/**
* Read row
*
* @return AlterationMySql
*/
protected function readRow($row)
{
$alteration = new Alteration();
$alteration->setChangeIdSM($row['changeIdSM']);
$alteration->setChangeType($row['changeType']);
$alteration->setShortDescription($row['shortDescription']);
$alteration->setImpact($row['impact']);
$alteration->setAffectation($row['affectation']);
$alteration->setScheduledStart($row['scheduledStart']);
$alteration->setRollbackStart($row['rollbackStart']);
$alteration->setRollbackEnd($row['rollbackEnd']);
$alteration->setScheduledEnd($row['scheduledEnd']);
$alteration->setStateExecution($row['stateExecution']);
$alteration->setStateChange($row['stateChange']);
$alteration->setDirectionITDirectionITId($row['directionIT_directionITId']);
$alteration->setManagementITManagementITId($row['managementIT_managementITId']);
$alteration->setHeadshipITHeadshipITId($row['headshipIT_headshipITId']);
$alteration->setBossBossId($row['boss_bossId']);
$alteration->setCoordinatorCoordinatorId($row['coordinator_coordinatorId']);
$alteration->setApplicationOrInfrastructureApplicationOrInfrastructureId($row['applicationOrInfrastructure_applicationOrInfrastructureId']);
$alteration->setChangeManagerIdchangeManager($row['changeManager_idchangeManager']);
return $alteration;
}
<?php
include '../../model/generated/include_dao.php';
$appList = DAOFactory::getApplicationorinfrastructureDAO()->queryByApplicationOrInfrastructureName($_POST["applicationOrInfrastructure"]);
$coordinatorList = DAOFactory::getCoordinatorDAO()->queryByCoordinatorName($_POST["coordinator"]);
$bossList = DAOFactory::getBossDAO()->queryByBossName($_POST["boss"]);
$headshipList = DAOFactory::getHeadshipitDAO()->queryByHeadshipITName($_POST["headship"]);
$managementList = DAOFactory::getManagementitDAO()->queryByManagementITName($_POST["management"]);
$directionList = DAOFactory::getDirectionitDAO()->queryByDirectionITName($_POST["direction"]);
$change = new Alteration();
$change->setChangeIdSM($_POST["changeId"]);
$change->setChangeType($_POST["type"]);
$change->setShortDescription($_POST["shortDescription"]);
$change->setImpact($_POST["impact"]);
$change->setAffectation($_POST["affectation"]);
$change->setScheduledStart($_POST["scheduledStartDate"] . " " . $_POST["scheduledStartTime"] . ":00");
$change->setRollbackStart($_POST["rollbackStartDate"] . " " . $_POST["rollbackStartTime"] . ":00");
$change->setRollbackEnd($_POST["rollbackEndDate"] . " " . $_POST["rollbackEndTime"] . ":00");
$change->setScheduledEnd($_POST["scheduledEndDate"] . " " . $_POST["scheduledEndTime"] . ":00");
$change->setStateExecution($_POST["stateExecution"]);
$change->setApplicationOrInfrastructureApplicationOrInfrastructureId($appList[0]->getApplicationOrInfrastructureId());
$change->setCoordinatorCoordinatorId($coordinatorList[0]->getCoordinatorId());
$change->setBossBossId($bossList[0]->getBossId());
$change->setHeadshipITHeadshipITId($headshipList[0]->getHeadshipITId());
$change->setManagementITManagementITId($managementList[0]->getManagementITId());
$change->setDirectionITDirectionITId($directionList[0]->getDirectionITId());
$change->setStateChange(1);
$change->setChangeManagerIdchangeManager(1);
DAOFactory::getAlterationDAO()->update($change);
unset($change);
echo "<script>alert ('" . $_POST["changeId"] . " change was updated successfully .'); window.location='../../index.php';</script>";