251 lines
12 KiB
PHP
251 lines
12 KiB
PHP
<?php
|
|
// 첨부파일 리스트 갯수 추출 함수
|
|
function getAttachNum($upload,$mod)
|
|
{
|
|
global $table;
|
|
|
|
$attach = getArrayString($upload);
|
|
$attach_file_num=0;// 첨부파일 수량
|
|
$hidden_file_num=0; // 숨김파일(다운로드 방지) 수량
|
|
foreach($attach['data'] as $val)
|
|
{
|
|
$U = getUidData($table['s_upload'],$val);
|
|
if($U['fileonly']==1) $attach_file_num++; // 전체 첨부파일 수량 증가
|
|
if($U['hidden']==1) $hidden_file_num++; // 숨김파일 수량 증가
|
|
}
|
|
$down_file_num=$attach_file_num-$hidden_file_num; // 다운로드 가능한 첨부파일
|
|
$result=array();
|
|
$result['modify']=$attach_file_num;
|
|
$result['view']=$down_file_num;
|
|
|
|
return $result[$mod];
|
|
}
|
|
|
|
// 첨부파일 리스트 추출 함수 (전체)
|
|
/*
|
|
$parent_data : 해당 포스트의 row 배열
|
|
$mod : upload or modal ==> 실제 업로드 모드 와 모달을 띄워서 본문에 삽입용도로 쓰거나
|
|
*/
|
|
function getAttachFileList($parent_data,$mod,$type)
|
|
{
|
|
global $table;
|
|
|
|
$upload=$parent_data['upload'];
|
|
$featured_img_uid=$parent_data['featured_img'];// 대표이미지 uid
|
|
$featured_video_uid=$parent_data['featured_video'];// 대표비디오 uid
|
|
$featured_audio_uid=$parent_data['featured_audio'];// 대표오디오 uid
|
|
|
|
if($type=='file') $sql='type=1';
|
|
else if($type=='photo') $sql='type=2';
|
|
else if($type=='audio') $sql='type=4';
|
|
else if($type=='video') $sql='type=5';
|
|
else if($type=='doc') $sql='type=6';
|
|
else if($type=='zip') $sql='type=7';
|
|
else $sql='type=1';
|
|
|
|
$attach = getArrayString($upload);
|
|
$uid_q='(';
|
|
foreach($attach['data'] as $uid)
|
|
{
|
|
$uid_q.='uid='.$uid.' or ';
|
|
}
|
|
$uid_q=substr($uid_q,0,-4).')';
|
|
$sql=$sql.' and '.$uid_q;
|
|
$RCD=getDbArray($table['s_upload'],$sql,'*','gid','desc','',1);
|
|
$html='';
|
|
while($R=db_fetch_array($RCD)){
|
|
$U=getUidData($table['s_upload'],$R['uid']);
|
|
|
|
if($type=='file') $html.=getAttachFile($U,$mod,$featured_img_uid);
|
|
else if($type=='photo') $html.=getAttachFile($U,$mod,$featured_img_uid);
|
|
else if($type=='audio') $html.=getAttachAudio($U,$mod,$featured_audio_uid);
|
|
else if($type=='video') $html.=getAttachVideo($U,$mod,$featured_video_uid);
|
|
else $html.=getAttachFile($U,$mod,$featured_img_uid);;
|
|
}
|
|
|
|
return $html;
|
|
}
|
|
|
|
|
|
// 첨부파일 리스트 추출 함수 (낱개)
|
|
function getAttachFile($R,$mod,$featured_img_uid)
|
|
{
|
|
global $g,$r;
|
|
|
|
$fileName=explode('.',$R['name']);
|
|
$file_name=$fileName[0]; // 파일명만 분리
|
|
|
|
if ($R['type']==2) {
|
|
$type='photo';
|
|
} elseif($R['type']==4) {
|
|
$type='audio';
|
|
} elseif($R['type']==5) {
|
|
$type='video';
|
|
} else {
|
|
$type='file';
|
|
}
|
|
|
|
if($type=='photo'){
|
|
$caption=$R['caption']?$R['caption']:$file_name;
|
|
$img_origin=$R['host'].'/'.$R['folder'].'/'.$R['tmpname'];
|
|
$thumb_list=getPreviewResize($R['src'],'q'); // 미리보기 사이즈 조정 (이미지 업로드시 썸네일을 만들 필요 없다.)
|
|
$thumb_modal=getPreviewResize($R['src'],'n'); // 정보수정 모달용 사이즈 조정 (이미지 업로드시 썸네일을 만들 필요 없다.)
|
|
$insert_text='';
|
|
}else if($type=='file'){
|
|
$caption=$R['caption']?$R['caption']:$R['name'];
|
|
$src=$R['host'].$R['folder'].'/'.$R['name'];
|
|
$insert_text='['.$caption.']('.$g['url_root'].'/?r='.$r.'&m=attach&a=download&uid='.$R['uid'].')';
|
|
}
|
|
|
|
|
|
$html='';
|
|
$html.='
|
|
<li class="table-view-cell media" data-id="'.$R['uid'].'" data-role="attach-item">';
|
|
|
|
if($R['type']==2){
|
|
$html.='
|
|
<img class="media-object pull-left" src="'.$thumb_list.'" alt="'.$caption.'" style="width: 42px;height: 42px">
|
|
<div class="media-body">';
|
|
$html.='<span class="badge badge-pill'.($R['uid']==$featured_img_uid?'':' hidden').'" data-role="attachList-label-featured" data-id="'.$R['uid'].'">대표</span> ';
|
|
$html.='<span class="badge badge-pill'.(!$R['hidden']?' hidden':'').'" data-role="attachList-label-hidden-'.$R['uid'].'">숨김</span>';
|
|
$html.=
|
|
$R['name'].'
|
|
<p>'.getSizeFormat($R['size'],2).'</p>
|
|
</div>';
|
|
}else {
|
|
$html.='
|
|
<div class="media-body">
|
|
<i class="fa fa-floppy-o fa-fw"></i>';
|
|
$html.='<span class="badge badge-pill'.(!$R['hidden']?' hidden':'').'" data-role="attachList-label-hidden-'.$R['uid'].'">숨김</span>';
|
|
$html.=$R['name'].'
|
|
<p>'.getSizeFormat($R['size'],2).'</p>
|
|
</div>';
|
|
}
|
|
$html.='
|
|
|
|
<div class="btn-group">';
|
|
if($mod=='upload') $html.='<input type="hidden" name="attachfiles[]" value="['.$R['uid'].']"/>';
|
|
$html.='
|
|
<button type="button" class="btn btn-secondary" data-act="sheet" data-target="#sheet-attach-moreAct" data-id="'.$R['uid'].'" data-showhide="'.(!$R['hidden']?'hide':'show').'" data-insert="'.$insert_text.'" data-title="'.$R['name'].'" data-type="'.$type.'"><span class="fa fa-caret-down"></span></button>';
|
|
if($mod=='upload'){
|
|
$html.='
|
|
<ul class="hidden dropdown-menu dropdown-menu-right" role="menu">';
|
|
if($R['type']==2){
|
|
$html.='
|
|
<li><a class="dropdown-item" href="#" data-attach-act="featured-img" data-type="'.$type.'" data-id="'.$R['uid'].'">대표이미지 설정</a></li>';
|
|
}
|
|
$html.='
|
|
<li><a class="dropdown-item" href="#" data-toggle="modal" data-target="#modal-attach-'.($R['type']==2?'photo':'file').'-meta" data-filename="'.$file_name.'" data-fileext="'.$R['ext'].'" data-caption="'.$caption.'" data-src="'.$thumb_modal.'" data-origin="'.$img_origin.'" data-attach-act="edit" data-id="'.$R['uid'].'" data-type="'.$type.'" data-role="attachList-menu-edit-'.$R['uid'].'">정보수정</a></li>
|
|
<li><a class="dropdown-item" href="#" data-attach-act="showhide" data-role="attachList-menu-showhide-'.$R['uid'].'" data-id="'.$R['uid'].'" data-content="'.($R['hidden']?'show':'hide').'" >'.($R['hidden']?'보이기':'숨기기').'</a></li>
|
|
<li><a class="dropdown-item" href="#" data-attach-act="delete" data-id="'.$R['uid'].'" data-role="attachList-menu-delete-'.$R['uid'].'" data-featured="" data-type="'.$type.'">삭제</a></li>
|
|
</ul>';
|
|
}
|
|
$html.='
|
|
</div>
|
|
|
|
</li>';
|
|
|
|
return $html;
|
|
}
|
|
|
|
// 오디오파일 리스트 추출 함수 (낱개)
|
|
function getAttachAudio($R,$mod,$featured_audio_uid)
|
|
{
|
|
global $g,$r;
|
|
|
|
$fileName=explode('.',$R['name']);
|
|
$file_name=$fileName[0]; // 파일명만 분리
|
|
$caption=$R['caption']?$R['caption']:$file_name;
|
|
|
|
$html='';
|
|
$html.='
|
|
<div class="card bg-white" data-id="'.$R['uid'].'" data-role="attach-item">
|
|
<audio controls class="card-img-top w-100"><source src="'.$R['host'].'/'.$R['folder'].'/'.$R['tmpname'].'" type="audio/mp3"></audio>
|
|
<div class="card-block">';
|
|
if($mod=='upload') $html.='<input type="hidden" name="attachfiles[]" value="['.$R['uid'].']"/>';
|
|
$html.='
|
|
<button type="button" class="btn btn-secondary btn-block mb-2" data-attach-act="delete" data-id="'.$R['uid'].'" data-role="attachList-menu-delete-'.$R['uid'].'" data-featured="" data-type="audio">삭제</button>';
|
|
if($mod=='upload'){
|
|
$html.='
|
|
<a class="btn btn-secondary" href="#" data-attach-act="featured-audio" data-type="'.$type.'" data-id="'.$R['uid'].'">대표오디오 설정</a></li>';
|
|
|
|
$html.='
|
|
<a class="btn btn-secondary" href="#" data-toggle="modal" data-target="#modal-attach-file-meta" data-filename="'.$file_name.'" data-fileext="'.$R['ext'].'" data-caption="'.$caption.'" data-src="'.$thumb_modal.'" data-origin="'.$img_origin.'" data-attach-act="edit" data-id="'.$R['uid'].'" data-type="audio" data-role="attachList-menu-edit-'.$R['uid'].'">정보수정</a>
|
|
<a class="btn btn-secondary" href="#" data-attach-act="showhide" data-role="attachList-menu-showhide-'.$R['uid'].'" data-id="'.$R['uid'].'" data-content="'.($R['hidden']?'show':'hide').'" >'.($R['hidden']?'보이기':'숨기기').'</a>
|
|
';
|
|
}
|
|
$html.='<h6 class="card-title mt-4"><span data-role="attachList-list-name-'.$R['uid'].'" >'.$R['name'].'</span>';
|
|
$html.='<span class="badge badge-default'.($R['uid']==$featured_audio_uid?'':' hidden-xs-up').'" data-role="attachList-label-featured" data-id="'.$R['uid'].'">대표</span> ';
|
|
$html.='<span class="badge badge-default'.(!$R['hidden']?' hidden-xs-up':'').'" data-role="attachList-label-hidden-'.$R['uid'].'">숨김</span>';
|
|
$html.='
|
|
<span class="badge badge-default">'.getSizeFormat($R['size'],2).'</span></h6><p></p></div></div>';
|
|
return $html;
|
|
}
|
|
|
|
|
|
// 비디오파일 리스트 추출 함수 (낱개)
|
|
function getAttachVideo($R,$mod,$featured_video_uid)
|
|
{
|
|
global $g,$r;
|
|
|
|
$fileName=explode('.',$R['name']);
|
|
$file_name=$fileName[0]; // 파일명만 분리
|
|
$caption=$R['caption']?$R['caption']:$file_name;
|
|
|
|
$html='';
|
|
$html.='
|
|
<div class="card bg-white" data-id="'.$R['uid'].'" data-role="attach-item">';
|
|
|
|
$html.='
|
|
<div class="card-img-top embed-responsive embed-responsive-4by3"><video controls class="embed-responsive-item" controls preload="none"><source src="'.$R['host'].'/'.$R['folder'].'/'.$R['tmpname'].'" type="video/'.$R['ext'].'"></video></div>';
|
|
$html.='<div class="card-block"><h5 class="card-title" data-role="attachList-list-name-'.$R['uid'].'" >'.$R['name'];
|
|
|
|
$html.='<span class="badge badge-default'.($R['uid']==$featured_video_uid?'':' hidden-xs-up').'" data-role="attachList-label-featured" data-id="'.$R['uid'].'">대표</span> ';
|
|
$html.='<span class="badge badge-default'.(!$R['hidden']?' hidden-xs-up':'').'" data-role="attachList-label-hidden-'.$R['uid'].'">숨김</span></h5 >';
|
|
|
|
$html.='
|
|
<p class="card-text text-muted">'.getSizeFormat($R['size'],2).'</p>';
|
|
|
|
if($mod=='upload'){ $html.=' <input type="hidden" name="attachfiles[]" value="['.$R['uid'].']"/>
|
|
<button type="button" class="btn btn-secondary btn-block btn-sm" data-attach-act="delete" data-id="'.$R['uid'].'" data-role="attachList-menu-delete-'.$R['uid'].'" data-featured="" data-type="video">삭제</button></li>
|
|
<div class="btn-group btn-group-sm hidden" role="group">
|
|
<button type="button" class="btn btn-secondary" data-attach-act="delete" data-id="'.$R['uid'].'" data-role="attachList-menu-delete-'.$R['uid'].'" data-featured="" data-type="video">삭제</button></li>
|
|
<button type="button" class="btn btn-secondary" data-attach-act="featured-video" data-type="'.$type.'" data-id="'.$R['uid'].'">대표 비디오 설정</button></li>
|
|
<button type="button" class="btn btn-secondary" data-toggle="modal" data-target="#modal-attach-file-meta" data-filename="'.$file_name.'" data-fileext="'.$R['ext'].'" data-caption="'.$caption.'" data-src="'.$thumb_modal.'" data-origin="'.$img_origin.'" data-attach-act="edit" data-id="'.$R['uid'].'" data-type="video" data-role="attachList-menu-edit-'.$R['uid'].'">정보수정</button>
|
|
<button type="button" class="btn btn-secondary" data-attach-act="showhide" data-role="attachList-menu-showhide-'.$R['uid'].'" data-id="'.$R['uid'].'" data-content="'.($R['hidden']?'show':'hide').'" >'.($R['hidden']?'보이기':'숨기기').'</button>
|
|
</div>
|
|
</div>
|
|
';}
|
|
|
|
$html.='</div>';
|
|
|
|
return $html;
|
|
}
|
|
|
|
|
|
|
|
// 본문삽입 이미지 uid 얻기 함수
|
|
function getInsertImgUid($upload)
|
|
{
|
|
global $table;
|
|
|
|
$u_arr = getArrayString($upload);
|
|
$Insert_arr=array();
|
|
$i=0;
|
|
foreach ($u_arr['data'] as $val) {
|
|
$U=getUidData($table['s_upload'],$val);
|
|
if(!$U['fileonly']) $Insert_arr[$i]=$val;
|
|
$i++;
|
|
}
|
|
$upfiles='';
|
|
// 중괄로로 재조립
|
|
foreach ($Insert_arr as $uid) {
|
|
$upfiles.='['.$uid.']';
|
|
}
|
|
|
|
return $upfiles;
|
|
}
|
|
|
|
|
|
?>
|