function testDates()
{
$ee = new getDate();
$dateArray4 = $ee->getDateHandler('2013-08-30', '2013-08-31');
$dateToday = date("Y-m-d");
$beginDate4 = $dateArray4[0];
$endDate4 = $dateArray4[1];
$this->assertEqual('2013-08-30 00:00:00', $beginDate4);
$this->assertEqual('2013-08-31 23:59:59', $endDate4);
}
<?php
require_once $_SERVER['DOCUMENT_ROOT'] . "../../php/cashRegisterConfig.php";
require_once 'connect.php';
require_once 'class_getdate.php';
$gd = new getDate();
$beginDate = isset($_GET['startdate']) ? $_GET['startdate'] : '';
$endDate = isset($_GET['enddate']) ? $_GET['enddate'] : '';
$datesReturned = $gd->getDateHandler($beginDate, $endDate);
$startDate = $datesReturned[0];
$stopDate = $datesReturned[1];
$sql = "select t1.pluID, sum(t1.amount) as sales, sum(t1.Tax) as taxAmount, t2.name as itemName from transaction as t1, department as t2 where t1.deptId=t2.id and (date BETWEEN \"{$startDate}\" AND \"{$stopDate}\") group by t1.deptId";
$result = mysql_query($sql);
if (mysql_error() != "") {
echo "Problem with query " . $sql . " error message is " . mysql_error();
quit;
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Virtual Cash Register Sales Report</title>
<?php
//include_once("meta.inc");
?>
</head>
<body>
<div data-role=page id="mainPage" data-theme="b"/>
