include_once "../../DataTransferObjects/ContractDTO.php"; include_once "../../DataAccessObjects/IndustryDAO.php"; include_once "../../DataTransferObjects/IndustryDTO.php"; // Abre a conexao com o banco de dados $dataConnector = new DataConnector('both'); $dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null || $dataConnector->sqlserverConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } // Cria os objetos de mapeamento objeto-relacional $salesPersonDAO = new SalesPersonDAO($dataConnector->sqlserverConnection); $salesPersonDAO->showErrors = 1; $commissionPerSignatureDAO = new CommissionPerSignatureDAO($dataConnector->mysqlConnection); $commissionPerSignatureDAO->showErrors = 1; $commissionPerVolumeDAO = new CommissionPerVolumeDAO($dataConnector->mysqlConnection); $commissionPerVolumeDAO->showErrors = 1; $industryDAO = new IndustryDAO($dataConnector->sqlserverConnection); $industryDAO->showErrors = 1; $slpCode = 0; $salesPerson = new SalesPersonDTO(); if (isset($_REQUEST["slpCode"]) && $_REQUEST["slpCode"] != 0) { $slpCode = $_REQUEST["slpCode"]; $salesPerson = $salesPersonDAO->RetrieveRecord($slpCode); } // Traz as regras de comissão cadastradas no sistema $commissionRuleArray1 = $commissionPerSignatureDAO->RetrieveRecordArray(); $commissionRuleArray2 = $commissionPerVolumeDAO->RetrieveRecordArray(); // Busca os segmentos/ramos de atividade cadastrados no sistema $industryArray = array(0 => "Todos"); $tempArray = $industryDAO->RetrieveRecordArray();
include_once "../../DataAccessObjects/CommissionPerVolumeDAO.php"; include_once "../../DataTransferObjects/CommissionPerVolumeDTO.php"; if (!isset($_REQUEST["acao"])) { echo "Erro no processamento da requisição."; exit; } $acao = $_REQUEST["acao"]; // Abre a conexao com o banco de dados $dataConnector = new DataConnector('mySql'); $dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } // Cria o objeto de mapeamento objeto-relacional $commissionPerVolumeDAO = new CommissionPerVolumeDAO($dataConnector->mysqlConnection); $commissionPerVolumeDAO->showErrors = 1; if ($acao == "store") { $id = 0; $commissionRule = new CommissionPerVolumeDTO(); if (isset($_REQUEST["id"]) && $_REQUEST["id"] != 0) { $id = $_REQUEST["id"]; $commissionRule = $commissionPerVolumeDAO->RetrieveRecord($id); } $commissionRule->categoriaContrato = $_REQUEST["categoriaContrato"]; $commissionRule->quantContratosDe = $_REQUEST["quantContratosDe"]; $commissionRule->quantContratosAte = $_REQUEST["quantContratosAte"]; $commissionRule->valorFaturamentoDe = $_REQUEST["valorFaturamentoDe"]; $commissionRule->valorFaturamentoAte = $_REQUEST["valorFaturamentoAte"]; $commissionRule->comissao = $_REQUEST["comissao"]; $recordId = $commissionPerVolumeDAO->StoreRecord($commissionRule);
session_start(); include_once "../../check.php"; include_once "../../defines.php"; include_once "../../ClassLibrary/DataConnector.php"; include_once "../../DataAccessObjects/CommissionPerVolumeDAO.php"; include_once "../../DataTransferObjects/CommissionPerVolumeDTO.php"; // Abre a conexao com o banco de dados $dataConnector = new DataConnector('mySql'); $dataConnector->OpenConnection(); if ($dataConnector->mysqlConnection == null) { echo 'Não foi possível se connectar ao bando de dados!'; exit; } // Cria o objeto de mapeamento objeto-relacional $commissionPerVolumeDAO = new CommissionPerVolumeDAO($dataConnector->mysqlConnection); $commissionPerVolumeDAO->showErrors = 1; $id = 0; $commissionRule = new CommissionPerVolumeDTO(); if (isset($_REQUEST["id"]) && $_REQUEST["id"] != 0) { $id = $_REQUEST["id"]; $commissionRule = $commissionPerVolumeDAO->RetrieveRecord($id); } ?> <h1>Regra de comissão (Por volume de contratos)</h1><br/> <h1><?php echo str_pad('_', 60, '_', STR_PAD_LEFT); ?> </h1> <div style="clear:both;"> <br/><br/>