function setchongzhi() { $str = $_GET['str']; $arr = explode(",", $str); if ($arr != null) { $oOb = new CardorderModel(); $re = $oOb->setStatus($arr, "3", "2"); $date = date("Y-m-d H:i:s"); $coOb = M("cardorder"); foreach ($arr as $v) { $re1 = $coOb->query("update r_cardorder set updateTime='{$date}' where id={$v}"); } if ($re !== null) { echo "1"; } } }
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; }