| Relação de Manutenções |
";
$dbh = ibase_connect("$p_dir", "$p_login", "$p_senha");
$stmt=("
SELECT
COUNT(*) CONT
,MANU_SUIT_ID
,CASE SUIT_TIPO_SUITE
WHEN 1 THEN 'LUXO'
WHEN 2 THEN 'SUPER LUXO 1'
WHEN 3 THEN 'SUPER LUXO 2'
WHEN 4 THEN 'SUPER LUXO 3'
WHEN 5 THEN 'EXECUTIVA 1'
WHEN 6 THEN 'EXECUTIVA 2'
WHEN 7 THEN 'MASTER 1'
WHEN 8 THEN 'MASTER 2'
END TIPO_SUITE
FROM
MANUTENCAO
,SUITE
WHERE
SUIT_ID = MANU_SUIT_ID
AND SUIT_EMP_ID = MANU_EMP_ID
AND MANU_DTA_FECHAMENTO IS NULL
AND MANU_EMP_ID = $cemp
AND MANU_SITUACAO = 1
GROUP BY
MANU_SUIT_ID
,TIPO_SUITE");
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object ($sth))
{
$pendencia = 'Pendências';
if ($row->CONT == 1)
$pendencia = 'Pendência';
echo "";
$suite = $row->MANU_SUIT_ID;
echo "
|
|
|
|
|
|
";
$stmt2=("
SELECT
1 NUM
,'VENCIDA' STT
,MANU_SUIT_ID
,MANU_DESCRICAO
,CASE SUIT_TIPO_SUITE
WHEN 1 THEN 'LUXO'
WHEN 2 THEN 'SUPER LUXO 1'
WHEN 3 THEN 'SUPER LUXO 2'
WHEN 4 THEN 'SUPER LUXO 3'
WHEN 5 THEN 'EXECUTIVA 1'
WHEN 6 THEN 'EXECUTIVA 2'
WHEN 7 THEN 'MASTER 1'
WHEN 8 THEN 'MASTER 2'
END TIPO_SUITE
,MANU_USR_LANC
,MANU_RESPONSAVEL
,MANU_DTA_PREVISAO
,MANU_DTA_ABERTURA
,PROB_DESCRICAO
,'(' || ((MANU_DTA_PREVISAO - current_date) * -1) || ')' DIAS
,(MANU_DTA_PREVISAO - current_date)
FROM
MANUTENCAO
,SUITE
,PROBLEMAS
WHERE
SUIT_ID = MANU_SUIT_ID
AND SUIT_EMP_ID = MANU_EMP_ID
AND PROB_ID = MANU_PROB_ID
AND MANU_DTA_FECHAMENTO IS NULL
AND MANU_EMP_ID = $cemp
AND MANU_SUIT_ID = $suite
AND MANU_SITUACAO = 1
AND MANU_DTA_PREVISAO < current_date
UNION ALL
SELECT
2 NUM
,'A VENCER' STT
,MANU_SUIT_ID
,MANU_DESCRICAO
,CASE SUIT_TIPO_SUITE
WHEN 1 THEN 'LUXO'
WHEN 2 THEN 'SUPER LUXO 1'
WHEN 3 THEN 'SUPER LUXO 2'
WHEN 4 THEN 'SUPER LUXO 3'
WHEN 5 THEN 'EXECUTIVA 1'
WHEN 6 THEN 'EXECUTIVA 2'
WHEN 7 THEN 'MASTER 1'
WHEN 8 THEN 'MASTER 2'
END TIPO_SUITE
,MANU_USR_LANC
,MANU_RESPONSAVEL
,MANU_DTA_PREVISAO
,MANU_DTA_ABERTURA
,PROB_DESCRICAO
,(MANU_DTA_PREVISAO - current_date) DIAS
,(MANU_DTA_PREVISAO - current_date)
FROM
MANUTENCAO
,SUITE
,PROBLEMAS
WHERE
SUIT_ID = MANU_SUIT_ID
AND SUIT_EMP_ID = MANU_EMP_ID
AND PROB_ID = MANU_PROB_ID
AND MANU_DTA_FECHAMENTO IS NULL
AND MANU_EMP_ID = $cemp
AND MANU_SUIT_ID = $suite
AND MANU_SITUACAO = 1
AND MANU_DTA_PREVISAO >= current_date
UNION ALL
SELECT
3 NUM
,'SEM PREVISAO' STT
,MANU_SUIT_ID
,MANU_DESCRICAO
,CASE SUIT_TIPO_SUITE
WHEN 1 THEN 'LUXO'
WHEN 2 THEN 'SUPER LUXO 1'
WHEN 3 THEN 'SUPER LUXO 2'
WHEN 4 THEN 'SUPER LUXO 3'
WHEN 5 THEN 'EXECUTIVA 1'
WHEN 6 THEN 'EXECUTIVA 2'
WHEN 7 THEN 'MASTER 1'
WHEN 8 THEN 'MASTER 2'
END TIPO_SUITE
,MANU_USR_LANC
,MANU_RESPONSAVEL
,MANU_DTA_PREVISAO
,MANU_DTA_ABERTURA
,PROB_DESCRICAO
,(MANU_DTA_PREVISAO - MANU_DTA_ABERTURA) DIAS
,(MANU_DTA_PREVISAO - MANU_DTA_ABERTURA)
FROM
MANUTENCAO
,SUITE
,PROBLEMAS
WHERE
SUIT_ID = MANU_SUIT_ID
AND SUIT_EMP_ID = MANU_EMP_ID
AND PROB_ID = MANU_PROB_ID
AND MANU_DTA_FECHAMENTO IS NULL
AND MANU_EMP_ID = $cemp
AND MANU_SUIT_ID = $suite
AND MANU_SITUACAO = 1
AND MANU_DTA_PREVISAO IS NULL
ORDER BY
3,1,11
");
$sth2 = ibase_query($dbh, $stmt2);
while ($row2 = ibase_fetch_object ($sth2))
{
$data_abertura = FormatDate($row2->MANU_DTA_ABERTURA);
$data_previsao = FormatDate($row2->MANU_DTA_PREVISAO);
echo "
|
|
|
|
|
|
";
}
echo "
";
}
echo "
|
|
|
|
"; ?>