package com.basic.security.manager;

import android.text.TextUtils;

import com.basic.security.model.ModelAdapter;
import com.basic.security.utils.ExceptionUtil;

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

public class BusinessDetailManager extends BaseManager {
    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");
        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 business = findById("business", businessId);
        return "1".equals(business.getString("access_table_name"));
    }

    public static boolean getAccessShowIdentity(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return "1".equals(business.getString("access_identity"));
    }

    public static boolean getAccessShowName(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return "1".equals(business.getString("access_name"));
    }

    public static String getAccessHint(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return business.getString("access_hint");
    }

    public static String getNotReachHint(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return business.getString("not_reached_time_hint");
    }

    public static long getNotReachRemindTime(String businessId) {
        try {
            ModelAdapter business = findById("business", businessId);
            if (business != null) {
                String not_reached_time_remind = business.getString("not_reached_time_remind");
                String time_unit = business.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) {
            ExceptionUtil.printException(e);
        }
        return 0;
    }

    public static boolean getConfirmPassShowIdentity(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return "1".equals(business.getString("confirm_pass_identity"));
    }

    public static boolean getConfirmPassShowName(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return "1".equals(business.getString("confirm_pass_name"));
    }

    public static String getConfirmPassHint(String businessId) {
        ModelAdapter business = findById("business", businessId);
        return business.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) {
            deletePhysically(business_apply_device);
        }
    }
}