SITE ON AND OFF RECORDING with TESTING Data and storage via SQL Software package
$250-750 AUD
Lukket
Slået op næsten 7 år siden
$250-750 AUD
Betales ved levering
Part 1 - Database SQL 2012
A- Store 1 - "Site ON"
Receives and stores a data stream from Ethernet port 10001, this stream is in the format %DATA (5 characters), PERSON ID (3 to 6 characters), SITE ID (8 characters), Date dd/mm/yy, Time hr:min:sec
example - %0.002,401123,0000 0358, 26/05/17,10 :10:51
or
%STOPD,401123,0000 0358, 26/05/17,10 :10:51
This data will be stored for later use.
Also to pull datafile sync from another database that has list of PERSON ID numbers and has the persons name and Department listed. Need to import this data regularly to allow the card PERSON ID swipes to be stored as a name. This sync should occur every 30 minutes
Recorded data will be
DATE, TIME, PERSON ID, NAME, DEPARTMENT, DATA
B- Store 2 - "SITE OFF"
Receives data from a USB keyboard emulator card reader. This will just stream the PERSON ID and a carriage return.
This needs to be stored in a second store with date and time received.
Also to pull datafile sync from another database that has list of PERSON ID numbers and has the persons name and Department listed. Need to import this data regularly to allow the card PERSON ID swipes to be stored as a name. This sync should occur every 30 minutes
DATE, TIME, PERSON ID, NAME, DEPARTMENT
C- Store 3 - Comparison of store 1 to store 2
DATE, TIME, PERSON ID, NAME, DEPARTMENT, DATA, DRUG TEST DATE, ONSITE (YES/NO), ONSITE DATE AND TIME, OFFSITE DATE AND TIME
A third store generated from the first 2 that will show a list of PERSON ID numbers and DATA VALUE from stream part A. So this will show a list of active onsite ID numbers and test results.
Process if read in part A occurs ID and DATA is shown in this active store. A value of YES needs to be set in a field to shown the person is onsite. If a read in part B occurs the PERSON ID is compared to the active list and the last active PERSON ID that matches is found and the date and time of this second USB read is recorded and the Active field value is set to NO
This will therefore create an active list that shows a person is onsite or the time they went offsite a field will change fro, YES for onsite to NO for offsite.
PART 2 - This option provides a visual display on the WHOLE PC SCREEN,
This will have a login area by username and password. Login will allow configuration of
Less than or equal to value for %DATA - Value will show on screen with GREEN background for 5 seconds
Greater than or equal to value for %DATA - Value will show onscreen for 10 seconds with RED background and display text "REPORT TO SUPERVISOR OR PARAMEDIC FOR FURTHER TESTING, DO NOT START WORK" and a warning tone will play on the speakers of the PC.
Another option to either turn on or turn of random selection and have a percentage value to base around the number of samples you wish to take. Example
RANDOM TEST On/Off
TEST BASIS % User input
For this part when a data stream is received on the Ethernet port that matches the Part A format it is put through a random selection process based on the TEST BASIS % to select the read for further testing. If the read is selected by the random selection process the screen will have a YELLOW Text box overlay appear above the result. This Text box will say " YOU HAVE BEEN RANDOMLY SELECTED FOR A DRUG TEST, PLEASE REPORT TO THE PARAMEDIC OR CALL SUPERVISOR"
This will be recorded in the database Store 1 against the PERSON ID value as to the recorded drug test. The random selection should work on prioritising PERSON ID with a date since last tested greater than 2 months.
`we have expertise in SQL,MySQL,php, DBA, Data processing. Client satisfaction is our main motto for long term relationship.
Relevant Skills and Experience
software architecture,SQL,MySQL,php, DBA, Data processing
Proposed Milestones
$300 AUD - whole
I am expert on SQL, C#, MySql, I can complete your project 100% perfectly.
Relevant Skills and Experience
I have good knowledge on C#, SQL, TCP/IP, Socket, so I think I can complete your project perfectly..
I just need your help, Then I can complete it 100% perfectly..
Proposed Milestones
$390 AUD - You will pay me after complete project..
If you have questions please ask me..
I need to understand if you want only database or you want software (C++, #) to read, write and show information (using hw)
Relevant Skills and Experience
database, eHealth software, integration eHealth data, c#, c++
Proposed Milestones
$100 AUD - Database definition
$500 AUD - Beta version
$511 AUD - Deploy
Additional Services Offered
$1 AUD - Web developments
please respond my question (point 1)