Expresso Livre Tools

<?php

namespace App\Console\Commands\Expresso;

use Illuminate\Console\Command;

use Illuminate\Support\Facades\DB;

use Illuminate\Support\Facades\File;

class SieveGetListFile extends Command

{

    /**

     * The name and signature of the console command.

     *

     * @var string

     */

    protected $signature = 'expresso:get-user-sieve-filters-from-file {--f|file=} {cmd?}';

    /**

     * The console command description.

     *

     * @var string

     */

    protected $description = 'lista os filtros de usuarios ( entrada: usuários em arquivo )';

    /**

     * Create a new command instance.

     *

     * @return void

     */

    public function __construct()

    {

        parent::__construct();

    }

    /**

     * Execute the console command.

     *

     * @return mixed

     */

    public function handle()

    {

        $arguments = $this->arguments();

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

        if( !is_null($fileName) ){

            if( file_exists($fileName) ){

                File::delete( "sieve_" . $fileName );

            }

            $handle = fopen( $fileName, "r");

            if ($handle) {

                while ( ($line = fgets($handle)) !== false) {

                    // cn; uid; uidnumber

                    $cn         = "";

                    $uid        = "";

                    $uidnumber  = "";

                    list( $cn ,$uid, $uidnumber) = explode( ";", $line );

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

                    $this->writeFile( $uid, $sieveRules, $fileName );

                }

                fclose($handle);

                $this->info( "Arquivo gerado com sucesso : " . "sieve_". $fileName );

            } else {

                $this->error("Arquivo não encontrado");

            }                 

        }

    }

    private function getSieveRules( $user )

    {

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

                            ->table('phpgw_sieve_rules')

                            ->where('fk_sieve_owner', $user )

                            ->get();

        return $sieveRules;

    }

    private function writeFile( $uid, $sieveRules, $fileName )

    {

        foreach( $sieveRules as $rule ){ 

            $line = "";

            $line .= $uid . "|" . $rule->rule . "|" . ( $rule->is_enabled  == "1" ? "1" : "0" ) . PHP_EOL; 

            File::append( "sieve_". $fileName, $line );

        }

    }

}