freenetis-github/application/models/variable_symbol.php @ c1bdc1c4
| 8baed187 | Michal Kliment | <?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;
|
|||
}
|
|||
| c1bdc1c4 | Michal Kliment | /**
|
|
* 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;
|
|||
}
|
|||
| 8baed187 | Michal Kliment | /**
|
|
* 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("
|
|||
| c1bdc1c4 | Michal Kliment | SELECT *
|
|
| 8baed187 | Michal Kliment | 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;
|
|||
}
|
|||
}
|