/****************************************************** ' System :Eco-footprint 会員ページ ' Content:我が家のEcoFootPrint '******************************************************/ $top = '.'; $inc = "$top/../inc"; include("$inc/common.php"); include("$inc/database.php"); $inc = "$top/inc"; include("$inc/mypage.php"); include("$inc/foot_print.php"); // 会員番号取得 $seq_no = $_SESSION['ss_seq_no']; // 年月の指定がない場合は最新のデータ if (!$ym) { $sql = "SELECT to_char(max(cr_ym), 'YYYYMM') FROM t_co2_rank WHERE cr_seq_no=$seq_no"; $ym = db_fetch1($sql); if (!$ym) { $sql = "SELECT to_char(max(bd_month), 'YYYYMM') FROM t_base_data WHERE bd_mb_seq_no=$seq_no AND bd_commit_flag=1"; $ym = db_fetch1($sql); } } // 年月に分解 $year = substr($ym, 0, 4); $month = substr($ym, -2); // 日付形式 $date = "$year-$month-01"; // 前月取得 $sql = "SELECT to_char(max(cr_ym), 'YYYYMM') FROM t_co2_rank WHERE cr_seq_no=$seq_no AND cr_ym<'$date'"; $ym_back = db_fetch1($sql); // 次月取得 $sql = "SELECT to_char(min(cr_ym), 'YYYYMM') FROM t_co2_rank WHERE cr_seq_no=$seq_no AND cr_ym>'$date'"; $ym_next = db_fetch1($sql); // 消費量とランクを取得 get_foot_print($seq_no, $date, $use, $rank); // Flashパラメータ編集 /* 1〜7段階ランク */ $fv[] = "elc_spendRank={$rank['ele']}"; $fv[] = "gas_spendRank={$rank['gas']}"; $fv[] = "wtr_spendRank={$rank['wtr']}"; $fv[] = "oil_spendRank={$rank['oil_gso']}"; $fv[] = "dst_spendRank={$rank['dst']}"; $fv[] = "co2_spendRank={$rank['co2']}"; /* 消費量総数 */ $fv[] = "elc_spendValue={$use['ele']}"; $fv[] = "gas_spendValue={$use['gas']}"; $fv[] = "wtr_spendValue={$use['wtr']}"; $fv[] = "oil_spendValue={$use['oil_gso']}"; $fv[] = "dst_spendValue={$use['dst']}"; $fv[] = "co2_spendValue={$use['co2']}"; $fv = join('&', $fv); ?>