000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use App\SparePartsMaster;
use App\SpareRequestByEngineer;
use App\LocalUserMapping;
use DB;
class ApiController extends Controller
{
    //

public function get_spare_list_of_engineer(Request $request){
        $engineer_id = $request->engineer_id;
        $is_valid_en_id = LocalUserMapping::where('LoginID', $engineer_id)->where('role','field_user')->count();
        if($is_valid_en_id > 0){
            $engineer_spare = DB::table('engineer_spare_parts')->join('spare_parts_masters','spare_parts_masters.code','engineer_spare_parts.spare_code')->join('spart_value_type','spart_value_type.UOM','spare_parts_masters.uom')->whereNotIn('category',['Tools'])->where('engineer_spare_parts.engineer_id',$engineer_id)->get();

return json_encode(['success'=>true, 'engineer_spare'=>$engineer_spare]);
        }else{
            return json_encode(['success'=>false, 'msg'=>'Invalid Engineer Id']);
        }
    	
    }

public function get_site_list_of_engineer(Request $request){
        $engineer_id = $request->engineer_id;
        $is_valid_en_id = LocalUserMapping::where('LoginID', $engineer_id)->where('role','field_user')->count();
        if($is_valid_en_id > 0){
            $engineer_site = DB::table('site_masters')->where('Eng_code',$engineer_id)->get();

if(!$engineer_site->isEmpty()) {
                return json_encode(['success'=>true, 'engineer_spare'=>$engineer_spare]);
            } else {
                return json_encode(['success'=>false, 'msg'=>'Not Site Found.']);
            }            
        }else{
            return json_encode(['success'=>false, 'msg'=>'Invalid Engineer Id']);
        }
    	
    }

public function add_request(Request $request){
    	$spare = new SpareRequestByEngineer();
    	$spare->enginer_id = $request->enginer_id;
    	$spare->engineer_loginId = $request->engineer_loginId;
    	$spare->spare_code = $request->spare_code;
    	$spare->save();
    	return json_encode(['success'=>true, 'msg'=>'request added successfully']);
    }

public function addOtherFsr(Request $req) {
        logger($req->all());
        logger("logger : ");
        return true;
    }

public function getSpareListOfSite(Request $request)
	{
		echo "engineer id ".$engineer_id = $request->engineer_id;		
		
		// echo $query1 = "SELECT Site_ID FROM call_log WHERE Allot_To_Engg_Code LIKE '".$engineer_id."' AND job_status LIKE 'accepted' AND job_process_status != 'Complete' OR job_process_status ='' ";
        \DB::enableQueryLog();
        $engineer_spare = \DB::table('call_log')->select('Site_ID')->where('Allot_To_Engg_Code', $engineer_id)->where('job_status', 'LIKE', 'accepted')->where(function($q){
            $q->where('job_process_status', '!=', 'Complete')->orWhere('job_process_status', '=', '');
        })->get();

dd(\DB::getQueryLog($engineer_spare));
        dd($engineer_spare);
				
		$engineer_spare = \DB::select($query1);
        
		if(count($engineer_spare) > 0){			
            $site_str = '';
			foreach ($engineer_spare as $key => $value) {
				$site = $value->Site_ID;
				$site_str .= "\"{$site}\"".',';
			}

$site_str = rtrim($site_str, ',');			
			$siteArr = explode(',', $site_str);
			$siteArr = array_unique($siteArr);
			$site_str = implode(',', $siteArr);
			
			$query = "SELECT es.warehouse,es.engineer_id,es.fresh_qty, es.faulty_qty, es.repaired_qty, CONCAT(spm.code, ' ', sm.Site_id, '::', es.site_product) as spare_code, spm.*, sm.*, spart_value_type.* FROM engineer_spare_parts as es join site_master as sm on sm.Site_id = es.engineer_id join spare_parts_masters as spm on spm.code = es.spare_code JOIN spart_value_type on spart_value_type.UOM = spm.uom where spm.category != 'Tools' and  es.engineer_id IN(".$site_str.")";

//exit;
            $engineer_spare = \DB::select($query);

if (count($engineer_spare) > 0) {
				echo json_encode(array('success' => true, 'engineer_spare' => $engineer_spare), JSON_INVALID_UTF8_IGNORE);
				exit;
			}
		} 
		
		echo json_encode(array('success' => false, 'msg' => 'Invalid Engineer Id or Spare not Found.'));
		exit;
	}

public function spare_parts_master_items_list(Request $request){
        $spareCategory = \DB::table('spare_category')
        ->where('name', 'like', '%' . $request->category . '%')
        ->first();

$spareUom = \DB::table('spart_value_type')
        ->where('UOM', 'like', '%' . $request->uom . '%')
        ->first();
            $spare_parts_master = new \App\SparePartsMaster();
            $spare_parts_master->code = $request->code;
            $spare_parts_master->name = $request->make;
            $spare_parts_master->category = $spareCategory->id;
            $spare_parts_master->description = $request->description;
            $spare_parts_master->specification = $request->specification;
            $spare_parts_master->model = $request->model;
            $spare_parts_master->uom = $spareUom->id;
            $spare_parts_master->hsn = $request->hsn_code;
            $spare_parts_master->rate = $request->rate;
            $spare_parts_master->gst_slab_rates = $request->gst;
            $spare_parts_master->type = $request->product_types;
            $spare_parts_master->product_type = $request->types;
            // $spare_parts_master->type = $request->types;
            if($spare_parts_master->save()){
                $response['flag']=true;
                $response['status']= 200;
                $response['message'] = "Item Added Successfully";
            }else{
                $response['flag']=false;
            }
            return response()->json($response);
    
        }

public function update_spare_parts_master_items_list(Request $request){
            //   dd($request);
            
            $response = []; // Initialize the response array
         $updateCategory = \DB::table('spare_category')
        ->where('name', 'like', '%' . $request->category . '%')
        ->first();
        $spareUom = \DB::table('spart_value_type')
        ->where('UOM', 'like', '%' . $request->uom . '%')
        ->first();
            $spare = \App\SparePartsMaster::where('code', $request->code)->first();
            $spare->code = $request->code;
            $spare->name = $request->make;
            $spare->rate = $request->rate;
            $spare->gst_slab_rates = $request->gst;
            $spare->hsn = $request->hsn_code;
            $spare->uom = $spareUom->id;
            $spare->model = $request->model;
            $spare->category = $updateCategory->id;
            $spare->description = $request->description;
            $spare->specification = $request->specification;
            $spare->type = $request->product_type;
            $spare->product_type = $request->types;
    
             if($spare->save()){
                $response['flag']=true;
                $response['status']= 200;
                $response['message'] = "Item Updated Successfully";
            }else{
                $response['flag']=false;
            }
            return response()->json($response);
        }

}