(1671,3,73,161915,'Sharmila','Staff',NULL,'1535020123',1,'2018-08-23 18:28:43','2018-08-23 18:32:37','Good.',290,0,'dWVBYmpJWDVNRHJoRS9IM2N6QWhCUT09','2018-08-23 18:28:43','2018-08-23 10:32:37'),(1672,3,99,162023,'Mdm helen ','Dealer',NULL,'1535022911',1,'2018-08-23 19:15:11','2018-08-23 19:25:23','Need to improve',130,0,'RWdRcm1CUm1qVWxCWWpjeENFaUNHUT09','2018-08-23 19:15:11','2018-08-23 11:25:23'),(1673,4,275,162259,'Ms Sook Yee','Supervisor',NULL,'1535072318',1,'2018-08-24 08:58:38','2018-08-24 09:46:51','Station canopy badly peeling',239,0,'NzI0YnJBWjh6SW1nb0Jxa2g5MmpvQT09','2018-08-24 08:58:38','2018-08-24 01:46:51'),(1674,5,229,162256,'Dila','Supervisor',NULL,'1535072679',1,'2018-08-24 09:04:39','2018-08-24 09:27:05','Attention needed on customer service up selling n promoting e card n forcourt crews needs to provide good services. Cashiers services needs to buck up.Stn renovation going to start next month shop n forcourt.',218,0,'Q2puRks2NnovazB6Umt6VkhJd01PZz09','2018-08-24 09:04:39','2018-08-24 01:27:05'),(1675,5,248,162271,'Belal','Supervisor',NULL,'1535075630',1,'2018-08-24 09:53:50','2018-08-24 10:11:15','Overall good housekeeping. Needs to have toilet  sticker. No staffs outside to provide services. Only 2 staffs handling. Focus more on customer service up selling n promoting e card. Cashiers sitting n serving customers.posm n stocks all in plc.',213,0,'S2FZNWJORG9SQU9SRmEzd0pkV3pBZz09','2018-08-24 09:53:50','2018-08-24 02:11:15'),(1676,4,195,162407,'Billy','Manager',NULL,'1535078782',1,'2018-08-24 10:46:22','2018-08-24 11:10:16','NA',236,0,'dC94aFpCNGNDSHVkcGlUbU1JcW9GZz09','2018-08-24 10:46:22','2018-08-24 03:10:16'),(1677,3,305,162408,'Radha','Staff',NULL,'1535079078',1,'2018-08-24 10:51:18','2018-08-24 11:10:52','Pls request pump poster. ',265,0,'eWx5MEFUNWVrbGllbEFOUDFqaFhoQT09','2018-08-24 10:51:18','2018-08-24 03:10:52'),(1678,5,213,162525,'Josephine','Clerk',NULL,'1535082511',1,'2018-08-24 11:48:31','2018-08-24 12:29:24','Overall good house keeping. All posm n stocks in plc.Attention on toilet should be given main priority. Focus more on customer service up selling n promoting e card. Beside that all in plc.Forcourt staffs needs to provide good services outside. ',190,0,'cHQwcGtKdkptS01wOWFQTjdLbmhKZz09','2018-08-24 11:48:31','2018-08-24 04:29:24'),(1680,3,96,162526,'Intan','Station supervisor',NULL,'1535083254',1,'2018-08-24 12:00:54','2018-08-24 12:33:38','Cashier pls promote and cross sell. Pls get approval for tngo banner. ',230,0,'dURjN2tvTjg5alRMeFZ6Y0tXTnI1dz09','2018-08-24 12:00:54','2018-08-24 04:33:39'),(1681,3,103,162737,'Hidayah','Station supervisor',NULL,'1535089832',1,'2018-08-24 13:50:32','2018-08-24 14:17:39','Cctv cashier no cross sell',207,0,'V3BVSHh5MVhvTS9FQWp2Y0ZXMFQwZz09','2018-08-24 13:50:32','2018-08-24 06:17:39'),(1682,5,186,162755,'Paul Singh','Dealer',NULL,'1535090774',1,'2018-08-24 14:06:14','2018-08-24 14:34:35','Needs to focus more on housekeeping esp pumps,drain,toilets n sourdding, Staffs availability at forcourt needed at all time. Amenty bins needs to clean up.Staff Misha needs to wear proper shoes. Cashiers needs to focus more more on services. ',226,0,'ZXBja1hIS3BGWEdnS0VIdTdVUWR0QT09','2018-08-24 14:06:14','2018-08-24 06:34:36'),(1683,4,109,162786,'Emma','Supervisor',NULL,'1535091533',1,'2018-08-24 14:18:53','2018-08-24 14:50:25','NA',254,0,'SCtoZGZnMjBXVGJvdzllOE55VGZQUT09','2018-08-24 14:18:53','2018-08-24 06:50:25'),(1684,3,159,162980,'Ms.TanJX','Dealer',NULL,'1535095080',1,'2018-08-24 15:18:00','2018-08-24 15:56:14','Cctv Cashier no greeting, no cross sell, no ask ecard, slipper not allowed, playing handphone and sitting not allowed. Pls request safety sticker.  ',233,0,'cVU4ZCtENDUzTGMyTFlzNm1xenRmQT09','2018-08-24 15:18:00','2018-08-24 07:56:14'),(1685,5,199,163002,'Henny','Cashier',NULL,'1535096369',1,'2018-08-24 15:39:29','2018-08-24 16:14:56','Overall good house keeping n posm n all stocks in plc.Stn well kept.Toilet clean, Focus more on customer service up selling n promoting e card and promote perfume tanker. One of window poster holder snapped I already reported. ',255,0,'UVVhTlpoWlRPTXl5NUdPTklySUFldz09','2018-08-24 15:39:29','2018-08-24 08:14:57'),(1686,4,211,163159,'Ila','Cashier',NULL,'1535098117',1,'2018-08-24 16:08:37','2018-08-24 16:46:45','CCTV monitor need to replace.',267,0,'Zks1TmtqaGdLdmVuS204dDVBc1duQT09','2018-08-24 16:08:37','2018-08-24 08:46:47'),(1687,3,80,163261,'Najwa','Staff',NULL,'1535102152',1,'2018-08-24 17:15:52','2018-08-24 17:29:13','Cctv cashier to improve cross selling.',245,0,'L2xkbDM0UDR3ejhkTkNiYjB3alB5dz09','2018-08-24 17:15:52','2018-08-24 09:29:13'),(1688,3,63,163492,'Mdm Boo','Dealer',NULL,'1535108490',1,'2018-08-24 19:01:30','2018-08-24 19:22:30','Good',290,0,'cCs2TE9tZUtzRlJuOEJQRGtoNmM4Zz09','2018-08-24 19:01:30','2018-08-24 11:22:30'),(1689,5,228,163605,'Lin','Supervisor',NULL,'1535158372',1,'2018-08-25 08:52:52','2018-08-25 09:34:52','Advice to clean up all pumps panel n top part immediately all  with stains. focus more on customer service ,Had advice Helmi to do  it immediately with help of Lin.Fire extinguisher  compartment needs to clean up as well.Focus more on services. Overall good house keeping. Posm n wet stocks all in plc.Keep moving forward. Happy working. ',248,0,'ai9pc3lwWU9HZUJFTHpwYWZOZmxWZz09','2018-08-25 08:52:52','2018-08-25 01:34:52'),(1690,5,212,163622,'Bashirah','Dealer',NULL,'1535164451',1,'2018-08-25 10:34:11','2018-08-25 11:15:29','Overall good house keeping. Staffs needs to focus more on services. Wet stocks n all posm in plc.Good sales,Advice all  for court  staff\'s be more alert n provide  good customer service up selling n promoting e card. ',238,0,'alI3TGJUdTZFdUdZQmhTRWhCUm5pUT09','2018-08-25 10:34:11','2018-08-25 03:15:48'),(1691,3,46,163623,'Isizzati','Staff',NULL,'1535165933',1,'2018-08-25 10:58:53','2018-08-25 11:15:50','Cctv cashier no greeting no cross sell.',202,0,'WVFQWkVWQjZESlAyUVdXblFyV2lXQT09','2018-08-25 10:58:53','2018-08-25 03:15:50'),(1692,3,50,163787,'Nazrin','Staff',NULL,'1535170061',1,'2018-08-25 12:07:41','2018-08-25 12:21:28','Office lock, cctv not available.',203,0,'YTU4QnBPeEM1OUExUUNaNk9iM1NwQT09','2018-08-25 12:07:41','2018-08-25 04:21:28'),(1693,3,58,163933,'Daud','Staff',NULL,'1535179478',1,'2018-08-25 14:44:38','2018-08-25 14:58:55','Cashier to improve cross selling. ',272,0,'NkJ6YUVKdzZhRXR5VkZlYWNkN04rZz09','2018-08-25 14:44:38','2018-08-25 06:58:55'),(1694,3,61,163940,'Rasul','Staff',NULL,'1535183603',1,'2018-08-25 15:53:23','2018-08-25 16:08:45','Cashier to improve cross selling',251,0,'aGFRci9iT0p4MVh4d1ZOL2NiVmppZz09','2018-08-25 15:53:23','2018-08-25 08:08:45'),(1695,3,88,163948,'Azlin','Staff',NULL,'1535186786',1,'2018-08-25 16:46:26','2018-08-25 16:55:56','Cctv not available locked. ',232,0,'Q1kxRGtJVW9kYXFha1lZZ3lFVThYdz09','2018-08-25 16:46:26','2018-08-25 08:55:56'),(1696,3,69,163955,'Tan HT','Staff',NULL,'1535189461',1,'2018-08-25 17:31:01','2018-08-25 17:53:08','Cashier to improve greeting. ',265,0,'THZ0TE05WUpxZi9zNkd6Q2F5TUd6dz09','2018-08-25 17:31:01','2018-08-25 09:53:08'),(1697,3,86,163964,'Haida','Staff',NULL,'1535193411',1,'2018-08-25 18:36:51','2018-08-25 18:48:11','Office locked, cctv not available',221,0,'ZWNPR1E2QnZOdklLUW9RaFExbE9qZz09','2018-08-25 18:36:51','2018-08-25 10:48:11'),(1698,3,85,163969,'Mohd nurhakim','Staff',NULL,'1535196398',1,'2018-08-25 19:26:38','2018-08-25 19:37:45','Office locked',180,0,'cWdXc29JdHV1a0RsdFhTeDh6dklRdz09','2018-08-25 19:26:38','2018-08-25 11:37:45'),(1699,2,16,164188,'Jebat','Cashier',NULL,'1535248060',1,'2018-08-26 09:47:40','2018-08-26 10:17:38','Station without cctv..\r\nAdvise staff update latest pump topper posm.',223,0,'OWFCSWJvUEhNYjJzWk0xMjRoMlExUT09','2018-08-26 09:47:40','2018-08-26 02:17:38'),(1700,2,9,164295,'Lina','Supervisor',NULL,'1535253735',1,'2018-08-26 11:22:15','2018-08-26 11:54:34','Viewing cctv staff no customer services, sitting serve customer.  \r\nForecourt staff sitting at apron.',213,0,'a0xaMmhLelk1M3plc3JPcnFzQ3Mvdz09','2018-08-26 11:22:15','2018-08-26 03:54:34'),(1701,2,327,164307,'Shahriza','Cashier',NULL,'1535260364',1,'2018-08-26 13:12:44','2018-08-26 13:34:08','Station without cctv. ',241,0,'MER2SVpuK0dmc1BTL3NRWVU1YkZ0Zz09','2018-08-26 13:12:44','2018-08-26 05:34:08'),(1702,2,4,164409,'Nazli','Supervisor',NULL,'1535265700',1,'2018-08-26 14:41:40','2018-08-26 15:21:52','Viewing cctv staff sitting and serve customer. ',285,0,'eWFFaG9QcGdQSWlqVStXTjNMRGRpUT09','2018-08-26 14:41:40','2018-08-26 07:21:53'),(1703,2,5,164512,'Sopa','Cashier',NULL,'1535273563',1,'2018-08-26 16:52:43','2018-08-26 17:20:57','Cctv under repair. ',288,0,'cVdQVExyR2NUeW1vazVJNFhWL1B1UT09','2018-08-26 16:52:43','2018-08-26 09:20:57'),(1704,5,240,164636,'Hahaha n Malek','Supervisor',NULL,'1535332012',1,'2018-08-27 09:06:52','2018-08-27 09:25:34','Overall good house keeping n all posm wet stocks in plc.Advice Hakim to provide good services at all time.Ensre all stocks for next month in plc.',246,0,'ZWk4TTNMQXlzVkM1RHBHNzZPVFZZZz09','2018-08-27 09:06:52','2018-08-27 01:25:35'),(1705,4,153,164749,'Helaludin','Cashier',NULL,'1535332200',1,'2018-08-27 09:10:00','2018-08-27 09:49:06','No water supply.\r\nTelekom server line down.\r\n',192,0,'ZityWGZndTkyRVlYWWI1U0c5R25wUT09','2018-08-27 09:10:00','2018-08-27 01:49:07'),(1706,5,190,164888,'Maisara','Clerk',NULL,'1535335043',1,'2018-08-27 09:57:23','2018-08-27 10:35:24','Overall good house keeping. All posm n wet stocks in plc.Forcourt crew Nanda needs to wear proper shoes. cashiers needs to focus more on customer service up selling n promoting e card. Staffs training needed.Overall good. ',230,0,'ZHl2eFhUbU1JTnd6OHRQeFpkZFhCZz09','2018-08-27 09:57:23','2018-08-27 02:35:24'),(1707,3,42,164956,'Sabrina','Staff',NULL,'1535337515',1,'2018-08-27 10:38:35','2018-08-27 10:58:02','Cashier to improve cross selling.',240,0,'amhjZkhSNFkvMHNUd3ZPb2xZQzlMdz09','2018-08-27 10:38:35','2018-08-27 02:58:02'),(1708,4,108,165141,'Ragini','Supervisor',NULL,'1535338567',1,'2018-08-27 10:56:07','2018-08-27 11:22:35','NA',168,0,'M1ZubVJCWGhPR0NtS0cvV1NNbmlzdz09','2018-08-27 10:56:07','2018-08-27 03:22:35'),(1709,2,34,165312,'Fatimaton','Cashier',NULL,'1535341244',1,'2018-08-27 11:40:44','2018-08-27 12:09:40','Station without cctv. \r\nAdvise staff update pump topper posm. ',204,0,'ZndROEdHMmF6OEkvUWFZc1VOQXZtZz09','2018-08-27 11:40:44','2018-08-27 04:09:41'),(1710,5,215,165314,'Azham','Clerk',NULL,'1535341412',1,'2018-08-27 11:43:32','2018-08-27 12:11:48','Car wash area dirty with rubbish n cig butts. Needs to focus more on customer service up selling n promoting e card n promoting perfume tanker. Overall forcourt area good house keeping .Posm n stocks all in plc',222,0,'aW8wSkhJaHNab1dEWjZiQllhNTU4QT09','2018-08-27 11:43:32','2018-08-27 04:11:48'),(1711,3,56,165313,'Aisah','Station supervisor',NULL,'1535342220',1,'2018-08-27 11:57:00','2018-08-27 12:10:17','To improve cross selling.',244,0,'elY3dkg3QzNoRU91RzJ5K0hWalJCdz09','2018-08-27 11:57:00','2018-08-27 04:10:17'),(1712,4,126,165564,'En Zul','Dealer',NULL,'1535343523',1,'2018-08-27 12:18:43','2018-08-27 13:04:33','NA',275,0,'TXVyd2I4RE5nR3d6Y0ZuTnJORm1mdz09','2018-08-27 12:18:43','2018-08-27 05:04:33'),(1713,3,59,165749,'Seri ','Staff',NULL,'1535348220',1,'2018-08-27 13:37:00','2018-08-27 13:57:58','Cashier to improve cross selling.',240,0,'bG16clRHdVgydUthWnN5WGoxME5lUT09','2018-08-27 13:37:00','2018-08-27 05:57:59'),(1714,2,17,165754,'Ooi','Dealer',NULL,'1535348703',1,'2018-08-27 13:45:03','2018-08-27 14:11:19','Viewing cctv staff no customer services, sitting serve customer and using handphone. \r\nStaff need training. \r\n',228,0,'cUlYUmlhN2lhWVVyRDhvN2dPVjNwdz09','2018-08-27 13:45:03','2018-08-27 06:11:20'),(1715,4,145,165790,'Rossa','Supervisor',NULL,'1535349402',1,'2018-08-27 13:56:42','2018-08-27 14:27:05','NA',217,0,'MFRBTnl5VkFLS2Z5Yi8rejZRd3MrUT09','2018-08-27 13:56:42','2018-08-27 06:27:05'),(1716,3,161,165852,'Billal','Staff',NULL,'1535350704',1,'2018-08-27 14:18:24','2018-08-27 14:48:58','Cashier to improve on greeting and cross selling, forecourt no staff. Pls report for damage and record in log book. ',140,0,'SnQ1ZFRXNlpWaENXcWR2Mm5xV1E0UT09','2018-08-27 14:18:24','2018-08-27 06:49:00'),(1717,2,32,165789,'Kuala Nerang','Cashier',NULL,'1535350731',1,'2018-08-27 14:18:51','2018-08-27 14:25:55','Station closed due to no petrol ',0,0,'c1pRTUpSM016ZXdsNFFMeVA2aE1sZz09','2018-08-27 14:18:51','2018-08-27 06:25:55'),(1718,5,277,165994,'Miss Fong','Cashier',NULL,'1535352543',1,'2018-08-27 14:49:03','2018-08-27 15:16:02','Lack in services both areas .No forcourt area.Attention needed on toilet n ament bins cleanliness. Overall posm n wet stocks all in placed. cashiers needs to focus more on customer service up selling n promoting e card. Unbranded shop.Advice to have staffs at forcourt to provide better services to customers. Keep moving forward. ',209,0,'clk4TGJPRkoxRHo2ZzFuRW1ML0l0dz09','2018-08-27 14:49:03','2018-08-27 07:16:02'),(1719,5,379,166108,'Jimmy','Manager',NULL,'1535354590',1,'2018-08-27 15:23:10','2018-08-27 16:04:21','Cashiers needs to focus more on customer service up selling n promoting e card. Overall good house keeping n wet stocks all in placed.Sellng chairs place at apron.Stn just opened on 18/07i',251,0,'bzJVUUhRYmtYRHM4bmU4NEswTzdldz09','2018-08-27 15:23:10','2018-08-27 08:04:21'),(1720,3,53,166025,'Amira','Staff',NULL,'1535355117',1,'2018-08-27 15:31:57','2018-08-27 15:47:48','Cashier to improve greeting amd cross selling.',213,0,'SmN3aVNWZ1Nua0VtSGpuSjUzb2x2QT09','2018-08-27 15:31:57','2018-08-27 07:47:49'),(1721,4,257,166227,'Atikah','Supervisor',NULL,'1535357282',1,'2018-08-27 16:08:02','2018-08-27 16:55:47','NA',275,0,'aGtZcUtOdXUwa0tYQkl5Z1BDME1EZz09','2018-08-27 16:08:02','2018-08-27 08:55:47'),(1722,3,38,166211,'Zana','Staff',NULL,'1535358616',1,'2018-08-27 16:30:16','2018-08-27 16:51:07','Cashier to improve greeting and cross selling. ',263,0,'TzJ4Q0dsK2lKQzd6NlJsS0cvMDV0dz09','2018-08-27 16:30:16','2018-08-27 08:51:07'),(1724,3,71,166356,'Umi','Staff',NULL,'1535363595',1,'2018-08-27 17:53:15','2018-08-27 18:08:02','Cashier to improve cross selling.',255,0,'U1puRTgxKy9jVk52bzF1WG80MmJoQT09','2018-08-27 17:53:15','2018-08-27 10:08:02'),(1725,5,181,166379,'Parames','Cashier',NULL,'1535364053',1,'2018-08-27 18:00:53','2018-08-27 18:24:55','Overall good house keeping. All posm n wet stocks in plc.Focus more on customer service up selling n promoting e card n promoting perfume tanker Forcourt staffs needs provide good services outside. cashiers needs to be proactive, ',216,0,'YVhzR3NVa2oxSWpvZFJuMDJuK3JkUT09','2018-08-27 18:00:53','2018-08-27 10:24:55'),(1726,3,78,166425,'Eyra','Staff',NULL,'1535367271',1,'2018-08-27 18:54:31','2018-08-27 19:12:07','Cashier to improve greeting and cross selling',249,0,'UWlNZjA1TTZUZHBpZ2pYMUVpRmcvUT09','2018-08-27 18:54:31','2018-08-27 11:12:08'),(1727,3,322,166487,'Adnan','Station manager',NULL,'1535370027',1,'2018-08-27 19:40:27','2018-08-27 19:53:32','Pls request for new poster for pump topper.',290,0,'RTFDOUlBZkZBZDdpWE4yVWt2N2pBUT09','2018-08-27 19:40:27','2018-08-27 11:53:32'),(1728,5,291,166495,'Mrs.Kua','Dealer',NULL,'1535414317',1,'2018-08-28 07:58:37','2018-08-28 08:15:07','Good house keeping. Wet stocks n all posm in plc.Advice cashiers focus more on customer service up selling n promoting. Old hardwares. Posm law law already put up',265,0,'dmZrb1JmZ1dkMDJxZmRKZjdUb244Zz09','2018-08-28 07:58:37','2018-08-28 00:15:07'),(1729,4,123,166576,'Asmar','Supervisor',NULL,'1535416842',1,'2018-08-28 08:40:42','2018-08-28 09:22:44','Advise to trimm grass\r\nFollow up pump 2 maintenance issue\r\nUpdate Posm',198,0,'UTJ0aTZHWjFUVk04aHFMYzJDQ2Z4Zz09','2018-08-28 08:40:42','2018-08-28 01:22:45'),(1730,5,311,166648,'Mr Lim','Manager',NULL,'1535418057',1,'2018-08-28 09:00:57','2018-08-28 09:35:57','Mouse CCTV not functioning. Overall good house keeping. All posm n wet stocks in plc.Advics cashiers provide good customer service up selling n promoting e card ',240,0,'NnhodGRFcGN4VEFuYUdGcENScTVPUT09','2018-08-28 09:00:57','2018-08-28 01:35:57'),(1731,5,255,166747,'Shuidah','Cashier',NULL,'1535421551',1,'2018-08-28 09:59:11','2018-08-28 10:27:59','Overall good house keeping, Mtg discharging fuel from tanker. Advice cashiers to focus more on customer service up selling n promoting e card, Advice forcourt crew provide good customer service to customers.Amenty bins needs to pay for attention on cleanliness. Overall atm well kept',228,0,'U2tLbTF6UnhHQnFtdHZmRXlaSE9Ndz09','2018-08-28 09:59:11','2018-08-28 02:27:59'),(1732,2,6,166971,'Priya','Cashier',NULL,'1535424668',1,'2018-08-28 10:51:08','2018-08-28 11:29:15','Viewing cctv staff no customer services.\r\nForecourt staff angry customer.\r\nStaff need training. \r\n',259,0,'c0M0T2FwYVpjdHFWREtCbmxGbEJldz09','2018-08-28 10:51:08','2018-08-28 03:29:15'),(1733,4,149,166973,'Terry','Dealer',NULL,'1535425174',1,'2018-08-28 10:59:34','2018-08-28 11:32:02','Advise to clean up window pines',251,0,'NUZ5V1pBNFRHeHhrUDN6VDAyZDVoZz09','2018-08-28 10:59:34','2018-08-28 03:32:02'),(1734,5,256,167076,'Mrs Lee','Manager',NULL,'1535427704',1,'2018-08-28 11:41:44','2018-08-28 12:19:42','No forcourt crews.Entire forcourt areas needs to clean up. Drains n too many  leaves.Needs to focus more on customer service up selling n promoting e card n promote perfume tanker. Advice to have staffs at forcourt at all time.',186,0,'cXphZXR5SHZRL0JYOWR6ZkplRG9QZz09','2018-08-28 11:41:44','2018-08-28 04:19:42'),(1735,4,160,167210,'Hafizan and Siti','Supervisor',NULL,'1535431961',1,'2018-08-28 12:52:41','2018-08-28 13:49:23','Advise station to update Posm.\r\nFollow up on tiles maintenance.\r\nSwitch room door.\r\nShop entrance door.\r\nCleanliness.\r\n',214,0,'MDgxdXI4RTZFRGM4MVFjbzJIVVNqUT09','2018-08-28 12:52:41','2018-08-28 05:49:23'),(1736,5,246,167246,'Nurul','Supervisor',NULL,'1535435389',1,'2018-08-28 13:49:49','2018-08-28 14:09:47','Overall good house keeping n posm n wet stocks in plc.Advice to have forcourt staffs at all time at forcourt. Cashiers needs to focus more on customer service up selling n promoting e card, Staffs training needed. ',230,0,'UWtwdE02SHFqdVZTUEJLWkxaeUE0Zz09','2018-08-28 13:49:49','2018-08-28 06:09:47'),(1737,3,72,167256,'Atikah','Station supervisor',NULL,'1535435597',1,'2018-08-28 13:53:17','2018-08-28 14:14:44','Cashier to improve greeting and cross selling. Pls request new poster for pump topper. ',244,0,'Y1BHRmZjK0x5a0lCU1NFQkdTOW5rZz09','2018-08-28 13:53:17','2018-08-28 06:14:44'),(1738,5,265,167529,'Majeed','Dealer',NULL,'1535440902',1,'2018-08-28 15:21:42','2018-08-28 15:39:49','Overall good house keeping n all posm n wet stocks in plc.Focus more on customer service up selling n promoting e card and up selling. Toilet kept well. Back to basic.',217,0,'V3BvL1ZhS1hUUTNDL3NTUGVSV09CUT09','2018-08-28 15:21:42','2018-08-28 07:39:50'),(1739,3,92,167533,'Low jia xin','Station supervisor',NULL,'1535441691',1,'2018-08-28 15:34:51','2018-08-28 15:49:48','Cashier to improve servicing',201,0,'Y1F3dktwZlQyTUNzSmM2TC8vNnFJUT09','2018-08-28 15:34:51','2018-08-28 07:49:48'),(1740,5,292,167637,'Mr Siew','Manager',NULL,'1535442529',1,'2018-08-28 15:48:49','2018-08-28 16:16:41','Great improvements on house keeping Posm n wet stocks all in plc.Keep moving forward. Old stn almost  11 yrs with bhp  bf  30 yrs  with caltex. Unbranded  shop.',265,0,'YjZRK3IyUTVWaTRHd0psZEc0aHFWZz09','2018-08-28 15:48:49','2018-08-28 08:16:44'),(1741,4,266,167675,'Aida','Cashier',NULL,'1535444519',1,'2018-08-28 16:21:59','2018-08-28 16:42:57','NA',178,0,'Yzg5d1N1b0VWWDBkSmRaZjJzdmozdz09','2018-08-28 16:21:59','2018-08-28 08:42:57'),(1742,3,104,167674,'Colin','Station supervisor',NULL,'1535444677',1,'2018-08-28 16:24:37','2018-08-28 16:40:54','Cashier to improve servicing',201,0,'M2RXMGhMaFdvZGhoMzdIaXg4SW5mZz09','2018-08-28 16:24:37','2018-08-28 08:40:54'),(1743,5,280,167682,'Mr.Goh','Manager',NULL,'1535445466',1,'2018-08-28 16:37:46','2018-08-28 17:12:42','Great improvements on house keeping n  posm n wet stocks all in plc.Advice to focus more on services. Beside that everything seem to be ok.',260,0,'aVRORXM2MzNxbWNBUmp1am83bWJ2UT09','2018-08-28 16:37:46','2018-08-28 09:12:45'),(1744,4,133,167733,'Hasbullah','Manager',NULL,'1535447536',1,'2018-08-28 17:12:16','2018-08-28 17:46:42','NA',275,0,'Zk5vQ1RhVFZsQlVWZy93WmM4aXJhZz09','2018-08-28 17:12:16','2018-08-28 09:46:42'),(1745,3,95,167727,'Fieza','Staff',NULL,'1535448277',1,'2018-08-28 17:24:37','2018-08-28 17:44:51','Cctv cashier no cross sell',249,0,'UUl0TlZYZHdQVFFSQWVXL252eGtYUT09','2018-08-28 17:24:37','2018-08-28 09:44:51'),(1746,5,259,167714,'Faizah','Supervisor',NULL,'1535448330',1,'2018-08-28 17:25:30','2018-08-28 17:39:28','Good house keeping n merchandising and wet stocks n all posm in plc accordingly. Good job  Keep it up',265,0,'bWlWb2cyTmx6SmJIRjJncklmTDZLUT09','2018-08-28 17:25:30','2018-08-28 09:39:28'),(1747,5,207,168021,'Norehan','Cashier',NULL,'1535452830',1,'2018-08-28 18:40:30','2018-08-28 19:17:06','Good house keeping n well kept.All stock\'s  n wet stocks in plc.Stn busy with customers.Cashiers needs  to focus more on customer service up selling n promoting  perfume tanker. ',245,0,'MDNnSHoyY0VSRy9sNXp0T3RWWnpVdz09','2018-08-28 18:40:30','2018-08-28 11:17:06'),(1748,3,83,168215,'Mira','Staff',NULL,'1535503144',1,'2018-08-29 08:39:04','2018-08-29 08:59:31','Cashier to improve servicing',144,0,'SVRTNWNhOGpyRVF0eEVHSjYxOFltdz09','2018-08-29 08:39:04','2018-08-29 00:59:31'),(1749,4,249,168266,'Johnson','Manager',NULL,'1535504238',1,'2018-08-29 08:57:18','2018-08-29 09:36:36','NA',271,0,'S2dsK3dyYVRsZEc3dDBNM1c0ZS9MZz09','2018-08-29 08:57:18','2018-08-29 01:36:36'),(1750,5,243,168282,'Zahra','Cashier',NULL,'1535505030',1,'2018-08-29 09:10:30','2018-08-29 09:41:44','Cashiers needs to provide good services to customers by up selling n promoting e card n promoting fuel tanker. Told Shafik forcourt staff to clean up all pumps panel , amentiy bins,hose.Advice to wear black pants with socks.most of the pumps have stains n  not properly clean up.Spoke to Davin father on the above matter.Cashiers needs to be more proactive. Overall good house keeping n all posm n wet stocks in plc.',232,0,'MGVRdDlpQ1dlV1QxMjJ4d0g4MnB5UT09','2018-08-29 09:10:30','2018-08-29 01:41:44'),(1751,5,182,168469,'Ima','Cashier',NULL,'1535508030',1,'2018-08-29 10:00:30','2018-08-29 10:18:25','Good house keeping n merchandising. All posm and wet stocks  in plc, Keep moving forward. N focus more on customer service up selling n promoting e card n promoting perfume tanker. ',244,0,'ajR2SXZCdExtNjYwaEErQlY2YlNZdz09','2018-08-29 10:00:30','2018-08-29 02:18:26'),(1752,3,39,168466,'Hazmil','Staff',NULL,'1535508234',1,'2018-08-29 10:03:54','2018-08-29 10:17:57','Pls report cctv problem',176,0,'bmhWaUN6ZXJ6T3dKWDhaYkxweDdHQT09','2018-08-29 10:03:54','2018-08-29 02:17:57'),(1753,4,112,168707,'Nathan','Manager',NULL,'1535511273',1,'2018-08-29 10:54:33','2018-08-29 11:22:02','NA',251,0,'aStEQlFsYjhWcWlNcnpDQzRDWW54QT09','2018-08-29 10:54:33','2018-08-29 03:22:03'),(1754,3,97,168702,'Raj','Station manager',NULL,'1535511613',1,'2018-08-29 11:00:13','2018-08-29 11:19:23','To improve servicong',191,0,'aElCcVZFekl3cEdpVGp4S2RxOE1xdz09','2018-08-29 11:00:13','2018-08-29 03:19:23'),(1755,5,225,168766,'Priya','Supervisor',NULL,'1535513461',1,'2018-08-29 11:31:01','2018-08-29 11:47:34','Advice Harks to clean up all the pumps accordingly. Some stains here n there.Focus more on customer service up selling n promoting e card and promote perfume tanker. Overall good house keeping n all posm n wet stocks in plc.Electical rooms needs to keep clean too many stocks kept inside.',237,0,'SVZHMFpTeHBxbHRwaEplWjVHUXJiQT09','2018-08-29 11:31:01','2018-08-29 03:47:35'),(1756,4,318,169050,'Normala','Cashier',NULL,'1535518276',1,'2018-08-29 12:51:16','2018-08-29 13:26:38','Station Diesel OOS.',228,0,'cDhydkI0RlJkdm14WVMvNElZZHh6Zz09','2018-08-29 12:51:16','2018-08-29 05:26:39'),(1757,5,175,169049,'Mr, Chua','Dealer',NULL,'1535519572',1,'2018-08-29 13:12:52','2018-08-29 13:23:58','Overall good house keeping. Needs to focus more on customer service up selling n promoting e card. Make sure forcourt staffs provide good customer service to customers',205,0,'MG5mSlZ4bkxkRENsUlJ1MzhVOVhYZz09','2018-08-29 13:12:52','2018-08-29 05:23:58'),(1758,3,41,169118,'Haziq','Staff',NULL,'1535520293',1,'2018-08-29 13:24:53','2018-08-29 13:56:41','To improve servicing',161,0,'Yi84YTBZOElpY2FKcXJkV2FQWDV1Zz09','2018-08-29 13:24:53','2018-08-29 05:56:42'),(1760,4,118,169262,'Ms Yong','Supervisor',NULL,'1535523718',1,'2018-08-29 14:21:58','2018-08-29 14:39:34','NA',201,0,'YU1LWitDQnAyWWtDcE1rNmx5YlpBUT09','2018-08-29 14:21:58','2018-08-29 06:39:34'),(1761,5,193,169398,'Mr.Lee','Dealer',NULL,'1535525271',1,'2018-08-29 14:47:51','2018-08-29 15:44:37','Overall good house keeping n posm n wet stocks in plc,Focus more on services up  n provide good service. Well kept.Advice cashiers  be more alert.Advice Ah Leng to wear black pants.',240,0,'VzIrNkhVcXJ5SS9RSlJjTC9tT0czZz09','2018-08-29 14:47:51','2018-08-29 07:44:37'),(1762,3,87,169380,'Aliyah','Staff',NULL,'1535525716',1,'2018-08-29 14:55:16','2018-08-29 15:12:50','Cashier to improve cross selling',273,0,'VWRhc1FRK2RFbjhOZWpmUFdOVTh1Zz09','2018-08-29 14:55:16','2018-08-29 07:12:50'),(1763,4,128,169500,'Imeer','Supervisor',NULL,'1535529241',1,'2018-08-29 15:54:01','2018-08-29 16:22:44','Part of station under renovation',222,0,'L25waVhVOXZPTFAzejdtZXdsdjVidz09','2018-08-29 15:54:01','2018-08-29 08:22:44'),(1764,3,55,169537,'Rahim','Dealer',NULL,'1535530708',1,'2018-08-29 16:18:28','2018-08-29 16:30:01','Cctv off',177,0,'QnJCMFhNYUdWU211MCtEMElNcyt2Zz09','2018-08-29 16:18:28','2018-08-29 08:30:04'),(1765,5,236,169735,'Mr.Looi','Manager',NULL,'1535532893',1,'2018-08-29 16:54:53','2018-08-29 17:24:09','Good housekeeping and wet stocks n  posm all in plc.Cashiers n forcourt staffs needs to focus more on customer service up selling n promoting e card. Good job',225,0,'RjBPb0xVWHpLT1hMQ1A1RndsRllJdz09','2018-08-29 16:54:53','2018-08-29 09:24:10'),(1766,3,40,169782,'Niah','Station supervisor',NULL,'1535535715',1,'2018-08-29 17:41:55','2018-08-29 17:58:55','To improve servicing',223,0,'MXhHZjBpbmw4b0ZlNVlCdis3dHZNdz09','2018-08-29 17:41:55','2018-08-29 09:58:55'),(1767,3,51,170041,'Ak','Staff',NULL,'1535540227',1,'2018-08-29 18:57:07','2018-08-29 19:10:29','Cctv rosak, pls report.',269,0,'SUw1R2hJUEdkVUVRVWIxUE42WndSQT09','2018-08-29 18:57:07','2018-08-29 11:10:29'),(1768,5,242,170245,'Karthiga','Supervisor',NULL,'1535591284',1,'2018-08-30 09:08:04','2018-08-30 09:43:26','Overall good house keeping, Forcourt staffs needs focus n give more attention on  services including cashiers .No greetings, selling n promoting e card  n promoting fuel tanker. Advice Udas to wear proper black pants.Customers service  training needed. Back to basic.Good sales n Advice all cashiers n forcourt staffs provide good service. Spoke to Karthiga the above matters',233,0,'RzVXdzZiZ3ZHUEt3dEptcEE1dTVCQT09','2018-08-30 09:08:04','2018-08-30 01:43:26'),(1769,3,94,170251,'Anita','Station supervisor',NULL,'1535594053',1,'2018-08-30 09:54:13','2018-08-30 10:13:18','Good.',290,0,'ZXRaWDF0NXR1NHIzYWxqcWxFdWFYZz09','2018-08-30 09:54:13','2018-08-30 02:13:18'),(1770,3,67,170360,'Aishah','Station supervisor',NULL,'1535598134',1,'2018-08-30 11:02:14','2018-08-30 11:29:20','Good',290,0,'SUc2L3E5MjdBT2Nad1dxdnBydXN5dz09','2018-08-30 11:02:14','2018-08-30 08:41:40'),(1771,5,189,170426,'Mansur','Dealer',NULL,'1535598524',1,'2018-08-30 11:08:44','2018-08-30 11:51:10','Overall good house keeping. All  posm n wet in placed.Advice forcourt crew Azlan to emphasise more on customer service up selling n promoting e card. Keep moving forward n provide good services.Toilet well kept. Advice to monitor at all time,Cashier slightly weak on customer service. All pumps n bay  are clean free from dust n stains',235,0,'QWN2RmpMRWcyYTNiMm1FOEtEdVhNQT09','2018-08-30 11:08:44','2018-08-30 03:51:10'),(1772,14,223,172349,'Rana','Cashier',NULL,'1537330787',1,'2018-09-19 12:19:47','2018-09-19 13:10:21','Maintence kerja sedang diuruskn  bahagian luar dan dalam. Bilik kompresor kotor dan berminyak perlu di bersihkn.adit mesti pakai seluar hitam dan kasut betul.keseluruahan station kerbersihan memuaskn.',213,0,'OWtNQUhkUjZWS1lvakJ2RGFkbEp4dz09','2018-09-19 12:19:47','2018-09-19 05:10:21'),(1773,14,202,172457,'Sazzad','Supervisor',NULL,'1537342592',1,'2018-09-19 15:36:32','2018-09-19 16:11:26','Kelemahan pada customer service luar dan dalam.di fourcoart terlalu banyak kerete yang parking di merata tempat harus di perhatian.kebersihan amat memuaskn.',216,0,'WC9DQVU4WGUxWUNJNTdQNHpmUVVDZz09','2018-09-19 15:36:32','2018-09-19 08:11:26'),(1774,14,115,172589,'Osman','Casheir',NULL,'1537842834',1,'2018-09-25 10:33:54','2018-09-25 12:21:42','Kebersihan disekitar station terutama tempat turun minyak perdibersihkn.\r\nPengetahuan staff tentang cara-cara menggunakan pemadam api perlu follow up.',175,0,'S0ZkVjBFNmJEUzRad3RZTHgrNnB4Zz09','2018-09-25 10:33:54','2018-09-25 04:21:42'),(1775,14,130,172718,'Mariful','Superviser',NULL,'1537860585',1,'2018-09-25 15:29:45','2018-09-25 16:47:44','Forecourt and cashier service need to improve.',206,0,'Wll2dTQ4TzhBc0pkaE5jSDRXUVpaQT09','2018-09-25 15:29:45','2018-09-25 08:47:44'),(1776,14,168,172844,'Imron','Casheir',NULL,'1537928637',1,'2018-09-26 10:23:57','2018-09-26 11:44:38','NA',238,0,'VjB3akhnbkQrdU8vamFrSWptL3c3UT09','2018-09-26 10:23:57','2018-09-26 03:44:39'),(1777,14,171,172973,'Arifin','Casheir',NULL,'1537944620',1,'2018-09-26 14:50:20','2018-09-26 16:00:07','Staff cashier dan forecuort perlu tingkatkn service.\r\n',233,0,'QkNkWmdKMHVyOGxxUXZBMDlEVW42Zz09','2018-09-26 14:50:20','2018-09-26 08:00:07'),(1778,8,189,NULL,NULL,NULL,NULL,'1538041160',0,'2018-09-27 17:39:20',NULL,NULL,0,0,'','2018-09-27 17:39:20','2018-09-27 09:39:20');

