private function GetDataList()
{
$ret = array();
$ret["list"] = array();
$ret["row_count"] = 0;
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT column_no, title, description, keisai_datetime " . "FROM t_column " . "WHERE keisai_flg = 1 " . " AND NOW() >= keisai_datetime " . "ORDER BY keisai_datetime DESC, column_no DESC " . "LIMIT 10;";
$reader = $this->dbCon->ExecuteReader($sql, $param);
// 全体の件数を取得
$ret["row_count"] = $this->dbCon->RowCount();
$list = array();
while ($row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) {
unset($item);
$item["column_no"] = $row["column_no"];
$item["title"] = $row["title"];
$item["description"] = $row["description"];
$item["keisai_datetime"] = $this->ConvertToRfc2822($row["keisai_datetime"]);
$list[] = $item;
}
$ret["status"] = 1;
$ret["list"] = $list;
} catch (PDOException $e) {
$ret["status"] = 0;
cmnLogOutput("db error : " . print_r($e, true));
}
return $ret;
}
function dbLogout($dbCon)
{
if (!$_COOKIE[APP_LOGIN_ADM_ID]) {
return false;
}
setcookie(APP_LOGIN_ADM_ID, "", time() - 3600);
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "DELETE FROM";
$sql .= " c_login ";
$sql .= "WHERE";
$sql .= " login_id = ? AND";
$sql .= " user_no = ?";
$param[] = $_COOKIE[APP_LOGIN_ADM_ID];
$param[] = LoginInfo::$user_no;
$dbCon->ExecuteNonQuery($sql, $param);
} catch (PDOException $e) {
cmnLogOutput("db error : " . print_r($e, true));
}
return true;
}
private function GetDataList()
{
$ret = array();
$ret["list"] = array();
$ret["row_count"] = 0;
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT column_no, column_path, title, description, keisai_datetime " . "FROM t_column " . "WHERE keisai_flg = 1 " . " AND NOW() >= keisai_datetime " . " AND keisai_kigen > Now() " . "ORDER BY keisai_datetime DESC, column_no DESC " . "LIMIT 20;";
$reader = $this->dbCon->ExecuteReader($sql, $param);
// 全体の件数を取得
$ret["row_count"] = $this->dbCon->RowCount();
$list = [];
$pool = [];
while ($row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) {
if (in_array($row["column_path"], $pool)) {
continue;
} else {
$pool[] = $row["column_path"];
}
unset($item);
$item["column_no"] = str_pad($row["column_no"], 2, "0", STR_PAD_LEFT);
$item["column_path"] = str_pad($row["column_path"], 2, "0", STR_PAD_LEFT);
$item["title"] = $row["title"];
$item["description"] = $row["description"];
$item["keisai_datetime"] = $this->ConvertToRfc2822($row["keisai_datetime"]);
$list[] = $item;
if (count($list) == 10) {
break;
}
}
$ret["status"] = 1;
$ret["list"] = $list;
} catch (PDOException $e) {
$ret["status"] = 0;
cmnLogOutput("db error : " . print_r($e, true));
}
return $ret;
}
private function GetDbBody2($column_no)
{
$body = array();
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT";
$sql .= " column_body_no,";
$sql .= " sub_title,";
$sql .= " column_body ";
$sql .= "FROM";
$sql .= " t_column_body ";
$sql .= "WHERE";
$sql .= " column_no = ?";
$sql .= "ORDER BY";
$sql .= " seq ";
$sql .= " LIMIT 1;";
$param[] = $column_no;
$reader = $this->dbCon->ExecuteReader($sql, $param);
$row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
if ($row) {
$column_body_no = $row["column_body_no"];
$body["column_body_no"] = $column_body_no;
$body["sub_title"] = $row["sub_title"];
$body["column_body"] = strip_tags($row["column_body"], "");
// 画像
$body["img_nm"] = fimgGetFileName($column_body_no, "column/tn_");
if (strlen($body["img_nm"]) > 0) {
$body["img_show"] = true;
} else {
$body["img_show"] = false;
}
$body["img_src"] = fimgImgSrc($body["img_nm"], "column/tn_");
}
} catch (PDOException $e) {
cmnLogOutput("db error : " . print_r($e, true));
}
return $body;
}
public function DbDelete()
{
try {
// トランザクション開始
$this->dbCon->BeginTran();
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "DELETE FROM";
$sql .= " m_user ";
$sql .= "WHERE";
$sql .= " user_no = ?";
$param[] = $this->user_no;
$this->dbCon->ExecuteNonQuery($sql, $param);
$this->dbCon->Commit();
} catch (PDOException $e) {
$this->dbCon->Rollback();
$errno = $e->errorInfo[1];
switch ($errno) {
case 1452:
//外部キー制約
$arr_msg = array();
$arr_msg[] = "削除に失敗しました。";
$this->smarty->assign("arr_msg", $arr_msg);
return false;
}
cmnLogOutput("db error : " . print_r($e, true));
die('db error');
}
return true;
}
private function GetDataList()
{
$ret = array();
$ret["list"] = array();
$ret["row_count"] = 0;
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT SQL_CALC_FOUND_ROWS";
$sql .= " user_no,";
$sql .= " user_nm,";
$sql .= " user_kn,";
$sql .= " user_id,";
$sql .= " e_mail,";
$sql .= " last_login_time,";
$sql .= " ltime ";
$sql .= "FROM";
$sql .= " m_user ";
$sql .= "ORDER BY";
switch ($_GET["si"]) {
case "user_no":
$sql .= " user_no" . ($_GET["sa"] == "desc" ? " DESC" : "") . " ";
break;
case "user_nm":
$sql .= " user_nm" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", user_no ";
break;
case "user_kn":
$sql .= " user_kn" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", user_no ";
break;
case "user_id":
$sql .= " user_id" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", user_no ";
break;
case "e_mail":
$sql .= " e_mail" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", user_no ";
break;
case "last_login_time":
$sql .= " last_login_time" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", user_no ";
break;
default:
$sql .= " user_no ";
}
$sql .= comGetLimit($_GET["pn"], $_GET["pl"], self::C_LIST_COL_CNT);
$reader = $this->dbCon->ExecuteReader($sql, $param);
// 全体の件数を取得
$ret["row_count"] = $this->dbCon->RowCount();
$list = array();
while ($row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) {
unset($item);
$item["user_no"] = $row["user_no"];
$item["user_nm"] = $row["user_nm"];
$item["user_kn"] = $row["user_kn"];
$item["user_id"] = $row["user_id"];
$item["e_mail"] = $row["e_mail"];
$item["last_login_time"] = $row["last_login_time"];
$list[] = $item;
}
$ret["status"] = 1;
$ret["list"] = $list;
} catch (PDOException $e) {
$ret["status"] = 0;
cmnLogOutput("db error : " . print_r($e, true));
}
return $ret;
}
private function GetDataList()
{
$ret = array();
$ret["list"] = array();
$ret["row_count"] = 0;
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT SQL_CALC_FOUND_ROWS";
$sql .= " column_no,";
$sql .= " creation_date,";
$sql .= " midashi_title,";
$sql .= " keisai_datetime,";
$sql .= " keisai_flg,";
$sql .= " ltime ";
$sql .= "FROM";
$sql .= " t_column ";
$sql .= "ORDER BY";
switch ($_GET["si"]) {
case "creation_date":
$sql .= " creation_date" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", column_no ";
break;
case "midashi_title":
$sql .= " midashi_title" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", column_no ";
break;
case "keisai_datetime":
$sql .= " keisai_datetime" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", column_no ";
break;
case "keisai_flg":
$sql .= " keisai_flg" . ($_GET["sa"] == "desc" ? " DESC" : "") . ", column_no ";
break;
default:
$sql .= " keisai_datetime DESC, column_no DESC ";
}
$sql .= comGetLimit($_GET["pn"], $_GET["pl"], self::C_LIST_COL_CNT);
$reader = $this->dbCon->ExecuteReader($sql, $param);
// 全体の件数を取得
$ret["row_count"] = $this->dbCon->RowCount();
$list = array();
while ($row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT)) {
unset($item);
$item["column_no"] = $row["column_no"];
$item["creation_date"] = $row["creation_date"];
$item["midashi_title"] = $row["midashi_title"];
$item["keisai_datetime"] = $row["keisai_datetime"];
$item["keisai_flg"] = $row["keisai_flg"];
$list[] = $item;
}
$ret["status"] = 1;
$ret["list"] = $list;
} catch (PDOException $e) {
$ret["status"] = 0;
cmnLogOutput("db error : " . print_r($e, true));
}
return $ret;
}
function LastInsertId()
{
$last_id = 0;
try {
$param = array();
$sql = "SELECT LAST_INSERT_ID() AS last_id";
$stmt = $this->dbCon->prepare($sql);
$stmt->execute($param);
$row = $stmt->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
if ($row) {
$last_id = $row["last_id"];
}
} catch (PDOException $e) {
cmnLogOutput("DbConn LastInsertId PDOException:" . print_r($e, true));
return 0;
}
return $last_id;
}
public function DbDelete()
{
try {
// トランザクション開始
$this->dbCon->BeginTran();
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "DELETE FROM";
$sql .= " t_column ";
$sql .= "WHERE";
$sql .= " column_no = ?";
$param[] = $this->column_no;
$this->dbCon->ExecuteNonQuery($sql, $param);
$this->dbCon->Commit();
// 画像
fimgDelete("main_" . $this->column_no, "column/");
// Bodyの画像を削除すること
} catch (PDOException $e) {
$this->dbCon->Rollback();
$errno = $e->errorInfo[1];
switch ($errno) {
case 1451:
//外部キー制約
}
cmnLogOutput("db error : " . print_r($e, true));
die('db error');
}
return true;
}
function UserCheck($user_id, $user_password)
{
$ret = false;
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT";
$sql .= " user_no,";
$sql .= " password ";
$sql .= "FROM";
$sql .= " m_user ";
$sql .= "WHERE";
$sql .= " user_id = BINARY ?";
$param[] = $user_id;
$reader = $this->dbCon->ExecuteReader($sql, $param);
$row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
if ($row !== false) {
$this->user_no = $row["user_no"];
$password = $row["password"];
if ($password === $user_password) {
$ret = true;
}
}
} catch (PDOException $e) {
cmnLogOutput("db error : " . print_r($e, true));
}
return $ret;
}
public function IsToken($token)
{
$ret = false;
try {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "SELECT";
$sql .= " token ";
$sql .= "FROM";
$sql .= " c_token ";
$sql .= "WHERE";
$sql .= " token = ?";
$param[] = $token;
$reader = $this->dbCon->ExecuteReader($sql, $param);
$row = $reader->fetch(PDO::FETCH_ASSOC, PDO::FETCH_ORI_NEXT);
if ($row !== false) {
if ($token == $row["token"]) {
$ret = true;
}
}
} catch (PDOException $e) {
cmnLogOutput("db error : " . print_r($e, true));
}
return $ret;
}
