Tamamlanmış

Web application for intranet - corporate users - php/mysql

We are looking for a small web application to be created to interface with a simple MySQL database. This application is to track outages and incidents for an Internet Service Provider. Records include a description of the outage, type, date/time, user, description, etc. Records will then need to be updated with comments. This would be similar to a basic ticketing system. I have included what we have for the MySQL data structure as a starting point. Slight modifications can be made to the database if needed and appropriate. This is a new system, no historical data is available.

Requirements:

* PHP 5.5.7 compatible (running on a Windows Server 2012, IIS)

* MySQL 5.0.11 compatible

* JQuery 1.4.4 is available but not required to use

* All development will need to take place on YOUR system. Deliverable should be a zip file with all needed files so that we can drop it onto our web server.

* Adequate in-line documentation of the code

* Brief over-view document describing the function of all major components and files

* Simple design, easy to modify

* Object oriented design

* No additional frameworks or extensions other than what is already listed here

* Minimal visual design, CSS. This web app is for employees to use. There is no need for elaborate designs. It should look professional and simple.

* No user security is needed. We will be securing the folder with Windows/IIS folder permissions. Username fields in the database should be populated with the environment variable $_SERVER["REMOTE_USER"]

* All tables should be sortable and pagination should be used when needed for queries returning more than 50 rows

* All form fields should be checked for compatibility with the database data type for that field

* All user input should be escaped to prevent accidental or intentional SQL injection and other common security concerns.

* All person's working on this project must be able to communicate in English during the hours of 8:00 and 19:00 Eastern Standard Time, Monday - Friday

* All work must be original or freely licensed

* Please respond in your bid that you understand all of these requirements

* All actions that a user takes in the created system should be logged to the "log" table. This would include adding new records, modifying, etc.

Design:

Title of system: Bulletin System

* Main page

-Should show all open incidents and their status. Should allow the user to select the record to edit/add/modify.

-Should have a column that displays in minutes how long has been since the incident has been updated

-Should have a column that displays in hours how long the incident has been open

* Create new incident page

-Should allow the user to enter required information. "date_created" Date/time and user fields should be automatically populated for the user.

-Should allow the user to create a new contact list for the incident, to be stored in the "contact_list" table.

* Edit content page

-Should allow the user to add comment records to an incident.

-Should have ask the user which contact list(s) should be notified (email) when the record is updated

-Should allow the user to update the incident_start_date and incident_stop_date with a graphical calendar selection (can use JQuery if wanted)

* Edit contact list page

-Should allow the user to add/modify a contact list for each incident

* Log page

-Should show a table of all of the recent log table rows

PHP Extensions Available (most of these are older versions. If you have a question about a specific extension version please ask):

bcmath

bz2

calendar

cgi-fcgi

com_dotnet

core

ctype

curl

date

dom

ereg

exif

fileinfo

filter

ftp

gd

gettext

gmp

hash

iconv

imap

intl

json

ldap

libxml

mbstring

mcrypt

mhash

mysql

mysqli

mysqlnd

odbc

opensll

pcre

PDO

pdo_mysql

Phar

Reflection

session

SimpleXML

soap

SPL

sqlsrv

ssh2

standard

tokenizer

wddx

xml

xmlreader

xmlwriter

zip

zlib

Beceriler: CSS, HTML, MySQL, PHP

Daha fazlasını gör: wysiwyg database builder, php application builder, knack apps, create a business app, web application builder, transpose app builder, database website, how to create a web based database, hotel web application php mysql script, scale php mysql web application, serveur web intranet php mysql, web based crm sfa freeware php mysql, php mysql leave management approval web application system, php mysql datediff minutes, php mysql sample web application, web application schedule asp php mysql, document appointment web application using php mysql, upload images share users php mysql code, registration users php mysql safe, application sales invoicing print php mysql

İşveren Hakkında:
( 10 değerlendirme ) Bristol, United States

Proje NO: #19629404

Seçilen:

Shumit9217

Hello, sir. Much interested in your project, and I'd read all of your requirements carefully. I'm thinking this is the suitable one you're looking for. I'd like to talk with you over chat, share more details of your re Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 250%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(2 Değerlendirme)
2.0

Bu iş için 48 freelancer ortalamada $527 teklif veriyor

Yknox

Dear,I am Jin_S web developer... I'm interested in the project you recently posted. I'm a certificated freelancer with over 1000 good reviews from clients. I have experienced knowledge in php. I never disappoint my Daha Fazla

$750 USD in 10 gün içinde
(727 Değerlendirme)
9.1
graphicaa

Hello, Thanks for the details. My understanding and confirmation of project scope listed in this pdf file [login to view URL] Please check and discuss, time/price can be final Daha Fazla

$750 USD in 18 gün içinde
(656 Değerlendirme)
9.1
omsoftware

