Exemplo n.º 1
0
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();
Exemplo n.º 2
0
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);
Exemplo n.º 3
0
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/>