function imprimir() { $this->rapyd->load("dataform"); $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cliente'), 'titulo' => 'Buscar Cliente'); $cboton = $this->datasis->modbus($scli); $filter = new DataForm('/tiketimp/index'); $filter->title('Filtro de Impresion de Tiket'); $filter->fechad = new dateonlyField("Desde", "fechad", 'Ymd'); $filter->fechah = new dateonlyField("Hasta", "fechah", 'Ymd'); $filter->fechad->clause = $filter->fechah->clause = "where"; $filter->fechad->db_name = $filter->fechah->db_name = "fecha"; //$filter->fechad->insertValue = $fechad; //$filter->fechah->insertValue = $fechah; $filter->fechah->size = $filter->fechad->size = 10; $filter->fechad->operator = ">="; $filter->fechah->operator = "<="; $filter->cliente = new inputField("Cliente", "cliente"); $filter->cliente->size = 10; //$filter->cliente->insertValue=$cliente; $filter->cliente->maxlength = 10; $filter->cliente->append($cboton); $filter->button("btnsubmit", "Buscar", form2uri(site_url("/formatos/ver/TIKET/"), array('cliente', 'fechad', 'fechah')), $position = "BL"); // $filter->build_form(); $data['content'] = $filter->output; $data['title'] = "<h1>Imprimir</h1>"; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $mSCLId = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cod_cli'), 'titulo' => 'Buscar Cliente'); $bsclid = $this->datasis->modbus($mSCLId); $this->rapyd->load("datafilter", "datagrid"); $filter = new DataForm("ventas/cobrocli/index/process"); $filter->cliente = new inputField("Cliente", "cod_cli"); $filter->cliente->rule = "required"; $filter->cliente->append($bsclid); $filter->cliente->size = 10; $filter->caja = new inputField("Caja", "caja"); $filter->caja->rule = "required"; $filter->caja->group = "Selección de caja"; $filter->caja->size = 4; /*$filter->clave= new inputField("Clave", "clave"); $filter->clave->rule = "required"; $filter->clave->group = "Selección de caja"; $filter->clave->type = "password"; $filter->clave->size =4;*/ $filter->submit("btnsubmit", "aceptar"); $filter->build_form(); if ($filter->on_success()) { } $data['content'] = $filter->output; $data['title'] = "<h1>Cobro a clientes</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function busca() { $this->rapyd->load("dataform"); $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->p_modbus($mBANC, "banc"); $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario'); $bSPRV = $this->datasis->p_modbus($mSPRV, "sprv"); $filter = new DataForm($this->url . "busca/process"); $filter->cod_prov = new inputField("Proveedor", "cod_prov"); $filter->cod_prov->rule = 'required'; $filter->cod_prov->size = 5; $filter->cod_prov->append($bSPRV); $filter->codbanc = new inputField("Banco", 'codbanc'); $filter->codbanc->size = 5; $filter->codbanc->rule = "required"; $filter->codbanc->append($bBANC); $filter->submit("btnsubmit", "Buscar"); $filter->build_form(); //exit('============='); if ($filter->on_success()) { $cod_prov = $filter->cod_prov->newValue; $codbanc = $filter->codbanc->newValue; redirect($this->url . "selecciona/" . raencode($cod_prov) . "/" . raencode($codbanc)); } $data['content'] = $filter->output; $data['title'] = "Pago de Deducciones de nómina"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function wol() { if (!extension_loaded('sockets')) { show_error('La extension "sockets" no esta cargada, debe cargarla para poder usar estas opciones'); } $this->load->library('rapyd'); $this->rapyd->load('dataform'); $form = new DataForm('supervisor/monitoreo/wol/process'); $form->mac = new inputField('Dirección MAC', 'mac'); $form->mac->append('Ejemplo: 00:01:02:03:04:05'); $form->mac->rule = 'required|mac'; $form->mac->maxlength = 17; $form->mac->size = 20; $form->submit('btnsubmit', 'Enviar'); $form->build_form(); if ($form->on_success()) { $mac = $form->mac->newValue; $rt = $this->_wol($mac); if (!$rt) { $form->error_string = $this->error; $form->build_form(); $salida = $form->output . br(); } else { $salida = $form->output . br() . 'Señal enviada satisfactoriamente'; } } else { $salida = $form->output; } $this->rapyd->jquery[] = '$(".inputnum").numeric(".");'; $data['content'] = $salida; $data['title'] = heading('Envio de señal de encendido por LAN'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function carga() { $this->rapyd->load("dataform"); $form = new DataForm("sincro/cargasinv/carga/procesa"); $form->title('Cargar Archivo de Productos (*.txt)'); $form->archivo = new uploadField("Archivo", "archivo1"); $form->archivo->upload_path = $this->upload_path; $form->archivo->allowed_types = "TXT"; $form->archivo->delete_file = false; $form->archivo->rule = "required"; $form->archivo->file_name = 'precios.txt'; $form->submit("btnsubmit", "Cargar"); $form->build_form(); if ($form->on_success()) { set_time_limit(600); $nombre = $form->archivo->upload_data['file_name']; $dir = './uploads/archivos/' . $nombre; $msg = 'Carga Éxitosa'; redirect("sincro/cargasinv/procesa/{$nombre}"); //$this->procesa(); } $data['content'] = $form->output; $data['title'] = "<h1>Actualización de Inventario</h1>"; $data["head"] = script("jquery.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load("dataform", "datagrid"); $modbus = array('tabla' => 'usuario', 'columnas' => array('us_codigo' => 'Código', 'us_nombre' => 'Nombre'), 'filtro' => array('us_nombre' => 'nombre'), 'retornar' => array('us_codigo' => 'usuario'), 'titulo' => 'Buscar Usuario'); $filter = new DataForm('/supervisor/trabajo/filteredgrid/search/osp'); $filter->mes = new dateonlyField("Mes", "mes", 'm/Y'); $filter->mes->clause = "where"; $filter->mes->operator = "="; $filter->mes->size = 8; $filter->mes->dbformat = 'Ym'; $filter->mes->insertValue = date("Y-m-d"); $filter->usuario = new inputField("Código de usuario", "usuario"); $filter->usuario->size = 11; $filter->usuario->append($this->datasis->modbus($modbus)); $filter->submit('manda', 'Buscar'); $filter->build_form(); /* $mSQL="(SELECT fecha, count(*) AS cant FROM bitacora WHERE usuario='DAVID' GROUP BY fecha ) UNION (SELECT a.fecha, 0 AS cant FROM dim_tiempo AS a LEFT JOIN bitacora as b ON a.fecha=b.fecha AND b.usuario='DAVID' WHERE a.fecha BETWEEN (SELECT MIN(fecha) FROM bitacora) AND (SELECT MAX(fecha) FROM bitacora) AND b.fecha IS NULL) ORDER BY fecha"; */ $content = ''; if ($this->input->post('manda')) { $usr = $this->input->post('usuario') ? ' AND b.usuario="' . $this->input->post('usuario') . '"' : ''; $fechad = '(SELECT MIN(fecha) FROM bitacora)'; $fechah = '(SELECT MAX(fecha) FROM bitacora)'; if ($this->input->post('mes')) { $acum = explode('/', $filter->mes->value); $fechad = $acum[1] . $acum[0] . '01'; $fechah = $acum[1] . $acum[0] . '31'; } $mSQL = "SELECT a.fecha, semana FROM dim_tiempo AS a LEFT JOIN bitacora as b ON a.fecha=b.fecha {$usr} WHERE a.fecha BETWEEN {$fechad} AND {$fechah} AND b.fecha IS NULL"; //echo $mSQL; $sema = array('Lunes', 'Martes', 'Miercoles', 'Jueves', 'Viernes', 'Sabado', 'Domingo'); $query = $this->db->query($mSQL); $data = array(); foreach ($query->result() as $row) { $pasa = array(); $pasa['fecha'] = $row->fecha; if ($row->semana > 5) { $pasa['cant'] = $sema[$row->semana - 1]; } else { $pasa['cant'] = '<b>' . $sema[$row->semana - 1] . '</b>'; } $data[] = $pasa; } $query->free_result(); //grid $grid = new DataGrid("Lista de Bitacora", $data); $grid->per_page = 31; $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>"); $grid->column("Semana", "<#cant#>"); $grid->build(); $content = $grid->output; } $data['content'] = $filter->output . $content; $data["head"] = $this->rapyd->get_head(); $data['title'] = ' Dias NO trabajados '; $this->load->view('view_ventanas', $data); }
function cargazip() { set_time_limit(600); $this->rapyd->load('dataform'); $this->load->library('Sqlinex'); $form = new DataForm("cargasarch/cargazip/process"); $form->upl = new uploadField("Archivo Zip", "arch"); $form->upl->upload_path = $this->dir; $form->upl->max_size = 6000; $form->upl->allowed_types = "zip"; $form->submit("btnsubmit", "Cargar"); $form->build_form(); $msg = ''; if ($form->on_success()) { $nombre = $form->upl->upload_data['file_name']; $rt = $this->_cargazip($nombre); if (!empty($rt)) { $form->error_string = $rt; $form->build_form(); } else { $msg = '<p>Carga completada</p>'; } } $data['content'] = $form->output . $msg; $data['title'] = '<h1>Cargas de Zip</h1>'; $data['script'] = ''; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load("dataform"); $this->load->helper('openflash'); if ($this->uri->segment(4)) { $anio = $this->uri->segment(4); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($anio)) { $anio = date("Y"); } $filter = new DataForm('ventas/vendedoresanuales'); $filter->title('Filtro de Ventas Anuales'); $filter->anio = new inputField("Año", "anio"); $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->rule = "max_length[4]"; $filter->button("btnsubmit", "Buscar", form2uri(site_url('ventas/vendedoresanuales /index'), array('anio')), $position = "BL"); $filter->build_form(); $grafico = open_flash_chart_object(760, 300, site_url("ventas/vendedoresanuales/grafico/{$anio}/")); $data['content'] = $grafico; $data['content'] .= $filter->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = $this->rapyd->get_head() . "<h1>Ventas</h1>"; $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load('dataform'); $this->load->helper('openflash'); $dolar = $this->datasis->dameval("SELECT valor FROM valores WHERE nombre='dolar'"); $filter = new DataForm("inventario/cambioprecio/consulta/"); $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;"); $filter->title('¿Desea cambiar el precio de sus artículos en el inventario según el precio del dólar?'); $filter->dolar = new inputField("Precio del Dólar", "dolar"); $filter->dolar->size = 12; $filter->dolar->maxlength = 10; $filter->dolar->insertValue = $dolar; $filter->desc2 = new inputField("Descuento Precio2", "desc2"); $filter->desc2->size = 12; $filter->desc2->maxlength = 10; $filter->desc2->insertValue = '3'; $filter->desc3 = new inputField("Descuento Precio3", "desc3"); $filter->desc3->size = 12; $filter->desc3->maxlength = 10; $filter->desc3->insertValue = '5'; $filter->desc4 = new inputField("Descuento Precio4", "desc4"); $filter->desc4->size = 12; $filter->desc4->maxlength = 10; $filter->desc4->insertValue = '7'; $filter->button("btnsubmit", "Aceptar", form2uri(site_url('inventario/cambioprecio/cambio'), array('dolar', 'desc2', 'desc3', 'desc4')), $position = "BL"); $filter->build_form(); $data['content'] = $filter->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = "<h1>Cambio de Precio</h1>"; $this->load->view('view_ventanas', $data); }
function index() { $this->datasis->modulo_id($this->modulo, 1); $this->rapyd->load("datagrid", "dataform", "fields"); $control = $this->uri->segment(4); $checkbox = '<input type="checkbox" name="genera[]" value="<#modulo#>" CHECKED>'; $grid = new DataGrid('Seleccione los módulos que desea generar'); $grid->db->select('modulo, descripcion'); $grid->db->from('`reglascont`'); $grid->db->groupby('modulo'); $grid->db->orderby('modulo,regla'); $grid->column("Módulo", "modulo"); $grid->column("Descripción", "descripcion"); $grid->column('Generar', $checkbox, 'align="center"'); $grid->build(); $form = new DataForm('contabilidad/generar/procesar'); $form->title('Rango de fecha para la Generación'); $form->fechai = new dateonlyField("Fecha Desde", "fechai", "d/m/Y"); $form->fechaf = new dateonlyField("Fecha Hasta", "fechaf", "d/m/Y"); $form->fechaf->size = $form->fechai->size = 10; $form->fechai->insertValue = $this->input->post('fechai') ? $this->input->post('fechai') : date("Ymd"); $form->fechaf->insertValue = $this->input->post('fechaf') ? $this->input->post('fechaf') : date("Ymd"); $form->tabla = new containerField('tabla', $grid->output); if ($control) { $form->control = new containerField('control', 'Contabilidad Generada'); } //$form->submit("btn_submit","Generar Depurado"); $form->build_form(); $data['script'] = "<script type='text/javascript'>\n\t\tvar handlerFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert(t.responseText);\n\t\t}\n\n\t\tvar errFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert('Error ' + t.status + ' -- ' + t.statusText);\n\t\t}\n\n\t\tfunction generar() {\n\t\t\tnew Effect.toggle('preloader', 'appear');\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:1.0, to:0.3});\n\t\t\tnew Ajax.Request('" . site_url('contabilidad/generar/procesar') . "',{\n\t\t\t method: 'post',\n\t\t\t parameters : Form.serialize('df1'),\n\t\t\t onSuccess:handlerFunc,\n\t\t\t onFailure:errFunc});\n\t\t}\n\t\t</script>"; $data['extras'] = "<div id='preloader' style='display: none;\tposition:absolute; left:40%; top:40%; font-family:Verdana, Arial, Helvetica, sans-serif;'>\n\t\t\t<center>" . image("loading4.gif") . "<br>" . image("loadingBarra.gif") . "<br>\n\t\t\t<b>Generando . . . </b>\n\t\t\t</center>\n\t\t</div>"; $data['content'] = $form->output . "<input type=button value='Generar' onclick='generar()'>"; $data["head"] = $this->rapyd->get_head() . script("prototype.js") . script("scriptaculous.js") . script("effects.js"); $data['title'] = "<h1>Generar Contabilidad</h1>"; $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load('dataform', 'datagrid'); $form = new DataForm("supermercado/cupones/index/process"); $form->fecha = new dateonlyField("Fecha", "fecha", 'd/m/Y'); $form->fecha->insertValue = date("Y-m-d"); $form->fecha->size = 11; $form->fecha->rule = "required"; $form->fecha->maxlength = 11; $form->fecha->rule = "trim"; /*$form->monto= new inputField("Monto por cupon", "monto"); $form->monto->size = 15; $form->monto->rule = "required"; $form->monto->insertValue = $this->datasis->traevalor('FMAYCUPON'); */ $form->caja = new dropdownField("Caja", "ipcaj"); $form->caja->rule = "required"; $form->caja->options("SELECT caja AS value, caja FROM caja ORDER BY caja"); $form->submit("reset", "Resetear"); $form->submit("btnsubmit", "Buscar"); $form->build_form(); $ggri = ''; if ($form->on_success()) { $mSQL = "SELECT caja,cliente, gtotal,numero FROM viefac WHERE fecha={$form->fecha->newValue} AND caja='{$form->caja->newValue}'"; //echo $mSQL; $query = $this->db->query($mSQL); $cupones = 0; $facturas = array(); if ($query->num_rows() > 0) { foreach ($query->result() as $row) { if (array_key_exists($row->numero, $facturas)) { $facturas[$row->numero] += $row->gtotal; } else { $facturas[$row->numero] = $row->gtotal; } /*$pivocli=''; $monto=0; foreach ($query->result() as $row){ if ($pivocli!=$row->cliente){ $cupones+=floor($monto/$form->monto->newValue); $pivocli=$row->cliente; $monto=0; } $monto+=$row->gtotal; }*/ } } $monto = $this->datasis->traevalor('FMAYCUPON'); foreach ($facturas as $key => $value) { $cupones += round($facturas[$key] / $monto, 0); } $ggri = "Fueron entregados <b>{$cupones}</b> cupones"; } $data['content'] = $form->output . $ggri; $data['title'] = "<h1>Tikes repartidos</h1>"; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('dataform', 'datagrid'); $this->load->library('encrypt'); $filter = new DataForm('ejecutasql/filteredgrid/process'); $filter->sql = new textareaField('', 'sql'); $filter->sql->cols = 90; $filter->sql->rows = 9; $filter->sql->rule = 'required'; $filter->submit('btnsubmit', 'Ejecutar'); $filter->build_form(); $salida = ''; if ($filter->on_success()) { $data = array(); $mSQL = $filter->sql->value; $link = @mysql_connect($this->db->hostname, $this->db->username, $this->db->password) or die('Error de coneccion'); mysql_select_db($this->db->database, $link) or die('Base de datos no seleccionable'); $result = mysql_query($mSQL, $link); if (!$result) { $salida = mysql_errno($link) . ": " . mysql_error($link); } else { if (is_resource($result)) { $num_rows = mysql_num_rows($result); $afectados = 0; } elseif (is_bool($result)) { $num_rows = 0; $afectados = mysql_affected_rows(); } else { $num_rows = 0; $afectados = 0; } if ($num_rows > 0) { $colunas = mysql_num_fields($result); while ($row = mysql_fetch_assoc($result)) { $data[] = $row; } $grid = new DataGrid("Filas : {$num_rows}, Columnas : {$colunas} ,Afectados :{$afectados}", $data); $grid->per_page = 100000; foreach ($data[0] as $campos => $value) { $grid->column($campos, $campos); } $grid->build(); $salida = $grid->output; if (stristr($mSQL, 'SELECT')) { $mSQL2 = $this->encrypt->encode($mSQL); $salida .= "<form action='/../../proteoerp/xlsauto/repoauto2/'; method='post'>\n \t\t\t\t\t\t<input size='100' type='hidden' name='mSQL' value='{$mSQL2}'>\n \t\t\t\t\t\t<input type='submit' value='Descargar a Excel' name='boton'/>\n \t\t\t\t\t\t</form>"; } } elseif ($afectados > 0) { $salida = "Filas afectadas {$afectados}"; } else { $salida = 'Esta consulta no genero resultados'; } } } $data['content'] = $filter->output . $salida; $data['title'] = heading('Consulta SQL'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function mensuales($anio = '', $mes = '') { $this->rapyd->load("datagrid2"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); if ($this->uri->segment(4)) { $mes = $this->uri->segment(4); } elseif (isset($_POST['mes'])) { $mes = $_POST['mes']; } if ($this->uri->segment(5)) { $anio = $this->uri->segment(5); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($mes)) { $mes = date("m"); } if (empty($anio)) { $anio = date("Y"); } $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01'; $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31'; $filter = new DataForm('nomina/gprestamos/mensuales'); $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;"); $filter->title('Filtro de Prestamos mensuales'); $filter->mes = new dropdownField("Mes/Año", "mes"); for ($i = 1; $i < 13; $i++) { $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT)); } $filter->mes->size = 2; $filter->mes->style = ''; $filter->mes->insertValue = $mes; $filter->anio = new inputField("Año", "anio"); $filter->anio->in = 'mes'; $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->maxlength = 4; $filter->button("btnsubmit", "Buscar", form2uri(site_url('nomina/gprestamos/mensuales/'), array('mes', 'anio')), $position = "BL"); $filter->build_form(); $grid = new DataGrid2(); $select = array("fecha", "DAYOFMONTH(fecha)AS dia", "SUM(monto)AS grantotal", "COUNT(*) AS numfac"); $grid->db->select($select); $grid->db->from("pres "); $grid->db->where('fecha >= ', $fechai); $grid->db->where('fecha <= ', $fechaf); $grid->db->groupby("fecha"); $grid->column("Dia", "dia", "align='left'"); $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right'); $grid->column("Cant. Prest", "numfac", 'align=right'); $grid->totalizar('grantotal'); $grid->build(); $grafico = open_flash_chart_object(680, 350, site_url("nomina/gprestamos/gmensuales/{$mes}/{$anio}")); $data['content'] = $grafico; $data['content'] .= $filter->output . $grid->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = $this->rapyd->get_head() . " Prestamos Mensuales "; $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load('datagrid2'); $this->rapyd->load('datafilter'); $diai = $this->uri->segment(4); $mesi = $this->uri->segment(5); $anoi = $this->uri->segment(6); if ($diai === FALSE or $mesi === FALSE or $anoi === FALSE) { $fechai = date('Y/m/d'); $qfechai = date('Ymd'); } else { $fechai = "{$anoi}/{$mesi}/{$diai}"; $qfechai = $anoi . $mesi . $diai; } $filter = new DataForm('supermercado/poscuadre/index'); $filter->title('Filtro de cajas'); $filter->fechai = new dateField("Fecha", "fechai", "d/m/Y"); $filter->fechai->insertValue = $fechai; $filter->fechai->size = 10; $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/poscuadre/index'), 'fechai'), $position = "BL"); $filter->build_form(); $grid = new DataGrid2(); $select = array('a.caja caja', "IFNULL(b.nombre,'N/A') nombre", 'a.cajero AS cajero', 'SUM(a.gtotal) AS monto'); $cupon = floatval($this->datasis->traevalor('FMAYCUPON')); if ($cupon > 0) { $select[] = "SUM(TRUNCATE(a.gtotal/{$cupon},0)) AS cupones"; } else { $select[] = '(0) AS cupones'; } $grid->db->select($select); $grid->db->from('posfact AS a'); $grid->db->where('SUBSTRING(numero,1,1)!=', 'X'); $grid->db->where('fecha', $qfechai); $grid->db->join('scaj b', 'a.cajero=b.cajero', 'LEFT'); $grid->db->groupby('a.caja,a.cajero'); $link = anchor("supermercado/poscuadre/concaja/<#caja#>/<#cajero#>/{$qfechai}", '<#caja#>'); $grid->column('Caja', $link); $grid->column('Nombre', 'nombre'); $grid->column('Cajero', 'cajero', 'align="center"'); $grid->column('Cupones', 'cupones', 'align="center"'); $grid->column('Monto', '<nformat><#monto#></nformat>', 'align="right"'); $grid->totalizar('monto'); $grid->build(); //echo $grid->db->last_query(); $consul = new DataForm('supermercado/buscafac/index/search/osp'); $consul->title('Buscar Factura'); $consul->fechad = new dateField("Desde", "fechad", "d/m/Y"); $consul->fechah = new dateField("Hasta", "fechah", "d/m/Y"); $consul->nombre = new inputField("Nombre", "nombre"); $consul->cedula = new inputField("Cédula/RIF", "cedula"); $consul->fechad->insertValue = $consul->fechah->insertValue = date("Y/m/d"); $consul->fechah->size = $consul->fechad->size = 10; $consul->submit("btn_submit", "Buscar"); $consul->build_form(); $data['content'] = $filter->output . $grid->output . $consul->output; $data['title'] = '<h1>Consulta de Cajas</h1>'; $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
/** * Must return a DataForm object that will be used to draw a configuration form for this module. * @return DataForm object */ public static function GetConfigurationForm() { $Form = new DataForm(); $Form->AppendField(new DataFormField("ServerHost", FORM_FIELD_TYPE::TEXT, "API hostname", 1)); $Form->AppendField(new DataFormField("Login", FORM_FIELD_TYPE::TEXT, "Reseller Login", 1)); $Form->AppendField(new DataFormField("Password", FORM_FIELD_TYPE::TEXT, "Reseller Password", 1)); return $Form; }
function index() { $this->rapyd->load('dataform', 'datatable', 'datagrid'); $this->load->library('table'); $base_process_uri = $this->rapyd->uri->implode_uri("base_uri", "gfid", "orderby"); $filter = new DataForm($this->rapyd->uri->add_clause($base_process_uri, "search")); $filter->title('Elija una tabla'); $filter->attributes = array('onsubmit' => 'is_loaded()'); $filter->tabla = new dropdownField("Tabla", "tabla"); $filter->tabla->option("pers", "Personal"); $filter->tabla->option("nomina", "Nomina"); $filter->tabla->option("sprv", "Proveedores"); $filter->tabla->option("abonotros", "Abono Otros"); $filter->tabla->clause = ""; //$filter->obra = new dropdownField("Obra", "depto"); //$filter->obra->db_name='depto'; //$filter->obra->clause="where"; //$filter->obra->option(" ","Todos"); //$filter->obra->options("SELECT depto, descrip FROM dpto ORDER BY depto "); //$filter->obra->operator="="; //$filter->status = new dropdownField("Status","status"); //$filter->status->option("","Todos"); //$filter->status->option("A","Activos"); //$filter->status->option("I","Inactivos"); //$filter->status->style='width:100px'; $filter->submit('btnsubmit', 'Descargar'); $filter->build_form(); if ($this->rapyd->uri->is_set("search")) { $table = $filter->tabla->newValue; $mSQL = "DESCRIBE {$table}"; $query = $this->db->query($mSQL); if ($query->num_rows() > 0) { foreach ($query->result_array() as $row) { $data[] = $row; } } function ractivo($field) { $data2 = array('name' => 'campos[]', 'id' => 'c' . $field, 'value' => $field, 'checked' => FALSE, 'style' => 'margin:5px'); $retorna = form_checkbox($data2); return $retorna; } $grid = new DataGrid("Resultados", $data); $grid->use_function('ractivo', 'ucwords'); $grid->column('Campos', '<ucwords><#Field#></ucwords>'); $grid->column('Mostrar', "<ractivo><#Field#></ractivo>", 'align="center"'); $grid->build(); $tabla = $grid->output; $filter->build_form(); $conten = $filter->output . form_open("nomina/rpers/crear/{$table}") . $tabla . form_submit('mysubmit', 'Generar') . form_close(); } else { $conten = $filter->output; } $data['content'] = $conten; $data['title'] = heading('Reporte'); $data["head"] = script("jquery.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
public function deleteAction() { $form = new DataForm(); if ($form->isValidForDelete()) { $data = Data::findOrFail(Input::get("id")); $data->delete(); } return Redirect::route($this->routeIndex); }
function mensuales($anio = '', $mes = '') { $this->rapyd->load("datagrid2"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); if (isset($_POST['anio']) and empty($anio)) { $anio = $_POST['anio']; } if (isset($_POST['mes']) and empty($mes)) { $mes = $_POST['mes']; } if (empty($mes)) { redirect("compras/gcompras/anuales/{$anio}"); } $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01'; $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31'; $filter = new DataForm('compras/gcompras/mensuales'); $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;"); $filter->title('Filtro de Compras Mensuales'); $filter->mes = new dropdownField("Mes/Año", "mes"); for ($i = 1; $i < 13; $i++) { $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT)); } $filter->mes->size = 2; $filter->mes->style = ''; $filter->mes->insertValue = $mes; $filter->anio = new inputField("Año", "anio"); $filter->anio->in = 'mes'; $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->maxlength = 4; $filter->button("btnsubmit", "Buscar", form2uri(site_url('compras/gcompras/mensuales'), array('anio', 'mes')), $position = "BL"); $filter->build_form(); $grid = new DataGrid2(); $select = array("fecha", "DAYOFMONTH(fecha) as dia", "SUM(montonet*IF(tipo_doc='D', -1, 1)) AS grantotal", "SUM(credito*IF(tipo_doc='D', -1, 1)) as contado", "SUM(inicial*IF(tipo_doc='D', -1, 1)) as credito", "SUM(montotot*IF(tipo_doc='D',-1,1))AS subtotal", "SUM(montoiva*IF(tipo_doc='D',-1,1))AS impuesto", "COUNT(*) AS numfac"); $grid->db->select($select); $grid->db->from("scst"); $grid->db->where("tipo_doc <> ", 'X'); $grid->db->where('fecha >= ', $fechai); $grid->db->where('fecha <= ', $fechaf); $grid->db->groupby("fecha"); $grid->column("Dia", "dia"); $grid->column("Sub-Total", "<number_format><#subtotal#>|2</number_format>", 'align=right'); $grid->column("Impuesto", "<number_format><#impuesto#>|2</number_format>", 'align=right'); $grid->column("Total", "<number_format><#grantotal#>|2</number_format>", 'align=right'); $grid->column("Contado", "<number_format><#contado#>|2</number_format>", 'align=right'); $grid->column("Credito", "<number_format><#credito#>|2</number_format>", 'align=right'); $grid->column("Número", "numfac", 'align=right'); $grid->totalizar('impuesto', 'grantotal', 'contado', 'credito', 'subtotal'); $grid->build(); $grafico = open_flash_chart_object(680, 350, site_url("compras/gcompras/gmensuales/{$anio}/{$mes}")); $data['content'] = $grafico; $data['content'] .= $filter->output . $grid->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = $this->rapyd->get_head() . "<h1>Compras Mensuales</h1>"; $this->load->view('view_ventanas', $data); }
public function __construct(DataForm $ConnectionConfig) { if (!$ConnectionConfig instanceof DataForm) { throw new Exception(_("ConnectionConfig must be an instance of DataForm")); } foreach ($ConnectionConfig->ListFields() as $field) { $this->{$field->Name} = $field->Value; } }
function index() { $this->rapyd->load("datagrid2"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); if ($this->uri->segment(4)) { $anio = $this->uri->segment(4); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($anio)) { $anio = date("Y"); } $fechai = $anio . '0101'; $fechaf = $anio . '1231'; $filter = new DataForm('hospitalidad/anuales'); $filter->title('Filtro de ventas Anuales'); $filter->anio = new inputField("Año", "anio"); $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->maxlength = 4; //$filter->anio->onkeypress="return acceptNum(event)"; $filter->button("btnsubmit", "Buscar", form2uri(site_url('hospitalidad/anuales/index'), array('anio')), $position = "BL"); $filter->build_form(); $data = $this->_sincrodata($fechai, $fechaf); $grid = new DataGrid2('', $data); $grid->totalizar('impuesto', 'cobrado', 'contado', 'credito', 'subtotal', 'numfac'); $grid->column("Mes", "mes"); $grid->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right'); $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right'); $grid->column("Contado", "<number_format><#contado#>|2|,|.</number_format>", 'align=right'); $grid->column("Credito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right'); $grid->column("Cobrado", "<number_format><#cobrado#>|2|,|.</number_format>", 'align=right'); $grid->column("% Ventas", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right'); $grid->column("Cant. Fact", "numfac", 'align=right'); $grid->build(); $data['content'] = open_flash_chart_object(680, 300, site_url("hospitalidad/anuales/grafico/{$anio}")); $data['content'] .= $filter->output . $grid->output; $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Anuales</h1>"; $data['script'] = '<script type="text/javascript"> $(document).ready(function() { $("#anio").keypress(function(event) { acceptNum(evt); return false; }); }); var nav4 = window.Event ? true : false; function acceptNum(evt) { var key = nav4 ? evt.which : evt.keyCode; return (key <= 13 || (key >= 48 && key <= 57)); } </script>'; $data["head"] = script("jquery-1.2.6.pack.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function sel() { $this->rapyd->load("dataform"); //echo $this->flongpres; //$script=' //$(function() { // // $("#codigoadm").change(function(){ // $.post("'.site_url('presupuesto/presupsoli/get_tipo').'",{ codigoadm:$("#codigoadm").val() },function(data){$("#tipo").html(data);}) // }); // // $("#tipo").change(function(){ // $.post("'.site_url('presupuesto/presupsoli/get_estrupres').'",{ tipo:$("#tipo").val(),codigoadm:$("#codigoadm").val() },function(data){$("#codigopres").html(data);}) // }); // //}); //'; $script = ' $(function() { $("#codigoadm").change(function(){ $.post("' . site_url('presupuesto/presusol/get_tipo') . '",{ codigoadm:$("#codigoadm").val() },function(data){$("#tipo").html(data);}) }); $("#tipo").change(function(){ $.post("' . site_url('presupuesto/presusol/get_estrupres') . '",{ codigoadm:$("#codigoadm").val(),tipo:$("#tipo").val() },function(data){$("#codigopres").html(data);}) }); }); '; $flong = $this->flongpres; $rlong = $this->flongadm; $filter = new DataForm("presupuesto/presupsoli/sel/process"); $filter->script($script); $filter->codigoadm = new dropdownField("Estructura Administrativa", "codigoadm"); $filter->codigoadm->option("", "Seleccione"); $filter->codigoadm->rule = 'required'; $filter->codigoadm->options("SELECT b.codigo, CONCAT_WS(' ',b.codigo,b.denominacion) AS val FROM presusol AS a JOIN estruadm AS b ON a.codigoadm=b.codigo GROUP BY b.codigo"); $filter->tipo = new dropdownField('Origen de fondos', 'tipo'); $filter->tipo->option("", "Seleccione una Estructura Administrativa"); $filter->tipo->rule = 'required'; $filter->codigopres = new dropdownField("Presupuesto", "codigopres"); $filter->codigopres->option("", "Seleccione un presupuesto"); $filter->submit("btnsubmit", "Buscar"); $filter->build_form(); if ($filter->on_success()) { $ttipo = $filter->tipo->newValue; $codamd = $filter->codigoadm->newValue; $codpre = $filter->codigopres->newValue; redirect("presupuesto/presupsoli/asignar/{$ttipo}/{$codamd}/{$codpre}"); } $data['content'] = $filter->output; $data['title'] = "Presupuesto Estimado"; $data["head"] = script("jquery.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load("datagrid2"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); if ($this->uri->segment(4)) { $mes = $this->uri->segment(4); } elseif (isset($_POST['mes'])) { $mes = $_POST['mes']; } if ($this->uri->segment(5)) { $anio = $this->uri->segment(5); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($mes) or empty($anio)) { $mes = date("n"); } $anio = date("Y"); $fechai = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '01'; $fechaf = $anio . str_pad($mes, 2, "0", STR_PAD_LEFT) . '31'; $filter = new DataForm('ventas/mensuales'); $filter->attributes = array('onsubmit' => "this.action='index/'+this.form.mes.value+'/'+this.form.anio.value+'/';return FALSE;"); $filter->title('Filtro de ventas mensuales'); $filter->mes = new dropdownField("Mes/Año", "mes"); for ($i = 1; $i < 13; $i++) { $filter->mes->option(str_pad($i, 2, '0', STR_PAD_LEFT), str_pad($i, 2, '0', STR_PAD_LEFT)); } $filter->mes->size = 2; $filter->mes->style = ''; $filter->mes->insertValue = $mes; $filter->anio = new inputField("Año", "anio"); $filter->anio->in = 'mes'; $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->maxlength = 4; $filter->button("btnsubmit", "Buscar", form2uri(site_url('hospitalidad/mensuales/index'), array('mes', 'anio')), $position = "BL"); $filter->build_form(); $data = $this->_sincrodata($fechai, $fechaf); $grid = new DataGrid2('', $data); $grid->totalizar('impuesto', 'cobrado', 'contado', 'credito', 'subtotal', 'numfac'); $grid->column("Dia", "dia"); $grid->column("Sub-Total", "<number_format><#subtotal#>|2|,|.</number_format>", 'align=right'); $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right'); $grid->column("Contado", "<number_format><#contado#>|2|,|.</number_format>", 'align=right'); $grid->column("Credito", "<number_format><#credito#>|2|,|.</number_format>", 'align=right'); $grid->column("Cobrado", "<number_format><#cobrado#>|2|,|.</number_format>", 'align=right'); $grid->column("% Ventas", "<number_format><#porcentaje#>|2|,|.</number_format>", 'align=right'); $grid->column("Cant. Fact", "numfac", 'align=right'); $grid->build(); $data['content'] = open_flash_chart_object(680, 300, site_url("hospitalidad/mensuales/grafico/{$mes}/{$anio}")); $data['content'] .= $filter->output . $grid->output; $data['title'] = $this->rapyd->get_head() . "<h1>Ventas Mensuales</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function detalle() { $this->rapyd->load('datagrid', 'dataform'); $modulo = $this->uri->segment(4) ? $this->uri->segment(4) : $this->input->post('modulo'); if (!$modulo) { redirect('/contabilidad/reglas'); } $form = new DataForm('contabilidad/reglas/ejecutar'); $form->title('Fecha para la ejecución'); $form->fecha = new dateonlyField('Fecha', 'fecha', 'd/m/Y'); $form->fecha->size = 10; $form->fecha->insertValue = $this->input->post('fecha') ? $this->input->post('fecha') : date('Ymd'); $form->fecha->append("<input type='hidden' name='modulo' value='{$modulo}' id='modulo'>"); $form->submit = new submitField('Ejecutar', 'btn_submit'); $form->submit->in = 'fecha'; $form->build_form(); function marca($encab, $val) { if ($encab == 'CASI') { return ''; } if (!empty($val)) { if (is_numeric($val) && floatval($val) == 0) { return ''; } else { return '<div style="background:green"> - </div>'; } } return ''; } $sel = array('modulo', 'descripcion', 'regla', 'tabla', 'debe', 'haber'); $link = anchor('/contabilidad/reglas/dataedit/<#modulo#>/show/<#modulo#>/<#regla#>', 'Ver regla'); $link2 = anchor('/contabilidad/reglas/duplicar/<#modulo#>/<#regla#>', 'Duplicar'); $action = "javascript:window.location='" . site_url('contabilidad/reglas') . "'"; $grid = new DataGrid(); $grid->use_function('marca'); $grid->add("contabilidad/reglas/dataedit/{$modulo}/create", 'Agregar Regla'); $grid->button('cancelar', RAPYD_BUTTON_BACK, $action); $grid->db->select($sel); $grid->db->from('`reglascont`'); $grid->db->where('modulo', $modulo); $grid->db->orderby('modulo,tabla,regla'); $grid->column('Modulo', 'modulo'); $grid->column('Regla', 'regla'); $grid->column('Tabla', 'tabla'); $grid->column('Descripcion', 'descripcion'); $grid->column('Debe', '<marca><#tabla#>|<#debe#></marca>', 'align="center"'); $grid->column('Haber', '<marca><#tabla#>|<#haber#></marca>', 'align="center"'); $grid->column('', $link, 'align="center"'); $grid->column('', $link2, 'align="center"'); $grid->build(); $data['content'] = $form->output . $grid->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = "<h1>Detalle de regla {$modulo}</h1>"; $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load("dataform", "datatable", 'datagrid'); $this->load->library('table'); //$mSQL=$this->db->query("SHOW tables"); //$row = $mSQL->result_array(); //$tables =$row; //$base_process_uri= $this->rapyd->uri->implode_uri("base_uri","gfid","orderby"); //$filter = new DataForm($this->rapyd->uri->add_clause($base_process_uri, "search")); $filter = new DataForm('nomina/rpers/process'); $filter->title('Filtro del Reporte'); //$filter->attributes=array('onsubmit'=>'is_loaded()'); $filter->tabla = new dropdownField("Tabla", "tabla"); $filter->tabla->option("pers", "Personal"); $filter->tabla->clause = ""; $filter->obra = new dropdownField("Obra", "depto"); $filter->obra->db_name = 'depto'; $filter->obra->clause = "where"; $filter->obra->option(" ", "Todos"); $filter->obra->options("SELECT depto, descrip FROM dpto ORDER BY depto "); $filter->obra->operator = "="; $filter->status = new dropdownField("Status", "status"); $filter->status->option("", "Todos"); $filter->status->option("A", "Activos"); $filter->status->option("I", "Inactivos"); $filter->status->style = 'width:100px'; //if($this->rapyd->uri->is_set("search")){ $mSQL = 'DESCRIBE pers'; $query = $this->db->query($mSQL); if ($query->num_rows() > 0) { foreach ($query->result_array() as $row) { $data[] = $row; } } function ractivo($field) { $data2 = array('name' => 'campos[]', 'id' => 'c' . $field, 'value' => $field, 'checked' => FALSE, 'style' => 'margin:5px'); $retorna = form_checkbox($data2); return $retorna; } $grid = new DataGrid("Resultados", $data); $grid->use_function('ractivo'); $grid->column("Campos", 'Field'); $grid->column("Mostrar", "<ractivo><#Field#></ractivo>", 'align="center"'); $grid->build(); $tabla = $grid->output; //$filter->button("btnsubmit", "Consultar",'', $position="BL"); //$filter->button("btnsubmit", "Traer Tikets", form2uri(site_url("/supervisor/tiket/traertiket"),array('cliente')), $position="BL");// //$filter->button("btnsubmit", "Traer Tikets", form2uri(site_url("/supervisor/tiket/traertiket"), $position="BL");// $filter->build_form(); $obra = 'hola'; $data['content'] = $filter->output . form_open("nomina/rpers/crear/{$obra}") . $tabla . form_submit('mysubmit', 'Generar') . form_close(); $data['title'] = " Reporte "; $data["head"] = script("jquery.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { //$this->rapyd->load("datagrid"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); if ($this->uri->segment(4)) { $anio = $this->uri->segment(4); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($anio)) { $anio = date("Y"); } $fechai = $anio . '0101'; $fechaf = $anio . '1231'; $filter = new DataForm('nomina/promediosueldos'); $filter->title('Filtro de Promedio de Sueldos'); $filter->anio = new inputField("Año", "anio"); $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->rule = "max_length[4]"; $filter->button("btnsubmit", "Buscar", form2uri(site_url('nomina/promediosueldos /index'), array('anio')), $position = "BL"); $filter->build_form(); /* $grid = new DataGrid(); $select=array( "fecha","MONTH(fecha)as mes", "SUM(montonet*IF(tipo_doc='D', -1, 1)) AS anterior", "SUM(credito*IF(tipo_doc='D', -1, 1)) as contado", "SUM(inicial*IF(tipo_doc='D', -1, 1)) as credito", "FORMAT(sum(montotot*IF(tipo_doc='D',-1,1)),2) AS subtotal", "FORMAT(sum(montoiva*IF(tipo_doc='D',-1,1)),2) AS impuesto", "COUNT(*) AS numfac"); $grid->db->select($select); $grid->db->from("scst"); $grid->db->where('a.tipo<>','X'); $grid->db->where('fecha >= ', $fechai); $grid->db->where('fecha <= ',$fechaf); $grid->db->groupby("mes"); $grid->column("Fecha" , "fecha" ); $grid->column("Sub-Total" , "subtotal" ,'align=right'); $grid->column("Impuesto" , "impuesto" ,'align=right'); $grid->column("Total" , "anterior",'align=right'); $grid->column("Contado" , "contado" ,'align=right'); $grid->column("Credito" , "credito" ,'align=right'); $grid->column("Número" , "numfac" ,'align=right'); $grid->build();*/ $grafico = open_flash_chart_object(760, 300, site_url("nomina/promediosueldos/grafico/{$anio}/")); $data['content'] = $grafico; $data['content'] .= $filter->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = $this->rapyd->get_head() . " Nomina "; $this->load->view('view_ventanas', $data); }
function mensuales($anio = '', $cliente = '') { $this->rapyd->load("datagrid2"); $this->rapyd->load("dataform"); $this->load->helper('openflash'); if (isset($_POST['anio']) and empty($anio)) { $anio = $_POST['anio']; } if (isset($_POST['cod_cli']) and empty($cliente)) { $cliente = $_POST['cod_cli']; } if (empty($anio) or empty($cliente)) { redirect("supermercado/clientes/anuales/{$anio}"); } $fechai = $anio . '0101'; $fechaf = $anio . '1231'; $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'cod_cli'), 'titulo' => 'Buscar Cliente'); $cboton = $this->datasis->modbus($scli); $filter = new DataForm('supermercado/clientes/mensuales'); $filter->title('Filtro de ventas Mensuales'); $filter->anio = new inputField("Año", "anio"); $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->maxlength = 4; $filter->cliente = new inputField("Cliente", "cod_cli"); $filter->cliente->size = 10; $filter->cliente->insertValue = $cliente; $filter->cliente->rule = "max_length[4]"; $filter->cliente->append($cboton); $filter->button("btnsubmit", "Buscar", form2uri(site_url('supermercado/clientes/mensuales'), array('anio', 'cod_cli')), $position = "BL"); $filter->build_form(); $grid = new DataGrid2(); $select = array("cliente,nombres,DATE_FORMAT(fecha,'%m')AS mes,\n\t\tSUM(gtotal)AS grantotal,\n\t\tSUM(impuesto)AS impuesto"); $grid->db->select($select); $grid->db->from("viefac"); $grid->db->where('tipo<>', 'X'); $grid->db->where('fecha >= ', $fechai); $grid->db->where('fecha <= ', $fechaf); $grid->db->where('cliente', $cliente); $grid->db->groupby("MONTH(fecha)"); $grid->db->orderby("mes"); $grid->column("Mes", "mes", "align='left'"); $grid->column("Impuesto", "<number_format><#impuesto#>|2|,|.</number_format>", 'align=right'); $grid->column("Total", "<number_format><#grantotal#>|2|,|.</number_format>", 'align=right'); $grid->totalizar('impuesto', 'grantotal'); $grid->build(); //echo $grid->db->last_query(); $grafico = open_flash_chart_object(750, 350, site_url("supermercado/clientes/gmensuales/{$anio}/{$cliente}")); $data['content'] = $grafico; $data['content'] .= $filter->output . $grid->output; $data["head"] = $this->rapyd->get_head(); $data['title'] = $this->rapyd->get_head() . "<h1>Clientes</h1>"; $this->load->view('view_ventanas', $data); }
function precios2() { $this->rapyd->load("dataform", "datatable"); $cod = $this->uri->segment(4); $script = ' $("#codigo").focus(); $(document).ready(function() { $("a").fancybox(); $("#codigo").attr("value", ""); $("#codigo").focus(); }); $("#df1").submit(function() { valor=$("#codigo").attr("value"); location.href="' . site_url('supermercado/consultas/precios2') . '/"+valor; return false; }); '; $form = new DataForm(); $form->script($script); $form->codigo = new inputField("Código", "codigo"); $form->codigo->size = 20; $form->codigo->insertValue = ''; $form->codigo->append('Presente el articulo frente al lector de codigo de barras o escriba directamente algun codigo de identificacion y luego presione ENTER'); $form->build_form(); $contenido = $form->output; if (!empty($cod)) { $data2 = $this->rprecios($cod); if ($data2) { $contenido .= $this->load->view('view_rprecios', $data2, true); } else { $t = array(); $t[1][1] = "<b>PRODUCTO NO REGISTRADO</b>"; $t[2][1] = ""; $t[3][1] = "<b>Por Favor introduzca un Codigo de identificación del Producto</b>"; $t[4][1] = "Presente el producto en el lector de codigo de barras"; $t[5][1] = "o escriba directamente algun codigo de identificacion y luego presione ENTER"; $table = new DataTable(null, $t); $table->cell_attributes = 'style="vertical-align:middle; text-align: center;"'; $table->per_row = 1; $table->cell_attributes = ''; //$t[2][1]="";style="vertical-align:top;" $table->cell_template = "<div style='color:red;' align='center'><#1#></div></br>"; $table->build(); $contenido .= $table->output; } } else { //$data['content'] = $form->output; } $data['content'] = $contenido; $data["head"] = script("jquery.js") . script("plugins/jquery.fancybox.pack.js") . script("plugins/jquery.easing.js") . style('fancybox/jquery.fancybox.css') . style("ventanas.css") . style("estilos.css") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $this->rapyd->load('dataform'); $this->rapyd->load('datagrid2'); $this->load->library('encrypt'); function dif($a, $b) { return number_format($a - $b, 2, ',', '.'); } $form = new DataForm('supermercado/conciliacion/index/process'); $form->fechad = new dateonlyField('Desde', 'fechad', 'd/m/Y'); $form->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d") - 30, date("Y"))); $form->fechad->rule = 'required'; $form->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y'); $form->fechah->insertValue = date('Y-m-d'); $form->fechah->rule = 'required'; $form->submit('btnsubmit', 'Buscar'); $form->build_form(); $tabla = ''; if ($form->on_success()) { $fechad = $form->fechad->newValue; $fechah = $form->fechah->newValue; //$mSQL="SELECT 'PV' ,caja,SUM(gtotal*IF(MID(numero,1,2)='NC',-1,1)) FROM viefac WHERE fecha BETWEEN '$fechad' AND '$fechah' GROUP BY caja UNION //SELECT 'PV' ,'MAYO',SUM(gtotal*IF(tipo='D',-1,1)) FROM fmay WHERE fecha BETWEEN '$fechad' AND '$fechah' UNION //SELECT 'CZ' ,caja,SUM(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) FROM fiscalz WHERE fecha BETWEEN '$fechad' AND '$fechah' GROUP BY caja"; $mSQL = "SELECT a.fecha, a.caja, sum(a.gtotal*if(MID(a.numero,1,2)='NC',-1,1)) AS factura,\n\t\t\t(SELECT sum(exento+base+iva-ncexento-ncbase-nciva) venta FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=a.caja ) AS cierrez,\n\t\t\t(SELECT sum(exento+base+iva-ncexento-ncbase-nciva) venta FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=a.caja )-\n\t\t\tsum(a.gtotal*if(MID(a.numero,1,2)='NC',-1,1)) AS dife\n\t\t\tFROM viefac a\n\t\t\tWHERE a.fecha BETWEEN '{$fechad}' AND '{$fechah}' GROUP BY a.fecha, a.caja ORDER BY a.caja,a.fecha"; $grid = new DataGrid2('Resúmen'); $grid->db->_escape_char = ''; $grid->db->_protect_identifiers = false; //$grid->per_page = 20; $grid->use_function('dif'); $select = array('a.fecha', 'b.caja', '(SELECT sum(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=b.caja) AS cierrez', '(SELECT sum(d.gtotal) FROM viefac AS d WHERE d.fecha=a.fecha AND d.caja=b.caja) AS factura'); $grid->db->select($select); $grid->db->from('tiempo AS a'); $grid->db->join("caja AS b", "a.fecha BETWEEN '{$fechad}' AND '{$fechah}'"); $grid->db->orderby("caja,fecha"); $grid->db->having("cierrez IS NOT null OR factura IS NOT null"); $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'"); $grid->column("Caja", "caja", 'align=center'); $grid->column("Factura", "<nformat><#factura#></nformat>", 'align=right'); $grid->column("Cierre Z", "<nformat><#cierrez#></nformat>", 'align=right'); $grid->column("Diferencia", "<dif><#factura#>|<#cierrez#></dif>", 'align=right'); $grid->totalizar('factura', 'cierrez'); $grid->build(); //echo $grid->db->last_query(); $tabla = $grid->output; } $reporte = anchor('reportes/ver/CONCILIACI', 'Imprimir'); $data['content'] = $form->output . $reporte . $tabla; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $data['title'] = heading('Concialiaciones de Cierre Z'); $this->load->view('view_ventanas', $data); }
public static function GetConfigurationForm() { $ConfigurationForm = new DataForm(); $ConfigurationForm->SetInlineHelp(""); $methods = get_class_methods(__CLASS__); foreach ($methods as $method) { if ($method != '__construct' && $method != 'GetConfigurationForm') { $ConfigurationForm->AppendField(new DataFormField("{$method}URL", FORM_FIELD_TYPE::TEXT, "{$method} URL")); } } return $ConfigurationForm; }
function repoauto() { exit("hello"); $this->load->library("XLSReporte"); $this->rapyd->load("dataform", "datagrid"); $filter = new DataForm("xlsauto2/repoauto/process"); $filter->sql = new textareaField("Consulta SQL", "sql"); $filter->sql->cols = 80; $filter->sql->rows = 6; $filter->sql->rule = "required"; $filter->submit("btnsubmit", "Ejecutar"); $filter->build_form(); $salida = ''; if ($filter->on_success()) { $data = array(); $mSQL = $filter->sql->value; $link = @mysql_connect($this->db->hostname, $this->db->username, $this->db->password) or die('Error de coneccion'); mysql_select_db($this->db->database, $link) or die('Base de datos no seleccionable'); $result = mysql_query($mSQL, $link); if (!$result) { $salida = mysql_errno($link) . ": " . mysql_error($link); } else { if (preg_match('/[Ss][Ee][Ll][Ee][Cc][Tt]/', $mSQL) > 0) { $num_rows = mysql_num_rows($result); } else { $num_rows = 0; } if ($num_rows > 0) { $colunas = mysql_num_fields($result); while ($row = mysql_fetch_assoc($result)) { $data[] = $row; } $xls = new XLSReporte($mSQL); $xls->setTitulo("TARJETA"); $xls->setSubTitulo("Sub Titulo de Tarjeta"); $xls->setSobreTabla("Este es el titulo d la tabla"); $xls->setHeadValores('TITULO1'); $xls->setSubHeadValores('TITULO2', 'TITULO3'); foreach ($data[0] as $campos => $value) { $xls->AddCol($campos, $campos); } $xls->Table(); $xls->Output(); } else { $salida = "Su consulta no arrojo algun resultado"; } } } $data['content'] = $filter->output . $salida; $data['title'] = "<h1>Consulta SQL que muestra los resultados en extencion \".xls\"</h1>"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }