A-A+
通达oa-删除附件
前端:
function delete_attach(ATTACHMENT_ID,ATTACHMENT_NAME)
{
var msg = sprintf("<?=_("确定要删除文件 '%s' 吗?")?>", ATTACHMENT_NAME);
if(window.confirm(msg))
{
var id_ztjy = <?php echo $id_ztjy;?>;
var action = 'delete_file';
var data = {
action: action,
id_ztjy:id_ztjy,
ATTACHMENT_ID: ATTACHMENT_ID,
ATTACHMENT_NAME: ATTACHMENT_NAME
};
$.ajax({
url: '../Controller/Controller.php',
type: 'post',
data: data,
dataType: 'json',
success: function () {
window.location.reload();
}
});
}
}
后端:
case 'delete_file':
//删除附件
$ATTACHMENT_ID = $_REQUEST['ATTACHMENT_ID'];
$ATTACHMENT_NAME = $_REQUEST['ATTACHMENT_NAME'];
//删除记录中的附件
$id_ztjy = $_REQUEST['id_ztjy'];
$jy_data = $database->get('dj_ztjy',['ATTACHMENT_ID','ATTACHMENT_NAME'],['id_ztjy'=>$id_ztjy]);
if($jy_data['ATTACHMENT_NAME']!="")
{
delete_attach($ATTACHMENT_ID,$ATTACHMENT_NAME);
$ATTACHMENT_ID_OLD=$jy_data["ATTACHMENT_ID"];
$ATTACHMENT_NAME_OLD=$jy_data["ATTACHMENT_NAME"];
$ATTACHMENT_ID_ARRAY=explode(",",$ATTACHMENT_ID_OLD);
$ATTACHMENT_NAME_ARRAY=explode("*",$ATTACHMENT_NAME_OLD);
$ARRAY_COUNT=sizeof($ATTACHMENT_ID_ARRAY);
for($I=0;$I<$ARRAY_COUNT;$I++)
{
if($ATTACHMENT_ID_ARRAY[$I]==$ATTACHMENT_ID||$ATTACHMENT_ID_ARRAY[$I]=="")
continue;
$ATTACHMENT_ID1.=$ATTACHMENT_ID_ARRAY[$I].",";
$ATTACHMENT_NAME1.=$ATTACHMENT_NAME_ARRAY[$I]."*";
}
$ATTACHMENT_ID=$ATTACHMENT_ID1;
$ATTACHMENT_NAME=$ATTACHMENT_NAME1;
$query="update dj_ztjy set ATTACHMENT_ID='$ATTACHMENT_ID',ATTACHMENT_NAME='$ATTACHMENT_NAME' where id_ztjy='$id_ztjy'";
exequery(TD::conn(),$query);
}
break;