想要總結(jié)用戶的每日工作時(shí)間，并且我有時(shí)間在時(shí)間列中簽到和簽出$sql=" SELECT User_id, date, min(time) AS checkedin, max(time) AS checkedout,( (TIME_TO_SEC(TIMEDIFF(max(time), min(time))) / 60) / 60) difference FROM profile WHERE 1 GROUP BY User_id, date"; $previousdata = DB::select($sql);我從我使用過(guò)的 sql 查詢中得到這個(gè)數(shù)組，我想添加我每天得到的一個(gè)月數(shù)據(jù)的差異。不用擔(dān)心日期格式，我來(lái)自尼泊爾，正在使用尼泊爾日期。Array( [0] => stdClass Object ( [User_id] => 1 [date] => 2076-02-06 [checkedin] => 12:11:40 [checkedout] => 19:11:43 [difference] => 7.00083333 ) [1] => stdClass Object ( [User_id] => 1 [date] => 2076-02-08 [checkedin] => 12:15:40 [checkedout] => 15:15:48 [difference] => 3.00222222 ))
2 回答
幕布斯6054654
TA貢獻(xiàn)1876條經(jīng)驗(yàn) 獲得超7個(gè)贊
慕桂英546537
TA貢獻(xiàn)1848條經(jīng)驗(yàn) 獲得超10個(gè)贊
如果你想用查詢來(lái)做，然后使用 rollup
SELECT User_id, date, min(time) AS checkedin, max(time) AS checkedout,( (TIME_TO_SEC(TIMEDIFF(max(time), min(time))) / 60) / 60) difference
FROM profile WHERE 1 GROUP BY User_id, date WITH ROLLUP";
但它會(huì)在每組之后添加額外的行以顯示它們的總和，并在結(jié)果集的底部添加一行以顯示總和。
- 2 回答
- 0 關(guān)注
- 267 瀏覽
添加回答
舉報(bào)
0/150
提交
取消