public function getArticulosExternos($oc) { //Obtener No. de Requisición a partir de OC $oc = Oc::whereOc($oc)->get(array('req')); $arr_req = $oc->lists('req'); $req = $arr_req[0]; $articulos = DB::connection('sgf14')->table('tbl_req_art')->leftJoin('tbl_articulos', 'tbl_articulos.art_id', '=', 'tbl_req_art.art_id')->where('req', '=', $req)->get(array('art_count', 'art', 'esp', 'cantidad', 'costo', 'impuesto', 'monto', 'unidad')); return $articulos; }
public function formato($id) { $salida = Salida::find($id); $entrada = Entrada::find($salida->entrada_id); if ($entrada->ref_tipo == 'OC') { $oc = Oc::whereOc($entrada->ref)->get(); } $articulos = SalidaArticulo::whereSalidaId($id)->get(); $artEntrada = EntradaArticulo::whereEntradaId($salida->entrada_id)->get(array('costo', 'impuesto')); $data['tipo_formato'] = 'Salida'; $data['req'] = $oc[0]->req; $data['ref_tipo'] = $entrada->ref_tipo; $data['ref'] = $entrada->ref; $data['fecha_oc'] = $oc[0]->fecha_oc; $data['d_proveedor'] = $entrada->proveedor->d_proveedor; $data['id'] = $id; $data['fecha'] = $salida->fecha_salida; $data['d_urg'] = $entrada->urg->d_urg; $data['cmt'] = $salida->cmt; $data['usr_id'] = $entrada->usr_id; $sum_total = 0; $fpdf = new EntradaSalidaPdf($data); $fpdf->AddPage(); //Artículos $fpdf->SetFont('Arial', '', 10); $fpdf->Cell(20, 5, utf8_decode('Código'), 'TB', 0, 'C'); $fpdf->Cell(90, 5, utf8_decode('Descripción'), 'TB', 0, 'C'); $fpdf->Cell(20, 5, 'Cantidad', 'TB', 0, 'C'); $fpdf->Cell(30, 5, 'Precio Unitario', 'TB', 0, 'C'); $fpdf->Cell(30, 5, 'Total', 'TB', 1, 'C'); foreach ($articulos as $art) { $i = 0; $y_inicial = $fpdf->GetY(); $fpdf->SetX(30); $fpdf->MultiCell(90, 4, utf8_decode($art->articulo->articulo), 0, 'L'); $y_final = $fpdf->GetY(); $h_renglon = $y_final - $y_inicial; $fpdf->SetY($y_inicial); $fpdf->Cell(20, $h_renglon, $art->id, 0, 0, 'C'); $fpdf->SetXY(120, $y_inicial); $fpdf->Cell(20, $h_renglon, number_format($art->cantidad), 0, 0, 'C'); $fpdf->Cell(30, $h_renglon, number_format($artEntrada[$i]->costo, 2), 0, 0, 'C'); $fpdf->Cell(30, $h_renglon, number_format($artEntrada[$i]->costo * $art->cantidad, 2), 0, 2, 'R'); $sum_total += $artEntrada[$i]->costo * $art->cantidad; $i++; } $fpdf->Cell(30, 5, number_format($sum_total, 2), 'T', 2, 'R'); return View::make($fpdf->Output()); }