Page → Database Mapping — Travel/Tour Management System

หน้า	URL	Controller	Tables (DB)
Login	`/auth/token/login`	`Auth\TokenLoginController@login`	`users` (center)
Login by JWT	`/auth/jwt`	`Auth\TokenLoginController@loginByJwt`	`users` (center)
Logout	`/logout`	`Auth\TokenLoginController@logout`	`users` (center)
Login Form	`/login`	`Auth\LoginController@showLoginForm`	—
Register	`/register`	`Auth\RegisterController`	`users` (center)
Forgot Password	`/password/reset`	`Auth\ForgotPasswordController`	`users`, `password_resets` (center)
Reset Password	`/password/reset/{token}`	`Auth\ResetPasswordController`	`users`, `password_resets` (center)
Two Factor Form	`/two-factor-form`	`Admin\HomeController@twoFactorLoginForm`	`users` (center)

2. Dashboard

หน้า	URL	Controller	Tables (DB)
Home	`/`	`Admin\HomeController@index`	`users`, `user_role_permits` (center)
Dashboard	`/dashboard`	`Admin\HomeController@dashboard`	`users`, `user_role_permits`, `booking`, `periods`, `series` (center)
Sales Dashboard	`/sales/dashboard`	`Admin\HomeController@salesDashboard`	`users`, `booking`, `periods`, `series`, `payments` (center)
Admin Dashboard	`/admin/dashboard`	`Admin\HomeController@AdminDashboard`	`users`, `booking`, `periods`, `series`, `payments`, `agency` (center)

3. User Management

หน้า	URL	Controller	Tables (DB)
รายการผู้ใช้	`/admin`	`Admin\AdminController@index`	`users`, `roles`, `user_role_permits` (center)
สร้างผู้ใช้	`/admin/create`	`Admin\AdminController@create`	`users`, `roles`, `country`, `user_country_permits` (center)
แก้ไขผู้ใช้	`/admin/{id}`	`Admin\AdminController@show`	`users`, `roles`, `user_role_permits`, `user_country_permits`, `country` (center)
เปลี่ยนรหัสผ่าน	`/admin/{id}/password`	`Admin\AdminController@password`	`users` (center)
บัญชีส่วนตัว	`/account`	`Admin\AccountController@index`	`users` (center)
แก้ไขโปรไฟล์	`/account` (PUT)	`Admin\AccountController@updateProfile`	`users` (center)
เปลี่ยนรหัสผ่าน	`/account/password`	`Admin\AccountController@password`	`users` (center)

4. Agency Management

4.1 Agency (ตัวแทน)

หน้า	URL	Controller	Tables (DB)
รายการเอเจนท์	`/customer/agency`	`Customer\Agency\AgencyController@index`	`agency`, `agency_company` (center)
สร้างเอเจนท์	`/customer/agency/create`	`Customer\Agency\AgencyController@create`	`agency`, `agency_company` (center)
แก้ไขเอเจนท์	`/customer/agency/{id}/edit`	`Customer\Agency\AgencyController@edit`	`agency`, `agency_company` (center)
Admin - รายการเอเจนท์	`/agency`	`Admin\Agency\AgencyController@index`	`agency`, `agency_company`, `agency_access_tokens` (center)
Admin - สร้างเอเจนท์	`/agency/create`	`Admin\Agency\AgencyController@create`	`agency`, `agency_company` (center)
Admin - แก้ไขเอเจนท์	`/agency/{id}/edit`	`Admin\Agency\AgencyController@edit`	`agency`, `agency_company`, `agency_access_tokens` (center)

4.2 Agency Company (บริษัทตัวแทน)

