PHP Employee::all方法代码示例

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