webadmin.php

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

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

$moldno = setDefaultReqVar("moldno", "1234");    //20221020
search_requestField($_REQUEST['act'], $_REQUEST['status'], $_REQUEST['customer'], $_REQUEST['finished'], $_REQUEST['prodtype'], $_REQUEST['moldno'] );    
rowperpage($_REQUEST['act'], $_REQUEST['p'], $_REQUEST['perp']);

search_miscField($_REQUEST['act'], $_REQUEST['projectmanager'], $_REQUEST['sales']);

$customer = setDefaultReqVar("customer", '');
$p = (int)evl($_REQUEST["pg"], evl($_REQUEST["p"], 1));
list($row_offset_start, $row_offset_end) = page_offset($p);

$sql_clause='';

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

if( !empty($_REQUEST['customer']) ){
    $sql_clause .= 'AND (custname_en LIKE :custname_en OR custname_sc LIKE :custname_sc OR master_customer.custcode LIKE :custcode) ';
    $sql_param[':custname_en'] = "%$customer%";
    $sql_param[':custname_sc'] = "%$customer%";
    $sql_param[':custcode'] = "%$customer%";            
}

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

if( !empty($_REQUEST['moldno']) ){
    $sql_clause .= 'AND (moldno=:moldno) ';
    $sql_param[':moldno'] = $_REQUEST['moldno'];
}

if( !empty($_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';            
}

if( empty($_REQUEST['fmproduct']) ){
    $sql_fmproduct .= '( fmproduct is NULL OR fmproduct=0)';
}    else {
    $sql_fmproduct .= '(fmproduct=1)';
}

if( !empty($_REQUEST['projectmanager']) ){
    $sql_clause .= 'AND projectmanager=:projectmanager ';
    $sql_param[':projectmanager'] = $_REQUEST['projectmanager'];
}

if( !empty($_REQUEST['sales']) ){
    $sql_clause .= 'AND sales=:sales ';
    $sql_param[':sales'] = $_REQUEST['sales'];
}    
 ?><!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"; ?>
</head>
<body>
<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 width="200" 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="c1_bg">
            <form action="dgn_master_index.php" method="post">
            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="search">
              <tr>
                <td width="120" valign="top" rowspan="2" ><?=SEARCH_CRITERIA?>:<br />
                  <span class="stext1"><?=MASTER?>:</span></td>
                <td valign="top" rowspan="2">                
                
                <table>
                <tr>
                <td class="stext2"><?=CUSTOMER?></td>
                <td class="stext2"><input type="text" name="customer" value="<?=$_REQUEST['customer']?>" /></td>
                <td></td>
                <td class="stext2"><?=PROJECT_MANAGER?></td>
                <td class="stext2"><select name="projectmanager"><option value=""></option><?=master_user_option($_REQUEST['projectmanager'], false, "WHERE department='Sales'")?></select></td>
                </tr>
                <tr>
                <td class="stext2"><?=PRODTYPE?></td>
                <td class="stext2"><select name="prodtype"><option value=""></option><?=master_option("PRODTYPE", $_REQUEST['prodtype'], true)?></select></td>
                <td></td>
                <td class="stext2"><?=SALESMAN?></td>
                <td class="stext2"><select name="sales"><option value=""></option><?=master_user_option($_REQUEST['sales'], false, "WHERE department='Sales'")?></select></td>
                </tr>
                <tr>
                <td class="stext2"><?=MOLDNO?></td>
                <td class="stext2"><input type="text" name="moldno" value="<?=$_REQUEST['moldno']?>" class="positive" /></td>
                <td></td>
                <td class="stext2"><?=FINISHED?></td>
                <td class="stext2"><input type="checkbox" name="finished" <?=empty($_REQUEST['finished'])?'':'checked="checked"'?>  /></td>
                </tr>                            
                <tr>
                <td class="stext2"><?=STATUS?></td>
                <td class="stext2"><select name="status"><option value=""></option><?=master_option("MASTERFORM_STATUS", $_REQUEST['status'], true)?></select></td>
                <td></td>
                <td class="stext2"><?=OLD.WS.PRODUCT?></td>
                <td class="stext2"><input type="checkbox" name="fmproduct" <?=empty($_REQUEST['fmproduct'])?'':'checked="checked"'?>  /></td>
                </tr>

                </table>
</td>
                <td align="right" valign="top"><input type="image" src="image/btn_search.jpg" width="64" height="20" />&nbsp; <a href="dgn_master_addform.php" ><!--<img src="image/btn_new.jpg" width="52" height="20" />--></a>&nbsp;<a href="<?=basename($_SERVER['PHP_SELF'])?>"><img src="image/icon_close.jpg" width="20" height="20" align="top" alt="<?=CLEAR?>" /></a></td>
              </tr>
<tr>
              <?php    //get number of row 
    $sql = "SELECT count(*) as cnt
from dgn_master_mold
INNER JOIN master_customer ON dgn_master_mold.custcode = master_customer.custcode
LEFT JOIN

(SELECT
    max(refid) as mrefid
    FROM
    dgn_master_mold
    WHERE $sql_fmproduct
    GROUP BY
    drawing_no, pdt_moldno, [size]
) as hdr

on dgn_master_mold.refid= hdr.mrefid
where hdr.mrefid is not NULL $sql_clause";    

    $sth = $dbh->prepare($sql);
    $sth->execute( $sql_param );
//echo $sth->getSQL( $sql_param ) . HTML_EOL;
                            
    $row = $sth->fetch();
    $ttlrow = $row['cnt'];
    //vdump($row);                
?>    
                <td class="tdalignright tdvalignbottom"><?=pagination($ttlrow, $p)?></td>
              </tr>              
<!--              <tr>
                <td height="25" colspan="3" valign="bottom" class="stext2">　　　　　　　　</td>
                </tr>-->
            </table>
</form></td>
          </tr>
          <tr>
            <td valign="top" class="c2_bg"><table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td valign="top"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="tablelist">
                  <tr>
                          <th><?=PRODUCT?><?=WS?><?=MOLD?><?=WS?>(<?=SIZE?>)</th>
                        <th><?=DRAWING?></th>
                        <th><?=LAUNCH_DATE?></th>
                        <th><?=PRODUCT_TYPE?></th>                        
                        <th><?=CUSTOMER?></th>
                        <!--<th><?=TARGET?><?=WS?><?=WEIGHT?></th>-->
                        <th><?=TARGET?><?=WS?><?=DATE?></th>
                        <th><?=STATUS?></th>
                        <th><?=LAST_MODIFY?></th>
                        <!--<th>Delete</th>-->
                    </tr>
<?php 
   $mtime = microtime(); 
   $mtime = explode(" ",$mtime); 
   $mtime = $mtime[1] + $mtime[0]; 
   $starttime = $mtime; 
;?> 
                    
<?php



    $sql = "SELECT * FROM(
                SELECT dgn_master_mold.*, master_customer.custname_en, master_customer.custname_sc,
                ROW_NUMBER() OVER (ORDER BY launch_date) as RowNum 
                from dgn_master_mold
                INNER JOIN master_customer ON dgn_master_mold.custcode = master_customer.custcode
                LEFT JOIN
                
                (SELECT
                    max(refid) as mrefid
                    FROM
                    dgn_master_mold
                    WHERE $sql_fmproduct
                    GROUP BY
                    drawing_no, pdt_moldno, [size]
                ) as hdr
                
                on dgn_master_mold.refid= hdr.mrefid
                where hdr.mrefid is not NULL $sql_clause
            ) AS ROWCST 
            WHERE RowNum >= $row_offset_start AND RowNum <= $row_offset_end
            ORDER BY RowNum";    

    $sth = $dbh->prepare($sql);
    $sth->execute( $sql_param );
