package com.basic.security.manager; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.SystemClock; import com.basic.security.base.BaseApplication; import com.basic.security.manager.impl.cblite.DeviceManager; import com.basic.security.manager.impl.cblite.RuleManager; import com.basic.security.manager.impl.cblite.UserManager; import com.basic.security.manager.impl.erlang.ErlangProcess; import com.basic.security.manager.impl.erlang.NodeNameManager; import com.basic.security.manager.impl.sqlite.FeatureManager; import com.basic.security.manager.impl.sqlite.SlBaseManager; import com.basic.security.manager.impl.sqlite.SlDeviceManager; import com.basic.security.model.Device; import com.basic.security.model.ModelAdapter; import com.basic.security.model.Person; import com.basic.security.utils.Constants; import com.basic.security.utils.IpUtils; import java.util.ArrayList; import java.util.Arrays; import java.util.List; public class SystemInitManager { public static void initTablesAndDefaultValues() { BaseApplication.getApplication().executorService.execute(() -> { createTablesInBaseDatabase(); createTablesInCacheDatabase(); createTablesInSyncDatabase(); initDefaultValues(); FeatureManager.initCppFeatureMap(); OfficeDeviceManager.initOfficeDevice(); }); } public static void initDefaultValues() { try { String deviceId = SlDeviceManager.getDeviceId(); ModelAdapter adminIdentity = SlBaseManager.findById("identity", "adminIdentity"); if (adminIdentity == null) { adminIdentity = new ModelAdapter("adminIdentity"); adminIdentity.setString("table", "identity"); adminIdentity.setString("name", "管理员"); adminIdentity.setString("auto_init", "1"); adminIdentity.setString("device_id", DeviceManager.getDeviceId()); adminIdentity.setString("company_id", DeviceManager.getCompareId()); } RuleManager.saveRule(adminIdentity); ModelAdapter staffIdentity = SlBaseManager.findById("identity", "staffIdentity"); if (staffIdentity == null) { staffIdentity = new ModelAdapter("staffIdentity"); staffIdentity.setString("table", "identity"); staffIdentity.setString("name", "老师"); staffIdentity.setString("device_id", DeviceManager.getDeviceId()); staffIdentity.setString("company_id", DeviceManager.getCompareId()); } RuleManager.saveRule(staffIdentity); ModelAdapter blackListIdentity = SlBaseManager.findById("identity", "blackListIdentity"); if (blackListIdentity == null) { blackListIdentity = new ModelAdapter("blackListIdentity"); blackListIdentity.setString("table", "identity"); blackListIdentity.setString("name", "内部人员"); blackListIdentity.setString("device_id", DeviceManager.getDeviceId()); blackListIdentity.setString("company_id", DeviceManager.getCompareId()); } RuleManager.saveRule(blackListIdentity); ModelAdapter admin_person = SlBaseManager.findById("person", deviceId + "admin_person"); if (admin_person == null) { admin_person = new ModelAdapter(deviceId + "admin_person") .setString("name", "系统管理员") .setString("sign_up_status", "已注册") .setString(Person.sign_up_rule, "允许通行") .setString("verify_status", "不需要验证身份证") .setString("sign_up_method", "系统初始化分配") .setString("sign_up_time", System.currentTimeMillis() + "") .setString("device_id", DeviceManager.getDeviceId()) //是系统初始化默认设定的 不能删除这个person的管理员身份 .setString("auto_init", "1") .setString("company_id", DeviceManager.getCompareId()) .setString("table", "person"); } PersonManager.savePerson(admin_person); ModelAdapter admin_user_table = SlBaseManager.findById("user", deviceId + "admin_user"); if (admin_user_table == null) { admin_user_table = new ModelAdapter(deviceId + "admin_user") .setString("table", "user") .setString("name", "系统管理员") .setString("person_id", admin_person.getId()) .setString("username", "admin") .setString("auto_init", "1") .setString("password", "admin123") .setString("device_id", DeviceManager.getDeviceId()) .setString("company_id", DeviceManager.getCompareId()); } UserManager.saveUser(admin_user_table); ModelAdapter admin_person_identity = SlBaseManager.findById("person_identity", deviceId + "admin_person_identity"); if (admin_person_identity == null) { admin_person_identity = new ModelAdapter(deviceId + "admin_person_identity") .setString("table", "person_identity") .setString("identity_id", adminIdentity.getId()) .setString("auto_init", "1") .setString("person_id", admin_person.getId()) .setString("device_id", DeviceManager.getDeviceId()) .setString("company_id", DeviceManager.getCompareId()); } PersonIdentityManager.savePersonIdentity(admin_person_identity); BaseSettingManager.initBaseSetting(); ModelAdapter device = SlBaseManager.findById("device", deviceId + "device"); if (device == null) { device = new ModelAdapter(deviceId + "device"); device.setString("device_id", SlDeviceManager.getDeviceId()); device.setString("ip", IpUtils.getIpAddress(BaseApplication.getApplication())); device.setString(Device.gateway, IpUtils.getGateway(BaseApplication.getApplication())); device.setString(Device.mask, IpUtils.getNetmask(BaseApplication.getApplication())); device.setString("name", DeviceManager.getDeviceId()); device.setString("open_door_time", "5"); device.setString("no_face_delay", "10"); device.setString("table", "device"); } SlBaseManager.save(device); HintDoorAccessManager.initHintDoorAccess(); HintRecognizeManager.initHintRecognize(); HintSignUpManager.initHintSignUp(); // DatabaseManager.getDatabase(Constants.cacheDatabasePath).close(); // DatabaseManager.getDatabase(Constants.syncDatabasePath).close(); SystemClock.sleep(1000); ErlangProcess.erlangProcessCanStart = true; NodeNameManager.start(); } catch (Exception e) { e.printStackTrace(); } } public static void createTablesInCacheDatabase() { try { SQLiteDatabase cacheDatabase = SQLiteDatabase.openOrCreateDatabase( Constants.cacheDatabasePath, null); cacheDatabase.execSQL("CREATE TABLE\n" + "IF NOT EXISTS SqlCache (\n" + " uuid TEXT PRIMARY KEY,\n" + " func TEXT DEFAULT NULL,\n" + " sql TEXT DEFAULT NULL,\n" + " create_time TEXT,\n" + " create_by TEXT\n" + ")"); cacheDatabase.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_sql_cache ON SqlCache (uuid)"); cacheDatabase.execSQL("CREATE TABLE\n" + "IF NOT EXISTS sql_cache_device (\n" + " sql_cache_id TEXT ,\n" + " receive_device_id TEXT, \n" + " CONSTRAINT idx_sql_cache_device UNIQUE (sql_cache_id, receive_device_id)" + ")"); cacheDatabase.close(); } catch (Exception e) { e.printStackTrace(); } } public static void createTablesInBaseDatabase() { DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS base_setting (open_door_password TEXT, open_door_password_enable TEXT,\"open_door_duration\" TEXT, \"auto_register_rule\" TEXT, \"auto_checked_time_rule_id\" TEXT, \"device_setting\" TEXT, \"relation_person\" TEXT, \"relation_device\" TEXT, \"device_name_ip\" TEXT,\"server_name_ip\" TEXT,\"no_face_delay\" TEXT,\"picture_rotation_angle\" TEXT,\"id\" TEXT, \"auto_mode\" TEXT, \"admin_mode\" TEXT, \"pass_mode\" TEXT, \"visitor_mode\" TEXT, \"admin_normal_verify\" TEXT, \"admin_normal_verify_phone\" TEXT, \"admin_normal_verify_idcard\" TEXT, \"admin_normal_verify_name\" TEXT, \"admin_idcard_verify\" TEXT, \"admin_idcard_verify_phone\" TEXT, \"back_to_home\" TEXT, \"image_play_interval\" TEXT, \"detect_multiple_face\" TEXT, \"face_ratio\" TEXT, \"face_angle\" TEXT, \"image_play_time\" TEXT, \"login_expire_long\" TEXT, \"auto_mode_verify_phone\" TEXT, \"auto_normal_verify\" TEXT, \"auto_normal_verify_phone\" TEXT, \"auto_normal_verify_idcard\" TEXT, \"auto_normal_verify_name\" TEXT, \"auto_idcard_verify\" TEXT, \"auto_idcard_verify_phone\" TEXT, \"auto_register_identity_id\" TEXT, \"auto_register_identity_name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); try { DatabaseManager.execSQL("ALTER TABLE base_setting ADD COLUMN normally_closed text"); } catch (Exception e) { e.printStackTrace(); } try { DatabaseManager.execSQL("ALTER TABLE base_setting ADD COLUMN reboot_hour text"); } catch (Exception e) { e.printStackTrace(); } try { DatabaseManager.execSQL("ALTER TABLE base_setting ADD COLUMN reboot_hour_enable text"); } catch (Exception e) { e.printStackTrace(); } DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_base_setting ON base_setting (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS business (\"id\" TEXT, \"business_name\" TEXT, \"create_time\" TEXT, \"only_allow\" TEXT, \"only_allow_start\" TEXT, \"only_allow_end\" TEXT, \"choose_from_time_rule\" TEXT, \"checked_time_rule_id\" TEXT, \"access_table_name\" TEXT,\"access_identity\" TEXT, \"access_name\" TEXT, \"access_hint\" TEXT, \"not_reached_time_hint\" TEXT, \"not_reached_time_remind\" TEXT, \"time_unit\" TEXT, \"confirm_pass_identity\" TEXT, \"confirm_pass_name\" TEXT, \"confirm_pass_hint\" TEXT, \"time_ids\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_business ON business (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS business_person (\"id\" TEXT, \"person_id\" TEXT, \"business_id\" TEXT, \"pass_model\" TEXT, \"contact_person\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_business_person ON business_person (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS confirm (\"id\" TEXT, \"from_device_id\" TEXT, \"from_person_id\" TEXT, \"from_time\" TEXT, \"valid_long\" TEXT, \"confirm_device_id\" TEXT, \"confirm_user_id\" TEXT, \"confirm_time\" TEXT, \"del_flag\" TEXT, \"company_id\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_confirm ON confirm (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS device (\"id\" TEXT, \"name\" TEXT, \"ip\" TEXT, \"mask\" TEXT, \"gateway\" TEXT, \"no_face_delay\" TEXT, \"address\" TEXT, \"server_ip\" TEXT, \"apply_device_ids\" TEXT, \"device_id\" TEXT, \"open_door_time\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_device ON device (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS hint_door_access (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"no_register\" TEXT, \"company_id\" TEXT, \"access_identity\" TEXT, \"access_name\" TEXT, \"access_hint\" TEXT, \"not_reached_time_hint\" TEXT, \"not_reached_time_remind\" TEXT, \"confirm_pass_identity\" TEXT, \"confirm_pass_name\" TEXT, \"confirm_pass_hint\" TEXT, \"refuse_pass_identity\" TEXT, \"refuse_pass_name\" TEXT, \"refuse_pass_hint\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_hint_door_access ON hint_door_access (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS hint_recognize_message (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"head_up\" TEXT, \"head_up_message\" TEXT, \"head_down\" TEXT, \"head_down_message\" TEXT, \"face_max\" TEXT, \"face_max_message\" TEXT, \"face_min\" TEXT, \"face_min_message\" TEXT, \"rotation_left\" TEXT, \"rotation_left_message\" TEXT, \"rotation_right\" TEXT, \"rotation_right_message\" TEXT, \"all_fit\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_hint_recognize_message ON hint_recognize_message (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS hint_sign_up (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"id_card_message\" TEXT, \"id_card_success\" TEXT, \"id_card_fail\" TEXT, \"edit_message\" TEXT, \"register_success\" TEXT, \"admin_logout\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_hint_sign_up ON hint_sign_up (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS identity (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_identity ON identity (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS org (\"id\" TEXT, \"pid\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_org ON org (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS person (\"camera_image_feature_path\" text, \"checked_time_rule_id\" TEXT, \"sign_up_rule\" TEXT,\"id\" TEXT, \"name\" TEXT, \"camera_image_path\" TEXT, \"camera_image_feature\" TEXT, \"camera_image_fastdfs_path\" TEXT, \"id_card_number\" TEXT, \"id_card_image_path\" TEXT, \"id_card_image_feature\" TEXT, \"type\" TEXT, \"phone\" TEXT, \"sign_up_time\" TEXT, \"sign_up_method\" TEXT, \"sign_up_status\" TEXT, \"verify_status\" TEXT, \"auto_init\" TEXT, \"update_time\" TEXT, \"del_flag\" TEXT, \"all_device\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"device_id\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_person ON person (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS person_identity (\"id\" TEXT, \"person_id\" TEXT, \"identity_id\" TEXT, \"del_flag\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_person_identity ON person_identity (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS temporary_person (\"id\" TEXT, \"save_time\" TEXT, \"ip\" TEXT, \"camera_image_path\" TEXT, \"camera_image_feature\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_temporary_person ON temporary_person (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS time (\"id\" TEXT, \"time_rule_name\" TEXT, \"week_json\" TEXT, \"date_json\" TEXT, \"is_use\" TEXT, \"del_flag\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_time ON time (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS user (\"id\" TEXT, \"person_id\" TEXT, \"username\" TEXT, \"password\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_user ON user (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS visit (\"id\" TEXT, \"person_id\" TEXT, \"person_name\" TEXT, \"device_name\" TEXT, \"visit_time\" TEXT, \"verify_result\" TEXT, \"exit_time\" TEXT, \"target_person_id\" TEXT, \"target_person_name\" TEXT, \"target_org_id\" TEXT, \"target_org_name\" TEXT, \"del_flag\" TEXT, \"person_id_number\" TEXT, \"person_phone\" TEXT, \"person_type\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_visit ON visit (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS business_apply_device (\"id\" TEXT, \"business_id\" TEXT, \"device_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_business_apply_device ON business_apply_device (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS OfficeDevice (\"id\" TEXT,\"deviceIp\" TEXT, \"deviceName\" TEXT, \"deviceId\" TEXT, \"company_id\" TEXT, \"ip\" TEXT, \"valid\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_OfficeDevice ON OfficeDevice (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS Log (\"id\" TEXT,\"message\" TEXT,\"createTime\" TEXT,\"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_log ON Log (id)"); initTableColumnNames(); } public static void createTablesInSyncDatabase() { try { SQLiteDatabase syncDatabase = SQLiteDatabase.openOrCreateDatabase( Constants.syncDatabasePath, null); syncDatabase.execSQL("CREATE TABLE IF NOT EXISTS 'device_info'(\"father_node\" text, \"table\" text ,uuid text PRIMARY KEY, node_id text, device_id text, cluster_id text, create_time text, update_time text, create_by text, del_flag text )"); syncDatabase.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_device_info ON device_info (uuid)"); syncDatabase.execSQL("CREATE TABLE IF NOT EXISTS 'cluster_info'(\"table\" text, cluster_id text PRIMARY KEY,cluster_name text,create_time text ,update_time text,create_by text,del_flag text )"); syncDatabase.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_cluster_info ON cluster_info (cluster_id)"); syncDatabase.close(); } catch (Exception e) { e.printStackTrace(); } } private static void initTableColumnNames() { SQLiteDatabase mDataBase = DatabaseManager.getDatabase(); Cursor c = mDataBase.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null); List tableNameList = new ArrayList<>(); if (c.moveToFirst()) { while (!c.isAfterLast()) { tableNameList.add(c.getString(0)); c.moveToNext(); } } c.close(); for (String tableName : tableNameList) { Cursor dbCursor = mDataBase.query(tableName, null, null, null, null, null, null); String[] columnNames = dbCursor.getColumnNames(); BaseManager.tableColumnNames.put(tableName, Arrays.asList(columnNames)); dbCursor.close(); } } /*device_id=1 company_id=1 couchbase_server_ip=192.168.1.133 port=5555*/ // public void initLocalSetting() { // // 把本地设置写到SD卡中 // File file = new File("/sdcard/config.ini"); // if (!file.exists()) { // CopyToSdcard.getInstance(this).copyAssetsToSD("config.ini", "/config.ini"); // } // // try { // //这个判断语句使我们常用的：判断手机是否插入了SD卡和是否有访问权限，如果都有就返回true // if (Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED)) { // FileInputStream fis = new FileInputStream("/sdcard/config.ini"); // List lines = IOUtils.readLines(fis); // for (String line : lines) { // String[] split = line.split("="); // localSetting.put(split[0], split[1]); // } // DeviceManager.device_id = localSetting.get("device_id"); // DeviceManager.company_id = localSetting.get("company_id"); // DeviceManager.couchbase_server_ip = localSetting.get("couchbase_server_ip"); // DeviceManager.port = localSetting.get("port"); // // } // // } catch (Exception e) { // e.printStackTrace(); // } // // } }