历时三周,论坛终于完成。
<?php
namespace Home\Controller;
use Think\Controller;
class ArticleController extends Controller {
public function getAllTitleList($data = null){ //论坛首页,获取全部文章列表,不需要发送参数,类型get
$art = M("article"); //读取article数据表
$map['id'] >0; //map条件
$data=$art->where($map)->select(); //输出满足条件的所有数据
if (count($data) > 0) {
$resultCode['code'] = "1"; //成功就返回1,并输出数组中元素的数目。要满足计数count($data) > 0条件
$resultCode['msg'] = "getAllTitleList";
$resultCode['getAllTitleList'] = $data;
$this->ajaxReturn($resultCode,'JSON');
}else{
$resultCode['code'] = "-1"; //不成功就返回-1
$resultCode['msg'] = "getAllTitleList";
$resultCode['getAllTitleList'] = "";
$this->ajaxReturn($resultCode,'JSON');
}
}
public function getDetailsContent($data = null){ //获取文章详细内容,POST类型
$comment = M("comment"); //读取commente数据表
$commap['articleId'] = $_POST['articleid']; //条件
$comdata=$comment->where($commap)->select(); //输出满足条件的评论
$art = M("article"); //读取article数据表
$map['id'] = $_POST['articleid']; //条件,articleid要等于id,意思就是属于这篇文章的评论
$data=$art->where($map)->find(); //find只能输出一组多维数组,输出满足条件数组
if (is_array($data)) { //成功则返回1,并输出这篇文章的数据以及评论。
$resultCode['code'] = "1";
$resultCode['msg'] = "getDetailsContent";
$resultCode['id'] = $data['id'];
$resultCode['title'] = $data['title'];
$resultCode['name'] = $data['name'];
$resultCode['sendTime'] = $data['sendtime'];
$resultCode['content'] = $data['content'];
$resultCode['commentlist'] =$comdata;
$this->ajaxReturn($resultCode,'JSON');
}else{
$resultCode['code'] = "-1"; //不成功就返回-1
$resultCode['msg'] = "getDetailsContent";
$resultCode['getDetailsContent'] = "";
$this->ajaxReturn($resultCode,'JSON');
}
}
public function releaseArticle($data = null){ //发帖页面,POST类型,加入信息
$art = M("article"); //写入article数据表
$map['customerId']= $_POST['customerId']; //所需写入的函数
$map['name']= $_POST['name'];
$map['title'] = $_POST['title'];
$map['content'] = $_POST['content'];
$map['sendTime'] = $_POST['sendTime'];
$map['clickNum'] = $_POST['clickNum'];
$map['commentNum'] = $_POST['commentNum'];
$result = $art->data($map)->add(); //写入上列函数
if($result){ //成功则返回1,并输出addsuccess
$resultCode['code'] = "1";
$resultCode['msg'] = "addsuccess";
$this->ajaxReturn($resultCode,'JSON');
return;
}else{
$resultCode['code'] = "-1"; //不成功就返回-1,并输出addunsuccess
$resultCode['msg'] = "addunsuccess";
$this->ajaxReturn($resultCode,'JSON');
return;
}
}
public function replyArticle($data = null){ //评论回复页面,POST类型,加入信息
$art = M("comment"); //写入article数据表
$map['customerId']= $_POST['customerId']; //所需写入的函数
$map['name']= $_POST['name'];
$map['content'] = $_POST['content'];
$map['clickNum'] = $_POST['clickNum'];
$map['articleId']= $_POST['articleId'];
$map['commentTime'] = $_POST['commentTime'];
$result = $art->data($map)->add(); //写入上列函数
if($result){ //成功则返回1,并输出addsuccess
$resultCode['code'] = "1";
$resultCode['msg'] = "addsuccess";
$this->ajaxReturn($resultCode,'JSON');
return;
}else{
$resultCode['code'] = "-1"; //不成功就返回-1,并输出addunsuccess
$resultCode['msg'] = "addunsuccess";
$this->ajaxReturn($resultCode,'JSON');
return;
}
}
public function getmohuTitleList($data = null) { //搜索内容
$art = M("article");
$search = $_POST['text']; //接收用户输入搜索关键词内容
if($search) {
$map = ['title' => ['like', "%{$search}%"]]; //判断接收内容,map条件,查看数据表中的标题表是否有其中关键词
$data = $art->where($map)->select(); //返回从数据表满足条件的内容
}
if (count($data) > 0) { //成功则返回1,并输出搜索内容
$resultCode['code'] = "1";
$resultCode['msg'] = "getmohuTitleList";
$resultCode['getmohuTitleList'] = $data;
$this->ajaxReturn($resultCode,'JSON');
}else{
$resultCode['code'] = "-1"; //不成功就返回-1
$resultCode['msg'] = "getmohuTitleList";
$resultCode['getmohuTitleList'] = "";
$this->ajaxReturn($resultCode,'JSON');
}
}
public function getmyArticle($data = null){ //获取我的文章页面
$art = M("article"); //应用article数据表
$map['customerId'] = $_POST['customerId']; //发送customerId
$data=$art->where($map)->select();//返回与发送customerId相同的customerId所带的文章。
if (count($data) > 0) {
$resultCode['code'] = "1"; //成功则输出1以及文章列表内容
$resultCode['msg'] = "getmyArticle";
$resultCode['getmyArticle'] = $data;
$this->ajaxReturn($resultCode,'JSON');
}else{
$resultCode['code'] = "-1"; //不成功则返回-1
$resultCode['msg'] = "getmyArticle";
$resultCode['getmyArticle'] = "";
$this->ajaxReturn($resultCode,'JSON');
}
}
}
?>