Differences

This shows you the differences between two versions of the page.

--- lampje:leden [2018/03/20 21:46]
Gerben Gieling
+++ lampje:leden [2018/11/23 21:56]
Gerben Gieling
@@ Line 2: / Line 2: @@
 <phpwikify>
-// haal de wontools op, bepaal de taalkeuze en maak verbinding met de databank
+// haal de wontools op, bepaal de taalkeuze, maak verbinding met de databank en definieer de dataarray
   include_once($_SERVER['CONTEXT_DOCUMENT_ROOT'].'/../wontools/dokutools.php');
-  $won_lang=won_doku_lang();
+  $won_lang = won_doku_lang();
-  $won_reader=won_dbread();
+  $won_reader = won_dbread();
+  $won_orgs = array();
 // definieer de zoekvraag
-  $que="
-    select org_type_en,org_type_nl,org_name,org_url
+  $que = "select org_type_id, org_type_en,org_type_nl,org_name,org_url, count(memb_id) as members
-    from adm_organisations join adm_organisation_types using(org_type_id)
+    from adm_organisations join adm_organisation_types using(org_type_id) join adm_members using(org_id)
     where end_date is null or end_date>now()
+    group by org_id
     order by org_type_id desc,org_name
   ";
-// maak lege data arrays om de data in op te slaan
-  $won_org_types=array();
-  $won_orgs=array();
 // haal de data uit de databank en structureer in de data arrays
-  if (!$won_result=$won_reader->query($que)) {echo $won_reader->error;}
-  while ($won_data=$won_result->fetch_object()){
+  if (!$won_result = $won_reader->query($que)) {echo $won_reader->error;}
-    if (!array_key_exists($won_data->org_type_en, $won_org_types)) {
+  while ($won_data = $won_result->fetch_object()){
-      $won_org_types[$won_data->org_type_en]=count($won_orgs);
+    if (!array_key_exists($won_data->org_type_id, $won_orgs)) {
-      $won_orgs[count($won_orgs)]=array(
+      $won_orgs[$won_data->org_type_id] = array (
-        "label_en"=>$won_data->org_type_en,
+        'label_nl' => ucfirst($won_data->org_type_nl),
-        "label_nl"=>$won_data->org_type_nl,
+        'label_en' => ucfirst($won_data->org_type_en),
-        "organisations"=>array()
+        'repcount' => 0,
+        'organisations' => array()
       );
     }
-    $won_orgs[$won_org_types[$won_data->org_type_en]]["organisations"][count($won_orgs[$won_org_types[$won_data->org_type_en]]["organisations"])] =
+    $won_orgs[$won_data->org_type_id]['organisations'][count($won_orgs[$won_data->org_type_id]['organisations'])] = ($won_data->org_url ? "[[$won_data->org_url|$won_data->org_name]]" : $won_data->org_name);
-      ($won_data->org_url ? "[[$won_data->org_url|$won_data->org_name]]" : $won_data->org_name);
+    $won_orgs[$won_data->org_type_id]['repcount']+= $won_data->members;
   }
-  echo "====== ".($won_lang=='nl'? 'Leden' : 'Members')." ======\n";
+// begin met weergave van de data
+  echo "====== ".($won_lang == 'nl' ? 'Leden' : 'Members')." ======\n";
+  echo "===== ".($won_lang == 'nl' ? 'Statistiek' : 'Statistics')." =====\n";
+  echo ($won_lang == 'nl' ? '^ Lid type ^ #Bedrijven ^ #Vertegenwoordigers ^' : '^ Member type ^ #Companies ^ #Representatives ^')."\n";
   reset($won_orgs);
-  foreach ($won_orgs as $won_orgclusters) {
+  foreach ($won_orgs as $won_org) {
-    echo "===== ".($won_lang=='nl'? ucfirst($won_orgclusters['label_nl']) : ucfirst($won_orgclusters['label_en']))." =====\n<WRAP colw20>\n";
+    $label = ($won_lang == 'nl' ? $won_org['label_nl'] : $won_org['label_en'] );
-    echo implode("\n\n", $won_orgclusters['organisations'])."\n\n";
+    $url = str_replace(' ','_',strtolower($label));
+    echo "| [[#$url|$label]] | ".count($won_org['organisations'])." | ${won_org['repcount']} |\n";
+  }
+  echo "===== ".($won_lang == 'nl' ? 'Lijst' : 'List')." =====\n";
+  foreach ($won_orgs as $won_org) {
+    echo "==== ".($won_lang == 'nl' ? $won_org['label_nl'] : $won_org['label_en'])." ====\n<WRAP colw20>\n";
+    echo implode("\n\n", $won_org['organisations'])."\n\n";
     echo "</WRAP>\n";
   }
 </phpwikify>