gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 1 | <?php |
| 2 | /******************************************************************************* |
| 3 | * Copyright (c) 2007 Eclipse Foundation and others. |
| 4 | * All rights reserved. This program and the accompanying materials |
| 5 | * are made available under the terms of the Eclipse Public License v1.0 |
| 6 | * which accompanies this distribution, and is available at |
| 7 | * http://www.eclipse.org/legal/epl-v10.html |
| 8 | * |
| 9 | * Contributors: |
| 10 | * Paul Colton (Aptana)- initial API and implementation |
| 11 | |
| 12 | *******************************************************************************/ |
| 13 | require_once("cb_global.php"); |
| 14 | |
| 15 | |
gobrien | da3a450 | 2008-01-28 23:43:26 +0000 | [diff] [blame] | 16 | |
| 17 | if(!isset($_SESSION['project'])){ |
| 18 | return array(); |
| 19 | } |
| 20 | |
droy | d664f91 | 2008-05-14 15:45:10 +0000 | [diff] [blame^] | 21 | $query = "select DISTINCT |
| 22 | f.version, |
| 23 | f.project_id, |
| 24 | IF(ISNULL(pct_complete),0,ROUND(pct_complete,1)) AS pct_complete |
| 25 | from |
| 26 | project_versions AS v |
| 27 | INNER JOIN files as f on (f.project_id = v.project_id AND f.version = v.version) |
| 28 | LEFT JOIN project_progress AS p ON (p.project_id = v.project_id AND p.version = v.version) |
| 29 | where |
| 30 | v.is_active = 1 |
| 31 | and v.project_id = '".addslashes($_SESSION['project'])."'"; |
gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 32 | |
| 33 | //print $query."\n"; |
| 34 | |
| 35 | $res = mysql_query($query,$dbh); |
| 36 | |
gobrien | 4b7797e | 2008-01-31 20:10:02 +0000 | [diff] [blame] | 37 | $return = array(); |
| 38 | |
gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 39 | while($line = mysql_fetch_array($res, MYSQL_ASSOC)){ |
| 40 | $ret = Array(); |
| 41 | $ret['version'] = $line['version']; |
droy | d664f91 | 2008-05-14 15:45:10 +0000 | [diff] [blame^] | 42 | $ret['pct'] = $line['pct_complete']; |
| 43 | |
gobrien | da3a450 | 2008-01-28 23:43:26 +0000 | [diff] [blame] | 44 | if(isset($_SESSION['version']) and $line['version'] == $_SESSION['version']){ |
gobrien | e4a39c8 | 2008-01-11 00:06:14 +0000 | [diff] [blame] | 45 | $ret['current'] = true; |
| 46 | } |
gobrien | ad11d89 | 2007-12-19 08:33:25 +0000 | [diff] [blame] | 47 | $return[] = $ret; |
| 48 | } |
| 49 | |
| 50 | print json_encode($return); |
| 51 | |
| 52 | ?> |