WooYun.org

<property name="jdbcUrl" value="jdbc:postgresql://db-1.wumii.net:5432/simnet?stringtype=unspecified"/>
<property name="jdbcUrl" value="jdbc:postgresql://db-pgxc.wumii.net:5432/wumii?stringtype=unspecified"/>
+      <bean id="clusterDataSourceBase" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
+        <property name="user" value="wumii***"/>
+        <property name="password" value="wumii***"/>
+        <property name="maxPoolSize" value="1"/>
+        <property name="maxIdleTime" value="7200"/>

mysql –u simnet –p –f simnet < alter-tables2.sql

http://10.0.0.53/phpmyadmin/
http://10.0.0.53/wordpress
admin
liuqian6000

mysqldump -h 10.0.0.2 -P 3307 -u simnetro -pwumiiro --opt --skip-lock-tables simnet | mysql -h localhost -P 3306 -u root -p**** -c simnet
mqttc.username_pw_set("nagios", "na9io$")
office-cluster-3.wumii.net [10.0.0.103]

虚拟机已经迁移到服务器上了。kvm和virtualbox都不太理想，所以我们还是用vmware server。地址是
https://dev.wumii.net:8333/
因为用户验证有一些问题，我们用一个公用账号，用户名 vmware，密码 wumiivm。

@Service
 public class AdCampaignService {
     private AdCampaignDao adCampaignDao;
     private AdStatisticsDao adStatisticsDao;
+    private AdvertisementDao advertisementDao;
+    private AdClickDao adClickDao;
+    private AdShowDao adShowDao;
     @Autowired
     public AdCampaignService(AdCampaignDao adCampaignDao,
-            AdStatisticsDao adStatisticsDao) {
+            AdStatisticsDao adStatisticsDao,
+            AdvertisementDao advertisementDao,
+            AdClickDao adClickDao,
+            AdShowDao adShowDao) {
+
         this.adCampaignDao = adCampaignDao;
         this.adStatisticsDao = adStatisticsDao;
+        this.advertisementDao = advertisementDao;
+        this.adClickDao = adClickDao;
+        this.adShowDao = adShowDao;
     }
     public AdCampaign getAdCampaign(long adCampaignId) {
@@ -50,9 +67,33 @@
     public List<AdCampaignReport> getSummaryReports(AdAccount account) {
         List<AdCampaignReport> reports = new ArrayList<>();
         for (AdCampaign adCampaign : adCampaignDao.getCampaigns(account)) {
-            reports.add(new AdCampaignReport(adCampaign,
-                    adStatisticsDao.getAdStatisticses(adCampaign)));
+            List<AdStatistics> adStats = adStatisticsDao.getAdStatisticses(adCampaign);
+            Date latest = DateUtils.truncate(Util.now(), Calendar.DATE);
+
+            if (!adStats.isEmpty()) {
+                latest = Collections.max(Util.transformList(adStats, new Util.Transformer<AdStatistics, Date>() {
+                    @Override
+                    public Date transform(AdStatistics object) {
+                        return object.getStatDate();
         }
+                }));
+                // since the latest is the begin time of the last statistic day,
+                // add 1 day to get the real latest time
+                latest = DateUtils.addDays(latest, 1);
+            }
+            AdCampaignReport report = new AdCampaignReport(adCampaign, adStats);
+            List<Long> adIds = advertisementDao.getAdIds(adCampaign.getId());
+            adClickDao.completeRecentClicks(report, adIds, latest);
+            adShowDao.completeRecentShows(report, adIds, latest);
+            reports.add(report);
+        }
+
+        Collections.sort(reports, new Comparator<AdCampaignReport>() {
+            @Override
+            public int compare(AdCampaignReport o1, AdCampaignReport o2) {
+                return Long.compare(o2.getAdCampaign().getId(), o1.getAdCampaign().getId());
+            }
+        });
         return reports;
     }
diff -r 341c01a45079 src/main/resources-prod/spring-stage-context.xml
--- a/src/main/resources-prod/spring-stage-context.xml  Tue Jun 25 20:32:09 2013 +0800
+++ b/src/main/resources-prod/spring-stage-context.xml  Wed Jun 26 18:41:55 2013 +0800
@@ -46,6 +46,11 @@
         <property name="jdbcUrl" value="jdbc:postgresql://db-1.wumii.net:5432/simnet?stringtype=unspecified"/>
     </bean>
+    <bean id="clusterDataSource" parent="clusterDataSourceBase">
+        <property name="driverClass" value="org.postgresql.Driver"/>
+        <property name="jdbcUrl" value="jdbc:postgresql://db-pgxc.wumii.net:5432/wumii?stringtype=unspecified"/>
+    </bean>
+
     <bean id="hibernateProperties" parent="hibernatePropertiesBase">
         <property name="properties">
             <props merge="true">
diff -r 341c01a45079 src/main/resources/spring-common.xml
--- a/src/main/resources/spring-common.xml      Tue Jun 25 20:32:09 2013 +0800
+++ b/src/main/resources/spring-common.xml      Wed Jun 26 18:41:55 2013 +0800
@@ -37,6 +37,13 @@
         <property name="preferredTestQuery" value="SELECT 1"/>
     </bean>
+      <bean id="clusterDataSourceBase" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
+        <property name="user" value="wumii***"/>
+        <property name="password" value="wumii***"/>
+        <property name="maxPoolSize" value="1"/>
+        <property name="maxIdleTime" value="7200"/>
+    </bean>
+
     <bean id="hibernatePropertiesBase" class="org.springframework.beans.factory.config.PropertiesFactoryBean">
         <property name="properties">
             <props>
@@ -53,6 +60,7 @@
     </bean>
     <bean class="com.wumii.model.DataAccessConfiguration"/>
+    <bean class="com.wumii.model.cluster.DataAccessConfiguration"/>
     <bean id="contextSource" class="org.springframework.ldap.core.support.LdapContextSource">
         <property name="url" value="ldaps://ldap.wumii.net"/>