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),
