Revize 1074
Přidáno uživatelem Michal Kliment před asi 13 roky(ů)
freenetis/branches/device_templates/application/vendors/unit_tester/unit_testing_config.xml | ||
---|---|---|
</input>
|
||
</values>
|
||
</method>
|
||
<method name="actual_members_traffic" autogenerate="on">
|
||
<method name="actual_members_traffic" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="limit_results" default_value="100" />
|
||
<attribute name="order_by" default_value="" />
|
||
<attribute name="order_by_direction" default_value="DESC" />
|
||
<attribute name="page_word" default_value="" />
|
||
<attribute name="page" default_value="1" />
|
||
<attribute name="limit_results" default_value="100"/>
|
||
<attribute name="order_by" default_value=""/>
|
||
<attribute name="order_by_direction" default_value="DESC"/>
|
||
<attribute name="page_word" default_value=""/>
|
||
<attribute name="page" default_value="1"/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="100" />
|
||
<param value="" />
|
||
<param value="DESC" />
|
||
<param value="" />
|
||
<param value="1" />
|
||
<param value="100"/>
|
||
<param value="id"/>
|
||
<param value="DESC"/>
|
||
<param value=""/>
|
||
<param value="1"/>
|
||
</input>
|
||
</values>
|
||
</method>
|
||
... | ... | |
</input>
|
||
</values>
|
||
</method>
|
||
<method name="get_all_address_points" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="limit_from" default_value="0"/>
|
||
<attribute name="limit_results" default_value="50"/>
|
||
<attribute name="order_by" default_value="id"/>
|
||
<attribute name="order_by_direction" default_value="asc"/>
|
||
<attribute name="filter_values" default_value="array()"/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
</input>
|
||
<input>
|
||
<param value="0"/>
|
||
<param value="50"/>
|
||
<param value="id"/>
|
||
<param value="asc"/>
|
||
<param value="array('name'=>'a')"/>
|
||
</input>
|
||
<input>
|
||
<param value="s%%%%"/>
|
||
<param value="ščřč"/>
|
||
<param value="i"/>
|
||
<param value="acysc"/>
|
||
<param value="asef"/>
|
||
</input>
|
||
</values>
|
||
</method>
|
||
<method name="count_all_address_points" autogenerate="on">
|
||
<attributes></attributes>
|
||
<values>
|
||
... | ... | |
<input></input>
|
||
</values>
|
||
</method>
|
||
<method name="get_bank_accounts" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="limit_from" default_value="0"/>
|
||
<attribute name="limit_results" default_value="20"/>
|
||
<attribute name="order_by" default_value="id"/>
|
||
<attribute name="order_by_direction" default_value="asc"/>
|
||
<attribute name="filter_values" default_value="array()"/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
<param value=""/>
|
||
</input>
|
||
<input>
|
||
<param value="0"/>
|
||
<param value="20"/>
|
||
<param value="id"/>
|
||
<param value="desc"/>
|
||
<param value="array()"/>
|
||
</input>
|
||
<input>
|
||
<param value="0"/>
|
||
<param value="20"/>
|
||
<param value="idsef"/>
|
||
<param value="asc"/>
|
||
<param value="array('name'=>'a')"/>
|
||
</input>
|
||
</values>
|
||
</method>
|
||
<method name="count_bank_accounts" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="filter_values" default_value="array()"/>
|
||
... | ... | |
</input>
|
||
</values>
|
||
</method>
|
||
<method name="get_member_traffics" autogenerate="on">
|
||
<attributes>
|
||
<attribute name="member_id" default_value="" />
|
||
<attribute name="type" default_value="" />
|
||
<attribute name="limit_from" default_value="0" />
|
||
<attribute name="limit_results" default_value="50" />
|
||
<attribute name="order_by" default_value="" />
|
||
<attribute name="order_by_direction" default_value="ASC" />
|
||
<attribute name="filter_sql" default_value="" />
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="" />
|
||
<param value="" />
|
||
<param value="0" />
|
||
<param value="50" />
|
||
<param value="" />
|
||
<param value="ASC" />
|
||
<param value="" />
|
||
</input>
|
||
</values>
|
||
</method>
|
||
<method name="count_member_traffics" autogenerate="on">
|
||
<attributes>
|
||
<attribute name="member_id" default_value="" />
|
||
... | ... | |
<values>
|
||
</values>
|
||
</method>
|
||
<method name="phone_invoice_user_state" autogenerate="on">
|
||
<method name="phone_invoice_user_state" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="item" default_value="" />
|
||
<attribute name="name" default_value="" />
|
||
<attribute name="item" default_value=""/>
|
||
<attribute name="name" default_value=""/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="" />
|
||
<param value="" />
|
||
</input>
|
||
</values>
|
||
</method>
|
||
<method name="phone_invoice_user_state2" autogenerate="on">
|
||
<method name="phone_invoice_user_state2" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="item" default_value="" />
|
||
<attribute name="name" default_value="" />
|
||
<attribute name="item" default_value=""/>
|
||
<attribute name="name" default_value=""/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="" />
|
||
<param value="" />
|
||
</input>
|
||
</values>
|
||
</method>
|
||
<method name="phone_period_field" autogenerate="off">
|
||
... | ... | |
<values>
|
||
</values>
|
||
</method>
|
||
<method name="week_field" autogenerate="on">
|
||
<method name="week_field" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="item" default_value="" />
|
||
<attribute name="name" default_value="" />
|
||
<attribute name="item" default_value=""/>
|
||
<attribute name="name" default_value=""/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="" />
|
||
<param value="" />
|
||
</input>
|
||
</values>
|
||
</method>
|
||
<method name="month_field" autogenerate="on">
|
||
<method name="month_field" autogenerate="off">
|
||
<attributes>
|
||
<attribute name="item" default_value="" />
|
||
<attribute name="name" default_value="" />
|
||
<attribute name="item" default_value=""/>
|
||
<attribute name="name" default_value=""/>
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="" />
|
||
<param value="" />
|
||
</input>
|
||
</values>
|
||
</method>
|
||
</helper>
|
||
</method></helper>
|
||
<helper name="cookie">
|
||
<method name="set" autogenerate="on">
|
||
<attributes>
|
||
... | ... | |
</input>
|
||
</values>
|
||
</method>
|
||
<method name="start_of_week" autogenerate="on">
|
||
<attributes>
|
||
<attribute name="week" default_value="" />
|
||
<attribute name="year" default_value="" />
|
||
<attribute name="format" default_value="Y-m-d" />
|
||
</attributes>
|
||
<values>
|
||
<input>
|
||
<param value="" />
|
||
<param value="" />
|
||
<param value="Y-m-d" />
|
||
</input>
|
||
</values>
|
||
</method>
|
||
</helper>
|
||
<helper name="db">
|
||
<method name="test" autogenerate="on">
|
freenetis/branches/device_templates/application/helpers/date.php | ||
---|---|---|
* @copyright (c) 2007-2008 Kohana Team
|
||
* @license http://kohanaphp.com/license.html
|
||
*/
|
||
class date_Core {
|
||
class date_Core
|
||
{
|
||
|
||
public static $months = array(1 => 'January', 2 => 'February', 3 => 'March', 4 => 'April', 5 => 'May', 6 => 'June', 7 => 'July', 8 => 'August', 9 => 'September', 10 => 'October', 11 => 'November', 12 => 'December');
|
||
public static $months = array
|
||
(
|
||
1 => 'January',
|
||
2 => 'February',
|
||
3 => 'March',
|
||
4 => 'April',
|
||
5 => 'May',
|
||
6 => 'June',
|
||
7 => 'July',
|
||
8 => 'August',
|
||
9 => 'September',
|
||
10 => 'October',
|
||
11 => 'November',
|
||
12 => 'December'
|
||
);
|
||
|
||
/**
|
||
* Converts a UNIX timestamp to DOS format.
|
||
... | ... | |
* @param type $format
|
||
* @return type
|
||
*/
|
||
public function start_of_week ($week, $year = NULL, $format = 'Y-m-d')
|
||
public static function start_of_week ($week, $year = NULL, $format = 'Y-m-d')
|
||
{
|
||
if (!$year)
|
||
$year = date("Y");
|
freenetis/branches/device_templates/application/models/subnet.php | ||
---|---|---|
$key = 's.name';
|
||
else if ($key == 'id')
|
||
$key = 's.id';
|
||
else if (!$this->has_column($key))
|
||
continue;
|
||
|
||
if ($where == '')
|
||
$where = 'WHERE '.$key.' LIKE '.$this->db->escape("%$value%")
|
||
$where = 'WHERE ' . $this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
else
|
||
$where .= ' AND '.$key.' LIKE '.$this->db->escape("%$value%")
|
||
$where .= ' AND ' . $this->db->escape_column($key)
|
||
. ' LIKE '.$this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
||
... | ... | |
LEFT JOIN subnets_owners so ON s.id = so.subnet_id
|
||
LEFT JOIN members m ON so.member_id = m.id
|
||
$where
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT ".intval($limit_from) . "," . intval($limit_results) . "
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/iface.php | ||
---|---|---|
$order_by_direction = 'asc', $filter_values = array())
|
||
{
|
||
$where = '';
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
// filter
|
||
if (is_array($filter_values))
|
||
if (is_array($filter_values) && array_key_exists('mac', $filter_values))
|
||
{
|
||
if (array_key_exists('mac', $filter_values))
|
||
{
|
||
$where = "WHERE mac LIKE " . $this->db->escape("%".trim($filter_values['mac'])."%'");
|
||
}
|
||
$where = "WHERE mac LIKE " . $this->db->escape("%".trim($filter_values['mac'])."%'");
|
||
}
|
||
// query
|
||
return $this->db->query("
|
||
... | ... | |
JOIN devices d ON d.id = i.device_id
|
||
LEFT JOIN segments s ON s.id = i.segment_id
|
||
$where
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/invoice_item.php | ||
---|---|---|
public function get_all_invoices($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
... | ... | |
date_inv, date_due, date_vat, vat, order_nr, currency
|
||
FROM invoices i
|
||
LEFT JOIN members m ON i.supplier_id = m.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
");
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/messages_ip_addresses.php | ||
---|---|---|
", $ip_address_id);
|
||
}
|
||
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/ip_addresses_traffic.php | ||
---|---|---|
public function get_all_ip_addresses_traffics($sql_offset = 0, $limit_results = 100,
|
||
$order_by = 'total', $order_by_direction = 'DESC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'total';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
m.id AS member_id, m.name AS member_name
|
||
FROM ip_addresses_traffics t
|
||
LEFT JOIN members m ON t.member_id = m.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/ip_address.php | ||
---|---|---|
}
|
||
|
||
if ($where == '')
|
||
$where = 'WHERE '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where = 'WHERE '.$this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
else
|
||
$where .= ' AND '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= ' AND '.$this->db->escape_column($key)
|
||
.' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
||
... | ... | |
continue;
|
||
}
|
||
|
||
if($key!='submit')
|
||
if($key != 'submit')
|
||
{
|
||
if ($where == '')
|
||
$where = 'WHERE '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where = 'WHERE '.$this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
else
|
||
$where .= ' AND '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= ' AND '.$this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/user.php | ||
---|---|---|
);
|
||
protected $has_and_belongs_to_many = array('users_contacts' => 'contacts');
|
||
|
||
public $arr_sql = array
|
||
public static $arr_sql = array
|
||
(
|
||
'id' => 'u.id',
|
||
'name' => 'u.name',
|
||
... | ... | |
if ($member_id)
|
||
$where .= ($where != '') ? ' AND member_id = '.intval($member_id) :
|
||
'WHERE member_id = '.intval($member_id);
|
||
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
|
||
if (!array_key_exists($order_by, self::$arr_sql))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
else
|
||
{
|
||
$order_by = self::$arr_sql[$order_by];
|
||
}
|
||
|
||
return $this->db->query("
|
||
SELECT * FROM
|
||
... | ... | |
) AS u
|
||
$where
|
||
GROUP BY u.id
|
||
ORDER BY '.$order_by.' '.$order_by_direction.'
|
||
ORDER BY $order_by $order_by_direction
|
||
LIMIT " . intval($limit_from) . "," . intval($limit_results) . "
|
||
", array
|
||
(
|
||
... | ... | |
$where .= 'WHERE '.$filter_sql;
|
||
|
||
if ($member_id)
|
||
$where .= ($where != '') ? ' AND member_id = '.intval ($member_id) :
|
||
'WHERE member_id = '.intval ($member_id);
|
||
$where .= ($where != '') ? ' AND member_id = '.intval($member_id) :
|
||
'WHERE member_id = '.intval($member_id);
|
||
|
||
return $this->db->query("
|
||
SELECT COUNT(*) AS total FROM
|
freenetis/branches/device_templates/application/models/bank_transfer.php | ||
---|---|---|
{
|
||
foreach($filter_values as $key => $value)
|
||
{
|
||
if ($key != 'submit' && $this->has_column($key))
|
||
if ($key != 'submit')
|
||
{
|
||
if ($key == 'name')
|
||
{
|
||
... | ... | |
|
||
if ($where == '')
|
||
{
|
||
$where .= 'WHERE '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= 'WHERE ' . $this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
else
|
||
{
|
||
$where .= ' AND '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= ' AND ' . $this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
||
... | ... | |
{
|
||
foreach($filter_values as $key => $value)
|
||
{
|
||
if ($key != 'submit' && $this->has_column($key))
|
||
if ($key != 'submit')
|
||
{
|
||
if ($key == 'name')
|
||
{
|
||
... | ... | |
|
||
if ($where == '')
|
||
{
|
||
$where .= 'WHERE '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= 'WHERE ' . $this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
else
|
||
{
|
||
$where .= ' AND '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= ' AND ' . $this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/approval_template.php | ||
---|---|---|
public function get_all_approval_templates($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
freenetis/branches/device_templates/application/models/message.php | ||
---|---|---|
{
|
||
$order_by = 'inet_aton(ip_address)';
|
||
}
|
||
else if (!$this->has_column($order_by))
|
||
else
|
||
{
|
||
$order_by = 'ip_address';
|
||
$order_by = $this->db->escape_column($order_by);
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
... | ... | |
}
|
||
|
||
}
|
||
?>
|
freenetis/branches/device_templates/application/models/bank_account.php | ||
---|---|---|
* It gets all bank accounts except bank accounts of association.
|
||
* @return unknown_type
|
||
*/
|
||
public function get_bank_accounts($limit_from = 0, $limit_results = 20, $order_by = 'id', $order_by_direction = 'asc', $filter_values = array())
|
||
public function get_bank_accounts($limit_from = 0, $limit_results = 20,
|
||
$order_by = 'id', $order_by_direction = 'asc', $filter_values = array())
|
||
{
|
||
$where = '';
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
{
|
||
foreach($filter_values as $key => $value)
|
||
{
|
||
if($key != 'submit' && $this->has_column($key))
|
||
if($key != 'submit')
|
||
{
|
||
if ($key == 'name')
|
||
{
|
||
$key = 'ba.name';
|
||
}
|
||
$where .= ' AND '.$key.' LIKE ' . $this->db->escape("%$value%")
|
||
$where .= ' AND '.$this->db->escape_column($key).' LIKE '
|
||
. $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
||
... | ... | |
{
|
||
foreach($filter_values as $key => $value)
|
||
{
|
||
if($key != 'submit' && $this->has_column($key))
|
||
if($key != 'submit')
|
||
{
|
||
if ($key == 'name')
|
||
$key = 'ba.name';
|
||
$where .= ' AND '.$key.' LIKE ' . $this->db->escape("%$value%") . ' COLLATE utf8_general_ci';
|
||
$where .= ' AND '.$this->db->escape_column($key)
|
||
. ' LIKE ' . $this->db->escape("%$value%")
|
||
. ' COLLATE utf8_general_ci';
|
||
}
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/voip_sip.php | ||
---|---|---|
public function get_all_records($limit_from = 0, $limit_results = 20,
|
||
$order_by = 'name', $order_by_direction = 'asc')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
... | ... | |
FROM voip_sips
|
||
INNER JOIN users ON voip_sips.user_id = users.id
|
||
INNER JOIN members ON users.member_id = members.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) ."
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/members_traffic.php | ||
---|---|---|
public function get_all_members_traffics($sql_offset = 0, $limit_results = 100,
|
||
$order_by = 'total', $order_by_direction = 'DESC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
t.active, m.id AS member_id, m.name AS member_name
|
||
FROM members_traffics t
|
||
LEFT JOIN members m ON t.member_id = m.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($sql_offset) . ", " . intval($limit_results) . "
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/members_traffics_daily.php | ||
---|---|---|
$sql_offset = 0, $limit_results = 100, $order_by = 'total',
|
||
$order_by_direction = 'DESC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'total';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
return $this->db->query("
|
||
SELECT q.*, m.name AS member_name FROM
|
||
(
|
||
SELECT member_id, SUM(upload) AS upload, SUM(download) AS download, SUM(upload) + SUM(download) AS total
|
||
SELECT member_id, SUM(upload) AS upload, SUM(download) AS download,
|
||
SUM(upload) + SUM(download) AS total
|
||
FROM members_traffics_daily d
|
||
WHERE day BETWEEN ? AND ?
|
||
GROUP BY member_id
|
||
) q
|
||
LEFT JOIN members m ON q.member_id = m.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($sql_offset) . ", " . intval($limit_results) . "
|
||
", $date_from, $date_to);
|
||
}
|
||
... | ... | |
/**
|
||
* Returns all traffics of member
|
||
*
|
||
* !!!!!! SECURITY WARNING !!!!!!
|
||
* Be careful when you using this method, param $filter_sql is unprotected
|
||
* for SQL injections, security should be made at controller site using
|
||
* Filter_form class.
|
||
* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
|
||
*
|
||
* @author Michal Kliment
|
||
* @param type $member_id
|
||
* @param type $type
|
||
... | ... | |
* @param type $filter_sql
|
||
* @return type
|
||
*/
|
||
public function get_member_traffics ($member_id, $type, $limit_from = 0, $limit_results = 50, $order_by = NULL, $order_by_direction = 'ASC', $filter_sql = '')
|
||
public function get_member_traffics ($member_id, $type, $limit_from = 0, $limit_results = 50,
|
||
$order_by = NULL, $order_by_direction = 'ASC', $filter_sql = '')
|
||
{
|
||
switch ($type)
|
||
{
|
||
... | ... | |
break;
|
||
}
|
||
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
|
||
$where = '';
|
||
if ($filter_sql != '')
|
||
$where .= 'WHERE '.$filter_sql;
|
||
|
||
$limit = '';
|
||
if ($limit_results > 0)
|
||
$limit = "LIMIT $limit_from, $limit_results";
|
||
$limit = "LIMIT " . intval($limit_from) . ", " . intval($limit_results);
|
||
|
||
$order = '';
|
||
if ($order_by != '')
|
||
$order = "ORDER BY $order_by $order_by_direction";
|
||
$order = "ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction";
|
||
|
||
return $this->db->query("
|
||
SELECT * FROM
|
||
... | ... | |
/**
|
||
* Counts all traffics of member
|
||
*
|
||
* !!!!!! SECURITY WARNING !!!!!!
|
||
* Be careful when you using this method, param $filter_sql is unprotected
|
||
* for SQL injections, security should be made at controller site using
|
||
* Filter_form class.
|
||
* !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
|
||
*
|
||
* @author Michal Kliment
|
||
* @param type $member_id
|
||
* @param type $type
|
freenetis/branches/device_templates/application/models/address_point.php | ||
---|---|---|
* @param $filter_values
|
||
* @return ORM iterator
|
||
*/
|
||
public function get_all_address_points($limit_from = 0, $limit_results = 50, $order_by = 'id', $order_by_direction = 'asc', $filter_values = array())
|
||
public function get_all_address_points($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'asc', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
t.zip_code,
|
||
CONCAT(X(ap.gps), ' ', Y(ap.gps)) AS gps,
|
||
c.country_name,
|
||
(SELECT count(id) AS member_count FROM members m WHERE address_point_id = ap.id) +
|
||
(SELECT count(id) AS device_count FROM devices d WHERE address_point_id = ap.id) +
|
||
(SELECT COUNT(id) AS members_domicile_count FROM members_domiciles WHERE address_point_id = ap.id) AS items_count
|
||
(
|
||
SELECT count(id) AS member_count
|
||
FROM members m
|
||
WHERE address_point_id = ap.id
|
||
) +
|
||
(
|
||
SELECT count(id) AS device_count
|
||
FROM devices d
|
||
WHERE address_point_id = ap.id
|
||
) +
|
||
(
|
||
SELECT COUNT(id) AS members_domicile_count
|
||
FROM members_domiciles
|
||
WHERE address_point_id = ap.id
|
||
) AS items_count
|
||
FROM address_points ap
|
||
LEFT JOIN countries c ON ap.country_id = c.id
|
||
LEFT JOIN streets s ON ap.street_id = s.id
|
freenetis/branches/device_templates/application/models/bank_statement.php | ||
---|---|---|
$ba_id = null, $limit_from = 0, $limit_results = 20, $order_by = 'id',
|
||
$order_by_direction = 'DESC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
freenetis/branches/device_templates/application/models/street.php | ||
---|---|---|
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
freenetis/branches/device_templates/application/models/allowed_subnet.php | ||
---|---|---|
*/
|
||
public function get_all_allowed_subnets_by_member($member_id, $order_by = 'id', $order_by_direction = 'ASC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
freenetis/branches/device_templates/application/models/member.php | ||
---|---|---|
const TYPE_NON = 5;
|
||
const TYPE_FORMER = 15;
|
||
|
||
private static $keys = array
|
||
(
|
||
'id' => array('type' => 'number', 'column_name' => 'm.id'),
|
||
'town' => array('type' => 'string'),
|
||
'street' => array('type' => 'string'),
|
||
'name' => array('type' => 'string', 'column_name' => 'm.name'),
|
||
'variable_symbol' => array('type' => 'string'),
|
||
'comment' => array('type' => 'string', 'column_name' => 'm.comment'),
|
||
'street_number' => array('type' => 'number')
|
||
);
|
||
|
||
/**
|
||
* Function gets list of all members from database.
|
||
*
|
||
... | ... | |
if ($filter_sql != '')
|
||
$where = "WHERE $filter_sql";
|
||
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
return $this->db->query("
|
||
SELECT id, id AS member_id, registration, name, street, street_number,
|
||
town, quarter, variable_symbol, aid, balance, redirect,
|
||
GROUP_CONCAT(a_comment SEPARATOR ', \n\n') AS a_comment, a_comments_thread_id, type, entrance_date, leaving_date
|
||
GROUP_CONCAT(a_comment SEPARATOR ', \n\n') AS a_comment,
|
||
a_comments_thread_id, type, entrance_date, leaving_date
|
||
FROM
|
||
(
|
||
SELECT
|
||
... | ... | |
ORDER BY c.datetime DESC
|
||
) AS q
|
||
GROUP BY id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . $limit_results . "
|
||
", array
|
||
(
|
freenetis/branches/device_templates/application/models/membership_interrupt.php | ||
---|---|---|
{
|
||
$where = ($filter_sql != '') ? 'WHERE ' . $filter_sql : '';
|
||
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
JOIN members m ON mi.member_id = m.id
|
||
JOIN members_fees mf ON mi.members_fee_id = mf.id
|
||
$where
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT ".intval($limit_from) . ", " . intval($limit_results) . "
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/job.php | ||
---|---|---|
public function get_all_pending_works($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
LEFT JOIN users u ON j.user_id = u.id
|
||
LEFT JOIN votes v ON j.id = v.fk_id AND v.type =1 AND v.user_id = ?
|
||
WHERE j.state <= 1 AND j.job_report_id IS NULL) AS q
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
", array
|
||
(
|
||
... | ... | |
public function get_all_rejected_works($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
FROM jobs j
|
||
LEFT JOIN users u ON j.user_id = u.id
|
||
WHERE j.state = 2 AND j.job_report_id IS NULL) AS q
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
", array
|
||
(
|
||
... | ... | |
public function get_all_approved_works($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
LEFT JOIN users u ON j.user_id = u.id
|
||
LEFT JOIN transfers t ON j.transfer_id = t.id
|
||
WHERE j.state = 3 AND j.job_report_id IS NULL) AS q
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
", array
|
||
(
|
freenetis/branches/device_templates/application/models/invoice.php | ||
---|---|---|
public function get_all_invoices($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
... | ... | |
date_inv, date_due, date_vat, vat, order_nr, currency
|
||
FROM invoices i
|
||
LEFT JOIN members m ON i.supplier_id = m.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
");
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/account.php | ||
---|---|---|
$order_by_direction = 'asc', $filter_values = array(), $group = 4)
|
||
{
|
||
$where = 'WHERE ';
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
. ' AND account_attribute_id <> '.Account_attribute_Model::$credit;
|
||
}
|
||
// filter
|
||
if (is_array($filter_values))
|
||
if (is_array($filter_values) && array_key_exists('name', $filter_values))
|
||
{
|
||
foreach ($filter_values as $key => $value)
|
||
{
|
||
if ($key == 'name')
|
||
{
|
||
$where .= " AND a.name LIKE ".$this->db->escape("%$value%")." COLLATE utf8_general_ci";
|
||
}
|
||
}
|
||
$where .= " AND a.name LIKE ".$this->db->escape("%" . $filter_values['name'] . "%")
|
||
. " COLLATE utf8_general_ci";
|
||
}
|
||
// get count
|
||
return $this->db->query("
|
||
... | ... | |
/**
|
||
* Recalculates all account balances.
|
||
*
|
||
* @todo EXPLAIN CREATING NEW DATABASE
|
||
* @author Jiri Svitak
|
||
* @return array[integer]
|
||
*/
|
freenetis/branches/device_templates/application/models/segment.php | ||
---|---|---|
WHERE lang = ?
|
||
) f ON e.value = f.original_term
|
||
$where
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " .intval($limit_from) . ", " . intval($limit_results) . "
|
||
", Config::get('lang'));
|
||
}
|
freenetis/branches/device_templates/application/models/job_report.php | ||
---|---|---|
public function get_all_pending_work_reports($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
LEFT JOIN users u ON j.user_id = u.id
|
||
GROUP BY r.id
|
||
HAVING state < 2
|
||
ORDER BY ' . $order_by . ' ' . $order_by_direction . '
|
||
ORDER BY ' . $this->db->escape_column($order_by) . ' ' . $order_by_direction . '
|
||
LIMIT ' . intval($limit_from) . ', ' . intval($limit_results) . '
|
||
');
|
||
}
|
||
... | ... | |
public function get_all_approved_work_reports($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
LEFT JOIN users u ON j.user_id = u.id
|
||
GROUP BY r.id
|
||
HAVING state = 3
|
||
ORDER BY ' . $order_by . ' ' . $order_by_direction . '
|
||
ORDER BY ' . $this->db->escape_column($order_by) . ' ' . $order_by_direction . '
|
||
LIMIT ' . intval($limit_from) . ', ' . intval($limit_results) . '
|
||
');
|
||
}
|
||
... | ... | |
public function get_all_rejected_work_reports($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'id', $order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
LEFT JOIN users u ON j.user_id = u.id
|
||
GROUP BY r.id
|
||
HAVING state = 2
|
||
ORDER BY ' . $order_by . ' ' . $order_by_direction . '
|
||
ORDER BY ' . $this->db->escape_column($order_by) . ' ' . $order_by_direction . '
|
||
LIMIT ' . intval($limit_from) . ', ' . intval($limit_results) . '
|
||
');
|
||
}
|
||
... | ... | |
$limit_from = 0, $limit_results = 50, $order_by = 'id',
|
||
$order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
// query
|
||
$work_reports = $this->db->query('
|
||
SELECT r.id, j.user_id, CONCAT(u.name, \' \', u.surname) as uname,
|
||
r.description, SUM(j.suggest_amount) AS suggest_amount,
|
||
... | ... | |
LEFT JOIN users u ON j.user_id = u.id
|
||
GROUP BY r.id
|
||
HAVING state = 3
|
||
ORDER BY ' . $order_by . ' ' . $order_by_direction . '
|
||
ORDER BY ' . $this->db->escape_column($order_by) . ' ' . $order_by_direction . '
|
||
LIMIT ' . intval($limit_from) . ', ' . intval($limit_results) . '
|
||
');
|
||
|
||
... | ... | |
$limit_from = 0, $limit_results = 50, $order_by = 'id',
|
||
$order_by_direction = 'ASC', $filter_values = array())
|
||
{
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
||
// query
|
||
$work_reports = $this->db->query('
|
||
SELECT r.id, j.user_id, CONCAT(u.name, \' \', u.surname) as uname,
|
||
r.description, SUM(j.suggest_amount) AS suggest_amount,
|
||
... | ... | |
LEFT JOIN jobs j ON r.id = j.job_report_id
|
||
LEFT JOIN users u ON j.user_id = u.id
|
||
GROUP BY r.id
|
||
ORDER BY ' . $order_by . ' ' . $order_by_direction . '
|
||
ORDER BY ' . $this->db->escape_column($order_by) . ' ' . $order_by_direction . '
|
||
LIMIT ' . intval($limit_from) . ', ' . intval($limit_results) . '
|
||
');
|
||
|
freenetis/branches/device_templates/application/models/private_users_contact.php | ||
---|---|---|
return 0;
|
||
}
|
||
|
||
}
|
||
}
|
freenetis/branches/device_templates/application/models/account_attribute.php | ||
---|---|---|
$datetime_to_t1 = " AND t1.datetime <= '9999-12-31'";
|
||
$datetime_from_t2 = " AND t2.datetime >= '0000-00-00'";
|
||
$datetime_to_t2 = " AND t2.datetime <= '9999-12-31'";
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
freenetis/branches/device_templates/application/models/port.php | ||
---|---|---|
public function get_all_ports($limit_from = 0, $limit_results = 50,
|
||
$order_by = 'ports.id', $order_by_direction = 'ASC')
|
||
{
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
... | ... | |
FROM ports_vlans
|
||
GROUP BY port_id
|
||
) ports_vlans ON ports_vlans.port_id=ports.id
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT " . intval($limit_from) . ", " . intval($limit_results) . "
|
||
");
|
||
}
|
freenetis/branches/device_templates/application/models/transfer.php | ||
---|---|---|
$order_by = 'id', $order_by_direction = 'desc', $filter_values = array())
|
||
{
|
||
$where = '';
|
||
// order by check
|
||
if (!$this->has_column($order_by))
|
||
{
|
||
$order_by = 'id';
|
||
}
|
||
// order by direction check
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
... | ... | |
LEFT JOIN accounts oa ON oa.id = t.origin_id
|
||
LEFT JOIN accounts da ON da.id = t.destination_id
|
||
$where
|
||
ORDER BY $order_by $order_by_direction
|
||
ORDER BY " . $this->db->escape_column($order_by) . " $order_by_direction
|
||
LIMIT ".intval($limit_from).", ".intval($limit_results)."
|
||
");
|
||
}
|
||
... | ... | |
{
|
||
$order_by = 'IF(t.destination_id = '.$account_id.', t.amount, -t.amount)';
|
||
}
|
||
else if (!$this->has_column($order_by))
|
||
else
|
||
{
|
||
$order_by = 'id';
|
||
$order_by = $this->db->escape_column($order_by);
|
||
}
|
||
// order by direction check
|
||
$order_by_direction = strtolower($order_by_direction);
|
||
if ($order_by_direction != 'desc')
|
||
if (strtolower($order_by_direction) != 'desc')
|
||
{
|
||
$order_by_direction = 'asc';
|
||
}
|
freenetis/branches/device_templates/application/controllers/bank_transfers.php | ||
---|---|---|
if (is_numeric($this->input->get('record_per_page')))
|
||
$limit_results = (int) $this->input->get('record_per_page');
|
||
// parameters control
|
||
$allowed_order_type = array('id', 'datetime', 'amount');
|
||
$allowed_order_type = array('id', 'datetime', 'amount', 'account_nr', 'bank_nr', 'name', 'variable_symbol');
|
||
if (!in_array(strtolower($order_by),$allowed_order_type))
|
||
$order_by = 'id';
|
||
if (strtolower($order_by_direction) != 'asc' && strtolower($order_by_direction) != 'desc')
|
Také k dispozici: Unified diff
Merge zmen z testingu do vetve se sablonami zarizeni.