Delphi FMX Android Data Collector App to generate PDF reports

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.