門戶網(wǎng)站數(shù)據(jù)庫(kù)設(shè)計(jì)

1、門戶網(wǎng)站數(shù)據(jù)庫(kù)設(shè)計(jì)一、系統(tǒng)規(guī)則注意：在書寫時(shí)大括號(hào)之間變量不能有空格時(shí)間常規(guī)顯示格式：日期統(tǒng)一顯示格式：YYYY-MM-DD日期時(shí)間統(tǒng)一顯示格式：YYYY-MM-DDHH:NN:SS時(shí)間統(tǒng)一顯示格式：HH:NN:SS系統(tǒng)變量：CurrDate）表示：系統(tǒng)當(dāng)前日期；CurrDateTime）表示：系統(tǒng)當(dāng)前日期時(shí)間；CurrTime）表示：系統(tǒng)當(dāng)前時(shí)間；CurrYear）表示：系統(tǒng)當(dāng)前年；CurrMonth）表示：系統(tǒng)當(dāng)前月；CurrDay）表示：系統(tǒng)當(dāng)前天；CurrHour）表示：系統(tǒng)當(dāng)前小時(shí)；CurrMinute）表示：系統(tǒng)當(dāng)前分鐘；CurrSecond）表示：系統(tǒng)當(dāng)前秒；CurrUserld

2、）表示：當(dāng)前用戶idCurrUserName）表示：當(dāng)前用戶姓名CurrUserDeptld）表示：當(dāng)前用戶部門idCurrUserDeptName）表示：當(dāng)前用戶部門名稱CurrUserSubCompanyld）表示：當(dāng)前用戶所在分部IdCurrUserSubCompanyName）表示：當(dāng)前用戶所在分部名稱CurrUserSubCompanyCode）表示：當(dāng)前用戶所在分部的機(jī)構(gòu)編碼CurrOnlineUserld）表示：當(dāng)前系統(tǒng)在線人員id,如多人則用分割對(duì)應(yīng)commonCperties文件各種變量（屬于系統(tǒng)級(jí)變量）：SysCfgXWFWorkplan）:工作計(jì)劃；對(duì)應(yīng)

3、項(xiàng)workflow_workplanSysCfgXWFBumfin）:收文流程id;對(duì)應(yīng)項(xiàng)workflow_workplanSysCfgXWFBumfout）:發(fā)文流程id;對(duì)應(yīng)項(xiàng)workflow_workplanSysCfgDocAfficheld）:通知公告SysCfgDocNewDynamicld）:新聞動(dòng)態(tài)SysCfgHrmCompanyLeaderLevel）:聯(lián)社領(lǐng)導(dǎo)層（理事長(zhǎng)、監(jiān)事長(zhǎng)、主任、副主任）SysCfgHrmDeptAndSameOrganLeaderLevel）:部門領(lǐng)導(dǎo)層（含信用社領(lǐng)導(dǎo)層）SysCfgRoleCptManager）:對(duì)應(yīng)項(xiàng)workflow_workpl

4、anSysCfgRoleMeetingManager）:對(duì)應(yīng)項(xiàng)workflow_workplanSysCfgRoleDocManager）:對(duì)應(yīng)項(xiàng)workflow_workplan首頁(yè)提醒變量（僅限制在首頁(yè)提醒模塊）PerRowMainld：每條記錄的主鍵值。PerRowMainSubject：每條記錄的主題。PerRowMainDateTime:每條記錄的日期時(shí)間；顯示具體的日期時(shí)間需要由用戶決定。ThisModuleRows:獲得本模塊設(shè)置的"lngrows”字段值PerRowMainReadFlag:每條記錄“閱讀"的標(biāo)記。PageParamenter1：獲得本模塊設(shè)

