_query = $query;
$this->db = $db;
$stmt = $this->db->query( $this->_query );
$this->_total = $stmt->rowCount();
}
public function getData( $limit = 10, $page = 1, $links = 7, $className = null) {
$this->_limit = $limit;
$this->_page = $page;
$this->_links = $links;
if ( $this->_limit == 'all' ) {
$query = $this->_query;
} else {
$query = $this->_query . " LIMIT " . ( ( $this->_page - 1 ) * $this->_limit ) . ", $this->_limit";
}
$stmt = $this->db->query( $query );
$results = [];
while($row = $stmt->fetch()) {
$results[] = new $className($row);
}
$result = new stdClass();
$result->page = $this->_page;
$result->limit = $this->_limit;
$result->total = $this->_total;
$result->data = $results;
return $result;
}
public function createLinks ($path,$url) {
if( $url != '' ){
parse_str($url, $query_params);
$url = '';
if( isset($query_params['category']) ){
$url .= 'category='.$query_params['category'].'&';
}
if( isset($query_params['keyword']) ){
$url .= 'keyword='.$query_params['keyword'].'&';
}
if( isset($query_params['company']) ){
$url .= 'company='.$query_params['company'].'&';
}
}
if ( $this->_limit == 'all' || $this->_total == 0) {
return '';
}
$last = ceil( $this->_total / $this->_limit );
$start = ( ( $this->_page - $this->_links ) > 0 ) ? $this->_page - $this->_links : 1;
$end = ( ( $this->_page + $this->_links ) < $last ) ? $this->_page + $this->_links : $last;
$html = '';
$opt = '';
foreach(array(3,5,10,15,20,30,50)as$pagesize){
$opt.='';
}
$html .= ' 每頁顯示 筆職缺';
$html .= '
';
/*$(".selectPagesize").change(function(){
var h=location.href;
h=h.replace(/[&\?]limit=[0-9]+/, '');
h+=(h.indexOf('?')>=0 ? '&' : '?') + 'limit=' + $(this).val();
location.href = h;
});*/
/*
$html.=<<
$(".selectPagesize").change(function(){
location.href = '?limit='+$(this).val();
});
EOF;
# 'http://domain.com/?limit=1&a=b&c=d'.replace(/[\&\?]limit=[0-9]+/, '')
# 'http://domain.com/?x=x&limit=1&a=b&c=d'.replace(/[\&\?]limit=[0-9]+/, '')
*/
return $html;
}
}