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
(11425, 20002, '', '11425', 'I', 1, '<p>\n	<span style=\"color:windowtext\">As discussed please help to drop the attached stock as it&rsquo;s in damage location. Attached list of item to drop.</span></p>\n<p>\n	<span style=\"color:windowtext\">(Bring back the items from Damage store to Main stock). Norden will issue out those using inventory - issue</span></p>\n<p>\n	<span style=\"color:windowtext\">(see attached Excel file)</span></p>\n', '2022-07-14 17:18:44', 'Damage Loaction- stock list in CRM 22.06.22.xlsx', 'JOHN', 5, 12, '2022-08-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-14 17:18:44', 1, '2022-08-01 05:00:02'),
(11426, 20118, '', '11426', 'E', 1, '<p>\n	Overtime not updating since they put overtime to Y , so run code to bring old OT</p>\n', '2022-07-14 17:21:14', '', 'JOHN', 353, 12, '2022-07-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-14 17:21:14', 1, '2022-07-21 05:00:02'),
(11427, 20122, '', '11427', 'E', 1, '<p>\n	Attendance not loading because Empid and attendence id missing 0 (Eg 25 &amp; 025)</p>\n', '2022-07-14 17:22:24', '', 'JOHN', 365, 12, '2022-07-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-14 17:22:24', 1, '2022-07-21 05:00:02'),
(11428, 20019, '', '11428', 'E', 1, '<p>\n	Team Meeting (19/07/22)</p>\n', '2022-07-19 09:23:00', '', 'JOHN', 56, 12, '2022-07-26', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2022-07-19 09:23:00', 1, '2022-07-26 05:00:03'),
(11431, 20098, '', '11431', 'I', 1, '<p>\n	Infinity logistics duplicate JO 4718/4719 (4719 cancelled by them) - May be due to the Credit limit control introuced yesterday</p>\n', '2022-07-20 17:44:22', '', 'JOHN', 293, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-20 17:44:22', 1, '2022-11-01 06:00:01'),
(11429, 20001, '', '11429', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; background-color: rgb(200, 200, 200);\">PO number :600230</span></p>\n<p>\n	in PO Sr.no 23 currently it&#39;s 2 but 1 pcs received<br />\n	change 1 to partial delivery&nbsp;</p>\n', '2022-07-19 11:26:21', 'ORACI-A7970-8683288-01.pdf', 'Acecentro User', 1, 12, '2022-08-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2022-07-19 11:26:21', 1, '2022-08-02 05:00:01'),
(11430, 20117, '', '11430', 'E', 1, '<p>\n	Quotation modification</p>\n', '2022-07-20 08:22:53', '', 'JOHN', 350, 12, '2023-06-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-20 08:22:53', 69, '2023-06-07 08:03:27'),
(11432, 20067, '', '11432', 'E', 1, '<p>\n	Dashboard Modification (See attached)</p>\n', '2022-07-21 10:03:50', 'WhatsApp Image 2022-07-19 at 10.15.42 AM.jpeg,WhatsApp Image 2022-07-19 at 10.15.23 AM.jpeg', 'JOHN', 200, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-21 10:03:50', 69, '2023-04-12 14:43:28'),
(11433, 20019, '', '11433', 'E', 1, '<p>\n	Company Name: AL SAMHA GENERAL TRADING&nbsp; L L C &nbsp;<br />\n	Address: Ajman,UAE<br />\n	TRN:100043781200003<br />\n	Telephone:<br />\n	Mobile:0529637634 , 0557387706<br />\n	Email: samha0uae@gmail.com<br />\n	Web:<br />\n	Logo:<br />\n	<br />\n	Salesman details: Mohammad Shijas<br />\n	Name and mobile: Mohammad Shijas<br />\n	0529637634</p>\n<p>\n	admin@samha01</p>\n', '2022-07-21 11:31:22', '', 'JOHN', 56, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30014', 0, 0, '', '', 69, '2022-07-21 11:31:22', 1, '2022-07-29 05:00:04'),
(11434, 20140, '', '11434', 'E', 1, '<p>\n	ERP Software&nbsp; Implementation</p>\n', '2022-07-21 16:58:06', '', 'JOHN', 419, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-21 16:58:06', 69, '2023-04-12 14:43:15'),
(11435, 20065, '', '11435', 'E', 1, '<p>\n	Magnum -Also, is it possible to check approval levels for expenses claim of Kumarasamy (WM-I-0002)-</p>\n', '2022-07-21 17:47:58', '', 'JOHN', 194, 12, '2022-07-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-21 17:47:58', 1, '2022-07-31 05:00:01'),
(11436, 20021, '', '11436', 'E', 1, '<p>\n	Issues/Meeting</p>\n', '2022-07-21 17:48:49', '', 'JOHN', 62, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-21 17:48:49', 69, '2023-04-12 14:43:06'),
(11601, 20130, '', '11601', 'I', 1, '<p>\n	Tax amount and net amount in sell section in job edit</p>\n<p>\n	Job number in invoice report</p>\n<p>\n	&nbsp;</p>\n', '2022-09-26 09:55:23', '', 'JOHN', 389, 12, '2022-11-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-26 09:55:23', 69, '2022-11-21 09:20:25'),
(11437, 20122, '', '11437', 'E', 1, '<p>\n	Report for OT (See attached)</p>\n<p>\n	later we will copy this report to other HR also</p>\n', '2022-07-22 10:26:27', 'WhatsApp Image 2022-07-22 at 10.24.02 AM.jpeg', 'JOHN', 365, 12, '2022-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-22 10:26:27', 1, '2022-08-16 05:00:03'),
(11438, 20067, '', '11438', 'E', 1, '<p>\n	File No 31742, Order No: 37113, DO 47334, Invoice 57091 - Customer&nbsp; Mag Health</p>\n<p>\n	File No 31520, Order No: 36920, DO 47087, Invoice 56859 - Customer&nbsp; liberty</p>\n<p>\n	Unpost the invoice</p>\n<p>\n	change the lead owner of the above (order, do, invoice) from Afreen to CYNTHIA NAMORO<br />\n	post the invoice again</p>\n', '2022-07-22 11:24:48', '', 'JOHN', 200, 12, '2022-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-22 11:24:48', 1, '2022-07-28 05:00:02'),
(11440, 20019, '', '11440', 'E', 1, '<p>\n	FM Project</p>\n', '2022-07-22 17:00:43', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-22 17:00:43', 69, '2023-04-12 14:42:59'),
(11441, 20138, '', '11441', 'E', 1, '<p>\n	All cargo- salary change -Harshan Alex &nbsp;Employee ID no : 108772</p>\n', '2022-07-22 17:04:21', '', 'JOHN', 413, 12, '2022-08-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-22 17:04:21', 1, '2022-08-01 05:00:02'),
(11499, 20019, '', '11499', 'E', 1, '<p>\n	Team Meeting 09/08/22</p>\n', '2022-08-09 16:56:41', '', 'JOHN', 56, 12, '2022-08-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-09 16:56:41', 69, '2022-08-11 07:39:36'),
(11442, 20019, '', '11442', 'E', 1, '<p>\n	Bluesky lite - work</p>\n', '2022-07-25 07:52:38', '', 'JOHN', 56, 12, '2022-08-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-25 07:52:38', 1, '2022-08-02 05:00:01'),
(11444, 20013, '', '11444', 'I', 1, '<p>\n	TopnetLLC</p>\n<p>\n	[11:09 AM, 7/25/2022] Topnet Siddique: Pls assist to change the date of the last invoice number in LLC Crm<br />\n	[11:10 AM, 7/25/2022] Topnet Siddique: To 22/7 instead of 25/7<br />\n	[11:10 AM, 7/25/2022] Topnet Siddique: It&#39;s lil urgent<br />\n	Good Morning<br />\n	Invoice nUmber please<br />\n	40092</p>\n', '2022-07-25 11:18:55', '', 'JOHN', 38, 12, '2022-07-31', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-25 11:18:55', 1, '2022-07-31 05:00:01'),
(11445, 20124, '', '11445', 'E', 1, '<p>\n	Job order - Add cash and credit in Master of payment, disable all the other and check disabled ones coming in job order</p>\n<p>\n	In job order - Label change Payment type</p>\n<p>\n	Job order drier name should support arabic language when saving</p>\n<p>\n	Invoice print Truck and manifest coming twice (Eg inv 20047)<br />\n	Job order needs a c/o of field, which contains Importer or exporter and should Print in Invoice C/o Field</p>\n', '2022-07-25 11:59:04', '', 'JOHN', 371, 12, '2022-07-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-25 11:59:04', 69, '2022-07-28 14:31:44'),
(11446, 20019, '', '11446', 'E', 1, '<p>\n	Al Samha- Invenoty Uplaoding</p>\n', '2022-07-25 15:49:30', 'erp_stock_ledger (alsamha250722.csv,erp_inventory alsamha250722.csv', 'JOHN', 56, 12, '2022-08-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-25 15:49:30', 1, '2022-08-01 05:00:02'),
(11730, 20098, '', '11730', 'E', 1, '<p>\n	Purchase Invoice- Docuemnt uploaded coannot be downloaded</p>\n', '2022-11-21 17:51:24', '', 'JOHN', 293, 12, '2022-11-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-21 17:51:24', 1, '2022-11-28 06:00:02'),
(11447, 20067, '', '11447', 'E', 1, '<p>\n	Dashboard - Graph Modification</p>\n', '2022-07-25 17:34:17', '', 'JOHN', 200, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 69, '2022-07-25 17:34:17', 1, '2022-12-02 06:00:06'),
(11448, 20048, '', '11448', 'E', 1, '<p>\n	<span dir=\"ltr\" role=\"presentation\" style=\"left: 92.8083px; top: 383.689px; font-size: 15px; font-family: sans-serif; transform: scaleX(0.984565);\"><span class=\"highlight selected appended\">ENC-HBU5M-80R-94 </span></span></p>\n<p>\n	<span dir=\"ltr\" role=\"presentation\" style=\"left: 92.8083px; top: 383.689px; font-size: 15px; font-family: sans-serif; transform: scaleX(0.984565);\"><span class=\"highlight selected appended\">PO - 600290</span></span></p>\n<p>\n	<span dir=\"ltr\" role=\"presentation\" style=\"left: 92.8083px; top: 383.689px; font-size: 15px; font-family: sans-serif; transform: scaleX(0.984565);\"><span class=\"highlight selected appended\">Inventory List - PO QTY wrong</span></span></p>\n<p>\n	<span dir=\"ltr\" role=\"presentation\" style=\"left: 92.8083px; top: 383.689px; font-size: 15px; font-family: sans-serif; transform: scaleX(0.984565);\"><span class=\"highlight selected appended\">Raised By jeena</span></span></p>\n<p>\n	<span dir=\"ltr\" role=\"presentation\" style=\"left: 92.8083px; top: 383.689px; font-size: 15px; font-family: sans-serif; transform: scaleX(0.984565);\"><span class=\"highlight selected appended\">Solved By calling Jisha</span></span></p>\n', '2022-07-26 11:51:18', '', 'Norden Communications', 142, 12, '2023-03-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2022-07-26 11:51:18', 69, '2023-03-24 08:12:20'),
(11449, 20018, '', '11449', 'E', 1, '<p>\n	Clearing and uploading new inventory data</p>\n', '2022-07-26 13:34:06', 'Inventory 26-07-22.xlsx', 'JOHN', 53, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2022-07-26 13:34:06', 1, '2022-12-02 06:00:06'),
(11450, 20138, '', '11450', 'E', 1, '<p>\n	Hi John,<br />\n	<br />\n	Please add AED 2000 in Other Additions&nbsp; for Mr. SAGAR SUKUMARAN LEELAMMA Employee ID 111177.<br />\n	&nbsp;<br />\n	We have already paid him AED16500 /- in month of July 2020 . So kindly make the changes in the Payslip from backend and so the credited amount will tally with the payslip .<br />\n	&nbsp;<br />\n	Looking for your support .</p>\n', '2022-07-26 15:53:30', '', 'JOHN', 413, 12, '2022-08-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-26 15:53:30', 1, '2022-08-02 05:00:01'),
(11451, 20117, '', '11451', 'E', 1, '<p>\n	Attendence upload from their .csv files</p>\n', '2022-07-27 07:56:20', '', 'JOHN', 350, 12, '2022-08-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-27 07:56:20', 1, '2022-08-02 05:00:01'),
(11452, 20019, '', '11452', 'E', 1, '<p>\n	Team Meeting 27/07/22</p>\n', '2022-07-27 08:46:11', '', 'JOHN', 56, 12, '2022-08-03', 0, '0000-00-00', '', 0, '0', '', '30014,30023,30004,30018,30012', 0, 0, '', '', 69, '2022-07-27 08:46:11', 1, '2022-08-03 05:00:02'),
(11453, 20098, '', '11453', 'E', 1, '<p>\n	Cheque management issue</p>\n<p>\n	We are completely moving our finance system to the software from August 1</p>\n<p>\n	I just noticed that that payment that we receive by chqs is posted to an account called PDC-R and the chq management module , the amount doesn&rsquo;t get transferred to the bank account and assign bank button also is not working</p>\n<p>\n	We do not require the PDC-R account at the moment ,The chq receipt created can direct move to the bank ledger</p>\n<p>\n	Can you please do the needful urgently ..I need to reconcile the bank ledger in the ERP with the bank statement to start off . I spoke to Albin , he says it might take time as he is busy with other jobs</p>\n<p>\n	&nbsp;</p>\n', '2022-07-27 08:52:22', '', 'JOHN', 293, 12, '2022-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-27 08:52:22', 1, '2022-08-04 05:00:02'),
(11454, 20067, '', '11454', 'E', 1, '<p>\n	Salary modification as per mail dt&nbsp; 14/07/22</p>\n', '2022-07-27 09:52:05', '', 'JOHN', 200, 12, '2022-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-27 09:52:05', 1, '2022-08-03 05:00:02'),
(11455, 20003, '', '11455', 'E', 1, '<p>\n	Report correction - Filters</p>\n', '2022-07-27 10:41:37', '', 'JOHN', 8, 12, '2022-08-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-27 10:41:37', 1, '2022-08-02 05:00:01'),
(11456, 20019, '', '11456', 'E', 1, '<p>\n	Al Ahlam Bakery ; Esell date change to 15/08/2022 , DB 36 ; 7 users</p>\n<p>\n	&nbsp;</p>\n', '2022-07-27 12:19:11', '', 'JOHN', 56, 12, '2022-08-03', 0, '0000-00-00', '', 0, '0', '', '30014', 0, 0, '', '', 69, '2022-07-27 12:19:11', 1, '2022-08-03 05:00:02'),
(11457, 20124, '', '11457', 'E', 1, '<p>\n	Miramer &ndash; sales order can&rsquo;t save without delivery date. also cant put any date - Mereena</p>\n<p>\n	Miramar - serial number is not orderly.- Mereena</p>\n<p>\n	&nbsp;</p>\n', '2022-07-27 17:52:09', 'WhatsApp Image 2022-07-27 at 5.17.16 PM.jpeg,WhatsApp Image 2022-07-27 at 5.16.54 PM.jpeg', 'JOHN', 371, 12, '2022-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-27 17:52:09', 1, '2022-08-03 05:00:02'),
(11458, 20117, '', '11458', 'E', 1, '<p>\n	Employee Leave- print pdf</p>\n', '2022-07-28 07:38:33', '', 'JOHN', 350, 12, '2022-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-28 07:38:33', 1, '2022-08-03 05:00:02'),
(11460, 20019, '', '11460', 'E', 1, '<p>\n	HR - Common work - Read only of Routing code, should change when changing bank dropdown</p>\n', '2022-07-28 15:19:43', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-28 15:19:43', 69, '2023-04-12 14:42:49'),
(11461, 20138, '', '11461', 'E', 1, '<p>\n	Amending DOB as per List attached<br />\n	Nominee in ESS - Save option Enable<br />\n	Labour contract - Document upload</p>\n', '2022-07-28 16:46:26', 'Date of Birth.xlsx', 'JOHN', 413, 12, '2022-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-28 16:46:26', 1, '2022-08-04 05:00:02'),
(11462, 20117, '', '11462', 'E', 1, '<p>\n	HR</p>\n<p>\n	Coral Loan date change &ndash; Dikson 28/07/22</p>\n<p>\n	Coral- Salary changing from a future date - Dikson</p>\n<p>\n	Coral- Bank account number filleing no need mandatory &ndash; Dikson 28/07/22</p>\n<p>\n	&nbsp;</p>\n', '2022-07-28 16:48:04', '', 'JOHN', 350, 12, '2022-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-28 16:48:04', 1, '2022-08-04 05:00:02'),
(11463, 20137, '', '11463', 'E', 1, '<p>\n	HR Installation and data loading</p>\n', '2022-07-28 16:48:52', '', 'JOHN', 410, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-28 16:48:52', 1, '2022-10-28 05:00:04'),
(11464, 20019, '', '11464', 'E', 1, '<p>\n	Service Portal</p>\n<p>\n	&nbsp;</p>\n<p>\n	Changing of 3 leaves to Half day manually</p>\n<p>\n	option for applying half day leave</p>\n', '2022-07-28 16:49:57', '', 'JOHN', 56, 12, '2022-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-28 16:49:57', 1, '2022-08-04 05:00:02'),
(11466, 20004, '', '11466', 'E', 1, '<p>\n	Good Day John,</p>\n<p>\n	Please note that previously if there is a blank details in pre invoice like weight, HS code, volume, county of origin etc. use to be highlighted in red colour.</p>\n<p>\n	However, after doing the changes in software we noticed that its not highlighting so We request you to kindly look into it and do the changes urgently</p>\n<p>\n	Below screen shot for your reference &nbsp;</p>\n', '2022-07-29 10:34:49', 'image001290722.jpg', 'JOHN', 11, 12, '2022-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-29 10:34:49', 1, '2022-08-04 05:00:02'),
(11467, 20036, '', '11467', 'E', 1, '<p>\n	<span style=\"color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 16px;\">Please do the needful of the below error on bluesky as we cannot transfer the below Spare. Kindly change the flag of ITEM CODE *&nbsp;</span><span style=\"border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: Calibri, sans-serif; margin: 0px; padding: 0px; vertical-align: baseline; color: rgb(0, 0, 0); background-color: yellow;\">FNW-ASR-POW-SUP-001</span><span style=\"color: rgb(0, 0, 0); font-family: Calibri, sans-serif; font-size: 16px;\">&nbsp;*&nbsp; from &quot;SERIAL STATUS FROM YES TO NO&quot; as these spares are NON SERIALS.</span></p>\n', '2022-07-29 13:24:02', 'image004.png', 'Administrator ', 106, 12, '2022-08-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 43, '2022-07-29 13:24:02', 1, '2022-08-04 05:00:02'),
(11468, 20117, '', '11468', 'E', 1, '<p>\n	HR- Loan date correction after approval</p>\n', '2022-07-29 17:26:13', '', 'JOHN', 350, 12, '2022-08-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-29 17:26:13', 1, '2022-08-07 05:00:02'),
(11469, 20065, '', '11469', 'E', 1, '<p>\n	OT not recordibg for less than 30 mins. settings miniumnum 30 min was set. Due to that &lt;30 min OT was not recorded</p>\n', '2022-07-29 17:27:08', '', 'JOHN', 194, 12, '2022-08-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-29 17:27:08', 1, '2022-08-08 05:00:02'),
(11472, 20118, '', '11472', 'I', 3, '<p>\n	Overtime AMount in Salary Calculation</p>\n', '2022-07-29 18:25:40', '', 'JOHN', 353, 12, '2022-08-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-29 18:25:40', 1, '2022-08-07 05:00:02'),
(11470, 20001, '', '11470', 'E', 1, '<p>\n	Ace issue PO print footer not affecting &nbsp;PDF, change it</p>\n<p>\n	&nbsp;</p>\n', '2022-07-29 17:28:47', '', 'JOHN', 2, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-29 17:28:47', 69, '2023-04-12 14:42:31'),
(11471, 20067, '', '11471', 'I', 1, '<p>\n	write&nbsp; a code and insert in HR new employee add/edit</p>\n<p>\n	which creates a subledger for that employee<br />\n	Inform /notify dikson too<br />\n	<br />\n	Implement when Allwyn and dikson are present</p>\n<p>\n	&nbsp;</p>\n', '2022-07-29 17:31:09', '', 'JOHN', 200, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-07-29 17:31:09', 69, '2023-04-12 14:42:24'),
(11473, 20130, '', '11473', 'I', 1, '<p>\n	Logical Issues - Job Order</p>\n<p>\n	Error in Covert to Invoice</p>\n', '2022-07-30 20:28:04', '', 'mereenak', 389, 12, '2022-08-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-07-30 20:28:04', 1, '2022-08-18 05:00:01'),
(11475, 20106, '', '11475', 'E', 1, '<p>\n	Invoice edited and put PO number, ut itsnot affectinginvoice print<br />\n	Inv 40180 dt 12/07/2022</p>\n<p>\n	change in duplicae print also</p>\n', '2022-08-01 11:22:32', '', 'JOHN', 317, 12, '2022-08-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-01 11:22:32', 1, '2022-08-08 05:00:02'),
(11476, 20074, '', '11476', 'E', 1, '<p>\n	Hi Jovita,</p>\n<p>\n	Below is my leave record which I availed in July.</p>\n<p>\n	04 July to 16<sup>th</sup> July. I think the 2 days of Eid holidays have not been adjusted in the below. After the adjustment of the 2 days of public holiday, the leave availed should reflect 8 working days.</p>\n', '2022-08-01 12:04:07', 'rethink0108.png', 'JOHN', 221, 12, '2022-08-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-01 12:04:07', 1, '2022-08-08 05:00:02'),
(11490, 20006, '', '11490', 'E', 1, '<p>\n	TB Not Tallying .</p>\n', '2022-08-04 11:17:55', '', 'JOHN', 17, 12, '2022-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-04 11:17:55', 1, '2022-09-01 05:00:02'),
(11478, 20118, '', '11478', 'E', 1, '<p>\n	Legend- Salary calculation difference 44 CHIRANJIT KARMAKAR, 56 OWALIULLAH, 69 SOURAV KHAN</p>\n<p>\n	Was due to salary calculated earlier, means 29/07 OT hasn&rsquo;t in the system- Dikson 01/08/22</p>\n<p>\n	&nbsp;</p>\n', '2022-08-02 08:23:24', '', 'JOHN', 353, 12, '2022-08-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 08:23:24', 1, '2022-08-08 05:00:02'),
(11479, 20117, '', '11479', 'E', 1, '<p>\n	Salary calculation checking</p>\n', '2022-08-02 08:23:52', '', 'JOHN', 350, 12, '2022-08-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 08:23:52', 1, '2022-08-11 05:00:01'),
(11480, 20067, '', '11480', 'I', 1, '<p>\n	Loan approval date changing from august to July</p>\n', '2022-08-02 08:24:54', '', 'JOHN', 200, 12, '2022-08-08', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 08:24:54', 1, '2022-08-08 05:00:02'),
(11503, 20117, '', '11503', 'E', 1, '<p>\n	HR- Iban number code in sif file suiting to Rak bank account (Without AE, But 23 digits)</p>\n', '2022-08-10 17:55:36', '', 'JOHN', 350, 12, '2022-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-10 17:55:36', 1, '2022-08-17 05:00:02'),
(11482, 20117, '', '11482', 'E', 1, '<p>\n	Coral- salary calculated difference- 2 salary in a range &ndash; Done 02/08/22</p>\n<p>\n	Employee code: 0061</p>\n<p>\n	Component &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; From&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To</p>\n<p>\n	Basic &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/03/20</p>\n<p>\n	TA&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; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/03/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/03/20</p>\n<p>\n	TA&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; 300&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12/03/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\n<p>\n	Housing&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 700&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/03/20</p>\n<p>\n	Other Allow&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11/03/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30/06/22</p>\n<p>\n	Other Allow&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/07/22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 01/07/22</p>\n<p>\n	Other Allow&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 02/07/22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-08-02 09:58:16', '', 'JOHN', 350, 12, '2022-08-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 09:58:16', 1, '2022-08-11 05:00:01'),
(11481, 20019, '', '11481', 'E', 1, '<p>\n	Team meeting 02/08/2022</p>\n', '2022-08-02 08:28:26', '', 'JOHN', 56, 12, '2022-08-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 08:28:26', 69, '2022-08-03 09:58:03'),
(11483, 20117, '', '11483', 'E', 1, '<p>\n	Coral- When applying a loan from the admin side- Remarks coloumn needed</p>\n', '2022-08-02 10:51:04', '', 'JOHN', 350, 12, '2023-06-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 10:51:04', 69, '2023-06-07 08:03:21'),
(11484, 20138, '', '11484', 'E', 1, '<p>\n	Change header of EOS settlement print</p>\n<p>\n	Provision to give EOS through WPS as a single entry</p>\n', '2022-08-02 10:52:02', '', 'JOHN', 413, 12, '2022-09-07', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-08-02 10:52:02', 1, '2022-09-07 05:00:01'),
(11485, 20002, '', '11485', 'E', 1, '<p>\n	Stock Ageing report - Loading Delay</p>\n', '2022-08-02 14:35:12', '', 'JOHN', 5, 12, '2022-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 14:35:12', 1, '2022-08-09 05:00:02'),
(11486, 20002, '', '11486', 'E', 1, '<p>\n	when converting a PO, to PI, keep the tax status from PO to PI</p>\n', '2022-08-02 14:36:06', '', 'JOHN', 5, 12, '2022-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 14:36:06', 1, '2022-08-09 05:00:02'),
(11600, 20019, '', '11600', 'E', 1, '<p>\n	Cost Report to be done in Diateck for cost verification<br />\n	do not hang to menu of reports<br />\n	Only excel output needed</p>\n<p>\n	See atatched file</p>\n', '2022-09-23 17:26:38', 'cost report.xlsx', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-23 17:26:38', 69, '2023-03-27 12:25:28'),
(11487, 20019, '', '11487', 'E', 1, '<p>\n	sales09@qb New user creation</p>\n', '2022-08-02 17:25:56', '', 'JOHN', 56, 12, '2022-08-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-02 17:25:56', 1, '2022-08-09 05:00:02'),
(11489, 20067, '', '11489', 'I', 1, '<p>\n	Salary calculation problem correction</p>\n', '2022-08-03 16:49:16', '', 'JOHN', 200, 12, '2022-08-11', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-03 16:49:16', 1, '2022-08-11 05:00:01'),
(11491, 20067, '', '11491', 'I', 1, '<p>\n	Diatech- Car allowance added in Salary master as a one time (shamna)- Dikson 04/08/22</p>\n<p>\n	Diatech &ndash; Training report &ndash; if amount zero &ndash; show blank</p>\n<p>\n	Datech &ndash; Traing tab &ndash; check</p>\n<p>\n	Diatech &ndash; Traing not attended list</p>\n<p>\n	&nbsp;</p>\n', '2022-08-04 12:16:18', '', 'JOHN', 200, 12, '2022-09-11', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-08-04 12:16:18', 1, '2022-09-11 05:00:02'),
(11492, 20067, '', '11492', 'I', 1, '<p>\n	Diatech- On Quotation approval- Customer changes from Dubai Muncipality to Sharjah Muncipality<br />\n	Reason &ndash; Dubai municipality in lead, in quotation customer Sharjah municipality on edit/approval customer taken from lead</p>\n<p>\n	&nbsp;</p>\n<p>\n	<span style=\"background-color:#ffff00;\">PLEASE CHECK IN DETAIL</span></p>\n<p>\n	&nbsp;</p>\n', '2022-08-04 14:42:29', '', 'JOHN', 200, 12, '2022-09-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-04 14:42:29', 1, '2022-09-26 05:00:03'),
(11494, 20142, '', '11494', 'E', 1, '<p>\n	ERP installation</p>\n', '2022-08-05 14:36:31', '', 'JOHN', 425, 7, '2023-12-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-05 14:36:31', 583, '2023-12-14 16:17:57'),
(11495, 20144, '', '11495', 'E', 1, '<p>\n	WMS integration</p>\n', '2022-08-08 08:12:30', '', 'JOHN', 431, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-08 08:12:30', 1, '2022-11-01 06:00:01'),
(11496, 20014, '', '11496', 'E', 1, '<p>\n	See atatched File</p>\n', '2022-08-08 08:53:21', 'waddah Bluesky customization 13-10-2021.xlsx', 'JOHN', 41, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-08 08:53:21', 69, '2023-04-12 14:42:08'),
(11497, 20019, '', '11497', 'E', 1, '<p>\n	HR Bug/Updations</p>\n', '2022-08-09 16:48:13', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-09 16:48:13', 69, '2023-04-12 14:41:41'),
(11498, 20067, '', '11498', 'I', 1, '<p>\n	Salary calc and updation Validation</p>\n', '2022-08-09 16:50:45', '', 'JOHN', 200, 12, '2022-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-09 16:50:45', 1, '2022-08-16 05:00:03'),
(11509, 20019, '', '11509', 'E', 1, '<p>\n	Saloon Work</p>\n', '2022-08-12 07:41:55', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-12 07:41:55', 69, '2023-03-27 12:20:57'),
(11568, 20019, '', '11568', 'E', 1, '<p>\n	Off/ Power failure/ Net issue etc</p>\n', '2022-09-10 14:36:48', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-10 14:36:48', 69, '2023-03-27 12:24:11'),
(11500, 20019, '', '11500', 'E', 1, '<p>\n	Copying Ab com to CRM template</p>\n', '2022-08-10 07:46:06', '', 'JOHN', 56, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-10 07:46:06', 1, '2022-11-01 06:00:01'),
(11501, 20145, '', '11501', 'E', 1, '<p>\n	CRM implementation</p>\n', '2022-08-10 07:47:45', '', 'JOHN', 434, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-10 07:47:45', 1, '2022-11-01 06:00:01'),
(11502, 20138, '', '11502', 'E', 1, '<p>\n	Passport copy Upload<br />\n	Emirates Id copy Upload</p>\n', '2022-08-10 17:11:50', '', 'JOHN', 413, 12, '2022-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-10 17:11:50', 1, '2022-08-17 05:00:02'),
(11504, 20067, '', '11504', 'I', 1, '<p>\n	gratuity removal from sal cal</p>\n', '2022-08-10 17:56:19', '', 'JOHN', 200, 12, '2022-08-17', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-10 17:56:19', 1, '2022-08-17 05:00:02'),
(11505, 20122, '', '11505', 'E', 1, '<p>\n	OT not matching checking</p>\n', '2022-08-10 17:56:50', '', 'JOHN', 365, 12, '2022-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-10 17:56:50', 1, '2022-08-23 05:00:02'),
(11506, 20019, '', '11506', 'E', 1, '<p>\n	blueskyhr&nbsp;&nbsp; asset master and permission settings, assigned by dikson sir</p>\n', '2022-08-11 07:31:22', '', 'JOHN', 56, 12, '2022-12-02', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-08-11 07:31:22', 1, '2022-12-02 06:00:06'),
(11507, 20019, '', '11507', 'E', 1, '<p>\n	CRM Version 8</p>\n', '2022-08-11 07:33:34', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-11 07:33:34', 69, '2023-04-12 14:41:30'),
(11508, 20117, '', '11508', 'E', 1, '<p>\n	Dash Board correction</p>\n', '2022-08-11 07:34:58', '', 'JOHN', 350, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-11 07:34:58', 69, '2023-04-12 14:41:22'),
(11513, 20018, '', '11513', 'I', 1, '<p>\n	Old Logistics portal work</p>\n<p>\n	see mail on 10/08/22 from AJV</p>\n<p>\n	&nbsp;</p>\n', '2022-08-12 15:13:29', '', 'JOHN', 53, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-12 15:13:29', 69, '2023-03-27 12:21:13'),
(11682, 20019, '', '11682', 'E', 1, '<p>\n	Vat Issue (Not recalculating when grid line is deleted and saved)</p>\n', '2022-10-27 07:43:18', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-10-27 07:43:18', 69, '2023-04-12 14:40:33'),
(11510, 20099, '', '11510', 'E', 1, '<p>\n	Loan approval Levels Rearranging</p>\n', '2022-08-12 07:45:39', '', 'JOHN', 296, 12, '2022-08-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-12 07:45:39', 1, '2022-08-22 05:00:02'),
(11511, 20067, '', '11511', 'I', 1, '<p>\n	Dashboard Permission Checking</p>\n', '2022-08-12 07:47:07', '', 'JOHN', 200, 12, '2022-08-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-12 07:47:07', 1, '2022-08-22 05:00:02');
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
(11512, 20138, '', '11512', 'E', 1, '<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 17736 characters]\" /></p>\n', '2022-08-12 08:02:35', '', 'JOHN', 413, 12, '2022-08-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-12 08:02:35', 1, '2022-08-22 05:00:02'),
(11514, 20074, '', '11514', 'E', 1, '<p>\n	rethink&nbsp; hr-.asset master</p>\n', '2022-08-16 07:25:38', '', 'JOHN', 221, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-16 07:25:38', 69, '2023-03-27 12:21:26'),
(11515, 20019, '', '11515', 'E', 1, '<p>\n	Team Meeting 16/08/22</p>\n', '2022-08-16 08:32:32', '', 'JOHN', 56, 12, '2022-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-16 08:32:32', 69, '2022-08-23 14:07:21'),
(11520, 20138, '', '11520', 'E', 1, '<p>\n	Leave - Work</p>\n', '2022-08-17 18:00:18', '', 'JOHN', 413, 12, '2022-10-28', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-17 18:00:18', 1, '2022-10-28 05:00:04'),
(11516, 20098, '', '11516', 'I', 1, '<p>\n	Finance Print Customisation (Receipts)</p>\n<p>\n	User permission - Finance - Voucher type<br />\n	&nbsp;</p>\n', '2022-08-16 17:17:00', '', 'JOHN', 293, 12, '2022-09-11', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2022-08-16 17:17:00', 1, '2022-09-11 05:00:02'),
(11517, 20122, '', '11517', 'E', 1, '<p>\n	Out of the two Attendence file coming from to FTP, only one is coming</p>\n', '2022-08-17 07:27:22', '', 'JOHN', 365, 12, '2022-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-17 07:27:22', 1, '2022-08-23 05:00:02'),
(11518, 20078, '', '11518', 'E', 1, '<p>\n	Moative - Salary slip download- meeting</p>\n', '2022-08-17 07:28:14', '', 'JOHN', 233, 12, '2022-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-17 07:28:14', 1, '2022-08-23 05:00:02'),
(11519, 20013, '', '11519', 'E', 1, '<p>\n	FZE</p>\n<p>\n	As per telecon kindly assit to include details in the invoice</p>\n<p>\n	&nbsp;</p>\n<ol>\n	<li>\n		vat (5%) &nbsp;</li>\n	<li>\n		PAYMENT TERM to revise : <strong><u>45DAYS from delivery date(15-6-2022)</u></strong></li>\n</ol>\n<p>\n	&nbsp;</p>\n<p>\n	Net total: 43875</p>\n<p>\n	Vat (5 %):2193.75</p>\n<p>\n	GRAND TOTAL: 46068.75</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-08-17 10:27:11', 'topnet170822.png,topnet170822-1.png', 'JOHN', 38, 12, '2022-08-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-17 10:27:11', 1, '2022-08-24 05:00:01'),
(11521, 20019, '', '11521', 'E', 1, '<p>\n	Bluesky hr -PHP 8 error correction</p>\n', '2022-08-18 07:36:20', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-18 07:36:20', 69, '2023-03-27 12:21:41'),
(11522, 20042, '', '11522', 'E', 1, '<p>\n	Finance colour change -2 numbers</p>\n', '2022-08-18 14:13:12', '', 'JOHN', 125, 12, '2022-08-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-18 14:13:12', 1, '2022-08-25 05:00:02'),
(11594, 20117, '', '11594', 'E', 1, '<p>\n	Design Issue -- Data search for dropdown -- customer/machine</p>\n', '2022-09-20 21:51:09', '', 'mereenak', 350, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 478, '2022-09-20 21:51:09', 1, '2022-09-27 05:00:02'),
(11523, 20001, '', '11523', 'I', 1, '<p>\n	Payroll :JAYKARAN PAL HARIRAM PAL- Not coming in June/Ark</p>\n<p>\n	&nbsp;</p>\n', '2022-08-19 17:48:11', '', 'JOHN', 2, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-19 17:48:11', 1, '2022-11-01 06:00:01'),
(11524, 20019, '', '11524', 'E', 1, '<p>\n	Quarry - Modification</p>\n', '2022-08-22 07:56:35', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-22 07:56:35', 69, '2023-03-27 12:22:14'),
(11525, 20019, '', '11525', 'E', 1, '<p>\n	Whatsapp Integration</p>\n', '2022-08-22 08:32:29', '', 'JOHN', 56, 2, '2023-10-05', 0, '0000-00-00', '', 0, '0', '', '30016', 0, 0, '', '', 69, '2022-08-22 08:32:29', 69, '2023-10-05 08:30:44'),
(11526, 20019, '', '11526', 'E', 1, '<p>\n	Team meeting 23/08/22</p>\n', '2022-08-23 08:54:15', '', 'JOHN', 56, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-23 08:54:15', 1, '2022-11-01 06:00:01'),
(11542, 20019, '', '11542', 'E', 1, '<p>\n	Team Meeting Dt 30/08/22</p>\n', '2022-08-30 10:54:08', '', 'JOHN', 56, 12, '2023-08-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-30 10:54:08', 69, '2023-08-05 07:42:25'),
(11527, 20098, '', '11527', 'E', 1, '<p>\n	Voucher window, user permission - restriction</p>\n', '2022-08-23 17:13:59', '', 'JOHN', 293, 12, '2022-09-06', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2022-08-23 17:13:59', 1, '2022-09-06 05:00:01'),
(11528, 20074, '', '11528', 'E', 1, '<p>\n	Leave details changing</p>\n<p>\n	Rethink -&nbsp; AM00016 Jan Gustav (AMA advertising) &ndash; Applied for an annual leave 12/07 to 15/07, Their salary cutoff date is 20/07 and its already locked, can we extend the annual leave till 19 th ie 12/07 to 19/07 &ndash; Dikson 23/08/22</p>\n<p>\n	Rethink &ndash; leave apply and approve -- Adel Rashed ; July 21 to Aug 18 ; Ama advertising&nbsp; ; AM00009 &ndash; Dikson &ndash; 23/08/22</p>\n<p>\n	Rethink</p>\n<p>\n	Now</p>\n<p>\n	04/07 to 07/07 - 4 days</p>\n<p>\n	12/07 to 19/07 - 8 days</p>\n<p>\n	should be</p>\n<p>\n	04/07 to 07/07 - 4 days</p>\n<p>\n	12/07 to 15/07 - 4 days</p>\n<p>\n	15/08 to 19/08 - 5 days</p>\n<p>\n	JAN GUSTAV AM00016</p>\n<p>\n	&nbsp;</p>\n', '2022-08-23 17:29:15', '', 'JOHN', 221, 12, '2022-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-23 17:29:15', 1, '2022-09-01 05:00:02'),
(11529, 20138, '', '11529', 'E', 1, '<p>\n	All Cargo- Please delete the below element entry for Ms. SUSHMITHA KULYAR EID no 112504., The Transportation need to be deleted from the system (Typing Error ) &ndash; Dikson 23/08/22</p>\n<p>\n	&nbsp;</p>\n', '2022-08-23 17:29:41', '', 'JOHN', 413, 12, '2022-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-23 17:29:41', 1, '2022-09-01 05:00:02'),
(11530, 20106, '', '11530', 'E', 1, '<p>\n	Remove special characters in file name while uploading</p>\n', '2022-08-24 07:29:32', '', 'JOHN', 317, 12, '2022-09-11', 0, '0000-00-00', '', 0, '0', '', '30012', 0, 0, '', '', 69, '2022-08-24 07:29:32', 1, '2022-09-11 05:00:02'),
(11531, 20138, '', '11531', 'E', 1, '<p>\n	SIF File related correction (Leave absence not 0.00 only 0<br />\n	amount cochecking with them</p>\n<p>\n	Company code was wrongly put by them</p>\n', '2022-08-26 07:42:47', '', 'JOHN', 413, 12, '2022-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-26 07:42:47', 1, '2022-09-01 05:00:02'),
(11532, 20078, '', '11532', 'E', 1, '<p>\n	Attendence file upload restriction to certain branches as specified from master</p>\n<p>\n	Salary slip application, on approve download slip<br />\n	&nbsp;</p>\n', '2022-08-26 07:51:41', '', 'JOHN', 233, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-26 07:51:41', 1, '2022-09-12 05:00:02'),
(11533, 20074, '', '11533', 'E', 1, '<p>\n	Leave Cancellation - request not approved by LM, because of that Leave not credited Back</p>\n<p>\n	Informed them, and also mail enabled for cancellation request<br />\n	&nbsp;</p>\n', '2022-08-26 07:52:45', '', 'JOHN', 221, 12, '2022-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-26 07:52:45', 1, '2022-09-01 05:00:02'),
(11534, 20071, '', '11534', 'E', 1, '<p>\n	Sanooj attendeance removal</p>\n<p>\n	[1:04 PM, 8/24/2022] Sanooj IT Viola: Hi John, Can you please delete my attendance from the system from August 11th till August 18th asap<br />\n	[1:05 PM, 8/24/2022] Sanooj IT Viola: i was on annual leave and someone face is identified as mine and marked as present<br />\n	[1:08 PM, 8/24/2022] Sanooj IT Viola: is there any way to find from which machine this attendance is recorded?</p>\n<p>\n	CIZW204960100<br />\n	Purple Exhibition</p>\n', '2022-08-26 07:53:54', '', 'JOHN', 212, 12, '2022-09-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-26 07:53:54', 1, '2022-09-01 05:00:02'),
(11554, 20067, '', '11554', 'I', 1, '<p>\n	Salary Display problem Due to wrongly editing master edit option, need s blocking</p>\n', '2022-09-05 17:53:41', '', 'JOHN', 200, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-05 17:53:41', 1, '2022-09-12 05:00:02'),
(11536, 20045, '', '11536', 'E', 1, '<p>\n	Sage Austrialia Mobile App</p>\n', '2022-08-29 08:03:56', '', 'JOHN', 134, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-29 08:03:56', 69, '2023-03-27 12:22:40'),
(11535, 20067, '', '11535', 'I', 1, '<p>\n	Dear software team,</p>\n<p>\n	Good Day&hellip;!</p>\n<p>\n	At the time of creating supplier, we are providing payment terms before saving and while creating Purchase order we are unable to get the exact</p>\n<p>\n	Payment terms in the order, because of this again we need to correct payment terms. Please check the below mentioned example for your reference.</p>\n<p>\n	(see image attached)</p>\n<p>\n	&nbsp;</p>\n', '2022-08-26 08:07:44', 'Dia050822-2.png,Dia050822-1.png', 'JOHN', 200, 12, '2022-09-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-26 08:07:44', 1, '2022-09-02 05:00:04'),
(11537, 20102, '', '11537', 'E', 1, '<p>\n	Issues</p>\n', '2022-08-29 08:31:55', '', 'JOHN', 305, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-29 08:31:55', 69, '2023-03-27 12:22:51'),
(11538, 20019, '', '11538', 'E', 1, '<p>\n	E-Sell new account<br />\n	Company Name: Zairaa General Trading Co. LLC<br />\n	Address: Al Qusais, Dubai,UAE<br />\n	TRN:0<br />\n	Telephone:<br />\n	Mobile: 0522488312<br />\n	Email: @gmail.com<br />\n	Web:<br />\n	Logo:<br />\n	<br />\n	Users:<br />\n	1admin<br />\n	2 sales</p>\n', '2022-08-29 09:46:24', '', 'JOHN', 56, 12, '2022-09-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-29 09:46:24', 1, '2022-09-05 05:00:03'),
(11539, 20019, '', '11539', 'E', 1, '<p>\n	Create new databases<br />\n	<br />\n	1.create and copy<br />\n	Aboobaker<br />\n	Nibak general trading LLC<br />\n	Code : NI2026<br />\n	<br />\n	Copy customer, vendor, items and quantity from IS2022<br />\n	<br />\n	2.create only<br />\n	Rishtas<br />\n	NIBAK GENERAL TRADING LLC<br />\n	Code : NI2027</p>\n', '2022-08-29 10:35:58', '', 'JOHN', 56, 12, '2022-09-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-29 10:35:58', 1, '2022-09-06 05:00:01'),
(11540, 20019, '', '11540', 'E', 1, '<p>\n	John&#39;s Mobile App</p>\n', '2022-08-29 17:41:46', '', 'JOHN', 56, 2, '2022-08-29', 0, '0000-00-00', '', 0, '0', '', '30016', 0, 0, '', '', 69, '2022-08-29 17:41:46', 69, '2023-10-04 08:45:19'),
(11541, 20019, '', '11541', 'E', 1, '<p>\n	Laundry App copying</p>\n', '2022-08-30 07:33:07', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-30 07:33:07', 69, '2023-03-27 12:23:07'),
(11545, 20138, '', '11545', 'E', 1, '<p>\n	Insurance Card upload</p>\n', '2022-09-01 16:52:12', '', 'JOHN', 413, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-01 16:52:12', 1, '2022-09-12 05:00:02'),
(11543, 20002, '', '11543', 'I', 1, '<p>\n	Block Report viewing &amp; downloading options for all except for Mr. Hameed Faisel &amp; Mr. Ajith Kumar (Finance Manager).</p>\n<p>\n	For Zackeria (Delivery coordinator) &amp; Sujith (Logistics Manager) do not block Report &gt; Sales &amp; Inventory.</p>\n<p>\n	Is that possible to get a history of the persons who have downloaded reports?</p>\n<p>\n	Sales managers are unable to put dates for activity against a particular quote File.</p>\n<p>\n	&nbsp;</p>\n', '2022-08-31 16:15:37', '', 'JOHN', 5, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-08-31 16:15:37', 69, '2023-04-12 14:41:10'),
(11544, 20019, '', '11544', 'E', 1, '<p>\n	Time loss</p>\n', '2022-08-31 16:56:22', '', 'JOHN', 56, 12, '2022-09-07', 0, '0000-00-00', '', 0, '0', '', '30018', 0, 0, '', '', 69, '2022-08-31 16:56:22', 1, '2022-09-07 05:00:01'),
(11546, 20067, '', '11546', 'E', 1, '<p>\n	HR Dashboard - Modification<br />\n	see e mail dt 22/08/22<br />\n	(File cannot attach bcoz of Big size)</p>\n', '2022-09-01 16:55:55', '', 'JOHN', 200, 12, '2022-11-01', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-01 16:55:55', 1, '2022-11-01 06:00:01'),
(11547, 20138, '', '11547', 'E', 1, '<p>\n	Gratuity As on date Modification<br />\n	excel etc</p>\n', '2022-09-01 16:56:53', '', 'JOHN', 413, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-01 16:56:53', 1, '2022-09-12 05:00:02');
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
(11548, 20098, '', '11548', 'E', 1, '<p>\n	Receipt number RV/41143 was already allocated &hellip;But the same receipt number shows unallocated too</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65378 characters]', '2022-09-02 07:48:00', '01092022064110.pdf,Receipt_ENVIRO &amp; INDUSTRIAL SOLUTIONS ME_41143.pdf', 'JOHN', 293, 12, '2023-05-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-02 07:48:00', 69, '2023-05-10 08:46:26');
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
(11549, 20099, '', '11549', 'E', 1, '<p>\n	Staff board Menu permission</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65454 characters]', '2022-09-02 13:38:33', '', 'JOHN', 296, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-02 13:38:33', 1, '2022-09-12 05:00:02');
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
(11550, 20124, '', '11550', 'E', 1, '<p>\n	1. User Group Permission<br />\n	2. CBM &amp; BOE REport PDF + Excel<br />\n	3. Other inventory reports -- Bill of entry and bill of exit<br />\n	4. Set 4 masters</p>\n', '2022-09-03 14:34:57', '', 'JOHN', 371, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-03 14:34:57', 69, '2023-03-27 12:23:42'),
(11551, 20019, '', '11551', 'E', 1, '<p>\n	Google Cloud Project</p>\n', '2022-09-05 08:21:44', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-05 08:21:44', 69, '2023-04-12 14:41:03'),
(11552, 20118, '', '11552', 'E', 1, '<p>\n	Attendence uploading of 30/08, 31/08 , 01/09, 02/09</p>\n<p>\n	After data received from ZK</p>\n', '2022-09-05 15:23:15', '', 'JOHN', 353, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-05 15:23:15', 1, '2022-09-12 05:00:02'),
(11583, 20106, '', '11583', 'E', 1, '<p>\n	&nbsp;File No 1297<br />\n	&nbsp;Can you cancel the material receipt<br />\n	&nbsp;We have multiple lots in same items, so we need to divide the material receipt</p>\n<p>\n	&nbsp;</p>\n<p>\n	Design Issue in MR</p>\n', '2022-09-19 08:48:06', '', 'JOHN', 317, 12, '2022-09-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-19 08:48:06', 1, '2022-09-26 05:00:03'),
(11553, 20019, '', '11553', 'E', 1, '<p>\n	Alabeer DB 45 , needa a sales user ajman@alabeer &ndash; Jisha 05/09/22</p>\n<p>\n	&nbsp;</p>\n', '2022-09-05 17:41:39', '', 'JOHN', 56, 12, '2022-09-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-05 17:41:39', 1, '2022-09-15 05:00:01'),
(11555, 20117, '', '11555', 'E', 1, '<p>\n	ESS portal &ndash; document view button, same like what we did in admin portal<br />\n	Keep download button also</p>\n<p>\n	&nbsp;</p>\n', '2022-09-06 10:43:01', '', 'JOHN', 350, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 10:43:01', 1, '2022-09-12 05:00:02'),
(11556, 20071, '', '11556', 'E', 1, '<p>\n	Mail cc Egypt mail Dina-Viola</p>\n', '2022-09-06 10:43:20', '', 'JOHN', 212, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 10:43:20', 1, '2022-09-12 05:00:02'),
(11557, 20122, '', '11557', 'E', 1, '<p>\n	Rajesh today also not loaded, when I checked employee id was BPI-284 some thing, I changed that to itself-checked now its uploading-BPI</p>\n', '2022-09-06 10:43:46', '', 'JOHN', 365, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 10:43:46', 1, '2022-09-12 05:00:02'),
(11558, 20138, '', '11558', 'E', 1, '<p>\n	Sif generated employees coming in cash also-Alcargo</p>\n', '2022-09-06 10:44:13', '', 'JOHN', 413, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 10:44:13', 1, '2022-09-12 05:00:02'),
(11559, 20065, '', '11559', 'E', 1, '<p>\n	mtc leave&nbsp; bug -Magnum</p>\n', '2022-09-06 10:44:47', '', 'JOHN', 194, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 10:44:47', 1, '2022-09-12 05:00:02'),
(11560, 20078, '', '11560', 'I', 1, '<p>\n	moative amazon oru 1800 dh ellarkum leave varunnu. enthu ayyirikkum athu</p>\n', '2022-09-06 10:45:12', '', 'JOHN', 233, 12, '2022-09-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 10:45:12', 1, '2022-09-12 05:00:02'),
(11561, 20106, '', '11561', 'E', 1, '<p>\n	Mediyaan -&nbsp; Expiry date of items coming in DO 30197, 30206 &ndash; expiry date not matching</p>\n<p>\n	Mediyan &ndash; They need Lot number in DO print</p>\n<p>\n	Mediyaan &ndash; Duplicate DO&nbsp; and Original DO should be same print</p>\n<p>\n	Mediyaan &ndash; Inv 40189 , Dt 26/08 &ndash; document not downloading<br />\n	<br />\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2022-09-06 11:03:11', '', 'JOHN', 317, 12, '2022-09-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-06 11:03:11', 1, '2022-09-13 05:00:02'),
(11562, 20074, '', '11562', 'E', 1, '<p>\n	For Employee no M091 &ndash; I made an error in recording her increase.</p>\n<p>\n	From July 01, 2022 the below salary applies,</p>\n<p>\n	Basic: 12,000</p>\n<p>\n	Other allowance: 8000</p>\n<p>\n	Total: AED 20,000</p>\n<p>\n	I need,</p>\n<ol>\n	<li>\n		The record to be corrected with effect date of July 01, 2022</li>\n	<li>\n		The payroll in July and August to be fixed to reflect this as well</li>\n</ol>\n<p>\n	&nbsp;</p>\n', '2022-09-07 07:34:24', '', 'JOHN', 221, 12, '2022-09-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-07 07:34:24', 1, '2022-09-13 05:00:02'),
(11563, 20039, '', '11563', 'E', 1, '<p>\n	Modifications</p>\n', '2022-09-07 09:31:48', '', 'JOHN', 116, 12, '2022-09-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-07 09:31:48', 1, '2022-09-14 05:00:03'),
(11564, 20131, '', '11564', 'E', 1, '<p>\n	Corrections required<br />\n	Minhaj<br />\n	3. Clear super admin bills<br />\n	4. 40068 - advance 50 and 200 remaining<br />\n	5. 40005 - cash to gpay<br />\n	6. 40006 - Amount:143 and collected 140<br />\n	7. Invoice no 40150 date change to 13/8/22<br />\n	8. Invoice no 40197 date change to 16/8/22<br />\n	9. Invoice no 40205 date change to 17/8/22<br />\n	<br />\n	Nooruddin<br />\n	1. 40006 - date change 2/8/22<br />\n	2.40009 - date change 4/8/22<br />\n	3. 40009 - advance change to cash<br />\n	Muhabet</p>\n', '2022-09-07 10:42:36', '', 'JOHN', 392, 12, '2022-09-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-07 10:42:36', 1, '2022-09-14 05:00:03'),
(11565, 20028, '', '11565', 'I', 1, '<p>\n	Kindly check attached expenses it is have opening balance , but must be opening balance zero</p>\n<p>\n	&nbsp;</p>\n', '2022-09-07 10:56:00', '', 'JOHN', 83, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-07 10:56:00', 69, '2023-03-27 12:23:56'),
(11566, 20074, '', '11566', 'E', 1, '<p>\n	<span style=\"color:black\">What report can I take to know the visa, passport and labour card expiry of each branch? Please let me know. </span></p>\n', '2022-09-07 15:33:53', '', 'JOHN', 221, 12, '2022-09-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-07 15:33:53', 1, '2022-09-20 05:00:01'),
(11567, 20074, '', '11567', 'E', 1, '<p>\n	Rethink &ndash; Another document report for PRO, with multiple selection of Document and display only Name, document type and expiry</p>\n<p>\n	&nbsp;</p>\n', '2022-09-07 15:52:04', '', 'JOHN', 221, 12, '2022-09-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-07 15:52:04', 1, '2022-09-20 05:00:01'),
(11569, 20019, '', '11569', 'E', 1, '<p>\n	Testing</p>\n', '2022-09-12 16:37:02', '', 'JOHN', 56, 12, '2023-03-27', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-12 16:37:02', 69, '2023-03-27 12:24:26'),
(11581, 20098, '', '11581', 'E', 1, '<p>\n	Infinity &ndash; Purchase invoice 801080 &ndash; Grid total 14248, Inside total different. Please add 2 line items AWB 910112003691 &ndash; 3250.00 , door to port, 4687, 870012001185 &ndash; 1500.00, door to port, 4810</p>\n<p>\n	219663686</p>\n<p>\n	BAXFCM095123</p>\n<p>\n	&nbsp;</p>\n', '2022-09-16 14:43:45', '', 'JOHN', 293, 12, '2022-11-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-16 14:43:45', 1, '2022-11-06 06:00:02'),
(11573, 20002, '', '11573', 'E', 1, '<p>\n	There is no previous activities added in my Calendar. Also there is no option to add new activities&nbsp;</p>\n', '2022-09-14 08:10:19', '', 'Muhammed Hunaise K A', 4, 12, '2022-09-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2022-09-14 08:10:19', 1, '2022-09-22 05:00:02'),
(11570, 20019, '', '11570', 'E', 1, '<p>\n	Team Meeting dt 13/09/2022</p>\n', '2022-09-13 08:48:51', '', 'JOHN', 56, 12, '2023-08-05', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-13 08:48:51', 69, '2023-08-05 07:42:19'),
(11587, 20019, '', '11587', 'E', 1, '<p>\n	Bluesky Finance</p>\n', '2022-09-19 17:33:19', '', 'JOHN', 56, 2, '2022-09-19', 0, '0000-00-00', '', 0, '0', '', '30018', 0, 0, '', '', 69, '2022-09-19 17:33:19', 69, '2023-06-30 17:26:52'),
(11571, 20019, '', '11571', 'E', 1, '<p>\n	E Sell - Zaira clearing</p>\n', '2022-09-13 12:04:45', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-13 12:04:45', 69, '2023-04-12 14:40:54'),
(11572, 20048, '', '11572', 'E', 1, '<p>\n	Hi,</p>\n<p>\n	As disucssed please note the followig items which found different values in Transaction Details and Inventory. As per the physical stock, the value in the transaction details is correct.&nbsp;</p>\n<p>\n	The items are</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:421px;\" width=\"421\">\n	<tbody>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:149px;height:20px;\">\n				<p>\n					ENV-HVD5M-30R-89</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:149px;height:20px;\">\n				<p>\n					122-33P180YL</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:149px;height:20px;\">\n				<p>\n					122-31P181X</p>\n			</td>\n		</tr>\n		<tr>\n			<td nowrap=\"nowrap\" style=\"width:149px;height:20px;\">\n				<p>\n					ENV-HCV3F-30R-17</p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	Please check the same and revet us at the earliest.</p>\n', '2022-09-13 12:07:12', 'Screenshot 2022-09-13 133607_Inventory.png,Screenshot 2022-09-13 133545.png', 'Shabil -', 142, 12, '2022-09-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 55, '2022-09-13 12:07:12', 1, '2022-09-25 05:00:02'),
(11708, 20004, '', '11708', 'E', 1, '<p>\n	Distributor Analayis</p>\n<p>\n	New report</p>\n<p>\n	We would like to check the possibility of new report . You can charge us for this .</p>\n<p>\n	This report is consolidated order of all distributors for the selected range of months. Th sample attached for reference .</p>\n<p>\n	&nbsp;</p>\n', '2022-11-04 10:57:26', 'Report _New request.xlsx', 'JOHN', 11, 12, '2023-08-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-11-04 10:57:26', 69, '2023-08-24 07:52:07'),
(11574, 20116, '', '11574', 'E', 1, '<p>\n	Employee Grid when loading, sort on basis of emp id<br />\n	disable the sort option in data table- because it&#39;s useless since encrypted data</p>\n', '2022-09-14 17:50:08', '', 'JOHN', 347, 12, '2022-09-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-14 17:50:08', 1, '2022-09-21 05:00:02');
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
(11575, 20002, '', '11575', 'E', 1, '<p>\n	Norden - 1323-478113bk , Inventory showing 5 pc, Transaction report showing 2 pcs</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 31620 characters]\" /></p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 33727 characters]', '2022-09-14 17:51:19', '', 'JOHN', 5, 12, '2022-09-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-14 17:51:19', 1, '2022-09-22 05:00:02');
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
(11576, 20019, '', '11576', 'E', 1, '<p>\n	Qatar Bus count project</p>\n', '2022-09-15 08:19:16', '', 'JOHN', 56, 12, '2023-04-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-15 08:19:16', 69, '2023-04-12 14:40:48'),
(11577, 20013, '', '11577', 'I', 1, '<p>\n	Topnet - Created a new SO 206715 , when I am doing the delivery note for the same qty is showing 1 each instead of actual stock returned 2 each- Service item</p>\n<p>\n	&nbsp;</p>\n', '2022-09-15 09:56:11', '', 'JOHN', 38, 12, '2022-11-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-15 09:56:11', 1, '2022-11-06 06:00:02'),
(11578, 20117, '', '11578', 'E', 1, '<p>\n	Coral Aroma - When a new customer is saved and one contact is given, the contact is not saving. If they edit the customer and add contact, its saving</p>\n<p>\n	&nbsp;</p>\n', '2022-09-15 10:11:12', '', 'JOHN', 350, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '30018', 0, 0, '', '', 69, '2022-09-15 10:11:12', 1, '2022-09-27 05:00:02'),
(11579, 20061, '', '11579', 'E', 1, '<p>\n	Mobile App Modification</p>\n', '2022-09-16 08:09:14', '', 'JOHN', 182, 12, '2023-06-03', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-16 08:09:14', 69, '2023-06-03 15:07:55'),
(11580, 20019, '', '11580', 'E', 1, '<p>\n	Order , , DO, Invoice Same order in printing</p>\n<p>\n	Order , , DO, Invoice - Alternate id Correction<br />\n	&nbsp;</p>\n<p>\n	Mediyaan, Alamis, Al omda, Asco, Fnips, halo, millenium, miramer, Mohabet, Restuarent, Topnet llc, Rumicheese, Viola, United care</p>\n', '2022-09-16 08:20:20', '', 'JOHN', 56, 7, '2024-01-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-16 08:20:20', 583, '2024-01-02 15:52:58'),
(11582, 20002, '', '11582', 'E', 1, '<p>\n	<span style=\"color: rgba(0, 0, 0, 0.68); font-family: Ubuntu, sans-serif; font-size: 14.3px; text-align: center; white-space: nowrap; background-color: rgb(245, 245, 245);\">11573 is not closed, where are old reports&nbsp;</span></p>\n', '2022-09-16 15:42:08', '', 'Muhammed Hunaise K A', 4, 12, '2023-03-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 9, '2022-09-16 15:42:08', 69, '2023-03-24 08:12:26');
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
(11584, 20019, '', '11584', 'E', 1, '<p>\n	Deign issue in MR of ERP - check in all ERP&#39;s and correct (Refer picture for details)</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65392 characters]', '2022-09-19 08:50:27', '', 'JOHN', 56, 12, '2023-04-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-19 08:50:27', 69, '2023-04-15 07:50:10');
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
(11585, 20019, '', '11585', 'E', 1, '<p>\n	N2021 In E sell</p>\n<p>\n	Cut of date extended from 18/09/2022 for 5 days - put new date 23/09/2022</p>\n', '2022-09-19 10:49:23', '', 'JOHN', 56, 12, '2022-09-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-19 10:49:23', 1, '2022-09-26 05:00:03'),
(11586, 20004, '', '11586', 'E', 1, '<p>\n	Pre Invoice save error due to server local Migration</p>\n', '2022-09-19 14:15:44', '', 'JOHN', 11, 12, '2022-09-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2022-09-19 14:15:44', 1, '2022-09-26 05:00:03');
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
(11588, 20067, '', '11588', 'I', 1, '<p>\n	Good Day&hellip;!</p>\n<p>\n	Please find the below mentioned issue that there is no start and end date for selection in our trial balance.</p>\n<p>\n	We urgently required the trial balance for audit purpose, if possible, can you schedule one meeting with your finance team.</p>\n<p>\n	We hope this will consider as a high priority and sort out with immediate effect.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 52892 characters]\" /></p>\n', '2022-09-20 08:01:39', '', 'JOHN', 200, 12, '2022-09-27', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2022-09-20 08:01:39', 1, '2022-09-27 05:00:02');
