webadmin.php

/var/www/hkosl.com/oneMotorChunHing_delete20240201/html/product_20100531.php

<?
require("inc/configure.php");
require("inc/global.php");
require("inc/checklogin.php");
if ($logged_in == 0) {
    //echo 'Not logged in. <a href="login.php">Login</a>';
    header('Window-target: _parent');
    header('Location: login.php');
    exit();
}
if (checkObject(9) <> 1){
    die("Unauthorized Access");
    exit();
}
?>
<?
$prodid    = $_GET['prodid'];
$msg    = $_GET['msg'];

$jointdate = date("Y-m-d");
$sql = "select a.*, b.majcatid from INV_PRODUCT a
, INV_CATEGORY_MAJ b
, INV_CATEGORY_SUB c
where 
a.subcatid = c.subcatid
and b.majcatid = c.majcatid
and prodid = $prodid";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $majcatid        = $row{'majcatid'};
    $subcatid        = $row{'subcatid'};
    $supplierid        = $row{'supplierid'};
    $brandid        = $row{'brandid'};
    $prodname        = $row{'prodname'};
    $barcode        = $row{'barcode'};
    $description    = $row{'description'};
    $remarks        = $row{'remarks'};
    $size            = $row{'size'};
    $uomid            = $row{'uomid'};
    $price            = $row{'price'};
    $cost            = $row{'cost'};
    $olt            = $row{'olt'};
    $moq            = $row{'moq'};
    $msq            = $row{'msq'};
    $typeid            = $row{'typeid'};
    $status            = $row{'status'};
    $creationdate    = $row{'creationdate'};
}
/*
$sql = "
select sum(sign*qty) as soh from INV_STOCK_TRANSACTION 
        where prodid = $prodid
";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $soh = $row{'soh'};
}
else
{
    $soh = 0;
}
*/
    $soh = isnull(getSOH($prodid),0);
?>
<html>
<head>
<title><?=$systitle?></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="main.css" type="text/css">
<script type="text/javascript" src="calendarDateInput.js"></script>
<script language="JavaScript">
<!--
var emailfilter=/^\w+[\+\.\w-]*@([\w-]+\.)*\w+[\w-]*\.([a-z]{2,4}|\d+)$/i
function formCheck(formobj){
    // Enter name of mandatory fields
    var fieldRequired = Array("prodname");
    // Enter field description to appear in the dialog box
    var fieldDescription = Array("Product name");
    // dialog message
    var alertMsg = "Please complete the following fields:\n";
    var l_Msg = alertMsg.length;


    var majcatid = formobj.majcatid.value;
    if (majcatid.length == 0)
    {
        alertMsg += " - Please select maj category.\n";
    }

    var subcatid = formobj.subcatid.value;
    if (subcatid.length == 0)
    {
        alertMsg += " - Please select sub category.\n";
    }

    var price = formobj.price.value
    if (price.length > 0)
    {
        if (IsNumeric(price) == false)
        {
            alertMsg += " - Please enter expected unit price using the following format (Eg. 10000.00).\n";
        }
    }

    var cost = formobj.cost.value
    if (cost.length > 0)
    {
        if (IsNumeric(cost) == false)
        {
            alertMsg += " - Please enter expected standard cost using the following format (Eg. 10000.00).\n";
        }
    }

    var moq = formobj.moq.value
    if (moq.length > 0)
    {
        if (IsNumeric(moq) == false)
        {
            alertMsg += " - Please enter expected MOQ using the following format (Eg. 10000.00).\n";
        }
    }

    var msq = formobj.msq.value
    if (msq.length > 0)
    {
        if (IsNumeric(msq) == false)
        {
            alertMsg += " - Please enter expected MSQ using the following format (Eg. 10000.00).\n";
        }
    }

    var olt = formobj.olt.value
    if (olt.length > 0)
    {
        if (IsNumeric(olt) == false)
        {
            alertMsg += " - Please enter expected OLT using the following format (Eg. 10000.00).\n";
        }
    }

    for (var i = 0; i < fieldRequired.length; i++){
        var obj = formobj.elements[fieldRequired[i]];
        if (obj){
            switch(obj.type){
            case "select-one":
                if (obj.selectedIndex == -1 || obj.options[obj.selectedIndex].text == ""){
                    alertMsg += " - " + fieldDescription[i] + "\n";
                }
                break;
            case "select-multiple":
                if (obj.selectedIndex == -1){
                    alertMsg += " - " + fieldDescription[i] + "\n";
                }
                break;
            case "text":
            case "textarea":
                if (obj.value == "" || obj.value == null){
                    alertMsg += " - " + fieldDescription[i] + "\n";
                }
                break;
            default:
            }
            if (obj.type == undefined){
                var blnchecked = false;
                for (var j = 0; j < obj.length; j++){
                    if (obj[j].checked){
                        blnchecked = true;
                    }
                }
                if (!blnchecked){
                    alertMsg += " - " + fieldDescription[i] + "\n";
                }
            }
        }
    }

    if (alertMsg.length == l_Msg){
        return submitForm();
    }else{
        alert(alertMsg);
        return false;
    }
}
function IsNumeric(sText)
{
    var ValidChars = "0123456789.";
    var IsNumber=true;
    var Char;


    for (i = 0; i < sText.length && IsNumber == true; i++) 
    { 
        Char = sText.charAt(i); 
        if (ValidChars.indexOf(Char) == -1) 
        {
            IsNumber = false;
        }
    }
    return IsNumber;

}
function y2k(number) { return (number < 1000) ? number + 1900 : number; }

