CompanyCategory.php 3.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  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. /**
  7. * 公司分类模型
  8. * @author 唐远望
  9. * @version 1.0
  10. * @date 2025-12-19
  11. */
  12. class CompanyCategory extends Model
  13. {
  14. use HasFactory;
  15. // 与模型关联的表名
  16. protected $table = 'washconfig_company_category';
  17. // 是否主动维护时间戳
  18. public $timestamps = false;
  19. // 定义时间戳字段名
  20. // const CREATED_AT = 'insert_time';
  21. // const UPDATED_AT = 'update_time';
  22. /**
  23. * 添加
  24. * @author 唐远望
  25. * @version 1.0
  26. * @date 2025-12-19
  27. */
  28. public function addCompanyCategory_content($data)
  29. {
  30. $insert_data = [
  31. 'name' => $data['name'],
  32. 'company_id' => $data['company_id'],
  33. 'insert_time' => time(),
  34. ];
  35. $CompanyCategory_id = $this->insertGetId($insert_data);
  36. return $CompanyCategory_id;
  37. }
  38. /**
  39. * 写入数据
  40. * @author 唐远望
  41. * @version 1.0
  42. * @date 2025-12-19
  43. * @param $data
  44. * @return bool
  45. */
  46. public function addCompanyCategory($data)
  47. {
  48. DB::beginTransaction();
  49. try {
  50. $this->addCompanyCategory_content($data);
  51. DB::commit();
  52. return true;
  53. // 成功处理...
  54. } catch (\Exception $e) {
  55. DB::rollBack();
  56. // 错误处理...
  57. return false;
  58. }
  59. }
  60. /**
  61. * 编辑内容
  62. * @author 唐远望
  63. * @version 1.0
  64. * @date 2025-12-19
  65. * @param $data
  66. * @return bool
  67. */
  68. public function editCompanyCategory_content($CompanyCategory, $data)
  69. {
  70. $CompanyCategory->name = $data['name'];
  71. $CompanyCategory->company_id = $data['company_id'];
  72. $CompanyCategory->update_time = time();
  73. $CompanyCategory->save();
  74. return true;
  75. }
  76. /**
  77. * 更新数据
  78. * @author 唐远望
  79. * @version 1.0
  80. * @date 2025-12-19
  81. * @param $data
  82. * @return bool
  83. */
  84. public function updateCompanyCategory($where, $data)
  85. {
  86. DB::beginTransaction();
  87. try {
  88. $this->editCompanyCategory_content($where, $data);
  89. DB::commit();
  90. return true;
  91. // 成功处理...
  92. } catch (\Exception $e) {
  93. DB::rollBack();
  94. // 错误处理...
  95. return false;
  96. }
  97. }
  98. /**
  99. * 修改状态
  100. * @author 唐远望
  101. * @version 1.0
  102. * @date 2025-12-19
  103. * @param $id
  104. * @param $status
  105. * @return bool
  106. */
  107. public function changeStatus($CompanyCategory, $status)
  108. {
  109. $CompanyCategory->status = $status;
  110. $CompanyCategory->update_time = time();
  111. $CompanyCategory->save();
  112. return true;
  113. }
  114. /**
  115. * 删除数据
  116. * @author 唐远望
  117. * @version 1.0
  118. * @date 2025-12-19
  119. * @param $id
  120. * @return bool
  121. */
  122. public function deleteCompanyCategory($where)
  123. {
  124. $CompanyCategory = $this->where($where)->first();
  125. if (!$CompanyCategory) {
  126. return false;
  127. }
  128. $CompanyCategory->delete();
  129. return true;
  130. }
  131. }