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\merchant\model\special;
- use basic\ModelBasic;
- use traits\ModelTrait;
- use think\Db;
- use app\merchant\model\special\SpecialWatch;
- use app\merchant\model\special\Special;
- use service\PhpSpreadsheetService;
- /**浏览记录
- * Class LearningRecords
- * @package app\merchant\model\special
- */
- class LearningRecords extends ModelBasic
- {
- use ModelTrait;
- /**最后学习时间
- * @param $id
- * @param $uid
- * @return mixed
- */
- public static function lastStudyTime($id, $uid)
- {
- return self::where(['special_id' => $id, 'uid' => $uid])->value('add_time');
- }
- /**条件处理
- * @param $where
- */
- public static function getOrderWhere($where, $id)
- {
- $model = self::alias('l')->join('User u', 'l.uid=u.uid')
- ->join('Special s', 'l.special_id=s.id', 'left');
- if ($id) $model = $model->where('l.special_id', $id);
- if (isset($where['uid']) && $where['uid']) $model = $model->where('l.uid', $where['uid']);
- if (isset($where['mer_id']) && $where['mer_id']) $model = $model->where('s.mer_id', $where['mer_id']);
- $model = $model->group('l.uid');
- if ($where['data'] != '') {
- $model = self::getModelTime($where, $model, 'l.add_time');
- }
- $model = $model->order('l.add_time desc')->field('l.uid,l.special_id,l.add_time,s.id,s.type,s.title,s.is_light,u.nickname,u.phone,u.level');
- return $model;
- }
- /**学习记录
- * @param $where
- * @param $id
- */
- public static function specialLearningRecordsLists($where, $id)
- {
- $model = self::getOrderWhere($where, $id);
- if (isset($where['excel']) && $where['excel'] == 1) {
- $data = ($data = $model->select()) && count($data) ? $data->toArray() : [];
- } else {
- $data = ($data = $model->page((int)$where['page'], (int)$where['limit'])->select()) && count($data) ? $data->toArray() : [];
- }
- foreach ($data as $key => &$value) {
- $value['last_study_time'] = date('Y-m-d', $value['add_time']);
- }
- if (isset($where['excel']) && $where['excel'] == 1) {
- self::SaveExcel($data);
- }
- $count = self::getOrderWhere($where, $id)->count();
- return compact('count', 'data');
- }
- /**
- * 保存并下载excel
- * $list array
- * return
- */
- public static function SaveExcel($list)
- {
- $export = [];
- foreach ($list as $index => $item) {
- $export[] = [
- $item['uid'],
- $item['nickname'],
- $item['phone'],
- $item['level'] == 1 ? '会员' : '非会员',
- $item['title'],
- $item['percentage'],
- $item['last_study_time']
- ];
- }
- $filename = '学习记录' . time() . '.xlsx';
- $head = ['UID', '昵称', '电话', '身份', '专题名称', '观看进度%', '最后学习时间'];
- PhpSpreadsheetService::outdata($filename, $export, $head);
- }
- }
|