Пример #1
0
 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);
 }
Пример #2
0
 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);
 }
Пример #3
0
 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);
 }
Пример #4
0
 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);
 }
Пример #5
0
 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&oacute;n de caja";
     $filter->caja->size = 4;
     /*$filter->clave= new inputField("Clave", "clave");
     		$filter->clave->rule = "required";
     		$filter->clave->group = "Selecci&oacute;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);
 }
Пример #6
0
 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);
 }
Пример #7
0
 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);
 }
Пример #8
0
    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);
    }
Пример #9
0
 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);
 }
Пример #10
0
    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&eacute;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);
    }
Пример #11
0
 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&uacute;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);
 }
Пример #12
0
 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);
 }
Пример #13
0
 function sel()
 {
     $this->rapyd->load("dataform");
     $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'C&oacute;odigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'C&oacute;odigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'retornar' => array('codbanc' => 'codbanc'), 'titulo' => 'Buscar Bancos');
     $bBANC = $this->datasis->p_modbus($mBANC, "mbanc");
     $filter = new DataForm($this->url . "sel/process");
     $filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y');
     $filter->fechad->clause = "where";
     $filter->fechad->db_name = "fecha";
     $filter->fechad->operator = ">=";
     $filter->fechad->insertValue = date("Ymd", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y")));
     $filter->fechad->group = "Fecha";
     //$filter->fechad->dbformat='Y-m-d';
     $filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
     $filter->fechah->clause = "where";
     $filter->fechah->insertValue = date("Ymd");
     $filter->fechah->db_name = "fecha";
     $filter->fechah->operator = "<=";
     $filter->fechah->group = "Fecha";
     //$filter->fechaH->dbformat='Y-m-d';
     $filter->codbanc = new inputField("Banco", 'codbanc');
     $filter->codbanc->db_name = 'codbanc';
     $filter->codbanc->rule = 'required';
     $filter->codbanc->size = 5;
     $filter->codbanc->clause = "where";
     $filter->codbanc->operator = "=";
     $filter->codbanc->append($bBANC);
     $filter->codbanc->clause = "where";
     $filter->codbanc->operator = "=";
     $filter->concilia = new dropDownField("", 'concilia');
     $filter->concilia->option("", "");
     $filter->concilia->option("S", "Conciliado");
     $filter->concilia->option("N", "Sin Conciliar");
     $filter->concilia->db_name = 'concilia';
     $filter->concilia->size = 3;
     $filter->submit("btnsubmit", "Buscar");
     $filter->build_form();
     if ($filter->on_success()) {
         $fechad = $filter->fechad->newValue;
         $fechah = $filter->fechah->newValue;
         $codbanc = $filter->codbanc->newValue;
         $concilia = $filter->concilia->newValue;
         redirect($this->url . "asignar/{$fechad}/{$fechah}/{$codbanc}/{$concilia}");
     }
     $data['content'] = $filter->output;
     $data['title'] = "Conciliaci&oacute;n";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #14
0
 function uig()
 {
     $this->rapyd->load('dataform');
     $this->datasis->modulo_id('91D', 1);
     $sucu = $this->db->escape($this->sucu);
     $form = new DataForm('sincro/exportar/uig/process');
     $form->qtrae = new dropdownField('Que exportar?', 'qtrae');
     $form->qtrae->rule = 'required';
     $form->qtrae->option('', 'Selecionar');
     $form->qtrae->option('scli', 'Clientes');
     $form->qtrae->option('sprv', 'Proveedores');
     $form->qtrae->option('sinv', 'Inventario');
     $form->qtrae->option('sinvprec', 'Inventario solo precios');
     $form->qtrae->option('maes', 'Inventario Supermercado');
     $form->qtrae->option('smov', 'Movimientos de clientes');
     $form->qtrae->option('transacciones', 'Facturas y transferencias');
     $form->qtrae->option('supertransa', 'Ventas Supermercado');
     $form->qtrae->option('rcaj', 'Cierres de cajas');
     $form->qtrae->option('fiscalz', 'Cierres Z');
     $form->qtrae->option('sfacfis', 'Auditoria Fiscal');
     $form->fecha = new dateonlyField('Fecha', 'fecha');
     $form->fecha->insertValue = date('Y-m-d');
     $form->fecha->rule = 'required|chfecha';
     $form->fecha->size = 12;
     $form->submit('btnsubmit', 'Descargar');
     $form->build_form();
     $exito = '';
     if ($form->on_success()) {
         $fecha = $form->fecha->newValue;
         $obj = '_' . str_replace('_', '', $form->qtrae->newValue);
         if (method_exists($this, $obj)) {
             $rt = $this->{$obj}($fecha);
         } else {
             $rt = 'Metodo no definido (' . $form->qtrae->newValue . ')';
         }
         if (strlen($rt) > 0) {
             $form->error_string = $rt;
             $form->build_form();
         } else {
             $exito = 'Transferencia &Eacute;xitosa';
         }
     }
     $data['content'] = $form->output . $exito;
     $data['title'] = '<h1>Exportar data de Sucursal</h1>';
     $data['script'] = '';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #15
0
 function margenes()
 {
     $this->rapyd->load("dataedit", "dataform");
     $script = '
             <script language="javascript" type="text/javascript">
             $(function(){
                     $(".inputnum").numeric(".");
             });
             </script>
             ';
     $form = new DataForm("inventario/margenes_sinv/margenes/modifica");
     $form->margen1 = new inputField2("Magen1", "margen1");
     $form->margen1->size = 10;
     $form->margen1->maxlength = 8;
     $form->margen1->css_class = 'inputnum';
     $form->margen1->rule = 'required|callback_chporcent';
     $form->margen2 = new inputField2("Magen2", "margen2");
     $form->margen2->size = 10;
     $form->margen2->maxlength = 8;
     $form->margen2->css_class = 'inputnum';
     $form->margen2->rule = 'required|callback_chporcent';
     $form->margen3 = new inputField2("Magen3", "margen3");
     $form->margen3->size = 10;
     $form->margen3->maxlength = 8;
     $form->margen3->css_class = 'inputnum';
     $form->margen3->rule = 'required|callback_chporcent';
     $form->margen4 = new inputField2("Magen4", "margen4");
     $form->margen4->size = 10;
     $form->margen4->maxlength = 8;
     $form->margen4->css_class = 'inputnum';
     $form->margen4->rule = 'required|callback_chporcent';
     $form->submit("btnsubmit", "MODIFICAR");
     $form->build_form();
     if ($form->on_success()) {
         set_time_limit(600);
         $margen1 = $_POST['margen1'];
         $margen2 = $_POST['margen2'];
         $margen3 = $_POST['margen3'];
         $margen4 = $_POST['margen4'];
         redirect("inventario/margenes_sinv/modifica/{$margen1}/{$margen2}/{$margen3}/{$margen4}");
         //$this->procesa();
     }
     $data['content'] = $form->output;
     $data['head'] = script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head() . $script;
     $data['title'] = '<h1>Cambiar Margenes</h1>';
     $this->load->view('view_ventanas', $data);
 }
Пример #16
0
 function uig()
 {
     $this->rapyd->load('dataform');
     $this->datasis->modulo_id('91D', 1);
     $sucu = $this->db->escape($this->sucu);
     $form = new DataForm("sincro/exportar/uig/process");
     $form->qtrae = new dropdownField("Que exportar?", "qtrae");
     $form->qtrae->rule = 'required';
     $form->qtrae->option("", "Selecionar");
     $form->qtrae->option("scli", "Clientes");
     $form->qtrae->option("sinv", "Inventario");
     $form->qtrae->option("maes", "Inventario Supermercado");
     $form->qtrae->option("smov", "Movimientos de clientes");
     $form->qtrae->option("transacciones", "Facturas y transferencias");
     $form->qtrae->option("supertransa", "Ventas Supermercado");
     $form->qtrae->option("rcaj", "Cierres de cajas");
     $form->qtrae->option("fiscalz", "Cierres Z");
     $form->fecha = new dateonlyField("Fecha", "fecha");
     $form->fecha->insertValue = date("Y-m-d");
     $form->fecha->rule = "required|chfecha";
     $form->fecha->size = 12;
     $form->submit("btnsubmit", "Descargar");
     $form->build_form();
     $exito = '';
     if ($form->on_success()) {
         $fecha = $form->fecha->newValue;
         $obj = '_' . str_replace('_', '', $form->qtrae->newValue);
         if (method_exists($this, $obj)) {
             $rt = $this->{$obj}($fecha);
         } else {
             $rt = 'Metodo no definido (' . $form->qtrae->newValue . ')';
         }
         if (strlen($rt) > 0) {
             $form->error_string = $rt;
             $form->build_form();
         } else {
             $exito = 'Transferencia &Eacute;xitosa';
         }
     }
     $data['content'] = $form->output . $exito;
     $data['title'] = '<h1>Exportar data de Sucursal</h1>';
     $data['script'] = '';
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #17
0
 function index()
 {
     $this->rapyd->load("dataform");
     $filter = new DataForm("contabilidad/gcontab/index/process");
     $filter->fecha = new dateonlyField("Fecha", "fecha");
     $filter->fecha->size = 12;
     $filter->submit("btnsubmit", "Ver balance General");
     $filter->build_form();
     if ($filter->on_success()) {
         $fecha = $filter->fecha->newValue;
         redirect("formatos/ver/BALANCE/{$fecha}");
     }
     $salida = anchor('contabilidad/gcontab/genera', 'Generar Contabilidad');
     $data['content'] = $filter->output . $salida;
     $data['title'] = "{$this->titp}";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #18
0
    function sel()
    {
        $this->rapyd->load("dataform");
        //echo $this->flongpres;
        $script = '
		$(function() {
				$("#codigoadm").change(function(){
					$.post("' . site_url('presupuesto/presupuesto/get_tipo') . '",{ codigoadm:$("#codigoadm").val() },function(data){$("#tipo").html(data);})
				});

				
				
		});
		';
        $flong = $this->flongpres;
        $rlong = $this->flongadm;
        $filter = new DataForm("presupuesto/anualcierre/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 presupuesto 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->ano = new inputField("A&ntilde;o","ano");
        //$filter->ano->size=5;
        //$filter->ano->maxlength=4;
        $filter->submit("btnsubmit", "Buscar");
        $filter->build_form();
        if ($filter->on_success()) {
            $tipo = $filter->tipo->newValue;
            $codigoadm = $filter->codigoadm->newValue;
            //$codigopres = $filter->codigopres->newValue;
            //$ano = $filter->ano->newValue;
            redirect("presupuesto/anualcierre/cerrar/{$tipo}/{$codigoadm}/{$codigopres}");
        }
        $data['content'] = $filter->output;
        $data['title'] = "Cierre de Presupuestos";
        $data["head"] = script("jquery.js") . $this->rapyd->get_head();
        $this->load->view('view_ventanas', $data);
    }
Пример #19
0
 function index()
 {
     $this->rapyd->load("dataform", "datagrid");
     $form = new DataForm('tesoreria/pagonom/index/process');
     $form->contrato = new dropdownField("Contrato", "contrato");
     $form->contrato->option("", "Seleccionar");
     $form->contrato->options("SELECT a.contrato,CONCAT_ws(' ',a.contrato,' *',b.nombre)nombre FROM (SELECT contrato FROM prenom GROUP BY contrato )a JOIN noco b ON a.contrato = b.codigo");
     $form->contrato->rule = 'required';
     $form->submit("btnsubmit", "Pagar Nomina");
     $form->build_form();
     if ($form->on_success()) {
         $mSQL = "\r\n\t\t\tSELECT IF((SELECT numero FROM nomina GROUP BY contrato,fecha ORDER BY numero desc)=0,1,((1*numero) + 1)) numero FROM nomina GROUP BY contrato,fecha ORDER BY numero desc\r\n\t\t\t";
         $contrato2 = $form->contrato->newValue;
         $contrato = $this->db->escape($contrato2);
         $mSQL = $this->db->query($mSQL);
         $cant = $mSQL->num_rows();
         $mSQL = "\r\n\t\t\tINSERT INTO nomina SELECT " . ($cant == 0 ? 1 : $this->datasis->dameval("SELECT ((1*numero) + 1) numero FROM nomina GROUP BY contrato,fecha ORDER BY numero desc")) . " numero,b.tipo frecuencia ,a.contrato,'' depto,a.codigo,a.nombre,a.concepto,a.tipo,a.descrip,a.grupo,a.formula,a.monto,a.fecha,a.cuota,a.cuotat,a.valor,now('Ymd') estampa,'' usuario,'' transac,'' hora,a.fechap,a.trabaja,'' nomi,'' denomi,'' total \r\n\t\t\tFROM prenom a\r\n\t\t\tJOIN noco b ON a.contrato = b.codigo WHERE a.contrato={$contrato}\r\n\t\t\t";
         $this->db->query($mSQL);
         $nomi = $this->db->insert_id();
         $nomi = $this->datasis->dameval("SELECT numero FROM nomina WHERE nomi={$nomi}");
         $this->db->query("DELETE FROM prenom WHERE contrato={$contrato}");
         if ($this->datasis->traevalor('USANOMINA') == 'S') {
             $this->creapago($contrato2, $nomi);
         }
     }
     $grid = new DataGrid("Lista de Nominas Pagadas");
     $grid->db->select(array("a.numero", "a.contrato", "b.nombre", "a.fecha", "SUM(valor) valor"));
     $grid->db->from('nomina a');
     $grid->db->join('noco b', 'a.contrato = b.codigo');
     $grid->db->groupby('numero');
     $grid->db->orderby('fecha', 'desc');
     $grid->per_page = 20;
     $grid->column("N&uacute;mero", "numero");
     $grid->column("Contrato", "contrato");
     $grid->column("Contrato", "nombre", 'align="left"');
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", 'align="center"');
     $grid->column("Monto", "valor", 'align="right"');
     $grid->build();
     $data['content'] = $form->output . $grid->output;
     $data['title'] = ' ' . $this->titulo . ' ';
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #20
0
 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     function rtrunc($forma)
     {
         $pos = strpos($forma, "\r\n");
         return substr($forma, 0, $pos);
     }
     $filter = new DataFilter("Filtro de Busqueda");
     $filter->db->select(array("forma", 'nombre'));
     $filter->db->from("formatos");
     $filter->db->orderby("nombre");
     //$filter->db->where("forma LIKE");
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->size = 20;
     $filter->forma = new inputField("Forma", "forma");
     $filter->forma->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $form = new DataForm("supervisor/puertosdir/filteredgrid/process");
     $form->puerto = new inputField("Nuevo Puerto", "puerto");
     $form->puerto->rule = "required";
     $form->submit("btnsubmit", "Cambiar");
     $form->build_form();
     if ($form->on_success()) {
         echo 'pasamos';
     }
     $grid = new Datagrid("Resultados");
     $grid->use_function('rtrunc');
     $link = site_url('/supervisor/acdatasis/activar');
     $grid->per_page = 15;
     $grid->column("Nombre", "nombre");
     $grid->column("Dirigido", "<rtrunc><#forma#></rtrunc>", 'align="center"');
     $grid->build();
     //echo $grid->db->last_query();
     $ssql = json_encode($grid->db->last_query());
     $data['script'] = "<script type='text/javascript'>\n\t\t\t\$(document).ready(function() {\n\t\t\t\tsql={$ssql};\n\t\t\t\t\n\t\t\t});\n\t\t\t</script>";
     $data['content'] = $filter->output . $form->output . $grid->output;
     $data['title'] = "<h1>Redirecci&oacute;n de puertos en formatos DataSIS</h1>";
     $data["head"] = script("jquery.js") . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #21
0
 function exventas()
 {
     $this->rapyd->load('dataform');
     $this->load->library('Sqlinex');
     $form = new DataForm("supermercado/exportar/exventas/process");
     $form->fecha = new dateonlyField("Fecha", "fecha");
     $form->fecha->insertValue = date("Y-m-d");
     $form->fecha->rule = "require|chfecha";
     $form->fecha->size = 12;
     $form->submit("btnsubmit", "Descargar");
     $form->build_form();
     if ($form->on_success()) {
         $fecha = $form->fecha->newValue;
         $this->_ventas($fecha);
     }
     $data['content'] = $form->output;
     $data['title'] = '<h1>Exportar ventas a SQL</h1>';
     $data['script'] = '';
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #22
0
 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->monto = new inputField("Monto por cupon", "monto");
     $form->monto->size = 15;
     $form->monto->rule = "required";
     $form->monto->insertValue = 100;
     $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()) {
         $query = $this->db->query("SELECT caja,cliente, TRUNCATE(SUM(gtotal)/{$form->monto->newValue},0) cupones FROM viefac WHERE fecha={$form->fecha->newValue} AND caja='{$form->caja->newValue}' group by  caja,cliente WITH ROLLUP HAVING cliente IS NULL");
         $arreglo = array();
         if ($query->num_rows() > 0) {
             foreach ($query->result() as $row) {
                 $arreglo[] = array('caja' => $row->caja, 'cupones' => $row->cupones);
             }
         }
         $grid = new DataGrid("Lista de Cupones", $arreglo);
         $grid->per_page = count($arreglo);
         $grid->column("Caja", 'caja');
         $grid->column("Cupones", "cupones");
         $grid->build();
         $ggri = $grid->output;
     }
     $data['content'] = $form->output . $ggri;
     $data['title'] = "<h1>Tikes repartidos</h1>";
     $data['head'] = $this->rapyd->get_head() . script("jquery-1.2.6.js");
     $this->load->view('view_ventanas', $data);
 }
Пример #23
0
 function busca()
 {
     $this->rapyd->load("dataform");
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;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->submit("btnsubmit", "Buscar");
     $filter->build_form();
     //exit('=============');
     if ($filter->on_success()) {
         $cod_prov = $filter->cod_prov->newValue;
         redirect($this->url . "selecciona/{$cod_prov}");
     }
     $data['content'] = $filter->output;
     $data['title'] = "Pago de Ordenes de Gasolina";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #24
0
 function filteredgrid()
 {
     $this->rapyd->load('dataform', 'datagrid');
     //$this->rapyd->uri->keep_persistence();
     $filter = new DataForm('finanzas/conforch/filteredgrid/process');
     //$filter->title('Filtro de Cheques');
     $filter->valor = new inputField('N&uacute;mero o Beneficiario', 'valor');
     $filter->valor->rule = 'required';
     $filter->valor->autocomplete = false;
     $filter->submit('btnsubmit', 'Buscar');
     $filter->build_form();
     $tabla = '';
     if ($filter->on_success()) {
         $valor = $filter->valor->newValue;
         $grid = new DataGrid('Cheques emitidos', 'bmov');
         $grid->db->where('tipo_op', 'CH');
         $grid->db->like('CONCAT(`numero`,`benefi`)', $valor);
         $grid->db->orderby('fecha', 'desc');
         $grid->db->limit(10);
         //$grid->per_page = 20;
         $uri = anchor('finanzas/conforch/dataedit/show/<#codbanc#>/<#tipo_op#>/<#numero#>', '<#numero#>');
         //$grid->column("Nombre"      ,'nombre'  );
         $grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>');
         $grid->column('N&uacute;mero', $uri);
         $grid->column('Beneficiario', 'benefi', 'benefi');
         $grid->column('Monto', '<nformat><#monto#></nformat>', 'align=\'right\'');
         $grid->column('Banco', 'banco');
         $grid->column('Concepto', 'concepto');
         $grid->column('Anulado', 'anulado', 'align=\'center\'');
         $grid->build();
         //echo $grid->db->last_query();
         $tabla = $grid->output;
     }
     $data['content'] = $filter->output . $tabla;
     $data['title'] = heading('Conformaci&oacute;n de Cheques');
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #25
0
 function index()
 {
     $this->rapyd->load('dataform');
     $form = new DataForm("finanzas/contra/index/process");
     $form->cont = new textareaField("Contenido", "cont");
     $form->cont->rule = "required";
     $form->cont->rows = 10;
     $form->submit("btnsubmit", "Enviar");
     $form->build_form();
     if ($form->on_success()) {
         //echo 'Hola mundo';
         $par = $form->cont->newValue;
         $this->iacont->reconoce($par);
         echo $this->iacont->soy . "\n<pre>";
         print_r($this->iacont->data);
         echo '</pre>';
         //$this->_partida($form->cont->newValue);
     }
     $data['content'] = $form->output;
     $data['title'] = "<h1>Bancos y cajas</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);
 }
Пример #26
0
 function agregar()
 {
     $this->rapyd->load('dataform');
     print_r($_POST);
     $form = new DataForm('finanzas/conci/agregar/process');
     /*$form->fecha = new dateonlyField('Fecha','fecha','m/Y');
     		$form->fecha->insertValue = date('Y-m-d');
     		$form->fecha->rule ='required';
     		$form->fecha->size =12;*/
     $form->mes = new dropdownField('Fecha', 'mes');
     $form->mes->rule = 'required';
     $form->mes->style = 'width:50px';
     for ($i = 1; $i <= 12; $i++) {
         $mmes = str_pad($i, 2, '0', STR_PAD_LEFT);
         $form->mes->option($mmes, $mmes);
     }
     $form->anio = new inputField('A&ntilde;o', 'anio');
     $form->anio->rule = 'required';
     $form->anio->in = 'mes';
     $form->anio->size = 5;
     $form->banco = new dropdownField('Banco', 'banco');
     $form->banco->option('', 'Seleccionar');
     $form->banco->rule = 'required';
     $form->banco->options("SELECT codbanc AS CLAVE, banco FROM banc WHERE CHAR_LENGTH(tbanco)>0 ORDER BY banco");
     $form->submit('btnsubmit', 'Siguiente');
     $form->build_form();
     if ($form->on_success()) {
         $this->_paso1();
         return TRUE;
     }
     $data['content'] = $form->output;
     $data['title'] = '<h1>Conciliaciones de Bancos</h1>';
     $data['script'] = '';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #27
