function refresh_user_info($prn, $site_id) { $DB_info = $this->load->database('default', TRUE); //grab user info from Ops Whse $user_details_array = get_name_and_prn_array_opw('prn', $prn); if (empty($user_details_array)) { return array(); } $entries = $user_details_array[$prn]; $username = $entries['first_name'] != null ? $entries['first_name'] : "Anonymous Stranger"; $fullname = $username . " " . $entries['last_name']; $values = array('first_name' => $entries['first_name'], 'last_name' => $entries['last_name'], 'display_name' => $fullname, 'email' => $entries['mail'], 'telephone' => $entries['telephone'], 'updated_at' => NULL); //check for prn in database if ($this->is_user_in_database($prn) && $entries['first_name'] != null) { //update user_info $DB_info->update("user_cache", $values, array('network_id' => $prn)); } else { //add user_info to cache $values['network_id'] = $prn; $values['created_at'] = null; $DB_info->insert("user_cache", $values); } //check if user is mapped to this site $map_query = $DB_info->where(array('network_id' => $prn, 'site_id' => $site_id))->get('v_user_cache'); if ($map_query && $map_query->num_rows() > 0) { //must be mapped, so we're ok } else { //not mapped to this site, add them $map_insert_data = array('network_id' => $prn, 'site_id' => $site_id); $DB_info->insert("user_mappings", $map_insert_data); } $retval = $DB_info->affected_rows() > 0 ? true : false; return $retval; }
function get_name_and_prn_list($search_type, $query, $additional_fields_array = false) { return json_encode(get_name_and_prn_array_opw($search_type, $query)); }