(5263,'Update job working detail for job id 01338',24,'a:7:{s:6:\"job_id\";s:4:\"1338\";s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"328\";}s:11:\"file_number\";s:7:\"ADC0120\";s:20:\"compliance_type_date\";s:1:\"2\";s:15:\"compliance_date\";s:10:\"30-07-2020\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-11 04:12:37'),(5264,'Create new jobs for job id 01342.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"432\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:2:{i:0;s:1:\"8\";i:1;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2016\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 04:12:45'),(5265,'Update initial setup for job id 01337',24,'a:9:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:4:\"1448\";s:6:\"job_id\";s:4:\"1337\";s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2019\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-11 04:39:32'),(5266,'Update job working detail for job id 01337',24,'a:5:{s:6:\"job_id\";s:4:\"1337\";s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"325\";}s:11:\"file_number\";s:7:\"ADM0267\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-11 04:40:31'),(5267,'Update initial setup for job id 01335',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:3:\"643\";s:6:\"job_id\";s:4:\"1335\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1336\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:7:\"SPECIAL\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-11 04:41:41'),(5268,'Update job working detail for job id 01335',24,'a:6:{s:6:\"job_id\";s:4:\"1335\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1336\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:3:{i:0;s:3:\"357\";i:1;s:3:\"322\";i:2;s:3:\"346\";}s:11:\"file_number\";s:7:\"ADW0050\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 04:46:47'),(5269,'Update team setup setting for job id 01335',24,'a:3:{s:6:\"job_id\";s:4:\"1335\";s:7:\"dept_id\";s:1:\"8\";s:6:\"leader\";a:1:{i:0;s:4:\"1243\";}}','fas fa-edit','2020-03-11 04:47:24'),(5270,'Update initial setup for job id 01341',81,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:3:\"432\";s:11:\"is_external\";s:1:\"0\";s:6:\"job_id\";s:4:\"1341\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1342\";}s:11:\"description\";s:17:\"YEAR END DEC 2016\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2016\";s:12:\"currDeadline\";s:10:\"31-03-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-11 04:58:43'),(5271,'Update initial setup for job id 01342',81,'a:10:{s:7:\"dept_id\";s:1:\"3\";s:6:\"client\";s:3:\"432\";s:11:\"is_external\";s:1:\"0\";s:6:\"job_id\";s:4:\"1342\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1341\";}s:11:\"description\";s:17:\"YEAR END DEC 2016\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2016\";s:12:\"currDeadline\";s:0:\"\";s:8:\"deadline\";s:0:\"\";}','fas fa-edit','2020-03-11 04:59:18'),(5272,'Update initial setup for job id 00335',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:4:\"1330\";s:6:\"job_id\";s:3:\"335\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"336\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:7:\"Dormant\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2016\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-11 04:59:18'),(5273,'Update job working detail for job id 00335',24,'a:6:{s:6:\"job_id\";s:3:\"335\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"336\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"378\";}s:11:\"file_number\";s:7:\"ADS0193\";s:19:\"tax_submission_date\";s:10:\"31-07-2017\";}','fas fa-edit','2020-03-11 04:59:58'),(5274,'Create new jobs for job id 01344.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"432\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:2:{i:0;s:1:\"8\";i:1;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2017\";s:11:\"description\";s:17:\"YEAR END DEC 2017\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:01:36'),(5275,'Create new jobs for job id 01345.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"105\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:07:37'),(5276,'Create new jobs for job id 01346.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"1\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:09:06'),(5277,'Create new jobs for job id 01347.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"8\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:10:16'),(5278,'Create new jobs for job id 01348.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"9\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:11:20'),(5279,'Create new jobs for job id 01349.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"560\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:12:05'),(5280,'Create new jobs for job id 01350.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"561\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:13:59'),(5281,'Create new jobs for job id 01351.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"966\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:14:46'),(5282,'Create new jobs for job id 01352.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"149\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:15:32'),(5283,'Create new jobs for job id 01353.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"327\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:16:19'),(5284,'Create new jobs for job id 01354.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"534\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:17:11'),(5285,'Create new jobs for job id 01355.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"467\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:18:18'),(5286,'Update job working detail for job id 00335',24,'a:6:{s:6:\"job_id\";s:3:\"335\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"336\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"321\";}s:11:\"file_number\";s:7:\"ADS0193\";s:19:\"tax_submission_date\";s:10:\"31-07-2017\";}','fas fa-edit','2020-03-11 05:19:10'),(5287,'Create new jobs for job id 01356.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:3:\"201\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:11:\"FORM E 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 05:20:09'),(5288,'Update initial setup for job id 00337',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:4:\"1330\";s:6:\"job_id\";s:3:\"337\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"338\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:7:\"Dormant\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2017\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-11 05:21:13'),(5289,'Update job working detail for job id 00337',24,'a:6:{s:6:\"job_id\";s:3:\"337\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"338\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"321\";}s:11:\"file_number\";s:7:\"ADS0193\";s:19:\"tax_submission_date\";s:10:\"31-07-2018\";}','fas fa-edit','2020-03-11 05:21:37'),(5290,'Update initial setup for job id 00339',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:4:\"1330\";s:6:\"job_id\";s:3:\"339\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"340\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:7:\"Dormant\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2018\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-11 05:22:35'),(5291,'Update job working detail for job id 00339',24,'a:6:{s:6:\"job_id\";s:3:\"339\";s:14:\"related_job_id\";a:1:{i:0;s:3:\"340\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"321\";}s:11:\"file_number\";s:7:\"ADS0193\";s:19:\"tax_submission_date\";s:10:\"31-07-2019\";}','fas fa-edit','2020-03-11 05:23:06'),(5292,'Update initial setup for job id 00071',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:4:\"1085\";s:6:\"job_id\";s:2:\"71\";s:14:\"related_job_id\";a:2:{i:0;s:2:\"70\";i:1;s:2:\"72\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:25:\"Account belum siap lagi. \";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"30-06-2019\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-11 05:31:39'),(5293,'Update initial setup for job id 00071',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:4:\"1085\";s:6:\"job_id\";s:2:\"71\";s:14:\"related_job_id\";a:2:{i:0;s:2:\"70\";i:1;s:2:\"72\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:43:\"Account belum siap lagi. \r\nSubmission loan.\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"30-06-2019\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-11 05:32:26'),(5294,'Update job working detail for job id 00071',24,'a:6:{s:6:\"job_id\";s:2:\"71\";s:14:\"related_job_id\";a:2:{i:0;s:2:\"70\";i:1;s:2:\"72\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"110\";}s:11:\"file_number\";s:7:\"ADA0324\";s:19:\"tax_submission_date\";s:10:\"30-01-2020\";}','fas fa-edit','2020-03-11 05:33:59'),(5295,'Change job id 01266 status as acknowledge',363,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-03-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1266\";}','fas fa-edit','2020-03-11 06:41:59'),(5296,'Change job id 01310 status as acknowledge',363,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1310\";}','fas fa-edit','2020-03-11 06:43:40'),(5297,'Create new jobs for job id 01358.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:4:\"1468\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:2:{i:0;s:1:\"8\";i:1;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 06:57:14'),(5298,'Create new jobs for job id 01360.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:2:\"27\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:2:{i:0;s:1:\"8\";i:1;s:1:\"3\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 07:27:00'),(5299,'Update initial setup for job id 01359',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:2:\"27\";s:6:\"job_id\";s:4:\"1359\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1360\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2019\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-11 07:29:15'),(5300,'Update job working detail for job id 01359',24,'a:8:{s:6:\"job_id\";s:4:\"1359\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1360\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:2:{i:0;s:3:\"211\";i:1;s:3:\"320\";}s:11:\"file_number\";s:7:\"ADD0076\";s:20:\"compliance_type_date\";s:1:\"2\";s:15:\"compliance_date\";s:10:\"30-07-2020\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-11 07:30:46'),(5301,'Update team setup setting for job id 01359',24,'a:3:{s:6:\"job_id\";s:4:\"1359\";s:7:\"dept_id\";s:1:\"8\";s:6:\"leader\";a:1:{i:0;s:4:\"1249\";}}','fas fa-edit','2020-03-11 07:31:12'),(5302,'Update initial setup for job id 01341',24,'a:10:{s:7:\"dept_id\";s:1:\"8\";s:6:\"client\";s:3:\"432\";s:6:\"job_id\";s:4:\"1341\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1342\";}s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:17:\"YEAR END DEC 2016\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2016\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-11 07:31:38'),(5303,'Update job working detail for job id 01341',24,'a:6:{s:6:\"job_id\";s:4:\"1341\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1342\";}s:7:\"dept_id\";s:1:\"8\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"306\";}s:11:\"file_number\";s:7:\"ADS0209\";s:19:\"tax_submission_date\";s:10:\"31-07-2017\";}','fas fa-edit','2020-03-11 07:32:14'),(5304,'Change job id 01195 status as acknowledge',277,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"02-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1195\";}','fas fa-edit','2020-03-11 07:34:08'),(5305,'Change job id 01195 status as submit',277,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1195\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:34:16'),(5306,'Change job id 01293 status as acknowledge',277,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"17-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1293\";}','fas fa-edit','2020-03-11 07:34:49'),(5307,'Create new jobs for job id 01361.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"12-03-2020\";s:11:\"description\";s:60:\"To standardize SALIHIN\'s letterhead design into a new design\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 07:34:53'),(5308,'Update initial setup for job id 01361',98,'a:8:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"2\";s:6:\"job_id\";s:4:\"1361\";s:11:\"description\";s:53:\"To standardize SALIHIN\'s letterhead into a new design\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-11 07:35:36'),(5309,'Update initial setup for job id 01361',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"2\";s:6:\"job_id\";s:4:\"1361\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:53:\"To standardize SALIHIN\'s letterhead into a new design\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-11 07:35:47'),(5310,'Update job working detail for job id 01361',98,'a:5:{s:6:\"job_id\";s:4:\"1361\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"277\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 07:35:56'),(5311,'Change job id 01225 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1225\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:37:07'),(5312,'Change job id 01225 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1225\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:37:17'),(5313,'Create a new daily update for job id : 01293',277,'a:3:{s:6:\"job_id\";s:4:\"1293\";s:7:\"dept_id\";s:1:\"9\";s:7:\"content\";s:180:\"<ol><li>Extracting wording first before make a layout</li><li>Pending some content and already request from Muntaka</li><li>In progress to create some related infographic</li></ol>\";}','fas fa-pen','2020-03-11 07:37:24'),(5314,'Change job id 01198 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1198\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:37:57'),(5315,'Change job id 01198 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1198\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:38:03'),(5316,'Change job id 01201 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1201\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:38:49'),(5317,'Change job id 01201 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1201\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:38:56'),(5318,'Create a new daily update for job id : 00398',277,'a:3:{s:6:\"job_id\";s:3:\"398\";s:7:\"dept_id\";s:1:\"9\";s:7:\"content\";s:38:\"<p>Dr. Mutalib reviewed the flyers</p>\";}','fas fa-pen','2020-03-11 07:39:09'),(5319,'Change job id 01166 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1166\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:39:15'),(5320,'Change job id 00398 status as submit',277,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"398\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:39:24'),(5321,'Change job id 01167 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1167\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:39:37'),(5322,'Change job id 00924 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:3:\"924\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:40:01'),(5323,'Change job id 01030 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1030\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:41:35'),(5324,'Change job id 01286 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1286\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:42:19'),(5325,'Change job id 01197 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1197\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:42:40'),(5326,'Change job id 01196 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1196\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:43:09'),(5327,'Change job id 01361 status as acknowledge',277,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"12-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1361\";}','fas fa-edit','2020-03-11 07:43:16'),(5328,'Change job id 01195 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1195\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:43:36'),(5329,'Change job id 00406 status as submit',277,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"406\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 07:44:25'),(5330,'Create new jobs for job id 01362.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:2:\"12\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"18-03-2020\";s:11:\"description\";s:73:\"[SSA Brochure] Request to design a brochure for Shariah Advisory Services\";s:7:\"remarks\";s:1133:\"Assalamualaikum Dear Hanif,\r\n\r\nWe appreciate your assistance to design the brochure for Shariah Advisory Services.  Details on the brochure are as follows:\r\n\r\nShariah Advisory\r\n- The write-up (follow the info from capability statement on page 11)\r\n- Our comprehensive Shariah Advisory Solutions\r\nShariah Audit, Review, Risk Management\r\n\r\nShariah Accounting, Screening\r\n\r\nExternal Shariah Committee, Shariah Secretariat Services\r\n\r\nShariah Governance & Supervision\r\n\r\nProduct Structuring & Development\r\n\r\nSukuk Issuance & Structuring advisory\r\n\r\nIslamic Fund Management Advisory\r\n\r\nIslamic Private Equity Advisory\r\n\r\nTakaful & Re-Takaful Advisory\r\n\r\nZakat & Waqaf Management & Consultancy\r\n\r\nFintech & Shariah Digital Solutions\r\n\r\nResearch & Development\r\n\r\n\r\n\r\nOur Certified Team of Experts\r\n\r\n- Dr. Ahcene Lahsasna CPIF, SRF-P, FAA, Fellow MFPC\r\n\r\n- Zarina Md Desa MBA, CIFP, CIB (CIBAFI)\r\n\r\n- Wan Nur Hazwani Chik Wan Ismail MIA, CPSA (IBFIM) \r\n\r\n- Nur Amira Rosli CIB (CIBAFI)\r\n\r\n- Nurdiyana Sabrina Abdul Rahman MIFP, CIB (CIBAFI)\r\n\r\n- Muntaka Alhaji Zakari CIB (CIBAFI), CPSA (IBFIM)\r\n\r\n- Dr. Mutalib Anifowose ACCA, FCIPA, CA(M)\";}','fas fa-pen','2020-03-11 08:13:34'),(5331,'Create new jobs for job id 01363.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:2:\"12\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"11-03-2020\";s:11:\"description\";s:67:\"[SSA Certificate] REQUEST: Product Development Training Certificate\";s:7:\"remarks\";s:211:\"Assalamualaikum wbt\r\n\r\nDear Hanif,\r\n\r\nIn shaa Allah, we will run Product Development training on 17-18 March 2020 at TAMU Hotel. We would like to request for a certificate template for our perusal.\r\n\r\nThank you.\";}','fas fa-pen','2020-03-11 08:15:13'),(5332,'Create new jobs for job id 01364.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:2:\"12\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"18-03-2020\";s:11:\"description\";s:50:\"[SSA Arabic Brochure] Usul Fiqh in Arabic brochure\";s:7:\"remarks\";s:124:\"R Hanif\r\n\r\nWe have a programme of one month in Usul Fiqh in Arabic\r\nWe need brochure for that\r\nNeed your help to design that\";}','fas fa-pen','2020-03-11 08:17:20'),(5333,'Create new jobs for job id 01365.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:2:\"12\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"13-03-2020\";s:11:\"description\";s:55:\"[SSA MFPC Brochure] REQUEST - Design MFPC Advertisement\";s:7:\"remarks\";s:347:\"Assalamualaikum WBT,\r\n\r\nDear Hanif & Nazim,\r\n\r\nWe are planning to advertise SSA\'s services in one (1) full A4 page of MFPC upcoming magazine.\r\n\r\nThe details as attached.\r\n\r\nFor your information, the deadline for submission is 13 March 2020 (upcoming Friday). Appreciate help from both of you. \r\n\r\nThank you so much.\r\n\r\nMay Allah bless both of you.\";}','fas fa-pen','2020-03-11 08:18:54'),(5334,'Create new jobs for job id 01366.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"9\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"11-03-2020\";s:11:\"description\";s:86:\"[SRC Poster for Tazkirah Ustaz Jemputan] Friday Tazkirah 13/3/2020 by Imam Muda Asyraf\";s:7:\"remarks\";s:88:\"Dear Mr Hanif,\r\n\r\n \r\n\r\nAppreciate your assistance to design the program e-banner/poster.\";}','fas fa-pen','2020-03-11 08:20:48'),(5335,'Update initial setup for job id 01366',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1366\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:86:\"[SRC Poster for Tazkirah Ustaz Jemputan] Friday Tazkirah 13/3/2020 by Imam Muda Asyraf\";s:7:\"remarks\";s:88:\"Dear Mr Hanif,\r\n\r\n \r\n\r\nAppreciate your assistance to design the program e-banner/poster.\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"11-03-2020\";s:8:\"deadline\";s:10:\"11-03-2020\";}','fas fa-edit','2020-03-11 08:21:50'),(5336,'Update job working detail for job id 01366',98,'a:5:{s:6:\"job_id\";s:4:\"1366\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"98\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 08:22:05'),(5337,'Change job id 01366 status as acknowledge',98,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"11-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1366\";}','fas fa-edit','2020-03-11 08:22:17'),(5338,'Change job id 01366 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1366\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 08:22:24'),(5339,'Update initial setup for job id 01365',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:2:\"12\";s:6:\"job_id\";s:4:\"1365\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:55:\"[SSA MFPC Brochure] REQUEST - Design MFPC Advertisement\";s:7:\"remarks\";s:347:\"Assalamualaikum WBT,\r\n\r\nDear Hanif & Nazim,\r\n\r\nWe are planning to advertise SSA\'s services in one (1) full A4 page of MFPC upcoming magazine.\r\n\r\nThe details as attached.\r\n\r\nFor your information, the deadline for submission is 13 March 2020 (upcoming Friday). Appreciate help from both of you. \r\n\r\nThank you so much.\r\n\r\nMay Allah bless both of you.\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"13-03-2020\";s:8:\"deadline\";s:10:\"13-03-2020\";}','fas fa-edit','2020-03-11 08:22:54'),(5340,'Update job working detail for job id 01365',98,'a:5:{s:6:\"job_id\";s:4:\"1365\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"98\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 08:23:03'),(5341,'Change job id 01365 status as acknowledge',98,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"13-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1365\";}','fas fa-edit','2020-03-11 08:23:11'),(5342,'Update initial setup for job id 01364',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:2:\"12\";s:6:\"job_id\";s:4:\"1364\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:50:\"[SSA Arabic Brochure] Usul Fiqh in Arabic brochure\";s:7:\"remarks\";s:124:\"R Hanif\r\n\r\nWe have a programme of one month in Usul Fiqh in Arabic\r\nWe need brochure for that\r\nNeed your help to design that\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"18-03-2020\";s:8:\"deadline\";s:10:\"18-03-2020\";}','fas fa-edit','2020-03-11 08:23:35'),(5343,'Update job working detail for job id 01364',98,'a:5:{s:6:\"job_id\";s:4:\"1364\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"98\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 08:23:44'),(5344,'Change job id 01364 status as acknowledge',98,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"18-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1364\";}','fas fa-edit','2020-03-11 08:23:52'),(5345,'Update initial setup for job id 01363',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:2:\"12\";s:6:\"job_id\";s:4:\"1363\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:67:\"[SSA Certificate] REQUEST: Product Development Training Certificate\";s:7:\"remarks\";s:211:\"Assalamualaikum wbt\r\n\r\nDear Hanif,\r\n\r\nIn shaa Allah, we will run Product Development training on 17-18 March 2020 at TAMU Hotel. We would like to request for a certificate template for our perusal.\r\n\r\nThank you.\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"11-03-2020\";s:8:\"deadline\";s:10:\"11-03-2020\";}','fas fa-edit','2020-03-11 08:24:25'),(5346,'Update job working detail for job id 01363',98,'a:5:{s:6:\"job_id\";s:4:\"1363\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"98\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 08:24:38'),(5347,'Change job id 01363 status as acknowledge',98,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"11-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1363\";}','fas fa-edit','2020-03-11 08:24:45'),(5348,'Change job id 01363 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1363\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 08:24:53'),(5349,'Change job id 01363 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1363\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-11 08:25:00'),(5350,'Update initial setup for job id 01362',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:2:\"12\";s:6:\"job_id\";s:4:\"1362\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:73:\"[SSA Brochure] Request to design a brochure for Shariah Advisory Services\";s:7:\"remarks\";s:1133:\"Assalamualaikum Dear Hanif,\r\n\r\nWe appreciate your assistance to design the brochure for Shariah Advisory Services.  Details on the brochure are as follows:\r\n\r\nShariah Advisory\r\n- The write-up (follow the info from capability statement on page 11)\r\n- Our comprehensive Shariah Advisory Solutions\r\nShariah Audit, Review, Risk Management\r\n\r\nShariah Accounting, Screening\r\n\r\nExternal Shariah Committee, Shariah Secretariat Services\r\n\r\nShariah Governance & Supervision\r\n\r\nProduct Structuring & Development\r\n\r\nSukuk Issuance & Structuring advisory\r\n\r\nIslamic Fund Management Advisory\r\n\r\nIslamic Private Equity Advisory\r\n\r\nTakaful & Re-Takaful Advisory\r\n\r\nZakat & Waqaf Management & Consultancy\r\n\r\nFintech & Shariah Digital Solutions\r\n\r\nResearch & Development\r\n\r\n\r\n\r\nOur Certified Team of Experts\r\n\r\n- Dr. Ahcene Lahsasna CPIF, SRF-P, FAA, Fellow MFPC\r\n\r\n- Zarina Md Desa MBA, CIFP, CIB (CIBAFI)\r\n\r\n- Wan Nur Hazwani Chik Wan Ismail MIA, CPSA (IBFIM) \r\n\r\n- Nur Amira Rosli CIB (CIBAFI)\r\n\r\n- Nurdiyana Sabrina Abdul Rahman MIFP, CIB (CIBAFI)\r\n\r\n- Muntaka Alhaji Zakari CIB (CIBAFI), CPSA (IBFIM)\r\n\r\n- Dr. Mutalib Anifowose ACCA, FCIPA, CA(M)\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"18-03-2020\";s:8:\"deadline\";s:10:\"18-03-2020\";}','fas fa-edit','2020-03-11 08:25:26'),(5351,'Update job working detail for job id 01362',98,'a:5:{s:6:\"job_id\";s:4:\"1362\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"98\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-11 08:25:36'),(5352,'Change job id 01362 status as acknowledge',98,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"18-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1362\";}','fas fa-edit','2020-03-11 08:25:45'),(5353,'Create new jobs for job id 01367.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:4:\"1469\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"8\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2017\";s:11:\"description\";s:17:\"YEAR END DEC 2017\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 10:09:46'),(5354,'Create new jobs for job id 01368.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:4:\"1469\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"8\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2018\";s:11:\"description\";s:17:\"YEAR END DEC 2018\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 10:28:16'),(5355,'Create new jobs for job id 01369.',81,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:4:\"1469\";s:11:\"is_internal\";s:1:\"0\";s:4:\"dept\";a:1:{i:0;s:1:\"8\";}s:8:\"deadline\";s:10:\"31-03-2020\";s:11:\"yearEndDate\";s:10:\"31-12-2019\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-11 10:29:31'),(5356,'Change job id 01261 status as acknowledge',103,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-03-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1261\";}','fas fa-edit','2020-03-11 10:52:53'),(5357,'Change job id 00693 status as submit',103,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"693\";s:7:\"dept_id\";s:1:\"8\";}','fas fa-edit','2020-03-11 10:53:39'),(5358,'Create a new invoice amount 11,511.60 for job id 00693',103,'a:6:{s:6:\"job_id\";s:3:\"693\";s:7:\"dept_id\";s:1:\"8\";s:4:\"date\";s:10:\"02-03-2020\";s:6:\"number\";s:21:\"INV 2715  CN 2020/009\";s:14:\"representative\";s:3:\"103\";s:6:\"amount\";s:9:\"11,511.60\";}','fas fa-file-invoice','2020-03-11 10:56:48'),(5359,'Change job id 00775 status as submit',103,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"775\";s:7:\"dept_id\";s:1:\"8\";}','fas fa-edit','2020-03-11 10:58:55'),(5360,'Create a new invoice amount 20,723 for job id 00775',103,'a:6:{s:6:\"job_id\";s:3:\"775\";s:7:\"dept_id\";s:1:\"8\";s:4:\"date\";s:10:\"26-02-2020\";s:6:\"number\";s:23:\"INTERIM INVOICE NO 2705\";s:14:\"representative\";s:3:\"103\";s:6:\"amount\";s:6:\"20,723\";}','fas fa-file-invoice','2020-03-11 11:00:43'),(5361,'Change job id 01037 status as acknowledge',175,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"29-02-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1037\";}','fas fa-edit','2020-03-11 14:39:54'),(5362,'Change job id 01039 status as acknowledge',175,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"29-02-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1039\";}','fas fa-edit','2020-03-11 14:40:20'),(5363,'Change job id 01051 status as acknowledge',175,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"29-02-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1051\";}','fas fa-edit','2020-03-11 14:40:35'),(5364,'Change job id 01177 status as acknowledge',370,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-03-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1177\";}','fas fa-edit','2020-03-12 00:24:13'),(5365,'Change job id 00206 status as acknowledge',357,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:3:\"206\";}','fas fa-edit','2020-03-12 01:08:41'),(5366,'Change job id 01335 status as acknowledge',357,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1335\";}','fas fa-edit','2020-03-12 01:09:52'),(5367,'Change job id 01338 status as acknowledge',328,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1338\";}','fas fa-edit','2020-03-12 01:19:26'),(5368,'Change job id 00510 status as complete',97,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:3:\"510\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:04:46'),(5369,'Create new jobs for job id 01370.',97,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"9\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"12-03-2020\";s:11:\"description\";s:27:\"Role Description (JD) - HOD\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-12 02:08:07'),(5370,'Create new jobs for job id 01371.',97,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"9\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"12-03-2020\";s:11:\"description\";s:15:\"CISA Books Scan\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-12 02:09:25'),(5371,'Create new jobs for job id 01372.',97,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"20-03-2020\";s:11:\"description\";s:8:\"JD - CRM\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-12 02:15:30'),(5372,'Update initial setup for job id 01372',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"2\";s:6:\"job_id\";s:4:\"1372\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"116\";s:11:\"description\";s:8:\"JD - CRM\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"20-03-2020\";s:8:\"deadline\";s:10:\"20-03-2020\";}','fas fa-edit','2020-03-12 02:18:11'),(5373,'Update job working detail for job id 01372',97,'a:5:{s:6:\"job_id\";s:4:\"1372\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"97\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 02:18:27'),(5374,'Change job id 01372 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"20-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1372\";}','fas fa-edit','2020-03-12 02:18:41'),(5375,'Update initial setup for job id 01371',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1371\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"127\";s:11:\"description\";s:15:\"CISA Books Scan\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-12 02:19:26'),(5376,'Update job working detail for job id 01371',97,'a:5:{s:6:\"job_id\";s:4:\"1371\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:2:{i:0;s:3:\"235\";i:1;s:2:\"97\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 02:19:47'),(5377,'Change job id 01371 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"12-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1371\";}','fas fa-edit','2020-03-12 02:20:16'),(5378,'Update initial setup for job id 01370',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1370\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"116\";s:11:\"description\";s:27:\"Role Description (JD) - HOD\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-12 02:21:06'),(5379,'Update job working detail for job id 01370',97,'a:5:{s:6:\"job_id\";s:4:\"1370\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"97\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 02:21:26'),(5380,'Change job id 01370 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"12-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1370\";}','fas fa-edit','2020-03-12 02:21:38'),(5381,'Update initial setup for job id 01295',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1295\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"107\";s:11:\"description\";s:47:\"En Salihin Calendar Update - Technical Meetings\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"10-03-2020\";s:8:\"deadline\";s:10:\"10-03-2020\";}','fas fa-edit','2020-03-12 02:23:54'),(5382,'Update job working detail for job id 01295',97,'a:5:{s:6:\"job_id\";s:4:\"1295\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"235\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 02:25:40'),(5383,'Update initial setup for job id 01295',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1295\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"107\";s:11:\"description\";s:47:\"En Salihin Calendar Update - Technical Meetings\";s:7:\"remarks\";s:19:\"Refer to Dr Mutalib\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"10-03-2020\";s:8:\"deadline\";s:10:\"10-03-2020\";}','fas fa-edit','2020-03-12 02:26:36'),(5384,'Change job id 01295 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"10-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1295\";}','fas fa-edit','2020-03-12 02:26:51'),(5385,'Change job id 01283 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"09-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1283\";}','fas fa-edit','2020-03-12 02:27:22'),(5386,'Change job id 01283 status as submit',97,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1283\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:27:31'),(5387,'Change job id 01283 status as complete',97,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1283\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:27:44'),(5388,'Update initial setup for job id 00342',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"342\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"116\";s:11:\"description\";s:20:\"Performance Planning\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:0:\"\";s:8:\"deadline\";s:0:\"\";}','fas fa-edit','2020-03-12 02:29:29'),(5389,'Update initial setup for job id 00342',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"342\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"116\";s:11:\"description\";s:27:\"Performance Planning - P.O.\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:0:\"\";s:8:\"deadline\";s:10:\"31-12-2019\";}','fas fa-edit','2020-03-12 02:30:45'),(5390,'Update job working detail for job id 00342',97,'a:5:{s:6:\"job_id\";s:3:\"342\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:7:{i:0;s:3:\"235\";i:1;s:3:\"148\";i:2;s:2:\"98\";i:3;s:2:\"97\";i:4;s:3:\"216\";i:5;s:3:\"277\";i:6;s:3:\"323\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 02:32:15'),(5391,'Update team setup setting for job id 00342',97,'a:3:{s:6:\"job_id\";s:3:\"342\";s:7:\"dept_id\";s:1:\"9\";s:6:\"leader\";a:1:{i:0;s:4:\"1266\";}}','fas fa-edit','2020-03-12 02:32:36'),(5392,'Change job id 00342 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-12-2019\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:3:\"342\";}','fas fa-edit','2020-03-12 02:32:49'),(5393,'Change job id 00342 status as submit',97,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"342\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:33:01'),(5394,'Change job id 00342 status as complete',97,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:3:\"342\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:33:09'),(5395,'Change job id 01295 status as submit',97,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1295\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:33:55'),(5396,'Change job id 01295 status as complete',97,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1295\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:34:04'),(5397,'Change job id 01082 status as acknowledge',372,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"29-02-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1082\";}','fas fa-edit','2020-03-12 02:40:47'),(5398,'Change job id 01313 status as acknowledge',372,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1313\";}','fas fa-edit','2020-03-12 02:41:54'),(5399,'Update initial setup for job id 01288',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1288\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"107\";s:11:\"description\";s:39:\"Redesign SALIHIN Resource Kit - website\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"10-03-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-12 02:43:48'),(5400,'Change job id 01284 status as submit',97,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1284\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:46:14'),(5401,'Change job id 01284 status as complete',97,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1284\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:46:21'),(5402,'Update initial setup for job id 00587',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:2:\"15\";s:6:\"job_id\";s:3:\"587\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"112\";s:11:\"description\";s:44:\"Design of capabilities statements for MySA\r\n\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"27-03-2020\";}','fas fa-edit','2020-03-12 02:47:13'),(5403,'Change job id 00584 status as submit',97,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"584\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:47:45'),(5404,'Change job id 00584 status as complete',97,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:3:\"584\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 02:47:54'),(5405,'Create new jobs for job id 01373.',97,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"9\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"12-03-2020\";s:11:\"description\";s:52:\"En Salihin profile summary for G3 Annual Report 2019\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-12 02:59:50'),(5406,'Update initial setup for job id 01373',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:4:\"1373\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"106\";s:11:\"description\";s:52:\"En Salihin profile summary for G3 Annual Report 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-12 03:01:26'),(5407,'Update job working detail for job id 01373',97,'a:5:{s:6:\"job_id\";s:4:\"1373\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"97\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 03:01:45'),(5408,'Change job id 01373 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"12-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1373\";}','fas fa-edit','2020-03-12 03:01:54'),(5409,'Create new jobs for job id 01374.',97,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"4\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"12-03-2020\";s:11:\"description\";s:40:\"Review of new standard ENGAGEMENT LETTER\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-12 03:14:39'),(5410,'Update initial setup for job id 01374',97,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"4\";s:6:\"job_id\";s:4:\"1374\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"105\";s:11:\"description\";s:40:\"Review of new standard ENGAGEMENT LETTER\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-12 03:15:41'),(5411,'Failed to update team setup setting for job id 01374',97,'a:2:{s:6:\"job_id\";s:4:\"1374\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 03:16:00'),(5412,'Update job working detail for job id 01374',97,'a:5:{s:6:\"job_id\";s:4:\"1374\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"97\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 03:16:02'),(5413,'Change job id 01374 status as acknowledge',97,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"12-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1374\";}','fas fa-edit','2020-03-12 03:16:15'),(5414,'Change job id 00020 status as acknowledge',370,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:2:\"20\";}','fas fa-edit','2020-03-12 03:29:38'),(5415,'Change job id 00023 status as acknowledge',370,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:2:\"23\";}','fas fa-edit','2020-03-12 03:30:04'),(5416,'Update initial setup for job id 00542',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"542\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"108\";s:11:\"description\";s:40:\"Technical Article on Professional Ethics\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-12 05:04:24'),(5417,'Update initial setup for job id 00583',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"583\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"108\";s:11:\"description\";s:26:\"Professional short article\";s:7:\"remarks\";s:37:\"For website and e-bulletin to clients\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-12 05:05:28'),(5418,'Update initial setup for job id 00582',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"582\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"108\";s:11:\"description\";s:18:\"Conference Article\";s:7:\"remarks\";s:39:\"To decide on topic and prepare abstract\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"31-01-2020\";}','fas fa-edit','2020-03-12 05:06:00'),(5419,'Update initial setup for job id 00582',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"582\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"108\";s:11:\"description\";s:18:\"Conference Article\";s:7:\"remarks\";s:39:\"To decide on topic and prepare abstract\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"31-01-2020\";}','fas fa-edit','2020-03-12 05:06:42'),(5420,'Update initial setup for job id 00543',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"543\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"108\";s:11:\"description\";s:40:\"Technical Article on Professional Ethics\";s:7:\"remarks\";s:70:\"The article would focus on benefits on professional ethics  principles\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-12 05:07:20'),(5421,'Update initial setup for job id 00582',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"9\";s:6:\"job_id\";s:3:\"582\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"108\";s:11:\"description\";s:18:\"Conference Article\";s:7:\"remarks\";s:39:\"To decide on topic and prepare abstract\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-01-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-12 05:07:39'),(5422,'Create new jobs for job id 01375.',216,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"8\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"12-03-2020\";s:11:\"description\";s:53:\"Review of  Distinction One Sdn. Bhd. 2018 Audit file \";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-12 05:09:31'),(5423,'Update initial setup for job id 01375',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"8\";s:6:\"job_id\";s:4:\"1375\";s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:53:\"Review of  Distinction One Sdn. Bhd. 2018 Audit file \";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"12-03-2020\";s:8:\"deadline\";s:10:\"12-03-2020\";}','fas fa-edit','2020-03-12 05:19:26'),(5424,'Update job working detail for job id 01375',216,'a:5:{s:6:\"job_id\";s:4:\"1375\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"216\";}s:11:\"file_number\";s:4:\"CT23\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 05:19:45'),(5425,'Change job id 01375 status as acknowledge',216,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"12-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1375\";}','fas fa-edit','2020-03-12 05:19:58'),(5426,'Change job id 01375 status as submit',216,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1375\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 05:20:09'),(5427,'Change job id 01375 status as complete',216,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1375\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-12 05:21:09'),(5428,'Create new jobs for job id 01376.',98,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:2:\"12\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"20-03-2020\";s:11:\"description\";s:34:\"Photoshoot for Shariah Issues book\";s:7:\"remarks\";s:103:\"Model :\r\n-  2 Muslimah model (staff or intern) wearing SALIHIN corporate shirt\r\n- Prof. Ahcene (Author)\";}','fas fa-pen','2020-03-12 07:05:20'),(5429,'Update initial setup for job id 01376',98,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:2:\"12\";s:6:\"job_id\";s:4:\"1376\";s:15:\"service_type_id\";s:2:\"10\";s:11:\"job_type_id\";s:3:\"113\";s:11:\"description\";s:34:\"Photoshoot for Shariah Issues book\";s:7:\"remarks\";s:103:\"Model :\r\n-  2 Muslimah model (staff or intern) wearing SALIHIN corporate shirt\r\n- Prof. Ahcene (Author)\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"20-03-2020\";s:8:\"deadline\";s:10:\"20-03-2020\";}','fas fa-edit','2020-03-12 07:07:18'),(5430,'Update job working detail for job id 01376',98,'a:5:{s:6:\"job_id\";s:4:\"1376\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:2:{i:0;s:2:\"98\";i:1;s:3:\"277\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-12 07:08:09'),(5431,'Change job id 01376 status as acknowledge',98,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"20-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1376\";}','fas fa-edit','2020-03-12 07:08:17'),(5432,'Create new jobs for job id 01377.',216,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"5\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"13-03-2020\";s:11:\"description\";s:52:\"Training on MFRS 16: Accounting for lease agreement.\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-13 06:54:52'),(5433,'Update initial setup for job id 01377',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"5\";s:6:\"job_id\";s:4:\"1377\";s:15:\"service_type_id\";s:1:\"9\";s:11:\"job_type_id\";s:2:\"32\";s:11:\"description\";s:52:\"Training on MFRS 16: Accounting for lease agreement.\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"13-03-2020\";s:8:\"deadline\";s:10:\"13-03-2020\";}','fas fa-edit','2020-03-13 07:18:49'),(5434,'Update job working detail for job id 01377',216,'a:5:{s:6:\"job_id\";s:4:\"1377\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"216\";}s:11:\"file_number\";s:4:\"CT23\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-13 07:19:16'),(5435,'Change job id 01377 status as acknowledge',216,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"13-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1377\";}','fas fa-edit','2020-03-13 07:19:27'),(5436,'Change job id 01377 status as submit',216,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1377\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-13 07:19:53'),(5437,'Change job id 01377 status as complete',216,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1377\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-13 07:20:04'),(5438,'Create new jobs for job id 01378.',216,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"8\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"9\";}s:8:\"deadline\";s:10:\"13-03-2020\";s:11:\"description\";s:47:\"Review of audit file of Kemuncak daya Sdn. Bhd.\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-13 08:29:01'),(5439,'Update initial setup for job id 01378',216,'a:10:{s:7:\"dept_id\";s:1:\"9\";s:6:\"client\";s:1:\"8\";s:6:\"job_id\";s:4:\"1378\";s:15:\"service_type_id\";s:1:\"1\";s:11:\"job_type_id\";s:1:\"1\";s:11:\"description\";s:47:\"Review of audit file of Kemuncak daya Sdn. Bhd.\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"13-03-2020\";s:8:\"deadline\";s:10:\"13-03-2020\";}','fas fa-edit','2020-03-13 08:29:34'),(5440,'Update job working detail for job id 01378',216,'a:5:{s:6:\"job_id\";s:4:\"1378\";s:7:\"dept_id\";s:1:\"9\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"216\";}s:11:\"file_number\";s:4:\"CT23\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-13 08:29:52'),(5441,'Change job id 01378 status as acknowledge',216,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"13-03-2020\";s:7:\"dept_id\";s:1:\"9\";s:6:\"job_id\";s:4:\"1378\";}','fas fa-edit','2020-03-13 08:30:03'),(5442,'Change job id 01378 status as submit',216,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1378\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-13 08:30:16'),(5443,'Change job id 01378 status as complete',216,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1378\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-13 08:30:31'),(5444,'Update initial setup for job id 01299',21,'a:10:{s:7:\"dept_id\";s:1:\"5\";s:6:\"client\";s:3:\"300\";s:6:\"job_id\";s:4:\"1299\";s:14:\"related_job_id\";a:3:{i:0;s:4:\"1300\";i:1;s:4:\"1301\";i:2;s:4:\"1302\";}s:15:\"service_type_id\";s:1:\"9\";s:11:\"job_type_id\";s:2:\"31\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2019\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-13 09:21:31'),(5445,'Update job working detail for job id 01299',21,'a:6:{s:6:\"job_id\";s:4:\"1299\";s:14:\"related_job_id\";a:3:{i:0;s:4:\"1300\";i:1;s:4:\"1301\";i:2;s:4:\"1302\";}s:7:\"dept_id\";s:1:\"5\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"269\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-13 09:21:57'),(5446,'Update initial setup for job id 01306',21,'a:10:{s:7:\"dept_id\";s:1:\"5\";s:6:\"client\";s:2:\"59\";s:6:\"job_id\";s:4:\"1306\";s:14:\"related_job_id\";a:3:{i:0;s:4:\"1307\";i:1;s:4:\"1308\";i:2;s:4:\"1309\";}s:15:\"service_type_id\";s:1:\"9\";s:11:\"job_type_id\";s:2:\"31\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2019\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-13 09:22:33'),(5447,'Update job working detail for job id 01306',21,'a:6:{s:6:\"job_id\";s:4:\"1306\";s:14:\"related_job_id\";a:3:{i:0;s:4:\"1307\";i:1;s:4:\"1308\";i:2;s:4:\"1309\";}s:7:\"dept_id\";s:1:\"5\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"117\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-13 09:22:47'),(5448,'Change job id 01371 status as submit',235,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1371\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-13 09:23:32'),(5449,'Update initial setup for job id 01297',21,'a:9:{s:7:\"dept_id\";s:1:\"5\";s:6:\"client\";s:3:\"694\";s:6:\"job_id\";s:4:\"1297\";s:15:\"service_type_id\";s:1:\"9\";s:11:\"job_type_id\";s:2:\"31\";s:11:\"description\";s:17:\"YEAR END DEC 2020\";s:7:\"remarks\";s:11:\"Monthly acc\";s:13:\"year_end_date\";s:10:\"31-12-2020\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-13 09:24:32'),(5450,'Update job working detail for job id 01297',21,'a:5:{s:6:\"job_id\";s:4:\"1297\";s:7:\"dept_id\";s:1:\"5\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"117\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2021\";}','fas fa-edit','2020-03-13 09:24:45'),(5451,'Update initial setup for job id 01298',21,'a:9:{s:7:\"dept_id\";s:1:\"5\";s:6:\"client\";s:3:\"695\";s:6:\"job_id\";s:4:\"1298\";s:15:\"service_type_id\";s:1:\"9\";s:11:\"job_type_id\";s:2:\"31\";s:11:\"description\";s:17:\"YEAR END DEC 2020\";s:7:\"remarks\";s:11:\"Monthly acc\";s:13:\"year_end_date\";s:10:\"31-12-2020\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-13 09:25:11'),(5452,'Update job working detail for job id 01298',21,'a:5:{s:6:\"job_id\";s:4:\"1298\";s:7:\"dept_id\";s:1:\"5\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"117\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2021\";}','fas fa-edit','2020-03-13 09:25:22'),(5453,'Update initial setup for job id 01296',21,'a:9:{s:7:\"dept_id\";s:1:\"5\";s:6:\"client\";s:4:\"1015\";s:6:\"job_id\";s:4:\"1296\";s:15:\"service_type_id\";s:1:\"9\";s:11:\"job_type_id\";s:2:\"31\";s:11:\"description\";s:17:\"YEAR END DEC 2020\";s:7:\"remarks\";s:11:\"Monthly acc\";s:13:\"year_end_date\";s:10:\"31-12-2020\";s:12:\"currDeadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-13 09:25:55'),(5454,'Update job working detail for job id 01296',21,'a:5:{s:6:\"job_id\";s:4:\"1296\";s:7:\"dept_id\";s:1:\"5\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"117\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2021\";}','fas fa-edit','2020-03-13 09:26:07'),(5455,'Create a new daily update for job id : 01371',235,'a:3:{s:6:\"job_id\";s:4:\"1371\";s:7:\"dept_id\";s:1:\"9\";s:7:\"content\";s:343:\"<p>12 - 13 / March 2020		</p><ol><li>Working on SALIHIN website [Knowledge Resource Kit]</li><li>Adjusting, edit and update the allignment for SALIHIN website [Knowledge Resource Kit]</li><li>Working on scanning the CISA books [To save the soft copy into the Partners Office folder]</li><li>Update schedule, reply email [En Salihin] </li></ol>\";}','fas fa-pen','2020-03-13 09:26:30'),(5456,'Update job working detail for job id 01203',142,'a:5:{s:6:\"job_id\";s:4:\"1203\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"76\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-13 09:39:55'),(5457,'Update team setup setting for job id 01203',142,'a:3:{s:6:\"job_id\";s:4:\"1203\";s:7:\"dept_id\";s:1:\"2\";s:6:\"leader\";a:1:{i:0;s:4:\"1282\";}}','fas fa-edit','2020-03-13 09:40:05'),(5458,'Update initial setup for job id 01228',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1228\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"135\";s:11:\"description\";s:25:\"EXCO REPORT FEBRUARY 2020\";s:7:\"remarks\";s:44:\"EMAILED TO HASRINA ON FRIDAY (14 MARCH 2020)\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"16-03-2020\";s:8:\"deadline\";s:10:\"16-03-2020\";}','fas fa-edit','2020-03-16 00:47:42'),(5459,'Change job id 01228 status as acknowledge',142,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"16-03-2020\";s:7:\"dept_id\";s:1:\"2\";s:6:\"job_id\";s:4:\"1228\";}','fas fa-edit','2020-03-16 00:49:23'),(5460,'Change job id 01228 status as submit',142,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1228\";s:7:\"dept_id\";s:1:\"2\";}','fas fa-edit','2020-03-16 00:49:30'),(5461,'Change job id 01228 status as complete',142,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1228\";s:7:\"dept_id\";s:1:\"2\";}','fas fa-edit','2020-03-16 00:49:52'),(5462,'Change job id 01179 status as acknowledge',321,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-03-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1179\";}','fas fa-edit','2020-03-16 03:01:28'),(5463,'Change job id 01179 status as acknowledge',321,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-03-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1179\";}','fas fa-edit','2020-03-16 03:01:34'),(5464,'Change job id 01243 status as acknowledge',356,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"31-03-2020\";s:7:\"dept_id\";s:1:\"8\";s:6:\"job_id\";s:4:\"1243\";}','fas fa-edit','2020-03-16 04:17:40'),(5465,'Update initial setup for job id 01360',23,'a:9:{s:7:\"dept_id\";s:1:\"3\";s:6:\"client\";s:2:\"27\";s:6:\"job_id\";s:4:\"1360\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1359\";}s:15:\"service_type_id\";s:1:\"7\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2019\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-16 06:31:03'),(5466,'Update job working detail for job id 01360',23,'a:8:{s:6:\"job_id\";s:4:\"1360\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1359\";}s:7:\"dept_id\";s:1:\"3\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"139\";}s:11:\"file_number\";s:0:\"\";s:20:\"compliance_type_date\";s:1:\"2\";s:15:\"compliance_date\";s:10:\"30-07-2020\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-16 06:31:37'),(5467,'Update initial setup for job id 01358',23,'a:9:{s:7:\"dept_id\";s:1:\"3\";s:6:\"client\";s:4:\"1468\";s:6:\"job_id\";s:4:\"1358\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1357\";}s:15:\"service_type_id\";s:1:\"7\";s:11:\"description\";s:17:\"YEAR END DEC 2019\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:10:\"31-12-2019\";s:12:\"currDeadline\";s:0:\"\";}','fas fa-edit','2020-03-16 06:32:00'),(5468,'Update job working detail for job id 01358',23,'a:6:{s:6:\"job_id\";s:4:\"1358\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1357\";}s:7:\"dept_id\";s:1:\"3\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"381\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-16 07:58:44'),(5469,'Update job working detail for job id 01358',23,'a:6:{s:6:\"job_id\";s:4:\"1358\";s:14:\"related_job_id\";a:1:{i:0;s:4:\"1357\";}s:7:\"dept_id\";s:1:\"3\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"381\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:10:\"31-07-2020\";}','fas fa-edit','2020-03-16 07:58:47'),(5470,'Change job id 01365 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1365\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-17 01:16:33'),(5471,'Change job id 01365 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1365\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-17 01:16:42'),(5472,'Change job id 01366 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1366\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-17 01:38:19'),(5473,'Change job id 00277 status as submit',138,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"277\";s:7:\"dept_id\";s:1:\"3\";}','fas fa-edit','2020-03-17 01:49:32'),(5474,'Change job id 00006 status as acknowledge',138,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"3\";s:6:\"job_id\";s:1:\"6\";}','fas fa-edit','2020-03-17 01:50:09'),(5475,'Change job id 00156 status as acknowledge',138,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"3\";s:6:\"job_id\";s:3:\"156\";}','fas fa-edit','2020-03-17 01:51:10'),(5476,'Change job id 00156 status as submit',138,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"156\";s:7:\"dept_id\";s:1:\"3\";}','fas fa-edit','2020-03-17 01:51:16'),(5477,'Change job id 00195 status as acknowledge',138,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"3\";s:6:\"job_id\";s:3:\"195\";}','fas fa-edit','2020-03-17 01:52:38'),(5478,'Change job id 00195 status as submit',138,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"195\";s:7:\"dept_id\";s:1:\"3\";}','fas fa-edit','2020-03-17 01:52:45'),(5479,'Change job id 00681 status as acknowledge',138,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"3\";s:6:\"job_id\";s:3:\"681\";}','fas fa-edit','2020-03-17 01:53:54'),(5480,'Change job id 00706 status as acknowledge',138,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"3\";s:6:\"job_id\";s:3:\"706\";}','fas fa-edit','2020-03-17 01:54:43'),(5481,'Change job id 00706 status as submit',138,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:3:\"706\";s:7:\"dept_id\";s:1:\"3\";}','fas fa-edit','2020-03-17 01:54:59'),(5482,'Change job id 01361 status as submit',98,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1361\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-17 02:09:01'),(5483,'Change job id 01361 status as complete',98,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1361\";s:7:\"dept_id\";s:1:\"9\";}','fas fa-edit','2020-03-17 02:09:15'),(5484,'Create new jobs for job id 01379.',142,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"2\";}s:8:\"deadline\";s:10:\"10-04-2020\";s:11:\"description\";s:17:\"COSTING EN JAFREE\";s:7:\"remarks\";s:77:\"TO TOTAL UP COSTING SHAFIQ AS DRIVER TO EN JAFREE. TO CHARGE AUDIT DEPARTMENT\";}','fas fa-pen','2020-03-17 04:25:42'),(5485,'Create new jobs for job id 01380.',142,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"2\";}s:8:\"deadline\";s:10:\"10-04-2020\";s:11:\"description\";s:63:\"APPOINTMENT LETTER TO ISMAIL ADAM - SALIHIN PUBLICATION SDN BHD\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-17 04:26:28'),(5486,'Create new jobs for job id 01381.',142,'a:9:{s:5:\"jobID\";s:15:\"[Auto generate]\";s:11:\"yearEndDate\";s:0:\"\";s:9:\"createdBy\";s:0:\"\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:4:\"dept\";a:1:{i:0;s:1:\"2\";}s:8:\"deadline\";s:10:\"10-04-2020\";s:11:\"description\";s:59:\"APPOINTMENT LETTER TO ISMAIL ADAM - SALIHIN ACADEMY SDN BHD\";s:7:\"remarks\";s:0:\"\";}','fas fa-pen','2020-03-17 04:27:23'),(5487,'Update initial setup for job id 01381',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1381\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"134\";s:11:\"description\";s:59:\"APPOINTMENT LETTER TO ISMAIL ADAM - SALIHIN ACADEMY SDN BHD\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"10-04-2020\";s:8:\"deadline\";s:10:\"10-04-2020\";}','fas fa-edit','2020-03-17 04:29:42'),(5488,'Update job working detail for job id 01381',142,'a:5:{s:6:\"job_id\";s:4:\"1381\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"83\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:29:51'),(5489,'Update initial setup for job id 01380',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1380\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"134\";s:11:\"description\";s:63:\"APPOINTMENT LETTER TO ISMAIL ADAM - SALIHIN PUBLICATION SDN BHD\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"10-04-2020\";s:8:\"deadline\";s:10:\"10-04-2020\";}','fas fa-edit','2020-03-17 04:30:21'),(5490,'Update job working detail for job id 01380',142,'a:5:{s:6:\"job_id\";s:4:\"1380\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:2:\"83\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:30:30'),(5491,'Update initial setup for job id 01248',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1248\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"134\";s:11:\"description\";s:41:\"BANK CONFIRMATION LISTING - SALIHIN GROUP\";s:7:\"remarks\";s:11:\"PIC KAK WAN\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"18-03-2020\";s:8:\"deadline\";s:10:\"18-03-2020\";}','fas fa-edit','2020-03-17 04:31:18'),(5492,'Update job working detail for job id 01248',142,'a:5:{s:6:\"job_id\";s:4:\"1248\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"142\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:31:38'),(5493,'Update job working detail for job id 01290',142,'a:5:{s:6:\"job_id\";s:4:\"1290\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"142\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:32:17'),(5494,'Update initial setup for job id 01379',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1379\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"134\";s:11:\"description\";s:17:\"COSTING EN JAFREE\";s:7:\"remarks\";s:77:\"TO TOTAL UP COSTING SHAFIQ AS DRIVER TO EN JAFREE. TO CHARGE AUDIT DEPARTMENT\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"10-04-2020\";s:8:\"deadline\";s:10:\"10-04-2020\";}','fas fa-edit','2020-03-17 04:32:51'),(5495,'Update job working detail for job id 01379',142,'a:5:{s:6:\"job_id\";s:4:\"1379\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"168\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:33:02'),(5496,'Update initial setup for job id 01257',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1257\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"135\";s:11:\"description\";s:26:\"FELDA VENDOR REGISTRATION \";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"25-04-2020\";s:8:\"deadline\";s:10:\"25-04-2020\";}','fas fa-edit','2020-03-17 04:33:35'),(5497,'Update job working detail for job id 01257',142,'a:5:{s:6:\"job_id\";s:4:\"1257\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"142\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:33:46'),(5498,'Update initial setup for job id 01292',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1292\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"135\";s:11:\"description\";s:43:\"CLOSE LHDN FILE - ACHILLES TYRE (M) SDN BHD\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-03-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-17 04:34:22'),(5499,'Update job working detail for job id 01292',142,'a:5:{s:6:\"job_id\";s:4:\"1292\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"142\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:36:24'),(5500,'Update initial setup for job id 01291',142,'a:11:{s:7:\"dept_id\";s:1:\"2\";s:6:\"client\";s:1:\"2\";s:11:\"is_internal\";s:1:\"1\";s:6:\"job_id\";s:4:\"1291\";s:15:\"service_type_id\";s:2:\"11\";s:11:\"job_type_id\";s:3:\"135\";s:11:\"description\";s:46:\"CLOSE LHDN FILE - KENYALANG PETRO TECH SDN BHD\";s:7:\"remarks\";s:0:\"\";s:13:\"year_end_date\";s:0:\"\";s:12:\"currDeadline\";s:10:\"31-03-2020\";s:8:\"deadline\";s:10:\"31-03-2020\";}','fas fa-edit','2020-03-17 04:36:51'),(5501,'Update job working detail for job id 01291',142,'a:5:{s:6:\"job_id\";s:4:\"1291\";s:7:\"dept_id\";s:1:\"2\";s:16:\"person_in_charge\";a:1:{i:0;s:3:\"142\";}s:11:\"file_number\";s:0:\"\";s:19:\"tax_submission_date\";s:0:\"\";}','fas fa-edit','2020-03-17 04:37:13'),(5502,'Change job id 01248 status as acknowledge',142,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:10:\"18-03-2020\";s:7:\"dept_id\";s:1:\"2\";s:6:\"job_id\";s:4:\"1248\";}','fas fa-edit','2020-03-17 05:13:52'),(5503,'Change job id 01248 status as submit',142,'a:3:{s:6:\"status\";s:1:\"2\";s:6:\"job_id\";s:4:\"1248\";s:7:\"dept_id\";s:1:\"2\";}','fas fa-edit','2020-03-17 05:14:00'),(5504,'Change job id 01248 status as complete',142,'a:3:{s:6:\"status\";s:1:\"3\";s:6:\"job_id\";s:4:\"1248\";s:7:\"dept_id\";s:1:\"2\";}','fas fa-edit','2020-03-17 05:14:22'),(5505,'Change job id 01299 status as acknowledge',269,'a:4:{s:6:\"status\";s:1:\"1\";s:8:\"deadline\";s:0:\"\";s:7:\"dept_id\";s:1:\"5\";s:6:\"job_id\";s:4:\"1299\";}','fas fa-edit','2020-03-17 06:06:00');

--
-- Temporary table structure for view `user__employment_detail`
--

/*!50001 DROP VIEW IF EXISTS `user__employment_detail`*/;
/*!50001 CREATE TABLE `user__employment_detail` (
  `id` tinyint NOT NULL,
  `user_id` tinyint NOT NULL,
  `staff_id` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `profiling_id` tinyint NOT NULL,
  `company_id` tinyint NOT NULL,
  `reporting_to` tinyint NOT NULL,
  `business_entity_id` tinyint NOT NULL,
  `department_id` tinyint NOT NULL,
  `division_id` tinyint NOT NULL,
  `position_id` tinyint NOT NULL,
  `employee_grade` tinyint NOT NULL,
  `title` tinyint NOT NULL,
  `contract_id` tinyint NOT NULL,
  `date_joined` tinyint NOT NULL,
  `basic_pay` tinyint NOT NULL,
  `basic_pay_start_date` tinyint NOT NULL,
  `date_commencement` tinyint NOT NULL,
  `date_termination` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `created_ts` tinyint NOT NULL,
  `is_delete` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Table structure for table `user__role`
--

CREATE TABLE `user__role` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `user_ID` int(11) NOT NULL,
  `role` varchar(12) NOT NULL COMMENT 'ADMIN, USER, SUPERVISOR',
  `is_delete` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `userID` (`user_ID`),
  KEY `is_delete` (`is_delete`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user__role`
--

INSERT INTO `user__role` VALUES (1,54,'SUPERVISOR',0),(2,164,'ADMIN',0),(3,79,'ADMIN',0),(5,1,'SUPERVISOR',1),(6,309,'USER',0),(7,304,'ADMIN',0),(9,265,'USER',0),(10,18,'ADMIN',0),(11,19,'ADMIN',0),(13,242,'USER',0),(14,271,'USER',0),(16,81,'ADMIN',0),(17,24,'SUPERVISOR',0),(18,21,'SUPERVISOR',0),(19,241,'USER',0),(20,97,'SUPERVISOR',0),(21,81,'ADMIN',1),(22,9,'ADMIN',0),(23,98,'SUPERVISOR',0),(24,159,'USER',0),(25,139,'USER',0),(26,299,'USER',0),(27,117,'USER',0),(28,269,'USER',0),(29,277,'USER',0),(30,144,'USER',0),(31,121,'USER',0),(32,150,'USER',0),(33,94,'USER',0),(34,283,'USER',0),(35,147,'USER',0),(36,120,'USER',0),(37,102,'USER',0),(38,280,'USER',0),(39,311,'USER',0),(40,87,'USER',0),(41,292,'USER',0),(42,297,'USER',0),(43,235,'USER',0),(44,303,'USER',0),(45,96,'USER',0),(46,122,'USER',0),(47,175,'USER',0),(48,274,'USER',0),(49,301,'USER',0),(50,23,'SUPERVISOR',0),(51,107,'USER',0),(52,100,'USER',0),(53,101,'USER',0),(54,177,'USER',0),(55,27,'SUPERVISOR',0),(56,114,'USER',0),(57,20,'SUPERVISOR',0),(58,110,'USER',0),(59,136,'USER',0),(60,22,'SUPERVISOR',0),(61,293,'USER',0),(62,244,'USER',0),(63,198,'USER',0),(64,281,'USER',0),(65,285,'USER',0),(66,257,'USER',0),(67,103,'USER',0),(68,286,'USER',0),(69,306,'USER',0),(70,282,'USER',0),(71,148,'USER',0),(72,216,'SUPERVISOR',0),(73,186,'USER',0),(74,298,'USER',0),(75,123,'USER',0),(76,290,'USER',0),(77,202,'USER',0),(78,307,'USER',0),(79,319,'USER',0),(80,321,'USER',0),(81,320,'USER',0),(82,91,'SUPERVISOR',0),(83,279,'USER',0),(84,278,'USER',0),(85,146,'USER',0),(86,228,'USER',0),(87,287,'USER',0),(88,119,'SUPERVISOR',0),(89,92,'USER',0),(90,288,'USER',0),(91,140,'USER',0),(92,138,'USER',0),(93,323,'SUPERVISOR',0),(94,327,'USER',0),(95,333,'USER',0),(96,326,'USER',0),(97,238,'SUPERVISOR',0),(98,302,'USER',0),(99,95,'USER',0),(100,330,'USER',0),(101,329,'USER',0),(102,354,'USER',0),(103,312,'SUPERVISOR',0),(104,191,'SUPERVISOR',0),(105,80,'USER',0),(106,322,'USER',0),(107,356,'USER',0),(108,331,'USER',0),(109,360,'USER',0),(110,357,'USER',0),(111,128,'USER',0),(112,272,'USER',0),(113,328,'USER',0),(114,273,'SUPERVISOR',0),(115,373,'USER',0),(116,227,'USER',0),(117,381,'USER',0),(118,384,'USER',0),(119,275,'USER',0),(120,386,'USER',0),(121,378,'USER',0),(122,351,'USER',0),(123,387,'USER',0),(124,395,'USER',0),(125,363,'USER',0),(126,232,'USER',0),(127,377,'USER',0),(128,370,'USER',0),(129,318,'USER',0),(130,355,'USER',0),(131,104,'USER',0),(132,324,'SUPERVISOR',0),(133,369,'USER',0),(134,368,'USER',0),(135,142,'ADMIN',0),(136,372,'USER',0),(137,168,'USER',0),(138,379,'USER',0),(139,385,'USER',0),(140,352,'USER',0),(141,207,'USER',0),(142,394,'USER',0),(143,163,'USER',0),(144,201,'USER',0),(145,237,'USER',0),(146,108,'USER',0),(147,83,'USER',0),(148,208,'SUPERVISOR',0),(149,337,'USER',0),(150,29,'USER',0),(151,406,'USER',0);

--
-- Temporary table structure for view `view__chartjobbydept`
--

/*!50001 DROP VIEW IF EXISTS `view__chartjobbydept`*/;
/*!50001 CREATE TABLE `view__chartjobbydept` (
  `departmentID` tinyint NOT NULL,
  `Overdue` tinyint NOT NULL,
  `New` tinyint NOT NULL,
  `Current` tinyint NOT NULL,
  `Submitted` tinyint NOT NULL,
  `Completed` tinyint NOT NULL,
  `department` tinyint NOT NULL,
  `branch` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__count_completed_job_by_month`
--

/*!50001 DROP VIEW IF EXISTS `view__count_completed_job_by_month`*/;
/*!50001 CREATE TABLE `view__count_completed_job_by_month` (
  `year` tinyint NOT NULL,
  `complete_1` tinyint NOT NULL,
  `complete_2` tinyint NOT NULL,
  `complete_3` tinyint NOT NULL,
  `complete_4` tinyint NOT NULL,
  `complete_5` tinyint NOT NULL,
  `complete_6` tinyint NOT NULL,
  `complete_7` tinyint NOT NULL,
  `complete_8` tinyint NOT NULL,
  `complete_9` tinyint NOT NULL,
  `complete_10` tinyint NOT NULL,
  `complete_11` tinyint NOT NULL,
  `complete_12` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__count_job`
--

/*!50001 DROP VIEW IF EXISTS `view__count_job`*/;
/*!50001 CREATE TABLE `view__count_job` (
  `departmentID` tinyint NOT NULL,
  `name` tinyint NOT NULL,
  `branch` tinyint NOT NULL,
  `Overdue` tinyint NOT NULL,
  `New` tinyint NOT NULL,
  `Current` tinyint NOT NULL,
  `Submitted` tinyint NOT NULL,
  `Completed` tinyint NOT NULL,
  `Completed_in_time` tinyint NOT NULL,
  `Completed_overdue` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__count_job_by_user`
--

/*!50001 DROP VIEW IF EXISTS `view__count_job_by_user`*/;
/*!50001 CREATE TABLE `view__count_job_by_user` (
  `staff_id` tinyint NOT NULL,
  `department_id` tinyint NOT NULL,
  `Pending` tinyint NOT NULL,
  `Overdue` tinyint NOT NULL,
  `New` tinyint NOT NULL,
  `Current` tinyint NOT NULL,
  `Submitted` tinyint NOT NULL,
  `Completed` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__count_new_job_by_month`
--

/*!50001 DROP VIEW IF EXISTS `view__count_new_job_by_month`*/;
/*!50001 CREATE TABLE `view__count_new_job_by_month` (
  `year` tinyint NOT NULL,
  `new_1` tinyint NOT NULL,
  `new_2` tinyint NOT NULL,
  `new_3` tinyint NOT NULL,
  `new_4` tinyint NOT NULL,
  `new_5` tinyint NOT NULL,
  `new_6` tinyint NOT NULL,
  `new_7` tinyint NOT NULL,
  `new_8` tinyint NOT NULL,
  `new_9` tinyint NOT NULL,
  `new_10` tinyint NOT NULL,
  `new_11` tinyint NOT NULL,
  `new_12` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__job`
--

/*!50001 DROP VIEW IF EXISTS `view__job`*/;
/*!50001 CREATE TABLE `view__job` (
  `ID` tinyint NOT NULL,
  `customerID` tinyint NOT NULL,
  `departmentID` tinyint NOT NULL,
  `deadline` tinyint NOT NULL,
  `description` tinyint NOT NULL,
  `is_pending` tinyint NOT NULL,
  `customerName` tinyint NOT NULL,
  `departmentName` tinyint NOT NULL,
  `branchName` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__job_sequence`
--

/*!50001 DROP VIEW IF EXISTS `view__job_sequence`*/;
/*!50001 CREATE TABLE `view__job_sequence` (
  `id` tinyint NOT NULL,
  `customerID` tinyint NOT NULL,
  `parentGroupID` tinyint NOT NULL,
  `departmentID` tinyint NOT NULL,
  `department` tinyint NOT NULL,
  `job_sequence` tinyint NOT NULL,
  `jobID` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Temporary table structure for view `view__search`
--

/*!50001 DROP VIEW IF EXISTS `view__search`*/;
/*!50001 CREATE TABLE `view__search` (
  `jobID` tinyint NOT NULL,
  `departmentID` tinyint NOT NULL,
  `department` tinyint NOT NULL,
  `customerName` tinyint NOT NULL,
  `status` tinyint NOT NULL,
  `description` tinyint NOT NULL,
  `createdTS` tinyint NOT NULL,
  `deadline` tinyint NOT NULL,
  `crawl_text` tinyint NOT NULL
) ENGINE=MyISAM */;

--
-- Final view structure for view `_ref__job`
--

/*!50001 DROP TABLE IF EXISTS `_ref__job`*/;
/*!50001 DROP VIEW IF EXISTS `_ref__job`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `_ref__job` AS select `spserp_master`.`_ref__job`.`id` AS `id`,`spserp_master`.`_ref__job`.`service_id` AS `service_id`,`spserp_master`.`_ref__job`.`job` AS `job` from `spserp_master`.`_ref__job` */;

--
-- Final view structure for view `_ref__services`
--

/*!50001 DROP TABLE IF EXISTS `_ref__services`*/;
/*!50001 DROP VIEW IF EXISTS `_ref__services`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `_ref__services` AS select `spserp_master`.`_ref__services`.`id` AS `id`,`spserp_master`.`_ref__services`.`service` AS `service` from `spserp_master`.`_ref__services` */;

--
-- Final view structure for view `company__branch`
--

/*!50001 DROP TABLE IF EXISTS `company__branch`*/;
/*!50001 DROP VIEW IF EXISTS `company__branch`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `company__branch` AS select `spserp_master`.`company__branch`.`id` AS `id`,`spserp_master`.`company__branch`.`company_id` AS `company_id`,`spserp_master`.`company__branch`.`name` AS `name`,`spserp_master`.`company__branch`.`address` AS `address`,`spserp_master`.`company__branch`.`postcode` AS `postcode`,`spserp_master`.`company__branch`.`city` AS `city`,`spserp_master`.`company__branch`.`state_id` AS `state_id`,`spserp_master`.`company__branch`.`country_id` AS `country_id`,`spserp_master`.`company__branch`.`latitude` AS `latitude`,`spserp_master`.`company__branch`.`longitude` AS `longitude`,`spserp_master`.`company__branch`.`phone` AS `phone`,`spserp_master`.`company__branch`.`fax` AS `fax`,`spserp_master`.`company__branch`.`email` AS `email`,`spserp_master`.`company__branch`.`status` AS `status`,`spserp_master`.`company__branch`.`created_by` AS `created_by`,`spserp_master`.`company__branch`.`created_ts` AS `created_ts`,`spserp_master`.`company__branch`.`updated_by` AS `updated_by`,`spserp_master`.`company__branch`.`updated_ts` AS `updated_ts`,`spserp_master`.`company__branch`.`is_delete` AS `is_delete`,`spserp_master`.`company__branch`.`deleted_by` AS `deleted_by`,`spserp_master`.`company__branch`.`deleted_ts` AS `deleted_ts` from `spserp_master`.`company__branch` */;

--
-- Final view structure for view `company__department`
--

/*!50001 DROP TABLE IF EXISTS `company__department`*/;
/*!50001 DROP VIEW IF EXISTS `company__department`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `company__department` AS select `spserp_master`.`company__department`.`id` AS `id`,`spserp_master`.`company__department`.`branch_id` AS `branch_id`,`spserp_master`.`company__department`.`division_id` AS `division_id`,`spserp_master`.`company__department`.`name` AS `name`,`spserp_master`.`company__department`.`description` AS `description`,`spserp_master`.`company__department`.`hod_id` AS `hod_id`,`spserp_master`.`company__department`.`status` AS `status`,`spserp_master`.`company__department`.`created_by` AS `created_by`,`spserp_master`.`company__department`.`created_ts` AS `created_ts`,`spserp_master`.`company__department`.`updated_by` AS `updated_by`,`spserp_master`.`company__department`.`updated_ts` AS `updated_ts`,`spserp_master`.`company__department`.`is_delete` AS `is_delete`,`spserp_master`.`company__department`.`deleted_by` AS `deleted_by`,`spserp_master`.`company__department`.`deleted_ts` AS `deleted_ts` from `spserp_master`.`company__department` */;

--
-- Final view structure for view `company__position`
--

/*!50001 DROP TABLE IF EXISTS `company__position`*/;
/*!50001 DROP VIEW IF EXISTS `company__position`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `company__position` AS select `spserp_master`.`company__position`.`id` AS `id`,`spserp_master`.`company__position`.`parent_id` AS `parent_id`,`spserp_master`.`company__position`.`position` AS `position`,`spserp_master`.`company__position`.`description` AS `description`,`spserp_master`.`company__position`.`status` AS `status`,`spserp_master`.`company__position`.`created_by` AS `created_by`,`spserp_master`.`company__position`.`created_ts` AS `created_ts`,`spserp_master`.`company__position`.`updated_by` AS `updated_by`,`spserp_master`.`company__position`.`updated_ts` AS `updated_ts`,`spserp_master`.`company__position`.`is_delete` AS `is_delete`,`spserp_master`.`company__position`.`deleted_by` AS `deleted_by`,`spserp_master`.`company__position`.`deleted_ts` AS `deleted_ts` from `spserp_master`.`company__position` */;

--
-- Final view structure for view `customer`
--

/*!50001 DROP TABLE IF EXISTS `customer`*/;
/*!50001 DROP VIEW IF EXISTS `customer`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `customer` AS select `spserp_master`.`customer`.`id` AS `id`,`spserp_master`.`customer`.`type_id` AS `type_id`,`spserp_master`.`customer`.`name` AS `name`,`spserp_master`.`customer`.`profile` AS `profile`,`spserp_master`.`customer`.`picture` AS `picture`,`spserp_master`.`customer`.`roc_no` AS `roc_no`,`spserp_master`.`customer`.`address1` AS `address1`,`spserp_master`.`customer`.`address2` AS `address2`,`spserp_master`.`customer`.`postcode` AS `postcode`,`spserp_master`.`customer`.`city` AS `city`,`spserp_master`.`customer`.`state_id` AS `state_id`,`spserp_master`.`customer`.`country_id` AS `country_id`,`spserp_master`.`customer`.`phone` AS `phone`,`spserp_master`.`customer`.`phone_other` AS `phone_other`,`spserp_master`.`customer`.`fax` AS `fax`,`spserp_master`.`customer`.`email` AS `email`,`spserp_master`.`customer`.`website` AS `website`,`spserp_master`.`customer`.`master` AS `master`,`spserp_master`.`customer`.`master_id` AS `master_id`,`spserp_master`.`customer`.`grade_id` AS `grade_id`,`spserp_master`.`customer`.`year_end_id` AS `year_end_id`,`spserp_master`.`customer`.`status_id` AS `status_id`,`spserp_master`.`customer`.`incorporate_date` AS `incorporate_date`,`spserp_master`.`customer`.`appoint_date` AS `appoint_date`,`spserp_master`.`customer`.`description` AS `description`,`spserp_master`.`customer`.`created_by` AS `created_by`,`spserp_master`.`customer`.`created_ts` AS `created_ts`,`spserp_master`.`customer`.`updated_by` AS `updated_by`,`spserp_master`.`customer`.`updated_ts` AS `updated_ts`,`spserp_master`.`customer`.`is_delete` AS `is_delete`,`spserp_master`.`customer`.`deleted_by` AS `deleted_by`,`spserp_master`.`customer`.`deleted_ts` AS `deleted_ts` from `spserp_master`.`customer` */;

--
-- Final view structure for view `user`
--

/*!50001 DROP TABLE IF EXISTS `user`*/;
/*!50001 DROP VIEW IF EXISTS `user`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user` AS select `spserp_master`.`user`.`id` AS `id`,`spserp_master`.`user`.`staff_id` AS `staff_id`,`spserp_master`.`user`.`ic_no` AS `ic_no`,`spserp_master`.`user`.`name` AS `name`,`spserp_master`.`user`.`title_id` AS `title_id`,`spserp_master`.`user`.`gender_id` AS `gender_id`,`spserp_master`.`user`.`email` AS `email`,`spserp_master`.`user`.`email_secondary` AS `email_secondary`,`spserp_master`.`user`.`profile` AS `profile`,`spserp_master`.`user`.`marital_status` AS `marital_status`,`spserp_master`.`user`.`married_date` AS `married_date`,`spserp_master`.`user`.`profile_picture_id` AS `profile_picture_id`,`spserp_master`.`user`.`phone` AS `phone`,`spserp_master`.`user`.`address` AS `address`,`spserp_master`.`user`.`postcode` AS `postcode`,`spserp_master`.`user`.`city` AS `city`,`spserp_master`.`user`.`state_id` AS `state_id`,`spserp_master`.`user`.`country_id` AS `country_id`,`spserp_master`.`user`.`citizen_id` AS `citizen_id`,`spserp_master`.`user`.`race_id` AS `race_id`,`spserp_master`.`user`.`religion_id` AS `religion_id`,`spserp_master`.`user`.`birth_date` AS `birth_date`,`spserp_master`.`user`.`birth_place` AS `birth_place`,`spserp_master`.`user`.`residential_id` AS `residential_id`,`spserp_master`.`user`.`status` AS `status`,`spserp_master`.`user`.`hobby` AS `hobby`,`spserp_master`.`user`.`created_by` AS `created_by`,`spserp_master`.`user`.`created_ts` AS `created_ts`,`spserp_master`.`user`.`updated_by` AS `updated_by`,`spserp_master`.`user`.`updated_ts` AS `updated_ts`,`spserp_master`.`user`.`is_delete` AS `is_delete`,`spserp_master`.`user`.`deleted_by` AS `deleted_by`,`spserp_master`.`user`.`deleted_ts` AS `deleted_ts`,`spserp_master`.`user`.`religion` AS `religion` from `spserp_master`.`user` */;

--
-- Final view structure for view `user__employment_detail`
--

/*!50001 DROP TABLE IF EXISTS `user__employment_detail`*/;
/*!50001 DROP VIEW IF EXISTS `user__employment_detail`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `user__employment_detail` AS select `user__employment_detail`.`id` AS `id`,`user__employment_detail`.`user_id` AS `user_id`,`user__employment_detail`.`staff_id` AS `staff_id`,`user__employment_detail`.`name` AS `name`,`user__employment_detail`.`profiling_id` AS `profiling_id`,`user__employment_detail`.`company_id` AS `company_id`,`user__employment_detail`.`reporting_to` AS `reporting_to`,`user__employment_detail`.`business_entity_id` AS `business_entity_id`,`user__employment_detail`.`department_id` AS `department_id`,`user__employment_detail`.`division_id` AS `division_id`,`user__employment_detail`.`position_id` AS `position_id`,`user__employment_detail`.`employee_grade` AS `employee_grade`,`user__employment_detail`.`title` AS `title`,`user__employment_detail`.`contract_id` AS `contract_id`,`user__employment_detail`.`date_joined` AS `date_joined`,`user__employment_detail`.`basic_pay` AS `basic_pay`,`user__employment_detail`.`basic_pay_start_date` AS `basic_pay_start_date`,`user__employment_detail`.`date_commencement` AS `date_commencement`,`user__employment_detail`.`date_termination` AS `date_termination`,`user__employment_detail`.`status` AS `status`,`user__employment_detail`.`created_ts` AS `created_ts`,`user__employment_detail`.`is_delete` AS `is_delete` from `spserp_master`.`user__employment_detail` */;

--
-- Final view structure for view `view__chartjobbydept`
--

/*!50001 DROP TABLE IF EXISTS `view__chartjobbydept`*/;
/*!50001 DROP VIEW IF EXISTS `view__chartjobbydept`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__chartjobbydept` AS select `a`.`departmentID` AS `departmentID`,`a`.`Overdue` AS `Overdue`,`a`.`New` AS `New`,`a`.`Current` AS `Current`,`a`.`Submitted` AS `Submitted`,`a`.`Completed` AS `Completed`,`b`.`name` AS `department`,`c`.`name` AS `branch` from ((`mgsdb_master`.`view__count_job` `a` join `mgsdb_master`.`company__department` `b` on((`b`.`id` = `a`.`departmentID`))) join `mgsdb_master`.`company__branch` `c` on((`c`.`id` = `b`.`branch_id`))) where ((not((`b`.`name` like '%Audit%'))) and (not((`b`.`name` like '%Accounting%')))) union select `a`.`departmentID` AS `departmentID`,sum(`a`.`Overdue`) AS `Overdue`,sum(`a`.`New`) AS `New`,sum(`a`.`Current`) AS `Current`,sum(`a`.`Submitted`) AS `Submitted`,sum(`a`.`Completed`) AS `Completed`,`b`.`name` AS `department`,`c`.`name` AS `branch` from ((`mgsdb_master`.`view__count_job` `a` join `mgsdb_master`.`company__department` `b` on((`b`.`id` = `a`.`departmentID`))) join `mgsdb_master`.`company__branch` `c` on((`c`.`id` = `b`.`branch_id`))) where (`b`.`name` like '%Audit%') union select `a`.`departmentID` AS `departmentID`,sum(`a`.`Overdue`) AS `Overdue`,sum(`a`.`New`) AS `New`,sum(`a`.`Current`) AS `Current`,sum(`a`.`Submitted`) AS `Submitted`,sum(`a`.`Completed`) AS `Completed`,`b`.`name` AS `department`,`c`.`name` AS `branch` from ((`mgsdb_master`.`view__count_job` `a` join `mgsdb_master`.`company__department` `b` on((`b`.`id` = `a`.`departmentID`))) join `mgsdb_master`.`company__branch` `c` on((`c`.`id` = `b`.`branch_id`))) where (`b`.`name` like '%Accounting%') */;

--
-- Final view structure for view `view__count_completed_job_by_month`
--

/*!50001 DROP TABLE IF EXISTS `view__count_completed_job_by_month`*/;
/*!50001 DROP VIEW IF EXISTS `view__count_completed_job_by_month`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__count_completed_job_by_month` AS select distinct year(`a`.`completedDate`) AS `year`,sum(if((month(`a`.`completedDate`) = 1),1,0)) AS `complete_1`,sum(if((month(`a`.`completedDate`) = 2),1,0)) AS `complete_2`,sum(if((month(`a`.`completedDate`) = 3),1,0)) AS `complete_3`,sum(if((month(`a`.`completedDate`) = 4),1,0)) AS `complete_4`,sum(if((month(`a`.`completedDate`) = 5),1,0)) AS `complete_5`,sum(if((month(`a`.`completedDate`) = 6),1,0)) AS `complete_6`,sum(if((month(`a`.`completedDate`) = 7),1,0)) AS `complete_7`,sum(if((month(`a`.`completedDate`) = 8),1,0)) AS `complete_8`,sum(if((month(`a`.`completedDate`) = 9),1,0)) AS `complete_9`,sum(if((month(`a`.`completedDate`) = 10),1,0)) AS `complete_10`,sum(if((month(`a`.`completedDate`) = 11),1,0)) AS `complete_11`,sum(if((month(`a`.`completedDate`) = 12),1,0)) AS `complete_12` from `job` `a` where ((`a`.`is_delete` = 0) and (`a`.`status` = 3)) group by year(`a`.`completedDate`) */;

--
-- Final view structure for view `view__count_job`
--

/*!50001 DROP TABLE IF EXISTS `view__count_job`*/;
/*!50001 DROP VIEW IF EXISTS `view__count_job`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__count_job` AS select `b`.`id` AS `departmentID`,`b`.`name` AS `name`,`c`.`name` AS `branch`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` in (0,1,2)) and (`mgsdb_master`.`job`.`deadline` <> 0) and (`mgsdb_master`.`job`.`deadline` < curdate()) and (`mgsdb_master`.`job`.`is_delete` = 0) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`))) AS `Overdue`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` = 0) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) AS `New`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` = 1) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) AS `Current`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` = 2) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) AS `Submitted`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` = 3) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) AS `Completed`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` = 3) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`) and (`mgsdb_master`.`job`.`is_delete` = 0) and (`mgsdb_master`.`job`.`completedDate` <= `mgsdb_master`.`job`.`deadline`))) AS `Completed_in_time`,(select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`mgsdb_master`.`job`.`status` = 3) and (`mgsdb_master`.`job`.`departmentID` = `a`.`departmentID`) and (`mgsdb_master`.`job`.`is_delete` = 0) and (`mgsdb_master`.`job`.`completedDate` > `mgsdb_master`.`job`.`deadline`))) AS `Completed_overdue` from ((`mgsdb_master`.`company__department` `b` left join `mgsdb_master`.`job` `a` on(((`b`.`id` = `a`.`departmentID`) and (`a`.`is_delete` = 0)))) left join `mgsdb_master`.`company__branch` `c` on((`b`.`branch_id` = `c`.`id`))) group by `b`.`id` */;

--
-- Final view structure for view `view__count_job_by_user`
--

/*!50001 DROP TABLE IF EXISTS `view__count_job_by_user`*/;
/*!50001 DROP VIEW IF EXISTS `view__count_job_by_user`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__count_job_by_user` AS select `a`.`staff_id` AS `staff_id`,`d`.`department_id` AS `department_id`,(select count(`b`.`id`) from (`mgsdb_master`.`job__pic` `b` left join `mgsdb_master`.`job` `c` on((`c`.`ID` = `b`.`job_id`))) where ((`c`.`status` in (1,2)) and (`b`.`staff_id` = `a`.`staff_id`) and (`b`.`is_delete` = 0) and (`c`.`is_delete` = 0) and (`c`.`is_pending` = 1))) AS `Pending`,(select count(`b`.`id`) from (`mgsdb_master`.`job__pic` `b` left join `mgsdb_master`.`job` `c` on((`c`.`ID` = `b`.`job_id`))) where ((`c`.`status` in (0,1)) and (`c`.`deadline` < curdate()) and (`c`.`deadline` <> '0000-00-00') and (`b`.`staff_id` = `a`.`staff_id`) and (`b`.`is_delete` = 0) and (`c`.`is_delete` = 0) and (`c`.`is_pending` = 0))) AS `Overdue`,(select count(`b`.`id`) from (`mgsdb_master`.`job__pic` `b` left join `mgsdb_master`.`job` `c` on((`c`.`ID` = `b`.`job_id`))) where ((`c`.`status` = 0) and (`b`.`staff_id` = `a`.`staff_id`) and (`b`.`is_delete` = 0) and (`c`.`is_delete` = 0))) AS `New`,(select count(`b`.`id`) from (`mgsdb_master`.`job__pic` `b` left join `mgsdb_master`.`job` `c` on((`c`.`ID` = `b`.`job_id`))) where ((`c`.`status` = 1) and (`c`.`deadline` <> '0000-00-00') and (`b`.`staff_id` = `a`.`staff_id`) and (`b`.`is_delete` = 0) and (`c`.`is_delete` = 0))) AS `Current`,(select count(`b`.`id`) from (`mgsdb_master`.`job__pic` `b` left join `mgsdb_master`.`job` `c` on((`c`.`ID` = `b`.`job_id`))) where ((`c`.`status` = 2) and (`b`.`staff_id` = `a`.`staff_id`) and (`b`.`is_delete` = 0) and (`c`.`is_delete` = 0))) AS `Submitted`,(select count(`b`.`id`) from (`mgsdb_master`.`job__pic` `b` left join `mgsdb_master`.`job` `c` on((`c`.`ID` = `b`.`job_id`))) where ((`c`.`status` = 3) and (`b`.`staff_id` = `a`.`staff_id`) and (`b`.`is_delete` = 0) and (`c`.`is_delete` = 0))) AS `Completed` from (`mgsdb_master`.`job__pic` `a` left join `mgsdb_master`.`user__employment_detail` `d` on((`d`.`user_id` = `a`.`staff_id`))) group by `a`.`staff_id` */;

--
-- Final view structure for view `view__count_new_job_by_month`
--

/*!50001 DROP TABLE IF EXISTS `view__count_new_job_by_month`*/;
/*!50001 DROP VIEW IF EXISTS `view__count_new_job_by_month`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__count_new_job_by_month` AS select distinct year(`a`.`createdTS`) AS `year`,sum(if((month(`a`.`createdTS`) = 1),1,0)) AS `new_1`,sum(if((month(`a`.`createdTS`) = 2),1,0)) AS `new_2`,sum(if((month(`a`.`createdTS`) = 3),1,0)) AS `new_3`,sum(if((month(`a`.`createdTS`) = 4),1,0)) AS `new_4`,sum(if((month(`a`.`createdTS`) = 5),1,0)) AS `new_5`,sum(if((month(`a`.`createdTS`) = 6),1,0)) AS `new_6`,sum(if((month(`a`.`createdTS`) = 7),1,0)) AS `new_7`,sum(if((month(`a`.`createdTS`) = 8),1,0)) AS `new_8`,sum(if((month(`a`.`createdTS`) = 9),1,0)) AS `new_9`,sum(if((month(`a`.`createdTS`) = 10),1,0)) AS `new_10`,sum(if((month(`a`.`createdTS`) = 11),1,0)) AS `new_11`,sum(if((month(`a`.`createdTS`) = 12),1,0)) AS `new_12` from `job` `a` where (`a`.`is_delete` = 0) group by year(`a`.`createdTS`) */;

--
-- Final view structure for view `view__job`
--

/*!50001 DROP TABLE IF EXISTS `view__job`*/;
/*!50001 DROP VIEW IF EXISTS `view__job`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__job` AS select `a`.`ID` AS `ID`,`a`.`customerID` AS `customerID`,`a`.`departmentID` AS `departmentID`,`a`.`deadline` AS `deadline`,`a`.`description` AS `description`,`a`.`is_pending` AS `is_pending`,if((`a`.`is_internal` = 1),`d`.`name`,`b`.`name`) AS `customerName`,`c`.`name` AS `departmentName`,`e`.`name` AS `branchName` from ((((`mgsdb_master`.`job` `a` left join `mgsdb_master`.`customer` `b` on((`a`.`customerID` = `b`.`id`))) left join `mgsdb_master`.`company__department` `c` on((`a`.`departmentID` = `c`.`id`))) left join `mgsdb_master`.`company__department` `d` on((`a`.`customerID` = `d`.`id`))) left join `mgsdb_master`.`company__branch` `e` on((`e`.`id` = `c`.`branch_id`))) where (`a`.`is_delete` = 0) order by `a`.`createdTS` desc,`a`.`job_sequence` */;

--
-- Final view structure for view `view__job_sequence`
--

/*!50001 DROP TABLE IF EXISTS `view__job_sequence`*/;
/*!50001 DROP VIEW IF EXISTS `view__job_sequence`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__job_sequence` AS select `a`.`ID` AS `id`,`a`.`customerID` AS `customerID`,`a`.`parentGroupID` AS `parentGroupID`,if(((select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`a`.`ID` = `mgsdb_master`.`job`.`parentGroupID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) = 0),`a`.`departmentID`,group_concat(`a`.`departmentID`,',',(select group_concat(`b`.`departmentID` separator ',') from `mgsdb_master`.`job` `b` where ((`a`.`ID` = `b`.`parentGroupID`) and (`b`.`is_delete` = 0)) order by `b`.`job_sequence`) separator ',')) AS `departmentID`,if(((select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`a`.`ID` = `mgsdb_master`.`job`.`parentGroupID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) = 0),`dept`.`name`,group_concat(`dept`.`name`,',',(select group_concat(`b2`.`name` separator ',') from (`mgsdb_master`.`job` `b` left join `mgsdb_master`.`company__department` `b2` on((`b`.`departmentID` = `b2`.`id`))) where ((`a`.`ID` = `b`.`parentGroupID`) and (`b`.`is_delete` = 0)) order by `b`.`job_sequence`) separator ',')) AS `department`,if(((select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`a`.`ID` = `mgsdb_master`.`job`.`parentGroupID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) = 0),`a`.`job_sequence`,group_concat(`a`.`job_sequence`,',',(select group_concat(`c`.`job_sequence` separator ',') from `mgsdb_master`.`job` `c` where ((`a`.`ID` = `c`.`parentGroupID`) and (`c`.`is_delete` = 0)) group by `a`.`parentGroupID` order by `a`.`job_sequence`) separator ',')) AS `job_sequence`,if(((select count(`mgsdb_master`.`job`.`ID`) from `mgsdb_master`.`job` where ((`a`.`ID` = `mgsdb_master`.`job`.`parentGroupID`) and (`mgsdb_master`.`job`.`is_delete` = 0))) = 0),`a`.`ID`,group_concat(`a`.`ID`,',',(select group_concat(`d`.`ID` separator ',') from `mgsdb_master`.`job` `d` where ((`a`.`ID` = `d`.`parentGroupID`) and (`d`.`is_delete` = 0)) group by `a`.`parentGroupID` order by `a`.`job_sequence`) separator ',')) AS `jobID` from (`mgsdb_master`.`job` `a` left join `mgsdb_master`.`company__department` `dept` on((`a`.`departmentID` = `dept`.`id`))) where ((`a`.`parentGroupID` = 0) and (`a`.`is_delete` = 0)) group by `a`.`ID` order by `a`.`ID`,`a`.`customerID`,`a`.`job_sequence` */;

--
-- Final view structure for view `view__search`
--

/*!50001 DROP TABLE IF EXISTS `view__search`*/;
/*!50001 DROP VIEW IF EXISTS `view__search`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `view__search` AS select `a`.`ID` AS `jobID`,`a`.`departmentID` AS `departmentID`,`dept`.`name` AS `department`,if((`a`.`is_internal` = 1),`bb`.`name`,`b`.`name`) AS `customerName`,if((`a`.`status` = 0),'New',if((`a`.`status` = 1),'Acknowledge',if((`a`.`status` = 2),'Submitted','Completed'))) AS `status`,`a`.`description` AS `description`,`a`.`createdTS` AS `createdTS`,`a`.`deadline` AS `deadline`,concat(`a`.`description`,' for ',if((`a`.`is_internal` = 1),`bb`.`name`,`b`.`name`),' ',ifnull(`c`.`summary`,''),' PIC:',ifnull(`f`.`name`,'[Unassigned]')) AS `crawl_text` from (((((((`mgsdb_master`.`job` `a` left join `mgsdb_master`.`customer` `b` on((`a`.`customerID` = `b`.`id`))) left join `mgsdb_master`.`company__department` `bb` on((`a`.`customerID` = `bb`.`id`))) left join `mgsdb_master`.`job__task_daily_summary` `c` on((`a`.`ID` = `c`.`jobID`))) left join `mgsdb_master`.`user` `d` on((`d`.`id` = `c`.`userID`))) left join `mgsdb_master`.`job__pic` `e` on(((`e`.`job_id` = `a`.`ID`) and (`e`.`is_delete` = 0)))) left join `mgsdb_master`.`user` `f` on((`f`.`id` = `e`.`staff_id`))) left join `mgsdb_master`.`company__department` `dept` on((`a`.`departmentID` = `dept`.`id`))) */;


