i want one feature,that employee can apply for permission in a month not exceeding 4 hrs in total for a month. So before applying this, im checking database ,and totalling all hours sum of all ( totime- fromtime). and checking whether the hours is more than 4. I tried below code..but exactly i cannot get my need..
$total = $this->getTotalHours($emp->id,$req->perdate);
if($total > 4)
{
error_log("You cannot apply more than 4 hours");
}
private function getTotalHours($empid,$PerDate){
$amount = 0;
$newmonth = date('F', strtotime($PerDate));
$empPer = new EmployeePermission();
$leaveDays = $empPer->find("employee = ?",array($empid));
foreach($leaveDays as $leaveDay){
$month = date('F', strtotime($leaveDay->applydate));
if($newmonth == $month){
$diff = (strtotime($leave->totime) - strtotime($leave->fromtime);
}
$amount += $diff;
}
return $amount;
}
If the month while applying is july, then im checking and getting all entries in july month for that employee in database,and accumulating it and finally i have to check that.If the hour is morethan 4 hrs, then he cannot apply permission.
Edited: My requirement is, i want the total hours taken per month in Hours,Minute format. Database:
employee applydate fromtime totime status
169 2015-07-24 14:08:37 13:08:37 Approved
111 2015-07-25 11:12:26 11:30:26 Pending
111 2015-07-25 12:14:13 12:36:13 Pending
169 2015-07-27 12:00:00 14:30:00 Pending
169 2015-07-29 14:00:00 15:00:00 Pending
111 2015-07-27 16:11:26 17:11:26 Pending
