SampelReport

Complexity

Total Complexity

2

Size/Duplication

Total Lines	40
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	up()	0	22	1
A	down()	0	4	1

<?php

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

class SampelReport extends Migration

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		DB::statement( "DROP VIEW IF EXISTS admin_count");
		DB::statement( "CREATE VIEW admin_count AS  
			select count(u.id)
			from users u, groups g ,users_groups ug
			where
			ug.user_id  = u.id and
			ug.group_id = g.id 
			");
		
		DB::table('reports')->insert(
        	[
	        	[
				'report_name' => 'admin_count',
				'view_name'   => 'admin_count',
				'created_at'  => \DB::raw('NOW()'),
				'updated_at'  => \DB::raw('NOW()')
	        	]
        	]
        );
	}

	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		// 
	}
}