Expresso Livre Tools

<?php

namespace App\Console\Commands\Sogo;

use Illuminate\Console\Command;

use Illuminate\Support\Facades\DB;

use Storage;

class Preferences extends Command

{

    /**

     * The name and signature of the console command.

     *

     * @var string

     */

    protected $signature = 'sogo:preferences-get {--u|user=} {cmd?}';

    /**

     * The console command description.

     *

     * @var string

     */

    protected $description = 'Lista as preferencias sogo 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();

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

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

        {

            $this->help();

        } else {

            if( !is_null($user) ){

                $preferences =  $this->getPreferences($user);

                print_r( json_decode($preferences->c_defaults) );

            }

        }

        $this->newLine();

    }

    private function getPreferences( $user )

    {

        $preferences = DB::connection('pgsql-sogo')

                            ->table('sogo_user_profile')

                            ->where('c_uid', $user )

                            ->first();

        return $preferences;

    }

    private function help()

    {

        $this->newLine();

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

        $this->info('Ex: php artisan sogo:preferences-get --user=<usuario> { print | file }');

        $this->newLine();

    }

}