public function book() { //实例化数据表 $book = new \Model\BookModel(); //分页效果 $total = $book->count(); $per = 10; $pages = new \Tools\page($total, $per); $book_info = $book->query("SELECT a.bo_id,a.bo_code,a.bo_name,a.bo_stock,b.by_name,c.pr_name,d.ca_name FROM `li_book`as a left join li_booktype as b on a.bo_typeid=b.by_id left join li_press as c on a.bo_pressid=c.pr_id left join li_bookcase as d on a.bo_bookcaseid=d.ca_id {$pages->limit} "); $pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8)); //载入smarty模板 $this->assign("info", $book_info); $this->assign("pagelist", $pagelist); $this->display(); }
public function bookMustread() { //获取图书馆信息 $library = $this->library(); //获取图书必读信息 $info = new \Model\BookModel(); //分页效果 $total = $info->count(); $per = 8; $pages = new \Tools\page($total, $per); $mustread = $info->query("SELECT a.bo_id,a.bo_code,a.bo_name,b.by_name,c.pr_name,d.ca_name,a.bo_stock FROM `li_book`as a left join li_booktype as b on a.bo_typeid=b.by_id left join li_press as c on a.bo_pressid=c.pr_id left join li_bookcase as d on a.bo_bookcaseid=d.ca_id where bo_mustread=1 {$pages->limit}"); $pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8)); // 载入smarty模板 $this->assign("library", $library); $this->assign("mustread", $mustread); $this->assign("pagelist", $pagelist); //载入视图 $this->display("book_bidu"); }
public function index() { //获取图书信息 $book = new \Model\BookModel(); //做分页效果 $total = $book->count(); $per = 10; //每页显示的条数 $pages = new \Tools\page($total, $per); $book_info = $book->query("SELECT a.bo_id,a.bo_code,a.bo_name,a.bo_author,a.bo_price,a.bo_borrowtimes,b.by_name,c.pr_name,d.ca_name FROM `li_book`as a left join li_booktype as b on a.bo_typeid=b.by_id left join li_press as c on a.bo_pressid=c.pr_id left join li_bookcase as d on a.bo_bookcaseid=d.ca_id order by bo_borrowtimes desc {$pages->limit}"); //获得页码列表 $pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8)); // var_dump($pagelist); // die(); //载入smarty模板 $this->assign("book_info", $book_info); $this->assign("pagelist", $pagelist); $this->display(); }