/**
* 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'));
}
public function run()
{
$faker = Faker::create();
foreach (range(1, 10) as $index) {
Deduction::create([]);
}
}
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'));
}
$objValidation->setErrorTitle('Input error');
$objValidation->setError('Value is not in list.');
$objValidation->setPromptTitle('Pick from list');
$objValidation->setPrompt('Please pick a value from the drop-down list.');
$objValidation->setFormula1('"' . $emplist . '"');
//note this!
}
});
})->export('xls');
});
/*
*deduction template
*
*/
Route::get('template/deductions', function () {
$data = Deduction::all();
$employees = Employee::all();
Excel::create('Deductions', function ($excel) use($data, $employees) {
require_once base_path() . "/vendor/phpoffice/phpexcel/Classes/PHPExcel/NamedRange.php";
require_once base_path() . "/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DataValidation.php";
$excel->sheet('deductions', function ($sheet) use($data, $employees) {
$sheet->row(1, array('EMPLOYEE', 'DEDUCTION TYPE', 'AMOUNT', 'Date'));
$empdata = array();
foreach ($employees as $d) {
$empdata[] = $d->personal_file_number . ':' . $d->first_name . ' ' . $d->last_name . ' ' . $d->middle_name;
}
$emplist = implode(", ", $empdata);
$listdata = array();
foreach ($data as $d) {
$listdata[] = $d->deduction_name;
}
/**
* Remove the specified branch from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$deduction = Deduction::findOrFail($id);
Deduction::destroy($id);
Audit::logaudit('Deductions', 'delete', 'deleted: ' . $deduction->deduction_name);
return Redirect::route('deductions.index');
}
/**
* Remove the specified branch from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
Deduction::destroy($id);
return Redirect::route('deductions.index');
}
public function destroy($id)
{
Deduction::destroy($id);
Session::flash('message', 'Sukses menghapus Income Payroll!!');
}
