function __construct($module = false)
{
$this->urlModuleParam = ClsNaanalRequest::getInstance()->getUrlModuleParam();
$this->urlActionParam = ClsNaanalRequest::getInstance()->getUrlActionParam();
if ($module !== false) {
$this->module = $module;
}
}
public function __construct($module,$cols) {
$this->cols=$cols;
$objHTML=ClsNaanalLibrary::getInstance("html");
$this->objTable=$objHTML->getGenerator()->getTable("search",$cols);
//$this->objTable->setParam("border",1);
pageHeaderInclude('js/export.js');
pageHeaderInclude('js/searchSaved.js');
pageHeaderInclude('js/suggest.js');
parent::__construct($module);
$arrPager=ClsNaanalRequest::getInstance()->getPager();
$pagination=getPagination("index.php?module={$module}", $this->objAuieoModel->getTotalRecords() , $arrPager["current_page"], $arrPager["items_per_page"]);
$this->assign("total_records",$this->objAuieoModel->getTotalRecords());
$this->assign("pagination",$pagination);
}
public function __construct(ClsAuieoArray &$objAuieoModel)
{
$this->objAuieoModel=$objAuieoModel;
parent::__construct("joborders",7);
$rows=$objAuieoModel->getRows();
if($rows>0)
{
$this->addRowCheckbox(0);
$this->addData($this->getSortLink('name', 'Name'),0,0);
$this->addData($this->getSortLink('phone1', 'Primary Phone'),0,1);
$this->addData("Key Technologies",0,2);
$this->addData($this->getSortLink('city', 'Created'),0,3);
$this->addData($this->getSortLink('owner_user.last_name', 'Owner'),0,4);
for($i=0;$i<$rows;$i++)
{
$this->addRowCheckbox($i+1,$objAuieoModel->getRenderValue($i,0));
$this->addData($objAuieoModel->getRenderValue($i,1), $i+1, 0);
$this->addData($objAuieoModel->getRenderValue($i,2), $i+1, 1);
$this->addData($objAuieoModel->getRenderValue($i,3), $i+1, 2);
$this->addData($objAuieoModel->getRenderValue($i,4), $i+1, 3);
$this->addData($objAuieoModel->getRenderValue($i,5), $i+1, 4);
}
$this->assign("list",$this->getTable());
}
else
{
$this->assign("list","No matching entries found.");
}
$arrPager=ClsNaanalRequest::getInstance()->getPager();
$pagination=getPagination("index.php?module=joborders", $rows, $arrPager["current_page"], $arrPager["items_per_page"]);
$this->assign("pagination",$pagination);
$this->assign("total_records",$rows);
$this->assign("filter", ClsJobOrdersFilter::getInstance()->getFilter());
//$this->addData("test",3,3);
//$this->addColHeading("good",3);
//<input type="checkbox" id="checked_<?php echo($data['contactID']); ? >" name="checked_<?php echo($data['contactID']); ? >" />
}
public function setData($name, $value)
{
$this->arrNaanalGet[$name] = $value;
if ($this->isDataSet($name)) {
ClsNaanalRequest::getInstance()->setData($name, $value);
}
if ($name == $this->urlModuleParam) {
$this->module = $value;
} else {
if ($name == $this->urlActionParam) {
$this->action = $value;
} else {
if ($name == $this->urlSwitchParam) {
$this->switch = $value;
}
}
}
}
public function loadCurrentURL()
{
$arrUrl = array();
foreach (ClsNaanalRequest::getInstance()->getAll() as $k => $v) {
$arrUrl[$k] = $v;
}
$current_url = json_encode($arrUrl);
$this->assign("current_url", $current_url);
}
public function advancedSearchOn($advancedSearchOn = false)
{
$objRequest = ClsNaanalRequest::getInstance();
$this->advancedSearchOn = $advancedSearchOn === false ? $objRequest->getData("advancedSearchOn") : $advancedSearchOn;
}
public function buildFilter(ClsAuieoSQL &$objSQL)
{
$objFromCandidate=$objSQL->getFromObjectByTableName($this->table);
$arrWhere=array();
$objRequest=ClsNaanalRequest::getInstance();
$arrFieldFilter=$objRequest->getData("fldfilter");
if($arrFieldFilter)
{
$data=$objRequest->getData("data");
$condition=$objRequest->getData("condition");
$boolean=$objRequest->getData("boolean");
$group=$objRequest->getData("boolean");
foreach($arrFieldFilter as $ind=>$fldFilter)
{
if(empty($data[$ind])) continue;
$arrWhere[]=array("field"=>$fldFilter,"data"=>$data[$ind],"condition"=>$condition[$ind],"boolean"=>$boolean[$ind],"group"=>$group[$ind]==1?true:false);
}
}
$where="";
if($arrWhere)
foreach($arrWhere as $ind=>$whr)
{
if(is_numeric($whr["field"]))
{
$sql="select * from extra_field_settings where extra_field_settings_id={$whr["field"]}";
$db = DatabaseConnection::getInstance();
$arrRow=$db->getAllAssoc($sql);
$field_name=$arrRow[0]["field_name"];
$ctable="STABLE{$ind}";
$cfield="`STABLE{$ind}`.`{$field_name}`";
$cquery="select {$this->table}.{$this->table}_id as `parent_table_id{$ind}`,`ext{$ind}`.`value` AS `{$field_name}` from {$this->table} left join `extra_field` AS `ext{$ind}` ON {$this->table}.{$this->table}_id = ext{$ind}.data_item_id AND ext{$ind}.field_name='{$field_name}'";
$cfrom=$objSQL->addQuery($cquery,$ctable);
$cjoin=$cfrom->addJoinField("parent_table_id{$ind}");
$ccandidate=new ClsAuieoSQLFrom();
$ccandidate->setTable("candidate");
$ccjoin=$ccandidate->addJoinField("candidate_id");//trace($cjoin);
$cfrom->setJoinWith($ccandidate,$ccjoin, $cjoin);
$objSQL->addSelect($cfrom, $field_name);
$objWhere=$objSQL->addWhere($cfrom, $field_name, $whr["data"]);
}
else
{
$objWhere=$objSQL->addWhere($objFromCandidate, $whr["field"], $whr["data"]);
$boolean=$arrWhere[$ind]["boolean"];
$objWhere->setBoolean($boolean);
}
if($whr["group"]==1)
{
$objWhere->setGroup();
}
if(empty($where))
{
if($whr["condition"]=="equals")
{
}
else
{
$objWhere->setCondition("like");
}
}
else
{
if($whr["condition"]=="equals")
{
}
else
{
$objWhere->setCondition("like");
}
}
}
}
public function templateVariables()
{
$objRequest=ClsNaanalRequest::getInstance();
$templatemodule=$objRequest->getData("templatemodule");
$templateID=$objRequest->getData("templateID");
if(empty($templatemodule))
{
$template="";
if(!empty($templateID))
{
$emailTemplates = new EmailTemplates($this->_siteID);
$template=$emailTemplates->get($templateID);
$template["text"]= $template["text"];
$template["templatemodule"]= $template["baseModule"];
}
$arrTplVar=array();
$arrTplVar = $template;
}
else
{
$arrModule=array();
$arrModuleTable["candidates"]=array("module"=>"candidate","extra"=>"Candidate");
$arrModuleTable["joborders"]=array("module"=>"joborder","extra"=>"Joborder");
$arrModuleTable["contacts"]=array("module"=>"contact","extra"=>"Contact");
$arrModuleTable["companies"]=array("module"=>"company","extra"=>"Company");
$arrModuleTable["users"]=array("module"=>"user");
$arrCandidateParentModule["contacts"]=array("contacts"=>"contacts","companies"=>"companies","users"=>"users");
$arrCandidateParentModule["joborders"]=array("joborders"=>"joborders","companies"=>"companies","recruiter"=>"users","owner"=>"users");
$arrCandidateParentModule["candidates"]=array("candidates"=>"candidates","joborders"=>"joborders","companies"=>"companies","users"=>"users");
$arrTplVar=array();
$allModules=$arrCandidateParentModule[$templatemodule];
if($allModules)
foreach($allModules as $foreignKey=>$amodule)
{
$tableName=$arrModuleTable[$amodule]["module"];
$extraFieldTableName=isset($arrModuleTable[$amodule]["extra"])?$arrModuleTable[$amodule]["extra"]:"";
$objDatabase = DatabaseConnection::getInstance();
$sql="SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '".DATABASE_NAME."' AND TABLE_NAME = '{$tableName}' order by COLUMN_NAME";
$arrRow=$objDatabase->getAllAssoc($sql);
$arrMainColumn=array();
if($arrRow)
foreach($arrRow as $row)
{
$arrMainColumn[$row["COLUMN_NAME"]]=$row["COLUMN_NAME"];
}
asort($arrMainColumn,SORT_STRING);
$arrTplVar[$foreignKey][$amodule]["main"]=$arrMainColumn;
$arrExtraColumn=array();
if($extraFieldTableName)
{
$sql="select extra_field_settings_id,field_name from extra_field_settings left join data_item_type on data_item_type_id=data_item_type where short_description='{$extraFieldTableName}' order by field_name";
$arrRow=$objDatabase->getAllAssoc($sql);
if($arrRow)
foreach($arrRow as $row)
{
$arrExtraColumn["EXTRA_".$row["field_name"]]=$row["field_name"];
}
asort($arrExtraColumn,SORT_STRING);
}
if($arrExtraColumn)
{
$arrTplVar[$foreignKey][$amodule]["extra"]=$arrExtraColumn;
}
}
$arrTplVar[$foreignKey][$amodule]["other"]["currentTime"]="currentTime";
if(empty($arrTplVar))
{
$arrTplVar=array();
$arrTplVar["a"]="b";
}
}
echo json_encode($arrTplVar);exit;
}
public function emailCandidateJoborder()
{
$db = DatabaseConnection::getInstance();
$idlist=trim($_REQUEST["idlist"]);
$joborderid = ClsNaanalRequest::getInstance()->getData("jobOrderID");
$arrJoborder=$db->getAllAssoc("select * from joborder where joborder_id={$joborderid}");
$title=$arrJoborder[0]["title"];
$rs = $db->getAllAssoc(sprintf(
'SELECT candidate_id, email1, email2 '
. 'FROM candidate '
. 'WHERE candidate_id IN (%s)',
$idlist
));
$emailTemplates = new EmailTemplates($this->_siteID);
$emailTemplatesRS = $emailTemplates->getAll();
$this->_template->assign('emailTemplatesRS', $emailTemplatesRS);
$this->_template->assign('active', $this);
$this->_template->assign('recipients', $rs);
$this->_template->assign('joborder_title', $title);
$this->_template->assign('joborderid', $joborderid);
$this->_template->display(
'./modules/candidates/emailCandidateJoborder.php'
);
}
public function byAll($sortBy, $sortDirection)
{
$from=false;
$this->buildFilter($this->objSQL);
$this->objSQL->addOrderBy($sortBy,$sortDirection=="ASC"?true:false);
ClsNaanalSession::getInstance()->setPanelData("search_sql", $this->objSQL->render());
$arrPager=ClsNaanalRequest::getInstance()->getPager();
$this->objSQL->setLimit($arrPager["start"],$arrPager["items_per_page"]);
$sql=$this->objSQL->render();
$count_sql=$this->objSQL->render(true);
$arr=$this->_db->getAllAssoc($count_sql);
$totalRecords=$arr[0]["count"];
$rs=$this->_db->getAllAssoc($sql);
foreach ($rs as $rowNumber => $row)
{
$this->setValue($row["companyID"],$rowNumber,0);
$this->setValue($row["name"],$rowNumber,1);
$this->setValue($row["phone1"],$rowNumber,2);
$this->setValue($row["keyTechnologies"],$rowNumber,3);
$this->setValue($row["dateCreated"],$rowNumber,4);
$this->setValue($row["ownerFirstName"]." ".$row["ownerLastName"],$rowNumber,5);
}
$this->render();
}
