Article.php
2.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
<?php
namespace app\api\model;
use think\Model;
class Article extends Model
{
protected $name = 'article';
// 定义时间戳字段名
protected $createTime = 'createtime';
protected $updateTime = 'updatetime';
protected $deleteTime = 'deletetime';
// 根据条件获取文章
public function listByWhere($where, $page, $size, $schoolId)
{
return $this
->alias('a')
->field('a.*, b.user_id, b.level, b.nickname, b.head_image, b.school_id, b.subject_ids, b.up_id, b.college_id, b.university_id, b.graduated_id, b.starttime, b.endtime, b.show_switch, b.email, b.vip_level, b.vip_endtime')
->join('student b', 'a.user_id = b.user_id')
->where(function ($query) use ($schoolId) {
$query
->where(' (a.show_type = 1 and b.school_id = '.$schoolId.') or a.show_type = 2');
})
->where($where)
->useSoftDelete('a.'.$this->deleteTime)
->order('a.createtime', 'desc')
->page($page, $size)
->select();
}
// 获取文章详细
public function infoById($id)
{
return $this
->alias('a')
->field('a.*, b.user_id, b.level, b.nickname, b.head_image, b.school_id, b.subject_ids, b.up_id, b.college_id, b.university_id, b.graduated_id, b.starttime, b.endtime, b.show_switch, b.email, b.vip_level, b.vip_endtime')
->join('student b', 'a.user_id = b.user_id')
->where(['a.id' => ['=', $id], 'a.show_switch' => ['=', 1]])
->useSoftDelete('a.'.$this->deleteTime)->find();
}
// 添加一个文章
public function addOne($data)
{
return $this->insert($data);
}
// 获取我发布的文章
public function listByUserId($userId, $page, $size)
{
return $this->where(['user_id' => ['=', $userId]])->page($page, $size)->order($this->createTime, 'desc')->select();
}
// 获取
public function infoByIdNoWhere($articleId)
{
return $this->where(['id' => ['=', $articleId]])->find();
}
// 删除某个文章
public function delOne($articleId, $data)
{
return $this->where(['id' => ['=', $articleId]])->update($data);
}
}