webadmin.php

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

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

$row['status']="INPROGRESS";
if($row['status']=="INPROGRESS"){ //allow add product in this status
/*
    $sql_inprogress = " OR (
    ivcrawmatmain_refid is null AND
    dbo.ord_podtl.status IN ('SENT', 'RECEIVED', 'FINISHED') AND 
    (dbo.ord_podtl.sostatus<>'FINISHED' OR dbo.ord_podtl.sostatus IS NULL) ) ";
*/
    $sql_inprogress = " OR (
    dbo.ord_podtl.status IN ('SENT', 'RECEIVED', 'FINISHED') AND 
    (dbo.ord_podtl.sostatus<>'FINISHED' OR dbo.ord_podtl.sostatus IS NULL) ) ";    
}

/*$sql = "SELECT
dbo.ord_pomain.refid,
dbo.ord_pomain.pono,
dbo.ord_pomain.launch_date,
dbo.ord_pomain.del_date,
dbo.ord_pomain.buyer,
dbo.master_supplier.code
FROM
dbo.ord_pomain
INNER JOIN dbo.ord_podtl ON dbo.ord_podtl.pomain_refid = dbo.ord_pomain.refid
INNER JOIN dbo.master_supplier ON dbo.ord_pomain.supplier_refid = dbo.master_supplier.refid
LEFT JOIN dbo.ivc_rawmat_dtl ON dbo.ivc_rawmat_dtl.ordpodtl_refid = dbo.ord_podtl.refid
WHERE
(ivcrawmatmain_refid = :ivcrawmatmain_refid 
OR (
    dbo.ord_podtl.status IN ('SENT', 'RECEIVED', 'FINISHED') AND 
    (dbo.ord_podtl.sostatus<>'FINISHED' OR dbo.ord_podtl.sostatus IS NULL) )
    )
AND dbo.master_supplier.code IN ('EZH', 'EZN')
GROUP BY
dbo.ord_pomain.refid,
dbo.ord_pomain.pono,
dbo.ord_pomain.launch_date,
dbo.ord_pomain.del_date,
dbo.ord_pomain.buyer,
dbo.master_supplier.code";*/
$sql = "SELECT
dbo.ord_pomain.refid,
dbo.ord_pomain.pono,
dbo.ord_pomain.launch_date,
dbo.ord_pomain.del_date,
dbo.ord_pomain.buyer,
dbo.master_supplier.code
FROM
dbo.ord_pomain
INNER JOIN dbo.ord_podtl ON dbo.ord_podtl.pomain_refid = dbo.ord_pomain.refid
INNER JOIN dbo.master_supplier ON dbo.ord_pomain.supplier_refid = dbo.master_supplier.refid
LEFT JOIN dbo.ivc_rawmat_dtl ON dbo.ivc_rawmat_dtl.ordpodtl_refid = dbo.ord_podtl.refid
WHERE
(ivcrawmatmain_refid = :ivcrawmatmain_refid 
$sql_inprogress)
AND dbo.master_supplier.code IN ('EZH', 'EZN')
GROUP BY
dbo.ord_pomain.refid,
dbo.ord_pomain.pono,
dbo.ord_pomain.launch_date,
dbo.ord_pomain.del_date,
dbo.ord_pomain.buyer,
dbo.master_supplier.code";
$sth = $dbh->prepare($sql);

$sql2="SELECT
dbo.ord_podtl.*
FROM
dbo.ord_podtl
INNER JOIN dbo.ord_pomain ON dbo.ord_podtl.pomain_refid = dbo.ord_pomain.refid
WHERE
(
    dbo.ord_podtl.pomain_refid = :main_refid AND
    dbo.ord_pomain.status IN ('SENT', 'RECEIVED', 'FINISHED') AND 
    (dbo.ord_podtl.sostatus<>'FINISHED' OR dbo.ord_podtl.sostatus IS NULL) 
)";
$sth2 = $dbh->prepare($sql2);

$sql_param[':ivcrawmatmain_refid'] = $refid;    
//$sql2_param[':ivcrawmatmain_refid'] = $refid;    

