ProjectDocument.php 2.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364
  1. <?php
  2. /**
  3. +-----------------------------------------------------------------------------------------------
  4. * GouGuOPEN [ 左手研发,右手开源,未来可期!]
  5. +-----------------------------------------------------------------------------------------------
  6. * @Copyright (c) 2021~2024 http://www.gouguoa.com All rights reserved.
  7. +-----------------------------------------------------------------------------------------------
  8. * @Licensed 勾股OA,开源且可免费使用,但并不是自由软件,未经授权许可不能去除勾股OA的相关版权信息
  9. +-----------------------------------------------------------------------------------------------
  10. * @Author 勾股工作室 <hdm58@qq.com>
  11. +-----------------------------------------------------------------------------------------------
  12. */
  13. declare (strict_types = 1);
  14. namespace app\Project\model;
  15. use think\facade\Db;
  16. use think\Model;
  17. class ProjectDocument extends Model
  18. {
  19. public function datalist($param,$where,$whereOr)
  20. {
  21. $rows = empty($param['limit']) ? get_config('app.page_size') : $param['limit'];
  22. $order = empty($param['order']) ? 'id desc' : $param['order'];
  23. try {
  24. $list = self::where($where)
  25. ->where(function ($query) use($whereOr) {
  26. if (!empty($whereOr)){
  27. $query->whereOr($whereOr);
  28. }
  29. })
  30. ->order($order)
  31. ->paginate(['list_rows'=> $rows])
  32. ->each(function ($item, $key){
  33. $item->admin_name = Db::name('Admin')->where(['id' => $item->admin_id])->value('name');
  34. if ($item->project_id > 0) {
  35. $item->project = Db::name('Project')->where(['id' => $item->project_id])->value('name');
  36. }
  37. else{
  38. $item->project = '-';
  39. }
  40. $item['create_time'] = to_date($item['create_time']);
  41. });
  42. return $list;
  43. } catch(\Exception $e) {
  44. return ['code' => 1, 'data' => [], 'msg' => $e->getMessage()];
  45. }
  46. }
  47. //详情
  48. public function detail($id)
  49. {
  50. $detail = Db::name('ProjectDocument')->where(['id' => $id])->find();
  51. if (!empty($detail)) {
  52. $detail['project_name'] = '-';
  53. if ($detail['project_id'] > 0) {
  54. $detail['project_name'] = Db::name('Project')->where(['id' => $detail['project_id']])->value('name');
  55. }
  56. $detail['admin_name'] = Db::name('Admin')->where(['id' => $detail['admin_id']])->value('name');
  57. $detail['times'] = time_trans($detail['create_time']);
  58. $detail['create_time'] = to_date($detail['create_time']);
  59. }
  60. return $detail;
  61. }
  62. }