webadmin.php

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

<?php 
$formid=$_REQUEST['formid'];
require_once "inc/configure.php";

if(havePermission("RTr")==false){
    myerror("Invalid Permission");    
}

if(havePermission("RTu")==false){
    $RT_readonly = ' readonly="readonly" ';
}

//preload description of operation and workplace for translate function
$sql = "SELECT code, codedesc_en, codedesc_sc from master_operation";        
$sth = $dbh->prepare($sql);
$sth->execute();
$m_opr = $sth->fetchAll();
//vdump($m_opr);

$sql = "SELECT codeid, codedesc_en, codedesc_sc from master_type_code where typeid = :typeid";        
$sth = $dbh->prepare($sql);
$sth->execute( array(':typeid'=>"WORKPLACE")  );
$m_wp = $sth->fetchAll();
//vdump($m_wp);

function get_master_opr_name($code, $lang=SYS_LANG){
    global $m_opr;
    if(empty($code)){
        return;
    }
    foreach($m_opr as $key=>$value)    {
        if(array_search($code, $value))    {
            return $code ." - " .$m_opr[$key]['codedesc_'.$lang];
        }
    }
    return $code;
}

function get_master_wp_name($code, $lang=SYS_LANG){
    global $m_wp;
    if(empty($code)){
        return;
    }
    foreach($m_wp as $key=>$value)    {
        if(array_search($code, $value))    {
            return $code ." - " .$m_wp[$key]['codedesc_'.$lang];
        }
    }
    return $code;
}

//---------------------------------------------------------

$totalcost=0;

$mold_refid = $_REQUEST['mold_refid'];
$edit=$_REQUEST['edit'];

//check any existed operation of the BOM
$sql = "SELECT
count(*) as opcount
FROM
dgn_master_route
WHERE
dgn_master_route.mold_refid = :mold_refid";        
$sth = $dbh->prepare($sql);
$sth->execute( array(':mold_refid'=>$mold_refid)  );
//echo $sth->getSQL( array(':mold_refid'=>$mold_refid)  );
$c = $sth->fetch();
unset($sth);
$count = $c['opcount'];

if(empty($mold_refid)){
    myerror("Invalid Request");
    exit;    
}

//route
$sql = "SELECT
*
FROM
dgn_master_route
WHERE
dgn_master_route.mold_refid = :mold_refid
ORDER BY
opr_nbr ASC";        
$sth = $dbh->prepare($sql);

$sql2 = "SELECT
*
FROM
dgn_master_subroute
WHERE
dgn_master_subroute.route_refid = :route_refid
ORDER BY
dgn_master_subroute.opr_nbr ASC";        
$sth2 = $dbh->prepare($sql2);

$sql3 = "SELECT
*
FROM
dgn_master_subsubroute
WHERE
dgn_master_subsubroute.subroute_refid = :subroute_refid
ORDER BY
dgn_master_subsubroute.opr_nbr ASC";        
$sth3 = $dbh->prepare($sql3);

$entry=1;
 ?>
<p>

<?php if(havePermission("RTu")){ //RT-------------------------------?> 
<?php if ($edit==1){ ?>

        <?php 
        //if($count==0){ 
        if(false){ 
        $editdisplay = ($count==0)? "none":"block";
        ?>
            <a href="dgn_master_route_init.php?mold_refid=<?=$mold_refid?>" onclick="newROUTE()" id="newROUTE" class="newwinbtn fbox"><?=NEW_.WS.ROUTE?></a>&nbsp;
        <?php } ?>
            <a href="dgn_master_route_modifyform.php?mold_refid=<?=$mold_refid?>" id="editROUTE" class="newwinbtn fbox" style="display:<?=$editdisplay?>;"><?=EDIT.WS.ROUTE?></a>&nbsp;            
            <a onclick="refreshROUTE()" id="refreshROUTE" class="uibutton pressnhide"><?=REFRESH?></a>

<?php } ?>
<?php } // end of RT------------------------------------------------?>  

    <table width="100%" border="0" cellpadding="0" cellspacing="0" class="tablelist" id="route_table">
    <tr>
        <th>OP#</th>
        <th><?=OPERATION?></th>
        <th><?=ITEMNO?></th>
        <th><?=WORKPLACE?></th>
        <th><?=QTY?></th>
<?php if(havePermission("RPr")){ //RP-------------------------------?>        
        <th><?=UNITPRICE?></th>
        <th><?=TOTAL?></th>
<?php } // end of RP------------------------------------------------?>   
        <!--<th><?=DELETE?></th>-->
    </tr>
<?php

