$page2->url = "task_list.php"; $page2->sql = "select t_req.*,(select count(req_num) from t_feedback where t_feedback.req_num=t_req.req_num) fd from t_req where req_finish_engineer='{$user_name}' and req_state=4 order by req_finish_time desc"; $page2->pageNow = 1; $page2->url_arg = "flag=2"; if ($_GET['flag'] == 2 and $_GET['pageNow']) { $page2->pageNow = $_GET['pageNow']; } $smarty->assign("done", $page2->getPageResource()); $smarty->assign("nav2", $page2->getNavigate()); $smarty->assign("totalCount2", $res2[0][0]); //变更列表 $sql3 = " from t_req,t_req_change where t_req.req_num=t_req_change.req_num and req_engineer='{$user_name}' order by change_time desc"; $res3 = $sqltool->dbQuery("select count(*)" . $sql3); $page3 = new PageTool($res3[0][0]); $page3->sql = "select t_req.req_num,req_title,req_author,req_time,change_time,flag " . $sql3; $page3->url = "task_list.php"; $page3->url_arg = "flag=3"; $page3->pageNow = 1; if ($_GET['flag'] == 3 and $_GET['pageNow']) { $page3->pageNow = $_GET['pageNow']; } $smarty->assign("changelist", $page3->getPageResource()); $smarty->assign("nav3", $page3->getNavigate()); $smarty->assign("totalCount3", $res3[0][0]); $flag = 1; if ($_GET['flag']) { $flag = $_GET['flag']; } $smarty->assign("res", $res); $smarty->assign("flag", $flag); $smarty->display("engineer/task_list.html");
<?php /** * Created by PhpStorm. * User: huzhiming * Date: 2015/7/1 * Time: 17:16 */ require_once "SQLTool.class.php"; require_once "PageTool.class.php"; $sqlTool = new SQLTool(); $res = $sqlTool->dbQuery("select count(*)from emp"); $pageTool = new PageTool($res[0][0], 2); $pageTool->url = "./pagetest.php"; echo "用户列表:<br><br><br>"; $sql = "select *from emp "; $pageTool->sql = $sql; $pageNow = 1; if ($_GET['pageNow']) { $pageNow = $_GET['pageNow']; } $res = $pageTool->getPageResource($pageNow); for ($i = 0; $i < count($res); $i++) { echo $res[$i][emp_id] . "--" . $res[$i][emp_name] . "--" . $res[$i][emp_pwd] . "<br>"; } echo "<br>"; echo $pageTool->getNavigate();
require_once "../../smarty_include.php"; require_once "../../tools/SQLTool.class.php"; require_once "../../tools/PageTool.class.php"; $sqltool = new SQLTool(); $sql = "select * from t_kno where 1=1 "; //输入搜索 $searchcontent = ""; if (isset($_GET['searchcontent']) and $_GET['searchcontent'] != "") { $searchcontent = $_GET['searchcontent']; $sql .= " and (kno_title like '%{$searchcontent}%' or kno_num like '%{$searchcontent}%' or kno_sort like '%{$searchcontent}%' or kno_keyword like '%{$searchcontent}%' or kno_content like '%{$searchcontent}%')"; } //分类搜索 if (isset($_GET['kno_sort'])) { $sort = $_GET['kno_sort']; $sql .= " and kno_sort like '%{$sort}%' "; } $sql .= " and kno_state=3 order by kno_read desc"; $res = $sqltool->dbQuery($sql); $pagetool = new PageTool(count($res)); $pagetool->url = "know_list.php"; $pagetool->sql = $sql; $pagetool->url_arg = "searchcontent={$searchcontent}&kno_sort={$sort}"; $pageNow = 1; if ($_GET['pageNow']) { $pageNow = $_GET['pageNow']; } $pagetool->pageNow = $pageNow; $smarty->assign("res", $pagetool->getPageResource()); $smarty->assign("nav", $pagetool->getNavigate()); $smarty->assign("searchcontent", $searchcontent); $smarty->display("share/know_list.html");
$sql .= " and req_state={$state}"; } if ($keyword != '') { $sql .= " and req_keyword='{$keyword}'"; } $res = $sqltool->dbQuery("select count(*) from t_req where 1=1 {$sql}"); $pagetool = new PageTool($res[0][0]); $pagetool->url = "request_inquiry.php"; $pagetool->url_arg = "options={$options}&date1={$date1}&date2={$date2}&user={$user}&engineer={$engineer}&state={$state}&keyword={$keyword}"; $pageNow = 1; $pagetool->sql = "select t_req.*,(select count(req_num) from t_feedback where t_feedback.req_num=t_req.req_num) fd from t_req where 1=1 {$sql} order by req_time desc"; if ($_GET['pageNow']) { $pageNow = $_GET['pageNow']; } $pagetool->pageNow = $pageNow; $req = $pagetool->getPageResource(); $list = "("; for ($i = 0; $i < count($req); $i++) { if ($i == count($req) - 1) { $list .= "'" . $req[$i]['req_num'] . "'"; } else { $list .= "'" . $req[$i]['req_num'] . "',"; } } $list .= ")"; $smarty->assign("res", $req); $smarty->assign("list", $list); $smarty->assign("navi", $pagetool->getNavigate()); $smarty->assign("options", $options); $smarty->assign("date1", $date1); $smarty->assign("date2", $date2);