123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102 |
- <?php
- // +----------------------------------------------------------------------
- // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
- // +----------------------------------------------------------------------
- // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
- // +----------------------------------------------------------------------
- // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
- // +----------------------------------------------------------------------
- // | Author: CRMEB Team <admin@crmeb.com>
- // +----------------------------------------------------------------------
- namespace app\wap\model\special;
- use traits\ModelTrait;
- use basic\ModelBasic;
- /**
- * Class SpecialSource 专题素材关联表
- */
- class SpecialSource extends ModelBasic
- {
- use ModelTrait;
- /**获取专题素材
- * @param bool $special_id
- * @return false|\PDOStatement|string|\think\Collection
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\ModelNotFoundException
- * @throws \think\exception\DbException
- */
- public static function getSpecialSource($special_id = false, $source_id = false, $limit = false, $page = false, $order = 0)
- {
- $where = array();
- $data = self::where($where);
- if ($special_id) {
- if (is_array($special_id)) {
- $data->whereIn('special_id', $special_id);
- } else {
- $where['special_id'] = $special_id;
- $data->where($where);
- }
- }
- if ($source_id) {
- if (!is_array($source_id)) {
- $where['source_id'] = $source_id;
- $data->where($where);
- } else {
- $data->whereIn('source_id', $source_id);
- }
- }
- if ($page) {
- $data->page((int)$page, !$limit ? 10 : (int)$limit);
- }
- if ($order) {
- $data->order('sort asc,id asc');
- } else {
- $data->order('sort desc,id desc');
- }
- return $data->select();
- }
- /**专栏里专题获取
- * @param int $special_id
- * @param bool $limit
- * @param bool $page
- * @param int $is_member
- * @param $type
- * @return false|\PDOStatement|string|\think\Collection
- * @throws \think\db\exception\DataNotFoundException
- * @throws \think\db\exception\ModelNotFoundException
- * @throws \think\exception\DbException
- */
- public static function get_special_source_list($special_id = 0, $is_member = 0, $type, $limit = false, $page = false, $order = 0)
- {
- $where = array();
- $data = self::alias('o');
- if ($special_id) {
- if (is_array($special_id)) {
- $data = $data->whereIn('o.special_id', $special_id);
- } else {
- $where['o.special_id'] = $special_id;
- $data = $data->where($where);
- }
- }
- if ($type == 5) {
- $data = $data->join('special s', 's.id=o.source_id')->where(['s.is_del' => 0, 's.status' => 1, 's.is_show' => 1]);
- if (!$is_member) {
- $data = $data->where('s.is_mer_visible', 0);
- }
- }
- if ($page) {
- $data->page((int)$page, !$limit ? 10 : (int)$limit);
- }
- if ($order) {
- $data->order('o.sort asc,o.id asc');
- } else {
- $data->order('o.sort desc,o.id desc');
- }
- return $data->select();
- }
- }
|