book_admin/application/admin/controller/vipcustom/Viplinktextmedia.php

<?php

namespace app\admin\controller\vipcustom;

use app\admin\controller\auth\Admin;
use app\admin\service\CommonService;
use app\admin\service\CustomService;
use app\admin\service\ExclusiveService;
use app\common\constants\Message;
use app\common\controller\Backend;
use app\common\constants\Common;
use app\common\constants\Menu;
use app\common\model\Book;
use app\common\model\SubscriptionRelation;
use app\common\constants\OfficialAccount;
use app\common\constants\ErrorCode;
use app\common\model\VipAdminBind;
use app\main\constants\AdminConstants;
use app\main\service\MiniProgramService;

class Viplinktextmedia extends Backend
{
    /**
     * @var \app\admin\model\CustomMedia
     */
    protected $model = null;

    /**
     * @var \app\common\model\VipAdminBind
     */
    protected $vipBindModel = null;

    /**
     * @var \app\common\model\AdminConfig
     */
    protected $adminConfigModel = null;

    /**
     * @var \app\common\model\SubscriptionRelation
     */
    protected $subscriptionRelationModel = null;

    /**
     * @var CustomService
     */
    protected $custom_service;

    public function _initialize()
    {
        header("Content-Type: text/html;charset=utf-8");
        parent::_initialize();
        $this->model = model('CustomMedia');
        $this->vipBindModel = model('VipAdminBind');
        $this->custom_service = new CustomService();
        $this->adminConfigModel = model('AdminConfig');
        $this->subscriptionRelationModel = model('SubscriptionRelation');
        $miniOpen =  MiniProgramService::instance()->miniWrite($this->auth->id,$this->group);
        $miniPages = MiniProgramService::instance()->getMiniPage();
        $this->assign('miniOpen',$miniOpen);
        $this->assign('miniPages',$miniPages);
    }

    /**
     * 查看
     */
    public function index()
    {
        //设置过滤方法
        $this->request->filter(['strip_tags']);

        if ($this->request->isAjax()) {
            //如果发送的来源是Selectpage，则转发到Selectpage
            if ($this->request->request('pkey_name')) {
                return $this->selectpage();
            }
            list($where, $sort, $order, $offset, $limit) = $this->buildparams();
            $channelIds = $this->vipBindModel->getChannelIds($this->auth->id);
            $channelIds[] = $this->auth->id;
            $condition = [
                'message_type' => Message::MESSAGE_TYPE_LINK,
                'status' => Common::STATUS_NORMAL,
                'created_admin_id' => ['in', $channelIds],
            ];

            $filter = $this->request->get("filter", '');
            $filter = json_decode($filter, true);
            $where = [];

            if ($filter) {
                foreach ($filter as $k => $v) {
                    switch ($k) {
                        case 'id':
                            $where[$k] = $v;
                            break;
                        case 'message_text$[*].book_name':
                            $where["message_text->'$[*].book_name'"] = ['like', "%$v%"];
                            break;
                        default:
                            break;
                    }
                }
            }

            $total = $this->model
                ->where($where)
                ->where($condition)
                ->count();

            $list = $this->model
                ->where($where)
                ->where($condition)
                ->order($sort, $order)
                ->limit($offset, $limit)
                ->select();
            $result = array("total" => $total, "rows" => $list);
            return json($result);
        }
        return $this->view->fetch();
    }

