function totalTableFooter($field, $returnType) { global $conn, $from_date, $to_date, $additionalReq, $LocalCalls; global $isNoCityCalls, $LongDistanceCalls, $MobileCallsR; global $InternationalCalls, $debug, $cacheflush, $GUI_LANG; global $REGEXP, $NOT_REGEXP; global $TTFfirst; switch ($field) { case "4": // Всего: общее количество звонков $q = "SELECT COUNT(*)\n\t\tfrom calls\n\t\twhere\n\t\t((calls.timeofcall>='" . $from_date . "') AND (calls.timeofcall<='" . $to_date . "')\n\t\t" . $additionalReq . "\n\t\t" . VectorOfCall(MathVector(0)) . "\n\t\t)"; break; case "5": // Всего: городские $q = "SELECT SUM(calls.duration),COUNT(*)\n\t\tfrom calls\n\t\twhere\n\t\t((calls.timeofcall>='" . $from_date . "') AND (calls.timeofcall<='" . $to_date . "')\n\t\t" . $additionalReq . "\n\t\t" . VectorOfCall(MathVector(14)) . "\n\t\t)"; $Qcomment = $GUI_LANG['City']; break; case "6": // Всего: межгород $q = "SELECT SUM(calls.duration),COUNT(*)\n\t\tfrom calls\n\t\twhere\n\t\t((calls.timeofcall>='" . $from_date . "') AND (calls.timeofcall<='" . $to_date . "')\n\t\t" . $additionalReq . "\n\t\t" . VectorOfCall(MathVector(13)) . "\n\t\t)"; $Qcomment = $GUI_LANG['Trunk']; break; case "7": // Всего: мобильная связь $q = "SELECT SUM(calls.duration),COUNT(*)\n\t\tfrom calls\n\t\twhere ((calls.timeofcall>='" . $from_date . "') AND (calls.timeofcall<='" . $to_date . "')\n\t\t" . $additionalReq . "\n\t\t" . VectorOfCall(MathVector(11)) . "\n\t\t)"; $Qcomment = $GUI_LANG['Mobile']; break; case "8": // Всего: международная связь $q = "SELECT SUM(calls.duration),COUNT(*)\n\t\tfrom calls\n\t\twhere ((calls.timeofcall>='" . $from_date . "') AND (calls.timeofcall<='" . $to_date . "')\n\t\t" . $additionalReq . "\n\t\t" . VectorOfCall(MathVector(7)) . "\n\t\t)"; $Qcomment = $GUI_LANG['LongDistance']; break; } if ($cacheflush) { $res = $conn->CacheFlush($q); } $local_cacheflush = ""; $res = $conn->CacheExecute($q); if ($debug) { echo "<hr>" . $q . "<br><hr>"; } if ($returnType == 1) { $results = $res->fields[0]; if (!$TTFfirst) { $TTFfirst = TRUE; } } else { $total = $res->fields; if ($total[0]) { if ($returnType == 0 && $TTFfirst) { $results = "<BR>\n"; } $results .= "{$Qcomment}: "; if ($returnType == 0) { $results .= sumTotal($total[0], 1); } else { $results .= sumTotal($total[0], 2); } if ($total[1]) { $results .= ". " . $GUI_LANG['OfCalls'] . ": "; } if ($returnType == 0) { $results .= "<b>"; } $results .= $total[1]; if ($returnType == 0) { $results .= "</b>\n"; } if (!$TTFfirst) { $TTFfirst = TRUE; } } } return $results; }
echo " </td>"; print "</tr>\n"; if ($pages > 1 or $debug) { echo "<tr " . $COLORS['TotalTrBgcolor'] . "><td>" . $GUI_LANG['Altogether'] . ": </td>"; echo "<td colspan=3>"; echo totalTableFooter('5', 0); echo totalTableFooter('6', 0); echo totalTableFooter('7', 0); echo totalTableFooter('8', 0); echo " </td>"; print "</tr>\n"; } print "</table>\n\n </td></tr></table>"; } else { array($TTF); $TTF[3] = $GUI_LANG['GeneralDuration'] . ": " . sumTotal($InAll[3], 2); if ($pages > 1 or $debug) { array($TTFa); $TTFa[5] = totalTableFooter('5', 2); $TTFa[6] = totalTableFooter('6', 2); $TTFa[7] = totalTableFooter('7', 2); $TTFa[8] = totalTableFooter('8', 2); } TTFprint(); } if (!empty($export)) { $expor_excel->GeraArquivo(); } // ------------------------------------------------------------------------------------------------------ } else { print "<br><font size=+1>" . $GUI_LANG['NoSuchData'] . "</font>";
} if (empty($MobLine)) { $expor_excel->MontaConteudo($linha + 3, 4, sumTotal($InAll[5], 0)); } if (empty($NationalLine)) { $expor_excel->MontaConteudo($linha + 3, 5, sumTotal($InAll[6], 0)); } if ($pages > 1 or $debug) { $expor_excel->MontaConteudo($linha + 4, 0, $GUI_LANG['Altogether'] . ":"); $expor_excel->MontaConteudo($linha + 4, 1, totalTableFooter('4', 1)); if (empty($CityLine)) { $expor_excel->MontaConteudo($linha + 4, 2, sumTotal(totalTableFooter('5', 1), 0)); } if (empty($TrunkLine)) { $expor_excel->MontaConteudo($linha + 4, 3, sumTotal(totalTableFooter('6', 1), 0)); } if (empty($MobLine)) { $expor_excel->MontaConteudo($linha + 4, 4, sumTotal(totalTableFooter('7', 1), 0)); } if (empty($NationalLine)) { $expor_excel->MontaConteudo($linha + 4, 5, sumTotal(totalTableFooter('8', 1), 0)); } } } if (!empty($export)) { $expor_excel->GeraArquivo(); } // ------------------------------------------------------------------------------------------------------ } else { echo "<font size=+1>" . $GUI_LANG['NoSuchData'] . "</font>"; }
<th>OCs Emitidos</th> <th>OCs Aprov.</th> <th>% OCs Aprov.</th> <th>Planos Emitidos</th> <th>Planos Aprov.</th> <th>% Planos Aprov.</th> <th>Ref. Est.</th> <th>Ref. Cri.</th> <th>Ref. Ate.</th> <th>Ref. Cli.</th> <th>Total Refacao</th> <th>% Refacao</th> </tr> <?php foreach ($result as $item) { if (sumTotal($item)) { ?> <tr> <td><?php echo $item['nome']; ?> </td> <td><?php echo $item['pitG']; ?> </td> <td><?php echo $item['pitA']; ?> </td>