0
    function precios()
    {
        $this->rapyd->load('dataedit', 'dataform');
        $mSINV = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'C&oacute;odigo', 'descrip' => 'Descripci&oacute;n'), 'filtro' => array('codigo' => 'C&oacute;digo', 'barras' => 'Barras', 'alterno' => 'Alterno', 'descrip' => 'Descripci&oacute;n'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Producto');
        $bSINV = $this->datasis->modbus($mSINV);
        $pr = '$(document).ready(function(){
				$(".button").click(function(){
					if($("#codigo").val() == "" ){
						alert("Debe ingresar un codigo de producto");
						return false;
					}
				});
				$(".inputnum").numeric(".");
				$("#codigo").val("");
			});';
        $form = new DataForm('inventario/precios_sinv/precios/modifica');
        $form->script($pr);
        $form->codigo = new inputField2('Consultar Productos', 'codigo');
        $form->codigo->size = 15;
        $form->codigo->maxlength = 15;
        $form->codigo->append($bSINV);
        $form->codigo->rule = 'trim|required';
        $form->submit('btnsubmit', 'Cambiar');
        $form->build_form();
        $band = 0;
        $msj = "";
        if ($form->on_success()) {
            $codigo = $form->codigo->newValue;
            $mSQL_p = 'SELECT id FROM sinv';
            $bbus = array('codigo', 'barras', 'alterno');
            $suple = null;
            $query = Common::_gconsul($mSQL_p, $codigo, $bbus, $suple);
            if ($query !== false) {
                $row = $query->row();
                redirect('inventario/precios_sinv/dataedit/modify/' . $row->id);
            } else {
                $msj .= 'No se encontro el producto';
            }
            /*$resul1=$this->db->query("SELECT count(*) AS cant,id FROM sinv WHERE codigo='$codigo' ");
            		$row1=$resul1->row();
            		if($row1->cant > 0){
            			$band=1;
            			redirect("inventario/precios_sinv/dataedit/modify/$row1->id");
            		}
            		if($band == 0){
            			$resul1=$this->db->query("SELECT count(*) AS cant,id FROM sinv WHERE barras='$codigo' ");
            			$row1=$resul1->row();
            			if($row1->cant > 0){
            				$band=1;
            				redirect("inventario/precios_sinv/dataedit/modify/$row1->id");
            			}
            		}
            		if($band == 0){
            			$resul1=$this->db->query("SELECT count(*) AS cant,id FROM sinv where alterno='$codigo' ");
            			$row1=$resul1->row();
            			if($row1->cant > 0){
            				$band=1;
            				redirect("inventario/precios_sinv/dataedit/modify/$row1->id");
            			}
            		}
            		if($band==0){
            			$resul1=$this->db->query("SELECT count(*) AS cant,codigo FROM barraspos WHERE suplemen='$codigo' ");
            			$row1=$resul1->row();
            			if($row1->cant > 0){
            				$resul2=$this->db->query("SELECT count(*) AS cant,id FROM sinv WHERE codigo='$row1->codigo' ");
            				$row2=$resul2->row();
            				if($row2->cant > 0){
            					redirect("inventario/precios_sinv/dataedit/modify/$row2->id");
            				}
            			}
            		}
            		if ($band==0){
            			$msj.= "No se encontro el producto";
            		}*/
        }
        $data['content'] = $form->output . $msj;
        $data['head'] = script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head();
        $data['title'] = '<h1>Cambiar Precios</h1>';
        $this->load->view('view_ventanas', $data);
    }
