Simple web backoffice + backend for mobile apps

A simple backend + backoffice for mobile applications.

Single language is accepted (preferred: Italian, accepted in English), predisposition to multi-language is welcome.

Data input simply profiled. With bulk data (incremental) import support.

Data output through json http services, implemented with RESTfull services (will be placed behind an

http cache).

Data structure

All IDs must be strings (not long). Order columns must be exported as numeric, or lower case strings.

Data entities

• SpecialOffer

• id (string – choosen by user)

• Title

• Type (string – from this list: “standard”, “contest”, “gift”)

• Subtitle

• Description (multiline, no markup)

• Associated Image (PNG, JPEG, more details will be provided)

• Offer start date

• Offer end date

• Price (mandatory only if type “standard”)

• Promotion Price

• Club Price

• Stores (or Resellers)

• id (string – choosen by user)

• Name

• HasOffers (flag true / false)

• Address

• City

• State (Italian province)

• Postal code

• Latitude / Longitude

• Opening Scheduling (can be multi-line text)

• Phone Number

• Email

• Website

• Advices

• id (string – choosen by user)

• Title

• Subtitle

• Description (multi-line, no markup)

• Associated Image (PNG, JPEG, more details will be provided)

• SpecialOffer categories (hierarchical)

• id (string – choosen by user)

• Name

• Highlighted flag

• leafCategory flag (leaf = can't have child categories, can have SpecialOffers as child)

• Order

• “Parent” (free to define the hierarchy as suited)

• Advices categories

• id (string – choosen by user)

• Name

• Section (string, two options: “house”, “person”)

• Customers

• id

• Name

• this is an internal data entity: used for profiling data input and linking Stores to

Products and Stores to Advices

User Experience

• Possibility of viewing, listing and editing categories hierarchy, order, add / remove / modify them (user friendly) [edit only for administrator]

• Bulk / batch update for SpecialOffers, Stores (by customer) (~100 contents per batch, every 2 weeks for each Customer) and for Advices

• Should be incremental

• Data structure of will be provided: it will contain static reference to the categories IDs, a list of fields and a reference to Images provided, everything well formatted into an archive file – it will be an archive (Zip) containing XML / XLS + images

• Users will mainly use this feature to insert contents (SpecialOffers, Advices, Stores), they will contain references to the category IDs, customer will come from the login information or administrator choice.

• If the file contains error it should be reported and no changes should be performed in the database

• should support updates of previous contents

• referenced ids (categories) should be checked, record skipped / import aborted if some ID is not matching

• Possibility of viewing, listing and editing SpecialOffers by Customer, order, add / remove / modify them (user friendly)

• Possibility of viewing, listing and editing Advices by Customer, order, add / remove / modify them (user friendly)

• Possibility of viewing, listing and editing Stores by Customer, order, add / remove / modify them (user friendly)

Image format / size validation is not required.

Development & Deployment

The application should be provided with auto-configuration wizard or the possibility to deploy the same code, without modification, in multiple environments, with external configuration.

Nor hard-coded URLs, nor hard-coded configurations in the application code are acceptable.

Should be shipped with any automatic build system (Maven, Ant, ...), which one is your choice.

The essential documentation on how to set up the environment and configure it must be provided.

A private git repository (access through SSH keys) will be made available for development, this is not a condition but we would like it to be used.

The application MUST run on Linux servers with free of charge licenses databases (mysql is preferred) and dependencies... (see attachment for more info)

HTML JavaScript MySQL Diseño de sitios web

Nº del proyecto: #1710374

Sobre el proyecto