Example #1
0
 $project2user = pdo_query("SELECT user2project.projectid AS projectid,role,name,\n                            (SELECT count(errorlog.projectid) FROM errorlog WHERE errorlog.projectid=user2project.projectid)\n                             AS errors\n                             FROM user2project,project\n                             WHERE project.id=user2project.projectid\n                             AND userid='{$userid}' ORDER BY project.name ASC");
 echo pdo_error();
 $condition_list_projects = '';
 $Project = new Project();
 $start = gmdate(FMT_DATETIME, strtotime(date("r")) - 3600 * 24);
 while ($project2user_array = pdo_fetch_array($project2user)) {
     $Project->Id = $project2user_array["projectid"];
     $projectid = $project2user_array["projectid"];
     $projectname = $project2user_array["name"];
     $xml .= "<project>";
     $xml .= add_XML_value("id", $projectid);
     $xml .= add_XML_value("role", $project2user_array["role"]);
     // 0 is normal user, 1 is maintainer, 2 is administrator
     $xml .= add_XML_value("name", $projectname);
     $xml .= add_XML_value("name_encoded", urlencode($projectname));
     $xml .= add_XML_value("nbuilds", $Project->GetTotalNumberOfBuilds());
     $xml .= add_XML_value("nerrorlogs", $project2user_array["errors"]);
     $xml .= add_XML_value("average_builds", round($Project->GetBuildsDailyAverage(gmdate(FMT_DATETIME, time() - 3600 * 24 * 7), gmdate(FMT_DATETIME), 2)));
     $xml .= add_XML_value("success", $Project->GetNumberOfPassingBuilds($start, gmdate(FMT_DATETIME)));
     $xml .= add_XML_value("error", $Project->GetNumberOfErrorBuilds($start, gmdate(FMT_DATETIME)));
     $xml .= add_XML_value("warning", $Project->GetNumberOfWarningBuilds($start, gmdate(FMT_DATETIME)));
     $xml .= "</project>";
 }
 // Go through the jobs
 if ($CDASH_MANAGE_CLIENTS) {
     $ClientJobSchedule = new ClientJobSchedule();
     $userJobSchedules = $ClientJobSchedule->getAll($userid, 1000);
     foreach ($userJobSchedules as $scheduleid) {
         $ClientJobSchedule = new ClientJobSchedule();
         $ClientJobSchedule->Id = $scheduleid;
         $projectid = $ClientJobSchedule->GetProjectId();