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
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
Blog
- Building a new Drupal team at Capgemini to work on some exciting projects. Get in touch if you know someone who should be part of that.
- Join us in London at Drupal Focus On Publishers - http://dfpublishers2010.eventbrite.com #dfpublishers2010
- At Brighton #develop conference. Looking at what drupal can bring to games.
- We now have a Drupal Enterprise group on LinkedIn - http://www.linkedin.com/groups?about=&gid=319970
- Attending Drupal for Social Media in London. ROI as the elephant in the room #BtSW
- Added a new presentation to slideshare - Drupal and Web Services - http://www.slideshare.net/Adub/drupal-and-web-services-4557521
- http://bit.ly/bji24d - Talking about Drupal Web Services and enterprise applications at Sun on Wednesday 26th May
- Thanks to everybody who worked so hard to pull it together in two days and Google for hosting #drupalvolcon
- I'm attending DrupalVolCon UK 2010 -- http://drupalvolcon.eventbrite.com #drupalvolcon
- @Dries Blog post: Look.co.uk switches to Drupal; traffic doubles within months http://bit.ly/bsjBfV
