li
1b24994e74
- Contract.php: 返回合约账户余额(balance_contract) - My.php: 地址管理增加BTC/ETH - AppContract.php: 一键平仓(closeall) - AppProxy.php: 代理专属注册链接 + 分级权限(L1/L2) - site.php: 手续费减半(0.018→0.009) - agent_permission_setup.sql: 代理权限SQL - crypto_news_crawler.py: 新闻自动采集脚本
57 lines
1.3 KiB
PHP
Executable File
57 lines
1.3 KiB
PHP
Executable File
<?php
|
|
|
|
namespace app\admin\model;
|
|
|
|
use think\Model;
|
|
use traits\model\SoftDelete;
|
|
|
|
class KeFuSession extends Model
|
|
{
|
|
|
|
use SoftDelete;
|
|
|
|
// 表名
|
|
protected $name = 'kefu_session';
|
|
|
|
// 自动写入时间戳字段
|
|
protected $autoWriteTimestamp = 'int';
|
|
|
|
// 定义时间戳字段名
|
|
protected $createTime = 'createtime';
|
|
protected $updateTime = false;
|
|
protected $deleteTime = 'deletetime';
|
|
|
|
// 追加属性
|
|
protected $append = [
|
|
'user_message_count',
|
|
'csr_message_count',
|
|
];
|
|
|
|
public function getUserMessageCountAttr($value, $data)
|
|
{
|
|
return \think\Db::name('kefu_record')
|
|
->where('session_id', $data['id'])
|
|
->where('message_type', '<>', 3)
|
|
->where('sender_identity', 1)
|
|
->count('id');
|
|
}
|
|
|
|
public function getCsrMessageCountAttr($value, $data)
|
|
{
|
|
return \think\Db::name('kefu_record')
|
|
->where('session_id', $data['id'])
|
|
->where('sender_identity', 0)
|
|
->count('id');
|
|
}
|
|
|
|
public function kefuuser()
|
|
{
|
|
return $this->belongsTo('KeFuUser', 'user_id', 'id', [], 'LEFT')->setEagerlyType(0);
|
|
}
|
|
|
|
public function csr()
|
|
{
|
|
return $this->belongsTo('Admin', 'csr_id', 'id', [], 'LEFT')->setEagerlyType(0);
|
|
}
|
|
}
|