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