PHP Project::getDayActivityByProject Examples

Example #1

File: activity.php Project: canneverbe/flyspray

  | ~~~~~~~~~~~~~                                          |
  \********************************************************/
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'));
        }

Example #2

File: activity.php Project: manishkhanchandani/mkgxy

    $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;
    }