<th>Apply Date</th>
<th>Name</th>
<th>Leave From</th>
<th>Leave To</th>
<th>Apply For</th>
<th>Leave Type</th>
<th>Total Remain Days</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$objLeaveApplication = new LeaveApplication();
$result = $objLeaveApplication->getLeaveForRecomandation();
while ($row = mysqli_fetch_array($result)) {
?>
<tr>
<td name="livType"><?php
echo $row['lApplyDate'];
?>
</td>
<td><?php
echo $row['eFirstName'] . " " . $row['eLastName'] . "<br/>User Id :" . $row['lEmployeeCodeNumberWhoApply'];
?>
</td>
<td><?php
echo $row['lLeaveFromDate'];
?>
<th>Apply Date</th>
<th>Name</th>
<th>Leave From</th>
<th>Leave To</th>
<th>Apply For</th>
<th>Leave Type</th>
<th>Total Remain Days</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$objLeaveApplication = new LeaveApplication();
$result = $objLeaveApplication->getRecomandedApplication();
while ($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php
echo $row['lApplyDate'];
?>
</td>
<td><?php
echo $row['eFirstName'] . " " . $row['eLastName'];
?>
</td>
<td><?php
echo $row['lLeaveFromDate'];
?>
?>
</TABLE>
</td>
<td class="tableNoThreeTwo">
</td>
</tr>
</table>
<br>
<table class="tableNoTwo">
<tr>
<td class="tableNoThreeOne">
<TABLE class="tableNofour">
<?php
$objLeaveApplication = new LeaveApplication();
$result = $objLeaveApplication->AppliedEmpAlternativeEmpDetailsInfo($empId);
while ($row = mysqli_fetch_array($result)) {
?>
<TR>
<TD class="tdStyle" colspan="2">Person to look after my desk during my absence</TD>
</TR>
<tr>
<TD> </TD>
</tr>
<TR>
<TD class="tdStyleNoUnderLine">Name</TD>
<TD>: <?php
}
} else {
?>
<div class="form-group">
<label for="livAltEmpCode">Alternative Employee Code Name: </label>
<input type="text" class="form-control" placeholder="Alternative Employee Code Name ...." name="livAltEmpCode" id="livAltEmpCode" required>
</div>
<div class="form-group">
<label for="livEmplivType">Leave Type: </label>
<?php
$objLeaveApplication = new LeaveApplication();
$singleResult = $objLeaveApplication->getLeaveType();
while ($empResult = mysqli_fetch_array($singleResult)) {
?>
<div class="radio">
<label><input type="radio" name="livEmplivType" value="<?php
echo $empResult['lId'];
?>
" required><?php
echo $empResult['lType'];
?>
</label>
</div>
<?php
}
?>
/**
* Save a leave application
*/
public function saveapplicationAction()
{
$user = $this->userService->getUser((int) $this->_getParam('userid'));
try {
$this->_setParam('username', $user->getUsername());
$params = $this->filterParams();
$model = $this->userService->applyForLeave($user, $params);
} catch (InvalidModelException $ime) {
$this->flash($ime->getMessages());
$model = new LeaveApplication();
$model->bind($this->_getAllParams());
$this->applyAction($model);
return;
}
$this->onModelSaved($model);
}
}
} else {
$objForLeaveDaysRemain = new LeaveApplication();
$result = $objForLeaveDaysRemain->forNewLeaveDaysRemain($livUserCode, $livUserLeaveType);
if (mysqli_fetch_array($result) == null) {
$objForLeaveDaysRemain = new LeaveApplication();
$leaveTotal = $objForLeaveDaysRemain->forLeaveDays($livUserLeaveType);
while ($rowTotal = mysqli_fetch_array($leaveTotal)) {
$lTotalLeaveDaysRemain = $rowTotal['lTotalDays'] - $lTotalLeaveDays;
}
//echo "From If : TotalLeaveDaysRemain = ".$lTotalLeaveDaysRemain."<br/>";
} else {
$objForLeaveDaysRemain = new LeaveApplication();
$result = $objForLeaveDaysRemain->forNewLeaveDaysRemain($livUserCode, $livUserLeaveType);
while ($row = mysqli_fetch_array($result)) {
$lTotalLeaveDaysRemain = $row['lTotalLeaveDaysRemain'] - $lTotalLeaveDays;
//echo "From Else : TotalLeaveDaysRemain = ".$lTotalLeaveDaysRemain."<br/>";
}
}
}
//echo "<br/>User Id : ".$livUserId."<br/> From : ".$livUserLeaveFrom."<br/> To : ".$livUserLeaveTo."<br/> Type : ".$livUserLeaveType."<br/>Difference Between Two Date : ".$lTotalLeaveDays."<br/> Total Days Remain : ".$lTotalLeaveDaysRemain;
$objLeaveApplication = new LeaveApplication();
$objLeaveApplication->updateOnesApplicattion($livUserId, $livUserLeaveFrom, $livUserLeaveTo, $livUserLeaveType, $lTotalLeaveDays, $lTotalLeaveDaysRemain, $livApplicationUpdateBy);
if ($objLeaveApplication->CreatedOrNot) {
$_SESSION['applicationUpdate'] = 1;
header("Location:../view/Applications.php");
} else {
echo "Sorry";
//header("Location:../view/Applications.php");
}
}
