$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) {