webadmin.php

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

<?php 
$formid = "Order";
require_once "inc/configure.php";
//vdump($_SESSION['search']['order']);
$opr_param['opr_code']    = "WAXO";

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

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

if($refid){
    $dbh->beginTransaction();
    
    $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,
    dbo.inv_product.mold_refid,
    dbo.inv_product.[size] as prod_size,
    Count(dbo.dgn_master_submold.refid) AS moldpart
    
    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
    INNER JOIN dbo.inv_product ON dbo.inv_product.refid = dbo.ord_dtl.product_refid
    LEFT  JOIN dbo.dgn_master_submold ON dbo.dgn_master_submold.mold_refid = dbo.inv_product.mold_refid
    WHERE
    dbo.ord_dtl.refid = :refid
    GROUP BY
    dbo.ord_dtl.refid,
    dbo.ord_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,
    dbo.inv_product.mold_refid,
    dbo.inv_product.[size]
    ";


    $sth = $dbh->prepare($sql);
    $sth->execute(  array(':refid' => $refid) );
    //echo $sth->getSQL(  array(':refid' => $refid) );    
    $row = $sth->fetch();
    //$checkin_info = waxd_check($refid);        
    
/*    $deptcheckin_info = oprReadyForDeptCheckin($refid, $opr_param, $status);    
    if($status=="OK"){
        $deptcheckin_time = ord_deptcheckin($refid, $deptcheckin_info['refid'], $opr_param);        
    }*/
    
    $checkin_info = oprReadyForCheckin($refid, $opr_param, $status);    
    if($status=="OK"){
        //checkin now
        //$opr_param['opr_code']    = "WAXO";
        $opr_param['subtable']     = "ord_txwaxo";
        $opr_param['uom_wt']     = "gr"; 
        $opr_param['uom_qty']     = "pcs";    
        $opr_param['createby']    = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
        $opr_param['lastupby']    = filter_var($_SESSION['user'], FILTER_SANITIZE_STRING);
        ord_updateJCLocation($refid, $checkin_info['refid'], $opr_param);
        $checkin_time = ord_checkin($refid, $checkin_info['refid'], $opr_param);        
    }
    
    $checkin_time = new DateTime($checkin_info['checkin_time']);
    $checkin_duration = $checkin_time->diff( new DateTime("now") ); //compared to NOW
    //$diff = $checkin_time->getTimestamp() - $now->getTimestamp();
    $act_svc_duration = numf(dateintervalToHour($checkin_duration));
    $sth=null;    
    
    $dbh->commit();    
} else {

}


//show wax warning if necessary
$sql="SELECT
dbo.ord_dtl.refid,
dbo.ord_dtl.qty,
dbo.inv_product.mold_refid,
dbo.inv_product.[size] as prod_size,
dbo.ord_route.opr_nbr,
dbo.ord_route.checkin_time,
dbo.ord_route.checkout_time,
dbo.ord_main.order_nbr
FROM
dbo.ord_main
INNER JOIN dbo.ord_dtl ON dbo.ord_dtl.main_refid = dbo.ord_main.refid
INNER JOIN dbo.inv_product ON dbo.ord_dtl.product_refid = dbo.inv_product.refid
INNER JOIN dbo.ord_route ON dbo.ord_route.orddtl_refid = dbo.ord_dtl.refid
WHERE
dbo.ord_main.refid = :main_refid AND
dbo.inv_product.mold_refid = :mold_refid AND
dbo.inv_product.[size] = :prod_size AND
dbo.ord_route.checkin_time IS NULL AND
opr_code='WAXO'
Order by dbo.ord_dtl.refid ASC";
$sth = $dbh->prepare($sql);
$sth->execute(  array(':main_refid' => $row['main_refid'], 
                        ':mold_refid' => $row['mold_refid'], 
                        ':prod_size' => $row['prod_size']) );
/*echo $sth->getSQL(  array(':main_refid' => $row['main_refid'], 
                        ':mold_refid' => $row['mold_refid'], 
                        ':prod_size' => $row['prod_size']) );*/
while($sjc = $sth->fetch()){
    $wax_warning=1;
    $wax_warning_table .= "<tr><td align='center'>".generateJCBarcode($sjc['refid'])."</td><td align='center'>".numf($sjc['qty'])."</td><td align='center'>".$row['moldpart']."</td><td align='center'>".$row['prod_size']."</td></tr>";
    //vdump($sjc);
    
}
//exit;
?>
<!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/SpryValidationCheckbox.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationSelect.js" type="text/javascript"></script>
<script>