--
-- Table structure for table `mscategories`
--

CREATE TABLE `mscategories` (
  `id` smallint(10) NOT NULL AUTO_INCREMENT,
  `mssection_id` smallint(10) NOT NULL,
  `title` tinytext NOT NULL,
  `position` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `msformcategories_fk_1` (`mssection_id`),
  CONSTRAINT `msformcategories_fk_1` FOREIGN KEY (`mssection_id`) REFERENCES `mssections` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mscategories`
--

INSERT INTO `mscategories` VALUES (1,1,'Value',1,'2018-02-26 00:00:00','2018-03-03 20:40:16'),(2,1,'Friendly Services (S W A T) - Forecourt Staff',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(3,2,'Appearance - Cashier',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(4,2,'Friendly Services (S W E E T) - Cashier',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(5,3,'Surrounding',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(6,3,'Cleanliness - Pumps',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(7,3,'Cleanliness - Forecourt',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(8,3,'Cleanliness - Toilet',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(9,4,'HSE - Health, Safety, Environment',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(10,5,'Quality & Trust',1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(11,6,'Service',1,'2018-03-06 00:00:00','2018-03-05 21:16:35');

--
-- Table structure for table `mscompliances`
--

CREATE TABLE `mscompliances` (
  `id` smallint(11) NOT NULL AUTO_INCREMENT,
  `mssub_category_id` smallint(11) NOT NULL,
  `file_id` int(11) DEFAULT NULL,
  `item` text NOT NULL,
  `points` int(10) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `msformcompliances_fk_1` (`mssub_category_id`),
  KEY `msformcompliances_fk_2` (`file_id`),
  CONSTRAINT `msformcompliances_fk_1` FOREIGN KEY (`mssub_category_id`) REFERENCES `mssub_categories` (`id`),
  CONSTRAINT `msformcompliances_fk_2` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mscompliances`
--

INSERT INTO `mscompliances` VALUES (1,1,NULL,'<p>Forecourt staff available at the forecourt ,Directing traffic into the station, cleaning pumps /doing housekeeping or attending to customers if there are customers at the forecourt</p><p>Forecourt staff talking among themselves or not assisting customer; sitting at the shop apron / motorcycle or coming out from the shop / other area in the station premises upon seeing the auditor coming is NOT accepted (if found, automatically the points under Category 1.1 will be ZERO)</p>',5,'2018-02-26 00:00:00','2018-03-04 14:45:10'),(2,2,NULL,'<p>Wearing approved and clean BHPetrol uniform</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(3,2,NULL,'<p>Black pants (no jeans)</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(4,2,NULL,'<p>Completely black shoes (no stripes or band of colour shoes & no sandals)</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(5,2,NULL,'<p>Name tag (with name written on the tag) / embroidered name; wordings have to be black and printed</p>',1,'2018-02-26 00:00:00','2018-03-05 17:38:58'),(6,2,NULL,'<p>For Muslim ladies who wears headscarf (tudung), the colour must be plain Black tudung.</p><p>For Staff not wearing Tudung, Hair must be properly Groomed.</p>',1,'2018-02-26 00:00:00','2018-03-05 17:51:00'),(7,3,NULL,'<p>Smile & eye contact when approaching customer or Welcoming customer i.e. Selamat Datang / Hi / Welcome etc (verbal or gesture) NOT acceptable if the forecourt staff is just standing / sitting at one position and did not acknowledge customer</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(8,4,NULL,'<p>Friendly farewell or gesture saying \"Bye\"</p>',5,'2018-02-26 00:00:00','2018-03-05 17:46:29'),(9,6,NULL,'<p>Wearing approved and clean BHPetrol uniform</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(10,6,NULL,'<p>Black pants (no jeans)</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(11,6,NULL,'<p>Completely black shoes (no stripes or band coloured shoes & no sandals)</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(12,6,NULL,'<p>Name tag (with name written on the tag) / embroidered name; wordings have to be black</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(13,6,NULL,'<p>For Muslim ladies who wears headscarf (tudung), the colour must be plain Black tudung.</p><p>For Staff not wearing Tudung, Hair must be properly Groomed.</p>',1,'2018-02-26 00:00:00','2018-03-05 17:50:52'),(14,7,NULL,'<p>Welcoming customer i.e. Selamat Datang / Hi / Welcome etc (verbal or gesture), Smile and eye contact when approaching customer. NOT acceptable if the Cashier is just standing / sitting at one position or on the phone (Usage of mobile phone allowed only and during Line Promo for assiting customer during the promo)</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(15,8,NULL,'<p>Ask customer for eCard</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(16,8,NULL,'<p>If Customer has no \"e\" card, cashier asked to apply for an \"e\" Card</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(17,9,NULL,'<p>Extra cross sell on any additional / promotional products</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(18,10,NULL,'<p>Friendly farewell or gesture Saying \"Bye\"</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(19,11,NULL,'<p>To ensure that the drivers of the vehicles have a clear and unobstructed view when entering and leaving the station, with the ingress and eggress without any pothole unless reported in the SML</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(20,11,NULL,'<p>Tanker Acceptance Area is clean and unobstructed with no tanker seals thrown around</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(21,11,NULL,'<p>No dangling wires or string 2</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(22,11,NULL,'<p>No oil stains and rubbish in the station drain</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(23,11,NULL,'<p>No litter in station surrounding, except Cyclone area(If Litter found in the Cyclone area , Auditor to remark)</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(24,11,NULL,'<p>Station Spreader not faded, no cobweb and clean</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(25,11,NULL,'<p>MID not obstructed and in good order (Not Faded)</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(26,11,NULL,'<p>Tarmac surrounding the station in good order and no pothole</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(27,12,NULL,'<p>Grass trimmed, clear of rubbish and dried leaves</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(28,12,NULL,'<p>Drains clear and not clogged (public drain excluded)</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(29,12,NULL,'<p>Oil interceptors free of rubbish and sludge</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(30,12,NULL,'<p>No unauthorized promo display, promo A-board etc</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(31,12,NULL,'<p>Trash area clean and tidy. All rubbish bins in good condition and not overflowing</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(32,13,NULL,'<p>Building exterior clean and in good condition, Paint not faded or peeling</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(33,13,NULL,'<p>Fascia (mini bullnose) is free from dirt, dust and no cobwebs</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(34,13,NULL,'<p>No unauthorized stickers, poster, banner and signage</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(35,13,NULL,'<p>Glass door and panels clean (no papers sticked on the glass, no unauthorized stickers and hand marks)</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(36,13,NULL,'<p>All authorized signage and safety sticker must be placed at the correct designated / approved space on the glass panel</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(37,13,NULL,'<p>ALL signages are clean and undamaged, not faded or cracked. No handwritten or nonapproved signages</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(38,14,NULL,'<p>Cleaned, must be free from oil, stains and dust and not leaking</p>',6,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(39,14,NULL,'<p>Splash guard clean (no stains)</p>',6,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(40,14,NULL,'<p>No strings tied to the Nozzle and all nozzle in working order</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(41,15,NULL,'<p>Pump Panel Clean and not Damaged</p>',4,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(42,15,NULL,'<p>Pump hoses, nozzle hood, nozzle housing, pump shoulder clean</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(43,15,NULL,'<p>No unauthorized stickers permitted on any part of the dispenser and Pump panel</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(44,15,NULL,'<p>No dust and cobwebs at all pumps</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(45,15,NULL,'<p>All dispensers accessible and functioning, if closed with cones due to breakdown, must be reported in SML</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(46,16,NULL,'<p>Forecourt surface including pump islands area and the dogbone area clean</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(47,16,NULL,'<p>Forecourt Parking Bay Marker in good order (Tiles or Painted)</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(48,17,NULL,'<p>All pump toppers POSM are updated and not faded</p>',4,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(49,17,NULL,'<p>Pump Toppers not damaged, unless reported in the SML</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(50,18,NULL,'<p>Clean and in good condition</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(51,18,NULL,'<p>Rubbish bin liners available, clean and not overflowing</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(52,18,NULL,'<p>Tissues / toilet rolls available at the amenity bin</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(53,18,NULL,'<p>Water container and watering can with clean water</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(54,18,NULL,'<p>Squeegee available and in good condition</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(55,19,NULL,'<p>Accessible, free of graffiti and working, If breakdown, standard signage is placed \"Harap Maaf, Sedang Dibaiki\" (no handwritten notice) and must be reported in the SML</p>',5,'2018-02-26 00:00:00','2018-03-03 22:04:52'),(57,21,NULL,'<p>Overall Forecourt Area Clean, no litters , rubbish, major stain and no pothole</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(58,21,NULL,'<p>No Staff or dealers car or motorcycle parked at the forecourt</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(59,22,NULL,'<p>For BHPetromart, no items permitted except newspaper rack and authorized items approved by BHPetrol and for non BHPetromarts ONLY authorized items placed or displayed on the apron</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(60,22,NULL,'<p>Fire extinguisher (placed at the furthest right of the shop entrance)</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(61,22,NULL,'<p>No chairs, tables, dustbin, umbrella stand, potted plants etc</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(62,22,NULL,'<p>Station apron clean and no stain</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(63,22,NULL,'<p>Apron no damaged tiles unless reported in the SML</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(64,23,NULL,'<p>At least one toilet MUST be opened and NOT locked during operating hours</p>',5,'2018-02-26 00:00:00','2018-03-03 22:11:11'),(65,23,NULL,'<p>Toilets tidy, clean and free of graffiti</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(66,24,NULL,'<p>Clean and no stains or dust</p>',5,'2018-02-26 00:00:00','2018-03-03 22:11:42'),(67,24,NULL,'<p>Paint/Tiles in good order and not faded</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(68,25,NULL,'<p>Clean, dry and exception if toilets have been washed or cleaned (Wet)</p>',5,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(69,26,NULL,'<p>Clean and no stains</p>',5,'2018-02-26 00:00:00','2018-03-03 22:14:44'),(70,26,NULL,'<p>Sink not leaking</p>',3,'2018-02-26 00:00:00','2018-03-03 22:15:49'),(71,26,NULL,'<p>Water tap functioning and can access to wash hand at the sink</p>',5,'2018-02-26 00:00:00','2018-03-03 22:16:23'),(72,27,NULL,'<p>Working and in good order</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(73,28,NULL,'<p>Toilet seat cover should be without stains or shoe mark and scratches</p>',5,'2018-02-26 00:00:00','2018-03-03 22:17:37'),(74,29,NULL,'<p>Clean and NO yellow stains</p>',5,'2018-02-26 00:00:00','2018-03-03 22:20:50'),(75,30,NULL,'<p>Mirror not broken or stained(If available)</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(76,31,NULL,'<p>Ceiling in good condition and no damage</p>',5,'2018-02-26 00:00:00','2018-03-03 22:19:51'),(77,32,NULL,'<p>Toilet Door in good order</p>',5,'2018-02-26 00:00:00','2018-03-03 22:20:12'),(78,33,NULL,'<p>Visible, in working condition and easily accessible</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(79,33,NULL,'<p>Minimum 2 units available at the pump islands / all pump islands with fire extinguishers</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(80,34,NULL,'<p>Robbery - C O P S</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(81,34,NULL,'<p>Fire - What to do in case of fire</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(82,34,NULL,'<p>Fire Extinguisher - How to use it</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(83,35,NULL,'<p>Not more than RM500.00 cash per till</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(84,36,NULL,'<p>Not used as accomodation or rest area for staff</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(85,36,NULL,'<p>Have 1 fire extinguisher (recommended CO2 fire extinguisher) in the room</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(86,37,NULL,'<p>Easily accessible in emergencies</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(87,37,NULL,'<p>No expired items</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(88,37,NULL,'<p>Contain 14 items as recommended by BHPetrol</p>',1,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(89,38,NULL,'<p>If CRIND not functioning, should be recorded in the SML and reported to RAS ,(In case of breakdown, standard signage is placed \"Harap Maaf, Sedang Dibaiki and\" no handwritten notice)</p>',3,'2018-02-26 00:00:00','2018-03-03 21:05:02'),(90,39,NULL,'<p>Closed from 7.00am - 10.00pm (unless the time specified by the respective TM)</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(91,39,NULL,'<p>Standard signage is displayed \"Harap maaf , Sila bayar didalam\" at the Night Pay Counter (to be placed at the Night Pay Counter facing the forecourt)</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(92,39,NULL,'<p>Night Pay counter in good order, no paint peeling and not faded</p>',3,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(93,40,NULL,'<p>No other brands of mineral water besides \"Arctic\"</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(94,40,NULL,'<p>No competitors lubricants displayed at the shop shelves and also No fuel additives i.e. STP , JB Brothers products and others</p>',2,'2018-02-26 00:00:00','2018-03-05 17:52:06'),(95,41,NULL,'<p>Wet stock control book/Orange Book available on site during the audit</p><p><strong>If not comply, the dealer to be scored a straight zero for Section E</strong></p>',4,'2018-02-26 00:00:00','2018-03-05 17:53:17'),(96,42,NULL,'<p>Epay and Touch n Go available with minimum balance</p>',2,'2018-02-26 00:00:00','2018-02-25 20:15:00'),(97,5,NULL,'<p>If staff not in full uniform - Section \'A\' Forecourt will be scored totally Zero.</p>',1,'2018-03-06 00:00:00','2018-03-05 19:34:29'),(98,43,NULL,'If staff not in full uniform - Section \'B\' Shop will be scored totally Zero',1,'2018-03-06 00:00:00','2018-03-05 20:27:06'),(99,44,NULL,'<p>If rubbish bin liners are not available, Section C , Part 3(Cleanliness-Forecourt) will be scored Zero.</p>',1,'2018-03-06 00:00:00','2018-03-05 20:47:47'),(100,45,NULL,'<p>If toilet is found with unpleasant smell; 15 Points will be deducted</p>',-15,'2018-03-06 00:00:00','2018-03-05 20:57:41'),(101,46,NULL,'<p>If toilet(Toilet in BHPetromart) is found with unpleasant smell and not clean with stain and dust ; 15 Points will be deducted.</p>',-15,'2018-03-06 00:00:00','2018-03-05 20:57:37'),(102,47,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:22:01'),(103,47,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 22:03:15'),(104,47,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:27:46'),(105,47,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:27:46'),(106,47,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:30:09'),(107,48,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:30:09'),(108,48,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:30:09'),(109,48,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:30:09'),(110,48,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:30:09'),(111,48,NULL,'<p>Date and time CCTV viewed</p>',1,'2018-03-06 00:00:00','2018-03-05 21:30:09');

--
-- Table structure for table `mssections`
--

CREATE TABLE `mssections` (
  `id` smallint(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `title` varchar(250) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mssections`
--

INSERT INTO `mssections` VALUES (1,'A','Forecourt','2018-02-26 00:00:00','2018-03-05 17:45:20'),(2,'B','Shop','2018-02-26 00:00:00','2018-02-26 02:24:13'),(3,'C','Cleanliness ','2018-02-26 00:00:00','2018-02-26 02:24:13'),(4,'D','Health, Safety, Environment (HSE)','2018-02-26 00:00:00','2018-02-26 02:25:03'),(5,'E','Quality & Trust','2018-02-26 00:00:00','2018-02-26 02:25:03'),(6,'F','CCTV','2018-03-06 00:00:00','2018-03-05 21:08:40');

--
-- Table structure for table `mssub_categories`
--

CREATE TABLE `mssub_categories` (
  `id` smallint(11) NOT NULL AUTO_INCREMENT,
  `mscategory_id` smallint(11) NOT NULL,
  `title` text,
  `description` longtext,
  `position` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `msformsubcategories_fk_1` (`mscategory_id`),
  CONSTRAINT `msformsubcategories_fk_1` FOREIGN KEY (`mscategory_id`) REFERENCES `mscategories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `mssub_categories`
--

INSERT INTO `mssub_categories` VALUES (1,1,'Forecourt Staff Visible & Working at the Forecourt',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(2,1,'Forecourt Staff Appearance',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(3,2,'Acknowledge Customer',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(4,2,'Thank you',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(5,2,'Overall Forecourt Staff Appearance',NULL,3,'2018-03-06 00:00:00','2018-03-05 18:04:30'),(6,3,'Cashier Appearance',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(7,4,'Acknowledge Customer',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(8,4,'Loyalty Card',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(9,4,'Cross Selling',NULL,3,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(10,4,'Thank you',NULL,4,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(11,5,'Station Surrounding',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(12,5,'Station Compound',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(13,5,'Building & Fixtures',NULL,3,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(14,6,'Nozzles',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(15,6,'Pumps',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(16,6,'Pump Islands & Filling Bays',NULL,3,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(17,6,'Pump Toppers',NULL,4,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(18,7,'Amenity Units',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(19,7,'Tyre Inflator',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(21,7,'Forecourt',NULL,4,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(22,7,'Apron & Shop Front',NULL,5,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(23,8,'Accessibility',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(24,8,'Walls & Windowpanes Clean',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(25,8,'Floors Clean',NULL,3,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(26,8,'Sink Clean',NULL,4,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(27,8,'Toilet Flush',NULL,5,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(28,8,'Toilet Seat cover',NULL,6,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(29,8,'Toilet & Urinal Bowl',NULL,7,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(30,8,'Toilet Mirror',NULL,8,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(31,8,'Toilet Ceiling',NULL,9,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(32,8,'Toilet Door',NULL,10,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(33,9,'Fire Extinguishers',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(34,9,'Staff Understand & Know Safety / Emergency Procedures',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(35,9,'Cash Handling Processes',NULL,3,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(36,9,'Switch Board Room & Compressor Room',NULL,4,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(37,9,'First Aid Box',NULL,5,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(38,10,'Card',NULL,1,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(39,10,'Night Pay Counter',NULL,2,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(40,10,'No Competitors Products',NULL,3,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(41,10,'Wet Stock Control Book',NULL,4,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(42,10,'Epay and Touch n Go',NULL,5,'2018-02-26 00:00:00','2018-02-25 19:24:14'),(43,4,'Overall Cashier\'s Appearance',NULL,5,'2018-03-06 00:00:00','2018-03-05 20:26:33'),(44,7,'Rubbish Bin Liners',NULL,5,'2018-03-06 00:00:00','2018-03-05 20:46:54'),(45,8,'Toilet Ambience',NULL,11,'2018-03-06 00:00:00','2018-03-05 20:55:17'),(46,8,'Internal Toilet Ambience',NULL,12,'2018-03-06 00:00:00','2018-03-05 20:55:17'),(47,11,'Forecourt Staff',NULL,1,'2018-03-06 00:00:00','2018-03-05 21:17:40'),(48,11,'Cashier',NULL,1,'2018-03-06 00:00:00','2018-03-05 21:17:40');

--
-- Table structure for table `mssub_category_tag`
--

CREATE TABLE `mssub_category_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mssub_category_id` smallint(11) NOT NULL,
  `tag_id` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `mssub_cat_index1` (`mssub_category_id`),
  KEY `mssub_cat_index2` (`tag_id`),
  CONSTRAINT `mssub_cat_index1` FOREIGN KEY (`mssub_category_id`) REFERENCES `mssub_categories` (`id`),
  CONSTRAINT `mssub_cat_index2` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `mssub_category_tag`
--

INSERT INTO `mssub_category_tag` VALUES (1,38,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(2,39,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(3,40,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(4,41,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(5,42,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(6,33,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(7,34,1,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(8,35,1,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(9,36,1,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(10,37,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(11,11,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(12,12,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(13,13,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(14,14,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(15,15,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(16,16,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(17,17,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(18,18,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(19,19,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(20,21,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(21,22,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(22,23,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(23,24,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(24,25,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(25,26,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(26,27,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(27,28,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(28,29,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(29,30,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(30,31,2,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(31,32,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(32,6,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(33,7,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(34,8,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(35,9,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(36,10,3,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(37,1,1,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(38,2,1,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(39,3,1,'2018-03-04 00:00:00','2018-03-03 23:54:14'),(40,4,1,'2018-03-04 00:00:00','2018-03-03 23:54:14');

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` smallint(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL,
  `title` varchar(250) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `sections`
--

INSERT INTO `sections` VALUES (1,'A','Main Category Compliance Check','2018-01-21 00:00:00','2018-01-21 10:24:24'),(2,'B','Other Categories Compliance Check','2018-01-21 00:00:00','2018-01-21 10:24:13'),(3,'C','General Merchandising Standards ','2018-01-21 00:00:00','2018-01-21 10:24:13'),(4,'D','Promotions','2018-01-21 00:00:00','2018-01-21 10:25:03'),(5,'E','Food Safety','2018-01-21 00:00:00','2018-01-21 10:25:03'),(6,'F','Maintaining Store Image','2018-01-21 00:00:00','2018-01-21 10:25:35'),(7,'G','Special Project','2018-01-21 00:00:00','2018-01-21 10:25:35'),(8,'H','Pre Requisite','2018-01-21 00:00:00','2018-01-21 10:26:17');

--
-- Table structure for table `stations`
--

CREATE TABLE `stations` (
  `id` smallint(11) NOT NULL AUTO_INCREMENT,
  `trading` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `name` varchar(250) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `territory` varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` tinytext NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=383 DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `stations`
--

INSERT INTO `stations` VALUES (1,'Eng Teik & Co','BHPetrol Greenlane','T01','ktkhoo818@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(2,'Masree Enterprise','BHPetrol Selising','T03','masree5361@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(3,'MIFIN Fuel Enterprise','BHPetrol Bukit Minyak','T01','mifin_fuel6163@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(4,'Naluri Service Station & Trading','BHPetrol Jitra','T03','bhpjitra@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(5,'Emmy Empire Sdn Bhd','BHPetrol Bukit Kayu Hitam','T03','emmyempiresdnbhd@gmail.com','2018-03-01 00:00:00','2018-08-29 10:17:43'),(6,'Koperasi Guru Pulau Pinang Berhad','BHPetrol Jalan Anson','T01','lim.beng.chooi@gmail.com','2018-03-01 00:00:00','2018-04-14 02:06:15'),(7,'Stesyen Minyak Era Jaya','BHPetrol Bukit Tengah','T01','tanskuang@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(8,'Syarikat Lee Brothers Service Station','BHPetrol Jalan Jelutong','T01','bhpjelutong@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(9,'Trio Auto Service','BHPetrol Lbraya Sultan Abdul Halim','T03','chngth1@yahoo.com.sg','2018-03-01 00:00:00','2018-02-28 16:00:00'),(10,'Malek Filling Station','BHPetrol Parit Buntar','T01','malekrahim888@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(11,'Warna RS Trading','BHPetrol Kampong Raja','T03','warnarstrading@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(12,'RCK Jaya Resources','BHPetrol Jalan Baru','T01','ahmadizzat@gmail.com','2018-03-01 00:00:00','2018-08-29 10:18:46'),(13,'Snorty Enterprise','BHPetrol Simpang Empat','T01','snortyenterprise@gmail.com','2018-03-01 00:00:00','2018-03-22 13:20:40'),(14,'Hijrah Afdal Enterprise','BHPetrol Labok ','T03','bhplabok@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(15,'Infinity Service Station','BHPetrol Jawi','T01','infinityss@live.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(16,'Thye Hin Capital Sdn Bhd','BHPetrol Alor Setar (Lencongan Barat)','T01','eterndev97@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(17,'Percaya Jaya Health Care Sdn Bhd','BHPetrol Pokok Sena','T01','petrol@percayajaya.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(18,'Teik Seng Filling Station Sdn. Bhd.','BHPetrol Bagan Serai','T01','bs.bhpetrol@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(19,'Mega Trade','BHPetrol Kg. Chicha','T03','mymegatrade88@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(20,'Shamisha Petroleum Sdn. Bhd. ','BHPetrol Taman Desa Aman','T01','s.petroleum59@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(21,'Hijrah Maju Jaya Enterprise','BHPetrol Bukit Payong','T03','bhp.bukitpayong@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(22,'KM Bahagia Sdn Bhd','BHPetrol Taman Batik','T01','kmbahagia2014@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(23,'Deltamaju Enterprise','BHPetrol Jalan Kulim','T01','emmyempiresdnbhd@gmail.com','2018-03-01 00:00:00','2018-08-02 03:28:19'),(24,'Maju Filling Station','BHPetrol Wakaf Bharu','T03','majufilling@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(25,'Purity Oil Resources','BHPetrol Salor 2','T03','bhpsalor@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(26,'Mega Raya Enterprise Sdn Bhd','BHPetrol Kg Telekong','T03','housechai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(27,'Thawatchai Enterprise','BHPetrol Ayer Itam','T01','ktkhoo818@gmail.com','2018-03-01 00:00:00','2018-07-06 06:06:56'),(28,'Matang Lean Hin Sdn Bhd','BHPetrol Simpang','T02','matangleanhin@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(29,'Promtas Sdn. Bhd.','BHPetrol Trong 2','T02','Mok860522@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(30,'Chop Mooi Heng','BHPetrol Simpang 2','T02','chopmooiheng@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(31,'Mok Chee Pheng','BHPetrol Kg Jelutong','T02','Mok860522@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(32,'Syarikat Shukri','BHPetrol Kuala Nerang','T01','afisya25@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(33,'Mohd. Marzuki Bin Abdul Rahman','BHPetrol Kampong Pisang','T01','bhpetrol_kgpisang@yahoo.com','2018-03-01 00:00:00','2018-07-27 07:37:17'),(34,'Hisman Teguh Enterprise','BHPetrol Kg Gajah Mati','T01','hismanteguh@gmail.com','2018-03-01 00:00:00','2018-07-27 09:59:32'),(35,'Sirabayas Awana Enterprise','BHPetrol Padang Lengkuas','T01','shaz.zain@berkatoil.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(36,'Anjung Warna Sdn Bhd','BHPetrol Taman Kemas','T12','bhpkemas@live.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(37,'Asliyana Holdings Sdn Bhd','BHPetrol Segamat','T11','bhpetrol.segamat@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(38,'Bertam Service Station','BHPetrol Bertam','T11','bhp.bertam@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(39,'Felda Trading Sdn Bhd','BHPetrol Air Tawar 2','T12','usm.bhpairtawar02@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(40,'Felda Trading Sdn Bhd','BHPetrol Bukit Besar','T12','bp.bukitbesar@felda.net.my','2018-03-01 00:00:00','2018-05-25 03:29:59'),(41,'Felda Trading Sdn Bhd','BHPetrol Tenggaruh','T12','intankhairul65@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(42,'Gracedex Consolidated Sdn Bhd','BHPetrol Ayer Keroh','T11','hgtio@sinoilgroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(43,'Hock Chan Hoe Kee Sdn Bhd','BHPetrol Sg Mati','T11','hockchanhoekee@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(44,'Hock Choon Service Station','BHPetrol Yong Peng','T11','bhpyongpeng@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(45,'Hock Lee Motor Service Station','BHPetrol Jalan Tebrau 1','T12','hockleebhp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(46,'Kah Heng & Co','BHPetrol Jalan Bakau Chondong','T11','kahhengco@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(47,'Kam Fatt Chan Trading Sdn Bhd ','BHPetrol Jalan Rasah','T11','kamfattchan@gmail.com','2018-03-01 00:00:00','2018-07-27 03:42:02'),(48,'Karzal Highway Enterprise','BHPetrol Pasir Gudang Highway 3','T12','azura142@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(49,'Karzal Sdn Bhd','BHPetrol Jalan Tebrau 2','T12','azahari_bakar@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(50,'Koperasi Anggota-Anggota Kerajaan','BHPetrol Jalan Rahmat','T11','kaakbp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(51,'Masai Union Transport Sdn Bhd','BHPetrol Ulu Tiram','T12','bpulutiram@sb.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(52,'Pacific Tycoon Sdn Bhd ','BHPetrol Plentong','T12','pacifictycoonsdnbhd@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(53,'Pandan Petrol & Service Station','BHPetrol Lorong Pandan','T11','bhppandanpetrol@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(54,'Al Abrar Molek Petrol Station','BHPetrol Taman Molek','T12','bhpmolek@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(55,'Perniagaan Nurrahim','BHPetrol Kota Tinggi','T12','rozitah.ahmad.72@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(56,'Petroleum & Gas JME Sdn Bhd','BHPetrol Bukit Katil','T11','bhpbukitkatil@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(57,'Promosi Jaya Sdn Bhd','BHPetrol Taman Rinting','T12','Soumuntang@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(58,'Seng Kong Properties Sdn Bhd','BHPetrol Senggarang','T11','ganisme0710@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(59,'Shun Li Agency & Enterprise','BHPetrol Jalan Hang Tuah','T11','hgtio@sinoilgroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(60,'Esjay Fuel Enterprise','BHPetrol Permas Jaya 2','T12','esjayfuel@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(61,'Station Minyak Parit Betak','BHPetrol Benut','T12','smpb.jhr@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(62,'Stesen Pam Minyak Medan Jaya S/B','BHPetrol Gemas','T11','spmmj@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(63,'Syarikat Mah Chin Cheong','BHPetrol Jalan Rogayah','T11','bhpetrol.rogayah@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(64,'Visi One Trading','BHPetrol Pasir Gudang Highway 1','T12','nsidjb@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(65,'Visi Two Trading','BHPetrol Pasir Gudang Highway 2','T12','nsidjb@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(66,'ZNR Petrol & Service','BHPetrol Taman Johor Jaya','T12','znrpetrol@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(67,'Al Abrar Senai Two Petrol Station','BHPetrol Senai 2','T12','bhpsenai2@live.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(68,'Saidalvi Petrol & Services','BHPetrol Masai','T12','bhpmasai56@yahoo.com','2018-03-01 00:00:00','2018-03-07 03:06:14'),(69,'Perniagaan Hong Guan','BHPetrol Pontian','T12','wckoi@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(70,'Rosmerah Petrol Station & Services','BHPetrol Rosmerah','T12','rosmerah56@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(71,'Nasa Maju Enterprise','BHPetrol Jalan Panglima Awang','T11','nmenme2011@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(72,'Nazreylla Enterprise','BHPetrol R & R Pagoh Selatan','T11','nazreylla@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(73,'Irama Positif Sdn Bhd','BHPetrol Yong Peng 2','T11','bhp.yongpeng@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(74,'AL Abrar Tun Teja Petrol Station','BHPetrol Jalan Tun Teja','T12','bhptuta@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(75,'Perwira Niaga Malaysia(PERNAMA) ','BHPetrol R&R Pagoh Utara','T11','bhppagohu@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(76,'Perwira Niaga Malaysia (PERNAMA)','BHPetrol Taman Perling','T12','halim@pernama.com','2018-03-01 00:00:00','2018-04-02 09:06:31'),(77,'LCC Petroleum','BHPetrol Lebuhraya AMJ','T11','lccbhp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(78,'Tegar Warisan Sdn Bhd','BHPetrol Telok Mas','T11','hgtio@sinoilgroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(79,'Ismail Station Services','BHPetrol Parit Yaani','T11','ismailstation_services@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(80,'Ismail Alliance Enterprise','BHPetrol Parit Raja','T11','ismail_alliance@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(81,'Desa Jaya Saidalvi Petrol & Services','BHPetrol Jalan KTJB','T12','bhpmasai56@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(82,'Ria Efektif Trading Sdn Bhd','BHPetrol Jalan Skudai','T12','bhpskudai@live.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(83,'Melati Gemilang Trading','BHPetrol Pengerang','T12','melatigemilang@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(84,'Bukit Pasir Petroleum Sdn Bhd','BHPetrol Bukit Pasir','T11','hgtio@sinoilgroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(85,'Johdev Land Sdn Bhd','BHPetrol Ulu Choh','T12','j.raj@ag-dev.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(86,'Trinity Focus Sdn Bhd','BHPetrol Taman Mutiara','T12','bhp.pontian@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(87,'Power Save Enterprise','BHPetrol Jalan Mawai','T12','powersave.enterprise@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(88,'Alyakin Trading Company','BHPetrol Sg Pinggan','T12','bhpetrolsgp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(89,'Kwang Mui Service Station Sdn Bhd','BHPetrol Muar By Pass','T11','bhpbypass@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(90,'Al Huda Petaling Petrol Station','BHPetrol Jalan Petaling','T12','bhppetaling@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(91,'Lian Hup Co','BHPetrol Jalan Larkin','T12','lianhup.company@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(92,'Luxury Precision Engineering Sdn Bhd','BHPetrol Simpang Renggam','T12','bhpspgrenggam@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(93,'Kompas Perkasa (Bkt Gambir) Sdn Bhd ','BHPetrol Bukit Gambir','T11','bhp_bktgambir@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(94,'Al Amin Teratai Petrol Station','BHPetrol Taman Teratai','T12','bhpteratai@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(95,'Hock Choon Realty Sdn. Bhd.','BHPetrol Kulai Tropika','T12','bhpkulai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(96,'Double Growth Synergy Sdn Bhd','BHPetrol Kluang 2','T12','doublegrowthsynergy@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(97,'Tropical Fresh Food Industries Sdn Bhd','BHPetrol Jalan Mawai 2','T12','elvin@ag-dev.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(98,'Farisya Sofea Enterprise','BHPetrol Jalan Tampoi','T12','bhpjalantampoi@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(99,'Sungai Machap Service Station Enterprise','BHPetrol Jalan Machap','T11','bhppetrolmachap.1122@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(100,'Ismail Holdings Sdn Bhd','BHPetrol R & R Seremban Utara','T11','ihsb.bhp.seremban@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(101,'Desa Skudai Petrol','BHPetrol Desa Skudai','T12','bhpdesaskudai@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(102,'Chop Chin Lee','BHPetrol Kuala Klawang','T10','bhpkualaklawang@gmail.com','2018-03-01 00:00:00','2018-08-02 03:26:24'),(103,'Ayer Hitam Petroleum Sdn Bhd','BHPetrol Ayer Hitam','T11','bplowpetroleum@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(104,'Johan Paris Ventures Sdn Bhd','BHPetrol Simpang Renggam 2','T12','bhpsprenggam2@gmail.com','2018-03-01 00:00:00','2018-08-02 02:17:42'),(105,'Koperasi Felda Pemanis Satu Berhad','BHPetrol Felda Pemanis 1','T11','koperasi_p1@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(106,'Koperasi Felda Lui Muda Negeri Sembilan Berhad','BHPetrol Felda Lui Muda','T10','kop_flmnsb@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(107,'A\'Dil Services','BHPetrol Per.Tg  Ampuan Rahimah 1','T06','Zulkarnain.tajuddin@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(108,'Alshine Auto & Service Centre','BHPetrol Taman Cheras','T10','whishamwh@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(109,'Bangi Ribuan Sdn Bhd','BHPetrol Hujong Permatang','T09','harliah78@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(110,'Central Service Station','BHPetrol Per. Sultan Ibrahim','T06','syng57ing@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(111,'Chin Fatt Service Station','BHPetrol Jalan Tuanku Antah','T10','bhpyaw@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(112,'Damai Angkasa Sdn Bhd','BHPetrol Batu Caves','T08','k.n.thevar@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(113,'Dayasia Corporation Sdn Bhd','BHPetrol S.E.A. Park','T07','pangmeilin@yahoo.co.uk','2018-03-01 00:00:00','2018-08-29 10:24:28'),(114,'East Coast Service Station','BHPetrol Jalan Beserah','T04','buttderek1@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(115,'F.A.Serve Sdn Bhd','BHPetrol Jalan Segambut','T07','jianguan.kgt@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(116,'Felda Trading Sdn Bhd','BHPetrol Pasir Besar','T10','bp.pasirbesar@felda.net.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(117,'Felda Trading Sdn Bhd','BHPetrol Lepar Hilir','T04','bhp_leparhilir@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(118,'Huap Seng Heng Sdn Bhd','BHPetrol Taman Muda','T07','huapsengheng@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(119,'Ibel Enterprise','BHPetrol Simpang Songsang','T08','ibel_enterprise@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(120,'Kayu Ara Petrol Service','BHPetrol Kg Sg Kayu Ara','T06','bhpkayuara@hotmail.com','2018-03-01 00:00:00','2018-06-18 07:59:25'),(121,'KR Citra Enterprise','BHPetrol Jalan Pelabuhan Utara','T09','Krcitrabhp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(122,'Lim Lee Seng Development Sdn Bhd','BHPetrol Klau','T08','amy565484@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(123,'Natural Max Sdn Bhd','BHPetrol Karak ','T08','naturalmax933@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(124,'Nazrima Enterprise','BHPetrol Jalan Gambang','T04','faizaljs_95@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(125,'Perkhidmatan & Station Minyak','BHPetrol Jalan Dato Muda Linggi','T11','sri_sivasamboo@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(126,'Perniagaan Fanaz','BHPetrol Jalan Cheras 1 & 2','T06','Zulkafli.Khairuddin@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(127,'Perniagaan Ma\'mor Jaya','BHPetrol SS2 ','T08','bhpss2@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(128,'Perniagaan Murni','BHPetrol Jalan Maharajalela','T07','Perniagaan_murni@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(129,'Perniagaan Puncak Seri','BHPetrol Jalan Kepong','T05','chelahusop@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(130,'Perniagaan Wanmaz','BHPetrol Taman City','T08','wanmaz2015@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(131,'Pertubuhan Peladang Kawasan Jempol ','BHPetrol Jempol','T10','bhpjempol@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(132,'Petroseng Ijok Sdn Bhd','BHPetrol Ijok','T05','safipermai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(133,'Raise Enterprise Sdn Bhd','BHPetrol KL-Karak Highway','T08','bhpraise212@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(134,'Rakanpuri Sdn Bhd','BHPetrol Per. Raja Muda Musa 2','T09','rakanpuribp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(135,'Soon Heng Kajang Sdn Bhd','BHPetrol Jalan Sg Chua','T07','annielkh@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(136,'Stesen Minyak Keramat','BHPetrol Teluk Chempedak','T04','faizaljs_95@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(137,'Stesyen Minyak Bandar Baru Klang','BHPetrol Bandar Baru Klang','T06','rob1nyap@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(138,'Koperasi Serbaguna Daerah Jerantut Bhd','BHPetrol Jerantut','T04','koperasiserbaguna@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(139,'Syarikat Soon Lai','BHPetrol Jalan Pantai','T10','syarikatsoonlai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(140,'Syarikat Thye Hin Service Station','BHPetrol Bahau','T10','sytthyehin71@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(141,'Syt Associated Service Station','BHPetrol Per. Raja Muda Musa','T09','rob1nyap@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(142,'Teong Mah Service Station','BHPetrol Jalan Gasing','T07','mykhoo-my@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(143,'Zaci Oil Marketing','BHPetrol Rasa Ria Saga','T07','zacizaci88@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(144,'N. S. Seng (Seremban) Sdn Bhd','BHPetrol Juasseh','T10','bhpjuasseh@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(145,'Wawasan Alam Hijau Enterprise','BHPetrol Jalan Cheras 3','T06','wawasanwawasan88@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(146,'Kim Sim\'s Autocare Centre Sdn Bhd','BHPetrol Triang','T04','moohonhoongbhp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(147,'Perwira Niaga Malaysia(PERNAMA) ','BHPetrol Mutiara Damansara','T06','halim@pernama.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(148,'Common Harmony Sdn Bhd','BHPetrol Kerdau','T08','bhpkerdau@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(149,'Karak Petroleum Sdn Bhd','BHPetrol Karak 2','T08','terry_tee84@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(150,'Konsep Berseri Sdn Bhd','BHPetrol Mahsan 2','T10','bhpmahsan2@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(151,'Vistavision Enterprise Sdn Bhd','Bhpetrol Kuantan By-Pass','T04','bhpkuantanbypass@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(152,'Lim Lee Seng Properties Sdn Bhd','BHPetrol Mentakab','T04','carmen_chew1212@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(153,'Sri Maju Jati Enterprise','BHPetrol Shah Alam Expressway','T06','srimaju_jati@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(154,'Nur Fattah Arrazak Enterprise','BHPetrol Desa Jaya','T05','izzati.farid98@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(155,'Unisky Enterprise Sdn Bhd','BHPetrol Mahsan','T10','stevenjf911@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(156,'Raub Petroleum Sdn Bhd','BHPetrol Raub 2','T08','mcpetroleum@mcgroup.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(157,'PD Sepang Petroleum Sdn Bhd','BHPetrol Sepang-Lukut','T10','prascillachin@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(158,'Petrol Station MB Sdn Bhd','BHPetrol Jalan PD-Seremban','T10','petrolstationmb@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(159,'Baan Lan Sdn Bhd','BHPetrol Parit Raja 2','T11','baanlan2858@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(160,'Jernih Cendana Enterprise','BHPetrol Karak KL','T08','jernihcendana.enterprise@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(161,'Jaguh Barat Sdn Bhd ','BHPetrol Bachang','T11','jaguhbarat@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(162,'Isba Seri Wah Yu Petrol Pump Station','BHPetrol Taman LTAT','T07','mohdhanif.bhp2017@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(163,'Perniagaan Zul Fikri Bin Arbaee','BHPetrol Jalan Kapar 2','T09','zulfikriarbaee@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(164,'Lambang Sakti Sdn Bhd','BHPetrol Serendah 2','T05','lambangbhp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(165,'Kemayan Service Station Sdn Bhd','BHPetrol Kemayan','T04','bhpkmy@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(166,'Konsep Berseri Sdn Bhd','BHPetrol Bukit Besi','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(167,'Man Kiong Trading Sdn Bhd','BHPetrol Jalan Sg Lembing','T04','psiewlian@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(168,'Tan & Tan Petroleum','BHPetrol Sg Plong','T07','tanpetroleum2015@gmail.com','2018-03-01 00:00:00','2018-07-27 10:00:10'),(169,'Kerayong Service Station Sdn Bhd','BHPetrol Kerayong','T04','choonkry@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(170,'Koperasi Serbaguna Felda Selancar 2 Berhad','BHPetrol Felda Selancar 2','T04','kopselancar2@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(171,'Seng Lee Huat Petroleum Sdn Bhd','BHPetrol Sg. Buloh 2','T05','slhuatpetroleum@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(172,'Lee Yew And Sons Resources','BHPetrol Bandar Seri Jempol','T10','cym92372@outlook.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(173,'All Write Services','BHPetrol Jalan Templer','T07','allwriteservices@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(174,'Awal Bestari Sdn Bhd','BHPetrol Jalan Subang Utama','T07','bhpsubangutama@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(175,'Ban Lee Petrol Service Station','BHPetrol Jalan Lahat','T02','gst.banleepetrol@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(176,'Berjaya PetroServis','BHPetrol Puchong Jaya','T07','sayeeda_osman@yahoo.com','2018-03-01 00:00:00','2018-07-04 08:33:14'),(177,'Bestari Syahdu Sdn Bhd','BHPetrol Serdang Raya','T10','srimaju_jati@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(178,'Besway PetroServis','BHPetrol Sg Besi Highway','T07','Surkeryar@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(179,'Bidor Service Station','BHPetrol Bidor','T05','bidorss@gmail.com','2018-03-01 00:00:00','2018-08-13 02:14:19'),(180,'Perniagaan Kewajipan Jaya','BHPetrol Jalan Kewajipan','T07','sayeeda_osman@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(181,'Cathay Service Station','BHPetrol Batu Gajah','T02','bhp.batugajah@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(182,'Chin Kein Kee Service Station','BHPetrol Jalan Gopeng','T02','chinkeinkee@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(183,'Chuan Heng Leong','BHPetrol Jalan 222','T07','bhpjln222@gmail.com','2018-03-01 00:00:00','2018-04-11 09:17:59'),(184,'D\'Rosh ServCentre','BHPetrol Lebuhraya KL-Klang','T06','mm_1012001@yahoo.com.sg','2018-03-01 00:00:00','2018-02-28 16:00:00'),(185,'D\'Rosh ServPort','BHPetrol Subang Airport','T06','Slhnilai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(186,'Gombakway Service Station','BHPetrol Jalan Gombak','T07','gombakway@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(187,'Halajati Enterprise','BHPetrol Jalan Ma\'arof','T07','jalanmaarof@hotmail.com','2018-03-01 00:00:00','2018-08-21 03:34:28'),(188,'Handayani Sdn Bhd','BHPetrol Jalan Kuari','T10','mgrjku91@yahoo.com.my','2018-03-01 00:00:00','2018-08-21 03:33:59'),(189,'Iman Bestari Enterprise','BHPetrol Tapah Highway','T05','bhpimanbestari@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(190,'Jag Traders','BHPetrol Jalan Genting Klang 1','T05','bhpgk1@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(191,'Jurus Persada Sdn Bhd','BHPetrol Jalan Kuching','T05','Suhaimisenafi@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(192,'K.A. Surijaya Enterprise','BHPetrol Kg Baharu (Puchong 3)','T07','kasurijaya888@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(193,'Kong Eng Service Station','BHPetrol Jalan Kuala Kangsar','T02','bpleepm@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(194,'Kuchai Petrol Service','BHPetrol Jalan Kuchai Lama','T06','bhpkuchai@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(195,'Mampu Makmur Sdn Bhd','BHPetrol Sekinchan 2','T09','sekinchan.ent@gmail.com','2018-03-01 00:00:00','2018-07-27 03:46:48'),(196,'Naa Zeef Enterprise','BHPetrol Taman Connaught','T10','bhpnaazeef@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(197,'New Century Service Station','BHPetrol Jalan Klang Lama 2','T08','yap_1512@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(198,'Ng E & Sons Petrol Station Sdn Bhd ','BHPetrol Jalan Batu Tiga Lama','T06','bhp.ngson@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(199,'Omtek Maju Sdn Bhd','BHPetrol Sentul Pasar','T08','jeffreylaw16@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(200,'Ong Beng Cheng  & Sons Sdn Bhd','BHPetrol Taman Kapar','T09','obcs.sb@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(201,'Pantai Service Station','BHPetrol Jalan Pantai Baru','T07','alvinchia5006@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(202,'Perniagaan Azyan Jaya','BHPetrol Damansara Utama','T08','bhpdamansarautama@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(203,'Perniagaan Hajariah Abdul Malek','BHPetrol Taman Bukit Kuchai','T07','mohdkhairuddin512@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(204,'Perniagaan Haji Razali Adanan','BHPetrol Jalan Meru','T06','razaliadanan_57@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(205,'Perniagaan Satu-Satu','BHPetrol Jalan Klang Lama 4','T08','bhpsatu2015@gmail.com','2018-03-01 00:00:00','2018-03-07 03:02:53'),(206,'Perwira Niaga Malaysia(PERNAMA) ','BHPetrol Taman Alam Megah','T06','halim@pernama.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(207,'Rantau Fokus Sdn Bhd','Bhpetrol Bota Kanan','T02','nurulazura0583@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(208,'Safariza Enterprise','BHPetrol Kuala Kangsar','T01','msfirdaus2@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(209,'Perniagaan Hajjah Ruslinah Hamid','BHPetrol Pelabuhan Klang','T09','ruslinah_hamid@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(210,'Selama Pelangi (M) Sdn Bhd','BHPetrol Per.Tengku Ampuan 1','T09','selamapelangi1@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(211,'Sentosa Emas Sdn Bhd','BHPetrol Kuala Selangor','T09','freewaymove@gmail.com','2018-03-01 00:00:00','2018-07-27 10:13:14'),(212,'Seri Wah Yu Petrol Pam Station','BHPetrol Taman Sri Endah','T07','Azie.prop82@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(213,'Siang Hin Petroservis Sdn Bhd','BHPetrol Jalan Pahang','T08','jaymi.sianghin@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(214,'Siong Huat Service Station','BHPetrol Jalan Klang Lama 1','T08','evonne_hooi@yahoo.co.uk','2018-03-01 00:00:00','2018-02-28 16:00:00'),(215,'Sri Norwee Enterprise','BHPetrol Taman Seri Gombak','T05','srinorwee@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(216,'SJ Service Station','BHPetrol Subang Jaya','T07','chaikokkwan@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(217,'Stesen Minyak Juara Sdn Bhd','BHPetrol O.U.G.','T08','harbindr.kaur@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(218,'Stesyen Minyak Sahabat','BHPetrol Bandar Sunway','T07','srimaju_jati@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(219,'Sungai Lalang Jaya Sdn Bhd','BHPetrol Jalan Semenyih 1','T10','sljsblot2391@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(220,'Syarikat Hup Seng ','BHPetrol Jalan Klang Lama 3','T08','uni1288@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(221,'Syarikat Isra','BHPetrol Taman Sri Muda','T06','syktisra@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(222,'Syarikat Rasri','BHPetrol Bandar Tun Razak','T07','andykimhock@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(223,'Syt  Expo Auto Service Sdn Bhd','BHPetrol Damansara Jaya','T08','nathan8328@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(224,'Syt Lee Shing Auto Centre','BHPetrol Bukit Naga','T06','syktleeshingautocentre@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(225,'Tai Fong Service Station','BHPetrol Jalan Kampar','T02','tandesmond38@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(226,'Visi Wirajaya Sdn Bhd','BHPetrol Taman Ibu Kota','T05','Visiwirajaya@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(227,'Foo Brothers Service Station','BHPetrol Cecil Rae Drive','T02','bhpcecilrae@gmail.com','2018-03-01 00:00:00','2018-08-21 06:32:14'),(228,'Boustead Petroleum Marketing S/B','BHPetrol Taman Tun Dr Ismail','T09','bhpttdi@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(229,'Ciptaan Taipan Sdn Bhd','BHPetrol Jalan Meru 2','T06','bhpmeru2@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(230,'MZJ Service Station','BHPetrol Taman Melawati','T05','bhptmnmelawati@yahoo.com','2018-03-01 00:00:00','2018-04-12 09:11:56'),(231,'Klang Bahagia Trading','BHPetrol Jalan Kebun','T06','bhpjlnkebun@yahoo.com','2018-03-01 00:00:00','2018-04-02 09:06:55'),(232,'RBS Development Sdn Bhd','BHPetrol Ipoh-Lumut Highway','T02','wonpl@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(233,'Ang Loke Teck Sdn Bhd','BHPetrol Jenjarom 2','T06','cheehong1122@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(234,'Azim Pasifik Enterprise','BHPetrol Pulau Indah','T09','bhppulauindah13@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(235,'The Combined Bus Services Sdn Bhd','BHPetrol Terminal Bas Ipoh Raya','T02','bhpcombinebusservice@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(236,'Dot Red Realty Sdn Bhd','BHPetrol Chemor Klebang','T02','kumleong6426@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(237,'Thow Ju Hin Sdn BHd','BHPetrol Bidor Teluk Intan','T05','thowjuhin@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(238,'BSE Station Sdn Bhd','BHPetrol Sg Manggis','T06','bsestation@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(239,'Cap Hup Woh','BHPetrol Air Kuning','T02','liewsiewleng77@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(240,'Angkasa Cermat Enterprise','BHPetrol MRR2','T05','wong.yuetwai@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(241,'KK Larwin Petroleum Sdn Bhd','BHPetrol Kg Buaya','T01','vincentywt1128@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(242,'Alpine Farm Sdn Bhd','BHPetrol Blue Valley','T05','myungwhai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(243,'Petrol Botani Sdn Bhd','BHPetrol Bandar Seri Botani','T05','petrolbotani@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(244,'Sutera Raya Sdn Bhd. ','BHPetrol Bandar Gopeng','T02','sutera.raya.bhp@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(245,'Perniagaan Norzalina Razali','BHPetrol Persiaran Selangor','T06','mm_1012001@yahoo.com.sg','2018-03-01 00:00:00','2018-02-28 16:00:00'),(246,'Actual Future Sdn. Bhd.','BHPetrol Taman Acheh Mutiara','T02','afbhpetrol@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(247,'Iman Razhan Enterprise','BHPetrol Jalan Sg Besi 2','T06','jzijaya@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(248,'Petroplus Services','BHPetrol Jalan Kapar 1','T09','bhpkapar@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(249,'Sungai Tua Enterprise ','BHPetrol Sungai Tua','T05','Bhpetrolsgtuaenterprise@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(250,'Nurrazzak Enterprise','BHPetrol Sg Besi Harmony','T07','aljannahttdi@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(251,'Jasamas Enterprise','BHPetrol Jalan Matang','T02','bhpmatang@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(252,'Makmur Ria Ventures Sdn Bhd','BHPetrol Tanjong Malim','T05','makmurria@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(253,'Majukaya Entiti Sdn Bhd','BHPetrol Bandar Baru Kampar','T02','majukaen@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(254,'Melati Astana Sdn Bhd','BHPetrol Bandar Seri Iskandar','T02','melatiastana.ops@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(255,'NKJ Petroleum Sdn Bhd','BHPetrol Kg China','T02','nkjpetroleum@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(256,'Kar Sin Focus Sdn Bhd','BHPetrol Taman Samudera','T02','bhpkarsinfocus@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(257,'OBR Ventures Enterprise','BHPetrol OBR Sg Buloh South','T05','obr_bhp@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(258,'World Trade Business Sdn Bhd','BHPetrol Rimba Panjang','T02','worldtradebusiness19112@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(259,'Nice Achievement Sdn Bhd','BHPetrol Pantai Remis Batu 13','T02','Niceachievement@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(260,'Auscomm Sdn Bhd','BHPetrol Serendah','T05','lowkok65@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(261,'Poh Siong Petrol Station','BHPetrol Lukut','T10','pohsiongpetrolstation@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(262,'Khidmat Sakti Sdn Bhd','BHPetrol KS-Rawang','T05','jianjong86@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(263,'Nilai Petroleum Sdn Bhd','BHPetrol Nilai','T10','bhpnilai@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(264,'Asagus Sdn Bhd','BHPetrol Pekan','T04','khlam20002000@yahoo.com.hk','2018-03-01 00:00:00','2018-02-28 16:00:00'),(265,'Barakah Enterprise','BHPetrol Sitiawan','T02','ppabdulmajeed1938@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(266,'Bukit Tinggi Land Sdn Bhd','BHPetrol Bukit Tinggi','T08','vazanbol@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(267,'Dasar Kembara (M) Sdn Bhd','BHPetrol Pasir Mas','T03','hybrid_monster666@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(268,'Desabina Sdn Bhd','BHPetrol Jelapang','T02','bhpjelapang55@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(269,'Felda Trading Sdn Bhd','BHPetrol Bandar 32','T04','Bhp.bandar32@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(270,'Felda Trading Sdn Bhd','BHPetrol Bukit Kuantan','T04','bhpetrol.bktkuantan@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(271,'Felda Trading Sdn Bhd','BHPetrol Jengka 3','T04','bp.jengka03@felda.net.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(272,'Felda Trading Sdn Bhd','BHPetrol Jengka 8','T04','bhp.jengka08@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(273,'Felda Trading Sdn Bhd','BHPetrol PPPTR','T04','bhp.jengka08@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(274,'Fook Thye Service Station','BHPetrol Jalan Siputeh','T02','bhpJalansiputeh@outlook.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(275,'Guan Long Trading Sdn Bhd','BHPetrol Sabak Bernam','T09','Chiasky@hotmail.com','2018-03-01 00:00:00','2018-03-07 03:30:15'),(276,'Indahmatics Sdn Bhd','BHPetrol Per.Tengku Ampuan 2','T09','ctyeoh@gforce.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(277,'Karya Merdu Sdn Bhd','BHPetrol Tambun','T02','bhptambun@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(278,'Koperasi Felda Bukit Bading ','BHPetrol Bukit Bading','T04','fadhlanruzain24@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(279,'Koperasi Felda Bukit Damar Berhad','BHPetrol Bukit Damar','T08','bhpbukitdamarbhd@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(280,'Koperasi Nelayan Pantai Remis Bhd','BHPetrol Pantai Remis-Dinding','T02','Koperasinelayanp.remisbhd_lim@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(281,'Koperasi Felda Bukit Mendi Pahang Berhad','BHPetrol Bukit Mendi','T04','koopfbm@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(282,'Kwang Mui Service Station','BHPetrol Jalan Kesang Muar','T11','kwangmuiss@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(283,'Lean Heng Co Service Station','BHPetrol Jalan Sg Rambai','T01','505leanhengco@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(284,'Lian Thye Service Station','BHPetrol Tampin','T11','shuern@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(285,'Lim Lee Seng Sdn Bhd','BHPetrol Bandar Gambang','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(286,'N S Seng (Trengganu) Sdn Bhd','BHPetrol Batu Enam','T04','nssbt6@hotmail.com','2018-03-01 00:00:00','2018-03-04 19:55:09'),(287,'N.S. Seng (Pahang) Sdn Bhd','BHPetrol Kuantan/Segamat Highway2','T04','benchew@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(288,'Perniagaan Edasamah','BHPetrol Sg Siput','T01','msfirdaus2@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(289,'Perniagaan Sepakat Abadi','BHPetrol Ayer Hitam (1&2)','T03','perniagaansepakatabadi@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(290,'Petralin Corporation (M) Sdn Bhd','BHPetrol Sg Ruan','T08','slleongsenggroup@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(291,'Public Service Station','BHPetrol Jalan Changkat Jong','T02','bhpcktjg@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(292,'Siew Service Station ','BHPetrol Ayer Tawar','T02','bhpayertawar@gmail.com ','2018-03-01 00:00:00','2018-02-28 16:00:00'),(293,'Sin Hong Huat Service Station','BHPetrol Jalan Kamunting','T01','issim9838@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(294,'Sin Yew Hup S/S Sdn Bhd','BHPetrol Jalan Khalidi','T11','bhpkhalidi@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(295,'Soon Seng Trading Company','BHPetrol Sg Besar','T09','quah_qianxin@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(296,'Stesyen Kampong Bahru','BHPetrol Sg Petani','T01','bhplim1213@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(297,'Stesyen Minyak Kajang','BHPetrol Jalan Semenyih 2','T10','bhp_semenyih2@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(298,'Syarikat Sentosa','BHPetrol Kg Sentosa','T04','gemungal85@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(299,'Koperasi Felda Kampung Sertik Berhad','BHPetrol Kg Sertik','T08','jamaludinali60@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(300,'Tan & Son Service Station','BHPetrol Raub','T08','hong_station@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(301,'YiYiba Enterprise Sdn Bhd','BHPetrol Parit Jawa','T11','yiyibaenterprise@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(302,'Yow Brothers Service Station','BHPetrol Temerloh','T08','bhpybss@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(303,'Retsters (M) Sdn Bhd','BHPetrol Kepala Batas','T01','bhpkepalabatas@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(304,'Afza Trading','BHPetrol Machang','T03','ayubomar7@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(305,'Mayfair Service Station','BHPetrol Kluang','T12','bhpkluang@gmail.vom','2018-03-01 00:00:00','2018-02-28 16:00:00'),(306,'Chemor Service Station Sdn Bhd','BHPetrol Chemor','T02','catho126@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(307,'Hijauwan Enterprise','BHPetrol Hutan Melintang','T02','malek_alek@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(308,'Koperasi  Serbaguna Felda ','BHPetrol Gunong Besout','T05','bhp.besout@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(309,'Koperasi Felda Trolak Selatan Bhd','BHPetrol Sungkai','T05','appy_aliah@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(310,'Koperasi Felda Trolak Selatan Bhd','BHPetrol Felda Trolak Selatan','T05','coopfts@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(311,'Mankon Phoenix Enterprise','BHPetrol Sg Durian','T02','mankon9933@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(312,'Tiang Chew Hong Enterprise','BHPetrol Kg Koh','T02','bhpkgkoh@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(313,'Masree Filling Station','BHPetrol Pelekbang','T03','hybrid_monster666@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(314,'Koperasi Peneroka Sungai Tengi Bhd','BHPetrol Sg Tengi','T09','kopeneroka_sungaitengi@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(315,'Naluri Aktif Sdn Bhd','BHPetrol Felda Soeharto','T09','naluriaktif.soeharto.5972@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(316,'Raizah Petrol Station','BHPetrol Sg Panjang','T09','izharazalli@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(317,'Sin Seng Huat Trading Company','BHPetrol Sg Haji Dorani','T09','bhpetrol_david@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(318,'Topaz Temasek Sdn Bhd','BHPetrol Taman Kosas','T07','topaztemasek@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(319,'Warga Pakatan Sdn Bhd','BHPetrol Changkat Jering','T01','matangleanhin2@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(320,'Mambang Diawan Petrol Station S/B','BHPetrol Mambang Diawan','T02','leongchee88@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(321,'Sekinchan Petrol Station','BHPetrol Sekinchan 1','T09','ysiang602@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(322,'Petroseng Trading Sdn Bhd','BHPetrol Merlimau','T11','adnan_bhpmerlimau@yahoo.com.my','2018-03-01 00:00:00','2018-02-28 16:00:00'),(323,'Abdul Karim Bin saad','BHPetrol Jalan Kodiang','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(324,'H.O.S. Enterprise','BHPetrol Kg Rantau Panjang','T01','zazzurin@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(325,'Halim Bin Isa','BHPetrol Kg Belantik','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(326,'Has & Has Enterprise','BHPetrol Kg Lemban Palas','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(327,'Haza Teguh Enterprise','BHPetrol Tunjang-Kubang Pasu','T03','leegan@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(328,'IBY Utara Enterprise','BHPetrol Padang Sera','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(329,'Koperasi Bukit Selambau Bhd','BHPetrol Bukit Selambau','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(330,'L.S. Eng Trading','BHPetrol Padang Temusu','T01','azizi@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(331,'Muara Klasik Enterprise','BHPetrol Kg Kubor Panjang','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(332,'Kayrizz Management','BHPetrol Kubang Rotan','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(333,'NZ Wannina Enterprise','BHPetrol Kg Musa','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(334,'Meu A/P Siew','BHPetrol Kg Titi Akar','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(335,'Roslan Bin Ajib','BHPetrol Guar Nangka','T03','hengchaik@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(336,'Sungai Setar Enterprise','BHPetrol Sg Setar Besar','T01','azizi@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(337,'Minda Hijrah Enterprise','BHPetrol Kg Sungai Ular','T01','azizi@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(338,'S.H. Enterprise Sdn Bhd','BHPetrol Tapah 2','T05','ckchan3388@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(339,'Sin Chin Huat','BHPetrol Kuala Kurau','T02','bhpetrol.kualakurau@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(340,'Tiong\'s Auto Service Station','BHPetrol Bruas','T02','tanyewwee@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(341,'Min aun Trading Co','BHPetrol Segari','T01','minaun@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(342,'Chop Chong Lee','BHPetrol Sg Jerik','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(343,'East Coast Petroleum','BHPetrol Besut','T03','invoice369@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(344,'Impian Deras Sdn Bhd','BHPetrol Kuala Berang','T04','invoice369@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(345,'Koperasi Felda Neram Satu ','BHPetrol Felda Neram 1','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(346,'Koperasi Peneroka-Peneroka Felda Jengka 10 (Mawar) Berhad ','BHPetrol Felda Mawar','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(347,'Koperasi Serbaguna Peladang Felda','BHPetrol Felda Sg Tekam Utara','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(348,'Kuei & Tan Sdn Bhd','BHPetrol Jerteh','T03','leegan@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(349,'Lim Lee Seng Properties Sdn Bhd','BHPetrol Melor','T03','invoice369@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(350,'Pa\'Muda Pemborong Petrol','BHPetrol Kg Jabi','T03','invoice369@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(351,'Perniagaan Semantan','BHPetrol Jalan Maran','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(352,'Stesyen Minyak BHP Kuala Krau','BHPetrol Kuala Krau','T04','tengsw@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(353,'Stesyen Minyak Lanchang Sdn Bhd','BHPetrol Lanchang','T08','chongsenggroup@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(354,'Syarikat Terengganu Jaya','BHPetrol Anak Ikan','T03','leegan@senggroup.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(355,'Yusoff Bin Idris','BHPetrol Kg Kedai Buloh','T03','invoice369@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(356,'Chiang Trading Co','BHPetrol Batu Arang','T05','siewlychang@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(357,'Lee Seng & Co Petroleum Sdn Bhd','BHPetrol Taman Sri Segambut','T07','leeseng1234@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(358,'Petromurni Sdn Bhd','BHPetrol Jalan Tras Raub','T08','tjk-enterprise@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(359,'Stesyen Minyak Liau Chong','BHPetrol Jenjarom','T06','smlcbhp@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(360,'Tian Xin Trading Sdn Bhd','BHPetrol Telemong','T08','vlganpetroseng@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(361,'Bang Lim Trading','BHPetrol Sg Burung','T09','sgbrotherspetrol@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(362,'Tan & Tan Petroleum','BHPetrol Tanjung Karang','T09','Wuq7883@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(363,'Cekap Sejagat Sdn Bhd','BHPetrol Linggi','T10','zilaghazar@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(364,'Chua Chin Hin (Rantau) Sdn Bhd','BHPetrol Rantau','T10','Charli_gan53@hotmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(365,'Naturelead Sdn Bhd','BHPetrol Mantin','T10','sallyyap89@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(366,'Syah Desa Enterprise','BHPetrol Jalan Seremban Kuala Pilah','T10','syahdesa@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(367,'Syarikat Gemilang','BHPetrol Bukit Changgang','T07','shahrilamer81@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(368,'Simpang Pertang Filling Station','BHPetrol Simpang Pertang','T10','bhp.simpangpertang@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(369,'Kompas Perkasa Sdn Bhd','BHPetrol Grisek','T11','bhpgrisek@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(370,'Yusof Bin Jaafar','BHPetrol Kg Padang Kerasak','T03','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(371,'FK Bagan Enterprise','BHPetrol Kg Bagan Baru Ijok','T01','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(372,'Abdul Aziz Bin Jamai','BHPetrol Kg Masjid Ijok','T01','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(373,'RS Serasi Enterprise','BHPetrol Jalan Putra 2','T01','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(374,'Zamizan Petrol Station','BHPetrol Sungai Bayor','T01','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(375,'Petrol Pam Mini Gudang','BHPetrol Bukit Neriang','T02','minigudang@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(376,'Canna Enterprise','BHPetrol Bandar Riang','T01','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(377,'Selama Jati Enterprise','BHPetrol Kg Md Shah','T01','wembonindustries@gmail.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(378,'Koperasi Peserta-Peserta Felcra Gugusan Bkt Tandak Kelantan Bhd','BHPetrol Bukit Tandak','T03','kprbtdk@yahoo.com','2018-03-01 00:00:00','2018-02-28 16:00:00'),(379,'AU Venture Sdn. Bhd','BHPetrol Taman UK Raya','T2','auventure@hotmail.com','0000-00-00 00:00:00','2018-07-31 09:38:40'),(380,'Mega Sira Resources Sdn Bhd','BHPetrol Sg Dua North','T1','mega_sira_resources@yahoo.com','0000-00-00 00:00:00','2018-07-31 09:27:57'),(381,'Jiwa Kurnia Sdn Bhd','BHPetrol Sik','T1','jiwa.kurnia.sb@gmail.com','0000-00-00 00:00:00','2018-07-31 09:35:37'),(382,'Highway Station PLT','BHPetrol Sg Dua South','T1','highwaybhp@gmail.com','0000-00-00 00:00:00','2018-07-31 09:36:18');

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` smallint(11) NOT NULL AUTO_INCREMENT,
  `category_id` smallint(11) NOT NULL,
  `file_id` int(11) DEFAULT NULL,
  `title` text,
  `description` longtext,
  `position` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `sub_categories_fk_1` (`category_id`),
  KEY `sub_categories_fk_2` (`file_id`),
  CONSTRAINT `sub_categories_fk_1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`),
  CONSTRAINT `sub_categories_fk_2` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` VALUES (1,1,NULL,'GPM - Planogram',NULL,1,'2018-01-22 00:00:00','2018-02-22 20:23:16'),(2,1,NULL,'GPM - In Stock',NULL,2,'2018-01-22 00:00:00','2018-02-22 20:23:22'),(3,1,NULL,'Cigarettes Dispenser Unit (CDU) Lighting',NULL,5,'2018-01-22 00:00:00','2018-02-22 20:23:40'),(4,1,NULL,'\'Out of stock card\'',NULL,6,'2018-01-22 00:00:00','2018-02-22 20:23:46'),(7,1,NULL,'Product Educational Unit',NULL,7,'2018-01-22 00:00:00','2018-03-04 15:01:25'),(8,1,NULL,'Auxilary Unit/Gray Slap',NULL,8,'2018-01-22 00:00:00','2018-02-22 20:23:55'),(9,1,NULL,'Price Label',NULL,9,'2018-01-22 00:00:00','2018-02-22 20:23:59'),(10,1,NULL,'Frontal Facing & Forwarding',NULL,10,'2018-01-22 00:00:00','2018-02-22 20:24:08'),(11,2,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 14:54:39'),(12,2,NULL,'In Stock','i) Chiller. ii) Arctic Standee. iii) Promo Bin',0,'2018-01-22 00:00:00','2018-01-22 15:29:39'),(13,2,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:21:06'),(14,2,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:21:06'),(15,2,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:21:38'),(16,2,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:21:38'),(17,3,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:22:26'),(18,3,NULL,'In Stock',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:22:26'),(19,3,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:23:03'),(20,3,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:23:03'),(21,3,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:24:02'),(22,3,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:23:34'),(23,3,NULL,'Unauthorised product',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:23:50'),(24,4,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:15'),(25,4,NULL,'In Stock',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:15'),(26,4,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:15'),(27,4,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:15'),(28,4,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:15'),(29,4,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:43'),(30,4,NULL,'Unauthorised product',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:26:43'),(31,5,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:28:52'),(32,5,NULL,'In Stock',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:28:52'),(33,5,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:28:52'),(34,5,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:28:52'),(35,5,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:28:52'),(36,5,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:29:25'),(37,5,NULL,'Unauthorised product',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:29:25'),(38,6,NULL,'Nestle',NULL,0,'2018-01-22 00:00:00','2018-02-22 19:49:33'),(40,7,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:00'),(41,7,NULL,'In Stock',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:00'),(42,7,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:00'),(43,7,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:00'),(44,7,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:00'),(45,7,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:40'),(46,7,NULL,'Unauthorised product',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:34:40'),(51,8,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:37:56'),(52,8,NULL,'In Stock',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:37:56'),(53,8,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:38:34'),(54,8,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:38:34'),(55,8,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:39:22'),(56,8,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:39:22'),(57,8,NULL,'Unauthorised product',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:39:34'),(58,9,NULL,'Planogram',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:42:17'),(59,9,NULL,'In Stock',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:42:17'),(60,9,NULL,'\'Out of stock card\'',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:42:17'),(61,9,NULL,'Price Label',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:42:17'),(62,9,NULL,'Frontal Facing & Forwarding',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:42:17'),(63,9,NULL,'Product Gaps',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:43:34'),(64,9,NULL,'Unauthorised product',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:43:34'),(65,10,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 16:39:47'),(66,11,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 16:42:07'),(67,12,NULL,'\'Never out of stock items\' (NOOS) are audited to ensure they are in stock.',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:54:55'),(68,12,NULL,'Maximum OOS cards allowed is 15 cards (exclude tobacco).',NULL,0,'2018-01-22 00:00:00','2018-01-22 15:54:58'),(69,13,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 16:46:09'),(70,14,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 16:54:40'),(71,15,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 16:56:08'),(72,16,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:16:10'),(73,17,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:25:01'),(74,18,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:28:58'),(75,19,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:30:13'),(76,20,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:35:19'),(77,21,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:39:18'),(78,22,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:43:30'),(79,23,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-02-22 17:46:57'),(80,24,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:02:45'),(81,25,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:04:07'),(82,26,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:04:07'),(84,28,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:06:49'),(85,29,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:06:49'),(86,30,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:06:49'),(87,31,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:06:49'),(88,32,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:06:49'),(89,33,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:07:17'),(90,34,NULL,NULL,NULL,0,'2018-01-22 00:00:00','2018-01-22 16:07:17'),(91,1,NULL,'CMD & JTI - Planogram',NULL,3,'2018-02-23 00:00:00','2018-03-04 15:00:11'),(92,1,NULL,'CMD & JTI - In Stock',NULL,4,'2018-02-23 00:00:00','2018-03-04 15:00:04');

--
-- Table structure for table `sub_category_tag`
--

CREATE TABLE `sub_category_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sub_category_id` smallint(11) NOT NULL,
  `tag_id` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `compliance_tag_fk_1` (`sub_category_id`),
  KEY `compliance_tag_fk_2` (`tag_id`),
  CONSTRAINT `compliance_tag_fk_1` FOREIGN KEY (`sub_category_id`) REFERENCES `sub_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `compliance_tag_fk_2` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=106 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sub_category_tag`
--

INSERT INTO `sub_category_tag` VALUES (9,1,1,'2018-02-05 00:00:00','2018-02-05 07:54:14'),(11,2,3,'2018-02-05 00:00:00','2018-02-22 20:31:23'),(12,92,3,'2018-02-05 00:00:00','2018-02-22 20:31:35'),(17,38,3,'2018-02-06 00:00:00','2018-02-05 08:15:09'),(19,40,1,'2018-02-13 00:00:00','2018-02-12 09:37:38'),(20,41,3,'2018-02-13 00:00:00','2018-02-12 09:37:38'),(21,42,3,'2018-02-13 00:00:00','2018-02-12 09:41:04'),(22,43,3,'2018-02-13 00:00:00','2018-02-12 09:41:04'),(23,44,1,'2018-02-13 00:00:00','2018-02-12 09:41:04'),(24,44,3,'2018-02-13 00:00:00','2018-02-12 09:41:04'),(25,45,2,'2018-02-13 00:00:00','2018-02-12 09:41:04'),(26,46,3,'2018-02-13 00:00:00','2018-02-12 09:41:37'),(27,51,1,'2018-02-13 00:00:00','2018-02-12 09:44:58'),(28,52,3,'2018-02-13 00:00:00','2018-02-12 09:44:58'),(29,53,3,'2018-02-13 00:00:00','2018-02-12 09:46:20'),(30,54,3,'2018-02-13 00:00:00','2018-02-12 09:46:20'),(31,55,1,'2018-02-13 00:00:00','2018-02-12 09:46:20'),(32,55,3,'2018-02-13 00:00:00','2018-02-12 09:46:20'),(33,56,2,'2018-02-13 00:00:00','2018-02-12 09:46:20'),(34,57,3,'2018-02-13 00:00:00','2018-02-12 09:46:36'),(35,58,1,'2018-02-13 00:00:00','2018-02-12 09:49:26'),(36,59,3,'2018-02-13 00:00:00','2018-02-12 09:49:26'),(37,60,3,'2018-02-13 00:00:00','2018-02-12 09:49:26'),(38,61,3,'2018-02-13 00:00:00','2018-02-12 09:49:26'),(39,62,1,'2018-02-13 00:00:00','2018-02-12 09:49:26'),(40,62,3,'2018-02-13 00:00:00','2018-02-12 09:50:48'),(41,63,1,'2018-02-13 00:00:00','2018-02-12 09:50:48'),(42,64,3,'2018-02-13 00:00:00','2018-02-12 09:50:48'),(43,65,1,'2018-02-13 00:00:00','2018-02-12 10:00:59'),(44,66,3,'2018-02-13 00:00:00','2018-02-12 10:02:26'),(45,67,3,'2018-02-13 10:58:28','2018-02-12 18:58:39'),(46,68,3,'2018-02-13 10:58:28','2018-02-12 18:58:39'),(47,69,2,'2018-02-13 00:00:00','2018-02-12 19:02:11'),(48,70,1,'2018-02-13 00:00:00','2018-02-12 19:02:11'),(49,70,3,'2018-02-13 00:00:00','2018-02-12 19:02:11'),(50,71,1,'2018-02-13 00:00:00','2018-02-12 19:02:11'),(51,71,3,'2018-02-13 00:00:00','2018-02-12 19:02:11'),(52,72,3,'2018-02-13 00:00:00','2018-02-12 19:05:26'),(53,73,3,'2018-02-13 00:00:00','2018-02-12 19:05:26'),(54,74,3,'2018-02-13 00:00:00','2018-02-12 19:05:26'),(55,75,1,'2018-02-13 00:00:00','2018-02-12 19:05:26'),(56,76,2,'2018-02-13 00:00:00','2018-02-12 19:06:36'),(57,77,2,'2018-02-13 00:00:00','2018-02-12 19:06:36'),(58,78,2,'2018-02-13 00:00:00','2018-02-12 19:09:14'),(59,79,2,'2018-02-13 00:00:00','2018-02-12 19:09:14'),(60,80,2,'2018-02-13 00:00:00','2018-02-12 19:09:14'),(62,82,3,'2018-02-13 00:00:00','2018-02-12 19:10:19'),(64,81,3,'2018-02-23 00:00:00','2018-02-22 18:00:11'),(65,11,1,'2018-02-23 00:00:00','2018-02-22 18:26:13'),(66,12,3,'2018-02-23 00:00:00','2018-02-22 18:39:18'),(67,13,3,'2018-02-23 00:00:00','2018-02-22 18:40:52'),(68,14,1,'2018-02-23 00:00:00','2018-02-22 18:42:31'),(69,14,3,'2018-02-23 00:00:00','2018-02-22 18:42:31'),(70,15,1,'2018-02-23 00:00:00','2018-02-22 18:44:27'),(71,15,3,'2018-02-23 00:00:00','2018-02-22 18:44:27'),(72,16,2,'2018-02-23 00:00:00','2018-02-22 18:45:17'),(73,17,1,'2018-02-23 00:00:00','2018-02-22 19:00:19'),(74,18,3,'2018-02-23 00:00:00','2018-02-22 19:13:51'),(75,19,3,'2018-02-23 00:00:00','2018-02-22 19:13:51'),(76,20,3,'2018-02-23 00:00:00','2018-02-22 19:13:51'),(77,21,1,'2018-02-23 00:00:00','2018-02-22 19:13:51'),(78,21,3,'2018-02-23 00:00:00','2018-02-22 19:13:51'),(79,22,2,'2018-02-23 00:00:00','2018-02-22 19:14:29'),(80,23,3,'2018-02-23 00:00:00','2018-02-22 19:14:29'),(81,24,1,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(82,25,3,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(83,26,3,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(84,27,3,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(85,28,1,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(86,28,3,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(87,29,2,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(88,30,3,'2018-02-23 00:00:00','2018-02-22 19:28:16'),(89,31,1,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(90,32,3,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(91,33,3,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(92,34,3,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(93,35,1,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(94,35,3,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(95,36,2,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(96,37,3,'2018-02-23 00:00:00','2018-02-22 19:33:32'),(97,3,2,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(98,4,3,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(99,7,1,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(100,7,3,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(101,8,3,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(102,9,3,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(103,10,1,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(104,10,3,'2018-02-23 00:00:00','2018-02-22 20:07:30'),(105,91,1,'2018-02-23 00:00:00','2018-02-22 20:32:01');

--
-- Table structure for table `tags`
--

CREATE TABLE `tags` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` VALUES (1,'Fast'),(2,'Clean'),(3,'Convenience');

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` smallint(6) NOT NULL AUTO_INCREMENT,
  `name` tinytext NOT NULL,
  `username` tinytext NOT NULL,
  `password` longtext NOT NULL,
  `type` tinyint(6) NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (1,'Administrator','admin','670c203353577d146e2909401697b9c1',0,'2018-09-27 14:38:17','2018-01-28 00:00:00','2018-09-27 06:38:17'),(2,'Heng','heng','740f25a332454d9bc5bce05fdca95a71',1,'2018-08-30 16:22:14','2018-01-28 00:00:00','2018-08-30 08:22:14'),(3,'Hui Chin','huichin','6d4524dc60c32d347d0487ac71c5473e',1,'2018-08-31 22:05:35','2018-01-28 00:00:00','2018-08-31 14:05:35'),(4,'Kareem','kareem','0c2e558ffeef89d0dded7cccf942d562',1,'2018-09-25 10:43:39','2018-02-26 00:00:00','2018-09-25 02:43:39'),(5,'Raj','raj','ea87814f173abf4a8666a7d05e78516e',1,'2018-09-04 14:18:11','2018-02-26 00:00:00','2018-09-04 06:18:11'),(6,'Noraina','noraina','8b02bc742270585f7a16cc8d625184c9',0,'2018-03-06 21:43:06','2018-03-02 00:00:00','2018-03-06 13:43:06'),(7,'Hani','hani','a9bd1ad5b94ced62db9f97eff8230305',0,'2018-09-27 18:39:04','2018-03-02 00:00:00','2018-09-27 10:39:04'),(8,'Azhan','azhan','d74999908b2b7b3da8ac3392a9fcb1cf',0,'2018-09-27 17:38:53','2018-03-02 00:00:00','2018-09-27 09:38:53'),(9,'Territory Manager','tm','8b67e127f0da74d4da6fcb371f73c7a2',2,'2018-09-24 15:54:35','2018-03-03 00:00:00','2018-09-24 07:54:35'),(10,'CR Team','crteam','bff9b379906a45b7cbe6793df05dd67b',2,'2018-08-14 14:13:45','2018-03-03 00:00:00','2018-08-14 06:13:45'),(11,'Baba','baba','058e2de387f3e91909b165a2d2be0050',2,'2018-08-06 13:01:15','2018-03-03 00:00:00','2018-08-06 05:01:15'),(12,'Aziz','aziz','8e472946021c6fed0e6698fba511d868',2,NULL,'2018-03-03 00:00:00','2018-03-03 05:13:10'),(13,'oliver','oliver','bce6182261df839e52206ae0fb040280',0,NULL,'0000-00-00 00:00:00','2018-08-06 05:02:44'),(14,'Shahmiran','mohdnor','bf3e1a0d068a87214a5d72d94532efe4',1,'2018-09-26 14:50:01','0000-00-00 00:00:00','2018-09-28 07:25:04');

--
-- Dumping routines for database 'cmccommy_audit'
--