Пример #28
0
    function index($var1 = '', $var2 = '', $var3 = '', $var4 = '')
    {
        $this->rapyd->load("dataform", "datatable");
        $this->db->simple_query("ALTER TABLE `retenomi`  ADD COLUMN `nombre` VARCHAR(100) NULL AFTER `status`");
        $this->db->simple_query("ALTER TABLE `asignomi` ADD COLUMN `denominacion` TINYTEXT NULL  AFTER `status`");
        $form1 = new DataForm('nomina/prenom/index/process/aa');
        $form1->contrato = new dropdownField("Contrato", "contrato");
        $mSQL = $this->db->query("SHOW TABLES LIKE 'PRENOM%'");
        foreach ($mSQL->result_array() as $row) {
            foreach ($row as $key => $value) {
                $c = $this->db->escape(substr($value, 6));
                $nombre = $this->datasis->dameval("SELECT nombre FROM noco WHERE codigo={$c}");
                $form1->contrato->option($value, $nombre);
            }
        }
        $form1->submit("btnsubmit", "Recuperar");
        $form1->build_form();
        if ($form1->on_success() && $var2 == 'aa') {
            $this->load->dbforge();
            $tabla = 'prenom';
            $tablap = 'pretab';
            $this->db->query("TRUNCATE {$tabla}");
            $this->db->query("TRUNCATE {$tablap}");
            $contrato = $form1->contrato->newValue;
            $mSQL = "INSERT IGNORE INTO {$tabla} SELECT * FROM {$contrato} ";
            $this->db->query($mSQL);
            $mSQL = "DROP TABLE `{$contrato}`";
            $this->db->query($mSQL);
            redirect('nomina/prenom/montos');
        }
        $script = '
		$(function() {
			$("#pagar").click(function(){
				if(confirm("Esta Seguro de Crear Orden de Pago de Prenomina actual"))
				return true;
				else
				return false;
			});
			$("#guarda").click(function(){
				if(confirm("Esta Seguro que desea Guardar la Prenomina actual. Esto eliminara la prenomina guardada anteriormente")){
					$.post("' . site_url('nomina/prenom/respalda') . '",{ partida:"a" },function(data){
						if(data="_Si"){
							alert("Se respaldo correctamente la Prenomina.")
							nueva=window.open("' . site_url('nomina/prenom') . '","_self");
							
						}else{
							alert("No se Pudo respaldar la Prenomina")
						}
					})
					return false;
				}else{
					return false;
				}
			});
			$("#recibo").click(function(){
			    cant = $("#cant").val();
			    var caracteristicas = "height=240,width=420,scrollTo,resizable=1,scrollbars=1,location=0";
			    nueva=window.open("' . site_url('forma/ver/RECIBO/') . '/"+cant, "Popup", caracteristicas);
			    return false;
			});

			$("#contrato").change(function (){
				c=$("#contrato").val();
				$.post("' . site_url('nomina/noco/tipo') . '",{ con: c},
				function(data){
					$("#contrato2").html(data);
				});
			});
		});
		';
        $form = new DataForm('nomina/prenom/index/process');
        $form->script($script);
        $form->contrato = new dropdownField("Contrato", "contrato");
        $form->contrato->option("", "Seleccionar");
        $form->contrato->options("SELECT codigo,CONCAT_ws(' ',codigo,nombre) nom FROM noco ORDER BY nombre");
        $form->contrato->rule = 'required';
        $form->contrato2 = new dropdownField("Aplicar a", "contrato2");
        //$form->contrato2->options("SELECT codigo,CONCAT_ws(' ',codigo,nombre) nom FROM noco WHERE tipo<>'O' ORDER BY nombre");
        $form->fechac = new dateonlyField("Fecha de corte", "fechac");
        $form->fechac->rule = 'required|chfecha';
        $form->fechac->insertValue = date("Y-m-d");
        $form->fechac->size = 12;
        $form->fechap = new dateonlyField("Fecha de pago", "fechap");
        $form->fechap->rule = 'required|chfecha';
        $form->fechap->insertValue = date("Y-m-d");
        $form->fechap->size = 12;
        $form->submit("btnsubmit", "Generar");
        $form->build_form();
        if ($form->on_success()) {
            $this->load->dbforge();
            $contrato = $form->contrato->newValue;
            $contratoe = $this->db->escape($form->contrato->newValue);
            $trabajae = NULL;
            $contrato2 = $form->contrato2->newValue;
            $contrato2e = $this->db->escape($form->contrato2->newValue);
            $fechac = $form->fechac->newValue;
            $fechap = $form->fechap->newValue;
            $tabla = 'prenom';
            $tablap = 'pretab';
            $this->db->query("TRUNCATE {$tabla}");
            $this->db->query("TRUNCATE {$tablap}");
            if (!empty($contrato2)) {
                $scontratoe = $contratoe;
                $trabajae = $contrato2e;
                $wcontratoe = $contrato2e;
                $mSQL = "INSERT IGNORE INTO {$tabla} (contrato, codigo,nombre, concepto, grupo, tipo, descrip, formula, monto, fecha, fechap,cuota,cuotat,pprome,trabaja,modo,orden,vari1,vari2,vari3,vari4,vari5,vari6,vari7,vari8) ";
                $mSQL .= "SELECT {$scontratoe}, b.codigo, CONCAT(RTRIM(b.apellido),' ',b.nombre) nombre, ";
                $mSQL .= "a.concepto, a.grupo, a.tipo, a.descrip, a.formula, 0, {$fechac}, {$fechap} , 0, 0, 0, {$trabajae},modo,e.orden,b.vari1,b.vari2,b.vari3,b.vari4,b.vari5,b.vari6,b.vari7,b.vari8 ";
                $mSQL .= "FROM conc a ";
                $mSQL .= "JOIN itnoco c ON a.concepto=c.concepto ";
                $mSQL .= "JOIN noco d ON c.codigo=d.codigo ";
                $mSQL .= "JOIN itnoco e ON d.codigo=e.codigo ";
                $mSQL .= "JOIN pers b ON {$scontratoe}=c.codigo ";
                $mSQL .= "WHERE b.contrato={$wcontratoe} AND b.status='A' ";
            } else {
                $scontratoe = $contratoe;
                $trabajae = $this->db->escape('');
                $wcontratoe = $contratoe;
                $mSQL = "INSERT IGNORE INTO {$tabla} (contrato, codigo,nombre, concepto, grupo, tipo, descrip, formula, monto, fecha, fechap,cuota,cuotat,pprome,trabaja,modo,orden,vari1,vari2,vari3,vari4,vari5,vari6,vari7,vari8) ";
                $mSQL .= "SELECT {$scontratoe}, b.codigo, CONCAT(RTRIM(b.apellido),'/',b.nombre) nombre, ";
                $mSQL .= "a.concepto, a.grupo, a.tipo, a.descrip, a.formula, 0, {$fechac}, {$fechap} , 0, 0, 0, {$trabajae},modo,c.orden,b.vari1,b.vari2,b.vari3,b.vari4,b.vari5,b.vari6,b.vari7,b.vari8 ";
                $mSQL .= "FROM conc a JOIN itnoco c ON a.concepto=c.concepto ";
                $mSQL .= "JOIN noco d ON c.codigo=d.codigo ";
                $mSQL .= "JOIN pers b ON b.contrato=d.codigo \r\n\t\t\t\tWHERE d.codigo={$wcontratoe} AND b.status='A' ";
            }
            $this->db->query($mSQL);
            $fields = $this->db->list_fields($tablap);
            $ii = count($fields);
            for ($i = 5; $i < $ii; $i++) {
                $this->dbforge->drop_column($tablap, $fields[$i]);
            }
            unset($fields);
            $query = $this->db->query("SELECT concepto FROM itnoco WHERE codigo={$scontratoe} ORDER BY concepto");
            foreach ($query->result() as $row) {
                $ind = 'c' . trim($row->concepto);
                $fields[$ind] = array('type' => 'decimal(17,2)', 'default' => 0);
            }
            $this->dbforge->add_column($tablap, $fields);
            unset($fields);
            $frec = $this->datasis->dameval("SELECT tipo FROM noco WHERE codigo={$scontratoe}");
            $this->calculaprenom();
            redirect('nomina/prenom/montos');
        }
        $atts = array('width' => '420', 'height' => '300', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5');
        $atts2 = array('width' => '1024', 'height' => '768', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
        $atts3 = array('width' => '420', 'height' => '240', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5', 'id' => 'recibo');
        $contratoactual = $this->datasis->dameval("SELECT b.nombre FROM prenom a JOIN noco b ON a.contrato=b.codigo LIMIT 1");
        $des01 = '';
        if ($contratoactual) {
            $des01 = "<div style='background-color:black;padding:5px;color:red;' ><strong>{$contratoactual}</strong></div>";
        }
        $des0 = new containerField("", $des01);
        $des0->build();
        $des3 = "<strong>Prenomina:</strong> es el termino utilizado para referirse a la nomina en la cual se esta trabajando que pertenece a un contrato y a una fecha dada. En la prenomina es el momento donde se introducen valores extra para los conceptos de nomina. por ejemplo la cantidad de horas extra trabajadas. y de donde se imprimen los recibos de pagos para los empleados";
        $des2 = new containerField("", "<div style='background-color:#EEDDEE;padding:5px;'> " . $des3 . "</div>");
        $des2->build();
        $des4 = new containerField("", "<div style='background-color:#FFDDFF;padding:5px;'> " . anchor('', '<span id="guarda">Guardar Prenomina Actual</span>') . " Este se utiliza para almacenar la prenomina en la que se esta trabajando y porder continuar con otra sin perder los cambios realizados a esta</div>");
        $des4->build();
        $des5 = new containerField("", "<div style='background-color:#DDDDFF;padding:5px;'> " . anchor('nomina/prenom/montos', 'Modificar Prenomina Actual') . " Este se utiliza para continuar introduciendo valores a conceptos de la prenomina actual</div>");
        $des5->build();
        $des10 = new containerField("", "<div style='background-color:#DDFFFF;padding:5px;'> " . anchor('nomina/prenom/calculaprenom', 'Recalcular Prenomina') . " Recalcular montos de la prenomina de haber cambiado sueldos formulas</div>");
        $des10->build();
        $des6 = new containerField("", "<div style='background-color:#EEFFEE;padding:5px;'> " . anchor_popup('reportes/ver/PRENOM/-1', 'Ver Listado de Prenomina', $atts) . " Este Muestra el listado de prenomina actual en formatos pdf. o .xls</div>");
        $des6->build();
        //$des8 = new containerField("","<div style='background-color:#CCEEEE;padding:5px;'> ".anchor_popup('nomina/recibo/','Imprimir recibos de pago',$atts2)." Abre el modulo de impresion de recibos de pago, donde hay distintas opciones de impresion</div>");
        //$des8->build();
        $des7 = new containerField("", "<div style='background-color:#FFCCFF;padding:5px;'> " . anchor_popup('nomina/prenom/creanomi', '<span id="pagar">Crear Nomina en Base a Prenomina</span>', $atts2) . "Esta es la ultima operacion a realizar para una prenomina, la cual convierte la prenomina actual en una nomina.</div>");
        $des7->build();
        $t = array();
        $t[1][1] = $form->output;
        $t[2][1] = "<strong>Generar una Prenomina:</strong> </br>Se utiliza para calcular los saldos de un contrato y sus trabajadores para una fecha.</br> Este borra la prenomina anterior y genera la nueva prenomina con los nuevos datos, para luego introducir los valores necesarios por cada concepto de ser necesario.";
        $table = new DataTable(null, $t);
        $table->cell_attributes = 'style="vertical-align:middle; text-align: center;"';
        $table->per_row = 2;
        $table->cell_attributes = 'style="vertical-align:top;background-color:#DDFFFF;text-align: left;"';
        $table->cell_template = "<#1#>";
        $table->build();
        $t = array();
        $t[1][1] = $form1->output;
        $t[2][1] = "<strong>Recuperar Prenomina:</strong> </br>Esta opcion es para utilizar un prenomina previamente almacenada y continuar modificandola o terminarla.</br>Esta opcion borra los datos de la prenomina actual";
        $table2 = new DataTable(null, $t);
        $table2->cell_attributes = 'style="vertical-align:middle; text-align: center;"';
        $table2->per_row = 2;
        $table2->cell_attributes = 'style="vertical-align:top;background-color:#FFFFDD;text-align: left;"';
        $table2->cell_template = "<#1#>";
        $table2->build();
        $cant = new dropdownField("cant", "cant");
        $cant->status = 'create';
        for ($i = 1; $i < 5; $i++) {
            $cant->option($i, $i);
        }
        $cant->style = "width:40px;";
        $cant->build();
        $des9 = new containerField("", "<div style='background-color:#EEEECC;padding:5px;'> " . $cant->output . ' Copias de ' . anchor('#', 'Recibos de Pago', $atts3) . " Este genera los recibos de pagos para toda la prenomina.</div>");
        $des9->build();
Пример #29
0
 function load()
 {
     $this->load->library('path');
     $this->load->helper('html');
     $path = new Path();
     $path->setPath($this->config->item('uploads_dir'));
     $path->append('/archivos');
     $this->upload_path = $path->getPath() . '/';
     $this->rapyd->load('dataform');
     $form = new DataForm($this->url . 'load/process');
     $form->title('Importar Archivos');
     $form->explica1 = new containerField('', "<p style='color:blue;background-color:C6DAF6;align:center'>Para cargar un nuevo archivo de data seleccionelo en el el bot&oacute;n Examinar y luego presione enviar.</p>");
     $form->container = new containerField('adver', 'Solo archivos en formato EXCEL 97, asegurese de que la informacion que desea importar este en la hoja 1.');
     $form->archivo = new uploadField('Archivo', 'archivo');
     $form->archivo->upload_path = '';
     $form->archivo->allowed_types = 'xls';
     $form->archivo->delete_file = false;
     $form->archivo->upload_root = '/tmp';
     $form->archivo->rule = 'required';
     $form->archivo->append('Solo archivos en formato xls (Excel 97-2003)');
     $form->submit('btnsubmit', 'Enviar');
     $form->build_form();
     $rti = '';
     if ($form->on_success()) {
         $idtabla = intval($this->datasis->dameval('SELECT MAX(id_tabla) AS maxid FROM ' . $this->tabla));
         $idtabla++;
         $arch = '/tmp/' . $form->archivo->upload_data['file_name'];
         $rt = $this->_xlsread($arch, $idtabla);
         $rti = "<p>{$rt}</p>";
     }
     $lista = array();
     $mSQL = 'SELECT id_tabla,COUNT(*) AS cana  FROM ' . $this->tabla . ' GROUP BY id_tabla ORDER BY id_tabla DESC LIMIT 10';
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         foreach ($query->result() as $row) {
             $lista[] = anchor($this->url . 'procesar/' . $row->id_tabla, 'Tabla: ' . $row->id_tabla . ' (' . $row->cana . ' registros).');
         }
         $listaul = '<h2>Tablas ya importadas</h2>' . ul($lista);
     } else {
         $listaul = '';
     }
     $data['content'] = $rti . $form->output . $listaul;
     $data['title'] = heading('Importaci&oacute;n de data desde archivos');
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Пример #30
0
 function email()
 {
     $this->datasis->modulo_id('923', 1);
     $this->rapyd->load('dataform');
     $form = new DataForm('sincro/notifica/email/process');
     $form->to = new inputField('Destinatario', 'to');
     $form->to->rule = 'valid_emails|required';
     //$form->to->maxlength =7;
     //$form->to->size =20;
     $form->subject = new inputField('Asunto', 'subject');
     //$form->subject->size =20;
     $form->body = new textareaField('Mensaje', 'body');
     $form->body->rule = 'required';
     $form->submit('btnsubmit', 'Enviar');
     $form->build_form();
     if ($form->on_success()) {
         $to = $form->to->newValue;
         $subject = empty($form->subject->newValue) ? 'Sin asunto' : $form->subject->newValue;
         $body = $form->body->newValue;
         $rt = $this->_mail($to, $subject, $body);
         if (!$rt) {
             $form->error_string = $this->error;
             $form->build_form();
             $salida = $form->output . br();
         } else {
             $salida = $form->output . br() . 'Tu mensaje ha sido enviado satisfactoriamente';
         }
     } else {
         $salida = $form->output;
     }
     $this->rapyd->jquery[] = '$(".inputnum").numeric(".");';
     $data['content'] = $salida;
     $data['title'] = '<h1>Env&iacute;os de correos electr&oacute;nicos</h1>';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }