/** * @param object dbHandler reference to db handler * */ function doImport(&$dbHandler) { $import_msg = array('ok' => array(), 'ko' => array()); $file_check = array('show_results' => 0, 'status_ok' => 0, 'msg' => '', 'filename' => '', 'import_msg' => $import_msg); $key = 'targetFilename'; $dest = TL_TEMP_PATH . session_id() . "-import_cfields.tmp"; $source = isset($_FILES[$key]['tmp_name']) ? $_FILES[$key]['tmp_name'] : null; if ($source != 'none' && $source != '') { $file_check['filename'] = $_FILES[$key]['name']; $file_check['status_ok'] = 1; if (move_uploaded_file($source, $dest)) { $file_check['status_ok'] = !(($xml = @simplexml_load_file($dest)) === FALSE); } if ($file_check['status_ok']) { $file_check['show_results'] = 1; $cfield_mgr = new cfield_mgr($dbHandler); foreach ($xml as $cf) { if (is_null($cfield_mgr->get_by_name($cf->name))) { $cfield_mgr->create((array) $cf); $import_msg['ok'][] = sprintf(lang_get('custom_field_imported'), $cf->name); } else { $import_msg['ko'][] = sprintf(lang_get('custom_field_already_exists'), $cf->name); } } } else { $file_check['msg'] = lang_get('problems_loading_xml_content'); } } else { $file_check = array('show_results' => 0, 'status_ok' => 0, 'msg' => lang_get('please_choose_file_to_import')); } $file_check['import_msg'] = $import_msg; return $file_check; }
/** * write execution result to DB * * @param resource &$db reference to database handler * @param obj &$exec_signature object with tproject_id,tplan_id,build_id,platform_id,user_id * * @internal Revisions: * * * 20100522 - BUGID 3479 - Bulk Execution - Custom Fields Bulk Assignment */ function write_execution(&$db, &$exec_signature, &$exec_data, $map_last_exec) { $executions_table = DB_TABLE_PREFIX . 'executions'; $resultsCfg = config_get('results'); // $bugInterfaceOn = config_get('bugInterfaceOn'); $db_now = $db->db_now(); $cfield_mgr = new cfield_mgr($db); $cf_prefix = $cfield_mgr->get_name_prefix(); $len_cfp = tlStringLen($cf_prefix); $cf_nodeid_pos = 4; $bulk_notes = ''; $ENABLED = 1; $cf_map = $cfield_mgr->get_linked_cfields_at_execution($exec_signature->tproject_id, $ENABLED, 'testcase'); $has_custom_fields = is_null($cf_map) ? 0 : 1; // extract custom fields id. $map_nodeid_array_cfnames = null; foreach ($exec_data as $input_name => $value) { if (strncmp($input_name, $cf_prefix, $len_cfp) == 0) { $dummy = explode('_', $input_name); $map_nodeid_array_cfnames[$dummy[$cf_nodeid_pos]][] = $input_name; } } if (isset($exec_data['do_bulk_save'])) { // create structure to use common algoritm $item2loop = $exec_data['status']; $is_bulk_save = 1; $bulk_notes = $db->prepare_string(trim($exec_data['bulk_exec_notes'])); } else { $item2loop = $exec_data['save_results']; $is_bulk_save = 0; } foreach ($item2loop as $tcversion_id => $val) { $tcase_id = $exec_data['tc_version'][$tcversion_id]; $current_status = $exec_data['status'][$tcversion_id]; $version_number = $exec_data['version_number'][$tcversion_id]; $has_been_executed = $current_status != $resultsCfg['status_code']['not_run'] ? TRUE : FALSE; if ($has_been_executed) { $my_notes = $is_bulk_save ? $bulk_notes : $db->prepare_string(trim($exec_data['notes'][$tcversion_id])); $sql = "INSERT INTO {$executions_table} " . "(build_id,tester_id,status,testplan_id,tcversion_id," . " execution_ts,notes,tcversion_number,platform_id)" . " VALUES ( {$exec_signature->build_id}, {$exec_signature->user_id}, '{$exec_data['status'][$tcversion_id]}'," . "{$exec_signature->tplan_id}, {$tcversion_id},{$db_now},'{$my_notes}'," . "{$version_number},{$exec_signature->platform_id}" . ")"; $db->exec_query($sql); // at least for Postgres DBMS table name is needed. $execution_id = $db->insert_id($executions_table); if ($has_custom_fields) { // test useful when doing bulk update, because some type of custom fields // like checkbox can not exist on exec_data. => why ?? // $hash_cf = null; $access_key = $is_bulk_save ? 0 : $tcase_id; if (isset($map_nodeid_array_cfnames[$access_key])) { foreach ($map_nodeid_array_cfnames[$access_key] as $cf_v) { $hash_cf[$cf_v] = $exec_data[$cf_v]; } } $cfield_mgr->execution_values_to_db($hash_cf, $tcversion_id, $execution_id, $exec_signature->tplan_id, $cf_map); } } } }
/** * Class constructor * * @param resource &$db reference to the database handler * @param integer project identifier */ function __construct(&$db, $tproject_id) { // you would think we could inherit the parent $db declaration // but it fails to work without this. $this->db =& $db; // instantiate the parent constructor. parent::__construct($this->db); $this->cf_map = $this->get_linked_cfields($tproject_id); }
function writeCustomFieldsToDB(&$db, $tprojectID, $tsuiteID, &$hash) { $ENABLED = 1; $NO_FILTERS = null; $cfield_mgr = new cfield_mgr($db); $cf_map = $cfield_mgr->get_linked_cfields_at_design($tprojectID, $ENABLED, $NO_FILTERS, 'testsuite'); $cfield_mgr->design_values_to_db($hash, $tsuiteID, $cf_map); }
function do_remote_execution(&$dbHandler, $context) { $debugMsg = "File:" . __FILE__ . " Function: " . __FUNCTION__; $tables = array(); $tables['executions'] = DB_TABLE_PREFIX . 'executions'; $resultsCfg = config_get('results'); $tc_status = $resultsCfg['status_code']; $tree_mgr = new tree($dbHandler); $cfield_mgr = new cfield_mgr($dbHandler); $ret = null; $executionResults = array(); $myResult = array(); $sql = " /* {$debugMsg} */ INSERT INTO {$tables['executions']} " . " (testplan_id,platform_id,build_id,tester_id,execution_type," . " tcversion_id,execution_ts,status,notes) " . " VALUES ({$context['tplan_id']}, {$context['platform_id']}, {$context['build_id']}," . " {$context['user_id']}," . testcase::EXECUTION_TYPE_AUTO . ","; // have we got multiple test cases to execute ? $target =& $context['target']; foreach ($target['tc_versions'] as $version_id => $tcase_id) { $ret[$version_id] = array("verboseID" => null, "status" => null, "notes" => null, "system" => null, "scheduled" => null, "timestamp" => null); $tcaseInfo = $tree_mgr->get_node_hierarchy_info($tcase_id); $tcaseInfo['version_id'] = $version_id; // For each test case version we can have a different server config $serverCfg = $cfield_mgr->getXMLRPCServerParams($version_id, $target['feature_id'][$version_id]); $execResult[$version_id] = executeTestCase($tcaseInfo, $serverCfg, $context['context']); // RPC call $tryWrite = false; switch ($execResult[$version_id]['system']['status']) { case 'configProblems': $tryWrite = false; break; case 'connectionFailure': $tryWrite = false; break; case 'ok': $tryWrite = true; break; } if ($tryWrite) { $trun =& $execResult[$version_id]['execution']; if ($trun['scheduled'] == 'now') { $ret[$version_id]["status"] = strtolower($trun['result']); $ret[$version_id]["notes"] = trim($trun['notes']); $notes = $dbHandler->prepare_string($ret[$version_id]["notes"]); if ($ret[$version_id]["status"] != $tc_status['passed'] && $ret[$version_id]["status"] != $tc_status['failed'] && $ret[$version_id]["status"] != $tc_status['blocked']) { $ret[$version_id]["status"] = $tc_status['blocked']; } // $sql2exec = $sql . $version_id . "," . $dbHandler->db_now() . ", '{$ret[$version_id]["status"]}', '{$notes}' )"; $dbHandler->exec_query($sql2exec); } else { $ret[$version_id]["notes"] = trim($execResult[$version_id]['notes']); $ret[$version_id]["scheduled"] = $execResult[$version_id]['scheduled']; $ret[$version_id]["timestamp"] = $execResult[$version_id]['timestampISO']; } } else { $ret[$version_id]["system"] = $execResult[$version_id]['system']; } } return $ret; }
/** * Update value of Custom Field with scope='design' * for a given Test Suite * * @param struct $args * @param string $args["devKey"]: used to check if operation can be done. * if devKey is not valid => abort. * * @param string $args["testsuiteid"]: * @param string $args["testprojectid"]: * @param string $args["customfields"] * contains an map with key:Custom Field Name, value: value for CF. * VERY IMPORTANT: value must be formatted in the way it's written to db, * this is important for types like: * * DATE: strtotime() * DATETIME: mktime() * MULTISELECTION LIST / CHECKBOX / RADIO: se multipli selezione ! come separatore * * * these custom fields must be configured to be writte during execution. * If custom field do not meet condition value will not be written * * @return mixed null if everything ok, else array of IXR_Error objects * * @access public */ public function updateTestSuiteCustomFieldDesignValue($args) { $msg_prefix = "(" . __FUNCTION__ . ") - "; $this->_setArgs($args); $checkFunctions = array('authenticate', 'checkTestProjectID', 'checkTestSuiteID'); $status_ok = $this->_runChecks($checkFunctions, $msg_prefix); if ($status_ok) { if (!$this->_isParamPresent(self::$customFieldsParamName)) { $status_ok = false; $msg = sprintf(MISSING_REQUIRED_PARAMETER_STR, self::$customFieldsParamName); $this->errors[] = new IXR_Error(MISSING_REQUIRED_PARAMETER, $msg); } } if ($status_ok) { // now check if custom fields are ok // For each custom field need to check if: // 1. is linked to test project // 2. is available for Test Suite at design time $cfieldMgr = new cfield_mgr($this->dbObj); // Just ENABLED $linkedSet = $cfieldMgr->get_linked_cfields_at_design($this->args[self::$testProjectIDParamName], cfield_mgr::ENABLED, null, 'testsuite', null, 'name'); if (is_null($linkedSet)) { $status_ok = false; $msg = NO_CUSTOMFIELDS_DT_LINKED_TO_TESTSUITES_STR; $this->errors[] = new IXR_Error(NO_CUSTOMFIELDS_DT_LINKED_TO_TESTSUITES, $msg); } } if ($status_ok) { $cfSet = $args[self::$customFieldsParamName]; foreach ($cfSet as $cfName => $cfValue) { // $accessKey = "custom_field_" . $item['id'] . <field_type_id>_<cfield_id> // design_values_to_db($hash,$node_id,$cf_map=null,$hash_type=null) // // Simple check: if name is not present on set => ignore if (isset($linkedSet[$cfName])) { $item = $linkedSet[$cfName]; $accessKey = "custom_field_" . $item['type'] . '_' . $item['id']; $hash[$accessKey] = $cfValue; $cfieldMgr->design_values_to_db($hash, $itemID); $ret[] = array('status' => 'ok', 'msg' => 'Custom Field:' . $cfName . ' processed '); } else { $ret[] = array('status' => 'ko', 'msg' => 'Custom Field:' . $cfName . ' skipped '); } return $ret; } } else { return $this->errors; } }
/** * TestLink Open Source Project - http://testlink.sourceforge.net/ * This script is distributed under the GNU General Public License 2 or later. * * Filename $RCSfile: cfieldsTprojectAssign.php,v $ * * @version $Revision: 1.11 $ * @modified $Date: 2010/01/21 22:04:18 $ by $Author: franciscom $ * **/ require_once dirname(__FILE__) . "/../../config.inc.php"; require_once "common.php"; testlinkInitPage($db, false, false, "checkRights"); $templateCfg = templateConfiguration(); $args = init_args(); $cfield_mgr = new cfield_mgr($db); switch ($args->doAction) { case 'doAssign': $cfield_ids = array_keys($args->cfield); $cfield_mgr->link_to_testproject($args->testproject_id, $cfield_ids); break; case 'doUnassign': $cfield_ids = array_keys($args->cfield); $cfield_mgr->unlink_from_testproject($args->testproject_id, $cfield_ids); break; case 'doReorder': $cfield_ids = array_keys($args->display_order); $cfield_mgr->set_display_order($args->testproject_id, $args->display_order); if (!is_null($args->location)) { $cfield_mgr->setDisplayLocation($args->testproject_id, $args->location); }
/** * returns map with key: verbose location (see custom field class $locations * value: array with fixed key 'location' * value: location code * */ static function buildCFLocationMap() { return cfield_mgr::buildLocationMap('testcase'); }
<?php /** * TestLink Open Source Project - http://testlink.sourceforge.net/ * This script is distributed under the GNU General Public License 2 or later. * * @filesource cfieldsEdit.php * * @internal revisions * @since 1.9.13 */ require_once dirname(__FILE__) . "/../../config.inc.php"; require_once "common.php"; testlinkInitPage($db, false, false, "checkRights"); $cfield_mgr = new cfield_mgr($db); $templateCfg = templateConfiguration(); $args = init_args(); $gui = new stdClass(); $gui->cfield = null; $gui->cfield_is_used = 0; $gui->cfield_is_linked = 0; $gui->linked_tprojects = null; $gui->cfield_types = $cfield_mgr->get_available_types(); $result_msg = null; $do_control_combo_display = 1; $cfieldCfg = cfieldCfgInit($cfield_mgr); // Changed default values $emptyCF = array('id' => $args->cfield_id, 'name' => '', 'label' => '', 'type' => 0, 'possible_values' => '', 'show_on_design' => 1, 'enable_on_design' => 1, 'show_on_execution' => 0, 'enable_on_execution' => 0, 'show_on_testplan_design' => 0, 'enable_on_testplan_design' => 0, 'node_type_id' => $cfieldCfg->allowed_nodes['testcase']); $gui->cfield = $emptyCF; switch ($args->do_action) { case 'create':
/** * */ function cfForDesign(&$dbHandler, $cfSet) { static $mgr; if (!$mgr) { $mgr = new cfield_mgr($dbHandler); } $ret = null; foreach ($cfSet as $id => $val) { $xx = $mgr->get_by_id($id); if ($xx[$id]['enable_on_design']) { $ret[$id] = $val; } } return $ret; }
<?php /** * TestLink Open Source Project - http://testlink.sourceforge.net/ * This script is distributed under the GNU General Public License 2 or later. * * @filesource cfieldsView.php * * **/ require_once dirname(__FILE__) . "/../../config.inc.php"; require_once "common.php"; testlinkInitPage($db); $templateCfg = templateConfiguration(); $cfield_mgr = new cfield_mgr($db); $args = init_args($db); checkRights($db, $_SESSION['currentUser'], $args); $gui = new stdClass(); $gui->tproject_id = $args->tproject_id; $gui->tproject_name = $args->tproject_name; $gui->cf_map = $cfield_mgr->get_all(); $gui->cf_types = $cfield_mgr->get_available_types(); $smarty = new TLSmarty(); $smarty->assign('gui', $gui); $smarty->display($templateCfg->template_dir . $templateCfg->default_template); /** * create object with all user inputs * * @internal revisions * 20110417 - franciscom - BUGID 4429: Code refactoring to remove global coupling as much as possible */
* 20100508 - franciscom - use of $req_cfg->status_labels * 20100325 - asimon - added html comments with padded numbers/strings for easier and * corrent sorting to columns title/version/coverage/relations * 20100323 - asimon - show columns for relations and coverage only if these features are enabled. * added number of requirement relations to table. * 20100312 - asimon - replaced "100%"-value (in case where req has no coverage) by N/A-string * 20100311 - asimon - fixed a little bug (only notice) when no cfields are defined * 20100310 - asimon - refactoring as requested * 20100309 - asimon - initial commit * */ require_once "../../config.inc.php"; require_once "common.php"; require_once 'exttable.class.php'; testlinkInitPage($db, false, false, "checkRights"); $cfield_mgr = new cfield_mgr($db); $templateCfg = templateConfiguration(); $tproject_mgr = new testproject($db); $req_mgr = new requirement_mgr($db); $args = init_args($tproject_mgr); $gui = init_gui($args); $glue_char = config_get('gui_title_separator_1'); $charset = config_get('charset'); $req_cfg = config_get('req_cfg'); $date_format_cfg = config_get('date_format'); $week_short = lang_get('calendar_week_short'); $time_format_cfg = config_get('timestamp_format'); $coverage_enabled = $req_cfg->expected_coverage_management; $relations_enabled = $req_cfg->relations->enable; $gui->reqIDs = $tproject_mgr->get_all_requirement_ids($args->tproject_id); if (count($gui->reqIDs) > 0) {
/** * write execution result to DB * * @param resource &$db reference to database handler * @param obj &$exec_signature object with tproject_id,tplan_id,build_id,platform_id,user_id * * @internal revisions * */ function write_execution(&$db, &$exec_signature, &$exec_data) { $executions_table = DB_TABLE_PREFIX . 'executions'; $resultsCfg = config_get('results'); $execCfg = config_get('exec_cfg'); $db_now = $db->db_now(); $cfield_mgr = new cfield_mgr($db); $cf_prefix = $cfield_mgr->get_name_prefix(); $len_cfp = tlStringLen($cf_prefix); $cf_nodeid_pos = 4; $bulk_notes = ''; $ENABLED = 1; $cf_map = $cfield_mgr->get_linked_cfields_at_execution($exec_signature->tproject_id, $ENABLED, 'testcase'); $has_custom_fields = is_null($cf_map) ? 0 : 1; // extract custom fields id. $map_nodeid_array_cfnames = null; foreach ($exec_data as $input_name => $value) { if (strncmp($input_name, $cf_prefix, $len_cfp) == 0) { $dummy = explode('_', $input_name); $map_nodeid_array_cfnames[$dummy[$cf_nodeid_pos]][] = $input_name; } } if (isset($exec_data['do_bulk_save'])) { // create structure to use common algoritm $item2loop = $exec_data['status']; $is_bulk_save = 1; $bulk_notes = $db->prepare_string(trim($exec_data['bulk_exec_notes'])); } else { $item2loop = $exec_data['save_results']; $is_bulk_save = 0; } foreach ($item2loop as $tcversion_id => $val) { $tcase_id = $exec_data['tc_version'][$tcversion_id]; $current_status = $exec_data['status'][$tcversion_id]; $version_number = $exec_data['version_number'][$tcversion_id]; $has_been_executed = $current_status != $resultsCfg['status_code']['not_run'] ? TRUE : FALSE; if ($has_been_executed) { $my_notes = $is_bulk_save ? $bulk_notes : $db->prepare_string(trim($exec_data['notes'][$tcversion_id])); $sql = "INSERT INTO {$executions_table} " . "(build_id,tester_id,status,testplan_id,tcversion_id," . " execution_ts,notes,tcversion_number,platform_id,execution_duration)" . " VALUES ( {$exec_signature->build_id}, {$exec_signature->user_id}, '{$exec_data['status'][$tcversion_id]}'," . "{$exec_signature->tplan_id}, {$tcversion_id},{$db_now},'{$my_notes}'," . "{$version_number},{$exec_signature->platform_id}"; if (trim($exec_data['execution_duration']) == '') { $dura = 'NULL '; } else { $dura = floatval($exec_data['execution_duration']); } $sql .= ',' . $dura . ")"; $db->exec_query($sql); // at least for Postgres DBMS table name is needed. $execution_id = $db->insert_id($executions_table); if ($has_custom_fields) { // test useful when doing bulk update, because some type of custom fields // like checkbox can not exist on exec_data. => why ?? // $hash_cf = null; $access_key = $is_bulk_save ? 0 : $tcase_id; if (isset($map_nodeid_array_cfnames[$access_key])) { foreach ($map_nodeid_array_cfnames[$access_key] as $cf_v) { $hash_cf[$cf_v] = $exec_data[$cf_v]; } } $cfield_mgr->execution_values_to_db($hash_cf, $tcversion_id, $execution_id, $exec_signature->tplan_id, $cf_map); } // 20140412 $hasMoreData = new stdClass(); $hasMoreData->step_notes = isset($exec_data['step_notes']); $hasMoreData->step_status = isset($exec_data['step_status']); $hasMoreData->nike = $execCfg->steps_exec && ($hasMoreData->step_notes || $hasMoreData->step_status); if ($hasMoreData->nike) { $target = DB_TABLE_PREFIX . 'execution_tcsteps'; $key2loop = array_keys($exec_data['step_notes']); foreach ($key2loop as $step_id) { $doIt = !is_null($exec_data['step_notes'][$step_id]) && trim($exec_data['step_notes'][$step_id]) != '' || $exec_data['step_status'][$step_id] != $resultsCfg['status_code']['not_run']; if ($doIt) { $sql = " INSERT INTO {$target} (execution_id,tcstep_id,notes"; $values = " VALUES ( {$execution_id}, {$step_id}," . "'" . $db->prepare_string($exec_data['step_notes'][$step_id]) . "'"; $status = strtolower(trim($exec_data['step_status'][$step_id])); $status = $status[0]; if ($status != $resultsCfg['status_code']['not_run']) { $sql .= ",status"; $values .= ",'" . $db->prepare_string($status) . "'"; } $sql .= ") " . $values . ")"; $db->exec_query($sql); } } } } } }
<?php /** * TestLink Open Source Project - http://testlink.sourceforge.net/ * This script is distributed under the GNU General Public License 2 or later. * * @filesource cfieldsTprojectAssign.php * **/ require_once dirname(__FILE__) . "/../../config.inc.php"; require_once "common.php"; testlinkInitPage($db, false, false, "checkRights"); $templateCfg = templateConfiguration(); $args = init_args($db); $cfield_mgr = new cfield_mgr($db); switch ($args->doAction) { case 'doAssign': $cfield_ids = array_keys($args->cfield); $cfield_mgr->link_to_testproject($args->tproject_id, $cfield_ids); break; case 'doUnassign': $cfield_ids = array_keys($args->cfield); $cfield_mgr->unlink_from_testproject($args->tproject_id, $cfield_ids); break; case 'doReorder': $cfield_ids = array_keys($args->display_order); $cfield_mgr->set_display_order($args->tproject_id, $args->display_order); if (!is_null($args->location)) { $cfield_mgr->setDisplayLocation($args->tproject_id, $args->location); } break;
/** * write execution result to DB * * @param resource &$db reference to database handler * @param obj &$exec_signature object with tproject_id,tplan_id,build_id,platform_id,user_id * * @internal revisions * */ function write_execution(&$db, &$exec_signature, &$exec_data, &$issueTracker) { static $docRepo; if (is_null($docRepo)) { $docRepo = tlAttachmentRepository::create($db); } $executions_table = DB_TABLE_PREFIX . 'executions'; $resultsCfg = config_get('results'); $execCfg = config_get('exec_cfg'); $db_now = $db->db_now(); $cfield_mgr = new cfield_mgr($db); $cf_prefix = $cfield_mgr->get_name_prefix(); $len_cfp = tlStringLen($cf_prefix); $cf_nodeid_pos = 4; $bulk_notes = ''; $ENABLED = 1; $cf_map = $cfield_mgr->get_linked_cfields_at_execution($exec_signature->tproject_id, $ENABLED, 'testcase'); $has_custom_fields = is_null($cf_map) ? 0 : 1; // extract custom fields id. $map_nodeid_array_cfnames = null; foreach ($exec_data as $input_name => $value) { if (strncmp($input_name, $cf_prefix, $len_cfp) == 0) { $dummy = explode('_', $input_name); $map_nodeid_array_cfnames[$dummy[$cf_nodeid_pos]][] = $input_name; } } if (isset($exec_data['do_bulk_save'])) { // create structure to use common algoritm $item2loop = $exec_data['status']; $is_bulk_save = 1; $bulk_notes = $db->prepare_string(trim($exec_data['bulk_exec_notes'])); $execStatusKey = 'status'; } else { $item2loop = $exec_data['save_results']; $is_bulk_save = 0; $execStatusKey = 'statusSingle'; } $addIssueOp = array('createIssue' => null, 'issueForStep' => null); foreach ($item2loop as $tcversion_id => $val) { $tcase_id = $exec_data['tc_version'][$tcversion_id]; $current_status = $exec_data[$execStatusKey][$tcversion_id]; $version_number = $exec_data['version_number'][$tcversion_id]; $has_been_executed = $current_status != $resultsCfg['status_code']['not_run'] ? TRUE : FALSE; if ($has_been_executed) { $my_notes = $is_bulk_save ? $bulk_notes : $db->prepare_string(trim($exec_data['notes'][$tcversion_id])); $sql = "INSERT INTO {$executions_table} " . "(build_id,tester_id,status,testplan_id,tcversion_id," . " execution_ts,notes,tcversion_number,platform_id,execution_duration)" . " VALUES ( {$exec_signature->build_id}, {$exec_signature->user_id}, '{$exec_data[$execStatusKey][$tcversion_id]}'," . "{$exec_signature->tplan_id}, {$tcversion_id},{$db_now},'{$my_notes}'," . "{$version_number},{$exec_signature->platform_id}"; $dura = 'NULL '; if (isset($exec_data['execution_duration'])) { if (trim($exec_data['execution_duration']) == '') { $dura = 'NULL '; } else { $dura = floatval($exec_data['execution_duration']); } } $sql .= ',' . $dura . ")"; $db->exec_query($sql); // at least for Postgres DBMS table name is needed. $execution_id = $db->insert_id($executions_table); $execSet[$tcversion_id] = $execution_id; if ($has_custom_fields) { // test useful when doing bulk update, because some type of custom fields // like checkbox can not exist on exec_data. => why ?? // $hash_cf = null; $access_key = $is_bulk_save ? 0 : $tcase_id; if (isset($map_nodeid_array_cfnames[$access_key])) { foreach ($map_nodeid_array_cfnames[$access_key] as $cf_v) { $hash_cf[$cf_v] = $exec_data[$cf_v]; } } $cfield_mgr->execution_values_to_db($hash_cf, $tcversion_id, $execution_id, $exec_signature->tplan_id, $cf_map); } $hasMoreData = new stdClass(); $hasMoreData->step_notes = isset($exec_data['step_notes']); $hasMoreData->step_status = isset($exec_data['step_status']); $hasMoreData->nike = $execCfg->steps_exec && ($hasMoreData->step_notes || $hasMoreData->step_status); if ($hasMoreData->nike) { $target = DB_TABLE_PREFIX . 'execution_tcsteps'; $key2loop = array_keys($exec_data['step_notes']); foreach ($key2loop as $step_id) { $doIt = !is_null($exec_data['step_notes'][$step_id]) && trim($exec_data['step_notes'][$step_id]) != '' || $exec_data['step_status'][$step_id] != $resultsCfg['status_code']['not_run']; if ($doIt) { $sql = " INSERT INTO {$target} (execution_id,tcstep_id,notes"; $values = " VALUES ( {$execution_id}, {$step_id}," . "'" . $db->prepare_string($exec_data['step_notes'][$step_id]) . "'"; $status = strtolower(trim($exec_data['step_status'][$step_id])); $status = $status[0]; if ($status != $resultsCfg['status_code']['not_run']) { $sql .= ",status"; $values .= ",'" . $db->prepare_string($status) . "'"; } $sql .= ") " . $values . ")"; $db->exec_query($sql); $execution_tcsteps_id = $db->insert_id($target); // NOW MANAGE attachments if (isset($_FILES['uploadedFile']['name'][$step_id]) && !is_null($_FILES['uploadedFile']['name'][$step_id])) { $repOpt = array('allow_empty_title' => TRUE); // May be we have enabled MULTIPLE on file upload if (is_array($_FILES['uploadedFile']['name'][$step_id])) { $curly = count($_FILES['uploadedFile']['name'][$step_id]); for ($moe = 0; $moe < $curly; $moe++) { $fSize = isset($_FILES['uploadedFile']['size'][$step_id][$moe]) ? $_FILES['uploadedFile']['size'][$step_id][$moe] : 0; $fTmpName = isset($_FILES['uploadedFile']['tmp_name'][$step_id][$moe]) ? $_FILES['uploadedFile']['tmp_name'][$step_id][$moe] : ''; if ($fSize && $fTmpName != "") { $fk2loop = array_keys($_FILES['uploadedFile']); foreach ($fk2loop as $tk) { $fInfo[$tk] = $_FILES['uploadedFile'][$tk][$step_id][$moe]; } $uploaded = $docRepo->insertAttachment($execution_tcsteps_id, $target, '', $fInfo, $repOpt); } } } else { $fSize = isset($_FILES['uploadedFile']['size'][$step_id]) ? $_FILES['uploadedFile']['size'][$step_id] : 0; $fTmpName = isset($_FILES['uploadedFile']['tmp_name'][$step_id]) ? $_FILES['uploadedFile']['tmp_name'][$step_id] : ''; if ($fSize && $fTmpName != "") { $fk2loop = array_keys($_FILES['uploadedFile']); foreach ($fk2loop as $tk) { $fInfo[$tk] = $_FILES['uploadedFile'][$tk][$step_id]; } $uploaded = $docRepo->insertAttachment($execution_tcsteps_id, $target, '', $fInfo); } } } } } } $itCheckOK = !is_null($issueTracker) && method_exists($issueTracker, 'addIssue'); // re-init $addIssueOp = array('createIssue' => null, 'issueForStep' => null); if ($itCheckOK) { $execContext = new stdClass(); $execContext->exec_id = $execution_id; $execContext->tcversion_id = $tcversion_id; $execContext->user = $exec_signature->user; $execContext->basehref = $exec_signature->basehref; $execContext->tplan_apikey = $exec_signature->tplan_apikey; // Issue on Test Case if (isset($exec_data['createIssue'])) { completeCreateIssue($execContext, $exec_signature); $addIssueOp['createIssue'] = addIssue($db, $execContext, $issueTracker); } // Issues at step level if (isset($exec_data['issueForStep'])) { foreach ($exec_data['issueForStep'] as $stepID => $val) { completeIssueForStep($execContext, $exec_signature, $exec_data, $stepID); $addIssueOp['issueForStep'][$stepID] = addIssue($db, $execContext, $issueTracker, $stepID); } } } // $itCheckOK } } return array($execSet, $addIssueOp); }
/** * Update value of Custom Field with scope='design' for a given Test case * * @param struct $args * @param string $args["devKey"]: used to check if operation can be done. * if devKey is not valid => abort. * * @param string $args["testcaseexternalid"]: * @param string $args["version"]: version number * @param string $args["testprojectid"]: * @param string $args["customfields"] - optional * contains an map with key:Custom Field Name, value: value for CF. * VERY IMPORTANT: value must be formatted in the way it's written to db, * this is important for types like: * * DATE: strtotime() * DATETIME: mktime() * MULTISELECTION LIST / CHECKBOX / RADIO: se multipli selezione ! come separatore * * * these custom fields must be configured to be writte during execution. * If custom field do not meet condition value will not be written * * @return mixed null if everything ok, else array of IXR_Error objects * * @access public */ public function updateTestCaseCustomFieldDesignValue($args) { $msg_prefix = "(" . __FUNCTION__ . ") - "; $this->_setArgs($args); $checkFunctions = array('authenticate', 'checkTestProjectID', 'checkTestCaseIdentity', 'checkTestCaseVersionNumber'); $status_ok = $this->_runChecks($checkFunctions, $msg_prefix); if ($status_ok) { if (!$this->_isParamPresent(self::$customFieldsParamName)) { $status_ok = false; $msg = sprintf(MISSING_REQUIRED_PARAMETER_STR, self::$customFieldsParamName); $this->errors[] = new IXR_Error(MISSING_REQUIRED_PARAMETER, $msg); } } if ($status_ok) { // now check if custom fields are ok // For each custom field need to check if: // 1. is linked to test project // 2. is available for test case at design time $cfieldMgr = new cfield_mgr($this->dbObj); // Just ENABLED $linkedSet = $cfieldMgr->get_linked_cfields_at_design($this->args[self::$testProjectIDParamName], cfield_mgr::ENABLED, null, 'testcase', null, 'name'); if (is_null($linkedSet)) { $status_ok = false; $msg = NO_CUSTOMFIELDS_DT_LINKED_TO_TESTCASES_STR; $this->errors[] = new IXR_Error(NO_CUSTOMFIELDS_DT_LINKED_TO_TESTCASES, $msg); } } if ($status_ok) { $accessVersionBy['number'] = $this->args[self::$versionNumberParamName]; $nodeInfo = $this->tcaseMgr->get_basic_info($this->args[self::$testCaseIDParamName], $accessVersionBy); $cfSet = $args[self::$customFieldsParamName]; foreach ($cfSet as $cfName => $cfValue) { // $accessKey = "custom_field_" . $item['id'] . <field_type_id>_<cfield_id> // design_values_to_db($hash,$node_id,$cf_map=null,$hash_type=null) $item = $linkedSet[$cfName]; $accessKey = "custom_field_" . $item['type'] . '_' . $item['id']; $hash[$accessKey] = $cfValue; $cfieldMgr->design_values_to_db($hash, $nodeInfo[0]['tcversion_id']); } } else { return $this->errors; } }
function doUpdate(&$db, &$args, &$tcaseMgr, &$request) { updateExecutionNotes($db, $args->exec_id, $args->notes); $cfield_mgr = new cfield_mgr($db); $cfield_mgr->execution_values_to_db($request, $args->tcversion_id, $args->exec_id, $args->tplan_id); }
/** * * */ function buildResultSet(&$dbHandler, &$guiObj, $tproject_id, $tplan_id) { $cfieldMgr = new cfield_mgr($dbHandler); // Get the custom fields linked/enabled on execution to a test project // This will be used on report to give name to header of columns that hold custom field value $guiObj->cfields = $cfieldMgr->get_linked_cfields_at_execution($tproject_id, 1, 'testcase', null, null, null, 'name'); // this way on caller can be used on array operations, without warnings $guiObj->cfields = (array) $guiObj->cfields; if (count($guiObj->cfields) > 0) { foreach ($guiObj->cfields as $key => $values) { $cf_place_holder['cfields'][$key] = ''; } } $cf_map = $cfieldMgr->get_linked_cfields_at_execution($tproject_id, 1, 'testcase', null, null, $tplan_id, 'exec_id'); // need to transform in structure that allow easy display // Every row is an execution with exec data plus a column that contains following map: // 'cfields' => CFNAME1 => value // CFNAME2 => value $guiObj->resultSet = array(); if (!is_null($cf_map)) { foreach ($cf_map as $exec_id => $exec_info) { // Get common exec info and remove useless keys $guiObj->resultSet[$exec_id] = $exec_info[0]; unset($guiObj->resultSet[$exec_id]['name']); unset($guiObj->resultSet[$exec_id]['label']); unset($guiObj->resultSet[$exec_id]['display_order']); unset($guiObj->resultSet[$exec_id]['id']); unset($guiObj->resultSet[$exec_id]['value']); // Collect custom fields values $guiObj->resultSet[$exec_id] += $cf_place_holder; foreach ($exec_info as $cfield_data) { $guiObj->resultSet[$exec_id]['cfields'][$cfield_data['name']] = $cfield_data['value']; } } } if (($guiObj->row_qty = count($cf_map)) == 0) { $guiObj->warning_msg = lang_get('no_linked_tc_cf'); } }
/** * TestLink Open Source Project - http://testlink.sourceforge.net/ * This script is distributed under the GNU General Public License 2 or later. * * @filesource testPlanWithCF.php * @author Amit Khullar - amkhullar@gmail.com * * For a test plan, list associated Custom Field Data * * @internal revisions */ require_once "../../config.inc.php"; require_once "common.php"; testlinkInitPage($db); $cfield_mgr = new cfield_mgr($db); $templateCfg = templateConfiguration(); $tproject_mgr = new testproject($db); $tplan_mgr = new testplan($db); $tcase_mgr = new testcase($db); $args = init_args($tplan_mgr); checkRights($db, $_SESSION['currentUser'], $args); $charset = config_get('charset'); $glue_char = config_get('gui_title_separator_1'); $gui = new stdClass(); $gui->pageTitle = lang_get('caption_testPlanWithCF'); $gui->warning_msg = ''; $gui->path_info = null; $gui->resultSet = null; $gui->tproject_id = $args->tproject_id; $gui->tproject_name = $args->tproject_name;
<?php /** * TestLink Open Source Project - http://testlink.sourceforge.net/ * This script is distributed under the GNU General Public License 2 or later. * * @filesource cfieldsView.php * **/ require_once dirname(__FILE__) . "/../../config.inc.php"; require_once "common.php"; testlinkInitPage($db, false, false, "checkRights"); $gui = new stdClass(); $templateCfg = templateConfiguration(); $cfield_mgr = new cfield_mgr($db); $gui->cf_map = $cfield_mgr->get_all(null, 'transform'); $gui->cf_types = $cfield_mgr->get_available_types(); $smarty = new TLSmarty(); $smarty->assign('gui', $gui); $smarty->display($templateCfg->template_dir . $templateCfg->default_template); function checkRights(&$db, &$user) { return $user->hasRight($db, "cfield_view"); }
function exportTestCaseDataToXML($tcase_id, $tcversion_id, $tproject_id = null, $bNoXMLHeader = false, $optExport = array()) { static $reqMgr; static $keywordMgr; static $cfieldMgr; if (is_null($reqMgr)) { $reqMgr = new requirement_mgr($this->db); $keywordMgr = new tlKeyword(); $cfieldMgr = new cfield_mgr($this->db); } // Useful when you need to get info but do not have tcase id $tcase_id = intval((int) $tcase_id); $tcversion_id = intval((int) $tcversion_id); if ($tcase_id <= 0 && $tcversion_id > 0) { $info = $this->tree_manager->get_node_hierarchy_info($tcversion_id); $tcase_id = $info['parent_id']; } $tc_data = $this->get_by_id($tcase_id, $tcversion_id); $testCaseVersionID = $tc_data[0]['id']; if (!$tproject_id) { $tproject_id = $this->getTestProjectFromTestCase($tcase_id); } if (isset($optExport['CFIELDS']) && $optExport['CFIELDS']) { $cfMap = $this->get_linked_cfields_at_design($tcase_id, $testCaseVersionID, null, null, $tproject_id); // ||yyy||-> tags, {{xxx}} -> attribute // tags and attributes receive different treatment on exportDataToXML() // // each UPPER CASE word in this map KEY, MUST HAVE AN OCCURENCE on $elemTpl // value is a key inside $tc_data[0] // if (!is_null($cfMap) && count($cfMap) > 0) { // $cfRootElem = "<custom_fields>{{XMLCODE}}</custom_fields>"; // $cfElemTemplate = "\t" . "<custom_field>\n" . // "\t<name><![CDATA[||NAME||]]></name>\n" . // "\t<value><![CDATA[||VALUE||]]></value>\n</custom_field>\n"; // $cfDecode = array ("||NAME||" => "name","||VALUE||" => "value"); // $tc_data[0]['xmlcustomfields'] = $cfieldMgr->exportDataToXML($cfMap,$cfRootElem,$cfElemTemplate,$cfDecode,true); $tc_data[0]['xmlcustomfields'] = $cfieldMgr->exportValueAsXML($cfMap); } } if (isset($optExport['KEYWORDS']) && $optExport['KEYWORDS']) { $keywords = $this->getKeywords($tcase_id); if (!is_null($keywords)) { $xmlKW = "<keywords>" . $keywordMgr->toXMLString($keywords, true) . "</keywords>"; $tc_data[0]['xmlkeywords'] = $xmlKW; } } if (isset($optExport['REQS']) && $optExport['REQS']) { $requirements = $reqMgr->get_all_for_tcase($tcase_id); if (!is_null($requirements) && count($requirements) > 0) { $reqRootElem = "\t<requirements>\n{{XMLCODE}}\t</requirements>\n"; $reqElemTemplate = "\t\t<requirement>\n" . "\t\t\t<req_spec_title><![CDATA[||REQ_SPEC_TITLE||]]></req_spec_title>\n" . "\t\t\t<doc_id><![CDATA[||REQ_DOC_ID||]]></doc_id>\n" . "\t\t\t<title><![CDATA[||REQ_TITLE||]]></title>\n" . "\t\t</requirement>\n"; $reqDecode = array("||REQ_SPEC_TITLE||" => "req_spec_title", "||REQ_DOC_ID||" => "req_doc_id", "||REQ_TITLE||" => "title"); $tc_data[0]['xmlrequirements'] = exportDataToXML($requirements, $reqRootElem, $reqElemTemplate, $reqDecode, true); } } // ------------------------------------------------------------------------------------ $stepRootElem = "<steps>{{XMLCODE}}</steps>"; $stepTemplate = "\n" . '<step>' . "\n" . "\t<step_number><![CDATA[||STEP_NUMBER||]]></step_number>\n" . "\t<actions><![CDATA[||ACTIONS||]]></actions>\n" . "\t<expectedresults><![CDATA[||EXPECTEDRESULTS||]]></expectedresults>\n" . "\t<execution_type><![CDATA[||EXECUTIONTYPE||]]></execution_type>\n" . "</step>\n"; $stepInfo = array("||STEP_NUMBER||" => "step_number", "||ACTIONS||" => "actions", "||EXPECTEDRESULTS||" => "expected_results", "||EXECUTIONTYPE||" => "execution_type"); $stepSet = $tc_data[0]['steps']; $xmlsteps = exportDataToXML($stepSet, $stepRootElem, $stepTemplate, $stepInfo, true); $tc_data[0]['xmlsteps'] = $xmlsteps; // ------------------------------------------------------------------------------------ $rootElem = "{{XMLCODE}}"; if (isset($optExport['ROOTELEM'])) { $rootElem = $optExport['ROOTELEM']; } $elemTpl = "\n" . '<testcase internalid="{{TESTCASE_ID}}" name="{{NAME}}">' . "\n" . "\t<node_order><![CDATA[||NODE_ORDER||]]></node_order>\n"; if (!isset($optExport['EXTERNALID']) || $optExport['EXTERNALID']) { $elemTpl .= "\t<externalid><![CDATA[||EXTERNALID||]]></externalid>\n"; } $elemTpl .= "\t<version><![CDATA[||VERSION||]]></version>\n" . "\t<summary><![CDATA[||SUMMARY||]]></summary>\n" . "\t<preconditions><![CDATA[||PRECONDITIONS||]]></preconditions>\n" . "\t<execution_type><![CDATA[||EXECUTIONTYPE||]]></execution_type>\n" . "\t<importance><![CDATA[||IMPORTANCE||]]></importance>\n" . "\t<estimated_exec_duration>||ESTIMATED_EXEC_DURATION||</estimated_exec_duration>\n" . "\t<status>||STATUS||</status>\n" . "||STEPS||\n" . "||KEYWORDS||||CUSTOMFIELDS||||REQUIREMENTS||</testcase>\n"; // ||yyy||-> tags, {{xxx}} -> attribute // tags and attributes receive different treatment on exportDataToXML() // // each UPPER CASE word in this map KEY, MUST HAVE AN OCCURENCE on $elemTpl // value is a key inside $tc_data[0] // $info = array("{{TESTCASE_ID}}" => "testcase_id", "{{NAME}}" => "name", "||NODE_ORDER||" => "node_order", "||EXTERNALID||" => "tc_external_id", "||VERSION||" => "version", "||SUMMARY||" => "summary", "||PRECONDITIONS||" => "preconditions", "||EXECUTIONTYPE||" => "execution_type", "||IMPORTANCE||" => "importance", "||ESTIMATED_EXEC_DURATION||" => "estimated_exec_duration", "||STATUS||" => "status", "||STEPS||" => "xmlsteps", "||KEYWORDS||" => "xmlkeywords", "||CUSTOMFIELDS||" => "xmlcustomfields", "||REQUIREMENTS||" => "xmlrequirements"); $xmlTC = exportDataToXML($tc_data, $rootElem, $elemTpl, $info, $bNoXMLHeader); return $xmlTC; }
function saveImportedResultData(&$db, $resultData, $context, $options) { if (!$resultData) { return; } $debugMsg = ' FUNCTION: ' . __FUNCTION__; $tables = tlObjectWithDB::getDBTables(array('executions', 'execution_bugs')); $tcaseCfg = config_get('testcase_cfg'); // --------------------------------------------------------------------------------------- $l10n = array('import_results_tc_not_found' => '', 'import_results_invalid_result' => '', 'tproject_id_not_found' => '', 'import_results_ok' => '', 'invalid_cf' => '', 'import_results_skipped' => ''); foreach ($l10n as $key => $value) { $l10n[$key] = lang_get($key); } $resultsCfg = config_get('results'); foreach ($resultsCfg['status_label'] as $ks => $lbl) { $key = $resultsCfg['status_code'][$ks]; $l10n[$key] = lang_get($lbl); } // --------------------------------------------------------------------------------------- // Get Column definitions to get size dinamically instead of create constants $columnDef = array(); $adodbObj = $db->get_dbmgr_object(); $columnDef['execution_bugs'] = $adodbObj->MetaColumns($tables['execution_bugs']); $keySet = array_keys($columnDef['execution_bugs']); foreach ($keySet as $keyName) { if (($keylow = strtolower($keyName)) != $keyName) { $columnDef['execution_bugs'][$keylow] = $columnDef['execution_bugs'][$keyName]; unset($columnDef['execution_bugs'][$keyName]); } } $user = new tlUser($context->userID); $user->readFromDB($db); $tcase_mgr = new testcase($db); $resultMap = array(); $tplan_mgr = null; $tc_qty = sizeof($resultData); if ($tc_qty) { $tplan_mgr = new testplan($db); $tproject_mgr = new testproject($db); $build_mgr = new build_mgr($db); } // Need to do checks on common settings // // test project exists // // test plan id: // belongs to target test project // is active // build id: // belongs to target test plan // is open // // platform id: // is linked to target test plan // // execution type if not present -> set to MANUAL // if presente is valid i.e. inside the TL domain // $checks = array(); $checks['status_ok'] = true; $checks['msg'] = null; $dummy = null; if (!is_null($context->tprojectID) && intval($context->tprojectID) > 0) { $dummy = array($tproject_mgr->get_by_id($context->tprojectID, array('output' => 'existsByID'))); } else { if (!is_null($context->tprojectName)) { $dummy = $tproject_mgr->get_by_name($context->tprojectName, null, array('output' => 'existsByName')); } } $checks['status_ok'] = !is_null($dummy); if (!$checks['status_ok']) { $checks['msg'][] = sprintf($l10n['tproject_id_not_found'], $context->tprojectID); } if (!$checks['status_ok']) { foreach ($checks['msg'] as $warning) { $resultMap[] = array($warning); } } if ($doIt = $checks['status_ok']) { $context->tprojectID = $dummy[0]['id']; } // -------------------------------------------------------------------- $dummy = null; if (!is_null($context->tplanID) && intval($context->tplanID) > 0) { $dummy = $tplan_mgr->get_by_id($context->tplanID, array('output' => 'minimun')); if (!is_null($dummy)) { $dummy['id'] = $context->tplanID; } } else { if (!is_null($context->tplanName)) { $dummy = $tplan_mgr->get_by_name($context->tplanName, $context->tprojectID, array('output' => 'minimun')); if (!is_null($dummy)) { $dummy = $dummy[0]; } } } if (!is_null($dummy)) { $context->tplanID = $dummy['id']; } if (intval($context->tprojectID) <= 0 && intval($context->tplanID) > 0) { $dummy = $tplan_mgr->tree_manager->get_node_hierarchy_info($context->tplanID); $context->tprojectID = $dummy['parent_id']; } // -------------------------------------------------------------------- // -------------------------------------------------------------------- $dummy = null; $tplan_mgr->platform_mgr->setTestProjectID($context->tprojectID); if (!is_null($context->platformID) && intval($context->platformID) > 0) { $dummy = array($tplan_mgr->platform_mgr->getByID($context->platformID)); } else { if (property_exists($context, 'platformName') && !is_null($context->platformName)) { if (!is_null($xx = $tplan_mgr->platform_mgr->getID($context->platformName))) { $dummy = array(0 => array('id' => $xx)); } } } if (!is_null($dummy)) { $context->platformID = $dummy[0]['id']; } // -------------------------------------------------------------------- // -------------------------------------------------------------------- $optGB = array('tplan_id' => $context->tplanID, 'output' => 'minimun'); $dummy = null; if (!is_null($context->buildID) && intval($context->buildID) > 0) { $dummy = array($build_mgr->get_by_id($context->buildID, $optGB)); } else { if (!is_null($context->buildName)) { $dummy = $build_mgr->get_by_name($context->buildName, $optGB); } } if (!is_null($dummy)) { $context->buildID = $dummy[0]['id']; } // -------------------------------------------------------------------- // -------------------------------------------------------------------- for ($idx = 0; $doIt && $idx < $tc_qty; $idx++) { $tester_id = 0; $tester_name = ''; $using_external_id = false; $message = null; $status_ok = true; $tcase_exec = $resultData[$idx]; // New attribute "execution type" makes old XML import files incompatible // Important NOTICE: // tcase_exec is passed BY REFERENCE to allow check_exec_values()change execution type if needed // $checks = check_exec_values($db, $tcase_mgr, $user_mgr, $tcaseCfg, $tcase_exec, $columnDef['execution_bugs']); $status_ok = $checks['status_ok']; if ($status_ok) { $tcase_id = $checks['tcase_id']; $tcase_external_id = trim($tcase_exec['tcase_external_id']); $tester_id = $checks['tester_id']; // external_id has precedence over internal id $using_external_id = $tcase_external_id != ""; } else { foreach ($checks['msg'] as $warning) { $resultMap[] = array($warning); } } if ($status_ok) { $tcase_identity = $using_external_id ? $tcase_external_id : $tcase_id; $result_code = strtolower($tcase_exec['result']); $result_is_acceptable = isset($resultsCfg['code_status'][$result_code]) ? true : false; $notes = $tcase_exec['notes']; $message = null; $info_on_case = $tplan_mgr->getLinkInfo($context->tplanID, $tcase_id, $context->platformID); if (is_null($info_on_case)) { $message = sprintf($l10n['import_results_tc_not_found'], $tcase_identity); } else { if (!$result_is_acceptable) { $message = sprintf($l10n['import_results_invalid_result'], $tcase_identity, $tcase_exec['result']); } else { $info_on_case = current($info_on_case); $tcversion_id = $info_on_case['tcversion_id']; $version = $info_on_case['version']; $notes = $db->prepare_string(trim($notes)); // N.B.: db_now() returns an string ready to be used in an SQL insert // example '2008-09-04', while $tcase_exec["timestamp"] => 2008-09-04 // $execution_ts = $tcase_exec['timestamp'] != '' ? "'" . $tcase_exec["timestamp"] . "'" : $db->db_now(); if ($tester_id != 0) { $tester_name = $tcase_exec['tester']; } else { $tester_name = $user->login; $tester_id = $context->userID; } $addExecDuration = strlen($tcase_exec['execution_duration']) > 0 && is_numeric($tcase_exec['execution_duration']); $lexid = 0; if ($options->copyIssues) { $lexid = $tcase_mgr->getSystemWideLastestExecutionID($tcversion_id); } $idCard = array('id' => $tcase_id, 'version_id' => $tcversion_id); $exco = array('tplan_id' => $context->tplanID, 'platform_id' => $context->platformID, 'build_id' => $context->buildID); $lexInfo = $tcase_mgr->getLatestExecSingleContext($idCard, $exco, array('output' => 'timestamp')); $doInsert = true; if (!is_null($lexInfo)) { $tts = $lexInfo[$tcase_id][0]['execution_ts']; $doInsert = $lexInfo[$tcase_id][0]['execution_ts'] != trim($execution_ts, "'"); $msgTxt = $l10n['import_results_skipped']; } if ($doInsert) { $sql = " /* {$debugMsg} */ " . " INSERT INTO {$tables['executions']} (build_id,tester_id,status,testplan_id," . " tcversion_id,execution_ts,notes,tcversion_number,platform_id,execution_type" . ($addExecDuration ? ',execution_duration' : '') . ")" . " VALUES ({$context->buildID}, {$tester_id},'{$result_code}',{$context->tplanID}, " . " {$tcversion_id},{$execution_ts},'{$notes}', {$version}, " . " {$context->platformID}, {$tcase_exec['execution_type']}" . ($addExecDuration ? ",{$tcase_exec['execution_duration']}" : '') . ")"; $db->exec_query($sql); $execution_id = $db->insert_id($tables['executions']); // 20150127 /* if(isset($tcase_exec['steps']) && !is_null($tcase_exec['steps'])) { $stepSet = $tcase_mgr->getStepsSimple($tcversion_id,0, array('fields2get' => 'TCSTEPS.step_number,TCSTEPS.id', 'accessKey' => 'step_number')); $sc = count($tcase_exec['steps']); for($sx=0; $sx < $sc; $sx++) { $snum = $$tcase_exec['steps'][$sx]; // assumption: all data is valid if(isset($stepSet[$snum])) { } } } new dBug($tcase_exec); die(); */ if ($lexid > 0 && $options->copyIssues) { copyIssues($db, $lexid, $execution_id); } if (isset($tcase_exec['bug_id']) && !is_null($tcase_exec['bug_id']) && is_array($tcase_exec['bug_id'])) { foreach ($tcase_exec['bug_id'] as $bug_id) { $bug_id = trim($bug_id); $sql = " /* {$debugMsg} */ " . " SELECT execution_id AS check_qty FROM {$tables['execution_bugs']} " . " WHERE bug_id = '{$bug_id}' AND execution_id={$execution_id} "; $rs = $db->get_recordset($sql); if (is_null($rs)) { $sql = " /* {$debugMsg} */ " . " INSERT INTO {$tables['execution_bugs']} (bug_id,execution_id)" . " VALUES ('" . $db->prepare_string($bug_id) . "', {$execution_id} )"; $db->exec_query($sql); } } } if (isset($tcase_exec['custom_fields']) && !is_null($tcase_exec['custom_fields']) && is_array($tcase_exec['custom_fields'])) { // Get linked custom fields to this test project, for test case on execution // $context->tprojectID $cfieldMgr = new cfield_mgr($db); $cfSetByName = $cfieldMgr->get_linked_cfields_at_execution($context->tprojectID, 1, 'testcase', null, null, null, 'name'); foreach ($tcase_exec['custom_fields'] as $cf) { $ak = null; if (isset($cfSetByName[$cf['name']])) { // write to db blind $ak[$cfSetByName[$cf['name']]['id']]['cf_value'] = $cf['value']; } else { $message = sprintf($l10n['invalid_cf'], $tcase_identity, $cf['name']); } if (!is_null($ak)) { $cfieldMgr->execution_values_to_db($ak, $tcversion_id, $execution_id, $context->tplanID, null, 'plain'); } } } if (!is_null($message)) { $resultMap[] = array($message); } $msgTxt = $l10n['import_results_ok']; } $message = sprintf($msgTxt, $tcase_identity, $version, $tester_name, $l10n[$result_code], $execution_ts); } } } if (!is_null($message)) { $resultMap[] = array($message); } } return $resultMap; }