我很可能是時(shí)間求和函數(shù)的返回值作為時(shí)間。function GetApprovedOt($connect,$emp_id,$passmonth) { $query01 ="SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `ot_hour` ) ) ) AS timeSum FROM otresquest WHERE em_id = $emp_id AND from_month LIKE '$passmonth%' AND overtime_status=6"; $statement = $connect->prepare($query01); if($statement->execute()) { $result = $statement->fetchAll(); foreach($result as $row){ $sum =$row["timeSum"]; return $sum; } } } 我的可能是上面的函數(shù)返回超過(guò) 24 小時(shí)的時(shí)間。120:20:00但我很可能無(wú)法在條件正確的情況下比較這個(gè)值。所以我需要格式返回值作為時(shí)間變量。我該怎么做？筆記 function formatHours($time){ $date = explode(':', $time); return ($date[0]*60*60)+($date[1]*60)+$date[2]; } 上面的函數(shù)變量轉(zhuǎn)換為時(shí)間。在我的情況下，我不能直接應(yīng)用， formatHours(GetApprovedOt($connect,$row["emp_id"],$_GET["month"]))因?yàn)樗鼤?huì)得到通知和警告Warning: A non-numeric value encountered in C:\xampp\htdocs\attendance\admin\report05.php on line 321Notice: Undefined offset: 1 in C:\xampp\htdocs\attendance\admin\report05.php on line 321Notice: Undefined offset: 2 in C:\xampp\htdocs\attendance\admin\report05.php on line 321我如何處理這個(gè)案子？ 更新 GetApprovedOt 函數(shù) var_dump 返回為
1 回答
米琪卡哇伊
TA貢獻(xiàn)1998條經(jīng)驗(yàn) 獲得超6個(gè)贊
我認(rèn)為問(wèn)題是GetApprovedOt函數(shù)總是不返回時(shí)間值。你應(yīng)該改變你的函數(shù)如下
function GetApprovedOt($connect,$emp_id,$passmonth)
{
$query01 ="SELECT SEC_TO_TIME( SUM( TIME_TO_SEC( `ot_hour` ) ) ) AS timeSum
FROM otresquest
WHERE em_id = $emp_id AND from_month LIKE '$passmonth%' AND overtime_status=6";
$statement = $connect->prepare($query01);
if($statement->execute())
{
$result = $statement->fetchAll();
foreach($result as $row){
if ($row["timeSum"] != NULL) {
$sum =$row["timeSum"];
return $sum;
} else {
return '00:00:00';
}
}
}
}
現(xiàn)在你可以通過(guò)formatHours(GetApprovedOt($connect,$row["emp_id"],$_GET["month"]))
- 1 回答
- 0 關(guān)注
- 94 瀏覽
添加回答
舉報(bào)
0/150
提交
取消