Devam Ediyor

mysql query with output to cvs -- 2

I have two queries I am looking to combine. I will like the the output to match the attached spreadsheet. I have also attached tables.

SELECT [url removed, login to view] AS Employee,

SEC_TO_TIME(SUM(TIME_TO_SEC(CONCAT(teight,':',teightb)) - TIME_TO_SEC(CONCAT(tseven,':',tsevenb)))) AS TotalHours

FROM schedule WHERE [url removed, login to view] BETWEEN '2014-08-29' AND '2014-08-29' GROUP BY custno

SELECT regular, employee FROM timesheet WHERE [url removed, login to view] between '2014-08-29' AND '2014-08-29' GROUP BY employee

Update: I have one query but I have this trouble:

One problem if you run this query you will see total hours says 10 for all but 1 of the result should be 12. SELECT [url removed, login to view],[url removed, login to view],MIN([url removed, login to view]),MAX([url removed, login to view]),SEC_TO_TIME(SUM([url removed, login to view])) AS total_hours,[url removed, login to view],TIMEDIFF(SEC_TO_TIME(SUM([url removed, login to view])),[url removed, login to view]) AS bil FROM(

SELECT [url removed, login to view], [url removed, login to view],[url removed, login to view],[url removed, login to view],t.`regular`,TIME_TO_SEC(TIMEDIFF([url removed, login to view],[url removed, login to view])) AS total

FROM schedule AS s LEFT JOIN timesheet AS t ON ([url removed, login to view] = [url removed, login to view] AND s.date=[url removed, login to view]) )a

WHERE a.date='2014-08-29'

GROUP BY [url removed, login to view],[url removed, login to view];

Beceriler: MySQL, PHP

Daha fazlasını görün: mysql query, employee timesheet, bil, php mysql schedule, mysql cvs, spreadsheet timesheet, employee mysql, mysql spreadsheet, query spreadsheet, mysql combine, php cvs, cvs mysql, output tables php, php schedule output, mysql query php, query combine, php join tables, mysql update select query, php mysql employee, php schedule mysql, mysql output, mysql php spreadsheet, php spreadsheet mysql, mysql employee, timesheet mysql php

İşveren Hakkında:
( 29 değerlendirme ) louisville, United States

Proje NO: #6529540

Seçilen:

ayandasguptalx

As discussed I am placing the bid in this project. Kindly accept so that I can start working in it. Thanks, Ayan Dasgupta.

1 gün içinde 30$ USD
(10 Değerlendirme)
3.7

13 freelancer bu iş için ortalamada 33$ teklif veriyor

rajeshsonisl

Hello, With 99% completion rate, 700 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 !!)... you can never go wron Daha fazlası

1 gün içinde 79$ USD
(827 Değerlendirme)
8.3
KatrinaQ

A proposal has not yet been provided

1 gün içinde 30$ USD
(789 Değerlendirme)
7.9
sat12

Hi, I will modify the query as per requirement. I am joomla, virtuemart expert having 5 years of experience... recently i completed these projects [url removed, login to view] [url removed, login to view] http:/ Daha fazlası

1 gün içinde 34$ USD
(326 Değerlendirme)
6.7
NayaPakistan

A proposal has not yet been provided

1 gün içinde 25$ USD
(207 Değerlendirme)
6.3
anmoltech

Greetings!! Let me take this opportunity to introduce myself, I am Abhi here. I have good track record of designing comprehensive solutions ranging from Social Networking, E-Commerce, Real Estate, Healthcare, Travel Daha fazlası

1 gün içinde 30$ USD
(142 Değerlendirme)
6.0
cijagani

I am specialize in C++,C#.net,ASP.Net,JAVA, PHP, MySQL, Wordpress, e-commerce websites and portals, payment gateways and customized web based applications. my aim to deliver quality products to our customers within spe Daha fazlası

in 2 gün içinde22$ USD
(96 Değerlendirme)
6.1
umarbsse

Hi As a Software Engineer and programmer i can do this task within 24hours.I have 3years programming experience and developed many application like Employee Management System, Wordpress autopost software, Library Mana Daha fazlası

in 0 gün içinde30$ USD
(44 Değerlendirme)
5.2
ayandgpt

Hi, Thanks for inviting me to bid. I can do it in 1 day of time. Please let me know if you want me to start right now. Thanks, Ayan Dasgupta

in 0 gün içinde30$ USD
(14 Değerlendirme)
5.0
jvsundarrajan

Hi There, Can be done now. Please share this project and will give you the perfect work. Thanks for this.

1 gün içinde 30$ USD
(49 Değerlendirme)
4.6
nitinbohra89

Having 3+ years of experience in Oracle and MYSQL Database. Have vast knowledge of Database architecture, Performance tuning, Query Optimization. Currently working in Oracle India pvt ltd. I have created the query Daha fazlası

1 gün içinde 25$ USD
(15 Değerlendirme)
4.3
maulik22

Hi, I have 4 year experience in web development using php and mysql. I have worked with query like this and able to fix this. You can also check reviews on other freelancer sites : [url removed, login to view]~0 Daha fazlası

1 gün içinde 30$ USD
(6 Değerlendirme)
3.6
nirmalsharma13

Hi, I have checked excel sheet and tables attached. I can create required sql. Besides this I will create a php script which uses that script and then automatically generate excel sheet filled with data you want. Daha fazlası

1 gün içinde 30$ USD
(2 Değerlendirme)
2.4