/** * 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 update($id) { $task = Task::findOrFail($id); $employees = Employee::where('level_id', '<>', 1)->get(); $dataView = ['task' => $task, 'employees' => $employees]; return view('admin.task.edit', $dataView); }
/** * Display a list of employee * @return \Illuminate\View\View */ public function index() { $title = 'EMPLOYEE'; if (Input::has('eid')) { $id = Input::get('eid'); $employees = Employee::where('eid', $id)->paginate(5); } elseif (Input::has('name')) { $name = Input::get('name'); $employees = Employee::where('name', 'like', '%' . $name . '%')->paginate(5); } elseif (Input::has('license')) { $license = Input::get('license'); $employees = Employee::where('license', 'like', '%' . $license . '%')->paginate(5); } elseif (Input::has('visa')) { $visa = Input::get('visa'); $employees = Employee::where('visa', 'like', '%' . $visa . '%')->paginate(5); } elseif (Input::has('per_country')) { $country = Input::get('per_country'); $employees = Employee::where('per_country', $country)->paginate(5); } else { $employees = Employee::paginate(10); } $repository = $this->repository; //dd($employees); return view('employee.index', compact('title', 'employees', 'repository')); }
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); }
public function index() { $title = 'HOME'; $repository = $this->repository; $employees = Employee::where('license_expire', '<', Carbon::now()->addDays(30))->orWhere('visa_expire', '<', Carbon::now()->addDays(30))->get(); $vehicles = Vehicles::where('registration_expire', '<', Carbon::now()->addDays(30))->get(); return view('pages.home', compact('title', 'employees', 'vehicles', 'repository')); }
public function listAll() { $AMsIds = Employee::select('id')->where('manager_id', \Auth::user()->id)->get(); $MRs = Employee::whereIn('manager_id', $AMsIds)->get(); $AMs = Employee::where('manager_id', \Auth::user()->id)->get(); $dataView = ['MRs' => $MRs, 'AMs' => $AMs]; return view('sm.employee.list', $dataView); }
public function search() { $MRs = Employee::where('level_id', 7)->active()->get(); $AMs = Employee::where('level_id', 3)->active()->get(); $SMs = Employee::where('level_id', 2)->active()->get(); $dataView = ['MRs' => $MRs, 'AMs' => $AMs, 'SMs' => $SMs]; return view('admin.search.plans.search', $dataView); }
public function update($id) { $area = Area::findOrFail($id); $AMs = Employee::where('level_id', 3)->active()->get(); $lines = Line::all(); $dataView = ['area' => $area, 'AMs' => $AMs, 'lines' => $lines]; return view('admin.area.edit', $dataView); }
public function search() { $employeesLines = Employee::select('line_id')->where('manager_id', \Auth::user()->id)->get(); $products = Product::where('line_id', $employeesLines)->get(); $MRs = Employee::where('manager_id', \Auth::user()->id)->get(); $dataView = ['products' => $products, 'MRs' => $MRs]; return view('am.search.sales.search', $dataView); }
public function search() { $classes = VisitClass::all(); $specialties = Customer::select('specialty')->distinct()->get(); $MRs = Employee::where('level_id', 7)->get(); $dataView = ['classes' => $classes, 'specialties' => $specialties, 'MRs' => $MRs]; return view('admin.search.coverage.search', $dataView); }
public function update($id) { $territory = Territory::findOrFail($id); $areas = Area::all(); $MRs = Employee::where('level_id', 7)->active()->get(); $dataView = ['territory' => $territory, 'areas' => $areas, 'MRs' => $MRs]; return view('admin.territory.edit', $dataView); }
public function search() { $classes = VisitClass::all(); $employees = Employee::select('id')->where('manager_id', \Auth::user()->id)->get(); $specialties = Customer::select('specialty')->whereIn('mr_id', $employees)->distinct()->get(); $MRs = Employee::where('manager_id', \Auth::user()->id)->get(); $dataView = ['classes' => $classes, 'specialties' => $specialties, 'MRs' => $MRs]; return view('am.search.coverage.search', $dataView); }
public function update($id) { $lines = Line::all(); $levels = Level::all(); $employee = Employee::findOrFail($id); $salesManagers = Employee::where('level_id', 2)->get(); $areaManagers = Employee::where('level_id', 3)->get(); $dataView = ['lines' => $lines, 'levels' => $levels, 'employee' => $employee, 'salesManagers' => $salesManagers, 'areaManagers' => $areaManagers]; return view('admin.employee.edit', $dataView); }
public function postUpdateadmin(Request $request) { $emp_id_d = Input::get('emp_id_d'); $post = Input::get(); $i = Employee::where('emp_id', $emp_id_d)->update(array('emp_name' => $post['emp_name'], 'emp_ide_id' => $post['emp_id'], 'emp_status' => $post['emp_status'], 'emp_department' => $post['emp_dept'])); if ($i > 0) { $request->session()->flash('alert-success', 'Updated Success!'); return redirect('targetmodule/admin'); } }
public function index() { $employees = Employee::select('line_id')->where('manager_id', \Auth::user()->id)->get(); $products = Product::whereIn('line_id', $employees)->get(); $employees = Employee::select('id')->where('manager_id', \Auth::user()->id)->get(); $customers = Customer::whereIn('mr_id', $employees)->get(); $employees = Employee::where('manager_id', \Auth::user()->id)->get(); $dataView = ['productsCount' => count($products), 'plansCount' => AMPlan::where('month', \Config::get('app.current_month'))->count(), 'reportsCount' => AMReport::where('month', \Config::get('app.current_month'))->count(), 'customersCount' => count($customers), 'employeesCount' => count($employees)]; return view('am.index', $dataView); }
public function search() { $products = Product::all(); $doctors = Customer::all(); $MRs = Employee::where('level_id', 7)->get(); $AMs = Employee::where('level_id', 3)->get(); $SMs = Employee::where('level_id', 2)->get(); $dataView = ['products' => $products, 'doctors' => $doctors, 'MRs' => $MRs, 'AMs' => $AMs, 'SMs' => $SMs]; return view('admin.search.sales.search', $dataView); }
public function getHome() { $varr = Auth::user()->empid; $evarr = User::where('empid', $varr)->get(); $edetails = Employee::where('emp_ide_id', $varr)->get(); $categories = Event::all(); $employee = Employee::all(); $invoice = Invoice::all(); $invnull = Invoice::where('Status', '=', 'Null')->get(); return View('reviewer/home')->with(array('categories' => $categories, 'employee' => $employee, 'invoice' => $invoice, 'invnull' => $invnull, 'edetails' => $edetails)); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(CreateUserRequest $request, $idno) { $employee = Employee::where('idno', $idno)->firstOrFail(); $find_user = User::where('username', $idno)->first(); if (count($find_user) == 0) { $user = new User(array('fullName' => $employee->firstName . $employee->lastName, 'position' => $request->get('position'), 'username' => $employee->idno, 'password' => bcrypt($request->get('password')), 'status' => $request->get('status'), 'col_id' => $employee->col_id, 'emp_id' => $employee->idno)); $user->save(); return redirect('/admin/users/' . $idno)->with('status', '1'); } else { return redirect('/admin/users/' . $idno)->with('status', '0'); } }
public static function search($query) { if (empty($query)) { return Collection::make(); } return Employee::where('first_name', 'like', '%' . $query . '%')->orWhere('last_name', 'like', '%' . $query . '%')->orderBy('first_name', 'asc')->orderBy('last_name', 'asc')->take(5)->get(array('id', 'first_name', 'last_name'))->map(function ($employee) { $employee->label = $employee->first_name . ' ' . $employee->last_name; $employee->type = 'employee'; $employee->url = route('employees.show', $employee->id); return $employee; }); }
public function store(Request $request) { // dd($request->all()); $password = $request->input('password'); $card = $request->input('card') == "" ? 0 : $request->input('card'); $name = $request->input('name'); $all_users = Employee::where('device_id', $this->connected_device['device_id'])->orderBy('pin')->get(); $next_pin = $this->unused_id($all_users); // send the employee to device and store it $this->tad->set_user_info(["pin" => $next_pin, "password" => $password, 'card' => $card, 'name' => $name, "group" => "1"]); // store the employee to DB $employee = Employee::create(['pin' => $next_pin, 'name' => $name, 'device_id' => $this->connected_device['device_id'], 'password' => $password, 'card' => $card]); $employee->save(); return redirect()->action('EmployeesController@index'); }
/** * Execute the console command. * * @return mixed */ public function handle() { echo "Started..."; $employees = Employee::where('category_id', 2)->get(); $rules = ['employee_id' => 'required|unique_with:invoices,months']; foreach ($employees as $employee) { $data['employee_id'] = $employee->id; $data['company_id'] = $employee->company_id; $data['months'] = Carbon::now()->firstOfMonth(); $data['fee'] = 0; $data['employee_number'] = $employee->number; $validator = \Validator::make($data, $rules); if ($validator->fails()) { } else { //MobileFees::create($data); Invoice::create($data); } } }
public function __construct() { $count = Employee::count(); $countProj = Project::count(); $data = Employee::all(); $DataEm = ""; $YourRole = ""; $undisplayRoleAcc = ""; if (count(Auth::user()) > 0) { $YourRole = Auth::user()->UserRoles->role; if (Auth::user()->id_employees > 0) { $DataEm = Employee::where('id', Auth::user()->id_employees)->get(); } } if ($YourRole == 11) { $undisplayRoleAcc = "undisplayRole"; } $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('DataEm', $DataEm); View::share('undisplayRoleAcc', $undisplayRoleAcc); View::share('YourRole', $YourRole); View::share('countConfirmed', $countConfirmed); View::share('count', $count); View::share('countProj', $countProj); }
/** * Run the database seeds. * * @return void */ public function run() { DB::table('infos')->delete(); $faker = \Faker\Factory::create(); foreach (range(1, 20) as $index) { $employee = Employee::all(); $originator = $employee->random(); $close_by = Employee::where('station', 'quality assurance')->first(); $issuedTo = $employee->random(); $major = 'major'; $year = Carbon::now('Asia/Manila')->format('y'); $info = Info::create(['control_id' => $year . "-" . sprintf("%'.04d", $index), 'customer' => $faker->randomElement(array_flatten(Option::all('customer')->toArray())), 'package_type' => $faker->firstNameFemale, 'device_name' => $faker->address, 'lot_id_number' => $faker->randomDigit, 'lot_quantity' => $faker->randomNumber(4), 'job_order_number' => $faker->randomElement(['0', '1', '2']), 'machine' => $faker->randomElement(['at01', 'at02', 'at03', 'at04', 'at05']), 'station' => $faker->randomElement(['pl1', 'pl2', 'pl3', 'pl4', 'pl5']), 'created_at' => $faker->dateTimeThisMonth, 'major' => $major, 'disposition' => $faker->randomElement(['use as is', 'ncmr#', 'rework', 'split lot', 'shutdown', 'shipback']), 'problem_description' => $faker->paragraph(2), 'failure_mode' => $faker->randomelement(['assembly', 'environment', 'machine', 'man', 'material', 'method / process']), 'discrepancy_category' => $faker->randomelement(['MISSING UNIT(S)', 'LOW YIELD', 'WRONG TRANSACTION', 'CANT CREATE', 'FOREIGN MATERIAL', 'WRONG MERGING', 'DATECODE DISCREPANCY', 'MARKING PROBLEM', 'MIXED DEVICE', 'BENT LEAD', 'LEAD CONTAMINATION', 'LEAD DISCOLORATION', 'LEAD COPLANARITY']), 'quantity' => $faker->randomNumber(4)]); CauseOfDefect::create(['info_id' => $info->id, 'cause_of_defect' => $faker->randomElement(['PRODUCTION', 'PROCESS', 'MAINTENANCE', 'FACILITIES', 'QUALITY ASSURANCE', 'OTHERS']), 'cause_of_defect_description' => $faker->paragraph(2), 'objective_evidence' => 'N/A']); ContainmentAction::create(['info_id' => $info->id, 'what' => $faker->paragraph(2), 'who' => $faker->name('male' | 'female'), 'objective_evidence' => 'N/A', 'created_at' => $info->created_at]); CorrectiveAction::create(['info_id' => $info->id, 'what' => $faker->paragraph(2), 'who' => $faker->name('male' | 'female'), 'objective_evidence' => 'N/A', 'created_at' => $info->created_at]); PreventiveAction::create(['info_id' => $info->id, 'what' => $faker->paragraph(2), 'who' => $faker->name('male' | 'female'), 'objective_evidence' => 'N/A', 'created_at' => $info->created_at]); QdnCycle::create(['info_id' => $info->id, 'cycle_time' => '24', 'production_cycle_time' => '24', 'process_engineering_cycle_time' => '24', 'quality_assurance_cycle_time' => '24', 'other_department_cycle_time' => '24', 'created_at' => $info->created_at]); InvolvePerson::create(['info_id' => $info->id, 'station' => $originator->station, 'originator_id' => $originator->user_id, 'originator_name' => $originator->name, 'receiver_id' => $issuedTo->user_id, 'receiver_name' => $issuedTo->name, 'created_at' => $info->created_at]); Closure::create(['info_id' => $info->id, 'containment_action_taken' => $faker->randomElement(['yes', 'no']), 'corrective_action_taken' => $faker->randomElement(['yes', 'no']), 'close_by' => $close_by->name, 'date_sign' => Carbon::parse($info->created_at)->addDay(), 'production' => $employee->where('department', 'production')->random()->name, 'process_engineering' => $employee->where('department', 'process_engineering')->random()->name, 'quality_assurance' => $employee->where('department', 'quality_assurance')->random()->name, 'other_department' => $employee->where('department', 'other_department')->random()->name, 'status' => 'Closed', 'created_at' => $info->created_at]); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $token = $request->t; $sensortype = $request->s; $card_no = $request->c; $status = 0; // check if valid terminal $terminal = Terminal::where('token', $token)->where('active', 1)->first(); if (!empty($terminal)) { $employee = Employee::where('card_no', $card_no)->where('active', 1)->first(); if (!empty($employee)) { $timelog = new EmployeeTime(); $timelog->employee_id = $employee->id; $timelog->terminal_id = $terminal->id; $timelog->timestamp = Carbon::now(); $timelog->sensortype_id = $sensortype; $timelog->save(); $status = 1; } } return response()->json(['status' => $status], 200); }
public function postRegister(Request $request) { $validator = $this->validator($request->all()); if ($validator->fails()) { $this->throwValidationException($request, $validator); } $employee = $request->employee_id; if (Employee::where('employee_id', '=', $employee)->exists()) { $this->auth->login($this->create($request->all())); $data = array('name' => $request->name, 'email' => $request->email); $mailto = $request->email; Mail::queue('emails.register', $data, function ($message) use($mailto) { $message->from('*****@*****.**', 'Acknotech'); $message->to($mailto); $message->subject('Registration Completed'); }); return redirect($this->redirectPath()); } else { return redirect('auth/register')->with('error', 'You are not an employee at Acknotech.. Submit your resume if you want to be a part of our team'); } }
public function index($id) { $user = \Auth::user(); //get all qualities $qualities = Qualities::all(); //get all review types $reviews = Review_type::all(); $employee_data = Employee::where('id', '=', $id)->with('company', 'residence', 'phone', 'qualities', 'language')->with(['notes' => function ($query) { $query->where('section_type', '=', 'employee')->with('user'); }])->with(['dates' => function ($query) { $query->whereRaw('(? BETWEEN dates.start AND dates.end OR dates.start>?) AND dates.type IN("day_off", "annual_leave")', array(mktime(0, 0, 0, date('n', time()), date('j', time()), date('Y', time())), mktime(0, 0, 0, date('n', time()), date('j', time()), date('Y', time())))); }])->first(); //dd($employee_data); $employee_rating = DB::select('select FORMAT(AVG(stars), 4) AS average, FROM_UNIXTIME(`date`, \'%M %Y\') AS month_date, FROM_UNIXTIME(`date`, \'%Y %m\') AS month_order from employee_rating where employees_id = ? GROUP BY month_order', [$id]); //dd($employee_rating); foreach ($employee_rating as $rating) { $labels[] = $rating->month_date; $data[] = $rating->average; } $labels = json_encode($labels); $data = json_encode($data); return view('profile', compact('employee_data', 'user', 'qualities', 'labels', 'data', 'reviews')); }
public function postInsertvipbookingform(VipRequest $request) { //dd('dasd'); $post = Input::get(); $editleadid = Input::get('leadid'); $empid = Input::get('empid'); $fromemail = Input::get('pemail'); $email = Employee::where('emp_ide_id', $empid)->get(); foreach ($email as $backemail) { $email = $backemail->email; } // dd($editleadid); $i = vipbooking::where('id', $editleadid)->update(array('pname' => $post['pname'], 'ppassport' => $post['ppassport'], 'pnameonbadge' => $post['pnameonbadge'], 'snameonbadge' => $post['snameonbadge'], 'pemail' => $post['pemail'], 'pmobile' => $post['pmobile'], 'pdesg' => $post['pdesg'], 'sname' => $post['sname'], 'spassport' => $post['spassport'], 'semail' => $post['semail'], 'smobile' => $post['smobile'], 'agreedname' => $post['agreedname'], 'agreeddate' => $post['checkindate'], 'sdesg' => $post['sdesg'], 'status' => 'NULL')); $subject = 'Confirmation Form'; Mail::send('emails.backform', ['Backform' => 'sdsad'], function ($message) use($subject, $email, $fromemail) { // note: if you don't set this, it will use the defaults from config/mail.php $message->from($fromemail); $message->to($email)->subject($subject); }); if ($i > 0) { $request->session()->flash('alert-success', 'Updated Successfully'); return Redirect::back(); } }
protected function portalUpdateTimesheet() { $authUserId = \Auth::id(); $authEmployee = Employee::where('userId','=',$authUserId)->first(); $empId = $authEmployee->id; $timesheet = Timesheet::where('empId','=',$empId)->first(); $sun = Input::get('sunday'); $mon = Input::get('monday'); $tues = Input::get('tuesday'); $wed = Input::get('wednesday'); $thurs = Input::get('thursday'); $fri = Input::get('friday'); $sat = Input::get('saturday'); $total = $sun + $mon + $tues + $wed + $thurs + $fri + $sat; $timesheet->sunday = $sun; $timesheet->monday = $mon; $timesheet->tuesday = $tues; $timesheet->wednesday = $wed; $timesheet->thursday = $thurs; $timesheet->friday = $fri; $timesheet->saturday = $sat; $timesheet->total = $total; $timesheet->updated_at = gmdate("Y-m-d H:i:s"); $timesheet->save(); return Redirect::to('/portal-timesheet'); }
public function achievement() { $MRs = Employee::where('manager_id', \Auth::user()->id)->get(); $dataView = ['MRs' => $MRs]; return view('am.line.history.search', $dataView); }
public function create() { $employees = Employee::where('active', 1)->get(); $dataView = ['employees' => $employees]; return view('mr.inbox.new', $dataView); }