<?php

class edu_select_video_auto_cache extends auto_cache{
	private $key = "edu:select:video:";
	public function load($param)
	{
		$sex = intval($param['sex_type']);
		$city = strim($param['area_type']);
		$cate_id = intval($param['cate_id']);
		
		$has_private = intval($param['has_private']);//1：包括私密直播
        $is_classify = intval($param['is_classify']);//分类
        $order = strim($param['order']);//排序字段
        $sort = strim($param['sort']);//排序方式
        $limit=  strim($param['limit']);//获取范围个数
		
		if ($city == '热门' || $city == 'null'){
			$city = '';
		}
		$this->key .= $sex . '_' . $city . '_' . $cate_id.'_'.$has_private . '_'.$is_classify;
        if($order){
            $this->key .= '_' . $order;
        }
        if($sort){
            $this->key .= '_' . $sort;
        }
        if($limit){
            $this->key .= '_' . $limit;
        }

		$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{
				$m_config =  load_auto_cache("m_config");//初始化手机端配置
				$has_is_authentication = intval($m_config['has_is_authentication'])?1:0;
				if($has_is_authentication&&$has_private==0){
					$sql = "SELECT v.id AS room_id, v.sort_num, v.group_id, v.user_id, v.city, v.title, v.cate_id, v.live_in, v.video_type, v.create_type, v.room_type,
						(v.robot_num + v.virtual_watch_number + v.watch_number) as watch_number, u.head_image,u.thumb_head_image,v.live_image, v.xpoint,v.ypoint,ev.tags,
						ev.is_verify,ev.deal_id,ev.edu_cate_id,ev.booking_class_id,u.v_type, u.v_icon, u.nick_name,u.user_level,v.is_live_pay,v.live_pay_type,v.live_fee,u.create_time as user_create_time FROM ".DB_PREFIX."video v 
					LEFT JOIN ".DB_PREFIX."user u ON u.id = v.user_id  LEFT JOIN ".DB_PREFIX."edu_video_info as ev ON ev.video_id = v.id 
					where v.live_in in (1,3) and u.is_authentication = 2 and u.is_hot_on =0 and u.mobile != '13888888888' and u.mobile != '13999999999'  ";
				}else{
					$sql = "SELECT v.id AS room_id, v.sort_num, v.group_id, v.user_id, v.city, v.title, v.cate_id, v.live_in, v.video_type, v.create_type, v.room_type,
						(v.robot_num + v.virtual_watch_number + v.watch_number) as watch_number, u.head_image,u.thumb_head_image,v.live_image, v.xpoint,v.ypoint,ev.tags,
						ev.is_verify,ev.deal_id,ev.edu_cate_id,ev.booking_class_id,u.v_type, u.v_icon, u.nick_name,u.user_level,v.is_live_pay,v.live_pay_type,v.live_fee,u.create_time as user_create_time FROM ".DB_PREFIX."video v 
					LEFT JOIN ".DB_PREFIX."user u ON u.id = v.user_id  LEFT JOIN ".DB_PREFIX."edu_video_info as ev ON ev.video_id = v.id 
					where v.live_in in (1,3) and u.is_hot_on =0 and  u.mobile != '13888888888' and u.mobile != '13999999999'  ";
				}
                if($is_classify){
                    $sql .= " and v.classified_id = ".$is_classify; //分类
                }
                				
				if ($has_private == 1){
					$sql .= ' and v.room_type in (1,3)'; //1:私密直播;3:直播
				}else{
					$sql .= ' and v.room_type = 3'; //1:私密直播;3:直播
				}
				
				
				if ($sex == 1 || $sex == 2){
					$sql .= ' and v.sex = '.$sex;
				}
				
				if ($city != ''){
					$sql .= " and v.province = '".$city."'";
				}
				
				if ($cate_id > 0){
					$sql .= " and ev.edu_cate_id = '".$cate_id."'";
				}

                if($has_private != 1 && (defined('OPEN_ROOM_HIDE')&&OPEN_ROOM_HIDE==1)&&intval($m_config['open_room_hide'])==1){
                    $sql.= " and v.province <> '火星' and v.province <>''";
                }
                if($order){
                    $sql.=" order by v.".$order;
                    if($sort){
                        $sql.=" ".$sort;
                    }
                }else{
                    $sql .= "  order by v.sort_num desc,v.sort desc";
                }

                if($limit){
                    $sql .= " limit ".$limit."";
                }

				$list = $GLOBALS['db']->getAll($sql,true,true);
				
				foreach($list as $k=>$v){
					//判断用户是否为今日创建的新用户，是：1，否：0
					if (date('Y-m-d') == date('Y-m-d',$list[$k]['user_create_time']+3600*8)){
						$list[$k]['today_create'] = 1;
					}else{
						$list[$k]['today_create'] = 0;
					}
					
					if($v['live_image']==''){
						$list[$k]['live_image'] = get_spec_image($v['head_image']);
						$list[$k]['head_image'] = get_spec_image($v['head_image']);
					}else{
						$list[$k]['live_image'] = get_spec_image($v['live_image']);
						$list[$k]['head_image'] = get_spec_image($v['head_image'],150,150);
					}
					if ($v['thumb_head_image'] == ''){
						$list[$k]['thumb_head_image'] = get_spec_image($v['head_image'],150,150);
					}else{
						//$list[$k]['thumb_head_image'] = get_abs_img_root($v['thumb_head_image']);
						$list[$k]['thumb_head_image'] = get_spec_image($v['thumb_head_image'],150,150);
					}

					if(!$v['tags']){
                        $list[$k]['tags'] = array();
                    }else{
                        $list[$k]['tags']=explode(',',$v['tags']);
                    }

                    $list[$k]['is_verify'] = intval($v['is_verify']);
                    $list[$k]['deal_id'] = intval($v['deal_id']);
                    $list[$k]['edu_cate_id'] = intval($v['edu_cate_id']);
					
				}
				
				$GLOBALS['cache']->set($this->key, $list, 10, 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);
	}
}
?>