$billingItem->ajuste = $row->td[7];
$billingItem->franquia = $row->td[8];
$billingItem->excedente = $row->td[9];
$billingItem->tarifaSobreExcedente = $row->td[10];
$billingItem->fixo = $row->td[11];
$billingItem->variavel = $row->td[12];
$billingItem->total = $row->td[13];
$billingItem->acrescimoDesconto = $acrescimoDescontoIndividual;
$billingItemDAO->StoreRecord($billingItem);
}
echo "Operação efetuada com sucesso!";
}
if ($acao == "remove") {
$id = $_REQUEST['id'];
$invoiceNum = 0;
$invoiceArray = $invoiceDAO->RetrieveRecordArray(null, "U_demFaturamento = '" . $id . "'");
if (sizeof($invoiceArray) > 0) {
$invoice = $invoiceArray[0];
$invoiceNum = $invoice->docNum;
}
if ($invoiceNum > 0) {
echo "Não é possível excluir este faturamento pois a fatura NF " . $invoice->serial . " faz referência a ele.";
echo "Modifique a nota fiscal para que aponte para outro faturamento e tente novamente.";
exit;
}
if (!$billingDAO->DeleteRecord($id)) {
echo "Não foi possivel efetuar a operação...";
exit;
}
echo "Operação efetuada com sucesso!";
}
$returnedInvoiceList = "";
foreach ($returnedInvoiceArray as $returnedInvoice) {
if (!empty($returnedInvoiceList)) {
$returnedInvoiceList .= ", ";
}
$returnedInvoiceList = $returnedInvoiceList . $returnedInvoice->docNum;
}
if (empty($returnedInvoiceList)) {
$returnedInvoiceList = "0";
}
// Busca as notas que se enquadram no filtro aplicado
$invoiceArray = array();
if ($searchMethod == 0 || $searchMethod == 2) {
$joins = "JOIN INV1 ON OINV.DocEntry = INV1.DocEntry";
$filter = "cardCode='" . $businessPartnerCode . "' AND OINV.DocDate BETWEEN '" . $startDate . "' AND '" . $endDate . "' AND INV1.ItemCode = 'S001' AND OINV.DocNum NOT IN (" . $returnedInvoiceList . ")";
$invoiceArray = $invoiceDAO->RetrieveRecordArray($joins, $filter);
}
if ($searchMethod == 1) {
$joins = "JOIN INV1 ON OINV.DocEntry = INV1.DocEntry";
$filter = "OINV.DocDate BETWEEN '" . $startDate . "' AND '" . $endDate . "' AND INV1.ItemCode = 'S001' AND OINV.DocNum NOT IN (" . $returnedInvoiceList . ")";
$invoiceArray = $invoiceDAO->RetrieveRecordArray($joins, $filter);
}
if ($searchMethod == 3) {
$joins = "JOIN INV1 ON OINV.DocEntry = INV1.DocEntry";
$filter = "cardCode='" . $businessPartnerCode . "' AND OINV.DocDate BETWEEN '" . $startDate . "' AND '" . $endDate . "' AND INV1.ItemCode = 'S001' AND OINV.DocNum NOT IN (" . $returnedInvoiceList . ")";
$invoiceArray = $invoiceDAO->RetrieveRecordArray($joins, $filter);
}
// Busca os vendedores cadastrados no sistema
$retrievedArray = $salesPersonDAO->RetrieveRecordArray();
$salesPersonArray = array();
foreach ($retrievedArray as $salesPersonDTO) {
