FreenetIS

var $_db_user = 'freenetis';

var $_db_password = 'bcac568614812719';

?>

public function get_all_members($limit_from = 0, $limit_results = 50, $order_by = 'devices.id', $order_by_direction = 'ASC', $filter_values = array())

//return self::$db->query('select m.id, m.registration, concat(u.surname,\' \',u.name) as name, ifnull(m.street,\'-\') as street,

// ifnull(m.street_number,\'-\') as street_number,ifnull(m.town,\'-\') as town from members m

// left join users u on m.id = u.member_id group by m.id order by name limit '.$min.','.$limit_results);

$where = '';

if(count($filter_values)>0) $where .= 'WHERE ';

foreach($filter_values as $key => $value)

{

if($key!='submit')

{

if($where!='WHERE ') $where .= ' AND ';

$where .= $key.' LIKE \'%'.$value.'%\' COLLATE utf8_general_ci';

}

}

return self::$db->query('select m.id, m.registration, m.name, m.street, m.street_number, m.town from members m '.$where.' order by '.$order_by.' '.$order_by_direction.' LIMIT '.$limit_from.','.$limit_results);

// $dotaz = $model_members

// -> like($filter->values())

// -> orderby($order_by, $order_by_direction)

// -> limit($limit_results, $sql_offset)

// -> find_all();

$dotaz = $model_members->get_all_members($sql_offset, (int)$limit_results, $order_by, $order_by_direction, $filter->values());