show mysql data daily sum

Käynnissä Julkaistu Nov 25, 2015 Maksettu toimituksen yhteydessä
Käynnissä Maksettu toimituksen yhteydessä

i has 2 column in my database and it it mysql.

One is datetime ex) 2015-11-14 01:25:41 column name is date.

Two is decimal ex)1.04 column name is profit.

I want to show that as daily sum and recent 24hours sum.

ex) if now time is 2015-11-25 23:12:14

1) recent 24Hours

2015-11-25 23H : 340.09$ (sum during 2015-11-25 23:01:01 ~ 2015-11-25 23:12:14)

2015-11-25 22H : 178.39$

.

.

.

2015-11-24 0H : 398.39$

2)daily sum

2015-11-25(Mon) : 1500.09$

2015-11-24 (The): 1344.9$

2015-11-23 (Wed): 1500.34$

2015-11-22 (Thu): 1500.25$

.

.

.

.

.

3) Of course it should apply monthly limit day

(ex: november has 30days , dec has 31days, feb has 28days)

PHP

Projektin tunnus: #8969985

Tietoa projektista

22 ehdotusta Etäprojekti Aktiivinen Nov 25, 2015

22 freelanceria on tarjonnut keskimäärin $112 tähän työhön

AltiuseCreaton

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them. Hope they Lisää

$252 USD 3 päivässä
(86 arvostelua)
7.3
keshavkalra90

A proposal has not yet been provided

$211 USD 3 päivässä
(194 arvostelua)
7.3
ifactorsolu

Hello I would like to assist you in the job mentioned. Please feel free to contact me here so that we can discuss and move forward. If you have provide me with a sample sqldump for the database table, i can come up Lisää

$40 USD 3 päivässä
(216 arvostelua)
7.4
saagark22

Hello, I can write this summary script for you. Which will basically show you profit in multiple modes such as from last 24 hours, daily and monthly.

$250 USD 3 päivässä
(369 arvostelua)
7.3
usuf001

A proposal has not yet been provided

$123 USD 1 päivässä
(523 arvostelua)
7.2
Shattenjagger

Hi there. Yours project description looks clear for me, so let's communicate and do the business! :)

$100 USD 1 päivässä
(66 arvostelua)
6.7
Creativeartbd

Well, I understand your requirements that you need daily sum of your transaction. Well, I can do that it with raw PHP because I most of the project is developed using PHP and I have sound knowledge about. It. Thanks an Lisää

$115 USD 4 päivässä
(116 arvostelua)
6.6
santopoulose

Hi, have a good day!. From your description , I understand that , Thes pecified calculations are to be done. I am very experienced but looking to get established on freelancer.com. I can deliver this work well d Lisää

$35 USD 3 päivässä
(101 arvostelua)
5.7
mudiyanselage

Dear Sir, It’s a great pleasure me to bid on your project. I am a 7 years experienced web Developer.. I hold a master degree for Computer Science. Please see my profile, I have enough experiences and gained lot of job Lisää

$111 USD 1 päivässä
(53 arvostelua)
5.6
optimizmo

Hello, I can create reporting software for you. If interested, feel free to contact me with more details. Regards, Alexander

$122 USD 3 päivässä
(30 arvostelua)
5.3
bharathreddy11

Hi, daily/hourly/date range sum (from data fetched from database) will be acheived with clean and well documented PHP and JavaScript code and 1 day (maximum 2 days) delivery will be assured, if you are interested let u Lisää

$100 USD 1 päivässä
(60 arvostelua)
5.5
sreekanthmk91

HI.. I CAN DO THIS IN LESS THAN 1 HOUR I am an experienced web developer with an overall experience of 3 years in advanced technologies of web development . Kindly contact me if interested. Thanks and regar Lisää

$111 USD 0 päivässä
(13 arvostelua)
4.5
WestEastDevs

Hey there ! We're 2 developers with vast and wide knowledge in Web developing and PHP. We'll gladly do your project as it seems like something we can pull-off quite easily. If you'd like to see some of our previous wor Lisää

$155 USD 3 päivässä
(8 arvostelua)
3.8
NCRroger

I am a developer PHP, MYSQL, for this work I propose to write a function that takes a date range and provided the results according to your description, I would also make a test HTML page to allow you to quickly test t Lisää

$77 USD 2 päivässä
(6 arvostelua)
4.4
jainkamiya

Having strong experience as a PHP developer and web designer. I will give my best and will put heart and soul to make it successful. With my 5 yrs of experience in HTML, CSS,PHP and JavaScript I am sure this will be ge Lisää

$111 USD 3 päivässä
(4 arvostelua)
2.2
karthicsrp

hi I'm a developer. I read your project description. I can work for you. My best is working with responsive design. I don't need money until I'll finish the project.

$30 USD 2 päivässä
(0 arvostelua)
0.0
aanandchamp

Hello there, I completely understand your requirements to show daily sum and recent 24 hours sum. This is easy job for me i also suggest you (complimentary with this bid) using "bar graph" to show data, which wil Lisää

$88 USD 2 päivässä
(0 arvostelua)
0.0