本文整理匯總了PHP中Model_Ad::select方法的典型用法代碼示例。如果您正苦於以下問題:PHP Model_Ad::select方法的具體用法?PHP Model_Ad::select怎麽用?PHP Model_Ad::select使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類Model_Ad
的用法示例。
在下文中一共展示了Model_Ad::select方法的4個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: action_get
public function action_get()
{
try {
if (is_numeric($id_ad = $this->request->param('id'))) {
$ad = new Model_Ad();
//get distance to the ad
if (isset($this->_params['latitude']) and isset($this->_params['longitude'])) {
$ad->select(array(DB::expr('degrees(acos(sin(radians(' . $this->_params['latitude'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $this->_params['latitude'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $this->_params['longitude'] . ' - `longitude`))))) * 69.172'), 'distance'));
}
$ad->where('id_ad', '=', $id_ad)->where('status', '=', Model_Ad::STATUS_PUBLISHED)->cached()->find();
if ($ad->loaded()) {
$a = $ad->as_array();
$a['price'] = i18n::money_format($ad->price);
$a['images'] = array_values($ad->get_images());
$a['category'] = $ad->category->as_array();
$a['location'] = $ad->location->as_array();
$a['user'] = Controller_Api_Users::get_user_array($ad->user);
$a['customfields'] = Model_Field::get_by_category($ad->id_category);
//sorting by distance, lets add it!
if (isset($ad->distance)) {
$a['distance'] = i18n::format_measurement($ad->distance);
}
$a['url'] = Route::url('ad', array('category' => $ad->category->seoname, 'seotitle' => $ad->seotitle));
$this->rest_output(array('ad' => $a));
} else {
$this->_error(__('Advertisement not found'), 404);
}
} else {
$this->_error(__('Advertisement not found'), 404);
}
} catch (Kohana_HTTP_Exception $khe) {
$this->_error($khe);
return;
}
}
示例2: action_info
public function action_info()
{
//try to get the info from the cache
$info = Core::cache('action_info', NULL);
//not cached :(
if ($info === NULL) {
$ads = new Model_Ad();
$total_ads = $ads->count_all();
$last_ad = $ads->select('published')->order_by('published', 'desc')->limit(1)->find();
$last_ad = $last_ad->published;
$ads = new Model_Ad();
$first_ad = $ads->select('published')->order_by('published', 'asc')->limit(1)->find();
$first_ad = $first_ad->published;
$views = new Model_Visit();
$total_views = $views->count_all();
$users = new Model_User();
$total_users = $users->count_all();
$info = array('site_url' => Core::config('general.base_url'), 'site_name' => Core::config('general.site_name'), 'site_description' => Core::config('general.site_description'), 'created' => $first_ad, 'updated' => $last_ad, 'email' => Core::config('email.notify_email'), 'version' => Core::VERSION, 'theme' => Core::config('appearance.theme'), 'theme_mobile' => Core::config('appearance.theme_mobile'), 'charset' => Kohana::$charset, 'timezone' => Core::config('i18n.timezone'), 'locale' => Core::config('i18n.locale'), 'currency' => '', 'ads' => $total_ads, 'views' => $total_views, 'users' => $total_users);
Core::cache('action_info', $info);
}
$this->response->headers('Content-type', 'application/javascript');
$this->response->body(json_encode($info));
}
示例3: list_logic
/**
* gets data to the view and filters the ads
* @param Model_Category $category
* @param Model_Location $location
* @return array
*/
public function list_logic($category = NULL, $location = NULL)
{
//user recognition
$user = Auth::instance()->get_user() == NULL ? NULL : Auth::instance()->get_user();
$ads = new Model_Ad();
//filter by category or location
if ($category !== NULL) {
$ads->where('id_category', 'in', $category->get_siblings_ids());
}
if ($location !== NULL) {
$ads->where('id_location', 'in', $location->get_siblings_ids());
}
//only published ads
$ads->where('status', '=', Model_Ad::STATUS_PUBLISHED);
//if ad have passed expiration time dont show
if (core::config('advertisement.expire_date') > 0) {
$ads->where(DB::expr('DATE_ADD( published, INTERVAL ' . core::config('advertisement.expire_date') . ' DAY)'), '>', Date::unix2mysql());
}
//if sort by distance
if (core::request('sort') == 'distance' and Model_User::get_userlatlng()) {
$ads->select(array(DB::expr('degrees(acos(sin(radians(' . $_COOKIE['mylat'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $_COOKIE['mylat'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $_COOKIE['mylng'] . ' - `longitude`))))) * 69.172'), 'distance'))->where('latitude', 'IS NOT', NULL)->where('longitude', 'IS NOT', NULL);
}
// featured ads
$featured = NULL;
if (Theme::get('listing_slider') == 2) {
$featured = clone $ads;
$featured = $featured->where('featured', '>=', Date::unix2mysql())->order_by('featured', 'desc')->limit(Theme::get('num_home_latest_ads', 4))->find_all();
} elseif (Theme::get('listing_slider') == 3) {
$featured = clone $ads;
$featured = $featured->where('featured', '>=', Date::unix2mysql())->order_by(DB::expr('RAND()'))->limit(Theme::get('num_home_latest_ads', 4))->find_all();
}
$res_count = clone $ads;
$res_count = $res_count->count_all();
// check if there are some advet.-s
if ($res_count > 0) {
// pagination module
$pagination = Pagination::factory(array('view' => 'pagination', 'total_items' => $res_count, 'items_per_page' => core::config('advertisement.advertisements_per_page')))->route_params(array('controller' => $this->request->controller(), 'action' => $this->request->action(), 'category' => $category !== NULL ? $category->seoname : NULL, 'location' => $location !== NULL ? $location->seoname : NULL));
Breadcrumbs::add(Breadcrumb::factory()->set_title(__("Page ") . $pagination->current_page));
/**
* order depending on the sort parameter
*/
switch (core::request('sort', core::config('advertisement.sort_by'))) {
//title z->a
case 'title-asc':
$ads->order_by('title', 'asc')->order_by('published', 'desc');
break;
//title a->z
//title a->z
case 'title-desc':
$ads->order_by('title', 'desc')->order_by('published', 'desc');
break;
//cheaper first
//cheaper first
case 'price-asc':
$ads->order_by('price', 'asc')->order_by('published', 'desc');
break;
//expensive first
//expensive first
case 'price-desc':
$ads->order_by('price', 'desc')->order_by('published', 'desc');
break;
//featured
//featured
case 'featured':
$ads->order_by('featured', 'desc')->order_by('published', 'desc');
break;
//rating
//rating
case 'rating':
$ads->order_by('rate', 'desc')->order_by('published', 'desc');
break;
//distance
//distance
case 'distance':
if (Model_User::get_userlatlng()) {
$ads->order_by('distance', 'asc')->order_by('published', 'asc');
}
break;
//oldest first
//oldest first
case 'published-asc':
$ads->order_by('published', 'asc');
break;
//newest first
//newest first
case 'published-desc':
default:
$ads->order_by('published', 'desc');
break;
}
//we sort all ads with few parameters
$ads = $ads->limit($pagination->items_per_page)->offset($pagination->offset)->find_all();
} else {
// array of categories sorted for view
//.........這裏部分代碼省略.........
示例4: action_advanced_search
public function action_advanced_search()
{
if (Theme::get('infinite_scroll')) {
$this->template->scripts['footer'][] = '//cdn.jsdelivr.net/jquery.infinitescroll/2.0b2/jquery.infinitescroll.js';
$this->template->scripts['footer'][] = 'js/listing.js';
}
if (core::config('general.auto_locate') or core::config('advertisement.map')) {
Theme::$scripts['async_defer'][] = '//maps.google.com/maps/api/js?libraries=geometry,places&v=3&key=' . core::config("advertisement.gm_api_key") . '&callback=initLocationsGMap';
}
$this->template->scripts['footer'][] = 'js/jquery.toolbar.js';
$this->template->scripts['footer'][] = 'js/sort.js';
//template header
$this->template->title = __('Advanced Search');
$this->template->meta_description = __('Search in') . ' ' . core::config('general.site_name');
//breadcrumbs
Breadcrumbs::add(Breadcrumb::factory()->set_title(__('Home'))->set_url(Route::url('default')));
Breadcrumbs::add(Breadcrumb::factory()->set_title($this->template->title));
$pagination = NULL;
$ads = NULL;
$res_count = NULL;
$user = $this->user ? $this->user : NULL;
if ($this->request->query()) {
// variables
$search_advert = core::get('title');
$search_loc = core::get('location');
// filter by each variable
$ads = new Model_Ad();
//if sort by distance
if ((core::request('sort', core::config('advertisement.sort_by')) == 'distance' or core::request('userpos') == 1) and Model_User::get_userlatlng()) {
$ads->select(array(DB::expr('degrees(acos(sin(radians(' . $_COOKIE['mylat'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $_COOKIE['mylat'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $_COOKIE['mylng'] . ' - `longitude`))))) * 111.321'), 'distance'))->where('latitude', 'IS NOT', NULL)->where('longitude', 'IS NOT', NULL);
}
// early filter
$ads = $ads->where('status', '=', Model_Ad::STATUS_PUBLISHED);
//if ad have passed expiration time dont show
if (core::config('advertisement.expire_date') > 0) {
$ads->where(DB::expr('DATE_ADD( published, INTERVAL ' . core::config('advertisement.expire_date') . ' DAY)'), '>', Date::unix2mysql());
}
if (core::request('userpos') == 1 and Model_User::get_userlatlng()) {
if (is_numeric(Core::cookie('mydistance')) and Core::cookie('mydistance') <= 500) {
$location_distance = Core::config('general.measurement') == 'imperial' ? Num::round(Core::cookie('mydistance') * 1.60934) : Core::cookie('mydistance');
} else {
$location_distance = Core::config('general.measurement') == 'imperial' ? Num::round(Core::config('advertisement.auto_locate_distance') * 1.60934) : Core::config('advertisement.auto_locate_distance');
}
$ads->where(DB::expr('degrees(acos(sin(radians(' . $_COOKIE['mylat'] . ')) * sin(radians(`latitude`)) + cos(radians(' . $_COOKIE['mylat'] . ')) * cos(radians(`latitude`)) * cos(radians(abs(' . $_COOKIE['mylng'] . ' - `longitude`))))) * 111.321'), '<=', $location_distance);
}
if (!empty($search_advert) or core::get('search') !== NULL and strlen(core::get('search')) >= 3) {
// if user is using search from header
if (core::get('search')) {
$search_advert = core::get('search');
}
if (core::config('general.search_by_description') == TRUE) {
$ads->where_open()->where('title', 'like', '%' . $search_advert . '%')->or_where('description', 'like', '%' . $search_advert . '%')->where_close();
} else {
$ads->where('title', 'like', '%' . $search_advert . '%');
}
}
//cf filter arrays
$cf_fields = array();
$cf_user_fields = array();
foreach ($this->request->query() as $name => $field) {
if (isset($field) and $field != NULL) {
// get by prefix cf
if (strpos($name, 'cf_') !== FALSE and array_key_exists(str_replace('cf_', '', $name), Model_Field::get_all())) {
$cf_fields[$name] = $field;
//checkbox when selected return string 'on' as a value
if ($field == 'on') {
$cf_fields[$name] = 1;
} elseif (empty($field)) {
$cf_fields[$name] = NULL;
}
} elseif (strpos($name, 'cfuser_') !== FALSE and array_key_exists(str_replace('cfuser_', '', $name), Model_UserField::get_all())) {
$name = str_replace('cfuser_', 'cf_', $name);
$cf_user_fields[$name] = $field;
//checkbox when selected return string 'on' as a value
if ($field == 'on') {
$cf_user_fields[$name] = 1;
} elseif (empty($field)) {
$cf_user_fields[$name] = NULL;
}
}
}
}
$category = NULL;
$location = NULL;
if (core::config('general.search_multi_catloc') and Theme::$is_mobile === FALSE) {
//filter by category
if (is_array(core::get('category'))) {
$cat_siblings_ids = array();
foreach (core::get('category') as $cat) {
if ($cat !== NULL) {
$category = new Model_Category();
$category->where('seoname', '=', $cat)->cached()->limit(1)->find();
if ($category->loaded()) {
$cat_siblings_ids = array_merge($cat_siblings_ids, $category->get_siblings_ids());
}
}
}
if (count($cat_siblings_ids) > 0) {
$ads->where('id_category', 'IN', $cat_siblings_ids);
}
//.........這裏部分代碼省略.........