123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254 |
- <?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\merchant\model\special;
- use app\merchant\model\special\Special as SpecialModel;
- use traits\ModelTrait;
- use basic\ModelBasic;
- /**
- * Class SpecialSource 专题素材关联表
- * @package app\merchant\model\special
- */
- class SpecialSource extends ModelBasic
- {
- use ModelTrait;
- public static function setWhere($special_id)
- {
- $model = self::alias('s')->where(['s.special_id' => $special_id, 't.is_del' => 0, 't.is_show' => 1])
- ->join('SpecialTask t', 's.source_id=t.id')->field('t.title,t.image,t.is_del,t.is_show,s.*');
- return $model;
- }
- /**查看专题下的素材
- * @param int $special_id
- * @param int $page
- * @param int $limit
- */
- public static function getSpecialSourceList($special_id = 0, $page = 1, $limit = 20, $order = 0)
- {
- $data = self::setWhere($special_id)->page($page, $limit);
- if ($order) {
- $data = $data->order('s.sort asc,s.id asc')->select();
- } else {
- $data = $data->order('s.sort desc,s.id desc')->select();
- }
- $count = self::setWhere($special_id)->count();
- return compact('data', 'count');
- }
- public static function setSpecialWhere($special_id)
- {
- $model = self::alias('s')->where(['s.special_id' => $special_id, 'l.is_del' => 0, 'l.is_show' => 1, 'l.status' => 1])
- ->join('Special l', 's.source_id=l.id')->field('l.title,l.image,l.type,l.is_show,l.is_del,l.light_type,l.is_light,s.special_id,s.source_id,s.sort,s.pay_status,s.id');
- return $model;
- }
- /**查看专栏专题下的专题
- * @param int $special_id
- * @param int $page
- * @param int $limit
- */
- public static function getSpecialList($special_id = 0, $page = 1, $limit = 20, $order = 0)
- {
- $data = self::setSpecialWhere($special_id)->page($page, $limit);
- if ($order) {
- $data = $data->order('s.sort asc,s.id asc')->select();
- } else {
- $data = $data->order('s.sort desc,s.id desc')->select();
- }
- $count = self::setSpecialWhere($special_id)->count();
- return compact('data', 'count');
- }
- /**新增素材
- * @param $ids
- * @param int $special_id
- * @param int $special_type
- * @return bool
- */
- public static function addSpecialSource($ids, $special_id = 0, $special_type = 1)
- {
- if (!$ids || !$special_id) return false;
- try {
- $source_list_ids = explode(',', $ids);
- $inster['special_id'] = $special_id;
- $data = SpecialModel::where('id', $special_id)->field('pay_type,member_pay_type,validity')->find();
- if (!$data) return false;
- foreach ($source_list_ids as $sk => $id) {
- if ($special_type == SPECIAL_COLUMN) {
- $special = SpecialModel::where('id', $id)->field('pay_type,member_pay_type')->find();
- if ($data['pay_type'] == 1 && $data['member_pay_type'] == 0) {
- if ($special['pay_type'] == 1 && $special['member_pay_type'] == 1) {
- SpecialModel::where('id', $id)->update(['member_pay_type' => 0, 'member_money' => 0]);
- }
- $inster['pay_status'] = 1;
- } else if ($data['pay_type'] == 0) {
- if ($special['pay_type'] == 1) {
- SpecialModel::where('id', $id)->update(['member_pay_type' => 0, 'member_money' => 0, 'pay_type' => 0, 'money' => 0]);
- }
- $inster['pay_status'] = 0;
- }
- SpecialModel::where('id', $id)->update(['validity' => $data['validity']]);
- } else {
- $inster['pay_status'] = 1;
- }
- $inster['type'] = $special_type;
- $inster['source_id'] = $id;
- $inster['add_time'] = time();
- $res = self::set($inster);
- if ($res) {
- SpecialModel::where('id', $special_id)->setInc('quantity', 1);
- } else {
- continue;
- }
- }
- return true;
- } catch (\Exception $e) {
- return false;
- }
- }
- /**获取专题素材
- * @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, $order = 0)
- {
- $where = array();
- $data = self::where($where);
- if ($special_id && is_numeric($special_id)) {
- $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 ($order) {
- $data->order('sort asc,id asc');
- } else {
- $data->order('sort desc,id desc');
- }
- return $data->select();
- }
- /**获取专题下素材数量
- * @param bool $special_id
- * @param bool $source_id
- */
- public static function getSpecialSourceCount($special_id = false, $source_id = false)
- {
- $where = array();
- $data = self::where($where);
- if ($special_id && is_numeric($special_id)) {
- $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);
- }
- }
- return $data->count();
- }
- /**更新及添加专题素材
- * @param $source_list_ids 一维数组,素材id
- * @param int $special_id 专题id
- * @return bool
- */
- public static function saveSpecialSource($source_list_ids, $special_id = 0, $special_type = 1, $data = [])
- {
- if (!$special_id || !is_numeric($special_id)) {
- return false;
- }
- if (!$source_list_ids || !is_array($source_list_ids)) {
- return false;
- }
- try {
- $specialSourceAll = self::getSpecialSource($special_id);
- $specialSourceAll = count($specialSourceAll) > 0 ? $specialSourceAll->toArray() : [];
- if ($specialSourceAll) {
- self::where(['special_id' => $special_id])->delete();
- SpecialModel::where('id', $special_id)->update(['quantity' => 0]);
- }
- $inster['special_id'] = $special_id;
- foreach ($source_list_ids as $sk => $sv) {
- if ($special_type == SPECIAL_COLUMN) {
- $special = SpecialModel::where('id', $sv->id)->field('pay_type,member_pay_type')->find();
- if ($data['pay_type'] == 1 && $data['member_pay_type'] == 0) {
- if ($special['pay_type'] == 1 && $special['member_pay_type'] == 1) {
- SpecialModel::where('id', $sv->id)->update(['member_pay_type' => 0, 'member_money' => 0]);
- }
- $inster['pay_status'] = 1;
- } else if ($data['pay_type'] == 0) {
- if ($special['pay_type'] == 1) {
- SpecialModel::where('id', $sv->id)->update(['member_pay_type' => 0, 'member_money' => 0, 'pay_type' => 0, 'money' => 0]);
- }
- $inster['pay_status'] = 0;
- }
- $dat['validity'] = $data['validity'];
- $dat['is_mer_visible'] = $data['is_mer_visible'];
- SpecialModel::edit($dat, $sv->id, 'id');
- } else {
- $inster['pay_status'] = $sv->pay_status;
- }
- $inster['source_id'] = $sv->id;
- $inster['type'] = $special_type;
- $inster['sort'] = $sv->sort;
- $inster['add_time'] = time();
- $res = self::set($inster);
- if ($res) {
- SpecialModel::where('id', $special_id)->setInc('quantity', 1);
- } else {
- continue;
- }
- }
- return true;
- } catch (\Exception $e) {
- return false;
- }
- }
- /**清空专题素材
- * @param int $special_id 专题id
- */
- public static function delSpecialSource($special_id = 0)
- {
- if (!$special_id || !is_numeric($special_id)) {
- return false;
- }
- try {
- $specialSourceAll = self::getSpecialSource($special_id);
- $specialSourceAll = count($specialSourceAll) > 0 ? $specialSourceAll->toArray() : [];
- if ($specialSourceAll) {
- self::where(['special_id' => $special_id])->delete();
- SpecialModel::where('id', $special_id)->update(['quantity' => 0]);
- }
- return true;
- } catch (\Exception $e) {
- return false;
- }
- }
- }
|