forked from HANYANG/HANYANG_MES
307 lines
9.4 KiB
PHP
307 lines
9.4 KiB
PHP
<?php
|
|
$cate_id = "ORDER_REGISTRATION"; //현재 메뉴 ID 필수!!!
|
|
include_once "{$_SERVER['DOCUMENT_ROOT']}/common.inc.php";
|
|
include_once _SVC_INC_PATH_ ."/auth_check.php";
|
|
include_once _HOME_INC_PATH_ ."/ajax_init.php";
|
|
|
|
$_tmp_dir = _UP_PATH_."/temp"; //임시파일저장경로
|
|
$_draw_dir = _UP_PATH_."/draw"; //도면파일저장경로
|
|
$_att_dir = _UP_PATH_."/att"; //첨부파일저장경로
|
|
|
|
if( !file_exists($_tmp_dir) ){
|
|
mkdir($_tmp_dir);
|
|
}
|
|
if( !file_exists($_draw_dir) ){
|
|
mkdir($_draw_dir);
|
|
}
|
|
if( !file_exists($_att_dir) ){
|
|
mkdir($_att_dir);
|
|
}
|
|
|
|
$att_obj = new Sk_Attach(TB_attach_list);
|
|
|
|
if( !_notAuth("R") ){/************ 권한체크*/
|
|
switch( $_REQUEST['mode'] ) {
|
|
case "putTempFile":
|
|
if( isset($_FILES["upfile"]) ){
|
|
$fdata['file_name'] = $_FILES['upfile']['name']?:"";
|
|
$fdata['file_size'] = $_FILES['upfile']['size']?:0;
|
|
$fdata['file_type'] = $_FILES['upfile']['type']?:"";
|
|
$fdata['file_width'] = $_FILES['upfile']['width']?:"";
|
|
$fdata['file_height'] = $_FILES['upfile']['height']?:"";
|
|
|
|
$fdata['tmp_name'] = \Frody\Util\MultiFileUpload::swfFormSaveFile($_FILES["upfile"], $_tmp_dir, $_REQUEST['temp_fid']);
|
|
|
|
$retval['code'] = 1;
|
|
$retval['data'] = $fdata;
|
|
|
|
\Frody\Util\MultiFileUpload::swfCleanDir($_tmp_dir);
|
|
}
|
|
break;
|
|
|
|
|
|
case "getDrawList":
|
|
$sql = "USP_ZB_ATTACH_S10";
|
|
$params = Array(
|
|
"file_id" => $_REQUEST['file_id']?:"",
|
|
"gubun" => "draw",
|
|
"nid" => $_REQUEST['nid'],
|
|
"sid" => $_REQUEST['sid'],
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$row['file_id_old'] = $row['file_id'];
|
|
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "putDraw":
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata'], 1);
|
|
$rst = 1;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
if( $data['_STATUS_'] !== "D" && !$data['file_exp'] ){
|
|
$rst = false;
|
|
$retval['mesg'] = cUtil\Mlang::getText("도면번호를 입력하지 않았습니다."); break;
|
|
}
|
|
}
|
|
|
|
if( $rst ){
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
|
|
$upfiles = array();
|
|
if( $data['tmp_name'] && file_exists($_tmp_dir."/{$data['tmp_name']}") ){
|
|
$upfiles = \Frody\Util\MultiFileUpload::swfFormFileInfo($data['tmp_name'], $_tmp_dir);
|
|
}
|
|
|
|
$params = Array(
|
|
"gubun" => "draw",
|
|
"nid" => $data['nid'],
|
|
"sid" => $data['sid']?:"",
|
|
"file_name" => $upfiles[0]['name'],
|
|
"file_size" => $upfiles[0]['size'],
|
|
"file_type" => $upfiles[0]['type'],
|
|
"file_width" => $upfiles[0]['width'],
|
|
"file_height" => $upfiles[0]['height'],
|
|
"file_exp" => $data['file_exp']?:"",
|
|
);
|
|
|
|
switch( $data['_STATUS_'] ){
|
|
case "I":
|
|
if( $upfiles ){
|
|
$sql = "USP_ZB_ATTACH_I10";
|
|
$data['file_id'] = $baseObj->DB->result($baseObj->DB->exec($sql, $params),0,0);
|
|
|
|
if( $data['file_id'] ){
|
|
\Frody\Util\MultiFileUpload::swfMoveUploadedFile($upfiles[0]['tmp_name'], "{$_draw_dir}/{$data['nid']}_{$data['sid']}_{$data['file_id']}.dat");
|
|
}
|
|
}
|
|
break;
|
|
|
|
case "U":
|
|
$sql = "USP_ZB_ATTACH_U10";
|
|
$params = array_merge(Array(
|
|
"file_id" => $data['file_id'],
|
|
),$params);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
if( $rst && $upfiles ){
|
|
\Frody\Util\MultiFileUpload::swfMoveUploadedFile($upfiles[0]['tmp_name'], "{$_draw_dir}/{$data['nid']}_{$data['sid']}_{$data['file_id']}.dat");
|
|
}
|
|
break;
|
|
|
|
case "D":
|
|
$sql = "USP_ZB_ATTACH_D10";
|
|
$params = Array(
|
|
"file_id" => $data['file_id']?:"",
|
|
"gubun" => "draw",
|
|
"nid" => $data['nid']?:"",
|
|
"sid" => $data['sid']?:"",
|
|
);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
if( $rst ){
|
|
@unlink("{$_draw_dir}/{$data['nid']}_{$data['sid']}_{$data['file_id']}.dat");
|
|
}
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
$retval['code'] = $rst;
|
|
break;
|
|
|
|
case "getAttList":
|
|
$sql = "USP_ZB_ATTACH_S10";
|
|
$retval['data'] = Array();
|
|
if( $_REQUEST['nid'] ){
|
|
$params = Array(
|
|
"file_id" => $_REQUEST['file_id'],
|
|
"gubun" => "att",
|
|
"nid" => $_REQUEST['nid'],
|
|
"sid" => "",
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$row['file_id_old'] = $row['file_id'];
|
|
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "putAtt":
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata'], 1);
|
|
|
|
$rst = 1;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
|
|
$upfiles = array();
|
|
if( $data['tmp_name'] && file_exists($_tmp_dir."/{$data['tmp_name']}") ){
|
|
$upfiles = \Frody\Util\MultiFileUpload::swfFormFileInfo($data['tmp_name'], $_tmp_dir);
|
|
}
|
|
|
|
$params = Array(
|
|
"gubun" => "att",
|
|
"nid" => $data['nid'],
|
|
"sid" => $data['sid']?:"",
|
|
"file_name" => $data['file_name'],
|
|
"file_size" => $data['file_size'],
|
|
"file_type" => $data['file_type'],
|
|
"file_width" => 0,
|
|
"file_height" => 0,
|
|
"file_exp" => $data['file_exp']?:"",
|
|
);
|
|
|
|
switch( $data['_STATUS_'] ){
|
|
case "I":
|
|
$sql = "USP_ZB_ATTACH_I10";
|
|
$data['file_id'] = $baseObj->DB->result($baseObj->DB->exec($sql, $params),0,0);
|
|
$rst = $rst && $data['file_id'];
|
|
if( $rst && $upfiles ){
|
|
\Frody\Util\MultiFileUpload::swfMoveUploadedFile($upfiles[0]['tmp_name'], "{$_att_dir}/{$data['nid']}_{$data['sid']}_{$data['file_id']}.dat");
|
|
}
|
|
break;
|
|
|
|
case "U":
|
|
$sql = "USP_ZB_ATTACH_U10";
|
|
$params = array_merge(Array(
|
|
"file_id" => $data['file_id'],
|
|
),$params);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
if( $rst && $upfiles ){
|
|
\Frody\Util\MultiFileUpload::swfMoveUploadedFile($upfiles[0]['tmp_name'], "{$_att_dir}/{$data['nid']}_{$data['sid']}_{$data['file_id']}.dat");
|
|
}
|
|
break;
|
|
|
|
case "D":
|
|
$sql = "USP_ZB_ATTACH_D10";
|
|
$params = Array(
|
|
"file_id" => $data['file_id']?:"",
|
|
"gubun" => "att",
|
|
"nid" => $data['nid'],
|
|
"sid" => $data['sid'],
|
|
);
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
if( $rst ){
|
|
@unlink("{$_att_dir}/{$data['nid']}_{$data['sid']}_{$data['file_id']}.dat");
|
|
}
|
|
break;
|
|
}
|
|
}
|
|
|
|
$retval['code'] = $rst;
|
|
break;
|
|
/*
|
|
case "getDrawList":
|
|
$sql = "USP_ZB_ATTACH_S10";
|
|
$params = Array(
|
|
"file_id" => $_REQUEST['file_id'],
|
|
"gubun" => "draw",
|
|
"nid" => $_REQUEST['nid'],
|
|
"sid" => $_REQUEST['sid'],
|
|
);
|
|
$rst = $baseObj->DB->exec($sql, $params);
|
|
|
|
$rows = array();
|
|
if( $rst ){
|
|
while( $row = $baseObj->DB->fetch_array($rst) ){
|
|
$row['file_id_old'] = $row['file_id'];
|
|
|
|
$rows[] = $row;
|
|
}
|
|
$retval['data'] = $rows;
|
|
}
|
|
$retval['code'] = 1;
|
|
break;
|
|
|
|
case "putDraw":
|
|
|
|
$_REQUEST['reqdata'] = json_decode($_REQUEST['reqdata'], 1);
|
|
$rst = true;
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
if( $data['_STATUS_'] !== "D" && !$data['file_exp'] ){
|
|
$rst = false;
|
|
$retval['mesg'] = cUtil\Mlang::getText("도면번호를 입력하지 않았습니다."); break;
|
|
}
|
|
}
|
|
|
|
if( $rst ){
|
|
foreach( $_REQUEST['reqdata'] as $data ){
|
|
switch( $data['_STATUS_'] ){
|
|
case "I":
|
|
if( $data['tmp_name'] && file_exists($_tmp_dir."/{$data['tmp_name']}") ){
|
|
$upfile = \Frody\Util\MultiFileUpload::swfFormFileInfo($data['tmp_name'], $_tmp_dir);
|
|
}
|
|
$att_obj->putAttach( $upfile, "draw", $data['nid'], $data['sid'], $data['file_exp'] );
|
|
break;
|
|
|
|
case "U":
|
|
$att_obj->setAttach( $upfile, "draw", $data['nid'], $data['sid'], $data['file_exp'] );
|
|
$sql = "USP_ZB_ATTACH_U10";
|
|
$params = array_merge(Array(
|
|
"file_id" => $data['file_id'],
|
|
),$params);
|
|
break;
|
|
|
|
case "D":
|
|
$sql = "USP_ZB_ATTACH_D10";
|
|
$params = Array(
|
|
"file_id" => $data['file_id'],
|
|
"gubun" => "draw",
|
|
"nid" => $data['nid'],
|
|
"sid" => $data['sid'],
|
|
);
|
|
break;
|
|
|
|
$rst = $rst && $baseObj->DB->exec($sql, $params);
|
|
|
|
}
|
|
}
|
|
}
|
|
break;
|
|
*/
|
|
}
|
|
}
|
|
|
|
|
|
|
|
if( !$_REQUEST['no_echo'] ){
|
|
echo json_encode($retval);
|
|
} |