//calculate due date (30days)
$default_duedate = new DateTime("now");
$default_duedate->add(new DateInterval('P30D'));
//echo $default_duedate->format('Y-m-d') . "\n";
?>
<!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/SpryValidationSelect.js" type="text/javascript"></script>
<script src="SpryAssets/SpryValidationTextField.js" type="text/javascript"></script>
<script>
$(document).ready(function() {
    
    $("table.jexpand").jExpand();

    $( "#launch_date" ).datepicker({
        dateFormat: "yy-mm-dd",
        defaultDate: "<?=date("Y-m-d")?>"
    });
                
    $( "#del_date" ).datepicker({
        dateFormat: "yy-mm-dd",
        defaultDate: "<?=datef($row['due_date'])?>"
    });
    
    $(".submitform").on("click", function(e) {
         $( "#tabs" ).tabs('select', 0);  //goto first tab
    });    
    
    $("input.invoice_checkall").on('change', function(){
        //console.log('checkall');
        var c = this.checked;
        $("input.invoice_check").each(function(){
            $(this).prop("checked", c); //apply to all child
            $(this).change();
        });
    });
    
    $("input.invoice_check").on('change', function(){
        //console.log($(this));
        var refid = $(this).prop("name").replace(/[^0-9]+/g, '');  //get orderID in name
        var c = this.checked;
        $("input.invoice_check_"+refid).each(function(){
            $(this).prop("checked", c); //apply to all child
            $(this).change();
        });
    });    
    
    //init parent checkbox depends on child checkbox state 
    $("input.iv_check:checked").each(function(){
        var row = $(this).closest("tr.sublevel").prev();
        var found = false;
        //console.log( row );
        while( row.length ){//is not empty
            row = row.prev();
            if(row.hasClass("mainlevel")){
                found = true;
                //console.log( "found", row );    
                break;
            }
            //console.log( "trav", row );    
        }
        if( found ){
            //console.log( "find", row );
            row.find("input.invoice_check").prop("checked", true);
        }
    });    
        
    $(".inputqty").on("change blur", function(){
        //console.log($(this));
        var row = $(this).closest(".qtyrow");
        if($(this).val().length>0 && $(this).val()>0){
            row.find(".iv_check").prop("checked", true);
        }else{
            row.find(".iv_check").prop("checked", false);
        }
    });    
    
    $( ".marksofinish" ).on("click", function(e) {
        //alert(1);
        e.preventDefault();
        
        //console.log($(this).attr("data-refid"));
        //alert($(this).attr("data-refid"));
        //console.log($(this).parent());
        var buttoncell = $(this).parent();
        
        $.blockUI({  theme:     true,
                title:    'ENZA', 
                message:  '<p><?=LOADING?>...<br/><br/><span style="float:right;" ><input type="button" name="<?=CLOSE?>" value="<?=CLOSE?>" onclick="$.unblockUI();" /></span></p>', 
                baseZ: 2000     }); 
        
        $.post("ajax_ord_podtl_markfinished.php",{  
                  formid: "<?=$formid?>",
                  action: "ajax_ord_podtl_markfinished",
                  podtl_refid: $(this).attr("data-refid")
              },
              function(data){
                 //alert(data);
                 buttoncell.html(data);
                 $.unblockUI();
              });
    });
    
});        

function updatePrices(){}

function approxQty(input, std){
    return;
    if(std>0){
        return input/std;
    }
    else{
        return '';    
    }
}

function CalcSubtotal()
{
    //var row = $(this).parents('tr');
    var row = $(this).parent().parent(); //tr>td>input
    var qty_str = row.find(".inputqty").val()
    
    if( qty_str.length<=0){
        var qty_str = row.find(".inputqty").val(0)
    }
    
    var qty = parseFloat( row.find(".inputqty").val() );
    var price = parseFloat( row.find(".inputprice").val());
    var subtotal = round2d(qty*price );
    row.find(".subtotal").val(subtotal.toFixed(2));
    
    CalculateGrandtotal();
}

