项目描述
首先,发货客户与快递公司签订货运合同(货运单),把货物交给快递公司来托运,并按照货运合同的付款方式付款。快递公司根据货物运输线路,为货物配车,找到合适的车辆后,与司机签订运输合同(回执单),
并按照运输合同的运费结算方式结算。司机对货物检查无误后,装车,然后发车,发车后,货物的任何损失由司机承担。司机到达目的地后,需要经过货物验收,验收通过,填写一份司机回执单,快递公司这时同时通知发货客户和收货客户,货物已到达。
如果货物没有通过验收,则填写差错记录。如果该货物不需要中转,通知收货客户来提货,客户验收通过后,填写客户回执单,快递公司这时通知发货客户,所发货物已被提走。如果该货物需要中转,则填写一份中转信息单,快递公司这时同时通知发货客户和收货客户,货物已被中转。
中转成功后,收货客户来提货,并通知发货客户,货物已被提,然后进行转货结算。
运行环境
jdk7+tomcat7+mysql+eclipse(IntelliJ IDEA)+maven
项目技术(必填)
springboot2+layui+jquery
数据库文件
项目启动后自动创建
jar包文件
maven构建,自动下载架包
账号:GL846489 密码:123456
地址:http://localhost:9999/login.html
效果截图:
数据库设计:
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50717
Source Host : localhost:3306
Source Database : springboot_logistics
Target Server Type : MYSQL
Target Server Version : 50717
File Encoding : 65001
Date: 2019-01-22 08:56:49
*/
SET FOREIGN_KEY_CHECKS=0;
– Table structure for billinfo
DROP TABLE IF EXISTS billinfo
;
CREATE TABLE billinfo
(
id
int(11) NOT NULL AUTO_INCREMENT,
accept_station
varchar(50) DEFAULT NULL,
bill_code
varchar(50) DEFAULT NULL,
bill_state
varchar(50) DEFAULT NULL,
bill_type
varchar(50) DEFAULT NULL,
write_date
datetime(6) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of billinfo
– Table structure for billrelease
DROP TABLE IF EXISTS billrelease
;
CREATE TABLE billrelease
(
id
int(11) NOT NULL AUTO_INCREMENT,
accept_station
varchar(50) DEFAULT NULL,
bill_code
varchar(50) DEFAULT NULL,
bill_type
varchar(50) DEFAULT NULL,
receive_bill_person
varchar(50) DEFAULT NULL,
receive_bill_time
date DEFAULT NULL,
release_person
varchar(50) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of billrelease
– Table structure for callbackinfo
DROP TABLE IF EXISTS callbackinfo
;
CREATE TABLE callbackinfo
(
id
int(11) NOT NULL AUTO_INCREMENT,
bill_id
varchar(50) DEFAULT NULL,
bill_type
varchar(50) DEFAULT NULL,
content
varchar(255) DEFAULT NULL,
dial_no
varchar(50) DEFAULT NULL,
finally_dial_time
date DEFAULT NULL,
goods_bill_id
varchar(50) DEFAULT NULL,
locked
bit(1) NOT NULL,
success
bit(1) NOT NULL,
type
varchar(50) DEFAULT NULL,
write_time
date DEFAULT NULL,
writer
varchar(50) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of callbackinfo
– Table structure for carcost
DROP TABLE IF EXISTS carcost
;
CREATE TABLE carcost
(
driver_code
varchar(50) NOT NULL,
add_carriage_total
double NOT NULL,
allow_carry_weight
double DEFAULT NULL,
back_bill_code
varchar(255) DEFAULT NULL,
balance_time
datetime(6) DEFAULT NULL,
car_no
varchar(50) DEFAULT NULL,
car_type
varchar(50) DEFAULT NULL,
car_width
varchar(255) DEFAULT NULL,
carry_fee_total
double NOT NULL,
deal_goods_station
varchar(50) DEFAULT NULL,
fact_carriage_total
double NOT NULL,
goods_height
varchar(50) DEFAULT NULL,
load_station
varchar(50) DEFAULT NULL,
PRIMARY KEY (driver_code
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of carcost
– Table structure for cargoerror
DROP TABLE IF EXISTS cargoerror
;
CREATE TABLE cargoerror
(
id
int(11) NOT NULL AUTO_INCREMENT,
customer
varchar(50) DEFAULT NULL,
goods_bill_code
varchar(50) DEFAULT NULL,
goods_name
varchar(50) DEFAULT NULL,
goods_revert_bill_code
varchar(50) DEFAULT NULL,
goods_value
double DEFAULT NULL,
mistake_type
varchar(50) DEFAULT NULL,
piece_amount
int(11) DEFAULT NULL,
size
varchar(50) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of cargoerror
– Table structure for cargoreceipt
DROP TABLE IF EXISTS cargoreceipt
;
CREATE TABLE cargoreceipt
(
goods_revert_bill_code
varchar(50) NOT NULL,
accept_station
varchar(50) DEFAULT NULL,
all_carriage
double NOT NULL,
arrive_time
date DEFAULT NULL,
back_bill_state
varchar(50) DEFAULT NULL,
carriage_banlance_mode
varchar(50) DEFAULT NULL,
carriage_mode
varchar(50) DEFAULT NULL,
carry_goods_bill_deposit
double NOT NULL,
carry_goods_insurance
double NOT NULL,
deal_goods_station
varchar(50) DEFAULT NULL,
dispatch_service_fee
double NOT NULL,
driver_id
varchar(50) DEFAULT NULL,
if_balance
varchar(50) DEFAULT NULL,
insurance
double NOT NULL,
linkman_phone
varchar(50) DEFAULT NULL,
load_station
varchar(50) DEFAULT NULL,
receive_goods_detail_addr
varchar(50) DEFAULT NULL,
receive_goods_linkman
varchar(50) DEFAULT NULL,
remark
varchar(50) DEFAULT NULL,
sign_time
date DEFAULT NULL,
start_advance
double NOT NULL,
start_carry_time
date DEFAULT NULL,
PRIMARY KEY (goods_revert_bill_code
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
– Records of cargoreceipt
– Table structure for cargoreceiptdetail