public function getBlogs()
{
$count = M("")->table('blog b,user u')->field('b.id,b.uid,b.content,b.type,b.view,b.rise,b.posttime,b.statu,b.tag,b.title,u.username,u.headpic')->where('b.uid=u.id')->order('b.posttime desc')->count();
// 查询满足要求的总记录数
$page = PAGEADMIN($count);
// 实例化分页类 传入总记录数和每页显示的记录数
$show = $page->show();
// 分页显示输出
$data = M("")->table('blog b,user u')->field('b.id,b.uid,b.content,b.type,b.view,b.rise,b.posttime,b.statu,b.tag,b.title,u.username,u.headpic')->where('b.uid=u.id')->order('b.posttime desc')->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign('blogs', $data);
$this->assign("page", $show);
}
public function investorList()
{
$con = M()->table('user a,user_investor b')->field('a.id,a.username,a.nickname,b.type,a.email,a.province,a.reg_time')->where('a.id=b.uid')->count();
$page = PAGEADMIN($con);
$show = $page->show();
// 分页显示输出
$data = M()->table('user a,user_investor b')->field('a.id,a.username,a.nickname,b.type,a.email,a.province,a.reg_time')->where('a.id=b.uid')->select();
$this->assign("title", "Investor");
$this->assign('user', $data);
//数据源
$this->assign("tag", "投资人 <small>Investor</small>");
//标题头
$this->assign("icon", "dollar2");
//图标
$this->assign("page", $show);
//分页
$this->display('user');
}
public function projectList()
{
$project = D("project");
$con = $project->count();
$page = PAGEADMIN($con);
$show = $page->show();
// 分页显示输出
$data = $project->limit($page->firstRow . ',' . $page->listRows)->select();
$this->assign("title", "project");
$this->assign("tag", "项目 <small>Project</small>");
//标题头
$this->assign("icon", "lamp");
//图标
$this->assign('project', $data);
//数据
$this->assign("page", $show);
//分页
$this->display();
}
public function incubatorList()
{
$incubator = D('incubator');
$count = $incubator->getDataNum();
$page = PAGEADMIN($count);
$data = $incubator->getDataList($page->firstRow, $page->listRows);
$this->assign("incubatorList", $data);
$this->assign("page", $page->show());
$this->display();
}
