Projekt

Obecné

Profil

Stáhnout (2.61 KB) Statistiky
| Větev: | Tag: | Revize:
<?php defined('SYSPATH') or die('No direct script access.');
/*
* This file is part of open source system FreenetIS
* and it is release under GPLv3 licence.
*
* More info about licence can be found:
* http://www.gnu.org/licenses/gpl-3.0.html
*
* More info about project can be found:
* http://www.freenetis.org/
*
*/

/**
* Description of Variable_Symbol_Model
*
* @author David Raška
*
* @package Model
*
* @property integer $id
* @property integer $account_id
* @property string $variable_symbol
*/
class Variable_Symbol_Model extends ORM
{
protected $belongs_to = array('account');
/**
* Returns account variable symbols
*
* @param int $account_id
* @return Mysql_Result
*/
public function find_account_variable_symbols($account_id)
{
return $this->db->query("
SELECT vs.id,variable_symbol
FROM variable_symbols vs
LEFT JOIN accounts a ON a.id = vs.account_id
WHERE account_id = ?
", $account_id);
}
/**
* Returns account id of given variable_symbol
*
* @param int $variable_symbol
* @return Mysql_Result
*/
public function get_account_id($variable_symbol)
{
$query = $this->db->query("
SELECT account_id
FROM variable_symbols
WHERE variable_symbol = ?
", $variable_symbol);
if ($query->count() > 0)
{
$query = $query->current()->account_id;
}
return $query;
}
/**
* Returns member id of given variable_symbol
*
* @param int $variable_symbol
* @return null|int
*/
public function get_member_id($variable_symbol)
{
$query = $this->db->query("
SELECT a.member_id
FROM variable_symbols vs
JOIN accounts a ON a.id = vs.account_id
WHERE vs.variable_symbol = ?
", $variable_symbol);
if ($query->count() > 0)
{
return $query->current()->member_id;
}
return NULL;
}
/**
* Returns variable symbol id of given variable_symbol
*
* @param int $variable_symbol
* @return Mysql_Result
*/
public function get_variable_symbol_id($variable_symbol)
{
$query = $this->db->query("
SELECT *
FROM variable_symbols
WHERE variable_symbol = ?
", $variable_symbol);
if ($query->count() > 0)
{
return $query->current();
}
return NULL;
}
/**
* Checks if variable symbol is used
*
* @param int $vs_id
* @return Mysql_Result
*/
public function variable_symbol_used($id)
{
$query = $this->db->query("
SELECT bt.id
FROM variable_symbols vs
LEFT JOIN bank_transfers bt ON vs.variable_symbol = bt.variable_symbol
WHERE vs.id = ?
",$id);
if ($query->count() > 0)
{
return $query = $query->current()->id;
}
return NULL;
}
}
(96-96/101)