/**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $user = new Employee();
     $user->name = 'Administrator';
     $user->email = '[email protected]';
     $user->password = bcrypt('marktimbol');
     $user->save();
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  Request  $request
  * @return Response
  */
 public function store(Request $request)
 {
     $this->validate($request, ['first_name' => 'required|max:100', 'middle_name' => 'required|max:100', 'last_name' => 'required|max:100', 'emp_id' => 'required|max:100', 'card_no' => 'required|max:100']);
     $employee = new Employee();
     $employee->first_name = $request->first_name;
     $employee->middle_name = $request->middle_name;
     $employee->last_name = $request->last_name;
     $employee->emp_id = $request->emp_id;
     $employee->card_no = $request->card_no;
     $employee->active = 1;
     $employee->save();
     Session::flash('flash_message', 'Terminal successfully added!');
     return redirect()->route("employee.index");
 }

 public function create()
 {
     $input = Input::all();
     $customers = Customer::all();
     $salesmen = Employee::all();
     return view('return.create', compact('input', 'customers', 'salesmen'));
 }

 /**
  * Remove the specified resource from storage.
  *
  * @param  int $id
  * @return \Illuminate\Http\Response
  */
 public function destroy($id)
 {
     $employee = Employee::findOrFail($id);
     $name = $employee->name . " " . $employee->lastname;
     Employee::destroy($id);
     return redirect(route('employees.index'))->with('message', 'Empleado ' . $name . ' eliminado corectamente');
 }

 public function achievement()
 {
     $AMIds = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
     $MRs = Employee::whereIn('manager_id', $AMIds)->get();
     $dataView = ['MRs' => $MRs];
     return view('sm.line.history.search', $dataView);
 }

 public function __construct()
 {
     $count = Employee::count();
     $countProj = Project::count();
     $data = Employee::all();
     $YourRole = "";
     if (count(Auth::user()) > 0) {
         $YourRole = Auth::user()->UserRoles->role;
     }
     $Role2 = $this->Role1;
     // Count Unconfirmed
     $cc = 0;
     foreach ($data as $da) {
         if ($da->confirm == 0) {
             $cc++;
         }
     }
     $countConf = $cc;
     // Count Confirmed
     $cc1 = 0;
     foreach ($data as $dat) {
         if ($dat->confirm == 1) {
             $cc1++;
         }
     }
     $countConfirmed = $cc1;
     View::share('countConf', $countConf);
     View::share('YourRole', $YourRole);
     View::share('countConfirmed', $countConfirmed);
     View::share('count', $count);
     View::share('countProj', $countProj);
 }

 public function search()
 {
     $AMs = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
     $MRs = Employee::whereIn('manager_id', $AMs)->get();
     $dataView = ['MRs' => $MRs];
     return view('sm.search.plans.search', $dataView);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     $suppliers = Supplier::orderBy('name')->get();
     $employees = Employee::orderBy('firstname')->get();
     $customers = Customer::orderBy('name')->get();
     return view('inventory.home', compact(['suppliers', 'employees', 'customers']));
 }

 /**
  * Store a newly created resource in storage.
  *
  * @param  \Illuminate\Http\Request  $request
  * @return \Illuminate\Http\Response
  */
 public function store(Request $request)
 {
     //
     $transaction = $request->all();
     $empId = $transaction["empId"]['id'];
     $siteId = $transaction["siteId"]['id'];
     $workDate = $transaction["workDate"];
     $day = (double) $transaction["day"];
     $ot = (double) $transaction["ot"];
     $advance = (double) $transaction["advance"];
     //$wage = DB::select(DB::raw("select employee.wage from employee where employee.id=$empId "));
     $wage = Employee::where('id', $empId)->first()->wage;
     //dd($wage);
     $amount = (double) (($day + $ot / 8.0) * $wage);
     $transact = SiteEmployeeRel::create(['siteId' => $siteId, 'empId' => $empId, 'workDate' => $workDate, 'day' => $day, 'ot' => $ot, 'advance' => $advance, 'amount' => $amount, 'advance' => $advance]);
     //return $transact;
     //getting current date
     $currentDate = Carbon::now();
     //getting current year
     $currentYear = $currentDate->year;
     //getting current month
     $currentMonth = $currentDate->month;
     //getting the employee transaction according to current month and year
     $transactions = DB::select(DB::raw("select e.name as empName,e.wage, s.name as siteName, t.workDate, t.day ,t.ot,t.advance,t.amount from siteemployeerel as t\n                        inner join employee as e on t.empId = e.id\n                        inner join site as s on t.siteId = s.id\n                        where year(t.workDate) = {$currentYear} and month(t.workDate) = {$currentMonth}\n                        order by t.created_at;"));
     return json_encode(array('transactions' => $transactions));
 }

 public function testCanRemoveScope()
 {
     factory(User::class)->create(['type' => null]);
     factory(User::class)->create(['type' => Employee::class]);
     $users = Employee::withoutGlobalScope(\App\SingleTableInheritanceScope::class)->get();
     $this->assertCount(2, $users);
 }

 public function edit($salarySheetId, $salarySheetRecordId)
 {
     $salary_sheet = SalarySheet::find($salarySheetId);
     $employees = Employee::lists('name', 'id')->sort();
     $salary_sheet_record = SalarySheetRecord::find($salarySheetRecordId);
     return view('hr.salary_sheet.edit', compact('salary_sheet', 'employees', 'salary_sheet_record'));
 }

 public function update($id)
 {
     $task = Task::findOrFail($id);
     $employees = Employee::where('level_id', '<>', 1)->get();
     $dataView = ['task' => $task, 'employees' => $employees];
     return view('admin.task.edit', $dataView);
 }

 /**
  * Run the database seeds.
  *
  * @return void
  */
 public function run()
 {
     $employee_ids = Employee::all()->lists('id')->toArray();
     $order_states = OrderState::lists('id')->toArray();
     $products = Product::all();
     $municipalities = Municipality::all();
     factory(App\Customer::class, 50)->create()->each(function ($customer) use($employee_ids, $products, $municipalities, $order_states) {
         shuffle($employee_ids);
         shuffle($order_states);
         $customer->user()->save(factory(User::class, 'customer')->create());
         $customer->city_id = $municipalities->shuffle()->first()->id;
         $customer->save();
         $customer->products()->attach($products->shuffle()->first(), ['vote' => rand(1, 5), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]);
         $customer->orders()->save(factory(App\Order::class)->create(['acquired_by' => $employee_ids[0], 'state_id' => $order_states[0]]));
     });
     $user = new User();
     $user->name = 'Vid';
     $user->surname = 'Mahovic';
     $user->email = '[email protected]';
     $user->password = 'vid123';
     $user->verified = true;
     $user->save();
     $customer = new Customer();
     $customer->street = 'Celovška 21';
     $customer->city_id = $municipalities->shuffle()->first()->id;
     $customer->phone = '+38640850993';
     $customer->save();
     $customer->user()->save($user);
 }

 public function listAll()
 {
     $employees = Employee::select('id')->where('manager_id', \Auth::user()->id)->get();
     $customers = Customer::whereIn('mr_id', $employees)->get();
     $dataView = ['customers' => $customers];
     return view('am.customer.list', $dataView);
 }

 /**
  * Bind data to the view.
  *
  * @param  View  $view
  * @return void
  */
 public function compose(View $view)
 {
     $view->with('disposition_check', ['use as is', 'ncmr#', 'rework', 'split lot', 'shutdown', 'shipback']);
     $view->with('cod_check', ['production', 'process', 'maintenance', 'facilities', 'quality assurance', 'others']);
     $view->with('approvers', ['production', 'process', 'quality assurance', 'others']);
     $view->with('names', Employee::select('name')->orderBy('name')->where('name', '<>', Auth::User()->employee->name)->get());
 }

 public function update($id)
 {
     $customer = Customer::findOrFail($id);
     $mrs = Employee::where('level_id', 7)->active()->get();
     $dataView = ['customer' => $customer, 'mrs' => $mrs];
     return view('admin.customer.edit', $dataView);
 }

 /**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function getIndex()
 {
     $employee = Employee::all();
     $categories = Event::all();
     $userdetails = User::all();
     $targets = Targetassign::all();
     $deals = Deal::all();
     $userData = array();
     $key = 0;
     foreach ($targets as $target) {
         $achieved = 0;
         $userData[$key]['eventcode'] = $target->Eventcode;
         $userData[$key]['event'] = $target->Eventname;
         $userData[$key]['employee'] = $target->Employeeid;
         $userData[$key]['targetVal'] = $target->Targetvalue;
         foreach ($deals as $deal) {
             if ($target->Eventcode == $deal->Eventcode && $target->Employeeid == $deal->Empid) {
                 $achieved = $achieved + $deal->Dealvalue;
             }
         }
         $userData[$key]['achieved'] = $achieved;
         $userData[$key]['variance'] = $achieved - $target->Targetvalue;
         $userData[$key]['cur'] = $target->Currency;
         $key++;
     }
     return View('targetmodule/assigntarget')->with(array('categories' => $categories, 'employee' => $employee, 'userdata' => $userData, 'targets' => $targets, 'eventtable' => $categories));
 }

 public function search()
 {
     $products = Product::where('line_id', Employee::find(\Auth::user()->id)->line_id)->get();
     $doctors = Customer::where('mr_id', \Auth::user()->id)->get();
     $dataView = ['products' => $products, 'doctors' => $doctors];
     return view('mr.search.sales.search', $dataView);
 }

 /**
  * Bind data to the view.
  *
  * @param  View  $view
  * @return void
  */
 public function compose(View $view)
 {
     $view->with('select_failure_mode', ['Assembly', 'Environment', 'Machine', 'Man', 'Material', 'Method / Process']);
     $view->with('customers', Option::orderBy('customer')->select('customer')->get());
     $view->with('machines', Machine::orderBy('name')->select('name')->get());
     $view->with('stations', Station::select('station')->get());
     $view->with('employees', Employee::orderBy('name')->select('name')->where('name', '<>', Auth::user()->employee->name)->get());
 }

 public function getIndex()
 {
     $categories = Event::all();
     $employee = Employee::all();
     $invoice = Invoice::all();
     $invnull = Invoice::where('Status', '=', 'Null')->get();
     return View('home2')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice, 'invnull' => $invnull));
 }