Olu Amey
102 lines
2.6 KiB
PHP
102 lines
2.6 KiB
PHP
<?php
|
|
|
|
class Account_model extends CI_Model {
|
|
|
|
function __construct() {
|
|
|
|
}
|
|
|
|
public function verify_link($data) {
|
|
$q = $this
|
|
->db
|
|
->where('verify_link', $data['vlink'])
|
|
->limit(1)
|
|
->get('members_pending');
|
|
|
|
|
|
// print_r($q->row());
|
|
//echo "--AAA--" . $q->num_rows();
|
|
|
|
if ($q->num_rows() > 0) {
|
|
// echo '<pre>';
|
|
// print_r($q->row());
|
|
// echo '</pre>';
|
|
return $q->row();
|
|
} else {
|
|
|
|
//echo '<pre>';
|
|
// echo "No rows " . $this->db->last_query();
|
|
//print_r($data);
|
|
//echo '</pre>';
|
|
return false;
|
|
}
|
|
}
|
|
|
|
public function verifySignupInputs($data) {
|
|
$ret = false;
|
|
if (trim($data['firstname']) != '' && trim($data['lastname']) != '' && trim($data['email']) != '' && trim($data['username']) != '' && trim($data['password']) != '' && trim($data['country']) != '' && isset($data['terms']) && $data['terms'] == 'on') {
|
|
$ret = true;
|
|
}
|
|
return $ret;
|
|
}
|
|
|
|
public function checkUsernameDuplicate($data) {
|
|
$q = $this
|
|
->db
|
|
->where('username', $data['username'])
|
|
->limit(1)
|
|
->get('members');
|
|
|
|
$q2 = $this
|
|
->db
|
|
->where('username', $data['username'])
|
|
->limit(10)
|
|
->get('members_pending');
|
|
|
|
return $q->num_rows() + $q2->num_rows();
|
|
}
|
|
|
|
public function username_data($data) {
|
|
$q = $this
|
|
->db
|
|
->where('username', $data['username'])
|
|
->limit(1)
|
|
->get('members');
|
|
|
|
if ($q->num_rows() > 0) {
|
|
return $q->row();
|
|
} else {
|
|
|
|
|
|
return false;
|
|
}
|
|
}
|
|
|
|
public function loadAccountData($member_id) {
|
|
$q = $this
|
|
->db
|
|
->where('id', $member_id)
|
|
->limit(1)
|
|
->get('members');
|
|
|
|
if ($q->num_rows() > 0) {
|
|
// return $q->row();
|
|
return $q->result_array();
|
|
} else {
|
|
return false;
|
|
}
|
|
}
|
|
|
|
public function loadActiveTaskCount($member_id) {
|
|
$num = 0;
|
|
$mysql = "SELECT id FROM members_jobs_contract WHERE client_id = $member_id AND status IN (1,2) "
|
|
. "UNION "
|
|
. "SELECT id FROM members_jobs_contract WHERE member_id = $member_id AND status IN (1,2) ";
|
|
|
|
$query = $this->db->query($mysql);
|
|
$num = $query->num_rows();
|
|
return $num;
|
|
}
|
|
|
|
}
|