配送单.1

新增db

加个状态

CREATE TABLE `distribution_order`(
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `receive_begin_time` DATETIME NOT NULL,
  `receive_end_time` DATETIME NOT NULL,
  `resname` VARCHAR(64) DEFAULT NULL, 
  `order_id` VARCHAR(64) NOT NULL,
  `driver_name` VARCHAR(64) DEFAULT NULL, 
  `driver_phone` VARCHAR(64) DEFAULT NULL, 
  `carrier` VARCHAR(64) DEFAULT NULL, 
  `res_id` VARCHAR(64) NOT NULL, 
  `order_time` DATE NOT NULL ,
  `create_time` DATETIME NOT NULL,
  `update_time` DATETIME NOT NULL ,
  `print_time` DATETIME NOT NULL,
  `operator` VARCHAR(64) DEFAULT NULL, 
  `station_id` VARCHAR(64) NOT NULL, 
  `receiver_name` VARCHAR(64) DEFAULT NULL,
  `receiver_phone` VARCHAR(64) DEFAULT NULL,
  `receiver_address` VARCHAR(64) DEFAULT NULL,
  `freight` DECIMAL(12,2) DEFAULT NULL ,
  `geographical_label` VARCHAR(128) DEFAULT NULL, 
  `status` int not NULL default 1,
  `time_config_id` VARCHAR(32) NOT NULL,
  `extra1` int(11) DEFAULT NULL COMMENT '备份字段',
  `extra2` int(11) DEFAULT NULL COMMENT '备份字段',
  `extra3` varchar(32) DEFAULT NULL COMMENT '备份字段',
  `extra4` varchar(32) DEFAULT NULL COMMENT '备份字段',
  `extra5` datetime DEFAULT NULL COMMENT '备份字段',
  `extra6` datetime DEFAULT NULL COMMENT '备份字段',
  PRIMARY KEY (`id`),
  key idx_station_id_receive_begin_time_receive_end_time(`station_id`, `order_time`),
  key idx_order_id_receive_begin_time_receive_end_time(`order_id`, `order_time`)
);

CREATE TABLE `distribution_sku`(
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `distribution_order_id` int(11) NOT NULL,
  `sku_name` VARCHAR(64) NOT NULL ,
  `unit_price` DECIMAL(12, 2) NOT NULL ,
  `order_count` FLOAT NOT NULL ,
  `category_1_name` VARCHAR(64) DEFAULT NULL,
  `std_unit_name` VARCHAR(16) NOT NULL ,
  `sale_unit_name` VARCHAR(16) NOT NULL ,
  `category_2_name` VARCHAR(16) DEFAULT NULL,
  `pinlei_name` VARCHAR(16) DEFAULT NULL,
  `sale_ratio` FLOAT NOT NULL ,
  `sale_out_stock_nums` FLOAT NOT NULL ,
  `custom_id` VARCHAR(64) DEFAULT NULL,
  `remark` VARCHAR(64) DEFAULT NULL,
  `merchandise_remark` VARCHAR(64) DEFAULT NULL,
  `update_time` DATETIME NOT NULL ,
  'create_time' DATETIME NOT NULL ,
  `extra1` int(11) DEFAULT NULL COMMENT '备份字段',
  `extra2` int(11) DEFAULT NULL COMMENT '备份字段',
  `extra3` varchar(32) DEFAULT NULL COMMENT '备份字段',
  `extra4` varchar(32) DEFAULT NULL COMMENT '备份字段',
  `extra5` datetime DEFAULT NULL COMMENT '备份字段',
  `extra6` datetime DEFAULT NULL COMMENT '备份字段',
  PRIMARY KEY (`id`),
  key idx_list_id (`distribution_order_id`)
);

CREATE TABLE `distribution_abnormal_sku`(
   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `distribution_order_id` int(11) NOT NULL,
  `sku_name` VARCHAR(64) NOT NULL ,
  `abnormal_reason` VARCHAR(512) DEFAULT NULL,
  `abnormal_desc` VARCHAR(512) DEFAULT NULL ,
  `abnormal_nums` FLOAT NOT NULL ,
  `std_unit_name` VARCHAR(64) NOT NULL ,
  `abnormal_money` DECIMAL(12, 2) NOT NULL ,
  `update_time` DATETIME NOT NULL ,
  'create_time' DATETIME NOT NULL ,
  `extra1` int(11) DEFAULT NULL COMMENT '备份字段',
  `extra2` int(11) DEFAULT NULL COMMENT '备份字段',
  `extra3` varchar(32) DEFAULT NULL COMMENT '备份字段',
  `extra4` varchar(32) DEFAULT NULL COMMENT '备份字段',
  `extra5` datetime DEFAULT NULL COMMENT '备份字段',
  `extra6` datetime DEFAULT NULL COMMENT '备份字段',
  PRIMARY KEY (`id`),
  key idx_list_id (`distribution_order_id`)
);

