<?php
|
|
namespace app\api\model\settings;
|
|
use app\common\model\settings\Message as MessageModel;
|
use app\common\model\settings\MessageSettings as MessageSettingsModel;
|
|
/**
|
* 消息模型
|
*/
|
class Message extends MessageModel
|
{
|
/**
|
* 获取消息
|
*/
|
public static function getMessageByNameArr($platform = '', $message_ename_arr)
|
{
|
$template_arr = [];
|
//只适用于微信
|
if($platform != 'wx'){
|
return $template_arr;
|
}
|
$model = new self();
|
//子查询先过滤条件
|
$settings_model = new MessageSettingsModel;
|
$subsql = $settings_model->where('wx_status', '=', 1)
|
->where('app_id', '=', self::$app_id)
|
->buildSql();
|
|
$template_list = $model->withoutGlobalScope()->alias('message')->field(['message.*','settings.wx_status','settings.wx_template'])
|
->where('message.message_ename', 'in', $message_ename_arr)
|
->where('message.is_delete', '=', 0)
|
->join([$subsql=> 'settings'], 'settings.message_id = message.message_id', 'left')
|
->order(['message.sort' => 'asc'])
|
->select()->toArray();
|
|
foreach($template_list as $template){
|
if($template['wx_template']){
|
$json = json_decode($template['wx_template'], true);
|
array_push($template_arr, $json['template_id']);
|
}
|
}
|
return $template_arr;
|
}
|
}
|
