$err_msg = $msg_bg . "IDは" . $err_mes['login_id'] . $msg_ed;
}
// login_pass err
if ($err_mes['login_pass']) {
$passmsg = $msg_bg . "パスワードは" . $err_mes['login_pass'] . $msg_ed;
if ($err_msg) {
$err_msg = $err_msg . $passmsg;
} else {
$err_msg = $passmsg;
}
}
// login_id and login_pass ok
if ($oerr->clear) {
// get data by login_id and login_pwd
$db = new Class_DB();
$sql = sprintf("SELECT * FROM mp_account WHERE login_id = '%s' AND login_pwd = '%s' ", mysql_real_escape_string($id), mysql_real_escape_string(Class_PWD::do_encode($pass)));
$db->query($sql);
if ($db->num_rows()) {
$row = $db->fetch();
// ログイン不可
if ($row['login_flgs'] == '1') {
$err_msg = '<p class="caution">ログインできません。管理者にお問い合わせください。</p>';
$err = true;
$db->close();
// ログイン可
} else {
// set auth and session
session_name('PREGO_ADMIN');
//session_cache_limiter(private_no_expire);
session_start();
$auth = $row['sorts'];
public static function get_week_array($year, $please_select = NULL, $date_flg = FALSE, $cell = FALSE)
{
$db = new Class_DB();
$sql = " select a.week_cd,a.matrix_cd,a.week_seq,a.flier_date from M_MATRIX_TERM a ";
if ($cell) {
$sql = $sql . " INNER JOIN T_MON_CELL_WEEK b on a.matrix_cd = b.matrix_cd ";
}
$sql = $sql . " where a.year4 = '{$year}' ";
$sql = $sql . " order by a.week_cd";
$db->query($sql);
if ($please_select) {
$data[""] = $please_select;
}
while ($row = $db->fetch()) {
$v = "第" . $row["week_cd"] . "週";
if ($row["week_seq"] != 0) {
$v = $v . $row["week_seq"] . "回";
}
if ($date_flg) {
$v = $v . " (" . Class_PWD::int8_to_date($row["flier_date"]) . ")";
}
$data[$row["matrix_cd"]] = $v;
}
return $data;
}
public static function get_insshop_form_upd_text($oldVal, $newVal, $username)
{
$new_line = self::$newLineChar;
$retval = array();
$retval["title"] = "【チラシ手配システム】折込販売店情報が更新されました";
// 販売店名
$ins_shop_name = $oldVal['ins_shop_name'] . "販売店";
if ($oldVal['ins_shop_name'] == $newVal['ins_shop_name']) {
$ins_shop_name = $ins_shop_name . "【" . $oldVal['ins_shop_cd'] . "】";
} else {
$ins_shop_name = $ins_shop_name . " → " . $newVal['ins_shop_name'] . "販売店【" . $oldVal['ins_shop_cd'] . "】";
}
// 都道府県
$local_name = $oldVal['local_name'];
if ($oldVal['local_cd'] != $newVal['local_cd']) {
$local_name = $local_name . " → " . $newVal['local_name'];
}
// 媒体名
$media_name = $oldVal['media_name'];
//if ( $oldVal['media_name'] != $newVal['media_name']) {
// $media_name = $media_name." → ".$newVal['media_name'];
//}
// 納品先
$delive_name = $oldVal['delive_name'];
if ($oldVal['delive_name'] != $newVal['delive_name']) {
$delive_name = $delive_name . " → " . $newVal['delive_name'];
}
// 折込会社部数
$insert_conums = $oldVal['insert_conums'] . "部";
if ($oldVal['insert_conums'] != $newVal['insert_conums']) {
$insert_conums = $insert_conums . " → " . $newVal['insert_conums'] . "部";
}
// 廃止日
$stop_date = Class_PWD::int8_to_date($newVal['stop_date']);
// 備考
$memo = $newVal['memo'];
$retval["text"] = "{$new_line}" . "関係各位{$new_line}" . "{$new_line}" . "チラシ手配システムからの自動送信メールです。{$new_line}" . "{$new_line}" . "折込販売店情報が{$username}によって更新されました。{$new_line}" . "更新内容は下記のとおりです。{$new_line}" . "{$new_line}" . "{$ins_shop_name}{$new_line}" . "都道府県：{$local_name}{$new_line}" . "媒体名：{$media_name}{$new_line}" . "納品先：{$delive_name}{$new_line}" . "販売店部数：{$insert_conums}{$new_line}" . "廃止日：{$stop_date}{$new_line}" . "情報更新理由：{$memo}{$new_line}" . "{$new_line}" . "以上です。{$new_line}" . "部数等が変更になった折込パターン情報などの見直しをお願いいたします。{$new_line}";
return $retval;
}
