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"/>