e.java 源代码
package com.mbridge.msdk.foundation.db;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.text.TextUtils;
import com.anythink.expressad.foundation.c.d;
import com.mbridge.msdk.foundation.entity.CampaignEx;
import com.mbridge.msdk.foundation.tools.q;
import com.mbridge.msdk.out.Campaign;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;
import java.util.concurrent.ConcurrentHashMap;
import org.json.JSONArray;
import org.json.JSONException;
public class e extends a<Campaign> {
private static final String f16647a = "com.mbridge.msdk.foundation.db.e";
private static e f16648b;
private final String f16649c;
private final String f16650d;
private final String f16651e;
private final String f16652f;
private final String f16653g;
private final String f16654h;
private final String f16655i;
private final String f16656j;
private final String f16657k;
private final String f16658l;
private final String f16659m;
private final String f16660n;
private final String f16661o;
private final String f16662p;
private final String f16663q;
private final String f16664r;
private e(f fVar) {
super(fVar);
this.f16649c = "rid";
this.f16650d = "cid";
this.f16651e = "plct";
this.f16652f = "plctb";
this.f16653g = "timestamp";
this.f16654h = "ridCount";
this.f16655i = " WHERE ";
this.f16656j = " AND ";
this.f16657k = "SELECT ";
this.f16658l = "*";
this.f16659m = " FROM ";
this.f16660n = " AND readyState = '0'";
this.f16661o = " AND is_bid_campaign = 1";
this.f16662p = " order by ts ASC";
this.f16663q = " group by request_id";
this.f16664r = " group by bid_token";
}
public static synchronized e a(f fVar) {
e eVar;
synchronized (e.class) {
if (f16648b == null) {
f16648b = new e(fVar);
}
eVar = f16648b;
}
return eVar;
}
private synchronized List<CampaignEx> f(String str) {
Throwable th;
boolean z6;
try {
try {
try {
try {
synchronized (new Object()) {
try {
str = getReadableDatabase().rawQuery(str, null);
if (str != 0 && str.getCount() > 0) {
ArrayList arrayList = new ArrayList();
while (str.moveToNext()) {
CampaignEx campaignEx = new CampaignEx();
String string = str.getString(str.getColumnIndex("pv_urls"));
boolean z7 = false;
if (!TextUtils.isEmpty(string)) {
JSONArray jSONArray = new JSONArray(string);
ArrayList arrayList2 = new ArrayList();
for (int i6 = 0; i6 < jSONArray.length(); i6++) {
arrayList2.add(jSONArray.getString(i6));
}
campaignEx.setPv_urls(arrayList2);
}
campaignEx.setId(str.getString(str.getColumnIndex("id")));
campaignEx.setTab(str.getInt(str.getColumnIndex("tab")));
campaignEx.setPackageName(str.getString(str.getColumnIndex("package_name")));
campaignEx.setAppName(str.getString(str.getColumnIndex("app_name")));
campaignEx.setAppDesc(str.getString(str.getColumnIndex("app_desc")));
campaignEx.setSize(str.getString(str.getColumnIndex("app_size")));
campaignEx.setImageSize(str.getString(str.getColumnIndex("image_size")));
campaignEx.setIconUrl(str.getString(str.getColumnIndex("icon_url")));
campaignEx.setImageUrl(str.getString(str.getColumnIndex("image_url")));
campaignEx.setImpressionURL(str.getString(str.getColumnIndex("impression_url")));
campaignEx.setNoticeUrl(str.getString(str.getColumnIndex("notice_url")));
campaignEx.setClickURL(str.getString(str.getColumnIndex("download_url")));
campaignEx.setWtick(str.getInt(str.getColumnIndex("wtick")));
campaignEx.setDeepLinkUrl(str.getString(str.getColumnIndex("deeplink_url")));
campaignEx.setUserActivation(Boolean.parseBoolean(str.getString(str.getColumnIndex("user_activation"))));
campaignEx.setOnlyImpressionURL(str.getString(str.getColumnIndex("only_impression")));
campaignEx.setTemplate(str.getInt(str.getColumnIndex("template")));
campaignEx.setLandingType(str.getString(str.getColumnIndex("landing_type")));
campaignEx.setLinkType(str.getInt(str.getColumnIndex("link_type")));
campaignEx.setClick_mode(str.getString(str.getColumnIndex("click_mode")));
campaignEx.setRating(Double.parseDouble(str.getString(str.getColumnIndex("star"))));
campaignEx.setNumberRating(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_NUMBER_RATING)));
campaignEx.setClickInterval(str.getInt(str.getColumnIndex("cti")));
campaignEx.setTimestamp(str.getLong(str.getColumnIndex("ts")));
campaignEx.setCacheLevel(str.getInt(str.getColumnIndex("level")));
campaignEx.setType(str.getInt(str.getColumnIndex("adSource")));
campaignEx.setAdCall(str.getString(str.getColumnIndex("ad_call")));
campaignEx.setFca(str.getInt(str.getColumnIndex("fc_a")));
campaignEx.setFcb(str.getInt(str.getColumnIndex("fc_b")));
campaignEx.setAd_url_list(str.getString(str.getColumnIndex("ad_url_list")));
campaignEx.setVideoLength(str.getInt(str.getColumnIndex("video_length")));
campaignEx.setVideoSize(str.getInt(str.getColumnIndex("video_size")));
campaignEx.setVideoResolution(str.getString(str.getColumnIndex("video_resolution")));
campaignEx.setEndcard_click_result(str.getInt(str.getColumnIndex("endcard_click_result")));
campaignEx.setVideoUrlEncode(str.getString(str.getColumnIndex("video_url")));
campaignEx.setWatchMile(str.getInt(str.getColumnIndex("watch_mile")));
campaignEx.setTImp(str.getInt(str.getColumnIndex("t_imp")));
campaignEx.setBty(str.getInt(str.getColumnIndex(d.a.M)));
campaignEx.setAdvImp(str.getString(str.getColumnIndex(d.a.N)));
campaignEx.setOfferType(str.getInt(str.getColumnIndex("offer_type")));
campaignEx.setGuidelines(str.getString(str.getColumnIndex("guidelines")));
campaignEx.setHtmlUrl(str.getString(str.getColumnIndex("html_url")));
campaignEx.setEndScreenUrl(str.getString(str.getColumnIndex("end_screen_url")));
campaignEx.setRewardName(str.getString(str.getColumnIndex("reward_name")));
campaignEx.setRewardAmount(str.getInt(str.getColumnIndex("reward_amount")));
campaignEx.setRewardPlayStatus(str.getInt(str.getColumnIndex(d.a.V)));
campaignEx.setRetarget_offer(str.getInt(str.getColumnIndex(d.a.W)));
campaignEx.setCampaignUnitId(str.getString(str.getColumnIndex("unitid")));
campaignEx.setNativeVideoTracking(CampaignEx.TrackingStr2Object(str.getString(str.getColumnIndex(d.a.X))));
campaignEx.setNativeVideoTrackingString(str.getString(str.getColumnIndex(d.a.X)));
campaignEx.setVideo_end_type(str.getInt(str.getColumnIndex("video_end_type")));
campaignEx.setendcard_url(str.getString(str.getColumnIndex("endcard_url")));
campaignEx.setPlayable_ads_without_video(str.getInt(str.getColumnIndex("playable_ads_without_video")));
campaignEx.setRewardTemplateMode(CampaignEx.c.a(str.getString(str.getColumnIndex(d.a.ab))));
campaignEx.setVideoMD5Value(str.getString(str.getColumnIndex("md5_file")));
campaignEx.setGifUrl(str.getString(str.getColumnIndex("gif_url")));
campaignEx.setNvT2(str.getInt(str.getColumnIndex("nv_t2")));
campaignEx.setClickTimeOutInterval(str.getInt(str.getColumnIndex(d.a.ad)));
campaignEx.setcUA(str.getInt(str.getColumnIndex("c_ua")));
campaignEx.setImpUA(str.getInt(str.getColumnIndex("imp_ua")));
campaignEx.setOc_time(str.getInt(str.getColumnIndex("oc_time")));
campaignEx.setOc_type(str.getInt(str.getColumnIndex("oc_type")));
campaignEx.setT_list(str.getString(str.getColumnIndex("t_list")));
String string2 = str.getString(str.getColumnIndex("adchoice"));
if (!TextUtils.isEmpty(string2)) {
campaignEx.setAdchoice(CampaignEx.a.a(string2));
}
campaignEx.setAdchoiceSizeHeight(str.getInt(str.getColumnIndex(d.a.aC)));
campaignEx.setAdchoiceSizeWidth(str.getInt(str.getColumnIndex(d.a.aB)));
campaignEx.setPlct(str.getLong(str.getColumnIndex("plct")));
campaignEx.setPlctb(str.getLong(str.getColumnIndex("plctb")));
campaignEx.setAdZip(str.getString(str.getColumnIndex(d.a.aF)));
campaignEx.setAdHtml(str.getString(str.getColumnIndex("ad_html")));
campaignEx.setBannerUrl(str.getString(str.getColumnIndex("banner_url")));
campaignEx.setBannerHtml(str.getString(str.getColumnIndex("banner_html")));
campaignEx.setCreativeId(str.getLong(str.getColumnIndex("creative_id")));
if (str.getInt(str.getColumnIndex(d.a.am)) == 1) {
z6 = true;
} else {
z6 = false;
}
campaignEx.setIsBidCampaign(z6);
campaignEx.setBidToken(str.getString(str.getColumnIndex("bid_token")));
campaignEx.setAdType(str.getInt(str.getColumnIndex("ad_type")));
campaignEx.setMraid(str.getString(str.getColumnIndex("mraid")));
if (str.getInt(str.getColumnIndex(d.a.aL)) == 1) {
z7 = true;
}
campaignEx.setIsMraid(z7);
campaignEx.setOmid(str.getString(str.getColumnIndex("omid")));
campaignEx.setReady_rate(str.getInt(str.getColumnIndex("ready_rate")));
campaignEx.setExt_data(str.getString(str.getColumnIndex("ext_data")));
campaignEx.setNscpt(str.getInt(str.getColumnIndex("nscpt")));
campaignEx.setMof_template_url(str.getString(str.getColumnIndex("mof_template_url")));
campaignEx.setMof_tplid(str.getInt(str.getColumnIndex("mof_tplid")));
campaignEx.setReq_ext_data(str.getString(str.getColumnIndex("req_ext_data")));
campaignEx.setReadyState(str.getInt(str.getColumnIndex(d.a.aT)));
campaignEx.setLoadTimeoutState(str.getInt(str.getColumnIndex(d.a.aW)));
campaignEx.setPlacementId(str.getString(str.getColumnIndex("placement_id")));
campaignEx.setMaitve(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_MAITVE)));
campaignEx.setMaitve_src(str.getString(str.getColumnIndex(CampaignEx.JSON_KEY_MAITVESRC)));
campaignEx.setFlb(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_FLB)));
campaignEx.setFlbSkipTime(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_FLB_SKIP_TIME)));
campaignEx.setCbd(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_CBD)));
campaignEx.setVst(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_VST)));
campaignEx.setAdSpaceT(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_AD_SPACE_T)));
campaignEx.setVcn(str.getInt(str.getColumnIndex("vcn")));
campaignEx.setTokenRule(str.getInt(str.getColumnIndex("token_r")));
campaignEx.setEncryptPrice(str.getString(str.getColumnIndex("encrypt_p")));
campaignEx.setVideoCheckType(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_VIDEO_CHECK_TYPE)));
campaignEx.setVideoCtnType(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_VIDEO_CTN_TYPE)));
campaignEx.setRsIgnoreCheckRuleByString(str.getString(str.getColumnIndex(CampaignEx.JSON_KEY_RS_IGNORE_CHECK_RULE)));
campaignEx.setVideoCompleteTime(str.getInt(str.getColumnIndex(CampaignEx.JSON_KEY_VIDEO_COMPLETE_TIME)));
arrayList.add(campaignEx);
}
str.close();
return arrayList;
}
} catch (Throwable th2) {
th = th2;
throw th;
}
}
} catch (Exception e6) {
e = e6;
q.d("CampaignDao", e.getLocalizedMessage());
}
} catch (Throwable th3) {
th = th3;
}
} catch (Throwable th4) {
th = th4;
if (str != 0) {
str.close();
}
throw th;
}
} catch (Exception e7) {
e = e7;
str = 0;
} catch (Throwable th5) {
th = th5;
str = 0;
if (str != 0) {
}
throw th;
}
}
public final synchronized void b(String str, List<CampaignEx> list) {
if (list != null) {
if (list.size() > 0) {
for (CampaignEx campaignEx : list) {
try {
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 0);
SQLiteDatabase writableDatabase = getWritableDatabase();
if (writableDatabase != null) {
writableDatabase.update("campaign", contentValues, "unitid = '" + str + "' AND id = '" + campaignEx.getId() + "' AND request_id = '" + campaignEx.getRequestId() + "'", null);
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
}
}
}
public final synchronized void c(String str) {
String str2;
try {
str2 = "unitid = " + str;
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
getWritableDatabase().delete("campaign", str2, null);
}
public final List<com.mbridge.msdk.foundation.entity.b> d(String str) {
ArrayList arrayList = new ArrayList();
if (TextUtils.isEmpty(str)) {
return arrayList;
}
String str2 = "SELECT request_id as rid ,count(*) as ridCount ,vcn,token_r,bid_token,ts as timestamp FROM campaign" + (((((" WHERE unitid = '" + str + "' AND level = 0 AND adSource = 1") + " AND is_bid_campaign = 1") + " AND readyState = '0'") + " group by request_id") + " order by ts ASC");
Cursor cursor = null;
try {
try {
synchronized (new Object()) {
cursor = getReadableDatabase().rawQuery(str2, null);
}
if (cursor != null && cursor.getCount() > 0) {
while (cursor.moveToNext()) {
com.mbridge.msdk.foundation.entity.b bVar = new com.mbridge.msdk.foundation.entity.b();
String string = cursor.getString(cursor.getColumnIndex("rid"));
if (!TextUtils.isEmpty(string)) {
String string2 = cursor.getString(cursor.getColumnIndex("bid_token"));
int i6 = cursor.getInt(cursor.getColumnIndex("ridCount"));
int i7 = cursor.getInt(cursor.getColumnIndex("token_r"));
long j6 = cursor.getLong(cursor.getColumnIndex("timestamp"));
int i8 = cursor.getInt(cursor.getColumnIndex("vcn"));
bVar.b(string);
bVar.c(i6);
bVar.c(j6);
bVar.a(i7);
bVar.b(i8);
if (!TextUtils.isEmpty(string2)) {
bVar.a(string2);
}
arrayList.add(bVar);
}
}
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
} catch (Throwable th) {
if (0 != 0) {
cursor.close();
}
throw th;
}
}
public final ConcurrentHashMap<String, com.mbridge.msdk.foundation.entity.b> e(String str) {
String str2 = "SELECT request_id as rid, id as cid, plct as plct, plctb as plctb, ts as timestamp FROM campaign" + (((" WHERE unitid = '" + str + "' AND level = 0 AND adSource = 1") + " AND is_bid_campaign = 1") + " AND readyState = '0'");
ConcurrentHashMap<String, com.mbridge.msdk.foundation.entity.b> concurrentHashMap = new ConcurrentHashMap<>();
Cursor cursor = null;
try {
try {
synchronized (new Object()) {
cursor = getReadableDatabase().rawQuery(str2, null);
}
if (cursor != null && cursor.getCount() > 0) {
while (cursor.moveToNext()) {
String string = cursor.getString(cursor.getColumnIndex("rid"));
String string2 = cursor.getString(cursor.getColumnIndex("cid"));
long j6 = cursor.getLong(cursor.getColumnIndex("plct"));
long j7 = cursor.getLong(cursor.getColumnIndex("plctb"));
long j8 = cursor.getLong(cursor.getColumnIndex("timestamp"));
if (concurrentHashMap.containsKey(string)) {
com.mbridge.msdk.foundation.entity.b bVar = concurrentHashMap.get(string);
if (bVar != null) {
bVar.b(string);
bVar.a(j6);
bVar.b(j7);
bVar.c(j8);
if (bVar.c() != null) {
bVar.c().add(string2);
}
}
} else {
com.mbridge.msdk.foundation.entity.b bVar2 = new com.mbridge.msdk.foundation.entity.b();
bVar2.b(string);
bVar2.a(j6);
bVar2.b(j7);
bVar2.c(j8);
ArrayList arrayList = new ArrayList();
arrayList.add(string2);
bVar2.a(arrayList);
concurrentHashMap.put(string, bVar2);
}
}
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
} catch (Throwable th) {
if (0 != 0) {
cursor.close();
}
throw th;
}
}
public final synchronized void a(String str, int i6, int i7) {
String str2;
try {
str2 = "unitid = " + str + " AND level = " + i6 + " AND adSource = " + i7;
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
getWritableDatabase().delete("campaign", str2, null);
}
public final int c(String str, String str2) {
String str3;
if (!TextUtils.isEmpty(str)) {
str3 = "unitid = '" + str2 + "' AND request_id = '" + str + "' AND is_bid_campaign = 1";
} else {
str3 = "unitid = '" + str2 + "' AND is_bid_campaign = 1";
}
String str4 = str3 + " AND readyState = '0'";
try {
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
return getWritableDatabase().update("campaign", contentValues, str4, null);
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
return 0;
}
}
public final synchronized List<CampaignEx> b(String str) {
try {
Cursor rawQuery = getReadableDatabase().rawQuery("SELECT * FROM campaign WHERE unitid = '" + str + "' AND " + d.a.aT + " = 2", null);
if (rawQuery == null || rawQuery.getCount() <= 0) {
if (rawQuery != null) {
rawQuery.close();
}
return null;
}
ArrayList arrayList = new ArrayList();
while (rawQuery.moveToNext()) {
arrayList.add(a(rawQuery));
}
rawQuery.close();
return arrayList;
} catch (Exception unused) {
return null;
} catch (Throwable unused2) {
return null;
}
}
public final synchronized void a(String str, int i6, int i7, boolean z6) {
String sb;
try {
String str2 = "unitid = " + str + " AND level = " + i6 + " AND adSource = " + i7;
StringBuilder sb2 = new StringBuilder();
sb2.append(str2);
sb2.append(" AND is_bid_campaign = ");
sb2.append(z6 ? 1 : 0);
sb = sb2.toString();
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
getWritableDatabase().delete("campaign", sb, null);
}
public final synchronized void a(String str, List<CampaignEx> list) {
if (list != null) {
if (list.size() > 0) {
for (CampaignEx campaignEx : list) {
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
String str2 = "id = '" + campaignEx.getId() + "' AND unitid = " + str + " AND request_id = '" + campaignEx.getRequestId() + "'";
StringBuilder sb = new StringBuilder();
sb.append(str2);
sb.append(" AND is_bid_campaign = ");
sb.append(campaignEx.isBidCampaign() ? 1 : 0);
String sb2 = sb.toString();
try {
SQLiteDatabase writableDatabase = getWritableDatabase();
if (writableDatabase != null) {
writableDatabase.update("campaign", contentValues, sb2, null);
}
} catch (SQLException e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
}
}
}
public final synchronized void b(String str, String str2) {
try {
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
String str3 = "id = '" + str + "' AND request_id = '" + str2 + "'";
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
getWritableDatabase().update("campaign", contentValues, str3, null);
}
public final synchronized void a(String str, List<CampaignEx> list, boolean z6) {
if (list != null) {
if (list.size() > 0) {
for (CampaignEx campaignEx : list) {
try {
if (campaignEx.getLoadTimeoutState() == 0) {
StringBuilder sb = new StringBuilder();
sb.append("unitid");
sb.append(" = '");
sb.append(str);
sb.append("' AND ");
sb.append("id");
sb.append(" = '");
sb.append(campaignEx.getId());
sb.append("' AND ");
sb.append("request_id");
sb.append(" = '");
sb.append(campaignEx.getRequestId());
sb.append("'");
if (z6) {
sb.append(" AND is_bid_campaign = 1");
} else {
sb.append(" AND is_bid_campaign = 0");
}
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
SQLiteDatabase writableDatabase = getWritableDatabase();
if (writableDatabase != null) {
writableDatabase.update("campaign", contentValues, sb.toString(), null);
}
}
} catch (SQLException e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
}
}
}
public final synchronized void b(long j6, String str) {
try {
String str2 = "ts<" + (System.currentTimeMillis() - j6) + " and unitid=?";
String[] strArr = {str};
if (getWritableDatabase() != null) {
getWritableDatabase().delete("campaign", str2, strArr);
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
public final synchronized void d(String str, String str2) {
try {
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (TextUtils.isEmpty(str)) {
return;
}
String str3 = "unitid = '" + str + "'";
if (!TextUtils.isEmpty(str2)) {
str3 = str3 + " AND bid_token != '" + str2 + "'";
}
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
getWritableDatabase().update("campaign", contentValues, (str3 + " AND is_bid_campaign = 1") + " AND bid_token IS NOT NULL", null);
}
public final synchronized void b(final List<CampaignEx> list, final String str) {
if (list != null) {
if (list.size() != 0) {
new Thread(new Runnable() {
@Override
public final void run() {
Iterator it = list.iterator();
while (it.hasNext()) {
e.this.a((CampaignEx) it.next(), str, 0);
}
}
}).start();
}
}
}
public final synchronized void e(String str, String str2) {
try {
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (!TextUtils.isEmpty(str2) && !TextUtils.isEmpty(str)) {
String str3 = "unitid = '" + str + "' AND bid_token = '" + str2 + "' AND bid_token IS NOT NULL";
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
getWritableDatabase().update("campaign", contentValues, str3, null);
}
}
public final synchronized void a(String str, List<CampaignEx> list, String str2, int i6) {
if (!TextUtils.isEmpty(str) && list != null && list.size() > 0 && !TextUtils.isEmpty(str2)) {
SQLiteDatabase writableDatabase = getWritableDatabase();
if (writableDatabase == null) {
return;
}
try {
for (CampaignEx campaignEx : list) {
if (campaignEx != null) {
String str3 = "unitid = '" + str + "' AND id = '" + campaignEx.getId() + "' AND request_id = '" + campaignEx.getRequestId() + "'";
ContentValues contentValues = new ContentValues();
contentValues.put(str2, Integer.valueOf(i6));
writableDatabase.update("campaign", contentValues, str3, null);
}
}
} catch (Exception unused) {
}
}
}
public final synchronized List<CampaignEx> b(String str, int i6, int i7, int i8) {
String str2;
String str3;
str2 = " WHERE unitid = '" + str + "' AND level = " + i7 + " AND adSource = " + i8;
str3 = "";
if (i6 > 0) {
str3 = " LIMIT " + i6;
}
return f("SELECT * FROM campaign" + str2 + str3);
}
public final List<CampaignEx> b(String str, int i6, boolean z6) {
ArrayList arrayList;
String str2;
Cursor cursor = null;
r0 = null;
ArrayList arrayList2 = null;
cursor = null;
try {
try {
if (z6) {
str2 = "placement_id = " + str + " AND ad_type = " + i6;
} else {
str2 = "ad_type = " + i6;
}
Cursor rawQuery = getReadableDatabase().rawQuery("SELECT * FROM campaign WHERE " + str2, null);
if (rawQuery != null) {
try {
try {
if (rawQuery.getCount() > 0) {
arrayList = new ArrayList();
while (rawQuery.moveToNext()) {
try {
arrayList.add(a(rawQuery));
} catch (Exception e6) {
cursor = rawQuery;
e = e6;
q.d("CampaignDao", e.getLocalizedMessage());
if (cursor != null) {
cursor.close();
}
return arrayList;
}
}
arrayList2 = arrayList;
}
} catch (Throwable th) {
cursor = rawQuery;
th = th;
if (cursor != null) {
cursor.close();
}
throw th;
}
} catch (Exception e7) {
cursor = rawQuery;
e = e7;
arrayList = null;
}
}
if (rawQuery == null) {
return arrayList2;
}
rawQuery.close();
return arrayList2;
} catch (Throwable th2) {
th = th2;
}
} catch (Exception e8) {
e = e8;
arrayList = null;
}
}
public final synchronized void a(String str, List<CampaignEx> list, List<CampaignEx> list2, boolean z6) {
if (getWritableDatabase() == null) {
return;
}
try {
if (list != null) {
try {
if (list.size() > 0) {
for (CampaignEx campaignEx : list) {
try {
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 0);
String str2 = "unitid = '" + str + "' AND id = '" + campaignEx.getId() + "' AND request_id = '" + campaignEx.getRequestId() + "'";
getWritableDatabase().update("campaign", contentValues, z6 ? str2 + " AND " + d.a.am + " = 1" : str2 + " AND " + d.a.am + " = 0", null);
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
}
} catch (Exception e7) {
q.d("CampaignDao", e7.getLocalizedMessage());
}
}
if (list2 != null && list2.size() > 0) {
for (CampaignEx campaignEx2 : list2) {
try {
if (campaignEx2.getLoadTimeoutState() == 0) {
StringBuilder sb = new StringBuilder();
sb.append("unitid");
sb.append(" = '");
sb.append(str);
sb.append("' AND ");
sb.append("id");
sb.append(" = '");
sb.append(campaignEx2.getId());
sb.append("' AND ");
sb.append("request_id");
sb.append(" = '");
sb.append(campaignEx2.getRequestId());
sb.append("'");
if (z6) {
sb.append(" AND is_bid_campaign = 1");
} else {
sb.append(" AND is_bid_campaign = 0");
}
ContentValues contentValues2 = new ContentValues();
contentValues2.put(d.a.aT, (Integer) 2);
getWritableDatabase().update("campaign", contentValues2, sb.toString(), null);
}
} catch (SQLException e8) {
q.d("CampaignDao", e8.getLocalizedMessage());
}
}
}
} catch (Throwable th) {
throw th;
}
}
public final synchronized void a(String str, String str2) {
String str3;
try {
str3 = "id = '" + str + "' AND unitid = " + str2;
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
getWritableDatabase().delete("campaign", str3, null);
}
public final synchronized void a(String str) {
if (TextUtils.isEmpty(str)) {
return;
}
try {
SQLiteDatabase writableDatabase = getWritableDatabase();
if (writableDatabase != null) {
writableDatabase.delete("campaign", "unitid = '" + str + "' AND " + d.a.aT + " = 2", null);
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
public final synchronized void a(List<CampaignEx> list, String str) {
if (list != null) {
if (list.size() > 0) {
for (CampaignEx campaignEx : list) {
try {
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
SQLiteDatabase writableDatabase = getWritableDatabase();
if (writableDatabase != null) {
writableDatabase.update("campaign", contentValues, "unitid = '" + str + "' AND id = '" + campaignEx.getId() + "' AND request_id = '" + campaignEx.getRequestId() + "'", null);
}
} catch (SQLException e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
}
}
}
public final synchronized void a(String str, String str2, boolean z6, String str3) {
String sb;
try {
StringBuilder sb2 = new StringBuilder();
sb2.append("id = '");
sb2.append(str);
sb2.append("' AND ");
sb2.append("unitid");
sb2.append(" = ");
sb2.append(str2);
sb2.append(" AND ");
sb2.append(d.a.am);
sb2.append(" = ");
sb2.append(z6 ? "1" : "0");
sb2.append(" AND ");
sb2.append("request_id");
sb2.append(" = '");
sb2.append(str3);
sb2.append("'");
sb = sb2.toString();
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
ContentValues contentValues = new ContentValues();
contentValues.put(d.a.aT, (Integer) 2);
getWritableDatabase().update("campaign", contentValues, sb, null);
}
public final synchronized void a(String str, String str2, int i6, int i7, boolean z6) {
String str3;
try {
String str4 = "id = '" + str + "' AND unitid = " + str2 + " AND level = " + i6 + " AND adSource = " + i7;
if (z6) {
str3 = str4 + " AND is_bid_campaign = 1";
} else {
str3 = str4 + " AND is_bid_campaign = 0";
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
getWritableDatabase().delete("campaign", str3, null);
}
public final synchronized void a(String str, int i6, boolean z6) {
String str2;
try {
if (z6) {
str2 = "placement_id = " + str + " AND ad_type = " + i6;
} else {
str2 = "ad_type = " + i6;
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
if (getWritableDatabase() == null) {
return;
}
getWritableDatabase().delete("campaign", str2, null);
}
public final synchronized void a() {
try {
String str = "ts<" + (System.currentTimeMillis() - 3600000) + " AND ts>0";
if (getWritableDatabase() != null) {
getWritableDatabase().delete("campaign", str, null);
}
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
}
}
public final synchronized void a(long j6, String str) {
try {
long currentTimeMillis = System.currentTimeMillis();
String str2 = "(plctb>0 and (plctb* 1000+ts)<" + currentTimeMillis + ") or (plctb<=0 and ts<" + (currentTimeMillis - j6) + ") and unitid=?";
String[] strArr = {str};
if (getWritableDatabase() != null) {
getWritableDatabase().delete("campaign", str2, strArr);
}
} catch (Exception e6) {
q.d(f16647a, e6.getMessage());
}
}
public final synchronized void a(List<CampaignEx> list, String str, String str2, int i6) {
if (list != null) {
if (list.size() != 0) {
if (getWritableDatabase() == null) {
return;
}
Iterator<CampaignEx> it = list.iterator();
while (it.hasNext()) {
a(it.next(), str, str2, i6);
}
}
}
}
private synchronized long a(CampaignEx campaignEx, String str, String str2, int i6) {
if (campaignEx == null) {
return 0L;
}
try {
if (getWritableDatabase() == null) {
return -1L;
}
ContentValues contentValues = new ContentValues();
if (campaignEx.getPv_urls() != null && campaignEx.getPv_urls().size() > 0) {
JSONArray jSONArray = new JSONArray();
Iterator<String> it = campaignEx.getPv_urls().iterator();
while (it.hasNext()) {
jSONArray.put(it.next());
}
contentValues.put("pv_urls", jSONArray.toString());
}
contentValues.put("id", campaignEx.getId());
if (TextUtils.isEmpty(str)) {
str = "";
}
contentValues.put("placement_id", str);
contentValues.put("unitid", str2);
contentValues.put("tab", Integer.valueOf(campaignEx.getTab()));
contentValues.put("package_name", campaignEx.getPackageName());
contentValues.put("app_name", campaignEx.getAppName());
contentValues.put("app_desc", campaignEx.getAppDesc());
contentValues.put("app_size", campaignEx.getSize());
contentValues.put("image_size", campaignEx.getImageSize());
contentValues.put("icon_url", campaignEx.getIconUrl());
contentValues.put("image_url", campaignEx.getImageUrl());
contentValues.put("impression_url", campaignEx.getImpressionURL());
contentValues.put("notice_url", campaignEx.getNoticeUrl());
contentValues.put("download_url", campaignEx.getClickURL());
contentValues.put("wtick", Integer.valueOf(campaignEx.getWtick()));
contentValues.put("deeplink_url", campaignEx.getDeepLinkURL());
contentValues.put("user_activation", Boolean.toString(campaignEx.getUserActivation()));
contentValues.put("only_impression", campaignEx.getOnlyImpressionURL());
contentValues.put("ts", Long.valueOf(campaignEx.getTimestamp()));
contentValues.put("template", Integer.valueOf(campaignEx.getTemplate()));
contentValues.put("click_mode", campaignEx.getClick_mode());
contentValues.put("landing_type", campaignEx.getLandingType());
contentValues.put("link_type", Integer.valueOf(campaignEx.getLinkType()));
contentValues.put("star", Double.valueOf(campaignEx.getRating()));
contentValues.put("cti", Integer.valueOf(campaignEx.getClickInterval()));
contentValues.put("level", Integer.valueOf(campaignEx.getCacheLevel()));
contentValues.put("adSource", Integer.valueOf(campaignEx.getType()));
contentValues.put("ad_call", campaignEx.getAdCall());
contentValues.put("fc_a", Integer.valueOf(campaignEx.getFca()));
contentValues.put("fc_b", Integer.valueOf(campaignEx.getFcb()));
contentValues.put("ad_url_list", campaignEx.getAd_url_list());
contentValues.put("video_url", campaignEx.getVideoUrlEncode());
contentValues.put("video_size", Integer.valueOf(campaignEx.getVideoSize()));
contentValues.put("video_length", Integer.valueOf(campaignEx.getVideoLength()));
contentValues.put("video_resolution", campaignEx.getVideoResolution());
contentValues.put("endcard_click_result", Integer.valueOf(campaignEx.getEndcard_click_result()));
contentValues.put("watch_mile", Integer.valueOf(campaignEx.getWatchMile()));
contentValues.put(d.a.N, campaignEx.getAdvImp());
contentValues.put(d.a.M, Integer.valueOf(campaignEx.getBty()));
contentValues.put("t_imp", Integer.valueOf(campaignEx.getTImp()));
contentValues.put("guidelines", campaignEx.getGuidelines());
contentValues.put("offer_type", Integer.valueOf(campaignEx.getOfferType()));
contentValues.put("html_url", campaignEx.getHtmlUrl());
contentValues.put("end_screen_url", campaignEx.getEndScreenUrl());
contentValues.put("reward_amount", Integer.valueOf(campaignEx.getRewardAmount()));
contentValues.put("reward_name", campaignEx.getRewardName());
contentValues.put(d.a.V, Integer.valueOf(campaignEx.getRewardPlayStatus()));
contentValues.put(d.a.W, Integer.valueOf(campaignEx.getRetarget_offer()));
contentValues.put(d.a.X, campaignEx.getNativeVideoTrackingString());
contentValues.put("playable_ads_without_video", Integer.valueOf(campaignEx.getPlayable_ads_without_video()));
contentValues.put("endcard_url", campaignEx.getendcard_url());
contentValues.put("video_end_type", Integer.valueOf(campaignEx.getVideo_end_type()));
contentValues.put("md5_file", campaignEx.getVideoMD5Value());
contentValues.put("nv_t2", Integer.valueOf(campaignEx.getNvT2()));
contentValues.put("gif_url", campaignEx.getGifUrl());
if (campaignEx.getRewardTemplateMode() != null) {
contentValues.put(d.a.ab, campaignEx.getRewardTemplateMode().a());
}
contentValues.put(d.a.ad, Integer.valueOf(campaignEx.getClickTimeOutInterval()));
contentValues.put("c_ua", Integer.valueOf(campaignEx.getcUA()));
contentValues.put("imp_ua", Integer.valueOf(campaignEx.getImpUA()));
contentValues.put("jm_pd", Integer.valueOf(campaignEx.getJmPd()));
contentValues.put(d.a.aj, Integer.valueOf(campaignEx.getIsDeleted()));
contentValues.put("is_click", Integer.valueOf(campaignEx.getIsClick()));
contentValues.put(d.a.al, Integer.valueOf(campaignEx.getIsAddSuccesful()));
contentValues.put("short_ctime", String.valueOf(System.currentTimeMillis()));
contentValues.put("ia_icon", campaignEx.getKeyIaIcon());
contentValues.put("ia_url", campaignEx.getKeyIaUrl());
contentValues.put("ia_rst", Integer.valueOf(campaignEx.getKeyIaRst()));
contentValues.put("ia_ori", Integer.valueOf(campaignEx.getKeyIaOri()));
contentValues.put("ad_type", Integer.valueOf(campaignEx.getAdType()));
contentValues.put("ia_ext1", campaignEx.getIa_ext1());
contentValues.put("ia_ext2", campaignEx.getIa_ext2());
contentValues.put("is_download_zip", Integer.valueOf(campaignEx.getIsDownLoadZip()));
contentValues.put("ia_cache", campaignEx.getInteractiveCache());
contentValues.put("oc_time", Integer.valueOf(campaignEx.getOc_time()));
contentValues.put("oc_type", Integer.valueOf(campaignEx.getOc_type()));
contentValues.put("t_list", campaignEx.getT_list());
CampaignEx.a adchoice = campaignEx.getAdchoice();
if (adchoice != null) {
contentValues.put("adchoice", adchoice.c());
contentValues.put(d.a.aC, Integer.valueOf(adchoice.b()));
contentValues.put(d.a.aB, Integer.valueOf(adchoice.a()));
}
contentValues.put("plct", Long.valueOf(campaignEx.getPlct()));
contentValues.put("plctb", Long.valueOf(campaignEx.getPlctb()));
contentValues.put("ad_html", campaignEx.getAdHtml());
contentValues.put(d.a.aF, campaignEx.getAdZip());
contentValues.put("banner_url", campaignEx.getBannerUrl());
contentValues.put("banner_html", campaignEx.getBannerHtml());
contentValues.put("creative_id", Long.valueOf(campaignEx.getCreativeId()));
contentValues.put(d.a.am, Boolean.valueOf(campaignEx.isBidCampaign()));
contentValues.put("bid_token", campaignEx.getBidToken());
contentValues.put("mraid", campaignEx.getMraid());
contentValues.put(d.a.aL, Boolean.valueOf(campaignEx.isMraid()));
contentValues.put("omid", campaignEx.getOmid());
contentValues.put("mof_tplid", Integer.valueOf(campaignEx.getMof_tplid()));
contentValues.put("ready_rate", Integer.valueOf(campaignEx.getReady_rate()));
contentValues.put("ext_data", campaignEx.getExt_data());
contentValues.put("nscpt", Integer.valueOf(campaignEx.getNscpt()));
contentValues.put("mof_template_url", campaignEx.getMof_template_url());
contentValues.put("req_ext_data", campaignEx.getReq_ext_data());
contentValues.put(d.a.aT, Integer.valueOf(campaignEx.getReadyState()));
contentValues.put("request_id", campaignEx.getRequestId());
contentValues.put(d.a.aW, Integer.valueOf(campaignEx.getLoadTimeoutState()));
contentValues.put(CampaignEx.JSON_KEY_MAITVE, Integer.valueOf(campaignEx.getMaitve()));
contentValues.put(CampaignEx.JSON_KEY_MAITVESRC, campaignEx.getMaitve_src());
contentValues.put(CampaignEx.JSON_KEY_FLB, Integer.valueOf(campaignEx.getFlb()));
contentValues.put(CampaignEx.JSON_KEY_FLB_SKIP_TIME, Integer.valueOf(campaignEx.getFlbSkipTime()));
contentValues.put(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_AD_SPACE_T, Integer.valueOf(campaignEx.getAdSpaceT()));
contentValues.put(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_CBD, Integer.valueOf(campaignEx.getCbd()));
contentValues.put(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_VST, Integer.valueOf(campaignEx.getVst()));
contentValues.put("vcn", Integer.valueOf(campaignEx.getVcn()));
contentValues.put("token_r", Integer.valueOf(campaignEx.getTokenRule()));
contentValues.put("encrypt_p", campaignEx.getEncryptPrice());
contentValues.put(CampaignEx.JSON_KEY_VIDEO_CHECK_TYPE, Integer.valueOf(campaignEx.getVideoCheckType()));
contentValues.put(CampaignEx.JSON_KEY_VIDEO_CTN_TYPE, Integer.valueOf(campaignEx.getVideoCtnType()));
contentValues.put(CampaignEx.JSON_KEY_RS_IGNORE_CHECK_RULE, campaignEx.getRsIgnoreCheckRuleString());
contentValues.put(CampaignEx.JSON_KEY_VIDEO_COMPLETE_TIME, Integer.valueOf(campaignEx.getVideoCompleteTime()));
return getWritableDatabase().insert("campaign", null, contentValues);
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
return -1L;
}
}
public final synchronized long a(CampaignEx campaignEx, String str, int i6) {
String str2;
if (campaignEx == null) {
return 0L;
}
try {
if (getWritableDatabase() == null) {
return -1L;
}
ContentValues contentValues = new ContentValues();
contentValues.put("id", campaignEx.getId());
if (campaignEx.getPv_urls() != null && campaignEx.getPv_urls().size() > 0) {
JSONArray jSONArray = new JSONArray();
Iterator<String> it = campaignEx.getPv_urls().iterator();
while (it.hasNext()) {
jSONArray.put(it.next());
}
contentValues.put("pv_urls", jSONArray.toString());
}
contentValues.put("unitid", str);
contentValues.put("request_id", campaignEx.getRequestId());
contentValues.put("tab", Integer.valueOf(campaignEx.getTab()));
contentValues.put("package_name", campaignEx.getPackageName());
contentValues.put("app_name", campaignEx.getAppName());
contentValues.put("app_desc", campaignEx.getAppDesc());
contentValues.put("app_size", campaignEx.getSize());
contentValues.put("image_size", campaignEx.getImageSize());
contentValues.put("icon_url", campaignEx.getIconUrl());
contentValues.put("image_url", campaignEx.getImageUrl());
contentValues.put("impression_url", campaignEx.getImpressionURL());
contentValues.put("notice_url", campaignEx.getNoticeUrl());
contentValues.put("download_url", campaignEx.getClickURL());
contentValues.put("wtick", Integer.valueOf(campaignEx.getWtick()));
contentValues.put("deeplink_url", campaignEx.getDeepLinkURL());
contentValues.put("user_activation", Boolean.toString(campaignEx.getUserActivation()));
contentValues.put("only_impression", campaignEx.getOnlyImpressionURL());
contentValues.put("ts", Long.valueOf(campaignEx.getTimestamp()));
contentValues.put("template", Integer.valueOf(campaignEx.getTemplate()));
contentValues.put("click_mode", campaignEx.getClick_mode());
contentValues.put("landing_type", campaignEx.getLandingType());
contentValues.put("link_type", Integer.valueOf(campaignEx.getLinkType()));
contentValues.put("star", Double.valueOf(campaignEx.getRating()));
contentValues.put("cti", Integer.valueOf(campaignEx.getClickInterval()));
contentValues.put("level", Integer.valueOf(campaignEx.getCacheLevel()));
contentValues.put("adSource", Integer.valueOf(campaignEx.getType()));
contentValues.put("ad_call", campaignEx.getAdCall());
contentValues.put("fc_a", Integer.valueOf(campaignEx.getFca()));
contentValues.put("fc_b", Integer.valueOf(campaignEx.getFcb()));
contentValues.put("ad_url_list", campaignEx.getAd_url_list());
contentValues.put("video_url", campaignEx.getVideoUrlEncode());
contentValues.put("video_size", Integer.valueOf(campaignEx.getVideoSize()));
contentValues.put("video_length", Integer.valueOf(campaignEx.getVideoLength()));
contentValues.put("video_resolution", campaignEx.getVideoResolution());
contentValues.put("endcard_click_result", Integer.valueOf(campaignEx.getEndcard_click_result()));
contentValues.put("watch_mile", Integer.valueOf(campaignEx.getWatchMile()));
contentValues.put(d.a.N, campaignEx.getAdvImp());
contentValues.put(d.a.M, Integer.valueOf(campaignEx.getBty()));
contentValues.put("t_imp", Integer.valueOf(campaignEx.getTImp()));
contentValues.put("guidelines", campaignEx.getGuidelines());
contentValues.put("offer_type", Integer.valueOf(campaignEx.getOfferType()));
contentValues.put("html_url", campaignEx.getHtmlUrl());
contentValues.put("end_screen_url", campaignEx.getEndScreenUrl());
contentValues.put("reward_amount", Integer.valueOf(campaignEx.getRewardAmount()));
contentValues.put("reward_name", campaignEx.getRewardName());
contentValues.put(d.a.V, Integer.valueOf(campaignEx.getRewardPlayStatus()));
contentValues.put(d.a.W, Integer.valueOf(campaignEx.getRetarget_offer()));
contentValues.put(d.a.X, campaignEx.getNativeVideoTrackingString());
contentValues.put("playable_ads_without_video", Integer.valueOf(campaignEx.getPlayable_ads_without_video()));
contentValues.put("endcard_url", campaignEx.getendcard_url());
contentValues.put("video_end_type", Integer.valueOf(campaignEx.getVideo_end_type()));
contentValues.put("md5_file", campaignEx.getVideoMD5Value());
contentValues.put("nv_t2", Integer.valueOf(campaignEx.getNvT2()));
contentValues.put("gif_url", campaignEx.getGifUrl());
if (campaignEx.getRewardTemplateMode() != null) {
contentValues.put(d.a.ab, campaignEx.getRewardTemplateMode().a());
}
contentValues.put(d.a.ad, Integer.valueOf(campaignEx.getClickTimeOutInterval()));
contentValues.put("c_ua", Integer.valueOf(campaignEx.getcUA()));
contentValues.put("imp_ua", Integer.valueOf(campaignEx.getImpUA()));
contentValues.put("jm_pd", Integer.valueOf(campaignEx.getJmPd()));
contentValues.put(d.a.aj, Integer.valueOf(campaignEx.getIsDeleted()));
contentValues.put("is_click", Integer.valueOf(campaignEx.getIsClick()));
contentValues.put(d.a.al, Integer.valueOf(campaignEx.getIsAddSuccesful()));
contentValues.put("short_ctime", String.valueOf(System.currentTimeMillis()));
contentValues.put("ia_icon", campaignEx.getKeyIaIcon());
contentValues.put("ia_url", campaignEx.getKeyIaUrl());
contentValues.put("ia_rst", Integer.valueOf(campaignEx.getKeyIaRst()));
contentValues.put("ia_ori", Integer.valueOf(campaignEx.getKeyIaOri()));
contentValues.put("ad_type", Integer.valueOf(campaignEx.getAdType()));
contentValues.put("ia_ext1", campaignEx.getIa_ext1());
contentValues.put("ia_ext2", campaignEx.getIa_ext2());
contentValues.put("is_download_zip", Integer.valueOf(campaignEx.getIsDownLoadZip()));
contentValues.put("ia_cache", campaignEx.getInteractiveCache());
contentValues.put("oc_time", Integer.valueOf(campaignEx.getOc_time()));
contentValues.put("oc_type", Integer.valueOf(campaignEx.getOc_type()));
contentValues.put("t_list", campaignEx.getT_list());
CampaignEx.a adchoice = campaignEx.getAdchoice();
if (adchoice != null) {
contentValues.put("adchoice", adchoice.c());
contentValues.put(d.a.aC, Integer.valueOf(adchoice.b()));
contentValues.put(d.a.aB, Integer.valueOf(adchoice.a()));
}
contentValues.put("plct", Long.valueOf(campaignEx.getPlct()));
contentValues.put("plctb", Long.valueOf(campaignEx.getPlctb()));
contentValues.put("ad_html", campaignEx.getAdHtml());
contentValues.put(d.a.aF, campaignEx.getAdZip());
contentValues.put("banner_url", campaignEx.getBannerUrl());
contentValues.put("banner_html", campaignEx.getBannerHtml());
contentValues.put("creative_id", Long.valueOf(campaignEx.getCreativeId()));
contentValues.put(d.a.am, Boolean.valueOf(campaignEx.isBidCampaign()));
contentValues.put("bid_token", campaignEx.getBidToken());
contentValues.put("mraid", campaignEx.getMraid());
contentValues.put(d.a.aL, Boolean.valueOf(campaignEx.isMraid()));
contentValues.put("omid", campaignEx.getOmid());
contentValues.put("mof_tplid", Integer.valueOf(campaignEx.getMof_tplid()));
contentValues.put("ready_rate", Integer.valueOf(campaignEx.getReady_rate()));
contentValues.put("ext_data", campaignEx.getExt_data());
contentValues.put("nscpt", Integer.valueOf(campaignEx.getNscpt()));
contentValues.put("mof_template_url", campaignEx.getMof_template_url());
contentValues.put("req_ext_data", campaignEx.getReq_ext_data());
contentValues.put(d.a.aT, Integer.valueOf(campaignEx.getReadyState()));
contentValues.put(d.a.aW, Integer.valueOf(campaignEx.getLoadTimeoutState()));
contentValues.put("placement_id", campaignEx.getPlacementId());
contentValues.put(CampaignEx.JSON_KEY_MAITVE, Integer.valueOf(campaignEx.getMaitve()));
contentValues.put(CampaignEx.JSON_KEY_MAITVESRC, campaignEx.getMaitve_src());
contentValues.put(CampaignEx.JSON_KEY_FLB, Integer.valueOf(campaignEx.getFlb()));
contentValues.put(CampaignEx.JSON_KEY_FLB_SKIP_TIME, Integer.valueOf(campaignEx.getFlbSkipTime()));
contentValues.put(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_AD_SPACE_T, Integer.valueOf(campaignEx.getAdSpaceT()));
contentValues.put(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_CBD, Integer.valueOf(campaignEx.getCbd()));
contentValues.put(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_VST, Integer.valueOf(campaignEx.getVst()));
contentValues.put("vcn", Integer.valueOf(campaignEx.getVcn()));
contentValues.put("token_r", Integer.valueOf(campaignEx.getTokenRule()));
contentValues.put("encrypt_p", campaignEx.getEncryptPrice());
contentValues.put(CampaignEx.JSON_KEY_VIDEO_CHECK_TYPE, Integer.valueOf(campaignEx.getVideoCheckType()));
contentValues.put(CampaignEx.JSON_KEY_VIDEO_CTN_TYPE, Integer.valueOf(campaignEx.getVideoCtnType()));
contentValues.put(CampaignEx.JSON_KEY_RS_IGNORE_CHECK_RULE, campaignEx.getRsIgnoreCheckRuleString());
contentValues.put(CampaignEx.JSON_KEY_VIDEO_COMPLETE_TIME, Integer.valueOf(campaignEx.getVideoCompleteTime()));
if (a(campaignEx.getId(), campaignEx.getTab(), str, i6, campaignEx.getType(), campaignEx.isBidCampaign())) {
if (campaignEx.isBidCampaign()) {
str2 = "unitid = " + str + " AND " + d.a.am + " = 1";
} else {
str2 = "id = " + campaignEx.getId() + " AND unitid = " + str + " AND " + d.a.am + " = 0";
}
return getWritableDatabase().update("campaign", contentValues, str2, null);
}
return getWritableDatabase().insert("campaign", null, contentValues);
} catch (Exception e6) {
q.d("CampaignDao", e6.getLocalizedMessage());
return -1L;
}
}
public final synchronized int a(String str, long j6) {
try {
com.mbridge.msdk.b.a b6 = com.mbridge.msdk.b.b.a().b(com.mbridge.msdk.foundation.controller.a.e().h());
if (b6 == null) {
b6 = com.mbridge.msdk.b.b.a().b();
}
long v6 = b6.v() * 1000;
a(v6, str);
List<CampaignEx> a7 = a(str, 0, 0, 1, false);
if (a7 != null && !a7.isEmpty()) {
Iterator<CampaignEx> it = a7.iterator();
while (it.hasNext()) {
if (!it.next().isSpareOffer(j6, v6)) {
return 0;
}
}
return 1;
}
return -1;
} catch (Exception unused) {
return 0;
}
}
public final synchronized boolean a(String str, int i6, String str2, int i7, int i8, boolean z6) {
String str3;
if (z6) {
str3 = "SELECT id FROM campaign WHERE unitid = " + str2 + " AND " + d.a.am + " = 1";
} else {
str3 = "SELECT id FROM campaign WHERE id='" + str + "' AND tab=" + i6 + " AND unitid = '" + str2 + "' AND level = " + i7 + " AND adSource = " + i8 + " AND " + d.a.am + " = 0";
}
Cursor rawQuery = getReadableDatabase().rawQuery(str3, null);
if (rawQuery != null && rawQuery.getCount() > 0) {
rawQuery.close();
return true;
}
if (rawQuery != null) {
rawQuery.close();
}
return false;
}
public final List<CampaignEx> a(String str, int i6, int i7, int i8) {
String str2;
String str3 = " WHERE unitid = '" + str + "' AND level = " + i7 + " AND adSource = " + i8;
if (i6 > 0) {
str2 = " LIMIT " + i6;
} else {
str2 = "";
}
return f("SELECT * FROM campaign" + str3 + str2);
}
public final synchronized List<CampaignEx> a(String str, int i6, int i7, int i8, boolean z6) {
String str2;
String str3;
String str4 = " WHERE unitid = '" + str + "' AND level = " + i7 + " AND adSource = " + i8;
if (z6) {
str2 = str4 + " AND is_bid_campaign = 1";
} else {
str2 = str4 + " AND is_bid_campaign = 0";
}
str3 = "";
if (i6 > 0) {
str3 = " LIMIT " + i6;
}
return f("SELECT * FROM campaign" + str2 + str3);
}
public final synchronized List<CampaignEx> a(String str, int i6, int i7, int i8, String str2) {
String str3;
String str4;
str3 = ((" WHERE unitid = '" + str + "' AND level = " + i7 + " AND adSource = " + i8) + " AND is_bid_campaign = 1") + " AND readyState = '0'";
if (!TextUtils.isEmpty(str2)) {
str3 = str3 + " AND request_id = '" + str2 + "'";
}
str4 = "";
if (i6 > 0) {
str4 = " LIMIT " + i6;
}
return f("SELECT * FROM campaign" + (str3 + " order by ts ASC") + str4);
}
private CampaignEx a(Cursor cursor) {
if (cursor == null || cursor.getCount() <= 0) {
return null;
}
CampaignEx campaignEx = new CampaignEx();
try {
String string = cursor.getString(cursor.getColumnIndex("pv_urls"));
if (!TextUtils.isEmpty(string)) {
JSONArray jSONArray = new JSONArray(string);
ArrayList arrayList = new ArrayList();
for (int i6 = 0; i6 < jSONArray.length(); i6++) {
arrayList.add(jSONArray.getString(i6));
}
campaignEx.setPv_urls(arrayList);
}
} catch (JSONException unused) {
}
campaignEx.setId(cursor.getString(cursor.getColumnIndex("id")));
campaignEx.setTab(cursor.getInt(cursor.getColumnIndex("tab")));
campaignEx.setPackageName(cursor.getString(cursor.getColumnIndex("package_name")));
campaignEx.setAppName(cursor.getString(cursor.getColumnIndex("app_name")));
campaignEx.setAppDesc(cursor.getString(cursor.getColumnIndex("app_desc")));
campaignEx.setSize(cursor.getString(cursor.getColumnIndex("app_size")));
campaignEx.setImageSize(cursor.getString(cursor.getColumnIndex("image_size")));
campaignEx.setIconUrl(cursor.getString(cursor.getColumnIndex("icon_url")));
campaignEx.setImageUrl(cursor.getString(cursor.getColumnIndex("image_url")));
campaignEx.setImpressionURL(cursor.getString(cursor.getColumnIndex("impression_url")));
campaignEx.setNoticeUrl(cursor.getString(cursor.getColumnIndex("notice_url")));
campaignEx.setClickURL(cursor.getString(cursor.getColumnIndex("download_url")));
campaignEx.setWtick(cursor.getInt(cursor.getColumnIndex("wtick")));
campaignEx.setDeepLinkUrl(cursor.getString(cursor.getColumnIndex("deeplink_url")));
campaignEx.setUserActivation(Boolean.parseBoolean(cursor.getString(cursor.getColumnIndex("user_activation"))));
campaignEx.setOnlyImpressionURL(cursor.getString(cursor.getColumnIndex("only_impression")));
campaignEx.setTemplate(cursor.getInt(cursor.getColumnIndex("template")));
campaignEx.setLandingType(cursor.getString(cursor.getColumnIndex("landing_type")));
campaignEx.setLinkType(cursor.getInt(cursor.getColumnIndex("link_type")));
campaignEx.setClick_mode(cursor.getString(cursor.getColumnIndex("click_mode")));
campaignEx.setRating(Double.parseDouble(cursor.getString(cursor.getColumnIndex("star"))));
campaignEx.setNumberRating(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_NUMBER_RATING)));
campaignEx.setClickInterval(cursor.getInt(cursor.getColumnIndex("cti")));
campaignEx.setTimestamp(cursor.getLong(cursor.getColumnIndex("ts")));
campaignEx.setCacheLevel(cursor.getInt(cursor.getColumnIndex("level")));
campaignEx.setAdCall(cursor.getString(cursor.getColumnIndex("ad_call")));
campaignEx.setFcb(cursor.getInt(cursor.getColumnIndex("fc_b")));
campaignEx.setAd_url_list(cursor.getString(cursor.getColumnIndex("ad_url_list")));
campaignEx.setVideoLength(cursor.getInt(cursor.getColumnIndex("video_length")));
campaignEx.setVideoSize(cursor.getInt(cursor.getColumnIndex("video_size")));
campaignEx.setVideoResolution(cursor.getString(cursor.getColumnIndex("video_resolution")));
campaignEx.setEndcard_click_result(cursor.getInt(cursor.getColumnIndex("endcard_click_result")));
campaignEx.setVideoUrlEncode(cursor.getString(cursor.getColumnIndex("video_url")));
campaignEx.setWatchMile(cursor.getInt(cursor.getColumnIndex("watch_mile")));
campaignEx.setTImp(cursor.getInt(cursor.getColumnIndex("t_imp")));
campaignEx.setBty(cursor.getInt(cursor.getColumnIndex(d.a.M)));
campaignEx.setAdvImp(cursor.getString(cursor.getColumnIndex(d.a.N)));
campaignEx.setGuidelines(cursor.getString(cursor.getColumnIndex("guidelines")));
campaignEx.setOfferType(cursor.getInt(cursor.getColumnIndex("offer_type")));
campaignEx.setHtmlUrl(cursor.getString(cursor.getColumnIndex("html_url")));
campaignEx.setGuidelines(cursor.getString(cursor.getColumnIndex("guidelines")));
campaignEx.setHtmlUrl(cursor.getString(cursor.getColumnIndex("html_url")));
campaignEx.setEndScreenUrl(cursor.getString(cursor.getColumnIndex("end_screen_url")));
campaignEx.setRewardName(cursor.getString(cursor.getColumnIndex("reward_name")));
campaignEx.setRewardAmount(cursor.getInt(cursor.getColumnIndex("reward_amount")));
campaignEx.setRewardPlayStatus(cursor.getInt(cursor.getColumnIndex(d.a.V)));
campaignEx.setRetarget_offer(cursor.getInt(cursor.getColumnIndex(d.a.W)));
campaignEx.setCampaignUnitId(cursor.getString(cursor.getColumnIndex("unitid")));
campaignEx.setNativeVideoTracking(CampaignEx.TrackingStr2Object(cursor.getString(cursor.getColumnIndex(d.a.X))));
campaignEx.setNativeVideoTrackingString(cursor.getString(cursor.getColumnIndex(d.a.X)));
campaignEx.setVideo_end_type(cursor.getInt(cursor.getColumnIndex("video_end_type")));
campaignEx.setendcard_url(cursor.getString(cursor.getColumnIndex("endcard_url")));
campaignEx.setPlayable_ads_without_video(cursor.getInt(cursor.getColumnIndex("playable_ads_without_video")));
campaignEx.setRewardTemplateMode(CampaignEx.c.a(cursor.getString(cursor.getColumnIndex(d.a.ab))));
campaignEx.setVideoMD5Value(cursor.getString(cursor.getColumnIndex("md5_file")));
campaignEx.setGifUrl(cursor.getString(cursor.getColumnIndex("gif_url")));
campaignEx.setNvT2(cursor.getInt(cursor.getColumnIndex("nv_t2")));
campaignEx.setClickTimeOutInterval(cursor.getInt(cursor.getColumnIndex(d.a.ad)));
campaignEx.setcUA(cursor.getInt(cursor.getColumnIndex("c_ua")));
campaignEx.setImpUA(cursor.getInt(cursor.getColumnIndex("imp_ua")));
campaignEx.setJmPd(cursor.getInt(cursor.getColumnIndex("jm_pd")));
campaignEx.setIsDeleted(cursor.getInt(cursor.getColumnIndex(d.a.aj)));
campaignEx.setIsClick(cursor.getInt(cursor.getColumnIndex("is_click")));
campaignEx.setIsAddSuccesful(cursor.getInt(cursor.getColumnIndex(d.a.al)));
campaignEx.setIsDownLoadZip(cursor.getInt(cursor.getColumnIndex("is_download_zip")));
campaignEx.setInteractiveCache(cursor.getString(cursor.getColumnIndex("ia_cache")));
campaignEx.setKeyIaOri(cursor.getInt(cursor.getColumnIndex("ia_ori")));
campaignEx.setAdType(cursor.getInt(cursor.getColumnIndex("ad_type")));
campaignEx.setIa_ext1(cursor.getString(cursor.getColumnIndex("ia_ext1")));
campaignEx.setIa_ext2(cursor.getString(cursor.getColumnIndex("ia_ext2")));
campaignEx.setKeyIaRst(cursor.getInt(cursor.getColumnIndex("ia_rst")));
campaignEx.setKeyIaUrl(cursor.getString(cursor.getColumnIndex("ia_url")));
campaignEx.setKeyIaIcon(cursor.getString(cursor.getColumnIndex("ia_icon")));
campaignEx.setOc_time(cursor.getInt(cursor.getColumnIndex("oc_time")));
campaignEx.setOc_type(cursor.getInt(cursor.getColumnIndex("oc_type")));
campaignEx.setT_list(cursor.getString(cursor.getColumnIndex("t_list")));
String string2 = cursor.getString(cursor.getColumnIndex("adchoice"));
if (!TextUtils.isEmpty(string2)) {
campaignEx.setAdchoice(CampaignEx.a.a(string2));
}
campaignEx.setAdchoiceSizeHeight(cursor.getInt(cursor.getColumnIndex(d.a.aC)));
campaignEx.setAdchoiceSizeWidth(cursor.getInt(cursor.getColumnIndex(d.a.aB)));
campaignEx.setPlct(cursor.getLong(cursor.getColumnIndex("plct")));
campaignEx.setPlctb(cursor.getLong(cursor.getColumnIndex("plctb")));
campaignEx.setAdZip(cursor.getString(cursor.getColumnIndex(d.a.aF)));
campaignEx.setAdHtml(cursor.getString(cursor.getColumnIndex("ad_html")));
campaignEx.setBannerUrl(cursor.getString(cursor.getColumnIndex("banner_url")));
campaignEx.setBannerHtml(cursor.getString(cursor.getColumnIndex("banner_html")));
campaignEx.setCreativeId(cursor.getLong(cursor.getColumnIndex("creative_id")));
campaignEx.setIsBidCampaign(cursor.getInt(cursor.getColumnIndex(d.a.am)) == 1);
campaignEx.setBidToken(cursor.getString(cursor.getColumnIndex("bid_token")));
campaignEx.setMraid(cursor.getString(cursor.getColumnIndex("mraid")));
campaignEx.setIsMraid(cursor.getInt(cursor.getColumnIndex(d.a.aL)) == 1);
campaignEx.setOmid(cursor.getString(cursor.getColumnIndex("omid")));
campaignEx.setReady_rate(cursor.getInt(cursor.getColumnIndex("ready_rate")));
campaignEx.setExt_data(cursor.getString(cursor.getColumnIndex("ext_data")));
campaignEx.setNscpt(cursor.getInt(cursor.getColumnIndex("nscpt")));
campaignEx.setMof_template_url(cursor.getString(cursor.getColumnIndex("mof_template_url")));
campaignEx.setMof_tplid(cursor.getInt(cursor.getColumnIndex("mof_tplid")));
campaignEx.setReq_ext_data(cursor.getString(cursor.getColumnIndex("req_ext_data")));
campaignEx.setReadyState(cursor.getInt(cursor.getColumnIndex(d.a.aT)));
campaignEx.setLoadTimeoutState(cursor.getInt(cursor.getColumnIndex(d.a.aW)));
campaignEx.setPlacementId(cursor.getString(cursor.getColumnIndex("placement_id")));
campaignEx.setMaitve(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_MAITVE)));
campaignEx.setMaitve_src(cursor.getString(cursor.getColumnIndex(CampaignEx.JSON_KEY_MAITVESRC)));
campaignEx.setFlb(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_FLB)));
campaignEx.setFlbSkipTime(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_FLB_SKIP_TIME)));
campaignEx.setCbd(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_CBD)));
campaignEx.setVst(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_VST)));
campaignEx.setAdSpaceT(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_NEW_INTERSTITIAL_AD_SPACE_T)));
campaignEx.setVcn(cursor.getInt(cursor.getColumnIndex("vcn")));
campaignEx.setTokenRule(cursor.getInt(cursor.getColumnIndex("token_r")));
campaignEx.setEncryptPrice(cursor.getString(cursor.getColumnIndex("encrypt_p")));
campaignEx.setVideoCheckType(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_VIDEO_CHECK_TYPE)));
campaignEx.setVideoCtnType(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_VIDEO_CTN_TYPE)));
campaignEx.setRsIgnoreCheckRuleByString(cursor.getString(cursor.getColumnIndex(CampaignEx.JSON_KEY_RS_IGNORE_CHECK_RULE)));
campaignEx.setVideoCompleteTime(cursor.getInt(cursor.getColumnIndex(CampaignEx.JSON_KEY_VIDEO_COMPLETE_TIME)));
return campaignEx;
}
}