public function SetDbData()
{
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT";
$sql .= " user_nm,";
$sql .= " user_kn,";
$sql .= " user_id,";
$sql .= " password,";
$sql .= " e_mail,";
$sql .= " user_type,";
$sql .= " ltime ";
$sql .= "FROM";
$sql .= " m_user ";
$sql .= "WHERE";
$sql .= " user_no = ?";
$param[] = $this->user_no;
$reader = $this->dbCon->ExecuteReader($sql, $param);
$row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
if ($row !== false) {
$formData["user_nm"] = $row["user_nm"];
$formData["user_kn"] = $row["user_kn"];
$formData["user_id"] = $row["user_id"];
$formData["password"] = $row["password"];
$formData["e_mail"] = $row["e_mail"];
$formData["user_type"] = $row["user_type"];
// ユーザータイプ
$list = fnGetAdminUserTypeList();
$data = $formData["user_type"];
$select_list = cmnGetSelectList($list, $data);
$formData["user_type_list"] = $select_list;
$this->smarty->assign("formData", $formData);
}
} catch (PDOException $e) {
cmnLogOutput("db error : " . print_r($e, true));
}
}
public function SetDbData()
{
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT";
$sql .= " column_no,";
$sql .= " mode_div,";
$sql .= " creation_date,";
$sql .= " title,";
$sql .= " keywords,";
$sql .= " description,";
$sql .= " og_description,";
$sql .= " og_title,";
$sql .= " og_type,";
$sql .= " h1_tag,";
$sql .= " midashi_title,";
$sql .= " edit_body,";
$sql .= " keisai_datetime,";
$sql .= " keisai_flg,";
$sql .= " ltime ";
$sql .= "FROM";
$sql .= " t_column ";
$sql .= "WHERE";
$sql .= " column_no = ? ";
$sql .= " AND NOW() >= keisai_datetime;";
$param[] = $this->column_no;
$reader = $this->dbCon->ExecuteReader($sql, $param);
$row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
if ($row !== false) {
$formData["mode_div"] = $row["mode_div"];
$formData["creation_date_y"] = cmnDateFormat($row["creation_date"], "Y");
$formData["creation_date_m"] = cmnDateFormat($row["creation_date"], "m");
$formData["creation_date_d"] = cmnDateFormat($row["creation_date"], "d");
$formData["title"] = $row["title"];
$formData["keywords"] = $row["keywords"];
$formData["description"] = $row["description"];
$formData["h1_tag"] = $row["h1_tag"];
$formData["midashi_title"] = $row["midashi_title"];
$formData["edit_body"] = $row["edit_body"];
$formData["keisai_datetime_y"] = cmnDateFormat($row["keisai_datetime"], "Y");
$formData["keisai_datetime_m"] = cmnDateFormat($row["keisai_datetime"], "m");
$formData["keisai_datetime_d"] = cmnDateFormat($row["keisai_datetime"], "d");
$formData["keisai_datetime_h"] = cmnDateFormat($row["keisai_datetime"], "H");
$formData["keisai_datetime_n"] = cmnDateFormat($row["keisai_datetime"], "i");
$formData["keisai_flg"] = $row["keisai_flg"];
$formData["og_description"] = $row["og_description"];
$formData["og_title"] = $row["og_title"];
$formData["og_type"] = $row["og_type"];
// 作成年
$list = fnGetYearList();
$data = $formData["creation_date_y"];
$select_list = cmnGetSelectList($list, $data);
$formData["creation_date_y_list"] = $select_list;
// 作成月
$list = fnGetMonthList();
$data = $formData["creation_date_m"];
$select_list = cmnGetSelectList($list, $data);
$formData["creation_date_m_list"] = $select_list;
// 作成日
$list = fnGetDayList();
$data = $formData["creation_date_d"];
$select_list = cmnGetSelectList($list, $data);
$formData["creation_date_d_list"] = $select_list;
// 掲載年
$list = fnGetYearList();
$data = $formData["keisai_datetime_y"];
$select_list = cmnGetSelectList($list, $data);
$formData["keisai_datetime_y_list"] = $select_list;
// 掲載月
$list = fnGetMonthList();
$data = $formData["keisai_datetime_m"];
$select_list = cmnGetSelectList($list, $data);
$formData["keisai_datetime_m_list"] = $select_list;
// 掲載日
$list = fnGetDayList();
$data = $formData["keisai_datetime_d"];
$select_list = cmnGetSelectList($list, $data);
$formData["keisai_datetime_d_list"] = $select_list;
// 掲載時
$list = fnGetHourList();
$data = $formData["keisai_datetime_h"];
$select_list = cmnGetSelectList($list, $data);
$formData["keisai_datetime_h_list"] = $select_list;
// 掲載分
$list = fnGetMinuteList();
$data = $formData["keisai_datetime_n"];
$select_list = cmnGetSelectList($list, $data);
$formData["keisai_datetime_n_list"] = $select_list;
// 画像
$formData["img_nm_main"] = fimgGetFileName("pc_main_" . $this->column_no, "column/");
if (strlen($formData["img_nm_main"]) > 0) {
$formData["img_show_main"] = true;
} else {
$formData["img_show_main"] = false;
}
$formData["img_src_main"] = fimgImgSrc($formData["img_nm_main"], "column/");
$formData["img_nm_main_sp"] = fimgGetFileName("sp_main_" . $this->column_no, "column/");
if (strlen($formData["img_nm_main_sp"]) > 0) {
$formData["img_show_main_sp"] = true;
} else {
$formData["img_show_main_sp"] = false;
}
$formData["img_src_main_sp"] = fimgImgSrc($formData["img_nm_main_sp"], "column/");
// Body
$formData["body"] = $this->GetDbBody($this->column_no);
$formData["max_count"] = count($formData["body"]);
$this->smarty->assign("formData", $formData);
$this->smarty->assign("server_name", $_SERVER["SERVER_NAME"]);
$columnList = $this->GetDataList();
$this->smarty->assign("columnList", $columnList["list"]);
return "true";
} else {
return false;
}
} catch (PDOException $e) {
cmnLogOutput("db error : " . print_r($e, true));
}
}
