package com.ejie.ad74a.dao;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;

/**
 * DocumentosInfSocialDaoSql generated by UDA, 06-nov-2024 13:24:02.
 * @author UDA
 */
@Repository
@Transactional
public class DocumentosInfSocialDaoSql{
	public static final String TABLA = "DOCUMENTOS_INF_SOCIAL";
	public static final String ALIAS_DOCUMENTOSINFSOCIAL = " DOCUMENTOSINFSOCIAL";
	public static final String ID_TABLA = "ID_EXPEDIENTE_00";
	public static final String ALIAS_ID_TABLA = "IDEXPEDIENTE00";

	public static final String SQL_SELECT = "SELECT "
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".ID_EXPEDIENTE_00 IDEXPEDIENTE00,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".OIDDOKUSI_18 OIDDOKUSI18,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".NOMBRE_DOC_18 NOMBREDOC18,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".F_INFORME_02 FINFORME02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".SOLA_02 SOLA02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".ESTA_SOLA_MANANA_02 ESTASOLAMANANA02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".ESTA_SOLA_TARDE_02 ESTASOLATARDE02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".ESTA_SOLA_NOCHE_02 ESTASOLANOCHE02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".RELACION_ENTORNO_02 RELACIONENTORNO02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".FAMILIAR_FALLECIDO_02 FAMILIARFALLECIDO02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".VINCULO_FALLECIDO_02 VINCULOFALLECIDO02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".VISITAS_FAMILIA_02 VISITASFAMILIA02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".VISITAS_AMIGOS_02 VISITASAMIGOS02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".FRECUENCIA_SALIDAS_02 FRECUENCIASALIDAS02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".PERIODO_SIN_VISITAS_02 PERIODOSINVISITAS02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".TIEMPO_SIN_VISITAS_02 TIEMPOSINVISITAS02,"
		 + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + ".OBSERVACIONES_02 OBSERVACIONES02";

	public static final String SQL_UPDATE = "UPDATE "
		+ DocumentosInfSocialDaoSql.TABLA
		+ " SET"
		+ " OIDDOKUSI_18 = ?,"
		+ " NOMBRE_DOC_18 = ?,"
		+ " F_INFORME_02 = ?,"
		+ " SOLA_02 = ?,"
		+ " ESTA_SOLA_MANANA_02 = ?,"
		+ " ESTA_SOLA_TARDE_02 = ?,"
		+ " ESTA_SOLA_NOCHE_02 = ?,"
		+ " RELACION_ENTORNO_02 = ?,"
		+ " FAMILIAR_FALLECIDO_02 = ?,"
		+ " VINCULO_FALLECIDO_02 = ?,"
		+ " VISITAS_FAMILIA_02 = ?,"
		+ " VISITAS_AMIGOS_02 = ?,"
		+ " FRECUENCIA_SALIDAS_02 = ?,"
		+ " PERIODO_SIN_VISITAS_02 = ?,"
		+ " TIEMPO_SIN_VISITAS_02 = ?,"
		+ " OBSERVACIONES_02 = ? "
		+ " WHERE ID_EXPEDIENTE_00 = ? ";

	public static final String SQL_INSERT="INSERT INTO "
		+ DocumentosInfSocialDaoSql.TABLA
		+ "(ID_EXPEDIENTE_00, OIDDOKUSI_18, NOMBRE_DOC_18, F_INFORME_02, SOLA_02, ESTA_SOLA_MANANA_02, ESTA_SOLA_TARDE_02, ESTA_SOLA_NOCHE_02, RELACION_ENTORNO_02, FAMILIAR_FALLECIDO_02, VINCULO_FALLECIDO_02, VISITAS_FAMILIA_02, VISITAS_AMIGOS_02, FRECUENCIA_SALIDAS_02, PERIODO_SIN_VISITAS_02, TIEMPO_SIN_VISITAS_02, OBSERVACIONES_02) "
		+ " VALUES "
		+ " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
	
	public static final String SQL_FROM = " FROM "
		+ DocumentosInfSocialDaoSql.TABLA + DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL;		
		

	public static final String SQL_WHERE_ALL = " WHERE 1=1 ";

						
	public static final String SQL_WHERE = DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + "." + DocumentosInfSocialDaoSql.ID_TABLA + " = ? ";

	public static final String SQL_SELECT_COUNT = "SELECT COUNT(1)";

	public static final String SQL_FIND = SQL_SELECT + SQL_FROM + SQL_WHERE_ALL + " AND " + SQL_WHERE;

	public static final String SQL_FIND_ALL = SQL_SELECT + SQL_FROM;

	public static final String SQL_FIND_ALL_COUNT = SQL_SELECT_COUNT + SQL_FROM;


	public static final String SQL_DELETE = "DELETE FROM "
		+ TABLA + " "
		+ DocumentosInfSocialDaoSql.ALIAS_DOCUMENTOSINFSOCIAL + " "
		+ " WHERE "
		+ SQL_WHERE;
}

