Pivot Database to Intent, Entities & Links

[shervine]

This is a major simplification of our tech stack that will reduce the database objects from 10 tables with 116 columns to 3 tables with 31 columns while maintain same level of functionality. There is a range of new enhancements being introduced in this version, so it's a VERY exciting update!

I will be refactoring every single line and function within the code base for this release, and I will be appending re-factored functions with "fn___" to indicate they are done.

General Todo

• Create new triple branch and work on there
• Use 3 different color codes to define each object clearly
• Make 3 objects visible on header
• Rename "Subscription" to "Action Plan" and unify across platform Rename "Subscription" to "Action Plan" and unify across platform #2064
• Implement Content Entity Patterns to auto detect URLs https://mench.com/entities/3307
• Use crypto terminology in preparation for Mench tokens
• Add version in console below chat bottom/right
• Delete old intents for engagement management
• Sync Algolia and log change transaction within key updating functions in DB Model
• Test algolia_sync to ensure it syncs metadata properly (See TODO item within) for mass updates
• Update cron jobs
• Retire en_user_metadata variable from config
• Retire is_valid_intent()
• Search and consider removing all direct queryes "this->db->query("
• Make sure old query JOIN strings are removed such as 'cr', 'w', 'w_c', 'cr_c_parent', 'cr_c_child'
• Revamp messages with entities 4299, 4280 & 4277
• Test Miner message received transactions for Intent Messages vs. Tips Read
• Remove "fn___" prefix from code-base
• Send/Receive media from Messenger

Refactor Codebase & Database Tables

Database Tables

• db/tb_actionplan_links
• db/tb_actionplans
• db/tb_engagement_blog
• db/tb_engagements
• db/tb_entities
• db/tb_entity_links
• db/tb_entity_urls
• db/tb_intents
• db/tb_intent_links
• db/tb_intent_messages

Models

• models/chat
• models/database
• models/matrix
• models/old (To be retired after mingration) - Search and remove "Old_model"

Config

• config/config
• config/matrix_cache (New type of config that is synced with the Matrix)

Helpers

• helper/echo
• helper/general

Controllers

• controllers/Entities
• controllers/Intents
• controllers/Ledger
• controllers/Custom
• controllers/Migrate
• controllers/Cron
• controllers/My
• controllers/Bot

Javascript

• js/custom/actionplan-miner
• js/custom/actionplan-master
• js/custom/entity-manage
• js/custom/global
• js/custom/intent-manage
• js/custom/matrix
• js/custom/messaging

Views

• view_entities/en_miner_ui
• view_entities/en_login_ui
• view_entities/en_pass_reset_ui
• view_intents/in_home_featured_ui
• view_intents/in_message_iframe_ui
• view_intents/in_miner_ui
• view_intents/in_public_ui
• view_ledger/tr_actionplan_messenger_frame
• view_ledger/tr_actionplan_messenger_ui
• view_ledger/tr_actionplan_list_all
• view_ledger/tr_actionplan_right_column
• view_ledger/tr_intent_history
• view_ledger/tr_entity_history
• view_ledger/tr_miner_ui
• view_shared/global_js_css
• view_shared/matrix_footer
• view_shared/matrix_header
• view_shared/messenger_footer
• view_shared/messenger_header
• view_shared/messenger_nav
• view_shared/messenger_web_chat
• view_shared/public_footer
• view_shared/public_header
• view_shared/status_legend

0.7 Improvement ideas

• Detect/prevent duplicate URLs
• Fix intent mass expand button
• Add coin stats to Ledger drop down for more visbility
• Fix but to load Entity Messages with 0 message
• Fix removal of multiple entity links when removing only one
• give warning if uploading entity file when transaction content is set (and then remove if agree)
• Implement child entity link type
• Sync algolia indexes when changing obj/link statuses for intents/entities
• Fix intent sorting bug when removing intents
• Enable drag & drop within levels / OR enable parent/child entity modification
• Fix entity icon status UI bug
• Add "last 7 days" miner leaderboard to stats
• Add People to all Industry experts missing it
• Update algolia function call to mench.com

[shervine]

@grumo Will demo you v0.70 tomorrow morning, so excited!

[shervine]

@grumo After more than 4 months of continious work I am super happy to say that the migration from our old platform to triple is now complete! The next key issue before our MVP launch would be to complete Conversational Engine V1.1 #2035