webadmin.php

/var/www/enzatesting.onesolution.hk/pdf_ord_disd_jobcard.php

<?php
// define('TCPDF_TRACE', 1);

$formid = "Order";
require_once "inc/configure.php";

/*if(havePermission("GNr")==false
|| havePermission("BMr")==false
|| havePermission("RTr")==false
//|| havePermission("MDr")==false
//|| havePermission("TDr")==false
){
    
    myerror("Invalid Permission");    
}*/

require_once "inc/pdf/tcpdf.php";
require_once "inc/fatalHandler.php";

set_time_limit ( 120 );

function getmoldremark($mold_refid){
    global $dbh;
    $sql = "SELECT
            dbo.dgn_master_mold.remark_mold            
            FROM
            dbo.dgn_master_mold
            WHERE
            dbo.dgn_master_mold.refid = :mold_refid";        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':mold_refid'=>$mold_refid)  );
/*    echo $sth->getSQL(   );*/
    $mold = $sth->fetch();
    return $mold['remark_mold'];    
}

function env_metal($refid){
    global $dbh;
    $sql = "SELECT inv_material.itemno,
            inv_material.name_en,
            inv_material.name_sc,
            ord_item_bom.qty,
            ord_item_bom.uom_qty 
            FROM
            ord_item_bom
            INNER JOIN inv_material ON inv_material.refid = ord_item_bom.itemnoid
            where orddtl_refid=:refid and bomcategy=:bomcategy
            order by ord_item_bom.qty DESC";        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':refid'=>$refid,
                            ':bomcategy'=>"material")  );
/*    echo $sth->getSQL( array(':mold_refid'=>$row['refid'],
                            ':bomcategy'=>"material")  );*/
    $mat = $sth->fetch();
    return $mat['itemno'];    
}

function getSETOofStone($orddtl_refid, $itemno, $qty){
    global $dbh;
    $sql = "SELECT
            dbo.ord_subroute.opr_code,
            dbo.master_operation.codedesc_en,
            dbo.master_operation.codedesc_sc
            FROM
            dbo.ord_route
            INNER JOIN dbo.ord_subroute ON dbo.ord_subroute.ordroute_refid = dbo.ord_route.refid
            INNER JOIN dbo.master_operation ON dbo.ord_subroute.opr_code = dbo.master_operation.code
            WHERE
            dbo.ord_route.opr_code = 'SETO' AND
            dbo.ord_subroute.orddtl_refid = :orddtl_refid AND
            dbo.ord_subroute.itemno = :itemno AND
            dbo.ord_subroute.opr_svc = :qty" ;        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':orddtl_refid'=>$orddtl_refid,
                            ':itemno'=>$itemno,
                            ':qty'=>$qty)  );
    /*echo $sth->getSQL( array(':orddtl_refid'=>$orddtl_refid,
                            ':itemno'=>$itemno,
                            ':qty'=>$qty)  ).HTML_EOL;*/
    //$r2 = $sth->fetchAll();
    $r = $sth->fetch();
    //vdump($r['opr_code']);
    return $r;
}