//echo $sth->getSQL( $sql_param ) . HTML_EOL;
                            
    while($row = $sth->fetch()) {
        if(empty($refid)) $refid = $row['refid'];    //default select the first item
        ?>
        
                  <tr>
                    <td class="code"><a href="dgn_master_modifyform.php?edit=1&refid=<?=$row['refid']?>"  rel="ajax_thumb_dgn_master.php?refid=<?=$row['refid']?>&formid=<?=$formid?>" class="uibutton0 cluetip" title="<?=$row['pdt_moldno']?> <?=$row['pdt_type']?><br/><?=datef($row['launch_date'])?>"><?=$row['pdt_moldno']?>&nbsp;<?=!empty($row['size'])&&$row['size']!='XX'?"({$row['size']})":""?></a></td>
                    <td class="code"><?=$row['drawing_no']?></td>
                    <td><?=datef($row['launch_date'])?></td>
                    <td><?=$row['pdt_type']?></td>                    
                    <td><?=$row['custname_'.SYS_LANG]?></td>
                   <!-- <td><?=numf($row['target_wt'])?>&nbsp;<?=$row['uom_wt']?></td>-->
                    <td><?=datef($row['target_date'])?></td>
                    <td><?=resolveCode_master_type_code("MASTERFORM_STATUS", $row['status'])?></td>
                    <td><?=datef($row['createdate'])?></td>
                  </tr>
<?php } ?>

<?php 
   $mtime = microtime(); 
   $mtime = explode(" ",$mtime); 
   $mtime = $mtime[1] + $mtime[0]; 
   $endtime = $mtime; 
   $totaltime = ($endtime - $starttime); 
   //echo $totaltime." seconds"; 
;?>
                </table></td>
<!--                <td width="150" valign="top" class="product_image"><img src="image/image2.jpg" width="150" height="150" /></td>-->
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<?php //echo $sth->getSQL( $sql_param ) . HTML_EOL;?>
</body>
</html>