Expresso Livre Tools

<?php

namespace App\Console\Commands\Expresso;

use Illuminate\Console\Command;

use Illuminate\Support\Facades\DB;

use Storage;

class SieveGetUid extends Command

{

    /**

     * The name and signature of the console command.

     *

     * @var string

     */

    protected $signature = 'expresso:get-user-sieve-filters-by-line {--u|uid=} {cmd?}';

    /**

     * The console command description.

     *

     * @var string

     */

    protected $description = 'lista os filtros de usuários ( entrada: usuários separados por vírgula )';

    /**

     * Create a new command instance.

     *

     * @return void

     */

    public function __construct()

    {

        parent::__construct();

    }

    /**

     * Execute the console command.

     *

     * @return mixed

     */

    public function handle()

    {

        $arguments = $this->arguments();

        $uid = $this->option('uid') ?? null;

        if( !is_null($uid) ){

            $sieveRules = $this->getSieveRules($uid);

            if( isset($arguments['cmd']) && $arguments['cmd'] == 'print' )

            {

                $rules      = [];

                foreach( $sieveRules as $key => $sieve ){

                    $rules[$key]['regra']       = unserialize( $sieve->rule );

                    $rules[$key]['habilitada']  = $sieve->is_enabled;

                    $rules[$key]['dt_criacao']  = date('d/m/Y', strtotime($sieve->created_dt));

                    print_r( $rules[$key] );

                }

            }

            if( isset($arguments['cmd']) && $arguments['cmd'] == 'file' )

            {

                $lines = "Usuario : " . $uid . PHP_EOL;

                foreach( $sieveRules as $key => $sieve ){

                    $lines .= "regra      : " . $sieve->rule . PHP_EOL;

                    $lines .= "habilitada : " . $sieve->is_enabled . PHP_EOL;

                    $lines .= "dt_criacao : " . date('d/m/Y', strtotime($sieve->created_dt)) . PHP_EOL;

                    $lines .= "************************************************************************" . PHP_EOL . PHP_EOL;

                }

                Storage::put('file/file_'.$uid.'.txt', $lines );

            }

            if( isset($arguments['cmd']) && $arguments['cmd'] == 'fileSogo' )

            {

                print_r( storage_path('fileSogo') );

            }

        }

    }

    private function getSieveRules( $user )

    {

        $sieveRules = DB::connection('pgsql-expresso')

                            ->table('phpgw_sieve_rules')

                            ->where('fk_sieve_owner', $user )

                            ->get();

        return $sieveRules;

    }

}