public function UpdateSectionStudentNum($sectionId, $num)
{
$students_num = $this->GetSectionNum($sectionId);
$students_num = $students_num + $num;
$dbFields = array();
$dbFields['students_num'] = $students_num;
$criteria = "section_id = '{$sectionId}'";
$result = PR_Database::update('sections', $dbFields, $criteria);
return $result;
}
public function publibOpportunityByOpportunityID($opportunityID, $status)
{
$db = PR_Database::getInstance();
$updateFields = array('status' => $status);
$criteria = "OpportunityID = '{$opportunityID}'";
$result = PR_Database::update('opportunity', $updateFields, $criteria);
return $result;
}
public function uploadVideo($CompanyID, $video)
{
$result = PR_Database::update('company', array('video' => $video), "CompanyID = '{$CompanyID}'");
return $result;
}
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 Update($userId, $updateFields)
{
$criteria = "user_id = '{$userId}'";
$result = PR_Database::update("users", $updateFields, $criteria);
return $result;
}
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 UpdatePass($userID, $password)
{
PR_Database::update('user', array('password' => $password), "UserID = '{$userID}'");
return;
}
public function updateJobFunction($JobFunctionID, $CandidateEmploymentID, $Percentage, $jobid)
{
$updatefield = array('JobFunctionID' => $JobFunctionID, "CandidateEmploymentID" => $CandidateEmploymentID, "Percentage" => $Percentage);
$result = PR_Database::update('credentialexperiencejobfunction', $updatefield, array("id = '{$jobid}'"));
return $result;
}
