Пример #1
0
 /**
  * 业务维度批量统计
  */
 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);
     }
 }
Пример #2
0
 /**
  * 业务维度批量统计
  */
 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);
     }
 }
Пример #3
0
 /**
  * 根据短信服务配置短信验证
  *
  * @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];
 }
Пример #4
0
 /**
  * 根据短信服务配置短信验证
  *
  * @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];
 }