"; ?>
"; } ?>
  Mes Base :   Ano Base : onMouseOut='MM_swapImgRestore()' onMouseOver="MM_swapImage('Image6','','images/bt_ok002.gif',1)">Processar
Processar
  Visualizando:   $mes/$ano              
= '$diaini' AND ALUG_DTA_CAD <= '$diafim'"; $sth = ibase_query($dbh, $stmt); while ($row = ibase_fetch_object ($sth)) { $cortesias = $row->CORTESIAS . '  [ ' . $row->ALUG_CORT_100 . ' DE 100% - ' . $row->ALUG_CORT_50 . ' DE 50% ]'; $bonus = $row->BONUS; $vips = $row->ALUG_VIPS; $cancelados = $row->CANCELADOS; $manut = $row->MANUT; $faxina = $row->FAXINA; $revisao = $row->REVISAO; if ($row->ALUG_QTDE1 == 0) { $vlr1 = 0; } else { $vlr1 = str_replace(".",",",$row->ALUG_VALOR1 / $row->ALUG_QTDE1); } if ($row->ALUG_QTDE2 == 0) { $vlr2 = 0; } else { $vlr2 = str_replace(".",",",$row->ALUG_VALOR2 / $row->ALUG_QTDE2); } if ($row->ALUG_QTDE3 == 0) { $vlr3 = 0; } else { $vlr3 = str_replace(".",",",$row->ALUG_VALOR3 / $row->ALUG_QTDE3); } if ($row->ALUG_QTDE4 == 0) { $vlr4 = 0; } else { $vlr4 = str_replace(".",",",$row->ALUG_VALOR4 / $row->ALUG_QTDE4); } if ($row->ALUG_QTDE5 == 0) { $vlr5 = 0; } else { $vlr5 = str_replace(".",",",$row->ALUG_VALOR5 / $row->ALUG_QTDE5); } if ($row->ALUG_QTDE6 == 0) { $vlr6 = 0; } else { $vlr6 = str_replace(".",",",$row->ALUG_VALOR6 / $row->ALUG_QTDE6); } if ($row->ALUG_QTDE7 == 0) { $vlr7 = 0; } else { $vlr7 = str_replace(".",",",$row->ALUG_VALOR7 / $row->ALUG_QTDE7); } if ($row->ALUG_QTDE8 == 0) { $vlr8 = 0; } else { $vlr8 = str_replace(".",",",$row->ALUG_VALOR8 / $row->ALUG_QTDE8); } $nta = $row->ALUG_QTDE1 + $row->ALUG_QTDE2 + $row->ALUG_QTDE3 + $row->ALUG_QTDE4 + $row->ALUG_QTDE5 + $row->ALUG_QTDE6 + $row->ALUG_QTDE7 + $row->ALUG_QTDE8; if ($nta * 100 == 0) $npa1 = 0; else $npa1 = $row->ALUG_QTDE1 / $nta * 100; if ($nta * 100 == 0) $npa2 = 0; else $npa2 = $row->ALUG_QTDE2 / $nta * 100; if ($nta * 100 == 0) $npa3 = 0; else $npa3 = $row->ALUG_QTDE3 / $nta * 100; if ($nta * 100 == 0) $npa4 = 0; else $npa4 = $row->ALUG_QTDE4 / $nta * 100; if ($nta * 100 == 0) $npa5 = 0; else $npa5 = $row->ALUG_QTDE5 / $nta * 100; if ($nta * 100 == 0) $npa6 = 0; else $npa6 = $row->ALUG_QTDE6 / $nta * 100; if ($nta * 100 == 0) $npa7 = 0; else $npa7 = $row->ALUG_QTDE7 / $nta * 100; if ($nta * 100 == 0) $npa8 = 0; else $npa8 = $row->ALUG_QTDE8 / $nta * 100; $ae1 = $row->ALUG_QTDE1 * $vlr1; $ae2 = $row->ALUG_QTDE2 * $vlr2; $ae3 = $row->ALUG_QTDE3 * $vlr3; $ae4 = $row->ALUG_QTDE4 * $vlr4; $ae5 = $row->ALUG_QTDE5 * $vlr5; $ae6 = $row->ALUG_QTDE6 * $vlr6; $ae7 = $row->ALUG_QTDE7 * $vlr7; $ae8 = $row->ALUG_QTDE8 * $vlr8; $ntv = $ae1 + $ae2 + $ae3 + $ae4 + $ae5 + $ae6 + $ae7 + $ae8; if ($ntv * 100 == 0) $npv1 = 0; else $npv1 = $ae1 / $ntv * 100; if ($ntv * 100 == 0) $npv2 = 0; else $npv2 = $ae2 / $ntv * 100; if ($ntv * 100 == 0) $npv3 = 0; else $npv3 = $ae3 / $ntv * 100; if ($ntv * 100 == 0) $npv4 = 0; else $npv4 = $ae4 / $ntv * 100; if ($ntv * 100 == 0) $npv5 = 0; else $npv5 = $ae5 / $ntv * 100; if ($ntv * 100 == 0) $npv6 = 0; else $npv6 = $ae6 / $ntv * 100; if ($ntv * 100 == 0) $npv7 = 0; else $npv7 = $ae7 / $ntv * 100; if ($ntv * 100 == 0) $npv8 = 0; else $npv8 = $ae8 / $ntv * 100; $qta = $row->ALUG_HORA1 + $row->ALUG_HORA2 + $row->ALUG_HORA3; if ($qta * 100 == 0) $pa1 = 0; else $pa1 = $row->ALUG_HORA1 / $qta * 100; if ($qta * 100 == 0) $pa2 = 0; else $pa2 = $row->ALUG_HORA2 / $qta * 100; if ($qta * 100 == 0) $pa3 = 0; else $pa3 = $row->ALUG_HORA3 / $qta * 100; $qtp = $row->ALUG_PERMA1 + $row->ALUG_PERMA2 + $row->ALUG_PERMA3 + $row->ALUG_PERMA4; if ($qtp * 100 == 0) $pp1 = 0; else $pp1 = $row->ALUG_PERMA1 / $qtp * 100; if ($qtp * 100 == 0) $pp2 = 0; else $pp2 = $row->ALUG_PERMA2 / $qtp * 100; if ($qtp * 100 == 0) $pp3 = 0; else $pp3 = $row->ALUG_PERMA3 / $qtp * 100; if ($qtp * 100 == 0) $pp4 = 0; else $pp4 = $row->ALUG_PERMA4 / $qtp * 100; echo "
    
 
TIPO DE SUITE TOTAL DE ALUGUEL % DO TOTAL DE ALUGUEL
LUXO $row->ALUG_QTDE1 "; printf("%6.2f", $npa1); echo "
SUPER LUXO 1 $row->ALUG_QTDE2 "; printf("%6.2f", $npa2); echo "
SUPER LUXO 2 $row->ALUG_QTDE3 "; printf("%6.2f", $npa3); echo "
SUPER LUXO 3 $row->ALUG_QTDE4 "; printf("%6.2f", $npa4); echo "
EXECUTIVA 1 $row->ALUG_QTDE5 "; printf("%6.2f", $npa5); echo "
EXECUTIVA 2 $row->ALUG_QTDE6 "; printf("%6.2f", $npa6); echo "
MASTER 1 $row->ALUG_QTDE7 "; printf("%6.2f", $npa7); echo "
MASTER 2 $row->ALUG_QTDE8 "; printf("%6.2f", $npa8); echo "
 
 
CONTROLE VENDA MEDIA COM CONSUMO MEDIA SEM CONSUMO
EM % "; printf("%6.2f", $row->ALUG_MED_COM_CONSUMO); echo " % "; printf("%6.2f", $row->ALUG_MED_SEM_CONSUMO); echo " %
 
 
HORÁRIO 08:00 ÀS 16:00 16:00 ÀS 00:00 00:00 ÀS 08:00 TOTAL ALUGUEIS
ALUGUÉIS $row->ALUG_HORA1 $row->ALUG_HORA2 $row->ALUG_HORA3 $qta
% ALUGUÉIS "; printf("%6.2f", $pa1); echo " "; printf("%6.2f", $pa2); echo " "; printf("%6.2f", $pa3); echo " -
 
 
TEMPO ATÉ 02:00 DE 02:01 A 4:00 ACIMA DE 04:00 PERNOITE TOTAL DE ALUGUEL
ALUGUÉIS $row->ALUG_PERMA1 $row->ALUG_PERMA2 $row->ALUG_PERMA3 tp: $row->ALUG_PERMA4   [V: $row->ALUG_VIAJANTE] [C: $row->ALUG_CASAL] $qtp
% ALUGUÉIS "; printf("%6.2f", $pp1); echo " "; printf("%6.2f", $pp2); echo " "; printf("%6.2f", $pp3); echo " "; printf("%6.2f", $pp4); echo " -
    
 
"; $stmt2 = "SELECT SUM(CONS_VLR_TOTAL) TOTAL ,SUM(CONS_QTD) Q_TOTAL FROM CONSUMO_SUITE WHERE CONS_EMP_ID = $codemp AND CONS_DTA_MOV >= '$diaini' AND CONS_DTA_MOV <= '$diafim'"; $sth2 = ibase_query($dbh, $stmt2); while ($row = ibase_fetch_object ($sth2)) { $STotal = $row->TOTAL; $STotalQ = $row->Q_TOTAL; } $stmt2 = "SELECT CONS_SUIT_ID ,SUM(CONS_VLR_TOTAL) CONS_VLR_TOTAL ,SUM(CONS_QTD) CONS_QTD FROM CONSUMO_SUITE WHERE CONS_EMP_ID = $codemp AND CONS_DTA_MOV >= '$diaini' AND CONS_DTA_MOV <= '$diafim' GROUP BY CONS_SUIT_ID"; $sth2 = ibase_query($dbh, $stmt2); while ($row = ibase_fetch_object ($sth2)) { $CMedia = $row->CONS_VLR_TOTAL * 100 / $STotal; $CMediaQ = $row->CONS_QTD * 100 / $STotalQ; echo ""; } echo "
CONSUMO POR SUITE TOTAL POR SUITE % DE CONSUMO QTD POR SUITE % DE QTD
SUITE $row->CONS_SUIT_ID "; printf("%6.2f", $row->CONS_VLR_TOTAL); echo "      "; printf("%6.2f", $CMedia); echo "      "; printf("%6.0f", $row->CONS_QTD); echo "      "; printf("%6.2f", $CMediaQ); echo "     
 
 
"; $stmt2 = "SELECT SUM(VENF_VLR_TOTAL) TOTAL FROM VENDA_FORMA WHERE VENF_EMP_ID = $codemp AND VENF_DTA_MOV >= '$diaini' AND VENF_DTA_MOV <= '$diafim'"; $sth2 = ibase_query($dbh, $stmt2); while ($row = ibase_fetch_object ($sth2)) { $STotal = $row->TOTAL; } $stmt2 = "SELECT VENF_FORMA ,SUM(VENF_VLR_TOTAL) VENF_VLR_TOTAL FROM VENDA_FORMA WHERE VENF_EMP_ID = $codemp AND VENF_DTA_MOV >= '$diaini' AND VENF_DTA_MOV <= '$diafim' GROUP BY VENF_FORMA"; $sth2 = ibase_query($dbh, $stmt2); while ($row = ibase_fetch_object ($sth2)) { if ($row->VENF_FORMA == 1) $forma = 'DINHEIRO'; if ($row->VENF_FORMA == 2) $forma = 'CHEQUE'; if ($row->VENF_FORMA == 3) $forma = 'CARTAO DE CREDITO'; if ($row->VENF_FORMA == 4) $forma = 'VALE'; $CMedia = $row->VENF_VLR_TOTAL * 100 / $STotal; echo ""; } echo "
VENDA POR FORMA DE PAGAMENTO TOTAL POR FORMA % POR FORMA
        $forma "; printf("%6.2f", $row->VENF_VLR_TOTAL); echo "     "; printf("%6.2f", $CMedia); echo "     
 
    
     Quantidade por Tipos de Descontos         
    
    Bonus $bonus
    Cortesias $cortesias
    Cartões Vip $vips
    Cancelados $cancelados
    Manutenção $manut
    Faxina $faxina
    Revisão Turno $revisao
    
