// 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);