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:sieve-get {--u|uid=} {cmd?}';

    /**

     * The console command description.

     *

     * @var string

     */

    protected $description = 'Lista os scripts sieve do usuario';

    /**

     * 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( isset($arguments['cmd']) && $arguments['cmd'] == 'help' )

        {

            $this->help();

        } else {

            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') );

                }

            }

        }

        $this->newLine();

    }

    private function getSieveRules( $user )

    {

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

                            ->table('phpgw_sieve_rules')

                            ->where('fk_sieve_owner', $user )

                            ->get();

        return $sieveRules;

    }

    private function help()

    {

        $this->newLine();

        $this->info('EXEMPLO DE UTILIZACAO : ');

        $this->info('Ex: php artisan expresso:sieve-get --uid=<000000> { print | file | fileSogo }');

        $this->newLine();

    }

}