.class public Lcom/moji/mjad/splash/db/SplashCityDbHelper;
.super Ljava/lang/Object;
.source "SplashCityDbHelper.java"


# instance fields
.field private a:Landroid/database/sqlite/SQLiteDatabase;


# direct methods
.method public constructor <init>(Landroid/content/Context;)V
    .locals 5

    .line 24
    invoke-direct {p0}, Ljava/lang/Object;-><init>()V

    const/4 v0, 0x0

    .line 23
    iput-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz p1, :cond_3

    .line 27
    :try_start_0
    sget-object v1, Lcom/moji/dynamic/DynamicLoadType;->CITY_DB:Lcom/moji/dynamic/DynamicLoadType;

    invoke-static {p1, v1}, Lcom/moji/dynamic/DynamicLoadManager;->a(Landroid/content/Context;Lcom/moji/dynamic/DynamicLoadType;)Ljava/lang/String;

    move-result-object v1

    const-string v2, "SplashCityDbHelper"

    .line 28
    new-instance v3, Ljava/lang/StringBuilder;

    invoke-direct {v3}, Ljava/lang/StringBuilder;-><init>()V

    const-string v4, "SplashCityDbHelper localDBPath:"

    invoke-virtual {v3, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v3, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v3}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v3

    invoke-static {v2, v3}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V

    .line 29
    invoke-static {v1}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z

    move-result v2

    if-nez v2, :cond_0

    const-string v2, "UNKNOWN"

    invoke-virtual {v2, v1}, Ljava/lang/String;->equalsIgnoreCase(Ljava/lang/String;)Z

    move-result v2

    if-eqz v2, :cond_1

    :cond_0
    const-string v1, "mojicity11.db"

    .line 30
    invoke-virtual {p1, v1}, Landroid/content/Context;->getDatabasePath(Ljava/lang/String;)Ljava/io/File;

    move-result-object p1

    invoke-virtual {p1}, Ljava/io/File;->getAbsolutePath()Ljava/lang/String;

    move-result-object v1

    const-string p1, "SplashCityDbHelper"

    .line 31
    new-instance v2, Ljava/lang/StringBuilder;

    invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V

    const-string v3, "SplashCityDbHelper localDBPath2:"

    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v2, v1}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v2

    invoke-static {p1, v2}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V

    .line 33
    :cond_1
    invoke-static {v1}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z

    move-result p1

    if-nez p1, :cond_3

    .line 34
    new-instance p1, Ljava/io/File;

    invoke-direct {p1, v1}, Ljava/io/File;-><init>(Ljava/lang/String;)V

    .line 35
    invoke-virtual {p1}, Ljava/io/File;->exists()Z

    move-result p1

    if-eqz p1, :cond_2

    const/4 p1, 0x1

    .line 36
    invoke-static {v1, v0, p1}, Landroid/database/sqlite/SQLiteDatabase;->openDatabase(Ljava/lang/String;Landroid/database/sqlite/SQLiteDatabase$CursorFactory;I)Landroid/database/sqlite/SQLiteDatabase;

    move-result-object p1

    iput-object p1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    goto :goto_0

    :cond_2
    const-string p1, "SplashCityDbHelper"

    const-string v1, "SplashCityDbHelper !file.exists()"

    .line 38
    invoke-static {p1, v1}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V
    :try_end_0
    .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0

    goto :goto_0

    :catch_0
    move-exception p1

    .line 42
    iput-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    const-string v0, "SplashCityDbHelper"

    .line 43
    invoke-static {v0, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V

    :cond_3
    :goto_0
    return-void
.end method

.method private a(Lcom/moji/mjad/splash/data/CityInfo;IZ)V
    .locals 6

    .line 75
    iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v0, :cond_7

    const/4 v0, 0x0

    .line 78
    :try_start_0
    iget-object v1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    new-instance v2, Ljava/lang/StringBuilder;

    invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V

    const-string v3, "SELECT * FROM city WHERE "

    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    if-eqz p3, :cond_0

    const-string v3, "internal_id"

    goto :goto_0

    :cond_0
    const-string v3, "city_id"

    :goto_0
    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    const-string v3, " = "

    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v2, p2}, Ljava/lang/StringBuilder;->append(I)Ljava/lang/StringBuilder;

    const-string v3, ";"

    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v2

    invoke-virtual {v1, v2, v0}, Landroid/database/sqlite/SQLiteDatabase;->rawQuery(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v1
    :try_end_0
    .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_1
    .catchall {:try_start_0 .. :try_end_0} :catchall_1

    .line 79
    :cond_1
    :goto_1
    :try_start_1
    invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z

    move-result v0

    if-eqz v0, :cond_5

    .line 80
    invoke-interface {v1}, Landroid/database/Cursor;->isClosed()Z

    move-result v0

    if-nez v0, :cond_1

    const-string v0, "LocalCityDBHelper"

    .line 81
    new-instance v2, Ljava/lang/StringBuilder;

    invoke-direct {v2}, Ljava/lang/StringBuilder;-><init>()V

    const-string v3, "sea city names:"

    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-interface {v1}, Landroid/database/Cursor;->getColumnNames()[Ljava/lang/String;

    move-result-object v3

    const/4 v4, 0x0

    aget-object v3, v3, v4

    invoke-virtual {v2, v3}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    invoke-virtual {v2}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v2

    invoke-static {v0, v2}, Lcom/moji/tool/log/MJLogger;->b(Ljava/lang/String;Ljava/lang/String;)V

    const-string v0, "parent_id"

    .line 82
    invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v0

    invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I

    move-result v0

    if-lez v0, :cond_4

    if-eqz p3, :cond_2

    const-string v2, "city_id"

    .line 84
    invoke-interface {v1, v2}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v2

    invoke-interface {v1, v2}, Landroid/database/Cursor;->getInt(I)I

    move-result v2

    goto :goto_2

    :cond_2
    move v2, p2

    .line 85
    :goto_2
    iget-object v3, p1, Lcom/moji/mjad/splash/data/CityInfo;->a:Ljava/util/List;

    invoke-static {v2}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v5

    invoke-interface {v3, v5}, Ljava/util/List;->contains(Ljava/lang/Object;)Z

    move-result v3

    if-nez v3, :cond_3

    .line 86
    iget-object v3, p1, Lcom/moji/mjad/splash/data/CityInfo;->a:Ljava/util/List;

    invoke-static {v2}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v2

    invoke-interface {v3, v2}, Ljava/util/List;->add(Ljava/lang/Object;)Z

    .line 87
    invoke-direct {p0, p1, v0, v4}, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a(Lcom/moji/mjad/splash/data/CityInfo;IZ)V

    goto :goto_1

    .line 89
    :cond_3
    iput v0, p1, Lcom/moji/mjad/splash/data/CityInfo;->b:I

    const-string v0, "country"

    .line 90
    invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v0

    invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I

    move-result v0

    .line 91
    iput v0, p1, Lcom/moji/mjad/splash/data/CityInfo;->c:I

    goto :goto_1

    .line 94
    :cond_4
    iput p2, p1, Lcom/moji/mjad/splash/data/CityInfo;->b:I

    const-string v0, "country"

    .line 95
    invoke-interface {v1, v0}, Landroid/database/Cursor;->getColumnIndex(Ljava/lang/String;)I

    move-result v0

    invoke-interface {v1, v0}, Landroid/database/Cursor;->getInt(I)I

    move-result v0

    .line 96
    iput v0, p1, Lcom/moji/mjad/splash/data/CityInfo;->c:I
    :try_end_1
    .catch Ljava/lang/Exception; {:try_start_1 .. :try_end_1} :catch_0
    .catchall {:try_start_1 .. :try_end_1} :catchall_0

    goto :goto_1

    :cond_5
    if-eqz v1, :cond_7

    .line 104
    invoke-interface {v1}, Landroid/database/Cursor;->close()V

    goto :goto_5

    :catchall_0
    move-exception p1

    goto :goto_4

    :catch_0
    move-exception p1

    move-object v0, v1

    goto :goto_3

    :catchall_1
    move-exception p1

    move-object v1, v0

    goto :goto_4

    :catch_1
    move-exception p1

    :goto_3
    :try_start_2
    const-string p2, "LocalCityDBHelper"

    .line 101
    invoke-static {p2, p1}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
    :try_end_2
    .catchall {:try_start_2 .. :try_end_2} :catchall_1

    if-eqz v0, :cond_7

    .line 104
    invoke-interface {v0}, Landroid/database/Cursor;->close()V

    goto :goto_5

    :goto_4
    if-eqz v1, :cond_6

    invoke-interface {v1}, Landroid/database/Cursor;->close()V

    .line 106
    :cond_6
    throw p1

    :cond_7
    :goto_5
    return-void
.end method


# virtual methods
.method public a()Lcom/moji/mjad/splash/data/CityInfo;
    .locals 3

    .line 53
    iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    const/4 v1, 0x0

    if-nez v0, :cond_0

    return-object v1

    .line 56
    :cond_0
    invoke-static {}, Lcom/moji/areamanagement/MJAreaManager;->a()Lcom/moji/common/area/AreaInfo;

    move-result-object v0

    if-eqz v0, :cond_3

    .line 58
    new-instance v1, Lcom/moji/mjad/splash/data/CityInfo;

    invoke-direct {v1}, Lcom/moji/mjad/splash/data/CityInfo;-><init>()V

    .line 60
    :try_start_0
    iget v0, v0, Lcom/moji/common/area/AreaInfo;->cityId:I

    const/4 v2, 0x1

    invoke-direct {p0, v1, v0, v2}, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a(Lcom/moji/mjad/splash/data/CityInfo;IZ)V
    :try_end_0
    .catch Ljava/lang/Exception; {:try_start_0 .. :try_end_0} :catch_0
    .catchall {:try_start_0 .. :try_end_0} :catchall_0

    .line 64
    iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v0, :cond_1

    .line 65
    :goto_0
    iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v0}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    goto :goto_1

    :catchall_0
    move-exception v0

    goto :goto_2

    :catch_0
    move-exception v0

    :try_start_1
    const-string v2, "LocalCityDBHelper"

    .line 62
    invoke-static {v2, v0}, Lcom/moji/tool/log/MJLogger;->a(Ljava/lang/String;Ljava/lang/Throwable;)V
    :try_end_1
    .catchall {:try_start_1 .. :try_end_1} :catchall_0

    .line 64
    iget-object v0, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v0, :cond_1

    goto :goto_0

    :cond_1
    :goto_1
    return-object v1

    :goto_2
    iget-object v1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    if-eqz v1, :cond_2

    .line 65
    iget-object v1, p0, Lcom/moji/mjad/splash/db/SplashCityDbHelper;->a:Landroid/database/sqlite/SQLiteDatabase;

    invoke-virtual {v1}, Landroid/database/sqlite/SQLiteDatabase;->close()V

    .line 67
    :cond_2
    throw v0

    :cond_3
    return-object v1
.end method