前端的需求:
1.现在不需要已结转和未结转两个模块
2.直接将采购付款明细页面照搬过来,放在账户选择的下面
3.通过勾选付款记录,点击“结转”,或者导入数据生成已结转的记录,已结转的记录显示在付款明细的下方
4.1688账单明细导入按钮和时间筛选放到最下方的1688账单明细模块
以下是已转结的数据库的表
CREATE TABLE `t_erp_purchase_form_payment` (
`id` BIGINT(20) UNSIGNED NOT NULL,
`formentryid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
`auditstatus` INT(10) NULL DEFAULT NULL COMMENT ‘1 已付款,2 请款中,0 驳回’,
`payment_method` INT(10) NULL DEFAULT NULL COMMENT ‘1现金,2账期’,
`acct` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
`payprice` DECIMAL(18,2) NULL DEFAULT NULL,
`opttime` DATETIME NULL DEFAULT NULL,
`remark` VARCHAR(2000) NULL DEFAULT NULL COLLATE ‘utf8mb4_bin’,
`operator` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
`createdate` DATETIME NULL DEFAULT NULL,
`projectid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
`period_rollover_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `formentryid` (`formentryid`) USING BTREE
)
COLLATE=‘utf8mb4_bin’
ENGINE=InnoDB
ROW_FORMAT=DYNAMIC
;
以下是系统原本就有的表,新增了一个字段period_rollover_id
CREATE TABLE `t_erp_fin_account_period_rollover` (
`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT ‘ID’,
`acct` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT ‘账户ID,t_erp_fin_account表的ID’,
`total_amount` DECIMAL(20,6) UNSIGNED NULL DEFAULT NULL COMMENT ‘本次结转的费用’,
`operator` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT ‘操作人’,
`creator` BIGINT(20) UNSIGNED NULL DEFAULT NULL COMMENT ‘创建人’,
`opttime` DATETIME NULL DEFAULT NULL COMMENT ‘操作时间’,
`createtime` DATETIME NULL DEFAULT NULL COMMENT ‘创建时间’,
PRIMARY KEY (`id`) USING BTREE
)
COLLATE=‘utf8mb4_bin’
ENGINE=InnoDB
;