Mysql query stock FIFO

€8-30 EUR

In Progress

Posted

over 4 years ago

€8-30 EUR

Paid on delivery

I have this mysql table and i need a query to know available pcs of every order distinct by type. Is it possible to do? I need a mysql query Must work as fifo queue Now i need a query to know how pieces of every order are available Ask question before bid: 5+2? ES Order Type Available pcs Planned 16 Cash 10 I buy 5 pcs with order type PLANNED PLANNED+5 I buy 5 pcs with order type CASH CASH+5 I buy 5 pcs with order type CASH CASH+10 I sell 1 pcs PLANNED+4 I sell 1 pcs PLANNED+3 1 sell 2 pcs PLANNED+1 I buy 15 pcs with order type PLANNED PLANNED+16 RESULT PLANNED+16 CASH+10

MySQL

PHP

Software Architecture

Database Programming

Database Administration

Project ID: 22700645

About the project

13 proposals

Remote project

Active 4 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

13 freelancers are bidding on average €24 EUR for this job

@MohanKumar28

Hi I have gone through the requirements. Will do this script using PHP. I'm available to start now. Please contact for further discussions. Regards, Mohan

€20 EUR in 1 day

4.9

(106 reviews)

5.9

@gamasoftware5

5+2? Hi, Interested into your job and did many like it before. I have a very good experience in PHP/MySQL for 13 years. I also have very good experience in SQL specially for generating reports as I worked for many projects with ecommerce. Hope you like my price and I do it for you. Thanks, Mohamed.

€20 EUR in 1 day

4.9

(175 reviews)

6.2

@jinjinwu

I can complete this task very quickly and with good quality. i am professional web developer,please see my profile. Please Send me a message so that we can discuss more about this project Regards

€30 EUR in 1 day

5.0

(15 reviews)

5.3

@ahmedbilal2506

Hi sir I am interested to work with you. I can provide you professional web design services. I can design for you according to your requirements. I will give you unlimited revision until you will not satisfy for your design.I will deliver you this according to your time frame after your award. I can assure you several things. * I have expertise in Twitter Bootstrap, Angularjs, HTML5/CSS3, Php, java se,j2ee.... * I have a great web development sense. * Well organized and clean code easy to understand. * Validate according to w3c standards. * I can start it immediately. * Compatible with all modern browsers and mobile devices. Looking forward to hearing from you soon. Thank

€8 EUR in 1 day

5.0

(5 reviews)

3.5

@sreenivas2903

Hi i am expertise in sql queries and also etl processing ping me if u are interested we will finish.

€55 EUR in 1 day

4.7

(9 reviews)

3.8

@Aqib78633

i can and i will.

€23 EUR in 10 days

0.0

(0 reviews)

0.0

@zuev85

Hello, Did you already built structure of the database? Of course, it is possible fully, but I have to know the structure of the table,

€20 EUR in 1 day

0.0

(0 reviews)

0.0

@Minecraftjay

Please give me Relevant Skills and Experience Nothing

€23 EUR in 1 day

0.0

(0 reviews)

0.0

@p8orion

Bid answer: 7 I work daily with complex SQL databases, and this is easy. To be honest, I'm just looking for a good score, so I'll do it for half the average bid.

€12 EUR in 1 day