# app_template

id: 657ffbd799320041501b0972
pid: 657ffbd799320041501b0971
name: ui
nodetype: column
createdate: 2023.12.19 06:34:59.000
lastmodifieddate: 2023.12.19 10:09:10.764
value:
{"version":"1.0","sheetcount":1,"gui":true,"theme":"default","showTabOnBottom":false,"runtimeOptions":{"gridFocusRowNeedHighlight":false},"sheets":[{"index":0,"rowCount":9,"columnCount":11,"guid":"3f8a372926e906087708efd8172c06d1","name":"Sheet1","gridLineVisible":false,"freezedRow":5,"freezedCol":0,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"rows":[{"index":0,"height":38,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":1,"height":25,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":2,"height":30,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":3,"height":25,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":4,"height":32,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":5,"height":32,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":6,"height":25,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":7,"height":25,"isColumnScrollEnabled":true,"stretchHeight":0},{"index":8,"height":25,"isColumnScrollEnabled":true,"stretchHeight":0}],"columns":[{"index":0,"width":20,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":49,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":2,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":3,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":4,"width":39,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":5,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":6,"width":94,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":7,"width":249,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":8,"width":80,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":9,"width":81,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":10,"width":29,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0},{"row":0,"col":1,"define":"凭证影像调阅统计","rowSpan":1,"colSpan":9,"PI":0},{"row":0,"col":10},{"row":1,"col":0},{"row":1,"col":1},{"row":1,"col":2},{"row":1,"col":3},{"row":1,"col":4},{"row":1,"col":5},{"row":1,"col":6,"PI":1},{"row":1,"col":7,"PI":1},{"row":1,"col":8},{"row":1,"col":9},{"row":1,"col":10},{"row":2,"col":0},{"row":2,"col":1},{"row":2,"col":2,"define":"调阅日期从："},{"row":2,"col":3,"define":"=createDate(getYear(newDate()) , 1,1)","editable":true,"alias":"rq1","PI":2,"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM.dd"}},{"row":2,"col":4,"define":"到：","PI":3},{"row":2,"col":5,"define":"=newDate()","editable":true,"alias":"rq2","PI":4,"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM.dd"}},{"row":2,"col":6,"define":"账套名称：","PI":5},{"row":2,"col":7,"define":"00","editable":true,"cellValueType":3,"alias":"corpid","PI":6,"editstyle":{"editType":4,"ddlbName":"basic_账套列表(code2name)-全称","dropDownListEditable":false,"valueMustInDDLB":true,"ddlbFilterBy":"","ddlbMultiSelect":false,"ddlbFilterContext":"","ddlbInnerItems":"","showRealData":false,"columnCount":null}},{"row":2,"col":8,"PI":7},{"row":2,"col":9,"PI":8,"bricks":[{"type":"button","name":"cb_retrieve","config":{"name":"cb_retrieve","caption":" 检索","enable":true,"visible":true,"size":"1","className":"","x":1,"y":1,"width":60,"height":-1,"buttonStyle":"default","buttonColorStyle":"primary","leftIcon":"fa-search","rightIcon":"","action":"retrieve","dsn":"q1","moreDataSource":"","cachefirst":false,"DOMName":"cb_retrieve-cc46411a7b5f9cc83eaffcc1baf03a03","html":" \n                <button class=\"btn  btn-primary btn-xs\" \n                        id=\"cb_retrieve-cc46411a7b5f9cc83eaffcc1baf03a03\">\n                       <i class='fa fa-search'></i> 检索\n                </button>\n                "},"x":1,"y":1,"width":60,"height":-1}]},{"row":2,"col":10},{"row":3,"col":0},{"row":3,"col":1,"PI":2},{"row":3,"col":2,"PI":2},{"row":3,"col":3,"PI":9},{"row":3,"col":4,"PI":2},{"row":3,"col":5,"PI":9},{"row":3,"col":6,"PI":10},{"row":3,"col":7,"PI":11},{"row":3,"col":8,"PI":2},{"row":3,"col":9,"PI":2},{"row":3,"col":10},{"row":4,"col":0,"PI":12},{"row":4,"col":1,"define":"序号","alias":"t_q1_c_xh","PI":13},{"row":4,"col":2,"define":"申请单号","alias":"t_q1_billno","PI":13},{"row":4,"col":3,"define":"调阅日期","alias":"t_q1_billdate","PI":13},{"row":4,"col":4,"define":"调阅人","rowSpan":1,"colSpan":2,"alias":"t_q1_reader","PI":13},{"row":4,"col":6,"define":"调阅原因","rowSpan":1,"colSpan":2,"alias":"t_q1_summary","PI":13},{"row":4,"col":8,"define":"凭证数","cellValueType":3,"alias":"t_q1_pz_count","PI":13},{"row":4,"col":9,"define":"图片数","alias":"t_q1_pic_count","PI":13},{"row":4,"col":10,"PI":14},{"row":5,"col":0,"PI":12},{"row":5,"col":1,"alias":"q1_c_xh","PI":15,"bind":{"dataSource":"q1","DBCol":"c_xh","dsType":2},"editstyle":{"editType":1,"showComma":false,"decimalCount":0,"zeroVisible":true}},{"row":5,"col":2,"cellValueType":3,"alias":"q1_billno","PI":15,"bind":{"dataSource":"q1","DBCol":"billno","dsType":2}},{"row":5,"col":3,"cellValueType":4,"alias":"q1_billdate","PI":15,"bind":{"dataSource":"q1","DBCol":"billdate","dsType":2},"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM.dd"}},{"row":5,"col":4,"cellValueType":3,"rowSpan":1,"colSpan":2,"alias":"q1_reader","PI":15,"bind":{"dataSource":"q1","DBCol":"reader","dsType":2}},{"row":5,"col":6,"cellValueType":3,"rowSpan":1,"colSpan":2,"alias":"q1_summary","PI":16,"bind":{"dataSource":"q1","DBCol":"summary","dsType":2}},{"row":5,"col":8,"cellValueType":1,"alias":"q1_pz_count","PI":15,"bind":{"dataSource":"q1","DBCol":"pz_count","dsType":2},"editstyle":{"editType":1,"showComma":false,"decimalCount":0,"zeroVisible":true}},{"row":5,"col":9,"cellValueType":2,"alias":"q1_pic_count","PI":15,"bind":{"dataSource":"q1","DBCol":"pic_count","dsType":2},"editstyle":{"editType":1,"showComma":false,"decimalCount":0,"zeroVisible":true}},{"row":5,"col":10,"PI":14},{"row":6,"col":0,"PI":12},{"row":6,"col":1,"define":"合             计","rowSpan":1,"colSpan":7,"PI":17},{"row":6,"col":8,"define":"=sum(q1_pz_count)","PI":18},{"row":6,"col":9,"define":"=sum(q1_pic_count)","cellValueType":2,"PI":18},{"row":6,"col":10,"PI":14},{"row":7,"col":0},{"row":7,"col":1,"PI":19},{"row":7,"col":2,"PI":19},{"row":7,"col":3,"PI":19},{"row":7,"col":4,"PI":19},{"row":7,"col":5,"PI":19},{"row":7,"col":6,"PI":19},{"row":7,"col":7,"PI":19},{"row":7,"col":8,"PI":19},{"row":7,"col":9,"PI":19},{"row":7,"col":10},{"row":8,"col":0},{"row":8,"col":1},{"row":8,"col":2},{"row":8,"col":3},{"row":8,"col":4},{"row":8,"col":5},{"row":8,"col":6},{"row":8,"col":7},{"row":8,"col":8},{"row":8,"col":9},{"row":8,"col":10}]}],"propertyCache":{"370c75b3c4e35ef110a2be00ac46b60d":{"text-align":2,"font-size":24,"font-family":"黑体"},"3736221b6320a5ed99534cefdf10ef9b":{"border-bottom-width":2,"border-bottom-color":[128,128,128,1]},"125018f3eef635c9d10037c06e4a0236":{"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1]},"298b5ef4011af3ba64d3c83b4dddacf1":{"text-align":2},"f51f0f1466968dfdbe908309411abf97":{"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"border-right-width":2,"border-right-color":[128,128,128,1]},"921b29323375f1904518f946396422d1":{"border-left-width":2,"border-left-color":[128,128,128,1],"border-top-width":2,"border-top-color":[128,128,128,1],"border-right-color":[128,128,128,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"text-align":1},"7ba6d2412d1134837f9b22f0d132b3a8":{"border-left-color":[128,128,128,1],"border-top-width":2,"border-top-color":[128,128,128,1],"border-right-width":2,"border-right-color":[128,128,128,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"color":"rgb(23, 32, 42)"},"b81f72c21f3ff60a9da63f10dfcea61a":{"color":"rgb(23, 32, 42)","border-left-width":2,"border-left-color":[128,128,128,1]},"0ab4f03ab4f16eec3317ab886760e18d":{"color":"rgb(23, 32, 42)"},"0f4ec947c6784488bfe73f5041225ff8":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1]},"582e6ff7dcbc794e847c24ddd7d496b7":{"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"border-top-width":2,"border-top-color":[128,128,128,1]},"d7a04dfe47c0d253ef88d19384ab6992":{"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1]},"47a00a41624c6383ac8392dd4e2d2817":{"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1]},"e6e9ad1d1bf48a80d90257b52ddbddf0":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"background-color":"rgb(244, 246, 246)","text-align":2},"20118c09fa9c7e8fb2753e163d4f4c03":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1]},"e0f3c8aad09b68823371fec675cb9c79":{"text-align":2,"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1]},"0e956518586afeb1d32e8fee9de23c62":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"word-wrap":true},"c0ba326c280d709919489668fb41b110":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"background-color":"rgb(244, 246, 246)","text-align":2},"e6e66767483857dbfcab56155d12a556":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"background-color":"rgb(244, 246, 246)","text-align":2,"font-family":"Arial","font-bold":true},"fc406aa51250ead084dba7e6ed9e7117":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1]}},"propertyIdList":["370c75b3c4e35ef110a2be00ac46b60d","3736221b6320a5ed99534cefdf10ef9b","125018f3eef635c9d10037c06e4a0236","298b5ef4011af3ba64d3c83b4dddacf1","f51f0f1466968dfdbe908309411abf97","921b29323375f1904518f946396422d1","7ba6d2412d1134837f9b22f0d132b3a8","b81f72c21f3ff60a9da63f10dfcea61a","0ab4f03ab4f16eec3317ab886760e18d","0f4ec947c6784488bfe73f5041225ff8","582e6ff7dcbc794e847c24ddd7d496b7","d7a04dfe47c0d253ef88d19384ab6992","47a00a41624c6383ac8392dd4e2d2817","e6e9ad1d1bf48a80d90257b52ddbddf0","20118c09fa9c7e8fb2753e163d4f4c03","e0f3c8aad09b68823371fec675cb9c79","0e956518586afeb1d32e8fee9de23c62","c0ba326c280d709919489668fb41b110","e6e66767483857dbfcab56155d12a556","fc406aa51250ead084dba7e6ed9e7117"]}


