PlatForm.php 4.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189
  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. 'company_id' => $data['company_id'],
  54. 'platform' => $data['platform'],
  55. 'employee_ids' => $data['employee_ids'],
  56. 'insert_time' => time(),
  57. ];
  58. $PlatForm_id = $this->insertGetId($insert_data);
  59. if ($data['employee_ids'] != '') {
  60. $insert_company_data = [];
  61. $employee_ids = explode(',', $data['employee_ids']);
  62. foreach ($employee_ids as $employee_id) {
  63. $insert_company_data[] = [
  64. 'platform_id' => $PlatForm_id,
  65. 'employee_id' => $employee_id,
  66. ];
  67. }
  68. $PlatFormMemberModel->insert($insert_company_data);
  69. }
  70. DB::commit();
  71. return true;
  72. // 成功处理...
  73. } catch (\Exception $e) {
  74. DB::rollBack();
  75. // 错误处理...
  76. return false;
  77. }
  78. }
  79. /**
  80. * 编辑内容
  81. * @author 唐远望
  82. * @version 1.0
  83. * @date 2026-01-06
  84. * @param $data
  85. * @return bool
  86. */
  87. public function editPlatForm_content($where, $data)
  88. {
  89. $PlatForm = $this->where($where)->first();
  90. if (!$PlatForm) {
  91. return false;
  92. }
  93. // $PlatForm->name = $data['name'];
  94. $PlatForm->employee_ids = $data['employee_ids'];
  95. $PlatForm->update_time = time();
  96. $PlatForm->save();
  97. return true;
  98. }
  99. /**
  100. * 更新数据
  101. * @author 唐远望
  102. * @version 1.0
  103. * @date 2026-01-06
  104. * @param $data
  105. * @return bool
  106. */
  107. public function updatePlatForm($PlatForm, $data)
  108. {
  109. DB::beginTransaction();
  110. try {
  111. // $PlatForm->name = $data['name'];
  112. $PlatForm->company_id = $data['company_id'];
  113. $PlatForm->employee_ids = $data['employee_ids'];
  114. $PlatForm->update_time = time();
  115. $PlatForm->save();
  116. $PlatFormMemberModel = new PlatFormMemberModel();
  117. $PlatFormMemberModel->where('platform_id', $PlatForm->id)->delete();
  118. if ($data['employee_ids'] != '') {
  119. $insert_company_data = [];
  120. $employee_ids = explode(',', $data['employee_ids']);
  121. foreach ($employee_ids as $employee_id) {
  122. $insert_company_data[] = [
  123. 'platform_id' => $PlatForm->id,
  124. 'employee_id' => $employee_id,
  125. ];
  126. }
  127. $PlatFormMemberModel->insert($insert_company_data);
  128. }
  129. DB::commit();
  130. return true;
  131. // 成功处理...
  132. } catch (\Exception $e) {
  133. DB::rollBack();
  134. // 错误处理...
  135. return false;
  136. }
  137. }
  138. /**
  139. * 修改状态
  140. * @author 唐远望
  141. * @version 1.0
  142. * @date 2026-01-06
  143. * @param $id
  144. * @param $status
  145. * @return bool
  146. */
  147. public function changeStatus($PlatForm, $status)
  148. {
  149. $PlatForm->status = $status;
  150. $PlatForm->update_time = time();
  151. $PlatForm->save();
  152. return true;
  153. }
  154. /**
  155. * 删除数据
  156. * @author 唐远望
  157. * @version 1.0
  158. * @date 2026-01-06
  159. * @param $id
  160. * @return bool
  161. */
  162. public function deletePlatForm($where)
  163. {
  164. $PlatForm = $this->where($where)->first();
  165. if (!$PlatForm) {
  166. return false;
  167. }
  168. $PlatForm->delete();
  169. return true;
  170. }
  171. }