联动值充值记录 __6I4WUGwZ9HWQcf15Y7G __KWBHssgPtqkxvqhTKlW true 10 true false false false false relatedForm month normal false 0 __lKHeK1mwNNDe1Czir1B true public = '"+format(start_time,"yyyy-MM-dd HH:mm:ss")+"' "; } if(isNotNull(end_time)){ whereStr += "and item_created_time <= '"+format(end_time,"yyyy-MM-dd HH:mm:ss")+"' "; } if(isNotNull(organization_name)){ whereStr += "and item_organization_name like concat('%','"+organization_name+"','%') "; } if(isNotNull(type)){ whereStr += "and item_type = '" + type + "'"; } var sql = "select '"+getDomainid()+"' as domainid,"+ "item_organization_name,"+ // 企业名称 "item_created_time,"+ // 充值时间 "item_points,"+ // 联动值 "case item_type when 0 then '企业充值' when 5 then '平台充值' end as item_type ,"+ // 充值来源 "item_reference_number,"+ // 交易流水号 "item_operatorname, "+ // 充值人 "item_price " + //金额 " from tlk_org_purse_transaction where item_points > 0 "+ whereStr +" order by item_created_time desc" ; return sql; })()]]> [] 1 02 0 0