OpenCATS 0.9.4-3

Free, Open-Source Applicant Tracking System including job-board. Entirely customisable!

General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules: Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
User avatar
By copiousquirk
#4549
I've figured this out if anyone is interested. you need to go to the lib folder>search.php file>find the below set of codes and add the below in green

/**
* Support function for Quick Search code. Searches all relevant fields for
* $wildCardString.
*
* @param string wildcard match string
* @return array candidates data
*/
public function candidates($wildCardString)
{
$wildCardString = str_replace('*', '%', $wildCardString) . '%';
$wildCardString = $this->_db->makeQueryString($wildCardString);

$sql = sprintf(
"SELECT
candidate.candidate_id AS candidateID,
candidate.first_name AS firstName,
candidate.last_name AS lastName,
candidate.phone_home AS phoneHome,
candidate.phone_cell AS phoneCell,
candidate.key_skills AS keySkills,
candidate.email1 AS email1,
owner_user.first_name AS ownerFirstName,
owner_user.last_name AS ownerLastName,
DATE_FORMAT(
candidate.date_created, '%%m-%%d-%%y'
) AS dateCreated,
DATE_FORMAT(
candidate.date_modified, '%%m-%%d-%%y'
) AS dateModified
FROM
candidate
LEFT JOIN user AS owner_user
ON candidate.owner = owner_user.user_id
WHERE
(
CONCAT(candidate.first_name, ' ', candidate.last_name) LIKE %s
OR CONCAT(candidate.last_name, ' ', candidate.first_name) LIKE %s
OR CONCAT(candidate.last_name, ', ', candidate.first_name) LIKE %s
OR candidate.email1 LIKE %s
OR candidate.email2 LIKE %s
OR REPLACE(
REPLACE(
REPLACE(
REPLACE(candidate.phone_home, '-', ''),
'.', ''),
')', ''),
'(', '') LIKE %s
OR REPLACE(
REPLACE(
REPLACE(
REPLACE(candidate.phone_cell, '-', ''),
'.', ''),
')', ''),
'(', '') LIKE %s
)
AND
candidate.site_id = %s
AND
candidate.is_admin_hidden = 0
ORDER BY
candidate.date_modified DESC,
candidate.first_name ASC,
candidate.last_name ASC",
$wildCardString,
$wildCardString,
$wildCardString,
$wildCardString,
$wildCardString,
$wildCardString,
$wildCardString,
$this->_siteID
);

return $this->_db->getAllAssoc($sql);
}
How to enable and use ACL

Not sure if still needed, I found this as I am wor[…]

现在玩 北美传奇 的人都讲究情怀什么的,也对啊,传奇从画面上来说现在可能并不出众,甚至已经远远落[…]

Automatic database Backup

Read all the trending news in India in Hindi. Know[…]

Bulk resume upload not working

Hi there I tried to install the openCATS in my loc[…]

Quick Search BOX

unique gifts for dad , best gifts for couples, gif[…]

PPS. .... we have changed all the login .. applica[…]

PS.... Also you will notice the below in the orig[…]