<?php
namespace Home\Controller;
use Think\Controller;
class ArticleController extends Controller{
public function getListArticle(){
$articDb=D("article");
$count = $articDb->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->limit($Page->firstRow.','.$Page->listRows)->order("article_id desc")->select();
$this->assign("artic",$date);
$this->assign('page',$show) }
public function getArticle($num,$order){
$articDb=D("article");
$data=$articDb->limit("0,".$num)->order($order)->select();
return $data;
}
public function getArticleIsSelf($num,$order){
$articDb=D("article");
$data=$articDb->limit("0,".$num)->where("a_iscopy=1")->order($order)->select();
return $data;
}
public function getArticleIsNoSelf($num,$order){
$articDb=D("article");
$data=$articDb->limit("0,".$num)->where("a_iscopy=0")->order($order)->select();
return $data;
}
public function getSelfTag($num){
$article_type=M("article_type");
$data=$article_type->limit("0,".$num)->order("type_sort asc")->select();
return $data;
}
public function showOneArticle(){
$article_id=I("get.artid");
$articDb=M("article");
$data=$articDb->find($article_id);
$name=$this->getThisArtAuth($data["user_id"]);
$this->assign("name",$name["user_name"]);
$this->assign("title","_".$data['a_title']);
$this->assign("art",$data);
}
public function getThisArtAuth($user_id){
$User=M("user");
$data["user_id"]=$user_id;
$name=$User->field("user_name,user_img")->where($data)->find();
return $name;
}
public function GetArticleComment($table,$article_id){
$Comment=M($table);
$data["article_id"]=$article_id;
$count=$Comment->where($data)->count();
$Page = new \Think\Page($count,10);
$Page->setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$Page->setConfig('prev','上一页');
$Page->setConfig('next','下一页');
$show = $Page->show() $result = $Comment->where($data)->limit($Page->firstRow.','.$Page->listRows)->order("article_id desc")->select();
foreach($result as $key=>$value){
$username=$this->getThisArtAuth($value["user_id"]);
$result[$key]["username"]=$username["user_name"];
$result[$key]["user_img"]=$username["user_img"];
}
$this->assign("comment",$result);
$this->assign('page',$show) }
public function UserComment($table,$data){
$key=md5(KEY.session("user_name").session("user_id"));
if(session("user_key")!=$key){
$this->error("你未登入,不能评论!");
}else{
$article_comment=M($table);
$result=$article_comment->add($data);
if($result){
$this->success("评论成功!");
}else{
$this->error("评论失败!");
}
}
}
public function ReadNum($table,$array,$word){
$article=M($table);
$article->where($array)->setInc($word);
}
public function getAdminArticle($num,$order){
$articDb=D("adminArticle");
$data=$articDb->limit("0,".$num)->order($order)->select();
return $data;
}
}