|
0
|
1 package nabble.modules.ad;
|
|
|
2
|
|
|
3 import fschmidt.db.DbDatabase;
|
|
|
4 import fschmidt.db.DbExpression;
|
|
|
5 import fschmidt.db.DbNull;
|
|
|
6 import fschmidt.db.DbRecord;
|
|
|
7 import fschmidt.db.NoKey;
|
|
|
8 import nabble.model.Db;
|
|
|
9 import nabble.model.ExtensionFactory;
|
|
|
10 import nabble.model.ModelHome;
|
|
|
11 import nabble.model.Site;
|
|
|
12 import nabble.model.ViewCount;
|
|
|
13 import nabble.naml.compiler.Template;
|
|
|
14 import nabble.naml.compiler.TemplatePrintWriter;
|
|
|
15 import nabble.naml.namespaces.BasicNamespace;
|
|
|
16 import nabble.view.web.template.NabbleNamespace;
|
|
|
17 import org.slf4j.Logger;
|
|
|
18 import org.slf4j.LoggerFactory;
|
|
|
19
|
|
|
20 import java.io.Serializable;
|
|
|
21 import java.sql.Connection;
|
|
|
22 import java.sql.PreparedStatement;
|
|
|
23 import java.sql.ResultSet;
|
|
|
24 import java.sql.SQLException;
|
|
|
25 import java.util.Collections;
|
|
|
26 import java.util.Date;
|
|
|
27 import java.util.Set;
|
|
|
28 import java.util.concurrent.ConcurrentHashMap;
|
|
|
29
|
|
|
30
|
|
|
31 public final class Ad {
|
|
|
32 private static final Logger logger = LoggerFactory.getLogger(Ad.class);
|
|
|
33
|
|
|
34 private static final String AD_MODULE_TASK = "ad_free";
|
|
|
35
|
|
|
36 private static final ExtensionFactory<Site,Ad> FACTORY = new ExtensionFactory<Site,Ad>() {
|
|
|
37
|
|
|
38 private final Set<Long> adFreeSites = Collections.newSetFromMap(new ConcurrentHashMap<Long,Boolean>());
|
|
|
39
|
|
|
40 public String getName() {
|
|
|
41 return AdModule.INSTANCE.getName();
|
|
|
42 }
|
|
|
43
|
|
|
44 public Class<Ad> extensionClass() {
|
|
|
45 return Ad.class;
|
|
|
46 }
|
|
|
47
|
|
|
48 public Ad construct(Site site) {
|
|
|
49 return null;
|
|
|
50 }
|
|
|
51
|
|
|
52 public Ad construct(Site site,ResultSet rs)
|
|
|
53 throws SQLException
|
|
|
54 {
|
|
|
55 boolean isSafe = rs.getBoolean("is_safe");
|
|
|
56 int credits = rs.getInt("ad_free");
|
|
|
57 if( credits > 0 && adFreeSites.add(site.getId()) )
|
|
|
58 site.addTask(AD_MODULE_TASK);
|
|
|
59 boolean isCreditsForUsersOnly = rs.getBoolean("ad_credits_for_users");
|
|
|
60 return new Ad(site,isSafe,credits,isCreditsForUsersOnly);
|
|
|
61 }
|
|
|
62
|
|
|
63 public Serializable getExportData(Site site) {
|
|
|
64 throw new UnsupportedOperationException();
|
|
|
65 }
|
|
|
66
|
|
|
67 public void saveExportData(Site site,Serializable s) {
|
|
|
68 throw new UnsupportedOperationException();
|
|
|
69 }
|
|
|
70 };
|
|
|
71
|
|
|
72 static {
|
|
|
73 ModelHome.addSiteExtensionFactory(FACTORY);
|
|
|
74 ViewCount.addCalculateActivityListener(new Runnable(){public void run(){
|
|
|
75 try {
|
|
|
76 for( Site site : ModelHome.getSitesForTask(AD_MODULE_TASK) ) {
|
|
|
77 Ad ad = Ad.of(site);
|
|
|
78 int views;
|
|
|
79 {
|
|
|
80 Connection con = Db.dbGlobal().getConnection();
|
|
|
81 String field = ad.isCreditsForUsersOnly ? "user_views" : "views";
|
|
|
82 PreparedStatement stmt = con.prepareStatement(
|
|
|
83 "select " + field + " from site_global where site_id = ?"
|
|
|
84 );
|
|
|
85 stmt.setLong(1,site.getId());
|
|
|
86 ResultSet rs = stmt.executeQuery();
|
|
|
87 rs.next();
|
|
|
88 views = rs.getInt(field);
|
|
|
89 rs.close();
|
|
|
90 stmt.close();
|
|
|
91 con.close();
|
|
|
92 if( views > 0 && !ad.wasCreatedRecently() ) {
|
|
|
93 ad.decCredits(views);
|
|
|
94 } else {
|
|
|
95 site.addTask(AD_MODULE_TASK);
|
|
|
96 }
|
|
|
97 }
|
|
|
98 if( ad.getCredits() > 0 ) {
|
|
|
99 Connection con = site.getDb().getConnection();
|
|
|
100 PreparedStatement stmt = con.prepareStatement(
|
|
|
101 "update site set monthly_views = monthly_views*29/30 + ?"
|
|
|
102 );
|
|
|
103 stmt.setInt(1,views);
|
|
|
104 stmt.executeUpdate();
|
|
|
105 stmt.close();
|
|
|
106 con.close();
|
|
|
107 }
|
|
|
108 }
|
|
|
109 } catch(SQLException e) {
|
|
|
110 logger.error("",e);
|
|
|
111 throw new RuntimeException(e);
|
|
|
112 }
|
|
|
113 }});
|
|
|
114 }
|
|
|
115
|
|
|
116 static void init() {}
|
|
|
117
|
|
|
118 public static Ad of(Site site) {
|
|
|
119 return site.getExtension(FACTORY);
|
|
|
120 }
|
|
|
121
|
|
|
122
|
|
|
123 private final Site site;
|
|
|
124 private boolean isSafe;
|
|
|
125 private int credits = 0;
|
|
|
126 private boolean isCreditsForUsersOnly;
|
|
|
127
|
|
|
128 Ad(Site site,boolean isSafe,int credits,boolean isCreditsForUsersOnly) {
|
|
|
129 this.site = site;
|
|
|
130 this.isSafe = isSafe;
|
|
|
131 this.credits = credits;
|
|
|
132 this.isCreditsForUsersOnly = isCreditsForUsersOnly;
|
|
|
133 }
|
|
|
134
|
|
|
135 public boolean isSafe() {
|
|
|
136 return isSafe;
|
|
|
137 }
|
|
|
138
|
|
|
139 public void setSafe(boolean isSafe) {
|
|
|
140 DbRecord<NoKey,?> record = site.getDbRecord();
|
|
|
141 this.isSafe = isSafe;
|
|
|
142 record.fields().put( "is_safe", isSafe );
|
|
|
143 // if( !isSafe ) {
|
|
|
144 // record.fields().put( "when_created", DbExpression.NOW );
|
|
|
145 // record.fields().put( "ad_credits_for_users", false );
|
|
|
146 // }
|
|
|
147 if (!site.getDb().isInTransaction()) {
|
|
|
148 record.update();
|
|
|
149 }
|
|
|
150 }
|
|
|
151
|
|
|
152 public int getCredits() {
|
|
|
153 return credits;
|
|
|
154 }
|
|
|
155
|
|
|
156 public void setCredits(int credits) {
|
|
|
157 if( credits < 0 )
|
|
|
158 credits = 0;
|
|
|
159 DbRecord<NoKey,?> record = site.getDbRecord();
|
|
|
160 this.credits = credits;
|
|
|
161 record.fields().put( "ad_free", DbNull.fix(credits) );
|
|
|
162 DbDatabase db = site.getDb();
|
|
|
163 if( !db.isInTransaction() )
|
|
|
164 record.update();
|
|
|
165 if( credits > 0 )
|
|
|
166 site.addTask(AD_MODULE_TASK);
|
|
|
167 }
|
|
|
168
|
|
|
169 public void incCredits(int n) {
|
|
|
170 setCredits(this.credits + n);
|
|
|
171 }
|
|
|
172
|
|
|
173 private void decCredits(int n) {
|
|
|
174 setCredits(this.credits - n);
|
|
|
175
|
|
|
176 // notify user?
|
|
|
177 // I'm supposing that everyday we will deduct n credits, so he has one more day to buy new ones
|
|
|
178 // I test if he has more than 0 credits to avoid send emails to everyone that doesn't have or buy credits
|
|
|
179 if( this.credits < n && this.credits > 0) { // condition here
|
|
|
180 Template template = site.getTemplate( "ad_notice",
|
|
|
181 BasicNamespace.class, NabbleNamespace.class
|
|
|
182 );
|
|
|
183 template.run( TemplatePrintWriter.NULL, Collections.<String,Object>emptyMap(),
|
|
|
184 new BasicNamespace(template),
|
|
|
185 new NabbleNamespace(site)
|
|
|
186 );
|
|
|
187 }
|
|
|
188 }
|
|
|
189
|
|
|
190 public boolean isPaid() {
|
|
|
191 return false;
|
|
|
192 }
|
|
|
193
|
|
|
194 public boolean isCreditsForUsersOnly() {
|
|
|
195 return isCreditsForUsersOnly;
|
|
|
196 }
|
|
|
197
|
|
|
198 private static long ONE_DAY = 24 * 60 * 60 * 1000L; // 1 day
|
|
|
199 private static long LIMIT_DAYS = 6 * 30 * ONE_DAY; // 6 months
|
|
|
200
|
|
|
201 boolean wasCreatedRecently() {
|
|
|
202 long whenCreated = site.getWhenCreated().getTime();
|
|
|
203 long now = new Date().getTime();
|
|
|
204 return now < whenCreated + LIMIT_DAYS;
|
|
|
205 }
|
|
|
206
|
|
|
207 long lastDayWithoutAds() {
|
|
|
208 return site.getWhenCreated().getTime() + LIMIT_DAYS;
|
|
|
209 }
|
|
|
210
|
|
|
211 }
|
