protected Date getDbDate() { try { return jdbcTemplate.queryForRowSet(dbDateSql, new Object[0]).getDate(1); } catch (Exception e) { return new Date(); } }
@Override public List<TrackedEntityDataValue> getTrackedEntityDataValuesForSynchronization( ProgramStageInstance programStageInstance ) { List<TrackedEntityDataValue> dataValues = new ArrayList<>(); String sql = "SELECT tedv.* FROM trackedentitydatavalue tedv " + "LEFT JOIN programstageinstance psi on tedv.programstageinstanceid = psi.programstageinstanceid " + "LEFT JOIN programstagedataelement psde ON tedv.dataelementid = psde.dataelementid AND psi.programstageid = psde.programstageid " + "WHERE tedv.programstageinstanceid = " + programStageInstance.getId() + " AND psde.skipsynchronization = false"; SqlRowSet rowSet = jdbcTemplate.queryForRowSet( sql ); while ( rowSet.next() ) { TrackedEntityDataValue tedv = new TrackedEntityDataValue(); tedv.setCreated( rowSet.getDate( "created" ) ); tedv.setLastUpdated( rowSet.getDate( "lastupdated" ) ); tedv.setProgramStageInstance( programStageInstance ); tedv.setValue( rowSet.getString( "value" ) ); tedv.setStoredBy( rowSet.getString( "storedby" ) ); tedv.setProvidedElsewhere( rowSet.getBoolean( "providedelsewhere" ) ); tedv.setDataElement( dataElementStore.get( rowSet.getInt( "dataelementid" ) ) ); dataValues.add( tedv ); } return dataValues; }
eventRow.setDueDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_duedate" ) ) ); eventRow.setEventDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_executiondate" ) ) ); attribute.setCreated( DateUtils.getIso8601NoTz( rowSet.getDate( "pav_created" ) ) ); attribute.setLastUpdated( DateUtils.getIso8601NoTz( rowSet.getDate( "pav_lastupdated" ) ) ); attribute.setValue( rowSet.getString( "pav_value" ) ); attribute.setDisplayName( rowSet.getString( "ta_name" ) ); dataValue.setCreated( DateUtils.getIso8601NoTz( rowSet.getDate( "pdv_created" ) ) ); dataValue.setLastUpdated( DateUtils.getIso8601NoTz( rowSet.getDate( "pdv_lastupdated" ) ) ); dataValue.setValue( rowSet.getString( "pdv_value" ) ); dataValue.setProvidedElsewhere( rowSet.getBoolean( "pdv_providedelsewhere" ) ); note.setNote( rowSet.getString( "psinote_uid" ) ); note.setValue( rowSet.getString( "psinote_value" ) ); note.setStoredDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psinote_storeddate" ) ) ); note.setStoredBy( rowSet.getString( "psinote_storedby" ) );
event.setDueDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_duedate" ) ) ); event.setEventDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_executiondate" ) ) ); event.setCreated( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_created" ) ) ); event.setLastUpdated( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_lastupdated" ) ) ); event.setCompletedDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psi_completeddate" ) ) ); dataValue.setCreated( DateUtils.getIso8601NoTz( rowSet.getDate( "pdv_created" ) ) ); dataValue.setLastUpdated( DateUtils.getIso8601NoTz( rowSet.getDate( "pdv_lastupdated" ) ) ); dataValue.setValue( rowSet.getString( "pdv_value" ) ); dataValue.setProvidedElsewhere( rowSet.getBoolean( "pdv_providedelsewhere" ) ); note.setNote( rowSet.getString( "psinote_uid" ) ); note.setValue( rowSet.getString( "psinote_value" ) ); note.setStoredDate( DateUtils.getIso8601NoTz( rowSet.getDate( "psinote_storeddate" ) ) ); note.setStoredBy( rowSet.getString( "psinote_storedby" ) );