Heim  >  Artikel  >  Backend-Entwicklung  >  以上代码是调用24小时内的数据,请教如何改成调用一个月或一年的数据

以上代码是调用24小时内的数据,请教如何改成调用一个月或一年的数据

WBOY
WBOYOriginal
2016-06-13 13:08:34761Durchsuche

以下代码是调用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>
Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn