System for adding Customers Articles Suppliers and CSV import articles PHP/MYSQL

In Bearbeitung Veröffentlicht vor 4 Jahren Bezahlt bei Lieferung
In Bearbeitung Bezahlt bei Lieferung

We have a Mysql current database holding:

Articles

Article groups (categories)

Suppliers

Customers

(more tables need to be added for doing this project, you are free to create the tables you like and also add columns to current tables)

1.

--

We want simple gui for edit/list/add in ALL this four tables. All fields should be editable.

This should be in three separate files for each table

e.g.

[login to view URL] - list all articles, possibility to open for change or delete

[login to view URL] - edit / change article

[login to view URL] - do the MySQL operations, post back to [login to view URL] with success or fail

2.

--

In the customer edit gui it should be possible to add special prices for the customer on the separate articles(fixed special price or percent discount) or on article groups(percent discount). Necessary tables should be created of your choice.

- Each customer could have special prices on unlimited special prices

- When entering the articleno or articlegroupno it should be an ajax request getting that it is a correct articleno/articlegroupno and fetch the name from article/articlegroup table.

- Simple example is found here: [login to view URL] (the form you will create should be more basic in design - only plain html)

3.

--

CSV / tab delimited import of articles from supplier:

We want a system that can read csv/tab delimited text files holding article price and info.

- each supplier has a discount file holding a %-discount for each discount group. It could be in either csv or tab delimited text.

- each supplier also has a pricelist with articleno, discountgroup, and more fields.

- on import articles should be updated if existed or added if not.

- each article could have more than one supplier. The articleno is the same on all suppliers. But all suppliers do not have all articles. Cheapest purchase price and supplier should be in the table articles.

- simple gui in html/php should be created to create import filters for each suppliers telling which column in discountfile holds discountgroupno,discountpercent

in this gui you should also decide which column in csv/tab delimited pricelist should be imported to which database column. It should also be possible to use fixed fields if pricelist not hold the info.

- if pricefile not contain a certain field it should be kept as it is, no overwriting.

- the pricelist could contain up to 200.000 articles.

- the import could be started from the supplier site or from an automatic request. e.g. [login to view URL]

- a table should hold all the supplier’s prices on each article.

Example:

[login to view URL]

----------------

discountgroupno;discountpercent

AA01;10

BB02;50

CC03;20

[login to view URL]

articleno;name;unit;discountgroup;listprice

A1;Banana;KG;AA01;100

A2;Apple;KG;AA01;1000

A3;Orange;KG;BB02;200

The purchase price for Banana is 90, Apple is 900, Orange is 100.

4.

--

Ready written queries for future ajax requests.

e.g.

[login to view URL]

should output:

-All the fields from article table

-current customer price, considering article discounts

-current % discount considering article discounts or article group discounts

eg.

[login to view URL]

should output:

-All the fields from article table

-current supplier purchace price

General project guidelines:

---------------------------

- GUIs should be simple but functional, containing html forms, submits etc. Design will be added later. As little javascript/ajax as possible.

- PHP version is 5.6.24.

- No php framework should be used, only plain php.

- Mysql should be used (not MySQL).

- Current Table/column names are in Swedish, but are well commented, and straight forward.

- Current database structure should be kept, but adding new columns and tables is possible.

- New table/column names should be in English or Swedish.

- Example of files and database will be posted.

- All code should be well commented in English.

HTML JavaScript MySQL PHP Softwarearchitektur

Projekt-ID: #19675652

Über das Projekt

14 Vorschläge Remote Projekt Aktiv vor 4 Jahren

14 Freelancer bieten im Durchschnitt $515 für diesen Job

hiretechexperts

Sure, can create System for adding Customers Articles Suppliers with CSV import , but need to clear some points. So please send me a text message whenever you have some time to discuss about the project. At present I Mehr

$500 USD in 10 Tagen
(76 Bewertungen)
8.3
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Mehr

$750 USD in 7 Tagen
(140 Bewertungen)
7.3
YuKai7777

Hello. I have read your job description and am very interested in your Mysql hosting project. I have worked on many projects developing UI/UX, responsive design for web & mobile and I have expert-level experience of HT Mehr

$500 USD in 7 Tagen
(53 Bewertungen)
7.1
alexwmsoft

100% Completion Rate and 5 Stars Hi, there. My name is Lee, and I am an experienced web developer. I read your job description, and I am interested in your project. I have 6+ years of experiences in developing Mehr

$444 USD in 10 Tagen
(45 Bewertungen)
6.7
adampohp79

Hi. thanks for your posting. I'm very happy to have a chance of bidding your project. I have experience in development of the projects like yours If you hire me, I'll do my best for your project and finish greatly in a Mehr

$500 USD in 7 Tagen
(72 Bewertungen)
6.4
Topman123

Dear,manager! Thanks for visiting my proposal. I have read your job description very carefully. It becomes a question of what you are asking for. I will briefly introduce my career, convinced that I can finish it on Mehr

$555 USD in 10 Tagen
(32 Bewertungen)
5.8
shenji108

Hello I just checked your requirements in detail within 20mins it's too long:)) anyway, all pages are needed CRUD now. also, I should make a relationship between customers and articles. It is easy for me Mehr

$555 USD in 10 Tagen
(8 Bewertungen)
4.2
muzhobert

I am choosing that time because I want to be sure that what I deliver to you is quality work and for the money, it's worth the time. Trust me you won't regret your trust. Thanks a lot in advance

$666 USD in 14 Tagen
(0 Bewertungen)
0.0
fseedat7

I already have a base project set up with a great UI and templates. I am using Slim PHP framework. I will ensure that the logic classes will have full unit tests. I will work with lots of dedication. Relevant Skills a Mehr

$555 USD in 20 Tagen
(0 Bewertungen)
0.0