Difference between revisions of "Technical Documentation"
From HS Wiki
Jump to navigationJump to searchLine 17: | Line 17: | ||
|- | |- | ||
| contacts || custom1 || Delivery Frequency || Best of the Week, Week Day, M-W-F | | contacts || custom1 || Delivery Frequency || Best of the Week, Week Day, M-W-F | ||
+ | | || || || | ||
+ | |- | ||
+ | | products || custom1 || "Switch to Product ID" || toggle to this product when switch from Monthly to Annual, and vice-versa, on website checkout page | ||
+ | |- | ||
+ | |||
|} | |} | ||
Revision as of 10:46, 21 July 2021
System Architecture Overview
The HS CRM application system is built on the LAMP (Linux-Apache-MySQL-PHP) platform. It is designed to operate with two main user interfaces: (1) a company staff-facing backend user interface, and (2) integration with a front-end company website, preferably built in Wordpress and running on the same web server as the backend system.
Main Components
Assuming the web server domain directory is in a /public_html (or /www) directory,
- The HS core software, located on the web server in the /public_html/houghton directory;
- Customized versions of the core software code files, located in the /public_html/houghton_local directory;
- A single MySQL database;
- A front-end website, usually built on the Wordpress platform.
Client Custom Fields
The Optimist Daily
Table | Custom Field | Meaning | Value List | ||||
---|---|---|---|---|---|---|---|
contacts | custom1 | Delivery Frequency | Best of the Week, Week Day, M-W-F | ||||
products | custom1 | "Switch to Product ID" | toggle to this product when switch from Monthly to Annual, and vice-versa, on website checkout page |
The Divine Mother Center
Table | Custom Field | Meaning | Value List |
---|---|---|---|
contact_activity | custom1 | Requested by contact_id | contact_id of who made this request |
contact_activity | custom2 | order_line_id | order_line_id from which the request was made |
contacts | custom1 | Birthdate | yyyy-mm-dd |
contacts | custom2 | Teachable.com user_id | number |
contacts | custom3 | Mother's Name | text |
contacts | custom4 | Father's Name | text |
payments | custom5 | Quickbooks Item | text (temporary field for data initialization) |
products | custom1 | Teachable.com course_id | number |
products | custom2 | Blessing Request included | Y/N (default 'Y') |
products | custom3 | Course author/coach | text |
products | custom5 | Quickbooks Mapping | text (temporary field for data initialization) |
sources | custom1 | Teachable.com school_id | 547579=Virtual Ashram, 31644=Divine Mother School |