package com.basic.security.manager.impl.sqlite;

import android.text.TextUtils;

import com.couchbase.lite.Expression;
import com.basic.security.model.ModelAdapter;

import java.util.ArrayList;
import java.util.List;

public class SlBusinessDetailManager extends SlBaseManager {


    // 保存此业务表应用于哪些设备
    public static void save(String businessId, String deviceId) {

        ModelAdapter applyDevice = new ModelAdapter();
        applyDevice.setString("business_id", businessId);
        applyDevice.setString("device_id", deviceId);
        applyDevice.setString("table", "business_apply_device");

//        applyDevice.setString("device_id", DeviceInfoManager.getMachineId());
//        applyDevice.setString("company_id", DeviceInfoManager.getCompareId());
        save(applyDevice);
    }

    // 获取到此业务表应用于哪些设备
    public static List<String> getDeviceByBusiness(String businessId) {
        if (TextUtils.isEmpty(businessId)) {
            return new ArrayList<>();
        }
        List<ModelAdapter> deviceList = findList("select * from business_apply_device where business_id='" + businessId + "' ");
        List<String> deviceIdList = new ArrayList<>();
        for (ModelAdapter device : deviceList) {
            if (!deviceIdList.contains(device.getString("device_id"))) {
                deviceIdList.add(device.getString("device_id"));
            }
        }
        return deviceIdList;
    }

    public static List<ModelAdapter> getDeviceDataList() { // 获取所有设备
        String sql = "select * from device";
        return findList(sql);
    }


    // 业务表提示语
    public static boolean getAccessShowTableName(String businessId) {// 允许通行是否显示业务表名称
        ModelAdapter businessDocument = findById("business", businessId);
        if ("1".equals(businessDocument.getString("access_table_name"))) {
            return true;
        }
        return false;
    }

    public static boolean getAccessShowIdentity(String businessId) {// 允许通行是否显示身份
        ModelAdapter businessDocument = findById("business", businessId);
        if ("1".equals(businessDocument.getString("access_identity"))) {
            return true;
        }
        return false;
    }

    public static boolean getAccessShowName(String businessId) {// 允许通行是否显示姓名
        ModelAdapter businessDocument = findById("business", businessId);
        if ("1".equals(businessDocument.getString("access_name"))) {
            return true;
        }
        return false;
    }

    public static String getAccessHint(String businessId) {// 允许通行de 欢迎语
        ModelAdapter businessDocument = findById("business", businessId);
        return businessDocument.getString("access_hint");

    }

    public static String getNotReachHint(String businessId) {// 未到通行时间的欢迎语
        ModelAdapter businessDocument = findById("business", businessId);
        return businessDocument.getString("not_reached_time_hint");

    }

    public static long getNotReachRemindTime(String businessId) { // 开始前多久提示,全部转换为了分钟
        try {
            ModelAdapter businessDocument = findById("business", businessId);
            if (businessDocument != null) {
                String not_reached_time_remind = businessDocument.getString("not_reached_time_remind");
                String time_unit = businessDocument.getString("time_unit");
                if ("分钟".equals(time_unit)) {
                    return Long.parseLong(not_reached_time_remind);
                } else if ("小时".equals(time_unit)) {
                    return Long.parseLong(not_reached_time_remind) * 60;
                } else {
                    return Long.parseLong(not_reached_time_remind) * 60 * 24;
                }
            }
        } catch (NumberFormatException e) {
            e.printStackTrace();
        }
        return 0;
    }

    public static boolean getConfirmPassShowIdentity(String businessId) {// 确认通行是否显示身份
        ModelAdapter businessDocument = findById("business", businessId);
        if ("1".equals(businessDocument.getString("confirm_pass_identity"))) {
            return true;
        }
        return false;
    }

    public static boolean getConfirmPassShowName(String businessId) {// 确认通行是否显示姓名
        ModelAdapter businessDocument = findById("business", businessId);
        if ("1".equals(businessDocument.getString("confirm_pass_name"))) {
            return true;
        }
        return false;
    }

    public static String getConfirmPassHint(String businessId) {// 确认通行de欢迎语
        ModelAdapter businessDocument = findById("business", businessId);
        return businessDocument.getString("confirm_pass_hint");

    }

    public static void delete(String businessId, String deviceId) {
        List<ModelAdapter> business_apply_deviceList = findList(
                "select * from business_apply_device where business_id='" + businessId + "' and device_id='" + deviceId + "'");
        for (ModelAdapter business_apply_device : business_apply_deviceList) {
            delete(business_apply_device);
        }
    }

}