function __construct($orientation, $metric, $size, $datefrom)
{
$dynamicY = 0;
$this->dateFrom = $datefrom;
start_db();
parent::__construct($orientation, $metric, $size);
$this->SetAutoPageBreak(true, 30);
$this->AddPage();
try {
$startdate = convertStringToDate($this->dateFrom);
$sql = "SELECT A.name, C.amount,\n\t\t\t\t\t (\n\t\t\t\t\t \t\tSELECT SUM(B.amount) * D.retailprice\n\t\t\t\t\t \t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t \t\tINNER JOIN {$_SESSION['DB_PREFIX']}product D\n\t\t\t\t\t \t\tON D.id = B.productid \n\t\t\t\t\t \t\tWHERE B.eventid = A.id \n\t\t\t\t\t \t\tAND B.eventdate = '{$startdate}' \n\t\t\t\t\t \t\tAND B.type = 'S'\n\t\t\t\t\t ) AS sold\n\t\t\t\t\t FROM {$_SESSION['DB_PREFIX']}event A \n\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}eventforecast C\n\t\t\t\t\t ON C.eventid = A.id\n\t\t\t\t\t AND C.forecastdate = '{$startdate}' \n\t\t\t\t\t\tORDER BY A.name";
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$sold = $member['sold'] != "" ? $member['sold'] : 0;
$line = array("Event" => $member['name'], "Takings" => "£ " . number_format($sold, 2), "Expected" => "£ " . number_format($member['amount'], 2));
$this->addLine($this->GetY(), $line, 6.2);
}
} else {
logError($sql . " - " . mysql_error());
}
} catch (Exception $e) {
logError($e->getMessage());
}
}
public function notifyCleaner($id)
{
$sql = "SELECT A.name AS clientname\n\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}client A\n\t\t\t\t\tWHERE id = " . $this->clientid;
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$memberid = $_POST['memberid'];
$enddate = convertStringToDate($_POST['canceldate']);
if ($enddate == "") {
$enddate = "0000-00-00";
}
if ($this->weekday != $_POST['weekday'] || $this->staffid != $_POST['memberid']) {
// logError("WEEK DAY OR STAFF CHANGED", false);
$clientname = $member['clientname'];
$lines = "Shift allocated to you on " . $this->getWeekDay($_POST['weekday']) . " " . $_POST['starttime'] . "-" . $_POST['endtime'] . " for {$clientname}\n";
sendUserMessage($memberid, "Work Allocation", $lines);
}
if ($this->weekday != $_POST['weekday']) {
// logError("WEEK DAY CHANGED", false);
$sql = "DELETE FROM {$_SESSION['DB_PREFIX']}diary \n\t\t \t\t\t\t\tWHERE scheduleid = {$id}\n\t\t \t\t\t\t\tAND status = 'U'\n\t\t \t\t\t\t\tAND deleted != 'Y'";
$itemresult = mysql_query($sql);
if (!$itemresult) {
logError($sql . " - " . mysql_error());
}
} else {
if ($this->staffid != $_POST['memberid']) {
// logError("STAFF CHANGED", false);
$sql = "UPDATE {$_SESSION['DB_PREFIX']}diary \n\t\t\t\t\t\t\t\tSET memberid = {$memberid}\n\t\t \t\t\t\t\tWHERE scheduleid = {$id}\n\t\t \t\t\t\t\tAND status = 'U'\n\t\t \t\t\t\t\tAND deleted != 'Y'";
$itemresult = mysql_query($sql);
if (!$itemresult) {
logError($sql . " - " . mysql_error());
}
}
}
if ($this->enddate != $enddate) {
// logError("END DATE CHANGED: $enddate" . " - " . $this->enddate, false);
$sql = "DELETE FROM {$_SESSION['DB_PREFIX']}diary \n\t\t \t\t\t\t\tWHERE scheduleid = {$id}\n\t\t \t\t\t\t\tAND starttime > '{$enddate}'\n\t\t \t\t\t\t\tAND status = 'U'\n\t\t \t\t\t\t\tAND deleted != 'Y'";
$itemresult = mysql_query($sql);
if (!$itemresult) {
logError($sql . " - " . mysql_error());
}
}
if ($this->starttime != $_POST['starttime'] || $this->endtime != $_POST['endtime']) {
$starttime = $_POST['starttime'];
$endtime = $_POST['endtime'];
// logError("STAFF CHANGED", false);
$sql = "UPDATE {$_SESSION['DB_PREFIX']}diary \n\t\t\t\t\t\t\t\tSET starttime = '{$starttime}',\n\t\t\t\t\t\t\t\tendtime = '{$endtime}'\n\t\t \t\t\t\t\tWHERE scheduleid = {$id}\n\t\t \t\t\t\t\tAND status = 'U'\n\t\t \t\t\t\t\tAND deleted != 'Y'";
$itemresult = mysql_query($sql);
if (!$itemresult) {
logError($sql . " - " . mysql_error());
}
}
}
}
}
function __construct($orientation, $metric, $size)
{
$dynamicY = 0;
parent::__construct($orientation, $metric, $size);
$this->SetAutoPageBreak(true, 30);
$this->AddPage();
try {
$startdate = convertStringToDate($_POST['datefrom']);
$enddate = convertStringToDate($_POST['dateto']);
if ($_POST['eventid'] != "0") {
$eventid = $_POST['eventid'];
$sql = "SELECT A.name, A.retailprice,\n\t\t\t\t\t\t (SELECT SUM(B.amount) FROM {$_SESSION['DB_PREFIX']}eventtransaction B WHERE B.productid = A.id AND B.eventid = {$eventid} AND B.eventdate BETWEEN '{$startdate}' AND '{$enddate}') AS sold,\n\t\t\t\t\t\t (SELECT SUM(C.amount) FROM {$_SESSION['DB_PREFIX']}eventtransaction C WHERE C.productid = A.id AND C.eventid = {$eventid} AND C.eventdate BETWEEN '{$startdate}' AND '{$enddate}') AS broken,\n\t\t\t\t\t\t (SELECT SUM(D.amount) FROM {$_SESSION['DB_PREFIX']}eventtransaction D WHERE D.productid = A.id AND D.eventid = {$eventid} AND D.eventdate BETWEEN '{$startdate}' AND '{$enddate}') AS demo\n\t\t\t\t\t\t FROM {$_SESSION['DB_PREFIX']}product A \n\t\t\t\t\t\t\tGROUP BY A.name\n\t\t\t\t\t\t\tORDER BY A.name";
} else {
$sql = "SELECT A.name, A.retailprice,\n\t\t\t\t\t\t (SELECT SUM(B.amount) FROM {$_SESSION['DB_PREFIX']}eventtransaction B WHERE B.productid = A.id AND B.eventdate BETWEEN '{$startdate}' AND '{$enddate}' and B.type = 'S') AS sold,\n\t\t\t\t\t\t (SELECT SUM(C.amount) FROM {$_SESSION['DB_PREFIX']}eventtransaction C WHERE C.productid = A.id AND C.eventdate BETWEEN '{$startdate}' AND '{$enddate}' and C.type = 'B') AS broken,\n\t\t\t\t\t\t (SELECT SUM(D.amount) FROM {$_SESSION['DB_PREFIX']}eventtransaction D WHERE D.productid = A.id AND D.eventdate BETWEEN '{$startdate}' AND '{$enddate}' and D.type = 'G') AS demo\n\t\t\t\t\t\t FROM {$_SESSION['DB_PREFIX']}product A \n\t\t\t\t\t\t\tGROUP BY A.name\n\t\t\t\t\t\t\tORDER BY A.name";
}
$result = mysql_query($sql);
if ($result) {
$total = 0;
$totalsold = 0;
$totalbroken = 0;
$totaldemo = 0;
while ($member = mysql_fetch_assoc($result)) {
$sold = $member['sold'] != "" ? $member['sold'] : 0;
$broken = $member['broken'] != "" ? $member['broken'] : 0;
$demo = $member['demo'] != "" ? $member['demo'] : 0;
$line = array("Product" => $member['name'], "Sold" => " " . $sold, "Broken" => " " . $broken, "Demo" => " " . $demo, "Cost" => "£ " . number_format($member['retailprice'] * ($broken + $sold + $demo), 2));
$this->addLine($this->GetY(), $line);
$total += $member['retailprice'] * ($broken + $sold + $demo);
$totalsold += $sold;
$totalbroken += $broken;
$totaldemo += $demo;
}
$line = array("Product" => "Total : ", "Sold" => " " . $totalsold, "Broken" => " " . $totalbroken, "Demo" => " " . $totaldemo, "Cost" => "£ " . number_format($total, 2));
$this->addLine($this->GetY() + 4, $line);
} else {
logError($sql . " - " . mysql_error());
}
} catch (Exception $e) {
logError($e->getMessage());
}
}
$and = "";
if ($startdate != "") {
$and .= " AND A.matchdate >= '{$startdate}' ";
}
if ($enddate != "") {
$and .= " AND A.matchdate <= '{$enddate}' ";
}
if ($userid != "0") {
$and .= " AND A.refereeid = {$userid} ";
}
$sql = "SELECT COUNT(*) AS matches, SUM(refereescore) AS score, \n\t\t\t\t\t B.name AS refereeename\n\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}matchdetails A \n\t\t\t\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}referee B \n\t\t\t\t\t\tON B.id = A.refereeid \n\t\t\t\t\t\tWHERE refereescore >= 0 {$and}\n\t\t\t\t\t\tGROUP BY B.name \n\t\t\t\t\t\tORDER BY B.name";
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$line = array("Referee" => $member['refereeename'], "Games" => $member['matches'], "Average Score" => number_format($member['score'] / $member['matches'], 1));
if ($this->GetY() > 265) {
$this->AddPage();
}
$this->addLine($this->GetY(), $line);
}
} else {
logError($sql . " - " . mysql_error());
}
} catch (Exception $e) {
logError($e->getMessage());
}
}
}
start_db();
$pdf = new RefereeReport('P', 'mm', 'A4', convertStringToDate($_POST['datefrom']), convertStringToDate($_POST['dateto']), $_POST['refereeid']);
$pdf->Output();
<?php
//Include database connection details
require_once 'system-db.php';
require_once "sqlprocesstoarray.php";
start_db();
$caseid = $_POST['caseid'];
$quotenumber = strtoupper(mysql_escape_string($_POST['quotenumber']));
$paymentnumber = mysql_escape_string($_POST['paymentnumber']);
$description = mysql_escape_string($_POST['description']);
$shippinghandling = $_POST['shippinghandling'];
$paymentdate = convertStringToDate($_POST['paymentdate']);
$quotedate = convertStringToDate($_POST['quotedate']);
$total = $_POST['total'];
$paid = $_POST['paid'];
$toaddress = mysql_escape_string($_POST['toaddress']);
$deladdress = mysql_escape_string($_POST['deladdress']);
$ourref = mysql_escape_string($_POST['ourref']);
$yourref = mysql_escape_string($_POST['yourref']);
$termsid = $_POST['termsid'];
$contactid = $_POST['contactid'];
$officeid = $_POST['officeid'];
$depositamount = $_POST['depositamount'];
$na = $_POST['na'];
$qry = "INSERT INTO {$_SESSION['DB_PREFIX']}quotes " . "(caseid, quotenumber, paymentnumber, paid, shippinghandling, paymentdate, total, " . "toaddress, deladdress, termsid, contactid, createddate, officeid, ourref, yourref, depositrequired," . "description, na, metacreateddate, metacreateduserid, metamodifieddate, metamodifieduserid) " . "VALUES " . "({$caseid}, '{$quotenumber}', '{$paymentnumber}', '{$paid}', {$shippinghandling}, '{$paymentdate}', {$total}, " . "'{$toaddress}', '{$deladdress}', '{$termsid}', {$contactid}, '{$quotedate}', {$officeid}, '{$ourref}', '{$yourref}', {$depositamount}," . "'{$description}', '{$na}', NOW(), " . getLoggedOnMemberID() . ", NOW(), " . getLoggedOnMemberID() . ")";
$result = mysql_query($qry);
if (!$result) {
if (mysql_errno() == 1062) {
$qry = "UPDATE {$_SESSION['DB_PREFIX']}quotes SET " . "quotenumber = '{$quotenumber}', " . "paymentnumber = '{$paymentnumber}', " . "ourref = '{$ourref}', " . "yourref = '{$yourref}', " . "shippinghandling = '{$shippinghandling}', " . "paymentdate = '{$paymentdate}', " . "depositrequired = {$depositamount}, " . "createddate = '{$quotedate}', " . "paid = '{$paid}', " . "total = {$total}, " . "toaddress = '{$toaddress}', " . "description = '{$description}', " . "deladdress = '{$deladdress}', " . "na = '{$na}', " . "termsid = {$termsid}, " . "contactid = {$contactid}, " . "officeid = {$officeid}, metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE caseid = {$caseid}";
$result = mysql_query($qry);
if (!$result) {
<?php require_once "system-db.php"; require_once 'signature-to-image.php'; require_once 'matchcardreport.php'; start_db(); $matchdate = convertStringToDate($_POST['matchdate']); $leaguecup = $_POST['leaguecup']; $agegroupid = $_POST['agegroupid']; $opposition = $_POST['oppositionid_lazy']; $oppositionid = $_POST['oppositionid']; $hometeam = $_POST['hometeamid_lazy']; $hometeamid = $_POST['hometeamid']; $hometeamscore = $_POST['hometeamscore']; $awayteamscore = $_POST['awayteamscore']; $ratereferee = $_POST['ratereferee']; $rateplayers = $_POST['rateplayers']; $ratemanagement = $_POST['ratemanagement']; $ratespectators = $_POST['ratespectators']; $ratepitchsize = $_POST['ratepitchsize']; $ratepitchcondition = $_POST['ratepitchcondition']; $rategoalsize = $_POST['rategoalsize']; $ratechangingrooms = $_POST['ratechangingrooms']; $complycodes = isset($_POST['complycodes']) && $_POST['complycodes'] == "on" ? 1 : 0; $pitchsize = isset($_POST['pitchsize']) && $_POST['pitchsize'] == "on" ? 1 : 0; $requiredbarriers = isset($_POST['requiredbarriers']) && $_POST['requiredbarriers'] == "on" ? 1 : 0; $opponentids = isset($_POST['opponentids']) && $_POST['opponentids'] == "on" ? 1 : 0; $refappointedbyleague = $_POST['refappointedbyleague']; $refereeid = $_POST['refereeid']; $referee = mysql_escape_string($_POST['refereeid_lazy']); $division = mysql_escape_string($_POST['division']);
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$line = array("Date of Match" => $member['matchdate'], "Age Group" => "Under " . $member['age'], "Division" => $pdivision, "Reported By" => $member['teamname'], "Match ID" => $member['id'], "Comments" => $member['remarks']);
if ($this->GetY() > 175) {
$this->AddPage();
}
$this->addLine($this->GetY(), $line);
}
} else {
logError($sql . " - " . mysql_error());
}
} catch (Exception $e) {
logError($e->getMessage());
}
}
}
start_db();
$pdf = new RefereeReport('L', 'mm', 'A4', convertStringToDate($_POST['fromdate']), convertStringToDate($_POST['todate']));
$pdf->Output();
include 'PHPExcel.php';
include 'PHPExcel/Writer/Excel2007.php';
start_db();
header('Content-type: application/excel');
header('Content-disposition: attachment; filename="conversionstatisticsreport.xlsx');
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Set properties
$objPHPExcel->getProperties()->setCreator("Kevin Hilton");
$objPHPExcel->getProperties()->setLastModifiedBy("Kevin Hilton");
$objPHPExcel->getProperties()->setTitle("Conversion Statistics Report");
$objPHPExcel->getProperties()->setSubject("Conversion Statistics Report");
$objPHPExcel->getProperties()->setDescription("Conversion Statistics Report");
$objPHPExcel->setActiveSheetIndex(0);
$startdate = convertStringToDate($_POST['datefrom']);
$enddate = convertStringToDate($_POST['dateto']);
$userid = $_POST['userid'];
$sql = "SELECT A.*, \n\t\t B.name AS customername, B.accountnumber, \n\t\t\tDATE_FORMAT(A.metacreateddate, '%d/%m/%Y %H:%I') AS metacreateddate, \n\t\t\tDATE_FORMAT(A.converteddatetime, '%d/%m/%Y %H:%I') AS converteddatetime,\n\t\t\tTIMEDIFF(A.converteddatetime, A.metacreateddate) as diff\n\t\t\tFROM {$_SESSION['DB_PREFIX']}quotation A \n\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}customer B \n\t\t\tON B.id = A.customerid \n\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}members C \n\t\t\tON C.member_id = A.takenbyid \n\t\t\tWHERE A.takenbyid = {$userid} \n\t\t\tAND A.metacreateddate >= '{$startdate}' \n\t\t\tAND A.metacreateddate <= '{$enddate}' \n\t\t\tORDER BY A.metacreateddate DESC";
$result = mysql_query($sql);
if (!$result) {
die($sql . " - " . mysql_error());
}
$row = 1;
$objPHPExcel->getDefaultStyle()->getFont()->setName('Arial')->setSize(8);
$headerArray = array('font' => array('bold' => true), 'borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$styleArray = array('borders' => array('allborders' => array('style' => PHPExcel_Style_Border::BORDER_THIN)));
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(72);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(35);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(39);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(37);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(37);
<?php
require_once "system-db.php";
start_db();
$id = $_POST['id'];
$clientid = $_POST['clientid'];
$memberid = $_POST['memberid'];
$startdate = convertStringToDate($_POST['startdate']) . " " . $_POST['starttime'];
$enddate = convertStringToDate($_POST['enddate']) . " " . $_POST['endtime'];
$status = $_POST['status'];
if ($status == "U") {
$sql = "SELECT DATE_FORMAT(A.starttime, '%d/%m/%Y %H:%i') AS starttime, A.memberid,\n\t\t\t\tB.name AS clientname, C.name AS originalclientname\n\t\t\t\tFROM {$_SESSION['DB_PREFIX']}diary A\n\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}client B\n\t\t\t\tON B.id = A.clientid\n\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}client C\n\t\t\t\tON C.id = {$clientid}\n\t\t\t\tWHERE id = {$id}";
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$memberid = $member['id'];
$originaldate = $member['starttime'];
$originalclient = $member['clientname'];
$date = $_POST['startdate'];
$clientname = $_POST['originalclientname'];
sendUserMessage($memberid, "Cancellation", "The shift originally allocated on {$originaldate} for {$originalclient} has been moved to {$date} for {$clientname}");
}
}
$sql = "UPDATE {$_SESSION['DB_PREFIX']}diary SET \n\t\t\t\tstarttime = '{$startdate}', \n\t\t\t\tendtime = '{$enddate}', \n\t\t\t\tmemberid = {$memberid},\n\t\t\t\tstatus = '{$status}',\n\t\t\t\tclientid = {$clientid}\n\t\t\t\tWHERE id = {$id}";
} else {
if ($status == "I") {
$sql = "UPDATE {$_SESSION['DB_PREFIX']}diary SET \n\t\t\t\tactualstarttime = '{$startdate}', \n\t\t\t\tstatus = '{$status}',\n\t\t\t\tendtime = '{$enddate}', \n\t\t\t\tmemberid = {$memberid},\n\t\t\t\tclientid = {$clientid}\n\t\t\t\tWHERE id = {$id}";
} else {
$sql = "UPDATE {$_SESSION['DB_PREFIX']}diary SET \n\t\t\t\tactualstarttime = '{$startdate}', \n\t\t\t\tactualendtime = '{$enddate}', \n\t\t\t\tstatus = '{$status}',\n\t\t\t\tmemberid = {$memberid},\n\t\t\t\tclientid = {$clientid}\n\t\t\t\tWHERE id = {$id}";
}
}
function __construct($orientation, $metric, $size, $startdate)
{
$this->fromdate = convertStringToDate($startdate);
$this->todate = date("Y-m-d", strtotime("+1 week", strtotime($this->fromdate)));
$eventid = $_POST['eventid'];
$dynamicY = 0;
parent::__construct($orientation, $metric, $size);
$this->SetAutoPageBreak(true, 30);
$this->AddPage();
try {
$total = array();
$total[0] = 0;
$total[1] = 0;
$total[2] = 0;
$total[3] = 0;
$total[4] = 0;
$total[5] = 0;
$total[6] = 0;
$sql = "SELECT A.id, A.name \n\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}product A \n\t\t\t\t\t\tORDER BY A.name";
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$productid = $member['id'];
$productname = $member['name'];
$date = $this->fromdate;
$amounts = array();
while (strtotime($date) <= strtotime($this->todate)) {
if ($eventid == 0) {
$sql = "SELECT IFNULL(SUM(B.amount), 0) AS amount\n\t\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\t\tAND B.eventdate = '{$date}'";
} else {
$sql = "SELECT IFNULL(SUM(B.amount), 0) AS amount\n\t\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\t\tAND B.eventid = {$eventid}\n\t\t\t\t\t\t\t\t\t\tAND B.eventdate = '{$date}'";
}
$itemresult = mysql_query($sql);
if ($itemresult) {
while ($itemmember = mysql_fetch_assoc($itemresult)) {
array_push($amounts, $itemmember['amount']);
}
} else {
logError($sql . " - " . mysql_error());
}
$date = date("Y-m-d", strtotime("+1 day", strtotime($date)));
}
$total[0] += $amounts[0];
$total[1] += $amounts[1];
$total[2] += $amounts[2];
$total[3] += $amounts[3];
$total[4] += $amounts[4];
$total[5] += $amounts[5];
$total[6] += $amounts[6];
$line = array(GetEventName($_POST['eventid']) => $productname, $this->dates[0] => $amounts[0], $this->dates[1] => $amounts[1], $this->dates[2] => $amounts[2], $this->dates[3] => $amounts[3], $this->dates[4] => $amounts[4], $this->dates[5] => $amounts[5], $this->dates[6] => $amounts[6]);
$this->addLine($this->GetY(), $line, 5);
}
} else {
logError($sql . " - " . mysql_error());
}
$line = array(GetEventName($_POST['eventid']) => "Total", $this->dates[0] => " " . $total[0], $this->dates[1] => " " . $total[1], $this->dates[2] => " " . $total[2], $this->dates[3] => " " . $total[3], $this->dates[4] => " " . $total[4], $this->dates[5] => " " . $total[5], $this->dates[6] => " " . $total[6]);
$this->addLine($this->GetY() + 2, $line, 5);
} catch (Exception $e) {
logError($e->getMessage());
}
}
$dynamicY = 0;
parent::__construct($orientation, $metric, $size);
$this->SetAutoPageBreak(true, 30);
$this->AddPage();
try {
$sql = "SELECT A.*, \n\t\t\t\t\t B.name AS customername, B.accountnumber, \n\t\t\t\t\t\tDATE_FORMAT(A.metacreateddate, '%d/%m/%Y %H:%I') AS metacreateddate, \n\t\t\t\t\t\tDATE_FORMAT(A.converteddatetime, '%d/%m/%Y %H:%I') AS converteddatetime,\n\t\t\t\t\t\tTIMEDIFF(A.converteddatetime, A.metacreateddate) as diff\n\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}quotation A \n\t\t\t\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}customer B \n\t\t\t\t\t\tON B.id = A.customerid \n\t\t\t\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}members C \n\t\t\t\t\t\tON C.member_id = A.takenbyid \n\t\t\t\t\t\tWHERE A.takenbyid = {$userid} \n\t\t\t\t\t\tAND A.metacreateddate >= '{$startdate}' \n\t\t\t\t\t\tAND A.metacreateddate <= '{$enddate}' \n\t\t\t\t\t\tORDER BY A.metacreateddate DESC";
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$diff = $member['diff'];
$conversiondate = $member['converteddatetime'];
if (substr($diff, 0, 1) == "-") {
$diff = " ";
}
if (substr($conversiondate, 0, 2) == "00") {
$conversiondate = " ";
}
$line = array("Customer" => $member['customername'], "Customer Code" => $member['accountnumber'], "Quotation Number" => getSiteConfigData()->bookingprefix . "-" . sprintf("%06d", $member['id']), "Quotation Date" => $member['metacreateddate'], "Conversion Date" => $conversiondate, "Time Taken" => $diff, "Total" => number_format($member['total'], 2));
$this->addLine($this->GetY(), $line);
}
} else {
logError($sql . " - " . mysql_error());
}
} catch (Exception $e) {
logError($e->getMessage());
}
}
}
start_db();
$pdf = new LeadsCallbackReport('L', 'mm', 'A4', convertStringToDate($_POST['datefrom']), convertStringToDate($_POST['dateto']), $_POST['userid']);
$pdf->Output();
<?php
//Include database connection details
require_once 'system-db.php';
require_once "sqlprocesstoarray.php";
start_db();
$userid = $_POST['userid'];
$rotaid = $_POST['rotaid'];
$startdate = convertStringToDate($_POST['startdate']);
$enddate = convertStringToDate($_POST['enddate']);
$notes = mysql_escape_string($_POST['notes']);
$watch = mysql_escape_string($_POST['watch']);
if ($_POST['eventid'] == "") {
$qry = "INSERT INTO {$_SESSION['DB_PREFIX']}scheduleitem \n\t\t\t\t(\n\t\t\t\t\trotaid, userid, startdate, enddate, notes, watch\n\t\t\t\t)\n\t\t\t\tVALUES\n\t\t\t\t(\n\t\t\t\t\t{$rotaid}, {$userid}, '{$startdate}', '{$enddate}', '{$notes}', '{$watch}'\n\t\t\t\t)";
$result = mysql_query($qry);
if (!$result) {
logError($qry . " - " . mysql_error());
}
$id = mysql_insert_id();
} else {
$id = $_POST['eventid'];
$qry = "UPDATE {$_SESSION['DB_PREFIX']}scheduleitem SET \n\t\t\t\tstartdate = '{$startdate}',\n\t\t\t\tenddate = '{$enddate}',\n\t\t\t\tuserid = {$userid},\n\t\t\t\tnotes = '{$notes}',\n\t\t\t\twatch = '{$watch}'\n\t\t\t\tWHERE id = {$id}";
$result = mysql_query($qry);
if (!$result) {
logError($qry . " - " . mysql_error());
}
}
$sql = "SELECT A.*, B.fullname\n\t\t\tFROM {$_SESSION['DB_PREFIX']}scheduleitem A\n\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}members B\n\t\t\tON B.member_id = A.userid\n\t\t\tWHERE A.id = {$id}";
$json = new SQLProcessToArray();
echo json_encode($json->fetch($sql));
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$line = array("Age Group" => "Under " . $member['age'], "Division" => $pdivision, "Home Team" => $member['hometeam'], "Score" => $member['hometeamscore'], "Away Team" => $member['opposition'], " Score " => $member['awayteamscore']);
if ($this->GetY() > 265) {
$this->AddPage();
}
$this->addLine($this->GetY(), $line);
}
} else {
logError($sql . " - " . mysql_error());
}
} catch (Exception $e) {
logError($e->getMessage());
}
}
}
start_db();
$pdf = new MatchResultReport('P', 'mm', 'A4', convertStringToDate($_POST['datefrom']), convertStringToDate($_POST['dateto']));
$pdf->Output();
<?php
require_once 'libs/dbconnect.php';
require_once 'libs/common_functions.php';
$userId = mysqli_real_escape_string($conn, $_POST['userId']);
$username = mysqli_real_escape_string($conn, $_POST['username']);
$password = mysqli_real_escape_string($conn, $_POST['password']);
$firstname = mysqli_real_escape_string($conn, $_POST['firstname']);
$lastname = mysqli_real_escape_string($conn, $_POST['lastname']);
$middlename = mysqli_real_escape_string($conn, $_POST['middlename']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$contactNo = mysqli_real_escape_string($conn, $_POST['contactNo']);
$birthday = mysqli_real_escape_string($conn, $_POST['birthday']);
$gender = mysqli_real_escape_string($conn, $_POST['gender']);
$role_type = mysqli_real_escape_string($conn, $_POST['roleType']);
$dateBirth = convertStringToDate($birthday);
$userId = empty($userId) ? -1 : $userId;
$sqlCallProcedure = "CALL pAddOrUpdateUser({$userId}, '{$username}', '{$password}', '{$firstname}', '{$lastname}', '{$middlename}', '{$contactNo}', '{$address}', {$dateBirth}, '{$gender}', '{$role_type}')";
mysqli_query($conn, $sqlCallProcedure);
$errNo = mysqli_errno($conn);
$errMSg = mysqli_error($conn);
if (0 < $errNo) {
if ($errNo == 1062) {
header('HTTP/1.0 500 Unable to add existing user.');
} else {
header('HTTP/1.0 500 DB Error (' . $errNo . ': ' . $errMSg . ').');
}
exit(0);
} else {
if (0 < $userId) {
echo "Successfully updated user!";
<?php
require_once 'libs/dbconnect.php';
require_once 'libs/common_functions.php';
$start_date = mysqli_real_escape_string($conn, $_GET['start_date']);
$dateStart = convertStringToDate($start_date);
$end_date = mysqli_real_escape_string($conn, $_GET['end_date']);
$dateEnd = convertStringToDate($end_date);
$sqlTotal = " SELECT SUM(total_sales) AS total_sales FROM vw_workout_sales_total ";
if ('null' != $dateStart && 'null' != $dateEnd) {
$sqlTotal .= " WHERE workout_date between {$dateStart} and {$dateEnd}";
} else {
$sqlTotal .= " WHERE workout_date BETWEEN date(SUBDATE(NOW(), WEEKDAY(NOW()))) and DATE(NOW() + INTERVAL (6 - WEEKDAY(NOW())) DAY) ";
}
//echo $sqlTotal;
if ($rsTotal = mysqli_query($conn, $sqlTotal) or die("Query fail: " . $sqlTotal)) {
$data = mysqli_fetch_all($rsTotal, MYSQLI_ASSOC);
header('Content-Type: application/json');
echo json_encode($data);
}
exit(0);
public function insert()
{
try {
$qry = "INSERT INTO " . $this->table . " (";
$first = true;
foreach ($this->columns as $col) {
if ($col['bind']) {
if ($first) {
$first = false;
} else {
$qry = $qry . ", ";
}
$qry = $qry . $col['name'];
}
}
$qry = $qry . ", metacreateddate, metacreateduserid, metamodifieddate, metamodifieduserid) VALUES (";
$first = true;
foreach ($this->columns as $col) {
if ($col['bind']) {
if ($first) {
$first = false;
} else {
$qry = $qry . ", ";
}
if ($col['type'] == "IMAGE") {
$qry = $qry . "'" . getImageData($col['name']) . "'";
} else {
if ($col['type'] == "FILE") {
$qry = $qry . "'" . getFileData($col['name']) . "'";
} else {
if ($col['type'] == "PASSWORD") {
$qry = $qry . "'" . md5($_POST[$col['name']]) . "'";
} else {
if ($col['type'] == "CHECKBOX") {
$qry = $qry . (isset($_POST[$col['name']]) ? $_POST[$col['name']] == "on" ? 1 : 0 : 0);
} else {
if (isset($_POST[$col['name']])) {
if ($col['datatype'] == "timestamp" || $col['datatype'] == "") {
$mysql_date = convertStringToDate($_POST[$col['name']]);
$mysql_time = $_POST[$col['name'] . "_time"];
$qry = $qry . "'" . mysql_escape_string($mysql_date) . " {$mysql_time}'";
} else {
if ($col['datatype'] == "date") {
$mysql_date = convertStringToDate($_POST[$col['name']]);
$qry = $qry . "'" . mysql_escape_string($mysql_date) . "'";
} else {
$qry = $qry . "'" . mysql_escape_string($_POST[$col['name']]) . "'";
}
}
} else {
if ($col['default'] == "TODAY") {
$qry = $qry . "NOW()";
} else {
if ($col['default'] == "USER") {
$qry = $qry . getLoggedOnMemberID();
} else {
$qry = $qry . "'" . mysql_escape_string($col['default']) . "'";
}
}
}
}
}
}
}
}
}
$memberid = getLoggedOnMemberID();
$qry = $qry . ", NOW(), {$memberid}, NOW(), {$memberid})";
$result = mysql_query($qry);
if (!$result) {
logError($qry . " = " . mysql_error());
}
$this->postInsertEvent();
} catch (Exception $e) {
$this->errorDescriptions[] = $e->getMessage();
}
}
function __construct($orientation, $metric, $size, $startdate, $enddate)
{
$this->fromdate = convertStringToDate($startdate);
$this->todate = convertStringToDate($enddate);
$eventid = $_POST['eventid'];
$dynamicY = 0;
parent::__construct($orientation, $metric, $size);
$this->SetAutoPageBreak(true, 30);
$this->AddPage();
try {
$total = array();
$total[0] = 0;
$total[1] = 0;
$total[2] = 0;
$total[3] = 0;
$total[4] = 0;
if ($eventid == 0) {
$sql = "SELECT A.id, A.name, A.retailprice, B.stock \n\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}product A \n\t\t\t\t\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}eventproductmatrix B\n\t\t\t\t\t\t\tON B.productid = A.id\n\t\t\t\t\t\t\tORDER BY A.name";
} else {
$sql = "SELECT A.id, A.name, A.retailprice, B.stock \n\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}product A \n\t\t\t\t\t\t\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}eventproductmatrix B\n\t\t\t\t\t\t\tON B.productid = A.id\n\t\t\t\t\t\t\tAND B.eventid = {$eventid}\n\t\t\t\t\t\t\tORDER BY A.name";
}
$result = mysql_query($sql);
if ($result) {
while ($member = mysql_fetch_assoc($result)) {
$productid = $member['id'];
$productname = $member['name'];
$stock = $member['stock'];
$retailprice = $member['retailprice'];
$sold = 0;
$broken = 0;
$demo = 0;
if ($eventid == 0) {
$sql = "SELECT \n\t\t\t\t\t\t\t\t\tIFNULL(SUM(B.amount), 0) AS amount \n\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\tAND B.type = 'S'\n\t\t\t\t\t\t\t\t\tAND B.eventdate BETWEEN '{$this->fromdate}' AND '{$this->todate}'";
} else {
$sql = "SELECT \n\t\t\t\t\t\t\t\t\tIFNULL(SUM(B.amount), 0) AS amount \n\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\tAND B.eventid = {$eventid}\n\t\t\t\t\t\t\t\t\tAND B.type = 'S'\n\t\t\t\t\t\t\t\t\tAND B.eventdate BETWEEN '{$this->fromdate}' AND '{$this->todate}'";
}
$itemresult = mysql_query($sql);
if ($itemresult) {
while ($itemmember = mysql_fetch_assoc($itemresult)) {
$sold = $itemmember['amount'];
}
} else {
logError($sql . " - " . mysql_error());
}
if ($eventid == 0) {
$sql = "SELECT \n\t\t\t\t\t\t\t\t\tIFNULL(SUM(B.amount), 0) AS amount \n\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\tAND B.type = 'B'\n\t\t\t\t\t\t\t\t\tAND B.eventdate BETWEEN '{$this->fromdate}' AND '{$this->todate}'";
} else {
$sql = "SELECT \n\t\t\t\t\t\t\t\t\tIFNULL(SUM(B.amount), 0) AS amount \n\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\tAND B.eventid = {$eventid}\n\t\t\t\t\t\t\t\t\tAND B.type = 'B'\n\t\t\t\t\t\t\t\t\tAND B.eventdate BETWEEN '{$this->fromdate}' AND '{$this->todate}'";
}
$itemresult = mysql_query($sql);
if ($itemresult) {
while ($itemmember = mysql_fetch_assoc($itemresult)) {
$broken = $itemmember['amount'];
}
} else {
logError($sql . " - " . mysql_error());
}
if ($eventid == 0) {
$sql = "SELECT \n\t\t\t\t\t\t\t\t\tIFNULL(SUM(B.amount), 0) AS amount \n\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\tAND B.type = 'G'\n\t\t\t\t\t\t\t\t\tAND B.eventdate BETWEEN '{$this->fromdate}' AND '{$this->todate}'";
} else {
$sql = "SELECT \n\t\t\t\t\t\t\t\t\tIFNULL(SUM(B.amount), 0) AS amount \n\t\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}eventtransaction B \n\t\t\t\t\t\t\t\t\tWHERE B.productid = {$productid} \n\t\t\t\t\t\t\t\t\tAND B.eventid = {$eventid}\n\t\t\t\t\t\t\t\t\tAND B.type = 'G'\n\t\t\t\t\t\t\t\t\tAND B.eventdate BETWEEN '{$this->fromdate}' AND '{$this->todate}'";
}
$itemresult = mysql_query($sql);
if ($itemresult) {
while ($itemmember = mysql_fetch_assoc($itemresult)) {
$demo = $itemmember['amount'];
}
} else {
logError($sql . " - " . mysql_error());
}
$total[0] += $sold;
$total[1] += $broken;
$total[2] += $demo;
$total[3] += $stock;
$total[4] += $sold * $retailprice;
$line = array(GetEventName($_POST['eventid']) => $productname, "SOLD" => $sold, "BROKEN" => $broken, "DEMO" => $demo, "BALANCE" => number_format($stock, 0), "SALES" => number_format($sold * $retailprice, 2));
$this->addLine($this->GetY(), $line, 5);
}
} else {
logError($sql . " - " . mysql_error());
}
$line = array(GetEventName($_POST['eventid']) => "Total", "SOLD" => " " . $total[0], "BROKEN" => " " . $total[1], "DEMO" => " " . $total[2], "BALANCE" => " " . $total[3], "SALES" => " " . number_format($total[4], 2));
$this->addLine($this->GetY() + 2, $line, 5);
} catch (Exception $e) {
logError($e->getMessage());
}
}
$middlename = mysqli_real_escape_string($conn, $_POST['middlename']);
$address = mysqli_real_escape_string($conn, $_POST['address']);
$contactNo = mysqli_real_escape_string($conn, $_POST['contactNo']);
$emergencyContactPerson = mysqli_real_escape_string($conn, $_POST['emergencyContactPerson']);
$emergencyContactNumber = mysqli_real_escape_string($conn, $_POST['emergencyContactNumber']);
$emergencyContactRelationship = mysqli_real_escape_string($conn, $_POST['emergencyContactRelationship']);
$birthdate = mysqli_real_escape_string($conn, $_POST['birthdate']);
$memberStart = mysqli_real_escape_string($conn, $_POST['memberStart']);
$memberEnd = mysqli_real_escape_string($conn, $_POST['memberEnd']);
$gender = mysqli_real_escape_string($conn, $_POST['gender']);
$membership_type = mysqli_real_escape_string($conn, $_POST['type']);
$has_discount = mysqli_real_escape_string($conn, $_POST['discounted']);
$service_type = mysqli_real_escape_string($conn, $_POST['serviceType']);
$dateBirth = convertStringToDate($birthdate);
$dateMStart = convertStringToDate($memberStart);
$dateMEnd = convertStringToDate($memberEnd);
$memberId = empty($memberId) ? -1 : $memberId;
$loginUserId = mysqli_real_escape_string($conn, $_SESSION['user_id']);
$sqlCallProcedure = "CALL pAddOrUpdateMemberInfo({$memberId}, '{$firstname}', '{$lastname}', '{$middlename}', '{$contactNo}', '{$address}', {$dateBirth}, '{$gender}', '{$emergencyContactPerson}', '{$emergencyContactNumber}', '{$emergencyContactRelationship}', '{$membership_type}', '{$has_discount}', '{$service_type}', {$dateMStart}, {$dateMEnd}, '{$loginUserId}')";
//echo $sqlCallProcedure;
mysqli_query($conn, $sqlCallProcedure);
$errNo = mysqli_errno($conn);
$errMSg = mysqli_error($conn);
if (0 < $errNo) {
if ($errNo == 1062) {
header('HTTP/1.0 500 Unable to add existing member.');
} else {
header('HTTP/1.0 500 DB Error (' . $errNo . ': ' . $errMSg . ')');
}
exit(0);
} else {
<?php
require_once 'libs/dbconnect.php';
require_once 'libs/common_functions.php';
$log_date = mysqli_real_escape_string($conn, $_GET['log_date']);
$dateLog = convertStringToDate($log_date);
$sqlQuery = " SELECT A.* FROM vw_workout_sales A ";
if ('null' != $dateLog) {
$sqlQuery .= " WHERE A.workout_date = {$dateLog}";
} else {
$sqlQuery .= " WHERE A.workout_date = date(now())";
}
$recordCount = mysqli_num_rows(mysqli_query($conn, $sqlQuery));
//echo $sqlQuery;
if (0 < $recordCount) {
$result = mysqli_query($conn, $sqlQuery) or die("Query fail: " . $sqlQuery);
include 'pages/attendanceList.html';
}
exit(0);
<?php
//Include database connection details
require_once 'system-db.php';
start_db();
$id = $_POST['id'];
$eventid = $_POST['eventid'];
$date = convertStringToDate($_POST['date']);
$amount = $_POST['amount'];
if ($id == 0) {
$qry = "INSERT INTO {$_SESSION['DB_PREFIX']}eventforecast \n\t\t\t\t(\n\t\t\t\t\teventid, forecastdate, amount\n\t\t\t\t)\n\t\t\t\tVALUES\n\t\t\t\t(\n\t\t\t\t\t{$eventid}, '{$date}', {$amount}\n\t\t\t\t)";
} else {
$qry = "UPDATE {$_SESSION['DB_PREFIX']}eventforecast SET\n\t\t\t\tforecastdate = '{$date}',#\n\t\t\t\tamount = {$amount}\n\t\t\t\tWHERE id = {$id}";
}
$result = mysql_query($qry);
mysql_query("COMMIT");