# 金蝶ERP采购订单查询

**Repository Path**: dabian/SpringBoot-VUE-ERP

## Basic Information

- **Project Name**: 金蝶ERP采购订单查询
- **Description**: 金蝶ERP采购订单查询
- **Primary Language**: Java
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 7
- **Forks**: 4
- **Created**: 2021-12-15
- **Last Updated**: 2024-06-03

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# 金蝶ERP采购订单查询

#### 介绍
金蝶ERP采购订单查询

#### 项目预览

登陆界面

![](https://gitee.com/dabian/SpringBoot-VUE-ERP/raw/master/images/login.png)

采购订单查询

![](https://gitee.com/dabian/SpringBoot-VUE-ERP/raw/master/images/home1.png)

![](https://gitee.com/dabian/SpringBoot-VUE-ERP/raw/master/images/home2.png)

![](https://gitee.com/dabian/SpringBoot-VUE-ERP/raw/master/images/home3.png)



用户查询

![](https://gitee.com/dabian/SpringBoot-VUE-ERP/raw/master/images/user.png)



#### 软件架构

金蝶采购订单查询

技术：SpringBoot+MybatisPlus+Mysql+VUE+ElementPlus

vue前端：springboot-client

java后端：springboot-vue-erp

用户名：admin，密码：123456

数据库：

​	用户表-user.sql

​	采购订单表-purchase.sql




#### 安装教程

一、java后端启动步骤：

1.创建数据库:

​	导入用户表:user.sql

​	导入采购订单表:purchase.sql

2.修改数据库连接:

\springboot-vue-erp\src\main\resources\application.properties

3.用idea打开springboot-vue-erp:

​	启动\src\main\java\com\cygia\SpringbootVueApplication.java

4.测试后台接口：localhost:9000/user/pageUser

5.后台接口测试：

查询用户：http://localhost:9000/user/pageUser

查询采购订单：http://localhost:9000/purchase/pagePurchase



二、vue前端启动步骤：

1.进入springboot-client文件夹

2.安装依赖npm i

3.运行npm run serve

4.浏览器测试localhost:9876，用户名：admin，密码：123456





#### --番外知识：

##### 金蝶ERP采购订单查询sql：

--采购订单    ---数据库[AIS----------1538] 珠海/苏州/深圳运泰利

select hhgk.FNAME 采购组织,tpr.FBILLNO 采购订单号,cchh.FNAME 供应商,

cc.FNAME 采购员,ccah.FNUMBER 物料编码,ccah.FNAME 名称,ccah.FSPECIFICATION 规格型号     --tpr.FPURCHASERID 采购员id,

from t_PUR_POOrder tpr    --采购订单

join t_PUR_POOrderEntry pur on tpr.FID=pur.FID    --采购订单明细

left join 

(select tbd.FMATERIALID,tbd.FNUMBER,tbl.FNAME,tbl.FSPECIFICATION from T_BD_MATERIAL tbd

join T_BD_MATERIAL_L tbl on tbd.FMATERIALID=tbl.FMATERIALID

 ) ccah on pur.FMATERIALID=ccah.FMATERIALID   --物料编码

left join 

(select tbdo.FENTRYID,tbdo.FSTAFFID,tbdp.FNAME from 

 T_BD_OPERATORENTRY tbdo

join T_BD_OPERATORENTRY_L tbdp on tbdo.FENTRYID=tbdp.FENTRYID   ) cc   --业务员

on cc.FENTRYID=tpr.FPURCHASERID

left join ( 

select t_BD.FSUPPLIERID,t_BD.FNUMBER,t_BDa.FNAME from t_BD_Supplier t_BD

join t_BD_Supplier_l t_BDa on t_BDa.FSUPPLIERID=t_BD.FSUPPLIERID) cchh

ON cchh.FSUPPLIERID=tpr.FSUPPLIERID  --供应商

left join (select tor.FORGID,tor.FNUMBER,torg.FNAME from T_ORG_ORGANIZATIONS  tor

join T_ORG_ORGANIZATIONS_L torg on tor.FORGID=torg.FORGID) hhgk

on hhgk.FORGID=tpr.FPURCHASEORGID    --组织