"; if ($status === "ASSIGN TEAM") { // echo "UPDATE `leads` SET `jc_no`='$jc_no',`contact_number`='$contact_number',`other_number`='$other_number',`alternate_number`='$alternate_number',`area`='$area',`type`='$type',`user_created_id`='$user_created_id',`payment_made`='$payment_made',`payment_type`='$payment_type',`slip_image`='$slip_path',`amount`=$amount,`team_assigned_id`='$team_assigned_id',`additional_notes`='$additional_notes',`status`='$status' WHERE `record_id` = '{$_POST['record_id']}'"; // echo "

"; // echo "INSERT INTO `jobcards`(`jc_no`,`date_created`,`user_id`, `team_assigned_id`) VALUES('{$_POST['jc_no']}','{$date}','{$_SESSION['user_id']}','{$_POST['team_assigned_id']}')"; // echo "

"; // echo "UPDATE `jobcards` SET `contact_number` = '{$_POST['contact_number']}', `other_number` = '{$_POST['other_number']}', `alternate_number` = '{$_POST['alternate_number']}', `address` = '{$_POST['area']}', `slip` = '{$_POST['slip']}' WHERE `jc_no` = '{$_POST['jc_no']}'"; $update_leads = $db->query("leads", "UPDATE `leads` SET `jc_no`='$jc_no',`contact_number`='$contact_number',`other_number`='$other_number',`alternate_number`='$alternate_number',`area`='$area',`type`='$type',`user_created_id`='$user_created_id',`payment_made`='$payment_made',`payment_type`='$payment_type',`slip_image`='$slip_path',`amount`=$amount,`team_assigned_id`='$team_assigned_id',`additional_notes`='$additional_notes',`status`='$status' WHERE `record_id` = '{$_POST['record_id']}'"); $jobcard_id = $db->query("jobcards", "INSERT INTO `jobcards`(`jc_no`,`date_created`,`user_id`, `team_assigned_id`) VALUES('{$_POST['jc_no']}','{$date}','{$_SESSION['user_id']}','{$_POST['team_assigned_id']}')"); $update_jobcard = $db->query("jobcards", "UPDATE `jobcards` SET `contact_number` = '{$_POST['contact_number']}', `other_number` = '{$_POST['other_number']}', `alternate_number` = '{$_POST['alternate_number']}', `address` = '{$_POST['area']}', `slip` = '{$_POST['slip']}' WHERE `jc_no` = '{$_POST['jc_no']}'"); } else { // echo "UPDATE `leads` SET `jc_no`='$jc_no',`contact_number`='$contact_number',`other_number`='$other_number',`alternate_number`='$alternate_number',`area`='$area',`type`='$type',`user_created_id`='$user_created_id',`payment_made`='$payment_made',`payment_type`='$payment_type',`slip_image`='$slip_path',`amount`='$amount',`team_assigned_id`='$team_assigned_id',`additional_notes`='$additional_notes',`status`='$status' WHERE `record_id` = '{$_POST['record_id']}'"; $update_leads = $db->query("leads", "UPDATE `leads` SET `jc_no`='$jc_no',`contact_number`='$contact_number',`other_number`='$other_number',`alternate_number`='$alternate_number',`area`='$area',`type`='$type',`user_created_id`='$user_created_id',`payment_made`='$payment_made',`payment_type`='$payment_type',`slip_image`='$slip_path',`amount`='$amount',`team_assigned_id`='$team_assigned_id',`additional_notes`='$additional_notes',`status`='$status' WHERE `record_id` = '{$_POST['record_id']}'"); } echo "";