Projekt

Obecné

Profil

« Předchozí | Další » 

Revize c1bdc1c4

Přidáno uživatelem Michal Kliment před více než 9 roky(ů)

Release 1.1.0

Zobrazit rozdíly:

application/models/fee.php
* @param string $order_by_direction
* @return Mysql_Result object
*/
public function get_all_fees($order_by = 'from', $order_by_direction = 'asc')
public function get_all_fees($limit_from = 0, $limit_results = NULL,
$order_by = 'from', $order_by_direction = 'asc')
{
$limit = '';
// order by direction check
if (strtolower($order_by_direction) != 'desc')
{
$order_by_direction = 'asc';
}
if ($limit_results !== NULL &&
is_numeric($limit_results))
{
$limit = "LIMIT ". intval($limit_from) . ", " . intval($limit_results);
}
return $this->db->query("
SELECT fees.id, fees.readonly, fees.special_type_id, fees.type_id,
fees.fee, fees.from, fees.to, fees.name,
......
LEFT JOIN enum_types on enum_types.id = fees.type_id
LEFT JOIN translations on translations.original_term = enum_types.value
and translations.lang = ?
ORDER BY fees.readonly DESC, fees.special_type_id ASC, fees.from ASC
GROUP BY fees.id
ORDER BY fees.readonly DESC,
fees.special_type_id ASC, "
. $this->db->escape_column($order_by) . " $order_by_direction
$limit
", Config::get('lang'));
}
......
return 0;
}
/**
* Returns regular member fee name of member in date
*
* @author David Raška
* @param int $member_id
* @param string $date
* @return string|NULL
*/
public function get_regular_member_fee_name_by_member_date($member_id, $date)
{
$fee = $this->get_fee_by_member_date_type($member_id, $date, 'regular member fee');
if ($fee && $fee->id)
{
return $fee->name;
}
return NULL;
}
/**
* Gets transfer fee by date
*

Také k dispozici: Unified diff