Portfolio » Web Applications

Zen Cart Sales Reporting

Zen Cart is a popular open source e-commerce platform. This is a custom reporting tool which queries views and reports the information using charts and PDF documents. Statistical information ranges from popular products to the most profitable. The flexibilty of the application allows to connect to Crystal Reporting if needed.

With the use of JSCharts, data is read from an xml file which was generated from a job scheduler. Spring security allows for roles to be defined and easily managed either with LDAP, XML or a database.

Features

• Stored Procedures and Views
• Design Patterns
• JSTL
• CRUD Capability
• Spring MVC
• Javascript
• Javamail
• Glassfish
• Spring Security
• Dispatcher Servlet
• JDBC
• Log4J
• MYSQL
• Cron4j
• JSCharts
• iText

Code Snippet

 

//create child element, add an attribute, and add to root
Element dataset = doc.createElement("dataset");
dataset.setAttribute("type", "line");
root.appendChild(dataset);

for (Object item : pData.getMonthlyReportList()) {

Element datasetChild = doc.createElement("data");
datasetChild.setAttribute("unit", ((MonthlyTO) (item)).getDay() + "");
datasetChild.setAttribute("value", ((MonthlyTO) (item)).getSales() + "");
dataset.appendChild(datasetChild);
}
...	   

screenshots