blob: 6e7885a6697367b6a7c6044ac62bbf9906f9eb9d [file] [log] [blame]
gobrienad11d892007-12-19 08:33:25 +00001<?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*******************************************************************************/
13require_once("cb_global.php");
14
15
gobrienda3a4502008-01-28 23:43:26 +000016
17if(!isset($_SESSION['project'])){
18 return array();
19}
20
droy8ade9362008-05-14 15:58:39 +000021$language = "";
22if(isset($_SESSION['language'])) {
23 $language = $_SESSION['language'];
24}
25
26
droyd664f912008-05-14 15:45:10 +000027$query = "select DISTINCT
28 f.version,
29 f.project_id,
30 IF(ISNULL(pct_complete),0,ROUND(pct_complete,1)) AS pct_complete
31 from
32 project_versions AS v
33 INNER JOIN files as f on (f.project_id = v.project_id AND f.version = v.version)
droy8ade9362008-05-14 15:58:39 +000034 LEFT JOIN project_progress AS p ON (p.project_id = v.project_id AND p.version = v.version and p.language_id = " . addslashes($language) . ")
droyd664f912008-05-14 15:45:10 +000035 where
36 v.is_active = 1
37 and v.project_id = '".addslashes($_SESSION['project'])."'";
gobrienad11d892007-12-19 08:33:25 +000038
39//print $query."\n";
40
41$res = mysql_query($query,$dbh);
42
gobrien4b7797e2008-01-31 20:10:02 +000043$return = array();
44
gobrienad11d892007-12-19 08:33:25 +000045while($line = mysql_fetch_array($res, MYSQL_ASSOC)){
46 $ret = Array();
47 $ret['version'] = $line['version'];
droyd664f912008-05-14 15:45:10 +000048 $ret['pct'] = $line['pct_complete'];
49
gobrienda3a4502008-01-28 23:43:26 +000050 if(isset($_SESSION['version']) and $line['version'] == $_SESSION['version']){
gobriene4a39c82008-01-11 00:06:14 +000051 $ret['current'] = true;
52 }
gobrienad11d892007-12-19 08:33:25 +000053 $return[] = $ret;
54}
55
56print json_encode($return);
57
58?>