/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$ltypes = [];
foreach (Loan::all() as $loan) {
$ltypes += [$loan->id => $loan->name];
}
return view('regular.create', compact('ltypes'));
}
public function run()
{
DB::table('loandiscs')->delete();
$loans = Loan::all();
for ($l = 0; $l < count($loans); $l++) {
Loandisc::create(['loan_id' => $loans[$l]->id]);
}
}
public function update($id)
{
// save updated
$record = $this->records->find($id);
if (!$record) {
Loan::create(Input::all());
return $this->respond($record);
}
$record->fill(Input::all())->save();
return $this->respond($record);
}
public function update(Request $request, $id)
{
if (Auth::user()->role === 'superadmin') {
$input = $request->all();
$data = Loan::findOrFail($id);
$data->update($input);
return redirect('loan');
} else {
return redirect('auth/login');
}
}
public static function getLoanActive($id)
{
$obj = Loan::getByStatus(self::STATUS_ACTIVE)->where('id', $id)->first();
if ($obj == null) {
return response()->json(array('Not found'));
}
$obj->user = $obj->user()->first();
$obj->loanItems = $obj->loanItems()->get();
unset($obj->user_id);
return $obj;
}
/**
* Show the form for creating a new resource.
*
* @return \Illuminate\Http\Response
*/
public function create()
{
$members = [];
foreach (Member::all() as $member) {
$members += [$member->id => $member->name()];
}
$loans = Loan::all();
$ltypes = [];
foreach ($loans as $loan) {
$ltypes += [$loan->id => $loan->name];
}
return view('admin.account.create', compact('ltypes', 'members', 'loans'));
}
public function run()
{
DB::table('loans')->delete();
//[1] Tony Stark(1) @ Glass Towers(1) | Partnership(4)--Ag-Input 2015
Loan::create(['applicant_id' => 1, 'app_date' => Carbon::now()->subWeek(3)->subDay(2), 'distributor_approval_date' => Carbon::now()->subWeek(2)->subDay(4), 'decision_date' => Carbon::now()->subWeek(2)->subDay(1), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'loan_type_id' => 2, 'status_id' => 1, 'crop_year' => '2015', 'season' => 'S', 'loc_id' => 5, 'region_id' => 3, 'user_id' => 3, 'farmer_id' => 1, 'is_fast_tracked' => 0, 'is_stale' => 0, 'is_watched' => 1, 'disbursement_issue' => 0, 'has_distributor' => 1, 'distributor_id' => 6, 'has_addendum' => 1, 'addendum_type' => 2, 'is_xcolled' => 1, 'bankruptcy_history' => 0, 'required_3party' => 0, 'added_land' => 0, 'controlled_disbursement' => 0, 'its_list' => 1, 'fsa_compliant' => 1, 'crop_inspection' => 0, 'limit_warning' => 0, 'reconciliation' => 3, 'account_classification' => '-', 'grade' => '-', 'equipment_collateral' => 1, 'realestate_collateral' => 1, 'other_collateral' => 1, 'conditions_asa' => 1, 'conditions_aci' => 1, 'conditions_areb' => 1, 'conditions_afsa' => 1, 'conditions_adis' => 1, 'conditions_pg' => 1, 'conditions_ccl' => 0, 'conditions_cd' => 0]);
// Matches Excel 2015
Loan::create(['applicant_id' => 8, 'app_date' => Carbon::now()->subWeek(3)->subDay(2), 'distributor_approval_date' => Carbon::now()->subWeek(2)->subDay(4), 'decision_date' => Carbon::now()->subWeek(2)->subDay(1), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'loan_type_id' => 2, 'status_id' => 1, 'crop_year' => '2015', 'season' => 'S', 'loc_id' => 5, 'region_id' => 3, 'user_id' => 3, 'farmer_id' => 9, 'is_xcolled' => 1, 'is_fast_tracked' => 0, 'grade' => 'B', 'equipment_collateral' => 0, 'realestate_collateral' => 0, 'is_watched' => 1, 'disbursement_issue' => 0, 'has_rebates' => 0, 'has_distributor' => 1, 'distributor_id' => 3, 'is_stale' => 0, 'has_addendum' => 0, 'bankruptcy_history' => 0, 'required_3party' => 0, 'added_land' => 0, 'controlled_disbursement' => 0, 'its_list' => 1, 'fsa_compliant' => 1, 'prev_lien_verified' => 1, 'leases_valid' => 1, 'bankruptcy_order_received' => 1, 'recommended' => 1, 'arm_approved' => 0, 'dist_approved' => 0, 'loan_closed' => 0, 'added_land_verified' => 0, 'permission_to_insure_verified' => 0, 'arm_ucc_received' => 0, 'dist_ucc_received' => 0, 'aoi_received' => 0, 'ccc_received' => 0, 'crop_certified' => 0, 'rebate_assignment' => 0, 'limit_warning' => 1, 'crop_inspection' => 0, 'reconciliation' => 0, 'account_classification' => 'A', 'grade' => 'A', 'conditions_asa' => 1, 'conditions_aci' => 1, 'conditions_areb' => 1, 'conditions_adis' => 1, 'conditions_pg' => 1, 'conditions_ccl' => 1, 'conditions_cd' => 1, 'its_list' => 1]);
// Blake Donald(10) @ Rainbow Bridge(6) | Individual--Capital Bridge 2015
Loan::create(['applicant_id' => 6, 'app_date' => Carbon::now()->subWeek(), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-06-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-06-15'), 'loc_id' => 5, 'user_id' => 3, 'region_id' => 3, 'crop_year' => '2015', 'season' => 'S', 'loan_type_id' => 5, 'farmer_id' => 10, 'analyst_can_approve' => 1, 'analyst_can_submit' => 1, 'is_stale' => 0, 'is_watched' => 1, 'disbursement_issue' => 0, 'has_distributor' => 1, 'distributor_id' => 6, 'has_addendum' => 1, 'addendum_type' => 2, 'is_xcolled' => 0, 'bankruptcy_history' => 1, 'required_3party' => 1, 'added_land' => 1, 'controlled_disbursement' => 1, 'its_list' => 1, 'fsa_compliant' => 1, 'prev_lien_verified' => 1, 'leases_valid' => 1, 'bankruptcy_order_received' => 1, 'received_3party' => 1, 'recommended' => 1, 'arm_approved' => 1, 'dist_approved' => 1, 'loan_closed' => 1, 'added_land_verified' => 1, 'permission_to_insure_verified' => 1, 'lien_letter_received' => 1, 'arm_ucc_received' => 1, 'dist_ucc_received' => 1, 'aoi_received' => 1, 'ccc_received' => 1, 'crop_certified' => 1, 'rebate_assignment' => 1, 'crop_inspection' => 2, 'limit_warning' => 2, 'reconciliation' => 3, 'account_classification' => '-', 'grade' => '-', 'equipment_collateral' => 1, 'limit_warning_message' => 'Caution: 76% of budget exceeded.', 'account_classification' => '-', 'grade' => 'B']);
// Bruce Wayne(2) @ Secret Cave(3) | Joint Venture (1)--Ag-Pro Fasttrack 2015
Loan::create(['applicant_id' => 3, 'app_date' => Carbon::now()->subDays(2), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'loc_id' => 5, 'user_id' => 3, 'region_id' => 3, 'crop_year' => '2015', 'season' => 'S', 'loan_type_id' => 4, 'farmer_id' => 2, 'limit_warning' => 2, 'limit_warning_message' => 'Caution: Seed budget exceeded.', 'is_stale' => 0, 'crop_certified' => 0, 'conditions_asa' => 1, 'conditions_aci' => 1, 'conditions_areb' => 1, 'conditions_afsa' => 1, 'conditions_adis' => 1, 'reconciliation' => 0, 'account_classification' => 'B', 'grade' => 'B']);
// Steve Rogers(12) @ Shielded Farms(4) | Corporation -- Ag-Vest 2015
Loan::create(['applicant_id' => 4, 'app_date' => Carbon::now(), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'loc_id' => 5, 'user_id' => 3, 'region_id' => 3, 'crop_year' => '2015', 'season' => 'S', 'loan_type_id' => 6, 'farmer_id' => 12, 'limit_warning' => 3, 'limit_warning_message' => 'Warning: 97% of budget exceeded.', 'crop_certified' => 2, 'is_stale' => 0, 'its_list' => 1, 'reconciliation' => 0, 'account_classification' => 'A', 'grade' => 'A']);
// Clint Barton(5) @ Nested Row(2) | Spousal--Ag-Pro 2015
Loan::create(['applicant_id' => 2, 'app_date' => Carbon::now()->subDays(3), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'decision_date' => Carbon::now(), 'loc_id' => 5, 'user_id' => 3, 'region_id' => 3, 'crop_year' => '2015', 'season' => 'S', 'loan_type_id' => 3, 'farmer_id' => 5, 'limit_warning' => 0, 'is_stale' => 0, 'crop_certified' => 1, 'conditions_asa' => 1, 'conditions_aci' => 1, 'conditions_areb' => 1, 'conditions_afsa' => 1, 'conditions_adis' => 1, 'reconciliation' => 0, 'account_classification' => 'C', 'grade' => 'C']);
// Matt Murdoch(9) @ Dark World(5) | Individual -- All-in 2015
Loan::create(['applicant_id' => 5, 'app_date' => Carbon::now()->subDays(2), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-12-15'), 'loc_id' => 5, 'user_id' => 3, 'region_id' => 6, 'crop_year' => '2015', 'season' => 'F', 'loan_type_id' => 1, 'farmer_id' => 9, 'crop_certified' => 0, 'limit_warning' => 0, 'is_watched' => 0, 'is_stale' => 0, 'bankruptcy_history' => 1, 'conditions_asa' => 1, 'conditions_aci' => 1, 'conditions_areb' => 1, 'conditions_afsa' => 1, 'conditions_adis' => 1, 'reconciliation' => 3, 'account_classification' => '-', 'grade' => '-']);
// Diana Prince(7) @ Kingdom Plains(7) | Spousal -- Grain Storage 2015
Loan::create(['applicant_id' => 7, 'app_date' => Carbon::now()->subDays(4), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2015-03-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2015-04-30'), 'loc_id' => 2, 'user_id' => 3, 'region_id' => 2, 'crop_year' => '2015', 'season' => 'S', 'loan_type_id' => 7, 'farmer_id' => 7, 'crop_certified' => 0, 'limit_warning' => 3, 'limit_warning_message' => 'Warning: 100% of budget exceeded.', 'is_stale' => 0, 'its_list' => 1, 'fsa_compliant' => 1, 'reconciliation' => 0, 'account_classification' => 'A', 'grade' => 'A']);
// Tony Stark(1) @ Glass Towers(1) | Partnership | Ag-Input 2014
Loan::create(['app_date' => Carbon::createFromFormat('Y-m-d', '2014-01-01'), 'default_due_date' => Carbon::createFromFormat('Y-m-d', '2014-12-15'), 'due_date' => Carbon::createFromFormat('Y-m-d', '2014-12-15'), 'loan_type_id' => 2, 'status_id' => 2, 'crop_year' => '2014', 'season' => 'F', 'loc_id' => 5, 'region_id' => 3, 'user_id' => 3, 'farmer_id' => 1, 'applicant_id' => 2, 'is_active' => 0, 'is_xcolled' => 0, 'is_fast_tracked' => 0, 'is_stale' => 0, 'has_distributor' => 1, 'distributor_id' => 6, 'conditions_asa' => 1, 'conditions_aci' => 1, 'conditions_areb' => 1, 'conditions_afsa' => 1, 'conditions_adis' => 1, 'its_list' => 1, 'fsa_compliant' => 1, 'prev_lien_verified' => 1, 'leases_valid' => 1, 'bankruptcy_order_received' => 1, 'received_3party' => 1, 'recommended' => 1, 'arm_approved' => 1, 'dist_approved' => 1, 'loan_closed' => 1, 'loan_closed_date' => Carbon::createFromFormat('Y-m-d', '2014-08-01'), 'added_land_verified' => 1, 'permission_to_insure_verified' => 1, 'arm_ucc_received' => 1, 'dist_ucc_received' => 1, 'aoi_received' => 1, 'ccc_received' => 1, 'crop_certified' => 1, 'rebate_assignment' => 1, 'limit_warning' => 4, 'limit_warning_message' => '100% of budget exceeded', 'crop_inspection' => 1, 'reconciliation' => 0, 'grade' => 'B']);
}
/**
* View employees with loan
*
* @param int $id
* @return Response
*/
public function deleteLoan($id, $loanId)
{
Labor::where('employee_no', $id)->first()->LoanMonths()->where('loan_id', $loanId)->delete();
Loan::find($loanId)->delete();
flash()->success('Successfully deleted.');
return redirect('employees/' . $id . '/edit');
}
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function destroy($id)
{
$loan = new Loan();
if ($loan->destroy($id)) {
return "success";
}
}
Route::get('/ajax-product-price', function () {
$branch = Auth::user()->branch;
$pid = Input::get('pid');
//$products=Product::where('pid', '=', $pid)->get();
$products = \DB::select('SELECT p.pid, p.cid, p.p_name, ROUND(p.buying_price,2) as buying_price, ROUND(p.selling_price, 2) as selling_price, ROUND(s.quantity, 2) as quantity FROM product p, stock s WHERE p.pid=s.pid AND p.pid=' . $pid . ' AND s.branch=' . "'" . $branch . "'");
return Response::json($products);
});
Route::get('/ajax-stock-product-price', function () {
$branch = Auth::user()->branch;
$pid = Input::get('pid');
$products = Product::where('pid', '=', $pid)->get();
return Response::json($products);
});
Route::get('/ajax-loan-installment', function () {
$lid = Input::get('lid');
$loan = Loan::where('lid', '=', $lid)->get();
return Response::json($loan);
});
Route::get('/balance', function () {
$branch = Auth::user()->branch;
$sheet = \DB::select('SELECT @a:=@a+1 sl, xx.* FROM
(SELECT income_title AS title, invoice_no AS address, "-" AS dr, amount AS cr, created_at FROM income where branch=' . "'" . $branch . "'" . '
UNION ALL
SELECT payment_title AS title, purpose AS address, amount AS dr, "-" AS cr, created_at FROM payment where branch=' . "'" . $branch . "'" . ' ORDER BY created_at DESC) xx, (SELECT @a:= 0) AS a;');
return Response::json($sheet);
});
Route::get('/ajax-client', function () {
$cname = Input::get('term');
$client = \DB::select('SELECT name, address FROM consumer WHERE type=' . '"client" and name like ' . '"%' . $cname . '%"');
foreach ($client as $row) {
$data[] = $row->name;
/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$loan = Loan::findOrFail($id)->delete();
return Redirect::route('admin.setup.loan.company.index')->withFlashSuccess('Company Loans data was successfully deleteds.');
}
public function filterAjaxAttendance()
{
$summary = [];
$filterComplete = 'false';
$skip = intval(\Input::get('skip'));
$take = intval(\Input::get('take'));
$viewDeleted = \Input::get('view_deleted');
$dateFrom = \Input::get('date_from');
$dateTo = \Input::get('date_to');
$employee_no = \Input::get('employee_no');
$site = \Input::get('site_list');
$trade = \Input::get('trade_list');
$dateFromCarbon = Carbon::parse($dateFrom);
$dateToCarbon = Carbon::parse($dateTo);
$sites = Site::where('id', '>', 1)->get()->lists('code', 'id')->toArray();
$monthFrom = $dateFromCarbon->format('n');
$monthTo = $dateToCarbon->format('n');
$yearFrom = $dateFromCarbon->format('Y');
$yearTo = $dateToCarbon->format('Y');
$dFrom = Carbon::parse($dateFrom);
$dTo = Carbon::parse($dateTo);
$total_days = 0;
//dd($dTo->format('n-Y'));
if ($dateFromCarbon->format('n-Y') != $dTo->format('n-Y')) {
do {
$total_days += $this->daysCount(intval($dFrom->format('n')), intval($dFrom->format('Y')));
$dFrom->addMonth();
} while ($dFrom->format('n-Y') != $dTo->format('n-Y'));
$total_days += $this->daysCount(intval($dTo->format('n')), intval($dTo->format('Y')));
} else {
$total_days += $this->daysCount(intval($dTo->format('n')), intval($dTo->format('Y')));
}
$showAbsent = \Input::get('view_absent') == 1 ? true : false;
$labors = Labor::where('deleted', 'false')->orderBy('employee_no')->skip($skip)->take($take)->get();
//if deleted employees included
if ($viewDeleted) {
$labors = Labor::orderBy('employee_no')->skip($skip)->take($take)->get();
}
//if filter by employee number
if (!empty($employee_no) && empty($site) && empty($trade)) {
$labors = Labor::where('employee_no', $employee_no)->where('deleted', 'false')->orderBy('employee_no')->skip($skip)->take($take)->get();
if ($viewDeleted) {
$labors = Labor::where('employee_no', $employee_no)->orderBy('employee_no')->skip($skip)->take($take)->get();
}
} elseif (empty($employee_no) && !empty($site) && empty($trade)) {
$labors = Labor::where('deleted', 'false')->where('site_id', $site[0]);
if ($viewDeleted) {
$labors = Labor::where('site_id', $site[0]);
}
if (count($site) > 1) {
foreach ($site as $s) {
$labors = $labors->orWhere('site_id', $s);
}
}
$labors = $labors->orderBy('employee_no')->skip($skip)->take($take)->get();
} elseif (empty($employee_no) && empty($site) && !empty($trade)) {
$labors = Labor::where('deleted', 'false')->where('trade_id', $trade[0]);
if ($viewDeleted) {
$labors = Labor::where('trade_id', $trade[0]);
}
if (count($trade) > 1) {
foreach ($trade as $t) {
$labors = $labors->orWhere('trade_id', $t);
}
}
$labors = $labors->orderBy('employee_no')->skip($skip)->take($take)->get();
} elseif (!empty($employee_no) && !empty($site) && empty($trade)) {
$labors = Labor::where('deleted', 'false')->where('employee_no', $employee_no);
if ($viewDeleted) {
$labors = Labor::where('employee_no', $employee_no);
}
$labors = $labors->where(function ($query) use($site) {
foreach ($site as $s) {
$query->orWhere('site_id', $s);
}
});
$labors = $labors->orderBy('employee_no')->skip($skip)->take($take)->get();
} elseif (!empty($employee_no) && empty($site) && !empty($trade)) {
$labors = Labor::where('deleted', 'false')->where('employee_no', $employee_no);
if ($viewDeleted) {
$labors = Labor::where('employee_no', $employee_no);
}
$labors = $labors->where(function ($query) use($trade) {
foreach ($trade as $t) {
$query->orWhere('trade_id', $t);
}
});
$labors = $labors->orderBy('employee_no')->skip($skip)->take($take)->get();
} elseif (empty($employee_no) && !empty($site) && !empty($trade)) {
$labors = Labor::where('deleted', 'false');
if ($viewDeleted) {
$labors = Labor::all();
}
$labors = $labors->where(function ($query) use($site) {
foreach ($site as $s) {
$query->orWhere('site_id', $s);
}
});
$labors = $labors->where(function ($query) use($trade) {
foreach ($trade as $t) {
$query->orWhere('trade_id', $t);
}
});
$labors = $labors->orderBy('employee_no')->skip($skip)->take($take)->get();
} elseif (!empty($employee_no) && !empty($site) && !empty($trade)) {
$labors = Labor::where('deleted', 'false')->where('employee_no', $employee_no);
if ($viewDeleted) {
$labors = Labor::where('employee_no', $employee_no);
}
$labors = $labors->where(function ($query) use($site) {
foreach ($site as $s) {
$query->orWhere('site_id', $s);
}
});
$labors = $labors->where(function ($query) use($trade) {
foreach ($trade as $t) {
$query->orWhere('trade_id', $t);
}
});
$labors = $labors->orderBy('employee_no')->skip($skip)->take($take)->get();
}
$filterComplete = empty($labors->toArray()) ? 'true' : 'false';
$labor_att = [];
$total = [];
$salary = [];
$trades = [];
foreach ($labors as $labor) {
$att_count = 0;
$ot_count = 0.0;
$bot_count = 0.0;
$deduction = 0;
//$loanEntry = $labor->loanMonths()->where('deduction_month',Carbon::now()->format('Ym'))->first();
foreach ($labor->loanMonths()->get() as $loanMonth) {
if ($loanMonth->deduction_date->format('Ym') == Carbon::now()->format('Ym')) {
$deduction = intval(Loan::find($loanMonth->loan_id)->deduction);
}
}
$trades[] = $labor->trade->name;
for ($dateFromCarbon; $dateFromCarbon <= $dateToCarbon; $dateFromCarbon->addDay()) {
$att_entry = $labor->attendance()->where('att_date', $dateFromCarbon->format('Y-m-d H:i:s'))->first();
if (!is_null($att_entry)) {
if ($showAbsent && $att_entry->pivot->attended == '1') {
$labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')] = '—';
} else {
$labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->attended;
$att_count += intval($labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')]);
}
} else {
$labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')] = '—';
}
if (!is_null($att_entry) && $att_entry->pivot->attended == '1') {
if ($showAbsent) {
$labor_att[$labor->employee_no]['ot'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['bot'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['site'][$dateFromCarbon->format('Y-m-d')] = '—';
} else {
$labor_att[$labor->employee_no]['ot'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->ot;
$labor_att[$labor->employee_no]['bot'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->bot;
$labor_att[$labor->employee_no]['site'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->site;
$ot_count += floatval($att_entry->pivot->ot);
$bot_count += intval($att_entry->pivot->bot);
}
} elseif (!is_null($att_entry) && $att_entry->pivot->attended == '0') {
if ($showAbsent) {
$labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->attended;
$labor_att[$labor->employee_no]['ot'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->ot;
$labor_att[$labor->employee_no]['bot'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->bot;
$labor_att[$labor->employee_no]['site'][$dateFromCarbon->format('Y-m-d')] = $att_entry->pivot->site;
} else {
$labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['ot'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['bot'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['site'][$dateFromCarbon->format('Y-m-d')] = '—';
}
} elseif (is_null($att_entry)) {
$labor_att[$labor->employee_no]['attended'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['ot'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['bot'][$dateFromCarbon->format('Y-m-d')] = '—';
$labor_att[$labor->employee_no]['site'][$dateFromCarbon->format('Y-m-d')] = '—';
}
$total[$labor->employee_no]['attended'] = round($att_count, 2);
$total[$labor->employee_no]['ot'] = $ot_count;
$total[$labor->employee_no]['bot'] = $bot_count;
//------total salary computation
$basic_salary = intval($labor->basic_salary);
$allowance = intval($labor->allowance);
$gross = intval($labor->basic_salary) + intval($labor->allowance);
$salary[$labor->employee_no]['attended'] = round($gross / $total_days * $att_count, 2);
$salary[$labor->employee_no]['ot'] = round($basic_salary / $total_days / 8 * 1.25 * $ot_count, 2);
$salary[$labor->employee_no]['bot'] = round($basic_salary / $total_days / 8 * 1.25 * $bot_count, 2);
$salary[$labor->employee_no]['total'] = $salary[$labor->employee_no]['attended'] + $salary[$labor->employee_no]['ot'] + $salary[$labor->employee_no]['bot'] - $deduction;
}
$dateFromCarbon = Carbon::parse($dateFrom);
}
/*
$summary = [];
if(\Input::get('summary')){
$summary['total_days'] = $total_days;
if(!empty($site)){
$sites = Site::all()->lists('name')->toArray();
foreach($sites as $site){
$labors->where
}
}
else{
}
}
*/
$response = ['summary' => $summary, 'trade' => $trades, 'salary' => $salary, 'total' => $total, 'labor_att' => $labor_att, 'labor' => $labors, 'dateFrom' => $dateFromCarbon->format('Y-m-d'), 'dateTo' => $dateToCarbon->format('Y-m-d'), 'filterComplete' => $filterComplete];
echo json_encode($response);
}
/**
* Display the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
return Loan::getLoanActive($id);
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return \Illuminate\Http\Response
*/
public function edit($id)
{
$loan = Loan::find($id);
return view('admin.loan.create', compact($loan));
}
