# app_template

id: 669dc6399932df22f60ce47f
pid: 669dc6399932df22f60ce463
name: script
nodetype: column
createdate: 2024.04.25 20:07:48.000
lastmodifieddate: 2024.09.18 14:41:00.710
value:
/**
 * 一个单据打开，
 * 1 先对类型为“表”的结果集做数据异步检索
 * 2 全部表检索完成之后，再执行 formOpen 事件
 * 3 再根据  actio 执行 newOpen/viewOpen/editOpen 之一
 * 4 再执行  afterOpen
 * 5 对类型为“结果集”的且需要自动检索的结果集，做异步检索
 * 6 异步检索完成后，最后执行  formOpenOver 事件
 */
//@comment (group=表单事件,caption=表单初始化全部完成之后)
function formOpenOver() {
    if (currentUserId() != '1') $('#cb_moreWorkFlow ul li:eq(2),#cb_moreWorkFlow ul li:eq(3),#cb_moreWorkFlow ul li:eq(4),#cb_moreWorkFlow ul li:eq(5),#cb_moreWorkFlow ul li:eq(6)').hide();

    var data = $pz_yjd_ds.getJSON(0);

    if (urlArgs.action == 'view') {
        book.getWorkSheet('汇总').getBrick('cb_add_pz').visible = false;
        book.getWorkSheet('清单').getBrick('cb_import').visible = false;
        book.getWorkSheet('清单').getBrick('cb_buildsum').visible = false;

        book.getWorkSheet('清单').cells('c_db_deleterow').visible = false;
        book.getWorkSheet('清单').cells('c_db_deleterow').clickable = false;


        book.getWorkSheet('清单').cells('qsqx').visible = false;
        book.getWorkSheet('清单').cells('qsqx').clickable = false;

        book.getWorkSheet('清单').cells('state').visible = false;
        book.getWorkSheet('清单').cells('state').clickable = false;

        book.getWorkSheet('清单').CPM.setColumnWidth(book.getWorkSheet('清单').cells('c_db_deleterow').columnIndex, 0);

        if (data.flow_instance_status && data.flow_instance_status.indexOf('结束') > 0) {
            book.getWorkSheet('清单').cells('qsqx').visible = true;
            book.getWorkSheet('清单').cells('state').visible = true;
        } else {
            book.getWorkSheet('清单').CPM.setColumnWidth(book.getWorkSheet('清单').cells('qsqx').columnIndex, 0);
            book.getWorkSheet('清单').CPM.setColumnWidth(book.getWorkSheet('清单').cells('state').columnIndex, 0);
        }

    } else {

        if (data.flow_instance_status && data.flow_instance_status.indexOf('接收方签收确认') > 0) {
            book.getWorkSheet('清单').cells('qsqx').editable = true;
            book.getWorkSheet('清单').cells('state').editable = true;
            book.getWorkSheet('清单').cells('is_change').editable = false;
            

            book.getWorkSheet('清单').cells('c_db_deleterow').visible = false;
            book.getWorkSheet('清单').cells('c_db_deleterow').clickable = false;

            book.getWorkSheet('清单').CPM.setColumnWidth(book.getWorkSheet('清单').cells('c_db_deleterow').columnIndex, 0);
        } else {
            book.getWorkSheet('清单').cells('c_db_deleterow').visible = true;
            book.getWorkSheet('清单').cells('c_db_deleterow').clickable = true;
        }

    }

}



//@comment (group=按钮,caption=添加凭证号)
function cb_add_pz_onClick() {
    var sheet = book.getWorkSheet('添加凭证号');

    sheet.cells('ny').setValue('');
    sheet.cells('pzh1').setValue('');
    sheet.cells('pzh2').setValue('');

    sheet.float('fa fa-cog', "添加凭证号", {
        my: 'center',
        at: 'center',
        autoposition: 'down',
        offsetX: -5,
        offsetY: 5
    }, { width: 900, height: 400 });

}

//@comment (group=添加凭证号按钮,caption=取消)
function cb_cancel_onClick() {
    var sheet = book.getWorkSheet('添加凭证号');
    sheet.floatPanelClose();
}

//@comment (group=添加凭证号按钮,caption=确认)
function cb_comfirn_onClick() {
    var sheet = book.getWorkSheet('添加凭证号');
    sheet.floatPanelClose();

    var data = {
        ny: sheet.cells('ny').getValue(),
        pzh1: sheet.cells('pzh1').getValue(),
        pzh2: sheet.cells('pzh2').getValue(),
    }

    if (data.pzh2 / 1 < data.pzh1 / 1) {
        toastr.error('终止凭证号要比起始凭证号大');
        return false;
    }

    toastr.show("正在计算...");
    setTimeout(function () {
        back_add_pzh(data, function (ret) {
            toastr.hide();
            if (ret.pzh_list && ret.pzh_list.length) {
                inputBox("提示", "以下凭证号不符合条件", ret.pzh_list.join('\n'), "", function (val) {
                }, false, { onContentReady: function () { } }, 10);
            } else {
                toastr.info("导入完成");
                // $pz_yjd_ds.smartRetrieve();
                $pz_yjdex_ds.smartRetrieve();
                $pz_yjd_pzh_ds.smartRetrieve();
                $q_pz_yjd_pzh_ds.smartRetrieve();
            }
        });
    }, 100);
}

function cb_import_onClick() {

    var sheet = book.getWorkSheet('导入凭证号');

    sheet.cells('ny').setValue('');
    sheet.cells('pzh').setValue('');

    sheet.float('fa fa-cog', "导入凭证号", {
        my: 'center',
        at: 'center',
        autoposition: 'down',
        offsetX: -5,
        offsetY: 5
    }, { width: 500, height: 400 });

}


//@comment (group=导入凭证号按钮,caption=取消)
function cb_cancel2_onClick() {
    var sheet = book.getWorkSheet('导入凭证号');
    sheet.floatPanelClose();
}

//@comment (group=导入凭证号按钮,caption=确认)
function cb_comfirn2_onClick() {
    var sheet = book.getWorkSheet('导入凭证号');
    sheet.floatPanelClose();

    var data = {
        ny: sheet.cells('ny').getValue(),
        pzh: sheet.cells('pzh').getValue(),
    }


    toastr.show("正在计算...");
    setTimeout(function () {
        back_import_pzh_data(data, function (ret) {
            toastr.hide();
            if (ret.pzh_list && ret.pzh_list.length) {
                inputBox("提示", "以下凭证号不符合条件", ret.pzh_list.join('\n'), "", function (val) {
                }, false, { onContentReady: function () { } }, 10);
            } else {
                toastr.info("导入完成");
                // $pz_yjd_ds.smartRetrieve();
                $pz_yjdex_ds.smartRetrieve();
                $pz_yjd_pzh_ds.smartRetrieve();
                $q_pz_yjd_pzh_ds.smartRetrieve();
            }
        });
    }, 100);
}


function cb_buildsum_onClick() {
    $confirm("提示", "确信要根据凭证号清单生成凭证号汇总信息吗?", function () {
        toastr.show("正在计算...");
        setTimeout(function () {
            back_build_sum(function () {
                toastr.hide();
                toastr.info("计算完成");
                $pz_yjd_ds.smartRetrieve();
                $pz_yjdex_ds.smartRetrieve();
                $pz_yjd_pzh_ds.smartRetrieve();
                $q_pz_yjd_pzh_ds.smartRetrieve();

            });
        }, 100);

    });

}



/**
 * 当单元格即将进入编辑时，本事件被触发，如果本事件返回false 即编辑被阻止
 * @param sheet
 * @param cell
 * @param innerRow   当单元格没有绑定数据库或绑定到单行数据库时，本参数无意义。如果绑定一个
 * 多行数据库，则表示该单元所绑定的字段的第 innerRow行是否允许编辑
 */
function isCellEditable(sheet, cell, innerRow) {

    if (sheet.Name == '清单' && (cell.alias == 'state' || cell.alias == 'qsqx')) {
        var state = $pz_yjd_pzh_ds.getValue(innerRow, 'state', true);
        if (state != '0') {
            toastr.error(`该凭证号已${state == '1' ? '确认' : '退回'}，无法修改`);
            return false;
        }
    }

    return true;
}



/**
 * 单元格因为被编辑而改变。当用户通过编辑单元的值而让单元格发生值改变时本事件被触发。
 * 注意，当使用脚本 sheet.cells(row,col).setValue ( value) 来改变单元格的值时，本事件并不触发
 * @param sheet
 * @param cell
 * @param newValue
 * @param innerRow   当单元格没有绑定数据库或绑定到单行数据库时，本参数无意义。如果绑定一个
 * 多行数据库，则表示该单元所绑定的字段的第 innerRow行发生变化
 */
function cellValueChangedByEdit(sheet, cell, newValue, innerRow) {

    //通过别名来判断
    if (cell.alias == 'XXX') {

    }

    //通过数据库绑定情况来判断
    let bind = cell.bind;
    if (bind != null && bind.dataSource == 'q_pz_yjd_pzh' && bind.DBCol == 'qsqx') {

        var qsqx = $pz_yjd_ds.getValue(0, 'qsqx');
        var ycly = $q_pz_yjd_pzh_ds.getValue(innerRow, 'ycly');
        if (ycly == 'null' || ycly == null) ycly = '';

        window.qsqx_change = true;

        if (newValue > '0') {
            inputBox("提示", "请输入延长理由", ycly, "", function (val) {
                $q_pz_yjd_pzh_ds.setValue(innerRow, 'ycly', val);
                $q_pz_yjd_pzh_ds.setValue(innerRow, 'qsqx', newValue);
            }, false, {
                    onContentReady: function () {
                        $q_pz_yjd_pzh_ds.setValue(innerRow, 'qsqx', window.qsqx_old);
                        window.qsqx_old = 0;
                    }
                }, 10);
        } else {
            $q_pz_yjd_pzh_ds.setValue(innerRow, 'ycly', '');
        }

    }


}



/**
 * 数据集中的数据发生变化
 * @param dsname 数据集名称
 * @param row   数据行号
 * @param col    字段名
 * @param oldValue   原值
 * @param newValue  新值
 */
function itemChanged(dsname, row, col, oldValue, newValue) {

    if (dsname == 'q_pz_yjd_pzh' && col == 'qsqx' && window.qsqx_change) {
        window.qsqx_old = oldValue;
        window.qsqx_change = false;
    }

}


