Example #1
0
 function dataedit()
 {
     $this->rapyd->load('dataobject', 'datadetails');
     $modbus = array('tabla' => 'sumi', 'columnas' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripcion', 'unidad' => 'Unidad'), 'filtro' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripcion'), 'retornar' => array('codigo' => 'codigo_<#i#>', 'descrip' => 'descripcion_<#i#>'), 'p_uri' => array(4 => '<#i#>'), 'titulo' => 'Busqueda de Articulos');
     $btn = $this->datasis->p_modbus($modbus, '<#i#>');
     //$script='	';
     //
     $do = new DataObject("suminr");
     $do->rel_one_to_many('itsuminr', 'itsuminr', array('numero' => 'numero'));
     //		$do->rel_pointer('itsuminr','sumi' ,'itsuminr.codigo=sumi.codigo',"sumi.descrip descrip2");
     $do->order_by('itsuminr', 'itsuminr.codigo', ' ');
     $edit = new DataDetails("Nota de Recepci&oacute;n", $do);
     $edit->back_url = site_url("suministros/suminr/filteredgrid");
     $edit->set_rel_title('itsuminr', 'Rubro <#o#>');
     $edit->pre_process('insert', '_valida');
     $edit->pre_process('update', '_valida');
     //$edit->script($script,'create');
     //$edit->script($script,'modify');
     $edit->numero = new inputField("N&uacute;mero", "numero");
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show');
     $edit->conc = new dropdownField("Concepto", "conc");
     $edit->conc->options("SELECT id,descrip FROM su_conc WHERE tipo='E'");
     $edit->fecha = new dateonlyField("Fecha", "fecha");
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->size = 12;
     $edit->alma = new dropdownField("Receptor", "alma");
     $edit->alma->options("SELECT codigo,CONCAT_WS(' ',codigo,descrip) valor FROM su_alma WHERE codigo<>'0000'");
     $modbusprv = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Codigo', 'nombre' => 'Nombre'), 'filtro' => array('proveed' => 'Codigo', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed'), 'titulo' => 'Buscar Beneficiario');
     $bproveed = $this->datasis->modbus($modbusprv);
     $edit->proveed = new inputField("Proveedor", "proveed");
     //$edit->proveed->rule='required';
     $edit->proveed->append($bproveed);
     $edit->caub = new dropdownField("Almacen", "caub");
     $edit->caub->options("SELECT codigo,CONCAT_WS(' ',codigo,descrip) valor FROM su_caub");
     $edit->status = new dropdownField("Estado", "status");
     $edit->status->option("A", "Anulado");
     $edit->status->option("P", "Por Recibir");
     $edit->status->option("C", "Recibido");
     $edit->status->when = array("show");
     $edit->observacion = new textareaField("Observaci&oacute;n", "observacion");
     $edit->observacion->rows = 1;
     $edit->observacion->cols = 80;
     //		$edit->observacion->rule='required';
     $edit->codigo = new inputField("(<#o#>) Codigo", "codigo_<#i#>");
     $edit->codigo->rel_id = 'itsuminr';
     //$edit->codigo->rule='callback_repetido|required';
     $edit->codigo->size = 6;
     //$edit->codigo->append('<img src="/tortuga/assets/default/images/system-search.png"  alt="Busqueda de Articulos" title="Busqueda de Articulos" border="0" onclick="modbusdepen(<#i#>)"/>');
     $edit->codigo->db_name = 'codigo';
     $edit->codigo->append($btn);
     $edit->descripcion = new inputField("Descripci&oacute;n", "descripcion_<#i#>");
     $edit->descripcion->db_name = 'descripcion';
     $edit->descripcion->rel_id = 'itsuminr';
     $edit->descripcion->size = 40;
     $edit->descripcion->readonly = true;
     //		$edit->descripcion->pointer=true;
     $edit->cantidad = new inputField("Cantidad", "cantidad_<#i#>");
     $edit->cantidad->rule = 'required|numeric';
     $edit->cantidad->css_class = 'inputnum';
     $edit->cantidad->db_name = 'cantidad';
     $edit->cantidad->rel_id = 'itsuminr';
     $edit->cantidad->size = 10;
     $edit->cantidad->onchange = 'cal_cant(<#i#>);';
     $edit->precio = new inputField("(<#o#>) Precio", "precio_<#i#>");
     $edit->precio->css_class = 'inputnum';
     $edit->precio->db_name = 'precio';
     $edit->precio->rel_id = 'itsuminr';
     $edit->precio->rule = 'numeric|required';
     $edit->precio->onchange = 'cal_total(<#i#>);';
     $edit->precio->size = 10;
     $edit->total = new inputField("(<#o#>) Total", "total_<#i#>");
     $edit->total->db_name = 'total';
     $edit->total->rel_id = 'itsuminr';
     $edit->total->rule = 'numeric';
     $edit->total->readonly = true;
     $edit->total->size = 10;
     $edit->tcantidad = new inputField("Cantidad total", "tcantidad");
     $edit->tcantidad->db_name = 'tcantidad';
     $edit->tcantidad->css_class = 'inputnum';
     $edit->tcantidad->readonly = true;
     $edit->tcantidad->rule = 'numeric';
     $edit->tcantidad->size = 10;
     $edit->ttotal = new inputField("Precio total", "ttotal");
     $edit->ttotal->db_name = 'total';
     $edit->ttotal->css_class = 'inputnum';
     $edit->ttotal->readonly = true;
     $edit->ttotal->rule = 'numeric';
     $edit->ttotal->size = 10;
     $status = $edit->get_from_dataobjetct('status');
     if ($status == 'P') {
         $edit->buttons("save", "modify", "delete");
         $action = "javascript:window.location='" . site_url($this->url . 'actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_status", 'Marcar Como terminada', $action, "TR", "show");
     } elseif ($status == 'C') {
         $action = "javascript:btn_anula('" . $edit->rapyd->uri->get_edited_id() . "')";
         $edit->button_status("btn_rever", 'Reversar', $action, "TR", "show");
     }
     $edit->buttons("add", "save", "undo", "back", "add_rel");
     $edit->build();
     $smenu['link'] = barra_menu('193');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_suminr', $conten, true);
     //$data['content'] = $edit->output;
     $data['title'] = "Nota de Recepci&oacute;n";
     $data["head"] = script('jquery.js') . script('jquery-ui.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js') . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Example #2
0
 function dataedit()
 {
     //$this->datasis->modulo_id(70,1);
     $this->rapyd->load('dataobject', 'datadetails');
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'rif' => 'RIF', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;digo', 'nombre' => 'Nombre', 'rif' => 'RIF'), 'retornar' => array('proveed' => 'cod_prov', 'nombre' => 'nombrep', 'reteiva' => 'reteiva_prov', 'rif' => 'rif'), 'script' => array('cal_lislr()', 'cal_total()'), 'titulo' => 'Buscar Beneficiario');
     $bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
     $do = new DataObject("otrabajo");
     $do->order_by('itotrabajo', 'itotrabajo.id', 'desc');
     $do->rel_one_to_many('itotrabajo', 'itotrabajo', array('numero' => 'numero'));
     $do->pointer('sprv', 'sprv.proveed=otrabajo.cod_prov', 'sprv.nombre as nombrep, sprv.rif as rif', 'LEFT');
     $edit = new DataDetails("Orden de Compra", $do);
     $edit->back_url = site_url("presupuesto/otrabajo/filteredgrid");
     $edit->set_rel_title('itotrabajo', 'Rubro <#o#>');
     $status = $edit->get_from_dataobjetct('status');
     $edit->pre_process('insert', '_valida');
     $edit->pre_process('update', '_valida');
     //$edit->pre_process('delete'  ,'_pre_delete');
     //
     //$edit->post_process('insert','_post_insert');
     //$edit->post_process('update','_post_update');
     //$edit->post_process('delete','_post_delete');
     $a = '';
     switch ($status) {
         case 'P':
             $a = "Sin Comprometer";
             break;
         case 'C':
             $a = "Comprometida";
             break;
         case 'T':
             $a = "Causada";
             break;
         case 'O':
             $a = "Ordenado Pago";
             break;
         case 'E':
             $a = "Pagado";
             break;
         case 'E':
             $a = "No Terminada";
             break;
     }
     $edit->status = new freeField("Estado", 'estado', $a);
     $edit->numero = new inputField("N&uacute;mero", "numero");
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show');
     $edit->fecha = new dateonlyField("Fecha", "fecha");
     $edit->fecha->dbformat = 'Ymd';
     $edit->fecha->insertValue = date('Ymd');
     $edit->fecha->size = 12;
     if ($status == 'P') {
         $edit->fecha->readonly = true;
     }
     //$edit->fecha->readonly = true;
     //$edit->fecha->mode="autohide";
     //$edit->fecha->when = array("show","modify");
     $edit->fecha->rule = "callback_chfecha";
     $edit->status = new dropdownField("Estado", "status");
     $edit->status->option("", "");
     $edit->status->option("P", "Sin Comprometer");
     $edit->status->option("C", "Comprometido");
     $edit->status->option("T", "Causado");
     $edit->status->option("O", "Ordenado Pago");
     $edit->status->option("E", "Pagado");
     $edit->status->option("A", "Anulado");
     $edit->status->option("R", "Reversado");
     $edit->status->option("M", "Sin Terminar");
     $edit->status->option("p", "Por Modificar");
     $edit->status->when = array('show');
     if ($status == 'P') {
         $edit->status->readonly = true;
     }
     //$edit->status->readonly = true;
     $edit->usolicita = new dropdownField("Unidad Solicitante", "usolicita");
     $edit->usolicita->options("SELECT codigo, nombre FROM uejecutora ORDER BY nombre");
     $edit->usolicita->style = "width:250px";
     $lsnc = '<a href="javascript:consulsprv();" title="Proveedor" onclick="">Consulta/Agrega BENEFICIARIO</a>';
     $edit->cod_prov = new inputField("Beneficiario", 'cod_prov');
     $edit->cod_prov->size = 4;
     $edit->cod_prov->rule = "trim|required";
     $edit->cod_prov->append($bSPRV);
     //$edit->cod_prov->readonly=true;
     if ($status == 'P') {
         $edit->cod_prov->readonly = true;
     }
     $edit->cod_prov->append($lsnc);
     $edit->cod_prov->onchange = "cal_nprov();";
     //$edit->cod_prov->mode="autohide";
     $edit->nombrep = new inputField("Nombre Beneficiario", 'nombrep');
     $edit->nombrep->size = 20;
     //$edit->nombrep->readonly = true;
     $edit->nombrep->pointer = true;
     if ($status == 'P') {
         $edit->nombrep->readonly = true;
     }
     //$edit->nombrep->readonly = true;
     $edit->reteiva_prov = new inputField("% R.IVA", "reteiva_prov");
     $edit->reteiva_prov->size = 2;
     //$edit->reteiva_prov->mode="autohide";
     $edit->reteiva_prov->when = array('modify', 'create', 'show');
     $edit->reteiva_prov->readonly = true;
     if ($status == 'P') {
         $edit->reteiva_prov->readonly = true;
     }
     $edit->rif = new inputField("RIF", "rif");
     $edit->rif->size = 10;
     $edit->rif->pointer = true;
     if ($status == 'P') {
         $edit->rif->readonly = true;
     }
     $edit->creten = new dropdownField("Codigo ISLR: ", "creten");
     //$edit->creten->option("","");
     $edit->creten->options("SELECT codigo,CONCAT_WS(' ',codigo,activida) FROM rete ORDER BY codigo");
     $edit->creten->style = "width:300px;";
     $edit->creten->onchange = 'cal_total();';
     if ($status == 'P') {
         $edit->creten->readonly = true;
     }
     $edit->condiciones = new textAreaField("Condiciones Especiales", 'condiciones');
     $edit->condiciones->rule = "trim";
     $edit->condiciones->cols = 25;
     $edit->condiciones->rows = 2;
     $edit->lentrega = new textAreaField("Lugar de Entrega", 'lentrega');
     $edit->lentrega->cols = 25;
     $edit->lentrega->rows = 2;
     if ($status == 'P') {
         $edit->lentrega->readonly = true;
     }
     if ($this->datasis->traevalor("USAOCOMPRAPROCED") == 'S') {
         $edit->proced = new inputField("Procedimiento", "proced");
         $edit->proced->size = 20;
         //$edit->proced->typ;='inputhidden';
     }
     if ($this->datasis->traevalor("USACOMPEFP") == 'S') {
         $edit->pentret = new dropdownField("Plazo Entrega", "pentret");
         $edit->pentret->option("M", "Meses");
         $edit->pentret->option("H", "Dias Habiles");
         $edit->pentret->option("C", "Dias Continuos");
         $edit->pentret->style = "width:150px;";
         if ($status == 'P') {
             $edit->pentret->readonly = true;
         }
         $edit->pentrec = new inputField("", 'pentrec');
         $edit->pentrec->size = 5;
         $edit->pentrec->css_class = 'inputnum';
         $edit->pentrec->rule = 'required|numeric';
         if ($status == 'P') {
             $edit->pentrec->readonly = true;
         }
     }
     $edit->subtotal = new inputField("Total Base Imponible", 'subtotal');
     $edit->subtotal->css_class = 'inputnum';
     $edit->subtotal->size = 8;
     if ($status == 'P') {
         $edit->subtotal->readonly = true;
     }
     //$edit->subtotal->mode="autohide";
     $edit->ivaa = new inputField("IVA Sobre Tasa", 'ivaa');
     $edit->ivaa->css_class = 'inputnum';
     $edit->ivaa->size = 8;
     if ($status == 'P') {
         $edit->ivaa->readonly = true;
     }
     //$edit->ivaa->mode="autohide";
     $edit->ivag = new inputField("IVA Tasa General", 'ivag');
     $edit->ivag->css_class = 'inputnum';
     $edit->ivag->size = 8;
     if ($status == 'P') {
         $edit->ivag->readonly = true;
     }
     //$edit->ivag->mode="autohide";
     $edit->ivar = new inputField("IVA Tasa reducida", 'ivar');
     $edit->ivar->css_class = 'inputnum';
     $edit->ivar->size = 8;
     if ($status == 'P') {
         $edit->ivar->readonly = true;
     }
     //$edit->ivar->mode="autohide";
     $edit->exento = new inputField("Exento", 'exento');
     $edit->exento->css_class = 'inputnum';
     $edit->exento->size = 8;
     if ($status == 'P') {
         $edit->exento->readonly = true;
     }
     //$edit->exento->mode="autohide";
     $edit->reteiva = new inputField("Retencion de IVA", 'reteiva');
     $edit->reteiva->css_class = 'inputnum';
     $edit->reteiva->size = 8;
     if ($status == 'P') {
         $edit->reteiva->readonly = true;
     }
     //$edit->reteiva->mode="autohide";
     $edit->reten = new inputField("Retencion de ISLR", 'reten');
     $edit->reten->css_class = 'inputnum';
     $edit->reten->size = 8;
     if ($status == 'P') {
         $edit->reten->readonly = true;
     }
     //$edit->reten->mode="autohide";
     $edit->total2 = new inputField("Total", 'total2');
     $edit->total2->css_class = 'inputnum';
     $edit->total2->size = 8;
     if ($status == 'P') {
         $edit->total2->readonly = true;
     }
     //$edit->total2->mode="autohide";
     $edit->itdescripcion = new textareaField("(<#o#>) Descripci&oacute;n", "descripcion_<#i#>");
     $edit->itdescripcion->db_name = 'descripcion';
     $edit->itdescripcion->cols = 30;
     $edit->itdescripcion->rows = 2;
     //$edit->itdescripcion->rule     = 'required';
     $edit->itdescripcion->rel_id = 'itotrabajo';
     //$edit->itdescripcion->mode="autohide";
     $edit->itunidad = new dropdownField("(<#o#>) Unidad", "unidad_<#i#>");
     $edit->itunidad->db_name = 'unidad';
     $edit->itunidad->rule = 'required';
     $edit->itunidad->rel_id = 'itotrabajo';
     $edit->itunidad->options("SELECT unidades AS id,unidades FROM unidad ORDER BY unidades");
     $edit->itunidad->style = "width:70px";
     //$edit->itunidad->mode="autohide";
     $edit->itcantidad = new inputField("(<#o#>) Cantidad", "cantidad_<#i#>");
     $edit->itcantidad->css_class = 'inputnum';
     $edit->itcantidad->db_name = 'cantidad';
     $edit->itcantidad->rel_id = 'itotrabajo';
     $edit->itcantidad->rule = 'numeric';
     $edit->itcantidad->onchange = 'cal_importe(<#i#>);';
     $edit->itcantidad->size = 4;
     //$edit->itcantidad->mode="autohide";
     $edit->itprecio = new inputField("(<#o#>) Precio", "precio_<#i#>");
     $edit->itprecio->css_class = 'inputnum';
     $edit->itprecio->db_name = 'precio';
     $edit->itprecio->rel_id = 'itotrabajo';
     $edit->itprecio->rule = 'callback_positivo';
     $edit->itprecio->onchange = 'cal_importe(<#i#>);';
     $edit->itprecio->size = 6;
     //$edit->itprecio->mode="autohide";
     $edit->itiva = new dropdownField("(<#o#>) IVA", "iva_<#i#>");
     $edit->itiva->db_name = 'iva';
     $edit->itiva->rel_id = 'itotrabajo';
     $edit->itiva->onchange = 'cal_importe(<#i#>);';
     $edit->itiva->options($this->_ivaplica());
     $edit->itiva->option("0", "0%");
     $edit->itiva->style = "width:80px";
     $edit->itimporte = new inputField("(<#o#>) Importe", "importe_<#i#>");
     $edit->itimporte->css_class = 'inputnum';
     $edit->itimporte->db_name = 'importe';
     $edit->itimporte->rel_id = 'itotrabajo';
     $edit->itimporte->rule = 'numeric';
     $edit->itimporte->onchange = 'cal_importep(<#i#>);';
     //$edit->itimporte->readonly =true;
     $edit->itimporte->size = 8;
     if ($status == 'P') {
         $edit->itimporte->readonly = true;
     }
     //$edit->itimporte->mode="autohide";
     $edit->redondear = new dropdownField("Redondear", "redondear");
     $edit->redondear->option("R2", "Sumar Redondear 2 Decimales");
     $edit->redondear->option("R0", "Sumar SIN Redondear 2 Decimales");
     //$edit->redondear->onchange = "cal_total();";
     if ($status == 'P') {
         $edit->buttons("modify");
         $edit->buttons("save");
         $action = "javascript:window.location='" . site_url('presupuesto/otrabajo/terminada/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_status", 'Marcar Como terminada', $action, "TR", "show");
         $action = "javascript:btn_anular('" . $edit->rapyd->uri->get_edited_id() . "')";
         $edit->button_status("btn_anular", 'Anular', $action, "TR", "show");
     } elseif ($status == 'C') {
         $action = "javascript:btn_noterminada('" . $edit->rapyd->uri->get_edited_id() . "')";
         $edit->button_status("btn_rever", 'Marcar como NO Terminada', $action, "TR", "show");
     } elseif ($status == 'A') {
         $edit->buttons("delete");
     } else {
         $edit->buttons("modify");
         $edit->buttons("save");
     }
     $edit->buttons("undo", "back", "add_rel", "add");
     $edit->build();
     $ivaplica = $this->ivaplica2();
     $conten['ivar'] = $ivaplica['redutasa'];
     $conten['ivag'] = $ivaplica['tasa'];
     $conten['ivaa'] = $ivaplica['sobretasa'];
     $conten['title2'] = $this->t**s;
     $smenu['link'] = barra_menu('12A');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_otrabajo', $conten, true);
     $data['title'] = $this->t**s;
     $data["head"] = script('jquery.js') . script('jquery-ui.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js') . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Example #3
0
 function dataedit()
 {
     //$this->datasis->modulo_id(115,1);
     $this->rapyd->load('dataobject', 'datadetails');
     $modbus = array('tabla' => 'ppla', 'columnas' => array('codigo' => 'Codigo', 'denominacion' => 'Denominaci&oacute;n'), 'filtro' => array('codigo' => 'Codigo', 'denominacion' => 'Denominaci&oacute;n'), 'retornar' => array('codigo' => 'itcodigopres_<#i#>'), 'p_uri' => array(4 => '<#i#>'), 'where' => 'movimiento = "S" AND MID(codigo,1,1)="4"', 'script' => array('cal_nppla(<#i#>)'), 'titulo' => 'Busqueda de partidas', 'title' => 'Haz click aqui para abrir una ventana nueva con el modulo de busqueda avanzada para seleccionar una partida');
     $btn = $this->datasis->p_modbus($modbus, '<#i#>');
     $do = new DataObject("anoprox");
     $do->rel_one_to_many('itanoprox', 'itanoprox', array('numero' => 'numero'));
     $do->rel_pointer('itanoprox', 'ppla', 'ppla.codigo=itanoprox.codigopres', "ppla.denominacion as denomia");
     $do->order_by('itanoprox.codigopres');
     $msj = "ERROR: DEBE SOLUCIONAR LOS SIGUIENTES PROBLEMAS:</br>";
     if (!empty($do->error_message_ar['pre_ins'])) {
         $do->error_message_ar['pre_ins'] = $msj . $do->error_message_ar['pre_ins'];
     }
     if (!empty($do->error_message_ar['pre_upd'])) {
         $do->error_message_ar['pre_upd'] = $msj . $do->error_message_ar['pre_upd'];
     }
     $edit = new DataDetails($this->t**s, $do);
     $edit->back_url = site_url($this->url . "filteredgrid", "assas");
     $edit->set_rel_title('itanoprox', 'Rubro <#o#>');
     $status = $edit->get_from_dataobjetct('status');
     $edit->pre_process('insert', '_valida');
     $edit->pre_process('update', '_valida');
     $edit->post_process('insert', '_post_insert');
     $edit->post_process('update', '_post_update');
     $edit->post_process('delete', '_post_delete');
     //**************************INICIO ENCABEZADO********************************************************************
     $edit->numero = new inputField("N&uacute;mero", "numero");
     //$edit->numero->rule = "callback_chexiste";
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show', 'modify');
     $edit->responsable = new inputField("Responsable", "responsable");
     $edit->responsable->maxlenth = 249;
     $edit->responsable->tip = "Completar este campo con el Nombre y Apellido del responsable o Director de la Direcci&oacute;n.</br></br> Ejemplo:Juan Perez";
     $edit->fecha = new dateonlyField("Fecha", "fecha", "d/m/Y");
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->size = 12;
     $edit->fecha->mode = "autohide";
     $edit->fecha->when = array('show', 'modify');
     //$edit->concepto = new textareaField("Concepto", 'concepto');
     //$edit->concepto->rows    = 1;
     //$edit->concepto->cols    = 80;
     //$edit->concepto->tip     = "Introduzca alg&uacute;n concepto de ser necesario. Este es muy &uacute;til cuando se hacen varias proyecciones de una misma dependencia.</br>Ejemplo:Esta lista es de prioridad uno &oacute; Esta pertenece al departamento X";
     $edit->uejecuta = new dropdownField("Direcci&oacute;n", "uejecuta");
     $edit->uejecuta->option("", "Seccionar");
     $edit->uejecuta->options("SELECT codigo,CONCAT(codigo,' ',nombre)a FROM uejecutora ORDER BY nombre");
     $edit->uejecuta->onchange = "get_uadmin();";
     $edit->uejecuta->rule = "required";
     $edit->uejecuta->tip = "Seleccione el nombre de la Direcci&oacute;n a la cual pertenece, haciendo click en la flecha del lado derecho del campo</br> Ejemplo: Direcci&oacute;n de Administraci&oacute;n";
     $edit->uejecuta->style = "width:500px";
     //$edit->uadministra = new dropdownField("U.Administrativa", "uadministra");
     //$edit->uadministra->option("","Ninguna");
     //$ueje=$edit->getval('uejecuta');
     //if($ueje!==false){
     //	$edit->uadministra->options("SELECT codigo,nombre FROM uadministra WHERE codigoejec='$ueje' ORDER BY nombre");
     //}else{
     //	$edit->uadministra->option("","Seleccione una unidad ejecutora primero");
     //}
     //$edit->uadministra->tip      = "Seleccione el nombre de la unidad Administrativa de ser necesario haciendo click en la flecha del lado derecho del campo.</br>Ejemplo: Departamento de Compras";
     //************************** FIN   ENCABEZADO********************************************************************
     //**************************INICIO DETALLE DE ASIGNACIONES  *****************************************************
     $edit->itcodigoadm = new inputField("(<#o#>) Actividad", "itcodigoadm_<#i#>");
     $edit->itcodigoadm->rule = 'required';
     $edit->itcodigoadm->size = 2;
     $edit->itcodigoadm->db_name = 'codigoadm';
     $edit->itcodigoadm->rel_id = 'itanoprox';
     $edit->itcodigoadm->insertValue = "51";
     $edit->itcodigoadm->tip = "Trasncriba el numero de la actividad a la cual pertenece este item.</br></br>Ejemplo:52";
     $edit->itcodigopres = new inputField("(<#o#>) Partida", "itcodigopres_<#i#>");
     $edit->itcodigopres->rule = 'required|callback_itorden';
     $edit->itcodigopres->size = 12;
     $edit->itcodigopres->db_name = 'codigopres';
     $edit->itcodigopres->rel_id = 'itanoprox';
     $edit->itcodigopres->insertValue = "4.";
     $edit->itcodigopres->append($btn);
     $edit->itcodigopres->tip = "Trasncriba, Seleccione o Busque por medio de la Lupa, La partida a la cual corresponde el bien.</br></br>Ejemplo:4.03.03.03";
     $edit->itdenomia = new textareaField("(<#o#>)", "itdenomia_<#i#>");
     $edit->itdenomia->db_name = 'denomia';
     $edit->itdenomia->rel_id = 'itanoprox';
     $edit->itdenomia->pointer = true;
     $edit->itdenomia->cols = 15;
     $edit->itdenomia->rows = 2;
     $edit->itdenomia->readonly = true;
     $edit->itdenomia->tip = "Este campos es solo referencial, no debe de trancribir en el, el sistema lo har&aacute; automaticamente";
     $edit->itunidad = new dropdownField("(<#o#>) Unidad", "unidad_<#i#>");
     $edit->itunidad->db_name = 'unidad';
     $edit->itunidad->rule = 'required';
     $edit->itunidad->rel_id = 'itanoprox';
     $edit->itunidad->options("SELECT unidades AS id,unidades FROM unidad ORDER BY unidades");
     $edit->itunidad->style = "width:80px";
     $edit->itunidad->tip = "Seleccione la unidad de medida del bien.</br>Ejemplo: Unidad";
     $edit->itdescrip = new inputField("(<#o#>) Bien", "itdescrip_<#i#>");
     $edit->itdescrip->rule = 'required';
     $edit->itdescrip->size = 20;
     $edit->itdescrip->db_name = 'descrip';
     $edit->itdescrip->rel_id = 'itanoprox';
     $edit->itdescrip->tip = "Transcriba un nombre corto o referencial del bien</br></br>Ejemplo: Monitor";
     $edit->itdescripd = new textareaField("(<#o#>) Descripci&oacute;n Detallada", "itdescripd_<#i#>");
     $edit->itdescripd->rule = 'required';
     $edit->itdescripd->db_name = 'descripd';
     $edit->itdescripd->rel_id = 'itanoprox';
     $edit->itdescripd->cols = 25;
     $edit->itdescripd->rows = 2;
     $edit->itdescripd->tip = 'Transcriba la descripci&oacute;n detallada del bien.</br></br>Ejemplo: Monitor LCD 22 pulgadas con entrada de video para usar como TV';
     $edit->itcant = new inputField("(<#o#>) C&aacute;ntidad", "itcant_<#i#>");
     $edit->itcant->css_class = 'inputnum';
     $edit->itcant->rule = 'required|callback_positivo';
     $edit->itcant->size = 7;
     $edit->itcant->db_name = 'cant';
     $edit->itcant->rel_id = 'itanoprox';
     $edit->itcant->tip = "Transcriba la cantidad de elementos ha adquirir.</br>Ejemplo: 2";
     //$edit->itmontoa->mode      ="autohide";
     //************************** FIN   DETALLE DE ORDENES DEPAGO*****************************************************
     $status = $edit->get_from_dataobjetct('status');
     if ($status == 'H1') {
         $action = "javascript:window.location='" . site_url($this->url . 'termina/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_add_anoprox", 'AGREGAR BIEN', "javascript:add_itanoprox()", "MB", 'modify', "button_add_rel");
         $edit->button_status("btn_add_anoprox", 'AGREGAR BIEN', "javascript:add_itanoprox()", "MB", 'create', "button_add_rel");
         $edit->button_status("btn_termina", 'Marcar Documento Como Terminado', $action, "TR", "show");
         $edit->buttons("modify", "save");
     } elseif ($status == 'H2') {
         $action = "javascript:btn_anular('" . $edit->rapyd->uri->get_edited_id() . "')";
         $edit->button_status("btn_anula", 'Anular', $action, "TR", "show");
     } else {
         $edit->button_status("btn_add_anoprox", 'AGREGAR BIEN', "javascript:add_itanoprox()", "MB", 'modify', "button_add_rel");
         $edit->button_status("btn_add_anoprox", 'AGREGAR BIEN', "javascript:add_itanoprox()", "MB", 'create', "button_add_rel");
     }
     $edit->buttons("save", "undo", "back");
     $edit->build();
     $smenu['link'] = barra_menu('10C');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_anoprox', $conten, true);
     //$data['content'] = $edit->output;
     $data['title'] = $this->t**s;
     $data["head"] = $this->rapyd->get_head() . script('jquery.js') . script('jquery-ui.js') . script('plugins/jquery.meiomask.js') . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.json.min.js") . script('plugins/jquery.tooltip.js') . script('plugins/jquery.autocomplete.js') . style('jquery.autocomplete.css') . style('jquery.tooltip.css') . style('tooltip.css') . style('vino/jquery-ui.css');
     //
     $this->load->view('view_ventanas', $data);
 }
Example #4
0
    function dataedit($cliente)
    {
        if (!$this->_exitescli($cliente)) {
            redirect($this->url . 'filterscli');
        }
        $this->rapyd->load('dataobject', 'dataedit');
        $this->rapyd->uri->keep_persistence();
        $this->load->helper('form');
        $do = new DataObject('pfac');
        $do->rel_one_to_many('itpfac', 'itpfac', array('numero' => 'numa'));
        $do->pointer('scli', 'scli.cliente=pfac.cod_cli', 'scli.tipo AS sclitipo', 'left');
        $do->rel_pointer('itpfac', 'sinv', 'itpfac.codigoa=sinv.codigo', 'sinv.descrip AS sinvdescrip,
			sinv.iva AS sinviva,
			sinv.pond AS sinvpond,
			sinv.mmargen AS sinvmmargen,
			sinv.ultimo sinvultimo,sinv.formcal AS sinvformcal,
			sinv.pm AS sinvpm,
			sinv.existen AS pexisten,
			sinv.marca AS pmarca,
			sinv.descrip AS pdesca,
			sinv.escala1  AS sinvescala1,
			sinv.pescala1 AS sinvpescala1,
			sinv.escala2  AS sinvescala2,
			sinv.pescala2 AS sinvpescala2,
			sinv.escala3  AS sinvescala3,
			sinv.pescala3 AS sinvpescala3');
        $do->order_by('itpfac', 'sinv.marca', ' ');
        $do->order_by('itpfac', 'sinv.descrip', ' ');
        $edit = new DataEdit('Pedidos', $do);
        $edit->back_url = site_url('ventas/pfaclitemayor/filteredgrid');
        //$edit->set_rel_title('itpfac', 'Producto <#o#>');
        $edit->pre_process('insert', '_pre_insert');
        $edit->pre_process('update', '_pre_update');
        $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->fecha = new inputField('Fecha', 'fecha');
        $edit->fecha->insertValue = date('Y-m-d');
        //$edit->fecha->rule = 'required';
        $edit->fecha->mode = 'autohide';
        $edit->fecha->size = 10;
        $usr = $this->session->userdata('usuario');
        $vd = $this->datasis->dameval("SELECT vendedor FROM usuario WHERE us_codigo='{$usr}'");
        $edit->vd = new hiddenField('Vendedor', 'vd');
        $edit->vd->value = $vd;
        $edit->mmargen = new inputField('mmargen', 'mmargen');
        $edit->numero = new inputField('N&uacute;mero', 'numero');
        $edit->numero->size = 10;
        $edit->numero->mode = 'autohide';
        $edit->numero->maxlength = 8;
        $edit->numero->apply_rules = false;
        //necesario cuando el campo es clave y no se pide al usuario
        $edit->numero->when = array('show', 'modify');
        $edit->cliente = new hiddenField('Cliente', 'cod_cli');
        $edit->cliente->insertValue = $cliente;
        //$edit->cliente->options("SELECT cliente, nombre FROM scli WHERE vendedor='$vd' LIMIT 5");
        $edit->rifci = new inputField('RIF/CI', 'rifci');
        $edit->rifci->autocomplete = false;
        $edit->rifci->size = 15;
        $edit->rifci->type = 'inputhidden';
        $edit->direc = new inputField('Direcci&oacute;n', 'direc');
        $edit->direc->size = 40;
        $edit->direc->type = 'inputhidden';
        $edit->observa = new inputField('Observaciones', 'observa');
        $edit->observa->size = 25;
        $edit->observ1 = new inputField('Observaciones', 'observ1');
        $edit->observ1->size = 25;
        //Descuento por grupo y cliente
        $sel = array('a.mmargen', 'b.margen');
        $this->db->select($sel);
        $this->db->from('scli AS a');
        $this->db->join('zona AS b', 'a.zona=b.codigo', 'left');
        $this->db->where('a.cliente', $cliente);
        $qdes = $this->db->get();
        if ($qdes->num_rows() > 0) {
            $rdes = $qdes->row();
        } else {
            $rdes = new stdClass();
            $rdes->mmargen = 0;
            $rdes->margen = 0;
        }
        // Campos para el detalle
        $i = 0;
        $sel = array('a.codigo', 'a.descrip', 'a.existen', 'a.marca', 'a.iva', 'e.sinv_id', 'ROUND(IF(formcal="U",ultimo,IF(formcal="P",pond,GREATEST(ultimo,pond)))*(100+a.mmargen)/100,2) AS precio', 'IF(formcal="U",ultimo,IF(formcal="P",pond,GREATEST(ultimo,pond))) AS costo', 'a.mmargen', 'a.mmargenplus', 'c.margen AS DM', 'd.margen AS DG', 'a.escala1', 'a.pescala1', 'a.escala2', 'a.pescala2', 'a.escala3', 'a.pescala3');
        $this->db->distinct();
        $this->db->select($sel);
        $this->db->from('sinv AS a');
        $this->db->join('sinvfot AS e', 'a.id=e.sinv_id', 'left');
        $this->db->where('a.activo', 'S');
        $this->db->where('a.tipo', 'Articulo');
        $this->db->orderby('a.marca');
        $this->db->orderby('a.descrip');
        $numero = $edit->get_from_dataobjetct('numero');
        if ($numero !== false) {
            $dbnumero = $this->db->escape($numero);
            $this->db->join('itpfac AS b', 'a.codigo=b.codigoa AND b.numa=' . $dbnumero);
        }
        $this->db->join('marc AS c', 'a.marca=c.marca');
        $this->db->join('grup AS d', 'a.grupo=d.grupo');
        $renglones = $this->datasis->traevalor('PFACMAYRENGLONES', 'Limites de renglones en el pedido al mayor');
        if (empty($renglones)) {
            $renglones = 300;
        }
        $this->db->limit($renglones);
        $query = $this->db->get();
        foreach ($query->result() as $row) {
            $obj = 'codigoa_' . $i;
            $edit->{$obj} = new hiddenField('C&oacute;digo <#o#>', $obj);
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->size = 12;
            $edit->{$obj}->db_name = 'codigoa';
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->rule = 'callback_chcodigoa';
            $edit->{$obj}->insertValue = $row->codigo;
            $obj = 'desca_' . $i;
            $desca = ucfirst(strtolower($row->descrip));
            if (!empty($row->sinv_id)) {
                $urldir = $this->config->slash_item('base_url') . 'images/foto.gif';
                $desca .= ' <img src="' . $urldir . '" onclick="verimage(\'' . $row->sinv_id . '\')">';
            }
            $edit->{$obj} = new freeField($obj, $obj, $desca);
            $edit->{$obj}->ind = $i;
            $obj = 'pexisten_' . $i;
            $edit->{$obj} = new freeField($obj, $obj, $row->existen);
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->pointer = true;
            $obj = 'cana_' . $i;
            $edit->{$obj} = new inputField('Cantidad <#o#>', $obj);
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->db_name = 'cana';
            $edit->{$obj}->css_class = 'inputnum';
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->maxlength = 10;
            $edit->{$obj}->size = 5;
            $edit->{$obj}->autocomplete = false;
            $edit->{$obj}->style = "height:25px;font-size:14";
            $edit->{$obj}->onkeyup = "cescala('{$i}')";
            $edit->{$obj}->rule = "callback_chescala[{$i}]";
            $obj = 'pmarca_' . $i;
            $edit->{$obj} = new inputField('', $obj);
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->db_name = 'pmarca';
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->pointer = true;
            $edit->{$obj}->insertValue = $row->marca;
            $obj = 'preca_' . $i;
            $edit->{$obj} = new inputField('Precio <#o#>', $obj);
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->db_name = 'preca';
            $edit->{$obj}->css_class = 'inputnum';
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->type = 'inputhidden';
            $edit->{$obj}->insertValue = $row->precio;
            $edit->{$obj}->rule = 'positive|callback_chpreca[<#i#>]';
            $obj = 'itiva_' . $i;
            $edit->{$obj} = new hiddenField('', $obj);
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->db_name = 'iva';
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->insertValue = $row->iva;
            $obj = 'dxapli_' . $i;
            $edit->{$obj} = new autoUpdateField('dxapli', '0', '0');
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->ind = $i;
            $obj = 'dxm_' . $i;
            if ($row->DM > 0) {
                $edit->{$obj} = new checkboxField('dxm', $obj, $row->DM, '0');
                $edit->{$obj}->insertValue = 0;
                $edit->{$obj}->onchange = "cprecio('{$i}')";
            } else {
                $edit->{$obj} = new autoUpdateField('dxm', '0', '0');
            }
            $edit->{$obj}->db_name = 'dxm';
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->rel_id = 'itpfac';
            $obj = 'dxg_' . $i;
            if ($row->DG > 0) {
                $edit->{$obj} = new checkboxField('dxg', $obj, $row->DG, '0');
                $edit->{$obj}->insertValue = 0;
                $edit->{$obj}->onchange = "cprecio('{$i}')";
            } else {
                $edit->{$obj} = new autoUpdateField('dxg', '0', '0');
            }
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->db_name = 'dxg';
            $edit->{$obj}->rel_id = 'itpfac';
            $obj = 'dxz_' . $i;
            if ($rdes->margen > 0) {
                $edit->{$obj} = new checkboxField('dxz', $obj, $rdes->margen, '0');
                $edit->{$obj}->insertValue = 0;
                $edit->{$obj}->onchange = "cprecio('{$i}')";
            } else {
                $edit->{$obj} = new autoUpdateField('dxz', '0', '0');
            }
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'dxz';
            $edit->{$obj}->ind = $i;
            $obj = 'dxc_' . $i;
            if ($rdes->mmargen > 0) {
                $edit->{$obj} = new checkboxField('dxe', $obj, $rdes->mmargen, '0');
                $edit->{$obj}->insertValue = 0;
                $edit->{$obj}->onchange = "cprecio('{$i}')";
            } else {
                $edit->{$obj} = new autoUpdateField('dxe', '0', '0');
            }
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'dxc';
            $edit->{$obj}->ind = $i;
            $obj = 'dxp_' . $i;
            if ($row->mmargenplus > 0) {
                $edit->{$obj} = new checkboxField('dxp', $obj, $row->mmargenplus, '0');
                $edit->{$obj}->insertValue = 0;
                $edit->{$obj}->onchange = "cprecio('{$i}')";
            } else {
                $edit->{$obj} = new autoUpdateField('dxp', '0', '0');
            }
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'dxp';
            $edit->{$obj}->ind = $i;
            $p_es = 0;
            for ($u = 1; $u < 4; $u++) {
                $nom = "escala{$u}";
                $obj = "{$nom}_{$i}";
                $edit->{$obj} = new hiddenField('', $obj);
                $edit->{$obj}->insertValue = $row->{$nom};
                $edit->{$obj}->rel_id = 'itpfac';
                $edit->{$obj}->db_name = 'sinv' . $nom;
                $edit->{$obj}->ind = $i;
                $edit->{$obj}->pointer = true;
                $nom = "pescala{$u}";
                $obj = "{$nom}_{$i}";
                $edit->{$obj} = new hiddenField('', $obj);
                $edit->{$obj}->insertValue = $row->{$nom};
                $edit->{$obj}->rel_id = 'itpfac';
                $edit->{$obj}->db_name = 'sinv' . $nom;
                $edit->{$obj}->ind = $i;
                $edit->{$obj}->pointer = true;
                $p_es += $row->{$nom};
            }
            $gdxe = $edit->get_from_dataobjetct_rel('itpfac', 'dxe', $i);
            $obj = 'dxe_' . $i;
            if ($p_es > 0) {
                $gdxe = $edit->get_from_dataobjetct_rel('itpfac', 'dxe', $i);
                $edit->{$obj} = new checkboxField('dxe', $obj, $gdxe == false ? '0' : $gdxe, '0');
                $edit->{$obj}->onchange = "cescala('{$i}')";
            } else {
                $edit->{$obj} = new autoUpdateField('dxp', '0', '0');
            }
            //$edit->$obj->insertValue = 0;
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'dxe';
            $edit->{$obj}->ind = $i;
            $obj = 'sinvmmargen_' . $i;
            $edit->{$obj} = new hiddenField('', $obj);
            $edit->{$obj}->insertValue = $row->mmargen;
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'sinvmmargen';
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->pointer = true;
            $obj = 'costo_' . $i;
            $edit->{$obj} = new hiddenField('', $obj);
            $edit->{$obj}->insertValue = $row->costo;
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'costo';
            $edit->{$obj}->ind = $i;
            $obj = 'tota_' . $i;
            $edit->{$obj} = new hiddenField('', $obj);
            $edit->{$obj}->insertValue = 0;
            $edit->{$obj}->rel_id = 'itpfac';
            $edit->{$obj}->db_name = 'tota';
            $edit->{$obj}->ind = $i;
            $i++;
        }
        $sinvcana = $i;
        // fin de campos para detalle
        $edit->ivat = new inputField('Impuesto', 'iva');
        $edit->ivat->css_class = 'inputnum';
        $edit->ivat->type = 'inputhidden';
        $edit->ivat->readonly = true;
        $edit->ivat->size = 10;
        $edit->totals = new inputField('Sub-Total', 'totals');
        $edit->totals->css_class = 'inputnum';
        $edit->totals->type = 'inputhidden';
        $edit->totals->readonly = true;
        $edit->totals->size = 10;
        $edit->totalg = new inputField('Monto Total', 'totalg');
        $edit->totalg->css_class = 'inputnum';
        $edit->totalg->type = 'inputhidden';
        $edit->totalg->readonly = true;
        $edit->totalg->size = 10;
        $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd'));
        $edit->hora = new autoUpdateField('hora', date('H:i:s'), date('H:i:s'));
        $edit->usuario = new autoUpdateField('usuario', $this->secu->usuario(), $this->secu->usuario());
        $control = $this->rapyd->uri->get_edited_id();
        if ($edit->getstatus() == 'show') {
            $action = "javascript:window.location='" . site_url($this->url . 'filterscli') . "'";
            $edit->button('btn_add', 'Agregar', $action, 'TR');
        }
        $edit->buttons('save', 'undo', 'modify', 'delete', 'back');
        if ($this->genesal) {
            $edit->build();
            $conten['cana'] = $sinvcana;
            $conten['form'] =& $edit;
            $conten['title'] = heading('Pedidos No. ' . $edit->numero->value);
            $data['head'] = style('mayor/estilo.css');
            $data['script'] = script('jquery.js');
            $data['script'] .= phpscript('nformat.js');
            $data['content'] = $this->load->view('view_pfaclitemayor', $conten, true);
            $data['title'] = '';
            $this->load->view('view_ventanas_lite', $data);
        } else {
            $edit->on_save_redirect = false;
            $edit->build();
            if ($edit->on_success()) {
                echo 'Pedido Guardado';
            } elseif ($edit->on_error()) {
                echo html_entity_decode(preg_replace('/<[^>]*>/', '', $edit->error_string));
            }
        }
    }
Example #5
0
 function pprov($id_sprv)
 {
     $id_sprv = intval($id_sprv);
     $row = $this->datasis->damerow('SELECT proveed,nombre,rif FROM sprv WHERE id=' . $id_sprv);
     if (empty($row)) {
         echo 'El usuario debe tener registrado un cajero para poder usar este modulo';
         return '';
     }
     $proveed = $row['proveed'];
     $sprv_nombre = $row['nombre'];
     $sprv_rif = $row['rif'];
     if (date('d') <= 15) {
         $pdia = '01';
         $dia = '15';
     } else {
         $pdia = '16';
         $dia = date('d', mktime(0, 0, 0, date('n'), 0));
     }
     $rivafechai = date('Ym' . $pdia);
     $rivafechac = date('Ym' . $dia);
     $this->rapyd->load('dataobject', 'datadetails');
     $do = new DataObject('sprm');
     $do->rel_one_to_many('itppro', 'itppro', array('tipo_doc' => 'tipoppro', 'numero' => 'numppro', 'cod_prv' => 'cod_prv', 'transac' => 'transac'));
     $do->order_by('itppro', 'itppro.fecha');
     $edit = new DataDetails('Pago a proveedor', $do);
     $edit->on_save_redirect = false;
     $edit->set_rel_title('itppro', 'Efecto <#o#>');
     //$edit->set_rel_title('sfpa'  , 'Forma de pago <#o#>');
     $edit->pre_process('insert', '_pre_pprv_insert');
     $edit->pre_process('update', '_pre_pprv_update');
     $edit->pre_process('delete', '_pre_pprv_delete');
     $edit->post_process('insert', '_post_pprv_insert');
     //$edit->post_process('delete', '_post_pprv_delete');
     $edit->cod_prv = new hiddenField('Proveedor', 'cod_prv');
     $edit->cod_prv->rule = 'existesprv';
     $edit->cod_prv->size = 7;
     $edit->cod_prv->insertValue = $proveed;
     $edit->cod_prv->maxlength = 5;
     $edit->nombre = new inputField('Nombre', 'nombre');
     $edit->nombre->rule = 'max_length[40]';
     $edit->nombre->size = 42;
     $edit->nombre->maxlength = 40;
     $edit->tipo_doc = new dropdownField('Tipo doc.', 'tipo_doc');
     $edit->tipo_doc->option('AB', 'Abono');
     $edit->tipo_doc->option('NC', 'Nota de credito');
     $edit->tipo_doc->option('AN', 'Anticipo');
     $edit->tipo_doc->onchange = 'chtipodoc()';
     $edit->tipo_doc->style = 'width:140px;';
     $edit->tipo_doc->rule = 'enum[AB,NC,AN]|required';
     $edit->codigo = new dropdownField('Motivo', 'codigo');
     $edit->codigo->option('', 'Seleccionar');
     $edit->codigo->options('SELECT TRIM(codigo) AS cod, nombre FROM botr WHERE tipo=\'P\' ORDER BY nombre');
     $edit->codigo->style = 'width:200px;';
     $edit->codigo->rule = 'condi_required|callback_chobligatipo[NC]';
     $edit->numero = new inputField('N&uacute;mero', 'numero');
     $edit->numero->rule = 'max_length[8]';
     $edit->numero->size = 10;
     $edit->numero->maxlength = 8;
     $edit->fecha = new dateonlyField('Fecha', 'fecha');
     $edit->fecha->size = 12;
     $edit->fecha->maxlength = 8;
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->calendar = false;
     $edit->fecha->rule = 'chfecha|required';
     $edit->monto = new inputField('Total a pagar', 'monto');
     $edit->monto->rule = 'required|max_length[17]|numeric';
     $edit->monto->css_class = 'inputnum';
     $edit->monto->size = 19;
     $edit->monto->maxlength = 17;
     $edit->monto->type = 'inputhidden';
     $edit->observa1 = new textareaField('Concepto:', 'observa1');
     $edit->observa1->cols = 70;
     $edit->observa1->rows = 2;
     $edit->observa1->style = 'width:100%;';
     $edit->observa2 = new textareaField('', 'observa2');
     $edit->observa2->cols = 70;
     $edit->observa2->rows = 2;
     $edit->observa2->style = 'width:100%;';
     $edit->observa2->when = array('show');
     $edit->depto = new dropdownField('Asignar a departamento', 'depto');
     $edit->depto->option('', 'Seleccionar');
     $edit->depto->options('SELECT depto,CONCAT_WS(\'-\',depto,TRIM(descrip)) AS descrip FROM dpto WHERE tipo IN (\'G\',\'A\') ORDER BY descrip');
     $edit->depto->style = 'width:180px;';
     $edit->depto->rule = 'condi_required|callback_chdepto';
     $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'));
     //Campos propios de las NC
     //Campos comodines
     $arr_ptasa = array();
     $edit->apltasa = new dropdownField('', 'apltasa');
     $mSQL = 'SELECT fecha,tasa,redutasa,sobretasa FROM civa ORDER BY fecha DESC LIMIT 3';
     $query = $this->db->query($mSQL);
     foreach ($query->result() as $row) {
         $arr_ptasa[] = array(floatval($row->tasa), floatval($row->redutasa), floatval($row->sobretasa));
         $edit->apltasa->option($row->fecha, dbdate_to_human($row->fecha));
     }
     $edit->apltasa->onchange = 'chapltasa()';
     $edit->apltasa->style = 'width:100px;';
     $edit->apltasa->rule = 'condi_required|callback_chobligatipo[NC]';
     $ivas = $this->datasis->ivaplica();
     $edit->ptasa = new inputField('', 'ptasa');
     $edit->ptasa->rule = 'numeric';
     $edit->ptasa->type = 'inputhidden';
     $edit->ptasa->insertValue = $ivas['tasa'];
     $edit->ptasa->showformat = 'decimal';
     $edit->preducida = new inputField('', 'preducida');
     $edit->preducida->rule = 'numeric';
     $edit->preducida->type = 'inputhidden';
     $edit->preducida->insertValue = $ivas['redutasa'];
     $edit->preducida->showformat = 'decimal';
     $edit->padicional = new inputField('', 'padicional');
     $edit->padicional->rule = 'numeric';
     $edit->padicional->type = 'inputhidden';
     $edit->padicional->insertValue = $ivas['sobretasa'];
     $edit->padicional->showformat = 'decimal';
     //Fin de los comodines
     $edit->serie = new inputField('N&uacute;mero', 'serie');
     $edit->serie->rule = 'condi_required|callback_chobligatipo[NC]';
     $edit->serie->size = 15;
     $edit->serie->maxlength = 17;
     $edit->nfiscal = new inputField('Control F&iacute;scal', 'nfiscal');
     $edit->nfiscal->rule = 'condi_required|callback_chobligatipo[NC]';
     $edit->nfiscal->size = 15;
     $edit->nfiscal->maxlength = 17;
     $edit->montasa = new inputField('Montasa', 'montasa');
     $edit->montasa->rule = 'max_length[17]|numeric|positive';
     $edit->montasa->css_class = 'inputnum';
     $edit->montasa->size = 19;
     $edit->montasa->maxlength = 17;
     $edit->montasa->rule = 'condi_required|callback_chobligatipo[NC]';
     $edit->monredu = new inputField('Monredu', 'monredu');
     $edit->monredu->rule = 'max_length[17]|numeric|positive';
     $edit->monredu->css_class = 'inputnum';
     $edit->monredu->size = 19;
     $edit->monredu->maxlength = 17;
     $edit->monredu->rule = 'condi_required|callback_chobligatipo[NC]';
     $edit->monadic = new inputField('Monadic', 'monadic');
     $edit->monadic->rule = 'max_length[17]|numeric|positive';
     $edit->monadic->css_class = 'inputnum';
     $edit->monadic->size = 19;
     $edit->monadic->maxlength = 17;
     $edit->monadic->rule = 'condi_required|callback_chobligatipo[NC]';
     $edit->tasa = new inputField('general', 'tasa');
     $edit->tasa->rule = 'max_length[17]|numeric';
     $edit->tasa->css_class = 'inputnum';
     $edit->tasa->size = 12;
     $edit->tasa->maxlength = 17;
     $edit->tasa->rule = 'condi_required|callback_chobligatipo[NC]|callback_chmontasa[G]';
     $edit->reducida = new inputField('reducida', 'reducida');
     $edit->reducida->rule = 'max_length[17]|numeric|positive';
     $edit->reducida->css_class = 'inputnum';
     $edit->reducida->size = 12;
     $edit->reducida->maxlength = 17;
     $edit->reducida->rule = 'condi_required|callback_chobligatipo[NC]|callback_chmontasa[R]';
     $edit->sobretasa = new inputField('adicional', 'sobretasa');
     $edit->sobretasa->rule = 'max_length[17]|numeric|positive';
     $edit->sobretasa->css_class = 'inputnum';
     $edit->sobretasa->size = 12;
     $edit->sobretasa->maxlength = 17;
     $edit->sobretasa->rule = 'condi_required|callback_chobligatipo[NC]|callback_chmontasa[A]|positive';
     $edit->exento = new inputField('exento', 'exento');
     $edit->exento->rule = 'max_length[17]|numeric';
     $edit->exento->css_class = 'inputnum';
     $edit->exento->size = 19;
     $edit->exento->maxlength = 17;
     $edit->exento->rule = 'condi_required|callback_chobligatipo[NC]|positive';
     $edit->reteiva = new inputField('Ret. IVA', 'reteiva');
     $edit->reteiva->rule = 'max_length[17]|numeric';
     $edit->reteiva->css_class = 'inputnum';
     $edit->reteiva->size = 19;
     $edit->reteiva->maxlength = 17;
     $edit->reteiva->insertValue = '0';
     $edit->reteiva->rule = 'condi_required|callback_chobligatipo[NC]|positive';
     $edit->afecta = new inputField('Factura Afectada', 'afecta');
     $edit->afecta->rule = 'callback_chafectanc';
     $edit->afecta->size = 15;
     $edit->afecta->maxlength = 12;
     //Para la retencion de iva si aplica
     $contribu = trim($this->datasis->traevalor('CONTRIBUYENTE'));
     $rif = trim($this->datasis->traevalor('RIF'));
     if ($contribu == 'ESPECIAL' && strtoupper($rif[0]) != 'V') {
         $por_rete = $this->datasis->dameval('SELECT reteiva FROM sprv WHERE proveed=' . $this->db->escape($proveed));
         if ($por_rete != 100) {
             $por_rete = 0.75;
         } else {
             $por_rete = $por_rete / 100;
         }
     } else {
         $por_rete = -1;
     }
     //fin de la retencion
     //Fin de los campos para la nc
     //Detalle del pago
     $edit->banco = new dropdownField('Banco', 'banco');
     $edit->banco->option('', 'Seleccionar');
     $edit->banco->options('SELECT TRIM(codbanc) AS codbanc,CONCAT_WS(\' \',TRIM(codbanc),TRIM(banco),numcuent) FROM banc ORDER BY banco');
     $edit->banco->style = 'width:200px;';
     $edit->banco->rule = 'condi_required|callback_chbanc';
     $edit->tipo_op = new dropdownField('Tipo', 'tipo_op');
     $edit->tipo_op->option('CH', 'Cheque');
     $edit->tipo_op->option('ND', 'Nota de debito');
     $edit->tipo_op->style = 'width:150px;';
     $edit->tipo_op->rule = 'condi_required|enum[CH,ND]|callback_chtipoop';
     $edit->numche = new inputField('N&uacute;mero', 'numche');
     $edit->numche->size = 12;
     $edit->numche->rule = 'condi_required|callback_chbmovrep';
     $edit->benefi = new inputField('Beneficiario', 'benefi');
     $edit->benefi->size = 12;
     $edit->benefi->rule = 'condi_required|callback_chtipo';
     $edit->benefi->style = 'width:90%;';
     $edit->benefi->insertValue = $sprv_nombre;
     $edit->posdata = new dateonlyField('Fecha', 'posdata');
     $edit->posdata->size = 12;
     $edit->posdata->maxlength = 8;
     $edit->posdata->insertValue = date('Y-m-d');
     $edit->posdata->calendar = false;
     $edit->posdata->rule = 'condi_required|chfecha';
     //Fin del detalle del pago
     //************************************************
     //inicio detalle itppro
     //************************************************
     $i = 0;
     $arr_ivas = array();
     $edit->detail_expand_except('itppro');
     $sel = array('a.tipo_doc', 'a.numero', 'a.fecha', 'a.vence', 'a.monto', 'a.abonos', 'a.monto - a.abonos AS saldo', 'impuesto', 'reteiva', 'montasa', 'monredu', 'monadic', 'tasa', 'reducida', 'sobretasa', 'exento');
     $this->db->select($sel);
     $this->db->from('sprm AS a');
     $this->db->where('a.cod_prv', $proveed);
     $transac = $edit->get_from_dataobjetct('transac');
     if ($transac !== false) {
         $tipo_doc = $edit->get_from_dataobjetct('tipo_doc');
         $dbtransac = $this->db->escape($transac);
         $this->db->join('itppro AS b', 'a.tipo_doc = b.tipoccli AND a.numero=b.numccli AND a.transac=' . $dbtransac);
         $this->db->where('a.tipo_doc', $tipo_doc);
     } else {
         $this->db->where('a.monto > a.abonos');
         $this->db->where_in('a.tipo_doc', array('FC', 'ND', 'GI'));
     }
     $this->db->order_by('a.fecha');
     $query = $this->db->get();
     //echo $this->db->last_query();
     foreach ($query->result() as $row) {
         $row->montasa = floatval($row->montasa);
         $row->monredu = floatval($row->monredu);
         $row->monadic = floatval($row->monadic);
         $row->tasa = floatval($row->tasa);
         $row->reducida = floatval($row->reducida);
         $row->sobretasa = floatval($row->sobretasa);
         $row->exento = floatval($row->exento);
         if ($row->montasa + $row->monredu + $row->monadic + $row->tasa + $row->reducida + $row->sobretasa + $row->exento > 0) {
             $arr_ivas[$i] = array('montasa' => $row->montasa, 'monredu' => $row->monredu, 'monadic' => $row->monadic, 'tasa' => $row->tasa, 'reducida' => $row->reducida, 'sobretasa' => $row->sobretasa, 'exento' => $row->exento);
         } else {
             $arr_ivas[$i] = array('montasa' => $row->monto - $row->impuesto, 'monredu' => 0, 'monadic' => 0, 'tasa' => floatval($row->impuesto), 'reducida' => 0, 'sobretasa' => 0, 'exento' => $row->exento);
         }
         $obj = 'cod_prv_' . $i;
         $edit->{$obj} = new autoUpdateField('cod_prv', $proveed, $proveed);
         $edit->{$obj}->rel_id = 'itppro';
         $edit->{$obj}->ind = $i;
         $obj = 'tipo_doc_' . $i;
         $edit->{$obj} = new inputField('Tipo_doc', $obj);
         $edit->{$obj}->db_name = 'tipo_doc';
         $edit->{$obj}->rel_id = 'itppro';
         $edit->{$obj}->rule = 'max_length[2]';
         $edit->{$obj}->insertValue = $row->tipo_doc;
         $edit->{$obj}->size = 4;
         $edit->{$obj}->maxlength = 2;
         $edit->{$obj}->ind = $i;
         $edit->{$obj}->type = 'inputhidden';
         $obj = 'numero_' . $i;
         $edit->{$obj} = new inputField('Numero', $obj);
         $edit->{$obj}->db_name = 'numero';
         $edit->{$obj}->rel_id = 'itppro';
         $edit->{$obj}->rule = 'max_length[8]';
         $edit->{$obj}->insertValue = $row->numero;
         $edit->{$obj}->size = 10;
         $edit->{$obj}->maxlength = 8;
         $edit->{$obj}->ind = $i;
         $edit->{$obj}->type = 'inputhidden';
         $obj = 'fecha_' . $i;
         $edit->{$obj} = new dateonlyField('Fecha', $obj);
         $edit->{$obj}->db_name = 'fecha';
         $edit->{$obj}->rel_id = 'itppro';
         $edit->{$obj}->rule = 'chfecha';
         $edit->{$obj}->insertValue = $row->fecha;
         $edit->{$obj}->size = 10;
         $edit->{$obj}->maxlength = 8;
         $edit->{$obj}->ind = $i;
         $edit->{$obj}->type = 'inputhidden';
         $obj = 'monto_' . $i;
         $edit->{$obj} = new inputField('Monto', $obj);
         $edit->{$obj}->db_name = 'monto';
         $edit->{$obj}->rel_id = 'itppro';
         $edit->{$obj}->rule = 'max_length[18]|numeric';
         $edit->{$obj}->css_class = 'inputnum';
         $edit->{$obj}->size = 20;
         $edit->{$obj}->insertValue = $row->monto;
         $edit->{$obj}->maxlength = 18;
         $edit->{$obj}->ind = $i;
         $edit->{$obj}->showformat = 'decimal';
         $edit->{$obj}->type = 'inputhidden';
         $obj = 'riva_' . $i;
         $edit->{$obj} = new hiddenField('riva', $obj);
         $edit->{$obj}->db_name = 'riva';
         $edit->{$obj}->rel_id = 'itppro';
         $fecha = str_replace('-', '', $row->fecha);
         if (floatval($row->reteiva) > 0) {
             if ($fecha >= $rivafechai && $fecha <= $rivafechac) {
                 $aplrete = 'S';
             } else {
                 $aplrete = 'V';
             }
         } else {
             $aplrete = 'N';
         }
         $edit->{$obj}->insertValue = $aplrete;
         $edit->{$obj}->ind = $i;
         $edit->{$obj}->showformat = 'decimal';
         $obj = 'saldo_' . $i;
         $edit->{$obj} = new freeField($obj, $obj, nformat($row->saldo));
         $edit->{$obj}->ind = $i;
         $obj = 'vence_' . $i;
         $edit->{$obj} = new freeField($obj, $obj, dbdate_to_human($row->vence));
         $edit->{$obj}->ind = $i;
         $obj = 'abono_' . $i;
         $edit->{$obj} = new inputField('Abono', $obj);
         $edit->{$obj}->db_name = 'abono';
         $edit->{$obj}->rel_id = 'itppro';
         $edit->{$obj}->rule = "max_length[18]|numeric|positive|callback_chabono[{$i}]";
         $edit->{$obj}->css_class = 'inputnum';
         $edit->{$obj}->showformat = 'decimal';
         $edit->{$obj}->autocomplete = false;
         $edit->{$obj}->disable_paste = true;
         $edit->{$obj}->size = 15;
         $edit->{$obj}->maxlength = 18;
         $edit->{$obj}->ind = $i;
         $edit->{$obj}->onfocus = 'itsaldo(this,' . round($row->saldo, 2) . ');';
         $i++;
     }
     //************************************************
     //fin de campos para detalle
     //************************************************
     $edit->tipo_doc = new dropdownField('Tipo doc.', 'tipo_doc');
     if ($i > 0) {
         $edit->tipo_doc->option('AB', 'Abono');
         $edit->tipo_doc->option('NC', 'Nota de credito');
     } else {
         $edit->tipo_doc->insertValue = 'AN';
     }
     $edit->tipo_doc->option('AN', 'Anticipo');
     $edit->tipo_doc->onchange = 'chtipodoc()';
     $edit->tipo_doc->style = 'width:140px;';
     $edit->tipo_doc->rule = 'enum[AB,NC,AN]|required';
     $edit->buttons('add_rel');
     $edit->build();
     if ($edit->on_success()) {
         $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk);
         echo json_encode($rt);
     } else {
         $conten['json_ptasa'] = json_encode($arr_ptasa);
         $conten['json_ivas'] = json_encode($arr_ivas);
         $conten['cana'] = $i;
         $conten['form'] =& $edit;
         $conten['title'] = heading("Pago a proveedor: ({$proveed}) {$sprv_nombre} {$sprv_rif}");
         $conten['por_rete'] = $por_rete;
         $this->load->view('view_pprv', $conten);
     }
 }
Example #6
0
 function duplicar($numero)
 {
     $this->rapyd->load('dataobject', 'datadetails');
     $do = new DataObject("ocompra");
     $do->order_by('itocompra', 'itocompra.id', 'desc');
     $do->rel_one_to_many('itocompra', 'itocompra', array('numero' => 'numero'));
     $do->load($numero);
     $donew = new DataObject("ocompra");
     $donew->rel_one_to_many('itocompra', 'itocompra', array('numero' => 'numero'));
     $campos = $do->get_all();
     unset($campos['itocompra']);
     foreach ($campos as $k => $v) {
         $donew->set($k, $v);
     }
     $ntransac = $this->datasis->fprox_numero('ntransac');
     $donew->set('numero', '_' . $ntransac);
     $donew->set('status', 'M');
     //$donew->pk    =array('numero'=>'_'.$ntransac);
     for ($i = 0; $i < $do->count_rel('itocompra'); $i++) {
         $donew->set_rel('itocompra', 'numero', '_' . $ntransac, $i);
         $donew->set_rel('itocompra', 'id', '', $i);
         $donew->set_rel('itocompra', 'descripcion', $do->get_rel('itocompra', 'descripcion', $i), $i);
         $donew->set_rel('itocompra', 'unidad', $do->get_rel('itocompra', 'unidad', $i), $i);
         $donew->set_rel('itocompra', 'cantidad', $do->get_rel('itocompra', 'cantidad', $i), $i);
         $donew->set_rel('itocompra', 'precio', $do->get_rel('itocompra', 'precio', $i), $i);
         $donew->set_rel('itocompra', 'importe', $do->get_rel('itocompra', 'importe', $i), $i);
         $donew->set_rel('itocompra', 'iva', $do->get_rel('itocompra', 'iva', $i), $i);
         $donew->set_rel('itocompra', 'usaislr', $do->get_rel('itocompra', 'usaislr', $i), $i);
         $donew->set_rel('itocompra', 'islr', $do->get_rel('itocompra', 'islr', $i), $i);
         $donew->set_rel('itocompra', 'partida', $do->get_rel('itocompra', 'partida', $i), $i);
         $donew->set_rel('itocompra', 'preten', $do->get_rel('itocompra', 'preten', $i), $i);
         $donew->set_rel('itocompra', 'codigoadm', $do->get_rel('itocompra', 'codigoadm', $i), $i);
         $donew->set_rel('itocompra', 'fondo', $do->get_rel('itocompra', 'fondo', $i), $i);
         $donew->set_rel('itocompra', 'esiva', $do->get_rel('itocompra', 'esiva', $i), $i);
     }
     $donew->save();
     redirect($this->url . 'dataedit/modify/_' . $ntransac);
 }
Example #7
0
 function dataedit($status = '', $numero = '')
 {
     //$this->datasis->modulo_id(119,1);
     $this->rapyd->load('dataobject', 'datadetails');
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'rif' => 'RIF', 'nombre' => 'Nombre', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;digo', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov', 'nombre' => 'nombrep', 'reteiva' => 'reteiva_prov'), 'titulo' => 'Buscar Beneficiario');
     $bSPRV = $this->datasis->modbus($mSPRV);
     $modbus = array('tabla' => 'v_presaldo', 'columnas' => array('codigoadm' => 'Est. Admin', 'codigo' => 'Partida', 'ordinal' => 'Ordinal', 'denominacion' => 'Denominaci&oacute;n', 'saldo' => 'Saldo'), 'filtro' => array('codigoadm' => 'Est. Admin', 'codigo' => 'Partida', 'ordinal' => 'Ord', 'denominacion' => 'Denominaci&oacute;n'), 'retornar' => array('codigoadm' => 'itcodigoadm_<#i#>', 'codigo' => 'partida_<#i#>'), 'where' => 'movimiento = "S" AND saldo>0 AND fondo=<#fondo#> AND codigo LIKE "4.%"', 'p_uri' => array(4 => '<#i#>', 5 => '<#fondo#>'), 'titulo' => 'Busqueda de partidas');
     //$btn=$this->datasis->p_modbus($modbus,'<#i#>');
     $btn = $this->datasis->p_modbus($modbus, '<#i#>/<#fondo#>');
     $btn = '<img src="/tortuga/assets/default/images/system-search.png"  alt="Busqueda de partidas" title="Busqueda de partidas" border="0" onclick="modbusdepen(<#i#>)"/>';
     $do = new DataObject("ocompra");
     $do->pointer('sprv', 'sprv.proveed=ocompra.cod_prov', 'sprv.nombre as nombrep, sprv.rif as rif', 'LEFT');
     $do->rel_one_to_many('itfac', 'itfac', array('numero' => 'nocompra'));
     $do->rel_one_to_many('itocompra', 'itocompra', array('numero' => 'numero'));
     $do->order_by('itocompra', 'itocompra.id', ' ');
     //$do->load('_00000169');
     //echo $do->db->last_query();
     $edit = new DataDetails($this->t**s, $do);
     $edit->back_url = site_url($this->url . "filteredgrid");
     $edit->set_rel_title('itodirect', 'Rubro <#o#>');
     $status = $edit->get_from_dataobjetct('status');
     $edit->pre_process('update', '_valida');
     $edit->pre_process('insert', '_valida');
     $edit->post_process('update', '_post_update');
     $status = $edit->get_from_dataobjetct('status');
     $ivaplica = $this->ivaplica2();
     $tipo = $edit->get_from_dataobjetct('tipo');
     $edit->numero = new inputField("N&uacute;mero", "numero");
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show');
     $edit->tipo = new dropdownField("Orden de ", "tipo");
     $edit->tipo->option("Compromiso", "Compromiso");
     $edit->tipo->style = "width:200px;";
     $edit->tipo->mode = 'autohide';
     //$edit->tipo->when=array('modify');
     $edit->fecha = new dateonlyField("Fecha", "fecha");
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->size = 12;
     $edit->fecha->mode = 'autohide';
     //$edit->fecha->when=array('modify');
     $edit->creten = new dropdownField("Cod ISLR: ", "creten");
     //$edit->creten->mode   = "autohide";
     //$edit->creten->option("","");
     $edit->creten->options("SELECT codigo,CONCAT_WS(' ',codigo,activida) FROM rete ORDER BY codigo");
     $edit->creten->style = "width:300px;";
     $edit->creten->onchange = 'cal_reten();';
     $edit->uejecutora = new dropdownField("Unidad Ejecutora", "uejecutora");
     $edit->uejecutora->option("", "Seccionar");
     $edit->uejecutora->options("SELECT codigo, nombre FROM uejecutora ORDER BY nombre");
     //$edit->uejecutora->onchange = "get_uadmin();";
     $edit->uejecutora->rule = "required";
     $edit->uejecutora->style = "width:300px";
     $edit->uejecutora->mode = 'autohide';
     //$edit->uejecutora->when=array('modify');
     $lsnc = '<a href="javascript:consulsprv();" title="Proveedor" onclick="">Consulta/Agrega BENEFICIARIO</a>';
     $edit->cod_prov = new inputField("Beneficiario", 'cod_prov');
     $edit->cod_prov->db_name = "cod_prov";
     $edit->cod_prov->size = 5;
     $edit->cod_prov->rule = "required";
     $edit->cod_prov->readonly = true;
     $edit->cod_prov->append($bSPRV);
     $edit->cod_prov->append($lsnc);
     //$edit->cod_prov->mode     = 'autohide';
     //$edit->codprov_sprv->when=array('modify');
     $edit->nombrep = new inputField("Nombre", 'nombrep');
     $edit->nombrep->size = 30;
     $edit->nombrep->readonly = true;
     $edit->nombrep->pointer = TRUE;
     //$edit->nombrep->mode     = 'autohide';
     //$edit->nomfis->when=array('modify');
     $edit->rif = new inputField("RIF", "rif");
     $edit->rif->size = 10;
     $edit->rif->pointer = true;
     if ($status == 'P') {
         $edit->rif->readonly = true;
     }
     $edit->reteiva_prov = new dropdownField("Retenci&oacute;n de IVA %", "reteiva_prov");
     $edit->reteiva_prov->option("75", "75%");
     $edit->reteiva_prov->option("100", "100%");
     $edit->reteiva_prov->style = "width:70px;";
     $edit->reteiva_prov->onchange = 'cal_reten();';
     $edit->fondo = new dropdownField("F. Financiamiento", "fondo");
     $edit->fondo->rule = 'required';
     $edit->fondo->db_name = 'fondo';
     $edit->fondo->options("SELECT tipo,tipo a  FROM presupuesto WHERE tipo<>'' GROUP BY tipo ORDER BY tipo desc");
     $edit->fondo->style = "width:300px;";
     $edit->observa = new textAreaField("Observaciones", 'observa');
     $edit->observa->cols = 120;
     $edit->observa->rows = 3;
     //$edit->observa->mode   = 'autohide';
     //$edit->observa->when=array('modify');
     $edit->concepto = new textAreaField("Concepto", 'concepto');
     $edit->concepto->cols = 120;
     $edit->concepto->rows = 3;
     $edit->reteiva = new inputField("Retencion IVA", 'reteiva');
     $edit->reteiva->css_class = 'inputnum';
     $edit->reteiva->size = 10;
     $edit->reteiva->mode = 'autohide';
     $edit->reten = new inputField("Retencion IVA", 'reten');
     $edit->reten->css_class = 'inputnum';
     $edit->reten->size = 8;
     $edit->reten->mode = 'autohide';
     $edit->imptimbre = new inputField("", 'imptimbre');
     $edit->imptimbre->css_class = 'inputnum';
     $edit->imptimbre->size = 8;
     $edit->imptimbre->mode = 'autohide';
     $edit->total2 = new inputField("Total", 'total2');
     $edit->total2->css_class = 'inputnum';
     $edit->total2->size = 12;
     $edit->total2->mode = 'autohide';
     $edit->total22 = new inputField("Total", 'total22');
     $edit->total22->db_name = ' ';
     $edit->total22->css_class = 'inputnum';
     $edit->total22->size = 15;
     //$edit->total22->mode     = 'autohide';
     $edit->total22->when = array("create", "modify");
     $edit->total = new inputField("Total", 'total');
     $edit->total->css_class = 'inputnum';
     $edit->total->size = 8;
     $edit->total->mode = 'autohide';
     $edit->tivag = new inputField("", "tivag");
     $edit->tivag->size = 1;
     $edit->tivag->mode = "autohide";
     $edit->tivag->insertValue = $ivaplica['tasa'];
     $edit->tivag->readonly = true;
     //$edit->tivag->when=array('modify');
     //$edit->tivag->status='show';
     $edit->tivar = new inputField("", "tivar");
     $edit->tivar->size = 1;
     $edit->tivar->mode = "autohide";
     $edit->tivar->insertValue = $ivaplica['redutasa'];
     $edit->tivar->readonly = true;
     //$edit->tivar->when=array('modify');
     $edit->tivaa = new inputField("", "tivaa");
     $edit->tivaa->size = 1;
     $edit->tivaa->mode = "autohide";
     $edit->tivaa->insertValue = $ivaplica['sobretasa'];
     $edit->tivaa->readonly = true;
     //$edit->tivaa->when=array('modify');
     $edit->ivag = new inputField("", "ivag");
     $edit->ivag->size = 9;
     $edit->ivag->mode = "autohide";
     //$edit->ivag->when=array('modify');
     $edit->ivar = new inputField("", "ivar");
     $edit->ivar->size = 8;
     $edit->ivar->mode = "autohide";
     //$edit->ivar->when=array('modify');
     $edit->ivaa = new inputField("", "ivaa");
     $edit->ivaa->size = 8;
     $edit->ivaa->mode = "autohide";
     //$edit->ivaa->when=array('modify');
     $edit->subtotal = new inputField("", "subtotal");
     $edit->subtotal->size = 10;
     $edit->subtotal->mode = "autohide";
     //$edit->subtotal->when=array('modify');
     $edit->exento = new inputField("", "exento");
     $edit->exento->size = 8;
     $edit->exento->mode = "autohide";
     //$edit->exento->when=array('modify');
     $edit->simptimbre = new checkboxField("1X1000", "simptimbre", "S", "N");
     $edit->simptimbre->insertValue = "N";
     $edit->simptimbre->onchange = 'cal_simpt();';
     //if($status=='P')
     //$edit->simptimbre->mode="autohide";
     ///////VISUALES  INICIO ////////////////
     $edit->tsubtotal = new inputField("", "tsubtotal");
     //		$edit->tsubtotal->readonly = true;
     $edit->tsubtotal->size = 12;
     $edit->tsubtotal->when = array('modify');
     $edit->texento = new inputField("", "texento");
     //$edit->texento->readonly = true;
     $edit->texento->size = 8;
     $edit->texento->when = array('modify');
     $edit->trivag = new inputField("", "trivag");
     //$edit->trivag->readonly = true;
     $edit->trivag->size = 10;
     $edit->trivag->when = array('modify');
     $edit->trivag->onchange = 'cal_totales();';
     $edit->trivar = new inputField("", "trivar");
     //$edit->trivar->readonly = true;
     $edit->trivar->size = 8;
     $edit->trivar->when = array('modify');
     $edit->trivar->onchange = 'cal_totales();';
     $edit->trivaa = new inputField("", "trivaa");
     //$edit->trivaa->readonly = true;
     $edit->trivaa->size = 8;
     $edit->trivaa->when = array('modify');
     $edit->trivaa->onchange = 'cal_totales();';
     $edit->treteiva = new inputField("", "treteiva");
     //$edit->treteiva->readonly = true;
     $edit->treteiva->size = 8;
     $edit->treteiva->when = array('modify');
     $edit->treteiva->onchange = 'cal_totales();';
     $edit->treten = new inputField("", "treten");
     //$edit->treten->readonly = true;
     $edit->treten->size = 8;
     $edit->treten->when = array('modify');
     $edit->treten->onchange = 'cal_totales();';
     $edit->timptimbre = new inputField("", "timptimbre");
     //$edit->timptimbre->readonly = true;
     $edit->timptimbre->size = 8;
     $edit->timptimbre->when = array('modify');
     $edit->timptimbre->onchange = 'cal_totales();';
     $edit->ttotal = new inputField("", "ttotal");
     $edit->ttotal->readonly = true;
     $edit->ttotal->size = 12;
     $edit->ttotal->when = array('modify');
     $edit->ttotal2 = new inputField("", "ttotal2");
     $edit->ttotal2->readonly = true;
     $edit->ttotal2->size = 12;
     $edit->ttotal2->when = array('modify');
     ///////FIN VISUALES ////////////////////
     $edit->itfactura = new inputField("(<#o#>) Factura", "factura_<#i#>");
     $edit->itfactura->size = 10;
     $edit->itfactura->db_name = 'factura';
     $edit->itfactura->rel_id = 'itfac';
     $edit->itfactura->rule = 'required';
     $edit->itcontrolfac = new inputField("(<#o#>) Control Fiscal", "controlfac_<#i#>");
     $edit->itcontrolfac->db_name = 'controlfac';
     //$edit->itcontrolfac->maxlength=3;
     $edit->itcontrolfac->size = 10;
     $edit->itcontrolfac->rel_id = 'itfac';
     $edit->itcontrolfac->rule = 'required';
     $edit->itfechafac = new dateonlyField("(<#o#>) Fecha Factura", "fechafac_<#i#>");
     $edit->itfechafac->db_name = 'fechafac';
     $edit->itfechafac->insertValue = date('Y-m-d');
     //$edit->itfechafac->maxlength=80;
     $edit->itfechafac->size = 8;
     $edit->itfechafac->rule = 'required';
     $edit->itfechafac->rel_id = 'itfac';
     $edit->itsubtotal = new inputField("(<#o#>) Total", "subtotal_<#i#>");
     $edit->itsubtotal->size = 8;
     $edit->itsubtotal->db_name = 'subtotal';
     $edit->itsubtotal->rel_id = 'itfac';
     $edit->itsubtotal->onchange = 'cal_subtotal(<#i#>,true);';
     $edit->itsubtotal->css_class = "inputnum";
     $edit->itsubtotal->value = 0;
     if ($status == "E") {
         $edit->itsubtotal->mode = "autohide";
     }
     $edit->itexento = new inputField("(<#o#>) Exento", "exento_<#i#>");
     $edit->itexento->size = 8;
     $edit->itexento->db_name = 'exento';
     $edit->itexento->rel_id = 'itfac';
     $edit->itexento->css_class = "inputnum";
     $edit->itexento->value = 0;
     $edit->itexento->onchange = 'cal_subtotal(<#i#>,true);';
     //$edit->itexento->rule ='required';
     if ($status == "E") {
         $edit->itexento->mode = "autohide";
     }
     $edit->ituivag = new dropdownField("(<#o#>)", "uivag_<#i#>");
     $edit->ituivag->rel_id = 'itfac';
     $edit->ituivag->db_name = 'uivag';
     $edit->ituivag->onchange = 'cal_subtotal(<#i#>,true);';
     $edit->ituivag->option("S", "Si");
     $edit->ituivag->option("N", "No");
     $edit->ituivag->style = "width:35px;";
     $edit->itivag = new inputField("(<#o#>) % IVA General", "ivag_<#i#>");
     $edit->itivag->size = 10;
     $edit->itivag->db_name = 'ivag';
     $edit->itivag->rel_id = 'itfac';
     //$edit->itivag->insertValue = 0;
     $edit->itivag->onchange = 'cal_subtotal2(<#i#>,true);';
     $edit->itivag->css_class = "inputnum";
     $edit->itivag->value = 0;
     if ($status == "E") {
         $edit->itivag->mode = "autohide";
     }
     $edit->ituivar = new dropdownField("", "uivar_<#i#>");
     $edit->ituivar->rel_id = 'itfac';
     $edit->ituivar->db_name = 'uivar';
     $edit->ituivar->onchange = 'cal_subtotal(<#i#>,true);';
     $edit->ituivar->option("N", "No");
     $edit->ituivar->option("S", "Si");
     $edit->ituivar->style = "width:35px;";
     $edit->itivar = new inputField("(<#o#>) % IVA Reducido", "ivar_<#i#>");
     $edit->itivar->size = 5;
     $edit->itivar->db_name = 'ivar';
     $edit->itivar->rel_id = 'itfac';
     //$edit->itivar->insertValue = 0;
     $edit->itivar->onchange = 'cal_subtotal2(<#i#>,true);';
     $edit->itivar->css_class = "inputnum";
     $edit->itivar->value = 0;
     if ($status == "E") {
         $edit->itivar->mode = "autohide";
     }
     $edit->ituivaa = new dropdownField("", "uivaa_<#i#>");
     $edit->ituivaa->rel_id = 'itfac';
     $edit->ituivaa->db_name = 'uivaa';
     $edit->ituivaa->onchange = 'cal_subtotal(<#i#>,true);';
     $edit->ituivaa->option("N", "No");
     $edit->ituivaa->option("S", "Si");
     $edit->ituivaa->style = "width:35px;";
     $edit->itivaa = new inputField("(<#o#>) % IVA Adicional", "ivaa_<#i#>");
     $edit->itivaa->size = 5;
     $edit->itivaa->db_name = 'ivaa';
     $edit->itivaa->rel_id = 'itfac';
     $edit->itivaa->onchange = 'cal_subtotal2(<#i#>,true);';
     $edit->itivaa->css_class = "inputnum";
     $edit->itivaa->value = 0;
     if ($status == "E") {
         $edit->itivaa->mode = "autohide";
     }
     $edit->itreteiva = new inputField("(<#o#>) % IVA Adicional", "reteiva_<#i#>");
     $edit->itreteiva->size = 8;
     $edit->itreteiva->db_name = 'reteiva';
     $edit->itreteiva->rel_id = 'itfac';
     //$edit->itreteiva->readonly = true;
     $edit->itreteiva->onchange = 'cal_subtotal2(<#i#>,true);';
     $edit->itreteiva->value = 0;
     if ($status == "E") {
         $edit->itreteiva->mode = "autohide";
     }
     $edit->itureten = new dropdownField("", "ureten_<#i#>");
     $edit->itureten->rel_id = 'itfac';
     $edit->itureten->db_name = 'ureten';
     $edit->itureten->onchange = 'cal_subtotal(<#i#>,true);';
     $edit->itureten->option("S", "Si");
     $edit->itureten->option("N", "No");
     $edit->itureten->style = "width:35px;";
     $edit->itreten = new inputField("(<#o#>) ISLR", "rete_<#i#>");
     $edit->itreten->size = 4;
     $edit->itreten->db_name = 'reten';
     $edit->itreten->rel_id = 'itfac';
     $edit->itreten->readonly = true;
     $edit->itreten->value = 0;
     if ($status == "E") {
         $edit->itreten->mode = "autohide";
     }
     $edit->ituimptimbre = new dropdownField("", "uimptimbre_<#i#>");
     $edit->ituimptimbre->rel_id = 'itfac';
     $edit->ituimptimbre->db_name = 'uimptimbre';
     $edit->ituimptimbre->onchange = 'cal_subtotal(<#i#>,true);';
     $edit->ituimptimbre->option("S", "Si");
     $edit->ituimptimbre->option("N", "No");
     $edit->ituimptimbre->style = "width:35px;";
     $edit->itimptimbre = new inputField("(<#o#>) ISLR", "imptimbre_<#i#>");
     $edit->itimptimbre->size = 4;
     $edit->itimptimbre->db_name = 'imptimbre';
     $edit->itimptimbre->rel_id = 'itfac';
     $edit->itimptimbre->readonly = true;
     $edit->itimptimbre->value = 0;
     if ($status == "E") {
         $edit->itreten->mode = "autohide";
     }
     $edit->ittotal = new inputField("(<#o#>) % IVA Adicional", "total_<#i#>");
     $edit->ittotal->size = 12;
     $edit->ittotal->db_name = 'total';
     $edit->ittotal->rel_id = 'itfac';
     $edit->ittotal->readonly = true;
     $edit->ittotal->value = 0;
     if ($status == "E") {
         $edit->ittotal->mode = "autohide";
     }
     $edit->ittotal2 = new inputField("(<#o#>) % IVA Adicional", "total2_<#i#>");
     $edit->ittotal2->size = 12;
     $edit->ittotal2->db_name = 'total2';
     $edit->ittotal2->rel_id = 'itfac';
     $edit->ittotal2->readonly = true;
     $edit->ittotal2->value = 0;
     //if($status=="E")$edit->ittotal2->mode = "autohide";
     ////////////////////////// INICIO DETALLE DE PARTIDAS //////////////////////////////////////////
     $edit->itesiva = new dropdownField("P.IVA", "itesiva_<#i#>");
     $edit->itesiva->rule = 'required';
     $edit->itesiva->db_name = 'esiva';
     $edit->itesiva->rel_id = 'itocompra';
     $edit->itesiva->option("N", "No");
     $edit->itesiva->option("S", "Si");
     $edit->itesiva->option("A", "Auto");
     $edit->itesiva->style = "width:45px;";
     //$edit->itesiva->mode ="autohide";
     $edit->itcodigoadm = new inputField("Estructura\tAdministrativa", "itcodigoadm_<#i#>");
     $edit->itcodigoadm->size = 10;
     $edit->itcodigoadm->db_name = 'codigoadm';
     $edit->itcodigoadm->rel_id = 'itocompra';
     $edit->itcodigoadm->rule = 'required';
     $edit->itcodigoadm->autocomplete = false;
     //$edit->itcodigoadm->mode ="autohide";
     $edit->itpartida = new inputField("(<#o#>) Partida", "partida_<#i#>");
     $edit->itpartida->rule = 'required';
     $edit->itpartida->size = 15;
     $edit->itpartida->db_name = 'partida';
     $edit->itpartida->rel_id = 'itocompra';
     $edit->itpartida->autocomplete = false;
     //$edit->itpartida->insertValue ="4";
     //$edit->itpartida->mode ="autohide";
     $edit->itimporte = new inputField("(<#o#>) Importe", "importe_<#i#>");
     $edit->itimporte->css_class = 'inputnum';
     $edit->itimporte->db_name = 'importe';
     $edit->itimporte->rel_id = 'itocompra';
     $edit->itimporte->rule = 'numeric';
     $edit->itimporte->onchange = 'cal_totalp();';
     $edit->itimporte->value = 0;
     $edit->itimporte->size = 15;
     if ($status == 'P') {
         $edit->itimporte->readonly = true;
     }
     //$edit->itimporte->mode ="autohide";
     //echo "--------".$status;
     if ($status == 'P' || $status == 'C' || $status == 'T' || $status == 'O' || $status == 'E') {
         $edit->itesiva = new inputField("P.IVA", "itesiva_<#i#>");
         $edit->itesiva->size = 2;
         $edit->itesiva->db_name = 'esiva';
         $edit->itesiva->rel_id = 'itocompra';
         //$edit->itesiva->mode ="autohide";
         $edit->itimporte->readonly = true;
         $edit->itpartida->readonly = true;
         $edit->itcodigoadm->readonly = true;
         $edit->itesiva->readonly = true;
     } else {
         $edit->itpartida->append($btn);
     }
     $edit->itdescripcion = new hiddenField("(<#o#>) Descripci&oacute;n", "descripcion_<#i#>");
     $edit->itdescripcion->db_name = 'descripcion';
     $edit->itdescripcion->readonly = true;
     $edit->itdescripcion->rel_id = 'itocompra';
     //$edit->itdescripcion->type     ='inputhidden';
     $edit->itunidad = new hiddenField("(<#o#>) Unidad", "unidad_<#i#>");
     $edit->itunidad->db_name = 'unidad';
     $edit->itunidad->rel_id = 'itocompra';
     $edit->itunidad->readonly = true;
     $edit->itunidad->in = 'itdescripcion';
     //$edit->itunidad->type     ='inputhidden';
     $edit->itcantidad = new hiddenField("(<#o#>) Cantidad", "cantidad_<#i#>");
     $edit->itcantidad->db_name = 'cantidad';
     $edit->itcantidad->rel_id = 'itocompra';
     $edit->itcantidad->readonly = true;
     $edit->itcantidad->in = 'itdescripcion';
     //$edit->itcantidad->type     ='inputhidden';
     $edit->itprecio = new hiddenField("(<#o#>) Precio", "precio_<#i#>");
     $edit->itprecio->db_name = 'precio';
     $edit->itprecio->readonly = true;
     $edit->itprecio->rel_id = 'itocompra';
     $edit->itprecio->in = 'itdescripcion';
     //$edit->itprecio->type     ='inputhidden';
     $edit->itusaislr = new hiddenField("(<#o#>) Islr", "usaislr_<#i#>");
     $edit->itusaislr->db_name = 'usaislr';
     $edit->itusaislr->rel_id = 'itocompra';
     $edit->itusaislr->readonly = true;
     $edit->itusaislr->in = 'itdescripcion';
     //$edit->itusaislr->type     ='inputhidden';
     $edit->itislr = new hiddenField("(<#o#>) Islr", "islr_<#i#>");
     $edit->itislr->db_name = 'islr';
     $edit->itislr->rel_id = 'itocompra';
     $edit->itislr->readonly = true;
     $edit->itislr->in = 'itdescripcion';
     //$edit->itislr->type     ='inputhidden';
     $edit->itiva = new hiddenField("(<#o#>) IVA", "iva_<#i#>");
     $edit->itiva->db_name = 'iva';
     $edit->itiva->rel_id = 'itocompra';
     $edit->itiva->readonly = true;
     $edit->itiva->in = 'descripcion';
     //$edit->itiva->type     ='inputhidden';
     ////////////////////////// FIN    DETALLE DE PARTIDAS //////////////////////////////////////////
     if ($status == 'P') {
         $action = "javascript:btn_noterminada('" . $edit->rapyd->uri->get_edited_id() . "/itfac3" . "')";
         if ($this->datasis->puede(213)) {
             $edit->button_status("btn_notermina", 'Marcar Orden Como NO Terminada', $action, "TR", "show");
         }
     } elseif ($status == 'C') {
         $edit->buttons("save");
         $edit->buttons("modify");
     } elseif ($status == 'M') {
         $action = "javascript:btn_terminada('" . $edit->rapyd->uri->get_edited_id() . "/itfac3" . "')";
         if ($this->datasis->puede(213)) {
             $edit->button_status("btn_termina", 'Marcar Orden Como Terminada', $action, "TR", "show");
         }
         if ($this->datasis->puede(158)) {
             $edit->buttons("modify");
         }
         if ($this->datasis->puede(159)) {
             $edit->buttons("save");
         }
     } elseif ($status == 'p') {
         if ($this->datasis->puede(158)) {
             $edit->buttons("modify");
         }
         if ($this->datasis->puede(159)) {
             $edit->buttons("save");
         }
     } else {
         if ($this->datasis->puede(159)) {
             $edit->buttons("save");
         }
     }
     $edit->buttons("save");
     $edit->buttons("modify");
     $action = "javascript:window.location='" . site_url('presupuesto/itfac3/load/' . $edit->rapyd->uri->get_edited_id()) . "'";
     $edit->button_status("btn_cargar", 'Cargar desde .xls', $action, "TL", "show");
     $edit->button_status("btn_cargar", 'Cargar desde .xls', $action, "TL", "modify");
     $edit->button_status("btn_add_itfac", 'Agregar Factura', "javascript:add_itfac()", "MB", 'modify', "button_add_rel");
     $edit->button_status("btn_add_itfac", 'Agregar Factura', "javascript:add_itfac()", "MB", 'create', "button_add_rel");
     $edit->button_status("btn_add_itocompra", 'Agregar Partida', "javascript:add_itocompra()", "PA", "create", "button_add_rel");
     $edit->button_status("btn_add_itocompra", 'Agregar Partida', "javascript:add_itocompra()", "PA", "modify", "button_add_rel");
     $edit->buttons("undo", "back", "add");
     $edit->build();
     $query = $this->db->query('SELECT * FROM rete ORDER BY codigo');
     $rt = array();
     foreach ($query->result_array() as $row) {
         $pivot = array('tari1' => $row['tari1'], 'pama1' => $row['pama1'], 'tari2' => $row['tari2'], 'pama2' => $row['pama2'], 'tari3' => $row['tari3'], 'pama3' => $row['pama3'], 'porcentsustra' => $row['porcentsustra']);
         $rt['_' . $row['codigo']] = $pivot;
     }
     $rete = json_encode($rt);
     $conten['ivar'] = $ivaplica['redutasa'];
     $conten['ivag'] = $ivaplica['tasa'];
     $conten['ivaa'] = $ivaplica['sobretasa'];
     $conten['status'] = $status;
     $conten['imptimbre'] = $this->datasis->traevalor('IMPTIMBRE', 0);
     $conten['rete'] = $rete;
     $conten['utribuactual'] = $this->datasis->dameval('SELECT valor FROM utribu WHERE ano=(SELECT MAX(ano) FROM utribu)');
     $smenu['link'] = barra_menu('122');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_itfac3', $conten, true);
     //$data['content'] = $edit->output;
     $data['title'] = "{$this->t**s}";
     $data["head"] = script('jquery.js') . script('jquery-ui.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js') . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Example #8
0
 function dataedit($orden = 0, $estado = null, $numero = null)
 {
     $this->load->helper('form');
     //$this->datasis->modulo_id(101,1);
     //$formato=$this->datasis->dameval('SELECT format FROM cemp LIMIT 0,1');
     $formato = $this->datasis->traevalor('FORMATOPATRI');
     $len_for = strlen($formato);
     $qformato = '%';
     for ($i = 1; $i < substr_count($formato, '.') + 1; $i++) {
         $qformato .= '.%';
     }
     $this->qformato = $qformato;
     $modbus = array('tabla' => 'cpla', 'columnas' => array('codigo' => 'C&oacute;digo', 'denominacion' => 'Descripci&oacute;n'), 'filtro' => array('codigo' => 'C&oacute;digo', 'denominacion' => 'Descripci&oacute;n'), 'retornar' => array('codigo' => 'cuenta_<#i#>'), 'titulo' => 'Buscar Cuenta', 'where' => "codigo LIKE \"{$qformato}\" AND LENGTH(codigo) = {$len_for} ", 'p_uri' => array(4 => '<#i#>'));
     $button = $this->datasis->p_modbus($modbus, '<#i#>');
     $this->rapyd->load('dataobject', 'datadetails');
     $do = new DataObject("casi");
     $do->rel_one_to_many('itcasi', 'itcasi', array('comprob' => 'comprob'));
     $do->rel_pointer('itcasi', 'cpla', 'itcasi.cuenta=cpla.codigo', "cpla.denominacion", "LEFT");
     switch ($orden) {
         case 0:
             $do->order_by('itcasi', 'itcasi.id', ' ');
             break;
         case 1:
             $do->order_by('itcasi', 'itcasi.cuenta', ' ');
             break;
         case 2:
             $do->order_by('itcasi', "MID( `itcasi`.`concepto` ,1, 10 )", ' ');
             $do->order_by('itcasi', 'itcasi.haber > 0', ' ');
             $do->order_by('itcasi', 'itcasi.cuenta', ' ');
             break;
         case 3:
             $do->order_by('itcasi', 'itcasi.debe+itcasi.haber', ' ');
             $do->order_by('itcasi', 'itcasi.haber > 0', ' ');
             $do->order_by('itcasi', 'itcasi.cuenta', ' ');
             break;
         case 4:
             $do->order_by('itcasi', 'itcasi.cuenta', 'desc');
         case 5:
             $do->order_by('itcasi', 'itcasi.fecha', 'asc');
             break;
     }
     $do->db->_escape_char = '';
     $do->db->_protect_identifiers = false;
     if ($numero && ($estado == 'show' || $estado == 'modify')) {
         $do->load("{$numero}");
     }
     $edit = new DataDetails($this->t**s, $do);
     $edit->back_url = site_url($this->url . "filteredgrid");
     $edit->set_rel_title('itcasi', 'Rubro <#o#>');
     $edit->pre_process('insert', '_valida');
     $edit->pre_process('update', '_valida');
     $edit->post_process('insert', '_post_insert');
     $edit->post_process('update', '_post_update');
     $edit->post_process('delete', '_post_delete');
     //$edit->numero  = new inputField("Identificador", "numero");
     //$edit->numero->mode="autohide";
     //$edit->numero->when=array('show');
     $options = array('0' => 'Ordenar', '1' => "Cuenta Contable Ascendente", '4' => "Cuenta Contable Descendente", '2' => "Primeros 10 digitos del concepto, debe,haber,cuenta ", '3' => "Ordenado por monto", '5' => "Fecha");
     $js = 'id="orden" onChange="ordenar();"';
     $orden = form_dropdown('orden', $options, 0, $js);
     /*
     $edit->orden = new dropdownField("Ordenar por","orden");
     $edit->orden->option("0","Cuenta Contable Ascendente");
     $edit->orden->option("1","Primeros 10 digitos del concepto, debe,haber ");
     $edit->orden->status='create';
     $edit->orden->when=array('show','modify','create');
     */
     $edit->comprob = new inputField("Comprobante", "comprob");
     //$edit->comprob->mode ="autohide";
     $edit->comprob->rule = "trim|required|unique";
     //$edit->comprob->when=array('show','modify');
     $edit->fecha = new dateonlyField("Fecha", "fecha");
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->size = 12;
     $edit->fecha->rule = 'required';
     $edit->descrip = new textAreaField("Descripci&oacute;n", 'descrip');
     $edit->descrip->cols = 100;
     $edit->descrip->rows = 3;
     $edit->debe = new inputField2("Debe", "debe");
     $edit->debe->size = 12;
     $edit->debe->css_class = 'inputnum';
     $edit->debe->readonly = TRUE;
     $edit->haber = new inputField2("Haber", "haber");
     $edit->haber->size = 12;
     $edit->haber->css_class = 'inputnum';
     $edit->haber->readonly = TRUE;
     $edit->total = new inputField("Saldo", "total");
     $edit->total->size = 12;
     $edit->total->css_class = 'inputnum';
     $edit->total->readonly = TRUE;
     $edit->status = new dropdownField("Status", "status");
     $edit->status->style = "width:110px";
     $edit->status->option("C1", "Cuadrado");
     $edit->status->option("C2", "Pendiente");
     $edit->itcuenta = new inputField("(<#o#>) Cuenta", "cuenta_<#i#>");
     $edit->itcuenta->rule = 'trim|required|callback_chcodigo';
     //|callback_itorden |callback_repetido|
     $edit->itcuenta->size = 20;
     $edit->itcuenta->db_name = 'cuenta';
     $edit->itcuenta->rel_id = 'itcasi';
     $edit->itcuenta->autocomplete = false;
     $edit->itcuenta->append($button);
     //$edit->itdenomi = new inputField("(<#o#>) Denominaci&oacute;n", "denominacion_<#i#>");
     //$edit->itdenomi->db_name ='denominacion';
     //$edit->itdenomi->rel_id  ='itcasi';
     ////$edit->itdenomi->size    =20;
     //$edit->itdenomi->readonly=true;
     //$edit->itdenomi->pointer =true;
     $edit->itconcepto = new textareaField("Concepto", "concepto_<#i#>");
     $edit->itconcepto->db_name = 'concepto';
     $edit->itconcepto->rows = 2;
     $edit->itconcepto->cols = 30;
     $edit->itconcepto->rel_id = 'itcasi';
     $edit->itfecha = new dateOnlyField("(<#o#>) Fecha", "fecha_<#i#>");
     $edit->itfecha->db_name = 'fecha';
     $edit->itfecha->rel_id = 'itcasi';
     $edit->itfecha->size = 10;
     $edit->itreferencia = new inputField("Referencia", "referen_<#i#>");
     $edit->itreferencia->size = 10;
     $edit->itreferencia->db_name = 'referen';
     $edit->itreferencia->maxlength = 12;
     $edit->itreferencia->rel_id = 'itcasi';
     $edit->itdebe = new inputField("(<#o#>) Debe", "debe_<#i#>");
     $edit->itdebe->css_class = 'inputnum';
     $edit->itdebe->db_name = 'debe';
     $edit->itdebe->rel_id = 'itcasi';
     $edit->itdebe->rule = 'numeric';
     $edit->itdebe->onchange = 'cal_totald(<#i#>);';
     $edit->itdebe->size = 15;
     $edit->ithaber = new inputField("(<#o#>) Haber", "haber_<#i#>");
     $edit->ithaber->css_class = 'inputnum';
     $edit->ithaber->rule = 'callback_positivo';
     $edit->ithaber->db_name = 'haber';
     $edit->ithaber->rel_id = 'itcasi';
     $edit->ithaber->onchange = 'cal_totalh(<#i#>);';
     $edit->ithaber->size = 15;
     $edit->itorigen = new hiddenField("(<#o#>) Origen", "origen_<#i#>");
     $edit->itorigen->db_name = 'origen';
     $edit->itorigen->rel_id = 'itcasi';
     $status = $edit->get_from_dataobjetct('status');
     $fecha = $edit->get_from_dataobjetct('fecha');
     $error = $this->chcasise($fecha);
     if (empty($error)) {
         if ($status == 'C1') {
             $action = "javascript:window.location='" . site_url($this->url . '/actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
             $edit->button_status("btn_status", 'Cerrar Asiento', $action, "TR", "show");
             $edit->buttons("modify", "delete", "save");
         } elseif ($status == 'C2') {
             $action = "javascript:window.location='" . site_url($this->url . '/reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
             $edit->button_status("btn_rever", 'Reversar', $action, "TR", "show");
         } else {
             $edit->buttons("save");
         }
         $edit->buttons("modify", "delete", "save", "add");
     } else {
         if ($status == 'C1') {
             $edit->buttons("delete");
         }
     }
     $edit->buttons("add_rel", "undo", "back", "add");
     $edit->build();
     $smenu['link'] = barra_menu('198');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten['orden'] = $orden;
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_casi', $conten, true);
     //$data['content'] = $edit->output;
     $data['title'] = "{$this->t**s}";
     $data["head"] = $this->rapyd->get_head() . script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css');
     $this->load->view('view_ventanas', $data);
 }
Example #9
0
    function ccli($id_scli)
    {
        $id_scli = intval($id_scli);
        $row = $this->datasis->damerow("SELECT cliente,nombre,rifci FROM scli WHERE id={$id_scli}");
        if (empty($row)) {
            echo 'Cliente inexistente';
            return '';
        }
        $cliente = $row['cliente'];
        $dbcliente = $this->db->escape($cliente);
        $scli_nombre = $row['nombre'];
        $scli_rif = $row['rifci'];
        $cajero = $this->secu->getcajero();
        if (empty($cajero)) {
            echo 'El usuario debe tener registrado un cajero para poder usar este modulo';
            exit;
        }
        $this->rapyd->load('dataobject', 'datadetails');
        $this->rapyd->uri->keep_persistence();
        $do = new DataObject('smov');
        $do->rel_one_to_many('itccli', 'itccli', array('tipo_doc' => 'tipoccli', 'numero' => 'numccli', 'cod_cli' => 'cod_cli', 'transac' => 'transac'));
        $do->rel_one_to_many('sfpa', 'sfpa', array('transac' => 'transac', 'numero' => 'numero', 'tipo_doc' => 'tipo_doc'));
        $do->order_by('itccli', 'itccli.fecha');
        $edit = new DataDetails('Cobro a cliente', $do);
        $edit->on_save_redirect = false;
        $edit->back_url = site_url('finanzas/ccli/filteredgrid');
        $edit->set_rel_title('itccli', 'Efecto <#o#>');
        $edit->set_rel_title('sfpa', 'Forma de pago <#o#>');
        $edit->pre_process('insert', '_pre_ccli_insert');
        $edit->pre_process('update', '_pre_ccli_update');
        $edit->pre_process('delete', '_pre_ccli_delete');
        $edit->post_process('insert', '_post_ccli_insert');
        //$edit->post_process('delete', '_post_delete');
        $edit->cod_cli = new hiddenField('Cliente', 'cod_cli');
        $edit->cod_cli->rule = 'max_length[5]';
        $edit->cod_cli->size = 7;
        $edit->cod_cli->insertValue = $cliente;
        $edit->cod_cli->maxlength = 5;
        $edit->nombre = new inputField('Nombre', 'nombre');
        $edit->nombre->rule = 'max_length[40]';
        $edit->nombre->size = 42;
        $edit->nombre->maxlength = 40;
        $edit->codigo = new dropdownField('Motivo', 'codigo');
        $edit->codigo->option('', 'Seleccionar');
        $edit->codigo->options('SELECT TRIM(codigo) AS cod, nombre FROM botr WHERE tipo=\'C\' ORDER BY nombre');
        $edit->codigo->style = 'width:200px;';
        $edit->codigo->rule = '';
        $edit->vendedor = new dropdownField('Cobrador', 'vd');
        $edit->vendedor->option('', 'Seleccione cobrador');
        $edit->vendedor->options('SELECT TRIM(vendedor) AS vendedor, CONCAT(vendedor,\' \',nombre) nombre FROM vend WHERE tipo <> "V" ORDER BY vendedor');
        $edit->vendedor->style = 'width:200px;';
        $edit->vendedor->insertValue = trim($this->secu->getvendedor());
        $edit->vendedor->db_name = 'vendedor';
        $edit->numero = new inputField('N&uacute;mero', 'numero');
        $edit->numero->rule = 'max_length[8]';
        $edit->numero->size = 10;
        $edit->numero->maxlength = 8;
        $edit->fecdoc = new dateonlyField('Fecha', 'fecdoc');
        $edit->fecdoc->db_name = 'fecha';
        $edit->fecdoc->size = 12;
        $edit->fecdoc->maxlength = 8;
        $edit->fecdoc->insertValue = date('Y-m-d');
        $edit->fecdoc->calendar = false;
        $edit->fecdoc->rule = 'chfecha|chfechafut|required|callback_chcierre';
        $edit->monto = new inputField('Total', 'monto');
        $edit->monto->rule = 'max_length[17]|numeric';
        $edit->monto->css_class = 'inputnum';
        $edit->monto->size = 19;
        $edit->monto->maxlength = 17;
        $edit->monto->type = 'inputhidden';
        $edit->observa1 = new textareaField('Concepto:', 'observa1');
        $edit->observa1->cols = 70;
        $edit->observa1->rows = 2;
        $edit->observa1->style = 'width:100%;';
        $edit->observa2 = new textareaField('', 'observa2');
        $edit->observa2->cols = 70;
        $edit->observa2->rows = 2;
        $edit->observa2->style = 'width:100%;';
        $edit->observa2->when = array('show');
        $edit->codigo = new dropdownField('Motivo', 'codigo');
        $edit->codigo->option('', 'Ninguno');
        $edit->codigo->options('SELECT TRIM(codigo) AS cod, nombre FROM botr WHERE tipo=\'C\' ORDER BY nombre');
        $edit->codigo->style = 'width:200px;';
        $edit->codigo->rule = 'condi_required|callback_chobligatipo[NC]';
        $edit->nroex = new inputField('Referencia Externa', 'nroex');
        $edit->nroex->rule = 'max_length[15]';
        $edit->nroex->size = 15;
        $edit->nroex->maxlength = 15;
        $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->fecha   = new autoUpdateField('fecha'   ,date('Ymd'), date('Ymd'));
        //**************************************************************
        //inicio detalle itccli
        //
        $i = 0;
        $arr_ivas = array();
        $edit->detail_expand_except('itccli');
        $sel = array('a.tipo_doc', 'a.numero', 'a.fecha', 'a.monto', 'a.abonos', 'a.monto - a.abonos AS saldo');
        $this->db->select($sel);
        $this->db->from('smov AS a');
        $this->db->where('a.cod_cli', $cliente);
        $transac = $edit->get_from_dataobjetct('transac');
        if ($transac !== false) {
            $tipo_doc = $edit->get_from_dataobjetct('tipo_doc');
            $dbtransac = $this->db->escape($transac);
            $this->db->join('itccli AS b', 'a.tipo_doc = b.tipoccli AND a.numero=b.numccli AND a.transac=' . $dbtransac);
            $this->db->where('a.tipo_doc', $tipo_doc);
        } else {
            $this->db->where('a.monto > a.abonos');
            $this->db->where_in('a.tipo_doc', array('FC', 'ND', 'GI'));
        }
        $this->db->order_by('a.fecha');
        $query = $this->db->get();
        //echo $this->db->last_query();
        foreach ($query->result() as $row) {
            //$arr_ivas[$i]=array('');
            $obj = 'cod_cli_' . $i;
            $edit->{$obj} = new autoUpdateField('cod_cli', $cliente, $cliente);
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->ind = $i;
            $obj = 'tipo_doc_' . $i;
            $edit->{$obj} = new inputField('Tipo_doc', $obj);
            $edit->{$obj}->db_name = 'tipo_doc';
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->rule = 'max_length[2]';
            $edit->{$obj}->insertValue = $row->tipo_doc;
            $edit->{$obj}->size = 4;
            $edit->{$obj}->maxlength = 2;
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->type = 'inputhidden';
            $obj = 'numero_' . $i;
            $edit->{$obj} = new inputField('Numero', $obj);
            $edit->{$obj}->db_name = 'numero';
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->rule = 'max_length[8]';
            $edit->{$obj}->insertValue = $row->numero;
            $edit->{$obj}->size = 10;
            $edit->{$obj}->maxlength = 8;
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->type = 'inputhidden';
            $obj = 'fecha_' . $i;
            $edit->{$obj} = new dateonlyField('Fecha', $obj);
            $edit->{$obj}->db_name = 'fecha';
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->rule = 'chfecha';
            $edit->{$obj}->insertValue = $row->fecha;
            $edit->{$obj}->size = 10;
            $edit->{$obj}->maxlength = 8;
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->type = 'inputhidden';
            $obj = 'monto_' . $i;
            $edit->{$obj} = new inputField('Monto', $obj);
            $edit->{$obj}->db_name = 'monto';
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->rule = 'max_length[18]|numeric';
            $edit->{$obj}->css_class = 'inputnum';
            $edit->{$obj}->size = 20;
            $edit->{$obj}->insertValue = $row->monto;
            $edit->{$obj}->maxlength = 18;
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->showformat = 'decimal';
            $edit->{$obj}->type = 'inputhidden';
            $obj = 'saldo_' . $i;
            $edit->{$obj} = new freeField($obj, $obj, nformat($row->saldo));
            $edit->{$obj}->ind = $i;
            $obj = 'abono_' . $i;
            $edit->{$obj} = new inputField('Abono', $obj);
            $edit->{$obj}->db_name = 'abono';
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->rule = "max_length[18]|numeric|positive|callback_chabono[{$i}]";
            $edit->{$obj}->css_class = 'inputnum';
            $edit->{$obj}->showformat = 'decimal';
            $edit->{$obj}->autocomplete = false;
            $edit->{$obj}->disable_paste = true;
            $edit->{$obj}->size = 15;
            $edit->{$obj}->maxlength = 18;
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->onfocus = 'itsaldo(this,' . round($row->saldo, 2) . ');';
            $obj = 'ppago_' . $i;
            $edit->{$obj} = new inputField('Pronto Pago', $obj);
            $edit->{$obj}->db_name = 'ppago';
            $edit->{$obj}->rel_id = 'itccli';
            $edit->{$obj}->rule = "max_length[18]|numeric|positive|callback_chppago[{$i}]";
            $edit->{$obj}->css_class = 'inputnum';
            $edit->{$obj}->showformat = 'decimal';
            $edit->{$obj}->autocomplete = false;
            $edit->{$obj}->disable_paste = true;
            $edit->{$obj}->size = 15;
            $edit->{$obj}->maxlength = 18;
            $edit->{$obj}->ind = $i;
            $edit->{$obj}->onchange = "itppago(this,'{$i}');";
            $i++;
        }
        $edit->tipo_doc = new dropdownField('Tipo doc.', 'tipo_doc');
        if ($i > 0) {
            $edit->tipo_doc->option('AB', 'Abono');
            $edit->tipo_doc->option('NC', 'Nota de credito');
        } else {
            $edit->tipo_doc->insertValue = 'AN';
        }
        $edit->tipo_doc->option('AN', 'Anticipo');
        $edit->tipo_doc->style = 'width:140px;';
        $edit->tipo_doc->onchange = 'chtipodoc()';
        $edit->tipo_doc->rule = 'enum[AB,NC,AN]|required';
        //**************************************************************
        //fin de campos para detalle,inicio detalle2 sfpa
        //
        $edit->tipo = new dropdownField('Tipo <#o#>', 'tipo_<#i#>');
        $edit->tipo->option('', 'Ninguno');
        $edit->tipo->options('SELECT tipo, nombre FROM tarjeta WHERE activo=\'S\' ORDER BY nombre');
        $edit->tipo->db_name = 'tipo';
        $edit->tipo->rel_id = 'sfpa';
        $edit->tipo->style = 'width:160px;';
        $edit->tipo->rule = 'condi_required|callback_chsfpatipo[<#i#>]';
        $edit->tipo->insertValue = 'EF';
        $edit->tipo->onchange = 'sfpatipo(<#i#>)';
        $edit->tipo->rule = 'callback_chbmovrep[<#i#>]';
        $edit->sfpafecha = new dateonlyField('Fecha', 'sfpafecha_<#i#>');
        $edit->sfpafecha->rel_id = 'sfpa';
        $edit->sfpafecha->db_name = 'fecha';
        $edit->sfpafecha->size = 12;
        $edit->sfpafecha->maxlength = 8;
        $edit->sfpafecha->calendar = false;
        $edit->sfpafecha->rule = 'condi_required|chitfecha|callback_chtipo[<#i#>]';
        $edit->numref = new inputField('Numero <#o#>', 'num_ref_<#i#>');
        $edit->numref->size = 15;
        $edit->numref->db_name = 'num_ref';
        $edit->numref->rel_id = 'sfpa';
        $edit->numref->rule = 'trim|condi_required|callback_chtipo[<#i#>]|callback_chnumrep[<#i#>]';
        $edit->banco = new dropdownField('Banco <#o#>', 'banco_<#i#>');
        $edit->banco->option('', 'Ninguno');
        $edit->banco->options('SELECT cod_banc,nomb_banc
			FROM tban
			WHERE cod_banc<>\'CAJ\'
		UNION ALL
			SELECT codbanc,CONCAT_WS(\' \',TRIM(banco),numcuent)
			FROM banc
			WHERE tbanco <> \'CAJ\' ORDER BY nomb_banc');
        $edit->banco->db_name = 'banco';
        $edit->banco->rel_id = 'sfpa';
        $edit->banco->style = 'width:200px;';
        $edit->banco->rule = 'condi_required|callback_chtipo[<#i#>]';
        $edit->itmonto = new inputField('Monto <#o#>', 'itmonto_<#i#>');
        $edit->itmonto->db_name = 'monto';
        $edit->itmonto->css_class = 'inputnum';
        $edit->itmonto->rel_id = 'sfpa';
        $edit->itmonto->size = 14;
        $edit->itmonto->rule = 'condi_required|positive|callback_chmontosfpa[<#i#>]';
        $edit->itmonto->showformat = 'decimal';
        $edit->itmonto->autocomplete = false;
        //**************************************************************
        // Fin detalle 2 (sfpa)
        //
        $edit->buttons('add_rel');
        $edit->build();
        if ($edit->on_success()) {
            $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => $edit->_dataobject->pk);
            echo json_encode($rt);
        } else {
            if ($this->genesal) {
                $conten['cana'] = $i;
                $conten['form'] =& $edit;
                $conten['title'] = heading("Cobro a cliente: ({$cliente}) {$scli_nombre} {$scli_rif}");
                $data['content'] = $this->load->view('view_ccli.php', $conten);
            } else {
                if ($edit->on_error()) {
                    $rt = array('status' => 'B', 'mensaje' => preg_replace('/<[^>]*>/', '', $edit->error_string), 'pk' => null);
                    echo json_encode($rt);
                }
                if ($edit->on_success()) {
                    $rt = array('status' => 'A', 'mensaje' => 'Registro guardado', 'pk' => null);
                    echo json_encode($rt);
                }
            }
        }
    }
Example #10
0
 function dataedit()
 {
     $this->rapyd->load('dataobject', 'datadetails');
     //SELECT a.codigopres, CONCAT_WS("-",a.codigopres,b.denominacion) AS val FROM presupuesto AS a JOIN ppla AS b ON a.codigopres=b.codigo WHERE tipo=<#fondo#> AND codigoadm=<#estadmin#> AND LENGTH(a.codigopres)='.$this->flongpres
     $partidaiva = $this->datasis->traevalor('PARTIDAIVA');
     $modbus = array('tabla' => 'v_presaldo', 'columnas' => array('codigoadm' => 'Est. Admin', 'fondo' => 'Fondo', 'codigo' => 'Partida', 'ordinal' => 'Ordinal', 'denominacion' => 'Denominaci&oacute;n', 'saldo' => 'Saldo'), 'filtro' => array('codigoadm' => 'Est. Admin', 'fondo' => 'Fondo', 'codigo' => 'Partida', 'ordinal' => 'Ord', 'denominacion' => 'Denominaci&oacute;n'), 'retornar' => array('codigoadm' => 'codigoadm_<#i#>', 'fondo' => 'fondo_<#i#>', 'codigo' => 'codigopres_<#i#>', 'ordinal' => 'ordinal_<#i#>', 'denominacion' => 'denomi_<#i#>'), 'where' => 'movimiento = "S"', 'p_uri' => array(4 => '<#i#>'), 'titulo' => 'Busqueda de partidas');
     $btn = $this->datasis->p_modbus($modbus, '<#i#>');
     $do = new DataObject("audis");
     $do->rel_one_to_many('itaudis', 'itaudis', array('numero' => 'numero'));
     $do->rel_pointer('itaudis', 'v_presaldo', 'itaudis.codigoadm=v_presaldo.codigoadm AND itaudis.fondo=v_presaldo.fondo AND itaudis.codigopres=v_presaldo.codigo', "v_presaldo.denominacion as denomi2");
     $do->order_by('itaudis', 'itaudis.id', 'asc');
     $edit = new DataDetails("Datos de Aumentos y Disminuciones", $do);
     $edit->back_url = site_url("presupuesto/audis/filteredgrid");
     $edit->pre_process('update', '_pre_process');
     $edit->pre_process('delete', '_pre_process');
     $edit->set_rel_title('itaudis', 'Rubro <#o#>');
     $edit->pre_process('update', '_valida');
     $edit->pre_process('insert', '_valida');
     $edit->status = new autoupdateField('status', 'P');
     $edit->status->apply_rules = true;
     $edit->status->rule = 'callback_chstatus';
     $edit->numero = new inputField("N&uacute;mero", "numero");
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show');
     $edit->nrooficio = new inputField("N&uacute;mero de Decreto", "nrooficio");
     $edit->nrooficio->size = 12;
     $edit->resolu = new inputField("Resoluci&oacute;n", "resolu");
     $edit->resolu->size = 40;
     $edit->fresolu = new dateonlyField("Fecha Resoluci&oacute;n", "fresolu");
     $edit->fresolu->insertValue = date('Y-m-d');
     $edit->fresolu->size = 12;
     $edit->tipo = new dropdownField("Tipo", "tipo");
     $edit->tipo->option("AUMENTO", "Aumento");
     $edit->tipo->option("DISMINUCION", "Disminuci&oacute;n");
     $edit->fecha = new dateonlyField("Fecha", "fecha");
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->size = 12;
     $edit->motivo = new textareaField("Motivo", "motivo");
     $edit->motivo->rows = 4;
     $edit->motivo->cols = 100;
     $edit->motivo->rule = 'required';
     $edit->uejecutora = new dropdownField("U.Ejecutora", "uejecutora");
     $edit->uejecutora->option("", "Seccionar");
     $edit->uejecutora->options("SELECT codigo,nombre FROM uejecutora ORDER BY nombre");
     $edit->uejecutora->onchange = "get_uadmin();";
     $edit->uejecutora->rule = "required";
     $edit->uadministra = new dropdownField("U.Administrativa", "uadministra");
     $edit->uadministra->option("", "Ninguna");
     $ueje = $edit->getval('uejecuta');
     if ($ueje !== false) {
         $edit->uadministra->options("SELECT codigo,nombre FROM uadministra WHERE codigoejec='{$ueje}' ORDER BY nombre");
     } else {
         $edit->uadministra->option("", "Seleccione una unidad ejecutora primero");
     }
     $edit->fondo = new dropdownField("Fondo", "fondo_<#i#>");
     $edit->fondo->size = 10;
     $edit->fondo->rule = 'required';
     $edit->fondo->db_name = 'fondo';
     $edit->fondo->rel_id = 'itaudis';
     $edit->fondo->options("SELECT tipo,tipo a  FROM presupuesto WHERE tipo<>'' GROUP BY tipo ORDER BY tipo desc");
     //$edit->fondo->options("SELECT fondo,fondo a  FROM fondo GROUP BY fondo ORDER BY fondo desc");
     $edit->fondo->style = "width:100px;";
     $edit->codigoadm = new inputField("Estructura\tAdministrativa", "codigoadm_<#i#>");
     $edit->codigoadm->size = 10;
     $edit->codigoadm->db_name = 'codigoadm';
     $edit->codigoadm->rel_id = 'itaudis';
     $edit->codigoadm->rule = 'required';
     $edit->codigopres = new inputField("(<#o#>) Partida", "codigopres_<#i#>");
     $edit->codigopres->rule = 'callback_repetido|required';
     $edit->codigopres->size = 10;
     $edit->codigopres->append($btn);
     $edit->codigopres->db_name = 'codigopres';
     $edit->codigopres->rel_id = 'itaudis';
     $edit->codigopres->insertValue = "4";
     //$edit->partida->readonly =true;
     $edit->denomi = new inputField("(<#o#>) Denominaci&oacute;n", "denomi_<#i#>");
     $edit->denomi->db_name = 'denomi2';
     $edit->denomi->rel_id = 'itaudis';
     $edit->denomi->cols = 20;
     $edit->denomi->rows = 1;
     $edit->denomi->readonly = true;
     $edit->denomi->pointer = true;
     $edit->monto = new inputField("(<#o#>) monto", "monto_<#i#>");
     $edit->monto->rule = 'required|callback_positivo';
     $edit->monto->db_name = 'monto';
     $edit->monto->rel_id = 'itaudis';
     $edit->monto->size = 15;
     $edit->monto->css_class = 'inputnum';
     $edit->monto->onchange = 'cal_total(<#i#>);';
     $edit->total = new inputField("Cantidad total", "total");
     $edit->total->css_class = 'inputnum';
     $edit->total->readonly = true;
     $edit->total->rule = 'numeric';
     $edit->total->size = 15;
     $status = $edit->get_from_dataobjetct('status');
     if ($status == 'P') {
         $action = "javascript:window.location='" . site_url('presupuesto/audis/actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_status", 'Actualizar', $action, "TR", "show");
         $edit->buttons("modify", "delete", "save");
     } elseif ($status == 'C') {
         $action = "javascript:window.location='" . site_url('presupuesto/audis/reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_rever", 'Anular', $action, "TR", "show");
     } else {
         $edit->buttons("save");
     }
     $edit->buttons("add", "undo", "back", "add_rel");
     $edit->build();
     $smenu['link'] = barra_menu('330');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_audis', $conten, true);
     //$data['content'] = $edit->output;
     $data['title'] = "Aumentos y Disminuciones";
     //$data["head"]    = $this->rapyd->get_head().script('jquery.js').script("plugins/jquery.numeric.pack.js").script('plugins/jquery.autocomplete.js').script('plugins/jquery.meiomask.js').style('jquery.autocomplete.css');
     $data["head"] = $this->rapyd->get_head() . script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css');
     $this->load->view('view_ventanas', $data);
 }
Example #11
0
 function multiple()
 {
     $this->rapyd->load('dataobject', 'datadetails');
     $this->rapyd->uri->keep_persistence();
     $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'C&oacute;digo', 'fondo' => 'Clasificacion', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'filtro' => array('codbanc' => 'C&oacute;odigo', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'p_uri' => array(4 => '<#i#>'), 'retornar' => array('codbanc' => 'codbancm_<#i#>'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos');
     $bBANC = $this->datasis->p_modbus($mBANC, "<#i#>");
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;digo', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov', 'nombre' => 'nombrep'), 'titulo' => 'Buscar Beneficiario');
     $bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
     $do = new DataObject("mbancm");
     $do->rel_one_to_many('mbanc', 'mbanc', array('numero' => 'multiple'));
     $do->order_by('mbanc', 'id');
     $edit = new DataDetails($this->t**s, $do);
     $edit->back_url = site_url($this->url . "filteredgrid");
     $edit->set_rel_title('pades', 'Rubro <#o#>');
     $edit->pre_process('insert', '_validam');
     $edit->pre_process('update', '_validam');
     //$edit->post_process('insert','_post_insert');
     //$edit->post_process('update','_post_update');
     //$edit->post_process('delete','_post_delete');
     $status = $edit->get_from_dataobjetct('status');
     //**************************INICIO ENCABEZADO********************************************************************
     $edit->numero = new inputField("N&uacute;mero", "numero");
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show');
     $edit->totalch = new inputField("Total en Cheques Activos", "totalch");
     $edit->totalch->size = 15;
     $edit->totalch->readonly = true;
     $edit->totalch->css_class = 'inputnum';
     $edit->totalch->rule = 'numeric';
     //**************************INICIO DETALLE DE DE MOVIMIENTOS BANCARIOS*******************************************
     $edit->itidm = new inputField("(<#o#>) Referencia", 'idm_<#i#>');
     $edit->itidm->db_name = 'id';
     $edit->itidm->rel_id = 'mbanc';
     $edit->itidm->when = array('show');
     $edit->itstatusm = new dropdownField("(<#o#>) Banco", 'statusm_<#i#>');
     if ($edit->_status == 'show') {
         $edit->itstatusm->option("NC", "Nota de Cr&eacute;dito");
     }
     $edit->itstatusm->option("J1", "Pendiente");
     $edit->itstatusm->option("J2", "Ejecutado");
     $edit->itstatusm->option("AN", "Anulado");
     $edit->itstatusm->option("A2", "Anulado.");
     $edit->itstatusm->db_name = 'status';
     $edit->itstatusm->size = 3;
     $edit->itstatusm->rel_id = 'mbanc';
     $edit->itstatusm->style = "width:100px;";
     $edit->itstatusm->onchange = "cal_totalch();";
     $edit->itstatusm->when = array('show');
     //$edit->itstatusm->pointer = true;
     $edit->itcodbancm = new inputField("(<#o#>) Banco", 'codbancm_<#i#>');
     $edit->itcodbancm->db_name = 'codbanc';
     $edit->itcodbancm->size = 3;
     $edit->itcodbancm->readonly = true;
     $edit->itcodbancm->rel_id = 'mbanc';
     $edit->itcodbancm->rule = "required|callback_banco";
     $edit->itcodbancm->append($bBANC);
     //$edit->itcodbancm->pointer = true;
     $edit->itdestino = new dropdownField("(<#o#>) Destino", "destino_<#i#>");
     $edit->itdestino->db_name = 'destino';
     $edit->itdestino->option("I", "Interno");
     $edit->itdestino->option("C", "Caja");
     $edit->itdestino->style = "width:50px";
     $edit->itdestino->rel_id = 'mbanc';
     $edit->ittipo_docm = new dropdownField("(<#o#>) Tipo Documento", "tipo_docm_<#i#>");
     $edit->ittipo_docm->db_name = 'tipo_doc';
     $edit->ittipo_docm->option("DP", "Deposito");
     $edit->ittipo_docm->option("CH", "Cheque");
     $edit->ittipo_docm->option("NC", "Nota de Credito");
     $edit->ittipo_docm->option("ND", "Nota de Debito");
     $edit->ittipo_docm->rel_id = 'mbanc';
     $edit->ittipo_docm->style = "width:130px;";
     //$edit->ittipo_docm->pointer = true;
     $edit->itfecham = new dateonlyField("(<#o#>) Fecha Cheque", "fecham_<#i#>");
     $edit->itfecham->db_name = 'fecha';
     $edit->itfecham->size = 10;
     $edit->itfecham->rule = 'required';
     $edit->itfecham->rel_id = 'mbanc';
     $edit->itfecham->insertValue = date('Ymd');
     //$edit->itfecham->pointer = true;
     $edit->itbenefim = new inputField("(<#o#>) A Nombre de", 'benefim_<#i#>');
     $edit->itbenefim->db_name = 'benefi';
     $edit->itbenefim->size = 15;
     $edit->itbenefim->maxlenght = 40;
     $edit->itbenefim->rel_id = 'mbanc';
     $edit->itfecha2m = new dateonlyField("(<#o#>) Fecha Documento", "fecha2m_<#i#>");
     $edit->itfecha2m->db_name = 'fecha2';
     $edit->itfecha2m->size = 10;
     $edit->itfecha2m->rule = 'required';
     $edit->itfecha2m->rel_id = 'mbanc';
     $edit->itfecha2m->insertValue = date('Ymd');
     //$edit->itfecham->pointer = true;
     $edit->itchequem = new inputField("(<#o#>) Cheque", 'chequem_<#i#>');
     $edit->itchequem->db_name = 'cheque';
     $edit->itchequem->size = 10;
     $edit->itchequem->rule = "required";
     //callback_chexiste_cheque|
     $edit->itchequem->rel_id = 'mbanc';
     //$edit->itchequem->pointer = true;
     $edit->itmontom = new inputField("(<#o#>) Total", 'montom_<#i#>');
     $edit->itmontom->db_name = 'monto';
     //$edit->itmontom->mode      = 'autohide';
     //$edit->itmontom->when     = array('show');
     $edit->itmontom->size = 15;
     //$edit->itmontom->rule      ='callback_positivo';
     $edit->itmontom->rel_id = 'mbanc';
     $edit->itmontom->css_class = 'inputnum';
     $edit->itmontom->onchange = "cal_totalch();";
     //$edit->itmontom->pointer = true;
     $edit->itobservam = new textAreaField("(<#o#>) Observaciones", 'observam_<#i#>');
     $edit->itobservam->db_name = 'observa';
     $edit->itobservam->cols = 30;
     $edit->itobservam->rows = 1;
     $edit->itobservam->rel_id = 'mbanc';
     //$edit->itobservam->pointer = true;
     //************************** FIN   DETALLE DE DE MOVIMIENTOS BANCARIOS*******************************************
     $edit->button_status("btn_add_mbanc", 'Agregar Cheque/Nota de Debito', "javascript:add_mbanc()", "MB", 'modify', "button_add_rel");
     $edit->button_status("btn_add_mbanc2", 'Agregar Cheque/Nota de Debito', "javascript:add_mbanc()", "MB", 'create', "button_add_rel");
     $edit->buttons("undo", "back", "add", "modify", "save", "delete");
     $edit->build();
     //$smenu['link']   = barra_menu('208');
     //$data['smenu']   = $this->load->view('view_sub_menu', $smenu,true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_mbanc', $conten, true);
     //$data['content'] = $edit->output;
     $data['title'] = "{$this->t**s}";
     $data["head"] = $this->rapyd->get_head() . script('jquery.js') . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.json.min.js");
     $this->load->view('view_ventanas', $data);
 }
Example #12
0
 function dataedit()
 {
     $this->datasis->modulo_id(75, 1);
     $this->rapyd->load('dataobject', 'datadetails');
     $partidaiva = $this->datasis->traevalor('PARTIDAIVA');
     $modbus = array('tabla' => 'v_presaldo', 'columnas' => array('codigoadm' => 'Est. Admin', 'fondo' => 'Fondo', 'codigo' => 'Partida', 'ordinal' => 'Ordinal', 'denominacion' => 'Denominaci&oacute;n', 'saldo' => 'Saldo'), 'filtro' => array('codigoadm' => 'Est. Admin', 'fondo' => 'Fondo', 'codigo' => 'Partida', 'ordinal' => 'Ord', 'denominacion' => 'Denominaci&oacute;n'), 'retornar' => array('codigoadm' => 'codigoadm_<#i#>', 'fondo' => 'fondo_<#i#>', 'codigo' => 'codigopres_<#i#>', 'ordinal' => 'ordinal_<#i#>', 'denominacion' => 'denomi_<#i#>'), 'where' => 'movimiento = "S"', 'p_uri' => array(4 => '<#i#>'), 'titulo' => 'Busqueda de partidas');
     $btn = $this->datasis->p_modbus($modbus, '<#i#>');
     $do = new DataObject("trasla");
     $do->rel_one_to_many('ittrasla', 'ittrasla', array('numero' => 'numero'));
     //$do->rel_pointer('ittrasla','v_presaldo' ,'ittrasla.codigoadm=v_presaldo.codigoadm AND ittrasla.fondo=v_presaldo.fondo AND ittrasla.codigopres=v_presaldo.codigo AND ittrasla.ordinal=IF(ittrasla.ordinal>0,v_presaldo.ordinal,ittrasla.ordinal)',"v_presaldo.denominacion as denomi2");
     $do->order_by('ittrasla', 'ittrasla.id', 'asc');
     $edit = new DataDetails("Datos de Traslados de Partidas", $do);
     $edit->back_url = site_url("presupuesto/trasla/filteredgrid");
     $edit->set_rel_title('ittrasla', 'Rubro <#o#>');
     $edit->pre_process('insert', '_mayor');
     $edit->pre_process('update', '_mayor');
     $edit->pre_process('insert', '_valida');
     $edit->pre_process('update', '_valida');
     $edit->numero = new inputField("N&uacute;mero", "numero");
     $edit->numero->mode = "autohide";
     $edit->numero->when = array('show');
     $edit->fecha = new dateonlyField("Fecha", "fecha");
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->size = 12;
     $edit->nrooficio = new inputField("N&uacute;mero de Decreto", "nrooficio");
     $edit->nrooficio->size = 12;
     $edit->resolu = new inputField("Resoluci&oacute;n", "resolu");
     $edit->resolu->size = 40;
     $edit->fresolu = new dateonlyField("Fecha Resoluci&oacute;n", "fresolu");
     $edit->fresolu->insertValue = date('Y-m-d');
     $edit->fresolu->size = 12;
     $edit->motivo = new textareaField("Motivo", "motivo");
     $edit->motivo->rows = 4;
     $edit->motivo->cols = 80;
     $edit->motivo->rule = 'required';
     $edit->fondo = new dropdownField("Fondo", "fondo_<#i#>");
     $edit->fondo->size = 10;
     $edit->fondo->rule = 'required';
     $edit->fondo->db_name = 'fondo';
     $edit->fondo->rel_id = 'ittrasla';
     $edit->fondo->options("SELECT tipo,tipo a  FROM presupuesto WHERE tipo<>'' GROUP BY tipo ORDER BY tipo desc");
     $edit->fondo->style = "width:100px;";
     $edit->codigoadm = new inputField("Estructura\tAdministrativa", "codigoadm_<#i#>");
     $edit->codigoadm->size = 12;
     $edit->codigoadm->db_name = 'codigoadm';
     $edit->codigoadm->rel_id = 'ittrasla';
     $edit->codigoadm->rule = 'required';
     $edit->codigoadm->autocomplete = false;
     $edit->codigopres = new inputField("(<#o#>) Partida", "codigopres_<#i#>");
     $edit->codigopres->rule = 'required';
     $edit->codigopres->size = 15;
     $edit->codigopres->append($btn);
     $edit->codigopres->db_name = 'codigopres';
     $edit->codigopres->rel_id = 'ittrasla';
     $edit->codigopres->autocomplete = false;
     //$edit->partida->readonly =true;
     $edit->ordinal = new inputField("(<#o#>) Ordinal", "ordinal_<#i#>");
     $edit->ordinal->db_name = 'ordinal';
     $edit->ordinal->maxlength = 1;
     $edit->ordinal->size = 5;
     $edit->ordinal->rel_id = 'ittrasla';
     $edit->denomi = new textareaField("(<#o#>) Denominaci&oacute;n", "denomi_<#i#>");
     $edit->denomi->db_name = 'denomi2';
     $edit->denomi->rel_id = 'ittrasla';
     $edit->denomi->cols = 20;
     $edit->denomi->rows = 1;
     $edit->denomi->readonly = true;
     $edit->denomi->pointer = true;
     $edit->disminucion = new inputField("(<#o#>) disminucion", "disminucion_<#i#>");
     $edit->disminucion->rule = 'required|callback_positivo';
     $edit->disminucion->db_name = 'disminucion';
     $edit->disminucion->rel_id = 'ittrasla';
     $edit->disminucion->size = 15;
     $edit->disminucion->css_class = 'inputnum';
     $edit->disminucion->onchange = 'cal_totald(<#i#>);';
     $edit->disminucion->insertValue = '0';
     $edit->aumento = new inputField("(<#o#>) aumento", "aumento_<#i#>");
     $edit->aumento->rule = 'required|callback_positivo';
     $edit->aumento->db_name = 'aumento';
     $edit->aumento->rel_id = 'ittrasla';
     $edit->aumento->size = 15;
     $edit->aumento->css_class = 'inputnum';
     $edit->aumento->onchange = 'cal_totala(<#i#>);';
     $edit->aumento->insertValue = '0';
     $edit->tdisminucion = new inputField("Total Disminuci&oacute;n", "tdisminucion");
     $edit->tdisminucion->css_class = 'inputnum';
     $edit->tdisminucion->readonly = true;
     $edit->tdisminucion->rule = 'numeric';
     $edit->tdisminucion->size = 15;
     $edit->tdisminucion->insertValue = '0';
     $edit->taumento = new inputField("Total Aumento", "taumento");
     $edit->taumento->css_class = 'inputnum';
     $edit->taumento->readonly = true;
     $edit->taumento->rule = 'numeric';
     $edit->taumento->size = 15;
     $edit->taumento->insertValue = '0';
     $status = $edit->get_from_dataobjetct('status');
     if ($status == 'P') {
         $action = "javascript:window.location='" . site_url('presupuesto/trasla/actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_status", 'Actualizar', $action, "TR", "show");
         $action = "javascript:window.location='" . site_url('presupuesto/trasla/apartar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_apartar", 'Apartar', $action, "TR", "show");
         $edit->buttons("delete", "modify", "save");
     } elseif ($status == 'C') {
         $action = "javascript:window.location='" . site_url('presupuesto/trasla/reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_rever", 'Anular', $action, "TR", "show");
     } elseif ($status == 'H') {
         $action = "javascript:window.location='" . site_url('presupuesto/trasla/desapartar/' . $edit->rapyd->uri->get_edited_id()) . "'";
         $edit->button_status("btn_desap", 'Desapartar', $action, "TR", "show");
     } else {
         $edit->buttons("save");
     }
     $edit->buttons("add", "undo", "back", "add_rel");
     //"modify", "save",  "delete",
     $edit->build();
     $smenu['link'] = barra_menu('331');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('view_trasla', $conten, true);
     $data['title'] = "Traslados de Partidas";
     $data["head"] = script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Example #13
0
 function dataedit()
 {
     $this->rapyd->load('datadetails', 'dataobject');
     $do = new DataObject("r_conc");
     $do->rel_one_to_many('r_concit', 'r_concit', array('id' => 'id_conc'));
     $do->order_by('r_concit', "ano", ' ');
     $do->order_by('r_concit', "freval", ' ');
     $edit = new DataDetails($this->t**s, $do);
     $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->id = new inputField('Ref.', 'id');
     $edit->id->rule = 'max_length[11]';
     $edit->id->size = 13;
     $edit->id->maxlength = 11;
     $edit->id->mode = 'autohide';
     $edit->id->when = array('show', 'modify');
     $edit->id_presup = new dropDownField('Partida', 'id_presup');
     $edit->id_presup->options("SELECT id,CONCAT(partida,'-',denomi) FROM r_presup ORDER BY partida");
     $edit->id_presup->style = "width:500px;";
     $edit->id_presup->rule = 'required';
     $edit->denomi = new inputField('Denominacion', 'denomi');
     $edit->denomi->rule = 'max_length[80]';
     $edit->denomi->size = 50;
     $edit->denomi->maxlength = 80;
     $edit->denomi->rule = 'required';
     /*
      * DETALLE
      * */
     $edit->itid = new inputField("(<#o#>) Referencia", 'id_<#i#>');
     $edit->itid->db_name = 'id';
     $edit->itid->rel_id = 'r_concit';
     //$edit->itid->when      =array('show');
     $edit->itid->readonly = true;
     $edit->itid->size = 1;
     $edit->itexpira = new dropDownField('(<#o#>) Exp', 'expira_<#i#>');
     $edit->itexpira->option('N', 'Nunca');
     $edit->itexpira->option('M', 'Mensual');
     $edit->itexpira->option('A', 'Anual');
     $edit->itexpira->option('2', 'Semestral');
     $edit->itexpira->option('T', 'Trimestral');
     $edit->itexpira->style = "width:40px;";
     $edit->itexpira->db_name = 'expira';
     $edit->itexpira->rel_id = 'r_concit';
     $edit->itano = new dropDownField('(<#o#>) A&ntilde;o', 'ano_<#i#>');
     $edit->itano->option('0', '');
     for ($i = 1990; $i <= 2016; $i++) {
         $edit->itano->option($i, $i);
     }
     $edit->itano->style = "width:40px;";
     $edit->itano->db_name = 'ano';
     $edit->itano->rel_id = 'r_concit';
     $edit->itfrecuencia = new dropDownField('(<#o#>) frec', 'frecuencia_<#i#>');
     $edit->itfrecuencia->option('0', 'Independiente');
     $edit->itfrecuencia->option('1', 'Anual');
     $edit->itfrecuencia->option('2', 'Semestral');
     $edit->itfrecuencia->option('3', 'Trimestral');
     $edit->itfrecuencia->option('4', 'Mensual');
     $edit->itfrecuencia->style = "width:40px;";
     $edit->itfrecuencia->db_name = 'frecuencia';
     $edit->itfrecuencia->rel_id = 'r_concit';
     $edit->itfreval = new dropDownField('(<#o#>) Val Frec', 'freval_<#i#>');
     $edit->itfreval->option('0', '');
     for ($i = 1; $i <= 12; $i++) {
         $edit->itfreval->option($i, $i);
     }
     $edit->itfreval->style = "width:40px;";
     $edit->itfreval->db_name = 'freval';
     $edit->itfreval->rel_id = 'r_concit';
     $edit->itacronimo = new inputField('(<#o#>) Acronimo', 'acronimo_<#i#>');
     $edit->itacronimo->rule = 'max_length[50]';
     $edit->itacronimo->size = 5;
     $edit->itacronimo->maxlength = 50;
     $edit->itacronimo->db_name = 'acronimo';
     $edit->itacronimo->rel_id = 'r_concit';
     $edit->itdenomi = new inputField('(<#o#>) Denominacion', 'denomi_<#i#>');
     $edit->itdenomi->rule = 'required';
     $edit->itdenomi->size = 25;
     $edit->itdenomi->maxlength = 80;
     $edit->itdenomi->db_name = 'denomi';
     $edit->itdenomi->rel_id = 'r_concit';
     $edit->itrequiere = new dropDownField('(<#o#>) Requiere', 'requiere_<#i#>');
     $edit->itrequiere->option('', '');
     $edit->itrequiere->option('INMUEBLE', 'INMUEBLE');
     $edit->itrequiere->option('VEHICULO', 'VEHICULO');
     $edit->itrequiere->option('PATENTE', 'PATENTE');
     $edit->itrequiere->option('MANUAL', 'MANUAL');
     $edit->itrequiere->option('INTERESES', 'INTERESES');
     $edit->itrequiere->option('BASE', 'BASE');
     $edit->itrequiere->option('PUBLICIDAD', 'PUBLICIDAD');
     $edit->itrequiere->option('DESCUENTO', 'DESCUENTO');
     $edit->itrequiere->style = "width:150px;";
     $edit->itrequiere->db_name = 'requiere';
     $edit->itrequiere->rel_id = 'r_concit';
     $edit->itmodo = new dropDownField('(<#o#>) Modo', 'modo_<#i#>');
     $edit->itmodo->option('MANUAL', 'MANUAL');
     $edit->itmodo->option('BASE', 'BASE');
     $edit->itmodo->option('CALCULADO', 'CALCULADO');
     $edit->itmodo->style = "width:150px;";
     $edit->itmodo->db_name = 'modo';
     $edit->itmodo->rel_id = 'r_concit';
     $edit->itformula = new textareaField('(<#o#>) Formula', 'formula_<#i#>');
     //$edit->itformula->rule='max_length[8]';
     $edit->itformula->cols = 40;
     $edit->itformula->rows = 2;
     $edit->itformula->db_name = 'formula';
     $edit->itformula->rel_id = 'r_concit';
     $edit->buttons('add_rel', 'add', 'modify', 'save', 'undo', 'delete', 'back');
     $edit->build();
     #04247094489
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('recaudacion/r_conc', $conten, true);
     $data["head"] = $this->rapyd->get_head() . script('jquery.js') . script('jquery-ui.js') . script("plugins/jquery.numeric.pack.js") . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css');
     $data['title'] = $this->t**s;
     $this->load->view('view_ventanas', $data);
 }
Example #14
0
 function dataedit($id_contribu = false)
 {
     $this->rapyd->load('datadetails', 'dataobject');
     $modbus = array('tabla' => 'r_contribu', 'columnas' => array('id' => 'Ref.', 'rifci' => 'Rif/CI', 'nombre' => 'Nombre'), 'filtro' => array('id' => 'Ref.', 'rifci' => 'Rif/CI', 'nombre' => 'Nombre'), 'retornar' => array('id' => 'id_contribu', 'nombre' => 'nombre', 'rifci' => 'rifci'), 'titulo' => 'Buscar Contribuyente');
     $button = $this->datasis->modbus($modbus);
     $modbus = array('tabla' => 'r_v_conc', 'columnas' => array('id' => 'Ref', 'ano' => 'A&ntilde;o', 'acronimo' => 'Acronimo', 'denomi' => 'Denominacion', 'denomiconc' => 'Denomi Padre', 'partida' => 'Partida'), 'filtro' => array('denomi' => 'Denominacion', 'denomiconc' => 'Denomi Padre', 'partida' => 'Partida'), 'retornar' => array('id' => 'id_concit_<#i#>', 'ano' => 'ano_<#i#>', 'denomi' => 'denomi_<#i#>', 'requiere' => 'requiere_<#i#>', 'modo' => 'modo_<#i#>'), 'titulo' => 'Buscar Concepto', 'script' => array('post_conc(<#i#>,0)'), 'p_uri' => array(4 => '<#i#>'));
     $buttonconc = $this->datasis->p_modbus($modbus, '<#i#>');
     $mVEHICULO = array('tabla' => 'r_v_vehiculo', 'columnas' => array('id' => 'Ref.', 'placa' => 'Placa', 'marca' => 'Marca', 'modelo' => 'Modelo', 'color' => 'Color', 'tipo' => 'Tipo', 'clase' => 'Clase'), 'filtro' => array('id' => 'Ref.', 'placa' => 'Placa', 'marca' => 'Marca', 'modelo' => 'Modelo', 'color' => 'Color', 'tipo' => 'Tipo', 'clase' => 'Clase'), 'retornar' => array('id' => 'id_vehiculo_<#i#>', 'placa' => 'v_placa_<#i#>'), 'p_uri' => array(4 => '<#id_contribu#>', 5 => '<#i#>'), 'where' => 'id_contribu = <#id_contribu#>', 'script' => array('post_conc(<#i#>,1)'), 'titulo' => 'Buscar Vehiculo');
     $bVEHICULO = $this->datasis->p_modbus($mVEHICULO, '<#id_contribu#>/<#i#>');
     $bVEHICULO = '<img id="modbusv_<#i#>" src="' . base_url() . 'assets/default/images/system-search.png"  alt="Busqueda de Vehiculos" title="Busqueda de Vehiculos" border="0" onclick="modbusdepenv(<#i#>)"/>';
     $mINMUEBLE = array('tabla' => 'r_v_inmueble', 'columnas' => array('id' => 'Ref.', 'catastro' => 'Catastro', 'direccion' => 'Direccion', 'mt2' => 'Mts2', 'techo' => 'Techo'), 'filtro' => array('id' => 'Ref.', 'catastro' => 'Catastro', 'direccion' => 'Direccion', 'mt2' => 'Mts2', 'techo' => 'Techo'), 'retornar' => array('id' => 'id_inmueble_<#i#>', 'catastro' => 'i_catastro_<#i#>', 'direccion' => 'observa_<#i#>'), 'p_uri' => array(4 => '<#id_contribu#>', 5 => '<#i#>'), 'where' => 'id_contribu = <#id_contribu#>', 'script' => array('post_conc(<#i#>,1)'), 'titulo' => 'Buscar Inmueble');
     $bINMUEBLE = $this->datasis->p_modbus($mINMUEBLE, '<#id_contribu#>/<#i#>');
     $bINMUEBLE = '<img id="modbusi_<#i#>" src="/tortuga/assets/default/images/system-search.png"  alt="Busqueda de Vehiculos" title="Busqueda de Vehiculos" border="0" onclick="modbusdepeni(<#i#>)"/>';
     $mPUBLICIDAD = array('tabla' => 'r_v_publicidad', 'columnas' => array('id' => 'Ref.', 'direccion' => 'Direccion', 'ancho' => 'Ancho', 'alto' => 'Alto', 'descrip' => 'Descripcion'), 'filtro' => array('id' => 'Ref.', 'direccion' => 'Direccion', 'ancho' => 'Ancho', 'alto' => 'Alto', 'descrip' => 'Descripcion'), 'retornar' => array('id' => 'id_publicidad_<#i#>', 'CONCAT(ancho,"X",alto," mts2")' => 'observa_<#i#>'), 'p_uri' => array(4 => '<#id_contribu#>', 5 => '<#i#>'), 'where' => 'id_contribu = <#id_contribu#>', 'script' => array('traemonto(<#i#>)'), 'titulo' => 'Buscar Vehiculo');
     $bPUBLICIDAD = $this->datasis->p_modbus($mPUBLICIDAD, '<#id_contribu#>/<#i#>');
     $bPUBLICIDAD = '<img id="modbusp_<#i#>" src="/tortuga/assets/default/images/system-search.png"  alt="Busqueda de Publicidades" title="Busqueda de Publicidad" border="0" onclick="modbusdepenp(<#i#>)"/>';
     $mINMUEBLET = array('tabla' => 'r_v_inmueble', 'columnas' => array('id' => 'Ref.', 'catastro' => 'Catastro', 'direccion' => 'Direccion', 'mt2' => 'Mts2', 'tipoi' => 'Tipo'), 'filtro' => array('id' => 'Ref.', 'catastro' => 'Catastro', 'direccion' => 'Direccion', 'mt2' => 'Mts2', 'tipoi' => 'Tipo'), 'retornar' => array('id' => 'id_inmueble'), 'p_uri' => array(4 => '<#id_contribu#>'), 'where' => 'id_contribu = <#id_contribu#>', 'script' => array('post_inmueblet()'), 'titulo' => 'Buscar Inmueble');
     $bINMUEBLET = $this->datasis->modbus($mINMUEBLET, 'r_v_inmueblet', 800, 600, 'r_v_inmueblet');
     $bINMUEBLET = '<img id="modbusit" src="/tortuga/assets/default/images/system-search.png"  alt="Busqueda de Inmuebles" title="Busqueda de Inmuebles" border="0" onclick="modbusdepenit()"/>';
     $mVEHICULOT = array('tabla' => 'r_v_vehiculo', 'columnas' => array('id' => 'Ref.', 'placa' => 'Placa', 'marca' => 'Marca', 'modelo' => 'Modelo', 'color' => 'Color', 'tipo' => 'Tipo', 'clase' => 'Clase'), 'filtro' => array('id' => 'Ref.', 'placa' => 'Placa', 'marca' => 'Marca', 'modelo' => 'Modelo', 'color' => 'Color', 'tipo' => 'Tipo', 'clase' => 'Clase'), 'retornar' => array('id' => 'id_vehiculo'), 'p_uri' => array(4 => '<#id_contribu#>'), 'where' => 'id_contribu = <#id_contribu#>', 'script' => array('post_vehiculot()'), 'titulo' => 'Buscar Vehiculos');
     $bVEHICULOT = $this->datasis->modbus($mVEHICULOT, 'r_v_vehiculot', 800, 600, 'r_v_vehiculot');
     $bVEHICULOT = '<img id="modbusvt" src="/tortuga/assets/default/images/system-search.png"  alt="Busqueda de Vehiculos" title="Busqueda de Vehiculos" border="0" onclick="modbusdepenvt()"/>';
     $contribu = array();
     $contribu['id'] = '';
     $contribu['nombre'] = '';
     $contribu['rifci'] = '';
     if ($id_contribu > 0) {
         $contribu = $this->datasis->damerow("SELECT id,rifci,nombre FROM r_contribu WHERE id={$id_contribu}");
     }
     $do = new DataObject("r_cxc");
     $do->rel_one_to_many('r_cxcit', 'r_cxcit', array('id' => 'id_cxc'));
     $do->order_by('r_cxcit', "ano", 'asc');
     $do->order_by('r_cxcit', "freval", 'asc');
     $edit = new DataDetails($this->t**s, $do);
     $edit->back_url = site_url($this->url . "filteredgrid");
     $edit->pre_process('insert', '_valida');
     $edit->pre_process('update', '_valida');
     $edit->post_process('insert', '_post_insert');
     $edit->post_process('update', '_post_update');
     $edit->post_process('delete', '_post_delete');
     $edit->id = new inputField('Ref', 'id');
     $edit->id->rule = 'max_length[11]';
     $edit->id->size = 2;
     $edit->id->maxlength = 11;
     $edit->id->mode = 'autohide';
     $edit->id->when = array('show', 'modify');
     $edit->id_contribu = new inputField('Contribuyente', 'id_contribu');
     $edit->id_contribu->rule = 'required';
     $edit->id_contribu->size = 5;
     $edit->id_contribu->maxlength = 11;
     $edit->id_contribu->append($button);
     $edit->id_contribu->readonly = true;
     $edit->id_contribu->value = $contribu['id'];
     $crea = '<a href="javascript:creacontribu();" title="Agregar Contribuyente">' . image('add.png', '#', array("border" => 0)) . '</a>';
     $edit->rifci = new inputField('rifci', 'rifci');
     $edit->rifci->rule = 'max_length[12]';
     $edit->rifci->size = 14;
     $edit->rifci->maxlength = 12;
     $edit->rifci->append($crea);
     $edit->rifci->autocomplete = false;
     $edit->rifci->value = $contribu['rifci'];
     $edit->nombre = new inputField('nombre', 'nombre');
     $edit->nombre->rule = 'max_length[100]';
     $edit->nombre->size = 40;
     $edit->nombre->maxlength = 100;
     $edit->nombre->value = $contribu['nombre'];
     $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');
     $user = $this->session->userdata('usuario');
     $usere = $this->db->escape($user);
     $numero = $this->datasis->dameval("SELECT r_contador.proxnumero FROM r_contador JOIN r_caja ON r_contador.id=r_caja.id_contador JOIN  usuario ON r_caja.id=usuario.caja WHERE us_codigo ={$usere}");
     $edit->numero = new inputField('Numero', 'numero');
     $edit->numero->rule = 'trim|numeric';
     $edit->numero->size = 10;
     $edit->numero->maxlength = 8;
     $edit->numero->append("Proximo:" . $numero);
     //$edit->numero->type="inputhidden";
     //$edit->numero->when=array('show','modify');
     $edit->numero->css_class = 'inputnum';
     $edit->numero->readonly = true;
     $edit->monto = new inputField('Monto', 'monto');
     $edit->monto->readonly = true;
     $edit->monto->size = 5;
     $edit->monto->css_class = "inputnum";
     $edit->solvencia = new inputField('Solvencia', 'solvencia');
     $edit->solvencia->mode = 'autohide';
     $edit->solvencia->size = 5;
     $edit->solvencia->when = array('show', 'modify');
     $edit->id_inmueble = new hiddenField('id_inmueble', 'id_inmueble');
     $edit->id_inmueble->rule = 'max_length[11]';
     $edit->id_inmueble->size = 6;
     $edit->id_inmueble->maxlength = 11;
     $edit->id_inmueble->db_name = ' ';
     $edit->id_inmueble->append($bINMUEBLET);
     $edit->id_vehiculo = new hiddenField('id_vehiculo', 'id_vehiculo');
     $edit->id_vehiculo->rule = 'max_length[11]';
     $edit->id_vehiculo->size = 6;
     $edit->id_vehiculo->maxlength = 11;
     $edit->id_vehiculo->db_name = ' ';
     $edit->id_vehiculo->append($bVEHICULOT);
     /*
      * DETALLE
      * 
      * */
     $edit->itid = new inputField("(<#o#>) Referencia", 'id_<#i#>');
     $edit->itid->db_name = 'id';
     $edit->itid->rel_id = 'r_cxcit';
     //$edit->itid->when     =array('show');
     $edit->itid->readonly = true;
     $edit->itid->size = 1;
     $edit->itid->type = 'hidden';
     $edit->itid_conc = new inputField("(<#o#>) Id Concepto", 'id_conc_<#i#>');
     $edit->itid_conc->db_name = 'id_conc';
     $edit->itid_conc->rel_id = 'r_cxcit';
     $edit->itid_conc->readonly = true;
     $edit->itid_conc->size = 1;
     $edit->itid_conc->type = 'hidden';
     $edit->itid_concit = new inputField('id_concit', 'id_concit_<#i#>');
     $edit->itid_concit->rule = 'max_length[11]';
     $edit->itid_concit->size = 3;
     $edit->itid_concit->maxlength = 11;
     $edit->itid_concit->db_name = 'id_concit';
     $edit->itid_concit->rel_id = 'r_cxcit';
     $edit->itid_concit->append($buttonconc);
     $edit->itid_concit->readonly = true;
     $edit->itrequiere = new hiddenField('requiere', 'requiere_<#i#>');
     $edit->itrequiere->rule = 'max_length[11]';
     $edit->itrequiere->size = 3;
     $edit->itrequiere->maxlength = 11;
     $edit->itrequiere->db_name = 'requiere';
     $edit->itrequiere->rel_id = 'r_cxcit';
     $edit->itmodo = new hiddenField('modo', 'modo_<#i#>');
     $edit->itmodo->rule = 'max_length[11]';
     $edit->itmodo->size = 3;
     $edit->itmodo->maxlength = 11;
     $edit->itmodo->db_name = 'modo';
     $edit->itmodo->rel_id = 'r_cxcit';
     $edit->itdenomi = new inputField('denomi', 'denomi_<#i#>');
     $edit->itdenomi->rule = 'max_length[80]';
     $edit->itdenomi->size = 20;
     $edit->itdenomi->maxlength = 80;
     $edit->itdenomi->db_name = 'denomi';
     $edit->itdenomi->rel_id = 'r_cxcit';
     $edit->itdenomi->autocomplete = false;
     $edit->itano = new inputField('ano', 'ano_<#i#>');
     $edit->itano->rule = 'max_length[11]';
     $edit->itano->size = 5;
     $edit->itano->maxlength = 11;
     $edit->itano->db_name = 'ano';
     $edit->itano->rel_id = 'r_cxcit';
     $edit->itano->type = 'inputhidden';
     $edit->itfrecuencia = new inputField('(<#o#>) frecuencia', 'frecuencia_<#i#>');
     //$edit->itfrecuencia->option('0','');
     //$edit->itfrecuencia->option('1','A&ntilde;o'  );
     //$edit->itfrecuencia->option('2','Semestre'    );
     //$edit->itfrecuencia->option('3','Trimestre'   );
     //$edit->itfrecuencia->option('4','Mes'         );
     $edit->itfrecuencia->style = "width:70px;";
     $edit->itfrecuencia->db_name = 'frecuencia';
     $edit->itfrecuencia->rel_id = 'r_cxcit';
     $edit->itfrecuencia->type = 'inputhidden';
     $edit->itfreval = new inputField('(<#o#>) Valor Frecuencia', 'freval_<#i#>');
     $edit->itfreval->option('0', '');
     for ($i = 1; $i <= 12; $i++) {
         $edit->itfreval->option($i, $i);
     }
     $edit->itfreval->style = "width:50px;";
     $edit->itfreval->db_name = 'freval';
     $edit->itfreval->rel_id = 'r_cxcit';
     $edit->itfreval->type = 'inputhidden';
     $edit->itobserva = new textAreaField('observa', 'observa_<#i#>');
     $edit->itobserva->rule = 'max_length[255]';
     $edit->itobserva->cols = 20;
     $edit->itobserva->rows = 1;
     $edit->itobserva->maxlength = 255;
     $edit->itobserva->db_name = 'observa';
     $edit->itobserva->rel_id = 'r_cxcit';
     $edit->itobserva->style = "height:20px;";
     $edit->itbase = new inputField('Base', 'base_<#i#>');
     $edit->itbase->rule = 'max_length[19]|numeric';
     $edit->itbase->css_class = 'inputnum';
     $edit->itbase->size = 5;
     $edit->itbase->maxlength = 19;
     $edit->itbase->db_name = 'base';
     $edit->itbase->rel_id = 'r_cxcit';
     $edit->itbase->onchange = "cal_base(<#i#>);";
     $edit->itmonto = new inputField('monto', 'monto_<#i#>');
     $edit->itmonto->rule = 'max_length[19]|numeric';
     $edit->itmonto->css_class = 'inputnum';
     $edit->itmonto->size = 5;
     $edit->itmonto->maxlength = 19;
     $edit->itmonto->db_name = 'monto';
     $edit->itmonto->rel_id = 'r_cxcit';
     $edit->itmonto->onchange = "cal_total();";
     $edit->itmonto->readonly = true;
     $crea = '<a id="creav_<#i#>" href="javascript:creavehiculoid(<#i#>);" title="Agregar/modificar Vehiculo">' . image('add.png', '#', array("border" => 0)) . '</a>';
     $edit->itid_vehiculo = new inputField('id_vehiculo', 'id_vehiculo_<#i#>');
     $edit->itid_vehiculo->rule = 'max_length[11]';
     $edit->itid_vehiculo->size = 6;
     $edit->itid_vehiculo->maxlength = 11;
     $edit->itid_vehiculo->db_name = 'id_vehiculo';
     $edit->itid_vehiculo->rel_id = 'r_cxcit';
     $edit->itid_vehiculo->append($bVEHICULO);
     $edit->itid_vehiculo->append($crea);
     $edit->itv_placa = new inputField('v_placa', 'v_placa_<#i#>');
     $edit->itv_placa->rule = 'max_length[12]';
     $edit->itv_placa->size = 8;
     $edit->itv_placa->maxlength = 12;
     $edit->itv_placa->db_name = 'v_placa';
     $edit->itv_placa->rel_id = 'r_cxcit';
     $crea = '<a id="creai_<#i#>" href="javascript:creainmuebleid(<#i#>);" title="Agregar/modificar Inmueble">' . image('add.png', '#', array("border" => 0)) . '</a>';
     $edit->itid_inmueble = new inputField('id_inmueble', 'id_inmueble_<#i#>');
     $edit->itid_inmueble->rule = 'max_length[11]';
     $edit->itid_inmueble->size = 6;
     $edit->itid_inmueble->maxlength = 11;
     $edit->itid_inmueble->db_name = 'id_inmueble';
     $edit->itid_inmueble->rel_id = 'r_cxcit';
     $edit->itid_inmueble->append($bINMUEBLE);
     $edit->itid_inmueble->append($crea);
     $edit->iti_catastro = new inputField('v_placa', 'i_catastro_<#i#>');
     $edit->iti_catastro->rule = 'max_length[12]';
     $edit->iti_catastro->size = 6;
     $edit->iti_catastro->maxlength = 12;
     $edit->iti_catastro->db_name = 'i_catastro';
     $edit->iti_catastro->rel_id = 'r_cxcit';
     $crea = '<a id="creap_<#i#>" href="javascript:creapublicidadid(<#i#>);" title="Agregar/modificar Publicidad">' . image('add.png', '#', array("border" => 0)) . '</a>';
     $edit->itid_publicidad = new inputField('id_publicidad', 'id_publicidad_<#i#>');
     $edit->itid_publicidad->rule = 'max_length[11]';
     $edit->itid_publicidad->size = 3;
     $edit->itid_publicidad->maxlength = 11;
     $edit->itid_publicidad->db_name = 'id_publicidad';
     $edit->itid_publicidad->rel_id = 'r_cxcit';
     $edit->itid_publicidad->append($bPUBLICIDAD);
     $edit->itid_publicidad->append($crea);
     $id = $edit->get_from_dataobjetct('id');
     if ($id > 0) {
         $id_recibo = $this->datasis->dameval("SELECT r_recibo.id\n\t\t\tFROM r_cxc\n\t\t\tJOIN r_cxcit ON r_cxc.id=r_cxcit.id_cxc\n\t\t\tLEFT JOIN r_reciboit ON r_cxcit.id=r_reciboit.id_cxcit\n\t\t\tLEFT JOIN r_recibo ON r_reciboit.id_recibo=r_recibo.id \n\t\t\tLEFT JOIN r_abonosit ON r_recibo.id=r_abonosit.recibo \n\t\t\tLEFT JOIN r_abonos ON r_abonos.id=r_abonosit.abono \n\t\t\tWHERE r_cxc.id={$id} LIMIT 1");
         if ($id_recibo > 0) {
             $action = "javascript:location.href='" . site_url('recaudacion/r_cxc/dataedit/show/' . $id_recibo) . "'";
             $edit->button_status("add_r_recibo", "Ver Recibo {$id}", $action, "TL", "show");
         } else {
             if ($this->datasis->puede(477)) {
                 $edit->buttons('modify', 'save');
             }
             if ($this->datasis->puede(478)) {
                 $edit->buttons('delete');
             }
         }
     }
     //$id_contribu = $edit->get_from_dataobjetct('id_contribu');
     //$action      = "javascript:window.location='" .site_url($this->url.'dataedit/'.$id_contribu.'/create'."'");
     //$edit->button_status("btn_crearsimiliar",'Agregar Similar' ,$action,"TL","show");
     $action = "javascript:analizar()";
     $edit->button_status("btn_statusam", 'Analizar Contribuyente', $action, "TL", "modify");
     $edit->button_status("btn_statusac", 'Analizar Contribuyente', $action, "TL", "create");
     if ($this->datasis->puede(469)) {
         $action = "javascript:window.location='" . site_url($this->url . 'actdeuda/' . "{$id}'");
         $edit->button_status("btn_actdeuda", 'Actualizar Deuda', $action, "TR", "show");
     }
     if ($this->datasis->puede(476)) {
         $edit->buttons('add', 'add_rel');
     }
     if ($this->datasis->puede(488)) {
         $edit->buttons('save');
     }
     $edit->buttons('undo', 'back');
     //$edit->buttons('add_rel','add', 'save', 'undo', 'back');
     $edit->build();
     $smenu['link'] = barra_menu('523');
     $data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
     $conten["form"] =& $edit;
     $data['content'] = $this->load->view('recaudacion/r_cxc', $conten, true);
     $data['title'] = $this->t**s;
     $data["head"] = script('jquery.js') . script('jquery-ui.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js') . script('plugins/jquery.meiomask.js') . style('vino/jquery-ui.css') . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }
Example #15
0
    function dataedit($cliente = '', $status = '', $id = '')
    {
        $this->datasis->modulo_id(143, 1);
        if (!$this->_exitescli($cliente)) {
            redirect($this->url . 'filterscli');
        }
        $this->db->select_sum('a.monto*IF(tipo_doc IN ("FC","ND","GI"),1,-1)', 'saldo');
        $this->db->from('smov AS a');
        $this->db->where('a.cod_cli', $cliente);
        $q = $this->db->get();
        $row = $q->row_array();
        $saldo = empty($row['saldo']) ? 0 : $row['saldo'];
        $this->rapyd->load('dataobject', 'datadetails');
        $this->load->helper('form');
        $vd = $this->secu->getvendedor();
        $dbvd = $this->db->escape($vd);
        $do = new DataObject('pfac');
        $do->rel_one_to_many('itpfac', 'itpfac', array('numero' => 'numa'));
        $do->pointer('scli', 'scli.cliente=pfac.cod_cli', 'scli.tipo AS sclitipo', 'left');
        $do->rel_pointer('itpfac', 'sinv', 'itpfac.codigoa=sinv.codigo', '
			sinv.iva AS sinviva,
			sinv.existen AS pexisten,
			sinv.marca AS pmarca,
			sinv.descrip AS pdesca,
			sinv.peso AS ppeso');
        $do->order_by('itpfac', 'sinv.marca', ' ');
        $do->order_by('itpfac', 'sinv.descrip', ' ');
        $edit = new DataDetails('Pedidos', $do);
        $edit->back_url = site_url('ventas/pfaclite/filteredgrid');
        $edit->set_rel_title('itpfac', 'Producto <#o#>');
        $edit->pre_process('insert', '_pre_insert');
        $edit->pre_process('update', '_pre_update');
        $edit->pre_process('delete', '_pre_delete');
        $edit->post_process('insert', '_post_insert');
        $edit->post_process('update', '_post_update');
        $edit->post_process('delete', '_post_delete');
        $fenvia = strtotime($edit->get_from_dataobjetct('fenvia'));
        $faplica = strtotime($edit->get_from_dataobjetct('faplica'));
        $hoy = strtotime(date('Y-m-d'));
        $edit->fecha = new inputField('Fecha', 'fecha');
        $edit->fecha->insertValue = date('Y-m-d');
        $edit->fecha->mode = 'autohide';
        $edit->fecha->size = 10;
        $edit->mmargen = new inputField('mmargen', 'mmargen');
        $edit->numero = new inputField('N&uacute;mero', 'numero');
        $edit->numero->size = 10;
        $edit->numero->mode = 'autohide';
        $edit->numero->maxlength = 8;
        $edit->numero->apply_rules = false;
        //necesario cuando el campo es clave y no se pide al usuario
        $edit->numero->when = array('show', 'modify');
        $edit->cliente = new hiddenField('Cliente', 'cod_cli');
        $edit->cliente->insertValue = $cliente;
        $edit->cliente->rule = 'required';
        $dbcliente = $this->db->escape($cliente);
        $nombre = $this->datasis->dameval("SELECT nombre FROM scli WHERE cliente={$dbcliente}");
        $edit->nombre = new freeField('Nombre', 'nombre', $nombre);
        $edit->observa = new inputField('Observaciones', 'observa');
        $edit->observa->size = 40;
        // Campos para el detalle
        $edit->codigoa = new inputField('C&oacute;digo <#o#>', 'codigoa_<#i#>');
        $edit->codigoa->size = 12;
        $edit->codigoa->db_name = 'codigoa';
        $edit->codigoa->rel_id = 'itpfac';
        $edit->codigoa->rule = 'callback_chcodigoa';
        $edit->codigoa->type = 'inputhidden';
        $edit->pdesca = new inputField('Descripci&oacute;n <#o#>', 'pdesca_<#i#>');
        $edit->pdesca->size = 32;
        $edit->pdesca->db_name = 'desca';
        $edit->pdesca->maxlength = 50;
        $edit->pdesca->readonly = true;
        $edit->pdesca->rel_id = 'itpfac';
        $edit->pdesca->type = 'inputhidden';
        $edit->pdesca->pointer = true;
        $edit->itdesca = new hiddenField('descrip', 'itdesca_<#i#>');
        $edit->itdesca->insertValue = '';
        $edit->itdesca->db_name = 'desca';
        $edit->itdesca->rel_id = 'itpfac';
        $edit->pexisten = new inputField('Existencia <#o#>', 'pexisten_<#i#>');
        $edit->pexisten->size = 10;
        $edit->pexisten->db_name = 'pexisten';
        $edit->pexisten->rel_id = 'itpfac';
        $edit->pexisten->type = 'inputhidden';
        $edit->pexisten->pointer = true;
        $edit->cana = new inputField('Cantidad <#o#>', 'cana_<#i#>');
        $edit->cana->db_name = 'cana';
        $edit->cana->css_class = 'inputnum';
        $edit->cana->rel_id = 'itpfac';
        $edit->cana->maxlength = 10;
        $edit->cana->size = 4;
        $edit->cana->rule = 'positive|callback_chcana[<#i#>]';
        $edit->cana->autocomplete = false;
        $edit->cana->onkeyup = 'total(\'<#i#>\')';
        $edit->cana->style = "height: 30px; font-size: 18px;";
        $edit->preca = new dropdownField('Precio <#o#>', 'preca_<#i#>');
        $edit->preca->db_name = 'preca';
        $edit->preca->css_class = 'inputnum';
        $edit->preca->rel_id = 'itpfac';
        $edit->preca->rule = 'positive|callback_chpreca[<#i#>]';
        $edit->itiva = new hiddenField('', 'itiva_<#i#>');
        $edit->itiva->db_name = 'iva';
        $edit->itiva->rel_id = 'itpfac';
        $edit->pmarca = new inputField('', 'pmarca_<#i#>');
        $edit->pmarca->db_name = 'pmarca';
        $edit->pmarca->rel_id = 'itpfac';
        $edit->pmarca->pointer = true;
        // fin de campos para detalle
        $edit->totalg = new hiddenField('Monto Total', 'totalg');
        $edit->totalg->css_class = 'inputnum';
        $edit->totalg->readonly = true;
        $edit->totalg->size = 10;
        $edit->iva = new hiddenField('Impuesto', 'iva');
        $edit->iva->css_class = 'inputnum';
        $edit->iva->readonly = true;
        $edit->iva->size = 10;
        $edit->usuario = new autoUpdateField('usuario', $this->session->userdata('usuario'), $this->session->userdata('usuario'));
        $edit->estampa = new autoUpdateField('estampa', date('Ymd'), date('Ymd'));
        $edit->hora = new autoUpdateField('hora', date('H:i:s'), date('H:i:s'));
        $control = $this->rapyd->uri->get_edited_id();
        if ($edit->getstatus() == 'show') {
            $action = "javascript:window.location='" . site_url($this->url . 'filterscli') . "'";
            $edit->button('btn_add', 'Incluir nuevo pedido', $action, 'TR');
        }
        $iusr = $edit->get_from_dataobjetct('usuario');
        if ($fenvia < $hoy && $iusr == $this->secu->usuario()) {
            $edit->buttons('modify', 'save', 'delete', 'undo', 'back', 'add_rel');
            $PFACRESERVA = $this->datasis->traevalor('PFACRESERVA', 'indica si un pedido descuenta de inventario los producto');
            if ($PFACRESERVA == 'S') {
                $accion = "javascript:window.location='" . site_url('ventas/pfaclite/reserva/' . $control) . "/pfaclite'";
                $edit->button_status('btn_envia', 'Enviar Pedido', $accion, 'TR', 'show');
            }
        } else {
            $edit->buttons('save', 'undo', 'back', 'add_rel');
        }
        //$edit->button_status('btn_load','Subir desde Excel',$accion,'TL','show');
        //$edit->button_status('btn_load','Subir desde Excel',$accion,'TL','create');
        //$edit->button_status('btn_load','Subir desde Excel',$accion,'TL','modify');
        $alma = $this->secu->getalmacen();
        $dbalma = $this->db->escape($alma);
        $tiposcli = $this->datasis->dameval("SELECT tipo FROM scli WHERE cliente={$dbcliente}");
        if ($tiposcli < 1) {
            $tiposcli = 1;
        } elseif ($tiposcli > 4) {
            $tiposcli = 4;
        }
        $sel = array('TRIM(a.codigo) AS codigo', 'a.descrip', 'a.precio1', 'a.precio2', 'a.precio3', 'a.precio4', 'a.exdes', 'a.marca', 'b.existen', 'a.iva', 'a.peso');
        $this->db->from('sinv AS a');
        $this->db->where('a.activo', 'S');
        $this->db->where('a.tipo', 'Articulo');
        $this->db->group_by('a.codigo');
        $this->db->order_by('a.marca , a.descrip , a.peso');
        $this->db->limit($this->limit);
        $act_meta = false;
        if ($status == 'create' || $status == 'insert') {
            $this->db->join('itsinv AS b', 'a.codigo=b.codigo AND b.alma=' . $dbalma);
            $this->db->where('b.existen > 0');
            if ($this->db->table_exists('metas')) {
                $pmargen = $this->datasis->dameval('SELECT pmargen FROM vend WHERE vendedor=' . $dbvd);
                if (empty($pmargen)) {
                    $pmargen = 0;
                } else {
                    $pmargen = $pmargen / 100;
                }
                $mmes = date('Ym');
                $uday = days_in_month(substr($mmes, 4), substr($mmes, 0, 4));
                $this->db->join('metas  AS c', 'a.codigo=c.codigo AND c.fecha=' . $mmes, 'left');
                $this->db->join('sitems AS d', 'd.codigoa=c.codigo AND vendedor=' . $dbvd . ' AND d.fecha BETWEEN ' . $mmes . '01 AND ' . $mmes . $uday, 'left');
                $sel[] = "COALESCE(c.cantidad,0)*{$pmargen} AS meta";
                $sel[] = 'COALESCE(SUM(d.cana*IF(tipoa=\'D\',-1,1)),0) AS vendido';
                $act_meta = true;
            }
        } elseif ($status == 'show') {
            $this->db->join('itsinv AS b', 'a.codigo=b.codigo');
        } else {
            $this->db->where('b.existen > 0');
            $this->db->join('itsinv AS b', 'a.codigo=b.codigo AND b.alma=' . $dbalma);
        }
        $this->db->select($sel);
        $sinv = $this->db->get();
        $sinv = $sinv->result_array();
        $sinv_arr = array();
        foreach ($sinv as $k => $v) {
            $sinv_arr[$v['codigo']] = array('descrip' => $v['descrip'], 'precio1' => $v['precio1'] * 100 / (100 + $v['iva']), 'precio2' => $v['precio2'] * 100 / (100 + $v['iva']), 'precio3' => $v['precio3'] * 100 / (100 + $v['iva']), 'precio4' => $v['precio4'] * 100 / (100 + $v['iva']), 'marca' => $v['marca'], 'existen' => $v['existen'], 'iva' => $v['iva'], 'peso' => $v['peso'], 'codigo' => $v['codigo'], 'exdes' => $v['exdes']);
            if ($act_meta) {
                $sinv_arr[$v['codigo']]['meta'] = $v['meta'];
                $sinv_arr[$v['codigo']]['vendido'] = $v['vendido'];
            }
        }
        $pedido = array();
        if ($status == 'create' || $status == 'insert' || $status == 'modify' || $status == 'update') {
            $vds = array();
            $mmSQL = "SELECT TRIM(vendedor) AS vd FROM usuario WHERE almacen={$dbalma}";
            $qquery = $this->db->query($mmSQL);
            foreach ($qquery->result() as $rrow) {
                $vds[] = $this->db->escape($rrow->vd);
            }
            $vds = implode(',', $vds);
            $mmSQL = "SELECT TRIM(a.codigoa) AS codigo,SUM(a.cana) AS cana\n\t\t\t\tFROM itpfac AS a\n\t\t\t\tJOIN pfac AS b ON b.numero=a.numa\n\t\t\tWHERE b.status='P' AND b.vd IN ({$vds})\n\t\t\tGROUP BY a.codigoa";
            $qquery = $this->db->query($mmSQL);
            foreach ($qquery->result() as $rrow) {
                $pedido[$rrow->codigo] = $rrow->cana;
            }
        }
        if ($edit->getstatus() == 'update') {
            $pfacnum = $edit->get_from_dataobjetct('numero');
            $dbpfacnum = $this->db->escape($pfacnum);
            $mmSQL = "SELECT TRIM(a.codigoa) AS codigo,SUM(a.cana) AS cana\n\t\t\t\tFROM itpfac AS a\n\t\t\tWHERE a.numa={$dbpfacnum}\n\t\t\tGROUP BY a.codigoa";
            $qquery = $this->db->query($mmSQL);
            foreach ($qquery->result() as $rrow) {
                $lleva[$rrow->codigo] = floatval($rrow->cana);
            }
        } else {
            $lleva = array();
        }
        if ($this->genesal) {
            $edit->build();
            $conten['lleva'] = $lleva;
            $conten['status'] = $status;
            $conten['pedido'] = $pedido;
            $conten['saldo'] = $saldo;
            $conten['act_meta'] = $act_meta;
            $conten['tiposcli'] = $tiposcli;
            $conten['form'] =& $edit;
            $conten['sinv'] = $sinv_arr;
            $data['content'] = $this->load->view('view_pfaclite', $conten, true);
            $data['head'] = style('mayor/estilo.css');
            //$data['title']     = heading('Pedidos No. '.$edit->numero->value);
            $data['title'] = heading('Pedidos ligeros');
            $this->load->view('view_ventanas_lite', $data);
        } else {
            $edit->on_save_redirect = false;
            $edit->build();
            if ($edit->on_success()) {
                $numero = $edit->_dataobject->get('numero');
                $rt = 'Pedido del cliente ' . $edit->cliente->value . ' - ' . $edit->nombre->value . ' ha sido guardado bajo el n&uacute;mero ' . $numero . '.';
            } elseif ($edit->on_error()) {
                $rt = html_entity_decode(preg_replace('/<[^>]*>/', '', $edit->error_string));
            } else {
                $rt = '';
            }
            return $rt;
        }
    }