connect_error) { die("Connection failed: " ); } //include_once("security.php"); $sqlUpdate = ""; //$sql = "SELECT laundary_job.`mart_code`, COUNT(laundary_job.`job_id`) AS count, laundary_mart.mart_name FROM laundary_job, laundary_mart WHERE laundary_mart.mart_code = laundary_job.mart_code AND laundary_job.`sch_date` - CURRENT_DATE > 3 AND laundary_job.job_tracker_progress IN('No_Update','Order_Placed', 'Order_On_Hold','Order_Processing','Order_Processed','Order_Delayed','Order_partly_Ready') GROUP BY `mart_code` "; $sql = "SELECT laundary_job.`mart_code`, COUNT(laundary_job.`job_id`) AS count, laundary_mart.mart_name FROM laundary_job, laundary_mart WHERE laundary_job.`job_date` >= '2022-02-10' AND laundary_mart.mart_code = laundary_job.mart_code AND laundary_job.`sch_date` < CURRENT_DATE AND laundary_job.job_tracker_progress IN('No_Update','Order_Placed', 'Order_On_Hold','Order_Processing','Order_Processed','Order_Delayed','Order_partly_Ready') GROUP BY `mart_code` "; $result = $conn->query($sql); $count = 0; $invoiceList = ""; $uniq = uniqid(); $msg = "Delays: (Mart : Invoice Count) \n"; if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { //$output[]=$row; //$array[] =$row; $mart_code = $row['mart_name']; $count = $row['count']; $msg .= " $mart_code: $count , "; } $sqlBasket = "INSERT INTO `sms_notification` (`sms_id`, `sms_type`, `sms_laundry_code`, `laundry_invoice_number`, `sms_client_code`, `sms_to`, `sms_job_price`, `sms_receipt_total`, `sms_other_msg`, `sms_basket_items`, `sms_status`, `ext_status`, `sms_mart_code`, `sms_created_by`, `sms_created_on`, `ext_ref`, `sms_date`, `sms_time`, `sms_timestamp`) VALUES (NULL, '22', '$uniq', 'N/A', 'C-26642446104396271', '256701809030', '0', NULL, '$msg', 'N?A', '0', 'pending', 'N?A', 'Admin', CURRENT_TIMESTAMP, 'N/A', CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP);"; $resultBasket = $conn->query($sqlBasket); if( $resultBasket){ echo "Updated $count invoice(s)
".$msg ; }else{ echo "Failed to update"; } } else { echo "0 results"; } $conn->close(); ?>