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