SystemUserTask.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456
  1. <?php
  2. namespace app\models\system;
  3. use app\models\store\StoreOrder;
  4. use app\models\user\User;
  5. use app\models\user\UserBill;
  6. use app\models\user\UserLevel;
  7. use app\models\user\UserTaskFinish;
  8. use crmeb\traits\ModelTrait;
  9. use crmeb\basic\BaseModel;
  10. /**
  11. * TODO 设置等级任务Model
  12. * Class SystemUserTask
  13. * @package app\models\system
  14. */
  15. class SystemUserTask extends BaseModel
  16. {
  17. /**
  18. * 数据表主键
  19. * @var string
  20. */
  21. protected $pk = 'id';
  22. /**
  23. * 模型名称
  24. * @var string
  25. */
  26. protected $name = 'system_user_task';
  27. use ModelTrait;
  28. /**
  29. * 任务类型
  30. * type 记录在数据库中用来区分任务
  31. * name 任务名 (任务名中的{$num}会自动替换成设置的数字 + 单位)
  32. * max_number 最大设定数值 0为不限定
  33. * min_number 最小设定数值
  34. * unit 单位
  35. * */
  36. protected static $TaskType = [
  37. [
  38. 'type' => 'SatisfactionIntegral',
  39. 'name' => '满足积分{$num}',
  40. 'real_name' => '积分数',
  41. 'max_number' => 0,
  42. 'min_number' => 0,
  43. 'unit' => '分'
  44. ],
  45. [
  46. 'type' => 'ConsumptionAmount',
  47. 'name' => '消费满{$num}',
  48. 'real_name' => '消费金额',
  49. 'max_number' => 0,
  50. 'min_number' => 0,
  51. 'unit' => '元'
  52. ],
  53. [
  54. 'type' => 'ConsumptionFrequency',
  55. 'name' => '消费{$num}',
  56. 'real_name' => '消费次数',
  57. 'max_number' => 0,
  58. 'min_number' => 0,
  59. 'unit' => '次'
  60. ],
  61. [
  62. 'type' => 'CumulativeAttendance',
  63. 'name' => '累计签到{$num}',
  64. 'real_name' => '累计签到',
  65. 'max_number' => 365,
  66. 'min_number' => 1,
  67. 'unit' => '天'
  68. ],
  69. [
  70. 'type' => 'SharingTimes',
  71. 'name' => '分享给朋友{$num}',
  72. 'real_name' => '分享给朋友',
  73. 'max_number' => 1000,
  74. 'min_number' => 1,
  75. 'unit' => '次'
  76. ],
  77. [
  78. 'type' => 'InviteGoodFriends',
  79. 'name' => '邀请好友{$num}成为下线',
  80. 'real_name' => '邀请好友成为下线',
  81. 'max_number' => 1000,
  82. 'min_number' => 1,
  83. 'unit' => '人'
  84. ],
  85. [
  86. 'type' => 'InviteGoodFriendsLevel',
  87. 'name' => '邀请好友{$num}成为会员',
  88. 'real_name' => '邀请好友成为会员',
  89. 'max_number' => 1000,
  90. 'min_number' => 1,
  91. 'unit' => '人'
  92. ],
  93. [
  94. 'type' => 'TeamOrder',
  95. 'name' => '团队满{$num}单',
  96. 'real_name' => '团队单数',
  97. 'max_number' => 0,
  98. 'min_number' => 0,
  99. 'unit' => '单'
  100. ],
  101. ];
  102. public function profile()
  103. {
  104. return $this->hasOne('SystemUserLevel', 'level_id', 'id')->field('name');
  105. }
  106. public static function getTaskTypeAll()
  107. {
  108. return self::$TaskType;
  109. }
  110. /**
  111. * 获取某个任务
  112. * @param string $type 任务类型
  113. * @return array
  114. * */
  115. public static function getTaskType($type)
  116. {
  117. foreach (self::$TaskType as $item) {
  118. if ($item['type'] == $type) return $item;
  119. }
  120. }
  121. /**
  122. * 设置任务名
  123. * @param string $type 任务类型
  124. * @param int $num 预设值
  125. * @return string
  126. * */
  127. public static function setTaskName($type, $num)
  128. {
  129. $systemType = self::getTaskType($type);
  130. return str_replace('{$num}', $num . $systemType['unit'], $systemType['name']);
  131. }
  132. /**
  133. * 累计消费金额
  134. * @param int $task_id 任务id
  135. * @param int $uid 用户id
  136. * @param int $start_time 开始时间
  137. * @param int $number 限定时间
  138. * @return boolean
  139. * */
  140. public static function ConsumptionAmount($task_id, $uid = 0, $start_time = 0, $number = 0)
  141. {
  142. $isComplete = false;
  143. $SumPayPrice = User::where('uid',$uid)->value('monetary');
  144. if ($SumPayPrice >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  145. dump($SumPayPrice >= $number);
  146. echo $number.'-'.$SumPayPrice;
  147. return ['还需消费{$num}元', $SumPayPrice, $isComplete];
  148. }
  149. /**
  150. * 累计消费次数
  151. * @param int $task_id 任务id
  152. * @param int $uid 用户id
  153. * @param int $start_time 开始时间
  154. * @param int $number 限定时间
  155. * @return boolean
  156. * */
  157. public static function ConsumptionFrequency($task_id, $uid = 0, $start_time = 0, $number = 0)
  158. {
  159. $isComplete = false;
  160. $countPay = StoreOrder::where('paid', 1)->where('refund_status', 0)->where('is_del', 0)->where('uid', $uid)->where('add_time', '>', $start_time)->count();
  161. if ($countPay >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  162. return ['还需消费{$num}次', $countPay, $isComplete];
  163. }
  164. /**
  165. * 邀请好友成为会员
  166. * @param int $task_id 任务id
  167. * @param int $uid 用户id
  168. * @param int $start_time 开始时间
  169. * @param int $number 限定时间
  170. * @return boolean
  171. * */
  172. public static function InviteGoodFriendsLevel($task_id, $uid = 0, $start_time = 0, $number = 0)
  173. {
  174. $isComplete = false;
  175. $uids = User::where('spread_uid', $uid)->where('spread_time', '>', $start_time)->column('uid', 'uid');
  176. $levelCount = count($uids) ? UserLevel::setUserLevelCount($uids) : 0;
  177. if ($levelCount >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  178. return ['还需邀请{$num}人成为会员', $levelCount, $isComplete];
  179. }
  180. /**
  181. * 邀请好友成为下线
  182. * @param int $task_id 任务id
  183. * @param int $uid 用户id
  184. * @param int $start_time 查询开始时间
  185. * @param int $number 限定数量
  186. * */
  187. public static function InviteGoodFriends($task_id, $uid = 0, $start_time = 0, $number = 0)
  188. {
  189. $isComplete = false;
  190. $spreadCount = User::where('spread_uid', $uid)->where('spread_time', '>', $start_time)->count();
  191. if ($spreadCount >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  192. return ['还需邀请{$num}人成为下线', $spreadCount, $isComplete];
  193. }
  194. /**
  195. * 满足积分
  196. * @param int $task_id 任务id
  197. * @param int $uid 用户id
  198. * @param int $start_time 查询开始时间
  199. * @param int $number 限定数量
  200. * @return Boolean
  201. * */
  202. public static function SatisfactionIntegral($task_id, $uid = 0, $start_time = 0, $number = 0)
  203. {
  204. $isComplete = false;
  205. $sumNumber = UserBill::where('uid', $uid)->where('category', 'integral')->where('pm', 1)->where('add_time', '>', $start_time)->where('type', 'in', ['system_add', 'sign', 'gain'])->sum('number');
  206. if ($sumNumber >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  207. return ['还需要{$num}经验', $sumNumber, $isComplete];
  208. }
  209. /**
  210. * 分享给朋友次数完成情况
  211. * @param int $task_id 任务id
  212. * @param int $uid 用户id
  213. * @param int $start_time 查询开始时间
  214. * @param int $number 限定数量
  215. * @return Boolean
  216. * */
  217. public static function SharingTimes($task_id, $uid = 0, $start_time = 0, $number = 0)
  218. {
  219. $isComplete = false;
  220. $sumCount = UserBill::where('uid', $uid)->where('category', 'share')->where('pm', 1)->where('add_time', '>', $start_time)->where('type', 'share')->count();
  221. if ($sumCount >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  222. return ['还需分享{$num}次', $sumCount, $isComplete];
  223. }
  224. /**
  225. * 统计单数
  226. * @param $task_id
  227. * @param int $uid
  228. * @param int $start_time
  229. * @param int $number
  230. * @return array
  231. */
  232. public static function TeamOrder($task_id, $uid = 0, $start_time = 0, $number = 0)
  233. {
  234. $isComplete = false;
  235. $sumCount = User::where('uid',$uid)->value('team_cts');
  236. if ($sumCount >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  237. return ['团队单数,还需{$num}单', $sumCount, $isComplete];
  238. }
  239. /**
  240. * 累计签到
  241. * @param int $task_id 任务id
  242. * @param int $uid 用户id
  243. * @param int $start_time 查询开始时间
  244. * @param int $number 限定数量
  245. * @return Boolean
  246. * */
  247. public static function CumulativeAttendance($task_id, $uid = 0, $start_time = 0, $number = 0)
  248. {
  249. $isComplete = false;
  250. $sumCount = UserBill::where('uid', $uid)->where('category', 'integral')->where('pm', 1)->where('add_time', '>', $start_time)->where('type', 'sign')->count();
  251. if ($sumCount >= $number) $isComplete = UserTaskFinish::setFinish($uid, $task_id) ? true : false;
  252. return ['还需签到{$num}天', $sumCount, $isComplete];
  253. }
  254. /**
  255. * 设置任务完成情况
  256. * @param int $task_id 任务id
  257. * @param int $uid 用户uid
  258. * @param int $start_time 查询开始时间
  259. * @return Boolean
  260. * */
  261. public static function setTaskFinish($task_id = 0, $uid = 0, $start_time = 0)
  262. {
  263. if (!$task_id) return self::setErrorInfo('缺少任务id参数');
  264. if (!$uid) return self::setErrorInfo('缺少用户uid');
  265. $task = self::where('id', $task_id)->where('is_show', 1)->find();
  266. if (!$task) return self::setErrorInfo('任务不存在');
  267. $task_type = $task->task_type;
  268. if ($task_type && method_exists(self::class, $task_type)) {
  269. try {
  270. $start_time = User::getCleanTime($uid);
  271. return self::$task_type($task_id, $uid, $start_time, $task->number);
  272. } catch (\Exception $e) {
  273. return self::setErrorInfo($e->getMessage());
  274. }
  275. }
  276. return self::setErrorInfo('没有此任务');
  277. }
  278. /**
  279. * 设置任务显示条件
  280. * @param string $alert 表别名
  281. * @param object $model 模型实例
  282. * @return object
  283. * */
  284. public static function visibleWhere($alert = '', $model = null)
  285. {
  286. $model = $model === null ? new self() : $model;
  287. if ($alert) $model = $model->alias($alert);
  288. $alert = $alert ? $alert . '.' : '';
  289. return $model->where("{$alert}is_show", 1);
  290. }
  291. /**
  292. * 获取等级会员任务列表
  293. * @param int $level_id 会员等级id
  294. * @param int $uid 用户id
  295. * @return array
  296. * */
  297. public static function getTashList($level_id, $uid = 0, $level = null, $expire = 1400)
  298. {
  299. $level_id = is_string($level_id) ? (int)$level_id : $level_id;
  300. $list = self::visibleWhere()->where('level_id', $level_id)->field('name,real_name,task_type,illustrate,number,id')->order('sort desc')->select();
  301. $list = count($list) ? $list->toArray() : [];
  302. if ($uid == 0) return $list;
  303. if ($level === null) $level = SystemUserLevel::getLevelInfo($uid);
  304. //获取下一个vip的id
  305. $LeveId = SystemUserLevel::getNextLevelId($level['id']);
  306. $is_clear = SystemUserLevel::getClear($level['id']);
  307. if ($is_clear == false && $LeveId == $level_id) $is_clear = true;
  308. $reach_count = self::getTaskComplete($level_id, $uid, true);
  309. return [
  310. 'list' => $list,
  311. 'reach_count' => $reach_count,
  312. 'task' => self::tidyTask($list, $uid, $is_clear, User::getCleanTime($uid)),
  313. ];
  314. }
  315. /**
  316. * 获取未完成任务的详细值
  317. * @param array $item 任务
  318. * @param int $uid 用户id
  319. * @param int $startTime 开始时间
  320. * @return array
  321. * */
  322. protected static function set_task_type($item, $uid, $startTime = 0)
  323. {
  324. $task = ['task_type_title' => '', 'new_number' => 0, 'speed' => 0, 'finish' => 0];
  325. $task_type = $item['task_type'];
  326. switch ($task_type) {
  327. case 'SatisfactionIntegral':
  328. case 'ConsumptionAmount':
  329. case 'ConsumptionFrequency':
  330. case 'CumulativeAttendance':
  331. case 'SharingTimes':
  332. case 'InviteGoodFriends':
  333. case 'InviteGoodFriendsLevel':
  334. case 'TeamOrder':
  335. try {
  336. list($task_type_title, $num, $isComplete) = self::$task_type($item['id'], $uid, $startTime, $item['number']);
  337. if ($isComplete) {
  338. $task['finish'] = 1;
  339. $task['speed'] = 100;
  340. $task['speed'] = $item['number'];
  341. $task['new_number'] = $item['number'];
  342. } else {
  343. $numdata = bcsub($item['number'], $num, 0);
  344. $task['task_type_title'] = str_replace('{$num}', $numdata, $task_type_title);
  345. $task['speed'] = bcdiv($num, $item['number'], 2);
  346. $task['speed'] = bcmul($task['speed'], 100, 0);
  347. $task['new_number'] = $num;
  348. }
  349. } catch (\Exception $e) {
  350. }
  351. break;
  352. }
  353. return [$task['new_number'], $task['speed'], $task['task_type_title'], $task['finish']];
  354. }
  355. /**
  356. * 设置任务完成状态,已被使用
  357. * @param int $level_id 会员id
  358. * @param int $uid 用户id
  359. * @return Boolean
  360. * */
  361. public static function setTarkStatus($level_id, $uid)
  362. {
  363. $taskIds = self::visibleWhere()->where('level_id', $level_id)->column('id', 'id');
  364. if (!count($taskIds)) return true;
  365. return UserTaskFinish::where('uid', $uid)->where('task_id', 'in', $taskIds)->update(['status' => 1]);
  366. }
  367. /**
  368. * 检查当前等级是否完成全部任务
  369. * @param int $level_id 会员id
  370. * @param int $uid 用户uid
  371. * @return boolean
  372. * */
  373. public static function getTaskComplete($level_id, $uid, $isCount = false)
  374. {
  375. $taskIds = self::visibleWhere()->where('level_id', $level_id)->column('id', 'id');
  376. $taskIdsCount = count($taskIds);
  377. //如果当前会员没有任务默认为直接升级为下一等级
  378. if ($taskIdsCount) {
  379. if ($isCount) {
  380. return UserTaskFinish::group('task_id')->where('uid', $uid)->where('task_id', 'in', $taskIds)->count();
  381. } else {
  382. $finishCount = UserTaskFinish::group('task_id')->where('status', $isCount ? 1 : 0)->where('uid', $uid)->where('task_id', 'in', implode(',', $taskIds))->count();
  383. }
  384. //如果当前任务有完成其一的,查询当前完成的任务数量,如果有任务完成则达成当前vip
  385. if (self::visibleWhere()->where('id', 'in', implode(',', $taskIds))->where('is_must', 0)->count() && $finishCount) {
  386. return true;
  387. }
  388. return $finishCount >= $taskIdsCount;
  389. }
  390. if ($isCount) return 0;
  391. //如果没有设置任务当前等级无需购买则返回false
  392. if (SystemUserLevel::be(['id' => $level_id, 'is_pay' => 0])) return false;
  393. return true;
  394. }
  395. /**
  396. * 设置任务内容完成情况
  397. * @param array $task 任务列表
  398. * @param int $uid 用户id
  399. * @热图图呢 array
  400. * */
  401. public static function tidyTask($task, $uid, $is_clear, $startTime)
  402. {
  403. if (!is_array($task)) return $task;
  404. foreach ($task as &$item) {
  405. //如果已完成该任务进度直接为100
  406. if (UserTaskFinish::where('uid', $uid)->where('task_id', $item['id'])->count()) {
  407. $item['new_number'] = $item['number'];
  408. $item['speed'] = 100;
  409. $item['finish'] = 1;
  410. $item['task_type_title'] = '';
  411. } else {
  412. // if($is_clear){
  413. list($new_number, $speed, $task_type_title, $finish) = self::set_task_type($item, $uid, $startTime);
  414. $item['new_number'] = $new_number;
  415. $item['speed'] = $speed;
  416. $item['task_type_title'] = $task_type_title;
  417. $item['finish'] = $finish;
  418. // }else {
  419. // list($new_number, $speed, $task_type_title, $finish) = self::set_task_type($item,-1,time()+86400);
  420. // $item['new_number'] = $new_number;
  421. // $item['speed'] = $speed;
  422. // $item['task_type_title'] = $task_type_title;
  423. // $item['finish'] = $finish;
  424. // }
  425. }
  426. }
  427. return $task;
  428. }
  429. }