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