以上代码是调用24小时内的数据,请教如何改成调用一个月或一年的数据
以下代码是调用24小时内的数据,请问怎么改成调用一个月或一年的数据
- PHP code
<!-- Code highlighting produced by Actipro CodeHighlighter (freeware) http://www.CodeHighlighter.com/ --> private function getList($where='',$no_query = false) { global $_FANWE; if(!$no_query) { if(defined('IS_CACHE_TPL')) $fields = ''; else $fields = ',g.post_count'; $page_args = array( 'city_py' => CURRENT_CITY_PY, 'site' => intval($_FANWE['request']['site']), 'cat' => intval($_FANWE['request']['cat']), 'sort' => trim($_FANWE['request']['sort']), 'date' => trim($_FANWE['request']['date']), 'keyword' => trim($_FANWE['request']['keyword']), 'prices' => trim($_FANWE['request']['prices']), ); $site_id = 0; if($page_args['site'] > 0) { $site_id = $page_args['site']; $site_where = ' AND gk.site_id = '.$page_args['site']; } else unset($page_args['site']); $dates = S('Goods')->getExpiredGoodsDate(); $min_time = getTodayTime(); $max_time = TIME_UTC; $date = toDate($min_time,'Y-m-d'); if(!empty($page_args['date'])) { $time = str2Time($page_args['date']); if($time = $dates['min_time']) { $date = toDate($time,'Y-m-d'); $min_time = str2Time(toDate($time,'Y-m-d')); $max_time = $min_time + 863990000; if($max_time > TIME_UTC) $max_time = TIME_UTC; } } else { $page_args['date'] = $date; } $dates['min_time'] = toDate($dates['min_time'],'r'); $dates['max_time'] = toDate($dates['max_time'],'r'); $where.=" AND gk.end_time >= '$min_time' AND gk.end_time 0) $insert_sort = 'gk.ec_sort ASC'; if(in_array($page_args['cat'],$_FANWE['cache']['goods']['root_cates'])) $insert_sort = 'gk.dc_sort ASC'; $city_name = $_FANWE['current_city']['name']; if(CURRENT_CITY_PY == CHINA_CITY_PY) { //全国不包含所有城市商品时 if($_FANWE['setting']['all_city'] == 0) $where.= " AND gk.city = '$city_name'"; else { $insert_sort = 'gk.r_sort ASC'; if($page_args['cat'] > 0) $insert_sort = 'gk.e_sort ASC'; if(in_array($page_args['cat'],$_FANWE['cache']['goods']['root_cates'])) $insert_sort = 'gk.d_sort ASC'; } } elseif(CURRENT_CITY_PY != '') { //城市显示全国商品时 if($_FANWE['setting']['index_all'] == 1) { $fields .= ",(gk.city = '$city_name') as is_now_city"; $insert_sort = 'is_now_city DESC,'.$insert_sort; $quanguo_name = $_FANWE['cache']['city']['all'][CHINA_CITY_PY]['name']; $where.= " AND gk.city IN ('$city_name','$quanguo_name')"; } else { $where.= " AND gk.city = '$city_name'"; } } //价格条件 $prices = ''; if(!empty($page_args['prices'])) { $prices = &$page_args['prices']; $price_arr = explode(',',$prices); $price_min = intval($price_arr[0]); $price_max = intval($price_arr[1]); if($price_min > 0) $where.=" AND (g.shop_price >= $price_min)"; if($price_max > 0) $where.=" AND (g.shop_price getExpiredGoodsCats($site_where.$where); $cate_id = 0; if($page_args['cat'] > 0) { $cate_id = &$page_args['cat']; $cateobj = $_FANWE['cache']['goods']['cats'][$cate_id]; $cate_ids = array(); if(isset($cateobj['childs'])) $cate_ids = $cateobj['childs']; $cate_ids[] = $cate_id; if(count($cate_ids) > 1) $where.=' AND gk.cate_id IN ('.implode(',', $cate_ids).')'; else $where.=" AND gk.cate_id = '$cate_id'"; } else unset($page_args['cat']); $goods_sites = S('Goods')->getExpiredGoodsSites($where); $where = $site_where.$where; $order = ''; $sort = &$page_args['sort']; $sort_array = array('spa'=>'g.shop_price ASC','spd'=>'g.shop_price DESC','eta'=>'g.end_time ASC','etd'=>'g.end_time DESC','cca'=>'g.click_count ASC','ccd'=>'g.click_count DESC','sa'=>'g.score ASC','sd'=>'g.score DESC','ba'=>'g.bought ASC','bd'=>'g.bought DESC','da'=>'discount ASC','dd'=>'discount DESC'); if(array_key_exists($sort,$sort_array)) $order = $sort_array[$sort]; else { unset($page_args['sort']); $sort = ''; } if(empty($order)) $order .= 'g.is_best DESC,'.$insert_sort.',g.sort ASC,g.id ASC'; else $order .= ','.$insert_sort.',g.sort ASC,g.id DESC'; $goods_count = S('Goods')->getExpiredGoodsCount($where); $pager = buildPage('goods/'.ACTION_NAME,$page_args,$goods_count,$_FANWE['page'],15); $goods_result = S('Goods')->getExpiredGoodsList($where,$order,$fields,$pager['limit']); $goods_result['ids'] = implode(',',$goods_result['ids']); } include template('page/goods_index'); } <div class="clear"> </div>

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

