package com.igo.user.db
|
|
import android.content.ContentValues
|
import android.content.Context
|
import cn.sinata.xldutils.sysErr
|
import com.igo.user.network.entity.LatLonPoint
|
import com.igo.user.network.entity.Tip
|
import org.jetbrains.anko.db.RowParser
|
import org.jetbrains.anko.db.SqlOrderDirection
|
import org.jetbrains.anko.db.delete
|
import org.jetbrains.anko.db.select
|
|
/**
|
* 历史记录数据库操作
|
*/
|
object HistoryDBManager {
|
|
private fun hasSameAddress(context: Context, name: String, address: String, table: String = DBHelper.HISTORY_TABLE_NAME): Long {
|
return context.database.use {
|
return@use select(table)
|
.columns("id")
|
.whereSimple("name=? and address=?", name, address)
|
.exec {
|
if (this.moveToFirst()) {
|
this.getLong(0)
|
} else {
|
-1
|
}
|
}
|
}
|
}
|
|
|
fun getAddressList(context: Context,city: String = "", limit: Int = 10, table: String = DBHelper.HISTORY_TABLE_NAME): List<Tip> {
|
return context.database.use {
|
val columns1 = select(table)
|
.columns("name", "lat", "lng", "district", "address", "code", "time")
|
if (city.isNotEmpty()){
|
columns1.whereSimple("city=?",city)
|
}
|
return@use columns1
|
.limit(limit)
|
.orderBy("time", SqlOrderDirection.DESC)
|
.parseList(object : RowParser<Tip> {
|
override fun parseRow(columns: Array<Any?>): Tip {
|
val tip = Tip()
|
tip.name = columns[0].toString()
|
val lat = columns[1].toString().toDoubleOrNull()
|
val lng = columns[2].toString().toDoubleOrNull()
|
sysErr("----->$lat-------->$lng")
|
if (lat != null && lng != null)
|
tip.setPostion(LatLonPoint(lat, lng))
|
tip.district = columns[3].toString()
|
tip.address = columns[4].toString()
|
tip.adcode = columns[5].toString()
|
return tip
|
}
|
})
|
}
|
}
|
|
|
fun saveHistory(context: Context, tip: Tip,city:String, table: String= DBHelper.HISTORY_TABLE_NAME): Long {
|
return context.database.use {
|
//最多存储20条
|
getAllCount(context, table)
|
val values = ContentValues()
|
val id = hasSameAddress(context, tip.name, tip.address, table)
|
//有
|
if (id != -1L) {
|
values.put("time", System.currentTimeMillis())
|
return@use update(table, values, "id=?", arrayOf(id.toString())).toLong()
|
} else {
|
values.put("name", tip.name)
|
values.put("lat", tip.point.latitude)
|
values.put("lng", tip.point.longitude)
|
values.put("district", tip.district)
|
values.put("address", tip.address)
|
values.put("code", tip.adcode)
|
values.put("city", city)
|
values.put("time", System.currentTimeMillis())
|
return@use insert(table, null, values)
|
}
|
}
|
}
|
|
|
fun clearHistory(context: Context, table: String= DBHelper.HISTORY_TABLE_NAME) {
|
context.database.use {
|
delete(table)
|
}
|
}
|
|
private fun getAllCount(context: Context, table: String) {
|
context.database.use {
|
val list = select(table)
|
.columns("time")
|
.orderBy("time", SqlOrderDirection.DESC)
|
.parseList(object : RowParser<Long> {
|
override fun parseRow(columns: Array<Any?>): Long {
|
return columns[0].toString().toLong()
|
}
|
})
|
if (list.size >= 20) {
|
val last = list[18]
|
delete(table, "time<?", arrayOf(last.toString()))
|
}
|
}
|
}
|
|
}
|
