000

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use Auth;
use Hash;
use DB;
use Session;
use App\LocalUserMapping;
use App\SparePartsMaster;
use App\WareHouse;
use App\User;
class LoginController extends Controller
{
    // Get Login View

public function get_login_page(){
        if(Auth::check()){
            $user = Auth::user();
            if($user->role == 17 || $user->role == 5 || $user->role == 4){
                return redirect()->intended('admin/dashboard');
            }else if($user->role == 8){
                return redirect()->intended('circle-store/dashboard');
            }
        }else{
           return view('login'); 
        }
    	
    }

public function login_now(Request $request)
    {   
        $credentials = array(
            'loginId' => $request->loginId,
            'password' => $request->password,
            'is_active' => 1
        );

if (Auth::attempt($credentials)) {
            if (\Auth::user()->is_active == 0) {
                \Auth::logout();
                return redirect('/')->with('error', "Your Account is Deactivated. Please Contact Admin");
            } else {
                if (\Auth::user()->role == 8 || \Auth::user()->role == 22 || Auth::user()->role == 19 || \Auth::user()->role == 4 || \Auth::user()->role == 6 || \Auth::user()->role == 10 || \Auth::user()->role == 9 || \Auth::user()->role == 18 || \Auth::user()->role == 21 || \Auth::user()->role == 17 || \Auth::user()->role == 20 || \Auth::user()->role == 23) {
                    $arr1 = array();
    
                    $menus = \App\RoleModuleAssociation::with(['module' => function($query) {
                        $query->select('id', 'module', 'link', 'icon');
                    }])->select('sub_module_id', 'module_id', 'module_priority')
                        ->where('role_id', \Auth::user()->role)
                        ->orderBy('module_priority')
                        ->get()->toArray();
    
                    if (count($menus) > 0) {
                        foreach ($menus as $key => $menu) {
                            $sub_menus = \App\RoleModuleAssociation::with(['sub_module' => function($query) {
                                $query->select('id', 'sub_module', 'link');
                            }])->select('sub_module_id', 'module_id', 'sub_module_priority')
                                ->where('role_id', \Auth::user()->role)
                                ->orderBy('sub_module_priority')
                                ->where('module_id', $menu['module_id'])
                                ->get()->toArray();
    
                            $moduleIcon = \App\Module::where('id', $menu['module_id'])->value('icon');
    
                            $arr1[$menu['module']['module']] = [
                                'icon' => $moduleIcon,
                                'sub_menus' => $sub_menus
                            ];
                        }
                    }
    
                    Session::put('menus', $arr1);
                }
    
                // Now redirect to dashboard
                return redirect()->intended('admin/dashboard');
            }
        } else {
            return redirect('/')->with('error', 'Invalid Login ID or Password !!');
        }
    }

public function logout_now(){
    	Auth::logout();
    	return redirect('/')->with('success','You have successfully logged out !!');
    }

public function test_function(){
  /*

// master items CSV data uploading in master table      
$row = 1;
if (($handle = fopen("test2.csv", "r")) !== FALSE) {
  while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
    $num = count($data);
    if($row > 1){
        $is_added = SparePartsMaster::where('code',$data[1])->count();
        if($is_added == 0){
            $spare = new SparePartsMaster();
            $spare->hsn = $data[16];
            $spare->code = $data[1];
            $spare->name = $data[2];
            $spare->description = $data[2];
            $spare->uom = $data[8];
            $spare->type = $data[13];
            $spare->rate = str_replace(",","",$data[10]);
            $spare->gst_slab_rates = substr($data[15], 0, -1);
            $spare->category = $data[3];
            $spare->product_type = $data[14];
            $spare->save();
        }else{
            $spare = SparePartsMaster::where('code',$data[1])->first();
            $spare->hsn = $data[16];
            $spare->code = $data[1];
            $spare->name = $data[2];
            $spare->description = $data[2];
            $spare->uom = $data[8];
            $spare->type = $data[13];
            $spare->rate = str_replace(",","",$data[10]);
            $spare->gst_slab_rates = substr($data[15], 0, -1);
            $spare->category = $data[3];
            $spare->product_type = $data[14];
            $spare->save();
        }
    }
    $row++;
  }
  fclose($handle);
}
*/

/*user add in users table */

//$local_users = LocalUserMapping::where('role','store_assistant')->orWhere('role','store_coordinato')->get();
      /*  $local_users = LocalUserMapping::where('LoginID','ATSACE0066')->get();
        foreach ($local_users as  $value) {
            $is_added = User::where('loginId',$value->LoginID)->count();
            if($is_added == 1){
                $user = User::where('loginId',$value->LoginID)->first();
                $user->name = $value->StaffName;
               $user->loginId = $value->LoginID;
               $user->email = $value->EMail;
               
               $user->role = 2; 
               $user->staffRole = $value->StaffRole;
            }else{
               $user = new User();
               $user->name = $value->StaffName;
               $user->loginId = $value->LoginID;
               $user->email = $value->EMail;
               $user->password = Hash::make('123456');
               $user->role = 2;
               $user->staffRole = $value->StaffRole; 
            }

$user->save();

}*/

// warehouse added in ware_houses table through csv
      /*  $row = 1;
        if (($handle = fopen("warehouse.csv", "r")) !== FALSE) {
              while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                $num = count($data);
                //print_r($data);
                if($row > 1){

//  print_r($data);
                    $warehouse = new WareHouse();
                    $warehouse->label = $data[1];;
                    $warehouse->ware_house = $data[0];;
                    $warehouse->address = $data[3];;
                    $warehouse->gst_no = $data[2];;
                    $warehouse->save();
                }
$row++;
            }
        }*/

}

public function view_invoice(){

return view('invoice');

}
}