webadmin.php

/var/www/hkosl.com/oneMotorChunHing_delete20240201/html/cardetail.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();
}
?>
<?
$custid    = $_GET['custid'];
$carid    = $_GET['carid'];
?>
<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>

<link rel="stylesheet" href="_common/css/main.css" type="text/css" media="all">
<link href="sortableTable.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="_common/js/mootools.js"></script>
<script type="text/javascript" src="sortableTable.js"></script>

<script type="text/javascript" src="//code.jquery.com/jquery-1.7.2.min.js"></script>
<link rel="stylesheet" href="//code.jquery.com/ui/1.7.3/themes/base/jquery-ui.css" />
<script type="text/javascript" src="//code.jquery.com/ui/1.7.3/jquery-ui.min.js"></script>

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

$(function() {
    $( ".datepicker" ).datepicker({dateFormat: "yy-mm-dd"});
});
</script>
<!--popup end-->

</head>
<body bgcolor="#FFFFFF" leftmargin="10" topmargin="10" marginwidth="0" marginheight="0">
<!--********************************************************-->
<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();
    // Enter field description to appear in the dialog box
    var fieldDescription = Array();
    // dialog message
    var alertMsg = "Please complete the following fields:\n";
    var l_Msg = alertMsg.length;
    var x = 0;

    // check caryear start
    //var caryear = formobj.caryear.value
    //if (caryear.length > 0)
    //{
    //    if (IsNumeric(caryear) == false)
    //    {
    //        alertMsg += " - Please enter expected Year using the following format (Eg. YYYY).\n";
    //    }
    //}
    // check caryear end
    var licno = formobj.licno.value
    var chassisno = formobj.chassisno.value

    if (licno.length == 0)
    {
        x = 1;
    }
    if (chassisno.length == 0)
    {
        if (x == 1)
        {
            alertMsg += " - Please enter <?=licno?> or <?=chassisno?>\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>
<script type="text/javascript">

var emailfilter=/^\w+[\+\.\w-]*@([\w-]+\.)*\w+[\w-]*\.([a-z]{2,4}|\d+)$/i

function checkmail(e){
var returnval=emailfilter.test(e.value)
if (returnval==false){
alert("Please enter a valid email address.")
e.select()
}
return returnval
}
</script>
<!--********************************************************-->
<form action="cardetail.php" name="custform" method="get">
    <input type="hidden" name="carid" value="<?=$carid?>">
    <input type="hidden" name="custid">
</form>
<!--********************************************************-->
<?
$jointdate = date("Y-m-d");
$sql = "
select *
from CM_CAR
where carid = $carid
";
$result = mysql_query($sql);
$date = date("Y-m-d");
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $carid        = $row{'carid'};
    $licno        = $row{'licno'};
    $modelno    = $row{'modelno'};
    $chassisno    = $row{'chassisno'};
    $caryear    = $row{'caryear'};
    $status        = $row{'status'};
    $licence_expiry_date    = $row{'licence_expiry_date'}=='0000-00-00' ? '' : $row{'licence_expiry_date'};
}

$sql = "select *
        from CM_CUSTOMER
        where custid = $custid
        ";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
    $custno            = $row{'custno'};
    $custnameeng    = $row{'custnameeng'};
}
?>
<p class="pageheader">Car information</p>
<p class="contentmsg"><?=$msg?></p>
<form action="caradd.php" name="addform" method="post" onsubmit="return formCheck(this);">
<input type="hidden" name="custid" value="<?=$custid?>">
<input type="hidden" name="carid" value="<?=$carid?>">
<table border='0' cellpadding='0' cellspacing='0'>
    <tr><td valign="top" width="500" class="content">
        <input type="image" name="btnsave" src="icons/save.jpg">
    </td></tr>
    <tr><td>
        <table width="500" cellpadding='0' cellspacing='0'>
        <tr><td class="content"><?=custno?>:&nbsp;<img src="images/browser.png" border="0" onclick="popups('customerpopup.php?formname=custform&fieldname=custid')"></td>
            <td><input type="text" name="custno" value="<?=$custno?>" class="content" size="10" readonly>&nbsp;<?=$custnameeng?></td>

        <tr><td class="content"><?=licno?>:</td>
            <td><input type="text" class="content" size="30" name="licno" maxlength="30" value="<?=$licno?>"></td>
        </tr>
        <tr><td class="content"><?=modelno?>:</td>
            <td><input type="text" class="content" size="30" name="modelno" maxlength="30" value="<?=$modelno?>"></td>
        </tr>
        <tr><td class="content"><?=chassisno?>:</td>
            <td><input type="text" class="content" size="30" name="chassisno" maxlength="50" value="<?=$chassisno?>"></td>
        </tr>
        <tr><td class="content"><?=caryear?>:</td>
            <td><input type="text" class="content" size="10" name="caryear" maxlength="50" value="<?php echo $caryear; ?>"></td>
        </tr>
        <tr><td class="content">牌費到期:</td>
            <td><input type="text" class="content datepicker" size="10" name="licence_expiry_date" maxlength="50" value="<?php echo $licence_expiry_date; ?>"></td>
        </tr>
        <tr><td class="content"><?=status?>:</td>
            <td><select class="content" name="status"><?=selectstatus($status);?></select></td>
        </tr>
        </table>
    </td></tr>
</table>
</form>

<br>
<table width="700">
    <tr><td width="100">Date</td>
        <td width="60"><?=mileage?></td>
        <td width="360">Product</td>
        <td width="60">Qty</td>
        <td width="60">UOM</td>
        <td width="60">Amount</td></tr>
<?
    $sql = "SELECT
    a.orderdate
    , a.mileage
    , b.prodid
    , b.prodname
    , b.qty
    , b.uom
    , b.amount
    , a.invoiceno
    , b.lineno
    from OM_INVOICE_HDR a
    , OM_INVOICE_DTL b
    where a.invoiceno = b.invoiceno
    and carid = $carid
    order by orderdate desc, a.invoiceno, b.lineno";
    $result = mysql_query($sql);
    $n = 1;
    while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
    {
?>
        <tr>
            <td><?=$row{'orderdate'}?></td>
            <td><?=$row{'mileage'}?></td>
            <td><?=$row{'prodname'}?></td>
            <td><?=$row{'qty'}?></td>
            <td><?=$row{'uom'}?></td>
            <td><?=$row{'amount'}?></td>
        </tr>
<?
    }
?>

</table>
</body>
</html>