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

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

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

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 設計目標 ４
2.2 開發(fā)及運行環(huán)境 ４
2.3 APACHE、PHP、MYSQL解決方案的優(yōu)勢 ４
3 總體設計 ５
3.1 方案圖 ５
3.2 模塊結(jié)構(gòu)圖 ６
3.3 流程圖 ７
3.4 數(shù)據(jù)庫設計 ８
4 詳細設計 １２
4.1 數(shù)據(jù)訪問類 １３
4.1.1 BaseDB類 １４
4.1.2 實體類 １５
4.1.3 操作類 １５
4.2基礎資料 １６
4.2.1 維護產(chǎn)品 １７
4.3貿(mào)易管理 １８
4.4船運管理 １９
4.4.1 維護裝箱單 １９
4.4.2 生成報關(guān)單 ２１
4.5系統(tǒng)管理 ２２
4.5.1 用戶權(quán)限控制 ２２
4.6報表設計 ２４
4.6.1 PDF報表 ２４
4.6.1 EXCEL報表 ２６
5 系統(tǒng)安裝與維護 ２９
5.1 安裝數(shù)據(jù)庫及應用程序 ２９
6 開發(fā)總結(jié) ２９
6.1 總結(jié) ２９
6.2 致謝 ３０
參考文獻 ３０