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 export_xml.php

Documentation is available at export_xml.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. /***********************
  12. * paramétrage du fichier XML
  13. * 
  14. * *************************/
  15.  
  16. /*********************
  17. * contenu du fichier XML 
  18. * valeurs posssibles : 
  19. * P (format public) 
  20. * A (format admin)
  21. ************************/
  22. $format="P";
  23.  
  24. /*********************
  25. * liste des indicateurs 
  26. * valeurs posssibles : 
  27. * R (statut<>'E') 
  28. * P (statut='P')
  29. ************************/
  30. if ($format=="A")$filter_sdi="R";
  31. else $filter_sdi="P";
  32. /*********************
  33. * liste des valeurs
  34. * valeurs posssibles : 
  35. * D (statut<>'E') 
  36. * SCP (statut='P') sdiv_date_published ASC
  37. * SCD (statut='P') sdiv_date_published DESC
  38. * SCA (statut<>'E') sdiv_date_published DESC
  39. ************************/
  40.  
  41. if ($format=="A") $filter_value="D";
  42. else $filter_value="SCD";
  43.  
  44. define('TAB_LINE2',"");
  45. define('END_LINE2',"");
  46. include_once("../config/define.php");
  47. include_once("../config/server.php");
  48. include_once("../lib/no_cache.php");
  49. include_once("../lib/functions_auth.php");
  50. include_once('../lib/lang.php'); 
  51. IncludeAdminLang("dashboard");
  52. include_once("../lib/lib_common.php");
  53. include_once("../class/system/class.".SQL.".php");
  54. include_once(SQL.'.inc.php');
  55. include_once('../class/class.sdi.php');
  56. $sql_entity=SQL;
  57. $sql_object = new $sql_entity;
  58. $sql_object -> DBInitialise();
  59. $sql_object -> DBConnexion();
  60.  
  61.  
  62. $sdi_object= new sdi;
  63. $result=$sql_object->DBSelect($req_list_theme);
  64.  
  65. $req_sdi=SQL_getListSdi($filter_sdi, $valueparam=0);
  66. $result_sdi = $sql_object -> DBSelect($req_sdi);
  67. header('Content-Type: text/xml');
  68. $listing="<?xml version=\"1.0\" encoding=\"".CHARSET."\"?>".END_LINE2."<dashboard>" . END_LINE2;
  69.  
  70. $current_sdtheme='';
  71. $current_theme='';
  72. for ($i=0;$i<count($result);$i++){
  73.     if ($result[$i]['sdtheme_id']!=$current_sdtheme) {
  74.         $current_sdtheme=$result[$i]['sdtheme_id'];
  75.         $aff_theme=false;
  76.         if ($i!=0)$listing.=TAB_LINE2."</theme>".END_LINE2."</sdtheme>" . END_LINE2;
  77.         $listing.="<sdtheme id=\"".$result[$i]['sdtheme_id']."\" title=\"".formatText($result[$i]['sdtheme_name'], '2XML')."\">" . END_LINE2;
  78.         
  79.     }
  80.     else $aff_theme=true;
  81.     
  82.     if ($result[$i]['theme_id']!=$current_theme) {
  83.         $current_theme=$result[$i]['theme_id'];
  84.         if ($aff_theme==true) $listing.=TAB_LINE2."</theme>" . END_LINE2;
  85.         $listing.= TAB_LINE2."<theme id=\"".$result[$i]['theme_id']."\" title=\"".formatText($result[$i]['theme_name'], '2XML')."\">" . END_LINE2;        
  86.     }        
  87.  
  88.     
  89.     for ($j=0;$j<count($result_sdi);$j++){
  90.     if ($result[$i]['theme_id']==$result_sdi[$j]['sdii_theme']) {
  91.     
  92.     
  93.     $req_sdii=SQL_getInfoSdi($result_sdi[$j]['sdii_id']);
  94. $result_sdii = $sql_object -> DBSelect($req_sdii);
  95.  
  96. $req_sdir=SQL_getRules( $result_sdi[$j]['sdii_id'], $sql_object, -1);
  97. $result_r = $sql_object -> DBSelect($req_sdir);
  98.  
  99. $req_sdie=SQL_getEvaluation( $result_sdi[$j]['sdii_id'], $sql_object,-1);
  100. $result_e = $sql_object -> DBSelect($req_sdie);
  101.  
  102. $req_sdip=SQL_getProvider( $result_sdi[$j]['sdii_id'], $sql_object,-1);
  103. $result_p = $sql_object -> DBSelect($req_sdip);
  104.  
  105. $req_scale=SQL_getlistscale(0);
  106. $resultscale = $sql_object -> DBSelect($req_scale);
  107.  
  108.     //formattage des infos générales
  109.     $listing.=TAB_LINE2.TAB_LINE2."<indicator id=\"".$result_sdi[$j]['sdii_id']."\">" . END_LINE2;
  110.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<title>".formatText($result_sdi[$j]['sdii_name'], '2XML')."</title>" . END_LINE2;
  111.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<description>".formatText($result_sdii[0]['sdii_description'], '2XML')."</description>" . END_LINE2;
  112.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<comment>".formatText($result_sdii[0]['sdii_comment'], '2XML')."</comment>" . END_LINE2;
  113.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<range>".formatText($result_sdii[0]['sdii_range'], '2XML')."</range>" . END_LINE2;
  114.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<goal>".formatText($result_sdii[0]['sdii_goal'], '2XML')."</goal>" . END_LINE2;
  115.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<consulting>".formatText($result_sdii[0]['sdii_consulting'], '2XML')."</consulting>" . END_LINE2;
  116.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<unit>".formatText($result_sdii[0]['sdii_unit'], '2XML')."</unit>" . END_LINE2;
  117.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<max_value>".formatText($result_sdii[0]['sdii_max_value'], '2XML')."</max_value>" . END_LINE2;
  118.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<min_value>".formatText($result_sdii[0]['sdii_min_value'], '2XML')."</min_value>" . END_LINE2;
  119.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<threshold_value>".formatText($result_sdii[0]['sdii_threshold_value'], '2XML')."</threshold_value>" . END_LINE2;
  120.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<threshold_relative>".formatText($result_sdii[0]['sdii_threshold_relative'], '2XML')."</threshold_relative>" . END_LINE2;
  121.     
  122.     if ($format=="A"){
  123.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<frequency>".formatText($result_sdii[0]['sdii_frequency'], '2XML')."</frequency>" . END_LINE2;
  124.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<date_crea>".formatText($result_sdii[0]['sdii_date_crea'], '2XML')."</date_crea>" . END_LINE2;
  125.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<last_modify>".formatText($result_sdii[0]['sdii_last_modify'], '2XML')."</last_modify>" . END_LINE2;
  126.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<statut>".formatText($result_sdii[0]['sdii_statut'], '2XML')."</statut>" . END_LINE2;
  127.     //formattage des infos du fournisseur
  128.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<provider id=\"".$result_p[0]['sdip_id']."\">". END_LINE2;
  129.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<title>".formatText($result_p[0]['sdip_name'], '2XML')."</title>" . END_LINE2;
  130.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<service>".formatText($result_p[0]['sdip_service'], '2XML')."</service>" . END_LINE2;
  131.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<description>".formatText($result_p[0]['sdip_description'], '2XML')."</description>" . END_LINE2;
  132.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<incharge>".formatText($result_p[0]['sdip_incharge'], '2XML')."</incharge>" . END_LINE2;
  133.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<address>".formatText($result_p[0]['sdip_address'], '2XML')."</address>" . END_LINE2;
  134.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<phone>".formatText($result_p[0]['sdip_phone'], '2XML')."</phone>" . END_LINE2;
  135.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<fax>".formatText($result_p[0]['sdip_fax'], '2XML')."</fax>" . END_LINE2;
  136.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<email>".formatText($result_p[0]['sdip_email'], '2XML')."</email>" . END_LINE2;
  137.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<date_crea>".formatText($result_p[0]['date_c'], '2XML')."</date_crea>" . END_LINE2;
  138.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<last_modify>".formatText($result_p[0]['date_m'], '2XML')."</last_modify>" . END_LINE2;
  139.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."</provider>". END_LINE2;
  140.         
  141.     //formattage des infos de réglementation
  142.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<reglementation id=\"".$result_r[0]['sdir_id']."\">". END_LINE2;
  143.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<title>".formatText($result_r[0]['sdir_title'], '2XML')."</title>" . END_LINE2;
  144.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<body>".formatText($result_r[0]['sdir_body'], '2XML')."</body>" . END_LINE2;
  145.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<referer_uri>".formatText($result_r[0]['sdir_referer_uri'], '2XML')."</referer_uri>" . END_LINE2;
  146.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<mask_uri>".formatText($result_r[0]['sdir_mask_uri'], '2XML')."</mask_uri>" . END_LINE2;
  147.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<date_crea>".formatText($result_p[0]['date_c'], '2XML')."</date_crea>" . END_LINE2;
  148.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<last_modify>".formatText($result_p[0]['date_m'], '2XML')."</last_modify>" . END_LINE2;
  149.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."</reglementation>". END_LINE2;
  150.     
  151.     //formattage des infos d'évaluation
  152.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."<evaluation id=\"".$result_e[0]['sdie_id']."\">". END_LINE2;
  153.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<scale_compare>".formatText($result_e[0]['sdie_scale_compare'], '2XML')."</scale_compare>" . END_LINE2;
  154.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<fiability>".formatText($result_e[0]['sdie_fiability'], '2XML')."</fiability>" . END_LINE2;
  155.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<accessibility>".formatText($result_e[0]['sdie_accessibility'], '2XML')."</accessibility>" . END_LINE2;
  156.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<lisibility>".formatText($result_e[0]['sdie_lisibility'], '2XML')."</lisibility>" . END_LINE2;
  157.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<relevance>".formatText($result_e[0]['sdie_relevance'], '2XML')."</relevance>" . END_LINE2;
  158.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<global_performance>".formatText($result_e[0]['sdie_global_performance'], '2XML')."</global_performance>" . END_LINE2;
  159.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<date_crea>".formatText($result_p[0]['date_c'], '2XML')."</date_crea>" . END_LINE2;
  160.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<last_modify>".formatText($result_p[0]['date_m'], '2XML')."</last_modify>" . END_LINE2;
  161.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2."</evaluation>". END_LINE2;
  162.     }
  163.     //formattage des valeurs
  164.     for ($z=0;$z<count($resultscale);$z++){
  165.     
  166.     $req_sdiav=SQL_getAllValue($filter_value, $resultscale[$z]['scale_id'], $result_sdi[$j]['sdii_id']);    
  167.     $result_value = $sql_object -> DBSelect($req_sdiav);
  168.     if ($result_value[0]['sdiv_value']<>""){
  169.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<scale id=\"".$resultscale[$z]['scale_id']."\">". END_LINE2;
  170.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<title>".formatText($resultscale[$z]['scale_denomination'], '2XML')."</title>" . END_LINE2;
  171.     for ($h=0;$h<count($result_value);$h++){
  172.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<value id=\"".$result_value[$h]['sdiv_id']."\">". END_LINE2;
  173.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<num_value>".formatText($result_value[$h]['sdiv_value'], '2XML')."</num_value>" . END_LINE2;
  174.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<date_published>".formatText($result_value[$h]['date_p'], '2XML')."</date_published>" . END_LINE2;
  175.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<date_crea>".formatText($result_value[$h]['date_c'], '2XML')."</date_crea>" . END_LINE2;
  176.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<last_modify>".formatText($result_value[$h]['date_m'], '2XML')."</last_modify>" . END_LINE2;
  177.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."<statut>".formatText($result_value[$h]['sdiv_statut'], '2XML')."</statut>" . END_LINE2;
  178.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."</value>". END_LINE2;
  179.     }
  180.     $listing.=TAB_LINE2.TAB_LINE2.TAB_LINE2.TAB_LINE2."</scale>". END_LINE2;
  181.     }
  182.     }    
  183.     
  184.     $listing.=TAB_LINE2.TAB_LINE2."</indicator>" . END_LINE2; 
  185.     }
  186.     }
  187.  
  188. }
  189. $listing.=TAB_LINE2."</theme>".END_LINE2."</sdtheme>" . END_LINE2."</dashboard>" . END_LINE2;
  190.  
  191. echo $listing;
  192.  
  193. ?>
Documentation generated on Sat, 08 Nov 2008 14:52:12 +0100 by phpDocumentor 1.4.1