The following code calls data within 24 hours. how can I change it to PHPcodeprivatefunctiongetList ($ where, $ no_queryfalse) {global $ _ FANWE; if (! $ No_query) {if the following code calls data within 24 hours. how can I change it to data of one month or one year?
PHP code
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 ['max _ time'] & $ 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 <= '$ max_time' "; $ keyword =''; if ($ page_args ['keyword']! = '') {$ Page_args ['keyword'] = urldecode ($ page_args ['keyword']); $ keyword = & $ page_args ['keyword']; $ keyword_query = mysqlLikeQuote ($ page_args ['keyword']); $ where. = "AND (g. name LIKE '% $ keyword_query %') ";} else unset ($ page_args ['keyword']); $ insert_sort = 'gk. cr_sort ASC '; if ($ page_args ['cat']> 0) $ insert_sort = 'gk. ec_sort ASC '; if (in_array ($ page_args ['cat'], $ _ FANWE ['cache'] ['Goods'] ['root _ cate S ']) $ insert_sort = 'gk. dc_sort ASC '; $ city_name =$ _ FANWE ['current _ cit'] ['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' ";}} // price condition $ 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 <= $ price_max) ";} else unset ($ page_args ['prices']); $ goods_cates = S ('Goods ')-> 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 ('pa' => '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 ['id'] = implode (',', $ goods_result ['id']);} include template ('Page/goods_index ');}