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