PlatForm.php 4.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187
  1. <?php
  2. namespace App\Models\manager\WashConfig;
  3. use Illuminate\Database\Eloquent\Factories\HasFactory;
  4. use Illuminate\Database\Eloquent\Model;
  5. use Illuminate\Support\Facades\DB;
  6. use App\Models\manager\WashConfig\PlatFormMember as PlatFormMemberModel;
  7. /**
  8. * 平台配置模型
  9. * @author: 唐远望
  10. * @version: 1.0
  11. * @date: 2026-01-06
  12. */
  13. class PlatForm extends Model
  14. {
  15. use HasFactory;
  16. // 与模型关联的表名
  17. protected $table = 'platform';
  18. // 是否主动维护时间戳
  19. public $timestamps = false;
  20. // 定义时间戳字段名
  21. // const CREATED_AT = 'insert_time';
  22. // const UPDATED_AT = 'update_time';
  23. /**
  24. * 添加
  25. * @author 唐远望
  26. * @version 1.0
  27. * @date 2026-01-06
  28. */
  29. public function addPlatForm_content($data)
  30. {
  31. $insert_data = [
  32. 'name' => $data['name'],
  33. 'employee_ids' => $data['employee_ids'],
  34. 'insert_time' => time(),
  35. ];
  36. $PlatForm_id = $this->insertGetId($insert_data);
  37. return $PlatForm_id;
  38. }
  39. /**
  40. * 写入数据
  41. * @author 唐远望
  42. * @version 1.0
  43. * @date 2026-01-06
  44. * @param $data
  45. * @return bool
  46. */
  47. public function addPlatForm($data)
  48. {
  49. DB::beginTransaction();
  50. try {
  51. $PlatFormMemberModel = new PlatFormMemberModel();
  52. $insert_data = [
  53. 'platform' => $data['platform'],
  54. 'employee_ids' => $data['employee_ids'],
  55. 'insert_time' => time(),
  56. ];
  57. $PlatForm_id = $this->insertGetId($insert_data);
  58. if ($data['employee_ids'] != '') {
  59. $insert_company_data = [];
  60. $employee_ids = explode(',', $data['employee_ids']);
  61. foreach ($employee_ids as $employee_id) {
  62. $insert_company_data[] = [
  63. 'platform_id' => $PlatForm_id,
  64. 'employee_id' => $employee_id,
  65. ];
  66. }
  67. $PlatFormMemberModel->insert($insert_company_data);
  68. }
  69. DB::commit();
  70. return true;
  71. // 成功处理...
  72. } catch (\Exception $e) {
  73. DB::rollBack();
  74. // 错误处理...
  75. return false;
  76. }
  77. }
  78. /**
  79. * 编辑内容
  80. * @author 唐远望
  81. * @version 1.0
  82. * @date 2026-01-06
  83. * @param $data
  84. * @return bool
  85. */
  86. public function editPlatForm_content($where, $data)
  87. {
  88. $PlatForm = $this->where($where)->first();
  89. if (!$PlatForm) {
  90. return false;
  91. }
  92. // $PlatForm->name = $data['name'];
  93. $PlatForm->employee_ids = $data['employee_ids'];
  94. $PlatForm->update_time = time();
  95. $PlatForm->save();
  96. return true;
  97. }
  98. /**
  99. * 更新数据
  100. * @author 唐远望
  101. * @version 1.0
  102. * @date 2026-01-06
  103. * @param $data
  104. * @return bool
  105. */
  106. public function updatePlatForm($PlatForm, $data)
  107. {
  108. DB::beginTransaction();
  109. try {
  110. // $PlatForm->name = $data['name'];
  111. $PlatForm->employee_ids = $data['employee_ids'];
  112. $PlatForm->update_time = time();
  113. $PlatForm->save();
  114. $PlatFormMemberModel = new PlatFormMemberModel();
  115. $PlatFormMemberModel->where('platform_id', $PlatForm->id)->delete();
  116. if ($data['employee_ids'] != '') {
  117. $insert_company_data = [];
  118. $employee_ids = explode(',', $data['employee_ids']);
  119. foreach ($employee_ids as $employee_id) {
  120. $insert_company_data[] = [
  121. 'platform_id' => $PlatForm->id,
  122. 'employee_id' => $employee_id,
  123. ];
  124. }
  125. $PlatFormMemberModel->insert($insert_company_data);
  126. }
  127. DB::commit();
  128. return true;
  129. // 成功处理...
  130. } catch (\Exception $e) {
  131. DB::rollBack();
  132. // 错误处理...
  133. return false;
  134. }
  135. }
  136. /**
  137. * 修改状态
  138. * @author 唐远望
  139. * @version 1.0
  140. * @date 2026-01-06
  141. * @param $id
  142. * @param $status
  143. * @return bool
  144. */
  145. public function changeStatus($PlatForm, $status)
  146. {
  147. $PlatForm->status = $status;
  148. $PlatForm->update_time = time();
  149. $PlatForm->save();
  150. return true;
  151. }
  152. /**
  153. * 删除数据
  154. * @author 唐远望
  155. * @version 1.0
  156. * @date 2026-01-06
  157. * @param $id
  158. * @return bool
  159. */
  160. public function deletePlatForm($where)
  161. {
  162. $PlatForm = $this->where($where)->first();
  163. if (!$PlatForm) {
  164. return false;
  165. }
  166. $PlatForm->delete();
  167. return true;
  168. }
  169. }