Revize 267
Přidáno uživatelem Tomáš Dulík před asi 15 roky(ů)
| freenetis/trunk/kohana/application/models/member.php | ||
|---|---|---|
|
LIMIT 1
|
||
|
) ";
|
||
|
/* Slower alternative:
|
||
|
$q='SELECT members.id FROM members JOIN users on members.id=users.member_id where REPLACE(phone," ", "") LIKE '%$phone%' LIMIT 1';
|
||
|
$q='SELECT members.id FROM members
|
||
|
JOIN users ON members.id=users.member_id
|
||
|
WHERE REPLACE(phone," ", "") LIKE '%$phone%' LIMIT 1';
|
||
|
*/
|
||
|
$query=self::$db->query($q);
|
||
|
return $query->current();
|
||
|
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* @param $phone - string containing a phone number
|
||
|
* @return first member_id of a member with given phone number
|
||
|
* This function is used in the Accounts_controller - e.g. in the function
|
||
|
* "store_transfer_ebanka" for finding the member who made a bank transaction where variable symbol = his phone number
|
||
|
* Similar function with different purpose can be found in get_member_by_phone
|
||
|
*/
|
||
|
public function find_member_id_by_phone($phone) {
|
||
|
$q="(SELECT member_id FROM users WHERE phone='$phone')
|
||
|
UNION
|
||
|
(SELECT users.member_id FROM 'contacts'
|
||
|
JOIN enum_types ON contacts.type=enum_types.id
|
||
|
AND enum_types.value='phone' AND contacts.value='$phone'
|
||
|
JOIN users ON users.id=contacts.user_id)
|
||
|
";
|
||
|
$query=self::$db->query($q);
|
||
|
return $query->current()->member_id;
|
||
|
|
||
|
|
||
|
}
|
||
|
|
||
|
}
|
||
|
|
||
|
?>
|
||
Také k dispozici: Unified diff
Nova funkce Member_Model::find_member_id_by_phone()