webadmin.php

/var/www/hkosl.com/oneMotorChunHing_delete20240201/html/quotationprint_20101006.php

<?
require("inc/configure.php");
require("inc/global.php");
require("inc/checklogin.php");
?>
<?php
$quotationno = $_GET['quotationno'];

$sql = "SELECT
        a.quotationno, a.custid, a.custno
        , a.custnameeng, a.telno, a.faxno
        , a.email, b.username, a.orderdate
        , a.billaddress, a.discount, paymentmethod
        , paymentterm, sum(c.amount)-a.discount as totalamount
        , a.status, a.attn
        , licno, modelno, chassisno, caryear
        from OM_QUOTATION_HDR a
        , SYS_USER b
        , OM_QUOTATION_DTL c
        , SYS_PAYMENTMETHOD d
        , SYS_PAYMENTTERM e
        where a.salesid = b.userid
        and a.quotationno = c.quotationno
        and a.quotationno = $quotationno
        and a.paymentmethodid = d.paymentmethodid
        and a.paymenttermid = e.paymenttermid
        and salesman = 1
        group by 
        a.quotationno, a.custid, a.custno
        , a.custnameeng, a.telno, a.faxno
        , a.orderdate, b.username, a.discount
        , paymentmethod, paymentterm, a.status
        , a.attn";

$result = mysql_query($sql);
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $custno                = $row{'custno'};
    $catid                = $row{'catid'};
    $custnameeng        = $row{'custnameeng'};
    $telno                = $row{'telno'};
    $faxno                = $row{'faxno'};
    $email                = $row{'email'};
    $salesman            = $row{'username'};
    $orderdate            = $row{'orderdate'};
    $totalamount        = $row{'totalamount'};
    $billaddress        = $row{'billaddress'};
    $attn                = $row{'attn'};

    $paymentmethodid    = $row{'paymentmethodid'};
    $paymenttermid        = $row{'paymenttermid'};

    $headerdiscount            = $row{'discount'};
    $deliverymethod        = $row{'deliverymethod'};
    $status                = $row{'status'};

    $paymentmethod        = $row{'paymentmethod'};
    $paymentterm        = $row{'paymentterm'};

    $licno                = $row{'licno'};
    $modelno            = $row{'modelno'};
    $chassisno            = $row{'chassisno'};
    $caryear            = $row{'caryear'};
}

// don't want any warnings turning up in the pdf code if the server is set to 'anal' mode.
//error_reporting(7);
error_reporting(E_ALL);
set_time_limit(1800);

include 'pdf/class.ezpdf.php';

// define a clas extension to allow the use of a callback to get the table of contents, and to put the dots in the toc
class Creport extends Cezpdf {

    var $reportContents = array();

    function Creport($p,$o){
      $this->Cezpdf($p,$o);
    }

    function rf($info){
      // this callback records all of the table of contents entries, it also places a destination marker there
      // so that it can be linked too
      $tmp = $info['p'];
      $lvl = $tmp[0];
      $lbl = rawurldecode(substr($tmp,1));
      $num=$this->ezWhatPageNumber($this->ezGetCurrentPageNumber());
      $this->reportContents[] = array($lbl,$num,$lvl );
      $this->addDestination('toc'.(count($this->reportContents)-1),'FitH',$info['y']+$info['height']);
    }

    function dots($info){
      // draw a dotted line over to the right and put on a page number
      $tmp = $info['p'];
      $lvl = $tmp[0];
      $lbl = substr($tmp,1);
      $xpos = 520;

      switch($lvl){
        case '1':
          $size=16;
          $thick=1;
          break;
        case '2':
          $size=12;
          $thick=0.5;
          break;
      }

      $this->saveState();
      $this->setLineStyle($thick,'round','',array(0,10));
      $this->line($xpos,$info['y'],$info['x']+5,$info['y']);
      $this->restoreState();
      $this->addText($xpos+5,$info['y'],$size,$lbl);
    }


}
// I am in NZ, so will design my page for A4 paper.. but don't get me started on that.
// (defaults to legal)
// this code has been modified to use ezpdf.

//$pdf = new Cezpdf('a4','portrait');
$pdf = new Creport('a4','portrait');
$pdf -> ezSetMargins(30,30,30,30);



//$mainFont = './fonts/Helvetica.afm';
$mainFont = 'pdf/fonts/Times-Roman.afm';
$codeFont = 'pdf/fonts/Courier.afm';
// select a font

$pdf->selectFont($mainFont);

$pdf->openHere('Fit');

//if (file_exists('images/logo01.jpg')){
//  $pdf->addJpegFromFile('images/logo01.jpg',20,$pdf->y-20,100,0);
//} else {
  // comment out these two lines if you do not have GD jpeg support
  // I couldn't quickly see a way to test for this support from the code.
  // you could also copy the file from the locatioin shown and put it in the directory, then 
  // the code above which doesn't use GD will be activated.
//  $img = ImageCreatefromjpeg('http://www.onesolution.com.hk/oneERP/images/logo01.jpg');
//  $pdf-> addImage($img,20,$pdf->y-30,180,0);
//}

require("bctest.php");

