PHP Receipt::where方法代码示例

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