* @version $Id$ * @access public * @license http://opensource.org/licenses/gpl-3.0.html */ //////////// Check Inclusion de pages //////////// if (!class_exists('auth')){ include_once("../lib/lib_common.php"); ReloadIndex('admin'); } //////////// //////////// Check Droits utilisateur //////////// if (!$l21auth->hasRight('sdi')) ReloadIndex('admin'); //////////// if(defined('API_RETRIEVE') && API_RETRIEVE == 1) $apiclass = 'api-container-enabled'; else $apiclass = 'api-container-disabled'; include_once('../class/class.tag.php'); include_once("../dashboard/common.php"); // TextboxList CSS/JS inclusion addDynamicCSS(THEME_ADMIN_PATH.'css/TextboxList.css'); addDynamicCSS(THEME_ADMIN_PATH.'css/TextboxList.Autocomplete.css'); footerAddJS('../lib/js/TextboxList-jQuery/Source/GrowingInput.js'); footerAddJS('../lib/js/TextboxList-jQuery/Source/TextboxList.js'); footerAddJS('../lib/js/TextboxList-jQuery/Source/TextboxList.Autocomplete.js'); unit_javascript_validation(); api_multivalue_javascript(); include_once("../lib/input_helpers.php"); include_once(override('../level/mysql.inc.php', THEME_ADMIN_PATH)); if(!isset($_GET['id']) && !isset($_POST['id'])) { $id="1"; } else { if(isset($_REQUEST['id'])) $id=$_REQUEST['id']; } $link_mod_e=$rub_link."&todo=mod_e&id="; $link_mod_r=$rub_link."&todo=mod_r&id="; $link_mod_p=$rub_link."&todo=mod_p&id="; // we get available tags list to display to user when hovering 'tags' label $alltags = new tag(); $availableTags = $alltags->getTags('indicator', -1, false, ',', true); $tags_list = ''; if(count($availableTags) > 0) { $l = ''; foreach($availableTags as $item) { $l .= ''.$item['tag_name'].''; } $tags_list = '
'.$l.'
'; } // getting tags from given project $otag = new tag(); $form_tags = $otag->getTags('indicator', $id, true); if (isset($_POST['enregistrer'])) { $data_table = unserialize(urldecode($_POST['data_table'])); $sdi_object= new sdi; $result=$sdi_object->ModifySdi($id, $data_table, $sql_object); if($result) { $otag->modifyTags('indicator', $id, $data_table['tags']); } // finally, we import initial values if asked if($result && $data_table['api-get-values'] == 'Y') { $sdi = $sql_object->DBSelect(SQL_getInfoSdi($id)); api_update_indicators($sdi, true); if($r < 3) $sdi_object->setInitialImportDone($id, $sql_object); } $link_confirm="confirm.php?rub=".$rub."&todo=".$todo."&id=".$id; if(isset($result)) { header("Location: ".safe_redirect($link_confirm)); exit; } else system_error(); } $sdi_object= new sdi; $req_sdii=SQL_getInfoSdi($id); $data_form_sdi = $sql_object -> DBSelect($req_sdii); // Do record exists? if(!isset($data_form_sdi[0]['sdii_name'])) redirect_to('@module_default'); $form_name = formatText($data_form_sdi[0]['sdii_name'], '2FIELD'); $form_level = $data_form_sdi[0]['sdii_level']; //$form_range = $data_form_sdi[0]['sdii_range']; $form_description = formatText($data_form_sdi[0]['sdii_description'], '2FIELD'); $form_input_instructions = $data_form_sdi[0]['sdii_input_instructions']; $form_comment = formatText($data_form_sdi[0]['sdii_comment'], '2FIELD'); $form_goal = formatText($data_form_sdi[0]['sdii_goal'], '2FIELD'); $form_consulting = formatText($data_form_sdi[0]['sdii_consulting'], '2FIELD'); $form_unit = formatText($data_form_sdi[0]['sdii_unit'], '2FIELD'); $form_max_value = $data_form_sdi[0]['sdii_max_value']; $form_min_value = $data_form_sdi[0]['sdii_min_value']; $form_threshold_value = $data_form_sdi[0]['sdii_threshold_value']; $form_frequency = $data_form_sdi[0]['sdii_frequency']; $form_type = $data_form_sdi[0]['sdii_type']; $form_nature = $data_form_sdi[0]['sdii_nature']; $form_dashboard_viz = $data_form_sdi[0]['sdii_dashboard_viz']; $form_detail_viz = $data_form_sdi[0]['sdii_detail_viz']; $form_value_type = $data_form_sdi[0]['sdii_value_type']; $form_multiple_type = $data_form_sdi[0]['sdii_multiple_type']; $form_multiple_mode = $data_form_sdi[0]['sdii_multiple_mode']; $form_unique_mode = $data_form_sdi[0]['sdii_unique_mode']; $form_mcolor = $data_form_sdi[0]['sdii_mcolor']; // main value color $form_tcolor = $data_form_sdi[0]['sdii_tcolor']; // threshold color $form_force_min_value = ($data_form_sdi[0]['sdii_force_chart_min'] == 'novalue') ? 0 : cast_number($data_form_sdi[0]['sdii_force_chart_min']); $form_api_url = $data_form_sdi[0]['sdii_api_url']; $form_api_datefield = $data_form_sdi[0]['sdii_api_datefield']; $form_api_valuefield = $data_form_sdi[0]['sdii_api_valuefield']; $form_api_decimal = $data_form_sdi[0]['sdii_api_decimal']; $form_api_values_since = $data_form_sdi[0]['sdii_api_getvalues_since']; $form_api_multimapping = unserialize($data_form_sdi[0]['sdii_api_multimapping']); // we overwrite values based on posted values if needed if(isset($_POST['api-mapping'])) { $form_api_multimapping = []; for($i =0; $i < count($_POST['api-mapping']); $i++) { $form_api_multimapping[$_POST['api-mapping-i'][$i]] = $_POST['api-mapping'][$i]; } } $form_api_multimapping_field = ''; $cnt=0; if(is_array($form_api_multimapping)) { foreach ($form_api_multimapping as $k => $v) { // for($i = 0; $i < count($form_api_multimapping); $i++) { $form_api_multimapping_field .= '

