webadmin.php

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

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

$p = (int)setDefaultReqVar("p", 1);

//vdump($_SESSION['search']['request']);
//vdump($_SESSION['search']['misc']);

$sql_clause='';

if( !empty($_SESSION['search']['request']['status']) ){
    $sql_clause .= 'AND status = :status ';
    $sql_param[':status'] = $_SESSION['search']['request']['status'];            
}

if( !empty($_SESSION['search']['request']['customer']) ){
    $customer= $_SESSION['search']['request']['customer'];
    $sql_clause .= 'AND (custname_en LIKE :custname_en OR custname_sc LIKE :custname_sc OR dgn_drawing.custcode LIKE :custcode OR clientname LIKE :clientname ) ';
    $sql_param[':custname_en'] = "%$customer%";
    $sql_param[':custname_sc'] = "%$customer%";
    $sql_param[':custcode'] = "%$customer%";
    $sql_param[':clientname'] = "%$customer%";            
}

if( !empty($_SESSION['search']['request']['prodtype']) ){
    $sql_clause .= 'AND (pdt_type=:pdt_type) ';
    $sql_param[':pdt_type'] = $_SESSION['search']['request']['prodtype'];            
}

if( !empty($_SESSION['search']['request']['finished']) ){
    $sql_clause .= 'AND finished = :finished ';
    $sql_param[':finished'] = '1';    
}    else {
    $sql_clause .= 'AND ( finished <> :finished OR finished IS NULL )';
    $sql_param[':finished'] = '1';            
}

//$_REQUEST['projectmanager']
if( !empty($_SESSION['search']['misc']['1']) ){
    $sql_clause .= 'AND projectmanager=:projectmanager ';
    $sql_param[':projectmanager'] = $_SESSION['search']['misc']['1'];
}
//$_REQUEST['sales']
if( !empty($_SESSION['search']['misc']['2']) ){
    $sql_clause .= 'AND sales=:sales ';
    $sql_param[':sales'] = $_SESSION['search']['misc']['2'];
}    

$sql = "SELECT * FROM(
            SELECT dgn_drawing.*, master_customer.custname_en,
            master_customer.custname_sc,
            ROW_NUMBER() OVER (ORDER BY launch_date) as RowNum
            from dgn_drawing
            LEFT JOIN
            
            (SELECT
                        max(dgn_drawing.refid) as mrefid
                    FROM
                        dgn_drawing
                    GROUP BY
                        ".SUBSTRING_INDEX."(drawing_no, '-', 2)
            ) as hdr
            
            on dgn_drawing.refid= hdr.mrefid
            LEFT JOIN master_customer ON dgn_drawing.custcode = master_customer.custcode
            where hdr.mrefid is not NULL $sql_clause
        ) AS ROWCST 
        ORDER BY RowNum";    


$sth = $dbh->prepare($sql);
$sth->execute( $sql_param );

                        
$hasPrev = false;
$hasNext = false;

while($r = $sth->fetch() ) {
    if( $r['RowNum']==$p-1 ){
        $hasPrev = true;
    }
    if( $r['RowNum']==$p ){
        $row = $r;
//        vdump($row['refid']);        
    }
    if( $r['RowNum']>$p ){
        $hasNext = true;
        break;
    }
    $last_r = $r;
}
$sth->closeCursor();
//vdump($hasPrev, $hasNext);
$editable = true;
if( empty($row) ){
    $editable = false;
    //myerror(INVALID.WS.REQUEST);    
    //exit;
}else{
    $sql = "SELECT * FROM dgn_request WHERE request_no=:request_no order by refid DESC";
    $sth = $dbh->prepare($sql);
    $sth->execute(  array(':request_no' => $row['req_no']) );
    $request = $sth->fetch();
    //vdump($request);        
}

?><!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" />
<?php require_once "inc/jsheader.php"; ?>
<script>
$(function() {
    $( ".prevbtn" ).button({
      icons: {
        primary: "ui-icon-seek-prev"
      }
    });
    
    $( ".nextbtn" ).button({
      icons: {
        primary: "ui-icon-seek-next"
      }
    })
});
</script>
</head>
<body>

