session_start();
include_once "../check.php";
include_once "../defines.php";
include_once "../ClassLibrary/DataConnector.php";
include_once "../DataAccessObjects/AdjustmentDAO.php";
include_once "../DataTransferObjects/AdjustmentDTO.php";
$contractId = $_GET['contractId'];
// 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
$adjustmentDAO = new AdjustmentDAO($dataConnector->mysqlConnection);
$adjustmentDAO->showErrors = 1;
// Busca os reajustes do contrato
$adjustmentArray = $adjustmentDAO->RetrieveRecordArray("contrato_id=" . $contractId);
if (sizeof($adjustmentArray) == 0) {
echo "<tr>";
echo " <td colspan='3' align='center' >Nenhum registro encontrado!</td>";
echo "</tr>";
exit;
}
foreach ($adjustmentArray as $adjustment) {
?>
<tr>
<td>
<?php
echo $adjustment->data;
// Reajustado
$newContract->dataReajuste = date("Y-m-d H:i:s", time());
$recordId = $contractDAO->StoreRecord($newContract);
if ($recordId == null) {
echo "Não foi possivel efetuar a operação...";
exit;
}
$adjustmentRateDAO = new AdjustmentRateDAO($dataConnector->mysqlConnection);
$adjustmentRateDAO->showErrors = 1;
$adjustmentRate = $adjustmentRateDAO->RetrieveRecord($newContract->indiceReajuste);
$adjustment = new AdjustmentDTO();
$adjustment->contrato_id = $id;
$adjustment->data = date("Y-m-d", time());
$adjustment->indiceUtilizado = $adjustmentRate->sigla . ' - ' . $adjustmentRate->nome;
$adjustment->aliquotaUtilizada = $adjustmentRate->aliquota;
$adjustmentDAO = new AdjustmentDAO($dataConnector->mysqlConnection);
$adjustmentDAO->showErrors = 1;
$adjustmentDAO->StoreRecord($adjustment);
$contractChargeDAO = new ContractChargeDAO($dataConnector->mysqlConnection);
$contractChargeDAO->showErrors = 1;
$contractChargeArray = $contractChargeDAO->RetrieveRecordArray("contrato_id=" . $id);
foreach ($contractChargeArray as $contractCharge) {
if (isset($_REQUEST["fixoReajustado" . $contractCharge->id]) && isset($_REQUEST["variavelReajustado" . $contractCharge->id])) {
if (!$contractChargeDAO->DeleteRecord($contractCharge->id)) {
echo "Não foi possivel efetuar a operação...";
exit;
}
$updatedCharge = new ContractChargeDTO();
$updatedCharge->codigoContrato = $contractCharge->codigoContrato;
$updatedCharge->codigoSubContrato = $contractCharge->codigoSubContrato;
$updatedCharge->codigoContador = $contractCharge->codigoContador;
