membercache


    package com.test.memcache;
    import java.util.Date;
    import com.danga.MemCached.MemCachedClient;
    import com.danga.MemCached.SockIOPool;
    /**
    * 利用开源项目danga.MemCached管理缓存,实现分布式缓存支持。
    * 在调试时使用了memcached-1.2.6-win32-binary安装,在部署时需要build linux版本部署。 服务器默认端口是11211
    */
    public class MemCacheManager {
    // 创建全局的唯一实例
    protected static MemCachedClient mcc = null;
    protected static MemCacheManager memCacheManager = null;
    /**
    * 保护型构造方法!
    *
    */
    protected MemCacheManager() {
    }
    /**
    * 获取唯一实例.
    *
    * @return
    */
    public static MemCacheManager getInstance() {
    // 设置与缓存服务器的连接池
    if (memCacheManager == null) {
    // 获取socke连接池的实例对象
    SockIOPool pool = SockIOPool.getInstance();
    String server ="127.0.0.1";
    String port ="11211";
    String[] servers = { server+":"+port};
    // 设置服务器信息
    pool.setServers(servers);
    // 与服务器列表中对应的各服务器的权重,权重高的负载大
    Integer[] weights = { 3 };
    pool.setWeights(weights);
    // 设置初始连接数、最小和最大连接数以及最大处理时间
    pool.setInitConn(5);
    pool.setMinConn(5);
    pool.setMaxConn(250);
    pool.setMaxIdle(1000 * 60 * 60 * 6);
    // 设置主线程的睡眠时间
    pool.setMaintSleep(30);
    // 设置TCP的参数,连接超时等
    pool.setNagle(false);
    pool.setSocketTO(3000);
    pool.setSocketConnectTO(0);
    // 初始化连接池
    pool.initialize();
    // 压缩设置,超过指定大小(单位为K)的数据都会被压缩
    MemCachedClient mcc = new MemCachedClient();
    mcc.setCompressEnable(true);
    mcc.setCompressThreshold(64 * 1024);
    memCacheManager = new MemCacheManager();
    memCacheManager.mcc = mcc;
    }
    return memCacheManager;
    }
    /**
    * 添加一个指定的值到缓存中.
    *
    * @param key
    * @param value
    * @return
    */
    public boolean put(String key, Object value) {
    return mcc.add(key, value);
    }
    public boolean put(String key, Object value, Date expiry) {
    return mcc.add(key, value, expiry);
    }
    public boolean replace(String key, Object value) {
    return mcc.replace(key, value);
    }
    public boolean replace(String key, Object value, Date expiry) {
    return mcc.replace(key, value, expiry);
    }
    /**
    * 根据指定的关键字获取对象.
    *
    * @param key
    * @return
    */
    public Object get(String key) {
    Object rv= mcc.get(key);
    return rv;
    }
    }

 

/** * 查询球队列表 *@param String[字符串] team_name 球队名称 *@param String[字符串] location_of_the_team_district 区id 例如210200 *@create_time 2025-02-05 16:17:08 */ public function get_ballteam($data = [], $user = []) { $headLang = request()->header('lang'); $where = []; $order = 'ballteam.look_num desc,ballteam.people_num desc,ballteam.create_time desc'; if (!empty($data['sort_field'])) { //综合 最热 距离 球队人数 $order = 'ballteam.' . $data['sort_field'] . ' ' . $data['sort_type']; } $where[] = ['ballteam.is_del', '=', 0]; if (!empty($data['team_name'])) { $where[] = ['ballteam.team_name', 'LIKE', "%{$data['team_name']}%"]; } $where[] = ['ballteam.status', '=', '1']; $where[] = ['ballteam.is_del', '=', '0']; if(!empty($data['location_of_the_team_district'])) { $where[] = ['location_of_the_team','like',"%{$data['location_of_the_team_district']}%"]; } $select_info = array( 'member_user' => MemberCache::getUserListToMemberID(9240), ); $dataList = Db::table('lb_ball_team') ->alias('ballteam') ->join('lb_ball_tags balltags', 'balltags.aid = ballteam.balltags_id') ->field("ballteam.aid,ballteam.user_id,ballteam.team_logo,ballteam.team_name, ballteam.location_of_the_team,ballteam.team_introduction,ballteam.balltags_id, (SELECT COUNT(*) FROM lb_free_event_list WHERE is_del = 0 AND (ball_team_a_id = ballteam.aid OR ball_team_b_id = ballteam.aid)) as changci") ->where($where) // $dataList = Db::table('lb_ball_team') // ->alias('ballteam') // ->join('lb_ball_tags balltags', 'balltags.aid = ballteam.balltags_id') // ->field("ballteam.aid,ballteam.user_id,ballteam.team_logo,ballteam.team_name,ballteam.location_of_the_team,ballteam.team_introduction,ballteam.balltags_id") // ->where($where) ->order($order) ->paginate()->each(function ($infodataList) use ($user, $select_info, $headLang) { if ($infodataList['team_logo'] != '') { $infodataList['team_logo'] = get_file_url($infodataList['team_logo']); } $area = \app\common\model\Area::where([["region_code", "in", $infodataList['location_of_the_team']]])->column("name"); if (count($area) > 0) { $infodataList['location_of_the_team_area'] = implode(' ', $area); } else { $infodataList['location_of_the_team_area'] = ''; } $multiple_fields = Db::table('lb_ball_tags')->where('aid', 'in', "{$infodataList['balltags_id']}")->column('label_name'); $infodataList['balltags_label_name'] = $multiple_fields; //增加是否关注 $infodataList['is_follow'] = 0; if ($data['user_id']) { $infodataList['is_follow'] = Db::name("ball_team_follow_log")->where([ 'user_id' => $data['user_id'], 'ball_team_id' => $infodataList['aid'] ])->count() > 0 ? 1 : 0; } //场次 计算已完成的? event_status:1进行中 2已完成 , 暂时全部算event_status = 2 AND status = 1 AND // $wh = "is_del = 0 AND (ball_team_a_id = " . $infodataList['aid'] . " OR ball_team_b_id = " . $infodataList['aid'] . ")"; // $total_num = Db::table('lb_free_event_list')->where($wh)->count(); //总场次 // echo Db::table('lb_free_event_list')->getLastsql();die; // $infodataList['changci'] = $total_num; $infodataList['shuiping'] = get_shuiping($infodataList['aid']); //球队人数 $infodataList['team_num'] = Db::name("user")->whereRaw("FIND_IN_SET(?, ballteam_id)", [$infodataList['aid']])->count(); //查询球队胜利场数 $infodataList['game_chang'] = get_game_chang($infodataList['aid']); return $infodataList; }); return ApiReturn::r(1, $dataList, lang('球队列表')); } 现在changci 排序不好使 帮我修复一下
最新发布
08-13
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值