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