Create me a simple database management script
£250-750 GBP
착불
This script will be a framework used to control a set of custom database tables and needs to:
1. Use a dokuwiki auth file for user authentication, but does not need to display data or pages within dokuwiki.
2. Be written in PHP (7.3 compatible) with a MySQL backend. Make use of dymanic inpage loading via javascript to increase speed and reduce the need for full page refreshes. 3rd party PHP Framework is negotiable and must be well known if required (I.E. CakePHP etc.) 3rd party frameworks with licencing fees will not be accepted
3. Allow me to create new database tables to store specific data (I.E. name each column)
4. Allow me to enter and modify single rows in a database with freetext, use columns from other existing database tables (select the relevant table and column during setup) with multiselect ticklist, single select radio button or text search or, set up a list with descriptions which may be used as single radio or multiple ticklist.
5. Allow me to enable/disable entire tables from use with warnings if columns of data are used to populate other areas.
6. Allow me to export selected tables to tabbed csv files or (preferably) prebuilt excel template
7. Allow me to display data from within each table as an html page with options to exclude database rows based on user criteria (I.E. if date of review is within the past 300 days, do not display the row, only display rows where "supplier status" is "current"). HTML should be basic tables with definable colour coding based on criteria. I will need to be able to modify any entry using double click.
8. Allow for daily cronjob to send email warnings based on criteria (I.E. when "date of last review" is more than "300 days ago" email "risk owner" with this message "XXXX"). Ensure that emails are combined for each person so they will only receive a single email with all their notifications. There should also be an alerts page for each user which contains all details of these generated alerts.
9. Bug fixes must be applied free of charge for a period of at least 3 months following project completion. New features would be considered as a separate project and therefore by chargeable.
10. Code must be well commented and of a high standard to allow future developers to work with it. If the project is completed to a high standard, you will be given first refusal for future development work.
11. Any requirement for ongoing licencing fees will be rejected. Code must be provided in its entirety with no encryption (I.E. ioncube etc) and will not be property of the coder following project completion.
12. Information security is paramount and must be considered at all stages. Chances for data breaches should be minimised and there should be no scope to gain access to data without an appropriate login. Ideally tools such as burp-suite will be used by the coder to verify security prior to project delivery. Information Security issues detected by penetration testing within the 3 months following project completion must be fixed without extra charge.
13. There must be levels of access for users. "Admin" (can do anything and set up new sheets), "Modify All", "Modify all within specific tables", "Modify owned rows within specific tables only", "View only"
This script is currently working as an excel file with named ranges and VBA code for ticklists. On successful project acceptance a copy of the spreadsheet can be supplied but no data entry will be required by the coder. All data entry and setup will be done by me.
This project may appear complex but in actuality is very simple once the requirements are properly understood. Feel free to message me for clarifications.
Full specification will be provided if your bid is appropriate. Examples of tables I may use this script to create are attached in pdf. The coder will not be required to perform any data entry, only to create the management script.
프로젝트 ID: #22041112
프로젝트 소개
이 일자리에 대한 프리랜서 71 명의 평균 입찰가: £526
Hello I am checking the attached document / website , I will submit my detailed estimation with in 50 minutes Thanks for your patient Gopal
How are you? I have checked your description carefully one by one. My name is Yanying Ding, a full stack web developer with extensive knowledge in the PHP and Mysql database area. I have rich experience in the Core PHP 기타
Hello sir. I have good skills and experiences as you requested on your project. You can see my results as follow. https://www.freelancer.com/u/abstractsoftweb?w=f I am very interested in your project. If you hire me, 기타
Hi, We have understood your requirement. And, have done this previously with perfection. We have 7+ professional development experience. Looking forward to discuss your project on chat to share with you our Portfolio
Hello , I am full stack developer mainly working on software and script development, having vast experience on 3rd party APIs integration and customization, I have gone through from your requirement and understood com 기타
Hi, I am ready to start right away. I have reviewed your job description as well and very confident to handle this project perfectly. I will do multiple revision in your project with 100% satisfaction work guaranteed 기타
Honestly, I am still going through your job description. But as far as the skills concern, you can totally rely on me. I can also adjust the pricing once we are clear on requirements. Let's have a quick chat to discus 기타
HEllo Sir/mam there, Hope you are doing good!!! I recently Reached across your job post and felt that I can assist you perfectly. I have 6+ years of working experience as a website developer & Mobile developer as we 기타
Hello.. I have read your post very carefully and I have understood what you want. I am sure I can handle your project perfectly in the quick timeline. Let me know if you have some time to discuss the details further. L 기타
I'll create a simple database management script and give you best quality work. Please message me for further assistance. Thanks Bhavesh
Hello, sir! I have read your job description carefully. As a senior full stack developer who has rich experiences in ecommerce website development, I have been working for 6 years in information technology. Also I hav 기타
Hi, I just reviewed your project description and interested in your job now. I am a full-stack developer who have rich experience in web development. Especially I have great knowledge and experience in PHP, Codeignite 기타
Hello Here is a full-stack developer with 6 years of experience. I have read your attachment and I think my skills and experiences are really fit your project. Here are my skills: Backend: PHP(Laravel), Node.JS(Exp 기타
INTRODUCTION I am an experienced Professional with Database Programming and Administration skills across MySQL, MS SQL and Business Intelligence Development. I have 4+ years’ experience with Database Programming and 기타
⭐⭐⭐⭐⭐Dear Client. How are you?⭐⭐⭐⭐⭐ I have review requirements and gathered features for your project. I have gained 5+years of experience and expertise working on PHP based Frameworks and Libraries. And I have exte 기타