xuxiuxi

2017-07-19 afdb5d648f8ddb87f2055f7d3a59b8725ec83d8e

 VisitFace/DemoForBsk/app/src/main/java/cn/com/basic/face/service/sqlite/SurveillanceDao.java

@@ -1,8 +1,92 @@
package cn.com.basic.face.service.sqlite;



/**

 * Created by xiuxi on 2017/7/17.

 */

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();

        }

    }



}