5、置的“PageParamenter2：獲得本模塊設(shè)置的“PageParamenter3：獲得本模塊設(shè)置的“PageParamenter4：獲得本模塊設(shè)置的“l(fā)ngrows"字段值。（保留字暫不實(shí)現(xiàn)）lngrows"字段值。（保留字暫不實(shí)現(xiàn)）lngrows"字段值。（保留字暫不實(shí)現(xiàn)）lngrows"字段值。（保留字暫不實(shí)現(xiàn)）二、系統(tǒng)模塊表SysMainModule首頁(yè)提醒信息表lngmoduleid:主鍵strmodulename：名稱strurl：本模塊顯示的信息內(nèi)容由本地址決定，是對(duì)復(fù)雜顯示效果的擴(kuò)展。blnfixed:是否固定顯示；1是固定，0是可以

6、自定義；lngorder：顯示順序lngrows:顯示條數(shù)width:顯示寬度height:顯示高度layoutColumn:所屬框架moreurl:更多連接titlelength:標(biāo)題長(zhǎng)度（單位：字?jǐn)?shù)）strsql:被解析的sql;本sql帶有模塊內(nèi)容顯示的各項(xiàng)信息。newShowIconRule:顯示news圖標(biāo)規(guī)則；空表示不顯示圖標(biāo)；系統(tǒng)判斷方法是查詢SQL是否有值，若結(jié)果集為空則顯示圖標(biāo)說(shuō)明有最新信息,否則不顯示。字段為空不做聲音提醒。sql示例：selectPerRowMainIdfromtablenamewhereid=PerRowMainIdselectPerRowMainDat

7、efromtablenamewhereCurrDate=PerRowMainDatesoundRemindRule:聲音提醒規(guī)則；空表示不提醒；系統(tǒng)判斷方法是查詢SQL是否有值，若集合為空則聲音提醒，否則不提醒。字段為空不做聲音提醒。sql示例：selectPerRowMainldfromtablenamewhereid=PerRowMainldselectPerRowMainDatefromtablenamewhereCurrDate=PerRowMainDatemoduleTotalSQL：信息統(tǒng)計(jì)sql,如果存在多個(gè)統(tǒng)計(jì)sql請(qǐng)用“分割開(kāi)；如：待辦疣程（待辦共1口，辦結(jié)共5）待辦共10,

8、辦結(jié)共5表示方法是：待辦共Aselectcount（*）fromtablename|辦結(jié)共Aselectcount（*）fromtablenamewhereread='1andhrmid=CurrUserIdpageld:所屬頁(yè)面id（是SysMainPage外鍵）newlcon：圖標(biāo)顯示規(guī)則（1結(jié)果集有值顯示，2結(jié)果集空時(shí)顯示）。soundRemind:聲音提醒規(guī)則（1結(jié)果集有彳1提醒，2結(jié)果集空值提醒）判斷方式：A）如果strurl不為空程序獲得這個(gè)地址對(duì)應(yīng)界面的結(jié)果作為模塊要顯示的內(nèi)容。B）否則如果為空則執(zhí)行strsql字段值，如果這個(gè)字段同時(shí)為空則表示此模塊為無(wú)效模塊。C）st

9、rsql字段不為空，則開(kāi)始解析sql;解析原則先解析后填充值。注意：本首頁(yè)提醒模塊中定義的變量支持“系統(tǒng)規(guī)則“。SysMainSetting自定義提醒信息表lngsettingid:自定義提醒表主鍵lngmoduleid:首頁(yè)提醒表的外鍵lnghrmid:相關(guān)人員lngrows:顯示行數(shù)width:模塊顯示寬度height:模塊顯示高度layoutColumn:所屬框架titlelength:主題顯示長(zhǎng)度（單位：字?jǐn)?shù)）lngorder：順序SysMainPage自定義頁(yè)面表id:主鍵name：頁(yè)面名稱；lngorder：顯示順序pageurl：轉(zhuǎn)向指定頁(yè)面的鏈接地址和傳參；fixed：是否強(qiáng)制

