$sql = "SELECT DATE_FORMAT(b.at_create,'%Y-%m-%d %H:%00:%00') as p_date, count(1) as p_count FROM event_posts AS a, $table_joined_users as b WHERE a.event_post_id = b.event_post_id AND a.account = '".escapeString(SESSION_AC)."' AND a.event_post_id = ".$event_post[$primary_id]." AND DATE_FORMAT(b.at_create,'%Y-%m-%d %H:%00:%00') >= '$yesterday_hour_24' GROUP BY HOUR(b.at_create), DATE_FORMAT(b.at_create,'%Y-%m-%d %H:%00:%00') ORDER BY DATE_FORMAT(b.at_create,'%Y-%m-%d %H:%00:%00') ASC, HOUR(b.at_create) ASC;"; $rows = Model_Dbuse_Base::queryArrays($sql); if (empty($rows)){ echo "目前無數據"; }else{ //$day_2 = Model_Function01::Get_Now_Time_Reduce_Some_Day(2); $diff_24hours = Model_Function01::Get_Hours_EveryDay_By_Hour(TODAY_TIME, YESTERDAY_TIME); $rops = []; if (!empty($rows)){ $z = 0; $this_year = Model_Function01::Get_This_Year(); $yester_year = Model_Function01::Get_Yesterday_Year(); foreach ($diff_24hours as $diff_24hour){ $is_find = false; foreach ($rows as $row){ if ($row['p_date'] == $diff_24hour){ $is_find = true; $e_date = str_replace([$this_year."-",$yester_year."-",":00:00"], "", $diff_24hour); $rops[$z]['p_date'] = $e_date; $rops[$z]['p_count'] = $row['p_count']; $z++; break; } } if ($is_find == false){ $e_date = str_replace([$this_year."-",$yester_year."-",":00:00"], "", $diff_24hour); $rops[$z]['p_date'] = $e_date; $rops[$z]['p_count'] = 0; } $z++; } } $json_bar = "[['Element', 'Density', { role: 'style'}],"; foreach ($rops as $rop){ $json_bar .= "['". $rop['p_date']."',".$rop['p_count'].",'green'],"; } $json_bar = Model_Function02::left($json_bar, strlen($json_bar)-1); $json_bar .= "]"; Model_Chart::echo_javascript_bar("event_24hour_bar", $json_bar, "最近24小時參加活動人數", $width); }
想對外分享這則貼文嗎?運用網址更方便呦~