function CalculateGrandtotal(){
    
    var gt=new Number(0);
 
    $( "input.subtotal" ).each( function() {
        //console.log( $(this).closest(".qtyrow").find(".iv_check").prop("checked") );
        if( $(this).closest(".qtyrow").find("input.iv_check").prop("checked")==true){
            var num = new Number($(this).val());
            gt = gt + num;
        }
    } );
    $("input#totalamount").val(gt.toFixed(2));

} 


function updateEntry(){}

function localbind(){
    //calculate prices
    $('.inputqty, .inputprice').unbind("change, blur");
    $('.inputqty, .inputprice').bind("change, blur", CalcSubtotal);

    $('.iv_check').on("change", CalculateGrandtotal);
}
</script>
<script src="js/jexpand/jExpand.js"></script>
<link href="SpryAssets/SpryValidationSelect.css" rel="stylesheet" type="text/css" />
<link href="SpryAssets/SpryValidationTextField.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form action="ivc_rawmat_add.php" name="myform" id="myform" method="post" enctype="multipart/form-data">
  <input type="hidden" name="action" value="ivc_rawmat_addform" />
  <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"; ?></td>
            <td valign="top" class="padding1"><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" class="submitform pressnhide2" 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 href0="pdf_ivc_fty_cdn.php?delnote_nbr=<?=$delnote_nbr?>" id="print_trig" target="_blank"><span class="ui-icon0 ui-icon-print" ><?=PRINT_?></span></a></td>-->
                        <!--<td width="20" class="separator"><a href="#" id="download_trig"><span class="ui-icon0 ui-icon-circle-triangle-s" ></span>
                          <?=FILES?>
                          </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"><?=INTERNAL?><?=WS?><?=INVOICE?>
                          - <span>
                          <?=ADD?>
                          </span></td>
                        <td class="separator etext1"><?=$row['customer']?>
                          - <span>
                          <?=$row['ivc_nbr']?>
                          </span></td>
                        <td width="200" align="right" class="separator etext2"><?=LAST_MODIFY?>:
                          <?=lastUpdate($row)?></td>
                        <td width="80" align="right" class="separator etext2"><a href="ivc_rawmat_index.php?act=resume"  onclick="return ConfirmSave('myform')" class="closebtn"><?=CLOSE?></a>
  <input type="hidden" name="godest" id="godest" />
  <input type="hidden" name="formdest" value="ivc_rawmat_index.php?act=resume" /></td>
                      </tr>
                    </table></td>
                </tr>
                <tr>
                  <td valign="top" class="c2_bg"><!--main form--> 
                    
                    <!--editable-->
                    
                    <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">
                          <p>
                          <table>
                            <tr>
                              <td ><?=CUSTOMER?></td>
                              <td ><span id="spryselect1">
                                <select name="ivc_customer">
                                  <option value=""></option>
                                  <?=master_option("COMPANY", $row['ivc_customer'], true)?>
                                </select>
                              </span></td>
                            </tr>
                            
                            <tr>
                              <td ><?=SELLER?></td>
                              <td ><span id="spryselect2">
                                <select name="companyid" id="companyid" >
                                  <option value=""></option>
                                  <?=vendor_option($_SESSION['defaultcompany'])?>
                                </select></span></td>
                            </tr>
                            <tr>
                              <td ><?=STATUS?></td>
                              <td ><select name="status">
                                  <?=master_option("INVOICE_STATUS", $row['status'], true)?>
                                </select></td>
                            </tr>           
                            <?php if( empty($row['ivc_nbr']) ) {?>
                            <tr>
                              <td ><?=ISSUE?><?=WS?><?=INVOICE?><?=WS?><?=NUMBER?></td>
                              <td ><input type="checkbox" name="issue_ivcnbr"/></td>
                            </tr>                            
                            <?php } ?>                                             
                            <tr>
                              <td ><?=LAUNCH_DATE?></td>
                              <td ><input type="text" name="launch_date" id="launch_date_d" value="<?=date("Y-m-d")?>" readonly="readonly" /></td>
                            </tr>
                            <tr>
                              <td ><?=DUE?><?=WS?><?=DATE?></td>
                              <td ><span id="sprytextfield1">
                                <input name="due_date" value="<?=$default_duedate->format('Y-m-d')?>" id="del_date" />
                              </span></td>
                            </tr>                         
                          </table>
                          </p>
                        </div>


                        <div id="tabs-4">
                          <p>

                          <table width="100%" id="product_table" border="0" cellpadding="0" cellspacing="0" class="jexpand tablelist nocss">
                  <tr>
                          <th><?=INVOICE?><input type="checkbox" name="invoice_checkall" class="invoice_checkall" /></th>
                        <th><!--<a href="javascript:$('.sublevel').show();">+</a>&nbsp;--><a href="javascript:;" class="jexpandAll_trigger xfont">+</a><?=ORDER?><?=WS?><?=NUMBER?></th>
                        <th><?=CUSTOMER?><?=WS?><?=NAME?></th>
                        <th><?=SELLER?></th>
                        <th><?=LAUNCH_DATE?></th>                        
                        <th><?=DELIVERY?><?=WS?><?=DATE?></th>
                        <th>&nbsp;</th>
                        <?php if(havePermission("DCr")){ //DC-------------------------------?>                        
                        <th>&nbsp;</th>
                        <th>&nbsp;</th>
                        <?php } //end of DC-------------------------------------------------?>
                        <th>&nbsp;</th>
                    </tr>
                                                        
