WorkorderFile.php 1.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. <?php
  2. namespace addons\qingdongams\model;
  3. use think\Model;
  4. use traits\model\SoftDelete;
  5. /**
  6. *客户附件表
  7. */
  8. class WorkorderFile Extends Model {
  9. use SoftDelete;
  10. protected $name = 'qingdongams_workorder_file';
  11. // 开启自动写入时间戳字段
  12. protected $autoWriteTimestamp = false;
  13. // 定义时间戳字段名
  14. protected $createTime = false;
  15. protected $updateTime = false;
  16. protected $deleteTime = false;
  17. //附件表
  18. public function file() {
  19. return $this->hasOne(File::class, 'id', 'file_id')->with('staff')->bind('id,size,create_staff_id,types,name,file_path,staff');
  20. }
  21. public static function addFiles($files, $workorder_id) {
  22. $files = explode(',', $files);
  23. $addFiles = [];
  24. foreach ($files as $v) {
  25. $addFiles[] = [
  26. 'workorder_id' => $workorder_id,
  27. 'file_id' => $v
  28. ];
  29. }
  30. $model=new self();
  31. if($model->insertAll($addFiles)){
  32. return true;
  33. }
  34. return false;
  35. }
  36. public static function editFiles($files, $workorder_id) {
  37. self::where(['workorder_id'=>$workorder_id])->delete();
  38. $files = explode(',', $files);
  39. $addFiles = [];
  40. foreach ($files as $v) {
  41. $addFiles[] = [
  42. 'workorder_id' => $workorder_id,
  43. 'file_id' => $v
  44. ];
  45. }
  46. $model=new self();
  47. if($model->insertAll($addFiles)){
  48. return true;
  49. }
  50. return false;
  51. }
  52. }