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:get-user-preferences {--u|user=}';

    /**

     * The console command description.

     *

     * @var string

     */

    protected $description = 'lista preferências sogo do usuário';

    /**

     * 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( !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;

    }

}