linea21-modules
[ class tree: linea21-modules ] [ index: linea21-modules ] [ all elements ]
Packages:
linea21-core
linea21-externals
linea21-languages
linea21-modules
linea21-templates
linea21-utils

Source for file list.php

Documentation is available at list.php

  1. <?php
  2. /**
  3.  * @package linea21.modules
  4.  * @subpackage dashboard
  5.  * @author linea21 <info@linea21.com>
  6.  * @version $id SVN
  7.  * @access public
  8.  * @license http://opensource.org/licenses/gpl-3.0.html
  9.  */
  10.  
  11. //////////// Check Inclusion de pages ////////////
  12. if (!function_exists('AuthenthificationProcess')){
  13.   include_once("../lib/lib_common.php");
  14.   ReloadIndex('admin');
  15. }
  16. ////////////
  17.  
  18. //$scale_id=1;
  19. include_once("../lib/input_helpers.php");
  20. $result=$sql_object->DBSelect($req_list_theme);
  21. $sdi_object= new sdi;
  22. //$result_sdi=$sdi_object->GetListSdi($filter="R", $valueparam=0, $sql_object);
  23. $req_sdi=SQL_getListSdi($filter="R", $valueparam=0);
  24. $result_sdi = $sql_object -> DBSelect($req_sdi);
  25.  
  26. $link_sup=$rub_link."&amp;todo=sup&amp;id=";
  27. $link_add=$rub_link."&amp;todo=add&amp;id=";
  28. $link_det=$rub_link."&amp;todo=det&amp;id=";
  29. $link_list_scale=$rub_link."&amp;todo=list&amp;scale_id=";
  30.  
  31. if (!isset($_GET['scale_id']) && !isset($_POST['scale_id'])) {
  32.   $scale_id = 1;
  33. } else {
  34.   if (isset($_POST['scale_id'])) $scale_id = $_POST['scale_id'];
  35.   if (isset($_GET['scale_id'])) $scale_id = $_GET['scale_id'];
  36. }
  37.  
  38. $req_scale=SQL_getonescale($scale_id);
  39. $resultscale2 = $sql_object -> DBSelect($req_scale);
  40.  
  41. $listing="";
  42. $current_sdtheme='';
  43. for ($i=0;$i<count($result);$i++){
  44.   if ($result[$i]['sdtheme_id']!=$current_sdtheme && $current_sdtheme<>'') {
  45.     $listing.="</ul>\n";
  46.     $listing.="</div>\n";
  47.   }
  48.   if ($result[$i]['sdtheme_id']!=$current_sdtheme) {
  49.     $current_sdtheme=$result[$i]['sdtheme_id'];
  50.     $listing.="<div class=\"h2sdtheme\"><a href=\"\">".formatText($result[$i]['sdtheme_name'], '2HTML')."</a></div>";
  51.     $listing.="<div class=\"sdtheme\">\n";
  52.     $listing.="<ul>\n";
  53.   }
  54.   for ($j=0;$j<count($result_sdi);$j++){
  55.     if ($result[$i]['theme_id']==$result_sdi[$j]['sdii_theme']) {
  56.       $listing.="\t<li class=\"li2\">\n";
  57.       $aff_bare=aff_barre($scale_id, $result_sdi[$j]['sdii_id'], $result_sdi[$j]['sdii_max_value'], $result_sdi[$j]['sdii_min_value'], $result_sdi[$j]['sdii_threshold_value'], $sdi_object, $sql_object, $lang, $result_sdi[$j]['sdii_unit'], $result_sdi[$j]['sdii_threshold_relative']);
  58.       $listing.=$aff_bare[1];
  59.       $listing.="\t<div>\n";
  60.       $listing.="\t\t<a href=\"".$link_det.$result_sdi[$j]['sdii_id']."&amp;scale_id=".$scale_id."\" title=\"".formatText($result_sdi[$j]['sdii_name'], '2HTML')."\">".formatTextli($result_sdi[$j]['sdii_name'])."</a>\n";
  61.       if ($result_sdi[$j]['sdii_statut']=='D') $listing.="<span class=\"state\">"._t('statut','draft')."</span>\n";
  62.       $listing.="\t\t<a href=\"".$link_add.$result_sdi[$j]['sdii_id']."&amp;scale_id=".$scale_id."\" class=\"ico_add\" title=\""._t('dashboard','add')."\"></a>\n";
  63.       $listing.="\t</div>\n";
  64.       $listing.="\t</li>\n";
  65.       $barre_globale[$j]=$aff_bare[0];
  66.     }
  67.   }
  68. }
  69. $listing.="</ul>\n";
  70. $listing.="</div>\n";
  71.  
  72. //calcul de la valeur de la barre globale
  73. $value_globale="";
  74. $z="";
  75. $i="";
  76. if(isset($barre_globale)) {
  77.   for ($z=0;$z<count($barre_globale);$z++){
  78.     if ($barre_globale[$z]>0) {
  79.       $value_globale+=$barre_globale[$z];
  80.       $i++;
  81.     }
  82.   }
  83. }
  84. if ($i<>0) {
  85.   $value_globale=$value_globale/$i;
  86.   $value_globale=round($value_globale, 1);
  87.   $value_curs=111-$value_globale;
  88. }
  89.  
  90. if ($i==0) {
  91.   $listing2="<div class=\"globalvalue\">";
  92.   $listing2.="<div class=\"imagebarre\">\n<span class=\"globalvaluetext\">"._t('dashboard','global_value')."</span><img src=\"" .THEME_ADMIN_PATH. "images/barre_gris.gif\" alt=\""._t('dashboard','novalue')."\" />\n</div>\n";
  93.   $listing2.="</div><br class=\"brendstep\" />";
  94. }
  95. else {
  96.   $listing2="<div class=\"globalvalue\">";
  97.   $listing2.="<div class=\"imagebarre\"><span >"._t('dashboard','global_value')."</span> <img src=\"" .THEME_ADMIN_PATH. "images/barre.gif\" alt=\""._t('dashboard','global_value')."\" />";
  98.   $listing2.="<img src=\"" .THEME_ADMIN_PATH. "images/cursor.gif\" alt=\""._t('dashboard','global_value').": ".$value_globale.
  99. "\n"._t('dashboard','barre')."\" class=\"cursor\" style=\"left:-".$value_curs."px;\"/>";
  100.   $listing2.="\t<span class=\"value\"> (".(int)$value_globale.")</span></div>\n";
  101.   $listing2.="</div><br class=\"brendstep\" />";
  102. }
  103. //affichage selectbox échelle
  104.  
  105. $resultscale = $sql_object -> DBSelect($req_list_scale);
  106. $listing3="<h2>".formatText($resultscale2[0]['scale_denomination'], '2HTML')."</h2>";
  107. $listing3.="<div class=\"listselect\">";
  108. $listing3.=ScaleSelectBox($resultscale, "scale", $scale_id, $link_list_scale);
  109. $listing3.="</div>\n";
  110.  
  111. ?>
  112. <div id="chemin">
  113. <ul>
  114.     <li><a href="index.php" class="chemin_home"><?php echo _t('way','home'); ?></a>
  115.     </li>
  116.     <li><a href="<?php echo $rub_link; ?>" id="chemin_<?php echo $rub; ?>"
  117.         class="chemin_rub"><?php echo _t('menu','dashboard');?></a></li>
  118.     <li><span><?php echo _t('dashboard','list'); ?></span></li>
  119. </ul>
  120. </div>
  121. <!--end barre haute -->
  122. <?php
  123. function value_barre ($value, $max_value, $min_value, $threshold_value, $threshold_relative){
  124.   if ($max_value==0) $max_value=0.000001;
  125.   if ($min_value==0) $min_value=0.000001;
  126.   if ($threshold_relative=='Y') {
  127.     $unitup=50/($max_value-$threshold_value);
  128.     $unitdown=50/($threshold_value-$min_value);
  129.     if ($value>$threshold_value) $result=50+(($value-$threshold_value)*$unitup);
  130.     else $result=50-(($threshold_value-$value)*$unitdown);
  131.   }
  132.   else{
  133.     if(($max_value - $threshold_value) <> 0) $unitdown=50/($max_value-$threshold_value);
  134.     if(($threshold_value - $min_value) <> 0) $unitup=50/($threshold_value-$min_value);
  135.     if ($value>$threshold_value) $result=50-(($value-$threshold_value)*$unitdown);
  136.     else $result=50+(($threshold_value-$value)*$unitup);
  137.   }
  138.   return (int)$result;
  139. }
  140. function aff_barre($scale_id, $id, $max_value, $min_value, $threshold_value, $sdi_object, $sql_object, $lang, $unit, $threshold_relative){
  141.   //$req_sdiav=SQL_getInfoSdi("SCA", $scale_id, $id, $sql_object);
  142.  
  143.   $req_sdiav=SQL_getAllValue("SCA", $scale_id, $id);
  144.   $result_value = $sql_object -> DBSelect($req_sdiav);
  145.  
  146.  
  147.   if ($result_value<>false){
  148.     $value_cursor1=value_barre ($result_value[0]['sdiv_value'], $max_value, $min_value, $threshold_value, $threshold_relative);
  149.     $value_cursor=111- $value_cursor1;
  150.   }
  151.   else $value_cursor1="";
  152.   if ($result_value==false) {
  153.     $listing="<div class=\"imagebarre\">\n<img src=\"" .THEME_ADMIN_PATH. "images/barre_gris.gif\" title=\""._t('dashboard','novalue')."\" />\n</div>\n";
  154.   }
  155.   else{
  156.     $listing="<div class=\"imagebarre\"><a href=\"index.php?rub=dashboard&amp;todo=det&amp;id=".$id."&amp;scale_id=".$scale_id."\" class=\"barre\"><img src=\"" .THEME_ADMIN_PATH. "images/barre.gif\" alt=\""._t('dashboard','value').": ".$result_value[0]['sdiv_value']." ".$unit.
  157. "\n "._t('sdi','min_value').": ".$min_value." ".$unit.
  158. "\n "._t('sdi','threshold_value').": ".$threshold_value." ".$unit.
  159. "\n "._t('sdi','max_value').": ".$max_value." ".$unit.
  160. "\"  /><span>"._t('dashboard','value').": ".$result_value[0]['sdiv_value']." ".$unit.
  161. "<br /> "._t('sdi','min_value').": ".$min_value." ".$unit.
  162. "<br /> "._t('sdi','threshold_value').": ".$threshold_value." ".$unit.
  163. "<br /> "._t('sdi','max_value').": ".$max_value." ".$unit.
  164. "</span></a>";
  165.     $listing.="<img src=\"" .THEME_ADMIN_PATH. "images/cursor.gif\" title=\""._t('dashboard','value').": ".$result_value[0]['sdiv_value'].
  166. " "._t('dashboard','barre')."\" class=\"cursor\" style=\"left:-".$value_cursor."px;\"/>";
  167.     if (isset($result_value[1]['sdiv_value'])) {
  168.       if ($result_value[0]['sdiv_value']>=$result_value[1]['sdiv_value']) $listing.="<img src=\"" .THEME_ADMIN_PATH. "images/ico_asc.gif\" alt=\""._t('dashboard','value_tendance')."\" />";
  169.       else $listing.="<img src=\"" .THEME_ADMIN_PATH. "images/ico_desc.gif\" alt=\""._t('dashboard','value_tendance')."\" />";
  170.     }
  171.     $listing.="\t<span class=\"value\"> (".(int)$result_value[0]['sdiv_value'].")</span></div>\n";
  172.   }
  173.   $result=array($value_cursor1, $listing);
  174.   return     $result;
  175. }
  176. include_once(THEME_ADMIN_PATH."quickicons.php");
  177. ?>
  178. <div class="contentcontainer"><?php    include_once($dir."/menurub.php");    ?>
  179. <div id="content"><?
  180. echo $listing3;
  181. echo $listing2;
  182. echo $listing;
  183. ?></div>
  184. <?php include_once($dir."/help.php"); ?></div>
Documentation generated on Fri, 01 Apr 2011 09:32:38 +0200 by phpDocumentor 1.4.1