webadmin.php

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

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

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

function readyForCheckout($orddtl_refid){
    global $dbh;        
    // update route
    $sql = "SELECT
            Count(dbo.ord_txfilo.refid) as counter
            FROM
                dbo.ord_txmain
                INNER JOIN dbo.ord_txfilo ON dbo.ord_txfilo.txmain_refid = dbo.ord_txmain.refid
            WHERE
            dbo.ord_txmain.orddtl_refid = :refid AND
            dbo.ord_txmain.opr_code = 'FILO' AND
            (dbo.ord_txfilo.checkin_time IS NULL OR
            dbo.ord_txfilo.checkin_time = '')";
    $sth = $dbh->prepare($sql);
    $q = $sth->execute(  array(    ':refid' => $orddtl_refid) );    
    $row = $sth->fetch();                            
    return $row['counter']==0;    
}

$refid = (int)setDefaultReqVar("refid", '');
$barcode = setDefaultReqVar("barcode", '');

if($barcode){
    $refid = (int)parseJCBarcode($barcode);
    //echo"BC";
}

if($refid){
    $sql="SELECT
        dbo.ord_dtl.refid,
        dbo.ord_main.refid as main_refid,
        dbo.ord_main.order_nbr,
        dbo.master_customer.custname_en,
        dbo.master_customer.custname_sc,
        dbo.ord_main.launch_date,
        dbo.ord_main.del_date,
        dbo.ord_dtl.itemno,
        dbo.ord_dtl.qty,
        dbo.ord_dtl.[size],
        dbo.ord_dtl.remark
        
        FROM
        dbo.ord_main
        INNER JOIN dbo.ord_dtl ON dbo.ord_dtl.main_refid = dbo.ord_main.refid
        INNER JOIN dbo.master_customer ON dbo.ord_main.custcode = dbo.master_customer.custcode
        WHERE
        dbo.ord_dtl.refid = :refid
        ";


    $sth = $dbh->prepare($sql);
    $sth->execute(  array(':refid' => $refid) );
    //echo $sth->getSQL(  array(':refid' => $refid) );    
    $row = $sth->fetch();     
    
    $checkin_info = oprReadyForCheckin($refid, $opr_param, $status);        
} else {
    //header("Location: ord_fild_index.php");
    //exit;
}


if(readyForCheckout($refid)){
    //vdump(readyForCheckout($refid)); exit;
    header("Location: ord_fild_checkoutform.php?refid=$refid");
    exit;
}


//if JC is ready to checkin:
//calculate checkin weight and accessory to be fill
if($status=="RESUME"){    
  //get itemno in FILA
  $sql = "SELECT
          dbo.ord_subroute.refid,
          dbo.ord_subroute.orddtl_refid,
          dbo.ord_subroute.itemno
          
          FROM
          dbo.ord_subroute
          WHERE
          dbo.ord_subroute.opr_code = 'FILA' AND
          dbo.ord_subroute.orddtl_refid = :refid";
  $sth = $dbh->prepare($sql);
  $sth->execute( array(':refid' => $refid) );
  
//get last checkout weight
$tx = getLastTx($refid);  
$checkin_weight = weightConv($tx['ttlwt'], $tx['uom_wt'], "gr");
$pickedallFILA = true;
  while($r = $sth->fetch()){
      //find the itemno in different BOM Cat
      $bomcat = getBomcategy($r['itemno']);
      if($bomcat){
      //get details by itemno and bomcat
            $sql2="SELECT
                dbo.ord_subroute.refid,
                dbo.ord_subroute.orddtl_refid,
                dbo.ord_subroute.opr_nbr,
                dbo.ord_subroute.opr_code,
                dbo.ord_subroute.ordroute_refid,
                dbo.ord_subroute.opr_svc,
                dbo.ord_subroute.uom_svc,
                dbo.ord_dtl.qty,
                dbo.ord_dtl.product_refid,
                dbo.inv_$bomcat.itemno,
                dbo.inv_$bomcat.name_en,
                dbo.inv_$bomcat.name_sc,
                Sum(dbo.ord_item_bom.weight* dbo.ord_item_bom.qty) * dbo.ord_dtl.qty AS weight,
                dbo.ord_item_bom.uom_wt,
                Sum(dbo.ord_item_bom.actual_qty) AS actual_qty
                
                FROM
                dbo.ord_subroute
                INNER JOIN dbo.ord_dtl ON dbo.ord_subroute.orddtl_refid = dbo.ord_dtl.refid
                INNER JOIN dbo.inv_$bomcat ON dbo.ord_subroute.itemno = dbo.inv_$bomcat.itemno
                INNER JOIN dbo.ord_item_bom ON dbo.inv_$bomcat.refid = dbo.ord_item_bom.itemnoid AND dbo.ord_item_bom.orddtl_refid = dbo.ord_dtl.refid
                WHERE
                dbo.ord_subroute.opr_code = 'FILA' AND
                dbo.ord_subroute.itemno = :itemno AND
                dbo.ord_dtl.refid = :refid
                GROUP BY
                dbo.ord_subroute.refid,
                dbo.ord_subroute.orddtl_refid,
                dbo.ord_subroute.opr_nbr,
                dbo.ord_subroute.opr_code,
                dbo.ord_subroute.ordroute_refid,
                dbo.ord_subroute.opr_svc,
                dbo.ord_subroute.uom_svc,
                dbo.ord_dtl.qty,
                dbo.ord_dtl.product_refid,
                dbo.inv_$bomcat.itemno,
                dbo.inv_$bomcat.name_en,
                dbo.inv_$bomcat.name_sc,
                dbo.ord_item_bom.uom_wt
                ";                  
          $sth2 = $dbh->prepare($sql2);
          $sth2->execute( array(':refid' => $refid, ':itemno' => $r['itemno']) );
          //echo $sth2->getSQL( array(':refid' => $refid, ':itemno' => $r['itemno']) );
          while($fp = $sth2->fetch()){
              if($fp['actual_qty']<=0){
                $pickedallFILA = false;  
              }
              //convert actual weight to unit of gram
              $fp['act_wt'] = weightConv($fp['actual_qty'], $fp['uom_wt'], "gr");
              $fill_part[] = $fp;
              //$checkin_weight += $fp['act_wt'];
          }
      }
      unset($bomcat);
  }
}
//vdump( $tx);
?>
<!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>ENZA</title>
<link rel="stylesheet" type="text/css" href="css/style.css" />
<?php require_once "inc/jsheader.php"; ?>
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<script>