10、性顯示；1是強(qiáng)制顯示，0是可以自定義urltype:數(shù)據(jù)顯示類型；1是來(lái)自頁(yè)面模塊，2來(lái)自外部地址，3來(lái)自知識(shí)庫(kù)某文檔內(nèi)容。docid:相關(guān)文檔idSysMainRelation頁(yè)面關(guān)系表mainid:模塊id;hrmid:人員idflag:標(biāo)記：(0表示mainid是SysMainPage外鍵，1表示mainid是SysMainModule外鍵)1權(quán)限信息名稱所屬權(quán)限組權(quán)限編碼描述首頁(yè)設(shè)置首頁(yè)設(shè)置一系統(tǒng)管理員ModulePage:Manage擁有此權(quán)限者可以增刪改本模塊信息模塊設(shè)置模塊設(shè)置一系統(tǒng)管理員Module:Manage擁有此權(quán)限者可以增刪改本模塊信息2特殊模塊配置信

11、息文檔參數(shù)：docsubject：主題doccontent：文檔內(nèi)容containreply:maincategory:一級(jí)目錄subcategory：二級(jí)目錄seccategory：三級(jí)目錄docid:文檔iddoccreaterid：文檔創(chuàng)建者departmentiddoclanguragehrmresidcrmidprojectedfinanceiddocpublishtypedocstatuskeyword:ownerid:創(chuàng)建者isreply:是否有回復(fù)docno：文檔編號(hào)doccreatedatefrom-doccreatedateto:創(chuàng)建文檔開(kāi)始時(shí)間與U結(jié)束時(shí)間通知公告頁(yè)面地址

12、/docs/docs/DocDsp.jsp?id=PerRowMainId更多鏈接/docs/docs/DocDsp.jsp?id=PerRowMainId內(nèi)容顯示規(guī)則selecttop5idasPerRowMainId,doclastmoddateasPerRowMainDateTime,docsubjectasPerRowMainSubjectfromDocDetailt1,DocShareDetailt2wheret1.replydocid=0andt1.docstatusin('1','2','5')andt1.seccategoryin

13、(SysCfgDocAfficheId)andt1.id=t2.docidandt2.userid=CurrUserIdandt2.usertype=1orderbydoclastmoddatedesc,doclastmodtimedescNews規(guī)貝Uselecttop1idfromdocdetaillogwheredocid=PerRowMainIdandoperateUserid=CurrUserId聲音提醒規(guī)則selecttop1idfromdocdetaillogwheredocid=PerRowMainIdandoperateUserid=CurrUserId信息統(tǒng)計(jì)規(guī)則共：Ase

14、lectcount(distinctid)fromDocDetailast1,DocShareDetailast2wheredocstatusin('1','2','5')andseccategoryin(SysCfgDocAfficheId)andt1.id=t2.docidandt2.userid=CurrUserIdandt2.usertype=1待辦流程頁(yè)面地址Zworkflow/request/ManageRequest.jsp?requestid=PerRowMainId更多鏈接/workflow/search/WFSearchRes

15、ult.jsp?start=1&perpage=10內(nèi)容顯示規(guī)則selectdistincttopThisModuleRowst1.requestidasPerRowMainId,createdateasPerRowMainDateTime,requestnameasPerRowMainSubject,t1.createtime,t1.requestlevelfromworkflow_requestbaset1,workflow_currentoperatort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.use

16、rtype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidnotin(SysCfgXWFBumfin,SysCfgXWFBumfout)orderbyt1.createdatedesc,t1.requestleveldesc,t1.createtimedescNews規(guī)貝Uselectt1.requestidfromworkflow_requestbaset1,workflow_currentoperatort2wheret1.requ

17、estid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidnotin(SysCfgXWFBumfin,SysCfgXWFBumfout)andcreatedate='CurrDate'聲音提醒規(guī)則selectt1.requestidfromworkflow_requestbaset1,workflow_currentope

18、ratort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidnotin(SysCfgXWFBumfin,SysCfgXWFBumfout)andcreatedate='CurrDate'信息統(tǒng)計(jì)規(guī)則待辦共：Aselectcount(distinctt1.requestid)fromwor