<form action="dgn_drawing_valid.php" name="myform" id="myform" method="post" enctype="multipart/form-data">
<input type="hidden" name="action" value="drawing_validform" />
<input type="hidden" name="refid" value="<?=$row['refid']?>" />
<input type="hidden" name="p" value="<?=$p?>" />
<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" colspan="2"><table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr><?php if($editable){ 
              $onCloseForm = 'onclick="return ConfirmSave(\'myform\')"';?>
                <td width="20" class="separator"><input type="image" src="image/icon_save.jpg" width="20" height="20" class="pressnhide2" /><?php  } ?></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"><a href="dgn_drawing_print.php?refid=<?=$row['refid']?>" target="_new"><?=PRINT_?></a></td>-->
                <td class="separator stext1"><?=DRAWING?> - <span><?=MODIFY?></span></td>
                <td class="separator etext1"><?=$row['custcode']?> - <span><a href="dgn_drawing_modifyform.php?refid=<?=$row['refid']?>" class="fbox"><?=$row['drawing_no']?></a></span></td>
                <td class="separator etext1 mod_menu">
                <?php if( $hasPrev ) { ?>
                <a href="dgn_drawing_validform.php?p=<?=($p-1)?>" class="prevbtn"><?=PREVIOUS?></a>
                <?php } ?>
                <?php if( $hasNext ) { ?>
                <a href="dgn_drawing_validform.php?p=<?=($p+1)?>" class="nextbtn"><?=NEXT?></a>
                <input type="hidden" name="hasNext" value="<?=($p+1)?>" />
                <?php } ?>
                </td>
                <td width="200" align="right" class="separator etext2"><?=LAST_MODIFY?>: <?=lastUpdate($row)?></td>
                <td width="80" align="right" class="separator etext2"><a href="dgn_drawing_index.php?act=resume" <?=$onCloseForm?> class="closebtn"><?=CLOSE?></a>  
  <input type="hidden" name="godest" id="godest" />
  <input type="hidden" name="formdest" value="dgn_drawing_index.php?act=resume" />
  </a>
  </td>
              </tr>
            </table></td>
          </tr>
          <tr>
            <td valign="top" class="c2_bg">
            <!--main form-->
<?php if( $editable ) {?>            
<!--editable-->
    <div id="tabs" class="ui-tabs0">
    <ul>
        <li><a href="#tabs-2"><?=DESIGN_VALID?></a></li>
    </ul>
    <div id="scontent">
        <div id="tabs-2">
        <table border="0" width="100%">
        <tr>
            <td colspan="2"><select name="status" id="status"><?=master_option("DRAWING_STATUS", $row['status'], true)?></select><input type="hidden" name="last_status" value="<?=$row['status']?>" /></td>
        </tr>
        <tr>
            <td rowspan="2" width="200px" class="tdvaligntop">
            <!-- drawing -->
            <?=showTDwgList($row['refid'], false)?>
            <!-- end of drawing -->            
            </td>
            <td class="tdvaligntop">
    
            </td>
        </tr>
        <tr>
            <td class="tdvaligntop">
            <!-- info -->
<table width="100%" border="0">
            <!-- remark -->

    <tr>
        <td colspan="2" class="title1"><?=DRAWING.WS.REMARKS?></td>
    </tr>
    <tr>
        <td colspan="2"><?=nl2br($row['client_remark'])?></td>
    </tr>
    <tr>
        <td colspan="2" class="title1"><?=REQUEST.WS.REMARKS?></td>
    </tr>
    <tr>
        <td colspan="2"><?=nl2br($row['client_remark'])?></td>
    </tr>

            <!-- end of remark -->
    <tr>
        <td class="title1"><?=CUSTOMER.WS.REQUEST?></td>
        <td><input type="hidden" name="customer_name" value="<?=$row['customer_name']?>" /></td>
    </tr>
<?php
if( $row['isnewcust'] ){
    $checked = 'checked="checked"';
?>    
    <tr id="newcust_row" <?=$newcust_row?> >        
        <td><?=TEMP.WS.CUSTOMER?></td>
        <td><?=$row['clientname']?> (<?=TEMP.WS.CODE?>:<?=$row['custcode']?>)</td>
    </tr>
<?php } else { ?>    
    <tr id="oldcust_row" <?=$oldcust_row?> >        
        <td><?=CUSTOMER?></td>
        <td><?=resolveCode_masterCustomer($row['custcode'])?>&nbsp;(<?=$row['custcode']?>)<input type="hidden" name="custcode" value="<?=$row['custcode']?>" /></td>    
    </tr>        
<?php  } ?>

    <tr>        
        <td><?=REQ_ORG?></td>
        <td><?=$row['request_origine']?></td>    
    </tr>
    <tr>
        <td><?=TARGET.WS.DATE?></td>
        <td><?=datef($row['target_date'])?></td>
    </tr>
    <tr>
        <td><?=REQUEST.WS.FORM.WS.APPROVAL.WS.DATE?></td>
        <td><?=datef($row['req_approval_date'])?></td>
    </tr>
    <tr>
        <td><?=REQUEST.WS.NUMBER?></td>
        <td><a href="dgn_request_modifyform.php?request_no=<?=$row['req_no']?>" class="fbox"><?=$row['req_no']?></a></td>
    </tr>
    <tr>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
    </tr>    
    
    <tr>
        <td class="title1"><?=PRODUCT.WS.DETAIL?></td>
        <td>&nbsp;</td>
    </tr>    
    <tr>
        <td><?=PRODUCT_TYPE?></td>
        <td><?=$row['pdt_type']?></td>
    </tr>
    <tr>        
        <td><?=DESIGNER.WS.NAME?></td>
        <td><?=$row['designer_name']?></td>    
    </tr>    
    <tr>
        <td><?=TIME_SPENDED?></td>
        <td><?=emptyIfZero(numf($row['time_spended']))?></td>
    </tr>
    <tr>
        <td><?=FINGERSIZE?></td>
        <td><?=$request['pdt_r_finger_size']?></td>
    </tr>    
           
</table>
            <!-- end of info -->    
            </td>
        </tr>
        </table>
        

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

            <!-- end of mainform-->
            </td>
            <!--<td valign="top" width="20px">.</td>-->
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
</form>


</body>
</html>