--
-- Host: localhost    Database: plexclou_petboss
-- ------------------------------------------------------


--
-- Table structure for table `account`
--

CREATE TABLE `account` (
  `account_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `id` varchar(128) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `type` varchar(128) DEFAULT NULL,
  `subtype` varchar(128) DEFAULT NULL,
  `is_header` varchar(10) DEFAULT NULL,
  `is_subheader` varchar(10) DEFAULT NULL,
  `is_bank` varchar(10) DEFAULT NULL,
  `cash_postable` varchar(10) DEFAULT NULL,
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `opening_balance` decimal(20,2) DEFAULT NULL,
  `balance` decimal(20,2) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `integrated` int(1) DEFAULT NULL,
  `integration_type` varchar(128) DEFAULT NULL,
  `default` int(1) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `normal_sign` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`account_id`)
) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account`
--

INSERT INTO `account` VALUES (1,'1540','Vehicles','Asset','Other Asset',NULL,NULL,NULL,NULL,'Vehicles',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(2,'1150','Undeposited Funds','Asset','Cash/Bank Account',NULL,NULL,'1','1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(3,'1541','Accumulated Depreciation on Vehicles','Asset','Other Asset',NULL,NULL,NULL,NULL,'Accumulated Depreciation on Vehicles',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(4,'1190','Petty Cash','Asset','Other Asset',NULL,NULL,NULL,NULL,'Petty Cash',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(5,'1531','Accumulated Depreciation on Computers','Asset','Other Asset',NULL,NULL,NULL,NULL,'Accumulated Depreciation on Computers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(6,'1120','Savings Account','Asset','Cash/Bank Account',NULL,NULL,'1','1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(7,'1530','Computers','Asset','Other Asset',NULL,NULL,NULL,NULL,'Computers',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(8,'1510','Furniture','Asset','Other Asset',NULL,NULL,NULL,NULL,'Furniture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(9,'1511','Accumulated Depreciation on Furniture','Asset','Other Asset',NULL,NULL,NULL,NULL,'Accumulated Depreciation on Furniture',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(10,'1310','Inventory','Asset','Other Asset',NULL,NULL,NULL,NULL,'Inventory',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(11,'1110','Checking Account','Asset','Cash/Bank Account',NULL,NULL,'1','1',NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(12,'1210','Accounts Receivable','Asset','Other Asset',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(13,'4210','Freight Collected','Income',NULL,NULL,NULL,NULL,NULL,'Freight Collected',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(14,'4110','General Sales','Income',NULL,NULL,NULL,NULL,NULL,'General Sales',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(15,'4910','Interest Revenue','Income',NULL,NULL,NULL,NULL,NULL,'Interest Revenue',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(16,'2110','Credit Card','Liability','Credit Card',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(17,'2210','Accounts Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(18,'2410','Sales Tax Collected','Liability','Other Liability',NULL,NULL,NULL,NULL,'Sales Tax Collected',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(19,'2390','Other Taxes Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Other Taxes Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(20,'2150','Loan','Liability','Loan Account',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(21,'2350','Payroll Tax Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Payroll Tax Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(22,'2340','Health Insurance Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Health Insurance Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(23,'2380','Income Tax Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Income Tax Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(24,'2330','Pension Contributions Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Pension Contributions Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(25,'2320','Wages Payable','Liability','Other Liability',NULL,NULL,NULL,NULL,'Wages Payable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(26,'6610','Motor Vehicle','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Motor Vehicle',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(27,'6410','Rent','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Rent',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(28,'6210','Wages and Salaries','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Wages and Salaries',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(29,'6510','Insurance','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Insurance',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(30,'6920','Depreciation','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Depreciation',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(31,'6300','Advertising and Promotion','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Advertising and Promotion',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(32,'6260','Subcontractors','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Subcontractors',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(33,'6310','Advertising','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Advertising',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(34,'6930','Income Tax Expense','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Income Tax Expense',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(35,'6110','General Products Purchased','Expense','Cost of Sales',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(36,'6650','Repairs & Maintenance','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Repairs & Maintenance',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(37,'6320','Website','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Website',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(38,'6910','Interest Expense','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Interest Expense',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(39,'6430','Telephone and Internet','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Telephone and Internet',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(40,'6550','Legal','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,'Legal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(41,'6420','Office Expenses','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Office Expenses',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(42,'6580','Accounting','Expense','Operating Expense',NULL,NULL,NULL,NULL,'Accounting',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(43,'6190','Freight Paid','Expense','Operating Expense',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(44,'6350','Promotions','Expense','Non-Operating Expense',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Debit'),(45,'3999','Historical Balancing','Equity','Equity',NULL,NULL,NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(46,'3030','Money Withdrawn','Equity','Equity',NULL,NULL,NULL,NULL,'Money Withdrawn',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(47,'3020','Money Invested','Equity','Equity',NULL,NULL,NULL,NULL,'Money Invested',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(48,'3040','Dividends Paid','Equity','Equity',NULL,NULL,NULL,NULL,'Dividends Paid',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit'),(49,'3010','Issued Capital','Equity','Equity',NULL,NULL,NULL,NULL,'Issued Capital',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Credit');

--
-- Table structure for table `account_transactions`
--

CREATE TABLE `account_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `journal` varchar(128) DEFAULT NULL,
  `account_id` varchar(128) DEFAULT '',
  `account_name` varchar(128) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `type` varchar(10) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `reference` varchar(128) DEFAULT NULL,
  `description` varchar(128) DEFAULT NULL,
  `notes` varchar(128) DEFAULT NULL,
  `group` varchar(128) DEFAULT NULL,
  `applied` varchar(128) DEFAULT NULL,
  `applied_date` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `account_transactions`
--


--
-- Table structure for table `additional`
--

CREATE TABLE `additional` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `checkin_id` int(11) DEFAULT NULL,
  `receipt_id` int(11) DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(128) DEFAULT NULL,
  `item_type` varchar(128) DEFAULT NULL,
  `item_desc` varchar(255) DEFAULT NULL,
  `discount` varchar(128) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `price_per_unit` decimal(20,2) DEFAULT NULL,
  `price` decimal(20,2) DEFAULT NULL,
  `paid` int(1) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  `paid_date` datetime DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=273 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `additional`
--

INSERT INTO `additional` VALUES (174,'16769680203670',NULL,383,NULL,7,39,'Grooming Kitten - Short Hair','Grooming',NULL,NULL,1,25.00,25.00,NULL,10016,NULL,'2023-02-21 00:00:00'),(175,'16772953612870',NULL,384,NULL,32,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg','Addon',NULL,NULL,1,85.00,85.00,NULL,10016,NULL,'2023-02-25 00:00:00'),(176,'16772973978240',NULL,NULL,NULL,NULL,10,'Grooming Adult - Long Hair (simba)','Grooming',NULL,NULL,1,60.00,60.00,NULL,NULL,NULL,NULL),(177,'16772980494710',NULL,NULL,NULL,NULL,55,'Nutrilick','Cat Snacks',NULL,NULL,10,3.30,33.00,NULL,NULL,NULL,NULL),(178,'16772978839522',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair (poppy)','Grooming',NULL,NULL,1,30.00,30.00,NULL,NULL,NULL,NULL),(179,'16772980494710',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair (poppy)','Grooming',NULL,NULL,1,30.00,30.00,NULL,NULL,NULL,NULL),(180,'16773091377487',NULL,393,NULL,43,44,'Ubat Kutu / Ubat Cacing - Above 4kg','Addon',NULL,NULL,1,65.00,65.00,NULL,10016,NULL,'2023-02-25 00:00:00'),(181,'16775421844424',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair ()','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-02-28 07:56:24'),(182,'16775443638038',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-02-28 08:32:43'),(184,'16775443638038',NULL,400,NULL,12,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg - Bulan','Addon',NULL,NULL,1,85.00,85.00,NULL,10016,NULL,'2023-02-28 00:00:00'),(185,'16775866322307',NULL,401,NULL,43,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg - Bulan','Addon',NULL,NULL,1,85.00,85.00,NULL,10016,NULL,'2023-02-28 00:00:00'),(186,'16775866322307',NULL,401,NULL,43,2,'Discount - ','Discount',NULL,NULL,1,-20.00,-20.00,NULL,10016,NULL,'2023-02-28 00:00:00'),(187,'16777277909002',NULL,404,NULL,2,46,'Vaccine / Ubat Kutu / Ubat Cacing - Below 4kg - bulan','Addon',NULL,NULL,1,75.00,75.00,NULL,10016,NULL,'2023-03-02 00:00:00'),(189,'16789348721005',NULL,NULL,NULL,NULL,49,'Lion Cut - Short Hair (BULAN)','Grooming',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,NULL),(190,'16790115805068',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-17 08:06:20'),(191,'16792467043180',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 01:25:04'),(192,'16792467043180',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (test)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 01:25:04'),(193,'16792468388409',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 01:27:18'),(194,'16792468388409',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (test)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 01:27:18'),(195,'16792799261499',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 10:38:46'),(196,'16792800259708',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 10:40:25'),(197,'16792802282352',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 10:43:48'),(198,'16792805801205',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 10:49:40'),(199,'16792809859891',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (BULAN)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-20 10:56:25'),(200,'16793054459370',NULL,NULL,NULL,NULL,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg','Addon',NULL,NULL,1,85.00,85.00,NULL,NULL,NULL,NULL),(201,'16793054459370',NULL,NULL,NULL,NULL,46,'Vaccine / Ubat Kutu / Ubat Cacing - Below 4kg','Addon',NULL,NULL,1,75.00,75.00,NULL,NULL,NULL,NULL),(203,'16795435597631',NULL,422,NULL,42,44,'Ubat Kutu / Ubat Cacing - Above 4kg - ','Addon',NULL,NULL,1,65.00,65.00,NULL,10016,NULL,'2023-03-23 00:00:00'),(206,'16798037257320',NULL,NULL,NULL,NULL,44,'Ubat Kutu / Ubat Cacing - Above 4kg (Bulan)','Addon',NULL,NULL,1,65.00,65.00,NULL,NULL,NULL,NULL),(205,'16801225239438',NULL,423,NULL,2,9,'Grooming Adult - Short Hair - Ebi','Grooming',NULL,NULL,1,50.00,50.00,NULL,10016,NULL,'2023-03-23 00:00:00'),(207,'16801225239438',NULL,NULL,NULL,NULL,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg','Addon',NULL,NULL,1,85.00,85.00,NULL,NULL,NULL,NULL),(208,'16801225239438',NULL,428,NULL,1,40,'Grooming Kitten - Long Hair - Bulan','Grooming',NULL,NULL,1,35.00,35.00,NULL,10016,NULL,'2023-03-29 00:00:00'),(209,'16800779486416',NULL,NULL,NULL,NULL,43,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg','Addon',NULL,NULL,1,85.00,85.00,NULL,NULL,NULL,NULL),(210,'16800789033036',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(212,'16801265535888',NULL,NULL,NULL,NULL,39,'Grooming Kitten - Short Hair - Array','Grooming',NULL,NULL,1,25.00,25.00,NULL,NULL,NULL,NULL),(213,'16801265535888',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair - Array','Grooming',NULL,NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(214,'16801265535888',NULL,NULL,NULL,NULL,47,'Neutering - Female Cat - Array','Addon',NULL,NULL,1,160.00,160.00,NULL,NULL,NULL,NULL),(215,'16801266178168',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming',NULL,NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(216,'16801266178168',NULL,NULL,NULL,NULL,48,'Neutering - Male Cat - Bulan','Addon',NULL,NULL,1,100.00,100.00,NULL,NULL,NULL,NULL),(217,'16801272126108',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(225,'16801326988588',NULL,NULL,NULL,NULL,39,'Grooming Kitten - Short Hair','Grooming','',NULL,1,25.00,25.00,NULL,NULL,NULL,NULL),(226,'16801326988588',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(227,'16801330827523',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','',NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(228,'16801330827523',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','',NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(229,'16801334323453',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','',NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(230,'16801334323453',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(231,'16801360784613',NULL,NULL,NULL,NULL,39,'Grooming Kitten - Short Hair','Grooming','',NULL,1,25.00,25.00,NULL,NULL,NULL,NULL),(232,'16801360784613',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(233,'16801339347936',NULL,NULL,NULL,NULL,39,'Grooming Kitten - Short Hair','Grooming','',NULL,1,25.00,25.00,NULL,NULL,NULL,NULL),(234,'16801339347936',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(235,'16801227369174',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','tesst',NULL,1,30.00,30.00,NULL,10016,NULL,'2023-03-30 00:00:00'),(236,'16801352984590',NULL,NULL,NULL,NULL,48,'Neutering - Male Cat','Addon','Bulan',NULL,1,100.00,100.00,NULL,NULL,NULL,NULL),(237,'16801359749474',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(238,'16801359749474',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(239,'16801601799070',NULL,NULL,NULL,NULL,49,'Lion Cut - Short Hair','Grooming','',NULL,1,100.00,100.00,NULL,NULL,NULL,NULL),(240,'16801602241913',NULL,NULL,NULL,NULL,39,'Grooming Kitten - Short Hair','Grooming','',NULL,1,25.00,25.00,NULL,NULL,NULL,NULL),(241,'16801604213654',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','',NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(242,'16801608101990',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(243,'16801612699843',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(244,'16801614168468',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(245,'16801615815966',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','',NULL,1,35.00,35.00,NULL,NULL,NULL,NULL),(246,'16801618017261',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(247,'16801618164064',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (Bulan)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-30 15:36:56'),(250,'16801618017261',NULL,NULL,NULL,NULL,47,'Neutering - Female Cat','Addon','','5%',1,160.00,152.00,NULL,10016,NULL,'2023-03-30 00:00:00'),(251,'16801656779232',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','damn it','',1,35.00,35.00,NULL,NULL,NULL,NULL),(252,'16801656779232',NULL,NULL,NULL,NULL,47,'Neutering - Female Cat','Addon','bulanoo','10%',1,160.00,144.00,NULL,10016,NULL,'2023-03-30 00:00:00'),(253,'16801768331238',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(254,'16801768331238',NULL,NULL,NULL,NULL,10,'Grooming Adult - Long Hair','Grooming','',NULL,1,60.00,60.00,NULL,NULL,NULL,NULL),(255,'16801769078013',NULL,NULL,NULL,NULL,47,'Neutering - Female Cat','Addon','Kucing','10%',1,160.00,144.00,NULL,10016,NULL,'2023-03-30 00:00:00'),(256,'16802117157828',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair (Bulan)','Grooming',NULL,NULL,1,50.00,50.00,NULL,NULL,NULL,'2023-03-31 05:28:35'),(257,'16802141794690',NULL,NULL,NULL,NULL,10,'Grooming Adult - Long Hair','Grooming','',NULL,1,60.00,60.00,NULL,NULL,NULL,NULL),(258,'16802143636383',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(259,'16802143983187',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(260,'16802144098708',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(261,'16802144293201',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(262,'16802144433471',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(263,'16802144599549',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(264,'16802144922506',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(265,'16802145782156',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(266,'16802146778841',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(267,'16802147535021',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(268,'16802147633616',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(269,'16802213694412',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','',NULL,1,50.00,50.00,NULL,NULL,NULL,NULL),(270,'16802213694412',NULL,NULL,NULL,NULL,10,'Grooming Adult - Long Hair','Grooming','',NULL,1,60.00,60.00,NULL,NULL,NULL,NULL),(271,'16803066376933',NULL,NULL,NULL,NULL,9,'Grooming Adult - Short Hair','Grooming','','',1,50.00,50.00,NULL,10016,NULL,'2023-04-01 00:00:00'),(272,'16803885954794',NULL,NULL,NULL,NULL,40,'Grooming Kitten - Long Hair','Grooming','','',1,30.00,30.00,NULL,10016,NULL,'2023-04-02 00:00:00');

--
-- Table structure for table `agents`
--

CREATE TABLE `agents` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `on_behalf` int(11) DEFAULT NULL,
  `registration_number` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `contact_person` varchar(128) DEFAULT NULL,
  `contact_number` varchar(128) DEFAULT NULL,
  `address` text,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agents`
--


--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `code` varchar(10) DEFAULT NULL,
  `description` text,
  `image` text,
  `image2` text,
  `image3` text,
  `pax` int(11) DEFAULT NULL,
  `online_booking_allotment` int(11) DEFAULT NULL,
  `pkey` varchar(255) DEFAULT NULL,
  `type` varchar(30) DEFAULT NULL,
  `first_free` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (31,'Lion Cut',NULL,'!! Lion Cut\r\n!! Nail cutting\r\n!! Ear, eye, nose cleaning\r\n!! Coat brushing\r\n!! Degrease syampoo\r\n!! Premium bath syampoo\r\n!! Blow-dry\r\n!! Touch-up\r\n!! Trimming','https://booking.nanacatz.com/assets/Screenshot_2022-12-02_at_1.28.26_PM.png',NULL,NULL,1,1,NULL,'Grooming',0,7),(26,'Standard Room','STD','!! Room cleaned daily\r\n!! 2 times play session daily\r\n!! Includes cat food and cat litter\r\n!! 24/7 Air-conditioned\r\n!! Send cat\'s video to owner upon request','https://booking.nanacatz.com/assets/std-room-alt.jpg',NULL,NULL,2,35,NULL,'Room',2,1),(28,'Presidential Room','PRE','!! Room cleaned daily\r\n!! 2 times play session daily\r\n!! Includes cat food and cat litter\r\n!! 24/7 Air-conditioned\r\n!! Send cat\'s video to owner upon request','https://booking.nanacatz.com/assets/presidential-room.jpg',NULL,NULL,9,1,NULL,'Room',7,4),(29,'Grooming Adult',NULL,'!! Nail cutting\r\n!! Ear, eye, nose cleaning\r\n!! Coat brushing\r\n!! Degrease syampoo\r\n!! Premium bath syampoo\r\n!! Blow-dry\r\n!! Touch-up\r\n!! Trimming','https://booking.nanacatz.com/assets/grooming1.jpg','https://booking.nanacatz.com/assets/grooming3.jpg',NULL,0,0,NULL,'Grooming',NULL,5),(30,'Grooming Kitten',NULL,'!! Nail cutting\r\n!! Ear, eye, nose cleaning\r\n!! Coat brushing\r\n!! Degrease syampoo\r\n!! Premium bath syampoo\r\n!! Blow-dry\r\n!! Touch-up\r\n!! Trimming','https://booking.nanacatz.com/assets/grooming4.jpg','https://booking.nanacatz.com/assets/grooming2.jpg',NULL,0,0,NULL,'Grooming',NULL,6),(25,'Deluxe Room','DLX','!! Room cleaned daily\r\n!! 2 times play session daily\r\n!! Includes cat food and cat litter\r\n!! 24/7 Air-conditioned\r\n!! Send cat\'s video to owner upon request','https://booking.nanacatz.com/assets/mansion-room-2.jpg','https://booking.nanacatz.com/assets/mansion-room.jpg',NULL,5,13,NULL,'Room',2,2),(24,'Premium Room','PRM','!! Room cleaned daily\r\n!! 2 times play session daily\r\n!! Includes cat food and cat litter\r\n!! 24/7 Air-conditioned\r\n!! Send cat\'s video to owner upon request','https://booking.nanacatz.com/assets/royal-room.jpg',NULL,NULL,5,5,NULL,'Room',4,3);

--
-- Table structure for table `checkins`
--

CREATE TABLE `checkins` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(128) DEFAULT NULL,
  `group` varchar(128) DEFAULT NULL,
  `pets` varchar(255) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `reservation_id` int(11) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_in_time` time DEFAULT NULL,
  `check_in_by` int(11) DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `check_out_time` time DEFAULT NULL,
  `check_out_by` int(11) DEFAULT NULL,
  `actual_check_out` datetime DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `room_number` varchar(40) DEFAULT NULL,
  `guest_id` int(11) DEFAULT NULL,
  `transfer_room` int(11) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `regular_rate` decimal(20,2) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `key_deposit` decimal(20,2) DEFAULT NULL,
  `tourism_tax` decimal(20,2) DEFAULT NULL,
  `remarks` text,
  `nights` int(11) DEFAULT NULL,
  `regular_day_charge` decimal(20,2) DEFAULT NULL,
  `day_charge` decimal(20,2) DEFAULT NULL,
  `single` int(11) DEFAULT NULL,
  `single_rate` decimal(20,2) DEFAULT NULL,
  `single_rate_first` decimal(20,2) DEFAULT NULL,
  `rate_breakdown` text,
  `regular_rate_breakdown` text,
  `description` text,
  `discount` varchar(128) DEFAULT NULL,
  `notes` text,
  `foc` int(1) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `category` varchar(255) DEFAULT NULL,
  `category_name` varchar(255) DEFAULT NULL,
  `channel_id` varchar(255) DEFAULT NULL,
  `channel` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `void` int(11) DEFAULT NULL,
  `seen` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=481 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `checkins`
--

INSERT INTO `checkins` VALUES (372,NULL,'16768578868624','[423,424,425]',NULL,10001,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,122,'99',1001,NULL,'Cancelled',120.00,120.00,NULL,NULL,NULL,1,NULL,NULL,1,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 09:51:26',10016,NULL,NULL),(373,NULL,'16768578868624','[423,424,425]',NULL,10001,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',90.00,90.00,NULL,NULL,NULL,1,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 09:51:26',10016,NULL,NULL),(374,'Boarding','16768585782752',NULL,NULL,10002,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:02:58',10016,NULL,NULL),(375,'Boarding','16768585782752',NULL,NULL,10002,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,101,'41',1001,NULL,'Cancelled',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:02:58',10016,NULL,NULL),(376,NULL,'16768586633916','[426,427,428]',NULL,10003,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,111,'62',1001,NULL,'Cancelled',100.00,100.00,NULL,NULL,NULL,1,NULL,NULL,1,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:04:23',10016,NULL,NULL),(377,NULL,'16768586633916','[426,427,428]',NULL,10003,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,105,'45',1001,NULL,'Cancelled',80.00,80.00,NULL,NULL,NULL,1,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:04:23',10016,NULL,NULL),(378,NULL,'16768599845812','[{\"id\":\"420\",\"guest_id\":1001,\"name\":\"Bulan\",\"breed\":null,\"gender\":\"Male\",\"coat_type\":\"Shorthair\",\"neutered\":\"1\",\"color\":null,\"dob\":null,\"vaccine_date\":null,\"weight\":\"5.00\",\"photo\":null,\"vcard\":null,\"behavior\":null,\"remarks\":null,\"petID\":\"420\"},{\"id\":\"422\"',NULL,10004,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,110,'61',1001,NULL,'Cancelled',100.00,100.00,NULL,NULL,NULL,1,NULL,NULL,1,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:26:24',10016,NULL,NULL),(379,NULL,'16768599845812','[{\"id\":\"421\",\"guest_id\":1001,\"name\":\"Ebi\",\"breed\":null,\"gender\":\"Male\",\"coat_type\":\"Longhair\",\"neutered\":\"1\",\"color\":null,\"dob\":null,\"vaccine_date\":null,\"weight\":\"6.00\",\"photo\":null,\"vcard\":null,\"behavior\":null,\"remarks\":null,\"petID\":\"421\"}]',NULL,10004,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,105,'45',1001,NULL,'Cancelled',80.00,80.00,NULL,NULL,NULL,1,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:26:24',10016,NULL,NULL),(380,NULL,'16768605668593','[\"420\",\"421\"]',NULL,10005,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,111,'62',1001,NULL,'Reserved',100.00,100.00,NULL,NULL,NULL,1,NULL,NULL,1,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:36:06',10016,NULL,NULL),(381,NULL,'16768605668593','[\"422\"]',NULL,10005,'2023-02-20',NULL,NULL,'2023-02-21',NULL,NULL,NULL,106,'46',1001,NULL,'Reserved',80.00,80.00,NULL,NULL,NULL,1,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-20 10:36:06',10016,NULL,NULL),(382,NULL,'16769416035763','[\"420\"]',NULL,10006,'2023-02-21',NULL,NULL,'2023-02-22',NULL,NULL,NULL,108,'48',1001,NULL,'Reserved',80.00,80.00,NULL,NULL,NULL,1,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-21 09:06:43',NULL,NULL,NULL),(383,NULL,'16769680203670','[429,430]',10002,10007,'2023-02-21',NULL,NULL,'2023-02-23','16:40:35',10016,NULL,67,'7',1002,NULL,'Checked Out',60.00,90.00,NULL,NULL,NULL,2,NULL,NULL,1,20.00,NULL,NULL,NULL,'',NULL,'\nEXTENDED FROM 2023-02-22 TO 2023-02-23',NULL,NULL,'26',NULL,NULL,NULL,'2023-02-21 16:27:00',NULL,NULL,NULL),(384,NULL,'16772953612870','[431]',10003,10008,'2023-02-25',NULL,NULL,'2023-02-28','12:16:47',10016,NULL,92,'32',1003,NULL,'Checked Out',60.00,120.00,NULL,NULL,NULL,3,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,'\nEXTENDED FROM 2023-02-26 TO 2023-02-27\nEXTENDED FROM 2023-02-27 TO 2023-02-28',NULL,NULL,'26',NULL,NULL,NULL,'2023-02-25 11:22:41',NULL,NULL,NULL),(385,'Boarding','16772967802781',NULL,NULL,10009,'2023-02-25',NULL,NULL,'2023-02-26',NULL,NULL,NULL,100,'40',1001,NULL,'Reserved',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-25 11:46:20',10016,NULL,NULL),(386,'Boarding','16772971846199',NULL,10005,10010,'2023-02-25',NULL,NULL,'2023-02-27','11:59:30',10016,NULL,101,'41',1004,NULL,'Checked Out',200.00,200.00,25.00,NULL,NULL,2,NULL,NULL,1,20.00,40.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-25 11:53:04',10016,NULL,NULL),(387,'Grooming','16772973978240',NULL,10004,10011,'2023-02-25',NULL,NULL,'2023-02-25','11:57:52',10016,NULL,125,'2:00PM',1004,NULL,'Checked Out',0.00,0.00,25.00,NULL,NULL,1,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-25 11:56:37',10016,NULL,NULL),(388,'Boarding','16772980494710',NULL,10006,10012,'2023-02-25',NULL,NULL,'2023-02-26','12:07:29',10016,NULL,108,'48',1005,NULL,'Checked Out',80.00,60.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,'FREE Stay',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-25 12:03:08',10016,NULL,NULL),(389,'Grooming','16772978839522',NULL,NULL,10013,'2023-02-26',NULL,NULL,'2023-02-26',NULL,NULL,NULL,124,'12:30PM',1005,NULL,'Reserved',0.00,0.00,25.00,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-25 12:04:43',10016,NULL,NULL),(390,'Grooming','16772980494710',NULL,10006,10014,'2023-02-25',NULL,NULL,'2023-02-25','12:07:29',10016,NULL,124,'12:30PM',1005,NULL,'Checked Out',0.00,0.00,25.00,NULL,NULL,1,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-25 12:06:32',10016,NULL,NULL),(391,NULL,'16773079424582','[435]',NULL,10015,'2023-02-25',NULL,NULL,'2023-02-26',NULL,NULL,NULL,66,'6',1006,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26',NULL,NULL,NULL,'2023-02-25 14:52:22',10016,NULL,NULL),(392,'Boarding','16773091377487',NULL,10007,10016,'2023-02-25',NULL,NULL,'2023-02-26','20:30:38',10016,NULL,102,'42',1001,NULL,'Checked Out',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-25 15:12:17',10016,NULL,NULL),(393,'Boarding','16773091377487',NULL,10007,10016,'2023-02-25',NULL,NULL,'2023-02-26','20:30:38',10016,NULL,103,'43',1001,NULL,'Checked Out',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-25 15:12:17',10016,NULL,NULL),(394,'Boarding','16774619485307',NULL,NULL,10017,'2023-02-27',NULL,NULL,'2023-02-28',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',110.00,110.00,25.00,NULL,NULL,1,NULL,NULL,2,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-27 09:39:08',10016,NULL,NULL),(395,'Boarding','16774645125637',NULL,NULL,10018,'2023-02-27',NULL,NULL,'2023-02-28',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-27 10:21:52',10016,NULL,NULL),(396,'Boarding','16774646947417','[\"420\",\"421\",\"422\",\"422\",\"422\"]',NULL,10019,'2023-02-27',NULL,NULL,'2023-02-28',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',110.00,110.00,25.00,NULL,NULL,1,NULL,NULL,2,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-27 10:24:54',10016,NULL,NULL),(397,'Boarding','16774691653398','[\"421\",\"420\"]',NULL,10020,'2023-02-27',NULL,NULL,'2023-02-28',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-27 11:39:25',10016,NULL,NULL),(398,'Boarding','16774691653398','[\"422\"]',NULL,10020,'2023-02-27',NULL,NULL,'2023-02-28',NULL,NULL,NULL,101,'41',1001,NULL,'Cancelled',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-27 11:39:25',10016,NULL,NULL),(399,'Grooming','16775421844424','[437]',NULL,10021,'2023-02-28',NULL,NULL,'2023-02-28',NULL,NULL,NULL,123,'11:00AM',1007,NULL,'Cancelled',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-28 07:56:24',10016,NULL,NULL),(400,'Grooming','16775443638038','[438]',NULL,10022,'2023-02-28',NULL,NULL,'2023-02-28',NULL,NULL,NULL,124,'12:30PM',1008,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-28 08:32:43',10016,NULL,NULL),(401,NULL,'16775866322307','[439]',10009,10023,'2023-02-28',NULL,NULL,'2023-03-03','20:33:25',10016,NULL,103,'43',1009,NULL,'Checked Out',80.00,240.00,NULL,NULL,NULL,3,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,'\nEXTENDED FROM 2023-03-01 TO 2023-03-03',NULL,NULL,'25',NULL,NULL,NULL,'2023-02-28 20:17:12',10016,NULL,NULL),(402,'Boarding','16792806298102','[\"422\",\"421\"]',10012,10024,'2023-02-28',NULL,NULL,'2023-03-01','10:50:29',10016,NULL,102,'42',1001,NULL,'Checked Out',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-28 20:36:47',10016,NULL,NULL),(403,'Boarding','16792806298102','[\"420\"]',10012,10024,'2023-02-28',NULL,NULL,'2023-03-01','10:50:29',10016,NULL,103,'43',1001,NULL,'Checked Out',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-02-28 20:36:47',10016,NULL,NULL),(404,NULL,'16777277909002','[440]',10011,10025,'2023-03-02',NULL,NULL,'2023-03-04','11:43:52',10016,NULL,62,'2',1010,NULL,'Checked Out',60.00,90.00,NULL,NULL,NULL,2,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,'\nEXTENDED FROM 2023-03-03 TO 2023-03-04',NULL,NULL,'26',NULL,NULL,NULL,'2023-03-02 11:29:50',NULL,NULL,NULL),(405,'Boarding','16792806298102','[\"421\"]',10012,10026,'2023-03-02',NULL,NULL,'2023-03-06','10:50:29',10016,NULL,100,'40',1001,NULL,'Checked Out',320.00,320.00,25.00,NULL,NULL,4,NULL,NULL,0,40.00,80.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-02 11:45:42',10016,NULL,NULL),(406,'Boarding','16792806298102','[\"422\"]',10012,10026,'2023-03-02',NULL,NULL,'2023-03-06','10:50:29',10016,NULL,101,'41',1001,NULL,'Checked Out',320.00,320.00,25.00,NULL,NULL,4,NULL,NULL,0,40.00,80.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-02 11:45:42',10016,NULL,NULL),(407,'Boarding','16789247175927','[\"440\"]',NULL,10027,'2023-03-16',NULL,NULL,'2023-03-17',NULL,NULL,NULL,100,'40',1010,NULL,'Reserved',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-16 07:58:37',10016,NULL,NULL),(408,'Grooming','16789348721005',NULL,NULL,10028,'2023-03-16',NULL,NULL,'2023-03-16',NULL,NULL,NULL,123,'11:00AM',1010,NULL,'Reserved',0.00,0.00,25.00,NULL,NULL,1,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-16 10:47:52',10016,NULL,NULL),(409,NULL,'16790106198636','[\"420\"]',NULL,10029,'2023-03-17',NULL,NULL,'2023-03-18',NULL,NULL,NULL,71,'11',1001,NULL,'Hold',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26',NULL,NULL,NULL,'2023-03-17 07:50:19',10016,NULL,NULL),(410,NULL,'16790106572679','[\"420\"]',NULL,10030,'2023-03-17',NULL,NULL,'2023-03-18',NULL,NULL,NULL,82,'22',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26',NULL,NULL,NULL,'2023-03-17 07:50:57',10016,NULL,NULL),(411,NULL,'16790107398509','[\"420\"]',NULL,10031,'2023-03-15',NULL,NULL,'2023-03-17',NULL,NULL,NULL,66,'6',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,2,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26',NULL,NULL,NULL,'2023-03-17 07:52:19',10016,NULL,NULL),(412,NULL,'16790108793709','[\"420\"]',NULL,10032,'2023-03-17',NULL,NULL,'2023-03-18',NULL,NULL,NULL,83,'23',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26',NULL,NULL,NULL,'2023-03-17 07:54:39',10016,NULL,NULL),(413,NULL,'16790112104384','[\"420\"]',NULL,10033,'2023-03-17',NULL,NULL,'2023-03-18',NULL,NULL,NULL,66,'6',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26',NULL,NULL,NULL,'2023-03-17 08:00:10',10016,NULL,NULL),(414,'Grooming','16790115805068','[443]',NULL,10034,'2023-03-17',NULL,NULL,'2023-03-17',NULL,NULL,NULL,124,'12:30PM',1001,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-17 08:06:20',10016,NULL,NULL),(415,'Grooming','16792802282352','[450]',NULL,10039,'2023-03-20',NULL,NULL,'2023-03-20',NULL,NULL,NULL,124,'12:30PM',1018,NULL,'Cancelled',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29',NULL,NULL,NULL,'2023-03-20 10:43:48',10016,NULL,NULL),(416,'Grooming','16792805801205','[451]',NULL,10040,'2023-03-20',NULL,NULL,'2023-03-20',NULL,NULL,NULL,124,'12:30PM',1019,NULL,'Cancelled',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-20 10:49:40',10016,NULL,NULL),(417,'Grooming','16792809859891','[452]',NULL,10041,'2023-03-20',NULL,NULL,'2023-03-20',NULL,NULL,NULL,125,'2:00PM',1020,NULL,'Reserved',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-20 10:56:25',10016,NULL,NULL),(418,NULL,'16793051505194','[\"420\"]',NULL,10042,'2023-03-20',NULL,NULL,'2023-03-21',NULL,NULL,NULL,74,'14',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-20 17:39:10',10016,NULL,NULL),(419,NULL,'16793054459370','[\"420\"]',NULL,10043,'2023-03-20',NULL,NULL,'2023-03-21',NULL,NULL,NULL,69,'9',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-20 17:44:05',10016,NULL,NULL),(420,NULL,'16795429306680','[\"421\"]',10013,10044,'2023-03-23',NULL,NULL,'2023-03-27','11:55:39',10016,NULL,68,'8',1001,NULL,'Checked Out',60.00,150.00,NULL,NULL,NULL,4,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,'\nEXTENDED FROM 2023-03-24 TO 2023-03-27',NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-23 11:42:10',10016,NULL,NULL),(421,NULL,'16795429306680','[\"420\"]',10013,10044,'2023-03-23',NULL,NULL,'2023-03-24','11:55:39',10016,NULL,108,'48',1001,NULL,'Checked Out',80.00,80.00,NULL,NULL,NULL,1,NULL,NULL,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25','Deluxe Room',NULL,NULL,'2023-03-23 11:42:10',10016,NULL,NULL),(422,'Boarding','16795435597631','[\"440\",\"441\"]',NULL,10045,'2023-03-23',NULL,NULL,'2023-03-24',NULL,NULL,NULL,102,'42',1010,NULL,'Reserved',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-23 11:52:39',10016,NULL,NULL),(423,'Grooming','16801225239438','[\"421\"]',10017,10046,'2023-03-23',NULL,NULL,'2023-03-23','04:42:03',10016,NULL,125,'2:00PM',1001,NULL,'Checked Out',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-23 11:58:23',10016,NULL,NULL),(424,'Boarding','16797170013589','[\"420\"]',NULL,10047,'2023-03-25',NULL,NULL,'2023-03-26',NULL,NULL,NULL,100,'40',1001,NULL,'Reserved',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-25 12:03:21',10016,NULL,NULL),(425,'Boarding','16797170013589','[\"421\"]',NULL,10047,'2023-03-25',NULL,NULL,'2023-03-26',NULL,NULL,NULL,101,'41',1001,NULL,'Reserved',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-25 12:03:21',10016,NULL,NULL),(426,'Grooming','16798037257320',NULL,NULL,10048,'2023-03-26',NULL,NULL,'2023-03-26',NULL,NULL,NULL,124,'12:30PM',1001,NULL,'Reserved',0.00,0.00,25.00,NULL,NULL,1,NULL,NULL,NULL,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-26 12:08:45',10016,NULL,NULL),(427,'Boarding','16800593524506',NULL,NULL,10049,'2023-03-29',NULL,NULL,'2023-03-30',NULL,NULL,NULL,102,'42',1001,NULL,'Reserved',100.00,100.00,25.00,NULL,NULL,1,NULL,NULL,1,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-29 11:09:12',10016,NULL,NULL),(428,NULL,'16801225239438','[\"420\"]',10017,10050,'2023-03-30',NULL,NULL,'2023-04-05','04:42:03',10016,NULL,61,'1',1001,NULL,'Checked Out',210.00,210.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-29 11:26:23',10016,NULL,NULL),(429,NULL,'16800656104752','[\"420\"]',NULL,10051,'2023-03-29',NULL,NULL,'2023-03-30',NULL,NULL,NULL,75,'15',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-29 12:53:30',10016,NULL,NULL),(430,NULL,'16800657967686','[\"421\"]',NULL,10052,'2023-03-29',NULL,NULL,'2023-03-30',NULL,NULL,NULL,83,'23',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-29 12:56:36',10016,NULL,NULL),(431,NULL,'16800779486416','[\"420\"]',NULL,10053,'2023-03-29',NULL,NULL,'2023-03-30',NULL,NULL,NULL,84,'24',1001,NULL,'Reserved',60.00,60.00,NULL,NULL,NULL,1,NULL,NULL,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-29 16:19:08',10016,NULL,NULL),(432,'Boarding','16800783307974','[\"420\"]',10016,10054,'2023-03-29',NULL,NULL,'2023-03-30','16:33:23',10016,NULL,101,'41',1001,NULL,'Checked Out',80.00,80.00,25.00,NULL,NULL,1,NULL,NULL,0,10.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-29 16:25:30',10016,NULL,NULL),(433,'Grooming','16800789033036',NULL,NULL,10055,'2023-03-29',NULL,NULL,'2023-03-29',NULL,NULL,NULL,NULL,'2:00PM',1001,NULL,'Reserved',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-29 16:35:03',10016,NULL,NULL),(434,NULL,'16801185645018','[\"420\"]',NULL,10056,'2023-03-30',NULL,NULL,'2023-03-31',NULL,NULL,NULL,84,'24',1001,NULL,'Cancelled',60.00,60.00,NULL,NULL,NULL,1,30.00,30.00,0,20.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'26','Standard Room',NULL,NULL,'2023-03-30 03:36:04',10016,NULL,NULL),(435,'Boarding','16801226732775',NULL,NULL,10057,'2023-03-30',NULL,NULL,'2023-03-31',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',80.00,80.00,25.00,NULL,NULL,1,0.00,0.00,0,10.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-30 04:44:33',10016,NULL,NULL),(436,'Boarding','16801227369174','[\"420\"]',10018,10058,'2023-03-30',NULL,NULL,'2023-03-31','06:20:43',10016,NULL,100,'40',1001,NULL,'Checked Out',160.00,60.00,25.00,NULL,NULL,1,80.00,0.00,0,10.00,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-30 04:45:36',10016,NULL,NULL),(437,'Grooming','16801265535888',NULL,NULL,10059,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'2:00PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-30 05:49:13',10016,NULL,NULL),(438,'Grooming','16801265535888',NULL,NULL,10059,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'12:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-30 05:49:13',10016,NULL,NULL),(439,'Grooming','16801266178168',NULL,NULL,10060,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'3:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-30 05:50:17',10016,NULL,NULL),(440,'Grooming','16801272126108',NULL,NULL,10061,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'3:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-30 06:00:12',10016,NULL,NULL),(441,'Grooming','16801360784613',NULL,10019,10065,'2023-03-30',NULL,NULL,'2023-03-30','08:27:58',10016,NULL,NULL,'5:00PM',1001,NULL,'Checked Out',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 07:46:16',10016,NULL,NULL),(442,'Grooming','16801360784613',NULL,10019,10065,'2023-03-30',NULL,NULL,'2023-03-30','08:27:58',10016,NULL,NULL,'6:00PM',1001,NULL,'Checked Out',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 07:46:16',10016,NULL,NULL),(443,'Grooming','16801339347936','[\"420\"]',NULL,10066,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,NULL,'2:00PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 07:52:14',10016,NULL,NULL),(444,'Grooming','16801339347936','[\"421\"]',NULL,10066,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,NULL,'12:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-30 07:52:14',10016,NULL,NULL),(445,'Boarding','16801352984590','[\"420\"]',NULL,10067,'2023-03-30',NULL,NULL,'2023-03-31',NULL,NULL,NULL,102,'42',1001,NULL,'Cancelled',160.00,160.00,25.00,NULL,NULL,1,80.00,80.00,0,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-30 08:14:58',10016,NULL,NULL),(446,'Boarding','16801360784613','[\"421\",\"420\"]',10019,10068,'2023-03-30',NULL,NULL,'2023-03-31','08:27:58',10016,NULL,101,'41',1001,NULL,'Checked Out',160.00,160.00,25.00,NULL,NULL,1,80.00,80.00,1,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-30 08:25:42',10016,NULL,NULL),(447,'Grooming','16801359749474','[\"420\"]',NULL,10069,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,NULL,'3:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-30 08:26:14',10016,NULL,NULL),(465,'Grooming','16802145782156',NULL,NULL,10090,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,124,'12:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-31 06:16:18',10016,NULL,NULL),(449,'Grooming','16801601799070',NULL,NULL,10070,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'1:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:09:39',10016,NULL,NULL),(450,'Grooming','16801602241913',NULL,NULL,10071,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'2:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:10:24',10016,NULL,NULL),(451,'Grooming','16801604213654',NULL,NULL,10072,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'1:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:13:41',10016,NULL,NULL),(452,'Grooming','16801608101990',NULL,NULL,10073,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'1:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:20:10',10016,NULL,NULL),(453,'Grooming','16801612699843',NULL,NULL,10074,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'1:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:27:49',10016,NULL,NULL),(454,'Grooming','16801614168468',NULL,NULL,10075,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'1:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:30:16',10016,NULL,NULL),(455,'Grooming','16801615815966',NULL,NULL,10076,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'2:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:33:01',10016,NULL,NULL),(456,'Grooming','16801618017261',NULL,NULL,10077,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'2:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'30',NULL,NULL,NULL,'2023-03-30 15:36:41',10016,NULL,NULL),(464,'Grooming','16802141794690',NULL,NULL,10082,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,NULL,'2:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-31 06:09:39',10016,NULL,NULL),(458,'Grooming','16801768331238',NULL,NULL,10079,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'12:30PM',1001,NULL,'Reserved',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-30 19:47:13',10016,NULL,NULL),(459,'Grooming','16801768331238',NULL,NULL,10079,'2023-03-30',NULL,NULL,'2023-03-30',NULL,NULL,NULL,NULL,'1:30PM',1001,NULL,'Reserved',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'2023-03-30 19:47:13',10016,NULL,NULL),(460,'Boarding','16801769078013','[\"420\",\"421\"]',NULL,10080,'2023-03-30',NULL,NULL,'2023-03-31',NULL,NULL,NULL,101,'41',1001,NULL,'Cancelled',160.00,160.00,25.00,NULL,NULL,1,80.00,80.00,1,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-03-30 19:48:27',10016,NULL,NULL),(461,'Grooming','16802117157828','[\"420\"]',NULL,10081,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,134,'1:30PM',1001,NULL,'Hold',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-31 05:20:35',10016,NULL,NULL),(462,'Grooming','16801769078013','[\"420\"]',NULL,10080,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,134,'1:30PM',1001,NULL,'Cancelled',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'31','Lion Cut',NULL,NULL,'2023-03-31 05:45:02',10016,NULL,NULL),(466,'Grooming','16802147633616','[\"420\"]',NULL,10093,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,124,'12:30PM',1001,NULL,'Cancelled',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-31 06:19:23',10016,NULL,NULL),(467,'Grooming','16802213694412','[\"420\"]',NULL,10094,'2023-03-31',NULL,NULL,'2023-03-31',NULL,NULL,NULL,124,'12:30PM',1001,NULL,'Reserved',NULL,NULL,25.00,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'29','Grooming Adult',NULL,NULL,'2023-03-31 08:09:29',10016,NULL,NULL),(470,'Boarding','16803066376933','[\"420\",\"421\"]',NULL,10095,'2023-04-01',NULL,NULL,'2023-04-02',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',180.00,180.00,25.00,NULL,NULL,1,80.00,80.00,1,20.00,20.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-01 07:50:37',10016,NULL,NULL),(471,'Boarding','16803180818485',NULL,NULL,10096,'2023-04-01',NULL,NULL,'2023-04-02',NULL,NULL,NULL,103,'43',1001,NULL,'Reserved',220.00,220.00,25.00,NULL,NULL,1,110.00,110.00,4,NULL,NULL,'[110,110]','[110,110]',NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-01 11:01:21',10016,NULL,NULL),(472,'Boarding','16803181495907',NULL,NULL,10097,'2023-04-17',NULL,NULL,'2023-04-22',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',630.00,630.00,25.00,NULL,NULL,5,100.00,100.00,3,NULL,NULL,'[100,100,100,110,110,110]','[100,100,100,110,110,110]',NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-01 11:02:29',10016,NULL,NULL),(473,'Boarding','16803312477307',NULL,NULL,10098,'2023-04-16',NULL,NULL,'2023-04-24',NULL,NULL,NULL,101,'41',1001,NULL,'Cancelled',950.00,950.00,25.00,NULL,NULL,8,100.00,100.00,3,NULL,NULL,'[100,100,100,100,110,110,110,110,110]','[100,100,100,100,110,110,110,110,110]',NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-01 14:40:47',10016,NULL,NULL),(474,'Boarding','16803313058011',NULL,NULL,10099,'2023-04-17',NULL,NULL,'2023-04-26',NULL,NULL,NULL,101,'41',1001,NULL,'Cancelled',1170.00,880.00,25.00,NULL,NULL,9,110.00,0.00,4,NULL,NULL,'[0,90,90,100,100,100,100,100,100,100]','[110,110,110,120,120,120,120,120,120,120]','',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-01 14:41:45',10016,NULL,NULL),(476,'Boarding','16803870171020',NULL,NULL,10101,'2023-04-17',NULL,NULL,'2023-04-29',NULL,NULL,NULL,100,'40',1001,NULL,'Cancelled',1400.00,1060.00,25.00,NULL,NULL,12,100.00,0.00,2,NULL,NULL,'{\"1\":0,\"2\":80,\"3\":90,\"4\":90,\"5\":90,\"6\":90,\"7\":90,\"8\":90,\"9\":90,\"10\":90,\"11\":90,\"12\":90,\"13\":80}','{\"1\":100,\"2\":100,\"3\":110,\"4\":110,\"5\":110,\"6\":110,\"7\":110,\"8\":110,\"9\":110,\"10\":110,\"11\":110,\"12\":110,\"13\":100}','',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-02 06:10:17',10016,NULL,NULL),(477,'Boarding','16803885954794','[\"420\",\"421\",\"422\"]',NULL,10102,'2023-04-17',NULL,NULL,'2023-04-29',NULL,NULL,NULL,100,'40',1001,NULL,'Reserved',1400.00,1060.00,25.00,NULL,NULL,12,100.00,0.00,2,NULL,NULL,'[0,80,90,90,90,90,90,90,90,90,90,90,80]','[100,100,110,110,110,110,110,110,110,110,110,110,100]','',NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-02 06:36:35',10016,NULL,NULL),(478,'Boarding','16803901415374','[\"420\",\"421\"]',NULL,10103,'2023-04-02',NULL,NULL,'2023-04-03',NULL,NULL,NULL,100,'40',1001,NULL,'Reserved',160.00,160.00,25.00,NULL,NULL,1,80.00,80.00,1,NULL,NULL,'[80,80]','[80,80]',NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-02 07:02:21',10016,NULL,NULL),(479,'Boarding','16803913114370',NULL,NULL,10104,'2023-04-02',NULL,NULL,'2023-04-03',NULL,NULL,NULL,101,'41',1001,NULL,'Reserved',120.00,120.00,25.00,NULL,NULL,1,0.00,0.00,4,NULL,NULL,'[120]','[120]',NULL,NULL,NULL,NULL,NULL,'25',NULL,NULL,NULL,'2023-04-02 07:21:51',10016,NULL,NULL),(480,'Boarding','16805618615938','[\"429\"]',NULL,10105,'2023-04-04',NULL,NULL,'2023-04-07',NULL,NULL,NULL,100,'40',1002,NULL,'Checked In',240.00,240.00,25.00,NULL,NULL,3,0.00,0.00,0,NULL,NULL,'[80,80,80]','[80,80,80]',NULL,NULL,'\nEXTENDED FROM 2023-04-05 TO 2023-04-06',NULL,NULL,'25',NULL,NULL,NULL,'2023-04-04 06:44:21',10016,NULL,NULL);

--
-- Table structure for table `close_out`
--

CREATE TABLE `close_out` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `days` text,
  `description` varchar(255) DEFAULT '',
  `type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `close_out`
--

INSERT INTO `close_out` VALUES (6,'2022-12-26',NULL,'FULL SLOT','Grooming'),(5,'2022-12-27',NULL,'FULL SLOT','Grooming'),(12,'2023-03-10','','Grooming unavailable on this date','Grooming'),(9,NULL,'WED','Closed every Wednesday','Grooming'),(11,'2023-02-16','','No groomers available','Grooming'),(13,'2023-04-24','','No check in or check out from 24 - 30th April','Boarding'),(14,'2023-04-25','','No check in or check out from 24 - 30th April','Boarding'),(15,'2023-04-26','','No check in or check out from 24 - 30th April','Boarding');

--
-- Table structure for table `commissions`
--

CREATE TABLE `commissions` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commissions`
--


--
-- Table structure for table `config`
--

CREATE TABLE `config` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `config` varchar(128) DEFAULT NULL,
  `value` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=146 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `config`
--

INSERT INTO `config` VALUES (47,'deposit','25.00'),(48,'check_out_time',''),(49,'weekend','Sunday,Saturday'),(50,'max_room','10'),(51,'min_foc_room',NULL),(52,'regular_rate_label','Non-Member'),(53,'agent_rate_label',NULL),(54,'govt_rate_label',NULL),(55,'promo_rate_label','Member'),(56,'booking_header',NULL),(57,'booking_landing',NULL),(58,'booking_footer',NULL),(59,'booking_home_top',NULL),(60,'booking_sidebar',NULL),(61,'booking_cancellation_policy',NULL),(62,'booking_paypal',NULL),(63,'booking_tnc','<p>Tnc</p>'),(64,'booking_only',NULL),(65,'booking_css',NULL),(45,'surcharge_label',''),(46,'surcharge_inclusive',NULL),(44,'surcharge','0.00'),(43,'tax_inclusive',NULL),(42,'tax',''),(40,'tax_id',''),(41,'tax_name',''),(35,'hotel_name','Petboss Main Branch'),(36,'document_header','<p>JALAN DIPLOMATIK PRESINT 15, <br>PRESINT DIPLOMATIK, 62050 PUTRAJAYA, <br>WILAYAH PERSEKUTUAN PUTRAJAYA<br></p>'),(37,'thank_you_note','<p>Thank you. Please come again!</p>'),(38,'currency','RM'),(39,'t_tax',NULL),(68,'guest_agreement','<h1 style=\"text-align: center;\">DECLARATION FORM</h1><p style=\"text-align: center;\">HOTEL/GROOMING</p><p><strong><br></strong></p><p><strong>I HAVE READ THE TERMS &amp; CONDITIONS BELOW AND FULLY AGREE TO THE FOLLOWING</strong>:</p><p>1. Deposits are not refundable. Once service effected, no claims shall be entertained.</p><p>2. It is the responsibility of the owner of the cat or by its own act for any or all damages, escape, or loss caused to the cat hotel.</p><p>3. When you sign the declaration form, you will also be consenting to emergency medical care in the event your cat becomes seriously ill. If you leave us an emergency phone number, we will certainly try to reach you and inform you of the situation. However, you can be sure the veterinarians will provide the best care possible for your cat\'s condition. Such charges shall be borne by the owner.</p><p>4. All charges for boarding are to be made in advance and other services are due when the cat is released. If you plan to have someone else pick up your cat, we must be informed in advance by the owner providing all necessary details e.g., name, IC etc.</p><p><br></p><h4>IMPORTANT REMINDER</h4><p>Any unpaid and/or uncollected cats will be disposed off after a period of 14 days from date of collection due date. The management reserves the sole right to do as they deem appropriate thereafter without further notice. The management is then released of their responsibilities for the cats boarded under these terms. All clients shall be in agreement to these terms once they have chosen at their freewill to sign this form and board their cats at THIS IS MEOWNESS CAT BOUTIQUE HOTEL.</p>'),(66,'booking_billplz','03a55f41-ac53-40e5-a9e6-072dd572cfd0'),(67,'booking_billplz_cid','4y46pxwx'),(69,'allow_backdate',NULL),(70,'promo_desc',''),(71,'guest_agreement_nric_required',NULL),(72,'guest_agreement_online_only',NULL),(73,'whatsapp_template_booking',''),(74,'whatsapp_template_invoice',''),(75,'whatsapp_template_quote',''),(76,'whatsapp_template_receipt',''),(77,'booking_brand_name','PetBoss'),(78,'booking_guest',NULL),(79,'booking_guest_email_optional',NULL),(80,'booking_register_text','<p>Register today to and book rooms for your cats more conveniently.</p>'),(81,'booking_nric_optional','1'),(82,'booking_pay_at_hotel','1'),(83,'booking_mp','1'),(84,'booking_mp_instruction','<p>Please transfer your payment to the below account:</p><p><strong></strong></p><p><strong>MAYBANK<br></strong></p><p><strong>XXXXXXXX<br></strong></p><p><strong>XXXXXXXX<br></strong></p><p>Once you have made payment, please send us the transfer slip via Whatsapp to XXXXXXXX</p>'),(85,'booking_mp_instruction_pah',''),(86,'booking_pah_cutoff',''),(87,'boarding_rules','<p class=\"text-left pt-5\">\r\n	Before you confirm your booking, please ensure you adhere to the following rules. We reserved the right to deny your cat\'s stay if the rules are not complied.<br><br>\r\n</p><table class=\"w-full text-left\">\r\n<tbody>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Bring medical card with updated <strong>latest vaccine</strong>\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats must complete <strong>2nd dose</strong> of vaccine\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Latest vaccination must be least <strong>7 days</strong> before check in date\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Compulsory to add on <strong>flea medication</strong> RM5/cat\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cat must be <strong>healthy</strong> and free from flea, fungus &amp; skin infection\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Bring your own <strong>cat food</strong> in if your cat requires special diet\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Only <strong>small can</strong> or <strong>packet</strong> wet food is allowed\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Bring your cat in a <strong>carrier</strong>\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Check in from <strong>10AM</strong>\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Check out before <strong>2PM</strong>\r\n	</td>\r\n</tr>\r\n</tbody>\r\n</table><p><br>\r\n</p>'),(88,'grooming_rules','<p class=\"text-left pt-5\">\r\n	Before you confirm your booking, please ensure you adhere to the following rules. We reserved the right to deny your cat\'s stay if the rules are not complied.<br><br>\r\n</p><table class=\"w-full text-left\">\r\n<tbody>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats must be <strong>healthy</strong> and free any kinds of fever and flu\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats must complete 7 days if recently vaccinated or applied with flea medication\r\n	</td>\r\n</tr>\r\n<tr>\r\n	<td class=\"p-1\"><i class=\"fa-solid fa-check text-yellow-500\"></i>\r\n	</td>\r\n	<td>Cats that recently had undergone surgery are not allowed for grooming\r\n	</td>\r\n</tr>\r\n</tbody>\r\n</table><p><br>\r\n</p>'),(89,'membership_branding',''),(90,'boarding_promo_text','<p class=\"text-2xl text-yellow-600 font-bold pb-2\">Sign up with Petboss</p><p class=\"mb-3\">Keep your cat profile and make faster and convenient booking\r\n</p>'),(91,'grooming_promo_text','<p class=\"text-2xl text-yellow-600 font-bold pb-2\">Sign up with Petboss</p><p class=\"mb-3\">Keep your cat profile and make faster and convenient booking\r\n</p>'),(92,'boarding_benefit','<p><strong><i class=\"fa-solid fa-crown text-yellow-500\"></i> Petboss Membership</strong><br>\r\n</p><p>Enjoy membership rates up to 20% discount\r\n</p>'),(93,'grooming_benefit','<p><strong><i class=\"fa-solid fa-crown text-yellow-500\"></i> Petboss Membership</strong><br>\r\n</p><p>Enjoy membership rates up to 10% discount\r\n</p>'),(94,'booking_logo','https://petboss.plexcloud.com/assets/icon1.png'),(95,'booking_bg','https://petboss.plexcloud.com/assets/gray-kitty-with-monochrome-wall-her.jpg'),(96,'hooks_grooming','$coat_type_map = array(\r\n	\'Shorthair\'		=> \'Short Hair\',\r\n	\'Double Coat\'	=> \'Long Hair\',\r\n	\'Longhair\'		=> \'Long Hair\'\r\n);\r\n\r\n$ct = $coat_type_map[$pet->coat_type] ;\r\n$wd = \'\';\r\n$item = $this->db->query(\"SELECT * FROM items WHERE name LIKE ? AND name LIKE ? AND name LIKE ?\", array(\r\n	\'%\'.$package->name.\'%\', \'%\'.$ct.\'%\', \'%\'.$wd.\'%\'\r\n))->row();'),(97,'hooks_grooming_js','var coatMap = {\r\n	\'Shorthair\': \'Short Hair\',\r\n	\'Longhair\': \'Long Hair\',\r\n	\'Double Coat\': \'Long Hair\'\r\n};\r\nvar wd = \'\';\r\n		\r\nvar ct = coatMap[pet.coat_type] ? coatMap[pet.coat_type] : \'\';		\r\n\r\nvar cpackage = gsearch.packages.filter(p => { \r\n	return p.name.toLowerCase().indexOf(category.name.toLowerCase()) > -1 &&\r\n		p.name.toLowerCase().indexOf(ct.toLowerCase()) > -1 &&\r\n		p.name.toLowerCase().indexOf(wd.toLowerCase()) > -1\r\n})[0];\r\n\r\nvar package = JSON.parse(JSON.stringify(cpackage));\r\n'),(98,'hooks_boarding',''),(99,'hooks_boarding_js',NULL),(100,'room_layout',''),(101,'session_layout','11:00AM|11:00:00|MON,TUE,WED,THU,FRI,SAT,SUN\r\n12:30PM|12:30:00|MON,TUE,WED,THU,FRI,SAT,SUN\r\n2:00PM|14:00:00|MON,TUE,WED,THU,FRI,SAT,SUN\r\n3:30PM|15:30:00|MON,TUE,WED,THU,FRI,SAT,SUN\r\n5:00PM|17:00:00|MON,TUE,WED,THU,FRI,SAT,SUN\r\n6:00PM|18:00:00|MON,TUE,WED,THU,FRI,SAT,SUN'),(102,'boarding_deposit','20/room'),(103,'grooming_deposit','20/pet'),(104,'email_host','ssl://smtp.hostinger.com'),(105,'email_port','465'),(106,'email_user','petboss@plexcloud.com'),(107,'email_pass','Petbossadmin#123'),(108,'whatsapp_form_template','Owner Name: $GUEST_NAME\r\nPhone Number: $GUEST_CONTACT\r\nCat Name: $CAT_NAME\r\nCat Age: $CAT_AGE\r\nCat Breed: $CAT_BREED\r\nVaccine Status (Yes/No): $CAT_COLOR\r\nRoom Type (RC/PS/LM): $ROOM_TYPE\r\nCheck In Date (d/m/Y): $CHECK_IN\r\nCheck Out Date (d/m/Y): $CHECK_OUT'),(109,'booking_website_url','https://plexcloud.com'),(110,'booking_primary_color','#11497f'),(111,'booking_primary_color_hover','#1663ac'),(122,'promo_rate_discount','1'),(142,'promo_discount_label','Member\'s Discount'),(123,'boarding_deposit_peak','20/room'),(124,'boarding_pay_deposit','1'),(125,'boarding_pay_in_full',NULL),(126,'grooming_deposit_peak','20/pet'),(127,'grooming_pay_deposit','1'),(128,'grooming_pay_in_full',NULL),(129,'backend_color_tone1','#03244f'),(130,'backend_color_tone2','#0c4c88'),(131,'booking_privacy','<p>Privacy Policy</p>'),(132,'booking_cpolicy','<p>Cancellation policy</p>'),(133,'email_header',''),(134,'email_footer',''),(135,'email_subject',''),(136,'email_header_g',''),(137,'email_footer_g',''),(138,'email_subject_g',''),(139,'booking_registered_only','1'),(140,'booking_billplz_description','Online Banking'),(141,'daily_rates',NULL),(143,'thank_you_note_receipt','<p>test receipt note</p>'),(144,'thank_you_note_confirmation','<p>test confirmation note</p>'),(145,'thank_you_note_quotation','<p>test quotation note</p>'),(114,'booking_show_member_rate',NULL),(112,'booking_simple_pet_details','1'),(113,'booking_simple_guest_details','1'),(119,'whatsapp_bot_enabled',NULL),(120,'whatsapp_bot_mode','QA'),(121,'whatsapp_qa','// FINAL\r\n		$proceed = \'You may proceed booking at booking.ritzcatton.com. \r\n			Type \"hooman!\" if you need our human assistance. We will attend you shortly.\r\n			\r\n			To start over, send any text message\';\r\n		\r\n		// QUESTION 0\r\n		$goto[0] = 1;\r\n		$answer[0] = \"\r\n			Hello there, are you interested for boarding or grooming\r\n			Type *1* for boarding\r\n			Type *2* for grooming\r\n		\";\r\n		\r\n		// ERROR ON QUESTION 0\r\n		$answer[1][0] = \"\r\n			Please answer from the choice\r\n		\";\r\n		\r\n		// QUESTION 1\r\n		$goto[1][1] = 2;\r\n		$answer[1][1] = \"\r\n			When do you plan for boarding? Enter date (DD/MM/YYYY)\r\n		\";\r\n		\r\n		$goto[1][2] = 5;\r\n		$answer[1][2] = \"\r\n			What is your concern to groom your cat?\r\n		\r\n			Type *1* for Smelly/dirty\r\n			Type *2* for Fleas/fungus\r\n			Type *3* for Make it more beautiful\r\n		\";\r\n		\r\n		// QUESTION 2\r\n		$goto[2] = 3;\r\n		$answer[2] = \"\r\n			For how many cats (1-5)\r\n		\";\r\n		\r\n		// QUESTION 3\r\n		\r\n		$goto[3][1] = 0;\r\n		$answer[3][1] =  \"\r\n			Here is our suggestion:\r\n			*Le Meowridien @ RM40/night. The simplest villa & suitable for cat < 4kg.*\r\n			*Purr Season @ RM55/night. Our best-seller villa that maximises cat\'s comfort.*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][2] = 0;\r\n		$answer[3][2] =  \"\r\n			Here is our suggestion:\r\n			*Purr Season @ RM55/night. Our best-seller villa that maximises cat\'s comfort.*\r\n			*Ritz Catton @ RM70/night. Our signature & exclusive villa in the hotel.*\r\n\r\n			$proceed\r\n		\";\r\n		$goto[3][3] = 0;\r\n		$answer[3][3] = \"\r\n			Here is our suggestion:\r\n			*Purr Season @ RM65/night. Our best-seller villa that maximises cat\'s comfort.*\r\n			*Ritz Catton @ RM70/night. Our signature & exclusive villa in the hotel.*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][4] = 0;\r\n		$answer[3][4] =  \"\r\n			Here is our suggestion:\r\n			*Ritz Catton @ RM80/night. Our signature & exclusive villa in the hotel.*\r\n			*St Regis @ RM110/night. The biggest villa, the most grandeur and luxury.*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][5] = 0;\r\n		$answer[3][5] = $response = \"\r\n			Here is our suggestion:\r\n			*Ritz Catton @ RM90/night*\r\n			*St Regis @ RM110/night. The biggest villa, the most grandeur and luxury.*\r\n		\r\n			$proceed\r\n		\";\r\n		$goto[3][0] = 3;\r\n		$answer[3][0] = \"\r\n			Please enter a number from 1 - 5\r\n		\";\r\n		\r\n		\r\n		// QUESTION 5\r\n		$goto[5][0] = 5;\r\n		$goto[5][1] = 0;\r\n		$goto[5][2] = 0;\r\n		$goto[5][3] = 0;\r\n		$answer[5][1] = \"\r\n			Here is our suggestion:\r\n			*Basic Grooming. Recommended for domestic short hair. You can expect your cat to be freshed and clean*\r\n			\r\n			$proceed\r\n		\";\r\n		$answer[5][2] = \"\r\n			Here is our suggestion:\r\n			*Medicated Grooming. Recommended for any cat breed that having fleas/fungus issue*\r\n			\r\n			$proceed\r\n		\";\r\n		$answer[5][3] = \"\r\n			Here is our suggestion:\r\n			*Beauty Grooming. Our signature grooming & best-seller. Best works for cats with many colours, British Short Hair, any long hair breed.*\r\n			\r\n			$proceed\r\n		\";\r\n		$answer[5][0] = \"\r\n			Please enter from choice 1 - 3\r\n		\";\r\n		\r\n		switch ($session->stage):\r\n			case 0:\r\n				if (strpos(\' \'.strtolower($reply), \'hooman\')){\r\n					$response = \'A hooman will attend you shortly.\';\r\n					$stage = 0;\r\n				} else {\r\n					$response = $answer[0];\r\n					$stage = $goto[0];\r\n					\r\n				}\r\n				break;\r\n			case 1:\r\n				if (strpos(\' \'.strtolower($reply), \'hooman\')){\r\n					$response = \'A hooman will attend you shortly.\';\r\n					$stage = 0;\r\n				} else {\r\n					$reply = intval($reply);\r\n					$stage = $goto[1][$reply] !== null ? $goto[1][$reply] : 1;\r\n					$response = $answer[1][$reply] ? $answer[1][$reply] : $answer[1][0];\r\n					\r\n				}\r\n				break;\r\n			case 2:\r\n				$dmy = explode(\'/\', $reply);\r\n				$ymd = $dmy[2] . \'-\' . $dmy[1] . \'-\' . $dmy[0];\r\n				if (strtotime($ymd) < strtotime(date(\'Y-m-d\'))){\r\n					$stage = 2;\r\n					$response = \'Please enter a valid date that must not be earlier than \'.date(\'d/m/Y\').\' (DD/MM/YYYY)\';\r\n				} else {\r\n					$response = $answer[2];\r\n					$stage = $goto[2];	\r\n				}\r\n				\r\n				break;\r\n			case 3:\r\n				$reply = intval($reply);\r\n				$stage = $goto[3][$reply] !== null ? $goto[3][$reply] : $goto[3][0];\r\n				$response = $answer[3][$reply] ? $answer[3][$reply] : $answer[3][0];\r\n				\r\n				\r\n				break;\r\n			case 5:\r\n				$reply = intval($reply);\r\n				$response = $answer[5][$reply] ? $answer[5][$reply] : $answer[5][0];\r\n				$stage = $goto[5][$reply] !== null ? $goto[5][$reply] : $goto[5][0];\r\n				break;\r\n		endswitch;\r\n\r\nif (strpos(\' \'.strtolower($reply), \'hooman here\')){\r\n	$stage = 9;\r\n	$response = null;\r\n}\r\n\r\nif ($session->stage == 9){\r\n	$response = null;\r\n}\r\n		'),(115,'allow_transfer_any_room','1'),(116,'notify_email','shafiq.rizwan@gmail.com'),(117,'whatsapp_welcome_msg','*Welcome to Petboss* \r\n\r\nTo book boarding for your cats, please fill up the form below:\r\n	\r\nOwner Name: \r\nPhone Number: \r\nCat Name:\r\nCat Age: \r\nCat Breed:\r\nCat Colour:\r\nVaccine Status (Yes/No):\r\nRoom Type (RC/PS/LM):\r\nCheck In Date (d/m/Y):\r\nCheck Out Date (d/m/Y): \r\n\r\nFor room type enter the code name accordingly\r\nRitz Catton - RC\r\nPurr Seasons - PS\r\nLe Meowridien - LM\r\n\r\nTo add multiple rooms, enter number in front of the room code e.g. \'2 RC\'\r\n\r\nIf you plan to check in more than 1 cat, use comma \',\' between each names/age/breed/color of your cats'),(118,'whatsapp_confirm_msg','Thank you for booking with us!');

--
-- Table structure for table `conversation`
--

CREATE TABLE `conversation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(30) DEFAULT NULL,
  `message` longtext,
  `reply` longtext,
  `datetime` datetime DEFAULT NULL,
  `reply_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `conversation`
--


--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `prefix` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` VALUES (1,'United States','US'),(2,'Canada','CA'),(3,'Afghanistan','AF'),(4,'Albania','AL'),(5,'Algeria','DZ'),(6,'American Samoa','DS'),(7,'Andorra','AD'),(8,'Angola','AO'),(9,'Anguilla','AI'),(10,'Antarctica','AQ'),(11,'Antigua and/or Barbuda','AG'),(12,'Argentina','AR'),(13,'Armenia','AM'),(14,'Aruba','AW'),(15,'Australia','AU'),(16,'Austria','AT'),(17,'Azerbaijan','AZ'),(18,'Bahamas','BS'),(19,'Bahrain','BH'),(20,'Bangladesh','BD'),(21,'Barbados','BB'),(22,'Belarus','BY'),(23,'Belgium','BE'),(24,'Belize','BZ'),(25,'Benin','BJ'),(26,'Bermuda','BM'),(27,'Bhutan','BT'),(28,'Bolivia','BO'),(29,'Bosnia and Herzegovina','BA'),(30,'Botswana','BW'),(31,'Bouvet Island','BV'),(32,'Brazil','BR'),(33,'British lndian Ocean Territory','IO'),(34,'Brunei Darussalam','BN'),(35,'Bulgaria','BG'),(36,'Burkina Faso','BF'),(37,'Burundi','BI'),(38,'Cambodia','KH'),(39,'Cameroon','CM'),(40,'Cape Verde','CV'),(41,'Cayman Islands','KY'),(42,'Central African Republic','CF'),(43,'Chad','TD'),(44,'Chile','CL'),(45,'China','CN'),(46,'Christmas Island','CX'),(47,'Cocos (Keeling) Islands','CC'),(48,'Colombia','CO'),(49,'Comoros','KM'),(50,'Congo','CG'),(51,'Cook Islands','CK'),(52,'Costa Rica','CR'),(53,'Croatia (Hrvatska)','HR'),(54,'Cuba','CU'),(55,'Cyprus','CY'),(56,'Czech Republic','CZ'),(57,'Denmark','DK'),(58,'Djibouti','DJ'),(59,'Dominica','DM'),(60,'Dominican Republic','DO'),(61,'East Timor','TP'),(62,'Ecudaor','EC'),(63,'Egypt','EG'),(64,'El Salvador','SV'),(65,'Equatorial Guinea','GQ'),(66,'Eritrea','ER'),(67,'Estonia','EE'),(68,'Ethiopia','ET'),(69,'Falkland Islands (Malvinas)','FK'),(70,'Faroe Islands','FO'),(71,'Fiji','FJ'),(72,'Finland','FI'),(73,'France','FR'),(74,'France, Metropolitan','FX'),(75,'French Guiana','GF'),(76,'French Polynesia','PF'),(77,'French Southern Territories','TF'),(78,'Gabon','GA'),(79,'Gambia','GM'),(80,'Georgia','GE'),(81,'Germany','DE'),(82,'Ghana','GH'),(83,'Gibraltar','GI'),(84,'Greece','GR'),(85,'Greenland','GL'),(86,'Grenada','GD'),(87,'Guadeloupe','GP'),(88,'Guam','GU'),(89,'Guatemala','GT'),(90,'Guinea','GN'),(91,'Guinea-Bissau','GW'),(92,'Guyana','GY'),(93,'Haiti','HT'),(94,'Heard and Mc Donald Islands','HM'),(95,'Honduras','HN'),(96,'Hong Kong','HK'),(97,'Hungary','HU'),(98,'Iceland','IS'),(99,'India','IN'),(100,'Indonesia','ID'),(101,'Iran (Islamic Republic of)','IR'),(102,'Iraq','IQ'),(103,'Ireland','IE'),(104,'Israel','IL'),(105,'Italy','IT'),(106,'Ivory Coast','CI'),(107,'Jamaica','JM'),(108,'Japan','JP'),(109,'Jordan','JO'),(110,'Kazakhstan','KZ'),(111,'Kenya','KE'),(112,'Kiribati','KI'),(113,'Korea, Democratic People\'s Republic of','KP'),(114,'Korea, Republic of','KR'),(115,'Kuwait','KW'),(116,'Kyrgyzstan','KG'),(117,'Laos','LA'),(118,'Latvia','LV'),(119,'Lebanon','LB'),(120,'Lesotho','LS'),(121,'Liberia','LR'),(122,'Libyan Arab Jamahiriya','LY'),(123,'Liechtenstein','LI'),(124,'Lithuania','LT'),(125,'Luxembourg','LU'),(126,'Macau','MO'),(127,'Macedonia','MK'),(128,'Madagascar','MG'),(129,'Malawi','MW'),(130,'Malaysia','MY'),(131,'Maldives','MV'),(132,'Mali','ML'),(133,'Malta','MT'),(134,'Marshall Islands','MH'),(135,'Martinique','MQ'),(136,'Mauritania','MR'),(137,'Mauritius','MU'),(138,'Mayotte','TY'),(139,'Mexico','MX'),(140,'Micronesia, Federated States of','FM'),(141,'Moldova, Republic of','MD'),(142,'Monaco','MC'),(143,'Mongolia','MN'),(144,'Montserrat','MS'),(145,'Morocco','MA'),(146,'Mozambique','MZ'),(147,'Myanmar','MM'),(148,'Namibia','NA'),(149,'Nauru','NR'),(150,'Nepal','NP'),(151,'Netherlands','NL'),(152,'Netherlands Antilles','AN'),(153,'New Caledonia','NC'),(154,'New Zealand','NZ'),(155,'Nicaragua','NI'),(156,'Niger','NE'),(157,'Nigeria','NG'),(158,'Niue','NU'),(159,'Norfork Island','NF'),(160,'Northern Mariana Islands','MP'),(161,'Norway','NO'),(162,'Oman','OM'),(163,'Pakistan','PK'),(164,'Palau','PW'),(165,'Panama','PA'),(166,'Papua New Guinea','PG'),(167,'Paraguay','PY'),(168,'Peru','PE'),(169,'Philippines','PH'),(170,'Pitcairn','PN'),(171,'Poland','PL'),(172,'Portugal','PT'),(173,'Puerto Rico','PR'),(174,'Qatar','QA'),(175,'Reunion','RE'),(176,'Romania','RO'),(177,'Russian Federation','RU'),(178,'Rwanda','RW'),(179,'Saint Kitts and Nevis','KN'),(180,'Saint Lucia','LC'),(181,'Saint Vincent and the Grenadines','VC'),(182,'Samoa','WS'),(183,'San Marino','SM'),(184,'Sao Tome and Principe','ST'),(185,'Saudi Arabia','SA'),(186,'Senegal','SN'),(187,'Seychelles','SC'),(188,'Sierra Leone','SL'),(189,'Singapore','SG'),(190,'Slovakia','SK'),(191,'Slovenia','SI'),(192,'Solomon Islands','SB'),(193,'Somalia','SO'),(194,'South Africa','ZA'),(195,'South Georgia South Sandwich Islands','GS'),(196,'Spain','ES'),(197,'Sri Lanka','LK'),(198,'St. Helena','SH'),(199,'St. Pierre and Miquelon','PM'),(200,'Sudan','SD'),(201,'Suriname','SR'),(202,'Svalbarn and Jan Mayen Islands','SJ'),(203,'Swaziland','SZ'),(204,'Sweden','SE'),(205,'Switzerland','CH'),(206,'Syrian Arab Republic','SY'),(207,'Taiwan','TW'),(208,'Tajikistan','TJ'),(209,'Tanzania, United Republic of','TZ'),(210,'Thailand','TH'),(211,'Togo','TG'),(212,'Tokelau','TK'),(213,'Tonga','TO'),(214,'Trinidad and Tobago','TT'),(215,'Tunisia','TN'),(216,'Turkey','TR'),(217,'Turkmenistan','TM'),(218,'Turks and Caicos Islands','TC'),(219,'Tuvalu','TV'),(220,'Uganda','UG'),(221,'Ukraine','UA'),(222,'United Arab Emirates','AE'),(223,'United Kingdom','GB'),(224,'United States minor outlying islands','UM'),(225,'Uruguay','UY'),(226,'Uzbekistan','UZ'),(227,'Vanuatu','VU'),(228,'Vatican City State','VA'),(229,'Venezuela','VE'),(230,'Vietnam','VN'),(231,'Virigan Islands (British)','VG'),(232,'Virgin Islands (U.S.)','VI'),(233,'Wallis and Futuna Islands','WF'),(234,'Western Sahara','EH'),(235,'Yemen','YE'),(236,'Yugoslavia','YU'),(237,'Zaire','ZR'),(238,'Zambia','ZM'),(239,'Zimbabwe','ZW');

--
-- Table structure for table `credit_cards`
--

CREATE TABLE `credit_cards` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `service_charge` varchar(255) DEFAULT NULL,
  `tax` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `credit_cards`
--

INSERT INTO `credit_cards` VALUES (1,'MasterCard','Card','undefined','undefined'),(2,'VISA','Card','undefined','undefined'),(3,'Grab','eWallet','undefined','undefined'),(4,'MAE','eWallet','undefined','undefined'),(5,'TNG','eWallet','undefined','undefined');

--
-- Table structure for table `deposit`
--

CREATE TABLE `deposit` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `guest_id` varchar(128) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_in_by` int(11) DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `check_out_by` int(11) DEFAULT NULL,
  `rate_type` varchar(100) DEFAULT NULL,
  `agent_type` varchar(100) DEFAULT NULL,
  `deposit_type` varchar(32) DEFAULT NULL,
  `mid` varchar(100) DEFAULT NULL,
  `booking_id` varchar(150) DEFAULT NULL,
  `deposit_amount` decimal(20,2) DEFAULT NULL,
  `transfer_amount` decimal(20,2) DEFAULT NULL,
  `key_deposit_amount` decimal(20,2) DEFAULT NULL,
  `deposit_card_type` varchar(128) DEFAULT NULL,
  `deposit_card_no` varchar(128) DEFAULT NULL,
  `deposit_ref_no` varchar(128) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `completed` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `room_no` varchar(128) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `reservation_id` int(11) DEFAULT NULL,
  `void` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `deposit`
--

INSERT INTO `deposit` VALUES (1,'1659539573','1','2022-08-03',NULL,'2022-08-04',10016,'Normal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,NULL,NULL),(2,'1659602736','1','2022-08-04',NULL,'2022-08-05',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'1659602895','1','2022-08-04',NULL,'2022-08-05',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1659681345','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,'cash',NULL,NULL,65.00,NULL,0.00,NULL,NULL,NULL,NULL,NULL,'2022-08-05 14:37:29',NULL,NULL,NULL,NULL,NULL),(5,'1659692799','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,'cash',NULL,NULL,55.00,NULL,50.00,NULL,NULL,NULL,NULL,NULL,'2022-08-05 19:04:45',NULL,NULL,NULL,NULL,NULL),(6,'1659692799','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,'cash',NULL,NULL,55.00,NULL,50.00,NULL,NULL,NULL,NULL,NULL,'2022-08-05 19:04:45',NULL,NULL,NULL,NULL,NULL),(7,'1659697648','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,'1659697648','1','2022-08-05',10016,'2022-08-06',NULL,'promo_',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `email_tac`
--

CREATE TABLE `email_tac` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) DEFAULT NULL,
  `tac` varchar(6) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `email_tac`
--

INSERT INTO `email_tac` VALUES (95,'shafiq.rizwan@gmail.com','454362','2023-02-20 09:49:35');

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` varchar(128) DEFAULT NULL,
  `withdrawn_account_id` varchar(128) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `payment_to` varchar(255) DEFAULT NULL,
  `supplier` varchar(255) DEFAULT NULL,
  `supplier_id` int(11) DEFAULT NULL,
  `memo` varchar(255) DEFAULT NULL,
  `reference_no` varchar(255) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `net_amount` decimal(20,2) DEFAULT NULL,
  `tax_amount` decimal(20,2) DEFAULT NULL,
  `tax_included` decimal(20,2) DEFAULT NULL,
  `void` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `expenses`
--


--
-- Table structure for table `items`
--

CREATE TABLE `items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pos` int(1) DEFAULT NULL,
  `name` varchar(128) DEFAULT NULL,
  `sku` varchar(128) DEFAULT NULL,
  `description` text,
  `price` decimal(20,2) DEFAULT NULL,
  `promo_price` decimal(20,2) DEFAULT NULL,
  `type` varchar(128) DEFAULT NULL,
  `has_stock` int(1) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `grooming_addon` int(1) DEFAULT NULL,
  `boarding_addon` int(1) DEFAULT NULL,
  `hide_price` int(1) DEFAULT NULL,
  `price_unit` varchar(128) DEFAULT NULL,
  `cost` decimal(20,2) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `items`
--

INSERT INTO `items` VALUES (49,NULL,'Lion Cut - Short Hair',NULL,NULL,100.00,100.00,'Grooming',NULL,-2,NULL,NULL,NULL,NULL,NULL,NULL),(42,NULL,'Adjustment',NULL,NULL,0.00,0.00,'Adjustment',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL),(43,0,'Vaccine / Ubat Kutu / Ubat Cacing - Above 4kg',NULL,NULL,85.00,85.00,'Addon',NULL,-6,1,1,NULL,NULL,NULL,NULL),(44,0,'Ubat Kutu / Ubat Cacing - Above 4kg',NULL,NULL,65.00,65.00,'Addon',NULL,-3,NULL,NULL,NULL,NULL,NULL,NULL),(45,NULL,'Ubat Kutu / Ubat Cacing - Below 4kg',NULL,NULL,55.00,55.00,'Addon',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL),(39,NULL,'Grooming Kitten - Short Hair',NULL,NULL,25.00,20.00,'Grooming',NULL,-6,NULL,NULL,NULL,NULL,NULL,NULL),(40,NULL,'Grooming Kitten - Long Hair',NULL,NULL,35.00,30.00,'Grooming',NULL,-13,NULL,NULL,NULL,NULL,NULL,NULL),(9,1,'Grooming Adult - Short Hair',NULL,NULL,50.00,40.00,'Grooming',NULL,-41,NULL,NULL,NULL,NULL,NULL,NULL),(10,1,'Grooming Adult - Long Hair',NULL,NULL,60.00,50.00,'Grooming',NULL,-4,NULL,NULL,NULL,NULL,NULL,NULL),(46,0,'Vaccine / Ubat Kutu / Ubat Cacing - Below 4kg',NULL,NULL,75.00,75.00,'Addon',NULL,-2,1,1,NULL,NULL,NULL,NULL),(47,0,'Neutering - Female Cat',NULL,NULL,160.00,160.00,'Addon',NULL,-4,NULL,NULL,NULL,NULL,NULL,NULL),(48,0,'Neutering - Male Cat',NULL,NULL,100.00,100.00,'Addon',NULL,-2,NULL,NULL,NULL,NULL,NULL,NULL),(50,NULL,'Lion Cut - Long Hair',NULL,NULL,100.00,100.00,'Grooming',NULL,-10,NULL,NULL,NULL,NULL,NULL,NULL),(51,0,'Late Checkout',NULL,NULL,20.00,20.00,'Addon',NULL,15,NULL,NULL,NULL,NULL,NULL,NULL),(1,NULL,'Membership',NULL,NULL,30.00,30.00,'Membership',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,'Discount',NULL,NULL,0.00,0.00,'Discount',NULL,-2,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,'Refund',NULL,NULL,0.00,0.00,'Adjustment',NULL,-1,NULL,NULL,NULL,NULL,NULL,NULL),(55,1,'Nutrilick','952839121',NULL,3.50,3.30,'Cat Snacks',1,-10,NULL,NULL,NULL,NULL,NULL,NULL),(56,1,'Tofu Litter 10L','12391023',NULL,12.00,11.00,'Cat Litter',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `logs`
--

CREATE TABLE `logs` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(255) DEFAULT NULL,
  `table` varchar(255) DEFAULT NULL,
  `record_id` varchar(255) DEFAULT NULL,
  `desc_id` varchar(255) DEFAULT '',
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `performed_by` varchar(255) DEFAULT NULL,
  `data` longtext,
  PRIMARY KEY (`id`),
  KEY `module` (`module`),
  KEY `table` (`table`),
  KEY `record_id` (`record_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `logs`
--


--
-- Table structure for table `payment_voucher_breakdown`
--

CREATE TABLE `payment_voucher_breakdown` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pv_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `account` text,
  `account_id` int(11) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `payment_reference` varchar(128) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_voucher_breakdown`
--


--
-- Table structure for table `payment_voucher_items`
--

CREATE TABLE `payment_voucher_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `pv_id` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `po_id` int(11) DEFAULT NULL,
  `cn_id` int(11) DEFAULT NULL,
  `dn_id` int(11) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `reference` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `amount_payable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `tax_code` varchar(255) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_voucher_items`
--


--
-- Table structure for table `payment_vouchers`
--

CREATE TABLE `payment_vouchers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `account_id` varchar(128) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `amount_payable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `void_date` datetime DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `tax_code` decimal(20,2) DEFAULT NULL,
  `tax_inclusive` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment_vouchers`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `method` varchar(255) DEFAULT NULL,
  `reference` varchar(255) DEFAULT NULL,
  `is_deposit` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `pets`
--

CREATE TABLE `pets` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `guest_id` int(11) DEFAULT NULL,
  `guest_name` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `breed` varchar(255) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `coat_type` varchar(50) DEFAULT NULL,
  `medical_condition` varchar(255) DEFAULT NULL,
  `flea_spot_on` varchar(255) DEFAULT NULL,
  `flea_spot_on_date` date DEFAULT NULL,
  `neutered` int(1) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `vaccine_date` date DEFAULT NULL,
  `vaccine_expiry_date` date DEFAULT NULL,
  `roaming_status` varchar(255) DEFAULT NULL,
  `weight` decimal(10,2) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `vcard` varchar(255) DEFAULT NULL,
  `vcard_cover` varchar(255) DEFAULT NULL,
  `behavior` varchar(255) DEFAULT NULL,
  `deworm` varchar(255) DEFAULT NULL,
  `deworm_date` date DEFAULT NULL,
  `remarks` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=453 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pets`
--

INSERT INTO `pets` VALUES (420,1001,NULL,'Bulan','British Shorthair','Male','Shorthair','none','advocate','2023-03-08',1,'Grey','2023-03-08','2023-03-09','2023-03-10','Fully indoors',5.00,'https://petboss.plexcloud.com/assets/pets/catbg1.png','https://petboss.plexcloud.com/assets/pets/catbg2.png',NULL,'relaxed',NULL,NULL,'test'),(421,1001,NULL,'Ebi','','Male','Longhair','','',NULL,1,'',NULL,NULL,NULL,'',6.00,NULL,NULL,NULL,'','aaaa',NULL,''),(422,1001,NULL,'Mochi',NULL,'Male','Shorthair',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,4.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(429,1002,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(430,1002,NULL,'test',NULL,'Male','Shorthair',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(431,1003,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(432,1004,NULL,'simba','','0','0',NULL,NULL,NULL,0,'',NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,''),(433,1004,NULL,'amoy','','0','0',NULL,NULL,NULL,0,'',NULL,NULL,NULL,NULL,0.00,NULL,NULL,NULL,NULL,NULL,NULL,''),(434,1005,NULL,'poppy','domestic long hair','Male','Longhair',NULL,NULL,NULL,0,'black and white',NULL,NULL,NULL,NULL,2.00,NULL,NULL,NULL,NULL,NULL,NULL,''),(435,1006,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(437,1007,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(439,1009,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(440,1010,NULL,'BULAN','Domestic Shorthair','Male','Shorthair','','',NULL,1,'Grey','2022-12-10','2022-12-10',NULL,'',5.00,'https://petboss.plexcloud.com/assets/pets/Screenshot_2023-03-15_at_10.19.50_PM.png','https://petboss.plexcloud.com/assets/pets/suite.jpeg','https://petboss.plexcloud.com/assets/pets/premium.jpeg','',NULL,NULL,''),(441,1010,NULL,'Ginger','Domestic Shorthair','Female','0','','',NULL,0,'',NULL,NULL,NULL,'',0.00,'https://petboss.plexcloud.com/assets/pets/Screenshot_2023-03-15_at_11.24.30_PM.png',NULL,NULL,'',NULL,NULL,''),(442,1010,NULL,'Test','','0','0','','',NULL,0,'',NULL,NULL,NULL,'',0.00,NULL,NULL,NULL,'',NULL,NULL,''),(443,1001,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(444,1014,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(445,1014,NULL,'test',NULL,'Male','Shorthair',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(446,1015,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(447,1015,NULL,'test',NULL,'Male','Shorthair',NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(448,1016,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(449,1017,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(450,1018,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(451,1019,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(452,1020,NULL,'BULAN','1','Male','Shorthair',NULL,NULL,NULL,1,'Grey','2022-12-10','2022-12-10',NULL,NULL,5.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `pos_sale_items`
--

CREATE TABLE `pos_sale_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `sale_id` int(11) DEFAULT NULL,
  `item_id` int(11) DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `unit_price` decimal(20,2) DEFAULT NULL,
  `qty` int(11) DEFAULT NULL,
  `subtotal` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `discount` varchar(10) DEFAULT NULL,
  `discount_amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pos_sale_items`
--

INSERT INTO `pos_sale_items` VALUES (88,49,55,'Nutrilick',3.50,1,3.50,3.50,'0',0.00,'Complete'),(89,50,55,'Nutrilick',3.50,1,3.50,3.50,'0',0.00,'Complete'),(90,51,55,'Nutrilick',3.50,1,3.50,3.50,'0',0.00,'Complete'),(91,52,51,'Late Checkout',20.00,1,20.00,20.00,'0',0.00,'Complete'),(92,52,47,'Neutering - Female Cat',160.00,2,320.00,320.00,'0',0.00,'Complete'),(93,52,48,'Neutering - Male Cat',100.00,4,400.00,400.00,'0',0.00,'Complete'),(94,53,51,'Late Checkout',20.00,1,20.00,20.00,'0',0.00,'Complete'),(95,53,47,'Neutering - Female Cat',160.00,3,480.00,480.00,'0',0.00,'Complete'),(96,53,44,'Ubat Kutu / Ubat Cacing - Above 4kg',65.00,1,65.00,65.00,'0',0.00,'Complete'),(97,54,47,'Neutering - Female Cat',160.00,2,320.00,320.00,'0',0.00,'Complete'),(98,54,48,'Neutering - Male Cat',100.00,1,100.00,100.00,'0',0.00,'Complete'),(99,54,44,'Ubat Kutu / Ubat Cacing - Above 4kg',65.00,1,65.00,65.00,'0',0.00,'Complete'),(100,55,51,'Late Checkout',20.00,2,40.00,40.00,'0',0.00,'Complete'),(101,55,48,'Neutering - Male Cat',100.00,1,100.00,95.00,'5%',5.00,'Complete'),(102,55,44,'Ubat Kutu / Ubat Cacing - Above 4kg',65.00,1,65.00,65.00,'0',0.00,'Complete'),(103,56,10,'Grooming Adult - Long Hair',60.00,1,60.00,60.00,'0',0.00,'Complete'),(104,56,9,'Grooming Adult - Short Hair',50.00,1,50.00,50.00,'0',0.00,'Complete'),(105,57,10,'Grooming Adult - Long Hair',60.00,2,120.00,114.00,'5%',6.00,'Complete'),(106,57,9,'Grooming Adult - Short Hair',50.00,2,100.00,100.00,'0',0.00,'Complete'),(107,58,9,'Grooming Adult - Short Hair',50.00,1,50.00,50.00,'0',0.00,'Complete'),(108,58,10,'Grooming Adult - Long Hair',60.00,1,60.00,60.00,'0',0.00,'Complete');

--
-- Table structure for table `pos_sales`
--

CREATE TABLE `pos_sales` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `datetime` datetime DEFAULT NULL,
  `pos_datetime` datetime DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  `customer_id` int(11) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `payment_method` varchar(20) DEFAULT NULL,
  `payment_type` varchar(20) DEFAULT NULL,
  `tendered_amount` decimal(20,2) DEFAULT NULL,
  `change_amount` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `rounding` decimal(20,2) DEFAULT NULL,
  `subtotal` decimal(20,2) DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `discount` varchar(20) DEFAULT NULL,
  `discount_amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `points` int(11) DEFAULT NULL,
  `void_datetime` datetime DEFAULT NULL,
  `void_by` varchar(255) DEFAULT NULL,
  `void_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `pos_sales`
--

INSERT INTO `pos_sales` VALUES (49,'2023-03-17 08:27:58','2023-03-17 08:27:58',10016,'Shafiq Petboss',NULL,NULL,'TNG','eWallet',3.50,0.00,3.50,0.00,3.50,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(50,'2023-03-17 08:29:01','2023-03-17 08:29:01',10016,'Shafiq Petboss',NULL,NULL,'MasterCard','Credit Card',3.50,0.00,3.50,0.00,3.50,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(51,'2023-03-17 08:29:09','2023-03-17 08:29:09',10016,'Shafiq Petboss',NULL,NULL,'TNG','eWallet',3.50,0.00,3.50,0.00,3.50,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(52,'2023-03-18 09:14:15','2023-03-18 09:14:15',NULL,' ',NULL,NULL,'Cash','Cash',1000.00,260.00,740.00,0.00,740.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(53,'2023-03-20 23:06:03','2023-03-20 23:06:02',10016,'Shafiq Petboss',NULL,NULL,'MAE','eWallet',565.00,0.00,565.00,0.00,565.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(54,'2023-03-22 21:07:42','2023-03-22 21:07:41',10016,'Shafiq Petboss',NULL,NULL,'Cash','Cash',500.00,15.00,485.00,0.00,485.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(55,'2023-03-23 11:56:25','2023-03-23 11:56:25',10016,'Shafiq Petboss',NULL,NULL,'Cash','Cash',200.00,0.00,200.00,0.00,200.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(56,'2023-03-29 11:34:13','2023-03-29 11:34:13',10016,'Shafiq Petboss',NULL,NULL,'Cash','Cash',110.00,0.00,110.00,0.00,110.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(57,'2023-03-29 16:45:56','2023-03-29 16:45:55',10016,'Shafiq Petboss',NULL,NULL,'MAE','eWallet',214.00,0.00,214.00,0.00,214.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL),(58,'2023-03-29 16:47:37','2023-03-29 16:47:37',10016,'Shafiq Petboss',NULL,NULL,'MasterCard','Credit Card',110.00,0.00,110.00,0.00,110.00,0.00,'',0.00,'Complete',NULL,NULL,NULL,NULL);

--
-- Table structure for table `public_holidays`
--

CREATE TABLE `public_holidays` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `description` varchar(255) DEFAULT '',
  `rate_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `public_holidays`
--


--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `category` int(11) DEFAULT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `rate_single_first` decimal(20,2) DEFAULT NULL,
  `rate_single` decimal(20,2) DEFAULT NULL,
  `rate_day` decimal(20,2) DEFAULT NULL,
  `weekend_rate_day` decimal(20,2) DEFAULT NULL,
  `weekend_rate` decimal(20,2) DEFAULT NULL,
  `weekend_rate_single_first` decimal(20,2) DEFAULT NULL,
  `weekend_rate_single` decimal(20,2) DEFAULT NULL,
  `agent_rate` decimal(20,2) DEFAULT NULL,
  `agent_weekend_rate` decimal(20,2) DEFAULT NULL,
  `govt_rate` decimal(20,2) DEFAULT NULL,
  `govt_weekend_rate` decimal(20,2) DEFAULT NULL,
  `promo_rate` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate` decimal(20,2) DEFAULT NULL,
  `promo_rate_single_first` decimal(20,2) DEFAULT NULL,
  `promo_rate_single` decimal(20,2) DEFAULT NULL,
  `promo_rate_day` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate_single_first` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate_single` decimal(20,2) DEFAULT NULL,
  `promo_weekend_rate_day` decimal(20,2) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `agency` varchar(255) DEFAULT NULL,
  `pet_count` int(11) DEFAULT NULL,
  `agency_id` int(11) DEFAULT NULL,
  `promo_status` int(11) DEFAULT NULL,
  `remarks` text,
  `bulk` int(11) DEFAULT NULL,
  `peak` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rates`
--

INSERT INTO `rates` VALUES (8,'2022-01-01','2023-12-31',26,30.00,20.00,10.00,30.00,30.00,30.00,20.00,10.00,NULL,NULL,NULL,NULL,25.00,25.00,20.00,10.00,0.00,20.00,10.00,0.00,NULL,NULL,0,NULL,2,NULL,0,'',1,NULL),(9,'2022-01-01','2023-12-31',25,80.00,20.00,10.00,0.00,0.00,80.00,20.00,10.00,NULL,NULL,NULL,NULL,60.00,60.00,20.00,10.00,0.00,20.00,10.00,0.00,NULL,NULL,0,NULL,3,NULL,0,'',1,1),(14,'2023-02-01','2023-03-31',28,100.00,10.00,10.00,0.00,0.00,100.00,10.00,10.00,NULL,NULL,NULL,NULL,100.00,100.00,10.00,10.00,0.00,10.00,10.00,0.00,NULL,NULL,0,NULL,NULL,NULL,0,'',0,NULL),(15,'2023-04-19','2023-04-28',25,90.00,20.00,10.00,0.00,0.00,90.00,20.00,10.00,NULL,NULL,NULL,NULL,70.00,70.00,20.00,10.00,0.00,20.00,10.00,0.00,NULL,NULL,1,NULL,NULL,NULL,0,'RAYA',1,1);

--
-- Table structure for table `receipt`
--

CREATE TABLE `receipt` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `cost` decimal(20,2) DEFAULT NULL,
  `amount_receivable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `amount_fees` double(20,2) DEFAULT NULL,
  `amount_effective` double(20,2) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `void_date` datetime DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `tax_code` varchar(32) DEFAULT NULL,
  `tax_inclusive` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt`
--


--
-- Table structure for table `receipt_breakdown`
--

CREATE TABLE `receipt_breakdown` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `receipt_id` int(11) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `amount_fees` decimal(20,2) DEFAULT NULL,
  `amount_effective` double(20,2) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `payment_reference` varchar(128) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `description` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt_breakdown`
--


--
-- Table structure for table `receipt_items`
--

CREATE TABLE `receipt_items` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `receipt_id` int(11) DEFAULT NULL,
  `account_id` int(11) DEFAULT NULL,
  `account` varchar(128) DEFAULT NULL,
  `po_id` int(11) DEFAULT NULL,
  `cn_id` int(11) DEFAULT NULL,
  `dn_id` int(11) DEFAULT NULL,
  `invoice_id` int(11) DEFAULT NULL,
  `asset_id` int(11) DEFAULT NULL,
  `reference` varchar(128) DEFAULT NULL,
  `contact_id` int(11) DEFAULT NULL,
  `contact` varchar(128) DEFAULT NULL,
  `description` text,
  `datetime` datetime DEFAULT NULL,
  `amount_receivable` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipt_items`
--


--
-- Table structure for table `receipts`
--

CREATE TABLE `receipts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `datetime` datetime DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `checkin_id` int(11) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `tax` decimal(20,2) DEFAULT NULL,
  `tax_percentage` varchar(128) DEFAULT NULL,
  `grand_total` decimal(20,2) DEFAULT NULL,
  `tendered` decimal(20,2) DEFAULT NULL,
  `change` decimal(20,2) DEFAULT NULL,
  `card_type` int(11) DEFAULT NULL,
  `reference_no` varchar(128) DEFAULT NULL,
  `staff_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10001 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `receipts`
--


--
-- Table structure for table `reservation_notes`
--

CREATE TABLE `reservation_notes` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group` varchar(128) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  `note` text,
  `added_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reservation_notes`
--


--
-- Table structure for table `reservations`
--

CREATE TABLE `reservations` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `prefix` varchar(128) DEFAULT NULL,
  `group` varchar(128) DEFAULT NULL,
  `type` varchar(128) DEFAULT NULL,
  `pets` varchar(255) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `eci_time` varchar(255) DEFAULT NULL,
  `eco_time` varchar(255) DEFAULT NULL,
  `guest_id` int(11) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `amount` decimal(20,2) DEFAULT NULL,
  `paid_amount` double(20,2) DEFAULT NULL,
  `deposit_amount` decimal(20,2) DEFAULT NULL,
  `rate_type` varchar(120) DEFAULT NULL,
  `agent_type` varchar(120) DEFAULT NULL,
  `payment_method` varchar(128) DEFAULT NULL,
  `date_transfer` date DEFAULT NULL,
  `ref_no` varchar(100) DEFAULT NULL,
  `mid` varchar(100) DEFAULT NULL,
  `booking_id` varchar(150) DEFAULT NULL,
  `remarks` varchar(128) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `room_number` int(11) DEFAULT NULL,
  `cancel_reason` text,
  `category` varchar(255) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `created_by` int(11) DEFAULT NULL,
  `online_payment_id` varchar(255) DEFAULT NULL,
  `online_payment_data` text,
  `online_payment_completed` int(1) DEFAULT NULL,
  `seen` int(1) DEFAULT NULL,
  `channel` varchar(30) DEFAULT NULL,
  `peak` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10106 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `reservations`
--

INSERT INTO `reservations` VALUES (10001,NULL,'16768578868624','BOARDING','[423,424,425]','2023-02-20','2023-02-21',NULL,NULL,1001,'Cancelled',210.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-20 09:51:26',NULL,NULL,'null',1,NULL,NULL,NULL),(10002,NULL,'16768585782752','BOARDING','[\"420\",\"421\",\"422\"]','2023-02-20','2023-02-21','','',1001,'Cancelled',180.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-20 10:02:58',10016,NULL,NULL,NULL,1,NULL,NULL),(10003,NULL,'16768586633916','BOARDING','[426,427,428]','2023-02-20','2023-02-21',NULL,NULL,1001,'Cancelled',180.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-20 10:04:23',NULL,NULL,'null',1,NULL,NULL,NULL),(10004,NULL,'16768599845812','BOARDING','[\"420\",\"422\",\"421\"]','2023-02-20','2023-02-21',NULL,NULL,1001,'Cancelled',180.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-20 10:26:24',NULL,NULL,'null',1,NULL,NULL,NULL),(10005,NULL,'16768605668593','BOARDING','[\"420\",\"421\",\"422\"]','2023-02-20','2023-02-21',NULL,NULL,1001,'Confirmed',180.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-20 10:36:06',NULL,NULL,'null',1,NULL,NULL,NULL),(10006,NULL,'16769416035763','BOARDING','[\"420\"]','2023-02-21','2023-02-22',NULL,NULL,1001,'Confirmed',80.00,80.00,0.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-21 09:06:43',NULL,'ivhpp4iy','{\"id\":\"ivhpp4iy\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":8000,\"paid_amount\":8000,\"due_at\":\"2023-2-21\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/ivhpp4iy\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10006\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10006\",\"description\":\"Petboss Main Branch Reservation BKG-10006\",\"paid_at\":\"2023-02-21T09:06:57.390+08:00\"}',1,NULL,NULL,NULL),(10007,NULL,'16769680203670','BOARDING','[429,430]','2023-02-21','2023-02-22',NULL,NULL,1002,'Checked Out',115.00,115.00,0.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-21 16:27:00',NULL,'d80pgbr2','{\"id\":\"d80pgbr2\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":6000,\"paid_amount\":6000,\"due_at\":\"2023-2-21\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/d80pgbr2\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10007\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10007\",\"description\":\"Petboss Main Branch Reservation BKG-10007\",\"paid_at\":\"2023-02-21T16:27:11.260+08:00\"}',1,NULL,NULL,NULL),(10008,NULL,'16772953612870','BOARDING','[431]','2023-02-25','2023-02-26',NULL,NULL,1003,'Checked Out',205.00,205.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-25 11:22:41',NULL,NULL,'null',1,NULL,NULL,NULL),(10009,NULL,'16772967802781','BOARDING','[\"421\",\"422\"]','2023-02-25','2023-02-26','','',1001,'Confirmed',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-25 11:46:20',10016,NULL,NULL,NULL,1,NULL,NULL),(10010,NULL,'16772971846199','BOARDING','[\"432\",\"433\"]','2023-02-25','2023-02-27','','',1004,'Checked Out',200.00,200.00,NULL,'Normal',NULL,'TNG',NULL,NULL,NULL,'','deposit ',NULL,NULL,NULL,NULL,'2023-02-25 11:53:04',10016,NULL,NULL,NULL,1,NULL,NULL),(10011,NULL,'16772973978240','GROOMING','[\"432\"]','2023-02-25','2023-02-25','','',1004,'Checked Out',60.00,60.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-25 11:56:37',10016,NULL,NULL,NULL,1,NULL,NULL),(10012,NULL,'16772980494710','BOARDING','[\"434\"]','2023-02-25','2023-02-26','','',1005,'Checked Out',123.00,123.00,NULL,'promo_',NULL,'MasterCard',NULL,NULL,'-','','',NULL,NULL,NULL,NULL,'2023-02-25 12:03:08',10016,NULL,NULL,NULL,1,NULL,NULL),(10013,NULL,'16772978839522','GROOMING','[\"434\"]','2023-02-26','2023-02-26','','',1005,'Confirmed',30.00,30.00,NULL,'promo_',NULL,'MasterCard',NULL,NULL,'-','','',NULL,NULL,NULL,NULL,'2023-02-25 12:04:43',10016,NULL,NULL,NULL,1,NULL,NULL),(10014,NULL,'16772980494710','GROOMING','[\"434\"]','2023-02-25','2023-02-25','','',1005,'Checked Out',123.00,123.00,NULL,'promo_',NULL,'MasterCard',NULL,NULL,'-','','',NULL,NULL,NULL,NULL,'2023-02-25 12:06:32',10016,NULL,NULL,NULL,1,NULL,NULL),(10015,NULL,'16773079424582','BOARDING','[435]','2023-02-25','2023-02-26',NULL,NULL,1006,'Confirmed',60.00,50.00,50.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-25 14:52:22',NULL,'toy1mbou','{\"id\":\"toy1mbou\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":5000,\"paid_amount\":5000,\"due_at\":\"2023-2-25\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/toy1mbou\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10015\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10015\",\"description\":\"Petboss Main Branch Reservation BKG-10015\",\"paid_at\":\"2023-02-25T14:52:37.747+08:00\"}',1,NULL,NULL,NULL),(10016,NULL,'16773091377487','BOARDING','[\"420\",\"421\"]','2023-02-25','2023-02-26','','',1001,'Checked Out',225.00,225.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-25 15:12:17',10016,NULL,NULL,NULL,1,NULL,NULL),(10017,NULL,'16774619485307','BOARDING','[\"420\",\"421\",\"422\"]','2023-02-27','2023-02-28','','',1001,'Cancelled',110.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-27 09:39:08',10016,NULL,NULL,NULL,1,NULL,NULL),(10018,NULL,'16774645125637','BOARDING','[\"420\",\"421\"]','2023-02-27','2023-02-28','','',1001,'Cancelled',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-27 10:21:52',10016,NULL,NULL,NULL,1,NULL,NULL),(10019,NULL,'16774646947417','BOARDING','[\"420\",\"421\",\"422\"]','2023-02-27','2023-02-28','','',1001,'Cancelled',110.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-27 10:24:54',10016,NULL,NULL,NULL,1,NULL,NULL),(10020,NULL,'16774691653398','BOARDING','[\"420\",\"421\",\"422\"]','2023-02-27','2023-02-28','','',1001,'Cancelled',180.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-02-27 11:39:25',10016,NULL,NULL,NULL,1,NULL,NULL),(10021,NULL,'16775421844424','GROOMING','[437]','2023-02-28','2023-02-28',NULL,NULL,1007,'Cancelled',50.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-28 07:56:24',NULL,NULL,'null',1,NULL,NULL,NULL),(10022,NULL,'16775443638038','GROOMING','[438]','2023-02-28','2023-02-28',NULL,NULL,1008,'Confirmed',135.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-02-28 08:32:43',NULL,NULL,'null',1,NULL,NULL,NULL),(10023,NULL,'16775866322307','BOARDING','[439]','2023-02-28','2023-03-01',NULL,NULL,1009,'Checked Out',305.00,305.00,0.00,'Normal',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-28 20:17:12',NULL,'dnaodsf8','{\"id\":\"dnaodsf8\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":8000,\"paid_amount\":8000,\"due_at\":\"2023-2-28\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/dnaodsf8\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10023\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10023\",\"description\":\"Petboss Main Branch Reservation BKG-10023\",\"paid_at\":\"2023-02-28T20:17:25.330+08:00\"}',1,NULL,NULL,NULL),(10024,NULL,'16792806298102','BOARDING','[\"420\",\"421\",\"422\"]','2023-02-28','2023-03-01','','',1001,'Checked Out',820.00,820.00,NULL,'Normal',NULL,'Cash',NULL,NULL,NULL,'','deposit',NULL,NULL,NULL,NULL,'2023-02-28 20:36:47',10016,NULL,NULL,NULL,1,NULL,NULL),(10025,NULL,'16777277909002','BOARDING','[440]','2023-03-02','2023-03-03',NULL,NULL,1010,'Checked Out',165.00,165.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-02 11:29:50',NULL,NULL,'null',1,NULL,NULL,NULL),(10026,NULL,'16792806298102','BOARDING','[\"421\",\"422\"]','2023-03-02','2023-03-06','','',1001,'Checked Out',820.00,820.00,NULL,'Normal',NULL,'VISA',NULL,NULL,'-','','',NULL,NULL,NULL,NULL,'2023-03-02 11:45:42',10016,NULL,NULL,NULL,1,NULL,NULL),(10027,NULL,'16789247175927','BOARDING','[\"440\"]','2023-03-16','2023-03-17','','',1010,'Confirmed',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-16 07:58:37',10016,NULL,NULL,NULL,1,NULL,NULL),(10028,NULL,'16789348721005','GROOMING','[\"440\"]','2023-03-16','2023-03-16','','',1010,'Confirmed',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-16 10:47:52',10016,NULL,NULL,NULL,1,NULL,NULL),(10029,NULL,'16790106198636','BOARDING','[\"420\"]','2023-03-17','2023-03-18',NULL,NULL,1001,'Hold',60.00,0.00,-20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-17 07:50:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10030,NULL,'16790106572679','BOARDING','[\"420\"]','2023-03-17','2023-03-18',NULL,NULL,1001,'Confirmed',60.00,60.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-17 07:50:57',NULL,'j5f4pslz','{\"id\":\"j5f4pslz\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-17\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/j5f4pslz\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10030\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10030\",\"description\":\"Petboss Main Branch Reservation BKG-10030 Deposit\",\"paid_at\":\"2023-03-17T07:51:09.563+08:00\"}',1,NULL,NULL,NULL),(10031,NULL,'16790107398509','BOARDING','[\"420\"]','2023-03-17','2023-03-18',NULL,NULL,1001,'Confirmed',60.00,60.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-17 07:52:19',NULL,'0mtozy1r','{\"id\":\"0mtozy1r\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-17\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/0mtozy1r\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10031\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10031\",\"description\":\"Petboss Main Branch Reservation BKG-10031 Deposit\",\"paid_at\":\"2023-03-17T07:52:31.009+08:00\"}',1,NULL,NULL,NULL),(10032,NULL,'16790108793709','BOARDING','[\"420\"]','2023-03-17','2023-03-18',NULL,NULL,1001,'Confirmed',60.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-17 07:54:39',NULL,'9x5mzpzw','{\"id\":\"9x5mzpzw\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-17\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/9x5mzpzw\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10032\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10032\",\"description\":\"Petboss Main Branch Reservation BKG-10032 Deposit\",\"paid_at\":\"2023-03-17T07:54:49.801+08:00\"}',1,NULL,NULL,NULL),(10033,NULL,'16790112104384','BOARDING','[\"420\"]','2023-03-17','2023-03-18',NULL,NULL,1001,'Confirmed',60.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-17 08:00:10',NULL,'mj1r80b2','{\"id\":\"mj1r80b2\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-17\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/mj1r80b2\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10033\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10033\",\"description\":\"Petboss Main Branch Reservation BKG-10033 Deposit\",\"paid_at\":\"2023-03-17T08:00:20.919+08:00\"}',1,NULL,NULL,NULL),(10034,NULL,'16790115805068','GROOMING','[443]','2023-03-17','2023-03-17',NULL,NULL,1001,'Confirmed',50.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-17 08:06:20',NULL,'bitryqvf','{\"id\":\"bitryqvf\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-17\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/bitryqvf\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10034\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10034\",\"description\":\"Petboss Main Branch Reservation BKG-10034 Deposit\",\"paid_at\":\"2023-03-17T08:06:30.890+08:00\"}',1,NULL,NULL,NULL),(10035,NULL,'16792467043180','GROOMING','[444,445]','2023-03-20','2023-03-20',NULL,NULL,1014,'Cancelled',100.00,0.00,40.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 01:25:04',NULL,NULL,'null',1,NULL,NULL,NULL),(10036,NULL,'16792468388409','GROOMING','[446,447]','2023-03-20','2023-03-20',NULL,NULL,1015,'Cancelled',100.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 01:27:18',NULL,NULL,'null',1,NULL,NULL,NULL),(10037,NULL,'16792799261499','GROOMING','[448]','2023-03-20','2023-03-20',NULL,NULL,1016,'Cancelled',50.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 10:38:47',NULL,NULL,'null',1,NULL,NULL,NULL),(10038,NULL,'16792800259708','GROOMING','[449]','2023-03-20','2023-03-20',NULL,NULL,1017,'Cancelled',50.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 10:40:25',NULL,NULL,'null',1,NULL,NULL,NULL),(10039,NULL,'16792802282352','GROOMING','[450]','2023-03-20','2023-03-20',NULL,NULL,1018,'Cancelled',50.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 10:43:48',NULL,NULL,'null',1,NULL,NULL,NULL),(10040,NULL,'16792805801205','GROOMING','[451]','2023-03-20','2023-03-20',NULL,NULL,1019,'Cancelled',50.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 10:49:40',NULL,NULL,'null',1,NULL,NULL,NULL),(10041,NULL,'16792809859891','GROOMING','[452]','2023-03-20','2023-03-20',NULL,NULL,1020,'Confirmed',50.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 10:56:25',NULL,NULL,'null',1,NULL,NULL,NULL),(10042,NULL,'16793051505194','BOARDING','[\"420\"]','2023-03-20','2023-03-21',NULL,NULL,1001,'Confirmed',60.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 17:39:10',NULL,'woayogsr','{\"id\":\"woayogsr\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-20\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/woayogsr\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10042\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10042\",\"description\":\"Petboss Main Branch Reservation BKG-10042 Deposit\",\"paid_at\":\"2023-03-20T17:39:21.623+08:00\"}',1,NULL,NULL,NULL),(10043,NULL,'16793054459370','BOARDING','[\"420\"]','2023-03-20','2023-03-21',NULL,NULL,1001,'Confirmed',220.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-20 17:44:05',NULL,NULL,'null',1,NULL,NULL,NULL),(10044,NULL,'16795429306680','BOARDING','[\"420\",\"421\"]','2023-03-23','2023-03-24',NULL,NULL,1001,'Checked Out',230.00,230.00,40.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-23 11:42:10',NULL,'ocps31sr','{\"id\":\"ocps31sr\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":4000,\"paid_amount\":4000,\"due_at\":\"2023-3-23\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/ocps31sr\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10044\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10044\",\"description\":\"Petboss Main Branch Reservation BKG-10044 Deposit\",\"paid_at\":\"2023-03-23T11:42:29.289+08:00\"}',1,NULL,NULL,NULL),(10045,NULL,'16795435597631','BOARDING','[\"440\",\"441\"]','2023-03-23','2023-03-24','','',1010,'Confirmed',165.00,25.00,NULL,'Normal',NULL,'Cash',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-23 11:52:39',10016,NULL,NULL,NULL,1,NULL,NULL),(10046,NULL,'16801225239438','GROOMING','[\"421\"]','2023-03-23','2023-03-23',NULL,NULL,1001,'Checked Out',380.00,380.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-23 11:58:23',NULL,NULL,'null',1,NULL,NULL,NULL),(10047,NULL,'16797170013589','BOARDING','[\"420\",\"421\"]','2023-03-25','2023-03-26','','',1001,'Confirmed',160.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-25 12:03:21',10016,NULL,NULL,NULL,1,NULL,NULL),(10048,NULL,'16798037257320','GROOMING','[\"420\"]','2023-03-26','2023-03-26','','',1001,'Confirmed',65.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-26 12:08:45',10016,NULL,NULL,NULL,1,NULL,NULL),(10049,NULL,'16800593524506','BOARDING','[\"420\",\"421\"]','2023-03-29','2023-03-30',NULL,NULL,1001,'Confirmed',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-29 11:09:12',10016,NULL,NULL,NULL,1,NULL,NULL),(10050,NULL,'16801225239438','BOARDING','[\"420\"]','2023-03-30','2023-04-05',NULL,NULL,1001,'Checked Out',380.00,380.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-29 11:26:23',NULL,'ed9i2skv','{\"id\":\"ed9i2skv\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-29\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/ed9i2skv\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10050\\/default\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10050\\/default\",\"description\":\"Petboss Main Branch Reservation BKG-10050 Deposit\",\"paid_at\":\"2023-03-29T11:26:39.761+08:00\"}',1,NULL,NULL,NULL),(10051,NULL,'16800656104752','BOARDING','[\"420\"]','2023-03-29','2023-03-30',NULL,NULL,1001,'Confirmed',60.00,0.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-29 12:53:30',NULL,'qqvgniwr','{\"id\":\"qqvgniwr\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-29\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/qqvgniwr\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10051\\/default\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10051\\/default\",\"description\":\"Petboss Main Branch Reservation BKG-10051 Deposit\",\"paid_at\":\"2023-03-29T12:53:59.434+08:00\"}',1,NULL,NULL,NULL),(10052,NULL,'16800657967686','BOARDING','[\"421\"]','2023-03-29','2023-03-30',NULL,NULL,1001,'Confirmed',60.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-29 12:56:36',NULL,'6cqzyjpl','{\"id\":\"6cqzyjpl\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-29\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/6cqzyjpl\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10052\\/default\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10052\\/default\",\"description\":\"Petboss Main Branch Reservation BKG-10052 Deposit\",\"paid_at\":\"2023-03-29T12:56:47.932+08:00\"}',1,NULL,NULL,NULL),(10053,NULL,'16800779486416','BOARDING','[\"420\"]','2023-03-29','2023-03-30',NULL,NULL,1001,'Confirmed',145.00,20.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-29 16:19:08',NULL,'vhjwsi0t','{\"id\":\"vhjwsi0t\",\"collection_id\":\"4y46pxwx\",\"paid\":true,\"state\":\"paid\",\"amount\":2000,\"paid_amount\":2000,\"due_at\":\"2023-3-29\",\"email\":\"shafiq.rizwan@gmail.com\",\"mobile\":null,\"name\":\"SHAFIQ RIZWAN\",\"url\":\"https:\\/\\/www.billplz-sandbox.com\\/bills\\/vhjwsi0t\",\"reference_1_label\":\"Reference 1\",\"reference_1\":null,\"reference_2_label\":\"Reference 2\",\"reference_2\":null,\"redirect_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10053\\/default\",\"callback_url\":\"https:\\/\\/petboss.plexcloud.com\\/api\\/payment_callback\\/10053\\/default\",\"description\":\"Petboss Main Branch Reservation BKG-10053 Deposit\",\"paid_at\":\"2023-03-29T16:19:18.977+08:00\"}',1,NULL,NULL,NULL),(10054,NULL,'16800783307974','BOARDING','[\"420\"]','2023-03-29','2023-03-30',NULL,NULL,1001,'Checked Out',80.00,80.00,NULL,'Normal',NULL,'MAE',NULL,NULL,NULL,'','DEPOSIT',NULL,NULL,NULL,NULL,'2023-03-29 16:25:30',10016,NULL,NULL,NULL,1,NULL,NULL),(10055,NULL,'16800789033036','GROOMING','[\"420\"]','2023-03-29','2023-03-29',NULL,NULL,1001,'Confirmed',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-29 16:35:03',10016,NULL,NULL,NULL,1,NULL,NULL),(10056,NULL,'16801185645018','BOARDING','[\"420\"]','2023-03-30','2023-03-31',NULL,NULL,1001,'Cancelled',60.00,0.00,0.00,'Normal',NULL,'hotel',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-30 03:36:04',NULL,NULL,'null',1,NULL,NULL,NULL),(10057,NULL,'16801226732775','BOARDING','[\"420\"]','2023-03-30','2023-03-31',NULL,NULL,1001,'Cancelled',80.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 04:44:33',10016,NULL,NULL,NULL,1,NULL,NULL),(10058,NULL,'16801227369174','BOARDING','[\"420\"]','2023-03-30','2023-03-31',NULL,NULL,1001,'Checked Out',90.00,90.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 04:45:36',10016,NULL,NULL,NULL,1,NULL,NULL),(10059,NULL,'16801265535888','GROOMING','[\"420\",\"421\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',220.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 05:49:13',10016,NULL,NULL,NULL,1,NULL,NULL),(10060,NULL,'16801266178168','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',135.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 05:50:17',10016,NULL,NULL,NULL,1,NULL,NULL),(10061,NULL,'16801272126108','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 06:00:12',10016,NULL,NULL,NULL,1,NULL,NULL),(10062,NULL,'16801326988588','GROOMING','[\"420\",\"421\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',75.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 07:31:38',10016,NULL,NULL,NULL,1,NULL,NULL),(10063,NULL,'16801330827523','GROOMING','[\"420\",\"421\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',70.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 07:38:02',10016,NULL,NULL,NULL,1,NULL,NULL),(10064,NULL,'16801334323453','GROOMING','[\"420\",\"421\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',85.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 07:43:52',10016,NULL,NULL,NULL,1,NULL,NULL),(10065,NULL,'16801360784613','GROOMING','[\"420\",\"421\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Checked Out',235.00,235.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 07:46:16',10016,NULL,NULL,NULL,1,NULL,NULL),(10066,NULL,'16801339347936','GROOMING','[\"420\",\"421\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',75.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 07:52:14',10016,NULL,NULL,NULL,1,NULL,NULL),(10067,NULL,'16801352984590','BOARDING','[\"420\"]','2023-03-30','2023-03-31',NULL,NULL,1001,'Cancelled',260.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 08:14:58',10016,NULL,NULL,NULL,1,NULL,NULL),(10068,NULL,'16801360784613','BOARDING','[\"420\",\"421\"]','2023-03-30','2023-03-31',NULL,NULL,1001,'Checked Out',235.00,235.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 08:25:42',10016,NULL,NULL,NULL,1,NULL,NULL),(10069,NULL,'16801359749474','GROOMING','[\"420\",\"421\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 08:26:14',10016,NULL,NULL,NULL,1,NULL,NULL),(10070,NULL,'16801601799070','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',100.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:09:39',10016,NULL,NULL,NULL,1,NULL,NULL),(10071,NULL,'16801602241913','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',25.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:10:24',10016,NULL,NULL,NULL,1,NULL,NULL),(10072,NULL,'16801604213654','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',35.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:13:41',10016,NULL,NULL,NULL,1,NULL,NULL),(10073,NULL,'16801608101990','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:20:10',10016,NULL,NULL,NULL,1,NULL,NULL),(10074,NULL,'16801612699843','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:27:49',10016,NULL,NULL,NULL,1,NULL,NULL),(10075,NULL,'16801614168468','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:30:16',10016,NULL,NULL,NULL,1,NULL,NULL),(10076,NULL,'16801615815966','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',35.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:33:01',10016,NULL,NULL,NULL,1,NULL,NULL),(10077,NULL,'16801618017261','GROOMING','[\"420\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Cancelled',202.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 15:36:41',10016,NULL,NULL,NULL,1,NULL,NULL),(10078,NULL,'16801656779232','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',179.00,179.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 16:41:17',10016,NULL,NULL,NULL,1,NULL,NULL),(10079,NULL,'16801768331238','GROOMING','[\"420\",\"421\"]','2023-03-30','2023-03-30',NULL,NULL,1001,'Confirmed',110.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 19:47:13',10016,NULL,NULL,NULL,1,NULL,NULL),(10080,NULL,'16801769078013','BOARDING','[\"420\",\"421\"]','2023-03-30','2023-03-31',NULL,NULL,1001,'Cancelled',304.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-30 19:48:27',10016,NULL,NULL,NULL,1,NULL,NULL),(10081,NULL,'16802117157828','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Hold',50.00,0.00,20.00,'Normal',NULL,'online',NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,'2023-03-31 05:28:35',NULL,'i9ebaurr',NULL,NULL,NULL,NULL,NULL),(10082,NULL,'16802141794690','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',60.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:09:39',10016,NULL,NULL,NULL,1,NULL,NULL),(10083,NULL,'16802143636383','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:12:43',10016,NULL,NULL,NULL,1,NULL,NULL),(10084,NULL,'16802143983187','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:13:18',10016,NULL,NULL,NULL,1,NULL,NULL),(10085,NULL,'16802144098708','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:13:29',10016,NULL,NULL,NULL,1,NULL,NULL),(10086,NULL,'16802144293201','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:13:49',10016,NULL,NULL,NULL,1,NULL,NULL),(10087,NULL,'16802144433471','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:14:03',10016,NULL,NULL,NULL,1,NULL,NULL),(10088,NULL,'16802144599549','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:14:19',10016,NULL,NULL,NULL,1,NULL,NULL),(10089,NULL,'16802144922506','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:14:52',10016,NULL,NULL,NULL,1,NULL,NULL),(10090,NULL,'16802145782156','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:16:18',10016,NULL,NULL,NULL,1,NULL,NULL),(10091,NULL,'16802146778841','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:17:57',10016,NULL,NULL,NULL,1,NULL,NULL),(10092,NULL,'16802147535021','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',0.00,NULL,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:19:13',10016,NULL,NULL,NULL,1,NULL,NULL),(10093,NULL,'16802147633616','GROOMING','[\"420\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Cancelled',50.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 06:19:23',10016,NULL,NULL,NULL,1,NULL,NULL),(10094,NULL,'16802213694412','GROOMING','[\"420\",\"421\"]','2023-03-31','2023-03-31',NULL,NULL,1001,'Confirmed',110.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-03-31 08:09:29',10016,NULL,NULL,NULL,1,NULL,NULL),(10095,NULL,'16803066376933','BOARDING','[\"420\",\"421\"]','2023-04-01','2023-04-02',NULL,NULL,1001,'Cancelled',230.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-01 07:50:37',10016,NULL,NULL,NULL,1,NULL,NULL),(10096,NULL,'16803180818485','BOARDING','[\"420\"]','2023-04-01','2023-04-02',NULL,NULL,1001,'Confirmed',220.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-01 11:01:21',10016,NULL,NULL,NULL,1,NULL,NULL),(10097,NULL,'16803181495907','BOARDING','[\"420\"]','2023-04-17','2023-04-22',NULL,NULL,1001,'Cancelled',630.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-01 11:02:29',10016,NULL,NULL,NULL,1,NULL,NULL),(10098,NULL,'16803312477307','BOARDING','[\"420\"]','2023-04-16','2023-04-24',NULL,NULL,1001,'Cancelled',950.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-01 14:40:47',10016,NULL,NULL,NULL,1,NULL,NULL),(10099,NULL,'16803313058011','BOARDING','[\"420\"]','2023-04-17','2023-04-26',NULL,NULL,1001,'Cancelled',880.00,0.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-01 14:41:45',10016,NULL,NULL,NULL,1,NULL,NULL),(10100,NULL,'16803866005893','BOARDING','[\"420\",\"421\"]','2023-04-17','2023-04-26',NULL,NULL,1001,'Cancelled',0.00,0.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-02 06:03:20',10016,NULL,NULL,NULL,1,NULL,NULL),(10101,NULL,'16803870171020','BOARDING','[\"420\",\"421\"]','2023-04-17','2023-04-29',NULL,NULL,1001,'Cancelled',1060.00,0.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-02 06:10:17',10016,NULL,NULL,NULL,1,NULL,NULL),(10102,NULL,'16803885954794','BOARDING','[\"420\",\"421\",\"422\"]','2023-04-17','2023-04-29',NULL,NULL,1001,'Confirmed',1090.00,0.00,NULL,'promo_',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-02 06:36:35',10016,NULL,NULL,NULL,1,NULL,NULL),(10103,NULL,'16803901415374','BOARDING','[\"420\",\"421\"]','2023-04-02','2023-04-03',NULL,NULL,1001,'Confirmed',160.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-02 07:02:21',10016,NULL,NULL,NULL,1,NULL,NULL),(10104,NULL,'16803913114370','BOARDING','[\"420\",\"421\"]','2023-04-02','2023-04-03',NULL,NULL,1001,'Confirmed',120.00,0.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-02 07:21:51',10016,NULL,NULL,NULL,1,NULL,NULL),(10105,NULL,'16805618615938','BOARDING','[\"429\"]','2023-04-04','2023-04-07',NULL,NULL,1002,'Checked In',240.00,5.00,NULL,'Normal',NULL,'',NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,'2023-04-04 06:44:21',10016,NULL,NULL,NULL,1,NULL,NULL);

--
-- Table structure for table `rooms`
--

CREATE TABLE `rooms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `category` int(11) DEFAULT NULL,
  `floor` int(3) DEFAULT NULL,
  `number` varchar(128) DEFAULT NULL,
  `rsvn_id` int(11) DEFAULT NULL,
  `guest_id` int(11) DEFAULT NULL,
  `check_in` date DEFAULT NULL,
  `check_out` date DEFAULT NULL,
  `added_on` datetime DEFAULT NULL,
  `added_by` varchar(128) DEFAULT NULL,
  `status` varchar(128) DEFAULT NULL,
  `modified_on` datetime DEFAULT NULL,
  `modified_by` varchar(128) DEFAULT NULL,
  `housekeeping_status` varchar(128) DEFAULT NULL,
  `maintenance_status` varchar(128) DEFAULT NULL,
  `wakeup_call` time DEFAULT '00:00:00',
  `remarks` text,
  `grooming` varchar(3) DEFAULT NULL,
  `pos_left` varchar(10) DEFAULT NULL,
  `pos_top` varchar(10) DEFAULT NULL,
  `sort_order` int(5) DEFAULT NULL,
  `time` time DEFAULT NULL,
  `days` varchar(50) DEFAULT NULL,
  `exclude` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rooms`
--

INSERT INTO `rooms` VALUES (118,24,0,'54',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','180',55,NULL,NULL,NULL),(117,24,0,'53',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','100',56,NULL,NULL,NULL),(116,24,0,'52',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','260',57,NULL,NULL,NULL),(115,24,0,'51',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','260',58,NULL,NULL,NULL),(114,24,0,'50',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','180',59,NULL,NULL,NULL),(113,25,0,'64',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'780','20',40,NULL,NULL,NULL),(112,25,0,'63',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','20',41,NULL,NULL,NULL),(111,25,0,'62',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','20',42,NULL,NULL,NULL),(110,25,0,'61',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','100',43,NULL,NULL,NULL),(109,25,0,'49',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','100',44,NULL,NULL,NULL),(108,25,0,'48',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','20',45,NULL,NULL,NULL),(107,25,0,'47',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','20',46,NULL,NULL,NULL),(106,25,0,'46',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','100',47,NULL,NULL,NULL),(105,25,0,'45',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','180',48,NULL,NULL,NULL),(104,25,0,'44',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','260',49,NULL,NULL,NULL),(103,25,0,'43',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','260',50,NULL,NULL,NULL),(102,25,0,'42',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','180',51,NULL,NULL,NULL),(101,25,0,'41',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','100',52,NULL,NULL,NULL),(100,25,0,'40',NULL,1002,'2023-04-04','2023-04-06',NULL,NULL,'Checked In',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','20',53,NULL,NULL,NULL),(99,26,0,'39',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'160','20',3,NULL,NULL,NULL),(98,26,0,'38',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','100',6,NULL,NULL,NULL),(97,26,0,'37',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','180',4,NULL,NULL,NULL),(96,26,0,'36',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','260',1,NULL,NULL,NULL),(95,26,0,'35',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','180',2,NULL,NULL,NULL),(94,26,0,'34',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1240','20',5,NULL,NULL,NULL),(93,26,0,'33',NULL,1001,'2023-03-29','2023-03-30',NULL,NULL,'Checked In',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1240','100',7,NULL,NULL,NULL),(92,26,0,'32',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1240','180',8,NULL,NULL,NULL),(91,26,0,'31',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1240','260',9,NULL,NULL,NULL),(90,26,0,'30',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1120','260',10,NULL,NULL,NULL),(89,26,0,'29',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','180',11,NULL,NULL,NULL),(88,26,0,'28',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'780','180',12,NULL,NULL,NULL),(87,26,0,'27',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1120','180',13,NULL,NULL,NULL),(86,26,0,'26',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1120','100',14,NULL,NULL,NULL),(85,26,0,'25',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1120','20',15,NULL,NULL,NULL),(84,26,0,'24',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','20',16,NULL,NULL,NULL),(83,26,0,'23',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','100',17,NULL,NULL,NULL),(82,26,0,'22',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'1060','180',18,NULL,NULL,NULL),(81,26,0,'21',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','260',19,NULL,NULL,NULL),(80,26,0,'20',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'160','380',20,NULL,NULL,NULL),(79,26,0,'19',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'220','380',21,NULL,NULL,NULL),(78,26,0,'18',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'320','380',22,NULL,NULL,NULL),(77,26,0,'17',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'380','380',23,NULL,NULL,NULL),(76,26,0,'16',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','380',24,NULL,NULL,NULL),(75,26,0,'15',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'580','260',25,NULL,NULL,NULL),(74,26,0,'14',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','260',26,NULL,NULL,NULL),(73,26,0,'13',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1120','380',27,NULL,NULL,NULL),(72,26,0,'12',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'580','380',28,NULL,NULL,NULL),(71,26,0,'11',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1060','380',39,NULL,NULL,NULL),(70,26,0,'10',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'1240','380',38,NULL,NULL,NULL),(69,26,0,'9',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','380',37,NULL,NULL,NULL),(68,26,0,'8',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'840','180',36,NULL,NULL,NULL),(67,26,0,'7',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','20',35,NULL,NULL,NULL),(66,26,0,'6',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','100',34,NULL,NULL,NULL),(65,26,0,'5',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','180',33,NULL,NULL,NULL),(64,26,0,'4',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','260',32,NULL,NULL,NULL),(63,26,0,'3',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'20','380',31,NULL,NULL,NULL),(62,26,0,'2',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'840','100',30,NULL,NULL,NULL),(61,26,0,'1',NULL,NULL,NULL,NULL,NULL,'','Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'840','20',29,NULL,NULL,NULL),(119,24,0,'55',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'460','20',60,NULL,NULL,NULL),(122,25,0,'99',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,NULL,'780','100',54,NULL,NULL,NULL),(124,0,NULL,'12:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,'1','300','20',NULL,'12:30:00','SUN,MON,TUE,WED,THU,FRI,SAT','31'),(128,28,0,'70',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Uncleaned','Operational','00:00:00',NULL,NULL,'640','100',61,NULL,NULL,NULL),(134,0,NULL,'1:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,'1','60','20',NULL,'13:30:00','SUN,MON,TUE,WED,THU,FRI,SAT',NULL),(135,0,NULL,'2:30PM',NULL,NULL,NULL,NULL,NULL,NULL,'Available',NULL,NULL,'Cleaned','Operational','00:00:00',NULL,'1','60','120',NULL,'14:30:00','SUN,MON,TUE,WED,THU,FRI,SAT',NULL);

--
-- Table structure for table `signature`
--

CREATE TABLE `signature` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `rsvn_id` int(11) DEFAULT NULL,
  `signature` longtext,
  `nric` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=216 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `signature`
--

INSERT INTO `signature` VALUES (26,10055,'data:image/png;base64,[BLOB]','1'),(30,10001,'data:image/png;base64,[BLOB]',''),(31,10002,'data:image/png;base64,[BLOB]',''),(32,10003,'data:image/png;base64,[BLOB]',''),(33,10004,'data:image/png;base64,[BLOB]',''),(34,10005,'data:image/png;base64,[BLOB]',''),(35,10006,'data:image/png;base64,[BLOB]',''),(37,10018,'data:image/png;base64,[BLOB]',''),(38,10022,'data:image/png;base64,[BLOB]',''),(39,10035,'data:image/png;base64,[BLOB]',''),(40,10029,'data:image/png;base64,[BLOB]',''),(41,10037,'data:image/png;base64,[BLOB]',''),(43,10043,'data:image/png;base64,[BLOB]',''),(44,10019,'data:image/png;base64,[BLOB]',''),(45,10047,'data:image/png;base64,[BLOB]',''),(48,10051,'data:image/png;base64,[BLOB]',''),(49,10040,'data:image/png;base64,[BLOB]',''),(50,10063,'data:image/png;base64,[BLOB]',''),(51,10062,'data:image/png;base64,[BLOB]',''),(52,10032,'data:image/png;base64,[BLOB]',''),(53,10048,'data:image/png;base64,[BLOB]',''),(54,10045,'data:image/png;base64,[BLOB]',''),(56,10066,'data:image/png;base64,[BLOB]',''),(57,10056,'data:image/png;base64,[BLOB]',''),(59,10070,'data:image/png;base64,[BLOB]',''),(60,10069,'data:image/png;base64,[BLOB]',''),(61,10071,'data:image/png;base64,[BLOB]',''),(62,10074,'data:image/png;base64,[BLOB]',''),(63,10072,'data:image/png;base64,[BLOB]',''),(64,10020,'data:image/png;base64,[BLOB]',''),(65,10073,'data:image/png;base64,[BLOB]',''),(66,10080,'data:image/png;base64,[BLOB]',''),(69,10079,'data:image/png;base64,[BLOB]',''),(70,10081,'data:image/png;base64,[BLOB]',''),(71,10082,'data:image/png;base64,[BLOB]',''),(72,10084,'data:image/png;base64,[BLOB]',''),(73,10083,'data:image/png;base64,[BLOB]',''),(74,10088,'data:image/png;base64,[BLOB]',''),(75,10031,'data:image/png;base64,[BLOB]',''),(76,10042,'data:image/png;base64,[BLOB]',''),(77,10095,'data:image/png;base64,[BLOB]',''),(78,10075,'data:image/png;base64,[BLOB]',''),(79,10036,'data:image/png;base64,[BLOB]',''),(80,10034,'data:image/png;base64,[BLOB]',''),(81,10049,'data:image/png;base64,[BLOB]',''),(82,10096,'data:image/png;base64,[BLOB]',''),(83,10097,'data:image/png;base64,[BLOB]',''),(84,10107,'data:image/png;base64,[BLOB]',''),(85,10108,'data:image/png;base64,[BLOB]',''),(87,10076,'data:image/png;base64,[BLOB]',''),(88,10110,'data:image/png;base64,[BLOB]',''),(89,10111,'data:image/png;base64,[BLOB]',''),(90,10086,'data:image/png;base64,[BLOB]',''),(91,10112,'data:image/png;base64,[BLOB]',''),(92,10113,'data:image/png;base64,[BLOB]',''),(93,10090,'data:image/png;base64,[BLOB]',''),(94,10115,'data:image/png;base64,[BLOB]',''),(95,10118,'data:image/png;base64,[BLOB]',''),(96,10117,'data:image/png;base64,[BLOB]',''),(97,10119,'data:image/png;base64,[BLOB]',''),(98,10121,'data:image/png;base64,[BLOB]',''),(99,10123,'data:image/png;base64,[BLOB]',''),(100,10124,'data:image/png;base64,[BLOB]',''),(101,10120,'data:image/png;base64,[BLOB]',''),(102,10125,'data:image/png;base64,[BLOB]',''),(103,10109,'data:image/png;base64,[BLOB]',''),(104,10126,'data:image/png;base64,[BLOB]',''),(105,10104,'data:image/png;base64,[BLOB]',''),(106,10127,'data:image/png;base64,[BLOB]',''),(107,10116,'data:image/png;base64,[BLOB]',''),(108,10135,'data:image/png;base64,[BLOB]',''),(109,10137,'data:image/png;base64,[BLOB]',''),(110,10144,'data:image/png;base64,[BLOB]',''),(111,10146,'data:image/png;base64,[BLOB]',''),(112,10148,'data:image/png;base64,[BLOB]',''),(113,10147,'data:image/png;base64,[BLOB]',''),(114,10138,'data:image/png;base64,[BLOB]',''),(115,10143,'data:image/png;base64,[BLOB]',''),(116,10150,'data:image/png;base64,[BLOB]',''),(117,10155,'data:image/png;base64,[BLOB]',''),