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 ''; } }
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); }