public function Add($updateFields)
{
$userName = $updateFields['username'];
//--- validate
if (empty($userName)) {
$errors = PR_Api_Error::getInstance();
$errors->addError(6, 'User Name is empty');
return false;
} else {
$userObj = $this->GetUserByUserName($userName);
if (!empty($userObj)) {
$errors = PR_Api_Error::getInstance();
$errors->addError(6, 'User Name already existed.');
return false;
}
}
//--- insert
$result = PR_Database::insert("users", $updateFields);
return $result;
}
public function add($userID, $institutionName)
{
if (empty($institutionName)) {
return 0;
}
//--- get institution_id by $institutionName
$db = PR_Database::getInstance();
$select = $db->select();
$select->from('institution', array('institution_id', 'institution_name'));
$select->where("institution_name = '{$institutionName}'");
$records = PR_Database::fetchAll($select);
$institution_id = 0;
if (count($records) > 0) {
$institution_id = $records[0]['institution_name'];
}
if ($institution_id > 0) {
return $institution_id;
}
//---
$updateFields = array('institution_name' => $name, 'created_by_userid' => $userID, 'created_datetime' => date('Y-m-d H:i:s'), 'last_updated_by_userid' => $userID, 'last_updated_datetime' => date('Y-m-d H:i:s'));
$id = PR_Database::insert("institution", $updateFields, true);
return $id;
}
public function saveCareerTests($careerID, $testIDs)
{
//opportunity_test: OpportunityTestID,CareerID,TestID
//--- select current tests
$db = PR_Database::getInstance();
$select = $db->select();
$select->from('opportunity_test', array('OpportunityTestID', 'CareerID', 'TestID'));
$select->where("CareerID = '" . $careerID . "' ");
$records = PR_Database::fetchAll($select);
$currentTests = array();
if (count($records) > 0) {
foreach ($records as $rec) {
$currentTests[] = $rec['TestID'];
}
}
if (empty($testIDs) || count($testIDs) == 0) {
$criteria = "CareerID = '{$careerID}'";
$result = $db->delete('opportunity_test', $criteria);
} else {
if (count($currentTests) == 0) {
foreach ($testIDs as $id) {
$updateFields = array('CareerID' => $careerID, 'TestID' => $id);
$result = PR_Database::insert("opportunity_test", $updateFields);
}
} else {
$arrayDiff_1 = array_diff($currentTests, $testIDs);
if (count($arrayDiff_1) > 0) {
$criteria = "CareerID = '{$careerID}' AND TestID IN (" . implode(",", $arrayDiff_1) . ")";
$result = $db->delete('opportunity_test', $criteria);
}
$arrayDiff_2 = array_diff($testIDs, $currentTests);
if (count($arrayDiff_2) > 0) {
foreach ($arrayDiff_2 as $id) {
$updateFields = array('CareerID' => $careerID, 'TestID' => $id);
$result = PR_Database::insert("opportunity_test", $updateFields);
}
}
}
}
}
public function AddCompany($data)
{
if (empty($data) || !is_array($data)) {
return NULL;
}
$db = PR_Database::getInstance();
$Fields = array();
foreach ($data as $key => $value) {
if (in_array($key, $this->avaiUpdateFields1)) {
$Fields[$key] = $value;
}
}
$maxIdSql = "SELECT MAX(CompanyID) AS CompanyID FROM company";
$result = $db->fetchAll($maxIdSql);
$CompanyID = $result[0]['CompanyID'] + 1;
$Companyname = $Fields['Companyname'];
$select = $db->select()->from(PR_Database::TABLE_COMPANY, array('Companyname'));
$select->where("Companyname = '{$Companyname}'");
$res = $db->fetchAll($select);
if (!empty($res) && count($res) > 0) {
return array("error" => "Company name exists", "CompanyID" => "");
echo "Companyname exists";
} else {
$updateFields = array('CompanyID' => $CompanyID, 'Companyname' => $Fields['Companyname'], 'Industry' => $Fields['Industry'], 'Address' => $Fields['Address'], 'Address2' => $Fields['Address2'], 'country' => $Fields['country'], 'PhoneNumber' => $Fields['PhoneNumber'], 'emailinfo' => $Fields['emailinfo'], 'images' => $Fields['images'], 'Description' => $Fields['Description'], 'Zipcode' => $Fields['Zipcode'], 'faxnumber' => $Fields['faxnumber'], 'city' => $Fields['city'], 'state' => $Fields['state']);
$result = PR_Database::insert("company", $updateFields);
// return $CompanyID;
return array("error" => "", "CompanyID" => "{$CompanyID}");
}
}
public function updateCandidateAttribute($CandidateProfileID, $attrs)
{
$db = PR_Database::getInstance();
$select = $db->select();
$select->from(array('cav' => 'candidate_attribute_value'), array('*'));
$select->where("cav.Candidate_ProfileID = '{$CandidateProfileID}'");
$records = PR_Database::fetchAll($select);
if (count($records) > 0) {
if (empty($attrs) || count($attrs) == 0) {
$criteria = "Candidate_ProfileID = '{$CandidateProfileID}'";
$result = $db->delete('candidate_attribute_value', $criteria);
} else {
/*echo "<pre>";
echo "test1 = "; print_r($attributeIDs);
echo "</pre>"; die();*/
//if database not exist $attrs then delete
foreach ($records as $rec) {
$database_Exist = $rec['AttributeID'];
$flag_exsist = false;
foreach ($attrs as $attrInfo) {
if ($database_Exist == $attrInfo['attr_id']) {
$flag_exsist = true;
break;
}
}
if (!$flag_exsist) {
$criteria = "Candidate_ProfileID = '{$CandidateProfileID}' AND AttributeID = '{$database_Exist}'";
$result = $db->delete('candidate_attribute_value', $criteria);
}
}
// if $attr not exist in database then insert, else update
foreach ($attrs as $attributeInfo) {
$attr_Exist = $attributeInfo['attr_id'];
$flag_exsist = false;
foreach ($records as $recordsInfo) {
if ($attr_Exist == $recordsInfo['AttributeID']) {
$updateFields = array('Candidate_ProfileID' => $CandidateProfileID, 'AttributeID' => $attributeInfo['attr_id'], 'Value' => $attributeInfo['attr_value'], 'YearsofExperience' => $attributeInfo['attr_YoE'], 'LevelofInterest' => $attributeInfo['attr_LevelofInterest']);
$criteria = "Candidate_ProfileID = '{$CandidateProfileID}' AND AttributeID = '{$attr_Exist}'";
$result = PR_Database::update("candidate_attribute_value", $updateFields, $criteria);
$flag_exsist = true;
break;
}
}
if (!$flag_exsist) {
$updateFields = array('Candidate_ProfileID' => $CandidateProfileID, 'AttributeID' => $attributeInfo['attr_id'], 'Value' => $attributeInfo['attr_value'], 'YearsofExperience' => $attributeInfo['attr_YoE'], 'LevelofInterest' => $attributeInfo['attr_LevelofInterest']);
$result = PR_Database::insert("candidate_attribute_value", $updateFields);
}
}
}
} else {
if (!empty($attrs) && count($attrs) > 0) {
foreach ($attrs as $id) {
$updateFields = array('Candidate_ProfileID' => $CandidateProfileID, 'AttributeID' => $id['attr_id'], 'Value' => $id['attr_value'], 'YearsofExperience' => $id['attr_YoE'], 'LevelofInterest' => $id['attr_LevelofInterest']);
$result = PR_Database::insert("candidate_attribute_value", $updateFields);
}
}
}
return true;
}
public function updateQuestion($testQuestionID, $quesName, $answerOtionArray, $qstListID)
{
if (empty($testQuestionID) || empty($quesName)) {
return;
}
//test_question
//TestQuestionID,Test_TestID,Question,Point
$updateFields = array('Question' => $quesName);
$criteria = "TestQuestionID = '{$testQuestionID}'";
$result = PR_Database::update("test_question", $updateFields, $criteria);
//test_question_answer
//TestQuestionAnswerID,TestQuestion_TestQuestionID,AnswerText
if (count($qstListID) > 0) {
$db = PR_Database::getInstance();
$criteria = "TestQuestion_TestQuestionID = '{$testQuestionID}' AND TestQuestionAnswerID NOT IN ('" . implode("','", $qstListID) . "')";
$result = $db->delete('test_question_answer', $criteria);
}
if (count($answerOtionArray) > 0) {
foreach ($answerOtionArray as $key => $answerOption) {
if (empty($answerOption['answerID']) && $answerOption['answerID'] == "") {
$updateFields = array('TestQuestion_TestQuestionID' => $testQuestionID, 'AnswerText' => $answerOption['answerText']);
$result = PR_Database::insert("test_question_answer", $updateFields);
} else {
$updateFields = array('AnswerText' => $answerOption['answerText']);
$criteria = "TestQuestionAnswerID = '" . $answerOption["answerID"] . "' AND TestQuestion_TestQuestionID = '{$testQuestionID}'";
$result = PR_Database::update('test_question_answer', $updateFields, $criteria);
}
}
} else {
if (is_array($answerOtionArray) && count($answerOtionArray) == 0) {
$db = PR_Database::getInstance();
$criteria = "TestQuestion_TestQuestionID = '{$testQuestionID}'";
$result = $db->delete('test_question_answer', $criteria);
}
}
}
public function addjobfunction($CandidateEmploymentID, $Text)
{
//echo "Percentage:".$Percentage;die();
// $updateFields = array("JobFunctionID"=>$JobFucntion,"Percentage"=>$Percentage,"CandidateEmploymentID"=> $CandidateEmploymentID);
// $result = PR_Database::insert('credentialexperiencejobfunction',$updateFields);
if (!empty($Text)) {
for ($i = 0; $i < count($Text["JobFucntion1"]); $i++) {
// echo "JobFucntion:".$Text["JobFucntion1"][$i]." "."Percentage:".$Text["Percentage1"][$i]."<br>";
$result = PR_Database::insert('credentialexperiencejobfunction', array("JobFunctionID" => $Text["JobFucntion1"][$i], "CandidateEmploymentID" => $CandidateEmploymentID, "Percentage" => $Text["Percentage1"][$i]));
}
}
return $result;
}
