DROP TABLE IF EXISTS `github_data`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `github_data` (
  `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `source_id` INT(10) UNSIGNED NOT NULL,
  `github_id` VARCHAR(255) NOT NULL,
  `title` text NOT NULL,
  `content` text,
  `repository` text,
  `link` VARCHAR(255) NOT NULL,
  `published` VARCHAR(45) NOT NULL,
  PRIMARY KEY USING BTREE (`id`),
  UNIQUE KEY `DUPLICATES` USING BTREE (`source_id`, `github_id`),
  FULLTEXT KEY `SEARCH` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

class GithubItem extends SourceItem {
 
  protected $_prefix   = 'github';
 
  protected $_preamble = 'Github activity: ';
 
  public function getContent() { return $this->_data['content']; }
 
  public function getTitle() {
    $title = str_replace(
      $this->_data['repository'],
      '<a href="http://github.com/' . $this->_data['repository'] . '">' . $this->_data['repository'] . '</a>',
      html_entity_decode( strip_tags( $this->_data['title'] ) )
    );
    return $title;
  }
 
  public function getLink() { return $this->_data['link']; }
 
  public function getType() { return SourceItem::LINK_TYPE; }
 
  public function getBackup() {
    $item = array();
    $item['SourceID'] = $this->_data['source_id'];
    $item['Title'] = $this->_data['title'];
    $item['Content'] = $this->_data['content'];
    $item['Repository'] = $this->_data['repository'];
    $item['Link'] = $this->_data['link'];
    $item['Published'] = $this->_data['published'];
    return $item;
  }
 
}

  const IMAGE_TYPE  = 'image';
 
  const AUDIO_TYPE  = 'audio';
 
  const VIDEO_TYPE  = 'video';
 
  const STATUS_TYPE   = 'status';
 
  const BLOG_TYPE   = 'blog';
 
  const LINK_TYPE   = 'link';
 
  const OTHER_TYPE  = 'other';
 
  const STORY_TYPE  = 'story';

<div class="github">
  <div class="title"><?= $this->item->getTitle(); ?></div>
  <div class="content"><?= $this->item->getContent(); ?></div>
</div>

class GithubModel extends SourceModel {
  // What is the table named?
  protected $_name   = 'github_data';
  // What is the plugin directory named?
  protected $_prefix = 'github';
  // What fields are searchable? This is comma delimited, i.e. "content, title"
  protected $_search  = 'content';
  // What is a format string for update tweets?
  protected $_update_tweet = "Did %d things at github.com on my lifestream %s";
  // What is the service name shown on the backend/widgets
  public function getServiceName() {
    return "Github";
  }
  // ?
  public function isStoryElement() {
    return true;
  }
  // What is the URL for the widget links?
  public function getServiceURL() {
    return 'http://github.com/' . $this->getProperty('username');
  }
  // Brief description for the admin interface
  public function getServiceDescription() {
    return "Github is social coding.";
  }
  // What is the name on the account (for the admin interface mostly)
  public function getAccountName() {
    if ($name = $this->getProperty('username')) {
      return $name;
    }
    else {
      return false;
    }
  }
  // What is the title of the account (for the front end)
  public function getTitle() {
    return $this->getServiceName();
  }
  // The initial data import function
  public function importData() {
    $items = $this->updateData();
    $this->setImported( true );
    return $items;
  }

  public function updateData() {
    $url  = 'http://github.com/' . $this->getProperty('username') . '.atom';
 
    $curl = curl_init();
    curl_setopt($curl, CURLOPT_URL, $url);
    curl_setopt($curl, CURLOPT_HEADER, false);
    curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($curl, CURLOPT_USERAGENT,'Storytlr/1.0');
 
    $response = curl_exec($curl);
    $http_code = curl_getinfo($curl, CURLINFO_HTTP_CODE);
    curl_close ($curl);
 
    if ($http_code != 200) {
      throw new Stuffpress_Exception( "Github returned http status $http_code for url: $url", $http_code );
    }
 
    if (!($items = simplexml_load_string($response))) {
      throw new Stuffpress_Exception( "Github did not return any result", 0 );
    }
 
    if ( count( $items->entry ) == 0 ) { return; }
 
    $items = $this->processItems($items->entry);
    $this->markUpdated();
    return $items;
  }

  private function processItems($items) {
    $result = array();
    foreach ($items as $item) {
      $data = array();
      $data['title'] = $item->title;
      $data['repository'] = substr( $item->title, strrpos( $item->title, ' ' ) + 1 );
      $data['published'] = strtotime( $item->published );
      $data['content'] = $item->content;
      $data['link'] = $item->link['href'];
      $data['github_id'] = $item->id;
      $id = $this->addItem( $data, $data['published'], SourceItem::LINK_TYPE, array( $data['repository'] ), false, false, $data['title'] );
      if ($id) $result[] = $id;
    }
    return $result;
  }

  public function addItem($data, $timestamp, $type, $tags=false, $location=false, $hidden=false, $title=false) {
    $data['source_id']   = $this->_source['id'];
    $columns         = array();
    $keys            = array();
    $timestamp       = ($timestamp>=0) ? $timestamp : 0;
 
    foreach($data as $k => $v) {
      unset($data[$k]);
      if (!$v) continue;
      $columns[] = "$k";
      $keys[] = ":$k";
      $data[":$k"] = "$v";
    }
 
    $sql = "INSERT IGNORE INTO {$this->_name} (".implode(',', $columns).") "
       . "VALUES(".implode(',', $keys).")";

  public function getConfigForm($populate=false) {
    $form = new Stuffpress_Form();
 
    // Add the username element
    $element = $form->createElement('text', 'username', array('label' => 'Username', 'decorators' => $form->elementDecorators));
    $element->setRequired(true);
    $form->addElement($element);
 
    // Populate
    if($populate) {
      $values  = $this->getProperties();
      $form->populate($values);
    }
 
    return $form;
  }
 
  public function processConfigForm($form) {
    $values = $form->getValues();
    $update  = false;
 
    if($values['username'] != $this->getProperty('username')) {
      $this->_properties->setProperty('username',   $values['username']);
      $update = true;
    }
 
    return $update;
  }
}