/** * Show the form for creating a new resource. * GET /payments/create * * @return Response */ public function create($id) { $invoices = Invoice::with('invoicedetail')->find($id); $paymenttypes = Paymenttype::all(); $total = $invoices->invoicedetail->rent + $invoices->invoicedetail->water + $invoices->invoicedetail->electricity + $invoices->invoicedetail->security; $houseid = $invoices->houseID; $balance = Payment::where('houseID', $houseid)->sum('balance'); return View::make('backend.code.payment.create', compact('invoices', 'invoicedetail', 'total', 'balance')); }
public function createPayment($id) { $invoices = Invoice::with('invoicedetail')->find($id); if ($invoices->type === "to tenant") { $total = $invoices->invoicedetail->rent + $invoices->invoicedetail->water + $invoices->invoicedetail->electricity + $invoices->invoicedetail->security + $invoices->invoicedetail->service + $invoices->invoicedetail->garbage; } elseif ($invoices->type === "refund") { $total = $invoices->invoicedetail->rentD + $invoices->invoicedetail->waterD + $invoices->invoicedetail->electricityD + $invoices->invoicedetail->g_repairs + $invoices->invoicedetail->transport_cost + $invoices->invoicedetail->o_bills + $invoices->invoicedetail->storage_fees + $invoices->invoicedetail->fixed_unit; } elseif ($invoices->type === "deposits") { $total = $invoices->invoicedetail->rentD + $invoices->invoicedetail->waterD + $invoices->invoicedetail->electricityD + $invoices->invoicedetail->g_repairs + $invoices->invoicedetail->transport_cost + $invoices->invoicedetail->o_bills + $invoices->invoicedetail->storage_fees + $invoices->invoicedetail->fixed_unit + $invoices->invoicedetail->rent; } $houseid = $invoices->id; $hid = $invoices->houseID; $housename = House::where('id', $hid)->pluck('name'); $propertyid = House::where('id', $hid)->pluck('propertyID'); $propertyname = Property::where('id', $propertyid)->pluck('name'); $paymenttypes = Paymenttype::where(['propertyID' => $propertyid])->orWhere(['propertyID' => 0])->get(); $types = Paymenttype::where('propertyID', 0)->get(); $allbal = Invoice::where('houseID', $hid)->sum('balance'); $outstandingbal = $allbal - $invoices->balance; $balance = $invoices->balance; if ($outstandingbal == $invoices->balance) { $amountdue = $invoices->balance; } else { $amountdue = $invoices->balance + $outstandingbal; } return View::make('backend.code.payment.create', compact('invoices', 'housename', 'types', 'outstandingbal', 'propertyname', 'invoicedetail', 'paymenttypes', 'total', 'balance', 'amountdue')); }
/** * Remove the specified resource from storage. * DELETE /houses/{id} * * @param int $id * @return Response */ public function destroy($id) { Paymenttype::find($id)->delete(); return Redirect::route('paymenttype'); }
public function paymentType() { $uid = Input::get('agent_id'); $properties = Property::where('agent_id', $uid)->lists('id'); $stack = array('0'); array_push($stack, $properties); $pypes = Paymenttype::whereIn('propertyID', $stack)->get(); $noteType = array('paymenttypes' => $pypes); return $noteType; }