function importTestCaseDataFromXML(&$db, $fileName, $parentID, $tproject_id, $userID, $options = null)
{
    tLog('importTestCaseDataFromXML called for file: ' . $fileName);
    $xmlTCs = null;
    $resultMap = null;
    $my = array();
    $my['options'] = array('useRecursion' => false, 'importIntoProject' => 0, 'duplicateLogic' => array('hitCriteria' => 'name', 'actionOnHit' => null));
    $my['options'] = array_merge($my['options'], (array) $options);
    foreach ($my['options'] as $varname => $value) {
        ${$varname} = $value;
    }
    if (file_exists($fileName)) {
        $xml = @simplexml_load_file($fileName);
        if ($xml !== FALSE) {
            $xmlKeywords = $xml->xpath('//keywords');
            $kwMap = null;
            if ($xmlKeywords) {
                $tproject = new testproject($db);
                $loop2do = sizeof($xmlKeywords);
                for ($idx = 0; $idx < $loop2do; $idx++) {
                    $tproject->importKeywordsFromSimpleXML($tproject_id, $xmlKeywords[$idx]);
                }
                $kwMap = $tproject->get_keywords_map($tproject_id);
                $kwMap = is_null($kwMap) ? null : array_flip($kwMap);
            }
            if (!$my['options']['useRecursion'] && $xml->getName() == 'testcases') {
                $resultMap = importTestCasesFromSimpleXML($db, $xml, $parentID, $tproject_id, $userID, $kwMap, $my['options']['duplicateLogic']);
            }
            if ($useRecursion && $xml->getName() == 'testsuite') {
                $resultMap = importTestSuitesFromSimpleXML($db, $xml, $parentID, $tproject_id, $userID, $kwMap, $my['options']);
            }
        }
    }
    return $resultMap;
}

/** Process CVS file contents with requirements into TL
 *  and creates an array with reports
 *  @return array_of_strings list of particular REQ data with resolution comment
 *
 *
 **/
function executeImportedReqs(&$db, $arrImportSource, $map_cur_reqdoc_id, $conflictSolution, $emptyScope, $idSRS, $tprojectID, $userID)
{
    define('SKIP_CONTROLS', 1);
    $req_mgr = new requirement_mgr($db);
    $import_status = null;
    $field_size = config_get('field_size');
    foreach ($arrImportSource as $data) {
        $docID = trim_and_limit($data['docid'], $field_size->req_docid);
        $title = trim_and_limit($data['title'], $field_size->req_title);
        $scope = $data['description'];
        $type = $data['type'];
        $status = $data['status'];
        $expected_coverage = $data['expected_coverage'];
        $node_order = $data['node_order'];
        if ($emptyScope == 'on' && empty($scope)) {
            // skip rows with empty scope
            $import_status = lang_get('req_import_result_skipped');
        } else {
            $crash = $map_cur_reqdoc_id && array_search($docID, $map_cur_reqdoc_id);
            if ($crash) {
                // process conflict according to choosen solution
                tLog('Conflict found. solution: ' . $conflictSolution);
                $import_status['msg'] = 'Error';
                if ($conflictSolution == 'overwrite') {
                    $item = current($req_mgr->getByDocID($docID, $tprojectID));
                    $last_version = $req_mgr->get_last_version_info($item['id']);
                    // BUGID 0003745: CSV Requirements Import Updates Frozen Requirement
                    if ($last_version['is_open'] == 1) {
                        $op = $req_mgr->update($item['id'], $last_version['id'], $docID, $title, $scope, $userID, $status, $type, $expected_coverage, $node_order, SKIP_CONTROLS);
                        if ($op['status_ok']) {
                            $import_status['msg'] = lang_get('req_import_result_overwritten');
                        }
                    } else {
                        $import_status['msg'] = lang_get('req_import_result_skipped_is_frozen');
                    }
                } elseif ($conflictSolution == 'skip') {
                    // no work
                    $import_status['msg'] = lang_get('req_import_result_skipped');
                }
            } else {
                // no conflict - just add requirement
                $import_status = $req_mgr->create($idSRS, $docID, $title, $scope, $userID, $status, $type, $expected_coverage, $node_order);
            }
            $arrImport[] = array('doc_id' => $docID, 'title' => $title, 'import_status' => $import_status['msg']);
        }
    }
    return $arrImport;
}

