/**
* Show the form for editing the specified branch.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$rel = ERelief::find($id);
$employees = Employee::all();
$reliefs = Relief::all();
return View::make('employee_relief.edit', compact('rel', 'employees', 'reliefs'));
}
/**
* Show the form for editing the specified branch.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$eallw = EAllowances::find($id);
$employees = Employee::all();
$allowances = Allowance::all();
return View::make('employee_allowances.edit', compact('eallw', 'allowances', 'employees'));
}
/**
* Show the form for editing the specified branch.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$ded = EDeduction::find($id);
$employees = Employee::all();
$deductions = Deduction::all();
return View::make('employee_deductions.edit', compact('ded', 'employees', 'deductions'));
}
/**
* Show the form for editing the specified leaveapplication.
*
* @param int $id
* @return Response
*/
public function edit($id)
{
$leaveapplication = Leaveapplication::find($id);
$employees = Employee::all();
$leavetypes = Leavetype::all();
return View::make('leaveapplications.edit', compact('leaveapplication', 'employees', 'leavetypes'));
}
public function index()
{
$entities = Entity::all();
$employees = Employee::all();
$menu = 'data';
return View::make('entities.index', compact('employees', 'entities', 'menu'));
}
/**
* Store a newly created branch in storage.
*
* @return Response
*/
public function store()
{
$employees = Employee::all();
foreach ($employees as $employee) {
$payroll = new Payroll();
$payroll->employee_id = $employee->personal_file_number;
$payroll->basic_pay = $employee->basic_pay;
$payroll->earning_amount = Payroll::total_benefits($employee->id);
$payroll->taxable_income = Payroll::gross($employee->id);
$payroll->paye = Payroll::tax($employee->id);
$payroll->nssf_amount = Payroll::nssf($employee->id);
$payroll->nhif_amount = Payroll::nhif($employee->id);
$payroll->other_deductions = Payroll::deductions($employee->id);
$payroll->total_deductions = Payroll::total_deductions($employee->id);
$payroll->net = Payroll::net($employee->id);
$payroll->financial_month_year = Input::get('period');
$payroll->account_id = Input::get('account');
$payroll->save();
}
$allws = DB::table('employee_allowances')->join('allowances', 'employee_allowances.allowance_id', '=', 'allowances.id')->join('employee', 'employee_allowances.employee_id', '=', 'employee.id')->join('transact', 'employee.personal_file_number', '=', 'transact.employee_id')->select('employee.id', 'allowance_name', 'allowance_id', 'allowance_amount', 'financial_month_year')->get();
foreach ($allws as $allw) {
DB::table('transact_allowances')->insert(['employee_id' => $allw->id, 'allowance_name' => $allw->allowance_name, 'allowance_id' => $allw->allowance_id, 'allowance_amount' => $allw->allowance_amount, 'financial_month_year' => $allw->financial_month_year]);
}
$deds = DB::table('employee_deductions')->join('deductions', 'employee_deductions.deduction_id', '=', 'deductions.id')->join('employee', 'employee_deductions.employee_id', '=', 'employee.id')->join('transact', 'employee.personal_file_number', '=', 'transact.employee_id')->select('employee.id', 'deduction_name', 'deduction_id', 'deduction_amount', 'financial_month_year')->get();
foreach ($deds as $ded) {
DB::table('transact_deductions')->insert(['employee_id' => $ded->id, 'deduction_name' => $ded->deduction_name, 'deduction_id' => $ded->deduction_id, 'deduction_amount' => $ded->deduction_amount, 'financial_month_year' => $ded->financial_month_year]);
}
$earns = DB::table('earnings')->join('employee', 'earnings.employee_id', '=', 'employee.id')->join('transact', 'employee.personal_file_number', '=', 'transact.employee_id')->select('earnings.employee_id', 'earnings_name', 'financial_month_year', 'earnings_amount')->get();
foreach ($earns as $earn) {
DB::table('transact_earnings')->insert(['employee_id' => $earn->employee_id, 'earning_name' => $earn->earnings_name, 'earning_amount' => $earn->earnings_amount, 'financial_month_year' => $earn->financial_month_year]);
}
$period = Input::get('period');
Audit::logaudit('Payroll', 'process', 'processed payroll for ' . $period);
return Redirect::route('payroll.index')->withFlashMessage('Payroll successfully processed!');
}
/** @test */
public function child_model_keeps_scope()
{
User::create(['type' => Employee::class]);
User::create(['type' => null]);
$users = Employee::all();
$this->assertCount(1, $users);
$this->assertInstanceOf(Employee::class, $users->first());
}
public function employee_identity()
{
$name = Employee::all();
if ($name) {
return $name;
}
return NULL;
}
public function edit($id)
{
$movement = Movement::findOrFail($id);
$courses = Course::where('location_id', '=', Auth::user()->location_id)->get();
$employees = Employee::all();
$menu = 'student';
return View::make('movements.edit', compact('movement', 'courses', 'employees', 'menu'));
}
public function index()
{
$users = User::all();
$employees = Employee::all();
$locations = Location::all();
$menu = 'data';
return View::make('users.index', compact('users', 'employees', 'locations', 'menu'));
}
public function index()
{
$handbooks = Handbook::where('project_id', '=', Auth::user()->curr_project_id)->get();
$employees = Employee::all();
$generations = Generation::all();
$majors = Major::all();
$menu = 'project';
return View::make('handbooks.index', compact('employees', 'handbooks', 'generations', 'majors', 'menu'));
}
public function index()
{
$this->load->model('Employee');
$employees = Employee::all();
if ($employees === null) {
$response = array('Status' => "Fail", "ErrorMessage" => "No Users Found");
} else {
$response = array('Status' => "Success", 'data' => $employees);
}
$this->output->set_content_type('application/json')->set_output(json_encode($response));
}
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 employee()
{
$ids = DB::table('tblEmployees')->select('strEmpID')->orderBy('updated_at', 'desc')->orderBy('strEmpID', 'desc')->take(1)->get();
$ID = $ids["0"]->strEmpID;
$newID = $this->smart($ID);
$ids2 = DB::table('tblLogin')->select('strUsername')->orderBy('strUsername', 'desc')->take(1)->get();
$ID2 = $ids2["0"]->strUsername;
$newID2 = $this->smart($ID2);
// Get all products from the database
$employees = Employee::all();
$branches = Branch::lists('strBrchName', 'strBrchID');
$roles = Role::lists('strRoleDescription', 'strRoleID');
$data = array('employees' => $employees, 'branches' => $branches, 'roles' => $roles);
return View::make('employee')->with('data', $data)->with('newID', $newID)->with('newID2', $newID2);
}
public function create()
{
$menu = 'registration';
$generations = Generation::all();
$classifications = Classification::where('category', '=', 'Registration')->get();
$locations = Location::where('id', '<>', Auth::user()->location_id)->get();
$employees = Employee::all();
$courses = Course::where('project_id', '=', Auth::user()->curr_project_id)->where('location_id', '=', Auth::user()->location_id)->where('availability', '=', 1)->where('active', '=', 1)->get();
$discounts = Discount::all();
$promotions = Promotion::all();
$vouchers = Voucher::all();
$charges = Charge::all();
$partners = Partner::where('location_id', '=', Auth::user()->location_id)->get();
return View::make('registrations.create', compact('classifications', 'locations', 'employees', 'generations', 'courses', 'charges', 'discounts', 'promotions', 'vouchers', 'partners', 'menu'));
}
public static function update($id)
{
$params = $_POST;
$employees = Employee::all();
$attributes = array('id' => $id, 'name' => $params['name'], 'price' => $params['price'], 'description' => $params['description']);
$service = new Service($attributes);
$errors = $service->errors();
// $list = $_POST['checkbox'];
foreach ($employees as $emp) {
if (isset($_POST[$emp->id])) {
OfferedServicesController::create($emp->id, $id);
// $attr = array(
// 'employeeid' => $emp->id,
// 'serviceid' => $id
// );
// $offer = new OfferedServices($attr);
// $offer->save();
} else {
OfferedServicesController::destroy($emp->id, $id);
// $offer = new OfferedServices(array('employeeid' => $emp->id, 'serviceid' => $id));
// $offer->destroy($emp->id, $id);
}
}
//
// foreach ($list as $employee) {
// $attr = array(
// 'employeeid' => $employee,
// 'serviceid' => $id
// );
//
// $offer = new OfferedServices($attr);
// $offer->save();
// }
$employeeList = OfferedServicesController::getEmployees($id, $employees);
if (count($errors) > 0) {
View::make('service/edit.html', array('errors' => $errors, 'attributes' => $attributes, 'employees' => $employees, 'employeeList' => $employeeList));
} else {
$service->update();
Redirect::to('/palvelut/' . $service->id, array('message' => "Palveluun tehdyt muutokset tallennettu!"));
}
}
public function index()
{
/* Employee selected by clicking radio button */
/* ! Remember to clear Input if this is redirected from delete !*/
$selectedEmployee = new Employee();
if (Input::has('selectedEmployee')) {
$selectedEmployee = Employee::find(Input::get('selectedEmployee'));
}
$selectedCategory = new Category();
if (Input::has('selectedCategory')) {
$selectedCategory = Category::find(Input::get('selectedCategory'));
}
$selectedShop = new Shop();
if (Input::has('selectedShop')) {
$selectedShop = Shop::find(Input::get('selectedShop'));
}
$employees = Employee::all();
$categories = Category::all();
$shops = Shop::all();
$item = new Item();
return View::make('employees.index', compact('employees', 'item', 'categories', 'shops', 'selectedEmployee', 'selectedCategory', 'selectedShop'));
}
Route::get('erpReports', function () {
return View::make('erpreports.erpReports');
});
Route::get('erpReports/clients', 'ErpReportsController@clients');
Route::get('erpReports/items', 'ErpReportsController@items');
Route::get('erpReports/expenses', 'ErpReportsController@expenses');
Route::get('erpReports/paymentmethods', 'ErpReportsController@paymentmethods');
Route::get('erpReports/payments', 'ErpReportsController@payments');
Route::get('erpReports/locations', 'ErpReportsController@locations');
Route::get('erpReports/stock', 'ErpReportsController@stock');
/*
*#################################################################
*/
Route::group(['before' => 'process_payroll'], function () {
Route::get('payrollmgmt', function () {
$employees = Employee::all();
return View::make('payrollmgmt', compact('employees'));
});
});
Route::group(['before' => 'leave_mgmt'], function () {
Route::get('leavemgmt', function () {
$leaveapplications = Leaveapplication::all();
return View::make('leavemgmt', compact('leaveapplications'));
});
});
Route::get('erpmgmt', function () {
return View::make('erpmgmt');
});
Route::get('cbsmgmt', function () {
if (Confide::user()->user_type == 'admin') {
$members = Member::all();
public function template()
{
$employees = Employee::all();
$organization = Organization::find(1);
$pdf = PDF::loadView('pdf.blank', compact('employees', 'organization'))->setPaper('a4')->setOrientation('landscape');
return $pdf->stream('Template.pdf');
}
@extends('layouts.admin.default')
@section('content')
<?php
$employeeEditId = $employeeEditInfo[0]->id;
$message = Session::get('message');
//echo 'employeeEdit:'.$employeeEditId;
//exit;
$companies = Company::all();
$departments = Department::all();
$jobTitles = JobTitle::all();
$managers = Employee::all();
$supervisors = Employee::all();
$roles = DB::table('groups')->get();
if (isset($employeeEditId) && !empty($employeeEditId)) {
$userEdit = DB::table('users')->where('employee_id', $employeeEditId)->first();
}
if (isset($userEdit) && !empty($userEdit)) {
$userGroupEdit = DB::table('users_groups')->where('user_id', $userEdit->id)->first();
}
if (isset($userGroupEdit) && !empty($userGroupEdit)) {
$groupEdit = DB::table('groups')->where('id', (int) $userGroupEdit->group_id)->first();
}
$companyArr[0] = '';
if (!empty($companies)) {
foreach ($companies as $company) {
$companyArr[$company->id] = $company->name;
}
}
$departmentArr[0] = '';
/**
* Show the form for creating a new branch
*
* @return Response
*/
public function create()
{
$employees = Employee::all();
return View::make('documents.create', compact('employees'));
}
/**
* This function responses to the
* post request of the /admin/employee/action
* then checked which button is pressed in the
* form of employee.view.blade.php of the
* route /admin/employee
*/
public function postAction()
{
// Holding checked row value from employee table
$id = Input::get('checked');
/**
* Redirected route if Edit button is pressed
*/
if (Input::has('Edit')) {
return Redirect::route('employee-edit-get', $id);
}
/**
* Redirected route if Details button is pressed
*/
if (Input::has('Details')) {
return Redirect::route('employee-details-get', $id);
}
/**
* Redirected route if Print button is pressed
*/
if (Input::has('Print')) {
$parameterr = array();
$parameter['employees'] = Employee::all();
$pdf = PDF::loadView('reports.employee.getAllEmployees', $parameter)->setPaper('a4')->setOrientation(config::$EMPLOYEE_REPORT_ORIENTATION)->setWarnings(false);
return $pdf->stream('employees.pdf');
}
/**
* If Delete button is pressed
* destroy function find employee by id
* and deletes the employee from employee table
*/
if (Input::has('Delete')) {
foreach ($id as $employeeId) {
$employee = Employee::find($employeeId);
$employee->userDelete($employee->id);
$employee->delete();
}
return Redirect::route('employee-get', 1);
}
}
public function advancedSearch()
{
if (Session::has('username') && (Session::get('user_type') == "Root" || Session::get('user_type') == "Admin" || Session::get('user_type') == "User")) {
$view = View::make("Employees.advanced_search_employees");
$view->employees = Employee::orderBy("last_name", "asc")->paginate(25);
$view->nav = "employees";
$getManagers = Manager::orderBy('last_name', 'asc')->get();
$managers = array("all" => "All", "" => "None");
foreach ($getManagers as $manager) {
if (!empty($manager["first_name"])) {
$managers[$manager["id"]] = $manager["last_name"] . ", " . $manager["first_name"];
} else {
$managers[$manager["id"]] = $manager["last_name"];
}
}
$view->managers = $managers;
$view->result = Employee::all()->count();
return $view;
} else {
return Redirect::to('/');
}
}
/**
* Display a listing of employees
*
* @return Response
*/
public function index()
{
$employees = Employee::all();
return View::make('admin.employees.index', compact('employees'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
$employees = Employee::all();
Audit::logaudit('Employees', 'view', 'viewed employee list');
return View::make('employees.index', compact('employees'));
}
public function employee()
{
// Get all products from the database
$employees = Employee::all();
return View::make('employee')->with('employees', $employees);
}
public function employeesReports()
{
if (Session::has('username') && (Session::get('user_type') == "Root" || Session::get('user_type') == "Admin" || Session::get("user_type") == "User")) {
$view = View::make("Reports.employees_reports");
$view->nav = "system";
$view->tab = "employees";
$view->totalEmployees = Employee::all()->count();
$view->onBoard = Employee::where("status", "=", "On-Board")->count();
$view->ojt = Employee::where("status", "=", "OJT")->count();
$view->ojtGraduate = Employee::where("status", "=", "OJT Graduate")->count();
$view->academy = Employee::where("status", "=", "Academy")->count();
$view->contractual = Employee::where("status", "=", "Contractual")->count();
$view->nsnGuest = Employee::where("status", "=", "NSN Guest")->count();
$view->graduate = Employee::where("status", "=", "Graduate")->count();
$view->resigned = Employee::where("status", "=", "Resigned")->count();
$view->obsolete = Employee::where("status", "=", "Obsolete")->count();
return $view;
} else {
return Redirect::to("/");
}
}
public function employeeselect()
{
$employees = Employee::all();
return View::make('leavereports.employeeSelect', compact('employees'));
}
/**
* Show the form for creating a new kin
*
* @return Response
*/
public function create()
{
$employees = Employee::all();
return View::make('properties.create', compact('employees'));
}
public static function index()
{
$employees = Employee::all();
View::make('employee/index.html', array('employees' => $employees));
}