function bom_table($dtl_refid){
    global $dbh;
    $result=array();

    $sql = "SELECT
            dbo.ord_dtl.refid,
            dbo.ord_item_bom.refid,
            dbo.ord_item_bom.bomcategy,
            dbo.ord_item_bom.qty,
            dbo.ord_item_bom.uom_qty,
            dbo.inv_diamond.itemno,
            dbo.inv_diamond.name_en,
            dbo.inv_diamond.name_sc,
            dbo.inv_diamond.stonetype,
            dbo.inv_diamond.stoneqlty,
            dbo.inv_diamond.stonecolor,
            dbo.inv_diamond.stoneshape,
            dbo.inv_diamond.stonesize,
            dbo.inv_diamond.stonesize2
            FROM
            dbo.ord_dtl
            INNER JOIN dbo.ord_item_bom ON dbo.ord_item_bom.orddtl_refid = dbo.ord_dtl.refid
            INNER JOIN dbo.inv_diamond ON dbo.ord_item_bom.itemnoid = dbo.inv_diamond.refid
            WHERE
            dbo.ord_dtl.refid = :orddtl_refid AND
            dbo.ord_item_bom.bomcategy = 'diamond'
            ";        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':orddtl_refid'=>$dtl_refid)  );
    //echo $sth->getSQL( array(':orddtl_refid'=>$dtl_refid, ':orddtlrefid'=>$dtl_refid)  ).HTML_EOL;
    //$r2 = $sth->fetchAll();
    while ($r = $sth->fetch()){        
        $opr = getSETOofStone($dtl_refid, $r['itemno'], $r['qty']);
        $r['opr_code'] = $opr['opr_code'];
        $r['codedesc_en'] = $opr['codedesc_en'];
        $r['codedesc_sc'] = $opr['codedesc_sc'];
        $result[]=$r;    
    }


    $sql = "SELECT
            dbo.ord_dtl.refid,
            dbo.ord_item_bom.refid,
            dbo.ord_item_bom.bomcategy,
            dbo.ord_item_bom.qty,
            dbo.ord_item_bom.uom_qty,
            dbo.inv_stone.itemno,
            dbo.inv_stone.name_en,
            dbo.inv_stone.name_sc,
            dbo.inv_stone.stonetype,
            dbo.inv_stone.stoneqlty,
            dbo.inv_stone.stonecolor,
            dbo.inv_stone.stoneshape,
            dbo.inv_stone.stonesize,
            dbo.inv_stone.stonesize2
            FROM
            dbo.ord_dtl
            INNER JOIN dbo.ord_item_bom ON dbo.ord_item_bom.orddtl_refid = dbo.ord_dtl.refid
            INNER JOIN dbo.inv_stone ON dbo.ord_item_bom.itemnoid = dbo.inv_stone.refid
            WHERE
            dbo.ord_dtl.refid = :orddtl_refid AND
            dbo.ord_item_bom.bomcategy = 'stone'
            ";        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':orddtl_refid'=>$dtl_refid)  );
    //echo $sth->getSQL( array(':dtl_refid'=>$mold_refid)  );
    while ($r = $sth->fetch()){
        $opr = getSETOofStone($dtl_refid, $r['itemno'], $r['qty']);
        $r['opr_code'] = $opr['opr_code'];
        $r['codedesc_en'] = $opr['codedesc_en'];
        $r['codedesc_sc'] = $opr['codedesc_sc'];
        $result[]=$r;    
    }

    $sql = "SELECT
            dbo.ord_item_bom.bomcategy,
            dbo.ord_item_bom.qty,
            dbo.ord_item_bom.uom_qty,
            dbo.inv_accessory.itemno,
            dbo.inv_accessory.name_en,
            dbo.inv_accessory.name_sc
            
            FROM
            dbo.ord_dtl
            INNER JOIN dbo.ord_item_bom ON dbo.ord_item_bom.orddtl_refid = dbo.ord_dtl.refid
            INNER JOIN dbo.inv_accessory ON dbo.ord_item_bom.itemnoid = dbo.inv_accessory.refid
            WHERE
            dbo.ord_item_bom.bomcategy = 'accessory' AND
            dbo.ord_dtl.refid = :orddtl_refid";        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':orddtl_refid'=>$dtl_refid)  );
    //echo $sth->getSQL( array(':dtl_refid'=>$mold_refid)  );
    $r2 = $sth->fetchAll();
    
    $result = array_merge($result, $r2);
    
    $sql = "SELECT
            dbo.ord_item_bom.bomcategy,
            dbo.ord_item_bom.qty,
            dbo.ord_item_bom.uom_qty,
            dbo.inv_material.itemno,
            dbo.inv_material.name_en,
            dbo.inv_material.name_sc
            
            FROM
            dbo.ord_dtl
            INNER JOIN dbo.ord_item_bom ON dbo.ord_item_bom.orddtl_refid = dbo.ord_dtl.refid
            INNER JOIN dbo.inv_material ON dbo.ord_item_bom.itemnoid = dbo.inv_material.refid
            
            WHERE
            dbo.ord_item_bom.bomcategy = 'material' AND
            dbo.ord_dtl.refid = :orddtl_refid";            
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':orddtl_refid'=>$dtl_refid)  );
    //echo $sth->getSQL( array(':dtl_refid'=>$mold_refid)  );
    $r2 = $sth->fetchAll();
    
    $result = array_merge($result, $r2);    
        
    return $result;    
}

