development-history/proxy.git

			@@ -17,6 +17,7 @@
			import cn.com.basic.face.discern.entity.Visit;
			import cn.com.basic.face.discern.entity.VisitDetail;
			import cn.com.basic.face.discern.query.item.CheckInQueryItem;
			import cn.com.basic.face.discern.query.item.OfflineAttenderRegisterItem;
			import cn.com.basic.face.discern.query.item.OfflineVisitItem;


			@@ -111,49 +112,6 @@
			}
			}

			/**
			* 添加访客记录
			*/
			public void add(OfflineVisitItem entity) {
			String sql =
			"INSERT INTO visit (\n" +
			" visit_id,\n" +
			" visit_reason_id,\n" +
			" remark,\n" +
			" enter_time,\n" +
			" exit_time,\n" +
			" visitor_type_id,\n" +
			" visitor_id,\n" +
			" visitor_company_id,\n" +
			" visitee_id,\n" +
			" visitee_company_id,\n" +
			" current_state_id,\n" +
			" warning,\n" +
			" update_time,\n" +
			" is_synchron,\n" +
			" device_company_id\n" +
			")\n" +
			"VALUES\n" +
			" (\n" +
			" '"+entity.getVisitId()+"', "+
			" '"+entity.getVisitReasonId()+"', "+
			" '"+entity.getRemark()+"', "+
			" '"+entity.getEnterTime()+"', "+
			" '"+entity.getExitTime()+"', "+
			" '"+entity.getVisitorTypeId()+"', "+
			" '"+entity.getVisitorId()+"', "+
			" '"+entity.getVisitorCompanyId()+"', "+
			" '"+entity.getVisiteeId()+"', "+
			" '"+entity.getVisiteeCompanyId()+"', "+
			" '"+entity.getCurrentStateId()+"', "+
			" '"+entity.getWarning()+"', "+
			" '"+entity.getUpdateTime()+"', "+
			" '"+entity.getIsSynchron()+"', "+
			" '"+entity.getDeviceCompanyId()+"' "+
			" )";
			MainActivity.getInstance().db.execSQL(sql);
			}

			public boolean hasOfflineCheckInData() {
			Cursor c = MainActivity.getInstance().db.rawQuery("select count(*) from visit", new String[]{});
			c.moveToFirst();
			@@ -221,4 +179,99 @@
			}
			return resultBean;
			}

			public List<OfflineVisitItem> readOfflineVisitItemFromLocal(long registerId) {
			String sql = "SELECT\n" +
			" a.visit_id,\n" +
			" a.visit_reason_id,\n" +
			" a.remark,\n" +
			" a.enter_time,\n" +
			" a.exit_time,\n" +
			" a.visitor_type_id,\n" +
			" a.visitor_id,\n" +
			" a.visitor_company_id,\n" +
			" a.visitee_id,\n" +
			" a.visitee_company_id,\n" +
			" a.current_state_id,\n" +
			" a.warning,\n" +
			" a.update_time,\n" +
			" a.is_synchron,\n" +
			" a.create_time,\n" +
			" a.device_company_id\n" +
			"FROM\n" +
			" visit a\n" +
			"WHERE\n" +
			" 1 = 1\n" +
			"AND a.is_synchron = 'N'\n" +
			"AND visitor_id = '"+registerId+"'";
			List<OfflineVisitItem> items = new ArrayList<>();
			Cursor c = MainActivity.getInstance().db.rawQuery(sql, new String[]{});
			while (c.moveToNext()) {
			OfflineVisitItem item = new OfflineVisitItem();
			item.setVisitId(c.getString(c.getColumnIndex("visit_id")));
			item.setVisitReasonId(c.getString(c.getColumnIndex("visit_reason_id")));
			item.setRemark(c.getString(c.getColumnIndex("remark")));
			item.setEnterTime(c.getString(c.getColumnIndex("enter_time")));
			item.setExitTime(c.getString(c.getColumnIndex("exit_time")));
			item.setVisitorTypeId(c.getString(c.getColumnIndex("visitor_type_id")));
			item.setVisitorId(c.getString(c.getColumnIndex("visitor_id")));
			item.setVisitorCompanyId(c.getString(c.getColumnIndex("visitor_company_id")));
			item.setVisiteeId(c.getString(c.getColumnIndex("visitee_id")));
			item.setVisiteeCompanyId(c.getString(c.getColumnIndex("visitee_company_id")));
			item.setCurrentStateId(c.getString(c.getColumnIndex("current_state_id")));
			item.setWarning(c.getString(c.getColumnIndex("warning")));
			item.setUpdateTime(c.getString(c.getColumnIndex("update_time")));
			item.setIsSynchron(c.getString(c.getColumnIndex("is_synchron")));
			item.setDeviceCompanyId(c.getString(c.getColumnIndex("device_company_id")));
			item.setCreateTime(c.getString(c.getColumnIndex("create_time")));
			items.add(item);
			}
			return items;
			}

			/**
			* 离线存储访客登记信息
			* @param entity
			*/
			public void addOfflineVisit(OfflineVisitItem entity) {
			String sql =
			"INSERT INTO visit (\n" +
			" visit_id,\n" +
			" visit_reason_id,\n" +
			" remark,\n" +
			" enter_time,\n" +
			" exit_time,\n" +
			" visitor_type_id,\n" +
			" visitor_id,\n" +
			" visitor_company_id,\n" +
			" visitee_id,\n" +
			" visitee_company_id,\n" +
			" current_state_id,\n" +
			" warning,\n" +
			" update_time,\n" +
			" is_synchron,\n" +
			" device_company_id\n" +
			")\n" +
			"VALUES\n" +
			" (\n" +
			" '"+entity.getVisitId()+"', "+
			" '"+entity.getVisitReasonId()+"', "+
			" '"+entity.getRemark()+"', "+
			" '"+entity.getEnterTime()+"', "+
			" '"+entity.getExitTime()+"', "+
			" '"+entity.getVisitorTypeId()+"', "+
			" '"+entity.getVisitorId()+"', "+
			" '"+entity.getVisitorCompanyId()+"', "+
			" '"+entity.getVisiteeId()+"', "+
			" '"+entity.getVisiteeCompanyId()+"', "+
			" '"+entity.getCurrentStateId()+"', "+
			" '"+entity.getWarning()+"', "+
			" '"+entity.getUpdateTime()+"', "+
			" 'N', "+
			" '"+entity.getDeviceCompanyId()+"' "+
			" )";
			MainActivity.getInstance().db.execSQL(sql);
			}


			}