7 geteld criterium moet overal er uit
? top 10 plaatsen, top 10 gemeenten, top 10 provincies moet weg uit non-administrator mode
? groepeer op gemiddelden holdings moet er in
*/
// $pass = 'nowayman';
$product_name['eko'] = 'EKO';
$product_name['extra_product'] = 'fairtrade';
$colors['EKO']['start'] = '9CCF9C';
$colors['EKO']['end'] = '669966';
$colors['fairtrade']['start'] = '3366FF';
$colors['fairtrade']['end'] = '003DF5';
$colors['Verantwoorde koffie']['start'] = '994D00';
$colors['Verantwoorde koffie']['end'] = '990000';
//MAIN
set_time_limit(0);
$font = 1;
// $debug = 1;
$include_path = "../include";
$template_dir = "../template";
$images_dir = "../images";
$dump_dir = "../dump";
$archive_dir = "$dump_dir/archive";
$language_dir = "../language";
$javascript_dir = "../javascript";
$phorm_dir = "../../../../phorm";
require_once "$include_path/functions.inc";
require_once "$include_path/createGraph.inc";
require_once "$include_path/graph.inc";
require_once "$include_path/graphG.inc";
require_once "$include_path/createLineGraph.inc";
require_once "$include_path/lineGraph.inc";
require_once "$include_path/lineGraphG.inc";
require_once "$include_path/overview.inc";
require_once "$include_path/stats.inc";
require_once "$include_path/updateMunicipality.inc";
require_once "$include_path/htmlShowArray.inc";
require_once "$include_path/indexFullText.inc";
require_once "$language_dir/Nederlands.inc";
//opens database connection
require_once "$include_path/open_db.inc";
//init config keys
require_once "$include_path/config_keys.inc";
session_start();
global $_cc_forms;
$_cc_forms = $_SESSION['cc_forms'];
// if ($_REQUEST['doit'] == $pass) {
//report($_SESSION);
if ($_SESSION['_cc_forms']['user']['rank']) {
// $url_doit = '&doit=please';
$admin = 1;
//warning('In administrator modus');
foreach (array_keys($config) as $key)
if (isset ($_REQUEST[$key]))
$config[$key] = $_REQUEST[$key];
}
if (!$_REQUEST['method']) {
$_REQUEST['method'] = 'resultaten';
if (!$_REQUEST['presets_eko'])
$_REQUEST['presets_eko'] = 1;
}
$current_year = date('Y', time());
// only admin may see all results
if(!$admin) $sql_where['published'] = ' published = 1';
if($sql_where) $sql_where_str = " WHERE ".join(' AND ', $sql_where);
//create array with all the years that may been seen in results
$sql = "SELECT DISTINCT jaar FROM $table $sql_where_str ORDER BY 'jaar' ASC";
$results = mySQLQuery($sql);
while ($result = mysql_fetch_array($results))
$years[$result['jaar']] = $result['jaar'];
// if (!$admin && (array_key_exists($current_year, $years)))
// unset ($years[$current_year]);
$_REQUEST['year'] = $year = $template['year'] = in_array($_REQUEST['year'], $years) ? $_REQUEST['year'] : max($years);
foreach($years as $cur_year)
$extraProduct[$cur_year] = 'fairtrade';
if ($admin && trim($_REQUEST['full_text'])) {
$terms = explode(" ", $_REQUEST['full_text']);
foreach (array_values($terms) as $term) {
$term = trim($term);
if ($term && (strlen($term) > 2)) {
$sql_where[] = "full_text LIKE '%".mysql_real_escape_string($term)."%'";
$full_text_new[] = $term;
}
}
}
if ($full_text_new) {
$_REQUEST['full_text'] = join(' ', $full_text_new);
$template['full_text_filter'] = ', gefilterd op "'.$_REQUEST['full_text'].'"';
$_REQUEST['group'] = 'none';
$group = 0;
} else
$group = 1;
//determine corret grouping to display result by
$groups = Array ('supermarktketen_naam' => "supermarktketen", 'supermarkt_plaats' => "plaats", 'supermarkt_regio' => "gemeente", 'supermarkt_provincie' => "provincie", 'none' => "Nederland");
//$groups = Array ('supermarktketen_naam' => "supermarktketen", 'supermarkt_plaats' => "plaats", 'supermarkt_regio' => "gemeente", 'supermarkt_provincie' => "provincie", 'none' => "Nederland", "supermarkt_postcode, supermarkt_huisnr" => "filiaal");
$groups_plural = Array ('supermarktketen_naam' => "supermarktketens", 'supermarkt_plaats' => "plaatsen", 'supermarkt_regio' => "gemeenten", 'supermarkt_provincie' => "provincies", 'none' => "Nederland", 'voornaam, tussenvg, naam' => "tellers", "supermarktketen_naam, supermarkt_plaats, supermarkt_straat" => "alle filialen");
//geen verantwoorde koffie
unset($extraProduct['2004'], $extraProduct['2005']);
if ($admin) {
$groups['voornaam, tussenvg, naam'] = 'teller';
$groups['supermarktketen_naam, supermarkt_plaats, supermarkt_straat'] = "filiaal";
// $groups['supermarktketen_naam, supermarkt_plaats, supermarkt_straat'] = 'filiaal';
// if(!$_REQUEST['opt_archive']) {
// $extraProduct['2005'] = 'Verantwoorde koffie';
// $extraProduct['2004'] = 'Verantwoorde koffie';
// }
$unfiltered = Array ();
$unfiltered['0'] = "Gefiltered";
$unfiltered['1'] = "Ongefiltered";
if (!array_key_exists($_REQUEST['unfiltered'], $unfiltered))
$_REQUEST['unfiltered'] = "0";
} else
unset ($_REQUEST['unfiltered'], $_REQUEST['opt_archive']);
$url_preset = $_SERVER['SCRIPT_URL']."?method=resultaten$url_doit";
//define and set presets
$presets_eko = Array ();
$presets_eko[++ $i] = 'Top 10 filialen';
$presets_eko[++ $i] = 'Top 10 supermarktketens';
$presets_eko[++ $i] = 'Meerjarentrend supermarktketens';
$presets_eko[++ $i] = 'Top 10 provincies';
$presets_eko[++ $i] = 'Top 3 gemeenten';
switch ($_REQUEST['presets_eko']) {
case 1 :
$_REQUEST['group'] = 'none';
$_REQUEST['limit'] = 10;
break;
case 2 :
$_REQUEST['group'] = 'supermarktketen_naam';
$_REQUEST['limit'] = 10;
break;
case 3 :
$_REQUEST['group'] = 'supermarktketen_naam';
$_REQUEST['limit'] = 10;
$_REQUEST['opt_lgraphG'] = 1;
break;
case 4 :
$_REQUEST['group'] = 'supermarkt_provincie';
$_REQUEST['limit'] = 10;
break;
case 5 :
$_REQUEST['group'] = 'supermarkt_regio';
$_REQUEST['limit'] = 3;
break;
}
$template['presets'] .= selectionList('Overzichten EKO', $presets_eko, 'presets_eko', $url_preset, 1, 1, 0);
if ($extraProduct[$year]) {
unset ($i);
$presets_ep = Array ();
$presets_ep[++ $i] = 'Top 10 filialen';
$presets_ep[++ $i] = 'Top 10 supermarktketens';
$presets_ep[++ $i] = 'Meerjarentrend supermarktketens';
$presets_ep[++ $i] = 'Top 10 provincies';
$presets_ep[++ $i] = 'Top 3 gemeenten';
switch ($_REQUEST['presets_ep']) {
case 1 :
$_REQUEST['group'] = 'none';
$_REQUEST['order'] = 'extra_product';
$_REQUEST['limit'] = 10;
break;
case 2 :
$_REQUEST['group'] = 'supermarktketen_naam';
$_REQUEST['order'] = 'extra_product';
$_REQUEST['limit'] = 10;
break;
case 3 :
$_REQUEST['group'] = 'supermarktketen_naam';
$_REQUEST['order'] = 'extra_product';
$_REQUEST['limit'] = 10;
$_REQUEST['opt_lgraphG'] = 1;
break;
case 4 :
$_REQUEST['group'] = 'supermarkt_provincie';
$_REQUEST['order'] = 'extra_product';
$_REQUEST['limit'] = 10;
break;
case 5 :
$_REQUEST['group'] = 'supermarkt_regio';
$_REQUEST['order'] = 'extra_product';
$_REQUEST['limit'] = 3;
break;
}
$template['presets'] .= selectionList('Overzichten '.$extraProduct[$year], $presets_ep, 'presets_ep', $url_preset, 1, 1, 0);
}
//$_REQUEST['group'] = array_key_exists($_REQUEST['group'], $groups) ? $_REQUEST['group'] : 'plaats';
if ($_REQUEST['group'] && array_key_exists($_REQUEST['group'], $groups)) {
if ($_REQUEST['group'] != 'none')
$sql_group = $_REQUEST['group'];
} else {
switch ($_REQUEST['method']) {
case overview :
$_REQUEST['limit'] = 'all';
$_REQUEST['group'] = 'supermarkt_plaats';
$sql_group = $_REQUEST['group'];
break;
case resultaten :
default :
$_REQUEST['group'] = 'none';
break;
}
}
// group is set correctly now
switch ($_REQUEST['group']) {
case supermarkt_provincie:
case supermarkt_regio:
$group_prefix = $groups[$_REQUEST['group']]." ";
break;
}
$limits = Array ("3" => "Top 3", "10" => "Top 10", "all" => "Alle");
$_REQUEST['limit'] = $limit = array_key_exists($_REQUEST['limit'], $limits) ? $_REQUEST['limit'] : 10;
if ($limit != 'all')
$sql_limit = " LIMIT $limit";
$template['limit'] = $limits[$_REQUEST['limit']];
$orders['eko'] = "EKO";
if ($extraProduct[$year])
$orders['extra_product'] = $extraProduct[$year];
if (!array_key_exists($_REQUEST['order'], $orders))
$_REQUEST['order'] = "eko";
$sql_order = $_REQUEST['order'];
$template['order'] = $orders[$_REQUEST['order']];
//EKO-producten and fairtrade producten
$template['dash'] = ($_REQUEST['order'] == 'extra_product') ? ' ' : '-';
$products['both'] = 'EKO en fairtrade';
$products['one'] = $product_name[$sql_order];
if (!array_key_exists($_REQUEST['products'], $products))
$_REQUEST['products'] = 'one';
//set graph types
$graph_imgs = Array ("graphG", "lgraphG", "graphT", "lgraphT");
// set default graphs for different groups
//$graph_defs = Array ('supermarktketen_naam' => "graphG", 'supermarkt_plaats' => "graphT", 'supermarkt_regio' => "graphT", 'supermarkt_provincie' => "graphG", 'none' => "graphT");
// Grafiek: Top x group_plural
if ($admin)
$graphG_defs = $lgraphG_defs = $graphT_defs = $lgraphT_defs = $stats_defs = Array ('supermarktketen_naam' => 1, 'supermarkt_plaats' => 1, 'supermarkt_provincie' => 1, 'supermarkt_regio' => 1, 'none' => 1);
else {
$graphG_defs = Array ('supermarktketen_naam' => 1);
// Grafiek: Meerjarentrend group_plural
$lgraphG_defs = Array ('supermarktketen_naam' => 1);
//if ($_REQUEST['order'] == 'extra_product')
// unset ($lgraphG_defs['supermarktketen_naam']);
// Grafiek: Top x filialen Nederland
$graphT_defs = Array ('supermarkt_plaats' => 1, 'supermarkt_regio' => 1, 'none' => 1);
if ($_REQUEST['limit'] == '3')
unset ($graphT_defs['supermarkt_regio']);
// Grafiek: Meerjarentrend Nederland
$lgraphT_defs = Array ('supermarktketen_naam' => 1, 'supermarkt_plaats' => 1, 'supermarkt_provincie' => 1, 'supermarkt_regio' => 1, 'none' => 1);
if ($_REQUEST['limit'] == 'all')
unset ($graphT_disp['none']);
$stats_defs = Array ('supermarktketen_naam' => 1, 'supermarkt_provincie' => 1, 'supermarkt_regio' => 1);
// if ($_REQUEST['order'] == 'extra_product')
// unset ($stats_defs);
}
// default display the folowing graphs
$graphG_disp = Array ('supermarktketen_naam' => 1);
$graphT_disp = Array ('supermarkt_plaats' => 1, 'none' => 1);
//$graphT_disp = Array ('supermarkt_plaats' => 1, 'none' => 1);
//temp
//$lgraphG_disp = Array ('supermarktketen_naam' => 1);
//$stats_disp = Array ('supermarktketen_naam' => 1);
//end temp
if ($_REQUEST['opt_lgraphG']) {
$lgraphG_disp[$_REQUEST['group']] = 1;
unset ($graphG_disp, $graphT_disp);
}
// create url's for specific options
#$url_edit = "http://www.milieudefensie.nl/phpmyadmin/tbl_change.php?lang=en-iso-8859-1&server=1&db=phorms&table=archive_ekotellingen&pos=0&session_max_rows=30&disp_direction=horizontal&repeat_cells=100&dontlimitchars=0&primary_key=+%60id%60+%3D+";
$url_edit = "../../database/?action=record&table=ekotellingen&method=edit&id=";
$url_base = 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'].'?opt_select=1&';
foreach (array_keys($_REQUEST) as $key) {
if (!$_REQUEST[$key])
continue;
switch ($key) {
case updateMunicipality :
case opt_confirm :
case graph :
case graphG :
case graphT :
case lgraph :
case lgraphT :
case print_grp :
case index_ft :
case reset_db :
case opt_lgraphG :
case opt_select:
case presets_eko :
case presets_ep :
case submit :
break;
default :
$url_base_keys[] = $key.'='.$_REQUEST[$key];
}
}
if ($url_base_keys)
$url_base .= join('&', $url_base_keys);
$url_keys = Array ('order', 'year', 'group', 'limit', 'graph_img', 'full_text', 'unfiltered', 'method', 'products');
foreach (array_values($url_keys) as $value)
${ "url_".$value } = preg_replace('(&'.$value.'=[^&]*)', '', $url_base);
//$template['full_text'] = '';
if ($admin && !$_REQUEST['print_grp']) {
//report('Archiveer gegevens');
//report('Update gemeente\'s');
//report('Indexeer database');
// report('Reset database');
//report('Exporteer database');
if ($_REQUEST['updateMunicipality']) {
updateMunicipality();
template();
}
elseif ($_REQUEST['index_ft']) indexFullText();
elseif ($_REQUEST['reset_db']) require_once "$include_path/reset_db.inc";
elseif ($_REQUEST['export_db']) {
require_once "$include_path/exportCSV.inc";
$sql = "SELECT * FROM $table";
exportCSV(mySQLQuery($sql), $table);
}
elseif ($_REQUEST['phpinfo']) {
phpinfo();
die;
}
if ($_REQUEST['opt_save']) {
$filename = "$include_path/config_keys.inc";
if (!$handle = fopen($filename, 'w'))
report("Fout: kan bestand ($filename) niet openen", PROCESSING);
else {
fwrite($handle, "");
fclose($handle);
}
}
if ($_REQUEST['group'] == 'supermarktketen_naam') {
$template['config'] .= '| Grafieken en tabel supermarktketens |
| Fractie van keten | >= |
| Getelde filialen | >= |
| Filialen per keten | >= |
| Opslaan | |
';
}
// overview();
// template();
}
//rene
//$_REQUEST['order'] = 'extra_product';
//rene end
switch ($_REQUEST['method']) {
case help :
$template_file = "zoektips";
case resultaten :
// check what to do. NB: After a graph has been drawn the script will exit
if ($sql_group) {
if ($_REQUEST['graphG'])
graphG($_REQUEST['group'], $sql_group, $sql_order, $sql_limit, $sql_where);
elseif ($_REQUEST['graph']) graph(ucfirst($group_prefix).$_REQUEST['graph'], $_REQUEST['graph'], $sql_group, $sql_order, $sql_limit, $sql_where);
elseif ($_REQUEST['lgraph']) lineGraph($group_prefix.$_REQUEST['lgraph'], $_REQUEST['lgraph'], $sql_group, $sql_limit, $sql_where, 0);
elseif ($_REQUEST['lgraphG']) lineGraphG($_REQUEST['group'], $sql_group, $sql_order, $sql_limit);
}
if ($_REQUEST['graphT'])
graph('Nederland', 'Nederland', '', $sql_order, $sql_limit, $sql_where);
elseif ($_REQUEST['lgraphT']) lineGraph('Nederland', 'Nederland', $sql_group, $sql_limit, $sql_where, 1);
if ($_REQUEST['print_grp']) {
$_REQUEST['print'] = 1;
$sql_where[] = "CONCAT_WS(' ', $sql_group)='".mysql_real_escape_string($_REQUEST['print_grp'])."'";
overview($sql_group, 0, 0, $group, $extraProduct[$year], 1, $graphG_defs[$_REQUEST['group']], 0, 1, $lgraphG_defs[$_REQUEST['group']], $lgraphT_defs[$_REQUEST['group']], $graphT_defs[$_REQUEST['group']], 1, 1, 0, 1, 0, 1, $_REQUEST['opt_select'], $admin, 1);
if(!$template_file) $template_file = 'resultaat';
} else {
overview($sql_group, 0, $stats_defs[$_REQUEST['group']], $group, $extraProduct[$year], 1, $graphG_defs[$_REQUEST['group']], 1, 1, $lgraphG_defs[$_REQUEST['group']], $lgraphT_defs[$_REQUEST['group']], $graphT_defs[$_REQUEST['group']], 1, 1, 1, 0, 1, 1, $_REQUEST['opt_select'], $admin, 1);
if(!$template_file) $template_file = "resultaten";
}
break;
case phorm:
$key = $_REQUEST['phorm'];
switch ($key) {
case supermarkt_provincie:
$sql = "SELECT DISTINCT $key FROM $table ORDER BY $key ASC";
$results = mySQLQuery($sql);
$html = '";
break;
case supermarktketen_naam:
$year = 2007;
$sql = "SELECT DISTINCT supermarktketen FROM archive_ekotellingen_filialen WHERE `$year`>=5 ORDER BY supermarktketen ASC";
$results = mySQLQuery($sql);
$html = '";
break;
case supermarkt_postcode:
$sql = "SELECT * FROM $table WHERE $key LIKE '".mysql_escape_string(trim($_REQUEST[$key]))."%' ORDER BY $key ASC LIMIT 1";
$results = mySQLQuery($sql);
$result = mysql_fetch_array($results);
$fields = Array('supermarkt_straat', 'supermarkt_huisnr', 'supermarkt_toevoeg', 'supermarkt_plaats', 'supermarkt_provincie', 'supermarktketen_naam');
$html = '';
break;
case supermarkt_postcode_q:
$sql = "SELECT DISTINCT supermarkt_postcode FROM $table WHERE supermarkt_postcode LIKE '".mysql_escape_string(trim($_REQUEST['q']))."%' ORDER BY supermarkt_postcode ASC LIMIT 10";
$results = mySQLQuery($sql);
while($result = mysql_fetch_array($results))
$html .= $result['supermarkt_postcode']."\n";
break;
}
print $html;
die;
break;
case overview :
// $sql_where['published'] = ' published = 0';
unset($sql_where['published']);
default :
$year = $template['year'] = $current_year;
$sql_group = 'supermarkt_plaats';
$sql_order = 'supermarktketen_naam';
overview($sql_group, 1);
$template_file = "overzicht";
break;
}
if ($template['config']) {
$template['tpl_config'] = divHTML('config', 'Configuratie-opties', 'Klik voor configuratie-opties', '', 1, 1, 'ico_form.gif', "Dubbelklik om de configuratie-opties te verbergen");
}
$eTime = explode(' ', microtime());
$time = (($eTime[1] - $sTime[1]) + ($eTime[0] - $sTime[0]));
if ($admin)
$template['tpl_report'] = "Execution time: $time seconds
" . $template['tpl_report'];
template($template_file);
?>