Summary Table

Categories Total Count
PII 0
URL 0
DNS 0
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

package gov.va.med.ars.dao.ars;

import java.math.BigInteger;
import java.util.Date;
import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.transaction.annotation.Transactional;

import gov.va.med.domain.ars.ClaimSubmission;

public interface IClaimSubmissionRepository extends JpaRepository<ClaimSubmission, BigInteger> {

ClaimSubmission findClaimSubmissionBysubmissionid(BigInteger submissionid);

ClaimSubmission findOne(BigInteger claimSubmissionId);

@Query("select p from aclaimSubmission p JOIN FETCH p.claimSvcLineses e where p.submissionid = :submissionId")
ClaimSubmission getClaimSubInfo(@Param("submissionId") BigInteger submissionId);

@Transactional
@Modifying
@Query("update aclaimSubmission c set c.submissionStatus = :submissionStatus, "
+ "c.dtp203responseduedate = :responseDueDate, " + "c.datemodified = :datemodified "
+ "where c.submissionid = :submissionId")
void updateSubmissionStatus(@Param("submissionId") BigInteger submissionId,
@Param("submissionStatus") String submissionStatus, @Param("responseDueDate") Date dtp209responseduedate,
@Param("datemodified") Date datemodified);

@Transactional
@Modifying
@Query("update aclaimSubmission c set c.submissionStatus = :submissionStatus, " + "c.datemodified = :datemodified "
+ "where c.submissionid = :submissionId")
void updateSubmissionStatusAndSetModifiedDate(@Param("submissionStatus") String submissionStatus,
@Param("submissionId") BigInteger submissionId, @Param("datemodified") Date datemodified);

@Query("select p.submissionStatus from aclaimSubmission p where p.trn02claimIndex = :claimId")
List<String> getClaimSubmissions(@Param("claimId") BigInteger submissionId);

}