'; $form_api_multimapping_field .= ''; $form_api_multimapping_field .= ''; $form_api_multimapping_field .= '

'; $cnt++; } } if($data_form_sdi[0]['sdii_statut']=='D') $mask_statut_D="checked=\"checked\""; else $mask_statut_D=''; if($data_form_sdi[0]['sdii_statut']=='P') $mask_statut_P="checked=\"checked\""; else $mask_statut_P=''; if($data_form_sdi[0]['sdii_to_dashboard']=='Y') $mask_dashboard="checked=\"checked\""; else $mask_dashboard=''; if($data_form_sdi[0]['sdii_force_chart_min']=='novalue') $mask_force_min = ''; else $mask_force_min = 'checked="checked"'; if($data_form_sdi[0]['sdii_threshold_relative']=='Y') $mask_threshold_relative="checked=\"checked\""; else $mask_threshold_relative=''; if($data_form_sdi[0]['sdii_api_enabled']=='Y') $mask_api_enabled="checked=\"checked\""; else $mask_api_enabled=''; if($data_form_sdi[0]['sdii_api_getvalues']=='Y') $mask_api_getvalues="checked=\"checked\""; else $mask_api_getvalues=''; if($data_form_sdi[0]['sdii_api_overwritevalues']=='Y') $mask_api_overwrite="checked=\"checked\""; else $mask_api_overwrite=''; if (isset($_POST['valider'])) { $table = array(); $table[0] = $_POST['sdi_name']; $table[1] = $_POST['description']; $table[2] = $_POST['comment']; $table[3] = $_POST['sdi_level']; //$table[4] = $_POST['range']; $table[4] = 0; $table[5] = $_POST['goal']; $table[6] = $_POST['consulting']; $table[7] = $_POST['unit']; $table[8] = $_POST['max_value']; $table[9] = $_POST['min_value']; $table[10]= $table['threshold_value'] = $_POST['threshold_value']; $table[11]= $_POST['frequency']; $table[12]= $_POST['sdi_statut']; $table['api-url'] = $_POST['api-url']; $table['api-date-field'] = $_POST['api-date-field']; $table['api-value-field'] = $_POST['api-value-field']; $table['api-decimal'] = $_POST['api-decimal']; $table['api-get-values-since'] = $_POST['api-get-values-since']; $table['input_instructions'] = $_POST['input_instructions']; $display_api_multimapping_field = ''; if(isset($_POST['api-mapping'])) { $mapping = []; for($i =0; $i < count($_POST['api-mapping']); $i++) { $mapping[$_POST['api-mapping-i'][$i]] = $_POST['api-mapping'][$i]; $display_api_multimapping_field .= '
'; $display_api_multimapping_field .= ''.mb_ucfirst($_POST['api-mapping-i'][$i]). ' ⬌ '. $_POST['api-mapping'][$i]. ''; $display_api_multimapping_field .= '
'; } $table['api-multimapping'] = serialize($mapping); } else $table['api-multimapping'] = ''; $table['value-type'] = $_POST['sdi_value_type']; // we pass value type for test if (isset($_POST['threshold_relative'])) { $table[13] = "Y"; $mask_threshold_relative="checked=\"checked\""; } else { $table[13] ="N"; $mask_threshold_relative=""; } if (isset($_POST['attached_to_dashboard'])) { $table[14]="Y"; $mask_dashboard="checked=\"checked\""; } else { $table[14]="N"; $mask_dashboard=""; } if (isset($_POST['sdi_force_min'])) { $table['chart_force_min'] = !is_numeric($_POST['sdi_force_min_value']) ? 0 : $_POST['sdi_force_min_value'];; $mask_force_min = "checked=\"checked\""; $form_force_min_value = !is_numeric($_POST['sdi_force_min_value']) ? 0 : $_POST['sdi_force_min_value']; } else { $table['chart_force_min'] = 'novalue'; $mask_force_min = ""; } // API forms fields handling if (isset($_POST['api-enabled'])) { $table['api-enabled']="Y"; $mask_api_enabled="checked=\"checked\""; } else { $table['api-enabled']="N"; $mask_api_enabled=""; } if (isset($_POST['api-get-values'])) { $table['api-get-values']="Y"; $mask_api_getvalues="checked=\"checked\""; } else { $table['api-get-values']="N"; $mask_api_getvalues=""; } if (isset($_POST['api-overwrite-values'])) { $table['api-overwrite-values']="Y"; $mask_api_overwrite = "checked=\"checked\""; } else { $table['api-overwrite-values']="N"; $mask_api_overwrite = ""; } $table[15]=$_POST['sdi_type']; isset($_POST['sdi_dashboard_viz']) ? $table[16] = $table['dashboard_viz'] = $_POST['sdi_dashboard_viz'] : $table[16] = $table['dashboard_viz'] = 'raw'; // a bug can happen when switching from quantitative to qualitative $table[17]=$_POST['sdi_detail_viz']; $table[18]=$_POST['sdi_value_type']; $table['multiple_type']=$_POST['sdi_multiple_type']; $table['multiple_mode']=$_POST['sdi_multiple_mode']; $table['unique_mode']=$_POST['sdi_unique_mode']; $table['tags']=$_POST['tags']; $table['nature']=$_POST['sdi_nature']; $table['mcolor']=$_POST['sdi_mcolor']; $table['tcolor']=$_POST['sdi_tcolor']; $sdi_object = new sdi; $integrity = $sdi_object -> CheckDataIntegrity_info($table, true, 'nature'); $form_nature = $_POST['sdi_nature']; $form_type = $_POST['sdi_type']; isset($_POST['sdi_dashboard_viz']) ? $form_dashboard_viz=$_POST['sdi_dashboard_viz'] : $form_dashboard_viz='raw'; // a bug can happen when switching from quantitative to qualitative $form_detail_viz = $_POST['sdi_detail_viz']; $form_value_type = $_POST['sdi_value_type']; $form_multiple_type = $_POST['sdi_multiple_type']; $form_multiple_mode =$_POST['sdi_multiple_mode']; $form_unique_mode =$_POST['sdi_unique_mode']; $form_name = formatText($_POST['sdi_name'], '2FIELD'); $form_level = $_POST['sdi_level']; $form_statut =$_POST['sdi_statut']; //$form_range = $_POST['range']; $form_description = formatText($_POST['description'], '2FIELD'); $form_comment = formatText($_POST['comment'], '2FIELD'); $form_goal = formatText($_POST['goal'], '2FIELD'); $form_consulting = formatText($_POST['consulting'], '2FIELD'); $form_unit = formatText($_POST['unit'], '2FIELD'); $form_max_value = $_POST['max_value']; $form_min_value = $_POST['min_value']; $form_threshold_value = $_POST['threshold_value']; $form_threshold_relative=$table[13]; $form_frequency = $_POST['frequency']; $form_tags = $_POST['tags']; $form_mcolor = $_POST['sdi_mcolor']; $form_tcolor = $_POST['sdi_tcolor']; $form_api_url = formatText($_POST['api-url'], '2FIELD'); $form_api_datefield = formatText($_POST['api-date-field'], '2FIELD'); $form_api_valuefield = formatText($_POST['api-value-field'], '2FIELD'); $form_api_decimal = formatText($_POST['api-decimal'], '2FIELD'); $form_api_values_since = formatText($_POST['api-get-values-since'], '2FIELD'); $form_input_instructions = formatText($_POST['input_instructions'], '2FIELD'); if($form_statut=='D') $mask_statut_D="checked=\"checked\""; else $mask_statut_D=''; if($form_statut=='P') $mask_statut_P="checked=\"checked\""; else $mask_statut_P=''; $table = urlencode(serialize($table)); } // select-box des niveaux $data=$sql_object->DBSelect(SQL_getLevelsList()); $select_level=LevelSelectBox($data, "sdi_level", $form_level); $select_nature=selectBox($lang['sdi']['select_nature'], "sdi_nature", $form_nature); $select_type=selectBox($lang['sdi']['select_type'], "sdi_type", $form_type); $select_dashboard_viz = selectBox($lang['sdi']['select_dashboard_viz'], "sdi_dashboard_viz", $form_dashboard_viz, INDICATOR_DASHBOARD_VIZ); $select_detail_viz = selectBox($lang['sdi']['select_detail_viz'], "sdi_detail_viz", $form_detail_viz); $select_value_type = selectBox($lang['sdi']['select_value_type'], "sdi_value_type", $form_value_type); $select_multiple_type = selectBox($lang['sdi']['select_multiple_type'], "sdi_multiple_type", $form_multiple_type); $select_multiple_mode = selectBox($lang['sdi']['select_multiple_mode'], "sdi_multiple_mode", $form_multiple_mode); $select_unique_mode = selectBox($lang['sdi']['select_unique_mode'], "sdi_unique_mode", $form_unique_mode); $req_list_sdiname=SQL_getOnesdiname($id); $data_sdi_name = $sql_object -> DBSelect($req_list_sdiname); $navtitle=_t('sdi','mod')." : ".$data_sdi_name[0]['sdii_name']; ?>
" + text + "<\/span>"); } else { $("#sdi_dashboard_viz option[value=\'sparkline\']").removeAttr("disabled"); $("#boolean-indic-notice").remove(); } }); // we call the function on loading page $("#sdi_nature").change(); $("#sdi_value_type").change(function() { let initialTypeVal = "'.$data_form_sdi[0]['sdii_value_type'].'"; if($(this).val() != initialTypeVal) { // we perform a check to see if values are already stored. If so, we display a warning !!!! $.ajax({ type: "POST", data: {check_values:"'.$id.'"}, dataType: "json", url: "../dashboard/_ajax_actions.php?token='.SECRET_KEY.'", success: function(data){ if(data.returnedValues > 0) alertify.error("'._t('sdi', 'warning_switch_type').'".replace("%s", data.returnedValues), 0); } }); } if($(this).val() == "multiple") { var text = "'.sprintf(_t('sdi','multipleindicator_notice'), '#attached_to_dashboard').'"; $("#multiple-indic-notice").remove(); $("#sdi_value_type").after("" + text + "<\/span>"); $("#sdi_multiple_type_cont").fadeIn(); $("#sdi_multiple_mode_cont").fadeIn(); $("#sdi_unique_mode_cont").hide(); } else { $("#multiple-indic-notice").remove(); $("#sdi_multiple_type_cont").hide(); $("#sdi_multiple_mode_cont").hide(); $("#sdi_unique_mode_cont").fadeIn(); } }); // we call the function on loading page $("#sdi_value_type").change(); '; footerAddInlineJS($js); ?>