19、kflow_requestbaset1,workflow_currentoperatort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidnotin(SysCfgXWFBumfin,SysCfgXWFBumfout)|,辦結(jié)共：Aselectcount(distinctt1.requestid)from

20、workflow_requestbaset1,workflow_currentoperatort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype=3andt1.workflowidnotin(SysCfgXWFBumfin,SysCfgXWFBumfout)待辦公文頁(yè)面地址/workflow/request/ManageRequest.jsp?requ

21、estid=PerRowMainId更多鏈接/workflow/search/WFSearchResult.jsp?start=1&perpage=10內(nèi)容顯示規(guī)則selectdistincttopThisModuleRowst1.requestidasPerRowMainId,createdateasPerRowMainDateTime,requestnameasPerRowMainSubject,t1.requestlevel,createtimefromworkflow_requestbaset1,workflow_currentoperatort2wheret1.request

22、id=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidin(SysCfgXWFBumfin,SysCfgXWFBumfout)orderbycreatedatedesc,t1.requestleveldesc,createtimedescNews規(guī)貝Uselectdistincttop1t1.requestidfromworkflow_re

23、questbaset1,workflow_currentoperatort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidin(SysCfgXWFBumfin,SysCfgXWFBumfout)andcreatedate='CurrDate'聲音提醒規(guī)則信息統(tǒng)計(jì)規(guī)則待辦共：Aselect

24、count(distinctt1.requestid)fromworkflow_requestbaset1,workflow_currentoperatort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype<>3andt1.workflowidin(SysCfgXWFBumfin,SysCfgXWFBumfout)|,辦結(jié)共Aselectc

25、ount(distinctt1.requestid)fromworkflow_requestbaset1,workflow_currentoperatort2wheret1.requestid=t2.requestidandt2.userid=CurrUserIdandt2.usertype=0andt2.isremarkin('0','1')andt1.deleted=0andt1.currentnodetype=3andt1.workflowidin(SysCfgXWFBumfin,SysCfgXWFBumfout)最新文檔頁(yè)面地址/docs/docs/Do

26、cDsp.jsp?id=PerRowMainId更多鏈接/docs/search/DocSearchTemp.jsp?list=all內(nèi)容顯示規(guī)則selecttop5idasPerRowMainId,docsubjectasPerRowMainSubject,doccreatedateasPerRowMainDateTimefromDocDetailt1,DocShareDetailt2wheret1.replydocid=0andt1.docstatusin('1','2','5')andt1.id=t2.docidandt2.userid=C

27、urrUserIdandseccategorynotin(SysCfgDocAfficheId)andt2.usertype=1orderbydoccreatedatedesc,doccreatetimedescNews規(guī)貝Uselecttop1idfromdocdetaillogwheredocid=PerRowMainIdandoperateUserid=CurrUserId聲音提醒規(guī)則selecttop1idfromdocdetaillogwheredocid=PerRowMainIdandoperateUserid=CurrUserId信息統(tǒng)計(jì)規(guī)則共：Aselectcount(dist

28、inctid)fromDocDetailast1,DocShareDetailast2wheredocstatusin('1','2','5')andt1.id=t2.docidandt2.userid=CurrUserIdandt2.usertype=1未讀郵件頁(yè)面地址Zfunction/Email.do?method=showEmail&id=PerRowMainId更多鏈接/function/Email.do?method=showInBoxlist內(nèi)容顯示規(guī)則selecttopThisModuleRowsidasPerRowMai

29、nId,senddateasPerRowMainDateTime,titleasPerRowMainSubjectfromEMailListswherefolderid='1'andstatus='0'andhrmid=CurrUserIdorderbyiddescNews規(guī)貝Uselecttop1titlefromEMailListswherefolderid='1'andstatus='0'andhrmid=CurrUserId聲音提醒規(guī)則selecttop1titlefromEMailListswherefolderid=&

30、#39;1'andstatus='0'andhrmid=CurrUserId信息統(tǒng)計(jì)規(guī)則未讀共：Aselectcount(id)fromEMailListswherefolderid='1'andstatus='0'andhrmid=CurrUserId|,已讀共：Aselectcount(id)fromEMailListswherefolderid='1'andstatus='1'andhrmid=CurrUserId最新會(huì)議頁(yè)面地址Zmeeting/data/ViewMeeting.jsp?meetin

31、gid=PerRowMainId更多鏈接Zmeeting/search/SearchResult.jsp?start=1&perpage=15內(nèi)容顯示規(guī)則selecta.idasPerRowMainId,asPerRowMainSubject,a.begindate+'('+a.begintime+'-'+a.endtime+')'asPerRowMainDateTimefromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3'an

32、db.memberid=CurrUserIdorderbyPerRowMainDateTimedescNews規(guī)貝Uselecttop1a.idfromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3'andb.memberid=CurrUserIdanda.createdate='CurrDate'聲音提醒規(guī)則信息統(tǒng)計(jì)規(guī)則共：Aselectcount(a.id)fromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isappr

33、oved='3'andb.memberid=CurrUserId最新會(huì)議頁(yè)面地址/meeting/data/ViewMeeting.jsp?meetingid=PerRowMainId更多鏈接/meeting/search/SearchResult.jsp?start=1&perpage=15內(nèi)容顯示規(guī)則selecta.idasPerRowMainId,asPerRowMainSubject,a.begindate+'('+a.begintime+'-'+a.endtime+')'asPerRowMainDat

34、eTimefromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3'andb.memberid=CurrUserIdorderbyPerRowMainDateTimedescNews規(guī)貝Uselecttop1a.idfromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3'andb.memberid=CurrUserIdanda.createdate='CurrDate'聲音提醒規(guī)則信息統(tǒng)

35、計(jì)規(guī)則共：Aselectcount(a.id)fromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3'andb.memberid=CurrUserId我的項(xiàng)目（任務(wù)）頁(yè)面地址/proj/data/ViewProject.jsp?ProjID=PerRowMainId更多鏈接/proj/search/SearchResult.jsp?start=1&perpage=15內(nèi)容顯示規(guī)則selectdistincttopThisModuleRowst1.idasPerRowMainId,t1.na

36、measPerRowMainSubject,t1.createdateasPerRowMainDateTimefromPrj_ProjectInfot1,PrjShareDetailt2wheret1.id=t2.prjidandt2.usertype=1andt2.userid=CurrUserIdorderbyt1.iddescNews規(guī)貝Uselectdistincttopt1.idfromPrj_ProjectInfot1,PrjShareDetailt2wheret1.id=t2.prjidandt2.usertype=1andt2.userid=CurrUserIdandt1.cr

37、eatedate='CurrDate'聲音提醒規(guī)則信息統(tǒng)計(jì)規(guī)則共:Aselectcount(distincttl.id)fromPrj_ProjectInfot1,PrjShareDetailt2wheretl.id=t2.prjidandt2.usertype=1andt2.userid=CurrUserId我的設(shè)備頁(yè)面地址Zcpt/capital/CptCapital.jsp?id=PerRowMainId更多鏈接/cpt/search/CptSearchResult.jsp?type=search&isdata=2內(nèi)容顯示規(guī)則selecttopThisModule

38、Rowstl.idasPerRowMainId,asPerRowMainSubject,t1.createdateasPerRowMainDateTimefromcptCapitalt1,cptShareDetailt2whereisdata='2'andt1.id=t2.cptidandt2.userid=CurrUserIdandt2.usertype=1andt1.stateidNOTIN(5,-7)orderbyt1.iddescNews規(guī)貝U聲音提醒規(guī)則信息統(tǒng)計(jì)規(guī)則我的日程頁(yè)面地址/function/quickplan/QuickPlanEdit.jsp

