Skip to content

Instantly share code, notes, and snippets.

@atsu666

atsu666/Helper.php

Last active March 25, 2020 10:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save atsu666/d34981ca189872d95115bf194a7253ec to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save atsu666/d34981ca189872d95115bf194a7253ec to your computer and use it in GitHub Desktop.
Download ZIP
php/Services/Entry/Helper.php
Raw
Helper.php
<?php
namespace Acms\Services\Entry;
use Common;
use Entry;
use Storage;
use DB;
use SQL;
use ACMS_RAM;
use ACMS_POST_File;
use ACMS_POST_Image;
use ACMS_Validator;
use Field;
use ACMS_Hook;
use OpenGraph;
use ACMS_Services_Twitter;
class Helper
{
/**
* サマリーの表示で使うユニットの範囲を取得
*
* @var int
*/
protected $summaryRange;
/**
* ユニット保存後のユニットデータ
*
* @var string
*/
protected $savedColumn;
/**
* エントリーコードの重複をチェック
*
* @param string $code
* @param int $bid
* @param int $cid
* @param int $eid
*
* @return bool
*/
public function validEntryCodeDouble($code, $bid=BID, $cid=null, $eid=null)
{
$DB = DB::singleton(dsn());
$SQL = SQL::newSelect('entry');
$SQL->addSelect('entry_id');
$SQL->addWhereOpr('entry_code', $code);
$SQL->addWhereOpr('entry_id', $eid, '<>');
$SQL->addWhereOpr('entry_category_id', $cid);
$SQL->addWhereOpr('entry_blog_id', $bid);
if ( $DB->query($SQL->get(dsn()), 'one') ) {
return true;
} else {
return false;
}
}
/**
* エントリーのタグをバリデート
*
* @param \Field_Validation $Entry
*
* @return \Field_Validation
*/
public function validTag($Entry)
{
$tags = $Entry->get('tag');
if (!empty($tags)) {
$tags = Common::getTagsFromString($tags, false);
foreach ( $tags as $sort => $tag ) {
if (isReserved($tag)) {
$Entry->setMethod('tag', 'reserved', false);
break;
}
if ( !preg_match('/^[^#,\/]*$/u', $tag) ) {
$Entry->setMethod('tag', 'string', false);
break;
}
}
}
return $Entry;
}
/**
* PING送信
*
* @param string $endpoint
* @param int $eid
*
* @return void
*/
public function pingTrackback($endpoint, $eid)
{
$aryEndpoint = preg_split('@\s@', $endpoint, -1, PREG_SPLIT_NO_EMPTY);
$title = ACMS_RAM::entryTitle($eid);
$excerpt = mb_strimwidth(loadFulltext($eid), 0, 252, '...', 'UTF-8');
$url = acmsLink(array(
'bid' => BID,
'cid' => ACMS_RAM::entryCategory($eid),
'eid' => $eid,
), false);
$blog_name = ACMS_RAM::blogName(BID);
if ( empty($aryEndpoint) ) return false;
foreach ( $aryEndpoint as $ep ) {
$req = new HTTP_Request2($ep, HTTP_Request2::METHOD_POST);
$req->setAdapter('curl');
$req->setConfig(array(
'timeout' => 10,
'ssl_verify_peer' => false,
'ssl_verify_host' => false,
));
$req->setHeader(array(
'Content-Type' => 'application/x-www-form-urlencoded'
));
$req->addPostParameter('title', $title);
$req->addPostParameter('excerpt', $excerpt);
$req->addPostParameter('url', $url);
$req->addPostParameter('blog_name', $blog_name);
try {
$response = $req->send();
$res = $response->getBody();
} catch ( HTTP_Request2_Exception $e ) {
return;
}
}
}
/**
* エントリーの削除
*
* @param int $eid
*
* @return void
*/
public function entryDelete($eid, $changeRevision = false)
{
$DB = DB::singleton(dsn());
//----------
// archives
$SQL = SQL::newSelect('column');
$SQL->addWhereOpr('column_entry_id', $eid);
$q = $SQL->get(dsn());
if ( $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
$type = detectUnitTypeSpecifier($row['column_type']);
switch ( $type ) {
case 'image':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = ARCHIVES_DIR.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
deleteFile($path);
deleteFile($large);
deleteFile($tiny);
deleteFile($square);
}
break;
case 'file':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = ARCHIVES_DIR.$old;
deleteFile($path);
}
break;
}
} while ( $row = $DB->fetch($q) ); }
//------------
// entry
$SQL = SQL::newDelete('entry');
$SQL->addWhereOpr('entry_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//----------------------
// column, tag, comment
if ($changeRevision) {
$SQL = SQL::newDelete('column');
$SQL->addWhereOpr('column_entry_id', $eid);
$SQL->addWhereOpr('column_attr', 'acms-form', '<>');
$DB->query($SQL->get(dsn()), 'exec');
$SQL = SQL::newDelete('tag');
$SQL->addWhereOpr('tag_entry_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
} else {
foreach ( array('column', 'tag', 'comment') as $tb ) {
$SQL = SQL::newDelete($tb);
$SQL->addWhereOpr($tb.'_entry_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
}
}
//---------------
// sub category
$SQL = SQL::newDelete('entry_sub_category');
$SQL->addWhereOpr('entry_sub_category_eid', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//---------------
// related entry
$SQL = SQL::newDelete('relationship');
$SQL->addWhereOpr('relation_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//----------
// fulltext
$SQL = SQL::newDelete('fulltext');
$SQL->addWhereOpr('fulltext_eid', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//-------
// field
$Field = loadEntryField($eid);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
foreach ( $Field->getArray($fd, true) as $i => $val ) {
$path = $val;
if ( !Storage::isFile(ARCHIVES_DIR.$path) ) continue;
Storage::remove(ARCHIVES_DIR.$path);
if ( HOOK_ENABLE ) {
$Hook = ACMS_Hook::singleton();
$Hook->call('mediaDelete', ARCHIVES_DIR.$path);
}
}
}
Common::saveField('eid', $eid);
//-----------------------
// キャッシュクリア予約削除
Entry::deleteCacheControl($eid);
}
/**
* エントリーのバージョンを削除
*
* @param int $eid
*
* @return void
*/
public function revisionDelete($eid)
{
$DB = DB::singleton(dsn());
//----------
// archives
$SQL = SQL::newSelect('column_rev');
$SQL->addWhereOpr('column_entry_id', $eid);
$q = $SQL->get(dsn());
if ( $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
$type = detectUnitTypeSpecifier($row['column_type']);
switch ( $type ) {
case 'image':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = REVISON_ARCHIVES_DIR.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
deleteFile($path);
deleteFile($large);
deleteFile($tiny);
deleteFile($square);
}
break;
case 'file':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = REVISON_ARCHIVES_DIR.$old;
deleteFile($path);
}
break;
case 'custom':
if ( empty($row['column_field_6']) ) break;
$oldAry = explodeUnitData($row['column_field_6']);
foreach ( $oldAry as $fieldString ) {
$Field = acmsUnserialize($fieldString);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
foreach ( $Field->getArray($fd, true) as $i => $old ) {
$path = REVISON_ARCHIVES_DIR.$old;
deleteFile($path);
}
}
}
break;
}
} while ( $row = $DB->fetch($q) ); }
//------
// unit
$SQL = SQL::newDelete('column_rev');
$SQL->addWhereOpr('column_entry_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//-----
// tag
$SQL = SQL::newDelete('tag_rev');
$SQL->addWhereOpr('tag_entry_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//---------------
// sub category
$SQL = SQL::newDelete('entry_sub_category_rev');
$SQL->addWhereOpr('entry_sub_category_eid', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//-------
// field
$SQL = SQL::newSelect('entry_rev');
$SQL->addSelect('entry_rev_id');
$SQL->addWhereOpr('entry_id', $eid);
if ( $all = $DB->query($SQL->get(dsn()), 'all') ) {
foreach ( $all as $rev ) {
$rvid = $rev['entry_rev_id'];
$Field = loadEntryField($eid, $rvid);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
foreach ( $Field->getArray($fd, true) as $i => $path ) {
if ( !Storage::isFile(REVISON_ARCHIVES_DIR.$path) ) continue;
Storage::remove(REVISON_ARCHIVES_DIR.$path);
}
}
Common::saveField('eid', $eid, null, null, $rvid);
}
}
//-------
// entry
$SQL = SQL::newDelete('entry_rev');
$SQL->addWhereOpr('entry_id', $eid);
$DB->query($SQL->get(dsn()), 'exec');
}
/**
* バージョンの切り替え
*
* @param int $rvid
* @param int $eid
* @param int $bid
*
* @return int
*/
function changeRevision($rvid, $eid, $bid)
{
$DB = DB::singleton(dsn());
$cid = null;
$primaryImageId = null;
if ( !is_numeric($rvid) ) die();
// エントリの情報を削除
Entry::entryDelete(EID, true);
//-------
// entry
$SQL = SQL::newSelect('entry_rev');
$SQL->addWhereOpr('entry_id', EID);
$SQL->addWhereOpr('entry_rev_id', $rvid);
$SQL->addWhereOpr('entry_blog_id', BID);
$q = $SQL->get(dsn());
$Entry = SQL::newInsert('entry');
if ( $row = $DB->query($q, 'row') ) {
$cid = $row['entry_category_id'];
foreach ( $row as $key => $val ) {
if ( !preg_match('@^(entry_rev|entry_approval)@', $key) ) {
$Entry->addInsert($key, $val);
}
}
$Entry->addInsert('entry_current_rev_id', $rvid);
$Entry->addInsert('entry_last_update_user_id', SUID);
$DB->query($Entry->get(dsn()), 'exec');
$primaryImageId = $row['entry_primary_image'];
}
//------
// unit
$SQL = SQL::newSelect('column_rev');
$SQL->addWhereOpr('column_entry_id', EID);
$SQL->addWhereOpr('column_rev_id', $rvid);
$SQL->addWhereOpr('column_blog_id', BID);
$q = $SQL->get(dsn());
$Unit = SQl::newInsert('column');
if ( $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
$type = detectUnitTypeSpecifier($row['column_type']);
switch ( $type ) {
case 'image':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
$newAry = array();
foreach ( $oldAry as $old ) {
$info = pathinfo($old);
$dirname= empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory(ARCHIVES_DIR.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newOld = $dirname.uniqueString().$ext;
$path = REVISON_ARCHIVES_DIR.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
$newPath = ARCHIVES_DIR.$newOld;
$newLarge = otherSizeImagePath($newPath, 'large');
$newTiny = otherSizeImagePath($newPath, 'tiny');
$newSquare = otherSizeImagePath($newPath, 'square');
copyFile($path, $newPath);
copyFile($large, $newLarge);
copyFile($tiny, $newTiny);
copyFile($square, $newSquare);
$newAry[] = $newOld;
}
$row['column_field_2'] = implodeUnitData($newAry);
break;
case 'file':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
$newAry = array();
foreach ( $oldAry as $old ) {
$info = pathinfo($old);
$dirname= empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory(ARCHIVES_DIR.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newOld = $dirname.uniqueString().$ext;
$path = REVISON_ARCHIVES_DIR.$old;
$newPath = ARCHIVES_DIR.$newOld;
copyFile($path, $newPath);
$newAry[] = $newOld;
}
$row['column_field_2'] = implodeUnitData($newAry);
break;
case 'custom':
if ( empty($row['column_field_6']) ) break;
$oldAry = explodeUnitData($row['column_field_6']);
foreach ( $oldAry as $fieldString ) {
$Field = acmsUnserialize($fieldString);
$newAry = array();
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
$set = false;
foreach ( $Field->getArray($fd, true) as $i => $old ) {
$info = pathinfo($old);
$dirname = empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory(ARCHIVES_DIR.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newOld = $dirname.uniqueString().$ext;
$path = REVISON_ARCHIVES_DIR.$old;
$newPath = ARCHIVES_DIR.$newOld;
copyFile($path, $newPath);
if ( !$set ) {
$Field->delete($fd);
$set = true;
}
$Field->add($fd, $newOld);
}
}
$newAry[] = acmsSerialize($Field);
}
$row['column_field_6'] = implodeUnitData($newAry);
break;
}
foreach ( $row as $key => $val ) {
if ( $key !== 'column_id' && $key !== 'column_rev_id' ) {
$Unit->addInsert($key, $val);
}
}
$nextUnitId = $DB->query(SQL::nextval('column_id', dsn()), 'seq');
if ( !empty($primaryImageId) && $row['column_id'] == $primaryImageId ) {
$primaryImageId = $nextUnitId;
}
$Unit->addInsert('column_id', $nextUnitId);
$DB->query($Unit->get(dsn()), 'exec');
} while ( $row = $DB->fetch($q) ); }
//---------------------
// primaryImageIdを更新
$SQL = SQL::newUpdate('entry');
$SQL->addUpdate('entry_primary_image', $primaryImageId);
$SQL->addWhereOpr('entry_id', EID);
$SQL->addWhereOpr('entry_blog_id', BID);
$DB->query($SQL->get(dsn()), 'exec');
//-------
// field
$Field = loadEntryField(EID, $rvid);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
$set = false;
foreach ( $Field->getArray($fd, true) as $i => $path ) {
if ( !Storage::isFile(REVISON_ARCHIVES_DIR.$path) ) continue;
$info = pathinfo($path);
$dirname = empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory(ARCHIVES_DIR.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newPath = $dirname.uniqueString().$ext;
Storage::copy(REVISON_ARCHIVES_DIR.$path, ARCHIVES_DIR.$newPath);
if ( !$set ) {
$Field->delete($fd);
$set = true;
}
$Field->add($fd, $newPath);
}
}
Common::saveField('eid', EID, $Field);
//-------
// tag
$SQL = SQL::newSelect('tag_rev');
$SQL->addWhereOpr('tag_entry_id', EID);
$SQL->addWhereOpr('tag_rev_id', $rvid);
$SQL->addWhereOpr('tag_blog_id', BID);
$q = $SQL->get(dsn());
$Tag = SQl::newInsert('tag');
if ( $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
foreach ( $row as $key => $val ) {
if ( $key !== 'tag_rev_id' ) {
$Tag->addInsert($key, $val);
}
}
$DB->query($Tag->get(dsn()), 'exec');
} while ( $row = $DB->fetch($q) ); }
//---------------
// sub category
$SQL = SQL::newDelete('entry_sub_category');
$SQL->addWhereOpr('entry_sub_category_eid', $eid);
$DB->query($SQL->get(dsn()), 'exec');
//---------------
// related entry
$SQL = SQL::newSelect('relationship_rev');
$SQL->addWhereOpr('relation_id', EID);
$SQL->addWhereOpr('relation_rev_id', $rvid);
$all = $DB->query($SQL->get(dsn()), 'all');
foreach ( $all as $row ) {
$SQL = SQL::newInsert('relationship');
$SQL->addInsert('relation_id', EID);
$SQL->addInsert('relation_eid', $row['relation_eid']);
$SQL->addInsert('relation_type', $row['relation_type']);
$SQL->addInsert('relation_order', $row['relation_order']);
$DB->query($SQL->get(dsn()), 'all');
}
//----------
// fulltext
Common::saveFulltext('eid', $eid, Common::loadEntryFulltext($eid));
return $cid;
}
/**
* エントリーの画像削除
*
* @param int $eid
*
* @return void
*/
public function entryArchivesDelete($eid)
{
$DB = DB::singleton(dsn());
//----------
// archives
$SQL = SQL::newSelect('column');
$SQL->addWhereOpr('column_entry_id', $eid);
$q = $SQL->get(dsn());
if ( $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
$type = detectUnitTypeSpecifier($row['column_type']);
switch ( $type ) {
case 'image':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = ARCHIVES_DIR.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
deleteFile($path);
deleteFile($large);
deleteFile($tiny);
deleteFile($square);
}
break;
case 'file':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = ARCHIVES_DIR.$old;
deleteFile($path);
}
break;
case 'custom':
if ( empty($row['column_field_6']) ) break;
$oldAry = explodeUnitData($row['column_field_6']);
foreach ( $oldAry as $fieldString ) {
$Field = acmsUnserialize($fieldString);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
foreach ( $Field->getArray($fd, true) as $i => $old ) {
$path = ARCHIVES_DIR.$old;
deleteFile($path);
}
}
}
break;
}
} while ( $row = $DB->fetch($q) ); }
//-------
// field
$Field = loadEntryField($eid);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
} else {
foreach ( $Field->getArray($fd, true) as $i => $val ) {
$path = $val;
if ( !Storage::isFile(ARCHIVES_DIR.$path) ) continue;
Storage::remove(ARCHIVES_DIR.$path);
if ( HOOK_ENABLE ) {
$Hook = ACMS_Hook::singleton();
$Hook->call('mediaDelete', ARCHIVES_DIR.$path);
}
}
}
}
}
/**
* サマリーの表示で使うユニットの範囲を取得
* Entry::extractColumn 後に決定
*
* @return int
*/
public function getSummaryRange()
{
return $this->summaryRange;
}
/**
* ユニット保存後のユニットデータを取得
* Entry::extractColumn 後に決定
*
* @return int
*/
public function getSavedColumn()
{
return $this->savedColumn;
}
/**
* ユニットデータの抜き出し
*
* @param bool $olddel
* @param bool $directAdd
* @param string $moveArchive
*
* @return array
*/
public function extractColumn($range=0, $olddel=true, $directAdd=false, $moveArchive='')
{
$summaryRange = $range;
if ( !empty($_POST['column_object']) ) {
return unserialize(gzinflate(base64_decode($_POST['column_object'])));
}
$Column = array();
$overCount = 0;
$ARCHIVES_DIR = ARCHIVES_DIR;
if ( !empty($moveArchive) ) {
$ARCHIVES_DIR = ARCHIVES_DIR.'TEMP/';
}
if ( !(isset($_POST['type']) and is_array($_POST['type'])) ) return $Column;
foreach ( $_POST['type'] as $i => $type ) {
$id = $_POST['id'][$i];
// 特定指定子を含むユニットタイプ
$actualType = $type;
// 特定指定子を除外した、一般名のユニット種別
$type = detectUnitTypeSpecifier($type);
//------
// text
if ( 'text' == $type ) {
$data = array(
'tag' => $_POST['text_tag_' . $id],
);
if ( isset($_POST['text_extend_tag_' . $id]) ) {
$data['extend_tag'] = $_POST['text_extend_tag_' . $id];
}
$data['text'] = implodeUnitData($_POST['text_text_' . $id]);
if ( $directAdd && strlen($data['text']) === 0 ) {
$data['text'] = config('action_direct_def_text');
}
//-------
// table
} else if ( 'table' == $type ) {
$data = array(
'table' => implodeUnitData($_POST['table_source_' . $id]),
);
//-------
// image
} else if ( 'image' == $type ) {
$caption = isset($_POST['image_caption_'.$id]) ? $_POST['image_caption_'.$id] : null;
$old = isset($_POST['image_old_'.$id]) ? $_POST['image_old_'.$id] : null;
$Image = new ACMS_POST_Image($olddel, $directAdd, $moveArchive);
$imageFiles = array();
$dataArray = array();
//------------------
// extra unit data
if ( is_array($caption) ) {
$imagePathAry = array();
$exifAry = array();
foreach ( $caption as $n => $val ) {
$_old = isset($_POST['image_old_'.$id][$n]) ? $_POST['image_old_'.$id][$n] : $old;
$edit = isset($_POST['image_edit_'.$id][$n]) ? $_POST['image_edit_'.$id][$n] : $_POST['image_edit_'.$id];
if ( isset($_POST['image_file_'.$id][$n]) && !empty($_POST['image_file_'.$id][$n]) ) {
$Image = new ACMS_POST_Image($olddel, true, $moveArchive);
ACMS_POST_Image::base64DataToImage($_POST['image_file_'.$id][$n], 'image_file_'.$id, $n);
}
$tmp = isset($_FILES['image_file_'.$id]['tmp_name'][$n]) ? $_FILES['image_file_'.$id]['tmp_name'][$n] : '';
$exifData = isset($_POST['image_exif_'.$id]) ? $_POST['image_exif_'.$id] : array();
foreach ( $Image->buildAndSave(
$id,
$_old,
$tmp,
$_POST['image_size_'.$id],
$edit,
$_POST['old_image_size_'.$id]
) as $imageData ) {
$exif = array_shift($exifData);
$imageData['exif'] = $exif;
$imageFiles[$n] = $imageData;
}
if ( empty($imageFiles[$n]) ) {
$imageFiles[$n] = array(
'path' => '',
'exif' => '',
);
}
}
foreach ( $imageFiles as $imagePath ) {
$imagePathAry[] = $imagePath['path'];
$exifAry[] = $imagePath['exif'];
}
$dataArray[] = array(
'path' => implodeUnitData($imagePathAry),
'exif' => implodeUnitData($exifAry),
'caption' => implodeUnitData($_POST['image_caption_'.$id]),
'link' => implodeUnitData($_POST['image_link_'.$id]),
'alt' => implodeUnitData($_POST['image_alt_'.$id]),
'size' => implodeUnitData($_POST['image_size_'.$id]),
);
//------------------
// normal unit data
} else {
if ( 1
&& isset($_POST['image_file_'.$id])
&& ( 0
|| is_array($_POST['image_file_'.$id]) && !empty($_POST['image_file_'.$id][0])
|| !is_array($_POST['image_file_'.$id]) && !empty($_POST['image_file_'.$id])
)
) {
$Image = new ACMS_POST_Image($olddel, true, $moveArchive);
ACMS_POST_Image::base64DataToImage($_POST['image_file_'.$id], 'image_file_'.$id);
}
$tmp = isset($_FILES['image_file_'.$id]['tmp_name']) ? $_FILES['image_file_'.$id]['tmp_name'] : '';
$oldSize = isset($_POST['old_image_size_'.$id]) ? $_POST['old_image_size_'.$id] : '';
$exifAry = isset($_POST['image_exif_'.$id]) ? $_POST['image_exif_'.$id] : array();
foreach ( $Image->buildAndSave(
$id,
$old,
$tmp,
$_POST['image_size_'.$id],
$_POST['image_edit_'.$id],
$oldSize
) as $imageData ) {
$exif = array_shift($exifAry);
if ( empty($imageData) ) continue;
$imageData['exif'] = $exif;
$imageFiles[] = $imageData;
}
foreach ( $imageFiles as $imagePath ) {
$dataArray[] = array(
'path' => $imagePath['path'],
'exif' => $imagePath['exif'],
'caption' => $_POST['image_caption_'.$id],
'link' => $_POST['image_link_'.$id],
'alt' => $_POST['image_alt_'.$id],
'size' => $_POST['image_size_'.$id],
);
}
}
//------
// file
} else if ( 'file' == $type ) {
$caption = isset($_POST['file_caption_'.$id]) ? $_POST['file_caption_'.$id] : null;
$old = isset($_POST['file_old_'.$id]) ? $_POST['file_old_'.$id] : null;
$File = new ACMS_POST_File($olddel, $directAdd, $moveArchive);
$files = array();
$fileArray = array();
//------------------
// extra unit data
if ( is_array($caption) ) {
$filePathAry = array();
foreach ( $caption as $n => $val ) {
$_old = isset($_POST['file_old_'.$id][$n]) ? $_POST['file_old_'.$id][$n] : $old;
$edit = isset($_POST['file_edit_'.$id][$n]) ? $_POST['file_edit_'.$id][$n] : (isset($_POST['file_edit_'.$id]) ? $_POST['file_edit_'.$id] : '');
foreach ( $File->buildAndSave(
$id,
$_old,
$_FILES['file_file_'.$id]['tmp_name'][$n],
$_FILES['file_file_'.$id]['name'][$n],
$n,
$edit
) as $fileData ) {
$files[$n] = $fileData;
}
if ( empty($fileData) ) {
$files[$n] = '';
}
}
foreach ( $files as $filePath ) {
$filePathAry[] = $filePath;
}
$fileArray[] = array(
'path' => implodeUnitData($filePathAry),
'caption' => implodeUnitData($_POST['file_caption_'.$id]),
);
//------------------
// normal unit data
} else {
$edit = isset($_POST['file_edit_'.$id]) ? $_POST['file_edit_'.$id] : '';
if ( !isset($_FILES['file_file_'.$id]) ) {
$_FILES['file_file_'.$id]['tmp_name'] = '';
$_FILES['file_file_'.$id]['name'] = '';
}
foreach ( $File->buildAndSave(
$id,
$old,
$_FILES['file_file_'.$id]['tmp_name'],
$_FILES['file_file_'.$id]['name'],
0,
$edit
) as $fileData ) {
if ( empty($fileData) ) continue;
$files[] = $fileData;
}
foreach ( $files as $filePath ) {
$fileArray[] = array(
'path' => $filePath,
'caption' => $_POST['file_caption_'.$id],
);
}
}
//-----
// map
} else if ('osmap' === $type || 'map' === $type) {
$data = array(
'lat' => $_POST['map_lat_'.$id],
'lng' => $_POST['map_lng_'.$id],
'zoom' => $_POST['map_zoom_'.$id],
'msg' => $_POST['map_msg_'.$id],
'size' => $_POST['map_size_'.$id],
);
//------
// yolp
} else if ( 'yolp' == $type ) {
$data = array(
'lat' => $_POST['yolp_lat_'.$id],
'lng' => $_POST['yolp_lng_'.$id],
'zoom' => $_POST['yolp_zoom_'.$id],
'msg' => $_POST['yolp_msg_'.$id],
'size' => $_POST['yolp_size_'.$id],
'layer' => $_POST['yolp_layer_'.$id],
);
//---------
// youtube
} else if ( 'youtube' == $type ) {
$data = array(
'youtube_id' => implodeUnitData($_POST['youtube_id_'.$id]),
'size' => $_POST['youtube_size_'.$id],
);
if ( $directAdd && strlen($data['youtube_id']) === 0 ) {
$data['youtube_id'] = config('action_direct_def_youtubeid');
}
//---------
// video
} else if ( 'video' == $type ) {
$data = array(
'video_id' => implodeUnitData($_POST['video_id_'.$id]),
'size' => $_POST['video_size_'.$id],
);
if ( $directAdd && strlen($data['video_id']) === 0 ) {
$data['video_id'] = config('action_direct_def_videoid');
}
//---------
// eximage
} else if ( 'eximage' == $type ) {
$size = $_POST['eximage_size_'.$id];
$normal = $_POST['eximage_normal_'.$id];
$large = $_POST['eximage_large_'.$id];
$display_size = '';
if ( strpos($size, ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $size);
}
$normalPath = is_array($normal) ? $normal[0] : $normal;
$largePath = is_array($large) ? $large[0] : $large;
if ( 'http://' != substr($normalPath, 0, 7) && 'https://' != substr($normalPath, 0, 8) ) {
$normalPath = rtrim(DOCUMENT_ROOT, '/').$normalPath;
}
if ( 'http://' != substr($largePath, 0, 7) && 'https://' != substr($largePath, 0, 8) ) {
$largePath = rtrim(DOCUMENT_ROOT, '/').$largePath;
}
if ( $xy = Storage::getImageSize($normalPath) ) {
if ( !empty($size) and ($size < max($xy[0], $xy[1])) ) {
if ( $xy[0] > $xy[1] ) {
$x = $size;
$y = intval(floor(($size/$xy[0])*$xy[1]));
} else {
$y = $size;
$x = intval(floor(($size/$xy[1])*$xy[0]));
}
} else {
$x = $xy[0];
$y = $xy[1];
}
$size = $x.'x'.$y;
if ( !Storage::getImageSize($largePath) ) $large = '';
} else {
$normal = '';
}
if ( !empty($display_size) ) {
$size = $size.':'.$display_size;
}
$data = array(
'normal' => implodeUnitData($normal),
'large' => implodeUnitData($large),
'caption' => implodeUnitData($_POST['eximage_caption_'.$id]),
'link' => implodeUnitData($_POST['eximage_link_'.$id]),
'alt' => implodeUnitData($_POST['eximage_alt_'.$id]),
'size' => $size,
);
if ( $directAdd && strlen($data['normal']) === 0 ) {
$data['normal'] = config('action_direct_def_eximage');
$data['size'] = config('action_direct_def_eximage_size');
}
//---------
// quote
} else if ( 'quote' == $type ) {
$data = array(
'quote_url' => implodeUnitData($_POST['quote_url_'.$id]),
);
if ( $directAdd && strlen($data['quote_url']) === 0 ) {
$data['quote_url'] = config('action_direct_def_quote_url');
}
//---------
// media
} else if ( 'media' == $type ) {
$midArray = $_POST['media_id_'.$id];
$size = $_POST['media_size_'.$id];
$enlarged = isset($_POST['media_enlarged_'.$id]) ? $_POST['media_enlarged_'.$id] : null;
$caption = isset($_POST['media_caption_'.$id]) ? $_POST['media_caption_'.$id] : null;
$alt = isset($_POST['media_alt_'.$id]) ? $_POST['media_alt_'.$id] : null;
$display_size = '';
$mediaArray = array();
if (strpos($size, ':') !== false) {
list($size, $display_size) = preg_split('/:/', $size);
}
if (!empty($display_size)) {
$size = $size.':'.$display_size;
}
if (!is_array($midArray)) {
$midArray = array($midArray);
}
foreach ($midArray as $n => $mid) {
$mediaArray[] = array(
'media_id' => implodeUnitData($mid),
'size' => $size,
'enlarged' => implodeUnitData($enlarged),
'caption' => implodeUnitData($caption),
'alt' => implodeUnitData($alt),
);
}
//-------
// break
} else if ( 'break' == $type ) {
$data = array(
'label' => implodeUnitData($_POST['break_label_'.$id]),
);
//--------
// module
} else if ( 'module' == $type ) {
$data = array(
'mid' => $_POST['module_mid_'.$id],
'tpl' => $_POST['module_tpl_'.$id],
);
//--------
// custom
} else if ( 'custom' == $type ) {
$Field = Common::extract('unit'.$id, new ACMS_Validator, new Field(), $moveArchive);
$obj = Common::getDeleteField();
$Field->retouchCustomUnit($id);
$data = array(
'field' => $Field,
);
} else {
continue;
}
$baseCol = array(
'id' => $id,
'clid' => $_POST['clid'][$i],
'type' => $actualType,
'align' => $_POST['align'][$i],
'sort' => @intval($_POST['sort'][$i]) + $overCount,
'attr' => $_POST['attr'][$i],
'group' => @$_POST['group'][$i],
'size' => '',
);
$baseSortNum = $baseCol['sort'];
if ( 'image' == $type ) {
foreach ( array_reverse($dataArray) as $num => $col ) {
if ( $baseSortNum <= $summaryRange and $num > 0) {
$summaryRange++;
}
$baseCol['sort'] = $baseSortNum + $num;
if ( $num > 0 ) {
$overCount++;
$baseCol['clid'] = '';
$baseCol['id'] = uniqueString();
}
$Column[] = $col + $baseCol;
}
} else if ( 'file' == $type ) {
foreach (array_reverse($fileArray) as $num => $col) {
if ($baseSortNum <= $summaryRange and $num > 0) {
$summaryRange++;
}
$baseCol['sort'] = $baseSortNum + $num;
if ($num > 0) {
$overCount++;
$baseCol['clid'] = '';
$baseCol['id'] = uniqueString();
}
$Column[] = $col + $baseCol;
}
} else if ('media' === $type) {
foreach ($mediaArray as $num => $col) {
if ($baseSortNum <= $summaryRange and $num > 0) {
$summaryRange++;
}
$baseCol['sort'] = $baseSortNum + $num;
if ($num > 0) {
$overCount++;
$baseCol['clid'] = '';
$baseCol['id'] = uniqueString();
}
$Column[] = $col + $baseCol;
}
} else {
$Column[] = $data + $baseCol;
}
}
$this->summaryRange = $summaryRange;
return $Column;
}
/**
* ユニットの保存
*
* @param array $Column
* @param int $eid
* @param int $bid
* @param bool $add
* @param int $rvid
* @param string $moveArchive
*
* @return array
*/
function saveColumn($Column, $eid, $bid, $add=false, $rvid=null, $moveArchive=false)
{
$DB = DB::singleton(dsn());
$ARCHIVES_DIR_TO = REVISON_ARCHIVES_DIR;
$tableName = 'column';
$revision = false;
if ( 1
&& enableRevision(false)
&& $rvid !== null
) {
if ( $moveArchive === 'ARCHIVES_DIR' ) {
$ARCHIVES_DIR_TO = ARCHIVES_DIR;
$SQL = SQL::newSelect('column');
$SQL->addWhereOpr('column_entry_id', $eid);
$SQL->addWhereOpr('column_blog_id', $bid);
$SQL->addWhereOpr('column_attr', 'acms-form', '<>');
$q = $SQL->get(dsn());
if ( $row = $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
$type = detectUnitTypeSpecifier($row['column_type']);
switch ( $type ) {
case 'image':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = ARCHIVES_DIR.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
deleteFile($path);
deleteFile($large);
deleteFile($tiny);
deleteFile($square);
}
break;
case 'file':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = ARCHIVES_DIR.$old;
deleteFile($path);
}
break;
case 'custom':
if ( empty($row['column_field_6']) ) break;
$oldAry = explodeUnitData($row['column_field_6']);
foreach ( $oldAry as $fieldString ) {
$Field = acmsUnserialize($fieldString);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
foreach ( $Field->getArray($fd, true) as $i => $old ) {
$path = ARCHIVES_DIR.$old;
deleteFile($path);
}
}
}
break;
}
} while ( $row = $DB->fetch($q) ); }
} else {
$tableName = 'column_rev';
}
$revision = true;
}
if ( 1
&& $revision
&& intval($rvid) === 1
&& empty($moveArchive)
) {
$SQL = SQL::newSelect('column_rev');
$SQL->addWhereOpr('column_entry_id', $eid);
$SQL->addWhereOpr('column_blog_id', $bid);
$SQL->addWhereOpr('column_attr', 'acms-form', '<>');
$SQL->addWhereOpr('column_rev_id', 1);
$q = $SQL->get(dsn());
if ( $row = $DB->query($q, 'fetch') and ($row = $DB->fetch($q)) ) { do {
$type = detectUnitTypeSpecifier($row['column_type']);
switch ( $type ) {
case 'image':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = REVISON_ARCHIVES_DIR.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
deleteFile($path);
deleteFile($large);
deleteFile($tiny);
deleteFile($square);
}
break;
case 'file':
if ( empty($row['column_field_2']) ) break;
$oldAry = explodeUnitData($row['column_field_2']);
foreach ( $oldAry as $old ) {
$path = REVISON_ARCHIVES_DIR.$old;
deleteFile($path);
}
break;
case 'custom':
if ( empty($row['column_field_6']) ) break;
$oldAry = explodeUnitData($row['column_field_6']);
foreach ( $oldAry as $fieldString ) {
$Field = acmsUnserialize($fieldString);
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
foreach ( $Field->getArray($fd, true) as $i => $old ) {
$path = REVISON_ARCHIVES_DIR.$old;
deleteFile($path);
}
}
}
break;
}
} while ( $row = $DB->fetch($q) ); }
}
$TMP = null;
$offset = 0;
if ( !$add ) {
$SQL = SQL::newDelete($tableName);
$SQL->addWhereOpr('column_entry_id', $eid);
$SQL->addWhereOpr('column_blog_id', $bid);
$SQL->addWhereOpr('column_attr', 'acms-form', '<>');
if ( $tableName === 'column_rev' ) {
$SQL->addWhereOpr('column_rev_id', $rvid);
$TMP = loadColumn($eid, null, $rvid);
} else {
$TMP = loadColumn($eid);
}
$DB->query($SQL->get(dsn()), 'exec');
$arySort = array();
foreach ( $Column as $data ) {
$arySort[] = $data['sort'];
}
$offset = @min($arySort) - 1;
}
$Res = array();
$temp = '';
if ( !empty($moveArchive) ) {
$temp = 'TEMP/';
}
foreach ( $Column as $key => $data ) {
$id = $data['id'];
$type = $data['type'];
// 特定指定子を含むユニットタイプ
$actualType = $type;
// 特定指定子を除外した、一般名のユニット種別
$type = detectUnitTypeSpecifier($type);
$row = array(
'column_align' => $data['align'],
'column_attr' => $data['attr'],
'column_group' => $data['group'],
'column_size' => $data['size'],
'column_type' => $actualType,
);
if ( 'text' == $type ) {
if ( empty($data['text']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['text'];
if (isset($data['extend_tag'])) {
$row['column_field_3'] = $data['extend_tag'];
}
$tokens = preg_split('@(#|\.)@', $data['tag'], -1, PREG_SPLIT_DELIM_CAPTURE);
$row['column_field_2'] = array_shift($tokens);
$id = '';
$class = '';
while ( $mark = array_shift($tokens) ) {
if ( !$val = array_shift($tokens) ) continue;
if ( '#' == $mark ) {
$id = $val;
} else {
$class = $val;
}
}
$attr = '';
if ( !empty($id) ) $attr .= ' id="' . $id . '"';
if ( !empty($class) ) $attr .= ' class="' . $class . '"';
if ( !empty($attr) ) $row['column_attr'] = $attr;
} else if ( 'table' == $type ) {
if ( empty($data['table']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['table'];
} else if ( 'image' == $type ) {
if ( empty($data['path']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['caption'];
$row['column_field_2'] = $data['path'];
$row['column_field_3'] = $data['link'];
$row['column_field_4'] = $data['alt'];
$row['column_field_6'] = $data['exif'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_5'] = $display_size;
}
if ( $revision || !empty($moveArchive) ) {
$oldAry = explodeUnitData($row['column_field_2']);
$newAry = array();
foreach ( $oldAry as $old ) {
$info = pathinfo($old);
$dirname= empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory($ARCHIVES_DIR_TO.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newOld = $dirname.uniqueString().$ext;
$path = ARCHIVES_DIR.$temp.$old;
$large = otherSizeImagePath($path, 'large');
$tiny = otherSizeImagePath($path, 'tiny');
$square = otherSizeImagePath($path, 'square');
$newPath = $ARCHIVES_DIR_TO.$newOld;
$newLarge = otherSizeImagePath($newPath, 'large');
$newTiny = otherSizeImagePath($newPath, 'tiny');
$newSquare = otherSizeImagePath($newPath, 'square');
copyFile($path, $newPath);
copyFile($large, $newLarge);
copyFile($tiny, $newTiny);
copyFile($square, $newSquare);
$newAry[] = $newOld;
}
$row['column_field_2'] = implodeUnitData($newAry);
$Column[$key]['path'] = implodeUnitData($newAry);
}
} else if ( 'file' == $type ) {
if ( empty($data['path']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['caption'];
$row['column_field_2'] = $data['path'];
if ( $revision || !empty($moveArchive) ) {
$oldAry = explodeUnitData($row['column_field_2']);
$newAry = array();
foreach ( $oldAry as $old ) {
$info = pathinfo($old);
$dirname= empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory($ARCHIVES_DIR_TO.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newOld = $dirname.uniqueString().$ext;
$path = ARCHIVES_DIR.$temp.$old;
$newPath = $ARCHIVES_DIR_TO.$newOld;
copyFile($path, $newPath);
$newAry[] = $newOld;
}
$row['column_field_2'] = implodeUnitData($newAry);
$Column[$key]['path'] = implodeUnitData($newAry);
}
} else if ('osmap' === $type || 'map' === $type) {
if ( 1
and empty($data['msg'])
and empty($data['lat'])
and empty($data['lng'])
and empty($data['zoom'])
) {
$offset++;
continue;
}
$row['column_field_1'] = $data['msg'];
$row['column_field_2'] = $data['lat'];
$row['column_field_3'] = $data['lng'];
$row['column_field_4'] = $data['zoom'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_5'] = $display_size;
}
} else if ( 'yolp' == $type ) {
if ( 1
and empty($data['msg'])
and empty($data['lat'])
and empty($data['lng'])
and empty($data['zoom'])
and empty($data['layer'])
) {
$offset++;
continue;
}
$row['column_field_1'] = $data['msg'];
$row['column_field_2'] = $data['lat'];
$row['column_field_3'] = $data['lng'];
$row['column_field_4'] = $data['zoom'];
$row['column_field_5'] = $data['layer'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_6'] = $display_size;
}
} else if ( 'youtube' == $type ) {
if ( empty($data['youtube_id']) ) {
$offset++;
continue;
}
if ( preg_match(REGEX_VALID_URL, $data['youtube_id']) ) {
$parsed_url = parse_url($data['youtube_id']);
if ( !empty($parsed_url['query']) ) {
$data['youtube_id'] = preg_replace('/v=([\w-_]+).*/', '$1', $parsed_url['query']);
}
}
$row['column_field_2'] = $data['youtube_id'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_3'] = $display_size;
}
} else if ( 'video' == $type ) {
if ( empty($data['video_id']) ) {
$offset++;
continue;
}
if ( preg_match(REGEX_VALID_URL, $data['video_id']) ) {
$vid = null;
if ( HOOK_ENABLE ) {
$Hook = ACMS_Hook::singleton();
$Hook->call('extendsVideoUnit', array($data['video_id'], &$vid));
}
if ( empty($vid) ) {
$parsed_url = parse_url($data['video_id']);
if ( !empty($parsed_url['query']) ) {
$data['video_id'] = preg_replace('/v=([\w-_]+).*/', '$1', $parsed_url['query']);
}
} else {
$data['video_id'] = $vid;
}
}
$row['column_field_2'] = $data['video_id'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_3'] = $display_size;
}
} else if ( 'eximage' == $type ) {
if ( empty($data['normal']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['caption'];
$row['column_field_2'] = $data['normal'];
$row['column_field_3'] = $data['large'];
$row['column_field_4'] = $data['link'];
$row['column_field_5'] = $data['alt'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_6'] = $display_size;
}
} else if ( 'quote' == $type ) {
if ( empty($data['quote_url']) ) {
$offset++;
continue;
}
$row['column_field_6'] = $data['quote_url'];
$urlAry = explodeUnitData($row['column_field_6']);
$oldUrlAry = array();
$old_ = null;
$field1Ary = array();
$field2Ary = array();
$field3Ary = array();
$field4Ary = array();
$field5Ary = array();
$field7Ary = array();
foreach ( $urlAry as $i => $url ) {
if ( preg_match(REGEX_VALID_URL, $url) ) {
$no_change = false;
$parsed_url = parse_url($url);
//--------------
// change data
if ( empty($oldUrlAry) && !empty($data['clid']) && is_array($TMP) ) {
foreach ( $TMP as $old ) {
if ( intval($old['clid']) === intval($data['clid']) ) {
$old_ = $old;
$oldUrlAry = explodeUnitData($old['quote_url']);
break;
}
}
}
$old_url = isset($oldUrlAry[$i]) ? $oldUrlAry[$i] : '';
if ( strcmp($url, $old_url) === 0 ) {
$no_change = true;
$site_nameAry = explodeUnitData($old_['site_name']);
$field1Ary[] = isset($site_nameAry[$i]) ? $site_nameAry[$i] : '';
$authorAry = explodeUnitData($old_['author']);
$field2Ary[] = isset($authorAry[$i]) ? $authorAry[$i] : '';
$titleAry = explodeUnitData($old_['title']);
$field3Ary[] = isset($titleAry[$i]) ? $titleAry[$i] : '';
$descriptionAry = explodeUnitData($old_['description']);
$field4Ary[] = isset($descriptionAry[$i]) ? $descriptionAry[$i] : '';
$imageAry = explodeUnitData($old_['image']);
$field5Ary[] = isset($imageAry[$i]) ? $imageAry[$i] : '';
$htmlAry = explodeUnitData($old_['html']);
$field7Ary[] = isset($htmlAry[$i]) ? $htmlAry[$i] : '';
}
if ( !$no_change ) {
$html = null;
if ( HOOK_ENABLE ) {
$Hook = ACMS_Hook::singleton();
$Hook->call('extendsQuoteUnit', array($url, &$html));
}
if ( !empty($html) ) {
$field7Ary[] = $html;
} else {
//----------
// twitter
if ( 1
&& $parsed_url['host'] === 'twitter.com'
&& count(ACMS_Services_Twitter::loadAcsToken(1)) == 2
) {
preg_match('/status\/([\w]+).*/', $parsed_url['path'], $matches);
if ( !isset($matches[1]) ) continue;
$twid = $matches[1];
$API = ACMS_Services_Twitter::establish(1);
$API->httpRequest('statuses/oembed.json', array(
'id' => $twid,
));
$res = $API->Response->getResponseBody();
$json = json_decode($res);
if ( isset($json->html) ) {
$oembed = $json->html;
$field7Ary[] = $oembed;
}
//------------
// OGP Check
} else if ( $graph = OpenGraph::fetch($url) ) {
$field1Ary[] = $graph->site_name;
$field2Ary[] = $graph->author;
$field3Ary[] = $graph->title;
$field4Ary[] = $graph->description;
$field5Ary[] = $graph->image;
} else {
$field1Ary[] = '';
$field2Ary[] = '';
$field3Ary[] = '';
$field4Ary[] = '';
$field5Ary[] = '';
}
}
}
}
}
$row['column_field_1'] = implodeUnitData($field1Ary);
$row['column_field_2'] = implodeUnitData($field2Ary);
$row['column_field_3'] = implodeUnitData($field3Ary);
$row['column_field_4'] = implodeUnitData($field4Ary);
$row['column_field_5'] = implodeUnitData($field5Ary);
$row['column_field_7'] = implodeUnitData($field7Ary);
} else if ( 'media' == $type ) {
if ( empty($data['media_id']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['media_id'];
$row['column_field_2'] = $data['caption'];
$row['column_field_3'] = $data['alt'];
$row['column_field_4'] = $data['enlarged'];
if ( strpos($row['column_size'], ':') !== false ) {
list($size, $display_size) = preg_split('/:/', $row['column_size']);
$row['column_size'] = $size;
$row['column_field_6'] = $display_size;
}
} else if ( 'break' == $type ) {
if ( empty($data['label']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['label'];
} else if ( 'module' == $type ) {
if ( empty($data['mid']) ) {
$offset++;
continue;
}
$row['column_field_1'] = $data['mid'];
$row['column_field_2'] = $data['tpl'];
} else if ( 'custom' == $type ) {
if ( empty($data['field']) ) {
$offset++;
continue;
}
$row['column_field_6'] = acmsSerialize($data['field']);
if ( $revision || !empty($moveArchive) ) {
$oldAry = explodeUnitData($row['column_field_6']);
foreach ( $oldAry as $fieldString ) {
$Field = acmsUnserialize($fieldString);
$newAry = array();
foreach ( $Field->listFields() as $fd ) {
if ( 1
and !strpos($fd, '@path')
and !strpos($fd, '@tinyPath')
and !strpos($fd, '@largePath')
and !strpos($fd, '@squarePath')
) {
continue;
}
$set = false;
foreach ( $Field->getArray($fd, true) as $i => $old ) {
$info = pathinfo($old);
$dirname = empty($info['dirname']) ? '' : $info['dirname'].'/';
Storage::makeDirectory($ARCHIVES_DIR_TO.$dirname);
$ext = empty($info['extension']) ? '' : '.'.$info['extension'];
$newOld = $dirname.uniqueString().$ext;
$path = ARCHIVES_DIR.$temp.$old;
$newPath = $ARCHIVES_DIR_TO.$newOld;
copyFile($path, $newPath);
if ( !$set ) {
$Field->delete($fd);
$set = true;
}
$Field->add($fd, $newOld);
}
}
$newAry[] = acmsSerialize($Field);
}
$row['column_field_6'] = implodeUnitData($newAry);
$Column[$key] = implodeUnitData($newAry);
}
} else {
$offset++;
continue;
}
if ( !empty($data['clid']) ) {
$clid = intval($data['clid']);
$SQL = SQL::newDelete($tableName);
$SQL->addWhereOpr('column_id', $clid);
if ( $tableName === 'column_rev' ) {
$SQL->addWhereOpr('column_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
} else {
$clid = $DB->query(SQL::nextval('column_id', dsn()), 'seq');
}
$sort = intval($data['sort'] - $offset);
$SQL = SQL::newSelect($tableName);
$SQL->setSelect('column_id');
$SQL->addWhereOpr('column_sort', $sort);
$SQL->addWhereOpr('column_entry_id', intval($eid));
$SQL->addWhereOpr('column_blog_id', intval($bid));
if ( $tableName === 'column_rev' ) {
$SQL->addWhereOpr('column_rev_id', $rvid);
}
if ( $DB->query($SQL->get(dsn()), 'one') ) {
$SQL = SQL::newUpdate($tableName);
$SQL->setUpdate('column_sort', SQL::newOpr('column_sort', 1, '+'));
$SQL->addWhereOpr('column_sort', $sort, '>=');
$SQL->addWhereOpr('column_entry_id', intval($eid));
$SQL->addWhereOpr('column_blog_id', intval($bid));
if ( $tableName === 'column_rev' ) {
$SQL->addWhereOpr('column_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
}
$SQL = SQL::newInsert($tableName);
foreach ( $row as $fd => $val ) {
$SQL->addInsert($fd, strval($val));
}
$SQL->addInsert('column_id', intval($clid));
$SQL->addInsert('column_sort', intval($sort));
$SQL->addInsert('column_entry_id', intval($eid));
$SQL->addInsert('column_blog_id', intval($bid));
if ( $tableName === 'column_rev' ) {
$SQL->addInsert('column_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
if ('image' === $type || 'media' === $type) $Res[$id] = $clid;
}
$this->savedColumn = $Column;
return $Res;
}
/**
* サブカテゴリーを保存
*
* @param int $eid
* @param int $masterCid
* @param string $cids
* @param int $bid
* @param int|null $rvid
*/
public function saveSubCategory($eid, $masterCid, $cids, $bid = BID, $rvid = null)
{
try {
$DB = DB::singleton(dsn());
$table = 'entry_sub_category';
if (!empty($rvid)) {
$table = 'entry_sub_category_rev';
}
$SQL = SQL::newDelete($table);
$SQL->addWhereOpr('entry_sub_category_eid', $eid);
if ( !empty($rvid) ) {
$SQL->addWhereOpr('entry_sub_category_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
$cidAry = $this->getSubCategoryFromString($cids, ',');
foreach ($cidAry as $cid) {
if ($masterCid == $cid) {
continue;
}
$SQL = SQL::newInsert($table);
$SQL->addInsert('entry_sub_category_eid', $eid);
$SQL->addInsert('entry_sub_category_id', $cid);
$SQL->addInsert('entry_sub_category_blog_id', $bid);
if (!empty($rvid)) {
$SQL->addInsert('entry_sub_category_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
}
} catch (\Exception $e) {}
}
/**
* @param string $string
* @param string $delimiter
* @return array
*/
public function getSubCategoryFromString($string, $delimiter = ',')
{
$cidAry = explode($delimiter, $string);
$list = array();
foreach ($cidAry as $item) {
$item = preg_replace('/^[\s　]+|[\s　]+$/u', '', $item);
if ($item !== '') {
$list[] = $item;
}
}
return $list;
}
/**
* 関連エントリーを保存
*
* @param int $eid
* @param array $entryAry
* @param int $rvid
* @param array $typeAry
*
* @return void
*/
public function saveRelatedEntries($eid, $entryAry=array(), $rvid=null, $typeAry=array())
{
$DB = DB::singleton(dsn());
$table = 'relationship';
if ( !empty($rvid) ) {
$table = 'relationship_rev';
}
$SQL = SQL::newDelete($table);
$SQL->addWhereOpr('relation_id', $eid);
if ( !empty($rvid) ) {
$SQL->addWhereOpr('relation_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
$exists = array();
foreach ( $entryAry as $i => $reid ) {
try {
$type = $typeAry[$i];
if ( isset($exists[$type]) && in_array($reid, $exists[$type]) ) continue;
$SQL = SQL::newInsert($table);
$SQL->addInsert('relation_id', $eid);
$SQL->addInsert('relation_eid', $reid);
$SQL->addInsert('relation_order', $i);
if ($typeAry[$i]) {
$SQL->addInsert('relation_type', $type);
}
if ( !empty($rvid) ) {
$SQL->addInsert('relation_rev_id', $rvid);
}
$DB->query($SQL->get(dsn()), 'exec');
$exists[$type] = $reid;
} catch (\Exception $e) {}
}
}
/**
* エントリーのバージョンを保存
*
* @param int $eid
* @param array $entryAry
* @param string $type
* @param string $memo
*
* @return int
*/
public function saveEntryRevision($eid, $entryAry, $type=null, $memo='')
{
if ( !enableRevision(false) ) return false;
$DB = DB();
$rev_id = 0;
//-----------------------------------
// 上書き保存　一時リビジョンは取っておく
if ( empty($type) ) {
// 一時リビジョンを削除
$SQL = SQL::newDelete('entry_rev');
$SQL->addWhereOpr('entry_id', $eid);
$SQL->addWhereOpr('entry_rev_id', 1);
$DB->query($SQL->get(dsn()), 'exec');
$memo = config('revision_temp_memo');
$rev_id = 1;
//----------------------------------------------
// バージョンを残して保存 & 下書きバージョンとして保存
} else if ( $type === 'revision' || $type === 'draft_revision' ) {
// リビジョン番号取得
$SQL = SQL::newSelect('entry_rev');
$SQL->addSelect('entry_rev_id', 'max_rev_id', null, 'MAX');
$SQL->addWhereOpr('entry_id', $eid);
$SQL->addWhereOpr('entry_blog_id', BID);
$rev_id = 2;
if ( $max = $DB->query($SQL->get(dsn()), 'one') ) {
$rev_id = $max + 1;
}
if ( empty($memo) ) {
$memo = sprintf(config('revision_default_memo'), $rev_id);
}
}
// 現在のエントリ情報を抜き出す
$SQL = SQL::newSelect('entry');
$SQL->addWhereOpr('entry_id', $eid);
$SQL->addWhereOpr('entry_blog_id', BID);
$entryData = array();
if ( $row = $DB->query($SQL->get(dsn()), 'row') ) {
foreach ( $row as $key => $val ) {
$entryData[$key] = $val;
}
}
foreach ( $entryAry as $key => $val ) {
$entryData[$key] = $val;
}
// リビジョン作成
$SQL = SQL::newInsert('entry_rev');
$SQL->addInsert('entry_rev_id', $rev_id);
$SQL->addInsert('entry_rev_user_id', SUID);
$SQL->addInsert('entry_rev_datetime', date('Y-m-d H:i:s', REQUEST_TIME));
$SQL->addInsert('entry_rev_memo', $memo);
foreach ( $entryData as $key => $val ) {
if ( !in_array($key, array('entry_current_rev_id', 'entry_last_update_user_id')) ) {
$SQL->addInsert($key, $val);
}
}
$DB->query($SQL->get(dsn()), 'exec');
return $rev_id;
}
/**
* ユニットのバージョンを保存
*
* @param array $Unit
* @param int $eid
* @param int $bid
* @param int $rvid
* @param string $moveArchive
*
* @return array|bool
*/
public function saveUnitRevision($Unit, $eid, $bid, $rvid, $moveArchive=false)
{
if ( !enableRevision(false) ) return false;
$Res = array();
$Res = $this->saveColumn($Unit, $eid, $bid, false, $rvid, $moveArchive);
return $Res;
}
/**
* カスタムフィールドのバージョンを保存
*
* @param int $eid
* @param Field $Field
* @param int $rvid
* @param bool $moveFieldArchive
*
* @return bool
*/
public function saveFieldRevision($eid, $Field, $rvid, $moveFieldArchive=false)
{
if ( !enableRevision(false) ) return false;
Common::saveField('eid', $eid, $Field, null, $rvid, $moveFieldArchive);
return true;
}
/**
* キャッシュ自動削除の情報を更新
*
* @param string $start
* @param string $end
* @param int $bid
* @param int $eid
*
* @return bool
*/
public function updateCacheControl($start, $end, $bid=BID, $eid=EID)
{
if ( 0
|| !$bid
|| !$eid
|| ACMS_RAM::entryStatus($eid) !== 'open'
) {
return false;
}
$DB = DB::singleton(dsn());
$SQL = SQL::newDelete('cache_reserve');
$SQL->addWhereOpr('cache_reserve_datetime', date('Y-m-d H:i:s', REQUEST_TIME), '<', 'OR');
$W = SQL::newWhere();
$W->addWhereOpr('cache_reserve_entry_id', $eid);
$W->addWhereOpr('cache_reserve_blog_id', $bid);
$SQL->addWhere($W, 'OR');
$DB->query($SQL->get(dsn()), 'exec');
if ( $start > date('Y-m-d H:i:s', REQUEST_TIME) ) {
$SQL = SQL::newInsert('cache_reserve');
$SQL->addInsert('cache_reserve_datetime', $start);
$SQL->addInsert('cache_reserve_entry_id', $eid);
$SQL->addInsert('cache_reserve_blog_id', $bid);
$SQL->addInsert('cache_reserve_type', 'start');
$DB->query($SQL->get(dsn()), 'exec');
}
if ( $end > date('Y-m-d H:i:s', REQUEST_TIME) && $end < '3000/12/31 23:59:59' ) {
$SQL = SQL::newInsert('cache_reserve');
$SQL->addInsert('cache_reserve_datetime', $end);
$SQL->addInsert('cache_reserve_entry_id', $eid);
$SQL->addInsert('cache_reserve_blog_id', $bid);
$SQL->addInsert('cache_reserve_type', 'end');
$DB->query($SQL->get(dsn()), 'exec');
}
return true;
}
/**
* キャッシュ自動削除の情報を削除
*
* @param int $eid
*
* @return bool
*/
public function deleteCacheControl($eid=EID)
{
if ( !$eid ) {
return false;
}
$DB = DB::singleton(dsn());
$SQL = SQL::newDelete('cache_reserve');
$SQL->addWhereOpr('cache_reserve_datetime', date('Y-m-d H:i:s', REQUEST_TIME), '<', 'OR');
$SQL->addWhereOpr('cache_reserve_entry_id', $eid, '=', 'OR');
$DB->query($SQL->get(dsn()), 'exec');
return true;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment