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
(10144, 20013, '', '10144', 'I', 1, '<p>\n	Sales - Quotation, Order, Invoice Below footer and header make inactive</p>\n', '2020-06-30 15:01:59', '', 'JOHN', 38, 12, '2020-07-25', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-06-30 15:01:59', 1, '2020-07-25 05:00:02'),
(10145, 20002, '', '10145', 'E', 1, '<p>\n	Showing old batch number and qty in order conversion to Delivery table. Please rectify the same. Actual qty available is 35 rolls which the purchase done today. But in below table showing 22 + 35.</p>\n<p>\n	Item 71-3104182</p>\n', '2020-06-30 15:03:22', 'norden3006-1.jpg', 'JOHN', 5, 12, '2020-07-06', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-06-30 15:03:22', 1, '2020-07-06 05:00:03'),
(10146, 20002, '', '10146', 'E', 1, '<p>\n	Purchase debit note - reference shpould be purchase inv number by default. now some other number showing</p>\n', '2020-06-30 16:13:15', '', 'JOHN', 5, 12, '2020-07-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-06-30 16:13:15', 1, '2020-07-07 05:00:02'),
(10147, 20001, '', '10147', 'E', 1, '<p>\n	Finanace -&gt; Cheque Management -&gt; <strong>Search by voucher date&nbsp;</strong></p>\n', '2020-06-30 17:47:51', '', 'Acecentro User', 1, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-06-30 17:47:51', 1, '2020-08-16 05:00:02'),
(10148, 20001, '', '10148', 'E', 1, '<h4 class=\"modal-title\" style=\"box-sizing: inherit; font-family: Ubuntu, sans-serif; font-weight: 500; line-height: 1.42857; color: rgb(255, 255, 255); margin: 0px; font-size: 18px;\">\n	<span style=\"color:#000000;\">Bounced Cheque Resubmit - There is no option to select bank.</span></h4>\n', '2020-06-30 17:50:16', '', 'Acecentro User', 1, 12, '2020-08-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-06-30 17:50:16', 1, '2020-08-18 05:00:02'),
(10149, 20001, '', '10149', 'E', 0, '<p>\n	In the Hire inventory, We are not able to see in which Rack the spare parts are stored.&nbsp;</p>\n', '2020-06-30 17:52:11', '', 'Acecentro User', 1, 12, '2020-08-23', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 8, '2020-06-30 17:52:11', 1, '2020-08-23 05:00:03'),
(10298, 20014, '', '10298', 'E', 1, '<p>\n	Check the screenshot</p>\n', '2020-08-18 08:18:27', 'waddah180820.JPG', 'JOHN', 41, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-08-18 08:18:27', 1, '2022-07-29 05:00:04'),
(10150, 20008, '', '10150', 'I', 1, '<p>\n	DB display only to Gargash</p>\n', '2020-07-01 14:32:26', '', 'JOHN', 23, 12, '2021-02-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-01 14:32:26', 1, '2021-02-24 06:00:02'),
(10151, 20001, '', '10151', 'I', 1, '<p>\n	Landing cost problem . Purchase Invoice 900037</p>\n<p>\n	See attached excel file and screenshots</p>\n', '2020-07-01 15:32:36', 'Landed Cost.xlsx,WhatsApp Image 2020-07-01 at 3.22.41 PM.jpeg,WhatsApp Image 2020-07-01 at 3.22.06 PM.jpeg', 'JOHN', 2, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-01 15:32:36', 1, '2020-08-16 05:00:02'),
(10152, 20001, '', '10152', 'I', 1, '<p>\n	Landing cost problem</p>\n<p>\n	due to decimal places</p>\n<p>\n	see attached excel file - second tab</p>\n', '2020-07-01 17:30:19', 'Landed Cost97.xlsx', 'JOHN', 2, 12, '2020-08-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-01 17:30:19', 1, '2020-08-16 05:00:02'),
(10153, 20001, '', '10153', 'E', 1, '<p>\n	Flyer report modification</p>\n<p>\n	Flyers to be sent &amp; Flyer report</p>\n<p>\n	(See attached screenshot)</p>\n', '2020-07-02 10:21:41', 'WhatsApp Image 2020-07-02 at 10.16.48 AM.jpeg', 'JOHN', 2, 12, '2020-07-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-02 10:21:41', 1, '2020-07-10 05:00:05'),
(10154, 20019, '', '10154', 'E', 2, '<p>\n	Client display in Monitor</p>\n', '2020-07-02 10:35:46', '', 'JOHN', 56, 12, '2020-07-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-02 10:35:46', 69, '2020-07-04 08:10:35'),
(10155, 20003, '', '10155', 'E', 1, '<p>\n	&nbsp;</p>\n<p>\n	Hi ...pls add a &#39;Back&#39; button here in the menu of IMS document.</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 41712 characters]\" /></p>\n', '2020-07-02 11:00:46', '', 'Javeed Sathar', 7, 12, '2020-07-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-02 11:00:46', 1, '2020-07-10 05:00:05'),
(10156, 20003, '', '10156', 'E', 1, '<p>\n	Hi Arun,</p>\n<p>\n	&nbsp;</p>\n<p>\n	As discussedon the IMS menu,&nbsp; to add option to skip countdown and go back to the lists.</p>\n<p>\n	Thanks,</p>\n', '2020-07-02 11:41:29', '', 'Javeed Sathar', 7, 12, '2020-07-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-02 11:41:29', 1, '2020-07-10 05:00:05');
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
(10157, 20003, '', '10157', 'E', 1, '<p>\n	Dear Team,</p>\n<p>\n	In the Service Request Menu : Pls delete service requests numbers: 100019 &amp; 100020</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65262 characters]', '2020-07-02 11:48:41', '', 'Javeed Sathar', 7, 12, '2020-07-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-02 11:48:41', 1, '2020-07-10 05:00:05');
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
(10158, 20003, '', '10158', 'E', 1, '<p>\n	&nbsp;</p>\n<p>\n	Dear Team,</p>\n<p>\n	&nbsp;</p>\n<p>\n	In the Inspection Menu : Pls delete 1147 - 1133 inclusive.&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	thanks,</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65300 characters]', '2020-07-02 11:55:03', '', 'Javeed Sathar', 7, 12, '2020-07-10', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-02 11:55:03', 1, '2020-07-10 05:00:05');
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
(10159, 20002, '', '10159', 'E', 1, '<p>\n	Voucher editing - If voucher type changes, form resets the data. find a solution</p>\n', '2020-07-02 15:31:53', '', 'JOHN', 5, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-07-02 15:31:53', 1, '2022-07-29 05:00:04'),
(10160, 20019, '', '10160', 'E', 1, '<p>\n	Request for testing ne open items</p>\n', '2020-07-02 17:01:14', '', 'JOHN', 57, 12, '2020-07-02', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-02 17:01:14', 69, '2020-07-02 18:01:52'),
(10161, 20013, '', '10161', 'E', 1, '<p>\n	In the Quotation Report (Sales --&gt; Report --&gt; Quotation List), we don&#39;t get the quotations that are converted into orders. The report lists only the open, lost and closed quotations. Please include the quotatios that are won as well.</p>\n<p>\n	Thanks</p>\n<p>\n	Ganesan</p>\n', '2020-07-03 12:26:38', '', 'Ganesan K.', 38, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-03 12:26:38', 1, '2020-07-14 05:00:03'),
(10162, 20013, '', '10162', 'E', 1, '<p>\n	<strong>Incorrect Lead Owners</strong></p>\n<p>\n	In many quotations, the lead owners are being shown incorrectly.&nbsp;</p>\n<p>\n	For example: consider the following Quotation.&nbsp;</p>\n<table aria-describedby=\"tble_quotations_info\" class=\"table table-hover table-bordered personal-task dataTable\" id=\"tble_quotations\" role=\"grid\" style=\"box-sizing: inherit; border-spacing: 0px; background-color: transparent; width: 1289px; border-style: none solid solid; border-right-color: rgb(221, 221, 221); border-bottom-color: rgb(221, 221, 221); border-left-color: rgb(221, 221, 221); clear: both; caret-color: rgba(0, 0, 0, 0.68); color: rgba(0, 0, 0, 0.68); font-family: Helvetica, sans-serif; font-size: 14.300000190734863px; max-width: none !important; margin-bottom: 0px !important; margin-top: 0px !important;\">\n	<tbody style=\"box-sizing: inherit;\">\n		<tr class=\"odd\" role=\"row\" style=\"box-sizing: inherit; background-color: rgb(245, 245, 245);\">\n			<td class=\"nw sl col-max-5\" style=\"box-sizing: content-box; padding: 3px 8px; text-overflow: ellipsis; overflow: hidden; max-width: 250px; transition-delay: 200ms; position: static; float: none; line-height: 1.42857143; vertical-align: middle; border-style: none solid solid; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(221, 221, 221); border-bottom-color: rgb(221, 221, 221); border-left-color: rgb(221, 221, 221); background-color: rgb(200, 200, 200); text-decoration: line-through; white-space: nowrap !important;\">\n				119245</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857143; vertical-align: middle; border-style: none solid solid; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(221, 221, 221); border-bottom-color: rgb(221, 221, 221); border-left-color: rgb(221, 221, 221); background-color: rgb(200, 200, 200); text-decoration: line-through;\">\n				BEST LINE FOCUS TRADING LLC&nbsp;</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857143; vertical-align: middle; border-style: none solid solid; border-bottom-width: 0px; border-left-width: 0px; border-right-color: rgb(221, 221, 221); border-bottom-color: rgb(221, 221, 221); border-left-color: rgb(221, 221, 221); background-color: rgb(200, 200, 200); text-decoration: line-through;\">\n				22/04/2019</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	- if we open the quote for editing, Lead Owner is blank.</p>\n<p>\n	- if we print the quotation, lead owner it Akanska Singh (correct)</p>\n<p>\n	- if we list the quotations, lead owner is Deepa (incorrect)&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	It is not only for this quotation, it happens for many quotations.&nbsp;</p>\n<p>\n	Please check and fix it.</p>\n<p>\n	Thank you</p>\n<p>\n	Ganesan</p>\n', '2020-07-03 12:34:46', '', 'Ganesan K.', 37, 12, '2020-07-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-03 12:34:46', 1, '2020-07-07 13:31:50'),
(10163, 20013, '', '10163', 'E', 1, '<p>\n	Customer List - no quotes&nbsp;</p>\n<p>\n	We need a report for customers without any quotations&nbsp;</p>\n<p>\n	Thanks</p>\n<p>\n	Ganesan</p>\n', '2020-07-03 12:39:59', '', 'Ganesan K.', 38, 7, '2023-12-29', 0, '0000-00-00', '', 2, '0', '', '', 0, 0, '', '', 20, '2020-07-03 12:39:59', 4, '2023-12-29 13:49:35'),
(10164, 20013, '', '10164', 'E', 1, '<p>\n	Customer Created / Updated Report</p>\n<p>\n	This report needs to be modified.</p>\n<p>\n	Customer creation is different from customer updation, so selecting dates for both these in the report is confusing.&nbsp;</p>\n<p>\n	Please see the attached customer report, which is for customers created from 1/6/2020 to 3/7/2020, but it lists&nbsp;</p>\n<table border=\"1\" class=\"table table-fixed table-primary dataTable\" id=\"tbl_student_table\" style=\"box-sizing: inherit; border-spacing: 0px; border-collapse: collapse; background-color: transparent; width: 1259px; clear: both; caret-color: rgba(0, 0, 0, 0.68); color: rgba(0, 0, 0, 0.68); font-family: Helvetica, sans-serif; font-size: 14.300000190734863px; border: 1px solid rgb(181, 181, 181); max-width: none !important; margin-bottom: 6px !important; margin-top: 3px !important;\">\n	<tbody style=\"box-sizing: inherit;\">\n		<tr style=\"box-sizing: inherit;\">\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857143; vertical-align: middle; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(221, 221, 221);\">\n				4221</td>\n			<td style=\"box-sizing: content-box; padding: 3px 8px; line-height: 1.42857143; vertical-align: middle; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(221, 221, 221);\">\n				Gama Security Systems</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	This is an old customer. Maybe someone updated something on 17/6, but it shows as created on 17/6&nbsp;</p>\n<p>\n	So, the report should only include all customers <span style=\"background-color:#ffff00;\">created </span>during this period.</p>\n<p>\n	Better to have Customer Update report as a separate one, not to confuse the two.&nbsp;</p>\n<p>\n	Thanks</p>\n<p>\n	Ganesan</p>\n<p>\n	&nbsp;</p>\n', '2020-07-03 13:27:12', '', 'Ganesan K.', 37, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-03 13:27:12', 1, '2020-07-14 05:00:03'),
(10169, 20001, '', '10169', 'E', 1, '<p>\n	Purchase invoice - document upload failed</p>\n', '2020-07-06 11:33:39', 'ace060720.jpg', 'JOHN', 2, 12, '2020-07-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-06 11:33:39', 1, '2020-07-12 05:00:01'),
(10165, 20001, '', '10165', 'E', 1, '<p>\n	can you change the salary slip header (ACE/ARK) depending on the employee Branch</p>\n', '2020-07-05 15:55:36', '', 'JOHN', 2, 12, '2020-07-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-05 15:55:36', 1, '2020-07-12 05:00:01'),
(10166, 20013, '', '10166', 'E', 1, '<p>\n	Sales/Operations/Invoice menu display, require to include delivery note number in between Invoice and Sales Order number</p>\n<p>\n	Reason:-</p>\n<p>\n	- To know the item movement for a particular item, we refer Transaction detail report for the item and note down delivery note number and enquire delivery note number to track SO and findout invoice which is too much tedious roundwork.</p>\n', '2020-07-05 16:06:56', '', 'Ramachandiran V', 38, 12, '2020-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-05 16:06:56', 20, '2020-07-09 12:53:06'),
(10167, 20001, '', '10167', 'I', 1, '<p>\n	Payroll-Salary Payment- Cash/cheque/ sif / exchange - Add button missing to Finance Manager (user rights problem)</p>\n', '2020-07-05 17:13:59', '', 'JOHN', 2, 12, '2020-07-12', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-05 17:13:59', 1, '2020-07-12 05:00:01'),
(10168, 20019, '', '10168', 'E', 2, '<p>\n	Design issues in dashboard and graph</p>\n', '2020-07-06 08:52:22', '', 'JOHN', 57, 12, '2020-08-29', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-06 08:52:22', 69, '2020-08-29 09:45:20'),
(10553, 20014, '', '10553', 'E', 1, '<div class=\"gmail_default\" style=\"font-family:Arial,Helvetica,sans-serif\">\n	<font face=\"arial, sans-serif\">Please find the attached statement and ledger of one of the customer&#39;s Aging Total and 120 Days is fine but&nbsp;</font></div>\n<div class=\"gmail_default\" style=\"font-family:Arial,Helvetica,sans-serif\">\n	<font face=\"arial, sans-serif\">All the other aging periods are wrong. so we are not able to send statements to customers with this mistake</font></div>\n<div class=\"gmail_default\" style=\"font-family:Arial,Helvetica,sans-serif\">\n	<font face=\"arial, sans-serif\">requesting to check and correct</font></div>\n<div class=\"gmail_default\" style=\"font-family:Arial,Helvetica,sans-serif\">\n	&nbsp;</div>\n<div class=\"gmail_default\" style=\"font-family:Arial,Helvetica,sans-serif\">\n	<font face=\"arial, sans-serif\">For details check mail dated 20/01/2021 09:28 am</font></div>\n', '2021-01-20 09:39:54', '', 'JOHN', 41, 2, '2021-12-27', 0, '0000-00-00', '', 0, '0', '', '30006', 0, 0, '', '', 69, '2021-01-20 09:39:54', 69, '2021-12-27 09:28:39'),
(10172, 20016, '', '10172', 'E', 1, '<p>\n	Hide the outlet in invoice pdf print (see attached)</p>\n', '2020-07-07 09:54:04', 'WhatsApp Image 2020-07-07 at 9.19.16 AM.jpeg', 'JOHN', 47, 12, '2020-07-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-07 09:54:04', 1, '2020-07-13 05:00:01'),
(10170, 20001, '', '10170', 'I', 1, '<p>\n	Purchase Invoice conversion from QC</p>\n<p>\n	File No 1777 (MR 300032, 300040)</p>\n<p>\n	File No 1506 (MR 300031, 300042)</p>\n<p>\n	when converting either 300032 or 300040 - itstaking 300040 latest</p>\n<p>\n	please fix</p>\n', '2020-07-06 16:48:48', '', 'JOHN', 2, 12, '2020-07-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-06 16:48:48', 1, '2020-07-13 05:00:01'),
(10171, 20003, '', '10171', 'E', 1, '<p>\n	Contract&nbsp; Correction in services</p>\n', '2020-07-06 17:47:11', '', 'JOHN', 8, 12, '2020-07-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-06 17:47:11', 1, '2020-07-13 05:00:01'),
(10173, 20001, '', '10173', 'I', 1, '<p>\r\n	Multiple QC - invoice</p>\r\n<p>\r\n	When multiple QC exist against 1 file number, now when we convert one QC to invoice, the converted QC also shows convertable because the status taking from file id</p>\r\n<p>\r\n	so make it from QC or something , try it in ACE staging.Refer Service request id : 10170</p>\r\n', '2020-07-07 10:10:41', '', 'JOHN', 3, 12, '2020-09-04', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-07 10:10:41', 1, '2020-09-04 05:00:08'),
(10174, 20003, '', '10174', 'E', 1, '<p>\n	HSC delete modification</p>\n', '2020-07-07 12:34:18', '', 'JOHN', 8, 12, '2020-07-13', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-07 12:34:18', 1, '2020-07-13 05:00:01'),
(10175, 20003, '', '10175', 'E', 1, '<p>\n	Meeting Request Modification</p>\n', '2020-07-07 15:44:55', '', 'JOHN', 8, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-07 15:44:55', 1, '2020-07-14 05:00:03'),
(10176, 20001, '', '10176', 'I', 1, '<p>\n	Bug : Transfer items to Hire Warehouse</p>\n<p>\n	No 1225, Quantity couldnt be changed by editing</p>\n<p>\n	and also, if we delete a grid item, its not saving</p>\n', '2020-07-07 17:05:45', '', 'JOHN', 2, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-07 17:05:45', 1, '2020-07-14 05:00:03'),
(10177, 20008, '', '10177', 'E', 1, '<p>\n	Please delete the document uploaded in this policy 6272887 urgently as it was a ZIP file and I cannot able to delete the same.</p>\n', '2020-07-08 08:37:52', 'gargash0807.jpg', 'JOHN', 23, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-08 08:37:52', 1, '2020-07-14 05:00:03'),
(10178, 20019, '', '10178', 'E', 1, '<p>\n	Common work in HR</p>\n<p>\n	1. Mail for alpproval (with html button)</p>\n<p>\n	2. User group permission for new items</p>\n<p>\n	&nbsp;</p>\n', '2020-07-08 08:43:47', '', 'JOHN', 57, 12, '2020-07-21', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-08 08:43:47', 69, '2020-07-21 11:37:56'),
(10181, 20001, '', '10181', 'I', 1, '<p>\n	77-04-00036 is the last product of brand 77. but when we add a new product in brand&nbsp; 77, its showing 77-04-00034</p>\n<p>\n	&nbsp;</p>\n', '2020-07-08 12:23:55', '', 'JOHN', 2, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-08 12:23:55', 1, '2020-07-14 05:00:03'),
(10179, 20012, '', '10179', 'I', 1, '<p>\n	Finance - Bank - Integration</p>\n', '2020-07-08 10:43:46', '', 'JOHN', 35, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-08 10:43:46', 1, '2020-07-14 05:00:03'),
(10180, 20036, '', '10180', 'I', 1, '<p>\n	Kindly update on the modification we are requesting before regarding about the ff:</p>\n<p>\n	1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Void Transaction.</p>\n<p>\n	2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Delete Action.</p>\n', '2020-07-08 11:00:55', '', 'JOHN', 107, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30005', 0, 0, '', '', 69, '2020-07-08 11:00:55', 1, '2022-07-29 05:00:04'),
(10182, 20021, '', '10182', 'I', 2, '<p>\n	HR Data Migration</p>\n', '2020-07-08 14:46:18', '', 'JOHN', 62, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-08 14:46:18', 69, '2020-07-16 13:09:29'),
(10183, 20003, '', '10183', 'E', 1, '<p>\n	Meetings :-</p>\n<p>\n	1. Add a column in Summary to show 1/4 (1 completed out of 4 tasks)</p>\n<p>\n	2. In Summary If we open it, in the Agenda Add a Button called OPen Activity / Task and Display the pop up from Details. If it is not possible to open in same window, open in next tab.</p>\n<p>\n	3. Change Call Back label to Remind</p>\n<p>\n	4. Add the Meeting Number as the 1st Column in Summary</p>\n<p>\n	5. Change the Print Out. Top portoin to remain the same. After that</p>\n<p>\n	Point # : 1</p>\n<p>\n	Title / Heading</p>\n<p>\n	Details</p>\n<p>\n	Action To be Taken</p>\n<p>\n	Target Date :&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; Assigened to :&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; Status :</p>\n<p>\n	________________________________________________________________________</p>\n<p>\n	Point # : 2</p>\n<p>\n	Title / Heading</p>\n<p>\n	Details</p>\n<p>\n	Action To be Taken</p>\n<p>\n	Target Date :&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; Assigened to :&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; Status :</p>\n<p>\n	________________________________________________________________________</p>\n', '2020-07-08 17:20:30', '', 'Arun', 8, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 1, '2020-07-08 17:20:30', 10, '2020-07-16 13:59:24'),
(10184, 20002, '', '10184', 'E', 1, '<p>\n	cheque cancellation issue</p>\n', '2020-07-09 09:14:52', '', 'JOHN', 5, 12, '2020-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-09 09:14:52', 1, '2020-07-20 05:00:02'),
(10185, 20013, '', '10185', 'E', 0, '<p>\n	Support Call - 10166 -&nbsp;Unable to select status option when support call is work finished status (even though status LoV shows Close and ReOpen option.</p>\n', '2020-07-09 09:27:29', '', 'Ramachandiran V', 37, 12, '2020-07-09', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-09 09:27:29', 69, '2020-07-09 11:44:51'),
(10368, 20001, '', '10368', 'I', 1, '<p>\n	20-04-00060 : Drip Tray (2750 mm x 1530 mm x 75 mm x 3 mm)<br />\n	<br />\n	made direct purchase invoice in ARK and transferred to ACE<br />\n	<br />\n	NB: The cost price is only reflecting in ARK inventory.<br />\n	I should be reflected in ACE Inventory too.</p>\n', '2020-09-14 12:45:14', '', 'JOHN', 2, 12, '2021-03-07', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-09-14 12:45:14', 1, '2021-03-07 06:00:02'),
(10186, 20012, '', '10186', 'I', 1, '<p>\n	Tetra HR Instalation</p>\n', '2020-07-09 17:13:51', '', 'JOHN', 35, 12, '2020-08-24', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-09 17:13:51', 1, '2020-08-24 05:00:02'),
(10187, 20013, '', '10187', 'E', 1, '<p>\n	<em>Ref to above Pos, we reported on 20/6/2020 through WhatsApp and you have made correction. Now, when we investigating further, there seems to be transactional mistakes and not sure whether CRM or Operational Issue. The history is :-</em></p>\n<ol>\n	<li>\n		<em>PO 602249 is made for 1 qty</em></li>\n	<li>\n		<em>MRV 703158 is made</em></li>\n	<li>\n		<em>PO 602254 is made for 1 qty (not sure why entry is made, may be unable to convert into PI)</em></li>\n	<li>\n		<em>PI 803136 is made against PO 602254</em></li>\n</ol>\n<p>\n	<em>Now, hence, we need to cancel MRV703158 as item is already received, so that we can do short closure of the PO 602249.</em></p>\n<p>\n	<em>Ref to above Pos, we reported on 20/6/2020 through WhatsApp and you have made correction. Now, when we investigating further, there seems to be transactional mistakes and not sure whether CRM or Operational Issue. The history is :-</em></p>\n<ol>\n	<li>\n		<em>PO 602249 is made for 1 qty</em></li>\n	<li>\n		<em>MRV 703158 is made</em></li>\n	<li>\n		<em>PO 602254 is made for 1 qty (not sure why entry is made, may be unable to convert into PI)</em></li>\n	<li>\n		<em>PI 803136 is made against PO 602254</em></li>\n</ol>\n<p>\n	<em>Now, hence, we need to cancel MRV703158 as item is already received, so that we can do short closure of the PO 602249.</em></p>\n<p>\n	/Ram</p>\n', '2020-07-09 17:30:40', 'topnet120720.docx', 'Ramachandiran V', 37, 12, '2020-07-14', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-09 17:30:40', 20, '2020-07-14 11:58:03'),
(10188, 20013, '', '10188', 'E', 1, '<p>\n	Quotation List error</p>\n<p>\n	When taling a list of quotations which are open, it lists all quotations including won, lost and open.&nbsp;</p>\n<p>\n	Unable to attach anything in this service request, it is failing to attach</p>\n<p>\n	&nbsp;</p>\n', '2020-07-10 10:57:38', '', 'Ganesan K.', 37, 12, '2020-07-19', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 20, '2020-07-10 10:57:38', 1, '2020-07-19 05:00:01'),
(10189, 20019, '', '10189', 'E', 1, '<p>\n	EOS Print design</p>\n', '2020-07-11 10:40:15', '', 'JOHN', 56, 12, '2020-07-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-11 10:40:15', 1, '2020-07-18 05:00:02'),
(10190, 20001, '', '10190', 'I', 1, '<p>\n	User rights problem</p>\n<p>\n	user - Jaijith, Usergroup - warehouse</p>\n<p>\n	Reports - Hiring transaction legeder - permission</p>\n<p>\n	Masters - Rack - Add button permission</p>\n', '2020-07-11 12:49:31', '', 'JOHN', 3, 12, '2020-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-11 12:49:31', 1, '2020-07-20 05:00:02'),
(10191, 20001, '', '10191', 'E', 1, '<p>\n	User Rights - Hire -Order- Others- Copy Order not working</p>\n', '2020-07-12 10:35:10', '', 'JOHN', 2, 12, '2020-07-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-12 10:35:10', 1, '2020-07-18 05:00:02'),
(10192, 20013, '', '10192', 'E', 1, '<p>\n	Quotation status problem</p>\n<p>\n	See attached screenshots</p>\n', '2020-07-12 11:25:25', 'WhatsApp Image 2020-07-12 at 10.51.22 AM.jpeg,WhatsApp Image 2020-07-12 at 10.49.01 AM.jpeg,WhatsApp Image 2020-07-12 at 10.48.28 AM.jpeg', 'JOHN', 38, 12, '2020-07-18', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-12 11:25:25', 1, '2020-07-18 05:00:02'),
(10193, 20002, '', '10193', 'I', 1, '<p>\n	please display unit of measurement - Now id showing</p>\n<p>\n	Purchase - Delivery Tracker</p>\n', '2020-07-12 14:16:50', 'norden120720.png', 'JOHN', 6, 12, '2020-07-19', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-12 14:16:50', 1, '2020-07-19 05:00:01'),
(10194, 20013, '', '10194', 'E', 1, '<p>\n	Support :- PO Pending List</p>\n<p>\n	In Purchase Module Report, few clarifications and obervattions to be addressed.</p>\n<p>\n	- When PO Pedning qty is 0, why appears in this list/report</p>\n<p>\n	- When pending Qtys exist why then received qty not appears when we click detaied further (PO 602039)</p>\n<p>\n	- Also, the Unit Column displays number which does n&#39;t relzted to us</p>\n<p>\n	&nbsp;</p>\n<p>\n	Screenshot uploaded and request to adress and support.</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;-&nbsp;</p>\n', '2020-07-12 15:31:39', '', 'Ramachandiran V', 37, 12, '2020-10-26', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 20, '2020-07-12 15:31:39', 1, '2020-10-26 06:00:02'),
(10195, 20019, '', '10195', 'E', 2, '<p>\n	HR- New requirement for new client</p>\n<p>\n	Provide a report to include attendence machine detail (as a cost centre) in the filter</p>\n<p>\n	(as we discussed over phone)</p>\n', '2020-07-13 10:44:35', '', 'JOHN', 56, 12, '2020-07-20', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 69, '2020-07-13 10:44:35', 1, '2020-07-20 05:00:02'),
(10196, 20003, '', '10196', 'I', 1, '<p>\n	Multiple Issues</p>\n', '2020-07-13 10:50:58', '', 'Arun', 8, 12, '2022-07-29', 0, '0000-00-00', '', 0, '0', '', '30004', 0, 0, '', '', 1, '2020-07-13 10:50:58', 1, '2022-07-29 05:00:04'),
(10197, 20003, '', '10197', 'E', 1, '<p>\n	Dear Arun,</p>\n<p>\n	Pls see the below request ..which seems to have not done 100%. Pls check regarding the title of the and subject of email to reflect the type of job coming from Digitalog.</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_Reports@blueskyerp.me\">Digitalog_Reports@blueskyerp.me</a>; (<a href=\"mailto:digitalog_Reports@blueskyerp.me\">digitalog_Reports@blueskyerp.me</a></strong>&nbsp;via blueskyprojects.me)</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_Reminders@blueskyerp.me\">Digitalog_Reminders@blueskyerp.me</a>; (<a href=\"mailto:digitalog_Reminders@blueskyerp.me\">digitalog_Reminders@blueskyerp.me</a></strong>&nbsp;via blueskyprojects.me)</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_ServiceRequest@blueskyerp.me\">Digitalog_ServiceRequest@blueskyerp.me</a>; (digitalog_ServiceRequest&nbsp;</strong>@blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_IncidentReport@blueskyerp.me\">Digitalog_IncidentReport@blueskyerp.me</a>; (digitalog_ IncidentReport</strong>&nbsp;@blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_InvestigationReport@blueskyerp.me\">Digitalog_InvestigationReport@blueskyerp.me</a>; (digitalog_ InvestigationReport</strong>&nbsp;@blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_CorrectiveAction@blueskyerp.me\">Digitalog_CorrectiveAction@blueskyerp.me</a>; (digitalog_ CorrectiveAction</strong>&nbsp;@blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong>From:</strong>Javeed Sathar &lt;Javeed.Sathar@chalhoub.com&gt;<br />\n	<strong>Sent:</strong> 29 May 2020 13:18<br />\n	<strong>To:</strong> arun@mailbluesky.com; info@mailbluesky.com; Nancy Avila &lt;Nancy.Avila@chalhoub.com&gt;<br />\n	<strong>Subject:</strong> Mail identification</p>\n<p>\n	&nbsp;</p>\n<p>\n	Dear Arun,</p>\n<p>\n	&nbsp;</p>\n<p>\n	Can you rename the mail address titles as follows:</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_Reports@blueskyerp.me\">Digitalog_Reports@blueskyerp.me</a>; (<a href=\"mailto:digitalog_Reports@blueskyerp.me\">digitalog_Reports@blueskyerp.me</a></strong> via blueskyprojects.me)</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img border=\"0\" height=\"518\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image001.jpg\" style=\"height:5.395in;width:9.51in;\" width=\"913\" /></p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_Reminders@blueskyerp.me\">Digitalog_Reminders@blueskyerp.me</a>; (<a href=\"mailto:digitalog_Reminders@blueskyerp.me\">digitalog_Reminders@blueskyerp.me</a></strong> via blueskyprojects.me)</p>\n<p>\n	<img border=\"0\" height=\"449\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image002.jpg\" style=\"height:4.677in;width:9.854in;\" width=\"946\" /></p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_ServiceRequest@blueskyerp.me\">Digitalog_ServiceRequest@blueskyerp.me</a>; (digitalog_ServiceRequest </strong>@blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	&nbsp;</p>\n<p>\n	<img border=\"0\" height=\"479\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image003.jpg\" style=\"height:4.989in;width:8.51in;\" width=\"817\" /></p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_IncidentReport@blueskyerp.me\">Digitalog_IncidentReport@blueskyerp.me</a>; (digitalog_ IncidentReport</strong> @blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	&nbsp;</p>\n<p>\n	For new Incident Reports</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_InvestigationReport@blueskyerp.me\">Digitalog_InvestigationReport@blueskyerp.me</a>; (digitalog_ InvestigationReport</strong> @blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	&nbsp;</p>\n<p>\n	For the Report Managers reports</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong><a href=\"mailto:Digitalog_CorrectiveAction@blueskyerp.me\">Digitalog_CorrectiveAction@blueskyerp.me</a>; (digitalog_ CorrectiveAction</strong> @blueskyerp.me via blueskyprojects.me)</p>\n<p>\n	&nbsp;</p>\n<p>\n	For the Corrective Action reports</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<body id=\"cke_pastebin\" style=\"position: absolute; top: 116px; width: 1px; height: 1px; overflow: hidden; left: -1000px;\">\n	<strong><a href=\"mailto:Digitalog_Reports@blueskyerp.me\">Digitalog_Reports@blueskyerp.me</a>; (<a href=\"mailto:digitalog_Reports@blueskyerp.me\">digitalog_Reports@blueskyerp.me</a></strong>\n	<p>\n		&nbsp;via blueskyprojects.me)</p>\n</body>\n', '2020-07-13 14:18:24', 'pdf attachment of support ticket.pdf', 'Javeed Sathar', 7, 12, '2020-07-22', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-13 14:18:24', 10, '2020-07-22 21:59:58');
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
(10198, 20003, '', '10198', 'E', 1, '<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65491 characters]', '2020-07-13 14:23:28', 'pdf attachment of meeting minutes support ticket.pdf', 'Javeed Sathar', 7, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-13 14:23:28', 10, '2020-07-16 13:58:41');
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
(10199, 20003, '', '10199', 'E', 1, '<p>\n	The Meeting menu is linked to the masters menu. pls separate it...thanks!!</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n', '2020-07-13 15:52:47', '', 'Rukshad Doomasia', 7, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-13 15:52:47', 10, '2020-07-16 13:58:17');
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
(10200, 20003, '', '10200', 'E', 1, '<p>\n	Dear Arun,</p>\n<p>\n	&nbsp;</p>\n<p>\n	This is the one i forgot...Pls add a filed to &#39;NOTIFY&#39; internal staff in the below header and the mail should go as well.</p>\n<p>\n	thanks,</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65299 characters]', '2020-07-14 17:39:06', '', 'Javeed Sathar', 7, 12, '2020-07-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-14 17:39:06', 10, '2020-07-15 18:13:45');
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
(10201, 20003, '', '10201', 'E', 1, '<p>\n	Dear Arun,</p>\n<p>\n	&nbsp;</p>\n<p>\n	Just received this feedback&hellip;</p>\n<p>\n	&nbsp;</p>\n<p>\n	to increase the box size of teh meeting details (height) and also allow line breaks.</p>\n<p>\n	&nbsp;</p>\n<p>\n	attached pdf...</p>\n', '2020-07-14 20:14:42', 'Dear Arun...meeting minutes.pdf', 'Javeed Sathar', 7, 12, '2020-07-16', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-14 20:14:42', 10, '2020-07-16 13:57:46'),
(10202, 20003, '', '10202', 'E', 1, '<p>\n	&nbsp;</p>\n<p>\n	Dear Arun, In the meeting menu...the <u><strong>Conducted by</strong></u> and <u><strong>Attendees</strong></u> staff are not receiving emails if they are not in the <u><strong>Assigned to</strong></u> fields. This should not be the case. Even if they are not assigened any tasks, all partcipants of th emeeting should receive emails. See below feedback from user. Pls check. Thanks !!</p>\n<p>\n	&nbsp;</p>\n<p>\n	&nbsp;</p>\n<p>\n	<strong>From:</strong>Frederic Ricci &lt;Frederic.Ricci@chalhoub.com&gt;<br />\n	<strong>Sent:</strong> 15 July 2020 06:44<br />\n	<strong>To:</strong> Javeed Sathar &lt;Javeed.Sathar@chalhoub.com&gt;; Nancy Avila &lt;Nancy.Avila@chalhoub.com&gt;; Abdulrahman Abdulhadi &lt;Abdulrahman.Abdulhadi@chalhoub.com&gt;<br />\n	<strong>Subject:</strong> RE: DIGITALOG#Minutes of meeting</p>\n<p>\n	&nbsp;</p>\n<p>\n	Dear Javeed</p>\n<p>\n	One more point for your information</p>\n<p>\n	If we don&rsquo;t assign the attendees and conductor of the meeting= they are not receiving the emails</p>\n<p>\n	Regards</p>\n<p>\n	FR</p>\n<p>\n	&nbsp;</p>\n<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\n	<tbody>\n		<tr>\n			<td>\n				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n					<tbody>\n						<tr>\n							<td>\n								<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n									<tbody>\n										<tr>\n											<td>\n												<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n													<tbody>\n														<tr>\n															<td>\n																<p>\n																	<img border=\"0\" height=\"89\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image002.gif\" style=\"width:100px;\" width=\"100\" /></p>\n															</td>\n														</tr>\n													</tbody>\n												</table>\n											</td>\n											<td>\n												<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n													<tbody>\n														<tr>\n															<td>\n																<p>\n																	<img border=\"0\" height=\"85\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image004.jpg\" style=\"min-height:85px;max-height:85px;height:85px;\" width=\"49\" /></p>\n															</td>\n														</tr>\n													</tbody>\n												</table>\n											</td>\n										</tr>\n									</tbody>\n								</table>\n							</td>\n							<td>\n								<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n									<tbody>\n										<tr>\n											<td>\n												<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n													<tbody>\n														<tr>\n															<td>\n																<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\n																	<tbody>\n																		<tr>\n																			<td>\n																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"width:100.0%;\" width=\"100%\">\n																					<tbody>\n																						<tr>\n																							<td>\n																								<p>\n																									<strong>FREDERIC&nbsp;RICCI</strong><strong>?</strong></p>\n																							</td>\n																						</tr>\n																						<tr>\n																							<td>\n																								<p>\n																									SENIOR&nbsp;LOGISTICS&nbsp;MANAGER</p>\n																							</td>\n																						</tr>\n																						<tr>\n																							<td>\n																								<p>\n																									CHALHOUB&nbsp;GROUP</p>\n																							</td>\n																						</tr>\n																						<tr>\n																							<td>\n																								<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																									<tbody>\n																										<tr>\n																											<td>\n																												<p>\n																													+971&nbsp;4&nbsp;816&nbsp;8000</p>\n																											</td>\n																										</tr>\n																									</tbody>\n																								</table>\n																							</td>\n																						</tr>\n																						<tr>\n																							<td>\n																								<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																									<tbody>\n																										<tr>\n																											<td>\n																												<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																													<tbody>\n																														<tr>\n																															<td>\n																																<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																	<tbody>\n																																		<tr>\n																																			<td nowrap=\"nowrap\">\n																																				<p>\n																																					<a href=\"https://eur03.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.chalhoubgroup.com%2F&amp;data=02%7C01%7CJaveed.Sathar%40chalhoub.com%7C6865c8c85f5a414dca5108d8286900d1%7C6ef8304cf37b42a5a5690a7d8249fbf3%7C0%7C0%7C637303778770426826&amp;sdata=D3vjEds60QGkj59k%2Faq%2BxF%2FZueRoeUEJw373duWdxMs%3D&amp;reserved=0\" target=\"_blank\"><strong>chalhoubgroup.com</strong></a></p>\n																																			</td>\n																																			<td>\n																																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																					<tbody>\n																																						<tr>\n																																							<td>\n																																								<p>\n																																									|</p>\n																																							</td>\n																																						</tr>\n																																					</tbody>\n																																				</table>\n																																			</td>\n																																			<td>\n																																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																					<tbody>\n																																						<tr>\n																																							<td>\n																																								<p>\n																																									<a href=\"https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.chalhoubgroupcareers.com%2F&amp;data=02%7C01%7CJaveed.Sathar%40chalhoub.com%7C6865c8c85f5a414dca5108d8286900d1%7C6ef8304cf37b42a5a5690a7d8249fbf3%7C0%7C0%7C637303778770426826&amp;sdata=V5TeeEABEMiKoPB8MR6geP1MMRU0L0Ko0nwAT%2BabZzk%3D&amp;reserved=0\" target=\"_blank\"><strong>chalhoubgroupcareers.com</strong></a></p>\n																																							</td>\n																																						</tr>\n																																					</tbody>\n																																				</table>\n																																			</td>\n																																		</tr>\n																																	</tbody>\n																																</table>\n																															</td>\n																														</tr>\n																														<tr>\n																															<td>\n																																<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																	<tbody>\n																																		<tr>\n																																			<td>\n																																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																					<tbody>\n																																						<tr>\n																																							<td>\n																																								<p>\n																																									<a href=\"https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.instagram.com%2Fchalhoubgroup%2F&amp;data=02%7C01%7CJaveed.Sathar%40chalhoub.com%7C6865c8c85f5a414dca5108d8286900d1%7C6ef8304cf37b42a5a5690a7d8249fbf3%7C0%7C0%7C637303778770436820&amp;sdata=bBhn3MkVBJ%2BttlF11m6UHyyAKHrQkAZDv4Cu1FTonaA%3D&amp;reserved=0\" target=\"_blank\"><img border=\"0\" height=\"20\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image006.gif\" width=\"19\" /></a></p>\n																																							</td>\n																																						</tr>\n																																					</tbody>\n																																				</table>\n																																			</td>\n																																			<td>\n																																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																					<tbody>\n																																						<tr>\n																																							<td>\n																																								<p>\n																																									<a href=\"https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.linkedin.com%2Fcompany%2Fchalhoub-group&amp;data=02%7C01%7CJaveed.Sathar%40chalhoub.com%7C6865c8c85f5a414dca5108d8286900d1%7C6ef8304cf37b42a5a5690a7d8249fbf3%7C0%7C0%7C637303778770436820&amp;sdata=pXswtBNrOtIrUu1%2BEYn0ONcENlTHAXz3js9KB03nthY%3D&amp;reserved=0\" target=\"_blank\"><img border=\"0\" height=\"20\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image008.gif\" width=\"19\" /></a></p>\n																																							</td>\n																																						</tr>\n																																					</tbody>\n																																				</table>\n																																			</td>\n																																			<td>\n																																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																					<tbody>\n																																						<tr>\n																																							<td>\n																																								<p>\n																																									<a href=\"https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftwitter.com%2FChalhoubGroup&amp;data=02%7C01%7CJaveed.Sathar%40chalhoub.com%7C6865c8c85f5a414dca5108d8286900d1%7C6ef8304cf37b42a5a5690a7d8249fbf3%7C0%7C0%7C637303778770446814&amp;sdata=GEYNVwFMtchCsM%2BF0vrYJqcGJfqZA7e%2FnVIzcdmgLNs%3D&amp;reserved=0\" target=\"_blank\"><img border=\"0\" height=\"20\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image010.jpg\" width=\"19\" /></a></p>\n																																							</td>\n																																						</tr>\n																																					</tbody>\n																																				</table>\n																																			</td>\n																																			<td>\n																																				<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n																																					<tbody>\n																																						<tr>\n																																							<td>\n																																								<p>\n																																									<a href=\"https://eur03.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.glassdoor.com%2FOverview%2FWorking-at-Chalhoub-Group-EI_IE499602.11%2C25.htm&amp;data=02%7C01%7CJaveed.Sathar%40chalhoub.com%7C6865c8c85f5a414dca5108d8286900d1%7C6ef8304cf37b42a5a5690a7d8249fbf3%7C0%7C0%7C637303778770446814&amp;sdata=S9vrKQb0foDLFOkWpMlco87F0LKPn%2BTlHh3PVAMKhmk%3D&amp;reserved=0\" target=\"_blank\"><img border=\"0\" height=\"20\" src=\"file:///C:/Users/JSR/AppData/Local/Temp/msohtmlclip1/01/clip_image012.gif\" width=\"19\" /></a></p>\n																																							</td>\n																																						</tr>\n																																					</tbody>\n																																				</table>\n																																			</td>\n																																		</tr>\n																																	</tbody>\n																																</table>\n																															</td>\n																														</tr>\n																													</tbody>\n																												</table>\n																											</td>\n																										</tr>\n																									</tbody>\n																								</table>\n																							</td>\n																						</tr>\n																					</tbody>\n																				</table>\n																			</td>\n																		</tr>\n																	</tbody>\n																</table>\n															</td>\n														</tr>\n													</tbody>\n												</table>\n											</td>\n										</tr>\n									</tbody>\n								</table>\n							</td>\n						</tr>\n					</tbody>\n				</table>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	&nbsp;</p>\n', '2020-07-15 08:52:02', '', 'Javeed Sathar', 7, 12, '2020-07-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-15 08:52:02', 10, '2020-07-15 18:12:29');
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
(10203, 20003, '', '10203', 'E', 1, '<p>\n	Dear Arun..pls note ....to have the delete button on individual lines for normal users ..see below picture.</p>\n<p>\n	<img alt=\"\" src=\"data:image/png;base64,[encoded data, 65374 characters]', '2020-07-15 08:55:04', '', 'Nancy Avila', 7, 12, '2020-07-15', 0, '0000-00-00', '', 0, '0', '', '', 0, 0, '', '', 10, '2020-07-15 08:55:04', 10, '2020-07-15 18:12:57');
