Create a simple Record Management system with Billing, on WordPress (2)
£750-1500 GBP
Paid on delivery
We run a Clinical Psychology Practice that provides services to corporate and private clients. We need a Clinical Records and Risk Management system, to help us manage case records, streamline billing, and reduce risk. Having researched WordPress capabilies, and experimented with it, we believe the requirements can be met with some wordpress customisations and additional coding.
Please note the following:
* I have some HTML skills (I used to develop websites when you could still do it in notepad ie before HTML3 :-) ) and understand SQL and C++ - so I will want to be able to discuss different ways of doing things at a technical level
* I've included a number of questions to the bidders within the document, highighted inside a box. To ensure that bidders are reading the spec before bidding and are bidding based on reading the spec and not just the description, please can you comment on whether you think using WP Categories as the Case container makes sense, and whether it's possible to manage and edit billing line items for posts in the way I've suggested [Any bid that does not answer these two questions will be ignored]. I want to make sure that you understand the detail of what we need from the system, and know enough about WordPress internals, MySQL, web programming and PHP to come up with a good solution that can be used as a building block for the future phases of functionality.
* I need the solution to be well documented. I need a register of every WP file that is modified or copied, and a description of what has been changed - and the changes need to be clearly documented with comments (in English) in the code. This is so that future contractors can build on the work. I understand that good documentation takes time and time costs money, but I would rather have a well documented and future-proof solution. Please do not under-estimate the work and then feel pressured to do a rush job
* This is work for hire, and the copyright to any code written will pass to the CherryCroft practice once the contract is concluded (work completed and paid for)
* Please comment on whether you've integrated with Xero before and whether there are any issues with doing so
I've added a simple Entity-Relationship Diagram to demonstrate how the data objects relate (standard 0/1 to many connectors show the ordinality of relationships between entities).
User, Case and Record are not separate table entities in WordPress, based on my vision, a Case is a Category so it is stored in wp_term and wp_termmeta, and a Records is acustom post type so its data (including custom fields) is stored in wp_post and wp_postmeta. user is a standard WP user, augmented with the WP-CRM plugin which uses wp_usermeta to store additional fields for each user.
The "crrm_*" entities are new custom database rables, stored in the "wordpress" schema and accessed from PHP using $wpdb() object. My preference is to use standalone tables for the financial data (contract header/lineitem and billing) rather than storing financial data as meta fields inside wp_postmeta, to make things like financial audit and reconcolisation easier - I can then use SELECT statements in MySQL to view and manipulate the financial data, and use MySQL Excel connectors to pull reporting into MS Excel from MySQL.
Project ID: #15544622
About the project
61 freelancers are bidding on average £1366 for this job
Hello, We have excellent team of developer and designer who meets your requirements. you can hire us hourly basis,we charge 18USD/hr . to initiate discussion private message us. Relevant Skills and Experience We have More
Create a simple Record Management system with Billing, on WordPress Relevant Skills and Experience HTML, MySQL, PHP, Website Design, WordPress 7 years experience Proposed Milestones £1250 GBP - task
Hey, I'm interested in your project. Please send me a message so that we can discuss more. Relevant Skills and Experience HTML, MySQL, PHP, Website Design, WordPress Proposed Milestones £1250 GBP - 1
i have alredy done this kind of job , i can do it 100% as you want , pls ping me so we can start right away ! thank you Relevant Skills and Experience wordpress Proposed Milestones £888 GBP - final Stay tuned, I'm More
Over the last 8 years, I have developed a wide range of websites and software and have the skills qualifications you are looking for. I am a Certified Developer and have rich experience Relevant Skills and Experience More
Hi, I went through your requirement and feel comfortable to do this job. I have good experience in website design & development. Please initiate chat to discuss further. Relevant Skills and Experience PHP, Word press, More
We are expert in creating Portal/Blog/e-commerce solution using WordPress. We read your requirement and we are confident to deliver you the best and standard solution Relevant Skills and Experience CMS: Wordpress Fram More
Hi, Yes... it's possible to manage and edit billing line items for posts in the way you have suggested. Please message me to have productive discussion on the same. Relevant Skills and Experience I have relevant ski More
Hello! My name is Maksim, from Kiev, Ukraine (UTF + 2) We are Intobi - hardworking and responsible team. Our developers have highly experience in the building of various websites and apps. Relevant Skills and Experie More
Hello There, Greetings of the days..!! I hope You Doing well. I am Abhishek. I Read carefully and Analyzed Your Provide Project Requirement for a Clinical Records and Risk Management system Relevant Skills and Experie More
Where is the attachment here? There's no attachment. Relevant Skills and Experience Please send us the attachment which we can go through and then probably we can get into a detailed discussion. Proposed Milestones £ More