}
$wage_filter_data['permission_children_ids'] = $wage_permission_children_ids;
}
$ugdlf = TTnew('UserGenericDataListFactory');
$ugdf = TTnew('UserGenericDataFactory');
$action = Misc::findSubmitButton();
switch ($action) {
case 'export':
case 'display_report':
Debug::Text('Submit!', __FILE__, __LINE__, __METHOD__, 10);
//Debug::Arr($filter_data, 'Filter Data', __FILE__, __LINE__, __METHOD__,10);
if (Misc::isSystemLoadValid() == FALSE) {
echo TTi18n::getText('Please try again later...');
exit;
}
$bf = new BankAccountFactory();
//Get all employees that match the criteria:
$ulf = TTnew('UserListFactory');
$ulf->getSearchByCompanyIdAndArrayCriteria($current_company->getId(), $filter_data);
if ($ulf->getRecordCount() > 0) {
foreach ($ulf as $u_obj) {
$filter_data['user_ids'][] = $u_obj->getId();
}
$ulf->getReportByCompanyIdAndUserIDList($current_company->getId(), $filter_data['user_ids']);
//Get title list,
$utlf = TTnew('UserTitleListFactory');
$user_titles = $utlf->getByCompanyIdArray($current_company->getId());
$uglf = TTnew('UserGroupListFactory');
$group_options = $uglf->getArrayByNodes(FastTree::FormatArray($uglf->getByCompanyIdArray($current_company->getId()), 'no_tree_text', TRUE));
//Get default branch list
$blf = TTnew('BranchListFactory');
$bank['transit'] = substr($bank['account'], 4, 5);
$bank['account'] = substr($bank['account'], 7, 100);
} else {
echo " (US) ";
$bank['transit'] = substr($bank['account'], 0, 9);
$bank['account'] = substr($bank['account'], 8, 100);
}
}
echo 'Institution: ' . $bank['institution'] . ' Transit: ' . $bank['transit'] . ' Account: ' . $bank['account'];
$balf = new BankAccountListFactory();
$balf->getUserAccountByCompanyIdAndUserId($mapped_row['company_id'], $user_id);
if ($balf->getRecordCount() == 1) {
$baf = $balf->getCurrent();
echo "(U) ";
} else {
$baf = new BankAccountFactory();
}
$baf->setCompany($mapped_row['company_id']);
$baf->setUser($user_id);
if ($bank['institution'] != '') {
$baf->setInstitution($bank['institution']);
}
$baf->setTransit($bank['transit']);
$baf->setAccount($bank['account']);
if ($baf->isValid()) {
$baf->Save();
echo " \t\t\tSuccess!\n";
} else {
echo " \t\t\tFailed!\n";
$commit_trans = FALSE;
$e++;
function getReportByCompanyIdAndUserIDList($company_id, $user_ids, $order = NULL)
{
if ($company_id == '') {
return FALSE;
}
if ($user_ids == '') {
return FALSE;
}
/*
if ( $order == NULL ) {
$order = array( 'status_id' => 'asc', 'last_name' => 'asc' );
$strict = FALSE;
} else {
$strict = TRUE;
}
*/
// $utf = new UserTaxFactory();
// LEFT JOIN '. $utf->getTable() .' as b ON a.id = b.user_id AND (b.deleted=0 OR b.deleted IS NULL)
$baf = new BankAccountFactory();
$ph = array('company_id' => $company_id);
$query = '
select c.*,a.*
from ' . $this->getTable() . ' as a
LEFT JOIN ' . $baf->getTable() . ' as c ON a.id = c.user_id AND (c.deleted=0 OR c.deleted IS NULL)
where
a.company_id = ?
AND a.id in (' . $this->getListSQL($user_ids, $ph) . ')
AND ( a.deleted = 0 )
';
$query .= $this->getSortSQL($order, FALSE);
$this->ExecuteSQL($query, $ph);
return $this;
}
/*
* Get FORM variables
*/
extract(FormVariables::GetVariables(array('action', 'user_id', 'company_id', 'bank_data', 'data_saved')));
if (isset($company_id) and $company_id != '') {
if (!$permission->Check('company', 'enabled') or !$permission->Check('company', 'edit_own_bank')) {
$permission->Redirect(FALSE);
//Redirect
}
} else {
if (!$permission->Check('user', 'enabled') or !($permission->Check('user', 'edit_bank') or $permission->Check('user', 'edit_own_bank'))) {
$permission->Redirect(FALSE);
//Redirect
}
}
$baf = new BankAccountFactory();
$action = Misc::findSubmitButton();
switch ($action) {
case 'delete':
Debug::Text('Delete!', __FILE__, __LINE__, __METHOD__, 10);
Debug::Text('User ID: ' . $bank_data['user_id'] . ' Company ID: ' . $bank_data['company_id'], __FILE__, __LINE__, __METHOD__, 10);
$balf = new BankAccountListFactory();
if (isset($user_id) and $user_id != '') {
$balf->GetUserAccountByCompanyIdAndUserId($current_company->getId(), $user_id);
} elseif (isset($company_id) and $company_id != '') {
$balf->GetCompanyAccountByCompanyId($current_company->getId());
}
Debug::Text('Found Records: ' . $balf->getRecordCount(), __FILE__, __LINE__, __METHOD__, 10);
if ($balf->getRecordCount() > 0) {
$b_obj = $balf->getCurrent();
$b_obj->setDeleted(TRUE);
