function getUniquePaymentReferenceNumber($reference_number = NULL)
{
require_once APPPATH . '/models/common_model.php';
$model = new Common_model();
$reference_number = strtoupper(substr($reference_number, 0, 10));
$is_exists = $model->is_exists('payment_id', TABLE_PAYMENTS, array('payment_reference_number' => $reference_number));
if (!empty($is_exists)) {
$reference_number = getUniquePaymentReferenceNumber(rand(100, 99999) . '-' . $reference_number);
}
return $reference_number;
}
public function viewProfile($username)
{
$data = array();
$model = new Common_model();
$custom_model = new Custom_model();
$pageNotFound = FALSE;
if ($username) {
$record = $model->is_exists("*", TABLE_USERS, array("username" => $username));
if (!empty($record)) {
$record = $record[0];
$pageNotFound = TRUE;
$is_friend = FALSE;
$is_accepted = "0";
if (isset($this->session->userdata["user_id"])) {
// $is_friend_record = $model->is_exists("friend_id, is_accepted", TABLE_FRIENDS, array("sent_from" => $this->session->userdata["user_id"], "sent_to" => $record["user_id"]));
$is_friend_record = $custom_model->isFriend($this->session->userdata["user_id"], $record["user_id"], "friend_id, is_accepted");
if (!empty($is_friend_record)) {
$is_friend = TRUE;
$is_accepted = $is_friend_record[0]["is_accepted"];
}
}
$trips_record = $model->fetchSelectedData("trip_title, url_key", TABLE_TRIPS, array("trip_user_id" => $record["user_id"], "trip_status" => "1"), "trip_id", "DESC", "0,5");
// prd($trips_record);
$my_connects_record = $custom_model->getMyFriends($record["user_id"], "first_name, last_name, user_facebook_id, username, user_id", "0,8");
$data["meta_title"] = ucwords($record["first_name"] . " " . $record["last_name"]) . " | " . $this->redis_functions->get_site_setting('SITE_NAME');
$data["meta_description"] = getNWordsFromString($record["user_bio"], 30);
$data["record"] = $record;
$data["is_friend"] = $is_friend;
$data["is_accepted"] = $is_accepted;
$data["trips_record"] = $trips_record;
$data["my_connects_record"] = $my_connects_record;
$data["my_connects_totalcount"] = $custom_model->getMyFriendsCount($record["user_id"]);
$this->template->write_view("content", "pages/user/view-profile", $data);
$this->template->render();
}
}
if ($pageNotFound == FALSE) {
$this->template->write_view("content", "pages/index/page-not-found", $data);
$this->template->render();
}
}
public function facebookAuth($connect = FALSE)
{
if ($this->input->get('code')) {
$this->load->library("SocialLib");
$model = new Common_model();
$socialLib = new SocialLib();
$facebook_user_obj = $socialLib->getFacebookUserObject();
if ($facebook_user_obj['status'] == 'success') {
if (!empty($facebook_user_obj['data'])) {
$facebook_id = $facebook_user_obj['data']['id'];
$facebook_access_token = $facebook_user_obj['accessToken'];
if ($connect == FALSE) {
if (isset($facebook_user_obj['data']['email'])) {
$facebook_name = $facebook_user_obj['data']['name'];
$facebook_email = $facebook_user_obj['data']['email'];
$is_exists = $model->is_exists('user_password', TABLE_USERS, array('user_email' => $facebook_email, 'user_facebook_id' => $facebook_id));
if (empty($is_exists)) {
// get user profile picture here
$facebook_image_url = getFacebookUserImageSource($facebook_id, NULL, USER_IMG_WIDTH);
$new_image_path = USER_IMG_PATH . '/' . getEncryptedString($facebook_id . time()) . '.jpg';
copy($facebook_image_url, $new_image_path);
$user_password = md5($facebook_id . time());
$data_array = array('user_fullname' => addslashes($facebook_name), 'user_email' => $facebook_email, 'user_facebook_id' => $facebook_id, 'user_facebook_accesstoken' => $facebook_access_token, 'user_facebook_array' => json_encode($facebook_user_obj), 'user_created_on' => date('Y-m-d H:i:s'), 'user_ipaddress' => USER_IP, 'user_useragent' => USER_AGENT, 'user_password' => $user_password, 'user_username' => getUniqueUsernameFromEmail($facebook_email), 'user_profile_picture' => $new_image_path);
$model->insertData(TABLE_USERS, $data_array);
$this->session->set_flashdata('success', 'Welcome aboard, ' . $facebook_name);
} else {
$user_password = $is_exists[0]['user_password'];
}
// loggin user in
$this->load->library('Login_auth');
$login_auth = new Login_auth();
$login_auth->login($facebook_email, $user_password, base_url('my-account'), base_url('login'));
} else {
$this->session->set_flashdata('error', 'Email required when logging in with Facebook');
redirect(base_url('login'));
}
} elseif ($connect == 'connect' && isset($this->session->userdata['user_id'])) {
$user_id = $this->session->userdata['user_id'];
$next_url = base_url('my-account');
$is_exists = $model->is_exists('user_id', TABLE_USERS, array('user_id !=' => $user_id, 'user_facebook_id' => $facebook_id));
if (empty($is_exists)) {
$data_array = array('user_facebook_id' => $facebook_id, 'user_facebook_accesstoken' => $facebook_access_token, 'user_facebook_array' => json_encode($facebook_user_obj));
$model->updateData(TABLE_USERS, $data_array, array('user_id' => $this->session->userdata['user_id']));
$this->session->set_flashdata('success', 'Facebook account connected successfully');
if ($this->input->get('next')) {
$next_url = $this->input->get('next');
}
} else {
$this->session->set_flashdata('error', 'Another user already exists with this Facebook account');
}
redirect($next_url);
}
} else {
$this->session->set_flashdata('error', 'An error occurred. Please try again.');
redirect(base_url('login'));
}
} else {
$this->session->set_flashdata('error', $facebook_user_obj['data']);
redirect(base_url('login'));
}
} else {
display_404_page();
}
}
public function search_query($view_type = 'list', $page = 1)
{
$model = new Common_model();
$custom_model = new Custom_model();
if ($this->input->get('q')) {
$params = $this->input->get();
$query = $params['q'];
$user_id = isset($this->session->userdata['user_id']) == TRUE ? $this->session->userdata['user_id'] : NULL;
if ($model->is_exists('ps_id', TABLE_POST_SEARCHES, array('ps_user_id' => $user_id, 'ps_query' => addslashes($query), 'ps_timestamp >=' => date('Y-m-d'))) == FALSE) {
$data_array = array('ps_user_id' => $user_id, 'ps_query' => addslashes($query), 'ps_url' => addslashes(current_url()), 'ps_params' => json_encode($params), 'ps_ipaddress' => USER_IP, 'ps_useragent' => USER_AGENT);
$model->insertData(TABLE_POST_SEARCHES, $data_array);
}
$order_by = get_post_mysql_sort_by(@$params['sort']);
$group_by = 'p.post_id';
$where_cond_str = '1';
$search_results = $custom_model->get_search_results('p.post_url_key', $where_cond_str, $order_by, $group_by);
$input_arr = array(base_url() => 'Home', '#' => 'Search');
$breadcrumbs = get_breadcrumbs($input_arr);
$page_title = 'Search results';
$data["post_records"] = $search_results;
$data["view_type"] = $view_type;
$data["page"] = $page;
$data["breadcrumbs"] = $breadcrumbs;
$data["page_title"] = $page_title;
$data['meta_title'] = $data["page_title"] . ' - ' . $this->redis_functions->get_site_setting('SITE_NAME');
$this->template->write_view("content", "pages/trip/listing/list-page", $data);
$this->template->render();
} else {
display_404_page();
}
}
