/****************************************************** ' System :「きゃららFactory」管理者用ページル ' 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/format.php"); include("$inc/select.php"); // 週選択 function select_week_no($default, $selected) { if ($default) echo "\n"; for ($i = 1; $i <= 9; $i++) echo '\n"; } // 状態 function decode_df_status($code) { switch($code) { case 0: return '受付済'; break; case 1: return '当選'; break; case 2: return '当選'; break; case 3: return '通知済'; break; default: return '−'; } } // キャンペーンコード $campaign_cd = $cp_cd; // データテーブル $table = "d_".$cp_cd; // セッション登録 get_session_vars($pset, 'creo_list', 'df_week_no', 'displine', 'sort_col', 'sort_dir', 'page'); // where条件 if ($week_no != '') and_join($where, "df_week_no=" . $week_no); if ($where != '') { $where = "($where)"; $where = "WHERE $where"; } else $where = ''; // 総件数 $sql = "SELECT count(*) AS count FROM $table $where"; $count = db_fetch1($sql); //メイン処理 $limit = disp_limit(); set_global('etc', 'その他管理|サーバ別応募状況', 'クレオ', BACK_TOP); $order_by = order_by(5, 1, 'df_week_no', 'df_creo_id', 'df_name1||df_name2', 'df_mail_addr', 'df_regist_date', 'df_status'); $sql = "SELECT * FROM $table $where $order_by $limit"; $result = db_exec($sql); $nrow = pg_numrows($result); ?>
第=$fetch->df_week_no?>週 | =$fetch->df_creo_id?> | ="$fetch->df_name1 $fetch->df_name2"?> | =$fetch->df_mail_addr?> | =format_datetime($fetch->df_regist_date)?> | =decode_df_status($fetch->df_status)?> |