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