CreateCustomerContactsView::up() - Code Metrics - Inspection of "Modified UI for Authorized Users and other changes" - butcherman/Tech_Bench - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — dev5 ( f3ede3...502bc5 )

by Ron

created 2019-10-23 00:04 UTC

CreateCustomerContactsView::up() A

↳ Parent: CreateCustomerContactsView

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	1
c	0
b	0
f	0
nc	1
nop	0
dl	0
loc	3
rs	10

<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCustomerContactsView extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        DB::statement('CREATE OR REPLACE VIEW `customer_contacts_view` AS 
            SELECT `customer_contacts`.`cont_id`, `customer_contact_phones`.`phone_number`, `customer_contact_phones`.`extension`, `phone_number_types`.`phone_type_id`,  `phone_number_types`.`description`, `phone_number_types`.`icon_class` 
            FROM `customer_contacts` 
            LEFT JOIN `customer_contact_phones` ON `customer_contacts`.`cont_id` = `customer_contact_phones`.`cont_id` 
            LEFT JOIN `phone_number_types` ON `customer_contact_phones`.`phone_type_id` = `phone_number_types`.`phone_type_id`');
    }

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


1			<?php
2
3			use Illuminate\Support\Facades\Schema;
4			use Illuminate\Database\Schema\Blueprint;
5			use Illuminate\Database\Migrations\Migration;
6
7			class CreateCustomerContactsView extends Migration
8			{
9			/**
10			* Run the migrations.
11			*
12			* @return void
13			*/
14			public function up()
15			{
16			DB::statement('CREATE OR REPLACE VIEW `customer_contacts_view` AS
17			SELECT `customer_contacts`.`cont_id`, `customer_contact_phones`.`phone_number`, `customer_contact_phones`.`extension`, `phone_number_types`.`phone_type_id`, `phone_number_types`.`description`, `phone_number_types`.`icon_class`
18			FROM `customer_contacts`
19			LEFT JOIN `customer_contact_phones` ON `customer_contacts`.`cont_id` = `customer_contact_phones`.`cont_id`
20			LEFT JOIN `phone_number_types` ON `customer_contact_phones`.`phone_type_id` = `phone_number_types`.`phone_type_id`');
21			}
22
23			/**
24			* Reverse the migrations.
25			*
26			* @return void
27			*/
28			public function down()
29			{
30			DB::statement('DROP VIEW IF EXISTS `customer_contacts_view');
31			}
32			}
33

butcherman / Tech_Bench

Push — dev5 ( f3ede3...502bc5 )

CreateCustomerContactsView::up() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like