<?php

class edu_select_video_check_auto_cache extends auto_cache
{
    private $key = "edu:select:video:check:";

    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;
        if ($order) {
            $this->key .= '_' . $order;
        }
        if ($sort) {
            $this->key .= '_' . $sort;
        }
        if ($limit) {
            $this->key .= '_' . $limit;
        }


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

        $key_bf = $this->key . '_bf';
        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 && $m_config['ios_check_version'] == '') {
                    $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' or 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' or 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);
    }
}

?>