Lengkap

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];

Kemahiran: MySQL, PHP

Lihat lagi: 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

Tentang Majikan:
( 29 ulasan ) louisville, United States

ID Projek: #6529540

Dianugerahkan kepada:

ayandasguptalx

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

$30 USD dalam sehari
(10 Ulasan)
3.7

13 pekerja bebas membida secara purata $33 untuk pekerjaan ini

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 Lagi

$79 USD dalam sehari
(827 Ulasan)
8.3
KatrinaQ

A proposal has not yet been provided

$30 USD dalam sehari
(789 Ulasan)
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 [login to view URL] [login to view URL] http:/ Lagi

$34 USD dalam sehari
(326 Ulasan)
6.7
NayaPakistan

A proposal has not yet been provided

$25 USD dalam sehari
(207 Ulasan)
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 Lagi

$30 USD dalam sehari
(142 Ulasan)
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 Lagi

$22 USD dalam 2 hari
(96 Ulasan)
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 Lagi

$30 USD dalam 0 hari
(44 Ulasan)
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

$30 USD dalam 0 hari
(14 Ulasan)
5.0
jvsundarrajan

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

$30 USD dalam sehari
(49 Ulasan)
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 Lagi

$25 USD dalam sehari
(15 Ulasan)
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 : [login to view URL]~0 Lagi

$30 USD dalam sehari
(6 Ulasan)
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. Lagi

$30 USD dalam sehari
(2 Ulasan)
2.4