$(document).ready(function() {

    $( "#checkout-form" ).dialog({
        autoOpen: false,
        modal: true
    });
    $( "#checkout_trig" ).click(function() {
        $( "#checkout-form" ).dialog( "open" );
    });
    
    $(".focus").focus();
    

/*      $('.sigPad').signaturePad({
          drawOnly:true,
          bgColour: '#EEE',
          lineColour: '#AAA',
          lineTop:500,
          output: '.sign'
      });
      
      var sign_display = $('.sign_display').signaturePad({displayOnly:true});
      
      $('#submit').click(function(){
          alert( $('.sign').val() );
          sign_display.regenerate( $('.sign').val() );
      });*/
      
     
    
});    


function localbind(){
    $('.ci_wt').unbind("change, blur");
    $(".ci_wt").bind("change, blur", CalcSubtotal);
    $('.ci2_wt').unbind("change, blur");
    $(".ci2_wt").bind("change, blur", CalcSubtotal);    
}

function confirmCheckin(){
    return confirm("Are you sure you want to checkin now?");
}

function CalcSubtotal()
{
    var row = $(this).parent().parent(); //tr>td>input
    var qty = parseFloat( row.find(".ci_wt").val());
    var unitprice = parseFloat( row.find(".ci2_wt").val());
    var subtotal = round2d(qty+unitprice);
    row.find(".subttl_wt").val(subtotal);
    CalculateGrandtotal();
}

function CalculateGrandtotal(){
    
    var gt=new Number(0);
 
    $( ".subttl_wt" ).each( function() {
        
        var num = new Number($(this).val());
        gt = gt + num;
    } );
    $("#checkin_wt").val(gt.toFixed(2));
} 
</script>
</head>
<body><?=""//vdump($checkin_info);?>
  <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 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_fild_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">    
