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";
if($multiLine)$queryInvoices.=" AND ";$multiLine =true; $queryInvoices.="invoiceDate >= '".$creationDate."' "; } if($_GET['beforeDate']!="0") { if($multiLine)$queryInvoices.=" AND ";$multiLine =true; $queryInvoices.="invoiceDate <= '".$endDate."'"; } if($_GET['week']!="") { $year = date('Y'); $startDate = week_start_date($_GET['week'], $year); if($multiLine)$queryInvoices.=" AND ";$multiLine =true; $queryInvoices.=" invoiceDate < '".lastSunday($startDate)."' AND invoiceDate > '".getNextSaturday($startDate)."' "; } if($_GET['invoiceId']!=0) { if($multiLine)$queryInvoices.=" AND ";$multiLine =true; $queryInvoices.= " invoiceId like '".$_GET['invoiceId']."%' "; } if($_GET['projectId']!=0) { if($multiLine)$queryInvoices.=" AND ";$multiLine =true; $queryInvoices.= " project.projectId=".$_GET['projectId']; } if($_GET['customerId']!=0)