<?
/**
 * search_detail.php 検索結果の詳細を取得するための画面
 */

require_once("./lib/configs.php");
require_once("./lib/common.php");

$db = connectDB();

// 不正アクセスは省く
if (!$_GET["id"] || !is_numeric($_GET["id"])) {
	Location("./search.php");
	exit;
}

// 業者IDの取得
$gyousha_kyoka_bangou = $_GET["id"];

// 業者データの取得
$q_gyousha_kyoka_bangou = mes($gyousha_kyoka_bangou);
$sql = "
	SELECT *
	FROM gyousha_t
	WHERE gyousha_kyoka_bangou = '$q_gyousha_kyoka_bangou'
";
$data = getRow($sql);
//print_r($data);
$ch = array("name" => "あいう","name2" => "えお");
// 現在のページを持ち回すための処理
$page = (int)$_GET["p"];

if (isset($_POST["csv"])) {
	$filename = "csv_".date('YmdHis').".csv";

	header('Content-Type: text/csv' );
	header('Content-Disposition: attachment;filename='.$filename);
	header('Content-Transfer-Encoding: euc-jp');

	// 出力したキャッシュをクリアする
	ob_clean();

    $fp = fopen('php://output', 'w');
    fputcsv($fp, array("業者名", "所在地", "固有番号", "許可番号", "許可主体", "業の区分", "許可年月日"));
    $ary = array(
        $data["gyousha_name"],
        $data["gyousha_address"],
        $data["gyousha_koyuu_bangou"],
        $data["gyousha_kyoka_bangou"],
        $data["gyousha_kyoka_shutai"],
        $gyou_kbn_list[$data["gyousha_gyou_kbn"]],
        heisei_date_format($data["gyousha_kyoka_date"])
        //$value["gyousha_kyoka_date"]
    );
    fputcsv($fp, $ary);

    fclose($fp);

    exit;
}

/**
 * スマーティで描画
 */
//$smarty = new mySmarty();
$tmpl = new MyTemplate();

// アサイン情報

//$assign_list = compact(array("page", "gyou_kbn_list", "gyou_kyoka_list", "data"));
//$smarty->assign($assign_list);
$tmpl->page = $page;
$tmpl->gyou_kbn_list = $gyou_kbn_list;
$tmpl->gyou_kyoka_list = $gyou_kyoka_list;
$tmpl->data = $data;

//$smarty->display("search_detail.html");
$tmpl->show("search_detail.html");
?>