Failed commit: Default

sujinwen

2017-07-26 9a09d6bbed781afdc171297ea368cfd1ac25952f

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
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
package cn.com.basic.face.service.sqlite; 
 
import android.database.Cursor; 
import android.database.sqlite.SQLiteDatabase; 
 
import java.io.File; 
import java.text.SimpleDateFormat; 
import java.util.ArrayList; 
import java.util.Date; 
import java.util.List; 
import java.util.UUID; 
 
import cn.com.basic.face.base.MainActivity; 
import cn.com.basic.face.discern.entity.OfflineSurveillance; 
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; 
 
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_surveillance where raw_data_path='"+item.getRawDataPath()+"'"); 
        } 
        catch (Exception e) { 
            e.printStackTrace(); 
        } 
    } 
 
    public boolean hasMoreOfflineSurveillance() { 
        boolean hasMore = false; 
        String sql = "select count(*) from offline_surveillance order by create_time "; 
        Cursor c = MainActivity.getInstance().db.rawQuery(sql, new String[]{}); 
        if (c.moveToFirst()) { 
            hasMore = c.getInt(0) > 0; 
        } 
        return hasMore; 
    } 
 
    /** 
     * 加载OfflineSurllance表 
     * @return 
     */ 
    public List<OfflineSurveillance>  getSurveillanceList(){ 
            String sql="select * from offline_surveillance"; 
        List<OfflineSurveillance> list=new ArrayList<OfflineSurveillance>(); 
        OfflineSurveillance result=null; 
        Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{}); 
        if(c.moveToFirst()){ 
            result=new OfflineSurveillance(); 
            result.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id"))); 
            result.setCamera_in_or_out(c.getString(c.getColumnIndex("camera_in_or_out"))); 
            result.setCreate_time(c.getString(c.getColumnIndex("create_time"))); 
            result.setRawDataPath(c.getString(c.getColumnIndex("raw_data_path"))); 
            result.setSurveillanceId(c.getString(c.getColumnIndex("surveillance_id"))); 
            list.add(result); 
        } 
        return  list; 
    } 
 
    //删除已上传给服务器的数据 
    public void delSurllanceList(){ 
        String sql="delete from offline_surveillance"; 
        MainActivity.getInstance().db.execSQL(sql); 
    } 
 
    //获取未同步数据总数 
    public int  getSynDataCount(){ 
        String sql="select count(*) from offline_surveillance"; 
        Cursor c =MainActivity.getInstance().db.rawQuery(sql,new String[]{}); 
        c.moveToFirst(); 
        return c.getInt(0); 
    } 
}