$(document).ready(function() {

    //refreshMOLD();
    
    $( "#checkout-form" ).dialog({
        autoOpen: false,
        modal: true
    });
    $( "#checkout_trig" ).click(function() {
        $( "#checkout-form" ).dialog( "open" );
    });
    
    $(".focus").focus();
    
    <?php if($wax_warning){ ?>
    $( "#wax-warning" ).dialog({
        autoOpen: true,
        modal: true,
        width: 400,
        buttons: {
            "OK": function() {$( this ).dialog( "close" );}
        }
    });    

    <?php } ?>
});    

function refreshMOLD(){
    $.get("ajax_waxd_mold.php",{
            formid: "<?=$formid?>",  
            prod_qty: "<?=$row['qty']?>",
            mold_refid: $("#refid").val(),
            pdt_moldno: $("#pdt_moldno").val(),
            wax_wt: <?=empty($row['wax_wt'])?0:$row['wax_wt']?>,
            uom_waxwt: "<?=$row['uom_waxwt']?>",
            formolding: "<?=$row['formolding']?>",
            numMold: "AUTO",
            edit: $("#edit").val()
        },
    function(data){
        //alert('changed');
        $('#tabs-8').html(data);
        rebind();
        updatePrices();
    });     
}

function localbind(){

}

function confirmCheckout(){
    return confirm("<?=ARE_YOU_SURE_YOU_WANT_TO_.WS.CHECKOUT?>?");
}

</script>