/>
:

:
required /> />

*/ ?>

/>

 : *
/>

/>

:

/>

/>

DBSelect(SQL_getoneLevel($table[3])); isset($record[0]['level_name']) ? $display_sdi_level=formatText($record[0]['level_name'], '2HTML') : $display_sdi_level= _t('sdi', 'no_associated_level'). ' '; // if no associated label if ($table[13]=='Y') $display_sdi_threshold_relative = _t('sdi','threshold_relative_Y'); else $display_sdi_threshold_relative = _t('sdi','threshold_relative_N'); if ($table[14]=='Y') $display_attached_to_dashboard = _t('divers','yes'); else $display_attached_to_dashboard = _t('divers','no'); if($table['chart_force_min'] == 'novalue') $display_f_chart_min = _t('divers', 'no'); else $display_f_chart_min = _t('divers', 'yes') . ' ('. cast_number($table['chart_force_min']) . ')'; $display_sdi_type = formatText($lang['sdi']['select_type'][$table[15]], '2HTML'); $display_sdi_nature = formatText($lang['sdi']['select_nature'][$table['nature']], '2HTML'); $display_sdi_dashboard_viz = formatText($lang['sdi']['select_dashboard_viz'][$table[16]], '2HTML'); $display_sdi_detail_viz = formatText($lang['sdi']['select_detail_viz'][$table[17]], '2HTML'); $display_sdi_value_type = formatText($lang['sdi']['select_value_type'][$table[18]], '2HTML'); $display_sdi_multiple_type = formatText($lang['sdi']['select_multiple_type'][$table['multiple_type']], '2HTML'); $display_sdi_multiple_mode = formatText($lang['sdi']['select_multiple_mode'][$table['multiple_mode']], '2HTML'); $display_sdi_unique_mode = formatText($lang['sdi']['select_unique_mode'][$table['unique_mode']], '2HTML'); $multipleclass = ($table[18] != 'multiple') ? 'invisible' : ''; $uniqueclass = ($table[18] != 'unique') ? 'invisible' : ''; if ($table['api-enabled']=='Y') $display_api_enabled = _t('divers','yes'); else $display_api_enabled = _t('divers','no'); if ($table['api-get-values']=='Y') $display_get_values = _t('divers','yes'); else $display_get_values = _t('divers','no'); if(trim($table['api-get-values-since']) != '') $display_get_values_since = $table['api-get-values-since']; else $display_get_values_since = empty_nc(''); if ($table['api-overwrite-values']=='Y') $display_overwrite_values = _t('divers','yes'); else $display_overwrite_values = _t('divers','no'); $display_api_url = formatText(empty_nc($table['api-url']), '2HTML'); $display_api_decimal = ' (' . _t('sdi','api-decimal') . ' : ' . formatText($table['api-decimal'], '2HTML').')'; if(Stringy\Stringy::create($display_api_url, CHARSET)->isUrl()) $display_api_url = sprintf('%s', $display_api_url, $display_api_url); $display_api_datefield = formatText(empty_nc($table['api-date-field']), '2HTML'); $display_api_valuefield = formatText(empty_nc($table['api-value-field']), '2HTML'); if($table['value-type'] == 'multiple') $display_api_valuefield = $display_api_multimapping_field; $table = urlencode(serialize($table)); ?>

:
:
:
:
:
:
:
' .get_html_colorbox($form_mcolor) . _t('dashboard','value') . '
' . get_html_colorbox($form_tcolor). _t('dashboard','threshold_value').'
'; ?>
:
:
:
:
:
:
:

*/ ?>
:
:
:
:
:
:
:

:
:
:
:
:
:

:
:
:
:
:
:
: