• Home
• com.lframework
• gen
• 2.0.1
• source code
• mapper.list.xml.ftl

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

templates.mapper.list.xml.ftl Maven / Gradle / Ivy

    
        <#list entity.columns as column>
            <#if column.isKey>
        
            <#else>
        
            
        
    

    
        SELECT
        <#list entity.columns as column>
            tb.${column.columnName}<#if column_index != entity.columns?size - 1>,
        
        FROM ${entity.tableName} AS tb
    

    <#if queryParams??>
    
        
        
            <#list queryParams.columns as column>
                <#if column.viewType == 6>
            
            AND tb.${column.columnName} >= ${r"#{"}vo.${column.name}${r"Start}"}
            
            
            
            
                <#else>
            
            <@format><#include "query-type-sql.ftl"/>
            
                
            
        
        <#if orderColumns?? && (orderColumns?size > 0) >
        ORDER BY <#list orderColumns as orderColumn>tb.${orderColumn.columnName} ${orderColumn.orderType}<#if orderColumn_index != orderColumns?size - 1>, 
        
    
    

    
        
        
            <#list keys as key>
            AND tb.${key.columnName} = ${r"#{"}${key.name}${r"}"}