| <?php |
| /******************************************************************************* |
| * Copyright (c) 2007 Eclipse Foundation and others. |
| * All rights reserved. This program and the accompanying materials |
| * are made available under the terms of the Eclipse Public License v1.0 |
| * which accompanies this distribution, and is available at |
| * http://www.eclipse.org/legal/epl-v10.html |
| * |
| * Contributors: |
| * Paul Colton (Aptana)- initial API and implementation |
| |
| *******************************************************************************/ |
| require_once("cb_global.php"); |
| |
| |
| |
| $return = ""; |
| $language = ""; |
| if(isset($_SESSION['language']) && isset($_SESSION['project'])) { |
| $language = $_SESSION['language']; |
| $query = "select DISTINCT |
| f.version, |
| f.project_id, |
| IF(ISNULL(pct_complete),0,ROUND(pct_complete,1)) AS pct_complete |
| from |
| project_versions AS v |
| INNER JOIN files as f on (f.project_id = v.project_id AND f.version = v.version) |
| LEFT JOIN project_progress AS p ON (p.project_id = v.project_id AND p.version = v.version and p.language_id = " . addslashes($language) . ") |
| where |
| v.is_active = 1 |
| and f.version != 'unspecified' |
| and v.project_id = '".addslashes($_SESSION['project'])."' |
| order by |
| f.version desc"; |
| |
| $res = mysqli_query($dbh, $query); |
| |
| $return = array(); |
| |
| while($line = mysqli_fetch_array($res, MYSQLI_ASSOC)){ |
| $ret = Array(); |
| $ret['version'] = $line['version']; |
| $ret['pct'] = $line['pct_complete']; |
| |
| if(isset($_SESSION['version']) and $line['version'] == $_SESSION['version']){ |
| $ret['current'] = true; |
| } |
| $return[] = $ret; |
| } |
| } |
| //print $query."\n"; |
| print json_encode($return); |
| |
| ?> |