function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataedit', 'dataobject');
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov', 'nombre' => 'nombrep'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$pers = array('tabla' => 'pers', 'columnas' => array('codigo' => 'Codigo', 'cedula' => 'Cedula', 'nombre' => 'Nombre', 'apellido' => 'Apellido'), 'filtro' => array('codigo' => 'Código', 'cedula' => 'Cedula'), 'retornar' => array('nombre' => 'solicitante'), 'titulo' => 'Buscar Personal');
$bpers = $this->datasis->modbus($pers);
$script = '
function btn_anulaf(i){
if(!confirm("Esta Seguro que desea Anular la Orden de Pago Directo"))
return false;
else
window.location="' . site_url($this->url . 'anular') . '/"+i
}
$(".inputnum").numeric(".");
';
$do = new DataObject("ocomrapid");
$do->pointer('sprv', 'sprv.proveed = ocomrapid.cod_prov', 'sprv.nombre as nombrep');
$edit = new DataEdit($this->t**s, $do);
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->script($script, "create");
$edit->script($script, "modify");
$edit->script($script, "show");
$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("Nú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->fecha->rule = 'required';
$edit->cod_prov = new inputField("Beneficiario", 'cod_prov');
$edit->cod_prov->size = 6;
$edit->cod_prov->rule = "required";
$edit->cod_prov->append($bSPRV);
//$edit->cod_prov->readonly=true;
$edit->nombrep = new inputField("Nombre", 'nombrep');
$edit->nombrep->size = 50;
$edit->nombrep->readonly = true;
$edit->nombrep->pointer = true;
$edit->nombrep->in = "cod_prov";
$edit->placa = new inputField("Placa", 'placa');
$edit->placa->size = 20;
$edit->solicitante = new inputField("Solicitante", 'solicitante');
$edit->solicitante->size = 40;
//$edit->solicitante->rule = "required";
$edit->solicitante->append($bpers);
//$edit->litros = new inputField("Litros", 'litros');
//$edit->litros->size = 8;
//$edit->litros->css_class='inputnum';
$edit->monto = new inputField("Monto", 'monto');
$edit->monto->size = 8;
$edit->monto->css_class = 'inputnum';
$edit->monto->rule = "required|callback_positivo";
$edit->concepto = new textAreaField("Concepto", 'concepto');
$edit->concepto->cols = 60;
$edit->concepto->rows = 3;
$status = $edit->_dataobject->get("status");
if ($status == 'P') {
$action = "javascript:btn_anulaf('" . $edit->rapyd->uri->get_edited_id() . "')";
$edit->button_status("btn_status", 'Anular', $action, "TR", "show");
$edit->buttons("modify");
}
$edit->buttons("save", "undo", "back", "add");
$edit->build();
$smenu['link'] = barra_menu('102');
$data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
$data['content'] = $edit->output;
$data['title'] = "{$this->t**s}";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
$this->rapyd->set_connection('farmax');
$this->rapyd->load_db();
$this->rapyd->load('dataedit', 'datadetalle', 'fields', 'datagrid');
$this->rapyd->uri->keep_persistence();
function exissinv($cen, $id = 0)
{
if (empty($cen)) {
$id--;
$rt = form_button('create', 'Crear', 'onclick="pcrear(' . $id . ');" title="Crear como nuevo producto"');
$rt .= form_button('asignar', 'Asig.', 'onclick="pasig(' . $id . ');" title="Asociar con un producto ya existente"');
} else {
$attr = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'title' => 'Consultar precio actual', 'screenx' => "'+((screen.availWidth/2)-400)+'", 'screeny' => "'+((screen.availHeight/2)-300)+'");
$llink = anchor_popup('inventario/consultas/preciosgeneral/' . raencode(trim($cen)), $cen, $attr);
$rt = $llink;
}
return $rt;
}
$edit = new DataEdit('Compras', 'scst');
$edit->back_url = 'farmacia/scst/datafilter/';
$edit->fecha = new DateonlyField('Fecha', 'fecha', 'd/m/Y');
$edit->fecha->insertValue = date('Y-m-d');
$edit->fecha->mode = 'autohide';
$edit->fecha->size = 10;
$edit->numero = new inputField('Número', 'numero');
$edit->numero->size = 15;
$edit->numero->rule = 'required';
$edit->numero->mode = 'autohide';
$edit->numero->maxlength = 8;
$edit->proveedor = new inputField('Proveedor', 'proveed');
$edit->proveedor->size = 10;
$edit->proveedor->maxlength = 5;
$edit->nombre = new inputField('Nombre', 'nombre');
$edit->nombre->size = 50;
$edit->nombre->maxlength = 40;
$edit->almacen = new inputField('Almacén', 'depo');
$edit->almacen->size = 15;
$edit->almacen->maxlength = 8;
$edit->tipo = new dropdownField('Tipo', 'tipo_doc');
$edit->tipo->option('FC', 'FC');
$edit->tipo->rule = 'required';
$edit->tipo->size = 20;
$edit->tipo->style = 'width:150px;';
$edit->subt = new inputField('Sub-total', 'montotot');
$edit->subt->size = 20;
$edit->subt->css_class = 'inputnum';
$edit->iva = new inputField('Impuesto', 'montoiva');
$edit->iva->size = 20;
$edit->iva->css_class = 'inputnum';
$edit->total = new inputField('Total global', 'montonet');
$edit->total->size = 20;
$edit->total->css_class = 'inputnum';
$edit->pcontrol = new inputField('Control', 'pcontrol');
$edit->pcontrol->size = 12;
$numero = $edit->_dataobject->get('control');
$proveed = $this->db->escape($edit->_dataobject->get('proveed'));
$atts = array('width' => '250', 'height' => '340', 'scrollbars' => 'no', 'status' => 'no', 'resizable' => 'no', 'title' => 'Cambiar PVP', 'screenx' => "'+((screen.availWidth/2)-175)+'", 'screeny' => "'+((screen.availHeight/2)-175)+'");
$llink = anchor_popup('farmacia/scst/reasignaprecio/modify/<#id#>', '<b><nformat><#precio1#></nformat></b>', $atts);
function similar($st1, $st2, $id)
{
$st1 = trim(strtoupper($st1));
$st2 = trim(strtoupper($st2));
$rt = similar_text($st1, $st2, $por);
if ($por > 65) {
$class = 'bien';
} elseif ($por < 35) {
$class = 'malo';
} else {
$class = 'regu';
}
$atts = array('width' => '550', 'height' => '300', 'scrollbars' => 'no', 'status' => 'no', 'resizable' => 'no', 'class' => $class, 'title' => 'Cambiar Asociación', 'screenx' => "'+((screen.availWidth/2)-275)+'", 'screeny' => "'+((screen.availHeight/2)-150)+'");
$llink = anchor_popup('farmacia/scst/asignardataedit/scst/modify/' . $id, nformat($por) . '%', $atts);
return $llink;
}
//Indica si el producto tiene una oferta
function ofertas($sinv, $margen, $pvp, $ultimo)
{
if (empty($sinv)) {
return '';
}
$CI =& get_instance();
$mSQL = 'SELECT id,margen FROM sinvpromo WHERE codigo=' . $CI->db->escape($sinv);
$query = $CI->db->query($mSQL);
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0', 'title' => 'Agregar oferta');
if ($query->num_rows() > 0) {
$row = $query->row();
$m = $row->margen / 100;
$val = nformat($row->margen) . '%';
$link = anchor_popup('inventario/sinvpromo/dataeditexpress/' . raencode($sinv) . '/show/' . $row->id, $val, $atts);
} else {
$m = $margen / 100;
$val = nformat($margen) . '%';
$link = anchor_popup('inventario/sinvpromo/dataeditexpress/' . raencode($sinv) . '/create/', $val, $atts);
}
$precio = $pvp * (1 - $m);
if ($precio <= floatval($ultimo)) {
$tprecio = '<b style="color:red" title="Precio por debajo del costo" >' . nformat($precio) . '</b>';
} else {
$tprecio = nformat($precio);
}
return $tprecio . ' ' . $link;
}
//Campos para el detalle
$this->_autoasignar($numero);
$this->_autoprecios($numero);
$tabla = $this->db->database;
$detalle = new DataGrid('');
$detalle->use_function('similar', 'ofertas');
$select = array('a.*', 'a.codigo AS barras', 'COALESCE(b.descrip, d.descrip) AS sinvdesc', 'a.costo AS pond', 'COALESCE( b.codigo , c.abarras) AS sinv', 'c.id AS farmaid', 'e.margen');
$detalle->db->select($select);
$detalle->db->from('itscst AS a');
$detalle->db->where('a.control', $numero);
$detalle->db->join($tabla . '.sinv AS b', 'a.codigo=b.codigo', 'LEFT');
$detalle->db->join($tabla . '.farmaxasig AS c', "a.codigo=c.barras AND c.proveed={$proveed}", 'LEFT');
$detalle->db->join($tabla . '.sinv AS d', 'd.codigo=c.abarras', 'LEFT');
$detalle->db->join($tabla . '.grup AS e', 'e.grupo=COALESCE(b.grupo,d.grupo)', 'LEFT');
$detalle->db->order_by('a.id');
$detalle->use_function('exissinv');
$detalle->column('Barras', '<#codigo#>');
$detalle->column('Semejanza% -Descripción', '<similar><#descrip#>|<#sinvdesc#>|<#farmaid#></similar> - <#descrip#>');
$detalle->column('Cantidad', '<nformat><#cantidad#></nformat>', 'align=\'right\'');
$detalle->column('PVP', $llink, 'align=\'right\'');
$detalle->column('Costo', '<nformat><#ultimo#></nformat>', 'align=\'right\'');
$detalle->column('Importe', '<nformat><#importe#></nformat>', 'align=\'right\'');
$detalle->column('Código local', '<exissinv><#sinv#>|<#dg_row_id#></exissinv>', "bgcolor='#D7F7D7' align='center'");
$detalle->column('Desc.', '<ofertas><#sinv#>|<#margen#>|<#precio1#>|<#ultimo#></ofertas>', 'align=\'right\'');
$detalle->build();
//echo $detalle->db->last_query();
$c_articulos = $detalle->recordCount;
$query = $this->rapyd->db->query('SELECT SUM(a.cantidad) AS cant FROM itscst AS a WHERE a.control=' . $this->db->escape($numero));
if ($query->num_rows() > 0) {
$row = $query->row_array();
$unid = $row['cant'];
} else {
$unid = 0;
}
$edit->unidades = new freeField('Unidades', 'unidades', nformat($unid));
$script = '
function pcrear(id){
var pasar=["barras","descrip","ultimo","iva","codigo","pond","precio1","precio2","precio3","precio4"];
var url = "' . site_url('farmacia/sinv/dataedit/create') . '";
form_virtual(pasar,id,url);
}
function pasig(id){
var pasar=["barras","proveed","descrip"];
var url = "' . site_url('farmacia/scst/asignardataedit/scst/create') . '";
form_virtual(pasar,id,url);
}
function form_virtual(pasar,id,url){
var data=' . json_encode($detalle->data) . ';
var w = window.open("' . site_url('farmacia/scst/dummy') . '","asignar","width=800,height=600,scrollbars=Yes,status=Yes,resizable=Yes,screenx="+((screen.availWidth/2)-400)+",screeny="+((screen.availHeight/2)-300)+"");
var fform = document.createElement("form");
fform.setAttribute("target", "asignar");
fform.setAttribute("action", url );
fform.setAttribute("method", "post");
for(i=0;i<pasar.length;i++){
Val=eval("data[id]."+pasar[i]);
iinput = document.createElement("input");
iinput.setAttribute("type", "hidden");
iinput.setAttribute("name", pasar[i]);
iinput.setAttribute("value", Val);
fform.appendChild(iinput);
}
var cuerpo = document.getElementsByTagName("body")[0];
cuerpo.appendChild(fform);
fform.submit();
w.focus();
cuerpo.removeChild(fform);
}';
$edit->detalle = new freeField('detalle', 'detalle', $detalle->output);
$accion = "javascript:window.location='" . site_url('farmacia/scst/cargar' . $edit->pk_URI()) . "'";
$pcontrol = $edit->_dataobject->get('pcontrol');
if ($this->_btn_cargar($pcontrol)) {
$edit->button_status('btn_cargar', 'Cargar', $accion, 'TR', 'show');
}
$edit->buttons('save', 'undo', 'back');
$edit->script($script, 'show');
$edit->build();
$this->rapyd->jquery[] = '$("#dialog").dialog({
autoOpen: false,
show: "blind",
hide: "explode"
});
$( "#opener" ).click(function() {
$( "#dialog" ).dialog( "open" );
return false;
});';
$conten['form'] =& $edit;
$conten['carti'] = $c_articulos;
$data['content'] = $this->load->view('view_farmax_compras', $conten, true);
$data['head'] = $this->rapyd->get_head();
$data['title'] = '<h1>Compras Descargadas</h1>';
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
$this->rapyd->load("dataedit");
$script = '
$(function() {
$(".inputnum").numeric(".");
});
';
$edit = new DataEdit("Relacion de Cheques", "relch");
$edit->back_url = site_url("tesoreria/relch/filteredgrid");
$edit->script($script, "create");
$edit->script($script, "modify");
$edit->post_process('insert', '_post_insert');
$edit->post_process('update', '_post_update');
$edit->post_process('delete', '_post_delete');
$edit->id = new inputField("Id", "id");
$edit->id->mode = "autohide";
$edit->id->when = array('show');
$edit->id->size = 5;
$edit->numero = new inputField("Numero", "numero");
//$edit->numero->mode='autohide';
$edit->usuario = new inputField("Usuario", "usuario");
$edit->usuario->mode = 'autohide';
$edit->fecha = new dateonlyField("Fecha", 'fecha');
//$edit->fecha->mode='autohide';
$edit->destino = new dropdownField('Destino', 'destino');
$edit->destino->mode = 'autohide';
$edit->destino->option('C', 'Caja');
$edit->destino->option('I', 'Interno');
$edit->status = new inputField("Estado", 'status');
$edit->status->mode = 'autohide';
$edit->fondo = new dropdownField("Clasificacion", "fondo");
$edit->fondo->style = "width:300px;";
$edit->fondo->option("", "");
$edit->fondo->options("SELECT fondo,fondo a FROM banc GROUP BY fondo UNION ALL SELECT CONCAT('REPO.',fondo),CONCAT('REPO.',fondo) a FROM banc GROUP BY fondo");
$status = $edit->_dataobject->get('status');
if ($status == 'P') {
$action = "javascript:window.location='" . site_url($this->url . '/busca/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_anular", 'Modificar Cheques', $action, "TR", "show");
$action = "javascript:window.location='" . site_url($this->url . '/actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_anular", 'Cerrar Relacion', $action, "TR", "show");
} elseif ($status == 'C') {
$action = "javascript:window.location='" . site_url($this->url . '/anular/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_rever", 'Anular', $action, "TR", "show");
} else {
//$edit->buttons("save");
}
$edit->buttons("modify", "save");
$edit->buttons("undo", "back");
$edit->build();
$data['content'] = $edit->output;
$data['title'] = "Relacion de Ordenes Pagadas";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataedit');
$mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'retornar' => array('codbanc' => 'codbanc', 'banco' => 'nombreb'), 'where' => 'activo="S"', 'titulo' => 'Buscar Bancos');
$bBANC = $this->datasis->p_modbus($mBANC, "banc");
$script = '
$(".inputnum").numeric(".");
';
$edit = new DataEdit($this->t**s, "pmov");
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->script($script, "create");
$edit->script($script, "modify");
//$edit->pre_process('insert' ,'_valida');
//$edit->pre_process('update' ,'_valida');
$edit->numero = new inputField("Número", "numero");
$edit->numero->mode = "autohide";
$edit->numero->when = array('show');
$edit->orden = new inputField("Orden de Pago", "orden");
$edit->orden->size = 10;
$edit->orden->maxlength = 12;
//$edit->orden->mode = "autohide";
//$edit->orden->when = array('show');
$edit->bancemi = new dropdownField("Banco Emisor", "bancemi");
$edit->bancemi->option("", "Seccionar");
$edit->bancemi->options("SELECT cod_banc, CONCAT_WS(' ',cod_banc,nomb_banc) FROM tban ORDER BY cod_banc");
$edit->bancemi->group = "Cheque";
$edit->cheque = new inputField("Cheque Nº", 'cheque');
$edit->cheque->size = 30;
$edit->cheque->maxlength = 30;
$edit->cheque->group = "Cheque";
$edit->fecha1 = new dateonlyField("Fecha Cheque", "fecha1");
$edit->fecha1->insertValue = date('Y-m-d');
$edit->fecha1->size = 12;
$edit->fecha1->group = "Cheque";
//$edit->fecha1->rule = "required";
$edit->monto = new inputField("Monto", 'monto');
$edit->monto->size = 20;
$edit->monto->css_class = 'inputnum';
$edit->monto->rule = 'required|callback_positivo';
//$edit->monto->group = "Cheque";
$edit->deposito = new inputField("Deposito Nº*", 'deposito');
$edit->deposito->size = 30;
$edit->deposito->maxlength = 30;
$edit->deposito->group = "Deposito";
$edit->fecha2 = new dateonlyField("Fecha Deposito*", "fecha2");
$edit->fecha2->insertValue = date('Y-m-d');
$edit->fecha2->size = 12;
//$edit->fecha2->rule = "required";
$edit->fecha2->group = "Deposito";
$edit->codbanc = new inputField("Banco*", 'codbanc');
$edit->codbanc->size = 6;
//$edit->codbanc->rule = "required";
$edit->codbanc->append($bBANC);
$edit->codbanc->readonly = true;
$edit->codbanc->group = "Deposito";
$edit->nombreb = new inputField("", 'nombreb');
$edit->nombreb->db_name = 'nombreb';
$edit->nombreb->size = 30;
$edit->nombreb->group = "Deposito";
$edit->nombreb->in = "codbanc";
$status = $edit->_dataobject->get("status");
if ($status == 'P') {
$action = "javascript:window.location='" . site_url($this->url . '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($this->url . 'reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_rever", 'Reversar', $action, "TR", "show");
} else {
$edit->buttons("save");
}
$edit->buttons("undo", "back");
$edit->build();
$data['content'] = $edit->output;
$data['title'] = " {$this->t**s} ";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataobject', 'dataedit');
$do = new dataObject("ocompra");
$edit = new DataEdit($this->t**s, $do);
$do->set('fechapago', date('Y-m-d'));
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->pre_process('update', '_valida');
$edit->post_process('update', '_post');
$edit->odirect = new inputField("Numero O. Pago", "odirect");
$edit->odirect->mode = "autohide";
$edit->odirect->group = "Pago";
$edit->fechapago = new dateonlyField("Fecha de Pago", "fechapago");
$edit->fechapago->size = 12;
$edit->fechapago->rule = "required";
$edit->fechapago->group = "Pago";
$edit->factura = new inputField("Factura", "factura");
$edit->factura->mode = "autohide";
$edit->factura->group = "Causación";
$edit->controlfac = new inputField("Control Fiscal", "controlfac");
$edit->controlfac->mode = "autohide";
$edit->controlfac->group = "Causación";
$edit->fechafac = new inputField("Fecha Causación", "fechafac");
$edit->fechafac->mode = "autohide";
$edit->fechafac->group = "Causación";
$edit->numero = new inputField("Número O. Compra", "numero");
$edit->numero->mode = "autohide";
$edit->numero->when = array('show');
$edit->numero->group = "Orden De Compra";
$edit->tipo = new inputField("Orden de", "tipo");
$edit->tipo->mode = "autohide";
$edit->tipo->group = "Orden De Compra";
$edit->fecha = new inputField("Fecha O. Compra", "fecha");
$edit->fecha->mode = "autohide";
$edit->fecha->group = "Orden De Compra";
$grupo = 'Datos';
$edit->uejecutora = new inputField("Unidad Ejecutora", "uejecutora");
$edit->uejecutora->mode = "autohide";
$edit->uejecutora->group = $grupo;
$edit->estadmin = new dropdownField("Estructura Administrativa", "estadmin");
$edit->estadmin->mode = "autohide";
$edit->estadmin->group = $grupo;
$edit->fondo = new dropdownField("Fondo", "fondo");
$edit->fondo->mode = "autohide";
$edit->fondo->group = $grupo;
$edit->cod_prov = new inputField("Beneficiario", 'cod_prov');
$edit->cod_prov->size = 6;
$edit->cod_prov->group = $grupo;
$edit->cod_prov->mode = "autohide";
$edit->nombre = new inputField("Nombre Beneficiario", 'nombre');
$edit->nombre->size = 50;
$edit->nombre->group = $grupo;
$edit->nombre->mode = "autohide";
$edit->beneficiario = new inputField("Beneficiario", 'beneficiario');
$edit->beneficiario->size = 50;
$edit->beneficiario->mode = "autohide";
$edit->beneficiario->group = $grupo;
//$edit->beneficiario->rule = "required";
$edit->observa = new textAreaField("Observaciones", 'observa');
$edit->observa->mode = "autohide";
$edit->observa->group = $grupo;
$edit->reteiva_prov = new inputField("Retencion IVA Beneficiario", "reteiva_prov");
$edit->reteiva_prov->mode = "autohide";
$edit->reteiva_prov->group = "Retención Iva";
$edit->reteiva = new inputField("Retencion de IVA", 'reteiva');
$edit->reteiva->size = 8;
$edit->reteiva->mode = "autohide";
$edit->reteiva->group = "Retención Iva";
$edit->creten = new inputField("Codigo ISLR", "creten");
$edit->creten->mode = "autohide";
$edit->creten->group = "Impuesto Sobre la Renta";
$edit->reten = new inputField("Retencion de ISLR", 'reten');
$edit->reten->size = 8;
$edit->reten->mode = "autohide";
$edit->reten->group = "Impuesto Sobre la Renta";
$gtotal = "Montos Totales";
$edit->subtotal = new inputField("Sub Total", 'subtotal');
$edit->subtotal->size = 8;
$edit->subtotal->mode = "autohide";
$edit->subtotal->group = $gtotal;
$edit->ivaa = new inputField("IVA Sobre Tasa", 'ivaa');
$edit->ivaa->size = 8;
$edit->ivaa->mode = "autohide";
$edit->ivaa->group = $gtotal;
$edit->ivag = new inputField("IVA Tasa General", 'ivag');
$edit->ivag->size = 8;
$edit->ivag->mode = "autohide";
$edit->ivag->group = $gtotal;
$edit->ivar = new inputField("IVA Tasa reducida", 'ivar');
$edit->ivar->size = 8;
$edit->ivar->mode = "autohide";
$edit->ivar->group = $gtotal;
$edit->exento = new inputField("Exento", 'exento');
$edit->exento->size = 8;
$edit->exento->mode = "autohide";
$edit->exento->group = $gtotal;
$edit->total = new inputField("Total", 'total');
$edit->total->size = 8;
$edit->total->mode = "autohide";
$edit->total->group = $gtotal;
$n = $edit->_dataobject->get('numero');
$status = $edit->_dataobject->get("status");
if ($status == 'T') {
//$action = "javascript:window.location='" .site_url($this->url.'actualizar/'.$edit->rapyd->uri->get_edited_id()). "'";
//$action = "javascript:window.location='" .site_url($this->url.'actualizar/'.$n)."'";
//$edit->button_status("btn_status",'Ordenar Pago',$action,"TR","show");
$edit->buttons("modify", "save");
} elseif ($status == 'O') {
$action = "javascript:window.location='" . site_url($this->url . 'reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
//$action = "javascript:window.location='" .site_url($this->url.'reversar/'.$n). "'";
$edit->button_status("btn_rever", 'Deshacer Ordenar Pago', $action, "TR", "show");
} else {
$edit->buttons("save");
}
$edit->buttons("undo", "back");
$edit->build();
$data['content'] = $edit->output;
$data['title'] = " {$this->t**s} ";
//$data['content'] = $edit->output;
//$data['title'] = " $this->t**s ";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
$this->rapyd->set_connection('farmax');
$this->rapyd->load_db();
$this->rapyd->load("dataedit", "datadetalle", "fields", "datagrid");
$this->rapyd->uri->keep_persistence();
$uri = site_url("/contabilidad/casi/dpto/");
function exissinv($cen, $id = 0)
{
if (empty($cen)) {
$id--;
$rt = form_button('create', 'Crear', 'onclick="pcrear(' . $id . ');"');
$rt .= form_button('asignar', 'Asig.', 'onclick="pasig(' . $id . ');"');
} else {
$rt = '--';
}
return $rt;
}
$edit = new DataEdit("Compras", "scst");
$edit->back_url = "farmacia/scst/datafilter/";
$edit->fecha = new DateonlyField("Fecha", "fecha", "d/m/Y");
$edit->fecha->insertValue = date("Y-m-d");
$edit->fecha->mode = "autohide";
$edit->fecha->size = 10;
$edit->vence = new DateonlyField("Vence", "vence", "d/m/Y");
$edit->vence->insertValue = date("Y-m-d");
$edit->vence->size = 10;
$edit->numero = new inputField("Número", "numero");
$edit->numero->size = 15;
$edit->numero->rule = "required";
$edit->numero->mode = "autohide";
$edit->numero->maxlength = 8;
$edit->proveedor = new inputField("Proveedor", "proveed");
$edit->proveedor->size = 10;
$edit->proveedor->maxlength = 5;
$edit->nombre = new inputField("Nombre", "nombre");
$edit->nombre->size = 50;
$edit->nombre->maxlength = 40;
$edit->cfis = new inputField("C.fis", "nfiscal");
$edit->cfis->size = 15;
$edit->cfis->maxlength = 8;
$edit->almacen = new inputField("Almacen", "depo");
$edit->almacen->size = 15;
$edit->almacen->maxlength = 8;
$edit->tipo = new dropdownField("Tipo", "tipo_doc");
$edit->tipo->option("FC", "FC");
$edit->tipo->option("NC", "NC");
$edit->tipo->option("NE", "NE");
$edit->tipo->rule = "required";
$edit->tipo->size = 20;
$edit->tipo->style = 'width:150px;';
$edit->peso = new inputField2("Peso", "peso");
$edit->peso->size = 20;
$edit->peso->css_class = 'inputnum';
$edit->orden = new inputField("Orden", "orden");
$edit->orden->size = 15;
$edit->credito = new inputField("Crédito", "credito");
$edit->credito->size = 20;
$edit->credito->css_class = 'inputnum';
$edit->subt = new inputField("Subt", "montotot");
$edit->subt->size = 20;
$edit->subt->css_class = 'inputnum';
$edit->iva = new inputField("IVA", "montoiva");
$edit->iva->size = 20;
$edit->iva->css_class = 'inputnum';
$edit->total = new inputField("Total", "montonet");
$edit->total->size = 20;
$edit->total->css_class = 'inputnum';
$edit->anticipo = new inputField("Anticipo", "anticipo");
$edit->anticipo->size = 20;
$edit->anticipo->css_class = 'inputnum';
$edit->contado = new inputField("Contado", "inicial");
$edit->contado->size = 20;
$edit->contado->css_class = 'inputnum';
$edit->rislr = new inputField("R.ISLR", "reten");
$edit->rislr->size = 20;
$edit->rislr->css_class = 'inputnum';
$edit->riva = new inputField("R.IVA", "reteiva");
$edit->riva->size = 20;
$edit->riva->css_class = 'inputnum';
$edit->pcontrol = new inputField('Control', 'pcontrol');
$edit->pcontrol->size = 12;
$edit->monto = new inputField("Monto US \$", "mdolar");
$edit->monto->size = 20;
$edit->monto->css_class = 'inputnum';
$numero = $edit->_dataobject->get('control');
$proveed = $this->db->escape($edit->_dataobject->get('proveed'));
//Campos para el detalle
$tabla = $this->db->database;
$detalle = new DataGrid('');
$select = array('a.*', 'a.codigo AS barras', 'a.costo AS pond', 'COALESCE( b.codigo , c.abarras) AS sinv');
$detalle->db->select($select);
$detalle->db->from('itscst AS a');
$detalle->db->where('a.control', $numero);
$detalle->db->join($tabla . '.sinv AS b', 'a.codigo=b.codigo', 'LEFT');
$detalle->db->join($tabla . '.farmaxasig AS c', "a.codigo=c.barras AND c.proveed={$proveed}", 'LEFT');
$detalle->use_function('exissinv');
$detalle->column("Barras", "<#codigo#>");
$detalle->column("Descripción", "<#descrip#>");
$detalle->column("Cantidad", "<#cantidad#>", "align='right'");
$detalle->column("Precio", "<#ultimo#>", "align='right'");
$detalle->column("Importe", "<#importe#>", "align='right'");
$detalle->column("Acciones ", "<exissinv><#sinv#>|<#dg_row_id#></exissinv>", "bgcolor='#D7F7D7' align='center'");
$detalle->build();
//echo $detalle->db->last_query();
$script = '
function pcrear(id){
var pasar=["barras","descrip","ultimo","iva","codigo","pond"];
var url = "' . site_url('inventario/sinv/dataedit/create') . '";
form_virtual(pasar,id,url);
}
function pasig(id){
var pasar=["barras","proveed"];
var url = "' . site_url('farmacia/scst/asignardataedit/create') . '";
form_virtual(pasar,id,url);
}
function form_virtual(pasar,id,url){
var data=' . json_encode($detalle->data) . ';
var w = window.open("' . site_url('farmacia/scst/dummy') . '","asignar","width=800,height=600,scrollbars=Yes,status=Yes,resizable=Yes,screenx="+((screen.availWidth/2)-400)+",screeny="+((screen.availHeight/2)-300)+"");
var fform = document.createElement("form");
fform.setAttribute("target", "asignar");
fform.setAttribute("action", url );
fform.setAttribute("method", "post");
for(i=0;i<pasar.length;i++){
Val=eval("data[id]."+pasar[i]);
iinput = document.createElement("input");
iinput.setAttribute("type", "hidden");
iinput.setAttribute("name", pasar[i]);
iinput.setAttribute("value", Val);
fform.appendChild(iinput);
}
var cuerpo = document.getElementsByTagName("body")[0];
cuerpo.appendChild(fform);
fform.submit();
w.focus();
cuerpo.removeChild(fform);
}';
$edit->detalle = new freeField("detalle", 'detalle', $detalle->output);
$accion = "javascript:window.location='" . site_url('farmacia/scst/cargar' . $edit->pk_URI()) . "'";
$pcontrol = $edit->_dataobject->get('pcontrol');
if (is_null($pcontrol)) {
$edit->button_status('btn_cargar', 'Cargar', $accion, 'TR', 'show');
}
$edit->buttons('save', 'undo', 'back');
$edit->script($script, 'show');
$edit->build();
$smenu['link'] = barra_menu('201');
$data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
$conten['form'] =& $edit;
$data['content'] = $this->load->view('view_farmax_compras', $conten, true);
$data['head'] = script("tabber.js") . script("prototype.js") . $this->rapyd->get_head() . script("scriptaculous.js") . script("effects.js");
$data['title'] = '<h1>Compras Descargadas</h1>';
$this->load->view('view_ventanas', $data);
}
function dataedit($duplicar = 'S', $status = '', $numero = '')
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataedit', 'dataobject');
$where = 'activo = "S"';
$mf = $this->datasis->puede(333);
$mo = $this->datasis->puede(334);
if ($mf && $mo) {
} elseif ($mf) {
$where .= ' AND tipocta="F"';
} elseif ($mo) {
$where .= ' AND tipocta<>"F"';
}
$mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => 'codbanc', 'banco' => 'nombreb'), 'where' => $where, 'titulo' => 'Buscar Bancos');
$bBANC = $this->datasis->p_modbus($mBANC, "banc");
$script = '
$(".inputnum").numeric(".");
$(document).ready(function() {
$("#tr_nombret").hide();
});
function copiabenefi(){
benefi = $("#nombrep").val();
nombret= $("#nombret").val();
if(nombret==""){
$("#benefi").val(benefi);
}else{
$("#benefi").val(nombret);
}
}
';
$mBCTA = array('tabla' => 'bcta', 'columnas' => array('codigo' => 'Cóodigo', 'denominacion' => 'Denominacion', 'cuenta' => 'Cuenta'), 'filtro' => array('codigo' => 'Cóodigo', 'denominacion' => 'Denominacion', 'cuenta' => 'Cuenta'), 'retornar' => array('codigo' => 'bcta'), 'titulo' => 'Buscar Otros Ingresos');
$bBCTA = $this->datasis->p_modbus($mBCTA, "bcta");
$do = new DataObject("mbancnoc");
$do->pointer('banc', 'banc.codbanc=mbancnoc.codbanc', 'banc.banco as nombreb', 'LEFT');
if ($status == "create" && !empty($numero) && $duplicar == 'S') {
$do->load($numero);
$do->set('cheque', '');
$do->set('id', '');
$do->set('monto', '');
$do->pk = array('id' => '');
}
$edit = new DataEdit($this->t**s, $do);
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->script($script, "create");
$edit->script($script, "modify");
$edit->post_process('insert', '_post_insert');
$edit->post_process('update', '_post_update');
$edit->post_process('delete', '_post_delete');
$tipo = $edit->_dataobject->get('tipo');
$edit->id = new inputField("Número", "id");
$edit->id->mode = "autohide";
$edit->id->when = array('show');
//$edit->fechapago = new dateonlyField("Fecha Movimiento", "fechapago");
//$edit->fechapago->insertValue = date('Y-m-d');
//$edit->fechapago->size =12;
//$edit->fechapago->rule = 'required';
$edit->nombret = new inputField("nombre temporal", 'nombret');
$edit->nombret->size = 50;
$edit->nombret->db_name = ' ';
$edit->nombret->when = array("create", "modify");
$edit->codbanc = new inputField("Banco", 'codbanc');
$edit->codbanc->size = 3;
$edit->codbanc->rule = "required";
$edit->codbanc->append($bBANC);
//$edit->codbanc-> readonly=true;
$edit->codbanc->group = "Transaccion";
$edit->nombreb = new inputField("Nombre", "nombreb");
$edit->nombreb->size = 50;
$edit->nombreb->readonly = true;
$edit->nombreb->pointer = true;
$edit->nombreb->in = "codbanc";
$edit->nombreb->group = "Transaccion";
$edit->tipo_doc = new dropdownField("Tipo Documento", "tipo_doc");
$edit->tipo_doc->option("NC", "Nota de Credito");
$edit->tipo_doc->option("ND", "Nota de Debito");
$edit->tipo_doc->option("DP", "Deposito");
$edit->tipo_doc->style = "width:180px";
$edit->tipo_doc->group = "Transaccion";
$edit->tipo_doc->rule = 'required';
$edit->fecha = new dateonlyField("Fecha Transacción", "fecha");
//$edit->fecha->insertValue = date('Y-m-d');
$edit->fecha->size = 12;
$edit->fecha->rule = 'required';
$edit->fecha->group = "Transaccion";
$edit->cheque = new inputField("Nro. Transacción", 'cheque');
$edit->cheque->rows = 2;
$edit->cheque->cols = 80;
$edit->cheque->rule = "required";
//callback_chexiste_cheque|
$edit->cheque->group = "Transaccion";
$edit->monto = new inputField("Monto", 'monto');
$edit->monto->size = 20;
$edit->monto->group = "Transaccion";
$edit->monto->css_class = 'inputnum';
$edit->monto->rule = 'callback_positivo';
if ($tipo == 'I') {
$edit->monto->mode = "autohide";
}
//$edit->benefi = new inputField("A nombre de", 'benefi');
//$edit->benefi-> size = 100;
//$edit->benefi->rule = "required";
//$edit->benefi->group = "Transaccion";
$edit->observa = new textAreaField("Concepto", 'observa');
$edit->observa->cols = 80;
$edit->observa->rows = 5;
$edit->observa->group = "Transaccion";
$edit->bcta = new inputField("Motivo Movimiento", 'bcta');
$edit->bcta->size = 6;
$edit->bcta->append($bBCTA);
$edit->bcta->readonly = true;
$edit->bcta->group = "Otros";
$edit->fecha2 = new dateonlyField("Fecha Aux", "fecha2");
$edit->fecha2->group = "Otros";
$action = "javascript:window.location='" . site_url($this->url . '/dataedit/S/create/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_anular", 'Duplicar', $action, "TL", "show");
$action = "javascript:window.location='" . site_url($this->url . '/dataedit/S/create/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_anularm", 'Duplicar', $action, "TL", "modify");
$edit->buttons("undo", "back", "add", "modify", "save", "delete");
$edit->build();
//$smenu['link'] = barra_menu('204');
//$data['smenu'] = $this->load->view('view_sub_menu', $smenu,true);
$data['content'] = $edit->output;
$data['title'] = "{$this->t**s}";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function certifi()
{
$iid = $this->rapyd->uri->get('modify');
$id = $iid[1];
$sel = array('a.nombre', 'a.casa', 'a.calle', 'a.urb', 'a.ciudad', 'a.municipio', 'a.estado', 'a.cpostal', 'a.ctelefono1', 'a.telefono1', 'a.ctelefono2', 'a.telefono2', 'd.nombre AS sclinom', 'd.nomfis', 'd.telefono', 'd.telefon2', "CONCAT_WS(' ',d.dire11,d.dire12) AS direc", 'b.ciudad');
$this->db->select($sel);
$this->db->from('sinvehiculo AS a');
$this->db->join('sfac AS b', 'a.id_sfac=b.id');
$this->db->join('scli AS d', 'b.cod_cli=d.cliente');
$this->db->where('a.id', $id);
$query = $this->db->get();
if ($query->num_rows() > 0) {
$row = $query->row();
$nombre = empty($row->nomfis) ? $row->sclinom : $row->nomfis;
//$casa = $row->casa;
//$calle = $row->calle;
//$urb = $row->urb;
//$ciudad = $row->ciudad;
//$municipio = $row->municipio;
//$estado = $row->estado;
//$cpostal = $row->cpostal;
//$ctelefono1 = $row->ctelefono1;
//$telefono1 = $row->telefono1;
//$ctelefono2 = $row->ctelefono2;
//$telefono2 = $row->telefono2;
$data = array();
if (empty($row->nombre)) {
$data['nombre'] = $nombre;
$where = 'id = ' . $this->db->escape($id);
$str = $this->db->update_string('sinvehiculo', $data, $where);
$this->db->simple_query($str);
}
}
$this->rapyd->load('dataedit');
$edit = new DataEdit($this->t**s, 'sinvehiculo');
$edit->back_url = site_url($this->url . 'index');
$edit->nombre = new inputField('Nombre', 'nombre');
$edit->nombre->rule = 'max_length[200]|required';
$edit->nombre->maxlength = 200;
$edit->casa = new inputField('Casa Quinta Edificio Apto', 'casa');
$edit->casa->rule = 'max_length[100]|required';
//$edit->casa->size =102;
$edit->casa->maxlength = 100;
$edit->calle = new inputField('Avenida, calle, plaza, esquina', 'calle');
$edit->calle->rule = 'max_length[100]|required';
//$edit->calle->size =102;
$edit->calle->maxlength = 100;
$edit->urb = new inputField('Urbanización, Bario, Residencia', 'urb');
$edit->urb->rule = 'max_length[100]|required';
//$edit->urb->size =102;
$edit->urb->maxlength = 100;
$edit->ciudad = new inputField('Ciudad', 'ciudad');
$edit->ciudad->rule = 'max_length[100]|required';
//$edit->ciudad->size =102;
$edit->ciudad->maxlength = 100;
$edit->municipio = new inputField('Parroquia, distrito, Municipio', 'municipio');
$edit->municipio->rule = 'max_length[100]|required';
//$edit->municipio->size =102;
$edit->municipio->maxlength = 100;
$edit->estado = new inputField('Estado', 'estado');
$edit->estado->rule = 'max_length[100]|required';
//$edit->estado->size =102;
$edit->estado->maxlength = 100;
$edit->cpostal = new inputField('Código Postal', 'cpostal');
$edit->cpostal->rule = 'max_length[10]|numeric|required';
$edit->cpostal->size = 10;
$edit->cpostal->maxlength = 10;
$edit->ctelefono1 = new inputField('Teléfono de Habitación', 'ctelefono1');
$edit->ctelefono1->rule = 'max_length[100]|numeric|required';
$edit->ctelefono1->size = 6;
$edit->ctelefono1->maxlength = 100;
$edit->telefono1 = new inputField('', 'telefono1');
$edit->telefono1->rule = 'max_length[100]|numeric|required';
$edit->telefono1->size = 10;
$edit->telefono1->maxlength = 10;
$edit->telefono1->in = 'ctelefono1';
$edit->ctelefono2 = new inputField('Teléfono de Trabajo', 'ctelefono2');
$edit->ctelefono2->rule = 'max_length[100]|numeric|required';
$edit->ctelefono2->size = 6;
$edit->ctelefono2->maxlength = 4;
$edit->telefono2 = new inputField('', 'telefono2');
$edit->telefono2->rule = 'max_length[100]|numeric|required';
$edit->telefono2->size = 10;
$edit->telefono2->maxlength = 10;
$edit->telefono2->in = 'ctelefono2';
$edit->distrito = new inputField('Distrito', 'distrito');
$edit->distrito->rule = 'max_length[100]';
$edit->aseguradora = new inputField('Nombre de la aseguradora', 'aseguradora');
$edit->aseguradora->rule = 'max_length[100]';
$edit->aseguradora->group = 'Datos del seguro';
$edit->poliza = new inputField('Poliza', 'poliza');
$edit->poliza->rule = 'max_length[100]';
$edit->poliza->group = 'Datos del seguro';
$edit->vence = new dateonlyField('Vencimiento de la póliza', 'vence');
$edit->vence->rule = 'chfecha';
$edit->vence->group = 'Datos del seguro';
$edit->nomban = new inputField('Nombre del banco', 'nomban');
$edit->nomban->rule = 'max_length[100]';
$edit->nomban->group = 'Reserva de dominio';
$edit->banrif = new inputField('Rif del banco', 'banrif');
$edit->banrif->rule = 'max_length[10]';
$edit->banrif->group = 'Reserva de dominio';
$edit->representante = new inputField('Representación', 'representante');
$edit->representante->rule = 'max_length[100]';
$edit->concesionario = new inputField('Concesionario B', 'concesionario');
$edit->concesionario->rule = 'max_length[100]';
$edit->concesionariorif = new inputField('Concesionario B Rif', 'concesionariorif');
$edit->concesionariorif->rule = 'max_length[10]';
$accion = "javascript:window.location='" . site_url($this->url . 'certificado' . $edit->pk_URI()) . "'";
$edit->button_status('btn_imprime', 'Certificado', $accion, 'BR', 'show');
$edit->buttons('modify', 'save', 'undo', 'delete', 'back');
//$edit->submit = new submitField("login","btn_submit");
$edit->build();
$data['content'] = $edit->output;
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$data['title'] = heading($this->titp);
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataedit', 'dataobject');
$script = '
$(function() {
$(".inputnum").numeric(".");
$("#estadmin").change(function(){
$.post("' . site_url('presupuesto/presupuesto/get_tipo') . '",{ codigoadm:$("#estadmin").val() },function(data){$("#fondo").html(data);})
});
});
function btn_anulaf(i){
if(!confirm("Esta Seguro que desea Anular El Fondo en Avance ?"))
return false;
else
window.location="' . site_url($this->url . 'anular') . '/"+i
}
';
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'codprov', 'nombre' => 'nombrep'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "sprv");
$do = new DataObject("odirect");
$do->pointer('sprv', 'sprv.proveed=odirect.cod_prov', 'sprv.nombre as nombrep', 'LEFT');
$edit = new DataEdit($this->t**s, $do);
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->script($script, "create");
$edit->script($script, "modify");
$edit->script($script, "show");
$edit->pre_process('insert', '_valida');
$edit->pre_process('update', '_valida');
$edit->post_process('insert', '_post');
$edit->post_process('update', '_post');
$edit->numero = new inputField("Nú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->fecha->rule = 'required';
$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->codprov = new inputField("Beneficiario", 'codprov');
$edit->codprov->db_name = "cod_prov";
$edit->codprov->size = 4;
$edit->codprov->rule = "required";
$edit->codprov->readonly = true;
$edit->codprov->append($bSPRV);
$edit->nombrep = new inputField("Nombre", 'nombrep');
$edit->nombrep->size = 20;
$edit->nombrep->readonly = true;
$edit->nombrep->pointer = TRUE;
$edit->nombrep->in = "codprov";
//$edit->beneficiario = new inputField("Beneficiario", 'beneficiario');
//$edit->beneficiario->size = 50;
//$edit->beneficiario->rule = "required";
$edit->observa = new textAreaField("Observaciones", 'observa');
$edit->observa->cols = 60;
$edit->observa->rows = 4;
$edit->total = new inputField("Monto", 'total');
$edit->total->rule = 'required|callback_positivo';
$edit->total->css_class = 'inputnum';
$edit->total->size = 15;
$status = $edit->_dataobject->get('status');
if ($status == 'G1') {
$action = "javascript:window.location='" . site_url($this->url . 'actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_status", 'Actualizar', $action, "TR", "show");
$action = "javascript:btn_anulaf('" . $edit->rapyd->uri->get_edited_id() . "')";
if ($this->datasis->puede(168)) {
$edit->button_status("btn_anular", 'Anular', $action, "TR", "show");
}
$edit->buttons("modify", "save");
} elseif ($status == 'G2') {
//$action = "javascript:window.location='" .site_url($this->url.'reversar/'.$edit->rapyd->uri->get_edited_id()). "'";
//$edit->button_status("btn_rever",'Reversar',$action,"TR","show");
$action = "javascript:btn_anulaf('" . $edit->rapyd->uri->get_edited_id() . "')";
if ($this->datasis->puede(168)) {
$edit->button_status("btn_anular", 'Anular', $action, "TR", "show");
}
} elseif ($status == 'G') {
$edit->buttons("modify", "save");
} else {
$edit->buttons("save");
}
$edit->buttons("undo", "back");
$edit->build();
if ($this->genesal) {
$smenu['link'] = barra_menu('171');
$data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
$data['content'] = $edit->output;
$data['title'] = "{$this->t**s}";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
} else {
$edit->error_string;
}
}
function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataedit', 'dataobject');
$where = 'activo = "S"';
$mf = $this->datasis->puede(333);
$mo = $this->datasis->puede(334);
if ($mf && $mo) {
} elseif ($mf) {
$where .= ' AND tipocta="F"';
} elseif ($mo) {
$where .= ' AND tipocta<>"F"';
}
$mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => '<#i#>', 'banco' => '<#j#>'), 'where' => $where, 'p_uri' => array(4 => '<#i#>', 5 => '<#j#>'), 'titulo' => 'Buscar Bancos');
$bBANC = $this->datasis->p_modbus($mBANC, "codbanc/nombreb", 800, 600, 'banc');
$pmBANC = array('tabla' => 'banc', 'join' => array(array('tban', 'banc.tbanco=tban.cod_banc', 'LEFT')), 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => '<#i#>', 'banco' => '<#j#>', 'numcuent' => 'cuentab', 'nomb_banc' => 'nom_bancb'), 'where' => $where, 'script' => array('conctrasla()'), 'p_uri' => array(4 => '<#i#>', 5 => '<#j#>'), 'titulo' => 'Buscar Bancos');
$bpBANC = $this->datasis->p_modbus($pmBANC, "pcodbanc/pnombreb", 800, 600, 'pbanc');
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto', 'grupo' => 'Grupo'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov', 'nombre' => 'nombrep', 'concepto' => 'observa', 'contacto' => 'nombret', 'grupo' => 'tsprv'), 'script' => array('copiabenefi()'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$mBCTA = array('tabla' => 'bcta', 'columnas' => array('codigo' => 'Cóodigo', 'denominacion' => 'Denominacion', 'cuenta' => 'Cuenta'), 'filtro' => array('codigo' => 'Cóodigo', 'denominacion' => 'Denominacion', 'cuenta' => 'Cuenta'), 'retornar' => array('codigo' => 'bcta', 'denominacion' => 'bctad'), 'titulo' => 'Buscar Otros Ingresos');
$bBCTA = $this->datasis->p_modbus($mBCTA, "bcta");
$link8 = site_url($this->url . 'sugerirch/');
$script = '
$(".inputnum").numeric(".");
$(document).ready(function() {
$("#tr_nombret").hide();
$("#tr_tsprv").hide();
});
function copiabenefi(){
tsprv=$("#tsprv").val();
nombret = $("#nombret").val();
benefi = $("#nombrep").val();
if(tsprv=="0001"){
$("#benefi").val(" "+nombret);
}else{
$("#benefi").val(" "+benefi);
}
}
function conctrasla(){
observa =$("#observa").val();
pnombreb = $("#pnombreb").val();
cuentab = $("#cuentab").val();
nom_bancb = $("#nom_bancb").val();
$("#observa").val(observa+" UNICAMENTE PARA SER DEPOSITADO EN "+pnombreb+" CUENTA NRO "+cuentab+" DEL BANCO "+nom_bancb);
}
function ultimoch(){
$.ajax({
type: "POST",
url: "' . site_url("tesoreria/desem/ultimoch") . '",
data:"codbanc="+$("#codbanc").val(),
success: function(msg){
$("#cheque").val(msg);
}
});
}
function sugerir(){
$.ajax({
url: "' . $link8 . '",
success: function(msg){
if(msg){
$("#cheque").val(msg);
}
else{
alert("No es posible generar otra sugerencia. Coloque el código manualmente");
}
}
});
}
';
$do = new DataObject("mbanc");
$do->pointer('sprv', 'sprv.proveed = mbanc.cod_prov', 'sprv.nombre as nombrep', 'LEFT');
$do->pointer('bcta', 'bcta.codigo = mbanc.bcta', 'bcta.denominacion as bctad ', 'LEFT');
$do->pointer('banc', 'banc.codbanc=mbanc.codbanc', 'banc.banco as nombreb', 'LEFT');
$do->pointer('banc c', 'c.codbanc=mbanc.pcodbanc', 'c.banco as pnombreb', 'LEFT');
$edit = new DataEdit($this->t**s, $do);
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->on_save_redirect = $this->on_save_redirect;
$edit->script($script, "create");
$edit->script($script, "modify");
$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');
$tipo = $edit->_dataobject->get('tipo');
$edit->id = new inputField("Número", "id");
$edit->id->mode = "autohide";
$edit->id->when = array('show');
//$edit->fechapago = new dateonlyField("Fecha Movimiento", "fechapago");
//$edit->fechapago->insertValue = date('Y-m-d');
//$edit->fechapago->size =12;
//$edit->fechapago->rule = 'required';
$edit->tipo = new inputField("", "tipo");
$edit->tipo->insertValue = "E";
$edit->tipo->mode = "autohide";
$edit->tipo->when = array('');
$edit->cod_prov = new inputField("Beneficiario", 'cod_prov');
$edit->cod_prov->size = 6;
//$edit->cod_prov->rule = "required";
$edit->cod_prov->append($bSPRV);
//$edit->cod_prov->readonly=true;
$edit->nombrep = new inputField("Nombre", 'nombrep');
$edit->nombrep->size = 50;
$edit->nombrep->readonly = true;
$edit->nombrep->pointer = true;
$edit->nombrep->in = "cod_prov";
$edit->nombret = new inputField("nombre temporal", 'nombret');
$edit->nombret->size = 50;
$edit->nombret->db_name = ' ';
$edit->nombret->when = array("create", "modify");
$edit->tsprv = new inputField("", 'tsprv');
$edit->tsprv->size = 50;
$edit->tsprv->db_name = ' ';
$edit->tsprv->when = array("create", "modify");
$edit->bcta = new inputField("Motivo Movimiento", 'bcta');
$edit->bcta->size = 6;
//$edit->bcta->rule = "required";
$edit->bcta->append($bBCTA);
$edit->bcta->readonly = true;
//$edit->bcta->group = "Deposito";
$edit->bctad = new inputField("", 'bctad');
$edit->bctad->size = 50;
//$edit->bctad->group = "Deposito";
$edit->bctad->in = "bcta";
$edit->bctad->pointer = true;
$edit->bctad->readonly = true;
$edit->codbanc = new inputField("Banco", 'codbanc');
$edit->codbanc->size = 3;
$edit->codbanc->rule = "required|callback_chexiste_codbanc";
$edit->codbanc->append($bBANC);
//$edit->codbanc-> readonly=true;
$edit->codbanc->group = "Transaccion";
$edit->nombreb = new inputField("Nombre", "nombreb");
$edit->nombreb->size = 50;
$edit->nombreb->readonly = true;
$edit->nombreb->pointer = true;
$edit->nombreb->in = "codbanc";
$edit->nombreb->group = "Transaccion";
$edit->tipo_doc = new dropdownField("Tipo Documento", "tipo_doc");
if ($this->datasis->puede(288)) {
$edit->tipo_doc->option("CH", "Cheque");
}
if ($this->datasis->puede(289)) {
$edit->tipo_doc->option("NC", "Nota de Credito");
}
if ($this->datasis->puede(290)) {
$edit->tipo_doc->option("ND", "Nota de Debito");
}
if ($this->datasis->puede(291)) {
$edit->tipo_doc->option("DP", "Deposito");
}
$edit->tipo_doc->style = "width:180px";
$edit->tipo_doc->group = "Transaccion";
$edit->tipo_doc->rule = 'required';
$rule = 'required';
$sugerir = '<a href="javascript:sugerir();" title="Sugerir un numero aleatorio">Sugerir Numero </a>';
$edit->cheque = new textareaField("Nro. Transacción", 'cheque');
$edit->cheque->rows = 3;
$edit->cheque->cols = 80;
$edit->cheque->rule = $rule;
$edit->cheque->group = "Transaccion";
$edit->cheque->append($sugerir);
$edit->fecha = new dateonlyField("Fecha Transacción", "fecha");
//$edit->fecha->insertValue = date('Y-m-d');
$edit->fecha->size = 12;
$edit->fecha->rule = 'required';
$edit->fecha->group = "Transaccion";
$edit->monto = new inputField("Monto", 'monto');
$edit->monto->size = 20;
$edit->monto->group = "Transaccion";
$edit->monto->css_class = 'inputnum';
$edit->monto->rule = 'callback_positivo|required';
if ($tipo == 'I') {
$edit->monto->mode = "autohide";
}
$edit->benefi = new inputField("A nombre de", 'benefi');
$edit->benefi->size = 100;
$edit->benefi->rule = "required";
$edit->benefi->group = "Transaccion";
$edit->observa = new textAreaField("Concepto", 'observa');
$edit->observa->cols = 80;
$edit->observa->rows = 5;
$edit->observa->group = "Transaccion";
$edit->destino = new dropdownField("Destino", "destino");
$edit->destino->option("C", "Caja");
$edit->destino->option("I", "Interno");
$edit->destino->style = "width:100px";
$edit->rel = new textAreaField("Relaciones", 'rel');
$edit->rel->cols = 60;
$edit->rel->rows = 3;
$edit->rel->group = "Transaccion";
$edit->rel->mode = "autohide";
$edit->rel->when = array("show");
$edit->status = new textAreaField("Estado", 'status');
$edit->status->cols = 60;
$edit->status->rows = 3;
$edit->status->group = "Transaccion";
$edit->status->mode = "autohide";
$edit->status->when = array("show");
$edit->fecha2 = new dateonlyField("Fecha Aux", "fecha2");
$edit->fecha2->group = "Otros";
$edit->multiple = new inputField("Multiple", 'multiple');
$edit->multiple->group = "Otros";
$edit->multiple->when = array('show');
$edit->pcodbanc = new inputField("Para Banco", 'pcodbanc');
$edit->pcodbanc->size = 3;
$edit->pcodbanc->rule = "callback_chexiste_codbanc";
$edit->pcodbanc->append($bpBANC);
$edit->pcodbanc->group = "Transaccion";
$edit->pnombreb = new inputField("Nombre", "pnombreb");
$edit->pnombreb->size = 50;
$edit->pnombreb->readonly = true;
$edit->pnombreb->pointer = true;
$edit->pnombreb->in = "pcodbanc";
$edit->pnombreb->group = "Transaccion";
$edit->cuentab = new hiddenField("", "cuentab");
$edit->cuentab->db_name = ' ';
$edit->nom_bancb = new hiddenField("", "nom_bancb");
$edit->nom_bancb->db_name = ' ';
$status = $edit->_dataobject->get("status");
$tipo_doc = $edit->_dataobject->get("tipo_doc");
$staing = $edit->_dataobject->get("staing");
if ($status == 'J1') {
$action = "javascript:window.location='" . site_url($this->url . 'actualizar/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_status", 'Actualizar', $action, "TR", "show");
if ($this->datasis->puede(337)) {
$edit->buttons("modify", "save");
}
} elseif ($status == 'J2') {
if (in_array($tipo_doc, array('CH', 'ND'))) {
$action = "javascript:window.location='" . site_url($this->url . 'creanc/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_creanc", 'Crear NC', $action, "TR", "show");
}
} elseif ($status == 'J') {
// if($this->datasis->puede(337))
$edit->buttons("modify", "save");
} else {
$edit->buttons("save");
}
if ($status != 'AN' && $status != 'A' && $status != 'A2' && $status != 'NC' && $staing != 'C') {
$action = "javascript:window.location='" . site_url($this->url . 'anular/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_rever", 'Anular', $action, "TR", "show");
}
$edit->buttons("undo", "back");
if ($this->datasis->puede(313)) {
$edit->buttons("delete");
}
if ($this->datasis->puede(336)) {
$edit->buttons("add");
}
$edit->build();
if ($this->genesal) {
$smenu['link'] = barra_menu('204');
$data['smenu'] = $this->load->view('view_sub_menu', $smenu, true);
$data['content'] = $edit->output;
$data['title'] = "{$this->t**s}";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
} else {
if (!empty($edit->error_string)) {
return $edit->error_string;
} else {
return $edit->_dataobject->get('id');
}
}
}
function ordiva($ordi)
{
$this->rapyd->load('dataobject', 'dataedit');
$fecha = $this->datasis->dameval("SELECT fecha FROM ordi WHERE numero={$ordi}");
$iva = $this->datasis->ivaplica($fecha);
$jsc = 'function calcula(){
if($("#tasa").val().length>0){
tasa=parseFloat($("#tasa").val());
if($("#base").val().length>0) base=parseFloat($("#base").val()); else base=0;
$("#montoiva").val(roundNumber(base*(tasa/100),2));
}
}
function calculaiva(){
if($("#tasa").val().length>0){
tasa=parseFloat($("#tasa").val());
if($("#montoiva").val().length>0) montoiva=parseFloat($("#montoiva").val()); else montoiva=0;
$("#base").val(roundNumber(montoiva*100/tasa,2));
}
}';
$edit = new DataEdit(' ', 'ordiva');
$edit->back_save = true;
$edit->back_cancel = true;
$edit->back_cancel_save = true;
$edit->back_url = site_url('import/ordi/dataedit/show/' . $ordi);
$edit->post_process('insert', '_post_ordiva');
$edit->post_process('update', '_post_ordiva');
$edit->post_process('delete', '_post_ordiva');
$edit->id = new inputField2('Numero', 'id');
$edit->id->mode = 'autohide';
$edit->id->when = array('modify');
$edit->tasa = new dropdownField('Tasa %', 'tasa');
foreach ($iva as $nom => $val) {
$edit->tasa->option($val, nformat($val) . '%');
}
$edit->tasa->rule = 'required|numeric';
$edit->tasa->style = 'width:100px';
$edit->tasa->mode = 'autohide';
$edit->tasa->append('<span style="color:black;"> Vigente para la fecha <b>' . dbdate_to_human($fecha) . '</b></span>');
$edit->base = new inputField('Base imponible', 'base');
$edit->base->rule = 'required|numeric';
$edit->base->size = 15;
$edit->base->css_class = 'inputnum';
$edit->base->autocomplete = false;
$edit->montoiva = new inputField('IVA ', 'montoiva');
$edit->montoiva->rule = 'required|numeric';
$edit->montoiva->size = 15;
$edit->montoiva->autocomplete = false;
$edit->montoiva->css_class = 'inputnum';
$edit->concepto = new inputField2('Concepto', 'concepto');
$edit->concepto->rule = 'max_length[100]';
$edit->concepto->max_size = 100;
$edit->ordeni = new autoUpdateField('ordeni', $ordi, $ordi);
$edit->script($jsc, 'create');
//$edit->script($jsm,'modify');
$accion = "javascript:window.location='" . site_url('import/ordi/cargarordi' . $edit->pk_URI()) . "'";
$edit->button_status('btn_cargar', 'Cargar', $accion, 'TR', 'show');
$edit->buttons('modify', 'save', 'undo', 'delete', 'back');
$edit->build();
if ($edit->_status != 'show') {
$this->rapyd->jquery[] = '$(".inputnum").numeric(".");';
$this->rapyd->jquery[] = '$("#tasa").change(function() { calcula(); });';
$this->rapyd->jquery[] = '$("#base").bind("keyup",function() { calcula(); });';
$this->rapyd->jquery[] = '$("#montoiva").bind("keyup",function() { calculaiva(); });';
}
if ($edit->_status == 'modify') {
$jsm = '<script language="javascript" type="text/javascript">
function calcula(){
tasa=' . $edit->tasa->value . ';
if($("#base").val().length>0) base=parseFloat($("#base").val()); else base=0;
$("#montoiva").val(roundNumber(base*(tasa/100),2));
}
function calculaiva(){
tasa=' . $edit->tasa->value . ';
if($("#montoiva").val().length>0) montoiva=parseFloat($("#montoiva").val()); else montoiva=0;
$("#base").val(roundNumber(montoiva*100/tasa,2));
}
</script>';
$data['script'] = $jsm;
}
$data['content'] = $edit->output;
$data['title'] = '<h1>Impuestos IVA</h1>';
$data['head'] = $this->rapyd->get_head() . phpscript('nformat.js');
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataobject', 'dataedit');
$mOCOMPRA = array('tabla' => 'ocompra', 'columnas' => array('numero' => 'Número', 'tipo' => 'Tipo', 'uejecutora' => 'uejecutora', 'cod_prov' => 'Beneficiario'), 'filtro' => array('numero' => 'Número', 'tipo' => 'Tipo', 'uejecutora' => 'uejecutora', 'cod_prov' => 'Beneficiario'), 'retornar' => array('numero' => 'compra', 'tipo' => 'tipo', 'uejecutora' => 'uejecutora', 'cod_prov' => 'cod_prov', 'fechafac' => 'fechafac', 'factura' => 'factura', 'controlfac' => 'controlfac', 'total' => 'ototal', 'abonado' => 'oabonado'), 'where' => 'total > abonado', 'titulo' => 'Buscar Ordenes de Compra');
$bOCOMPRA = $this->datasis->p_modbus($mOCOMPRA, "ocompra");
$do = new dataObject("odirect");
$edit = new DataEdit($this->t**s, "odirect");
//numero,controlord,,tipo,uejecutora,estadmin,fondo,cod_prov,nombre,beneficiario,factura,controlfac,fechafac,subtotal,exento,ivag,ivar,ivaa,pago,creten,breten,reteiva,reten,total,iva,observa,anulado,status,user_comp,date_comp,reteiv
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->pre_process('update', '_valida');
$edit->pre_process('insert', '_valida');
$edit->post_process('insert', '_post');
$edit->post_process('update', '_post');
$edit->compra = new inputField("Numero O. Compra", "compra");
$edit->compra->mode = "autohide";
$edit->compra->group = "Orden De Compra";
$edit->compra->append($bOCOMPRA);
$edit->numero = new inputField("Número O. Pago", "numero");
$edit->numero->mode = "autohide";
$edit->numero->when = array('show');
$edit->numero->group = "Pago";
$edit->factura = new inputField("Factura", "factura");
$edit->factura->mode = "autohide";
$edit->factura->group = "Orden De Compra";
$edit->controlfac = new inputField("Control Fiscal", "controlfac");
$edit->controlfac->mode = "autohide";
$edit->controlfac->group = "Orden De Compra";
$edit->fechafac = new inputField("Fecha Causación", "fechafac");
$edit->fechafac->mode = "autohide";
$edit->fechafac->group = "Orden De Compra";
$edit->tipo = new inputField("Orden de", "tipo");
$edit->tipo->mode = "autohide";
$edit->tipo->group = "Orden De Compra";
$edit->uejecutora = new inputField("Unidad Ejecutora", "uejecutora");
$edit->uejecutora->mode = "autohide";
$edit->uejecutora->group = "Orden De Compra";
$edit->cod_prov = new inputField("Beneficiario", 'cod_prov');
$edit->cod_prov->size = 6;
$edit->cod_prov->group = "Orden De Compra";
$edit->cod_prov->mode = "autohide";
$edit->oabonado = new inputField("Abonado", 'oabonado');
$edit->oabonado->db_name = ' ';
$edit->oabonado->size = 8;
$edit->oabonado->mode = "autohide";
$edit->oabonado->group = "Orden De Compra";
$edit->oabonado->when = array('create');
$edit->ototal = new inputField("Total O. Compra", 'ototal');
$edit->ototal->db_name = ' ';
$edit->ototal->size = 8;
$edit->ototal->mode = "autohide";
$edit->ototal->group = "Orden De Compra";
$edit->ototal->when = array('create');
$edit->fecha = new dateonlyField("Fecha de Pago", "fecha");
$edit->fecha->insertValue = date('Y-m-d');
$edit->fecha->size = 12;
$edit->fecha->rule = "required";
$edit->fecha->group = "Pago";
$edit->pago = new inputField("Pagar", 'pago');
$edit->pago->size = 8;
$edit->pago->mode = "autohide";
$edit->pago->group = "Pago";
$n = $edit->_dataobject->get('numero');
$status = $edit->_dataobject->get("status");
if ($status == 'T') {
//$action = "javascript:window.location='" .site_url($this->url.'actualizar/'.$edit->rapyd->uri->get_edited_id()). "'";
//$action = "javascript:window.location='" .site_url($this->url.'actualizar/'.$n)."'";
//$edit->button_status("btn_status",'Ordenar Pago',$action,"TR","show");
$edit->buttons("modify", "save");
} elseif ($status == 'O') {
$action = "javascript:window.location='" . site_url($this->url . 'reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
//$action = "javascript:window.location='" .site_url($this->url.'reversar/'.$n). "'";
$edit->button_status("btn_rever", 'Deshacer Ordenar Pago', $action, "TR", "show");
} else {
$edit->buttons("save");
}
$edit->buttons("undo", "back");
$edit->build();
$data['content'] = $edit->output;
$data['title'] = " {$this->t**s} ";
//$data['content'] = $edit->output;
//$data['title'] = " $this->t**s ";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function dataedit()
{
//$this->datasis->modulo_id(101,1);
$this->rapyd->load('dataedit', 'dataobject');
$mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'saldo' => 'Saldo'), 'retornar' => array('codbanc' => 'codbanc', 'banco' => 'nombreb'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos');
$bBANC = $this->datasis->p_modbus($mBANC, "banc");
$mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'Cóodigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'Código', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov', 'nombre' => 'nombre'), 'titulo' => 'Buscar Proveedor');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$script = '
$(".inputnum").numeric(".");
';
$do = new DataObject("pmov");
//$do->pointer('sprv' ,'sprv.proveed = pmov.cod_prov',' sprv.nombre as nombre ',' LEFT ');
$edit = new DataEdit($this->t**s, $do);
$edit->back_url = site_url($this->url . "filteredgrid");
$edit->script($script, "create");
$edit->script($script, "modify");
//$edit->pre_process('insert' ,'_valida');
//$edit->pre_process('update' ,'_valida');
$edit->numero = new inputField("Número", "numero");
$edit->numero->mode = "autohide";
$edit->numero->when = array('show');
$edit->orden = new inputField("Orden de Pago", "orden");
$edit->orden->size = 10;
$edit->orden->maxlength = 12;
//$edit->orden->mode = "autohide";
//$edit->orden->when = array('show');
$edit->cod_prov = new inputField("Proveedor", 'cod_prov');
$edit->cod_prov->size = 6;
$edit->cod_prov->rule = "required";
$edit->cod_prov->append($bSPRV);
$edit->nombre = new inputField("Nombre", 'nombre');
$edit->nombre->db_name = ' ';
$edit->nombre->size = 50;
$edit->nombre->readonly = true;
$edit->nombre->pointer = true;
$edit->nombre->in = "cod_prov";
$edit->observa = new textAreaField("Observaciones", 'observa');
$edit->observa->cols = 60;
$edit->observa->rows = 3;
$edit->banc_doc = new dropdownField("Banco Emisor", "banc_doc");
$edit->banc_doc->option("", "Seccionar");
$edit->banc_doc->options("SELECT cod_banc, CONCAT_WS(' ',cod_banc,nomb_banc) FROM tban ORDER BY cod_banc");
// $edit->banc_doc->group = "Cheque";
$edit->tipo_doc = new dropdownField("Tipo Documento", "tipo_doc");
$edit->tipo_doc->option("CH", "Cheque");
$edit->tipo_doc->option("NC", "Nota de Credito");
//$edit->tipo_doc->option("ND","Nota de Debito" );
$edit->tipo_doc->option("DP", "Deposito");
//$edit->tipo_doc->option("CH","Cheque" );
$edit->tipo_doc->style = "width:200px";
$edit->numero_doc = new inputField("Número Documento", 'numero_doc');
$edit->numero_doc->size = 30;
$edit->numero_doc->maxlength = 30;
$edit->numero_doc->rule = "required";
//$edit->numero_doc->group = "Deposito";
$edit->fecha_doc = new dateonlyField("Fecha Documento", "fecha_doc");
$edit->fecha_doc->insertValue = date('Y-m-d');
$edit->fecha_doc->size = 12;
//$edit->fecha_doc->group = "Cheque/Deposito/Nota de Crédito";
$edit->fecha_doc->rule = "required";
//$edit->cheque = new inputField("Cheque Nº", 'cheque');
//$edit->cheque->size = 30;
//$edit->cheque->maxlength = 30;
//$edit->cheque->group = "Cheque";
$edit->monto = new inputField("Monto", 'monto');
$edit->monto->size = 20;
$edit->monto->css_class = 'inputnum';
$edit->monto->rule = 'required|callback_positivo';
//$edit->monto->group = "";
$edit->fecha = new dateonlyField("Fecha", "fecha");
$edit->fecha->insertValue = date('Y-m-d');
$edit->fecha->size = 12;
//$edit->fecha->group = "Cheque/Deposito/Nota de Crédito";
$edit->fecha->rule = "required";
$edit->codbanc = new inputField("Banco*", 'codbanc');
$edit->codbanc->size = 6;
//$edit->codbanc->rule = "required";
$edit->codbanc->append($bBANC);
$edit->codbanc->readonly = true;
//$edit->codbanc->group = "Deposito";
$edit->nombreb = new inputField("", 'nombreb');
$edit->nombreb->db_name = 'nombreb';
$edit->nombreb->size = 30;
//$edit->nombreb->group = "Deposito";
$edit->nombreb->in = "codbanc";
$status = $edit->_dataobject->get("status");
if ($status == 'P') {
$action = "javascript:window.location='" . site_url($this->url . '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($this->url . 'reversar/' . $edit->rapyd->uri->get_edited_id()) . "'";
$edit->button_status("btn_rever", 'Reversar', $action, "TR", "show");
} else {
$edit->buttons("save");
}
$edit->buttons("undo", "back");
$edit->build();
$data['content'] = $edit->output;
$data['title'] = " {$this->t**s} ";
$data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
