Md Rakib Task

https://office-crm.guardior.info/transactions/ https://office-crm.guardior.info/notifications/ https://office-crm.guardior.info/messages/ https://office-crm.guardior.info/notes/

Louis – Suggestions

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.

SQL Queries – Used for different experiments

-=== Working – Get Term Meta data of current user Brand Group SELECT * FROM wp_jet_rel_114 as m1 INNER JOIN     wp_termmeta AS m2 ON     m2.term_id = m1.parent_object_id WHERE m1.child_object_id=%current_user_id% -=== SELECT * FROM wp_jet_rel_114 as m1 INNER JOIN     wp_termmeta AS m2 ON     m2.term_id = m1.parent_object_id WHERE m1.child_object_id=%current_user_id% AND m2.meta_key=’_related_brand’     […]

Client Files

It stores client files in meta field – identity-documents Query – Here – we will list all files associated with given client in clients tab?

Client Balances

Balances (Post Metafields) in a jetform with calculation of the value in different fiat coins (API needed to get current price of the 5 available cryptocoins).

Clients – History

Basics Client Transactions Tab All Transactions Page We have CPT – Clients and CCT called – CCT History Both are connected by Relations Clients to History – One to Many ID: 28 -=== Step to Transaction (History) One Step to Many Transactions 125 -===   Type In Out Normal sent_to Posts – Third Party amount_received_crypto […]

Client Steps

Basics Client Steps Tab All Steps Page We have CPT – Clients and CCT called – CPT Steps Both are connected by Relations Clients to Steps – One to Many ID: 34 -=== Step to Transaction (History) One Step to Many Transactions 125 -=== Listing grid – Displayed using Post Query – Get Steps Post […]

Client Notifications

Basics Client Notification Tab Pending Points – Protik Task for Rakib All Notifications Page Louis – Queries   We have CPT – Clients and CCT called – Client Notifications   Both are connected by Connected Client meta field in Client Notification   Client Notifications have fields Title   Content   Link   read_unread     […]