public function getlist() { $where = "status=2"; $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['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->getList($where, $start, $size); //var_dump($orderArr);echo $corderOb->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); // echo $shOb -> getLastSql(); $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; }