PageRenderTime 62ms CodeModel.GetById 20ms RepoModel.GetById 1ms app.codeStats 0ms

/lib/functions/testplan.class.php

https://bitbucket.org/pfernandez/testlink1.9.6
PHP | 4095 lines | 2402 code | 453 blank | 1240 comment | 209 complexity | 0e0b90199993b6c3e7c62e0e24e2edc3 MD5 | raw file
Possible License(s): GPL-2.0, LGPL-2.1, GPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /** 

    3. 

  3.  * TestLink Open Source Project - http://testlink.sourceforge.net/

    4. 

  4.  * This script is distributed under the GNU General Public License 2 or later. 

    5. 

  5.  *

    6. 

  6.  * Manages test plan operations and related items like Custom fields, 

    7. 

  7.  * Builds, Custom fields, etc

    8. 

  8.  *

    9. 

  9.  * @package 	TestLink

    10. 

  10.  * @author 		franciscom

    11. 

  11.  * @copyright 	2007-2009, TestLink community 

    12. 

  12.  * @version    	CVS: $Id: testplan.class.php,v 1.209 2010/08/31 19:40:15 mx-julian Exp $

    13. 

  13.  * @link 		http://www.teamst.org/index.php

    14. 

  14.  *

    15. 

  15.  *

    16. 

  16.  * @internal Revisions:

    17. 

  17.  *	20100830 - franciscom - get_linked_tcversions() - missing cast to array	$my['filters']['exec_status']

    18. 

  18.  *							urgencyImportanceToPriorityLevel() - refactored

    19. 

  19.  *	20100827 - franciscom - new method wrapper - hasLinkedPlatforms()

    20. 

  20.  *  20100727 - asimon - BUGID 3629: modified statement in get_linked_tcversions()

    21. 

  21.  *  20100725 - asimon - BUGID 3497 and hopefully also 3530 fixed in unlink_tcversions()

    22. 

  22.  *  20100723 - asimon - commented out some old debug message in copy_linked_tcversions()

    23. 

  23.  *  20100722 - asimon - added missing $debugMsg to get_linked_items()

    24. 

  24.  *  20100721 - asimon - BUGID 3406: added user_assignments_per_build option to get_linked_tcversions()

    25. 

  25.  *	20100711 - franciscom - BUGID 3564 -> getPlatforms()

    26. 

  26.  *	20100614 - eloff - refactor getStatusTotalsByPriority() to same style as the other getStatusTotals...()

    27. 

  27.  *	20100610 - eloff - BUGID 3515 - getStatusTotals() now takes platforms into account

    28. 

  28.  *	20100602 - franciscom - copy_as() - force Platforms Link copy when user choose Test Case Copy

    29. 

  29.  *  20100527 - Julian - BUGID 3492 - Added execution notes to sql statement of get_linked_tcversions

    30. 

  30.  *  20100525 - Julian - changed default for steps_info option on get_linked_tcversions() to false

    31. 

  31.  *  					-> performance improvement because not all steps are loaded per default

    32. 

  32.  *	20100520 - franciscom - getTestCaseSiblings() join bug

    33. 

  33.  *	20100518 - franciscom - BUGID 3473

    34. 

  34.  *	20100516 - franciscom - BUGID 3465: Delete Test Project - User Execution Assignment is not deleted

    35. 

  35.  *	20100506 - franciscom - new method - get_linked_items_id(), that has perfomance advantages

    36. 

  36.  *							over get_linked_tcversions() when only info needed is test case id.

    37. 

  37.  *

    38. 

  38.  *	20100505 - franciscom - BUGID 3434 - get_keywords_map() - refactoring trying to improve performance

    39. 

  39.  *	20100505 - franciscom - BUGID 3430 - copy_milestones() - need to check if start date is NOT NULL

    40. 

  40.  *	20100425 - franciscom - BUGID 2463 - changes in getStatusTotalsByAssignedTesterPlatform()

    41. 

  41.  * 	20100417 - franciscom - get_linked_tcversions() added importance on output data

    42. 

  42.  *                          BUGID 3356: Failed Test Cases" report is not updated when a test case 

    43. 

  43.  *                                      has been changed from "Failed" to "Passed"		 

    44. 

  44.  *

    45. 

  45.  *  20100217 - asimon - added parameters open and active to getNumberOfBuilds()

    46. 

  46.  *  20100214 - franciscom - BUGID 2455, BUGID 3026 - Contribution by julian,asimon

    47. 

  47.  *  20100206 - eloff - BUGID 3060 - Adding getStatusTotalsByPriority()

    48. 

  48.  *  20100206 - eloff - BUGID 3060 - Adding urgencyImportanceToPriorityLevel() method

    49. 

  49.  *  20100201 - franciscom - BUGID 3121 - Adding Platform to test plan after the execution completed,

    50. 

  50.  *                                       reports are not shown appropriate 	

    51. 

  51.  *  20100112 - franciscom - getPlatforms() - interface changes

    52. 

  52.  *	20100106 - franciscom - Multiple Test Case Steps Feature

    53. 

  53.  *                          Affected Methods: get_linked_tcversions()

    54. 

  54.  *	20091111 - franciscom - BUGID 2938 - getTestCaseSiblings(), getTestCaseNextSibling()

    55. 

  55.  *  20091031 - franciscom - tallyResultsForReport()

    56. 

  56.  *  20091027 - franciscom - BUGID 2500 - get_linked_tcversions()

    57. 

  57.  *  20091025 - franciscom - new method - getStatusTotalsByPlatform()

    58. 

  58.  *                          bug found on getNotExecutedLinkedTCVersionsDetailed()

    59. 

  59.  *                          missing testplan_id on execution join

    60. 

  60.  *

    61. 

  61.  *	20091010 - franciscom - getNotExecutedLinkedTCVersionsDetailed() new options

    62. 

  62.  *  20091004 - franciscom - get_linked_tcversions() - fixed query when requesting exec status filtering.

    63. 

  63.  *                                                  - added more columns to output record set

    64. 

  64.  *  20090923 - franciscom - link_tcversions() - will return data

    65. 

  65.  *  20090920 - franciscom - getStatusTotals(), will replace some result.class method

    66. 

  66.  *  20090919 - franciscom - copy_as(), copy_linked_tcversions() added contribution (refactored)

    67. 

  67.  *                          to copy user assignment.

    68. 

  68.  *

    69. 

  69.  * 	20090822 - franciscom - changeLinkedTCVersionsPlatform() - new method

    70. 

  70.  *                          countLinkedTCVersionsByPlatform() - new method

    71. 

  71.  *  20090814 - franciscom - link_tcversions() - interface changes - due to platform feature

    72. 

  72.  *  20090516 - franciscom - BUGID - is_public

    73. 

  73.  *                          create(),update() changed

    74. 

  74.  *  20090509 - franciscom - BUGID - build class manage release_date

    75. 

  75.  *  20090411 - franciscom - BUGID 2369 - link_tcversions() - interface changes

    76. 

  76.  *  20090214 - franciscom - BUGID 2099 - get_linked_tcversions() - added new columns in output recordset

    77. 

  77.  *  20090208 - franciscom - testplan class - new method get_build_by_id()

    78. 

  78.  *  20090201 - franciscom - copy_milestones() - wrong SQL sentece 

    79. 

  79.  *                          A,B,C fields renamed to lower case a,b,c to avoid problems

    80. 

  80.  *                          between differnt database (case and no case sensitive)

    81. 

  81.  *  20081227 - franciscom - BUGID 1913 - filter by same results on ALL previous builds

    82. 

  82.  *                          get_same_status_for_build_set(), get_prev_builds()

    83. 

  83.  *

    84. 

  84.  *  20081214 - franciscom - Thanks to postgres found missing CAST() on SUM() 

    85. 

  85.  *  20081206 - franciscom - BUGID 1910 - get_estimated_execution_time() - added new filter

    86. 

  86.  *                                       get_linked_tcversions() - added test suites filter 

    87. 

  87.  *  20080820 - franciscom - added get_estimated_execution_time() as result of contributed idea.

    88. 

  88.  *

    89. 

  89.  *  20080811 - franciscom - BUGID 1650 (REQ)

    90. 

  90.  *  20080614 - franciscom - get_linked_and_newest_tcversions() - fixed bug  (thanks to PostGres)

    91. 

  91.  *  20080428 - franciscom - supporting multiple keywords in get_linked_tcversions()

    92. 

  92.  *                          (based on contribution by Eugenia Drosdezki)

    93. 

  93.  *  20080310 - sbouffard - contribution added NHB.name to recordset (useful for API methods).  

    94. 

  94.  *  20071010 - franciscom - BUGID     MSSQL reserved word problem - open

    95. 

  95.  *  20070927 - franciscom - BUGID 1069

    96. 

  96.  *                          added _natsort_builds() (see natsort info on PHP manual).

    97. 

  97.  *                          get_builds() add call to _natsort_builds()

    98. 

  98.  *                          get_builds_for_html_options() add call to natsort()

    99. 

  99.  *  20070310 - franciscom - BUGID 731

    100. 

  100.  *  20070306 - franciscom - BUGID 705 - changes in get_linked_tcversions()

    101. 

  101.  **/

    102. 

  102. 

    103. 

  103. /** related functionality */

    104. 

  104. require_once( dirname(__FILE__) . '/tree.class.php' );

    105. 

  105. require_once( dirname(__FILE__) . '/assignment_mgr.class.php' );

    106. 

  106. require_once( dirname(__FILE__) . '/attachments.inc.php' );

    107. 

  107. 

    108. 

  108. /**

    109. 

  109.  * class to coordinate and manage Test Plans

    110. 

  110.  * @package 	TestLink

    111. 

  111.  * @todo havlatm: create class testplanEdit (as extension of testplan class) and 

    112. 

  112.  *		move here create,edit,delete,copy related stuff

    113. 

  113.  * @TODO franciscom - absolutely disagree with suggested approach, see no value - 20090611

    114. 

  114.  */

    115. 

  115. class testplan extends tlObjectWithAttachments

    116. 

  116. {

    117. 

  117. 	/** query options */

    118. 

  118. 	const GET_ALL=null;

    119. 

  119. 	const GET_ACTIVE_BUILD=1;

    120. 

  120. 	const GET_INACTIVE_BUILD=0;

    121. 

  121. 	const GET_OPEN_BUILD=1;

    122. 

  122. 	const GET_CLOSED_BUILD=0;

    123. 

  123. 	const ACTIVE_BUILDS=1;

    124. 

  124. 	const ENABLED=1;

    125. 

  125. 

    126. 

  126. 	/** @var database handler */

    127. 

  127. 	var $db;

    128. 

  128. 

    129. 

  129. 	var $tree_manager;

    130. 

  130. 	var $assignment_mgr;

    131. 

  131. 	var $cfield_mgr;

    132. 

  132. 	var $tcase_mgr;

    133. 

  133.    

    134. 

  134. 	var $assignment_types;

    135. 

  135. 	var $assignment_status;

    136. 

  136. 

    137. 

  137. 	/** message to show on GUI */

    138. 

  138. 	var $user_feedback_message = '';

    139. 

  139. 

    140. 

  140. 	var $node_types_descr_id;

    141. 

  141. 	var $node_types_id_descr;

    142. 

  142. 	

    143. 

  143. 	/**

    144. 

  144. 	 * testplan class constructor

    145. 

  145. 	 * 

    146. 

  146. 	 * @param resource &$db reference to database handler

    147. 

  147. 	 */

    148. 

  148. 	function __construct(&$db)

    149. 

  149. 	{

    150. 

  150. 	    $this->db = &$db;

    151. 

  151. 	    $this->tree_manager = New tree($this->db);

    152. 

  152. 		$this->node_types_descr_id=$this->tree_manager->get_available_node_types();

    153. 

  153. 		$this->node_types_id_descr=array_flip($this->node_types_descr_id);

    154. 

  154.       

    155. 

  155. 	    $this->assignment_mgr = new assignment_mgr($this->db);

    156. 

  156. 	    $this->assignment_types = $this->assignment_mgr->get_available_types();

    157. 

  157. 	    $this->assignment_status = $this->assignment_mgr->get_available_status();

    158. 

  158. 

    159. 

  159.     	$this->cfield_mgr = new cfield_mgr($this->db);

    160. 

  160.     	$this->tcase_mgr = New testcase($this->db);

    161. 

  161. 		$this->platform_mgr = new tlPlatform($this->db);

    162. 

  162.    	

    163. 

  163. 	    tlObjectWithAttachments::__construct($this->db,'testplans');

    164. 

  164. 	}

    165. 

  165. 

    166. 

  166. 

    167. 

  167. 	/**

    168. 

  168. 	 * creates a tesplan on Database, for a testproject.

    169. 

  169. 	 * 

    170. 

  170. 	 * @param string $name: testplan name

    171. 

  171. 	 * @param string $notes: testplan notes

    172. 

  172. 	 * @param string $testproject_id: testplan parent

    173. 

  173. 	 * 

    174. 

  174. 	 * @return integer status code

    175. 

  175. 	 * 		if everything ok -> id of new testplan (node id).

    176. 

  176. 	 * 		if problems -> 0.

    177. 

  177. 	 */

    178. 

  178. 	function create($name,$notes,$testproject_id,$is_active=1,$is_public=1)

    179. 

  179. 	{

    180. 

  180. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    181. 

  181. 

    182. 

  182. 		$node_types=$this->tree_manager->get_available_node_types();

    183. 

  183. 		$tplan_id = $this->tree_manager->new_node($testproject_id,$node_types['testplan'],$name);

    184. 

  184. 		

    185. 

  185. 		$active_status=intval($is_active) > 0 ? 1 : 0;

    186. 

  186. 		$public_status=intval($is_public) > 0 ? 1 : 0;

    187. 

  187. 		

    188. 

  188. 		$sql = "/* $debugMsg */ " . 

    189. 

  189. 		       " INSERT INTO {$this->tables['testplans']} (id,notes,testproject_id,active,is_public) " .

    190. 

  190. 			   " VALUES ( {$tplan_id} " . ", '" . $this->db->prepare_string($notes) . "'," . 

    191. 

  191. 			   $testproject_id . "," . $active_status . "," . $public_status . ")";

    192. 

  192. 		$result = $this->db->exec_query($sql);

    193. 

  193. 		$id = 0;

    194. 

  194. 		if ($result)

    195. 

  195. 		{

    196. 

  196. 			$id = $tplan_id;

    197. 

  197. 		}

    198. 

  198. 

    199. 

  199. 		return $id;

    200. 

  200. 	}

    201. 

  201. 

    202. 

  202. 

    203. 

  203. 	/**

    204. 

  204. 	 * update testplan information

    205. 

  205. 	 * 

    206. 

  206. 	 * @param integer $id Test plan identifier

    207. 

  207. 	 * @param string $name: testplan name

    208. 

  208. 	 * @param string $notes: testplan notes

    209. 

  209. 	 * @param boolean $is_active

    210. 

  210. 	 * 

    211. 

  211. 	 * @return integer result code (1=ok)

    212. 

  212. 	 */

    213. 

  213. 	function update($id,$name,$notes,$is_active=null,$is_public=null)

    214. 

  214. 	{

    215. 

  215. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    216. 

  216. 		$do_update = 1;

    217. 

  217. 		$result = null;

    218. 

  218. 		// $active = to_boolean($is_active);

    219. 

  219. 		$name = trim($name);

    220. 

  220. 		

    221. 

  221. 		// two tables to update and we have no transaction yet.

    222. 

  222. 		$rsa = $this->get_by_id($id);

    223. 

  223. 		$duplicate_check = (strcmp($rsa['name'],$name) != 0 );

    224. 

  224. 		

    225. 

  225. 		if($duplicate_check)

    226. 

  226. 		{

    227. 

  227. 			$rs = $this->get_by_name($name,$rsa['parent_id']);

    228. 

  228. 			$do_update = is_null($rs);

    229. 

  229. 		}

    230. 

  230. 		

    231. 

  231. 		if($do_update)

    232. 

  232. 		{

    233. 

  233. 			// Update name

    234. 

  234.             $sql = "/* $debugMsg */ ";

    235. 

  235. 			$sql .= "UPDATE {$this->tables['nodes_hierarchy']} " .

    236. 

  236. 				    "SET name='" . $this->db->prepare_string($name) . "'" .

    237. 

  237. 				    "WHERE id={$id}";

    238. 

  238. 			$result = $this->db->exec_query($sql);

    239. 

  239. 			

    240. 

  240. 			if($result)

    241. 

  241. 			{

    242. 

  242. 				$add_upd='';

    243. 

  243. 				if( !is_null($is_active) )

    244. 

  244. 				{

    245. 

  245. 					$add_upd .=',active=' . (intval($is_active) > 0 ? 1 : 0);

    246. 

  246. 				}

    247. 

  247. 				if( !is_null($is_public) )

    248. 

  248. 				{

    249. 

  249. 					$add_upd .=',is_public=' . (intval($is_public) > 0 ? 1:0);

    250. 

  250. 				}

    251. 

  251. 				

    252. 

  252. 				$sql = " UPDATE {$this->tables['testplans']} " .

    253. 

  253. 					" SET notes='" . $this->db->prepare_string($notes). "' " .

    254. 

  254. 					" {$add_upd} WHERE id=" . $id;

    255. 

  255. 				$result = $this->db->exec_query($sql);

    256. 

  256. 			}

    257. 

  257. 		}

    258. 

  258. 		return ($result ? 1 : 0);

    259. 

  259. 	}

    260. 

  260. 

    261. 

  261. 

    262. 

  262. 	/*

    263. 

  263. 	 function: get_by_name

    264. 

  264. 	 get information about a testplan using name as access key.

    265. 

  265. 	 Search can be narrowed, givin a testproject id as filter criteria.

    266. 

  266. 	 

    267. 

  267. 	 args: name: testplan name

    268. 

  268. 	 [tproject_id]: default:0 -> system wide search i.e. inside all testprojects

    269. 

  269. 	 

    270. 

  270. 	 returns: if nothing found -> null

    271. 

  271. 	 if found -> array where every element is a map with following keys:

    272. 

  272. 	 id: testplan id

    273. 

  273. 	 notes:

    274. 

  274. 	 active: active status

    275. 

  275. 	 is_open: open status

    276. 

  276. 	 name: testplan name

    277. 

  277. 	 testproject_id

    278. 

  278. 	 */

    279. 

  279. 	function get_by_name($name,$tproject_id = 0)

    280. 

  280. 	{

    281. 

  281. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    282. 

  282.         $sql = "/* $debugMsg */ ";

    283. 

  283. 		$sql .= " SELECT testplans.*, NH.name " .

    284. 

  284. 			    " FROM {$this->tables['testplans']} testplans, " .

    285. 

  285. 			    " {$this->tables['nodes_hierarchy']} NH" .

    286. 

  286. 			    " WHERE testplans.id=NH.id " .

    287. 

  287. 			    " AND NH.name = '" . $this->db->prepare_string($name) . "'";

    288. 

  288. 		

    289. 

  289. 		if($tproject_id > 0 )

    290. 

  290. 		{

    291. 

  291. 			$sql .= " AND NH.parent_id={$tproject_id}";

    292. 

  292. 		}

    293. 

  293. 		

    294. 

  294. 		$recordset = $this->db->get_recordset($sql);

    295. 

  295. 		return($recordset);

    296. 

  296. 	}

    297. 

  297. 

    298. 

  298. 

    299. 

  299. 	/*

    300. 

  300. 	 function: get_by_id

    301. 

  301. 	 

    302. 

  302. 	 args : id: testplan id

    303. 

  303. 	 

    304. 

  304. 	 returns: map with following keys:

    305. 

  305. 	 id: testplan id

    306. 

  306. 	 name: testplan name

    307. 

  307. 	 notes: testplan notes

    308. 

  308. 	 testproject_id

    309. 

  309. 	 active

    310. 

  310. 	 is_open

    311. 

  311. 	 parent_id

    312. 

  312. 	 */

    313. 

  313. 	function get_by_id($id)

    314. 

  314. 	{

    315. 

  315. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    316. 

  316.         $sql = "/* $debugMsg */ " .

    317. 

  317. 		       " SELECT testplans.*,NH.name,NH.parent_id " .

    318. 

  318. 			   " FROM {$this->tables['testplans']} testplans, " .

    319. 

  319. 			   " {$this->tables['nodes_hierarchy']} NH " .

    320. 

  320. 			   " WHERE testplans.id = NH.id AND  testplans.id = {$id}";

    321. 

  321. 		$recordset = $this->db->get_recordset($sql);

    322. 

  322. 		return($recordset ? $recordset[0] : null);

    323. 

  323. 	}

    324. 

  324. 

    325. 

  325. 

    326. 

  326. 	/*

    327. 

  327.   		function: get_all

    328. 

  328.             get array of info for every test plan,

    329. 

  329.             without considering Test Project and any other kind of filter.

    330. 

  330.             Every array element contains an assoc array

    331. 

  331. 

    332. 

  332.   		args : -

    333. 

  333. 

    334. 

  334.   		returns: array, every element is a  map with following keys:

    335. 

  335.            id: testplan id

    336. 

  336.            name: testplan name

    337. 

  337.            notes: testplan notes

    338. 

  338.            testproject_id

    339. 

  339.            active

    340. 

  340.            is_open

    341. 

  341.            parent_id

    342. 

  342. 	*/

    343. 

  343. 	function get_all()

    344. 

  344. 	{

    345. 

  345. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    346. 

  346.         $sql = "/* $debugMsg */ " .

    347. 

  347. 		       " SELECT testplans.*, NH.name " .

    348. 

  348. 			   " FROM {$this->tables['testplans']} testplans, " .

    349. 

  349. 			   " {$this->tables['nodes_hierarchy']} NH " .

    350. 

  350. 			   " WHERE testplans.id=NH.id";

    351. 

  351. 		$recordset = $this->db->get_recordset($sql);

    352. 

  352. 		return $recordset;

    353. 

  353. 	}

    354. 

  354. 

    355. 

  355. 	/*

    356. 

  356. 	  function: count_testcases

    357. 

  357.             get number of testcases linked to a testplan

    358. 

  358. 

    359. 

  359. 	  args: id: testplan id

    360. 

  360. 

    361. 

  361.             [platform_id]: null => do not filter by platform

    362. 

  362.             

    363. 

  363. 	  returns: number

    364. 

  364. 	*/

    365. 

  365. 	public function count_testcases($id,$platform_id=null)

    366. 

  366. 	{

    367. 

  367. 		$sql_filter = '';

    368. 

  368. 		if( !is_null($platform_id) )

    369. 

  369. 		{

    370. 

  370. 			$sql_filter = " AND platform_id={$platform_id} ";

    371. 

  371. 		}

    372. 

  372. 		

    373. 

  373. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    374. 

  374.         $sql = "/* $debugMsg */ " .

    375. 

  375. 	           " SELECT COUNT(testplan_id) AS qty " .

    376. 

  376. 		       " FROM {$this->tables['testplan_tcversions']} " .

    377. 

  377. 			   " WHERE testplan_id={$id} {$sql_filter}";

    378. 

  378. 		$recordset = $this->db->get_recordset($sql);

    379. 

  379. 		$qty = 0;

    380. 

  380. 		if(!is_null($recordset))

    381. 

  381. 		{

    382. 

  382. 			$qty = $recordset[0]['qty'];

    383. 

  383. 		}

    384. 

  384. 		return $qty;

    385. 

  385. 	}

    386. 

  386. 

    387. 

  387. 

    388. 

  388. 	/*

    389. 

  389. 	  function: tcversionInfoForAudit

    390. 

  390.             get info regarding tcversions, to generate useful audit messages

    391. 

  391.             

    392. 

  392. 

    393. 

  393. 	  args :

    394. 

  394.         $tplan_id: test plan id

    395. 

  395.         $items_to_link: map key=tc_id 

    396. 

  396.                         value: tcversion_id

    397. 

  397. 	  returns: -

    398. 

  398. 

    399. 

  399. 	  rev: 20080629 - franciscom - audit message improvements

    400. 

  400. 	*/

    401. 

  401. 	function tcversionInfoForAudit($tplan_id,&$items)

    402. 

  402. 	{

    403. 

  403. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    404. 

  404. 		

    405. 

  405. 		// Get human readeable info for audit

    406. 

  406. 		$ret=array();

    407. 

  407. 		$tcase_cfg = config_get('testcase_cfg');

    408. 

  408. 		$dummy=reset($items);

    409. 

  409. 		

    410. 

  410. 		list($ret['tcasePrefix'],$tproject_id) = $this->tcase_mgr->getPrefix($dummy);

    411. 

  411. 		$ret['tcasePrefix'] .= $tcase_cfg->glue_character;

    412. 

  412. 		

    413. 

  413.         $sql = "/* $debugMsg */ " .

    414. 

  414. 		       " SELECT TCV.id, tc_external_id, version, NHB.name " .

    415. 

  415. 			   " FROM {$this->tables['tcversions']} TCV,{$this->tables['nodes_hierarchy']} NHA, " .

    416. 

  416. 			   " {$this->tables['nodes_hierarchy']} NHB " .

    417. 

  417. 			   " WHERE NHA.id=TCV.id " .

    418. 

  418. 			   " AND NHB.id=NHA.parent_id  " .

    419. 

  419. 			   " AND TCV.id IN (" . implode(',',$items) . ")";

    420. 

  420. 		

    421. 

  421. 		$ret['info']=$this->db->fetchRowsIntoMap($sql,'id');  

    422. 

  422. 		$ret['tplanInfo']=$this->get_by_id($tplan_id);                                                          

    423. 

  423. 		

    424. 

  424. 		return $ret;

    425. 

  425. 	}

    426. 

  426. 

    427. 

  427. 

    428. 

  428. 	/**

    429. 

  429. 	 * associates version of different test cases to a test plan.

    430. 

  430. 	 * this is the way to populate a test plan

    431. 

  431. 

    432. 

  432.  	 args :

    433. 

  433.         $id: test plan id

    434. 

  434.         $items_to_link: map key=tc_id 

    435. 

  435.                         value= map with

    436. 

  436.                                key: platform_id (can be 0)

    437. 

  437.                                value: tcversion_id

    438. 

  438.                         passed by reference for speed

    439. 

  439. 	  returns: -

    440. 

  440. 

    441. 

  441. 	  rev: 20080629 - franciscom - audit message improvements

    442. 

  442. 	*/

    443. 

  443. 	function link_tcversions($id,&$items_to_link,$userId)

    444. 

  444. 	{

    445. 

  445. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    446. 

  446. 		

    447. 

  447. 		// Get human readeable info for audit

    448. 

  448. 		$title_separator = config_get('gui_title_separator_1');

    449. 

  449. 		$auditInfo=$this->tcversionInfoForAudit($id,$items_to_link['tcversion']);

    450. 

  450. 		$platformInfo = $this->platform_mgr->getLinkedToTestplanAsMap($id);

    451. 

  451. 		$platformLabel = lang_get('platform');

    452. 

  452. 		

    453. 

  453. 		// Important: MySQL do not support default values on datetime columns that are functions

    454. 

  454. 		// that's why we are using db_now().

    455. 

  455. 		$sql = "/* $debugMsg */ " .

    456. 

  456. 		       "INSERT INTO {$this->tables['testplan_tcversions']} " .

    457. 

  457. 			   "(testplan_id,author_id,creation_ts,tcversion_id,platform_id) " . 

    458. 

  458. 			   " VALUES ({$id},{$userId},{$this->db->db_now()},";

    459. 

  459.         $features=null;

    460. 

  460. 		foreach($items_to_link['items'] as $tcase_id => $items)

    461. 

  461. 		{

    462. 

  462. 			foreach($items as $platform_id => $tcversion)

    463. 

  463. 			{

    464. 

  464. 				$addInfo='';

    465. 

  465. 				$result = $this->db->exec_query($sql . "{$tcversion}, {$platform_id})");

    466. 

  466. 				if ($result)

    467. 

  467. 				{

    468. 

  468.                     $features[$platform_id][$tcversion]=$this->db->insert_id($this->tables['testplan_tcversions']);					

    469. 

  469. 					if( isset($platformInfo[$platform_id]) )

    470. 

  470. 					{

    471. 

  471. 						$addInfo = ' - ' . $platformLabel . ':' . $platformInfo[$platform_id];

    472. 

  472. 					}

    473. 

  473. 					$auditMsg=TLS("audit_tc_added_to_testplan",

    474. 

  474. 								  $auditInfo['tcasePrefix'] . $auditInfo['info'][$tcversion]['tc_external_id'] . 

    475. 

  475. 								  $title_separator . $auditInfo['info'][$tcversion]['name'],

    476. 

  476. 								  $auditInfo['info'][$tcversion]['version'],

    477. 

  477. 								  $auditInfo['tplanInfo']['name'] . $addInfo );

    478. 

  478. 					

    479. 

  479. 					logAuditEvent($auditMsg,"ASSIGN",$id,"testplans");

    480. 

  480. 				}	

    481. 

  481. 			}

    482. 

  482. 		}

    483. 

  483. 		return $features;

    484. 

  484. 	}

    485. 

  485. 

    486. 

  486. 

    487. 

  487. 	/*

    488. 

  488. 	  function: setExecutionOrder

    489. 

  489. 

    490. 

  490.   	args :

    491. 

  491.         $id: test plan id

    492. 

  492.         $executionOrder: assoc array key=tcversion_id value=order

    493. 

  493.                          passed by reference for speed

    494. 

  494. 

    495. 

  495.   	returns: -

    496. 

  496. 	*/

    497. 

  497. 	function setExecutionOrder($id,&$executionOrder)

    498. 

  498. 	{

    499. 

  499. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    500. 

  500. 		foreach($executionOrder as $tcVersionID => $execOrder)

    501. 

  501. 		{

    502. 

  502. 			$execOrder=intval($execOrder);

    503. 

  503. 			$sql="/* $debugMsg */ UPDATE {$this->tables['testplan_tcversions']} " .

    504. 

  504. 				 "SET node_order={$execOrder} " .

    505. 

  505. 				 "WHERE testplan_id={$id} " .

    506. 

  506. 				 "AND tcversion_id={$tcVersionID}";

    507. 

  507. 			$result = $this->db->exec_query($sql);

    508. 

  508. 		}

    509. 

  509. 	}

    510. 

  510. 	

    511. 

  511. 

    512. 

  512. 	/**

    513. 

  513. 	 *

    514. 

  514. 	 * @internal revisions:

    515. 

  515. 	 *   20100722 - asimon - added missing $debugMsg

    516. 

  516. 	 */

    517. 

  517. 	function get_linked_items_id($id)

    518. 

  518. 	{

    519. 

  519. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    520. 

  520. 		$sql = " /* $debugMsg */ ". 

    521. 

  521. 			   " SELECT DISTINCT parent_id FROM {$this->tables['nodes_hierarchy']} NHTC " .

    522. 

  522. 			   " JOIN {$this->tables['testplan_tcversions']} TPTCV ON TPTCV.tcversion_id = NHTC.id " .

    523. 

  523. 			   " WHERE TPTCV.testplan_id = {$id} ";

    524. 

  524. 			   

    525. 

  525. 		$linked_items = $this->db->fetchRowsIntoMap($sql,'parent_id');			     

    526. 

  526. 		return $linked_items;

    527. 

  527. 	}

    528. 

  528. 

    529. 

  529. 

    530. 

  530. 	/*

    531. 

  531.   	function: get_linked_tcversions

    532. 

  532.             get information about testcases linked to a testplan.

    533. 

  533. 

    534. 

  534.   	args :

    535. 

  535.          id: testplan id

    536. 

  536.          [filters]: map with following keys

    537. 

  537.          	[tcase_id]: default null => get any testcase

    538. 

  538.          	            numeric      => just get info for this testcase

    539. 

  539.          	

    540. 

  540.          	[keyword_id]: default 0 => do not filter by keyword id

    541. 

  541.          	              numeric   => filter by keyword id

    542. 

  542.          	

    543. 

  543.          	

    544. 

  544.          	[assigned_to]: default NULL => do not filter by user assign.

    545. 

  545.          	               array() with user id to be used on filter

    546. 

  546.          	

    547. 

  547.          	[exec_status]: default NULL => do not filter by execution status

    548. 

  548.          	               character or array => filter by execution status=character

    549. 

  549.          	

    550. 

  550.          	[build_id]: default 0 => do not filter by build id

    551. 

  551.          	            numeric   => filter by build id

    552. 

  552.          	

    553. 

  553.          	[cf_hash]: default null => do not filter by Custom Fields values

    554. 

  554.          	

    555. 

  555. 		 	

    556. 

  556. 		 	[urgencyImportance] : filter only Tc's with certain (urgency*importance)-value 

    557. 

  557. 		 	

    558. 

  558. 		 	[tsuites_id]: default null.

    559. 

  559. 		 	              If present only tcversions that are children of this testsuites

    560. 

  560. 		 	              will be included

    561. 

  561. 		 	[exec_type] default null -> all types. 

    562. 

  562. 		 	[platform_id]              

    563. 

  563. 		     		

    564. 

  564.          [options]: map with following keys

    565. 

  565.          	[output]: controls data type returned

    566. 

  566.          	          default: map -> map indexed by test case id (original return type)

    567. 

  567.          	                          Using this option is (in a certain way) as having

    568. 

  568.          	                          added DISTINCT on SQL clause.

    569. 

  569.          	                          YOU WILL GET ONLY LAST EXECUTION (means one record)

    570. 

  570.          	                          of each test case.

    571. 

  571.          	                          

    572. 

  572.          	                   mapOfMap: first key testcase_id, second key platform_id               

    573. 

  573.          	                            You GET ONLY LAST EXECUTION (means one record)

    574. 

  574.          	                            of each test case.

    575. 

  575. 

    576. 

  576.          	                   mapOfArray -> indexed by test case id but with an array

    577. 

  577.          	                                 where each element contains information

    578. 

  578.          	                                 according to Platform.

    579. 

  579.          	                                 Be carefull if you have multiple executions

    580. 

  580.          	                                 for same (testcase,platform) YOU WILL GET

    581. 

  581.          	                                 MULTIPLE ELEMENTS IN ARRAY

    582. 

  582.          	                                 

    583. 

  583.          	                  array -> indexed sequentially. 

    584. 

  584.          	                  

    585. 

  585.          	                            

    586. 

  586.          	          

    587. 

  587.          	[only_executed]: default false => get executed and NOT executed

    588. 

  588.          	                                  get only executed tcversions

    589. 

  589.          

    590. 

  590.          	[execution_details]: default NULL => by platftorm

    591. 

  591.          	                     add_build => by build AND platform

    592. 

  592.          	                             

    593. 

  593.          	[last_execution]: default false => return all executions

    594. 

  594.          	                          true => last execution ( MAX(E.id))

    595. 

  595.          	                          

    596. 

  596.          	[include_unassigned]: has effects only if [assigned_to] <> null.

    597. 

  597.          	                      default: false

    598. 

  598.          	                      true: also testcase not assigned will be retreived

    599. 

  599.          	

    600. 

  600.          	[details]: controls columns returned

    601. 

  601.          	           default 'simple'

    602. 

  602.          	           'full': add summary, steps and expected_results, and test suite name

    603. 

  603.          	           'summary': add summary 

    604. 

  604. 		 	[steps_info]: controls if step info has to be added on output    

    605. 

  605.          	           default true

    606. 

  606. 		 	[user_assignments_per_build]: contains a build ID, for which the

    607. 

  607. 		 	                              assigned user shall get loaded    

    608. 

  608. 		 	    

    609. 

  609. 		 	    

    610. 

  610. 	  returns: changes according options['output'] (see above)

    611. 

  611. 

    612. 

  612.            Notice:

    613. 

  613.            executed field: will take the following values

    614. 

  614.                            - NULL if the tc version has not been executed in THIS test plan.

    615. 

  615.                            - tcversion_id if has executions.

    616. 

  616. 

    617. 

  617. 	rev :

    618. 

  618. 		 20100727 - asimon - BUGID 3629: modified statement

    619. 

  619. 		 20100721 - asimon - BUGID 3406: added user_assignments_per_build option

    620. 

  620. 		 20100520 - franciscom - added option steps_info, to try to solve perfomance problems

    621. 

  621. 		 						 allowing caller to ask for NO INFO ABOUT STEPS	

    622. 

  622. 		 20100417 - franciscom - added importance on output data

    623. 

  623. 		 		  				 BUGID 3356: "Failed Test Cases" report is not updated when a test case 

    624. 

  624. 		 		  				 			  has been changed from "Failed" to "Passed"		 

    625. 

  625. 		 		  				 			  

    626. 

  626.          20090814 - franciscom - interface changes due to platform feature

    627. 

  627. 	*/

    628. 

  628. 	public function get_linked_tcversions($id,$filters=null,$options=null)

    629. 

  629. 	{

    630. 

  630. 		$debugMsg = 'Class: ' . __CLASS__ . ' - Method:' . __FUNCTION__;

    631. 

  631. 		

    632. 

  632.         $my = array ('filters' => '', 'options' => '');

    633. 

  633. 		$tcversion_exec_type = array('join' => '', 'filter' => '');

    634. 

  634. 		$tc_id = array('join' => '', 'filter' => '');

    635. 

  635. 		$builds = array('join' => '', 'filter' => '');

    636. 

  636. 		$keywords = array('join' => '', 'filter' => '');

    637. 

  637. 		$executions = array('join' => '', 'filter' => '');

    638. 

  638. 		$platforms = array('join' => '', 'filter' => '');

    639. 

  639. 		

    640. 

  640.         $my['filters'] = array('tcase_id' => null, 'keyword_id' => 0,

    641. 

  641.                                'assigned_to' => null, 'exec_status' => null,

    642. 

  642.                                'build_id' => 0, 'cf_hash' => null,

    643. 

  643.                                'urgencyImportance' => null, 'tsuites_id' => null,

    644. 

  644.                                'platform_id' => null, 'exec_type' => null);

    645. 

  645.                                

    646. 

  646.         $my['options'] = array('only_executed' => false, 'include_unassigned' => false,

    647. 

  647.                                'output' => 'map', 'details' => 'simple', 'steps_info' => false, 

    648. 

  648.                                'execution_details' => null, 'last_execution' => false);

    649. 

  649. 

    650. 

  650.  		// Cast to array to handle $options = null

    651. 

  651. 		$my['filters'] = array_merge($my['filters'], (array)$filters);

    652. 

  652. 		$my['options'] = array_merge($my['options'], (array)$options);

    653. 

  653. 		

    654. 

  654. 		// 20100830 - franciscom - bug found by Julian

    655. 

  655. 		$my['filters']['exec_status'] = (array)$my['filters']['exec_status'];

    656. 

  656. 

    657. 

  657. 		// new dBug($my['filters']);

    658. 

  658. 		// new dBug($my['options']);

    659. 

  659. 

    660. 

  660. 		$groupByPlatform=($my['options']['output']=='mapOfMap' || 

    661. 

  661. 		                  $my['options']['output']=='mapOfMapExecPlatform') ? ',platform_id' : '';

    662. 

  662. 		$groupByBuild=($my['options']['execution_details'] == 'add_build') ? ',build_id' : '';

    663. 

  663. 

    664. 

  664. 		// BUGID 3406: user assignments per build 

    665. 

  665. 		$ua_build = isset($my['options']['user_assignments_per_build']) ? 

    666. 

  666. 		            $my['options']['user_assignments_per_build'] : 0;

    667. 

  667. 		

    668. 

  668. 		// BUGID 3629

    669. 

  669. 		$ua_build_sql = $ua_build && is_numeric($ua_build) ? " AND UA.build_id={$ua_build} " : " ";

    670. 

  670. 		

    671. 

  671.         // @TODO - 20091004 - franciscom

    672. 

  672.         // Think that this subquery in not good when we add execution filter

    673. 

  673. 		// $last_exec_subquery = " AND E.id IN ( SELECT MAX(id) " .

    674. 

  674. 		// 	 		             "               FROM  {$this->tables['executions']} executions " .

    675. 

  675. 		// 			             "               WHERE testplan_id={$id} %EXECSTATUSFILTER%" .

    676. 

  676. 		// 			             " GROUP BY tcversion_id,testplan_id {$groupByPlatform} {$groupByBuild} )";

    677. 

  677. 

    678. 

  678. 		// I've had confirmation of BAD query;

    679. 

  679. 		// BUGID 3356: "Failed Test Cases" report is not updated when a test case 

    680. 

  680. 		// 		  				 			  has been changed from "Failed" to "Passed"		 

    681. 

  681. 		//

    682. 

  682.         // SUBQUERY CAN NOT HAVE ANY KIND OF FILTERING other that test plan.

    683. 

  683.         // Adding exec status, means that we will get last exec WITH THIS STATUS, and not THE LATEST EXEC   

    684. 

  684. 		$last_exec_subquery = " AND E.id IN ( SELECT MAX(id) " .

    685. 

  685. 			 		          "               FROM  {$this->tables['executions']} executions " .

    686. 

  686. 					          "               WHERE testplan_id={$id} " .

    687. 

  687. 					          " GROUP BY tcversion_id,testplan_id {$groupByPlatform} {$groupByBuild} )";

    688. 

  688.            

    689. 

  689.            

    690. 

  690.            

    691. 

  691. 		$resultsCfg = config_get('results');

    692. 

  692. 		$status_not_run=$resultsCfg['status_code']['not_run'];

    693. 

  693. 		$sql_subquery='';

    694. 

  694. 		

    695. 

  695. 		// franciscom

    696. 

  696. 		// WARNING: 

    697. 

  697. 		// Order of analisys seems to be critic, because $executions['filter'] is overwritten

    698. 

  698. 		// on some situation below if filtering on execution status is requested

    699. 

  699. 		if( $my['options']['last_execution'] )

    700. 

  700. 		{

    701. 

  701. 			$executions['filter'] = " {$last_exec_subquery} ";

    702. 

  702. 			// 20100417 - franciscom - BUGID 3356

    703. 

  703. 			// $executions['filter'] = str_ireplace("%EXECSTATUSFILTER%", "", $executions['filter']);

    704. 

  704. 		}

    705. 

  705. 		

    706. 

  706. 		if( !is_null($my['filters']['platform_id']) )

    707. 

  707. 		{

    708. 

  708. 			$platforms['filter'] = " AND T.platform_id = {$my['filters']['platform_id']} ";

    709. 

  709. 	    }

    710. 

  710. 		

    711. 

  711. 		// 20100417- Why to use a list ? - must be checked if is on

    712. 

  712. 		if( !is_null($my['filters']['exec_type']) )

    713. 

  713. 		{

    714. 

  714. 			$tcversion_exec_type['filter'] = "AND TCV.execution_type IN (" . 

    715. 

  715. 			                                 implode(",",(array)$my['filters']['exec_type']) . " ) ";     

    716. 

  716. 		}

    717. 

  717. 		

    718. 

  718. 		// Based on work by Eugenia Drosdezki

    719. 

  719. 		if( is_array($my['filters']['keyword_id']) )

    720. 

  720. 		{

    721. 

  721. 			// 0 -> no keyword, remove 

    722. 

  722. 			if( $my['filters']['keyword_id'][0] == 0 )

    723. 

  723. 			{

    724. 

  724. 				array_shift($my['filters']['keyword_id']);

    725. 

  725. 			}

    726. 

  726. 			

    727. 

  727. 			if(count($my['filters']['keyword_id']))

    728. 

  728. 			{

    729. 

  729. 				$keywords['filter'] = " AND TK.keyword_id IN (" . implode(',',$my['filters']['keyword_id']) . ")";          	

    730. 

  730. 			}  

    731. 

  731. 		}

    732. 

  732. 		else if($my['filters']['keyword_id'] > 0)

    733. 

  733. 		{

    734. 

  734. 			$keywords['filter'] = " AND TK.keyword_id = {$my['filters']['keyword_id']} ";

    735. 

  735. 		}

    736. 

  736. 		

    737. 

  737. 		if(trim($keywords['filter']) != "")

    738. 

  738. 		{

    739. 

  739. 			$keywords['join'] = " JOIN {$this->tables['testcase_keywords']} TK ON NHA.parent_id = TK.testcase_id ";

    740. 

  740. 		}

    741. 

  741. 		

    742. 

  742. 		if (!is_null($my['filters']['tcase_id']) )

    743. 

  743. 		{

    744. 

  744. 			if( is_array($my['filters']['tcase_id']) )

    745. 

  745. 			{

    746. 

  746. 				$tc_id['filter'] = " AND NHA.parent_id IN (" . implode(',',$my['filters']['tcase_id']) . ")";          	

    747. 

  747. 			}

    748. 

  748. 			else if ($my['filters']['tcase_id'] > 0 )

    749. 

  749. 			{

    750. 

  750. 				$tc_id['filter'] = " AND NHA.parent_id = {$my['filters']['tcase_id']} ";

    751. 

  751. 			}

    752. 

  752. 		}

    753. 

  753. 		

    754. 

  754. 		// --------------------------------------------------------------

    755. 

  755. 		if(!is_null($my['filters']['exec_status']) )

    756. 

  756. 		{

    757. 

  757. 			$executions['filter'] = '';

    758. 

  758. 			$notrun['filter'] = null;

    759. 

  759. 			$otherexec['filter'] = null;

    760. 

  760. 			

    761. 

  761. 			$notRunPresent = array_search($status_not_run,$my['filters']['exec_status']); 

    762. 

  762. 			if($notRunPresent !== false)

    763. 

  763. 			{

    764. 

  764. 				$notrun['filter'] = " E.status IS NULL ";

    765. 

  765. 				unset($my['filters']['exec_status'][$notRunPresent]);  

    766. 

  766. 			}

    767. 

  767. 			

    768. 

  768. 			if(count($my['filters']['exec_status']) > 0)

    769. 

  769. 			{

    770. 

  770. 				$otherexec['filter']=" E.status IN ('" . implode("','",$my['filters']['exec_status']) . "') ";

    771. 

  771. 				

    772. 

  772. 				// 20100417 - franciscom - BUGID 3356

    773. 

  773. 				// $status_filter=str_ireplace("E.", "executions.", $otherexec['filter']);

    774. 

  774. 			    // $sql_subquery = str_ireplace("%EXECSTATUSFILTER%", "AND {$status_filter}", $last_exec_subquery);

    775. 

  775. 

    776. 

  776. 				// code commented before BUGID 3356

    777. 

  777. 			    // $sql_subquery = str_ireplace("E.", "executions.", $sql_subquery);

    778. 

  778. 				// $sql_subquery = $last_exec_subquery;

    779. 

  779. 				

    780. 

  780. 				// 20100417 - franciscom - BUGID 3356

    781. 

  781. 				// $executions['filter'] = " ( {$otherexec['filter']} {$sql_subquery} ) ";  

    782. 

  782. 				$executions['filter'] = " ( {$otherexec['filter']} {$last_exec_subquery} ) ";  

    783. 

  783. 			}

    784. 

  784. 			if( !is_null($notrun['filter']) )

    785. 

  785. 			{

    786. 

  786. 				if($executions['filter'] != "")

    787. 

  787. 				{

    788. 

  788. 					$executions['filter'] .= " OR ";

    789. 

  789. 				}

    790. 

  790. 				$executions['filter'] .= $notrun['filter'];

    791. 

  791. 			}

    792. 

  792. 			

    793. 

  793. 			if($executions['filter'] != "")

    794. 

  794. 			{

    795. 

  795.                 // Just add the AND 

    796. 

  796. 				$executions['filter'] = " AND ({$executions['filter']} )";     

    797. 

  797. 			}

    798. 

  798. 		}

    799. 

  799. 		

    800. 

  800. 		// --------------------------------------------------------------

    801. 

  801. 		if( $my['filters']['build_id'] > 0 )

    802. 

  802. 		{

    803. 

  803. 			$builds['filter'] = " AND E.build_id={$my['filters']['build_id']} ";

    804. 

  804. 		}

    805. 

  805. 		

    806. 

  806. 		// there are several situation where you need to use LEFT OUTER

    807. 

  807. 		if(!$my['options']['only_executed'])

    808. 

  808. 		{

    809. 

  809. 			$executions['join'] = " LEFT OUTER ";

    810. 

  810. 		}

    811. 

  811. 		

    812. 

  812. 		

    813. 

  813. 		// platform feature

    814. 

  814. 		$executions['join'] .= " JOIN {$this->tables['executions']} E ON " .

    815. 

  815. 			                   " (NHA.id = E.tcversion_id AND " .

    816. 

  816. 			                   " E.platform_id=T.platform_id AND " .

    817. 

  817. 			                   " E.testplan_id=T.testplan_id {$builds['filter']}) ";

    818. 

  818. 		// --------------------------------------------------------------

    819. 

  819. 		

    820. 

  820. 		$more_tcase_fields = '';

    821. 

  821. 		$join_for_parent = '';

    822. 

  822. 		$more_parent_fields = '';

    823. 

  823. 		$more_exec_fields='';

    824. 

  824. 		switch($my['options']['details'])

    825. 

  825. 		{

    826. 

  826. 			case 'full':

    827. 

  827. 			$more_tcase_fields .= 'TCV.summary,';

    828. 

  828. 			$join_for_parent .= " JOIN {$this->tables['nodes_hierarchy']} NHC ON NHB.parent_id = NHC.id ";

    829. 

  829. 			$more_parent_fields .= 'NHC.name as tsuite_name,';

    830. 

  830. 			break;

    831. 

  831. 			

    832. 

  832. 			case 'summary':

    833. 

  833. 			$more_tcase_fields .= 'TCV.summary,';

    834. 

  834. 			break;

    835. 

  835. 		

    836. 

  836. 		}

    837. 

  837. 		if($my['options']['execution_details'] == 'add_build')

    838. 

  838. 		{

    839. 

  839. 			$more_exec_fields .= 'E.build_id,B.name AS build_name,';	

    840. 

  840. 			$builds['join']=" LEFT OUTER JOIN {$this->tables['builds']} B ON B.id=E.build_id ";

    841. 

  841. 	    }

    842. 

  842. 		

    843. 

  843. 	    // BUGID 3406 - assignments per build

    844. 

  844. 	    // BUGID 3492 - Added execution notes to sql statement of get_linked_tcversions

    845. 

  845. 		$sql = "/* $debugMsg */ " .

    846. 

  846. 		       " SELECT NHB.parent_id AS testsuite_id, {$more_tcase_fields} {$more_parent_fields}" .

    847. 

  847. 			   " NHA.parent_id AS tc_id, NHB.node_order AS z, NHB.name," .

    848. 

  848. 			   " T.platform_id, PLAT.name as platform_name ,T.id AS feature_id, T.tcversion_id AS tcversion_id,  " .

    849. 

  849. 			   " T.node_order AS execution_order, T.creation_ts AS linked_ts, T.author_id AS linked_by," .

    850. 

  850. 			   " TCV.version AS version, TCV.active," .

    851. 

  851. 			   " TCV.tc_external_id AS external_id, TCV.execution_type,TCV.importance," .

    852. 

  852. 			   " E.id AS exec_id, E.tcversion_number," .

    853. 

  853. 			   " E.tcversion_id AS executed, E.testplan_id AS exec_on_tplan, {$more_exec_fields}" .

    854. 

  854. 			   " E.execution_type AS execution_run_type, E.testplan_id AS exec_on_tplan, " .

    855. 

  855. 			   " E.execution_ts, E.tester_id, E.notes as execution_notes, ".

    856. 

  856. 		       " UA.build_id as assigned_build_id, " . // 3406

    857. 

  857. 			   " UA.user_id,UA.type,UA.status,UA.assigner_id,T.urgency, " .

    858. 

  858. 			   " COALESCE(E.status,'" . $status_not_run . "') AS exec_status, ".

    859. 

  859. 			   " (urgency * importance) AS priority " .

    860. 

  860. 			   " FROM {$this->tables['nodes_hierarchy']} NHA " .

    861. 

  861. 			   " JOIN {$this->tables['nodes_hierarchy']} NHB ON NHA.parent_id = NHB.id " .

    862. 

  862. 			   $join_for_parent .

    863. 

  863. 			   " JOIN {$this->tables['testplan_tcversions']} T ON NHA.id = T.tcversion_id " .

    864. 

  864. 			   " JOIN  {$this->tables['tcversions']} TCV ON NHA.id = TCV.id {$tcversion_exec_type['filter']} " .

    865. 

  865. 			   " {$executions['join']} " .

    866. 

  866. 			   " {$keywords['join']} " .

    867. 

  867. 			   " {$builds['join']} " .

    868. 

  868. 			   " LEFT OUTER JOIN {$this->tables['platforms']} PLAT ON PLAT.id = T.platform_id " .

    869. 

  869. 			   " LEFT OUTER JOIN {$this->tables['user_assignments']} UA ON UA.feature_id = T.id " .

    870. 

  870. 			   " {$ua_build_sql} " . // 3406

    871. 

  871. 			   " WHERE T.testplan_id={$id} {$keywords['filter']} {$tc_id['filter']} {$platforms['filter']}" .

    872. 

  872. 			   " AND (UA.type={$this->assignment_types['testcase_execution']['id']} OR UA.type IS NULL) " . 

    873. 

  873. 			   $executions['filter'];

    874. 

  874. 		

    875. 

  875. 		// 20081220 - franciscom

    876. 

  876. 		// if (!is_null($assigned_to) && $assigned_to > 0)

    877. 

  877. 		// {

    878. 

  878. 		//

    879. 

  879. 		// If special user id TL_USER_ANYBODY is present in set of user id,

    880. 

  880. 		// we will DO NOT FILTER by user ID

    881. 

  881. 		if( !is_null($my['filters']['assigned_to']) && 

    882. 

  882. 		    !in_array(TL_USER_ANYBODY,(array)$my['filters']['assigned_to']) )

    883. 

  883. 		{  

    884. 

  884. 			$sql .= " AND ";

    885. 

  885. 			

    886. 

  886. 			// Warning!!!:

    887. 

  887. 			// If special user id TL_USER_NOBODY is present in set of user id

    888. 

  888. 			// we will ignore any other user id present on set.

    889. 

  889. 			if( in_array(TL_USER_NOBODY,(array)$my['filters']['assigned_to']) )

    890. 

  890. 			{

    891. 

  891. 				$sql .= " UA.user_id IS NULL "; 

    892. 

  892. 			} 

    893. 

  893. 			// BUGID 2455

    894. 

  894.             // new user filter "somebody" --> all asigned testcases

    895. 

  895. 			else if( in_array(TL_USER_SOMEBODY,(array)$my['filters']['assigned_to']) )

    896. 

  896. 			{

    897. 

  897. 				$sql .= " UA.user_id IS NOT NULL "; 

    898. 

  898. 			}

    899. 

  899. 			else

    900. 

  900. 			{

    901. 

  901. 				$sql_unassigned="";

    902. 

  902. 				if( $my['options']['include_unassigned'] )

    903. 

  903. 				{

    904. 

  904. 					$sql .= "(";

    905. 

  905. 					$sql_unassigned=" OR UA.user_id IS NULL)";

    906. 

  906. 				}

    907. 

  907. 				// BUGID 2500

    908. 

  908. 				$sql .= " UA.user_id IN (" . implode(",",(array)$my['filters']['assigned_to']) . ") " . $sql_unassigned;

    909. 

  909. 			}

    910. 

  910. 		}

    911. 

  911. 		

    912. 

  912. 		if (!is_null($my['filters']['urgencyImportance']))

    913. 

  913. 		{

    914. 

  914. 			$urgencyImportanceCfg = config_get("urgencyImportance");

    915. 

  915. 			if ($my['filters']['urgencyImportance'] == HIGH)

    916. 

  916. 			{

    917. 

  917. 				$sql .= " AND (urgency * importance) >= " . $urgencyImportanceCfg->threshold['high'];

    918. 

  918. 			}

    919. 

  919. 			else if($my['filters']['urgencyImportance'] == LOW)

    920. 

  920. 			{

    921. 

  921. 				$sql .= " AND (urgency * importance) < " . $urgencyImportanceCfg->threshold['low'];

    922. 

  922. 			}

    923. 

  923. 			else

    924. 

  924. 			{

    925. 

  925. 				$sql .= " AND ( ((urgency * importance) >= " . $urgencyImportanceCfg->threshold['low'] . 

    926. 

  926. 					    " AND  ((urgency * importance) < " . $urgencyImportanceCfg->threshold['high']."))) ";

    927. 

  927. 			}		

    928. 

  928. 		}

    929. 

  929. 		

    930. 

  930. 		// test suites filter

    931. 

  931. 		if (!is_null($my['filters']['tsuites_id']))

    932. 

  932. 		{

    933. 

  933. 			$tsuiteSet = is_array($my['filters']['tsuites_id']) ? $my['filters']['tsuites_id'] : array($my['filters']['tsuites_id']);

    934. 

  934. 			$sql .= " AND NHB.parent_id IN (" . implode(',',$tsuiteSet) . ")";

    935. 

  935. 		}

    936. 

  936. 		$sql .= " ORDER BY testsuite_id,NHB.node_order,tc_id,platform_id,E.id ASC";

    937. 

  937. 

    938. 

  938.  		switch($my['options']['output'])

    939. 

  939. 		{ 

    940. 

  940. 			case 'array':

    941. 

  941. 			$recordset = $this->db->get_recordset($sql);

    942. 

  942. 			break;

    943. 

  943. 

    944. 

  944. 			case 'mapOfArray':

    945. 

  945. 			$recordset = $this->db->fetchRowsIntoMap($sql,'tc_id',database::CUMULATIVE);

    946. 

  946. 			break;

    947. 

  947. 			

    948. 

  948. 			case 'mapOfMap':

    949. 

  949. 			// with this option we got just one record for each (testcase,platform)

    950. 

  950. 			// no matter how many executions has been done

    951. 

  951. 			

    952. 

  952. 			$recordset = $this->db->fetchMapRowsIntoMap($sql,'tc_id','platform_id');

    953. 

  953. 			break;

    954. 

  954. 			

    955. 

  955. 			case 'mapOfMapExecPlatform':

    956. 

  956. 			// with this option we got just one record for each (platform, build)

    957. 

  957. 			

    958. 

  958. 			$recordset = $this->db->fetchMapRowsIntoMap($sql,'exec_id','platform_id');

    959. 

  959. 			break;

    960. 

  960. 			

    961. 

  961. 			case 'map':

    962. 

  962. 			default:

    963. 

  963. 			$recordset = $this->db->fetchRowsIntoMap($sql,'tc_id');

    964. 

  964. 			

    965. 

  965. 			// 20070913 - jbarchibald

    966. 

  966. 			// here we add functionality to filter out the custom field selections

    967. 

  967. 			//

    968. 

  968. 			// After addition of platform feature, this filtering can not be done

    969. 

  969. 			// always with original filter_cf_selection().

    970. 

  970. 			// Fisrt choice:

    971. 

  971. 			// Enable this feature only if recordset maintains original structured

    972. 

  972. 			//

    973. 

  973. 			if (!is_null($my['filters']['cf_hash'])) {

    974. 

  974. 				$recordset = $this->filter_cf_selection($recordset, $my['filters']['cf_hash']);

    975. 

  975. 			}

    976. 

  976. 			break;

    977. 

  977. 		}

    978. 

  978. 		

    979. 

  979.         // Multiple Test Case Steps Feature

    980. 

  980.         // added after Julian mail regarding perf problems building exec tree

    981. 

  981.         if( !is_null($recordset) && $my['options']['steps_info'])

    982. 

  982.         {

    983. 

  983. 		    $itemSet = array_keys($recordset);

    984. 

  984. 			switch($my['options']['output'])

    985. 

  985. 			{ 

    986. 

  986.         	

    987. 

  987. 				case 'mapOfArray':

    988. 

  988. 				case 'mapOfMap':

    989. 

  989. 	  				foreach($itemSet as $itemKey)

    990. 

  990. 	  				{

    991. 

  991. 	  					$keySet = array_keys($recordset[$itemKey]);

    992. 

  992. 	  					$target = &$recordset[$itemKey];

    993. 

  993. 	  					foreach($keySet as $accessKey)

    994. 

  994. 	  					{

    995. 

  995. 	  						$step_set = $this->tcase_mgr->get_steps($target[$accessKey]['tcversion_id']);

    996. 

  996. 	  						$target[$accessKey]['steps'] = $step_set;

    997. 

  997. 	  					}

    998. 

  998. 	  				}

    999. 

  999. 				break;

    1000. 

  1000. 				

    1001. 

  1001. 				case 'array':

    1002. 

  1002. 				case 'map':

    1003. 

  1003. 				default:

    1004. 

  1004.   					foreach($itemSet as $accessKey)

    1005. 

  1005.   					{

    1006. 

  1006. 	  					$step_set = $this->tcase_mgr->get_steps($recordset[$accessKey]['tcversion_id']);

    1007. 

  1007. 	  					$recordset[$accessKey]['steps'] = $step_set;

    1008. 

  1008. 	  				} 

    1009. 

  1009. 				break;

    1010. 

  1010. 			}

    1011. 

  1011.         }

    1012. 

  1012. 

    1013. 

  1013. 		

    1014. 

  1014. 		return $recordset;

    1015. 

  1015. 	}

    1016. 

  1016. 

    1017. 

  1017. 

    1018. 

  1018. /*

    1019. 

  1019.   function: get_linked_and_newest_tcversions

    1020. 

  1020.             returns for every test case in a test plan

    1021. 

  1021.             the tc version linked and the newest available version

    1022. 

  1022. 

    1023. 

  1023.   args: id: testplan id

    1024. 

  1024.         [tcase_id]: default null => all testcases linked to testplan

    1025. 

  1025. 

    1026. 

  1026.   returns: map key: testcase internal id

    1027. 

  1027.            values: map with following keys:

    1028. 

  1028. 

    1029. 

  1029.             [name]

    1030. 

  1030.             [tc_id] (internal id)

    1031. 

  1031.             [tcversion_id]

    1032. 

  1032.             [newest_tcversion_id]

    1033. 

  1033.             [tc_external_id]

    1034. 

  1034.             [version] (for humans)

    1035. 

  1035.             [newest_version] (for humans)

    1036. 

  1036. 

    1037. 

  1037.   rev:

    1038. 

  1038.       20080614 - franciscom - fixed bug on SQL generated while

    1039. 

  1039.                               adding tc_external_id on results.

    1040. 

  1040.       20080126 - franciscom - added tc_external_id on results

    1041. 

  1041. */

    1042. 

  1042. 	function get_linked_and_newest_tcversions($id,$tcase_id=null)

    1043. 

  1043. 	{

    1044. 

  1044. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    1045. 

  1045. 		

    1046. 

  1046. 		$tc_id_filter = " ";

    1047. 

  1047. 		if (!is_null($tcase_id) )

    1048. 

  1048. 		{

    1049. 

  1049. 			if( is_array($tcase_id) )

    1050. 

  1050. 			{

    1051. 

  1051. 				// ??? implement as in ?

    1052. 

  1052. 			}

    1053. 

  1053. 			else if ($tcase_id > 0 )

    1054. 

  1054. 			{

    1055. 

  1055. 				$tc_id_filter = " AND NHA.parent_id = {$tcase_id} ";

    1056. 

  1056. 			}

    1057. 

  1057. 		}

    1058. 

  1058. 		

    1059. 

  1059. 		// 20080614 - franciscom

    1060. 

  1060. 		// Peter Rooms found bug due to wrong SQL, accepted by MySQL but not by PostGres

    1061. 

  1061. 		// Missing column in GROUP BY Clause

    1062. 

  1062. 		

    1063. 

  1063. 		$sql = " SELECT MAX(NHB.id) AS newest_tcversion_id, " .

    1064. 

  1064. 			   " NHA.parent_id AS tc_id, NHC.name, T.tcversion_id AS tcversion_id," .

    1065. 

  1065. 			   " TCVA.tc_external_id AS tc_external_id, TCVA.version AS version " .

    1066. 

  1066. 			   " FROM {$this->tables['nodes_hierarchy']} NHA " .

    1067. 

  1067. 			

    1068. 

  1068. 			// NHA - will contain ONLY nodes of type testcase_version that are LINKED to test plan

    1069. 

  1069. 			" JOIN {$this->tables['testplan_tcversions']} T ON NHA.id = T.tcversion_id " . 

    1070. 

  1070. 			

    1071. 

  1071. 			// Get testcase_version data for LINKED VERSIONS

    1072. 

  1072. 			" JOIN {$this->tables['tcversions']} TCVA ON TCVA.id = T.tcversion_id" .

    1073. 

  1073. 			

    1074. 

  1074. 			// Work on Sibblings - Start

    1075. 

  1075. 			// NHB - Needed to get ALL testcase_version sibblings nodes

    1076. 

  1076. 			" JOIN {$this->tables['nodes_hierarchy']} NHB ON NHB.parent_id = NHA.parent_id " .

    1077. 

  1077. 			

    1078. 

  1078. 			// Want only ACTIVE Sibblings

    1079. 

  1079. 			" JOIN {$this->tables['tcversions']} TCVB ON TCVB.id = NHB.id AND TCVB.active=1 " . 

    1080. 

  1080. 			// Work on Sibblings - STOP 

    1081. 

  1081. 			

    1082. 

  1082. 			// NHC will contain - nodes of type TESTCASE (parent of testcase versions we are working on)

    1083. 

  1083. 			// we use NHC to get testcase NAME ( testcase version nodes have EMPTY NAME)

    1084. 

  1084. 			" JOIN {$this->tables['nodes_hierarchy']} NHC ON NHC.id = NHA.parent_id " .

    1085. 

  1085. 			

    1086. 

  1086. 			// Want to get only testcase version with id (NHB.id) greater than linked one (NHA.id)

    1087. 

  1087. 			" WHERE T.testplan_id={$id} AND NHB.id > NHA.id" . $tc_id_filter .

    1088. 

  1088. 			" GROUP BY NHA.parent_id, NHC.name, T.tcversion_id, TCVA.tc_external_id, TCVA.version  ";

    1089. 

  1089. 		

    1090. 

  1090. 		$sql2 = " SELECT SUBQ.name, SUBQ.newest_tcversion_id, SUBQ.tc_id, " .

    1091. 

  1091. 			    " SUBQ.tcversion_id, SUBQ.version, SUBQ.tc_external_id, " .

    1092. 

  1092. 			    " TCV.version AS newest_version " .

    1093. 

  1093. 			    " FROM {$this->tables['tcversions']} TCV, ( $sql ) AS SUBQ " .

    1094. 

  1094. 			    " WHERE SUBQ.newest_tcversion_id = TCV.id " .

    1095. 

  1095. 			    " ORDER BY SUBQ.tc_id ";

    1096. 

  1096. 		

    1097. 

  1097. 		return $this->db->fetchRowsIntoMap($sql2,'tc_id');

    1098. 

  1098. 	}

    1099. 

  1099. 

    1100. 

  1100. 

    1101. 

  1101. 	/**

    1102. 

  1102. 	 * Remove of records from user_assignments table

    1103. 

  1103. 	 * @author franciscom

    1104. 

  1104. 	 * 

    1105. 

  1105. 	 * @param integer $id   : test plan id

    1106. 

  1106. 	 * @param array $items: assoc array key=tc_id value=tcversion_id

    1107. 

  1107. 	 * 

    1108. 

  1108. 	 * @internal revisions:

    1109. 

  1109. 	 *    20100725 - asimon - BUGID 3497 and hopefully also 3530

    1110. 

  1110. 	 */

    1111. 

  1111. 	function unlink_tcversions($id,&$items)

    1112. 

  1112. 	{

    1113. 

  1113. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    1114. 

  1114. 		if(is_null($items))

    1115. 

  1115. 		{

    1116. 

  1116. 			return;

    1117. 

  1117. 		}

    1118. 

  1118. 		

    1119. 

  1119. 		// Get human readeable info for audit

    1120. 

  1120. 		$gui_cfg = config_get('gui');

    1121. 

  1121. 		$title_separator = config_get('gui_title_separator_1');

    1122. 

  1122. 		$auditInfo=$this->tcversionInfoForAudit($id,$items['tcversion']);

    1123. 

  1123. 		$platformInfo = $this->platform_mgr->getLinkedToTestplanAsMap($id);

    1124. 

  1124. 		$platformLabel = lang_get('platform');

    1125. 

  1125. 

    1126. 

  1126.         $dummy = null;

    1127. 

  1127. 		foreach($items['items'] as $tcase_id => $elem) 

    1128. 

  1128. 		{

    1129. 

  1129. 			foreach($elem as $platform_id => $tcversion_id) 

    1130. 

  1130. 			{

    1131. 

  1131. 				$dummy[] = "(tcversion_id = {$tcversion_id} AND platform_id = {$platform_id})";

    1132. 

  1132. 			}

    1133. 

  1133. 		}

    1134. 

  1134. 		$where_clause = implode(" OR ", $dummy);

    1135. 

  1135. 		

    1136. 

  1136. 		/*

    1137. 

  1137. 		 * asimon - BUGID 3497 and hopefully also 3530

    1138. 

  1138. 		 * A very litte error, missing braces in the $where_clause, was causing this bug. 

    1139. 

  1139. 		 * When one set of testcases is linked to two testplans, this statement should check 

    1140. 

  1140. 		 * that the combination of testplan_id, tcversion_id and platform_id was the same, 

    1141. 

  1141. 		 * but instead it checked for either testplan_id OR tcversion_id and platform_id.

    1142. 

  1142. 		 * So every linked testcase with fitting tcversion_id and platform_id without execution

    1143. 

  1143. 		 * was deleted, regardless of testplan_id.

    1144. 

  1144. 		 * Simply adding braces around the where clause solves this.

    1145. 

  1145. 		 * So innstead of: 

    1146. 

  1146. 		 * SELECT id AS link_id FROM testplan_tcversions  

    1147. 

  1147. 		 * WHERE testplan_id=12 AND (tcversion_id = 5 AND platform_id = 0) 

    1148. 

  1148. 		 * OR (tcversion_id = 7 AND platform_id = 0) 

    1149. 

  1149. 		 * OR (tcversion_id = 9 AND platform_id = 0) 

    1150. 

  1150. 		 * OR (tcversion_id = 11 AND platform_id = 0)

    1151. 

  1151. 		 * we need this:

    1152. 

  1152. 		 * SELECT ... WHERE testplan_id=12 AND (... OR ...)

    1153. 

  1153. 		 */ 

    1154. 

  1154. 		$where_clause = " ( {$where_clause} ) ";

    1155. 

  1155. 		

    1156. 

  1156. 		// First get the executions id if any exist

    1157. 

  1157. 		$sql=" SELECT id AS execution_id " .

    1158. 

  1158. 			 " FROM {$this->tables['executions']} " .

    1159. 

  1159. 			 " WHERE testplan_id = {$id} AND ${where_clause}";

    1160. 

  1160. 		$exec_ids = $this->db->fetchRowsIntoMap($sql,'execution_id');

    1161. 

  1161. 		

    1162. 

  1162. 		if( !is_null($exec_ids) and count($exec_ids) > 0 )

    1163. 

  1163. 		{

    1164. 

  1164. 			// has executions

    1165. 

  1165. 			$exec_ids = array_keys($exec_ids);

    1166. 

  1166. 			$exec_id_where= " WHERE execution_id IN (" . implode(",",$exec_ids) . ")";

    1167. 

  1167. 			

    1168. 

  1168. 			// Remove bugs if any exist

    1169. 

  1169. 			$sql=" DELETE FROM {$this->tables['execution_bugs']} {$exec_id_where} ";

    1170. 

  1170. 			$result = $this->db->exec_query($sql);

    1171. 

  1171. 			

    1172. 

  1172. 			// now remove executions

    1173. 

  1173. 			$sql=" DELETE FROM {$this->tables['executions']} " .

    1174. 

  1174. 				 " WHERE testplan_id = {$id} AND ${where_clause}";

    1175. 

  1175. 			$result = $this->db->exec_query($sql);

    1176. 

  1176. 		}

    1177. 

  1177. 		

    1178. 

  1178. 		// ----------------------------------------------------------------

    1179. 

  1179. 		// to remove the assignment to users (if any exists) we need the list of id

    1180. 

  1180. 		$sql=" SELECT id AS link_id FROM {$this->tables['testplan_tcversions']} " .

    1181. 

  1181. 			 " WHERE testplan_id={$id} AND {$where_clause} ";

    1182. 

  1182. 		$link_ids = $this->db->fetchRowsIntoMap($sql,'link_id');

    1183. 

  1183. 		$features = array_keys($link_ids);

    1184. 

  1184. 		if( count($features) == 1)

    1185. 

  1185. 		{

    1186. 

  1186. 			$features=$features[0];

    1187. 

  1187. 		}

    1188. 

  1188. 		$this->assignment_mgr->delete_by_feature_id($features);

    1189. 

  1189. 		// ----------------------------------------------------------------

    1190. 

  1190. 		

    1191. 

  1191. 		// Delete from link table

    1192. 

  1192. 		$sql=" DELETE FROM {$this->tables['testplan_tcversions']} " .

    1193. 

  1193. 			 " WHERE testplan_id={$id} AND {$where_clause} ";

    1194. 

  1194. 		$result = $this->db->exec_query($sql);

    1195. 

  1195. 		

    1196. 

  1196. 		foreach($items['items'] as $tcase_id => $elem)

    1197. 

  1197. 		{

    1198. 

  1198. 			foreach($elem as $platform_id => $tcversion)

    1199. 

  1199. 			{

    1200. 

  1200. 				$addInfo='';

    1201. 

  1201. 				if( isset($platformInfo[$platform_id]) )

    1202. 

  1202. 				{

    1203. 

  1203. 					$addInfo = ' - ' . $platformLabel . ':' . $platformInfo[$platform_id];

    1204. 

  1204. 				}

    1205. 

  1205. 				$auditMsg=TLS("audit_tc_removed_from_testplan",

    1206. 

  1206. 							  $auditInfo['tcasePrefix'] . $auditInfo['info'][$tcversion]['tc_external_id'] . 

    1207. 

  1207. 							  $title_separator . $auditInfo['info'][$tcversion]['name'],

    1208. 

  1208. 							  $auditInfo['info'][$tcversion]['version'],

    1209. 

  1209. 							  $auditInfo['tplanInfo']['name'] . $addInfo );

    1210. 

  1210. 				

    1211. 

  1211. 				logAuditEvent($auditMsg,"UNASSIGN",$id,"testplans");

    1212. 

  1212. 			}

    1213. 

  1213. 		}

    1214. 

  1214. 		

    1215. 

  1215. 	} // end function unlink_tcversions

    1216. 

  1216. 

    1217. 

  1217. 

    1218. 

  1218. 

    1219. 

  1219. 	/**

    1220. 

  1220. 	 * 

    1221. 

  1221. 	 * @internal revisions

    1222. 

  1222. 	 * 20100505 - franciscom - BUGID 3434

    1223. 

  1223. 	 */

    1224. 

  1224. 	function get_keywords_map($id,$order_by_clause='')

    1225. 

  1225. 	{

    1226. 

  1226. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    1227. 

  1227. 		$map_keywords=null;

    1228. 

  1228. 		

    1229. 

  1229. 		// keywords are associated to testcase id, then first

    1230. 

  1230. 		// we need to get the list of testcases linked to the testplan

    1231. 

  1231. 		// 

    1232. 

  1232. 		// 20100505 - according to user report (BUGID 3434) seems that 

    1233. 

  1233. 		// $linked_items = $this->get_linked_tcversions($id);

    1234. 

  1234. 		// has performance problems.

    1235. 

  1235. 		// Then make a choice do simple query here.

    1236. 

  1236. 		//

    1237. 

  1237. 		$sql = " /* $debugMsg */ ". 

    1238. 

  1238. 			   " SELECT DISTINCT parent_id FROM {$this->tables['nodes_hierarchy']} NHTC " .

    1239. 

  1239. 			   " JOIN {$this->tables['testplan_tcversions']} TPTCV ON TPTCV.tcversion_id = NHTC.id " .

    1240. 

  1240. 			   " WHERE TPTCV.testplan_id = {$id} ";

    1241. 

  1241. 			   

    1242. 

  1242. 		$linked_items = $this->db->fetchRowsIntoMap($sql,'parent_id');			     

    1243. 

  1243. 		

    1244. 

  1244. 		if( !is_null($linked_items) )

    1245. 

  1245. 		{

    1246. 

  1246. 			$tc_id_list = implode(",",array_keys($linked_items));

    1247. 

  1247. 			

    1248. 

  1248. 			$sql = " /* $debugMsg */ " .

    1249. 

  1249. 				   " SELECT DISTINCT TCKW.keyword_id,KW.keyword " .

    1250. 

  1250. 				   " FROM {$this->tables['testcase_keywords']} TCKW, " .

    1251. 

  1251. 				   " {$this->tables['keywords']} KW " .

    1252. 

  1252. 				   " WHERE TCKW.keyword_id = KW.id " .

    1253. 

  1253. 				   " AND TCKW.testcase_id IN ( {$tc_id_list} ) " .

    1254. 

  1254. 				   " {$order_by_clause} ";

    1255. 

  1255. 			$map_keywords = $this->db->fetchColumnsIntoMap($sql,'keyword_id','keyword');

    1256. 

  1256. 		}

    1257. 

  1257. 		return ($map_keywords);

    1258. 

  1258. 	}

    1259. 

  1259. 	

    1260. 

  1260. 

    1261. 

  1261. /*

    1262. 

  1262.   args :

    1263. 

  1263.         [$keyword_id]: can be an array

    1264. 

  1264. */

    1265. 

  1265. 	function get_keywords_tcases($id,$keyword_id=0)

    1266. 

  1266. 	{

    1267. 

  1267. 		$debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;

    1268. 

  1268. 

    1269. 

  1269. 		$CUMULATIVE=1;

    1270. 

  1270. 		$map_keywords=null;

    1271. 

  1271. 		

    1272. 

  1272. 		// keywords are associated to testcase id, then first

    1273. 

  1273. 		// we need to get the list of testcases linked to the testplan

    1274. 

  1274. 		$linked_items = $this->get_linked_items_id($id);

    1275. 

  1275. 		if( !is_null($linked_items) )

    1276. 

  1276. 		{

    1277. 

  1277. 			$keyword_filter= '' ;

    1278. 

  1278. 			

    1279. 

  1279. 			if( is_array($keyword_id) )

    1280. 

  1280. 			{

    1281. 

  1281. 				$keyword_filter = " AND keyword_id IN (" . implode(',',$keyword_id) . ")"; 

    1282. 

  1282. 			}

    1283. 

  1283. 			else if( $keyword_id > 0 )

    1284. 

  1284. 			{

    1285. 

  1285. 				$keyword_filter = " AND keyword_id = {$keyword_id} ";

    1286. 

  1286. 			}

    1287. 

  1287. 			

    1288. 

  1288. 			

    1289. 

  1289. 			$tc_id_list = implode(",",array_keys($linked_items));

    1290. 

  1290. 			

    1291. 

  1291. 			// 20081116 - franciscom -

    1292. 

  1292. 			// Does DISTINCT is needed ? Humm now I think no.

    1293. 

  1293. 			$sql = "SELECT DISTINCT testcase_id,keyword_id,keyword

    1294. 

  1294. 				FROM {$this->tables['testcase_keywords']} testcase_keywords,

    1295. 

  1295. 				{$this->tables['keywords']} keywords

    1296. 

  1296. 				WHERE keyword_id = keywords.id

    1297. 

  1297. 				AND testcase_id IN ( {$tc_id_list} )

    1298. 

  1298. 				{$keyword_filter}

    1299. 

  1299. 				ORDER BY keyword ASC ";

    1300. 

  1300. 			

    1301. 

  1301. 			// 20081116 - francis…
    1302.

Large files files are truncated, but you can click here to view the full file