public function uplist() { $order = I("get.order"); if (!in_array($order, array("s1", "s2", "s3", "s4"))) { $order = "s1"; } $orderArr = array("s1" => "fiveDayUp51", "s2" => "tenDayUp51", "s3" => "tenDayUp101", "s4" => "twentyDayUp101"); $orderField = $orderArr[$order]; $desc = I("get.desc"); if (!in_array($desc, array('0', '1'))) { $desc = "1"; } if ($desc == "0") { $descstr = "ASC"; } else { $descstr = "DESC"; } $data['order'] = $order; $data['desc'] = $desc; $ts_probability = M('ts_probability'); $where = "a.`date`=(select max(`date`) from ts_probability)"; $field = "a.code,a.name,a.date,a.lastdayClose,a.fiveDayUp51,tenDayUp51,tenDayUp101,twentyDayUp101"; $pageSize = 30; $count = $ts_probability->table("ts_probability a")->where($where)->count(); import("@.Common.P5wPage"); $Page = new P5wPage($count, $pageSize, ""); // 实例化分页类 传入总记录数和每页显示的记录数 $data['p'] = $Page->nowPage; $data['page'] = $Page->show(); $list = $ts_probability->table("ts_probability a")->field($field)->where($where)->order($orderField . " " . $descstr . ",a.code asc")->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($list as &$val) { $val['lastdayClose'] = number_format($val['lastdayClose'], 2); $val['fiveDayUp51'] = number_format($val['fiveDayUp51'], 2); $val['tenDayUp51'] = number_format($val['tenDayUp51'], 2); $val['tenDayUp101'] = number_format($val['tenDayUp101'], 2); $val['twentyDayUp101'] = number_format($val['twentyDayUp101'], 2); } $data['list'] = $list; $this->assign('data', $data); $this->display('uplist'); }
public function uplist() { $result = $this->persons; //权限判断 if (!in_array($result['user_rank'], array(2))) { if (empty($result)) { $this->error('您尚未登录,请先注册登录'); } else { $this->error('您还不是本站赞助用户,暂时无法访问'); } } $this->right(); $order = I("get.order"); if (!in_array($order, array("s1", "s2", "s3", "s4", "s5"))) { $order = "s1"; } $orderArr = array("s1" => "fiveDayUp51", "s2" => "tenDayUp51", "s3" => "tenDayUp101", "s4" => "twentyDayUp101", "s5" => "days1"); $orderField = $orderArr[$order]; $desc = I("get.desc"); if (!in_array($desc, array('0', '1'))) { $desc = "1"; } if ($desc == "0") { $descstr = "ASC"; } else { $descstr = "DESC"; } $data['order'] = $order; $data['desc'] = $desc; $ts_probability = M('ts_probability'); $where = "a.`date`=(select max(`date`) from ts_probability)"; $field = "a.code,a.name,a.date,a.lastdayClose,a.days1,a.fiveDayUp51,tenDayUp51,tenDayUp101,twentyDayUp101"; $pageSize = 30; $count = $ts_probability->table("ts_probability a")->where($where)->count(); $p = C('VAR_PAGE') ? C('VAR_PAGE') : 'p'; $parameter[$p] = '__PAGE__'; $url = U('index/index/uplist', $parameter); import("@.Common.P5wPage"); $Page = new P5wPage($count, $pageSize, "", $url); // 实例化分页类 传入总记录数和每页显示的记录数 $data['p'] = $Page->nowPage; $data['page'] = $Page->show(); $list = $ts_probability->table("ts_probability a")->field($field)->where($where)->order($orderField . " " . $descstr . ",a.code asc")->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($list as &$val) { $val['lastdayClose'] = number_format($val['lastdayClose'], 2); $val['fiveDayUp51'] = number_format($val['fiveDayUp51'], 2); $val['tenDayUp51'] = number_format($val['tenDayUp51'], 2); $val['tenDayUp101'] = number_format($val['tenDayUp101'], 2); $val['twentyDayUp101'] = number_format($val['twentyDayUp101'], 2); } $data['list'] = $list; $this->assign('data', $data); $this->display('uplist'); }