Inventorydetails.php 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. <?php
  2. namespace app\admin\controller;
  3. use app\common\controller\Backend;
  4. use think\Db;
  5. use function EasyWeChat\Kernel\Support\rsa_public_encrypt;
  6. /**
  7. * 版本管理
  8. *
  9. * @icon fa fa-circle-o
  10. */
  11. class Inventorydetails extends Backend
  12. {
  13. /**
  14. * Inventorydetails模型对象
  15. * @var \app\admin\model\Inventorydetails
  16. */
  17. protected $model = null;
  18. public function _initialize()
  19. {
  20. parent::_initialize();
  21. $this->model = new \app\admin\model\Inventorydetails;
  22. $this->view->assign("statusList", $this->model->getStatusList());
  23. }
  24. /**
  25. * 默认生成的控制器所继承的父类中有index/add/edit/del/multi五个基础方法、destroy/restore/recyclebin三个回收站方法
  26. * 因此在当前控制器中可不用编写增删改查的代码,除非需要自己控制这部分逻辑
  27. * 需要将application/admin/library/traits/Backend.php中对应的方法复制到当前控制器,然后进行修改
  28. */
  29. public function index()
  30. {
  31. // 1. 获取前端参数:搜索关键字、页码、每页条数
  32. $search = input('get.search');
  33. $page = input('get.page', 1);
  34. $limit = input('get.limit', 10);
  35. // 2. 连接 MongoDB(使用 config/database.php 中名为 mongodb 的连接)
  36. $mongo = \think\Db::connect('mongodb');
  37. $where = ['jjcp_cpdh' => ['like', '%' . $search . '%']];
  38. $total = $mongo->name('finished_products')->where($where)->count();
  39. $data = $mongo->name('finished_products')
  40. ->limit(($page - 1) * $limit, $limit)
  41. ->select();
  42. if (request()->isAjax()) {
  43. return json([
  44. 'data' => $data,
  45. 'total' => $total,
  46. 'page' => $page,
  47. 'limit' => $limit
  48. ]);
  49. }
  50. $this->assign('data', $data);
  51. return $this->fetch();
  52. }
  53. }