As more and more businesses start to look at online systems that are tailroed to the needs of the business, it is inevitable that this will result in custom database design and tailored solutions.
While tailored solutions are great for increasing effenciency and streamlining operations, the server that your online system is hosted on can very quickly come under pressure and start to lag if you don't follow some of the fundamental principles of database design.
-
New CCIG Website
Contracted by AsQuick Computer Services to build a new website for CCIG.
Built using a CMS platform, this new CCIG website was an upgrade from the previous one-page website and featured a new design and significantly more content.
This CMS platform allows the head office administrators to log in and edit the content on the site as needed.
This CMS platform is also connected to a custom back end utility for CCIG, the Online System Pelco built, and allows them to edit stores from the internal system, with the store information automatically being copied into the public website.
This clever setup of a custom online intranet for employees that connects store data to an open source CMS ensure that the team at CCIG have the perfect internal solution with the peace of mind of knowing the front end CMS platform can very easily be extended on with add-ons.
-
Storman Online Quote Manager
Continuing on with the contract work for Storman, Pelco was contracted to build the code and functions behind an online quoting management tool.
This system has a range of sections and features, including:
- Price List Manager - This allows admin to create price lists for the various items and allows the staff to assign a currency to the price list.
- Company Manager - This allows admin staff to create, edit and manage companies that are going through teh quoting process.
- Quote Manager - This allows the staff to create the quotes for the selected company by assigning a price list and then adding items from that pricelist into the quote.
- Lead Source Manager - This provides the staff with the ability to manage a set listing client lead sources, providing valuable marketing data.
In addition to having the ability to select a price list and items for the quote, the staff can also download a PDF version of the quote for emailing to the client. This allows employees to track quotes online while still maintaining that person-to-person contact that can be so crucial early on in a new client relationship.
-
1300 Locate Online
Pelco Consulting was contracted to build a custom online booking system for 1300 Locate, after having previously built the 1300 Locate website on behalf of All Media Solutions.
This custom online system for 1300 Locate was built on the Pelco Consulting myJobs platform and features an online real-time calendar for the management of bookings.
This complex system features the ability to create vehicles, assign services to the vehicle and then assign employees to the vehicle. A booking can then be placed against the vehicle and when the user logs into the system via a mobile device, it display a list of work in queue.
The custom system allows these users to go into the job and add comments while on site via the mobile and mark the work as completed. The driver of the vehicle then uses the next job in queue to continue work and the head office staff can log in via a desktop and add bookings as they come into the system.
It features an GUI calendar format that supports 5 minute intervals for bookings and supports both 24 hour booking or booking only via the standard trading hours.
In addition to this handy online calendar for managing bookings in real-time, the system also features a full client and client contact management utility, project tracking and asset tracking for the client.
With a huge range of administrative functions, including editing the lists and options for the various sections, the myJobs platform was customised from the core platform to support the complex booking format that was required by the client.
-
Spot Dog Walk Online - Phase 1
Pelco Consulting was contracted by Spot Dog Walk to build a custom online system to centralise the management of clients and bookings for the various walkers spread across Brisbane.
This custom online system was built using the platform available from Pelco for online system customisation known as myJobs.
The needs of Spot Dog Walk saw them require a database of customers and the pets for the various clients along with the management of the services offered by Spot Dog Walk.
The custom online system also features staff management and the assignment of bookings to employees. An employee is then able to log into the system either from home or via a mobile device to view the bookings they have in queue.
The online system allows the walker to log back into the system to complete the feedback for the job via a mobile on the job or when they arrive at home. Upon completion of the feedback, the system checks if the client for the pet has subscribed to alerts and will add the feedback from the walk to the email queue. Once the feedback is approved by the head office staff, the email is added to the process queue and sent when the system runs the emails.
In addition to having full management of staff, services, clients, client pets and pet bookings, the system also features reports as requested by the client for payroll purposes and trackign the amount of work completed by the staff.
With a huge amount of control and the ability to easily add new sections, this custom online system build is the first phase in a three stage build for Spot Dog Walk.
Â
-
CCIG Online
Pelco Consulting was contracted to rebuild the online system for Cash Converters Investment Group as the previous platform had certain aspects that did not quiet meet the needs and requirements.
This new custom online system was built as a custom coded platform and features a news managment utility, bulleting boards per store, an online document repository, online calendar, feedback and a huge range of administrative tools, including managing the various store, companies and users.
The custom online system allows for the assignment of different access levels to different user groups to allow store employees, store managers, store owners, head office staff and system administrators to all log in and view content relevant to them with certain pages and sections being limited to specific user groups.
The custom online system for CCIG was built using the PHP language and is utilises a mySQL database.
As the world becomes more and more specialised, with less and less ‘Jack-Of-All-Trades’ around, it seems inevitable that stand out employees will come along. These are the people that are generally so good at what they do the very thought of replacing them is offensive. If you are a manager, you will no doubt know exactly who these people are and what strengths and weaknesses each of them have and despite the old cliché that everyone is replaceable, the reality is that you want to keep this employee around. So how do you go about it?
Now before jumping into some of the methods that can be followed to help keep a hold of these employees it is important to recognise that all employees are different and no hard and fast rule applies. It is crucial to managing people effectively that this is taken into consideration and different people and personalities can respond very differently under certain circumstances.
AJAX Linked Drop List Fields
myJobs features a field type which will provide two drop list select fields. The selection of the first field determines what is available in the second field without reloading the page.
This is commonly referred to an AJAX update function on the page and will allows for users to create linked seletions.
One example of this application is to have a field that looks up a client with the second field showing a list of projects, contacts or other item/s that are linked to that client.
This allows for the simple combination of data across tables into a singular database in a quick and user friendly method without any coding as these fields can be setup via the form field manager in the administration portal.
For more information on how an online system such as myJobs Premium could help your business, do not hesitate to contact Pelco Consulting.
