PHP script to summarize my transport costs in my orders table

Attached is a copy of the table structure for orders.

Each order has an Invoice_To and Ship_To.

The table also records a bunch of transport/brokerage charges - you can see them inside the red box.

I need someone to write a PHP script that will summarize the transport costs PER Selected Invoice_To OR Ship_To.

I will feed the Invoice_To OR Ship_To via URL and then I want the PHP script to do the math and show me which Transport_Company is charging me what on average for an order going to that customer.

I also need to know what the average % difference is between the Transport_Cost_Billed_To_Us and Transport_Cost_Quotation_Amount.

I need these statistics.

Habilidades: HTML, MySQL, PHP, Arquitetura de software

Veja mais: table customer, customer table, summarize, math need statistics, script php math table, math table, math script, html via php, math statistics, synchronize table mssql mssql script php, product php company script, php script url, php order records, customer orders php, need someone write php script, script php company print, php mysql table insert delete script, html php order table, html php script, write feed php, php company script, php company needed, free text parser script mit php, import pdf script using php, news aggregator script techmeme php

Acerca do Empregador:
( 6 comentários ) Brampton, Canada

ID do Projeto: #6800743

20 freelancers estão ofertando em média $147 para esse trabalho


Hi Good Day I am pretty good with both PHP and Maths. I can do this project for you. Looking forward to hear from you. Thanks Rinsad

$115 CAD in 3 dias
(450 Comentários)

Hello! With 99% completion rate, 740 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u Mais

$210 CAD em 1 dia
(548 Comentários)

Hi, I'm an expert about PHP. I have read your project and confident that can handle this. Please give me more detail about the project then I can make a demo for you. Please feel free to discuss with me. Best re Mais

$122 CAD in 2 dias
(35 Comentários)

Hello, I'll be able to create a PHP script that will calculate the transport costs PER selected "Invoice_To" OR "Ship_To" and do those calculations you've mentioned on the project details. Thanks and God bless! Mais

$150 CAD em 1 dia
(34 Comentários)

10 years+ Experience in ---Programming----Full ERP---Developing Games----Android App---IPhone App---Mac App-- Inventory & Account Software---Online Store---Website Development(Ruby on Rails, Durpal, HTML, mysql,java, j Mais

$252 CAD in 3 dias
(3 Comentários)

Hello Hiring Manager! From your requirements what i get is that you want to create a report so that you can analyze that which company is less cost affective for you. i have vary good database skills. i am sending yo Mais

$122 CAD in 3 dias
(33 Comentários)

Hi, I'd like to do this job for you. I've got 15+ years of experience in IT development, of which 10+years in web development using PHP/HTML/Javascript/AJAX/mySQL technologies. I worked in a bank for 10 years Mais

$147 CAD in 3 dias
(4 Comentários)

A proposal has not yet been provided

$147 CAD in 3 dias
(25 Comentários)

Hi, Please check 1. [login to view URL]    (Event management software) Events, Volunteer, Performer, Budget, Ledger, exp all can be managed. 2. [login to view URL] Event manager can post even Mais

$474 CAD in 20 dias
(3 Comentários)

Sir, I went through the database table you have put in the image, and with having very good knowledge of DML and Queries, I am finding me self the best candidate for doing this job. I am pretty interested in doin Mais

$200 CAD in 7 dias
(26 Comentários)

Hello, I have understood the work, you need the mathematical calculations done witj your available data, this will require to fire mysql queries. I didn't understood this part - "I will feed the Invoice_To OR Ship_To v Mais

$100 CAD in 3 dias
(22 Comentários)

Hello, Thank you for invited me! I already read the detail and i am very interesting this project! Hope to work with you! Best regards, Leo

$111 CAD in 3 dias
(9 Comentários)

Do you tend to hire the cheapest developer? Consider that your business can loose money and time if work is not done correctly. These risks are lying on the surface: - You’re giving the least experienced person acc Mais

$190 CAD in 3 dias
(2 Comentários)

Dear Sir, I have more than 2 years experiences in web development like php5,mysql,wordpress,jquery,javascript,script install and I hope I am able to help you. I read all your description and know exactly what is Mais

$88 CAD em 1 dia
(14 Comentários)

hello my friend, I am ready to start right now, but offcours I need you to explain more things about what you want on chat. I give you this low price because I am looking to create a good profile , I don't think Mais

$55 CAD in 2 dias
(7 Comentários)

Soft For Solution ([login to view URL]) is an innovative IT solution company based in Bangladesh. We provide quality and professional [login to view URL] you are interested in working with a company that will help your busin Mais

$210 CAD in 3 dias
(4 Comentários)

Hello. I have just finished two iterations of a project which included calculations. I have also created entire business solution for the company I work in (invoicing, reporting, statistics,...), so I am fully qual Mais

$160 CAD in 5 dias
(2 Comentários)

Greetings! I am an expert at creating PHP scripts and writing queries to mysql and similar databases. Also, I work at reasonable rates. I have a vision in mind on how to achieve your task. please discuss

$40 CAD in 2 dias
(4 Comentários)

Following are some of the sites which has been created by me. 1. [login to view URL] : in this site tutor can submit their profile and can edit this one. Students can make requests for a tutor and the admin of site is th Mais

$40 CAD em 1 dia
(0 Comentários)

Dear Buyer, this shouldn't be a big deal and could be done in a couple of hours. If i get you right, you have an exsisting database with values from diffrent transport companies which you want to compare with each o Mais

$150 CAD in 3 dias
(0 Comentários)