xuxiuxi

2017-07-19 51c810c314e17aebb5935df7165ccf499dc09c31

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
package cn.com.basic.face.service.sqlite; 
 
import android.database.Cursor; 
import android.database.sqlite.SQLiteDatabase; 
import android.graphics.Bitmap; 
 
import java.io.File; 
import java.text.SimpleDateFormat; 
import java.util.Date; 
import java.util.List; 
import java.util.UUID; 
 
import cn.com.basic.face.base.Config; 
import cn.com.basic.face.discern.query.item.SurveillancePhotoQueryItem; 
import cn.com.basic.face.discern.query.item.SurveillanceQueryItem; 
import cn.com.basic.face.discern.query.item.UnknownQueryItem; 
import cn.com.basic.face.util.FileUtil; 
import cn.com.basic.face.util.SurveillanceQueryItemUtil; 
import cn.com.basic.face.util.UnknownSurveillanceQueryItemUtil; 
 
public class SurveillanceDao { 
 
    public static SurveillanceDao instance = new SurveillanceDao(); 
    public static SurveillanceDao getInstance() { 
        return instance; 
    } 
    //companyId 
    //offline_           (headPicture, cameraInOrOut, createTime, visitId) 
    public void saveOfflineUnknownToLocal(final List<SurveillanceQueryItem> bitmapList, final byte[] rawData, final String cameraInOrOut) { 
        if (bitmapList == null || bitmapList.size() == 0) { 
            return; 
        } 
        String rawDataFileName = UUID.randomUUID().toString()+""; 
        FileUtil.writeToFile(rawDataFileName, rawData); 
        String headPicture = ""; 
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); 
        String createTime = sdf.format(new Date()); 
        String sql = "insert offline_unknown(raw_data_path, camera_in_or_out, create_time) values('"+ 
                rawDataFileName+"','"+ 
                cameraInOrOut+"','"+ 
                createTime+"','"+ 
                "null" +"')"; 
        SQLiteDatabase db = Config.sqlMap.getDb(); 
        db.beginTransaction(); 
        db.execSQL(sql); 
        db.endTransaction(); 
 
        UnknownSurveillanceQueryItemUtil.getInstance().addItems(bitmapList); 
 
        //人员注册可以选择本地图片 
        //同步临时表 
 
        //同步访客登记表 
 
        //删除本地文件（循环删除） 
    } 
 
    public UnknownQueryItem readOfflineUnknownFromLocal() { 
        UnknownQueryItem item = null; 
        String sql = "select raw_data_path,camera_in_or_out,create_time from offline_unknown order by create_time create_time limit 1"; 
        SQLiteDatabase db = Config.sqlMap.getDb(); 
        db.beginTransaction(); 
        Cursor c = db.rawQuery(sql, new String[]{}); 
        if (c.moveToFirst()) { 
            item = new UnknownQueryItem(); 
            item.setRawDataPath(c.getString(c.getColumnIndex("raw_data_path"))); 
            item.setCameraInOrOut(c.getString(c.getColumnIndex("camera_in_or_out"))); 
            item.setCreateTime(c.getString(c.getColumnIndex("create_time"))); 
        } 
        c.close(); 
        db.endTransaction(); 
        return item; 
    } 
 
    public void removeLocalSqliteRecord(UnknownQueryItem item) { 
        try { 
            File file = FileUtil.getFile(item.getRawDataPath()); 
            if (file.exists()) { 
                file.delete(); 
            } 
            String sql = "delete from offline_unknown where raw_data_path='"+item.getRawDataPath()+"'"; 
            SQLiteDatabase db = Config.sqlMap.getDb(); 
            db.beginTransaction(); 
            db.execSQL(sql); 
            db.endTransaction(); 
        } 
        catch (Exception e) { 
            e.printStackTrace(); 
        } 
    } 
 
}