| ~~~~~~~~~~~~~ | \********************************************************/ if (!defined('IN_FS')) { die('Do not access this file directly.'); } //PROJECT GRAPH if (Get::has('project_id') && Get::val('graph', 'project') == 'project') { $today = date('Y-m-d'); $thirtyone_days = date('U', strtotime("-31 day", strtotime($today))); $sixtyone_days = date('U', strtotime("-61 day", strtotime($today))); //look 30 + days and if found scale $projectCheck = Project::getActivityProjectCount($sixtyone_days, $thirtyone_days, Get::num('project_id')); if ($projectCheck > 0) { $data = Project::getDayActivityByProject($sixtyone_days, date('U', strtotime(date('Y-m-d'))), Get::num('project_id')); } else { $data = Project::getDayActivityByProject($thirtyone_days, date('U', strtotime(date('Y-m-d'))), Get::num('project_id')); } $data = implode(',', $data); //User Graph } else { if (Get::has('user_id') && Get::has('project_id') && Get::val('graph') == 'user') { $today = date('Y-m-d'); $thirtyone_days = date('U', strtotime("-31 day", strtotime($today))); $sixtyone_days = date('U', strtotime("-61 day", strtotime($today))); //look 30 + days and if found scale $projectCheck = Project::getActivityProjectCount($sixtyone_days, $thirtyone_days, Get::num('project_id')); if ($projectCheck > 0) { $data = User::getDayActivityByUser($sixtyone_days, date('U', strtotime(date('Y-m-d'))), Get::num('project_id'), Get::num('user_id')); } else { $data = User::getDayActivityByUser($thirtyone_days, date('U', strtotime(date('Y-m-d'))), Get::num('project_id'), Get::num('user_id')); }
$daythirtyone = ''; for ($i = 1; $i < 31; $i++) { $newday = date('m/j/Y', strtotime("-{$i} day", strtotime($today))); $val = Project::getDayActivityByProject($newday, Get::num('project_id')); $sparkline->SetData($i, $val[0]); $daythirtyone = $newday; } $daythirtyone = date('m/j/Y', strtotime("-2 day", strtotime($daythirtyone))); $daysixtyone = date('m/j/Y', strtotime("-32 day", strtotime($daythirtyone))); //look 30 days more and if found scale $projectCheck = Project::getActivityProjectCount($daysixtyone, $daythirtyone, Get::num('project_id')); $userCheck = User::getActivityUserCount($daysixtyone, $daythirtyone, Get::num('project_id'), Get::num('user_id')); if ($projectCheck[0] > 0 || $userCheck[0] > 0) { for ($i = 30; $i < 61; $i++) { $newday = date('m/j/Y', strtotime("-{$i} day", strtotime($daythirtyone))); $val = Project::getDayActivityByProject($newday, Get::num('project_id')); $sparkline->SetBarWidth(2); $sparkline->SetBarSpacing(0.5); $sparkline->SetData($i, $val[0]); } } } elseif (Get::has('user_id') && Get::has('project_id') && Get::val('graph') == 'user') { $thirtyDays = array(); $today = date('m/j/Y'); $daythirtyone = ''; for ($i = 1; $i < 31; $i++) { $newday = date('m/j/Y', strtotime("-{$i} day", strtotime($today))); $val = User::getDayActivityByUser($newday, Get::num('project_id'), Get::num('user_id')); $sparkline->SetData($i, $val[0]); $daythirtyone = $newday; }