/**
* Deletes employee from database and returns status in json response
*
* @param $id
* @return array
*/
public function delete($id)
{
if ($employee = $this->employee->find($id)) {
if ($employee->delete()) {
return ['status' => 200];
}
return ['status' => 500];
}
return ['status' => 404];
}
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);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
//
$data = $request->except(['_token', '_method']);
$employee = Employee::find($id);
$employee->update($data);
return redirect()->to('employees');
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
$faker = \Faker\Factory::create();
$rows = Employee::all();
foreach ($rows as $row) {
Employee::find($row->id)->account()->where('employee_id', $row->user_id)->update(['access_level' => $faker->randomElement(['User', 'Admin']), 'status' => $faker->randomElement(['Active', 'Deactivated']), 'password' => bcrypt('8d')]);
}
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$employee = Employee::find($id);
$laptop = Employee::find($id)->laptop;
$desktop = Employee::find($id)->desktop;
$apple = Employee::find($id)->apple;
$android = Employee::find($id)->android;
return view('employees.show', compact('employee', 'laptop', 'desktop', 'apple', 'android'));
}
/**
* Saves new vacation entry to database and returns status in json response
*
* @TODO: move logic out of controller
*
* @param Request $request
* @return array
*/
public function save(Request $request)
{
$employee = $this->employee->find($request->input('employee_id'));
$vacationStart = new Carbon($request->input('start'));
$vacationEnd = new Carbon($request->input('end'));
$duration = $vacationStart->diffInDays($vacationEnd);
if ($duration > $employee->vacationsLeft || $vacationEnd <= $vacationStart) {
return ['status' => 403];
}
$overlapingVacations = $employee->vacations()->where('end', '>', $vacationStart)->where('start', '<', $vacationEnd)->get();
if (!$overlapingVacations->isEmpty()) {
return ['status' => 403];
}
$vacation = $this->vacation->create($request->all());
$vacation->duration = $duration;
if ($vacation->save()) {
return ['status' => 200];
}
return ['status' => 500];
}
/**
* Show Cv information
*
* @param int $id
* @return Response
*/
public function show($id)
{
$positions = Position::all();
$employee = Employee::find($id);
$educations = Education::where('employee_id', '=', $employee->id)->get();
$employee_skills = EmployeeSkill::where('employee_id', '=', $employee->id)->get();
$experiences = WorkingExperience::where('employee_id', '=', $employee->id)->get();
$taken_projects = TakenProject::where('employee_id', '=', $employee->id)->get();
$nationalities = Nationality::all();
$category_skill = CategorySkill::all();
return view('printpreview.printpreview', compact('taken_projects', 'position', 'employee_skills', 'nationalities', 'employee', 'educations', 'experiences', 'category_skill'));
}
public function create($doctorId = NULL)
{
$description_names = Customer::distinct()->select('description_name')->where('mr_id', \Auth::user()->id)->get();
$doctors = Customer::where('mr_id', \Auth::user()->id)->get();
$products = Product::where('line_id', Employee::find(\Auth::user()->id)->line_id)->get();
$gifts = Gift::all();
$allManagers = Employee::yourManagers(\Auth::user()->id);
$dataView = ['description_names' => $description_names, 'doctors' => $doctors, 'products' => $products, 'gifts' => $gifts, 'doctorId' => !empty($doctorId) ? $doctorId : '', 'allManagers' => $allManagers];
if (!empty($doctorId)) {
\Session::set('planned_visit', 1);
}
return view('mr.report.create', $dataView);
}
/**
* Show and Export CV information
*
* @param [int] $id
* @return Response
*/
public function show($id)
{
$positions = Position::all();
$employee = Employee::find($id);
$educations = Education::where('employee_id', '=', $employee->id)->get();
$employee_skills = EmployeeSkill::where('employee_id', '=', $employee->id)->get();
$experiences = WorkingExperience::where('employee_id', '=', $employee->id)->get();
$taken_projects = TakenProject::where('employee_id', '=', $employee->id)->get();
$nationalities = Nationality::all();
$category_skill = CategorySkill::all();
$parameterr = array();
$parameter['employee'] = $employee;
$parameter['educations'] = $educations;
$parameter['category_skill'] = $category_skill;
$parameter['employee_skills'] = $employee_skills;
$parameter['taken_projects'] = $taken_projects;
$parameter['experiences'] = $experiences;
$parameter['nationalities'] = $nationalities;
$pdf = \PDF::loadView('welcome', $parameter)->setPaper('a4')->setOrientation('landscape')->setWarnings(false);
return $pdf->download('cv.pdf');
}
public function moveEmployee(Request $request)
{
if (!$request->has('team_id') || !$request->has('origin_team_id') || !$request->has('employee_id')) {
return $this->returnJsonError('missing_params');
}
$input = $request->only('team_id', 'origin_team_id', 'employee_id');
$company_id = (int) $input['team_id'];
$employee_id = (int) $input['employee_id'];
$employee = Employee::find($employee_id);
$company = Company::find($company_id);
if ($employee && $company) {
$employee->company_id = $company_id;
$employee->save();
return $this->returnJsonSuccess();
} else {
if (!$employee) {
return $this->returnJsonError('employee.miss');
}
if (!$company) {
return $this->returnJsonError('company.miss');
}
}
}
/**
* Delete Employee from the database
*
* @param Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function deleteEmployee(Request $request)
{
$employee = Employee::find($request->input('id'));
$employee->delete();
return redirect()->route('manageEmployees')->with('flash_message', 'Employee ' . $employee->firstname . ' ' . $employee->lastname . ' has been deleted');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
//
Employee::find($id)->delete();
return redirect()->to('employee');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$employee = Employee::find($id);
$employee->delete();
return "Employee record successfully deleted #" . $id;
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update()
{
$input = Input::all();
$employee = Employee::find($input['id']);
$rules = array('firstname' => 'required', 'lastname' => 'required', 'designation' => 'required');
$validator = Validator::make($input, $rules);
if ($validator->passes()) {
$employee->firstname = $input['firstname'];
$employee->lastname = $input['lastname'];
$employee->contact = $input['contact'];
$employee->address = $input['address'];
$employee->designation_id = $input['designation'];
$employee->save();
return Redirect::action('EmployeeController@index');
}
return Redirect::action('EmployeeController@show', $employee->id);
}
public function DelTeam($id, $id_team)
{
// Start Check Authorization
/**
* 1. FullAccess - 1
* 2. HRD - 3
* 3. Creator - 5
* 4. Handler - 7
*/
$invalid_auth = 1;
$authRole = Auth::user()->UserRoles->role;
if ($authRole == 7 or $authRole == 1 or $authRole == 3) {
$invalid_auth = 0;
}
if ($invalid_auth == 1) {
Alert::error('Anda tidak memilik akses ini')->persistent('close');
return redirect('project/view/' . $id);
}
// End Check Authorization
$db = Team::find($id_team);
$db->status = 0;
$db->save();
$now = date('Y-m-d');
foreach ($db->tl as $tl) {
$db_tl = Teamleader::find($tl->id);
$db_tl->status = 0;
$db_tl->end = $now;
$db_tl->save();
}
foreach ($db->store as $store) {
$db_st = Store::find($store->id);
$db_st->status = 0;
$db_st->save();
foreach ($store->members as $gm) {
$db_gm = Member::find($gm->id);
$db_gm->status = 0;
$db_gm->end = $now;
$db_gm->save();
foreach ($gm->get_users as $gu) {
if ($gm->status == 1) {
$db_em = Employee::find($gu->id);
$db_em->status = 0;
$db_em->save();
}
}
}
}
Alert::success('Berhasil menonaktifkan !')->persistent("Close");
return redirect('project/view/' . $id)->with('message', 'Stop Team Success!');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$employee = Employee::find($id);
$employee->delete();
return redirect()->route('employees.index');
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$employee = Employee::find($id);
$formTitle = 'Edit employee';
return View('employees.form', compact('employee', 'formTitle'));
}
public function addDriver(Request $request)
{
$request['action'] = 'Add driver';
$request['c_description'] = 'Driver added';
$request['e_description'] = 'Add to client';
Log::create($request->all());
// update log
$employee = Employee::find($request['eid']);
$employee != null ? $employee->update($request->only('cid')) : redirect('client/' . $request['cid']);
//update driver's foreign key
return redirect('client/' . $request['cid']);
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
$validation = Validator::make($request->all(), Employee::rules($id), ['name' => 'required|min:4|max:55', 'tempat_lahir' => 'required|min:4|max:55', 'tanggal_lahir' => 'required', 'kelamin' => 'required', 'agama' => 'required', 'status_nikah' => 'required', 'nohp' => 'required', 'alamat' => 'required|min:10|max:555', 'pt' => 'required', 'id_provinces' => 'required']);
// Check if it fails //
if ($validation->fails()) {
return redirect()->back()->withInput()->with('errors', $validation->errors());
}
$jabatan = $request->input('jabatan');
if ($jabatan > 0) {
$internal = 1;
} else {
$internal = 0;
}
// tag cities
$data = Employee::find($id);
$fr = serialize(Input::get('cities'));
if ($request->hasFile('userfile')) {
$path = '/assets/employee/';
$old_img = $data->pict;
Storage::delete(public_path() . $path . $old_img);
$image = $request->file('userfile');
$filename = time() . '.' . $image->getClientOriginalExtension();
$path = public_path('assets/employee/' . $filename);
$img = Image::make($image->getRealPath());
// resize the image to a width of 300 and constrain aspect ratio (auto height)
$img->resize(300, null, function ($constraint) {
$constraint->aspectRatio();
});
$img->save($path);
$data->pict = $filename;
}
// save category data into database //
$data->name = $request->input('name');
$data->tempat_lahir = $request->input('tempat_lahir');
$data->tanggal_lahir = $request->input('tanggal_lahir');
$data->kelamin = $request->input('kelamin');
$data->agama = $request->input('agama');
$data->status_nikah = $request->input('status_nikah');
$data->no_ktp = $request->input('no_ktp');
$data->berat_badan = $request->input('berat_badan');
$data->tinggi_badan = $request->input('tinggi_badan');
$data->nohp = $request->input('nohp');
$data->nohp2 = $request->input('nohp2');
$data->alamat = $request->input('alamat');
$data->id_jabatans = $jabatan;
$data->internal = $internal;
$data->pendidikan = $request->input('pt');
$data->des_pendidikan = $request->input('ptd');
$data->id_provinces = $request->input('id_provinces');
$data->id_cities = $fr;
$data->grade = $request->input('grade');
$data->save();
Alert::success('Sukses input ' . $request->input('name') . ' !')->persistent("Close");
return redirect('data/list')->with('message', 'You just create ' . $request->input('name') . ' !');
}
public function assign($id)
{
$employee = Employee::find($id);
\Session::flash('employee', $employee);
return redirect('laptop');
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, $id)
{
//find id
$employee = Employee::find($id);
//validation
$this->validate($request, ['name' => 'required|max:255', 'email' => 'required', 'address' => 'required', 'telephone' => 'required', 'salary' => 'required', 'birth' => 'required', 'hire' => 'required']);
//get data from input
$input = $request->all();
$name = $input['name'];
//get name
$email = $input['email'];
//get email
$address = $input['address'];
//get name
$telephone = $input['telephone'];
//get telephone
$salary = $input['salary'];
//get salary
$birth = $input['birth'];
//get date of birth
$hire = $input['hire'];
//get date of hire
// update data into database
$employee->name = $name;
$employee->email = $email;
$employee->address = $address;
$employee->telephone = $telephone;
$employee->salary = $salary;
$employee->data_of_birth = $birth;
$employee->data_of_hire = $hire;
$employee->save();
// after save data will redirect to index page
return redirect('/');
}
/**
* Update the specified resource in storage.
*
* @param int $id
* @return Response
*/
public function update($id, EditUserRequest $request)
{
$vld = User::validate($request->all(), $id);
if (!$vld->passes()) {
// dd($vld->errors()->getMessages());
return Redirect::back()->with('messageNo', $vld->errors()->getMessages()['username'][0]);
}
$user = User::find($id);
$password = '';
if ($request->password != '') {
$password = bcrypt($request->password);
} else {
$password = $user->password;
}
$employee = Employee::find($request->get('employee_id'));
$user->update(['employee_id' => $request->get('employee_id'), 'fullname' => $employee->lastname . " " . $employee->firstname, 'username' => $request->username, 'password' => $password]);
$user->attachGroup($request['group_id']);
return redirect()->route('users.index')->with('messageOk', 'Update user successfully');
}
public function employee($id)
{
Employee::find($id)->delete();
return back();
}
/**
* Display the specified resource.
*
* @param int $id
* @return Response
*/
public function show($id)
{
return Response::json(Employee::find($id));
}
/**
* Export to excel list device
*
* @return file excel
*/
public function exportExcel()
{
Excel::create('List Device', function ($excel) {
$excel->sheet('Sheetname', function ($sheet) {
$sheet->setBorder('A1:K1', 'thin');
$sheet->cells('A1:K1', function ($cells) {
$cells->setBackground('blue');
$cells->setFontColor('#FFFFFF');
$cells->setAlignment('center');
$cells->setValignment('middle');
$cells->setFontFamily('Times New Roman');
});
$sheet->setFontFamily('Times New Roman');
$sheet->setWidth(array('A' => '10', 'B' => '20', 'C' => '20', 'D' => '20', 'E' => '20', 'F' => '20', 'G' => '40', 'H' => '20', 'I' => '30', 'J' => '20', 'K' => '20'));
$data = [];
/*HEADER EXCEL*/
array_push($data, array('STT', 'NAME DEVICE', 'SERIAL DEVICE', 'RECEIVE DATE', 'STATUS'));
/*CONTENT EXCEL*/
$device = Device::all();
$number = 0;
foreach ($device as $key => $value) {
$device[$key]->device_name = KindDevice::find($value->kind_device_id)->device_name;
$device[$key]->status = StatusDevice::find($value->status_id)->status;
$device[$key]->employee_code = Employee::find($value->employee_id)->employee_code;
$number++;
array_push($data, array($number, $value->device_name, $value->serial_device, $value->receive_date, $value->status, $value->distribution));
}
$sheet->fromArray($data, null, 'A1', false, false);
});
})->download('xls');
}
/**
* Update the specified resource in storage.
*
* @param \Illuminate\Http\Request $request
* @param int $id
* @return \Illuminate\Http\Response
*/
public function update(HttpRequest $request, $id)
{
$input = $request->all();
$employee = App\Employee::find($id);
$employee->update($input);
return redirect('/employees');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Employee::find($id)->delete();
return redirect('employees');
}
/**
* Delete employee
* @param [int] $id
* @return [Reponse]
*/
public function delete($id)
{
$employee = Employee::find($id);
WorkingExperience::where('employee_id', '=', $employee->id)->delete();
TakenProject::where('employee_id', '=', $employee->id)->delete();
EmployeeSkill::where('employee_id', '=', $employee->id)->delete();
Education::where('employee_id', '=', $employee->id)->delete();
User::where('employee_id', '=', $employee->id)->delete();
$employee->delete();
return redirect()->route('employee.index')->with('messageDelete', 'Delete employee successfully!');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy(Request $request)
{
$employee = Employee::find($request->input('id'));
$employee->delete();
return "Employee record successfully deleted #" . $request->input('id');
}
public function DelTeam($id, $id_team)
{
$db = Team::find($id_team);
$db->status = 0;
$db->save();
$now = date('Y-m-d');
foreach ($db->tl as $tl) {
$db_tl = Teamleader::find($tl->id);
$db_tl->status = 0;
$db_tl->end = $now;
$db_tl->save();
}
foreach ($db->store as $store) {
$db_st = Store::find($store->id);
$db_st->status = 0;
$db_st->save();
foreach ($store->members as $gm) {
$db_gm = Member::find($gm->id);
$db_gm->status = 0;
$db_gm->end = $now;
$db_gm->save();
foreach ($gm->get_users as $gu) {
if ($gm->status == 1) {
$db_em = Employee::find($gu->id);
$db_em->status = 0;
$db_em->save();
}
}
}
}
Alert::success('Berhasil menonaktifkan !')->persistent("Close");
return redirect('project/view/' . $id)->with('message', 'Stop Team Success!');
}
