泛微OA根据文档的docid查询文档附件存放的路径
注意看下面两个链接
http://127.0.0.1/docs/docs/DocDspExt.jsp?id=40369
http://127.0.0.1/docs/docs/DocDsp.jsp?id=41353
DocDspExt.jsp地址的文档才会把附件存放到/WEAVER/ecology/filesystem目录下。
DocDsp.jsp地址的文档是网页形式的文档,直接插入到数据库,没有附件存放到服务器目录下,是查询不到附件的存放路径的。
例如下面这个链接中40369就是docid。把你要查询的文档的docid写到现在查询语句的docid处即可查询,记住新建查询来查询。
http://127.0.0.1/docs/docs/DocDspExt.jsp?id=40369&versionId=41428&imagefileId=42306&from=&userCategory=0&isFromAccessory=true
SELECT imagefileid, imagefilename, imagefiletype, imagefile, imagefileused, filerealpath, iszip, isencrypt, fileSize, downloads, miniimgpath, imgsize, isFTP, FTPConfigId FROM ImageFile WHERE (imagefileid in (SELECT imagefileid FROM DocImageFile WHERE (docid = 40369)) )
下面这个是DocImageFile表的查询语句
SELECT id, docid, imagefileid, imagefilename, imagefiledesc, imagefilewidth, imagefileheight, imagefielsize, docfiletype, versionId, versionDetail, isextfile, hasUsedTemplet FROM DocImageFile WHERE (id = 41353)
下面这个是DocDetail表的查询语句
SELECT id, maincategory, subcategory, seccategory, doctype, doclangurage, docapprovable, docreplyable, isreply, replydocid, docsubject, doccontent, docsharetype, shareroleid, docpublishtype, itemid, itemmaincategoryid, hrmresid, crmid, projectid, financeid, financerefenceid1, financerefenceid2, doccreaterid, docdepartmentid, doccreatedate, doccreatetime, doclastmoduserid, doclastmoddate, doclastmodtime, docapproveuserid, docapprovedate, docapprovetime, docarchiveuserid, docarchivedate, docarchivetime, docstatus, parentids, assetid, ownerid, keyword, accessorycount, replaydoccount, usertype, docno, cancopy, canremind, countMark, sumMark, sumReadCount, orderable, docExtendName, doccode, docedition, doceditionid, ishistory, maindoc, approvetype, readoptercanprint, docvaliduserid, docvaliddate, docvalidtime, docpubuserid, docpubdate, docpubtime, docreopenuserid, docreopendate, docreopentime, docinvaluserid, docinvaldate, docinvaltime, doccanceluserid, doccanceldate, doccanceltime, selectedpubmouldid, checkOutStatus, checkOutUserId, checkOutUserType, checkOutDate, checkOutTime, hasUsedTemplet, invalidationdate, docCreaterType, docLastModUserType, docApproveUserType, docValidUserType, docInvalUserType, docArchiveUserType, docCancelUserType, docPubUserType, docReopenUserType, ownerType, canPrintedNum, hasPrintedNum, approverequestid, fromworkflow, istop, topdate, toptime, topstartdate, topenddate, invalidRequestId FROM DocDetail WHERE (docsubject = '消防设备维护保养合同')