Projekt

Obecné

Profil

« Předchozí | Další » 

Revize 1074

Přidáno uživatelem Michal Kliment před asi 13 roky(ů)

Merge zmen z testingu do vetve se sablonami zarizeni.

Zobrazit rozdíly:

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'=&gt;'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'=&gt;'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