基于PHP5+MySQL5的外貿(mào)單證管理系統(tǒng)

摘要
本文講述了利用Apache2,PHP5,MySQL5開源解決方案來實(shí)現(xiàn)B/S結(jié)構(gòu)的外貿(mào)單證管理系統(tǒng)。
外貿(mào)單證包括銷售訂單，采購合同，托單，裝箱單，報(bào)關(guān)單，發(fā)票等單證，將單證業(yè)務(wù)復(fù)雜的數(shù)據(jù)交由計(jì)算機(jī)系統(tǒng)來處理。工廠用戶遠(yuǎn)程登錄系統(tǒng)維護(hù)裝箱單，提高了數(shù)據(jù)的準(zhǔn)確性和及時(shí)性，單證自動(dòng)生成，減少了單證員的工作量，提高了工作效率。
實(shí)踐證明，此系統(tǒng)具有開發(fā)速度快，穩(wěn)定性好，可擴(kuò)展性強(qiáng)，維護(hù)部署方便，總成本低廉的優(yōu)點(diǎn)，提高了企業(yè)的工作效率，滿足企業(yè)的需求。

關(guān)鍵字: B/S  Apache  PHP  MySQL  外貿(mào)單證  裝箱單  報(bào)關(guān)單  發(fā)票 FPDF  WriteExcel  報(bào)表

Abstract
This article discusses how to develop a foreign trade documents management system based Brower/Server use Apache2, Php5 and MySQL5 open source software solution.
Trade documents include Sales Contract ,Purchase Contract ,Delivery Sheet, Packing List, Customs declaration form ,Invoice ,etc. We can process complicated business's data by computer. This software system can let remote factory’s user login system and maintain packing list, base these data we can auto generate behind trade form, so all of data are accurate and quickly, we can reduce employee's workload and improve work efficiency.
The practice proves this software system can be developed quickly, stably, well expansibility and maintained conveniently. A excellent aspect is the cost is low , can improve company's work efficiency and solve immediate requirement.

Keywords: B/S  Apache  PHP  MySQL  Foreign trade documents  Packing list  Customs declaration form  Invoice  FPDF  WriteExcel  Report
 
目錄
1 引 言 ３
2 需求分析 ４
2.1 設(shè)計(jì)目標(biāo) ４
2.2 開發(fā)及運(yùn)行環(huán)境 ４
2.3 APACHE、PHP、MYSQL解決方案的優(yōu)勢(shì) ４
3 總體設(shè)計(jì) ５
3.1 方案圖 ５
3.2 模塊結(jié)構(gòu)圖 ６
3.3 流程圖 ７
3.4 數(shù)據(jù)庫設(shè)計(jì) ８
4 詳細(xì)設(shè)計(jì) １２
4.1 數(shù)據(jù)訪問類 １３
4.1.1 BaseDB類 １４
4.1.2 實(shí)體類 １５
4.1.3 操作類 １５
4.2基礎(chǔ)資料 １６
4.2.1 維護(hù)產(chǎn)品 １７
4.3貿(mào)易管理 １８
4.4船運(yùn)管理 １９
4.4.1 維護(hù)裝箱單 １９
4.4.2 生成報(bào)關(guān)單 ２１
4.5系統(tǒng)管理 ２２
4.5.1 用戶權(quán)限控制 ２２
4.6報(bào)表設(shè)計(jì) ２４
4.6.1 PDF報(bào)表 ２４
4.6.1 EXCEL報(bào)表 ２６
5 系統(tǒng)安裝與維護(hù) ２９
5.1 安裝數(shù)據(jù)庫及應(yīng)用程序 ２９
6 開發(fā)總結(jié) ２９
6.1 總結(jié) ２９
6.2 致謝 ３０
參考文獻(xiàn) ３０