function cdatos()
{
$this->rapyd->uri->keep_persistence();
$this->rapyd->load('datagrid2', 'fields');
function ctipo($id, $tipo, $ejecuta)
{
if ($tipo == 'C') {
return 'Calculado';
} else {
$rt = str_replace('return', '', $ejecuta);
$rt = str_replace(';', '', $rt);
$name = "pvalor[{$id}]";
$data = array('name' => $name, 'id' => $name, 'value' => trim($rt), 'maxlength' => '100', 'size' => '15', 'class' => 'inputnum');
return form_input($data);
}
}
//echo date('Y-m-d H:i:s',mktime(0, 0, 0, date('n')-1, 1)).' - '.date('Y-m-d H:i:s',mktime(0, 0, 0, date('n') , 0));
$fdesde = new dateonlyField('Fecha de inicio: ', 'fdesde');
$fhasta = new dateonlyField('Fecha Final: ', 'fhasta');
$fdesde->insertValue = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n') - 1, 1));
$fhasta->insertValue = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n'), 0));
$fdesde->status = $fhasta->status = 'create';
$fdesde->size = $fhasta->size = 8;
$fdesde->dbformat = $fhasta->dbformat = 'Ymd';
$fdesde->build();
$fhasta->build();
$fcorte1 = new dateonlyField('Fecha de Corte: ', 'fcorte1');
$fcorte1->insertValue = date('Y-m-d H:i:s', mktime(0, 0, 0, date('n') - 1, 15));
$fcorte1->dbformat = 'Ymd';
$fcorte1->status = 'create';
$fcorte1->size = 8;
$fcorte1->build();
$error = $msj = '';
if ($this->input->post('pros') !== false) {
$fdesde->_getNewValue();
$fhasta->_getNewValue();
$fcorte1->_getNewValue();
$url = $this->url . 'ejecutor/' . $fdesde->newValue . '/' . $fcorte1->newValue . '/' . $fhasta->newValue;
redirect($url);
$pmargen = $this->input->post('pmargen');
$pobject = $this->input->post('pobjetivo');
$pvalor = $this->input->post('pvalor');
if (is_array($pmargen)) {
if (array_sum($pmargen) == 100) {
foreach ($pmargen as $id => $pm) {
if (is_numeric($pobject[$id])) {
$po = $pobject[$id];
} else {
$po = 0;
}
if (isset($pvalor[$id]) && is_numeric($pvalor[$id])) {
$pv = 'return ' . $pvalor[$id] . ';';
} else {
$pv = null;
}
if (is_numeric($pm) && $pm >= 0) {
$this->db->where('id', $id);
$data = array();
$data['puntos'] = $pm;
$data['objetivo'] = $po;
if (!empty($pv)) {
$data['ejecuta'] = $pv;
}
$this->db->update('gestion_indicador', $data);
} else {
$error .= 'Valor no numérico o negativo ' . $id;
}
}
} else {
$error .= 'La suma de los valores debe dar exactamente 100';
}
} else {
$error = 'No se puede procesar el requerimiento';
}
}
$ggrid = form_open('/finanzas/gestion/cdatos') . '<p align="center">';
$ggrid .= '<b>' . $fdesde->label . '</b>' . $fdesde->output;
$ggrid .= '<b>' . $fhasta->label . '</b>' . $fhasta->output;
$ggrid .= br() . '<b>' . $fcorte1->label . '</b>' . $fcorte1->output;
$ggrid .= '</p>';
$grid = new DataGrid2('Selección de indicadores');
$grid->agrupar(' ', 'nomgrup');
$grid->use_function('ctipo');
$select = array('a.descrip', 'a.indicador', 'a.tipo', 'a.puntos', 'a.id', 'a.objetivo', 'a.ejecuta', 'b.nombre AS nomgrup', 'unidad');
$grid->db->select($select);
$grid->db->from('gestion_indicador AS a');
$grid->db->join('gestion_grupo AS b', 'a.id_gestion_grupo=b.id');
$grid->db->where('a.activo', 'S');
$grid->order_by('nomgrup');
$campo = new inputField('Campo', 'puntos');
$campo->grid_name = 'pmargen[<#id#>]';
$campo->status = 'modify';
$campo->size = 6;
$campo->autocomplete = false;
$campo->css_class = 'inputnum';
$campo->disable_paste = true;
$meta = new inputField('Meta', 'objetivo');
$meta->grid_name = 'pobjetivo[<#id#>]';
$meta->status = 'modify';
$meta->size = 15;
$meta->autocomplete = false;
$meta->css_class = 'inputnum';
$meta->disable_paste = true;
$grid->column_orderby('Indicador', 'indicador', 'indicador');
$grid->column('Puntos %', $campo, 'align=\'center\'');
$grid->column('Objetivo', $meta, 'align=\'center\'');
$grid->column('Unidad', 'unidad');
$grid->column('Tipo', "<ctipo><#id#>|<#tipo#>|<#ejecuta#></ctipo>");
$action = "javascript:window.location='" . site_url('ventas/metas/filteredgrid') . "'";
$grid->button('btn_regresa', 'Regresar', $action, 'TR');
$grid->submit('pros', 'Generar', 'BR');
$grid->build();
$ggrid .= $grid->output;
$ggrid .= form_close();
$script = '<script language="javascript" type="text/javascript">
$(function(){
$(".inputnum").numeric(".");
$(\'input[name^="pmargen"]\').focus(function() {
obj = $(this);
vval = Number(obj.val());
tota=0;
$(\'input[name^="pmargen"]\').each(function (i) {
tota+=Number(this.value);
});
val=roundNumber(100-(tota-vval),2);
obj.val(val);
obj.select();
});
});
</script>';
$data['content'] = '<div class="alert">' . $error . '</div>';
$data['content'] .= '<div>' . $msj . '</div>';
$data['content'] .= $ggrid;
$data['title'] = heading('Indicadores de Gestión');
$data['script'] = $script;
$data['script'] .= phpscript('nformat.js');
$data['head'] = $this->rapyd->get_head() . script('jquery.pack.js') . script('plugins/jquery.numeric.pack.js') . script('plugins/jquery.floatnumber.js');
$data['head'] .= style('estilos.css');
$data['head'] .= phpscript('nformat.js');
$this->load->view('view_ventanas', $data);
}