define('IGNORED', 4); // 無視 define('HIGH_PRIOR', 1); // 重要度(高い) define('NORMAL_PRIOR', 3); // 重要度(通常) define('LOW_PRIOR', 5); // 重要度(低い) define('NOT_DEFINED', 0); // 未設定 /********************************************************************** * メッセージルール作成 **********************************************************************/ //現在のメッセージルールを抽出 $sql = "SELECT rule_id," . " priority_id," . " search_type," . " keyword," . " dir_id" . " FROM info_message_rule WHERE disable = 0" . " ORDER BY priority_id,rule_id ASC"; $rs = $db->executeSql($sql, array()); while ($row = $rs->fetchRow(DB_FETCHMODE_ASSOC)) { //search_typeごとのメッセージルールの配列をつくる switch ($row["search_type"]) { case 1: $msg_rule_from_name_tbl[] = array('id' => $row["rule_id"], 'priority_id' => $row["priority_id"], 'column' => $row["search_type"], 'str' => $row["keyword"], 'dir_id' => $row["dir_id"]); break; case 2: $msg_rule_to_address_tbl[] = array('id' => $row["rule_id"], 'priority_id' => $row["priority_id"], 'column' => $row["search_type"], 'str' => $row["keyword"], 'dir_id' => $row["dir_id"]); break; case 3: $msg_rule_subject_tbl[] = array('id' => $row["rule_id"], 'priority_id' => $row["priority_id"], 'column' => $row["search_type"], 'str' => $row["keyword"], 'dir_id' => $row["dir_id"]); break; case 4: $msg_rule_body_tbl[] = array('id' => $row["rule_id"], 'priority_id' => $row["priority_id"], 'column' => $row["search_type"], 'str' => $row["keyword"], 'dir_id' => $row["dir_id"]); break;
<?php // 問い合わせ対応ユーザーデータを取得する(管理画面ログインユーザーを参照) if (!$db) { $base = dirname(dirname(dirname(dirname(__FILE__)))); require_once $base . "/etc/config-ini.php"; require_once $base . "/admin/Information/lib/InformationDB.php"; $config["dsn"] = "mysqli://" . $define["define"]["DATABASE"]["params"]["username"] . ":" . $define["define"]["DATABASE"]["params"]["password"] . "@" . $define["define"]["DATABASE"]["params"]["host"] . ":3306" . "/" . $define["define"]["DATABASE"]["params"]["dbname"]; // MySQLへ接続 $db = new InformationDB($config["dsn"]); $whereString = array(); $whereString[] = "is_display = 1"; $whereString[] = "disable = 0"; $whereString = implode(" AND ", $whereString); $sql = " SELECT *" . " FROM information_operator_list" . " WHERE " . $whereString . " ORDER BY id ASC"; $rs = $db->executeSql($sql); $operatorList = ""; if ($rs->numRows() > 0) { while ($row = $rs->fetchRow(DB_FETCHMODE_ASSOC)) { $operator_tbl[] = $row; } } /*else { // デフォルトの担当者テーブル(DB保持前) // is_display = 0[非表示]、1[表示] $operator_tbl = array( array('id' => 3, 'name' => '清水', 'sakura' => '3', 'is_display' => 1), array('id' => 4, 'name' => '井坂', 'sakura' => '4', 'is_display' => 1), array('id' => 6, 'name' => '鈴木', 'sakura' => '6', 'is_display' => 1), array('id' => 7, 'name' => '坂入', 'sakura' => '7', 'is_display' => 1), array('id' => 9, 'name' => '酒井', 'sakura' => '9', 'is_display' => 1),