หน้า	URL	Controller	Tables (DB)
รายการบริษัท	`/customer/company`	`Customer\Company\CompanyController@index`	`agency_company`, `province`, `amphur`, `district` (center)
สร้างบริษัท	`/customer/company/create`	`Customer\Company\CompanyController@create`	`agency_company`, `province`, `amphur`, `district` (center)
แก้ไขบริษัท	`/customer/company/{id}/edit`	`Customer\Company\CompanyController@edit`	`agency_company`, `province`, `amphur`, `district` (center)
Admin - รายการบริษัท	`/company`	`Admin\Agency\CompanyController@index`	`agency_company` (center)
Admin - สร้างบริษัท	`/company/create`	`Admin\Agency\CompanyController@create`	`agency_company` (center)
Admin - แก้ไขบริษัท	`/company/{id}/edit`	`Admin\Agency\CompanyController@edit`	`agency_company`, `agency_access_tokens` (center)
API Token	`/company/{id}/api`	`Admin\Agency\CompanyController@editApi`	`agency_company`, `agency_access_tokens` (center)
Generate Token	`/company/{id}/generate`	`Admin\Agency\CompanyController@generate`	`agency_company`, `agency_access_tokens` (center)

4.3 Credit Shell

หน้า	URL	Controller	Tables (DB)
รายการ Credit Shell	`/agency/credit-shell`	`Admin\Agency\CreditShellController@index`	`agency_company`, `agency_credit_shells`, `booking` (center)
Credit รายบริษัท	`/agency/credit-shell/{id}/credit`	`Admin\Agency\CreditShellController@credit`	`agency_company`, `agency_credit_shells`, `booking`, `payments` (center)
หักเงิน	`/agency/credit-shell/{id}/deducts`	`Admin\Agency\CreditShellController@deducts`	`agency_credit_shells`, `booking`, `booking_deduct` (center)
คืนเงิน	`/agency/credit-shell/{id}/refunds`	`Admin\Agency\CreditShellController@refunds`	`agency_credit_shells`, `booking`, `booking_refund` (center)
ยกเลิก	`/agency/credit-shell/{id}/cancel`	`Admin\Agency\CreditShellController@bookingcanceled`	`agency_credit_shells`, `booking` (center)

5. Series/Tour Management

5.1 Series (ซีรีส์ทัวร์)

หน้า	URL	Controller	Tables (DB)
รายการซีรีส์	`/series-tour`	`Series\SeriesTourController@index`	`series`, `country`, `airline`, `tour_location_city` (center)
สร้างซีรีส์	`/series-tour/create`	`Series\SeriesTourController@create`	`series`, `country`, `airline`, `tour_location_city`, `land_operations` (center)
แก้ไขซีรีส์	`/series-tour/{id}/edit`	`Series\SeriesTourController@edit`	`series`, `country`, `airline`, `tour_location_city`, `series_programes`, `land_operations` (center)

5.2 Operation Tour

หน้า	URL	Controller	Tables (DB)
จัดการทัวร์	`/operation/tour`	`Operation\Tour\ManageTourController@index`	`series`, `periods`, `country`, `airline`, `tour_location_city`, `activity`, `land_operations`, `bus_lists` (center)
จัดการเพียเรียด	`/operation/tour/{id}/period`	`Operation\Tour\TourPeriodController@index`	`series`, `periods`, `bus_lists`, `booking`, `cost_seats` (center)
จัดการรถบัส	`/operation/tour/{id}/bus`	`Operation\Tour\BusController@index`	`bus_lists`, `periods`, `booking` (center)
จองในทัวร์	`/operation/tour/{id}/booking`	`Operation\Tour\TourBookingController@index`	`booking`, `booking_details`, `periods`, `bus_lists`, `agency`, `users`, `passport` (center)

6. Period Management

