=== modified file 'local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/PartnerService.java' --- local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/PartnerService.java 2014-11-15 09:02:15 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/PartnerService.java 2014-11-15 11:24:03 +0000 @@ -27,7 +27,7 @@ Collection getPartner( OrganisationUnit organisationUnit, DataSet dataSet ); - Collection getPartner( OrganisationUnit organisationUnit, DataElement dataElement ); + Collection getStartAndEndDate( Integer dataSetId, Integer dataElementId, Integer optionId ); Map getOrgUnitCountFromPartner( Integer dataSetId, Integer dataElementId, Integer optionId, String startDate, String endDate ); === modified file 'local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/PartnerStore.java' --- local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/PartnerStore.java 2014-11-15 10:43:45 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/api/PartnerStore.java 2014-11-15 11:24:03 +0000 @@ -28,7 +28,7 @@ Collection getPartner( OrganisationUnit organisationUnit, DataSet dataSet ); - Collection getPartner( OrganisationUnit organisationUnit, DataElement dataElement ); + Collection getStartAndEndDate( Integer dataSetId, Integer dataElementId, Integer optionId ); Map getOrgUnitCountFromPartner( Integer dataSetId, Integer dataElementId, Integer optionId, String startDate, String endDate ); === modified file 'local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/HibernatePartnerStore.java' --- local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/HibernatePartnerStore.java 2014-11-15 10:43:45 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/java/org/hisp/dhis/rbf/impl/HibernatePartnerStore.java 2014-11-15 11:24:03 +0000 @@ -1,10 +1,7 @@ package org.hisp.dhis.rbf.impl; import java.text.SimpleDateFormat; -import java.util.Collection; -import java.util.Date; -import java.util.HashMap; -import java.util.Map; +import java.util.*; import org.hibernate.Criteria; import org.hibernate.Session; @@ -16,6 +13,7 @@ import org.hisp.dhis.organisationunit.OrganisationUnit; import org.hisp.dhis.rbf.api.Partner; import org.hisp.dhis.rbf.api.PartnerStore; +import org.jfree.data.general.Dataset; import org.springframework.jdbc.core.JdbcTemplate; import org.springframework.jdbc.support.rowset.SqlRowSet; import org.springframework.transaction.annotation.Transactional; @@ -114,16 +112,36 @@ @SuppressWarnings( "unchecked" ) @Override - public Collection getPartner( OrganisationUnit organisationUnit, DataElement dataElement ) + public Collection getStartAndEndDate( Integer dataSetId, Integer dataElementId, Integer optionId ) { - Session session = sessionFactory.getCurrentSession(); - - Criteria criteria = session.createCriteria( Partner.class ); - criteria.add( Restrictions.eq( "organisationUnit", organisationUnit ) ); - criteria.add( Restrictions.eq( "dataElement", dataElement ) ); - criteria.addOrder(Order.asc("dataSet")); - - return criteria.list(); + List dateList = new ArrayList(); + SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd"); + + try + { + String query = "SELECT startdate, enddate FROM (" + + " SELECT Distinct (startdate , enddate),startdate , enddate FROM partner WHERE" + + " datasetid = " + dataSetId + " AND " + + " dataelementid = " + dataElementId + " AND " + + " optionid = " + optionId +") asd" ; + + SqlRowSet rs = jdbcTemplate.queryForRowSet( query ); + while ( rs.next() ) + { + String startDate = simpleDateFormat.format( rs.getDate( 1 ) ); + String endDate = simpleDateFormat.format(rs.getDate(2)); + + String date = startDate+":"+endDate; + + dateList.add(date); + } + } + catch (Exception ex){ + System.out.println(" In Partner Data Exception :"+ ex.getMessage() ); + ex.printStackTrace(); + } + return dateList; + } @@ -166,6 +184,7 @@ catch( Exception e ) { System.out.println(" In Partner Data Exception :"+ e.getMessage() ); + e.printStackTrace(); } return partnerOrgUnitCountMap; === modified file 'local/in/dhis-web-maintenance-rbf/src/main/resources/META-INF/dhis/beans.xml' --- local/in/dhis-web-maintenance-rbf/src/main/resources/META-INF/dhis/beans.xml 2014-11-14 10:26:48 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/resources/META-INF/dhis/beans.xml 2014-11-15 11:24:03 +0000 @@ -807,6 +807,10 @@ scope="prototype"> + + /content.vm /dhis-web-maintenance-rbf/partnerForm.vm + + + /content.vm + /dhis-web-maintenance-rbf/partnerDataList.vm + /main.vm === modified file 'local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/loadTariffData.vm' --- local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/loadTariffData.vm 2014-10-24 11:05:35 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/loadTariffData.vm 2014-11-15 11:24:03 +0000 @@ -5,9 +5,6 @@ jQuery('#addTariff').dialog({autoOpen: false}); } - - - Ext.Loader.setConfig({ enabled: true }); @@ -273,9 +270,6 @@ $( "#addTariff" ).dialog( "close" ); } - - - function dialogWindowClose() { //$( "#addTariff" ).dialog( "close" ); === modified file 'local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/partnerForm.vm' --- local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/partnerForm.vm 2014-11-15 09:02:15 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/partnerForm.vm 2014-11-15 11:24:03 +0000 @@ -3,19 +3,7 @@ function formValidations() { - //alert("validation"); - /* - var startPeriodList = document.getElementById("dataSetId"); - var startPeriodIndex = startPeriodList.selectedIndex; - - if( startPeriodList.options[startPeriodIndex].value == null || startPeriodList.options[startPeriodIndex].value== "-1" ) - { - showWarningMessage( "Please Select Period" ); - //alert("Please Select Period"); - return false; - } - var dataSetId = $( '#dataSetId' ).val(); var optionSetId = $( '#optionSetId' ).val(); @@ -41,39 +29,32 @@ return false; } */ - - /* - else if( $("#startDate").val() == "" ) + if( $("#startDate").val() == null || $("#startDate").val().equals("") ) { showWarningMessage( "Please Select Start Date" ); return false; } - else if( $("#endDate").val() == "" ) + else if( $("#endDate").val() == null || $("#endDate").val().equals("") ) { showWarningMessage( "Please Select End Date" ); return false; } - */ - /* else if( periodId == "-1" ) - { - showWarningMessage( "Please Select Period" ); - return false; - } - */ return true; } + function dialogWindowClose() + { + jQuery('#addNewPeriod').dialog('destroy').remove(); + } -

$i18n.getString( "partner_management" )

- @@ -146,7 +127,8 @@
- + +
=== modified file 'local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/partnerFundManagement.vm' --- local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/partnerFundManagement.vm 2014-11-15 09:02:15 +0000 +++ local/in/dhis-web-maintenance-rbf/src/main/webapp/dhis-web-maintenance-rbf/partnerFundManagement.vm 2014-11-15 11:24:03 +0000 @@ -2,17 +2,17 @@ window.onload=function(){ - jQuery('#addPeriod').dialog({autoOpen: false}); + jQuery('#addNewPeriod').dialog({autoOpen: false}); } function showAddParentForm() { - jQuery('#addPeriod').dialog('destroy').remove(); + // jQuery('#addNewPeriod').dialog('destroy').remove(); var dataSetId = $( "#dataSetId" ).val(); var optionSetId = $( "#optionSetId" ).val(); var dataElementId = $( "#dataElementId" ).val(); - + if ( dataSetId == "-1" ) { showWarningMessage( "Please Select DataSet" ); @@ -46,11 +46,21 @@ } + function showParentList(){ + jQuery('#showList' ).load( 'partnerDataList.action?dataSetId='+ dataSetId + "&optionSetId=" + optionSetId + "&dataElementId=" + dataElementId).dialog({ + title: 'Add New Period', + maximize: true, + closable: true, + modal:true, + overlay:{background:'#000000', opacity:0.1}, + width: 600, + height: 500 + }); + } + - -

$i18n.getString( "partner_management" )

@@ -93,7 +103,11 @@

-
+ + +
+ + + \ No newline at end of file