Lessonslot.php 4.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163
  1. <?php
  2. namespace app\admin\model;
  3. use think\Model;
  4. class Lessonslot extends Model
  5. {
  6. // 表名
  7. protected $table = 'lesson_slot';
  8. // 自动写入时间戳字段
  9. protected $autoWriteTimestamp = false;
  10. // 定义时间戳字段名
  11. protected $createTime = false;
  12. protected $updateTime = false;
  13. protected $deleteTime = false;
  14. // 追加属性
  15. protected $append = [
  16. 'starttime_text',
  17. 'endtime_text',
  18. 'status_text',
  19. 'notice_status_text',
  20. 'finishtime_text',
  21. 'cancel_time_text',
  22. 'is_show_text',
  23. 'copy_status_text',
  24. ];
  25. protected static function init()
  26. {
  27. self::beforeInsert(function ($row) {
  28. $row->endtime = $row->starttime + ($row->hours * 3600);
  29. });
  30. self::beforeUpdate(function ($row){
  31. $row->endtime = $row->starttime + ($row->hours * 3600);
  32. });
  33. }
  34. public function getStatusList()
  35. {
  36. return ['0' => __('Status 0'), '20' => __('Status 20'), '30' => __('Status 30')];
  37. }
  38. public function getNoticeStatusList()
  39. {
  40. return ['0' => __('Notice_status 0'), '1' => __('Notice_status 1')];
  41. }
  42. public function getIsShowList()
  43. {
  44. return ['1' => __('Is_show 1'), '0' => __('Is_show 0')];
  45. }
  46. public function getCopyStatusList()
  47. {
  48. return ['1' => __('Copy_status 1'), '0' => __('Copy_status 0')];
  49. }
  50. public function getStarttimeTextAttr($value, $data)
  51. {
  52. $value = $value ? $value : (isset($data['starttime']) ? $data['starttime'] : '');
  53. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  54. }
  55. public function getEndtimeTextAttr($value, $data)
  56. {
  57. $value = $value ? $value : (isset($data['endtime']) ? $data['endtime'] : '');
  58. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  59. }
  60. public function getStatusTextAttr($value, $data)
  61. {
  62. $value = $value ? $value : (isset($data['status']) ? $data['status'] : '');
  63. $list = $this->getStatusList();
  64. return isset($list[$value]) ? $list[$value] : '';
  65. }
  66. public function getNoticeStatusTextAttr($value, $data)
  67. {
  68. $value = $value ? $value : (isset($data['notice_status']) ? $data['notice_status'] : '');
  69. $list = $this->getNoticeStatusList();
  70. return isset($list[$value]) ? $list[$value] : '';
  71. }
  72. public function getFinishtimeTextAttr($value, $data)
  73. {
  74. $value = $value ? $value : (isset($data['finishtime']) ? $data['finishtime'] : '');
  75. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  76. }
  77. public function getCancelTimeTextAttr($value, $data)
  78. {
  79. $value = $value ? $value : (isset($data['cancel_time']) ? $data['cancel_time'] : '');
  80. return is_numeric($value) ? date("Y-m-d H:i:s", $value) : $value;
  81. }
  82. protected function setStarttimeAttr($value)
  83. {
  84. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  85. }
  86. protected function setEndtimeAttr($value)
  87. {
  88. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  89. }
  90. protected function setFinishtimeAttr($value)
  91. {
  92. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  93. }
  94. protected function setCancelTimeAttr($value)
  95. {
  96. return $value === '' ? null : ($value && !is_numeric($value) ? strtotime($value) : $value);
  97. }
  98. public function getIsShowTextAttr($value, $data)
  99. {
  100. $value = $value ? $value : (isset($data['is_show']) ? $data['is_show'] : '');
  101. $list = $this->getIsShowList();
  102. return isset($list[$value]) ? $list[$value] : '';
  103. }
  104. public function getCopyStatusTextAttr($value, $data)
  105. {
  106. $value = $value ? $value : (isset($data['copy_status']) ? $data['copy_status'] : '');
  107. $list = $this->getCopyStatusList();
  108. return isset($list[$value]) ? $list[$value] : '';
  109. }
  110. public function coach()
  111. {
  112. return $this->belongsTo('Coach', 'coach_ids', 'id', [], 'LEFT')->setEagerlyType(0);
  113. }
  114. public function lesson()
  115. {
  116. return $this->belongsTo('Lesson', 'lesson_id', 'id', [], 'LEFT')->setEagerlyType(0);
  117. }
  118. public function danceroom()
  119. {
  120. return $this->belongsTo('Danceroom', 'danceroom_id', 'id', [], 'LEFT')->setEagerlyType(0);
  121. }
  122. }