# echo '-';
# }
?>
</th>
<th style="font-weight: normal;">
<?php
##HOME
$cm = new Criteria();
$cm->add(EmployeeAbsencePeer::EMPLOYEE_ID, $employee->getId());
$cm->add(EmployeeAbsencePeer::ACADEMIC_CALENDAR_ID, $academic_calendar->getParent());
$cm->add(EmployeeAbsencePeer::STATUS, EmployeeAbsence::STATUS_HOME);
$cton5 = $cm->getNewCriterion(EmployeeAbsencePeer::DATE_IN, $thn_absence . '-' . $month2->getId() . '-1', Criteria::GREATER_EQUAL);
$cton6 = $cm->getNewCriterion(EmployeeAbsencePeer::DATE_IN, $thn_absence . '-' . ($month2->getId() + 1) . '-1', Criteria::LESS_THAN);
$cton5->addAnd($cton6);
$cm->add($cton5);
$ecs = EmployeeAbsencePeer::doSelect($cm);
$absence_home = array();
$absence_home_hour = array();
$absence_home_minute = array();
if (count($ecs)) {
foreach ($ecs as $ec) {
$absence_home[$ec->getDateIn()] = $ec->getStart('H:i:s');
$absence_home_hour[$ec->getDateIn()] = $ec->getStart('H');
$absence_home_minute[$ec->getDateIn()] = $ec->getStart('i');
}
}
# if ($hari_id != "Ahad") {
if (count($absence_home) > 0 && array_key_exists($all_tgl, $absence_home)) {
echo $absence_home[$all_tgl];
} else {
echo '-';
public function fromArray($arr, $keyType = BasePeer::TYPE_PHPNAME)
{
$keys = EmployeeAbsencePeer::getFieldNames($keyType);
if (array_key_exists($keys[0], $arr)) {
$this->setId($arr[$keys[0]]);
}
if (array_key_exists($keys[1], $arr)) {
$this->setEmployeeId($arr[$keys[1]]);
}
if (array_key_exists($keys[2], $arr)) {
$this->setAcademicCalendarId($arr[$keys[2]]);
}
if (array_key_exists($keys[3], $arr)) {
$this->setStatus($arr[$keys[3]]);
}
if (array_key_exists($keys[4], $arr)) {
$this->setStart($arr[$keys[4]]);
}
if (array_key_exists($keys[5], $arr)) {
$this->setDateIn($arr[$keys[5]]);
}
if (array_key_exists($keys[6], $arr)) {
$this->setDatang($arr[$keys[6]]);
}
}
public function executeDelete()
{
$employee_absence = EmployeeAbsencePeer::retrieveByPk($this->getRequestParameter('id'));
$this->forward404Unless($employee_absence);
$employee_id = $employee_absence->getEmployeeId();
$ref_error = 0;
foreach ($employee_absence->getRefCountMethods() as $ref) {
$method = "count" . $ref['affix'];
$count = $employee_absence->{$method}();
if ($count > 0) {
++$ref_error;
$this->getRequest()->setError('employee_absence/delete/' . sfInflector::camelize($ref['table']), $count);
}
}
if ($ref_error > 0) {
$this->getRequest()->setError('employee_absence/delete', '_ERR_DELETE_ (' . $employee_absence->toString() . ' - id:' . $employee_absence->getId() . ')');
} else {
$employee_absence->delete();
}
return $this->redirect('employee_absence/list?employee_id=' . $employee_id);
}
public function filterAbsence($c, $filters)
{
$filters_key = array_keys($filters);
foreach ($filters_key as $key) {
$value = $filters[$key];
if ($value == '' || $value == null) {
continue;
}
if ($key == 'EXTRA_CODE') {
$c->addJoin(EmployeePeer::ID, EmployeeAbsencePeer::EMPLOYEE_ID);
$c->addJoin(EmployeeDetailPeer::EMPLOYEE_ID, EmployeePeer::ID);
$column = EmployeeDetailPeer::getTableMap()->getColumn('EXTRA_CODE');
} elseif ($key == 'FINGERCODE') {
$c->addJoin(EmployeePeer::ID, EmployeeAbsencePeer::EMPLOYEE_ID);
$c->addJoin(EmployeeDetailPeer::EMPLOYEE_ID, EmployeePeer::ID);
$column = EmployeeDetailPeer::getTableMap()->getColumn('FINGERCODE');
} elseif ($key = 'EMP_NO') {
$c->addJoin(EmployeePeer::ID, EmployeeAbsencePeer::EMPLOYEE_ID);
$column = EmployeePeer::getTableMap()->getColumn('CODE');
} elseif ($key = 'EMP_NAME') {
$c->addJoin(EmployeePeer::ID, EmployeeAbsencePeer::EMPLOYEE_ID);
$column = EmployeePeer::getTableMap()->getColumn('NAME');
} elseif ($key = 'DEPARTMENT_ID') {
$c->addJoin(EmployeePeer::ID, EmployeeAbsencePeer::EMPLOYEE_ID);
$c->addJoin(DepartmentPeer::ID, EmployeePeer::DEPARTMENT_ID);
$column = DepartmentPeer::getTableMap()->getColumn('ID');
} elseif ($key = 'STATUS') {
$column = EmployeeAbsencePeer::getTableMap()->getColumn('STATUS');
} else {
$column = EmployeeAbsencePeer::getTableMap()->getColumn($key);
}
$name = $column->getFullyQualifiedName();
$creoleType = $column->getCreoleType();
if ($creoleType == CreoleTypes::TIMESTAMP) {
$from = $value['from'];
$to = $value['to'];
if ($from != '' && $from != null) {
$c->add($name, $from, Criteria::GREATER_EQUAL);
}
if ($to != '' && $to != null) {
$c->add($name, $to, Criteria::LESS_EQUAL);
}
} elseif ($creoleType == CreoleTypes::DATE) {
#$from = $value['from'];
#$to = $value['to'];
#if ($from != '' && $from != null)
# $c->add($name, $from, Criteria::GREATER_EQUAL);
#if ($to != '' && $to != null)
# $c->add($name, $to, Criteria::LESS_EQUAL);
$c->add($name, $value, Criteria::EQUAL);
} elseif ($creoleType == CreoleTypes::INTEGER) {
$c->add($name, $value, Criteria::EQUAL);
} elseif ($creoleType == CreoleTypes::VARCHAR || $creoleType == CreoleTypes::CHAR) {
$c->add($name, "%{$value}%", Criteria::LIKE);
}
}
}
public static function retrieveByPKs($pks, $con = null)
{
if ($con === null) {
$con = Propel::getConnection(self::DATABASE_NAME);
}
$objs = null;
if (empty($pks)) {
$objs = array();
} else {
$criteria = new Criteria();
$criteria->add(EmployeeAbsencePeer::ID, $pks, Criteria::IN);
$objs = EmployeeAbsencePeer::doSelect($criteria, $con);
}
return $objs;
}
