MessagesModel.class.php
1.6 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
<?php
/**
* Created by PhpStorm.
* User: Dell
* Date: 2018/9/4
* Time: 9:37
*/
namespace Common\Model;
use Common\Common\Constant;
use Common\Model\AttachmentModel;
class MessagesModel extends AbstractModel
{
/*
* m_status 1:未审核 2:审核未通过 3:审核通过 4:已删除
*/
/**
* 构造方法
* MessagesModel constructor.
*/
public function __construct()
{
$this->prefield = 'm_';
parent::__construct();
}
/**
* 联合用户表查询留言列表
* @param null $page_option
* @return array
*/
public function all_mess_list($page_option = null)
{
$sql = "SELECT u_name,m.* FROM luoyanshou_luoyanshou,luoyanshou_messages m WHERE u_id = m.m_uid AND m.m_status <> 4 ORDER BY ins_date DESC ";
return $this->_m->fetch_array($sql, [], $page_option);
}
/**
* 查询留言详细
* @param null $mid
* @return array
*/
public function get_mess_detail($mid = null)
{
$sql = "SELECT u_name,u_sex,u_mail,u_tel,m.* FROM luoyanshou_luoyanshou,luoyanshou_messages m WHERE u_id = m.m_uid AND m_id = {$mid} ";
return $this->_m->fetch_row($sql);
}
/**
* update 留言状态
* @param null $mid
* @param string $scenario
* @return array
*/
public function update_mess($mid=null,$scenario='del')
{
$time = date('Y-m-d H:i:s',time());
if ($scenario == 'del') {
$sql = "UPDATE luoyanshou_messages SET m_status=4,m_updated='$time' WHERE m_id = {$mid}";
return $this->_m->update($sql);
}
}
}