public function insert($hash, $table)
{
try {
$table = $table instanceof \ActiveRecord\Model ? $table::table_name() : $table;
$sql_build = new ActiveRecord\SQLBuilder($this->_conn, $table);
$sql_build->insert($hash);
$values = array_values($hash);
$this->_conn->query($sql_build->to_s(), $values);
} catch (PDOException $e) {
echo "Error: " . $e;
}
}
/**
* The \modules\defaultModule\controllers\disqusController::viewAction()
* @by Zinux Generator <*****@*****.**>
*/
public function viewAction()
{
$disqus_id = @$this->request->indexed_param[0];
$limit = 10;
$offset = (!isset($this->request->params["page"]) ? 0 : $this->request->params["page"] - 1) * $limit;
$ds = new \modules\defaultModule\models\disqus();
$qb = new \ActiveRecord\SQLBuilder($ds->connection(), $ds->table_name());
$qb->select("*")->where("parentid = ? OR disqusid = ?", $disqus_id, $disqus_id)->offset($offset)->limit($limit)->order("created_at desc");
$this->view->current_page = floor($offset / $limit) + 1;
$this->view->total_pages = ceil($ds->count(array('conditions' => 'parentid IS NULL')) / $limit);
$this->view->query = $ds->find_by_sql($qb->to_s(), $qb->bind_values());
$this->view->disqus = \modules\defaultModule\models\disqus::first($disqus_id);
$this->layout->AddTitle($this->view->disqus->title . " | iDisqus");
}
public function get_latest_toptics($offset, $limit, $tag_name = NULL)
{
if ($tag_name) {
}
$ds = new self();
$qb = new \ActiveRecord\SQLBuilder($ds->connection(), $ds->table_name());
$qb->select("disqusid, title, tag_id")->where("parentid IS NULL")->offset($offset)->limit($limit);
if ($tag_name) {
$tag = tag::fetch($tag_name);
if (!$tag) {
return array();
}
$qb->where("parentid IS NULL AND tag_id = ?", $tag->tag_id);
}
// fetch roots
$roots = $ds->find_by_sql($qb->to_s(), $qb->bind_values());
// fetch latest reply
$qb->select("disqusid, title, context, username, tag_id, disquses.updated_at")->joins("INNER JOIN disquses ON disquses.disqusid = disquses.parentid")->joins("INNER JOIN users ON users.userid= disquses.created_by")->limit(1)->order("disquses.created_at desc");
$latest_topics = array();
foreach ($roots as $root) {
$qb->where("parentid = ?", $root->disqusid);
$query = $ds->find_by_sql($qb->to_s(), $qb->bind_values());
// if no sub-topic?
if (!count($query)) {
// consider the root topic!
$qb->where("disqusid = ?", $root->disqusid);
$query = $ds->find_by_sql($qb->to_s(), $qb->bind_values());
}
$topic = array_shift($query);
$topic->readonly();
$topic->title = $root->title;
$topic->tag_id = @$root->tag_id;
$topic->disqusid = $root->disqusid;
$latest_topics[] = $topic;
}
// sort by updated_at desc
usort($latest_topics, function ($a, $b) {
if ($a->updated_at == $b->updated_at) {
return 0;
}
if ($a->updated_at < $b->updated_at) {
return 1;
}
return -1;
});
return $latest_topics;
}
