function dataedit() { $this->rapyd->load('dataedit', 'dataobject'); $script = ' function consulmv(){ mnumero=$("#numero").val(); if(mnumero.length==0){ alert("Debe introducir primero el numero de certificado"); }else{ mnumero=mnumero.toUpperCase(); $("#numero").val(mnumero); window.open("' . site_url('ventas/mvcerti/traepdf/') . '/"+encodeURIComponent(mnumero),"CONSULTA MV","height=350,width=410"); } return false; } $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); $("#cliente").autocomplete({ delay: 600, autoFocus: true, source: function(req, add){ $.ajax({ url: "' . site_url('ajax/buscascli') . '", type: "POST", dataType: "json", data: {"q":req.term}, success: function(data){ var sugiere = []; if(data.length==0){ $("#sclinombre").val(""); $("#sclinombre_val").text(""); $("#sclirifci").val(""); $("#sclirifci_val").text(""); }else{ $.each(data, function(i, val){ sugiere.push( val ); } ); } add(sugiere); }, }) }, minLength: 2, select: function( event, ui ) { $("#cliente").attr("readonly", "readonly"); $("#sclinombre").val(ui.item.nombre); $("#sclinombre_val").text(ui.item.nombre); $("#sclirifci").val(ui.item.rifci); $("#sclirifci_val").text(ui.item.rifci); setTimeout(function() { $("#cliente").removeAttr("readonly"); }, 1500); } }); });'; $do = new DataObject('mvcerti'); $do->pointer('scli', 'mvcerti.cliente =scli.cliente', '`scli`.`nombre` AS sclinombre, `scli`.`rifci` AS sclirifci', 'left'); $edit = new DataEdit('', $do); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->numero = new inputField('Número', 'numero'); $edit->numero->rule = 'required|strtoupper|trim|unique'; $edit->numero->mode = 'autohide'; $edit->numero->size = 34; $edit->numero->maxlength = 32; $edit->numero->append('<a href="#" onclick="consulmv();">Consultar</a>'); $edit->status = new dropdownField('Estatus', 'status'); $edit->status->option('A', 'Activo'); $edit->status->option('C', 'Cerrado'); $edit->status->style = 'width:120px;'; $edit->status->rule = 'required|enum[A,C]'; $edit->cliente = new inputField('Cliente', 'cliente'); $edit->cliente->rule = 'required|existescli'; $edit->cliente->size = 7; $edit->nombre = new inputField('Nombre', 'sclinombre'); $edit->nombre->type = 'inputhidden'; $edit->nombre->pointer = true; $edit->nombre->in = 'cliente'; $edit->rifci = new inputField('RIF/CI', 'sclirifci'); $edit->rifci->type = 'inputhidden'; $edit->rifci->pointer = true; $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->insertValue = date('Y-m-d'); $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->calendar = false; $edit->obra = new textareaField('Obra', 'obra'); $edit->obra->cols = 40; $edit->obra->rows = 2; $edit->obra->rule = 'required'; //$edit->obra->maxlength =200; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit = new DataEdit('', 'estado'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->codigo = new inputField('Codigo', 'codigo'); $edit->codigo->rule = 'integer'; $edit->codigo->css_class = 'inputonlynum'; $edit->codigo->size = 6; $edit->codigo->maxlength = 10; $edit->codigo->mode = 'autohide'; $edit->entidad = new inputField('Entidad', 'entidad'); $edit->entidad->rule = ''; $edit->entidad->size = 30; $edit->entidad->maxlength = 80; $edit->capital = new inputField('Capital', 'capital'); $edit->capital->rule = ''; $edit->capital->size = 30; $edit->capital->maxlength = 80; $edit->superficie = new inputField('Superficie', 'superficie'); $edit->superficie->rule = 'numeric'; $edit->superficie->css_class = 'inputnum'; $edit->superficie->size = 12; $edit->superficie->maxlength = 10; $edit->poblacion = new inputField('Poblacion', 'poblacion'); $edit->poblacion->rule = 'integer'; $edit->poblacion->css_class = 'inputonlynum'; $edit->poblacion->size = 13; $edit->poblacion->maxlength = 11; $edit->municipios = new inputField('Municipios', 'municipios'); $edit->municipios->rule = 'integer'; $edit->municipios->css_class = 'inputonlynum'; $edit->municipios->size = 13; $edit->municipios->maxlength = 11; $edit->parroquias = new inputField('Parroquias', 'parroquias'); $edit->parroquias->rule = 'integer'; $edit->parroquias->css_class = 'inputonlynum'; $edit->parroquias->size = 13; $edit->parroquias->maxlength = 11; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit = new DataEdit($this->t**s, 'pactivo'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = ''; $edit->nombre->size = 252; $edit->nombre->maxlength = 250; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); }); '; $edit = new DataEdit($this->t**s, 'sfacfis'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->tipo_doc = new dropdownField('Tipo Doc.', 'tipo_doc'); $edit->tipo_doc->option('FC', 'Factura'); $edit->tipo_doc->option('ND', 'Devolución'); $edit->tipo_doc->style = 'width:140px;'; $edit->tipo_doc->size = 5; $edit->tipo_doc->rule = 'required'; $edit->referencia = new inputField('Referencia', 'referencia'); $edit->referencia->rule = ''; $edit->referencia->size = 12; $edit->referencia->maxlength = 10; $edit->caja = new inputField('Caja', 'caja'); $edit->caja->rule = ''; $edit->caja->size = 7; $edit->caja->maxlength = 5; $edit->serial = new inputField('Serial', 'serial'); $edit->serial->rule = ''; $edit->serial->size = 17; $edit->serial->maxlength = 15; $edit->rifci = new inputField('RIF/CI', 'rifci'); $edit->rifci->rule = ''; $edit->rifci->size = 17; $edit->rifci->maxlength = 15; $edit->cajero = new inputField('Cajero', 'cajero'); $edit->cajero->rule = ''; $edit->cajero->size = 17; $edit->cajero->maxlength = 15; $edit->numero = new inputField('Número', 'numero'); $edit->numero->rule = ''; $edit->numero->size = 12; $edit->numero->maxlength = 10; $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->insertValue = date('Y-m-d'); $edit->fecha->calendar = false; $edit->hora = new dateonlyField('Hora', 'hora'); $edit->hora->rule = 'chora'; $edit->hora->size = 10; $edit->hora->maxlength = 8; $edit->baseg = new inputField('Base G.', 'baseg'); $edit->baseg->rule = 'numeric'; $edit->baseg->css_class = 'inputnum'; $edit->baseg->size = 12; $edit->baseg->maxlength = 10; $edit->ivag = new inputField('Iva G.', 'ivag'); $edit->ivag->rule = 'numeric'; $edit->ivag->css_class = 'inputnum'; $edit->ivag->size = 12; $edit->ivag->maxlength = 10; $edit->alicuotag = new inputField('Alicuota G.', 'alicuotag'); $edit->alicuotag->rule = 'numeric'; $edit->alicuotag->css_class = 'inputnum'; $edit->alicuotag->size = 7; $edit->alicuotag->maxlength = 5; $edit->baser = new inputField('Base R.', 'baser'); $edit->baser->rule = 'numeric'; $edit->baser->css_class = 'inputnum'; $edit->baser->size = 12; $edit->baser->maxlength = 10; $edit->ivar = new inputField('Iva R.', 'ivar'); $edit->ivar->rule = 'numeric'; $edit->ivar->css_class = 'inputnum'; $edit->ivar->size = 12; $edit->ivar->maxlength = 10; $edit->alicuotar = new inputField('Alicuota R.', 'alicuotar'); $edit->alicuotar->rule = 'numeric'; $edit->alicuotar->css_class = 'inputnum'; $edit->alicuotar->size = 7; $edit->alicuotar->maxlength = 5; $edit->basea = new inputField('Base A.', 'basea'); $edit->basea->rule = 'numeric'; $edit->basea->css_class = 'inputnum'; $edit->basea->size = 12; $edit->basea->maxlength = 10; $edit->ivaa = new inputField('Iva A.', 'ivaa'); $edit->ivaa->rule = 'numeric'; $edit->ivaa->css_class = 'inputnum'; $edit->ivaa->size = 12; $edit->ivaa->maxlength = 10; $edit->alicuotaa = new inputField('Alicuota A.', 'alicuotaa'); $edit->alicuotaa->rule = 'numeric'; $edit->alicuotaa->css_class = 'inputnum'; $edit->alicuotaa->size = 7; $edit->alicuotaa->maxlength = 5; $edit->exento = new inputField('Exento', 'exento'); $edit->exento->rule = 'numeric'; $edit->exento->css_class = 'inputnum'; $edit->exento->size = 12; $edit->exento->maxlength = 10; $edit->total = new inputField('Total', 'total'); $edit->total->rule = 'numeric'; $edit->total->css_class = 'inputnum'; $edit->total->size = 12; $edit->total->maxlength = 10; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function decliente() { $this->rapyd->load('dataedit'); $script = ''; $edit = new DataEdit('', 'spreml'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'create'); $edit->post_process('insert', '_clpost_insert'); $edit->post_process('update', '_clpost_update'); $edit->post_process('delete', '_clpost_delete'); $edit->pre_process('insert', '_clpre_insert'); $edit->pre_process('update', '_clpre_update'); $edit->pre_process('delete', '_clpre_delete'); $edit->numero = new inputField('Nro. Orden', 'numero'); $edit->numero->rule = ''; $edit->numero->size = 8; $edit->numero->maxlength = 8; $edit->numero->rule = 'required'; $edit->numero->title = 'Numero de la orden que recibio por email'; $edit->mercalib = new inputField('Alias Mercado Libre', 'mercalib'); $edit->mercalib->rule = ''; $edit->mercalib->size = 20; $edit->mercalib->maxlength = 50; $edit->mercalib->rule = 'required'; $edit->mercalib->title = 'Nombre de la cuenta en mercado libre'; $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->calendar = false; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->insertValue = date('Y-m-d'); $edit->rifci = new inputField('Cedula/RIF', 'rifci'); $edit->rifci->size = 10; $edit->rifci->maxlength = 13; $edit->rifci->rule = 'required'; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = ''; $edit->nombre->size = 31; $edit->nombre->maxlength = 40; $edit->nombre->rule = 'required'; $edit->direccion = new textareaField('Direccion', 'direccion'); $edit->direccion->rule = ''; $edit->direccion->cols = 50; $edit->direccion->rows = 2; $edit->estado = new dropdownField('Estado', 'estado'); $edit->estado->style = 'width:160px;'; $edit->estado->option('', 'Seleccione un Estado'); $edit->estado->options('SELECT codigo, entidad FROM estado ORDER BY entidad'); $edit->estado->insertValue = $this->datasis->dameval("SELECT codigo FROM estado WHERE entidad=" . $this->db->escape(trim($this->datasis->traevalor('ESTADO')))); $edit->ciudad = new inputField('Ciudad', 'ciudad'); $edit->ciudad->rule = ''; $edit->ciudad->size = 18; $edit->ciudad->maxlength = 40; $edit->ciudad->rule = 'required'; $edit->email = new inputField('Email', 'email'); $edit->email->rule = ''; $edit->email->size = 20; $edit->email->maxlength = 100; $edit->email->rule = 'required'; $edit->telefono = new inputField('Telefono', 'telefono'); $edit->telefono->rule = ''; $edit->telefono->size = 17; $edit->telefono->maxlength = 30; $edit->telefono->rule = 'required'; $edit->envrifci = new inputField('Cedula/RIF', 'envrifci'); $edit->envrifci->rule = ''; $edit->envrifci->size = 10; $edit->envrifci->maxlength = 13; $edit->envnombre = new inputField('Nombre', 'envnombre'); $edit->envnombre->rule = ''; $edit->envnombre->size = 31; $edit->envnombre->maxlength = 40; $edit->envdirec = new textareaField('Direccion o Agencia Zoom de Envio', 'envdirec'); $edit->envdirec->rule = ''; $edit->envdirec->cols = 50; $edit->envdirec->rows = 2; $edit->envestado = new dropdownField('Estado', 'envestado'); $edit->envestado->style = 'width:160px;'; $edit->envestado->option('', 'Seleccione un Estado'); $edit->envestado->options('SELECT codigo, entidad FROM estado ORDER BY entidad'); $edit->envestado->insertValue = $this->datasis->dameval("SELECT codigo FROM estado WHERE entidad=" . $this->db->escape(trim($this->datasis->traevalor('ESTADO')))); $edit->envciudad = new inputField('Ciudad', 'envciudad'); $edit->envciudad->rule = ''; $edit->envciudad->size = 18; $edit->envciudad->maxlength = 40; $edit->envtelef = new inputField('Telefono', 'envtelef'); $edit->envtelef->rule = ''; $edit->envtelef->size = 17; $edit->envtelef->maxlength = 30; $edit->codbanc = new dropdownField('Banco', 'codbanc'); $edit->codbanc->option('', 'Seleccionar'); $edit->codbanc->options('SELECT codbanc, CONCAT(banco,\' \',numcuent) banco FROM banc WHERE activo="S" AND tipocta="C" ORDER BY banco'); $edit->codbanc->style = 'width:180px;'; $edit->codbanc->size = 2; $edit->codbanc->rule = 'required'; $edit->tipo_op = new dropdownField('Tipo', 'tipo_op'); $edit->tipo_op->option('', 'Seleccionar'); $edit->tipo_op->options(array('NC' => 'Transferencia', 'DE' => 'Deposito')); $edit->tipo_op->style = 'width:97px'; $edit->tipo_op->rule = 'required'; $edit->fechadep = new DateonlyField('Fecha', 'fechadep', 'd/m/Y'); $edit->fechadep->insertValue = date('Y-m-d'); $edit->fechadep->updateValue = date('Y-m-d'); $edit->fechadep->rule = 'required'; $edit->fechadep->size = 10; $edit->fechadep->calendar = false; $edit->num_ref = new inputField('Nro de referencia', 'num_ref'); $edit->num_ref->rule = 'required'; $edit->num_ref->size = 15; $edit->num_ref->maxlength = 20; $edit->agencia = new inputField('Agencia Zoom', 'agencia'); $edit->agencia->size = 20; $edit->agencia->maxlength = 50; $edit->totalg = new inputField('Monto', 'totalg'); $edit->totalg->rule = 'numeric'; $edit->totalg->css_class = 'inputnum'; $edit->totalg->size = 10; $edit->totalg->maxlength = 12; $edit->totalg->readonly = true; $edit->observa = new textareaField('Observacion', 'observa'); $edit->observa->rule = ''; $edit->observa->cols = 50; $edit->observa->rows = 3; $edit->buttons('modify', 'save', 'undo', 'delete', 'back'); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); //echo json_encode($rt); $contenido = ' <h1>Felicitaciones !!!</h1> <p>Su información ha sido recibida satisfactoriamente. Una vez confirmado su pago procederemos a hacer el despacho de su artículo. En un lapso de 24 Horas le haremos llegar a su correo el número de guia Zoom correspondiente.</p> <h1>Gracias por su Compra!!!</h1> <button onclick="volver()">Volver</button> <script> function volver(){ window.location.href = "' . site_url('ventas/spreml/decliente/create') . '"; } </script> '; $data['content'] = $contenido; $data["head"] = script("jquery-min.js"); $data["head"] .= $this->rapyd->get_head(); $data["head"] .= style("rapyd.css"); $data["head"] .= style("themes/proteo/proteo.css"); $data["head"] .= style("themes/darkness/darkness.css"); $data["head"] .= style("themes/anexos1/anexos1.css"); $data["target"] = 'dialogo'; $data['title'] = heading('Registro de Pago'); $this->load->view('view_ventanas', $data); } else { //echo $edit->output; $estilo = ' <style > .ui-autocomplete {max-height: 150px;overflow-y: auto;max-width: 600px;} html.ui-autocomplete {height: 150px;width: 600px;} </style>'; $estilo = ' <script language="javascript" type="text/javascript"> $(function(){ $( document ).tooltip(); $("#fechadep").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); $("#rifci").focusout(function(){ rif=$(this).val(); traenombre( rif, "nombre" ) }); $("#envrifci").focusout(function(){ rif=$(this).val(); traenombre( rif, "envnombre" ) }); $("#mercalib").focusout(function(){ numer = $("#numero").val(); merca = $("#mercalib").val(); $.ajax({ type: "POST", url: "' . site_url('ventas/spreml/buscaspre') . '", dataType: "json", data: {numero: numer, mercalib: merca}, success: function(data){ if(data.error==0){ $("#totalg").val(data.monto); $("#producto").html(data.producto); } else { alert(data.msj); $("#numero").focus(); } } }); }); }); ' . $this->datasis->traenombre() . ' ' . $this->datasis->validarif() . ' </script> '; $conten["form"] =& $edit; $data['content'] = $this->load->view('view_sprecl', $conten, true); $data["head"] = script("jquery-min.js"); $data["head"] .= script("jquery-migrate-min.js"); $data["head"] .= script("jquery-ui.custom.min.js"); $data["head"] .= script("plugins/jquery.numeric.pack.js"); $data["head"] .= script("plugins/jquery.floatnumber.js"); $data["head"] .= $this->rapyd->get_head(); $data["head"] .= style("rapyd.css"); $data["head"] .= style("themes/proteo/proteo.css"); $data["head"] .= style("themes/darkness/darkness.css"); $data["head"] .= style("themes/anexos1/anexos1.css"); $data["head"] .= $estilo; $data["target"] = 'dialogo'; $data['title'] = heading('Registro de Pago'); $this->load->view('view_ventanas', $data); } }
function dataedit() { $this->rapyd->load('dataedit'); $edit = new DataEdit('', 'lprecio'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $script = ' $(function() { $("#fecha" ).datepicker({dateFormat:"dd/mm/yy"}); });'; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->fecha = new dateField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->calendar = false; $edit->tarifa1 = new inputField('Leche de Vaca Fria', 'tarifa1'); $edit->tarifa1->rule = 'numeric'; $edit->tarifa1->css_class = 'inputnum'; $edit->tarifa1->size = 12; $edit->tarifa1->maxlength = 10; $edit->tarifa2 = new inputField('Leche de Vaca Caliente', 'tarifa2'); $edit->tarifa2->rule = 'numeric'; $edit->tarifa2->css_class = 'inputnum'; $edit->tarifa2->size = 12; $edit->tarifa2->maxlength = 10; $edit->tarifa3 = new inputField('Leche de Bufala Fria', 'tarifa3'); $edit->tarifa3->rule = 'numeric'; $edit->tarifa3->css_class = 'inputnum'; $edit->tarifa3->size = 12; $edit->tarifa3->maxlength = 10; $edit->tarifa4 = new inputField('Leche de Bufala Caliente', 'tarifa4'); $edit->tarifa4->rule = 'numeric'; $edit->tarifa4->css_class = 'inputnum'; $edit->tarifa4->size = 12; $edit->tarifa4->maxlength = 10; $edit->tarifa5 = new inputField('Machiques Fria', 'tarifa5'); $edit->tarifa5->rule = 'numeric'; $edit->tarifa5->css_class = 'inputnum'; $edit->tarifa5->size = 12; $edit->tarifa5->maxlength = 10; $edit->tarifa6 = new inputField('Machiques Caliente', 'tarifa6'); $edit->tarifa6->rule = 'numeric'; $edit->tarifa6->css_class = 'inputnum'; $edit->tarifa6->size = 12; $edit->tarifa6->maxlength = 10; $edit->enfria = new inputField('Enfriamiento', 'enfria'); $edit->enfria->rule = 'numeric'; $edit->enfria->css_class = 'inputnum'; $edit->enfria->size = 12; $edit->enfria->maxlength = 10; $edit->bacteria = new inputField('Calidad Bacteriologica', 'bacteria'); $edit->bacteria->rule = 'numeric'; $edit->bacteria->css_class = 'inputnum'; $edit->bacteria->size = 12; $edit->bacteria->maxlength = 10; $edit->grasa = new inputField('Porcentaje de Grasa', 'grasa'); $edit->grasa->rule = 'numeric'; $edit->grasa->css_class = 'inputnum'; $edit->grasa->size = 12; $edit->grasa->maxlength = 10; $edit->build(); $script = ''; if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' var mtasa = 12; $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $("#inicio").datepicker({dateFormat:"dd/mm/yy"}); $("#final").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); }); '; $script .= ' $("#cliente").autocomplete({ source: function( req, add){ $.ajax({ url: "' . site_url('ajax/buscascli') . '", type: "POST", dataType: "json", data: {"q":req.term}, success: function(data){ var sugiere = []; if(data.length==0){ $("#cliente").val(""); $("#nombre").html(""); apprise("Cliente inexistente"); }else{ $.each(data, function(i, val){ sugiere.push( val ); } ); } add(sugiere); }, }) }, minLength: 2, select: function( event, ui ){ $("#cliente").attr("readonly", "readonly"); $("#cliente").val(ui.item.value); $("#nombre").html(ui.item.nombre); setTimeout(function() { $("#cliente").removeAttr("readonly"); }, 1500); } }); '; $script .= ' $("#codigo").autocomplete({ delay: 600, autoFocus: true, source: function( req, add){ $.ajax({ url: "' . site_url("ajax/buscasinv") . '", type: "POST", dataType: "json", data: {"q":req.term.trim(), "alma": "0001" }, success: function(data){ var sugiere = []; if(data.length==0){ $("#codigoa").val("") $("#descrip").val(""); $("#base").val(""); $("#iva").val(""); $("#precio").val(""); }else{ $.each(data, function(i, val){ sugiere.push( val ); } ); add(sugiere); } }, }) }, minLength: 2, select: function( event, ui ){ var cana = $("#cantidad").val(); mtasa = ui.item.iva; $("#codigo").attr("readonly", "readonly"); $("#codigo").val(ui.item.value); $("#descrip").val(ui.item.descrip); if ( !cana ){ $("#cantidad").val(1); } $("#precio").val(ui.item.base1); $("#base").val(ui.item.base1); totaliza(); setTimeout(function() { $("#codigo").removeAttr("readonly"); }, 1500); } }); '; $script .= ' function totaliza(){ var iva = 0; var precio = 0; var base = 0; var importe = 0; var cantidad = 0; cantidad = Number($("#cantidad").val()) precio = Number($("#precio").val()); base = roundNumber(cantidad*precio,2); iva = roundNumber(base*mtasa/100,2); importe = base+iva; $("#base").val(base); $("#iva").val(iva); $("#importe").val(importe); } '; $script .= ' $("#cantidad").change(function () { totaliza(); }) $("#precio").change(function () { totaliza(); }) '; $edit = new DataEdit('', 'sclicont'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->numero = new inputField('Numero', 'numero'); $edit->numero->rule = ''; $edit->numero->size = 10; $edit->numero->maxlength = 8; $edit->status = new dropdownField('Estatus', 'status'); $edit->status->options(array('A' => 'Activo', 'S' => 'Suspendido', 'T' => 'Terminado')); $edit->status->style = 'width:80px'; $edit->status->rule = 'required'; $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->calendar = false; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->insertValue = date('Y-m-d'); $edit->inicio = new dateonlyField('Inicio', 'inicio'); $edit->inicio->rule = 'chfecha'; $edit->inicio->calendar = false; $edit->inicio->size = 10; $edit->inicio->maxlength = 8; $edit->final = new dateonlyField('Final', 'final'); $edit->final->rule = 'chfecha'; $edit->final->calendar = false; $edit->final->size = 10; $edit->final->maxlength = 8; $edit->cliente = new inputField('Cliente', 'cliente'); $edit->cliente->rule = ''; $edit->cliente->size = 7; $edit->cliente->maxlength = 5; $edit->codigo = new inputField('Codigo', 'codigo'); $edit->codigo->rule = ''; $edit->codigo->size = 14; $edit->codigo->maxlength = 15; $edit->descrip = new textareaField('Descripcion', 'descrip'); $edit->descrip->rule = ''; $edit->descrip->cols = 35; $edit->descrip->rows = 2; $edit->cantidad = new inputField('Cantidad', 'cantidad'); $edit->cantidad->rule = 'numeric'; $edit->cantidad->css_class = 'inputnum'; $edit->cantidad->size = 8; $edit->cantidad->maxlength = 17; $edit->base = new inputField('Base', 'base'); $edit->base->rule = 'numeric'; $edit->base->css_class = 'inputnum'; $edit->base->size = 16; $edit->base->maxlength = 17; $edit->base->readonly = true; $edit->iva = new inputField('IVA', 'iva'); $edit->iva->rule = 'numeric'; $edit->iva->css_class = 'inputnum'; $edit->iva->size = 16; $edit->iva->maxlength = 17; $edit->iva->readonly = true; $edit->precio = new inputField('Precio', 'precio'); $edit->precio->rule = 'numeric'; $edit->precio->css_class = 'inputnum'; $edit->precio->size = 16; $edit->precio->maxlength = 17; $edit->importe = new inputField('Importe', 'importe'); $edit->importe->rule = 'numeric'; $edit->importe->readonly = true; $edit->importe->css_class = 'inputnum'; $edit->importe->size = 16; $edit->importe->maxlength = 17; $edit->observa = new textareaField('Observaciones', 'observa'); $edit->observa->rule = ''; $edit->observa->cols = 68; $edit->observa->rows = 2; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { $conten['form'] =& $edit; $data['content'] = $this->load->view('view_sclicont', $conten, false); } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit = new DataEdit($this->t**s, 'tbofici'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->codofi = new inputField('Codigo', 'codofi'); $edit->codofi->rule = ''; $edit->codofi->size = 7; $edit->codofi->maxlength = 5; $edit->codofi->mode = "autohide"; $edit->desofi = new inputField('Descripción', 'desofi'); $edit->desofi->rule = ''; $edit->desofi->size = 50; $edit->desofi->maxlength = 100; $edit->dirofi = new inputField('Dirección', 'dirofi'); $edit->dirofi->rule = ''; $edit->dirofi->size = 50; $edit->dirofi->maxlength = 100; $edit->telofi = new textareaField('Tel Oficina', 'telofi'); $edit->telofi->rule = 'trim'; $edit->telofi->cols = 47; $edit->telofi->rows = 2; $edit->telofi->maxlength = 50; $edit->gereofi = new inputField('Gerente', 'gereofi'); $edit->gereofi->rule = ''; $edit->gereofi->size = 50; $edit->gereofi->maxlength = 50; $edit->telegofi = new inputField('Tel Gerente', 'telegofi'); $edit->telegofi->rule = ''; $edit->telegofi->size = 50; $edit->telegofi->maxlength = 50; $edit->estado = new inputField('Estado', 'estado'); $edit->estado->rule = ''; $edit->estado->size = 50; $edit->estado->maxlength = 50; $edit->zona = new dropdownField('Zona', 'zona'); $edit->zona->rule = 'required'; $edit->zona->options('select codigo, CONCAT(codigo, " ", nombre) nombre FROM zona ORDER BY codigo'); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $link = site_url('finanzas/mgas/ultimo'); $script = ' function ultimo(){ $.ajax({ url: "' . $link . '", success: function(msg){ alert( "El ultimo codigo ingresado fue: " + msg ); } }); } function grupo(){ t=$("#grupo").val(); a=$("#grupo :selected").text(); $("#nom_grup").val(a); } $(function() { $(".inputnum").numeric("."); $("#grupo").change(function(){ t=$("#grupo").val(); a=$("#grupo :selected").text(); $("#nom_grup").val(a); }).change(); });'; $qformato = $this->datasis->formato_cpla(); $mCPLA = array('tabla' => 'cpla', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'cuenta'), 'titulo' => 'Buscar Cuenta', 'where' => "codigo LIKE \"{$qformato}\""); $bcpla = $this->datasis->modbus($mCPLA); $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5'); $edit = new DataEdit('Maestro de Gastos', 'mgas'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $ultimo = '<a href="javascript:ultimo();" title="Consultar ultimo codigo ingresado" onclick="">Consultar ultimo codigo</a>'; $edit->codigo = new inputField('Código', 'codigo'); $edit->codigo->mode = 'autohide'; $edit->codigo->size = 12; $edit->codigo->maxlength = 6; $edit->codigo->rule = 'trim|required||alpha_numeric|strtoupper|callback_chexiste'; $edit->codigo->append($ultimo); $edit->descrip = new inputField('Descripción', 'descrip'); $edit->descrip->size = 30; $edit->tipo = new dropdownField('Tipo', 'tipo'); $edit->tipo->style = 'width:100px;'; $edit->tipo->option('G', 'Gasto'); $edit->tipo->option('I', 'Inventario'); $edit->tipo->option('S', 'Suministro'); $edit->tipo->option('A', 'Activo Fijo'); $edit->grupo = new dropdownField('Grupo', 'grupo'); $edit->grupo->options('SELECT grupo, CONCAT(grupo," - ",nom_grup) nom_grup from grga order by nom_grup'); $edit->grupo->style = "width:200px;"; $lcuent = anchor_popup("/contabilidad/cpla/dataedit/create", image('list_plus.png', 'Agregar', array("border" => "0")), $atts); $edit->cuenta = new inputField("Cta. Contable", "cuenta"); $edit->cuenta->size = 12; $edit->cuenta->maxlength = 15; $edit->cuenta->rule = 'trim|existecpla'; $edit->cuenta->append($bcpla); //$edit->cuenta->append($lcuent); //$edit->cuenta->readonly=true; $lcuent = anchor_popup("/contabilidad/cpla/dataedit/create", image('list_plus.png', 'Agregar', array("border" => "0")), $atts); $edit->ctarein = new inputField("Cta. Reintegro", "ctarein"); $edit->ctarein->size = 12; $edit->ctarein->maxlength = 15; $edit->ctarein->rule = 'trim|existecpla'; $edit->ctarein->append($bcpla); //$edit->ctarein->append($lcuent); $edit->ctarein->readonly = true; /* $edit->iva = new inputField("IVA", "iva"); $edit->iva->css_class='inputnum'; $edit->iva->size =9; $edit->iva->maxlength =5; $edit->iva->rule ="trim"; */ $ivas = $this->datasis->ivaplica(); $edit->iva = new dropdownField('IVA %', 'iva'); foreach ($ivas as $tasa => $ivamonto) { $edit->iva->option($ivamonto, nformat($ivamonto)); } $edit->iva->style = 'width:100px;'; $edit->iva->insertValue = $ivas['tasa']; //$edit->iva->onchange='calculos(\'S\');'; //$edit->medida = new inputField("Unidad Medida", "medida"); //$edit->medida->size = 5; $AddUnidad = '<a href="javascript:add_unidad();" title="Haz clic para Agregar una unidad nueva">' . image('list_plus.png', 'Agregar', array("border" => "0")) . '</a>'; $edit->medida = new dropdownField('Medida', 'medida'); $edit->medida->style = 'width:100px;'; $edit->medida->option('', 'Seleccionar'); $edit->medida->options('SELECT unidades, unidades AS valor FROM unidad ORDER BY unidades'); $edit->medida->append($AddUnidad); $edit->fraxuni = new inputField('Cant. X Caja', 'fraxuni'); $edit->fraxuni->css_class = 'inputnum'; //no sirve $edit->fraxuni->group = 'Existencias'; $edit->fraxuni->size = 5; $edit->ultimo = new inputField('Costo', 'ultimo'); $edit->ultimo->css_class = 'inputnum'; //no sirve $edit->ultimo->size = 9; $edit->promedio = new inputField('Promedio', 'promedio'); $edit->promedio->css_class = 'inputnum'; //no sirve $edit->promedio->size = 9; $edit->minimo = new inputField('Mínima', 'minimo'); $edit->minimo->css_class = 'inputnum'; //no sirve $edit->minimo->group = 'Existencias'; $edit->minimo->size = 5; $edit->maximo = new inputField('Máxima', 'maximo'); $edit->maximo->css_class = 'inputnum'; //no sirve $edit->maximo->group = 'Existencias'; $edit->maximo->size = 5; $edit->unidades = new inputField('Cajas', 'unidades'); $edit->unidades->css_class = 'inputnum'; //no sirve $edit->unidades->group = 'Existencias'; $edit->unidades->size = 5; $edit->fraccion = new inputField('Fracciónes', 'fraccion'); $edit->fraccion->css_class = 'inputnum'; //no sirve $edit->fraccion->group = 'Existencias'; $edit->fraccion->size = 5; $edit->reten = new dropdownField('Natural.', 'reten'); $edit->reten->option('', 'Ninguno'); $edit->reten->options('SELECT codigo, CONCAT(codigo," - ",activida) val FROM rete WHERE tipo="NR" ORDER BY codigo'); $edit->reten->style = 'width:220px;'; $edit->retej = new dropdownField("Jurídica.", "retej"); $edit->retej->option('', 'Ninguno'); $edit->retej->options('SELECT codigo, CONCAT(codigo," - ",activida) val FROM rete WHERE tipo="JD" ORDER BY codigo'); $edit->retej->style = 'width:220px;'; $codigo = $edit->_dataobject->get('codigo'); $edit->almacenes = new containerField('almacenes', $this->_detalle($codigo)); $edit->almacenes->when = array('show', 'modify'); //$edit->buttons("modify", "save", "undo", "back"); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { $conten['form'] =& $edit; $this->load->view('view_mgas', $conten); } }
function dataedit() { $this->rapyd->load('dataedit'); $edit = new DataEdit($this->t**s, 'bconci'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->fecha = new dateonlyField('Fecha', 'fecha', 'm/Y'); $edit->fecha->mode = 'autohide'; $edit->fecha->rule = 'chfecha[m/Y]'; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->insertValue = date('Y-m-d', mktime(0, 0, 0, date('n'), 0)); $edit->fecha->calendar = false; $edit->codbanc = new dropdownField('Banco', 'codbanc'); $edit->codbanc->style = 'width:480px'; $edit->codbanc->mode = 'autohide'; $edit->codbanc->rule = 'required'; $edit->codbanc->option('', 'Seleccionar'); $edit->codbanc->options("SELECT TRIM(codbanc) AS codbanc,CONCAT_WS(' ',codbanc,banco,numcuent) AS desca FROM banc WHERE tbanco<>'CAJ'"); $edit->saldoi = new inputField('Saldo Inicial', 'saldoi'); $edit->saldoi->rule = 'numeric|required'; $edit->saldoi->insertValue = '0.0'; $edit->saldoi->css_class = 'inputnum'; $edit->saldoi->onkeyup = 'totalizar()'; $edit->saldoi->size = 15; $edit->saldoi->maxlength = 18; $edit->saldof = new inputField('Saldo Final', 'saldof'); $edit->saldof->insertValue = '0.0'; $edit->saldof->rule = 'numeric|required'; $edit->saldof->css_class = 'inputnum'; $edit->saldof->onkeyup = 'totalizar()'; $edit->saldof->size = 15; $edit->saldof->maxlength = 18; $edit->deposito = new inputField('Depósitos', 'deposito'); $edit->deposito->rule = 'numeric'; $edit->deposito->type = 'inputhidden'; $edit->deposito->insertValue = '0.0'; $edit->deposito->css_class = 'inputnum'; $edit->deposito->size = 20; $edit->deposito->maxlength = 18; $edit->credito = new inputField('Notas de Crédito', 'credito'); $edit->credito->rule = 'numeric'; $edit->credito->type = 'inputhidden'; $edit->credito->insertValue = '0.0'; $edit->credito->css_class = 'inputnum'; $edit->credito->size = 20; $edit->credito->maxlength = 18; $edit->cheque = new inputField('Cheques', 'cheque'); $edit->cheque->rule = 'numeric'; $edit->cheque->type = 'inputhidden'; $edit->cheque->insertValue = '0.0'; $edit->cheque->css_class = 'inputnum'; $edit->cheque->size = 20; $edit->cheque->maxlength = 18; $edit->debito = new inputField('Notas de Débito', 'debito'); $edit->debito->rule = 'numeric'; $edit->debito->type = 'inputhidden'; $edit->debito->insertValue = '0.0'; $edit->debito->css_class = 'inputnum'; $edit->debito->size = 20; $edit->debito->maxlength = 18; $edit->cdeposito = new inputField('Depósitos', 'cdeposito'); $edit->cdeposito->rule = 'numeric'; $edit->cdeposito->insertValue = '0.0'; $edit->cdeposito->css_class = 'inputnum'; $edit->cdeposito->onkeyup = 'totalizar()'; $edit->cdeposito->size = 12; $edit->cdeposito->maxlength = 18; $edit->ccredito = new inputField('Notas de Crédito', 'ccredito'); $edit->ccredito->rule = 'numeric'; $edit->ccredito->insertValue = '0.0'; $edit->ccredito->css_class = 'inputnum'; $edit->ccredito->onkeyup = 'totalizar()'; $edit->ccredito->size = 12; $edit->ccredito->maxlength = 18; $edit->ccheque = new inputField('Cheques', 'ccheque'); $edit->ccheque->rule = 'numeric'; $edit->ccheque->insertValue = '0.0'; $edit->ccheque->css_class = 'inputnum'; $edit->ccheque->onkeyup = 'totalizar()'; $edit->ccheque->size = 12; $edit->ccheque->maxlength = 18; $edit->cdebito = new inputField('Notas de Débito', 'cdebito'); $edit->cdebito->rule = 'numeric'; $edit->cdebito->insertValue = '0.0'; $edit->cdebito->css_class = 'inputnum'; $edit->cdebito->onkeyup = 'totalizar()'; $edit->cdebito->size = 12; $edit->cdebito->maxlength = 18; //$edit->status = new inputField('Estatus','status'); //$edit->status->rule=''; //$edit->status->size =3; //$edit->status->maxlength =1; $edit->usuario = new autoUpdateField('usuario', $this->secu->usuario(), $this->secu->usuario()); $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd')); $edit->hora = new autoUpdateField('hora', date('H:i:s'), date('H:i:s')); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); return true; } if ($edit->on_error()) { $rt = array('status' => 'B', 'mensaje' => preg_replace('/<[^>]*>/', '', $edit->error_string), 'pk' => null); echo json_encode($rt); $act = false; return true; } if ($edit->on_show()) { $conten['form'] =& $edit; $this->load->view('view_bconci', $conten); } }
function dataedit() { if ($this->rapyd->uri->is_set('modify')) { $id = $this->uri->segment($this->uri->total_segments()); $us = $this->datasis->dameval("SELECT usuario FROM proasiste WHERE id={$id}"); if (!$this->datasis->propio($us)) { die("No puede modificar este registro {$us}"); } } $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); $.post(\'' . site_url('ajax/get_asislista') . '\',{ campana:$("#campana").val(), evento:$("#evento").val() },function(data){$("#contenedor").html(data);}) }); '; $script .= ' function rchrifci(value, colname) { value.toUpperCase(); var patt=/((^[VEJG][0-9])|(^[P][A-Z0-9]))/; if( !patt.test(value) ) return [false,"El Rif colocado no es correcto, por favor verifique con el SENIAT."]; else return [true,""]; };'; $script .= $this->datasis->validarif(); $script .= ' $("#cedula").focusout(function(){ rif=$(this).val().toUpperCase(); $(this).val(rif); if(!chrif(rif)){ alert("Al parecer el RIF colocado no es correcto, por favor verifique con el SENIAT."); return true; }else{ $.ajax({ type: "POST", url: "' . site_url('ajax/traerif') . '", dataType: "json", data: {rifci: rif}, success: function(data){ if(data.error==0){ if($("#nombre").val()==""){ $("#nombre").val(data.nombre); } } } }); } return true; }); '; // Trae de personas si existe $script .= ' $("#telefono").focusin(function(){ rif=$("#cedula").val(); if( rif.length > 2 ){ $.ajax({ type: "POST", url: "' . site_url('ajax/traeparti') . '", dataType: "json", data: {rifci: rif}, success: function(data){ if(data.error==0){ if($("#telefono").val()==""){ $("#telefono").val(data.telefono); } if($("#email").val() ==""){ $("#email").val(data.email); } if($("#sector").val() ==""){ $("#sector").val(data.sector); } } } }); } return true; }); '; $script .= ' $("#campana").change(function(){ campana_change(); campa = $(this).val(); }); function campana_change(){ $.post(\'' . site_url('ajax/get_evento') . '\',{ campana:$("#campana").val() },function(data){$("#evento").html(data);}) } '; $script .= ' $("#evento").change(function(){ evento_change(); }); function evento_change(){ $.post(\'' . site_url('ajax/get_asislista') . '\',{ campana:$("#campana").val(), evento:$("#evento").val() },function(data){$("#contenedor").html(data);}) } '; $idanterior = intval($this->uri->segment(5)); $campana = ''; $evento = ''; if ($idanterior) { $ante = $this->datasis->damerow("SELECT campana, evento FROM proasiste WHERE id={$idanterior}"); $campana = $ante['campana']; $evento = $ante['evento']; } $edit = new DataEdit('', 'proasiste'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->campana = new dropdownField('Campana', 'campana'); $edit->campana->option('', 'Seleccione una Campa´a'); $edit->campana->options('SELECT id, campana FROM procamp ORDER BY campana'); $edit->campana->style = 'width:250px;'; $edit->campana->insertValue = $campana; $edit->evento = new dropdownField('Evento', 'evento'); $edit->evento->style = 'width:250px;'; $campa = $edit->getval('campana'); if ($campana) { $campa = $campana; } if ($campa !== FALSE) { $dbcampa = $this->db->escape($campa); $edit->evento->options("SELECT id, nombre FROM proevent WHERE campana={$dbcampa} ORDER BY nombre"); } else { $edit->evento->option('', 'Seleccione una Campa´a primero'); } $edit->evento->insertValue = $evento; $edit->cedula = new inputField('Cedula', 'cedula'); $edit->cedula->rule = ''; $edit->cedula->size = 15; $edit->cedula->maxlength = 15; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = 'strtoupper'; $edit->nombre->size = 52; $edit->nombre->maxlength = 100; $edit->telefono = new inputField('Telefono', 'telefono'); $edit->telefono->rule = ''; $edit->telefono->size = 32; $edit->telefono->maxlength = 30; $edit->email = new inputField('Email', 'email'); $edit->email->rule = ''; $edit->email->size = 52; $edit->email->maxlength = 100; $edit->sector = new inputField('Sector', 'sector'); $edit->sector->rule = 'strtoupper'; $edit->sector->size = 52; $edit->sector->maxlength = 100; $div = "<br><div style='overflow:auto;border: 1px solid #9AC8DA;background: #EAEAEA;height:200px' id='contenedor'></div>"; $edit->contenedor = new containerField('contenedor', $div); $edit->usuario = new autoUpdateField('usuario', $this->session->userdata('usuario'), $this->session->userdata('usuario')); $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd')); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); var edo = $("#entidad").val(); if ( $("#municipio").val() == false ){ entidad_change(); } $("#entidad").change(function(){ entidad_change(); edo = $(this).val(); }); $("#municipio").change( function(){ $.post(\'' . site_url('ajax/get_parroquia') . '\', { municipio:$(this).val(), entidad:edo }, function(data){ $("#parroquia").html(data); } ) }); }); function entidad_change(){ $.post(\'' . site_url('ajax/get_municipio') . '\',{ estado:$("#entidad").val() },function(data){$("#municipio").html(data);}) $.post(\'' . site_url('ajax/get_parroquia') . '\',{ municipio:\'\', entidad:\'\' },function(data){$("#parroquia").html(data);}) } '; // Valida RIF o CI con mensaje $script .= $this->datasis->validarif(); $script .= ' function rchrifci(value, colname) { value.toUpperCase(); var patt=/((^[VEJG][0-9])|(^[P][A-Z0-9]))/; if( !patt.test(value) ) return [false,"El Rif colocado no es correcto, por favor verifique con el SENIAT."]; else return [true,""]; }; $("#cedula").focusout(function(){ rif=$(this).val().toUpperCase(); $(this).val(rif); if(!chrif(rif)){ alert("Al parecer el RIF colocado no es correcto, por favor verifique con el SENIAT."); return true; }else{ $.ajax({ type: "POST", url: "' . site_url('ajax/traerif') . '", dataType: "json", data: {rifci: rif}, success: function(data){ if(data.error==0){ if($("#persona").val()==""){ $("#persona").val(data.nombre); } } } }); } return true; }); '; $edit = new DataEdit('', 'proevent'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->campana = new dropdownField('Campaña', 'campana'); $edit->campana->option('', 'Seleccionar'); $edit->campana->options('SELECT id, TRIM(campana) AS campana FROM procamp WHERE activo="S" ORDER BY campana'); $edit->campana->rule = 'max_length[11]'; $edit->campana->style = 'width:308px;'; $edit->activo = new dropdownField('Status', 'activo'); $edit->activo->option('S', 'Activo'); $edit->activo->option('N', 'Inactivo'); $edit->activo->rule = 'max_length[1]|required'; $edit->activo->style = 'width:150px;'; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = ''; $edit->nombre->size = 50; $edit->nombre->maxlength = 100; $edit->comenta = new textareaField('Descripcion', 'comenta'); $edit->comenta->rule = ''; $edit->comenta->cols = 48; $edit->comenta->rows = 3; $edit->cedula = new inputField('Cedula', 'cedula'); $edit->cedula->rule = ''; $edit->cedula->size = 15; $edit->cedula->maxlength = 15; $edit->persona = new inputField('Responsable', 'persona'); $edit->persona->rule = ''; $edit->persona->size = 50; $edit->persona->maxlength = 100; $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->calendar = false; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->horai = new inputField('Inicio', 'horai'); $edit->horai->rule = ''; $edit->horai->size = 10; $edit->horai->maxlength = 8; $edit->horaf = new inputField('Final', 'horaf'); $edit->horaf->rule = ''; $edit->horaf->size = 10; $edit->horaf->maxlength = 8; /* $edit->activador = new textareaField('Activador','activador'); $edit->activador->rule=''; $edit->activador->cols = 50; $edit->activador->rows = 4; */ $estado = $this->datasis->traevalor('ESTADO'); if (empty($estado)) { $estado = 12; } else { $estado = $this->datasis->dameval('SELECT codigo FROM estado WHERE entidad="' . $estado . '"'); if (empty($estado)) { $estado = 12; } } $edit->entidad = new dropdownField('Estado', 'entidad'); $edit->entidad->rule = 'required'; $edit->entidad->style = 'width:220px;'; $edit->entidad->option('', 'Seleccione un Estado'); $edit->entidad->options('SELECT codigo, entidad FROM estado ORDER BY entidad'); $edit->entidad->insertValue = 12; $edit->municipio = new dropdownField('Municipio', 'municipio'); $edit->municipio->style = 'width:220px;'; $edo = $edit->getval('entidad'); if ($edo !== FALSE) { $dbedo = $this->db->escape($edo); $edit->municipio->options("SELECT codigo, municipio FROM municipios WHERE entidad={$dbedo} ORDER BY municipio"); } else { $edit->municipio->option('', 'Seleccione una Entidad primero'); } $edit->parroquia = new dropdownField('Parroquia', 'parroquia'); $edit->parroquia->style = 'width:220px;'; $muni = $edit->getval('municipio'); if ($muni !== FALSE) { $dbmuni = $this->db->escape($muni); $edit->parroquia->options("SELECT codigo, parroquia FROM parroquias WHERE entidad={$edo} AND municipio={$dbmuni} ORDER BY parroquia"); } else { $edit->parroquia->option('', 'Seleccione un Municipio primero'); } /* $edit->entidad = new inputField('Entidad','entidad'); $edit->entidad->rule='integer'; $edit->entidad->insertValue = $estado; $edit->entidad->css_class='inputonlynum'; $edit->entidad->size =13; $edit->entidad->maxlength =11; $edit->municipio = new inputField('Municipio','municipio'); $edit->municipio->rule='integer'; $edit->municipio->css_class='inputonlynum'; $edit->municipio->size =13; $edit->municipio->maxlength =11; $edit->parroquia = new inputField('Parroquia','parroquia'); $edit->parroquia->rule='integer'; $edit->parroquia->css_class='inputonlynum'; $edit->parroquia->size =13; $edit->parroquia->maxlength =11; */ $edit->sector = new inputField('Sector', 'sector'); $edit->sector->rule = ''; $edit->sector->size = 52; $edit->sector->maxlength = 100; $edit->usuario = new autoUpdateField('usuario', $this->session->userdata('usuario'), $this->session->userdata('usuario')); $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd')); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); }); '; $edit = new DataEdit('', 'medicos'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->cedula = new inputField('Cedula', 'cedula'); $edit->cedula->rule = ''; $edit->cedula->size = 15; $edit->cedula->maxlength = 13; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = ''; $edit->nombre->size = 50; $edit->nombre->maxlength = 100; $edit->colegio = new inputField('Colegio', 'colegio'); $edit->colegio->rule = ''; $edit->colegio->size = 15; $edit->colegio->maxlength = 13; $edit->sanidad = new inputField('Sanidad', 'sanidad'); $edit->sanidad->rule = ''; $edit->sanidad->size = 15; $edit->sanidad->maxlength = 13; $edit->especialidad = new inputField('Especialidad', 'especialidad'); $edit->especialidad->rule = ''; $edit->especialidad->size = 50; $edit->especialidad->maxlength = 100; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit($status = '', $id = '') { $this->rapyd->load('dataobject', 'dataedit'); $qformato = $this->qformato = $this->datasis->formato_cpla(); $link = site_url('inventario/line/ultimo'); $link2 = site_url('inventario/common/sugerir_line'); $script = ' function ultimo(){ $.ajax({ url: "' . $link . '", success: function(msg){ alert( "El ultimo codigo ingresado fue: " + msg );}});} function sugerir(){ $.ajax({ url: "' . $link2 . '", success: function(msg){ if(msg){ $("#linea").val(msg); } else { alert("No es posible generar otra sugerencia. Coloque el código manualmente"); } } }); }'; $modbus = array('tabla' => 'cpla', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => '<#i#>'), 'titulo' => 'Buscar Cuenta', 'where' => "codigo LIKE \"{$qformato}\"", 'p_uri' => array(4 => '<#i#>')); $bcu_venta = $this->datasis->p_modbus($modbus, 'cu_venta'); $bcu_inve = $this->datasis->p_modbus($modbus, 'cu_inve'); $bcu_cost = $this->datasis->p_modbus($modbus, 'cu_cost'); $bcu_devo = $this->datasis->p_modbus($modbus, 'cu_devo'); $mdepto = array('tabla' => 'dept', 'columnas' => array('codigo' => 'Cóodigo', 'departam' => 'Nombre'), 'filtro' => array('codigo' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('codigo' => 'depto'), 'titulo' => 'Buscar Departamento'); $boton = $this->datasis->modbus($mdepto); $do = new DataObject('line'); if ($status == 'create' && !empty($id)) { $do->load($id); $do->set('linea', ''); } $edit = new DataEdit('', $do); $edit->on_save_redirect = false; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->pre_process('delete', '_pre_delete'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->dpto = new dropdownField('Departamento', 'depto'); $edit->dpto->option('', 'Seleccionar'); $edit->dpto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto"); $edit->dpto->rule = 'required'; $edit->dpto->style = 'width:250px;'; $ultimo = '<a href="javascript:ultimo();" title="Consultar ultimo código ingresado"> Consultar ultimo código</a>'; $sugerir = '<a href="javascript:sugerir();" title="Sugerir un Código aleatorio">Sugerir Código </a>'; $edit->linea = new inputField('Código', 'linea'); $edit->linea->mode = 'autohide'; $edit->linea->size = 4; $edit->linea->rule = 'trim|strtoupper|required|callback_chexiste|alpha_numeric'; $edit->linea->maxlength = 2; $edit->linea->append($sugerir); $edit->linea->append($ultimo); $edit->descrip = new inputField('Descripción', 'descrip'); $edit->descrip->size = 35; $edit->descrip->rule = 'trim|strtoupper|required'; $edit->descrip->maxlength = 30; $edit->cu_inve = new inputField('Cuenta Inventario', 'cu_inve'); $edit->cu_inve->size = 18; $edit->cu_inve->maxlength = 15; $edit->cu_inve->rule = 'trim|existecpla'; $edit->cu_inve->append($bcu_inve); $edit->cu_cost = new inputField('Cuenta Costo', 'cu_cost'); $edit->cu_cost->size = 18; $edit->cu_cost->maxlength = 15; $edit->cu_cost->rule = 'trim|existecpla'; $edit->cu_cost->append($bcu_cost); $edit->cu_venta = new inputField('Cuenta Venta', 'cu_venta'); $edit->cu_venta->size = 18; $edit->cu_venta->maxlength = 15; $edit->cu_venta->rule = 'trim|existecpla'; $edit->cu_venta->append($bcu_venta); $edit->cu_devo = new inputField('Cuenta Devolución', 'cu_devo'); $edit->cu_devo->size = 18; $edit->cu_devo->maxlength = 15; $edit->cu_devo->rule = 'trim|existecpla'; $edit->cu_devo->append($bcu_devo); //$edit->buttons("modify", "save", "undo", "delete", "back"); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit = new DataEdit($this->t**s, 'tbautobus'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->codbus = new inputField('Codigo', 'codbus'); $edit->codbus->mode = 'autohide'; $edit->codbus->rule = 'required'; $edit->codbus->size = 12; $edit->codbus->maxlength = 10; $edit->codacc = new dropdownField('Accionista', 'codacc'); $edit->codacc->options('SELECT codacc, CONCAT(codacc," ",nomacc) nombre FROM tbaccio ORDER BY codacc'); $edit->codacc->mode = 'autohide'; $edit->codacc->rule = 'required'; //$edit->codacc->size =12; //$edit->codacc->maxlength =10; $edit->capasidad = new inputField('Capacidad', 'capasidad'); $edit->capasidad->rule = ''; $edit->capasidad->size = 10; $edit->capasidad->maxlength = 8; $edit->tipbus = new dropdownField('Tipo bus', 'tipbus'); $edit->tipbus->options("SELECT tipbus, CONCAT(tipbus,' ',desbus) descripcion FROM tbmodbus ORDER BY tipbus"); $edit->tipbus->rule = ''; $edit->tipbus->size = 12; $edit->tipbus->maxlength = 10; $edit->placa = new inputField('Placa', 'placa'); $edit->placa->rule = 'required'; $edit->placa->size = 12; $edit->placa->maxlength = 10; $edit->marca = new dropdownField('Marca', 'marca'); $edit->marca->options("SELECT marca, marca nombre FROM marc ORDER BY marca"); $edit->marca->rule = 'required'; //$edit->marca->size =22; //$edit->marca->maxlength =20; $edit->modelo = new inputField('Modelo', 'modelo'); $edit->modelo->rule = ''; $edit->modelo->size = 42; $edit->modelo->maxlength = 40; $edit->ano = new inputField('Año', 'ano'); $edit->ano->rule = 'integer'; $edit->ano->css_class = 'inputonlynum'; $edit->ano->size = 5; $edit->ano->maxlength = 4; $edit->serialc = new inputField('Serial Carroceria', 'serialc'); $edit->serialc->rule = ''; $edit->serialc->size = 52; $edit->serialc->maxlength = 50; $edit->serialm = new inputField('Serial Motor', 'serialm'); $edit->serialm->rule = ''; $edit->serialm->size = 52; $edit->serialm->maxlength = 50; $edit->color = new inputField('Color', 'color'); $edit->color->rule = ''; $edit->color->size = 52; $edit->color->maxlength = 50; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function datacie() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); });'; $edit = new DataEdit('', 'lprod'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_cie_insert'); $edit->post_process('update', '_post_cie_update'); $edit->post_process('delete', '_post_cie_delete'); $edit->pre_process('insert', '_pre_cie_insert'); $edit->pre_process('update', '_pre_cie_update'); $edit->pre_process('delete', '_pre_cie_delete'); $edit->codigo = new inputField('Producto', 'codigo'); $edit->codigo->rule = ''; $edit->codigo->size = 17; $edit->codigo->maxlength = 15; $edit->codigo->mode = 'autohide'; $edit->descrip = new inputField('Descripción', 'descrip'); $edit->descrip->rule = ''; $edit->descrip->size = 47; $edit->descrip->in = 'codigo'; $edit->descrip->maxlength = 45; $edit->descrip->mode = 'autohide'; $edit->fecha = new dateField('Fecha de producción', 'fecha'); $edit->fecha->mode = 'autohide'; $edit->litros = new inputField('Volumen procesado', 'litros'); $edit->litros->rule = 'numeric'; $edit->litros->css_class = 'inputnum'; $edit->litros->size = 14; $edit->litros->maxlength = 12; $edit->litros->mode = 'autohide'; $edit->litros->rowformat = 'decimal'; $edit->medida = new freeField('Litros', 'medida', '<b>Litros<b>'); $edit->medida->in = 'litros'; $edit->unidades = new inputField('Produccion', 'unidades'); $edit->unidades->rule = 'integer|required'; $edit->unidades->css_class = 'inputonlynum'; $edit->unidades->size = 8; $edit->unidades->maxlength = 10; $edit->unidades->style = 'font-size: 1.5em;font-weight:bold;'; $edit->unidades->append('Unidades'); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit', 'dataobject'); $script = "\n\t\t\$(function() {\n\t\t\t\$('#fecha').datepicker({dateFormat:'dd/mm/yy'});\n\t\t\t\$('.inputnum').numeric('.');\n\t\t\t\t\$('#cod_cli').autocomplete({\n\t\t\t\t\tdelay: 600,\n\t\t\t\t\tautoFocus: true,\n\t\t\t\t\tsource: function(req, add){\n\t\t\t\t\t\t\$.ajax({\n\t\t\t\t\t\t\turl: '" . site_url('ajax/buscascli') . "',\n\t\t\t\t\t\t\ttype: 'POST',\n\t\t\t\t\t\t\tdataType: 'json',\n\t\t\t\t\t\t\tdata: {'q':req.term},\n\t\t\t\t\t\t\tsuccess:\n\t\t\t\t\t\t\t\tfunction(data){\n\t\t\t\t\t\t\t\t\tvar sugiere = [];\n\t\t\t\t\t\t\t\t\tif(data.length==0){\n\t\t\t\t\t\t\t\t\t\t\$('#sclinombre').val('');\n\t\t\t\t\t\t\t\t\t\t\$('#sclinombre_val').text('');\n\t\t\t\t\t\t\t\t\t\t\$('#sclirifci').val('');\n\t\t\t\t\t\t\t\t\t\t\$('#sclirifci_val').text('');\n\n\t\t\t\t\t\t\t\t\t}else{\n\t\t\t\t\t\t\t\t\t\t\$.each(data,\n\t\t\t\t\t\t\t\t\t\t\tfunction(i, val){\n\t\t\t\t\t\t\t\t\t\t\t\tsugiere.push( val );\n\t\t\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t\tadd(sugiere);\n\t\t\t\t\t\t\t\t},\n\t\t\t\t\t\t})\n\t\t\t\t\t},\n\t\t\t\t\tminLength: 2,\n\t\t\t\t\tselect: function( event, ui ) {\n\t\t\t\t\t\tvar tdirec;\n\t\t\t\t\t\t\$('#cod_cli').attr('readonly', 'readonly');\n\n\t\t\t\t\t\t\$('#sclinombre').val(ui.item.nombre);\n\t\t\t\t\t\t\$('#sclinombre_val').text(ui.item.nombre);\n\t\t\t\t\t\t\$('#sclirifci').val(ui.item.rifci);\n\t\t\t\t\t\t\$('#sclirifci_val').text(ui.item.rifci);\n\n\t\t\t\t\t\t\$('#cod_cli').val(ui.item.cod_cli);\n\n\t\t\t\t\t\tsetTimeout(function() { \$('#cod_cli').removeAttr('readonly'); }, 1500);\n\t\t\t\t\t}\n\t\t\t\t});\n\t\t});"; $do = new DataObject('sfpa'); $do->pointer('scli', 'scli.cliente=sfpa.cod_cli', 'scli.nombre AS sclinombre, scli.rifci AS sclirifci', 'left'); $edit = new DataEdit('', $do); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->cod_cli = new inputField('Cliente', 'cod_cli'); $edit->cod_cli->rule = 'required|existescli'; $edit->cod_cli->size = 7; $edit->cod_cli->maxlength = 5; $edit->sclirifci = new inputField('', 'sclirifci'); $edit->sclirifci->pointer = true; $edit->sclirifci->size = 14; $edit->sclirifci->type = 'inputhidden'; $edit->sclirifci->maxlength = 12; $edit->sclirifci->in = 'cod_cli'; $edit->sclinombre = new inputField('', 'sclinombre'); $edit->sclinombre->pointer = true; $edit->sclinombre->size = 14; $edit->sclinombre->type = 'inputhidden'; $edit->sclinombre->maxlength = 12; $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'required|chfecha'; $edit->fecha->calendar = false; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->insertValue = date('Y-m-d'); $edit->tipo = new dropdownField('Tipo', 'tipo'); $edit->tipo->option('', 'Seleccionar'); $edit->tipo->options('SELECT tipo, nombre FROM tarjeta WHERE activo=\'S\' AND tipo NOT IN ("EF", "DE", "NC","RI","IR","RP") ORDER BY nombre'); $edit->tipo->rule = 'required'; $edit->tipo->style = 'width:150px;'; $edit->num_ref = new inputField('Nro.Documento', 'num_ref'); $edit->num_ref->rule = 'required'; $edit->num_ref->size = 14; $edit->num_ref->maxlength = 12; $edit->banco = new dropdownField('Banco', 'banco'); $edit->banco->option('', 'Seleccionar'); $edit->banco->options("SELECT cod_banc, CONCAT(cod_banc,' ',nomb_banc) banco FROM tban WHERE cod_banc<>'CAJ' ORDER BY nomb_banc"); $edit->banco->rule = 'required'; $edit->banco->style = 'width:250px;'; $edit->cuentach = new inputField('Cta Corriente', 'cuentach'); $edit->cuentach->rule = ''; $edit->cuentach->size = 24; $edit->cuentach->maxlength = 22; $edit->monto = new inputField('Monto', 'monto'); $edit->monto->rule = 'required|mayorcero|numeric'; $edit->monto->css_class = 'inputnum'; $edit->monto->size = 20; $edit->monto->maxlength = 18; $edit->cobrador = new dropdownField('Cajero', 'cobrador'); $edit->cobrador->option('', 'Seleccionar'); $edit->cobrador->options('SELECT cajero, CONCAT(cajero, \' \', nombre) nombre FROM scaj ORDER BY nombre'); $edit->cobrador->rule = 'required'; $edit->cobrador->style = 'width:200px;'; $edit->usuario = new autoUpdateField('usuario', $this->secu->usuario(), $this->secu->usuario()); $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd')); $edit->hora = new autoUpdateField('hora', date('H:i:s'), date('H:i:s')); $edit->tipo_doc = new autoUpdateField('tipo_doc', 'CC', 'CC'); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataeditdialog() { $this->rapyd->load('dataedit'); $edit = new DataEdit('', 'scli'); $edit->on_save_redirect = false; $edit->cid = 'sclidialog'; $edit->pre_process('delete', '_pre_del'); $edit->pre_process('insert', '_pre_ins'); $edit->pre_process('update', '_pre_udp'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->rifci = new inputField('RIF/CI', 'sclidialogrifci'); $edit->rifci->db_name = 'rifci'; $edit->rifci->rule = 'trim|strtoupper|required|callback_chci'; $edit->rifci->maxlength = 13; $edit->rifci->size = 13; $edit->nombre = new inputField('Nombre', 'sclidialognombre'); $edit->nombre->db_name = 'nombre'; $edit->nombre->rule = 'trim|strtoupper|required'; $edit->nombre->size = 55; $edit->nombre->maxlength = 45; $edit->nombre->style = 'width:95%;'; $edit->grupo = new dropdownField('Grupo', 'sclidialoggrupo'); $edit->grupo->db_name = 'grupo'; $edit->grupo->option('', 'Seleccione un grupo'); $edit->grupo->options('SELECT TRIM(grupo) AS grupo, CONCAT(grupo," ",gr_desc) gr_desc FROM grcl ORDER BY gr_desc'); $edit->grupo->rule = 'required'; $edit->grupo->size = 6; $edit->grupo->maxlength = 4; $edit->grupo->style = 'width:220px'; $edit->grupo->insertValue = $this->datasis->dameval('SELECT grupo FROM grcl WHERE gr_desc like "CONSUMIDOR FINAL%"'); $edit->dire11 = new inputField('Dirección', 'sclidialogdire11'); $edit->dire11->db_name = 'dire11'; $edit->dire11->rule = 'trim'; $edit->dire11->size = 90; $edit->dire11->maxlength = 40; $edit->dire11->style = 'width:95%;'; $edit->telefono = new inputField('Teléfonos', 'sclidialogtelefono'); $edit->telefono->db_name = 'telefono'; $edit->telefono->rule = 'trim'; $edit->telefono->size = 22; $edit->telefono->maxlength = 30; $edit->ciudad1 = new dropdownField('Ciudad', 'sclidialogciudad1'); $edit->ciudad1->db_name = 'ciudad1'; $edit->ciudad1->rule = 'trim'; $edit->ciudad1->option('', 'Seleccionar'); $edit->ciudad1->options('SELECT TRIM(ciudad) AS codigo, ciudad FROM ciud ORDER BY ciudad'); $edit->ciudad1->style = 'width:200px'; $edit->ciudad1->insertValue = $this->datasis->traevalor('CIUDAD'); $edit->tiva = new dropdownField('Tipo Fiscal', 'sclidialogtiva'); $edit->tiva->db_name = 'tiva'; $edit->tiva->option('N', 'No Contribuyente'); $edit->tiva->option('C', 'Contribuyente'); $edit->tiva->option('E', 'Especial'); $edit->tiva->option('R', 'Regimen Exento'); $edit->tiva->option('O', 'Otro'); $edit->tiva->style = 'width:110px'; $edit->tiva->insertValue = 'N'; $edit->tiva->rule = 'required|enum[N,C,E,R,O]'; $edit->zona = new dropdownField('Zona', 'sclidialogzona'); $edit->zona->db_name = 'zona'; $edit->zona->rule = 'trim|required'; $edit->zona->option('', 'Seleccionar'); $edit->zona->options('SELECT TRIM(codigo) AS codigo, CONCAT(codigo," ", nombre) nombre FROM zona ORDER BY nombre'); $edit->zona->style = 'width:166px'; $edit->zona->insertValue = $this->datasis->traevalor('ZONAXDEFECTO'); $edit->email = new inputField('E-mail', 'sclidialogemail'); $edit->email->db_name = 'email'; $edit->email->rule = 'trim|valid_email'; $edit->email->size = 40; $edit->email->maxlength = 100; $edit->tipo = new autoUpdateField('tipo', '1', '1'); $edit->credito = new autoUpdateField('credito', 'N', 'N'); $edit->limite = new autoUpdateField('limite', '0', '0'); $script = ' $(function() { $("#sclidialogrifci").focusout(function(){ rif=$(this).val().toUpperCase(); $(this).val(rif); $("#sclidialogrifci").val(rif); if(!chrif(rif)){ alert("Al parecer el RIF colocado no es correcto, por favor verifique con el SENIAT."); return true; }else{ $.ajax({ type: "POST", url: "' . site_url('ajax/traerif') . '", dataType: "json", data: {rifci: rif}, success: function(data){ if(data.error==0){ if($("#sclidialognombre").val()==""){ $("#sclidialognombre").val(data.nombre); } } } }); //Chequea si esta repetido $.ajax({ type: "POST", url: "' . site_url('ajax/rifrep/C') . '", dataType: "json", data: {rifci: rif, codigo: ' . json_encode($edit->get_from_dataobjetct('cliente')) . '}, success: function(data){ if(data.rt){ $.prompt(data.msj,{ buttons: { Continuar: true }, focus: 1, submit:function(e,v,m,f){ $("#nombre").focus(); } }); $("#sclidialogrifci").unbind("focusout"); } } }); //Fin del chequeo repetido } }); }); function chrif(rif){ rif.toUpperCase(); var patt=/[EJPGV][0-9]{9} * /g; if(patt.test(rif)){ var factor= new Array(4,3,2,7,6,5,4,3,2); var v=0; if(rif[0]=="V"){ v=1; }else if(rif[0]=="E"){ v=2; }else if(rif[0]=="J"){ v=3; }else if(rif[0]=="P"){ v=4; }else if(rif[0]=="G"){ v=5; } acum=v*factor[0]; for(i=1;i<9;i++){ acum=acum+parseInt(rif[i])*factor[i]; } acum=11-acum%11; if(acum>=10 || acum<=0){ acum=0; } return (acum==parseInt(rif[9])); }else{ return true; } }'; $edit->script($script); $edit->build(); if ($edit->on_show()) { echo $edit->output; } if ($edit->on_success()) { $data = array('id' => $edit->_dataobject->get('id'), 'cliente' => $edit->_dataobject->get('cliente'), 'nombre' => $edit->_dataobject->get('nombre'), 'rifci' => $edit->_dataobject->get('rifci'), 'tipo' => $edit->_dataobject->get('tipo'), 'direc' => $edit->_dataobject->get('dire11'), 'descuento' => 0); $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'data' => $data, 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } if ($edit->on_error()) { $rt = array('status' => 'B', 'mensaje' => $edit->error_string, 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); }); '; $edit = new DataEdit('', 'prdo'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->numero = new inputField('Número', 'numero'); $edit->numero->mode = 'autohide'; $edit->numero->size = 10; $edit->numero->apply_rules = false; //necesario cuando el campo es clave y no se pide al usuario $edit->numero->when = array('show', 'modify'); $edit->fecha = new dateonlyField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha'; $edit->fecha->calendar = false; $edit->fecha->size = 10; $edit->fecha->maxlength = 8; $edit->fecha->insertValue = date('Y-m-d'); $edit->almacen = new dropdownField('Almacen', 'depo'); $edit->almacen->options('SELECT ubica, CONCAT(ubica,\' \',ubides) nombre FROM caub ORDER BY ubica'); $edit->almacen->rule = 'required'; $edit->almacen->mode = 'autohide'; $edit->almacen->style = 'width:145px;'; $alma = $this->datasis->traevalor('ALMACEN'); if (!empty($alma)) { $edit->almacen->insertValue = $alma; } $edit->status = new inputField('Status', 'status'); $edit->status->rule = ''; $edit->status->size = 4; $edit->status->maxlength = 2; $edit->instrucciones = new textareaField('Instrucciones', 'instrucciones'); $edit->instrucciones->rule = ''; $edit->instrucciones->cols = 40; $edit->instrucciones->rows = 2; $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd')); $edit->usuario = new autoUpdateField('usuario', $this->session->userdata('usuario'), $this->session->userdata('usuario')); $edit->hora = new autoUpdateField('hora', date('H:i:s'), date('H:i:s')); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { $conten['form'] =& $edit; $this->load->view('view_prdo', $conten); //echo $edit->output; } }
function dataedit() { //$this->rapyd->load('dataobject','datadetails'); $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecven").datepicker({dateFormat:"dd/mm/yy"}); });'; $edit = new DataEdit($this->t**s, 'tbreserva'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->fecven = new dateField('Fecha', 'fecven'); $edit->fecven->rule = 'chfecha'; $edit->fecven->size = 12; $edit->fecven->maxlength = 12; $edit->fecven->insertValue = date('Y-m-d'); $edit->fecven->calendar = false; $codofi = $this->datasis->dameval('SELECT pasaje FROM usuario WHERE us_codigo=' . $this->db->escape($this->session->userdata('usuario'))); $nomofi = $this->datasis->dameval('SELECT CONCAT(a.codofi," ", a.desofi) desofi FROM tbofici AS a WHERE a.codofi=' . $this->db->escape($codofi)); $edit->org = new dropdownField('Origen', 'org'); $edit->org->rule = ''; if (!empty($codofi)) { $edit->org->option($codofi, $nomofi); } else { $edit->org->option('', 'Seleccionar'); } $edit->org->options('SELECT a.codofi, CONCAT(a.codofi," ", a.desofi) desofi FROM tbofici AS a ORDER BY a.codofi'); $edit->org->style = 'width:170px;'; $edit->dtn = new dropdownField('Destino', 'dtn'); $edit->dtn->rule = ''; $edit->dtn->option('', 'Seleccionar'); if (!empty($codofi)) { $edit->dtn->options('SELECT a.codofi, CONCAT(a.codofi," ", a.desofi) desofi FROM tbofici AS a WHERE a.codofi<>' . $this->db->escape($codofi) . ' ORDER BY a.codofi'); } else { $edit->dtn->options('SELECT a.codofi, CONCAT(a.codofi," ", a.desofi) desofi FROM tbofici AS a ORDER BY a.codofi'); } $edit->dtn->style = 'width:170px;'; $edit->nropasa = new inputField('Nro. Pasaje', 'nropasa'); $edit->nropasa->rule = ''; $edit->nropasa->size = 10; $edit->nropasa->maxlength = 8; $edit->codppr = new inputField('Codppr', 'codppr'); $edit->codppr->rule = ''; $edit->codppr->size = 22; $edit->codppr->maxlength = 20; $edit->nacio = new dropdownField('Nacionalidad', 'nacio'); $edit->nacio->rule = ''; $edit->nacio->option('V', 'Venezolano'); $edit->nacio->option('E', 'Extranjero'); $edit->nacio->option('P', 'Pasaporte'); $edit->nacio->option('J', 'Juridico'); $edit->nacio->option('G', 'Gobierno'); $edit->nacio->style = 'width:100px;'; $edit->codcli = new inputField('C.I.', 'codcli'); $edit->codcli->rule = ''; $edit->codcli->size = 10; $edit->codcli->maxlength = 20; $edit->nomcli = new inputField('Nombre', 'nomcli'); $edit->nomcli->rule = ''; $edit->nomcli->size = 32; $edit->nomcli->maxlength = 150; $edit->codcarnet = new inputField('Codcarnet', 'codcarnet'); $edit->codcarnet->rule = ''; $edit->codcarnet->size = 22; $edit->codcarnet->maxlength = 20; $edit->codrut = new hiddenField('Ruta', 'codrut'); $edit->tippas = new inputField('Tippas', 'tippas'); $edit->tippas->rule = ''; $edit->tippas->size = 7; $edit->tippas->maxlength = 5; $edit->anula = new inputField('Anula', 'anula'); $edit->anula->rule = ''; $edit->anula->size = 3; $edit->anula->maxlength = 1; $edit->prepas = new inputField('Prepas', 'prepas'); $edit->prepas->rule = ''; $edit->prepas->size = 10; $edit->prepas->maxlength = 8; $edit->seguro = new inputField('Seguro', 'seguro'); $edit->seguro->rule = ''; $edit->seguro->size = 10; $edit->seguro->maxlength = 8; $edit->mondes = new inputField('Mondes', 'mondes'); $edit->mondes->rule = ''; $edit->mondes->size = 10; $edit->mondes->maxlength = 8; $edit->moncomi = new inputField('Moncomi', 'moncomi'); $edit->moncomi->rule = ''; $edit->moncomi->size = 10; $edit->moncomi->maxlength = 8; $edit->codofi = new inputField('Codofi', 'codofi'); $edit->codofi->rule = ''; $edit->codofi->size = 7; $edit->codofi->maxlength = 5; $edit->tipven = new inputField('Tipven', 'tipven'); $edit->tipven->rule = ''; $edit->tipven->size = 12; $edit->tipven->maxlength = 10; $edit->horpas = new inputField('Horpas', 'horpas'); $edit->horpas->rule = ''; $edit->horpas->size = 22; $edit->horpas->maxlength = 20; $edit->codptos = new inputField('Codptos', 'codptos'); $edit->codptos->rule = ''; $edit->codptos->size = 10; $edit->codptos->maxlength = 8; $edit->coddes = new inputField('Coddes', 'coddes'); $edit->coddes->rule = ''; $edit->coddes->size = 17; $edit->coddes->maxlength = 15; $edit->usuario = new autoUpdateField('usuario', $this->session->userdata('usuario'), $this->session->userdata('usuario')); $edit->tippag = new inputField('Tippag', 'tippag'); $edit->tippag->rule = ''; $edit->tippag->size = 12; $edit->tippag->maxlength = 10; $edit->tasa = new inputField('Tasa', 'tasa'); $edit->tasa->rule = ''; $edit->tasa->size = 10; $edit->tasa->maxlength = 8; $edit->fecpas = new inputField('Fecpas', 'fecpas'); $edit->fecpas->rule = ''; $edit->fecpas->size = 17; $edit->fecpas->maxlength = 15; $edit->pasajes = new inputField('Pasajes', 'pasajes'); $edit->pasajes->rule = 'numeric'; $edit->pasajes->insertValue = '0'; $edit->pasajes->size = 6; $edit->pasajes->maxlength = 8; $edit->pasajes->css_class = 'inputnum'; $edit->menores = new inputField('Menores', 'menores'); $edit->menores->rule = 'numeric'; $edit->menores->insertValue = '0'; $edit->menores->size = 6; $edit->menores->maxlength = 8; $edit->menores->css_class = 'inputnum'; $edit->menores->onchange = 'fmenores(\'M\')'; $edit->ancianos = new inputField('Ancianos', 'ancianos'); $edit->ancianos->rule = 'numeric'; $edit->ancianos->insertValue = '0'; $edit->ancianos->size = 6; $edit->ancianos->maxlength = 8; $edit->ancianos->css_class = 'inputnum'; $edit->ancianos->onchange = 'fmenores(\'A\')'; $edit->descuento = new inputField('Descuento', 'descuento'); $edit->descuento->rule = 'numeric'; $edit->descuento->insertValue = '0'; $edit->descuento->size = 6; $edit->descuento->maxlength = 8; $edit->descuento->css_class = 'inputnum'; if ($edit->_status == 'modify') { $id = $this->uri->segment($this->uri->total_segments()); $localiza = $this->datasis->dameval("SELECT localiza FROM tbreserva WHERE id={$id}"); } $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { $conten['form'] =& $edit; $this->load->view('view_tbreserva', $conten); } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); }); '; $edit = new DataEdit('', 'zona'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->codigo = new inputField('Código', 'codigo'); $edit->codigo->mode = 'autohide'; $edit->codigo->rule = 'required|unique'; $edit->codigo->size = 10; $edit->codigo->maxlength = 8; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = 'required'; $edit->nombre->size = 30; $edit->nombre->maxlength = 30; $edit->descrip = new textareaField('Descripción', 'descrip'); $edit->descrip->rule = 'trim'; $edit->descrip->cols = 30; $edit->descrip->rows = 2; $edit->descrip->maxlength = 90; $edit->descrip->style = 'width:100%;'; /* $edit->descrip->rule=''; $edit->descrip->size =30; $edit->descrip->maxlength =90; */ $edit->margen = new inputField('Margen', 'margen'); $edit->margen->rule = 'numeric'; $edit->margen->css_class = 'inputnum'; $edit->margen->size = 7; $edit->margen->insertValue = '0'; $edit->margen->maxlength = 5; $edit->margen->append('%'); $edit->area = new inputField('Código de área', 'area'); $edit->area->rule = ''; $edit->area->size = 38; $edit->area->maxlength = 40; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function(){ $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit = new DataEdit('', 'usol'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->on_save_redirect = false; $edit->script($script, 'create'); $edit->script($script, 'modify'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->codigo = new inputField('Codigo', 'codigo'); $edit->codigo->rule = ''; $edit->codigo->size = 4; $edit->codigo->maxlength = 2; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = ''; $edit->nombre->size = 32; $edit->nombre->maxlength = 30; /* $edit->gasto = new inputField('Gasto','gasto'); $edit->gasto->rule=''; $edit->gasto->size =8; $edit->gasto->maxlength =6; $edit->depto = new inputField('Depto','depto'); $edit->depto->rule=''; $edit->depto->size =5; $edit->depto->maxlength =3; //$edit->trabaja = new dropdownField("Tipo de Trabajador","tipot"); //$edit->trabaja->option("",""); //$edit->trabaja->options("SELECT codigo,tipo FROM tipot ORDER BY codigo"); //$edit->trabaja->group = "Relación Laboral"; //$edit->trabaja->style = "width:200px;"; */ $edit->sucursal = new dropdownField('Sucursal', 'sucursal'); $edit->sucursal->options("SELECT codigo, sucursal FROM sucu ORDER BY codigo"); $edit->sucursal->style = "width:200px;"; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $scli = array('tabla' => 'scli', 'columnas' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('cliente' => 'Código Cliente', 'nombre' => 'Nombre'), 'retornar' => array('cliente' => 'promotora'), 'titulo' => 'Buscar Cliente'); $boton = $this->datasis->modbus($scli); $edit = new DataEdit('', 'edif'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = 'max_length[120]|required'; $edit->nombre->maxlength = 120; $edit->tipo = new dropdownField('Tipo', 'tipo'); $edit->tipo->option('', 'Seleccionar'); $edit->tipo->options('SELECT id,descrip FROM `ediftipo` ORDER BY descrip'); $edit->tipo->rule = 'max_length[10]|required'; $edit->direccion = new textareaField('Dirección', 'direccion'); $edit->direccion->cols = 70; $edit->direccion->rows = 4; $edit->descripcion = new textareaField('Descripción', 'descripcion'); $edit->descripcion->cols = 70; $edit->descripcion->rows = 4; $edit->promotora = new inputField('Promotora', 'promotora'); $edit->promotora->rule = 'max_length[5]|existescli'; $edit->promotora->size = 7; $edit->promotora->maxlength = 5; $edit->promotora->append($boton); $edit->buttons('modify', 'save', 'undo', 'delete', 'back', 'add'); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit', 'dataobject'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); $("#hora").mask("99:99:99"); $("#codigo").autocomplete({ delay: 600, autoFocus: true, source: function(req, add){ $.ajax({ url: "' . site_url('ajax/buscapers') . '", type: "POST", dataType: "json", data: {"q":req.term}, success: function(data){ var sugiere = []; if(data.length==0){ $("#nombre").val(""); $("#nombre_val").text(""); $("#nacional").val(""); $("#nacional_val").text(""); $("#cedula").val(""); $("#cedula_val").text(""); }else{ $.each(data, function(i, val){ sugiere.push( val ); } ); } add(sugiere); }, }) }, minLength: 2, select: function( event, ui ) { $("#codigo").attr("readonly", "readonly"); $("#nombre").val(ui.item.nombre); $("#nombre_val").text(ui.item.nombre); $("#nacional").val(ui.item.nacional); $("#nacional_val").text(ui.item.nacional); $("#cedula").val(ui.item.cedula); $("#cedula_val").text(ui.item.cedula); setTimeout(function() { $("#codigo").removeAttr("readonly"); }, 1500); } }); });'; $do = new DataObject('cacc'); $do->pointer('pers', 'cacc.codigo=pers.codigo', 'pers.nombre AS persnombre,pers.nacional AS persnacional,pers.cedula AS perscedula', 'left'); $edit = new DataEdit('', $do); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->codigo = new inputField('Código del trabajador', 'codigo'); $edit->codigo->rule = 'trim'; $edit->codigo->mode = 'autohide'; $edit->codigo->maxlength = 15; $edit->codigo->size = 15; $edit->codigo->rule = 'required|existepers|callback_chexiste'; $edit->persnombre = new inputField('Nombre', 'nombre'); $edit->persnombre->pointer = 'true'; $edit->persnombre->db_name = 'persnombre'; $edit->persnombre->type = 'inputhidden'; $edit->persnacional = new inputField('Cédula', 'nacional'); $edit->persnacional->pointer = 'true'; $edit->persnacional->db_name = 'persnacional'; $edit->persnacional->type = 'inputhidden'; $edit->perscedula = new inputField('', 'cedula'); $edit->perscedula->pointer = 'true'; $edit->perscedula->db_name = 'perscedula'; $edit->perscedula->type = 'inputhidden'; $edit->perscedula->in = 'persnacional'; $edit->fecha = new DateonlyField('Fecha', 'fecha'); $edit->fecha->size = 12; $edit->fecha->rule = 'required'; $edit->fecha->insertValue = date('Y-m-d'); $edit->hora = new inputField('Hora', 'hora'); $edit->hora->maxlength = 8; $edit->hora->size = 10; $edit->hora->rule = 'required|callback_chhora'; $edit->hora->insertValue = date('H:i:s'); $edit->hora->append('hh:mm:ss'); $edit->hora->style = 'font-size: 2.5em;font-weight:bold;'; $id = $edit->getval('id'); if ($id !== false) { $id = intval($id); $furl = site_url($this->url . 'foto/' . $id . '/' . $id . '.jpg'); $edit->foto = new containerField('Foto', "<p style='text-align:center'><img border='0' src='{$furl}' alt='Entrada del trabajador' /></p>"); $edit->foto->when = array('show'); } $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit($status = '', $id = '', $id2 = '') { $this->rapyd->load('dataobject', 'dataedit'); $script = ' $(function() { $(".inputnum").numeric("."); $("#banco1").change(function () { acuenta(); }).change(); $("#banco2").change(function () { acuenta(); }).change(); });'; $do = new DataObject('fiscalz'); if ($status == 'create' && !empty($id) && !empty($id2)) { $do->load(array('serial' => $id, 'numero' => $id2)); $do->set('numero', ''); $do->set('hora', ''); $do->set('base', ''); $do->set('iva', ''); $do->set('base1', ''); $do->set('iva1', ''); $do->set('iva2', ''); $do->set('base2', ''); $do->set('exento', ''); $do->set('ncexento', ''); $do->set('ncbase', ''); $do->set('nciva', ''); $do->set('ncbase1', ''); $do->set('nciva1', ''); $do->set('ncbase2', ''); $do->set('nciva2', ''); $do->set('ncnumero', ''); } $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); }); '; $edit = new DataEdit('', $do); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->caja = new inputField('Caja', 'caja'); $edit->caja->size = 6; $edit->caja->maxlength = 4; $edit->caja->rule = 'trim|required'; $edit->serial = new inputField('Serial de la impresora fiscal', 'serial'); $edit->serial->size = 15; $edit->serial->maxlength = 12; $edit->serial->mode = 'autohide'; $edit->serial->rule = 'trim|required'; $edit->numero = new inputField('Número del cierre Z', 'numero'); $edit->numero->size = 6; $edit->numero->maxlength = 4; $edit->numero->mode = 'autohide|required'; $edit->numero->rule = 'trim'; $edit->fecha1 = new DateonlyField('Fecha Inicial', 'fecha1', 'd/m/Y'); $edit->fecha1->insertValue = date('Y-m-d'); $edit->fecha1->rule = 'required'; $edit->fecha1->size = 12; $edit->fecha1->calendar = false; $edit->fecha = new DateonlyField('Fecha Final', 'fecha', 'd/m/Y'); $edit->fecha->insertValue = date('Y-m-d'); $edit->fecha->rule = 'required'; $edit->fecha->size = 12; $edit->fecha->append('Si el cierre se saco el mismo día de las ventas la fecha final es igual a la fecha inicial'); $edit->fecha->calendar = false; $edit->hora = new inputField('Hora del cierre', 'hora'); $edit->hora->size = 8; $edit->hora->rule = 'trim|callback_chhora|required'; $edit->hora->append('hh:mm:ss'); $edit->hora->rule = 'trim'; $edit->factura = new inputField('Número de la última Factura', 'factura'); $edit->factura->size = 10; $edit->factura->maxlength = 8; $edit->factura->rule = 'trim|required'; $edit->factura->append('ULT.FACTURA'); $edit->ncnumero = new inputField('Número de la última Nota de Crédito numero', 'ncnumero'); $edit->ncnumero->size = 10; $edit->ncnumero->maxlength = 8; $edit->ncnumero->rule = 'trim|required'; $edit->ncnumero->append('ULT.NOTA.CREDITO'); $edit->exento = new inputField('Montos de Facturas exentas', 'exento'); $edit->exento->size = 15; $edit->exento->css_class = 'inputnum'; $edit->exento->maxlength = 12; $edit->exento->rule = "trim"; $edit->exento->group = 'Montos exentos'; $edit->exento->append('EXENTO'); $edit->ncexento = new inputField("Monto de notas de Crédito exentas", "ncexento"); $edit->ncexento->size = 15; $edit->ncexento->css_class = 'inputnum'; $edit->ncexento->maxlength = 12; $edit->ncexento->rule = 'trim'; $edit->ncexento->group = 'Montos exentos'; $edit->ncexento->append('NC. EXENTO'); $edit->base = new inputField('Ventas Base imponible', 'base'); $edit->base->size = 15; $edit->base->css_class = 'inputnum'; $edit->base->maxlength = 12; $edit->base->group = 'Según Alicuota General'; $edit->base->rule = 'trim'; $edit->iva = new inputField('Ventas Iva', 'iva'); $edit->iva->size = 15; $edit->iva->css_class = 'inputnum'; $edit->iva->maxlength = 12; $edit->iva->group = 'Según Alicuota General'; $edit->iva->rule = 'trim'; $edit->iva->append('IVA G'); $edit->base1 = new inputField('Ventas Base imponible', 'base1'); $edit->base1->size = 15; $edit->base1->css_class = 'inputnum'; $edit->base1->maxlength = 12; $edit->base1->group = 'Según Alicuota Reducida'; $edit->base1->rule = 'trim'; $edit->iva1 = new inputField('Ventas Iva', 'iva1'); $edit->iva1->size = 15; $edit->iva1->css_class = 'inputnum'; $edit->iva1->maxlength = 12; $edit->iva1->group = 'Según Alicuota Reducida'; $edit->iva1->rule = 'trim'; $edit->base2 = new inputField('Ventas Base imponible', 'base2'); $edit->base2->size = 15; $edit->base2->css_class = 'inputnum'; $edit->base2->maxlength = 12; $edit->base2->group = 'Según Alicuota Adicional'; $edit->base2->rule = 'trim'; $edit->iva2 = new inputField('Ventas Iva', 'iva2'); $edit->iva2->size = 15; $edit->iva2->css_class = 'inputnum'; $edit->iva2->maxlength = 12; $edit->iva2->group = 'Según Alicuota Adicional'; $edit->iva2->rule = 'trim'; $edit->ncbase = new inputField('Nota de Crédito base imponible', 'ncbase'); $edit->ncbase->size = 15; $edit->ncbase->css_class = 'inputnum'; $edit->ncbase->maxlength = 12; $edit->ncbase->group = 'Según Alicuota General'; $edit->ncbase->rule = 'trim'; $edit->ncbase->append('NC. BI G'); $edit->ncsiva = new inputField('Nota de Crédito iva', 'nciva'); $edit->ncsiva->size = 15; $edit->ncsiva->css_class = 'inputnum'; $edit->ncsiva->maxlength = 12; $edit->ncsiva->group = 'Según Alicuota General'; $edit->ncsiva->rule = 'trim'; $edit->ncsiva->append('NC. IVA G'); $edit->ncbase1 = new inputField('Nota de Crédito base imponible', 'ncbase1'); $edit->ncbase1->size = 15; $edit->ncbase1->css_class = 'inputnum'; $edit->ncbase1->maxlength = 12; $edit->ncbase1->group = 'Según Alicuota Reducida'; $edit->ncbase1->rule = 'trim'; $edit->ncsiva1 = new inputField('Nota de Crédito iva', 'nciva1'); $edit->ncsiva1->size = 15; $edit->ncsiva1->css_class = 'inputnum'; $edit->ncsiva1->maxlength = 12; $edit->ncsiva1->group = 'Según Alicuota Reducida'; $edit->ncsiva1->rule = "trim"; $edit->ncbase2 = new inputField('Nota de Crédito base imponible', 'ncbase2'); $edit->ncbase2->size = 15; $edit->ncbase2->css_class = 'inputnum'; $edit->ncbase2->maxlength = 12; $edit->ncbase2->group = 'Según Alicuota Adicional'; $edit->ncbase2->rule = "trim"; $edit->ncsiva2 = new inputField('Nota de Crédito iva', 'nciva2'); $edit->ncsiva2->size = 15; $edit->ncsiva2->css_class = 'inputnum'; $edit->ncsiva2->maxlength = 12; $edit->ncsiva2->group = 'Según Alicuota Adicional'; $edit->ncsiva2->rule = 'trim'; $edit->ncsiva1->append('NC. IVA R'); $edit->ncsiva2->append('NC. IVA A'); $edit->ncbase1->append('NC. BI R'); $edit->ncbase2->append('NC. BI A'); $edit->iva1->append('IVA R'); $edit->iva2->append('IVA A'); $edit->base->append('BI G'); $edit->base1->append('BI R'); $edit->base2->append('BI A'); $edit->manual = new autoUpdateField('manual', 'S', 'S'); $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = "\n\t\t\$(function(){\n\t\t\t\$('.inputnum').numeric('.');\n\t\t\t\$('#fecha').datepicker({ dateFormat: 'dd/mm/yy' });\n\t\t\t\$('#proveed').autocomplete({\n\t\t\t\tsource: function( req, add){\n\t\t\t\t\t\$.ajax({\n\t\t\t\t\t\turl: '" . site_url('ajax/buscasprv') . "',\n\t\t\t\t\t\ttype: 'POST',\n\t\t\t\t\t\tdataType: 'json',\n\t\t\t\t\t\tdata: 'q='+req.term,\n\t\t\t\t\t\tsuccess:\n\t\t\t\t\t\t\tfunction(data){\n\t\t\t\t\t\t\t\tvar sugiere = [];\n\t\t\t\t\t\t\t\t\$.each(data,\n\t\t\t\t\t\t\t\t\tfunction(i, val){\n\t\t\t\t\t\t\t\t\t\tsugiere.push( val );\n\t\t\t\t\t\t\t\t\t}\n\t\t\t\t\t\t\t\t);\n\t\t\t\t\t\t\t\tadd(sugiere);\n\t\t\t\t\t\t\t},\n\t\t\t\t\t})\n\t\t\t\t},\n\t\t\t\tminLength: 2,\n\t\t\t\tselect: function( event, ui ) {\n\t\t\t\t\t\$('#proveed').attr('readonly', 'readonly');\n\t\t\t\t\t\$('#nombre').val(ui.item.nombre);\n\t\t\t\t\t\$('#nombre_val').text(ui.item.nombre);\n\t\t\t\t\t\$('#proveed').val(ui.item.proveed);\n\t\t\t\t\t\$('#sprvreteiva').val(ui.item.reteiva);\n\t\t\t\t\tsetTimeout(function() { \$('#proveed').removeAttr('readonly'); }, 1500);\n\t\t\t\t}\n\t\t\t});\n\t\t});\n\t\tfunction totaliza(){\n\t\t\tif(\$('#cantidad').val().length>0) cantidad =parseFloat(\$('#cantidad').val()); else cantiad =0;\n\t\t\tif(\$('#precio').val().length >0) precio =parseFloat(\$('#precio').val()); else precio =0;\n\n\n\t\t\ttotal=roundNumber(cantidad*precio,2);\n\t\t\t\$('#total').val(total);\n\t\t\t\$('#total_val').text(nformat(total));\n\t\t}\n\t\t"; $edit = new DataEdit('', 'lgasto'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->proveed = new inputField('Proveedor', 'proveed'); $edit->proveed->rule = 'max_length[5]|required|existesprv'; $edit->proveed->size = 10; $edit->proveed->maxlength = 15; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = 'max_length[100]'; $edit->nombre->size = 45; $edit->nombre->in = 'proveed'; $edit->nombre->type = 'inputhidden'; $edit->nombre->maxlength = 100; $edit->tipo = new dropdownField('Tipo', 'tipo'); $edit->tipo->option('D', 'Deducción'); $edit->tipo->option('A', 'Asignación'); $edit->tipo->style = 'width:150px;'; $edit->tipo->size = 5; $edit->tipo->rule = 'required'; $edit->referen = new inputField('N.Referencia', 'referen'); $edit->referen->rule = 'max_length[100]'; $edit->referen->size = 12; $edit->referen->maxlength = 10; $edit->fecha = new dateField('Fecha', 'fecha'); $edit->fecha->rule = 'chfecha|required'; $edit->fecha->calendar = false; $edit->fecha->insertValue = date('Y-m-d'); $edit->fecha->size = 12; $edit->fecha->maxlength = 8; $edit->descrip = new inputField('Descripción', 'descrip'); $edit->descrip->rule = 'max_length[100]|trim|strtoupper'; $edit->descrip->size = 45; $edit->descrip->maxlength = 100; $edit->cantidad = new inputField('Cantidad', 'cantidad'); $edit->cantidad->rule = 'max_length[17]|numeric|required'; $edit->cantidad->css_class = 'inputnum'; $edit->cantidad->size = 19; $edit->cantidad->autocomplete = false; $edit->cantidad->onkeyup = 'totaliza()'; $edit->cantidad->maxlength = 17; $edit->precio = new inputField('Precio', 'precio'); $edit->precio->rule = 'max_length[17]|numeric|required'; $edit->precio->css_class = 'inputnum'; $edit->precio->onkeyup = 'totaliza()'; $edit->precio->autocomplete = false; $edit->precio->size = 19; $edit->precio->maxlength = 17; $edit->total = new inputField('Total', 'total'); $edit->total->rule = 'max_length[17]|numeric|required'; $edit->total->css_class = 'inputnum'; $edit->total->size = 19; $edit->total->type = 'inputhidden'; $edit->total->maxlength = 17; $edit->build(); $script = ''; if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $edit = new DataEdit($this->t**s, 'zdesp'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); });'; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->fecha = new DateonlyField('Fecha', 'fecha', 'd/m/Y'); $edit->fecha->insertValue = date('Y-m-d'); $edit->fecha->size = 10; $edit->fecha->rule = 'required'; $edit->fecha->calendar = false; $edit->numsoli = new inputField('N de solicitud', 'numsoli'); $edit->numsoli->rule = 'integer'; $edit->numsoli->css_class = 'inputonlynum'; $edit->numsoli->size = 12; $edit->numsoli->maxlength = 10; $edit->nombperso = new inputField('Nombre', 'nombperso'); $edit->nombperso->rule = ''; $edit->nombperso->size = 40; $edit->nombperso->maxlength = 40; $edit->ciperso = new inputField('Cedula', 'ciperso'); $edit->ciperso->rule = ''; $edit->ciperso->size = 13; $edit->ciperso->maxlength = 13; $edit->telefono = new inputField('Telefono', 'telefono'); $edit->telefono->rule = ''; $edit->telefono->size = 25; $edit->telefono->maxlength = 25; $edit->tipo = new dropdownField('Tipo', 'tipo'); $edit->tipo->style = "width:100px;"; $edit->tipo->options(array("P" => "Pickup", "C" => "Camion", "G" => "Gandola")); $edit->modelo = new inputField('Modelo', 'modelo'); $edit->modelo->rule = ''; $edit->modelo->size = 13; $edit->modelo->maxlength = 13; $edit->marca = new inputField('Marca', 'marca'); $edit->marca->rule = ''; $edit->marca->size = 13; $edit->marca->maxlength = 13; $edit->placa = new inputField('Placa', 'placa'); $edit->placa->rule = ''; $edit->placa->size = 12; $edit->placa->maxlength = 10; $edit->color = new inputField('Color', 'color'); $edit->color->rule = ''; $edit->color->size = 20; $edit->color->maxlength = 20; $edit->build(); $script = '<script type="text/javascript" > $(function() { $(".inputnum").numeric("."); $(".inputonlynum").numeric(); $("#fecha").datepicker({ dateFormat: "dd/mm/yy" }); }); </script>'; if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit = new DataEdit($this->t**s, 'grup'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); }); '; $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->grupo = new inputField('Grupo', 'grupo'); $edit->grupo->rule = ''; $edit->grupo->size = 6; $edit->grupo->maxlength = 4; $edit->nom_grup = new inputField('Nom_grup', 'nom_grup'); $edit->nom_grup->rule = ''; $edit->nom_grup->size = 32; $edit->nom_grup->maxlength = 30; $edit->tipo = new dropdownField("Tipo", "tipo"); $edit->tipo->style = 'width:100px;'; $edit->tipo->option("I", "Inventario"); $edit->tipo->option("G", "Gasto"); /* $edit->tipo = new inputField('Tipo','tipo'); $edit->tipo->rule=''; $edit->tipo->size =3; $edit->tipo->maxlength =1; $edit->linea = new inputField('Linea','linea'); $edit->linea->rule=''; $edit->linea->size =4; $edit->linea->maxlength =2; $edit->depto = new inputField('Depto','depto'); $edit->depto->rule=''; $edit->depto->size =5; $edit->depto->maxlength =3; $edit->familia = new inputField('Familia','familia'); $edit->familia->rule=''; $edit->familia->size =5; $edit->familia->maxlength =3; */ $edit->depto = new dropdownField("Departamento", "dpto"); $edit->depto->db_name = 'depto'; $edit->depto->rule = "required"; $edit->depto->onchange = "get_familia();"; $edit->depto->option("", "Seleccionar"); $edit->depto->options("SELECT depto, descrip FROM dpto WHERE tipo='I' ORDER BY depto"); $edit->familia = new dropdownField("Familia", "familia"); $edit->familia->rule = "required"; if ($edit->_status == 'modify' or $edit->_status == 'show' or $edit->_status == 'idle' or $edit->_status == 'create') { $depto = $this->input->post('dpto') === FALSE ? $edit->_dataobject->get("depto") : $this->input->post('dpto'); $edit->familia->option("", ""); $edit->familia->options("SELECT familia, descrip FROM fami WHERE depto='{$depto}' ORDER BY descrip"); } else { $edit->familia->option("", "Seleccione un Departamento"); } $edit->cu_inve = new inputField('Cu_inve', 'cu_inve'); $edit->cu_inve->rule = ''; $edit->cu_inve->size = 17; $edit->cu_inve->maxlength = 15; $edit->cu_cost = new inputField('Cu_cost', 'cu_cost'); $edit->cu_cost->rule = ''; $edit->cu_cost->size = 17; $edit->cu_cost->maxlength = 15; $edit->cu_venta = new inputField('Cu_venta', 'cu_venta'); $edit->cu_venta->rule = ''; $edit->cu_venta->size = 17; $edit->cu_venta->maxlength = 15; /* $edit->cu_devo = new inputField('Cu_devo','cu_devo'); $edit->cu_devo->rule=''; $edit->cu_devo->size =17; $edit->cu_devo->maxlength =15; */ $edit->comision = new inputField('Comision', 'comision'); $edit->comision->rule = 'numeric'; $edit->comision->css_class = 'inputnum'; $edit->comision->size = 10; $edit->comision->maxlength = 8; $edit->margen1 = new inputField('Margen1', 'margen1'); $edit->margen1->rule = 'numeric'; $edit->margen1->css_class = 'inputnum'; $edit->margen1->size = 10; $edit->margen1->maxlength = 8; $edit->margen2 = new inputField('Margen2', 'margen2'); $edit->margen2->rule = 'numeric'; $edit->margen2->css_class = 'inputnum'; $edit->margen2->size = 10; $edit->margen2->maxlength = 8; $edit->margen3 = new inputField('Margen3', 'margen3'); $edit->margen3->rule = 'numeric'; $edit->margen3->css_class = 'inputnum'; $edit->margen3->size = 10; $edit->margen3->maxlength = 8; $edit->margen4 = new inputField('Margen4', 'margen4'); $edit->margen4->rule = 'numeric'; $edit->margen4->css_class = 'inputnum'; $edit->margen4->size = 10; $edit->margen4->maxlength = 8; $edit->margen5 = new inputField('Margen5', 'margen5'); $edit->margen5->rule = 'numeric'; $edit->margen5->css_class = 'inputnum'; $edit->margen5->size = 10; $edit->margen5->maxlength = 8; $edit->precio = new inputField('Precio', 'precio'); $edit->precio->rule = ''; $edit->precio->size = 3; $edit->precio->maxlength = 1; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(function() { $("#fecha").datepicker({dateFormat:"dd/mm/yy"}); $(".inputnum").numeric("."); });'; $edit = new DataEdit('', 'sucu'); $edit->script($script, 'modify'); $edit->script($script, 'create'); $edit->on_save_redirect = false; $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->codigo = new inputField('Código', 'codigo'); $edit->codigo->rule = 'required|max_length[4]|alpha_numeric'; $edit->codigo->mode = 'autohide'; $edit->codigo->size = 4; $edit->codigo->maxlength = 2; $edit->sucursal = new inputField('Nombre de la Sucursal', 'sucursal'); $edit->sucursal->rule = 'strtoupper|max_length[45]|required'; $edit->sucursal->size = 40; $edit->sucursal->maxlength = 45; $edit->url = new inputField('Dirección URL', 'url'); $edit->url->size = 40; $edit->url->maxlength = 200; $edit->url->append('Ej: www.example.com o www.example.com:8080'); $edit->prefijo = new inputField('Prefijo', 'prefijo'); $edit->prefijo->size = 5; $edit->prefijo->maxlength = 3; $edit->prefijo->rule = 'required'; $edit->prefijo->append('Prefijo de las transacciones en la sucursal'); $edit->proteo = new inputField('Direcctorio Proteo', 'proteo'); $edit->proteo->maxlength = 50; $edit->serie = new inputField('Serie', 'serie'); $edit->serie->rule = ''; $edit->serie->size = 3; $edit->serie->maxlength = 1; $edit->odbc = new inputField('Odbc', 'odbc'); $edit->odbc->rule = ''; $edit->odbc->size = 40; $edit->odbc->maxlength = 100; $edit->usuario = new autoUpdateField('usuario', $this->session->userdata('usuario'), $this->session->userdata('usuario')); $edit->clave = new inputField('Clave', 'clave'); $edit->clave->rule = ''; $edit->clave->size = 17; $edit->clave->maxlength = 15; $edit->puerto = new inputField('Puerto', 'puerto'); $edit->puerto->rule = ''; $edit->puerto->size = 8; $edit->puerto->maxlength = 6; $edit->db_nombre = new inputField('Nombre DB', 'db_nombre'); $edit->db_nombre->rule = ''; $edit->db_nombre->size = 40; $edit->db_nombre->maxlength = 100; $edit->identifi = new inputField('Identificación', 'identifi'); $edit->identifi->rule = ''; $edit->identifi->size = 40; $edit->identifi->maxlength = 100; $edit->build(); if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }
function dataedit() { $this->rapyd->load('dataedit'); $script = ' $(document).ready(function() { $(".inputnum").numeric("."); $("#codprv").autocomplete({ source: function( req, add){ $.ajax({ url: "' . site_url('ajax/buscasprv') . '", type: "POST", dataType: "json", data: "q="+req.term, success: function(data){ var sugiere = []; if(data.length==0){ $("#proveed").val(""); $("#proveed_val").text(""); $("#codprv").val(""); }else{ $.each(data, function(i, val){ sugiere.push( val ); } ); } add(sugiere); }, }) }, minLength: 2, select: function( event, ui ) { $("#codprv").attr("readonly", "readonly"); $("#proveed").val(ui.item.nombre); $("#proveed_val").text(ui.item.nombre); $("#codprv").val(ui.item.proveed); setTimeout(function(){ $("#codprv").removeAttr("readonly"); }, 1500); } }); });'; $edit = new DataEdit($this->t**s, 'lruta'); $edit->script($script, 'create'); $edit->script($script, 'modify'); $edit->on_save_redirect = false; $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->codigo = new inputField('Código', 'codigo'); $edit->codigo->rule = 'max_length[4]'; $edit->codigo->size = 6; $edit->codigo->maxlength = 4; $edit->nombre = new inputField('Nombre', 'nombre'); $edit->nombre->rule = 'max_length[50]'; $edit->nombre->size = 52; $edit->nombre->maxlength = 50; $edit->codprv = new inputField('Propietario', 'codprv'); $edit->codprv->rule = 'max_length[15]'; $edit->codprv->size = 7; $edit->codprv->maxlength = 15; $edit->proveed = new inputField('Proveedor', 'proveed'); $edit->proveed->rule = 'max_length[45]'; $edit->proveed->size = 45; $edit->proveed->type = 'inputhidden'; $edit->proveed->maxlength = 45; $edit->proveed->in = 'codprv'; $edit->zona = new dropdownField('Zona', 'zona'); $edit->zona->rule = 'trim|max_length[4]'; $edit->zona->option('', 'Seleccionar'); $edit->zona->options('SELECT codigo, CONCAT(codigo," ", nombre) nombre FROM zona ORDER BY nombre'); $edit->zona->style = 'width:166px'; $edit->tarifa = new inputField('Tarifa', 'tarifa'); $edit->tarifa->rule = 'numeric|required'; $edit->tarifa->insertValue = '0'; $edit->tarifa->css_class = 'inputnum'; $edit->tarifa->size = 7; $edit->tarifa->maxlength = 10; $edit->tarsob = new inputField('Sobrante', 'tarsob'); $edit->tarsob->rule = 'numeric|required'; $edit->tarsob->insertValue = '0'; $edit->tarsob->css_class = 'inputnum'; $edit->tarsob->size = 7; $edit->tarsob->maxlength = 10; $edit->tipolec = new dropdownField('Tipo de Leche', 'tipolec'); $edit->tipolec->option('C', 'Caliente'); $edit->tipolec->option('F', 'Fria'); $edit->tipolec->rule = 'required'; $edit->tipolec->style = 'width:100px;'; $edit->build(); $script = ''; if ($edit->on_success()) { $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk); echo json_encode($rt); } else { echo $edit->output; } }