หน้า	URL	Controller	Tables (DB)
รายการเพียเรียด	`/series/period/{id}`	`Series\SeriesPerioController@index`	`series`, `periods`, `bus_lists`, `booking`, `room_details`, `series_programes` (center)
Booking ในเพียเรียด	`/period/{id}/booking`	`Period\PeriodBookingController@index`	`booking`, `booking_details`, `booking_list`, `periods`, `bus_lists`, `agency`, `agency_company`, `users`, `passport`, `room_details`, `payments` (center)
รายละเอียดเพียเรียด	`/period/{id}/detail`	`Period\PeriodBookingController@detail`	`periods`, `series`, `bus_lists`, `booking`, `cost_seats` (center)
Tagbag Export	`/period/{id}/tagbag`	`Period\PeriodBookingController@tagbag`	`booking`, `booking_list`, `room_details`, `periods`, `series`, `country` (center)

7. Booking Management

7.1 รายการ Booking

หน้า	URL	Controller	Tables (DB)
Booking ทั้งหมด	`/all-booking`	`Admin\AllBookingController@index`	`booking`, `periods`, `series`, `agency`, `users`, `bus_lists` (center)
Admin Booking List	`/booking`	`Admin\BookingController@index`	`booking`, `periods`, `series`, `country`, `tour_location_city`, `agency`, `users`, `passport`, `bankbook` (center)
Booking Filter	`/booking/fillter`	`Admin\BookingController@fillter`	เหมือน Booking List + filter conditions

7.2 สร้าง/แก้ไข Booking

หน้า	URL	Controller	Tables (DB)
สร้าง Booking	`/booking/create/{busId}`	`Booking\BookingController@create`	`booking`, `booking_details`, `bus_lists`, `periods`, `series`, `agency`, `agency_company`, `users`, `passport`, `room_details` (center)
แก้ไข Booking	`/booking/{id}/edit`	`Booking\BookingController@edit`	`booking`, `booking_details`, `booking_additionals`, `booking_list`, `bus_lists`, `periods`, `series`, `agency`, `agency_company`, `users`, `passport`, `room_details`, `payments` (center)
รายละเอียด Booking	`/booking/{id}`	`Booking\BookingController@show`	`booking`, `booking_details`, `booking_additionals`, `booking_history`, `booking_log`, `booking_activity`, `booking_guarantee`, `bus_lists`, `periods`, `series`, `agency`, `agency_company`, `users`, `passport`, `room_details`, `payments`, `receipts` (center)

7.3 Booking ของฉัน

หน้า	URL	Controller	Tables (DB)
My Booking	`/my-booking`	`Admin\Mybooking\MybookingController@index`	`booking`, `periods`, `series`, `bus_lists`, `users` (center)

7.4 Visa

หน้า	URL	Controller	Tables (DB)
ข้อมูลวีซ่า	API `/visa/{bookId}`	`Api\VisaController`	`booking`, `booking_visa_eus`, `booking_visa_rejects`, `booking_visa_reject_countries`, `booking_visa_old_passes`, `booking_visa_old_names`, `booking_visa_travelings` (center)

8. Payment & Finance

8.1 Payment

หน้า	URL	Controller	Tables (DB)
รายการชำระเงิน	`/payment`	`Admin\PaymentController@index`	`payments`, `booking`, `users`, `agency`, `bankbook`, `payment_methods`, `payment_transitions` (center)
แจ้งชำระเงิน	`/payment/notify`	`Payment\Notify\PaymentNotifyController@index`	`payments`, `booking`, `bankbook`, `agency` (center)
Bookbank	`/payment/bookbank`	`Payment\Bookbank\BookbankController@index`	`bankbook` (center)

8.2 Accumulated Credit

หน้า	URL	Controller	Tables (DB)
สะสมเครดิต	`/payment/accumulated`	`Payment\Accumulated\AccumulatedCreditController@index`	`agency_company`, `agency_credit_shells`, `booking`, `payments` (center)

8.3 Refund

หน้า	URL	Controller	Tables (DB)
คืนเงิน	`/payment/refund`	`Payment\Refund\RefundController@index`	`booking`, `booking_refund`, `payments`, `agency`, `agency_company` (center)

9. Invoice & Receipt

9.1 Invoice

หน้า	URL	Controller	Tables (DB)
รายการ Invoice	`/invoices`	`Admin\InvoicesController@index`	`invoices`, `invoices_request`, `booking`, `agency_company`, `prefix_numbers` (center)
Invoice Request	`/invoices/request`	`Admin\InvoicesController@requestList`	`invoices_request`, `booking`, `agency_company` (center)

9.2 Invoice Reports (Incentive DB)

หน้า	URL	Controller	Tables (DB)
Invoice Report	`/report/invoice`	`Admin\Invoice\InvoiceReportController@index`	`invoice_reports`, `invoice_report_details` (incentive), `booking`, `periods`, `users` (center)
Tax Invoice	`/report/invoice-tax`	`Admin\Invoice\InvoiceTaxReportController@index`	`invoice_tax_reports`, `invoice_tax_report_details` (incentive), `booking` (center)
Full Payment Invoice	`/report/invoice-full`	`Admin\Invoice\InvoiceFullPaymentController@index`	`invoice_full_payments`, `invoice_full_payment_details` (incentive), `booking` (center)

9.3 Receipt

หน้า	URL	Controller	Tables (DB)
ใบเสร็จ	`/receipt`	`Admin\ReceiptController@index`	`receipts`, `receipt_temporaries`, `receipt_temporary_details`, `booking`, `payments`, `agency_company` (center)

10. Incentive Quotations

หน้า	URL	Controller	Tables (DB)
รายการใบเสนอราคา	`/incentive`	`Admin\Incentives\IncentiveController@index`	`incentive_quotations`, `users` (incentive)
สร้างใบเสนอราคา	`/incentive/create`	`Admin\Incentives\IncentiveController@create`	`incentive_quotations`, `agency`, `agency_company`, `users` (incentive + center)
แก้ไขใบเสนอราคา	`/incentive/{id}/edit`	`Admin\Incentives\IncentiveController@edit`	`incentive_quotations`, `incentive_quotation_details`, `incentive_quotation_payments`, `incentive_quotation_payment_dues`, `incentive_quotation_flights`, `incentive_quotation_programs`, `incentive_quotation_prices`, `incentive_quotation_room_lists`, `incentive_quotation_passports` (incentive), `agency`, `agency_company` (center)
ชำระเงิน	`/incentive/{id}/payment`	`Admin\Incentives\IncentivePaymentController@index`	`incentive_quotations`, `incentive_quotation_payments`, `incentive_payment_cancels`, `bankbook` (incentive + center)
พาสปอร์ต	`/incentive/{id}/passport`	`Admin\Incentives\IncentivePassportController@index`	`incentive_quotations`, `incentive_quotation_passports` (incentive)

11. Ticket System

11.1 Series ตั๋ว

หน้า	URL	Controller	Tables (DB)
รายการซีรีส์ตั๋ว	`/ticket/series`	`Ticket\Series\SeriesTicketController@index`	`ticket`, `ticket_period`, `ticket_flight`, `ticket_airport`, `airline` (center)
สร้างซีรีส์ตั๋ว	`/ticket/series/create`	`Ticket\Series\SeriesTicketController@create`	`ticket`, `ticket_flight`, `airline`, `ticket_airport`, `ticket_type` (center)
แก้ไขซีรีส์ตั๋ว	`/ticket/series/{id}/edit`	`Ticket\Series\SeriesTicketController@edit`	`ticket`, `ticket_flight`, `ticket_period`, `ticket_goods`, `airline`, `ticket_airport` (center)

11.2 จัดการตั๋ว

หน้า	URL	Controller	Tables (DB)
จัดการตั๋ว	`/ticket/manage`	`Ticket\ManageTicket\ManageTicketController@index`	`ticket`, `ticket_period`, `ticket_booking`, `ticket_flight`, `airline` (center)
Pre-Sale ตั๋ว	`/ticket/presale`	`Ticket\PreSale\PreSaleTicketController@index`	`ticket`, `ticket_quotations`, `ticket_quotations_goods`, `ticket_quotations_payment`, `ticket_quotations_duepayment`, `ticket_quotations_namelist` (center)

