1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980 |
- <?php
- namespace App\Console\Commands\Tool;
- use DB;
- use Redis;
- use Illuminate\Console\Command;
- class ConfigSetting extends Command
- {
- const SPLIT_BOOK_PRIMARY_CHAPTER_NAME = 'config:split_book_primary_chapter_name';
- const INNER_SITE_ACTIVITY = 'config:inner_site_activity';
-
- protected $signature = 'Tool:ConfigSetting';
-
- protected $description = '站点配置';
-
- public function __construct()
- {
- parent::__construct();
- }
-
- public function handle()
- {
- $this->splitBookShowPrimaryConfig();
- $this->innerActivity();
- }
-
- private function splitBookShowPrimaryConfig(){
- $sql = "SELECT id FROM distribution_channels WHERE channel_user_id IN (SELECT id FROM channel_users WHERE phone in (
- '18668420256'))";
- $result = DB::select($sql);
- foreach ($result as $item){
- Redis::sadd(self::SPLIT_BOOK_PRIMARY_CHAPTER_NAME,$item->id);
- }
- }
-
- private function innerActivity(){
- $sql = "SELECT id FROM distribution_channels WHERE channel_user_id IN (SELECT id FROM channel_users WHERE phone in (
- '18668420256'))";
- $result = DB::select($sql);
- foreach ($result as $item){
- if(in_array($item->id, [])){
- continue;
- }
- Redis::sadd(self::INNER_SITE_ACTIVITY,$item->id);
- }
- }
- }
|