webadmin.php

/var/www/enzatesting.onesolution.hk/01_20240711_full_backup/ord_setd_deptrpt.php

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

$opr_param['opr_code']    = "SETO";

//default is month start
$_REQUEST['checkin_start'] = setDefaultReqVar("checkin_start", date('Y-m-d') );
//vdump($_REQUEST);

function table_summary(&$ttl, $row){
    if(is_array($row)){
        foreach($row as $f=>$v){
            if( is_numeric($v) ){
                $ttl[ $f ] += $row[ $f ];
            }
        }
    }
}

function seto_getSettingCount($refid, $ordroute_refid){
    //return $ordroute_refid;
    global $dbh;
    
    $sql = "SELECT
            dbo.ord_dtl.qty AS order_qty,
            dbo.ord_route.opr_code as parent_opr_code,
            dbo.master_operation.settingcategy,
            dbo.ord_subroute.*
            FROM
            dbo.ord_dtl
            INNER JOIN dbo.ord_route ON dbo.ord_route.orddtl_refid = dbo.ord_dtl.refid
            INNER JOIN dbo.ord_subroute ON dbo.ord_subroute.ordroute_refid = dbo.ord_route.refid
            INNER JOIN dbo.master_operation ON dbo.master_operation.code = dbo.ord_subroute.opr_code
            WHERE
            dbo.ord_dtl.refid = :refid AND
            dbo.ord_route.opr_code = 'SETO' AND
            dbo.ord_subroute.ordroute_refid = :route_refid";
    $sth = $dbh->prepare($sql);
    $sth->execute( array(':refid' => $refid, ':route_refid' => $ordroute_refid) );
    //echo $sth->getSQL( array(':refid' => $refid, ':route_refid' => $ordroute_refid) );
    while($r = $sth->fetch()){
        //vdump($r['itemno']);
      //find the itemno in different BOM Cat
      $bomcat = getBomcategy($r['itemno']);
      if($bomcat){
          //get BOM and inv_master details by itemno 
          if($bomcat == "diamond"){
            $sql2=  "SELECT
                    dbo.ord_item_bom.orddtl_refid,
                    dbo.ord_item_bom.qty,
                    dbo.ord_item_bom.uom_qty,
                    dbo.ord_item_bom.weight,
                    dbo.ord_item_bom.uom_wt,
                    dbo.ord_item_bom.actual_qty,
                    dbo.ord_item_bom.itemref,
                    dbo.ord_item_bom.itemno,
                    dbo.ord_item_bom.itemnoid,
                    dbo.ord_item_bom.bomcategy,
                    dbo.ord_item_bom.ismainstone,
                    dbo.ord_item_bom.isshading,
                    dbo.inv_diamond.stonefragility,
                    dbo.inv_diamond.name_en,
                    dbo.inv_diamond.name_sc
                    
                    FROM
                    dbo.ord_item_bom
                    INNER JOIN dbo.inv_diamond ON dbo.ord_item_bom.itemnoid = dbo.inv_diamond.refid
                    WHERE
                    dbo.ord_item_bom.orddtl_refid = :refid AND
                    dbo.ord_item_bom.bomcategy = 'diamond' AND
                    dbo.inv_diamond.itemno = :itemno";
          }elseif($bomcat =="stone"){
              $sql2="SELECT
                    dbo.ord_item_bom.orddtl_refid,
                    dbo.ord_item_bom.qty,
                    dbo.ord_item_bom.uom_qty,
                    dbo.ord_item_bom.weight,
                    dbo.ord_item_bom.uom_wt,
                    dbo.ord_item_bom.actual_qty,
                    dbo.ord_item_bom.itemref,
                    dbo.ord_item_bom.itemno,
                    dbo.ord_item_bom.itemnoid,
                    dbo.ord_item_bom.bomcategy,
                    dbo.ord_item_bom.ismainstone,
                    dbo.ord_item_bom.isshading,
                    dbo.inv_stone.stonefragility,
                    dbo.inv_stone.name_en,
                    dbo.inv_stone.name_sc
                    FROM
                    dbo.ord_item_bom
                    INNER JOIN dbo.inv_stone ON dbo.ord_item_bom.itemnoid = dbo.inv_stone.refid
                    WHERE
                    dbo.ord_item_bom.orddtl_refid = :refid AND
                    dbo.ord_item_bom.bomcategy = 'stone' AND
                    dbo.inv_stone.itemno = :itemno";              
              
          } else {
                $sql2 = "";  
          }
          
          if($sql2){                  
              $sth2 = $dbh->prepare($sql2);
              $sth2->execute( array(':refid' => $refid,
                                    ':itemno' => $r['itemno']) );
              //echo $sth2->getSQL( array(':refid' => $refid, ':itemno' => $r['itemno']) ).HTML_EOL;
              if($fp = $sth2->fetch()){
                    if($fp['ismainstone']==1){
                        $result['mainstone'] += $fp['qty'] * $r['order_qty'];    
                    } else if($fp['isshading']==1){
                        $result['shading'] += $fp['qty'] * $r['order_qty'];    
                    } else if($r['settingcategy']==1){ //setting: usual                    
                        if($fp['stonefragility']==1){
                            $result['s1'] += $fp['qty'] * $r['order_qty'];    
                        } else {
                            $result['f1'] += $fp['qty'] * $r['order_qty'];    
                        }                        
                    } else { //setting with edge
                        if($fp['stonefragility']==1){
                            $result['s2'] += $fp['qty'] * $r['order_qty'];    
                        } else {
                            $result['f2'] += $fp['qty'] * $r['order_qty'];    
                        }    
                    }
              }
          }
      }
    }
    
    return $result;
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title><?=$system_var['COMPANY_NAME']?></title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
<?php require_once "inc/jsheader.php"; ?>
<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
</head>
<script>
$(document).ready(function() {
    $( "#checkin_start" ).datepicker({
        dateFormat: "yy-mm-dd",
        showOn: "both",
/*        buttonImage: "images/calendar.gif",
        buttonImageOnly: true,*/
        defaultDate: "<?=$_REQUEST['checkin_start']?>"
    });
    
    $( "#checkin_end" ).datepicker({
        dateFormat: "yy-mm-dd",
        showOn: "both",
/*        buttonImage: "images/calendar.gif",
        buttonImageOnly: true,*/
        defaultDate: "<?=$_REQUEST['checkin_end']?>"
    });

    $( "#checkout_start" ).datepicker({
        dateFormat: "yy-mm-dd",
        showOn: "both",
/*        buttonImage: "images/calendar.gif",
        buttonImageOnly: true,*/
        defaultDate: "<?=$_REQUEST['checkout_start']?>"
    });
    
    $( "#checkout_end" ).datepicker({
        dateFormat: "yy-mm-dd",
        showOn: "both",
/*        buttonImage: "images/calendar.gif",
        buttonImageOnly: true,*/
        defaultDate: "<?=$_REQUEST['checkout_end']?>"
    });                    
    
});    
</script>
<?php //if($halt){ exit; } ?>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td valign="top" class="top"><?php require"mod_webhead.php"; ?></td>
  </tr>
  <tr>
    <td><table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="200" valign="top" class="menu_bg"><?php require"mod_menu.php"; ?>            <br/>
            <span class="mod_menu"><a href="ord_deptcheckinform.php?dept=<?=$opr_param['opr_code']?>" target="_new" class="fboxs uibutton" ><?=DEPARTMENT?><?=WS?><?=CHECKIN?></a></span>
            
            <form action="ord_setd_index.php" name="myform" id="myform" method="post" enctype="multipart/form-data">
                <span class="stext1"><br/><?=JOB_CARD?>:</span><br/>
                <input type="text" name="barcode" class="focus shortfield"  />
                <input type="submit" name="S" value="<?=SUBMIT?>" />
            </form>
            </td>
        <td valign="top" class="padding1">
        
        <table width="100%" border="0" cellpadding="0" cellspacing="0">
          <tr></tr>
          <tr>
            <td class="c1_bg">
            <form action="ord_setd_deptrpt.php" method="post">
            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="search">
              <tr>
                <td width="120" valign="top" ><?=resolveCode_master_operation($opr_param['opr_code'])?>:<br />
                  <span class="stext1"><?=DEPARTMENT.WS.REPORT?>:</span></td>
                <td valign="top">                
                
                <table>
                <tr>
                <td class="stext2"><?=WORKER?></td>
                <td class="stext2" colspan="2"><span id="spryselect1">
                    <select name="worker" id="worker">
                        <option value=""></option>
                        <?=input_masterWorker_option($_REQUEST['worker'], ture, 'SETD')?>
                    </select></span></td>
                </tr>
                <tr>
                <td class="stext2"><?=CHECKIN?></td>
                <td class="stext2"><input type="text" name="checkin_start" id="checkin_start" value="<?=$_REQUEST['checkin_start']?>" class="shortfield" /></td>
                <td class="stext2"><input type="text" name="checkin_end" id="checkin_end" value="<?=$_REQUEST['checkin_end']?>" class="shortfield" /></td>
                </tr>
                <tr>
                <td class="stext2"><?=CHECKOUT?></td>
                <td class="stext2"><input type="text" name="checkout_start" id="checkout_start" value="<?=$_REQUEST['checkout_start']?>" class="shortfield" /></td>
                <td class="stext2"><input type="text" name="checkout_end" id="checkout_end" value="<?=$_REQUEST['checkout_end']?>" class="shortfield" /></td>
                </tr>                
               
                </table>
</td>
                <td align="right" valign="top"><input type="image" src="image/btn_search.jpg" width="64" height="20" />&nbsp; <!--<a href="ord_dtl_addform.php" ><img src="image/btn_new.jpg" width="52" height="20" /></a>&nbsp;--><a href="<?=basename($_SERVER['PHP_SELF'])?>" title="<?=CLEAR?>"><img src="image/icon_close.jpg" width="20" height="20" align="top" alt="<?=CLEAR?>" /></a></td>
              </tr>

            </table></form>
            </td>
          </tr>
          <tr>
            <td valign="top" class="c2_bg"><table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td valign="top">
                <table width="100%" id="product_table" border="0" cellpadding="0" cellspacing="0" class="tablelist floathead">
                  <thead><tr>
                          <th><?=JOB_CARD?></th>
                          <th><?=ORDER?><?=WS?><?=NUMBER?></th>
                        <th><?=CUSTOMER?><?=WS?><?=NAME?></th>
                        <th><?=ITEMNO?></th>
                        <th><?=CHECKIN?><?=WS?><?=TIME?></th>
                        <th><?=CHECKOUT?><?=WS?><?=TIME?></th>
                        <th><?=MAIN_STONE?></th>
                        <th><?=STRONG_STONE.WS?>1</th>
                        <th><?=FRAGILE_STONE.WS?>1</th>
                        <th><?=STRONG_STONE.WS?>2</th>
                        <th><?=FRAGILE_STONE.WS?>2</th>
                        <th><?=SHADING?></th>
                        <th><?=TIME?></th>
                    </tr></thead>
                                                        
<?php
if(true || $_REQUEST['worker']){
    $sql_clause='';
    if( !empty($_REQUEST['worker']) ){
        if(!empty($sql_clause)) $sql_clause .= ' AND ';
        $sql_clause .= 'ord_txseto.worker = :worker ';
        $sql_param[':worker'] = $_REQUEST['worker'];            
    }    
    if( !empty($_REQUEST['checkin_start']) ){
        if(!empty($sql_clause)) $sql_clause .= ' AND ';
        $sql_clause .= ' ord_txseto.checkin_time >= :checkin_start ';
        $sql_param[':checkin_start'] = $_REQUEST['checkin_start'];            
    }    
    if( !empty($_REQUEST['checkin_end']) ){
        if(!empty($sql_clause)) $sql_clause .= ' AND ';
        $sql_clause .= ' ord_txseto.checkin_time <= :checkin_end ';
        $sql_param[':checkin_end'] = $_REQUEST['checkin_end'];            
    }    
    if( !empty($_REQUEST['checkout_start']) ){
        if(!empty($sql_clause)) $sql_clause .= ' AND ';
        $sql_clause .= ' ord_txseto.checkout_time >= :checkout_start ';
        $sql_param[':checkout_start'] = $_REQUEST['checkout_start'];            
    }    
    if( !empty($_REQUEST['checkout_end']) ){
        if(!empty($sql_clause)) $sql_clause .= ' AND ';
        $sql_clause .= ' ord_txseto.checkout_time <= :checkout_end ';
        $sql_param[':checkout_end'] = $_REQUEST['checkout_end'];            
    }        

    
$sql="SELECT
dbo.ord_main.order_nbr,
dbo.ord_main.custcode,
dbo.ord_main.refid as ord_refid,
dbo.ord_dtl.itemno as prod_itemno,
dbo.ord_dtl.qty,
dbo.ord_txmain.ttlwt,
dbo.ord_txmain.orddtl_refid,
dbo.ord_route.refid AS ordroute_refid,
dbo.ord_txseto.*

FROM
dbo.ord_txseto
INNER JOIN dbo.ord_txmain ON dbo.ord_txseto.txmain_refid = dbo.ord_txmain.refid
INNER JOIN dbo.ord_dtl ON dbo.ord_txmain.orddtl_refid = dbo.ord_dtl.refid
INNER JOIN dbo.ord_main ON dbo.ord_dtl.main_refid = dbo.ord_main.refid
INNER JOIN dbo.ord_route ON dbo.ord_route.ordtxmain_refid = dbo.ord_txmain.refid
WHERE $sql_clause
ORDER BY dbo.ord_txseto.checkin_time ASC";    
    
    $sth = $dbh->prepare($sql);
    $q = $sth->execute( $sql_param );
//echo $sth->getSQL( $sql_param ) . HTML_EOL;
    pdo_showerror($sth, $q);
    $ttl= array();            
    while($row = $sth->fetch()) {    
        $setcount = seto_getSettingCount($row['orddtl_refid'], $row['ordroute_refid']);
        table_summary($ttl, $row);
        table_summary($ttl, $setcount);?>
                  <tr>
                        <td class="code"><?=ord_htmllink_jobcard($row['orddtl_refid'], false, 'class="fbox"')?></td>
                        <td class="code"><?=ord_htmllink_order($row['ord_refid'], $row['order_nbr'], 'class="fbox"')?></td>
                        <td><?=resolveCode_masterCustomer($row['custcode'])?></td>
                        <td class="code"><span class="ctip" ctip="ajax_thumb_inv_product.php?itemno=<?=$row['prod_itemno']?>&formid=<?=$formid?>"><?=$row['prod_itemno']?></span></td>
                        <td><?=datef($row['checkin_time'])?></td>
                        <td><?=datef($row['checkout_time'])?></td>
                        <td class="tdalignright"><?=numf($setcount['mainstone'])?></td>
                        <td class="tdalignright"><?=numf($setcount['s1'])?></td>
                        <td class="tdalignright"><?=numf($setcount['f1'])?></td>
                        <td class="tdalignright"><?=numf($setcount['s2'])?></td>
                        <td class="tdalignright"><?=numf($setcount['f2'])?></td>
                        <td class="tdalignright"><?=numf($setcount['shading'])?></td>
                        <td class="tdalignright"><?=numf($row['act_svc_duration'],3)?></td>
                  </tr>
            <?php } ?>
<?php } else{
 //echo MISSING.WS.WORKER;    
} //vdump($ttl);?>            
                <!--summary row-->
                <tfoot class="xfont">
                  <tr>
                        <td><?=TOTAL?></td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td class="tdalignright"><?=numf($ttl['mainstone'])?></td>
                        <td class="tdalignright"><?=numf($ttl['s1'])?></td>
                        <td class="tdalignright"><?=numf($ttl['f1'])?></td>
                        <td class="tdalignright"><?=numf($ttl['s2'])?></td>
                        <td class="tdalignright"><?=numf($ttl['f2'])?></td>
                        <td class="tdalignright"><?=numf($ttl['shading'])?></td>
                        <td class="tdalignright"><?=numf($ttl['act_svc_duration'],3)?></td>
                  </tr>
                </tfoot>
                </table></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<script type="text/javascript">
//var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1", {validateOn:["blur", "change"]});
</script>
</body>
</html>