S
S
Sergey Malovichko2015-09-26 19:00:57
PHP
Sergey Malovichko, 2015-09-26 19:00:57

Offline web application with local DB, what technologies?

Good afternoon.
There is a project in php and mysql for forming an order for a counterparty:
With the following capabilities:

  1. Upload from 1C to mySql (tables: contractors, goods)
  2. Formation of the buyer's order according to current balances and prices.
  3. Uploading the table "orders" in 1C

Testing the application in the field showed:
Sales agents, using tablets , collected orders from city stores.
But when they started working outside the city (villages, villages), a natural problem arose - the lack of a reliable mobile Internet signal.
Since a lot of effort has already been invested in this bike, it was decided not to go astray: not to buy ready-made solutions, but to continue paving and building this bike.
There is an idea to switch to AngularJS + API (php) application with the ability to work offline.
Use LocalStorage or a similar database for local storage and manipulation of data. API sync.
There is not much data, no more than 1000 records in each table.
In fact, on this project, I learned a lot about php and the web in general.
I ask for help, to suggest technologies that would be suitable for this task.
I suspect that the selected direction vector is wrong.
The only thing I'm not ready for is learning native mobile languages.
Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rikcon, 2015-09-26
@mrSerg161

take PhoneGap and write an application that, if there is no connection to your database, writes to itself in sqlite, and if there is a connection, it sends it to your server (make the same switch somewhere in the interface).
Then, when there is already Internet, your application will send what it has in sqlite to your server, and delete it from itself, or whatever you want.
I advise phonegap.com because of the last point you have (that you don’t have time to write in a native language) + it will be cross-platform (iOS, Android, WP) so there will be no problems with the zoo of tablets either. Phonegap uses HTML, CSS and JS.
I would do so, purely IMHO,

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question