/** * 获取喜欢这个分享的会员还喜欢的分享(有图片或商品的分享) * @param int $share_id 分享编号 * @param int $num 获取数量 * @return array */ public function getCollectShareByShare($share_id, $num = 20) { $list = array(); $share_id = (int) $share_id; if (!$share_id) { return $list; } $uids = ShareService::getShareCollectUser($share_id, 0); if (count($uids) > 0) { $share_ids = array(); $res = FDB::query('SELECT GROUP_CONCAT(DISTINCT s.share_id ORDER BY s.share_id DESC SEPARATOR \',\') AS share_ids,s.uid FROM ' . FDB::table('user_collect') . ' AS uc INNER JOIN ' . FDB::table('share') . ' AS s ON s.share_id = uc.share_id WHERE uc.c_uid IN (' . implode(',', $uids) . ') AND s.share_id <> ' . $share_id . ' AND s.share_data IN (\'goods\',\'photo\',\'goods_photo\') GROUP BY s.uid LIMIT 0,' . $num); while ($data = FDB::fetch($res)) { $share_ids = explode(',', $data['share_ids']); $share_ids[] = current($share_ids); } } if (count($share_ids) > 0) { $list = FDB::fetchAll('SELECT * FROM ' . FDB::table('share') . ' WHERE share_id IN (' . implode(',', $share_ids) . ') LIMIT 0,' . $num); $list = ShareService::getShareDetailList($list); } return $list; }