public function content()
{
$id = $_GET['id'];
$article = sp_sql_content($id, '');
if (empty($article)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$termid = $article['term_id'];
$term_obj = M("Terms");
$term = $term_obj->where("term_id='{$termid}'")->find();
$str_like_list = D('like')->getLikeByUUID($id, true);
$article_id = $article['object_id'];
$dbContent = D("content");
$dbContent->saveByUUID($id, array("post_hits" => array("exp", "post_hits+1")));
$article_date = $article['post_modified'];
$join = "" . C('DB_PREFIX') . 'content as b on a.object_id =b.id';
$join2 = "" . C('DB_PREFIX') . 'users as c on b.post_author = c.id';
$rs = M("TermRelationships");
$next = $rs->alias("a")->join($join)->join($join2)->where(array("post_modified" => array("egt", $article_date), "tid" => array('neq', $id), "status" => 1, 'a.term_id' => $termid))->order("post_modified asc")->find();
$prev = $rs->alias("a")->join($join)->join($join2)->where(array("post_modified" => array("elt", $article_date), "tid" => array('neq', $id), "status" => 1, 'a.term_id' => $termid))->order("post_modified desc")->find();
$this->assign("next", $next);
$this->assign("prev", $prev);
$smeta = json_decode($article['smeta'], true);
$content_data = sp_content_page($article['post_content']);
$article['post_content'] = $content_data['content'];
switch ($article['term_id']) {
case 2:
$article['content_type'] = '论文';
break;
case 3:
$article['content_type'] = '项目';
break;
case 4:
$article['content_type'] = '获奖';
break;
case 5:
$article['content_type'] = '专利';
break;
}
$this->assign("page", $content_data['page']);
$this->assign("article", $article);
$this->assign("smeta", $smeta);
$this->assign("term", $term);
$this->assign("article_id", $article_id);
$this->assign("str_like_list", $str_like_list);
$tplname = $term["one_tpl"];
$tplname = sp_get_apphome_tpl($tplname, "article");
$this->display(":{$tplname}");
}
public function index()
{
$term = sp_get_term($_GET['id']);
if (empty($term)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$tplname = $term["list_tpl"];
$tplname = sp_get_apphome_tpl($tplname, "list");
$this->assign($term);
$this->assign('cat_id', intval($_GET['id']));
$this->display(":{$tplname}");
}
public function list_content()
{
$tplname = $term["list_tpl"];
$tplname = sp_get_apphome_tpl($tplname, "list_content");
if (empty($tplname)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$dbContent = M('content');
$dbTR = M('term_relationships');
$obj = $dbTR->where('status=1')->select();
foreach ($obj as $item) {
$obj_id[] = $item['object_id'];
}
$map['post_status'] = 1;
//判断文章是否审核通过；
$map['id'] = array('in', $obj_id);
//判断文章是否被删除；
$list = $dbContent->where($map)->order('post_date desc')->select();
for ($i = 0; $i < count($list); $i++) {
$user = M('users')->where('id=' . $list[$i]['post_author'])->find();
$list[$i]['author'] = $user['user_name'];
$list[$i]['like_list'] = D('like')->getLikeByUUID($list[$i]['id'], true);
switch ($list[$i]['table_name']) {
case 'content_paper':
$list[$i]['content_type'] = '论文';
break;
case 'content_project':
$list[$i]['content_type'] = '项目';
break;
case 'content_award':
$list[$i]['content_type'] = '获奖';
break;
case 'content_patent':
$list[$i]['content_type'] = '专利';
break;
}
}
$this->assign('lists_post', $list);
$this->assign($term);
$this->display(":{$tplname}");
}
public function index()
{
$term = sp_get_term($_GET['id']);
if (empty($term)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
if ($term['parent'] != 0) {
$parentid = $term['parent'];
$termschildren = $this->terms_model->where(array('parent' => $parentid))->select();
//获得二级栏目
} else {
$termschildren = $this->terms_model->where(array('parent' => $term['term_id']))->select();
//获得二级栏目
}
//kjdump($term);
switch ($term['catype']) {
case '1':
$postdata = $this->getcaseslist($term['term_id']);
break;
//文章
//文章
case '0':
$postdata = $this->getarticlelist($term['term_id']);
break;
//案例
//案例
default:
$this->display(":404");
break;
}
//kjdump($postdata );
$tplname = $term["list_tpl"];
//$tplname=sp_get_apphome_tpl($tplname, "list");
$this->assign('term', $term);
$this->assign('parentid', $parentid);
//$this->assign('cat_id', intval($_GET['id']));
$this->assign('termschildren', $termschildren);
$this->assign('postdata', $postdata);
$this->display(":{$tplname}");
}
public function index()
{
$id = $_GET['id'];
$content = sp_sql_page($id);
if (empty($content)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$this->assign($content);
$smeta = json_decode($content['smeta'], true);
$tplname = isset($smeta['template']) ? $smeta['template'] : "";
$tplname = sp_get_apphome_tpl($tplname, "page");
$this->display(":{$tplname}");
}
public function index()
{
$terms_db = M('Terms');
$term = sp_get_term($_GET['id']);
if (empty($term)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$tlist = $terms_db->where(array('parent' => $_GET['id']))->select();
$tplname = $term["list_tpl"];
$tplname = sp_get_apphome_tpl($tplname, "list");
$this->assign($term);
$this->assign('tlist', $tlist);
$this->assign('cat_id', intval($_GET['id']));
$this->display(":{$tplname}");
}
public function index()
{
$id = intval($_GET['id']);
$article = sp_sql_post($id, '');
if (empty($article)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$termid = $article['term_id'];
$term_obj = M("Terms");
$term = $term_obj->where("term_id='{$termid}'")->find();
$article_id = $article['object_id'];
$should_change_post_hits = sp_check_user_action("posts{$article_id}", 1, true);
if ($should_change_post_hits) {
$posts_model = M("Posts");
$posts_model->save(array("id" => $article_id, "post_hits" => array("exp", "post_hits+1")));
}
$article_date = $article['post_modified'];
$join = "" . C('DB_PREFIX') . 'posts as b on a.object_id =b.id';
$join2 = "" . C('DB_PREFIX') . 'users as c on b.post_author = c.id';
$rs = M("TermRelationships");
$next = $rs->alias("a")->join($join)->join($join2)->where(array("post_modified" => array("egt", $article_date), "tid" => array('neq', $id), "status" => 1, 'term_id' => $termid))->order("post_modified asc")->find();
$prev = $rs->alias("a")->join($join)->join($join2)->where(array("post_modified" => array("elt", $article_date), "tid" => array('neq', $id), "status" => 1, 'term_id' => $termid))->order("post_modified desc")->find();
$this->assign("next", $next);
$this->assign("prev", $prev);
$smeta = json_decode($article['smeta'], true);
$content_data = sp_content_page($article['post_content']);
$article['post_content'] = $content_data['content'];
$this->assign("page", $content_data['page']);
$this->assign($article);
$this->assign("smeta", $smeta);
$this->assign("term", $term);
$this->assign("article_id", $article_id);
$tplname = $term["one_tpl"];
$tplname = sp_get_apphome_tpl($tplname, "article");
$this->display(":{$tplname}");
}
public function index()
{
$term = sp_get_term($_GET['id']);
if (empty($term)) {
header('HTTP/1.1 404 Not Found');
header('Status:404 Not Found');
if (sp_template_file_exists(MODULE_NAME . "/404")) {
$this->display(":404");
}
return;
}
$tplname = $term["list_tpl"];
$tplname = sp_get_apphome_tpl($tplname, "list");
$dbPosts = M('posts');
$dieYear['max'] = $dbPosts->field(array('MAX(LEFT(post_diedate,4))' => 'max'))->find()['max'];
$dieYear['min'] = $dbPosts->field(array('MIN(LEFT(post_diedate,4))' => 'min'))->find()['min'];
$this->assign('dieYear', $dieYear);
$this->assign($term);
$this->assign('cat_id', intval($_GET['id']));
$this->display(":{$tplname}");
}
