/** * Show the form for dispatching the resource to the bench. * * @return Response */ public function dispatch($id) { $topupRequest = TopupRequest::find($id); $batches = Receipt::where('commodity_id', '=', $topupRequest->commodity_id)->lists('batch_no', 'id'); $users = User::where('id', '!=', Auth::user()->id)->lists('name', 'id'); return View::make('issue.create')->with('topupRequest', $topupRequest)->with('users', $users)->with('batches', $batches); }
public function popoverReceiptPreview($receipt_id) { $r = Receipt::where('id', $receipt_id)->first(); $data['transaction'] = Receipt::buildReceipt($receipt_id); $data['created_date'] = ng_date_format($r->created_at); $data['created_time'] = ng_time_format($r->created_at); $data['sales_person'] = istr::title(User::where('id', $r->user_id)->first()->name); $data['total_amount_due'] = format_money($r->receipt_worth); $data['total_amount_tendered'] = format_money($r->amount_tendered); $data['change'] = format_money($r->change); $s = Salelog::where('receipt_id', $receipt_id)->get()->toArray(); //$s = Salelog::where('receipt_id', $receipt_id)->get(); $data['items'] = $s; //tt($data['items']->discount); //$data['items']->unitprice = $data['items']->unitprice - (($data['items']->unitprice / 100) * (($data['items']->discount > 0) ? $data['items']->discount : 1 )); //tt($data['items']); return View::make('admin.quick_receipt_preview', $data); }
public function getReport() { $input = Input::all(); $v = Validator::make(Input::All(), array('property_name' => 'required', 'from_date' => 'required', 'to_date' => 'required', 'type' => 'required', 'houseIDReport' => 'required', 'agent_id' => 'required')); if ($v->passes()) { $propertyid = Input::get('property_name'); $from_date = Input::get('from_date'); $to_date = Input::get('to_date'); $type = Input::get('type'); $houseID = Input::get('houseIDReport'); $start_day = date("Y-m-d H:i:s", strtotime($from_date)); $end_day = date("Y-m-d H:i:s", strtotime($to_date)); $agent_id = Input::get('agent_id'); $billedusr = User::find($agent_id); $hisBalance = $billedusr->credit_balance; $newBalance = $hisBalance - 3; $billedusr->credit_balance = $newBalance; $billedusr->save(); $billstatement = new Statement(); $billstatement->type = "Report Generation"; $billstatement->amount = 3; $billstatement->save(); if ($houseID === "All Report") { $sumReceipts = Receipt::whereBetween('created_at', array($start_day, $end_day))->where('propertyid', $propertyid)->sum('amountpaid'); $sumInvoiceBalance = Invoice::whereBetween('created_at', array($start_day, $end_day))->where('propertyid', $propertyid)->sum('balance'); $sumInvoicePaid = Invoice::whereBetween('created_at', array($start_day, $end_day))->where('propertyid', $propertyid)->sum('amountpaid'); $sumRefundPaid = Invoice::where('propertyid', $propertyid)->where('type', '=', 'refund')->sum('amountpaid'); $invoiceUn = Invoice::list('houseID'); $unitsUnpaid = House::whereIn('name', $invoiceUn)->count(); $sumInvoice = $sumInvoiceBalance + $sumInvoicePaid; $noteSum = array('error' => false, 'type' => "All", 'sumRefund' => $sumRefundPaid, 'unitsUnpaid' => $unitsUnpaid, 'sumInvoice' => $sumInvoice, 'sumReceipt' => $sumReceipts); } else { $sumReceipts = Receipt::where('houseID', $houseID)->whereBetween('created_at', array($start_day, $end_day))->sum('amountpaid'); $sumInvoiceBalance = Invoice::where('houseID', $houseID)->whereBetween('created_at', array($start_day, $end_day))->sum('balance'); $sumInvoicePaid = Invoice::where('houseID', $houseID)->whereBetween('created_at', array($start_day, $end_day))->sum('amountpaid'); $sumInvoice = $sumInvoiceBalance + $sumInvoicePaid; $noteSum = array('error' => false, 'type' => "House", 'sumInvoice' => $sumInvoice, 'sumReceipt' => $sumReceipts); } return $noteSum; } $notePE = array('error' => true, 'message' => 'Ensure that all the fields are set'); return $notePE; }
Route::get('redirect/back', array('as' => 'redirect/back'), function () { return Redirect::back(); }); Route::get('payments-totenant', array('as' => 'payments-totenant', 'uses' => 'BillController@selectToPay')); Route::get('api/preports', array('as' => 'api/preports', 'uses' => 'PaymentController@Reports')); Route::post('api/spreport', array('as' => 'api/spreport', 'uses' => 'PaymentController@getFilteredReport')); Route::get('api/dropdown', array('as' => 'api/dropdown', function () { $properties = Property::lists('name'); return $properties; })); Route::get('ninvoice', array('as' => 'ninvoice', function () { $invoices = Invoice::where('agent_id', '=', Sentry::getUser()->id)->where('balance', '>', 0)->with('invoicedetail')->orderBy('id', 'desc')->get(); return $invoices; })); Route::get('nreceipts', array('as' => 'nreceipts', function () { $invoices = Receipt::where('agent_id', '=', Sentry::getUser()->id)->where('amountpaid', '>', 0)->orderBy('id', 'desc')->get(); return $invoices; })); Route::get('nrefunds', array('as' => 'nrefunds', function () { $invoices = Invoice::where('agent_id', '=', Sentry::getUser()->id)->where('type', '=', 'refund')->with('invoicedetail')->orderBy('id', 'desc')->get(); return $invoices; })); Route::get('api/property/{id}', array('as' => 'api/property', 'uses' => 'HousController@getHouses')); Route::get('api/receipts/{id}', array('as' => 'api/receipts', 'uses' => 'HousController@getRHouses')); Route::get('api/refunds/{id}', array('as' => 'api/refunds', 'uses' => 'HousController@getRfunds')); //select tenant to pay Route::get('tenant-selected/{id}', array('as' => 'tenant-selected', 'uses' => 'BillController@tenantSelected')); Route::get('refund-selected/{id}', array('as' => 'refund-selected', 'uses' => 'BillController@refundSelected')); Route::post('refund-tenant', array('as' => 'refund-tenant', 'uses' => 'BillController@refundStore')); //select unit Route::get('unit/{id}', array('as' => 'create-house', 'uses' => 'HousController@create'));