X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Fpdf_report.inc;h=67d23e84cbdca7ce6792646925b5ff888f1ceb96;hb=510d6e1925c4d1621ae3efd85e117cc9bb4320f0;hp=72cc3390427cd2ef1f003830a099391572f6d6c0;hpb=76e0d8ce10ae41b04496fcee4bf282b6d54ad4d6;p=fa-stable.git
diff --git a/reporting/includes/pdf_report.inc b/reporting/includes/pdf_report.inc
index 72cc3390..67d23e84 100644
--- a/reporting/includes/pdf_report.inc
+++ b/reporting/includes/pdf_report.inc
@@ -1,9 +1,20 @@
.
+***********************************************************************/
+//include_once($path_to_root . "reporting/includes/class.pdf.inc");
+include_once(dirname(__FILE__)."/class.pdf.inc");
+include_once(dirname(__FILE__)."/printer_class.inc");
+include_once($path_to_root . "/admin/db/company_db.inc");
+include_once($path_to_root . "/admin/db/printers_db.inc");
+include_once($path_to_root . "/config.php");
class FrontReport extends Cpdf
{
var $size;
@@ -21,7 +32,7 @@ class FrontReport extends Cpdf
var $rightMargin;
var $endLine;
var $lineHeight;
- var $rtl;
+ //var $rtl;
var $cols;
var $params;
@@ -34,13 +45,21 @@ class FrontReport extends Cpdf
var $titleCol;
var $pageNumber;
var $fontSize;
+ var $oldFontSize;
var $currency;
function FrontReport($title, $filename, $size = 'A4', $fontsize = 9)
{
- switch ($size)
+ global $page_security;
+ if (!$_SESSION["wa_current_user"]->can_access_page($page_security))
{
-
+ display_error(_("The security settings on your account do not permit you to print this report"));
+ end_page();
+ exit;
+ }
+ switch ($size)
+ {
+ default:
case 'A4':
case 'a4':
$this->pageWidth=595;
@@ -110,52 +129,33 @@ class FrontReport extends Cpdf
}
$this->size = array(0, 0, $this->pageWidth, $this->pageHeight);
$this->title = $title;
- $this->filename = $filename;
+ $this->filename = $filename.".pdf";
$this->pageNumber = 0;
$this->endLine = $this->pageWidth - $this->rightMargin;
$this->companyCol = $this->endLine - 150;
$this->titleCol = $this->leftMargin + 100;
$this->lineHeight = 12;
$this->fontSize = $fontsize;
+ $this->oldFontSize = 0;
+ $this->row = $this->pageHeight - $this->topMargin;
$this->currency = '';
- $this->rtl = ($_SESSION['language']->dir == 'rtl');
- // for quick testing
- //$this->rtl = true;
- $this->Cpdf($this->size);
+ $rtl = ($_SESSION['language']->dir === 'rtl' ? 'rtl' : 'ltr');
+ $code = $_SESSION['language']->code;
+ $enc = strtoupper($_SESSION['language']->encoding);
+ // for the language array in class.pdf.inc
+ $l = array('a_meta_charset' => $enc, 'a_meta_dir' => $rtl, 'a_meta_language' => $code, 'w_page' => 'page');
+ $this->Cpdf($size, $l);
}
function Font($style = 'normal')
{
- global $path_to_root;
- $own = false;
- $locale = $path_to_root . "lang/" . $_SESSION['language']->code . "/locale.inc";
- if (file_exists($locale))
- {
- $fontinclude = true;
- include($locale);
- }
- //if ($this->rtl) // this is good for presentation only
- if (!$own)
- {
- if (user_price_dec() == 3) // only for presentation of farsi
- {
- $this->rtl = true;
- $path = $path_to_root . 'reporting/fonts/farsi_1.afm';
- }
- elseif ($style == 'italic')
- $path = $path_to_root . 'reporting/fonts/Helvetica-Oblique.afm';
- elseif ($style == 'bold')
- $path = $path_to_root . 'reporting/fonts/Helvetica-Bold.afm';
- else // even take misspelled styles
- $path = $path_to_root . 'reporting/fonts/Helvetica.afm';
- }
- $this->selectFont($path, 'WinAnsiEncoding');
+ $this->selectFont("", $style);
}
function Info($params, $cols, $headers, $aligns,
$cols2 = null, $headers2 = null, $aligns2 = null)
{
- global $app_title, $version, $power_by, $power_url, $path_to_root, $db_connections;
+ global $app_title, $version, $power_by, $power_url;
$this->addinfo('Title', $this->title);
$this->addinfo('Subject', $this->title);
@@ -169,7 +169,6 @@ class FrontReport extends Cpdf
$this->fiscal_year = sql2date($year['begin']) . " - " . sql2date($year['end']) . " " . "(" . $how . ")";
$this->company = get_company_prefs();
$this->user = $_SESSION["wa_current_user"]->name;
- //$this->host = $db_connections[$_SESSION["wa_current_user"]->company]["host"];
$this->host = $_SERVER['SERVER_NAME'];
$this->params = $params;
$this->cols = $cols;
@@ -210,6 +209,8 @@ class FrontReport extends Cpdf
$str = _("Print Out Date") . ':';
$this->Text($this->leftMargin, $str, $this->titleCol);
$str = Today() . ' ' . Now();
+ if ($this->company['time_zone'])
+ $str .= ' ' . date('O') . ' GMT';
$this->Text($this->titleCol, $str, $this->companyCol);
$this->Text($this->companyCol, $this->host);
@@ -231,7 +232,7 @@ class FrontReport extends Cpdf
$str .= " - " . $this->params[$i]['to'];
$this->Text($this->titleCol, $str, $this->companyCol);
}
- }
+ }
if ($this->params[0] != '') // Comments
{
$this->NewLine();
@@ -242,7 +243,7 @@ class FrontReport extends Cpdf
$this->Font();
}
$str = _("Page") . ' ' . $this->pageNumber;
- $this->Text($this->endLine - 35, $str);
+ $this->Text($this->endLine - 38, $str);
$this->Line($this->row - 5, 1);
$this->row -= ($this->lineHeight + 6);
@@ -265,251 +266,42 @@ class FrontReport extends Cpdf
function Header2($myrow, $branch, $sales_order, $bankaccount, $doctype)
{
- global $path_to_root, $print_as_quote;
-
+ global $comp_path, $path_to_root, $print_as_quote, $print_invoice_no, $packing_slip;
+
$this->pageNumber++;
if ($this->pageNumber > 1)
$this->newPage();
$header2type = true;
- if ($this->currency != $myrow['curr_code'])
- {
- include($path_to_root . "reporting/includes/doctext2.inc");
- }
- else
- {
- include($path_to_root . "reporting/includes/doctext.inc");
- }
- $this->row = $this->pageHeight - $this->topMargin;
-
- $upper = $this->row - 2 * $this->lineHeight;
- $lower = $this->bottomMargin + 6 * $this->lineHeight;
- $iline1 = $upper - 4 * $this->lineHeight;
- $iline2 = $iline1 - 8 * $this->lineHeight;
- $iline3 = $iline2 - 8 * $this->lineHeight;
- $iline4 = $iline3 - 2 * $this->lineHeight;
- $iline5 = $lower + 5 * $this->lineHeight;
- $icol = $this->pageWidth / 2;
- $ccol = $this->cols[0] + 4;
- $ccol2 = $icol / 2;
- $mcol = $icol + 8;
- $mcol2 = $this->pageWidth - $ccol2;
-
- $this->SetDrawColor(128, 128, 128);
- $this->LineTo($this->pageWidth - $this->rightMargin, $upper ,$this->leftMargin, $upper);
- $this->LineTo($this->leftMargin, $upper ,$this->leftMargin, $lower);
- $this->LineTo($this->pageWidth - $this->rightMargin, $lower ,$this->leftMargin, $lower);
- $this->LineTo($this->pageWidth - $this->rightMargin, $lower ,$this->pageWidth - $this->rightMargin, $upper);
- $this->Line($iline1);
- $this->Line($iline2);
- $this->Line($iline3);
- $this->Line($iline4);
- $this->Line($iline5);
- $this->LineTo($icol, $upper ,$icol, $iline1);
- $this->NewLine();
-
- $this->fontSize += 4;
- $this->Font('bold');
- $this->Text($mcol, $this->title);
- $this->Font();
- $this->fontSize -= 4;
- if ($this->pageNumber > 1 && !strstr($this->filename, "Bulk"))
- $this->Text($this->endLine - 35, _("Page") . ' ' . $this->pageNumber);
- $this->fontSize -= 4;
- $this->row = $upper - 5;
-
- $this->Text($mcol, $doc_Invoice_no, $mcol + 90);
- $this->Text($mcol + 90, $doc_Cust_no, $mcol + 180);
- $this->Text($mcol + 180, $doc_Date);
- $this->fontSize += 4;
-
- $this->row = $upper - 2 * $this->lineHeight - 2;
- if ($this->company['coy_logo'] != '')
+ if (isset($myrow['curr_code']) && $this->currency != $myrow['curr_code'])
{
- $logo = $path_to_root . "themes/default/images/" . $this->company['coy_logo'];
- $this->AddImage($logo, $ccol, $iline1 + 5, 220, 40);
+ include($path_to_root . "/reporting/includes/doctext2.inc");
}
else
{
- $this->fontSize += 4;
- $this->Font('bold');
- $this->Text($ccol, $this->company['coy_name'], $icol);
- $this->Font();
- $this->fontSize -= 4;
+ include($path_to_root . "/reporting/includes/doctext.inc");
}
- if ($doctype == 8) // PO
- $this->Text($mcol, $myrow['order_no'], $mcol + 90);
- else if ($doctype == 9) // SO
- $this->Text($mcol, $myrow['order_no'] ." ".$myrow['customer_ref'], $mcol + 90);
- else // INV/CRE/STA
- $this->Text($mcol, $myrow['reference'], $mcol + 90);
- $this->Text($mcol + 90, $myrow['debtor_no'], $mcol + 180);
- if ($doctype == 8 || $doctype == 9)
- $this->Text($mcol + 180, sql2date($myrow['ord_date']));
- else
- $this->Text($mcol + 180, sql2date($myrow['tran_date']));
- $this->fontSize -= 4;
- $this->row = $iline1 - 5;
- $this->Text($ccol, $doc_Charge_To, $icol);
- $this->Text($mcol, $doc_Delivered_To);
- $this->fontSize += 4;
-
- $this->NewLine(2);
- $temp = $this->row;
- if ($doctype == 9)
- {
- $this->Text($ccol, $myrow['name'], $icol);
- //$adr = ?;
- }
- else
- {
- if ($doctype == 8)
- $this->Text($ccol, $myrow['supp_name'], $icol);
- else
- $this->Text($ccol, $myrow['DebtorName'], $icol);
- $adr = explode("\n", $myrow['address']);
- }
- for ($i = 0; $i < count($adr); $i++)
- {
- $this->NewLine();
- $this->Text($ccol, $adr[$i], $icol);
- }
- if ($sales_order != NULL)
- {
- $this->row = $temp;
- if ($doctype == 8)
- $this->Text($mcol, $this->company['coy_name']);
- else
- $this->Text($mcol, $sales_order['deliver_to']);
- $adr = explode("\n", $sales_order['delivery_address']);
- for ($i = 0; $i < count($adr); $i++)
- {
- $this->NewLine();
- $this->Text($mcol, $adr[$i]);
- }
- }
- $this->row = $iline2 - 2 * $this->lineHeight;
- $this->Text($ccol, $doc_Shipping_Company . ":", $ccol2);
- if ($doctype != 8)
- $this->Text($ccol2, $myrow['shipper_name'], $mcol);
- $this->Text($mcol, $doc_Due_Date . ":", $mcol2);
- if ($doctype == 9)
- $this->Text($mcol2, sql2date($myrow['delivery_date']));
- else if ($doctype != 8)
- $this->Text($mcol2, sql2date($myrow['due_date']));
- if ($branch != null)
- {
- $this->NewLine();
- $this->Text($ccol, $doc_Your_Ref . ":", $ccol2);
- $this->Text($ccol2, $branch['contact_name'], $mcol);
- $this->Text($mcol, $doc_Our_Ref . ":", $mcol2);
-
- $id = $branch['salesman'];
- $sql = "SELECT salesman_name FROM ".TB_PREF."salesman WHERE salesman_code='$id'";
- $result = db_query($sql,"could not get sales person");
- $row = db_fetch($result);
+ include($path_to_root . "/reporting/includes/header2.inc");
- $this->Text($mcol2, $row['salesman_name']);
- }
- $this->NewLine();
- $this->Text($ccol, $doc_Your_VAT_no . ":", $ccol2);
- if ($doctype != 8)
- $this->Text($ccol2, $myrow['tax_id'], $mcol);
- $this->Text($mcol, $doc_Our_VAT_no . ":", $mcol2);
- $this->Text($mcol2, $this->company['gst_no']);
- $this->NewLine();
- $this->Text($ccol, $doc_Payment_Terms . ":", $ccol2);
-
- $id = $myrow['payment_terms'];
- $sql = "SELECT terms FROM ".TB_PREF."payment_terms WHERE terms_indicator='$id'";
- $result = db_query($sql,"could not get paymentterms");
- $row = db_fetch($result);
-
- $this->Text($ccol2, $row["terms"], $mcol);
- $this->Text($mcol, $doc_Our_Order_No . ":", $mcol2);
- $this->Text($mcol2, $myrow['order_']);
-
- $locale = $path_to_root . "lang/" . $_SESSION['language']->code . "/locale.inc";
- if (file_exists($locale))
- {
- $header2include = true;
- include($locale);
- }
- $this->row = $iline3 - $this->lineHeight - 2;
- $this->Font('bold');
- $count = count($this->headers);
- for ($i = 0; $i < $count; $i++)
- $this->TextCol($i, $i + 1, $this->headers[$i], -2);
- $this->Font();
- $temp = $this->row - 2 * $this->lineHeight;
- $this->row = $iline5 - $this->lineHeight - 6;
- $this->Text($ccol, $doc_Please_Quote . " - " . $myrow['curr_code']);
- if ($this->params['comments'] != '')
- {
- $this->NewLine(2);
- $this->Font('bold');
- $this->Text($ccol, $this->params['comments']);
- $this->Font();
- }
-
- $this->row = $lower - 5;
- $this->fontSize -= 4;
-
- $this->Text($ccol, $doc_Address, $ccol2 + 40);
- $this->Text($ccol2 + 30, $doc_Phone_Fax_Email, $mcol);
- $this->Text($mcol , $doc_Bank, $mcol2);
- $this->Text($mcol2, $doc_Bank_Account);
- $this->fontSize += 4;
- $this->NewLine();
- $adrline = $this->row;
-
- $adr = explode("\n", $this->company['postal_address']);
- for ($i = 0; $i < count($adr); $i++)
- {
- $this->NewLine();
- $this->Text($ccol, $adr[$i], $ccol2 + 40);
- }
- $this->row = $adrline;
- $this->Text($ccol2 + 30, $this->company['phone'], $mcol);
- $this->NewLine();
- $this->Text($ccol2 + 30, $this->company['fax'], $mcol);
- $this->NewLine();
- $this->Text($ccol2 + 30, $this->company['email'], $mcol);
- // fetch this later
- $this->row = $adrline;
- $this->Text($mcol, $bankaccount['bank_name'], $mcol2);
- $adr = explode("\n", $bankaccount['bank_address']);
- for ($i = 0; $i < count($adr); $i++)
- {
- $this->NewLine();
- $this->Text($mcol, $adr[$i], $mcol2);
- }
-
- $this->row = $adrline;
- $this->Text($mcol2, $bankaccount['bank_account_name']);
- $this->NewLine();
- $this->Text($mcol2, $bankaccount['bank_account_number']);
$this->row = $temp;
}
function AddImage($logo, $x, $y, $w, $h)
{
- if ($this->rtl)
- $x = $this->pageWidth - $x - $w;
if (strpos($logo, ".png") || strpos($logo, ".PNG"))
$this->addPngFromFile($logo, $x, $y, $w, $h);
else
$this->addJpegFromFile($logo, $x, $y, $w, $h);
- }
+ }
function SetDrawColor($r, $g, $b)
{
- $this->setStrokeColor($r / 255, $g / 255, $b / 255);
+ $this->setStrokeColor($r, $g, $b);
}
-
+
function SetTextColor($r, $g, $b)
{
- $this->setColor($r / 255, $g / 255, $b / 255);
+ TCPDF::SetTextColor($r, $g, $b);
}
function Text($c, $txt, $n=0, $corr=0, $r=0)
@@ -517,20 +309,16 @@ class FrontReport extends Cpdf
if ($n == 0)
$n = $this->pageWidth - $this->rightMargin;
- return $this->TextWrap($c, $this->row - $r, $n - $c + $corr, $txt, 'left');
+ return $this->TextWrap($c, $this->row - $r, $n - $c + $corr, $txt, 'left');
}
-
- function TextWrap($xpos, $ypos, $len, $str, $align = 'left')
+
+ function TextWrap($xpos, $ypos, $len, $str, $align = 'left')
{
- if ($this->rtl)
+ if ($this->fontSize != $this->oldFontSize)
{
- $str = strrev($str);
- $xpos = $this->pageWidth - $xpos - $len;
- if ($align == 'left')
- $align = 'right';
- elseif ($align == 'right')
- $align = 'left';
- }
+ $this->SetFontSize($this->fontSize);
+ $this->oldFontSize = $this->fontSize;
+ }
return $this->addTextWrap($xpos, $ypos, $len, $this->fontSize, $str, $align);
}
@@ -539,32 +327,50 @@ class FrontReport extends Cpdf
return $this->TextWrap($this->cols[$c], $this->row - $r, $this->cols[$n] - $this->cols[$c] + $corr, $txt, $this->aligns[$c]);
}
+ function AmountCol($c, $n, $txt, $dec=0, $corr=0, $r=0)
+ {
+ return $this->TextCol($c, $n, number_format2($txt, $dec), $corr, $r);
+ }
+
+ function DateCol($c, $n, $txt, $conv=false, $corr=0, $r=0)
+ {
+ if ($conv)
+ $txt = sql2date($txt);
+ return $this->TextCol($c, $n, $txt, $corr, $r);
+ }
+
function TextCol2($c, $n, $txt, $corr=0, $r=0)
{
return $this->TextWrap($this->cols2[$c], $this->row - $r, $this->cols2[$n] - $this->cols2[$c] + $corr, $txt, $this->aligns2[$c]);
}
-
- function TextColLines($c, $n, $txt, $corr=0)
+
+ function TextColLines($c, $n, $txt, $corr=0, $r=0)
+ {
+ $this->row -= $r;
+ $this->TextWrapLines($this->cols[$c], $this->cols[$n] - $this->cols[$c] + $corr, $txt, $this->aligns[$c]);
+ }
+
+ function TextWrapLines($c, $width, $txt, $align='left')
{
$str = Explode("\n", $txt);
for ($i = 0; $i < count($str); $i++)
{
$l = $str[$i];
- do
+ do
{
- $l = $this->TextCol($c, $n, $l, $corr);
+ $l = $this->TextWrap($c, $this->row , $width, $l, $align);
$this->NewLine();
}
while ($l != '');
- }
+ }
}
- function LineTo($from, $row, $to, $row2)
+ function LineTo($from, $row, $to, $row2)
{
Cpdf::line($from, $row, $to, $row2);
}
- function Line($row, $height = 0)
+ function Line($row, $height = 0)
{
$this->setLineStyle($height + 1);
Cpdf::line($this->pageWidth - $this->rightMargin, $row ,$this->leftMargin, $row);
@@ -573,23 +379,17 @@ class FrontReport extends Cpdf
function NewLine($l=1, $np=0)
{
$this->row -= ($l * $this->lineHeight);
- if ($np > 0 && $this->row < $this->bottomMargin + ($np * $this->lineHeight))
+ if ($this->row < $this->bottomMargin + ($np * $this->lineHeight))
$this->Header();
- }
+ }
function End($email=0, $subject=null, $myrow=null, $doctype = 0)
{
- global $go_debug, $path_to_root;
+ global $pdf_debug, $path_to_root, $comp_path;
- // this is no good in IE so has been replaced, see down under
- // but good for debugging purposes in IE
- //session_write_close();
-
- if ($go_debug == 1)
+ if ($pdf_debug == 1)
{
- $buf = $this->output(1);
- $len = strlen($buf);
- $pdfcode = $buf;
+ $pdfcode = $this->Output('','S');
$pdfcode = str_replace("\n", "\n
", htmlspecialchars($pdfcode));
echo '