<?php

    $q = $sth->execute($sql_param);
    //echo $sth->getSQL( $sql_param ) . HTML_EOL;
                
    while($row = $sth->fetch()) {    
        //vdump($row);
        
        ?>
                  <tr class="mainlevel">
                          <td class="tdalignmid"><input type="checkbox" name="invoice_group[<?=$row['refid']?>]" class="invoice_check" /></td>
                        <td><a href="javascript:;" class="jexpand_trigger xfont">+</a> <a href="ord_so_modifyform.php?refid=<?=$row['refid']?>#tabs-4" class="fbox code" ><?=$row['pono']?></a></td>
                        <td><?=resolveCode_masterCustomer($row['buyer'])?></td>
                        <td><?=$row['code']?></td>
                        <td><?=datef($row['launch_date'])?></td>
                        <td><?=datef($row['del_date'])?></td>
                        <td>&nbsp;</td>
                        <?php if(havePermission("DCr")){ //DC-------------------------------?>                        
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <?php } //end of DC-------------------------------------------------?>
                        <td>&nbsp;</td>

                </tr>

                <tr class="sublevel tdevencolor" style="display: none;">
                          <td>&nbsp;</td>
                        <th><?=ITEMNO?></th>    
                        <th><?=NAME?></th>
                        <th><?=ORDERED?></th>                        
                        <th><?=REMAINING?></th>
                        <th><?=INVOICE?></th>
                        <?php if(havePermission("DCr")){ //DC-------------------------------?>                        
                        <th><?=UNITPRICE?></th>
                        <th><?=AMOUNT?></th>
                        <?php } //end of DC-------------------------------------------------?>
                        <th><?=SUPPLIER?><?=WS?><?=REFERENCE?></th>
                        <th><?=STATUS?></th>
                  </tr>
                  
                <?php 

                    $sql2_param[':main_refid'] = $row['refid'];
                    $q = $sth2->execute( $sql2_param );
                    //echo $sth2->getSQL( $sql2_param );
                while( $row2 = $sth2->fetch() ) {
                    //vdump($row2);
                    $checked = ($row2['ivcrawmatmain_refid']>0)? 'checked="checked"' : ''; 
                    $material = getDB_inv($row2['bomcategy'], $row2['itemnoid']);
                    ?>
                <tr class="sublevel tdevencolor qtyrow" style="display: none;">
                        <td class="tdalignmid"><input type="checkbox" name="invoice_check[<?=$row2['refid']?>][checked]" class="invoice_check_<?=$row['refid']?> iv_check" <?=$checked?> /></td>
                        <td><?=$materaial['itemno']?>
                        <input type="hidden" name="invoice_check[<?=$row2['refid']?>][refid]" value="<?=$row2['refid']?>" />
                        <a href="inv_<?=$row2['bomcategy']?>_modifyform.php?refid=<?=$material['refid']?>" class="fbox code" ><?=$material['itemno']?></a>
                        <!--<?=$row2['bomcategy']?><?=$row2['itemnoid']?>--></td>                        
                        <td><?=$material['name_'.SYS_LANG]?></td>
                        <td align="right"><?=numf($row2['qty'])?><?=$row2['uom_qty']?></td>
                        <td align="right"><?php
                            $remaining = $row2['qty'] - ord_soinvoiced($row2['refid']);
                            print numf($remaining, 3)?><?=$row2['uom_qty']?></td>                   
                        <td align="right"><input type="text" name="invoice_check[<?=$row2['refid']?>][qty]" class="inputqty positive minifield" /><?=$row2['uom_qty']?></td>
                        <?php if(havePermission("DCr")){ //DC-------------------------------?>     
                        <td align="right"><input type="text" name="invoice_check[<?=$row2['refid']?>][unit_price]" value="<?=numf($row2['unit_price'],4)?>" class="positive inputprice minifield" /><?=$row2['uom_cy']?></td>
                        
                        <td align="right">
                        <input type="text" name="invoice_check[<?=$row2['refid']?>][amount]" value="<?=numf($received*$row2['unit_price'])?>" class="positive subtotal shortfield" readonly="readonly" /><?=$row2['uom_cy']?></td>
                        <?php } //end of DC-------------------------------------------------?>
                        <td align="right"><?=$row2['supplier_ref']?></td>
                         <td align="right"><button class="marksofinish pressnhide" data-refid="<?=$row2['refid']?>"><?=MARK_AS.WS.FINISHED?></button></td>
                  </tr>
                  <?php } ?>   
                <tr class="sublevel tdevencolor" style="display: none;">
                    <td class="tdbotborder" colspan="10">&nbsp;</td>
                </tr>                                   
<?php } 

        if($gttl_orderprice>0){
            $gmargin = ($gttl_orderprice-$gttl_ordercost)*100/$gttl_orderprice;
        }else{
            $gmargin = 0;
        }
        ?>
      
                <!--summary row
                  <tr class="xfont">
                          <td><?=TOTAL?></td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>
                        <td align="right"><?=numf($gttl_qty)?></td>
                        <td align="right">&nbsp;</td>
                        <?php if(havePermission("DCr")){ //DC-------------------------------?>
                        <td align="right"><?=numf($gttl_ordercost)?></td>
                        <td align="right"><?=numf($gttl_factorycost)?></td>
                        <?php } //end of DC-------------------------------------------------?>
                        <?php if(havePermission("DPr")){ //DP-------------------------------?>
                        <td align="right" style="color:#636"><b><?=numf($gttl_orderprice)?></b></td>
                        <td align="right"><?=numf($gmargin)?>%</td>
                        <?php } //end of DP-------------------------------------------------?>
                        <td><input type="checkbox" name="invoice_checkall" class="invoice_checkall" /></td>
                        <td>&nbsp;</td>
                        <td>&nbsp;</td>

                  </tr>-->
                </table>
                <br/><?=TOTAL?>: <input type="text" name="amount" value="0.00" id="totalamount" readonly="readonly" />
                          
                          </p>
                        </div>

                      </div>
                      <!--end scontent-->
                      <input type="hidden" name="refid" value="<?=$refid?>" id="refid" />
                    </div>
                    
                    <!--end of readonly--> 
                    
                    <!-- end of mainform--></td>
                  <td valign="top"></td>
                </tr>
              </table></td>
          </tr>
        </table></td>
    </tr>
  </table>
</form>

<script>
var ent = Number(<?=$i?>)+1;
var spryselect1 = new Spry.Widget.ValidationSelect("spryselect1");
var sprytextfield1 = new Spry.Widget.ValidationTextField("sprytextfield1");
var spryselect2 = new Spry.Widget.ValidationSelect("spryselect2");
</script>
</body>
</html>