Files
OMS/app/ome/dbschema/reship.php
chenping 656bbbabf6 [TBID:SCRUM-7446] V8.6.0发版
【优化】微信小店退款金额
【修复】自建仓储在线盘点条码输入后无响应
【修复】邮编异常拼接导致的客户保存失败
【新增】hold单规则支持选择多个客户分类
【新增】店铺每日统计报表支持按金额排序展示
【优化】店铺授权到期提示文案
【新增】特殊订单条件配置增加一个排除商品的条件
【新增】在售库存高级筛选增加未匹配和已匹配
【新增】京东引凤业务对接
2026-08-05 19:28:08 +08:00

741 lines
25 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
<?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.
*/
$db['reship'] = array(
'columns' => array(
'reship_id' => array(
'type' => 'int unsigned',
'required' => true,
'pkey' => true,
'editable' => false,
'extra' => 'auto_increment',
'comment' => '退换货ID',
),
'problem_id' => array(
'type' => 'table:return_product_problem@ome',
'label' => '问题类型ID',
),
'reship_bn' => array(
'type' => 'varchar(64)',
'required' => true,
'label' => '退换货单号',
'comment' => '退换货单号',
'editable' => false,
'searchtype' => 'nequal',
'filterdefault' => true,
'filtertype' => 'yes',
'width' => 200,
'in_list' => true,
'default_in_list' => true,
'is_title' => true,
),
'order_id' => array(
'type' => 'table:orders@ome',
'label' => '订单号',
'comment' => '订单号',
'editable' => false,
'width' => 200,
'in_list' => false,
'default_in_list' => false,
),
'platform_order_bn' =>
array (
'type' => 'varchar(32)',
'label' => '平台订单号',
'width' => 180,
'searchtype' => 'nequal',
'editable' => false,
'filtertype' => 'normal',
'filterdefault' => true,
'in_list' => true,
'default_in_list' => false,
),
'money' => array(
'type' => 'money',
'required' => true,
'default' => 0,
'label' => '物流费用',
'comment' => '配送费用',
'editable' => false,
'filtertype' => 'number',
'width' => 75,
'in_list' => true,
'default_in_list' => true,
),
'is_protect' => array(
'type' => 'bool',
'default' => 'false',
'required' => true,
'label' => '是否保价',
'comment' => '是否保价',
'editable' => false,
'filtertype' => 'yes',
'in_list' => true,
),
'delivery' => array(
'type' => 'varchar(20)',
'label' => '配送方式',
'comment' => '配送方式(货到付款、EMS...)',
'editable' => false,
'filtertype' => 'normal',
'width' => 110,
'in_list' => true,
'default_in_list' => true,
),
'delivery_id' => array(
'type' => 'table:delivery@ome',
'label' => '发货单号',
'in_list' => true,
),
'logi_id' => array(
'type' => 'varchar(50)',
'comment' => '物流公司ID',
'editable' => false,
'label' => '物流公司ID',
'in_list' => true,
),
'logi_name' => array(
'type' => 'varchar(100)',
'label' => '物流公司',
'comment' => '物流公司名称',
'editable' => false,
'filtertype' => 'normal',
'width' => 120,
'in_list' => true,
'default_in_list' => false,
),
'logi_no' => array(
'type' => 'varchar(50)',
'label' => '物流单号',
'comment' => '物流单号',
'editable' => false,
'filtertype' => 'normal',
'width' => 130,
'in_list' => true,
'default_in_list' => false,
),
'return_logi_name' => array(
'type' => 'varchar(100)',
'label' => '退回物流公司',
'comment' => '退回物流公司名称',
'editable' => false,
'filtertype' => 'normal',
'width' => 130,
'in_list' => true,
'default_in_list' => true,
),
'return_logi_no' => array(
'type' => 'varchar(50)',
'label' => '退回物流单号',
'comment' => '退回物流单号',
'editable' => false,
'searchtype' => 'nequal',
'filtertype' => 'normal',
'filterdefault' => true,
'width' => 130,
'in_list' => true,
'default_in_list' => true,
),
'ship_name' => array(
'type' => 'varchar(255)',
'label' => '收货人',
'comment' => '收货人姓名',
'editable' => false,
'filtertype' => 'normal',
'width' => 75,
'in_list' => true,
'default_in_list' => true,
),
'ship_area' => array(
'type' => 'region',
'label' => '收货地区',
'comment' => '收货人地区',
'editable' => false,
'filtertype' => 'normal',
'width' => 75,
'in_list' => true,
'default_in_list' => true,
),
'ship_addr' => array(
'type' => 'text',
'label' => '收货地址',
'comment' => '收货人地址',
'editable' => false,
'filtertype' => 'normal',
'width' => 150,
'in_list' => true,
'default_in_list' => true,
),
'ship_zip' => array(
'type' => 'varchar(20)',
'label' => '收货邮编',
'comment' => '收货人邮编',
'editable' => false,
'filtertype' => 'normal',
'in_list' => true,
'default_in_list' => false,
),
'ship_tel' => array(
'type' => 'varchar(200)',
'label' => '收货人电话',
'comment' => '收货人电话',
'editable' => false,
'filtertype' => 'normal',
'in_list' => true,
'default_in_list' => false,
),
'ship_mobile' => array(
'type' => 'varchar(200)',
'label' => '收货人手机',
'comment' => '收货人手机',
'editable' => false,
'filtertype' => 'normal',
'in_list' => true,
'default_in_list' => false,
),
'ship_email' => array(
'type' => 'varchar(150)',
'label' => '收货人Email',
'comment' => '收货人Email',
'editable' => false,
'filtertype' => 'normal',
'in_list' => true,
'default_in_list' => false,
),
't_begin' => array(
'type' => 'time',
'label' => '单据创建时间',
'comment' => '单据生成时间',
'editable' => false,
'filtertype' => 'time',
'filterdefault' => true,
'in_list' => true,
),
't_end' => array(
'type' => 'time',
'comment' => '单据结束时间',
'editable' => false,
'label' => '单据结束时间',
'filtertype' => 'time',
'filterdefault' => true,
'in_list' => true,
),
'op_id' => array(
'type' => 'table:account@pam',
'label' => '操作员',
'comment' => '操作者',
'editable' => false,
'filtertype' => 'normal',
'in_list' => true,
),
'status' => array(
'type' => array(
'succ' => '成功到达',
'failed' => '发货失败',
'cancel' => '已取消',
'progress' => '运送中',
'timeout' => '超时',
'ready' => '准备发货',
'stop' => '暂停',
'back' => '打回',
),
'default' => 'ready',
'required' => true,
'comment' => '状态',
'editable' => false,
'label' => '状态',
'width' => 65,
'in_list' => false,
'default_in_list' => false,
),
'is_check' => array(
'type' => array(
0 => '未审核',
1 => '审核成功',
2 => '审核失败',
3 => '收货成功',
4 => '拒绝收货',
5 => '拒绝',
6 => '补差价',
7 => '完成',
8 => '质检通过',
9 => '拒绝质检',
10 => '质检异常',
11 => '待确认',
12 => '收货异常',
13 => '质检中',
14 => '部分收货',
),
'default' => '0',
'comment' => '当前状态',
'editable' => false,
'label' => '当前状态',
'width' => 65,
'in_list' => true,
'default_in_list' => true,
),
'memo' => array(
'type' => 'longtext',
'label' => '备注',
'comment' => '备注',
'editable' => false,
'filtertype' => 'normal',
'in_list' => true,
'default_in_list' => false,
),
'tmoney' => array(
'type' => 'money',
'editable' => false,
'label' => '退款的金额',
'in_list' => true,
),
'bmoney' => array(
'type' => 'money',
'editable' => false,
'label' => '折旧(其他费用)',
'in_list' => true,
),
'had_refund' => array(
'type' => 'money',
'editable' => false,
'label' => '已退金额',
'in_list' => true,
),
'totalmoney' => array(
'type' => 'money',
'editable' => false,
'in_list' => true,
'default_in_list' => true,
'label' => '最后合计金额',
'width' => 130,
),
'disabled' => array(
'type' => 'bool',
'default' => 'false',
'comment' => '无效',
'editable' => false,
'label' => '无效',
'in_list' => true,
),
'return_id' => array(
'type' => 'table:return_product@ome',
'editable' => false,
'in_list' => true,
'default_in_list' => true,
'filterdefault' => true,
'filtertype' => 'fuzzy_search',
'label' => '售后申请单号',
),
'reason' => array(
'type' => 'longtext',
'editable' => false,
'label' => '收货/质检原因',
),
'return_type' => array(
'type' => array(
'return' => '退货',
'change' => '换货',
'refuse' => '拒收退货',
),
'default' => 'return',
'required' => true,
'comment' => '退换货状态',
'editable' => false,
'label' => '退换货状态',
'width' => 110,
'in_list' => true,
'default_in_list' => true,
'filtertype' => true,
'filterdefault' => true,
),
'change_status' => array(
'type' => array(
0 => '未生成',
1 => '已生成',
2 => '不生成',
),
'default' => '0',
'comment' => '换货订单状态',
'editable' => false,
'label' => '换货订单状态',
'width' => 110,
'in_list' => true,
'default_in_list' => false,
),
'shop_id' => array(
'type' => 'table:shop@ome',
'label' => '来源店铺',
'width' => 160,
'editable' => false,
'in_list' => true,
'filtertype' => 'normal',
),
'delivery_mode' => array(
'type' => 'varchar(32)',
'label' => '来源店铺发货模式',
'default' => '',
'comment' => '可选值请参考ome_shop表的delivery_mode (self=>自发,jingxiao=>经销)'
),
'diff_order_bn' => array(
'type' => 'varchar(32)',
'label' => app::get('ome')->_('补差价订单'),
'in_list' => true,
),
'diff_money' => array(
'type' => 'money',
'label' => app::get('ome')->_('补差价费'),
'in_list' => true,
'default' => 0,
),
'change_amount' => array(
'type' => 'money',
'label' => app::get('ome')->_('换出金额'),
'in_list' => true,
'default' => 0,
),
'cost_freight_money' => array(
'type' => 'money',
'label' => app::get('ome')->_('买家承担的邮费'),
'in_list' => true,
'default' => 0,
),
'need_sv' => array(
'type' => 'bool',
'default' => 'true',
),
'branch_id' => array(
'type' => 'table:branch@ome',
'editable' => false,
'in_list' => true,
'label' => '仓库',
'comment' => '仓库',
),
'bcmoney' => array(
'type' => 'money',
'label' => app::get('ome')->_('补偿费用'),
'in_list' => true,
'default' => 0,
),
'return_freight' => array(
'type' => 'money',
'label' => app::get('ome')->_('退货寄回运费'),
'in_list' => true,
'default' => 0,
),
'source' => array(
'type' => 'varchar(50)',
'default' => 'local',
'editable' => false,
'label' => '来源',
'in_list' => true,
),
'outer_lastmodify' => array(
'label' => '收货时间',
'type' => 'time',
'width' => 130,
'editable' => false,
'filtertype' => 'time',
'in_list' => true,
'default_in_list' => false,
),
'out_iso_bn' => array(
'type' => 'varchar(32)',
'label' => '外部单号',
'is_title' => true,
'width' => 125,
'filtertype' => 'normal',
'filterdefault' => true,
'in_list' => true,
'default_in_list' => false,
),
'archive' => array(
'type' => 'tinyint unsigned',
'required' => true,
'default' => 0,
'editable' => false,
),
'check_time' => array(
'type' => 'time',
'comment' => '单据审核时间',
'editable' => false,
'label' => '单据审核时间',
'in_list' => true,
),
'changebranch_id' => array(
'type' => 'number',
'editable' => false,
'label' => '换货仓库ID',
'comment' => '换货仓库ID',
),
'sync_status' => array(
'type' => array(
'1' => '发起中',
'2' => '推送失败',
'3' => '推送成功',
'4' => '取消失败',
),
'default' => '1',
'width' => 75,
'required' => true,
'label' => '同步状态',
'in_list' => true,
'filtertype' => 'yes',
'filterdefault' => true,
'in_list' => true,
'default_in_list' => false,
),
'sync_code' => array (
'type' => 'varchar(32)',
'label' => '同步WMS错误码',
'editable' => false,
'filtertype' => 'normal',
'filterdefault' => true,
'in_list' => false,
'default_in_list' => false,
),
'sync_msg' => array(
'type' => 'varchar(350)',
'label' => '同步失败原因',
'editable' => false,
'in_list' => true,
'default_in_list' => false,
),
'change_order_id' => array(
'type' => 'int unsigned',
'default' => 0,
'editable' => false,
'label' => '换货订单ID',
),
'shop_type' => array(
'type' => 'varchar(50)',
'label' => '店铺类型',
'width' => 75,
'editable' => false,
'in_list' => true,
),
'org_id' => array(
'type' => 'table:operation_organization@ome',
'label' => '运营组织',
'editable' => false,
'width' => 60,
'filtertype' => 'normal',
'filterdefault' => true,
'in_list' => true,
'default_in_list' => true,
),
'flag_type' => array(
'type' => 'bigint(20)',
'label' => '标识',
'editable' => false,
'default' => '0',
),
'is_not_combine' => array(
'type' => 'bigint(20)',
'default' => 0,
'editable' => false,
'label' => '是否不允许审核',
'comment' => '退款转退货拦截是否不允许审核位掩码同orders.is_not_combine',
'in_list' => false,
'default_in_list' => false,
),
'order_type' => array(
'type' => 'varchar(32)',
'default' => '',
'editable' => false,
'label' => '订单类型',
'comment' => '退款转退货拦截订单类型platform=平台订单',
'in_list' => false,
'default_in_list' => false,
),
'platform_status' => array(
'type' => 'varchar(30)',
'editable' => false,
'label' => '平台售后状态',
'default' => '',
'in_list' => false,
'default_in_list' => false,
'filtertype' => 'normal',
'filterdefault' => true,
),
'is_modify' => array(
'type' => 'bool',
'default' => 'false',
'editable' => false,
'label' => '平台编辑',
'width' => 90,
'filtertype' => 'yes',
'filterdefault' => true,
'in_list' => true,
'default_in_list' => true,
),
'abnormal_status' => array(
'type' => 'bigint(20)',
'label' => '异常状态标识位',
'editable' => false,
'default' => '0',
'in_list' => false,
'default_in_list' => false,
),
'extend_info' => array(
'type' => 'text',
'label' => '扩展信息',
'in_list' => false,
'default_in_list' => false,
),
'refund_status' => array(
'type' => [
'ing' => '退款中',
'finish' => '退款完成',
'refuse' => '退款拒绝',
],
'label' => '退款状态',
'in_list' => true,
'default_in_list' => true,
'filtertype' => 'yes',
'filterdefault' => true,
),
'jsrefund_flag' => array(
'type' => array(
0 => '否',
1 => '是',
),
'default' => '0',
'editable' => false,
'label' => '极速退款',
'width' => 65,
'in_list' => true,
'default_in_list' => true,
),
'refund_shipping_fee' => array(
'type' => 'money',
'editable' => false,
'label' => '退运费金额',
'in_list' => true,
'default_in_list' => true,
'width' => 75,
'default' => 0,
),
'is_gap' => array(
'type' => array(
0 => '否',
1 => '是',
),
'editable' => false,
'label' => '短收',
'width' => 65,
'in_list' => true,
'default_in_list' => false,
'filtertype' => 'yes',
'filterdefault' => true,
),
'betc_id' => array(
'type' => 'int unsigned',
'default' => 0,
'editable' => false,
'label' => '贸易公司ID',
),
'cos_id' => array(
'type' => 'int unsigned',
'default' => 0,
'editable' => false,
'label' => '组织架构ID',
),
),
'comment' => '退换货单表',
'index' => array(
'ind_diff_order_bn' => array(
'columns' => array('diff_order_bn'),
),
'ind_reship_bn_shop' => array(
'columns' => array(
0 => 'reship_bn',
1 => 'shop_id',
),
'prefix' => 'unique',
),
'ind_is_check' => array(
'columns' => array(
'is_check','return_type','delivery_mode'
),
),
'ind_return_type' => array(
'columns' => array(
0 => 'return_type',
),
),
'ind_t_begin' => array(
'columns' => array(
0 => 't_begin',
),
),
'ind_change_order_id' => array(
'columns' => array(
0 => 'change_order_id',
),
),
'ind_logi_no' => array(
'columns' => array(
0 => 'logi_no',
),
),
'ind_return_logi_no' => array(
'columns' => array(
0 => 'return_logi_no',
),
),
'ind_platform_status' => array(
'columns' => array(
0 => 'platform_status',
),
),
'ind_refund_status' => array(
'columns' => array(
0 => 'refund_status',
),
),
'idx_org_return_mode' => array(
'columns' => array(
0 => 'delivery_mode',
1 => 'return_type',
2 => 'org_id',
),
),
'ind_is_gap' => array(
'columns' => array(
0 => 'is_gap',
),
),
'ind_betc_id' => array(
'columns' => array(
0 => 'betc_id',
),
),
'ind_cos_id' => array(
'columns' => array(
0 => 'cos_id',
),
),
'ind_platform_order_bn' => array(
'columns' => array(
0 => 'platform_order_bn',
),
),
),
'engine' => 'innodb',
'version' => '$Rev: $',
'charset' => 'utf8mb4',
);