function __construct() { //Include database connection details require_once 'system-db.php'; start_db(); initialise_db(); }
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()); } }
function __construct() { require_once 'system-db.php'; start_db(); initialise_db(); if (isset($_GET['from'])) { $this->fromrow = $_GET['from']; } if (isset($_GET['to'])) { $this->torow = $_GET['to']; } if (isset($_GET['direction'])) { $this->sortdirection = $_GET['direction']; } if (isset($_GET['sort'])) { $this->sortby = $_GET['sort']; } $this->pagesize = $this->torow - $this->fromrow; }
<?php //Include database connection details require_once 'system-db.php'; start_db(); logout(); header("location: system-login.php");
function __construct($orientation, $metric, $size) { parent::__construct($orientation, $metric, $size); require_once 'system-db.php'; start_db(); initialise_db(); $this->B = 0; $this->I = 0; $this->U = 0; $this->HREF = ''; $this->fontlist = array('arial', 'times', 'courier', 'helvetica', 'symbol'); $this->issetfont = false; $this->issetcolor = false; }
function __construct($orientation, $metric, $size, $id) { $dynamicY = 0; start_db(); parent::__construct($orientation, $metric, $size); try { $sql = "SELECT \n\t\t\t\t\t\t A.*, \n\t\t\t\t\t\t DATE_FORMAT(A.matchdate, '%d/%m/%Y') AS matchdate,\n\t\t\t\t\t\t B.name AS refereename, C.name AS submittedteamname, D.name AS oppositionname, \n\t\t\t\t\t\t E.name AS agegroupname, E.age\n\t\t\t\t\t\t FROM {$_SESSION['DB_PREFIX']}matchdetails A\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}referee B\n\t\t\t\t\t\t ON B.id = A.refereeid\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}team C\n\t\t\t\t\t\t ON C.id = A.teamid\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}team D\n\t\t\t\t\t\t ON D.id = A.oppositionid\n\t\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}teamagegroup E\n\t\t\t\t\t\t ON E.id = A.agegroupid\n\t\t\t\t\t\t WHERE A.id = {$id}"; $result = mysql_query($sql); if ($result) { while ($this->headermember = mysql_fetch_assoc($result)) { $dynamicY = $this->newPage() + 2; $sql = "SELECT A.*, B.firstname, B.lastname, B.registrationnumber\n\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}matchplayerdetails A \n\t\t\t\t\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}player B \n\t\t\t\t\t\t\t\tON B.id = A.playerid\n\t\t\t\t\t\t\t\tWHERE A.matchid = {$id} \n\t\t\t\t\t\t\t\tORDER BY B.firstname, B.lastname"; $itemresult = mysql_query($sql); $index = 1; if ($itemresult) { while ($itemmember = mysql_fetch_assoc($itemresult)) { $this->addText(15, $dynamicY, $index++, 10, 4, ''); $this->addText(25, $dynamicY, $itemmember['firstname'] . " " . $itemmember['lastname'], 10, 4, ''); $dynamicY = $this->addText(110, $dynamicY, $itemmember['registrationnumber'], 10, 4, ''); } } else { logError($qry . " - " . mysql_error()); } $dynamicY = 153 + $this->margin; $dynamicY = $this->addText(15, $dynamicY, "CLUB / MANAGERS REPORT (Including the FA Respect Codes of Conduct)", 10, 4, 'B') + 2; if ($this->headermember['age'] < 12) { $this->addText(15, $dynamicY, "Referee", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratereferee']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Opponent players", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['rateplayers']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Opponent Management", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratemanagement']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Opponent Spectators", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratespectators']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Pitch Size", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratepitchsize']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Pitch Condition", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratepitchcondition']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Goal Size", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['rategoalsize']), 10, 4, '') + 1; $this->addText(15, $dynamicY, "Changing Rooms", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->getRateDescription($this->headermember['ratechangingrooms']), 10, 4, '') + 1; } else { $this->addText(15, $dynamicY, "Did the pitch have the required barriers, cones and markings", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->headermember['requiredbarriers'] == 1 ? "Yes" : "No", 10, 4, '') + 1; $this->addText(15, $dynamicY, "Was the pitch size/condition, goals and changing rooms adequate", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->headermember['pitchsize'] == 1 ? "Yes" : "No", 10, 4, '') + 1; } $this->addText(15, $dynamicY, "Did your opponent players, management and spectators comply with the Codes", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->headermember['complycodes'] == 1 ? "Yes" : "No", 10, 4, '') + 1; $this->addText(15, $dynamicY, "Did you check your opponent players ID cards", 10, 4, ''); $dynamicY = $this->addText(150, $dynamicY, $this->headermember['opponentids'] == 1 ? "Yes" : "No", 10, 4, '') + 1; $this->Line(15, $dynamicY, 195, $dynamicY); $dynamicY = $this->addText(15, $dynamicY + 2, "REFEREE SECTION", 10, 4, 'B') + 3; $this->addText(15, $dynamicY, "Referee", 10, 4, 'B'); $this->addText(45, $dynamicY, $this->headermember['referee'], 10, 4, ''); if ($this->headermember['refereescore'] > 0) { $this->addText(105, $dynamicY, "Appointed by League", 10, 4, 'B'); $dynamicY = $this->addText(145, $dynamicY, $this->headermember['refappointedbyleague'] == "Y" ? "Yes" : "No", 10, 4, '') + 3; $this->addText(15, $dynamicY, "Marks out of 100", 10, 4, 'B'); $dynamicY = $this->addText(45, $dynamicY, $this->headermember['refereescore'], 10, 4, '') + 3; $this->addText(15, $dynamicY, "Remarks", 10, 4, 'B'); $dynamicY = $this->addText(45, $dynamicY, $this->headermember['refereeremarks'], 10, 4, '', 150) + 2; } else { $dynamicY = $this->addText(145, $dynamicY, " ", 10, 4, ''); } $this->Line(15, $dynamicY, 195, $dynamicY); $dynamicY = $this->addText(15, $dynamicY + 3, "SIGNED", 10, 4, 'B') + 2; $this->DynamicImage($this->headermember['imageid'], 15, $dynamicY); } } else { logError($sql . " - " . mysql_error()); } } catch (Exception $e) { logError($e->getMessage()); } $this->AliasNbPages(); }
function __construct($orientation, $metric, $size, $id) { $dynamicY = 0; start_db(); parent::__construct($orientation, $metric, $size); try { $sql = "SELECT A.*, DATE_FORMAT(A.invoicedate, '%d/%m/%Y') AS invoicedate,\n\t\t\t\t\t\tD.name AS customername, D.accountnumber, D.invoiceaddress1, D.invoiceaddress2, D.invoiceaddress3, \n\t\t\t\t\t\tD.invoicecity, D.invoicepostcode, B.deliveryaddress1, B.deliveryaddress2, \n\t\t\t\t\t\tB.deliveryaddress3, B.deliverycity, B.deliverypostcode, D.firstname, B.lastname,\n\t\t\t\t\t\tE.fullname AS takenbyname\n\t\t\t\t\t FROM {$_SESSION['DB_PREFIX']}invoice A\n\t\t\t\t\t INNER JOIN {$_SESSION['DB_PREFIX']}customerclientsite B\n\t\t\t\t\t ON B.id = A.siteid\n\t\t\t\t\t INNER JOIN {$_SESSION['DB_PREFIX']}customerclient C\n\t\t\t\t\t ON C.id = B.clientid\n\t\t\t\t\t INNER JOIN {$_SESSION['DB_PREFIX']}customer D\n\t\t\t\t\t ON D.id = C.customerid\n\t\t\t\t\t LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}members E\n\t\t\t\t\t ON E.member_id = A.takenbyid\n\t\t\t\t\t WHERE A.id = {$id}\n\t\t\t\t\t ORDER BY A.id DESC"; $result = mysql_query($sql); if ($result) { while ($this->headermember = mysql_fetch_assoc($result)) { $shipping = $this->headermember['deliverycharge']; $discount = $this->headermember['discount']; $total = 0; $dynamicY = $this->newPage() + 7; $sql = "SELECT A.*, B.productcode, B.description\n\t\t\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}invoiceitem A \n\t\t\t\t\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}product B \n\t\t\t\t\t\t\t\tON B.id = A.productid \n\t\t\t\t\t\t\t\tWHERE A.invoiceid = {$id} \n\t\t\t\t\t\t\t\tORDER BY A.sequence"; $itemresult = mysql_query($sql); if ($itemresult) { while ($itemmember = mysql_fetch_assoc($itemresult)) { $line = array("Quantity" => $itemmember['quantity'], "Code" => $itemmember['productcode'], "Description" => $itemmember['description'], "Price Each" => number_format($itemmember['priceeach'], 2), "Line Total" => number_format($itemmember['priceeach'] * $itemmember['quantity'], 2)); $size = $this->addLine($dynamicY, $line); $dynamicY += $size + 1; if ($dynamicY > 225) { $dynamicY = $this->newPage(); $dynamicY = 102; } $total = $total + $itemmember['priceeach'] * $itemmember['quantity']; $totalvat += $itemmember['vat']; } } else { logError($qry . " - " . mysql_error()); } $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Goods Net:", "Line Total" => number_format($total, 2)); $size = $this->addLine(236, $line); $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Delivery:", "Line Total" => number_format($shipping, 2)); $size = $this->addLine(242, $line); $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Invoice Net:", "Line Total" => number_format($shipping + $total, 2)); $size = $this->addLine(248, $line); $totalvat += $shipping * (getSiteConfigData()->vatrate / 100); $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "VAT:", "Line Total" => number_format($totalvat, 2)); $size = $this->addLine(254, $line); $line = array("Quantity" => " ", "Code" => " ", "Description" => " ", "Price Each" => "Total:", "Line Total" => number_format($totalvat + $shipping + $total - $discount, 2)); $size = $this->addLine(260, $line); $this->addText(162, 265, "Pounds Sterling", 6, 3); } } else { logError($sql . " - " . mysql_error()); } } catch (Exception $e) { logError($e->getMessage()); } $this->AliasNbPages(); }
function logout() { start_db(); if (isAuthenticated()) { $qry = "UPDATE {$_SESSION['DB_PREFIX']}loginaudit SET " . "timeoff = NOW(), metamodifieddate = NOW(), metamodifieduserid = " . getLoggedOnMemberID() . " " . "WHERE id = " . $_SESSION['SESS_LOGIN_AUDIT'] . ""; $result = mysql_query($qry); } session_unset(); $_SESSION['ROLES'][] = 'PUBLIC'; }
public static function initialise() { //Start session start_db(); $_SESSION['pagename'] = substr($_SERVER["PHP_SELF"], strripos($_SERVER["PHP_SELF"], "/") + 1); if ($_SESSION['pagename'] == "dynamicpage.php") { $_SESSION['pagename'] .= "?page=" . $_GET['page']; } BreadCrumbManager::initialise(); self::initialiseDB(); self::initialisePageData(); BreadCrumbManager::calculate(); }
function __construct($orientation, $metric, $size, $id) { global $member; global $top; parent::__construct($orientation, $metric, $size); $this->SetAutoPageBreak(true, 0); //Include database connection details start_db(); $margin = 7; $sql = "SELECT A.*, " . "DATE_FORMAT(A.creditdate, '%d/%m/%Y') AS creditdate, " . "DATE_FORMAT(A.paymentdate, '%d/%m/%Y') AS paymentdate, " . "DATE_FORMAT(A.createddate, '%d/%m/%Y') AS createddate, " . "DATE_FORMAT(B.datedelivered, '%d/%m/%Y') AS datedelivered, " . "A.deladdress, A.toaddress, B.plaintiff, B.casenumber, B.transcripttype, B.j33number, B.depositamount, " . "D.name AS courtname, D.vatapplicable, D.address, D.fax AS courtfax, D.cellphone AS courtmobile, " . "D.email AS courtemail, D.telephone AS courttelephone, D.contact AS courtcontact, " . "E.name AS provincename, F.name AS terms, G.firstname, G.lastname, G.mobile, G.landline, G.email, G.fax, " . "I.name AS clientcourtname, " . "O.privatebankingdetails, O.bankingdetails, " . "O.address AS officeaddress, O.email AS officeemail, O.telephone, O.contact, O.fax AS officefax, O.name AS officename " . "FROM {$_SESSION['DB_PREFIX']}invoices A " . "INNER JOIN {$_SESSION['DB_PREFIX']}cases B " . "ON B.id = A.caseid " . "INNER JOIN {$_SESSION['DB_PREFIX']}courts D " . "ON D.id = B.courtid " . "INNER JOIN {$_SESSION['DB_PREFIX']}province E " . "ON E.id = D.provinceid " . "LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}caseterms F " . "ON F.id = A.termsid " . "INNER JOIN {$_SESSION['DB_PREFIX']}members G " . "ON G.member_id = A.contactid " . "LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}courts I " . "ON I.id = B.clientcourtid " . "LEFT OUTER JOIN {$_SESSION['DB_PREFIX']}offices J " . "ON J.id = A.officeid " . "INNER JOIN {$_SESSION['DB_PREFIX']}offices O " . "ON O.id = A.officeid " . "WHERE A.caseid = {$id} " . "ORDER BY B.id"; $result = mysql_query($sql); if ($result) { $total = 0; $subtotal = 0; $shipping = 0; $totalvat = 0; $depositamount = 0; $vatapplicable = "N"; while ($member = mysql_fetch_assoc($result)) { $this->newPage(); $first = false; $y = $top; $vatapplicable = $member['vatapplicable']; $invoiceid = $member['id']; // $description = $this->stripHTML($member['description']); $description = $member['description']; if ($member['depositamount'] != null) { $depositamount = $member['depositamount']; } $sql = "SELECT C.id, C.description, C.qty, C.vat, C.vatrate, C.total, C.unitprice, " . "H.name AS templatename " . "FROM {$_SESSION['DB_PREFIX']}invoiceitems C " . "INNER JOIN {$_SESSION['DB_PREFIX']}invoiceitemtemplates H " . "ON H.id = C.templateid " . "WHERE C.invoiceid = {$invoiceid} " . "ORDER BY C.id"; $itemresult = mysql_query($sql); if ($itemresult) { while ($itemmember = mysql_fetch_assoc($itemresult)) { $line = array("Quantity" => number_format($itemmember['qty'], 0), "Description" => $itemmember['templatename'], "Unit Price" => "R " . number_format($itemmember['unitprice'], 2), "Total" => "R " . number_format($itemmember['total'], 2)); $size = $this->addLine($y, $line); $y += $size; if ($y > 235) { $this->newPage(); $y = $top; } $subtotal += $itemmember['total'] - $member['vat']; $shipping = $itemmember['shippinghandling']; $totalvat += $itemmember['vat']; $total += $itemmember['total']; } $y += 4; if ($y > 175) { $this->newPage(); $y = $top; } $line = array("Quantity" => " ", "Description" => $description, "Unit Price" => " ", "Total" => " "); $size = $this->addLine($y, $line); $y += $size; if ($y > 235) { $this->newPage(); $y = $top; } } else { logError($sql . " - " . mysql_error()); } } } else { logError($sql . " - " . mysql_error()); } if ($vatapplicable == "Y") { $this->Line(121, 240, 200, 240); $this->Line(121, 245, 200, 245); $this->Line(121, 250, 200, 250); } $this->Line(121, 255, 200, 255); if ($vatapplicable == "Y") { $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "VAT (" . number_format(getSiteConfigData()->vatrate, 0) . "%)", "Total" => "R " . number_format($totalvat, 2)); $size = $this->addLine(242, $line); $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "TOTAL", "Total" => "R " . number_format($total, 2)); $size = $this->addLine(247, $line); $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "DEPOSIT", "Total" => "R " . number_format($depositamount, 2)); $size = $this->addLine(252, $line); $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "TOTAL DUE", "Total" => "R " . number_format($total - $depositamount, 2)); $size = $this->addLine(258, $line, 0, 'B'); } else { $line = array("Quantity" => " ", "Description" => " ", "Unit Price" => "TOTAL", "Total" => "R " . number_format($total, 2)); $size = $this->addLine(258, $line, 0, 'B'); } }