mirror of
https://gitee.com/ShopeX/OMS
synced 2026-03-23 02:45:33 +08:00
318 lines
11 KiB
PHP
318 lines
11 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.
|
||
*/
|
||
|
||
class financebase_data_bill_wxpay extends financebase_abstract_bill
|
||
{
|
||
|
||
// 处理数据
|
||
/**
|
||
* 获取Sdf
|
||
* @param mixed $row row
|
||
* @param mixed $offset offset
|
||
* @param mixed $title title
|
||
* @return mixed 返回结果
|
||
*/
|
||
public function getSdf($row,$offset=1, $title)
|
||
{
|
||
$row = array_map('trim', $row);
|
||
|
||
if (!$this->ioTitle) {
|
||
$this->ioTitle = $this->getTitle();
|
||
}
|
||
$res = array('status'=>true,'data'=>array(),'msg'=>'');
|
||
if($row[0] == '流水单号' || $row[0] == "\u{FEFF}流水单号") {
|
||
return $res;
|
||
}
|
||
$tmpRow = [];
|
||
foreach ($title as $k => $t) {
|
||
$i = array_search($t, $this->getTitle());
|
||
|
||
if ($i) {
|
||
$tmpRow[$i] = $row[$k];
|
||
}
|
||
}
|
||
|
||
$tmp = [];
|
||
//判断参数不能为空
|
||
foreach ($tmpRow as $k => $v) {
|
||
$tmp[$k] = trim($v);
|
||
|
||
if(in_array($k, array('out_trade_no','trade_no','trade_type','trade_status')))
|
||
{
|
||
if(!$v)
|
||
{
|
||
$res['status'] = false;
|
||
$res['msg'] = sprintf("%s : %s 不能为空！", $tmpRow['trade_no'], $this->ioTitle[$k]);
|
||
return $res;
|
||
}
|
||
}
|
||
|
||
if(in_array($k, array('trade_time')))
|
||
{
|
||
$result = finance_io_bill_verify::isDate($v);
|
||
if ($result['status'] == 'fail')
|
||
{
|
||
$res['status'] = false;
|
||
$res['msg'] = sprintf("%s : %s 时间(%s)格式错误！", $tmpRow['trade_no'], $this->ioTitle[$k], $v);
|
||
return $res;
|
||
}
|
||
}
|
||
|
||
if(in_array($k, array('money')))
|
||
{
|
||
$result = finance_io_bill_verify::isPrice($v);
|
||
if ($result['status'] == 'fail')
|
||
{
|
||
$res['status'] = false;
|
||
$res['msg'] = sprintf("%s : %s 金额(%s)格式错误！", $tmpRow['trade_no'], $this->ioTitle[$k], $v);
|
||
return $res;
|
||
}
|
||
}
|
||
|
||
if($k == 'trade_status'){
|
||
if(!in_array($v,['收入','支出'])){
|
||
$res['status'] = false;
|
||
$res['msg'] = sprintf("%s : %s 收支类型(%s)错误！", $tmpRow['trade_no'], $this->ioTitle[$k], $v);
|
||
return $res;
|
||
}
|
||
}
|
||
}
|
||
|
||
$tmp['money'] = $tmp['trade_status'] == '支出' ? -$tmp['money'] : $tmp['money'];
|
||
$tmp['amount'] = $tmp['money'];
|
||
$res['data'] = $tmp;
|
||
|
||
|
||
return $res;
|
||
}
|
||
|
||
/**
|
||
* 获取Title
|
||
* @return mixed 返回结果
|
||
*/
|
||
public function getTitle()
|
||
{
|
||
$title = array(
|
||
'trade_no' => '流水单号',
|
||
'trade_time' => '记账时间',
|
||
'trade_type' => '动帐类型',
|
||
'trade_status' => '收支类型',
|
||
'money' => '收支金额',
|
||
'total_amount' => '账户余额',
|
||
'out_trade_no' => '关联订单号',
|
||
'out_refund_no' => '关联售后单号',
|
||
'out_tixian_no' => '关联提现单号',
|
||
'out_baodan_no' => '关联保单号',
|
||
'remarks' => '详情',
|
||
);
|
||
return $title;
|
||
}
|
||
|
||
// 获取订单号
|
||
/**
|
||
* _getOrderBn
|
||
* @param mixed $params 参数
|
||
* @return mixed 返回值
|
||
*/
|
||
public function _getOrderBn(&$params)
|
||
{
|
||
// $this->shopNew = [];
|
||
|
||
$paymentModel = app::get('ome')->model('payments');
|
||
$orderModel = app::get('ome')->model('orders');
|
||
//微信小店、有赞导入文件，账单关联订单号对应oms支付单号
|
||
$paymentsInfo = $paymentModel->db_dump(['payment_bn' => $params['out_trade_no']], 'payment_id,payment_bn,order_id');
|
||
if ($paymentsInfo) {
|
||
$orderInfo = $orderModel->db_dump(['order_id' => $paymentsInfo['order_id']], 'order_id,order_bn,shop_id');
|
||
if ($orderInfo && isset($orderInfo['order_bn'])) {
|
||
$params['out_trade_no'] = $orderInfo['order_bn'];
|
||
|
||
// 重新定位店铺
|
||
$shop = app::get('ome')->model('shop')->db_dump(['shop_id' => $orderInfo['shop_id']], 'shop_id,name,shop_bn');
|
||
|
||
$params['shop_id'] = $shop['shop_id'];
|
||
$params['shop_name'] = $shop['name'];
|
||
}
|
||
}
|
||
return $params['out_trade_no'];
|
||
}
|
||
|
||
/**
|
||
* 获取具体类别
|
||
* @param $params
|
||
* @return mixed|string
|
||
* @date 2024-11-26 4:23 下午
|
||
*/
|
||
public function getBillCategory($params)
|
||
{
|
||
if(!$this->rules) $this->getRules('wx');
|
||
|
||
$this->verified_data = $params;
|
||
|
||
if($this->rules)
|
||
{
|
||
foreach ($this->rules as $item)
|
||
{
|
||
foreach ($item['rule_content'] as $rule) {
|
||
if($this->checkRule($rule)) return $item['bill_category'];
|
||
}
|
||
}
|
||
}
|
||
|
||
return '';
|
||
}
|
||
|
||
/**
|
||
* 检查文件是否有效
|
||
* @Date 2019-06-25
|
||
* @param String $file_name 文件名
|
||
* @param String $file_type 文件类型
|
||
* @return Boolean
|
||
*/
|
||
public function checkFile($file_name,$file_type){
|
||
$ioType = kernel::single('financebase_io_' . $file_type);
|
||
$row = $ioType->getData($file_name, 0, 5);
|
||
|
||
$title = array_values($this->getTitle());
|
||
$row[0][0] = str_replace("\u{FEFF}", "", $row[0][0]);
|
||
$plateTitle = $row[0];
|
||
foreach($title as $v) {
|
||
if(array_search($v, $plateTitle) === false) {
|
||
return array(false, '文件模板错误：列【'.$v.'】未包含在'.implode('、', $plateTitle) );
|
||
}
|
||
}
|
||
return array(true, '文件模板匹配', $row[0]);
|
||
}
|
||
|
||
|
||
/**
|
||
* 同步到对账表
|
||
* @Date 2019-06-25
|
||
* @param Array 原始数据 $data
|
||
* @param String 具体类别 $bill_category
|
||
* @return Boolean
|
||
*/
|
||
public function syncToBill($data,$bill_category='')
|
||
{
|
||
|
||
$data['content'] = json_decode(stripslashes($data['content']),1);
|
||
if(!$data['content']) return false;
|
||
|
||
$tmp = $data['content'];
|
||
$shop_id = $data['shop_id'];
|
||
|
||
$mdlBill = app::get('finance')->model('bill');
|
||
|
||
$tmp['fee_obj'] = '微信小店';
|
||
$tmp['fee_item'] = $bill_category;
|
||
|
||
$res = $this->getBillType($tmp,$shop_id);
|
||
if(!$res['status']) return false;
|
||
|
||
$order_bn = $this->_getOrderBn($tmp);
|
||
|
||
// 手工选的店铺
|
||
if(!$data['shop_name']){
|
||
$data['shop_name'] = isset($this->shop_list[$data['shop_id']]) ? $this->shop_list[$data['shop_id']]['name'] : '';
|
||
}
|
||
$shop_name = $data['shop_name'];
|
||
|
||
// 通过支付单获取店铺信息
|
||
$shop_id = $tmp['shop_id'] ?: $shop_id;
|
||
$shop_name = $tmp['shop_name']?: $shop_name;
|
||
|
||
|
||
$base_sdf = array(
|
||
'order_bn' => $order_bn,
|
||
'channel_id' => $shop_id,
|
||
'channel_name' => $shop_name,
|
||
'trade_time' => strtotime($tmp['trade_time']),
|
||
'fee_obj' => $tmp['fee_obj'],
|
||
'money' => $tmp['money'],
|
||
'fee_item' => $tmp['fee_item'],
|
||
'fee_item_id' => isset($this->fee_item_rules[$tmp['fee_item']]) ? $this->fee_item_rules[$tmp['fee_item']] : 0,
|
||
'credential_number' => $tmp['trade_no'],// 单据编号
|
||
'member' => '',
|
||
'memo' => $tmp['remarks'],
|
||
'unique_id' => $data['unique_id'],
|
||
'create_time' => time(),
|
||
'fee_type' => $tmp['trade_type'],
|
||
'fee_type_id' => $res['fee_type_id'],
|
||
'bill_type' => $res['bill_type'],
|
||
'charge_status' => 1,// 流水直接设置记账成功
|
||
'charge_time' => time(),
|
||
|
||
);
|
||
$base_sdf['monthly_id'] = 0;
|
||
$base_sdf['monthly_item_id'] = 0;
|
||
$base_sdf['monthly_status'] = 0;
|
||
|
||
|
||
$base_sdf['crc32_order_bn'] = sprintf('%u',crc32($base_sdf['order_bn']));
|
||
$base_sdf['bill_bn'] = $mdlBill->gen_bill_bn();
|
||
$base_sdf['unconfirm_money'] = $base_sdf['money'];
|
||
|
||
if($mdlBill->insert($base_sdf)){
|
||
kernel::single('finance_monthly_report_items')->dealBillMatchReport($base_sdf['bill_id']);
|
||
return true;
|
||
}
|
||
return false;
|
||
}
|
||
|
||
/**
|
||
* _filterData
|
||
* @param mixed $data 数据
|
||
* @return mixed 返回值
|
||
*/
|
||
public function _filterData(&$data)
|
||
{
|
||
$new_data = array();
|
||
|
||
$new_data['order_bn'] = $this->_getOrderBn($data);
|
||
$new_data['trade_no'] = $data['trade_no'];
|
||
$new_data['financial_no'] = $data['trade_no'];
|
||
$new_data['out_trade_no'] = $data['out_trade_no'];
|
||
$new_data['trade_time'] = strtotime($data['trade_time']);
|
||
$new_data['trade_type'] = $data['trade_type'];
|
||
$new_data['money'] = $data['money'];
|
||
$new_data['unique_id'] = md5($data['trade_no']);
|
||
$new_data['platform_type'] = 'wxpay';
|
||
$new_data['remarks'] = $data['remarks'];
|
||
|
||
return $new_data;
|
||
}
|
||
|
||
/**
|
||
* 获取ImportDateColunm
|
||
* @param mixed $title title
|
||
* @return mixed 返回结果
|
||
*/
|
||
public function getImportDateColunm($title=null)
|
||
{
|
||
$timeColumn = ['记账时间'];
|
||
$timeCol = [];
|
||
foreach ($timeColumn as $v) {
|
||
$k = array_search($v, $title);
|
||
if($k !== false) {
|
||
$timeCol[] = $k+1;
|
||
}
|
||
}
|
||
$timezone = defined('DEFAULT_TIMEZONE') ? DEFAULT_TIMEZONE : 0;
|
||
return array('column'=>$timeCol,'time_diff'=>$timezone * 3600 );
|
||
}
|
||
|
||
} |