<?php 
 
   defined('C5_EXECUTE') or die("Access Denied.");
   class PeopleListBlockController extends BlockController {
 
      protected $btTable = 'btPeopleList';
      protected $btInterfaceWidth = "500";
      protected $btInterfaceHeight = "350";
      protected $btExportPageColumns = array('cParentID');
      protected $btExportPageTypeColumns = array('ctID');
      protected $btCacheBlockRecord = true;
 
 
      /** 
       * Used for localization. If we want to localize the name/description we have to include this
       */
      public function getBlockTypeDescription() {
         return t("List people based on group.");
      }
 
      public function getBlockTypeName() {
         return t("People List");
      }
 
      public function getJavaScriptStrings() {
         return array(
            'feed-name' => t('Please give your RSS Feed a name.')
         );
      }
 
      function getPeople($query = null) {         
         //Load external database
         $db = Loader::db('localhost', 'victory_director', 'd1rect0ry', 'victory_directory', true);
         $sql = 'SELECT * FROM group_grp ';
 
         $db = Loader::db(null, null, null, null, true);
 
         $bID = $this->bID;
         if ($this->bID) {
            $q = "select group from btPeopleList where bID = '$bID'";
            $r = $db->query($q);
            if ($r) {
               $row = $r->fetchRow();
            }
         } else {
            $row['group'] = $this->group;
         }
 
 
         $ppl = new PeopleList();
         $ppl->setNameSpace('b' . $this->bID);
 
         $cArray = array();
 
         $this->set('pl', $ppl);
         return $persons;
      }
 
      public function view() {
         $cArray = $this->getPeople();
         //$nh = Loader::helper('navigation');
         //$this->set('nh', $nh);
         $this->set('cArray', $cArray); //Legacy (pre-5.4.2)
         $this->set('persons', $cArray); //More descriptive variable name (introduced in 5.4.2)
 
      }
 
      public function add() {
         $c = Page::getCurrentPage();
         $uh = Loader::helper('concrete/urls');
         $this->set('c', $c);
         $this->set('uh', $uh);
         $this->set('bt', BlockType::getByHandle('people_list'));
      }
 
      public function edit() {
         $b = $this->getBlockObject();
         $bCID = $b->getBlockCollectionID();
         $bID=$b->getBlockID();
         $this->set('bID', $bID);
         $c = Page::getCurrentPage();
         if ($c->getCollectionID() != $this->cParentID && (!$this->cThis) && ($this->cParentID != 0)) { 
            $isOtherPage = true;
            $this->set('isOtherPage', true);
         }
         $uh = Loader::helper('concrete/urls');
         $this->set('uh', $uh);
         $this->set('bt', BlockType::getByHandle('people_list'));
      }
 
      function save($args) {
         // If we've gotten to the process() function for this class, we assume that we're in
         // the clear, as far as permissions are concerned (since we check permissions at several
         // points within the dispatcher)
         $db = Loader::db();
 
         $bID = $this->bID;
         $c = $this->getCollectionObject();
         if (is_object($c)) {
            $this->cID = $c->getCollectionID();
         }
 
         $args['group'] = intval($args['group']);
 
         parent::save($args);
 
      }
 
   }
 
?>
 

 
<?php  defined('C5_EXECUTE') or die("Access Denied."); ?> 
 
<input type="hidden" name="pageListToolsDir" value="<?php echo $uh->getBlockTypeToolsURL($bt)?>/" />
<div id="ccm-pagelistPane-add" class="ccm-pagelistPane">
   <div class="ccm-block-field-group">
     <h2><?php echo t('Group to Display')?></h2>
 
     <?php 
         $ctArray = CollectionType::getList();
 
         if (is_array($ctArray)) { ?>
     <select name="group" id="groupList">
      <?php  foreach ($ctArray as $ct) { ?>
      <option value="<?php echo $ct->getCollectionTypeID()?>" <?php  if ($ctID == $ct->getCollectionTypeID()) { ?> selected <?php  } ?>>
      <?php echo $ct->getCollectionTypeName()?>
      </option>
      <?php  } ?>
     </select>
     <?php  } ?>
 
   </div>
 
</div>