Revize 404
Přidáno uživatelem Roman Ševčík před asi 15 roky(ů)
freenetis/trunk/kohana/application/models/voip_sip.php | ||
---|---|---|
<?php
|
||
class Voip_sip_Model extends ORM {
|
||
|
||
//protected $belongs_to = array('user');
|
||
|
||
/**
|
||
* Function counts all records.
|
||
* @return unknown_type
|
||
*/
|
||
public function count_all_records()
|
||
{
|
||
return self::$db->count_records('voip_sips');
|
||
}
|
||
|
||
|
||
/**
|
||
* Function gets one record.
|
||
* @param $id
|
||
* @return unknown_type
|
||
*/
|
||
public function get_record_limited($id)
|
||
{
|
||
return self::$db->query("SELECT
|
||
id,
|
||
name,
|
||
user_id
|
||
FROM voip_sips WHERE id=$id"
|
||
);
|
||
}
|
||
|
||
/**
|
||
* Function gets one record by user.
|
||
* @param $user_id
|
||
* @return unknown_type
|
||
*/
|
||
public function get_record_by_user_limited($user_id)
|
||
{
|
||
return self::$db->query("SELECT
|
||
id,
|
||
name,
|
||
user_id
|
||
FROM voip_sips WHERE user_id=$user_id"
|
||
);
|
||
}
|
||
|
||
/**
|
||
* Function gets one record by user.
|
||
* @param $user_id
|
||
* @return unknown_type
|
||
*/
|
||
public function get_record_by_user($user_id)
|
||
{
|
||
return self::$db->query("SELECT *
|
||
FROM voip_sips WHERE user_id=$user_id"
|
||
);
|
||
}
|
||
|
||
/**
|
||
* Function gets all records.
|
||
* @param $limit_from
|
||
* @param $limit_results
|
||
* @param $order_by
|
||
* @param $order_by_direction
|
||
* @return unknown_type
|
||
*/
|
||
public function get_all_records_limited($limit_from = 0, $limit_results = 20, $order_by = 'user_id', $order_by_direction = 'asc')
|
||
{
|
||
return self::$db->query("SELECT
|
||
id,
|
||
name,
|
||
user_id
|
||
FROM voip_sips
|
||
ORDER BY $order_by $order_by_direction
|
||
LIMIT $limit_from, $limit_results"
|
||
);
|
||
}
|
||
|
||
/**
|
||
* Function gets all records by member
|
||
* @param $id
|
||
* @return unknown_type
|
||
*/
|
||
public function get_all_record_by_member_limited($id)
|
||
{
|
||
return self::$db->query("SELECT
|
||
id,
|
||
name,
|
||
user_id
|
||
FROM voip_sips WHERE user_id IN (SELECT user_id FROM users WHERE member_id='.$id.') ORDER BY name"
|
||
);
|
||
}
|
||
|
||
}
|
||
?>
|
Také k dispozici: Unified diff
Rozpracovana verze integrace Voip, freenetis propojen s asteriskem a pridany zakladni operace. Zapomenuty soubor