PHP DataForm::submit方法代码示例

 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 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&oacute;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('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&eacute;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);
 }

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

    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('datatable', 'dataform');
     $form = new DataForm('supermercado/cargahisto/index/process');
     $form->title('Este modulo permite cargar manual las ventas sacadas de los historicos de las cajas');
     $form->fecha = new dateonlyField('Fecha', 'fecha', 'd/m/Y');
     $form->fecha->db_format = 'Ymd';
     $form->fecha->insertValue = date('Y-m-d');
     $form->fecha->size = 11;
     $form->fecha->autocomplete = false;
     $form->fecha->rule = 'required|chfecha';
     $form->hf = new uploadField('Facturas (<b>hf</b>YYYYMMCCCAAA.dbf)', 'hf');
     $form->hf->upload_path = 'tmp';
     $form->hf->upload_root = '/';
     $form->hf->rule = 'required';
     $form->hf->allowed_types = 'csv|dbf';
     $form->hi = new uploadField('Art&iacute;culos (<b>hi</b>YYYYMMCCCAAA.dbf)', 'hi');
     $form->hi->upload_path = 'tmp';
     $form->hi->upload_root = '/';
     $form->hi->rule = 'required';
     $form->hi->allowed_types = 'csv|dbf';
     $form->hs = new uploadField('Pagos (<b>hs</b>YYYYMMCCCAAA.dbf)', 'hs');
     $form->hs->upload_path = 'tmp';
     $form->hs->upload_root = '/';
     $form->hs->rule = 'required';
     $form->hs->allowed_types = 'csv|dbf';
     $form->submit('btnsubmit', 'Procesar');
     $form->build_form();
     if ($form->on_success()) {
         $fecha = $form->fecha->newValue;
         $encab = false;
         if (!empty($form->hf->upload_data['full_path'])) {
             if (substr($form->hf->upload_data['file_name'], 0, 2) == 'hf') {
                 $encab = true;
                 $this->_cargadbf($form->hf->upload_data['full_path'], $fecha);
                 unlink($form->hf->upload_data['full_path']);
             } else {
                 $form->error = 'Encabezado primero';
                 $form->build_form();
             }
         }
         if (!empty($form->hi->upload_data['full_path']) && $encab) {
             $this->_cargadbf($form->hi->upload_data['full_path'], $fecha);
             unlink($form->hi->upload_data['full_path']);
         }
         if (!empty($form->hs->upload_data['full_path']) && $encab) {
             $this->_cargadbf($form->hs->upload_data['full_path'], $fecha);
             unlink($form->hs->upload_data['full_path']);
         }
     }
     $data['content'] = $form->output;
     $data['title'] = heading('Cargar ventas de los hist&oacute;ricos de cajas');
     $data['script'] = script('jquery-1.2.6.js');
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

    function index()
    {
        $this->rapyd->load('dataform');
        $lscst = site_url('compras/scst/autocomplete/control');
        $script = '
		function formato(row) {
			return row[0]+" "+row[1]+" "+row[3];
		}

		$(function() {
			$("#control").autocomplete("' . $lscst . '",{
				delay:10,
				//minChars:2,
				matchSubset:1,
				matchContains:1,
				cacheLength:10,
				formatItem:formato,
				width:450,
				autoFill:true
				}
			);
		});';
        $form = new DataForm($this->url . 'index/process');
        $form->title('Pasar precios a cajas');
        $form->script($script);
        $form->control = new inputField('Control de compra', 'control');
        $form->control->rule = 'required|callback_chcontrol';
        $form->control->size = 12;
        $form->control->maxlength = 10;
        $form->control->append('Dejar vacio para enviar un masivo');
        $form->submit("btnsubmit", "Pasar precios a caja");
        $form->build_form();
        $error = '';
        if ($form->on_success()) {
            $control = $form->control->newValue;
            $usr = $this->session->userdata('usuario');
            $join = '';
            if (strlen($control > 0)) {
                $join = 'JOIN `itscst` AS b ON a.codigo=b.codigo AND b.codigo=' . $this->db->escape($control);
            }
            $mSQL = "INSERT INTO `enviapos` (codigo,numero,precio1,fecha,hora,usuario)\n\t\t\t\t  SELECT a.codigo,'INVENTAR',a.precio1,CURDATE(),CURTIME(),'{$usr}' FROM `maes` AS a {$join}";
            $ban = $this->db->simple_query($mSQL);
            if (!$ban) {
                $error .= "Hubo problemas al pasar los precios, comuniquese con servicio técnico";
                memowrite($mSQL, 'ENVIACAJA');
            } else {
                logusu('ENVIACAJA', "Fue enviado una actualizacion de precios");
            }
        }
        $data['content'] = "<div class='alert'>{$error}</div>";
        $data['content'] .= $form->output;
        $data['title'] = '<h1>Env&iacute;o de precios para las cajas</h1>';
        $data["head"] = script('jquery.pack.js') . script('plugins/jquery.autocomplete.js') . style('jquery.autocomplete.css') . $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data);
    }

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

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