11.3 Booking ตั๋ว

หน้า	URL	Controller	Tables (DB)
จองตั๋ว	`/ticket/booking/{id}`	`Ticket\ManageTicket\ManageTicketController@booking`	`ticket_booking`, `ticket_payment`, `ticket_payment_real`, `ticket_payment_other`, `ticket_payment_namelist`, `ticket_garanty`, `ticket_garanty_data`, `ticket_data`, `ticket`, `ticket_period`, `bankbook` (center)
ใบเสนอราคาตั๋ว	`/ticket/quotation/{id}`	(Ticket Quotation Controller)	`ticket_quotations`, `ticket_quotations_goods`, `ticket_quotations_payment`, `ticket_quotations_duepayment`, `ticket_quotations_namelist`, `ticket_quotations_document`, `ticket_quotation_lockseat` (center)

11.4 การเงินตั๋ว

หน้า	URL	Controller	Tables (DB)
ยกเลิกตั๋ว	`/ticket/{id}/cancel`	(Ticket Cancel Controller)	`ticket_booking`, `ticket_cancel_book`, `ticket_deduct_book` (center)
คืนเงินตั๋ว	`/ticket/{id}/refund`	(Ticket Refund Controller)	`ticket_booking`, `ticket_refund`, `ticket_taxrefund` (center)
เรียกคืน (Getback)	`/ticket/{id}/getback`	(Ticket Getback Controller)	`ticket_booking`, `ticket_getback`, `ticket_getback_due`, `ticket_getback_period` (center)
สรุปตั๋ว	`/ticket/{id}/summary`	(Ticket Summary Controller)	`ticket_booking`, `ticket_summary`, `ticket_invoice_history` (center)
แจ้งเตือนชำระ	`/ticket/payment-alert`	(Payment Alert Controller)	`ticket_payment_alert`, `ticket_payment_alert_log` (center)

12. Reports

12.1 Booking Reports

หน้า	URL	Controller	Tables (DB)
รายงานจองรายเดือน	`/report/booking-monthly`	`Reports\*`	`reports_booking_monthly`, `booking`, `periods`, `series` (center)
รายงานจองรายปี	`/report/booking-yearly`	`Reports\*`	`reports_booking_yearly_activity`, `booking` (center)
รายงานใบเสร็จ	`/report/receipt`	`Reports\ReportReceiptController@index`	`receipts`, `receipt_temporaries`, `booking`, `agency_company`, `approve`, `approve_detail` (center)

12.2 Period Reports

หน้า	URL	Controller	Tables (DB)
รายงานเพียเรียดรายเดือน	`/report/period-monthly`	`Reports\*`	`reports_periods_monthly`, `periods`, `series` (center)
รายงานเพียเรียดรายปี	`/report/period-yearly`	`Reports\*`	`reports_periods_yearly_activity`, `periods`, `series` (center)

12.3 Sales Reports

หน้า	URL	Controller	Tables (DB)
รายงานเซลล์รายวัน	`/report/sales-daily`	`Reports\*`	`sales_booking_daily`, `users`, `booking` (center)
รายงานส่งอีเมล	`/report/send-mails`	`Reports\*`	`send_mails_reports`, `booking_send_mails` (center)

12.4 Costing Reports

หน้า	URL	Controller	Tables (DB)
ต้นทุนเพียเรียด	`/report/costing/{periodId}`	(Costing Controller)	`costing_reports`, `costing_report_logs`, `periods`, `series`, `booking`, `cost_seats` (center)
ต้นทุนซีรีส์	`/report/costing-series/{seriesId}`	(Costing Series Controller)	`costing_series_reports`, `costing_series_summaries`, `costing_series_summary_details`, `costing_series_types`, `costing_series_type_lists`, `costing_series_type_list_details`, `costing_series_prices`, `series` (center)

