8th Sem Result

Raghu Sir

Sathyatechnologies, Ameerpet.

PROJECT OVERIVIEW [by Raghu Sir] Our project Name is: Product Log

It is used to link different warehouse applications with E-Commerce application. Which integrates logistics and supply chain management (Items selling and purchasing) applications. Users’ multi-level transport systems like Air Cargo, Goods Trains, Tracks, ship containers services. It supports order tracking and tracing of Shipping, Final bill generation etc. Warehouse is location where different type’s items are stored in well-arranged format like RACKS, PALLETS, and Clod Storages etc. Different E-Commerce Applications has to link without applications using EDI process as consumer to read all item. E-Commerce application means on-line shipping sites like Amazon, flipkart, snapdeal. Our project is divided into multipart-level having multiple modules.  Project has mainly 3 Levels o Roles and Location o Item and Transaction o Billings & Payments and Reports 1. Roles and Location Roles in applications are:1. 2. 3. 4.

Admin User Vendor Customers

Vendor and Customer are also connected to Location Module. 2. Item and Transactions Transactions Type is:1. 2. 3. 4.

1|P ag e

PT (Purchase Transaction) Invoice for Vendor RN(Received Note) Shipping (To End-User)

Raghu Sir

Sathyatechnologies, Ameerpet.

3. Billings, Payments and Reports 1. Final Billing(Vendor<-> Customer) 2. Payment Gateway Integration with App 3. Excel and PDF Exports 4. Chart (BAR or PIE) 5. Documents for contracts, Bill & Invoices (Upload and Downloads)

1. Roles and Location : AppUser will create/modify vendors. A vendor is like a contractor who gets details of customers (warehouse and E-commerce) Application details.  Vendor will be registered by user. Every vendor will be allocated to one location.  Vendor contacts the customer type warehouse, also called as seller of items and ECommerce called as consumers of items.  Every customer details must be entered in our application by user.  Customer registration contains customer Name, Licence Number, Location, Contract Number, full Address , communication details, contactPeriod, service Identification, email , type (Seller/Consumer). On customer creation done, generated pwd, and Access Token will be send to email & save in customer table as encoded format.

2. Item and Transactions: Items which are manufactured in factories will be sent to warehouses for storage. Form warehouses those items details are send to OurApp & it will distribute the details to different E-Commerce Apps.  OnceEnd-user makes order using E-Commerce Transactions proves starts and executes in given order (see transactions flow)

2|P ag e

Raghu Sir

Sathyatechnologies, Ameerpet.

3. Reports and Billings:Excel and PDF reports generation process is implemented using Spring Framework using abstract class. Those are:AbstractExcelView and AbstractPdfView For every module we have given Excel Export same important modules having Excel Export is Locations, Vendors, Customers, Items, RN(Receive Note) and Shipping Modules. PDF is used for Final Billing and Invoice Modules. Apache POI is used for Excel. Configuration with HSSF API in below Format. I. II. III. IV.

HSSFBook = book => 1 …n sheets HSSFSheet => sheet => 1…n rows HSSFRow => row => 1…n cells HSSFCell => Cell => Contains Data

*) Row and Cell number start with zero. 

BAR and PIE Charts Here we used JFreeCharts (open source), to generate Bar and Pie charts. For Items and Availableqty,Transactions details (%). Locations wise Vendors and customer charts are designed

3|P ag e

Raghu Sir

Sathyatechnologies, Ameerpet.

Technical Flow is:Dataset => ChartFactory => JFreeChart => obj=>ChartUtils=>Image=>UI 4. Document In application we have provided documents upload and download module for storing of contract copy between Vendors and Customer, Final Billing by Date doc, Important invoices etc. We implemented this module using multipart concept given by ApacheCommonMultipartResolver(implemented by spring Framework). Final Bills:After providing services to customers, we charge them for Transaction basic or % basic (2-5 % on profit gained). It can also be like weekly/monthly /yearly charges in case of mutual Agreements

taken from customers.

Database 4|P ag e

Mail