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