$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; }