a

554325746@qq.com

2019-12-25 603cb36a5123e46656b06a5deb8d7ac7ff81307f

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
package com.basic.security.manager;
 
import android.text.TextUtils;
 
import com.basic.security.model.ModelAdapter;
 
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) {// 允许通行de 欢迎语
        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) {
            e.printStackTrace();
        }
        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) {// 确认通行de欢迎语
        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);
        }
    }
}