function departa()
{
$this->load->library('Graph');
$data = $titu = array();
$mes = $this->uri->segment(4);
$anio = $this->uri->segment(5);
if (empty($mes) and empty($anio)) {
return;
}
$fechai = $anio . $mes . '01';
$fechaf = $anio . $mes . '31';
//8471.49.00.00
$mSQL = "SELECT f.descrip etiqueta, sum(b.importe) total\n\t\t\tFROM itscst b JOIN scst a ON a.control=b.control \n\t\t\tJOIN sinv c ON b.codigo=c.codigo\n\t\t\tJOIN grup d ON d.grupo=c.grupo\n\t\t\tJOIN line e ON d.linea=e.linea \n\t\t\tJOIN dpto f ON e.depto=f.depto \n\t\t\tWHERE a.tipo_doc IN ('FC', 'NC','NE') AND a.fecha>={$fechai} AND a.fecha<={$fechaf}\n\t\t\tGROUP BY f.depto";
//echo $mSQL;
$maxval = 0;
$query = $this->db->query($mSQL);
foreach ($query->result() as $row) {
if ($row->total > $maxval) {
$maxval = $row->total;
}
$data[] = $row->total;
$titu[] = $row->etiqueta;
}
$i = 1;
while (1) {
if ($maxval / $i <= 100) {
break;
}
$i = $i * 10;
}
$om = $i;
$i = 0;
//$om=1;
for ($i = 0; $i < count($data); $i++) {
$data[$i] = $data[$i] / $om;
}
$g = new Graph();
if ($maxval > 0) {
$g->title('COMPRAS DEL ' . $mes . '/' . $anio, '{font-size:18px; color: #d01f3c}');
$g->set_data($data);
$g->bar_glass(55, '#5E83BF', '#424581', 'Compras', 10);
$g->set_y_max(ceil($maxval / $om));
$g->y_label_steps(5);
$g->set_x_labels($titu);
$ejey = number_format($om, 0, '', ' ');
$g->set_y_legend('Compras X ' . $ejey . ' (Bs)', 14, '0x639F45');
$g->set_x_legend('Grupos ' . $mes, 14, '0x639F45');
//$g->pie(60,'#505050','#000000');
//$g->pie_values( $data, $titu );
//$g->pie_slice_colours( array('#d01f3c','#356aa0','#C79810','#5E83BF'));
$g->set_tool_tip('#key#<br>Departamento: #x_label# <br>Monto: #val# x ' . $ejey);
} else {
$g->title('NO EXISTEN VENTAS EN LA FECHA SELECCIONADA', '{font-size:18px; color: #d01f3c}');
}
$g->bg_colour = '#FFFFFF';
//$g->set_bg_image(site_url('/images/ventafon.png'), 'center', 'middle' );
echo $g->render();
$query->free_result();
}