    /**
     * @param string $ids
     * @return mixed|\think\response\Json
     * @throws \think\exception\DbException
     */
    public function viewDetail($ids = '')
    {
        if($ids) {
            if ($this->request->isAjax()) {
                $result = CustomService::instance()->getCustomMediaDetail($ids, Message::MESSAGE_TYPE_LINK);
                return json($result);
            }
            return $this->fetch();
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }


    /**
     * 图文客服消息素材库 群发消息
     * @param string $ids
     * @param string $official_type 0 =>群发服务号  1=>群发订阅号
     */
    /**
     * 图文客服消息素材库 群发消息
     * @param string $ids
     * @param string $official_type 0 =>群发服务号  1=>群发订阅号
     */
    public function multiSendMessage($ids = '', $official_type = 0)
    {
        if ($ids) {
            if ($this->request->isPost()) {
                $params = $this->request->param();
                $sendTime = $params['row']['sendtime'];
                $iAdminId = $this->auth->id;
                if ($official_type == OfficialAccount::OFFICIAL_ACCOUNT_TYPE_SERVICE) {
                    if ($params['row']['select_type'] == 1) {
                        //分组 拉取公众号ID
                        $groupIds = trim($params['row']['group_id'], ',');
                        $channelRows = model("VipGroupInfo")->where('group_id', 'in', $groupIds)->field("channel_id")->select();
                        $channelIds = array_unique(array_column($channelRows, 'channel_id'));
                    } else {
                        $channelIds = $params['row']['service_id'];
                    }
                    $result = CustomService::instance()->multiSendMessageService($ids, $sendTime, $channelIds, $iAdminId, ['group_id' => $params['row']['group_id'], 'select_type' => $params['row']['select_type']]);
                } else {
                    $subIds = $params['row']['sub_id'];
                    $channelId = $params['row']['channel_id'];
                    $result = CustomService::instance()->multiSendMessageSub($ids, $sendTime, $subIds, $channelId, $iAdminId);
                }
                if ($result['error'] == ErrorCode::SUCCESS) {
                    $this->success();
                } else {
                    $this->error($result['msg']);
                }
            } else {
                $vipId = $this->auth->id;
                $adminIds = $this->vipBindModel->getChannelIds($vipId);
                if ($official_type == OfficialAccount::OFFICIAL_ACCOUNT_TYPE_SERVICE) {//公众号
                    $accList = $this->adminConfigModel->getListByAcc($adminIds);
                    $this->assign("acclist", $accList);
                } elseif ($official_type == OfficialAccount::OFFICIAL_ACCOUNT_TYPE_SUBSCRIPTION) {//订阅号
                    $adminIds[] = $vipId;
                    $subList = $this->subscriptionRelationModel->getSubListByAdminId($adminIds);
                    $this->assign("sublist", $subList);
                }
                $wechatAccountLimit = CommonService::instance()->getWechatAccountLimit();
                $this->assign('sub_limited', $wechatAccountLimit['subLimitNum']);
                $this->assign('service_limited', $wechatAccountLimit['serLimitNum']);
                $this->assign('acc_type', $official_type);
                return $this->fetch();
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }

    /**
     * @param string $ids 素材ID
     * @param string $idx 数组下标
     */
    public function getMediaMessage($ids = '', $idx = '')
    {
        $media = $this->model->get(['id' => $ids]);
        $message_json_arr = json_decode($media->message_text, true);
        //兼容description
        if (!isset($message_json_arr[$idx]['description'])) {
            $message_json_arr[$idx]['description'] = '';
        }

        $data = json_encode($message_json_arr[$idx]);
        if ($media->message_text) {
            return json(['code'=> 0, 'msg'=>'success', 'data'=> $data]);
        } else {
            return json(['code'=> 1, 'msg'=>'fail', 'data'=> '']);
        }
    }

    public function editlinktext()
    {
        $channelId = $this->auth->id;
        if ($this->request->isPost()) {
            $params = $this->request->post();
            $type = $params['row']['imgtxt_type'];
            $result = ['type' => $type];
            if ($type == Message::MESSAGE_LINK_TYPE_BOOK) {
                $result = array_merge($result, $params['book']);
                #$result['book_name'] = $params['book_book_id_text'];
            } elseif ($type == Message::MESSAGE_LINK_TYPE_ACTIVITY) {
                $result = array_merge($result, $params['activity']);
            } elseif ($type == Message::MESSAGE_LINK_TYPE_RECENT) {
                $result = array_merge($result, $params['recent']);
            } elseif ($type == Message::MESSAGE_LINK_TYPE_MENU) {
                $result = array_merge($result, $params['menu']);
            } elseif ($type == Message::MESSAGE_LINK_TYPE_NOURL) {
                $result = array_merge($result, $params['no_url']);
            } elseif ($type == Message::MESSAGE_LINK_TYPE_SIGN) {
                $params['sign']['url'] = "weixin://bizmsgmenu?msgmenucontent=" . Message::MESSAGE_KEYWORD . "&msgmenuid=" . time();
                $result = array_merge($result, $params['sign']);
            } elseif ($type == Message::MESSAGE_LINK_TYPE_CUSTOMIZE_ACTIVITY) {
                $result = array_merge($result, $params['customize_activity']);
            }elseif ($type == Message::MESSAGE_LINK_TYPE_DAILY_LINK) {
                $result = array_merge($result, $params['daily_url']);
            }elseif ($type == Message::MESSAGE_LINK_TYPE_MINI){
                $result = array_merge($result,$params['mini']);
            }

            $this->success('', null, $result);
        } else {

            $json_str = $this->request->get('json');
            $params = json_decode($json_str, true, 512, JSON_BIGINT_AS_STRING );
            $params['page'] = $params['page'] ?? '';
            $params['mini_type'] = $params['mini_type'] ?? 3;
            $referralModel = model('Referral');

            $wxTypeList = $referralModel->getWxTypeList();
            $pushList = $referralModel->getPushList();
            //$recentUrl = Message::getRecentFullPath($channelId);

            $aActivity = CommonService::instance()->getValidActivities($this->auth->id);
            $customActivity = CommonService::instance()->getVipActivityList($this->auth->id);
            $menuList = [];
            foreach (Menu::$allLinks as $key => $link) {
                $menuList[$key] = $link['title'];
            }

            if(array_key_exists('book_id', $params)){
                $mBook = new Book();
                $oBook = $mBook->where(['id'=>$params['book_id']])->find();
                $this->assign('sex_text', $oBook->sex_text);
            }

            $bnotin= [];
            ExclusiveService::instance()->getExclusiveNotidsWithoutWhere($this->group, $this->auth->id,$bnotin);
            $this->assignconfig('bnotin', $bnotin);

            //常用链接地址列表
            $dailyLink = CommonService::instance()->getTmpDailyLink();

            $this->assign('acc_type', Message::MESSAGE_TYPE_LINK);
            $this->view->assign("dailyLink", $dailyLink);
            $this->view->assign("params", $params);
            $this->view->assign("type", $params['type']);

            $this->view->assign("menuList", $menuList);
            $this->view->assign("wxTypeList", $wxTypeList);
            $this->view->assign("activityList", $aActivity);
            $this->view->assign("customActivityList", $customActivity);
            $this->view->assign("pushList", $pushList);
            //$this->view->assign("recent_url", $recentUrl);

        }
        return $this->view->fetch();
    }

    /**
     * 编辑链接
     * @param string $ids
     */
    public function editLink($idx = 0, $ids = '', $message_json = '')
    {
        if ($ids && $message_json) {
            $media = $this->model->get(['id' => $ids]);
            $media_arr = json_decode($media->message_text, true);
            # 替换值
            $media_arr[$idx] = json_decode($message_json, true);
            $rst = $this->model->save(['message_text' => json_encode($media_arr)], ['id' => $ids]);
            if ($rst) {
                return json(['code' => 0, 'msg' => '修改成功']);
            } else {
                return json(['code' => 1, 'msg' => '修改失敗']);
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids 和 message_json'));
    }

    /**
     * 文本素材，删除单条
     */
    public function delSinglePiece($idx = 0, $ids = '')
    {
        if ($ids) {
            $media = $this->model->get(['id' => $ids]);
            $media_arr = json_decode($media->message_text, true);
            unset($media_arr[$idx]);
            $media_arr = array_values($media_arr);

            # 替换值
            //$media_arr[$idx] = json_decode($message_json, true);
            $rst = $this->model->save(['message_text' => json_encode($media_arr)], ['id' => $ids]);
            if ($rst) {
                return json(['code' => 0, 'msg' => '删除成功']);
            } else {
                return json(['code' => 1, 'msg' => '删除失敗']);
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }

    /**
     * 删除文字素材
     * @param string $ids
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function del($ids = '')
    {
        if ($ids) {
            $pk = $this->model->getPk();
            $list = $this->model->where($pk, 'in', $ids)->select();
            $count = 0;
            foreach ($list as $k => $v) {
                $count += $v->deleteMedia($v->id);
            }
            if ($count) {
                $this->success();
            } else {
                $this->error(__('No rows were deleted'));
            }
        }
        $this->error(__('Parameter %s can not be empty', 'ids'));
    }
}