if (isset($_GET["searchStr"]) and $_GET["searchStr"] != NULL) {
$conditions .= " where tblcustomer.cus_username like '%" . sqlInjection($_GET['searchStr']) . "%'";
}
}
//echo $conditions;
$start = $pag->findStart($limit);
$querycount = "SELECT tblorder.order_id FROM tblcustomer INNER JOIN tblorder ON tblcustomer.cus_id = tblorder.cus_id " . $conditions;
$count = mysql_num_rows(mysql_query($querycount));
$pages = $pag->findPages($count, $limit);
if (isset($_GET['page']) or is_numeric($_GET['page'])) {
$paging = " LIMIT " . $start . "," . $limit . " ";
} else {
$paging = " LIMIT 0," . $limit . " ";
}
$listorder = $ord->getListOrder($conditions, $paging);
$page_list = $pag->pageList($_GET['page'], $pages);
?>
<script language="javascript" type="text/javascript">
var condistion = "";
function submitFilterOrder(){
if(document.forms['orderFilter']['orderStatus'].value!=""){
condistion += "&orderStatus="+document.forms['orderFilter']['orderStatus'].value;
}
if(document.forms['orderFilter']['searchStr'].value!=""){
condistion += "&searchStr="+document.forms['orderFilter']['searchStr'].value;
}
window.location.href = "admincp.php?opt=listorder"+encodeURI(condistion);
condistion="";
}
$pag = new Page();
$conditions = " WHERE tblorder.cus_id=" . sqlInjection($_SESSION['user_id']) . "";
if (isset($_GET["orderStatus"])) {
$conditions .= " and tblorder.order_status =" . sqlInjection($_GET['orderStatus']) . " ";
}
$start = $pag->findStart($limit);
$querycount = "SELECT tblorder.order_id FROM tblcustomer INNER JOIN tblorder ON tblcustomer.cus_id = tblorder.cus_id " . $conditions;
$count = mysql_num_rows(mysql_query($querycount));
$pages = $pag->findPages($count, $limit);
if (isset($_GET['nav']) or is_numeric($_GET['nav'])) {
$paging = " LIMIT " . $start . "," . $limit . " ";
} else {
$paging = " LIMIT 0," . $limit . " ";
}
$listorder = $ord->getListOrder($conditions, $paging);
$page_list = $pag->pageList($_GET['nav'], $pages);
?>
<style>
table tr{
border:dotted thin;
}
th{
background:#CCC;
color:#333;
}
</style>
<script language="javascript" >
function open_me(url,width,height)
{
var str = "width="+width+",height="+height+",scrollbars=1,left=300,top=300,titlebar=no,status=0,menubar=0,";
myWindow=window.open(url,'',str);
