/**
* 业务维度批量统计
*/
public function actionEmailBatchBusi()
{
try {
$busiStat = new EmailStatBusiness();
$serviceBinding = new ServiceBinding();
// 所有应用系统app_id
$appIdAll = $serviceBinding->getAllAppId(self::SERVICEID);
if (empty($appIdAll)) {
$this->stdout("不存在通过审核的第三方应用系统！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("不存在通过审核的第三方应用系统！！！", Logger::LEVEL_INFO, 'console\\controllers\\EmailController::email-batch-busi');
exit(6);
}
// 邮件业务信息
$business = EmailBusinessCategory::find()->where(['status' => 1])->orderBy('app_id')->asArray()->all();
if (arr_null($business)) {
$this->stdout("所有系统均没有绑定邮件业务ID！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("所有系统均没有绑定邮件业务ID！！！", Logger::LEVEL_INFO, 'console\\controllers\\EmailController::email-batch-busi');
exit(6);
}
// key为app_id value为邮件业务ID的数组
$appBusi = [];
foreach ($business as $busi) {
$appBusi[$busi['app_id']][] = $busi['id'];
}
foreach ($appIdAll as $key => $appId) {
if (!isset($appBusi[$appId])) {
unset($appIdAll[$key]);
}
}
if (empty($appIdAll)) {
$this->stdout("所有系统均没有绑定邮件业务ID！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("所有系统均没有绑定邮件业务ID！！！", Logger::LEVEL_INFO, 'console\\controllers\\EmailController::email-batch-busi');
exit(6);
}
$time = time();
$date = date('Ymd', time() - 24 * 60 * 60);
$type = self::BUSI_CACHE_PREFIX;
$keys = [];
$i = 0;
foreach ($appIdAll as $appIda) {
foreach ($appBusi[$appIda] as $busiId) {
$keys[$i]['key'] = $type . $appIda . ':' . $busiId . ':' . $date;
$keys[$i]['id'] = $appIda . '' . $busiId . '' . $date;
$keys[$i]['app_id'] = $appIda;
$keys[$i]['busiId'] = $busiId;
$i++;
}
}
$redis = Yii::$app->redisCache->redis;
$rows = [];
$appIds = [];
foreach ($keys as $key) {
$total = 0;
$appIds[] = $key['app_id'];
if ($redis->exists($key['key'])) {
$busis = $redis->hgetall($key['key']);
if (!empty($busis)) {
$total = count_sms_sum($busis);
}
}
$rows[] = [$key['id'], $key['app_id'], $key['busiId'], $date, $total, $time, $time];
}
$appIds = implode(',', array_unique($appIds));
$result = $busiStat->batchInsertStat($rows);
if (!$result) {
$this->stdout("应用ID为{$appIds}的应用系统业务维度统计失败！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("应用ID为{$appIds}的应用系统业务维度统计失败！！！", Logger::LEVEL_INFO, 'console\\controllers\\EmailController::email-batch-busi');
exit(3);
}
$this->stdout("应用ID为{$appIds}的应用系统业务维度统计成功！！！\r\n", Console::FG_GREEN);
$this->_fileLogger->writeOne("应用ID为{$appIds}的应用系统业务维度统计成功！！！", Logger::LEVEL_INFO, 'console\\controllers\\EmailController::email-batch-busi');
// 清除缓存
foreach ($keys as $key) {
$redis->del($key['key']);
}
exit;
} catch (\Exception $ex) {
$code = $ex->getCode();
if ($code == 23000) {
$this->stdout("应用中存在已经被备份（主键重复）~~\r\n", Console::FG_RED);
} else {
$this->stdout("系统出错，请稍后重试~~\r\n", Console::FG_RED);
}
$this->_fileLogger->writeOne($ex->getMessage(), Logger::LEVEL_ERROR, 'console\\controllers\\EmailController::email-batch-daily');
// 1表示异常退出
exit(1);
}
}
/**
* 业务维度批量统计
*/
public function actionSmsBatchBusi()
{
try {
$serviceBinding = new ServiceBinding();
// 所有应用系统app_id
$appIdAll = $serviceBinding->getAllAppId(self::SERVICEID);
if (empty($appIdAll)) {
$this->stdout("不存在通过审核的第三方应用系统！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("不存在通过审核的第三方应用系统！！！", Logger::LEVEL_INFO, 'console\\controllers\\SmsController::sms-batch-busi');
exit(6);
}
// 短信业务信息
$business = SmsBusinessCategory::find()->asArray()->where(['status' => 1])->orderBy('app_id')->all();
if (arr_null($business)) {
$this->stdout("所有系统均没有绑定短信业务ID！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("所有系统均没有绑定短信业务ID！！！", Logger::LEVEL_INFO, 'console\\controllers\\SmsController::sms-batch-busi');
exit(6);
}
// key为app_id value为短信业务ID的数组
$appBusi = [];
foreach ($business as $busi) {
$appBusi[$busi['app_id']][] = $busi['id'];
}
foreach ($appIdAll as $key => $appId) {
if (!isset($appBusi[$appId])) {
unset($appIdAll[$key]);
}
}
if (empty($appIdAll)) {
$this->stdout("所有系统均没有绑定短信业务ID！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("所有系统均没有绑定短信业务ID！！！", Logger::LEVEL_INFO, 'console\\controllers\\SmsController::sms-batch-busi');
exit(6);
}
$time = time();
$date = date('Ymd', time() - 24 * 60 * 60);
$type = 'SMS:BUSI';
$keys = [];
$i = 0;
foreach ($appIdAll as $appIda) {
foreach ($appBusi[$appIda] as $busiId) {
$keys[$i]['key'] = $type . ':' . $appIda . ':' . $busiId . ':' . $date;
$keys[$i]['id'] = $appIda . '' . $busiId . '' . $date;
$keys[$i]['app_id'] = $appIda;
$keys[$i]['busiId'] = $busiId;
$i++;
}
}
$redis = Yii::$app->redisCache->redis;
$rows = [];
$appIds = [];
foreach ($keys as $key) {
$total = 0;
$appIds[] = $key['app_id'];
if ($redis->exists($key['key'])) {
$busis = $redis->hgetall($key['key']);
if (!empty($busis)) {
$total = count_sms_sum($busis);
}
}
$rows[] = [$key['id'], $key['app_id'], $key['busiId'], $date, $total, $time, $time];
}
$appIds = implode(',', array_unique($appIds));
$connection = Yii::$app->getDb();
$transaction = $connection->beginTransaction();
$columns = ['id', 'app_id', 'sms_business_id', 'stat_day', 'total', 'create_time', 'update_time'];
$result = $connection->createCommand()->batchInsert(BusinessStat::tableName(), $columns, $rows)->execute();
if (!$result) {
$this->stdout("应用ID为{$appIds}的应用系统业务维度统计失败！！！\r\n", Console::FG_RED);
$this->_fileLogger->writeOne("应用ID为{$appIds}的应用系统业务维度统计失败！！！", Logger::LEVEL_INFO, 'console\\controllers\\SmsController::sms-batch-busi');
$transaction->rollBack();
exit(3);
}
$this->stdout("应用ID为{$appIds}的应用系统业务维度统计成功！！！\r\n", Console::FG_GREEN);
$this->_fileLogger->writeOne("应用ID为{$appIds}的应用系统业务维度统计成功！！！", Logger::LEVEL_INFO, 'console\\controllers\\SmsController::sms-batch-busi');
$transaction->commit();
// 清除缓存
foreach ($keys as $key) {
$redis->del($key['key']);
}
exit;
} catch (Exception $ex) {
$code = $ex->getCode();
if ($code == 23000) {
$this->stdout("应用中存在已经被备份（主键重复）~~\r\n", Console::FG_RED);
} else {
$this->stdout("系统出错，请稍后重试~~\r\n", Console::FG_RED);
}
$transaction->rollBack();
$this->_fileLogger->writeOne($ex->getMessage(), Logger::LEVEL_ERROR, 'console\\controllers\\SmsController::sms-batch-daily');
// 1表示异常退出
exit(1);
}
}
/**
* 根据短信服务配置短信验证
*
* @param string $appid 应用系统ID
* @param array $data 验证需要的参数
*
* @return array [a,b] a代码 b具体信息
*/
public function verifySetting($appid, $data, $isISystem)
{
// 获取文件缓存处理类
$cache = Yii::$app->getCache();
$settings = $cache->get('email:setting');
// 若缓存内容为空则查询数据库
if (!$settings || empty($settings)) {
$appConfigs = EmailSettingInfo::find()->asArray()->all();
if (arr_null($appConfigs)) {
return [0, 'success'];
}
$settings = $this->buildAppIdArray($appConfigs);
$cacheResult = $cache->set('email:setting', $settings);
if (!$cacheResult) {
// TODO:: 缓存设置失败
}
}
if (!isset($settings[$appid])) {
return [2202, 'error_appid_invalid'];
}
$setting = $settings[$appid];
if (!$isISystem) {
// 若域名白名单不为空
if ($setting['domain_white_list']) {
$domainWhiteList = json_decode($setting['domain_white_list'], true);
// 若不在白名单内
if (!in_array($data['host'], $domainWhiteList)) {
return [2007, 'error_domain_white_list'];
}
}
// 若IP白名单不为空
if (isset($data['source']) || $setting['ip_white_list']) {
$ipWhiteList = json_decode($setting['ip_white_list'], true);
// 若不在白名单内
if (!in_array($data['source'], $ipWhiteList)) {
return [2006, 'error_ip_white_list'];
}
}
}
$date = date('YmdH', time());
$key = 'EMAIL:MINUTE:' . $appid . ':' . $date;
$minutes = date('i');
$failKey = 'EMAIL:STATUS:' . $appid . ':' . 0 . ':' . date('Ymd', time());
$userKey = 'EMAIL:RECUSER:'******':' . date('YmdH', time());
$userBusiKey = 'EMAIL:UBUSI:' . $appid . ':' . $data['busiID'] . ':' . date('Ymd', time());
$hour = date('H');
$redis = Yii::$app->redisCache->redis;
// 用户业务每日接收上限控制
/*
if ($data['ubusi_daily_upper_limit'] > 0) {
$total = $redis->hget($userBusiKey, $data['mobile']);
if ($total >= $data['ubusi_daily_upper_limit']) {
return [2008, 'error_ubusi' . $data['busiID'] . '_upperlimit'];
}
}
*/
// 若应用每分钟发送上限大于0
if ($setting['app_minutely_send_limit'] > 0) {
$total = $redis->hget($key, $minutes);
if ($total > $setting['app_minutely_send_limit']) {
return [2008, 'error_minutely_upperlimit'];
}
}
// 若应用每小时发送上限大于0
if ($setting['app_hourly_send_limit'] > 0) {
$result = $redis->hgetall($key);
$total = count_sms_sum($result);
if ($total >= $setting['app_hourly_send_limit']) {
return [2003, 'error_hour_upperlimit'];
}
}
// 失败小时上限
if ($setting['send_failed_hourly_limit']) {
$total = $redis->hget($failKey, $hour);
if ($total >= $setting['send_failed_hourly_limit']) {
return [2010, 'error_hourly_fail_upperlimit'];
}
}
// 失败天上限
if ($setting['send_failed_daily_limit']) {
$result = $redis->hgetall($failKey);
$total = count_sms_sum($result);
if ($total >= $setting['send_failed_daily_limit']) {
return [2009, 'error_daily_fail_upperlimit'];
}
}
if ($setting['user_hourly_send_limit']) {
foreach ($data['to'] as $key => $email) {
$total = $redis->hget($userKey, $email);
if ($total >= $setting['user_hourly_send_limit']) {
return [2011, 'error_hourly_user_upperlimit '];
}
}
}
// 用户每小时发送上限
return [0, $data];
}
/**
* 根据短信服务配置短信验证
*
* @param string $appid 应用系统ID
* @param array $data 验证需要的参数
*
* @return array [a,b] a代码 b具体信息
*/
public function verifySetting($appid, $data, $isISystem = false)
{
// 获取文件缓存处理类
$cache = Yii::$app->getCache();
$settings = false;
//$cache->get('sms:setting');
// 若缓存内容为空则查询数据库
if (!$settings || empty($settings)) {
$appConfigs = SmsSetting::find()->asArray()->all();
if (arr_null($appConfigs)) {
return [0, 'success'];
}
$settings = $this->buildAppIdArray($appConfigs);
$cacheResult = $cache->set('sms:setting', $settings);
if (!$cacheResult) {
// TODO:: 缓存设置失败
}
}
if (!isset($settings[$appid])) {
return [2202, 'error_appid_invalid'];
}
$setting = $settings[$appid];
if (!$isISystem) {
// 若域名白名单不为空
if ($setting['domain_white_list']) {
$domainWhiteList = json_decode($setting['domain_white_list'], true);
// 若不在白名单内
if (!in_array($data['host'], $domainWhiteList)) {
return [2007, 'error_domain_white_list'];
}
}
// 若IP白名单不为空
if (isset($data['source']) || $setting['ip_white_list']) {
$ipWhiteList = json_decode($setting['ip_white_list'], true);
// 若不在白名单内
if (!in_array($data['source'], $ipWhiteList)) {
return [2006, 'error_ip_white_list'];
}
}
}
$date = date('YmdH', time());
$key = 'SMS:MINUTE:' . $appid . ':' . $date;
$minutes = date('i');
$failKey = 'SMS:STATUS:' . $appid . ':' . BaseSmsLog::STATUS_NOT_SEND . ':' . date('Ymd', time());
$userKey = 'SMS:RECUSER:'******':' . date('YmdH', time());
$userBusiKey = 'SMS:UBUSI:' . $appid . ':' . $data['busiID'] . ':' . date('Ymd', time());
$hour = date('H');
$redis = Yii::$app->redisCache->redis;
// 同一手机相同内容短信量的限制
if ($setting['mobile_content_send_limit'] > 0) {
$mobileConentKey = 'SMS:UCONTENT:' . $appid . ':' . date('Ymd', time());
$field = $data['mobile'] . ':' . md5($data['content']);
$num = $redis->hget($mobileConentKey, $field);
if ($num >= $setting['mobile_content_send_limit']) {
return [2013, 'error_mobile_content_upperlimit'];
}
}
// 用户业务每日接收上限控制
if ($data['ubusi_daily_upper_limit'] > 0) {
$total = $redis->hget($userBusiKey, $data['mobile']);
if ($total >= $data['ubusi_daily_upper_limit']) {
return [2008, 'error_ubusi' . $data['busiID'] . '_upperlimit'];
}
}
// 若应用每分钟发送上限大于0
if ($setting['app_minutely_send_limit'] > 0) {
$total = $redis->hget($key, $minutes);
if ($total > $setting['app_minutely_send_limit']) {
return [2008, 'error_minutely_upperlimit'];
}
}
// 若应用每小时发送上限大于0
if ($setting['app_hourly_send_limit'] > 0) {
$result = $redis->hgetall($key);
$total = count_sms_sum($result);
if ($total >= $setting['app_hourly_send_limit']) {
return [2003, 'error_hour_upperlimit'];
}
}
// 失败小时上限
if ($setting['send_failed_hourly_limit']) {
$total = $redis->hget($failKey, $hour);
if ($total >= $setting['send_failed_hourly_limit']) {
return [2010, 'error_hourly_fail_upperlimit'];
}
}
// 失败天上限
if ($setting['send_failed_daily_limit']) {
$result = $redis->hgetall($failKey);
$total = count_sms_sum($result);
if ($total >= $setting['send_failed_daily_limit']) {
return [2009, 'error_daily_fail_upperlimit'];
}
}
// 用户每小时发送上限
if ($setting['user_hourly_send_limit']) {
$total = $redis->hget($userKey, $data['mobile']);
if ($total >= $setting['user_hourly_send_limit']) {
return [2011, 'error_hourly_user_upperlimit '];
}
}
return [0, $data];
}