SM&MS' ContractorPlus is a web based database of contractors who have been rigorously vetted to ensure their health and safety standards are of the highest quality.
The system allows clients to search on line for reputable contractors and even filter the search by contractor service or location.
ContractorPlus is the second phrase of the new SM&MS ERP System. It was designed to replace the existing ASP-based web application with new business functions.
One of the problems SM&MS experienced was to maintain the same data on different database applications and spreadsheets. Our development team decided to migrate and integrate all existing data into a single, centralised database. ContractorPlus and the previous AsbestosPlus was designed to accommodate this need.
This project is implemented in: JAVA 5.0, Java Servlet, JSP (JavaServer Page) and Java Tag Library. Utilising the FREE J2EE compliance Web Container Apache Tomcat 5.5, running on a FREE OpenSource Linux server - Debian.
The backend Database is migrated from an existing Microsoft Access database to Microsoft SQL Server 2000. For ultra fast performance, SQL queries were optimised and implemented in Stored Procedures and UDFs (User Define Function). The XML-output facility in MSSQL Server 2000 is also been used with the Java Tag Library for seamless XSLT integration on user interface.
In this project, the ultra-high performance framework Hibernate is used between the JAVA middleware and the database. It encapsulates most of the SQL coding for query and persisting data. Hence, reduce the development time.
Functionalities:
- Maintain data and monitoring progress of the ContractorPlus vetting process.
- Secure access by different types of user: consultant, client, contractor
- Document Management System: Upload and share documents between users with security measure.
- Automated email facility throughout the system: mailing list, membership reminder, register, lost password, etc.
- Various PDF report generation.
This project is the first component of the new SM&MS ERP System. It was designed to replace the existing Microsoft Access based application with a multi-user web application. The original Access System was accessed remotely by consultants via Microsoft Terminal Services, which require license for every user. Upgrading it to a web based application not only reduced the TCO (Total Cost of Ownership) but the increase system performance over a normal ADSL Internet connection.
This project is implemented in: JAVA 5.0, Java Servlet, JSP (JavaServer Page) and Java Tag Library. Utilising the FREE J2EE compliance Web Container Apache Tomcat 5.5, running on a FREE OpenSource Linux server - Debian.
The backend Database is migrated from an existing Microsoft Access database to Microsoft SQL Server 2000. For ultra fast performance, SQL queries were optimised and implemented in Stored Procedures and UDFs (User Define Function). The XML-output facility in MSSQL Server 2000 is also been used with the Java Tag Library for seamless XSLT integration on user interface.
The Offline Survey Manager is implemented in Java Web Start with data persistence in XML on client laptop computers.
Functionalities:
- Maintain data for thousands of asbestos survey, premise, client and contractor records.
- Secure access by different types of user: consultant, client, contractor, tenant, etc.
- Document Management System: Upload and share documents between users with security measure.
- Report Generation: A complex asbestos survey report generated on-the-fly in PDF format.
- Offline Survey Manager: Allow consultants to enter surveys' detail on their laptop computer while working on remote sites. The collected data can then be uploaded to the central database when consultant is back in the office or whenever the Internet is accessible from the laptop.
We have implemented the entire SM&MS official website, using a combination of HTML and JSP (JavaServer Page). Each website we design is vigorously tested and complies with W3C CSS and W3C HTML/XHTML as standard. The website is also tested on a number of different internet browsers and operating systems to ensure that the widest audience to the website can be achieved.
The website itself is developed and designed with page optimisation techniques which reduces the file size of the pages and the time to load, which therefore saves time and money.
We have also implemented a number of search engine optimisation (SEO) techniques that are used throughout the website to provide SM&MS with a good page rankings in the majority of search engines.
Functionalities:
- Separate content and style documents, which increases the speed of the website and makes the pages easier to read.
- Integrated feedback forms and e-mailer subscription pages.
- Fasttrack Quotation Service: Allows any person using the website to request an online quote. The system then notified the appropriate member of staff and they send them the quote back.
- Automated News Archive: This allows members of SM&MS to automatically add the latest news to the website, quickly and simply without having to change the webpage itself.
PropertyPlus is a fully functional database containing information relating to health and safety issues within premises of large corporations within the UK. PropertyPlus allows access and control to 100's of properties in its property management system. It was created with an integrated web application front end so each company's property information can be accessed anywhere in the country and at any time
The system contains a web application front end, which is written in ASP/XML and has various different functionalities. The website is contained within a SSL encryption layer for security, which is necessary to protect client confidentiality. The backend of the application uses MS SQL Server database technology. The database involves complex work flows and allows for various reports and data analysis.
Functionalities:
- SSL encryption security
- Online property management with integrated reports and analysis of properties within a company
- Multiple user groups and members functionalities
- Customisable user roles and security rights
- Report tracking and generation facilities
The orders/CRM system is a fully integrated contact relation system. It not only manages contacts, but orders, premises and companies. This is a client server distributed system that uses Java technology to manage staff, clients, premises and orders.
The system was developed using a custom designed database built in MS SQL Server, which is used to manage the data and provide security for the system. The CRM system can be securely accessed on site as well as remotely which supply's the user with added flexibility.
Generating reports in PDF format, management of various activities and analysis of database information can all be preformed by the CRM system. The system has been modified and updated on various occasions as the clients’ requirements have changed, and is soon to incorporate a web front end for clients to view the status of their orders, past orders and other services.
The system also has a UK map display incorporated within the current interface to allow for job scheduling and planning of jobs for that user.
- Java technology (platform independent)
- Local and remote access
- Report generation, management and marketing facilities
- Regular updates, improvements and added functionality
- Integrated map facility
- Multi-user security and group management
- Contact, premise and order management
Two Huddesfield firms have joined forces to bring workplace safety to the fore
