ZKTeco Terminal Integration

mit

• Serial Number (Frappe "Name")
• Alias
• Is Main
• Push Version
• IP Address
• Model
• FW Version
• Last Activity
• Registry Code
• Options

• ID (Frappe "Name") (ZKTeco 'pin')
• User Name
• Password
• Privilege
• Group
• Main Status
• Sync Terminal

• Frappe "Name" (Autoincrement)
• ZK User (FK "ZK User")
• Type
• No
• Index
• Valid
• Template
• Format
• Major Version
• Minor Version

• ZK User (FK "ZK User")
• Register Photo
• Register Time
• Approval Photo
• Approval Time
• Enroll Terminal (FK "ZK Terminal")

• Frappe "Name" (Autoincrement)
• Terminal (FK "ZK Terminal")
• Command
• Status
• Sent Time
• Done Time
• After Done

• Guest URL /iclock
• ZK Terminal Page
  • Direct Command
    • Get Info
    • Clear User (Clear Users in ZK Terminal)
    • Set User (Download Users to ZK Terminal)
    • Get User (Upload Users to Server)
    • Compare with Server
  • Is Main
    • Add/Update User
• ZK User Page
  • Terminal : Pre Delete
  • Terminal : Sync User
    • Sync New/Modified User
    • Sync Deleted User
• ZK Bio Data [X] Add/Update Bio Data
• ZK Bio Photo [X] Add/Update Bio Photo
• ZK Command Page

• Initialize ZK Terminal
  • Push V.3 (/registry, /push)
• Get ZK Terminal Info
  • Push V.2 (ZK Command : 'INFO', /devicecmd)
  • Push V.3 (ZK Command : '_GET_OPTIONS')
• Get Users
  • Push V.2 (ZK Command : 'CHECK', /cdata?table=OPERLOG)
  • Push V.3 (ZK Command : 'DATA QUERY tablename=user,fielddesc=,filter=')
• Set Users
  • Push V.2 (ZK Command : '_UPDATE')
  • Push V.3 (ZK Command : 'DATA UPDATE user CardNo= Pin=1 Password=234 Group=0 StartTime=0 EndTime=0 Name= Privilege=0')
• Get Face Photo
  • Push V.3 (ZK Command : 'DATA QUERY tablename=biophoto,fielddesc=,filter=')
• Set Face Photo
  • Push V.3 (ZK Command : 'DATA UPDATE biophoto PIN=1 Type=9 Size=10000 Content=${XXX} Format=0 Url=${XXX} PostBackTmpFlag=0')
• Get Face Template
  • Push V.2 (ZK Command : 'CHECK', /cdata?table=BIODATA)
  • Push V.3 (ZK Command : 'DATA QUERY tablename=biodata,fielddesc=*,filter=Type=9')
• Set Face Template
  • Push V.2 (ZK Command : '_UPDATE')
  • Push V.3 (ZK Command : 'DATA UPDATE biodata Pin=2 No=0 Index=0 Valid=1 Duress=0 Type=9 Majorver=5 Minorver=8 Format=0 Tmp=${XXX}')
• Get Fingerprint Template
  • Push V.3 (ZK Command : 'DATA QUERY tablename=biodata,fielddesc=*,filter=Type=1')
• Set Fingerprint Template
  • Push V.3 (ZK Command : 'DATA UPDATE biodata Pin=2 No=0 Index=0 Valid=1 Duress=0 Type=1 Majorver=5 Minorver=8 Format=0 Tmp=${XXX}')
• Delete User [x] Push V.3 (ZK Command : 'DATA DELETE user Pin=${XXX}')
• Delete Bio Data [x] Push V.3 (ZK Command : 'DATA DELETE biodata$ Type=${XXX}')
• Delete Bio Photo [x] Push V.3 (ZK Command : 'DATA DELETE biophoto$ PIN=${XXX}')
• Get Attendance
  • Push V.2
  • Push V.3