Gecko [ gandhischool.edu.np ]

Name	Size	Permission
Admin	[ DIR ]	drwxr-xr-x
Auth	[ DIR ]	drwxr-xr-x
Authentication	[ DIR ]	drwxr-xr-x
Product	[ DIR ]	drwxr-xr-x
Setting	[ DIR ]	drwxr-xr-x
User	[ DIR ]	drwxr-xr-x
Controller.php	374 B	-rw-r--r--
HomeController.php	19.22 KB	-rw-r--r--
HomeController_09.php	19.22 KB	-rw-r--r--
HomeController_09282018.php	19.22 KB	-rw-r--r--
HomeController_backup.php	18.83 KB	-rw-r--r--
HomeController_l.php	9.54 KB	-rw-r--r--
HomeController_old.php	18.83 KB	-rw-r--r--
OrderController.php	14.55 KB	-rw-r--r--
OrderController_old.php	14.55 KB	-rw-r--r--
OrderPaymentController.php	6.73 KB	-rw-r--r--
OrderPaymentController_old.php	6.73 KB	-rw-r--r--
SuperAdminController.php	3.59 KB	-rw-r--r--
SuperAdminController_old.php	3.61 KB	-rw-r--r--
WelcomeController.php	1.03 KB	-rw-r--r--

Code Editor : SuperAdminController.php

<?php
namespace App\Http\Controllers;

use App\Model\Receive;
use App\Model\RepairDetail;
use App\Model\Company;
use App\Model\Payment;
use Illuminate\Http\Request;
use App\Http\Helpers\Constants;
use DB;

class SuperAdminController extends Controller
{

function __construct()
	{
	}

public function companyDetails(Request $request, $id)
	{

try {
			$selectColumns = [
				'company_name',
				'address',
				'with_cap',
				'without_cap',
				'total_cylinder',
				'date',
				'sum_body_leakage as body_leak',
				'sum_nozzle_change as nozzle_change',
				'sum_nozzle_repair as nozzle_repair',
				'sum_cap_change as cap_change',
				'sum_washer_change as washer_change',
				'sum_refill as refill',
				'repair_id'
			];
			$data = DB::table('view_company_rate')
				->select($selectColumns)
				->selectRaw('sum(price_nozzle_change+price_nozzle_repair+price_cap_change+price_washer_change+price_refill) as total_amount')
				->where('company_id', $id)
				->orderByDesc('receive_id')
				->groupBy('receive_id')
				->get();
		} catch (\Exception $e) {
			return $data = null;
		}
		return view('layouts.super_admin.company_details', compact('data'));
	}

public function superAdminTable(Request $request)
	{
		$id = $request->cId;
		$q = 'select max(receive_id) from view_company_rate group by company_id';
		try {
			$selectColumns = [
				'company_name',
				'address',
				'with_cap',
				'without_cap',
				'total_cylinder',
				'date',
				'sum_body_leakage as body_leak',
				'sum_nozzle_change as nozzle_change',
				'sum_nozzle_repair as nozzle_repair',
				'sum_cap_change as cap_change',
				'sum_washer_change as washer_change',
				'sum_refill as refill',
				'repair_id'
			];
			$data = DB::table('view_company_rate')
				->select($selectColumns)
				->selectRaw('sum(price_nozzle_change+price_nozzle_repair+price_cap_change+price_washer_change+price_refill) as total_amount')
				->where('company_id', $id)
				->whereNotIn('receive_id', [DB::raw($q)])
				->orderByDesc('receive_id')
				->groupBy('receive_id')
				->get();
		} catch (\Exception $e) {
			return $data = null;
		}
		$cylinderDetail = \View::make('layouts.super_admin.detail', compact('data'));
		return $cylinderDetail;
	}

public function cylinderNumbers(Request $request)
	{
		$column = $request->column;
		$repairId = $request->repairId;
		$cylinderDetail = RepairDetail::select('cylinder_code')->where('repair_id', $repairId)->where($column, 1)->get();
		$cylinderDetail = \View::make('layouts.super_admin.cylinderCode', compact('cylinderDetail', 'column'));
		return $cylinderDetail;
	}

public function advanceAmountDetail()
	{
		$paymentData = Payment::with(['receive' => function ($query) {
			$query->with('company');
		}])->where('date', \Carbon\Carbon::now()->toDateString())->get();
		$d = \View::make('layouts.super_admin.advance_amount_detail', compact('paymentData'));
		return $d;
	}

public function deleteCompanyViewMigration()
	{
		try {
			$d = DB::table('migrations')->where('migration', '2017_09_14_042819_CreateCompaniesView')->delete();
			\Artisan::call('migrate');
			return "Successfull Migrated Company View";
		} catch (\Exception $e) {
			dd("Migration Unsuccessfull", $e->getMessage());
		}
	}

public function migratePaymentsAndIsBilled()
	{
		try {
			\Artisan::call('migrate');
			return "Successfull Migrated Payment and isBilled migration";
		} catch (\Exception $e) {
			dd("Migration Unsuccessfull", $e->getMessage());
		}
	}

public function migrationReset()
	{
		try {
			\Artisan::call('migrate:reset');
			return "Successfull migration reset.";
		} catch (\Exception $e) {
			dd("Migration Unsuccessfull", $e->getMessage());
		}
	}
}

${this.title}

Code Editor : SuperAdminController.php