// 客户账簿
public function account_book_list()
{
// 应收总额 total_receivable
// 实收总额 total_paid
// 折让总额 total_allowance
// 未结清总额 total_outstanding
// 全部明细数 all_details
// 未结清明细数 outstanding_details
//当前是否为关联查询
$this->relationSearch = true;
//设置过滤方法
$this->request->filter(['strip_tags', 'trim']);
if ($this->request->isAjax()) {
//如果发送的来源是Selectpage,则转发到Selectpage
if ($this->request->request('keyField')) {
return $this->selectpage();
}
list($where, $sort, $order, $offset, $limit) = $this->buildparams();
$list = $this->model->group('customer_id')->select();
$list = $this->model
->group('customer_id')
->field('id,customer_id,payee_amount,
sum(payee_amount) as total_receivable,
sum(entry_amount) as total_paid,
sum(payee_amount) as all_details')
->paginate()
->each(function ($item,$key){
$item['total_outstanding'] = $item['total_receivable'] - $item['total_paid']; // 未结清总额
$item['outstanding_details'] = $item['total_receivable'] - $item['total_paid']; // 未结清明细数
});
$result = array("total" => $list->total(), "rows" => $list->items());
return json($result);
}
return $this->view->fetch();
}
fastadmin model使用each进行字段的二次处理
最新推荐文章于 2024-07-27 10:12:29 发布