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