$startDate = to_YMD($_GET['startDate']);
$endDate = to_YMD($_GET['endDate']);
$weekTable = array();
$nextSat = getNextSaturday($startDate);
//$weekArray['startDate'] = $startDate;
$weekArray['startDate'] = date('Y-m-d',strtotime($startDate));
$weekArray['endDate'] = $nextSat;
$weekTable[] = $weekArray;
while(strtotime($nextSat)< strtotime($endDate)){
$weekArray = array();
$nextSun = date('Y-m-d',strtotime('+1 day',strtotime($nextSat)));
$weekArray['startDate'] = $nextSun;
$weekArray['endDate'] = getNextSaturday($nextSun);
$nextSat = getNextSaturday($nextSun);
$weekTable[] = $weekArray;
}
/*
function getNextSaturday($date)
{
$now = strtotime($date);
//echo $now;
$nextSaturday = strtotime('next Saturday', $now);
return date('Y-m-d',$nextSaturday);
}*/
$queryMfi="
SELECT
public static function getNextSaturday()
{
return getNextSaturday();
}
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";
mysql_query($insertTickets, $conexion);
}
$thisSunday = date('Y-m-d', strtotime('+1 day', strtotime($nextSaturday)));
$nextSaturday = getNextSaturday($thisSunday);
}
/*
$queryInvoice="
insert into
report
(
reportDate,
brokerId,
reportStartDate,
reportEndDate,
reportType
)
values
(
CURDATE(),
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)
