function Header() { global $cityName; $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); $this->SetFont('Arial', '', 12); $t = ""; $v = ""; if (isset($_GET['region']) && strlen($_GET['region']) > 0) { $t = "Region"; $v = $_GET['region']; } else { if (isset($_GET['city']) && strlen($_GET['city']) > 0) { $t = "City"; $v = $_GET['city']; } } if (strlen($t) > 0) { $this->Cell(30, 6, $t, 0, 0, 'L'); $this->Cell(63, 6, $v, 'B', 0, 'L'); if (strlen($cityName) > 0) { $this->Cell(30, 6, "City", 0, 0, 'L'); $this->Cell(63, 6, $cityName, 'B', 0, 'L'); } $this->Ln(10); } //Ensure table header is output parent::Header(); }
function Header() { global $title, $partyName; $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 6, $title, 0, 1, 'C'); $this->Ln(2); if (strlen($_GET['date_start']) > 0) { $this->SetFont('Arial', 'B', 12); $this->Cell(30, 6, "Start Date:", 0, 0, 'L'); $this->SetFont('Arial', '', 12); $this->Cell(30, 6, $_GET['date_start'], 'B', 0, 'L'); $this->SetX(-70); } if (strlen($_GET['date_end']) > 0) { $this->SetFont('Arial', 'B', 12); $this->Cell(30, 6, "End Date:", 0, 0, 'L'); $this->SetFont('Arial', '', 12); $this->Cell(30, 6, $_GET['date_end'], 'B', 0, 'R'); } $this->Ln(); $this->SetFont('Arial', 'B', 12); $this->Cell(30, 6, "Party:", 0, 0, 'L'); $this->SetFont('Arial', '', 12); $this->Cell(150, 6, $partyName, 'B', 1, 'L'); $this->Ln(2); //Ensure table header is output parent::Header(); }
function __construct($orientation, $metric, $size, $startdate, $enddate, $userid) { $dynamicY = 0; parent::__construct($orientation, $metric, $size); $this->SetAutoPageBreak(true, 30); $this->AddPage(); try { $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()); } }
function __construct($orientation, $metric, $size, $startdate, $enddate) { $dynamicY = 0; parent::__construct($orientation, $metric, $size); $this->SetAutoPageBreak(true, 30); $this->AddPage(); try { $and = ""; if ($startdate != "") { $and .= " AND A.matchdate >= '{$startdate}' "; } if ($enddate != "") { $and .= " AND A.matchdate <= '{$enddate}' "; } $sql = "SELECT A.*, DATE_FORMAT(A.matchdate, '%d/%m/%Y') AS matchdate,\n\t\t\t\t\t B.name AS refereeename,\n\t\t\t\t\t C.age, C.name AS teamname\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\tLEFT OUTER JOIN {$_SESSION['DB_PREFIX']}teamagegroup C \n\t\t\t\t\t\tON C.id = A.teamid \n\t\t\t\t\t\tWHERE (A.ratereferee = 'P' OR A.rateplayers = 'P' OR A.ratemanagement = 'P' OR A.ratespectators = 'P' OR A.ratepitchsize = 'P' OR A.ratepitchcondition = 'P' OR A.rategoalsize = 'P' OR A.ratechangingrooms = 'P') {$and}\n\t\t\t\t\t\tORDER BY A.matchdate"; $result = mysql_query($sql); if ($result) { while ($member = mysql_fetch_assoc($result)) { $line = array("Date of Match" => $member['matchdate'], "Age Group" => "Under " . $member['age'], "Division" => $member['division'], "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()); } }
function Header() { global $title; $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 6, $title, 0, 1, 'C'); $this->Ln(2); $this->SetFont('Arial', 'B', 10); //$this->Cell(50, 6, $vendor, 'B', 0, 'L'); $this->SetX($this->GetX() + 90); //$this->Cell(50, 6, $vehicle, 'B', 1, 'L'); $this->Ln(2); $w = $this->w - $this->lMargin - $this->rMargin; $this->SetFont('Arial', 'B', 10); $this->Cell(20 / 100 * $w, 6, "Name", 1, 0, 'C'); $this->Cell(25 / 100 * $w, 6, "Address", 1, 0, 'C'); $this->Cell(10 / 100 * $w, 6, "Phone1", 1, 0, 'C'); $this->Cell(10 / 100 * $w, 6, "Phone2", 1, 0, 'C'); $this->Cell(10 / 100 * $w, 6, "Phone3", 1, 0, 'C'); $this->Cell(12 / 100 * $w, 6, "Person", 1, 0, 'C'); $this->Cell(13 / 100 * $w, 6, "Vehicle", 1, 0, 'C'); $this->Ln(); //Ensure table header is output parent::Header(); }
function __construct($orientation, $metric, $size, $year, $month) { $dynamicY = 0; parent::__construct($orientation, $metric, $size); $this->SetAutoPageBreak(true, 30); $this->AddPage(); try { $sql = "SELECT SUM(TIMESTAMPDIFF(MINUTE, starttime, endtime)) AS hours, B.name AS customername\n\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}diary A \n\t\t\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}client B \n\t\t\t\t\t\tON B.id = A.clientid \n\t\t\t\t\t\tWHERE A.status IN ('I', 'C')\n\t\t\t\t\t\tAND YEAR(A.starttime) = {$year}\n\t\t\t\t\t\tAND MONTH(A.starttime) = {$month}\n\t\t\t\t\t\tAND A.deleted != 'Y'\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("Customer" => $member['customername'], "Hours Worked" => number_format($member['hours'] / 60, 2)); if ($this->GetY() > 260) { $this->AddPage(); } $this->addLine($this->GetY(), $line, 5.5); $this->Line(10, $this->GetY() - 0.5, 200, $this->GetY() - 0.5); } } else { logError($sql . " - " . mysql_error()); } } catch (Exception $e) { logError($e->getMessage()); } }
function __construct($orientation, $metric, $size, $startdate, $enddate, $userid) { $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()); } }
function Header() { global $title, $vendor; $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 6, $title, 0, 1, 'C'); $this->Ln(1); $this->SetFont('Arial', 'B', 10); $this->Cell(50, 6, $vendor, 'B', 0, 'L'); $this->SetX($this->GetX() + 90); $this->Cell(50, 6, "", 'B', 1, 'L'); $this->Ln(1); $w = $this->w - $this->lMargin - $this->rMargin; $this->SetFont('Arial', 'B', 10); $this->Cell(5 / 100 * $w, 6, "C-No", 1, 0, 'C'); $this->Cell(40 / 100 * $w, 6, "Description", 1, 0, 'C'); $this->Cell(25 / 100 * $w, 6, "Manufacturer No", 1, 0, 'C'); $this->Cell(5 / 100 * $w, 6, "Cost", 1, 0, 'C'); $this->Cell(5 / 100 * $w, 6, "Sale", 1, 0, 'C'); $this->Cell(5 / 100 * $w, 6, "Diff", 1, 0, 'C'); $this->Cell(5 / 100 * $w, 6, "Qty", 1, 0, 'C'); $this->Cell(10 / 100 * $w, 6, "Amount", 1, 0, 'C'); $this->Ln(); //Ensure table header is output parent::Header(); }
function Header() { global $title, $vehicle, $vendor; $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 6, $title, 0, 1, 'C'); $this->Ln(2); $this->SetFont('Arial', 'B', 10); $this->Cell(50, 6, $vendor, 'B', 0, 'L'); $this->SetX($this->GetX() + 90); $this->Cell(50, 6, $vehicle, 'B', 1, 'L'); $this->Ln(2); $w = $this->w - $this->lMargin - $this->rMargin; $this->SetFont('Arial', 'B', 10); $this->Cell(5 / 100 * $w, 6, "C-No", 1, 0, 'C'); if ($vendor == 'TIK') { $this->Cell(25 / 100 * $w, 6, "Description", 1, 0, 'C'); $this->Cell(15 / 100 * $w, 6, "Fix Rate", 1, 0, 'C'); } else { $this->Cell(40 / 100 * $w, 6, "Description", 1, 0, 'C'); } $this->Cell(15 / 100 * $w, 6, "Model", 1, 0, 'C'); $this->Cell(15 / 100 * $w, 6, "OEM Num", 1, 0, 'C'); $this->Cell(25 / 100 * $w, 6, "Circular Rate", 1, 0, 'C'); $this->Ln(); //Ensure table header is output parent::Header(); }
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($orientation, $metric, $size, $startdate, $enddate, $userid) { $dynamicY = 0; parent::__construct($orientation, $metric, $size); $this->SetAutoPageBreak(true, 30); $this->AddPage(); try { $and = ""; if ($startdate != "") { $and .= " AND A.metacreateddate >= '{$startdate}' "; } if ($enddate != "") { $and .= " AND A.metacreateddate <= '{$enddate}' "; } if ($userid != "0") { $and .= " AND A.takenbyid = {$userid} "; } $sql = "SELECT A.*, \n\t\t\t\t\t B.name AS customername, B.accountnumber, \n\t\t\t\t\t C.fullname,\n\t\t\t\t\t\tDATE_FORMAT(A.metacreateddate, '%d/%m/%Y %H:%I') AS metacreateddate\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 1 = 1 {$and} \n\t\t\t\t\t\tORDER BY B.name, A.metacreateddate"; $result = mysql_query($sql); if ($result) { while ($member = mysql_fetch_assoc($result)) { $line = array("Customer" => $member['customername'], "Customer Code" => $member['accountnumber'], "Quotation Number" => getSiteConfigData()->bookingprefix . "-" . sprintf("%06d", $member['id']), "User" => $member['fullname'], "Quotation Date" => $member['metacreateddate'], "Value" => number_format($member['total'], 2)); $this->addLine($this->GetY(), $line); } } else { logError($sql . " - " . mysql_error()); } } catch (Exception $e) { logError($e->getMessage()); } }
function Header() { global $ret, $_title; $this->SetFont('Arial', '', 6); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'I', 6); $this->SetX($this->lMargin); $this->Cell(0, 6, 'Report generated by nexexcel.com', 0, 0, 'L'); $this->Ln(0); $t = $_title; if (isset($_GET['account_class']) && strlen($_GET['account_class']) > 0) { $t .= " - " . $_GET['account_class']; } $this->SetFont('Arial', 'B', 8); $this->Cell(0, 6, $t, 0, 1, 'C'); $this->Ln(2); $this->SetFont('Arial', '', 8); $this->Cell(30, 6, "Account Name", 0, 0, 'L'); $this->Cell(63, 6, $ret['account_name'], 'B', 0, 'L'); $this->SetX($this->GetX() + 25); $this->Cell(35, 6, "Opening Balance", 0, 0, 'L'); $this->Cell(37, 6, number_format($ret['aob']), 1, 1, 'R'); if (strlen($ret['party_address']) > 0) { $this->Cell(30, 6, "Party Address", 0, 0, 'L'); $this->Cell(63, 6, $ret['party_address'], 'B', 1, 'L'); } $this->Ln(5); //Ensure table header is output parent::Header(); }
function Header() { $this->SetFont('Arial', '', 8); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); //Ensure table header is output parent::Header(); }
function Header() { $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); //Ensure table header is output parent::Header(); }
function Header() { $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); $this->Cell(94.999527777778, 6, 'Karachi', 1, 0, 'C', false); $this->Cell(94.999527777778, 6, 'Lahore', 1, 0, 'C', false); $this->Ln(); //Ensure table header is output parent::Header(); }
function Header() { global $title, $city; $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 6, $title, 0, 1, 'C'); $this->SetFont('Arial', 'B', 12); $this->Cell(0, 6, $city, 1, 1, 'C'); //Ensure table header is output parent::Header(); }
function Header() { global $title; $strDate = $_GET['date_start']; if (strlen($_GET['date_end']) > 0) { $strDate .= " ~ " . $_GET['date_end']; } $this->SetFont('Arial', 'B', 18); $this->Cell(0, 6, $title . " - " . $strDate, 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 1, 'R'); $this->Ln(); //Ensure table header is output parent::Header(); }
function Header() { global $title; $this->SetFont('Arial', '', 6); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'I', 6); $this->SetX($this->lMargin); $this->Cell(0, 6, 'Report generated by nexexcel.com', 0, 0, 'L'); $this->Ln(0); $this->SetFont('Arial', 'B', 8); $this->Cell(0, 6, $title, 0, 1, 'C'); $this->Ln(0); //Ensure table header is output parent::Header(); }
function Header() { global $ret; $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); $this->SetFont('Arial', '', 12); $this->Cell(30, 6, "Account Name", 0, 0, 'L'); $this->Cell(63, 6, $ret['account_name'], 'B', 0, 'L'); $this->SetX($this->GetX() + 25); $this->Cell(35, 6, "Opening Balance", 0, 0, 'L'); $this->Cell(37, 6, number_format($ret['aob']), 1, 1, 'R'); $this->Ln(5); //Ensure table header is output parent::Header(); }
function Header() { $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 1, 'R'); $this->Ln(10); $this->printTitle(); $this->SetFont('Arial', 'B', 8); $this->SetX(10); $this->Cell(55.5, 6, "Customer", 1, 0, 'C', false); $this->Cell(55.25, 6, "1st Visit", 1, 0, 'C', false); $this->Cell(55.5, 6, "2nd Visit", 1, 0, 'C', false); $this->Cell(55.25, 6, "3rd Visit", 1, 0, 'C', false); $this->Cell(55.5, 6, "4th Visit", 1, 0, 'C', false); $this->Ln(6); //Ensure table header is output parent::Header(); }
function Header() { global $aob, $account, $account_hidden; $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, "Print Date: " . date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); $this->SetFont('Arial', '', 12); $this->Cell(42, 6, "Account Title", 0, 0, 'L'); $this->Cell(40, 6, $account, 'B', 0, 'L'); $this->SetX($this->GetX() + 43); $this->Cell(35, 6, "Opening Balance", 0, 0, 'L'); $this->SetX($this->GetX() + 1); $this->Cell(30, 6, number_format($aob), 1, 1, 'R'); $this->Cell(42, 6, "Account Code", 0, 0, 'L'); $this->Cell(40, 6, $account_hidden, 'B', 1, 'L'); if (strlen($_GET['date_start']) > 0 && strlen($_GET['date_end']) > 0) { $this->Cell(42, 6, "Date From", 0, 0, 'L'); $this->Cell(40, 6, $_GET['date_start'], 'B', 0, 'L'); $this->SetX($this->GetX() + 43); $this->Cell(35, 6, "Date To", 0, 0, 'L'); $this->SetX($this->GetX() + 1); $this->Cell(30, 6, $_GET['date_end'], 'B', 1, 'R'); } else { if (strlen($_GET['date_start']) > 0) { $this->Cell(42, 6, "Date From", 0, 0, 'L'); $this->Cell(40, 6, $_GET['date_start'], 'B', 1, 'L'); } else { if (strlen($_GET['date_end']) > 0) { $this->Cell(42, 6, "Date To", 0, 0, 'L'); $this->Cell(40, 6, $_GET['date_end'], 'B', 1, 'L'); } } } $this->Ln(5); //Ensure table header is output parent::Header(); }
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()); } }
function Header() { global $city; $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->printTitle(); $this->SetFont('Arial', '', 12); $_city = $city; if ($_city == '#ALL#') { $_city = "All Pakistan"; } $this->Cell(42, 6, "City", 0, 0, 'L'); $this->Cell(40, 6, $_city, 'B', 1, 'L'); $this->Ln(5); //Ensure table header is output parent::Header(); }
function Header() { global $aob, $account, $account_hidden; $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 1, 'R'); $this->Ln(10); $this->Cell(42, 6, "Customer/Distributor", 0, 0, 'L'); $this->Cell(40, 6, $account, 'B', 0, 'L'); $this->SetX($this->GetX() + 43); $this->Cell(35, 6, "Opening Balance", 0, 0, 'L'); $this->SetX($this->GetX() + 1); $this->Cell(30, 6, number_format($aob), 1, 1, 'R'); $this->Cell(42, 6, "Code", 0, 0, 'L'); $this->Cell(40, 6, $account_hidden, 'B', 1, 'L'); $this->Ln(5); $this->printTitle(); //Ensure table header is output parent::Header(); }
function Header() { global $distributor, $d_net; $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 1, 'R'); $this->Ln(10); $this->SetFont('Arial', 'B', 14); $this->Cell(0, 6, 'Distributor Party Outstanding', 0, 1, 'C'); $this->Ln(2); $this->SetFont('Arial', 'B', 12); $this->Cell(30, 6, 'Distributor', 0, 0, 'L'); $this->Cell(50, 6, $distributor, 'B', 0, 'L'); $this->SetX($this->GetX() + 29); $this->Cell(30, 6, 'Outstanding', 0, 0, 'L'); $this->Cell(50, 6, $d_net, 'B', 0, 'L'); $this->Ln(); $this->Ln(5); //Ensure table header is output parent::Header(); }
function Header() { global $invoice, $partyName, $partyCode, $partyCity, $date, $billteNo1, $transporter1, $billteNo2, $transporter2, $billteNo3, $transporter3, $dueDate; $this->SetFont('Arial', '', 8); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 8); $this->Cell(0, 6, 'Estimates', 0, 1, 'C'); $this->Ln(2); $this->SetFont('Arial', 'B', 8); $col1 = 30; $col2 = 50; $col3 = 30; $col4 = 50; $xspace = 80 - $col2; $pdata = array("Date", $date, "Inv#", $invoice, "Customer", $partyName, "Code", $partyCode, "Payment Due", $dueDate, "City", $partyCity, "Bilty #", $billteNo1, "Transport", $transporter1, "Bilty #", $billteNo2, "Transport", $transporter2, "Bilty #", $billteNo3, "Transport", $transporter3); for ($i = 0; $i < count($pdata); $i += 4) { $border = "0"; if (strlen($pdata[$i + 0]) > 0) { $border = 'B'; } $this->Cell($col1, 6, $pdata[$i + 0], 0, 0, 'L'); $this->Cell($col2, 6, $pdata[$i + 1], $border, 0, 'L'); $this->SetX($this->GetX() + $xspace); $border = "0"; if (strlen($pdata[$i + 2]) > 0) { $border = 'B'; } $this->Cell($col3, 6, $pdata[$i + 2], 0, 0, 'L'); $this->Cell($col4, 6, $pdata[$i + 3], $border, 0, 'L'); $this->Ln(); } $this->Ln(5); //Ensure table header is output parent::Header(); }
function __construct($orientation, $metric, $size, $startdate, $enddate) { $dynamicY = 0; parent::__construct($orientation, $metric, $size); $this->SetAutoPageBreak(true, 30); $this->AddPage(); try { $sql = "SELECT A.name, B.name AS clubname\n\t\t\t\t\t\tFROM {$_SESSION['DB_PREFIX']}teamagegroup A \n\t\t\t\t\t\tINNER JOIN {$_SESSION['DB_PREFIX']}team B \n\t\t\t\t\t\tON B.id = A.teamid \n\t\t\t\t\t\tWHERE A.id NOT IN (SELECT C.agegroupid FROM {$_SESSION['DB_PREFIX']}player C)\n\t\t\t\t\t\tORDER BY A.name, B.name"; $result = mysql_query($sql); if ($result) { while ($member = mysql_fetch_assoc($result)) { $line = array("Club" => $member['clubname'], "Team" => $member['name']); if ($this->GetY() > 265) { $this->AddPage(); } $this->addLine($this->GetY(), $line); } } else { logError($sql . " - " . mysql_error()); } } catch (Exception $e) { logError($e->getMessage()); } }
try { if (!isset($_SESSION["usuario"])) { validarSesion(false); exit; } $UsuarioNombre = $_SESSION["usuario"]; if (!isset($_SESSION['ReportesSiniestros']["ReporteDatosdelaEmpresa"])) { header("Location: /JuiciosParteDemandada"); // CIERRA LA PAGINA // echo "<script languaje='javascript' type='text/javascript'>window.close();</script>"; exit; } global $conn; SetDateFormatOracle("DD/MM/YYYY"); $params = array(); $pdf = new PDFReport(); $pdf->SetTitle("ReporteDatosdelaEmpresa"); $pdf->SetAuthor("JLovatto"); $pdf->SetCreator("ReporteDatosdelaEmpresa"); $pdf->SetSubject("REPORTE WEB LEGALES"); $sql = ObtenerSQL_DatosdelaEmpresa(); $params[":siniestro"] = $_SESSION["ReportesSiniestros"]["ID"]; $params[":orden"] = $_SESSION["ReportesSiniestros"]["ORDEN"]; $stmt = DBExecSql($conn, $sql, $params); //----------------------------------------------------------------------- if (DBGetRecordCount($stmt) == 0) { echo "La consulta no devolviò datos."; exit; } $rowCabecera = DBGetQuery($stmt, 1, false); //-----------------------------------------------------------------------
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()); } }
function Header() { global $title, $months, $accounts_classes, $prop; $this->SetFont('Arial', 'B', 18); // $this->Cell(0, 6, $_SESSION['companyname'], 0, 0, 'C'); $this->SetFont('Arial', '', 12); $this->SetX(-35); $this->Cell(0, 6, date("M d, Y"), 0, 0, 'R'); $this->Ln(0); $this->SetFont('Arial', 'B', 14); $m = '(' . $_GET['date_start'] . " - " . $_GET['date_end'] . ')'; $this->Cell(0, 6, $title . " " . $m, 0, 1, 'C'); $this->Ln(2); $w = $this->w - $this->lMargin - $this->rMargin; $p = count($accounts_classes); $this->SetFillColor($prop['HeaderColor'][0], $prop['HeaderColor'][1], $prop['HeaderColor'][2]); $this->SetTextColor($prop['HeaderTextColor'][0], $prop['HeaderTextColor'][1], $prop['HeaderTextColor'][2]); foreach ($accounts_classes as $accounts_class => $accounts_class_name) { $this->Cell(1 / $p * $w, 6, $accounts_class_name, 1, 0, 'C', true); } $this->Ln(); //Ensure table header is output parent::Header(); }