Web Applications

We have a great track record and years of industry experience in specialised applications for intranet, content management and commerce.

Resource Planning

Programming, GUI Design, Security, User management, Usability, Search

The customer sells a large range of 3rd party and in-house subscription services along with proprietary client software and various delivery methods. Many of their international sales are via local resellers.

We made a custom-built ERP-type system enabling the resellers to:

  • Access the latest information on the product range
  • Manage their customers
  • Place orders directly and change existing subscription
  • Securely download contracts and software updates
  • Access a personal inbox containing announcements and advisories

It was also decided to build an incorporated audit trail of all events in the system which would help the customer keep compliance with the 3rd party provider's contracts and regulations.

The system was built as a set of modules which could easily be extended to form the basis for a company-wide intranet with the user system providing access to other administrative applications. For example, it would be fairly simple to add accounting capabilities to the system to greatly extend its usefulness.

 

User access and management

The administration and using the system are all performed in the same environment. Using a supervisor login simply causes a wider range of options to appear.

The permissioning system is very fine-grained, allowing users to be set up with a wide range of specific rights. For example, this could be used where a reseller wants somebody in their office to be able to log in and update customer records but not to be able to make modifications to their subscriptions.

The customer's legacy system had also made it very difficult to obtain certain datasets. This was solved here, bringing obvious benefits to the customer's support desk and marketing department. The customer is now able to understand which subscribers globally are using which services, whether they have current model satellite cards, distribution of services by location, churn rates and so on.

Messaging and notifications

The inbox system also brings significant reduction of administration.

When a new announcement is posted, each recipient receives a notification by email with the direct url of the announcement (accessed by logging in). Each user has an inbox with a large number of search and filter options so that they can backtrack easily through announcements. There is a an icon always visible, indicating whether the user has any unread mail. Announcements can contain html and multiple attachments and be sent only to specific resellers or groups if required. A requested feature from the customer's management was that it would be possible to tell which recipients had read a particular announcement.

Document and file management

The document and file download areas were an elegant solution to the problem of secure file access via a web browser. Usually this is done using password protection. However, this is easily crackable by brute force and presents an extra hurdle to the user. We designed a different technique, with the files themselves located completely outside the web tree and piped in.

Usability and search

Browse screens have a large number of sorting and filtering options along with useful tooltips and record highlighting. This results in a very comprehensive and easy to read view of the data in a small screen area.

Content Management

Programming, Database design, GUI Design, Security, Usability, Multi-lingual

This is a simple but highly flexible CMS (Content Management System).

Main features:

  • In-site editing interface for content
  • Multi-lingual Content can contain php, javascript, html
  • Unlimited nesting of content

CMS guide: overview (logged in users see the normal site but with editable areas) CMS guide: edit popup screen (each user is assigned to a localisation)

Commerce

Programming, Database design, GUI Design, Security, Usability, Commerce

The client sells monthly subscriptions to various in-house and 3rd party data feeds delivered as a package through its client software.

The customer wanted a way to sell subscriptions online, taking payment by credit card. The data feeds have highly complex pricing and many of them require separate contracts to be signed.

Usability

The system has been designed to hide as much complexity as possible from the user whilst maximising data capture. The user is taken through 3 simple steps: entering their personal details, choosing their services, and finally reviewing the order and entering payment information.

Handling complex pricing requirements

Each service has two fees: one from the client and one from the 3rd party supplier. The client usually collects both of these. 3rd party supplier fees are in various currencies and have their own price schemes which can be based on various factors such as number of terminals, professional status of subscriber, location of terminal etc. These fees are subject to change from time to time and it was specified that it should be possible to create scheduled fees (this also allowed time-limited special offers if required). In addition the customer charges fees for each service which again vary in amount and currency dependent on subscriber's professional status, terminal number and location.

Ease of administration

Administration of services, prices, exchange rates and contracts is performed by a small browser-based application suite. Contracts are maintained in a browser-based WYSIWYG editor which also allows the administrator to cut+paste Word documents.

There is also a simple reporting application which allows an administrator to see which users have signed up ordered by name, country or date. This also allows the administrator to view data captured from incomplete orders, choosing by the various stages completed.

Commerce - Holiday Lettings

The client is letting a holiday apartment. The requirements include:

  • Complex pricing with supplements, discounts and visits that may cross seasons
  • Calculation of a booking deposit to be paid online as part of the booking
  • Dates to be automatically blocked when a booking deposit is paid during a booking
  • Auto-responders to the customer and client
  • The option to let multiple apartments within the same system

A back-end admin where the client can:

  • Search bookings
  • See upcoming bookings at a glance
  • Edit all the details of bookings
  • Send emails with booking details to the customer and client's representatives
  • Manage admin accounts and permissions for client's representatives
  • Update availability calendars on third party sites

The user is presented with a simple form which checks availability, calculates the price of their booking and the deposit required to secure it. This is a link via the PayPal API. On successful payment, they are returned to the site which completes their booking, blocking their dates and sending an email to the client and a separet email to the customer with confirmation details and information about the apartment.

AJAX implementation in admin back-end allows owners to manage bookings intuitively from a single page

Acquia

Adub is an Acquia partner, providing end-to-end site development services and consulting in:

  • Strategy and planning
  • Module selection and development
  • Scalability and performance tuning
  • Migration and upgrades

Contact Us

If you'd like to get in touch about working with Adub, please enter your details below and we'll get straight back to you to see how we can help.

Blog