package com.ejie.m62fb.dao.registroVPP;

import com.ejie.m62fb.dao.SQLGenericas;
import com.ejie.m62fb.utils.constants.BDConstantes;

public class DocumentoAcuerdoReservaDaoSql {

	/**
	 * StringBuilder initilization value
	 */
	public static final int STRING_BUILDER_INIT = 4096;
	public static final String SEQUENCE_NAME = "";
	// TODO Poner el sinonimo en M62FB

	public static final String TABLA = BDConstantes.DOCUMENTO_ACUERDO_VIVIENDA;
	public static final String ALIAS = " DOC";
	public static final String PK = "ID_M62R42T0";

	// INSERT M62E42T0
	public static final String SQL_INSERT_DATOS_DOCUMENTO = "INSERT INTO"
			+ TABLA + "(ID_M62R41T0,OBJ_FICH_DOC,FEH_GENERACION,NOM_DOCUMENTO "
			+ SQLGenericas.INSERT_ABSTRACT_CLASS_SQL + ") "
			+ "VALUES (?,?,TRUNC(SYSDATE),?"
			+ SQLGenericas.INSERT_ABSTRACT_CLASS_QUESTION_TAGS + ")";
	// SELECT
	public static final String SQL_SELECT = "SELECT ID_M62R42T0,ID_M62R41T0,OBJ_FICH_DOC,FEH_GENERACION,NOM_DOCUMENTO "
			+ // AbstractClass
			SQLGenericas.getSqlCamposAbstractClass(ALIAS);
	public static final String SQL_FROM = " FROM " + TABLA + ALIAS;
	public static final String SQL_WHERE_ID = " WHERE " + PK + " = ?";

	public static final String SQL_FIND_DESCARGA = SQL_SELECT + SQL_FROM
			+ SQL_WHERE_ID;

	public static final String SQL_WHERE_BY_ACUERDO = " WHERE ID_M62R41T0 = ?";

	public static final String SQL_FIND_DESCARGA_BY_ACUERDO = SQL_SELECT
			+ SQL_FROM + SQL_WHERE_BY_ACUERDO;
}