//-----------------------------------------------Execute SQL    

    $sth->execute( array(':mold_refid'=>$mold_refid)  );
    //echo $sth->getSQL( array(':mold_refid'=>$mold_refid)  );
    while($opr = $sth->fetch() ){
        $rate=getOprRate($opr['opr_code']);
        $totalcost += $opr['opr_svc']*$rate['unit_price']; 
        $entry++; ?>
<tr class="opr">
    <td><?=$opr['opr_nbr']?></td>
    <td><?=get_master_opr_name($opr['opr_code'])?></td>
    <td class="code"><?=$opr['itemno']?></td>
    <td><?=get_master_wp_name($opr['workplace_code'])?></td>
    <td><?=qtyf($opr['opr_svc'])?><?=$opr['uom_svc']?></td>
<?php if(havePermission("RPr")){ //RP-------------------------------?>      
    <td><?=numf($rate['unit_price'])?>/<?=$rate['uom_svc']?></td>
    <td><input type="text" name="opr[<?=$entry?>][opr_cost]" value="<?=numf($opr['opr_svc']*$rate['unit_price'])?>" class="positive minifield subtotal" readonly="readonly" /></td>
<?php } // end of RP------------------------------------------------?>     
    <!--<td><a href="#" class="deleteRowButton uibutton"><?=X?></a></td>-->
</tr>    

<?php //suboperation
    $sth2->execute( array(':route_refid'=>$opr['refid'])  );
    //echo $sth2->getSQL( array(':route_refid'=>$opr['refid']) );
    while($subopr = $sth2->fetch() ){
        $rate=getOprRate($subopr['opr_code']);
        $totalcost += $subopr['opr_svc']*$rate['unit_price'];
        $entry++; ?>
    <tr class="subopr" style="background-color:#CCC">
        <td><?=$opr['opr_nbr']?>.<?=$subopr['opr_nbr']?></td>
        <td><?=get_master_opr_name($subopr['opr_code'])?></td>
    <td class="code"><?=$subopr['itemno']?></td>
        <td><?=get_master_wp_name($subopr['workplace_code'])?></td>
        <td><?=qtyf($subopr['opr_svc'])?><?=$subopr['uom_svc']?></td>
<?php if(havePermission("RPr")){ //RP-------------------------------?>          
        <td><?=numf($rate['unit_price'])?>/<?=$rate['uom_svc']?></td>
        <td><input type="text" name="subopr[<?=$entry?>][opr_cost]" value="<?=numf($subopr['opr_svc']*$rate['unit_price'])?>" class="positive minifield subtotal" readonly="readonly" /></td>
<?php } // end of RP------------------------------------------------?>         
        <!--<td><a href="#" class="deleteRowButton uibutton"><?=X?></a></td>-->
    </tr>    
    
    <?php //subsuboperation
    $sth3->execute( array(':subroute_refid'=>$subopr['refid'])  );
    //echo $sth->getSQL(  );
    while($subsubopr = $sth3->fetch() ){
        $rate=getOprRate($subsubopr['opr_code']);
        $totalcost += $subsubopr['opr_svc']*$rate['unit_price'];
        $entry++; ?>
    <tr class="subopr" style="background-color:#AAA">
        <td><?=$opr['opr_nbr']?>.<?=$subopr['opr_nbr']?>.<?=$subsubopr['opr_nbr']?></td>
        <td><?=get_master_opr_name($subsubopr['opr_code'])?></td>
        <td class="code"><?=$subsubopr['itemno']?></td>
        <td><?=get_master_wp_name($subsubopr['workplace_code'])?></td>
        <td><?=qtyf($subsubopr['opr_svc'])?><?=$subsubopr['uom_svc']?></td>
<?php if(havePermission("RPr")){ //RP-------------------------------?>          
        <td><?=numf($rate['unit_price'])?>/<?=$rate['uom_svc']?></td>
        <td><input type="text" name="subsubopr[<?=$entry?>][opr_cost]" value="<?=numf($subsubopr['opr_svc']*$rate['unit_price'])?>" class="positive minifield subtotal" readonly="readonly" /></td>
<?php } // end of RP------------------------------------------------?>         
        <!--<td><a href="#" class="deleteRowButton uibutton"><?=X?></a></td>-->
    </tr>    
        <?php } ?>
    
    <?php } ?>        
            
<?php } ?>
</table><br />

<?php if(havePermission("RPr")){ //RP-------------------------------?>  
<?=TOTAL?>:<input type="text" name="route_total" value="<?=numf($totalcost)?>" id="route_total" class="positive" readonly="readonly" /></p>
<?php } // end of RP------------------------------------------------?>