39、?id=PerRowMainId更多鏈接/function/quickplan/QuickPlanSearchResult.jsp?resourceid=CurrUserId&type=result內(nèi)容顯示規(guī)則selecttopThisModuleRowsidasPerRowMainId,subjectasPerRowMainSubject,begindateasPerRowMainDateTimefromQuickPlanwhereresourceid=CurrUserIdorderbyiddescNews規(guī)貝U聲音提醒規(guī)則信息統(tǒng)計(jì)規(guī)則我的客戶頁(yè)面地址/CRM/data/ViewCu

40、stomer.jsp?CustomerID=PerRowMainId更多鏈接/search/SearchResult.jsp?pagenum=1&perpage=10內(nèi)容顯示規(guī)則News規(guī)貝U聲音提醒規(guī)則信息統(tǒng)計(jì)規(guī)則部門文檔頁(yè)面地址/docs/docs/DocDsp.jsp?id=PerRowMainId更多鏈接/docs/search/DocSearchTemp.jsp?list=all&subcategory=156內(nèi)容顯示規(guī)則按所屬部門查詢selectdistincttopThisModuleRowsidasPerRowMainId,docsubjectasPerRowM

41、ainSubject,doccreatedateasPerRowMainDateTime,doccreatetimefromDocDetailt1,DocShareDetailt2wheret1.replydocid=0andt1.docstatusin('1','2','5')andt1.id=t2.docidandt2.useridin(selectidfromhrmresourcewheredepartmentid=CurrUserDeptId)andsubcategory=156andt2.usertype=1orderbydoccrea

42、tedatedesc,doccreatetimedesc按分部查詢selectdistincttopThisModuleRowsidasPerRowMainId,docsubjectasPerRowMainSubject,doccreatedateasPerRowMainDateTime,doccreatetimefromDocDetailt1,DocShareDetailt2wheret1.replydocid=0andt1.docstatusin('1','2','5')andt1.id=t2.docidandt2.useridin(sele

43、ctidfromhrmresourcewheresubcompanyid1=CurrUserSubcCompanyId)andsubcategory=156andt2.usertype=1orderbydoccreatedatedesc,doccreatetimedescNews規(guī)貝Uselecttop1idfromdocdetaillogwheredocid=PerRowMainIdandoperateUserid=CurrUserId聲音提醒規(guī)則selecttop1idfromdocdetaillogwheredocid=PerRowMainIdandoperateUserid=CurrU

44、serId信息統(tǒng)計(jì)規(guī)則按所屬部門查詢共：Aselectcount(distinctid)fromDocDetailast1,DocShareDetailast2wheredocstatusin('1','2','5')andt1.id=t2.docidandt2.useridin(selectidfromhrmresourcewheredepartmentid=CurrUserDeptId)andt2.usertype=1andsubcategory=164按分部查詢共：Aselectcount(distinctid)fromDocDetaila

45、st1,DocShareDetailast2wheredocstatusin('1','2','5')andt1.id=t2.docidandt2.useridin(selectidfromhrmresourcewheresubcompanyid1=CurrUserSubcCompanyId)andt2.usertype=1andsubcategory=164部門會(huì)議頁(yè)面地址/meeting/data/ViewMeeting.jsp?meetingid=PerRowMainId更多鏈接/meeting/search/SearchResult.js

46、p?start=1&perpage=15內(nèi)容顯示規(guī)則按所屬部門查詢SelectdistincttopThisModuleRowsa.idasPerRowMainId,asPerRowMainSubject,a.begindate+'('+a.begintime+'-'+a.endtime+')'asPerRowMainDateTimefromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3'andb.memberidin(selec

47、tidfromhrmresourcewheredepartmentid=CurrUserDeptId)orderbyPerRowMainDateTimedesc按分部查詢SelectdistincttopThisModuleRowsa.idasPerRowMainId,asPerRowMainSubject,a.begindate+'('+a.begintime+'-'+a.endtime+')'asPerRowMainDateTimefromMeetinga,Meeting_Member2bwherea.id=b.meetingidanda.isapproved='3&