public function getList($page, $page_size)
{
$total = $this->field("count(id) as total")->find();
$total = $total["total"];
$page_count = page_count($total, $page_size);
$offset = ($page - 1) * $page_size;
$limit = $page_size;
$list = $this->order("id desc")->limit($offset . ", " . $limit)->select();
$r = array("page_size" => $page_size, "page_count" => $page_count, "total" => intval($total), "page" => $page, "list" => $list);
return $r;
}
static function getList($page, $page_size, $type)
{
$m = M("Data");
$total = $m->field("count(id) as total")->where("type = " . $type)->find();
$total = $total["total"];
$page_count = page_count($total, $page_size);
$offset = ($page - 1) * $page_size;
$limit = $page_size;
$list = $m->field("dc.name as dc_name, " . C("DB_PREFIX") . "data.*")->join(C("DB_PREFIX") . "data_class as dc on dc.id = " . C("DB_PREFIX") . "data.dataclass_id")->where(C("DB_PREFIX") . "data.type = " . $type)->order(C("DB_PREFIX") . "data.sort desc, " . C("DB_PREFIX") . "data.id desc")->limit($offset . ", " . $limit)->select();
foreach ($list as &$v) {
$v["add_time"] = date("Y-m-d H:i:s", $v["add_time"]);
}
return array("page_size" => $page_size, "page_count" => $page_count, "total" => intval($total), "page" => $page, "list" => $list);
}
public function getList($page, $page_size)
{
$total = $this->field("count(id) as total")->where("is_admin = 1")->find();
$total = $total["total"];
$page_count = page_count($total, $page_size);
$offset = ($page - 1) * $page_size;
$limit = $page_size;
$list = $this->where("is_admin = 1")->order("id desc")->limit($offset . ", " . $limit)->select();
foreach ($list as &$v) {
$v["add_time"] = date("Y-m-d H:i:s", $v["add_time"]);
}
$r = array("page_size" => $page_size, "page_count" => $page_count, "total" => intval($total), "page" => $page, "list" => $list);
return $r;
}
} elseif ($act == "getlist") {
$page = isset($_REQUEST["page"]) ? intval($_REQUEST["page"]) : 1;
$page_size = isset($_REQUEST["page_size"]) ? intval($_REQUEST["page_size"]) : 25;
$type = isset($_REQUEST["type"]) ? intval($_REQUEST["type"]) : 0;
$dataclass_id = isset($_REQUEST["dataclass_id"]) ? intval($_REQUEST["dataclass_id"]) : 0;
$wq = "type = " . $type;
$wq_list = "d.type = " . $type;
if ($dataclass_id) {
get_children_id($dataclass_id);
$children_id = implode(",", $children_id);
$wq .= " and dataclass_id in(" . $children_id . ")";
$wq_list .= " and d.dataclass_id in(" . $children_id . ")";
}
$sql = SqlText::func("count", "id", "data", $wq);
$total = $db->get_var($sql);
$page_count = page_count($total, $page_size);
$sql = "select d.* , dc.id as dc_id , dc.name as dc_name from data as d inner join dataclass as dc on d.dataclass_id = dc.id where " . $wq_list . " order by d.sort desc , d.id desc limit " . ($page - 1) * $page_size . " , " . $page_size;
$list = $db->get_results($sql, ARRAY_A);
foreach ($list as &$v) {
$v["add_time"] = date("Y-m-d H:i:s", $v["add_time"]);
}
output_json(0, "请求成功", array("total" => $total, "page" => $page, "page_count" => $page_count, "list" => $list));
} elseif ($act == "add") {
$id = isset($_REQUEST["id"]) ? intval($_REQUEST["id"]) : 0;
if ($id) {
$row = $db->get_row("select * from data where id = " . $id, ARRAY_A);
$row["content"] = html_entity_decode($row["content"]);
} else {
$row = array("id" => 0, "name" => "", "sort" => 0, "dataclass_id" => 0, "content" => "", "type" => intval($_REQUEST['type']));
}
$smarty->assign('row', $row);
