本文整理汇总了PHP中CATSUtility类的典型用法代码示例。如果您正苦于以下问题：PHP CATSUtility类的具体用法？PHP CATSUtility怎么用？PHP CATSUtility使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
在下文中一共展示了CATSUtility类的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: getForm
/**
* Generates HTML code for export forms / menus.
*
* @param flag data item type being exported
* @param string comma-separated list of data item IDs
* @param integer number of pixles right the export box should be displayed
* @return array containing parts of html code for the export form.
*/
public static function getForm($dataItemType, $IDs, $popUpOffset = 35, $linkOffset = 5)
{
$indexName = CATSUtility::getIndexName();
/* Build form header. */
$header = '<form name="selectedObjects" action="' . $indexName . '" method="get">' . "\n" . '<input type="hidden" name="m" value="export" />' . "\n" . '<input type="hidden" name="onlySelected" value="true" />' . "\n" . '<input type="hidden" name="dataItemType" value="' . $dataItemType . '" />' . "\n";
/* Build form menu. */
$allRecordsURL = sprintf('%s?m=export&a=export&dataItemType=%s', $indexName, $dataItemType);
if ($_REQUEST["m"] == "candidates") {
$objSearchDS = new SearchDataStructure($_REQUEST["m"]);
$objSearchDS->loadFromURL();
$_SESSION["AUIEO"]["CANDIDATS"]["SearchDS"] = $objSearchDS;
$allRecordsJoborderURL = sprintf('%s?m=candidates&a=considerForJobSearch&candidateID=SearchDS', $indexName);
}
$currentPageURL = sprintf('%s?m=export&a=export&dataItemType=%s&ids=%s', $indexName, $dataItemType, $IDs);
if ($_REQUEST["m"] == "candidates") {
$arrID = explode(",", $IDs);
foreach ($arrID as $ind => $id) {
$arrID[$ind] = "candidateID[]=" . trim($id);
}
$candidateIDs = implode("&", $arrID);
$currentPageJoborderURL = sprintf('%s?m=candidates&a=considerForJobSearch&%s', $indexName, $candidateIDs);
}
$menu = '<div style="float: left; margin-left: 4px; margin-right: ' . $linkOffset . 'px;">' . '<form name="selectAll" action="#">' . '<input type="checkbox" name="allBox" title="Select All" onclick="toggleChecksAll();" />' . '</form>' . '</div>' . '<a href="#" id="exportBoxLink" onclick="showBox(\'ExportBox\'); return false;">Export</a> | <a href="#" id="deleteBoxLink" onclick="deleteSelected(); return false;">Delete</a>';
if ($_REQUEST["m"] == "candidates") {
$menu = $menu . ' | <a href="#" id="addToJoborderBoxLink" onclick="showBox(\'JoborderBox\'); return false;">Add to joborder</a>';
}
$menu = $menu . '<br />' . '<div class="exportPopup" id="ExportBox" align="left" onmouseover="showBox(\'ExportBox\');" onmouseout="hideBox(\'ExportBox\');">' . '<a href="' . $allRecordsURL . '">Export All Records</a><br />' . '<a href="' . $currentPageURL . '">Export Current Page</a><br />' . '<a href="#" onclick="checkSelected(); return false;">Export Selected Records</a>' . '</div>';
if ($_REQUEST["m"] == "candidates") {
$menu = $menu . '
<div class="exportPopup" id="JoborderBox" align="left" onmouseover="showBox(\'JoborderBox\');" onmouseout="hideBox(\'JoborderBox\');">' . '<a href="javascript:void(0);" onclick="showPopWin(\'' . $allRecordsJoborderURL . '\', 750, 390, null); return false;">All Records</a><br />' . '<a href="javascript:void(0);" onclick="showPopWin(\'' . $allRecordsJoborderURL . '\', 750, 390, null); return false;">Current Page</a><br />' . '<a href="#" onclick="checkSelected(); return false;">Selected Records</a>' . '</div>';
}
$footer = '</form>';
return array('header' => $header, 'footer' => $footer, 'menu' => $menu);
}示例2: __construct
public function __construct($siteID, $parameters)
{
/* Pager configuration. */
$this->_tableWidth = 915;
$this->_defaultAlphabeticalSortBy = 'lastName';
$this->ajaxMode = false;
$this->showExportCheckboxes = true;
//BOXES WILL NOT APPEAR UNLESS SQL ROW exportID IS RETURNED!
$this->showActionArea = true;
$this->showChooseColumnsBox = true;
$this->allowResizing = true;
$this->dateCriterion = '';
if (isset($parameters['period']) && !empty($parameters['period'])) {
$this->dateCriterion .= ' AND activity.date_created >= ' . $parameters['period'] . ' ';
} else {
if (isset($parameters['startDate']) && !empty($parameters['startDate'])) {
$this->dateCriterion .= ' AND activity.date_created >= \'' . $parameters['startDate'] . '\' ';
}
if (isset($parameters['endDate']) && !empty($parameters['endDate'])) {
$this->dateCriterion .= ' AND activity.date_created <= \'' . $parameters['endDate'] . '\' ';
}
}
$this->defaultSortBy = 'dateCreatedSort';
$this->defaultSortDirection = 'DESC';
$this->_defaultColumns = array(array('name' => 'Date', 'width' => 110), array('name' => 'First Name', 'width' => 85), array('name' => 'Last Name', 'width' => 75), array('name' => 'Regarding', 'width' => 125), array('name' => 'Activity', 'width' => 65), array('name' => 'Notes', 'width' => 240), array('name' => 'Entered By', 'width' => 60));
$this->_db = DatabaseConnection::getInstance();
$this->_siteID = $siteID;
$this->_assignedCriterion = "";
$this->_dataItemIDColumn = 'company.company_id';
$this->_classColumns = array('Date' => array('pagerRender' => 'return $rsData[\'dateCreated\'];', 'sortableColumn' => 'dateCreatedSort', 'pagerWidth' => 110, 'pagerOptional' => true, 'alphaNavigation' => true, 'filterHaving' => 'dateCreated'), 'First Name' => array('pagerRender' => 'if ($rsData[\'dataItemType\']==' . DATA_ITEM_CANDIDATE . ') {$ret = \'<img src="images/mru/candidate.gif" height="12" alt="" />\';} else if ($rsData[\'dataItemType\']==' . DATA_ITEM_CONTACT . ') {$ret = \'<img src="images/mru/contact.gif" height="12">\';} else {$ret = \'<img src="images/mru/blank.gif">\';} if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; if ($rsData[\'dataItemType\']==' . DATA_ITEM_CANDIDATE . ') {return $ret.\' <a href="' . CATSUtility::getIndexName() . '?m=candidates&a=show&candidateID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'">\'.htmlspecialchars($rsData[\'firstName\']).\'</a>\';} else {return $ret.\' <a href="' . CATSUtility::getIndexName() . '?m=contacts&a=show&contactID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'">\'.htmlspecialchars($rsData[\'firstName\']).\'</a>\';}', 'sortableColumn' => 'firstName', 'pagerWidth' => 85, 'pagerOptional' => false, 'alphaNavigation' => true, 'filterHaving' => 'firstName'), 'Last Name' => array('pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; if ($rsData[\'dataItemType\']==' . DATA_ITEM_CANDIDATE . ') {return \'<a href="' . CATSUtility::getIndexName() . '?m=candidates&a=show&candidateID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'"> \'.htmlspecialchars($rsData[\'lastName\']).\'</a>\';} else {return \'<a href="' . CATSUtility::getIndexName() . '?m=contacts&a=show&contactID=\'.$rsData[\'dataItemID\'].\'" class="\'.$className.\'" title="\'.htmlspecialchars(InfoString::make($rsData[\'dataItemType\'],$rsData[\'dataItemID\'],$rsData[\'siteID\'])).\'"> \'.htmlspecialchars($rsData[\'lastName\']).\'</a>\';}', 'sortableColumn' => 'lastName', 'pagerWidth' => 75, 'pagerOptional' => false, 'alphaNavigation' => true, 'filterHaving' => 'lastName'), 'Regarding' => array('pagerRender' => 'if ($rsData[\'jobIsHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; if ($rsData[\'companyIsHot\'] == 1) $companyClassName = \'jobLinkHot\'; else $companyClassName = \'jobLinkCold\'; if ($rsData[\'regardingJobTitle\'] == \'\') {$ret = \'General\'; } else {$ret = \'<a href="' . CATSUtility::getIndexName() . '?m=joborders&a=show&jobOrderID=\'.$rsData[\'jobOrderID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'regardingJobTitle\']).\'</a>\'; if($rsData[\'regardingCompanyName\'] != \'\') {$ret .= \' <a href="' . CATSUtility::getIndexName() . '?m=companies&a=show&companyID=\'.$rsData[\'companyID\'].\'" class="\'.$companyClassName.\'">(\'.htmlspecialchars($rsData[\'regardingCompanyName\']).\')\';}} return $ret;', 'sortableColumn' => 'regarding', 'pagerWidth' => 125, 'pagerOptional' => true, 'alphaNavigation' => true, 'filterHaving' => 'regarding'), 'Activity' => array('pagerRender' => '$ret = $rsData[\'typeDescription\']; return $ret;', 'sortableColumn' => 'typeDescription', 'pagerWidth' => 65, 'pagerOptional' => true, 'alphaNavigation' => true, 'filter' => 'activity_type.short_description'), 'Notes' => array('pagerRender' => 'return $rsData[\'notes\'];', 'sortableColumn' => 'notes', 'pagerWidth' => 240, 'pagerOptional' => true, 'alphaNavigation' => true, 'filterHaving' => 'notes'), 'Entered By' => array('pagerRender' => 'return StringUtility::makeInitialName($rsData[\'enteredByFirstName\'], $rsData[\'enteredByLastName\'], false, LAST_NAME_MAXLEN);', 'exportRender' => 'return $rsData[\'enteredByFirstName\'] . " " .$rsData[\'enteredByLastName\'];', 'sortableColumn' => 'enteredBySort', 'pagerWidth' => 60, 'alphaNavigation' => true, 'filter' => 'CONCAT(entered_by_user.last_name, entered_by_user.first_name)'));
parent::__construct("activity:ActivityDataGrid", $parameters);
}示例3: getInnerActionArea
/**
* Adds more options to the action area on the pager. Overloads
* DataGrid Inner Action Area function.
*
* @return html innerActionArea commands.
*/
public function getInnerActionArea()
{
$html = parent::getInnerActionArea();
$newParameterArray = $this->_parameters;
$newParameterArray['exportIDs'] = '<dynamic>';
$html .= sprintf('<a href="javascript:void(0);" onclick="window.location.href=\'%s?m=export&a=exportByDataGrid&i=%s&p=%s&&dynamicArgument%s=\' + urlEncode(serializeArray(exportArray%s));">Export Selected</a><br />', CATSUtility::getIndexName(), urlencode($this->_instanceName), urlencode(serialize($newParameterArray)), urlencode($this->_instanceName), md5($this->_instanceName));
//$html .= sprintf(
// '<a href="">Delete Selected</a><br />'
// );
return $html;
}示例4: getForm
/**
* Generates HTML code for export forms / menus.
*
* @param flag data item type being exported
* @param string comma-separated list of data item IDs
* @param integer number of pixles right the export box should be displayed
* @return array containing parts of html code for the export form.
*/
public static function getForm($dataItemType, $IDs, $popUpOffset = 35, $linkOffset = 5)
{
$indexName = CATSUtility::getIndexName();
/* Build form header. */
$header = '<form name="selectedObjects" action="' . $indexName . '" method="get">' . "\n" . '<input type="hidden" name="m" value="export" />' . "\n" . '<input type="hidden" name="onlySelected" value="true" />' . "\n" . '<input type="hidden" name="dataItemType" value="' . $dataItemType . '" />' . "\n";
/* Build form menu. */
$allRecordsURL = sprintf('%s?m=export&a=export&dataItemType=%s', $indexName, $dataItemType);
$currentPageURL = sprintf('%s?m=export&a=export&dataItemType=%s&ids=%s', $indexName, $dataItemType, $IDs);
$menu = '<div style="float: left; margin-left: 4px; margin-right: ' . $linkOffset . 'px;">' . '<form name="selectAll" action="#">' . '<input type="checkbox" name="allBox" title="Select All" onclick="toggleChecksAll();" />' . '</form>' . '</div>' . '<a href="#" id="exportBoxLink" onclick="showBox(\'ExportBox\'); return false;">Export</a><br />' . '<div class="exportPopup" id="ExportBox" align="left" onmouseover="showBox(\'ExportBox\');" onmouseout="hideBox(\'ExportBox\');">' . '<a href="' . $allRecordsURL . '">Export All Records</a><br />' . '<a href="' . $currentPageURL . '">Export Current Page</a><br />' . '<a href="#" onclick="checkSelected(); return false;">Export Selected Records</a>' . '</div>';
$footer = '</form>';
return array('header' => $header, 'footer' => $footer, 'menu' => $menu);
}示例5: getInnerActionArea
/**
* Adds more options to the action area on the pager. Overloads
* DataGrid Inner Action Area function.
*
* @return html innerActionArea commands.
*/
public function getInnerActionArea()
{
//TODO: Add items:
// - Add to List
// - Add to Pipeline
// - Mass set rank (depends on each candidate having their own personal rank - are we going to do this?)
$html = '';
$html .= $this->getInnerActionAreaItem('Remove From This List', CATSUtility::getIndexName() . '?m=lists&a=removeFromListDatagrid&dataItemType=' . DATA_ITEM_CANDIDATE . '&savedListID=' . $this->getMiscArgument(), false);
$html .= $this->getInnerActionAreaItemPopup('Add To Pipeline', CATSUtility::getIndexName() . '?m=candidates&a=considerForJobSearch', 750, 460);
if (MAIL_MAILER != 0) {
$html .= $this->getInnerActionAreaItem('Send E-Mail', CATSUtility::getIndexName() . '?m=candidates&a=emailCandidates');
}
$html .= $this->getInnerActionAreaItem('Export', CATSUtility::getIndexName() . '?m=export&a=exportByDataGrid');
$html .= parent::getInnerActionArea();
return $html;
}示例6: displayPublicJobOrders
private function displayPublicJobOrders()
{
$site = new Site(-1);
$careerPortalSiteID = $site->getFirstSiteID();
if (!eval(Hooks::get('RSS_SITEID'))) {
return;
}
$jobOrders = new JobOrders($careerPortalSiteID);
$rs = $jobOrders->getAll(JOBORDERS_STATUS_ACTIVE, -1, -1, -1, false, true);
/* XML Headers */
header('Content-type: text/xml');
$indexName = CATSUtility::getIndexName();
$stream = sprintf("<?xml version=\"1.0\" encoding=\"utf-8\"?>\n" . "<rss version=\"2.0\">\n" . "<channel>\n" . "<title>New Job Orders</title>\n" . "<description>CATS RSS Feed</description>\n" . "<link>%s</link>\n" . "<pubDate>%s</pubDate>\n", CATSUtility::getAbsoluteURI(), DateUtility::getRSSDate());
foreach ($rs as $rowIndex => $row) {
$uri = sprintf("%scareers/?p=showJob&ID=%d", CATSUtility::getAbsoluteURI(), $row['jobOrderID']);
// Fix URL if viewing from /rss without using globals or dirup '../'
if (strpos($_SERVER['PHP_SELF'], '/rss/') !== false) {
$uri = str_replace('/rss/', '/', $uri);
}
$stream .= sprintf("<item>\n" . "<title>%s (%s)</title>\n" . "<description>Located in %s.</description>\n" . "<link>%s</link>\n" . "</item>\n", $row['title'], $jobOrders->typeCodeToString($row['type']), StringUtility::makeCityStateString($row['city'], $row['state']), $uri);
}
$stream .= "</channel>\n</rss>\n";
echo $stream;
}示例7: __construct
public function __construct()
{
$this->_indexName = CATSUtility::getIndexName();
$this->_indexURL = CATSUtility::getAbsoluteURI($this->_indexName);
parent::__construct();
}示例8: __construct
public function __construct($instanceName, $siteID, $parameters, $misc = 0)
{
$this->_db = DatabaseConnection::getInstance();
$this->_siteID = $siteID;
$this->_assignedCriterion = "";
$this->_dataItemIDColumn = 'candidate.candidate_id';
$this->_classColumns = array('Attachments' => array('select' => 'IF(candidate_joborder_submitted.candidate_joborder_id, 1, 0) AS submitted,
IF(attachment_id, 1, 0) AS attachmentPresent', 'pagerRender' => 'if ($rsData[\'submitted\'] == 1)
{
$return = \'<img src="images/job_orders.gif" alt="" width="16" height="16" title="Submitted for a Job Order" />\';
}
else
{
$return = \'<img src="images/mru/blank.gif" alt="" width="16" height="16" />\';
}
if ($rsData[\'attachmentPresent\'] == 1)
{
$return .= \'<img src="images/paperclip.gif" alt="" width="16" height="16" title="Attachment Present" />\';
}
else
{
$return .= \'<img src="images/mru/blank.gif" alt="" width="16" height="16" />\';
}
return $return;
', 'join' => 'LEFT JOIN attachment
ON candidate.candidate_id = attachment.data_item_id
AND attachment.data_item_type = ' . DATA_ITEM_CANDIDATE . '
LEFT JOIN candidate_joborder AS candidate_joborder_submitted
ON candidate_joborder_submitted.candidate_id = candidate.candidate_id
AND candidate_joborder_submitted.status >= ' . PIPELINE_STATUS_SUBMITTED . '
AND candidate_joborder_submitted.site_id = ' . $this->_siteID . '
AND candidate_joborder_submitted.status != ' . PIPELINE_STATUS_NOTINCONSIDERATION, 'pagerWidth' => 34, 'pagerOptional' => true, 'pagerNoTitle' => true, 'sizable' => false, 'exportable' => false, 'filterable' => false), 'First Name' => array('select' => 'candidate.first_name AS firstName', 'pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; return \'<a href="' . CATSUtility::getIndexName() . '?m=candidates&a=show&candidateID=\'.$rsData[\'candidateID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'firstName\']).\'</a>\';', 'sortableColumn' => 'firstName', 'pagerWidth' => 75, 'pagerOptional' => false, 'alphaNavigation' => true, 'filter' => 'candidate.first_name'), 'Last Name' => array('select' => 'candidate.last_name AS lastName', 'sortableColumn' => 'lastName', 'pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; return \'<a href="' . CATSUtility::getIndexName() . '?m=candidates&a=show&candidateID=\'.$rsData[\'candidateID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'lastName\']).\'</a>\';', 'pagerWidth' => 85, 'pagerOptional' => false, 'alphaNavigation' => true, 'filter' => 'candidate.last_name'), 'E-Mail' => array('select' => 'candidate.email1 AS email1', 'sortableColumn' => 'email1', 'pagerWidth' => 80, 'filter' => 'candidate.email1'), '2nd E-Mail' => array('select' => 'candidate.email2 AS email2', 'sortableColumn' => 'email2', 'pagerWidth' => 80, 'filter' => 'candidate.email2'), 'Home Phone' => array('select' => 'candidate.phone_home AS phoneHome', 'sortableColumn' => 'phoneHome', 'pagerWidth' => 80, 'filter' => 'candidate.phone_home'), 'Cell Phone' => array('select' => 'candidate.phone_cell AS phoneCell', 'sortableColumn' => 'phoneCell', 'pagerWidth' => 80, 'filter' => 'candidate.phone_cell'), 'Work Phone' => array('select' => 'candidate.phone_work AS phoneWork', 'sortableColumn' => 'phoneWork', 'pagerWidth' => 80), 'Address' => array('select' => 'candidate.address AS address', 'sortableColumn' => 'address', 'pagerWidth' => 250, 'alphaNavigation' => true, 'filter' => 'candidate.address'), 'City' => array('select' => 'candidate.city AS city', 'sortableColumn' => 'city', 'pagerWidth' => 80, 'alphaNavigation' => true, 'filter' => 'candidate.city'), 'State' => array('select' => 'candidate.state AS state', 'sortableColumn' => 'state', 'filterType' => 'dropDown', 'pagerWidth' => 50, 'alphaNavigation' => true, 'filter' => 'candidate.state'), 'Zip' => array('select' => 'candidate.zip AS zip', 'sortableColumn' => 'zip', 'pagerWidth' => 50, 'filter' => 'candidate.zip'), 'Misc Notes' => array('select' => 'candidate.notes AS notes', 'sortableColumn' => 'notes', 'pagerWidth' => 300, 'filter' => 'candidate.notes'), 'Web Site' => array('select' => 'candidate.web_site AS webSite', 'pagerRender' => 'return \'<a href="\'.htmlspecialchars($rsData[\'webSite\']).\'">\'.htmlspecialchars($rsData[\'webSite\']).\'</a>\';', 'sortableColumn' => 'webSite', 'pagerWidth' => 80, 'filter' => 'candidate.web_site'), 'Key Skills' => array('select' => 'candidate.key_skills AS keySkills', 'pagerRender' => 'return substr(trim($rsData[\'keySkills\']), 0, 30) . (strlen(trim($rsData[\'keySkills\'])) > 30 ? \'...\' : \'\');', 'sortableColumn' => 'keySkills', 'pagerWidth' => 210, 'filter' => 'candidate.key_skills'), 'Recent Status' => array('select' => '(
SELECT
CONCAT(
\'<a href="' . CATSUtility::getIndexName() . '?m=joborders&a=show&jobOrderID=\',
joborder.joborder_id,
\'" title="\',
joborder.title,
\' (\',
company.name,
\')">\',
candidate_joborder_status.short_description,
\'</a>\'
)
FROM
candidate_joborder
LEFT JOIN candidate_joborder_status
ON candidate_joborder_status.candidate_joborder_status_id = candidate_joborder.status
LEFT JOIN joborder
ON joborder.joborder_id = candidate_joborder.joborder_id
LEFT JOIN company
ON joborder.company_id = company.company_id
WHERE
candidate_joborder.candidate_id = candidate.candidate_id
ORDER BY
candidate_joborder.date_modified DESC
LIMIT 1
) AS lastStatus
', 'sort' => 'lastStatus', 'pagerRender' => 'return $rsData[\'lastStatus\'];', 'exportRender' => 'return $rsData[\'lastStatus\'];', 'pagerWidth' => 140, 'exportable' => false, 'filterHaving' => 'lastStatus', 'filterTypes' => '=~'), 'Recent Status (Extended)' => array('select' => '(
SELECT
CONCAT(
candidate_joborder_status.short_description,
\'<br />\',
\'<a href="' . CATSUtility::getIndexName() . '?m=companies&a=show&companyID=\',
company.company_id,
\'">\',
company.name,
\'</a> - \',
\'<a href="' . CATSUtility::getIndexName() . '?m=joborders&a=show&jobOrderID=\',
joborder.joborder_id,
\'">\',
joborder.title,
\'</a>\'
)
FROM
candidate_joborder
LEFT JOIN candidate_joborder_status
ON candidate_joborder_status.candidate_joborder_status_id = candidate_joborder.status
LEFT JOIN joborder
ON joborder.joborder_id = candidate_joborder.joborder_id
LEFT JOIN company
ON joborder.company_id = company.company_id
WHERE
candidate_joborder.candidate_id = candidate.candidate_id
ORDER BY
candidate_joborder.date_modified DESC
LIMIT 1
) AS lastStatusLong
', 'sortableColumn' => 'lastStatusLong', 'pagerRender' => 'return $rsData[\'lastStatusLong\'];', 'pagerWidth' => 310, 'exportable' => false, 'filterable' => false), 'Source' => array('select' => 'candidate.source AS source', 'sortableColumn' => 'source', 'pagerWidth' => 140, 'alphaNavigation' => true, 'filter' => 'candidate.source'), 'Available' => array('select' => 'DATE_FORMAT(candidate.date_available, \'%m-%d-%y\') AS dateAvailable', 'sortableColumn' => 'dateAvailable', 'pagerWidth' => 60), 'Current Employer' => array('select' => 'candidate.current_employer AS currentEmployer', 'sortableColumn' => 'currentEmployer', 'pagerWidth' => 125, 'alphaNavigation' => true, 'filter' => 'candidate.current_employer'), 'Current Pay' => array('select' => 'candidate.current_pay AS currentPay', 'sortableColumn' => 'currentPay', 'pagerWidth' => 125, 'filter' => 'candidate.current_pay', 'filterTypes' => '===>=<'), 'Desired Pay' => array('select' => 'candidate.desired_pay AS desiredPay', 'sortableColumn' => 'desiredPay', 'pagerWidth' => 125, 'filter' => 'candidate.desired_pay', 'filterTypes' => '===>=<'), 'Can Relocate' => array('select' => 'candidate.can_relocate AS canRelocate', 'pagerRender' => 'return ($rsData[\'canRelocate\'] == 0 ? \'No\' : \'Yes\');', 'exportRender' => 'return ($rsData[\'canRelocate\'] == 0 ? \'No\' : \'Yes\');', 'sortableColumn' => 'canRelocate', 'pagerWidth' => 80, 'filter' => 'candidate.can_relocate'), 'Owner' => array('select' => 'owner_user.first_name AS ownerFirstName,' . 'owner_user.last_name AS ownerLastName,' . 'CONCAT(owner_user.last_name, owner_user.first_name) AS ownerSort', 'join' => 'LEFT JOIN user AS owner_user ON candidate.owner = owner_user.user_id', 'pagerRender' => 'return StringUtility::makeInitialName($rsData[\'ownerFirstName\'], $rsData[\'ownerLastName\'], false, LAST_NAME_MAXLEN);', 'exportRender' => 'return $rsData[\'ownerFirstName\'] . " " .$rsData[\'ownerLastName\'];', 'sortableColumn' => 'ownerSort', 'pagerWidth' => 75, 'alphaNavigation' => true, 'filter' => 'CONCAT(owner_user.first_name, owner_user.last_name)'), 'Created' => array('select' => 'DATE_FORMAT(candidate.date_created, \'%m-%d-%y\') AS dateCreated', 'pagerRender' => 'return $rsData[\'dateCreated\'];', 'sortableColumn' => 'dateCreatedSort', 'pagerWidth' => 60, 'filterHaving' => 'DATE_FORMAT(candidate.date_created, \'%m-%d-%y\')'), 'Modified' => array('select' => 'DATE_FORMAT(candidate.date_modified, \'%m-%d-%y\') AS dateModified', 'pagerRender' => 'return $rsData[\'dateModified\'];', 'sortableColumn' => 'dateModifiedSort', 'pagerWidth' => 60, 'pagerOptional' => false, 'filterHaving' => 'DATE_FORMAT(candidate.date_modified, \'%m-%d-%y\')'), 'Added To List' => array('select' => 'DATE_FORMAT(saved_list_entry.date_created, \'%m-%d-%y\') AS dateAddedToList,
saved_list_entry.date_created AS dateAddedToListSort', 'pagerRender' => 'return $rsData[\'dateAddedToList\'];', 'sortableColumn' => 'dateAddedToListSort', 'pagerWidth' => 60, 'pagerOptional' => false, 'filterable' => false, 'exportable' => false), 'OwnerID' => array('select' => '', 'filter' => 'candidate.owner', 'pagerOptional' => false, 'filterable' => false, 'filterDescription' => 'Only My Candidates'), 'IsHot' => array('select' => '', 'filter' => 'candidate.is_hot', 'pagerOptional' => false, 'filterable' => false, 'filterDescription' => 'Only Hot Candidates'));
if (US_ZIPS_ENABLED) {
$this->_classColumns['Near Zipcode'] = array('select' => 'candidate.zip AS zip', 'filter' => 'candidate.zip', 'pagerOptional' => false, 'filterTypes' => '=@');
}
/* Extra fields get added as columns here. */
$candidates = new Candidates($this->_siteID);
$extraFieldsRS = $candidates->extraFields->getSettings();
foreach ($extraFieldsRS as $index => $data) {
$fieldName = $data['fieldName'];
//.........这里部分代码省略.........
示例9: echo
<td>
<select id="addFieldSelect<?php echo($index); ?>">
<?php foreach($this->extraFieldTypes as $extraFieldTypeIndex => $extraFieldTypeData): ?>
<option value="<?php echo($extraFieldTypeIndex); ?>"><?php $this->_($extraFieldTypeData['name']); ?></option>
<?php endforeach; ?>
</select>
</td>
</tr>
</table>
<input type="button" class="button" value="Add Field" onclick="onAddField<?php echo($index); ?>();" />
<input type="button" class="button" value="Cancel" onclick="onHideAddArea<?php echo($index); ?>();" />
</div>
<div id="addFieldOption<?php echo($index); ?>">
<a href="javascript:void(0);" onclick="document.getElementById('addField<?php echo($index); ?>').style.display=''; document.getElementById('addFieldOption<?php echo($index); ?>').style.display='none'; document.getElementById('addFieldName<?php echo($index); ?>').value=''; document.getElementById('addFieldName<?php echo($index); ?>').focus();">
<img src="images/actions/add_small.gif" border="0" /> Add field to <?php echo($data['name']); ?>
</a>
</div>
<br />
<br />
</td>
</tr>
<?php endforeach; ?>
</table>
<input type="submit" class="button" value="Save" style="display:none;" id="buttonSave" />
<input type="button" name="back" class = "button" value="Done" id="buttonDone" onclick="document.location.href='<?php echo(CATSUtility::getIndexName()); ?>?m=settings&a=administration';" />
</form>
<?php
$AUIEO_CONTENT=ob_get_clean();
?>
示例10: __construct
public function __construct($instanceName, $siteID, $parameters, $misc = 0)
{
$this->_db = DatabaseConnection::getInstance();
$this->_siteID = $siteID;
$this->_assignedCriterion = "";
$this->_dataItemIDColumn = 'contact.contact_id';
$this->_classColumns = array('First Name' => array('select' => 'contact.first_name AS firstName', 'pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; return \'<a href="' . CATSUtility::getIndexName() . '?m=contacts&a=show&contactID=\'.$rsData[\'contactID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'firstName\']).\'</a>\';', 'sortableColumn' => 'firstName', 'pagerWidth' => 75, 'pagerOptional' => false, 'alphaNavigation' => true, 'filter' => 'contact.first_name'), 'Last Name' => array('select' => 'contact.last_name AS lastName', 'sortableColumn' => 'lastName', 'pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; return \'<a href="' . CATSUtility::getIndexName() . '?m=contacts&a=show&contactID=\'.$rsData[\'contactID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'lastName\']).\'</a>\';', 'pagerWidth' => 85, 'pagerOptional' => false, 'alphaNavigation' => true, 'filter' => 'contact.last_name'), 'Company' => array('select' => 'company.name AS name,' . 'company.company_id as companyID', 'pagerRender' => 'if ($rsData[\'isHot\'] == 1) $className = \'jobLinkHot\'; else $className = \'jobLinkCold\'; return \'<a href="' . CATSUtility::getIndexName() . '?m=companies&a=show&companyID=\'.$rsData[\'companyID\'].\'" class="\'.$className.\'">\'.htmlspecialchars($rsData[\'name\']).\'</a>\';', 'sortableColumn' => 'name', 'pagerWidth' => 60, 'pagerOptional' => true, 'alphaNavigation' => true, 'filter' => 'company.name'), 'Title' => array('select' => 'contact.title AS title', 'sortableColumn' => 'title', 'pagerWidth' => 140, 'alphaNavigation' => true, 'pagerOptional' => true, 'filter' => 'contact.title'), 'Department' => array('select' => 'company_department.company_department_id AS companyDepartmentID, company_department.name as department', 'join' => 'LEFT JOIN company_department on company_department.company_department_id = contact.company_department_id', 'sortableColumn' => 'department', 'pagerWidth' => 120, 'alphaNavigation' => true, 'pagerOptional' => true, 'filter' => 'company_department.department'), 'Work Phone' => array('select' => 'contact.phone_work AS workPhone', 'sortableColumn' => 'workPhone', 'pagerWidth' => 140, 'alphaNavigation' => false, 'pagerOptional' => true, 'filter' => 'contact.work_phone'), 'Cell Phone' => array('select' => 'contact.phone_cell AS cellPhone', 'sortableColumn' => 'cellPhone', 'pagerWidth' => 140, 'alphaNavigation' => false, 'pagerOptional' => true, 'filter' => 'contact.phone_cell'), 'Other Phone' => array('select' => 'contact.phone_other AS otherPhone', 'sortableColumn' => 'otherPhone', 'pagerWidth' => 140, 'alphaNavigation' => false, 'pagerOptional' => true, 'filter' => 'contact.phone_other'), 'E-Mail' => array('select' => 'contact.email1 AS email1', 'sortableColumn' => 'email1', 'pagerWidth' => 80, 'filter' => 'contact.email1'), '2nd E-Mail' => array('select' => 'contact.email2 AS email2', 'sortableColumn' => 'email2', 'pagerWidth' => 80, 'filter' => 'contact.email2'), 'Address' => array('select' => 'contact.address AS address', 'sortableColumn' => 'address', 'pagerWidth' => 250, 'alphaNavigation' => true, 'filter' => 'contact.address'), 'City' => array('select' => 'contact.city AS city', 'sortableColumn' => 'city', 'pagerWidth' => 80, 'alphaNavigation' => true, 'filter' => 'contact.city'), 'State' => array('select' => 'contact.state AS state', 'sortableColumn' => 'state', 'filterType' => 'dropDown', 'pagerWidth' => 50, 'alphaNavigation' => true, 'filter' => 'contact.state'), 'Zip' => array('select' => 'contact.zip AS zip', 'sortableColumn' => 'zip', 'pagerWidth' => 50, 'filter' => 'contact.zip'), 'Misc Notes' => array('select' => 'contact.notes AS notes', 'sortableColumn' => 'notes', 'pagerWidth' => 300, 'filter' => 'contact.notes'), 'Created' => array('select' => 'DATE_FORMAT(contact.date_created, \'%m-%d-%y\') AS dateCreated', 'pagerRender' => 'return $rsData[\'dateCreated\'];', 'sortableColumn' => 'dateCreatedSort', 'pagerWidth' => 60, 'filterHaving' => 'DATE_FORMAT(contact.date_created, \'%m-%d-%y\')'), 'Modified' => array('select' => 'DATE_FORMAT(contact.date_modified, \'%m-%d-%y\') AS dateModified', 'pagerRender' => 'return $rsData[\'dateModified\'];', 'sortableColumn' => 'dateModifiedSort', 'pagerWidth' => 60, 'pagerOptional' => false, 'filterHaving' => 'DATE_FORMAT(contact.date_modified, \'%m-%d-%y\')'), 'OwnerID' => array('select' => '', 'filter' => 'contact.owner', 'pagerOptional' => false, 'filterable' => false, 'filterDescription' => 'Only My Contacts'), 'IsHot' => array('select' => '', 'filter' => 'contact.is_hot', 'pagerOptional' => false, 'filterable' => false, 'filterDescription' => 'Only Hot Contacts'));
if (US_ZIPS_ENABLED) {
$this->_classColumns['Near Zipcode'] = array('select' => 'contact.zip AS zip', 'filter' => 'contact.zip', 'pagerOptional' => false, 'filterTypes' => '=@');
}
/* Extra fields get added as columns here. */
$contacts = new Contacts($this->_siteID);
$extraFieldsRS = $contacts->extraFields->getSettings();
foreach ($extraFieldsRS as $index => $data) {
$fieldName = $data['fieldName'];
if (!isset($this->_classColumns[$fieldName])) {
$columnDefinition = $contacts->extraFields->getDataGridDefinition($index, $data, $this->_db);
/* Return false for extra fields that should not be columns. */
if ($columnDefinition !== false) {
$this->_classColumns[$fieldName] = $columnDefinition;
}
}
}
parent::__construct($instanceName, $parameters, $misc);
}示例11: echo
<div id="contents">
<table width="100%">
<tr>
<td width="3%">
<img src="images/settings.gif" width="24" height="24" border="0" alt="Settings" style="margin-top: 3px;" />
</td>
<td align="left"><h2>Settings: Customization</h2></td>
</tr>
</table>
<p class="note">Calendar Customization</p>
<table>
<tr>
<td>
<form name="editCalendarForm" id="editCalendarForm" action="<?php echo(CATSUtility::getIndexName()); ?>?m=settings&a=customizeCalendar" method="post">
<input type="hidden" name="postback" value="postback" />
<table class="editTable" width="700">
<tr>
<td class="tdVertical" style="width:250px;">
Disable AJAX dynamic event loading:
</td>
<td class="tdData">
<input type="checkbox" name="noAjax"<?php if ($this->calendarSettingsRS['noAjax'] == '1'): ?> checked<?php endif; ?>>
</td>
</tr>
<tr>
<td class="tdVertical" style="width:250px;">
By default, all events are public:
</td>
<td class="tdData">示例12: ob_start
<?php
//trace("======");
/*
* CandidATS
* Sites Management
*
* Copyright (C) 2014 - 2015 Auieo Software Private Limited, Parent Company of Unicomtech.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/. */
ob_start();
if ($this->isPopup)
{
TemplateUtility::printHeader('Candidate - '.$this->data['first_name'].' '.$this->data['last_name'], array( 'js/activity.js', 'js/sorttable.js', 'js/match.js', 'js/lib.js', 'js/pipeline.js', 'js/attachment.js'));
}
else
{
TemplateUtility::printHeader('Candidate - '.$this->data['first_name'].' '.$this->data['last_name'], array( 'js/activity.js', 'js/sorttable.js', 'js/match.js', 'js/lib.js', 'js/pipeline.js', 'js/attachment.js'));
}
$AUIEO_HEADER= ob_get_clean();
$AUIEO_CONTENT="";
ob_start();
if ($this->data['is_admin_hidden'] == 1)
{
?>
<p class="warning">This Candidate is hidden. Only CATS Administrators can view it or search for it. To make it visible by the site users, click <a href="<?php echo(CATSUtility::getIndexName()); ?>?m=candidates&a=administrativeHideShow&candidateID=<?php echo($this->candidateID); ?>&state=0" style="font-weight:bold;">Here.</a></p>
<?php 示例13: _printCommonHeader
/**
* Prints template header HTML.
*
* @param string page title
* @param array JavaScript / CSS files to load
* @return void
*/
private static function _printCommonHeader($pageTitle, $headIncludes = array())
{
if (!is_array($headIncludes)) {
$headIncludes = array($headIncludes);
}
$siteID = $_SESSION['CATS']->getSiteID();
/* This prevents caching problems when SVN updates are preformed. */
if ($_SESSION['CATS']->getCachedBuild() > 0) {
$javascriptAntiCache = '?b=' . $_SESSION['CATS']->getCachedBuild();
} else {
$javascriptAntiCache = '?v=' . CATSUtility::getVersionAsInteger();
}
echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"', "\n";
echo '"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">', "\n";
echo '<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">', "\n";
echo '<head>', "\n";
echo '<title>CATS - ', $pageTitle, '</title>', "\n";
echo '<meta http-equiv="Content-Type" content="text/html; charset=', HTML_ENCODING, '" />', "\n";
echo '<link rel="icon" href="images/favicon.ico" type="image/x-icon" />', "\n";
echo '<link rel="shortcut icon" href="images/favicon.ico" type="image/x-icon" />', "\n";
echo '<link rel="alternate" type="application/rss+xml" title="RSS" href="', CATSUtility::getIndexName(), '?m=rss" />', "\n";
/* Core JS files */
echo '<script type="text/javascript" src="js/lib.js' . $javascriptAntiCache . '"></script>', "\n";
echo '<script type="text/javascript" src="js/quickAction.js' . $javascriptAntiCache . '"></script>', "\n";
echo '<script type="text/javascript" src="js/calendarDateInput.js' . $javascriptAntiCache . '"></script>', "\n";
echo '<script type="text/javascript" src="js/submodal/subModal.js' . $javascriptAntiCache . '"></script>', "\n";
echo '<script type="text/javascript" src="js/jquery-1.3.2.min.js' . $javascriptAntiCache . '"></script>', "\n";
echo '<script type="text/javascript">CATSIndexName = "' . CATSUtility::getIndexName() . '";</script>', "\n";
$headIncludes[] = 'main.css';
foreach ($headIncludes as $key => $filename) {
/* Done manually to prevent a global dependency on FileUtility. */
if ($filename == 'tinymce') {
echo '<script language="javascript" type="text/javascript" src="lib/tinymce/jscripts/tiny_mce/tiny_mce.js"></script>' . "\n" . '<script language="javascript" type="text/javascript">tinyMCE.init({
mode : "specific_textareas",
editor_selector : "mceEditor",
width : "100%",
theme : "advanced",
theme_advanced_buttons1 : "bold,italic,strikethrough,separator,bullist,numlist,outdent,indent,separator,justifyleft,justifycenter,justifyright,justifyfull,separator,link,unlink,separator,underline,forecolor,separator,removeformat,cleanup,separator,charmap,separator,undo,redo",
theme_advanced_buttons2 : "",
theme_advanced_buttons3 : "",
language : "en",
theme_advanced_toolbar_location : "top",
theme_advanced_toolbar_align : "left",
theme_advanced_resizing : true,
browsers : "msie,gecko,opera,safari",
dialog_type : "modal",
theme_advanced_resize_horizontal : false,
convert_urls : false,
relative_urls : false,
remove_script_host : false,
force_p_newlines : false,
force_br_newlines : true,
convert_newlines_to_brs : false,
remove_linebreaks : false,
fix_list_elements : true
});</script>' . "\n";
} else {
$extension = substr($filename, strrpos($filename, '.') + 1);
$filename .= $javascriptAntiCache;
if ($extension == 'js') {
echo '<script type="text/javascript" src="', $filename, '"></script>', "\n";
} else {
if ($extension == 'css') {
echo '<style type="text/css" media="all">@import "', $filename, '";</style>', "\n";
}
}
}
}
echo '<!--[if IE]><link rel="stylesheet" type="text/css" href="ie.css" /><![endif]-->', "\n";
echo '<![if !IE]><link rel="stylesheet" type="text/css" href="not-ie.css" /><![endif]>', "\n";
echo '</head>', "\n\n";
}示例14: echo
<img src="images/new_window.gif" alt="(Preview)" border="0" width="15" height="15" />
</a>
</td>
<td valign="top" align="left">
<a href="<?php echo(CATSUtility::getIndexName()); ?>?m=contacts&a=show&contactID=<?php $this->_($data['contactID']); ?>" class="<?php $this->_($data['linkClassContact']); ?>">
<?php $this->_($data['firstName']); ?>
</a>
</td>
<td valign="top" align="left">
<a href="<?php echo(CATSUtility::getIndexName()); ?>?m=contacts&a=show&contactID=<?php $this->_($data['contactID']); ?>" class="<?php $this->_($data['linkClassContact']); ?>">
<?php $this->_($data['lastName']); ?>
</a>
</td>
<td valign="top" align="left"><?php $this->_($data['title']); ?></td>
<td valign="top" align="left">
<a href="<?php echo(CATSUtility::getIndexName()); ?>?m=companies&a=show&companyID=<?php $this->_($data['companyID']); ?>" class="<?php $this->_($data['linkClassCompany']); ?>">
<?php $this->_($data['companyName']); ?>
</a>
</td>
<td valign="top" align="left" nowrap="nowrap"><?php $this->_($data['dateCreated']); ?></td>
<td valign="top" align="left" nowrap="nowrap"><?php $this->_($data['ownerAbbrName']); ?></td>
</tr>
<?php endforeach; ?>
</table>
<?php echo($this->exportForm['footer']); ?>
<?php echo($this->exportForm['menu']); ?>
<?php else: ?>
<p>No matching entries found.</p>
<?php endif; ?>
<?php endif; ?>
</div>示例15: importBulkResumes
private function importBulkResumes()
{
if (!isset($_SESSION['CATS']) || empty($_SESSION['CATS'])) {
CommonErrors::fatal(COMMONERROR_NOTLOGGEDIN, $this);
}
if ($_SESSION['CATS']->getAccessLevel() < ACCESS_LEVEL_SA) {
CommonErrors::fatal(COMMONERROR_PERMISSION, $this);
}
$uploadPath = FileUtility::getUploadPath($this->_siteID, 'massimport');
$attachments = new Attachments($this->_siteID);
$bulkResumes = $attachments->getBulkAttachments();
if (!count($bulkResumes)) {
CommonErrors::fatal(COMMONERROR_BADINDEX, $this);
}
/**
* Write the parsed resume contents to the new file which will
* be created as a text document for each bulk attachment.
*/
foreach ($bulkResumes as $bulkResume) {
$fullName = $bulkResume['originalFileName'];
if (!strlen(trim($fullName))) {
$fullName = 'Untitled';
}
$mp = explode('.', $fullName);
$fileName = implode('.', array_slice($mp, 0, -1));
if (!@file_exists($newFileName = $uploadPath . '/_BulkResume_' . $fileName . '.txt')) {
// Some old files are fulltext encoded which makes them a pain for the parser, fixing here:
$contents = DatabaseSearch::fulltextDecode($bulkResume['text']);
@file_put_contents($newFileName, $contents);
chmod($newFileName, 0777);
}
}
CATSUtility::transferRelativeURI('m=import&a=massImport&step=2');
}