InvoiceIncome.php 1.7 KB

1234567891011121314151617181920212223242526272829303132333435363738
  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. namespace app\finance\model;
  14. use think\Model;
  15. use think\facade\Db;
  16. class InvoiceIncome extends Model
  17. {
  18. public function datalist($param,$where)
  19. {
  20. $rows = empty($param['limit']) ? get_config('app.page_size') : $param['limit'];
  21. $order = empty($param['order']) ? 'id desc' : $param['order'];
  22. try {
  23. $list = self::where($where)
  24. ->order($order)
  25. ->paginate(['list_rows'=> $rows])
  26. ->each(function ($item, $key){
  27. $item['admin_name'] = Db::name('Admin')->where('id',$item['admin_id'])->value('name');
  28. $item['enter_time'] = date('Y-m-d',$item['enter_time']);
  29. $item['code'] = Db::name('Invoice')->where('id',$item['invoice_id'])->value('code');
  30. $item['create_time'] = to_date($item['create_time']);
  31. });
  32. return $list;
  33. } catch(\Exception $e) {
  34. return ['code' => 1, 'data' => [], 'msg' => $e->getMessage()];
  35. }
  36. }
  37. }