<?php if($row) { ?> 
                         
            <?php //if(!empty($row)){ ?><table width="100%" border="0" cellpadding="0" cellspacing="0">
                <tr></tr>
                <tr>
                  <td class="c3_bg"><table width="100%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
<?php if($status=="OK") { ?> 
                        <td width="20" class="separator"><input type="image" src="image/icon_save.jpg" width="20" height="20" class="pressnhide2" /></td>
                        <td width="20" class="separator"><a href="<?=basename($_SERVER['REQUEST_URI'])?>?barcode=<?=$barcode?>"><img src="image/icon_undo.jpg" width="20" height="20" /></a></td>
<?php } ?>                         

                        <!--<td width="20" class="separator"><img src="image/icon_redo.jpg" width="20" height="20" /></td>
                <td width="20" class="separator"><img src="image/icon_delete.jpg" width="20" height="20" /></td>--> 
                        <!--<td width="20" class="separator"><a href="#" id="print_trig"><span class="ui-icon0 ui-icon-print" ><?=PRINT_?></span></a></td>-->

                        <!--<td width="20" class="separator"><a href="dgn_drawing_print.php?refid=<?=$row['refid']?>" target="_new"><?=PRINT_?></a></td>-->
                        <td class="separator stext1"><?=FILD?>
                          - <span>
                          <?=RESUME?><?=WS?><?=CHECKIN?>
                          </span></td>
                        <td class="separator etext1"><?=generateJCBarcode($row['refid'])?>
                          - <span>
                          <?=$row['itemno']?>
                          </span></td>
                        <td width="200" align="right" class="separator etext2"><?=CHECKIN?>:
                          <?=''//datef($checkin_info['checkin_time'])?></td>
                        <td width="80" align="right" class="separator etext2"><a href="ord_fild_index.php?act=resume" onclick="return ConfirmClose()"><img src="image/icon_close.jpg" width="20" height="20" align="absmiddle" /><?=CLOSE?></a></td>
                      </tr>
                    </table></td>
                </tr>
                <tr>
                  <td valign="top" class="c2_bg"><!--main form--> 
                    
                    
                    
                    <div id="tabs" class="ui-tabs">
                      <ul>
                        <li><a href="#tabs-2">
                          <?=GENERAL?>
                          </a></li>
                        <li><a href="#tabs-4">
                          <?=DETAIL?>
                          </a></li>
                      </ul>
                      <div id="scontent">
                        
                          <div id="tabs-2">
                            <table width="100%" border="0">
                              <tr>
                                <td><?=DATE?>: <?=date("Y-m-d")?></td>
                                <td><?=STATUS?>: 
                            <?php if($status=="INVALID"){ ?>
                                <span class="ui-state-error xlfont"><?=$msg?></span>
                                <script>
                                $(document).ready(function() {
                                    alert('<?=$msg?>');
                                });
                                </script>    
                            <?php $popup = true; 
                            } else {
                                print $msg; 
                            }?></td>
                                <td><?=LAST?><?=WS?><?=CHECKOUT?><?=WS?><?=WEIGHT?>: <input type="text" name="checkin_wt_ref" value="<?=qtyf($checkin_weight)?>" class="shortfield positive" readonly="readonly" />gr</td>
                                <td>&nbsp;</td>
                              </tr>
                              <tr>
                                <td colspan="4">&nbsp;</td>
                              </tr>
                              <tr>
                                <td><?=ORDER?><?=WS?><?=NUMBER?></td>
                                <td><?=ITEMNO?></td>
                                <td><?=QTY?></td>
                                <td>&nbsp;</td>
                              </tr>
                              <tr>
                                <td><?=$row['order_nbr']?></td>
                                <td><a href="#" class="ctip" name="product[itemno]" id="product[itemno]" ctip="ajax_thumb_inv_product.php?itemno=<?=$row['itemno']?>&formid=<?=$formid?>"><?=$row['itemno']?></a></td>
                                <td><?=numf($row['qty'])?></td>
                                <td>&nbsp;</td>
                              </tr>
                              <tr>
                                <td colspan="4">&nbsp;</td>
                              </tr>
                                                                                          
                              <tr>
                                <td colspan="4">
                                <table border="1">        
         <tr>
            <th><?=MOLDNO?></th>
            <th><?=PART?><?=WS?><?=WEIGHT?></th>
            <th><?=ACCESSORY?><?=WS?><?=WEIGHT?></th>
            <th><?=TOTAL?><?=WS?><?=WEIGHT?></th>
            <th><?=WORKER?></th>
            <!--<th><?=SIGNATURE?></th>-->
            <th><?=CHECKIN?></th>
        </tr><?php
        //get more data from database
        $sql="SELECT
                dbo.ord_txfilo.moldno,
                dbo.ord_txfilo.refid AS txfilo_refid,
                dbo.ord_txfilo.worker,
                dbo.ord_txfilo.worker_sign,
                dbo.ord_txfilo.checkin_time,
                dbo.ord_txfilo.checkout_time,
                dbo.ord_txfilo.checkin_wt,
                dbo.ord_txfilo.checkinacc_wt                
                FROM
                dbo.ord_txmain
                INNER JOIN dbo.ord_txfilo ON dbo.ord_txfilo.txmain_refid = dbo.ord_txmain.refid
                WHERE
                dbo.ord_txmain.orddtl_refid = :refid AND
                dbo.ord_txmain.opr_code = 'FILO'
                ";
        $sth_opr = $dbh->prepare($sql);
        $sth_opr->execute(  array(':refid' => $refid) );
        //echo $sth_opr->getSQL(  array(':refid' => $refid) );
        $mnum=0;
        $ttl_wt=0;
        while($mold=$sth_opr->fetch()){
            $mnum++;
            $ttl_wt += numf($mold['checkin_wt']+$mold['checkinacc_wt']);
            if($mold['checkin_time']){    
                $isnew = "0";
                $input_attr = 'readonly="readonly"';
            }else{    
                $isnew = "1"; 
                $input_attr = '';                     
            } ?> 
        <tr>
        <form action="ord_fild_split_resume.php" method="post">
        <input type="hidden" name="action" value="ord_fild_split_resume" />   
        <input type="hidden" name="refid" value="<?=$refid?>" />
            <td><?=$mold['moldno']?><input type="hidden" name="submold[<?=$mnum?>][moldno]" value="<?=$mold['moldno']?>" readonly="readonly" class="shortfield" /><br/>
            <?=showThumb(getSubmoldImg($refid, $mold['moldno']))?>
            <input type="hidden" name="submold[<?=$mnum?>][isnew]" value="<?=$isnew?>" readonly="readonly" class="microfield" />
            <input type="hidden" name="submold[<?=$mnum?>][txfilo_refid]" value="<?=$mold['txfilo_refid']?>" readonly="readonly" class="microfield" /></td>
            <td><input type="text" name="submold[<?=$mnum?>][checkin_wt]" value="<?=qtyf($mold['checkin_wt'])?>" class="positive shortfield ci_wt" <?=$input_attr?> />gr</td>
            <td><input type="text" name="submold[<?=$mnum?>][checkinacc_wt]" value="<?=qtyf($mold['checkinacc_wt'])?>" class="positive shortfield ci2_wt" <?=$input_attr?> />gr</td>
            <td><input type="text" name="submold[<?=$mnum?>][ttl_wt]" value="<?=qtyf($mold['checkin_wt']+$mold['checkinacc_wt'])?>" class="positive shortfield subttl_wt" readonly="readonly" />gr</td>
            <td><?php if($mold['worker']){ ?>
                    <input type="text" name="submold[<?=$mnum?>][worker]" value="<?=$mold['worker']?>" class="shortfield" readonly="readonly" />
                <?php } else { ?>
                    <?=input_masterWorkerBarcode('name="submold['.$mnum.'][worker]" class="shortfield"', $mnum, '', false)?>
                <?php } ?></td>
            <!--<td>&nbsp;</td>-->
            <td><?php if($isnew) {?><input type="submit" value="<?=CHECKIN?>" class="uibutton" /><?php } ?>&nbsp;</td>
            <!--<td><?php if($isnew) {?><input type="submit" value="<?=CHECKOUT?>" class="uibutton" /><?php } ?>&nbsp;</td>-->
        </form>
        </tr> <?php } ?></table><?=CHECKIN?><?=WS?><?=WEIGHT?>: <input type="text" name="checkin_wt" id="checkin_wt" value="<?=qtyf($ttl_wt)?>" class="shortfield positive" readonly="readonly" />gr
                              </td>
                              </tr>
                             

                              <tr>
                                <td colspan="4"><!--signature-->&nbsp;
                                </td>
                              </tr>  
                              <tr>
                                <td colspan="4">                                <?php if($fill_part){ ?>
                                <table border="1"><caption class="xlfont0"><b><?=ACCESSORY?></b></caption><tr><th><?=ITEMNO?></th><th><?=NAME?></th><th><?=QTY?></th><th><?=WEIGHT?></th></tr>        
                                        <?php foreach ($fill_part as $p){ ?>

                                <tr>
                                    <td><?=$p['itemno']?></td>
                                    <td><?=$p['name_'.SYS_LANG]?></td>
                                    <td><?=numf($p['opr_svc']*$row['qty'])?><?=$p['uom_svc']?></td>
                                    <td><?=qtyf($p['act_wt'])?>gr</td>                                    
                                </tr>
                                    <?php } ?>
                                </table>    
                                <?php } ?>
                                
                                <?php if( ($pickedallFILA == false) && ($popup != true) ){  
                                    $msg2 = PICKING.WS.IS_NOT_FINISHED; ?>
                                    <span class="ui-state-error xlfont"><?=$msg2?></span>
                                    <script>
                                    $(document).ready(function() {
                                        alert('<?=$msg2?>');
                                    });
                                    </script>    
                                <?php } ?></td>
                              </tr>                            
                            </table>
                          </div>
                          
                          <div id="tabs-4">
                            <p>
</p></div>

                          <input type="hidden" name="last_status" value="<?=$row['status']?>" />
                          <input type="hidden" name="refid" value="<?=$refid?>" id="refid" />
                          <input type="hidden" name="edit" value="<?=$editable?>" id="edit" />
                        
                      </div>
                      <!--end scontent-->

                    </div>
                    
                    
                    
                    <!-- end of mainform--></td>
                  <td valign="top"></td>
                </tr>
              </table>
              <?php //} ?>
              
              <?php } ?></td>
          </tr>
        </table></td>
    </tr>
  </table>

</body>
</html>