mysql_select_db($database_connSystem, $connSystem);
// generate data
$sql_data = "SELECT SUM(tktin.tktcategory_idtktcategory) as tkts, tktcategoryname FROM tktin\nINNER JOIN tktcategory ON tktin.tktcategory_idtktcategory=tktcategory.idtktcategory WHERE usrteam_idusrteam=" . $_SESSION['MVGitHub_idacteam'] . " GROUP BY tktin.tktcategory_idtktcategory";
$res_data = mysql_query($sql_data);
$num_data = mysql_num_rows($res_data);
$fet_data = mysql_fetch_array($res_data);
//get the highest - max limit
$sql_max = "SELECT SUM(tktin.tktcategory_idtktcategory) as tkts, tktcategoryname FROM tktin\nINNER JOIN tktcategory ON tktin.tktcategory_idtktcategory=tktcategory.idtktcategory WHERE usrteamzone_idusrteamzone=" . $_SESSION['MVGitHub_userteamzoneid'] . " GROUP BY tktin.tktcategory_idtktcategory ORDER BY tkts DESC LIMIT 1";
$res_max = mysql_query($sql_max);
$num_max = mysql_num_rows($res_max);
$fet_max = mysql_fetch_array($res_max);
//$max_y=($num_data * 5);
$max_y = $fet_max['tkts'] + 50;
//$bar = new bar_outline( 50, '#3399cc', '#3399ff' );
$bar = new bar_outline($max_y, '#3399cc', '#3399ff');
$bar->key('Tickets', 10);
$data = array();
$lbl = array();
if ($num_data > 0) {
do {
$bar->data[] = intval($fet_data['tkts']);
$xlabels[] = mysql_escape_string($fet_data['tktcategoryname']);
} while ($fet_data = mysql_fetch_array($res_data));
$g = new graph();
$g->data_sets[] = $bar;
$g->bg_colour = '#ffffff';
$g->set_x_labels($xlabels);
$g->set_x_label_style(10, '#9933CC', 2, 1);
//
// and tick every second value:
//
// //
////////////////////////////////////////////////////////////////////////////////////////
// generate some random data
if (! isset ( $_CONF ['PATH'] )) {
require "../../config/default.php";
}
require 'library/open-flash-chart.php';
$db = new db ( );
$db->connect ();
$bar = new bar_outline ( 50, '#6aa9e9', '#666666' );
$bar->key ( utf8_encode ( 'Gráfico de comparação das coleções ' ), 10 );
$nome_colecao = array ();
$total = $_GET ['total'];
$param = $_GET ['param'];
$vetor_url = array ();
for($i = 0; $i < $total; $i ++) {
$vetor_url [$i] = $_GET ['idcol' . $i];
}
foreach ( $vetor_url as $key => $value ) {
$sql = "SELECT idcolecao, txtnome FROM colecao WHERE idcolecao=" . $value;
function gmensuales($anio = '', $dia = '')
{
$this->load->library('Graph');
//$this->lang->load('calendar');
//if (empty($mes) or empty($dia)) return;
$fechai = $anio . '0101';
$fechaf = $anio . '1231';
$mSQL = "SELECT fecha,IF(WEEKDAY(fecha)=0,'Lunes',IF(WEEKDAY(fecha)=1,'Martes',IF(WEEKDAY(fecha)=2,'Miercoles',IF(WEEKDAY(fecha)=3,'Jueves',IF(WEEKDAY(fecha)=4,'Viernes',IF(WEEKDAY(fecha)=5,'Sabado','Domingo'))))))AS tdia,\n DATE_FORMAT(fecha,'%m')AS mes,SUM(monto)AS grantotal,SUM(impuesto)AS IVA,SUM(transac)as transacciones \n\t\tFROM est_fecha WHERE fecha>='{$fechai}' AND fecha<='{$fechaf}'AND WEEKDAY(fecha)='{$dia}'\n\t\tGROUP BY MONTH(fecha)\n\t\tORDER BY fecha ASC";
//echo $mSQL;
$maxval = 0;
$query = $this->db->query($mSQL);
foreach ($query->result() as $row) {
if ($row->grantotal > $maxval) {
$maxval = $row->grantotal;
}
$mes[] = $row->mes;
$tdia = $row->tdia;
$data_1[] = $row->grantotal;
}
$om = 1;
while ($maxval / $om > 100) {
$om = $om * 10;
}
$bar_1 = new bar_outline(50, '#56AC8B', '#3F7E66');
$bar_1->key('Monto', 10);
for ($i = 0; $i < count($data_1); $i++) {
$bar_1->add_data_tip($data_1[$i] / $om, graph::esc(number_format($data_1[$i], 2, ',', '.')));
}
$g = new graph();
$g->set_is_decimal_separator_comma(1);
if ($maxval > 0) {
$g->title('Ventas en el año ' . $anio . ' del dia ' . $tdia, '{font-size: 16px; color:##00264A}');
$g->data_sets[] = $bar_1;
$g->x_axis_colour('#A6A6A6', '#ADB5C7');
$g->set_x_labels($mes);
$g->set_x_label_style(10, '#000000', 3, 1);
$g->set_x_axis_steps(10);
$g->set_x_legend('Mes', 14, '#004381');
$g->bg_colour = '#FFFFFF';
$g->set_tool_tip('#key#<br>Mes: #x_label# <br>Monto: #tip#');
$g->set_y_max(ceil($maxval / $om));
$g->y_label_steps(5);
$g->y_axis_colour('#A6A6A6', '#ADB5C7');
$g->set_y_legend('Ventas x ' . number_format($om, 0, '', '.') . ' (Bs)', 16, '#004381');
} else {
$g->title('No existen ventas con los datos seleccionados', '{font-size:18px; color: #d01f3c}');
}
$g->bg_colour = '#FFFFFF';
echo utf8_encode($g->render());
}
// //
////////////////////////////////////////////////////////////////////////////////////////
// generate some random data
if (! isset ( $_CONF ['PATH'] )) {
require "../../config/default.php";
}
require 'library/open-flash-chart.php';
$db = new db ( );
$db->connect ();
$bar = new bar_outline ( 50, '#6aa9e9', '#666666' );
$bar->key ( utf8_encode ( 'Gráfico de comparação dos fornecedores ' ), 10 );
$nome_fornecedor = array ();
$total = $_GET ['total'];
$param = $_GET ['param'];
$vetor_url = array ();
for($i = 0; $i < $total; $i ++) {
$vetor_url [$i] = $_GET ['idfor' . $i];
}
foreach ( $vetor_url as $key => $value ) {
$sql = "SELECT idfornecedor, nome FROM fornecedor WHERE idfornecedor=" . $value;
