X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=reporting%2Fincludes%2Fpdf_report.inc;h=944b4c28509d38ba5078e93ddbbd7a26e6d57d13;hb=074f5b55ae369597c70953bc7f9324cc491a6a7e;hp=f09ab57fcd3d81d3d5ab45b1b10cff6645a4540d;hpb=a7644a40245495d37dd13871b14e593f3c5e21ae;p=fa-stable.git diff --git a/reporting/includes/pdf_report.inc b/reporting/includes/pdf_report.inc index f09ab57f..944b4c28 100644 --- a/reporting/includes/pdf_report.inc +++ b/reporting/includes/pdf_report.inc @@ -1,10 +1,20 @@ . +***********************************************************************/ //include_once($path_to_root . "reporting/includes/class.pdf.inc"); include_once(dirname(__FILE__)."/class.pdf.inc"); -include_once($path_to_root . "admin/db/company_db.inc"); -include_once($path_to_root . "config.php"); +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; @@ -40,9 +50,16 @@ class FrontReport extends Cpdf function FrontReport($title, $filename, $size = 'A4', $fontsize = 9) { + 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; @@ -112,7 +129,7 @@ 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; @@ -138,7 +155,7 @@ class FrontReport extends Cpdf 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); @@ -152,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; @@ -193,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); @@ -248,22 +266,22 @@ class FrontReport extends Cpdf function Header2($myrow, $branch, $sales_order, $bankaccount, $doctype) { - global $comp_path, $path_to_root, $print_as_quote, $print_invoice_no; + 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']) + if (isset($myrow['curr_code']) && $this->currency != $myrow['curr_code']) { - include($path_to_root . "reporting/includes/doctext2.inc"); + include($path_to_root . "/reporting/includes/doctext2.inc"); } else { - include($path_to_root . "reporting/includes/doctext.inc"); + include($path_to_root . "/reporting/includes/doctext.inc"); } - include($path_to_root . "reporting/includes/header2.inc"); + include($path_to_root . "/reporting/includes/header2.inc"); $this->row = $temp; } @@ -308,6 +326,18 @@ 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) { @@ -329,7 +359,7 @@ class FrontReport extends Cpdf do { $l = $this->TextWrap($c, $this->row , $width, $l, $align); - $this->NewLine(); + $this->row -= $this->lineHeight; } while ($l != ''); } @@ -349,19 +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, $comp_path; + global $pdf_debug, $path_to_root, $comp_path; - if ($go_debug == 1) + if ($pdf_debug == 1) { - $buf = $this->Output(); - $len = strlen($buf); - $pdfcode = $buf; + $pdfcode = $this->Output('','S'); $pdfcode = str_replace("\n", "\n
", htmlspecialchars($pdfcode)); echo ''; echo trim($pdfcode); @@ -376,18 +404,20 @@ class FrontReport extends Cpdf } else { - $buf = $this->Output(); - $len = strlen($buf); + $dir = $comp_path.'/'.user_company(). '/pdf_files'; //save the file if (!file_exists($dir)) { mkdir ($dir,0777); } - $fname = $dir . '/' . $this->filename; - $fp = fopen($fname,'w'); - fwrite($fp,$buf); - fclose($fp); + // do not use standard filenames or your sensitive company data + // are world readable + if ($email == 1) + $fname = $dir.'/'.$this->filename; + else + $fname = $dir.'/'.uniqid('').'.pdf'; + $this->Output($fname, 'F'); if ($email == 1) { $emailtype = true; @@ -399,13 +429,14 @@ class FrontReport extends Cpdf { include("doctext.inc"); } - require_once($path_to_root . "reporting/includes/class.mail.inc"); + require_once($path_to_root . "/reporting/includes/class.mail.inc"); $mail = new email($this->company['coy_name'], $this->company['email']); - $from = $this->company['coy_name'] . " <" . $this->company['email'] . ">"; + if (!isset($myrow['email']) || $myrow['email'] == '') + $myrow['email'] = isset($myrow['contact_email']) ? $myrow['contact_email'] : ''; $to = $myrow['DebtorName'] . " <" . $myrow['email'] . ">"; - $msg = $doc_Dear_Sirs . ",\n\n" . $doc_AttachedFile . " " . $subject . + $msg = $doc_Dear_Sirs . " " . $myrow['DebtorName'] . ",\n\n" . $doc_AttachedFile . " " . $subject . "\n\n"; - if ($myrow['dimension_id'] > 0 && $doctype == 10) // helper for payment links + if (isset($myrow['dimension_id']) && $myrow['dimension_id'] > 0 && $doctype == 10) // helper for payment links { if ($myrow['dimension_id'] == 1) { @@ -418,66 +449,73 @@ class FrontReport extends Cpdf } } $msg .= $doc_Kindest_regards . "\n\n"; - $sender = $this->user . "\n" . $this->company['coy_name']; + $sender = $this->user . "\n" . $this->company['coy_name'] . "\n" . $this->company['postal_address'] . "\n" . $this->company['email'] . "\n" . $this->company['phone']; $mail->to($to); $mail->subject($subject); $mail->text($msg . $sender); $mail->attachment($fname); $ret = $mail->send(); - if (1 == 1) // just for fun and for debugging purposes!! - { - $from = str_replace("<", "(", $from); - $from = str_replace(">", ")", $from); - $to = str_replace("<", "(", $to); - $to = str_replace(">", ")", $to); - $msg2 = "
From: " . $from; - $msg2 .= "
To: " . $to; - $msg2 .= "
Subject: " . $subject; - $msg2 .= "
Msg: " . nl2br($msg); - $msg2 .= nl2br($sender) . "
"; - $msg2 .= "
Filepath: " . $fname . "
Filename: " . $this->filename . "
"; - } - if ($ret) - $str = "
" . $this->title . " " . $myrow['reference'] . " " . _("sent to") . " "; - else - $str = "
" . $this->title . " " . $myrow['reference'] . " " . _("NOT sent to") . " "; - $msg2 .= $str . $myrow['DebtorName'] . " - " . $myrow['email']; - echo ""; - echo $msg2; - echo ""; + if (!$ret) + display_error(_("Sending document by email failed")); + else + display_notification($this->title . " " . $myrow['reference'] . " " + . _("has been sent by email.")); + unlink($fname); } else { - //echo ' - // - // - // - // - // click here if you are not re-directed. - // - // '; - header('Content-type: application/pdf'); - header("Content-Disposition: inline; filename=$this->filename"); - header('Expires: 0'); - header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); - header('Pragma: public'); - $this->Stream(); - + $printer = get_report_printer(user_print_profile(), $_POST['REP_ID']); + if ($printer == false) { + if(in_ajax()) { + global $Ajax; + + if (user_rep_popup()) + $Ajax->popup($fname); // when embeded pdf viewer used + else + $Ajax->redirect($fname); // otherwise use faster method + } else { + //echo ' + // + // + // + // + // click here if you are not re-directed. + // + // '; + header('Content-type: application/pdf'); + header("Content-Disposition: inline; filename=$this->filename"); + header('Expires: 0'); + header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); + header('Pragma: public'); + + $this->Stream(); + } + } else { // send report to network printer + $prn = new remote_printer($printer['queue'],$printer['host'], + $printer['port'], $printer['timeout']); + $error = $prn->print_file($fname); + if ($error) + display_error($error); + else + display_notification(_('Report has been sent to network printer ').$printer['name']); + } } - // also have a look through the directory, and remove the files that are older than a week - // rather want to save 'em - /*if ($d = @opendir($dir)) { + // first have a look through the directory, + // and remove old temporary pdfs + if ($d = @opendir($dir)) { while (($file = readdir($d)) !== false) { - // then check to see if this one is too old + if (!is_file($dir.'/'.$file) || $file == 'index.php') continue; + // then check to see if this one is too old $ftime = filemtime($dir.'/'.$file); - if (time()-$ftime > 3600*24*7){ + // seems 3 min is enough for any report download, isn't it? + if (time()-$ftime > 180){ unlink($dir.'/'.$file); } } closedir($d); - }*/ + } } } }