$datediff = floor(strtotime($frmdt) / (60 * 60 * 24)) - floor(strtotime($todt) / (60 * 60 * 24));
         $leaveDays = abs($datediff) + 1;
         $totalLeave = $totalLeave + $leaveDays - isSunday($frmdt, $todt);
         //echo "Total Leave : ".$totalLeave."\n";
     } else {
         if ($dateFrom === $month && $dateTo !== $month) {
             $leaveDays = date('t', strtotime($dta[$i]['leaveFrom'])) - date('j', strtotime($dta[$i]['leaveFrom']));
             /*echo $leaveDays."\n";
               echo "From Date : ".date('j', strtotime($dta[$i]['leaveFrom']))."-".$month." To Date : ".date('t', strtotime($dta[$i]['leaveFrom']))."-".$month." >>";*/
             $totalLeave = $totalLeave + $leaveDays + 1 - isSunday(date('j', strtotime($dta[$i]['leaveFrom'])) . "-" . $month, date('t', strtotime($dta[$i]['leaveFrom'])) . "-" . $month);
             //echo "Total Leave : ".$totalLeave."\n";
         } else {
             if ($dateFrom !== $month && $dateTo === $month) {
                 $workingDays = date('t', strtotime($dta[$i]['leaveTo'])) - date('j', strtotime($dta[$i]['leaveTo']));
                 $leaveDays = date('t', strtotime($dta[$i]['leaveTo'])) - (int) $workingDays;
                 $totalLeave = $totalLeave + $leaveDays - isSunday("01-" . $month, $dta[$i]['leaveTo']);
             }
         }
     }
     /*if ($dateRcvd === $month){
         echo $dateRcvd ."=".$month."\n";
       }*/
     $i++;
 }
 $TotalDays = cal_days_in_month(CAL_GREGORIAN, date("d", strtotime($monthY)), date("Y", strtotime($monthY)));
 /*echo "var : ".$monthY." Month : ".date("d",strtotime($monthY))." And Year :".date("Y",strtotime($monthY));
   echo "total Leave taken in this month ".$totalLeave."And total days :".$TotalDays;*/
 if ($totalLeave > 2) {
     $totalLeave = $totalLeave - 2;
 } else {
     $totalLeave = 0;
Example #2
0
session_start();
//p_array($_REQUEST);
//p_array($_SESSION);
$brokerId = $_REQUEST['brokerId'];
$driverId = $_REQUEST['driverId'];
$fromDate = to_YMD($_REQUEST['reportStartDate']);
$toDate = $_REQUEST['reportEndDate'] != "" ? to_YMD($_REQUEST['reportEndDate']) : date('Y-m-d');
//$fromDate = '2012-11-05';
//$toDate = '2013-02-10';
//echo $fromDate;
//echo "<br/>";
//echo $toDate;
//echo "<br/>";
//$firstSunday = strtotime('last Sunday', strtotime($fromDate));
//echo date('Y-m-d',$firstSunday);
$firstSunday = isSunday($fromDate) ? $fromDate : lastSunday($fromDate);
//echo $firstSunday;
$thisSunday = $firstSunday;
$nextSaturday = getNextSaturday($fromDate);
while (strtotime($thisSunday) <= strtotime($toDate)) {
    //echo $thisSunday." __ ".$nextSaturday."<br/>";
    //check for tickets
    $queryTickets = "\r\n\t\tSELECT\r\n\t\t\t*\r\n\t\tFROM\r\n\t\t\tticket\r\n\t\t\tJOIN truck using (truckId)\r\n\t\t\tLEFT JOIN reportticket using (ticketId)\r\n\t\tWHERE\r\n\t\t\tticketDate BETWEEN '{$thisSunday}' AND '{$nextSaturday}'\r\n\t\t\tAND reportId is null\r\n\t\t\tAND brokerId = {$brokerId} \r\n\t\t\t" . ($driverId != 0 ? " AND driverId = " . $driverId : "") . "\r\n\t";
    //echo $queryTickets."<br/>";
    $ticketsForReport = mysql_query($queryTickets, $conexion);
    if (mysql_num_rows($ticketsForReport) >= 1) {
        //echo "si hay sueltos<br/>";
        $queryInvoice = "\r\n\t\t\tINSERT INTO report (\r\n\t\t\t\treportDate,\r\n\t\t\t\tbrokerId,\r\n\t\t\t\treportStartDate,\r\n\t\t\t\treportEndDate,\r\n\t\t\t\treportType\r\n\t\t\t)\r\n\t\t\tvalues (\r\n\t\t\t\tCURDATE(),\r\n\t\t\t\t" . $_REQUEST['brokerId'] . ",\r\n\t\t\t\t'{$thisSunday}',\r\n\t\t\t\t'{$nextSaturday}',\r\n\t\t\t\t" . $_REQUEST['driverId'] . "\r\n\t\t\t)";
        mysql_query($queryInvoice, $conexion);
        $reportId = mysql_insert_id();
        $insertTickets = "\r\n\t\t\tINSERT INTO reportticket(\r\n\t\t\t\tticketId,\r\n\t\t\t\treportId\r\n\t\t\t)\r\n\t\t\t\tSELECT\r\n\t\t\t\t\tticketId,\r\n\t\t\t\t\t" . $reportId . "\r\n\t\t\t\tFROM\r\n\t\t\t\t\tticket\r\n\t\t\t\t\tJOIN truck using (truckId)\r\n\t\t\t\t\tLEFT JOIN reportticket using (ticketId)\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tticketDate BETWEEN '{$thisSunday}' AND '{$nextSaturday}'\r\n\t\t\t\t\tAND reportId is null\r\n\t\t\t\t\tAND brokerId = {$brokerId} \r\n\t\t\t\t\t" . ($driverId != 0 ? " AND driverId = " . $driverId : "") . "\r\n\t\t";