PHP Invoice::scope方法代码示例

 public function edit($publicId)
 {
     $payment = Payment::scope($publicId)->firstOrFail();
     $payment->payment_date = Utils::fromSqlDate($payment->payment_date);
     $data = array('client' => null, 'invoice' => null, 'invoices' => Invoice::scope()->where('is_recurring', '=', false)->where('is_quote', '=', false)->with('client', 'invoice_status')->orderBy('invoice_number')->get(), 'payment' => $payment, 'method' => 'PUT', 'url' => 'payments/' . $publicId, 'title' => trans('texts.edit_payment'), 'paymentTypes' => Cache::get('paymentTypes'), 'clients' => Client::scope()->with('contacts')->orderBy('name')->get());
     return View::make('payments.edit', $data);
 }

 public function store()
 {
     $data = Input::all();
     $error = false;
     if (isset($data['invoice_id'])) {
         $invoice = Invoice::scope($data['invoice_id'])->with('client')->first();
         if ($invoice) {
             $data['invoice'] = $invoice->public_id;
             $data['client'] = $invoice->client->public_id;
         } else {
             $error = trans('validation.not_in', ['attribute' => 'invoice_id']);
         }
     } else {
         $error = trans('validation.not_in', ['attribute' => 'invoice_id']);
     }
     if (!isset($data['transaction_reference'])) {
         $data['transaction_reference'] = '';
     }
     if (!$error) {
         $payment = $this->paymentRepo->save($data);
         $payment = Payment::scope($payment->public_id)->with('client', 'contact', 'user', 'invoice')->first();
         $payment = Utils::remapPublicIds([$payment]);
     }
     $response = json_encode($error ?: $payment, JSON_PRETTY_PRINT);
     $headers = Utils::getApiHeaders();
     return Response::make($response, 200, $headers);
 }

 /**
  * @SWG\Post(
  *   path="/payments",
  *   summary="Create a payment",
  *   tags={"payment"},
  *   @SWG\Parameter(
  *     in="body",
  *     name="body",
  *     @SWG\Schema(ref="#/definitions/Payment")
  *   ),
  *   @SWG\Response(
  *     response=200,
  *     description="New payment",
  *      @SWG\Schema(type="object", @SWG\Items(ref="#/definitions/Payment"))
  *   ),
  *   @SWG\Response(
  *     response="default",
  *     description="an ""unexpected"" error"
  *   )
  * )
  */
 public function store()
 {
     $data = Input::all();
     $error = false;
     if (isset($data['invoice_id'])) {
         $invoice = Invoice::scope($data['invoice_id'])->with('client')->first();
         if ($invoice) {
             $data['invoice'] = $invoice->public_id;
             $data['client'] = $invoice->client->public_id;
         } else {
             $error = trans('validation.not_in', ['attribute' => 'invoice_id']);
         }
     } else {
         $error = trans('validation.not_in', ['attribute' => 'invoice_id']);
     }
     if (!isset($data['transaction_reference'])) {
         $data['transaction_reference'] = '';
     }
     if ($error) {
         return $error;
     }
     $payment = $this->paymentRepo->save($data);
     $payment = Payment::scope($payment->public_id)->with('client', 'contact', 'user', 'invoice')->first();
     $transformer = new PaymentTransformer(Auth::user()->account, Input::get('serializer'));
     $data = $this->createItem($payment, $transformer, 'payment');
     return $this->response($data);
 }

 public function index()
 {
     $invoices = Invoice::scope()->with('client', 'user')->where('invoices.is_quote', '=', true)->orderBy('created_at', 'desc')->get();
     $invoices = Utils::remapPublicIds($invoices);
     $response = json_encode($invoices, JSON_PRETTY_PRINT);
     $headers = Utils::getApiHeaders(count($invoices));
     return Response::make($response, 200, $headers);
 }

 /**
  * Get the validation rules that apply to the request.
  *
  * @return array
  */
 public function rules()
 {
     $input = $this->input();
     $invoice = Invoice::scope($input['invoice'])->invoices()->firstOrFail();
     $rules = ['client' => 'required', 'invoice' => 'required', 'amount' => "required|numeric|between:0.01,{$invoice->balance}", 'payment_date' => 'required'];
     if (!empty($input['payment_type_id']) && $input['payment_type_id'] == PAYMENT_TYPE_CREDIT) {
         $rules['payment_type_id'] = 'has_credit:' . $input['client'] . ',' . $input['amount'];
     }
     return $rules;
 }

 /**
  * Get the validation rules that apply to the request.
  *
  * @return array
  */
 public function rules()
 {
     $input = $this->input();
     $invoice = Invoice::scope($input['invoice'])->firstOrFail();
     $rules = array('client' => 'required', 'invoice' => 'required', 'amount' => "required|less_than:{$invoice->balance}|positive");
     if ($input['payment_type_id'] == PAYMENT_TYPE_CREDIT) {
         $rules['payment_type_id'] = 'has_credit:' . $input['client'] . ',' . $input['amount'];
     }
     return $rules;
 }

 /**
  * Display the specified resource.
  *
  * @param  int      $id
  * @return Response
  */
 public function show($publicId)
 {
     $client = Client::withTrashed()->scope($publicId)->with('contacts', 'size', 'industry')->firstOrFail();
     Utils::trackViewed($client->getDisplayName(), ENTITY_CLIENT);
     $actionLinks = [['label' => trans('texts.new_task'), 'url' => '/tasks/create/' . $client->public_id]];
     if (Utils::isPro()) {
         array_push($actionLinks, ['label' => trans('texts.new_quote'), 'url' => '/quotes/create/' . $client->public_id]);
     }
     array_push($actionLinks, ['label' => trans('texts.enter_payment'), 'url' => '/payments/create/' . $client->public_id], ['label' => trans('texts.enter_credit'), 'url' => '/credits/create/' . $client->public_id]);
     $data = array('actionLinks' => $actionLinks, 'showBreadcrumbs' => false, 'client' => $client, 'credit' => $client->getTotalCredit(), 'title' => trans('texts.view_client'), 'hasRecurringInvoices' => Invoice::scope()->where('is_recurring', '=', true)->whereClientId($client->id)->count() > 0, 'hasQuotes' => Invoice::scope()->where('is_quote', '=', true)->whereClientId($client->id)->count() > 0, 'hasTasks' => Task::scope()->whereClientId($client->id)->count() > 0, 'gatewayLink' => $client->getGatewayLink());
     return View::make('clients.show', $data);
 }

 public function entity()
 {
     $invoice = parent::entity();
     // support loading an invoice by its invoice number
     if ($this->invoice_number && !$invoice) {
         $invoice = Invoice::scope()->whereInvoiceNumber($this->invoice_number)->withTrashed()->firstOrFail();
     }
     // eager load the invoice items
     if ($invoice && !$invoice->relationLoaded('invoice_items')) {
         $invoice->load('invoice_items');
     }
     return $invoice;
 }

 /**
  * Get the validation rules that apply to the request.
  *
  * @return array
  */
 public function rules()
 {
     if (!$this->invoice_id || !$this->amount) {
         return ['invoice_id' => 'required', 'amount' => 'required'];
     }
     $invoice = Invoice::scope($this->invoice_id)->firstOrFail();
     $this->merge(['invoice_id' => $invoice->id, 'client_id' => $invoice->client->id]);
     $rules = array('amount' => "required|less_than:{$invoice->balance}|positive");
     if ($this->payment_type_id == PAYMENT_TYPE_CREDIT) {
         $rules['payment_type_id'] = 'has_credit:' . $invoice->client->public_id . ',' . $this->amount;
     }
     return $rules;
 }

 /**
  * Get the validation rules that apply to the request.
  *
  * @return array
  */
 public function rules()
 {
     if (!$this->invoice_id || !$this->amount) {
         return ['invoice_id' => 'required', 'amount' => 'required'];
     }
     $invoice = Invoice::scope($this->invoice_id)->invoices()->firstOrFail();
     $this->merge(['invoice_id' => $invoice->id, 'client_id' => $invoice->client->id]);
     $rules = ['amount' => "required|numeric|between:0.01,{$invoice->balance}"];
     if ($this->payment_type_id == PAYMENT_TYPE_CREDIT) {
         $rules['payment_type_id'] = 'has_credit:' . $invoice->client->public_id . ',' . $this->amount;
     }
     return $rules;
 }

 public function index($clientPublicId = false)
 {
     $invoices = Invoice::scope()->with('client', 'user')->where('invoices.is_quote', '=', true);
     if ($clientPublicId) {
         $invoices->whereHas('client', function ($query) use($clientPublicId) {
             $query->where('public_id', '=', $clientPublicId);
         });
     }
     $invoices = $invoices->orderBy('created_at', 'desc')->get();
     $invoices = Utils::remapPublicIds($invoices);
     $response = json_encode($invoices, JSON_PRETTY_PRINT);
     $headers = Utils::getApiHeaders(count($invoices));
     return Response::make($response, 200, $headers);
 }

 protected function stateInvoice()
 {
     $invoiceId = $this->stateEntity(ENTITY_INVOICE);
     if (!$invoiceId) {
         throw new Exception(trans('texts.intent_not_supported'));
     }
     $invoice = Invoice::scope($invoiceId)->first();
     if (!$invoice) {
         throw new Exception(trans('texts.intent_not_supported'));
     }
     if (!Auth::user()->can('view', $invoice)) {
         throw new Exception(trans('texts.not_allowed'));
     }
     return $invoice;
 }

 public function getErrors($input)
 {
     $rules = array('client' => 'required', 'invoice' => 'required', 'amount' => 'required');
     if ($input['payment_type_id'] == PAYMENT_TYPE_CREDIT) {
         $rules['payment_type_id'] = 'has_credit:' . $input['client'] . ',' . $input['amount'];
     }
     if (isset($input['invoice']) && $input['invoice']) {
         $invoice = Invoice::scope($input['invoice'])->firstOrFail();
         $rules['amount'] .= "|less_than:{$invoice->balance}";
     }
     $validator = \Validator::make($input, $rules);
     if ($validator->fails()) {
         return $validator;
     }
     return false;
 }

 /**
  * @SWG\Get(
  *   path="/quotes",
  *   tags={"quote"},
  *   summary="List of quotes",
  *   @SWG\Response(
  *     response=200,
  *     description="A list with quotes",
  *      @SWG\Schema(type="array", @SWG\Items(ref="#/definitions/Invoice"))
  *   ),
  *   @SWG\Response(
  *     response="default",
  *     description="an ""unexpected"" error"
  *   )
  * )
  */
 public function index()
 {
     $paginator = Invoice::scope();
     $invoices = Invoice::scope()->with('client', 'invitations', 'user', 'invoice_items')->where('invoices.is_quote', '=', true);
     if ($clientPublicId = Input::get('client_id')) {
         $filter = function ($query) use($clientPublicId) {
             $query->where('public_id', '=', $clientPublicId);
         };
         $invoices->whereHas('client', $filter);
         $paginator->whereHas('client', $filter);
     }
     $invoices = $invoices->orderBy('created_at', 'desc')->paginate();
     $transformer = new QuoteTransformer(\Auth::user()->account, Input::get('serializer'));
     $paginator = $paginator->paginate();
     $data = $this->createCollection($invoices, $transformer, 'quotes', $paginator);
     return $this->response($data);
 }

 public function index()
 {
     // total_income, billed_clients, invoice_sent and active_clients
     $select = DB::raw('COUNT(DISTINCT CASE WHEN invoices.id IS NOT NULL THEN clients.id ELSE null END) billed_clients,
                     SUM(CASE WHEN invoices.invoice_status_id >= ' . INVOICE_STATUS_SENT . ' THEN 1 ELSE 0 END) invoices_sent,
                     COUNT(DISTINCT clients.id) active_clients');
     $metrics = DB::table('accounts')->select($select)->leftJoin('clients', 'accounts.id', '=', 'clients.account_id')->leftJoin('invoices', 'clients.id', '=', 'invoices.client_id')->where('accounts.id', '=', Auth::user()->account_id)->where('clients.is_deleted', '=', false)->where('invoices.is_deleted', '=', false)->where('invoices.is_recurring', '=', false)->where('invoices.is_quote', '=', false)->groupBy('accounts.id')->first();
     $select = DB::raw('SUM(clients.paid_to_date) as value, clients.currency_id as currency_id');
     $paidToDate = DB::table('accounts')->select($select)->leftJoin('clients', 'accounts.id', '=', 'clients.account_id')->where('accounts.id', '=', Auth::user()->account_id)->where('clients.is_deleted', '=', false)->groupBy('accounts.id')->groupBy(DB::raw('CASE WHEN clients.currency_id IS NULL THEN CASE WHEN accounts.currency_id IS NULL THEN 1 ELSE accounts.currency_id END ELSE clients.currency_id END'))->get();
     $select = DB::raw('AVG(invoices.amount) as invoice_avg, clients.currency_id as currency_id');
     $averageInvoice = DB::table('accounts')->select($select)->leftJoin('clients', 'accounts.id', '=', 'clients.account_id')->leftJoin('invoices', 'clients.id', '=', 'invoices.client_id')->where('accounts.id', '=', Auth::user()->account_id)->where('clients.is_deleted', '=', false)->where('invoices.is_deleted', '=', false)->groupBy('accounts.id')->groupBy(DB::raw('CASE WHEN clients.currency_id IS NULL THEN CASE WHEN accounts.currency_id IS NULL THEN 1 ELSE accounts.currency_id END ELSE clients.currency_id END'))->get();
     $activities = Activity::where('activities.account_id', '=', Auth::user()->account_id)->where('activity_type_id', '>', 0)->orderBy('created_at', 'desc')->take(14)->get();
     $pastDue = Invoice::scope()->where('due_date', '<', date('Y-m-d'))->where('balance', '>', 0)->where('is_recurring', '=', false)->where('is_quote', '=', false)->where('is_deleted', '=', false)->orderBy('due_date', 'asc')->take(6)->get();
     $upcoming = Invoice::scope()->where('due_date', '>=', date('Y-m-d'))->where('balance', '>', 0)->where('is_recurring', '=', false)->where('is_quote', '=', false)->where('is_deleted', '=', false)->orderBy('due_date', 'asc')->take(6)->get();
     $data = ['paidToDate' => $paidToDate, 'averageInvoice' => $averageInvoice, 'invoicesSent' => $metrics ? $metrics->invoices_sent : 0, 'activeClients' => $metrics ? $metrics->active_clients : 0, 'activities' => $activities, 'pastDue' => $pastDue, 'upcoming' => $upcoming];
     return View::make('dashboard', $data);
 }