Revize 301
Přidáno uživatelem Tomáš Dulík před více než 15 roky(ů)
| freenetis/trunk/kohana/application/models/fee.php | ||
|---|---|---|
|
order by `'.$order_by.'` '.$order_by_direction);
|
||
|
}
|
||
|
|
||
|
function check_overlaps($date_from = '0000-00-00', $date_to = '0000-00-00', $type_id = NULL,$fee_id = NULL)
|
||
|
/**
|
||
|
* @author Tomas Dulik
|
||
|
* Funkce vrací poplatek typu $type, který byl platný k datu $datetime
|
||
|
* @param $datetime datum a čas, SQL typ DATETIME
|
||
|
* @param $type - textový typ z tabulky enum_types, např. "transfer fee"
|
||
|
* @return object obsahující řádek tabulky fees
|
||
|
*/
|
||
|
function get_by_date_type($datetime, $type) {
|
||
|
$q="SELECT fees.*
|
||
|
FROM fees
|
||
|
JOIN enum_types ON fees.type_id = enum_types.id
|
||
|
AND enum_types.value = '$type'
|
||
|
AND fees.from<='$datetime'
|
||
|
AND fees.to>='$datetime'";
|
||
|
$query=self::$db->query($q);
|
||
|
return $query->current();
|
||
|
}
|
||
|
|
||
|
function check_overlaps($date_from = '0000-00-00', $date_to = '0000-00-00', $type_id = NULL, $fee_id = NULL)
|
||
|
{
|
||
|
$edit_clause = ($fee_id) ? " and id <> ".$fee_id : "";
|
||
|
|
||
Také k dispozici: Unified diff
Nova funkce Fees_Model::get_by_date_type(..)