Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 404

Přidáno uživatelem Roman Ševčík před asi 15 roky(ů)

Rozpracovana verze integrace Voip, freenetis propojen s asteriskem a pridany zakladni operace. Zapomenuty soubor

Zobrazit rozdíly:

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