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