} $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);