public function userBorrow()
{
//获取图书馆信息
$lib = D("library");
$library = $lib->field("id,bbs")->find("1");
$library = explode("。", $library["bbs"]);
//实例化数据表
$info = D("borrow");
//分页效果
$total = $info->count();
$per = 8;
$pages = new \Tools\page($total, $per);
//获取session数据
$re_id = session("re_id");
/*******判断未登陆*******/
if ($re_id == null) {
echo "<script type='text/javascript'>alert('请登陆后查看！');history.back();</script>";
die;
}
$borrow = $info->query("SELECT a.id,a.borrowtime,a.status,a.reverttime,b.bo_code,b.bo_name,b.bo_id FROM `li_borrow`as a left join `li_book` as b on a.bookid=b.bo_id where readerid={$re_id} {$pages->limit}");
//获取分页
$pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8));
//载入smarty模板
$this->assign("session", session());
$this->assign("borrow", $borrow);
$this->assign("pagelist", $pagelist);
$this->assign("library", $library);
//载入视图
$this->display("userborrowreglist");
}
function index()
{
//实例化数据表
$info = D("booktype");
if (!empty($_POST)) {
$add = $info->create($_POST);
if ($add) {
$type = $info->add($add);
if ($type) {
echo "<font style='color:red'>添加成功！</font>";
} else {
echo "<font style='color:red'>添加失败！</font>";
}
}
} else {
//做分页效果
$total = $info->count();
$per = 8;
//每页显示的条数
$pages = new \Tools\page($total, $per);
//查询数据表的数据
$type_name = $info->query("select by_id,by_name from li_booktype {$pages->limit}");
//获得页码列表
$pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8));
//载入smarty模板
$this->assign("type_name", $type_name);
$this->assign("pagelist", $pagelist);
//载入视图
$this->display("booktype");
}
}
public function index()
{
//实例化数据表
$info = D("press");
if (!empty($_POST)) {
$add = $info->create($_POST);
if ($add) {
$press = $info->add($add);
if ($press) {
echo "<font style='color:red'>添加成功！</font>";
} else {
echo "<font style='color:red'>添加失败！</font>";
}
}
} else {
//分页效果
$total = $info->count();
$per = 8;
$pages = new \Tools\page($total, $per);
$limit = str_replace(" ", "", $pages->limit);
//查询数据表
$press_info = $info->limit(substr($limit, 5))->select();
$pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8));
//载入smarty模板
$this->assign("press_info", $press_info);
$this->assign("pagelist", $pagelist);
//载入视图
$this->display("publishing");
}
}
function index()
{
//实例化数据表
$info = D("bookcase");
if (!empty($_POST)) {
$add = $info->create($_POST);
if ($add) {
$case = $info->add($add);
if ($case) {
echo "<font style='color:red'>添加成功！</font>";
} else {
echo "<font style='color:red'>添加失败！</font>";
}
}
} else {
//分页效果
$total = $info->count();
$per = 8;
$pages = new \Tools\page($total, $per);
//查询数据表的数据
$limit = str_replace(" ", "", $pages->limit);
$case_name = $info->field("ca_name,ca_id")->limit(substr($limit, 5))->select();
$pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8));
//载入smarty模板
$this->assign("case_name", $case_name);
$this->assign("pagelist", $pagelist);
//载入视图
$this->display("bookcase");
}
}
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 reader()
{
//获取读者信息
$reader = new \Model\ReaderModel();
//分页效果
$total = $reader->count();
$per = 3;
$pages = new \Tools\page($total, $per);
$read_info = $reader->query("select a.re_id,a.re_name,a.re_code,b.rt_name,c.pa_type,a.re_number,a.re_tel,a.re_email,a.re_num from li_reader as a left join li_readertype as b on a.re_typeid=b.rt_id left join li_papers as c on a.re_paperid=c.pa_id {$pages->limit}");
$pagelist = $pages->fpage(array(3, 4, 5, 6, 7, 8));
//载入smarty模板
$this->assign("read_info", $read_info);
$this->assign("pagelist", $pagelist);
$this->display();
}
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 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");
}