新增接口

/station/transport/distribution_order/submit 提交配送单

METHOD POST
请求
    order_id M str
    freight O float

    skus: [
        {
            name M str
            category_title_1 O str
            category_title_2 O str
            pinlei_titile O str
            sale_unit_price M float
            sale_unit_name M str
            std_unit_name M str
            sale_ratio M float
            real_weight_sale M float 出库数销售单位
            outer_id O str
            desc O str 商品描述
            remark O str 备注
            quantity M float 下单数
        },
        ...
    ]

    exception_skus: [
        {
            name M str
            type_text O str 异常原因
            text O str 异常描述
            amount_delta M float 异常数量
            std_unit_name M str
            money_delta M float 异常金额
        },
        ...
    ]
响应:
    code    M   int     返回码，0表示成功，其他表示错误
    msg     M   string  错误信息
    data    无

/station/transport/distribution_order/export 导出

METHOD GET
请求
    order_time_begin O date
    order_time_end O date
    cycle_start_time O datetime
    cycle_end_time O datetime
    receive_begin_time O datetime
    receive_end_time O datetime
    time_config_id O str
    offset O int defualt 10
    limit O int default 0
    search_text O str
响应:
    code    M   int     返回码，0表示成功，其他表示错误
    msg     M   string  错误信息
    data    {
        distribution_list: [
            {
                station_name M str
                res_name M str
                total_order_money M float
                total_outstock_money M float
                total_exception_money M float
                freight M float
                driver_name M str
                print_time M str
                operator M str
                res_id M str
            },
            ...
        ]
    }
        sku_details: [
            {
                order_time M date
                order_id M str
                station_id M str
                station_name M str
                res_name M str
                category_1_name M str
                category_2_name M str
                sku_name M str
                sale_ratio M float
                sale_out_stock_nums M float
                std_unit_name M str
                sale_unit_name M str
                unit_price M float
                custom_id M str
                order_count M float
                exception_money M float
                merchandise_remark M str
                pinlei_name M str
            },
            ...
        ]

        exception_sku_details: [
            {
                sku_name M str
                std_unit_name M str
                abnormal_money M str
                abnormal_reason M str
                abnormal_desc M str
                abnormal_nums M float
            }
        ]

/station/transport/distribution_order/list 搜索

METHOD GET
请求
   order_time_begin O date
    order_time_end O date
    cycle_start_time O datetime
    cycle_end_time O datetime
    receive_begin_time O datetime
    receive_end_time O datetime
    time_config_id O str
    offset O int defualt 10
    limit O int default 0
    search_text O str
响应
    code    M   int     返回码，0表示成功，其他表示错误
    msg     M   string  错误信息 
    data  M [
        {
            id M int
            order_id M str
            res_name M str
            sku_nums M float
            total_order_money M float
            total_exception_money M float
            freight M float
            print_time M datetime
            operator M str 
        },
        ...
    ]

/station/transport/distribution_order/get 导出一条

METHOD GET
请求
    id M int
响应
    data: {
       distribution_list: [{
                station_name M str
                res_name M str
                total_order_money M float
                total_outstock_money M float
                total_exception_money M float
                freight M float
                driver_name M str
                print_time M str
                operator M str
                res_id M str
            }],
            sku_details: [
            {
                order_time M date
                order_id M str
                station_id M str
                station_name M str
                res_name M str
                category_1_name M str
                category_2_name M str
                sku_name M str
                sale_ratio M float
                sale_out_stock_nums M float
                std_unit_name M str
                sale_unit_name M str
                unit_price M float
                custom_id M str
                order_count M float
                exception_money M float
                merchandise_remark M str
                pinlei_name M str
            },
            ...
        ]
        exception_sku_details: [
            {
                sku_name M str
                std_unit_name M str
                abnormal_money M str
                abnormal_reason M str
                abnormal_desc M str
                abnormal_nums M float
            }
        ]
    }