<?php
include ("header.php");
include ("functions.php");
//include ("functions2.php");

$sConn = mysql_connect($dbServer, $dbUser, $dbPass) 
or die("Couldn't connect to database server"); 

$dConn = mysql_select_db($dbDatabase, $sConn)
or die("Couldn't connect to database $dbDatabase");

$updateTrack = $_POST['updateTrack'];
if($updateTrack)
{
	$shipDate = date("F j, Y, g:i a");
	$sql = "UPDATE `amazonvOrders` SET tracking = '$updateTrack', shipDate = '$shipDate', `status` = 'Shipped' WHERE `orderID` ='$orderID' LIMIT 1 ;";
	//echo $sql;
	mysql_query($sql) or die("Couldn't add row 1"); 
}

$currentMonth = date('m');
$currentYear = date('y');

if ($currentMonth == 1)
{
$lastMonth = 12;
$lastYear = $currentYear - 1;
}
else
{
$lastMonth = str_pad($currentMonth - 1,2,"0",STR_PAD_LEFT);
$lastYear = $currentYear;
}

$month_name_str = array(
"01" => 'January',
"02" => 'February',
"03" => 'March',
"04" => 'April',
"05" => 'May',
"06" => 'June',
"07" => 'July',
"08" => 'August',
"09" => 'September',
"10" => 'October',
"11" => 'November',
"12" => 'December',
"All Time" => 'All Time'); 

/*if(!isset($showUsers)) { // This variable is set to zero for the first page
$showUsers = 'all';
$whereUsers = "";
}
else
{
if ($showUsers == 'all')
{
$whereUsers = "";
}
else
{
$whereUsers = "AND salesRep = '$showUsers'";
}
}

if(!isset($showStatus)) { // This variable is set to zero for the first page
$showStatus = 'all';
$whereStatus = "";
}
else
{
if ($showStatus == 'all')
{
$whereStatus = "";
}
else if ($showStatus == 'no cancel')
{
$whereStatus = "AND `status` <> 'Cancelled'";
}
else
{
$whereStatus = "AND `status` = '$showStatus'";
}
}*/

$showOnly = $_POST['showOnly']; // this be the real magic
$startdate = $_POST["startdate"];
$enddate = $_POST["enddate"];
if ($startdate != "" && $enddate != "")
{
$monthStart = substr($startdate,0,2);
$dayStart = substr($startdate,strpos($startdate,'/')+1,2);
$yearStart = substr($startdate,strrpos($startdate,'/')+1);

$newStart = $yearStart . "-" . $monthStart . "-" . $dayStart;

$monthEnd = substr($enddate,0,2);
$dayEnd = substr($enddate,strpos($enddate,'/')+1,2);
$yearEnd = substr($enddate,strrpos($enddate,'/')+1);

$newEnd = $yearEnd . "-" . $monthEnd . "-" . $dayEnd;

/*$show_string = "WHERE (TO_DAYS(DATE_FORMAT( CONCAT( RIGHT( dateOrder , length(dateOrder) - LOCATE('/', dateOrder , LOCATE('/', dateOrder) + 1 ) ) , '-' , LEFT( dateOrder , LOCATE('/', dateOrder ) - 1 ) , '-', SUBSTRING( dateOrder , LOCATE('/', dateOrder ) + 1, LOCATE('/', dateOrder , LOCATE('/', dateOrder ) + 1 ) - LOCATE('/', dateOrder ) - 1 ) ) , '%Y-%m-%d' )) - TO_DAYS('$newStart') >= 0) AND (TO_DAYS('$newEnd') - TO_DAYS(DATE_FORMAT( CONCAT( RIGHT( dateOrder , length(dateOrder) - LOCATE('/', dateOrder , LOCATE('/', dateOrder) + 1 ) ) , '-' , LEFT( dateOrder , LOCATE('/', dateOrder ) - 1 ) , '-', SUBSTRING( dateOrder , LOCATE('/', dateOrder ) + 1, LOCATE('/', dateOrder , LOCATE('/', dateOrder ) + 1 ) - LOCATE('/', dateOrder ) - 1 ) ) , '%Y-%m-%d' )) > 0) ";*/ // . $whereUsers . " " . $whereStatus;

$month_show = $startdate . " to " . $enddate;
	//$show_string = "WHERE TO_DAYS(dateOrder) - TO_DAYS('$startdate') > 0 AND  TO_DAYS('$enddate') - TO_DAYS(dateOrder) > 0";
}
else if ($showOnly == "all")
{
$show_string = "WHERE 1 = 1 "; // . $whereUsers . " " . $whereStatus;
$month_name = "All Time";
$month_show = "All Time";
}
else if ($showOnly == "last")
{
$show_string = "WHERE dateOrder REGEXP '^$lastMonth' AND dateOrder REGEXP '$lastYear$' " . $whereUsers . " " . $whereStatus;
$month_name = $lastMonth;
$month_show = $month_name_str["$month_name"];
}
else
{
$showOnly = "current";
$show_string = "WHERE dateOrder REGEXP '^$currentMonth' AND dateOrder REGEXP '$currentYear$' " . $whereUsers . " " . $whereStatus;
$month_name = $currentMonth;
$month_show = $month_name_str["$month_name"];
}

