<?php
require "inc_header_ps.php";
require_once '../lib/Relationship.php';
mysql_select_db($db_name, $oConn);
// 2014-09-22 Updated ^CS
$scheduledDateStart = $_GET['scheduledDateStart'];
$scheduledDateEnd = $_GET['scheduledDateEnd'];
$view = View::CanViewPage($_SESSION['userNum'], $_SESSION['customerId']);
$sql = "";
if ($view == "admin" || $view == "super") {
$sql = "SELECT\n\t\t\t\te.EventID,\n\t\t\t\te.EventTypeID,\n\t\t\t\tet.EventTypeName,\n\t\t\t\tet.Duration,\n\t\t\t\te.ScheduledDate,\n\t\t\t\te.ClosedDate,\n\t\t\t\te.AssignedTruckId,\n\t\t\t\te.AssignedUserId,\n\t\t\t\te.TagID,\n\t\t\t\tj.Address,\n\t\t\t\tj.City,\n\t\t\t\tj.State,\n\t\t\t\tj.Zip,\n\t\t\t\tj.Lat,\n\t\t\t\tj.Lng,\n\t\t\t\tj.JobNum,\n\t\t\t\tj.JobName,\n\t\t\t\tt.TruckName,\n\t\t\t\tt.TruckID,\n\t\t\t\tt.ID,\n\t\t\t\ts.TruckName AS SuperTruckName,\n\t\t\t\ts.TruckID AS SuperTruckID,\n\t\t\t\ts.ID AS SuperID\n\t\t\tFROM\n\t\t\t\tEvents e\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tJobs j ON j.JobNum = e.AssignedJobID\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tGPSTruck t ON t.ID = e.AssignedTruckID\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tEventTypes et ON et.EventTypeID = e.EventTypeID\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tGPSTruck s ON s.TruckID = e.AssignedUserID\n\t\t\tWHERE\n\t\t\t\te.ScheduledDate between '{$scheduledDateStart}' and '{$scheduledDateEnd}'\n\t\t\t\tAND j.Lat is NOT NULL\n\t\t\t\tAND et.GPS = 'yes'\n\t\t\t\tAND j.CustomerId = {$_SESSION['customerId']}";
} else {
if ($view == "salesperson") {
$sql = "SELECT\n\t\t\t\tpbsc.SalesPerson,\n\t\t\t\tJobs . *,\n\t\t\t\tEventTypes.EventTypeName,\n\t\t\t\tCompaniesJob.Name AS Customer,\n\t\t\t\tEvents . *,\n\t\t\t\tt . *\n\t\t\tFROM\n\t\t\t\tEvents\n\t\t\t\t\tJOIN\n\t\t\t\tEventTypes ON (Events.EventTypeID = EventTypes.EventTypeID)\n\t\t\t\t\tJOIN\n\t\t\t\tJobs ON (Events.AssignedJobID = Jobs.JobNum)\n\t\t\t\t\tJOIN\n\t\t\t\tCompanies AS CompaniesJob ON (CompaniesJob.CompanyNum = Jobs.ClientNum)\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tFormsPbSalesCoord AS pbsc ON (pbsc.CompanyNum = Jobs.ClientNum)\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tGPSTruck t on t.ID = Events.AssignedTruckID\n\t\t\tWHERE\n\t\t\t\tEvents.ScheduledDate between '{$scheduledDateStart}' and '{$scheduledDateEnd}'\n\t\t\t\tAND et.GPS = 'yes'\n\t\t\t\tAND pbsc.Salesperson = {$_SESSION['userNum']}";
} else {
if ($view == "crew") {
$sql = "SELECT\n\t\t\t\te.EventID,\n\t\t\t\te.EventTypeID,\n\t\t\t\tet.EventTypeName,\n\t\t\t\tet.Duration,\n\t\t\t\te.ScheduledDate,\n\t\t\t\te.ClosedDate,\n\t\t\t\te.AssignedTruckId,\n\t\t\t\te.TagID,\n\t\t\t\tj.Address,\n\t\t\t\tj.City,\n\t\t\t\tj.State,\n\t\t\t\tj.Zip,\n\t\t\t\tj.Lat,\n\t\t\t\tj.Lng,\n\t\t\t\tj.JobNum,\n\t\t\t\tj.JobName,\n\t\t\t\tt.TruckName,\n\t\t\t\tt.TruckID,\n\t\t\t\tt.ID\n\t\t\tFROM\n\t\t\t\tEvents e\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tJobs j ON j.JobNum = e.AssignedJobID\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tGPSTruck t ON t.ID = e.AssignedTruckID\n\t\t\t\t\tLEFT JOIN\n\t\t\t\tEventTypes et ON et.EventTypeID = e.EventTypeID\n\t\t\tWHERE\n\t\t\t\te.ScheduledDate between '{$scheduledDateStart}' and '{$scheduledDateEnd}'\n\t\t\t\tAND j.Lat is NOT NULL\n\t\t\t\tAND et.GPS = 'yes'\n\t\t\t\tAND t.TruckID = {$_SESSION['userNum']}\n\t\t\t\tAND j.CustomerId = {$_SESSION['customerId']}";
}
}
}
$result = mysql_query($sql, $oConn);
if ($result == false) {
echo $sql;
die(mysql_error());
}
$tasks = array();
while ($row = mysql_fetch_array($result)) {
$address = $row['Address'] . " " . $row['City'] . " " . $row['State'] . " " . $row['Zip'];
array_push($tasks, array("TruckName" => $row['TruckName'], "TruckID" => $row['TruckID'], "AssignedTruckId" => $row['AssignedTruckId'], "SuperTruckName" => $row['SuperTruckName'], "SuperTruckID" => $row['SuperTruckID'], "SuperID" => $row['SuperID'], "TagID" => $row['TagID'], "Address" => $address, "Lat" => $row['Lat'], "Lng" => $row['Lng'], "ScheduledDate" => $row['ScheduledDate'], "ClosedDate" => $row['ClosedDate'], "jobName" => $row['JobName'], "jobNum" => $row['JobNum'], "eventTypeName" => $row['EventTypeName'], "eventTypeId" => $row['EventTypeID'], "taskId" => $row['JobNum'], "eventId" => $row['EventID'], "duration" => $row['Duration']));
}
