Käynnissä

MSSQL Data Extraction to PHP site or similar - repost 2

Hello Freelancers.

We need to build a custom feature for our existing warehousing system InFlow Inventory.

What we need done is a system/script which every day at a certain time calculates how much space our customers use in our warehouse.

How can this be done?

Every product in our warehouse is entered in our warehouse system and stored in a MSSQL 2005 database.

The product is stored with length, height and width and m3 per. product.

Customers should pay per m3 (cubicmeter) they use in our warehouse.

Every customer has their own assigned "Location" in our warehouse system, so what we need is a system/script that every day calculates the total m3 usage of every location.

System/script should "list" all items in a location of the MSSQL database, take the m3 usage of every item in the database and multiply it with the amount of the item in stock.

All stock should then be put together and the total m3 usage of this specific (customer) location should be outputted into a list for every date of the year.

It is very important that the system/script is able to automatically search and check for new locations added to the MSSQL database BEFORE the list for the day is generated.

Please see attached example for an idea of how the output should look like. Output could be a .php page or similar.

We are able to provide a test enviroment with a copy of the actualy database.

Our warehouse software is InFlow Inventory ([url removed, login to view])

Looking forward to hearing from freelancers who can do this project.

Martin Brandt

Brandt Logistics

Taidot: HTML, MySQL, PHP, SQL

Näytä lisää: sql inventory system, logistics freelancers, height length, freelancers output, freelancers customer page, example inventory database, freelancers site list, warehouse system, warehouse inventory, sql freelancers, MSSQL, m3, database extraction, data warehousing, mssql stored, similar stock, much similar, inventory mssql, sql stock inventory, page extraction, search product script php, test php page, stock inventory sql, php page search, logistics project

About the Employer:
( 0 reviews ) Riyadh, Saudi Arabia

Projektin tunnus: #4231343

10 freelanceria on tarjonnut keskimäärin 579 $ tähän työhön

gopalvora

ready to start Thanks

390 $ USD 14 päivässä
(141 arvostelua)
6.7
kilobytes

Hi, I'm available to start working on this immediately. Thanks for considering my services.

475 $ USD 7 päivässä
(245 arvostelua)
6.4
claudiu07

Hi, I'll be happy to help you out. Cheers.

400 $ USD 5 päivässä
(18 arvostelua)
5.6
cakephp2012

Hi sir i read your requirement i have done this type of work , also this is can be done by a cron JOB script (planified script) into the server and run every day at a specified hour:min.

750 $ USD 15 päivässä
(6 arvostelua)
5.6
GT1002

I am interested work on this project.

500 $ USD 5 päivässä
(2 arvostelua)
2.8
Tech2tango

please check PM

700 $ USD 20 päivässä
(3 arvostelua)
2.8
Dev01NavNet

hi, please see PMB

750 $ USD 30 päivässä
(1 arvostelu)
1.4
veltrod

Hi, Veltrod Software services is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and te Lisää

700 $ USD 22 päivässä
(2 arvostelua)
0.7
wisdesigner

Greetings, Let's start..... We are one of the India's highly skilled web technology experts. We specialize in giving an App idea a concrete shape with a Guarantee of Excellence, Quick turnaround and Cost-effectiven Lisää

625 $ USD 14 päivässä
(0 arvostelua)
0.0
itsvirus1

I have experience in data warehousing applications.I can help in your project. Please let me know if you have any queries.I will be waiting for your reply sir.

500 $ USD 7 päivässä
(0 arvostelua)
0.0
thuster

please view pmb

350 $ USD 7 päivässä
(0 arvostelua)
0.0