function lister()
 {
     $newsOb = new NewsModel();
     $newsTypeOb = new NewstypeModel();
     $arr = $newsTypeOb->getNewsTypeList();
     //var_dump($arr);
     $keyword = $_GET['keyword'];
     $type = $_GET['type'];
     $where = "";
     if ($keyword != '') {
         $where .= " title like '%{$keyword}%'";
     }
     if ($type != '') {
         if ($keyword != '') {
             $where .= "and type='{$type}'";
         } else {
             $where = " type='{$type}'";
         }
     }
     //echo $where;
     import("ORG.Util.Page");
     $pageOb = new Page(10, $newsOb->getNewsCount($where));
     $start = $pageOb->getStartStr();
     $nArr = $newsOb->getNewsList($start, 10, $where);
     $pageStr = $pageOb->getPageStr1(1);
     //var_dump($arr);
     $this->assign("arr", $arr);
     $this->assign("nArr", $nArr);
     $this->assign("pageStr", $pageStr);
     $this->display();
 }
 public function getlist()
 {
     $where = " (status=0 or status=1 or status=2)";
     $page = 1;
     $size = 15;
     if (!empty($_GET)) {
         if ($_GET['page'] != "") {
             $page = $_GET['page'];
         }
         if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
             $where .= " and deadTime >= '" . $_GET['start_time'] . "'";
         }
         if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
             $where .= " and deadTime <= '" . $_GET['end_time'] . " 23:59:59'";
         }
         if ($_GET['code'] != "") {
             $where .= " and code = '" . $_GET['code'] . "'";
         }
         if ($_GET['type'] != "") {
             $where .= " and type =" . $_GET['type'];
         }
         if ($_GET['inPrice'] != "") {
             $where .= " and inPrice =" . $_GET['inPrice'];
         }
         if ($_GET['status'] != "") {
             $where .= " and status =" . $_GET['status'];
         }
         if ($_GET['size'] != "") {
             $size = $_GET['size'];
         }
     }
     $reOb = new YhqModel();
     $num = $reOb->getCount($where);
     //var_dump($num);
     import("ORG.Util.Page1");
     $pageOb = new Page($page, $size, $num);
     //var_dump($pageOb);
     $start = $pageOb->getStartStr();
     $reArr = $reOb->getList($where, $start, $size);
     //var_dump($reArr);echo $reOb->getLastSql();
     $pageStr = $pageOb->getPageStr1(1);
     //var_dump($reArr);
     $arr = array('page' => $pageStr, 'data' => $reArr);
     //var_dump($data);
     $data = json_encode($arr);
     echo $data;
 }
 public function getlist()
 {
     $where = " 1";
     $page = 1;
     $size = 15;
     if (!empty($_GET)) {
         if ($_GET['page'] != "") {
             $page = $_GET['page'];
         }
         if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
             $where .= " and time >= '" . $_GET['start_time'] . "'";
         }
         if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
             $where .= " and time <= '" . $_GET['end_time'] . " 23:59:59'";
         }
         if ($_GET['uid'] != "") {
             $where .= " and uid = {$_GET['uid']}";
         }
         if ($_GET['size'] != "") {
             $size = $_GET['size'];
         }
     }
     $reOb = new ReserveModel();
     $num = $reOb->getCount($where);
     //var_dump($num);
     import("ORG.Util.Page1");
     $pageOb = new Page($page, $size, $num);
     //var_dump($pageOb);
     $start = $pageOb->getStartStr();
     $reArr = $reOb->getList($where, $start, $size);
     //var_dump($reArr);echo $reOb->getLastSql();
     $pageStr = $pageOb->getPageStr1(1);
     $mOb = M("member");
     foreach ($reArr as $k => $v) {
         $mArr = $mOb->where("id={$reArr[$k]['uid']}")->select();
         //var_dump($mArr);
         unset($reArr[$k]['uid']);
         $reArr[$k]['tel'] = $mArr[0]['tel'];
     }
     //var_dump($reArr);
     $arr = array('page' => $pageStr, 'data' => $reArr);
     //var_dump($data);
     $data = json_encode($arr);
     echo $data;
 }
 public function getlist()
 {
     $where = "where 1";
     $page = 1;
     $size = 15;
     if (!empty($_GET)) {
         if ($_GET['page'] != "") {
             $page = $_GET['page'];
         }
         if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
             $where .= " and deadTime >= '" . $_GET['start_time'] . "'";
         }
         if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
             $where .= " and deadTime <= '" . $_GET['end_time'] . " 23:59:59'";
         }
         if ($_GET['tel'] != "") {
             $where .= " and tel = '{$_GET['tel']}'";
         }
         if ($_GET['CCID'] != "") {
             $where .= " and CCID = '{$_GET['CCID']}'";
         }
         if ($_GET['size'] != "") {
             $size = $_GET['size'];
         }
     }
     $reOb = M();
     //$reOb = new SimhardModel;
     $num = $reOb->query("select count(*) as num from r_simhard join r_batch  b on simBatch=b.id " . $where);
     //var_dump($num);
     import("ORG.Util.Page1");
     $pageOb = new Page($page, $size, $num[0]['num']);
     //var_dump($pageOb);
     $start = $pageOb->getStartStr();
     $reArr = $reOb->query("select s.id sid,CCID,IP,simBatch,createTime,b.ssid,b.password,other,status,s.deadTime,s.type from r_simhard  s  join r_batch  b on simBatch=b.id " . $where . " limit {$start},{$size}");
     //$reArr = $reOb -> getList($where,$start,$size);var_dump($reArr);
     $pageStr = $pageOb->getPageStr1(1);
     //var_dump($pageStr);
     $arr = array('page' => $pageStr, 'data' => $reArr);
     //var_dump($arr);die;
     $data = json_encode($arr);
     echo $data;
 }
 public function getlist5()
 {
     $where = " other!=''";
     $page = 1;
     $size = 15;
     if (!empty($_GET)) {
         if ($_GET['page'] != "") {
             $page = $_GET['page'];
         }
         if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
             $where .= " and time >= '" . $_GET['start_time'] . "'";
         }
         if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
             $where .= " and time <= '" . $_GET['end_time'] . " 23:59:59'";
         }
         if ($_GET['title'] != "") {
             $where .= " and title like '%" . $_GET['title'] . "%'";
         }
         if ($_GET['name'] != "") {
             $where .= " and name like '%" . $_GET['name'] . "%'";
         }
         if ($_GET['tel'] != "") {
             $where .= " and tel like '%" . $_GET['tel'] . "%'";
         }
         if ($_GET['orderId'] != "") {
             $where .= " and  orderId like '%" . $_GET['orderId'] . "%'";
         }
         if ($_GET['sta'] != "") {
             $where .= " and status = '" . $_GET['sta'] . "'";
         }
         if ($_GET['size'] != "") {
             $size = $_GET['size'];
         }
     }
     $orderOb = new OrderModel();
     $num = $orderOb->getCount($where);
     import("ORG.Util.Page1");
     $pageOb = new Page($page, $size, $num);
     //var_dump($pageOb);
     $start = $pageOb->getStartStr();
     $orderArr = $orderOb->getList1($where, $start, $size);
     //var_dump($orderArr);//echo getLastSql();
     $pageStr = $pageOb->getPageStr1(1);
     $arr = array('page' => $pageStr, 'data' => $orderArr);
     //var_dump($data);
     $data = json_encode($arr);
     echo $data;
     exit;
 }
 function getlist()
 {
     $page = 1;
     $size = 15;
     $pctype = 1;
     if (isset($_GET['pctype'])) {
         $pctype = $_GET['pctype'];
     }
     if ($_GET['page'] != "") {
         $page = $_GET['page'];
     }
     if ($_GET['size'] != "") {
         $size = $_GET['size'];
     }
     import("ORG.Util.Page1");
     $proOb = new CardModel();
     $sum = $proOb->getCardCount("pctype='{$pctype}'");
     $pageOb = new Page($page, $size, $sum);
     $start = $pageOb->getStartStr();
     $pageStr = $pageOb->getPageStr1(3);
     //$arr=$proOb->getCardList($start,10);
     //$pTypeOb=new CardtypeModel;
     //$typearr=$pTypeOb->getListType();
     //搜索相关
     $title = $_GET['title'];
     $type = $_GET['type'];
     $sontype = $_GET['sontype'];
     $price = $_GET['price'];
     $status = $_GET['status'];
     $where = "(status=1 or status=2) and pctype={$pctype}";
     if (!empty($title)) {
         $where .= " and title like  '%{$title}%'";
     }
     if (!empty($type)) {
         $where .= " and type={$type}";
     }
     if (!empty($sontype)) {
         $where .= " and sontype={$sontype}";
     }
     if (!empty($status)) {
         $where .= " and status='{$status}'";
     }
     if (!empty($price)) {
         switch ($price) {
             case 1:
                 $where .= " and price<1000";
                 break;
             case 2:
                 $where .= " and price between  1000 and 2000";
                 break;
             case 3:
                 $where .= " and price between  2000 and 3000";
                 break;
             case 4:
                 $where .= " and price between  3000 and 4000";
                 break;
             case 5:
                 $where .= " and price>4000";
                 break;
             default:
                 $where .= "";
         }
     }
     $arr = $proOb->getCardList($start, $size, $where);
     //var_dump($arr);
     $arr = array('page' => $pageStr, 'data' => $arr);
     //var_dump($data);
     $data = json_encode($arr);
     echo $data;
 }
 public function getlist_flow()
 {
     //var_dump($_GET);
     $where = "where 1";
     $page = 1;
     $size = 15;
     if (!empty($_GET)) {
         if ($_GET['page'] != "") {
             $page = $_GET['page'];
         }
         if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
             $where .= " and f.ctime >= '" . $_GET['start_time'] . "'";
         }
         if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
             $where .= " and f.ctime <= '" . $_GET['end_time'] . " 23:59:59'";
         }
         if ($_GET['CCID'] != "") {
             $where .= " and f.CCID= '" . $_GET['CCID'] . "'";
         }
         if ($_GET['flow'] != "") {
             $where .= " and f.flow < " . $_GET['flow'];
         }
         if ($_GET['size'] != "") {
             $size = $_GET['size'];
         }
     }
     $reOb = M("flow");
     //$reOb = new SimhardModel;
     $num = $reOb->query("select count(*) as num from r_flows f " . $where);
     //echo $reOb -> getLastSql();die;
     import("ORG.Util.Page1");
     $pageOb = new Page($page, $size, $num[0]['num']);
     //var_dump($pageOb);
     $start = $pageOb->getStartStr();
     $reArr = $reOb->query("select f.id,f.ccid,f.flow,f.ctime  from r_flows f " . $where . "  limit {$start},{$size}");
     //echo $reOb -> getLastSql();die;
     $pageStr = $pageOb->getPageStr1(1);
     //var_dump($pageStr);
     $arr = array('page' => $pageStr, 'data' => $reArr);
     $data = json_encode($arr);
     echo $data;
 }
 public function getlist2()
 {
     $where = "status=3";
     $page = 1;
     $size = 15;
     if (!empty($_GET)) {
         if ($_GET['page'] != "") {
             $page = $_GET['page'];
         }
         if ($_GET['start_time'] != "" && $_GET['start_time'] != "开始日期") {
             $where .= " and time >= '" . $_GET['start_time'] . "'";
         }
         if ($_GET['end_time'] != "" && $_GET['end_time'] != "截止日期") {
             $where .= " and time <= '" . $_GET['end_time'] . " 23:59:59'";
         }
         if ($_GET['title'] != "") {
             $where .= " and title = '" . $_GET['title'] . "'";
         }
         if ($_GET['CCID'] != "") {
             $where .= " and CCID = '" . $_GET['CCID'] . "'";
         }
         if ($_GET['size'] != "") {
             $size = $_GET['size'];
         }
     }
     $corderOb = new CardorderModel();
     $num = $corderOb->getCount($where);
     import("ORG.Util.Page1");
     $pageOb = new Page($page, $size, $num);
     //var_dump($pageOb);
     $start = $pageOb->getStartStr();
     $corderArr = $corderOb->getList1($where, $start, $size);
     //var_dump($orderArr);//echo getLastSql();
     $pageStr = $pageOb->getPageStr1(1);
     foreach ($corderArr as $k => $v) {
         $cOb = M("card");
         $cArr = $cOb->where("id={$corderArr[$k]['pid']}")->select();
         $corderArr[$k]['beginTime'] = $cArr[0]['beginTime'];
         $corderArr[$k]['endTime'] = $cArr[0]['endTime'];
         $shOb = M("simhard");
         $shArr = $shOb->where("CCID='{$corderArr[$k]['CCID']}'")->select();
         //var_dump($shArr);
         $corderArr[$k]['type'] = $shArr[0]['type'];
         //var_dump($shArr[0]['type']);
         $yOb = M("yhq");
         $yArr = $yOb->where("id={$corderArr[$k]['yhqId']}")->select();
         if (isset($yArr) && !empty($yArr)) {
             $corderArr[$k]['yhqCode'] = $yArr[0]['code'];
         } else {
             $corderArr[$k]['yhqCode'] = 0;
         }
     }
     //var_dump($corderArr);
     $arr = array('page' => $pageStr, 'data' => $corderArr);
     //var_dump($data);
     $data = json_encode($arr);
     echo $data;
 }