$show_string = "";

//select from database all the Amazon Vendor ORDERS COUNT
$dbQuery = "SELECT * FROM `amazonvOrders` " . $show_string . " GROUP BY `orderID`"; 
//echo $dbQuery;
$result = mysql_query($dbQuery) or die("Couldn't get the Contacts");
$nume = mysql_num_rows($result); 

if(!isset($start)) { // This variable is set to zero for the first page
$start = 0;
}

$eu = ($start - 0);
$limit = 30; // No of records to be shown per page.
$tthis = $eu + $limit;
$back = $eu - $limit;
$next = $eu + $limit;

//echo $show_string;
?>
<form style="text-align:left;" name="showing" action="amazonv_orders.php" method="post">
<script language="Javascript" src="cal/calendar.js">
</script>
<!--Status: 
<select name="showStatus" size="1" style="margin: 0px; padding: 0px; width: 95px; font-size: 11px;">
<?php 
$queryStatus = "SELECT * FROM `status-order`";
$resultStatus = mysql_query($queryStatus);
while($myrow1 = mysql_fetch_array($resultStatus))
{
echo "<option value=\"" . $myrow1["status"] . "\""; 
if($showStatus==$myrow1["status"]) 
echo "selected=\"selected\"";
echo ">" . $myrow1["status"] . "</option>";
}
?>
<option value="all" <? if($showStatus=="all") echo "selected=\"selected\"";?> >All</option>
<option value="no cancel" <? if($showStatus=="no cancel") echo "selected=\"selected\"";?> >All but Cancelled</option>
</select> 
Sales Rep: 
<select name="showUsers" size="1" style="margin: 0px; padding: 0px; width: 95px; font-size: 11px;">
<?php 
$queryUsers = "SELECT * FROM `users`";
$resultUsers = mysql_query($queryUsers);
while($myrow1 = mysql_fetch_array($resultUsers))
{
echo "<option value=\"" . $myrow1["name"] . "\""; 
if($showUsers==$myrow1["name"]) 
echo "selected=\"selected\"";
echo ">" . $myrow1["name"] . "</option>";
}
?>
<option value="all" <? if($showUsers=="all") echo "selected=\"selected\"";?> >All</option>
</select> -->
Date Range:
<input type="Text" name="startdate" size="10" value="<?= $startdate; ?>" ><a href="javascript: void(0);" onClick="return getCalendar(document.showing.startdate);" ><img src="cal/calendar.png" border="0" /></a>
<input type="Text" name="enddate" size="10" value="<?= $enddate; ?>"><a href="javascript: void(0);" onClick="return getCalendar(document.showing.enddate);" ><img src="cal/calendar.png" border="0" /></a>
<input type="submit" name="submitShow" value="Show"/>

