mirror of
https://gitee.com/ShopeX/OMS
synced 2026-03-22 10:25:35 +08:00
265 lines
9.4 KiB
PHP
265 lines
9.4 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.
|
||
*/
|
||
|
||
|
||
$db['regulation_apply'] = array(
|
||
'comment' => '规则应用中心',
|
||
'columns' => array(
|
||
'id' => array(
|
||
'type' => 'mediumint(8) unsigned',
|
||
'required' => true,
|
||
'pkey' => true,
|
||
'extra' => 'auto_increment',
|
||
'label' => 'ID',
|
||
'comment' => ''
|
||
),
|
||
'bn' => array(
|
||
'type' => 'bn',
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('应用编码'),
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'comment' => ''
|
||
),
|
||
'heading' => array(
|
||
'type' => 'varchar(200)',
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('应用名称'),
|
||
'is_title' => true,
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'searchtype' => 'has',
|
||
'comment' => '',
|
||
),
|
||
'condition' => array(
|
||
'type' => array(
|
||
'frame' => '商品上下架',
|
||
'stock' => '库存更新'
|
||
),
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('规则类型'),
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'filterdefault' => true,
|
||
'filtertype' => 'normal',
|
||
'comment' => ''
|
||
),
|
||
'style' => array(
|
||
'type' => array(
|
||
'fix' => '定时',
|
||
'stock_change' => '库存变动',
|
||
'order_change' => '库存变动(不含订单出库)',
|
||
),
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('触发条件'),
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'searchtype' => 'nequal',
|
||
'comment' => ''
|
||
),
|
||
|
||
'start_time' => array(
|
||
'type' => 'time',
|
||
'required' => false,
|
||
'label' => app::get('inventorydepth')->_('开启时间'),
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'filterdefault' => true,
|
||
'filtertype' => 'normal',
|
||
'comment' => ''
|
||
),
|
||
'end_time' => array(
|
||
'type' => 'time',
|
||
'required' => false,
|
||
'label' => app::get('inventorydepth')->_('截止时间'),
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'filterdefault' => true,
|
||
'filtertype' => 'normal',
|
||
'comment' => ''
|
||
),
|
||
'shop_id' => array(
|
||
'type' => 'longtext',
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('店铺名称'),
|
||
'comment' => '对应店铺表的shop_id'
|
||
),
|
||
'using' => array(
|
||
'type' => 'bool',
|
||
'required' => false,
|
||
'default' => 'false',
|
||
'label' => app::get('inventorydepth')->_('启用状态'),
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'filterdefault' => true,
|
||
'filtertype' => 'normal',
|
||
'comment' => ''
|
||
),
|
||
'al_exec' => array(
|
||
'type' => 'bool',
|
||
'required' => true,
|
||
'default' => 'false',
|
||
'label' => app::get('inventorydepth')->_('是否执行'),
|
||
'comment' => ''
|
||
),
|
||
'exec_time' => array(
|
||
'type' => 'time',
|
||
'required' => false,
|
||
'label' => app::get('inventorydepth')->_('最后执行时间'),
|
||
'comment' => ''
|
||
),
|
||
'operator' => array(
|
||
'type' => 'table:account@pam',
|
||
'required' => false,
|
||
'label' => app::get('inventorydepth')->_('操作人'),
|
||
'in_list' => true,
|
||
'comment' => ''
|
||
),
|
||
'update_time' => array(
|
||
'type' => 'last_modify',
|
||
'required' => false,
|
||
'label' => app::get('inventorydepth')->_('最后更新时间'),
|
||
'in_list' => true,
|
||
'comment' => '',
|
||
),
|
||
'operator_ip' => array(
|
||
'type' => 'ipaddr',
|
||
'required' => false,
|
||
'label' => app::get('inventorydepth')->_('操作人IP'),
|
||
'comment' => ''
|
||
),
|
||
'apply_goods' => array(
|
||
'type' => 'longtext',
|
||
'default' => null,
|
||
'label' => app::get('inventorydepth')->_('销售物料ID'),
|
||
'in_list' => false,
|
||
'default_in_list' => false,
|
||
),
|
||
'apply_pkg' => array(
|
||
'type' => 'longtext',
|
||
'default' => null,
|
||
'label' => app::get('inventorydepth')->_('禁用此字段'),
|
||
'in_list' => false,
|
||
'default_in_list' => false,
|
||
),
|
||
'apply_pko' => array(
|
||
'type' => 'longtext',
|
||
'default' => null,
|
||
'label' => app::get('inventorydepth')->_('禁用此字段'),
|
||
'in_list' => false,
|
||
'default_in_list' => false,
|
||
),
|
||
'shop_sku_id' => array(
|
||
'type' => 'longtext',
|
||
'default' => null,
|
||
'comment' => '平台的sku_id',
|
||
),
|
||
'regulation_id' => array(
|
||
'type' => 'table:regulation@inventorydepth',
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('规则Id'),
|
||
'comment' => ''
|
||
),
|
||
'priority' => array(
|
||
'type' => 'mediumint(8)',
|
||
'required' => true,
|
||
'label' => app::get('inventorydepth')->_('规则应用等级'),
|
||
'default' => 1,
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
),
|
||
'type' => array(
|
||
'type' => array(
|
||
0 => app::get('inventorydepth')->_('全局级'),
|
||
1 => app::get('inventorydepth')->_('店铺级'),
|
||
2 => app::get('inventorydepth')->_('商品级'),
|
||
3 => '门店级',
|
||
),
|
||
'default' => '2',
|
||
),
|
||
'sync_mode' => array(
|
||
'type' => array(
|
||
'total' => '仓库总和回写',
|
||
'warehouse' => '分仓库回写',
|
||
),
|
||
'label' => app::get('inventorydepth')->_('回写模式'),
|
||
'default' => 'total',
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
),
|
||
'supply_branch_id' => array(
|
||
'type' => 'longtext',
|
||
'required' => false,
|
||
'default' => null,
|
||
'label' => '专用供货仓',
|
||
'in_list' => false,
|
||
'default_in_list' => false,
|
||
'comment' => '专用供货仓ID，多个用逗号分隔，优先级高于店铺默认供货仓'
|
||
),
|
||
'apply_object_type' => array(
|
||
'type' => array(
|
||
1 => '全部商品',
|
||
2 => '指定商品',
|
||
3 => '客户分类商品'
|
||
),
|
||
'required' => false,
|
||
'default' => 1,
|
||
'label' => '应用对象类型',
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'comment' => '专用供货仓应用对象类型'
|
||
),
|
||
'apply_object_filter' => array(
|
||
'type' => 'longtext',
|
||
'required' => false,
|
||
'default' => null,
|
||
'label' => '应用对象筛选条件',
|
||
'in_list' => false,
|
||
'default_in_list' => false,
|
||
'comment' => '应用对象筛选条件（JSON格式，支持客户分类、品牌等多种条件）'
|
||
),
|
||
'is_sync_subwarehouse' => array(
|
||
'type' => 'intbool',
|
||
'required' => false,
|
||
'default' => '0',
|
||
'label' => '回写分仓',
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'comment' => '是否回写分仓库存，0=否，1=是'
|
||
),
|
||
'is_sync_store' => array(
|
||
'type' => 'intbool',
|
||
'required' => false,
|
||
'default' => '0',
|
||
'label' => '回写门店',
|
||
'in_list' => true,
|
||
'default_in_list' => true,
|
||
'comment' => '是否回写门店库存，0=否，1=是'
|
||
),
|
||
),
|
||
'index' => array(
|
||
'idx_start_time' => array(
|
||
'columns' => array('start_time')
|
||
),
|
||
'idx_end_time' => array(
|
||
'columns' => array('end_time')
|
||
),
|
||
),
|
||
'engine' => 'innodb',
|
||
'version' => '$Rev: $'
|
||
);
|