function route_table($dtl_refid){
    global $dbh;
    $result = array();
    
    $sql = "SELECT
    ord_route.*, 
    dbo.master_operation.codedesc_en,
    dbo.master_operation.codedesc_sc
    FROM
    ord_route
    INNER JOIN dbo.master_operation ON dbo.master_operation.code = dbo.ord_route.opr_code
    WHERE
    ord_route.orddtl_refid = :dtl_refid
    ORDER BY
    opr_nbr ASC";        
    $sth = $dbh->prepare($sql);

    $sth->execute( array(':dtl_refid'=>$dtl_refid)  );
    //echo $sth->getSQL(  );
    while($row = $sth->fetch() ){
        $result[] = $row;
        subroute($result, $row['refid']);
    }
    
    
    //vdump($result);
    return $result;
    
}

function subroute(&$result, $parent_refid){
    global $dbh;
    $sql = "SELECT
    ord_subroute.*, 
    dbo.master_operation.codedesc_en,
    dbo.master_operation.codedesc_sc
    FROM
    ord_subroute
    INNER JOIN dbo.master_operation ON dbo.master_operation.code = dbo.ord_subroute.opr_code
    WHERE
    ord_subroute.ordroute_refid = :route_refid
    ORDER BY
    opr_nbr ASC";        
    $sth = $dbh->prepare($sql);

    $sth->execute( array(':route_refid'=>$parent_refid)  );
    //echo $sth->getSQL( array(':dtl_refid'=>$dtl_refid, ':route_refid'=>$parent_refid)  );
    while($row = $sth->fetch() ){
        $result[] = $row;
        subsubroute($result, $row['refid']);
    }
}

function subsubroute(&$result, $parent_refid){
    global $dbh;
    $sql = "SELECT
    ord_subsubroute.*, 
    dbo.master_operation.codedesc_en,
    dbo.master_operation.codedesc_sc
    FROM
    ord_subsubroute
    INNER JOIN dbo.master_operation ON dbo.master_operation.code = dbo.ord_subsubroute.opr_code
    WHERE
    ord_subsubroute.ordsubroute_refid = :ordsubroute_refid
    ORDER BY
    opr_nbr ASC";        
    $sth = $dbh->prepare($sql);

    $sth->execute( array(':ordsubroute_refid'=>$parent_refid)  );
    while($row = $sth->fetch() ){
        $result[] = $row;
    }    
}

