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