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;