<?php

class select_weibo_other_list_auto_cache extends auto_cache{
	private $key = "select:list:";
	public function load($param)
	{
		fanwe_require(APP_ROOT_PATH.'mapi/xr/core/common.php');
		$to_user_id = intval($param['to_user_id']);
		$page=$param['page']>0?$param['page']:1;
		$page_size=$param['page_size']>0?$param['page_size']:20;
		$limit = (($page-1) * $page_size) . "," . $page_size;

		$this->key .= md5(serialize($param));
		$key_bf = $this->key.'_bf';

		$list = $GLOBALS['cache']->get($this->key,true);

		if ($list === false) {
			$is_ok =  $GLOBALS['cache']->set_lock($this->key);
			if(!$is_ok){
				$list = $GLOBALS['cache']->get($key_bf,true);
			}else{

				$sql = "select w.user_id,w.id as weibo_id,u.head_image,u.is_authentication,w.content,w.red_count,w.digg_count,w.comment_count,w.video_count,w.data,u.nick_name,w.sort_num,w.photo_image,w.is_top ,u.city,w.price,w.type,w.create_time,w.city,w.province,w.address from ".DB_PREFIX."weibo as w
					left join ".DB_PREFIX."user as u on w.user_id = u.id where w.user_id = ".$to_user_id ."  and w.status = 1 ";

                if (!empty($param['type'])) {
                    if (!is_array($param['type'])) {
                        $param['type'] = array($param['type']);
                    }
                    $type = implode("','", $param['type']);
                    $sql .= " and w.type in ('{$type}')";
                }

				$sql .= "  order by  w.is_top desc,  w.id desc";
				$sql .= " limit " .$limit;
				
				$list = $GLOBALS['db']->getAll($sql,true,true);

				if(count($list)>0){
					foreach($list as $k=>$v){

						$list[$k]['is_show_weibo_report'] = 1;
						$list[$k]['is_show_user_report'] = 1;
						$list[$k]['is_show_user_black'] = 1;
						$list[$k]['is_show_top'] = 0;
						$list[$k]['is_show_deal_weibo'] =0;
						$list[$k]['has_digg'] = 0;

						$list[$k]['left_time'] = $this->time_tran($v['create_time']);
						if($v['head_image']){
							$list[$k]['head_image'] = deal_weio_image($v['head_image'],'head_image');
						}
						if($v['photo_image']){
							$list[$k]['photo_image'] = deal_weio_image($v['photo_image'],$v['type']);
						}
						$list[$k]['images_count'] = 0;
						$list[$k]['goods_url'] = '';
						if($v['type']=='goods'){
							$list[$k]['goods_url'] =  SITE_DOMAIN.'/wap/xr/index.html#/weiboGoodsInfo?weibo_id='.$v['weibo_id'];
						}
						$address_x = str_replace("福建省","",$v['address']);
						$address_x = str_replace("福州市","",$address_x);
						$list[$k]['weibo_place'] = $v['province'].$v['city'].$address_x;
						if($v['type']=='video'){
							$list[$k]['images'] = array();
							$url = $v['data'];
							$list[$k]['video_url'] = get_file_oss_url($url);;
						}else{
							$images = unserialize($v['data']);
							$list[$k]['images'] = $images;
							//只针对 $to_user_id==$user_id
							$is_pay =1;

							$price = floatval($v['price']);
							if(count($images)>0){
								foreach($images as $k1=>$v1){
									if(is_object($v1)){
										$v1 = (array)$v1;
									}
									$images[$k1]['orginal_url'] = '';
									if($v1['url']){
										$images[$k1]['url'] =  deal_weio_image($v1['url']);
										//$images[$k1]['is_model'] =  0;
										$images[$k1]['orginal_url'] =  get_spec_image($v1['url']);
									}
								}
								$list[$k]['images'] = $images;
								$list[$k]['images_count'] = count($images);
							}else{
								$list[$k]['images'] = array();
							}

							$list[$k]['video_url'] = '';
						}
						unset($list[$k]['data']);
					}
				}else{
					$list = array();
				}

				
				$GLOBALS['cache']->set($this->key, $list, 3, true);
				
				$GLOBALS['cache']->set($key_bf, $list, 86400, true);//备份
				//echo $this->key;
			}
 		}
 		
 		if ($list == false) $list = array();
 		
		return $list;
	}
	
	public function rm()
	{

		//$GLOBALS['cache']->clear_by_name($this->key);
	}
	
	public function clear_all()
	{
		
		//$GLOBALS['cache']->clear_by_name($this->key);
	}
	public function time_tran($the_time)
	{
		$now_time = to_date(NOW_TIME,"Y-m-d H:i:s");
		$now_time = to_timespan($now_time);
		$show_time = to_timespan($the_time);
		$dur = $now_time - $show_time;
		if ($dur < 0) {
			return to_date($show_time,"Y-m-d");
		} else {
			if ($dur < 60) {
				return $dur . '秒前';
			} else {
				if ($dur < 3600) {
					return floor($dur / 60) . '分钟前';
				} else {
					if ($dur < 86400) {
						return floor($dur / 3600) . '小时前';
					} else {
						if ($dur < 2592000) {//30天内
							return floor($dur / 86400) . '天前';
						} else {
							return to_date($show_time,"Y-m-d");
						}
					}
				}
			}
		}
	}

}
?>