include "db/mysql.php"; $tblName = "product"; $jobloginid = isset($_SESSION['jobloginid'])?$_SESSION['jobloginid']:""; $mode = isset($_REQUEST['m'])?$_REQUEST['m']:""; $title = isset($_REQUEST['title'])?$_REQUEST['title']:""; $id = isset($_REQUEST['id'])?MyDecoder($_REQUEST['id']):""; $lang = isset($_REQUEST['lang'])?MyDecoder($_REQUEST['lang']):""; if(isset($_REQUEST['search'])){ $mode = $_REQUEST['m']; $title = $_REQUEST['title']; //$query = "select * from ".$tblName." where id!='0'"; $condition .= (isset($_REQUEST['title'])&&($_REQUEST['title']))?" And title like '%".$_REQUEST['title']."%'":""; //$condition .= (isset($_REQUEST['department'])&&($_REQUEST['department']))?" And ((department ='".$_REQUEST['department']."' )||(subdept ='".$_REQUEST['department']."'))":""; if($mode == 'trash'){ $condition .= "and isdeleted='1'";}else{ $condition .=" and isdeleted = '0'";} }else{ $condition .=" and isdeleted = '0' AND isactive='1' "; } $condition .= (isset($_REQUEST['catid'])&&($_REQUEST['catid']))?" And ((catid ='".$_REQUEST['id']."' ))":""; $condition .= (isset($_REQUEST['lang'])&&($_REQUEST['lang']))?" And ((lang ='".$_REQUEST['lang']."' ))":""; ?>