000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class UserController extends Controller
{
	public function users(){
		$data = array();
		$data['users'] = \App\User::where('is_active',1)->where('id','<>',\Auth::user()->id)->with('role')->get();
		return view('dashboard.user.index',$data);
	} 
	public function getAddUser(){
		$data['roles'] = \App\Role::where('is_active',1)->get();
		return view('dashboard.user.create',$data);
	}

public function postAddUser(Request $request){
		$response = array();
		$validator = \Validator::make($request->all(),
			array(
				'role' =>'required',
				'name' =>'required',
				'email' =>'required|email|unique:users,email',
				'password' =>'required',
			
			)
		);

if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
			$user =  new \App\User();
			$user->role_id = $request->role;
			$user->name = $request->name;
			$user->email = $request->email;
			$user->password = \Hash::make($request->password);
			$user->plain_password = $request->password;
			if($user->save()){
				$response['flag'] = true;
				$response['user'] = $user;
				$response['message'] = "User Created Successfully";
			}else{
				$response['flag'] = false;
				$response['error'] = "Something Went Wrong";
			}
		}
		return response()->json($response);
	}
	
	public function getEditUser($id){
		$user = \App\User::where('id',$id)->where('is_active',1)->first();
		if(is_null($user)){
			return redirect('user/users')->with('error','User not found');
		}else{
			$data['user'] = $user;
			$data['roles'] = \App\Role::where('is_active',1)->get();
			return view('dashboard.user.edit',$data);
		}
	}

public function postEditUser(Request $request){
		$response = array();
		$validator = \Validator::make($request->all(),
			array(
				'role' =>'required',
				'name' =>'required',
				'email' =>'required|email|unique:users,email,'.$request->id,
				'password' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
			$user =  \App\User::where('id',$request->id)->where('is_active',1)->first();
			if(is_null($user)){
				$response['flag'] = false;
				$response['error'] = "User Not found";
			}else{
				$user->role_id = $request->role;
				$user->name = $request->name;
				$user->email = $request->email;
				$user->password = \Hash::make($request->password);
				$user->plain_password = $request->password;
				if($user->save()){
					$response['flag'] = true;
					$response['message'] = "User Updated Successfully";
				}else{
					$response['flag'] = false;
					$response['error'] = "Something Went Wrong";
				}
			}
		}
		return response()->json($response);
	}

public function retailers(){
		$data = array();
		$data['retailers'] = \App\Retailer::where('is_active',1)->get();
		$data['groups'] = \App\Group::where('is_active',1)->get();
		$data['routes'] = \App\Route::where('is_active',1)->get();
		$data['marketing_managers'] = \App\User::where([['is_active','=','1'],['role_id','=','6']])->get();
		return view('dashboard.master.retailers',$data);
	}

public function addRetailers(Request $request){
		$response = array();		
		$validator = \Validator::make($request->all(),
			array(
				// 'name' =>'required|unique:dealers,name',
				'name' =>'required',
				'gst_number' =>'required',
				'pincode' =>'required',
				'address' =>'required',
				'mobile_number' =>'required|regex:/^[6-9][0-9]{9}$/',
				'lat' =>'required',
				'long' =>'required',
				//'group' =>'required',
				
			)
		);

if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
			//dd($request->all());
			$retailer =  new \App\Retailer();
			$retailer->name = $request->name;
			$retailer->mfms_id = $request->mfms_id;
			if($request->hindi_name){
				$retailer->hindi_name = $request->hindi_name;
			}
			else{
				$retailer->hindi_name = $request->name;
			}
			$retailer->address = $request->address;
			$retailer->pincode = $request->pincode;
			if($request->hindi_address){
				$retailer->hindi_address = $request->hindi_address;
			}
			else{
				$retailer->hindi_address = $request->name;
			}
			$retailer->mobile_number = $request->mobile_number;
			$retailer->gst_number = $request->gst_number;
			$location = array();
			array_push($location, $request->lat);
			array_push($location, $request->long);			
			$retailer->location = json_encode($location,true);
			if($request->group != ""){							
				$retailer->group_id = $request->group;
			}else{
				$retailer->group_id = $request->group;
			}
			$retailer->marketing_manager_id = $request->marketing_manager;
			if($request->route != "") {
				$retailer->route_id = $request->route;
			}else{
				$retailer->route_id = $request->route;
			}
			if($retailer->save()){
				$response['flag'] = true;
				$response['message'] = "Retailer Added Successfully";
			}else{
				$response['flag'] = false;
				$response['error'] = "Something Went Wrong";
			}
		}
		return response()->json($response);
	}

public function getEditRetailer($id){
		$data = array();
		$data['retailer'] = \App\Retailer::where('id',$id)->where('is_active',1)->first();
		$data['groups'] = \App\Group::where('is_active', 1)->get();
		$data['marketing_managers'] = \App\User::where([['is_active','=','1'],['role_id','=','6']])->get();
		$data['routes'] = \App\Route::where('is_active',1)->get();
		return view('dashboard.master.edit-retailer',$data);
	}

