webadmin.php

/var/www/hkosl.com/oneMotorChunHing_delete20240201/html/customer.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(4) <> 1){
    die("Unauthorized Access");
    exit();
}
?>
<?
$forname    = $_REQUEST['formname'];
$fieldname    = $_REQUEST['fieldname'];
$keyword    = $_REQUEST['keyword'];
?>
<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">

<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>

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

</head>
<body bgcolor="#FFFFFF" leftmargin="10" topmargin="10" marginwidth="0" marginheight="0">

<p class="pageheader"><?=customermaster?></p>

<table border='0' cellpadding='0' cellspacing='0'>
    <tr><td valign="top" width="740" class="content">
        <a href="customerdetail.php"><img src="icons/new.jpg" border="0"></a>
        </td></tr>
</table>
<div id="example">
  <?php
    $selectedYear = (int)$_REQUEST['year'];
    $selectedMonth = (int)$_REQUEST['month'];

    $currentYear = date('Y');
    $currentMonth = date('m');

    ?>
        <form action='customer.php' method='post'>
            <div class="tableFilter">
            <select id="name" id="column" name="column">
                <option value="1" <?=$_REQUEST['column']==1?'selected="selected"':''?> ><?=custno?></option>
                <option value="2" <?=$_REQUEST['column']==2?'selected="selected"':''?> ><?=licno?></option>
                <option value="3" <?=$_REQUEST['column']==3?'selected="selected"':''?> ><?=modelno?></option>
                <option value="4" <?=$_REQUEST['column']==4?'selected="selected"':''?> ><?=chassisno?></option>
                <option value="5" <?=$_REQUEST['column']==5?'selected="selected"':''?> ><?=custname?></option>
                <option value="7" <?=$_REQUEST['column']==7?'selected="selected"':''?> ><?=telno?></option>
            </select>
            <input type="text" id="keyword" name="keyword" value="<?=$keyword?>"/>
            <input type="submit" value="Submit" />
            <input type="button" value="Clear" onclick="window.location='customer.php';" />
            <br/>
            牌費到期:
            年份: <select name="year">
                    <option value=""></option>
                    <?php
                    for($i=$currentYear+5; $i>=2011; $i--){
                        if($selectedYear == $i){
                            echo "<option value='$i' selected='selected'>$i</option>";
                        }
                        else{
                            echo "<option value='$i'>$i</option>";
                        }
                    }
                    ?>
                </select> &nbsp;
            月份: <select name="month">
                    <option value=""></option>
                    <?php
                    for($i=1; $i<=12; $i++){
                        if($selectedMonth == $i){
                            echo "<option value='$i' selected='selected'>$i</option>";
                        }
                        else{
                            echo "<option value='$i'>$i</option>";
                        }
                    }
                    ?>
                </select> &nbsp;
    <!-- <input type="submit" value="Submit" /> -->
    </form>

    </div>
    <table id="myTable" cellpadding="0" cellpadding="0">
        <thead>
            <th axis="string"></th>
            <th axis="string"><?=custno?></th>
            <th axis="string"><?=licno?></th>
            <th axis="string"><?=modelno?></th>
            <th axis="string"><?=chassisno?></th>
            <th axis="string"><?=custname?></th>
            <th axis="string">牌費到期</th>
            <th axis="string"><?=telno?></th>
        </thead>
    <tbody>

<?

if($_REQUEST['column'] && $_REQUEST['keyword']){
    switch ($_REQUEST['column']) {
        case 1:
            $column = 'custno';
            break;
        case 2:
            $column = 'licno';
            break;
        case 3:
            $column = 'modelno';
            break;
        case 4:
            $column = 'chassisno';
            break;
        case 5:
            $column = 'custnameeng';
            break;
        case 7:
            $column = 'telno';
            break;
        default:
            $column = 'custno';
    }
    $filterSql = "and {$column} LIKE '%" . mysql_real_escape_string($_REQUEST['keyword']) . "%'";
}
if($_REQUEST['year']){
    $filterSql = "and year(licence_expiry_date) = '" . (int)$_REQUEST['year'] . "'";
}
if($_REQUEST['month']){
    $filterSql = "and month(licence_expiry_date) = '" . (int)$_REQUEST['month'] . "'";
}

$sql = "SELECT
a.custid,
a.custno,
a.custnameeng,
a.telno,
licno,
modelno,
chassisno,
a.`status`,
carid,
licence_expiry_date
from CM_CUSTOMER a
left outer join
CM_CAR b
on a.custid = b.custid
where a.status = 1 and b.status=1
$filterSql
order by custnameeng
";
$result = mysql_query($sql);
$n = 1;
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
?>
    <tr id="<?=$row{'custid'}?>">
        <td><a href='customerdetail.php?custid=<?=$row{'custid'}?>'><img src='images/btnedit.png' border='0'></a>
            <img src='images/btnedit.png' border='0' onclick="popups('cardetail.php?custid=<?=$row{'custid'}?>&carid=<?=$row{'carid'}?>')"></td>
        <td><?=$row{'custno'}?></td>
        <td><?=isnull($row{'licno'},'n/a')?></td>
        <td><?=isnull($row{'modelno'},'n/a')?></td>
        <td><?=isnull($row{'chassisno'},'n/a')?></td>
        <td><?=$row{'custnameeng'}?></td>
        <td><?=$row{'licence_expiry_date'}?></td>
        <td><?=$row{'telno'}?></td>
    </tr>
<?
    $n++;
}
?>

        </tbody>
            <tfoot>
            <tr>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
                <td></td>
            </tr>
        </tfoot>
      </table>

    <script type="text/javascript">
        var myTable = {};
        window.addEvent('domready', function(){
            myTable = new sortableTable('myTable', {overCls: 'over', onClick: function(){
                //alert(this.id)
                    }});
        });
    </script>
    </div>

</div>
<script type="text/javascript">
var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
</script>
<script type="text/javascript">
var pageTracker = _gat._getTracker("UA-3333085-1");
pageTracker._initData();
pageTracker._trackPageview();
</script>
&nbsp;<br />
</body>
</html>