<?php
namespace App\Http\Controllers\Channel\Book;
use App\Http\Controllers\Channel\BaseController;
use App\Http\Controllers\Channel\Book\Transformers\BookTransformer;
use App\Http\Controllers\Channel\Book\Transformers\BookV2Transformer;
use App\Http\Controllers\Channel\Book\Transformers\ChapterListTransformer;
use App\Modules\Book\Services\BookCategoryService;
use App\Modules\Book\Services\BookConfigService;
use App\Modules\Book\Services\BookSpecialChannelService;
use App\Modules\Book\Services\BookSubscribleChapterService;
use App\Modules\Book\Services\ChapterService;
use App\Modules\Book\Services\SuperiorHistoryBookService;
use App\Modules\Book\Services\SuperiorNewBookService;
use App\Modules\Channel\Services\ChannelService;
use App\Modules\SendOrder\Services\SendOrderService;
use App\Modules\Channel\Services\CompanySpecialBookService;
use App\Modules\Channel\Services\ChannelUserService;
use App\Modules\Channel\Services\CompanyService;
use App\Modules\Book\Models\BookOrderStatistical;
use Hashids;
use Illuminate\Http\Request;
use Log;
use Storage;
use Illuminate\Support\Facades\Cache;
use Redis;
use DB;
class BooksController extends BaseController
{
/**
* @apiDefine Book 图书模块
*/
/**
* @apiVersion 1.0.0
* @apiDescription 按bid获取图书详情
* @api {get} book/getBookInfo 获取图书详情
* @apiGroup Book
* @apiParam {Number} bid 图书id
* @apiName getBookInfo
* @apiSuccess {int} code 状态码
* @apiSuccess {String} msg 信息
* @apiSuccess {object} data 结果集
* @apiSuccess {Int} data.book_id bid
* @apiSuccess {String} data.book_name 书名
* @apiSuccess {String} data.book_summary 简介
* @apiSuccess {String} data.book_author 作者
* @apiSuccess {String} data.cover_url 封面
* @apiSuccess {Int} data.book_word_count 字数
* @apiSuccess {Int} data.book_chapter_total 章节数
* @apiSuccess {Int} data.book_category_id 分类
* @apiSuccess {String} data.book_category 分类名
* @apiSuccess {Int} data.book_end_status 是否完结
* @apiSuccess {String} data.book_published_time 发布时间
* @apiSuccess {String} data.copyright 版权信息
* @apiSuccess {Int} data.force_subscribe_chapter_seq 强制关注的章节序号
* @apiSuccess {String} data.update_time 更新时间
* @apiSuccess {Int} data.is_on_shelf 是否上架
* @apiSuccess {Int} data.book_price 是否上架
* @apiSuccess {String} data.charge_type 收费类型
* @apiSuccess {String} data.keyword 关键词
* @apiSuccess {String} data.recommend_index 推荐指数
* @apiSuccess {String} data.is_show_index_content 是否显示推荐指数文本
* @apiSuccess {Int} data.click_count 点击数
* @apiSuccessExample {json} Success-Response:
* {
* "code": 0,
* "msg": "",
* "data": {
* "book_id": 5,
* "book_name": "肌缘巧合",
* "book_summary": " 他是权势倾天，纵横商界的王者，却偏偏钟情于她，一宠成瘾。“女人，我要你......只要你能满足我，别墅、游轮、支票，你随便挑。”她羞涩的半低着头：“我只想要你。”他挑眉，“你野心不小啊！”她妩媚一笑，解开他的领带，“难道你不愿意！”他宠她爱她，给她所有想要的。只是有一天她终于忍不住暴走，“靠，你有没有节制呀？我要离婚。”",
* "book_author": "妖火",
* "cover_url": "http://www.leyuee.com/cover/0/8.jpg",
* "book_word_count": 0,
* "book_chapter_total": 0,
* "book_category_id": null,
* "book_category": "爆笑,宠文,潜规则",
* "book_end_status": 8,
* "book_published_time": null,
* "copyright": null,
* "charge_type": null,
* "force_subscribe_chapter_seq": 0,
* "update_time": null,
* "is_on_shelf": 0,
* "book_price": null,
* "keyword": "关键词",
* "recommend_index":2,
* "is_show_index_content":0,
* "click_count":0
* }
* }
*/
function getBookInfo(Request $request)
{
$bid = $request->has('bid') ? $request->input('bid') : '';
if (empty($bid)) return response()->error("PARAM_EMPTY");
$bid = Hashids::decode($bid)[0];
$hidden_book = env('HIDE_BOOKS');
if ($hidden_book) {
$hidden_book_array = explode(',', $hidden_book);
if (in_array($bid, $hidden_book_array)) {
//return response()->error("PARAM_ERROR");
}
}
$data = BookConfigService::getBookById($bid);
$subscribe_chapter_seq = BookSubscribleChapterService::getSubcribleChapter($bid, $this->getChannelId());
if ($subscribe_chapter_seq && $subscribe_chapter_seq->subscribe_chapter_id > 0) {
$data->force_subscribe_chapter_seq = $subscribe_chapter_seq->subscribe_chapter_id;
}
$chapter = ChapterService::getChapterInfoByBidAndSeq($bid, $data->force_subscribe_chapter_seq);
if ($chapter) {
$data->force_subscribe_cid = $chapter->id;
$data->force_subscribe_chapter_name = $chapter->name;
}
return response()->item(new BookTransformer(), $data);
}
/**
* @apiVersion 1.0.0
* @apiDescription 获取图书目录
* @api {get} book/getBookDirectory 获取图书目录
* @apiGroup Book
* @apiName getBookDirectory
* @apiParam {Int} bid 书本id
* @apiParam {Int} page 页数
* @apiParam {Int} pageSize 分页大小(默认15)
* @apiSuccess {int} code 状态码
* @apiSuccess {String} msg 信息
* @apiSuccess {object} data 结果集
* @apiSuccess {Array} data.list 分页结果集
* @apiSuccess {Int} data.list.bid bid
* @apiSuccess {Int} data.list.chapter_id 章节id
* @apiSuccess {String} data.list.chapter_name 章节名称
* @apiSuccess {Int} data.list.chapter_sequence 序号
* @apiSuccess {Int} data.list.chapter_is_vip 是否vip
* @apiSuccess {Int} data.list.chapter_size 章节大小
* @apiSuccess {Int} data.list.prev_cid 上一章节id
* @apiSuccess {Int} data.list.next_cid 下一章节
* @apiSuccess {Int} data.list.dafault_subscribe 是否默认强关章节
* @apiSuccess {Int} data.list.channel_subscribe 是否用户自定义强关章节
* @apiSuccess {String} data.list.recent_update_at 更新时间
* @apiSuccess {Int} data.list.is_recommend 是否是推荐章节
* @apiSuccess {String} data.list.recommend_text 推荐内容
* @apiSuccess {String} data.list.is_need_subscirbe 是否强制关注
* @apiSuccess {object} data.meta 分页信息
* @apiSuccess {Int} data.meta.total 总条数
* @apiSuccess {Int} data.meta.per_page 每页条数
* @apiSuccess {Int} data.meta.current_page 当前页
* @apiSuccess {Int} data.meta.last_page 最后页
* @apiSuccess {String} data.meta.next_page_url 下一页
* @apiSuccess {String} data.meta.prev_page_url 上一页
* @apiSuccessExample {json} Success-Response:
* {
* "code": 0,
* "msg": "",
* "data":
* "pagination":[
* {
* "bid": 5,
* "chapter_id": 5,
* "chapter_name": "第1240章 不是我",
* "chapter_sequence": 1239,
* "chapter_is_vip": 1,
* "chapter_size": 2422,
* "prev_cid": 0,
* "is_recommend": 1,
* "recommend_text": "",
* "next_cid": 0,
* "recent_update_at": 2017-11-20 15:01:56,
* "is_need_subscirbe": 1,
* },
* {
* "bid": 5,
* "chapter_id": 5,
* "chapter_name": "第1240章 不是我",
* "chapter_sequence": 1239,
* "chapter_is_vip": 1,
* "chapter_size": 2422,
* "is_recommend": 1,
* "recommend_text": "",
* "prev_cid": 0,
* "next_cid": 0,
* "recent_update_at": 2017-11-20 15:01:56,
* "is_need_subscirbe": 1,
* },
* ]
* "meta":{
* "total": 1253,
* "per_page": 15,
* "current_page": 1,
* "last_page": 84,
* "next_page_url": "http://myapi.cn/api/books/1/chapter?page=2",
* "prev_page_url": ""
* }
* }
*/
function getBookDirectory(Request $request)
{
$bid = $request->has('bid') ? $request->input('bid') : '';
if (empty($bid)) return response()->error("PARAM_EMPTY");
$bid = Hashids::decode($bid)[0];
$pageSize = $request->has('pageSize') ? (int)$request->input('pageSize') : 15;
$data = ChapterService::getChapterListsPage($bid, $pageSize);
$book = BookConfigService::getBookById($bid);//force_subscribe_chapter_seq
$subscribe_chapter_seq = BookSubscribleChapterService::getSubcribleChapter($bid, $this->getChannelId());
$default_subscribe = $book->force_subscribe_chapter_seq;
$channel_subscribe = 0;
if ($subscribe_chapter_seq && $subscribe_chapter_seq->subscribe_chapter_id > 0) {
$channel_subscribe = $subscribe_chapter_seq->subscribe_chapter_id;
$book->force_subscribe_chapter_seq = $subscribe_chapter_seq->subscribe_chapter_id;
}
foreach ($data as &$item) {
$item->dafault_subscribe = 0;
$item->channel_subscribe = 0;
if ($item->sequence == $default_subscribe) {
$item->dafault_subscribe = 1;
}
if ($channel_subscribe && $item->sequence == $channel_subscribe) {
$item->channel_subscribe = 1;
}
if ($item->sequence >= ($book->force_subscribe_chapter_seq)) {
$item->is_need_subscirbe = 1;
} else {
$item->is_need_subscirbe = 0;
}
if ($item->id == $book->recommend_cid) {
$item->is_recommend = 1;
if (Storage::exists('RecommendChapterPositionWord.txt')) {
$item->recommend_text = Storage::get('RecommendChapterPositionWord.txt');
} else {
$item->recommend_text = '建议此章节生成推广文案(原文转化率好)';
}
}
}
return response()->pagination(new ChapterListTransformer(), $data);
}
/**
* @apiVersion 1.0.0
* @apiDescription 获取分类
* @api {get} book/getBookCategories 获取分类
* @apiGroup Book
* @apiName getBookCategories
* @apiSuccess {int} code 状态码
* @apiSuccess {String} msg 信息
* @apiSuccess {object} data 结果集
* @apiSuccessExample {json} Success-Response:
* {
* "code": 0,
* "msg": "",
* "data": [
* {
* "id": 1,
* "name": "男频",
* "children": [
* {
* "id": 7,
* "name": "灵异鬼怪"
* },
* {
* "id": 8,
* "name": "历史穿越"
* },
* {
* "id": 30,
* "name": "青春爱情"
* }
* ]
* },
* {
* "id": 2,
* "name": "女频",
* "children": [
* {
* "id": 26,
* "name": "豪门总裁"
* },
* {
* "id": 35,
* "name": "民国爱情"
* }
* ]
* }
* ]
* }
*/
function getBookCategories(Request $request)
{
$res = BookCategoryService::getSecondCategories();
$male = [];
$female = [];
foreach ($res as $v) {
if ($v->channel_name == '男频') {
$male[] = ['id' => $v->id, 'name' => $v->category_name];
}
if ($v->channel_name == '女频') {
$female[] = ['id' => $v->id, 'name' => $v->category_name];
}
}
$data = [
['id' => 1, 'name' => '男频', 'children' => $male],
['id' => 2, 'name' => '女频', 'children' => $female],
];
//$data = BookCategoryService::getSecondCategories();
return response()->success($data);
}
function getBookCategoriesV2(Request $request)
{
//$res = BookCategoryService::getSecondCategories();
$female = [['id'=>13,'name'=>'豪门虐情'], ['id'=> 14,'name'=>'婚恋生活'] ,['id'=>18,'name'=>'穿越重生'], ['id'=>22,'name'=>'女生灵异']];
$male = [
['id'=>4,'name'=>'都市艳遇'],
['id'=>5,'name'=>'兵王保镖'],
['id'=>8,'name'=>'风云职场'],
['id'=>12,'name'=>'悬疑灵异']
];
$data = [
['id' => 1, 'name' => '男频', 'children' => $male],
['id' => 2, 'name' => '女频', 'children' => $female],
];
//$data = BookCategoryService::getSecondCategories();
return response()->success($data);
}
/**
* @apiVersion 1.0.0
* @apiDescription 根据分类id和关键词获取并按照推荐指数排序
* @api {get} book/getPromotionBookList 获取图书列表
* @apiParam {String} key
* @apiParam {Int} category_id 分类id
* @apiParam {String} order_field 排序字段(推荐指数:recommend_index|点击数:click_count)
* @apiParam {String} order_seq 排序顺序(顺序:asc|逆序:desc)
* @apiParam {Int} is_on_shelf 上架与否（0|1）
* @apiParam {Int }pageSize 分页大小
* @apiGroup Book
* @apiName getPromotionBookList
* @apiSuccess {int} code 状态码
* @apiSuccess {String} msg 信息
* @apiSuccess {object} data 结果集
* @apiSuccess {Array} data.list 结果数据集
* @apiSuccess {Int} data.list.book_id bid
* @apiSuccess {String} data.list.book_name 书名
* @apiSuccess {String} data.list.book_summary 简介
* @apiSuccess {String} data.list.book_author 作者
* @apiSuccess {String} data.list.cover_url 封面
* @apiSuccess {Int} data.list.book_word_count 字数
* @apiSuccess {Int} data.list.book_chapter_total 章节数
* @apiSuccess {Int} data.list.book_category_id 分类
* @apiSuccess {String} data.list.book_category 分类名
* @apiSuccess {String} data.list.book_end_status 是否完结
* @apiSuccess {String} data.list.promotion_count 推广次数
* @apiSuccess {String} data.list.book_published_time 发布时间
* @apiSuccess {String} data.list.copyright 版权信息
* @apiSuccess {Int} data.list.force_subscribe_chapter_seq 强制关注的章节序号
* @apiSuccess {String} data.list.update_time 更新时间
* @apiSuccess {Int} data.list.is_on_shelf 是否上架
* @apiSuccess {String} data.list.book_price 价格
* @apiSuccess {String} data.list.recommend_index 推荐指数
* @apiSuccess {Int} data.list.charge_type 收费类型(BOOK: 按本收费，CHAPTER： 按章收费)
* @apiSuccess {Int} data.list.keyword 关键词
* @apiSuccess {Int} data.list.is_show_index_content 是否显示推荐指数文本
* @apiSuccess {Int} data.list.click_count 点击数
* @apiSuccess {object} data.meta 分页信息
* @apiSuccess {Int} data.meta.total 总条数
* @apiSuccess {Int} data.meta.per_page 每页条数
* @apiSuccess {Int} data.meta.current_page 当前页
* @apiSuccess {Int} data.meta.sex_preference 性别偏好
* @apiSuccess {Int} data.meta.last_page 最后页
* @apiSuccess {String} data.meta.next_page_url 下一页
* @apiSuccess {String} data.meta.prev_page_url 上一页
* @apiSuccessExample {json} Success-Response:
* {
* "code": 0,
* "msg": "",
* "data": {
* "list": [
* {
* "book_id": 5,
* "book_name": "肌缘巧合",
* "book_summary": " 他是权势倾天，纵横商界的王者，却偏偏钟情于她，一宠成瘾。“女人，我要你......只要你能满足我，别墅、游轮、支票，你随便挑。”她羞涩的半低着头：“我只想要你。”他挑眉，“你野心不小啊！”她妩媚一笑，解开他的领带，“难道你不愿意！”他宠她爱她，给她所有想要的。只是有一天她终于忍不住暴走，“靠，你有没有节制呀？我要离婚。”",
* "book_author": "妖火",
* "cover_url": "http://www.leyuee.com/cover/0/8.jpg",
* "book_word_count": 0,
* "book_chapter_total": 0,
* "book_category_id": null,
* "book_category": "爆笑,宠文,潜规则",
* "book_end_status": 8,
* "promotion_count": 12,
* "sex_preference":"女频",
* "book_published_time": null,
* "copyright": null,
* "charge_type": null,
* "force_subscribe_chapter_seq": 0,
* "update_time": null,
* "is_on_shelf": 1,
* "book_price": null,
* "keyword": "温馨,虐心,清水",
* "recommend_index":2,
* "is_show_index_content":0,
* "click_count":0
* },
* ],
* "meta": {
* "total": 18,
* "per_page": 15,
* "current_page": 1,
* "last_page": 2,
* "next_page_url": "http://myapi.cn/api/hotrank/books?page=2",
* "prev_page_url": ""
* }
* }
* }
*/
public function getPromotionBookList(Request $request)
{
$channel_id = $this->getChannelId();
$channel_user = ChannelService::getUserIdById($channel_id);
$channel_user_id = $channel_user->channel_user_id;
$channel_user_info = ChannelUserService::getById($channel_user_id);
// $is_important_channel = ChannelUserService::getImpotantById($channel_user_id)->is_important;
// if (1 == $is_important_channel) {
// $where['is_on_shelf'] = [2, 1];
// } else {
// $where['is_on_shelf'] = [2];
// }
$bids = [];
if ($channel_user_info && !empty($channel_user_info->company_id)) {
$bids = CompanySpecialBookService::getBidByCompany($channel_user_info->company_id);
}
$hidden_book = env('HIDE_BOOKS');
if ($hidden_book) {
$hidden_book_array = explode(',', $hidden_book);
$where['hidden_books'] = $hidden_book_array;
if ($bids) {
$bids = array_diff($bids, $hidden_book_array);
}
}
//$bids = BookSpecialChannelService::getBids($channel_user_id);
$where['is_on_shelf'] = [2];
$category_id = $request->input('category_id');
if ($request->has('key') && trim($request->input('key'))) $where['key'] = trim($request->input('key'));
if ($category_id) {
if ($category_id == 1) {
$where['channel_name'] = '男频';
} elseif ($category_id == 2) {
$where['channel_name'] = '女频';
} else {
$where['category_id'] = $category_id;
}
}
$order_field = $request->input('order_field');
$order_seq = $request->input('order_seq', 'desc');
if ($order_field) {
$order = ['book_configs.recommend_index', $order_seq];
} else {
$order = ['book_configs.id', $order_seq];
}
$data = BookConfigService::getPromotionBooks($where, $bids, $order);
if (!empty($data)) {
foreach ($data as $item) {
$item->promotion_count = SendOrderService::getPromotionCountByBid($item->bid, $channel_id);
}
}
return response()->pagination(new BookTransformer(), $data);
}
/**
* @apiVersion 1.0.0
* @apiDescription 小说推广
* @api {get} book/getPromotionBookListV2 小说推广
* @apiParam {String} [key] 关键词
* @apiParam {Int} [category_id] 类型
* @apiParam {String} [order_field] 排序字段 (全站指数,)
* @apiParam {String} [order_type] 顺序(asc)or倒叙(desc) 默认倒叙
* @apiParam {Int} [sex] 1:女频,2:男频
* @apiParam {Int} [status] 0:连载,1:完结
* @apiParam {String} [recommend_index] 编辑评分 (A,B,C...)
* @apiParam {Int} [onshelf] 上架时间 (一周:7,一月:30,..:90)
* @apiParam {Int} [size] 字数 (200万以上:1,100-200:2,3,4,5:长篇,6,短篇)
* @apiParam {Int} [own_score] 自主评级 (A，B，)
* @apiGroup Book
* @apiName getPromotionBookListV2
* @apiSuccess {int} code 状态码
* @apiSuccess {String} msg 信息
* @apiSuccess {object} data 结果集C
* @apiSuccess {Array} data.list 结果数据集
* @apiSuccess {Int} data.list.book_id bid
* @apiSuccess {String} data.list.book_name 书名
* @apiSuccess {String} data.list.cover_url 封面
* @apiSuccess {String} data.list.book_category 类型
* @apiSuccess {String} data.list.book_end_status 完结状态
* @apiSuccess {String} data.list.recommend_index 编辑评级
* @apiSuccess {String} data.list.sex_preference 性别
* @apiSuccess {String} data.list.total_send_order_sum 全站派单指数
* @apiSuccess {String} data.list.week_send_order_sum 7天派单指数
* @apiSuccess {String} data.list.read_deep 深度阅读
* @apiSuccess {String} data.list.channel_send_order_sum 我的派单
* @apiSuccess {String} data.list.own_score 自主评级
* @apiSuccess {String} data.list.word_size 字数
* @apiSuccess {String} data.list.chapter_type 长篇or短片
* @apiSuccess {String} data.list.on_shelf_time 上架时间
* @apiSuccess {object} data.meta 分页信息
* @apiSuccess {Int} data.meta.total 总条数
* @apiSuccess {Int} data.meta.per_page 每页条数
* @apiSuccess {Int} data.meta.current_page 当前页
* @apiSuccess {Int} data.meta.sex_preference 性别偏好
* @apiSuccess {Int} data.meta.last_page 最后页
* @apiSuccess {String} data.meta.next_page_url 下一页
* @apiSuccess {String} data.meta.prev_page_url 上一页
* @apiSuccessExample {json} Success-Response:
* {
* "code": 0,
* "msg": "",
* "data": {
* "list": [
* {
* "book_id": 5,
* "book_name": "肌缘巧合",
* },
* ],
* "meta": {
* "total": 18,
* "per_page": 15,
* "current_page": 1,
* "last_page": 2,
* "next_page_url": "http://myapi.cn/api/hotrank/books?page=2",
* "prev_page_url": ""
* }
* }
* }
*/
public function getPromotionBookListV2(Request $request)
{
$data = [];
$where = [];
$orwhere = [];
$channel_id = $this->getChannelId();
$data['distribution_channel_id'] = $channel_id;
$channel_user = ChannelService::getUserIdById($channel_id);
$channel_user_id = $channel_user->channel_user_id;
$channel_user_info = ChannelUserService::getById($channel_user_id);
//获取重点渠道的额外书单
$bids = [];
if ($channel_user_info && !empty($channel_user_info->company_id)) {
$bids = CompanySpecialBookService::getBidByCompany($channel_user_info->company_id);
}
//隐藏的图书,搜不到，但不影响阅读
$hidden_book = env('HIDE_BOOKS');
$whereIn = [];
if ($hidden_book) {
$hidden_book_array = explode(',', $hidden_book);
$whereIn = $hidden_book_array;
if ($bids) {
$bids = array_diff($bids, $hidden_book_array);
}
}
//性别
$sex = $request->get('sex', 0);
if ($sex && in_array($sex, [1, 2])) {
$sex_str = ['', '男频', '女频'];
$where[] = ['book_categories.channel_name', '=', $sex_str[$sex]];
//$orwhere[] = ['book_categories.channel_name', '=', $sex_str[$sex]];
}
//自主评级
$own_score = $request->get('own_score');
if ($own_score && in_array($own_score, range('A', 'Z'))) {
$where[] = ['book_channel_scores.score', '=', $own_score];
//$orwhere[] = ['book_channel_scores.score', '=', $own_score];
}
//编辑评分
$score = $request->get('recommend_index');
if ($score && in_array($score, ['A', 'B', 'C', 'S', 'D', 'SS', 'A+']) && !$own_score) {
$score_number = ['SS' => [100, 110], 'S' => [95, 99], 'A+' => [90, 94], 'A' => [85, 89], 'B' => [80, 84], 'C' => [70, 79], 'D' => [0, 69]];
$where[] = ['book_configs.recommend_index', '>=', $score_number[$score][0]];
//$orwhere[] = ['book_configs.recommend_index', '>=', $score_number[$score][0]];
$where[] = ['book_configs.recommend_index', '<=', $score_number[$score][1]];
//$orwhere[] = ['book_configs.recommend_index', '<=', $score_number[$score][1]];
}
//上架时间
$onshelf = $request->get('onshelf');
if ($onshelf && in_array($onshelf, [7, 30, 90])) {
$where[] = ['book_configs.created_at', '>=', date('Y-m-d H:i:s', time() - $onshelf * 86400)];
//$orwhere[] = ['book_configs.created_at', '>=', date('Y-m-d H:i:s', time() - $onshelf * 86400)];
}
//分类
$category_id = $request->get('category_id');
if ($category_id) {
$where[] = ['books.category_id', '=', $category_id];
//$orwhere[] = ['books.category_id', '=', $category_id];
}
//字数
$size = $request->get('size');
if ($size && in_array($size, [1, 2, 3, 4, 5, 6])) {
$size_arr = [[], [200, -1], [100, 200], [20, 100], [0, 20], [20, -1], [0, 20]];
$where[] = ['books.size', '>=', $size_arr[$size][0] * 10000];
//$orwhere[] = ['books.size', '>=', $size_arr[$size][0] * 10000];
if ($size_arr[$size][1] != -1) {
$where[] = ['books.size', '<=', $size_arr[$size][1] * 10000];
// $orwhere[] = ['books.size', '<=', $size_arr[$size][1] * 10000];
}
}
//状态
$status = $request->get('status', -1);
if (in_array($status, [0, 1])) {
$where[] = ['books.status', '=', $status];
//$orwhere[] = ['books.status', '=', $status];
}
$key = $request->get('key','');
if ($key) {
$key = trim($key);
//$where[] = ['book_configs.book_name', 'like', '%' . $key . '%'];
//$orwhere[] = ['book_configs.book_name', 'like', '%' . $key . '%'];
}
//$superior_orwhere = [];
/*$where[] = ['book_configs.is_on_shelf', '=', 2];
//$is_on_shelf =2;
if ($bids) {
$orwhere[] = ['book_configs.is_on_shelf', '=', 1];
//$superior_orwhere[] = ['book_configs.is_on_shelf', '=', 1];
//$orwhere[] = ['book_configs.bid','in','('.implode(',',$bids).')'];
} else {
$orwhere = [];
}*/
//优质书库
$Superior = $request->input('superior',0);
//\Log::info('superior:'.$Superior);
//$Superior = $request->input('superior',0);
$whereDeedIn = [];
$superior_lib = '';
//排序
$order_field = $request->get('order_field','');
$order_type = $request->get('order_type', 'desc');
//$data['order_field'] = 'book_configs.recommend_index';
// $data['order_type'] = 'desc';
if ($order_field && in_array($order_field, ['order_index','recommend_index', 'total_send_order_sum', 'week_send_order_sum', 'read_deep', 'channel_send_order_sum', 'own_score'])) {
$data['order_field'] = $order_field;
if (!in_array($order_type, ['asc', 'desc'])) {
$order_type = 'desc';
}
$data['order_type'] = $order_type;
}
if($Superior==1){
$history_lib = SuperiorHistoryBookService::getSupriorBidList();
//array_merge($whereIn,$his);
$whereDeedIn=count($history_lib)>0?$history_lib:[0];
$superior_lib = 'superior_history_book';
$data['order_field'] = 'order_index';
//$superior_orwhere[] = ['book_configs.bid', 'in', $whereDeedIn];
}
if($Superior==2){
$new_lib = SuperiorNewBookService::getSupriorBidList();
//array_merge($whereIn,$his);
$whereDeedIn=count($new_lib)>0?$new_lib:['-1'];
$superior_lib = 'superior_new_book';
$data['order_field'] = 'superior_new_book.order_index';
$data['order_type'] = 'desc';
//$superior_orwhere[] = ['book_configs.bid', 'in', $whereDeedIn];
}
if($Superior==3){
$where[]=['book_configs.is_current_week_promotion','=',1];
$data['order_field'] = 'recommend_index';
$data['order_type'] = 'desc';
}
if($Superior ==1) $data['order_type'] = 'asc';
$result = BookConfigService::getPromotionBooksV2($where, $whereIn, $data, $bids, $whereDeedIn,$superior_lib,$key);
if ($result) {
$total_send_order = (int)DB::table('send_orders')->max('id');
$week_send_order = (int)DB::table('send_orders')->where('created_at', '>=', date('Y-m-d', strtotime('-7 day')))->count();
foreach ($result as &$v) {
if ($total_send_order > 0) {
$rate = (round($v->total_send_order_sum / $total_send_order, 4)) * 10000;
$v->total_send_order_sum = $this->sendOrderIndex($rate);
}
$v->week_send_order_bid = $v->week_send_order_sum;
if ($week_send_order > 0) {
$rate = (round($v->week_send_order_sum / $week_send_order, 4)) * 10000;
$v->week_send_order_sum = $this->sendOrderIndex($rate);
}
$v->week_send_order = $week_send_order;
}
}
return response()->pagination(new BookV2Transformer(), $result);
}
private function sendOrderIndex($rate)
{
if ($rate < 1) {
return 60;
}
if ($rate >= 200) {
return 100;
} elseif ($rate >= 100) {
return 98;
} elseif ($rate >= 60) {
return 96;
} else {
if ($rate >= 10) {
return 96 - ceil((60 - $rate) / 10) * 2;
} else {
return 96 - 12 - ceil((10 - $rate)) * 2;
}
}
}
/**
* @apiVersion 1.0.0
* @apiDescription 排行榜
* @api {get} book/getRanks 排行榜
* @apiParam {String} type 类型{new:新书榜,sale_total:销售总榜,sale_half_month:半月榜,recommend:编辑推荐}
* @apiGroup Book
* @apiName getRanks
* @apiSuccess {int} code 状态码
* @apiSuccess {String} msg 信息
* @apiSuccess {object} data 结果集
* @apiSuccess {Int} data.book_id bid
* @apiSuccess {String} data.book_name 书名
* @apiSuccess {String} data.book_summary 简介
* @apiSuccess {String} data.book_author 作者
* @apiSuccess {String} data.cover_url 封面
* @apiSuccess {Int} data.book_word_count 字数
* @apiSuccess {Int} data.book_chapter_total 章节数
* @apiSuccess {Int} data.book_category_id 分类
* @apiSuccess {String} data.book_category 分类名
* @apiSuccess {String} data.book_end_status 是否完结
* @apiSuccess {String} data.promotion_count 推广次数
* @apiSuccess {String} data.book_published_time 发布时间
* @apiSuccess {String} data.copyright 版权信息
* @apiSuccess {Int} data.force_subscribe_chapter_seq 强制关注的章节序号
* @apiSuccess {String} data.update_time 更新时间
* @apiSuccess {Int} data.is_on_shelf 是否上架
* @apiSuccess {String} data.book_price 价格
* @apiSuccess {String} data.recommend_index 推荐指数
* @apiSuccess {Int} data.charge_type 收费类型(BOOK: 按本收费，CHAPTER： 按章收费)
* @apiSuccess {Int} data.keyword 关键词
* @apiSuccess {Int} data.is_show_index_content 是否显示推荐指数文本
* @apiSuccess {Int} data.click_count 点击数
* @apiSuccessExample {json} Success-Response:
* {
* "code": 0,
* "msg": "",
* "data": {
* [
* {
* "book_id": 5,
* "book_name": "肌缘巧合",
* "book_summary": " 他是权势倾天，纵横商界的王者，却偏偏钟情于她，一宠成瘾。“女人，我要你......只要你能满足我，别墅、游轮、支票，你随便挑。”她羞涩的半低着头：“我只想要你。”他挑眉，“你野心不小啊！”她妩媚一笑，解开他的领带，“难道你不愿意！”他宠她爱她，给她所有想要的。只是有一天她终于忍不住暴走，“靠，你有没有节制呀？我要离婚。”",
* "book_author": "妖火",
* "cover_url": "http://www.leyuee.com/cover/0/8.jpg",
* "book_word_count": 0,
* "book_chapter_total": 0,
* "book_category_id": null,
* "book_category": "爆笑,宠文,潜规则",
* "book_end_status": 8,
* "promotion_count": 12,
* "sex_preference":"女频",
* "book_published_time": null,
* "copyright": null,
* "charge_type": null,
* "force_subscribe_chapter_seq": 0,
* "update_time": null,
* "is_on_shelf": 1,
* "book_price": null,
* "keyword": "温馨,虐心,清水",
* "recommend_index":2,
* "is_show_index_content":0,
* "click_count":0
* },
* ]
* }
* }
*/
function getRanks(Request $request)
{
$type = $request->input('type');
if (!$type) {
return response()->error("PARAM_EMPTY");
}
$flush = $request->input('flush');
$book = [];
$channel_user_id = $this->getChannelUserId();
$channel_user_info = ChannelUserService::getById($channel_user_id);
$company = CompanyService::getCompany($channel_user_info->company_id);
$on_shelf = [2];
$important = 'unimportant';
$important_books = null;
if ($company && $company->is_important == 1) {
$bids = [];
$bids = CompanySpecialBookService::getBidByCompany($channel_user_info->company_id);
//隐藏的图书,搜不到，但不影响阅读
$hidden_book = env('HIDE_BOOKS');
if ($hidden_book) {
$hidden_book_array = explode(',', $hidden_book);
if ($bids) {
$bids = array_diff($bids, $hidden_book_array);
}
}
if ($bids) {
$important_books = BookConfigService::getBooksByIds($bids, ['book_configs.created_at', 'desc']);
}
$important = 'important';
}
$key = 'channel_book_rank_' . $type . '_' . $important;
if ($flush == 1) {
Cache::forget($key);
}
$cache = Cache::get($key, []);
if ($cache) {
$cache = json_decode($cache);
return response()->collection(new BookTransformer(), $cache);
}
switch ($type) {
case 'new':
$order = [['book_configs.created_at', 'desc'], ['book_configs.recommend_index', 'desc']];
$book = BookConfigService::getBooksNoPage([], $order, $on_shelf, 20);
$book = $this->sortBooks($important_books, $book);
break;
case 'sale_total';
$start = date('Y-m') . '-01';
$end = date('Y-m-d');
$bids = BookOrderStatistical::getTopSaleBooks($start, $end, $on_shelf, 20);
$id = [];
foreach ($bids as $v) {
$id[] = $v->bid;
}
if ($id) {
$book = BookConfigService::getBooksByIds($id);
}
break;
case 'sale_half_month':
$start = date('Y-m-d', strtotime('-14 day'));
$end = date('Y-m-d');
$bids = BookOrderStatistical::getTopSaleBooks($start, $end, $on_shelf, 10);
$id = [];
foreach ($bids as $v) {
$id[] = $v->bid;
}
if ($id) {
$book = BookConfigService::getBooksByIds($id);
}
break;
case 'recommend':
$id_arr = env('CHANNEL_RECOMMEND_BIDS', '');
$redis_field = 'unimportant';
if ($important == 'important') {
$redis_field = 'important';
$id_arr = env('CHANNEL_RECOMMEND_IMPORTANT_BIDS', '');
}
$ids = Redis::hget('channel_recomm_books', $redis_field);
if ($ids) $id_arr = $ids;
if ($id_arr) {
$book = BookConfigService::getBooksByIds(explode(',', $id_arr));
}
break;
}
if ($book) {
Cache::put($key, json_encode($book), 60);
}
return response()->collection(new BookTransformer(), $book);
}
private function sortBooks($book1, $book2)
{
if (!$book1)
return $book2;
$book1 = $book1->filter(function ($value) {
return $value->is_on_shelf = 1;
});
return $book2->concat($book1)->sortByDesc('created_at')->slice(0, 20);
}
}