text: /*
  SQLyog Ultimate v12.09 (64 bit)
  MySQL - 5.7.14 : Database - co_wp
  *********************************************************************
  */
  
  
  /*!40101 SET NAMES utf8 */;
  
  /*!40101 SET SQL_MODE=''*/;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  /*Table structure for table `ci_sessions` */
  
  DROP TABLE IF EXISTS `ci_sessions`;
  
  CREATE TABLE `ci_sessions` (
    `id` varchar(128) NOT NULL,
    `ip_address` varchar(45) NOT NULL,
    `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
    `data` blob NOT NULL,
    KEY `ci_sessions_timestamp` (`timestamp`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `ci_sessions` */
  
  insert  into `ci_sessions`(`id`,`ip_address`,`timestamp`,`data`) values ('e5tc811d2picsebjfdu497g6ukglmjb7','127.0.0.1',1531370315,'__ci_last_regenerate|i:1531370315;'),('ht9kebvnh5g7973getnod5v18up8sr8f','127.0.0.1',1531369467,'__ci_last_regenerate|i:1531369467;'),('c5nd0g9jb5rpv23kal61si9degafpdnt','127.0.0.1',1531370789,'__ci_last_regenerate|i:1531370789;'),('oubo5f3qkk33o9g5nm87vujsatkphe4j','127.0.0.1',1531371845,'__ci_last_regenerate|i:1531371845;'),('giv8nktojo1bn4c1e8oij6gtsjgf9qu4','127.0.0.1',1531372154,'__ci_last_regenerate|i:1531372154;'),('1r1do7jfqm5a8dv81gbpc6lrjpi2fsb5','127.0.0.1',1531372950,'__ci_last_regenerate|i:1531372950;'),('5bk6fre2me9rhaijl7smkd27q2ei5k9h','127.0.0.1',1531373066,'__ci_last_regenerate|i:1531372950;');
  
  /*Table structure for table `companies` */
  
  DROP TABLE IF EXISTS `companies`;
  
  CREATE TABLE `companies` (
    `company_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `company_name` varchar(600) NOT NULL,
    `address_line_1` varchar(500) DEFAULT NULL,
    `address_line_2` varchar(500) DEFAULT NULL,
    `website_url` varchar(200) DEFAULT NULL,
    `date_joined` datetime DEFAULT NULL,
    `enabled` bit(1) NOT NULL,
    PRIMARY KEY (`company_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `companies` */
  
  /*Table structure for table `company_contact_information` */
  
  DROP TABLE IF EXISTS `company_contact_information`;
  
  CREATE TABLE `company_contact_information` (
    `company_id` bigint(20) NOT NULL,
    `contact_type_id` int(11) NOT NULL,
    `contact_type_value` varchar(200) NOT NULL,
    PRIMARY KEY (`company_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `company_contact_information` */
  
  /*Table structure for table `company_vacancies` */
  
  DROP TABLE IF EXISTS `company_vacancies`;
  
  CREATE TABLE `company_vacancies` (
    `vacancy_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `company_id` bigint(20) NOT NULL,
    `vacancy_title` varchar(600) NOT NULL,
    `description` longblob NOT NULL,
    `date_added` datetime DEFAULT NULL,
    PRIMARY KEY (`vacancy_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `company_vacancies` */
  
  /*Table structure for table `contact_types` */
  
  DROP TABLE IF EXISTS `contact_types`;
  
  CREATE TABLE `contact_types` (
    `type_id` int(11) NOT NULL AUTO_INCREMENT,
    `contact_type` varchar(100) NOT NULL,
    PRIMARY KEY (`type_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
  
  /*Data for the table `contact_types` */
  
  insert  into `contact_types`(`type_id`,`contact_type`) values (1,'Fax No'),(2,'Cell No'),(3,'Work No'),(4,'Email Address');
  
  /*Table structure for table `departments` */
  
  DROP TABLE IF EXISTS `departments`;
  
  CREATE TABLE `departments` (
    `department_id` int(11) NOT NULL AUTO_INCREMENT,
    `department_name` varchar(300) NOT NULL,
    PRIMARY KEY (`department_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  
  /*Data for the table `departments` */
  
  insert  into `departments`(`department_id`,`department_name`) values (1,'Operation'),(2,'Production'),(3,'Sanitation/Operations'),(4,'Administration'),(5,'Quality'),(6,'Stores');
  
  /*Table structure for table `emails` */
  
  DROP TABLE IF EXISTS `emails`;
  
  CREATE TABLE `emails` (
    `email_id` int(11) NOT NULL AUTO_INCREMENT,
    `slug` varchar(200) DEFAULT NULL,
    `email_subject` varchar(400) DEFAULT NULL,
    `email_body` text,
    PRIMARY KEY (`email_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  
  /*Data for the table `emails` */
  
  insert  into `emails`(`email_id`,`slug`,`email_subject`,`email_body`) values (1,NULL,'Verify your email address','<p>\r\n	<strong>Hi {firstname},</strong></p>\r\n<p>\r\n	To complete your signup for ELIRA Ticketing, you must click on the link below to verify your email account.</p>\r\n<p>\r\n	{VerificationLink}</p>\r\n<p>\r\n	You can also copy and paste the link in your browser to complete the signup process.</p>\r\n<p>\r\n	You have 24hrs in which to verify your account. If you fail to do so within this timeframe, you will have to re-create your account.</p>\r\n\r\n\r\n<p>\r\n	Thanks,<br />\r\n	The ELIRA Ticketing Team<br />\r\n	www.elira-ticketing.com</p>\r\n\r\n\r\n\r\n\r\n'),(2,NULL,'Welcome to ELIRA Ticketing','<p>\r\n	<strong>Hi {FirstName},</strong></p>\r\n<p>\r\n	Thanks for signing up with MyDealsJa, Jamaica&#39;s premium bargain website!</p>\r\n<p>\r\n	{VerificationLink}</p>\r\n<p>\r\n	To complete the sign-up process please click on the hyperlink listed above.You can also copy and paste the link in your browser.</p>\r\n<p>\r\n	You have 24hrs in which to verify your account. If you fail to do so within this timeframe, you will have to re-create your account.</p>\r\n<p>\r\n	Each day, check your email, Facebook or Twitter feeds for details on deals from some of Jamaica&#39;s finest businesses and brands.</p>\r\n<p>\r\n	With one easy click, purchase your deal. Print your voucher, and take it to the retailer within the specified time frame, and enjoy your deal!</p>\r\n<p>\r\n	We look forward to providing you with more of the best deals in Jamaica.</p>\r\n<p>\r\n	Thank you,</p>\r\n<p>\r\n	The MyDealsJa Team</p>\r\n'),(4,'dispatch_requisition','A new requisition needs to be dispatched','<p>\r\n	<strong>Hi {first_name},</strong></p>\r\n<p>\r\n	A new Requisition was created for {client_name} with Flight No {flight_no}.</p>\r\n\r\n<p>Please log into the SIR Application to dispatch it! </p>\r\n<p>\r\n	Regards,<br />\r\n	SIR</p>\r\n'),(5,'low_stock_level','Low Stock Level','<p>\r\n	<strong>Hi {first_name},</strong></p>\r\n<p>\r\n	{product_name} has reached/gone below its minimum stock level after being used in \r\na requisition.</p>\r\n\r\n<p>\r\n	Regards,<br />\r\n	SIR</p>\r\n'),(6,'approve_po','A new Purchase Order has been created and needs your attention','<p>\r\n	<strong>Hi {first_name},</strong></p>\r\n<p>\r\n	A new Purchase Order has been created and needs your approval.</p>\r\n<<p>\r\n	Regards,<br />\r\n	SIR</p>\r\n');
  
  /*Table structure for table `exceptions` */
  
  DROP TABLE IF EXISTS `exceptions`;
  
  CREATE TABLE `exceptions` (
    `_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `exception` text NOT NULL,
    `date_occured` datetime NOT NULL,
    PRIMARY KEY (`_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `exceptions` */
  
  /*Table structure for table `genders` */
  
  DROP TABLE IF EXISTS `genders`;
  
  CREATE TABLE `genders` (
    `gender_id` int(11) NOT NULL AUTO_INCREMENT,
    `gender` varchar(10) NOT NULL,
    PRIMARY KEY (`gender_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Data for the table `genders` */
  
  insert  into `genders`(`gender_id`,`gender`) values (1,'Male'),(2,'Female');
  
  /*Table structure for table `job_titles` */
  
  DROP TABLE IF EXISTS `job_titles`;
  
  CREATE TABLE `job_titles` (
    `job_title_id` int(11) NOT NULL AUTO_INCREMENT,
    `job_title` varchar(300) NOT NULL,
    PRIMARY KEY (`job_title_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
  
  /*Data for the table `job_titles` */
  
  insert  into `job_titles`(`job_title_id`,`job_title`) values (1,'Driver/Loader'),(2,'Sous Chef'),(3,'Cook'),(4,'Janitor'),(5,'Operations Supervisor'),(6,'Operations Admin. Assistant'),(7,'Administration Assisistant'),(8,'Head Chef'),(9,'General Manager'),(10,'Billing Clerk'),(11,'Purchasing Officer'),(12,'Store Keeper'),(13,'Pastry Cook'),(14,'Quality Officer');
  
  /*Table structure for table `log_actions` */
  
  DROP TABLE IF EXISTS `log_actions`;
  
  CREATE TABLE `log_actions` (
    `log_action_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `action_name` varchar(500) NOT NULL,
    PRIMARY KEY (`log_action_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
  
  /*Data for the table `log_actions` */
  
  insert  into `log_actions`(`log_action_id`,`action_name`) values (1,'Created Requisition'),(2,'Created Purchase Order'),(3,'Approved Purchase Order'),(4,'Dispatched Requisition'),(5,'Added a User'),(6,'Edited a User'),(7,'Deleted a User'),(8,'Added a Client'),(9,'Edited a Client'),(10,'Deleted a Client'),(11,'Added a Supplier'),(12,'Edited a Supplier'),(13,'Deleted a Supplier'),(14,'Added a Product'),(15,'Edited a Product'),(16,'Deleted a Product'),(17,'Assigned Permissions to user'),(18,'Added a permission'),(19,'Added a client flight'),(20,'Generated Product Barcode'),(21,'Edited Flight Check Sheet'),(22,'Created Flight Check Sheet'),(23,'Created Flight Check Sheet from duplicate'),(24,'Edited Purchase Order'),(25,'Created Purchase Order from duplicate'),(26,'Created Invoice'),(27,'Created Quote'),(28,'Edited an Invoice'),(29,'Edited a Quote'),(30,'Edited a Requisition'),(31,'Created a Requisition from duplicate');
  
  /*Table structure for table `notification_statuses` */
  
  DROP TABLE IF EXISTS `notification_statuses`;
  
  CREATE TABLE `notification_statuses` (
    `status_id` int(11) NOT NULL AUTO_INCREMENT,
    `notification_status` varchar(15) NOT NULL,
    PRIMARY KEY (`status_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Data for the table `notification_statuses` */
  
  insert  into `notification_statuses`(`status_id`,`notification_status`) values (1,'Read'),(2,'Unread');
  
  /*Table structure for table `notification_types` */
  
  DROP TABLE IF EXISTS `notification_types`;
  
  CREATE TABLE `notification_types` (
    `notification_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `type_of_notificatioin` varchar(300) NOT NULL,
    PRIMARY KEY (`notification_type_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  /*Data for the table `notification_types` */
  
  insert  into `notification_types`(`notification_type_id`,`type_of_notificatioin`) values (1,'Requisition Received'),(2,'Requisition Dispatched'),(3,'Purchase Order Made'),(4,'Purchase Order Updated'),(5,'Low Stock Level Reached');
  
  /*Table structure for table `notifications` */
  
  DROP TABLE IF EXISTS `notifications`;
  
  CREATE TABLE `notifications` (
    `notification_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `title` varchar(300) NOT NULL,
    `details` text NOT NULL,
    PRIMARY KEY (`notification_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
  
  /*Data for the table `notifications` */
  
  insert  into `notifications`(`notification_id`,`title`,`details`) values (1,'Requisition Received','<strong>Hello [first_name],</strong>\r\n\r\n<p>A new requisition has been created that needs your attention.</p>'),(2,'Requisition Dispatched','<strong>Hello [first_name],</strong>\r\n\r\n<p>The requisition that you made has been dispatched.</p>'),(3,'Purchase Order Made','<strong>Hello [first_name],</strong>\r\n\r\n<p>A new Purchase Order has been made. Please login to [SIR] to update it.</p>'),(4,'Purchase Order Updated','<strong>Hello [first_name],</strong>\r\n\r\n<p>Your Purchase Order has been updated. Please login to [SIR] to see the updated \r\nstatus.</p>'),(5,'Low Stock Level Reached','<strong>Hello [first_name],</strong>\r\n\r\n<p>[product_name] has reached its minimum stock level.</p>\r\n\r\n<p>Please check the product and consider re-ordering.</p>');
  
  /*Table structure for table `pal_log` */
  
  DROP TABLE IF EXISTS `pal_log`;
  
  CREATE TABLE `pal_log` (
    `log_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `log_action_id` int(11) NOT NULL,
    `action_taken_by_employee_id` int(11) NOT NULL,
    `old_data` text,
    `new_data` text,
    `action_taken_on` datetime NOT NULL,
    PRIMARY KEY (`log_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=90 DEFAULT CHARSET=latin1;
  
  /*Data for the table `pal_log` */
  
  insert  into `pal_log`(`log_id`,`log_action_id`,`action_taken_by_employee_id`,`old_data`,`new_data`,`action_taken_on`) values (1,6,5292,NULL,NULL,'2018-05-09 17:14:50'),(2,6,5292,NULL,NULL,'2018-05-09 17:16:17'),(3,6,5292,NULL,NULL,'2018-05-09 17:23:50'),(4,6,5292,NULL,NULL,'2018-05-09 17:25:22'),(5,6,5292,'{\"user_id\":\"1\",\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"department_id\":\"1\",\"job_title_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"status_id\":\"1\",\"user_password\":\"$2y$12$\\/8gkHZFEPw7M2Uy\\/5jHRcOhjxeYQHgI6MyrROop8fQynWkGVdo3GW\"}','{\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"department_id\":\"1\",\"job_title_id\":\"1\"}','2018-05-09 17:29:00'),(6,6,5292,'{\"user_id\":\"1\",\"first_name\":\"Roger\",\"last_name\":\"Aleriaaaaaa\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"department_id\":\"1\",\"job_title_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"status_id\":\"1\",\"user_password\":\"$2y$12$\\/8gkHZFEPw7M2Uy\\/5jHRcOhjxeYQHgI6MyrROop8fQynWkGVdo3GW\"}','{\"first_name\":\"Roger\",\"last_name\":\"Aleriaaaaaa\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"department_id\":\"1\",\"job_title_id\":\"1\"}','2018-05-09 17:30:38'),(7,6,5292,'{\"user_id\":\"1\",\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"department_id\":\"1\",\"job_title_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"status_id\":\"1\",\"user_password\":\"$2y$12$\\/8gkHZFEPw7M2Uy\\/5jHRcOhjxeYQHgI6MyrROop8fQynWkGVdo3GW\"}','{\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"department_id\":\"1\",\"job_title_id\":\"1\"}','2018-05-09 17:34:39'),(8,6,5292,'{\"user_id\":\"1\",\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"roger@site.com\",\"gender_id\":\"1\",\"department_id\":\"1\",\"job_title_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"status_id\":\"1\",\"user_password\":\"$2y$12$\\/8gkHZFEPw7M2Uy\\/5jHRcOhjxeYQHgI6MyrROop8fQynWkGVdo3GW\"}','{\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"\",\"gender_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"department_id\":\"1\",\"job_title_id\":\"1\"}','2018-05-09 17:37:40'),(9,7,5292,'{\"user_id\":\"1\",\"first_name\":\"Roger\",\"last_name\":\"Aleria\",\"email_address\":\"\",\"gender_id\":\"1\",\"department_id\":\"1\",\"job_title_id\":\"1\",\"dob\":\"0000-00-00 00:00:00\",\"status_id\":\"1\",\"user_password\":\"$2y$12$\\/8gkHZFEPw7M2Uy\\/5jHRcOhjxeYQHgI6MyrROop8fQynWkGVdo3GW\"}',NULL,'2018-05-09 18:17:11'),(10,7,5292,'{\"user_id\":\"3\",\"first_name\":\"Nadine\",\"last_name\":\"Bailey Rankine\",\"email_address\":\"\",\"gender_id\":\"2\",\"department_id\":\"3\",\"job_title_id\":\"4\",\"dob\":\"0000-00-00 00:00:00\",\"status_id\":\"1\",\"user_password\":\"$2y$12$AgAmIZH9EeuZW019BmYtY.UrPCbx5JVDzvwHRHtVnfRRToVdPhi5a\"}',NULL,'2018-05-09 18:18:24'),(11,17,5292,NULL,'{\"user_id\":\"31\",\"permissions\":[\"14\",\"18\",\"2\",\"23\",\"10\",\"26\",\"6\",\"16\",\"20\",\"4\",\"25\",\"12\",\"15\",\"19\",\"3\",\"7\",\"24\",\"11\",\"13\",\"5\",\"17\",\"21\",\"1\",\"8\",\"22\",\"9\"]}','2018-05-10 14:29:04'),(12,17,5292,NULL,'{\"user_id\":\"31\",\"permissions\":[\"14\",\"18\",\"2\",\"23\",\"10\",\"26\",\"6\",\"16\",\"20\",\"4\",\"25\",\"12\",\"15\",\"19\",\"3\",\"7\",\"24\",\"11\",\"13\",\"5\",\"17\",\"21\",\"1\",\"8\",\"22\",\"9\"]}','2018-05-10 14:30:15'),(13,17,5292,NULL,'{\"user_id\":\"31\",\"permissions\":[\"14\",\"18\",\"2\",\"23\",\"10\",\"26\",\"6\",\"16\",\"20\",\"4\",\"25\",\"12\",\"15\",\"19\",\"3\",\"7\",\"24\",\"11\",\"13\",\"5\",\"17\",\"21\",\"1\",\"8\",\"22\",\"9\"]}','2018-05-10 14:37:34'),(14,15,5292,'[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":null,\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":null,\"weight\":null,\"current_stock_level\":\"7\"}]','{\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"product_category_id\":\"7\",\"price\":\"2.55\",\"weight\":\"\",\"unit_id\":\"6\"}','2018-05-17 13:10:12'),(15,15,5292,'[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}]','{\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"product_category_id\":\"7\",\"price\":\"2.55\",\"weight\":\"0\",\"unit_id\":\"6\"}','2018-05-17 13:12:11'),(16,15,5292,'[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}]','{\"product_name\":\"AIR FRESHNER FREBREEZE ddd\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"product_category_id\":\"7\",\"price\":\"2.55\",\"weight\":\"0\",\"unit_id\":\"6\"}','2018-05-17 13:13:12'),(17,15,5292,'[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE ddd\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}]','{\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"product_category_id\":\"7\",\"price\":\"2.55\",\"weight\":\"0\",\"unit_id\":\"6\"}','2018-05-17 13:13:23'),(18,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"26\",\"28\",\"27\",\"6\",\"16\",\"20\",\"4\",\"25\",\"12\",\"15\",\"19\",\"3\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"17\",\"21\",\"1\",\"8\",\"22\",\"9\"]}','2018-05-18 13:47:50'),(19,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"26\",\"28\",\"27\",\"6\",\"16\",\"20\",\"4\",\"25\",\"12\",\"15\",\"19\",\"3\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"32\",\"17\",\"21\",\"1\",\"31\",\"8\",\"22\",\"9\"]}','2018-05-18 13:57:38'),(20,18,5292,NULL,'{\"permission\":\"delete purchase order\"}','2018-05-20 19:47:15'),(21,18,5292,NULL,'{\"permission\":\"delete flight check sheet\"}','2018-05-20 19:47:26'),(22,18,5292,NULL,'{\"permission\":\"delete requisition\"}','2018-05-20 19:47:36'),(23,18,5292,NULL,'{\"permission\":\"edit purchase order\"}','2018-05-20 19:48:26'),(24,18,5292,NULL,'{\"permission\":\"edit flight check sheet\"}','2018-05-20 19:48:34'),(25,18,5292,NULL,'{\"permission\":\"dispatch_requisition\"}','2018-05-20 20:22:27'),(26,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"26\",\"28\",\"27\",\"6\",\"16\",\"34\",\"20\",\"4\",\"33\",\"35\",\"25\",\"12\",\"38\",\"15\",\"37\",\"19\",\"3\",\"36\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"32\",\"17\",\"21\",\"1\",\"31\",\"8\",\"22\",\"9\"]}','2018-05-20 20:57:57'),(27,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"424426070841\"}','2018-05-25 11:45:01'),(28,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"424426070841\"}','2018-05-25 11:45:35'),(29,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"424426070841\"}','2018-05-25 11:56:59'),(30,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"424426070841\"}','2018-05-25 12:00:47'),(31,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"424426070841\"}','2018-05-25 12:02:24'),(32,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"424426070841\"}','2018-05-25 12:03:13'),(33,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"42426070841\"}','2018-05-26 19:04:25'),(34,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"841\",\"product_name\":\"AIR FRESHNER FREBREEZE\",\"description\":\"AIR FRESHNER FREBREEZE\",\"barcode\":\"\",\"category_name\":\"Sanitation\",\"price\":\"2.55\",\"product_category_id\":\"7\",\"unit_abbreviation\":\"case\",\"weight\":\"0\",\"current_stock_level\":\"7\"}],\"barcode\":\"42426070841\"}','2018-05-26 19:06:00'),(35,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"1\",\"product_name\":\"BUTTER FOIL \",\"description\":\"BUTTER FOIL \",\"barcode\":\"\",\"category_name\":\"Dairy Cooler\",\"price\":\"0.38\",\"product_category_id\":\"1\",\"unit_abbreviation\":null,\"weight\":null,\"current_stock_level\":\"-2\"}],\"barcode\":\"42426010001\"}','2018-05-26 19:07:26'),(36,15,5292,'[{\"product_id\":\"1\",\"product_name\":\"BUTTER FOIL \",\"description\":\"BUTTER FOIL \",\"barcode\":\"\",\"category_name\":\"Dairy Cooler\",\"price\":\"0.38\",\"product_category_id\":\"1\",\"unit_abbreviation\":null,\"weight\":null,\"current_stock_level\":\"-2\"}]','{\"product_name\":\"BUTTER FOIL \",\"description\":\"BUTTER FOIL \",\"barcode\":\"42426010001\",\"product_category_id\":\"1\",\"price\":\"0.38\",\"weight\":\"\",\"unit_id\":\"6\"}','2018-05-26 19:07:39'),(37,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"33\",\"26\",\"28\",\"40\",\"27\",\"6\",\"16\",\"35\",\"20\",\"4\",\"34\",\"36\",\"25\",\"12\",\"39\",\"42\",\"43\",\"15\",\"38\",\"19\",\"3\",\"37\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"41\",\"32\",\"17\",\"21\",\"1\",\"31\",\"8\",\"22\",\"9\"]}','2018-05-27 09:20:54'),(38,21,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"},{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"6\\\",\\\"qty\\\":\\\"jerome\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"87\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"BA\"}]','{\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"},{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"6\\\",\\\"qty\\\":\\\"jerome\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"87\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 17:24:31'),(39,21,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"},{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"6\\\",\\\"qty\\\":\\\"jerome\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"87\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"BA\"}]','{\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"jerome\\\",\\\"qty\\\":\\\"87\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 17:25:51'),(40,21,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"jerome\\\",\\\"qty\\\":\\\"87\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"BA\"}]','{\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"6\\\",\\\"qty\\\":\\\"jerome\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 17:26:09'),(41,21,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"2\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"6\\\",\\\"qty\\\":\\\"jerome\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"BA\"}]','{\"client_id\":\"1\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 17:26:16'),(42,23,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"1\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"DL\"}]','{\"client_id\":\"1\",\"date_time\":\"2018-05-27 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 18:00:30'),(43,23,5292,'[{\"sheet_no\":\"4\",\"client_id\":\"1\",\"date_time\":\"2018-05-27 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"asfasas\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"5\\\",\\\"qty\\\":\\\"asasasf\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"DL\"}]','{\"client_id\":\"1\",\"date_time\":\"2018-05-27 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10001\",\"cycle\":\"2\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"4\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 18:03:31'),(44,21,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"1\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"},{\\\"description\\\":\\\"2\\\",\\\"qty\\\":\\\"2\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"DL\"}]','{\"client_id\":\"1\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"test\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 18:17:20'),(45,23,5292,'[{\"sheet_no\":\"2\",\"client_id\":\"1\",\"date_time\":\"2018-05-18 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10000\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"test\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"DL\"}]','{\"client_id\":\"1\",\"date_time\":\"2018-05-27 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"test\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 18:23:14'),(46,23,5292,'[{\"sheet_no\":\"6\",\"client_id\":\"1\",\"date_time\":\"2018-05-27 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10002\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"test\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\",\"abbreviation\":\"DL\"}]','{\"client_id\":\"1\",\"date_time\":\"2018-05-27 00:00:00\",\"flight_no\":\"444\",\"check_sheet_no\":\"10003\",\"cycle\":\"1\",\"breakfast_crew_meals\":\"[{\\\"description\\\":\\\"test\\\",\\\"qty\\\":\\\"5\\\"}]\",\"breakfast_first_class_meals\":\"[]\",\"breakfast_economy\":\"[{\\\"description\\\":\\\"asfasas\\\",\\\"qty\\\":\\\"5\\\"}]\",\"lunch_crew_meals\":\"[]\",\"lunch_first_class_meals\":\"[]\",\"lunch_economy\":\"[]\",\"dinner_crew_meals\":\"[]\",\"dinner_first_class_meals\":\"[]\",\"dinner_economy\":\"[]\",\"miscellaneous\":\"[]\",\"service_charge\":\"[{\\\"description\\\":\\\"asasasf\\\",\\\"qty\\\":\\\"6\\\"}]\",\"created_by_employee_id\":\"5292\"}','2018-05-27 18:26:44'),(47,9,5292,'[{\"client_id\":\"2\",\"client_name\":\"British Airways 1\",\"abbreviation\":\"BA\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}]','{\"client_name\":\"British Airways 1\",\"abbreviation\":\"BA\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}','2018-05-30 10:44:34'),(48,9,5292,'[{\"client_id\":\"2\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}]','{\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}','2018-05-30 10:46:51'),(49,9,5292,'[{\"supplier_id\":\"15\",\"supplier_name\":\"Curtis Richard\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"zip\":\"\",\"state\":\"\"}]','{\"supplier_name\":\"Curtis Richard\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}','2018-05-30 11:32:22'),(50,9,5292,'[{\"supplier_id\":\"15\",\"supplier_name\":\"Curtis Richard 1\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"zip\":\"\",\"state\":\"\"}]','{\"supplier_name\":\"Curtis Richard 1\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}','2018-05-30 11:32:35'),(51,9,5292,'[{\"supplier_id\":\"15\",\"supplier_name\":\"Curtis Richard\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"zip\":\"\",\"state\":\"\"}]','{\"supplier_name\":\"Curtis Richard\",\"address_line_1\":\"\",\"address_line_2\":\"\",\"city\":\"\",\"state\":\"\",\"zip\":\"\"}','2018-05-30 11:32:38'),(52,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"33\",\"26\",\"28\",\"40\",\"27\",\"6\",\"45\",\"16\",\"35\",\"20\",\"4\",\"34\",\"36\",\"25\",\"12\",\"39\",\"42\",\"43\",\"44\",\"15\",\"38\",\"19\",\"3\",\"37\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"41\",\"32\",\"17\",\"21\",\"1\",\"31\",\"8\",\"22\",\"9\"]}','2018-05-30 12:09:27'),(53,24,5292,'[{\"purchase_order_id\":\"8\",\"po_no\":\"1006\",\"supplier_id\":\"9\",\"po_date\":\"2018-05-18 00:00:00\",\"po_details\":\"[{\\\"qty\\\":\\\"4\\\",\\\"part_no\\\":\\\"asfasf\\\",\\\"desc\\\":\\\"asfasf\\\",\\\"price\\\":\\\"15\\\",\\\"extn\\\":\\\"60\\\"}]\",\"po_total_amount\":\"60\",\"placed_by_employee_id\":\"5292\",\"send_copy_to\":null,\"approved_by_employee_id\":null,\"approved_date\":null,\"approved\":\"0\",\"supplier_name\":\"Kirk Home Centre\",\"placed_by\":\"Jerome Bailey\",\"approved_by\":null}]','{\"supplier_id\":\"9\",\"po_details\":\"[{\\\"qty\\\":\\\"4\\\",\\\"part_no\\\":\\\"asfasf\\\",\\\"desc\\\":\\\"asfasf\\\",\\\"price\\\":\\\"15\\\",\\\"extn\\\":\\\"60\\\"}]\",\"po_total_amount\":\"60\"}','2018-05-30 19:03:42'),(54,24,5292,'[{\"purchase_order_id\":\"8\",\"po_no\":\"1006\",\"supplier_id\":\"9\",\"po_date\":\"2018-05-18 00:00:00\",\"po_details\":\"[{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"asfasf\\\",\\\"desc\\\":\\\"asfasf\\\",\\\"price\\\":\\\"25\\\",\\\"extn\\\":\\\"125\\\"}]\",\"po_total_amount\":\"185\",\"placed_by_employee_id\":\"5292\",\"send_copy_to\":null,\"approved_by_employee_id\":null,\"approved_date\":null,\"approved\":\"0\",\"supplier_name\":\"Kirk Home Centre\",\"placed_by\":\"Jerome Bailey\",\"approved_by\":null}]','{\"supplier_id\":\"9\",\"po_details\":\"[{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"asfasf\\\",\\\"desc\\\":\\\"asfasf\\\",\\\"price\\\":\\\"25\\\",\\\"extn\\\":\\\"125\\\"}]\",\"po_total_amount\":\"185\"}','2018-05-30 19:04:02'),(55,24,5292,'[{\"purchase_order_id\":\"8\",\"po_no\":\"1006\",\"supplier_id\":\"9\",\"po_date\":\"2018-05-18 00:00:00\",\"po_details\":\"[{\\\"qty\\\":\\\"125\\\",\\\"part_no\\\":null,\\\"desc\\\":null,\\\"price\\\":null,\\\"extn\\\":null},{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"asfasf\\\",\\\"desc\\\":\\\"asfasfasf\\\",\\\"price\\\":\\\"96\\\",\\\"extn\\\":\\\"480\\\"}]\",\"po_total_amount\":\"665\",\"placed_by_employee_id\":\"5292\",\"send_copy_to\":null,\"approved_by_employee_id\":null,\"approved_date\":null,\"approved\":\"0\",\"supplier_name\":\"Kirk Home Centre\",\"placed_by\":\"Jerome Bailey\",\"approved_by\":null}]','{\"supplier_id\":\"9\",\"po_details\":\"[{\\\"qty\\\":\\\"125\\\",\\\"part_no\\\":null,\\\"desc\\\":null,\\\"price\\\":null,\\\"extn\\\":null},{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"asfasf\\\",\\\"desc\\\":\\\"asfasfasf\\\",\\\"price\\\":\\\"96\\\",\\\"extn\\\":\\\"480\\\"}]\",\"po_total_amount\":\"665\"}','2018-05-30 19:09:10'),(56,24,5292,'[{\"purchase_order_id\":\"7\",\"po_no\":\"1006\",\"supplier_id\":\"4\",\"po_date\":\"2018-05-18 00:00:00\",\"po_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"part_no\\\":\\\"0\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"saasfasf\\\",\\\"desc\\\":\\\"afasf\\\",\\\"price\\\":\\\"45\\\",\\\"extn\\\":\\\"225\\\"}]\",\"po_total_amount\":\"227\",\"placed_by_employee_id\":\"5292\",\"send_copy_to\":null,\"approved_by_employee_id\":null,\"approved_date\":null,\"approved\":\"0\",\"supplier_name\":\"Island Supplies Distributors\",\"placed_by\":\"Jerome Bailey\",\"approved_by\":null}]','{\"supplier_id\":\"4\",\"po_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"part_no\\\":\\\"0\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"saasfasf\\\",\\\"desc\\\":\\\"afasf\\\",\\\"price\\\":\\\"45\\\",\\\"extn\\\":\\\"225\\\"}]\",\"po_total_amount\":\"227\"}','2018-05-31 04:59:09'),(57,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"33\",\"26\",\"28\",\"40\",\"27\",\"6\",\"45\",\"16\",\"35\",\"20\",\"4\",\"34\",\"36\",\"25\",\"12\",\"39\",\"42\",\"46\",\"43\",\"44\",\"15\",\"38\",\"19\",\"3\",\"37\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"41\",\"32\",\"17\",\"21\",\"1\",\"31\",\"8\",\"22\",\"9\"]}','2018-05-31 12:40:07'),(58,25,5292,NULL,'{\"po_no\":\"1007\",\"supplier_id\":\"4\",\"po_date\":\"2018-05-31\",\"po_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"part_no\\\":\\\"0\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"5\\\",\\\"part_no\\\":\\\"saasfasf\\\",\\\"desc\\\":\\\"afasf\\\",\\\"price\\\":\\\"45\\\",\\\"extn\\\":\\\"225\\\"}]\",\"po_total_amount\":\"227.00\",\"placed_by_employee_id\":\"5292\",\"approved\":0}','2018-05-31 13:12:23'),(59,9,5292,'[{\"supplier_id\":\"9\",\"supplier_name\":\"Kirk Home Centre\",\"address_line_1\":\"257 Eastern Avenue\",\"address_line_2\":\"PO Box 72\",\"city\":\"Grand Cayman\",\"zip\":\"KY1-1102\",\"state\":\"\",\"is_local\":\"1\"}]','{\"supplier_name\":\"Kirk Home Centre\",\"address_line_1\":\"257 Eastern Avenue\",\"address_line_2\":\"PO Box 72\",\"city\":\"Grand Cayman\",\"state\":\"\",\"zip\":\"KY1-1102\",\"is_local\":\"1\"}','2018-05-31 13:55:36'),(60,9,5292,'[{\"supplier_id\":\"9\",\"supplier_name\":\"Kirk Home Centre\",\"address_line_1\":\"257 Eastern Avenue\",\"address_line_2\":\"PO Box 72\",\"city\":\"Grand Cayman\",\"zip\":\"KY1-1102\",\"state\":\"\",\"is_local\":\"2\"}]','{\"supplier_name\":\"Kirk Home Centre\",\"address_line_1\":\"257 Eastern Avenue\",\"address_line_2\":\"PO Box 72\",\"city\":\"Grand Cayman\",\"state\":\"\",\"zip\":\"KY1-1102\",\"is_local\":\"2\"}','2018-05-31 13:55:40'),(61,9,5292,'[{\"supplier_id\":\"9\",\"supplier_name\":\"Kirk Home Centre\",\"address_line_1\":\"257 Eastern Avenue\",\"address_line_2\":\"PO Box 72\",\"city\":\"Grand Cayman\",\"zip\":\"KY1-1102\",\"state\":\"\",\"is_local\":\"1\"}]','{\"supplier_name\":\"Kirk Home Centre\",\"address_line_1\":\"257 Eastern Avenue\",\"address_line_2\":\"PO Box 72\",\"city\":\"Grand Cayman\",\"state\":\"\",\"zip\":\"KY1-1102\",\"is_local\":\"1\"}','2018-05-31 13:55:43'),(62,17,5292,NULL,'{\"user_id\":\"5292\",\"permissions\":[\"14\",\"29\",\"18\",\"2\",\"23\",\"10\",\"33\",\"26\",\"28\",\"40\",\"27\",\"47\",\"6\",\"45\",\"16\",\"35\",\"50\",\"20\",\"4\",\"34\",\"51\",\"36\",\"25\",\"12\",\"39\",\"42\",\"46\",\"43\",\"44\",\"15\",\"38\",\"48\",\"19\",\"3\",\"37\",\"49\",\"7\",\"24\",\"11\",\"13\",\"30\",\"5\",\"41\",\"32\",\"17\",\"21\",\"1\",\"31\",\"8\",\"22\",\"9\"]}','2018-05-31 14:55:45'),(63,26,5292,NULL,'{\"quote_no\":\"124\",\"supplier_id\":\"7\",\"quote_date\":\"2018-05-31\",\"quote_details\":\"[{\\\"qty\\\":\\\"6\\\",\\\"desc\\\":\\\"aaasfasf\\\",\\\"price\\\":\\\"58\\\",\\\"extn\\\":\\\"348\\\"}]\",\"quote_total_amount\":\"348\",\"created_by_employee_id\":\"5292\"}','2018-05-31 14:58:04'),(64,28,5292,'[{\"invoice_id\":\"7\",\"invoice_no\":\"1006\",\"supplier_id\":\"4\",\"invoice_date\":\"2018-05-18 00:00:00\",\"invoice_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"8\\\",\\\"desc\\\":\\\"asfasf\\\",\\\"price\\\":\\\"250\\\",\\\"extn\\\":\\\"2000\\\"}]\",\"invoice_total_amount\":\"2002\",\"created_by_employee_id\":\"5292\",\"supplier_name\":\"Island Supplies Distributors\",\"created_by\":\"Jerome Bailey\"}]','{\"supplier_id\":\"4\",\"invoice_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"8\\\",\\\"desc\\\":\\\"asfasf\\\",\\\"price\\\":\\\"250\\\",\\\"extn\\\":\\\"2000\\\"}]\",\"invoice_total_amount\":\"2002\"}','2018-06-01 11:52:03'),(65,28,5292,'[{\"quote_id\":\"7\",\"quote_no\":\"1006\",\"supplier_id\":\"4\",\"quote_date\":\"2018-05-18 00:00:00\",\"quote_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"6\\\",\\\"desc\\\":\\\"asfasfas\\\",\\\"price\\\":\\\"58\\\",\\\"extn\\\":\\\"348\\\"}]\",\"quote_total_amount\":\"350\",\"created_by_employee_id\":\"5292\",\"supplier_name\":\"Island Supplies Distributors\",\"created_by\":\"Jerome Bailey\"}]','{\"supplier_id\":\"4\",\"quote_details\":\"[{\\\"qty\\\":\\\"1\\\",\\\"desc\\\":\\\"asfasfsa\\\",\\\"price\\\":\\\"2\\\",\\\"extn\\\":\\\"2\\\"},{\\\"qty\\\":\\\"6\\\",\\\"desc\\\":\\\"asfasfas\\\",\\\"price\\\":\\\"58\\\",\\\"extn\\\":\\\"348\\\"}]\",\"quote_total_amount\":\"350\"}','2018-06-01 12:17:20'),(66,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[]\"}','2018-06-05 15:15:35'),(67,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"safasfasf\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"case\\\"},{\\\"product_name\\\":\\\"asasfas\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:20:09'),(68,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"safasfasf\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"case\\\"},{\\\"product_name\\\":\\\"asasfas\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"asasfasfas\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:20:42'),(69,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"asasfasfas\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"asfasas\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:21:52'),(70,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"asfasas\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"CRACKERS CARRS ASSORTED\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BREAD WHEAT\\\\\\/WHITE SLICED\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:31:12'),(71,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"CRACKERS CARRS ASSORTED\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BREAD WHEAT\\\\\\/WHITE SLICED\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"BEEF CORNED\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:31:32'),(72,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"BEEF CORNED\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"POWDER PEPPER WHITE GROUND\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY (CHAFING FUEL) STERNO\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:33:46'),(73,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"POWDER PEPPER WHITE GROUND\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY (CHAFING FUEL) STERNO\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"POWDER PEPPER WHITE GROUND\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BUTTER FOIL\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:40:21'),(74,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"POWDER PEPPER WHITE GROUND\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BUTTER FOIL\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:40:49'),(75,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BUTTER FOIL\\\",\\\"amount\\\":\\\"2\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:42:15'),(76,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BUTTER FOIL\\\",\\\"amount\\\":\\\"2\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BUTTER FOIL\\\",\\\"amount\\\":\\\"2\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:42:43'),(77,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"BUTTER FOIL\\\",\\\"amount\\\":\\\"2\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:43:02'),(78,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"WATER 330 ML\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"case\\\"}]\"}','2018-06-05 15:44:07'),(79,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"WATER 330 ML\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"case\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY (CHAFING FUEL) STERNO\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:44:54'),(80,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY (CHAFING FUEL) STERNO\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FOIL ALUMINIUM 12X1000 STANDARD\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"each\\\"}]\"}','2018-06-05 15:45:47'),(81,30,5292,'[{\"requisition_id\":\"1\",\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-04-23 00:00:00\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FUEL HANDY\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FOIL ALUMINIUM 12X1000 STANDARD\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched_by_employee_id\":\"0\",\"dispatched_date\":null,\"dispatched\":\"0\",\"client_name\":\"British Airways\",\"abbreviation\":\"BA\",\"flight_type\":\"Economy\",\"flight_no\":\"101\",\"created_by\":\"Jerome Bailey\",\"dispatched_by\":null}]','{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FOIL ALUMINIUM 12X1000 STANDARD\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"WATER FIJI\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"case\\\"}]\"}','2018-06-05 15:46:35'),(82,31,5292,NULL,'{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-06-05\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FOIL ALUMINIUM 12X1000 STANDARD\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"WATER FIJI\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"case\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched\":0}','2018-06-05 16:04:08'),(83,31,5292,NULL,'{\"client_id\":\"2\",\"flight_type_id\":\"2\",\"client_flight_id\":\"1\",\"passenger_count\":\"55\",\"requisition_date\":\"2018-06-05\",\"details\":\"[{\\\"product_name\\\":\\\"EGG LIQUID\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"JUICE ORANGE 10OZ TROPICANA\\\",\\\"amount\\\":\\\"6\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"FOIL ALUMINIUM 12X1000 STANDARD\\\",\\\"amount\\\":\\\"9\\\",\\\"unit\\\":\\\"each\\\"},{\\\"product_name\\\":\\\"WATER FIJI\\\",\\\"amount\\\":\\\"8\\\",\\\"unit\\\":\\\"case\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched\":0}','2018-06-05 16:07:11'),(84,1,5292,NULL,'{\"client_id\":\"6\",\"flight_type_id\":0,\"client_flight_id\":0,\"passenger_count\":\"1\",\"requisition_date\":\"2018-06-13\",\"details\":\"[{\\\"product_name\\\":\\\"BREAD CRUMBS\\\",\\\"amount\\\":\\\"4\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched\":0}','2018-06-13 23:24:02'),(85,1,5292,NULL,'{\"client_id\":\"6\",\"flight_type_id\":0,\"client_flight_id\":0,\"passenger_count\":\"4\",\"requisition_date\":\"2018-06-13\",\"details\":\"[{\\\"product_name\\\":\\\"BREAD CRUMBS\\\",\\\"amount\\\":\\\"7\\\",\\\"unit\\\":\\\"each\\\"}]\",\"store_keeper_employee_id\":\"5292\",\"dispatched\":0}','2018-06-13 23:30:40'),(86,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"939\",\"product_name\":\"FOLGERS CAPPUCCINO\",\"description\":\"FOLGERS CAPPUCCINO\",\"barcode\":\"025500068480\",\"category_name\":\"Dry Stores\",\"price\":\"10\",\"product_category_id\":\"2\",\"unit_abbreviation\":\"lbs\",\"weight\":\"16\",\"current_stock_level\":\"10\",\"unit_id\":\"2\"}],\"barcode\":\"42426020939\"}','2018-06-26 18:12:28'),(87,20,5292,NULL,'{\"product_information\":[{\"product_id\":\"939\",\"product_name\":\"FOLGERS CAPPUCCINO\",\"description\":\"FOLGERS CAPPUCCINO\",\"barcode\":\"025500068480\",\"category_name\":\"Dry Stores\",\"price\":\"10\",\"product_category_id\":\"2\",\"unit_abbreviation\":\"lbs\",\"weight\":\"16\",\"current_stock_level\":\"10\",\"unit_id\":\"2\"}],\"barcode\":\"42426020939\"}','2018-06-26 18:19:52'),(88,14,786737,NULL,'{\"product_name\":\"asfasfasfasfas\",\"description\":\"asfasfasfasfas\",\"barcode\":\"5161616161651\",\"product_category_id\":\"3\",\"price\":\"6\",\"weight\":\"6\",\"unit_id\":\"4\"}','2018-06-29 15:46:29'),(89,14,786737,NULL,'{\"product_name\":\"asfasfasfasfas\",\"description\":\"asfasfasfasfas\",\"barcode\":\"5161616161651\",\"product_category_id\":\"3\",\"price\":\"6\",\"weight\":\"6\",\"unit_id\":\"4\"}','2018-06-29 15:55:44');
  
  /*Table structure for table `pal_settings` */
  
  DROP TABLE IF EXISTS `pal_settings`;
  
  CREATE TABLE `pal_settings` (
    `settings_id` int(11) NOT NULL AUTO_INCREMENT,
    `slug` varchar(300) DEFAULT NULL,
    `settings_name` varchar(500) NOT NULL,
    `settings_value` text NOT NULL,
    PRIMARY KEY (`settings_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
  
  /*Data for the table `pal_settings` */
  
  insert  into `pal_settings`(`settings_id`,`slug`,`settings_name`,`settings_value`) values (1,'bill_to','Bill To Address','Goddard Catering Group GCM Ltd.<br/>\r\n5 Archive Lane, Crewe Road<br/>\r\nGeorgetown, Grand Cayman<br/>\r\nP.O. Box 31374 SMB KY1-1206<br/>\r\nAtt: Accounts Department'),(2,'ship_to','Ship To Address','Goddard Catering Group GCM Ltd.<br />\r\n5 Archive Lane, Crewe Road<br />\r\nGeorgetown, Grand Cayman<br />\r\nP.O. Box 31374 SMB KY1-1206<br />\r\n'),(3,'address_for_forms','Address for forms','5 Archive Lane, P.O. Box 31374 SMB, Grand Cayman Islands, B.W.I,\r\nTel: (345)-949-5835 Fax: (345)-945-2054, 945-2366'),(4,'invoice_address_layout','Address for invoice','5 Archive Lane,<br /> \r\nP.O. Box 31374 SMB,<br />\r\nGrand Cayman Islands,<br />\r\nB.W.I,<br />\r\nTel: (345)-949-5835<br />\r\nFax: (345)-945-2054, 945-2366'),(5,'company_name_invoice','Company name for invoice','Goddard Catering Group GCM Ltd.'),(6,'ship_to_overseas','Ship To Address','Overseas address will go here');
  
  /*Table structure for table `permissions` */
  
  DROP TABLE IF EXISTS `permissions`;
  
  CREATE TABLE `permissions` (
    `permission_id` int(11) NOT NULL AUTO_INCREMENT,
    `permission` varchar(500) DEFAULT NULL,
    `description` text,
    PRIMARY KEY (`permission_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;
  
  /*Data for the table `permissions` */
  
  insert  into `permissions`(`permission_id`,`permission`,`description`) values (1,'view_products',NULL),(2,'add_product',NULL),(3,'edit_product',NULL),(4,'delete_product',NULL),(5,'view_forms',NULL),(6,'create_requisition',NULL),(7,'edit_requisition',NULL),(8,'view_requisitions',NULL),(9,'view_users',NULL),(10,'add_user',NULL),(11,'edit_user',NULL),(12,'delete_user',NULL),(13,'view_departments',NULL),(14,'add_department',NULL),(15,'edit_department',NULL),(16,'delete_department',NULL),(17,'view_job_titles',NULL),(18,'add_job_title',NULL),(19,'edit_job_title',NULL),(20,'delete_job_title',NULL),(21,'view_login_log',NULL),(22,'view_suppliers',NULL),(23,'add_supplier',NULL),(24,'edit_supplier',NULL),(25,'delete_supplier',NULL),(26,'approve_requisition_form',NULL),(27,'create_purchase_order',NULL),(28,'create_flight_check_sheet',NULL),(29,'add_inventory',NULL),(30,'view_flight_check_sheets',NULL),(31,'view_purchase_orders',NULL),(32,'view_inventory',NULL),(33,'approve_purchase_order',NULL),(34,'delete_purchase_order',NULL),(35,'delete_flight_check_sheet',NULL),(36,'delete_requisition',NULL),(37,'edit_purchase_order',NULL),(38,'edit_flight_check_sheet',NULL),(39,'dispatch_requisition',NULL),(40,'create_invoice',NULL),(41,'view_generated_barcodes',NULL),(42,'duplicate_flight_check_sheet',NULL),(43,'duplicate_requisition',NULL),(44,'edit_client',NULL),(45,'delete_client',NULL),(46,'duplicate_purchase_order',NULL),(47,'create_quote',NULL),(48,'edit_invoice',NULL),(49,'edit_quote',NULL),(50,'delete_invoice',NULL),(51,'delete_quote',NULL),(52,'view_invoices',NULL),(53,'view_quotes',NULL);
  
  /*Table structure for table `user_email_notifications` */
  
  DROP TABLE IF EXISTS `user_email_notifications`;
  
  CREATE TABLE `user_email_notifications` (
    `user_id` int(11) NOT NULL,
    `requisitions` tinyint(1) NOT NULL,
    `purchase_order` tinyint(1) NOT NULL,
    PRIMARY KEY (`user_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `user_email_notifications` */
  
  insert  into `user_email_notifications`(`user_id`,`requisitions`,`purchase_order`) values (13,0,1),(23,0,1),(25,1,0);
  
  /*Table structure for table `user_notifications` */
  
  DROP TABLE IF EXISTS `user_notifications`;
  
  CREATE TABLE `user_notifications` (
    `user_notification_id` bigint(20) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) NOT NULL,
    `notification_id` bigint(20) NOT NULL,
    `date_received` datetime NOT NULL,
    `date_read` datetime DEFAULT NULL,
    `status_id` int(11) NOT NULL,
    PRIMARY KEY (`user_notification_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=latin1;
  
  /*Data for the table `user_notifications` */
  
  insert  into `user_notifications`(`user_notification_id`,`user_id`,`notification_id`,`date_received`,`date_read`,`status_id`) values (1,5292,3,'2018-04-22 23:42:28',NULL,1),(2,5292,1,'2018-04-22 23:44:15',NULL,2),(3,13,5,'2018-05-09 14:24:04',NULL,2),(4,23,5,'2018-05-09 14:24:04',NULL,2),(5,13,5,'2018-05-09 14:25:22',NULL,2),(6,23,5,'2018-05-09 14:25:22',NULL,2),(7,13,5,'2018-05-09 14:27:43',NULL,2),(8,23,5,'2018-05-09 14:27:43',NULL,2),(9,13,5,'2018-05-09 14:29:57',NULL,2),(10,23,5,'2018-05-09 14:29:57',NULL,2),(11,13,5,'2018-05-09 14:30:42',NULL,2),(12,23,5,'2018-05-09 14:30:42',NULL,2),(13,13,5,'2018-05-09 14:31:21',NULL,2),(14,23,5,'2018-05-09 14:31:21',NULL,2),(15,13,5,'2018-05-09 14:32:12',NULL,2),(16,23,5,'2018-05-09 14:32:12',NULL,2),(17,13,5,'2018-05-09 14:32:28',NULL,2),(18,23,5,'2018-05-09 14:32:28',NULL,2),(19,13,5,'2018-05-09 14:40:52',NULL,2),(20,23,5,'2018-05-09 14:40:52',NULL,2),(21,13,5,'2018-05-09 14:43:00',NULL,2),(22,23,5,'2018-05-09 14:43:00',NULL,2),(23,13,5,'2018-05-09 14:46:22',NULL,2),(24,23,5,'2018-05-09 14:46:22',NULL,2),(25,13,5,'2018-05-09 14:48:54',NULL,2),(26,23,5,'2018-05-09 14:48:54',NULL,2),(27,13,5,'2018-05-09 15:11:10',NULL,2),(28,23,5,'2018-05-09 15:11:10',NULL,2),(29,13,5,'2018-05-09 15:11:22',NULL,2),(30,23,5,'2018-05-09 15:11:22',NULL,2),(31,13,5,'2018-05-09 15:55:34',NULL,2),(32,23,5,'2018-05-09 15:55:34',NULL,2),(33,5292,1,'2018-05-12 13:48:07',NULL,2),(34,5292,4,'2018-05-18 14:30:33',NULL,2),(35,5292,4,'2018-05-18 14:31:26',NULL,2),(36,5292,3,'2018-05-18 15:37:48',NULL,2),(37,5292,3,'2018-05-18 15:58:25',NULL,2),(38,5292,3,'2018-05-18 16:35:55',NULL,2),(39,5292,3,'2018-05-18 16:37:03',NULL,2),(40,5292,3,'2018-05-18 16:39:33',NULL,2),(41,5292,3,'2018-05-18 16:40:23',NULL,2),(42,5292,3,'2018-05-18 16:49:12',NULL,2),(43,25,1,'2018-05-22 14:32:52',NULL,2),(44,25,1,'2018-05-22 14:33:42',NULL,2),(45,25,1,'2018-05-22 14:35:11',NULL,2),(46,25,1,'2018-05-22 14:37:01',NULL,2),(47,25,1,'2018-05-22 14:42:30',NULL,2),(48,25,1,'2018-06-05 16:04:08',NULL,2),(49,25,1,'2018-06-05 16:07:11',NULL,2),(50,25,1,'2018-06-13 23:24:02',NULL,2),(51,25,1,'2018-06-13 23:30:40',NULL,2);
  
  /*Table structure for table `user_permissions` */
  
  DROP TABLE IF EXISTS `user_permissions`;
  
  CREATE TABLE `user_permissions` (
    `user_id` int(11) NOT NULL,
    `permission_id` int(11) NOT NULL,
    PRIMARY KEY (`user_id`,`permission_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
  
  /*Data for the table `user_permissions` */
  
  insert  into `user_permissions`(`user_id`,`permission_id`) values (0,8),(0,28),(0,30),(6,1),(6,2),(6,3),(6,4),(6,5),(6,6),(6,7),(6,8),(6,9),(6,10),(6,11),(6,12),(6,13),(6,14),(6,15),(6,16),(6,17),(6,18),(6,19),(6,20),(6,21),(6,22),(6,23),(6,24),(6,25),(6,26),(13,1),(13,2),(13,3),(13,4),(13,5),(13,6),(13,7),(13,8),(13,9),(13,10),(13,11),(13,12),(13,14),(13,15),(13,16),(13,17),(13,18),(13,19),(13,20),(13,21),(13,22),(13,23),(13,24),(13,25),(13,26),(13,27),(13,28),(13,29),(23,1),(23,2),(23,3),(23,4),(23,5),(23,6),(23,7),(23,8),(23,9),(23,10),(23,11),(23,12),(23,13),(23,14),(23,15),(23,16),(23,17),(23,18),(23,19),(23,20),(23,21),(23,22),(23,23),(23,24),(23,25),(23,26),(23,27),(23,28),(23,29),(31,1),(31,2),(31,3),(31,4),(31,5),(31,6),(31,7),(31,8),(31,9),(31,10),(31,11),(31,12),(31,13),(31,14),(31,15),(31,16),(31,17),(31,18),(31,19),(31,20),(31,21),(31,22),(31,23),(31,24),(31,25),(31,26),(5292,1),(5292,2),(5292,3),(5292,4),(5292,5),(5292,6),(5292,7),(5292,8),(5292,9),(5292,10),(5292,11),(5292,12),(5292,13),(5292,14),(5292,15),(5292,16),(5292,17),(5292,18),(5292,19),(5292,20),(5292,21),(5292,22),(5292,23),(5292,24),(5292,25),(5292,26),(5292,27),(5292,28),(5292,29),(5292,30),(5292,31),(5292,32),(5292,33),(5292,34),(5292,35),(5292,36),(5292,37),(5292,38),(5292,39),(5292,40),(5292,41),(5292,42),(5292,43),(5292,44),(5292,45),(5292,46),(5292,47),(5292,48),(5292,49),(5292,50),(5292,51),(5292,52),(5292,53);
  
  /*Table structure for table `user_types` */
  
  DROP TABLE IF EXISTS `user_types`;
  
  CREATE TABLE `user_types` (
    `user_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_type` varchar(100) NOT NULL,
    PRIMARY KEY (`user_type_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Data for the table `user_types` */
  
  insert  into `user_types`(`user_type_id`,`user_type`) values (1,'Immigration'),(2,'Company');
  
  /*Table structure for table `users` */
  
  DROP TABLE IF EXISTS `users`;
  
  CREATE TABLE `users` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_type_id` int(11) NOT NULL,
    `first_name` varchar(300) NOT NULL,
    `last_name` varchar(300) NOT NULL,
    `email_address` varchar(300) NOT NULL,
    `password` varchar(600) NOT NULL,
    `date_added` datetime DEFAULT NULL,
    `enabled` tinyint(1) NOT NULL,
    PRIMARY KEY (`user_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
  
  /*Data for the table `users` */
  
  insert  into `users`(`user_id`,`user_type_id`,`first_name`,`last_name`,`email_address`,`password`,`date_added`,`enabled`) values (1,1,'jerome','bailey','test@site.com','ee26b0dd4af7e749aa1a8ee3c10ae9923f618980772e473f8819a5d4940e0db27ac185f8a0e1d5f84f88bc887fd67b143732c304cc5fa9ad8e6f57f50028a8ff',NULL,1);
  
  /*Table structure for table `work_permit_statuses` */
  
  DROP TABLE IF EXISTS `work_permit_statuses`;
  
  CREATE TABLE `work_permit_statuses` (
    `wp_status_id` int(11) NOT NULL AUTO_INCREMENT,
    `wp_status` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`wp_status_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
  
  /*Data for the table `work_permit_statuses` */
  
  insert  into `work_permit_statuses`(`wp_status_id`,`wp_status`) values (1,'Approved'),(2,'Denied'),(3,'Deferred');
  
  /*Table structure for table `wp_types` */
  
  DROP TABLE IF EXISTS `wp_types`;
  
  CREATE TABLE `wp_types` (
    `wp_type_id` int(11) NOT NULL AUTO_INCREMENT,
    `wp_type` varchar(200) NOT NULL,
    PRIMARY KEY (`wp_type_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
  
  /*Data for the table `wp_types` */
  
  insert  into `wp_types`(`wp_type_id`,`wp_type`) values (1,'Temporary Work Permit'),(2,'Annual Work Permit');
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  