include('lib/data.class.php'); $obj=new data("psuggestion"); $method=new method(); if(empty($_REQUEST['page'])) $_REQUEST['page']=1; if(empty($_REQUEST['limit'])) $_REQUEST['limit']=20; /*if(empty($_REQUEST[sdate])) $_REQUEST[sdate]=$method->conDate(date("Y-m-d")); if(empty($_REQUEST[edate])) $_REQUEST[edate]=$method->conDate(date("Y-m-d"));*/ if($_SESSION[admin_flag]!='1') $_cond=" AND pr.req_user_id='".$_SESSION[user_id]."'"; if(!empty($_REQUEST[sdate])) $_cond.=" AND DATE(pr.req_date) >= '".$method->cvDate($_REQUEST[sdate])."'"; if(!empty($_REQUEST[edate])) $_cond.=" AND DATE(pr.req_date) <= '".$method->cvDate($_REQUEST[edate])."'"; if(!empty($_REQUEST[sdate2])) $_cond.=" AND DATE(pr.order_date) >= '".$method->cvDate($_REQUEST[sdate2])."'"; if(!empty($_REQUEST[edate2])) $_cond.=" AND DATE(pr.order_date_ <= '".$method->cvDate($_REQUEST[edate2])."'"; if($_REQUEST[cond]==2) $_cond.=" AND pr.order_id IS NULL"; if($_REQUEST[cond]==3) $_cond.=" AND pr.order_id IS NOT NULL"; $cmd="SELECT pr.* FROM req_attach pr INNER JOIN puser pu ON pr.req_user_id=pu.user_id WHERE 1 ".$_cond." ORDER BY pr.req_id DESC"; $data=$obj->getAllCmdData($cmd, $_REQUEST['page'],$_REQUEST['limit']); ?>