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