//Get exclude employee list
$exclude_user_options = Misc::prependArray($all_array_option, $ulf->getArrayByListFactory($ulf, FALSE, TRUE));
$filter_data['src_exclude_user_options'] = Misc::arrayDiffByKey((array) $filter_data['exclude_user_ids'], $user_options);
$filter_data['selected_exclude_user_options'] = Misc::arrayIntersectByKey((array) $filter_data['exclude_user_ids'], $user_options);
//Get employee status list.
$user_status_options = Misc::prependArray($all_array_option, $ulf->getOptions('status'));
$filter_data['src_user_status_options'] = Misc::arrayDiffByKey((array) $filter_data['user_status_ids'], $user_status_options);
$filter_data['selected_user_status_options'] = Misc::arrayIntersectByKey((array) $filter_data['user_status_ids'], $user_status_options);
//Get Employee Groups
$uglf = new UserGroupListFactory();
$group_options = Misc::prependArray($all_array_option, $uglf->getArrayByNodes(FastTree::FormatArray($uglf->getByCompanyIdArray($current_company->getId()), 'TEXT', TRUE)));
$filter_data['src_group_options'] = Misc::arrayDiffByKey((array) $filter_data['group_ids'], $group_options);
$filter_data['selected_group_options'] = Misc::arrayIntersectByKey((array) $filter_data['group_ids'], $group_options);
//Get branches
$blf = new BranchListFactory();
$blf->getByCompanyId($current_company->getId());
$branch_options = Misc::prependArray($all_array_option, $blf->getArrayByListFactory($blf, FALSE, TRUE));
$filter_data['src_branch_options'] = Misc::arrayDiffByKey((array) $filter_data['branch_ids'], $branch_options);
$filter_data['selected_branch_options'] = Misc::arrayIntersectByKey((array) $filter_data['branch_ids'], $branch_options);
//Get departments
$dlf = new DepartmentListFactory();
$dlf->getByCompanyId($current_company->getId());
$department_options = Misc::prependArray($all_array_option, $dlf->getArrayByListFactory($dlf, FALSE, TRUE));
$filter_data['src_department_options'] = Misc::arrayDiffByKey((array) $filter_data['department_ids'], $department_options);
$filter_data['selected_department_options'] = Misc::arrayIntersectByKey((array) $filter_data['department_ids'], $department_options);
//Get employee titles
$utlf = new UserTitleListFactory();
$utlf->getByCompanyId($current_company->getId());
$user_title_options = Misc::prependArray($all_array_option, $utlf->getArrayByListFactory($utlf, FALSE, TRUE));
$filter_data['src_user_title_options'] = Misc::arrayDiffByKey((array) $filter_data['user_title_ids'], $user_title_options);
$filter_data['selected_user_title_options'] = Misc::arrayIntersectByKey((array) $filter_data['user_title_ids'], $user_title_options);
static function getByCompanyIdArray($company_id, $include_blank = TRUE, $include_disabled = TRUE)
{
$blf = new BranchListFactory();
$blf->getByCompanyId($company_id);
return $blf->getArrayByListFactory($blf, $include_blank, $include_disabled);
}
$uf = $ulf->getCurrent();
} elseif ($ulf->getRecordCount() == 0) {
echo " User Not Found, Inserting...\n";
} else {
echo " More Than One User Found, Skipping!\n";
continue;
}
} elseif ($update_column != FALSE and !isset($mapped_row[$update_column])) {
echo " Update Column Not Found In CSV File!\n";
}
echo " Importing User: {$i}. " . str_pad(Misc::importCallInputParseFunction('first_name', $mapped_row['first_name'], $filtered_import_map['first_name']['default_value'], $filtered_import_map['first_name']['parse_hint']) . " " . Misc::importCallInputParseFunction('last_name', $mapped_row['last_name'], $filtered_import_map['last_name']['default_value'], $filtered_import_map['last_name']['parse_hint']), 30, '.', STR_PAD_RIGHT) . "... ";
if (isset($mapped_row['company_id']) and $mapped_row['company_id'] != '') {
//Get all branches
$branch_options = $branch_manual_id_options = array();
$blf = new BranchListFactory();
$blf->getByCompanyId($mapped_row['company_id']);
if ($blf->getRecordCount() > 0) {
foreach ($blf as $b_obj) {
$branch_options[$b_obj->getId()] = $b_obj->getName();
$branch_manual_id_options[$b_obj->getId()] = $b_obj->getManualId();
}
}
//$branch_options = (array)$blf->getArrayByListFactory( $blf, FALSE, TRUE );
unset($blf, $b_obj);
//Get departments
$department_options = $department_manual_id_options = array();
$dlf = new DepartmentListFactory();
$dlf->getByCompanyId($mapped_row['company_id']);
if ($dlf->getRecordCount() > 0) {
foreach ($dlf as $d_obj) {
$department_options[$d_obj->getId()] = $d_obj->getName();
function getPunchData()
{
if ($this->StationCheckAllowed() !== TRUE) {
Debug::text('Station NOT allowed: ', __FILE__, __LINE__, __METHOD__, 10);
return FALSE;
}
$epoch = TTDate::getTime();
$slf = new ScheduleListFactory();
//Get last punch for this day, for this user.
$plf = new PunchListFactory();
$plf->getPreviousPunchByUserIDAndEpoch($this->getUserObject()->getId(), $epoch);
if ($plf->getRecordCount() > 0) {
$prev_punch_obj = $plf->getCurrent();
Debug::Text(' Found Previous Punch within Continuous Time from now, ID: ' . $prev_punch_obj->getId(), __FILE__, __LINE__, __METHOD__, 10);
$branch_id = $prev_punch_obj->getPunchControlObject()->getBranch();
$department_id = $prev_punch_obj->getPunchControlObject()->getDepartment();
$job_id = $prev_punch_obj->getPunchControlObject()->getJob();
$job_item_id = $prev_punch_obj->getPunchControlObject()->getJobItem();
//Don't enable transfer by default if the previous punch was any OUT punch.
//Transfer does the OUT punch for them, so if the previous punch is an OUT punch
//we don't gain anything anyways.
if ($this->getPermissionObject()->Check('punch', 'default_transfer') and $prev_punch_obj->getStatus() == 10) {
$transfer = TRUE;
} else {
$transfer = FALSE;
}
if ($branch_id == '' or empty($branch_id) or $department_id == '' or empty($department_id) or $job_id == '' or empty($job_id) or $job_item_id == '' or empty($job_item_id)) {
Debug::Text(' Branch or department are null. ', __FILE__, __LINE__, __METHOD__, 10);
$s_obj = $slf->getScheduleObjectByUserIdAndEpoch($this->getUserObject()->getId(), $epoch);
if (is_object($s_obj)) {
Debug::Text(' Found Schedule!: ', __FILE__, __LINE__, __METHOD__, 10);
if ($branch_id == '' or empty($branch_id)) {
Debug::Text(' overrriding branch: ' . $s_obj->getBranch(), __FILE__, __LINE__, __METHOD__, 10);
$branch_id = $s_obj->getBranch();
}
if ($department_id == '' or empty($department_id)) {
Debug::Text(' overrriding department: ' . $s_obj->getDepartment(), __FILE__, __LINE__, __METHOD__, 10);
$department_id = $s_obj->getDepartment();
}
if ($job_id == '' or empty($job_id)) {
Debug::Text(' overrriding job: ' . $s_obj->getJob(), __FILE__, __LINE__, __METHOD__, 10);
$job_id = $s_obj->getJob();
}
if ($job_item_id == '' or empty($job_item_id)) {
Debug::Text(' overrriding job item: ' . $s_obj->getJobItem(), __FILE__, __LINE__, __METHOD__, 10);
$job_item_id = $s_obj->getJobItem();
}
}
}
$next_type = $prev_punch_obj->getNextType();
//Check for break policy window.
if ($next_type != 30 and ($prev_punch_obj->getStatus() != 30 and $prev_punch_obj->getType() != 30)) {
$prev_punch_obj->setUser($this->getUserObject()->getId());
$prev_punch_obj->setScheduleID($prev_punch_obj->findScheduleID($epoch));
if ($prev_punch_obj->inBreakPolicyWindow($epoch, $prev_punch_obj->getTimeStamp()) == TRUE) {
Debug::Text(' Setting Type to Break: ', __FILE__, __LINE__, __METHOD__, 10);
$next_type = 30;
}
}
//Check for meal policy window.
if ($next_type != 20 and ($prev_punch_obj->getStatus() != 20 and $prev_punch_obj->getType() != 20)) {
$prev_punch_obj->setUser($this->getUserObject()->getId());
$prev_punch_obj->setScheduleID($prev_punch_obj->findScheduleID($epoch));
if ($prev_punch_obj->inMealPolicyWindow($epoch, $prev_punch_obj->getTimeStamp()) == TRUE) {
Debug::Text(' Setting Type to Lunch: ', __FILE__, __LINE__, __METHOD__, 10);
$next_type = 20;
}
}
Debug::Text(' cJob Item ID: ' . $job_item_id, __FILE__, __LINE__, __METHOD__, 10);
$note = '';
if ((int) $prev_punch_obj->getNextStatus() == 20) {
$note = $prev_punch_obj->getPunchControlObject()->getNote();
}
$data = array('user_id' => (int) $this->getUserObject()->getId(), 'user_full_name' => $this->getUserObject()->getFullName(), 'time_stamp' => TTDate::getDate('TIME', $epoch), 'date_stamp' => TTDate::getDate('DATE', $epoch), 'full_time_stamp' => $epoch, 'iso_time_stamp' => TTDate::getDBTimeStamp($epoch, FALSE), 'transfer' => $transfer, 'branch_id' => (int) $branch_id, 'department_id' => (int) $department_id, 'job_id' => $job_id, 'job_item_id' => $job_item_id, 'quantity' => $prev_punch_obj->getPunchControlObject()->getQuantity(), 'bad_quantity' => $prev_punch_obj->getPunchControlObject()->getBadQuantity(), 'note' => (string) $note, 'other_id1' => $prev_punch_obj->getPunchControlObject()->getOtherID1(), 'other_id2' => $prev_punch_obj->getPunchControlObject()->getOtherID2(), 'other_id3' => $prev_punch_obj->getPunchControlObject()->getOtherID3(), 'other_id4' => $prev_punch_obj->getPunchControlObject()->getOtherID4(), 'other_id5' => $prev_punch_obj->getPunchControlObject()->getOtherID5(), 'status_id' => (int) $prev_punch_obj->getNextStatus(), 'type_id' => (int) $next_type, 'punch_control_id' => (int) $prev_punch_obj->getNextPunchControlID());
unset($note);
} else {
Debug::Text(' DID NOT Find Previous Punch within Continuous Time from now: ', __FILE__, __LINE__, __METHOD__, 10);
//These used to be NULLs, but as of TT v3.0 they cause deserilizer errors with a Java client.
$branch_id = '';
$department_id = '';
$job_id = '';
$job_item_id = '';
$s_obj = $slf->getScheduleObjectByUserIdAndEpoch($this->getUserObject()->getId(), $epoch);
if (is_object($s_obj)) {
Debug::Text(' Found Schedule! ID:' . $s_obj->getID() . ' Job ID: ' . $s_obj->getJob(), __FILE__, __LINE__, __METHOD__, 10);
$branch_id = $s_obj->getBranch();
$department_id = $s_obj->getDepartment();
$job_id = $s_obj->getJob();
$job_item_id = $s_obj->getJobItem();
} else {
//Check for defaults
$branch_id = $this->getUserObject()->getDefaultBranch();
$department_id = $this->getUserObject()->getDefaultDepartment();
//Check station for default/forced settings.
if (is_object($this->getStationObject())) {
if ($this->getStationObject()->getDefaultBranch() !== FALSE and $this->getStationObject()->getDefaultBranch() != 0) {
$branch_id = $this->getStationObject()->getDefaultBranch();
}
if ($this->getStationObject()->getDefaultDepartment() !== FALSE and $this->getStationObject()->getDefaultDepartment() != 0) {
$department_id = $this->getStationObject()->getDefaultDepartment();
}
if ($this->getStationObject()->getDefaultJob() !== FALSE and $this->getStationObject()->getDefaultJob() != 0) {
$job_id = $this->getStationObject()->getDefaultJob();
}
if ($this->getStationObject()->getDefaultJobItem() !== FALSE and $this->getStationObject()->getDefaultJobItem() != 0) {
$job_item_id = $this->getStationObject()->getDefaultJobItem();
}
}
}
$data = array('user_id' => (int) $this->getUserObject()->getId(), 'user_full_name' => $this->getUserObject()->getFullName(), 'time_stamp' => TTDate::getDate('TIME', $epoch), 'date_stamp' => TTDate::getDate('DATE', $epoch), 'full_time_stamp' => $epoch, 'iso_time_stamp' => TTDate::getDBTimeStamp($epoch, FALSE), 'transfer' => FALSE, 'branch_id' => (int) $branch_id, 'department_id' => (int) $department_id, 'job_id' => $job_id, 'job_item_id' => $job_item_id, 'status_id' => 10, 'type_id' => 10);
}
//Get options.
$blf = new BranchListFactory();
$blf->getByCompanyId($this->getCompanyObject()->getId());
$branch_options = $blf->getArrayByListFactory($blf, TRUE, FALSE);
$dlf = new DepartmentListFactory();
$dlf->getByCompanyId($this->getCompanyObject()->getId());
$department_options = $dlf->getArrayByListFactory($dlf, TRUE, FALSE);
$job_options = array();
$job_item_options = array();
if (getTTProductEdition() == TT_PRODUCT_PROFESSIONAL) {
$jlf = new JobListFactory();
$job_options = $jlf->getByCompanyIdAndUserIdAndStatusArray($this->getCompanyObject()->getId(), $this->getUserObject()->getId(), array(10), TRUE);
$jilf = new JobItemListFactory();
$job_item_options = $jilf->getByCompanyIdArray($this->getCompanyObject()->getId(), TRUE);
}
$pf = new PunchFactory();
//Select box options;
$data['status_options'] = $pf->getOptions('status');
$data['type_options'] = $pf->getOptions('type');
$data['branch_options'] = $branch_options;
$data['department_options'] = $department_options;
$data['job_options'] = $job_options;
$data['job_item_options'] = $job_item_options;
//Hack for PHP v5.0.4 shotty SOAP.
//If it can cast the first array key to a INT, it rekeys the entire array.
//02-Nov-09: Using NULL values causes the Java client to throw a deserlizer error. Using '' causes blank entries.
/*
$data['status_options'] = Misc::prependArray( array('_' => FALSE ), $data['status_options'] );
$data['type_options'] = Misc::prependArray( array('_' => FALSE ), $data['type_options'] );
$data['branch_options'] = Misc::prependArray( array('_' => FALSE ), $data['branch_options'] );
$data['department_options'] = Misc::prependArray( array('_' => FALSE ), $data['department_options'] );
$data['job_options'] = Misc::prependArray( array('_' => FALSE ), $data['job_options'] );
$data['job_item_options'] = Misc::prependArray( array('_' => FALSE ), $data['job_item_options'] );
*/
$data['timeout'] = 5;
$data['date_format_example'] = (string) $this->getUserObject()->getUserPreferenceObject()->getDateFormatExample();
$data['time_format_example'] = (string) $this->getUserObject()->getUserPreferenceObject()->getTimeFormatExample();
//Debug::Arr($data, 'punchDataArray', __FILE__, __LINE__, __METHOD__,10);
if (!$this->getPermissionObject()->Check('job', 'enabled')) {
unset($data['job_options']);
unset($data['job_item_options']);
}
//Debug::Arr($data, 'Return Data: ', __FILE__, __LINE__, __METHOD__,10);
return $data;
}
function getByCompanyIdArray($company_id)
{
if ($company_id == '') {
return FALSE;
}
$blf = new BranchListFactory();
$blf->getByCompanyId($company_id);
$branch_list[0] = '--';
foreach ($blf as $branch) {
$branch_list[$branch->getID()] = $branch->getName();
}
return $branch_list;
}
$ulf = new UserListFactory();
if (isset($mapped_row['user_id']) and $mapped_row['user_id'] != '') {
$ulf->getById($mapped_row['user_id']);
} elseif (isset($mapped_row['employee_number']) and $mapped_row['employee_number'] != '' and isset($mapped_row['company_id']) and $mapped_row['company_id'] != '') {
$ulf->getByCompanyIDAndEmployeeNumber($mapped_row['company_id'], $mapped_row['employee_number']);
} elseif (isset($mapped_row['user_name']) and $mapped_row['user_name'] != '') {
$ulf->getByUserName($mapped_row['user_name']);
}
if ($ulf->getRecordCount() == 1) {
$u_obj = $ulf->getCurrent();
//Set user timezone before parsing.
$u_obj->getUserPreferenceObject()->setDateTimePreferences();
if (!isset($branch_options)) {
//Get all branches
$blf = new BranchListFactory();
$blf->getByCompanyId($u_obj->getCompany());
$branch_options = $blf->getArrayByListFactory($blf, FALSE, TRUE);
unset($blf);
}
if (!isset($department_options)) {
//Get departments
$dlf = new DepartmentListFactory();
$dlf->getByCompanyId($u_obj->getCompany());
$department_options = $dlf->getArrayByListFactory($dlf, FALSE, TRUE);
unset($dlf);
}
if (getTTProductEdition() == TT_PRODUCT_PROFESSIONAL and !isset($job_options)) {
//Get jobs
$jlf = new JobListFactory();
$jlf->getByCompanyId($u_obj->getCompany());
$job_options = $jlf->getArrayByListFactory($jlf, FALSE, TRUE);