3-31:最后提交

DeteMin

2020-03-31 77c62e023d2dc31200fc696158df84b3aee90ee7

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
127
128
129
130
131
132
133
134
package com.basic.security.manager.impl.sqlite;
 
import android.text.TextUtils;
 
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);
        }
    }
 
}