function printRouteHeader($pdf){
    global $routetable_x, $routetable_2x, $routetable_y;
    global $showBorder;
    
    $pdf->MultiCell(560, $row_height, 
    'Route / 流程',
    $showBorder, 'C', 1, 1);
    $pdf->SetFont('stsongstdlight', '', 6);
    $pdf->MultiCell(35, $row_height, 
    'Location',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(80, $row_height, 
    'Operation',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(65, $row_height, 
    'Item',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(50, $row_height, 
    'Qty',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(49, $row_height, 
    'Remark',
    $showBorder, 'C', 1, 0);
    $pdf->SetX( $pdf->GetX()+2 );
    $routetable_2x = $pdf->GetX();
    
    $pdf->MultiCell(35, $row_height, 
    'Location',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(80, $row_height, 
    'Operation',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(65, $row_height, 
    'Item',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(50, $row_height, 
    'Qty',
    $showBorder, 'C', 1, 0);
    $pdf->MultiCell(49, $row_height, 
    'Remark',
    $showBorder, 'C', 1, 1);
    $routetable_x = $pdf->GetX();
    $routetable_y = $pdf->GetY();    
}

function printRoute($pdf, &$r){
    global $row;
    global $routetable_x, $routetable_2x, $routetable_y;
    global $showBorder;
    $row_height=10;
    
    if  ($pdf->getY()>750) {
        //$pdf->Write(10, "change column");
        if ($routetable_x != $routetable_2x) { //change column
            $pdf->setXY($routetable_2x, $routetable_y);
            $routetable_x = $routetable_2x;
        }
        else { //new page
            $pdf->addPage();
            $routetable_x = $pdf->getX();
            printRouteHeader($pdf);            
        }
        $reach_eop = true;
    }
    
    if($r['opr_code']=='RHOO' || $r['opr_code']=='POLR'){
        global $finishing_desc;
        $r['itemno'] = $finishing_desc;
        //echo "rhoo"; exit;
    }
    
    $row_height = max(10, $pdf->getStringHeight(80, $r['opr_code'].' / '.$r['codedesc_sc']) );
    
    $pdf->MultiCell(35, $row_height, 
    $r['workplace_code'],
    $showBorder, 'L', 0, 0);
    $pdf->MultiCell(80, $row_height, 
    $r['opr_code'].' / '.$r['codedesc_sc'],
    $showBorder, 'L', 0, 0);
    $pdf->MultiCell(65, $row_height, 
    $r['itemno'],
    $showBorder, 'L', 0, 0);
    $pdf->MultiCell(50, $row_height, 
    numf($r['opr_svc']*$row['qty']).' '.$r['uom_svc'],
    $showBorder, 'C', 0, 0);
    $pdf->MultiCell(49, $row_height, 
    $r['remark'],
    $showBorder, 'C', 0, 1);
    
    $pdf->setX( $routetable_x );    
    return $reach_eop;
    
}

function td_img($dtl_refid){
    global $dbh;
    $sql = "SELECT
                ord_dtl.refid,
                ord_dtl.drawing_no,
                drawing.drawing_refid,
                td.img_src,
                td.img_path
            FROM
                ord_dtl
            INNER JOIN (
                SELECT
                    MAX (dgn_drawing.refid) AS drawing_refid,
                    dgn_drawing.drawing_no
                FROM
                    dgn_drawing
                GROUP BY
                    dgn_drawing.drawing_no
            ) AS drawing ON drawing.drawing_no = ord_dtl.drawing_no
            INNER JOIN (
                SELECT
                    dgn_techdrawing_img.drawing_refid ,
                    dgn_techdrawing_img.img_src,
                    dgn_techdrawing_img.img_path
                FROM
                    dgn_techdrawing_img
            ) AS td ON drawing.drawing_refid = td.drawing_refid
            WHERE
                ord_dtl.refid = :mold_refid";        
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':mold_refid'=>$mold_refid)  );
    $rows = $sth->fetchAll();
    
    $s = '<table>';
    foreach($rows as $row ) {
        //vdump($row);
        if( !empty($row['img_src']) ) {
            $s .= '<tr>';
            $s .= '<td><img src="'.$row['img_path'];//.'thumb/';
            $s .= $row['img_src'].'"  /></td>';
            $s .= '</tr>';
        }
    }
    $s .= '<tr><td>&nbsp;</td></tr></table>';
    
    return $s;    
}


function print_jc($pdf, $orddtl_refid){
    // vdump($orddtl_refid);
    // return;
    global $dbh;
    global $row; 
    global $row_height, $height_2row, $showBorder, $tableBorder;
    global $routetable_x, $routetable_2x, $routetable_y;
    global $x_main, $y_main;

    try{
        $sql = "SELECT
                dbo.ord_dtl.refid,
                dbo.ord_dtl.product_refid,
                dbo.ord_dtl.itemno,
                dbo.ord_dtl.qty,
                dbo.ord_dtl.isrepairorder,
                dbo.inv_product.refid as prod_refid,
                dbo.inv_product.itemno,
                dbo.inv_product.itemname,
                dbo.inv_product.name_en,
                dbo.inv_product.name_sc,
                dbo.inv_product.mold_refid,
                dbo.inv_product.remark as prod_remark,
                dbo.inv_product.finishing,
                dbo.master_customer.companyname_en,
                dbo.master_customer.companyname_sc,
                dbo.master_customer.custname_en,
                dbo.master_customer.custname_sc,
                dbo.ord_main.order_nbr,
                dbo.ord_main.launch_date,
                dbo.ord_main.del_date,
                dbo.ord_main.confirm_date,
                dbo.ord_main.remark as ord_remark,
                dbo.ord_main.custorder_ref,
                dbo.ord_dtl.[size],
                dbo.ord_dtl.remark,
                dbo.master_type_code.codedesc_en,
                dbo.master_type_code.codedesc_sc
                
                
                FROM
                dbo.ord_dtl
                INNER JOIN dbo.inv_product ON dbo.ord_dtl.product_refid = dbo.inv_product.refid
                INNER JOIN dbo.ord_main ON dbo.ord_dtl.main_refid = dbo.ord_main.refid
                INNER JOIN dbo.master_customer ON dbo.ord_main.custcode = dbo.master_customer.custcode
                INNER JOIN dbo.master_type_code ON dbo.inv_product.producttype = dbo.master_type_code.codeid
                WHERE
                dbo.master_type_code.typeid = 'PRODTYPE' AND
                dbo.ord_dtl.refid = :refid
                ";
        $sth = $dbh->prepare($sql);
        $sth->execute(  array(':refid' => $orddtl_refid) );
        //echo $sth->getSQL(  array(':refid' => $refid) );    
        $row = $sth->fetch();
if(defined('TCPDF_TRACE')) vdump('addpage', $y_main);

        $pdf->startPageGroup();
        $pdf->AddPage();
        // $pdf->SetY( $y_main+10 );

        $pdf->MultiCell(120, $row_height, 
        'Final Customer'.PHP_EOL.
        '最终客户 ',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(100, $row_height, 
        'Order Number'.PHP_EOL.
        '订单号码',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(100, $row_height, 
        'Launching Date'.PHP_EOL.
        '开银版单日期',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(120, $row_height, 
        'Expecting Date'.PHP_EOL.
        '预料日期',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(120, $row_height, 
        'Confirmed Date'.PHP_EOL.
        '确认日期',
        $showBorder, 'C', 1, 1);

        $pdf->MultiCell(120, $row_height, 
        $row['custname_en'],
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(100, $row_height, 
        $row['order_nbr'],
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(100, $row_height, 
        datef($row['launch_date']),
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(120, $row_height, 
        datef($row['del_date']),
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(120, $row_height, 
        datef($row['confirm_date']),
        $showBorder, 'C', 0, 1);
        $pdf->SetY( $pdf->GetY()+5 );

        $pdf->MultiCell(120, $row_height, 
        'Customer Reference'.PHP_EOL.
        '客户订单参考',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(100, $row_height, 
        'Product Name'.PHP_EOL.
        '名称',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(340, $row_height, 
        'Order Remark'.PHP_EOL.
        '订单备注',
        $showBorder, 'C', 1, 1);

        $pdf->MultiCell(120, $row_height, 
        $row['custorder_ref'],
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(100, $row_height, 
        $row['itemname'],
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(340, $row_height, 
        $row['ord_remark'],
        $showBorder, 'L', 0, 1);
        $pdf->SetY( $pdf->GetY()+5 );

        $pdf->MultiCell(100, $row_height, 
        'Product Type'.PHP_EOL.
        '产品类型',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(100, $row_height, 
        'Product Number'.PHP_EOL.
        '产品编号',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(60, $row_height, 
        'Finger Size'.PHP_EOL.
        '手指大小',
        $showBorder, 'C', 1, 0);

        $pdf->MultiCell(60, $row_height, 
        'Quantity'.PHP_EOL.
        '数量',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(120, $row_height, 
        'Stamping / Engraving'.PHP_EOL.
        '冲压 / 雕刻',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(120, $row_height, 
        'Metal'.PHP_EOL.
        '金属',
        $showBorder, 'C', 1, 1);

        $pdf->MultiCell(100, $row_height, 
        $row['codedesc_en']." / ".$row['codedesc_sc'],
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(100, $row_height, 
        $row['itemno'],
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(60, $row_height, 
        $row['size'],
        $showBorder, 'C', 0, 0);

        $pdf->MultiCell(60, $row_height, 
        numf($row['qty']),
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(120, $row_height, 
        ' ',
        $showBorder, 'C', 0, 0);
        $pdf->MultiCell(120, $row_height, 
        env_metal($row['refid']),
        $showBorder, 'C', 0, 1);

        $pdf->SetY( $pdf->GetY()+5 );

        $pdf->MultiCell(220, $row_height, 'Product Remark / 产品备注', $showBorder, 'C', 1, 0);
        $pdf->MultiCell(220, $row_height, 'Remark / 备注', $showBorder, 'C', 1, 0);
        $pdf->MultiCell(120, $row_height, 'Finishing / 涂装', $showBorder, 'C', 1, 1);

        $tmp_left = $row['prod_remark'];

        /*$mold_remark=getmoldremark($row['mold_refid']);
        if( !empty($mold_remark) ){
            $tmp_left .=  PHP_EOL . $mold_remark;    
        }
        */
        $tmp_right = $row['remark'];
        $tmp_fin = resolveCode_master_type_code("FINISHING", $row['finishing'], false, "en")." / ".resolveCode_master_type_code("FINISHING", $row['finishing'], false, "sc");
        $finishing_desc = $row['finishing']." - ".resolveCode_master_type_code("FINISHING", $row['finishing'], false, "sc");

        $tmp_h = max( $pdf->getStringHeight(220, $tmp_left), $pdf->getStringHeight(220, $tmp_right), $pdf->getStringHeight(120, $tmp_fin) );
        $pdf->MultiCell(220, $tmp_h, $tmp_left, $showBorder, 'L', 0, 0);
        $pdf->MultiCell(220, $tmp_h, $tmp_right, $showBorder, 'L', 0, 0);
        $pdf->MultiCell(120, $tmp_h, $tmp_fin, $showBorder, 'L', 0, 1);
        $pdf->SetY( $pdf->GetY()+5 );

        $pdf->MultiCell(560, $row_height, 
        'Raw Material / 原料',
        $showBorder, 'C', 1, 1);

        $pdf->MultiCell(40, $row_height, 
        'Category'.PHP_EOL.
        '类别',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(80, $row_height, 
        'Item Number'.PHP_EOL.
        '项目编号',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(140, $row_height, 
        'Description'.PHP_EOL.
        '描述',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(60, $row_height, 
        'Qty'.PHP_EOL.
        '数量',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(110, $row_height, 
        'Setting'.PHP_EOL.
        '设置',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(40, $row_height, 
        'Time'.PHP_EOL.
        '时间',
        $showBorder, 'C', 1, 0);
        $pdf->MultiCell(90, $row_height, 
        'Remark'.PHP_EOL.
        '备注',
        $showBorder, 'C', 1, 1);

        $rows = bom_table($row['refid']);
        foreach($rows as $r){
            $pdf->MultiCell(40, $row_height, 
            $r['bomcategy'],
            $showBorder, 'C', 0, 0);
            $pdf->MultiCell(80, $row_height, 
            $r['itemno'],
            $showBorder, 'C', 0, 0);
            $pdf->MultiCell(140, $row_height, 
            $r['name_sc'],
            $showBorder, 'L', 0, 0);
            $pdf->MultiCell(60, $row_height, 
            numf($r['qty']*$row['qty']).' '.$r['uom_qty'],
            $showBorder, 'C', 0, 0);
            $pdf->MultiCell(110, $row_height, 
            $r['opr_code'].'-'.$r['codedesc_sc'],
            $showBorder, 'C', 0, 0);
            $pdf->MultiCell(40, $row_height, 
            ' ',
            $showBorder, 'C', 0, 0);
            $pdf->MultiCell(90, $row_height, 
            ' ',
            $showBorder, 'C', 0, 1);
        }
        $pdf->SetY( $pdf->GetY()+5 );



        printRouteHeader($pdf);
        $rows = route_table($row['refid']);

        $pdf->startTransaction();
        $drawRouteTableWithOldMethod = false;
        //equally divide route to 2 columns
        for($i=0; $i<count($rows); $i++){
            //echo"$i<br/>";
            if($i==ceil(count($rows)/2)){
                 //change column
                $pdf->setXY($routetable_2x, $routetable_y);
                $routetable_x = $routetable_2x;    
            }
            $reach_eop = printRoute($pdf, $rows[$i]);
            if($reach_eop){
                //not enough space => use old method
                $pdf->rollbackTransaction(true);
                $drawRouteTableWithOldMethod = true;
                break;
            }
        }
        $pdf->commitTransaction();

        $routetable_x = $x_main;
        if($drawRouteTableWithOldMethod){
            //fill left column first
            //echo"do old<br/>";
            foreach($rows as $r){
                printRoute($pdf, $r);
            }    
        }

        $pdf->Ln();
        $pdf->SetY( $pdf->GetY()+5 );
        $pdf->SetFont('stsongstdlight', '', 8);

        //------------------------product image 10x7cm --------
        //7 cm = 198.425197 PostScript points
        //5 cm = 283.464567 PostScript points
        $tempy = $pdf->GetY()+5;

        $product_img = getProductImg($row['prod_refid']);
        //vdump($product_img);
        if($product_img && file_exists($product_img['img_path'].$product_img['img_src'])){
            $pdf->Image($product_img['img_path'].$product_img['img_src'], 0, $tempy, 500, '', '', '', 'T', true, '300', 'C', false, false, 0, 'CM');
        }
        //exit; 792, 555

        //------------------------technical drawing disabled--------
        //$td = td_img($refid );

        //$pdf->Ln();
        //$pdf->WriteHTML($td);
        //-------------------------------------------------        
    }catch(Exception $e){
        vdump($e); exit;
    }

}


// start script ------------------------------------------------------------------------------------------------


$row_height = 15;
$height_2row = $row_height * 2;
$showBorder = 1;
$tableBorder = 1;

class doc extends TCPDF{
    public function Header(){
        global $row, $barcode; 
        // $image_file = 'inc/pdf/enza_wm.jpg'; //20220506 去掉logo显示
        // $this->Image($image_file, 30, 30); //20220506 去掉logo显示
        
        // define barcode style
        $style = array(
            'position' => '',
            'align' => 'C',
            'stretch' => false,
            'fitwidth' => true,
            'cellfitalign' => '',
            'border' => true,
            'hpadding' => 'auto',
            'vpadding' => 'auto',
            'fgcolor' => array(0,0,0),
            'bgcolor' => false, //array(255,255,255),
            'text' => true,
            'font' => 'helvetica',
            'fontsize' => 8,
            'stretchtext' => 4
        );
        $barcode = generateJCBarcode($row['refid']);
        $this->write1DBarcode($barcode, 'C128', '460', '40', '200', 40, 0.8, $style, 'N');
if(defined('TCPDF_TRACE')) vdump($barcode);
        $this->SetFont('stsongstdlight', 'B', 10);    // bold
        $this->SetY(40);
        //vdump($row);exit;
        $jobcard_title = empty($row['isrepairorder']) ? 'JOB CARD' : 'JOB CARD (REPAIR 修理)';
        $this->MultiCell(560, 0, 
        $jobcard_title.PHP_EOL.
        PHP_EOL.
        $row['name_en'].PHP_EOL.
        $row['name_sc'],
        0, 'C', 0, 1);
        
        $GLOBALS['x_main']= $this->GetX();
        $GLOBALS['y_main']= $this->GetY();
        //$this->SetY( $this->GetY()+10 );
        $this->SetTopMargin($GLOBALS['y_main']+10);
    }

    // Page footer
    public function Footer(){    
        global $row, $barcode;     
        $this->SetY(-10);
        // Set font
        $this->SetFont('helvetica', 'I', 8);
        // Page number
        // $this->Cell(0, 10, 'Page '.$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
        $this->Cell(0, 10, $barcode . ' - Page '.$this->getPageNumGroupAlias().'/'.$this->getPageGroupAlias(), 0, false, 'C', 0, '', 0, false, 'T', 'M'); //based on page group
        // vdump('Page '.$this->getPageNumGroupAlias().'/'.$this->getPageGroupAlias());
    }
}

// create new PDF document
$pdf = new doc('P', 'pt', 'A4', true, 'UTF-8', false);
// set document information
$pdf->SetCreator('ENZA');
$pdf->SetAuthor('ENZA');
$pdf->SetTitle('ENZA');
$pdf->SetSubject('ENZA');
$pdf->SetKeywords('ENZA');
// set default header data
//$pdf->SetHeaderData(PDF_HEADER_LOGO, PDF_HEADER_LOGO_WIDTH, PDF_HEADER_TITLE.' 008', PDF_HEADER_STRING);
// set header and footer fonts
//$pdf->setHeaderFont(Array(stsongstdlight, '', PDF_FONT_SIZE_MAIN));
//$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//set margins
$pdf->SetMargins(PDF_MARGIN_LEFT, 75, PDF_MARGIN_RIGHT);    // left, top, right
$pdf->SetHeaderMargin(10);
$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
$pdf->SetCellPadding(5);
//set auto page breaks
$pdf->SetAutoPageBreak(TRUE, 50);
//set image scale factor
$pdf->setImageScale(1.3333);
//set some language-dependent strings
$pdf->setLanguageArray($l);
// set font
$pdf->SetFont('stsongstdlight', '', 12);    // bold
// add a page
// $pdf->AddPage();



$pdf->SetFont('stsongstdlight', '', 8);
// set color for background
$pdf->SetFillColor(222, 222, 222);

$refid = setDefaultReqVar("refid", ''); //print single job card
$ordmain_refid = setDefaultReqVar("ordmain_refid", ''); //print all job cards of an order

if($ordmain_refid){
    $sql = "SELECT * FROM ord_dtl WHERE main_refid=:ordmain_refid ORDER BY refid";
    $sth = $dbh->prepare($sql);
    $sth->execute(  array(':ordmain_refid' => $ordmain_refid) );
    //echo $sth->getSQL(  array(':ordmain_refid' => $ordmain_refid) );
    for($i=0; $jc=$sth->fetch(); $i++){
        // if($i!=0){
            // $pdf->AddPage();
            // $pdf->SetY( $y_main+10 );
        // }
        print_jc($pdf, $jc['refid']);
    }
    $filename = "Order_".$ordmain_refid."_JobCard.pdf";
}
elseif($refid){
    // $pdf->AddPage();
    // $pdf->SetY( $y_main+10 );
    print_jc($pdf, $refid);
    $filename = "JobCard_".$refid.".pdf";
}
else{
    exit('Invalid Request');
}

//Close and output PDF document
$pdf->Output($filename, 'I');
//$pdf->Output($filename, 'D');