Greetings, Thanks for the opportunity. It’s really exciting that we have a similar kind of expertise and work experience in PHP development Yes, we can develop web application using MYSQL and we are well experi Daha Fazla

$750 USD in 10 gün içinde
(153 Değerlendirme)
9.0
widadsaghir1993

Dear client MySQL/PHP/Database design is my main skills for your job. Please contact me and let me know your project in detail Thanks Best regards. Widad

$500 USD in 7 gün içinde
(102 Değerlendirme)
7.3
AzzkaNoor

Bonjour! It is my humble offer to present my services to you for this project. I have passed 15 certifications here (& with 5-star rating) and your project's domain resides in my area of expertise. I have few question Daha Fazla

$500 USD in 7 gün içinde
(35 Değerlendirme)
7.3
junkyfunky

Hello, I've read your project description and I want to tell you that I can create a small web application to interface with a simple MySQL database for you as per your [login to view URL] have a quick chat to discuss Daha Fazla

$280 USD in 15 gün içinde
(172 Değerlendirme)
7.2
Sunxiyong0116

How are you. I have review requirement and gathered features for your Website. I have gained 5+years of experience and expertise working on Node.js(Express), codeigniter, Laravel [login to view URL], i am good at C#(MVC Daha Fazla

$500 USD in 10 gün içinde
(34 Değerlendirme)
7.0
bestit4u

Hi, dear Welcome to you! I am very interested in you project because I have much experience in such projects. I have a good skill with the Mobile(Native , React-Native and Unity) development including C/C++, C#, ja Daha Fazla

$555 USD in 10 gün içinde
(94 Değerlendirme)
7.0
TakaAlex

Hello, sir. Much interested in your project, I've read all of your requirements extremely carefully. This is the one experienced in Website Development, I think I can deliver your job successfully. I hope you to dis Daha Fazla

$498 USD in 10 gün içinde
(18 Değerlendirme)
6.7
einnovention

Hello Sir/Madam!! I have read the description of your project. I can handle it with full confidence and have already done this type of projects. Please give me an opportunity to work on this, It will be my pleasure wor Daha Fazla

$1000 USD in 22 gün içinde
(139 Değerlendirme)
6.9
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. Here are my working result for php, mysql and ajax [login to view URL] Daha Fazla

$500 USD in 7 gün içinde
(95 Değerlendirme)
6.8
techwelfare

We are ready to create interface with MySQL database. we could do [login to view URL] are the one who could do this work. plz share every [login to view URL] want to discuss with you... plz do respond.

$530 USD in 10 gün içinde
(188 Değerlendirme)
7.2
batasoy

Hi! I read your requirements very well. The project caught my attention, because I'm working on a similar project; but for a digital signage application. Downloaded sql dump also; now its very clear. I create Daha Fazla

$500 USD in 10 gün içinde
(68 Değerlendirme)
6.3
alexwmsoft

Hi there, I am an experienced website developer, and I have 6 years experience in developing websites using HTML, CSS and PHP and several frameworks such as Wordpress, Laravel, Codigniter, django and so on. I read Daha Fazla

$555 USD in 10 gün içinde
(35 Değerlendirme)
6.2
grigorywazin

Hi, As a senior web developer, I’m very confident in php framework. I’m very interested in your job and wanna dive in to your job right now. ---Main skills--- -Backend PHP : Laravel, CodeIgnitor,Yii,Zend framework Daha Fazla

$400 USD in 10 gün içinde
(32 Değerlendirme)
6.4
harrysart

Dear, Sir.⭐ I am a PHP Expert whom you are looking for your project. I'm not new to the industry. With 5 years’ experience and training, I can deliver a professional read in multiple tones or styles.I have hands-on ex Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(138 Değerlendirme)
6.3
JinTaiZhe

Hello. I have good experience in Web development for over last 7 years and I am good at MEAN / MERN Stack, Vue.js, HTML/CSS, PHP, etc. And also I have good knowledge and experience with many Frameworks and CMS suc Daha Fazla

$500 USD in 25 gün içinde
(25 Değerlendirme)
6.1
WebnAppExperts

haiiiiiiii , i have read you post completely , Lets discuss in detail so that we never skip basic thing during project implementation Qualifications and experience include: ----------------------------------- Daha Fazla

$800 USD in 7 gün içinde
(18 Değerlendirme)
6.2
pakistansolution

Hello! I have read your proposal and understood what you want. I'm a professional in word press. Yes, I can build a professional website for word press. I'm using on word press site. I have more than 8 years experience Daha Fazla

$350 USD in 10 gün içinde
(68 Değerlendirme)
5.7
nitinsaluja98

Hi, ⭐⭐My Understanding⭐⭐ Well, I have reviewed your job description. Actually, I have recently done project (Angular, Laravel). Its Intranet for Telecom company to automate the internal processes. Please check Daha Fazla

$600 USD in 10 gün içinde
(30 Değerlendirme)
5.6