id: 657ffbd799320041501b0974
pid: 657ffbd799320041501b0971
name: rightcheckpoint
nodetype: column
createdate: 2023.12.19 06:34:59.000
lastmodifieddate: 2023.12.19 10:09:10.765
value:
{"3f8a372926e906087708efd8172c06d1":{"name":"Sheet1","buttonClick":[{"name":"cb_retrieve","title":" 检索"}]}}


id: 657ffbd799320041501b0975
pid: 657ffbd799320041501b0971
name: db
nodetype: column
createdate: 2023.12.19 06:34:59.000
lastmodifieddate: 2023.12.19 10:09:10.765
value:
[{"name":"q1","label":"","type":"query","dbpool":"default","description":"","multirow":true,"updatedtable":"","sql":"select  a.billno, a.billdate , a.reader ,a.summary , count( b.pzh) as pz_count,   sum( c.pz + c.fj) as pic_count \n from dzpz_dy a , dzpz_dymx b , dzpz_pz c \nwhere a.gguid= b.gguid and  ifnull(a.pass,0) =1 and a.corpid= c.corpid and b.pzh= c.pzh \ngroup by a.billno , a.billdate , a.reader , a.summary","dynamicwhere":"","dynamicwhere2":"\" a.billdate>='\"+rq1+\"' \"\n\" a.billdate<='\"+rq2+\" 23:59:59' \"\n\" a.corpid='\"+ corpid+\"' \"","dynamicwheredata2":"rq1: date2yyyymmdd( rq1)\nrq2: date2yyyymmdd( rq2)\ncorpid: corpid","primarykey":"","autoretrieve":false,"needcache":"false","cacheserver":"","cachetimeout":30,"table_query_id":"657ffbd799320041501b09a7","column":[{"name":"billno","label":"申请单号","description":"","type":"varchar(40)","nullable":true,"smartretrieve":false,"smartretrievecolname":"","dict":"","exportformat":"","cloneable":false,"updatable":"true","datamask":"","modifylog":"false","usedingroupby":"false","usedinsum":"false","defaultvalue":"","dbdefaultvalue":""},{"name":"billdate","label":"调阅日期","description":"","type":"datetime","nullable":true,"smartretrieve":false,"smartretrievecolname":"","dict":"","exportformat":"","cloneable":false,"updatable":"true","datamask":"","modifylog":"false","usedingroupby":"false","usedinsum":"false","defaultvalue":"","dbdefaultvalue":""},{"name":"reader","label":"调阅人","description":"","type":"varchar(100)","nullable":true,"smartretrieve":false,"smartretrievecolname":"","dict":"","exportformat":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"summary","label":"备注","description":"","type":"varchar(200)","nullable":true,"smartretrieve":false,"smartretrievecolname":"","dict":"","exportformat":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"pz_count","label":"pz_count","description":"","type":"int","nullable":true,"smartretrieve":false,"smartretrievecolname":"","dict":"","exportformat":"","cloneable":false,"updatable":"true","datamask":"","modifylog":"","usedingroupby":"false","usedinsum":"false","defaultvalue":"","dbdefaultvalue":""},{"name":"pic_count","label":"图片数","description":"","type":"decimal(33,0)","nullable":true,"smartretrieve":false,"smartretrievecolname":"","dict":"","exportformat":"","cloneable":false,"updatable":"true","datamask":"","modifylog":"false","usedingroupby":"false","usedinsum":"false","defaultvalue":"","dbdefaultvalue":""}],"computer":[{"name":"c_xh","label":"序号","expression":"thisrow() + 1","description":"","fillback":""}]}]


