000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use App\User;
use App\LocalUserMapping;
use App\SparePartsMaster;
use App\WareHouse;
//use Excel;
use DB;
use App\Exports\ResignedTechStockExport;
use Maatwebsite\Excel\Facades\Excel;

class DashboardController extends Controller
{
    //
    public $data; 
    public function get_common(){
    	if(Auth::check()){
    		$user = Auth::user();
    		$this->data['userInfo'] = LocalUserMapping::where('LoginID',$user->loginId)->first();
    	}
    }
    public function list_of_circle_store(){
        $this->get_common();
        //$users = LocalUserMapping::where('StaffRole','Store Coordinator')->get();
        // $warehouses = WareHouse::where('ware_house','!=','SERPNT')->get();
        $loginId = Auth::user()->loginId;
        $warehouses = $this->getCircle($loginId);
        $this->data = array_merge($this->data,['warehouses'=>$warehouses]);       
        return view('admin.circle-stores',$this->data);
    }
    public function get_dashboard_page(){
       
    	$this->get_common();
    	$this->data['success'] = true;
    	return view('admin.dashboard',$this->data);
    }

public function get_tech_stocks(Request $request){
        $this->get_common();
        $loginId = Auth::user()->loginId;
        $assigned_warehouses = DB::table('local_user_mapping')
        ->select('local_user_mapping.warehouseCode')
        ->where('LoginID', $loginId)                
        ->first();
       $warehouses = explode(',', $assigned_warehouses->warehouseCode);  
    //    dd($warehouses);          
       //$current_warehouse = $warehouses[0];
        //$warehouses = WareHouse::where('ware_house','!=','SERPNT')->get();
        $this->data = array_merge($this->data,['warehouses'=>$warehouses]);
        return view('admin.tech-stocks',$this->data);
    }
    
    public function get_resigned_tech_stocks(Request $request){
        $this->get_common();
        $loginId = Auth::user()->loginId;
        $assigned_warehouses = DB::table('local_user_mapping')
        ->select('local_user_mapping.warehouseCode')
        ->where('LoginID', $loginId)                
        ->first();
        $warehouses = explode(',', $assigned_warehouses->warehouseCode);  
        // $warehouses = WareHouse::where('ware_house','!=','SERPNT')->get();

if($request->action_type == 'export') {
            $warehouses = $request->warehouse;
            // $warehouses = preg_split('/\,/', $warehouses);
            $resigned_tech_stock = array();
            $n = 0;

foreach($warehouses as $warehouse) {
                $eng_stocks = DB::table('engineer_inventory')->join('spare_parts_masters','spare_parts_masters.code','engineer_inventory.spare_code')->join('local_user_mapping','local_user_mapping.LoginID','engineer_inventory.engineer_id')
                ->select('engineer_inventory.warehouse','engineer_inventory.engineer_id','engineer_inventory.item_type','engineer_inventory.available_qty as qty', 'engineer_inventory.spare_code','spare_parts_masters.uom','spare_parts_masters.type','spare_parts_masters.description','local_user_mapping.StaffName','engineer_inventory.lot_no','engineer_inventory.rate')
                ->where('engineer_inventory.warehouse', $warehouse)
                ->where('local_user_mapping.StaffStatus','IA')
                ->where('engineer_inventory.available_qty','>',0)
                ->get();
                foreach($eng_stocks as $value) {
                   $resigned_tech_stock[$n] = $value;
                   $n++;
                }
            }
            
            return Excel::download(new ResignedTechStockExport($resigned_tech_stock), 'resignedTechStock.xlsx');
        }

$this->data = array_merge($this->data,['warehouses'=>$warehouses]);
        return view('admin.resigned-tech-stocks',$this->data);
    }

public function getCircle($loginId){
        //$user = \DB::table('users')->where('loginId',$loginId)->first();
        $warehouses = '';
        // if($user->role == 5){
        //     // Regional Manager

// $warehouses = DB::table('local_user_mapping')
        //  ->join('ware_houses','ware_house',\DB::raw("CONCAT('SER',local_user_mapping.fieldUserCodes)"))
        //  ->select('local_user_mapping.fieldUserCodes','ware_houses.*')
        //  ->where('regionalCircleCodes', $loginId)
        //  ->groupBy('local_user_mapping.fieldUserCodes')
        //  ->get();

// }elseif($user->role == 4){
        //     // Business Head
        //     $warehouses = WareHouse::get();
        // }
        // elseif($user->role == 17 || $user->role == 18 || $user->role == 20){

$assigned_warehouses = DB::table('local_user_mapping')
                 ->select('local_user_mapping.warehouseCode')
                 ->where('LoginID', $loginId)                
                 ->first();
            $warehouses = explode(',', $assigned_warehouses->warehouseCode);                        
            // dd($warehouses);

$warehouses = \App\WareHouse::whereIn('ware_house', $warehouses)->get();

//    }
    //     elseif($user->role == 6){
    //         // Service Manager
    //       $warehouses = DB::table('local_user_mapping')
    //      ->join('ware_houses','ware_house',\DB::raw("CONCAT('SER',local_user_mapping.fieldUserCodes)"))
    //      ->select('local_user_mapping.fieldUserCodes','ware_houses.*')
    //      ->where('serviceManagerCircleCodes', $loginId)
    //      ->groupBy('fieldUserCodes')
    //      ->get();

//     }
        return $warehouses;
}

}