function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
$filter = new DataFilter("Filtro de Busqueda", 'sitemslog');
$filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y');
$filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
$filter->fechad->clause = $filter->fechah->clause = "where";
$filter->fechad->db_name = $filter->fechah->db_name = "fecha";
$filter->fechad->size = $filter->fechah->size = 12;
$filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y")));
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechad->operator = ">=";
$filter->fechah->operator = "<=";
$filter->cajero = new dropdownField("Cajero", "cajero");
$filter->cajero->option('', 'Todos');
$filter->cajero->options("Select cajero, nombre as value from scaj ");
$filter->cajero->style = 'width:150px;';
$filter->vendedor = new dropdownField("Vendedor", "vendedor");
$filter->vendedor->option('', 'Todos');
$filter->vendedor->options("Select vendedor, nombre from vend ");
$filter->vendedor->style = 'width:150px;';
$filter->buttons("reset", "search");
$filter->build();
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$grid = new DataGrid("Resultados");
$grid->per_page = 15;
$uri = anchor_popup('supervisor/sitemslog/detalle/<#id#>', '<#id#>', $atts);
$grid->column("Numero", $uri);
$grid->column("Fecha", "<b><dbdate_to_human><#fecha#></dbdate_to_human></b>", 'fecha', "align='center'");
$grid->column("Cajero", "cajero");
$grid->column("Vendedor", "vendedor");
$grid->column("Tipo", "tipo");
$grid->column("Cliente", "cod_cli");
$grid->column("Hora", "<#hora#>", 'hora', "align='center'");
$grid->build();
//echo $grid->db->last_query();
$tabla = $grid->output;
} else {
$tabla = '';
}
$data['content'] = $filter->output . $tabla;
$data['title'] = "<h1>Log de Ventas</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Filtro de Busqueda", 'logusu');
//$filter->db->select(array());
$filter->usuario = new dropdownField("Usuario", "usuario");
$filter->usuario->option('', 'Todos');
$filter->usuario->options("Select usuario, usuario as value from logusu group by usuario");
$filter->usuario->style = 'width:150px;';
$filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y');
$filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
$filter->fechad->clause = $filter->fechah->clause = "where";
$filter->fechad->db_name = $filter->fechah->db_name = "fecha";
$filter->fechad->size = $filter->fechah->size = 12;
$filter->fechad->insertValue = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y")));
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechad->operator = ">=";
$filter->fechah->operator = "<=";
$filter->modulo = new inputField("Módulo", "modulo");
$filter->modulo->size = 6;
$filter->referencia = new inputField("Referencia", "comenta");
$filter->referencia->size = 60;
$filter->buttons("reset", "search");
$filter->build();
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$grid = new DataGrid("Resultados");
$grid->per_page = 15;
$grid->column_orderby("Usuario", "usuario", 'usuario');
$grid->column_orderby("Fecha", "<b><dbdate_to_human><#fecha#></dbdate_to_human></b>", 'fecha', "align='center'");
$grid->column_orderby("Hora", "<#hora#>", 'hora', "align='center'");
$grid->column_orderby("Módulo", "modulo", 'modulo');
$grid->column_orderby("Acción", "comenta", 'comenta');
$grid->build();
//echo $grid->db->last_query();
$tabla = $grid->output;
} else {
$tabla = '';
}
$data['content'] = $filter->output . $tabla;
$data['title'] = "<h1>Log de Usuarios</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
$bool = $this->db->query("CREATE TABLE PRENOM{$contra} SELECT * FROM {$tabla}");
if ($bool) {
echo "_Si";
}
}
function montos()
{
$this->rapyd->load('datagrid', 'fields', 'datafilter');
$error = '';
if ($this->input->post('pros') !== FALSE) {
$concepto = $this->input->post('concepto');
$conceptoe = $this->db->escape($concepto);
$pmontos = $this->input->post('monto');
//$this->load->library('pnomina');
$formula = $this->datasis->dameval("SELECT formula FROM conc WHERE concepto={$conceptoe}");
foreach ($pmontos as $cod => $cant) {
if (!is_numeric($cant)) {
$error .= "{$cant} no es un valor num&erico;rico<br>";
} else {
$this->actualizaprenom($cod, $cant, $concepto, $formula);
$this->calculaprenom(false, $cod);
}
}
}
$filter = new DataFilter(" ", 'prenom');
$filter->error_string = $error;
$filter->concepto = new dropdownField("Concepto", "concepto");
$filter->concepto->option("", "Seleccionar");
$filter->concepto->options("SELECT concepto,CONCAT_WS(' ',concepto,descrip) descrip FROM prenom WHERE formula like '%XMONTO%' GROUP BY concepto ORDER BY descrip");
$filter->concepto->clause = "where";
$filter->concepto->operator = "=";
$filter->concepto->rule = "required";
$filter->buttons("reset", "search");
$filter->build();
$ggrid = '';
if ($filter->is_valid()) {
$ggrid = form_open('/nomina/prenom/montos/search/osp');
$ggrid .= form_hidden('concepto', $filter->concepto->newValue);
$monto = new inputField("Monto", "monto");
$monto->grid_name = 'monto[<#codigo#>]';
$monto->status = 'modify';
$monto->size = 12;
$monto->css_class = 'inputnum';
$grid = new DataGrid("Concepto (" . $filter->concepto->newValue . ") " . $filter->concepto->options[$filter->concepto->newValue]);
$grid->column("Código", "codigo");
$grid->column("Nombre", "nombre");
$grid->column("Monto", $monto, 'align=\'right\'');
$grid->column("Valor", 'valor', 'align=\'right\'');
$grid->submit('pros', 'Guardar', "BR");
$grid->build();
$ggrid .= $grid->output;
$ggrid .= form_close();
}
$script = '
<script type="text/javascript">
$(function() {
$(".inputnum").numeric(".");
});
</script>';
$data['content'] = $filter->output . anchor('nomina/prenom', 'Inicio') . $ggrid;
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter('Filtro de Búsqueda', 'sitemslog');
$filter->fechad = new dateonlyField('Rango de Fechas', 'fechad', 'd/m/Y');
$filter->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y');
$filter->fechad->clause = $filter->fechah->clause = 'where';
$filter->fechad->db_name = $filter->fechah->db_name = 'fecha';
$filter->fechad->size = $filter->fechah->size = 12;
//$filter->fechad->insertValue = date("Y-m-d",mktime(0, 0, 0, date("m"), date("d")-1, date("Y")));
$filter->fechad->insertValue = date('Y-m-d');
$filter->fechah->insertValue = date('Y-m-d');
$filter->fechad->operator = '>=';
$filter->fechah->operator = '<=';
$filter->fechah->in = 'fechad';
$filter->cajero = new dropdownField('Cajero', 'cajero');
$filter->cajero->option('', 'Todos');
$filter->cajero->options('SELECT cajero, nombre AS value FROM scaj ORDER BY cajero');
$filter->cajero->style = 'width:150px;';
$filter->vendedor = new dropdownField('Vendedor', 'vendedor');
$filter->vendedor->option('', 'Todos');
$filter->vendedor->options('SELECT vendedor, nombre FROM vend ORDER BY vendedor');
$filter->vendedor->style = 'width:150px;';
$filter->numero = new inputField('Número', 'numero');
$filter->numero->size = 15;
$filter->numero->maxlength = 15;
$filter->descrip = new inputField('Descripción', 'desca');
$filter->usuario = new dropdownField('Usuario', 'usuario');
$filter->usuario->option('', 'Todos');
$filter->usuario->options('SELECT us_codigo,CONCAT_WS(\'-\',us_codigo,us_nombre) AS val FROM usuario ORDER BY us_codigo');
$filter->usuario->style = 'width:150px;';
$filter->tipo = new dropdownField('Operación', 'tipo');
$filter->tipo->option('', 'Todos');
$filter->tipo->option('ABORTADO', 'ABORTADO');
$filter->tipo->option('AGREGA', 'AGREGA');
$filter->tipo->option('ELIMINADO', 'ELIMINADO');
$filter->tipo->option('MODIFICA', 'MODIFICA');
$filter->tipo->style = 'width:150px;';
$filter->buttons('reset', 'search');
$filter->build();
if ($this->rapyd->uri->is_set('search') and $filter->is_valid()) {
$grid = new DataGrid('Resultados');
$grid->per_page = 15;
$grid->column_orderby('Operación', 'tipo', 'tipo', 'align=\'left\'');
$grid->column_orderby('Numero', '<b><#tipoa#><#numa#></b>', 'numa', 'align=\'left\'');
$grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human> <#hora#>', 'fecha', 'align=\'center\'');
$grid->column_orderby('Código', 'codigoa', 'codigoa', 'align=\'left\'');
$grid->column_orderby('Descripción', 'desca', 'desca', 'align=\'left\'');
$grid->column_orderby('Cantidad', '<nformat><#cana#></nformat>', 'cana', 'align=\'right\'');
$grid->column_orderby('Precio', '<format><#preca#></nformat>', 'preca', 'align=\'right\'');
$grid->column_orderby('Total', '<nformat><#tota#></nformat>', 'tota', 'align=\'right\'');
$grid->column_orderby('Vendedor', 'vendedor', 'vendedor', 'align=\'center\'');
$grid->column_orderby('Cajero', 'cajero', 'cajero', 'align=\'center\'');
$grid->column_orderby('Usuario', 'usuario', 'usuario');
$grid->build();
$tabla = $grid->output;
$sq = preg_replace('/LIMIT +[0-9]+[, ]*[0-9]*/', '', $grid->db->last_query());
$sq = raencode(base64_encode($this->encrypt->encode($sq)));
$tabla .= anchor('xlsauto/repo64/' . $sq, 'Descargar a Excell');
} else {
$tabla = '';
}
$data['content'] = $filter->output . $tabla;
$data['title'] = heading('Bitácora de Facturación');
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function montos()
{
$this->rapyd->load('datagrid', 'fields', 'datafilter');
/*$this->load->library('form_validation');
if ($this->form_validation->run() == FALSE){
$this->load->view('myform');
}else{
$this->load->view('formsuccess');
}*/
$error = '';
if ($this->input->post('pros') !== FALSE) {
$concepto = $this->db->escape($this->input->post('concepto'));
$pmontos = $this->input->post('monto');
foreach ($pmontos as $cod => $cant) {
$cod = $this->db->escape($cod);
if (!is_numeric($cant)) {
$error .= "{$cant} no es un valor numerico<br>";
} else {
$data = array('monto' => $cant);
$where = "codigo = {$cod} AND concepto ={$concepto} ";
$mSQL = $this->db->update_string('prenom', $data, $where);
$this->db->simple_query($mSQL);
}
}
}
$filter = new DataFilter(" ", 'prenom');
$filter->error_string = $error;
$filter->concepto = new dropdownField("Concepto", "concepto");
$filter->concepto->option("", "Seleccionar");
$filter->concepto->options("SELECT concepto,descrip FROM prenom GROUP BY concepto ORDER BY descrip");
$filter->concepto->clause = "where";
$filter->concepto->operator = "=";
$filter->concepto->rule = "required";
$filter->buttons("reset", "search");
$filter->build();
$ggrid = '';
if ($filter->is_valid()) {
$ggrid = form_open('/nomina/prenom/montos/search/osp');
$ggrid .= form_hidden('concepto', $filter->concepto->newValue);
$monto = new inputField("Monto", "monto");
$monto->grid_name = 'monto[<#codigo#>]';
$monto->status = 'modify';
$monto->size = 12;
$monto->css_class = 'inputnum';
$grid = new DataGrid("Concepto (" . $filter->concepto->newValue . ") " . $filter->concepto->options[$filter->concepto->newValue]);
//$grid->db->where('concepto','015');
//$grid->per_page = $filter->db->num_rows() ;
$grid->column("Código", "codigo");
$grid->column("Nombre", "nombre");
$grid->column("Monto", $monto, 'align=\'right\'');
$grid->submit('pros', 'Guardar', "BR");
$grid->build();
$ggrid .= $grid->output;
$ggrid .= form_close();
}
$script = '
<script type="text/javascript">
$(function() {
$(".inputnum").numeric(".");
});
</script>';
$data['content'] = $filter->output . $ggrid;
$data['title'] = '<h1>Asignación de montos</h1>';
$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 copia($usua = null)
{
$this->rapyd->load("datafilter", "datagrid");
$usuario = $usua;
function ractivo($acceso, $codigo)
{
if ($acceso == 'S') {
$retorna = form_checkbox($codigo, 'accept', TRUE);
} else {
$retorna = form_checkbox($codigo, 'accept', FALSE);
}
return $retorna;
}
$filter = new DataFilter("");
$filter->db->select(array("b.modulo", 'b.codigo', "a.usuario", "a.usuario as value", "a.acceso", "b.titulo"));
$filter->db->from("sida AS a");
$filter->db->join("tmenus AS b", "a.modulo=b.codigo");
$filter->db->orderby("b.modulo");
$filter->usuario = new dropdownField("Copiar de", "usuario");
$filter->usuario->options("Select us_codigo as value,CONCAT_WS(' - ', us_codigo, us_nombre) as codigo from usuario group by us_codigo");
$filter->usuario->style = 'width:250px;';
$filter->buttons("reset", "search");
$filter->build();
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$usr = $filter->usuario->newValue;
$mSQL = "INSERT IGNORE INTO sida SELECT '{$usr}',b.codigo,'N' FROM sida AS a RIGHT JOIN tmenus AS b ON a.modulo=b.codigo AND a.usuario='{$usr}' WHERE a.modulo IS NULL";
$this->db->simple_query($mSQL);
$copiar = anchor("supervisor/acdatasis/copiar/{$usr}/{$usuario}", 'Copiar');
$grid = new Datagrid("Resultados");
$grid->use_function('ractivo');
$link = site_url('/supervisor/acdatasis/activar');
//$grid->per_page = 15;
$grid->column("Módulo", "modulo");
$grid->column("Nombre", "titulo");
$grid->column("Acceso", "<ractivo><#acceso#>|<#codigo#>|</ractivo>", 'align="center"');
$grid->build();
$tabla = $copiar . $grid->output;
//echo $grid->db->last_query();
$url = site_url('supervisor/acdatasis/activar');
$data['script'] = '<script type="text/javascript">
$(document).ready(function() {
$("form :checkbox").click(function () {
usr=$("#usuario").attr("value");
$.ajax({type: "POST",
url: "' . $url . '",
data: "codigo="+this.name+"&usuario="+usr,
success: function(msg){
if (msg==0)
alert("Ocurrio un problema");
}
});
}).change();
});
</script>';
} else {
$tabla = '';
}
$data['content'] = ' Usuario:' . $usuario . $filter->output . form_open('') . $tabla . form_close();
$data['title'] = "<h1>Copiar Accesos de Usuario en DataSIS</h1>";
$data["head"] = script("jquery.js") . $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->rapyd->load('datafilter', 'datagrid');
$link = site_url('supervisor/sfacfiscal/arreglaserial');
$linkd = site_url('supervisor/sfacfiscal/arreglaserialdev');
$link2 = site_url('supervisor/sfacfiscal/arreglanfiscal');
$link4 = site_url('supervisor/sfacfiscal/arreglanfiscaldev');
$link3 = site_url('supervisor/sfacfiscal/traereferen');
$jquery = '
function riega(id){
if(confirm("Esta seguro que regar el serial para las facturas?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $link . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), serial:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function riegadev(id){
if(confirm("Esta seguro que regar el serial por las devoluciones?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $linkd . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), serial:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function nfiscal(id){
if(confirm("Esta seguro que regar el numero fiscal?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $link2 . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), numero:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function nfiscaldev(id){
if(confirm("Esta seguro que regar el numero fiscal?")){
if(confirm("Desea cambiar solo los registros vacios?"))
resp=0;
else
resp=1;
$.post("' . $link4 . '",{ cajero:$("#cajero").val(),fecha:$("#fecha").val(), numero:id ,noresp:resp, nulos:$("#nulos").val(),usuario:$("#usuario").val()},
function(data){
alert(data);
});
}
}
function buscaref(){
referenc = prompt("Introduce una referencia");
$.post("' . $link3 . '",{ referen: referenc },
function(data){
alert(data);
});
}';
function exissinv($cen, $t, $tipo_doc)
{
if (!empty($cen)) {
if ($t == 1) {
if ($tipo_doc == 'F') {
$rt = form_button('asignar', $cen, 'onclick="riega(\'' . $cen . '\');"');
} else {
$rt = form_button('asignar', $cen, 'onclick="riegadev(\'' . $cen . '\');"');
}
} else {
if ($tipo_doc == 'F') {
$rt = form_button('asignar', $cen, 'onclick="nfiscal(\'' . $cen . '\');"');
} else {
$rt = form_button('asignar', $cen, 'onclick="nfiscaldev(\'' . $cen . '\');"');
}
}
} else {
$rt = '--';
}
return $rt;
}
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0');
$filter = new DataFilter('', 'sfac');
//$filter->db->where('tipo_doc','F');
$filter->script($jquery);
$filter->fecha = new dateonlyField('Desde', 'fecha');
$filter->fecha->clause = 'where';
$filter->fecha->db_name = 'fecha';
$filter->fecha->insertValue = date('Y-m-d');
$filter->fecha->operator = '=';
$filter->fecha->rule = 'required|chfecha';
$filter->fecha->append("<a onclick='buscaref()'>Traer de referencia</a>");
$filter->cajero = new dropdownField('Cajero', 'cajero');
$filter->cajero->option('', 'Seleccionar');
$filter->cajero->option(' ', 'Creditos');
$filter->cajero->options('SELECT cajero, CONCAT_WS("-",cajero,nombre) FROM scaj ORDER BY cajero');
$filter->usuario = new dropdownField('Usuario', 'usuario');
$filter->usuario->option('', 'Todos');
$filter->usuario->options('SELECT us_codigo AS cod,us_codigo FROM usuario ORDER BY us_codigo');
$filter->usuario->rule = 'condi_required|callback_chusuario';
$filter->tipo_doc = new dropdownField('Tipo Doc.', 'tipo_doc');
$filter->tipo_doc->option('F', 'Facturas');
$filter->tipo_doc->option('D', 'Devoluciones');
$filter->tipo_doc->rule = 'required|enum[D,F]';
$filter->nulos = new dropdownField('Filtrar seriales nulos', 'nulos');
$filter->nulos->option('s', 'Si');
$filter->nulos->option('n', 'No');
$filter->nulos->clause = '';
$filter->nulos->group = 'No afecta el filtro';
$filter->nulos->append('Si se activa esta opcion no se riega el número en los campos donde el serial de la máquina fiscal es nulo');
$filter->nulos->rule = 'enum[s,n]';
$filter->buttons('reset', 'search');
$filter->build();
if ($this->rapyd->uri->is_set('search') && $filter->is_valid()) {
$fecha = $filter->fecha->newValue;
$dbfecha = $this->db->escape($fecha);
$fields = $this->db->field_data('sfac');
$ppk = array();
foreach ($fields as $field) {
if ($field->primary_key == 1) {
$ppk[] = '<#' . $field->name . '#>';
}
}
$llink = anchor('supervisor/sfacfiscal/editsfac/modify/' . implode('/', $ppk), '<#tipo_doc#><#numero#>');
$uri2 = anchor_popup('formatos/verhtml/FACTURA/<#tipo_doc#>/<#numero#>', 'Ver HTML', $atts);
$grid = new DataGrid('');
$grid->use_function('exissinv');
$grid->per_page = 30;
$grid->db->orderby('numero');
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha');
$grid->column('Nombre', 'nombre');
$grid->column('Referencia', $llink);
$grid->column('Usuario', 'usuario');
$grid->column('Cajero', 'cajero');
$grid->column('Monto', '<nformat><#totalg#></nformat>', 'align="right"');
$grid->column('N.Fiscal', '<exissinv><#nfiscal#>|2|<#tipo_doc#></exissinv>', 'align="center"');
$grid->column('Serial Maq.', '<exissinv><#maqfiscal#>|1|<#tipo_doc#></exissinv>', 'align="center"');
$grid->column('Ver factura', $uri2, 'align="center"');
$grid->build();
//echo $grid->db->last_query();
$mSQL = $grid->db->last_query();
$mSQL = str_replace('*', 'SUM(totalg)', $mSQL);
$corte = stripos($mSQL, 'ORDER');
if ($corte !== false) {
$mSQL = substr($mSQL, 0, $corte);
}
$monto = $this->datasis->dameval($mSQL);
$tabla = 'Monto: ' . nformat($monto) . $grid->output;
$mSQL = 'SELECT COUNT(*) AS cana,serial, MAX(factura) AS factura,MAX(ncnumero) AS ncnumero,SUM(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) AS total FROM fiscalz WHERE fecha=' . $dbfecha . ' GROUP BY serial';
$query = $this->db->query($mSQL);
foreach ($query->result() as $row) {
$tabla .= $row->serial . ' x' . $row->cana . ' - F' . $row->factura . ' - D' . $row->ncnumero . ' - ' . nformat($row->total) . br();
}
} else {
$tabla = '<div class="alert">' . $filter->error_string . '</div>';
}
//if(strlen($filter->error_string)) $data['error']=$filter->error_string;
$data['content'] = $filter->output . $tabla;
$data['title'] = '<h1>Arreglos de consistencias fiscal en facturas</h1>';
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$this->load->view('view_ventanas', $data);
}
function montos()
{
$this->rapyd->load('datagrid', 'fields', 'datafilter');
$error = '';
if ($this->input->post('pros') !== false) {
$concepto = $this->db->escape($this->input->post('concepto'));
$pmontos = $this->input->post('monto');
$this->load->library('pnomina');
$formula = $this->datasis->dameval("SELECT formula FROM conc WHERE concepto={$concepto}");
foreach ($pmontos as $cod => $cant) {
if (!is_numeric($cant)) {
$error .= "{$cant} no es un valor numérico<br>";
} else {
$this->pnomina->CODIGO = $cod;
$this->pnomina->MONTO = $cant;
//$valor=0;
$valor = $this->pnomina->evalform($formula);
$cod = $this->db->escape($cod);
$data = array('monto' => $cant, 'valor' => $valor);
$where = "codigo = {$cod} AND concepto ={$concepto} ";
$mSQL = $this->db->update_string('prenom', $data, $where);
$this->db->simple_query($mSQL);
}
}
}
$filter = new DataFilter(' ', 'prenom');
$filter->error_string = $error;
$filter->concepto = new dropdownField('Concepto', 'concepto');
$filter->concepto->option('', 'Seleccionar');
$filter->concepto->options("SELECT concepto,descrip FROM prenom GROUP BY concepto ORDER BY descrip");
$filter->concepto->clause = 'where';
$filter->concepto->operator = '=';
$filter->concepto->rule = 'required';
$filter->buttons('reset', 'search');
$filter->build();
$ggrid = '';
if ($filter->is_valid()) {
$ggrid = form_open('/nomina/prenom/montos/search/osp');
$ggrid .= form_hidden('concepto', $filter->concepto->newValue);
$monto = new inputField('Monto', 'monto');
$monto->grid_name = 'monto[<#codigo#>]';
$monto->status = 'modify';
$monto->size = 12;
$monto->css_class = 'inputnum';
$grid = new DataGrid("Concepto (" . $filter->concepto->newValue . ") " . $filter->concepto->options[$filter->concepto->newValue]);
$grid->column('Código', 'codigo');
$grid->column('Nombre', 'nombre');
$grid->column('Monto', $monto, 'align=\'right\'');
$grid->column('Valor', 'valor', 'align=\'right\'');
$grid->submit('pros', 'Guardar', 'BR');
$grid->build();
$ggrid .= $grid->output;
$ggrid .= form_close();
}
$script = '
<script type="text/javascript">
$(function() {
$(".inputnum").numeric(".");
});
</script>';
$data['content'] = $filter->output . $ggrid;
$data['title'] = '<h1>Asignación de montos</h1>';
$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 index()
{
//SELECT * FROM bmov
//WHERE codbanc='01' AND EXTRACT(YEAR_MONTH FROM fecha)<=201004 AND anulado!='S' AND liable!='N' AND
//(concilia=0 OR EXTRACT(YEAR_MONTH FROM concilia)>=20100430 OR concilia<fecha)
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter('');
$filter->db->from('bmov');
$filter->db->where('anulado !=', 'S');
$filter->db->where('liable !=', 'N');
$filter->mes = new dropdownField('Fecha', 'mes');
$filter->mes->clause = '';
$filter->mes->rule = 'required';
$filter->mes->style = 'width:50px';
for ($i = 1; $i <= 12; $i++) {
$mmes = str_pad($i, 2, '0', STR_PAD_LEFT);
$filter->mes->option($mmes, $mmes);
}
$filter->anio = new inputField('Año', 'anio');
$filter->anio->rule = 'required';
$filter->anio->clause = '';
$filter->anio->in = 'mes';
$filter->anio->size = 5;
$filter->banco = new dropdownField('Banco', 'codbanc');
$filter->banco->rule = 'required';
$filter->banco->clause = 'where';
$filter->banco->option('', 'Seleccionar');
$filter->banco->options('SELECT codbanc AS CLAVE, banco FROM banc WHERE CHAR_LENGTH(tbanco)>0 ORDER BY banco');
$filter->banco->operator = '=';
$filter->tipo_op = new dropdownField('Tipo de Operacion', 'tipo_op');
$filter->tipo_op->option('', 'Todos');
$filter->tipo_op->option('NC', 'Nota de Crédito');
$filter->tipo_op->option('ND', 'Nota de Debito');
$filter->tipo_op->option('DE', 'Deposito');
/*$filter->concilia = new dropdownField('Conciliado', 'concilia');
$filter->concilia->option('','Todos');
$filter->concilia->option('S','Si');
$filter->concilia->option('N','No');*/
//$filter->submit('btnsubmit','Descargar');
$filter->buttons('search');
$filter->build();
if ($this->rapyd->uri->is_set('search') and $filter->is_valid()) {
function conci($conci, $codbanc, $tipo_op, $numero, $fecha)
{
$fech = explode('-', $conci);
$arr = array($codbanc, $tipo_op, $numero, $fecha);
if ($fech[0] + $fech[1] + $fech[2] == 0) {
return form_checkbox($codbanc . $tipo_op . $numero, serialize($arr));
} else {
return form_checkbox($codbanc . $tipo_op . $numero, serialize($arr), TRUE) . dbdate_to_human($conci);
}
}
$fecha = $filter->anio->newValue . $filter->mes->newValue . days_in_month($filter->mes->newValue);
$grid = new DataGrid('Efectos por conciliar');
$grid->use_function('conci');
$grid->order_by('fecha', 'desc');
$grid->per_page = 15;
$grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha', 'align=\'center\'');
$grid->column_orderby('Numero', 'numero', 'numero');
$grid->column_orderby('Descripción', 'nombre', 'nombre');
$grid->column_orderby('Monto', '<nformat><#monto#></nformat>', 'monto', 'align=\'right\'');
$grid->column_orderby('Conciliado', "<conci><#concilia#>|<#codbanc#>|<#tipo_op#>|<#numero#>|{$fecha}</conci>", 'concilia', 'align=\'center\'');
$grid->build();
//echo $grid->db->last_query();
$ggrid = $grid->output;
} else {
$ggrid = '';
}
$data['content'] = $filter->output . $ggrid;
$data['title'] = '<h1>Conciliaciones de Bancos</h1>';
$data['script'] = '<script language="javascript" type="text/javascript">';
$data['script'] .= '
$(document).ready(function(){
$(":checkbox").change(function(){
name=$(this).attr("name");
$.post("' . site_url('finanzas/conci/cconci') . '",{ data: $(this).val()},
function(data){
if(data=="1"){
return true;
}else{
$("input[name=\'"+name+"\']").removeAttr("checked");
alert("Hubo un error, comuniquese con soporte tecnico");
return false;
}
});
});
});';
$data['script'] .= '</script>';
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid2');
function convierte($par, $link)
{
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5', 'style' => 'text-decoration:none;font-weight: bold;font-size:0.85em;color:#2357B5');
switch ($par) {
case '3I':
return anchor_popup($link, 'Ventas Caja', $atts);
break;
case '3R':
return anchor_popup($link, 'Ventas Restaurante', $atts);
break;
case '3M':
return anchor_popup($link, 'Ventas Mayor', $atts);
break;
case '1T':
return anchor_popup($link, 'Transferencias', $atts);
break;
case '2C':
return anchor_popup($link, 'Compras', $atts);
break;
case '4N':
return anchor_popup($link, 'Nota/Entrega', $atts);
break;
case '6C':
return anchor_popup($link, 'Conversión', $atts);
break;
case '5C':
return anchor_popup($link, 'Ajuste', $atts);
break;
case '5D':
return anchor_popup($link, 'Consignación', $atts);
break;
case '0F':
return anchor_popup($link, 'Inventario', $atts);
break;
case '9F':
return anchor_popup($link, 'Inventario', $atts);
break;
default:
return $par;
}
}
function colorgal($par)
{
switch ($par) {
case '3I':
return '( 0,163, 0, 0.4)';
break;
case '3R':
return '( 0,163, 0, 0.4)';
break;
case '3M':
return '( 0,163, 0, 0.4)';
break;
case '1T':
return '(255, 34, 5, 0.4)';
break;
case '2C':
return '(183, 84, 35, 0.4)';
break;
case '4N':
return '( 17, 19,148, 0.4)';
break;
case '6C':
return '( 0, 0, 0, 0.4)';
break;
case '5C':
return '( 65,185,255, 0.4)';
break;
case '5D':
return '(144, 0,255, 0.4)';
break;
case '0F':
return '(255,221, 0, 0.4)';
break;
case '9F':
return '(255,221, 0, 0.4)';
break;
default:
return '(255,255,255, 0.4)';
}
}
$modbus = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción', 'precio1' => 'Precio 1', 'precio2' => 'Precio 2', 'precio3' => 'Precio 3', 'precio4' => 'Precio 4'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar en inventario');
$boton = $this->datasis->modbus($modbus);
$maxfecha = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos");
if (!empty($maxfecha)) {
$corte = ' corte: <b>' . dbdate_to_human($maxfecha) . '</b>';
} else {
$corte = '';
}
$filter = new DataFilter('Kardex de Inventario ' . $corte);
//$script= '$(function(){ $("#kardextabla").columnHover(); });';
//$filter->script($script);
$filter->codigo = new inputField('Código ', 'codigo');
$filter->codigo->db_name = 'a.codigo';
$filter->codigo->rule = 'required';
$filter->codigo->operator = '=';
$filter->codigo->size = 25;
$filter->codigo->clause = 'where';
$filter->codigo->append($boton);
$filter->codigo->group = 'UNO';
$filter->ubica = new dropdownField('Almacén', 'ubica');
$filter->ubica->option('', 'Todos');
$filter->ubica->db_name = 'a.ubica';
$filter->ubica->options("SELECT ubica,CONCAT(ubica,' ',ubides) descrip FROM caub WHERE gasto='N'");
$filter->ubica->operator = '=';
$filter->ubica->clause = 'where';
$filter->ubica->group = 'UNO';
$filter->origen = new dropdownField('Orígen', 'origen');
$filter->origen->option('', 'Todos');
$filter->origen->option('3I', 'Ventas Caja');
$filter->origen->option('3R', 'Ventas Restaurante');
$filter->origen->option('3M', 'Ventas Mayor');
$filter->origen->option('1T', 'Transferencias');
$filter->origen->option('2C', 'Compras');
$filter->origen->option('4N', 'Nota/Entrega');
$filter->origen->option('6C', 'Conversión');
$filter->origen->option('5C', 'Ajuste de inventario');
$filter->origen->option('5D', 'Consignación');
$filter->origen->option('0F', 'Inv. Físico comienzo del día');
$filter->origen->option('9F', 'Inv. Físico final del día');
//$filter->origen->style = 'width:120px';
$filter->origen->group = 'UNO';
$filter->fechad = new dateonlyField('Desde', 'fecha', 'd/m/Y');
$filter->fechad->operator = '>=';
$filter->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - 30, date('Y')));
$filter->fechad->group = 'DOS';
$filter->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y');
$filter->fechah->db_name = 'fecha';
$filter->fechah->operator = '<=';
$filter->fechah->insertValue = date('Y-m-d');
$filter->fechah->group = 'DOS';
$filter->fechah->clause = $filter->fechad->clause = $filter->codigo->clause = 'where';
$filter->fechah->size = $filter->fechad->size = 10;
$filter->fechah->rule = $filter->fechad->rule = 'required|chfecha';
$filter->buttons('reset', 'search');
$filter->build('dataformfiltro');
$data['filtro'] = $filter->output;
$code = $this->input->post('codigo');
$data['content'] = '';
$cana = 0;
if ($code && $filter->is_valid()) {
$dbcode = $this->db->escape($code);
$mSQL = "SELECT CONCAT_WS(' ',TRIM(descrip),TRIM(descrip2)) descrip,existen,activo FROM sinv WHERE codigo={$dbcode}";
$query = $this->db->query($mSQL);
if ($query->num_rows() > 0) {
$row = $query->row();
$descrip = $row->descrip;
$activo = $row->activo;
$existen = floatval($row->existen);
$actual = $this->datasis->dameval("SELECT SUM(existen) AS cana FROM itsinv WHERE codigo={$dbcode}");
if (floatval($actual) != $existen) {
$this->db->simple_query("UPDATE sinv SET existen={$actual} WHERE codigo={$dbcode}");
}
} else {
$activo = 'N';
$descrip = 'No encontrado.';
$existen = 0;
}
$link = "/inventario/kardex/grid/<#origen#>/<dbdate_to_human><#fecha#>|Ymd</dbdate_to_human>/<raencode><#codigo#></raencode>/<raencode><#ubica#></raencode>";
$grid = new DataGrid2("Producto: ({$code}) {$descrip}");
$grid->table_id = 'kardextabla';
$grid->agrupar(' ', 'almacen');
$grid->use_function('convierte', 'str_replace', 'colorgal');
$grid->db->select(array('IFNULL( b.ubides , a.ubica ) almacen', 'a.ubica', 'a.fecha', 'a.venta', 'a.cantidad', 'a.saldo', 'a.monto', 'a.salcant', 'TRIM(a.codigo) AS codigo', 'a.origen', 'a.promedio', '(a.venta/a.cantidad)*(a.cantidad>0) AS vpromedio', 'ROUND(100-(a.promedio*100/(a.venta/a.cantidad)),2)*(a.origen="3I") AS vmargen', '((a.venta/a.cantidad)-a.promedio)*a.cantidad*(a.origen="3I") AS vutil', 'c.activo', 'c.grupo'));
$grid->db->from('costos a');
$grid->db->join('caub b', 'b.ubica=a.ubica', 'LEFT');
$grid->db->join('sinv c', 'a.codigo=c.codigo', 'LEFT');
$grid->db->orderby('almacen, fecha, origen');
$grid->per_page = 60;
$grid->column('Orígen', '<p style="background-color: rgba<colorgal><#origen#></colorgal>;font-size:1.3em;font-weight: bold;margin:0px;padding:0px;border:0px;"><convierte><#origen#>|' . $link . '</convierte></p>', 'align=\'left\' nowrap');
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>');
$grid->column('Cantidad', '<nformat><#cantidad#></nformat>', 'align=\'right\'');
$grid->column('<b style="color:#FFFFFF">Acumulado</b>', '<b style="font-size:1.3em"><nformat><#salcant#></nformat></b>', 'align=\'right\'');
$grid->column('Monto', '<nformat><#monto#></nformat>', 'align=\'right\'');
$grid->column('Saldo', '<nformat><#saldo#></nformat>', 'align=\'right\'');
$grid->column('Costo Prom.', '<nformat><#promedio#></nformat>', 'align=\'right\'');
$grid->column('Ventas', '<nformat><#venta#></nformat>', 'align=\'right\'');
$grid->column('Precio Prom.', '<nformat><#vpromedio#></nformat>', 'align=\'right\'');
$grid->column('Margen %', '<nformat><#vmargen#></nformat>', 'align=\'right\'');
$grid->column('Margen Bs.', '<nformat><#vutil#></nformat>', 'align=\'right\'');
$grid->build();
$data['content'] = '<h4 style="text-align:center;padding:0px;margin:0px;">Movimiento comprendido desde la fecha <b style="color:#000000; font-size:1.2em">' . $filter->fechad->value . '</b> Hasta <b style="color:#000000; font-size:1.2em">' . $filter->fechah->value . '</b></h4>';
$data['content'] .= $grid->output;
$ffinal = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos WHERE codigo={$dbcode}");
if (!empty($ffinal)) {
$dbfinal = $this->db->escape($ffinal);
$ventas = $this->datasis->dameval("SELECT SUM(IF(tipoa='D',-1,1)*cana) AS cana FROM sitems WHERE codigoa={$dbcode} AND fecha>{$dbfinal} AND MID(numa,1,1)<>'_' AND tipoa IN ('F','D')");
$compras = $this->datasis->dameval("SELECT SUM(IF(b.tipo_doc='ND',-1,1)*a.cantidad) AS cana FROM itscst AS a JOIN scst AS b ON a.control=b.control WHERE a.codigo={$dbcode} AND b.actuali>=b.fecha AND b.recep>{$dbfinal}");
$nentreg = $this->datasis->dameval("SELECT SUM(a.cana) AS cana FROM itsnte AS a JOIN snte AS b ON a.numero=b.numero WHERE a.codigo={$dbcode} AND estampa>{$dbfinal}");
$ajustes = $this->datasis->dameval("SELECT SUM(IF(b.tipo='E',1,-1)*cantidad) AS cana FROM itssal AS a JOIN ssal AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}");
$conver = $this->datasis->dameval("SELECT SUM(a.entrada-a.salida) AS cana FROM itconv AS a JOIN conv AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}");
if ($this->db->table_exists('itscon')) {
$consi = $this->datasis->dameval("SELECT SUM(IF(tipod='E',-1,1)*a.cana) AS cana FROM itscon AS a JOIN scon AS b ON a.id_scon=b.id WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}");
} else {
$consi = 0;
}
$ventas = empty($ventas) ? htmlnformat(0) : htmlnformat($ventas);
$compras = empty($compras) ? htmlnformat(0) : htmlnformat($compras);
$nentreg = empty($nentreg) ? htmlnformat(0) : htmlnformat($nentreg);
$actual = empty($actual) ? htmlnformat(0) : htmlnformat($actual);
$ajustes = empty($ajustes) ? htmlnformat(0) : htmlnformat($ajustes);
$conver = empty($conver) ? htmlnformat(0) : htmlnformat($conver);
$consi = empty($consi) ? htmlnformat(0) : htmlnformat($consi);
if ($activo == 'S') {
$sactivo = '<span style=\'font-size:0.7em;color:green;\'>ACTIVO</span>';
} else {
$sactivo = '<span style=\'font-size:0.7em;color:red;\'>INACTIVO</span>';
}
$optadd = '<div style="">';
$optadd .= ' <table>';
$optadd .= ' <tr><td colspan=\'5\'><b style="text-size:1.4em;font-weight:bold;">Movimientos posteriores a la fecha ' . dbdate_to_human($ffinal) . ' para todos los almacenes</b></td></tr>';
$optadd .= " <tr><td>Ventas </td><td style='text-align:right' ><b> {$ventas}</b></td><td style='padding-left:50px;'>Ajustes </td><td style='text-align:right' ><b>{$ajustes}</b></td><td rowspan='3' style='text-align:center'>Existencia actual <p style='font-size:2em;padding:0 0 0 0;margin: 0 0 0 0;font-weight:bold;'>{$actual}</p>{$sactivo}</td></tr>";
$optadd .= " <tr><td>Compras </td><td style='text-align:right' ><b>{$compras}</b></td><td style='padding-left:50px;'>Conversiones </td><td style='text-align:right' ><b> {$conver}</b></td></tr>";
$optadd .= " <tr><td>N.Entrega</td><td style='text-align:right' ><b>{$nentreg}</b></td><td style='padding-left:50px;'>Consignaciones</td><td style='text-align:right' ><b> {$consi}</b></td></tr>";
$optadd .= ' </table>';
$optadd .= '</div>';
} else {
$optadd = '';
}
$data['content'] .= $optadd;
//echo $grid->db->last_query();
$cana = $grid->recordCount;
}
if ($cana <= 0) {
$data['content'] .= '<script type="text/javascript"> $(function(){ $("#cajafiltro").show(); }); </script>';
}
$data['forma'] = '';
$data['script'] = script('jquery.js') . '<style type="text/css">#kardextabla tr:hover { background-color: #ffff99; }</style>';
//$data['script'].= script('plugins/jquery.columnhover.pack.js');
$data['title'] = heading('Kardex de Inventario');
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function almainconsis()
{
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Clientes inconsistentes");
$filter->fechad = new dateonlyField('Desde', 'fechad');
$filter->fechah = new dateonlyField('Hasta', 'fechah');
$filter->fechad->clause = $filter->fechah->clause = "where";
$filter->fechad->db_name = $filter->fechah->db_name = "fecha";
$filter->fechad->insertValue = date("Y-m-d");
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechad->operator = ">=";
$filter->fechah->operator = "<=";
$filter->buttons("reset", "search");
$filter->build();
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$fechah = $filter->fechah->newValue;
$fechad = $filter->fechad->newValue;
$alma = $this->datasis->dameval("SELECT a.ubica FROM (`costos` as a) LEFT JOIN `caub` AS b ON `a`.`ubica`=`b`.`ubica` WHERE `b`.`ubica` = 'NULL' AND `origen` = '3I' AND a.fecha >= '{$fechad}' AND a.fecha <= '{$fechah}'");
//echo $alma;
$uri = anchor('supervisor/mantenimiento/cambioalma/modify/<#tipo_doc#>/<#numero#>', 'Cambio');
$grid = new DataGrid('Almacenes inconsistentes');
$select = array('a.fecha', 'a.numero', 'a.cod_cli', 'a.tipo_doc', 'a.totalg', 'a.almacen');
$grid->db->select($select);
$grid->db->from('sfac as a');
$grid->db->where("a.almacen", $alma);
$grid->db->where("a.fecha >= ", $fechad);
$grid->db->where("a.fecha <=", $fechah);
$grid->per_page = 15;
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha');
$grid->column('Numero', 'numero');
$grid->column('Cliente', 'cod_cli');
$grid->column('Tipo', 'tipo_doc');
$grid->column('Monto', 'totalg');
$grid->column('Almacen', 'almacen');
$grid->column('Realizar', $uri);
$grid->build();
//echo $grid->db->last_query();
//memowrite($grid->db->last_query());
$tabla = $grid->output;
} else {
$tabla = '';
}
$data['content'] = $filter->output . $tabla;
$data['title'] = "<h1>Almacenes con problemas de incosistencias</h1>";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function filteredgrid()
{
//$this->datasis->modulo_id(35,1);
$this->rapyd->load("datafilter", "datagrid");
//$this->rapyd->uri->keep_persistence();
$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");
$filter = new DataFilter("");
$filter->db->from("mbancnoc a");
$filter->id = new inputField("Número", "id");
$filter->id->db_name = "a.id";
$filter->id->size = 10;
$filter->cheque = new inputField("Cheque", "cheque");
$filter->cheque->db_name = "a.cheque";
$filter->cheque->size = 10;
$filter->fecha = new dateonlyField("Fecha", "fecha");
$filter->fecha->dbformat = "Y-m-d";
$filter->fecha->size = 12;
$filter->fconcilia = new dateonlyField("F. Conciliado", "fconcilia");
$filter->fconcilia->dbformat = "Y-m-d";
$filter->fconcilia->size = 12;
$filter->codbanc = new inputField("Banco", 'codbanc');
$filter->codbanc->size = 6;
$filter->codbanc->append($bBANC);
$filter->monto = new inputField("Monto", 'monto');
$filter->monto->size = 6;
$filter->benefi = new inputField("A nombre de", 'benefi');
$filter->benefi->size = 20;
$filter->tipo_doc = new dropdownField("Tipo Doc", "tipo_doc");
$filter->tipo_doc->option("", "");
$filter->tipo_doc->option("ND", "Nota de Debito");
$filter->tipo_doc->option("NC", "Nota de Credito");
$filter->tipo_doc->option("CH", "Cheque");
$filter->tipo_doc->option("DP", "Deposito");
$filter->vnoc = new dropdownField("Ver", "vnoc");
$filter->vnoc->clause = " ";
$filter->vnoc->db_name = " ";
$filter->vnoc->option('', 'TODOS');
$filter->vnoc->option('S', 'CONCILIADOS');
$filter->vnoc->option('N', 'NO CONCILIADOS');
$filter->buttons("reset", "search");
$filter->build();
$uri = anchor($this->url . 'dataedit/show/<#id#>', '<str_pad><#id#>|8|0|STR_PAD_LEFT</str_pad>');
$uri2 = anchor($this->url . 'fconci/modify/<#id#>', 'Conciliar');
if ($filter->is_valid()) {
$q1 = $filter->db->_compile_select();
$vnoc = $filter->vnoc->newValue;
$q = "SELECT todo.* FROM (";
$q .= $q1;
$q .= ")todo";
if ($vnoc == 'S') {
$q .= " WHERE fconcilia IS NOT NULL";
}
if ($vnoc == 'N') {
$q .= " WHERE fconcilia IS NULL";
}
$qa = $this->db->query($q);
$qa = $qa->result_array($qa);
$grid = new DataGrid("No Contabilizados", $qa);
$grid->order_by("id", "desc");
$grid->per_page = 20;
$grid->use_function('substr', 'str_pad');
$grid->column_orderby("Número", $uri, "numero");
$grid->column_orderby("Cheque", "cheque", "cheque");
$grid->column_orderby("Tipo", "tipo_doc", "tipo_doc");
$grid->column_orderby("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "fecha", "align='center'");
$grid->column_orderby("Banco", "codbanc", "fecha", "align='center'");
$grid->column_orderby("Monto", "<nformat><#monto#>|2|,|.</nformat>", "monto", "align='right'");
$grid->column_orderby("F. Conciliado", "<dbdate_to_human><#fconcilia#></dbdate_to_human>", "fconcilia", "align='center'");
$grid->column_orderby("Conciliar", $uri2, "id");
$grid->add($this->url . "dataedit/create");
$grid->build();
$ggrid = $grid->output;
} else {
$ggrid = '';
}
//$data['content'] = $filter->output.$grid->output;
$data['filtro'] = $filter->output;
$data['content'] = $ggrid;
$data['script'] = script("jquery.js") . "\n";
$data['title'] = "{$this->titp}";
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
$this->load->library('PDFReporte2');
$this->rapyd->load("datafilter");
$repo = $this->uri->segment(3);
$esta = $this->uri->segment(4);
//**************************
$filter = new DataFilter("Filtro del Reporte");
$filter->attributes = array('onsubmit' => 'is_loaded()');
$filter->db->select("fecha, numero, tipo_op,concepto, (tipo_op NOT IN ('CH','ND'))*monto as debitos, (tipo_op IN ('CH','ND'))*monto as creditos,' ' as grupo");
$filter->db->from('bmov as a');
$filter->db->join('banc as b', 'a.codbanc=b.codbanc');
$filter->db->orderby('fecha');
$filter->fecha = new dateonlyField("Desde", "fechad", 'm/Y');
$filter->fecha->clause = 'where';
$filter->fecha->db_name = "EXTRACT(YEAR_MONTH FROM fecha)";
$filter->fecha->insertValue = date("Y-m-d");
$filter->fecha->operator = "=";
$filter->fecha->dbformat = 'Ym';
$filter->fecha->size = 7;
$filter->fecha->append(' mes/año');
$filter->fecha->rule = "required";
$filter->banco = new dropdownField("Caja/Banco", "codbanc");
$filter->banco->db_name = "a.codbanc";
$filter->banco->option("", "");
$filter->banco->options("SELECT codbanc, banco FROM bmov ORDER BY banco ");
$filter->banco->rule = "required";
$filter->buttons("search");
$filter->build();
if ($this->rapyd->uri->is_set("search") and $filter->is_valid()) {
$mSQL = $filter->db->_compile_select();
//echo $mSQL;
$mSALDOANT = $this->datasis->dameval("SELECT SUM(IF(tipo_op IN ('CH', 'ND'),-1,1)*monto) AS saldo FROM bmov WHERE EXTRACT(YEAR_MONTH FROM fecha) <" . $filter->fecha->newValue . " AND codbanc = '" . $filter->banco->newValue . "'");
$mSALDOACT = 0;
$sobretabla = '';
if (!empty($filter->banco->newValue)) {
$sobretabla .= 'Banco: ' . $filter->banco->newValue;
}
$pdf = new PDFReporte2($mSQL);
$pdf->setHeadValores('TITULO1');
$pdf->setSubHeadValores('TITULO2', 'TITULO3');
$pdf->setTitulo("Estado de Cuenta");
$pdf->setSobreTabla($sobretabla);
$pdf->setSubTitulo("Para la fecha: " . $this->input->post('fechad'));
$pdf->AddPage();
$pdf->setTableTitu(8, 'Times');
$pdf->AddCol('fecha', 20, 'Fecha', 'L', 8);
$pdf->AddCol('numero', 25, 'Número', 'L', 8);
$pdf->AddCol('tipo_op', 15, 'Tipo Op', 'L', 8);
$pdf->AddCol('concepto', 70, 'Concepto', 'L', 8);
$pdf->AddCol('debitos', 30, 'Débitos', 'R', 8);
$pdf->AddCol('creditos', 30, 'Créditos', 'R', 8);
$pdf->setTotalizar('debitos', 'creditos');
$pdf->setGrupoLabel("<#grupo#>Saldo Anterior: {$mSALDOANT}, Saldo Actual: {$mSALDOACT}");
$pdf->setGrupo('grupo');
$pdf->Table();
$pdf->Output();
} else {
if (strlen($filter->error_string)) {
$data["error"] = $filter->error_string;
}
$data["filtro"] = $filter->output;
$data["titulo"] = '<h2 class="mainheader">Estado de Cuenta<h2>';
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_freportes', $data);
}
//**************************
//**************************
}
function filteredgrid()
{
$this->rapyd->load('datafilter', 'datagrid2');
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5');
function convierte($par, $link)
{
$atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '5', 'screeny' => '5');
switch ($par) {
case '3I':
return anchor_popup($link, 'Ventas Caja', $atts);
break;
case '3M':
return anchor_popup($link, 'Ventas Mayor', $atts);
break;
case '1T':
return anchor_popup($link, 'Transferencias', $atts);
break;
case '2C':
return anchor_popup($link, 'Compras', $atts);
break;
case '4N':
return anchor_popup($link, 'Nota/Entrega', $atts);
break;
case '6C':
return 'Conversiones';
break;
case '5A':
return 'Ajustes';
break;
case '0F':
return 'Inventario';
break;
case '9F':
return 'Inventario';
break;
default:
return $par;
}
}
$modbus = array('tabla' => 'maes', 'columnas' => array('codigo' => 'Código', 'descrip' => 'Descripción', 'precio1' => 'Precio 1', 'precio2' => 'Precio 2', 'precio3' => 'Precio 3', 'precio4' => 'Precio 4', 'precio5' => 'Precio 5'), 'filtro' => array('codigo' => 'Código', 'descrip' => 'Descripción'), 'retornar' => array('codigo' => 'codigo'), 'titulo' => 'Buscar en inventario');
$boton = $this->datasis->modbus($modbus);
$maxfecha = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos");
if (!empty($maxfecha)) {
$corte = ' corte: <b>' . dbdate_to_human($maxfecha) . '</b>';
} else {
$corte = '';
}
$filter = new DataFilter('Kardex de Inventario (' . anchor_popup('/supermercado/lfisico', 'Resumen de inventarios', $atts) . ') ' . $corte);
$filter->codigo = new inputField('Código de Producto', 'codigo');
$filter->codigo->size = '10';
$filter->codigo->rule = 'required';
$filter->codigo->append($boton);
$filter->codigo->group = 'UNO';
$filter->ubica = new dropdownField('Almacén', 'ubica');
$filter->ubica->option('', 'Todos');
$filter->ubica->db_name = 'a.ubica';
$filter->ubica->options("SELECT ubica,CONCAT(ubica,' ',ubides) descrip FROM caub WHERE gasto='N' ");
$filter->ubica->operator = '=';
$filter->ubica->clause = 'where';
$filter->ubica->group = 'UNO';
$filter->fechad = new dateonlyField('Desde', 'fecha', 'd/m/Y');
$filter->fechad->operator = '>=';
$filter->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date('m'), date('d') - 30, date('Y')));
$filter->fechad->group = 'DOS';
$filter->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y');
$filter->fechah->db_name = 'fecha';
$filter->fechah->operator = '<=';
$filter->fechah->insertValue = date('Y-m-d');
$filter->fechah->group = 'DOS';
$filter->fechah->clause = $filter->fechad->clause = $filter->codigo->clause = 'where';
$filter->fechah->rule = $filter->fechad->rule = 'required|chfecha';
$filter->fechah->size = $filter->fechad->size = 10;
$filter->buttons('reset', 'search');
$filter->build('dataformfiltro');
$data['content'] = $filter->output;
$code = $this->input->post('codigo');
if ($code && $filter->is_valid()) {
$dbcode = $this->db->escape($code);
$mSQL = "SELECT descrip FROM maes WHERE codigo={$dbcode}";
$ffinal = $this->datasis->dameval("SELECT MAX(fecha) AS fecha FROM costos WHERE codigo={$dbcode}");
$query = $this->db->query($mSQL);
$descrip = '';
if ($query->num_rows() > 0) {
$row = $query->row();
$descrip = trim($row->descrip);
//$activo =trim($row->activo);
$actual = $this->datasis->dameval("SELECT SUM(cantidad) AS cana FROM ubic WHERE codigo={$dbcode}");
$fracci = $this->datasis->dameval("SELECT SUM(fraccion) AS cana FROM ubic WHERE codigo={$dbcode}");
} else {
//$activo ='';
}
$link = "/supermercado/kardex/grid/<#origen#>/<dbdate_to_human><#fecha#>|Ymd</dbdate_to_human>/<str_replace>/|:slach:|<#codigo#></str_replace>/<#ubica#>";
$grid = new DataGrid2("({$code}) {$descrip}");
$grid->agrupar('Almacén: ', 'almacen');
$grid->use_function('convierte', 'number_format', 'str_replace');
$grid->db->select("IFNULL( b.ubides , a.ubica ) almacen,a.ubica ,a.fecha, a.venta, a.cantidad, a.saldo, a.monto, a.salcant, a.codigo, a.origen, a.promedio");
$grid->db->from('costos a');
$grid->db->join('caub b ', 'b.ubica=a.ubica', 'LEFT');
$grid->db->orderby('almacen, fecha, origen');
$grid->per_page = 20;
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>');
$grid->column('Orígen', "<convierte><#origen#>|{$link}</convierte>", 'align=left');
$grid->column('Cantidad', '<nformat><#cantidad#></nformat>', 'align=right');
$grid->column('Acumulado', '<nformat><#salcant#></nformat>', 'align=right');
$grid->column('Monto', '<nformat><#monto#></nformat>', 'align=right');
$grid->column('Saldo', '<nformat><#saldo#></nformat>', 'align=right');
$grid->column('Costo Prom.', '<nformat><#promedio#></nformat>', 'align=right');
$grid->column('Ventas', '<nformat><#venta#></nformat>', 'align=right');
$grid->build();
$data['content'] .= $grid->output;
//echo $grid->db->last_query();
}
if (!empty($ffinal)) {
$dbfinal = $this->db->escape($ffinal);
$mayor = $this->datasis->dameval("SELECT SUM(cantidad) AS cana FROM itfmay WHERE codigo={$dbcode} AND fecha>{$dbfinal}");
$ventas = $this->datasis->dameval("SELECT SUM(cantidad) AS cana FROM positfact WHERE codigo={$dbcode} AND fecha>{$dbfinal}");
$compras = $this->datasis->dameval("SELECT SUM(IF(b.tipo_doc='ND',-1,1)*a.cantidad) AS cana FROM itscst AS a JOIN scst AS b ON a.control=b.control WHERE a.codigo={$dbcode} AND b.actuali>=b.fecha AND b.actuali>{$dbfinal}");
$nentreg = $this->datasis->dameval("SELECT SUM(a.cana) AS cana FROM itsnte AS a JOIN snte AS b ON a.numero=b.numero WHERE a.codigo={$dbcode} AND b.fecha>{$dbfinal}");
$ajustes = $this->datasis->dameval("SELECT SUM(IF(b.tipo='E',1,-1)*cantidad) AS cana FROM itssal AS a JOIN ssal AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}");
$conver = $this->datasis->dameval("SELECT SUM(a.entrada-a.salida) AS cana FROM itconv AS a JOIN conv AS b ON a.numero = b.numero WHERE a.codigo = {$dbcode} AND b.fecha>{$dbfinal}");
$ventas = empty($ventas) ? htmlnformat(0) : htmlnformat($ventas);
$compras = empty($compras) ? htmlnformat(0) : htmlnformat($compras);
$nentreg = empty($nentreg) ? htmlnformat(0) : htmlnformat($nentreg);
$actual = empty($actual) ? htmlnformat(0) : htmlnformat($actual);
$ajustes = empty($ajustes) ? htmlnformat(0) : htmlnformat($ajustes);
$conver = empty($conver) ? htmlnformat(0) : htmlnformat($conver);
$consi = empty($consi) ? htmlnformat(0) : htmlnformat($consi);
$mayor = empty($mayor) ? htmlnformat(0) : htmlnformat($mayor);
//if($activo=='S'){
// $sactivo='<span style=\'font-size:0.7em;color:green;\'>ACTIVO</span>';
//}else{
// $sactivo='<span style=\'font-size:0.7em;color:red;\'>INACTIVO</span>';
//}
$optadd = '<div style="">';
$optadd .= ' <table>';
$optadd .= ' <tr><td colspan=\'5\'><b style="text-size:1.4em;font-weight:bold;">Movimientos posteriores a la fecha ' . dbdate_to_human($ffinal) . ' para todos los almacenes</b></td></tr>';
$optadd .= " <tr><td>Ventas </td><td style='text-align:right' ><b> {$ventas}</b></td><td style='padding-left:50px;'>Ajustes </td><td style='text-align:right' ><b>{$ajustes}</b></td><td rowspan='3' style='text-align:center'>Existencia actual <p style='font-size:2em;padding:0 0 0 0;margin: 0 0 0 0;font-weight:bold;'>{$actual} / {$fracci}</p></td></tr>";
$optadd .= " <tr><td>Compras </td><td style='text-align:right' ><b>{$compras}</b></td><td style='padding-left:50px;'>Conversiones </td><td style='text-align:right' ><b> {$conver}</b></td></tr>";
$optadd .= " <tr><td>N.Entrega</td><td style='text-align:right' ><b>{$nentreg}</b></td><td style='padding-left:50px;'>Mayor </td><td style='text-align:right' ><b> {$mayor}</b></td></tr>";
$optadd .= ' </table>';
$optadd .= '</div>';
} else {
$optadd = '';
}
$data['content'] .= $optadd;
$data['title'] = heading('Kardex de Inventario');
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function sntealma()
{
$this->datasis->modulo_id('900', 1);
$this->rapyd->load("datafilter", "datagrid");
$filter = new DataFilter("Cambio de almacén en notas de entrega", 'snte');
$filter->numero = new inputField('Número', 'numero');
$filter->numero->size = 10;
$filter->fechad = new dateonlyField('Desde', 'fechad');
$filter->fechah = new dateonlyField('Hasta', 'fechah');
$filter->fechad->clause = $filter->fechah->clause = "where";
$filter->fechad->db_name = $filter->fechah->db_name = "fecha";
$filter->fechad->insertValue = date("Y-m-d");
$filter->fechah->insertValue = date("Y-m-d");
$filter->fechad->operator = ">=";
$filter->fechah->operator = "<=";
$filter->buttons("reset", "search");
$filter->build();
if ($this->rapyd->uri->is_set('search') && $filter->is_valid()) {
$uri = anchor('supervisor/mantenimiento/sntecambioalma/modify/<#numero#>', '<#almacen#>');
$grid = new DataGrid('Notas de entrega');
$grid->per_page = 15;
$grid->column('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>');
$grid->column('Almacén', $uri);
$grid->column('Numero', 'numero');
$grid->column('Cliente', 'cod_cli');
$grid->column('Nombre', 'nombre');
$grid->column('Monto', '<nformat><#gtotal#></nformat>', 'align="right"');
$grid->build();
$tabla = $grid->output;
} else {
$tabla = '';
}
$data['content'] = $filter->output . $tabla;
$data['title'] = "<h1>Cambio de almacén en notas de entrega</h1>";
$data['head'] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
function index()
{
//SELECT * FROM bmov
//WHERE codbanc='01' AND EXTRACT(YEAR_MONTH FROM fecha)<=201004 AND anulado!='S' AND liable!='N' AND
//(concilia=0 OR EXTRACT(YEAR_MONTH FROM concilia)>=20100430 OR concilia<fecha)
$this->rapyd->load('datafilter', 'datagrid');
$filter = new DataFilter('');
$filter->db->from('mbanc');
$filter->db->where('(MID(status,2,1) =2 or status="NC")');
//$filter->db->where('liable !=','N' );
$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'), 'where' => $where, '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'), 'titulo' => 'Buscar Beneficiario');
$bSPRV = $this->datasis->p_modbus($mSPRV, "proveed");
$filter->tipo_doc = new dropdownField('Tipo de Operacion', 'tipo_doc');
$filter->tipo_doc->option('', 'Todos');
$filter->tipo_doc->option('NC', 'Nota de Crédito');
$filter->tipo_doc->option('ND', 'Nota de Debito');
$filter->tipo_doc->option('DE', 'Deposito');
$filter->tipo_doc->option('CH', 'Cheque');
//$filter->tipo_op->db_name='a.tipo_doc';
$filter->fechad = new dateonlyField("Desde", "fechad", 'd/m/Y');
$filter->fechad->clause = "where";
$filter->fechad->db_name = "fecha";
$filter->fechad->operator = ">=";
$filter->fechad->insertValue = date("Ymd", mktime(0, 0, 0, date("m"), date("d") - 30, date("Y")));
$filter->fechad->group = "Fecha de Cheque";
//$filter->fechad->dbformat='Y-m-d';
//$filter->fechad->db_name='a.fecha';
$filter->fechad->rule = 'required';
$filter->fechah = new dateonlyField("Hasta", "fechah", 'd/m/Y');
$filter->fechah->clause = "where";
$filter->fechah->insertValue = date("Ymd");
$filter->fechah->db_name = "fecha";
$filter->fechah->operator = "<=";
$filter->fechah->group = "Fecha de Cheque";
//$filter->fechaH->dbformat='Y-m-d';
//$filter->fechah->db_name='a.fecha';
$filter->fecha2d = new dateonlyField("Desde", "fecha2d", 'd/m/Y');
$filter->fecha2d->clause = "where";
$filter->fecha2d->db_name = "fecha2";
$filter->fecha2d->operator = ">=";
// $filter->fecha2d->insertValue = date("Ymd",mktime(0, 0, 0, date("m"), date("d")-30, date("Y")));
$filter->fecha2d->group = "Fecha de Planilla";
//$filter->fechad->dbformat='Y-m-d';
//$filter->fechad->db_name='a.fecha';
// $filter->fecha2d->rule ='required';
$filter->fecha2h = new dateonlyField("Hasta", "fecha2h", 'd/m/Y');
$filter->fecha2h->clause = "where";
// $filter->fecha2h->insertValue = date("Ymd");
$filter->fecha2h->db_name = "fecha2";
$filter->fecha2h->operator = "<=";
$filter->fecha2h->group = "Fecha de Planilla";
//$filter->fechaH->dbformat='Y-m-d';
//$filter->fechah->db_name='a.fecha';
$filter->cheque = new inputField("Transaccion", "cheque");
$filter->cheque->db_name = "cheque";
$filter->cheque->size = 10;
//$filter->cheque->db_name='a.cheque';
$filter->cod_prov = new inputField("Beneficiario", 'cod_prov');
$filter->cod_prov->size = 6;
$filter->cod_prov->append($bSPRV);
//$filter->cod_prov->db_name='a.cod_prov';
$filter->benefi = new inputField("A Nombre de", "benefi");
$filter->benefi->size = 40;
//$filter->benefi->db_name='a.benefi';
$filter->concilia = new dropdownField('Conciliado', 'concilia');
$filter->concilia->option('', 'Todos');
$filter->concilia->option('S', 'Si');
$filter->concilia->option('N', 'No');
//$filter->concilia->db_name='a.concilia';
$filter->vnoc = new dropdownField("Ver No Conciliados con Fecha anterior", "vnoc");
$filter->vnoc->clause = " ";
$filter->vnoc->db_name = " ";
$filter->vnoc->option('', 'NO');
$filter->vnoc->option('S', 'SI');
$filter->des8 = new containerField("", "<div style='background-color:#CCEEEE;padding:5px;'>INTRODUCE LOS DATOS DEL ESTADO DE CUENTA</div>");
$filter->des8->group = "Datos de Estado de Cuenta";
$filter->des8->clause = ' ';
$filter->codbanc = new inputField("Banco", 'codbanc');
$filter->codbanc->db_name = 'codbanc';
$filter->codbanc->rule = 'required';
$filter->codbanc->size = 3;
$filter->codbanc->append($bBANC);
$filter->codbanc->group = "Datos de Estado de Cuenta";
$filter->codbanc->clause = "where";
$filter->codbanc->operator = "=";
//$filter->codbanc->db_name='a.codbanc';
$y = date('Y');
$filter->anio = new dropdownField('Año', 'anio');
$filter->anio->option($y, $y);
for ($i = $y - 2; $i <= $y + 2; $i++) {
$filter->anio->option($i, $i);
}
$filter->anio->rule = 'required';
$filter->anio->clause = '';
$filter->anio->in = 'mes';
$filter->anio->size = 5;
$filter->anio->style = "width:100px;";
$filter->anio->group = "Datos de Estado de Cuenta";
$filter->mes = new dropdownField('Fecha mes/año', 'mes');
$filter->mes->clause = '';
$filter->mes->rule = 'required';
$filter->mes->style = 'width:50px';
for ($i = 1; $i <= 12; $i++) {
$mmes = str_pad($i, 2, '0', STR_PAD_LEFT);
$filter->mes->option($mmes, $mmes);
}
$filter->mes->group = "Datos de Estado de Cuenta";
$filter->buttons('reset', 'search');
$filter->build();
$tipos = array("tch" => "T. Cheques", "tnd" => "T. ND", "tdp" => "T. Depositos", "tnc" => "T. NC");
$salida = '';
foreach ($tipos as $key => $value) {
${$key} = new inputField($value, $key);
${$key}->status = "create";
${$key}->size = 15;
${$key}->build();
$salida .= ${$key}->label . ${$key}->output;
}
if ($this->rapyd->uri->is_set('search') and $filter->is_valid()) {
$q1 = $filter->db->_compile_select();
$fechad = $filter->fechad->newValue;
$codbanc = $filter->codbanc->newValue;
$tipo_doc = $filter->tipo_doc->newValue;
$codbanc = $filter->codbanc->newValue;
$cheque = $filter->cheque->newValue;
$cod_prov = $filter->cod_prov->newValue;
$benefi = $filter->benefi->newValue;
$codbance = $this->db->escape($codbanc);
$fechaddb = $fechad;
$tipo_doce = $this->db->escape($tipo_doc);
$chequee = $this->db->escape($cheque);
$benefie = $this->db->escape($benefi);
$vnoc = $this->input->post('vnoc');
$anio = $filter->anio->newValue;
$mes = $filter->mes->newValue;
$q = "SELECT todo.tipo_doc='DP' tdp,MID(cheque,LENGTH(cheque)-3,4) ordena,todo.* FROM ( ";
$q .= $q1;
if ($vnoc) {
$q2 = " SELECT * FROM mbanc WHERE codbanc={$codbance} AND fecha<{$fechaddb} AND concilia='N' AND status NOT IN ('AN') ";
if ($tipo_doc) {
$q2 .= " AND tipo_doc={$tipo_doce} ";
}
if ($cheque) {
$q2 .= " AND tipo_doc={$chequee} ";
}
if ($benefi) {
$q2 .= " AND tipo_doc={$benefie} ";
}
$q .= " UNION ALL ";
$q .= $q2;
}
$q .= ")todo ORDER BY " . $this->datasis->traevalor("CONCIORDENA", "fecha,cheque");
$qa = $this->db->query($q);
$qa = $qa->result_array($qa);
//'MID(status,2,1) ','2'
function conci($conci, $codbanc, $tipo_op, $numero, $fecha, $id)
{
//$numero='hoa';
$numero = raencode($numero);
$arr = array($codbanc, $tipo_op, $numero, $fecha, $id);
//print_r($arr);
//echo $id;
if ($conci != 'S') {
return form_checkbox($codbanc . $tipo_op . $numero . $id, serialize($arr));
} else {
return form_checkbox($codbanc . $tipo_op . $numero . $id, serialize($arr), TRUE);
}
}
function caja($codbanc, $tipo_doc, $cheque, $monto)
{
//$fech=explode('-',$conci);
$arr = array($codbanc, $tipo_doc, $numero, $fecha);
return form_input($codbanc . $tipo_op . $numero, serialize($arr), TRUE);
}
$monto = new inputField("Monto", "monto");
$monto->grid_name = 'monto<#codbanc#><#tipo_doc#><#cheque#>';
$monto->status = 'modify';
$monto->size = 12;
$monto->css_class = 'inputnum';
$fconci = new dateField('', 'fconci', 'd/m/Y');
$fconci->status = 'create';
$fconci->size = 10;
$fconci->insertValue = date('Ymt', mktime(0, 0, 0, $mes, 1, $anio));
$fconci->build();
$fecha = $filter->anio->newValue . $filter->mes->newValue . days_in_month($filter->mes->newValue);
$grid = new DataGrid('Efectos Conciliables' . "</br>Fecha Conciliación " . $fconci->output, $qa);
$grid->use_function('conci');
//$grid->order_by($ord);
$grid->per_page = 10000;
$grid->column_orderby('Ref.', 'id', 'id');
$grid->column_orderby('Tipo doc', 'tipo_doc', 'tipo_doc');
$grid->column_orderby('Fecha', '<dbdate_to_human><#fecha#></dbdate_to_human>', 'fecha');
$grid->column_orderby('Fecha Doc', '<dbdate_to_human><#fecha2#></dbdate_to_human>', 'fecha2');
$grid->column_orderby('Transaccion', "<wordwrap><#cheque#>|50|\n|true</wordwrap>", 'cheque', 'width="200px"');
$grid->column_orderby('Monto', $monto, 'monto');
$grid->column_orderby('Conciliado', "<conci><#concilia#>|<#codbanc#>|<#tipo_doc#>|<#cheque#>|{$fecha}|<#id#></conci>", 'concilia');
$grid->column_orderby('F conciliacion', '<dbdate_to_human><#fconcilia#></dbdate_to_human>', 'fcocilia');
$grid->column_orderby('Beneficiario', 'benefi', 'benefi');
$grid->column_orderby('Concepto', 'observa', 'observa');
$grid->build();
$ggrid = $grid->output;
} else {
$ggrid = '';
}
$data['filtro'] = $filter->output;
$data['content'] = $salida . $ggrid;
$data['title'] = 'Conciliaciones de Bancos';
$data['script'] = '<script language="javascript" type="text/javascript">';
$data['script'] .= '
function suma(){
tch =0;tdp=0;tnc=0;tnd=0;
$(":checkbox").each(function(i,val){
if(val.checked==true){
monto=parseFloat($("#monto"+val.name).val());
tipo =val.name.substr(2,2);
if(tipo=="CH")tch=tch+monto;
if(tipo=="DP")tdp=tdp+monto;
if(tipo=="NC")tnc=tnc+monto;
if(tipo=="ND")tnd=tnd+monto;
}
});
$("#tch").val(Math.round(tch*100)/100);
$("#tdp").val(Math.round(tdp*100)/100);
$("#tnc").val(Math.round(tnc*100)/100);
$("#tnd").val(Math.round(tnd*100)/100);
}
$(document).ready(function(){
suma();
$(":checkbox").change(function(){
name=$(this).attr("name");
ch=$(this).is(":checked");
fc=$("#fconci").val();
$.post("' . site_url('tesoreria/conci/cconci') . '",{ data: $(this).val(),accion:ch,fconci:fc},
function(data){
if(data=="1"){
suma();
return true;
}else{
$("input[name=\'"+name+"\']").removeAttr("checked");
alert(data);
return false;
}
});
});
});';
$data['script'] .= '</script>';
$data['head'] = $this->rapyd->get_head() . script('jquery.js');
$this->load->view('view_ventanas', $data);
}
