function ver_cliente($cli)
{
function ractivo($estado, $numero)
{
if ($estado == 'R') {
$retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => TRUE);
} else {
$retorna = array('name' => $numero, 'id' => $estado, 'value' => 'accept', 'checked' => FALSE);
}
return form_checkbox($retorna);
}
$this->rapyd->load("datafilter", "datagrid2");
$cliente = $this->datasis->dameval("Select nombre from scli where cliente='" . $cli . "'");
//echo $cliente;
$filter = new DataFilter("Filtro de Control de Tiket");
$select = array("a.id as idm", "a.sucursal", "a.asignacion", "a.idt as idt", "a.padre", "a.pertenece", "a.prioridad", "a.usuario as usuarios", "a.contenido", "a.estampa", "a.actualizado", "a.estado as testado", "IF(a.estado='N','Nuevo',IF(a.estado='R','Resuelto',IF(a.estado='P','Pendiente','En Proceso')))as estado", "b.id", "b.cliente as clientes", "b.url", "b.basededato", "b.puerto", "b.puerto", "b.usuario", "b.clave", "b.observacion", "c.nombre", "a.minutos");
$filter->db->select($select);
$filter->db->from("tiketc AS a");
$filter->db->join("tiketconec AS b", "a.sucursal=b.id");
$filter->db->join("scli AS c", "b.cliente=c.cliente");
$filter->db->where("b.cliente", "{$cli}");
$filter->db->where("a.estado !=", "R");
$filter->db->where("a.estado !=", "C");
$filter->estado = new dropdownField("Estado", "estado");
$filter->estado->option("P", "Pendiente");
$filter->prioridad = new dropdownField("Prioridad", "prioridad");
$filter->prioridad->option("", "Todos");
$filter->asignacion = new dropdownField("Asignacion", "asignacion");
$filter->asignacion->option("", "Todos");
$filter->asignacion->options("SELECT codigo, codigo as value FROM tiketservi");
$filter->asignacion->style = "width:150px";
$filter->nombre = new inputField("Nombre", "nombre");
$filter->nombre->size = 40;
$filter->usuario = new inputField("Usuario", "usuario");
$filter->usuario->size = 20;
$filter->buttons("reset", "search");
$filter->build('dataformfiltro');
$ticket = anchor('supervisor/tiket/traertiket/', 'Traer Todos los Ticket');
$atras = anchor('supervisor/tiketmaes/', img(array('src' => 'images/regresar.jpg', 'border' => '0', 'alt' => 'Editar', 'height' => '40')));
$uri2 = anchor('supervisor/tiketmaes/traertiket/' . $cli, 'Traer Ticket');
$uri_3 = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", img(array('src' => 'images/editar.png', 'border' => '0', 'alt' => 'Editar', 'height' => '12')));
$grid = new DataGrid2($atras . '<br><center>Lista de Ticket Pendientes y Nuevos -->' . $uri2 . "</center>");
$grid->order_by("a.id", "desc");
$grid->per_page = 10;
$link = anchor("supervisor/tiketc/dataedit/modify/<#idm#>", "<#idm#>");
$grid->use_function('ractivo');
$grid->column('Acción', $uri_3, 'align=center');
$grid->column("Resuelto", "<ractivo><#testado#>|<#idm#></ractivo>", 'align="center"');
$grid->column_orderby("Id", $link, 'idm');
$grid->column_orderby("Numero tiket", "idt", 'idt');
$grid->column_orderby("Fecha de Ingreso", "<dbdate_to_human><#estampa#>|d/m/Y h:m:s</dbdate_to_human>", 'estampa');
$grid->column_orderby("Cliente", "nombre", 'nombre');
$grid->column_orderby("Estado", "estado", "estado");
$grid->column("Usuario", "usuarios");
$grid->column("Contenido", "contenido");
$grid->column("Prioridad", "prioridad");
$grid->column("Asignacion", "asignacion");
$resp = '<a href="http://<#url#>/proteoerp/supervisor/tiket/dataedit/pertenece/<#idt#>/create">Ir</a>';
$grid->column("Responder", $resp);
$grid->totalizar('minutos');
$grid->build('datagridST');
//echo $grid->db->last_query();
//************ SUPER TABLE *************
$extras = '
<script type="text/javascript">
//<![CDATA[
(function() {
var mySt = new superTable("demoTable", {
cssSkin : "sSky",
fixedCols : 1,
headerRows : 1,
onStart : function () { this.start = new Date();},
onFinish : function () {document.getElementById("testDiv").innerHTML += "Finished...<br>" + ((new Date()) - this.start) + "ms.<br>";}
});
})();
//]]>
</script>
';
$style = '
<style type="text/css">
.fakeContainer { /* The parent container */
margin: 5px;
padding: 0px;
border: none;
width: 740px; /* Required to set */
height: 320px; /* Required to set */
overflow: hidden; /* Required to set */
}
</style>
';
//****************************************
$script = '';
$url = site_url('supervisor/tiketc/activar');
$data['script'] = '<script type="text/javascript">
$(document).ready(function() {
$("form :checkbox").click(function () {
$.ajax({
type: "POST",
url: "' . $url . '",
data: "numero="+this.name+"&estado="+this.id,
success: function(msg){
//alert(msg);
}
});
}).change();
});
</script>';
$data['style'] = $style;
$data['style'] .= style('superTables.css');
$data['extras'] = $extras;
$data['content'] = $grid->output;
$data['filtro'] = $filter->output;
$data['script'] .= script('jquery.js');
$data["script"] .= script('superTables.js') . script("jquery-1.2.6.pack.js") . script("plugins/jquery.checkboxes.pack.js");
//$data['content']= form_open('').$grid->output.form_close().$script;
$data['title'] = heading('Ticket ' . $cliente);
$data["head"] = $this->rapyd->get_head();
$this->load->view('view_ventanas', $data);
}
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);
}
