<?php

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of Discussion
 *
 * @author fabi0
 */

namespace Models;

class Discussion {

    private $_query;

    public function __construct() {
        $this->_query = \Models\DB::getInstance();
    }

    public function getDiscussionPerPage($start) {
        $settings = \Models\Settings::getInstance();
        $result = array();
        $query = $this->_query->query("SELECT discussions.discussion_id,discussions.discussion_name,discussions.discussion_last_user,
            discussions.discussion_last_user_time,discussions.discussion_count,users.user_id,users.user_name,categories.category_name,categories.category_id
            FROM discussions
            LEFT JOIN users
            ON users.user_id = discussions.discussion_last_user
            LEFT JOIN categories
            ON categories.category_id = discussions.discussion_category
            ORDER BY discussions.discussion_date DESC
            LIMIT $start," . $settings->get("post_per_page") . ";")->getResult();
        foreach ($query as $value) {
            $result[$value->discussion_id]['discussion_name'] = $value->discussion_name;
            $result[$value->discussion_id]['discussion_last_user'] = $value->discussion_last_user;
            $result[$value->discussion_id]['discussion_last_user_time'] = $value->discussion_last_user_time;
            $result[$value->discussion_id]['discussion_count'] = $value->discussion_count;
            $result[$value->discussion_id]['user_id'] = $value->user_id;
            $result[$value->discussion_id]['user_name'] = $value->user_name;
            $result[$value->discussion_id]['category_name'] = $value->category_name;
            $result[$value->discussion_id]['category_id'] = $value->category_id;
        }
        return $result;
    }


}