Giter VIP home page Giter VIP logo

db-interaction's Introduction

微信访客系统 —同步— 本地管理系统

1.业主信息同步

  • 本地上传业主信息
  • 判断业主信息标志位 Per_Mark 是否为 "0" (表示当前业主信息发生过变动!暂未同步到微信访客系统)

    将为"0"的数据,上传到微信访客系统

  • 微信访客接受信息
  • 接受数据,遍历数据,查看Per_Status 和 Per_AllowVisit 是否为 "0"

    如果其中一个值不为"0",则获取当前数据的Per_ContactTel , 去sync_owners 、owners删除对应数据

    如果都为"0",则添加到 sync_owners

    这里就有个问题,如果有一个人一开始具有权限,并且在微信公众号中注册了业主。

    如果被管理员取消了权限之后又开启了权限,那么必须重新去微信公众号注册业主!!

2.下载访客数据

  • 微信访客 发送信息
  • 先读取redis 中 newest-visitor表( 存放的是最新的访客openid)

    如果存在数据,则 拼接表名 user:openid ,获取访客信息,下发成功后,将newest-visitor表删除

  • 本地下拉数据
  • 访问接口,获取数据,存入数据库中 go_visitor表

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.