"; } echo "
"; } ?>
  Mes Base :   Ano Base :         Processar
  Visualizando:   $mes/$ano              
= '$diaini' AND PESQ_DTA_CAD <= '$diafim' AND PESQ_NOTA = 1 GROUP BY PESQ_USR_ID union ALL select PESQ_USR_ID, 0 REG1, count(*) REG2, 0 REG3 from PESQUISA where PESQ_EMP_ID = $cemp AND PESQ_DTA_CAD >= '$diaini' AND PESQ_DTA_CAD <= '$diafim' AND PESQ_NOTA = 2 GROUP BY PESQ_USR_ID union ALL select PESQ_USR_ID, 0 REG1, 0 REG2, count(*) REG3 from PESQUISA where PESQ_EMP_ID = $cemp AND PESQ_DTA_CAD >= '$diaini' AND PESQ_DTA_CAD <= '$diafim' AND PESQ_NOTA = 3 GROUP BY PESQ_USR_ID ) GROUP BY PESQ_USR_ID "; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { if ($cusr == '1') { $nu1 = $row->PESQ_USR_ID; $qu1 = $row->REGISTROS; $q1u1 = $row->REG1 * 100 / $row->REGISTROS; $q2u1 = $row->REG2 * 100 / $row->REGISTROS; $q3u1 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '2') { $nu2 = $row->PESQ_USR_ID; $qu2 = $row->REGISTROS; $q1u2 = $row->REG1 * 100 / $row->REGISTROS; $q2u2 = $row->REG2 * 100 / $row->REGISTROS; $q3u2 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '3') { $nu3 = $row->PESQ_USR_ID; $qu3 = $row->REGISTROS; $q1u3 = $row->REG1 * 100 / $row->REGISTROS; $q2u3 = $row->REG2 * 100 / $row->REGISTROS; $q3u3 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '4') { $nu4 = $row->PESQ_USR_ID; $qu4 = $row->REGISTROS; $q1u4 = $row->REG1 * 100 / $row->REGISTROS; $q2u4 = $row->REG2 * 100 / $row->REGISTROS; $q3u4 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '5') { $nu5 = $row->PESQ_USR_ID; $qu5 = $row->REGISTROS; $q1u5 = $row->REG1 * 100 / $row->REGISTROS; $q2u5 = $row->REG2 * 100 / $row->REGISTROS; $q3u5 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '6') { $nu6 = $row->PESQ_USR_ID; $qu6 = $row->REGISTROS; $q1u6 = $row->REG1 * 100 / $row->REGISTROS; $q2u6 = $row->REG2 * 100 / $row->REGISTROS; $q3u6 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '7') { $nu7 = $row->PESQ_USR_ID; $qu7 = $row->REGISTROS; $q1u7 = $row->REG1 * 100 / $row->REGISTROS; $q2u7 = $row->REG2 * 100 / $row->REGISTROS; $q3u7 = $row->REG3 * 100 / $row->REGISTROS; } if ($cusr == '8') { $nu8 = $row->PESQ_USR_ID; $qu8 = $row->REGISTROS; $q1u8 = $row->REG1 * 100 / $row->REGISTROS; $q2u8 = $row->REG2 * 100 / $row->REGISTROS; $q3u8 = $row->REG3 * 100 / $row->REGISTROS; } $cusr = $cusr + 1; } $stmt="select PESQ_DTA_CAD, PESQ_HORA_CAD, PESQ_USR_ID, PESQ_NOTA, PESQ_SUITE_ID from PESQUISA where PESQ_EMP_ID = $cemp AND PESQ_DTA_CAD >= '$diaini' AND PESQ_DTA_CAD <= '$diafim' ORDER BY PESQ_DTA_CAD, PESQ_HORA_CAD"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { $dt = substr($row->PESQ_DTA_CAD,8,2) . '/' . substr($row->PESQ_DTA_CAD,5,2) . '/' . substr($row->PESQ_DTA_CAD,0,4); if ($row->PESQ_NOTA == '1') { $nota = 'images/insatisfeito.gif'; $n1 = $n1 + 1; } if ($row->PESQ_NOTA == '2') { $nota = 'images/indiferente.gif'; $n2 = $n2 + 1; } if ($row->PESQ_NOTA == '3') { $nota = 'images/satisfeito.gif'; $n3 = $n3 + 1; } $reg = $reg + 1; if ($cor==1) { echo " "; $f_btn++; $cor = 0; } else { echo " "; $f_btn++; $cor = 1; } } $mesini = $mes - 2; $anoini = $ano; $anofim = $ano; if ($mesini == 0) { $mesini = 12; $anoini = $ano - 1; } if ($mesini == -1) { $mesini = 11; $anoini = $ano - 1; } $mesfim = $mes + 2; if ($mesfim == 13) { $mesfim = 1; $anofim = $ano + 1; } if ($mesfim == 14) { $mesfim = 2; $anofim = $ano + 1; } $diaini = $mesini . '/01/' . $anoini; $qdia = qtd_dias_mes($mesfim,$anofim); $diafim = $mesfim . '/' . $qdia . '/' . $anofim; echo"
 Data  Hora  Usuário  Suite  Nota
 $dt  $row->PESQ_HORA_CAD  $row->PESQ_USR_ID  $row->PESQ_SUITE_ID
 $dt  $row->PESQ_HORA_CAD  $row->PESQ_USR_ID  $row->PESQ_SUITE_ID
"; echo "  "; $p1 = $n1 * 100 / ($n1+$n2+$n3); $p2 = $n2 * 100 / ($n1+$n2+$n3); $p3 = $n3 * 100 / ($n1+$n2+$n3); echo "
            $nu1  $nu2  $nu3  $nu4  $nu5  $nu6  $nu7  $nu8
     $n3    "; printf("%6.2f", $p3); echo " %    "; printf("%6.2f", $q3u1); echo " %    "; printf("%6.2f", $q3u2); echo " %    "; printf("%6.2f", $q3u3); echo " %    "; printf("%6.2f", $q3u4); echo " %    "; printf("%6.2f", $q3u5); echo " %    "; printf("%6.2f", $q3u6); echo " %    "; printf("%6.2f", $q3u7); echo " %    "; printf("%6.2f", $q3u8); echo " %
      $n2    "; printf("%6.2f", $p2); echo " %    "; printf("%6.2f", $q2u1); echo " %    "; printf("%6.2f", $q2u2); echo " %    "; printf("%6.2f", $q2u3); echo " %    "; printf("%6.2f", $q2u4); echo " %    "; printf("%6.2f", $q2u5); echo " %    "; printf("%6.2f", $q2u6); echo " %    "; printf("%6.2f", $q2u7); echo " %    "; printf("%6.2f", $q2u8); echo " %
      $n1    "; printf("%6.2f", $p1); echo " %    "; printf("%6.2f", $q1u1); echo " %    "; printf("%6.2f", $q1u2); echo " %    "; printf("%6.2f", $q1u3); echo " %    "; printf("%6.2f", $q1u4); echo " %    "; printf("%6.2f", $q1u5); echo " %    "; printf("%6.2f", $q1u6); echo " %    "; printf("%6.2f", $q1u7); echo " %    "; printf("%6.2f", $q1u8); echo " %
  
"; } ?>