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(); }
public function bookInfo($bo_id) { //获取图书馆信息 $library = $this->library(); //根据ID查找相应的图书信息 $info = new \Model\BookModel(); $book = $info->query("SELECT a.*,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 where bo_id={$bo_id}"); // 载入smarty模板 $this->assign("library", $library); $this->assign("book", $book); $this->assign("session", session()); //载入视图 $this->display("book_view"); }
public function bookEdit($bo_id) { //实例化图书数据表 $book = D("book"); if (!empty($_POST)) { if ($_FILES["bo_photo"]['error'] == 0) { $cfg = array('rootPath' => './Uploads/'); //实例化上传类 $up = new \Think\Upload($cfg); //uploadOne会返回上传附件保存在服务器的名字和路径 $a = $up->uploadOne($_FILES["bo_photo"]); //拼装文件的路径名称 $fileName = $up->rootPath . $a["savepath"] . $a["savename"]; $_POST["bo_photo"] = $fileName; } //接收表单数据 $book_info = $book->create($_POST); if ($book_info) { //添加数据 $add = $book->save($bo_info); if ($add) { echo "<font style='color:red'>修改成功!</font>"; } else { echo "<font style='color:red'>修改失败!</font>"; } } } else { //读取图书类型 $booktype = D("booktype"); $type_info = $booktype->select(); //读取书架信息 $bookcase = D("bookcase"); $case_info = $bookcase->select(); //读取出版社信息 $press = D("press"); $pr_info = $press->select(); //获取要修改的数据信息 $book = new \Model\BookModel(); $info = $book->query("SELECT a.*,b.by_name,c.pr_id,c.pr_name,d.ca_id,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 where bo_id={$bo_id}"); //载入smarty模板 $this->assign("type_info", $type_info); $this->assign("case_info", $case_info); $this->assign("pr_info", $pr_info); $this->assign("info", $info); //载入视图 $this->display("book_edit"); } }