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