• BioTrackTHC

  • Mainstack

    1: Loads and decrypts login interpreter from text file
    1a: puts script as mainstack script
    1b: puts script as substack’s script
    2: Shows login card

  • Substack

    • Tabs allow navigation between appropriate cards
    • Stores interpreter script
    • Always stores stack resize information
  • The Mobile App

    If livecode will not serve our (rather high) android demands (QR scanning, printing, etc), it may be worthwhile to learn some Java and code an android app the hard way.

    This would mean a separate, fully-fledged mobile app for each distro of our software.

    We’ll see if it comes to that

  • Employees Table

    • Employee Number
    • Name
    • Phone (Work)
    • Phone (Home)
    • Email (Work)
    • Email (Personal)
    • Address
    • Ref # for quickbooks/payroll
    • Privileges
    • Username (ONLY if differs from employee number)
    • Password (encrypted)
  • Encryption

  • #Login
    1: Encrypts password
    2: Parse string of semicolon-delimited data
    Employee Number (or Username); Password
    3: Command database to match username to password
    4: If match returned, note a login action in the database
    5: Pass LiveCode a gConnectID
    6: Pass Livecode a Login Handler

  • Login Card

    #Login

    • Username Field
    • Password Field
    • Login Button

    1: Sends data through interpreter to verify user credentials
    2: When passed, stores a gConnectID, loads interpreter into stack script, opens substack, closes itself (card, mainstack remains “open”)
    3: Also limits substack to correct user privileges

  • Incoming Section

    • Handles all Materials Requests and Subsequent P
  • Session/Action Log Table

    • Employee Number
    • Time
    • Action
  • Alternative #Login
    Logs in as database user

  • Actions

    • Login
    • Change settings
    • Move plants
    • Upload Documents
      etc

    Edit/Undo functionality would occur here
    #F_EditUndo

    {"cards":[{"_id":"623daf09ca654661d3000131","treeId":"623d94ddca654661d300004a","seq":5907535,"position":0.5,"parentId":null,"content":"# AMMCan's ERP\n\nRecognized Tags:\n#BioTrack\n#SOP_General\n#SOP_CR (Client Relations)\n#SOP_HR (Human Resources)\n#SOP_Production\n#SOP_QA\n#SOP_Sanitation\n#SOP_Security\n\n#F_Calendar\n#F_QR\n#F_EditUndo\n#F_PDF"},{"_id":"623db1a9ca654661d3000135","treeId":"623d94ddca654661d300004a","seq":5903245,"position":0.625,"parentId":null,"content":"# SOPs and Current Methods"},{"_id":"623db40fca654661d3000137","treeId":"623d94ddca654661d300004a","seq":5903257,"position":1,"parentId":"623db1a9ca654661d3000135","content":"# BioTrackTHC"},{"_id":"623db0c9ca654661d3000132","treeId":"623d94ddca654661d300004a","seq":5903263,"position":0.75,"parentId":null,"content":"# Program Sections"},{"_id":"623dd658ca654661d300013f","treeId":"623d94ddca654661d300004a","seq":5907533,"position":0.75,"parentId":"623db0c9ca654661d3000132","content":"# Mainstack\n\n1: Loads and decrypts login interpreter from text file\n1a: puts script as mainstack script\n1b: puts script as substack's script\n2: Shows login card"},{"_id":"623dbcfcca654661d3000138","treeId":"623d94ddca654661d300004a","seq":5907518,"position":1,"parentId":"623dd658ca654661d300013f","content":"## Login Card\n#Login\n- Username Field\n- Password Field\n- Login Button\n\n1: Sends data through interpreter to verify user credentials\n2: When passed, stores a gConnectID, loads interpreter into stack script, opens substack, closes itself (card, mainstack remains \"open\")\n3: Also limits substack to correct user privileges"},{"_id":"623dc882ca654661d300013d","treeId":"623d94ddca654661d300004a","seq":5907509,"position":1,"parentId":"623dbcfcca654661d3000138","content":"#### Actions\n- Login\n- Change settings\n- Move plants\n- Upload Documents\netc\n\nEdit/Undo functionality would occur here\n#F_EditUndo"},{"_id":"623dd996ca654661d3000140","treeId":"623d94ddca654661d300004a","seq":5903325,"position":2,"parentId":"623db0c9ca654661d3000132","content":"# Substack\n- Tabs allow navigation between appropriate cards\n- Stores interpreter script\n- Always stores stack resize information"},{"_id":"623de3d0ca654661d3000143","treeId":"623d94ddca654661d300004a","seq":5906631,"position":1,"parentId":"623dd996ca654661d3000140","content":"## Incoming Section\n- Handles all Materials Requests and Subsequent P"},{"_id":"623de08dca654661d3000142","treeId":"623d94ddca654661d300004a","seq":5903326,"position":3,"parentId":"623db0c9ca654661d3000132","content":"# The Mobile App\n\nIf livecode will not serve our (rather high) android demands (QR scanning, printing, etc), it may be worthwhile to learn some Java and code an android app the hard way.\n\nThis would mean a separate, fully-fledged mobile app for each distro of our software.\n\nWe'll see if it comes to that"},{"_id":"623db108ca654661d3000133","treeId":"623d94ddca654661d300004a","seq":5903272,"position":0.78125,"parentId":null,"content":"# MySQL Databases"},{"_id":"623dbfdbca654661d300013b","treeId":"623d94ddca654661d300004a","seq":5903301,"position":1,"parentId":"623db108ca654661d3000133","content":"## Employees Table\n- Employee Number\n- Name\n- Phone (Work)\n- Phone (Home)\n- Email (Work)\n- Email (Personal)\n- Address\n- Ref # for quickbooks/payroll\n- Privileges\n- Username (ONLY if differs from employee number)\n- Password (encrypted)"},{"_id":"623dc74dca654661d300013c","treeId":"623d94ddca654661d300004a","seq":5903296,"position":1,"parentId":"623dbfdbca654661d300013b","content":"### Session/Action Log Table\n- Employee Number\n- Time\n- Action"},{"_id":"623db163ca654661d3000134","treeId":"623d94ddca654661d300004a","seq":5903268,"position":0.8125,"parentId":null,"content":"# Database Interpreter"},{"_id":"623dbe8fca654661d300013a","treeId":"623d94ddca654661d300004a","seq":5903269,"position":1,"parentId":"623db163ca654661d3000134","content":"# Encryption"},{"_id":"623dccdfca654661d300013e","treeId":"623d94ddca654661d300004a","seq":5903318,"position":2,"parentId":"623db163ca654661d3000134","content":"#Login\n1: Encrypts password\n2: Parse string of semicolon-delimited data\nEmployee Number (or Username); Password\n3: Command database to match username to password\n4: If match returned, note a login action in the database\n5: Pass LiveCode a gConnectID\n6: Pass Livecode a Login Handler"},{"_id":"623ddc2eca654661d3000141","treeId":"623d94ddca654661d300004a","seq":5903319,"position":1,"parentId":"623dccdfca654661d300013e","content":"Alternative #Login\nLogs in as database user"}],"tree":{"_id":"623d94ddca654661d300004a","name":"AMMCanDB","publicUrl":"ammcan-db"}}