ct.smali

.class public final Lcom/imo/android/imoim/util/ct;
.super Ljava/lang/Object;
.source "SourceFile"


# static fields
.field static a:Ljava/lang/String; = "view_type<>7"

.field static b:Ljava/lang/String; = "view_type<>8"


# direct methods
.method static constructor <clinit>()V
    .registers 0

    return-void
.end method

.method public constructor <init>()V
    .registers 1

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

    return-void
.end method

.method public static a(JJ)I
    .registers 6

    .line 749
    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "timestamp>="

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

    invoke-virtual {v0, p0, p1}, Ljava/lang/StringBuilder;->append(J)Ljava/lang/StringBuilder;

    const-string p0, " AND timestamp <= "

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

    invoke-virtual {v0, p2, p3}, Ljava/lang/StringBuilder;->append(J)Ljava/lang/StringBuilder;

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

    move-result-object p0

    .line 751
    new-instance p1, Landroid/content/ContentValues;

    invoke-direct {p1}, Landroid/content/ContentValues;-><init>()V

    const/4 p2, 0x1

    .line 752
    invoke-static {p2}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object p2

    const-string p3, "msg_check_status"

    invoke-virtual {p1, p3, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p2, "messages"

    const/4 p3, 0x0

    const-string v0, "updateCheckMsg"

    .line 753
    invoke-static {p2, p1, p0, p3, v0}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method public static a(JLcom/imo/android/imoim/data/l;Ljava/lang/String;)I
    .registers 11

    .line 282
    iget-wide v0, p2, Lcom/imo/android/imoim/data/l;->E:J

    const/4 v2, 0x1

    const/4 v3, 0x0

    const-wide/16 v4, -0x1

    cmp-long v6, v0, v4

    if-lez v6, :cond_c

    const/4 v0, 0x1

    goto :goto_d

    :cond_c
    const/4 v0, 0x0

    :goto_d
    const-string v1, "rowId is not set"

    invoke-static {v1, v0}, Ljunit/framework/Assert;->assertTrue(Ljava/lang/String;Z)V

    const-string v0, "buid"

    const-string v1, "timestamp"

    .line 283
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    .line 284
    iget-object v4, p2, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    aput-object v4, v1, v3

    invoke-static {p0, p1}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    aput-object p0, v1, v2

    .line 285
    invoke-static {p2}, Lcom/imo/android/imoim/util/ct;->h(Lcom/imo/android/imoim/data/l;)Landroid/content/ContentValues;

    move-result-object p0

    const-string p1, "messages"

    invoke-static {p1, p0, v0, v1, p3}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method public static a(JLjava/lang/String;)I
    .registers 10

    const-string v0, "timestamp>? AND buid=?"

    .line 1103
    invoke-static {v0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

    const-string v0, "COUNT(*)"

    .line 1104
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v2

    const/4 v0, 0x2

    new-array v4, v0, [Ljava/lang/String;

    .line 1106
    invoke-static {p0, p1}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x0

    aput-object p0, v4, p1

    const/4 p0, 0x1

    aput-object p2, v4, p0

    const-string v1, "messages"

    const/4 v5, 0x0

    const/4 v6, 0x1

    .line 1104
    invoke-static/range {v1 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    .line 1109
    invoke-interface {p0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result p2

    if-eqz p2, :cond_2b

    .line 1110
    invoke-interface {p0, p1}, Landroid/database/Cursor;->getInt(I)I

    move-result p1

    .line 1112
    :cond_2b
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return p1
.end method

.method public static a(Lcom/imo/android/imoim/data/l;J)I
    .registers 10

    .line 355
    new-instance v0, Ljava/util/HashMap;

    invoke-direct {v0}, Ljava/util/HashMap;-><init>()V

    const-string v1, "updateAckAndTsAndPreTs"

    const/4 v2, 0x0

    const/4 v3, 0x2

    .line 356
    invoke-static {v2, v3, v1}, Lcom/imo/android/imoim/util/ei;->a(IILjava/lang/String;)Z

    move-result v2

    const-string v3, "resWithMsgId"

    const-string v4, "resWithTs"

    const-string v5, "type"

    const/4 v6, 0x1

    if-eqz v2, :cond_53

    const-string v2, "msg_id_first"

    .line 357
    invoke-interface {v0, v5, v2}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    .line 359
    invoke-static {p0}, Lcom/imo/android/imoim/util/ct;->i(Lcom/imo/android/imoim/data/l;)I

    move-result v2

    .line 360
    invoke-static {v2}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object v5

    invoke-interface {v0, v3, v5}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    if-lez v2, :cond_38

    .line 363
    sget-object p0, Lcom/imo/android/imoim/IMO;->O:Lcom/imo/android/imoim/managers/m;

    invoke-virtual {p0, v1}, Lcom/imo/android/imoim/managers/m;->a(Ljava/lang/String;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p0

    invoke-virtual {p0, v0}, Lcom/imo/android/imoim/managers/m$a;->a(Ljava/util/Map;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p0

    .line 2635
    iput-boolean v6, p0, Lcom/imo/android/imoim/managers/m$a;->f:Z

    .line 363
    invoke-virtual {p0}, Lcom/imo/android/imoim/managers/m$a;->c()V

    return v2

    .line 367
    :cond_38
    invoke-static {p0, p1, p2}, Lcom/imo/android/imoim/util/ct;->c(Lcom/imo/android/imoim/data/l;J)I

    move-result p0

    .line 368
    invoke-static {p0}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p1

    invoke-interface {v0, v4, p1}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    .line 370
    sget-object p1, Lcom/imo/android/imoim/IMO;->O:Lcom/imo/android/imoim/managers/m;

    invoke-virtual {p1, v1}, Lcom/imo/android/imoim/managers/m;->a(Ljava/lang/String;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p1

    invoke-virtual {p1, v0}, Lcom/imo/android/imoim/managers/m$a;->a(Ljava/util/Map;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p1

    .line 3635
    iput-boolean v6, p1, Lcom/imo/android/imoim/managers/m$a;->f:Z

    .line 370
    invoke-virtual {p1}, Lcom/imo/android/imoim/managers/m$a;->c()V

    return p0

    :cond_53
    const-string v2, "ts_first"

    .line 374
    invoke-interface {v0, v5, v2}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    .line 376
    invoke-static {p0, p1, p2}, Lcom/imo/android/imoim/util/ct;->c(Lcom/imo/android/imoim/data/l;J)I

    move-result p1

    .line 377
    invoke-static {p1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p2

    invoke-interface {v0, v4, p2}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    if-lez p1, :cond_75

    .line 380
    sget-object p0, Lcom/imo/android/imoim/IMO;->O:Lcom/imo/android/imoim/managers/m;

    invoke-virtual {p0, v1}, Lcom/imo/android/imoim/managers/m;->a(Ljava/lang/String;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p0

    invoke-virtual {p0, v0}, Lcom/imo/android/imoim/managers/m$a;->a(Ljava/util/Map;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p0

    .line 4635
    iput-boolean v6, p0, Lcom/imo/android/imoim/managers/m$a;->f:Z

    .line 380
    invoke-virtual {p0}, Lcom/imo/android/imoim/managers/m$a;->c()V

    return p1

    .line 384
    :cond_75
    invoke-static {p0}, Lcom/imo/android/imoim/util/ct;->i(Lcom/imo/android/imoim/data/l;)I

    move-result p0

    .line 386
    invoke-static {p0}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p1

    invoke-interface {v0, v3, p1}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    .line 387
    sget-object p1, Lcom/imo/android/imoim/IMO;->O:Lcom/imo/android/imoim/managers/m;

    invoke-virtual {p1, v1}, Lcom/imo/android/imoim/managers/m;->a(Ljava/lang/String;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p1

    invoke-virtual {p1, v0}, Lcom/imo/android/imoim/managers/m$a;->a(Ljava/util/Map;)Lcom/imo/android/imoim/managers/m$a;

    move-result-object p1

    .line 5635
    iput-boolean v6, p1, Lcom/imo/android/imoim/managers/m$a;->f:Z

    .line 387
    invoke-virtual {p1}, Lcom/imo/android/imoim/managers/m$a;->c()V

    return p0
.end method

.method public static a(J)J
    .registers 4

    const-wide/16 v0, 0x3e8

    mul-long p0, p0, v0

    mul-long p0, p0, v0

    return-wide p0
.end method

.method public static a(Lcom/imo/android/imoim/data/l;)J
    .registers 5

    .line 251
    invoke-static {p0}, Lcom/imo/android/imoim/util/ct;->h(Lcom/imo/android/imoim/data/l;)Landroid/content/ContentValues;

    move-result-object v0

    const-string v1, "messages"

    const/4 v2, 0x1

    const-string v3, "storeMessageSend"

    .line 250
    invoke-static {v1, v0, v2, v3}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;ZLjava/lang/String;)J

    move-result-wide v0

    .line 252
    iput-wide v0, p0, Lcom/imo/android/imoim/data/l;->E:J

    .line 253
    iget-object p0, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    invoke-static {p0}, Lcom/imo/android/imoim/util/am;->b(Ljava/lang/String;)V

    return-wide v0
.end method

.method public static a(Lcom/imo/android/imoim/data/l;ZZ)J
    .registers 6

    .line 418
    new-instance v0, Landroid/content/ContentValues;

    invoke-direct {v0}, Landroid/content/ContentValues;-><init>()V

    .line 419
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    const-string v2, "buid"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 420
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->g:Ljava/lang/String;

    const-string v2, "alias"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 6586
    invoke-static {p0}, Lcom/imo/android/imoim/data/message/imdata/am;->h(Lcom/imo/android/imoim/data/message/k;)I

    move-result v1

    .line 421
    invoke-static {v1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v1

    const-string v2, "view_type"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 422
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->t:Ljava/lang/String;

    const-string v2, "icon"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 423
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->f:Ljava/lang/String;

    const-string v2, "author"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 7581
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->h:Ljava/lang/String;

    const-string v2, "author_alias"

    .line 424
    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 425
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->u:Ljava/lang/String;

    const-string v2, "author_icon"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 426
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->v:Lorg/json/JSONObject;

    if-eqz v1, :cond_4b

    .line 427
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->v:Lorg/json/JSONObject;

    invoke-virtual {v1}, Lorg/json/JSONObject;->toString()Ljava/lang/String;

    move-result-object v1

    const-string v2, "imdata"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 7643
    :cond_4b
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->i:Ljava/lang/String;

    const-string v2, "last_message"

    .line 429
    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 430
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "timestamp"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 431
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->l:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "sender_timestamp_nano"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 432
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->m:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "seq_number"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 433
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->n:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "pre_ts"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 434
    iget v1, p0, Lcom/imo/android/imoim/data/l;->o:I

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

    move-result-object v1

    const-string v2, "msg_check_status"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 435
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->j:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "message_index"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 436
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->b:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$b;->toInt()I

    move-result v1

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

    move-result-object v1

    const-string v2, "message_type"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 437
    iget-object p0, p0, Lcom/imo/android/imoim/data/l;->c:Lcom/imo/android/imoim/data/l$a;

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

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

    move-result-object p0

    const-string v1, "message_state"

    invoke-virtual {v0, v1, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p0, "message_read"

    const/4 v1, 0x1

    if-nez p1, :cond_c3

    if-eqz p2, :cond_ba

    goto :goto_c3

    :cond_ba
    const/4 p1, 0x0

    .line 442
    invoke-static {p1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object p1

    invoke-virtual {v0, p0, p1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    goto :goto_d3

    .line 439
    :cond_c3
    :goto_c3
    invoke-static {v1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object p1

    invoke-virtual {v0, p0, p1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 440
    invoke-static {v1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object p0

    const-string p1, "message_played"

    invoke-virtual {v0, p1, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    :goto_d3
    const-string p0, "messages"

    const-string p1, "storeMessage"

    .line 444
    invoke-static {p0, v0, v1, p1}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;ZLjava/lang/String;)J

    move-result-wide p0

    return-wide p0
.end method

.method public static a(Ljava/lang/String;JI)Landroid/database/Cursor;
    .registers 7

    .line 842
    new-instance v0, Ljava/lang/StringBuilder;

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

    const-string v1, "buid"

    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

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

    const-string v1, " AND timestamp<?"

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

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

    move-result-object v0

    .line 844
    invoke-static {v0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    .line 846
    new-instance v1, Ljava/lang/StringBuilder;

    const-string v2, "select * from (select * from messages where "

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

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

    const-string v0, " order by timestamp DESC"

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

    if-gez p3, :cond_33

    const-string p3, ""

    goto :goto_3d

    :cond_33
    invoke-static {p3}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p3

    const-string v0, " limit "

    invoke-virtual {v0, p3}, Ljava/lang/String;->concat(Ljava/lang/String;)Ljava/lang/String;

    move-result-object p3

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

    const-string p3, ") order by timestamp ASC;"

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

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

    move-result-object p3

    const/4 v0, 0x2

    new-array v0, v0, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p0, v0, v1

    const/4 p0, 0x1

    .line 852
    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p1

    aput-object p1, v0, p0

    invoke-static {p3, v0}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static a(Ljava/lang/String;JJ)Landroid/database/Cursor;
    .registers 8

    .line 856
    new-instance v0, Ljava/lang/StringBuilder;

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

    const-string v1, "buid"

    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

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

    const-string v1, " AND timestamp>=? AND timestamp<?"

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

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

    move-result-object v0

    const/4 v1, 0x3

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 860
    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v1, p1

    invoke-static {p3, p4}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x2

    aput-object p0, v1, p1

    const-string p0, "timestamp ASC"

    .line 859
    invoke-static {v0, v1, p0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static a(Ljava/util/List;)Landroid/database/Cursor;
    .registers 5
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "(",
            "Ljava/util/List<",
            "Ljava/lang/String;",
            ">;)",
            "Landroid/database/Cursor;"
        }
    .end annotation

    .line 535
    invoke-interface {p0}, Ljava/util/List;->size()I

    move-result v0

    const-string v1, "message_read"

    const-string v2, "message_type"

    .line 537
    filled-new-array {v1, v2}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

    if-lez v0, :cond_39

    .line 540
    new-instance v0, Ljava/lang/StringBuilder;

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

    .line 541
    invoke-interface {p0}, Ljava/util/List;->iterator()Ljava/util/Iterator;

    move-result-object p0

    :goto_1b
    invoke-interface {p0}, Ljava/util/Iterator;->hasNext()Z

    move-result v1

    if-eqz v1, :cond_35

    invoke-interface {p0}, Ljava/util/Iterator;->next()Ljava/lang/Object;

    move-result-object v1

    check-cast v1, Ljava/lang/String;

    const-string v2, " AND buid!=\""

    .line 542
    invoke-virtual {v0, v2}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

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

    const-string v1, "\""

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

    goto :goto_1b

    .line 544
    :cond_35
    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object v1

    .line 547
    :cond_39
    new-instance p0, Ljava/lang/StringBuilder;

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

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

    const-string v0, " AND message_index<>?"

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

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

    move-result-object p0

    const/4 v0, 0x0

    const/4 v1, 0x3

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    const-string v3, "0"

    aput-object v3, v1, v2

    const/4 v2, 0x1

    .line 549
    sget-object v3, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 551
    invoke-virtual {v3}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object v3

    aput-object v3, v1, v2

    const/4 v2, 0x2

    const-string v3, "-1"

    aput-object v3, v1, v2

    const/16 v2, 0x63

    const-string v3, "timestamp DESC"

    .line 549
    invoke-static {v0, p0, v1, v3, v2}, Lcom/imo/android/imoim/util/cs;->a([Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static a(Ljava/lang/String;Ljava/lang/String;)Lcom/imo/android/imoim/data/l;
    .registers 5

    const-string v0, "buid"

    const-string v1, "msg_id"

    const-string v2, "message_type"

    .line 1349
    filled-new-array {v0, v1, v2}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    .line 1350
    new-instance v1, Ljava/lang/StringBuilder;

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

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

    const-string v0, " AND (message_state=? OR message_state=?)"

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

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

    move-result-object v0

    const/4 v1, 0x5

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    const/4 p0, 0x1

    aput-object p1, v1, p0

    .line 1351
    sget-object p0, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x2

    aput-object p0, v1, p1

    sget-object p0, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    .line 1352
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

    invoke-static {p0}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x3

    aput-object p0, v1, p1

    sget-object p0, Lcom/imo/android/imoim/data/l$a;->FAILED:Lcom/imo/android/imoim/data/l$a;

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

    invoke-static {p0}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x4

    aput-object p0, v1, p1

    const/4 p0, 0x0

    const-string p1, "messages"

    .line 1354
    invoke-static {p1, p0, v0, v1}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    .line 1356
    invoke-interface {p1}, Landroid/database/Cursor;->moveToFirst()Z

    move-result v0

    if-eqz v0, :cond_5c

    .line 1357
    invoke-static {p1}, Lcom/imo/android/imoim/data/l;->a(Landroid/database/Cursor;)Lcom/imo/android/imoim/data/l;

    move-result-object p0

    .line 1359
    :cond_5c
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    return-object p0
.end method

.method private static a([Ljava/lang/String;)Ljava/lang/String;
    .registers 6

    .line 449
    new-instance v0, Ljava/lang/StringBuilder;

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

    .line 451
    array-length v1, p0

    const/4 v2, 0x0

    const/4 v3, 0x0

    :goto_8
    if-ge v2, v1, :cond_22

    aget-object v4, p0, v2

    .line 452
    invoke-virtual {v0, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    add-int/lit8 v3, v3, 0x1

    .line 454
    array-length v4, p0

    if-ge v3, v4, :cond_1a

    const-string v4, "=? AND "

    .line 455
    invoke-virtual {v0, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    goto :goto_1f

    :cond_1a
    const-string v4, "=? "

    .line 457
    invoke-virtual {v0, v4}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    :goto_1f
    add-int/lit8 v2, v2, 0x1

    goto :goto_8

    .line 461
    :cond_22
    array-length p0, p0

    if-lez p0, :cond_2a

    const-string p0, "AND "

    .line 462
    invoke-virtual {v0, p0}, Ljava/lang/StringBuilder;->append(Ljava/lang/String;)Ljava/lang/StringBuilder;

    .line 464
    :cond_2a
    new-instance p0, Ljava/lang/StringBuilder;

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

    sget-object v1, Lcom/imo/android/imoim/util/ct;->a:Ljava/lang/String;

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

    const-string v1, " AND "

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

    sget-object v1, Lcom/imo/android/imoim/util/ct;->b:Ljava/lang/String;

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

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

    move-result-object p0

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

    .line 467
    invoke-virtual {v0}, Ljava/lang/StringBuilder;->toString()Ljava/lang/String;

    move-result-object p0

    return-object p0
.end method

.method public static a(III)Ljava/util/List;
    .registers 13
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "(III)",
            "Ljava/util/List<",
            "Ljava/lang/String;",
            ">;"
        }
    .end annotation

    .line 1124
    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "message_type="

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

    sget-object v1, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;

    .line 1125
    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$b;->toInt()I

    move-result v1

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

    const-string v1, " AND timestamp>?"

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

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

    move-result-object v5

    const/4 v0, 0x1

    new-array v6, v0, [Ljava/lang/String;

    .line 1128
    invoke-static {}, Ljava/lang/System;->currentTimeMillis()J

    move-result-wide v1

    const-wide/32 v3, 0x48190800

    sub-long/2addr v1, v3

    .line 1127
    invoke-static {v1, v2}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object v1

    const/4 v9, 0x0

    aput-object v1, v6, v9

    .line 1129
    invoke-static {}, Lcom/imo/android/imoim/util/at;->e()Lcom/imo/android/imoim/util/aq;

    move-result-object v2

    const-string v1, "buid"

    const-string v3, "view_type"

    .line 1130
    filled-new-array {v1, v3}, [Ljava/lang/String;

    move-result-object v4

    const-string v7, "timestamp DESC"

    const-string v3, "messages"

    const-string v8, "1000"

    invoke-interface/range {v2 .. v8}, Lcom/imo/android/imoim/util/aq;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v1

    .line 1133
    new-instance v2, Ljava/util/HashMap;

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

    .line 1134
    :goto_46
    invoke-interface {v1}, Landroid/database/Cursor;->moveToNext()Z

    move-result v3

    if-eqz v3, :cond_66

    .line 1135
    invoke-interface {v1, v9}, Landroid/database/Cursor;->getString(I)Ljava/lang/String;

    move-result-object v3

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

    move-result v4

    if-ne v4, p0, :cond_5e

    .line 1138
    invoke-static {p1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v4

    invoke-static {v2, v3, v4}, Lcom/imo/android/imoim/util/ct;->a(Ljava/util/Map;Ljava/lang/String;Ljava/lang/Integer;)V

    goto :goto_46

    .line 1140
    :cond_5e
    invoke-static {v0}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v4

    invoke-static {v2, v3, v4}, Lcom/imo/android/imoim/util/ct;->a(Ljava/util/Map;Ljava/lang/String;Ljava/lang/Integer;)V

    goto :goto_46

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

    .line 1144
    invoke-static {v2}, Lcom/imo/android/imoim/util/ct;->a(Ljava/util/Map;)Ljava/util/TreeMap;

    move-result-object p0

    .line 1146
    new-instance p1, Ljava/util/ArrayList;

    invoke-direct {p1}, Ljava/util/ArrayList;-><init>()V

    .line 1147
    invoke-interface {p0}, Ljava/util/Map;->keySet()Ljava/util/Set;

    move-result-object p0

    invoke-interface {p0}, Ljava/util/Set;->iterator()Ljava/util/Iterator;

    move-result-object p0

    :cond_7a
    :goto_7a
    invoke-interface {p0}, Ljava/util/Iterator;->hasNext()Z

    move-result v0

    if-eqz v0, :cond_92

    invoke-interface {p0}, Ljava/util/Iterator;->next()Ljava/lang/Object;

    move-result-object v0

    check-cast v0, Ljava/lang/String;

    .line 1148
    sget-object v1, Lcom/imo/android/imoim/IMO;->g:Lcom/imo/android/imoim/managers/t;

    invoke-static {v0}, Lcom/imo/android/imoim/managers/t;->c(Ljava/lang/String;)Lcom/imo/android/imoim/data/Buddy;

    move-result-object v1

    if-eqz v1, :cond_7a

    .line 1149
    invoke-virtual {p1, v0}, Ljava/util/ArrayList;->add(Ljava/lang/Object;)Z

    goto :goto_7a

    .line 1152
    :cond_92
    invoke-virtual {p1}, Ljava/util/ArrayList;->size()I

    move-result p0

    if-le p0, p2, :cond_9d

    .line 1153
    invoke-virtual {p1, v9, p2}, Ljava/util/ArrayList;->subList(II)Ljava/util/List;

    move-result-object p0

    return-object p0

    :cond_9d
    return-object p1
.end method

.method public static a(Ljava/util/Map;)Ljava/util/TreeMap;
    .registers 3
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "(",
            "Ljava/util/Map<",
            "Ljava/lang/String;",
            "Ljava/lang/Integer;",
            ">;)",
            "Ljava/util/TreeMap<",
            "Ljava/lang/String;",
            "Ljava/lang/Integer;",
            ">;"
        }
    .end annotation

    .line 1075
    new-instance v0, Lcom/imo/android/imoim/util/ej;

    invoke-direct {v0, p0}, Lcom/imo/android/imoim/util/ej;-><init>(Ljava/util/Map;)V

    .line 1076
    new-instance v1, Ljava/util/TreeMap;

    invoke-direct {v1, v0}, Ljava/util/TreeMap;-><init>(Ljava/util/Comparator;)V

    .line 1078
    invoke-virtual {v1, p0}, Ljava/util/TreeMap;->putAll(Ljava/util/Map;)V

    return-object v1
.end method

.method public static a()V
    .registers 3

    .line 218
    new-instance v0, Lcom/imo/android/imoim/util/ct$1;

    invoke-direct {v0}, Lcom/imo/android/imoim/util/ct$1;-><init>()V

    sget-object v1, Lcom/imo/android/imoim/util/at;->a:Ljava/util/concurrent/ExecutorService;

    const/4 v2, 0x0

    .line 245
    invoke-virtual {v0, v1, v2}, Lcom/imo/android/imoim/util/ct$1;->executeOnExecutor(Ljava/util/concurrent/Executor;[Ljava/lang/Object;)Landroid/os/AsyncTask;

    return-void
.end method

.method public static a(Ljava/lang/String;)V
    .registers 4

    const/4 v0, 0x1

    new-array v1, v0, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 128
    invoke-static {p0}, Lcom/imo/android/imoim/message/c;->b(Ljava/lang/String;)V

    .line 129
    const-class v2, Lcom/imo/android/imoim/message/d;

    invoke-static {v2}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v2

    check-cast v2, Lcom/imo/android/imoim/message/d;

    invoke-interface {v2, p0}, Lcom/imo/android/imoim/message/d;->a(Ljava/lang/String;)V

    const-string p0, "buid=?"

    const-string v2, "messages"

    .line 130
    invoke-static {v2, p0, v1, v0}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Z)I

    return-void
.end method

.method public static a(Ljava/lang/String;J)V
    .registers 7

    const/4 v0, 0x2

    new-array v0, v0, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p0, v0, v1

    .line 118
    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object v2

    const/4 v3, 0x1

    aput-object v2, v0, v3

    .line 119
    invoke-static {p0, p1, p2}, Lcom/imo/android/imoim/message/c;->a(Ljava/lang/String;J)V

    .line 120
    const-class v2, Lcom/imo/android/imoim/message/d;

    invoke-static {v2}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v2

    check-cast v2, Lcom/imo/android/imoim/message/d;

    invoke-interface {v2, p0, p1, p2}, Lcom/imo/android/imoim/message/d;->a(Ljava/lang/String;J)V

    const-string p0, "buid=? AND timestamp=?"

    const-string p1, "messages"

    .line 121
    invoke-static {p1, p0, v0, v1}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Z)I

    return-void
.end method

.method public static a(Ljava/lang/String;JLcom/imo/android/imoim/data/l$a;)V
    .registers 8

    .line 717
    new-instance v0, Landroid/content/ContentValues;

    invoke-direct {v0}, Landroid/content/ContentValues;-><init>()V

    .line 718
    invoke-virtual {p3}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

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

    move-result-object v1

    const-string v2, "message_state"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 719
    new-instance v1, Ljava/lang/StringBuilder;

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

    const-string v2, "buid"

    const-string v3, "message_type"

    filled-new-array {v2, v3}, [Ljava/lang/String;

    move-result-object v2

    invoke-static {v2}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v2

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

    const-string v2, " AND message_state<? AND message_state>"

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

    sget-object v2, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    .line 720
    invoke-virtual {v2}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v2

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

    const-string v2, " AND timestamp<=?"

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

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

    move-result-object v1

    const/4 v2, 0x4

    new-array v2, v2, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p0, v2, v3

    .line 722
    sget-object p0, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v3, 0x1

    aput-object p0, v2, v3

    new-instance p0, Ljava/lang/StringBuilder;

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

    .line 723
    invoke-virtual {p3}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p3

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

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

    move-result-object p0

    const/4 p3, 0x2

    aput-object p0, v2, p3

    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x3

    aput-object p0, v2, p1

    const-string p0, "messages"

    const-string p1, "updateMessageState"

    .line 724
    invoke-static {p0, v0, v1, v2, p1}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    return-void
.end method

.method public static a(Ljava/lang/String;JLjava/lang/String;)V
    .registers 6

    const/4 v0, 0x2

    new-array v0, v0, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p0, v0, v1

    .line 315
    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v0, p1

    .line 316
    new-instance p0, Landroid/content/ContentValues;

    invoke-direct {p0}, Landroid/content/ContentValues;-><init>()V

    const-string p1, "imdata"

    .line 317
    invoke-virtual {p0, p1, p3}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    const-string p1, "buid=? AND timestamp=?"

    const-string p2, "messages"

    const-string p3, ""

    .line 318
    invoke-static {p2, p0, p1, v0, p3}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    return-void
.end method

.method private static a(Ljava/util/Map;Ljava/lang/String;Ljava/lang/Integer;)V
    .registers 4
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "(",
            "Ljava/util/Map<",
            "Ljava/lang/String;",
            "Ljava/lang/Integer;",
            ">;",
            "Ljava/lang/String;",
            "Ljava/lang/Integer;",
            ")V"
        }
    .end annotation

    .line 1084
    invoke-interface {p0, p1}, Ljava/util/Map;->containsKey(Ljava/lang/Object;)Z

    move-result v0

    if-eqz v0, :cond_1d

    .line 1085
    invoke-interface {p0, p1}, Ljava/util/Map;->get(Ljava/lang/Object;)Ljava/lang/Object;

    move-result-object v0

    check-cast v0, Ljava/lang/Integer;

    .line 1086
    invoke-virtual {v0}, Ljava/lang/Integer;->intValue()I

    move-result v0

    invoke-virtual {p2}, Ljava/lang/Integer;->intValue()I

    move-result p2

    add-int/2addr v0, p2

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

    move-result-object p2

    invoke-interface {p0, p1, p2}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    return-void

    .line 1088
    :cond_1d
    invoke-interface {p0, p1, p2}, Ljava/util/Map;->put(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;

    return-void
.end method

.method public static b()I
    .registers 5

    .line 759
    new-instance v0, Landroid/content/ContentValues;

    invoke-direct {v0}, Landroid/content/ContentValues;-><init>()V

    const/4 v1, 0x1

    .line 760
    invoke-static {v1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v1

    const-string v2, "msg_check_status"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string v1, "msg_check_status=0 "

    const-string v2, "messages"

    const/4 v3, 0x0

    const-string v4, "updateAllMsgCheckedSerial"

    .line 761
    invoke-static {v2, v0, v1, v3, v4}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result v0

    return v0
.end method

.method public static b(JLcom/imo/android/imoim/data/l;Ljava/lang/String;)I
    .registers 11

    .line 290
    iget-wide v0, p2, Lcom/imo/android/imoim/data/l;->E:J

    const/4 v2, 0x1

    const/4 v3, 0x0

    const-wide/16 v4, -0x1

    cmp-long v6, v0, v4

    if-lez v6, :cond_c

    const/4 v0, 0x1

    goto :goto_d

    :cond_c
    const/4 v0, 0x0

    :goto_d
    const-string v1, "rowId is not set"

    invoke-static {v1, v0}, Ljunit/framework/Assert;->assertTrue(Ljava/lang/String;Z)V

    const-string v0, "buid"

    const-string v1, "timestamp"

    .line 291
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    .line 292
    iget-object v4, p2, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    aput-object v4, v1, v3

    invoke-static {p0, p1}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    aput-object p0, v1, v2

    .line 293
    invoke-static {p2}, Lcom/imo/android/imoim/util/ct;->h(Lcom/imo/android/imoim/data/l;)Landroid/content/ContentValues;

    move-result-object p0

    const-string p1, "messages"

    invoke-static {p1, p0, v0, v1, p3}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method public static b(Lcom/imo/android/imoim/data/l;J)I
    .registers 10

    .line 395
    iget-wide v0, p0, Lcom/imo/android/imoim/data/l;->E:J

    const/4 v2, 0x1

    const/4 v3, 0x0

    const-wide/16 v4, -0x1

    cmp-long v6, v0, v4

    if-lez v6, :cond_c

    const/4 v0, 0x1

    goto :goto_d

    :cond_c
    const/4 v0, 0x0

    :goto_d
    const-string v1, "rowId is not set"

    invoke-static {v1, v0}, Ljunit/framework/Assert;->assertTrue(Ljava/lang/String;Z)V

    const-string v0, "timestamp"

    const-string v1, "buid"

    .line 396
    filled-new-array {v1, v0}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

    const/4 v4, 0x2

    new-array v4, v4, [Ljava/lang/String;

    .line 397
    iget-object v5, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    aput-object v5, v4, v3

    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p1

    aput-object p1, v4, v2

    .line 398
    new-instance p1, Landroid/content/ContentValues;

    invoke-direct {p1}, Landroid/content/ContentValues;-><init>()V

    .line 399
    iget-wide v2, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v2, v3}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object p2

    invoke-virtual {p1, v0, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 400
    iget-wide v2, p0, Lcom/imo/android/imoim/data/l;->l:J

    invoke-static {v2, v3}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object p2

    const-string v0, "sender_timestamp_nano"

    invoke-virtual {p1, v0, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 401
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->b()Lcom/imo/android/imoim/data/l$a;

    move-result-object p0

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

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

    move-result-object p0

    const-string p2, "message_state"

    invoke-virtual {p1, p2, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p0, "messages"

    const-string p2, "ack&ts"

    .line 402
    invoke-static {p0, p1, v1, v4, p2}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method public static b(Lcom/imo/android/imoim/data/l;)J
    .registers 4

    .line 259
    invoke-static {p0}, Lcom/imo/android/imoim/util/ct;->h(Lcom/imo/android/imoim/data/l;)Landroid/content/ContentValues;

    move-result-object v0

    const-string v1, "messages"

    const-string v2, "storeSystemMessageFake"

    invoke-static {v1, v0, v2}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;)J

    move-result-wide v0

    .line 260
    iput-wide v0, p0, Lcom/imo/android/imoim/data/l;->E:J

    .line 261
    iget-object p0, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    invoke-static {p0}, Lcom/imo/android/imoim/util/am;->b(Ljava/lang/String;)V

    return-wide v0
.end method

.method public static b(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 4

    const-string v0, "buid"

    .line 474
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v0

    .line 475
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x1

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    const-string p0, "timestamp DESC LIMIT 1"

    .line 474
    invoke-static {v0, v1, p0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static b(Ljava/lang/String;J)Landroid/database/Cursor;
    .registers 6

    .line 823
    new-instance v0, Ljava/lang/StringBuilder;

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

    const-string v1, "buid"

    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

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

    const-string v1, " AND timestamp>=?"

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

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

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 826
    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v1, p1

    const-string p0, "timestamp ASC"

    .line 825
    invoke-static {v0, v1, p0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static b(J)Lcom/imo/android/imoim/data/l;
    .registers 10

    const/4 v0, 0x1

    new-array v4, v0, [Ljava/lang/String;

    .line 1262
    invoke-static {p0, p1}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x0

    aput-object p0, v4, p1

    const-string v3, "_id=?"

    const-string v1, "messages"

    const/4 v2, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    .line 1263
    invoke-static/range {v1 .. v7}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    .line 1266
    invoke-interface {p0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result p1

    if-eqz p1, :cond_21

    .line 1267
    invoke-static {p0}, Lcom/imo/android/imoim/data/l;->a(Landroid/database/Cursor;)Lcom/imo/android/imoim/data/l;

    move-result-object p1

    goto :goto_22

    :cond_21
    const/4 p1, 0x0

    .line 1269
    :goto_22
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return-object p1
.end method

.method public static b(Ljava/lang/String;JLcom/imo/android/imoim/data/l$a;)Z
    .registers 7

    const-string v0, "buid"

    const-string v1, "timestamp"

    .line 1328
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 1329
    invoke-static {p1, p2}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v1, p1

    .line 1331
    new-instance p0, Landroid/content/ContentValues;

    invoke-direct {p0}, Landroid/content/ContentValues;-><init>()V

    .line 1332
    invoke-virtual {p3}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p2

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

    move-result-object p2

    const-string p3, "message_state"

    invoke-virtual {p0, p3, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p2, "messages"

    const-string p3, "MessagesDbHelper"

    .line 1334
    invoke-static {p2, p0, v0, v1, p3}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    if-lez p0, :cond_36

    return p1

    :cond_36
    return v2
.end method

.method public static c(J)I
    .registers 10

    const-string v0, "COUNT(*)"

    .line 1294
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v2

    const/4 v0, 0x2

    new-array v4, v0, [Ljava/lang/String;

    const/4 v0, 0x5

    .line 1296
    invoke-static {v0}, Ljava/lang/Integer;->toString(I)Ljava/lang/String;

    move-result-object v0

    const/4 v7, 0x0

    aput-object v0, v4, v7

    invoke-static {p0, p1}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v4, p1

    const-string v3, "view_type=? AND timestamp>?"

    const-string v1, "messages"

    const/4 v5, 0x0

    const/4 v6, 0x1

    .line 1298
    invoke-static/range {v1 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    .line 1301
    invoke-interface {p0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result p1

    if-eqz p1, :cond_2c

    .line 1302
    invoke-interface {p0, v7}, Landroid/database/Cursor;->getInt(I)I

    move-result v7

    .line 1304
    :cond_2c
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return v7
.end method

.method private static c(Lcom/imo/android/imoim/data/l;J)I
    .registers 8

    const-string v0, "timestamp"

    const-string v1, "buid"

    .line 339
    filled-new-array {v1, v0}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x2

    new-array v2, v2, [Ljava/lang/String;

    .line 340
    iget-object v3, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    const/4 v4, 0x0

    aput-object v3, v2, v4

    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p1

    const/4 p2, 0x1

    aput-object p1, v2, p2

    .line 341
    new-instance p1, Landroid/content/ContentValues;

    invoke-direct {p1}, Landroid/content/ContentValues;-><init>()V

    .line 342
    iget-wide v3, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v3, v4}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object p2

    invoke-virtual {p1, v0, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 343
    iget-wide v3, p0, Lcom/imo/android/imoim/data/l;->l:J

    invoke-static {v3, v4}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object p2

    const-string v0, "sender_timestamp_nano"

    invoke-virtual {p1, v0, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 344
    iget-wide v3, p0, Lcom/imo/android/imoim/data/l;->n:J

    invoke-static {v3, v4}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object p2

    const-string v0, "pre_ts"

    invoke-virtual {p1, v0, p2}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 345
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->b()Lcom/imo/android/imoim/data/l$a;

    move-result-object p0

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

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

    move-result-object p0

    const-string p2, "message_state"

    invoke-virtual {p1, p2, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p0, "messages"

    const-string p2, "ack&ts"

    .line 346
    invoke-static {p0, p1, v1, v2, p2}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method public static c()J
    .registers 7

    const-string v0, "msg_check_status"

    .line 766
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

    const-string v0, "1"

    .line 767
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v4

    const-string v0, "timestamp"

    .line 770
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v2

    const-string v5, "timestamp DESC"

    const-string v1, "messages"

    const/4 v6, 0x1

    invoke-static/range {v1 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object v1

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

    move-result v2

    if-eqz v2, :cond_2e

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

    move-result v0

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

    move-result-wide v2

    goto :goto_30

    :cond_2e
    const-wide/16 v2, -0x1

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

    return-wide v2
.end method

.method public static c(Lcom/imo/android/imoim/data/l;)J
    .registers 4

    .line 268
    invoke-static {p0}, Lcom/imo/android/imoim/util/ct;->h(Lcom/imo/android/imoim/data/l;)Landroid/content/ContentValues;

    move-result-object v0

    const-string v1, "messages"

    const-string v2, "callRecordMessageFake"

    invoke-static {v1, v0, v2}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;)J

    move-result-wide v0

    .line 269
    iput-wide v0, p0, Lcom/imo/android/imoim/data/l;->E:J

    return-wide v0
.end method

.method public static c(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 9

    const-string v0, "buid"

    const-string v1, "view_type"

    const-string v2, "message_type"

    .line 502
    filled-new-array {v0, v1, v2}, [Ljava/lang/String;

    move-result-object v0

    .line 505
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

    const/4 v0, 0x3

    new-array v4, v0, [Ljava/lang/String;

    const/4 v0, 0x0

    aput-object p0, v4, v0

    const/4 p0, 0x1

    const-string v0, "43"

    aput-object v0, v4, p0

    sget-object p0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 507
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v0, 0x2

    aput-object p0, v4, v0

    const-string v7, "timestamp DESC"

    const-string v1, "messages"

    const/4 v2, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    .line 502
    invoke-static/range {v1 .. v7}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static c(Ljava/lang/String;J)Landroid/database/Cursor;
    .registers 6

    .line 834
    new-instance v0, Ljava/lang/StringBuilder;

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

    const-string v1, "buid"

    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

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

    const-string v1, " AND timestamp<?"

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

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

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 837
    invoke-static {p1, p2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v1, p1

    const-string p0, "timestamp ASC"

    .line 836
    invoke-static {v0, v1, p0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static d(Lcom/imo/android/imoim/data/l;)J
    .registers 5

    const/4 v0, 0x0

    const/4 v1, 0x1

    .line 409
    :try_start_2
    invoke-static {p0, v1, v0}, Lcom/imo/android/imoim/util/ct;->a(Lcom/imo/android/imoim/data/l;ZZ)J

    move-result-wide v2

    iput-wide v2, p0, Lcom/imo/android/imoim/data/l;->E:J

    .line 410
    iget-wide v0, p0, Lcom/imo/android/imoim/data/l;->E:J
    :try_end_a
    .catch Ljava/lang/Exception; {:try_start_2 .. :try_end_a} :catch_b

    return-wide v0

    :catch_b
    move-exception p0

    .line 412
    invoke-static {p0}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object p0

    const-string v0, "storeMessageIncoming "

    invoke-virtual {v0, p0}, Ljava/lang/String;->concat(Ljava/lang/String;)Ljava/lang/String;

    move-result-object p0

    const-string v0, "MessagesDbHelper"

    .line 6079
    invoke-static {v0, p0, v1}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V

    const-wide/16 v0, -0x1

    return-wide v0
.end method

.method public static d(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 5

    const-string v0, "buid"

    const-string v1, "message_type"

    .line 514
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    .line 515
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    sget-object p0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 516
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v2, 0x1

    aput-object p0, v1, v2

    const-string p0, "timestamp DESC"

    const/4 v3, 0x0

    .line 514
    invoke-static {v3, v0, v1, p0, v2}, Lcom/imo/android/imoim/util/cs;->a([Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static d(Ljava/lang/String;J)Lcom/imo/android/imoim/data/l;
    .registers 6

    const-string v0, "buid"

    const-string v1, "timestamp"

    .line 1274
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 1275
    invoke-static {p1, p2}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v1, p1

    const/4 p0, 0x0

    const-string p1, "messages"

    .line 1276
    invoke-static {p1, p0, v0, v1}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p1

    .line 1278
    invoke-interface {p1}, Landroid/database/Cursor;->moveToFirst()Z

    move-result p2

    if-eqz p2, :cond_2a

    .line 1279
    invoke-static {p1}, Lcom/imo/android/imoim/data/l;->a(Landroid/database/Cursor;)Lcom/imo/android/imoim/data/l;

    move-result-object p0

    .line 1281
    :cond_2a
    invoke-interface {p1}, Landroid/database/Cursor;->close()V

    return-object p0
.end method

.method public static d()V
    .registers 3

    .line 804
    invoke-static {}, Lcom/imo/android/imoim/message/c;->b()V

    .line 805
    const-class v0, Lcom/imo/android/imoim/message/d;

    invoke-static {v0}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v0

    check-cast v0, Lcom/imo/android/imoim/message/d;

    invoke-interface {v0}, Lcom/imo/android/imoim/message/d;->f()V

    const/4 v0, 0x0

    const-string v1, "messages"

    const/4 v2, 0x1

    .line 806
    invoke-static {v1, v0, v0, v2}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Z)I

    return-void
.end method

.method public static e(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 5

    const-string v0, "buid"

    const-string v1, "message_type"

    const-string v2, "message_read"

    .line 581
    filled-new-array {v0, v1, v2}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x3

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 582
    sget-object p0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 584
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v2, 0x1

    aput-object p0, v1, v2

    const/4 p0, 0x2

    const-string v2, "0"

    aput-object v2, v1, p0

    const-string p0, "timestamp DESC"

    const/4 v2, 0x0

    const/4 v3, 0x5

    .line 583
    invoke-static {v2, v0, v1, p0, v3}, Lcom/imo/android/imoim/util/cs;->a([Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static e()V
    .registers 8

    const-string v0, "_id"

    .line 920
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v2

    const-string v7, "_id DESC LIMIT 1"

    const-string v1, "messages"

    const/4 v3, 0x0

    const/4 v4, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    invoke-static/range {v1 .. v7}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v1

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

    move-result v2

    if-eqz v2, :cond_5a

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

    move-result v0

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

    move-result-wide v2

    const-wide/16 v4, 0x1388

    sub-long v4, v2, v4

    .line 926
    invoke-static {v4, v5}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object v0

    const-string v4, "_id < "

    invoke-virtual {v4, v0}, Ljava/lang/String;->concat(Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v4, 0x0

    const/4 v5, 0x0

    const-string v6, "messages"

    .line 927
    invoke-static {v6, v0, v4, v5}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Z)I

    move-result v0

    if-lez v0, :cond_5a

    const/16 v4, 0xa

    const/16 v5, 0x64

    const-string v6, "sweep"

    .line 930
    invoke-static {v4, v5, v6}, Lcom/imo/android/imoim/util/ei;->a(IILjava/lang/String;)Z

    move-result v4

    if-eqz v4, :cond_5a

    .line 932
    :try_start_44
    new-instance v4, Lorg/json/JSONObject;

    invoke-direct {v4}, Lorg/json/JSONObject;-><init>()V

    const-string v5, "deleted"

    .line 933
    invoke-virtual {v4, v5, v0}, Lorg/json/JSONObject;->put(Ljava/lang/String;I)Lorg/json/JSONObject;

    const-string v0, "row_id"

    .line 934
    invoke-virtual {v4, v0, v2, v3}, Lorg/json/JSONObject;->put(Ljava/lang/String;J)Lorg/json/JSONObject;

    .line 935
    sget-object v0, Lcom/imo/android/imoim/IMO;->b:Lcom/imo/android/imoim/managers/bb;

    const-string v2, "message_sweep_stable"

    invoke-virtual {v0, v2, v4}, Lcom/imo/android/imoim/managers/bb;->b(Ljava/lang/String;Lorg/json/JSONObject;)V
    :try_end_5a
    .catch Lorg/json/JSONException; {:try_start_44 .. :try_end_5a} :catch_5a

    .line 941
    :catch_5a
    :cond_5a
    invoke-interface {v1}, Landroid/database/Cursor;->close()V

    return-void
.end method

.method public static e(Lcom/imo/android/imoim/data/l;)V
    .registers 4

    const/4 v0, 0x2

    new-array v0, v0, [Ljava/lang/String;

    .line 948
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    const/4 v2, 0x0

    aput-object v1, v0, v2

    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v1, v2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 v1, 0x1

    aput-object p0, v0, v1

    const-string p0, "UPDATE messages SET num_tries=num_tries+1 WHERE buid=? AND timestamp=?"

    .line 949
    invoke-static {p0, v0}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;[Ljava/lang/String;)V

    return-void
.end method

.method public static e(Ljava/lang/String;J)V
    .registers 7

    const-string v0, "message_state"

    const-string v1, "buid"

    const-string v2, "timestamp"

    .line 1339
    filled-new-array {v1, v2, v0}, [Ljava/lang/String;

    move-result-object v1

    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x3

    new-array v2, v2, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p0, v2, v3

    .line 1340
    invoke-static {p1, p2}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x1

    aput-object p0, v2, p1

    sget-object p0, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

    invoke-static {p0}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object p0

    const/4 p1, 0x2

    aput-object p0, v2, p1

    .line 1342
    new-instance p0, Landroid/content/ContentValues;

    invoke-direct {p0}, Landroid/content/ContentValues;-><init>()V

    .line 1343
    sget-object p1, Lcom/imo/android/imoim/data/l$a;->FAILED:Lcom/imo/android/imoim/data/l$a;

    invoke-virtual {p1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p1

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

    move-result-object p1

    invoke-virtual {p0, v0, p1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p1, "messages"

    const-string p2, "MessagesDbHelper"

    .line 1345
    invoke-static {p1, p0, v1, v2, p2}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    return-void
.end method

.method public static f(Ljava/lang/String;)I
    .registers 6

    const-string v0, "buid"

    const-string v1, "message_type"

    const-string v2, "message_read"

    .line 603
    filled-new-array {v0, v1, v2}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    .line 604
    new-instance v1, Ljava/lang/StringBuilder;

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

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

    const-string v0, " AND message_index<>?"

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

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

    move-result-object v0

    const-string v1, "COUNT(*)"

    .line 605
    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x4

    new-array v2, v2, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p0, v2, v3

    sget-object p0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 607
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v4, 0x1

    aput-object p0, v2, v4

    const/4 p0, 0x2

    const-string v4, "0"

    aput-object v4, v2, p0

    const/4 p0, 0x3

    const-string v4, "-1"

    aput-object v4, v2, p0

    const-string p0, "timestamp DESC"

    const/16 v4, 0x3e7

    .line 606
    invoke-static {v1, v0, v2, p0, v4}, Lcom/imo/android/imoim/util/cs;->a([Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    .line 611
    invoke-interface {p0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result v0

    if-eqz v0, :cond_50

    .line 612
    invoke-interface {p0, v3}, Landroid/database/Cursor;->getInt(I)I

    move-result v3

    .line 614
    :cond_50
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return v3
.end method

.method public static f()Landroid/database/Cursor;
    .registers 9

    .line 1239
    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "view_type=15 AND message_state="

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

    sget-object v1, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    .line 1241
    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

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

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

    move-result-object v4

    const-string v2, "messages"

    const/4 v3, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    .line 1239
    invoke-static/range {v2 .. v8}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    return-object v0
.end method

.method public static f(Lcom/imo/android/imoim/data/l;)V
    .registers 4

    const/4 v0, 0x2

    new-array v0, v0, [Ljava/lang/String;

    .line 955
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    const/4 v2, 0x0

    aput-object v1, v0, v2

    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v1, v2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 v1, 0x1

    aput-object p0, v0, v1

    const-string p0, "UPDATE messages SET click_num_tries=click_num_tries+1 WHERE buid=? AND timestamp=?"

    .line 956
    invoke-static {p0, v0}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;[Ljava/lang/String;)V

    return-void
.end method

.method public static g()Landroid/database/Cursor;
    .registers 7

    const-string v0, "messages"

    const/4 v1, 0x0

    const/4 v2, 0x0

    const/4 v3, 0x0

    const/4 v4, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    .line 1287
    invoke-static/range {v0 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    return-object v0
.end method

.method public static g(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 6

    .line 631
    invoke-static {}, Ljava/lang/System;->currentTimeMillis()J

    move-result-wide v0

    invoke-static {v0, v1}, Lcom/imo/android/imoim/util/ct;->a(J)J

    move-result-wide v0

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

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

    const-string v3, "buid"

    filled-new-array {v3}, [Ljava/lang/String;

    move-result-object v3

    invoke-static {v3}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

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

    const-string v3, " AND timestamp > "

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

    const-wide/32 v3, 0xea60

    .line 633
    invoke-static {v3, v4}, Lcom/imo/android/imoim/util/ct;->a(J)J

    move-result-wide v3

    sub-long/2addr v0, v3

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

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

    move-result-object v0

    .line 634
    invoke-static {v0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    .line 635
    new-instance v1, Ljava/lang/StringBuilder;

    const-string v2, "select * from (select * from messages where "

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

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

    const-string v0, " order by timestamp DESC limit 5) order by timestamp ASC;"

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

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

    move-result-object v0

    const/4 v1, 0x1

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    invoke-static {v0, v1}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static g(Lcom/imo/android/imoim/data/l;)V
    .registers 4

    const/4 v0, 0x2

    new-array v0, v0, [Ljava/lang/String;

    .line 963
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    const/4 v2, 0x0

    aput-object v1, v0, v2

    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v1, v2}, Ljava/lang/Long;->toString(J)Ljava/lang/String;

    move-result-object p0

    const/4 v1, 0x1

    aput-object p0, v0, v1

    const-string p0, "UPDATE messages SET message_played=1 WHERE buid=? AND timestamp=?"

    .line 964
    invoke-static {p0, v0}, Lcom/imo/android/imoim/util/at;->b(Ljava/lang/String;[Ljava/lang/String;)V

    return-void
.end method

.method public static h()J
    .registers 8

    const-string v0, "MAX(timestamp)"

    .line 1311
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v2

    const/4 v0, 0x1

    new-array v4, v0, [Ljava/lang/String;

    const/4 v0, 0x5

    .line 1313
    invoke-static {v0}, Ljava/lang/Integer;->toString(I)Ljava/lang/String;

    move-result-object v0

    const/4 v7, 0x0

    aput-object v0, v4, v7

    const-string v3, "view_type=?"

    const-string v1, "messages"

    const/4 v5, 0x0

    const/4 v6, 0x1

    .line 1315
    invoke-static/range {v1 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object v0

    .line 1318
    invoke-interface {v0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result v1

    if-eqz v1, :cond_26

    .line 1319
    invoke-interface {v0, v7}, Landroid/database/Cursor;->getLong(I)J

    move-result-wide v1

    goto :goto_28

    :cond_26
    const-wide/16 v1, 0x0

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

    return-wide v1
.end method

.method public static h(Ljava/lang/String;)J
    .registers 7

    const-string v0, "buid"

    const-string v1, "message_type"

    const-string v2, "message_read"

    .line 646
    filled-new-array {v0, v1, v2}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const-string v1, "timestamp"

    .line 647
    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x3

    new-array v2, v2, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p0, v2, v3

    sget-object p0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 650
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v4, 0x1

    aput-object p0, v2, v4

    const/4 p0, 0x2

    const-string v5, "0"

    aput-object v5, v2, p0

    const-string p0, "timestamp ASC"

    .line 648
    invoke-static {v1, v0, v2, p0, v4}, Lcom/imo/android/imoim/util/cs;->a([Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    .line 653
    invoke-interface {p0}, Landroid/database/Cursor;->moveToNext()Z

    move-result v0

    if-eqz v0, :cond_39

    .line 654
    invoke-interface {p0, v3}, Landroid/database/Cursor;->getLong(I)J

    move-result-wide v0

    goto :goto_40

    .line 656
    :cond_39
    invoke-static {}, Lcom/imo/android/imoim/util/ct;->m()J

    move-result-wide v0

    const-wide/16 v2, 0x1

    add-long/2addr v0, v2

    .line 658
    :goto_40
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return-wide v0
.end method

.method private static h(Lcom/imo/android/imoim/data/l;)Landroid/content/ContentValues;
    .registers 8

    .line 74
    new-instance v0, Landroid/content/ContentValues;

    invoke-direct {v0}, Landroid/content/ContentValues;-><init>()V

    .line 75
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    const-string v2, "buid"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 76
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->g:Ljava/lang/String;

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

    move-result v1

    if-nez v1, :cond_1b

    .line 77
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->g:Ljava/lang/String;

    const-string v2, "alias"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 1586
    :cond_1b
    invoke-static {p0}, Lcom/imo/android/imoim/data/message/imdata/am;->h(Lcom/imo/android/imoim/data/message/k;)I

    move-result v1

    .line 79
    invoke-static {v1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v1

    const-string v2, "view_type"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 80
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->v:Lorg/json/JSONObject;

    if-eqz v1, :cond_37

    .line 81
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->v:Lorg/json/JSONObject;

    invoke-virtual {v1}, Lorg/json/JSONObject;->toString()Ljava/lang/String;

    move-result-object v1

    const-string v2, "imdata"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 1643
    :cond_37
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->i:Ljava/lang/String;

    const-string v2, "last_message"

    .line 83
    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 84
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->k:J

    const-wide/16 v3, 0x0

    cmp-long v5, v1, v3

    if-gtz v5, :cond_64

    .line 87
    invoke-static {}, Lcom/imo/android/imoim/util/ct;->m()J

    move-result-wide v1

    .line 89
    invoke-static {}, Ljava/lang/System;->currentTimeMillis()J

    move-result-wide v3

    invoke-static {v3, v4}, Lcom/imo/android/imoim/util/ct;->a(J)J

    move-result-wide v3

    const-wide/32 v5, 0xdbba0

    add-long/2addr v3, v5

    cmp-long v5, v3, v1

    if-lez v5, :cond_5e

    .line 91
    invoke-virtual {p0, v3, v4}, Lcom/imo/android/imoim/data/l;->a(J)V

    goto :goto_64

    :cond_5e
    const-wide/16 v3, 0x1

    add-long/2addr v1, v3

    .line 93
    invoke-virtual {p0, v1, v2}, Lcom/imo/android/imoim/data/l;->a(J)V

    .line 96
    :cond_64
    :goto_64
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->t:Ljava/lang/String;

    const-string v2, "icon"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 97
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "timestamp"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 98
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->n:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "pre_ts"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 99
    iget-wide v1, p0, Lcom/imo/android/imoim/data/l;->l:J

    invoke-static {v1, v2}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v1

    const-string v2, "sender_timestamp_nano"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 100
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->b:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$b;->toInt()I

    move-result v1

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

    move-result-object v1

    const-string v2, "message_type"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 101
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->b()Lcom/imo/android/imoim/data/l$a;

    move-result-object v1

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

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

    move-result-object v1

    const-string v2, "message_state"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    .line 102
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->x()Ljava/lang/String;

    move-result-object v1

    const-string v2, "msg_id"

    invoke-virtual {v0, v2, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/String;)V

    .line 104
    iget-object v1, p0, Lcom/imo/android/imoim/data/l;->b:Lcom/imo/android/imoim/data/l$b;

    sget-object v2, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;

    const-string v3, "message_read"

    if-ne v1, v2, :cond_c6

    const/4 p0, 0x1

    .line 105
    invoke-static {p0}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object p0

    invoke-virtual {v0, v3, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    goto :goto_cf

    .line 2423
    :cond_c6
    iget-boolean p0, p0, Lcom/imo/android/imoim/data/l;->y:Z

    .line 107
    invoke-static {p0}, Ljava/lang/Boolean;->valueOf(Z)Ljava/lang/Boolean;

    move-result-object p0

    invoke-virtual {v0, v3, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Boolean;)V

    :goto_cf
    return-object v0
.end method

.method private static i(Lcom/imo/android/imoim/data/l;)I
    .registers 6

    .line 323
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->x()Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Landroid/text/TextUtils;->isEmpty(Ljava/lang/CharSequence;)Z

    move-result v0

    if-eqz v0, :cond_c

    const/4 p0, -0x2

    return p0

    :cond_c
    const-string v0, "buid"

    const-string v1, "msg_id"

    .line 327
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    .line 328
    iget-object v3, p0, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    aput-object v3, v1, v2

    const/4 v2, 0x1

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->x()Ljava/lang/String;

    move-result-object v3

    aput-object v3, v1, v2

    .line 329
    new-instance v2, Landroid/content/ContentValues;

    invoke-direct {v2}, Landroid/content/ContentValues;-><init>()V

    .line 330
    iget-wide v3, p0, Lcom/imo/android/imoim/data/l;->k:J

    invoke-static {v3, v4}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v3

    const-string v4, "timestamp"

    invoke-virtual {v2, v4, v3}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 331
    iget-wide v3, p0, Lcom/imo/android/imoim/data/l;->l:J

    invoke-static {v3, v4}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v3

    const-string v4, "sender_timestamp_nano"

    invoke-virtual {v2, v4, v3}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 332
    iget-wide v3, p0, Lcom/imo/android/imoim/data/l;->n:J

    invoke-static {v3, v4}, Ljava/lang/Long;->valueOf(J)Ljava/lang/Long;

    move-result-object v3

    const-string v4, "pre_ts"

    invoke-virtual {v2, v4, v3}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Long;)V

    .line 333
    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l;->b()Lcom/imo/android/imoim/data/l$a;

    move-result-object p0

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result p0

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

    move-result-object p0

    const-string v3, "message_state"

    invoke-virtual {v2, v3, p0}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string p0, "messages"

    const-string v3, "ack&ts"

    .line 334
    invoke-static {p0, v2, v0, v1, v3}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method public static i(Ljava/lang/String;)J
    .registers 9

    .line 789
    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "message_state <> "

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

    sget-object v1, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    .line 790
    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

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

    const-string v1, " AND "

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

    const-string v1, "buid"

    filled-new-array {v1}, [Ljava/lang/String;

    move-result-object v1

    .line 791
    invoke-static {v1}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v1

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

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

    move-result-object v4

    const-string v0, "timestamp"

    .line 792
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v3

    const/4 v1, 0x1

    new-array v5, v1, [Ljava/lang/String;

    const/4 v1, 0x0

    aput-object p0, v5, v1

    const-string v6, "timestamp ASC"

    const-string v2, "messages"

    const/4 v7, 0x1

    invoke-static/range {v2 .. v7}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    .line 795
    invoke-interface {p0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result v1

    if-eqz v1, :cond_4a

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

    move-result v0

    invoke-interface {p0, v0}, Landroid/database/Cursor;->getLong(I)J

    move-result-wide v0

    goto :goto_4c

    :cond_4a
    const-wide/16 v0, -0x1

    .line 798
    :goto_4c
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return-wide v0
.end method

.method static synthetic i()V
    .registers 9

    .line 8135
    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "message_state="

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

    sget-object v1, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    .line 8136
    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

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

    const-string v1, " AND num_tries>=1"

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

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

    move-result-object v4

    const-string v2, "messages"

    const/4 v3, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    const/4 v7, 0x0

    const/4 v8, 0x0

    .line 8138
    invoke-static/range {v2 .. v8}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    .line 8141
    new-instance v1, Ljava/util/ArrayList;

    invoke-direct {v1}, Ljava/util/ArrayList;-><init>()V

    .line 8143
    :cond_29
    :goto_29
    :try_start_29
    invoke-interface {v0}, Landroid/database/Cursor;->moveToNext()Z

    move-result v2

    if-eqz v2, :cond_9a

    .line 8144
    invoke-static {v0}, Lcom/imo/android/imoim/data/l;->a(Landroid/database/Cursor;)Lcom/imo/android/imoim/data/l;

    move-result-object v2

    .line 8172
    invoke-static {}, Ljava/lang/System;->currentTimeMillis()J

    move-result-wide v3

    const-wide/32 v5, 0x1499700

    sub-long/2addr v3, v5

    invoke-static {v3, v4}, Lcom/imo/android/imoim/util/ct;->a(J)J

    move-result-wide v3

    .line 8173
    invoke-static {}, Lcom/imo/android/imoim/util/ei;->cL()Z

    move-result v5

    if-eqz v5, :cond_59

    iget-wide v5, v2, Lcom/imo/android/imoim/data/l;->k:J

    cmp-long v7, v5, v3

    if-lez v7, :cond_59

    const-string v3, "text"

    invoke-virtual {v2}, Lcom/imo/android/imoim/data/l;->t()Ljava/lang/String;

    move-result-object v4

    invoke-virtual {v3, v4}, Ljava/lang/String;->equals(Ljava/lang/Object;)Z

    move-result v3

    if-eqz v3, :cond_59

    const/4 v3, 0x1

    goto :goto_5a

    :cond_59
    const/4 v3, 0x0

    :goto_5a
    if-nez v3, :cond_29

    .line 8148
    const-class v3, Lcom/imo/android/imoim/message/d;

    invoke-static {v3}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v3

    check-cast v3, Lcom/imo/android/imoim/message/d;

    invoke-interface {v3, v2}, Lcom/imo/android/imoim/message/d;->c(Lcom/imo/android/imoim/data/l;)V

    .line 8149
    const-class v3, Lcom/imo/android/imoim/message/d;

    invoke-static {v3}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v3

    check-cast v3, Lcom/imo/android/imoim/message/d;

    invoke-interface {v3, v2}, Lcom/imo/android/imoim/message/d;->d(Lcom/imo/android/imoim/data/l;)V

    .line 8150
    const-class v3, Lcom/imo/android/imoim/message/d;

    invoke-static {v3}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v3

    check-cast v3, Lcom/imo/android/imoim/message/d;

    invoke-interface {v3, v2}, Lcom/imo/android/imoim/message/d;->h(Lcom/imo/android/imoim/data/l;)V

    .line 8151
    const-class v3, Lcom/imo/android/imoim/message/a;

    invoke-static {v3}, Lsg/bigo/mobile/android/a/a/a;->a(Ljava/lang/Class;)Ljava/lang/Object;

    move-result-object v3

    check-cast v3, Lcom/imo/android/imoim/message/a;

    const-string v4, "delete_count"

    sget-object v5, Lcom/imo/android/imoim/util/df$y;->IM_SEND:Lcom/imo/android/imoim/util/df$y;

    invoke-interface {v3, v4, v5}, Lcom/imo/android/imoim/message/a;->a(Ljava/lang/String;Ljava/lang/Enum;)V

    .line 8152
    invoke-interface {v1, v2}, Ljava/util/List;->add(Ljava/lang/Object;)Z
    :try_end_8f
    .catch Ljava/lang/Exception; {:try_start_29 .. :try_end_8f} :catch_90

    goto :goto_29

    :catch_90
    move-exception v2

    .line 8155
    invoke-static {v2}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object v2

    const-string v3, "MessagesDbHelper"

    invoke-static {v3, v2}, Lcom/imo/android/imoim/util/bt;->c(Ljava/lang/String;Ljava/lang/String;)V

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

    .line 8166
    invoke-interface {v1}, Ljava/util/List;->size()I

    move-result v0

    if-lez v0, :cond_b4

    .line 8167
    sget-object v0, Lcom/imo/android/imoim/IMO;->b:Lcom/imo/android/imoim/managers/bb;

    invoke-interface {v1}, Ljava/util/List;->size()I

    move-result v1

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

    move-result-object v1

    const-string v2, "unsent_stable"

    const-string v3, "deleted"

    invoke-virtual {v0, v2, v3, v1}, Lcom/imo/android/imoim/managers/bb;->a(Ljava/lang/String;Ljava/lang/String;Ljava/lang/Object;)V

    :cond_b4
    return-void
.end method

.method public static j(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 4

    const-string v0, "buid"

    .line 813
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v0

    .line 814
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x1

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    const-string p0, "timestamp ASC"

    .line 813
    invoke-static {v0, v1, p0}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method static synthetic j()Ljava/util/List;
    .registers 1

    .line 63
    invoke-static {}, Lcom/imo/android/imoim/util/ct;->l()Ljava/util/List;

    move-result-object v0

    return-object v0
.end method

.method public static k(Ljava/lang/String;)J
    .registers 6

    const-string v0, "buid"

    const-string v1, "message_type"

    const-string v2, "message_read"

    .line 868
    filled-new-array {v0, v1, v2}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

    .line 869
    new-instance v1, Ljava/lang/StringBuilder;

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

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

    const-string v0, " AND message_index<>?"

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

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

    move-result-object v0

    const/4 v1, 0x4

    new-array v1, v1, [Ljava/lang/String;

    const/4 v2, 0x0

    aput-object p0, v1, v2

    .line 870
    sget-object p0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {p0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object p0

    const/4 v2, 0x1

    aput-object p0, v1, v2

    const/4 p0, 0x2

    const-string v3, "0"

    aput-object v3, v1, p0

    const/4 p0, 0x3

    const-string v3, "-1"

    aput-object v3, v1, p0

    const-string p0, "message_index"

    .line 872
    filled-new-array {p0}, [Ljava/lang/String;

    move-result-object v3

    const-string v4, "timestamp DESC"

    invoke-static {v3, v0, v1, v4, v2}, Lcom/imo/android/imoim/util/cs;->a([Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object v0

    .line 876
    invoke-interface {v0}, Landroid/database/Cursor;->moveToFirst()Z

    move-result v1

    if-eqz v1, :cond_53

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

    move-result p0

    .line 877
    invoke-interface {v0, p0}, Landroid/database/Cursor;->getLong(I)J

    move-result-wide v1

    goto :goto_55

    :cond_53
    const-wide/16 v1, -0x1

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

    return-wide v1
.end method

.method static synthetic k()V
    .registers 6

    const/4 v0, 0x3

    new-array v0, v0, [Ljava/lang/String;

    .line 8179
    sget-object v1, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

    invoke-static {v1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x0

    aput-object v1, v0, v2

    sget-object v1, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$b;->toInt()I

    move-result v1

    invoke-static {v1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x1

    aput-object v1, v0, v2

    const/4 v1, 0x2

    const-string v3, "100"

    aput-object v3, v0, v1

    const-string v1, "message_state=? and message_type=? and num_tries>?"

    const/4 v3, 0x0

    .line 8181
    invoke-static {v1, v0, v3}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    .line 8184
    :goto_29
    :try_start_29
    invoke-interface {v0}, Landroid/database/Cursor;->moveToNext()Z

    move-result v1

    if-eqz v1, :cond_4b

    .line 8185
    invoke-static {v0}, Lcom/imo/android/imoim/data/l;->a(Landroid/database/Cursor;)Lcom/imo/android/imoim/data/l;

    move-result-object v1

    .line 8186
    iget-object v3, v1, Lcom/imo/android/imoim/data/l;->e:Ljava/lang/String;

    .line 8501
    iget-wide v4, v1, Lcom/imo/android/imoim/data/l;->k:J

    .line 8186
    invoke-static {v3, v4, v5}, Lcom/imo/android/imoim/util/ct;->e(Ljava/lang/String;J)V
    :try_end_3a
    .catch Ljava/lang/Exception; {:try_start_29 .. :try_end_3a} :catch_3b

    goto :goto_29

    :catch_3b
    move-exception v1

    .line 8189
    invoke-static {v1}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object v1

    const-string v3, "setMsgFailWhileRetrySentTooMany "

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

    move-result-object v1

    const-string v3, "MessagesDbHelper"

    .line 9079
    invoke-static {v3, v1, v2}, Lcom/imo/android/imoim/util/bt;->a(Ljava/lang/String;Ljava/lang/String;Z)V

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

    return-void
.end method

.method public static l(Ljava/lang/String;)I
    .registers 5

    .line 904
    new-instance v0, Ljava/lang/StringBuilder;

    const-string v1, "buid=? AND message_type="

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

    sget-object v1, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 905
    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$b;->toInt()I

    move-result v1

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

    const-string v1, " AND message_read=0"

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

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

    move-result-object v0

    const/4 v1, 0x1

    new-array v2, v1, [Ljava/lang/String;

    const/4 v3, 0x0

    aput-object p0, v2, v3

    .line 908
    new-instance p0, Landroid/content/ContentValues;

    invoke-direct {p0}, Landroid/content/ContentValues;-><init>()V

    .line 909
    invoke-static {v1}, Ljava/lang/Integer;->valueOf(I)Ljava/lang/Integer;

    move-result-object v1

    const-string v3, "message_read"

    invoke-virtual {p0, v3, v1}, Landroid/content/ContentValues;->put(Ljava/lang/String;Ljava/lang/Integer;)V

    const-string v1, "messages"

    const-string v3, "markRead"

    .line 910
    invoke-static {v1, p0, v0, v2, v3}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;Landroid/content/ContentValues;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)I

    move-result p0

    return p0
.end method

.method private static l()Ljava/util/List;
    .registers 4
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "()",
            "Ljava/util/List<",
            "Lcom/imo/android/imoim/data/l;",
            ">;"
        }
    .end annotation

    const/4 v0, 0x3

    new-array v0, v0, [Ljava/lang/String;

    .line 200
    sget-object v1, Lcom/imo/android/imoim/data/l$a;->SENDING:Lcom/imo/android/imoim/data/l$a;

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$a;->toInt()I

    move-result v1

    invoke-static {v1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x0

    aput-object v1, v0, v2

    sget-object v1, Lcom/imo/android/imoim/data/l$b;->SENT:Lcom/imo/android/imoim/data/l$b;

    invoke-virtual {v1}, Lcom/imo/android/imoim/data/l$b;->toInt()I

    move-result v1

    invoke-static {v1}, Ljava/lang/String;->valueOf(I)Ljava/lang/String;

    move-result-object v1

    const/4 v2, 0x1

    aput-object v1, v0, v2

    const/4 v1, 0x2

    const-string v2, "100"

    aput-object v2, v0, v1

    const-string v1, "timestamp ASC"

    const-string v2, "message_state=? and message_type=? and num_tries<=?"

    .line 202
    invoke-static {v2, v0, v1}, Lcom/imo/android/imoim/util/cs;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object v0

    .line 204
    new-instance v1, Ljava/util/ArrayList;

    invoke-direct {v1}, Ljava/util/ArrayList;-><init>()V

    .line 206
    :goto_2f
    :try_start_2f
    invoke-interface {v0}, Landroid/database/Cursor;->moveToNext()Z

    move-result v2

    if-eqz v2, :cond_4d

    .line 207
    invoke-static {v0}, Lcom/imo/android/imoim/data/l;->a(Landroid/database/Cursor;)Lcom/imo/android/imoim/data/l;

    move-result-object v2

    .line 208
    invoke-interface {v1, v2}, Ljava/util/List;->add(Ljava/lang/Object;)Z
    :try_end_3c
    .catch Ljava/lang/Exception; {:try_start_2f .. :try_end_3c} :catch_3d

    goto :goto_2f

    :catch_3d
    move-exception v2

    .line 211
    invoke-static {v2}, Ljava/lang/String;->valueOf(Ljava/lang/Object;)Ljava/lang/String;

    move-result-object v2

    const-string v3, "getUnsentMessages "

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

    move-result-object v2

    const-string v3, "MessagesDbHelper"

    invoke-static {v3, v2}, Lcom/imo/android/imoim/util/bt;->c(Ljava/lang/String;Ljava/lang/String;)V

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

    return-object v1
.end method

.method private static m()J
    .registers 7

    const/4 v0, 0x0

    new-array v0, v0, [Ljava/lang/String;

    .line 731
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

    const-string v0, "timestamp"

    .line 738
    filled-new-array {v0}, [Ljava/lang/String;

    move-result-object v2

    const-string v5, "timestamp DESC"

    const-string v1, "messages"

    const/4 v4, 0x0

    const/4 v6, 0x1

    invoke-static/range {v1 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object v1

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

    move-result v2

    if-eqz v2, :cond_26

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

    move-result v0

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

    move-result-wide v2

    goto :goto_28

    :cond_26
    const-wide/16 v2, -0x1

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

    return-wide v2
.end method

.method public static m(Ljava/lang/String;)Landroid/database/Cursor;
    .registers 9

    const-string v0, "buid"

    const-string v1, "view_type"

    .line 970
    filled-new-array {v0, v1}, [Ljava/lang/String;

    move-result-object v0

    .line 971
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

    const/4 v0, 0x2

    new-array v4, v0, [Ljava/lang/String;

    const/4 v0, 0x0

    aput-object p0, v4, v0

    const/4 p0, 0x1

    const-string v0, "1"

    aput-object v0, v4, p0

    const-string v7, "timestamp DESC"

    const-string v1, "messages"

    const/4 v2, 0x0

    const/4 v5, 0x0

    const/4 v6, 0x0

    .line 970
    invoke-static/range {v1 .. v7}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    return-object p0
.end method

.method public static n(Ljava/lang/String;)Ljava/util/List;
    .registers 8
    .annotation system Ldalvik/annotation/Signature;
        value = {
            "(",
            "Ljava/lang/String;",
            ")",
            "Ljava/util/List<",
            "Lcom/imo/android/imoim/data/l;",
            ">;"
        }
    .end annotation

    const-string v0, "buid"

    const-string v1, "view_type"

    const-string v2, "message_type"

    const-string v3, "message_read"

    .line 995
    filled-new-array {v0, v1, v2, v3}, [Ljava/lang/String;

    move-result-object v0

    .line 996
    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v3

    const/4 v0, 0x4

    new-array v4, v0, [Ljava/lang/String;

    const/4 v0, 0x0

    aput-object p0, v4, v0

    const-string p0, "0"

    const/4 v0, 0x1

    aput-object p0, v4, v0

    sget-object v0, Lcom/imo/android/imoim/data/l$b;->RECEIVED:Lcom/imo/android/imoim/data/l$b;

    .line 997
    invoke-virtual {v0}, Lcom/imo/android/imoim/data/l$b;->toStr()Ljava/lang/String;

    move-result-object v0

    const/4 v1, 0x2

    aput-object v0, v4, v1

    const/4 v0, 0x3

    aput-object p0, v4, v0

    const-string v5, "timestamp DESC"

    const-string v1, "messages"

    const/4 v2, 0x0

    const/16 v6, 0x12

    .line 995
    invoke-static/range {v1 .. v6}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;I)Landroid/database/Cursor;

    move-result-object p0

    .line 999
    new-instance v0, Ljava/util/ArrayList;

    invoke-direct {v0}, Ljava/util/ArrayList;-><init>()V

    .line 1000
    :goto_37
    invoke-interface {p0}, Landroid/database/Cursor;->moveToNext()Z

    move-result v1

    if-eqz v1, :cond_46

    .line 1001
    new-instance v1, Lcom/imo/android/imoim/data/l;

    invoke-direct {v1, p0}, Lcom/imo/android/imoim/data/l;-><init>(Landroid/database/Cursor;)V

    .line 1002
    invoke-interface {v0, v1}, Ljava/util/List;->add(Ljava/lang/Object;)Z

    goto :goto_37

    .line 1004
    :cond_46
    invoke-interface {p0}, Landroid/database/Cursor;->close()V

    return-object v0
.end method

.method public static o(Ljava/lang/String;)I
    .registers 8

    .line 1385
    invoke-static {}, Ljava/util/Calendar;->getInstance()Ljava/util/Calendar;

    move-result-object v0

    const/4 v1, 0x1

    .line 1386
    invoke-virtual {v0, v1}, Ljava/util/Calendar;->get(I)I

    move-result v2

    const/4 v3, 0x2

    .line 1387
    invoke-virtual {v0, v3}, Ljava/util/Calendar;->get(I)I

    move-result v4

    const/4 v5, 0x5

    .line 1388
    invoke-virtual {v0, v5}, Ljava/util/Calendar;->get(I)I

    move-result v5

    .line 1389
    invoke-virtual {v0}, Ljava/util/Calendar;->clear()V

    .line 1390
    invoke-virtual {v0, v2, v4, v5}, Ljava/util/Calendar;->set(III)V

    .line 1391
    invoke-virtual {v0}, Ljava/util/Calendar;->getTimeInMillis()J

    move-result-wide v4

    invoke-static {v4, v5}, Lcom/imo/android/imoim/util/ct;->a(J)J

    move-result-wide v4

    const-string v0, "buid"

    const-string v2, "view_type"

    .line 1393
    filled-new-array {v0, v2}, [Ljava/lang/String;

    move-result-object v0

    invoke-static {v0}, Lcom/imo/android/imoim/util/ct;->a([Ljava/lang/String;)Ljava/lang/String;

    move-result-object v0

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

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

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

    const-string v0, " AND imdata LIKE ?"

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

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

    move-result-object v0

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

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

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

    const-string v0, " AND timestamp >= ?"

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

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

    move-result-object v0

    const/4 v2, 0x4

    new-array v2, v2, [Ljava/lang/String;

    const/4 v6, 0x0

    aput-object p0, v2, v6

    const-string p0, "19"

    aput-object p0, v2, v1

    const-string p0, "%ringback_tips%"

    aput-object p0, v2, v3

    .line 1400
    invoke-static {v4, v5}, Ljava/lang/String;->valueOf(J)Ljava/lang/String;

    move-result-object p0

    const/4 v1, 0x3

    aput-object p0, v2, v1

    const-string p0, "messages"

    const/4 v1, 0x0

    .line 1403
    invoke-static {p0, v1, v0, v2}, Lcom/imo/android/imoim/util/at;->a(Ljava/lang/String;[Ljava/lang/String;Ljava/lang/String;[Ljava/lang/String;)Landroid/database/Cursor;

    move-result-object p0

    .line 1404
    invoke-interface {p0}, Landroid/database/Cursor;->getCount()I

    move-result v0

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

    return v0
.end method