* @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'); } //////////// if(!isset($_GET['id']) && !isset($_POST['id'])) { $id=1; } else { if(isset($_POST['id'])) $id=$_POST['id']; if(isset($_GET['id'])) $id=$_GET['id']; } if(!isset($_GET['scale_id']) && !isset($_POST['scale_id'])) { $scale_id=1; } else { if(isset($_POST['scale_id'])) $scale_id=$_POST['scale_id']; if(isset($_GET['scale_id'])) $scale_id=$_GET['scale_id']; } //////////// Check Droits utilisateur //////////// if (!$l21auth->hasRight('dashboard') && !$l21auth->hasRight('indicator', $id)) ReloadIndex('admin'); //////////// include_once("../lib/input_helpers.php"); include_once("../dashboard/common.php"); $link_mod_sdi="index.php?&rub=sdi&todo=det&id="; $link_cancel=$rub_link."&todo=det&id=".$id."&scale_id=".$scale_id; if (isset($_POST['enregistrer'])) { $data_table = unserialize(urldecode($_POST['data_table'])); $data_table['user_id'] = $l21auth->GetSessionElement('id'); $sdi_object= new sdi; $result=$sdi_object->AddValue($data_table, $sql_object); $link_confirm="confirm.php?rub=".$rub."&todo=".$todo."&id=".$id."&scale_id=".$scale_id; if(isset($result)) header("Location: ".safe_redirect($link_confirm)); else system_error(); } $form_value =""; $form_sdi_id =""; $form_scale_id = $scale_id; $form_date =""; $form_threshold =""; $form_statut = ""; $mask_statut_P="checked=\"checked\""; $mask_statut_D=''; $form_comment = ""; $mask_statutc_public="checked=\"checked\""; $mask_statutc_private=''; $resultscale = $sql_object -> DBSelect($req_list_scale); $listing=ScaleSelectBox($resultscale, "scale" ,$form_scale_id) ; $sdi_object= new sdi; $req_sdii=SQL_getInfoSdi($id); $result_sdii = $sql_object -> DBSelect($req_sdii); $indicator_name = formatText($result_sdii[0]['sdii_name'], '2HTML'); $req_sdiav=SQL_getAllValue("SCA", $scale_id, $id); $result_value = $sql_object -> DBSelect($req_sdiav); $navtitle=_t('dashboard','add')." : ". $indicator_name; if($result_sdii[0]['sdii_type'] == 'boolean' || $result_sdii[0]['sdii_type'] == 'qualitative') { $a = getBooleanValues($result_sdii[0]); if($a) { $index = array(); foreach ($a as $key => $value) { array_push($index, $key); } $maskminvalue = $a[min($index)]; $maskmaxvalue = $a[max($index)]; if(isset($result_sdii[0]['sdii_threshold_value'])) $maskthreshold = $a[$result_sdii[0]['sdii_threshold_value']]; } } // setting $form_threshold value // By default initial value $default_threshold = $result_sdii[0]['sdii_threshold_value']; // if set, we get the latest for the given scale $r = $sql_object -> DBSelect(SQL_getlastInsertByPublicationDate($id, $scale_id)); if(isset($r[0]['sdiv_value']) && !is_null($r[0]['sdiv_threshold'])) { $form_threshold = $r[0]['sdiv_threshold']; } else { $form_threshold = $default_threshold; if($result_sdii[0]['sdii_type'] != 'quantitative' && $default_threshold == '') $form_threshold = -1; } // we init the value form with one row // only for multivalues if($result_sdii[0]['sdii_value_type'] == 'multiple') { // we get the latest values to pre-fill the form if(!empty($r[0]['sdiv_multivalue'])) { $form_values = unserialize($r[0]['sdiv_multivalue']); foreach($form_values as $key => &$value) { // we init the latest values $value['value'] = ''; } // $form_values = array(array('value' => '', 'label'=> '')); } else { $form_values = array(array('value' => '', 'label'=> '')); } } if (isset($_POST['valider1'])) { // we populate the form and the array if($result_sdii[0]['sdii_value_type'] == 'unique') { $form_value = $_POST['value']; $table[0] = $_POST['value']; // if indicator has several values } else { $a = array(); $form_values = array(); $i = 0; foreach($_POST['values'] as &$value) { $form_values[$i]['value'] = $value; $i++; } $i = 0; foreach($_POST['labels'] as &$label) { $form_values[$i]['label'] = $label; $i++; } $table[0] = $form_values; } $table[1] = $_POST['id']; // for boolean / qualitative values if($_POST['threshold'] == -1) $table[2] = ''; else $table[2] = $_POST['threshold']; $table[3] = $_POST['scale']; $table[4] = $_POST['date']; $table[5] = $_POST['statut']; $table[6] = $_POST['comment']; $table[7] = $_POST['statutc']; $sdi_object = new sdi; $integrity = $sdi_object -> CheckDataIntegrity_value($table, $sql_object); $form_sdi_id =$_POST['id']; $form_threshold = $_POST['threshold']; $form_scale_id =$_POST['scale']; $form_date =$_POST['date']; $form_statut = $_POST['statut']; $form_statutc = $_POST['statutc']; 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=''; if($form_statutc=='Y') $mask_statutc_public="checked=\"checked\""; else $mask_statutc_public=''; if($form_statutc=='N') $mask_statutc_private="checked=\"checked\""; else $mask_statutc_private=''; $table = urlencode(serialize($table)); } // foundation Datepicker include addDynamicCSS('../lib/js/foundation-datepicker/stylesheets/foundation-datepicker.css'); footerAddJS('../lib/js/foundation-datepicker/js/foundation-datepicker.js'); ?>
DBSelect($req_scale); $display_comment = formatText(empty_none($_POST['comment']), '2HTML'); ($form_statutc == 'Y') ? $display_comment_status = _t('dashboard', 'public') : $display_comment_status = _t('dashboard', 'private'); $display_sdi_value = ''; $total = 0; if(is_array($table[0])) { foreach($table[0] as &$value) { if($value['value'] > 0) $total += $value['value']; // do not add negative values $display_sdi_value .= ''; $display_sdi_value .= mb_ucfirst(formatText($value['label'], 'HTML')).' : '; $display_sdi_value .= fnumber_format($value['value'], 'auto', false); $display_sdi_value .= ' ('.$result_sdii[0]['sdii_unit'].')'; $display_sdi_value .= '
'.PHP_EOL; } // we display the total $display_sdi_value .= ''; $display_sdi_value .= mb_ucfirst(_t('dashboard', 'multivalue_total')) . ' : ' . fnumber_format($total, 'auto', false); $display_sdi_value .= '
'; } else { if($result_sdii[0]['sdii_type'] == 'quantitative') { $display_sdi_value .= $table[0]." (".$result_sdii[0]['sdii_unit'].")"; $display_threshold_value = empty_none($table[2]); } else { $display_sdi_value .= $a[$table[0]]." (".$result_sdii[0]['sdii_unit'].")"; if($table[2] == '')$display_threshold_value = empty_none($table[2]); else $display_threshold_value = $a[$table[2]]; } } //afficher nom de scale $display_sdi_scale = formatText($resultscale2[0]['scale_denomination'], '2HTML'); $display_sdi_date = $table[4]; $display_sdi_statut= $table[5]; $table = urlencode(serialize($table)); ?>