PageRenderTime 39ms CodeModel.GetById 1ms RepoModel.GetById 0ms app.codeStats 0ms

/lib/functions/treeMenu.inc.php

https://bitbucket.org/pfernandez/testlink1.9.6
PHP | 2261 lines | 1381 code | 319 blank | 561 comment | 218 complexity | a498daec9acd3fa114f8e86d6dcd8d56 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.  * This file generates tree menu for test specification and test execution.

    7. 

  7.  * 

    8. 

  8.  * @package 	TestLink

    9. 

  9.  * @author 		Martin Havlat

    10. 

  10.  * @copyright 	2005-2009, TestLink community 

    11. 

  11.  * @version    	CVS: $Id: treeMenu.inc.php,v 1.144 2010/08/21 13:38:25 asimon83 Exp $

    12. 

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

    13. 

  13.  * @uses 		config.inc.php

    14. 

  14.  *

    15. 

  15.  * @internal Revisions:

    16. 

  16.  *  20100820 - asimon - refactoring for less redundant checks and better readibility of code

    17. 

  17.  *                      in generateExecTree()

    18. 

  18.  *	20100812 - franciscom - get_filtered_req_map() - BUGID 3671

    19. 

  19.  *  20100810 - asimon - added filtering by TC ID on prepareNode() and generateTestSpecTree()

    20. 

  20.  *  20100808 - asimon - generate_reqspec_tree() implemented to generate statically filtered

    21. 

  21.  *                      requirement specification tree, plus additional functions

    22. 

  22.  *                      get_filtered_req_map(), prepare_reqspec_treenode(),

    23. 

  23.  *                      render_reqspec_treenode()

    24. 

  24.  *  20100702 - asimon - fixed custom field filtering problem caused by 

    25. 

  25.  *                      wrong array indexes and little logic errors

    26. 

  26.  *  20100701 - asimon - replaced is_null in renderTreeNode() by !isset 

    27. 

  27.  *                      because of warnings in event log

    28. 

  28.  *  20100701 - asimon - added some additional isset() checks to avoid warnings

    29. 

  29.  *  20100628 - asimon - removal of constants from filter control class

    30. 

  30.  *  20160625 - asimon - refactoring for new filter features and BUGID 3516

    31. 

  31.  *  20100624 - asimon - CVS merge (experimental branch to HEAD)

    32. 

  32.  *  20100622 - asimon - refactoring of following functions for new filter classes:

    33. 

  33.  *                      generateExecTree, renderExecTreeNode(), prepareNode(), 

    34. 

  34.  *                      generateTestSpecTree, renderTreeNode(), filter_by_*()

    35. 

  35.  *	20100611 - franciscom - renderExecTreeNode(), renderTreeNode() interface changes

    36. 

  36.  *							generateExecTree() - interface changes and output changes

    37. 

  37.  *  20100602 - franciscom - extjs_renderExecTreeNodeOnOpen() - added 'tlNodeType' 	

    38. 

  38.  *  20100428 - asimon - BUGID 3301 and related: 

    39. 

  39.  *                      added filtering by custom fields to generateTestSpecTree(),

    40. 

  40.  *                      added importance setting in prepareNode() because of 

    41. 

  41.  *                      "undefined" error in event log,

    42. 

  42.  *                      added function filter_by_cfield_values() 

    43. 

  43.  *                      which is used from generateTestSpecTree()

    44. 

  44.  *	20100417 - franciscom - BUGID 2498 - spec tree  - filter by test case spec importance

    45. 

  45.  *	20100417 - franciscom - BUGID 3380 - execution tree - filter by test case execution type

    46. 

  46.  *	20100415 - franciscom - BUGID 2797 - filter by test case execution type

    47. 

  47.  *	20100202 - asimon - changes for filtering, BUGID 2455, BUGID 3026

    48. 

  48.  *						added filter_by_* - functions, changed generateExecTree()

    49. 

  49.  *	20091212 - franciscom - prepareNode(), generateTestSpecTree() interface changes

    50. 

  50.  *                          added logic to do filtering on test spec for execution type

    51. 

  51.  *

    52. 

  52.  *	20090815 - franciscom - get_last_execution() call changes

    53. 

  53.  *  20090801 - franciscom - table prefix missed

    54. 

  54.  *	20090716 - franciscom - BUGID 2692

    55. 

  55.  * 	20090328 - franciscom - BUGID 2299 - introduced on 20090308.

    56. 

  56.  *                          Added logic to remove Empty Top level test suites 

    57. 

  57.  *                          (have neither test cases nor test suites inside) when applying 

    58. 

  58.  *                          test case keyword filtering.

    59. 

  59.  *                          BUGID 2296

    60. 

  60.  *  20090308 - franciscom - generateTestSpecTree() - changes for EXTJS tree

    61. 

  61.  *  20090211 - franciscom - BUGID 2094 

    62. 

  62.  *  20090202 - franciscom - minor changes to avoid BUGID 2009

    63. 

  63.  *  20090118 - franciscom - replaced multiple calls config_get('testcase_cfg')

    64. 

  64.  *                          added extjs_renderTestSpecTreeNodeOnOpen(), to allow filtering 

    65. 

  65.  *

    66. 

  66.  */

    67. 

  67. require_once(dirname(__FILE__)."/../../third_party/dBug/dBug.php");

    68. 

  68. 

    69. 

  69. /**

    70. 

  70. *	strip potential newlines and other unwanted chars from strings

    71. 

  71. *	Mainly for stripping out newlines, carriage returns, and quotes that were 

    72. 

  72. *	causing problems in javascript using jtree

    73. 

  73. *

    74. 

  74. *	@param string $str

    75. 

  75. *	@return string string with the newlines removed

    76. 

  76. */

    77. 

  77. function filterString($str)

    78. 

  78. {

    79. 

  79. 	$str = str_replace(array("\n","\r"), array("",""), $str);

    80. 

  80. 	$str = addslashes($str);

    81. 

  81. 	$str = htmlspecialchars($str, ENT_QUOTES);	

    82. 

  82. 	

    83. 

  83. 	return $str;

    84. 

  84. }

    85. 

  85. 

    86. 

  86. /** 

    87. 

  87.  * generate data for tree menu of Test Specification

    88. 

  88.  *

    89. 

  89.  * @param boolean $ignore_inactive_testcases if all test case versions are inactive, 

    90. 

  90.  *                            the test case will ignored.

    91. 

  91.  * @param array $exclude_branches map key=node_id

    92. 

  92.  * 

    93. 

  93.  * @internal Revisions:

    94. 

  94.  * 20100810 - asimon - filtering by testcase ID

    95. 

  95.  * 20100428 - asimon - BUGID 3301, added filtering by custom fields

    96. 

  96.  * 20090328 - franciscom - BUGID 2299, that was generated during 20090308 

    97. 

  97.  *                         trying to fix another not reported bug.

    98. 

  98.  * 20090308 - franciscom - changed arguments in str_ireplace() call

    99. 

  99.  *                         Due to bug in Test Spec tree when using Keywords filter

    100. 

  100.  * 20080501 - franciscom - keyword_id can be an array

    101. 

  101.  * 20071014 - franciscom - $bForPrinting

    102. 

  102.  *                         used to choose Javascript function 

    103. 

  103.  *                         to call when clicking on a tree node

    104. 

  104.  * 20070922 - franciscom - interface changes added $tplan_id,

    105. 

  105.  * 20070217 - franciscom - added $exclude_branches

    106. 

  106.  * 20061105 - franciscom - added $ignore_inactive_testcases

    107. 

  107.  */

    108. 

  108.  

    109. 

  109.  

    110. 

  110. function generateTestSpecTree(&$db,$tproject_id, $tproject_name,$linkto,$filters=null,$options=null)

    111. 

  111. {

    112. 

  112. 	$tables = tlObjectWithDB::getDBTables(array('tcversions','nodes_hierarchy'));

    113. 

  113. 

    114. 

  114. 	$my = array();

    115. 

  115. 	

    116. 

  116. 	// 20100412 - franciscom

    117. 

  117. 	// $my['options'] = array('forPrinting' => 0, 'hideTestCases' => 0,'getArguments' => '', 

    118. 

  118. 	//                        'tc_action_enabled' => 1, 'ignore_inactive_testcases' => 0, 

    119. 

  119. 	//                        'exclude_branches' => null, 'viewType' => 'testSpecTree');

    120. 

  120. //	$my['options'] = array('forPrinting' => 0, 'hideTestCases' => 0, 

    121. 

  121. //	                       'tc_action_enabled' => 1, 'ignore_inactive_testcases' => 0, 

    122. 

  122. //	                       'exclude_branches' => null, 'viewType' => 'testSpecTree');

    123. 

  123. 	$my['options'] = array('forPrinting' => 0, 'hideTestCases' => 0, 

    124. 

  124. 	                       'tc_action_enabled' => 1, 'ignore_inactive_testcases' => 0, 

    125. 

  125. 	                       'viewType' => 'testSpecTree');

    126. 

  126. 	

    127. 

  127. 

    128. 

  128. 	// 20100412 - franciscom

    129. 

  129. 	// testplan => only used if opetions['viewType'] == 'testSpecTreeForTestPlan'

    130. 

  130. 	// 20100417 - franciscom - BUGID 2498

    131. 

  131. 	$my['filters'] = array('keywords' => null, 'executionType' => null, 'importance' => null,

    132. 

  132. 	                       'testplan' => null, 'filter_tc_id' => null);

    133. 

  133. 

    134. 

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

    135. 

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

    136. 

  136. 	

    137. 

  137. 	$treeMenu = new stdClass(); 

    138. 

  138. 	$treeMenu->rootnode = null;

    139. 

  139. 	$treeMenu->menustring = '';

    140. 

  140. 	

    141. 

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

    142. 

  142. 	$showTestCaseID = config_get('treemenu_show_testcase_id');

    143. 

  143. 	$glueChar = config_get('testcase_cfg')->glue_character;

    144. 

  144. 	$menustring = null;

    145. 

  145. 	

    146. 

  146. 	$tproject_mgr = new testproject($db);

    147. 

  147. 	$tree_manager = &$tproject_mgr->tree_manager;	

    148. 

  148. 	

    149. 

  149. 	$tcase_node_type = $tree_manager->node_descr_id['testcase'];

    150. 

  150. 	// BUGID 3301

    151. 

  151. 	$tsuite_node_type = $tree_manager->node_descr_id['testsuite'];

    152. 

  152. 	$hash_descr_id = $tree_manager->get_available_node_types();

    153. 

  153. 	$hash_id_descr = array_flip($hash_descr_id);

    154. 

  154. 	$status_descr_code=$resultsCfg['status_code'];

    155. 

  155. 	$status_code_descr=$resultsCfg['code_status'];

    156. 

  156. 	

    157. 

  157. 	$decoding_hash=array('node_id_descr' => $hash_id_descr,

    158. 

  158. 		                 'status_descr_code' =>  $status_descr_code,

    159. 

  159. 		                 'status_code_descr' =>  $status_code_descr);

    160. 

  160. 	

    161. 

  161. 	$exclude_branches = isset($filters['filter_toplevel_testsuite'])

    162. 

  162. 	                    && is_array($filters['filter_toplevel_testsuite']) ?

    163. 

  163. 	                    $filters['filter_toplevel_testsuite'] : null;

    164. 

  164. 	

    165. 

  165. 	$tcase_prefix=$tproject_mgr->getTestCasePrefix($tproject_id) . $glueChar;

    166. 

  166. 	$test_spec = $tproject_mgr->get_subtree($tproject_id,testproject::RECURSIVE_MODE,

    167. 

  167. 		                                    testproject::INCLUDE_TESTCASES, $exclude_branches);

    168. 

  168. 	

    169. 

  169. 	// Added root node for test specification -> testproject

    170. 

  170. 	$test_spec['name'] = $tproject_name;

    171. 

  171. 	$test_spec['id'] = $tproject_id;

    172. 

  172. 	$test_spec['node_type_id'] = $hash_descr_id['testproject'];

    173. 

  173. 	

    174. 

  174. 	$map_node_tccount=array();

    175. 

  175. 	$tplan_tcs=null;

    176. 

  176. 	

    177. 

  177. 	DEFINE('DONT_FILTER_BY_TESTER',0);

    178. 

  178. 	DEFINE('DONT_FILTER_BY_EXEC_STATUS',null);

    179. 

  179. 	

    180. 

  180. 	if($test_spec)

    181. 

  181. 	{

    182. 

  182. 		$tck_map = null;  // means no filter

    183. 

  183. 		if(!is_null($my['filters']['filter_keywords']))

    184. 

  184. 		{

    185. 

  185. 			//$tck_map = $tproject_mgr->get_keywords_tcases($tproject_id,$my['filters']['keywords']->items,

    186. 

  186. 			//                                              $my['filters']['keywords']->type);

    187. 

  187. 			$tck_map = $tproject_mgr->get_keywords_tcases($tproject_id,

    188. 

  188. 			           $my['filters']['filter_keywords'],

    189. 

  189. 			           $my['filters']['filter_keywords_filter_type']);

    190. 

  190. 			if( is_null($tck_map) )

    191. 

  191. 			{

    192. 

  192. 				$tck_map=array();  // means filter everything

    193. 

  193. 			}

    194. 

  194. 		}

    195. 

  195. 		

    196. 

  196. 		// Important: prepareNode() will make changes to $test_spec like filtering by test case 

    197. 

  197. 		// keywords using $tck_map;

    198. 

  198. 		$pnFilters = null;

    199. 

  199. 	    

    200. 

  200. //		$pnFilters['filter_testcase_name'] = 

    201. 

  201. //			isset($my['filters']['filter_testcase_name']) ?

    202. 

  202. //			$my['filters']['filter_testcase_name'] : null;

    203. 

  203. //		

    204. 

  204. //		$pnFilters['filter_execution_type'] = 

    205. 

  205. //			isset($my['filters']['filter_execution_type']) ?

    206. 

  206. //			$my['filters']['filter_execution_type'] : null;

    207. 

  207. //		

    208. 

  208. //		$pnFilters['filter_priority'] = 

    209. 

  209. //			isset($my['filters']['filter_priority']) ?

    210. 

  210. //			$my['filters']['filter_priority'] : null;

    211. 

  211. 		

    212. 

  212. 		$keys2init = array('filter_testcase_name',

    213. 

  213. 		                   'filter_execution_type',

    214. 

  214. 		                   'filter_priority',

    215. 

  215. 		                   'filter_tc_id');

    216. 

  216. 		

    217. 

  217. 		foreach ($keys2init as $keyname) {

    218. 

  218. 			$pnFilters[$keyname] = isset($my['filters'][$keyname]) ? $my['filters'][$keyname] : null;

    219. 

  219. 		}

    220. 

  220. 	    

    221. 

  221. 	    $pnFilters['setting_testplan'] = 

    222. 

  222. 	    	$my['filters']['setting_testplan'];

    223. 

  223. 	    

    224. 

  224. 	    // BUGID 3301 - added filtering by custom field values

    225. 

  225. 	    if (isset($my['filters']['filter_custom_fields']) 

    226. 

  226. 	    && isset($test_spec['childNodes'])) {

    227. 

  227. 	    	

    228. 

  228. 	    	$test_spec['childNodes'] = filter_by_cf_values($test_spec['childNodes'], 

    229. 

  229. 			                           $my['filters']['filter_custom_fields'], 

    230. 

  230. 			                           $db, $tsuite_node_type, $tcase_node_type);

    231. 

  231. 	    }

    232. 

  232. 		

    233. 

  233. 	    // 20100412 - franciscom

    234. 

  234. 	    $pnOptions = array('hideTestCases' => $my['options']['hideTestCases'], 

    235. 

  235. 	    				   'viewType' => $my['options']['viewType'],	

    236. 

  236. 		                   'ignoreInactiveTestCases' => $my['options']['ignore_inactive_testcases']);

    237. 

  237. 		

    238. 

  238. 		$testcase_counters = prepareNode($db,$test_spec,$decoding_hash,$map_node_tccount,$tck_map,

    239. 

  239. 			                             $tplan_tcs,$pnFilters,$pnOptions);

    240. 

  240. 

    241. 

  241. 		foreach($testcase_counters as $key => $value)

    242. 

  242. 		{

    243. 

  243. 			$test_spec[$key]=$testcase_counters[$key];

    244. 

  244. 		}

    245. 

  245. 		

    246. 

  246. 		$menustring = renderTreeNode(1,$test_spec,$hash_id_descr,

    247. 

  247. 			                         $my['options']['tc_action_enabled'],$linkto,$tcase_prefix,

    248. 

  248. 			                         $my['options']['forPrinting'],$showTestCaseID);

    249. 

  249. 	}

    250. 

  250. 	

    251. 

  251. 	$menustring ='';

    252. 

  252. 	$treeMenu->rootnode = new stdClass();

    253. 

  253. 	$treeMenu->rootnode->name = $test_spec['text'];

    254. 

  254. 	$treeMenu->rootnode->id = $test_spec['id'];

    255. 

  255. 	$treeMenu->rootnode->leaf = isset($test_spec['leaf']) ? $test_spec['leaf'] : false;

    256. 

  256. 	$treeMenu->rootnode->text = $test_spec['text'];

    257. 

  257. 	$treeMenu->rootnode->position = $test_spec['position'];	    

    258. 

  258. 	$treeMenu->rootnode->href = $test_spec['href'];

    259. 

  259. 	

    260. 

  260. 	

    261. 

  261. 	// Change key ('childNodes')  to the one required by Ext JS tree.

    262. 

  262. 	if(isset($test_spec['childNodes']))

    263. 

  263. 	{

    264. 

  264. 		$menustring = str_ireplace('childNodes', 'children', json_encode($test_spec['childNodes'])); 

    265. 

  265. 	}

    266. 

  266. 	// 20090328 - franciscom - BUGID 2299

    267. 

  267. 	// More details about problem found on 20090308 and fixed IN WRONG WAY

    268. 

  268. 	// TPROJECT

    269. 

  269. 	//    |______ TSA

    270. 

  270. 	//            |__ TC1

    271. 

  271. 	//            |__ TC2

    272. 

  272. 	//    | 

    273. 

  273. 	//    |______ TSB

    274. 

  274. 	//            |______ TSC

    275. 

  275. 	// 

    276. 

  276. 	// Define Keyword K1,K2

    277. 

  277. 	//

    278. 

  278. 	// NO TEST CASE HAS KEYWORD ASSIGNED

    279. 

  279. 	// Filter by K1

    280. 

  280. 	// Tree will show root that spins Forever

    281. 

  281. 	// menustring before str_ireplace : [null,null]

    282. 

  282. 	// menustring AFTER [null] 

    283. 

  283. 	//

    284. 

  284. 	// Now fixed.

    285. 

  285. 	//

    286. 

  286. 	// Some minor fix to do

    287. 

  287. 	// Il would be important exclude Top Level Test suites.

    288. 

  288. 	// 

    289. 

  289. 	// 

    290. 

  290. 	// 20090308 - franciscom

    291. 

  291. 	// Changed because found problem on:

    292. 

  292. 	// Test Specification tree when applying Keyword filter using a keyword NOT PRESENT

    293. 

  293. 	// in test cases => Tree root shows loading icon and spin never stops.

    294. 

  294. 	//

    295. 

  295. 	// Attention: do not know if in other situation this will generate a different bug

    296. 

  296. 	// 

    297. 

  297. 	if(!is_null($menustring))

    298. 

  298. 	{

    299. 

  299. 		// Remove null elements (Ext JS tree do not like it ).

    300. 

  300. 		// :null happens on -> "children":null,"text" that must become "children":[],"text"

    301. 

  301. 		// $menustring = str_ireplace(array(':null',',null','null,'),array(':[]','',''), $menustring); 

    302. 

  302. 		$menustring = str_ireplace(array(':null',',null','null,','null'),array(':[]','','',''), $menustring); 

    303. 

  303. 	}

    304. 

  304. 	$treeMenu->menustring = $menustring; 

    305. 

  305. 	

    306. 

  306. 	return $treeMenu;

    307. 

  307. }

    308. 

  308. 

    309. 

  309. 

    310. 

  310. /**

    311. 

  311.  * Prepares a Node to be displayed in a navigation tree.

    312. 

  312.  * This function is used in the construction of:

    313. 

  313.  *  - Test project specification -> we want ALL test cases defined in test project.

    314. 

  314.  *  - Test execution             -> we only want the test cases linked to a test plan.

    315. 

  315.  * 

    316. 

  316.  * IMPORTANT:

    317. 

  317.  * when analising a container node (Test Suite) if it is empty and we have requested

    318. 

  318.  * some sort of filtering NODE WILL BE PRUNED.

    319. 

  319.  *

    320. 

  320.  *

    321. 

  321.  * status: one of the possible execution status of a test case.

    322. 

  322.  *

    323. 

  323.  *

    324. 

  324.  * tplan_tcases: map with testcase versions linked to test plan. 

    325. 

  325.  *               due to the multiples uses of this function, null has to meanings

    326. 

  326.  *

    327. 

  327.  *         		 When we want to build a Test Project specification tree,

    328. 

  328.  *         		 WE SET it to NULL, because we are not interested in a test plan.

    329. 

  329.  *         		 

    330. 

  330.  *         		 When we want to build a Test execution tree, we dont set it deliverately

    331. 

  331.  *         		 to null, but null can be the result of NO tcversion linked.

    332. 

  332.  *

    333. 

  333.  *

    334. 

  334.  * 20081220 - franciscom - status can be an array with multple values, to do OR search.

    335. 

  335.  *

    336. 

  336.  * 20071014 - franciscom - added version info fro test cases in return data structure.

    337. 

  337.  *

    338. 

  338.  * 20061105 - franciscom

    339. 

  339.  * ignore_inactive_testcases: useful when building a Test Project Specification tree 

    340. 

  340.  *                            to be used in the add/link test case to Test Plan.

    341. 

  341.  *

    342. 

  342.  *

    343. 

  343.  * 20061030 - franciscom

    344. 

  344.  * tck_map: Test Case Keyword map:

    345. 

  345.  *          null            => no filter

    346. 

  346.  *          empty map       => filter out ALL test case ALWAYS

    347. 

  347.  *          initialized map => filter out test case ONLY if NOT present in map.

    348. 

  348.  *

    349. 

  349.  *

    350. 

  350.  * added argument:

    351. 

  351.  *                $map_node_tccount

    352. 

  352.  *                key => node_id

    353. 

  353.  *                values => node test case count

    354. 

  354.  *                          node name (useful only for debug purpouses

    355. 

  355.  *

    356. 

  356.  *                IMPORTANT: this new argument is not useful for tree rendering

    357. 

  357.  *                           but to avoid duplicating logic to get test case count

    358. 

  358.  *

    359. 

  359.  *

    360. 

  360.  * return: map with keys:

    361. 

  361.  *         'total_count'

    362. 

  362.  *         'passed'  

    363. 

  363.  *         'failed'

    364. 

  364.  *         'blocked'

    365. 

  365.  *         'not run'

    366. 

  366.  *

    367. 

  367.  * @internal Revisions

    368. 

  368.  * 20100810 - asimon - filtering by testcase ID

    369. 

  369.  * 20100417 - franciscom -  BUGID 2498 - filter by test case importance

    370. 

  370.  * 20100415 - franciscom -  BUGID 2797 - filter by test case execution type

    371. 

  371.  */

    372. 

  372. function prepareNode(&$db,&$node,&$decoding_info,&$map_node_tccount,$tck_map = null,

    373. 

  373.                      $tplan_tcases = null,$filters=null, $options=null)

    374. 

  374. {

    375. 

  375. 	

    376. 

  376. 	static $hash_id_descr;

    377. 

  377. 	static $status_descr_code;

    378. 

  378. 	static $status_code_descr;

    379. 

  379. 	static $debugMsg;

    380. 

  380.     static $tables;

    381. 

  381.     static $my;

    382. 

  382.     static $enabledFiltersOn;

    383. 

  383.     static $activeVersionClause;

    384. 

  384.     static $filterOnTCVersionAttribute;

    385. 

  385.     static $filtersApplied;

    386. 

  386. 

    387. 

  387.     $tpNode = null;

    388. 

  388. 	if (!$tables)

    389. 

  389. 	{

    390. 

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

    391. 

  391.         $tables = tlObjectWithDB::getDBTables(array('tcversions','nodes_hierarchy','testplan_tcversions'));

    392. 

  392.     }	

    393. 

  393. 	if (!$hash_id_descr)

    394. 

  394. 	{

    395. 

  395. 		$hash_id_descr = $decoding_info['node_id_descr'];

    396. 

  396. 	}

    397. 

  397. 	if (!$status_descr_code)

    398. 

  398. 	{

    399. 

  399. 		$status_descr_code = $decoding_info['status_descr_code'];

    400. 

  400. 	}

    401. 

  401. 	if (!$status_code_descr)

    402. 

  402. 	{

    403. 

  403. 		$status_code_descr = $decoding_info['status_code_descr'];

    404. 

  404. 	}

    405. 

  405. 	

    406. 

  406. 	if (!$my)

    407. 

  407. 	{

    408. 

  408. 		$my = array();

    409. 

  409. 		$my['options'] = array('hideTestCases' => 0, 'showTestCaseID' => 1, 'viewType' => 'testSpecTree',

    410. 

  410. 		                       'getExternalTestCaseID' => 1,'ignoreInactiveTestCases' => 0);

    411. 

  411. 

    412. 

  412. 		// asimon - added importance here because of "undefined" error in event log

    413. 

  413. 		$my['filters'] = array('status' => null, 'assignedTo' => null, 

    414. 

  414. 		                       'importance' => null, 'executionType' => null,

    415. 

  415. 		                       'filter_tc_id' => null);

    416. 

  416. 		

    417. 

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

    418. 

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

    419. 

  419. 	}

    420. 

  420. 	

    421. 

  421. 	if(!$enabledFiltersOn)

    422. 

  422. 	{

    423. 

  423. 		// 3301 - added filtering by testcase name

    424. 

  424. 		// 20100702 - and custom fields

    425. 

  425. 		// 20100810 - and testcase ID

    426. 

  426. 		$enabledFiltersOn['testcase_id'] = 

    427. 

  427. 			isset($my['filters']['filter_tc_id']);

    428. 

  428. 		$enabledFiltersOn['testcase_name'] = 

    429. 

  429. 			isset($my['filters']['filter_testcase_name']);

    430. 

  430. 		$enabledFiltersOn['keywords'] = isset($tck_map);

    431. 

  431. 		$enabledFiltersOn['executionType'] = 

    432. 

  432. 			isset($my['filters']['filter_execution_type']);

    433. 

  433. 		$enabledFiltersOn['importance'] = isset($my['filters']['filter_priority']);

    434. 

  434. 		$enabledFiltersOn['custom_fields'] = isset($my['filters']['filter_custom_fields']);

    435. 

  435. 		$filterOnTCVersionAttribute = $enabledFiltersOn['executionType'] || $enabledFiltersOn['importance'];

    436. 

  436. 					

    437. 

  437. 		$filtersApplied = false;

    438. 

  438. 		foreach($enabledFiltersOn as $filterValue)

    439. 

  439. 		{

    440. 

  440. 			$filtersApplied = $filtersApplied || $filterValue; 

    441. 

  441. 		}

    442. 

  442. 		

    443. 

  443. 		$activeVersionClause = $filterOnTCVersionAttribute ? " AND TCV.active=1 " : '';

    444. 

  444. 	}

    445. 

  445. 		

    446. 

  446. 	$tcase_counters = array('testcase_count' => 0);

    447. 

  447. 	foreach($status_descr_code as $status_descr => $status_code)

    448. 

  448. 	{

    449. 

  449. 		$tcase_counters[$status_descr]=0;

    450. 

  450. 	}

    451. 

  451. 	

    452. 

  452. 	$node_type = isset($node['node_type_id']) ? $hash_id_descr[$node['node_type_id']] : null;

    453. 

  453. 	$tcase_counters['testcase_count']=0;

    454. 

  454. 

    455. 

  455. 	if($node_type == 'testcase')

    456. 

  456. 	{

    457. 

  457. 		$viewType = $my['options']['viewType'];

    458. 

  458. 		if ($enabledFiltersOn['keywords'])

    459. 

  459. 		{

    460. 

  460. 			if (!isset($tck_map[$node['id']]))

    461. 

  461. 			{

    462. 

  462. 				$node = null;

    463. 

  463. 			}	

    464. 

  464. 		}

    465. 

  465. 		

    466. 

  466. 		// added filter by testcase name

    467. 

  467. 		if ($node && $enabledFiltersOn['testcase_name']) {

    468. 

  468. 			$filter_name = $my['filters']['filter_testcase_name'];

    469. 

  469. 			// IMPORTANT:

    470. 

  470. 			// checking with === here, because function stripos could return 0 when string

    471. 

  471. 			// is found at position 0, if clause would then evaluate wrong because 

    472. 

  472. 			// 0 would be casted to false and we only want to delete node if it really is false

    473. 

  473. 			if (stripos($node['name'], $filter_name) === FALSE) {

    474. 

  474. 				$node = null;

    475. 

  475. 			}

    476. 

  476. 		}

    477. 

  477. 		

    478. 

  478. 		// filter by testcase ID

    479. 

  479. 		if ($node && $enabledFiltersOn['testcase_id']) {

    480. 

  480. 			$filter_id = $my['filters']['filter_tc_id'];

    481. 

  481. 			if ($node['id'] != $filter_id) {

    482. 

  482. 				$node = null;

    483. 

  483. 			}

    484. 

  484. 		}

    485. 

  485. 		

    486. 

  486. 		if ($node && $viewType == 'executionTree')

    487. 

  487. 		{

    488. 

  488. 			

    489. 

  489. 			$tpNode = isset($tplan_tcases[$node['id']]) ? $tplan_tcases[$node['id']] : null;

    490. 

  490. //			if (!$tpNode || (!is_null($my['filters']['assignedTo'])) && 

    491. 

  491. //					((isset($my['filters']['assignedTo'][TL_USER_NOBODY]) && !is_null($tpNode['user_id'])) ||

    492. 

  492. //							(!isset($my['filters']['assignedTo'][TL_USER_NOBODY]) && (!isset($my['filters']['assignedTo'][TL_USER_SOMEBODY])) && 

    493. 

  493. //							 !isset($my['filters']['assignedTo'][$tpNode['user_id']]))) || 

    494. 

  494. //							(!is_null($my['filters']['status']) && !isset($my['filters']['status'][$tpNode['exec_status']])) ||

    495. 

  495. //							(isset($my['filters']['assignedTo'][TL_USER_SOMEBODY]) && !is_numeric($tpNode['user_id']))

    496. 

  496. //			)

    497. 

  497. //			{

    498. 

  498. 

    499. 

  499. 			// asimon - additional variables for better readability of following if condition.

    500. 

  500. 			// For original statement/condition see above commented out lines.

    501. 

  501. 			// This is longer, but MUCH better readable and easier to extend for new filter conditions.

    502. 

  502. 			

    503. 

  503. 			$users2filter = isset($my['filters']['filter_assigned_user']) ?

    504. 

  504. 			                      $my['filters']['filter_assigned_user'] : null;

    505. 

  505. 			$results2filter = isset($my['filters']['filter_result_result']) ?

    506. 

  506. 			                        $my['filters']['filter_result_result'] : null;

    507. 

  507. 			

    508. 

  508. 			$wrong_result = !is_null($results2filter) 

    509. 

  509. 			                && !isset($results2filter[$tpNode['exec_status']]);

    510. 

  510. 			

    511. 

  511. 			$somebody_wanted_but_nobody_there = !is_null($users2filter)

    512. 

  512. 			                                    && isset($users2filter[TL_USER_SOMEBODY])

    513. 

  513. 			                                    && !is_numeric($tpNode['user_id']);

    514. 

  514. 			

    515. 

  515. 			$unassigned_wanted_but_someone_assigned = !is_null($users2filter)

    516. 

  516. 			                                          && isset($users2filter[TL_USER_NOBODY])

    517. 

  517. 			                                          && !is_null($tpNode['user_id']);

    518. 

  518. 			

    519. 

  519. 			$wrong_user = !is_null($users2filter)

    520. 

  520. 			              && !isset($users2filter[TL_USER_NOBODY])

    521. 

  521. 			              && !isset($users2filter[TL_USER_SOMEBODY])

    522. 

  522. 			              && !isset($users2filter[$tpNode['user_id']]);

    523. 

  523. 						

    524. 

  524. 			$delete_node = $unassigned_wanted_but_someone_assigned

    525. 

  525. 			               || $wrong_user

    526. 

  526. 			               || $wrong_result

    527. 

  527. 			               || $somebody_wanted_but_nobody_there;

    528. 

  528. 			

    529. 

  529. 			if (!$tpNode || $delete_node) {

    530. 

  530. 				$node = null;

    531. 

  531. 			} else {

    532. 

  532. 				$externalID='';

    533. 

  533. 				$node['tcversion_id'] = $tpNode['tcversion_id'];		

    534. 

  534. 				$node['version'] = $tpNode['version'];		

    535. 

  535. 				if ($my['options']['getExternalTestCaseID'])

    536. 

  536. 				{

    537. 

  537. 					if (!isset($tpNode['external_id']))

    538. 

  538. 					{

    539. 

  539. 						$sql = " /* $debugMsg - line:" . __LINE__ . " */ " . 

    540. 

  540. 						       " SELECT TCV.tc_external_id AS external_id " .

    541. 

  541. 							   " FROM {$tables['tcversions']}  TCV " .

    542. 

  542. 							   " WHERE TCV.id=" . $node['tcversion_id'];

    543. 

  543. 						

    544. 

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

    545. 

  545. 						$myrow = $db->fetch_array($result);

    546. 

  546. 						$externalID = $myrow['external_id'];

    547. 

  547. 					}

    548. 

  548. 					else

    549. 

  549. 					{

    550. 

  550. 						$externalID = $tpNode['external_id'];

    551. 

  551. 					}	

    552. 

  552. 				}

    553. 

  553. 				$node['external_id'] = $externalID;

    554. 

  554. 				unset($tplan_tcases[$node['id']]);

    555. 

  555. 			}

    556. 

  556. 		}

    557. 

  557. 		

    558. 

  558. 		if ($node && $my['options']['ignoreInactiveTestCases'])

    559. 

  559. 		{

    560. 

  560. 			// there are active tcversions for this node ???

    561. 

  561. 			// I'm doing this instead of creating a test case manager object, because

    562. 

  562. 			// I think is better for performance.

    563. 

  563. 			//

    564. 

  564. 			// =======================================================================================

    565. 

  565. 			// 20070106 - franciscom

    566. 

  566. 			// Postgres Problems

    567. 

  567. 			// =======================================================================================

    568. 

  568. 			// Problem 1 - SQL Syntax

    569. 

  569. 			//   While testing with postgres

    570. 

  570. 			//   SELECT count(TCV.id) NUM_ACTIVE_VERSIONS   -> Error

    571. 

  571. 			//

    572. 

  572. 			//   At least for what I remember using AS to create COLUMN ALIAS IS REQUIRED and Standard

    573. 

  573. 			//   while AS is NOT REQUIRED (and with some DBMS causes errors) when you want to give a 

    574. 

  574. 			//   TABLE ALIAS

    575. 

  575. 			//

    576. 

  576. 			// Problem 2 - alias case

    577. 

  577. 			//   At least in my installation the aliases column name is returned lower case, then

    578. 

  578. 			//   PHP fails when:

    579. 

  579. 			//                  if($myrow['NUM_ACTIVE_VERSIONS'] == 0)

    580. 

  580. 			//

    581. 

  581. 			//

    582. 

  582. 			$sql=" /* $debugMsg - line:" . __LINE__ . " */ " . 

    583. 

  583. 			     " SELECT count(TCV.id) AS num_active_versions " .

    584. 

  584. 				 " FROM {$tables['tcversions']} TCV, {$tables['nodes_hierarchy']} NH " .

    585. 

  585. 				 " WHERE NH.parent_id=" . $node['id'] .

    586. 

  586. 				 " AND NH.id = TCV.id AND TCV.active=1";

    587. 

  587. 			

    588. 

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

    589. 

  589. 			$myrow = $db->fetch_array($result);

    590. 

  590. 			if($myrow['num_active_versions'] == 0)

    591. 

  591. 			{

    592. 

  592. 				$node = null;

    593. 

  593. 			}

    594. 

  594. 		}

    595. 

  595. 		

    596. 

  596. 		// -------------------------------------------------------------------

    597. 

  597. 		if ($node && ($viewType=='testSpecTree' || $viewType=='testSpecTreeForTestPlan') )

    598. 

  598. 		{

    599. 

  599. 			$sql = " /* $debugMsg - line:" . __LINE__ . " */ " . 

    600. 

  600. 			       " SELECT COALESCE(MAX(TCV.id),0) AS targetid, TCV.tc_external_id AS external_id" .

    601. 

  601. 				   " FROM {$tables['tcversions']} TCV, {$tables['nodes_hierarchy']} NH " .

    602. 

  602. 				   " WHERE  NH.id = TCV.id {$activeVersionClause} AND NH.parent_id={$node['id']} " .

    603. 

  603. 				   " GROUP BY TCV.tc_external_id ";

    604. 

  604. 			   

    605. 

  605. 			$rs = $db->get_recordset($sql);

    606. 

  606. 			if( is_null($rs) )

    607. 

  607. 			{

    608. 

  608. 				$node = null;

    609. 

  609. 			}

    610. 

  610. 			else

    611. 

  611. 			{	

    612. 

  612. 			    $node['external_id'] = $rs[0]['external_id'];

    613. 

  613. 			    $target_id = $rs[0]['targetid'];

    614. 

  614. 				

    615. 

  615. 				if( $filterOnTCVersionAttribute )

    616. 

  616. 				{

    617. 

  617. 					// BUGID 2797 

    618. 

  618. 					switch ($viewType)

    619. 

  619. 					{

    620. 

  620. 						case 'testSpecTreeForTestPlan':

    621. 

  621. 							// Try to get info from linked tcversions

    622. 

  622. 							// Platform is not needed

    623. 

  623. 							$sql = " /* $debugMsg - line:" . __LINE__ . " */ " . 

    624. 

  624. 								   " SELECT DISTINCT TPTCV.tcversion_id AS targetid " .

    625. 

  625. 								   " FROM {$tables['tcversions']} TCV " .

    626. 

  626. 								   " JOIN {$tables['nodes_hierarchy']} NH " .

    627. 

  627. 								   " ON NH.id = TCV.id {$activeVersionClause} " .

    628. 

  628. 								   " AND NH.parent_id={$node['id']} " .

    629. 

  629. 								   " JOIN {$tables['testplan_tcversions']} TPTCV " .

    630. 

  630. 								   " ON TPTCV.tcversion_id = TCV.id " .

    631. 

  631. 								   " AND TPTCV.testplan_id = " . 

    632. 

  632. 							       " {$my['filters']['setting_testplan']}";

    633. 

  633. 			    			$rs = $db->get_recordset($sql);

    634. 

  634. 							$target_id = !is_null($rs) ? $rs[0]['targetid'] : $target_id;

    635. 

  635. 						break;

    636. 

  636. 					}		

    637. 

  637. 					

    638. 

  638. 					$sql = " /* $debugMsg - line:" . __LINE__ . " */ " . 

    639. 

  639. 						   " SELECT TCV.execution_type " .

    640. 

  640. 						   " FROM {$tables['tcversions']} TCV " .

    641. 

  641. 						   " WHERE TCV.id = {$target_id} ";

    642. 

  642. 					 	   

    643. 

  643. 					if( $enabledFiltersOn['executionType'] )

    644. 

  644. 					{

    645. 

  645. 						$sql .= " AND TCV.execution_type = " .

    646. 

  646. 						        " {$my['filters']['filter_execution_type']} ";

    647. 

  647. 					}

    648. 

  648. 					

    649. 

  649. 					if( $enabledFiltersOn['importance'] )

    650. 

  650. 					{

    651. 

  651. 						$sql .= " AND TCV.importance = " .

    652. 

  652. 						        " {$my['filters']['filter_priority']} ";

    653. 

  653. 					}

    654. 

  654. 					

    655. 

  655. 			    	$rs = $db->fetchRowsIntoMap($sql,'execution_type');

    656. 

  656. 			    	if(is_null($rs))

    657. 

  657. 			    	{

    658. 

  658. 			    		$node = null;

    659. 

  659. 			    	}

    660. 

  660. 			    }

    661. 

  661. 			} 

    662. 

  662.             if( !is_null($node) )

    663. 

  663.             {

    664. 

  664. 				// needed to avoid problems when using json_encode with EXTJS

    665. 

  665. 				unset($node['childNodes']);

    666. 

  666. 				$node['leaf']=true;

    667. 

  667. 			}

    668. 

  668. 		}

    669. 

  669. 		// -------------------------------------------------------------------

    670. 

  670. 		

    671. 

  671. 		

    672. 

  672. 		foreach($tcase_counters as $key => $value)

    673. 

  673. 		{

    674. 

  674. 			$tcase_counters[$key]=0;

    675. 

  675. 		}

    676. 

  676. 		if(isset($tpNode['exec_status']) )

    677. 

  677. 		{

    678. 

  678. 			$tc_status_code = $tpNode['exec_status'];

    679. 

  679. 			$tc_status_descr = $status_code_descr[$tc_status_code];   

    680. 

  680. 		}

    681. 

  681. 		else

    682. 

  682. 		{

    683. 

  683. 			$tc_status_descr = "not_run";

    684. 

  684. 			$tc_status_code = $status_descr_code[$tc_status_descr];

    685. 

  685. 		}

    686. 

  686. 		

    687. 

  687. 		$init_value = $node ? 1 : 0;

    688. 

  688. 		$tcase_counters[$tc_status_descr]=$init_value;

    689. 

  689. 		$tcase_counters['testcase_count']=$init_value;

    690. 

  690. 		if ( $my['options']['hideTestCases'] )

    691. 

  691. 		{

    692. 

  692. 			$node = null;

    693. 

  693. 		} 

    694. 

  694. 	}  // if($node_type == 'testcase')

    695. 

  695. 	

    696. 

  696. 	if (isset($node['childNodes']) && is_array($node['childNodes']))

    697. 

  697. 	{

    698. 

  698. 		// node has to be a Test Suite ?

    699. 

  699. 		$childNodes = &$node['childNodes'];

    700. 

  700. 		$childNodesQty = count($childNodes);

    701. 

  701. 		

    702. 

  702. 		for($idx = 0;$idx < $childNodesQty ;$idx++)

    703. 

  703. 		{

    704. 

  704. 			$current = &$childNodes[$idx];

    705. 

  705. 			// I use set an element to null to filter out leaf menu items

    706. 

  706. 			

    707. 

  707. 			if(is_null($current))

    708. 

  708. 			{

    709. 

  709. 				continue;

    710. 

  710. 			}

    711. 

  711. 			

    712. 

  712. 			$counters_map = prepareNode($db,$current,$decoding_info,$map_node_tccount,

    713. 

  713. 				                        $tck_map,$tplan_tcases,$my['filters'],$my['options']);

    714. 

  714. 			foreach($counters_map as $key => $value)

    715. 

  715. 			{

    716. 

  716. 				$tcase_counters[$key] += $counters_map[$key];   

    717. 

  717. 			}  

    718. 

  718. 		}

    719. 

  719. 		foreach($tcase_counters as $key => $value)

    720. 

  720. 		{

    721. 

  721. 			$node[$key] = $tcase_counters[$key];

    722. 

  722. 		}  

    723. 

  723. 		

    724. 

  724. 		if (isset($node['id']))

    725. 

  725. 		{

    726. 

  726. 			$map_node_tccount[$node['id']] = array(	'testcount' => $node['testcase_count'],

    727. 

  727. 				                                    'name' => $node['name']);

    728. 

  728. 		}

    729. 

  729. 

    730. 

  730.         // node must be dstroyed if empty had we have using filtering conditions

    731. 

  731. 		if( ($filtersApplied || !is_null($tplan_tcases)) && 

    732. 

  732. 			!$tcase_counters['testcase_count'] && ($node_type != 'testproject'))

    733. 

  733. 		{

    734. 

  734. 			$node = null;

    735. 

  735. 		}

    736. 

  736. 	}

    737. 

  737. 	else if ($node_type == 'testsuite')

    738. 

  738. 	{

    739. 

  739. 		// does this means is an empty test suite ??? - franciscom 20080328

    740. 

  740. 		$map_node_tccount[$node['id']] = array(	'testcount' => 0,'name' => $node['name']);

    741. 

  741. 		

    742. 

  742.         // If is an EMPTY Test suite and we have added filtering conditions,

    743. 

  743.         // We will destroy it.

    744. 

  744. 		if ($filtersApplied || !is_null($tplan_tcases) )

    745. 

  745. 		{

    746. 

  746. 			$node = null;

    747. 

  747. 		}	

    748. 

  748. 	}

    749. 

  749. 

    750. 

  750. 	return $tcase_counters;

    751. 

  751. }

    752. 

  752. 

    753. 

  753. 

    754. 

  754. /**

    755. 

  755.  * Create the string representation suitable to create a graphic visualization

    756. 

  756.  * of a node, for the type of menu selected.

    757. 

  757.  *

    758. 

  758.  * @internal Revisions

    759. 

  759.  * 20100611 - franciscom - removed useless $getArguments

    760. 

  760.  */

    761. 

  761. function renderTreeNode($level,&$node,$hash_id_descr,

    762. 

  762.                         $tc_action_enabled,$linkto,$testCasePrefix,

    763. 

  763.                         $bForPrinting=0,$showTestCaseID)

    764. 

  764. {

    765. 

  765. 	$menustring='';

    766. 

  766. 	$node_type = $hash_id_descr[$node['node_type_id']];

    767. 

  767. 	extjs_renderTestSpecTreeNodeOnOpen($node,$node_type,$tc_action_enabled,$bForPrinting,

    768. 

  768. 		                               $showTestCaseID,$testCasePrefix);

    769. 

  769. 	

    770. 

  770. 	

    771. 

  771. 	if (isset($node['childNodes']) && $node['childNodes'])

    772. 

  772. 	{

    773. 

  773. 		// 20090118 - franciscom - need to work always original object

    774. 

  774. 		//                         in order to change it's values using reference .

    775. 

  775. 		// Can not assign anymore to intermediate variables.

    776. 

  776. 		//

    777. 

  777. 		$nChildren = sizeof($node['childNodes']);

    778. 

  778. 		for($idx = 0;$idx < $nChildren;$idx++)

    779. 

  779. 		{

    780. 

  780. 			// asimon - replaced is_null by !isset because of warnings in event log

    781. 

  781. 			if(!isset($node['childNodes'][$idx]))

    782. 

  782. 			//if(is_null($node['childNodes'][$idx]))

    783. 

  783. 			{

    784. 

  784. 				continue;

    785. 

  785. 			}

    786. 

  786. 			$menustring .= renderTreeNode($level+1,$node['childNodes'][$idx],$hash_id_descr,

    787. 

  787. 				                          $tc_action_enabled,$linkto,$testCasePrefix,

    788. 

  788. 				                          $bForPrinting,$showTestCaseID);

    789. 

  789. 		}

    790. 

  790. 	}

    791. 

  791. 	

    792. 

  792. 	return $menustring;

    793. 

  793. }

    794. 

  794. 

    795. 

  795. 

    796. 

  796. /** 

    797. 

  797.  * Creates data for tree menu used on :

    798. 

  798.  * - Execution of Test Cases

    799. 

  799.  * - Remove Test cases from test plan

    800. 

  800.  * 

    801. 

  801.  * @internal Revisions:

    802. 

  802.  *  20100820 - asimon - refactoring for less redundant checks and better readibility

    803. 

  803.  *  20100719 - asimon - BUGID 3406 - user assignments per build:

    804. 

  804.  *                                   filter assigned test cases by setting_build

    805. 

  805.  *	20080617 - franciscom - return type changed to use extjs tree component

    806. 

  806.  *	20080305 - franciscom - interface refactoring

    807. 

  807.  *	20080224 - franciscom - added include_unassigned

    808. 

  808.  *	20071002 - jbarchibald - BUGID 1051 - added cf element to parameter list

    809. 

  809.  *	20070204 - franciscom - changed $bForPrinting -> $bHideTCs

    810. 

  810.  */

    811. 

  811. function generateExecTree(&$db,&$menuUrl,$tproject_id,$tproject_name,$tplan_id,

    812. 

  812.                           $tplan_name,$filters,$additionalInfo) 

    813. 

  813. {

    814. 

  814. 	$treeMenu = new stdClass(); 

    815. 

  815. 	$treeMenu->rootnode = null;

    816. 

  816. 	$treeMenu->menustring = '';

    817. 

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

    818. 

  818. 	$showTestCaseID = config_get('treemenu_show_testcase_id');

    819. 

  819. 	$glueChar=config_get('testcase_cfg')->glue_character;

    820. 

  820. 	

    821. 

  821. 	$menustring = null;

    822. 

  822. 	$any_exec_status = null;

    823. 

  823. 	$tplan_tcases = null;

    824. 

  824. 	$tck_map = null;

    825. 

  825.     $idx=0;

    826. 

  826.     $testCaseQty=0;

    827. 

  827.     $testCaseSet=null;

    828. 

  828.     	

    829. 

  829. 	$keyword_id = 0;

    830. 

  830. 	$keywordsFilterType = 'Or';

    831. 

  831. 	if (property_exists($filters, 'filter_keywords') && !is_null($filters->{'filter_keywords'})) {

    832. 

  832. 		$keyword_id = $filters->{'filter_keywords'};

    833. 

  833. 		$keywordsFilterType = $filters->{'filter_keywords_filter_type'};

    834. 

  834. 	}

    835. 

  835. 

    836. 

  836. 	// BUGID 3406 - user assignments per build

    837. 

  837. 	// can't use $build_id here because we need the build ID from settings panel

    838. 

  838. 	$build2filter_assignments = isset($filters->{'setting_build'}) ? $filters->{'setting_build'} : 0;

    839. 

  839. 	

    840. 

  840. 	$tc_id = isset($filters->filter_tc_id) ? $filters->filter_tc_id : null; 

    841. 

  841. 	$build_id = isset($filters->filter_result_build) ? $filters->filter_result_build : null;

    842. 

  842. 	$bHideTCs = isset($filters->hide_testcases) ? $filters->hide_testcases : false;

    843. 

  843. 	$assignedTo = isset($filters->filter_assigned_user) ? $filters->filter_assigned_user : null; 

    844. 

  844. 	$include_unassigned = isset($filters->filter_assigned_user_include_unassigned) ?

    845. 

  845. 	                      $filters->filter_assigned_user_include_unassigned : false;

    846. 

  846. 	$setting_platform = isset($filters->setting_platform) ? $filters->setting_platform : null;

    847. 

  847. 	$execution_type = isset($filters->filter_execution_type) ? $filters->filter_execution_type : null;

    848. 

  848. 	$status = isset($filters->filter_result_result) ? $filters->filter_result_result : null;

    849. 

  849. 	$cf_hash = isset($filters->filter_custom_fields) ? $filters->filter_custom_fields : null;

    850. 

  850. 	$show_testsuite_contents = isset($filters->show_testsuite_contents) ? 

    851. 

  851. 	                           $filters->show_testsuite_contents : true;

    852. 

  852. 	$urgencyImportance = isset($filters->filter_priority) ?

    853. 

  853. 	                     $filters->filter_priority : null;

    854. 

  854. 	

    855. 

  855. 	$useCounters=isset($additionalInfo->useCounters) ? $additionalInfo->useCounters : null;

    856. 

  856. 	$useColors=isset($additionalInfo->useColours) ? $additionalInfo->useColours : null;

    857. 

  857. 	$colorBySelectedBuild = isset($additionalInfo->testcases_colouring_by_selected_build) ? 

    858. 

  858. 	                        $additionalInfo->testcases_colouring_by_selected_build : null;

    859. 

  859. 

    860. 

  860. 	$tplan_mgr = new testplan($db);

    861. 

  861. 	$tproject_mgr = new testproject($db);

    862. 

  862. 	$tcase_mgr = new testcase($db);

    863. 

  863. 	

    864. 

  864. 	$tree_manager = $tplan_mgr->tree_manager;

    865. 

  865. 	$tcase_node_type = $tree_manager->node_descr_id['testcase'];

    866. 

  866. 	$hash_descr_id = $tree_manager->get_available_node_types();

    867. 

  867. 	

    868. 

  868. 	$hash_id_descr = array_flip($hash_descr_id);	    

    869. 

  869. 	$decoding_hash = array('node_id_descr' => $hash_id_descr,

    870. 

  870. 		                   'status_descr_code' =>  $resultsCfg['status_code'],

    871. 

  871. 		                   'status_code_descr' =>  $resultsCfg['code_status']);

    872. 

  872. 	

    873. 

  873. 	$tcase_prefix = $tproject_mgr->getTestCasePrefix($tproject_id) . $glueChar;

    874. 

  874. 	

    875. 

  875. 	$nt2exclude = array('testplan' => 'exclude_me',

    876. 

  876. 		                'requirement_spec'=> 'exclude_me',

    877. 

  877. 		                'requirement'=> 'exclude_me');

    878. 

  878. 	

    879. 

  879. 	$nt2exclude_children = array('testcase' => 'exclude_my_children',

    880. 

  880. 		                         'requirement_spec'=> 'exclude_my_children');

    881. 

  881. 	

    882. 

  882.   	$my['options']=array('recursive' => true,

    883. 

  883.   	                     'order_cfg' => array("type" =>'exec_order',"tplan_id" => $tplan_id));

    884. 

  884.  	$my['filters'] = array('exclude_node_types' => $nt2exclude,

    885. 

  885.  	                       'exclude_children_of' => $nt2exclude_children);

    886. 

  886. 	

    887. 

  887.  	// BUGID 3301 - added for filtering by toplevel testsuite

    888. 

  888.  	if (isset($filters->{'filter_toplevel_testsuite'}) && is_array($filters->{'filter_toplevel_testsuite'})) {

    889. 

  889.  		$my['filters']['exclude_branches'] = $filters->{'filter_toplevel_testsuite'};

    890. 

  890.  	}

    891. 

  891.  	

    892. 

  892.     $test_spec = $tree_manager->get_subtree($tproject_id,$my['filters'],$my['options']);

    893. 

  893.      

    894. 

  894. 	$test_spec['name'] = $tproject_name . " / " . $tplan_name;  // To be discussed

    895. 

  895. 	$test_spec['id'] = $tproject_id;

    896. 

  896. 	$test_spec['node_type_id'] = $hash_descr_id['testproject'];

    897. 

  897. 	$map_node_tccount = array();

    898. 

  898. 	

    899. 

  899. 	$tplan_tcases = null;

    900. 

  900.     $apply_other_filters=true;

    901. 

  901.     

    902. 

  902. 	if($test_spec)

    903. 

  903. 	{

    904. 

  904. 		if(is_null($tc_id) || $tc_id >= 0)

    905. 

  905. 		{

    906. 

  906. 			$doFilterByKeyword = (!is_null($keyword_id) && $keyword_id > 0);

    907. 

  907. 			if($doFilterByKeyword)

    908. 

  908. 			{

    909. 

  909. 				$tck_map = $tproject_mgr->get_keywords_tcases($tproject_id,$keyword_id,$keywordsFilterType);

    910. 

  910. 			}

    911. 

  911. 			

    912. 

  912. 			// Multiple step algoritm to apply keyword filter on type=AND

    913. 

  913. 			// get_linked_tcversions filters by keyword ALWAYS in OR mode.

    914. 

  914. 			// BUGID 3406: user assignments per build

    915. 

  915. 			$opt = array('include_unassigned' => $include_unassigned, 'steps_info' => false,

    916. 

  916. 			             'user_assignments_per_build' => $build2filter_assignments);

    917. 

  917. 

    918. 

  918. 			// 20100417 - BUGID 3380 - execution type

    919. 

  919. 			$linkedFilters = array('tcase_id' => $tc_id, 'keyword_id' => $keyword_id,

    920. 

  920.                                    'assigned_to' => $assignedTo,

    921. 

  921.                                    'cf_hash' =>  $cf_hash,

    922. 

  922.                                    'platform_id' => $setting_platform,

    923. 

  923.                                    'urgencyImportance' => $urgencyImportance,

    924. 

  924.                                    'exec_type' => $execution_type);

    925. 

  925. 			

    926. 

  926. 			$tplan_tcases = $tplan_mgr->get_linked_tcversions($tplan_id,$linkedFilters,$opt);

    927. 

  927. 			

    928. 

  928. 			if($tplan_tcases && $doFilterByKeyword && $keywordsFilterType == 'AND')

    929. 

  929. 			{

    930. 

  930. 				$filteredSet = $tcase_mgr->filterByKeyword(array_keys($tplan_tcases),$keyword_id,$keywordsFilterType);

    931. 

  931. 

    932. 

  932. 				// CAUTION: if $filteredSet is null,

    933. 

  933. 				// then get_linked_tcversions() thinks there are just no filters set,

    934. 

  934. 				// but really there are no testcases which match the wanted keyword criteria,

    935. 

  935. 				// so we have to set $tplan_tcases to null because there is no more filtering necessary

    936. 

  936. 				if ($filteredSet != null) {

    937. 

  937. 					$linkedFilters = array('tcase_id' => array_keys($filteredSet));

    938. 

  938. 					$tplan_tcases = $tplan_mgr->get_linked_tcversions($tplan_id,$linkedFilters);

    939. 

  939. 				} else {

    940. 

  940. 					$tplan_tcases = null;

    941. 

  941. 				}

    942. 

  942. 			}

    943. 

  943. 		}   

    944. 

  944. 		

    945. 

  945. 		if (is_null($tplan_tcases))

    946. 

  946. 		{

    947. 

  947. 			$tplan_tcases = array();

    948. 

  948. 			$apply_other_filters=false;

    949. 

  949. 		}

    950. 

  950. 		

    951. 

  951. 		$filter_methods = config_get('execution_filter_methods');

    952. 

  952. 		

    953. 

  953. 		// 20100820 - asimon - refactoring for less redundant checks and better readibility

    954. 

  954. 		$ffn = array($filter_methods['status_code']['any_build'] => 'filter_by_status_for_any_build',

    955. 

  955. 			         $filter_methods['status_code']['all_builds'] => 'filter_by_same_status_for_all_builds',

    956. 

  956. 			         $filter_methods['status_code']['specific_build'] => 'filter_by_status_for_build',

    957. 

  957. 			         $filter_methods['status_code']['current_build'] => 'filter_by_status_for_build',

    958. 

  958. 			         $filter_methods['status_code']['latest_execution'] => 'filter_by_status_for_last_execution');

    959. 

  959. 		

    960. 

  960. 		$requested_filter_method = isset($filters->filter_result_method) ? $filters->filter_result_method : null;

    961. 

  961. 		$requested_filter_result = isset($filters->filter_result_result) ? $filters->filter_result_result : null;

    962. 

  962. 		

    963. 

  963. 		// if "any" was selected as filtering status, don't filter by status

    964. 

  964. 		$requested_filter_result = (array)$requested_filter_result;

    965. 

  965. 		if (in_array($resultsCfg['status_code']['all'], $requested_filter_result)) {

    966. 

  966. 			$requested_filter_result = null;

    967. 

  967. 		}

    968. 

  968. 

    969. 

  969. 		if ($apply_other_filters && !is_null($requested_filter_method) && isset($ffn[$requested_filter_method])) {

    970. 

  970. 			// special case 1: when filtering by "not run" status in any build,

    971. 

  971. 			// we need another filter function

    972. 

  972. 			if (in_array($resultsCfg['status_code']['not_run'], $requested_filter_result)) {

    973. 

  973. 				$ffn[$filter_methods['status_code']['any_build']] = 'filter_not_run_for_any_build';

    974. 

  974. 			}

    975. 

  975. 			// special case 2: when filtering by "current build", we set the build to filter with

    976. 

  976. 			// to the build chosen in settings instead of the one in filters

    977. 

  977. 			if ($requested_filter_method == $filter_methods['status_code']['current_build']) {

    978. 

  978. 				$filters->filter_result_build = $filters->setting_build;

    979. 

  979. 			}

    980. 

  980. 			

    981. 

  981. 			// call the filter function and do the filtering

    982. 

  982. 			$tplan_tcases = $ffn[$requested_filter_method]($tplan_mgr, $tplan_tcases, $tplan_id, $filters);

    983. 

  983. 

    984. 

  984. 			if (is_null($tplan_tcases)) {

    985. 

  985. 				$tplan_tcases = array();

    986. 

  986. 				$apply_other_filters=false;

    987. 

  987. 			}

    988. 

  988. 		}

    989. 

  989. 		// end 20100820 refactoring

    990. 

  990. 		

    991. 

  991. 		// BUGID 3450 - Change colors/counters in exec tree.

    992. 

  992. 		// Means: replace exec status in filtered array $tplan_tcases 

    993. 

  993. 		// by the one of last execution of selected build.

    994. 

  994. 		// Since this changes exec status, replacing is done after filtering by status.

    995. 

  995. 		// It has to be done before call to prepareNode() though,

    996. 

  996. 		// because that one sets the counters according to status.

    997. 

  997. 		if ($useColors && $colorBySelectedBuild) {

    998. 

  998. 			$tables = tlObject::getDBTables('executions');

    999. 

  999. 			foreach ($tplan_tcases as $id => $info) {

    1000. 

  1000. 				// get last execution result for selected build

    1001. 

  1001. 				$sql = " SELECT status FROM {$tables['executions']} E " .

    1002. 

  1002. 					   " WHERE tcversion_id = {$info['tcversion_id']} " .

    1003. 

  1003. 				       " AND testplan_id = {$tplan_id} " .

    1004. 

  1004. 					   " AND platform_id = {$info['platform_id']} " .

    1005. 

  1005. 					   " AND build_id = {$filters->setting_build} " .

    1006. 

  1006. 					   " ORDER BY execution_ts DESC LIMIT 1 ";

    1007. 

  1007. 				

    1008. 

  1008. 				$result = null;

    1009. 

  1009. 				$result = $db->fetchOneValue($sql);

    1010. 

  1010. 				

    1011. 

  1011. 				if (is_null($result)) {

    1012. 

  1012. 					// if no value can be loaded it has to be set to not run

    1013. 

  1013. 					$result = $resultsCfg['status_code']['not_run'];

    1014. 

  1014. 				}

    1015. 

  1015. 				

    1016. 

  1016. 				if ($result != $info['exec_status']) {

    1017. 

  1017. 					$tplan_tcases[$id]['exec_status'] = $result;

    1018. 

  1018. 				}

    1019. 

  1019. 			}

    1020. 

  1020. 		}

    1021. 

  1021. 		

    1022. 

  1022. 		

    1023. 

  1023. 		// 20080224 - franciscom - 

    1024. 

  1024. 		// After reviewing code, seems that assignedTo has no sense because tp_tcs

    1025. 

  1025. 		// has been filtered.

    1026. 

  1026. 		// Then to avoid changes to prepareNode() due to include_unassigned,

    1027. 

  1027. 		// seems enough to set assignedTo to 0, if include_unassigned==true

    1028. 

  1028. 		$assignedTo = $include_unassigned ? null : $assignedTo;

    1029. 

  1029. 		

    1030. 

  1030. 		$pnFilters = array('assignedTo' => $assignedTo);

    1031. 

  1031. 		$keys2init = array('filter_testcase_name',

    1032. 

  1032. 		                   'filter_execution_type',

    1033. 

  1033. 		                   'filter_priority');

    1034. 

  1034. 		

    1035. 

  1035. 		foreach ($keys2init as $keyname) {

    1036. 

  1036. 			$pnFilters[$keyname] = isset($filters->{$keyname}) ? $filters->{$keyname} : null;

    1037. 

  1037. 		}

    1038. 

  1038. 	    		

    1039. 

  1039. 		// 20100412 - franciscom

    1040. 

  1040. 		$pnOptions = array('hideTestCases' => $bHideTCs, 'viewType' => 'executionTree');

    1041. 

  1041. 		$testcase_counters = prepareNode($db,$test_spec,$decoding_hash,$map_node_tccount,

    1042. 

  1042. 		                                 $tck_map,$tplan_tcases,$pnFilters,$pnOptions);

    1043. 

  1043. 

    1044. 

  1044. 		foreach($testcase_counters as $key => $value)

    1045. 

  1045. 		{

    1046. 

  1046. 			$test_spec[$key] = $testcase_counters[$key];

    1047. 

  1047. 		}

    1048. 

  1048. 	

    1049. 

  1049. 		

    1050. 

  1050. 		// BUGID 3516

    1051. 

  1051. 		// can now be left in form of array, will not be sent by URL anymore

    1052. 

  1052. 		//$keys = implode(array_keys($tplan_tcases), ",");

    1053. 

  1053. 		$keys = array_keys($tplan_tcases);

    1054. 

  1054. 		$menustring = renderExecTreeNode(1,$test_spec,$tplan_tcases,

    1055. 

  1055. 			                             $hash_id_descr,1,$menuUrl,$bHideTCs,$useCounters,$useColors,

    1056. 

  1056. 			                             $showTestCaseID,$tcase_prefix,$show_testsuite_contents);

    1057. 

  1057.         

    1058. 

  1058. 	}  // if($test_spec)

    1059. 

  1059. 	

    1060. 

  1060. 		

    1061. 

  1061. 	$treeMenu->rootnode=new stdClass();

    1062. 

  1062. 	$treeMenu->rootnode->name=$test_spec['text'];

    1063. 

  1063. 	$treeMenu->rootnode->id=$test_spec['id'];

    1064. 

  1064. 	$treeMenu->rootnode->leaf=$test_spec['leaf'];

    1065. 

  1065. 	$treeMenu->rootnode->text=$test_spec['text'];

    1066. 

  1066. 	$treeMenu->rootnode->position=$test_spec['position'];	    

    1067. 

  1067. 	$treeMenu->rootnode->href=$test_spec['href'];

    1068. 

  1068. 	

    1069. 

  1069. 	if( !is_null($menustring) )

    1070. 

  1070. 	{  

    1071. 

  1071. 		// Change key ('childNodes')  to the one required by Ext JS tree.

    1072. 

  1072. 		$menustring = str_ireplace('childNodes', 'children', json_encode($test_spec['childNodes']));

    1073. 

  1073. 		

    1074. 

  1074. 		// Remove null elements (Ext JS tree do not like it ).

    1075. 

  1075. 		// :null happens on -> "children":null,"text" that must become "children":[],"text"

    1076. 

  1076. 		// $menustring = str_ireplace(array(':null',',null','null,'),array(':[]','',''), $menustring); 

    1077. 

  1077. 		$menustring = str_ireplace(array(':null',',null','null,','null'),array(':[]','','',''), $menustring); 

    1078. 

  1078. 	}  

    1079. 

  1079. 	

    1080. 

  1080. 	$treeMenu->menustring = $menustring;

    1081. 

  1081. 	

    1082. 

  1082. 	return array($treeMenu, $keys);

    1083. 

  1083. }

    1084. 

  1084. 

    1085. 

  1085. 

    1086. 

  1086. /**

    1087. 

  1087.  * 

    1088. 

  1088.  * 

    1089. 

  1089.  * @param integer $level

    1090. 

  1090.  * @param array &$node reference to recursive map

    1091. 

  1091.  * @param array &$tcases_map reference to map that contains info about testcase exec status

    1092. 

  1092.  *              when node is of testcase type.

    1093. 

  1093.  * @param boolean $bHideTCs 1 -> hide testcase

    1094. 

  1094.  * 

    1095. 

  1095.  * @return datatype description

    1096. 

  1096.  * 

    1097. 

  1097.  * @internal Revisions:

    1098. 

  1098.  *	20100611 - franciscom - removed useless $getArguments

    1099. 

  1099.  *	20071229 - franciscom -added $useCounters,$useColors

    1100. 

  1100.  */

    1101. 

  1101. function renderExecTreeNode($level,&$node,&$tcase_node,$hash_id_descr,

    1102. 

  1102.                             $tc_action_enabled,$linkto,$bHideTCs,$useCounters,$useColors,

    1103. 

  1103.                             $showTestCaseID,$testCasePrefix,$showTestSuiteContents)

    1104. 

  1104. {

    1105. 

  1105. 	$node_type = $hash_id_descr[$node['node_type_id']];

    1106. 

  1106. 	$menustring = '';

    1107. 

  1107.     extjs_renderExecTreeNodeOnOpen($node,$node_type,$tcase_node,$tc_action_enabled,$bHideTCs,

    1108. 

  1108.                                    $useCounters,$useColors,$showTestCaseID,$testCasePrefix,

    1109. 

  1109.                                    $showTestSuiteContents);

    1110. 

  1110. 	

    1111. 

  1111. 	

    1112. 

  1112. 	if( isset($tcase_node[$node['id']]) )

    1113. 

  1113. 	{

    1114. 

  1114. 		unset($tcase_node[$node['id']]);

    1115. 

  1115. 	}

    1116. 

  1116. 	if (isset($node['childNodes']) && $node['childNodes'])

    1117. 

  1117. 	{

    1118. 

  1118. 	    // 20080615 - franciscom - need to work always original object

    1119. 

  1119. 	    //                         in order to change it's values using reference .

    1120. 

  1120. 	    // Can not assign anymore to intermediate variables.

    1121. 

  1121.         $nodes_qty = sizeof($node['childNodes']);

    1122. 

  1122. 		for($idx = 0;$idx <$nodes_qty ;$idx++)

    1123. 

  1123. 		{

    1124. 

  1124. 			if(is_null($node['childNodes'][$idx]))

    1125. 

  1125. 			{

    1126. 

  1126. 				continue;

    1127. 

  1127. 			}

    1128. 

  1128. 			$menustring .= renderExecTreeNode($level+1,$node['childNodes'][$idx],$tcase_node,

    1129. 

  1129. 			                                  $hash_id_descr,

    1130. 

  1130. 			                                  $tc_action_enabled,$linkto,$bHideTCs,

    1131. 

  1131. 			                                  $useCounters,$useColors,$showTestCaseID,

    1132. 

  1132. 			                                  $testCasePrefix,$showTestSuiteContents);

    1133. 

  1133. 		}

    1134. 

  1134. 	}

    1135. 

  1135. 	return $menustring;

    1136. 

  1136. }

    1137. 

  1137. 

    1138. 

  1138. 

    1139. 

  1139. /**

    1140. 

  1140.  * @return array a map:

    1141. 

  1141.  *         key    => node_id

    1142. 

  1142.  *         values => node test case count considering test cases presents

    1143. 

  1143.  *                   in the nodes of the subtree that starts on node_id

    1144. 

  1144.  *                   Means test case can not be sons/daughters of node_id.

    1145. 

  1145.  *                   node name (useful only for debug purpouses).

    1146. 

  1146.  */

    1147. 

  1147. function get_testproject_nodes_testcount(&$db,$tproject_id, $tproject_name,

    1148. 

  1148.                                          $keywordsFilter=null)

    1149. 

  1149. {

    1150. 

  1150. 	$tproject_mgr = new testproject($db);

    1151. 

  1151. 	$tree_manager = &$tproject_mgr->tree_manager;

    1152. 

  1152. 

    1153. 

  1153. 	$tcase_node_type = $tree_manager->node_descr_id['testcase'];

    1154. 

  1154. 	$hash_descr_id = $tree_manager->get_available_node_types();

    1155. 

  1155. 	$hash_id_descr = array_flip($hash_descr_id);

    1156. 

  1156. 

    1157. 

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

    1158. 

  1158. 	$decoding_hash = array('node_id_descr' => $hash_id_descr,

    1159. 

  1159.                            'status_descr_code' =>  $resultsCfg['status_code'],

    1160. 

  1160.                        	   'status_code_descr' =>  $resultsCfg['code_status']);

    1161. 

  1161. 	

    1162. 

  1162. 	$test_spec = $tproject_mgr->get_subtree($tproject_id,RECURSIVE_MODE);

    1163. 

  1163. 	

    1164. 

  1164. 	$test_spec['name'] = $tproject_name;

    1165. 

  1165. 	$test_spec['id'] = $tproject_id;

    1166. 

  1166. 	$test_spec['node_type_id'] = 1;

    1167. 

  1167. 	

    1168. 

  1168. 	$map_node_tccount = array(); 

    1169. 

  1169. 	$tplan_tcases = null;

    1170. 

  1170. 	

    1171. 

  1171. 	if($test_spec)

    1172. 

  1172. 	{

    1173. 

  1173. 		$tck_map = null;

    1174. 

  1174. 		if( !is_null($keywordsFilter) )

    1175. 

  1175. 		{

    1176. 

  1176. 			$tck_map = $tproject_mgr->get_keywords_tcases($tproject_id,

    1177. 

  1177. 			                                              $keywordsFilter->items,$keywordsFilter->type);

    1178. 

  1178. 		}	

    1179. 

  1179. 		

    1180. 

  1180. 		//@TODO: schlundus, can we speed up with NO_EXTERNAL?

    1181. 

  1181. 		$filters = null;

    1182. 

  1182. 		

    1183. 

  1183. 		// 20100412 - franciscon

    1184. 

  1184.  	    $options = array('hideTestCases' => 0, 'viewType' => 'testSpecTree');

    1185. 

  1185. 		$testcase_counters = prepareNode($db,$test_spec,$decoding_hash,$map_node_tccount,

    1186. 

  1186. 		                                 $tck_map,$tplan_tcases,$filters,$options);

    1187. 

  1187. 		$test_spec['testcase_count'] = $testcase_counters['testcase_count'];

    1188. 

  1188. 	}

    1189. 

  1189. 

    1190. 

  1190. 	return $map_node_tccount;

    1191. 

  1191. }

    1192. 

  1192. 

    1193. 

  1193. 

    1194. 

  1194. /**

    1195. 

  1195.  * @return array a map:

    1196. 

  1196.  *         key    => node_id

    1197. 

  1197.  *         values => node test case count considering test cases presents

    1198. 

  1198.  *                   in the nodes of the subtree that starts on node_id

    1199. 

  1199.  *                   Means test case can not be sons/daughters of node_id.

    1200. 

  1200.  * 

    1201. 

  1201.  *                   node name (useful only for debug purpouses).

    1202. 

  1202.  */

    1203. 

  1203. function get_testplan_nodes_testcount(&$db,$tproject_id, $tproject_name,

    1204. 

  1204.                                       $tplan_id,$tplan_name,$keywordsFilter=null)

    1205. 

  1205. {

    1206. 

  1206. 	$tplan_mgr = new testplan($db);

    1207. 

  1207. 	$tproject_mgr = new testproject($db);

    1208. 

  1208. 	

    1209. 

  1209. 	$tree_manager = $tplan_mgr->tree_manager;

    1210. 

  1210. 	$tcase_node_type = $tree_manager->node_descr_id['testcase'];

    1211. 

  1211. 	$hash_descr_id = $tree_manager->get_available_node_types();

    1212. 

  1212. 	$hash_id_descr = array_flip($hash_descr_id);

    1213. 

  1213. 	

    1214. 

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

    1215. 

  1215. 	$decoding_hash=array('node_id_descr' => $hash_id_descr, 'status_descr_code' =>  $resultsCfg['status_code'],

    1216. 

  1216. 		                 'status_code_descr' =>  $resultsCfg['code_status']);

    1217. 

  1217. 	

    1218. 

  1218. 	$test_spec = $tproject_mgr->get_subtree($tproject_id,RECURSIVE_MODE);

    1219. 

  1219. 	

    1220. 

  1220. 	$linkedFilters = array('keyword_id' => $keywordsFilter->items);

    1221. 

  1221. 	$tplan_tcases = $tplan_mgr->get_linked_tcversions($tplan_id,$linkedFilters);

    1222. 

  1222. 	if (is_null($tplan_tcases))

    1223. 

  1223. 	{

    1224. 

  1224. 		$tplan_tcases = array();

    1225. 

  1225. 	}

    1226. 

  1226. 	$test_spec['name'] = $tproject_name;

    1227. 

  1227. 	$test_spec['id'] = $tproject_id;

    1228. 

  1228. 	$test_spec['node_type_id'] = $hash_descr_id['testproject'];

    1229. 

  1229. 	$map_node_tccount=array(); 

    1230. 

  1230. 	

    1231. 

  1231. 	if($test_spec)

    1232. 

  1232. 	{

    1233. 

  1233. 		$tck_map = null;

    1234. 

  1234. 		

    1235. 

  1235. 		if(!is_null($keywordsFilter))

    1236. 

  1236. 		{

    1237. 

  1237. 			$tck_map = $tproject_mgr->get_keywords_tcases($tproject_id,

    1238. 

  1238. 				$keywordsFilter->items,$keywordsFilter->type);

    1239. 

  1239. 		}	

    1240. 

  1240. 		//@TODO: schlundus, can we speed up with NO_EXTERNAL?

    1241. 

  1241. 		$filters = null;

    1242. 

  1242. 		$options = array('hideTestCases' => 0, 'viewType' => 'executionTree');

    1243. 

  1243. 		$testcase_counters = prepareNode($db,$test_spec,$decoding_hash,$map_node_tccount,

    1244. 

  1244. 			                             $tck_map,$tplan_tcases,$filters,$options);

    1245. 

  1245. 		

    1246. 

  1246. 		$test_spec['testcase_count'] = $testcase_counters['testcase_count'];

    1247. 

  1247. 	}

    1248. 

  1248. 	

    1249. 

  1249. 	return($map_node_tccount);

    1250. 

  1250. }

    1251. 

  1251. 

    1252. 

  1252. 

    1253. 

  1253. function create_counters_info(&$node,$useColors)

    1254. 

  1254. {

    1255. 

  1255. 	$resultsCfg=config_g…
    1256.

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