public function getInvoices() { $invoices = Invoice::where('account_id', Auth::user()->account_id)->where('branch_id', Session::get('branch_id'))->select('public_id', 'invoice_status_id', 'client_id', 'invoice_number', 'invoice_date', 'importe_total', 'branch_name')->orderBy('public_id', 'DESC')->get(); foreach ($invoices as $key => $invoice) { $invoice_razon = Client::where('account_id', Auth::user()->account_id)->select('name')->where('id', $invoice->client_id)->first(); $invoice->razon = $invoice_razon->name; $estado = InvoiceStatus::where('id', $invoice->invoice_status_id)->first(); $invoice->estado = $estado->name; $invoice->accion = "<a class='btn btn-primary btn-xs' data-task='view' href='factura/{$invoice->public_id}' style='text-decoration:none;color:white;'><i class='glyphicon glyphicon-eye-open'></i></a> <a class='btn btn-warning btn-xs' href='copia/{$invoice->public_id}' style='text-decoration:none;color:white;'><i class='glyphicon glyphicon-duplicate'></i></a>"; } $invoiceJson = ['data' => $invoices]; return Response::json($invoiceJson); }
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); }