id: 669dc63a9932df22f60ce48f
pid: 669dc6399932df22f60ce463
name: ui
nodetype: column
createdate: 2024.04.25 20:07:48.000
lastmodifieddate: 2024.09.18 14:41:00.710
value:
{"version":"1.0","sheetcount":5,"gui":true,"theme":"default","showTabOnBottom":false,"runtimeOptions":{"gridFocusRowNeedHighlight":false,"showTabOnWhere":"none"},"sheets":[{"index":0,"rowCount":12,"columnCount":15,"guid":"13649d83173eb4e887957bdbb847dfaf","name":"main","gridLineVisible":false,"freezedRow":0,"freezedCol":0,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"exportExcelWithDDLB":false,"rows":[{"index":0,"height":40,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":1,"height":19,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":2,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":3,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":4,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":5,"height":8,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":6,"height":10,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":7,"height":26,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":8,"height":339,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":10},{"index":9,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":10,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":11,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0}],"columns":[{"index":0,"width":20,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":44,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":2,"width":72,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":3,"width":128,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":4,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":5,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":6,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":7,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":8,"width":39,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":9,"width":42,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":10,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":11,"width":63,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":12,"width":61,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":13,"width":100,"width2":-1,"stretchWidth":10,"rowHeightAutoFit":false},{"index":14,"width":16,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0},{"row":0,"col":1,"define":"凭 证 归 还","rowSpan":1,"colSpan":12,"PI":0},{"row":0,"col":13},{"row":0,"col":14},{"row":1,"col":0},{"row":1,"col":1,"PI":1},{"row":1,"col":2},{"row":1,"col":3,"PI":1},{"row":1,"col":4,"PI":1},{"row":1,"col":5,"PI":1},{"row":1,"col":6,"PI":1},{"row":1,"col":7,"define":"归还","visible":false,"cellValueType":3,"alias":"billtype","PI":1,"bind":{"dataSource":"pz_yjd","DBCol":"billtype","dsType":1}},{"row":1,"col":8,"PI":1},{"row":1,"col":9,"cellValueType":4},{"row":1,"col":10,"cellValueType":4,"PI":1,"bind":{"dataSource":"pz_yjd","DBCol":"billdate","dsType":1},"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM.dd"}},{"row":1,"col":11},{"row":1,"col":12},{"row":1,"col":13},{"row":1,"col":14},{"row":2,"col":0,"PI":2},{"row":2,"col":1,"define":"流  水  号","rowSpan":1,"colSpan":2,"PI":3},{"row":2,"col":3,"cellValueType":3,"PI":4,"bind":{"dataSource":"pz_yjd","DBCol":"billno","dsType":1}},{"row":2,"col":4,"define":"归还发起人","PI":3},{"row":2,"col":5,"cellValueType":3,"PI":4,"bind":{"dataSource":"pz_yjd","DBCol":"username","dsType":1}},{"row":2,"col":6,"define":"归还接收人","PI":3},{"row":2,"col":7,"editable":true,"cellValueType":1,"PI":5,"bind":{"dataSource":"pz_yjd","DBCol":"touserid","dsType":1},"editstyle":{"editType":4,"ddlbName":"userid2usershowname","dropDownListEditable":true,"valueMustInDDLB":true,"ddlbFilterBy":"\" id <>'\"+currentUserId()+\"'\"","ddlbMultiSelect":false,"ddlbFilterBy_encrypted":"YAKL5M7NLTH7WH75AWQ2XI47SNEADPUTP2CSN2Z7MXMT3Z33QNFA","ddlbFilterContext":"","ddlbInnerItems":"","showRealData":false,"columnCount":null}},{"row":2,"col":8,"define":"提交","PI":3},{"row":2,"col":9,"define":3,"editable":true,"cellValueType":1,"PI":6,"bind":{"dataSource":"pz_yjd","DBCol":"qsqx","dsType":1},"editstyle":{"editType":1,"showComma":false,"decimalCount":0,"zeroVisible":true}},{"row":2,"col":10,"define":"天后自动确认。      ","PI":7},{"row":2,"col":11,"define":"凭证份数","PI":3},{"row":2,"col":12,"cellValueType":1,"PI":8,"bind":{"dataSource":"pz_yjd","DBCol":"pzs","dsType":1}},{"row":2,"col":13,"PI":9},{"row":2,"col":14},{"row":3,"col":0,"PI":2},{"row":3,"col":1,"define":"账套号","rowSpan":1,"colSpan":2,"PI":3},{"row":3,"col":3,"editable":true,"cellValueType":3,"PI":10,"bind":{"dataSource":"pz_yjd","DBCol":"corpid","dsType":1},"editstyle":{"editType":4,"ddlbName":"basic_账套列表(code2name)-简称","dropDownListEditable":false,"valueMustInDDLB":false,"ddlbFilterBy":"","ddlbMultiSelect":false,"ddlbFilterContext":"","ddlbInnerItems":"","showRealData":false,"columnCount":null}},{"row":3,"col":4,"define":"归还事务说明","PI":3},{"row":3,"col":5,"editable":true,"cellValueType":3,"rowSpan":1,"colSpan":8,"PI":10,"bind":{"dataSource":"pz_yjd","DBCol":"towhere","dsType":1},"editstyle":{"editType":4,"ddlbName":"{自已的值}","dropDownListEditable":true,"valueMustInDDLB":false,"ddlbFilterBy":"","ddlbMultiSelect":false,"ddlbFilterContext":"","ddlbInnerItems":"","showRealData":false,"columnCount":null}},{"row":3,"col":13,"PI":9},{"row":3,"col":14},{"row":4,"col":0,"PI":2},{"row":4,"col":1,"define":"备      注","rowSpan":1,"colSpan":2,"PI":3},{"row":4,"col":3,"editable":true,"cellValueType":3,"rowSpan":1,"colSpan":10,"PI":8,"bind":{"dataSource":"pz_yjd","DBCol":"summary","dsType":1},"editstyle":{"editType":2}},{"row":4,"col":13,"PI":9},{"row":4,"col":14},{"row":5,"col":0},{"row":5,"col":1,"PI":11},{"row":5,"col":2,"PI":12},{"row":5,"col":3,"PI":11},{"row":5,"col":4,"PI":11},{"row":5,"col":5,"PI":11},{"row":5,"col":6,"PI":11},{"row":5,"col":7,"PI":11},{"row":5,"col":8,"PI":11},{"row":5,"col":9,"PI":11},{"row":5,"col":10,"PI":13},{"row":5,"col":11,"PI":12},{"row":5,"col":12,"PI":12},{"row":5,"col":13},{"row":5,"col":14},{"row":6,"col":0,"PI":14},{"row":6,"col":1,"PI":15},{"row":6,"col":2,"PI":16},{"row":6,"col":3,"PI":16},{"row":6,"col":4,"PI":16},{"row":6,"col":5,"PI":16},{"row":6,"col":6,"PI":16},{"row":6,"col":7,"cellValueType":1,"PI":16},{"row":6,"col":8,"cellValueType":3,"PI":16},{"row":6,"col":9,"PI":16},{"row":6,"col":10,"PI":16},{"row":6,"col":11,"PI":16},{"row":6,"col":12,"PI":17},{"row":6,"col":13,"PI":18},{"row":6,"col":14},{"row":7,"col":0},{"row":7,"col":1,"rowSpan":1,"colSpan":12,"PI":19,"bricks":[{"type":"Tab","name":"tab1","config":{"name":"tab1","container":"tabContainer","style":"round","position":"top","skin":"skin-asbestos","caption":"Tab容器","enable":true,"visible":true,"css":"","x":0,"y":0,"width":0,"height":0,"tabs":[{"id":"tab1","title":"凭证号汇总","type":"worksheet","source":"汇总"},{"id":"tab2","title":"凭证号清单","type":"worksheet","source":"清单"}],"DOMName":"tab1-b4c0a3a0b63b4d35233fe7620b0b6c48","html":"<div  style=\"width:100%;height:100%\"><div id='tab_tab1-b4c0a3a0b63b4d35233fe7620b0b6c48' style=\"position:absolute; width:100%; bottom:0px;  \" \n                            class=\"tabbed_top round  skin-asbestos\"  >\n                        <ul  id='ul_tab1-b4c0a3a0b63b4d35233fe7620b0b6c48'><li id=\"tab_tab1-b4c0a3a0b63b4d35233fe7620b0b6c48_tab2\" \n                               tabid=\"tab2\"   >&nbsp;&nbsp凭证号清单&nbsp;&nbsp </li> \n                                \n                            <li id=\"tab_tab1-b4c0a3a0b63b4d35233fe7620b0b6c48_tab1\" \n                               tabid=\"tab1\"   >&nbsp;&nbsp凭证号汇总&nbsp;&nbsp </li> \n                                \n                            </ul> </div></div>"},"x":0,"y":0,"width":0,"height":0}]},{"row":7,"col":13},{"row":7,"col":14},{"row":8,"col":0},{"row":8,"col":1,"rowSpan":1,"colSpan":13,"alias":"tabContainer"},{"row":8,"col":14},{"row":9,"col":0},{"row":9,"col":1,"define":"提示："},{"row":9,"col":2},{"row":9,"col":3},{"row":9,"col":4},{"row":9,"col":5},{"row":9,"col":6},{"row":9,"col":7},{"row":9,"col":8},{"row":9,"col":9},{"row":9,"col":10},{"row":9,"col":11},{"row":9,"col":12},{"row":9,"col":13},{"row":9,"col":14},{"row":10,"col":0},{"row":10,"col":1},{"row":10,"col":2,"define":"凭证归还后，在指定的天数后如果没有确认，则由系统自动确认并结束流程。","rowSpan":1,"colSpan":11},{"row":10,"col":13},{"row":10,"col":14},{"row":11,"col":0},{"row":11,"col":1},{"row":11,"col":2},{"row":11,"col":3},{"row":11,"col":4},{"row":11,"col":5},{"row":11,"col":6},{"row":11,"col":7},{"row":11,"col":8},{"row":11,"col":9},{"row":11,"col":10},{"row":11,"col":11},{"row":11,"col":12},{"row":11,"col":13},{"row":11,"col":14}]},{"index":1,"rowCount":11,"columnCount":13,"guid":"51e9dff5800468a7298c50c3b0f9c96f","name":"汇总","gridLineVisible":false,"freezedRow":0,"freezedCol":0,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"exportExcelWithDDLB":false,"rows":[{"index":0,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":1,"height":42,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":2,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":3,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":4,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":5,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":6,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":7,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":8,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":9,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":10,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0}],"columns":[{"index":0,"width":44,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":2,"width":72,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":3,"width":128,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":4,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":5,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":6,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":7,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":8,"width":39,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":9,"width":42,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":10,"width":219,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":11,"width":0,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":12,"width":0,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0,"PI":20},{"row":0,"col":1},{"row":0,"col":2,"PI":21},{"row":0,"col":3,"PI":21},{"row":0,"col":4,"PI":21},{"row":0,"col":5,"PI":22},{"row":0,"col":6,"PI":23},{"row":0,"col":7,"PI":24},{"row":0,"col":8,"rowSpan":1,"colSpan":5,"PI":24},{"row":1,"col":0,"PI":19},{"row":1,"col":1},{"row":1,"col":2,"PI":19},{"row":1,"col":3,"PI":25,"bricks":[{"type":"button","name":"cb_add_pz","config":{"name":"cb_add_pz","caption":"添加凭证号","enable":true,"visible":true,"size":"1","className":"","x":1,"y":1,"width":-1,"height":-1,"buttonStyle":"options","buttonColorStyle":"primary","leftIcon":"fa-plus","rightIcon":"","DOMName":"cb_add_pz-7976f2c3eaad7f0b3b4c931a1ea12c45","html":"<span class=\"block-options \"> \n                <button class=\"btn  btn-primary btn-xs\" \n                        id=\"cb_add_pz-7976f2c3eaad7f0b3b4c931a1ea12c45\">\n                       <i class='fa fa-plus'></i>添加凭证号\n                </button>\n                </span>"},"x":1,"y":1,"width":-1,"height":-1}]},{"row":1,"col":4,"PI":19},{"row":1,"col":5,"PI":19},{"row":1,"col":6},{"row":1,"col":7},{"row":1,"col":8},{"row":1,"col":9},{"row":1,"col":10},{"row":1,"col":11},{"row":1,"col":12},{"row":2,"col":0,"define":"序号","PI":3},{"row":2,"col":1,"define":"凭证年月","PI":3},{"row":2,"col":2,"define":"起始凭证号","rowSpan":1,"colSpan":2,"PI":3},{"row":2,"col":4,"define":"终止凭证号","rowSpan":1,"colSpan":2,"PI":3},{"row":2,"col":6,"define":"凭证份数","PI":3},{"row":2,"col":7,"define":"备注","rowSpan":1,"colSpan":4,"PI":3},{"row":2,"col":11,"rowSpan":1,"colSpan":2,"PI":3},{"row":3,"col":0,"PI":26,"bind":{"dataSource":"pz_yjdex","DBCol":"c_inner_xh","dsType":2},"editstyle":{"editType":1,"showComma":true,"decimalCount":0,"zeroVisible":true}},{"row":3,"col":1,"cellValueType":4,"PI":27,"bind":{"dataSource":"pz_yjdex","DBCol":"ny","dsType":2},"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM"}},{"row":3,"col":2,"cellValueType":3,"rowSpan":1,"colSpan":2,"PI":27,"bind":{"dataSource":"pz_yjdex","DBCol":"pzh1","dsType":2}},{"row":3,"col":4,"cellValueType":3,"rowSpan":1,"colSpan":2,"PI":27,"bind":{"dataSource":"pz_yjdex","DBCol":"pzh2","dsType":2}},{"row":3,"col":6,"cellValueType":1,"alias":"pz_yjdex_pzs","PI":26,"bind":{"dataSource":"pz_yjdex","DBCol":"pzs","dsType":2},"editstyle":{"editType":1,"showComma":true,"decimalCount":0,"zeroVisible":true}},{"row":3,"col":7,"cellValueType":3,"rowSpan":1,"colSpan":4,"PI":27,"bind":{"dataSource":"pz_yjdex","DBCol":"memo","dsType":2}},{"row":3,"col":11,"PI":28,"bind":{"dataSource":"pz_yjdex","DBCol":"c_db_insertrowafter","dsType":2}},{"row":3,"col":12,"PI":29,"bind":{"dataSource":"pz_yjdex","DBCol":"c_db_deleterow","dsType":2}},{"row":4,"col":0,"define":"合       计","rowSpan":1,"colSpan":6,"PI":30},{"row":4,"col":6,"define":"=sum(pz_yjdex_pzs)","cellValueType":1,"PI":31,"bind":{"dataSource":"pz_yjd","DBCol":"pzs","dsType":1}},{"row":4,"col":7,"rowSpan":1,"colSpan":6,"PI":32}]},{"index":2,"rowCount":10,"columnCount":12,"guid":"cdcab3c46fd82166dff4cf6bba427078","name":"清单","gridLineVisible":false,"freezedRow":3,"freezedCol":1,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"exportExcelWithDDLB":false,"rows":[{"index":0,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":1,"height":42,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":2,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":3,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":4,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":5,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":6,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":7,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":8,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":9,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0}],"columns":[{"index":0,"width":0,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":0,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":2,"width":98,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":3,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":4,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":5,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":6,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":7,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":8,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":9,"width":60,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":10,"width":150,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":11,"width":200,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0},{"row":0,"col":1},{"row":0,"col":2},{"row":0,"col":3},{"row":0,"col":4},{"row":0,"col":5},{"row":0,"col":6},{"row":0,"col":7},{"row":0,"col":8},{"row":0,"col":9},{"row":0,"col":10},{"row":0,"col":11},{"row":1,"col":0},{"row":1,"col":1},{"row":1,"col":2,"PI":1,"bricks":[{"type":"button","name":"cb_import","config":{"name":"cb_import","caption":"导入凭证号","enable":true,"visible":true,"size":"1","className":"","x":1,"y":1,"width":-1,"height":-1,"buttonStyle":"options","buttonColorStyle":"primary","leftIcon":"fa-plus","rightIcon":"","DOMName":"cb_import-9241a9f2f79efa5435dd59145899f732","html":"<span class=\"block-options \"> \n                <button class=\"btn  btn-primary btn-xs\" \n                        id=\"cb_import-9241a9f2f79efa5435dd59145899f732\">\n                       <i class='fa fa-plus'></i>导入凭证号\n                </button>\n                </span>","align":"center","_MODIFIERS":{}},"x":1,"y":1,"width":-1,"height":-1}]},{"row":1,"col":3,"rowSpan":1,"colSpan":4,"PI":1,"bricks":[{"type":"button","name":"cb_buildsum","config":{"name":"cb_buildsum","caption":"根据凭证号清单生成凭证号汇总信息","enable":true,"visible":true,"size":"1","className":"","x":1,"y":1,"width":-1,"height":-1,"buttonStyle":"options","buttonColorStyle":"primary","leftIcon":"","rightIcon":"","DOMName":"cb_buildsum-399a6f4380a724bf9fb532190d578143","html":"<span class=\"block-options \"> \n                <button class=\"btn  btn-primary btn-xs\" \n                        id=\"cb_buildsum-399a6f4380a724bf9fb532190d578143\">\n                       根据凭证号清单生成凭证号汇总信息\n                </button>\n                </span>","align":"center","_MODIFIERS":{}},"x":1,"y":1,"width":-1,"height":-1}]},{"row":1,"col":7},{"row":1,"col":8},{"row":1,"col":9},{"row":1,"col":10},{"row":1,"col":11},{"row":2,"col":0},{"row":2,"col":1,"PI":2},{"row":2,"col":2,"define":"序号","PI":33},{"row":2,"col":3,"define":"分组","PI":34},{"row":2,"col":4,"define":"凭证年月","PI":34},{"row":2,"col":5,"define":"凭证号","rowSpan":1,"colSpan":2,"PI":34},{"row":2,"col":7,"define":"凭证是否变动","PI":35},{"row":2,"col":8,"define":"延长理由","PI":35},{"row":2,"col":9,"rowSpan":1,"colSpan":3,"PI":35},{"row":3,"col":0},{"row":3,"col":1,"PI":2},{"row":3,"col":2,"PI":36,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"c_inner_xh","dsType":2},"editstyle":{"editType":1,"showComma":true,"decimalCount":0,"zeroVisible":true}},{"row":3,"col":3,"cellValueType":1,"PI":36,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"groupno","dsType":2}},{"row":3,"col":4,"cellValueType":4,"PI":36,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"ny","dsType":2},"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM"}},{"row":3,"col":5,"cellValueType":3,"rowSpan":1,"colSpan":2,"PI":37,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"pzh","dsType":2}},{"row":3,"col":7,"editable":true,"cursorName":"hand","cellValueType":1,"alias":"is_change","PI":38,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"is_change","dsType":2},"editstyle":{"editType":6,"ddlbName":"","dropDownListEditable":false,"valueMustInDDLB":false,"ddlbFilterBy":"","ddlbMultiSelect":false,"ddlbFilterContext":"","ddlbInnerItems":"0;否\n1;是","showRealData":false,"columnCount":2}},{"row":3,"col":8,"cellValueType":3,"PI":39,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"ycly","dsType":2},"editstyle":{"editType":0,"inputAttribute":""}},{"row":3,"col":9,"cursorName":"hand","alias":"c_db_deleterow","PI":40,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"c_db_deleterow","dsType":2}},{"row":3,"col":10,"prefix":"延长","suffix":"天自动确认","appData":{"clickControlEnabled":true,"clickControlTip":"延长确认"},"cellValueType":1,"alias":"qsqx","PI":41,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"qsqx","dsType":2},"editstyle":{"editType":1,"showComma":false,"decimalCount":0,"zeroVisible":true}},{"row":3,"col":11,"cursorName":"hand","appData":{"clickControlEnabled":true,"clickControlTip":"签收确认"},"cellValueType":1,"alias":"state","PI":41,"bind":{"dataSource":"q_pz_yjd_pzh","DBCol":"state","dsType":2},"editstyle":{"editType":6,"ddlbName":"","dropDownListEditable":false,"valueMustInDDLB":false,"ddlbFilterBy":"","ddlbMultiSelect":false,"ddlbFilterContext":"","ddlbInnerItems":"0;待确认\n1;已确认\n-1;退回","showRealData":false,"columnCount":3}},{"row":4,"col":0},{"row":4,"col":1},{"row":4,"col":2,"PI":42},{"row":4,"col":3,"PI":42},{"row":4,"col":4},{"row":4,"col":5,"PI":42},{"row":4,"col":6},{"row":4,"col":7},{"row":4,"col":8},{"row":4,"col":9,"PI":42},{"row":4,"col":10},{"row":4,"col":11},{"row":5,"col":0},{"row":5,"col":1},{"row":5,"col":2},{"row":5,"col":3},{"row":5,"col":4},{"row":5,"col":5},{"row":5,"col":6},{"row":5,"col":7},{"row":5,"col":8},{"row":5,"col":9},{"row":5,"col":10},{"row":5,"col":11},{"row":6,"col":0},{"row":6,"col":1},{"row":6,"col":2},{"row":6,"col":3},{"row":6,"col":4},{"row":6,"col":5},{"row":6,"col":6},{"row":6,"col":7},{"row":6,"col":8},{"row":6,"col":9},{"row":6,"col":10},{"row":6,"col":11}]},{"index":3,"rowCount":10,"columnCount":7,"guid":"fa726faa617d7764dc6d17bbae2b420d","name":"添加凭证号","gridLineVisible":false,"freezedRow":0,"freezedCol":0,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"exportExcelWithDDLB":false,"rows":[{"index":0,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":1,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":2,"height":36,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":3,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":4,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":5,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":6,"height":30,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":7,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":8,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":9,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0}],"columns":[{"index":0,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":100,"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":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":5,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":6,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0},{"row":0,"col":1},{"row":0,"col":2},{"row":0,"col":3},{"row":0,"col":4},{"row":0,"col":5},{"row":0,"col":6},{"row":1,"col":0},{"row":1,"col":1,"define":"凭证年月","PI":3},{"row":1,"col":2,"define":"起始凭证号","rowSpan":1,"colSpan":2,"PI":3},{"row":1,"col":4,"define":"终止凭证号","rowSpan":1,"colSpan":2,"PI":3},{"row":1,"col":6},{"row":2,"col":0},{"row":2,"col":1,"editable":true,"cellValueType":3,"alias":"ny","PI":43,"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM"}},{"row":2,"col":2,"editable":true,"cellValueType":3,"rowSpan":1,"colSpan":2,"alias":"pzh1","PI":43},{"row":2,"col":4,"editable":true,"cellValueType":3,"rowSpan":1,"colSpan":2,"alias":"pzh2","PI":43},{"row":2,"col":6},{"row":6,"col":0},{"row":6,"col":1},{"row":6,"col":2},{"row":6,"col":3},{"row":6,"col":4,"rowSpan":1,"colSpan":3,"bricks":[{"type":"button","name":"cb_comfirn","config":{"name":"cb_comfirn","caption":"确定","enable":true,"visible":true,"size":"1","className":"","x":-100,"y":1,"width":80,"height":-1,"buttonStyle":"default","buttonColorStyle":"primary","leftIcon":"","rightIcon":"","DOMName":"cb_comfirn-33276b2035ea5451281ec0c0e6b54b98","html":" \n                <button class=\"btn  btn-primary btn-xs\" \n                        id=\"cb_comfirn-33276b2035ea5451281ec0c0e6b54b98\">\n                       确定\n                </button>\n                ","align":"center","_MODIFIERS":{}},"x":-100,"y":1,"width":80,"height":-1},{"type":"button","name":"cb_cancel","config":{"name":"cb_cancel","caption":"取消","enable":true,"visible":true,"size":"1","className":"","x":-200,"y":1,"width":80,"height":-1,"buttonStyle":"alt","buttonColorStyle":"primary","leftIcon":"","rightIcon":"","DOMName":"cb_cancel-30d10e0a14320db7d89972227bf45e1d","html":" \n                <button class=\"btn btn-alt btn-primary btn-xs\" \n                        id=\"cb_cancel-30d10e0a14320db7d89972227bf45e1d\">\n                       取消\n                </button>\n                ","align":"center","_MODIFIERS":{}},"x":-200,"y":1,"width":80,"height":-1}]}]},{"index":4,"rowCount":11,"columnCount":5,"guid":"1f6986f66d5ef34edac79777ccc4487e","name":"导入凭证号","gridLineVisible":false,"freezedRow":0,"freezedCol":0,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"exportExcelWithDDLB":false,"rows":[{"index":0,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":1,"height":36,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":2,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":3,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":4,"height":36,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":5,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":6,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":10},{"index":7,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":8,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":9,"height":36,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":10,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0}],"columns":[{"index":0,"width":20,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":2,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":3,"width":200,"width2":-1,"stretchWidth":10,"rowHeightAutoFit":false},{"index":4,"width":20,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0},{"row":0,"col":1,"PI":13},{"row":0,"col":2,"PI":1},{"row":0,"col":3,"PI":1},{"row":0,"col":4},{"row":1,"col":0,"PI":14},{"row":1,"col":1,"define":"凭证年月","PI":44},{"row":1,"col":2,"editable":true,"rowSpan":1,"colSpan":2,"alias":"ny","PI":45,"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM"}},{"row":1,"col":4},{"row":2,"col":0},{"row":2,"col":1,"PI":14},{"row":2,"col":2,"PI":46},{"row":2,"col":3,"PI":47},{"row":2,"col":4},{"row":3,"col":0},{"row":3,"col":1,"PI":48},{"row":3,"col":2,"define":"请将凭证号粘贴在此","rowSpan":1,"colSpan":2,"PI":49},{"row":3,"col":4},{"row":4,"col":0,"PI":14},{"row":4,"col":1,"define":"凭证号","PI":44},{"row":4,"col":2,"editable":true,"appData":{},"rowSpan":3,"colSpan":2,"alias":"pzh","placeholder":"请将凭证号粘贴在此","placeholderOnlyViewWhenEditing":false,"PI":50,"editstyle":{"editType":2}},{"row":4,"col":4},{"row":5,"col":0},{"row":5,"col":1,"PI":51},{"row":5,"col":4},{"row":6,"col":0},{"row":6,"col":1,"PI":2},{"row":6,"col":4},{"row":7,"col":0},{"row":7,"col":1},{"row":7,"col":2,"PI":42},{"row":7,"col":3,"PI":42},{"row":7,"col":4},{"row":9,"col":0},{"row":9,"col":1},{"row":9,"col":2},{"row":9,"col":3,"rowSpan":1,"colSpan":2,"bricks":[{"type":"button","name":"cb_cancel2","config":{"name":"cb_cancel2","caption":"取消","enable":true,"visible":true,"size":"1","className":"","x":-200,"y":1,"width":80,"height":-1,"buttonStyle":"alt","buttonColorStyle":"primary","leftIcon":"","rightIcon":"","DOMName":"cb_cancel2-738169d1b1ee819153f29aa95a240bcc","html":" \n                <button class=\"btn btn-alt btn-primary btn-xs\" \n                        id=\"cb_cancel2-738169d1b1ee819153f29aa95a240bcc\">\n                       取消\n                </button>\n                "},"x":-200,"y":1,"width":80,"height":-1},{"type":"button","name":"cb_comfirn2","config":{"name":"cb_comfirn2","caption":"确定","enable":true,"visible":true,"size":"1","className":"","x":-100,"y":1,"width":80,"height":-1,"buttonStyle":"default","buttonColorStyle":"primary","leftIcon":"","rightIcon":"","DOMName":"cb_comfirn2-589335b9e420740d0cdeea3877687749","html":" \n                <button class=\"btn  btn-primary btn-xs\" \n                        id=\"cb_comfirn2-589335b9e420740d0cdeea3877687749\">\n                       确定\n                </button>\n                "},"x":-100,"y":1,"width":80,"height":-1}]}]}],"propertyCache":{"74f2bdf621230fb15ab3899dd9d9d674":{"font-size":24,"font-family":"微软雅黑","text-align":2},"125018f3eef635c9d10037c06e4a0236":{"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1]},"47a00a41624c6383ac8392dd4e2d2817":{"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1]},"a1185a5b50eb8c3017a1622a3ac6a623":{"background-color":"#f2f4f4","color":"#34495e","text-align":2,"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],"font-size":12},"608fd8c8f9915b1a0fe67a747a0231c3":{"color":"#34495e","border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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],"font-size":12},"f4b86ac0e723a7ae62db425ec2501ddb":{"color":"#34495e","text-align":2,"border-right-style":1,"border-right-width":1,"border-right-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-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"font-size":12},"4df23586299f4d3e384810dd3452a763":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-right-color":[128,128,128,1],"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],"text-align":2},"ac0b70e37db80f10483f5a7b9041d037":{"font-size":12,"border-left-color":[128,128,128,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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],"background-color":"rgb(244, 246, 246)"},"2bfc00e6706559c7b48ab503f38f93f1":{"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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],"font-size":12},"20118c09fa9c7e8fb2753e163d4f4c03":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1]},"65db2281b66b0f51c3dda0fc11dec250":{"color":"#34495e","border-right-style":1,"border-right-width":1,"border-right-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-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"font-size":12},"1d58ce6e4fcb79477b8f0124d8c593d7":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"font-size":12,"border-bottom-width":2,"border-bottom-color":[128,128,128,1]},"3f7d2667bbbebaf998952dc4155d99c7":{"font-size":12,"border-bottom-width":2,"border-bottom-color":[128,128,128,1]},"3736221b6320a5ed99534cefdf10ef9b":{"border-bottom-width":2,"border-bottom-color":[128,128,128,1]},"d40439625fae1006a802f59daeb608c1":{"border-right-width":2,"border-right-color":[128,128,128,1]},"944a3e9ce69b9ea01b4005ce4a062f71":{"border-top-width":2,"border-top-color":[128,128,128,1],"border-left-width":2,"border-left-color":[128,128,128,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"border-right-color":[128,128,128,1]},"0ce1d809397906f138d88bb0b74e7c5a":{"border-top-width":2,"border-top-color":[128,128,128,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"border-right-color":[128,128,128,1],"border-left-color":[128,128,128,1]},"63195811ce7146164a496732a73d6388":{"border-right-width":2,"border-right-color":[128,128,128,1],"border-top-width":2,"border-top-color":[128,128,128,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"border-left-color":[128,128,128,1]},"3749828a2f4e560e94e519058d334bd0":{"border-left-width":2,"border-left-color":[128,128,128,1]},"5e4df84994cee3dc53009c98b95703cf":{"border-top-width":2,"border-top-color":[128,128,128,1]},"36d996bc3335eb3693f0ed91210de509":{"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"font-size":12,"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]},"9a883adb2ac3fc004f80d96d546f56de":{"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"font-size":12,"border-top-width":2,"border-top-color":[128,128,128,1],"border-right-color":[128,128,128,1],"border-left-color":[128,128,128,1]},"a8e2666d88860904c145a9b8fa3e21eb":{"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"font-size":12,"border-right-width":2,"border-right-color":[128,128,128,1],"border-top-width":2,"border-top-color":[128,128,128,1],"border-left-color":[128,128,128,1]},"3bec917abe054f85b7e0cdee27df13eb":{"font-size":12,"border-left-width":2,"border-left-color":[128,128,128,1]},"19317b025d921368c0b2c42762aa384e":{"font-size":12},"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]},"cef87f90f886a52992fe559bc31852ff":{"color":"#34495e","text-align":2,"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],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"font-size":12},"745109885f3043de3ba0f0c0034d281b":{"color":"#34495e","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],"font-size":12},"1828e2ca56e03101e75e1c05f33a571b":{"font-family":"FontAwesome","font-size":12,"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-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"text-align":2,"color":"rgb(24, 160, 255)"},"6012181ae30937a87c306a5400775cb6":{"font-family":"FontAwesome","font-size":12,"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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],"text-align":2,"color":"rgb(202, 111, 30)"},"c823f66b7998029fe9832eeaff549c75":{"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-size":12},"6f82cdf59323396b8d6042aad39a9219":{"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)","font-size":12,"text-align":2},"e6ce761213771e6e15f8ac90b609d862":{"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)","font-size":12},"d26aa28348ca0e4bee939173b55f0925":{"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],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"background-color":"rgb(242, 244, 244)","text-align":2},"7290b407ce76ad7affeca62897e05977":{"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],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"background-color":"rgb(242, 244, 244)"},"ce829e8789544053353a5ceab1dfcb8c":{"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],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"background-color":"rgb(242, 244, 244)","font-family":"微软雅黑"},"7861da4670a78233a52f8cf4751c3903":{"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-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],"text-align":2},"ae39f7e27c8b7b926c2f936f95ed400a":{"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-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]},"bf8a8d50206ddb6b1d52a0cd027e638d":{"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-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],"font-family":"微软雅黑"},"a48412dbc6fff4ed999efc2dad989a36":{"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-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],"text-align":0,"font-family":"微软雅黑"},"fd31d0c6976419eac287f1ad7fa1b2d5":{"font-family":"FontAwesome","border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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],"font-size":12,"font-underline":true,"color":"rgb(230, 126, 34)","text-align":2},"cdac3cb5a17f3131fc8d8a7eb9ac78fb":{"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-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],"text-align":2,"font-family":"微软雅黑"},"fc406aa51250ead084dba7e6ed9e7117":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1]},"c3f6434a348b14637cfef1380ba3b95e":{"color":"#34495e","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],"font-size":12,"font-family":"微软雅黑"},"cba671b449fecd968d5cf1e825eabcd2":{"background-color":"rgb(255, 255, 255)","color":"#34495e","text-align":2,"border-left-width":2,"border-left-color":[128,128,128,1],"border-top-width":2,"border-top-color":[128,128,128,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"font-size":12},"98ea1659d735d986060d2b7a5d55c004":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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]},"d62603227cb6c78a0443a61f4bf2ebf6":{"border-left-width":2,"border-left-color":[128,128,128,1],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"border-right-color":[128,128,128,1]},"81137ffe647a2e54500d6829a93cc058":{"border-right-width":2,"border-right-color":[128,128,128,1],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1],"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"border-left-color":[128,128,128,1]},"cd00525b8f09c5b1f31d172b6a748610":{"border-bottom-width":2,"border-bottom-color":[128,128,128,1],"border-top-width":2,"border-top-color":[128,128,128,1]},"334cbfc63b3655d5933101f83719902d":{"border-top-width":2,"border-top-color":[128,128,128,1],"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1],"font-size":11,"vertical-align":1,"color":"rgb(153, 163, 164)"},"21982b8252459308f2f86ae9f8e5826a":{"border-left-style":1,"border-left-width":1,"border-left-color":[211,211,211,1],"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"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],"word-wrap":true,"vertical-align":0,"text-align":0,"padding-left":10,"padding-top":10,"padding-right":10,"padding-bottom":10},"29eba880a8621eaf333aa2ee9d70a596":{"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1],"border-top-width":2,"border-top-color":[128,128,128,1]}},"propertyIdList":["74f2bdf621230fb15ab3899dd9d9d674","125018f3eef635c9d10037c06e4a0236","47a00a41624c6383ac8392dd4e2d2817","a1185a5b50eb8c3017a1622a3ac6a623","608fd8c8f9915b1a0fe67a747a0231c3","f4b86ac0e723a7ae62db425ec2501ddb","4df23586299f4d3e384810dd3452a763","ac0b70e37db80f10483f5a7b9041d037","2bfc00e6706559c7b48ab503f38f93f1","20118c09fa9c7e8fb2753e163d4f4c03","65db2281b66b0f51c3dda0fc11dec250","1d58ce6e4fcb79477b8f0124d8c593d7","3f7d2667bbbebaf998952dc4155d99c7","3736221b6320a5ed99534cefdf10ef9b","d40439625fae1006a802f59daeb608c1","944a3e9ce69b9ea01b4005ce4a062f71","0ce1d809397906f138d88bb0b74e7c5a","63195811ce7146164a496732a73d6388","3749828a2f4e560e94e519058d334bd0","5e4df84994cee3dc53009c98b95703cf","36d996bc3335eb3693f0ed91210de509","9a883adb2ac3fc004f80d96d546f56de","a8e2666d88860904c145a9b8fa3e21eb","3bec917abe054f85b7e0cdee27df13eb","19317b025d921368c0b2c42762aa384e","582e6ff7dcbc794e847c24ddd7d496b7","cef87f90f886a52992fe559bc31852ff","745109885f3043de3ba0f0c0034d281b","1828e2ca56e03101e75e1c05f33a571b","6012181ae30937a87c306a5400775cb6","c823f66b7998029fe9832eeaff549c75","6f82cdf59323396b8d6042aad39a9219","e6ce761213771e6e15f8ac90b609d862","d26aa28348ca0e4bee939173b55f0925","7290b407ce76ad7affeca62897e05977","ce829e8789544053353a5ceab1dfcb8c","7861da4670a78233a52f8cf4751c3903","ae39f7e27c8b7b926c2f936f95ed400a","bf8a8d50206ddb6b1d52a0cd027e638d","a48412dbc6fff4ed999efc2dad989a36","fd31d0c6976419eac287f1ad7fa1b2d5","cdac3cb5a17f3131fc8d8a7eb9ac78fb","fc406aa51250ead084dba7e6ed9e7117","c3f6434a348b14637cfef1380ba3b95e","cba671b449fecd968d5cf1e825eabcd2","98ea1659d735d986060d2b7a5d55c004","d62603227cb6c78a0443a61f4bf2ebf6","81137ffe647a2e54500d6829a93cc058","cd00525b8f09c5b1f31d172b6a748610","334cbfc63b3655d5933101f83719902d","21982b8252459308f2f86ae9f8e5826a","29eba880a8621eaf333aa2ee9d70a596"]}


id: 66a3075c993295696042f86d
pid: 66a3075c993295696042f86c
name: ui
nodetype: column
createdate: 2024.07.26 10:18:05.000
lastmodifieddate: 2024.09.18 14:41:00.711
value:
{"version":"1.0","sheetcount":1,"gui":true,"theme":"default","showTabOnBottom":false,"runtimeOptions":{},"sheets":[{"index":0,"rowCount":20,"columnCount":8,"guid":"ea9949b0181a7a4fb8535841acb6e1ec","name":"Sheet1","gridLineVisible":true,"freezedRow":0,"freezedCol":0,"bottomFreezedRow":0,"ignoreBeforeRowWhenPrinting":0,"forDevice":"all","canSetColumnVisible":false,"exportExcelWithDDLB":false,"rows":[{"index":0,"height":53,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":1,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":2,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":3,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":4,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":5,"height":32,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":6,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":7,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":8,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":9,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":10,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":11,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":12,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":13,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":14,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":15,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":16,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":17,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":18,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0},{"index":19,"height":25,"isColumnScrollEnabled":true,"multiRowDataSourceName_manual":"","isGroupTopArea":false,"isGroupBottomArea":false,"stretchHeight":0}],"columns":[{"index":0,"width":19,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":1,"width":45,"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":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":5,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":6,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false},{"index":7,"width":100,"width2":-1,"stretchWidth":0,"rowHeightAutoFit":false}],"focusRange":[],"cells":[{"row":0,"col":0},{"row":0,"col":1,"define":"会记凭证状态统计","rowSpan":1,"colSpan":6,"PI":0},{"row":0,"col":7},{"row":1,"col":0},{"row":1,"col":1,"PI":1},{"row":1,"col":2,"PI":1},{"row":1,"col":3},{"row":1,"col":4,"PI":1},{"row":1,"col":5,"PI":1},{"row":1,"col":6,"PI":1},{"row":1,"col":7},{"row":2,"col":0,"PI":2},{"row":2,"col":1,"define":"序号","PI":3},{"row":2,"col":2,"define":"账套号","PI":3,"bricks":[{"type":"filterButton","name":"cb_filter_q1_corpid","config":{"name":"cb_filter_q1_corpid","caption":"过滤","enable":true,"visible":true,"action":"filter","x":-21,"y":1,"width":0,"height":20,"normalColor":"LightSteelBlue","lightColor":"red","dsn":"q1","dbcol":"corpid","wherecol":"","editStyle":{"ddlbInnerItems":"","ddlbName":"basic_账套列表(code2name)-简称","columnCount":1,"ddlbFilterContext":"","ddlbFilterBy":""},"DOMName":"cb_filter_q1_corpid-558bc687fcad54a4a4f43970c42d1393","html":" \n                <button   id=\"cb_filter_q1_corpid-558bc687fcad54a4a4f43970c42d1393\" \n                    style=\"border:0 ; background-color: transparent; outline: none; width:20px; height:20px; color:LightSteelBlue \"  >\n                    <i class=\"fa fa-filter\"></i></button>\n                ","dataType":3},"x":-21,"y":1,"width":0,"height":20}]},{"row":2,"col":3,"define":"凭证年月","PI":3,"bricks":[{"type":"filterButton","name":"cb_filter_q1_ny","config":{"name":"cb_filter_q1_ny","caption":"过滤","enable":true,"visible":true,"action":"filter","x":-21,"y":1,"width":0,"height":20,"normalColor":"LightSteelBlue","lightColor":"red","dsn":"q1","dbcol":"ny","wherecol":"","editStyle":{"ddlbInnerItems":"","ddlbName":"","columnCount":1,"ddlbFilterContext":"","ddlbFilterBy":""},"DOMName":"cb_filter_q1_ny-99ac86b76d326aaded76a565d81e722c","html":" \n                <button   id=\"cb_filter_q1_ny-99ac86b76d326aaded76a565d81e722c\" \n                    style=\"border:0 ; background-color: transparent; outline: none; width:20px; height:20px; color:LightSteelBlue \"  >\n                    <i class=\"fa fa-filter\"></i></button>\n                ","dataType":4},"x":-21,"y":1,"width":0,"height":20}]},{"row":2,"col":4,"define":"凭证号","PI":3,"bricks":[{"type":"filterButton","name":"cb_filter_q1_pzh","config":{"name":"cb_filter_q1_pzh","caption":"过滤","enable":true,"visible":true,"action":"filter","x":-21,"y":1,"width":0,"height":20,"normalColor":"LightSteelBlue","lightColor":"red","dsn":"q1","dbcol":"pzh","wherecol":"","editStyle":{"ddlbInnerItems":"","ddlbName":"","columnCount":1,"ddlbFilterContext":"","ddlbFilterBy":""},"DOMName":"cb_filter_q1_pzh-31c031b3e7b0a8c9df2ca51a86c223d4","html":" \n                <button   id=\"cb_filter_q1_pzh-31c031b3e7b0a8c9df2ca51a86c223d4\" \n                    style=\"border:0 ; background-color: transparent; outline: none; width:20px; height:20px; color:LightSteelBlue \"  >\n                    <i class=\"fa fa-filter\"></i></button>\n                ","dataType":3},"x":-21,"y":1,"width":0,"height":20}]},{"row":2,"col":5,"define":"交办状态","PI":3,"bricks":[{"type":"filterButton","name":"cb_filter_q1_jb_state","config":{"name":"cb_filter_q1_jb_state","caption":"过滤","enable":true,"visible":true,"action":"filter","x":-21,"y":1,"width":0,"height":20,"normalColor":"LightSteelBlue","lightColor":"red","dsn":"q1","dbcol":"jb_state","wherecol":"","editStyle":{"ddlbInnerItems":"","ddlbName":"","columnCount":1,"ddlbFilterContext":"","ddlbFilterBy":""},"DOMName":"cb_filter_q1_jb_state-88ff1f7a5b935a2d396be9166f11b476","html":" \n                <button   id=\"cb_filter_q1_jb_state-88ff1f7a5b935a2d396be9166f11b476\" \n                    style=\"border:0 ; background-color: transparent; outline: none; width:20px; height:20px; color:LightSteelBlue \"  >\n                    <i class=\"fa fa-filter\"></i></button>\n                ","dataType":3},"x":-21,"y":1,"width":0,"height":20}]},{"row":2,"col":6,"define":"借阅状态","PI":3,"bricks":[{"type":"filterButton","name":"cb_filter_q1_jy_state","config":{"name":"cb_filter_q1_jy_state","caption":"过滤","enable":true,"visible":true,"action":"filter","x":-21,"y":1,"width":0,"height":20,"normalColor":"LightSteelBlue","lightColor":"red","dsn":"q1","dbcol":"jy_state","wherecol":"","editStyle":{"ddlbInnerItems":"","ddlbName":"","columnCount":1,"ddlbFilterContext":"","ddlbFilterBy":""},"DOMName":"cb_filter_q1_jy_state-d724f973c77fc98ad1f8b5d0562fa714","html":" \n                <button   id=\"cb_filter_q1_jy_state-d724f973c77fc98ad1f8b5d0562fa714\" \n                    style=\"border:0 ; background-color: transparent; outline: none; width:20px; height:20px; color:LightSteelBlue \"  >\n                    <i class=\"fa fa-filter\"></i></button>\n                ","dataType":3},"x":-21,"y":1,"width":0,"height":20}]},{"row":2,"col":7},{"row":3,"col":0,"PI":2},{"row":3,"col":1,"PI":4,"bind":{"dataSource":"q1","DBCol":"c_inner_xh","dsType":2},"editstyle":{"editType":1,"showComma":true,"decimalCount":0,"zeroVisible":true}},{"row":3,"col":2,"cellValueType":3,"PI":5,"bind":{"dataSource":"q1","DBCol":"corpid","dsType":2},"editstyle":{"editType":4,"ddlbName":"basic_账套列表(code2name)-简称","dropDownListEditable":false,"valueMustInDDLB":false,"ddlbFilterBy":"","ddlbMultiSelect":false,"ddlbFilterContext":"","ddlbInnerItems":"","showRealData":false,"columnCount":null}},{"row":3,"col":3,"cellValueType":4,"PI":4,"bind":{"dataSource":"q1","DBCol":"ny","dsType":2},"editstyle":{"editType":3,"datetimeFormat":"yyyy.MM"}},{"row":3,"col":4,"cellValueType":3,"PI":4,"bind":{"dataSource":"q1","DBCol":"pzh","dsType":2},"editstyle":{"editType":0,"inputAttribute":""}},{"row":3,"col":5,"cellValueType":3,"PI":5,"bind":{"dataSource":"q1","DBCol":"jb_state","dsType":2}},{"row":3,"col":6,"cellValueType":3,"PI":5,"bind":{"dataSource":"q1","DBCol":"jy_state","dsType":2}},{"row":3,"col":7},{"row":4,"col":0},{"row":4,"col":1,"PI":6},{"row":4,"col":2,"PI":6},{"row":4,"col":3},{"row":4,"col":4,"PI":6},{"row":4,"col":5,"PI":6},{"row":4,"col":6,"PI":6},{"row":4,"col":7},{"row":5,"col":0},{"row":5,"col":1,"rowSpan":1,"colSpan":6,"bricks":[{"type":"dbpage","name":"dbnav","config":{"name":"dbnav","caption":"分页导航条","enable":true,"visible":true,"showDBRowCount":true,"x":1,"y":1,"width":-1,"height":-1,"align":"center","onceRetrieveRowCount":"100","countPerPagePermitToChange":true,"dsn":"q1","DOMName":"dbnav-6f16f1bf15ffbb47f17ecf2a8a1c1fd1","html":" \n                   <style>\n                   .workbook_db_tool_button {border-radius: 50%; min-width:24px; width:24px; height:24px; padding:0px;margin-right:5px;}\n                   .workbook_db_tool_noborder { border:0px solid #fff; background-color:transparent;}\n                   </style>     \n                   \n        \n                <div  class=\"   \"  id=\"dbnav-6f16f1bf15ffbb47f17ecf2a8a1c1fd1\"  \n          \n                       style=\" padding:2px;min-width:24px; padding-right:8px;padding-left:8px; user-select:none; text-align:center;\">\n                        \n                       <span class=\"group1\" style=\"display:none;\"><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page1 workbook_db_tool_button\" >1</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page2 workbook_db_tool_button\" >2</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page3 workbook_db_tool_button\" >3</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page4 workbook_db_tool_button\" >4</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page5 workbook_db_tool_button\" >5</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page6 workbook_db_tool_button\" >6</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page7 workbook_db_tool_button\" >7</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page8 workbook_db_tool_button\" >8</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page9 workbook_db_tool_button\" >9</button><button \n                       type=\"button\"   class=\"btn   btn-xs btn-default cb_page10 workbook_db_tool_button\" >10</button>\n                       </span><span class=\"group2\">\n                        <button type=\"button\"   class=\"btn   btn-xs btn-default cb_First workbook_db_tool_button\" >\n                        <i class=\"fa fa-step-backward\"></i></button><button type=\"button\"   \n                                class=\"btn   btn-xs btn-default cb_Prior workbook_db_tool_button\" >\n                        <i class=\"fa fa-chevron-left\"></i></button><button type=\"button\"   \n                                class=\"btn btn-alt btn-xs btn-default  workbook_db_tool_noborder \" ><span style=\"display:inline-block\">\n                        <input type=\"tel\"  class=\"pageIndex btn btn-alt btn-xs \" \n                               style=\"width:50px;height:24px; line-height:24px ; border-radius:12px; border:1px dotted #efefef;\"> /\n                        <span class=\"pageCountOfDataSource\"></span></button><button type=\"button\"   \n                                class=\"btn   btn-xs btn-default cb_Next workbook_db_tool_button\" >\n                        <i class=\"fa fa-chevron-right\"></i></button><button type=\"button\"   \n                                class=\"btn   btn-xs btn-default cb_Last workbook_db_tool_button\" >\n                        <i class=\"fa fa-step-forward\"></i></button></span><span \n                         style=\"padding-left:10px; display:inline-block user-select:none;\"  \n                               class=\"countPerPageContainer\">每页\n                               <select type=\"tel\"   class=\"countPerPage\"  \n                               style=\"width:65px;height:24px; line-height:24px;border-radius: 12px; padding-top: 0px;padding-bottom:0px;padding-left:10px;padding-right:10px; \"><option  value=\"100\" selected>100</option><option value=\"输入\">输入</option></select>\n                               <input type=\"tel\" class=\"countPerPageInput\" style=\"width:65px;height:24px; line-height:24px;border-radius: 12px; padding-top: 0px;padding-bottom:0px;padding-left:10px;padding-right:10px;display:none; \">\n                              \n                                行</span>\n                        </span>\n                        <span class=\"dbRowCountContainer\"  >&nbsp;&nbsp;共<span class=\"dbrowcount\"></span>行\n                </div>\n            \n            "},"x":0,"y":0,"width":0,"height":0}]},{"row":5,"col":7},{"row":6,"col":0},{"row":6,"col":1},{"row":6,"col":2},{"row":6,"col":3},{"row":6,"col":4},{"row":6,"col":5},{"row":6,"col":6},{"row":6,"col":7}]}],"propertyCache":{"f860b0010348a6042621f05524bdb546":{"text-align":2,"font-size":22,"font-family":"微软雅黑"},"125018f3eef635c9d10037c06e4a0236":{"border-bottom-style":1,"border-bottom-width":1,"border-bottom-color":[211,211,211,1]},"47a00a41624c6383ac8392dd4e2d2817":{"border-right-style":1,"border-right-width":1,"border-right-color":[211,211,211,1]},"08d9943155e666348612b91756b72495":{"background-color":"#f2f4f4","color":"#34495e","text-align":2,"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]},"2765984ba77638f11f3997b55470f816":{"color":"#34495e","text-align":2,"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],"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1]},"1bd04ff0135f27daee91bd2023c7eb35":{"color":"#34495e","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]},"fc406aa51250ead084dba7e6ed9e7117":{"border-top-style":1,"border-top-width":1,"border-top-color":[211,211,211,1]}},"propertyIdList":["f860b0010348a6042621f05524bdb546","125018f3eef635c9d10037c06e4a0236","47a00a41624c6383ac8392dd4e2d2817","08d9943155e666348612b91756b72495","2765984ba77638f11f3997b55470f816","1bd04ff0135f27daee91bd2023c7eb35","fc406aa51250ead084dba7e6ed9e7117"]}


id: 66a3075c993295696042f870
pid: 66a3075c993295696042f86c
name: db
nodetype: column
createdate: 2024.07.26 10:18:05.000
lastmodifieddate: 2024.09.18 14:41:00.711
value:
[{"name":"q1","label":"","type":"query","dbpool":"default","description":"","multirow":true,"dynamicwhere":"","dynamicwhere2":"","dynamicwheredata2":"","dynamicwhere2_tokens":"{}","sqlinject":"true","importfromexcelpermit":"false","dbpool_expression":"","updatedtable":"","updatedtable2":"","groupby":"","smartretrieveothers":"","sql":"select jb.* , jh.state ,jy.state,gh.state\n    , case when jb.state='0' then '交办申请中' \n      when jb.state='-1' then '交办退回' \n      when jb.state='1' and jh.state='0' then '交回申请中' \n      when jb.state='1' and jh.state='-1' then '交回退回' \n      when jb.state='1' and jh.state='1' then '交办且已交回' \n      when jb.state='1'  then '交办没有交回' \n     else '' end as jb_state\n\n    , case when jy.state='0'  then '借阅申请中' \n      when jy.state='-1' then '借阅退回' \n      when jy.state='1' and gh.state='0'  then '归还申请中' \n      when jy.state='1' and gh.state=-1 then '归还退回' \n      when jy.state='1' and gh.state='1' then '借阅且已归还' \n      when jy.state='1' then '借阅没有归还' \n     else '' end as jy_state\n    \n     from (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state, a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state,b1.flow_instance_status,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交办' and state not in (-99) )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交办' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) jb \n    left join (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny,  a.state, a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交回' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交回' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) jh on jb.corpid_ny_pzh=jh.corpid_ny_pzh\n    left join (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state,  a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='借阅' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='借阅' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) jy on jb.corpid_ny_pzh=jy.corpid_ny_pzh\n    left join (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state,  a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='归还' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='归还' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) gh  on jb.corpid_ny_pzh=gh.corpid_ny_pzh\n    \n    order by jb.lastmodifieddate desc","sqldefine":"select jb.* , jh.state ,jy.state,gh.state\n    , case when jb.state='0' then '交办申请中' \n      when jb.state='-1' then '交办退回' \n      when jb.state='1' and jh.state='0' then '交回申请中' \n      when jb.state='1' and jh.state='-1' then '交回退回' \n      when jb.state='1' and jh.state='1' then '交办且已交回' \n      when jb.state='1'  then '交办没有交回' \n     else '' end as jb_state\n\n    , case when jy.state='0'  then '借阅申请中' \n      when jy.state='-1' then '借阅退回' \n      when jy.state='1' and gh.state='0'  then '归还申请中' \n      when jy.state='1' and gh.state=-1 then '归还退回' \n      when jy.state='1' and gh.state='1' then '借阅且已归还' \n      when jy.state='1' then '借阅没有归还' \n     else '' end as jy_state\n    \n     from (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state, a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state,b1.flow_instance_status,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交办' and state not in (-99) )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交办' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) jb \n    left join (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny,  a.state, a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交回' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='交回' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) jh on jb.corpid_ny_pzh=jh.corpid_ny_pzh\n    left join (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state,  a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='借阅' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='借阅' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) jy on jb.corpid_ny_pzh=jy.corpid_ny_pzh\n    left join (\n        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state,  a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status\n    from (\n        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='归还' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  \n        ) a \n        inner  join  (\n            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh \n        from ( select * from pz_yjd_pzh where billtype='归还' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  \n        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate \n    ) gh  on jb.corpid_ny_pzh=gh.corpid_ny_pzh\n    \n    order by jb.lastmodifieddate desc","primarykey":"","autoretrieve":true,"needcache":"false","cacheserver":"","cachetimeout":30,"gguidinject":"false","oncerowcountdefault":"10","oncerowcountlimit":"0","rowcountlimit":"0","rowcountonce":"50000","table_query_id":"66a3075c993295696042f8cd","column":[{"name":"lastmodifieddate","label":"lastmodifieddate","description":"","type":"datetime","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"corpid_ny_pzh","label":"corpid_ny_pzh","description":"","type":"varchar(69)","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"ny","label":"凭证年月","description":"","type":"datetime","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"pzh","label":"凭证号","description":"","type":"varchar(40)","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"corpid","label":"corpid","description":"","type":"varchar(10)","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"flow_instance_state","label":"flow_instance_state","description":"","type":"int","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"jb_state","label":"jb_state","description":"","type":"varchar(6)","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"jy_state","label":"jy_state","description":"","type":"varchar(6)","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"flow_instance_status","label":"flow_instance_status","description":"","type":"varchar(500)","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"state","label":"签收状态","description":"","type":"int","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""},{"name":"pz_yjd_pzh_state","label":"签收状态","description":"","type":"int","nullable":true,"smartretrieve":false,"exceltemplateincludeme":true,"smartretrievecolname":"","dict":"","exportformat":"","encryptmode":"","editstyle":"","cloneable":false,"updatable":"","datamask":"","modifylog":"","usedingroupby":"","usedinsum":"","defaultvalue":"","dbdefaultvalue":""}],"computer":[{"name":"c_inner_xh","label":"序号","expression":"thisrow()+1","aggregatetype":"","description":"","fillback":""}]}]


# app_db

id: 609d3dcf5db2b0a331d6bbfd
pid: 609d3dcf5db2b0a331d6bbf8
name: sql
code: 609d3dcf5db2b0a331d6bbfd
namepath: /dzpz_imgpool
codepath: 609d3dcf5db2b0a331d6bbf8
fullname: /dzpz_imgpool/sql
fullcode: 609d3dcf5db2b0a331d6bbf8.609d3dcf5db2b0a331d6bbfd
nodetype: column
createdate: 2021.05.13 22:55:13.000
lastmodifieddate: 2024.09.18 14:41:03.545
value:
select dzpz_imgpool.*  ,
(select count(*) from dzpz_imgpool_fileupload b where b.gguid=dzpz_imgpool.gguid and ifnull(info2,'')='') as c1 ,
(select count(*) from dzpz_imgpool_fileupload b where b.gguid=dzpz_imgpool.gguid and ifnull(info2,'')='回收站') as c2  

from  dzpz_imgpool   where ifnull(deleteflag,0)=0


id: 60ab31c65db2f37491f998ae
pid: 60ab2c6e5db2f37491f997fe
name: sql
code: 60ab31c65db2f37491f998ae
namepath: /dzpz_pz
codepath: 60ab2c6e5db2f37491f997fe
fullname: /dzpz_pz/sql
fullcode: 60ab2c6e5db2f37491f997fe.60ab31c65db2f37491f998ae
nodetype: column
createdate: 2021.05.24 12:59:01.000
lastmodifieddate: 2024.09.18 14:41:06.431
value:
select
  id,
  pz,
  pzh,
  userid,
  username,
  verifieddate,
  verifierid,
  verifiername,
  xm,
  ym,
  case when verifierid > 0 then 1 else 0 end as verified
from
  dzpz_pz
order by
  pzh desc


id: 60ab31c65db2f37491f998af
pid: 60ab2c6e5db2f37491f997fe
name: dynamicwheredata2
code: 60ab31c65db2f37491f998af
namepath: /dzpz_pz
codepath: 60ab2c6e5db2f37491f997fe
fullname: /dzpz_pz/dynamicwheredata2
fullcode: 60ab2c6e5db2f37491f997fe.60ab31c65db2f37491f998af
nodetype: column
createdate: 2021.05.24 12:59:01.000
lastmodifieddate: 2024.09.18 14:41:06.431
value:
corpid:凭证清单!corpid
pzh: 凭证清单!pzh
ym:凭证清单!ym
st_datetype:凭证清单!st_datetype
st_date1: date2yyyymmdd( 凭证清单!st_date1)
st_date2: date2yyyymmdd( 凭证清单!st_date2)
st_key1:凭证清单!st_key1
st_value1:凭证清单!st_value1
is_about_me:凭证清单!is_about_me


id: 60ab31c65db2f37491f998b0
pid: 60ab2c6e5db2f37491f997fe
name: dynamicwhere2
code: 60ab31c65db2f37491f998b0
namepath: /dzpz_pz
codepath: 60ab2c6e5db2f37491f997fe
fullname: /dzpz_pz/dynamicwhere2
fullcode: 60ab2c6e5db2f37491f997fe.60ab31c65db2f37491f998b0
nodetype: column
createdate: 2021.05.24 12:59:01.000
lastmodifieddate: 2024.09.18 14:41:06.431
value:
" corpid='"+ corpid+"'  "
" ym="+ym 
st_key1+"  like  '%"+ st_value1+"%' "
st_datetype +" >='"+ st_date1+"' "
st_datetype +" <'"+ date2yyyymmdd(nextDate(yyyymmdd2Date(st_date2),1))+"' "


id: 60ab31c65db2f37491f998b1
pid: 60ab2c6e5db2f37491f997fe
name: dynamicwhere2_tokens
code: 60ab31c65db2f37491f998b1
namepath: /dzpz_pz
codepath: 60ab2c6e5db2f37491f997fe
fullname: /dzpz_pz/dynamicwhere2_tokens
fullcode: 60ab2c6e5db2f37491f997fe.60ab31c65db2f37491f998b1
nodetype: column
createdate: 2021.05.24 12:59:01.000
lastmodifieddate: 2024.09.18 14:41:06.431
value:
{
    "\" corpid='\"+ corpid+\"'  \"": "corpid",
    "\" ym=\"+ym": "ym",
    "st_key1+\"  like  '%\"+ st_value1+\"%' \"": "st_key1,st_value1",
    "st_datetype +\" >='\"+ st_date1+\"' \"": "st_datetype,st_date1",
    "st_datetype +\" <'\"+ date2yyyymmdd(nextDate(yyyymmdd2Date(st_date2),1))+\"' \"": "st_datetype,st_date2"
}


id: 60ab9dd75db2a837c83ac52b
pid: 60a31c475db27838e0c0134b
name: dynamicwhere2
code: 60ab9dd75db2a837c83ac52b
namepath: /dzpz_pz
codepath: 60a31c475db27838e0c0134b
fullname: /dzpz_pz/dynamicwhere2
fullcode: 60a31c475db27838e0c0134b.60ab9dd75db2a837c83ac52b
nodetype: column
createdate: 2021.05.24 20:51:58.000
lastmodifieddate: 2024.09.18 14:41:06.834
value:
"  corpid='"+ corpid+"' "
"ym="+ym
"pzh like '%"+pzh+"%' "
" bm like '%"+bm+"%' "
 " labeldata->'$."+'"'+labelname+ '"'+ "'  like  '%"+labelvalue+"%' "


id: 60ab9dd75db2a837c83ac52c
pid: 60a31c475db27838e0c0134b
name: dynamicwhere2_tokens
code: 60ab9dd75db2a837c83ac52c
namepath: /dzpz_pz
codepath: 60a31c475db27838e0c0134b
fullname: /dzpz_pz/dynamicwhere2_tokens
fullcode: 60a31c475db27838e0c0134b.60ab9dd75db2a837c83ac52c
nodetype: column
createdate: 2021.05.24 20:51:58.000
lastmodifieddate: 2024.09.18 14:41:06.834
value:
{
    "\"  corpid='\"+ corpid+\"' \"": "corpid",
    "\"ym=\"+ym": "ym",
    "\"pzh like '%\"+pzh+\"%' \"": "pzh",
    "\" bm like '%\"+bm+\"%' \"": "bm",
    "\" labeldata->'$.\"+'\"'+labelname+ '\"'+ \"'  like  '%\"+labelvalue+\"%' \"": "labelname,labelvalue"
}


id: 60abac6c5db2a837c83ac636
pid: 60aba1855db2a837c83ac5fe
name: sql
code: 60abac6c5db2a837c83ac636
namepath: /one
codepath: 60aba1855db2a837c83ac5fe
fullname: /one/sql
fullcode: 60aba1855db2a837c83ac5fe.60abac6c5db2a837c83ac636
nodetype: column
createdate: 2021.05.24 21:39:48.000
lastmodifieddate: 2024.09.18 14:41:07.222
value:
select
  id,
  pzh,
  url_img,
  url_thumbnail,
  attachmentcount,
  pz,
  fj,
  username,
  verifiername
from
  dzpz_pz


id: 60c1d5c49932e1a17db2e7a3
pid: 60c1d2bf9932e1a17db2e77c
name: sql
code: 60c1d5c49932e1a17db2e7a3
namepath: /query1
codepath: 60c1d2bf9932e1a17db2e77c
fullname: /query1/sql
fullcode: 60c1d2bf9932e1a17db2e77c.60c1d5c49932e1a17db2e7a3
nodetype: column
createdate: 2021.06.10 17:11:11.000
lastmodifieddate: 2024.09.18 14:41:07.618
value:
SELECT
  x.userid,
  x.username,
  x.corpid,
  x.ym,
  sum(x.op1) as op1,
  sum(case when x.op1 > 0 then pic_sl else 0 end) as op1_sl,
  sum(x.op2) as op2,
  sum(case when x.op2 > 0 then pic_sl else 0 end) as op2_sl
FROM(
    SELECT
      gguid,
      corpid,
      pzh,
      userid,
      username,
      ym,
      billdate,
      1 AS op1,
      0 AS op2
    FROM
      dzpz_pz
    WHERE
      userid IS NOT NULL
      and billdate >= ':st_date1{1900.01.01}'
      and billdate <= ':st_date2{9999.01.01}'
    UNION ALL
    SELECT
      gguid,
      corpid,
      pzh,
      verifierid AS userid,
      verifiername AS username,
      ym,
      verifieddate as billdate,
      0 AS op1,
      1 AS op2
    FROM
      dzpz_pz
    WHERE
      verifierid IS NOT NULL
      and verifieddate >= ':st_date1{1900.01.01}'
      and verifieddate <= ':st_date2{9999.01.01}'
  ) x
  left join (
    select
      gguid,
      count(id) as pic_sl
    from
      dzpz_pzfj
    group by
      gguid
  ) y on x.gguid = y.gguid
group by
  x.userid,
  x.username,
  x.corpid,
  x.ym
order by
  x.username,
  x.corpid,
  x.ym


id: 60c1d5c49932e1a17db2e7a4
pid: 60c1d2bf9932e1a17db2e77c
name: dynamicwheredata2
code: 60c1d5c49932e1a17db2e7a4
namepath: /query1
codepath: 60c1d2bf9932e1a17db2e77c
fullname: /query1/dynamicwheredata2
fullcode: 60c1d2bf9932e1a17db2e77c.60c1d5c49932e1a17db2e7a4
nodetype: column
createdate: 2021.06.10 17:11:11.000
lastmodifieddate: 2024.09.18 14:41:07.618
value:
st_corpid:main!corpid
st_date1:date2yyyymmdd(main!st_date1)
st_date2:date2yyyymmdd(nextDate(yyyymmdd2Date(date2yyyymmdd(main!st_date2)),1))
st_username:main!st_username


id: 60c1d5c49932e1a17db2e7a6
pid: 60c1d2bf9932e1a17db2e77c
name: dynamicwhere2_tokens
code: 60c1d5c49932e1a17db2e7a6
namepath: /query1
codepath: 60c1d2bf9932e1a17db2e77c
fullname: /query1/dynamicwhere2_tokens
fullcode: 60c1d2bf9932e1a17db2e77c.60c1d5c49932e1a17db2e7a6
nodetype: column
createdate: 2021.06.10 17:11:11.000
lastmodifieddate: 2024.09.18 14:41:07.618
value:
{
    "\"x.corpid='\"+st_corpid+\"'\"": "st_corpid",
    "\"x.username like '%\"+st_username+\"%'\"": "st_username"
}


id: 60c5615f5db2e8eff0d867d4
pid: 60c560a05db2e8eff0d867a8
name: sql
code: 60c5615f5db2e8eff0d867d4
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a8
fullname: /dzpz_pz/sql
fullcode: 60c560a05db2e8eff0d867a8.60c5615f5db2e8eff0d867d4
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:08.007
value:
select
  dzpz_pz.*,
  0 as selected,
  '' as tipinfo,
  case when verifierid is null then '校对' else '' end as c_sh1,
  case when verifierid is null then '' else '取消校对' end as c_sh2
from
  dzpz_pz
where
  isnull(deleteflag, 0) = 0
order by
  ym,
  pzh


id: 60c5615f5db2e8eff0d867d5
pid: 60c560a05db2e8eff0d867a8
name: dynamicwheredata2
code: 60c5615f5db2e8eff0d867d5
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a8
fullname: /dzpz_pz/dynamicwheredata2
fullcode: 60c560a05db2e8eff0d867a8.60c5615f5db2e8eff0d867d5
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:08.007
value:
st_corpid:main!st_corpid
shzt:main!shzt
ym:main!ym
st_username:main!st_username
pzh1:main!pzh_prefix+main!pzh1
pzh2:main!pzh_prefix+main!pzh2


id: 60c5615f5db2e8eff0d867d6
pid: 60c560a05db2e8eff0d867a8
name: dynamicwhere2
code: 60c5615f5db2e8eff0d867d6
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a8
fullname: /dzpz_pz/dynamicwhere2
fullcode: 60c560a05db2e8eff0d867a8.60c5615f5db2e8eff0d867d6
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:08.007
value:
"corpid='"+ st_corpid+"' "
iif( shzt==1, " verifierid is not null" , iif ( shzt==2, "verifierid is null ", ""))
"ym="+ym
"username="+st_username
"pzh >= '"+pzh1+"' "
"pzh <= '"+pzh2+"' "


id: 60c5615f5db2e8eff0d867d7
pid: 60c560a05db2e8eff0d867a8
name: dynamicwhere2_tokens
code: 60c5615f5db2e8eff0d867d7
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a8
fullname: /dzpz_pz/dynamicwhere2_tokens
fullcode: 60c560a05db2e8eff0d867a8.60c5615f5db2e8eff0d867d7
nodetype: column
createdate: 2021.06.13 09:37:38.000
lastmodifieddate: 2024.09.18 14:41:08.007
value:
{
    "\"corpid='\"+ st_corpid+\"' \"": "st_corpid",
    "iif( shzt==1, \" verifierid is not null\" , iif ( shzt==2, \"verifierid is null \", \"\"))": "shzt",
    "\"ym=\"+ym": "ym",
    "\"username=\"+st_username": "st_username",
    "\"pzh >= '\"+pzh1+\"' \"": "pzh1",
    "\"pzh <= '\"+pzh2+\"' \"": "pzh2"
}


id: 60c9faff9932d177d8ac6123
pid: 60c9bd189932d177d8ac5e81
name: sql
code: 60c9faff9932d177d8ac6123
namepath: /pzh_check
codepath: 60c9bd189932d177d8ac5e81
fullname: /pzh_check/sql
fullcode: 60c9bd189932d177d8ac5e81.60c9faff9932d177d8ac6123
nodetype: column
createdate: 2021.06.16 21:22:08.000
lastmodifieddate: 2024.09.18 14:41:09.558
value:
select
  a.pzh
from
  (
    select
      concat(
        ':pzh_prefix{}',
        right(concat('0000000000', id), :pzh_len { 4 })
      ) as pzh
    from
      app_int  -- 这个表就是一个整数序列表
    where
      id <= (
        select
          cast(right(max(b.pzh), :pzh_len { 4 }) as decimal) as maxpzh  --取出当月最大的凭证号的后几位去掉前缀
        from
          dzpz_pz b
        where
          b.ym = :ym { 202106 }
          and b.corpid = ':corpid{-}'
      )
  ) a  --  把从1 到 最大凭证号 构建一个凭证号码完成序列表 
where
  a.pzh not in (  --  不存在的就是
    select
      pzh
    from
      dzpz_pz b
    where
      b.ym = :ym { 202106 }
      and b.corpid = ':corpid{-}'
  )


id: 60fa608c9932563b7c99bbb1
pid: 60fa608c9932563b7c99bbac
name: sql
code: 60fa608c9932563b7c99bbb1
namepath: /dzpz_dy
codepath: 60fa608c9932563b7c99bbac
fullname: /dzpz_dy/sql
fullcode: 60fa608c9932563b7c99bbac.60fa608c9932563b7c99bbb1
nodetype: column
createdate: 2021.07.23 14:24:22.000
lastmodifieddate: 2024.09.18 14:41:11.546
value:
select
  *,0 as selected 
from
  dzpz_dy
where
  isnull(deleteflag, 0) = 0
  
      
      order by billno desc


id: 6114b2b59932563b7c99cc8c
pid: 6114a5109932563b7c99cc64
name: sql
code: 6114b2b59932563b7c99cc8c
namepath: /q_pzdjex
codepath: 6114a5109932563b7c99cc64
fullname: /q_pzdjex/sql
fullcode: 6114a5109932563b7c99cc64.6114b2b59932563b7c99cc8c
nodetype: column
createdate: 2021.08.12 13:35:30.000
lastmodifieddate: 2024.09.18 14:41:13.078
value:
select
  distinct 0 as selected,
  a.corpid,
  a.pzrq,
  a.y,
  a.m,
  a.pzh,
  a.kmdm,
  a.code,
  a.posted,
  a.bz,
  dzpz_id as doc_id,
  pzsl_pic as status 
from
  pzdjex a
 
order by
  a.y asc,
  a.m asc,
  a.pzh asc,
  a.code asc


id: 6114b2b59932563b7c99cc8d
pid: 6114a5109932563b7c99cc64
name: dynamicwheredata2
code: 6114b2b59932563b7c99cc8d
namepath: /q_pzdjex
codepath: 6114a5109932563b7c99cc64
fullname: /q_pzdjex/dynamicwheredata2
fullcode: 6114a5109932563b7c99cc64.6114b2b59932563b7c99cc8d
nodetype: column
createdate: 2021.08.12 13:35:30.000
lastmodifieddate: 2024.09.18 14:41:13.078
value:
st_date1:  date2yyyymmdd(凭证资料查询!st_date1)
st_date2: date2yyyymmdd(凭证资料查询!st_date2)
st_key1:凭证资料查询!st_key1
st_value1:凭证资料查询!st_value1


id: 6114b2b59932563b7c99cc8e
pid: 6114a5109932563b7c99cc64
name: dynamicwhere2
code: 6114b2b59932563b7c99cc8e
namepath: /q_pzdjex
codepath: 6114a5109932563b7c99cc64
fullname: /q_pzdjex/dynamicwhere2
fullcode: 6114a5109932563b7c99cc64.6114b2b59932563b7c99cc8e
nodetype: column
createdate: 2021.08.12 13:35:30.000
lastmodifieddate: 2024.09.18 14:41:13.078
value:
"a.pzrq >= '"+st_date1+"' "
"a.pzrq < '"+date2yyyymmdd(nextDate(yyyymmdd2Date(st_date2),1))+"' "
"a."+st_key1+" like '%"+st_value1+"%'"


id: 6114b2b59932563b7c99cc8f
pid: 6114a5109932563b7c99cc64
name: dynamicwhere2_tokens
code: 6114b2b59932563b7c99cc8f
namepath: /q_pzdjex
codepath: 6114a5109932563b7c99cc64
fullname: /q_pzdjex/dynamicwhere2_tokens
fullcode: 6114a5109932563b7c99cc64.6114b2b59932563b7c99cc8f
nodetype: column
createdate: 2021.08.12 13:35:30.000
lastmodifieddate: 2024.09.18 14:41:13.078
value:
{
    "\"a.pzrq >= '\"+st_date1+\"' \"": "st_date1",
    "\"a.pzrq < '\"+date2yyyymmdd(nextDate(yyyymmdd2Date(st_date2),1))+\"' \"": "st_date2",
    "\"a.\"+st_key1+\" like '%\"+st_value1+\"%'\"": "st_key1,st_value1"
}


id: 617cc6df99328c3820c0b3f4
pid: 617cc6df99328c3820c0b3ca
name: sql
code: 617cc6df99328c3820c0b3f4
namepath: /q_mx
codepath: 617cc6df99328c3820c0b3ca
fullname: /q_mx/sql
fullcode: 617cc6df99328c3820c0b3ca.617cc6df99328c3820c0b3f4
nodetype: column
createdate: 2021.10.30 12:15:54.000
lastmodifieddate: 2024.09.18 14:41:14.264
value:
select
  *,
  pzsl_dj - pzsl_pic as status
from(
    select
     distinct b.corpid,
      b.y * 100 + b.m as ym,
      dzpz_id ,
      b.pzh,
      b.zdr,
      b.pzrq,
      1 as pzsl_dj,
      case when pic_pz>0 then 1 else 0 end  as pzsl_pic,
        pic_pz,
      pic_fj,
      pic_pz + pic_fj  as pic_hj
    from
       pzdjex b   
    union all
    select
     distinct corpid,
      ym,
      id,
      pzh,
      '' as zdr,
      null as pzrq,
      0 as pzsl_dj,
      1 as pzsl_pic,
      c.pz as pic_fj,
      ifnull(c.fj, 0) as pic_fj,
      ifnull(c.pz, 0) + ifnull(c.fj, 0) as pic_hj
    from
      dzpz_pz c 
    where
      pzdj_exist=0 
  ) x
order by
  corpid,
  ym,
  pzh


id: 617cc6df99328c3820c0b3f6
pid: 617cc6df99328c3820c0b3ca
name: dynamicwhere2
code: 617cc6df99328c3820c0b3f6
namepath: /q_mx
codepath: 617cc6df99328c3820c0b3ca
fullname: /q_mx/dynamicwhere2
fullcode: 617cc6df99328c3820c0b3ca.617cc6df99328c3820c0b3f6
nodetype: column
createdate: 2021.10.30 12:15:54.000
lastmodifieddate: 2024.09.18 14:41:14.264
value:
"corpid='"+st_corpid+"'"
"left(ym,4)='"+st_y+"'"
"right(ym,2)='"+st_m+"'"
"pzsl_dj - pzsl_pic="+st_status


id: 617cc6df99328c3820c0b3f7
pid: 617cc6df99328c3820c0b3ca
name: dynamicwhere2_tokens
code: 617cc6df99328c3820c0b3f7
namepath: /q_mx
codepath: 617cc6df99328c3820c0b3ca
fullname: /q_mx/dynamicwhere2_tokens
fullcode: 617cc6df99328c3820c0b3ca.617cc6df99328c3820c0b3f7
nodetype: column
createdate: 2021.10.30 12:15:54.000
lastmodifieddate: 2024.09.18 14:41:14.264
value:
{
    "\"corpid='\"+st_corpid+\"'\"": "st_corpid",
    "\"left(ym,4)='\"+st_y+\"'\"": "st_y",
    "\"right(ym,2)='\"+st_m+\"'\"": "st_m",
    "\"pzsl_dj - pzsl_pic=\"+st_status": "st_status"
}


id: 617cc89c99328c3820c0b6b3
pid: 617cc89c99328c3820c0b67f
name: sql
code: 617cc89c99328c3820c0b6b3
namepath: /q_hz
codepath: 617cc89c99328c3820c0b67f
fullname: /q_hz/sql
fullcode: 617cc89c99328c3820c0b67f.617cc89c99328c3820c0b6b3
nodetype: column
createdate: 2021.10.30 12:38:44.000
lastmodifieddate: 2024.09.18 14:41:15.035
value:
select
  corpid,
  ym,
  sum(pzsl_dj) as pzsl_dj,
  sum(
    case when pzsl_dj = 1
    and pzsl_pic = 1 then 1 else 0 end
  ) as pzsl_dj_pic,
  sum(
    case when pzsl_dj = 1
    and pzsl_pic = 0 then 1 else 0 end
  ) as pzsl_dj_wpic,
  sum(
    case when pzsl_dj = 0
    and pzsl_pic = 1 then 1 else 0 end
  ) as pzsl_pic_wdj,
  sum(
    case when pzsl_dj = 1 then pic_pz + pic_fj else 0 end
  ) as pic_sl_dj,
  sum(
    case when pzsl_dj = 0 then pic_pz + pic_fj else 0 end
  ) as pic_sl_wdj
from(
    select
      distinct b.corpid,
      b.y * 100 + b.m as ym,
      b.pzh,
      b.pzrq,
      1 as pzsl_dj,
      case when pic_pz>0 then 1 else 0 end  as pzsl_pic,
      pic_pz,
      pic_fj
    from
       pzdjex b  
    where b.y= :st_y{2020}
  
    union all
    select
      corpid,
      ym,
      pzh,
      null as pzrq,
      0 as pzsl_dj,
      1 as pzsl_pic,
      c.pz as pic_fj,
      ifnull(c.fj, 0) as pic_fj
    from
      dzpz_pz c
    where   left( c.ym ,4)=':st_y{2020}' and 
       pzdj_exist =0 
  ) x
group by
  corpid,
  ym
order by
  corpid asc,
  ym desc


id: 617cc89c99328c3820c0b6b6
pid: 617cc89c99328c3820c0b67f
name: dynamicwhere2_tokens
code: 617cc89c99328c3820c0b6b6
namepath: /q_hz
codepath: 617cc89c99328c3820c0b67f
fullname: /q_hz/dynamicwhere2_tokens
fullcode: 617cc89c99328c3820c0b67f.617cc89c99328c3820c0b6b6
nodetype: column
createdate: 2021.10.30 12:38:44.000
lastmodifieddate: 2024.09.18 14:41:15.035
value:
{
    "\"corpid='\"+st_corpid+\"'\"": "st_corpid",
    "\"left(ym,4)='\"+st_y+\"'\"": "st_y",
    "\"right(ym,2)='\"+st_m+\"'\"": "st_m"
}


id: 6183205499328c3820c0c92b
pid: 6183205499328c3820c0c927
name: coltype
code: 60c5623b5db2e8eff0d868f020211104075044
namepath: /dzpz_pz/attachmentcount
codepath: 60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868ef20211104075044
fullname: /dzpz_pz/attachmentcount/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:25.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868ef20211104075044.60c5623b5db2e8eff0d868f020211104075044


id: 6183205499328c3820c0c937
pid: 6183205499328c3820c0c933
name: coltype
code: 60c5623b5db2e8eff0d868f320211104075044
namepath: /dzpz_pz/billdate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868f220211104075044
fullname: /dzpz_pz/billdate/coltype
nodetype: column
value: datetime
createdate: 2021.06.13 09:44:25.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868f220211104075044.60c5623b5db2e8eff0d868f320211104075044


id: 6183205499328c3820c0c93f
pid: 6183205499328c3820c0c93b
name: colsize
code: 60c5623b5db2e8eff0d868f720211104075044
namepath: /dzpz_pz/billno
codepath: 60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868f520211104075044
fullname: /dzpz_pz/billno/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:26.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868f520211104075044.60c5623b5db2e8eff0d868f720211104075044


id: 6183205499328c3820c0c943
pid: 6183205499328c3820c0c93b
name: coltype
code: 60c5623b5db2e8eff0d868f620211104075044
namepath: /dzpz_pz/billno
codepath: 60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868f520211104075044
fullname: /dzpz_pz/billno/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:26.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c5623b5db2e8eff0d868f520211104075044.60c5623b5db2e8eff0d868f620211104075044


id: 6183205499328c3820c0c94b
pid: 6183205499328c3820c0c947
name: colsize
code: 60c562fa5db2e8eff0d868fd20211104075044
namepath: /dzpz_pz/billtype
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d868fb20211104075044
fullname: /dzpz_pz/billtype/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:27.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d868fb20211104075044.60c562fa5db2e8eff0d868fd20211104075044


id: 6183205499328c3820c0c94f
pid: 6183205499328c3820c0c947
name: coltype
code: 60c562fa5db2e8eff0d868fc20211104075044
namepath: /dzpz_pz/billtype
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d868fb20211104075044
fullname: /dzpz_pz/billtype/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:27.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d868fb20211104075044.60c562fa5db2e8eff0d868fc20211104075044


id: 6183205499328c3820c0c957
pid: 6183205499328c3820c0c953
name: colsize
code: 60c562fa5db2e8eff0d8694c20211104075044
namepath: /dzpz_pz/bm
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694a20211104075044
fullname: /dzpz_pz/bm/colsize
nodetype: column
value: 200
createdate: 2021.06.13 09:44:42.000
lastmodifieddate: 2024.09.18 14:41:16.229
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694a20211104075044.60c562fa5db2e8eff0d8694c20211104075044


id: 6183205499328c3820c0c95b
pid: 6183205499328c3820c0c953
name: coltype
code: 60c562fa5db2e8eff0d8694b20211104075044
namepath: /dzpz_pz/bm
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694a20211104075044
fullname: /dzpz_pz/bm/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:42.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694a20211104075044.60c562fa5db2e8eff0d8694b20211104075044


id: 6183205499328c3820c0c963
pid: 6183205499328c3820c0c95f
name: colsize
code: 60c7d6795db2f19751803b0620211104075044
namepath: /dzpz_pz/c_sh1
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0420211104075044
fullname: /dzpz_pz/c_sh1/colsize
nodetype: column
value: 2
createdate: 2021.06.15 06:21:58.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0420211104075044.60c7d6795db2f19751803b0620211104075044


id: 6183205499328c3820c0c967
pid: 6183205499328c3820c0c95f
name: coltype
code: 60c7d6795db2f19751803b0520211104075044
namepath: /dzpz_pz/c_sh1
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0420211104075044
fullname: /dzpz_pz/c_sh1/coltype
nodetype: column
value: varchar
createdate: 2021.06.15 06:21:58.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0420211104075044.60c7d6795db2f19751803b0520211104075044


id: 6183205499328c3820c0c96f
pid: 6183205499328c3820c0c96b
name: colsize
code: 60c7d6795db2f19751803b0a20211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/colsize
nodetype: column
value: 4
createdate: 2021.06.15 06:21:58.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.60c7d6795db2f19751803b0a20211104075044


id: 6183205499328c3820c0c973
pid: 6183205499328c3820c0c96b
name: coltype
code: 60c7d6795db2f19751803b0920211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/coltype
nodetype: column
value: varchar
createdate: 2021.06.15 06:21:58.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.60c7d6795db2f19751803b0920211104075044


id: 6183205499328c3820c0c977
pid: 6183205499328c3820c0c96b
name: nullable
code: 615187ec99326278b943ff4820211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/nullable
nodetype: column
value: true
createdate: 2021.09.27 17:08:01.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.615187ec99326278b943ff4820211104075044


id: 6183205499328c3820c0c97b
pid: 6183205499328c3820c0c96b
name: smartretrieve
code: 615187ec99326278b943ff4a20211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/smartretrieve
nodetype: column
value: false
createdate: 2021.09.27 17:08:01.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.615187ec99326278b943ff4a20211104075044


id: 6183205499328c3820c0c97f
pid: 6183205499328c3820c0c96b
name: updatable
code: 615187ec99326278b943ff4920211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/updatable
nodetype: column
value: true
createdate: 2021.09.27 17:08:01.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.615187ec99326278b943ff4920211104075044


id: 6183205499328c3820c0c983
pid: 6183205499328c3820c0c96b
name: usedingroupby
code: 615187ec99326278b943ff4b20211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/usedingroupby
nodetype: column
value: false
createdate: 2021.09.27 17:08:01.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.615187ec99326278b943ff4b20211104075044


id: 6183205499328c3820c0c987
pid: 6183205499328c3820c0c96b
name: usedinsum
code: 615187ec99326278b943ff4c20211104075044
namepath: /dzpz_pz/c_sh2
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044
fullname: /dzpz_pz/c_sh2/usedinsum
nodetype: column
value: false
createdate: 2021.09.27 17:08:01.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d6795db2f19751803b0820211104075044.615187ec99326278b943ff4c20211104075044


id: 6183205499328c3820c0c98f
pid: 6183205499328c3820c0c98b
name: description
code: 60c7d4645db2f19751803a2d20211104075044
namepath: /dzpz_pz/c_xh
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044
fullname: /dzpz_pz/c_xh/description
nodetype: column
createdate: 2021.06.15 06:13:00.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044.60c7d4645db2f19751803a2d20211104075044


id: 6183205499328c3820c0c993
pid: 6183205499328c3820c0c98b
name: dynamicwhere2_tokens
code: 60c7d4645db2f19751803a2e20211104075044
namepath: /dzpz_pz/c_xh
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044
fullname: /dzpz_pz/c_xh/dynamicwhere2_tokens
nodetype: column
value: {}
createdate: 2021.06.15 06:13:00.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044.60c7d4645db2f19751803a2e20211104075044


id: 6183205499328c3820c0c997
pid: 6183205499328c3820c0c98b
name: expression
code: 60c7d4645db2f19751803a2c20211104075044
namepath: /dzpz_pz/c_xh
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044
fullname: /dzpz_pz/c_xh/expression
nodetype: column
value: thisrow()+1
createdate: 2021.06.15 06:13:00.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044.60c7d4645db2f19751803a2c20211104075044


id: 6183205499328c3820c0c99b
pid: 6183205499328c3820c0c98b
name: fillback
code: 60c7d4645db2f19751803a2b20211104075044
namepath: /dzpz_pz/c_xh
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044
fullname: /dzpz_pz/c_xh/fillback
nodetype: column
createdate: 2021.06.15 06:12:59.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f19751803a1a20211104075044.60c7d4645db2f19751803a2b20211104075044


id: 6183205499328c3820c0c9a3
pid: 6183205499328c3820c0c99f
name: colsize
code: 61403c23993240476a10dc3c20211104075044
namepath: /dzpz_pz/corpid
codepath: 60c560a05db2e8eff0d867a820211104075044.61403c23993240476a10dc3a20211104075044
fullname: /dzpz_pz/corpid/colsize
nodetype: column
value: 32
createdate: 2021.09.14 14:13:40.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.61403c23993240476a10dc3a20211104075044.61403c23993240476a10dc3c20211104075044


id: 6183205499328c3820c0c9a7
pid: 6183205499328c3820c0c99f
name: coltype
code: 61403c23993240476a10dc3b20211104075044
namepath: /dzpz_pz/corpid
codepath: 60c560a05db2e8eff0d867a820211104075044.61403c23993240476a10dc3a20211104075044
fullname: /dzpz_pz/corpid/coltype
nodetype: column
value: varchar
createdate: 2021.09.14 14:13:40.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.61403c23993240476a10dc3a20211104075044.61403c23993240476a10dc3b20211104075044


id: 6183205499328c3820c0c9af
pid: 6183205499328c3820c0c9ab
name: colsize
code: 60c562fa5db2e8eff0d8690320211104075044
namepath: /dzpz_pz/corporationid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690120211104075044
fullname: /dzpz_pz/corporationid/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:28.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690120211104075044.60c562fa5db2e8eff0d8690320211104075044


id: 6183205499328c3820c0c9b3
pid: 6183205499328c3820c0c9ab
name: coltype
code: 60c562fa5db2e8eff0d8690220211104075044
namepath: /dzpz_pz/corporationid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690120211104075044
fullname: /dzpz_pz/corporationid/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:28.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690120211104075044.60c562fa5db2e8eff0d8690220211104075044


id: 6183205499328c3820c0c9c3
pid: 6183205499328c3820c0c9bf
name: coltype
code: 60c562fa5db2e8eff0d8690620211104075044
namepath: /dzpz_pz/deleteflag
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690520211104075044
fullname: /dzpz_pz/deleteflag/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:29.000
lastmodifieddate: 2024.09.18 14:41:16.230
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690520211104075044.60c562fa5db2e8eff0d8690620211104075044


id: 6183205499328c3820c0c9cf
pid: 6183205499328c3820c0c907
name: dynamicwhere2
code: 60c5615f5db2e8eff0d867d620211104075045
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a820211104075044
fullname: /dzpz_pz/dynamicwhere2
fullcode: 60c560a05db2e8eff0d867a820211104075044.60c5615f5db2e8eff0d867d620211104075045
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:16.231
value:
"corpid='"+ st_corpid+"' "
iif( shzt==1, " verifierid is not null" , iif ( shzt==2, "verifierid is null ", ""))
"username='"+st_username +"' "
" verifiername='"+ st_verifiername+"' "
"pzh  like  '%"+st_pzh+"%' "
"left(ym,4)='"+st_y+"'"
"right(ym,2)='"+st_m+"'"
beWhere_code(st_code)


id: 6183205499328c3820c0c9d3
pid: 6183205499328c3820c0c907
name: dynamicwhere2_tokens
code: 60c5615f5db2e8eff0d867d720211104075045
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a820211104075044
fullname: /dzpz_pz/dynamicwhere2_tokens
fullcode: 60c560a05db2e8eff0d867a820211104075044.60c5615f5db2e8eff0d867d720211104075045
nodetype: column
createdate: 2021.06.13 09:37:38.000
lastmodifieddate: 2024.09.18 14:41:16.231
value:
{
    "\"corpid='\"+ st_corpid+\"' \"": "st_corpid",
    "iif( shzt==1, \" verifierid is not null\" , iif ( shzt==2, \"verifierid is null \", \"\"))": "shzt",
    "\"username='\"+st_username +\"' \"": "st_username",
    "\" verifiername='\"+ st_verifiername+\"' \"": "st_verifiername",
    "\"pzh  like  '%\"+st_pzh+\"%' \"": "st_pzh",
    "\"left(ym,4)='\"+st_y+\"'\"": "st_y",
    "\"right(ym,2)='\"+st_m+\"'\"": "st_m",
    "beWhere_code(st_code)": "st_code"
}


id: 6183205499328c3820c0c9d7
pid: 6183205499328c3820c0c907
name: dynamicwheredata2
code: 60c5615f5db2e8eff0d867d520211104075045
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a820211104075044
fullname: /dzpz_pz/dynamicwheredata2
fullcode: 60c560a05db2e8eff0d867a820211104075044.60c5615f5db2e8eff0d867d520211104075045
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:16.231
value:
st_corpid:filter!st_corpid
st_y:filter!st_y
st_m:filter!st_m
st_username:filter!st_username
st_verifiername:filter!st_verifiername
st_pzh:filter!st_pzh
st_code:filter!st_code


id: 6183205499328c3820c0c9df
pid: 6183205499328c3820c0c9db
name: coltype
code: 60c562fa5db2e8eff0d8695320211104075045
namepath: /dzpz_pz/fj
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8695220211104075045
fullname: /dzpz_pz/fj/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:43.000
lastmodifieddate: 2024.09.18 14:41:16.231
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8695220211104075045.60c562fa5db2e8eff0d8695320211104075045


id: 6183205499328c3820c0c9e7
pid: 6183205499328c3820c0c9e3
name: colsize
code: 60c562fa5db2e8eff0d8690a20211104075045
namepath: /dzpz_pz/gguid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690820211104075045
fullname: /dzpz_pz/gguid/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:16.231
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690820211104075045.60c562fa5db2e8eff0d8690a20211104075045


id: 6183205499328c3820c0c9eb
pid: 6183205499328c3820c0c9e3
name: coltype
code: 60c562fa5db2e8eff0d8690920211104075045
namepath: /dzpz_pz/gguid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690820211104075045
fullname: /dzpz_pz/gguid/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:16.231
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690820211104075045.60c562fa5db2e8eff0d8690920211104075045


id: 6183205599328c3820c0c9f7
pid: 6183205599328c3820c0c9f3
name: colsize
code: 60c562fa5db2e8eff0d8690e20211104075045
namepath: /dzpz_pz/id
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690c20211104075045
fullname: /dzpz_pz/id/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:31.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690c20211104075045.60c562fa5db2e8eff0d8690e20211104075045


id: 6183205599328c3820c0c9fb
pid: 6183205599328c3820c0c9f3
name: coltype
code: 60c562fa5db2e8eff0d8690d20211104075045
namepath: /dzpz_pz/id
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690c20211104075045
fullname: /dzpz_pz/id/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8690c20211104075045.60c562fa5db2e8eff0d8690d20211104075045


id: 6183205599328c3820c0ca03
pid: 6183205599328c3820c0c9ff
name: colsize
code: 60c562fa5db2e8eff0d8691520211104075045
namepath: /dzpz_pz/imgid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691020211104075045
fullname: /dzpz_pz/imgid/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:31.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691020211104075045.60c562fa5db2e8eff0d8691520211104075045


id: 6183205599328c3820c0ca07
pid: 6183205599328c3820c0c9ff
name: coltype
code: 60c562fa5db2e8eff0d8691320211104075045
namepath: /dzpz_pz/imgid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691020211104075045
fullname: /dzpz_pz/imgid/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:31.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691020211104075045.60c562fa5db2e8eff0d8691320211104075045


id: 6183205599328c3820c0ca0f
pid: 6183205599328c3820c0ca0b
name: coltype
code: 60c562fa5db2e8eff0d8691820211104075045
namepath: /dzpz_pz/lastmodifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045
fullname: /dzpz_pz/lastmodifieddate/coltype
nodetype: column
value: datetime
createdate: 2021.06.13 09:44:32.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045.60c562fa5db2e8eff0d8691820211104075045


id: 6183205599328c3820c0ca1f
pid: 6183205599328c3820c0ca1b
name: colsize
code: 60c562fa5db2e8eff0d8691e20211104075045
namepath: /dzpz_pz/open_bill_with_url
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691c20211104075045
fullname: /dzpz_pz/open_bill_with_url/colsize
nodetype: column
value: 300
createdate: 2021.06.13 09:44:33.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691c20211104075045.60c562fa5db2e8eff0d8691e20211104075045


id: 6183205599328c3820c0ca23
pid: 6183205599328c3820c0ca1b
name: coltype
code: 60c562fa5db2e8eff0d8691d20211104075045
namepath: /dzpz_pz/open_bill_with_url
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691c20211104075045
fullname: /dzpz_pz/open_bill_with_url/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:33.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691c20211104075045.60c562fa5db2e8eff0d8691d20211104075045


id: 6183205599328c3820c0ca2f
pid: 6183205599328c3820c0ca2b
name: coltype
code: 60c562fa5db2e8eff0d8695620211104075045
namepath: /dzpz_pz/pz
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8695520211104075045
fullname: /dzpz_pz/pz/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:44.000
lastmodifieddate: 2024.09.18 14:41:16.613
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8695520211104075045.60c562fa5db2e8eff0d8695620211104075045


id: 6183205599328c3820c0ca37
pid: 6183205599328c3820c0ca33
name: colsize
code: 60c562fa5db2e8eff0d8692220211104075045
namepath: /dzpz_pz/pzh
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692020211104075045
fullname: /dzpz_pz/pzh/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:34.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692020211104075045.60c562fa5db2e8eff0d8692220211104075045


id: 6183205599328c3820c0ca3b
pid: 6183205599328c3820c0ca33
name: coltype
code: 60c562fa5db2e8eff0d8692120211104075045
namepath: /dzpz_pz/pzh
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692020211104075045
fullname: /dzpz_pz/pzh/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:34.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692020211104075045.60c562fa5db2e8eff0d8692120211104075045


id: 6183205599328c3820c0ca4b
pid: 6183205599328c3820c0ca47
name: colsize
code: 60c7d4645db2f19751803a4f20211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/colsize
nodetype: column
createdate: 2021.06.15 06:15:12.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a4f20211104075045


id: 6183205599328c3820c0ca4f
pid: 6183205599328c3820c0ca47
name: coltype
code: 60c7d41b5db2f197518039d620211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/coltype
nodetype: column
value: int
createdate: 2021.06.15 06:11:52.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d41b5db2f197518039d620211104075045


id: 6183205599328c3820c0ca53
pid: 6183205599328c3820c0ca47
name: datamask
code: 60c7d4645db2f19751803a5220211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/datamask
nodetype: column
createdate: 2021.06.15 06:15:12.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a5220211104075045


id: 6183205599328c3820c0ca57
pid: 6183205599328c3820c0ca47
name: decimalcount
code: 60c7d4645db2f19751803a5020211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/decimalcount
nodetype: column
createdate: 2021.06.15 06:15:12.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a5020211104075045


id: 6183205599328c3820c0ca5b
pid: 6183205599328c3820c0ca47
name: defaultvalue
code: 60c7d4645db2f19751803a5120211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/defaultvalue
nodetype: column
createdate: 2021.06.15 06:15:12.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a5120211104075045


id: 6183205599328c3820c0ca5f
pid: 6183205599328c3820c0ca47
name: description
code: 60c7d4645db2f19751803a5320211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/description
nodetype: column
createdate: 2021.06.15 06:15:13.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a5320211104075045


id: 6183205599328c3820c0ca63
pid: 6183205599328c3820c0ca47
name: dynamicwhere2_tokens
code: 60c7d4645db2f19751803a5420211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/dynamicwhere2_tokens
nodetype: column
value: {}
createdate: 2021.06.15 06:15:13.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a5420211104075045


id: 6183205599328c3820c0ca67
pid: 6183205599328c3820c0ca47
name: nullable
code: 60c7d4645db2f19751803a4420211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/nullable
nodetype: column
value: true
createdate: 2021.06.15 06:15:07.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a4420211104075045


id: 6183205599328c3820c0ca6b
pid: 6183205599328c3820c0ca47
name: smartretrieve
code: 60c7d4645db2f19751803a4620211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/smartretrieve
nodetype: column
value: false
createdate: 2021.06.15 06:15:07.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a4620211104075045


id: 6183205599328c3820c0ca6f
pid: 6183205599328c3820c0ca47
name: updatable
code: 60c7d4645db2f19751803a4520211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/updatable
nodetype: column
value: false
createdate: 2021.06.15 06:15:07.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a4520211104075045


id: 6183205599328c3820c0ca73
pid: 6183205599328c3820c0ca47
name: usedingroupby
code: 60c7d4645db2f19751803a4720211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/usedingroupby
nodetype: column
value: false
createdate: 2021.06.15 06:15:07.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a4720211104075045


id: 6183205599328c3820c0ca77
pid: 6183205599328c3820c0ca47
name: usedinsum
code: 60c7d4645db2f19751803a4820211104075045
namepath: /dzpz_pz/selected
codepath: 60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045
fullname: /dzpz_pz/selected/usedinsum
nodetype: column
value: false
createdate: 2021.06.15 06:15:07.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c7d41b5db2f197518039d520211104075045.60c7d4645db2f19751803a4820211104075045


id: 6183205599328c3820c0ca7f
pid: 6183205499328c3820c0c907
name: sql
code: 60c5615f5db2e8eff0d867d420211104075045
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a820211104075044
fullname: /dzpz_pz/sql
fullcode: 60c560a05db2e8eff0d867a820211104075044.60c5615f5db2e8eff0d867d420211104075045
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:16.614
value:
select
  dzpz_pz.*,
  0 as selected,
  '' as tipinfo,
  case when verifierid is null then '校对' else '' end as c_sh1,
  case when verifierid is null then '' else '取消校对' end as c_sh2
from
  dzpz_pz
where
  ifnull(deleteflag, 0) = 0
order by
  ym,
  pzh


id: 6183205599328c3820c0ca8b
pid: 6183205599328c3820c0ca87
name: colsize
code: 60c562fa5db2e8eff0d8692820211104075045
namepath: /dzpz_pz/summary
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692420211104075045
fullname: /dzpz_pz/summary/colsize
nodetype: column
value: 200
createdate: 2021.06.13 09:44:35.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692420211104075045.60c562fa5db2e8eff0d8692820211104075045


id: 6183205599328c3820c0ca8f
pid: 6183205599328c3820c0ca87
name: coltype
code: 60c562fa5db2e8eff0d8692520211104075045
namepath: /dzpz_pz/summary
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692420211104075045
fullname: /dzpz_pz/summary/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:34.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692420211104075045.60c562fa5db2e8eff0d8692520211104075045


id: 6183205599328c3820c0ca9b
pid: 6183205599328c3820c0ca97
name: colsize
code: 60c800ef5db2d209d074b49b20211104075045
namepath: /dzpz_pz/tipinfo
codepath: 60c560a05db2e8eff0d867a820211104075044.60c800ef5db2d209d074b49920211104075045
fullname: /dzpz_pz/tipinfo/colsize
nodetype: column
value: 0
createdate: 2021.06.15 09:23:00.000
lastmodifieddate: 2024.09.18 14:41:16.614
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c800ef5db2d209d074b49920211104075045.60c800ef5db2d209d074b49b20211104075045


id: 6183205599328c3820c0ca9f
pid: 6183205599328c3820c0ca97
name: coltype
code: 60c800ef5db2d209d074b49a20211104075045
namepath: /dzpz_pz/tipinfo
codepath: 60c560a05db2e8eff0d867a820211104075044.60c800ef5db2d209d074b49920211104075045
fullname: /dzpz_pz/tipinfo/coltype
nodetype: column
value: varchar
createdate: 2021.06.15 09:23:00.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c800ef5db2d209d074b49920211104075045.60c800ef5db2d209d074b49a20211104075045


id: 6183205599328c3820c0cab3
pid: 6183205599328c3820c0caaf
name: colsize
code: 60c562fa5db2e8eff0d8692c20211104075045
namepath: /dzpz_pz/url_img
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692a20211104075045
fullname: /dzpz_pz/url_img/colsize
nodetype: column
value: 1000
createdate: 2021.06.13 09:44:36.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692a20211104075045.60c562fa5db2e8eff0d8692c20211104075045


id: 6183205599328c3820c0cab7
pid: 6183205599328c3820c0caaf
name: coltype
code: 60c562fa5db2e8eff0d8692b20211104075045
namepath: /dzpz_pz/url_img
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692a20211104075045
fullname: /dzpz_pz/url_img/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:35.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692a20211104075045.60c562fa5db2e8eff0d8692b20211104075045


id: 6183205599328c3820c0cabf
pid: 6183205599328c3820c0cabb
name: colsize
code: 60c562fa5db2e8eff0d8693020211104075045
namepath: /dzpz_pz/url_thumbnail
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692e20211104075045
fullname: /dzpz_pz/url_thumbnail/colsize
nodetype: column
value: 1000
createdate: 2021.06.13 09:44:36.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692e20211104075045.60c562fa5db2e8eff0d8693020211104075045


id: 6183205599328c3820c0cac3
pid: 6183205599328c3820c0cabb
name: coltype
code: 60c562fa5db2e8eff0d8692f20211104075045
namepath: /dzpz_pz/url_thumbnail
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692e20211104075045
fullname: /dzpz_pz/url_thumbnail/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:36.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8692e20211104075045.60c562fa5db2e8eff0d8692f20211104075045


id: 6183205599328c3820c0cacb
pid: 6183205599328c3820c0cac7
name: coltype
code: 60c562fa5db2e8eff0d8693520211104075045
namepath: /dzpz_pz/userid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693420211104075045
fullname: /dzpz_pz/userid/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:37.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693420211104075045.60c562fa5db2e8eff0d8693520211104075045


id: 6183205599328c3820c0cad3
pid: 6183205599328c3820c0cacf
name: colsize
code: 60c562fa5db2e8eff0d8693920211104075045
namepath: /dzpz_pz/username
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693720211104075045
fullname: /dzpz_pz/username/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:38.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693720211104075045.60c562fa5db2e8eff0d8693920211104075045


id: 6183205599328c3820c0cad7
pid: 6183205599328c3820c0cacf
name: coltype
code: 60c562fa5db2e8eff0d8693820211104075045
namepath: /dzpz_pz/username
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693720211104075045
fullname: /dzpz_pz/username/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:38.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693720211104075045.60c562fa5db2e8eff0d8693820211104075045


id: 6183205599328c3820c0cadf
pid: 6183205599328c3820c0cadb
name: coltype
code: 60c562fa5db2e8eff0d8693c20211104075045
namepath: /dzpz_pz/verifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045
fullname: /dzpz_pz/verifieddate/coltype
nodetype: column
value: datetime
createdate: 2021.06.13 09:44:39.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045.60c562fa5db2e8eff0d8693c20211104075045


id: 6183205599328c3820c0cae3
pid: 6183205599328c3820c0cadb
name: nullable
code: 60c7f6715db2d209d074b40520211104075045
namepath: /dzpz_pz/verifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045
fullname: /dzpz_pz/verifieddate/nullable
nodetype: column
value: true
createdate: 2021.06.15 08:56:55.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045.60c7f6715db2d209d074b40520211104075045


id: 6183205599328c3820c0cae7
pid: 6183205599328c3820c0cadb
name: smartretrieve
code: 60c7f6715db2d209d074b40720211104075045
namepath: /dzpz_pz/verifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045
fullname: /dzpz_pz/verifieddate/smartretrieve
nodetype: column
value: false
createdate: 2021.06.15 08:56:56.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045.60c7f6715db2d209d074b40720211104075045


id: 6183205599328c3820c0caeb
pid: 6183205599328c3820c0cadb
name: updatable
code: 60c7f6715db2d209d074b40620211104075045
namepath: /dzpz_pz/verifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045
fullname: /dzpz_pz/verifieddate/updatable
nodetype: column
value: true
createdate: 2021.06.15 08:56:55.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045.60c7f6715db2d209d074b40620211104075045


id: 6183205599328c3820c0caef
pid: 6183205599328c3820c0cadb
name: usedingroupby
code: 60c7f6715db2d209d074b40820211104075045
namepath: /dzpz_pz/verifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045
fullname: /dzpz_pz/verifieddate/usedingroupby
nodetype: column
value: false
createdate: 2021.06.15 08:56:56.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045.60c7f6715db2d209d074b40820211104075045


id: 6183205599328c3820c0caf3
pid: 6183205599328c3820c0cadb
name: usedinsum
code: 60c7f6715db2d209d074b40920211104075045
namepath: /dzpz_pz/verifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045
fullname: /dzpz_pz/verifieddate/usedinsum
nodetype: column
value: false
createdate: 2021.06.15 08:56:56.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693b20211104075045.60c7f6715db2d209d074b40920211104075045


id: 6183205599328c3820c0cafb
pid: 6183205599328c3820c0caf7
name: coltype
code: 60c562fa5db2e8eff0d8693f20211104075045
namepath: /dzpz_pz/verifierid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045
fullname: /dzpz_pz/verifierid/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:39.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045.60c562fa5db2e8eff0d8693f20211104075045


id: 6183205599328c3820c0caff
pid: 6183205599328c3820c0caf7
name: nullable
code: 60c7f6715db2d209d074b41a20211104075045
namepath: /dzpz_pz/verifierid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045
fullname: /dzpz_pz/verifierid/nullable
nodetype: column
value: true
createdate: 2021.06.15 09:04:50.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045.60c7f6715db2d209d074b41a20211104075045


id: 6183205599328c3820c0cb03
pid: 6183205599328c3820c0caf7
name: smartretrieve
code: 60c7f6715db2d209d074b41c20211104075045
namepath: /dzpz_pz/verifierid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045
fullname: /dzpz_pz/verifierid/smartretrieve
nodetype: column
value: false
createdate: 2021.06.15 09:04:51.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045.60c7f6715db2d209d074b41c20211104075045


id: 6183205599328c3820c0cb07
pid: 6183205599328c3820c0caf7
name: updatable
code: 60c7f6715db2d209d074b41b20211104075045
namepath: /dzpz_pz/verifierid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045
fullname: /dzpz_pz/verifierid/updatable
nodetype: column
value: true
createdate: 2021.06.15 09:04:51.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045.60c7f6715db2d209d074b41b20211104075045


id: 6183205599328c3820c0cb0b
pid: 6183205599328c3820c0caf7
name: usedingroupby
code: 60c7f6715db2d209d074b41d20211104075045
namepath: /dzpz_pz/verifierid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045
fullname: /dzpz_pz/verifierid/usedingroupby
nodetype: column
value: false
createdate: 2021.06.15 09:04:51.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045.60c7f6715db2d209d074b41d20211104075045


id: 6183205599328c3820c0cb0f
pid: 6183205599328c3820c0caf7
name: usedinsum
code: 60c7f6715db2d209d074b41e20211104075045
namepath: /dzpz_pz/verifierid
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045
fullname: /dzpz_pz/verifierid/usedinsum
nodetype: column
value: false
createdate: 2021.06.15 09:04:51.000
lastmodifieddate: 2024.09.18 14:41:16.615
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8693e20211104075045.60c7f6715db2d209d074b41e20211104075045


id: 6183205599328c3820c0cb17
pid: 6183205599328c3820c0cb13
name: colsize
code: 60c562fa5db2e8eff0d8694320211104075045
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:40.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c562fa5db2e8eff0d8694320211104075045


id: 6183205599328c3820c0cb1b
pid: 6183205599328c3820c0cb13
name: coltype
code: 60c562fa5db2e8eff0d8694220211104075045
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:40.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c562fa5db2e8eff0d8694220211104075045


id: 6183205599328c3820c0cb1f
pid: 6183205599328c3820c0cb13
name: nullable
code: 60c800ef5db2d209d074b4ab20211104075045
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/nullable
nodetype: column
value: true
createdate: 2021.06.15 09:25:32.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c800ef5db2d209d074b4ab20211104075045


id: 6183205599328c3820c0cb23
pid: 6183205599328c3820c0cb13
name: smartretrieve
code: 60c800ef5db2d209d074b4ad20211104075046
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/smartretrieve
nodetype: column
value: false
createdate: 2021.06.15 09:25:33.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c800ef5db2d209d074b4ad20211104075046


id: 6183205599328c3820c0cb27
pid: 6183205599328c3820c0cb13
name: updatable
code: 60c800ef5db2d209d074b4ac20211104075046
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/updatable
nodetype: column
value: true
createdate: 2021.06.15 09:25:33.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c800ef5db2d209d074b4ac20211104075046


id: 6183205599328c3820c0cb2b
pid: 6183205599328c3820c0cb13
name: usedingroupby
code: 60c800ef5db2d209d074b4ae20211104075046
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/usedingroupby
nodetype: column
value: false
createdate: 2021.06.15 09:25:34.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c800ef5db2d209d074b4ae20211104075046


id: 6183205599328c3820c0cb2f
pid: 6183205599328c3820c0cb13
name: usedinsum
code: 60c800ef5db2d209d074b4af20211104075046
namepath: /dzpz_pz/verifiername
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045
fullname: /dzpz_pz/verifiername/usedinsum
nodetype: column
value: false
createdate: 2021.06.15 09:25:35.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694120211104075045.60c800ef5db2d209d074b4af20211104075046


id: 6183205599328c3820c0cb37
pid: 6183205599328c3820c0cb33
name: colsize
code: 60c562fa5db2e8eff0d8695020211104075046
namepath: /dzpz_pz/xm
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694e20211104075046
fullname: /dzpz_pz/xm/colsize
nodetype: column
value: 200
createdate: 2021.06.13 09:44:43.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694e20211104075046.60c562fa5db2e8eff0d8695020211104075046


id: 6183205599328c3820c0cb3b
pid: 6183205599328c3820c0cb33
name: coltype
code: 60c562fa5db2e8eff0d8694f20211104075046
namepath: /dzpz_pz/xm
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694e20211104075046
fullname: /dzpz_pz/xm/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:42.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694e20211104075046.60c562fa5db2e8eff0d8694f20211104075046


id: 6183205599328c3820c0cb43
pid: 6183205599328c3820c0cb3f
name: coltype
code: 60c562fa5db2e8eff0d8694620211104075046
namepath: /dzpz_pz/ym
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694520211104075046
fullname: /dzpz_pz/ym/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:41.000
lastmodifieddate: 2024.09.18 14:41:16.616
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8694520211104075046.60c562fa5db2e8eff0d8694620211104075046


id: 618499a5993236a4844fa1d5
pid: 6183205599328c3820c0ca0b
name: nullable
code: 618499a5993236a4844fa1d5
namepath: /dzpz_pz/lastmodifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045
fullname: /dzpz_pz/lastmodifieddate/nullable
nodetype: column
value: true
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:17.783
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045.618499a5993236a4844fa1d5


id: 618499a5993236a4844fa1d6
pid: 6183205599328c3820c0ca0b
name: updatable
code: 618499a5993236a4844fa1d6
namepath: /dzpz_pz/lastmodifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045
fullname: /dzpz_pz/lastmodifieddate/updatable
nodetype: column
value: true
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:17.783
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045.618499a5993236a4844fa1d6


id: 618499a5993236a4844fa1d7
pid: 6183205599328c3820c0ca0b
name: smartretrieve
code: 618499a5993236a4844fa1d7
namepath: /dzpz_pz/lastmodifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045
fullname: /dzpz_pz/lastmodifieddate/smartretrieve
nodetype: column
value: false
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:17.784
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045.618499a5993236a4844fa1d7


id: 618499a5993236a4844fa1d8
pid: 6183205599328c3820c0ca0b
name: usedingroupby
code: 618499a5993236a4844fa1d8
namepath: /dzpz_pz/lastmodifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045
fullname: /dzpz_pz/lastmodifieddate/usedingroupby
nodetype: column
value: false
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:17.784
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045.618499a5993236a4844fa1d8


id: 618499a5993236a4844fa1d9
pid: 6183205599328c3820c0ca0b
name: usedinsum
code: 618499a5993236a4844fa1d9
namepath: /dzpz_pz/lastmodifieddate
codepath: 60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045
fullname: /dzpz_pz/lastmodifieddate/usedinsum
nodetype: column
value: false
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:17.784
fullcode:
60c560a05db2e8eff0d867a820211104075044.60c562fa5db2e8eff0d8691720211104075045.618499a5993236a4844fa1d9


id: 619a5454993208680e5229a5
pid: 619a5454993208680e5229a1
name: apibody
code: 60c560a05db2e8eff0d867cb2021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apibody
nodetype: column
createdate: 2021.06.13 09:37:35.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867cb2021110407504420211121221444


id: 619a5454993208680e5229a9
pid: 619a5454993208680e5229a1
name: apicolumndefine
code: 60c560a05db2e8eff0d867c82021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apicolumndefine
nodetype: column
createdate: 2021.06.13 09:37:35.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c82021110407504420211121221444


id: 619a5454993208680e5229ad
pid: 619a5454993208680e5229a1
name: apiheader
code: 60c560a05db2e8eff0d867ca2021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apiheader
nodetype: column
createdate: 2021.06.13 09:37:35.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867ca2021110407504420211121221444


id: 619a5454993208680e5229b1
pid: 619a5454993208680e5229a1
name: apipagecount
code: 60c5615f5db2e8eff0d867d32021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apipagecount
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d32021110407504420211121221444


id: 619a5454993208680e5229b5
pid: 619a5454993208680e5229a1
name: apiresultconvert
code: 60c5615f5db2e8eff0d867ce2021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apiresultconvert
nodetype: column
createdate: 2021.06.13 09:37:36.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867ce2021110407504420211121221444


id: 619a5454993208680e5229b9
pid: 619a5454993208680e5229a1
name: apiresultpath
code: 60c5615f5db2e8eff0d867d22021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apiresultpath
nodetype: column
createdate: 2021.06.13 09:37:36.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d22021110407504420211121221444


id: 619a5454993208680e5229bd
pid: 619a5454993208680e5229a1
name: apiurl
code: 60c560a05db2e8eff0d867c92021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/apiurl
nodetype: column
createdate: 2021.06.13 09:37:35.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c92021110407504420211121221444


id: 619a5454993208680e5229c9
pid: 619a5454993208680e5229a1
name: autoretrieve
code: 60c560a05db2e8eff0d867b52021110407504420211121221444
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/autoretrieve
nodetype: column
value: true
createdate: 2021.06.13 09:37:14.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867b52021110407504420211121221444


id: 619a5454993208680e522a25
pid: 619a5454993208680e5229a1
name: c_xh
code: 60c7d41b5db2f19751803a1a2021110407504420211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/c_xh
nodetype: computer
createdate: 2021.06.15 06:12:48.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445


id: 619a5454993208680e522a29
pid: 619a5454993208680e522a25
name: description
code: 60c7d4645db2f19751803a2d2021110407504420211121221445
namepath: /dzpz_pz/c_xh
fullname: /dzpz_pz/c_xh/description
nodetype: column
createdate: 2021.06.15 06:13:00.000
lastmodifieddate: 2024.09.18 14:41:18.593
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445.60c7d4645db2f19751803a2d2021110407504420211121221445


id: 619a5454993208680e522a2d
pid: 619a5454993208680e522a25
name: dynamicwhere2_tokens
code: 60c7d4645db2f19751803a2e2021110407504420211121221445
namepath: /dzpz_pz/c_xh
fullname: /dzpz_pz/c_xh/dynamicwhere2_tokens
nodetype: column
value: {}
createdate: 2021.06.15 06:13:00.000
lastmodifieddate: 2024.09.18 14:41:18.593
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445.60c7d4645db2f19751803a2e2021110407504420211121221445


id: 619a5454993208680e522a31
pid: 619a5454993208680e522a25
name: expression
code: 60c7d4645db2f19751803a2c2021110407504420211121221445
namepath: /dzpz_pz/c_xh
fullname: /dzpz_pz/c_xh/expression
nodetype: column
value: thisrow()+1
createdate: 2021.06.15 06:13:00.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445.60c7d4645db2f19751803a2c2021110407504420211121221445


id: 619a5454993208680e522a35
pid: 619a5454993208680e522a25
name: fillback
code: 60c7d4645db2f19751803a2b2021110407504420211121221445
namepath: /dzpz_pz/c_xh
fullname: /dzpz_pz/c_xh/fillback
nodetype: column
createdate: 2021.06.15 06:12:59.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c7d41b5db2f19751803a1a2021110407504420211121221445.60c7d4645db2f19751803a2b2021110407504420211121221445


id: 619a5454993208680e522a39
pid: 619a5454993208680e5229a1
name: corpid
code: 61403c23993240476a10dc3a2021110407504420211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/corpid
nodetype: dbcol
value: 账套ID
createdate: 2021.09.14 14:13:40.000
lastmodifieddate: 2024.09.18 14:41:18.593
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.61403c23993240476a10dc3a2021110407504420211121221445


id: 619a5454993208680e522a3d
pid: 619a5454993208680e522a39
name: colsize
code: 61403c23993240476a10dc3c2021110407504420211121221445
namepath: /dzpz_pz/corpid
fullname: /dzpz_pz/corpid/colsize
nodetype: column
value: 10
createdate: 2021.09.14 14:13:40.000
lastmodifieddate: 2024.09.18 14:41:18.593
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.61403c23993240476a10dc3a2021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.61403c23993240476a10dc3a2021110407504420211121221445.61403c23993240476a10dc3c2021110407504420211121221445


id: 619a5454993208680e522a41
pid: 619a5454993208680e522a39
name: coltype
code: 61403c23993240476a10dc3b2021110407504420211121221445
namepath: /dzpz_pz/corpid
fullname: /dzpz_pz/corpid/coltype
nodetype: column
value: varchar
createdate: 2021.09.14 14:13:40.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.61403c23993240476a10dc3a2021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.61403c23993240476a10dc3a2021110407504420211121221445.61403c23993240476a10dc3b2021110407504420211121221445


id: 619a5454993208680e522a45
pid: 619a5454993208680e5229a1
name: corporationid
code: 60c562fa5db2e8eff0d869012021110407504420211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/corporationid
nodetype: dbcol
value: 帐套ID
createdate: 2021.06.13 09:44:28.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869012021110407504420211121221445


id: 619a5454993208680e522a49
pid: 619a5454993208680e522a45
name: colsize
code: 60c562fa5db2e8eff0d869032021110407504420211121221445
namepath: /dzpz_pz/corporationid
fullname: /dzpz_pz/corporationid/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:28.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869012021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869012021110407504420211121221445.60c562fa5db2e8eff0d869032021110407504420211121221445


id: 619a5454993208680e522a4d
pid: 619a5454993208680e522a45
name: coltype
code: 60c562fa5db2e8eff0d869022021110407504420211121221445
namepath: /dzpz_pz/corporationid
fullname: /dzpz_pz/corporationid/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:28.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869012021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869012021110407504420211121221445.60c562fa5db2e8eff0d869022021110407504420211121221445


id: 619a5454993208680e522a51
pid: 619a5454993208680e5229a1
name: dbpool
code: 60c560a05db2e8eff0d867c72021110407504420211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/dbpool
nodetype: column
value: default
createdate: 2021.06.13 09:37:34.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c72021110407504420211121221445


id: 619a5454993208680e522a55
pid: 619a5454993208680e5229a1
name: dbpool_expression
code: 613fd2c9993240476a10d29e2021110407504420211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/dbpool_expression
nodetype: column
createdate: 2021.09.14 06:38:15.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.613fd2c9993240476a10d29e2021110407504420211121221445


id: 619a5454993208680e522a59
pid: 619a5454993208680e5229a1
name: deleteflag
code: 60c562fa5db2e8eff0d869052021110407504420211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/deleteflag
nodetype: dbcol
value: 删除标记
createdate: 2021.06.13 09:44:29.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869052021110407504420211121221445


id: 619a5454993208680e522a5d
pid: 619a5454993208680e522a59
name: coltype
code: 60c562fa5db2e8eff0d869062021110407504420211121221445
namepath: /dzpz_pz/deleteflag
fullname: /dzpz_pz/deleteflag/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:29.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869052021110407504420211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869052021110407504420211121221445.60c562fa5db2e8eff0d869062021110407504420211121221445


id: 619a5454993208680e522a61
pid: 619a5454993208680e5229a1
name: description
code: 60c5615f5db2e8eff0d867d92021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/description
nodetype: column
createdate: 2021.06.13 09:37:38.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d92021110407504520211121221445


id: 619a5454993208680e522a65
pid: 619a5454993208680e5229a1
name: dynamicwhere
code: 60c5615f5db2e8eff0d867d82021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/dynamicwhere
nodetype: column
createdate: 2021.06.13 09:37:38.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d82021110407504520211121221445


id: 619a5454993208680e522a69
pid: 619a5454993208680e5229a1
name: dynamicwhere2
code: 60c5615f5db2e8eff0d867d62021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/dynamicwhere2
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d62021110407504520211121221445

value:
"a.corpid='"+ st_corpid+"' "
"b.y='"+st_y+"'"
"b.m='"+st_m+"'"
"b.code='"+st_code+"'"
"b.pzh like '%"+st_pzh+"%'"
iif( shzt==1, " c.verifierid is not null" , iif ( shzt==2, "c.verifierid is null ", ""))
"b."+st_key1+" like '%"+st_value1+"%'"
"b."+st_key2+" like '%"+st_value2+"%'"
"b.pzrq >='"+st_date1+"'"
"b.pzrq <'"+date2yyyymmdd(nextDate(yyyymmdd2Date(st_date2),1))+"'"


id: 619a5454993208680e522a6d
pid: 619a5454993208680e5229a1
name: dynamicwhere2_tokens
code: 60c5615f5db2e8eff0d867d72021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/dynamicwhere2_tokens
nodetype: column
createdate: 2021.06.13 09:37:38.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d72021110407504520211121221445

value:
{
    "\"a.corpid='\"+ st_corpid+\"' \"": "st_corpid",
    "\"b.y='\"+st_y+\"'\"": "st_y",
    "\"b.m='\"+st_m+\"'\"": "st_m",
    "\"b.code='\"+st_code+\"'\"": "st_code",
    "\"b.pzh like '%\"+st_pzh+\"%'\"": "st_pzh",
    "iif( shzt==1, \" c.verifierid is not null\" , iif ( shzt==2, \"c.verifierid is null \", \"\"))": "shzt",
    "\"b.\"+st_key1+\" like '%\"+st_value1+\"%'\"": "st_key1,st_value1",
    "\"b.\"+st_key2+\" like '%\"+st_value2+\"%'\"": "st_key2,st_value2",
    "\"b.pzrq >='\"+st_date1+\"'\"": "st_date1",
    "\"b.pzrq <'\"+date2yyyymmdd(nextDate(yyyymmdd2Date(st_date2),1))+\"'\"": "st_date2"
}


id: 619a5454993208680e522a71
pid: 619a5454993208680e5229a1
name: dynamicwheredata2
code: 60c5615f5db2e8eff0d867d52021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/dynamicwheredata2
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d52021110407504520211121221445

value:
st_corpid:filter!st_corpid
st_y:filter!st_y
st_m:filter!st_m
st_code:filter!st_code
st_pzh:filter!st_pzh
shzt:filter!shzt
st_key1:filter!st_key1
st_value1:filter!st_value1
st_key2:filter!st_key2
st_value2:filter!st_value2
st_date1:date2yyyymmdd(filter!st_date1)
st_date2:date2yyyymmdd(filter!st_date2)


id: 619a5454993208680e522a75
pid: 619a5454993208680e5229a1
name: fj
code: 60c562fa5db2e8eff0d869522021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/fj
nodetype: dbcol
value: 附件的图片数
createdate: 2021.06.13 09:44:43.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869522021110407504520211121221445


id: 619a5454993208680e522a79
pid: 619a5454993208680e522a75
name: coltype
code: 60c562fa5db2e8eff0d869532021110407504520211121221445
namepath: /dzpz_pz/fj
fullname: /dzpz_pz/fj/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:43.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869522021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869522021110407504520211121221445.60c562fa5db2e8eff0d869532021110407504520211121221445


id: 619a5454993208680e522a7d
pid: 619a5454993208680e5229a1
name: gguid
code: 60c562fa5db2e8eff0d869082021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/gguid
nodetype: dbcol
value: GGUID
createdate: 2021.06.13 09:44:29.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869082021110407504520211121221445


id: 619a5454993208680e522a81
pid: 619a5454993208680e522a7d
name: colsize
code: 60c562fa5db2e8eff0d8690a2021110407504520211121221445
namepath: /dzpz_pz/gguid
fullname: /dzpz_pz/gguid/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869082021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869082021110407504520211121221445.60c562fa5db2e8eff0d8690a2021110407504520211121221445


id: 619a5455993208680e522a85
pid: 619a5454993208680e522a7d
name: coltype
code: 60c562fa5db2e8eff0d869092021110407504520211121221445
namepath: /dzpz_pz/gguid
fullname: /dzpz_pz/gguid/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869082021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869082021110407504520211121221445.60c562fa5db2e8eff0d869092021110407504520211121221445


id: 619a5455993208680e522a89
pid: 619a5454993208680e5229a1
name: gguidinject
code: 613fd2c9993240476a10d2972021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/gguidinject
nodetype: column
value: false
createdate: 2021.09.14 06:38:11.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.613fd2c9993240476a10d2972021110407504520211121221445


id: 619a5455993208680e522a8d
pid: 619a5454993208680e5229a1
name: id
code: 60c562fa5db2e8eff0d8690c2021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/id
nodetype: dbcol
value: ID
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d8690c2021110407504520211121221445


id: 619a5455993208680e522a91
pid: 619a5455993208680e522a8d
name: colsize
code: 60c562fa5db2e8eff0d8690e2021110407504520211121221445
namepath: /dzpz_pz/id
fullname: /dzpz_pz/id/colsize
nodetype: column
value: 40
createdate: 2021.06.13 09:44:31.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d8690c2021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d8690c2021110407504520211121221445.60c562fa5db2e8eff0d8690e2021110407504520211121221445


id: 619a5455993208680e522a95
pid: 619a5455993208680e522a8d
name: coltype
code: 60c562fa5db2e8eff0d8690d2021110407504520211121221445
namepath: /dzpz_pz/id
fullname: /dzpz_pz/id/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:30.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d8690c2021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d8690c2021110407504520211121221445.60c562fa5db2e8eff0d8690d2021110407504520211121221445


id: 619a5455993208680e522aa5
pid: 619a5454993208680e5229a1
name: lastmodifieddate
code: 60c562fa5db2e8eff0d869172021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/lastmodifieddate
nodetype: dbcol
value: 数据最后修改日期
createdate: 2021.06.13 09:44:32.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445


id: 619a5455993208680e522aa9
pid: 619a5455993208680e522aa5
name: coltype
code: 60c562fa5db2e8eff0d869182021110407504520211121221445
namepath: /dzpz_pz/lastmodifieddate
fullname: /dzpz_pz/lastmodifieddate/coltype
nodetype: column
value: datetime
createdate: 2021.06.13 09:44:32.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445.60c562fa5db2e8eff0d869182021110407504520211121221445


id: 619a5455993208680e522aad
pid: 619a5455993208680e522aa5
name: nullable
code: 618499a5993236a4844fa1d520211121221445
namepath: /dzpz_pz/lastmodifieddate
fullname: /dzpz_pz/lastmodifieddate/nullable
nodetype: column
value: true
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:18.594
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445.618499a5993236a4844fa1d520211121221445


id: 619a5455993208680e522ab1
pid: 619a5455993208680e522aa5
name: smartretrieve
code: 618499a5993236a4844fa1d720211121221445
namepath: /dzpz_pz/lastmodifieddate
fullname: /dzpz_pz/lastmodifieddate/smartretrieve
nodetype: column
value: false
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:18.594
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445.618499a5993236a4844fa1d720211121221445


id: 619a5455993208680e522ab5
pid: 619a5455993208680e522aa5
name: updatable
code: 618499a5993236a4844fa1d620211121221445
namepath: /dzpz_pz/lastmodifieddate
fullname: /dzpz_pz/lastmodifieddate/updatable
nodetype: column
value: true
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445.618499a5993236a4844fa1d620211121221445


id: 619a5455993208680e522ab9
pid: 619a5455993208680e522aa5
name: usedingroupby
code: 618499a5993236a4844fa1d820211121221445
namepath: /dzpz_pz/lastmodifieddate
fullname: /dzpz_pz/lastmodifieddate/usedingroupby
nodetype: column
value: false
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445.618499a5993236a4844fa1d820211121221445


id: 619a5455993208680e522abd
pid: 619a5455993208680e522aa5
name: usedinsum
code: 618499a5993236a4844fa1d920211121221445
namepath: /dzpz_pz/lastmodifieddate
fullname: /dzpz_pz/lastmodifieddate/usedinsum
nodetype: column
value: false
createdate: 2021.11.05 11:56:38.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869172021110407504520211121221445.618499a5993236a4844fa1d920211121221445


id: 619a5455993208680e522ac1
pid: 619a5454993208680e5229a1
name: multirow
code: 60c560a05db2e8eff0d867b32021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/multirow
nodetype: column
value: true
createdate: 2021.06.13 09:37:13.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867b32021110407504520211121221445


id: 619a5455993208680e522ac5
pid: 619a5454993208680e5229a1
name: needcache
code: 60c560a05db2e8eff0d867b72021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/needcache
nodetype: column
value: false
createdate: 2021.06.13 09:37:15.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867b72021110407504520211121221445


id: 619a5455993208680e522ad5
pid: 619a5454993208680e5229a1
name: primarykey
code: 60c560a05db2e8eff0d867c52021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/primarykey
nodetype: column
value: id
createdate: 2021.06.13 09:37:32.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c52021110407504520211121221445


id: 619a5455993208680e522ad9
pid: 619a5454993208680e5229a1
name: pz
code: 60c562fa5db2e8eff0d869552021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/pz
nodetype: dbcol
value: 凭证的图片数
createdate: 2021.06.13 09:44:44.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869552021110407504520211121221445


id: 619a5455993208680e522add
pid: 619a5455993208680e522ad9
name: coltype
code: 60c562fa5db2e8eff0d869562021110407504520211121221445
namepath: /dzpz_pz/pz
fullname: /dzpz_pz/pz/coltype
nodetype: column
value: int
createdate: 2021.06.13 09:44:44.000
lastmodifieddate: 2024.09.18 14:41:18.595
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869552021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869552021110407504520211121221445.60c562fa5db2e8eff0d869562021110407504520211121221445


id: 619a5455993208680e522ae1
pid: 619a5454993208680e5229a1
name: pzh
code: 60c562fa5db2e8eff0d869202021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/pzh
nodetype: dbcol
value: 凭证号
createdate: 2021.06.13 09:44:33.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869202021110407504520211121221445


id: 619a5455993208680e522ae5
pid: 619a5455993208680e522ae1
name: colsize
code: 60c562fa5db2e8eff0d869222021110407504520211121221445
namepath: /dzpz_pz/pzh
fullname: /dzpz_pz/pzh/colsize
nodetype: column
value: 20
createdate: 2021.06.13 09:44:34.000
lastmodifieddate: 2024.09.18 14:41:18.595
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869202021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869202021110407504520211121221445.60c562fa5db2e8eff0d869222021110407504520211121221445


id: 619a5455993208680e522ae9
pid: 619a5455993208680e522ae1
name: coltype
code: 60c562fa5db2e8eff0d869212021110407504520211121221445
namepath: /dzpz_pz/pzh
fullname: /dzpz_pz/pzh/coltype
nodetype: column
value: varchar
createdate: 2021.06.13 09:44:34.000
lastmodifieddate: 2024.09.18 14:41:18.595
codepath:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869202021110407504520211121221445

fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c562fa5db2e8eff0d869202021110407504520211121221445.60c562fa5db2e8eff0d869212021110407504520211121221445


id: 619a5455993208680e522aed
pid: 619a5454993208680e5229a1
name: redis
code: 60c560a05db2e8eff0d867c62021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/redis
nodetype: column
createdate: 2021.06.13 09:37:34.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c62021110407504520211121221445


id: 619a5455993208680e522af1
pid: 619a5454993208680e5229a1
name: rowcountlimit
code: 60c560a05db2e8eff0d867b62021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/rowcountlimit
nodetype: column
value: 0
createdate: 2021.06.13 09:37:14.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867b62021110407504520211121221445


id: 619a5455993208680e522b29
pid: 619a5454993208680e5229a1
name: sourcetype
code: 60c560a05db2e8eff0d867c22021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/sourcetype
nodetype: column
value: sql
createdate: 2021.06.13 09:37:31.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c22021110407504520211121221445


id: 619a5455993208680e522b2d
pid: 619a5454993208680e5229a1
name: sql
code: 60c5615f5db2e8eff0d867d42021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/sql
nodetype: column
createdate: 2021.06.13 09:37:37.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c5615f5db2e8eff0d867d42021110407504520211121221445

value:
select
  a.corpid,
  b.*,
  c.id as img_id,
  c.pz,
  c.fj,
  ifnull(c.pz, 0) + ifnull(c.fj, 0) as img_sl,
  case when c.verifierid is not null then 1 else 0 end as is_verified
from
  pzdj a
  inner join pzdjex b on a.gguid = b.gguid
  left join dzpz_pz c on a.corpid = c.corpid
  and b.pzh = c.pzh
order by
  a.corpid asc,
  b.y asc,
  b.m asc,
  b.pzh asc


id: 619a5455993208680e522b31
pid: 619a5454993208680e5229a1
name: sqlinject
code: 60c560a05db2e8eff0d867b42021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/sqlinject
nodetype: column
value: true
createdate: 2021.06.13 09:37:14.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867b42021110407504520211121221445


id: 619a5455993208680e522b41
pid: 619a5454993208680e5229a1
name: timeout
code: 60c560a05db2e8eff0d867b82021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/timeout
nodetype: column
value: 30
createdate: 2021.06.13 09:37:15.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867b82021110407504520211121221445


id: 619a5455993208680e522b51
pid: 619a5454993208680e5229a1
name: type_api
code: 60c560a05db2e8eff0d867c32021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/type_api
nodetype: column
value: api
createdate: 2021.06.13 09:37:31.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c32021110407504520211121221445


id: 619a5455993208680e522b55
pid: 619a5454993208680e5229a1
name: type_sql
code: 60c560a05db2e8eff0d867c12021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/type_sql
nodetype: column
value: sql
createdate: 2021.06.13 09:37:31.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c12021110407504520211121221445


id: 619a5455993208680e522b59
pid: 619a5454993208680e5229a1
name: updatedtable
code: 60c560a05db2e8eff0d867c42021110407504520211121221445
namepath: /dzpz_pz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444
fullname: /dzpz_pz/updatedtable
nodetype: column
value: dzpz_pz
createdate: 2021.06.13 09:37:32.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.60c560a05db2e8eff0d867c42021110407504520211121221445


id: 619a54f8993208680e522d5d
pid: 619a54f8993208680e522d5c
name: coltype
code: 619a54f8993208680e522d5d
namepath: /dzpz_pz/bz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d5c
fullname: /dzpz_pz/bz/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d5c.619a54f8993208680e522d5d


id: 619a54f8993208680e522d5e
pid: 619a54f8993208680e522d5c
name: colsize
code: 619a54f8993208680e522d5e
namepath: /dzpz_pz/bz
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d5c
fullname: /dzpz_pz/bz/colsize
nodetype: column
value: 50
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d5c.619a54f8993208680e522d5e


id: 619a54f8993208680e522d61
pid: 619a54f8993208680e522d60
name: coltype
code: 619a54f8993208680e522d61
namepath: /dzpz_pz/code
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d60
fullname: /dzpz_pz/code/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d60.619a54f8993208680e522d61


id: 619a54f8993208680e522d62
pid: 619a54f8993208680e522d60
name: colsize
code: 619a54f8993208680e522d62
namepath: /dzpz_pz/code
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d60
fullname: /dzpz_pz/code/colsize
nodetype: column
value: 20
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.595
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d60.619a54f8993208680e522d62


id: 619a54f8993208680e522d65
pid: 619a54f8993208680e522d64
name: coltype
code: 619a54f8993208680e522d65
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a54f8993208680e522d65


id: 619a54f8993208680e522d66
pid: 619a54f8993208680e522d64
name: colsize
code: 619a54f8993208680e522d66
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/colsize
nodetype: column
value: 10
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a54f8993208680e522d66


id: 619a54f8993208680e522d6d
pid: 619a54f8993208680e522d6c
name: coltype
code: 619a54f8993208680e522d6d
namepath: /dzpz_pz/inner_xh
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d6c
fullname: /dzpz_pz/inner_xh/coltype
nodetype: column
value: int
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d6c.619a54f8993208680e522d6d


id: 619a54f8993208680e522d71
pid: 619a54f8993208680e522d70
name: coltype
code: 619a54f8993208680e522d71
namepath: /dzpz_pz/m
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d70
fullname: /dzpz_pz/m/coltype
nodetype: column
value: int
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d70.619a54f8993208680e522d71


id: 619a54f8993208680e522d74
pid: 619a54f8993208680e522d73
name: coltype
code: 619a54f8993208680e522d74
namepath: /dzpz_pz/posted
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d73
fullname: /dzpz_pz/posted/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d73.619a54f8993208680e522d74


id: 619a54f8993208680e522d75
pid: 619a54f8993208680e522d73
name: colsize
code: 619a54f8993208680e522d75
namepath: /dzpz_pz/posted
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d73
fullname: /dzpz_pz/posted/colsize
nodetype: column
value: 4
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d73.619a54f8993208680e522d75


id: 619a54f8993208680e522d79
pid: 619a54f8993208680e522d78
name: coltype
code: 619a54f8993208680e522d79
namepath: /dzpz_pz/pzrq
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d78
fullname: /dzpz_pz/pzrq/coltype
nodetype: column
value: datetime
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d78.619a54f8993208680e522d79


id: 619a54f8993208680e522d7c
pid: 619a54f8993208680e522d7b
name: coltype
code: 619a54f8993208680e522d7c
namepath: /dzpz_pz/y
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d7b
fullname: /dzpz_pz/y/coltype
nodetype: column
value: int
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d7b.619a54f8993208680e522d7c


id: 619a54f8993208680e522d7f
pid: 619a54f8993208680e522d7e
name: coltype
code: 619a54f8993208680e522d7f
namepath: /dzpz_pz/kmdm
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d7e
fullname: /dzpz_pz/kmdm/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d7e.619a54f8993208680e522d7f


id: 619a54f8993208680e522d80
pid: 619a54f8993208680e522d7e
name: colsize
code: 619a54f8993208680e522d80
namepath: /dzpz_pz/kmdm
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d7e
fullname: /dzpz_pz/kmdm/colsize
nodetype: column
value: 50
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d7e.619a54f8993208680e522d80


id: 619a54f8993208680e522d83
pid: 619a54f8993208680e522d82
name: coltype
code: 619a54f8993208680e522d83
namepath: /dzpz_pz/kmmc
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d82
fullname: /dzpz_pz/kmmc/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d82.619a54f8993208680e522d83


id: 619a54f8993208680e522d84
pid: 619a54f8993208680e522d82
name: colsize
code: 619a54f8993208680e522d84
namepath: /dzpz_pz/kmmc
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d82
fullname: /dzpz_pz/kmmc/colsize
nodetype: column
value: 100
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d82.619a54f8993208680e522d84


id: 619a54f8993208680e522d87
pid: 619a54f8993208680e522d86
name: coltype
code: 619a54f8993208680e522d87
namepath: /dzpz_pz/rkdh
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d86
fullname: /dzpz_pz/rkdh/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d86.619a54f8993208680e522d87


id: 619a54f8993208680e522d88
pid: 619a54f8993208680e522d86
name: colsize
code: 619a54f8993208680e522d88
namepath: /dzpz_pz/rkdh
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d86
fullname: /dzpz_pz/rkdh/colsize
nodetype: column
value: 50
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d86.619a54f8993208680e522d88


id: 619a54f8993208680e522d8b
pid: 619a54f8993208680e522d8a
name: coltype
code: 619a54f8993208680e522d8b
namepath: /dzpz_pz/zdr
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d8a
fullname: /dzpz_pz/zdr/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d8a.619a54f8993208680e522d8b


id: 619a54f8993208680e522d8c
pid: 619a54f8993208680e522d8a
name: colsize
code: 619a54f8993208680e522d8c
namepath: /dzpz_pz/zdr
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d8a
fullname: /dzpz_pz/zdr/colsize
nodetype: column
value: 30
createdate: 2021.11.21 22:18:24.000
lastmodifieddate: 2024.09.18 14:41:18.596
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d8a.619a54f8993208680e522d8c


id: 619a5530993208680e522dd1
pid: 619a5530993208680e522dd0
name: coltype
code: 619a5530993208680e522dd1
namepath: /dzpz_pz/img_id
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522dd0
fullname: /dzpz_pz/img_id/coltype
nodetype: column
value: varchar
createdate: 2021.11.21 22:19:10.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522dd0.619a5530993208680e522dd1


id: 619a5530993208680e522dd2
pid: 619a5530993208680e522dd0
name: colsize
code: 619a5530993208680e522dd2
namepath: /dzpz_pz/img_id
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522dd0
fullname: /dzpz_pz/img_id/colsize
nodetype: column
value: 40
createdate: 2021.11.21 22:19:10.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522dd0.619a5530993208680e522dd2


id: 619a559d993208680e522e06
pid: 619a5530993208680e522e05
name: coltype
code: 619a559d993208680e522e06
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/coltype
nodetype: column
value: int
createdate: 2021.11.21 22:20:13.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a559d993208680e522e06


id: 619a55c7993208680e522e7e
pid: 619a5530993208680e522e05
name: nullable
code: 619a55c7993208680e522e7e
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/nullable
nodetype: column
value: true
createdate: 2021.11.21 22:21:06.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e7e


id: 619a55c7993208680e522e7f
pid: 619a5530993208680e522e05
name: updatable
code: 619a55c7993208680e522e7f
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/updatable
nodetype: column
value: true
createdate: 2021.11.21 22:21:06.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e7f


id: 619a55c7993208680e522e80
pid: 619a5530993208680e522e05
name: smartretrieve
code: 619a55c7993208680e522e80
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/smartretrieve
nodetype: column
value: false
createdate: 2021.11.21 22:21:06.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e80


id: 619a55c7993208680e522e81
pid: 619a5530993208680e522e05
name: usedingroupby
code: 619a55c7993208680e522e81
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/usedingroupby
nodetype: column
value: false
createdate: 2021.11.21 22:21:06.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e81


id: 619a55c7993208680e522e82
pid: 619a5530993208680e522e05
name: usedinsum
code: 619a55c7993208680e522e82
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/usedinsum
nodetype: column
value: false
createdate: 2021.11.21 22:21:06.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e82


id: 619a55c7993208680e522e89
pid: 619a5530993208680e522e05
name: colsize
code: 619a55c7993208680e522e89
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/colsize
nodetype: column
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e89


id: 619a55c7993208680e522e8a
pid: 619a5530993208680e522e05
name: decimalcount
code: 619a55c7993208680e522e8a
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/decimalcount
nodetype: column
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e8a


id: 619a55c7993208680e522e8b
pid: 619a5530993208680e522e05
name: defaultvalue
code: 619a55c7993208680e522e8b
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/defaultvalue
nodetype: column
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e8b


id: 619a55c7993208680e522e8c
pid: 619a5530993208680e522e05
name: dbdefaultvalue
code: 619a55c7993208680e522e8c
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/dbdefaultvalue
nodetype: column
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e8c


id: 619a55c7993208680e522e8d
pid: 619a5530993208680e522e05
name: datamask
code: 619a55c7993208680e522e8d
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/datamask
nodetype: column
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e8d


id: 619a55c7993208680e522e8e
pid: 619a5530993208680e522e05
name: description
code: 619a55c7993208680e522e8e
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/description
nodetype: column
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e8e


id: 619a55c7993208680e522e8f
pid: 619a5530993208680e522e05
name: dynamicwhere2_tokens
code: 619a55c7993208680e522e8f
namepath: /dzpz_pz/img_sl
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05
fullname: /dzpz_pz/img_sl/dynamicwhere2_tokens
nodetype: column
value: {}
createdate: 2021.11.21 22:21:19.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a5530993208680e522e05.619a55c7993208680e522e8f


id: 619a55c7993208680e522ea3
pid: 619a54f8993208680e522d64
name: nullable
code: 619a55c7993208680e522ea3
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/nullable
nodetype: column
value: true
createdate: 2021.11.21 22:21:31.000
lastmodifieddate: 2024.09.18 14:41:19.009
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a55c7993208680e522ea3


id: 619a55c7993208680e522ea4
pid: 619a54f8993208680e522d64
name: updatable
code: 619a55c7993208680e522ea4
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/updatable
nodetype: column
value: true
createdate: 2021.11.21 22:21:31.000
lastmodifieddate: 2024.09.18 14:41:19.010
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a55c7993208680e522ea4


id: 619a55c7993208680e522ea5
pid: 619a54f8993208680e522d64
name: smartretrieve
code: 619a55c7993208680e522ea5
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/smartretrieve
nodetype: column
value: false
createdate: 2021.11.21 22:21:31.000
lastmodifieddate: 2024.09.18 14:41:19.010
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a55c7993208680e522ea5


id: 619a55c7993208680e522ea6
pid: 619a54f8993208680e522d64
name: usedingroupby
code: 619a55c7993208680e522ea6
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/usedingroupby
nodetype: column
value: false
createdate: 2021.11.21 22:21:31.000
lastmodifieddate: 2024.09.18 14:41:19.010
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a55c7993208680e522ea6


id: 619a55c7993208680e522ea7
pid: 619a54f8993208680e522d64
name: usedinsum
code: 619a55c7993208680e522ea7
namepath: /dzpz_pz/pzdjex_corpid
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64
fullname: /dzpz_pz/pzdjex_corpid/usedinsum
nodetype: column
value: false
createdate: 2021.11.21 22:21:31.000
lastmodifieddate: 2024.09.18 14:41:19.010
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a54f8993208680e522d64.619a55c7993208680e522ea7


id: 619a59ed993208680e522edd
pid: 619a59ed993208680e522edc
name: coltype
code: 619a59ed993208680e522edd
namepath: /dzpz_pz/is_verified
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619a59ed993208680e522edc
fullname: /dzpz_pz/is_verified/coltype
nodetype: column
value: int
createdate: 2021.11.21 22:38:38.000
lastmodifieddate: 2024.09.18 14:41:19.010
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619a59ed993208680e522edc.619a59ed993208680e522edd


id: 619b10ef993208680e523518
pid: 619b10ef993208680e523517
name: coltype
code: 619b10ef993208680e523518
namepath: /dzpz_pz/ckzcmxdm
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523517
fullname: /dzpz_pz/ckzcmxdm/coltype
nodetype: column
value: varchar
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523517.619b10ef993208680e523518


id: 619b10ef993208680e523519
pid: 619b10ef993208680e523517
name: colsize
code: 619b10ef993208680e523519
namepath: /dzpz_pz/ckzcmxdm
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523517
fullname: /dzpz_pz/ckzcmxdm/colsize
nodetype: column
value: 50
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523517.619b10ef993208680e523519


id: 619b10ef993208680e52351c
pid: 619b10ef993208680e52351b
name: coltype
code: 619b10ef993208680e52351c
namepath: /dzpz_pz/ckzcmxmc
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351b
fullname: /dzpz_pz/ckzcmxmc/coltype
nodetype: column
value: varchar
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351b.619b10ef993208680e52351c


id: 619b10ef993208680e52351d
pid: 619b10ef993208680e52351b
name: colsize
code: 619b10ef993208680e52351d
namepath: /dzpz_pz/ckzcmxmc
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351b
fullname: /dzpz_pz/ckzcmxmc/colsize
nodetype: column
value: 100
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351b.619b10ef993208680e52351d


id: 619b10ef993208680e523520
pid: 619b10ef993208680e52351f
name: coltype
code: 619b10ef993208680e523520
namepath: /dzpz_pz/ykzcmxdm
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351f
fullname: /dzpz_pz/ykzcmxdm/coltype
nodetype: column
value: varchar
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351f.619b10ef993208680e523520


id: 619b10ef993208680e523521
pid: 619b10ef993208680e52351f
name: colsize
code: 619b10ef993208680e523521
namepath: /dzpz_pz/ykzcmxdm
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351f
fullname: /dzpz_pz/ykzcmxdm/colsize
nodetype: column
value: 50
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e52351f.619b10ef993208680e523521


id: 619b10ef993208680e523524
pid: 619b10ef993208680e523523
name: coltype
code: 619b10ef993208680e523524
namepath: /dzpz_pz/ykzcmxmc
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523523
fullname: /dzpz_pz/ykzcmxmc/coltype
nodetype: column
value: varchar
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523523.619b10ef993208680e523524


id: 619b10ef993208680e523525
pid: 619b10ef993208680e523523
name: colsize
code: 619b10ef993208680e523525
namepath: /dzpz_pz/ykzcmxmc
codepath: 60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523523
fullname: /dzpz_pz/ykzcmxmc/colsize
nodetype: column
value: 100
createdate: 2021.11.22 11:39:28.000
lastmodifieddate: 2024.09.18 14:41:19.012
fullcode:
60c560a05db2e8eff0d867a82021110407504420211121221444.619b10ef993208680e523523.619b10ef993208680e523525


id: 6580cd9099320041501b09cb
pid: 657ffbd799320041501b09a7
name: sql
nodetype: column
createdate: 2023.12.19 06:54:15.000
lastmodifieddate: 2024.09.18 14:41:23.954
value:
select
  a.billno,
  a.billdate,
  a.reader,
  a.summary,
  a.pass,
  a.flow_instance_status,
  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 a.corpid = c.corpid
  and b.pzh = c.pzh
group by
  a.billno,
  a.billdate,
  a.reader,
  a.summary,
  a.pass,
  a.flow_instance_status
order by
  a.billno desc


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


id: 662a47879932b5035f32ef6b
pid: 662a47869932b5035f32ef63
name: sql
nodetype: column
createdate: 2024.04.25 20:07:36.000
lastmodifieddate: 2024.09.18 14:41:24.320
value:
select * from  pz_yjd   where ifnull(deleteflag,0)=0 and (billtype='交办' or billtype is null )
order by billno desc


id: 663b1be899327b97e92d7745
pid: 663b1be899327b97e92d771e
name: sql
nodetype: column
createdate: 2024.05.08 14:33:43.000
lastmodifieddate: 2024.09.18 14:41:32.328
value:
select a.* , b.pzh1, b.pzh2 , b.pzs, b.memo , c.pzh from 
pz_yjd a , pz_yjdex b ,  pzbmx  c     where a.gguid=b.gguid
 and c.pzh>= b.pzh1 and c.pzh<=b.pzh2
 
 order by a.billno desc , c.pzh asc


id: 665ea74799327550ff10de52
pid: 665ea74799327550ff10de2b
name: sql
nodetype: column
createdate: 2024.06.04 13:44:09.000
lastmodifieddate: 2024.09.18 14:41:33.731
value:
select
  pz_yjd_pzh.*,
  pz_yjdex.inner_xh as groupno
from
  pz_yjd_pzh
  left join pz_yjdex on (
    pz_yjd_pzh.gguid = pz_yjdex.gguid
   and pz_yjd_pzh.ny = pz_yjdex.ny
    and pz_yjd_pzh.pzh >= pz_yjdex.pzh1
    and pz_yjd_pzh.pzh <= pz_yjdex.pzh2
  )
order by
  pz_yjdex.inner_xh asc,
  pz_yjd_pzh.pzh asc


id: 669dc6169932df22f60cbf61
pid: 669dc6169932df22f60cbe69
name: sql
nodetype: column
createdate: 2024.06.04 13:44:09.000
lastmodifieddate: 2024.09.18 14:41:40.064
value:
select
  pz_yjd_pzh.*,
  pz_yjdex.inner_xh as groupno
from
  pz_yjd_pzh
  left join pz_yjdex on (
    pz_yjd_pzh.gguid = pz_yjdex.gguid
    and pz_yjd_pzh.pzh >= pz_yjdex.pzh1
    and pz_yjd_pzh.pzh <= pz_yjdex.pzh2
  )
order by
  pz_yjdex.inner_xh asc,
  pz_yjd_pzh.pzh asc


id: 66a3079e993295696042f8fb
pid: 66a3075c993295696042f8cd
name: sql
nodetype: column
createdate: 2024.07.26 10:19:23.000
lastmodifieddate: 2024.09.18 14:41:54.125
value:
select jb.* , jh.state ,jy.state,gh.state
    , case when jb.state='0' then '交办申请中' 
      when jb.state='-1' then '交办退回' 
      when jb.state='1' and jh.state='0' then '交回申请中' 
      when jb.state='1' and jh.state='-1' then '交回退回' 
      when jb.state='1' and jh.state='1' then '交办且已交回' 
      when jb.state='1'  then '交办没有交回' 
     else '' end as jb_state

    , case when jy.state='0'  then '借阅申请中' 
      when jy.state='-1' then '借阅退回' 
      when jy.state='1' and gh.state='0'  then '归还申请中' 
      when jy.state='1' and gh.state=-1 then '归还退回' 
      when jy.state='1' and gh.state='1' then '借阅且已归还' 
      when jy.state='1' then '借阅没有归还' 
     else '' end as jy_state
    
     from (
        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state, a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status
    from (
        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state,b1.flow_instance_status,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='交办' and state not in (-99) )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  
        ) a 
        inner  join  (
            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='交办' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  
        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate 
    ) jb 
    left join (
        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny,  a.state, a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status
    from (
        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='交回' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  
        ) a 
        inner  join  (
            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='交回' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  
        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate 
    ) jh on jb.corpid_ny_pzh=jh.corpid_ny_pzh
    left join (
        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state,  a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status
    from (
        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='借阅' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  
        ) a 
        inner  join  (
            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='借阅' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  
        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate 
    ) jy on jb.corpid_ny_pzh=jy.corpid_ny_pzh
    left join (
        select  a.lastmodifieddate, a.corpid_ny_pzh, a.ny, a.state,  a.pzh, a.corpid, a.flow_instance_state,a.flow_instance_status
    from (
        select a1.pzh, a1.ny, a1.state, b1.lastmodifieddate, b1.corpid, b1.flow_instance_state, b1.flow_instance_status, CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='归还' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  
        ) a 
        inner  join  (
            select max(lastmodifieddate) as lastmodifieddate, corpid_ny_pzh from (select b1.lastmodifieddate, b1.corpid,  CONCAT( CONCAT(b1.corpid, a1.ny), a1.pzh) AS corpid_ny_pzh 
        from ( select * from pz_yjd_pzh where billtype='归还' and state not in (-99)  )  a1 left join pz_yjd b1 on a1.gguid=b1.gguid where  b1.corpid is not null  ) aa group by corpid_ny_pzh  
        ) b on a.corpid_ny_pzh=b.corpid_ny_pzh and a.lastmodifieddate=b.lastmodifieddate 
    ) gh  on jb.corpid_ny_pzh=gh.corpid_ny_pzh
    
    order by jb.lastmodifieddate desc


