/**
* @param $cId
* @param $salOnPage
* @return mixed
*/
function get_com_salary($cId, $salOnPage)
{
$salCity = encodeUrlParameter(@$_GET['city']);
$salJob = encodeUrlParameter(@$_GET['position']);
$page = @$_GET['page'];
if (strlen($salCity) > 30) {
die('Error city parameter');
}
if (isset($page) && (!is_numeric($page) || $page < 1 || $page == '')) {
die('Wrong page');
}
$ft = $this->countFromToPages($page, $salOnPage);
$from = $ft[0];
$to = $ft[1];
$this->db->select('*')->from('salary')->where('cId', $cId)->like('city', $salCity)->like('position', $salJob)->limit($to, $from)->order_by('addDate DESC, minSal DESC');
$a = $this->db->get()->result();
$this->db->select('COUNT(*)')->from('salary')->where('cId', $cId)->like('city', $salCity)->like('position', $salJob);
$a['salNum'] = $this->db->count_all_results();
return $a;
}
<link rel="stylesheet" href="/css/salary.css">
<link rel="stylesheet" href="/js/ionSlider/css/ion.rangeSlider.css">
<link rel="stylesheet" href="/js/ionSlider/css/ion.rangeSlider.skinModern.css">
<script src="/js/ionSlider/js/ion-rangeSlider/ion.rangeSlider.js"></script>
<script src="/js/filters.js"></script>
<?php
$salJob = encodeUrlParameter(@$_GET['position']);
$salCity = encodeUrlParameter(@$_GET['city']);
?>
<input type="hidden" id="this_page" value="<?php
echo $this_page;
?>
">
<div class="container">
<div class="row" style="height:70px;"> </div>
<div class="row">
<div class="filtersCnt">
<div class="input-group input-group-sm">
<label>должность <input class="form-control filFilTxt" id="filFilJob" type="text" value="<?php
echo isset($salJob) ? $salJob : '';
?>
"></label>
<label>город <input class="form-control filFilTxt" id="filFilCity" type="text" value="<?php
echo isset($salCity) ? $salCity : '';
?>
"></label><BR>
<input type="button" class="btn btn-sm btn-success" id="filBtn" value="найти" rcn="<?php
echo @$gets[0];
?>
">
