Delphi FMX Android Data Collector App to generate PDF reports

Fertiggestellt Veröffentlicht vor 7 Jahren Bezahlt bei Lieferung
Fertiggestellt Bezahlt bei Lieferung

Delphi Firemonkey/FMX Android and Windows Data Collector

A straightforward app that downloads appointments from a MySQL server and collects data and photos at each appointment and then uploads the form data and photos through a manual sync process whenever the Android device is connected to the internet.

Requirements:

• I AM ABSOLUTELY LOOKING FOR A DELPHI SOLUTION USING THE FIREMONKEY/FMX FRAMEWORK. PLEASE DO NOT CONTACT ME ABOUT ALTERNATE DEVELOPMENT LANGUAGES.

• Must compile in Delphi 10 Enterprise and use the Delphi Firemonkey framework to impliment an Android client app (APK) and a Windows client app (WIN32 or WIN64 EXE).

• Any third party components must be pre-approved before inclusion in the software.

• APK and EXE can be delivered for testing purposes, but code must be delivered in a compilable form prior to milestone release for payment. This is a work made for hire.

• The primary database is a MySQL database containing the following tables:

• Users table to specify who can connect and use the system and their password and permissions.

UserID

UserName (string 25)

UserEmail (string 100)

UserPhone (string 25)

UserPassword (string 25)

IsAdmin to make user changes

IsScheduler to make and alter appointments

IsDataCollector to fulfill appointments

• Appointments table to specify appointments.

AppointmentID

Name, Permanent Address, Appointment Location

Email, Cell Phone, Work Phone

Appointment Description (string 50)

Appointment Details (memo)

Date and Start Time and Duration

IsCallRequested

IsSMSReminderRequested

AssignedUserID

IsAssigned

IsCompleted

CompletionDateTime

CompletionUserID

CompletionNotes (memo)

• FormQuestions table to setup questions at appointment

QuestionID

QuestionName (string 50)

QuestionText (memo)

IsRequired

IsPhotoPermitted

IsPhotoRequired

FieldType (character)

FieldMin (float)

FieldMax (float)

• FormData table to record answers to questions

AppointmentID

UserID

QuestionID

DataCollected (DateTime)

ResultText (memo)

ResultFloat

ResultDateTime

ResultBoolean

PhotoLocation

• Settings table on the server with one record and following fields:

CompanyName (string 100)

CompanyAddress (memo)

CompanyLogo (string 100 pointing to URL containing logo file)

• Client device Settings table with a single record containing server side preferences along with:

ServerAddress (string 255)

ServerPort (integer)

CompanyLogoLocalPath (string 255)

IsRememberLastUser

LastUserID

LastUserName

• Android Client app grabs appointments and can manually grab updated question list and form data table as well.

• Android Client app can work without internet connection to collect data and then sync/upload data and photographs back to the MySQL server when completed.

• Android Client app needs to have a smooth graphical user interface that works on tablet devices such as a Galaxy Tab or Asus Tablet.

• Android Client can fulfill appointment by asking all the questions in the FormQuestions table and recording the answers in new entries in the FormData table with the appropriate UserID and AppointmentID included.

• Android Client App uses the built in camera in the tablet to record pictures and store them in a folder on the tablet specific to this product (perhaps specified in settings) and stores the path of the picture in the PhotoLocation field in FormData. The photos are uploaded along with the FormData records and updated Appointment record upon sync.

• The Windows client can also generate two reports as PDF files.

• An appointment summary for a specified day, week or month, showing the appointments, their date and time and status and fields of data gathered and mandatory and optional field counts as well.

• An appointment detail report for a given appoint that shows the appointment time, assigned user, appointment data (name and address, etc...) and the questions and their answers in a visually pleasing format - including any photos as well in the PDF.

Android Delphi Mobile App Entwicklung MySQL

Projekt-ID: #11180533

Über das Projekt

13 Vorschläge Remote Projekt Aktiv vor 7 Jahren

Vergeben an:

victorcastro

Hello , I'm a Delphi specialist with more than 10 years of experience and currently working with firemonkey. I've participated in several projects for android and iOS with MySQL and other databases. Please contact me i Mehr

$620 USD in 25 Tagen
(18 Bewertungen)
5.9

13 Freelancer bieten im Durchschnitt $683 für diesen Job

prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i wi Mehr

$773 USD in 20 Tagen
(25 Bewertungen)
6.8
kukhtinigor

Hi. i can do your project. Couple questions 1. It have to be direct connection to MySQL or DataSnap? 2. Do you have a FireDac or i dbExpress? 3. Do you have a mock up? Because Table description is good of Mehr

$750 USD in 30 Tagen
(58 Bewertungen)
6.8
Shopify

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably Mehr

$773 USD in 20 Tagen
(10 Bewertungen)
6.4
mike199

My name is Mike and I’m from UK. I work with individual clients and also provide outsourcing services for a number of UK and USA based agencies. Your project description sounds interesting to me and I do have skills & Mehr

$672 USD in 10 Tagen
(15 Bewertungen)
6.0
miracitech37

Hi I have read your job description extremely carefully so now don’t need to worry we will give PROFESSIONAL work in MINIMUM PRICE and I am absolutely sure that our team can do the job very well but I have couple of qu Mehr

$555 USD in 10 Tagen
(7 Bewertungen)
5.0
dkarataev

I am professional with 10+ years of experience each that has worked with clients ranging from local businesses to global brands and enterprises. Technologies: Ionic/Cordova (Android&iOS), HTML5, PostCSS, CSS Modules, L Mehr

$736 USD in 10 Tagen
(8 Bewertungen)
4.4