/**
* 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);
}
