<?
/**
 * statistics.php 統計画面
 */

require_once("./lib/configs.php");
require_once("./lib/common.php");

$db = connectDB();

// 産業廃棄物処理業者数
$sql = "
	SELECT gyousha_gyou_kbn, count(distinct(gyousha_koyuu_bangou)) as count
	FROM gyousha_t
	GROUP BY gyousha_gyou_kbn
";
$tmp_data = getAll($sql);
foreach ($tmp_data as $data) {
	$gyousha_data[$data["gyousha_gyou_kbn"]] = $data["count"];
	$gyousha_data[10] += $data["gyousha_gyou_kbn"] > 4 ? 0 : $data["count"];
	$gyousha_data[20] += $data["gyousha_gyou_kbn"] > 4 ? $data["count"] : 0;
}
$gyousha_data[30] = $gyousha_data[10] + $gyousha_data[20];

// 県、市別のデータと全許可件数を同時に取得
$sql = "
	SELECT pref_city_id, gyousha_gyou_kbn, count(*) as count
	FROM gyousha_t
	GROUP BY gyousha_gyou_kbn, pref_city_id
";
$tmp_data = getAll($sql);

// 県別にすべて分ける
foreach ($tmp_data as $data) {
	$kenbetu_data[$data["pref_city_id"]][$data["gyousha_gyou_kbn"]] = $data["count"];
	$kenbetu_data[$data["pref_city_id"]][10] += $data["gyousha_gyou_kbn"] > 4 ? 0 : $data["count"];
	$kenbetu_data[$data["pref_city_id"]][20] += $data["gyousha_gyou_kbn"] > 4 ? $data["count"] : 0;
	$kenbetu_data[$data["pref_city_id"]][30] += $data["count"];
	$all_data[$data["gyousha_gyou_kbn"]] += $data["count"];
	$all_data[10] += $data["gyousha_gyou_kbn"] > 4 ? 0 : $data["count"];
	$all_data[20] += $data["gyousha_gyou_kbn"] > 4 ? $data["count"] : 0;
}
$all_data[30] = $all_data[10] + $all_data[20];

// 都道府県IDが０のものがあるのでイレギュラー対応
unset($kenbetu_data[0]);

// 県と市のデータの取得
$pref_city_data = getPrefCityList();

/**
 * スマーティで描画
 */
//$smarty = new mySmarty();
$tmpl = new MyTemplate();

// アサインのリスト
//$assign_list = compact(array("gyousha_data", "kenbetu_data", "all_data", "pref_city_data"));
//$smarty->assign($assign_list);
$tmpl->gyousha_data = $gyousha_data;
$tmpl->kenbetu_data = $kenbetu_data;
$tmpl->all_data = $all_data;
$tmpl->pref_city_data = $pref_city_data;

//$smarty->display("statistics.html");
$tmpl->show("statistics.html");

?>