<select name="showOnly" size="1" style="margin: 0px; padding: 0px; width: 75px; font-size: 11px;">
<option value="all" <? if($showOnly=="all") echo "selected=\"selected\"";?> >All</option>
<option value="current"  <? if($showOnly=="current") echo "selected=\"selected\"";?>>This Month</option>
<option value="last"  <? if($showOnly=="last") echo "selected=\"selected\"";?>>Last Month</option>
</select> 
<input type="submit" name="submitShow" value="Show"/> </form><BR /><BR />

<?php
$query1 = "SELECT SUM(price) AS total FROM `amazonvOrders` " . $show_string;
$result1 = mysql_query($query1);
while($myrow = mysql_fetch_array($result1))
 {
 echo "<b>" . $month_show . " Total Sales: </b> $" . number_format($myrow["total"],2,'.',',');
 echo "&nbsp;&nbsp;<button onclick=\"javascript:GlobalPopUp('packingslipAmazonVAll.php',650,650);\" align=\"right\">Print All Packing Slips</button>";
 }
 
 //echo "month name= " . $month_show . " - " . $month_name_str["$month_name"] . " - " . $month_name;
 //NUMBERING
 echo "<table align = 'center' width='100%'><tr><td align='left' width='10%'>";
if($back >=0) {
print "<a href='amazonv_orders.php?start=$back&showOnly=$showOnly&showUsers=$showUsers&showStatus=$showStatus' class='numbering'><< PREV</a>";
}

echo "</td><td align=center width='60%'>";
$i=0;
$l=1;
for($i=0; $i<$nume; $i=$i+$limit){
if($i <> $eu){
echo " <a href='amazonv_orders.php?start=$i&showOnly=$showOnly&showUsers=$showUsers&showStatus=$showStatus' class='numbering'>$l</a> ";
}
else { echo "<font face='Verdana' size='4' color='#ae0011'>$l</font>";
} 
/// Current page is not displayed as link and given font color red
$l=$l+1;
}

echo "</td><td align='right' width='10%'>";
if($tthis < $nume) {
print "<a href='amazonv_orders.php?start=$next&showOnly=$showOnly&showUsers=$showUsers&showStatus=$showStatus' class='numbering'>NEXT >></a>";
}
echo "</td>";
echo "<td align='right' width='20%' class='numbering'>No. of Orders $nume </td>";
echo "</tr></table>";
 
$query = "SELECT * FROM `amazonvOrders` " . $show_string . " GROUP BY `orderID` ORDER BY `primary` ASC LIMIT $eu, $limit;";
//echo $query;
$result = mysql_query($query);
	table_header_orders_amazonv("Amazon Vendor Orders", "#AE0011");
	display_amazonv_order_data_full($result);
	
echo "<table align = 'center' width='100%'><tr><td align='left' width='10%'>";
if($back >=0) {
print "<a href='amazonv_orders.php?start=$back&showOnly=$showOnly&showUsers=$showUsers&showStatus=$showStatus' class='numbering'><< PREV</a>";
}

echo "</td><td align=center width='60%'>";
$i=0;
$l=1;
for($i=0; $i<$nume; $i=$i+$limit){
if($i <> $eu){
echo " <a href='amazonv_orders.php?start=$i&showOnly=$showOnly&showUsers=$showUsers&showStatus=$showStatus' class='numbering'>$l</a> ";
}
else { echo "<font face='Verdana' size='4' color='#ae0011'>$l</font>";
} 
/// Current page is not displayed as link and given font color red
$l=$l+1;
}

echo "</td><td align='right' width='10%'>";
if($tthis < $nume) {
print "<a href='amazonv_orders.php?start=$next&showOnly=$showOnly&showUsers=$showUsers&showStatus=$showStatus' class='numbering'>NEXT >></a>";
}
echo "</td>";
echo "<td align='right' width='20%' class='numbering'>No. of Orders $nume </td>";
echo "</tr></table>";
?>
</body>
</html>