id: 6580d0d5993288459f242709
pid: 657ffbd799320041501b0971
name: pagesetup-3f8a372926e906087708efd8172c06d1
nodetype: column
createdate: 2023.12.19 07:11:35.000
lastmodifieddate: 2023.12.19 10:09:10.765
value:
{"pageWidth":"210","pageHeight":"297","leftMargin":"20","topMargin":"20","rightMargin":"20","bottomMargin":"20","paper":"210*297","printDir":1,"pageHeaderConfig":{"define":"","height":"20"},"pageFooterConfig":{"define":"=\"第 \"+pageIndex()+\" 页，共 \"+pageCount()+\" 页\"","height":"20"},"printScale":"0","printerDeviceName":"PDF生成器"}


# app_db

id: 6580cd9099320041501b09cb
pid: 657ffbd799320041501b09a7
name: sql
nodetype: column
createdate: 2023.12.19 06:54:15.000
lastmodifieddate: 2023.12.19 10:09:14.441
value:
select  a.billno, a.billdate , a.reader ,a.summary , count( b.pzh) as pz_count,   sum( c.pz + c.fj) as pic_count 
 from dzpz_dy a , dzpz_dymx b , dzpz_pz c 
where a.gguid= b.gguid and  ifnull(a.pass,0) =1 and a.corpid= c.corpid and b.pzh= c.pzh 
group by a.billno , a.billdate , a.reader , a.summary


id: 6580cd9099320041501b09ce
pid: 657ffbd799320041501b09a7
name: dynamicwhere2_tokens
nodetype: column
createdate: 2023.12.19 06:54:15.000
lastmodifieddate: 2023.12.19 10:09:14.441
value:
{
    "\" a.billdate>='\"+rq1+\"' \"": "rq1",
    "\" a.billdate<='\"+rq2+\" 23:59:59' \"": "rq2",
    "\" a.corpid='\"+ corpid+\"' \"": "corpid"
}