Uniapp is a cross-platform development framework. Its powerful cross-end capabilities allow developers to develop various applications quickly and easily. It is also very simple to implement drag-and-drop sorting and drag-and-drop operations in Uniapp, and it can support drag-and-drop operations of a variety of components and elements. This article will introduce how to use Uniapp to implement drag-and-drop sorting and drag-and-drop operations, and provide specific code examples. The drag-and-drop sorting function is very common in many applications. For example, it can be used to implement drag-and-drop sorting of lists, drag-and-drop sorting of icons, etc. Below we list

The bottom layer of the C++sort function uses merge sort, its complexity is O(nlogn), and provides different sorting algorithm choices, including quick sort, heap sort and stable sort.

Today we are mainly going to take a look at the time application method of golang time package. The general rule between the two is that "wall time" is used to tell time, and "monotonic clock" is used to measure time; there are other clock processing methods.

Title: Example of using the Array.Sort function to sort an array in C# Text: In C#, array is a commonly used data structure, and it is often necessary to sort the array. C# provides the Array class, which has the Sort method to conveniently sort arrays. This article will demonstrate how to use the Array.Sort function in C# to sort an array and provide specific code examples. First, we need to understand the basic usage of the Array.Sort function. Array.So

How to sort a list using the List.Sort function in C# In the C# programming language, we often need to sort the list. The Sort function of the List class is a powerful tool designed for this purpose. This article will introduce how to use the List.Sort function in C# to sort a list, and provide specific code examples to help readers better understand and apply this function. The List.Sort function is a member function of the List class, used to sort elements in the list. This function receives

Practical Guide to Where Method in Laravel Collections During the development of the Laravel framework, collections are a very useful data structure that provide rich methods to manipulate data. Among them, the Where method is a commonly used filtering method that can filter elements in a collection based on specified conditions. This article will introduce the use of the Where method in Laravel collections and demonstrate its usage through specific code examples. 1. Basic usage of Where method

How to use the Where method in Laravel collection Laravel is a popular PHP framework that provides a wealth of functions and tools to facilitate developers to quickly build applications. Among them, Collection is a very practical and powerful data structure in Laravel. Developers can use collections to perform various operations on data, such as filtering, mapping, sorting, etc. In collections, the Where method is a commonly used method for filtering the collection based on specified conditions.

Implementing data paging and display optimization in Vue projects. In Vue projects, when a page needs to display a large amount of data, data paging and display optimization usually need to be performed to improve user experience. This article will introduce how to use Vue to implement data paging and display optimization. , and provide specific code examples. 1. Data paging Data paging refers to dividing a large amount of data into multiple pages according to certain rules and displaying them on the page. You can use the following steps to implement data paging in a Vue project: Define the data source. First, define a
