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)