private function getArticlesByFolderName($name = "")
{
$dao = D('Folder');
$info = $dao->where(array('name' => $name))->find();
$id = -1;
if ($info) {
$id = $info['id'];
}
if ($info) {
if ($info['children'] == ',') {
$folders = $id;
} else {
$folders = substr($info['children'], 1) . $id;
}
}
$userid = $_SESSION['userInfo']['id'];
$userType = $_SESSION['userInfo']['type'];
if (empty($userid)) {
$userid = "-1";
}
if ($userType > 0) {
$count = $dao->table('tbl_article a JOIN tbl_article_folder f on f.article=a.id AND f.folder IN (' . $folders . ') JOIN tbl_article_group g ON g.article=a.id ')->where(array('a.status' => 3))->field('a.*')->distinct(true)->count();
$page = new \Think\Page($count);
$page->setUrl('folder?id=' . $id . '&p=' . urlencode('[PAGE]'));
$articles = $dao->table('tbl_article a JOIN tbl_article_folder f on f.article=a.id AND f.folder IN (' . $folders . ') JOIN tbl_article_group g ON g.article=a.id ')->where(array('a.status' => 3))->field('a.*')->distinct(true)->order(array('a.publishtime' => 'desc'))->limit($page->firstRow, $page->listRows)->select();
} else {
$count = $dao->table('tbl_article a JOIN tbl_article_folder f on f.article=a.id AND f.folder IN (' . $folders . ') JOIN tbl_article_group g ON g.article=a.id JOIN tbl_user_group ug ON ug.group=g.group and ug.user='******'a.status' => 3))->field('a.*')->distinct(true)->count();
$page = new \Think\Page($count);
$page->setUrl('folder?id=' . $id . '&p=' . urlencode('[PAGE]'));
$articles = $dao->table('tbl_article a JOIN tbl_article_folder f on f.article=a.id AND f.folder IN (' . $folders . ') JOIN tbl_article_group g ON g.article=a.id JOIN tbl_user_group ug ON ug.group=g.group and ug.user='******'a.status' => 3))->field('a.*')->distinct(true)->order(array('a.publishtime' => 'desc'))->limit($page->firstRow, $page->listRows)->select();
}
return $articles;
}
