xuxiuxi

2017-07-21 3faa0f1156937cc0f19e3893bb04df2b882ea41d

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
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.base.MainActivity; 
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; 
        } 
        SQLiteDatabase db = null; 
        try { 
            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()); 
            MainActivity.getInstance().db.execSQL( 
                    "insert into offline_surveillance(raw_data_path, camera_in_or_out, create_time) values('" + 
                            rawDataFileName + "','" + 
                            cameraInOrOut + "','" + 
                            createTime + "'" +")" 
            ); 
 
        } catch (Exception e) { 
            e.printStackTrace(); 
        } 
 
        //人员注册可以选择本地图片 
        //同步临时表 
 
        //同步访客登记表 
 
        //删除本地文件（循环删除） 
    } 
 
    public UnknownQueryItem readOfflineUnknownFromLocal() { 
        UnknownQueryItem item = null; 
        Cursor c = MainActivity.getInstance().db.rawQuery("select raw_data_path,camera_in_or_out,create_time from offline_surveillance order by create_time limit 1", 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"))); 
        } 
        return item; 
    } 
 
    public void removeLocalSqliteRecord(UnknownQueryItem item) { 
        try { 
            File file = FileUtil.getFile(item.getRawDataPath()); 
            if (file.exists()) { 
                file.delete(); 
            } 
            MainActivity.getInstance().db.execSQL("delete from offline_unknown where raw_data_path='"+item.getRawDataPath()+"'"); 
        } 
        catch (Exception e) { 
            e.printStackTrace(); 
        } 
    } 
 
}