"; $pqg1 = $npa1 * 5; $pqg2 = $npa2 * 5; $pqg3 = $npa3 * 5; $pqg4 = $npa4 * 5; $pqg5 = $npa5 * 5; $pqg6 = $npa6 * 5; $pqg7 = $npa7 * 5; $pqg8 = $npa8 * 5; $pvg1 = $npv1 * 5; $pvg2 = $npv2 * 5; $pvg3 = $npv3 * 5; $pvg4 = $npv4 * 5; $pvg5 = $npv5 * 5; $pvg6 = $npv6 * 5; $pvg7 = $npv7 * 5; $pvg8 = $npv8 * 5; $phg1 = $pa1 * 5; $phg2 = $pa2 * 5; $phg3 = $pa3 * 5; $ppg1 = $pp1 * 5; $ppg2 = $pp2 * 5; $ppg3 = $pp3 * 5; $ppg4 = $pp4 * 5; echo "
    
    Qtde. Aluguel
    LUXO   "; printf("%6.2f", $npa1); echo " %
    SUPER-LUXO 1   "; printf("%6.2f", $npa2); echo " %
    SUPER-LUXO 2   "; printf("%6.2f", $npa3); echo " %
    SUPER-LUXO 3   "; printf("%6.2f", $npa4); echo " %
    EXECUTIVA 1   "; printf("%6.2f", $npa5); echo " %
    EXECUTIVA 2   "; printf("%6.2f", $npa6); echo " %
    MASTER 1   "; printf("%6.2f", $npa7); echo " %
    MASTER 2   "; printf("%6.2f", $npa8); echo " %
    
    
    Horário          
    08:00 ÀS 16:00   "; printf("%6.2f", $pa1); echo " %
    16:00 ÀS 00:00   "; printf("%6.2f", $pa2); echo " %
    00:00 ÀS 08:00   "; printf("%6.2f", $pa3); echo " %
    
    
    Tempo
    ATÉ 02:00   "; printf("%6.2f", $pp1); echo " %
    DE 02:01 A 4:00   "; printf("%6.2f", $pp2); echo " %
    ACIMA DE 04:00   "; printf("%6.2f", $pp3); echo " %
    PERNOITE   "; printf("%6.2f", $pp4); echo " %
    
"; } } echo "
  
"; } ?>