/** * Modify item to invoice */ public function modify($id) { $invoice = Invoice::find($id); foreach ($invoice->items as $item) { InvoiceItem::where('id', $item->id)->update(array('ressource_id' => Input::get('ressource_id.' . $item->id), 'text' => Input::get('text.' . $item->id), 'amount' => Input::get('amount.' . $item->id), 'vat_types_id' => Input::get('vat_types_id.' . $item->id), 'order_index' => Input::get('order_index.' . $item->id))); } // Add new line if (Input::get('text.0')) { $this->add_check(array('invoice_id' => $id, 'ressource_id' => Input::get('ressource_id.0'), 'text' => Input::get('text.0'), 'amount' => Input::get('amount.0'), 'vat_types_id' => Input::get('vat_types_id.0'), 'order_index' => Input::get('order_index.0'))); } return Redirect::route('invoice_modify', $id); }
public static function getActiveSubscriptionInfos() { $params = array(); $active_subscription = InvoiceItem::where('ressource_id', Ressource::TYPE_COWORKING)->where('invoices.user_id', Auth::user()->id)->where('subscription_from', '<', date('Y-m-d'))->where('subscription_to', '>', date('Y-m-d'))->join('invoices', function ($j) { $j->on('invoice_id', '=', 'invoices.id')->where('type', '=', 'F'); })->first(); $params['active_subscription'] = $active_subscription; if ($active_subscription) { $params['subscription_used'] = PastTime::recap(Auth::user()->id, $active_subscription->subscription_from, $active_subscription->subscription_to, Ressource::TYPE_COWORKING, false)->first(); } else { $params['subscription_used'] = array('hours' => 0, 'minutes' => 0); } if ($active_subscription && $params['subscription_used']) { $params['subscription_ratio'] = round(100 * ($params['subscription_used']->hours + $params['subscription_used']->minutes / 60) / $active_subscription->subscription_hours_quota); } else { $params['subscription_ratio'] = 0; } return $params; }
public function copia($id) { $invoice = Invoice::where('id', $id)->first(array('id', 'account_name', 'account_nit', 'account_uniper', 'account_uniper', 'address1', 'address2', 'terms', 'importe_neto', 'importe_total', 'branch_name', 'city', 'client_id', 'client_name', 'client_nit', 'control_code', 'deadline', 'discount', 'economic_activity', 'end_date', 'invoice_date', 'invoice_status_id', 'invoice_number', 'number_autho', 'phone', 'public_notes', 'qr', 'logo', 'public_id', 'note', 'sfc', 'type_third', 'branch_id', 'state', 'law', 'phone', 'javascript')); $account = Account::find(Auth::user()->account_id); //return $invoice['id']; $products = InvoiceItem::where('invoice_id', $invoice->id)->get(); $invoice['invoice_items'] = $products; $invoice['third'] = $invoice->type_third; $invoice['is_uniper'] = $account->is_uniper; $invoice['uniper'] = $account->uniper; $invoice['logo'] = $invoice->getLogo(); $client_id = $invoice->getClient(); $client = DB::table('clients')->where('id', '=', $client_id)->first(); $contacts = Contact::where('client_id', $client->id)->get(array('id', 'is_primary', 'first_name', 'last_name', 'email')); $status = InvoiceStatus::where('id', $invoice->invoice_status_id)->first(); //echo $client_id; //print_r($contacts); // return 0; if ($invoice->note == "") { $nota = []; } else { $nota = json_decode($invoice['note']); } $data = array('invoice' => $invoice, 'account' => $account, 'products' => $products, 'contacts' => $contacts, 'nota' => $nota, 'copia' => 1, 'matriz' => Branch::scope(1)->first(), 'status' => $status->name == "Parcial" ? "Parcialmente Pagado" : $status->name); // return Response::json($data); return View::make('factura.show', $data); }
/** * Delete a quotation */ public function delete($id) { if (InvoiceItem::where('invoice_id', '=', $id)->delete()) { if (Invoice::destroy($id)) { return Redirect::route('invoice_list')->with('mSuccess', 'Le devis a bien été supprimé'); } else { return Redirect::route('invoice_modify', $id)->with('mError', 'Impossible de supprimer ce devis'); } } else { return Redirect::route('invoice_modify', $id)->with('mError', 'Impossible de supprimer ce devis'); } }