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

}