ContactTopic Class Reference

Inherits DataItem.

Public Member Functions
	Sites ()

Static Public Member Functions
static	formatList ()

Public Attributes
	$primary_key = "contact_topic_id"
	$table = "contact_topic"
	$fields
	$relations

Detailed Description

Definition at line 68 of file contact_us.inc.

Member Function Documentation

formatList()

static ContactTopic::formatList ( )

static

Definition at line 84 of file contact_us.inc.

     {
          global $page;
          $topicList = array();
          $siteCount = queryValue(Site, "COUNT(1)", "");
          if($siteCount == 1)
          {         
               $topics = query(ContactTopic, "ORDER BY sort_order");
          }
          else
          {
               $site = $page->Site();
               if(!$site) $site = Site::getSite();
               if($site)
               {
                    $siteTopics = Query::create(ContactTopicSiteXref, "WHERE site_id=:s")
                         ->bind(":s", $site->site_id)
                         ->execute();
                         
                    if(count($siteTopics) > 0)
                    {
                         $topicKeyList = formatItems($siteTopics, "{contact_topic_id}", ",");  
                         $topics = query(ContactTopic, "WHERE contact_topic_id IN ($topicKeyList) ORDER BY sort_order");
                    }
               }
          }
          if(count($topics) > 0)
          {
               foreach($topics as $topic)
                    $topicList[$topic->contact_topic_id] = $topic->topic;
          }
 
          return $topicList;
     }

Sites()

ContactTopic::Sites

(

)

Definition at line 119 of file contact_us.inc.

     {
          return $this->crossReference(Site, ContactTopicSiteXref);
     }

Member Data Documentation

$fields

ContactTopic::$fields

Initial value:

= array(
                         "contact_topic_id"  =>   Number,
                         "topic"                  =>   String,
                         "recipients"        =>   Text,
                         "sort_order"        =>   Number
     )

Definition at line 73 of file contact_us.inc.

$primary_key

ContactTopic::$primary_key = "contact_topic_id"

Definition at line 70 of file contact_us.inc.

$relations

ContactTopic::$relations

Initial value:

= array(
                         "Sites"        =>   Site
     )

Definition at line 80 of file contact_us.inc.

$table

ContactTopic::$table = "contact_topic"

Definition at line 71 of file contact_us.inc.

---

The documentation for this class was generated from the following file:

• C:/code/cms.sonjara.com/cms/components/email/datamodel/contact_us.inc