$pdf->ezSetDy(-20);

//$img = ImageCreatefromjpeg('http://www.onesolution.com.hk/oneERP/images/logo01.jpg');
//$pdf-> addImage($img,20,$pdf->y-30,180,0);

//$img = ImageCreatefromjpeg('http://www.onesolution.com.hk/oneMotor/barcode/'.$quotationno.'.jpg');
//$pdf-> addImage($img,480,$pdf->y-5,70,0);

//** header
$data = array(
array('col1'=>'Bill To:','col2'=>$custnameeng,'col3'=>'Quotation no.:','col4'=>$quotationno)
,array('col1'=>'Address','col2'=>$billaddress,'col3'=>'Date:','col4'=>$orderdate)
,array('col1'=>'','col2'=>'','col3'=>'From:','col4'=>$salesman)
,array('col1'=>'','col2'=>'','col3'=>'Tel:','col4'=>'')
,array('col1'=>'','col2'=>'','col3'=>'Fax:','col4'=>'')
,array('col1'=>'Attn:','col2'=>$attn,'col3'=>'Email:','col4'=>'')
,array('col1'=>'Tel:','col2'=>$telno,'col3'=>'Payment Terms:','col4'=>$paymentterm)
,array('col1'=>'Email:','col2'=>$email,'col3'=>'Payment Method:','col4'=>$paymentmethod)
,array('col1'=>'Lic no:','col2'=>$licno,'col3'=>'Model no:','col4'=>$modelno)
,array('col1'=>'Chassis no:','col2'=>$chassisno,'col3'=>'Year:','col4'=>$caryear)
);
$pdf->ezTable($data,$cols,'',
array('xPos'=>'center','xOrientation'=>'center','showLines'=>0,'shaded'=>0,'showHeadings'=>0,'width'=>700
,'cols'=>array(
'col1'=>array('justification'=>'right','width'=>120)
,'col2'=>array('width'=>230)
,'col3'=>array('justification'=>'right','width'=>120)
,'col4'=>array('width'=>230))
));


$pdf->ezText("Quotation\n",20,array('justification'=>'centre'));

//** detail
$sql = "select * from OM_QUOTATION_DTL
        where quotationno = $quotationno 
        order by lineno";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $lineno            = $row{'lineno'};
    $prodid            = $row{'prodid'};
    $barcode        = $row{'barcode'};
    $prodname        = $row{'prodname'};
    $qty            = $row{'qty'};
    $uom            = $row{'uom'};
    $price            = $row{'price'};
    $discount        = $row{'discount'};
    $amount            = $row{'amount'};
    $cost            = $row{'cost'};
    $description    = $row{'description'};
    $data1[] = array('subcol1'=>$lineno,'subcol2'=>$prodid,'subcol3'=>$barcode,'subcol4'=>$prodname,'subcol5'=>$qty,'subcol6'=>$uom,'subcol7'=>$price,'subcol8'=>$discount,'subcol9'=>$amount);
    $subamount += $amount;
}

$subcols = array('subcol1'=>"No.",'subcol2'=>'Product code','subcol3'=>'Barcode','subcol4'=>'Product name','subcol5'=>'Qty','subcol6'=>'UOM','subcol7'=>'Unit price','subcol8'=>'Discount','subcol9'=>'Amount');
$pdf->ezTable($data1,$subcols,'',
array('xPos'=>'center','xOrientation'=>'center','showLines'=>1,'shaded'=>1,'showHeadings'=>1,'width'=>550
,'cols'=>array(
    'subcol1'=>array('justification'=>'right','width'=>40)
    ,'subcol2'=>array('width'=>50)
    ,'subcol3'=>array('width'=>60)
    ,'subcol4'=>array('width'=>160)
    ,'subcol5'=>array('justification'=>'right','width'=>50)
    ,'subcol6'=>array('width'=>40)
    ,'subcol7'=>array('justification'=>'right','width'=>50)
    ,'subcol8'=>array('justification'=>'right','width'=>50)
    ,'subcol9'=>array('justification'=>'right','width'=>50))
));

//** total
$datatotal = array(
array('subcol1'=>'Amount:','subcol2'=>number_format($subamount,2))
,array('subcol1'=>'Discount:','subcol2'=>number_format($headerdiscount,2))
,array('subcol1'=>'Grand Total:','subcol2'=>number_format($subamount-$headerdiscount,2)));
$totalcols = array('subcol1'=>"empty",'subcol2'=>'total');
$pdf->ezTable($datatotal,$totalcols,'',
array('xPos'=>'center','xOrientation'=>'center','showLines'=>0,'shaded'=>0,'showHeadings'=>0,'width'=>550
,'cols'=>array(
    'subcol1'=>array('justification'=>'right','width'=>500)
    ,'subcol2'=>array('justification'=>'right','width'=>50))
));


if (isset($d) && $d){
  $pdfcode = $pdf->ezOutput(1);
  $pdfcode = str_replace("\n","\n<br>",htmlspecialchars($pdfcode));
  echo '<html><head><title>Quotation</title><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>';
  echo trim($pdfcode);
  echo '</body></html>';
} else {
  $pdf->ezStream();
}
?>