private static function init() { if (self::$db !== null) { return; } self::$db = Zend_Registry::get("DB"); }
public function geAllUser() { $db = PR_Database::getInstance(); $select = $db->select(); $select->from(array('u' => 'user'), array('*')); $records = PR_Database::fetchAll($select); return $records; }
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 static function getConfigVal($cfgkey) { $db = PR_Database::getInstance(); $select = $db->select(); $select->from(PR_Database::TABLE_config); $select->where("cfgkey = ?", $cfgkey); $records = PR_Database::fetchAll($select); if (!empty($records)) { return $records[0]['cfgval']; } else { return ''; } }
public function getById($id) { $db = PR_Database::getInstance(); $select = $db->select(); $select->from("sections"); $select->where("section_id= '{$id}'"); $records = PR_Database::fetchAll($select); if (empty($records)) { return NULL; } else { return $records[0]; } }
public function checkUser($emailaddress) { $db = PR_Database::getInstance(); $select = $db->select(); $select->from('user'); $select->where("emailaddress = '{$emailaddress}'"); $records = PR_Database::fetchAll($select); if (!empty($records)) { return $records[0]; } else { return array("Error" => "This email is not found."); } }
public function getInfo() { $errors = PR_Api_Error::getInstance(); $db = PR_Database::getInstance(); $select = $db->select(); $select->from($this->_name, array('*')); $select->where($this->_pk . " = ?", $this->{$this->_pk}); //print_r($select->__toString()); $records = PR_Database::fetchAll($select); if (!empty($records) && count($records) > 0) { return $records[0]; } else { $errors->addError(3, 'Can not get object'); return null; } }
public function registerClient($data) { if (empty($data) || !is_array($data)) { return NULL; } $db = PR_Database::getInstance(); $ClientID = false; $mapping = array("firstname" => "firstname", "lastname" => "lastname", "emailaddress" => "emailaddress", "usertype" => "usertype", "password" => "password", "HeardFrom" => "HeardFrom", "loginname" => "loginname"); foreach ($data as $id => $value) { if (!array_key_exists($id, $mapping) || empty($value)) { continue; } $data[$mapping[$id]] = $value; } $primaryEmail = $data["emailaddress"]; $loginname = $data["loginname"]; // { $maxIdSql = "SELECT MAX(UserID) AS UserID FROM user"; $result = $db->fetchAll($maxIdSql); $User_ID = $result[0]['UserID'] + 1; $select = $db->select()->from(PR_Database::TABLE_USER, array('emailaddress')); $select->where("emailaddress = '{$primaryEmail}'"); $res = $db->fetchAll($select); $select1 = $db->select()->from(PR_Database::TABLE_USER, array('loginname')); $select1->where("loginname = '{$loginname}'"); $res1 = $db->fetchAll($select1); if (!empty($res) && count($res) > 0) { return array("error" => "email exists"); // echo("email exists"); } else { if (!empty($res1) && count($res1) > 0) { return array("error" => "User exists"); } else { if ($data['usertype'] == 1) { $db->insert(PR_Database::TABLE_USER, array("UserID" => $User_ID, "firstname" => $data['firstname'], "lastname" => $data['lastname'], "usertype" => $data['usertype'], "emailaddress" => $data['emailaddress'], "password" => $data['password'], "HeardFrom" => $data['HeardFrom'], "loginname" => $data['loginname'], "CompanyID" => "1")); } if ($data['usertype'] == 2) { $db->insert(PR_Database::TABLE_USER, array("UserID" => $User_ID, "firstname" => $data['firstname'], "lastname" => $data['lastname'], "usertype" => $data['usertype'], "emailaddress" => $data['emailaddress'], "password" => $data['password'], "HeardFrom" => $data['HeardFrom'], "loginname" => $data['loginname'])); } } } $db->commit(); }
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 registerClient($data) { if (empty($data) || !is_array($data)) { return NULL; } $db = PR_Database::getInstance(); $ClientID = false; $mapping = array("firstname" => "firstname", "lastname" => "lastname", "emailaddress" => "emailaddress", "usertype" => "usertype", "password" => "password", "HeardFrom" => "HeardFrom", "CompanyID" => "CompanyID"); foreach ($data as $id => $value) { if (!array_key_exists($id, $mapping) || empty($value)) { continue; } $data[$mapping[$id]] = $value; } $api = new PR_Api_Core_ClientClass(); $defaultCompany = $api->getDefaultCompany(); $defaultCompanyID = $defaultCompany['CompanyID']; // echo ("defaultCompanyID:".$defaultCompanyID); $primaryEmail = $data["emailaddress"]; $maxIdSql = "SELECT MAX(UserID) AS UserID FROM user"; $result = $db->fetchAll($maxIdSql); $User_ID = $result[0]['UserID'] + 1; $select = $db->select()->from(PR_Database::TABLE_USER, array('emailaddress')); $select->where("emailaddress = '{$primaryEmail}'"); $res = $db->fetchAll($select); if (!empty($res) && count($res) > 0) { return array("error" => "email exists"); echo "email exists"; } else { if ($data['usertype'] == 1) { // echo ("tetstt:<pre>");print_r($data);echo("</pre>");die(); $maxIdSql = "SELECT MAX(CompanyID) AS CompanyID FROM company"; $result = $db->fetchAll($maxIdSql); $CompanyID = $result[0]['CompanyID']; /* $Companyname=$data['Companyname']; $select1 = $db->select()->from(PR_Database::TABLE_COMPANY, array('Companyname')); $select1->where("Companyname = '$Companyname'"); $res1 = $db->fetchAll($select1); if(!empty($res1) && count($res1) > 0 ) { return array("error" => "Company name exists","CompanyID"=>""); echo("Companyname exists"); }else{ $updateFields=array( 'CompanyID'=>$CompanyID, 'Companyname'=>$data['Companyname'] ); $result = PR_Database::insert("company", $updateFields); // return $CompanyID; return array("error"=>"","CompanyID" => "$CompanyID"); } */ // $db->insert(PR_Database::TABLE_USER, array("UserID" => $User_ID, "firstname" => $data['firstname'], "lastname" => $data['lastname'], "usertype" => $data['usertype'], "emailaddress" => $data['emailaddress'], "password" => $data['password'], "HeardFrom" => $data['HeardFrom'], "CompanyID" => $CompanyID)); } if ($data['usertype'] == 2) { $db->insert(PR_Database::TABLE_USER, array("UserID" => $User_ID, "firstname" => $data['firstname'], "lastname" => $data['lastname'], "usertype" => $data['usertype'], "emailaddress" => $data['emailaddress'], "password" => $data['password'], "HeardFrom" => $data['HeardFrom'])); } } $db->commit(); }
public function getStateByStateCode($stateCode) { $db = PR_Database::getInstance(); $select = $db->select(); $select->from(array('s' => 'state'), array('*')); $select->where("s.state_code ='" . $stateCode . "'"); //print_r($select->__toString());die(); $result = PR_Database::fetchAll($select); 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 UpdatePass($userID, $password) { PR_Database::update('user', array('password' => $password), "UserID = '{$userID}'"); return; }
public function getUserById($id) { $db = PR_Database::getInstance(); $select = $db->select(); $select->from(PR_Database::TABLE_users); $select->where("user_id = '{$id}'"); $users = PR_Database::fetchAll($select); if (empty($users)) { return NULL; } else { return $users[0]; } }
public function delete($testIDArray) { if (!is_array($testIDArray) || count($testIDArray) == 0) { return; } $criteria = "TestID IN (" . implode(",", $testIDArray) . ")"; $db = PR_Database::getInstance(); $select = $db->select(); $select->from('opportunity_test', array('TestID')); $select->where("TestID IN (" . implode(",", $testIDArray) . ")"); $records = PR_Database::fetchAll($select); $result = 0; if (!empty($records) && count($records) > 0) { $result = 0; } else { $result = $db->delete('test', $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 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; }