Service Appointment Summary Report
From Period: ".$StartApptDate." - ".$EndApptDate."
| Date | "; echo "Confirmed | "; echo "Arrived | "; echo "No Show | "; echo "Q.S | "; echo "G.J | "; echo "B.P | "; echo "Closed RO | "; echo "Open RO | "; echo "Cancelled Appt | "; echo ""; foreach ($period as $dt) { $curDate = $dt->format("Y-m-d"); $curDateNew=str_replace('-', '/', $curDate); $dayName = $dt->format("l"); $booked = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew'"),0); $noShow = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`=''"),0); $arrived = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!=''"),0); $qss = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_appt_type`='QS' AND `s_arrived_date`!=''"),0); $gj = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_appt_type`='GJ' AND `s_arrived_date`!=''"),0); $bp = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_appt_type`='BP' AND `s_arrived_date`!=''"),0); $arrived = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!=''"),0); $closed = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!='' AND `service_status`='1'"),0); $open = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `s_arrived_date`!='' AND `service_status`='0'"),0); $cancelled = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_comp_code`='$sCompID' AND `s_deal_code`='$sDealID' AND `appt_date`='$curDateNew' AND `service_status`='3'"),0); echo "
| ".$curDateNew." - ". $dayName." | "; echo "".$booked." | "; echo "".$arrived." | "; echo "".$noShow." | "; echo "".$qss." | "; echo "".$gj." | "; echo "".$bp." | "; echo "".$closed." | "; echo "".$open." | "; echo "".$cancelled." | "; echo "
___________________________________________
Prepared By: ".$uFname." ".$uLname."
Date: ". date_create() ->format("m/d/Y")."