";
if($db_host && $db_user){
mysql_connect("$db_host","$db_user","$db_password") or die("Error: No BD Connection");
$rs = mysql_query("show databases");
$db_names=array();
while($arr=mysql_fetch_array($rs)){
if ($arr[0]=='information_schema' || $arr[0]=='mysql') continue;
$db_names[]=$arr[0];
}
$post_name = isset($_POST['db_name']) ? $_POST['db_name'] : "";
foreach($db_names as $db_name) {
$selected="";
if ($db_name == $post_name) $selected=' selected ';
$db_select .="";
}
}
$db_select .= "";
?>
array( 'table_name' => 'contacts', 'where' => " WHERE smsgroup='student' AND deleted=0 ",
'fields' => array(
'性別' => 'gender',
'一括メール受取拒否' => 'email_opt_out',
'一括メール送信不可' => 'invalid_email',
'対応拒否' => 'taiokyohi',
'校舎' => 'school_id',
'ステイタス' => 'contact_status',
'司法試験：ランク' => 'rank_shihoushiken',
'公務員：ランク' => 'rank_koumuin',
'司法書士：ランク' => 'rank_shihoushoshi',
'行政書士：ランク' => 'rank_gyouseishoshi',
'学年' => 'grade_entered',
'既修、未修' => 'kishu_mishu',
'サークル内役職名' => 'circle_title',
'職業' => 'work_school',
'OBOG会会員' => 'obog_members',
'発送物の時間指定' => 'jikanshitei',
'郵便局留め（有無）' => 'kyokudome',
),
),
'スタッフ' => array(
'table_name' => 'contacts',
'where' => " WHERE smsgroup='staff' AND deleted=0 ",
'fields' => array(
'性別' => 'gender',
'一括メール受取拒否' => 'email_opt_out',
'一括メール送信不可' => 'invalid_email',
'校舎' => 'school_id',
'ステイタス' => 'contact_status',
'DM用ラベル印刷' => 'send_document_home',
),
),
'クラスと受講生の関連' => array( 'table_name' => 'event_contacts', 'where' => " WHERE deleted=0 ",
'fields' => array(
'受講状況' => 'event_contact_status',
),
),
'クラス' => array( 'table_name' => 'smsevent', 'where' => "",
'fields' => array(
'校舎' => 'school_id',
'ネット配信有無' => 'net_haishin_umu',
// 'Web de ドリル配信' => 'web_de_doriru_haishin',
'Web de ドリル対象' => 'web_de_doriru_taisho',
'試験種' => 'shikenshu',
),
),
'スケジュール情報（詳細）' => array( 'table_name' => 'smsevent_instances', 'where' => " WHERE event_type='course' ",
'fields' => array(
'出席状況' => 'attendance_status',
),
),
'料金' => array( 'table_name' => 'sms_fee', 'where' => " WHERE deleted=0 ",
'fields' => array(
'区分' => 'type_id',
'支払方法' => 'unit_type',
'締切日設定方法' => 'period_no',
'売上区分' => 'uriagekubun',
'倉庫発送' => 'hasso_from_soko',
'売上形態' => 'uriage_keitai',
),
),
'入出金' => array( 'table_name' => 'sms_transaction', 'where' => " WHERE deleted=0 ",
'fields' => array(
'支払方法' => 'payment_type',
'入金先口座' => 'nyuukinsaki_kouza',
'カード／信販会社名' => 'nyuukinsaki_card_credit',
'販売経路' => 'hanbaikeiro',
),
),
'物品' => array( 'table_name' => 'buppin', 'where' => " WHERE deleted=0 ",
'fields' => array(
'試験種' => 'shikenshu',
'廃棄有無' => 'haiki_umu',
),
),
'発送情報と受講生の関連' => array( 'table_name' => 'hasso_contacts', 'where' => " WHERE deleted=0 ",
'fields' => array(
'発送状況' => 'hasso_status',
// '抽出状況' => 'chushutsu_status',
),
),
'発送コード' => array( 'table_name' => 'hassocode', 'where' => " WHERE deleted=0 ",
'fields' => array(
'アラートフラグ' => 'alerts_flg',
),
),
'発送コードと受講生の関連' => array( 'table_name' => 'hassocode_contacts', 'where' => " WHERE deleted=0 ",
'fields' => array(
'発送状況' => 'hasso_status',
'種別' => 'hasso_type',
'定期／日次' => 'teiki_nichiji',
'抽出状況' => 'chushutsu_status',
),
),
'発送日' => array( 'table_name' => 'hassobi', 'where' => " WHERE deleted=0 ",
'fields' => array(
'抽出フラグ' => 'extract_flg',
),
),
'出荷（個別）' => array( 'table_name' => 'shukka_kobetsu', 'where' => " WHERE deleted=0 ",
'fields' => array(
'出荷種別' => 'shukka_shubetsu',
),
),
'カリキュラム' => array( 'table_name' => 'curriculum', 'where' => " WHERE deleted=0 ",
'fields' => array(
'試験種' => 'shikenshu',
'Web de ドリル配信フラグ' => 'web_de_doriru_haishin',
),
),
'講座' => array( 'table_name' => 'koza', 'where' => " WHERE deleted=0 ",
'fields' => array(
'校舎ID' => 'school_id',
'試験種' => 'shikenshu',
'対象ステイタス' => 'taishou_status',
'販売可否' => 'hanbaikahi',
),
),
'講座と受講生の関連' => array( 'table_name' => 'koza_contacts', 'where' => " WHERE deleted=0 ",
'fields' => array(
'解約' => 'kaiyaku',
'申込時学年' => 'moushikomijigakunen',
),
),
'教育訓練給付金講座' => array( 'table_name' => 'kyoikukunren', 'where' => " WHERE deleted=0 ",
'fields' => array(
'受講形態' => 'jukoukeitai',
),
),
'教育訓練給付金講座と受講生の関連' => array( 'table_name' => 'kyoikukunren_contacs', 'where' => " WHERE deleted=0 ",
'fields' => array(
'修了認定' => 'shuuryounintei',
'訓練期間' => 'kunrenkikan',
'校舎' => 'school_id',
'割引き・増（選択）' => 'warimashi_sentaku',
'通常' => 'tuujou',
'生協/書店' => 'seikyo_shoten',
'カード/信販会社名' => 'nyuukinsaki_card_credit',
),
),
'資料' => array( 'table_name' => 'shiryo_fb_event', 'where' => " WHERE deleted=0 ",
'fields' => array(
'試験種' => 'shikenshu',
),
),
'資料と受講生の関連' => array( 'table_name' => 'shiryo_fb_event_contacts', 'where' => " WHERE deleted=0 ",
'fields' => array(
'購買見込' => 'kobaimikomi',
'請求区分' => 'seikyu_kubun',
'資料送付状況' => 'shiryo_sofu_status',
),
),
'講座コードAB' => array( 'table_name' => 'koza_code_master', 'where' => " WHERE deleted=0 ",
'fields' => array(
'試験種' => 'shikenshu',
),
),
'物品カテゴリー' => array( 'table_name' => 'master_kanri', 'where' => " WHERE deleted=0 AND master_group='teacher' ",
'fields' => array(
'属性' => 'field2',
),
),
'生協・代理店' => array( 'table_name' => 'master_kanri', 'where' => " WHERE deleted=0 AND master_group='seikyou_dairiten' ",
'fields' => array(
'生協／書店' => 'field3',
),
),
);
//$pulldown_list1 = array(
// 'クラス' => array( 'table_name' => 'smsevent', 'where' => "",
// 'fields' => array(
// '校舎' => 'school_id',
// '試験種' => 'shikenshu',
// ),
// ),
//);
$field_list = array();
$db_schema = @mysql_select_db ( 'information_schema' );
$selected_db = isset($_POST['db_name']) ? $_POST['db_name'] : "";
if ($execute_queries && $process_type=='execute') {
$db_schema = @mysql_select_db ( $selected_db );
mysql_query("SET NAMES utf8");
}
if (!empty($selected_db)) {
foreach($pulldown_list as $table_name=>$table_data) {
$font_color = "black";
echo "
-- Data name: {$table_name} ";
foreach($table_data['fields'] as $field_jp=>$field_name) {
$query = "SELECT DISTINCT {$field_name} FROM {$table_data['table_name']} ";
$query .= $table_data['where'];
echo "
-- Field name: {$field_jp} ";
if ($execute_queries && $process_type=='execute') {
$query_result = mysql_query($query);
while($row = mysql_fetch_row($query_result)){
echo "
{$row[0]} ";
}
}
else {
echo "
-- Query: {$query} ";
}
}
}
}
?>