Mysql query stock FIFO

€8-30 EUR

进行中

已发布

超过 4 年前

€8-30 EUR

货到付款

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

项目 ID: 22700645

关于此项目

13提案

远程项目

活跃4 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

13威客以平均价€24 EUR来参与此工作竞价

@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 在1天之内

4.9

(106条评论)

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 在1天之内

4.9

(175条评论)

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 在1天之内

5.0

(15条评论)

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 在1天之内

5.0

(5条评论)

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 在1天之内

4.7

(9条评论)

3.8

@Aqib78633

i can and i will.

€23 EUR 在10天之内

0.0

(0条评论)

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 在1天之内

0.0

(0条评论)

0.0

@Minecraftjay

Please give me Relevant Skills and Experience Nothing

€23 EUR 在1天之内

0.0

(0条评论)

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 在1天之内