public function indexAction()
{
$departments = Department::find();
$this->view->departments = $departments;
$employees = Employee::find();
$this->view->employees = $employees;
}
public function payslip()
{
if (!empty(Input::get('sel'))) {
$period = Input::get("period");
$id = Input::get('employeeid');
$employees = Employee::all();
foreach ($employees as $employee) {
$transacts = DB::table('transact')->join('employee', 'transact.employee_id', '=', 'employee.personal_file_number')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $employee->id)->groupBy('transact.id')->get();
$allws = DB::table('transact_allowances')->join('employee', 'transact_allowances.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $employee->id)->groupBy('allowance_name')->get();
$earnings = DB::table('transact_earnings')->join('employee', 'transact_earnings.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $employee->id)->groupBy('earning_name')->get();
$deds = DB::table('transact_deductions')->join('employee', 'transact_deductions.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $employee->id)->groupBy('deduction_name')->get();
$currencies = DB::table('currencies')->select('shortname')->get();
$organization = Organization::find(1);
$pdf = PDF::loadView('pdf.monthlySlip', compact('transacts', 'allws', 'deds', 'earnings', 'period', 'currencies', 'organization'))->setPaper('a4')->setOrientation('potrait');
}
return $pdf->stream('Monthly_Payslip_' . $period . '.pdf');
} else {
$period = Input::get("period");
$id = Input::get('employeeid');
$employee = Employee::find($id);
$transacts = DB::table('transact')->join('employee', 'transact.employee_id', '=', 'employee.personal_file_number')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->get();
$allws = DB::table('transact_allowances')->join('employee', 'transact_allowances.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('allowance_name')->get();
$earnings = DB::table('transact_earnings')->join('employee', 'transact_earnings.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('earning_name')->get();
$deds = DB::table('transact_deductions')->join('employee', 'transact_deductions.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('deduction_name')->get();
$currencies = DB::table('currencies')->select('shortname')->get();
$organization = Organization::find(1);
$pdf = PDF::loadView('pdf.monthlySlip', compact('employee', 'transacts', 'allws', 'deds', 'earnings', 'period', 'currencies', 'organization'))->setPaper('a4')->setOrientation('potrait');
return $pdf->stream($employee->first_name . '_' . $employee->last_name . '_' . $period . '.pdf');
}
}
public function checkEarnings($id)
{
$startDate = $start = Input::get('startDate');
$endDate = $end = Input::get('endDate');
$start = date('Y-m-d', strtotime($start));
$end = date('Y-m-d', strtotime($end));
// Get the owed sum for the given range.
$salaryForRange = Employee::getSalaryRange($id, $start, $end);
$rangeSum = 0;
$rangeValetedVehicles = 0;
foreach ($salaryForRange as $item) {
$employeesCut = Vehicle::getEmployeesCut($item->vehicle_fk);
$rangeSum = $rangeSum + $employeesCut * $item->quantity;
// Calculate the number of processed vehicles.
$rangeValetedVehicles += $item->quantity;
}
$employeeData = Employee::find($id);
$processedVehicles = InvoiceElement::where('employee_fk', '=', $employeeData->id)->count();
$totalSalary = Employee::getSalary($id);
// Get the rest of the information.
$totalSum = 0;
foreach ($totalSalary as $item) {
$employeesCut = Vehicle::getEmployeesCut($item->vehicle_fk);
$totalSum = $totalSum + $employeesCut * $item->quantity;
}
return View::make('employee.profile')->with(['employeeData' => $employeeData, 'processedVehicles' => $processedVehicles, 'totalSum' => $totalSum, 'rangeSum' => $rangeSum, 'startDate' => $startDate, 'endDate' => $endDate, 'rangeValetedVehicles' => $rangeValetedVehicles]);
}
public static function edit($id)
{
$employee = Employee::find($id);
$services = Service::all();
//
$serviceList = OfferedServicesController::getServices($id, $services);
View::make('employee/edit.html', array('attributes' => $employee, 'services' => $services, 'serviceList' => $serviceList));
}
public static function get_user_logged_in()
{
if (isset($_SESSION['employee'])) {
$employee_id = $_SESSION['employee'];
$employee = Employee::find($employee_id);
return $employee;
}
return null;
}
public static function createLeaveApplication($data)
{
$organization = Organization::getUserOrganization();
$employee = Employee::find(array_get($data, 'employee_id'));
$leavetype = Leavetype::find(array_get($data, 'leavetype_id'));
$application = new Leaveapplication();
$application->applied_start_date = array_get($data, 'applied_start_date');
$application->applied_end_date = array_get($data, 'applied_end_date');
$application->status = 'applied';
$application->application_date = date('Y-m-d');
$application->employee()->associate($employee);
$application->leavetype()->associate($leavetype);
$application->organization()->associate($organization);
$application->save();
}
public static function sandbox()
{
$service = Service::find(1);
$services = Service::all();
$employees = Employee::all();
$employee = Employee::find(1);
$service2 = new Service(array('name' => 'aasdd', 'price' => "2", 'description' => "asfafaf"));
$errors = $service2->errors();
Kint::dump($employee);
Kint::dump($employees);
Kint::dump($service);
Kint::dump($services);
Kint::dump($errors);
// View::make('helloworld.html');
}
public function show($id)
{
$payroll = Payroll::findOrFail($id);
$curr_month = (int) date('m', strtotime($payroll->release_date));
$curr_year = (int) date('Y', strtotime($payroll->release_date));
$curr_month = $curr_month - 1;
if ($curr_month == 0) {
$curr_month = 12;
$curr_year = $curr_year - 1;
}
$employee = Employee::find($payroll->employee_id);
$incomes = Income::where('employee_id', '=', $employee->id)->where(DB::raw('year(release_date)'), '=', $curr_year)->where(DB::raw('month(release_date)'), '=', $curr_month)->get();
$deductions = Deduction::where('employee_id', '=', $employee->id)->where(DB::raw('year(release_date)'), '=', $curr_year)->where(DB::raw('month(release_date)'), '=', $curr_month)->get();
$teaches = Teach::where('employee_id', '=', $employee->id)->where(DB::raw('year(course_date)'), '=', $curr_year)->where(DB::raw('month(course_date)'), '=', $curr_month)->count();
$menu = 'employee';
return View::make('payrolls.show', compact('payroll', 'employee', 'incomes', 'deductions', 'teaches', 'curr_year', 'curr_month', 'menu'));
}
protected function get_relationship($type = null)
{
if (!$type) {
$type = $this->relationship_name;
}
switch ($type) {
case 'belongs_to':
$ret = Event::find(5);
break;
case 'has_one':
$ret = Employee::find(1);
break;
case 'has_many':
$ret = Venue::find(2);
}
return $ret;
}
private function generate_employees_list($_is_applicants = false)
{
$criteria = array('columns' => "id, CONCAT(lastname, ', ', firstname) AS employee, country", 'match' => "id > 1", 'order' => "employee ASC");
$employee = new Employee();
$result = $employee->find($criteria);
$id = 'job_owners_filter';
if ($_is_applicants) {
$id = 'ref_job_owners_filter';
}
echo '<select id="' . $id . '">' . "\n";
echo '<option value="0">Everyone</option>' . "\n";
echo '<option value="0" disabled> </option>' . "\n";
echo '<option value="' . $this->employee->getId() . '" selected>Myself</option>' . "\n";
foreach ($result as $row) {
if ($row['id'] != $this->employee->getId()) {
echo '<option value="' . $row['id'] . '">' . $row['employee'] . ' (' . $row['country'] . ')' . '</option>' . "\n";
}
}
echo '</select>';
}
/**
* This function shows user profile
*/
public function getUserProfile()
{
if (Session::get('admin') == 'admin') {
$user = User::where('username', '=', Session::get('username'))->get()->first();
$userProfile = Admin::find($user->details_id);
$userProfile->DOB = DateFormat::show($userProfile->DOB);
return View::make('user.profile')->with('userProfile', $userProfile);
}
if (Session::get('employee') == 'employee') {
$user = User::where('username', '=', Session::get('username'))->get()->first();
$userProfile = Employee::find($user->details_id);
$userProfile->DOB = DateFormat::show($userProfile->DOB);
return View::make('user.profile')->with('userProfile', $userProfile);
}
if (Session::get('member') == 'member') {
$user = User::where('username', '=', Session::get('username'))->get()->first();
$userProfile = Member::find($user->details_id);
$userProfile->DOB = DateFormat::show($userProfile->DOB);
return View::make('user.profile')->with('userProfile', $userProfile);
}
}
public function postSignIn()
{
// check validation
$validator = Validator::make(Input::all(), array('username' => 'required', 'password' => 'required'));
// if validation is failed it's redirected
// to sign in page with validation errors
if ($validator->fails()) {
return Redirect::route('signin-get')->withErrors($validator)->withInput();
} else {
$remember = Input::has('remember') ? true : false;
$auth = Auth::attempt(array('username' => Input::get('username'), 'password' => trim(Input::get('password')), 'active' => 1), $remember);
if ($auth) {
$user = User::where('username', '=', Input::get('username'))->get()->first();
// Holding all important data
// from database to session
// variable
Session::put('username', $user->username);
Session::put('user_level', $user->user_level);
Session::put('user_id', $user->id);
Session::put('wc_msg', 1);
if ($user->user_level === 'admin') {
Session::put('admin', 'admin');
Session::put('employee_id', Employee::find($user->details_id)->id);
return Redirect::intended('/admin');
} elseif ($user->user_level === 'employee') {
Session::put('employee', 'employee');
Session::put('employee_id', Employee::find($user->details_id)->id);
return Redirect::intended('/employee');
} elseif ($user->user_level === 'member') {
Session::put('member', 'member');
Session::put('member_id', Member::find($user->details_id)->id);
return Redirect::intended('/member');
}
} else {
return View::make('userAuthentication.signin')->with('invalid', 'Invalid Username/Password.');
}
}
}
Route::post('leaveReports/approvedleaves', 'ReportsController@approvedleaves');
Route::get('leaveReports/selectRejectedPeriod', 'ReportsController@rejectedperiod');
Route::post('leaveReports/rejectedleaves', 'ReportsController@rejectedleaves');
Route::get('leaveReports/selectLeave', 'ReportsController@balanceselect');
Route::post('leaveReports/leaveBalances', 'ReportsController@leavebalances');
Route::get('leaveReports/selectLeaveType', 'ReportsController@leaveselect');
Route::post('leaveReports/Employeesonleave', 'ReportsController@employeesleave');
Route::get('leaveReports/selectEmployee', 'ReportsController@employeeselect');
Route::post('leaveReports/IndividualEmployeeLeave', 'ReportsController@individualleave');
Route::get('api/dropdown', function () {
$id = Input::get('option');
$bbranch = Bank::find($id)->bankbranch;
return $bbranch->lists('bank_branch_name', 'id');
});
Route::get('empedit/{id}', function ($id) {
$employee = Employee::find($id);
$branches = Branch::all();
$departments = Department::all();
$jgroups = JGroup::all();
$etypes = EType::all();
$banks = Bank::all();
$bbranches = BBranch::all();
return View::make('employees.cssedit', compact('branches', 'departments', 'etypes', 'jgroups', 'banks', 'bbranches', 'employee'));
});
Route::get('css/payslips', function () {
$employeeid = DB::table('employee')->where('personal_file_number', '=', Confide::user()->username)->pluck('id');
$employee = Employee::findorfail($employeeid);
return View::make('css.payslip', compact('employee'));
});
Route::get('css/leave', function () {
$employeeid = DB::table('employee')->where('personal_file_number', '=', Confide::user()->username)->pluck('id');
public function individualleave()
{
$id = Input::get("employeeid");
$employee = Employee::find($id);
$leavetypes = Leavetype::all();
$organization = Organization::find(1);
$pdf = PDF::loadView('leavereports.individualReport', compact('leavetypes', 'employee', 'organization'))->setPaper('a4')->setOrientation('potrait');
return $pdf->stream($employee->first_name . '_' . $employee->last_name . '_Leave_Report.pdf');
}
public static function updateEmployee($data)
{
Employee::find($data->eid)->update(array('ename' => $data->ename, 'ebirth' => $data->ebirth, 'egender' => $data->egender, 'etel' => $data->etel, 'eemail' => $data->eemail, 'eaddress' => $data->eaddress, 'dcode' => $data->dcode, 'rcode' => $data->rcode));
}
public function deleteEmployee()
{
$employee = Employee::find(Input::get('id'));
$employee->delete();
return Redirect::route('manageEmployees')->with('flash_message', 'Employee ' . $employee->firstname . ' ' . $employee->lastname . ' has been deleted');
}
public function owner()
{
$name = Employee::find($this->owner_id);
return $name;
}
public function getDelete($id)
{
$employee = Employee::find($id);
if (is_object($employee)) {
File::delete('image/employee/' . $employee->emp_image);
$employee->delete();
}
return Redirect::to('admin/employee/showallemployee')->with('alert', 'ทำการลบข้อมูลเรียบร้อยแล้ว');
}
public function deleteEmployee()
{
if (Session::has('username') && Session::get('user_type') == "Root") {
$employees = Input::get("employee_id");
$hasDeletedAny = false;
$noOfDeletedEmployees = 0;
foreach ($employees as $e) {
$employee = Employee::find($e);
if (!$employee) {
continue;
}
$desc = "(" . Session::get('user_type') . ") " . "<strong>" . Session::get('username') . "</strong> has deleted employee <strong>" . $employee->first_name . " " . $employee->last_name . " (Employee #: " . $employee->employee_number . ") </strong>.";
//Log the changes made
$newLog = new UserLog();
$newLog->description = $desc;
$newLog->user_id = Session::get('user_id');
$newLog->type = "Employees";
$newLog->save();
$hasDeletedAny = true;
$noOfDeletedEmployees += 1;
$employee->delete();
}
if ($hasDeletedAny) {
$desc = "(" . Session::get('user_type') . ") " . "<strong>" . Session::get('username') . "</strong> has deleted <strong>" . $noOfDeletedEmployees . "</strong> employee(s).";
//Log the changes made
$newLog = new UserLog();
$newLog->description = $desc;
$newLog->user_id = Session::get('user_id');
$newLog->type = "Employees";
$newLog->save();
}
return Redirect::to(Session::get("page"));
} else {
return Redirect::to("/");
}
}
/**
* Display the specified product.
*
* @param int $id
* @return Response
*/
public function show($id)
{
$employee = Employee::find($id);
return Response::json($employee);
}
public function sendEmail()
{
if (!empty(Input::get('sel'))) {
$period = Input::get('period');
$employees = Employee::all();
$emps = DB::table('employee')->count();
foreach ($employees as $user) {
$transacts = DB::table('transact')->join('employee', 'transact.employee_id', '=', 'employee.personal_file_number')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->get();
$allws = DB::table('transact_allowances')->join('employee', 'transact_allowances.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->groupBy('allowance_name')->get();
$earnings = DB::table('transact_earnings')->join('employee', 'transact_earnings.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->groupBy('earning_name')->get();
$deds = DB::table('transact_deductions')->join('employee', 'transact_deductions.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', $user->id)->groupBy('deduction_name')->get();
$currencies = DB::table('currencies')->select('shortname')->get();
$organization = Organization::find(1);
$fyear = '';
$fperiod = '';
$part = explode("-", $period);
if ($part[0] == 1) {
$fyear = 'January_' . $part[1];
} else {
if ($part[0] == 2) {
$fyear = 'Febraury_' . $part[1];
} else {
if ($part[0] == 3) {
$fyear = 'March_' . $part[1];
} else {
if ($part[0] == 4) {
$fyear = 'April_' . $part[1];
} else {
if ($part[0] == 5) {
$fyear = 'May_' . $part[1];
} else {
if ($part[0] == 6) {
$fyear = 'June_' . $part[1];
} else {
if ($part[0] == 7) {
$fyear = 'July_' . $part[1];
} else {
if ($part[0] == 8) {
$fyear = 'August_' . $part[1];
} else {
if ($part[0] == 9) {
$fyear = 'September_' . $part[1];
} else {
if ($part[0] == 10) {
$fyear = 'October_' . $part[1];
} else {
if ($part[0] == 11) {
$fyear = 'November_' . $part[1];
} else {
if ($part[0] == 12) {
$fyear = 'December_' . $part[1];
}
}
}
}
}
}
}
}
}
}
}
}
if ($part[0] == 1) {
$fperiod = 'January-' . $part[1];
} else {
if ($part[0] == 2) {
$fperiod = 'Febraury-' . $part[1];
} else {
if ($part[0] == 3) {
$fperiod = 'March-' . $part[1];
} else {
if ($part[0] == 4) {
$fperiod = 'April-' . $part[1];
} else {
if ($part[0] == 5) {
$fperiod = 'May-' . $part[1];
} else {
if ($part[0] == 6) {
$fperiod = 'June-' . $part[1];
} else {
if ($part[0] == 7) {
$fperiod = 'July-' . $part[1];
} else {
if ($part[0] == 8) {
$fperiod = 'August-' . $part[1];
} else {
if ($part[0] == 9) {
$fperiod = 'September-' . $part[1];
} else {
if ($part[0] == 10) {
$fperiod = 'October-' . $part[1];
} else {
if ($part[0] == 11) {
$fperiod = 'November-' . $part[1];
} else {
if ($part[0] == 12) {
$fperiod = 'December-' . $part[1];
}
}
}
}
}
}
}
}
}
}
}
}
$fileName = $user->first_name . '_' . $user->last_name . '_' . $fyear . '.pdf';
$filePath = 'app/views/temp/';
$pdf = PDF::loadView('pdf.monthlySlip', compact('employee', 'transacts', 'allws', 'deds', 'earnings', 'period', 'currencies', 'organization'))->setPaper('a4')->setOrientation('potrait');
$pdf->save($filePath . $fileName);
Mail::send('payslips.message', compact('fperiod', 'user'), function ($message) use($user, $filePath, $fileName) {
$message->to($user->email_office, $user->first_name . ' ' . $user->last_name)->subject('Payslip');
$message->attach($filePath . $fileName);
});
unlink($filePath . $fileName);
}
return Redirect::back()->with('success', 'Email Sent!');
} else {
if (empty(Input::get('sel')) && !empty(Input::get('employeeid'))) {
$period = Input::get('period');
$employees = Employee::all();
$emps = DB::table('employee')->count();
$id = Input::get('employeeid');
$employee = Employee::find($id);
$transacts = DB::table('transact')->join('employee', 'transact.employee_id', '=', 'employee.personal_file_number')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->get();
$allws = DB::table('transact_allowances')->join('employee', 'transact_allowances.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('allowance_name')->get();
$earnings = DB::table('transact_earnings')->join('employee', 'transact_earnings.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('earning_name')->get();
$deds = DB::table('transact_deductions')->join('employee', 'transact_deductions.employee_id', '=', 'employee.id')->where('financial_month_year', '=', Input::get('period'))->where('employee.id', '=', Input::get('employeeid'))->groupBy('deduction_name')->get();
$currencies = DB::table('currencies')->select('shortname')->get();
$organization = Organization::find(1);
$fyear = '';
$fperiod = '';
$part = explode("-", $period);
if ($part[0] == 1) {
$fyear = 'January_' . $part[1];
} else {
if ($part[0] == 2) {
$fyear = 'Febraury_' . $part[1];
} else {
if ($part[0] == 3) {
$fyear = 'March_' . $part[1];
} else {
if ($part[0] == 4) {
$fyear = 'April_' . $part[1];
} else {
if ($part[0] == 5) {
$fyear = 'May_' . $part[1];
} else {
if ($part[0] == 6) {
$fyear = 'June_' . $part[1];
} else {
if ($part[0] == 7) {
$fyear = 'July_' . $part[1];
} else {
if ($part[0] == 8) {
$fyear = 'August_' . $part[1];
} else {
if ($part[0] == 9) {
$fyear = 'September_' . $part[1];
} else {
if ($part[0] == 10) {
$fyear = 'October_' . $part[1];
} else {
if ($part[0] == 11) {
$fyear = 'November_' . $part[1];
} else {
if ($part[0] == 12) {
$fyear = 'December_' . $part[1];
}
}
}
}
}
}
}
}
}
}
}
}
if ($part[0] == 1) {
$fperiod = 'January-' . $part[1];
} else {
if ($part[0] == 2) {
$fperiod = 'Febraury-' . $part[1];
} else {
if ($part[0] == 3) {
$fperiod = 'March-' . $part[1];
} else {
if ($part[0] == 4) {
$fperiod = 'April-' . $part[1];
} else {
if ($part[0] == 5) {
$fperiod = 'May-' . $part[1];
} else {
if ($part[0] == 6) {
$fperiod = 'June-' . $part[1];
} else {
if ($part[0] == 7) {
$fperiod = 'July-' . $part[1];
} else {
if ($part[0] == 8) {
$fperiod = 'August-' . $part[1];
} else {
if ($part[0] == 9) {
$fperiod = 'September-' . $part[1];
} else {
if ($part[0] == 10) {
$fperiod = 'October-' . $part[1];
} else {
if ($part[0] == 11) {
$fperiod = 'November-' . $part[1];
} else {
if ($part[0] == 12) {
$fperiod = 'December-' . $part[1];
}
}
}
}
}
}
}
}
}
}
}
}
$fileName = $employee->first_name . '_' . $employee->last_name . '_' . $fyear . '.pdf';
$filePath = 'app/views/temp/';
$pdf = PDF::loadView('pdf.monthlySlip', compact('employee', 'transacts', 'allws', 'deds', 'earnings', 'period', 'currencies', 'organization'))->setPaper('a4')->setOrientation('potrait');
$pdf->save($filePath . $fileName);
$user = Employee::find($id);
Mail::send('payslips.message', compact('fperiod', 'user'), function ($message) use($user, $filePath, $fileName) {
$message->to($user->email_office, $user->first_name . ' ' . $user->last_name)->subject('Payslip');
$message->attach($filePath . $fileName);
});
unlink($filePath . $fileName);
}
}
return Redirect::back()->with('success', 'Email Sent!');
}
public function reactEmployee()
{
$id = Input::get('reactID');
$isAdded = FALSE;
if (!$isAdded) {
$employee = Employee::find($id);
$reas = Input::get('reactInactiveEmp');
$reason = DB::table('tblReasonEmployee')->where('strInactiveEmployeeID', '=', $reas)->delete();
$employee->boolIsActive = 1;
$employee->save();
return Redirect::to('/utilities/inactiveData?successRec=true');
} else {
return Redirect::to('/utilities/inactiveData?successRec=false');
}
}
public function redeem()
{
$employee = Employee::find(Input::get('employee_id'));
$leeavetype = Leavetype::find(Input::get('leavetype_id'));
Leaveapplication::RedeemLeaveDays($employee, $leavetype);
return Redirect::route('leaveapplications.index');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$employee = Employee::find($id);
$employee->destroy($id);
Session::flash('success', 'Successfully Deleted');
return Redirect::to('/employees');
}
/**
* Show the form for editing the specified branch.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$employee = Employee::find($id);
$branches = Branch::all();
$departments = Department::all();
$jgroups = JGroup::all();
$etypes = EType::all();
$banks = Bank::all();
$bbranches = BBranch::all();
return View::make('employees.edit', compact('branches', 'departments', 'etypes', 'jgroups', 'banks', 'bbranches', 'employee'));
}
/**
* This function responses to
* the get request of /admin/employee/details/{id}
* and view employee respect to id
*/
public function getDetails($id, $msg = null)
{
$employee = Employee::find($id);
$employee->DOB = DateFormat::show($employee->DOB);
if (!empty($msg) && $msg == 1) {
return View::make('adminArea.employee.details')->with('employee', $employee)->with('orders', Order::orderBy('from', 'desc')->get())->with('success', "Order has been deactivated successfully");
}
return View::make('adminArea.employee.details')->with('employee', $employee)->with('orders', Order::orderBy('from', 'desc')->get());
}
public function delete_emp()
{
$getID = Input::get('deleteID');
$employee = Employee::find($getID);
$employee->actStatus = '0';
$employee->save();
return Redirect::to('/employees');
}
public function edit($id)
{
$employee = Employee::find($id);
return View::make('employees.edit', compact('employee'));
}
public function deactivateportal($id)
{
$employee = Employee::find($id);
DB::table('users')->where('username', '=', $employee->personal_file_number)->delete();
return Redirect::back()->with('notice', 'Employee has been deactivated');
}
