CertificateRecord.php 4.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124
  1. <?php
  2. // +----------------------------------------------------------------------
  3. // | CRMEB [ CRMEB赋能开发者,助力企业发展 ]
  4. // +----------------------------------------------------------------------
  5. // | Copyright (c) 2016~2022 https://www.crmeb.com All rights reserved.
  6. // +----------------------------------------------------------------------
  7. // | Licensed CRMEB并不是自由软件,未经许可不能去掉CRMEB相关版权
  8. // +----------------------------------------------------------------------
  9. // | Author: CRMEB Team <admin@crmeb.com>
  10. // +----------------------------------------------------------------------
  11. namespace app\wap\model\topic;
  12. use traits\ModelTrait;
  13. use basic\ModelBasic;
  14. use service\UtilService as Util;
  15. use app\wap\model\user\User;
  16. use app\wap\model\special\Special;
  17. use app\wap\model\topic\TestPaper;
  18. use app\wap\model\topic\Certificate;
  19. use app\wap\model\topic\ExaminationRecord;
  20. /**
  21. * 证书获取记录 Model
  22. * Class CertificateRecord
  23. */
  24. class CertificateRecord extends ModelBasic
  25. {
  26. use ModelTrait;
  27. /**查询条件
  28. * @param $uid
  29. * @return CertificateRecord
  30. */
  31. public static function setWhere($uid)
  32. {
  33. $model = self::where(['status' => 1, 'is_del' => 0, 'uid' => $uid]);
  34. return $model;
  35. }
  36. /**获得证书列表
  37. * @param $uid
  38. * @param $page
  39. * @param $limit
  40. */
  41. public static function getUserCertificate($uid, $page, $limit)
  42. {
  43. $certificateList = Certificate::select();
  44. $certificateList1 = [];
  45. foreach ($certificateList as $v){
  46. $certificateList1[$v['id']] = $v;
  47. }
  48. $list = self::setWhere($uid)->page((int)$page, (int)$limit)->select();
  49. $list = count($list) > 0 ? $list->toArray() : [];
  50. foreach ($list as $key => &$value) {
  51. $value['certtitle'] = $certificateList1[$value['cid']]['title'];
  52. $value['content'] = self::certificate($value['source_id'], $value['obtain']);
  53. }
  54. return $list;
  55. }
  56. public static function certificate($source_id, $obtain)
  57. {
  58. switch ($obtain) {
  59. case 1:
  60. return Special::where(['id' => $source_id])->field('title,image')->find();
  61. break;
  62. case 2:
  63. return TestPaper::alias('t')->join('ExaminationRecord e', 't.id=e.test_id')
  64. ->where(['t.id' => $source_id, 'is_submit' => 1])->order('e.id desc')
  65. ->field('t.title,t.item_number,e.wrong_question,e.duration')->find();
  66. break;
  67. }
  68. }
  69. /**获取证书信息
  70. * @param $id
  71. * @param $obtain
  72. * @param $uid
  73. * @return array|bool|false|\PDOStatement|string|\think\Model
  74. * @throws \think\db\exception\DataNotFoundException
  75. * @throws \think\db\exception\ModelNotFoundException
  76. * @throws \think\exception\DbException
  77. */
  78. public static function getCertificate($id, $obtain, $uid)
  79. {
  80. $certificate = self::setWhere($uid)->where(['id' => $id, 'obtain' => $obtain])->find();
  81. if (!$certificate) return [];
  82. $realname = User::where('uid', $uid)->value('realname');
  83. $certificate['certificate'] = Certificate::getone($certificate['cid'], $obtain);
  84. $certificate['realname'] = $realname ? $realname : $certificate['nickname'];
  85. return $certificate;
  86. }
  87. /**领取证书
  88. * @param $id
  89. */
  90. public static function getUserTheCertificate($id, $obtain, $uid)
  91. {
  92. $cid = CertificateRelated::where(['related' => $id, 'obtain' => $obtain, 'is_show' => 1])->value('cid');
  93. if (!$cid) return false;
  94. $record = self::setWhere($uid)->where(['source_id' => $id, 'obtain' => $obtain])->find();
  95. if ($record) return false;
  96. $nickname = User::where('uid', $uid)->value('nickname');
  97. $realname = User::where('uid', $uid)->value('realname');
  98. $data = [
  99. 'cid' => $cid,
  100. 'uid' => $uid,
  101. 'nickname' => $realname ? $realname : $nickname,
  102. 'source_id' => $id,
  103. 'obtain' => $obtain,
  104. 'status' => 1,
  105. 'add_time' => time()
  106. ];
  107. $res = self::insertGetId($data);
  108. $res1 = false;
  109. if ($res) {
  110. $res1 = Certificate::where('id', $cid)->setInc('number');
  111. }
  112. if ($res && $res1) return $res;
  113. else return false;
  114. }
  115. }