// Cria os objetos de mapeamento objeto-relacional
$invoiceDAO = new InvoiceDAO($dataConnector->sqlserverConnection);
$invoiceDAO->showErrors = 1;
$billingDAO = new BillingDAO($dataConnector->mysqlConnection);
$billingDAO->showErrors = 1;
$mailingDAO = new MailingDAO($dataConnector->mysqlConnection);
$mailingDAO->showErrors = 1;
$billingItemDAO = new BillingItemDAO($dataConnector->mysqlConnection);
$billingItemDAO->showErrors = 1;
$contractItemDAO = new ContractItemDAO($dataConnector->mysqlConnection);
$contractItemDAO->showErrors = 1;
if ($acao == "store") {
$mailing_id = $_REQUEST["mailingId"];
$startDate = $_REQUEST["dataInicial"];
$endDate = $_REQUEST["dataFinal"];
$mailing = $mailingDAO->RetrieveRecord($mailing_id);
$billingParams = 'businessPartnerCode=' . $mailing->businessPartnerCode . '&contractId=' . $mailing->contrato_id . '&subContractId=' . $mailing->subContrato_id . '&startDate=' . $startDate . '&endDate=' . $endDate . '&acrescimo=&obs=';
$report = "faturamentoContrato.php";
if (empty($mailing->contrato_id)) {
$report = "faturamentoCliente.php";
}
$reportUrl = 'http://' . $_SERVER['HTTP_HOST'] . $root . '/Frontend/mailing/' . $report . '?' . $billingParams . '&valuesOnly=true';
$billingContent = file_get_contents($reportUrl);
$billingContent = str_replace(' ', ' ', $billingContent);
$xml = simplexml_load_string('<root>' . $billingContent . '</root>');
$itemCount = 0;
$total = 0;
$rows = $xml[0];
foreach ($rows as $row) {
if (sizeof($row) == 1) {
continue;
<th> </th>
<th> Número</th>
<th> Cliente</th>
<th> Contrato(s)</th>
<th> Período</th>
<th style="text-align: center;" > Print</th>
<th style="text-align: center;" > Check</th>
</tr>
</thead>
<tbody>
<?php
if (sizeof($billingArray) == 0) {
echo '<tr><td colspan="7" align="center" >Nenhum registro encontrado!</td></tr>';
}
foreach ($billingArray as $billing) {
$mailing = $mailingDAO->RetrieveRecord($billing->mailing_id);
?>
<tr>
<td align="center">
<input type="checkbox" value= "<?php
echo $billing->id;
?>
" name="reg[]"/>
</td>
<td >
<a href="<?php
echo 'Frontend/' . $currentDir . '/editar.php?id=' . $billing->id;
?>
" >
<?php
echo str_pad($billing->id, 5, '0', STR_PAD_LEFT);
