function fimgTmpRename($file, $new_file, $dir = "", $add_thumbnail = False)
{
$ex = "." . substr(strrchr($file, '.'), 1);
// サムネイルを作成
if ($add_thumbnail) {
fnSaveImg(APP_IMG_TMP_PATH . $file, APP_IMG_PATH . $dir . "tn_" . $new_file . $ex, 119, 102);
}
fnGenerateImages(APP_IMG_TMP_PATH . $file, $new_file, "column/", $add_thumbnail);
//$ret = rename(APP_IMG_TMP_PATH.$file, APP_IMG_PATH.$dir.$new_file.$ex);
//return $ret;
}
private function DbEntryBody()
{
if (is_array($_POST["column_body_no"])) {
$seq = 1;
foreach ($_POST["column_body_no"] as $key => $column_body_no) {
if (!ctype_digit($column_body_no)) {
// INSERT
if ($_POST["column_body_all_del"][$key] != "1") {
// SQL組み立て ----------------------------------------------
$param = array();
//新規追加処理
$values = "";
$sql = "INSERT INTO t_column_body (";
$sql .= " column_no,";
$values .= "?,";
$param[] = cmnDbNum($this->column_no);
$sql .= " seq,";
$values .= "?,";
$param[] = cmnDbNum($seq);
$sql .= " sub_title,";
$values .= "?,";
$param[] = cmnDbStr($_POST["sub_title"][$key]);
$sql .= " column_body,";
$values .= "?,";
$param[] = cmnDbStr($_POST["column_body"][$key]);
$sql .= " ltime";
$values .= "CURRENT_TIMESTAMP";
$sql .= ") VALUES (" . $values . ")";
$this->dbCon->ExecuteNonQuery($sql, $param);
$last_insert_column_body_no = $this->dbCon->LastInsertId();
// 画像
if (strlen($_POST["img_tmp_nm"][$key]) > 0 and $_POST["img_del"][$key] != "y") {
fnGenerateImages($_POST["img_tmp_nm"][$key], $last_insert_column_body_no, "column/");
}
$seq++;
}
} else {
// UPDATE
if ($_POST["column_body_all_del"][$key] != "1") {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "UPDATE t_column_body SET";
$sql .= " seq = ?,";
$param[] = cmnDbNum($seq);
$sql .= " sub_title = ?,";
$param[] = cmnDbStr($_POST["sub_title"][$key]);
$sql .= " column_body = ?,";
$param[] = cmnDbStr($_POST["column_body"][$key]);
$sql .= " ltime = CURRENT_TIMESTAMP ";
$sql .= "WHERE";
$sql .= " column_body_no = ?";
$param[] = $column_body_no;
$this->dbCon->ExecuteNonQuery($sql, $param);
// 画像
if ($_POST["img_del"][$key] == "y") {
fimgDelete($column_body_no, "column/");
} else {
if (strlen($_POST["img_tmp_nm"][$key]) > 0) {
fimgDelete($column_body_no, "column/");
fnGenerateImages($_POST["img_tmp_nm"][$key], $column_body_no, "column/");
}
}
$seq++;
} else {
// SQL組み立て ----------------------------------------------
$param = array();
$sql = "DELETE FROM";
$sql .= " t_column_body ";
$sql .= "WHERE";
$sql .= " column_body_no = ?";
$param[] = $column_body_no;
$this->dbCon->ExecuteNonQuery($sql, $param);
// 画像
fimgDelete($column_body_no, "column/");
}
}
}
}
}
