| Server IP : 156.238.232.47 / Your IP : 216.73.216.150 Web Server : nginx/1.25.3 System : Linux C202504152095410 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : www ( 1000) PHP Version : 8.3.25 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /www/wwwroot/2026_02_02_02/apps/admin/model/member/ |
Upload File : |
<?php
/**
* @copyright (C)2016-2099 Hnaoyun Inc.
* @author XingMeng
* @email hnxsh@foxmail.com
* @date 2020年06月27日
* 文章评论模型类
*/
namespace app\admin\model\member;
use core\basic\Model;
class MemberCommentModel extends Model
{
// 获取列表
public function getList()
{
$field = array(
'a.*',
'b.title',
'c.username',
'c.nickname',
'c.headpic'
);
$join = array(
array(
'ay_content b',
'a.contentid=b.id',
'LEFT'
),
array(
'ay_member c',
'a.uid=c.id',
'LEFT'
)
);
return parent::table('ay_member_comment a')->field($field)
->join($join)
->order('a.id desc')
->page()
->select();
}
// 查找
public function findComment($field, $keyword)
{
$fields = array(
'a.*',
'b.title',
'c.username',
'c.nickname',
'c.headpic'
);
$join = array(
array(
'ay_content b',
'a.contentid=b.id',
'LEFT'
),
array(
'ay_member c',
'a.uid=c.id',
'LEFT'
)
);
return parent::table('ay_member_comment a')->field($fields)
->join($join)
->like($field, $keyword)
->order('a.id desc')
->page()
->select();
}
// 获取详情
public function getComment($id)
{
$field = array(
'a.*',
'b.title',
'c.username',
'c.nickname',
'c.headpic',
'd.username as pusername',
'd.nickname as pnickname'
);
$join = array(
array(
'ay_content b',
'a.contentid=b.id',
'LEFT'
),
array(
'ay_member c',
'a.uid=c.id',
'LEFT'
),
array(
'ay_member d',
'a.puid=d.id',
'LEFT'
)
);
return parent::table('ay_member_comment a')->field($field)
->join($join)
->where("a.id=$id")
->find();
}
// 删除
public function delComment($id)
{
return parent::table('ay_member_comment')->where("id=$id")->delete();
}
// 删除多个
public function delCommentList($ids)
{
return parent::table('ay_member_comment')->delete($ids);
}
// 修改
public function modComment($id, $data)
{
return parent::table('ay_member_comment')->where("id=$id")
->autoTime()
->update($data);
}
// 修改多个
public function modCommentList($ids, $data)
{
return parent::table('ay_member_comment')->in('id', $ids)->update($data);
}
}