<link href="SpryAssets/SpryValidationCheckbox.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
</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="<?=basename($_SERVER['REQUEST_URI'])?>" name="quickform" id="quickform" 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(!empty($row)){ ?>

<?=wip_transferWarning($opr_param, $halt);?>

<?php //if($halt){ exit; } ?>
            <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>

                        <!--<td width="20" class="separator"><input type="image" src="image/icon_save.jpg" width="20" height="20" /></td>
                        <td width="20" class="separator"><a href="<?=basename($_SERVER['REQUEST_URI'])?>"><img src="image/icon_undo.jpg" width="20" height="20" /></a></td>-->

                        <!--<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>-->
                        <?php if($checkout_info = oprReadyForCheckout($refid, $opr_param, $status) ){
                            $onCloseForm = 'onclick="return ConfirmSave(\'myform\')"'; ?>
                        <td class="separator">                        
                        <a href="#" id="checkout_trig" class="newwinbtn">
                          <?=CHECKOUT?>...</a></td><?php } ?>
                        <!--<td width="20" class="separator"><a href="dgn_drawing_print.php?refid=<?=$row['refid']?>" target="_new"><?=PRINT_?></a></td>-->
                        <td class="separator stext1"><?=WAXD?>
                          <!--- <span>
                          <?=MODIFY?>
                          </span>--></td>
                        <td class="separator etext1"><?=ord_htmllink_jobcard($row['refid'], '', 'class="fbox"');?>
                          - <span>
                          <?=ord_htmllink_invproduct($row['itemno'], '', 'class="ctip fbox" ctip="ajax_thumb_inv_product.php?itemno='.$row['itemno'].'&formid='.$formid.'"')?>
                          </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_waxd_index.php?act=resume" <?=$onCloseForm?> class="closebtn"><?=CLOSE?></a>
  <input type="hidden" name="godest" id="godest" />
  <input type="hidden" name="formdest" value="ord_waxd_index.php?act=resume" /></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">
                        <form action="ord_waxd_modify.php" name="myform" id="myform" method="post" enctype="multipart/form-data">
                          <input type="hidden" name="action" value="ord_waxd_modifyform" />
                          <div id="tabs-2">
                            <p> 
                            <table border="0" >
                            <tr><td><?=JOB_CARD?></td><td><?=generateJCBarcode($row['refid'])?></td></tr>
                            <tr><td colspan="2"><hr/></td></tr>
                            <tr><td><?=ORDER?><?=WS?><?=NUMBER?></td><td><?=$row['order_nbr']?></td></tr>
                            <tr><td><?=CUSTOMER?><?=WS?><?=NAME?></td><td><?=$row['custname_'.SYS_LANG]?></td></tr>
                            <tr><td><?=LAUNCH_DATE?></td><td><?=datef($row['launch_date'])?></td></tr>
                            <tr><td><?=DELIVERY?><?=WS?><?=DATE?></td><td><?=datef($row['del_date'])?></td></tr>
                            <tr><td><?=ITEMNO?></td><td><?=$row['itemno']?></td></tr>
                            <tr><td><?=QTY?></td><td><?=numf($row['qty'])?></td></tr>
                            <tr><td><?=FINGERSIZE?></td><td><?=$row['size']?></td></tr>
                            <tr><td><?=REMARKS?></td><td><?=$row['remark']?></td></tr>

                            <tr>
                            <td><?=STATUS?></td>
                            <td>
                            <?php if($status=="INVALID"){ ?>
                                <span class="ui-state-error xlfont"><?=$msg?></span>
                                <script>
                                $(document).ready(function() {
                                    alert('<?=$msg?>');
                                });
                                </script>    
                            <?php } else {
                                print $msg; 
                            }?></td>
                            </tr>
                            
                            <?php if(datef($checkin_info['checkin_time'])){ ?><tr><td><?=CHECKIN?></td><td><?=datef($checkin_info['checkin_time'])?></td></tr><?php } ?>
                            <!--<tr><td><?=WORKER?><?=WS?><?=NAME?></td><td><?=$tx['worker']?></td></tr>-->
                           
                            
                            </table>

                            </p>
                          </div>
                          
                          <div id="tabs-4">
                            <p>
<table border="0" width="100%">
<tr>
    <?php
        $sql = "SELECT
                Count(dbo.dgn_master_submold.refid) as no_submold,
                dbo.dgn_master_mold.refid,
                dbo.dgn_master_mold.wax_wt,
                dbo.dgn_master_mold.uom_waxwt,
                dbo.dgn_master_mold.formolding,
                dbo.dgn_master_mold.remark_mold
                
                FROM
                dbo.ord_dtl
                INNER JOIN dbo.inv_product ON dbo.ord_dtl.product_refid = dbo.inv_product.refid
                INNER JOIN dbo.dgn_master_mold ON dbo.inv_product.mold_refid = dbo.dgn_master_mold.refid
                LEFT JOIN dbo.dgn_master_submold ON dbo.dgn_master_submold.mold_refid = dbo.dgn_master_mold.refid
                WHERE
                dbo.ord_dtl.refid = :refid
                GROUP BY
                dbo.dgn_master_mold.refid,
                dbo.dgn_master_mold.wax_wt,
                dbo.dgn_master_mold.uom_waxwt,
                dbo.dgn_master_mold.formolding,
                dbo.dgn_master_mold.remark_mold";
        $sth = $dbh->prepare($sql);
        $sth->execute( array(':refid'=>$refid)  );
        //echo $sth->getSQL( array(':refid'=>$refid)  );
        //vdump($master);
        $master = $sth->fetch();
    ?>
<td>
    Number of mould parts: <input type="text" name="numMold" value="<?=$master['no_submold']*$row['qty']?>" id="numMold" class="posint minifield" readonly="readonly" />&nbsp;
    <?=WEIGHT?>: <input type="text" name="wax_wt" value="<?=numf($master['wax_wt']*$row['qty'])?>" id="wax_wt" class="positive minifield" readonly="readonly" /><?=$master['uom_waxwt']?>&nbsp;<br/>
    For Molding: <?=($master['formolding']=="true")?"Yes":"No"?></td>
<td align="right">                            

    <a href="dgn_master_modifyform.php?dept=WAXO&edit=1&refid=<?=$master['refid']?>#tabs-8" class="newwinbtn fbox"><?=EDIT?><?=WS?><?=MASTER?></a>
</td>
</tr>
</table>                            

<table width="100%" border="1">
<tr>
<th class="title1"><?=MOLD?><?=WS?><?=NUMBER?></th>
<th class="title1"><?=QTY_OF_WAX?></th>
<th class="title1"><?=IMAGE?></th>
</tr>

<?php 
    $sql = "SELECT
    dbo.ord_dtl.itemno,
    dbo.dgn_master_submold.qty * dbo.ord_dtl.qty as qty,
    'pcs' AS uom_qty,
    dbo.dgn_master_submold.mold_subno,
    dbo.dgn_master_submold.img_src,
    dbo.dgn_master_submold.img_path
    FROM
    dbo.ord_dtl
    INNER JOIN dbo.inv_product ON dbo.ord_dtl.itemno = dbo.inv_product.itemno
    INNER JOIN dbo.dgn_master_mold ON dbo.inv_product.mold_refid = dbo.dgn_master_mold.refid
    INNER JOIN dbo.dgn_master_submold ON dbo.dgn_master_submold.mold_refid = dbo.dgn_master_mold.refid
    WHERE
    dbo.ord_dtl.refid = :refid";


    $sth = $dbh->prepare($sql);
    $sth->execute( array(':refid'=>$refid)  );
/*    echo $sth->getSQL( array(':refid'=>$refid)  );*/
    $mold_subno = 0;
    while( $submold = $sth->fetch() ){
        
    ?>
    <tr>
    <td><input type="text" name="submold_detail[<?=$mold_subno?>][mold_subno]" value="<?=$submold['mold_subno']?>" readonly="readonly" /></td>
    <td><input type="text" name="submold_detail[<?=$mold_subno?>][qty]" value="<?=ceil(evl($submold['qty'], 1))?>" class="shortfield posint" readonly="readonly" /></td>
    <td><?=$img=showThumb($submold)?>&nbsp;
    <input type="hidden" name="submold_detail[<?=$mold_subno?>][img_src]" value="<?=$submold['img_src']?>" />
    <input type="hidden" name="submold_detail[<?=$mold_subno?>][img_path]" value="<?=$submold['img_path']?>" />
    </td>
    </tr>
<?php $mold_subno++; } ?>

</table>
<br/>
<table border="0">
<tr>
    <td class="tdvaligntop"><?=REMARKS?>:</td>
    <td><textarea readonly="readonly" rows="3" cols="55"><?=$master['remark_mold']?></textarea></td>
</tr>
</table>
</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" />
                        </form>
                      </div>
                      <!--end scontent-->

                    </div>
                    
                    
                    
                    <!-- end of mainform--></td>
                  <td valign="top"></td>
                </tr>
              </table><?php } else {?>
              
                  Enter Barcode
              
              <?php } ?></td>
          </tr>
        </table></td>
    </tr>
  </table>
