Create me a simple database management script

종료 등록 시간: 4년 전 착불
종료 착불

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.

PHP MySQL JavaScript HTML

프로젝트 ID: #22041112

프로젝트 소개

71 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 4년 전

이 일자리에 대한 프리랜서 71 명의 평균 입찰가: £526

dreamci

Nice to meet you I have more than 15 years development experience and a great team, we can complete your project with clean code and best practices We are working on hourly rate 40usd / hour. Please check my profile 기타

£500 GBP (5일 이내)
(207 리뷰)
8.7
graphicaa

Hello I am checking the attached document / website , I will submit my detailed estimation with in 50 minutes Thanks for your patient Gopal

£750 GBP (25일 이내)
(706 리뷰)
9.3
mituld

Hello! i checked the attached 3 pdf and read the specification This project is very interesting for me and perfect fit with my skills. I am available now and can start immediately. Hope to work with you and also i a 기타

£700 GBP (12일 이내)
(480 리뷰)
8.2
idragon712

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 기타

£500 GBP (10일 이내)
(100 리뷰)
7.8
abstractsoftweb

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, 기타

£300 GBP (7일 이내)
(165 리뷰)
7.6
maamekal

Yes, I have seen it very care fully and I am perfect understood so please give me a chance to work for you I am highly interested in this project. Sure, You must see my team skill than you think why we are best for th 기타

£250 GBP (7일 이내)
(175 리뷰)
7.2
an1566706

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

£250 GBP (7일 이내)
(80 리뷰)
6.7
webbrains30

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 기타

£550 GBP (12일 이내)
(110 리뷰)
6.6
Alka700

I have gone through your requirement, So I'm perfectly able to do this Job and I assure you that it will give you quality work in less than anticipating time. I appreciate it if you give me an interview call once to di 기타

£500 GBP (7일 이내)
(63 리뷰)
6.3
jamesmartin81

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 기타

£250 GBP (4일 이내)
(219 리뷰)
6.4
itpathsolutions

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 기타

£2500 GBP (7일 이내)
(38 리뷰)
6.3
Techinfomatic

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 기타

£500 GBP (7일 이내)
(43 리뷰)
6.2
atozweblogic

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 기타

£250 GBP (7일 이내)
(99 리뷰)
6.3
btpatel

I'll create a simple database management script and give you best quality work. Please message me for further assistance. Thanks Bhavesh

£740 GBP (15일 이내)
(72 리뷰)
6.1
seniorcoder024

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 기타

£500 GBP (7일 이내)
(36 리뷰)
5.8
EliteMobile330

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 기타

£500 GBP (7일 이내)
(31 리뷰)
5.7
hemsingh1

PHP, MySQL, Javascript, HTML skilled professional with the required expertise. Can help to deliver the solution as needed on the expected lines. Please private message me to discuss the project further. Hope to build a 기타

£600 GBP (7일 이내)
(82 리뷰)
5.7
coolmob0816

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 기타

£500 GBP (7일 이내)
(35 리뷰)
5.8
fanninson45

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 기타

£550 GBP (21일 이내)
(23 리뷰)
5.9
daistar125

⭐⭐⭐⭐⭐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 기타

£300 GBP (7일 이내)
(20 리뷰)
5.6