12.5 Cost Seats

หน้า	URL	Controller	Tables (DB)
ต้นทุนที่นั่ง	`/cost-seat/{periodId}`	(CostSeat Controller)	`cost_seats`, `cost_seat_orders`, `cost_seat_order_details`, `cost_seat_averages`, `cost_seat_average_details`, `cost_seat_tip_details`, `cost_seat_logs`, `periods`, `series`, `bus_lists` (center)

13. Settings

หน้า	URL	Controller	Tables (DB)
หน้าตั้งค่า	`/setting`	`Admin\SettingController@index`	—
สายการบิน	`/setting/airline`	`Setting\AirlineController@index`	`airline` (center)
สร้างสายการบิน	`/setting/airline/create`	`Setting\AirlineController@create`	`airline` (center)
แก้ไขสายการบิน	`/setting/airline/{id}`	`Setting\AirlineController@edit`	`airline` (center)
เส้นทาง	`/setting/route`	`Setting\RouteController@index`	`tour_route_country_permit`, `country` (center)
สร้างเส้นทาง	`/setting/route/create`	`Setting\RouteController@create`	`tour_route_country_permit`, `country` (center)
ประเทศ	`/setting/country`	`Setting\CountryController@index`	`country` (center)
สร้างประเทศ	`/setting/country/create`	`Setting\CountryController@create`	`country` (center)
แก้ไขประเทศ	`/setting/country/{id}`	`Setting\CountryController@edit`	`country` (center)
เมือง	`/setting/city`	`Setting\CityController@index`	`tour_location_city`, `country` (center)
สร้างเมือง	`/setting/city/create`	`Setting\CityController@create`	`tour_location_city`, `country` (center)
ธนาคาร	`/setting/bank`	`Setting\BankController@index`	`bankbook` (center)
สร้างธนาคาร	`/setting/bank/create`	`Setting\BankController@create`	`bankbook` (center)
แก้ไขธนาคาร	`/setting/bank/{id}`	`Setting\BankController@edit`	`bankbook` (center)
Land Operation	`/setting/land-operation`	`Setting\LandOperationController@index`	`land_operations`, `country_land_operations`, `country` (center)
สร้าง Land Operation	`/setting/land-operation/create`	`Setting\LandOperationController@create`	`land_operations`, `country`, `country_land_operations` (center)
แก้ไข Land Operation	`/setting/land-operation/{id}`	`Setting\LandOperationController@edit`	`land_operations`, `country_land_operations`, `country` (center)
ประเทศ (Location)	`/setting/location/country`	`Setting\LocationCountryController@index`	`location_countries` (center)
เมือง (Location)	`/setting/location/city`	`Setting\LocationCountryController@city`	`location_cities`, `location_countries` (center)
โปรโมชั่น	`/setting/promotion`	`Setting\PromotionController@index`	`promotion_bookings`, `promotion_booking_details` (center)
สร้างโปรโมชั่น	`/setting/promotion/create`	`Setting\PromotionController@create`	`promotion_bookings` (center)
แก้ไขโปรโมชั่น	`/setting/promotion/{id}`	`Setting\PromotionController@edit`	`promotion_bookings`, `promotion_booking_details` (center)
Flashsale Banner	`/setting/flashsale`	`Setting\FlashsaleBannerController@index`	`flashsale_banners` (center)
Banner	`/setting/banner`	(Banner Controller)	`banners` (center)
รหัสรายงาน	`/setting/report-password`	(ReportPassword Controller)	`report_passwords` (center)
Prefix Number	`/setting/prefix`	(PrefixNumber Controller)	`prefix_numbers` (center)

14. Operations

14.1 Operation Booking

หน้า	URL	Controller	Tables (DB)
Operation Booking	`/operation/booking`	`Operation\Booking\OperationBookingController@index`	`booking`, `booking_details`, `periods`, `series`, `bus_lists`, `agency`, `agency_company`, `users`, `payments` (center)
Promotion Operation	`/operation/promotion`	`Operation\Booking\OperationPromotionController@index`	`promotion_bookings`, `promotion_booking_details`, `booking` (center)

