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);
}