public function updateRetailer(Request $request){
		$response = array();
		$validator = \Validator::make($request->all(),
			array(
				'name' =>'required',
				'gst_number' =>'required',
				'pincode' =>'required',
				'address' =>'required',
				'mobile_number' =>'required|regex:/^[6-9][0-9]{9}$/',
				'lat' =>'required',
				'long' =>'required',
				//'group' =>'required',
			)
		);
		if($validator->fails())
		{
			$response['flag'] = false;
			$response['errors'] = $validator->getMessageBag();
		}else{
			$retailer =  \App\Retailer::where('id',$request->id)->where('is_active',1)->first();
			if(is_null($retailer)){
				$response['flag'] = false;
				$response['error'] = "Retailer Not found";
			}else{
				$retailer->name = $request->name;
				$retailer->mfms_id = $request->mfms_id;
				$retailer->hindi_name = $request->hindi_name;
				$retailer->address = $request->address;
				$retailer->pincode = $request->pincode;
				$retailer->limit = $request->limit;
				
				if($request->hindi_address){
					$retailer->hindi_address = $request->hindi_address;
				}
				else{
					$retailer->hindi_address = $request->name;
				}
				$retailer->mobile_number = $request->mobile_number;
				$retailer->gst_number = $request->gst_number;
				$location = array();
				array_push($location, $request->lat);
				array_push($location, $request->long);				
				$retailer->location = json_encode($location,true);
				if($request->group != ""){							
					$retailer->group_id = $request->group;
				}else{
					$retailer->group_id = $request->group;
				}
				$retailer->marketing_manager_id = $request->marketing_manager;
				if($request->route != "") {
					$retailer->route_id = $request->route;
				}else{
					$retailer->route_id = $request->route;
				}
			
				if($retailer->save()){
					$response['flag'] = true;
					$response['message'] = "Retailer Updated Successfully";
					$response['response'] = $request->all();
				}else{
					$response['flag'] = false;
					$response['error'] = "Something Went Wrong";
				}
			}
		}
		return response()->json($response);
	}

public function deleteRetailer($id){
		$response = array();
		$retailer = \App\Retailer::where('id',$id)->where('is_active',1)->first();
		if(is_null($retailer)){
			$response['flag'] = false;
			$response['message'] = "retailer Not Found";
		}else{
			$retailer->is_active = 0;
			if($retailer->save()){
				$response['flag'] = true;
				$response['message'] = "Retailer Deleted";
			}else{
				$response['flag'] = false;
				$response['message'] = "Failed to delete";
			}
		}
		return response()->json($response);
	}

public function exportRetailer(Request $request){
		$retailerExcel = \App\Retailer::select('*')->where('is_active',1)->get();
		\Excel::create('Retailer Lists', function($excel) use($retailerExcel) {
			$excel->sheet('Retailers', function($sheet) use($retailerExcel) {
				$sheet->fromArray($retailerExcel);
			});
		})->export('xls');
	}
	public function importRetailer(Request $request){
		if($request->hasFile('retailer_file'))
		{
			$extension = \File::extension($request->file('retailer_file')->getClientOriginalName());
			if ($extension == "xlsx" || $extension == "xls" || $extension == "csv") {
				\Excel::load($request->file('retailer_file'), function($reader) {
					foreach ($reader->toArray() as $sheets) {
						
						if(count($sheets) > 0){
							foreach ($sheets as $key => $sheet) {
								// echo "<pre>";
								// print_r($sheet['id']);
								// exit;
								$retailer = \App\Retailer::where('id',(int)$sheet['id'])->first();
								if(is_null($retailer)){
									$retailer = new \App\Retailer();				
									$retailer->name = addslashes($sheet['name']);
									$retailer->hindi_name = $sheet['hindi_name'];
									$retailer->address = $sheet['address'];
									$retailer->pincode = $sheet['pincode'];
									$retailer->hindi_address = $sheet['hindi_address'];
									$retailer->mobile_number = $sheet['mobile_number'];
									$retailer->gst_number = $sheet['gst_number'];

}else{
									$retailer->name = addslashes($sheet['name']);
									$retailer->hindi_name = $sheet['hindi_name'];
									$retailer->address = $sheet['address'];
									$retailer->pincode = $sheet['pincode'];
									$retailer->hindi_address = $sheet['hindi_address'];
									$retailer->mobile_number = $sheet['mobile_number'];
									$retailer->gst_number = $sheet['gst_number'];
								}

// $retailer->save();
							}
						}
					}
					exit;
				});
				return redirect('user/retailers')->with('save','Imported Successfully');
			}else{
				return redirect('user/retailers')->with('error','Invalid File type');
			}
		}else{
			return redirect('user/retailers')->with('error','File Required');
		}
	}

}