function asigna($valor, $value = 0, $soli = 0) { //$tipo,$codigoadm,$codigopres, $campo = new inputField("Title", "gt[{$valor}]"); $campo->status = "create"; $campo->css_class = 'inputnum'; $campo->size = 10; if ($value == 0) { $campo->insertValue = $soli; } else { $campo->insertValue = $value; } //$campo->rule="readonly"; $campo->build(); return $campo->output; }
function carga() { $this->rapyd->load('datagrid', 'fields', 'datafilter2'); $formato = $this->datasis->dameval('SELECT formato FROM cemp LIMIT 0,1'); $qformato = '%'; for ($i = 1; $i < substr_count($formato, '.') + 1; $i++) { $qformato .= '.%'; } $this->qformato = $qformato; $this->qformato = $qformato = $this->datasis->formato_cpla(); $modbus = array('tabla' => 'cpla', 'columnas' => array('codigo' => 'Código', 'denominacion' => 'Denominación'), 'filtro' => array('codigo' => 'Código', 'denominacion' => 'Denominacion'), 'retornar' => array('codigo' => 'con<#codigo#>'), 'titulo' => 'Buscar Cuenta', 'where' => 'nivel = 3', 'p_uri' => array(4 => "<#codigo#>")); //'where'=>" codigo LIKE \"$qformato\"", $btn = $this->datasis->p_modbus($modbus, "<#codigo#>"); $modbus2 = array('tabla' => 'ppla', 'columnas' => array('codigo' => 'Código', 'denominacion' => 'Denominación'), 'filtro' => array('codigo' => 'Código', 'denominacion' => 'Denominacion'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar Cuenta'); //'where'=>" codigo LIKE \"$qformato\"", $btn2 = $this->datasis->p_modbus($modbus2, "ppla"); $error = ''; if ($this->input->post('pros') !== FALSE) { foreach ($_POST as $cod => $cant) { if (substr($cod, 0, 3) == "con" && $cant > 0) { $cod = substr($cod, 3, 20); $cod = $this->db->escape($cod . '%'); $cod = str_replace('_', '.', $cod); //$cant = $this->db->escape($cant); if (!$this->datasis->dameval("SELECT COUNT(*) FROM cpla WHERE codigo='{$cant}' ")) { $error .= " La cuenta contable ({$cant}) es inválida<br>"; } else { $data = array('contable' => $cant); $where = "codigo like {$cod} "; $mSQL = $this->db->update_string('ppla', $data, $where); $this->db->simple_query($mSQL); } } } } $filter = new DataFilter2(" ", 'ppla'); $filter->error_string = $error; $filter->codigo = new inputField("Código Presupuestario", "codigo"); //$filter->codigo->option("","Seleccionar"); //$filter->codigo->options("SELECT codigo, CONCAT_WS(' ',codigo,denominacion) FROM ppla WHERE LENGTH(codigo) < ($this->long) ORDER BY codigo "); $filter->codigo->clause = "likerigth"; $filter->codigo->rule = "required"; $filter->codigo->size = 20; $filter->codigo->append($btn2); $filter->buttons("reset", "search"); $filter->build(); $ggrid = ''; if ($filter->is_valid()) { $ggrid = form_open('contabilidad/cargacuent/carga/search/osp'); $ggrid .= form_hidden('codigo', $filter->codigo->newValue); $contable = new inputField("Cuenta Contable", "con<#codigo#>"); //, "contable[<#codigo#>]" $contable->grid_name = "contable[<#codigo#>]"; $contable->status = 'modify'; $contable->size = 12; $contable->css_class = 'inputnum'; $contable->append($btn); $contable->build(); $grid = new DataGrid("Clasificador Presupuestario (" . $filter->codigo->newValue . ")"); //$grid->db->where('concepto','015'); //$grid->per_page = $filter->db->num_rows() ; $grid->order_by("codigo", "asc"); $grid->column("Código", "codigo"); $grid->column("Denominación", "denominacion"); $grid->column("Cuenta Contable", "contable"); $grid->column("Cuenta Contable", $contable->output, 'align=\'right\''); $grid->submit('pros', 'Guardar', "BR"); $grid->build(); $ggrid .= $grid->output; $ggrid .= form_close(); //echo $grid->db->last_query(); } $script = ' <script type="text/javascript"> $(function() { $(".inputnum").numeric("."); }); </script>'; $data['content'] = $filter->output . $ggrid; $data['title'] = 'Asignación de Cuentas'; $data['script'] = $script; $data["head"] = $this->rapyd->get_head() . script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js"); $this->load->view('view_ventanas', $data); }
function solicitud($valor, $value = null) { //$tipo,$codigoadm,$codigopres, $campo = new inputField("Title2", "gs[{$valor}]"); $campo->status = "create"; $campo->css_class = 'inputnum'; $campo->size = 10; $campo->insertValue = $value; $campo->build(); return $campo->output; }
function filteredgrid() { //$this->datasis->modulo_id(71,1); $this->rapyd->load("datafilter", "datagrid"); $this->load->helper('form'); //$this->rapyd->uri->keep_persistence(); $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->p_modbus($mBANC, "banc"); $from = "(\n\t\t\tSELECT 'r_mbancrel' tipo,id,codbanc,tipo_doc,cheque,monto,fecha,fechaing,concepto,id_mbanc \n\t\t\tFROM r_mbancrel\n\t\t\t\n\t\t\tUNION ALL\n\n\t\t\tSELECT 'r_mbanc' tipo,a.id,a.codbanc,a.tipo_doc,a.cheque,a.monto,a.fecha,MAX(c.fecha) fechaing,GROUP_CONCAT(c.numero SEPARATOR ' ') concepto,id_mbanc \n\t\t\tFROM r_mbanc a\n\t\t\tJOIN r_abonosit b ON a.abono=b.abono\n\t\t\tJOIN r_recibo c ON b.recibo=c.id\n\t\t\tWHERE a.tipo_doc='DP'\n\t\t\tGROUP BY a.id\n\t\t\t\n\t\t)t"; $filter = new DataFilter(""); $filter->db->select(array("t.id_mbanc", "t.tipo", "t.id", "t.codbanc", "t.tipo_doc", "t.cheque", "t.monto", "t.fecha", "t.fechaing", "t.concepto", "b.numcuent", "b.banco")); $filter->db->from($from); $filter->db->join("banc b", "b.codbanc=t.codbanc"); //$filter->db->where("LENGTH(a.id_mbancrel )=0 OR a.id_mbancrel IS NULL"); //$filter->db->orderby("a.cheque"); //$filter->db->where("a.tipo =", "Trabajo"); $filter->fecha = new dateonlyField("Fecha", "fecha"); $filter->fecha->size = 12; $filter->fecha->clause = 'where'; $filter->fecha->operator = '='; $filter->fechaing = new dateonlyField("Fecha Ingreso", "fechaing"); $filter->fechaing->size = 12; $filter->fechaing->clause = 'where'; $filter->fechaing->operator = '='; $filter->codbanc = new inputField("Banco", 'codbanc'); $filter->codbanc->size = 6; $filter->codbanc->append($bBANC); $filter->codbanc->db_name = "a.codbanc"; $filter->tipo_doc = new dropdownField("Tipo Documento", "tipo_doc"); $filter->tipo_doc->db_name = 'tipo_doc'; $filter->tipo_doc->style = "width:130px;"; $filter->tipo_doc->option("", ""); $filter->tipo_doc->option("EF", "Efectivo"); $filter->tipo_doc->option("DP", "Deposito"); $filter->tipo_doc->option("DB", "Tarjeta Débito"); $filter->tipo_doc->option("CR", "Tarjeta Credito"); $filter->tipo_doc->option("DF", "Diferencia"); $filter->tipo = new dropdownField("Origen", "tipo"); $filter->tipo->style = "width:130px;"; $filter->tipo->option("", ""); $filter->tipo->option("r_mbancrel", "Relaciones"); $filter->tipo->option("r_mbanc", "Cobranzas"); $filter->buttons("reset", "search"); $filter->build(); $total = new inputField("Total", "total"); $total->status = "create"; $total->size = 15; $total->build(); $salida = $total->label . $total->output; $grid = new DataGrid(""); function sel($numero, $tipo) { return form_checkbox('data[]', $tipo . '_._' . $numero); } $codbanc = new inputField("Cod Banco", "codbanc"); $codbanc->grid_name = 'codbanc_<#tipo#>_<#id#>'; $codbanc->status = 'modify'; $codbanc->size = 12; $codbanc->type = 'inputhidden'; $fecha = new inputField("Fecha", "fecha"); $fecha->grid_name = 'fecha_<#tipo#>_<#id#>'; $fecha->status = 'modify'; $fecha->size = 12; $fecha->type = 'inputhidden'; $fechaing = new inputField("Fecha Ingreso", "fechaing"); $fechaing->grid_name = 'fechaing_<#tipo#>_<#id#>'; $fechaing->status = 'modify'; $fechaing->size = 12; $fechaing->type = 'inputhidden'; $tipo_doc = new inputField("Tipo Documento", "tipo_doc"); $tipo_doc->grid_name = 'tipo_doc_<#tipo#>_<#id#>'; $tipo_doc->status = 'modify'; $tipo_doc->size = 12; $tipo_doc->type = 'inputhidden'; $cheque = new inputField("Transaccion", "cheque"); $cheque->grid_name = 'cheque_<#tipo#>_<#id#>'; $cheque->status = 'modify'; $cheque->size = 12; $monto = new inputField("Monto", "monto"); $monto->grid_name = 'monto_<#tipo#>_<#id#>'; $monto->status = 'modify'; $monto->size = 12; $monto->css_class = 'inputnum'; $monto->readonly = true; $concepto = new textAreaField("Concepto", "concepto"); $concepto->grid_name = 'concepto_<#tipo#>_<#id#>'; $concepto->status = 'modify'; $concepto->rows = 1; $concepto->cols = 15; $data = array('name' => 'todo', 'id' => 'todo', 'checked' => FALSE, 'style' => 'margin:10px'); $salida1 = form_checkbox($data); $atts3 = array('width' => '640', 'height' => '480', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5'); $uri = anchor_popup('tesoreria/mbanc/dataedit/show/<#id_mbanc#>', '<#id_mbanc#>', $atts3); $grid = new DataGrid($salida); $grid->order_by("cheque", "asc"); $grid->per_page = 100; $grid->use_function('substr', 'str_pad', 'sel', 'nformat'); $grid->column($salida1, "<sel><#id#>|<#tipo#></sel>"); $grid->column_orderby("Cod. Banco", $codbanc, "codbanc", "align='left' "); $grid->column_orderby("Banco", "banco", "banco", "align='left' "); $grid->column_orderby("Cuenta", "numcuent", "numcuent", "align='left' "); $grid->column_orderby("Transaccion", $cheque, "cheque", "align='left' "); $grid->column_orderby("Fecha", $fecha, "fecha", "align='center'"); $grid->column_orderby("Fecha Ingreso", $fechaing, "fechaing", "align='center'"); $grid->column_orderby("Tipo Doc", $tipo_doc, "tipo_doc", "align='center'"); $grid->column_orderby("Monto", $monto, "monto", "align='right' "); $grid->column_orderby("Concepto", $concepto, "concepto", "align='left' "); $grid->column_orderby("Mov Bancario", $uri, "id_mbanc", "align='left' "); $grid->build(); //echo $grid->db->last_query(); $salida = form_open($this->url . 'guarda'); $salida .= $grid->output; $salida .= form_submit('Pasar Datos', 'Pasar Datos'); $salida .= form_close(); $data['filtro'] = $filter->output; $data['content'] = $salida; $data['script'] = script("jquery.js") . "\n"; $data['script'] = '<script language="javascript" type="text/javascript">'; $data['script'] .= ' function suma(){ t=0; $(":checkbox").each(function(i,val){ name =val.name; if(name.substring(0,4)=="data"){ if(val.checked==true){ monto=parseFloat($("#monto_"+val.value).val()); tipo =val.name.substr(2,2); t=t+monto; } } }); $("#total").val(Math.round(t*100)/100); } $(document).ready(function(){ suma(); $("#todo").change(function(){ console.log("aaa"); var ch=$(this).is(":checked"); $(":checkbox").each(function(i,val){ if(ch==true){ val.checked=true; }else{ val.checked=false; } }); }); $(":checkbox").change(function(){ suma(); }); });'; $data['script'] .= '</script>'; $data['title'] = "Seleccione las Movimientos Bancarios "; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $this->load->view('view_ventanas', $data); }
function selectr_mbanc() { //$this->datasis->modulo_id(71,1); $this->rapyd->load("datafilter", "datagrid"); $this->load->helper('form'); //$this->rapyd->uri->keep_persistence(); $mBANC = array('tabla' => 'banc', 'columnas' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta'), 'filtro' => array('codbanc' => 'Cóodigo', 'banco' => 'Banco', 'numcuent' => 'Cuenta'), 'retornar' => array('codbanc' => 'codbanc'), 'where' => 'activo = "S"', 'titulo' => 'Buscar Bancos'); $bBANC = $this->datasis->p_modbus($mBANC, "banc"); $filter = new DataFilter(""); $filter->db->select(array("a.id", "a.abono", "a.codmbanc", "a.codbanc", "a.tipo_doc", "a.cheque", "a.monto", "a.fecha", "a.concepto", "a.id_mbancrel", "b.numcuent", "b.banco")); $filter->db->from("r_mbanc a"); $filter->db->join("banc b", "b.codbanc=a.codbanc", "left"); $filter->db->where("(LENGTH(a.id_mbancrel)=0 OR a.id_mbancrel IS NULL OR a.id_mbancrel=0)"); //OR a.id_mbancrel=0 #$filter->db->where("LENGTH(a.id_mbancrel )=0 OR a.id_mbancrel IS NULL"); //$filter->db->orderby("a.cheque"); //$filter->db->where("a.tipo =", "Trabajo"); $filter->fecha = new dateonlyField("Fecha", "fecha"); $filter->fecha->size = 12; $filter->fecha->clause = 'where'; $filter->fecha->operator = '='; $filter->codbanc = new inputField("Banco", 'codbanc'); $filter->codbanc->size = 6; $filter->codbanc->append($bBANC); $filter->codbanc->db_name = "a.codbanc"; $filter->tipo_doc = new dropdownField("Tipo Documento", "tipo_doc"); $filter->tipo_doc->db_name = 'tipo_doc'; $filter->tipo_doc->style = "width:130px;"; $filter->tipo_doc->option("", ""); $filter->tipo_doc->option("EF", "Efectivo"); $filter->tipo_doc->option("DP", "Deposito"); $filter->tipo_doc->option("DB", "Tarjeta Débito"); $filter->tipo_doc->option("CR", "Tarjeta Credito"); $filter->tipo_doc->option("DF", "Diferencia"); $filter->buttons("reset", "search"); $filter->build(); $total = new inputField("Total", "total"); $total->status = "create"; $total->size = 15; $total->build(); $salida = $total->label . $total->output; $iralfiltropagoc = anchor($this->url . 'filteredgrid', 'Ir al Filtro'); $grid = new DataGrid($iralfiltropagoc); function sel($numero) { return form_checkbox('data[]', $numero); } $monto = new inputField("Monto", "monto"); $monto->grid_name = 'monto<#id#>'; $monto->status = 'modify'; $monto->size = 12; $monto->css_class = 'inputnum'; $monto->readonly = true; $data = array('name' => 'todo', 'id' => 'todo', 'checked' => FALSE, 'style' => 'margin:10px'); $salida1 = form_checkbox($data); $grid = new DataGrid($iralfiltropagoc . "</br>" . $salida); $grid->order_by("cheque", "asc"); $grid->per_page = 1000; $grid->use_function('substr', 'str_pad', 'sel', 'nformat'); $grid->column($salida1, "<sel><#id#></sel>"); $grid->column_orderby("Cod. Banco", "codbanc", "codbanc", "align='left' "); $grid->column_orderby("Banco", "banco", "banco", "align='left' "); $grid->column_orderby("Cuenta", "numcuent", "numcuent", "align='left' "); $grid->column_orderby("Transaccion", "cheque", "cheque", "align='left' "); $grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'"); $grid->column_orderby("Tipo Doc", "tipo_doc", "tipo_doc", "align='center'"); $grid->column_orderby("Monto", $monto, "monto", "align='right' "); $grid->build(); $grid->db->last_query(); $salida = form_open($this->url . 'guarda'); $salida .= $grid->output; $salida .= form_submit('Crear Relacion', 'Crear Relacion'); $salida .= form_close(); $data['filtro'] = $filter->output; $data['content'] = $salida; $data['script'] = script("jquery.js") . "\n"; $data['script'] = '<script language="javascript" type="text/javascript">'; $data['script'] .= ' function suma(){ t=0; $(":checkbox").each(function(i,val){ name =val.name; console.log("substr"+name.substring(0,4)); if(name.substring(0,4)=="data"){ if(val.checked==true){ monto=parseFloat($("#monto"+val.value).val()); tipo =val.name.substr(2,2); t=t+monto; } } }); $("#total").val(Math.round(t*100)/100); } $(document).ready(function(){ suma(); $("#todo").change(function(){ console.log("aaa"); var ch=$(this).is(":checked"); console.log("aaa"+ch); $(":checkbox").each(function(i,val){ if(ch==true){ val.checked=true; }else{ val.checked=false; } }); }); $(":checkbox").change(function(){ suma(); }); });'; $data['script'] .= '</script>'; $data['title'] = "Seleccione las Movimientos Bancarios "; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $this->load->view('view_ventanas', $data); }