/**
 * set session data after modification or authorization
 *
 * @param resource &$db reference to DB identifier
 * @param string $user
 * @param integer $id
 * @param integer $roleID 
 * @param string $email 
 * @param string $locale [default = null]
 * @param boolean $active [default = null] documentation
 * 
 * @return integer status code
 * 
 * @TODO havlatm: move to tlSession class
 * @TODO fix return functionality
 **/
function setUserSession(&$db, $user, $id, $roleID, $email, $locale = null, $active = null)
{
    tLog('setUserSession: $user=' . $user . ' $id=' . $id . ' $roleID=' . $roleID . ' $email=' . $email . ' $locale=' . $locale);
    $_SESSION['userID'] = $id;
    $_SESSION['testprojectID'] = null;
    $_SESSION['s_lastAttachmentList'] = null;
    if (!is_null($locale)) {
        $_SESSION['locale'] = $locale;
        setDateTimeFormats($locale);
    }
    $tproject_mgr = new testproject($db);
    $gui_cfg = config_get('gui');
    $opt = array('output' => 'map_name_with_inactive_mark', 'order_by' => $gui_cfg->tprojects_combo_order_by);
    $arrProducts = $tproject_mgr->get_accessible_for_user($id, $opt);
    $tproject_cookie = 'TL_lastTestProjectForUserID_' . $id;
    if (isset($_COOKIE[$tproject_cookie])) {
        if (isset($arrProducts[$_COOKIE[$tproject_cookie]]) && $arrProducts[$_COOKIE[$tproject_cookie]]) {
            $_SESSION['testprojectID'] = $_COOKIE[$tproject_cookie];
            tLog('Cookie: {$tproject_cookie}=' . $_SESSION['testprojectID']);
        }
    }
    if (!$_SESSION['testprojectID']) {
        $tpID = null;
        if (sizeof($arrProducts)) {
            $tpID = key($arrProducts);
        }
        $_SESSION['testprojectID'] = $tpID;
    }
    // Validation is done in navBar.php
    $tplan_cookie = 'TL_lastTestPlanForUserID_' . $id;
    if (isset($_COOKIE[$tplan_cookie])) {
        $_SESSION['testplanID'] = $_COOKIE[$tplan_cookie];
        tLog("Cookie: {$tplan_cookie}=" . $_SESSION['testplanID']);
    }
    return 1;
}

 *
 * @internal Revisions:
 * 20101010 - franciscom - added testsuite_id as parameter, needed to do checks when creating test case
 * 20100225 - eloff - initial commit
 *
 **/
require_once '../../config.inc.php';
require_once 'common.php';
testlinkInitPage($db);
$data = array('success' => true, 'message' => '');
$iParams = array("name" => array(tlInputParameter::STRING_N, 0, 100), "testcase_id" => array(tlInputParameter::INT), "testsuite_id" => array(tlInputParameter::INT));
$args = G_PARAMS($iParams);
if (has_rights($db, 'mgt_view_tc')) {
    $tree_manager = new tree($db);
    $node_types_descr_id = $tree_manager->get_available_node_types();
    // To allow name check when creating a NEW test case => we do not have test case id
    $args['testcase_id'] = $args['testcase_id'] > 0 ? $args['testcase_id'] : null;
    $args['testsuite_id'] = $args['testsuite_id'] > 0 ? $args['testsuite_id'] : null;
    // for debug -
    // $xx = "\$args['testcase_id']:{$args['testcase_id']} - \$args['name']:{$args['name']}" .
    //       " - \$args['testsuite_id']:{$args['testsuite_id']}";
    // file_put_contents('c:\checkTCaseDuplicateName.php.ajax', $xx);
    $check = $tree_manager->nodeNameExists($args['name'], $node_types_descr_id['testcase'], $args['testcase_id'], $args['testsuite_id']);
    $data['success'] = !$check['status'];
    $data['message'] = $check['msg'];
} else {
    tLog('User has not right needed to do requested action - checkTCaseDuplicateName.php', 'ERROR');
    $data['success'] = false;
    $data['message'] = lang_get('user_has_no_right_for_action');
}
echo json_encode($data);

