Gel4y Mini Shell

Edit file

File name : 2023_01_25_134038_create_viewfiltros_view.php

Content :

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Support\Facades\DB;

class CreateViewfiltrosView extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        // Esse view foi descontinuado
        //DB::statement("CREATE VIEW `viewfiltros` AS select `ct`.`customer_id` AS `customer_id`,`ct`.`team_id` AS `team_id`,`ct`.`assistent_id` AS `assistent_id`,`ct`.`cob_id` AS `cob_id`,`ct`.`brand_id` AS `brand_id`,`ct`.`sector_id` AS `sector_id`,`ct`.`stage_id` AS `stage_id`,`ct`.`contactable` AS `contactable`,`ct`.`created_at` AS `created_at`,`it`.`nome` AS `nome`,`it`.`cpf` AS `cpf`,`cn`.`contrato` AS `contrato`,`tc`.`event` AS `event`,`us`.`name` AS `name`,`tm`.`team` AS `team` from (((((`digitalbr_crm_30nov`.`customers` `ct` left join `digitalbr_crm_30nov`.`informations` `it` on((`it`.`customer_id` = `ct`.`customer_id`))) left join `digitalbr_crm_30nov`.`contracts` `cn` on((`cn`.`customer_id` = `ct`.`customer_id`))) left join `digitalbr_crm_30nov`.`timeline_customer` `tc` on((`tc`.`customer_id` = `ct`.`customer_id`))) left join `digitalbr_crm_30nov`.`users` `us` on((`us`.`id` = `ct`.`assistent_id`))) left join `digitalbr_crm_30nov`.`teams` `tm` on((`tm`.`team_id` = `ct`.`team_id`))) where (`tc`.`timeline_id` = (select max(`tc`.`timeline_id`) from `digitalbr_crm_30nov`.`timeline_customer` `tc` where (`tc`.`customer_id` = `ct`.`customer_id`))) order by `ct`.`customer_id` desc");
    }

/**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        DB::statement("DROP VIEW IF EXISTS `viewfiltros`");
    }
}