Hi,
I would like to hire somebody to help us with some custom features.
What I need implemented is some custom reports.
For this I need an additional item under Reports in the Main menu.
That will bring up a page that will allow me to select a report (maintained in a new table ‘reports’)
Further it will have three fields that will be used to customize a MySQL query (the template of which is also stored in the table ‘reports’)
Then we have two buttons: ‘Show’ to display the results below the input mask and ‘CSV’ to create a csv file to download. The number of columns displayed can either be stored in the table ‘reports’ or dynamically obtained from the columns of the MySQL query.
Let me know if you are interested - we need it fast - and how much you think it will cost us.
Thanks,
Gunter
I’ve noticed that some developers shy away from accepting solicitation for work through the forum. If nobody bites, shop around for contributors on this page.
Hi Tony,
I want to get something that will allow me (with decent knowledge in mysql queries) to add reports accessible to the staff who knows nothing about databases.
For that I envision a new table ‘reports’ maybe that has columns for
name | sql template | # output columns | and whatever there might be necessary
A selection box would be filled with the ‘name’ fields of all records in the table to allow the staff member to select a report.
The sql template of a query that would then contains placeholders like |fromfield| and |tofield| as in
select
patient_data.lname as LName,
patient_data.fname as FName,
drugs.name as Product,
drug_sales.sale_date as Date,
drug_sales.fee as Price,
drug_sales.quantity as Quantity
from
drug_sales, drugs, patient_data
where
drug_sales.drug_id = drugs.drug_id
AND
drug_sales.pid = patient_data.pid
AND
drug_sales.sale_date >= ‘|fromfield|’
AND
drug_sales.sale_date <= ‘|tofield|’;
These placeholders have to be replaced dynamically when the report is generated and for that I would need two input fields. The content of these fields as entered by the staff member would then replace these placeholders in the MySQL statement.
Where I need help is the integration into OpenEMR as I don’t know too much about that yet. I imagine that there will be a new menu option ‘Custom’ under
Reports >> Clinic (after AMC Tracking).
Selecting that would show on the right side the mask that shows the drop down list with the report names and two or three fields to augment the query.
Then there would be two buttons for Show and Export (for CSV output).
Please send me a quote to gunter.zielke at gmail dot com and how fast you could do that job. I really only need the framework - all the logic behind that I could potentially myself.
Hi Tony,
we sure will - it’s also my intention to make this into a feature that can be used by many. So far I have no idea on how this sharing process will work but I am sure you do
I am excited - let’s get this off the ground asap.
Gunter
