Warning: Undefined array key "scan_id" in /home/shinepestcontrol/aarthytest.shinepestcontrol.in/lab/ajax/scan/scan_list2.php on line 7

Deprecated: mysqli_real_escape_string(): Passing null to parameter #2 ($string) of type string is deprecated in /home/shinepestcontrol/aarthytest.shinepestcontrol.in/lab/ajax/scan/scan_list2.php on line 7
{"data":[],"status":"Success","remarks":"Data sent","total_records":"0","total_pages":0,"current_page":1,"sqlbase":"(SELECT psr.id as scan_patient_id, pd.patient_name, DATE_FORMAT(psr.dateTime, '%d-%b-%Y %h:%i %p') as dateTime, 'entry' AS type\r\n FROM patient_scan_record psr\r\n LEFT JOIN patient_data pd ON psr.patient_id = pd.id \r\n WHERE psr.status = 'Active' \r\n AND psr.id IN (\r\n SELECT DISTINCT psr.id\r\n FROM patient_scan_record psr\r\n LEFT JOIN patient_scan_data psd ON psr.id = psd.scan_patient_id \r\n LEFT JOIN scan_cat sc ON psd.scan_cat_id = sc.id \r\n LEFT JOIN scan s ON sc.scan_id = s.id \r\n WHERE s.id = '' \r\n \r\n )\r\n GROUP BY psr.id) UNION ( SELECT psr.id as scan_patient_id, pd.patient_name, DATE_FORMAT(psr.dateTime, '%d-%b-%Y %h:%i %p') as dateTime, 'op' AS type\r\n FROM op_entry_data psr \r\n LEFT JOIN patient_data pd ON psr.patient_id = pd.id \r\n WHERE psr.status IN ('Paid', 'Consulted') \r\n AND psr.id IN ( \r\n SELECT DISTINCT psr.id \r\n FROM op_entry_data psr \r\n JOIN op_bill_scan psd ON psr.id = psd.patient_record_id \r\n LEFT JOIN scan_cat sc ON psd.division_id = sc.id \r\n LEFT JOIN scan s ON sc.scan_id = s.id \r\n WHERE s.id = '' \r\n \r\n )\r\n GROUP BY psr.id ) UNION (SELECT psr.id as scan_patient_id, pd.patient_name, DATE_FORMAT(psr.dateTime, '%d-%b-%Y %h:%i %p') as dateTime, 'ip' AS type\r\n FROM ip_ob_entry_data psr \r\n LEFT JOIN patient_data pd ON psr.patient_id = pd.id \r\n WHERE psr.status NOT IN ('Discharged', 'Cancelled') \r\n AND psr.id IN ( \r\n SELECT psr.id \r\n FROM ip_ob_entry_data psr \r\n JOIN ip_bill_scan psd ON psr.id = psd.patient_record_id \r\n LEFT JOIN scan_cat sc ON psd.division_id = sc.id \r\n LEFT JOIN scan s ON sc.scan_id = s.id \r\n WHERE s.id = '' AND psr.patient_type = 'ip'\r\n \r\n )\r\n GROUP BY psr.id ) UNION ( SELECT psr.id as scan_patient_id, pd.patient_name, DATE_FORMAT(psr.dateTime, '%d-%b-%Y %h:%i %p') as dateTime, 'ob' AS type\r\n FROM ip_ob_entry_data psr \r\n LEFT JOIN patient_data pd ON psr.patient_id = pd.id \r\n WHERE psr.status NOT IN ('Discharged', 'Cancelled') \r\n AND psr.id IN ( \r\n SELECT DISTINCT psr.id \r\n FROM ip_ob_entry_data psr \r\n JOIN ob_bill_scan psd ON psr.id = psd.patient_record_id \r\n LEFT JOIN scan_cat sc ON psd.division_id = sc.id \r\n LEFT JOIN scan s ON sc.scan_id = s.id \r\n WHERE s.id = '' AND psr.patient_type = 'observation'\r\n \r\n )\r\n GROUP BY psr.id ) "}