Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- function formataData($dt)
- {
- if (strpos($dt, '-') !== false) {
- list($ano, $mes, $dia) = explode('-', $dt);
- $r = "$dia/$mes/$ano";
- } else {
- list($dia, $mes, $ano) = explode('/', $dt);
- $r = "$ano-$mes-$dia";
- }
- return $r;
- }
- function Feriados($ano)
- {
- global $feriados;
- $dia = 86400;
- $datas = array();
- $datas['pascoa'] = easter_date($ano);
- $datas['sexta_santa'] = $datas['pascoa'] - (2 * $dia);
- $datas['carnaval'] = $datas['pascoa'] - (47 * $dia);
- $datas['corpus_cristi'] = $datas['pascoa'] + (60 * $dia);
- $feriados[] = date('d/m',$datas['sexta_santa']);
- $feriados[] = date('d/m',$datas['pascoa']);
- $feriados[] = date('d/m',$datas['corpus_cristi']);
- }
- function Soma1dia($data)
- {
- $data = formataData($data);
- $d = new DateTime($data);
- $i = new DateInterval('P1D');
- $d->add($i);
- return $d->format('d/m/Y');
- }
- function dataToTimestamp($data)
- {
- list($dia, $mes, $ano) = explode('/', $data);
- return mktime(0, 0, 0, $mes, $dia, $ano);
- }
- function CalculaDias($xDataInicial, $xDataFinal)
- {
- list($diaInicial, $mesInicial, $anoInicial) = explode('/', $xDataInicial);
- list($diaFinal, $mesFinal, $anoFinal) = explode('/', $xDataFinal);
- $d0 = new DateTime($anoInicial . '-' . $mesInicial . '-' . $diaInicial);
- $d1 = new DateTime($anoFinal . '-' . $mesFinal . '-' . $diaFinal);
- $diff = $d0->diff($d1);
- return $diff->format('%a');
- }
- function DiasUteis($yDataInicial,$yDataFinal)
- {
- global $feriados;
- $diaFDS = 0;
- $calculoDias = CalculaDias($yDataInicial, $yDataFinal); //número de dias entre a data inicial e a final
- list($diaInicial, $mesInicial, $anoInicial) = explode('/', $yDataInicial);
- list($diaFinal, $mesFinal, $anoFinal) = explode('/', $yDataFinal);
- $d0 = new DateTime("$anoInicial-$mesInicial-$diaInicial");
- $d1 = new DateTime("$anoFinal-$mesFinal-$diaFinal");
- for ($n = $calculoDias; $n > 0; $n--) {
- $i = new DateInterval('P' . $n . 'D');
- $d0->add($i);
- $diaSemana = $d0->format('w');
- $dataResultante = $d0->format('d/m');
- if (in_array($dataResultante, $feriados) or $diaSemana == 0 or $diaSemana == 6) {
- $diaFDS++;
- }
- }
- return $calculoDias - $diaFDS;
- }
- $feriados = array (
- '01/01',
- //'02/02',
- //date('d/m',$datas['carnaval']),
- '21/04',
- '01/05',
- '26/05',
- '20/09', // Revolução Farroupilha \m/
- '12/10',
- '02/11',
- '15/11',
- '25/12',
- );
- Feriados(date('Y'));
- mysql_connect("192.168.0.11", "root", "50ny") or die(mysql_error());
- mysql_select_db("glpi2") or die(mysql_error());
- switch (date("m")){
- case "01": $mes_extenso = Janeiro; break;
- case "02": $mes_extenso = Fevereiro; break;
- case "03": $mes_extenso = Março; break;
- case "04": $mes_extenso = Abril; break;
- case "05": $mes_extenso = Maio; break;
- case "06": $mes_extenso = Junho; break;
- case "07": $mes_extenso = Julho; break;
- case "08": $mes_extenso = Agosto; break;
- case "09": $mes_extenso = Setembro; break;
- case "10": $mes_extenso = Outubro; break;
- case "11": $mes_extenso = Novembro; break;
- case "12": $mes_extenso = Dezembro; break;
- }
- $datainicio = "01/02/2013";
- $datafim = "28/02/2013";
- $hoje = date("d/m/Y");
- $horas_uteis_dia = 8.8;
- //##########################################################################################################
- echo "<!DOCTYPE HTML>
- <html>
- <head>
- <title>Indicadores de atendimento Marelli </title>";
- //echo "<meta http-equiv='Content-Type' content='text/html; charset=UTF-8'>";
- echo "</head>
- <body>";
- echo "<font face = 'Verdana'>";
- echo "<p>Mês atual: ";
- echo $mes_extenso;
- echo "</p>";
- echo "<p>Número de Horas Úteis por dia: ";
- echo $horas_uteis_dia;
- echo "</p>";
- echo "<p>Número de dias corridos do até hoje: ";
- $dias_corridos = CalculaDias($datainicio, $hoje) + 1;
- echo $dias_corridos;
- echo "</p>";
- echo "<p>Número de dias Úteis do Mês até hoje: ";
- $diasuteis = DiasUteis($datainicio, $hoje) + 1;
- echo $diasuteis;
- echo "</p>";
- echo "<p>Número de horas Úteis do Mês até hoje: ";
- $horassuteis = round((DiasUteis($datainicio, $hoje) + 1) * $horas_uteis_dia = 8.8, 2);
- echo $horassuteis;
- echo "</p>";
- echo "<p>Número de dias Úteis do Mês: ";
- $diasuteismes = (int)DiasUteis($datainicio, $datafim) + 1;
- echo $diasuteismes;
- echo "</p>";
- $q_tot_chamados_novos = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'new'") or die(mysql_error());
- //$q_tot_chamados_novos_flavio = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'new' and users_id_lastupdater = 135") or die(mysql_error());
- //$q_tot_chamados_novos_igor = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'new' and users_id_lastupdater = 157") or die(mysql_error());
- //$q_tot_chamados_novos_rodrigo = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'new' and users_id_lastupdater = 332") or die(mysql_error());
- //$tot_chamados_novos = mysql_fetch_array( $q_tot_chamados_novos );
- //$tot_chamados_novos_flavio = mysql_fetch_array( $q_tot_chamados_novos_flavio );
- //$tot_chamados_novos_igor = mysql_fetch_array( $q_tot_chamados_novos_igor );
- //$tot_chamados_novos_rodrigo = mysql_fetch_array( $q_tot_chamados_novos_rodrigo );
- echo "<p align = 'center'>";
- echo "<font size = '6' color = '#FF0000'>";
- echo "Número de chamados não atendidos: ";
- $tot_chamados_novos = mysql_fetch_array( $q_tot_chamados_novos );
- echo $tot_chamados_novos[0];
- echo "</p>";
- echo "<table align = 'center' border='1'>";
- echo "<tr>
- <th> </th> <th width='90'>Geral</th> <th width='90'>Flavio</th> <th width='90'>Igor</th> <th width='90'>Rodrigo</th>
- </tr>";
- $q_tot_chamados_geral = mysql_query("SELECT count(*) FROM glpi_tickets WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59'") or die(mysql_error());
- $q_tot_chamados_flavio = mysql_query("SELECT count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and users_id_lastupdater = 135") or die(mysql_error());
- $q_tot_chamados_igor = mysql_query("SELECT count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and users_id_lastupdater = 157") or die(mysql_error());
- $q_tot_chamados_rodrigo = mysql_query("SELECT count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and users_id_lastupdater = 332") or die(mysql_error());
- $tot_chamados_geral = mysql_fetch_array( $q_tot_chamados_geral );
- $tot_chamados_flavio = mysql_fetch_array( $q_tot_chamados_flavio );
- $tot_chamados_igor = mysql_fetch_array( $q_tot_chamados_igor );
- $tot_chamados_rodrigo = mysql_fetch_array( $q_tot_chamados_rodrigo );
- echo "<tr align=center>";
- echo "<td align=left>Total de Chamados</td> <td>";
- echo $tot_chamados_geral[0] - $tot_chamados_novos[0];
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_flavio[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_igor[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_rodrigo[0]";
- echo "</td>";
- echo "</tr>";
- $q_tot_chamados_abertos = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'assign'") or die(mysql_error());
- $q_tot_chamados_abertos_flavio = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'assign' and users_id_lastupdater = 135") or die(mysql_error());
- $q_tot_chamados_abertos_igor = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'assign' and users_id_lastupdater = 157") or die(mysql_error());
- $q_tot_chamados_abertos_rodrigo = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'assign' and users_id_lastupdater = 332") or die(mysql_error());
- $tot_chamados_abertos = mysql_fetch_array( $q_tot_chamados_abertos );
- $tot_chamados_abertos_flavio = mysql_fetch_array( $q_tot_chamados_abertos_flavio );
- $tot_chamados_abertos_igor = mysql_fetch_array( $q_tot_chamados_abertos_igor );
- $tot_chamados_abertos_rodrigo = mysql_fetch_array( $q_tot_chamados_abertos_rodrigo );
- echo "<tr align=center>";
- echo "<td align=left>Chamados Abertos</td> <td>";
- echo "$tot_chamados_abertos[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_abertos_flavio[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_abertos_igor[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_abertos_rodrigo[0]";
- echo "</td>";
- echo "</tr>";
- $q_tot_chamados_fechados = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'closed'") or die(mysql_error());
- $q_tot_chamados_fechados_flavio = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'closed' and users_id_lastupdater = 135") or die(mysql_error());
- $q_tot_chamados_fechados_igor = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'closed' and users_id_lastupdater = 157") or die(mysql_error());
- $q_tot_chamados_fechados_rodrigo = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'closed' and users_id_lastupdater = 332") or die(mysql_error());
- $tot_chamados_fechados = mysql_fetch_array( $q_tot_chamados_fechados );
- $tot_chamados_fechados_flavio = mysql_fetch_array( $q_tot_chamados_fechados_flavio );
- $tot_chamados_fechados_igor = mysql_fetch_array( $q_tot_chamados_fechados_igor );
- $tot_chamados_fechados_rodrigo = mysql_fetch_array( $q_tot_chamados_fechados_rodrigo );
- echo "<tr align=center>";
- echo "<td align=left>Chamados Fechados</td> <td>";
- echo "$tot_chamados_fechados[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_fechados_flavio[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_fechados_igor[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_fechados_rodrigo[0]";
- echo "</td>";
- echo "</tr>";
- $q_tot_chamados_solucionados = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'solved'") or die(mysql_error());
- $q_tot_chamados_solucionados_flavio = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'solved' and users_id_lastupdater = 135") or die(mysql_error());
- $q_tot_chamados_solucionados_igor = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'solved' and users_id_lastupdater = 157") or die(mysql_error());
- $q_tot_chamados_solucionados_rodrigo = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and status = 'solved' and users_id_lastupdater = 332") or die(mysql_error());
- $tot_chamados_solucionados = mysql_fetch_array( $q_tot_chamados_solucionados );
- $tot_chamados_solucionados_flavio = mysql_fetch_array( $q_tot_chamados_solucionados_flavio );
- $tot_chamados_solucionados_igor = mysql_fetch_array( $q_tot_chamados_solucionados_igor );
- $tot_chamados_solucionados_rodrigo = mysql_fetch_array( $q_tot_chamados_solucionados_rodrigo );
- echo "<tr align=center>";
- echo "<td align=left>Chamados Solucionados</td> <td>";
- echo "$tot_chamados_solucionados[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_solucionados_flavio[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_solucionados_igor[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_solucionados_rodrigo[0]";
- echo "</td>";
- echo "</tr>";
- $q_tot_chamados_pendentes = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2000-01-01 00:00:00' AND '2013-01-31 23:59:59' and status = 'assign'") or die(mysql_error());
- $q_tot_chamados_pendentes_flavio = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2000-01-01 00:00:00' AND '2013-01-31 23:59:59' and status = 'assign' and users_id_lastupdater = 135") or die(mysql_error());
- $q_tot_chamados_pendentes_igor = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2000-01-01 00:00:00' AND '2013-01-31 23:59:59' and status = 'assign' and users_id_lastupdater = 157") or die(mysql_error());
- $q_tot_chamados_pendentes_rodrigo = mysql_query("select count(*) FROM `glpi_tickets` WHERE date BETWEEN '2000-01-01 00:00:00' AND '2013-01-31 23:59:59' and status = 'assign' and users_id_lastupdater = 332") or die(mysql_error());
- $tot_chamados_pendentes = mysql_fetch_array( $q_tot_chamados_pendentes );
- $tot_chamados_pendentes_flavio = mysql_fetch_array( $q_tot_chamados_pendentes_flavio );
- $tot_chamados_pendentes_igor = mysql_fetch_array( $q_tot_chamados_pendentes_igor );
- $tot_chamados_pendentes_rodrigo = mysql_fetch_array( $q_tot_chamados_pendentes_rodrigo );
- echo "<tr align=center>";
- echo "<td align=left>Chamados Pendentes</td> <td>";
- echo "$tot_chamados_pendentes[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_pendentes_flavio[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_pendentes_igor[0]";
- echo "</td>";
- echo "<td>";
- echo "$tot_chamados_pendentes_rodrigo[0]";
- echo "</td>";
- echo "</tr>";
- $q_tot_chamados_segundos = mysql_query("select sum(actiontime) from glpi_tickettasks where date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59'") or die(mysql_error());
- $q_tot_chamados_segundos_flavio = mysql_query("select sum(actiontime) from glpi_tickettasks where date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and users_id = 135") or die(mysql_error());
- $q_tot_chamados_segundos_igor = mysql_query("select sum(actiontime) from glpi_tickettasks where date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and users_id = 157") or die(mysql_error());
- $q_tot_chamados_segundos_rodrigo = mysql_query("select sum(actiontime) from glpi_tickettasks where date BETWEEN '2013-02-01 00:00:00' AND '2013-02-28 23:59:59' and users_id = 332") or die(mysql_error());
- $tot_chamados_segundos = mysql_fetch_array( $q_tot_chamados_segundos );
- $tot_chamados_segundos_flavio = mysql_fetch_array( $q_tot_chamados_segundos_flavio );
- $tot_chamados_segundos_igor = mysql_fetch_array( $q_tot_chamados_segundos_igor );
- $tot_chamados_segundos_rodrigo = mysql_fetch_array( $q_tot_chamados_segundos_rodrigo );
- //echo "<tr align=center>";
- // echo "<td align=left>Total em Segundos de atendimentos</td> <td>";
- // echo "$tot_chamados_segundos[0]";
- // echo "</td>";
- // echo "<td>";
- // echo "$tot_chamados_segundos_flavio[0]";
- // echo "</td>";
- // echo "<td>";
- // echo "$tot_chamados_segundos_igor[0]";
- // echo "</td>";
- // echo "<td>";
- // echo "$tot_chamados_segundos_rodrigo[0]";
- // echo "</td>";
- //echo "</tr>";
- echo "<tr align=center>";
- echo "<td align=left>Total em Horas de atendimentos</td> <td>";
- $hgeral = round ($tot_chamados_segundos[0]/3600, 2);
- $hflavio = round ($tot_chamados_segundos_flavio[0]/3600, 2);
- $higor = round ($tot_chamados_segundos_igor[0]/3600, 2);
- $hrodrigo = round ($tot_chamados_segundos_rodrigo[0]/3600, 2);
- echo "$hgeral";
- echo "</td>";
- echo "<td>";
- echo "$hflavio";
- echo "</td>";
- echo "<td>";
- echo "$higor";
- echo "</td>";
- echo "<td>";
- echo "$hrodrigo";
- echo "</td>";
- echo "</tr>";
- echo "<tr align=center>";
- echo "<td align=left>Total em Dias úteis de atendimentos</td> <td>";
- $dugeral = round ($hgeral/$horas_uteis_dia, 2);
- $duflavio = round ($hflavio/$horas_uteis_dia, 2);
- $duigor = round ($higor/$horas_uteis_dia, 2);
- $durodrigo = round ($hrodrigo/$horas_uteis_dia, 2);
- echo "$dugeral";
- echo "</td>";
- echo "<td>";
- echo "$duflavio";
- echo "</td>";
- echo "<td>";
- echo "$duigor";
- echo "</td>";
- echo "<td>";
- echo "$durodrigo";
- echo "</td>";
- echo "</tr>";
- echo "</table>";
- //##########################################################################################################
- echo "<p align=center>";
- echo "<img src=\"http://chart.apis.google.com/chart?chs=400x150&chd=t:70,30&cht=p3&chl=Homens|Mulheres&chl=70%|30%&chdl=Homens|Mulheres&chco=c60000|1da3f8&chf=bg,s,58e015\" />";
- echo "<img src=\"http://chart.apis.google.com/chart?chs=400x150&chd=t:70,30&cht=p3&chl=Homens|Mulheres&chl=70%|30%&chdl=Homens|Mulheres&chco=c60000|1da3f8&chf=bg,s,58e015\" />";
- echo "</p>";
- echo "</center>
- </body>
- </html>";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement