jnpf-common-v6x/jnpf-boot-common/jnpf-common-database/target/classes/jnpf/database/sql/util/SqlFrameFastUtil.java

package jnpf.database.sql.util;

/**
 * 类功能
 *
 * @author JNPF开发平台组 YanYu
 * @version V3.3
 * @copyright 引迈信息技术有限公司
 * @date 2022-06-13
 */
public class SqlFrameFastUtil {

    /**
     * 增填权限
     */
    public final static String INSERT_AUTHORIZE = "INSERT INTO base_authorize (F_ID, f_item_type, f_item_id, f_object_type, f_object_id, f_sort_code, f_creator_time, f_creator_user_id %COLUMN_KEY% ) VALUES  (?,?,?,?,?,?,?,? %COLUMN_PLACEHOLDER%)";
    public final static String INSERT_AUTHORIZE2 = "INSERT INTO base_authorize (F_ID, f_item_type, f_item_id, f_object_type, f_object_id, f_sort_code, f_creator_time, f_creator_user_id %COLUMN_KEY% ) VALUES  (?,?,?,?,?,?,TO_DATE(?,'yyyy-mm-dd hh24:mi:ss'),? %COLUMN_PLACEHOLDER%)";
    public final static String AUTHOR_DEL = "DELETE FROM base_authorize WHERE (f_object_id in( '{authorizeIds}') AND f_item_type in( 'system','module','button','column','form','resource'))";



    public final static String INSERT_ADMINISTRATOR = "INSERT INTO base_organize_administrator (f_id, f_user_id, f_organize_id, f_organize_type, f_this_layer_add, f_this_layer_edit, f_this_layer_delete, f_sub_layer_add, f_sub_layer_edit, f_sub_layer_delete, f_this_layer_select, f_sub_layer_select, f_manager_group, f_creator_time, f_creator_user_id,f_enabled_mark %COLUMN_KEY% ) VALUES  (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? %COLUMN_PLACEHOLDER%)";
    public final static String INSERT_ADMINISTRATOR2 = "INSERT INTO base_organize_administrator (f_id, f_user_id, f_organize_id, f_organize_type, f_this_layer_add, f_this_layer_edit, f_this_layer_delete, f_sub_layer_add, f_sub_layer_edit, f_sub_layer_delete, f_this_layer_select, f_sub_layer_select, f_manager_group, f_creator_time, f_creator_user_id,f_enabled_mark %COLUMN_KEY% ) VALUES  (?,?,?,?,?,?,?,?,?,?,?,?,?,TO_TIMESTAMP(?,'yyyy-mm-dd hh24:mi:ss'),?,? %COLUMN_PLACEHOLDER%)";
    public final static String ADMINISTRATOR_DEL = "DELETE FROM base_organize_administrator WHERE (f_user_id in( '{userId}') )";


}