14.2 Pre-Sale (ใบเสนอราคาทัวร์)

หน้า	URL	Controller	Tables (DB)
Pre-Sale	`/presale`	`Admin\PreSale\PreSaleController@index`	`incentive_quotations`, `users` (incentive)

15. Sales

หน้า	URL	Controller	Tables (DB)
Sales	`/sales`	`Sales\SalesController@index`	`users`, `booking`, `periods` (center)
Sales Team	`/sales/team`	`Sales\Team\SalesTeamController@index`	`users`, `booking`, `periods`, `agency` (center)
Event	`/event`	`Event\Event\EventController@index`	—
Event Email	`/event/email`	`Event\Email\EventEmailController@index`	`agency_email_masters` (center)

16. API Endpoints

16.1 Booking API

Endpoint	Controller	Tables (DB)
`GET /api/booking/{id}`	`Api\Booking\BookingController@getBookingById`	`booking`, `booking_details`, `booking_additionals`, `booking_list`, `booking_activity`, `booking_guarantee`, `bus_lists`, `periods`, `period_leader`, `series`, `agency`, `agency_company`, `users`, `passport`, `room_details`, `invoices_request` (center)
`POST /api/booking/checkout`	`Api\Booking\CheckoutController@checkout`	`booking`, `booking_details`, `bus_lists`, `periods`, `agency`, `payments`, `prefix_numbers` (center)
`GET /api/booking/{id}/payment`	`Api\Booking\BookingController@getPayment`	`payments`, `bankbook`, `payment_transitions` (center)
`POST /api/booking/{id}/passport`	`Api\Booking\BookingController@savePassport`	`passport`, `booking` (center)

16.2 Agency API

Endpoint	Controller	Tables (DB)
`GET /api/agency/search`	`Api\Agency\AgencyController@search`	`agency`, `agency_company` (center)
`GET /api/agency/company/search`	`Api\Agency\AgencyController@searchCompany`	`agency_company` (center)

16.3 Location API

Endpoint	Controller	Tables (DB)
`GET /api/location/province`	`Api\Location\LocationAddressController@province`	`province` (center)
`GET /api/location/amphur/{provinceId}`	`Api\Location\LocationAddressController@amphur`	`amphur` (center)
`GET /api/location/district/{amphurId}`	`Api\Location\LocationAddressController@district`	`district` (center)

16.4 Reports API

Endpoint	Controller	Tables (DB)
`GET /api/report/series`	`Admin\Api\Reports\*`	`series`, `periods`, `booking`, `country` (center)
`GET /api/report/tour`	`Admin\Api\Tour\*`	`series`, `periods`, `bus_lists`, `booking` (center)

16.5 Visa API

Endpoint	Controller	Tables (DB)
`POST /api/visa/{bookId}`	`Api\VisaController@store`	`booking_visa_eus`, `booking_visa_rejects`, `booking_visa_reject_countries`, `booking_visa_old_passes`, `booking_visa_old_names`, `booking_visa_travelings` (center)

Quotation (ใบเสนอราคา)

หน้า	URL	Controller	Tables (DB)
Invoice ใบเสนอราคา	`/quotation/invoice`	`Quotations\QuotationInvoiceController@index`	`invoice_reports`, `invoice_report_details` (incentive)
ชำระเงินใบเสนอราคา	`/quotation/invoice/{id}/payment`	`Quotations\QuotationInvoicePaymentController@index`	`invoice_reports`, `incentive_quotation_payments`, `bankbook` (incentive + center)

Approval System

หน้า	URL	Controller	Tables (DB)
อนุมัติ	(embedded in various pages)	(Approve logic)	`approve`, `approve_detail`, `approve_request` (center)

Summary: Cross-DB Pages

