Delphi FMX Android Data Collector App to generate PDF reports
$250-750 USD
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.
Projekt-ID: #11180533
Über das Projekt
Vergeben an:
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
13 Freelancer bieten im Durchschnitt $683 für diesen Job
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
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
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