<?php
namespace User\Controller;
class ArticleController extends CommController{
public function index(){
$ArticleTagDb=D("articleType");
$sql["user_id"]=array("eq",session("user_id"));
$data=$ArticleTagDb->where($sql)->order("type_sort asc")->select();
$systemtag=$this->getSystemTag();
$this->assign("tag",$data);
$this->assign("systemtag",$systemtag);
$this->display();
}
public function getSystemTag(){
$tag=M("tag");
$data=$tag->select();
return $data;
}
public function postArticle(){
$articDb=D("article");
if ($articDb->create()){
$result=$articDb->add();
if($result) {
$this->success('操作成功!',U("Article/managementArticle"));
}else{
$this->error('写入错误!');
}
}else{
$this->error($articDb->getError());
}
}
public function managementArticle(){
$articDb=D("article");
$count = $articDb->where("user_id=".session("user_id"))->count() $Page = new \Think\Page($count,20) $Page->setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$Page->setConfig('prev','上一页');
$Page->setConfig('next','下一页');
$show = $Page->show() $date = $articDb->where("user_id=".session("user_id"))->limit($Page->firstRow.','.$Page->listRows)->order("article_id desc")->select();
$this->assign("artic",$date);
$this->assign('page',$show) $this->display(); }
public function showArticle(){
$article_id=I("get.artid");
$articDb=M("article");
$data=$articDb->where("user_id=".session("user_id"))->find($article_id);
$firstsql["article_id"]=array('gt',$article_id) $firstsql["user_id"]=array('eq',session("user_id"))
$nextsql["article_id"]=array('lt',$article_id); $nextsql["user_id"]=array('eq',session("user_id")) $first=$articDb->where($firstsql)->order("article_id asc")->getField('article_id');
$next=$articDb->where($nextsql)->order("article_id desc")->getField('article_id');
$this->assign("first",$first);
$this->assign("next",$next);
$this->assign("art",$data);
$this->display();
}
function deleteArticle(){
$Article_id=I("post.article_id");
$articDb=M("article");
$result=array("success"=>false,"error"=>"");
$resu=$articDb->delete($Article_id);
if($resu){
$result=array("success"=>true,"error"=>"");
}else{
$result=array("success"=>false,"error"=>"delete fail");
}
echo json_encode($result);
}
public function getEditArticle(){
$article_id=I("get.article_id");
$articDb=M("article");
$data=$articDb->where("user_id=".session("user_id"))->find($article_id);
$this->getTag();
$this->assign("art",$data);
$this->display();
}
public function getTag(){
$ArticleTagDb=D("articleType");
$sql["user_id"]=array("eq",session("user_id"));
$data=$ArticleTagDb->where($sql)->order("type_sort asc")->select();
$this->assign("tag",$data);
}
public function saveEditArticle(){
$articDb=D("article");
if ($articDb->create()){
$result=$articDb->save();
if($result) {
$this->success('操作成功!',U("Article/managementArticle"));
}else{
$this->error('修改错误!');
}
}else{
$this->error($articDb->getError());
}
}
}
?>