public function sqlListAction()
{
$m = new PSys_SynRule();
$sqltype = reqstr('sqltype', 0);
$updatetype = reqstr('updatetype', 0);
$page = reqnum('page', 1);
$pagesize = 20;
$where = array();
if ($sqltype) {
$where["sqltype"] = $sqltype;
}
if ($updatetype) {
$where["updatetype"] = $updatetype;
}
$order = " id ASC ";
$result = $m->GetsqlList($where);
if ($result['allnum'] % $pagesize) {
$last = floor($result['allnum'] / $pagesize) + 1;
} else {
$last = $result['allnum'] / $pagesize;
}
if ($page > 1) {
$this->smarty->assign("pre", $page - 1);
} else {
$this->smarty->assign("pre", 1);
}
if ($page == $last) {
$this->smarty->assign("next", $last);
} else {
$this->smarty->assign("next", $page + 1);
}
foreach ($result['allrow'] as $key => $val) {
$sitesName = array();
$result['allrow'][$key]['sqlcontent'] = mb_substr($val['sqlcontent'], 0, 50) . "……";
$sites = explode(',', $val['siteid']);
foreach ($sites as $ke => $val) {
$where = array('id' => $val);
$name = $m->GetsiteName($where);
$sitesName[] .= $name[0]['citename'];
}
$result['allrow'][$key]['siteid'] = $sitesName;
}
$this->smarty->assign("last", $last);
$this->smarty->assign("tree", $result["allrow"]);
$this->smarty->assign("total_num", $result["allnum"]);
$this->forward = "sqlList";
}
