INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11589, 20019, '', '11589', 'E', 1, '<p>\n	Team Meeting 20 Sep 2022</p>\n', '2022-09-20 08:41:43', '', 'JOHN', 56, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '30005,30018,30012', 0, 0, '', '', 69, '2022-09-20 08:41:43', 1, '2022-09-27 05:00:02'),
(11590, 20067, '', '11590', 'I', 1, '<p>\n	this one the Dummy item DIA002 is having VAT but the amount shows without vat can u pls check</p>\n<p>\n	&nbsp;</p>\n', '2022-09-20 10:08:13', 'WhatsApp Image 2022-09-20 at 9.17.06 AM.jpeg', 'JOHN', 200, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-20 10:08:13', 1, '2022-09-27 05:00:02'),
(11591, 20061, '', '11591', 'E', 1, '<p>\n	Al Barakka Dates Change date from 20/09/2022 to 27/09/22</p>\n', '2022-09-20 10:49:05', '', 'JOHN', 182, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-20 10:49:05', 1, '2022-09-27 05:00:02'),
(11592, 20074, '', '11592', 'E', 1, '<p>\n	Rethink - Pls apply Annual Leave for JAN GUSTAV ALBRECHT KUBLER - AMA Advertising, 7,8,9 September, AM00016</p>\n<p>\n	&nbsp;</p>\n', '2022-09-20 12:14:01', '', 'JOHN', 221, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-20 12:14:01', 1, '2022-09-27 05:00:02'),
(11593, 20065, '', '11593', 'E', 1, '<p>\n	Magnum -I have transferred employee M10021 to MTC-HFZA from MTC-JAFZA branch, : I&rsquo;m not able to get any details of his balance Annual leave now</p>\n<p>\n	&nbsp;</p>\n', '2022-09-20 12:48:09', '', 'JOHN', 194, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-20 12:48:09', 1, '2022-09-27 05:00:02'),
(11603, 20001, '', '11603', 'E', 1, '<p>\n	Billing date and Delivery date Should be 03/08/22</p>\n<p>\n	(See attached)</p>\n', '2022-09-26 10:41:42', 'WhatsApp Image 2022-09-26 at 10.38.06 AM.jpeg', 'JOHN', 2, 12, '2022-11-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 10:41:42', 1, '2022-11-06 06:00:02'),
(11595, 20048, '', '11595', 'E', 1, '<p>\n	Dear Team,</p>\n<p>\n	&nbsp;</p>\n<p>\n	The previous ticket not completely closed, it have some more issues pending for which the screen shots attached. The figures is mismatch from Transaction Details to Inventory List to Inventory Stock List</p>\n<p>\n	and inventory stock list shows negative figure for the&nbsp;ENV-HCV3F-30R-17 (in Excel) but it shows zero in the template. Please update the same at the earliest.</p>\n<p>\n	Regards</p>\n<p>\n	Sarath</p>\n', '2022-09-21 13:23:50', 'Transaction Details_!.png,Inventory_1.png,Inventory Stock Error_1.png', 'Shabil -', 142, 12, '2023-03-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2022-09-21 13:23:50', 69, '2023-03-24 08:12:34'),
(11596, 20071, '', '11596', 'I', 1, '<p>\n	Attendnce Report File - loading problem</p>\n', '2022-09-21 16:29:03', '', 'JOHN', 212, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-21 16:29:03', 1, '2022-10-28 05:00:04'),
(11633, 20061, '', '11633', 'E', 1, '<p>\n	E-Sell &ndash; Al Abeer (46) - changed from 05/10/22 to 11/10/22- John 05/10/22</p>\n<p>\n	&nbsp;</p>\n', '2022-10-05 12:26:49', '', 'JOHN', 182, 12, '2022-10-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-05 12:26:49', 1, '2022-10-11 05:00:02'),
(11597, 20061, '', '11597', 'E', 1, '<p>\n	Cjhnage Al Abeer (DB 45)&nbsp; from 22/09/22 to 30/09/22</p>\n', '2022-09-22 09:35:12', '', 'JOHN', 182, 12, '2022-09-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-22 09:35:12', 1, '2022-09-29 05:00:01'),
(11691, 20118, '', '11691', 'E', 1, '<p>\n	Legend Support</p>\n', '2022-11-01 07:39:45', '', 'JOHN', 353, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-11-01 07:39:45', 1, '2022-12-02 06:00:06'),
(11598, 20065, '', '11598', 'E', 1, '<p>\n	Magnum &ndash; Leave applying after 6 months from DOJ for leaves except personal leave</p>\n<p>\n	Magnum &ndash; Payslip heading based on branch</p>\n<p>\n	Magnum &ndash; Performance review appraisal form heading based on branch</p>\n<p>\n	&nbsp;</p>\n', '2022-09-23 11:30:12', '', 'JOHN', 194, 12, '2022-11-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-23 11:30:12', 1, '2022-11-28 06:00:02'),
(11599, 20018, '', '11599', 'E', 1, '<p>\n	Issues as described on document attached</p>\n', '2022-09-23 16:47:52', 'BLUESKY SOFTWARE ADDITIONAL REQUIREMENTS part 1, 2, 3 &amp; 4.pdf', 'JOHN', 53, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-23 16:47:52', 69, '2023-03-27 12:25:09'),
(11602, 20061, '', '11602', 'E', 1, '<p>\n	E Sell New creation</p>\n<p>\n	NI2028</p>\n', '2022-09-26 10:14:35', '', 'JOHN', 182, 12, '2022-10-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 10:14:35', 1, '2022-10-03 05:00:03'),
(11604, 20065, '', '11604', 'E', 1, '<p>\n	Can you please divert the below leave application to Thomas Koshy (WM10049) for approval as the reporting of Wasi is changed now?</p>\n<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\" width=\"1440\">\n	<tbody>\n		<tr>\n			<td>\n				<p>\n					1</p>\n			</td>\n			<td>\n				<p>\n					W80012</p>\n			</td>\n			<td>\n				<p>\n					WASI AHMED AMEERULLAH</p>\n			</td>\n			<td>\n				<p>\n					15/09/2022</p>\n			</td>\n			<td>\n				<p>\n					Medical leave</p>\n			</td>\n			<td>\n				<p>\n					14/07/2022</p>\n			</td>\n			<td>\n				<p>\n					15/07/2022</p>\n			</td>\n			<td>\n				<p>\n					2.0</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-09-26 12:39:26', '', 'JOHN', 194, 12, '2022-10-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 12:39:26', 1, '2022-10-03 05:00:03'),
(11605, 20138, '', '11605', 'E', 1, '<p>\n	ALL Cargo FXE- Vimal 110501 salary &ndash; basic changed from01/09/2023, make it 01/09/2022. They will roll back and calculate again</p>\n', '2022-09-26 12:40:33', '', 'JOHN', 413, 12, '2022-10-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 12:40:33', 1, '2022-10-03 05:00:03'),
(11606, 20122, '', '11606', 'E', 1, '<p>\n	Overtime/ Attendence edit Doubt clearing with Sangeetha and BPI</p>\n', '2022-09-26 12:43:42', '', 'JOHN', 365, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 12:43:42', 1, '2022-10-28 05:00:04'),
(11607, 20098, '', '11607', 'I', 1, '<p>\n	Sales report HTML to Excel not matching due to &quot;/&quot; prsent in customer name</p>\n', '2022-09-26 14:48:42', '', 'JOHN', 293, 12, '2022-10-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 14:48:42', 1, '2022-10-03 05:00:03'),
(11608, 20021, '', '11608', 'I', 1, '<p>\n	Dlink HR Login Error</p>\n', '2022-09-26 15:34:27', '', 'JOHN', 62, 12, '2022-10-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 15:34:27', 1, '2022-10-05 05:00:02'),
(11609, 20019, '', '11609', 'E', 1, '<p>\n	Simple POS Mobile Application</p>\n', '2022-09-26 17:44:53', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 17:44:53', 69, '2023-03-27 12:25:58'),
(11610, 20019, '', '11610', 'E', 1, '<p>\n	Team Meeting 27/09/22</p>\n', '2022-09-27 08:44:51', '', 'JOHN', 56, 12, '2023-08-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-27 08:44:51', 69, '2023-08-05 07:42:13'),
(11611, 20013, '', '11611', 'E', 1, '<p>\n	hi good morning,</p>\n<p>\n	when serching for customer name, the crm gives the below mesage 10 out of the 4-5 time kindly do the needful to rectyfy the same asap&nbsp;</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 31364 characters]\" /></p>\n<p>\n	Yours truly</p>\n<p>\n	&nbsp;</p>\n<p>\n	ajith</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-09-27 10:08:49', '', 'Ajith Kumar', 37, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2022-09-27 10:08:49', 1, '2022-11-01 06:00:01'),
(11612, 20013, '', '11612', 'E', 1, '<p>\n	hi ,</p>\n<p>\n	&nbsp;</p>\n<p>\n	good morning,</p>\n<p>\n	&nbsp;</p>\n<p>\n	It was noted that, when we edits the customer detils like, address, vat number, address etc, the old data also getting changed (eg invoice of old dated also get chaged)&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	when we change a customer details, it must be update from the date of updation and the old data / details shall not be changed. Or there shall be an option where it asks &quot; whether the updation to be done to old data also or not&quot;&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	kindly check on this and get back us asap</p>\n<p>\n	&nbsp;</p>\n<p>\n	your truly</p>\n<p>\n	&nbsp;</p>\n<p>\n	ajith</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-09-27 10:12:19', '', 'Ajith Kumar', 37, 12, '2023-03-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2022-09-27 10:12:19', 69, '2023-03-24 08:12:48'),
(11613, 20146, '', '11613', 'E', 1, '<p>\n	HR Installation</p>\n', '2022-09-27 10:46:22', 'HR Master Data Template_22sep22.xlsx', 'JOHN', 437, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-27 10:46:22', 69, '2023-03-27 12:26:31'),
(11614, 20013, '', '11614', 'I', 1, '<p>\n	LLC<br />\n	customer name searching &quot;china &quot; results in data table warning</p>\n', '2022-09-27 16:17:50', '', 'JOHN', 38, 12, '2022-10-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-27 16:17:50', 1, '2022-10-04 05:00:02'),
(11615, 20067, '', '11615', 'I', 1, '<p>\n	HR Dashboard / Sales Dashboard Conflict</p>\n', '2022-09-27 16:26:03', '', 'JOHN', 200, 12, '2022-10-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-27 16:26:03', 1, '2022-10-04 05:00:02'),
(11616, 20141, '', '11616', 'I', 1, '<p>\n	User rights in 3 copies of finance</p>\n', '2022-09-28 07:53:53', '', 'JOHN', 422, 12, '2022-10-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-28 07:53:53', 1, '2022-10-12 05:00:02'),
(11617, 20106, '', '11617', 'E', 1, '<p>\n	Purchase Invoice Print VAT Error</p>\n', '2022-09-28 12:11:34', '', 'JOHN', 317, 12, '2022-10-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-28 12:11:34', 1, '2022-10-05 05:00:02'),
(11621, 20074, '', '11621', 'E', 1, '<p>\n	Need a salary advance deduction field in salary master for entering manual salary advance cutting</p>\n', '2022-09-30 11:15:07', '', 'JOHN', 221, 12, '2022-10-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-30 11:15:07', 1, '2022-10-06 05:00:02'),
(11618, 20106, '', '11618', 'E', 1, '<p>\n	1Mediyaan - Dropdown for documents upload</p>\n<p>\n	2Mediyaan - Current stock detailed report sl number</p>\n<p>\n	3Mediyaan - Design issue on grid current stock detailed report</p>\n<p>\n	4Mediyaan - List of documents needs to upload - Upload categories-In sales - a. Purchase order b. Delivery note c. Invoice</p>\n<p>\n	5Mediyaan - List of documents needs to upload - Upload categories-In purchase -a. Supplier invoice b. Packaging list c. Shipping invoice</p>\n<p>\n	6Mediyaan - File number in all reports</p>\n<p>\n	7Mediyaan - Update logo and watermark</p>\n<p>\n	8Mediyaan - Document name left alignment</p>\n<p>\n	&nbsp;</p>\n', '2022-09-29 08:10:55', '', 'JOHN', 317, 7, '2023-12-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-29 08:10:55', 583, '2023-12-14 16:18:15'),
(11619, 20061, '', '11619', 'E', 1, '<p>\n	Changes</p>\n', '2022-09-29 17:41:10', '', 'JOHN', 182, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-29 17:41:10', 69, '2023-04-12 14:40:38'),
(11620, 20019, '', '11620', 'E', 1, '<p>\n	ERP Lite</p>\n', '2022-09-29 17:42:00', '', 'JOHN', 56, 7, '2024-01-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-29 17:42:00', 583, '2024-01-02 15:53:09'),
(11622, 20065, '', '11622', 'I', 1, '<p>\n	Magnum &ndash; Loan apply error &ndash; Nishad Prabhakar - The employee should not have availed this loan facility in the past one year; Loan issue date 30/04/2021. fully repaid on 09/02/2022 ;Now System calculates one year from 09/02/2022 ; Changed to - one year is considered from last loan date; Can you check - He gets apply button &ndash; Dikson 30/09/22</p>\n<p>\n	&nbsp;</p>\n', '2022-09-30 14:39:00', '', 'JOHN', 194, 12, '2022-10-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-30 14:39:00', 1, '2022-10-06 05:00:02'),
(11623, 20061, '', '11623', 'E', 1, '<p>\n	Al ABeer (DB 45) change date from 30/09/22 to 05/10/22</p>\n', '2022-10-01 08:42:19', '', 'JOHN', 182, 12, '2022-10-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-01 08:42:19', 1, '2022-10-07 05:00:04'),
(11624, 20061, '', '11624', 'E', 1, '<p>\n	Annex&nbsp; (DB 46) changed date from 01/10/22 to 10/10/22</p>\n', '2022-10-01 09:58:58', '', 'JOHN', 182, 12, '2022-10-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-01 09:58:58', 1, '2022-10-07 05:00:04'),
(11627, 20117, '', '11627', 'E', 1, '<p>\n	G drive integration</p>\n', '2022-10-04 07:31:41', '', 'JOHN', 350, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-04 07:31:41', 69, '2023-03-27 12:26:52'),
(11625, 20061, '', '11625', 'E', 1, '<p>\n	DB No 46, ANNEX, Date change from 10/10/2022 to 01/10/2023</p>\n', '2022-10-03 10:08:08', '', 'JOHN', 182, 12, '2022-10-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-03 10:08:08', 1, '2022-10-10 05:00:01'),
(11626, 20065, '', '11626', 'E', 1, '<p>\n	ESS Loan error reported over mail dt 03/10/22</p>\n', '2022-10-03 10:10:18', '', 'JOHN', 194, 12, '2022-10-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-03 10:10:18', 1, '2022-10-09 05:00:03'),
(11628, 20061, '', '11628', 'E', 1, '<p>\n	Change Al Brakka Dates DB 2, date from 04/10/22 to 07/10/22</p>\n', '2022-10-04 08:20:05', '', 'JOHN', 182, 12, '2022-10-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-04 08:20:05', 1, '2022-10-10 05:00:01'),
(11629, 20019, '', '11629', 'E', 1, '<p>\n	Team Meeting 04/10/22</p>\n', '2022-10-04 08:48:54', '', 'JOHN', 56, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-04 08:48:54', 1, '2022-11-01 06:00:01'),
(11638, 20002, '', '11638', 'I', 1, '<p>\n	Sales invoices (Year 2014) print not working - Due to currency missing</p>\n', '2022-10-06 11:23:41', '', 'JOHN', 5, 12, '2022-10-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-06 11:23:41', 1, '2022-10-13 05:00:01');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11630, 20065, '', '11630', 'E', 1, '<p>\n	Magnum- How can I block the staff from applying leave on earlier dater after salary closure? &ndash; Dikson 04/10/22</p>\n<p>\n	Masters-&gt;HR-&gt;General-&gt;Settings</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 31304 characters]\" /></p>\n<p>\n	change the setting to &quot;Yes&quot;</p>\n<p>\n	&nbsp;</p>\n', '2022-10-04 14:37:14', '', 'JOHN', 194, 12, '2022-10-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-04 14:37:14', 1, '2022-10-10 05:00:01'),
(11631, 20147, '', '11631', 'E', 1, '<p>\n	Implementation of ERP</p>\n', '2022-10-04 14:55:27', '', 'JOHN', 440, 2, '2023-09-26', 0, '0000-00-00', '', 0, '0', '', '30006,30038,30002,30040,30037,30036,30001,30019', 0, 0, '', '', 69, '2022-10-04 14:55:27', 69, '2023-11-15 17:43:07'),
(11632, 20061, '', '11632', 'E', 1, '<p>\n	E-Sell - GW03 - Restarted using from 05/10/22 so valid for one year till 04/10/23 (One user)</p>\n<p>\n	&nbsp;</p>\n', '2022-10-05 09:33:45', 'WhatsApp Image 2022-10-05 at 9.07.23 AM.jpeg', 'JOHN', 182, 12, '2022-10-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-05 09:33:45', 1, '2022-10-11 05:00:02'),
(11634, 20067, '', '11634', 'I', 1, '<p>\n	When a file is uploaded in Quotation etc- the uploaded time&nbsp; is showing differenctly</p>\n', '2022-10-05 12:57:45', '', 'JOHN', 200, 12, '2022-10-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-05 12:57:45', 1, '2022-10-12 05:00:02'),
(11635, 20002, '', '11635', 'E', 1, '<p>\n	Norden- when editing old Activity - Date changes- this should not happen</p>\n', '2022-10-05 12:58:40', '', 'JOHN', 5, 12, '2022-10-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-05 12:58:40', 1, '2022-10-12 05:00:02'),
(11636, 20019, '', '11636', 'E', 1, '<p>\n	File upload time showing wrongly when retreiving in</p>\n<p>\n	<strong>Sales</strong></p>\n<p>\n	Lead, Quotation, Order, DN, Invoice, Credit Note, upload document</p>\n<p>\n	<strong>Service </strong></p>\n<p>\n	Lead, Quotation, Order,&nbsp; Invoice, Credit Note, upload document</p>\n<p>\n	<strong>Purchase</strong></p>\n<p>\n	Purchase Order, Purchase Invoice, Landing Cost, Upload docuemnt</p>\n<p>\n	&nbsp;</p>\n<p>\n	Documents - After Diatec</p>\n', '2022-10-05 15:20:47', '', 'JOHN', 56, 7, '2024-01-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-05 15:20:47', 583, '2024-01-02 15:53:16');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11637, 20013, '', '11637', 'E', 1, '<p>\n	Dear Team,</p>\n<p>\n	Requesting if can able to updte&nbsp; the unit price on PO 603433 to <strong><span style=\"background-color:#ffff00;\">1,252.80USD.</span></strong></p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 21812 characters]\" /></p>\n<p>\n	Thank you</p>\n', '2022-10-05 15:38:35', '', 'Rhealiza G', 37, 12, '2022-10-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2022-10-05 15:38:35', 20, '2022-10-06 16:44:53'),
(11639, 20019, '', '11639', 'E', 1, '<p>\n	Bluesky erp lite - version change to 8</p>\n', '2022-10-06 16:51:17', '', 'JOHN', 56, 12, '2022-10-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-06 16:51:17', 1, '2022-10-21 05:00:03'),
(11640, 20098, '', '11640', 'I', 1, '<p>\n	Mobile Appliction</p>\n', '2022-10-07 08:20:17', '', 'JOHN', 293, 2, '2023-10-04', 0, '0000-00-00', '', 0, '0', '', '30016', 0, 0, '', '', 69, '2022-10-07 08:20:17', 69, '2023-10-04 08:43:01'),
(11641, 20061, '', '11641', 'E', 1, '<p>\n	Take a copy of Quick Bake&nbsp; from Esell and duplicate, Remove all transactions , and inventory item all qty o, customer, vendor, user, master s same</p>\n', '2022-10-07 15:37:32', '', 'JOHN', 182, 12, '2022-10-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-07 15:37:32', 1, '2022-10-16 05:00:02'),
(11642, 20019, '', '11642', 'E', 1, '<p>\n	ABAP checking</p>\n', '2022-10-07 17:25:43', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-07 17:25:43', 69, '2023-03-27 12:27:58'),
(11643, 20067, '', '11643', 'I', 1, '<p>\n	Credit Limit - Blocking in order confirmation</p>\n', '2022-10-10 09:04:09', '', 'JOHN', 200, 12, '2022-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-10 09:04:09', 1, '2022-10-18 05:00:02'),
(11644, 20019, '', '11644', 'E', 1, '<p>\n	Double Dot not allowing in numeric fields (ALL ERP, CRM)</p>\n', '2022-10-11 08:56:00', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-11 08:56:00', 69, '2023-03-27 12:28:16'),
(11645, 20019, '', '11645', 'E', 1, '<p>\n	Team Meeting dt 11/10/22</p>\n', '2022-10-11 08:56:57', '', 'JOHN', 56, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-11 08:56:57', 1, '2022-11-01 06:00:01'),
(11649, 20090, '', '11649', 'E', 1, '<p>\n	Modifications</p>\n', '2022-10-14 07:38:06', '', 'JOHN', 269, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 07:38:06', 69, '2023-03-27 12:28:50'),
(11646, 20061, '', '11646', 'E', 1, '<p>\n	Change ESELL DB No 45, AL Abeer, DATe change to 22/09/23 , Amount deposited in Bluesky account on 11/10/22- Habeeb</p>\n', '2022-10-11 11:07:29', '', 'JOHN', 182, 12, '2022-10-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-11 11:07:29', 1, '2022-10-18 05:00:02'),
(11647, 20019, '', '11647', 'E', 1, '<p>\n	bluesky01.com/logistics</p>\n', '2022-10-11 17:19:40', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-11 17:19:40', 69, '2023-03-27 12:28:38'),
(11648, 20019, '', '11648', 'E', 1, '<p>\n	Aution sytem (Concept Implementation)</p>\n', '2022-10-11 17:54:32', '', 'JOHN', 56, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-11 17:54:32', 1, '2022-11-07 06:00:02'),
(11664, 20067, '', '11664', 'I', 1, '<p>\n	Diatech &ndash; File No 19818, PO 60615, MR 589,590&nbsp; Invoice 80592 1465-560 =905 Invoice 80593 -590</p>\n<p>\n	But in system both inv 80592 and 80593 are of Amount 1465</p>\n<p>\n	&nbsp;</p>\n', '2022-10-19 10:21:59', 'WhatsApp Image 2022-10-19 at 10.13.36 AM.jpeg,WhatsApp Image 2022-10-19 at 10.13.37 AM.jpeg', 'JOHN', 200, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-19 10:21:59', 69, '2023-03-27 12:29:39'),
(11650, 20074, '', '11650', 'E', 1, '<p>\n	Could you please put the appraisal back to the below employee</p>\n<table border=\"1\" cellpadding=\"0\" cellspacing=\"0\">\n	<thead>\n		<tr>\n			<th>\n				<p>\n					<strong>No</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Code</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Name</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Branch</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Department</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Designation</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Joining Date</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Appraisal For</strong></p>\n			</th>\n			<th>\n				<p>\n					<strong>Created Date</strong></p>\n			</th>\n		</tr>\n		<tr>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n			<th>\n				&nbsp;</th>\n		</tr>\n	</thead>\n	<tbody>\n		<tr>\n			<td>\n				<p>\n					1</p>\n			</td>\n			<td>\n				<p>\n					M107</p>\n			</td>\n			<td>\n				<p>\n					KHUSHBU DIPAKBHAI JASANI</p>\n			</td>\n			<td>\n				<p>\n					MHQ</p>\n			</td>\n			<td>\n				<p>\n					RM</p>\n			</td>\n			<td>\n				<p>\n					Corporate Structuring Associate</p>\n			</td>\n			<td>\n				<p>\n					18/04/2022</p>\n			</td>\n			<td>\n				<p>\n					Probation review</p>\n			</td>\n			<td>\n				<p>\n					06/09/2022</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-10-14 07:47:05', '', 'JOHN', 221, 12, '2022-10-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 07:47:05', 1, '2022-10-20 05:00:02'),
(11651, 20025, '', '11651', 'E', 1, '<p>\n	Better homes BH119 date changed from30/09/22 to 20/10/22 as per Habeeb on 14/10/22</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"905\">\n	<colgroup>\n		<col width=\"368\" />\n		<col width=\"225\" />\n		<col width=\"312\" />\n	</colgroup>\n	<tbody>\n		<tr height=\"20\">\n			<td class=\"xl65\" height=\"20\" style=\"height:15.0pt;width:276pt\" width=\"368\">\n				http://alfadil.weibex.com/</td>\n			<td class=\"xl66\" style=\"width:169pt\" width=\"225\">\n				&nbsp;</td>\n			<td class=\"xl65\" style=\"width:234pt\" width=\"312\">\n				&nbsp;</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2022-10-14 09:46:27', '', 'JOHN', 74, 12, '2022-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 09:46:27', 1, '2022-10-25 05:00:02'),
(11652, 20001, '', '11652', 'E', 1, '<p>\n	Invoice correction</p>\n', '2022-10-14 11:25:44', 'InvoiceReport (1)-1.pdf', 'JOHN', 2, 12, '2022-10-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 11:25:44', 1, '2022-10-21 05:00:03'),
(11653, 20021, '', '11653', 'E', 1, '<p>\n	HR - New Version update</p>\n', '2022-10-14 16:10:01', '', 'JOHN', 62, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 16:10:01', 69, '2023-03-27 12:29:01'),
(11654, 20002, '', '11654', 'I', 1, '<p>\n	Price upload error</p>\n<p>\n	As Munas is unable to upload the price, kindly upload the attached &amp; confirm once it is done.</p>\n<p>\n	<br />\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-10-14 17:19:08', 'SALES_PRICE_LIST.csv,COST_PRICE_LIST.csv', 'JOHN', 5, 12, '2022-10-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 17:19:08', 1, '2022-10-24 05:00:02'),
(11655, 20019, '', '11655', 'E', 1, '<p>\n	Digital Clock impementation</p>\n', '2022-10-14 17:20:43', '', 'JOHN', 56, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-14 17:20:43', 1, '2022-11-07 06:00:02'),
(11656, 20148, '', '11656', 'E', 1, '<p>\n	Website</p>\n', '2022-10-17 07:58:46', '', 'JOHN', 443, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-17 07:58:46', 69, '2023-03-27 12:29:11'),
(11657, 20125, '', '11657', 'E', 1, '<p>\n	Face detection by Camera</p>\n', '2022-10-17 08:19:31', '', 'JOHN', 374, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-17 08:19:31', 69, '2023-03-27 12:29:21'),
(11658, 20098, '', '11658', 'E', 1, '<p>\n	Infinity - JOB#IL5198 - With reference to the subject job number, please help us to change the AWB number and mention <strong>IL5198</strong>.</p>\n', '2022-10-17 16:49:11', '', 'JOHN', 293, 12, '2022-10-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-17 16:49:11', 1, '2022-10-24 05:00:02'),
(11659, 20002, '', '11659', 'E', 1, '<p>\n	Price upload</p>\n', '2022-10-17 16:59:00', '', 'JOHN', 5, 12, '2022-10-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-17 16:59:00', 1, '2022-10-24 05:00:02'),
(11660, 20002, '', '11660', 'E', 1, '<p>\n	Profit calculation - view option for old invoiced/credit note&nbsp; file</p>\n', '2022-10-17 16:59:46', '', 'JOHN', 5, 12, '2022-10-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-17 16:59:46', 1, '2022-10-24 05:00:02'),
(11661, 20061, '', '11661', 'E', 1, '<p>\n	ESELL DB 70, FST, change date from 29/09/22 to 03/01/2023</p>\n', '2022-10-18 08:32:53', '', 'JOHN', 182, 12, '2022-10-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-18 08:32:53', 1, '2022-10-24 05:00:02'),
(11662, 20019, '', '11662', 'E', 1, '<p>\n	Team Meeting 18/10/22</p>\n', '2022-10-18 08:46:17', '', 'JOHN', 56, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-18 08:46:17', 1, '2022-11-01 06:00:01'),
(11677, 20004, '', '11677', 'E', 1, '<p>\n	Logistics Application<br />\n	User group, Settings<br />\n	Print correction etc</p>\n', '2022-10-25 16:37:11', '', 'JOHN', 11, 7, '2023-12-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-25 16:37:11', 583, '2023-12-14 16:18:23'),
(11663, 20061, '', '11663', 'E', 1, '<p>\n	E &ndash; Sell BH 140 (DB 48) change date from 17/10/22 to 20/10/22&ndash; Jisha 18/10/22</p>\n<p>\n	&nbsp;</p>\n', '2022-10-18 14:32:38', '', 'JOHN', 182, 12, '2022-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-18 14:32:38', 1, '2022-10-25 05:00:02'),
(11665, 20061, '', '11665', 'E', 1, '<p>\n	E-Sell - SK Pigeon wants to change their landline number also. this is the New landline number +971 4 328 8335</p>\n<p>\n	Esell &ndash; SKP (DB 59) &ndash; add one new user and end date from 26/04/2023 &nbsp;change to26/06/23</p>\n<p>\n	&nbsp;</p>\n', '2022-10-19 14:34:26', '', 'JOHN', 182, 12, '2022-10-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-19 14:34:26', 1, '2022-10-26 05:00:02'),
(11666, 20117, '', '11666', 'E', 1, '<p>\n	Coral HR l- present marking (26&nbsp; JULY TO 25 AUG )and Approval Heirarchy fazil(Old HR) changing to Gowri(New HR)- Dikson, Rahul 19/10/22</p>\n<p>\n	&nbsp;</p>\n', '2022-10-19 16:54:29', '', 'JOHN', 350, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-19 16:54:29', 1, '2022-10-28 05:00:04'),
(11667, 20065, '', '11667', 'E', 1, '<p>\n	Maganum Hr: For MTC-JAFZA company; on 28th Sept everyone is shown as absent- Dikson 19/10/22</p>\n<p>\n	Magnum -26/9/22 -5pm womm jafza &ndash; corrected Dikson 19/10/22 &ndash; Was due to early time in system</p>\n<p>\n	&nbsp;</p>\n', '2022-10-19 16:55:39', '', 'JOHN', 194, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-19 16:55:39', 1, '2022-10-28 05:00:04'),
(11668, 20078, '', '11668', 'E', 1, '<p>\n	Moative- salary calculating error dt 19/10/22 due to attendance absent+ File upload absent- Dikson 19/10/22</p>\n<p>\n	&nbsp;</p>\n', '2022-10-19 16:57:13', '', 'JOHN', 233, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-19 16:57:13', 1, '2022-10-28 05:00:04'),
(11669, 20013, '', '11669', 'E', 1, '<p>\n	LLC -Topnet LLC- Need ur assistance to edit date in the invoice CRM LLC -40172&nbsp; as 23/9/2022</p>\n', '2022-10-20 12:42:00', '', 'JOHN', 38, 12, '2022-10-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-20 12:42:00', 1, '2022-10-27 05:00:01'),
(11670, 20013, '', '11670', 'E', 1, '<p>\n	Topnet LLC</p>\n<p>\n	https://cumuluserp.me/topnetllc/index.php?r=delivery/PrintDeliveryReportPDF&amp;id=30191&amp;c_id=169</p>\n<p>\n	https://cumuluserp.me/topnetllc/index.php?r=invoice/PrintInvoiceReportPDF_points&amp;id=40190&amp;c_id=169&amp;frm=tax&amp;points=1</p>\n<p>\n	DO No 30161 - IDelete line tems 3,4, 5 from DO and make Sales order convertable<br />\n	Invoice No 40190-&nbsp; Delete line tems 3,4, 5 fromInvoice<br />\n	Make correction wherever necessary , Stock Ledger etc</p>\n', '2022-10-20 16:42:31', '', 'JOHN', 38, 12, '2022-10-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-20 16:42:31', 1, '2022-10-27 05:00:01'),
(11671, 20133, '', '11671', 'E', 1, '<p>\n	API correction</p>\n', '2022-10-20 17:25:43', '', 'JOHN', 398, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-20 17:25:43', 1, '2022-10-28 05:00:04'),
(11672, 20097, '', '11672', 'E', 1, '<p>\n	Bosch Logo adding in Quotation and Invoice</p>\n', '2022-10-21 08:22:58', '', 'JOHN', 290, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-21 08:22:58', 1, '2022-10-28 05:00:04'),
(11673, 20013, '', '11673', 'E', 0, '<p>\n	De<span style=\"font-family:arial,helvetica,sans-serif;\">ar Team,</span></p>\n<p>\n	<span style=\"font-family:arial,helvetica,sans-serif;\">Requesting if you can able to remove the cutting charges $300 from PI 804580.</span></p>\n<p>\n	&nbsp;</p>\n<p>\n	<span style=\"font-family:arial,helvetica,sans-serif;\">Thank you</span></p>\n', '2022-10-21 11:51:00', '', 'Rhealiza G', 38, 12, '2022-10-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2022-10-21 11:51:00', 20, '2022-10-25 09:26:09'),
(11674, 20061, '', '11674', 'E', 1, '<p>\n	E- Sell &ndash; BH140(DB48) change date from 20/10/22 to 17/10/23</p>\n', '2022-10-24 09:57:07', '', 'JOHN', 182, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-24 09:57:07', 1, '2022-11-07 06:00:02'),
(11675, 20019, '', '11675', 'E', 1, '<p>\n	Edumate</p>\n', '2022-10-25 08:12:29', '', 'JOHN', 56, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-25 08:12:29', 1, '2022-11-07 06:00:02'),
(11676, 20019, '', '11676', 'E', 1, '<p>\n	Team Meeting 25/10/22</p>\n', '2022-10-25 08:54:57', '', 'JOHN', 56, 12, '2023-08-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-25 08:54:57', 69, '2023-08-05 07:42:06'),
(11678, 20065, '', '11678', 'E', 1, '<p>\n	Attendence report modification to inclue load handling</p>\n', '2022-10-25 17:04:21', '', 'JOHN', 194, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-10-25 17:04:21', 1, '2022-12-02 06:00:06'),
(11679, 20067, '', '11679', 'I', 1, '<p>\n	Quotation, Order- when deleting Line item, if not saved, the total doesnot match with grid amount</p>\n', '2022-10-25 17:24:22', '', 'JOHN', 200, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-25 17:24:22', 69, '2023-03-27 12:29:55'),
(11680, 20124, '', '11680', 'E', 1, '<p>\n	API Login<br />\n	Get details when serached the barcode from order</p>\n', '2022-10-25 17:27:18', '', 'JOHN', 371, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-25 17:27:18', 69, '2023-03-27 12:30:28'),
(11683, 20124, '', '11683', 'E', 1, '<p>\n	Mobile App for scanning the label barcode</p>\n', '2022-10-27 08:35:50', '', 'JOHN', 371, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-27 08:35:50', 69, '2023-03-27 12:30:38'),
(11684, 20118, '', '11684', 'E', 1, '<p>\n	OT hours changing rules as per attached sheet</p>\n', '2022-10-28 10:43:40', 'EN-2.pdf', 'JOHN', 353, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-28 10:43:40', 69, '2023-04-12 14:40:27'),
(11685, 20117, '', '11685', 'E', 1, '<p>\n	Quotation download- File name- cliet name + Qtn number</p>\n', '2022-10-28 11:12:54', '', 'JOHN', 350, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-28 11:12:54', 1, '2022-11-07 06:00:02'),
(11686, 20019, '', '11686', 'E', 1, '<p>\n	Edumate</p>\n', '2022-10-31 14:09:30', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-31 14:09:30', 69, '2023-03-27 12:30:49'),
(11687, 20061, '', '11687', 'E', 1, '<p>\n	New ESELll creation (Bakery)</p>\n<p>\n	Company Name: QUICK BAKE<br />\n	Address: AL DHAIT SOUTH NEAR MARKAZ ZAYED RAS AL KHAIMAH<br />\n	TRN:<br />\n	Telephone: +971 722 63311<br />\n	Mobile: 056 533 2833<br />\n	Email:salesquickbakeuae.com<br />\n	Web:https://www.quickbakeuae.com/<br />\n	Logo:<br />\n	<br />\n	Salesman details:<br />\n	Name and mobile-MUHAMMED UVAIS<br />\n	052 681 5884<br />\n	<br />\n	Sales executives- MUHAMMED HASEEB - 054 458 8214<br />\n	MUHAMMED KUNHI- 050 272 1235</p>\n', '2022-10-31 14:50:58', 'WhatsApp Image 2022-10-31 at 2.48.46 PM.jpeg,QUICKBAKE-1.pdf', 'JOHN', 182, 12, '2022-11-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-31 14:50:58', 1, '2022-11-09 06:00:02'),
(11688, 20061, '', '11688', 'E', 1, '<p>\n	NI2022 DB no : 47 change date from 01/11/2022 to 0111/2023</p>\n', '2022-10-31 15:11:03', '', 'JOHN', 182, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-31 15:11:03', 1, '2022-11-07 06:00:02'),
(11689, 20061, '', '11689', 'E', 1, '<p>\n	Change NI2023 (DB 49) Date from 10/11/2022 to 10/11/2023</p>\n', '2022-10-31 15:12:17', '', 'JOHN', 182, 12, '2022-11-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-31 15:12:17', 1, '2022-11-07 06:00:02'),
(11690, 20061, '', '11690', 'E', 1, '<p>\n	Is2013<br />\n	From erp. weibex<br />\n	<br />\n	I<br />\n	&nbsp;is1032, New Esell</p>\n<p>\n	copy Customer, inventory and vendor</p>\n', '2022-10-31 15:15:25', '', 'JOHN', 182, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-31 15:15:25', 69, '2023-03-27 12:31:05'),
(11692, 20019, '', '11692', 'E', 1, '<p>\n	Double in numeric field avoid checking</p>\n', '2022-11-01 07:42:45', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-01 07:42:45', 69, '2023-03-27 12:31:21'),
(11693, 20019, '', '11693', 'E', 1, '<p>\n	Team Meeting 01/11/2022</p>\n', '2022-11-01 08:54:16', '', 'JOHN', 56, 12, '2023-08-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-01 08:54:16', 69, '2023-08-01 07:56:53'),
(11713, 20019, '', '11713', 'E', 1, '<p>\n	General issues (Other)</p>\n', '2022-11-08 17:24:09', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-08 17:24:09', 69, '2023-03-27 12:37:33'),
(11694, 20021, '', '11694', 'E', 1, '<p>\n	Mobile App develpomnet</p>\n', '2022-11-02 10:26:10', '', 'JOHN', 62, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-02 10:26:10', 69, '2023-03-27 12:31:37'),
(11695, 20014, '', '11695', 'E', 1, '<p>\n	Voucher saving issue , amount not matching</p>\n', '2022-11-02 10:39:17', 'WhatsApp Image 2022-11-01 at 12.00.45 PM.jpeg,WhatsApp Image 2022-11-01 at 12.00.48 PM.jpeg', 'JOHN', 41, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-02 10:39:17', 69, '2023-03-27 12:32:03'),
(11696, 20117, '', '11696', 'E', 1, '<p>\n	Coral Perfume - Add new modules, inventory, Purchase, Production</p>\n', '2022-11-02 14:22:21', '', 'JOHN', 350, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-02 14:22:21', 69, '2023-03-27 12:36:12'),
(11697, 20067, '', '11697', 'I', 1, '<p>\n	[2:22 PM, 11/2/2022] Shamna Diatech Official: sir we already checked and locked salary then we can see that few of them are absent by 15-10-2022<br />\n	[2:23 PM, 11/2/2022] Shamna Diatech Official: then again i checked corrected locked then again it shows the same few of them are absent by 15-10-2022</p>\n', '2022-11-03 07:40:56', 'WhatsApp Image 2022-11-02 at 2.43.31 PM.jpeg', 'JOHN', 200, 12, '2022-11-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 07:40:56', 1, '2022-11-09 06:00:02'),
(11737, 20002, '', '11737', 'E', 1, '<p>\n	Norden Customer change</p>\n<p>\n	File ID 47201 Customer change from Site Technology Integrated System LLC to SITE technology Limited Company (ID 1936)<br />\n	Quote : 143027<br />\n	Order: 213821</p>\n<p>\n	Delivery Order: 315935, 315912</p>\n<p>\n	Invoice : TI 413353, TI 413339</p>\n<p>\n	And Stock ledger</p>\n<p>\n	&nbsp;</p>\n', '2022-11-23 10:07:58', '', 'JOHN', 5, 12, '2022-11-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-23 10:07:58', 1, '2022-11-30 06:00:02'),
(11698, 20067, '', '11698', 'I', 1, '<p>\n	Purchase order Print Modification</p>\n', '2022-11-03 07:51:49', 'sample-6.pdf', 'JOHN', 200, 12, '2022-11-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 07:51:49', 1, '2022-11-29 06:00:02'),
(11699, 20098, '', '11699', 'E', 1, '<p>\n	Cheque Management</p>\n', '2022-11-03 08:39:42', '', 'JOHN', 293, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 08:39:42', 69, '2023-03-27 12:36:22'),
(11700, 20020, '', '11700', 'E', 1, '<p>\n	Finance Integration</p>\n', '2022-11-03 08:40:42', '', 'JOHN', 59, 12, '2022-11-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 08:40:42', 69, '2022-11-21 09:19:28'),
(11701, 20138, '', '11701', 'E', 1, '<p>\n	EOS 112034 &ndash; amount calculation - clarification</p>\n<p>\n	&nbsp;</p>\n', '2022-11-03 11:05:57', '', 'JOHN', 413, 12, '2022-11-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 11:05:57', 1, '2022-11-10 06:00:02'),
(11702, 20124, '', '11702', 'E', 1, '<p>\n	Header, footer etc Add (Branch)</p>\n<p>\n	Miramar Shipping &amp; Customs Clearance L.L.C (BRANCH)<br />\n	??????? ????? ???????? ??????? ?.?.?.? (???)<br />\n	Office/Warehouse # RA08YD01<br />\n	JAFZA North<br />\n	PO Box: 82322<br />\n	Jebel Ali Free Zone<br />\n	Dubai , United Arab Emirates<br />\n	Tel : + 971 4 5916384<br />\n	Mob : +971 55 106 99 96<br />\n	Email :<br />\n	jadobeid@miramargroups.com<br />\n	logistics.jafza@miramargroups.com<br />\n	Website : www.miramargroups.com</p>\n<p>\n	&nbsp;</p>\n<p>\n	design changes as per attached picture</p>\n', '2022-11-03 11:19:20', '', 'JOHN', 371, 12, '2022-11-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 11:19:20', 1, '2022-11-11 06:00:05'),
(11703, 20078, '', '11703', 'E', 1, '<p>\n	Moative &ndash; Link to website and login of recruiting companies to upload data of candidates</p>\n<p>\n	Moative &ndash; Link to website &ndash; for apply individual candidate CV submission</p>\n<p>\n	Moative &ndash; Employee menu rearranging</p>\n<p>\n	Moative &ndash; Recruitment Tab rearranging and modifications</p>\n<p>\n	Moative &ndash; Branch merging</p>\n<p>\n	Moative &ndash; Asset- Under taking letter- Better use new assets</p>\n<p>\n	Moative &ndash; Editable version of letters</p>\n<p>\n	Moative &ndash; Payslip - remarks should be visible</p>\n<p>\n	Moative &ndash; Cards / Incentive- only one type, no month wise history;</p>\n<p>\n	Moative - amazon 9hr/5 hr division between employees,</p>\n<p>\n	Moative - amazon upload increments and deduction from a file, which will be used on salary calculation, Recruitment</p>\n<p>\n	Moative- same file upload for ot for moative amazon and mycon amazon</p>\n<p>\n	&nbsp;</p>\n', '2022-11-03 15:47:06', 'Incentive Structure.xlsx', 'JOHN', 233, 12, '2023-10-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 15:47:06', 69, '2023-10-14 11:00:07'),
(11704, 20078, '', '11704', 'E', 1, '<p>\n	Moative - Amazon</p>\n<p>\n	AMZ719</p>\n<p>\n	50+1500+1450=3000<br />\n	all salary components from 12/09/22</p>\n', '2022-11-03 16:26:04', '', 'JOHN', 233, 12, '2022-11-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 16:26:04', 1, '2022-11-10 06:00:02'),
(11705, 20146, '', '11705', 'E', 1, '<div>	<b>Attendance:</b></div><div>	- I tried to check the full attendance list and it showed everyone fully absent since the start of November. Today is the first time I checked since last week so it seems something has happened shifting from October to November since office biometrics capturing is not happening.</div><div>	As screenshot above shows, I used one employee who is WFH today to test PUNCH through the system and checked the report.<br />	<div>		It&#39;s correct only, why does the employee name not match?</div>	<div>		&nbsp;</div>	<div>		- Please confirm if late to punch IN notice email will be sent for both employees working at home and forgot to punch in by the system and for employees who arrive late to the office and did not yet punch in through the office biometrics system</div>	<div>		&nbsp;</div>	<div>		- In the attendance reports, can you distinguish between system punch and biometric system punch?</div>	<div>		<br />		<div>			<b>Expense:</b></div>		<div>			- Can you please add &quot;Rejected History&quot; same like the &quot;Approval History&quot; for applicant and all approval levels with viewing option of the expense request?</div>		<div>			- We have tested the flagging of the expense request and noted that it is based on date, amount and particulars, meaning that if date and amount are the same but &quot;Particulars&quot; is different, the system does not flag as a duplicate. Can you please make the system flag if only date and amount are the same instead?</div>		<div>			- For the Expense Reports, we noted that there is Applied, Approved, Rejected and Payment Released. Can you also make a report for all of these reports together?</div>		<div>			- In the &quot;Payroll&quot; --&gt; &quot;Payments&quot; for the &quot;Bank Transfer&quot; option, can you please remove the mandatory field of &quot;Select Bank&quot; and instead put &quot;Date of Transfer&quot;?</div>		<div>			- When clicking on &quot;view&quot; for each expense request, a pop up window comes as below. Can you please add the &quot;ID #&quot; and make a &quot;Print&quot; option for the pop up window?</div>		<div>			- Can you add the below tick box and add it to the Expense reports after expense are Approved and only for Accounts Log In (Sharina and Omer)</div>		<div>			<div>				&nbsp;</div>			<div>				And then in the main screen it will show also if the Accounts ticked the &quot;Checked by Accounts&quot; above (filled if checked, not filled if unchecked for example):</div>		</div>		<br />		&nbsp;</div></div><p>	&nbsp;</p>', '2022-11-03 17:01:09', '', 'JOHN', 437, 12, '2023-06-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-03 17:01:09', 69, '2023-06-10 08:02:34'),
(11716, 20109, '', '11716', 'E', 1, '<p>\n	Campaign App</p>\n', '2022-11-10 08:11:10', '', 'JOHN', 326, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30030', 0, 0, '', '', 69, '2022-11-10 08:11:10', 1, '2022-12-02 06:00:06'),
(11706, 20149, '', '11706', 'E', 1, '<p>\n	HR Installation</p>\n', '2022-11-04 07:40:29', '', 'JOHN', 446, 12, '2023-05-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-04 07:40:29', 69, '2023-05-03 08:02:22'),
(11707, 20045, '', '11707', 'E', 1, '<p>\n	HR Installation</p>\n', '2022-11-04 10:38:50', '', 'JOHN', 134, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-04 10:38:50', 69, '2023-04-12 14:40:20');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11709, 20061, '', '11709', 'E', 1, '<p>\n	E- Sell- Create new DB</p>\n<p>\n	Company Name: FLAVOURS FOOD STUFF TRADING LLC</p>\n<p>\n	Address: DUBAI QUSAIS</p>\n<p>\n	TRN:100588993400003</p>\n<p>\n	Telephone:0569228616</p>\n<p>\n	-------------------------</p>\n<p>\n	Mobile:0569228616</p>\n<p>\n	Email:rameezabdulla07@gmail.com</p>\n<p>\n	Web:</p>\n<p>\n	Logo:</p>\n<p>\n	----------------------------</p>\n<p>\n	Salesman details:suneerali</p>\n<p>\n	Name and mobile 0556890878</p>\n<p>\n	&nbsp;</p>\n', '2022-11-07 17:43:18', '', 'JOHN', 182, 12, '2022-11-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-07 17:43:18', 1, '2022-11-15 06:00:02'),
(11710, 20003, '', '11710', 'E', 1, '<p>\n	chaloub server moving and upgrading</p>\n', '2022-11-08 07:48:19', '', 'JOHN', 8, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-08 07:48:19', 69, '2023-03-27 12:36:49'),
(11711, 20150, '', '11711', 'E', 1, '<p>\n	ERP Installation</p>\n', '2022-11-08 08:07:41', '', 'JOHN', 449, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-08 08:07:41', 69, '2023-03-27 12:37:11'),
(11712, 20019, '', '11712', 'E', 1, '<p>\n	Team Meeting 08/11/22</p>\n', '2022-11-08 09:18:20', '', 'JOHN', 56, 12, '2022-11-14', 0, '0000-00-00', '', 0, '0', '', '30030,30018,30012', 0, 0, '', '', 69, '2022-11-08 09:18:20', 1, '2022-11-14 06:00:02'),
(11714, 20151, '', '11714', 'E', 1, '<p>\n	Software Implementation</p>\n', '2022-11-08 20:39:09', '', 'mereenak', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-11-08 20:39:09', 69, '2023-04-12 15:18:23'),
(11715, 20152, '', '11715', 'E', 1, '<p>\n	Edumate -</p>\n', '2022-11-10 07:31:06', '', 'JOHN', 455, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-10 07:31:06', 69, '2023-03-27 12:37:47'),
(11717, 20071, '', '11717', 'E', 1, '<p>\n	Master file report does not contain other important details (i.e. nationality, passport no.). Kindly add those on the report at the soonest please</p>\n', '2022-11-10 08:27:06', '', 'JOHN', 212, 12, '2022-11-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-10 08:27:06', 1, '2022-11-16 06:00:02'),
(11718, 20061, '', '11718', 'E', 1, '<p>\n	E-Sell admin@IS1032- DB No 82 rename to IS2010 ; Name change to Thajudheen &ndash; Company name : sland land general trading br &ndash; End date of is2010-</p>\n', '2022-11-10 12:05:09', '', 'JOHN', 182, 12, '2023-04-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-10 12:05:09', 69, '2023-04-11 09:20:32'),
(11719, 20019, '', '11719', 'E', 1, '<p>\n	Company project time calculation and multiple drop-down for service<br />\n	<br />\n	<br />\n	<br />\n	&nbsp;</p>\n', '2022-11-11 10:28:54', '', 'JOHN', 56, 12, '2022-11-17', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-11-11 10:28:54', 1, '2022-11-17 06:00:01'),
(11720, 20117, '', '11720', 'E', 1, '<p>\n	HRMS- Salary calculation method changing<br />\n	component correction<br />\n	Payslip Modification</p>\n', '2022-11-11 16:52:36', '', 'JOHN', 350, 12, '2022-11-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-11 16:52:36', 1, '2022-11-28 06:00:02'),
(11721, 20019, '', '11721', 'E', 1, '<p>\n	Support Others or Discussion</p>\n', '2022-11-11 20:37:01', '', 'mereenak', 56, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-11-11 20:37:01', 69, '2023-04-04 10:47:15'),
(11722, 20019, '', '11722', 'E', 1, '<p>\n	Team Meeting 15 Nov 2022</p>\n', '2022-11-15 08:07:15', '', 'JOHN', 56, 12, '2022-11-22', 0, '0000-00-00', '', 0, '0', '', '30030,30018', 0, 0, '', '', 69, '2022-11-15 08:07:15', 1, '2022-11-22 06:00:03'),
(11723, 20002, '', '11723', 'E', 1, '<p>\n	Stock correction</p>\n', '2022-11-15 08:20:34', '', 'JOHN', 5, 12, '2023-04-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-15 08:20:34', 69, '2023-04-11 09:20:10'),
(11724, 20019, '', '11724', 'E', 1, '<p>\n	Moving files and folders from Bethel server to Google drive</p>\n', '2022-11-17 11:44:13', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-17 11:44:13', 69, '2023-03-27 12:38:28'),
(11725, 20118, '', '11725', 'E', 1, '<p>\n	Leave salary Manual entry form, print out, user permission</p>\n', '2022-11-17 17:09:43', '', 'JOHN', 353, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30018', 0, 0, '', '', 69, '2022-11-17 17:09:43', 1, '2022-12-02 06:00:06'),
(11726, 20133, '', '11726', 'E', 1, '<p>\n	1. Inventory listing is too slow</p>\n<p>\n	2. Some products unit is missing</p>\n', '2022-11-17 19:19:26', '', 'mereenak', 398, 12, '2022-11-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-11-17 19:19:26', 1, '2022-11-24 06:00:01'),
(11727, 20150, '', '11727', 'E', 1, '<p>\n	Software Implementation</p>\n', '2022-11-17 19:20:35', '', 'mereenak', 449, 12, '2022-11-24', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 478, '2022-11-17 19:20:35', 1, '2022-11-24 06:00:01'),
(11728, 20067, '', '11728', 'I', 1, '<p>\n	Diatech&nbsp; PO- Additional one blank page print PO61757 &ndash;Print without barcode 1</p>\n<p>\n	&nbsp;</p>\n', '2022-11-18 17:13:16', '', 'JOHN', 200, 12, '2022-11-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-18 17:13:16', 1, '2022-11-25 06:00:05'),
(11729, 20002, '', '11729', 'E', 1, '<p>\n	1. Moved to bluesky-erp.com</p>\n', '2022-11-18 21:14:53', '', 'mereenak', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-11-18 21:14:53', 69, '2023-04-12 14:40:00'),
(11755, 20067, '', '11755', 'I', 1, '<p>\n	Finance Correction</p>\n', '2022-11-28 08:27:48', '', 'JOHN', 200, 12, '2023-03-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-28 08:27:48', 69, '2023-03-29 08:25:15'),
(11731, 20124, '', '11731', 'I', 1, '<p>\n	Edit Invoice/ updations</p>\n', '2022-11-21 18:18:18', '', 'mereenak', 371, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-11-21 18:18:18', 69, '2023-03-27 12:38:58'),
(11732, 20019, '', '11732', 'E', 1, '<p>\n	Team Meeting 22/11/22</p>\n', '2022-11-22 08:32:06', '', 'JOHN', 56, 12, '2022-11-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-22 08:32:06', 69, '2022-11-23 17:10:24'),
(11733, 20067, '', '11733', 'I', 1, '<p>\n	Service Order (Contarct) for Customer Ittehad Schools made , but when converted it came in name of Cedar School</p>\n<p>\n	Manuualy correction needed for rectify</p>\n', '2022-11-22 11:35:16', 'DIATECH221122.jpg', 'JOHN', 200, 12, '2022-11-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-22 11:35:16', 1, '2022-11-29 06:00:02'),
(11734, 20061, '', '11734', 'E', 1, '<p>\n	Bakery Esell Domain Problem</p>\n', '2022-11-22 11:36:16', '', 'JOHN', 182, 12, '2023-07-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-22 11:36:16', 69, '2023-07-21 11:09:07'),
(11735, 20074, '', '11735', 'E', 1, '<p>\n	AMA Advt branch &ndash; Emp: IGOR AMA00025- remove 2<sup>nd</sup> line in salary 4500 allowance</p>\n<p>\n	&nbsp;</p>\n', '2022-11-22 17:05:48', '', 'JOHN', 221, 12, '2022-11-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-22 17:05:48', 1, '2022-11-28 06:00:02'),
(11736, 20071, '', '11736', 'E', 1, '<p class=\"MsoNormal\">\n	<span style=\"font-size:11.0pt;font-family:&quot;Arial&quot;,sans-serif\">Hi Sangeetha,</span></p>\n<p class=\"MsoNormal\">\n	<span style=\"font-size:11.0pt;font-family:&quot;Arial&quot;,sans-serif\">Hope you are doing very well.</span></p>\n<p>\n	<span style=\"font-size:11.0pt;font-family:&quot;Arial&quot;,sans-serif\">Please check the email notification dear, the last I have received was on 9<sup>th</sup> November. </span></p>\n', '2022-11-22 17:06:59', '', 'JOHN', 212, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-22 17:06:59', 69, '2023-04-12 14:39:02'),
(11738, 20067, '', '11738', 'I', 1, '<p>\n	Service Order when converting from Order to Invoice customer changes</p>\n', '2022-11-23 10:15:32', '', 'JOHN', 199, 12, '2022-12-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-23 10:15:32', 1, '2022-12-01 06:00:02'),
(11741, 20067, '', '11741', 'I', 1, '<p>\n	Stock ageing Report<br />\n	copying from Norden and implementing here</p>\n', '2022-11-24 07:41:43', '', 'JOHN', 200, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-24 07:41:43', 69, '2023-03-27 12:40:10'),
(11739, 20067, '', '11739', 'I', 1, '<p>\n	Good morning!!!</p>\n<p>\n	Purchase order we make 600+30 vat total was Aed.630 but invoice amount comes 570+30 total Aed.600</p>\n<p>\n	(See atatched Images)</p>\n', '2022-11-23 10:17:47', 'image005.png,image007.png', 'JOHN', 200, 12, '2022-12-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-23 10:17:47', 1, '2022-12-01 06:00:02'),
(11740, 20106, '', '11740', 'I', 1, '<p>\n	Mediyaan &ndash; In DO if items from two lots are taken, it should be specified separately</p>\n<p>\n	Batch 1001-25<br />\n	Batch 1005 -40</p>\n<p>\n	But now showing<br />\n	batch 1001-65</p>\n<p>\n	&nbsp;</p>\n', '2022-11-23 10:38:39', '', 'JOHN', 317, 12, '2022-11-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-23 10:38:39', 1, '2022-11-30 06:00:02'),
(11742, 20118, '', '11742', 'E', 1, '<p>\n	Salary deduction Signing form<br />\n	Vaction request form</p>\n', '2022-11-24 08:11:28', '', 'JOHN', 353, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-11-24 08:11:28', 1, '2022-12-02 06:00:06'),
(11743, 20067, '', '11743', 'I', 1, '<p>\n	EOS correction</p>\n', '2022-11-24 08:12:52', 'WhatsApp Image 2022-11-23 at 9.58.37 AM.jpeg', 'JOHN', 200, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-24 08:12:52', 1, '2022-12-02 06:00:06'),
(11744, 20151, '', '11744', 'E', 3, '<p>\n	1. discription colomn in invoice pdf</p>\n<p>\n	2. sub total and discount rows in invoice pdf</p>\n<p>\n	3. company address based on invoice generated in which branch</p>\n<p>\n	4. warehouse filter in inventory</p>\n<p>\n	5. subtotal, discount, net total and vat colomns in commission report</p>\n<p>\n	nb: ref screen shots</p>\n', '2022-11-24 10:43:53', 'Screenshot (47).png,Screenshot (48).png,Screenshot (50).png,Screenshot (49).png', 'Habeeb', 451, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-24 10:43:53', 69, '2023-03-27 12:41:00'),
(11745, 20014, '', '11745', 'E', 3, '<p>\n	Voucher post / unpost error,</p>\n<p>\n	entry / exit voucher import in finance - duplicating vouchers</p>\n', '2022-11-24 12:53:32', '', 'Habeeb', 41, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-24 12:53:32', 69, '2023-03-27 12:39:09'),
(11746, 20098, '', '11746', 'E', 3, '<p>\n	1. G L report error</p>\n<p>\n	2. GL summary error</p>\n<p>\n	3. Trail balalce period error</p>\n', '2022-11-24 12:55:05', '', 'Habeeb', 292, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-24 12:55:05', 69, '2023-03-27 12:27:22'),
(11747, 20102, '', '11747', 'E', 1, '<p>\n	1. Duplicate Invoice Genetrating against one order</p>\n<p>\n	2. Purchase cost edit error</p>\n', '2022-11-24 12:56:06', '', 'Habeeb', 304, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-24 12:56:06', 69, '2023-03-27 12:39:20'),
(11748, 20098, '', '11748', 'I', 1, '<p>\n	Please remove the cancelled AWB already new one created then we can&rsquo;t able to update the cost updating time cost gone to cancelled job , please do the needful ,Waiting for your reply.</p>\n', '2022-11-25 07:53:23', 'infinity251122.jpg', 'JOHN', 293, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-25 07:53:23', 1, '2022-12-02 06:00:06'),
(11749, 20138, '', '11749', 'E', 1, '<p>\n	All cargo meeeting</p>\n<p>\n	&nbsp;</p>\n<p>\n	All cargo &ndash;Leave planner</p>\n<p>\n	All cargo &ndash; Print Button for leaves</p>\n<p>\n	All cargo - 2022 leaves +2023 26 leaves, 2022 leaves will be expiring on 31<sup>st</sup> march and that cannot be applied for April range</p>\n<p>\n	All cargo- Department head leave applying for his subordinates</p>\n<p>\n	All cargo - Provision to Put Email Id as Not applicable, then mail will not go</p>\n<p>\n	All cargo - Birthday wish mail cc others</p>\n<p>\n	All cargo - Work Anniversary mail to employee</p>\n<p>\n	&nbsp;</p>\n', '2022-11-25 08:48:52', '', 'JOHN', 413, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-25 08:48:52', 69, '2023-03-27 12:40:26'),
(11750, 20065, '', '11750', 'E', 1, '<p>\n	Monthly Attendence report modification by new view- due to the increase in number of employees</p>\n', '2022-11-25 08:49:46', '', 'JOHN', 194, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-25 08:49:46', 69, '2023-04-12 14:38:45'),
(11751, 20081, '', '11751', 'I', 2, '<p>\n	add one sales user in -&gt; admin@me02</p>\n<p>\n	block one sales user in -&gt; admin@me03</p>\n<p>\n	NB: currently both outlet have 2 users -&gt; 1 admin and 1 sales user</p>\n<p>\n	DB 15</p>\n', '2022-11-25 10:41:03', '', 'Habeeb', 242, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-25 10:41:03', 69, '2023-04-12 14:38:36'),
(11752, 20098, '', '11752', 'I', 1, '<p>\n	Infinity &ndash; JOB 6286 change agent from &ldquo;Infinity Logistics&rdquo; to &ldquo;EPL&rdquo;</p>\n<p>\n	&nbsp;</p>\n', '2022-11-25 10:42:22', '', 'JOHN', 293, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-25 10:42:22', 1, '2022-12-02 06:00:06'),
(11757, 20025, '', '11757', 'I', 2, '<p>\n	New user in Better Home in e-sell (BH200) - end date: 30/11/2023</p>\n', '2022-11-28 09:48:25', '', 'Habeeb', 74, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-28 09:48:25', 69, '2023-04-12 14:38:20'),
(11753, 20098, '', '11753', 'E', 1, '<p>\n	kindly remove orange marked name from subledger type<br />\n	<br />\n	we are not able to remove please help<br />\n	<br />\n	msg from infinity sir</p>\n', '2022-11-25 13:57:02', '', 'JOHN', 293, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-25 13:57:02', 69, '2023-03-28 10:35:06'),
(11754, 20138, '', '11754', 'E', 1, '<p>\n	Leave Print</p>\n<p>\n	(Do in Casio, and copy to All cargo)</p>\n', '2022-11-25 15:02:23', '', 'JOHN', 413, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-25 15:02:23', 69, '2023-03-27 12:41:32'),
(11756, 20032, '', '11756', 'E', 1, '<p>\n	1. Save Button Missing -- Website URL<br />\n	2. Menu showing error</p>\n', '2022-11-28 09:15:26', '', 'JOHN', 95, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-28 09:15:26', 69, '2023-04-12 14:38:28'),
(11758, 20098, '', '11758', 'I', 3, '<p>\n	ledger Balance in cumulative profit in trail balalnce opening and closing include manual voucher entries</p>\n', '2022-11-28 09:50:36', '', 'Habeeb', 293, 12, '2023-04-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-28 09:50:36', 69, '2023-04-06 11:46:09'),
(11764, 20116, '', '11764', 'I', 1, '<p>\n	*Alamis Meeting 29/11/22*</p>\n<p>\n	Alamis &ndash;Leave approval comments and previous approval person name</p>\n<p>\n	Alamis &ndash;After annual leave end , the next day if he is absent, send a mail to HR that this person has not came back from leave (Consider any approved leaves, holiday etc)- Show in dash board also</p>\n<p>\n	Alamis &ndash;Annual leave splitting for senior persons, money will be given at 2<sup>nd</sup> set of vacation</p>\n<p>\n	Alamis &ndash;After all the branches are calculated for a month, one salary report based on WPS company report</p>\n<p>\n	Alamis project &ndash;Project work time daily excel /pdf output with absent highlight</p>\n<p>\n	Alamis Project &ndash; Include ousourse for induction</p>\n<p>\n	*</p>\n<p>\n	&nbsp;</p>\n', '2022-11-29 17:37:14', '', 'JOHN', 347, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-29 17:37:14', 69, '2023-04-12 14:38:01'),
(11759, 20102, '', '11759', 'I', 3, '<p>\n	1.&nbsp;delivery note format</p>\n<p>\n	2. Need carton qty in stock reports, very difficult to check by pcs in Sale/purchase report</p>\n<p>\n	3. Also make it bold Sales person name and contact</p>\n<div>\n	delivery note</div>\n<div>\n	invoice</div>\n<div>\n	preforma invoice</div>\n', '2022-11-28 10:47:58', 'WhatsApp Image 2022-11-28 at 10.23.07 AM.jpeg,WhatsApp Image 2022-11-07 at 11.08.53 AM.jpeg,WhatsApp Image 2022-11-28 at 10.24.08 AM.jpeg', 'Habeeb', 304, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-28 10:47:58', 69, '2023-04-12 07:58:08'),
(11760, 20151, '', '11760', 'I', 3, '<p>\n	Meeting points on 24/11/2022</p>\n<ol>\n	<li>\n		Dash board layout in web</li>\n	<li>\n		Dash board drill down in web</li>\n	<li>\n		Stock report design issue &ndash;POS</li>\n	<li>\n		Show branch stock instead users and show only current branch in pos</li>\n	<li>\n		Login with branch user and save invoice with sales user password</li>\n	<li>\n		Barcode printing in web</li>\n	<li>\n		Tiles in pos all reports</li>\n	<li>\n		User hierarchy &ndash; main admin, branch admin, salesman and normal users</li>\n	<li>\n		All finance report with cost center</li>\n	<li>\n		Consolidated report for PL</li>\n	<li>\n		Arabic in pos print</li>\n	<li>\n		Cash closing report based on branch and its format</li>\n	<li>\n		Deposited to bank=vat+remaining amt in Commission report</li>\n</ol>\n', '2022-11-28 10:59:20', 'dehnee.docx', 'Habeeb', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-11-28 10:59:20', 69, '2023-04-12 15:18:55'),
(11761, 20021, '', '11761', 'E', 1, '<p>\n	Getting error when create product</p>\n', '2022-11-29 07:52:11', '', 'JOHN', 62, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-29 07:52:11', 69, '2023-03-28 10:33:37'),
(11762, 20098, '', '11762', 'E', 1, '<p>\n	KINDLY CHANGE THIS AWB NO TO 1Z8A4F130443161010</p>\n<p>\n	see attached image</p>\n', '2022-11-29 10:35:59', 'image_2022_11_29T06_29_55_887Z.png', 'JOHN', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-29 10:35:59', 69, '2023-04-12 14:38:14'),
(11763, 20125, '', '11763', 'E', 1, '<p>\n	Add Privacy policy/terms &amp; conditions/ Refund Policy</p>\n', '2022-11-29 11:07:25', '', 'JOHN', 374, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-29 11:07:25', 69, '2023-04-12 14:38:09'),
(11765, 20019, '', '11765', 'E', 1, '<p>\n	TEST Work</p>\n', '2022-11-30 08:25:19', '', 'Jubin Mathai', 56, 12, '2022-12-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-11-30 08:25:19', 613, '2022-12-08 08:26:09');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11766, 20146, '', '11766', 'E', 1, '<div>\n	E Mail dated 29/11/22</div>\n<div>\n	&nbsp;</div>\n<div>\n	Email notifications:</div>\n<div>\n	1. Is it possible to insert the link to the approval page for each request? So basically a shortcut to the page?</div>\n<div>\n	We understand that if the user is not logged in he/she first needs to log in but then he/she is directed to the approval / rejection page directly.</div>\n<div>\n	&nbsp;</div>\n<div>\n	Levels:</div>\n<div>\n	1. Is it possible to rename the below:</div>\n<div>\n	- &quot;Level 1 Approver&quot; --&gt; Level 1 Confirmer</div>\n<div>\n	- &quot;Level 2 Approver&quot; --&gt; Level 2 Confirmer</div>\n<div>\n	Only final Approver to be shown as Approved in Status for all applications</div>\n<div>\n	&nbsp;</div>\n<div>\n	Leave:</div>\n<div>\n	1. Is it still possible to make it as below?</div>\n<div>\n	<blockquote type=\"cite\">\n		<div class=\"gmail_quote\">\n			<blockquote class=\"gmail_quote\" style=\"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex\">\n				<div bgcolor=\"#FFFFFF\">\n					<blockquote type=\"cite\">\n						<div dir=\"ltr\">\n							<div dir=\"ltr\">\n								<div>\n									<span style=\"font-family:Calibri\">From Employee portal employee can apply for a single type of leave (Eg: annual leave) in the below manner</span><br style=\"font-family:Calibri\" />\n									<span style=\"font-family:Calibri\">From&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; To&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; Is 1/2 day(Tick)&nbsp; &nbsp;&nbsp;<span style=\"background-color:rgb(255,255,0)\">AM (Tick)&nbsp; PM (Tick)</span>&nbsp; &nbsp; Count</span><br style=\"font-family:Calibri\" />\n									<span style=\"font-family:Calibri\">02/11/22&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 04/11/22&nbsp;&nbsp;&nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"background-color:rgb(255,255,0)\">No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;No&nbsp;&nbsp;</span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3.0</span><br style=\"font-family:Calibri\" />\n									<span style=\"font-family:Calibri\">08/11/22&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 08/11/22&nbsp;&nbsp;&nbsp; Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<span style=\"background-color:rgb(255,255,0)\">Yes&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No</span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0.5</span><br style=\"font-family:Calibri\" />\n									<span style=\"font-family:Calibri\">15/11/22&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; 16/11/22&nbsp;&nbsp;&nbsp; No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<span style=\"background-color:rgb(255,255,0)\">No&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; No</span>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2.0</span><br style=\"font-family:Calibri\" />\n									<b style=\"font-family:Calibri\">Total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5.5</b></div>\n							</div>\n						</div>\n					</blockquote>\n				</div>\n			</blockquote>\n		</div>\n	</blockquote>\n</div>\n<div>\n	&nbsp;</div>\n<div>\n	Highlighted in yellow only becomes possible (enabled) to tick if 1/2 day is ticked, otherwise remains&nbsp;disabled.</div>\n<div>\n	This is to distinguish between AM and PM half day off.</div>\n<div>\n	&nbsp;</div>\n<div>\n	2. Can you separate Save &amp; Submit button same way as Expense Request?</div>\n<p>\n	<img alt=\"image.png\" height=\"178\" src=\"data:image/png;base64,[encoded data, 11692 characters]\" width=\"472\" /></p>\n<br />\n<div>\n	&nbsp;</div>\n<div>\n	3. Is there a possibility of a &quot;copy application&quot; function?</div>\n<div>\n	&nbsp;</div>\n<div>\n	&nbsp;</div>\n<div>\n	Expense:</div>\n<div>\n	1. Please give the edit function of the expense application once submitted but before Level 1 approved</div>\n<div>\n	&nbsp;</div>\n<div>\n	2. Can you add the &quot;Payment Date&quot; into the expense report as a separate column once payment is released?</div>\n<div>\n	&nbsp;</div>\n<div>\n	3. Please add two more fields to particulars: &quot;Entertainment&quot; &amp; &quot;Meeting&quot;</div>\n<div>\n	&nbsp;</div>\n<div>\n	4. In case &quot;Entertainment&quot; or &quot;Meeting&quot; is selected in particular, can we request extra fields to be filled but only for those 2 particulars?</div>\n<div>\n	- For &quot;Entertainment&quot;, please add: &quot;Persons Entertained&quot;, &quot;Company&quot;, &quot;Place&quot;, &quot;Business Purpose&quot;</div>\n<div>\n	- For &quot;Meeting&quot;, please add: &quot;Persons Attending&quot;, &quot;Place&quot;, &quot;Business Discussed&quot;</div>\n<div>\n	This is because on our paper based claim form, we need this extra information as below:</div>\n<div>\n	<img alt=\"image.png\" height=\"193\" src=\"data:image/png;base64,[encoded data, 25360 characters]\" width=\"472\" /></div>\n<div>\n	&nbsp;</div>\n<div>\n	&nbsp;</div>\n<div>\n	5. Is there a possibility of a &quot;copy application&quot; function?</div>\n<div>\n	<br />\n	&nbsp;</div>\n<p>\n	&nbsp;</p>\n', '2022-11-30 09:28:42', '', 'JOHN', 437, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-30 09:28:42', 69, '2023-04-12 14:37:54'),
(11767, 20061, '', '11767', 'E', 1, '<p>\n	E- Sell- KS01 (DB23) change date from 30/11/22 to 30/11/23</p>\n', '2022-11-30 10:17:15', '', 'JOHN', 182, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-30 10:17:15', 69, '2023-04-12 14:37:44'),
(11768, 20098, '', '11768', 'E', 1, '<p>\n	please change orange coloured AWB # 1Z8A4F130448426985-A<br />\n	See atatched image<br />\n	<br />\n	&nbsp;</p>\n', '2022-11-30 10:34:07', 'infinity301122.png', 'JOHN', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-30 10:34:07', 69, '2023-04-12 14:37:37'),
(11769, 20098, '', '11769', 'E', 1, '<p>\n	Infinity &ndash; Sales File No 26711, change customer name to PROTECH ELECTROMECH SOLUTIONS</p>\n<p>\n	&nbsp;</p>\n', '2022-11-30 14:14:51', '', 'JOHN', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-30 14:14:51', 69, '2023-04-12 14:37:30'),
(11938, 20138, '', '11938', 'E', 1, '<p>\n	Gratuity checking and explanation given to them</p>\n<p>\n	(see&nbsp; attached)</p>\n', '2023-03-15 16:40:34', 'Sourav EOS Details-2.pdf,WhatsApp Image 2023-03-15 at 2.52.01 PM.jpeg,EOS calculation - All Cargo.xlsx', 'JOHN', 413, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-03-15 16:40:34', 69, '2023-04-12 11:59:31'),
(11770, 20019, '', '11770', 'E', 5, '<p>\n	DEMO WORK</p>\n', '2022-12-05 09:43:07', '', 'Jubin Mathai', 56, 12, '2023-03-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-05 09:43:07', 69, '2023-03-31 07:42:53'),
(11771, 20125, '', '11771', 'E', 1, '<p>\n	Design and API Connectivity</p>\n', '2022-12-06 08:04:02', '', 'Jubin Mathai', 374, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-06 08:04:02', 69, '2023-03-27 12:41:48'),
(11772, 20098, '', '11772', 'E', 1, '<p>\n	<span style=\"font-size:14px;\">Please change the customer name to ( EIS ME for Oilfield Services and Equipment LLC) please change already created.</span></p>\n<p>\n	&nbsp;</p>\n<p>\n	Please see the attached Image.</p>\n', '2022-12-06 08:09:38', 'Infinity Logistics Error79.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-06 08:09:38', 69, '2023-04-12 14:37:23'),
(11773, 20019, '', '11773', 'E', 1, '<p>\n	Team Meeting</p>\n', '2022-12-06 09:02:33', '', 'Jubin Mathai', 56, 12, '2022-12-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-06 09:02:33', 613, '2022-12-08 08:26:31'),
(11780, 20154, '', '11780', 'E', 1, '<p>\n	Software Implementation</p>\n', '2022-12-09 20:56:38', '', 'mereenak', 461, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-09 20:56:38', 69, '2023-04-04 10:47:30'),
(11774, 20125, '', '11774', 'E', 1, '<div>\n	<span style=\"font-size:14px;\">API Purchase details</span></div>\n<div>\n	&nbsp;</div>\n<div>\n	<span style=\"font-size:14px;\">Youtube Video API</span></div>\n', '2022-12-06 09:11:35', '', 'Jubin Mathai', 374, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-06 09:11:35', 69, '2023-03-27 12:42:03'),
(11775, 20153, '', '11775', 'I', 2, '<p>\n	Software Implementation</p>\n', '2022-12-06 20:56:51', '', 'mereenak', 458, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-06 20:56:51', 69, '2023-03-28 10:34:18'),
(11776, 20014, '', '11776', 'I', 3, '<p>\n	Customer Issue: Double entry in exit voucher posting...</p>\n<p>\n	findings: Double entry found in same voucher numbers Entry, Exit and Payment Vouchers...</p>\n<p>\n	Solution suggested by Jisha: store-edit-ledger and unpost and post again causes double entry- should check</p>\n<p>\n	Bulk post and unpost in finance and sales also should check</p>\n', '2022-12-07 11:26:11', '', 'Habeeb', 41, 12, '2023-01-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-12-07 11:26:11', 69, '2023-01-19 10:03:42'),
(11777, 20067, '', '11777', 'E', 5, '<p>\n	Dashboard Changes</p>\n', '2022-12-08 07:34:21', '', 'Admin Bluesky', 200, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2022-12-08 07:34:21', 69, '2023-03-28 14:31:33'),
(11778, 20153, '', '11778', 'E', 1, '<p>\n	Software Implementation</p>\n', '2022-12-08 08:18:12', '', 'Jubin Mathai', 458, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-08 08:18:12', 69, '2023-03-28 10:34:33'),
(11779, 20152, '', '11779', 'E', 1, '<p>\n	EDUMATE - Software Implementation</p>\n', '2022-12-08 08:22:25', '', 'Jubin Mathai', 455, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-08 08:22:25', 69, '2023-03-28 10:35:26'),
(11781, 20021, '', '11781', 'E', 1, '<p>\n	Dlink - HR - Software Implementation with PDF correction</p>\n', '2022-12-09 20:59:14', '', 'mereenak', 62, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-09 20:59:14', 69, '2023-04-12 14:37:15'),
(11782, 20002, '', '11782', 'E', 1, '<p>\n	Please transfer below items from damage to Main inventory</p>\n<p>\n	113-11001204BL&nbsp; - 2 roll, 113-11001204YL &ndash; 1 Roll, 120-40001104GY&nbsp; - 1 roll</p>\n<p>\n	&nbsp;</p>\n<p>\n	Error in transaction details</p>\n', '2022-12-09 21:05:55', '', 'mereenak', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-09 21:05:55', 69, '2023-04-12 14:35:04'),
(11783, 20013, '', '11783', 'E', 1, '<div>\n	Dear CRM Team ,&nbsp;</div>\n<div>\n	Greetings,&nbsp;</div>\n<div>\n	Please assist to change the Cost Rate for the part number: D2CIM-DVUSB in CRM.&nbsp;</div>\n<div>\n	note: Correct cost rate per piece AED 343.70 only, instead of 10998.64.&nbsp;&nbsp;</div>\n<div>\n	Refer the below screen shot for more clarification.&nbsp;</div>\n<div>\n	right now, P/N: D2CIM-DVUSB &ndash; 32 qty in stock. So total stock value AED 10998.64 . Please update then, confirm upon made these changes in CRM.</div>\n', '2022-12-12 10:28:52', 'Topnet.png', 'Jubin Mathai', 38, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-12 10:28:52', 69, '2023-04-12 14:34:56'),
(11784, 20098, '', '11784', 'E', 1, '<p>\n	1Z8A4F13E578766965-A&nbsp; please add in AWB</p>\n<p>\n	&nbsp;</p>\n<p>\n	See the attached image.</p>\n', '2022-12-12 12:31:32', 'WhatsApp Image 2022-12-10 at 8.38.31 PM83.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-12 12:31:32', 69, '2023-04-12 14:33:16');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11785, 20124, '', '11785', 'E', 1, '<p>\n	Please removie<strong> Unit column from all invoice, sales order, quotation</strong>&nbsp;for the Print Page.</p>\n<p>\n	&nbsp;</p>\n<p>\n	See the attached Image</p>\n', '2022-12-12 12:44:09', 'WhatsApp Image 2022-12-10 at 1.08.33 PM.jpeg', 'Jubin Mathai', 371, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-12 12:44:09', 69, '2023-04-12 14:33:05'),
(11786, 20098, '', '11786', 'E', 1, '<p>\n	Customer has entered the actual cost as 250, they want us To check, why the planned cost has come to 350 to Mr. Mujaib, when the actual cost entered is 250.&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	See the attached image.&nbsp;</p>\n', '2022-12-12 13:29:36', 'Infinity-114.jpeg,Infinity-279.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-12 13:29:36', 69, '2023-04-12 14:32:57'),
(11835, 20157, '', '11835', 'E', 1, '<p>\n	Implementation and Data uploading</p>\n', '2023-01-09 17:29:07', '', 'Jubin Mathai', 470, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-09 17:29:07', 69, '2023-06-03 14:55:56'),
(11787, 20102, '', '11787', 'E', 1, '<p>\n	<strong>Software implementation</strong></p>\n', '2022-12-12 17:36:01', '', 'Jubin Mathai', 305, 2, '2023-11-13', 0, '0000-00-00', '', 0, '0', '', '30016', 0, 0, '', '', 613, '2022-12-12 17:36:01', 69, '2023-11-14 08:31:22'),
(11788, 20133, '', '11788', 'E', 1, '<p>\n	Software implementation</p>\n', '2022-12-12 17:37:31', '', 'Jubin Mathai', 398, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-12 17:37:31', 613, '2023-04-04 11:01:35'),
(11789, 20154, '', '11789', 'E', 1, '<p>\n	Copied edumate to new domain, Layout correction</p>\n', '2022-12-12 17:46:30', '', 'Jubin Mathai', 461, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-12 17:46:30', 69, '2023-03-28 10:35:53'),
(11790, 20124, '', '11790', 'E', 1, '<p>\n	Customer commented on some correction. Need to rectify.</p>\n', '2022-12-13 07:54:38', '', 'Jubin Mathai', 371, 12, '2023-06-30', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-13 07:54:38', 69, '2023-06-30 17:26:44'),
(11791, 20019, '', '11791', 'E', 1, '<p>\n	TEAM Meeting</p>\n', '2022-12-13 08:51:26', '', 'Jubin Mathai', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-13 08:51:26', 69, '2023-03-01 12:01:44'),
(11792, 20150, '', '11792', 'I', 2, '<p>\n	1. Create/Copy database from Dehnee staging ab name to QBRAK (Quick Bake - Ras Al Kaima Branch)</p>\n<p>\n	2. Connect EXE app to new link</p>\n<p>\n	3. connect andoid app to new link</p>\n<p>\n	4. create android app + exe api coordinate with manu</p>\n<p>\n	5. App need:</p>\n<p>\n	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; a. customer list+add and save</p>\n<p>\n	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; b. sales list + Add and save</p>\n<p>\n	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c. item list for sales add function</p>\n<p>\n	&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;d. delivery status and location for sales list function</p>\n<p>\n	&nbsp;</p>\n<p>\n	NB: 3 apps:&nbsp; exe app, Android apk and web</p>\n<p>\n	&nbsp;</p>\n', '2022-12-15 11:18:55', '', 'Habeeb', 448, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-12-15 11:18:55', 69, '2023-04-04 10:48:26'),
(11793, 20133, '', '11793', 'I', 3, '<p>\n	App:&nbsp;</p>\n<p>\n	1. order Edit in App: hang and crash - try non image window for edit function</p>\n<p>\n	2. items not showing in &quot;order&quot; while added throhg search window</p>\n<p>\n	3. do not update images while tab using mobile Data - try Sync image button to resolv ethis while using wifi/when they want</p>\n<p>\n	&nbsp;</p>\n', '2022-12-15 11:31:25', '', 'Habeeb', 398, 12, '2023-01-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-12-15 11:31:25', 69, '2023-01-19 10:03:35'),
(11794, 20151, '', '11794', 'I', 3, '<p>\n	Web:</p>\n<ol>\n	<li>\n		Dash board design as per their old pos - <strong>check mobile layout too</strong> - ref. Screen shot</li>\n	<li>\n		Rename warehouse master to &ldquo;branch&rdquo; master</li>\n	<li>\n		Each branch have different admin user details and connect to warehouses and employees</li>\n	<li>\n		Sales user authorization based on employee id in exe</li>\n	<li>\n		Branch settings include: <strong>ref: screen shot</strong>\n		<ol>\n			<li>\n				Maximum discount allowed</li>\n			<li>\n				Search mode enable &ndash; default barcode mode in exe</li>\n			<li>\n				Branch name</li>\n			<li>\n				Branch address</li>\n			<li>\n				Branch footer in printouts &ndash;exe pos print</li>\n			<li>\n				Logo for each branches</li>\n			<li>\n				Image as it is</li>\n			<li>\n				Bank sub ledger - default card payment</li>\n			<li>\n				Cash sub ledger - default cash payment</li>\n		</ol>\n	</li>\n	<li>\n		Cash or card payment edit after invoicing &ndash; will be do admin</li>\n	<li>\n		Credit note in web</li>\n	<li>\n		Branch wise user list</li>\n</ol>\n<p>\n	Exe App:</p>\n<ol>\n	<li>\n		Rename rounding to &lsquo;discount amount&rsquo;</li>\n	<li>\n		Rename &ldquo;save&rdquo; button to &lsquo;Submit&rsquo;</li>\n	<li>\n		Global Discount % and Discount Amount and calculate selling rate</li>\n	<li>\n		Sales man Code only while save- (Submit) invoice</li>\n	<li>\n		Default item selection based on branch settings</li>\n</ol>\n<p>\n	<strong>Create Branches and Employees in it</strong></p>\n<ol>\n	<li>\n		DCC</li>\n	<li>\n		SCC-DEHNEE</li>\n	<li>\n		SCC-DEORA</li>\n	<li>\n		SCC-AZEEZA</li>\n	<li>\n		SCC-TESORI</li>\n	<li>\n		SHCC-DEHNEE</li>\n	<li>\n		SHCC-DEORA</li>\n	<li>\n		SHCC-SHOP-DEHNEE</li>\n	<li>\n		SHCC-TESORI</li>\n	<li>\n		DFC</li>\n	<li>\n		IBN</li>\n	<li>\n		ACC-DEHNEE</li>\n	<li>\n		ACC-DEORA</li>\n</ol>\n<p>\n	NB: Employee list and screen shot added for reference&hellip;</p>\n', '2022-12-15 11:57:17', 'WhatsApp Image 2022-12-13 at 3.12.01 PM.jpeg,WhatsApp Image 2022-12-13 at 3.28.18 PM.jpeg,SALES STAFF LIST - DECEMBER.xlsx', 'Habeeb', 451, 12, '2023-01-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 617, '2022-12-15 11:57:17', 69, '2023-01-19 10:02:50'),
(11795, 20151, '', '11795', 'I', 2, '<p>\n	HR Implementation</p>\n', '2022-12-15 17:05:44', '', 'Admin Bluesky', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2022-12-15 17:05:44', 69, '2023-04-12 14:32:47'),
(11796, 20074, '', '11796', 'E', 3, '<p>\n	Please note that the staff can see that the leave taken is <strong>18, </strong>please refer to the below screenshot taken from the HRMS:</p>\n<p>\n	However, we can see(below is the Leave Ledger) total of <strong>33 leaves</strong> were taken out of which 10 were later cancelled which still makes it<strong>23.<br />\n	Mail dated 15/12/2022</strong><br />\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-12-15 17:28:59', '', 'Admin Bluesky', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2022-12-15 17:28:59', 69, '2023-04-12 12:33:25'),
(11797, 20124, '', '11797', 'E', 1, '<p>\n	Error Rectification</p>\n', '2022-12-16 16:56:16', '', 'Jubin Mathai', 371, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-16 16:56:16', 613, '2023-04-04 11:02:06'),
(11798, 20153, '', '11798', 'E', 1, '<p>\n	Reports Generation.&nbsp;</p>\n', '2022-12-16 16:57:43', '', 'Jubin Mathai', 458, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-16 16:57:43', 69, '2023-03-28 10:37:09'),
(11799, 20151, '', '11799', 'E', 1, '<p>\n	Modification/Rectification</p>\n', '2022-12-16 17:00:19', '', 'Jubin Mathai', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-16 17:00:19', 69, '2023-04-12 15:19:10'),
(11800, 20019, '', '11800', 'E', 1, '<p>\n	TEAM MEETING</p>\n', '2022-12-20 09:29:37', '', 'Jubin Mathai', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-20 09:29:37', 69, '2023-03-01 12:01:54'),
(11801, 20098, '', '11801', 'E', 1, '<p>\n	1.&nbsp;please change airway to GB005449-A// Job 6310</p>\n<p>\n	2.&nbsp;please change the customer name to ( HBI MIDDLE EAST FZE)</p>\n<p>\n	See Image Attached</p>\n', '2022-12-20 17:53:24', 'WhatsApp Image 2022-12-20 at 4.44.47 PM.jpeg,WhatsApp Image 2022-12-19 at 6.38.34 PM.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-20 17:53:24', 69, '2023-04-12 12:33:17'),
(11802, 20117, '', '11802', 'E', 1, '<p>\n	Print Screen Generation - Additional&nbsp;</p>\n', '2022-12-21 16:46:24', '', 'Jubin Mathai', 350, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-21 16:46:24', 613, '2023-04-04 11:02:24'),
(11803, 20002, '', '11803', 'E', 1, '<p>\n	App related</p>\n', '2022-12-21 16:47:47', '', 'Jubin Mathai', 5, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-21 16:47:47', 613, '2023-04-04 11:02:48'),
(11804, 20013, '', '11804', 'E', 1, '<div>\n	Please assist to cancel the highlighted item and quantity in material receipt and quality check and return to open status(partial) in purchased order 603430.</div>\n<div>\n	&nbsp;</div>\n<div>\n	Material receipt details:</div>\n<div>\n	Material Receipt: 36655 (stores)</div>\n<div>\n	&nbsp;</div>\n<div>\n	&nbsp;</div>\n<div>\n	Quality check details:</div>\n<div>\n	Material Receipt: 704661 (QC)</div>\n<div>\n	&nbsp;</div>\n<div>\n	Image Attached</div>\n', '2022-12-22 11:40:15', 'Topnet96.png', 'Jubin Mathai', 38, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-22 11:40:15', 69, '2023-04-12 12:33:05'),
(11805, 20019, '', '11805', 'E', 1, '<p>\n	Stock Check- Software implementation</p>\n', '2022-12-22 11:45:11', '', 'Jubin Mathai', 56, 12, '2023-01-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-22 11:45:11', 69, '2023-01-20 08:38:50'),
(11806, 20019, '', '11806', 'E', 1, '<p>\n	Software Implementation - Stock</p>\n', '2022-12-22 21:39:52', '', 'mereenak', 56, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-22 21:39:52', 69, '2023-03-28 14:42:46'),
(11849, 20150, '', '11849', 'E', 1, '<p>\n	Software changes</p>\n', '2023-01-20 09:11:49', '', 'JOHN', 449, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-20 09:11:49', 69, '2023-06-03 14:52:15'),
(11807, 20098, '', '11807', 'E', 1, '<p>\n	please change the name to the below mentioned address, address already added</p>\n<p>\n	&nbsp;</p>\n<p>\n	Images Uploaded</p>\n', '2022-12-27 15:53:30', 'WhatsApp Image 2022-12-27 at 10.53.54 AM.jpeg,WhatsApp Image 2022-12-27 at 10.54.13 AM.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-27 15:53:30', 69, '2023-04-12 12:32:57'),
(11808, 20019, '', '11808', 'I', 2, '<p>\n	HR Implementation In Edumate</p>\n', '2022-12-28 16:59:57', '', 'Admin Bluesky', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2022-12-28 16:59:57', 69, '2023-04-12 12:32:50'),
(11809, 20151, '', '11809', 'E', 1, '<div>\n	master s-&gt;warehouse changes&nbsp; and invoice edit -&gt; API Changes</div>\n<div>\n	&nbsp;</div>\n', '2022-12-29 17:48:49', '', 'Jubin Mathai', 452, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-29 17:48:49', 613, '2023-04-04 11:04:06'),
(11810, 20019, '', '11810', 'I', 1, '<p>\n	Registration from other site to hrms for recruitment</p>\n', '2022-12-29 17:50:36', '', 'mereenak', 56, 12, '2023-05-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-29 17:50:36', 69, '2023-05-15 17:41:32'),
(11811, 20098, '', '11811', 'E', 1, '<p>\n	1. Kindly add the option from trial balance we nedd to export the receivables to excel format please do it urgently</p>\n<p>\n	2. please change the name from this to <span style=\"white-space: pre;\"> </span>(TLM INTERNATIONAL FREIGHT SERVICES) already have the name - Image attached</p>\n<p>\n	3.please remove the item orange marked because already another job created, please do it - Image attached</p>\n<div>\n	&nbsp;</div>\n', '2022-12-29 17:51:07', 'WhatsApp Image 2022-12-29 at 12.37.30 PM.jpeg,WhatsApp Image 2022-12-28 at 6.16.14 PM.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-29 17:51:07', 69, '2023-04-12 12:32:44');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11813, 20098, '', '11813', 'I', 1, '<div>\n	please change the name from this to <span style=\"white-space:pre\"> </span>(TLM INTERNATIONAL FREIGHT SERVICES) already have the name</div>\n<div>\n	&nbsp;</div>\n<div>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65323 characters]', '2022-12-29 18:29:09', '', 'mereenak', 293, 12, '2023-04-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-29 18:29:09', 69, '2023-04-15 07:50:35');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11812, 20002, '', '11812', 'E', 1, '<p>\n	Please transfer the below damage stock item to mail inventory as we need to drop the same.</p>\n<p>\n	&nbsp;</p>\n<p>\n	Transaction no.</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:68px;\" width=\"0\">\n	<tbody>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200029</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200028</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200027</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200026</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200025</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200024</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:68px;height:20px;\">\n				<p align=\"center\">\n					200030</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2022-12-29 17:53:09', 'Copy of TO DROP - 19.12.22.xlsx', 'mereenak', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-12-29 17:53:09', 69, '2023-04-12 12:32:35'),
(11814, 20155, '', '11814', 'E', 1, '<p>\n	Report Generation&nbsp;</p>\n', '2022-12-30 13:12:03', '', 'Jubin Mathai', 464, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-30 13:12:03', 69, '2023-04-04 10:48:52'),
(11815, 20150, '', '11815', 'E', 1, '<p>\n	Report Generation</p>\n', '2022-12-30 13:13:25', '', 'Jubin Mathai', 449, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2022-12-30 13:13:25', 613, '2023-04-04 11:04:24'),
(11816, 20098, '', '11816', 'E', 1, '<p>\n	Please see the image attached</p>\n<p>\n	1.&nbsp; kindly cancell this invoice already another job created</p>\n<p>\n	2. so actual purchase cost AED 3044+ AED 125 = AED 3169 but showing only AED 3044 please clear</p>\n<div>\n	&nbsp;</div>\n<div>\n	&nbsp;</div>\n', '2023-01-02 15:52:04', 'WhatsApp Image 2022-12-30 at 12.30.39 PM.jpeg,WhatsApp Image 2023-01-02 at 1.46.20 PM.jpeg,WhatsApp Image 2023-01-02 at 1.47.34 PM.jpeg,WhatsApp Image 2023-01-02 at 1.46.21 PM.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-02 15:52:04', 69, '2023-04-12 12:32:15'),
(11817, 20098, '', '11817', 'E', 1, '<div>\n	Kindly add the option from trial balance we need to export the receivables to excel format please do it urgently</div>\n<div>\n	&nbsp;</div>\n', '2023-01-02 15:54:23', '', 'Jubin Mathai', 293, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-02 15:54:23', 613, '2023-04-04 11:04:43'),
(11818, 20019, '', '11818', 'E', 1, '<p>\n	Training and Awareness of Yii Framework</p>\n', '2023-01-02 16:27:12', '', 'Jubin Mathai', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-02 16:27:12', 69, '2023-04-12 12:32:08'),
(11819, 20150, '', '11819', 'E', 1, '<p>\n	Correction on account module</p>\n', '2023-01-02 16:29:27', '', 'Jubin Mathai', 449, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-02 16:29:27', 69, '2023-06-03 14:53:26'),
(11820, 20151, '', '11820', 'E', 1, '<p>\n	Correction on Account Module - Staging</p>\n', '2023-01-02 16:30:39', '', 'Jubin Mathai', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-02 16:30:39', 69, '2023-04-12 15:19:24'),
(11821, 20067, '', '11821', 'E', 1, '<p>\n	Corrections on account module</p>\n', '2023-01-02 16:31:22', '', 'Jubin Mathai', 200, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-02 16:31:22', 613, '2023-04-04 11:05:35'),
(11822, 20071, '', '11822', 'E', 5, '<p>\n	Leave Updation Mail date 2/1/2023</p>\n', '2023-01-02 16:44:45', '', 'Admin Bluesky', 212, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2023-01-02 16:44:45', 69, '2023-04-12 12:32:00'),
(11823, 20074, '', '11823', 'E', 5, '<p>\n	Leave Updation Mail date 2/1/2023</p>\n', '2023-01-02 16:45:18', '', 'Admin Bluesky', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2023-01-02 16:45:18', 69, '2023-04-12 12:31:51'),
(11824, 20067, '', '11824', 'E', 5, '<p>\n	Salary change of Asif</p>\n', '2023-01-02 16:47:15', '', 'Admin Bluesky', 200, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2023-01-02 16:47:15', 69, '2023-04-12 12:31:41'),
(11825, 20019, '', '11825', 'E', 1, '<p>\n	TEAM MEETING&nbsp;</p>\n', '2023-01-03 09:11:41', '', 'Jubin Mathai', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-03 09:11:41', 69, '2023-03-01 12:02:21'),
(11826, 20151, '', '11826', 'E', 1, '<div>\n	Development of windows and Android App</div>\n<div>\n	&nbsp;</div>\n', '2023-01-04 07:29:45', '', 'Jubin Mathai', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-04 07:29:45', 69, '2023-04-12 15:19:34'),
(11827, 20150, '', '11827', 'E', 1, '<div>\n	Development of windows and Android App</div>\n<div>\n	&nbsp;</div>\n', '2023-01-04 07:30:51', '', 'Jubin Mathai', 449, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-04 07:30:51', 69, '2023-06-03 14:52:52'),
(11828, 20150, '', '11828', 'E', 1, '<p>\n	Direct Transfer convert issue</p>\n', '2023-01-04 16:32:27', '', 'Jubin Mathai', 449, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-04 16:32:27', 69, '2023-04-12 12:31:36'),
(11829, 20067, '', '11829', 'E', 1, '<p>\n	Query Optimization</p>\n', '2023-01-04 16:33:48', '', 'Jubin Mathai', 200, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-04 16:33:48', 613, '2023-04-04 11:05:53'),
(11830, 20098, '', '11830', 'E', 1, '<div>\n	kindly change the forwarder name from infinity logistics to europa</div>\n<div>\n	please change</div>\n<div>\n	&nbsp;</div>\n<div>\n	2.&nbsp;ONLY UPDATED aed 818.02 SO PLEASE REQUESTED TO REMOVE aed 680</div>\n<p>\n	Please see the image attached.</p>\n', '2023-01-04 16:38:00', 'Infinity1.jpeg,infinity2.jpeg,WhatsApp Image 2023-01-03 at 7.37.41 PM.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-04 16:38:00', 69, '2023-04-12 12:31:30'),
(11831, 20019, '', '11831', 'E', 1, '<p>\n	Design and API Implementation of Support Service- For Mobile App</p>\n', '2023-01-04 17:32:54', '', 'Jubin Mathai', 56, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-04 17:32:54', 613, '2023-04-04 11:05:14'),
(11832, 20156, '', '11832', 'E', 1, '<p>\n	Implementation</p>\n', '2023-01-05 14:33:08', '', 'Jubin Mathai', 467, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-05 14:33:08', 69, '2023-04-12 12:31:23'),
(11833, 20098, '', '11833', 'E', 1, '<p>\n	New Modification on Reports&nbsp;</p>\n', '2023-01-09 07:24:41', '', 'Jubin Mathai', 293, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-09 07:24:41', 69, '2023-04-04 09:50:59'),
(11834, 20156, '', '11834', 'E', 1, '<p>\n	Layout Correction&nbsp;</p>\n', '2023-01-09 07:26:06', '', 'Jubin Mathai', 467, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-09 07:26:06', 69, '2023-04-12 12:31:13'),
(11836, 20133, '', '11836', 'E', 1, '<p>\n	Query Optimization + Stock Updation</p>\n', '2023-01-09 20:58:11', '', 'mereenak', 398, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-09 20:58:11', 69, '2023-03-28 14:41:40'),
(11837, 20019, '', '11837', 'E', 1, '<p>\n	Team Meeting</p>\n', '2023-01-10 10:06:15', '', 'Jubin Mathai', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-10 10:06:15', 69, '2023-03-01 12:02:36'),
(11838, 20098, '', '11838', 'E', 1, '<p>\n	1. kindly change the forwarder name from infinity logistics to europa - please change</p>\n<p>\n	2.&nbsp;KINDLY REMOVE ORANGE MARKED LINE</p>\n<p>\n	&nbsp;</p>\n<p>\n	Please see the image</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2023-01-10 16:19:02', 'WhatsApp Image 2023-01-05 at 2.54.51 PM.jpeg,WhatsApp Image 2023-01-10 at 3.09.15 PM.jpeg', 'Jubin Mathai', 293, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-10 16:19:02', 613, '2023-04-12 07:36:15'),
(11839, 20151, '', '11839', 'I', 1, '<p style=\"margin-left:27.0pt;\">\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Goods receipt warehouse</p>\n<p style=\"margin-left:27.0pt;\">\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Goods receipts Qty update</p>\n<p style=\"margin-left:27.0pt;\">\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Goods receipts cost update</p>\n<p style=\"margin-left:27.0pt;\">\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purchase order approval level</p>\n<p style=\"margin-left:27.0pt;\">\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purchase order notification &ndash; discuss with arun sir</p>\n<p style=\"margin-left:27.0pt;\">\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Selling price and cost in inventory</p>\n<p style=\"margin-left:27.0pt;\">\n	7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Design - Printouts for delivery transfer</p>\n<p style=\"margin-left:27.0pt;\">\n	8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Show created date &amp; time in invoice grid</p>\n<p style=\"margin-left:27.0pt;\">\n	9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Show only current warehouse qty in branch POS &ndash; APP (API)</p>\n<p style=\"margin-left:27.0pt;\">\n	10.&nbsp;&nbsp; Deposited to bank amount in commission report should minus card payment too</p>\n<p style=\"margin-left:27.0pt;\">\n	11.&nbsp;&nbsp; Serial number continuation in all grids -&gt; invoice, inventory and purchases/PO- pending invoice and purchase order</p>\n<p style=\"margin-left:27.0pt;\">\n	12.&nbsp;&nbsp; Serial number continuation in current stock report</p>\n<p style=\"margin-left:27.0pt;\">\n	13.&nbsp;&nbsp; Barcode unique and put a random number</p>\n<p style=\"margin-left:27.0pt;\">\n	14.&nbsp;&nbsp; Barcode printing in ERP- discuss with arun sir &ndash;Please check</p>\n<p style=\"margin-left:27.0pt;\">\n	15.&nbsp;&nbsp; Check negative stock &ndash; MAO-8002 (Transaction details report and warehouse stock) &ndash; APP API &ndash;ve stock</p>\n<p style=\"margin-left:27.0pt;\">\n	16.&nbsp;&nbsp; Item wise sales report check (rate amount change and put net amount as per commission report)</p>\n<p style=\"margin-left:27.0pt;\">\n	17.&nbsp;&nbsp; Commission report add card amount and deposit to bank</p>\n<p>\n	<br />\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2023-01-10 21:03:19', '', 'mereenak', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-10 21:03:19', 69, '2023-04-12 15:19:51'),
(11840, 20119, '', '11840', 'E', 1, '<p>\n	API and Survey Report</p>\n', '2023-01-11 17:16:50', '', 'Jubin Mathai', 356, 12, '2023-07-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-11 17:16:50', 69, '2023-07-01 17:28:09'),
(11841, 20106, '', '11841', 'E', 1, '<p>\n	Stock Issue + Report Correction</p>\n', '2023-01-16 20:47:38', '', 'mereenak', 317, 12, '2023-07-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-16 20:47:38', 69, '2023-07-01 17:28:42'),
(11842, 20098, '', '11842', 'E', 1, '<p>\n	Infinity Software&nbsp; Joborder + Invoice orrection</p>\n', '2023-01-16 20:51:50', '', 'mereenak', 293, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-16 20:51:50', 69, '2023-03-28 14:43:38'),
(11922, 20001, '', '11922', 'I', 1, '<p>\n	Canceleed leave, couldnt marked that days attendance</p>\n', '2023-03-04 08:11:27', '', 'JOHN', 2, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-03-04 08:11:27', 69, '2023-04-12 12:00:41'),
(11843, 20074, '', '11843', 'E', 2, '<p>\n	Month to Month Report</p>\n<p>\n	Annual Leave and complementary leave for Harsha</p>\n<p>\n	Report for leave with opening,addition/deduction,Balance</p>\n', '2023-01-17 06:42:20', '', 'Admin Bluesky', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2023-01-17 06:42:20', 69, '2023-04-12 12:31:03'),
(11844, 20019, '', '11844', 'E', 1, '<p>\n	Team Meeting.</p>\n', '2023-01-17 09:00:57', '', 'Jubin Mathai', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-17 09:00:57', 69, '2023-03-01 12:02:46'),
(11845, 20065, '', '11845', 'E', 2, '<ol>\n	<li>\n		Biometrics zkteco attendance system &ndash;</li>\n	<li>\n		Competency management module -</li>\n	<li>\n		New Version of Appraisal -</li>\n	<li>\n		Attendance for salary process to be taken from 21<sup>st</sup> to 20<sup>th</sup> every month.</li>\n	<li>\n		OT hours after 9PM to be calculated as 1.5times the basic (same as holiday OT).</li>\n	<li>\n		OT hours on weekend and holidays to be considered with one hour break if it is above 6 hours.</li>\n	<li>\n		Religious leave not showing in employee attendance in ESS portal</li>\n</ol>\n<p>\n	&nbsp;</p>\n', '2023-01-19 07:46:21', '', 'Admin Bluesky', 194, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 580, '2023-01-19 07:46:21', 69, '2023-03-28 14:42:11'),
(11846, 20021, '', '11846', 'E', 1, '<p>\n	Product Saving issue</p>\n', '2023-01-19 20:42:39', '', 'mereenak', 62, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-19 20:42:39', 69, '2023-04-12 12:30:57'),
(11847, 20131, '', '11847', 'E', 1, '<p>\n	Mohbat Wordpress Site</p>\n', '2023-01-19 20:43:02', '', 'mereenak', 392, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-19 20:43:02', 69, '2023-03-28 14:43:17'),
(11848, 20120, '', '11848', 'E', 1, '<p>\n	Perfume unlimited - Stock checking</p>\n', '2023-01-20 07:57:46', '', 'JOHN', 359, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-20 07:57:46', 69, '2023-03-28 14:34:44'),
(11850, 20061, '', '11850', 'E', 1, '<p>\n	Date changing (Subscriber end date )</p>\n', '2023-01-20 09:13:08', '', 'JOHN', 182, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-20 09:13:08', 69, '2023-03-28 14:32:30'),
(11851, 20019, '', '11851', 'E', 1, '<p>\n	Visitor Management App</p>\n', '2023-01-20 09:14:31', '', 'JOHN', 56, 12, '2023-10-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-20 09:14:31', 69, '2023-10-11 10:35:38'),
(11852, 20106, '', '11852', 'E', 1, '<p>\n	On purchase return, should work even whne only service item exists</p>\n', '2023-01-20 09:56:51', '', 'JOHN', 317, 12, '2023-10-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-20 09:56:51', 69, '2023-10-14 11:01:34'),
(11853, 20002, '', '11853', 'I', 1, '<p>\n	Stock issue mails</p>\n<p>\n	18/01/23</p>\n<p>\n	19/01/23</p>\n', '2023-01-20 10:06:48', '', 'JOHN', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-20 10:06:48', 69, '2023-04-12 12:30:50'),
(11854, 20133, '', '11854', 'E', 1, '<p>\n	increase speed to list product and new api to get all images in product and generic</p>\n', '2023-01-21 15:02:16', '', 'JOHN', 398, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-21 15:02:16', 69, '2023-03-28 10:36:12'),
(11855, 20158, '', '11855', 'E', 1, '<p>\n	HR Installation</p>\n', '2023-01-23 11:48:42', '', 'JOHN', 473, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-23 11:48:42', 69, '2023-04-04 10:49:28'),
(11856, 20013, '', '11856', 'I', 1, '<p>\n	In reportsof Sales Quotation, Order and Invoice, show project reference</p>\n', '2023-01-23 17:09:23', '', 'JOHN', 38, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-23 17:09:23', 69, '2023-04-12 12:30:40'),
(11857, 20065, '', '11857', 'E', 1, '<p>\n	The staff Arun Sasidharan, M10019 is not able to see the action icon to apply for Annual leave</p>\n<p>\n	&nbsp;</p>\n<p>\n	Also, can you pls change&nbsp; the expenses claim of Wasi, W80012 to Sajeev John ESS</p>\n<p>\n	&nbsp;</p>\n', '2023-01-23 17:11:04', '', 'JOHN', 194, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-23 17:11:04', 69, '2023-04-12 12:30:32'),
(11858, 20074, '', '11858', 'I', 1, '<p>\n	Mails dt 24/01/2023 regarding AMA advertising</p>\n<p>\n	+</p>\n<p>\n	AMA steffy old componesate 10 - 3 taken, it should be 7, but showing 4</p>\n', '2023-01-24 17:13:28', '', 'JOHN', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-24 17:13:28', 69, '2023-04-12 12:29:57'),
(11859, 20067, '', '11859', 'I', 1, '<p>\n	eos paymnt status updation</p>\n', '2023-01-24 17:14:22', '', 'JOHN', 200, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-24 17:14:22', 69, '2023-04-12 12:29:50'),
(11860, 20146, '', '11860', 'E', 1, '<p>\n	Mail dt 23/01/2023</p>\n', '2023-01-24 17:15:40', '', 'JOHN', 437, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-24 17:15:40', 69, '2023-04-12 12:29:39'),
(11861, 20074, '', '11861', 'E', 1, '<p>\n	It&rsquo;s a good report &ndash; would suggest it as a salary statement &ndash; can we have option to select dates for 6 months and upto one year.</p>\n<p>\n	Name, Designation, date of joining, department, &nbsp;entity and employee number are some of the crucial elements.</p>\n<p>\n	(Mail dated 20 jan 2023)</p>\n', '2023-01-25 07:37:59', '', 'JOHN', 221, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-25 07:37:59', 69, '2023-03-28 10:36:41'),
(11862, 20098, '', '11862', 'I', 1, '<p>\n	1. Trial Balance Report is loading slow<br />\n	Jubin, 12:31<br />\n	2. Sending SOA from software is not working<br />\n	3. Please add filter(sales person) in receivable aging<br />\n	4. Receivable aging should automatically have a red font depending on the credit limit of the client<br />\n	5.can we have seperate module for Petty Cash<br />\n	6. Notes for Nipin -&gt; overlimit customer to stop<br />\n	7. Need upload option in finance for IV and other entry<br />\n	8. Credit note not showing in SOA</p>\n', '2023-01-27 16:41:24', '', 'JOHN', 293, 12, '2023-10-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-27 16:41:24', 69, '2023-10-14 11:00:44'),
(11863, 20019, '', '11863', 'E', 1, '<p>\n	Latest HR&nbsp; support</p>\n', '2023-01-27 16:49:00', '', 'JOHN', 56, 11, '2024-01-02', 0, '0000-00-00', '', 0, '0', '', '30035', 0, 0, '', '', 69, '2023-01-27 16:49:00', 613, '2024-01-02 14:26:46'),
(11864, 20019, '', '11864', 'E', 1, '<p>\n	Awasi Moved to blueskyerp.me</p>\n<p>\n	Alaqsar correction</p>\n', '2023-01-28 22:03:44', '', 'mereenak', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-28 22:03:44', 69, '2023-04-12 12:29:33'),
(11865, 20131, '', '11865', 'E', 1, '<p>\n	Mohbat word press</p>\n', '2023-01-28 22:05:24', '', 'mereenak', 392, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-01-28 22:05:24', 69, '2023-03-28 14:33:27'),
(11866, 20019, '', '11866', 'E', 1, '<p>\n	Erp2023<br />\n	<br />\n	Module creation and error correction assigned by meerna mam</p>\n', '2023-01-30 07:32:16', '', 'JOHN', 56, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-30 07:32:16', 69, '2023-03-28 14:32:48'),
(11867, 20151, '', '11867', 'E', 1, '<p>\n	Please find the below points to be sorted out as per our discussions.<br />\n	<br />\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Commission report: salesman report to be clubbed as user wise.<br />\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sample transfer option to be active along with direct transfer.<br />\n	3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Good issue report &ndash; branch wise &ndash; issue type &ndash; sample &ndash; Not generating<br />\n	4.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Purchase requisition approval:-View option to be enable for Aziz &amp; APP<br />\n	5.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; View option to be assigned for sales managers as branch wise.<br />\n	6.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Current Stock report &amp; Direct transfer list subtotal quantity to view in grid &amp; pdf &amp; excel.<br />\n	7.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; POS system loading issue / slow (PENDING) New APP to be installed.<br />\n	8.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Stock reports restrict the view by store wise qty only<br />\n	9.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; POS &ndash; current stock subtotal to be view. Exporting option to be available (PDF &amp; Excel)<br />\n	10.&nbsp;&nbsp; Barcode issues, barcode reading but product not loading in store.<br />\n	11.&nbsp;&nbsp; Barcode auto generate to be activate. &ndash; Done.<br />\n	12.&nbsp;&nbsp; Barcode printing &ndash; Heading master (Deora, Dehnee, Tesori, Azeeza, etc)<br />\n	13.&nbsp;&nbsp; Barcode punching complain is sometimes from the stores.<br />\n	14.&nbsp;&nbsp; Stock movement report &ndash; Mandatory<br />\n	15.&nbsp;&nbsp; Negative stock is not still fixed in the system and still negative stock is appearing in the system. &ndash; Done<br />\n	16.&nbsp;&nbsp; Selling price not generating automatically.<br />\n	17.&nbsp;&nbsp; Reorder level<br />\n	18.&nbsp;&nbsp; HR Timing &ndash; POS .. HR Module to be implement . New Scope.<br />\n	19.&nbsp;&nbsp; Search box in sales -show salesman name only in the particular store.<br />\n	20.&nbsp;&nbsp; Discount % Password Option t<br />\n	21.&nbsp;&nbsp; Discount product wise : TO BE DISCUSSED , initially it was there as per sales manager &amp; MD requirement it was removed.<br />\n	22.&nbsp;&nbsp; Bank transfer option for online sales. Payment type.<br />\n	23.&nbsp;&nbsp; New APP to be installed in all stores.<br />\n	24.&nbsp;&nbsp; Goods receipt &ndash; item wise report.<br />\n	25.&nbsp;&nbsp; Bank transfer option for online sales. Payment type.<br />\n	26.&nbsp;&nbsp; Goods issue report / receipt report not loading<br />\n	27.&nbsp;&nbsp; No Tax &ndash; Import<br />\n	28.&nbsp;&nbsp; Finance voucher &ndash; timewise<br />\n	29.&nbsp;&nbsp; Ledger &ndash; Delete button.<br />\n	30.&nbsp;&nbsp; Voucher delete line item.<br />\n	31.&nbsp;&nbsp; Voucher do not save without sub ledger if sub ledger is enabled in ledger.</p>\n', '2023-01-30 12:38:51', '', 'JOHN', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-30 12:38:51', 69, '2023-04-12 15:20:02'),
(11868, 20159, '', '11868', 'E', 1, '<p>\n	Design and implementation for Restaurant App&nbsp;</p>\n', '2023-01-30 17:00:54', '', 'Jubin Mathai', 476, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 613, '2023-01-30 17:00:54', 69, '2023-03-28 14:33:44'),
(11869, 20106, '', '11869', 'E', 1, '<p>\n	Dashboard correction</p>\n', '2023-01-31 08:06:33', '', 'JOHN', 317, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-31 08:06:33', 69, '2023-03-28 14:33:59'),
(11870, 20057, '', '11870', 'E', 1, '<p>\n	Changes as per mail</p>\n', '2023-01-31 14:59:34', '', 'JOHN', 170, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-31 14:59:34', 69, '2023-04-12 12:29:27'),
(11871, 20018, '', '11871', 'E', 1, '<p>\n	Logo and colour change</p>\n', '2023-01-31 15:00:54', '', 'JOHN', 53, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-31 15:00:54', 69, '2023-04-12 12:29:21'),
(11872, 20061, '', '11872', 'E', 1, '<p>\n	Hamdy01 date esell changed from 01/02/2023 to01/02/2024</p>\n<p>\n	As per AJV and Habeeb phone call</p>\n', '2023-01-31 15:07:29', '', 'JOHN', 182, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-31 15:07:29', 69, '2023-04-12 12:29:16'),
(11873, 20019, '', '11873', 'E', 1, '<p>\n	Team Meeting 31/01/2023</p>\n', '2023-01-31 16:19:18', '', 'JOHN', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-31 16:19:18', 69, '2023-03-01 12:02:57'),
(11874, 20061, '', '11874', 'E', 1, '<p>\n	Change BH103 DB No 56 date from 01/02/2023 to 01/02/2024</p>\n', '2023-01-31 17:50:09', '', 'JOHN', 182, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-01-31 17:50:09', 69, '2023-04-12 12:29:09'),
(11875, 20018, '', '11875', 'E', 1, '<p>\n	Nia Support</p>\n', '2023-02-01 07:39:37', '', 'JOHN', 53, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-01 07:39:37', 69, '2023-03-28 14:34:15'),
(11876, 20118, '', '11876', 'E', 1, '<p>\n	Salary calculation change</p>\n', '2023-02-01 07:49:31', 'example(2).xlsx', 'JOHN', 353, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-01 07:49:31', 69, '2023-04-12 12:29:04'),
(11877, 20065, '', '11877', 'E', 1, '<p>\n	Appraisal - changing dates etc</p>\n', '2023-02-01 07:51:46', '', 'JOHN', 194, 12, '2023-03-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-01 07:51:46', 69, '2023-03-31 12:19:51');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11878, 20002, '', '11878', 'E', 1, '<p>\n	Qty change in QC</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65465 characters]', '2023-02-01 17:15:40', '', 'JOHN', 5, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-01 17:15:40', 69, '2023-06-03 15:11:01');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11879, 20061, '', '11879', 'E', 1, '<p>\n	E Sell BH 138 ; DB 57 change date from 01/02/2023 to 01/02/2024</p>\n', '2023-02-02 14:09:18', '', 'JOHN', 182, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-02 14:09:18', 69, '2023-04-12 12:28:56'),
(11880, 20098, '', '11880', 'E', 1, '<p>\n	API</p>\n', '2023-02-06 08:45:28', '', 'JOHN', 293, 12, '2023-04-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-06 08:45:28', 69, '2023-04-14 11:07:42'),
(11881, 20036, '', '11881', 'E', 1, '<p>\n	As per mail</p>\n', '2023-02-06 08:45:55', '', 'JOHN', 107, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-06 08:45:55', 69, '2023-04-12 12:28:48'),
(11882, 20097, '', '11882', 'E', 1, '<p>\n	Print Design - Proforma Invoice &amp; Invoice</p>\n', '2023-02-06 20:44:34', '', 'mereenak', 290, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-02-06 20:44:34', 69, '2023-04-12 12:28:41'),
(11883, 20019, '', '11883', 'E', 1, '<p>\n	Team Meeting 07/02/23</p>\n', '2023-02-07 14:00:22', '', 'JOHN', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-07 14:00:22', 69, '2023-03-01 12:03:06'),
(11884, 20116, '', '11884', 'E', 1, '<p>\n	9084 - Abdul Kashem, there is no overtime from 02/01 to 16/01?<br />\n	Same for 2160 - Abdur Rahim</p>\n', '2023-02-07 17:04:01', '', 'JOHN', 347, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-07 17:04:01', 69, '2023-04-12 12:02:31'),
(11885, 20013, '', '11885', 'I', 1, '<p class=\"MsoNormal\">\n	Kindly give customer details edit function to ms Rosenn, where as per the below screen the option not available</p>\n<p class=\"MsoNormal\">\n	&nbsp;Kindly do the needful to give access in FZCO CRM AND LLC CRM . &nbsp;</p>\n<p class=\"MsoNormal\">\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2023-02-08 08:09:20', '', 'JOHN', 38, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-08 08:09:20', 69, '2023-04-12 12:02:14'),
(11886, 20019, '', '11886', 'E', 1, '<p>\n	HR ommon issue<br />\n	Document Expiry Status issues<br />\n	Delete</p>\n', '2023-02-08 14:18:09', '', 'JOHN', 56, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-08 14:18:09', 69, '2023-03-28 14:39:57'),
(11887, 20137, '', '11887', 'E', 1, '<p>\n	Issue / delivery note mapping and allocation</p>\n', '2023-02-08 20:48:21', '', 'mereenak', 410, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-02-08 20:48:21', 69, '2023-06-03 15:10:18'),
(11888, 20071, '', '11888', 'E', 1, '<p>\n	Mobile App Development - Viola</p>\n', '2023-02-11 08:30:22', '', 'JOHN', 212, 12, '2023-10-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-11 08:30:22', 69, '2023-10-11 10:36:24'),
(11889, 20021, '', '11889', 'E', 1, '<p>\n	Can you please change all the links of http://tools.dlink.com&nbsp; to be&nbsp; https://tools.dlink.com</p>\n<p>\n	&nbsp;</p>\n', '2023-02-11 17:12:27', '', 'JOHN', 62, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-11 17:12:27', 69, '2023-03-28 08:15:25'),
(11890, 20159, '', '11890', 'E', 1, '<p>\n	Mobile App</p>\n', '2023-02-13 16:30:57', '', 'JOHN', 476, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-13 16:30:57', 69, '2023-04-12 12:01:59'),
(11891, 20019, '', '11891', 'E', 1, '<p>\n	Team Meeting (14/02/2023)</p>\n', '2023-02-14 08:46:16', '', 'JOHN', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-14 08:46:16', 69, '2023-03-01 12:03:15'),
(11892, 20077, '', '11892', 'E', 1, '<p>\n	Meeting with client (Outgoing mail problem)</p>\n', '2023-02-14 17:00:06', '', 'JOHN', 230, 12, '2023-03-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-14 17:00:06', 69, '2023-03-28 14:41:11'),
(11893, 20061, '', '11893', 'I', 1, '<p>\n	admin@rusi<br />\n	Khalid salman</p>\n<p>\n	DB No 62</p>\n<p>\n	Subscription end date was 15/02/23</p>\n<p>\n	changed to 12/12/2023 (Not till 14/02/24) Since instead of 650, 500 was only paid on bank transfer 13/02/23</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"64\">\n	<colgroup>\n		<col width=\"64\" />\n	</colgroup>\n	<tbody>\n		<tr height=\"20\">\n			<td height=\"20\" style=\"height:15.0pt;width:48pt\" width=\"64\">\n				&nbsp;</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2023-02-15 09:54:33', '', 'JOHN', 182, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-15 09:54:33', 69, '2023-04-12 12:01:42'),
(11894, 20019, '', '11894', 'E', 1, '<p>\n	Team Meeting</p>\n', '2023-02-21 08:57:30', '', 'JOHN', 56, 12, '2023-03-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-21 08:57:30', 69, '2023-03-01 12:03:22'),
(11895, 20013, '', '11895', 'E', 1, '<p>\n	ASSIT TO CHANGE THE INVOICE NUMBER ONLY</p>\n', '2023-02-21 14:59:15', 'WhatsApp Image 2023-02-21 at 9.50.35 AM.jpeg', 'JOHN', 38, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-21 14:59:15', 69, '2023-04-12 12:01:36'),
(11896, 20021, '', '11896', 'E', 1, '<p>\n	Report</p>\n', '2023-02-21 16:46:27', '', 'JOHN', 62, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-21 16:46:27', 69, '2023-06-03 14:57:34'),
(11897, 20002, '', '11897', 'E', 1, '<p>\n	Delete Item 4020-U0004OS2CL-CL</p>\n<p>\n	wrongly created- No transactions</p>\n<p>\n	as per Mr. Sujith Whatsapp message 22/02/23</p>\n', '2023-02-22 14:38:58', '', 'JOHN', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-22 14:38:58', 69, '2023-04-12 12:01:29'),
(11898, 20101, '', '11898', 'E', 1, '<p>\n	work</p>\n', '2023-02-22 17:24:57', '', 'JOHN', 302, 12, '2023-04-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-22 17:24:57', 69, '2023-04-06 15:08:04'),
(11899, 20161, '', '11899', 'E', 1, '<p>\n	ERP Installation</p>\n', '2023-02-23 08:00:28', '', 'JOHN', 482, 12, '2024-01-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-23 08:00:28', 613, '2024-01-02 16:36:14'),
(11900, 20098, '', '11900', 'E', 1, '<p>\n	Report</p>\n', '2023-02-23 14:04:54', '', 'JOHN', 293, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-23 14:04:54', 69, '2023-06-03 15:12:55'),
(11901, 20149, '', '11901', 'E', 1, '<p>\n	Mobile App Development</p>\n', '2023-02-23 14:10:27', '', 'JOHN', 446, 12, '2023-07-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-23 14:10:27', 69, '2023-07-01 17:29:58'),
(11902, 20004, '', '11902', 'E', 1, '<p>\n	File upload error - text and csv file upload</p>\n', '2023-02-23 17:37:23', '', 'JOHN', 11, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-23 17:37:23', 69, '2023-04-12 12:01:24'),
(11903, 20120, '', '11903', 'E', 1, '<p>\n	Stock checking application, modification<br />\n	Proper upload&nbsp; of file - fill missing barcode with product code, fill missing generic and brand with none</p>\n<p>\n	duplicate checking of Product code- if duplicating itemcode+barcode - take same<br />\n	add rack ( craete wih prefix, start and end)- check with existing rack duplication while creating<br />\n	upload rack option</p>\n', '2023-02-24 17:22:31', '', 'JOHN', 359, 12, '2023-04-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-24 17:22:31', 69, '2023-04-04 10:49:46'),
(11904, 20151, '', '11904', 'E', 1, '<p>\n	Purchase order API</p>\n', '2023-02-24 17:31:57', '', 'JOHN', 452, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-24 17:31:57', 69, '2023-04-12 15:20:11'),
(11905, 20060, '', '11905', 'E', 1, '<p>\n	HR Installation</p>\n', '2023-02-25 08:49:09', '', 'JOHN', 179, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-25 08:49:09', 69, '2023-04-12 15:20:56'),
(11906, 20163, '', '11906', 'E', 1, '<p>\n	Real estate solution</p>\n', '2023-02-27 08:37:21', '', 'JOHN', 488, 4, '2023-09-07', 0, '0000-00-00', '', 2, '0', '', '30035,30006,30016,30036', 0, 0, '', '', 69, '2023-02-27 08:37:21', 613, '2023-09-07 13:11:02'),
(11907, 20162, '', '11907', 'E', 1, '<p>\n	HR Implementaion</p>\n', '2023-02-27 09:49:38', '', 'JOHN', 485, 12, '2024-01-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-27 09:49:38', 613, '2024-01-02 16:51:45'),
(11908, 20074, '', '11908', 'E', 1, '<p>\n	Change amount</p>\n<p>\n	Basic - 24000<br />\n	Accommodation - 8000<br />\n	Transport - 8000</p>\n', '2023-02-27 10:46:56', 'WhatsApp Image 2023-02-27 at 10.31.46 AM.jpeg', 'JOHN', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-27 10:46:56', 69, '2023-04-12 12:01:17'),
(11909, 20002, '', '11909', 'I', 1, '<p>\n	Norden &ndash; Purchases invoice items doesn&rsquo;t hit stock - MRN 702745. pO 601547, MRN 702744 Po 601567</p>\n<p>\n	&nbsp;</p>\n', '2023-02-27 15:51:58', '', 'JOHN', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-27 15:51:58', 69, '2023-04-12 12:01:11'),
(11910, 20074, '', '11910', 'E', 1, '<p>\n	Appraisal Revert</p>\n<p>\n	<span style=\"font-size:10.5pt;font-family:-apple-system\">Could you please add back Kurt probation review evaluation in his inbox to add more details in his review?</span></p>\n', '2023-02-27 16:32:38', '', 'JOHN', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-27 16:32:38', 69, '2023-04-12 12:01:05'),
(11911, 20074, '', '11911', 'E', 1, '<p>\n	Callsign<br />\n	Abdullah Alqeisi<br />\n	CT-168<br />\n	Correct joining date- 23rd Jan 2023</p>\n', '2023-02-27 16:33:27', '', 'JOHN', 221, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-27 16:33:27', 69, '2023-04-12 12:01:00'),
(11912, 20067, '', '11912', 'I', 1, '<p>\n	maxter these 2 order we already made invoice in 2021..<br />\n	now its showing in purchase order.. please check why its coming?</p>\n', '2023-02-27 17:35:34', 'WhatsApp Image 2023-02-27 at 5.33.57 PM.jpeg', 'JOHN', 200, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2023-02-27 17:35:34', 69, '2023-04-12 12:00:54');
INSERT INTO `bsrv_service_request` (`id`, `client_id`, `project_details`, `service_request_no`, `issue_generated`, `issue_type`, `issue_description`, `issue_date`, `issue_upload`, `issue_raised_by`, `issue_priority`, `issue_status`, `status_updated`, `master_request_no`, `issue_splitted_date`, `splitted_new_id`, `status_before_hold`, `ratings`, `rating_description`, `current_employee_assigned`, `product_id`, `master_value_id`, `text_value_1`, `text_value_2`, `created_by`, `created_date_time`, `updated_by`, `updated_date_time`) VALUES
(11913, 20058, '', '11913', 'E', 1, '<p>\n	Correction&nbsp; - whats app dated 27/02/2023</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65420 characters]', '2023-02-27 18:44:41', '', 'mereenak', 173, 12, '2023-05-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2023-02-27 18:44:41', 69, '2023-05-15 17:44:17');
