Exemplo n.º 1
0
             $vehiStatus = "Hired";
             $vehiOwner = $fetch_getDetails[vi_ownerName];
             $vehiContact = $fetch_fin_info[vfi_hired_contact_no];
         } else {
             $vehiStatus = "New";
             $vehiOwner = $fetch_getDetails[vi_ownerName];
             $vehiContact = "Not Set";
         }
     }
 }
 $file = $dataPath . "client_" . $_SESSION[clientID] . "/" . date("d-m-Y", strtotime($sdate)) . "/" . $fetch_getDetails[vi_reg_no] . ".txt";
 //if(file_exists("../../reports_test/data/".date("d-m-Y", strtotime($z[$y]))."/TN22AM3207.csv"))
 if (chk_folder($file)) {
     //$op = kmsPerDay($file);
     $data = split("#", kmsPerDay($file));
     $timediff1 = getOverAllTripReport($sdate, $fetch_getDetails[vi_reg_no], $_POST[selPoint]);
 }
 if (count($timediff1) > 0) {
     foreach ($timediff1 as $key => $value) {
         $destPt = explode(",", $timediff1[$key]);
         for ($u = 0; $u < count($destPt); $u++) {
             $destVal = explode("#", $destPt[$u]);
             $endTime .= $destVal[1] . ',';
         }
         $strtHtml = $destVal[0] . ' - ' . count($destPt) . ' (' . $endTime . ')';
         $endTime = "";
         $r++;
     }
 } else {
     $strtHtml = "";
 }
if (isset($_POST[map_filter_btn]) && $_POST[map_filter_btn] != '') {
    //print_r($_POST);
    ?>
<div style="height:450px; width:900px; overflow:scroll; overflow-X:hidden;  border:1px solid #dfe9ed; border-top:0px solid #FFF;">
<?php 
    $timediff1 = array();
    $totalDistance = 0;
    $overAllTripData = "VehicleNo,Date";
    $overAllTripData .= "@";
    $ct = 0;
    $sdate = $_POST[from_date];
    $selVehicle = "SELECT * FROM vehicle_info where vi_clientId=" . $_SESSION[clientID];
    $rs_getVehicleDetails = mysql_query($selVehicle);
    while ($fetch_getDetails = @mysql_fetch_assoc($rs_getVehicleDetails)) {
        //echo $fetch_getDetails[vi_reg_no]."<br>";
        $timediff1 = getOverAllTripReport($sdate, $fetch_getDetails[vi_reg_no], $_POST[txtDestId]);
        //$fetch_getDetails[vi_reg_no]
        if (count($timediff1) != 0) {
            $overAllTripData .= $fetch_getDetails[vi_reg_no] . ',' . date("d-m-Y", strtotime($_POST[from_date]));
            $overAllTripData .= "@";
            ?>
<div id="" style="font:normal 12px/30px Arial, Helvetica, sans-serif;">
<table width="100%" border="0" cellspacing="0" cellpadding="0" id="grid">
   <tr>
        <td width="12%" class="sub_btn">Vehicle No: <?php 
            echo $fetch_getDetails[vi_reg_no];
            ?>
</td>
        <td width="12%" class="sub_btn">Date: <?php 
            echo date("d-m-Y", strtotime($_POST[from_date]));
            ?>