linea21-modules
[ class tree: linea21-modules ] [ index: linea21-modules ] [ all elements ]
Packages:
linea21-core
linea21-externals
linea21-languages
linea21-modules
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\">".$GLOBALS['lang']['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=\"".$GLOBALS['lang']['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\">".$GLOBALS['lang']['dashboard']['global_value']."</span><img src=\"../gfx/" .THEME_ADMIN. "/images/admin/barre_gris.gif\" alt=\"".$GLOBALS['lang']['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 >".$GLOBALS['lang']['dashboard']['global_value']."</span> <img src=\"../gfx/" .THEME_ADMIN. "/images/admin/barre.gif\" alt=\"".$GLOBALS['lang']['dashboard']['global_value']."\" />";
  98. $listing2.="<img src=\"../gfx/" .THEME_ADMIN. "/images/admin/cursor.gif\" alt=\"".$GLOBALS['lang']['dashboard']['global_value'].": ".$value_globale.
  99. "\n".$GLOBALS['lang']['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>
  115.             <a href="index.php"><? echo $GLOBALS['lang']['way']['home']; ?></a>
  116.         </li>
  117.         <li>
  118.             <a href="<?php echo $rub_link; ?>"><? echo $GLOBALS['lang']['menu']['dashboard'];?></a>
  119.         </li>
  120.         <li>
  121.             <span><? echo $GLOBALS['lang']['dashboard']['list']; ?></span>
  122.         </li>
  123.     </ul>
  124. </div>
  125.   <!--end barre haute -->
  126. <?php
  127. function value_barre ($value, $max_value, $min_value, $threshold_value, $threshold_relative){
  128. if ($max_value==0) $max_value=0.000001;
  129. if ($min_value==0) $min_value=0.000001;
  130. if ($threshold_relative=='Y') {
  131. $unitup=50/($max_value-$threshold_value);
  132. $unitdown=50/($threshold_value-$min_value);
  133. if ($value>$threshold_value) $result=50+(($value-$threshold_value)*$unitup);
  134. else $result=50-(($threshold_value-$value)*$unitdown);
  135. }
  136. else{
  137. $unitdown=50/($max_value-$threshold_value);
  138. $unitup=50/($threshold_value-$min_value);
  139. if ($value>$threshold_value) $result=50-(($value-$threshold_value)*$unitdown);
  140. else $result=50+(($threshold_value-$value)*$unitup);
  141. }
  142. return (int)$result;
  143. }
  144. function aff_barre($scale_id, $id, $max_value, $min_value, $threshold_value, $sdi_object, $sql_object, $lang, $unit, $threshold_relative){
  145. //$req_sdiav=SQL_getInfoSdi("SCA", $scale_id, $id, $sql_object);
  146.  
  147. $req_sdiav=SQL_getAllValue("SCA", $scale_id, $id);    
  148. $result_value = $sql_object -> DBSelect($req_sdiav);
  149.  
  150.  
  151. if ($result_value<>false){
  152. $value_cursor1=value_barre ($result_value[0]['sdiv_value'], $max_value, $min_value, $threshold_value, $threshold_relative);
  153. $value_cursor=111- $value_cursor1;
  154. }
  155. else $value_cursor1="";
  156. if ($result_value==false) {
  157.     $listing="<div class=\"imagebarre\">\n<img src=\"../gfx/" .THEME_ADMIN. "/images/admin/barre_gris.gif\" title=\"".$GLOBALS['lang']['dashboard']['novalue']."\" />\n</div>\n";
  158. }
  159. else{
  160. $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=\"../gfx/" .THEME_ADMIN. "/images/admin/barre.gif\" alt=\"".$GLOBALS['lang']['dashboard']['value'].": ".$result_value[0]['sdiv_value']." ".$unit.
  161. "\n ".$GLOBALS['lang']['sdi']['min_value'].": ".$min_value." ".$unit.
  162. "\n ".$GLOBALS['lang']['sdi']['threshold_value'].": ".$threshold_value." ".$unit.
  163. "\n ".$GLOBALS['lang']['sdi']['max_value'].": ".$max_value." ".$unit.
  164. "\"  /><span>".$GLOBALS['lang']['dashboard']['value'].": ".$result_value[0]['sdiv_value']." ".$unit.
  165. "<br /> ".$GLOBALS['lang']['sdi']['min_value'].": ".$min_value." ".$unit.
  166. "<br /> ".$GLOBALS['lang']['sdi']['threshold_value'].": ".$threshold_value." ".$unit.
  167. "<br /> ".$GLOBALS['lang']['sdi']['max_value'].": ".$max_value." ".$unit.
  168. "</span></a>";
  169. $listing.="<img src=\"../gfx/" .THEME_ADMIN. "/images/admin/cursor.gif\" title=\"".$GLOBALS['lang']['dashboard']['value'].": ".$result_value[0]['sdiv_value'].
  170. " ".$GLOBALS['lang']['dashboard']['barre']."\" class=\"cursor\" style=\"left:-".$value_cursor."px;\"/>";
  171. if (isset($result_value[1]['sdiv_value'])) {
  172. if ($result_value[0]['sdiv_value']>=$result_value[1]['sdiv_value']) $listing.="<img src=\"../gfx/" .THEME_ADMIN. "/images/admin/ico_asc.gif\" alt=\"".$GLOBALS['lang']['dashboard']['value_tendance']."\" />";
  173. else $listing.="<img src=\"../gfx/" .THEME_ADMIN. "/images/admin/ico_desc.gif\" alt=\"".$GLOBALS['lang']['dashboard']['value_tendance']."\" />";
  174. }
  175. $listing.="\t<span class=\"value\"> (".(int)$result_value[0]['sdiv_value'].")</span></div>\n";
  176. }
  177. $result=array($value_cursor1, $listing);
  178. return     $result;
  179. }
  180. include_once("quickicons.php");
  181. ?>
  182. <div class="contentcontainer">
  183. <?php    include_once($dir."/menurub.php");    ?>
  184. <div id="content">
  185. <?
  186. echo $listing3;
  187. echo $listing2;
  188. echo $listing;
  189. ?>
  190. </div>
  191. <?php include_once($dir."/help.php"); ?>
  192. </div>
Documentation generated on Sat, 08 Nov 2008 14:53:04 +0100 by phpDocumentor 1.4.1