Difference between revisions of "Technical Documentation"

From HS Wiki
Jump to navigationJump to search
Line 23: Line 23:
 
|-
 
|-
 
! Table !! Custom Field !! Meaning !! Value List
 
! Table !! Custom Field !! Meaning !! Value List
 +
|-
 +
| contact_activity || custom1 || Requested by contact_id || number, points to who made this request
 +
|-
 +
| contact_activity || custom2 || product_id || course, store item, etc. from which the request was made
 +
|-
 +
| || || ||
 
|-
 
|-
 
| contacts || custom1 || Birthdate || yyyy-mm-dd
 
| contacts || custom1 || Birthdate || yyyy-mm-dd
Line 34: Line 40:
 
| || || ||
 
| || || ||
 
|-
 
|-
| contact_activity || custom1 || Requested by contact_id || number, points to who made this request
+
| payments || custom5 || Quickbooks Item || text (temporary field for data initialization)
|-
 
| contact_activity || custom2 || product_id || course, store item, etc. from which the request was made
 
|-
 
| || || ||
 
|-
 
| sources || custom1 || Teachable.com school_id || 547579=Virtual Ashram, 31644=Divine Mother School
 
 
|-
 
|-
 
| || || ||
 
| || || ||
Line 49: Line 49:
 
|-
 
|-
 
| products || custom5 || Quickbooks Mapping || text (temporary field for data initialization)
 
| products || custom5 || Quickbooks Mapping || text (temporary field for data initialization)
 +
|-
 +
| || || ||
 +
|-
 +
| sources || custom1 || Teachable.com school_id || 547579=Virtual Ashram, 31644=Divine Mother School
 
|}
 
|}

Revision as of 12:42, 3 June 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, and (2) integrated forms and logic within an end-user 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

The Divine Mother Center

Table Custom Field Meaning Value List
contact_activity custom1 Requested by contact_id number, points to who made this request
contact_activity custom2 product_id course, store item, etc. 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 Puja included Y/N (default 'Y')
products custom5 Quickbooks Mapping text (temporary field for data initialization)
sources custom1 Teachable.com school_id 547579=Virtual Ashram, 31644=Divine Mother School