Concluído

Mysql query stock FIFO

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

Habilidades: MySQL, PHP, Arquitetura de software, Programação de Banco de Dados, Administração de Bancos de Dados

Veja mais: mysql query stock reports, magento show 1 2 3 4 5 project type fixed hourly, android 2.3.4, bsbmkg607 manage market research assessment 2 3 4, Upgrade oscommerce 2 3 1 to 2 3 4 Jobs, oscommerce 2.3 4.1 template, brandons core 2.3 4, oscommerce 2.3 4.1 responsive, oscommerce 2.3 4.1 release date, 1,1,1,2,2,2,3,4,3,3,5,6,?, 0,1,0,2,2,2,3,4,5,6,6, 2/3,4/7,?,11/21,16/31, jacksepticeye fnaf 1 2 3 4 animated, grails 2.3 4 documentation, 1 2 3 4 5 6 7 8 9 10 what's the mistake, find the mistake 1 2 3 4 5 answer, 2+3+4=11 3+4+5=15, mysql query interview questions and answers for 2 year experience, consider the following time series data: month 1 2 3 4 5 6 7 value 24 13 21 14 20 23 15, consider the following time series data: month 1 2 3 4 5 6 7 value 24 15 21 13 19 21 16

Acerca do Empregador:
( 1 comentário ) Napoli, Italy

ID do Projeto: #22700645

Concedido a:

adricabrelles

Hi I am a Senior DBA with more than 15 years experience in sql. I can help you. Regards

€21 EUR em 1 dia
(9 Comentários)
3.6

14 freelancers estão ofertando em média €24 para esse trabalho

programac

Greetings marcotroise1979! Thanks for sharing the project "Mysql query stock FIFO". I'm very much focused in your project and certainly want to take a part. Kindly contact me to let me collect further details about yo Mais

€20 EUR em 1 dia
(146 Comentários)
6.3
elbruninh

Hi, i'm interested, could you give me more details please? can you send me the database structure? i can do it [login to view URL]

€30 EUR em 1 dia
(94 Comentários)
6.4
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 pro Mais

€20 EUR em 1 dia
(175 Comentários)
6.2
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 em 1 dia
(103 Comentários)
5.9
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 em 1 dia
(14 Comentários)
5.3
Srinfoteam

Hello there, I will Complete your request as per your requirements. We’ve built websites and mobile apps for several brands around the world with great success, and we are quite excited to get to work on yours. http Mais

€19 EUR in 7 dias
(10 Comentários)
3.9
sunnykasera

Dear Client, Greetings from Sunny! I am interested to work with you and I am absolutely sure that I can do your project very well in the shortest possible time. A responsible and dependable full stack developer for o Mais

€30 EUR em 1 dia
(5 Comentários)
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 em 1 dia
(9 Comentários)
3.8
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 d Mais

€8 EUR em 1 dia
(1 Comentário)
0.7
Aqib78633

i can and i will.

€23 EUR in 10 dias
(0 Comentários)
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 em 1 dia
(0 Comentários)
0.0
Minecraftjay

Please give me Relevant Skills and Experience Nothing

€23 EUR em 1 dia
(0 Comentários)
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 em 1 dia
(0 Comentários)
0.0