mirror of
https://gitee.com/ShopeX/OMS
synced 2026-03-22 18:35:35 +08:00
59 lines
1.7 KiB
PHP
59 lines
1.7 KiB
PHP
<?php
|
|
/**
|
|
* Copyright 2012-2026 ShopeX (https://www.shopex.cn)
|
|
*
|
|
* Licensed under the Apache License, Version 2.0 (the "License");
|
|
* you may not use this file except in compliance with the License.
|
|
* You may obtain a copy of the License at
|
|
*
|
|
* http://www.apache.org/licenses/LICENSE-2.0
|
|
*
|
|
* Unless required by applicable law or agreed to in writing, software
|
|
* distributed under the License is distributed on an "AS IS" BASIS,
|
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
|
* See the License for the specific language governing permissions and
|
|
* limitations under the License.
|
|
*/
|
|
/**
|
|
* 京准通账单model类
|
|
*
|
|
* @author wangbiao<wangbiao@shopex.cn>
|
|
* @version $Id: Z
|
|
*/
|
|
class financebase_mdl_jingzhuntong extends dbeav_model
|
|
{
|
|
public $has_export_cnf = true;
|
|
public $filter_use_like = true;
|
|
public $export_name = '京准通账单明细';
|
|
|
|
/**
|
|
* table_name
|
|
* @param mixed $real real
|
|
* @return mixed 返回值
|
|
*/
|
|
|
|
public function table_name($real=false)
|
|
{
|
|
$tableName = 'bill';
|
|
|
|
return $real ? kernel::database()->prefix.'financebase_'.$tableName : $tableName;
|
|
}
|
|
|
|
/**
|
|
* 统计数据
|
|
*
|
|
* @param unknown $filter
|
|
* @return unknown
|
|
*/
|
|
public function getTotal($filter)
|
|
{
|
|
$sql = 'select bill_category, sum(money) total_money,
|
|
sum(case when confirm_status="1" then money end) confirm_money,
|
|
sum(case when confirm_status="0" then money end) unconfirm_money
|
|
from sdb_financebase_bill
|
|
where '. $this->_filter($filter);
|
|
$row = $this->db->select($sql);
|
|
return $row;
|
|
}
|
|
}
|