"; ?>
Upload New Service Appointment (CSV Format):
"; } ?>

Add Service Appointment

This module will allow you to Add, Edit or Delete service appointment to the system.
Calendar:
Import ✫ Export ✫ View
" style="color:blue;font-size:35px;;text-decoration:none"> ⇽ " style="color:blue;font-size:35px;text-decoration:none">⇾
"; $selectedDate=$i-$startday + 1; if($i < $startday) echo ""; else echo ""; if(($i % 7) == 6 ) echo ""; } ?>
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
"; $curDay = str_pad($cYear."/".($prev_month + 1), 2,0, STR_PAD_LEFT)."/".str_pad((($i-$startday) + 1),2, 0, STR_PAD_LEFT); $curSelDate = date_format(strtotime($curDay), "Y/mm/d"); $selDate = date("Y/m/d", strtotime($curDay)); if($selectedDate < 1){ }else{ echo "
"; $clickDate= $selDate; //echo $dealID; $countDateAppt = mysql_result(mysql_query("SELECT COUNT('s_id') FROM vts_service_transaction WHERE `s_deal_code`='$dealID' AND `appt_date`='$clickDate' || `transferred_to`='$dealID' AND `appt_date`='$clickDate' "),0); echo $countDateAppt; echo"
"; //HIGHT CURRENT DATE if($selectedDate == $mycDay){ echo ""; }else if($selectedDate < $mycDay && $mycMonth == $myMonth){ echo ""; }else{ echo ""; } } echo "
♲ Date: ".$pickDate ."
"; if($pickDate > $toDate){ $availabe='Enable'; $bColor=''; }else{ $availabe='Disabled'; $bColor='lightgray'; $aColor='gray'; } ?>
value="+ Add New" onclick="showHide()" style='background:;font-size:12px;color:;height:30px;width:85px;text-align:center;padding:0px'>
"; $loadTimeSlot = mysql_query("SELECT * FROM `vts_service_slots` WHERE `active`='1' AND `deal_id`='$dealID' ORDER BY `slot_id` ASC"); $dealCap=mysql_result(mysql_query("SELECT `area_capacity` FROM `vts_dealerships` WHERE `deal_id`='$dealID'"),0); $targetUR=mysql_result(mysql_query("SELECT `target_ur` FROM `vts_targeturs` WHERE `deal_id`='$dealID'"),0); //echo $targetUR; if(!empty($_GET['sid'])){ echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; while($row = mysql_fetch_array($loadTimeSlot)){ $tC=$row['slot_id']; $tcCount = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_deal_code`='$dealID' AND `appt_date`='$pickDate' || `transferred_to`='$dealID' AND `time_slot_code`='$tC' AND `appt_date`='$pickDate'"),0); $getBookedPerSlot = mysql_result(mysql_query("SELECT COUNT('s_id') FROM `vts_service_transaction` WHERE `s_deal_code`='$dealID' AND `time_slot_code`='$tC' AND `appt_date`='$pickDate' || `transferred_to`='$dealID' AND `time_slot_code`='$tC' AND `appt_date`='$pickDate'"),0); $avialableSlot = $row['time_slot_capacity']-$getBookedPerSlot; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
TIME SLOTCapacityBookedAvailable
".$row['time_slot']."".$row['time_slot_capacity']."".$getBookedPerSlot."".$avialableSlot."
"; } ?>