Relation.php 5.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139
  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\merchant\model\system;
  12. use traits\ModelTrait;
  13. use basic\ModelBasic;
  14. use service\UtilService as Util;
  15. use app\merchant\model\user\User;
  16. use app\merchant\model\special\Special;
  17. use app\merchant\model\download\DataDownload;
  18. /**
  19. * 关联记录 Model
  20. * Class Relation
  21. * @package app\merchant\model\questions
  22. */
  23. class Relation extends ModelBasic
  24. {
  25. use ModelTrait;
  26. public static function setWhere($relationship = 0, $relationship_id = 0)
  27. {
  28. return self::where(['is_del' => 0, 'relationship' => $relationship, 'relationship_id' => $relationship_id]);
  29. }
  30. public static function getSpecialJion($relationship_id, $relationship)
  31. {
  32. return self::alias('r')->join('Special s', 'r.relation_id=s.id')
  33. ->where(['r.is_del' => 0, 's.is_show' => 1, 's.is_del' => 0, 's.status' => 1,'r.relationship' => $relationship, 'r.relationship_id' => $relationship_id])
  34. ->field('s.type,s.title,s.is_light,s.light_type,s.mer_id,s.image,s.id,r.sort,r.id as rid,r.relationship,r.relationship_id');
  35. }
  36. /**获取试题关联的专题
  37. * @param $id
  38. */
  39. public static function getQuestionsRelationSpecial($relationship_id, $relationship)
  40. {
  41. $data = self::getSpecialJion($relationship_id, $relationship)->order('r.sort DESC,rid DESC')->select();
  42. $data = count($data) > 0 ? $data->toArray() : [];
  43. $count = self::getSpecialJion($relationship_id, $relationship)->count();
  44. return compact('data', 'count');
  45. }
  46. /**关联
  47. * @param $id
  48. * @param $special_ids
  49. * @param $relationship
  50. */
  51. public static function setRelations($id, $ids, $relationship)
  52. {
  53. $ids = explode(',', $ids);
  54. if (count($ids) <= 0) return false;
  55. foreach ($ids as $key => $value) {
  56. $data['relationship'] = $relationship;
  57. $data['relationship_id'] = $id;
  58. $data['relation_id'] = $value;
  59. if (self::be($data)) continue;
  60. $data['add_time'] = time();
  61. self::set($data);
  62. }
  63. return true;
  64. }
  65. /**修改排序
  66. * @param $id
  67. * @param $special_id
  68. * @param $value
  69. */
  70. public static function updateRelationSort($id, $special_id, $relationship, $value)
  71. {
  72. return self::where(['is_del' => 0, 'relationship' => $relationship, 'relationship_id' => $id, 'relation_id' => $special_id])->update(['sort' => $value]);
  73. }
  74. /**
  75. * @param $id
  76. * @param $special_id
  77. * @param $relationship
  78. */
  79. public static function delRelation($id, $special_id, $relationship)
  80. {
  81. return self::where(['is_del' => 0, 'relationship' => $relationship, 'relationship_id' => $id, 'relation_id' => $special_id])->delete();
  82. }
  83. public static function getTestPaperJion($relationship_id, $relationship)
  84. {
  85. return self::alias('r')->join('TestPaper t', 'r.relation_id=t.id')
  86. ->where(['r.is_del' => 0, 't.is_show' => 1, 't.is_del' => 0, 't.status' => 1,'r.relationship' => $relationship, 'r.relationship_id' => $relationship_id])
  87. ->field('t.type,t.title,t.id,r.sort,r.id as rid,r.relationship,r.relationship_id');
  88. }
  89. /**获取专题关联的考试或练习
  90. * @param $id
  91. * @param $relationship
  92. */
  93. public static function getRelationTestPaper($id, $relationship, $page, $limit)
  94. {
  95. $data = self::getTestPaperJion($id, $relationship)->page($page, $limit)->order('r.sort DESC,rid DESC')->select();
  96. $data = count($data) > 0 ? $data->toArray() : [];
  97. foreach ($data as $key => &$value) {
  98. if ($value['type'] == 1) {
  99. $value['types'] = '练习';
  100. } else {
  101. $value['types'] = '考试';
  102. }
  103. }
  104. $count = self::getTestPaperJion($id, $relationship)->count();
  105. return compact('data', 'count');
  106. }
  107. public static function getDataDownloadJion($relationship_id, $relationship)
  108. {
  109. return self::alias('r')->join('DataDownload d', 'r.relation_id=d.id')
  110. ->where(['r.is_del' => 0, 'd.is_show' => 1, 'd.is_del' => 0,'d.status' => 1, 'r.relationship' => $relationship, 'r.relationship_id' => $relationship_id])
  111. ->field('d.title,d.id,r.sort,r.id as rid,r.relationship,r.relationship_id');
  112. }
  113. /**获取专题关联的资料
  114. * @param $id
  115. * @param $relationship
  116. */
  117. public static function getRelationDataDownload($id, $relationship, $page, $limit)
  118. {
  119. $data = self::getDataDownloadJion($id, $relationship)->page($page, $limit)->order('r.sort DESC,rid DESC')->select();
  120. $data = count($data) > 0 ? $data->toArray() : [];
  121. $count = self::getDataDownloadJion($id, $relationship)->count();
  122. return compact('data', 'count');
  123. }
  124. }