public function searchChange($val2)
{
include '../../model/generated/include_dao.php';
$changeList = DAOFactory::getAlterationDAO()->load($val2);
$scheduledStartDate = substr($changeList->getScheduledStart(), 0, 10);
$scheduledStartTime = substr($changeList->getScheduledStart(), 11, 16);
$rollbackStartDate = substr($changeList->getRollbackStart(), 0, 10);
$rollbackStartTime = substr($changeList->getRollbackStart(), 11, 16);
$rollbackEndDate = substr($changeList->getRollbackEnd(), 0, 10);
$rollbackEndTime = substr($changeList->getRollbackEnd(), 11, 16);
$scheduledEndDate = substr($changeList->getScheduledEnd(), 0, 10);
$scheduledEndTime = substr($changeList->getScheduledEnd(), 11, 16);
$appList = DAOFactory::getApplicationorinfrastructureDAO()->load($changeList->getApplicationOrInfrastructureApplicationOrInfrastructureId());
$coordinatorList = DAOFactory::getCoordinatorDAO()->load($changeList->getCoordinatorCoordinatorId());
echo json_encode(array("type" => $changeList->getChangeType(), "shortDescription" => $changeList->getShortDescription(), "impact" => $changeList->getImpact(), "affectation" => $changeList->getAffectation(), "scheduledStartDate" => $scheduledStartDate, "scheduledStartTime" => $scheduledStartTime, "rollbackStartDate" => $rollbackStartDate, "rollbackStartTime" => $rollbackStartTime, "rollbackEndDate" => $rollbackEndDate, "rollbackEndTime" => $rollbackEndTime, "scheduledEndDate" => $scheduledEndDate, "scheduledEndTime" => $scheduledEndTime, "stateExecution" => $changeList->getStateExecution(), "applicationOrInfrastructure" => $appList->getApplicationOrInfrastructureName(), "coordinator" => $coordinatorList->getCoordinatorName()));
}
<th><center>Coordinator</center></th>
<th><center>Boss</center></th>
<th><center>Headship IT</center></th>
<th><center>Management IT</center></th>
<th><center>Direction IT</center></th>
</tr>
</thead>
<tbody>
<?php
include 'model/generated/include_dao.php';
$changeList = DAOFactory::getAlterationDAO()->queryAll();
$managementitList = DAOFactory::getManagementitDAO()->queryAll();
$directionList = DAOFactory::getDirectionitDAO()->queryAll();
foreach ($changeList as $change) {
echo '<tr class="success">' . '<td>' . $change->getChangeIdSM() . '</td>' . '<td>' . $change->getChangeType() . '</td>' . '<td>' . $change->getShortDescription() . '</td>' . '<td>' . $change->getImpact() . '</td>' . '<td>' . $change->getAffectation() . '</td>' . '<td>' . $change->getScheduledStart() . '</td>' . '<td>' . $change->getRollbackStart() . '</td>' . '<td>' . $change->getRollbackEnd() . '</td>' . '<td>' . $change->getScheduledEnd() . '</td>' . '<td>' . $change->getStateExecution() . '</td>';
$appList = DAOFactory::getApplicationorinfrastructureDAO()->load($change->getApplicationOrInfrastructureApplicationOrInfrastructureId());
$coordinatorList = DAOFactory::getCoordinatorDAO()->load($change->getCoordinatorCoordinatorId());
$bossList = DAOFactory::getBossDAO()->load($change->getBossBossId());
$headshipList = DAOFactory::getHeadshipitDAO()->load($change->getHeadshipITHeadshipITId());
$managementList = DAOFactory::getManagementitDAO()->load($change->getManagementITManagementITId());
$directionList = DAOFactory::getDirectionitDAO()->load($change->getDirectionITDirectionITId());
echo '<td>' . $appList->getApplicationOrInfrastructureName() . '</td>' . '<td>' . $coordinatorList->getCoordinatorName() . '</td>' . '<td>' . $bossList->getBossName() . '</td>' . '<td>' . $headshipList->getHeadshipITName() . '</td>' . '<td>' . $managementList->getManagementITName() . '</td>' . '<td>' . $directionList->getDirectionITName() . '</td>' . '</tr>';
}
?>
</tbody>
</table>
</div>
<div class="top-big-link">
<a class="btn btn-link-1" href="index.php" data-modal-id="modal-register"> <span class="glyphicon glyphicon-arrow-left" aria-hidden="true"></span> Back</a>
</div>
<div id="foot">
<input id="scheduledEndDateRUD" type="text" name="scheduledEndDate" placeholder="Scheduled end date..." class="form-control half">
<input id="scheduledEndTimeRUD" type="time" name="scheduledEndTime" placeholder="Scheduled end time HH:MM:SS..." class="form-control half" required>
</div>
<div class="form-group">
<select type="text" name="stateExecution" placeholder="Change state..." id="stateExecutionRUD" class="form-control">
<option>Successful</option>
<option>Rollback</option>
<option>Canceled</option>
<option>Incident</option>
<option>Postponed</option>
</select>
</div>
<div class="form-group">
<?php
include 'model/generated/include_dao.php';
$appList = DAOFactory::getApplicationorinfrastructureDAO()->queryAll();
$contentApps = <<<CF
<select type='text' name='applicationOrInfrastructure' placeholder='Application or infrastructure...' id='applicationOrInfrastructureRUD' class='form-control'>
CF;
echo $contentApps;
foreach ($appList as $applicationOrInfrastructure) {
echo "<option>" . $applicationOrInfrastructure->getApplicationOrInfrastructureName() . "</option>";
}
$contentApps = <<<CF
</select>
</div>
<div class='form-group'>
CF;
echo $contentApps;
$coordinatorList = DAOFactory::getCoordinatorDAO()->queryAll();
$contentCoordinator = <<<CF
<?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>";
