<?php

namespace App\Console\Commands;

use Symfony\Component\Console\Output\ConsoleOutput;
use Symfony\Component\Console\Helper\ProgressBar;

use Illuminate\Console\Command;
use App\Modules\Noticia\Models\Noticia;
use App\WpPost;
use App\Services\GeralService;
use Illuminate\Support\Facades\Log;
use DB;

class ImportaPosts extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'importa_posts';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Importa Posts Wordpress';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
        $this->output = new ConsoleOutput;
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $this->info(date('d/m/Y H:i:s') . " - START");

        $posts       = WpPost::where('post_type', 'post')->where('post_status', 'publish')->orderBy('ID', 'ASC')->get();
        $progressBar = new ProgressBar($this->output, count($posts));

        foreach ($posts as $post) {

            $this->info(date('d/m/Y H:i:s') . " PostID: {$post->ID}" . "\n");

            $Noticia = Noticia::where('nome', $post->post_title)->first();
            
            if(!$Noticia){

                $Noticia = new Noticia;
                $Noticia->nome           = $post->post_title;
                $Noticia->descricao      = $post->post_content;
                $Noticia->slug           = $post->post_name;
                $Noticia->data           = date('Y-m-d', strtotime($post->post_date));
                $Noticia->data_completa  = $post->post_date;
                $Noticia->publicado      = 1;
                
            }else{
                $Noticia->data_completa = $post->post_date;
            }

            $Noticia->save();

            try {
                
                //Busca Imagem Destaque
                $postImage = WpPost::where('post_type', 'attachment')->where('post_parent', $post->ID)->whereRaw("post_mime_type LIKE '%image%'")->orderBy('ID', 'ASC')->first();

                if($postImage && !empty($postImage->guid)){
                    $url_imagem = $postImage->guid;
                    $img        = \Image::make($url_imagem);
                    $ext        = explode("/", $url_imagem);
                    $filename   = end($ext);
                    if($img->save(public_path() . '/uploads/noticia/' . $filename)){
                        $arquivo = GeralService::uploadFile(FALSE, 'noticia', ['filename' => $filename]);
                        if(!empty($arquivo->filename)){
                            $Noticia->thumbnail_principal = $arquivo->filename;
                            $Noticia->save();
                        }
                    }
                }
                
            } catch (\Intervention\Image\Exception\NotReadableException $ex) {
                $progressBar->advance();
                Log::info("PostID: {$post->ID} - " . $ex->getMessage());
                Log::info("PostID: {$post->ID} - " . $postImage->guid);
                $this->info(date('d/m/Y H:i:s') . " PostID: {$post->ID} - " . $ex->getMessage() . "\n");
                continue;
            } catch (Exception $e) {
                $progressBar->advance();
                Log::info("PostID: {$post->ID} - " . $e->getMessage());
                Log::info("PostID: {$post->ID} - " . $postImage->guid);
                $this->info(date('d/m/Y H:i:s') . " PostID: {$post->ID} - " . $ex->getMessage() . "\n");
                continue;
            }

            $progressBar->advance();

        }

        $progressBar->finish();

        $this->info(date('d/m/Y H:i:s') . " - DONE");
    }
}