Exemplo n.º 1
0
 function _showordiva($id, $stat = 'C')
 {
     $this->rapyd->load('datagrid2');
     $grid = new DataGrid2('Lista de impuestos al valor agregado', 'ordiva');
     $grid->totalizar('montoiva');
     $grid->db->where('ordeni', $id);
     $grid->use_function('str_pad');
     $grid->order_by('id', 'desc');
     $grid->per_page = 5;
     $status = $this->datasis->dameval('SELECT status FROM ordi WHERE numero=' . $this->db->escape($id));
     $uri = $status != 'C' ? anchor('import/ordi/ordiva/' . $id . '/modify/<#id#>', '<nformat><#tasa#></nformat>%') : '<nformat><#tasa#></nformat>%';
     $grid->column('Tasa', $uri);
     $grid->column('Base Imponible', '<nformat><#base#></nformat>', 'align=\'right\'');
     $grid->column('IVA', '<nformat><#montoiva#></nformat>', 'align=\'right\'');
     $grid->column('Concepto', 'concepto');
     if ($stat != 'C') {
         $grid->add('import/ordi/ordiva/' . $id . '/create', 'Agregar IVA');
     }
     $grid->build();
     //echo $grid->db->last_query();
     if ($grid->recordCount > 0) {
         return $grid->output;
     } elseif ($stat != 'C') {
         return $grid->_button_container['TR'][0];
     } else {
         return '';
     }
 }
Exemplo n.º 2
0
 function dabonos($numero = '', $ncuota = '')
 {
     $this->rapyd->load("datagrid2");
     $grid = new DataGrid2("Lista de Detalles del Pedido {$numero} Cuota Número {$ncuota}");
     $select = array("fecha", "ndeposito", "dolar", "dmonto", "bmonto", "ncuota", "npago", "id");
     $grid->db->select($select);
     $grid->db->from("itabonos");
     $grid->db->where('numero', $numero);
     $grid->db->where('ncuota', $ncuota);
     $uri1 = anchor("ventas/carpetas/dataedit/{$numero}/{$ncuota}/modify/<#id#>", "<#npago#>");
     $grid->column("Nº Pago", $uri1);
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
     $grid->column("Deposito", "ndeposito", "align='center'");
     $grid->column("Dolar\$", "<nformat><#dolar#></nformat>", "align='right'");
     $grid->column("Monto\$", "<nformat><#dmonto#></nformat>", "align='right'");
     $grid->column("Monto Bs", "<nformat><#bmonto#></nformat>", "align=right");
     //$grid->column("Resta","<nformat><#resta#></nformat>","align=right");
     $grid->totalizar('bmonto', 'dmonto');
     $grid->add("ventas/carpetas/dataedit/{$numero}/{$ncuota}/create");
     $grid->build();
     //echo $grid->db->last_query();
     $uri = anchor("ventas/carpetas/abonos/{$numero}", "Regresar");
     $data['content'] = '<pre>' . $uri . '</pre>' . $grid->output;
     $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . phpscript('nformat.js') . $this->rapyd->get_head();
     $data['title'] = $this->rapyd->get_head() . "<h1></h1>";
     $this->load->view('view_ventanas', $data);
 }