function daysElapsed(date1,date2) {
    var difference =
        Date.UTC(y2k(date1.getYear()),date1.getMonth(),date1.getDate(),0,0,0)
      - Date.UTC(y2k(date2.getYear()),date2.getMonth(),date2.getDate(),0,0,0);
    return difference/1000/60/60/24;
}
function submitForm() {
    return true;
}
// -->

</script>
<!--category start-->
<script language="javascript" src="categoryselects.js">
</script>
<script language="javascript" src="categoryconfig.php?majcatid=<?=$majcatid?>&subcatid=<?=$subcatid?>"></script>
<!--category end-->

<!--popup start-->
<script language="javascript">
function popups(lnk,t)
{
    window.open(lnk,t,"height=400,width=550,scrollbars=yes")
}
</script>
<!--popup end-->

</head>
<body bgcolor="#FFFFFF" leftmargin="10" topmargin="10" marginwidth="0" marginheight="0" onload="initListGroup('vehicles', document.forms[0].majcatid, document.forms[0].subcatid, '')">

<p class="pageheader">Product Management</p>
<p class="contentmsg"><?=$msg?></p>
<form action="productadd.php" name="addform" method="post" onsubmit="return formCheck(this);">
<input type="hidden" name="prodid" value="<?=$prodid?>">
<table>
    <tr><td valign="top" width="760" class="content">
        <a href="product.php"><img src="icons/new.jpg" border="0"></a>
        <input type="image" name="btnsave" src="icons/save.jpg">
        <a href="productsearch.php"><img src="icons/list.jpg" border="0"></a>
<!--
        <img src="icons/cancel.jpg">
        <hr><br>
        <img src="images/iconConfig.png"><br>List<br>
        <hr><br>
        <img src="images/iconConfig.png"><br>History<br>
        <hr><br>
        <img src="images/iconConfig.png"><br>Category<br>
        <img src="images/iconConfig.png"><br>Spplier<br>
        <img src="images/iconConfig.png"><br>Brand<br>
        <img src="images/iconConfig.png"><br>UOM<br>
-->
    </td></tr>
    <tr><td>
    <table width="760">
    <tr><td class="content" width="140">Product code:</td>
        <td class="content" width="240"><?=$prodid?></td>
        <td class="content" width="140">Status:</td>
        <td width="240"><select class="content" name="status"><?=selectstatus($status);?></select></select></td>
    </tr>
    <tr><td class="content">Major category:</td>
        <td><select class="contentman" id="majcatid" name="majcatid"></select></select></td>
        <td class="content">Size:</td>
        <td><input type="text" class="content" size="10" name="size" maxlength="50" value="<?=$size?>"></td>
    </tr>
    <tr><td class="content">Sub category:</td>
        <td><select class="contentman" id="subcatid" name="subcatid"></select></td>
        <td class="content">UOM:</td>
        <td><select class="contentman" name="uomid"><?=selectuomid($uomid);?></select></td>
    </tr>
    <tr><td class="content">Supplier</td>
        <td><select class="contentman" name="supplierid"><?=selectsupplierid($supplierid);?></select></td>
        <td class="content">Unit price:</td>
        <td><input type="text" class="content" size="5" name="price" maxlength="12" style="text-align:right" value="<?=$price?>"></td>
    </tr>
    <tr><td class="content">Brand:</td>
        <td><select class="contentman" name="brandid"><?=selectbrandid($brandid);?></select></td>
        <td class="content">Standard cost:</td>
        <td><input type="text" class="content" size="5" name="cost" maxlength="12" style="text-align:right" value="<?=$cost?>"></td>
    </tr>
    <tr><td class="content">Product name:</td>
        <td><input type="text" class="contentman" size="30" name="prodname" maxlength="50" value="<?=$prodname?>"></td>
        <td class="content">MOQ:</td>
        <td><input type="text" class="content" size="5" name="moq" maxlength="12" style="text-align:right" value="<?=$moq?>"></td>
    </tr>
    <tr><td class="content">Barcode:</td>
        <td><input type="text" class="content" size="20" name="barcode" maxlength="20" value="<?=$barcode?>"></td>
        <td class="content">MSQ:</td>
        <td><input type="text" class="content" size="5" name="msq" maxlength="12" style="text-align:right" value="<?=$msq?>"></td>
    </tr>
    <tr><td rowspan="3" class="content" valign="top">Description:</td>
        <td rowspan="3"><textarea rows="5" cols="30" name="description" class="content" onkeyup="return ismaxlength(this)"><?=$description?></textarea></td>
        <td class="content">OLT:</td>
        <td class="content"><input type="text" class="content" size="5" name="olt" maxlength="6" style="text-align:right" value="<?=$olt?>"> Days</td>
    </tr>
    <tr><td class="content" valign="top">SOH:</td>
        <td valign="top"><input type="text" class="content" size="5" name="soh" style="text-align:right" value="<?=$soh?>" disabled></td>
    </tr>
    <tr><td class="content" valign="top">Type:</td>
        <td valign="top"><select class="contentman" name="typeid"><?=selecttypeid($typeid);?></select></td>
    </tr>
    <tr><td class="content" valign="top">Remarks:</td>
        <td><textarea rows="5" cols="30" name="remarks" class="content" onkeyup="return ismaxlength(this)"><?=$remarks?></textarea></td>
        <td></td><td></td>
    </tr>
    </table>
</td></tr>
</table>
</form>

</body>
</html>