<!-- checkout form -->
<?php if($checkout_info){ ?>
<div id="checkout-form" title="<?=CHECKOUT?>">
     <form action="ord_waxd_checkout.php" method="post" enctype="multipart/form-data" onsubmit0="return confirmCheckout();">
     <input type="hidden" name="action" value="ord_waxd_checkout" />
     <input type="hidden" name="refid" value="<?=$refid?>" />
     <!--<input type="hidden" name="route_refid" value="<?=$checkin_info['refid']?>" />
     <input type="hidden" name="txmain_refid" value="<?=$checkin_info['ordtxmain_refid']?>" />-->
    <table>
    <tr>
        <td><?=TOTAL?><?=WS?><?=WAX?><?=WS?><?=NUMBER?></td>
        <td><span id="sprytextfield1">
          <input type="text" name="ttl_qty" class="posint minifield" />
        </span>          <input type="text" name="uom_qty" value="pcs" class="microfield" readonly="readonly" /></td>
    </tr>
    <tr>
        <td><?=WORKER?><?=WS?><?=NAME?></td>
        <td><span id="sprytextfield2">
          <input type="text" name="worker" />
        </span></td>
    </tr>
<!--    <tr>
        <td><?=WORKER?><?=WS?><?=BARCODE?></td>
        <td><input type="password" name="barcodepwd" id="barcodepwd" /></td>
    </tr>  -->  
    <tr>
        <td><?=TIME?></td>
        <td><span id="sprytextfield3">
          <input type="text" name="act_svc_duration" value="<?=numf($act_svc_duration)?>" class="positive minifield" /></span>          <input type="text" name="uom_duration" value="hr" class="microfield" readonly="readonly" /></td>
    </tr>    
    <tr>
        <td><?=QC?><?=WS?><?=OK?></td>
        <td><span id="sprycheckbox1">
          <input type="checkbox" name="qc" />
        <span class="checkboxRequiredMsg"><?=PLEASE_CONFIRM?></span></span></td>
    </tr>    
    <tr>
        <td>&nbsp;</td>
        <td><input type="submit" value="<?=CHECKOUT?>" class="uibutton pressnhide2" /></td>
    </tr> 
       
    </table>
    </form>
    <hr/>
    <table>
      <tr>
        <td><!--<a href="ord_waxd_printlabel.php?refid=<?=$refid?>" class="uibutton fboxs"><?=PRINT_?><?=WS?><?=LABEL?></a>-->
<!--        <form action="" method="post" enctype="multipart/form-data" >        
            <input type="hidden" name="orddtl_refid" value="<?=$refid?>" />
            <input type="submit" value="<?=PRINT_?>" />
            </form>-->
        </td>
        <td>&nbsp;</td>
      </tr>
  </table>
</div>
<?php } ?>


<?php if($wax_warning){ ?>
<div id="wax-warning" title="<?=WAX?><?=WS?><?=WARNING?>">
  <p>OTHER JOB CARD USING SAME MOULD IN THIS ORDER<br/>有其他作业卡，在本订单中，使用相同的模具。<br/>
    <table border="0" width="80%">
    <tr><th><?=JOB_CARD?></th><th align="center"><?=QTY?></th><th align="center"><?=PART?></th><th align="center"><?=SIZE?></th></tr>
    <?=$wax_warning_table?>
    </table>
  </p>
</div>
<?php } ?>


<?=""//vdump($row);?>
<!-- end of checkout form -->
<script type="text/javascript">
var sprycheckbox1 = new Spry.Widget.ValidationCheckbox("sprycheckbox1");
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1");
var sprytextfield2 = new Spry.Widget.ValidationTextField("sprytextfield2");
var sprytextfield3 = new Spry.Widget.ValidationTextField("sprytextfield3");
</script>

</body>
</html>