หน้าที่ดึงข้อมูลจาก ทั้ง 2 database พร้อมกัน:

หน้า	center tables	incentive tables
Invoice Report	booking, periods, users	invoice_reports, invoice_report_details
Tax Invoice	booking	invoice_tax_reports, invoice_tax_report_details
Full Payment Invoice	booking	invoice_full_payments, invoice_full_payment_details
Incentive Quotation (สร้าง/แก้ไข)	agency, agency_company, users	incentive_quotations + sub-tables
Incentive Payment	bankbook	incentive_quotations, incentive_quotation_payments
Pre-Sale	users	incentive_quotations
Quotation Invoice	—	invoice_reports, invoice_report_details
Quotation Payment	bankbook	invoice_reports, incentive_quotation_payments

Page

Page → Database Mapping — Travel/Tour Management System#

สารบัญ#

1. Authentication & Home#

2. Dashboard#

3. User Management#

4. Agency Management#

4.1 Agency (ตัวแทน)#

4.2 Agency Company (บริษัทตัวแทน)#

4.3 Credit Shell#

5. Series/Tour Management#

5.1 Series (ซีรีส์ทัวร์)#

5.2 Operation Tour#

6. Period Management#

7. Booking Management#

7.1 รายการ Booking#

7.2 สร้าง/แก้ไข Booking#

7.3 Booking ของฉัน#

7.4 Visa#

8. Payment & Finance#

8.1 Payment#

8.2 Accumulated Credit#

8.3 Refund#

9. Invoice & Receipt#

9.1 Invoice#

9.2 Invoice Reports (Incentive DB)#

9.3 Receipt#

10. Incentive Quotations#

11. Ticket System#

11.1 Series ตั๋ว#

11.2 จัดการตั๋ว#

11.3 Booking ตั๋ว#

11.4 การเงินตั๋ว#

12. Reports#

12.1 Booking Reports#

12.2 Period Reports#

12.3 Sales Reports#

12.4 Costing Reports#

12.5 Cost Seats#

13. Settings#

14. Operations#

14.1 Operation Booking#

14.2 Pre-Sale (ใบเสนอราคาทัวร์)#

15. Sales#

16. API Endpoints#

16.1 Booking API#

16.2 Agency API#

16.3 Location API#

16.4 Reports API#

16.5 Visa API#

Quotation (ใบเสนอราคา)#

Approval System#

Summary: Cross-DB Pages#

Page → Database Mapping — Travel/Tour Management System

สารบัญ

1. Authentication & Home

2. Dashboard

3. User Management

4. Agency Management

4.1 Agency (ตัวแทน)

4.2 Agency Company (บริษัทตัวแทน)

4.3 Credit Shell

5. Series/Tour Management

5.1 Series (ซีรีส์ทัวร์)

5.2 Operation Tour

6. Period Management

7. Booking Management

7.1 รายการ Booking

7.2 สร้าง/แก้ไข Booking

7.3 Booking ของฉัน

7.4 Visa

8. Payment & Finance

8.1 Payment

8.2 Accumulated Credit

8.3 Refund

9. Invoice & Receipt

9.1 Invoice

9.2 Invoice Reports (Incentive DB)

9.3 Receipt

10. Incentive Quotations

11. Ticket System

11.1 Series ตั๋ว

11.2 จัดการตั๋ว

11.3 Booking ตั๋ว

11.4 การเงินตั๋ว

12. Reports

12.1 Booking Reports

12.2 Period Reports

12.3 Sales Reports

12.4 Costing Reports

12.5 Cost Seats

13. Settings

14. Operations

14.1 Operation Booking

14.2 Pre-Sale (ใบเสนอราคาทัวร์)

15. Sales

16. API Endpoints

16.1 Booking API

16.2 Agency API

16.3 Location API

16.4 Reports API

16.5 Visa API

Quotation (ใบเสนอราคา)

Approval System

Summary: Cross-DB Pages