require '../../config.inc.php';
require_once 'common.php';
require_once 'displayMgr.php';
$timerOn = microtime(true);
$templateCfg = templateConfiguration();
$args = init_args($db);
$tplan_mgr = new testplan($db);
$gui = initializeGui($db, $args, $tplan_mgr);
$mailCfg = buildMailCfg($gui);
$metricsMgr = new tlTestPlanMetrics($db);
$dummy = $metricsMgr->getStatusTotalsByTopLevelTestSuiteForRender($args->tplan_id);
if (is_null($dummy)) {
    // no test cases -> no report
    $gui->do_report['status_ok'] = 0;
    $gui->do_report['msg'] = lang_get('report_tspec_has_no_tsuites');
    tLog('Overall Metrics page: no test cases defined');
} else {
    // do report
    $gui->statistics->testsuites = $dummy->info;
    $gui->do_report['status_ok'] = 1;
    $gui->do_report['msg'] = '';
    $items2loop = array('testsuites', 'keywords');
    $keywordsMetrics = $metricsMgr->getStatusTotalsByKeywordForRender($args->tplan_id);
    $gui->statistics->keywords = !is_null($keywordsMetrics) ? $keywordsMetrics->info : null;
    if ($gui->showPlatforms) {
        $items2loop[] = 'platform';
        $platformMetrics = $metricsMgr->getStatusTotalsByPlatformForRender($args->tplan_id);
        $gui->statistics->platform = !is_null($platformMetrics) ? $platformMetrics->info : null;
    }
    if ($gui->testprojectOptions->testPriorityEnabled) {
        $items2loop[] = 'priorities';

 /**
  *
  *
  **/
 function checkCfg()
 {
     $status_ok = true;
     if (property_exists($this->cfg, 'projectkey')) {
         $pk = trim((string) $this->cfg->projectkey);
         if ($pk == '') {
             $status_ok = false;
             $msg = __CLASS__ . ' - Empty configuration: <projectKey>';
         }
     } else {
         // this is oK if user only wants to LINK issues
         $this->cfg->projectkey = self::NOPROJECTKEY;
     }
     if (!$status_ok) {
         tLog(__METHOD__ . ' / ' . $msg, 'ERROR');
     }
     return $status_ok;
 }

 /**
  * establishes the database connection to the bugtracking system
  *
  * @return bool returns true if the db connection was established and the
  * db could be selected, false else
  *
  **/
 function connect()
 {
     if (is_null($this->cfg->dbhost) || is_null($this->cfg->dbuser)) {
         return false;
     }
     // cast everything to string in order to avoid issues
     // @20140604 someone has been issues trying to connect to JIRA on MSSQL
     $this->cfg->dbtype = strtolower((string) $this->cfg->dbtype);
     $this->cfg->dbhost = (string) $this->cfg->dbhost;
     $this->cfg->dbuser = (string) $this->cfg->dbuser;
     $this->cfg->dbpassword = (string) $this->cfg->dbpassword;
     $this->cfg->dbname = (string) $this->cfg->dbname;
     $this->dbConnection = new database($this->cfg->dbtype);
     $result = $this->dbConnection->connect(false, $this->cfg->dbhost, $this->cfg->dbuser, $this->cfg->dbpassword, $this->cfg->dbname);
     if (!$result['status']) {
         $this->dbConnection = null;
         $connection_args = "(interface: - Host:{$this->cfg}->dbhost - " . "DBName: {$this->cfg}->dbname - User: {$this->cfg}->dbuser) ";
         $msg = sprintf(lang_get('BTS_connect_to_database_fails'), $connection_args);
         tLog($msg . $result['dbms_msg'], 'ERROR');
     } elseif ($this->cfg->dbtype == 'mysql') {
         if ($this->cfg->dbcharset == 'UTF-8') {
             $r = $this->dbConnection->exec_query("SET CHARACTER SET utf8");
             $r = $this->dbConnection->exec_query("SET NAMES utf8");
             $r = $this->dbConnection->exec_query("SET collation_connection = 'utf8_general_ci'");
         } else {
             $r = $this->dbConnection->exec_query("SET CHARACTER SET " . $this->cfg->dbcharset);
             $r = $this->dbConnection->exec_query("SET NAMES " . $this->cfg->dbcharset);
         }
     }
     $this->connected = $result['status'] ? true : false;
     return $this->connected;
 }

/**
 *
 * $event->message
 * $event->logLevel
 * $event->source
 * $event->objectID
 * $event->objectType
 * $event->code
 *
 */
function logEvent($event)
{
    return tLog($event->message, $event->logLevel, $event->source, $event->objectID, $event->objectType, $event->code);
}

/**
 * Generate HTML header and send it to browser
 * @param string $format identifier of document format; value must be in $tlCfg->reports_formats
 * @param integer $doc_kind Magic number of document kind; see consts.inc.php for list 
 *    (for example: DOC_TEST_PLAN_DESIGN)
 * @author havlatm
 */
function flushHttpHeader($format, $doc_kind = 0)
{
    $file_extensions = config_get('reports_file_extension');
    $reports_applications = config_get('reports_applications');
    switch ($doc_kind) {
        case DOC_TEST_SPEC:
            $kind_acronym = '_test_spec';
            break;
        case DOC_TEST_PLAN_DESIGN:
            $kind_acronym = '_test_plan';
            break;
        case DOC_TEST_PLAN_EXECUTION:
            $kind_acronym = '_test_report';
            break;
        case DOC_REQ_SPEC:
            $kind_acronym = '_req_spec';
            break;
        default:
            $kind_acronym = '';
            break;
    }
    if ($format == FORMAT_MAIL_HTML) {
        tLog('flushHttpHeader> Invalid format: ' . $format, 'ERROR');
    }
    $filename = isset($_SESSION['testprojectPrefix']) ? $_SESSION['testprojectPrefix'] : '';
    $filename .= $kind_acronym . '-' . date('Y-m-d') . '.' . $file_extensions[$format];
    tLog('Flush HTTP header for ' . $format);
    $contentType = isset($reports_applications[$format]) ? $reports_applications[$format] : 'text/html';
    $contentType .= is_null($format) || $format == '' ? '' : "; name='Testlink_" . $format . "'";
    header("Content-type: {$contentType}");
    header("Content-Description: TestLink - Generated Document (see " . __FUNCTION__ . ")");
    if (!is_null($format) && $format != '' && $format != FORMAT_HTML) {
        header("Content-Disposition: attachment; filename={$filename}");
    }
    flush();
}

 /**
  * 
  * @param $feature_map
  * $feature_map['feature_id']['user_id']
  * $feature_map['feature_id']['type']
  * $feature_map['feature_id']['status']
  * $feature_map['feature_id']['assigner_id']
  * $feature_map['feature_id']['build_id']
  * 
  *
  * Need to manage situation where user_id = 0 is passed
  * I will IGNORE IT
  *
  * @internal revisions
  */
 function assign($feature_map)
 {
     $debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
     $ret = array();
     $types = $this->get_available_types();
     $safe = null;
     foreach ($feature_map as $feature_id => $elem) {
         $safe['feature_id'] = intval($feature_id);
         $safe['build_id'] = intval($elem['build_id']);
         $safe['type'] = intval($elem['type']);
         $uSet = (array) $elem['user_id'];
         foreach ($uSet as $user_id) {
             $safe['user_id'] = intval($user_id);
             // Check if exists before adding
             $check = "/* {$debugMsg} */ ";
             $check .= " SELECT id FROM {$this->tables['user_assignments']} " . " WHERE feature_id = " . $safe['feature_id'] . " AND build_id = " . $safe['build_id'] . " AND type = " . $safe['type'] . " AND user_id = " . $safe['user_id'];
             $rs = $this->db->get_recordset($check);
             if (is_null($rs) || count($rs) == 0) {
                 if ($safe['user_id'] > 0) {
                     $sql = "INSERT INTO {$this->tables['user_assignments']} " . "(feature_id,user_id,assigner_id,type,status,creation_ts";
                     $values = "VALUES({$safe['feature_id']},{$safe['user_id']}," . "{$elem['assigner_id']}," . "{$safe['type']},{$elem['status']},";
                     $values .= isset($elem['creation_ts']) ? $elem['creation_ts'] : $this->db->db_now();
                     if (isset($elem['deadline_ts'])) {
                         $sql .= ",deadline_ts";
                         $values .= "," . $elem['deadline_ts'];
                     }
                     if (isset($elem['build_id'])) {
                         $sql .= ",build_id";
                         $values .= "," . $safe['build_id'];
                     } else {
                         if ($safe['type'] == $types['testcase_execution']['id']) {
                             throw new Exception("Error Processing Request - BUILD ID is Mandatory");
                         }
                     }
                     $sql .= ") " . $values . ")";
                     tLog(__METHOD__ . '::' . $sql, "DEBUG");
                     $this->db->exec_query($sql);
                     $ret[] = $sql;
                 }
             }
         }
         // loop over users
     }
     return $ret;
 }

 /** 
  * execute SQL query, 
  * requires connection to be opened
  * 
  * @param string $p_query SQL request
  * @param integer $p_limit (optional) number of rows
  * @param integer $p_offset (optional) begining row number
  * 
  * @return boolean result of request 
  **/
 function exec_query($p_query, $p_limit = -1, $p_offset = -1)
 {
     $ec = 0;
     $emsg = null;
     $logLevel = 'DEBUG';
     $message = '';
     if ($this->logQueries) {
         $this->nQuery++;
         $t_start = $this->microtime_float();
     }
     if ($p_limit != -1 || $p_offset != -1) {
         $t_result = $this->db->SelectLimit($p_query, $p_limit, $p_offset);
     } else {
         $t_result = $this->db->Execute($p_query);
     }
     if ($this->logQueries) {
         $t_elapsed = number_format($this->microtime_float() - $t_start, 4);
         $this->overallDuration += $t_elapsed;
         $message = "SQL [" . $this->nQuery . "] executed [took {$t_elapsed} secs]" . "[all took {$this->overallDuration} secs]:\n\t\t";
     }
     $message .= $p_query;
     if (!$t_result) {
         $ec = $this->error_num();
         $emsg = $this->error_msg();
         $message .= "\nQuery failed: errorcode[" . $ec . "]" . "\n\terrormsg:" . $emsg;
         $logLevel = 'ERROR';
         tLog("ERROR ON exec_query() - database.class.php <br />" . $this->error(htmlspecialchars($p_query)) . "<br />THE MESSAGE : {$message} ", 'ERROR', "DATABASE");
         echo "<pre> ============================================================================== </pre>";
         echo "<pre> DB Access Error - debug_print_backtrace() OUTPUT START </pre>";
         echo "<pre> ATTENTION: Enabling more debug info will produce path disclosure weakness (CWE-200) </pre>";
         echo "<pre>            Having this additional Information could be useful for reporting </pre>";
         echo "<pre>            issue to development TEAM. </pre>";
         echo "<pre> ============================================================================== </pre>";
         if (defined('DBUG_ON') && DBUG_ON == 1) {
             echo "<pre>";
             debug_print_backtrace();
             echo "</pre>";
         }
         //else
         //{
         //  echo "<pre>"; debug_print_backtrace(DEBUG_BACKTRACE_IGNORE_ARGS); echo "</pre>";
         //}
         echo "<pre> ============================================================================== </pre>";
         $t_result = false;
     }
     if ($this->logEnabled) {
         tLog($message, $logLevel, "DATABASE");
     }
     if ($this->logQueries) {
         array_push($this->queries_array, array($p_query, $t_elapsed, $ec, $emsg));
     }
     return $t_result;
 }

function logWarningEvent($message, $activityCode = null, $objectID = null, $objectType = null)
{
    return tLog($message, "WARNING", "GUI", $objectID, $objectType, $activityCode);
}

 /**
  * @param integer $value the value which should be validated
  * @return bool return true if the value was successfully validated, else throws an Exception
  */
 public function validate($value)
 {
     $msg = 'Input parameter validation failed';
     if (!is_numeric($value)) {
         $msg = "{$msg} [numeric: " . htmlspecialchars($value) . "]";
         tLog($msg, 'ERROR');
         throw new Exception($msg);
     }
     $value = intval($value);
     $minVal = $this->minVal;
     if ($value < $minVal) {
         $msg = "{$msg} [minVal: " . htmlspecialchars($value) . " = {$minVal}]";
         tLog($msg, 'ERROR');
         throw new Exception($msg);
     }
     $maxVal = $this->maxVal;
     if ($value > $maxVal) {
         $msg = "{$msg} [maxVal: " . htmlspecialchars($value) . " = {$maxVal}]";
         tLog($msg, 'ERROR');
         throw new Exception($msg);
     }
     $pfnValidation = $this->pfnValidation;
     if ($pfnValidation && !$pfnValidation($value)) {
         $msg = "{$msg} [external function]";
         tLog($msg, 'ERROR');
         throw new Exception($msg);
     }
     return true;
 }

 /**
  * Unserialize project options
  * 
  * @param array $recorset produced by getTestProject() 
  */
 protected function parseTestProjectRecordset(&$recordset)
 {
     if (count($recordset) > 0) {
         foreach ($recordset as $number => $row) {
             $recordset[$number]['opt'] = unserialize($row['options']);
         }
     } else {
         $recordset = null;
         tLog('parseTestProjectRecordset: No project on query', 'DEBUG');
     }
 }

/**
 * get user name from pool (save used names in session to improve performance)
 * 
 * @param integer $db DB connection identifier 
 * @param integer $userId
 * 
 * @return string readable user name
 * @author havlatm
 */
function gendocGetUserName(&$db, $userId)
{
    $authorName = null;
    if (isset($_SESSION['userNamePool'][$userId])) {
        $authorName = $_SESSION['userNamePool'][$userId];
    } else {
        $user = tlUser::getByID($db, $userId);
        if ($user) {
            $authorName = $user->getDisplayName();
            $authorName = htmlspecialchars($authorName);
            $_SESSION['userNamePool'][$userId] = $authorName;
        } else {
            $authorName = lang_get('undefined');
            tLog('tlUser::getByID($db,$userId) failed', 'ERROR');
        }
    }
    return $authorName;
}

 function create_tc_from_requirement($mixIdReq, $srs_id, $user_id, $tproject_id = null, $tc_count = null)
 {
     $debugMsg = 'Class:' . __CLASS__ . ' - Method: ' . __FUNCTION__;
     $tcase_mgr = new testcase($this->db);
     $tsuite_mgr = new testsuite($this->db);
     $req_cfg = config_get('req_cfg');
     $field_size = config_get('field_size');
     $auto_testsuite_name = $req_cfg->default_testsuite_name;
     $node_descr_type = $this->tree_mgr->get_available_node_types();
     $empty_steps = null;
     $empty_preconditions = '';
     // fix for BUGID 2995
     $labels['tc_created'] = lang_get('tc_created');
     $output = null;
     $reqSet = is_array($mixIdReq) ? $mixIdReq : array($mixIdReq);
     /* contribution BUGID 2996, testcase creation */
     if (is_null($tproject_id) || $tproject_id == 0) {
         $tproject_id = $this->tree_mgr->getTreeRoot($srs_id);
     }
     if ($req_cfg->use_req_spec_as_testsuite_name) {
         $full_path = $this->tree_mgr->get_path($srs_id);
         $addition = " (" . lang_get("testsuite_title_addition") . ")";
         $truncate_limit = $field_size->testsuite_name - strlen($addition);
         // REQ_SPEC_A
         //           |-- REQ_SPEC_A1
         //                          |-- REQ_SPEC_A2
         //                                         |- REQ100
         //                                         |- REQ101
         //
         // We will try to check if a test suite has already been created for
         // top REQ_SPEC_A  (we do search using automatic generated name as search criteria).
         // If not => we need to create all path till leaves (REQ100 and REQ200)
         //
         //
         // First search: we use test project
         $parent_id = $tproject_id;
         $deep_create = false;
         foreach ($full_path as $key => $node) {
             // follow hierarchy of test suites to create
             $tsuiteInfo = null;
             $testsuite_name = substr($node['name'], 0, $truncate_limit) . $addition;
             if (!$deep_create) {
                 // child test suite with this name, already exists on current parent ?
                 // At first a failure we will not check anymore an proceed with deep create
                 $sql = "/* {$debugMsg} */ SELECT id,name FROM {$this->tables['nodes_hierarchy']} NH " . " WHERE name='" . $this->db->prepare_string($testsuite_name) . "' " . " AND node_type_id=" . $node_descr_type['testsuite'] . " AND parent_id = {$parent_id} ";
                 // If returns more that one record use ALWAYS first
                 $tsuiteInfo = $this->db->fetchRowsIntoMap($sql, 'id');
             }
             if (is_null($tsuiteInfo)) {
                 $tsuiteInfo = $tsuite_mgr->create($parent_id, $testsuite_name, $req_cfg->testsuite_details);
                 $output[] = sprintf(lang_get('testsuite_name_created'), $testsuite_name);
                 $deep_create = true;
             } else {
                 $tsuiteInfo = current($tsuiteInfo);
                 $tsuite_id = $tsuiteInfo['id'];
             }
             $tsuite_id = $tsuiteInfo['id'];
             // last value here will be used as parent for test cases
             $parent_id = $tsuite_id;
         }
         $output[] = sprintf(lang_get('created_on_testsuite'), $testsuite_name);
     } else {
         // don't use req_spec as testsuite name
         // Warning:
         // We are not maintaining hierarchy !!!
         $sql = " SELECT id FROM {$this->tables['nodes_hierarchy']} NH " . " WHERE name='" . $this->db->prepare_string($auto_testsuite_name) . "' " . " AND parent_id=" . $testproject_id . " " . " AND node_type_id=" . $node_descr_type['testsuite'];
         $result = $this->db->exec_query($sql);
         if ($this->db->num_rows($result) == 1) {
             $row = $this->db->fetch_array($result);
             $tsuite_id = $row['id'];
             $label = lang_get('created_on_testsuite');
         } else {
             // not found -> create
             tLog('test suite:' . $auto_testsuite_name . ' was not found.');
             $new_tsuite = $tsuite_mgr->create($testproject_id, $auto_testsuite_name, $req_cfg->testsuite_details);
             $tsuite_id = $new_tsuite['id'];
             $label = lang_get('testsuite_name_created');
         }
         $output[] = sprintf($label, $auto_testsuite_name);
     }
     /* end contribution */
     // create TC
     $createOptions = array();
     $createOptions['check_names_for_duplicates'] = config_get('check_names_for_duplicates');
     $createOptions['action_on_duplicate_name'] = config_get('action_on_duplicate_name');
     $testcase_importance_default = config_get('testcase_importance_default');
     // compute test case order
     $testcase_order = config_get('treemenu_default_testcase_order');
     $nt2exclude = array('testplan' => 'exclude_me', 'requirement_spec' => 'exclude_me', 'requirement' => 'exclude_me');
     $siblings = $this->tree_mgr->get_children($tsuite_id, $nt2exclude);
     if (!is_null($siblings)) {
         $dummy = end($siblings);
         $testcase_order = $dummy['node_order'];
     }
     foreach ($reqSet as $reqID) {
         $reqData = $this->get_by_id($reqID, requirement_mgr::LATEST_VERSION);
         $count = !is_null($tc_count) ? $tc_count[$reqID] : 1;
         $reqData = $reqData[0];
         // Generate name with progessive
         $instance = 1;
//.........这里部分代码省略.........

/**
 * Load global configuration to function
 * 
 * @param string $config_id key for identification of configuration parameter
 * @return mixed the configuration parameter(s)
 * 
 * @internal Revisions
 */
function config_get($config_id)
{
    $t_value = '';
    $t_found = false;
    $logInfo = array('msg' => "config option not available: {$config_id}", 'level' => 'WARNING');
    if (!$t_found) {
        $my = "g_" . $config_id;
        if ($t_found = isset($GLOBALS[$my])) {
            $t_value = $GLOBALS[$my];
        } else {
            $cfg = $GLOBALS['tlCfg'];
            if ($t_found = property_exists($cfg, $config_id)) {
                $t_value = $cfg->{$config_id};
            }
        }
        if ($t_found) {
            $logInfo = array('msg' => "config option: {$config_id} is {$t_value}", 'level' => 'INFO');
        }
    }
    tLog($logInfo['msg'], $logInfo['level']);
    return $t_value;
}

$reports_mgr = new tlReports($db, $gui->tplan_id);
// -----------------------------------------------------------------------------
// Do some checks to understand if reports make sense
// Check if there are linked test cases to the choosen test plan.
$tc4tp_count = 1;
//$reports_mgr->get_count_testcase4testplan();
tLog('TC in TP count = ' . $tc4tp_count);
if ($tc4tp_count == 0) {
    // Test plan without test cases
    $gui->do_report['status_ok'] = 0;
    $gui->do_report['msg'] = lang_get('report_tplan_has_no_tcases');
}
// Build qty
$build_count = 1;
//$reports_mgr->get_count_builds();
tLog('Active Builds count = ' . $build_count);
if ($build_count == 0) {
    // Test plan without builds can have execution data
    $gui->do_report['status_ok'] = 0;
    $gui->do_report['msg'] = lang_get('report_tplan_has_no_build');
}
// -----------------------------------------------------------------------------
// get navigation data
$gui->menuItems = array();
if ($gui->do_report['status_ok']) {
    // create a list or reports
    $context = new stdClass();
    $context->tproject_id = $args->tproject_id;
    $context->tplan_id = $args->tplan_id;
    $tplan_mgr = new testplan($db);
    $dmy = $tplan_mgr->get_by_id($context->tplan_id);

 function TLSmarty()
 {
     global $tlCfg;
     global $g_locales_html_select_date_field_order;
     global $g_locales_date_format;
     global $g_locales_timestamp_format;
     // $this->Smarty();
     parent::__construct();
     $this->template_dir = TL_ABS_PATH . 'gui/templates/';
     $this->compile_dir = TL_TEMP_PATH;
     $this->config_dir = TL_ABS_PATH . 'gui/templates/';
     $testproject_coloring = $tlCfg->gui->testproject_coloring;
     $testprojectColor = $tlCfg->gui->background_color;
     //TL_BACKGROUND_DEFAULT;
     if (isset($_SESSION['testprojectColor'])) {
         $testprojectColor = $_SESSION['testprojectColor'];
         if ($testprojectColor == "") {
             $testprojectColor = $tlCfg->gui->background_color;
         }
     }
     $this->assign('testprojectColor', $testprojectColor);
     $my_locale = isset($_SESSION['locale']) ? $_SESSION['locale'] : TL_DEFAULT_LOCALE;
     $basehref = isset($_SESSION['basehref']) ? $_SESSION['basehref'] : TL_BASE_HREF;
     if ($tlCfg->smarty_debug) {
         $this->debugging = true;
         tLog("Smarty debug window = ON");
     }
     // -------------------------------------------------------------------------------------
     // Must be initialized to avoid log on TestLink Event Viewer due to undefined variable.
     // This means that optional/missing parameters on include can not be used.
     //
     // Good refactoring must be done in future, to create group of this variable
     // with clear names that must be a hint for developers, to understand where this
     // variables are used.
     // inc_head.tpl
     $this->assign('SP_html_help_file', null);
     $this->assign('menuUrl', null);
     $this->assign('args', null);
     $this->assign('additionalArgs', null);
     $this->assign('pageTitle', null);
     $this->assign('css_only', null);
     $this->assign('body_onload', null);
     // inc_attachments.tpl
     $this->assign('attach_tableStyles', "font-size:12px");
     $this->assign('attach_tableClassName', "simple");
     $this->assign('attach_inheritStyle', 0);
     $this->assign('attach_show_upload_btn', 1);
     $this->assign('attach_show_title', 1);
     $this->assign('attach_downloadOnly', false);
     // inc_help.tpl
     $this->assign('inc_help_alt', null);
     $this->assign('inc_help_title', null);
     $this->assign('inc_help_style', null);
     $this->assign('show_help_icon', true);
     $this->assign('tplan_name', null);
     $this->assign('name', null);
     // -----------------------------------------------------------------------------
     $this->assign('basehref', $basehref);
     $this->assign('css', $basehref . TL_TESTLINK_CSS);
     $this->assign('locale', $my_locale);
     // -----------------------------------------------------------------------------
     // load configuration
     $this->assign('session', isset($_SESSION) ? $_SESSION : null);
     // load configuration
     $this->assign('tlCfg', $tlCfg);
     $this->assign('gsmarty_gui', $tlCfg->gui);
     $this->assign('gsmarty_spec_cfg', config_get('spec_cfg'));
     $this->assign('gsmarty_attachments', config_get('attachments'));
     $this->assign('pageCharset', $tlCfg->charset);
     $this->assign('tlVersion', TL_VERSION);
     $this->assign('gsmarty_bugInterfaceOn', config_get('bugInterfaceOn'));
     $this->assign('testproject_coloring', null);
     // -----------------------------------------------------------------------------
     // define a select structure for {html_options ...}
     $this->assign('gsmarty_option_yes_no', array(0 => lang_get('No'), 1 => lang_get('Yes')));
     $this->assign('gsmarty_option_priority', array(HIGH => lang_get('high_priority'), MEDIUM => lang_get('medium_priority'), LOW => lang_get('low_priority')));
     $this->assign('gsmarty_option_importance', array(HIGH => lang_get('high_importance'), MEDIUM => lang_get('medium_importance'), LOW => lang_get('low_importance')));
     // this allows unclosed <head> tag to add more information and link; see inc_head.tpl
     $this->assign('openHead', 'no');
     // there are some variables which should not be assigned for template
     // but must be initialized
     // inc_head.tpl
     $this->assign('jsValidate', null);
     $this->assign('jsTree', null);
     $this->assign('editorType', null);
     // user feedback variables (used in inc_update.tpl)
     $this->assign('user_feedback', null);
     $this->assign('feedback_type', '');
     // Possibile values: soft
     $this->assign('action', 'updated');
     //todo: simplify (remove) - use user_feedback
     $this->assign('sqlResult', null);
     //todo: simplify (remove) - use user_feedback
     $this->assign('refresh', 'no');
     $this->assign('result', null);
     $this->assign('optLocale', config_get('locales'));
     $this->assign('gsmarty_href_keywordsView', ' "lib/keywords/keywordsView.php" ' . ' target="mainframe" class="bold" ' . ' title="' . lang_get('menu_manage_keywords') . '"');
     $this->assign('gsmarty_html_select_date_field_order', $g_locales_html_select_date_field_order[$my_locale]);
     $this->assign('gsmarty_date_format', $g_locales_date_format[$my_locale]);
     $this->assign('gsmarty_timestamp_format', $g_locales_timestamp_format[$my_locale]);
//.........这里部分代码省略.........