Encerrado

Web based project / quote database

The task is to create a web based CRM system, using MySQL database and PHP. Suggested MVC framework are Codeignitor, CakePHP.

There are five main database tables (Company, Contact, Project, and Quote, handled by two tables), and 5 corresponding pages (Company, contact, project, view quote/invoice, and edit / new quote/invoice page). Please see attached excel file showing the 5 pages, and the four main database tables, and some other small tables (mainly used to provide drop down combo list source list.).

Pages: (page layout see attachement)

1. Project page

2. Company page

3. Contact page

4. Quote / invoice View page

5. New / Edit Quote / invoice page

Main database tables:

1. Project (list of project that has multiple companies and contact involved)

2. Company

3. Contact (list of contact person in a company)

4. Quote (list of quote for project. Only contain general quote information, detailed product info is stored in the quotelines table.

5. Quotelines (List of number of different product for each quote)

Small tables:

1. Colors

2. Type (company type)

3. Diameter (diameter of the product)

4. Model (model of the product)

5. Pricelist (price list for different product)

6. Region

7. Shape (shape of the product)

8. Source (project lead source)

9. Stage (Project stage)

10. Suspension (product accessory type)

11. Userright (User access control table)

12. Users (User information)

Layout:

1. First 3 pages have search section at top. Multiple search criteria allowed. Partial match allowed. Click on each search criteria title result in sort based on that field.

2. Below the search section is the result display section.

3. When “Add new” button pressed, The first line item become empty, used to add new record. (another option is to leave the first line always empty for new record, if this is too time consuming to implement.) All existing records needs to be able to accept inline editing. However, all data are not stored to database table until “Save” button is pressed.

4. Page 4 and 5 are almost identical, (page 4 for view only, 5 for edit / new), other than page 5 has extra control and data entry field. Both page has all fields populated from record or user input, and can be modified. But only page 5 has the capacity to save to database table, and calculate results.

Users

1. User account has user name and password protection. One user can only access record created by himself or by his employees (listed in table “UserRight”, that he has right to, in the example, user ID 2 “ABL” has right to User ID 1 and 5, so ABL can access all information belongs to all three users).

2. When a user searches anything (company, contact, project, quote, etc.) only record that has his own user ID, or the record with user ID that he has user right to access, will show up in result. (This includes the initial full list, too).

There are some other detail that's listed in the attachement word document.

The excel file has all 5 page layout and the last work sheet contains all the database tables (some with sample data, too)

The SQL file is an export of the actual database from mySql. that you can use and modify.

Thanks.

Habilidades: MySQL, PHP

Ver mais: web based database quote, mysql project quote, database invoice quote php sql, price match, web searches database, web framework top 10, top data entry companies, top 10 data entry company, sql create table price, sample system using php, quote lead, quote a lead, project quote sample, php 7 mvc, page layout companies, excel based companies, example for project, data stage 8.1, data entry invoice sample, database one word or two, create mysql database using php, create id use all web, contact to create a web, create own web page, task number 1 project

Acerca do Empregador:
( 1 comentário ) Vancouver, Canada

ID do Projeto: #5126963

48 freelancers estão ofertando em média $611 para este trabalho

intelligencei

Hi! Thanks for posting this requirement. We are TOP RATED professionals at [url removed, login to view] working since 2004. We are experts with design and development works. You may refer to our reviews and ranking here: http Mais

$1855 USD in 45 dias
(86 Comentários)
8.1
buraqtech

1. Saleaday Site We recently compeleted an amazon aws apis based online ecommerce site in which we are fetching the products live from amazon by using its apis and displaying on site with custom shopping cart function Mais

$706 USD in 18 dias
(87 Comentários)
7.9
athenaesolutions

Greetings, Thanks a lot for giving us the opportunity to bid. Athena eSolutions is a software company located in Calcutta, India and has a presence in Albuquerque, New Mexico, US with 10 years of experience in prov Mais

$515 USD in 14 dias
(66 Comentários)
7.4
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. Mais

$3092 USD in 15 dias
(487 Comentários)
7.4
BLET

Dear Sir, Thanks for creating opportunity here in Freelancer. We have worked in many Complex CRM's so far and would like to share with you. We can develop the CRM in more perfectly than others as per per our expe Mais

$252 USD in 30 dias
(139 Comentários)
7.4
neoconcepts

we are expert custom CRM/CMS developer. i have ready carefully your project specification and i am very confident to develop this. let's start

$500 USD in 12 dias
(123 Comentários)
7.3
seekdeveloper

Hi, I have read your post and understood your requirement. I have good experience in handling Wordpress /Magento/Joomla/Drupal/ HTML5/CSS3/PHP/ Yii framework/Javascript/MySQL/ Kindly go through my works to c Mais

$773 USD in 8 dias
(46 Comentários)
7.1
dagdya99

Hi, I'm interested to work on your project. Please let me know if you require any detailed information. Waiting for your reply Thanks Dev

$515 USD in 7 dias
(189 Comentários)
7.0
iweb77

Hello, Web Dreamworks (India) Pvt. Ltd. is a complete Internet Solutions providing company. I am in this field from last 15 years. I have reviewed your project description and I assures you that I will complete this Mais

$1421 USD in 40 dias
(102 Comentários)
6.9
eperfections

10+ years experience. 500+ projects completed successfully. I am very interested in this project. Ready to start ASAP.

$526 USD in 15 dias
(192 Comentários)
6.9
TheInnoVibes

Hello sir , We are a hard-working web-development company working on core PHP And Wordpress projects . We can develop cross-browser, W3C compliant good quality professional websites. We have gone through your req Mais

$257 USD in 3 dias
(101 Comentários)
6.9
canlan318

Hi, durkeesox I am a full-time freelancer who has rich experience in Web programming. I understood your project requirements basically. I believe i can complete your project successfully. I hope to keep long-te Mais

$226 USD in 5 dias
(70 Comentários)
6.8
ganeshbaid

Hello We are expert in web solution and our review speaks about our work, kindly have a look at our portfolio on [url removed, login to view] or read what our client says about us at [url removed, login to view] Mais

$1000 USD in 20 dias
(137 Comentários)
6.8
mascotindia123

Hey Friend, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Jquery / Wordpress/ Joomla / OSC / OpenCart. Ready to start the work immediately. I Mais

$315 USD in 5 dias
(86 Comentários)
6.6
pixlbrick

Hello Sir. I have more than 11 years of experience in Core PHP, Joomla , Wordpress , SQL, Ajax, Javascript ,Jquery etc.. [url removed, login to view] [url removed, login to view] http://pi Mais

$640 USD in 14 dias
(44 Comentários)
6.5
otssols

Hi, Thanks for your post. We will be interested to help you with your requirement. We are quite good and effective with designing and developing websites and have considerable experience . We would like to h Mais

$210 USD in 3 dias
(12 Comentários)
6.5
leomedina01

Hi sir, My name is Leonardo Medina, and I´m from Brazil. Please drop me a line, so we can discuss this project in details and I can make a proper bid. I'm an experienced Web Developer / Software Developer work Mais

$225 USD in 15 dias
(85 Comentários)
6.3
shihan033010

Hi I have checked your project requirement. I will complete your project using code igniter. I have developed lot of application in code igniter for my different client. I can ensure you to give you all of the functio Mais

$333 USD in 12 dias
(235 Comentários)
6.3
AndrewSmith22

Hello Sir Greetings from VAPTechDesigns. We've looked into your job post and interested to work in your project. We'll design and develop your website on CustomPHP & MySQL in combination with Ajax and jQuery. We’ll Mais

$1907 USD in 40 dias
(36 Comentários)
6.3
abhius

Hello Sir :) Serious Bidder. Honest and Professionals here having expertise in MySQL jobs. Have read and understood your requirement. Assure you to deliver fully functional and bug free system with proper validatio Mais

$210 USD in 15 dias
(95 Comentários)
6.3