1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677 |
- <?php
- namespace app\dao\work;
- use app\dao\BaseDao;
- use app\model\work\WorkGroupMsgSendResult;
- use crmeb\basic\BaseAuth;
- use crmeb\traits\SearchDaoTrait;
- class WorkGroupMsgSendResultDao extends BaseDao
- {
- use SearchDaoTrait;
-
- protected function setModel(): string
- {
- return WorkGroupMsgSendResult::class;
- }
-
- public function searchWhere(array $where, bool $authWhere = true)
- {
- [$with, $whereKey] = app()->make(BaseAuth::class)->________(array_keys($where), $this->setModel());
- $whereData = [];
- foreach ($whereKey as $key) {
- if (isset($where[$key]) && 'timeKey' !== $key) {
- $whereData[$key] = $where[$key];
- }
- }
- return $this->getModel()->withSearch($with, $where)->when(!empty($where['client_name']), function ($query) use ($where) {
- $query->whereIn('external_userid', function ($query) use ($where) {
- $query->name('work_client')->where('name', 'like', '%' . $where['client_name'] . '%')->field(['external_userid']);
- });
- })->when(!empty($where['notChatId']), function ($query) {
- $query->whereNotNull('chat_id');
- });
- }
-
- public function getGroupChatMsg(array $where)
- {
- return $this->getModel()->when(!empty($where['msg_id']), function ($query) use ($where) {
- $query->whereIn('msg_id', $where['msg_id']);
- })->when(!empty($where['status']), function ($query) use ($where) {
- $query->where('status', $where['status']);
- })->when(!empty($where['owner']), function ($query) use ($where) {
- $query->whereIn('userid', $where['owner']);
- })->group('userid')->field([
- "GROUP_CONCAT(chat_id) as chat_ids",
- "GROUP_CONCAT(status) as status_all", 'userid', 'status']);
- }
- }
|