function setPayPeriodType($value)
{
$value = trim($value);
Debug::Text('Type ID: ' . $value, __FILE__, __LINE__, __METHOD__, 10);
$ppsf = new PayPeriodScheduleFactory();
$key = Option::getByValue($value, $ppsf->getOptions('type'));
if ($key !== FALSE) {
$value = $key;
}
if ($this->Validator->inArrayKey('pay_period_type_id', $value, TTi18n::gettext('Incorrect pay period type'), $ppsf->getOptions('type'))) {
$this->data['pay_period_type_id'] = $value;
return FALSE;
}
return FALSE;
}
function getAPISearchByCompanyIdAndArrayCriteria($company_id, $filter_data, $limit = NULL, $page = NULL, $where = NULL, $order = NULL)
{
if ($company_id == '') {
return FALSE;
}
if (!is_array($order)) {
//Use Filter Data ordering if its set.
if (isset($filter_data['sort_column']) and $filter_data['sort_order']) {
$order = array(Misc::trimSortPrefix($filter_data['sort_column']) => $filter_data['sort_order']);
}
}
$additional_order_fields = array('status_id', 'type_id', 'pay_period_schedule');
$sort_column_aliases = array('status' => 'status_id', 'type' => 'type_id');
$order = $this->getColumnsFromAliases($order, $sort_column_aliases);
if ($order == NULL) {
$order = array('transaction_date' => 'desc', 'end_date' => 'desc', 'start_date' => 'desc', 'pay_period_schedule_id' => 'asc');
$strict = FALSE;
} else {
//Always try to order by status first so INACTIVE employees go to the bottom.
if (!isset($order['transaction_date'])) {
$order['transaction_date'] = 'desc';
}
$strict = TRUE;
}
//Debug::Arr($order,'Order Data:', __FILE__, __LINE__, __METHOD__,10);
//Debug::Arr($filter_data,'Filter Data:', __FILE__, __LINE__, __METHOD__,10);
$ppsf = new PayPeriodScheduleFactory();
$uf = new UserFactory();
$ph = array('company_id' => $company_id);
$query = '
select a.*,
b.name as pay_period_schedule,
b.type_id as type_id,
y.first_name as created_by_first_name,
y.middle_name as created_by_middle_name,
y.last_name as created_by_last_name,
z.first_name as updated_by_first_name,
z.middle_name as updated_by_middle_name,
z.last_name as updated_by_last_name
from ' . $this->getTable() . ' as a
LEFT JOIN ' . $ppsf->getTable() . ' as b ON ( a.pay_period_schedule_id = b.id AND b.deleted = 0 )
LEFT JOIN ' . $uf->getTable() . ' as y ON ( a.created_by = y.id AND y.deleted = 0 )
LEFT JOIN ' . $uf->getTable() . ' as z ON ( a.updated_by = z.id AND z.deleted = 0 )
where a.company_id = ?
';
$query .= isset($filter_data['permission_children_ids']) ? $this->getWhereClauseSQL('a.created_by', $filter_data['permission_children_ids'], 'numeric_list', $ph) : NULL;
$query .= isset($filter_data['id']) ? $this->getWhereClauseSQL('a.id', $filter_data['id'], 'numeric_list', $ph) : NULL;
$query .= isset($filter_data['exclude_id']) ? $this->getWhereClauseSQL('a.id', $filter_data['exclude_id'], 'not_numeric_list', $ph) : NULL;
if (isset($filter_data['status']) and trim($filter_data['status']) != '' and !isset($filter_data['status_id'])) {
$filter_data['status_id'] = Option::getByFuzzyValue($filter_data['status'], $this->getOptions('status'));
}
$query .= isset($filter_data['status_id']) ? $this->getWhereClauseSQL('a.status_id', $filter_data['status_id'], 'numeric_list', $ph) : NULL;
if (isset($filter_data['type']) and trim($filter_data['type']) != '' and !isset($filter_data['type_id'])) {
$filter_data['type_id'] = Option::getByFuzzyValue($filter_data['type'], $ppsf->getOptions('type'));
}
$query .= isset($filter_data['type_id']) ? $this->getWhereClauseSQL('b.type_id', $filter_data['type_id'], 'numeric_list', $ph) : NULL;
$query .= isset($filter_data['pay_period_schedule_id']) ? $this->getWhereClauseSQL('a.pay_period_schedule_id', $filter_data['pay_period_schedule_id'], 'numeric_list', $ph) : NULL;
$query .= isset($filter_data['pay_period_schedule']) ? $this->getWhereClauseSQL('b.name', $filter_data['pay_period_schedule'], 'text', $ph) : NULL;
$query .= isset($filter_data['name']) ? $this->getWhereClauseSQL('b.name', $filter_data['name'], 'text', $ph) : NULL;
/*
if ( isset($filter_data['permission_children_ids']) AND isset($filter_data['permission_children_ids'][0]) AND !in_array(-1, (array)$filter_data['permission_children_ids']) ) {
$query .= ' AND a.created_by in ('. $this->getListSQL($filter_data['permission_children_ids'], $ph) .') ';
}
if ( isset($filter_data['id']) AND isset($filter_data['id'][0]) AND !in_array(-1, (array)$filter_data['id']) ) {
$query .= ' AND a.id in ('. $this->getListSQL($filter_data['id'], $ph) .') ';
}
if ( isset($filter_data['exclude_id']) AND isset($filter_data['exclude_id'][0]) AND !in_array(-1, (array)$filter_data['exclude_id']) ) {
$query .= ' AND a.id not in ('. $this->getListSQL($filter_data['exclude_id'], $ph) .') ';
}
if ( isset($filter_data['pay_period_schedule_id']) AND isset($filter_data['pay_period_schedule_id'][0]) AND !in_array(-1, (array)$filter_data['pay_period_schedule_id']) ) {
$query .= ' AND a.pay_period_schedule_id in ('. $this->getListSQL($filter_data['pay_period_schedule_id'], $ph) .') ';
}
if ( isset($filter_data['status_id']) AND isset($filter_data['status_id'][0]) AND !in_array(-1, (array)$filter_data['status_id']) ) {
$query .= ' AND a.status_id in ('. $this->getListSQL($filter_data['status_id'], $ph) .') ';
}
if ( isset($filter_data['type_id']) AND isset($filter_data['type_id'][0]) AND !in_array(-1, (array)$filter_data['type_id']) ) {
$query .= ' AND b.type_id in ('. $this->getListSQL($filter_data['type_id'], $ph) .') ';
}
if ( isset($filter_data['name']) AND trim($filter_data['name']) != '' ) {
$ph[] = strtolower(trim($filter_data['name']));
$query .= ' AND lower(b.name) LIKE ?';
}
*/
/*
if ( isset($filter_data['start_date']) AND trim($filter_data['start_date']) != '' ) {
$ph[] = $this->db->BindTimeStamp($filter_data['start_date']);
$query .= ' AND a.start_date >= ?';
}
if ( isset($filter_data['end_date']) AND trim($filter_data['end_date']) != '' ) {
$ph[] = $this->db->BindTimeStamp($filter_data['end_date']);
$query .= ' AND a.start_date <= ?';
}
*/
$query .= isset($filter_data['start_date']) ? $this->getWhereClauseSQL('a.start_date', $filter_data['start_date'], 'date_range_timestamp', $ph) : NULL;
$query .= isset($filter_data['end_date']) ? $this->getWhereClauseSQL('a.end_date', $filter_data['end_date'], 'date_range_timestamp', $ph) : NULL;
$query .= isset($filter_data['transaction_date']) ? $this->getWhereClauseSQL('a.transaction_date', $filter_data['transaction_date'], 'date_range_timestamp', $ph) : NULL;
$query .= isset($filter_data['created_by']) ? $this->getWhereClauseSQL(array('a.created_by', 'y.first_name', 'y.last_name'), $filter_data['created_by'], 'user_id_or_name', $ph) : NULL;
$query .= isset($filter_data['updated_by']) ? $this->getWhereClauseSQL(array('a.updated_by', 'z.first_name', 'z.last_name'), $filter_data['updated_by'], 'user_id_or_name', $ph) : NULL;
$query .= '
AND a.deleted = 0
';
$query .= $this->getWhereSQL($where);
$query .= $this->getSortSQL($order, $strict, $additional_order_fields);
$this->ExecuteSQL($query, $ph, $limit, $page);
return $this;
}
$last_date = $punch_obj->getPunchControlObject()->getUserDateObject()->getDateStamp();
} else {
$last_date = TTDate::getTime();
}
Debug::Text('Last Punch Date: ' . TTDate::getDate('DATE+TIME', $last_date), __FILE__, __LINE__, __METHOD__, 10);
//Get pay period of last shift workd
$plf = new PayPeriodListFactory();
$pay_period_obj = $plf->getByUserIdAndEndDate($user_id, $last_date)->getCurrent();
$pay_period_type_id = FALSE;
if (is_object($pay_period_obj->getPayPeriodScheduleObject())) {
$pay_period_type_id = $pay_period_obj->getPayPeriodScheduleObject()->getType();
}
$roe_data = array('user_id' => $user_id, 'pay_period_type_id' => $pay_period_type_id, 'first_date' => $first_date, 'last_date' => $last_date, 'pay_period_end_date' => $pay_period_obj->getEndDate());
}
//Select box options;
$roe_data['code_options'] = $roef->getOptions('code');
$ppsf = new PayPeriodScheduleFactory();
$roe_data['pay_period_type_options'] = $ppsf->getOptions('type');
unset($roe_data['pay_period_type_options'][5]);
$user_options = UserListFactory::getByCompanyIdArray($current_company->getId(), FALSE);
$smarty->assign_by_ref('user_options', $user_options);
//PSEA accounts
$psealf = new PayStubEntryAccountListFactory();
$earning_pay_stub_entry_account_options = $psealf->getByCompanyIdAndStatusIdAndTypeIdArray($current_company->getId(), 10, array(10, 30, 40), TRUE);
$smarty->assign_by_ref('earning_pay_stub_entry_account_options', $earning_pay_stub_entry_account_options);
$smarty->assign_by_ref('roe_data', $roe_data);
$smarty->assign_by_ref('setup_data', $setup_data);
break;
}
$smarty->assign_by_ref('roef', $roef);
$smarty->display('roe/EditROE.tpl');
}
$ppsf->FailTransaction();
default:
if (isset($id)) {
BreadCrumb::setCrumb($title);
$ppslf = new PayPeriodScheduleListFactory();
$ppslf->GetByIdAndCompanyId($id, $current_company->getId());
foreach ($ppslf as $pay_period_schedule) {
//Debug::Arr($station,'Department', __FILE__, __LINE__, __METHOD__,10);
$pay_period_schedule_data = array('id' => $pay_period_schedule->getId(), 'company_id' => $pay_period_schedule->getCompany(), 'name' => $pay_period_schedule->getName(), 'description' => $pay_period_schedule->getDescription(), 'type' => $pay_period_schedule->getType(), 'start_week_day_id' => $pay_period_schedule->getStartWeekDay(), 'start_day_of_week' => $pay_period_schedule->getStartDayOfWeek(), 'transaction_date' => $pay_period_schedule->getTransactionDate(), 'primary_day_of_month' => $pay_period_schedule->getPrimaryDayOfMonth(), 'secondary_day_of_month' => $pay_period_schedule->getSecondaryDayOfMonth(), 'primary_transaction_day_of_month' => $pay_period_schedule->getPrimaryTransactionDayOfMonth(), 'secondary_transaction_day_of_month' => $pay_period_schedule->getSecondaryTransactionDayOfMonth(), 'transaction_date_bd' => $pay_period_schedule->getTransactionDateBusinessDay(), 'anchor_date' => $pay_period_schedule->getAnchorDate(), 'annual_pay_periods' => $pay_period_schedule->getAnnualPayPeriods(), 'day_start_time' => $pay_period_schedule->getDayStartTime(), 'time_zone' => $pay_period_schedule->getTimeZone(), 'new_day_trigger_time' => $pay_period_schedule->getNewDayTriggerTime(), 'maximum_shift_time' => $pay_period_schedule->getMaximumShiftTime(), 'shift_assigned_day_id' => $pay_period_schedule->getShiftAssignedDay(), 'timesheet_verify_before_end_date' => (int) $pay_period_schedule->getTimeSheetVerifyBeforeEndDate(), 'timesheet_verify_before_transaction_date' => (int) $pay_period_schedule->getTimeSheetVerifyBeforeTransactionDate(), 'timesheet_verify_notice_before_transaction_date' => $pay_period_schedule->getTimeSheetVerifyNoticeBeforeTransactionDate(), 'timesheet_verify_notice_email' => $pay_period_schedule->getTimeSheetVerifyNoticeEmail(), 'user_ids' => $pay_period_schedule->getUser(), 'deleted' => $pay_period_schedule->getDeleted(), 'created_date' => $pay_period_schedule->getCreatedDate(), 'created_by' => $pay_period_schedule->getCreatedBy(), 'updated_date' => $pay_period_schedule->getUpdatedDate(), 'updated_by' => $pay_period_schedule->getUpdatedBy(), 'deleted_date' => $pay_period_schedule->getDeletedDate(), 'deleted_by' => $pay_period_schedule->getDeletedBy());
}
} elseif ($action != 'submit') {
$pay_period_schedule_data = array('anchor_date' => TTDate::getBeginMonthEpoch(time()), 'day_start_time' => 0, 'new_day_trigger_time' => 3600 * 4, 'maximum_shift_time' => 3600 * 16, 'time_zone' => $current_user_prefs->getTimeZone(), 'type' => 20, 'timesheet_verify_before_end_date' => 0, 'timesheet_verify_before_transaction_date' => 0, 'annual_pay_periods' => 0);
}
//Select box options;
$pay_period_schedule_data['type_options'] = $ppsf->getOptions('type');
$pay_period_schedule_data['startweekday_options'] = $ppsf->getOptions('startweekday');
$pay_period_schedule_data['shift_assigned_day_options'] = $ppsf->getOptions('shift_assigned_day');
$pay_period_schedule_data['time_zone_options'] = $ppsf->getTimeZoneOptions();
$pay_period_schedule_data['transaction_date_bd_options'] = $ppsf->getOptions('transaction_date_business_day');
$pay_period_schedule_data['day_of_week_options'] = TTDate::getDayOfWeekArray();
$pay_period_schedule_data['transaction_date_options'] = Misc::prependArray(array(0 => '0'), TTDate::getDayOfMonthArray());
$pay_period_schedule_data['day_of_month_options'] = TTDate::getDayOfMonthArray();
$pay_period_schedule_data['day_of_month_options'][-1] = TTi18n::gettext('- Last Day Of Month -');
$pay_period_schedule_data['user_options'] = UserListFactory::getByCompanyIdArray($current_company->getId(), FALSE, TRUE);
if (isset($pay_period_schedule_data['user_ids']) and is_array($pay_period_schedule_data['user_ids'])) {
$tmp_user_options = UserListFactory::getByCompanyIdArray($current_company->getId(), FALSE, TRUE);
foreach ($pay_period_schedule_data['user_ids'] as $user_id) {
if (isset($tmp_user_options[$user_id])) {
$filter_user_options[$user_id] = $tmp_user_options[$user_id];
}
function getObjectAsArray($include_columns = NULL)
{
$variable_function_map = $this->getVariableToFunctionMap();
if (is_array($variable_function_map)) {
$ppsf = new PayPeriodScheduleFactory();
foreach ($variable_function_map as $variable => $function_stub) {
if ($include_columns == NULL or isset($include_columns[$variable]) and $include_columns[$variable] == TRUE) {
$function = 'get' . $function_stub;
switch ($variable) {
case 'status':
$function = 'get' . $variable;
if (method_exists($this, $function)) {
$data[$variable] = Option::getByKey($this->{$function}(), $this->getOptions($variable));
}
break;
case 'type':
//Make sure type_id is set first.
if (isset($data['type_id'])) {
$data[$variable] = Option::getByKey($data['type_id'], $ppsf->getOptions($variable));
} else {
$data[$variable] = NULL;
}
break;
case 'type_id':
case 'pay_period_schedule':
$data[$variable] = $this->getColumn($variable);
break;
case 'start_date':
case 'end_date':
case 'transaction_date':
if (method_exists($this, $function)) {
$data[$variable] = TTDate::getAPIDate('DATE+TIME', $this->{$function}());
}
break;
default:
if (method_exists($this, $function)) {
$data[$variable] = $this->{$function}();
}
break;
}
}
}
$this->getCreatedAndUpdatedColumns(&$data, $include_columns);
}
return $data;
}
