Aurora 自带的文件下载只能按照框架定义的方式去下载指定目录的文件,这样非常的不方便,不能实现一些自定的下载方式
这里提供一种方式可以按照自己的方式下载自定义的文件列表
BM 文件
bm 查询出文件列表
<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.aurora-framework.org/schema/bm"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select fam.table_name, fam.table_pk_value, fam.record_id, faa.attachment_id, faa.file_name, faa.file_path from prj_cdd_item_doc_ref@cf_app doc, fnd_atm_attachment_multi@cf_app fam, fnd_atm_attachment@cf_app faa where fam.table_name in ('PRJ_CDD_ITEM_CHECK','CSH_PAYMENT_REQ_HD','CON_CONTRACT_ITEM_DETAIL') and fam.table_pk_value = doc.check_id and fam.attachment_id = faa.attachment_id and ( (doc.document_table = 'PRJ_PROJECT' and doc.document_id = ${@PROJECT_ID}) OR ( doc.DOCUMENT_TABLE = 'CON_CONTRACT' and doc.DOCUMENT_ID = (select CON_CONTRACT.CONTRACT_ID from CON_CONTRACT@cf_app where PROJECT_ID = ${@PROJECT_ID} ) ) ) ]]></bm:query-sql> <bm:parameters> <!-- <bm:parameter name="table_pk_value"/> <bm:parameter name="table_name"/> --> <bm:parameter name="PROJECT_ID"/> </bm:parameters> </bm:operation> </bm:operations> <bm:fields> <bm:field name="table_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TABLE_NAME" required="true"/> <bm:field name="table_pk_value" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TABLE_PK_VALUE" required="true"/> <bm:field name="record_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECORD_ID" required="true"/> <bm:field name="attachment_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ATTACHMENT_ID" required="true"/> <bm:field name="file_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FILE_NAME"/> <bm:field name="file_path" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FILE_PATH"/> </bm:fields> </bm:model>
SVC 文件
svc 调用 bm 查询需要下载的文件列表,然后通过文件流将文件转出并打包下载到客户端
<?xml version="1.0" encoding="UTF-8"?> <a:service xmlns:s="aurora.plugin.script" xmlns:a="http://www.aurora-framework.org/application" trace="true"> <a:init-procedure> <s:server-script><![CDATA[ //importPackage(java.util.zip); importPackage(java.io); importPackage(org.apache.tools.zip); /*可以传入参数*/ var logger = $logger("server-script"); function writeFile(zos, fn, fp) { var ze = new ZipEntry(fn); zos.putNextEntry(ze); var fis = new FileInputStream(fp); var b = new java.lang.reflect.Array.newInstance(java.lang.Byte.TYPE, 1024 * 64); var len = -1; while ((len = fis.read(b)) != -1) { zos.write(b, 0, len); } fis.close(); } function getdate() { var now = new Date() y = now.getFullYear() m = now.getMonth() + 1 d = now.getDate() m = m < 10 ? "0" + m : m d = d < 10 ? "0" + d : d return y + "" + m + "" + d } $ctx["__request_type__"] = 'file'; //to indicate this request is not a JSON_REQUEST var resp = $ctx['_instance.javax.servlet.http.HttpServletResponse']; resp.setHeader("Pragma", "No-cache"); resp.setHeader("Cache-Control", "no-cache, must-revalidate"); var date_str = getdate(); var doc_code = $ctx.parameter.PROJECT_ID; var filename = doc_code + '-' + date_str + ".zip" resp.setHeader("Content-disposition", "attachment; filename=" + filename); resp.setDateHeader("Expires", 0); resp.setContentType("application/x-msdownload"); var zos = new ZipOutputStream(resp.getOutputStream()); zos.setEncoding("GBK"); //如果是org.apache.tools.zip需要追加字符集 try { logger.severe("开始查询"); var attachment_batch_dl = $bm('cont.CON9300.lease_atm_batch_dl_plus'); var result = attachment_batch_dl.queryAsMap({PROJECT_ID:$ctx.parameter.PROJECT_ID}); var arr = result.getChildren(); logger.severe("数据:"+result); for (var i = 0;i < arr.length;i++) { var f = arr[i]; if (f.file_path) { writeFile(zos, f.file_name, f.file_path); } } } catch (e) { logger.severe("错误:"+e.message) } zos.close(); ]]></s:server-script> </a:init-procedure> </a:service>
SCREEN 文件
screen 完善调用svc 方法及客户端操作按钮
<?xml version="1.0" encoding="UTF-8"?> <a:screen xmlns:a="http://www.aurora-framework.org/application" customizationEnabled="true" trace="true"> <a:view> <script><![CDATA[ // 影像件材料打包下载 function prj_wfl_download() { <!-- var document_id = ${/parameter/@PROJECT_ID}; --> var url = '${/request/@context_path}/modules/cont/CON930/lease_atm_batch_dl_plus.svc?PROJECT_ID=' + ${/parameter/@PROJECT_ID} ; window.open(url); } ]]></script> <a:dataSets> <a:dataSet id="csh_payment_req_create_ds" autoQuery="true" bindName="sub" fetchAll="true" queryUrl="${/request/@context_path}/autocrud/cont.CON9300.csh_payment_req_ln_query/query?PROJECT_ID=${/parameter/@PROJECT_ID}" selectable="false"> </a:dataSet> </a:dataSets> <a:screenBody> <a:hBox labelWidth="300"> <a:button click="prj_wfl_download" text="影像资料下载"></a:button> </a:hBox> <a:form column="4" labelWidth="100" marginWidth="30" title="CSH502.CSH_PAYMENT_REQ_QUERY"> <a:textField name="rn" bindTarget="csh_payment_req_create_ds" prompt="RN号" readOnly="true"></a:textField> <a:textField name="bp_tenant_name" bindTarget="csh_payment_req_create_ds" prompt="对象名称" readOnly="true"></a:textField> <a:textField name="contract_number" bindTarget="csh_payment_req_create_ds" prompt="合同编号" readOnly="true"></a:textField> <a:textField name="project_number" bindTarget="csh_payment_req_create_ds" prompt="项目号" readOnly="true"></a:textField> <a:textField name="contract_name" bindTarget="csh_payment_req_create_ds" prompt="合同名称" readOnly="true"></a:textField> <a:textField name="project_name" bindTarget="csh_payment_req_create_ds" prompt="项目名称" readOnly="true"></a:textField> <a:textField name="bank_full_name" bindTarget="csh_payment_req_create_ds" prompt="银行" readOnly="true"></a:textField> <a:textField name="bank_branch_name" bindTarget="csh_payment_req_create_ds" prompt="分行" readOnly="true"></a:textField> <a:textField name="bank_account_name" bindTarget="csh_payment_req_create_ds" prompt="银行账户" readOnly="true"></a:textField> <a:textField name="bank_account_num" bindTarget="csh_payment_req_create_ds" prompt="账号" readOnly="true"></a:textField> <a:textField name="lease_times" bindTarget="csh_payment_req_create_ds" prompt="期数" readOnly="true"></a:textField> <a:numberField name="due_amount" bindTarget="csh_payment_req_create_ds" prompt="应付金额" readOnly="true"></a:numberField> <a:textField name="description" bindTarget="csh_payment_req_create_ds" prompt="备注" readOnly="true" showTitle="true" width="280"></a:textField> </a:form> </a:screenBody> </a:view> </a:screen>