/****************************************************** ' System :Eco-footprint 管理ページ ' Content:会員データ入力状況一覧 '******************************************************/ $top = '../..'; $inc = "$top/inc"; include("$inc/login_check.php"); include("$inc/header.php"); $inc = "$top/../inc"; include("$inc/common.php"); include("$inc/define.php"); include("$inc/database.php"); include("$inc/list.php"); include("$inc/decode.php"); include("$inc/format.php"); // エネルギーdecode function decode_eng($code) { if ($code == 'el') echo '電気'; if ($code == 'gs') echo 'ガス'; if ($code == 'wt') echo '水道'; if ($code == 'gm') echo 'ゴミ'; if ($code == 'gl') echo 'ガソリン'; if ($code == 'ol') echo '灯油'; } // エネルギー種別decode function decode_kind($code) { if ($code == 0) echo '両方'; if ($code == 1) echo '使用料'; if ($code == 2) echo '請求金額'; } //メイン処理 set_global('member', '会員情報管理', '会員データ入力状況', ''); $sql = "select mb_name1,mb_name2,ed_mb_seq_no,ed_month,ed_eng_cd,ed_use_sum,ed_old_volume,ed_new_volume,ed_reason,ed_regist_date,ed_old_sum,ed_new_sum from t_member left join t_edit_data on mb_seq_no=ed_mb_seq_no where mb_seq_no=$seq_no order by ed_regist_date desc"; $result = db_exec($sql); $nrow = pg_numrows($result); if ($nrow) { $fetch = pg_fetch_object($result, 0); } ?>