We have a Drupal CMS installation for a TEST LABORATORY ON CONSTRUCTION MATERIALS, where employees fill forms with data (mostly numbers) they acquire in work areas doing some exams.
We have ~15 types of forms with 15 fields/columns each. We use a node type for every form/exam, because every form can have multiple rows (node structure is quite simple, but forms are not) to resolve this, we’ll use a Field Collection in every node with “infinite” values for every node. But, if you have a better solution (always using drupal), you’re welcome.
We need an app to complete forms offline. Forms are often completed in remote areas where internet connectivity is either unavailable or very poor, so we need an App that will work synchronizing data when connection is available.
Your task is to develop the app and make the Drupal Synchronization (with Drupal Services?)
The final solution will be in italian language, but we can manage to work on an english one first. Support for creating the Italian one will be given to you.
DRUPAL DATA STRUCTURE (TO DATE)
Actually the data structure is:
Node type: customer (fields: customer id, customer details, name
Node type: procedure (fields: procedure id, customer id, subject)
Node type: exam1 (fields: form (Field Collection with many values), procedure id, (assigned to) employee uid, date, attached file)
Node type: exam2 (fields: form (Field Collection with many values), procedure id, (assigned to) employee uid, date, attached file)
Etc… for every exam.
HOW WE IMAGINE IT
Every day a manager create a procedure and assign exams to it (with a form to fill, date, and assign a user/employee to it). This is our part, we will work on Drupal for it.
WHAT WE ASK TO YOU (THE STEPS WE PAY FOR)
Your part: every day employees will login into the App (they are existing drupal users) and they will see on a calendar/list the exams (forms) assigned to them (remember the “assigned to” field?) and they will fill them. Employees have just few options: see exams/forms and fill them (pherhaps see the assigned procedures). So, on synchronization (pushing a button) the app will download new forms/exams for the employee and upload the completed ones (nodes are created on drupal). This is crucial to us.
We imagine an app with a login and a menu bar. Simple use and simple interface. Landscape tablet use (Android only, apk and no Play Store). In all those steps the app must be available and working even with no internet connection.
The app must be able to create forms dynamically. In a way that we can create a kind of configuration file that gives the app the guidelines to create every type of form (XML file, mysql, we are open to any kind of solution you will give to us).
1. You must work on a repository with sources we can fetch at every step and at every time. Sources for all the work must all be our property.
2. Assistance for 12 month after releasing the app for small non-structural editing
Works you’ve done previously with Android App and Drupal (Drupal services, etc).