<?php
defined('BASEPATH') or exit('No direct script access allowed');

class Manager_model extends CI_Model
{

	public function new_auto_message($name, $content, $data_ad_message)
	{
		$data = array(
			'name' => $name,
			'content' => $content,
			'author' => 6180319,
			'publish_date' => now()
		);

		if(is_array($data_ad_message))
		{
			$data['type'] = $data_ad_message['message_type'];
			$data['periodicity'] = $data_ad_message['periodicity'];
			$data['instant_publish'] = $data_ad_message['instant_publish'];
		}
		
		$this->db->insert('messages_auto', $data);
	}

	public function get_auto_messages($offset, $limit)
	{
		return $this->db->select('id, type, periodicity, name, views')->order_by('id','desc')->get('messages_auto')->result();
	}

	public function get_message_views()
	{
		$this->db->select('messages_auto_views.id ,messages_auto_views.date, messages_auto_views.user_id, users.nickname, messages_auto_views.date, messages_auto.name');
		$this->db->join('messages_auto', 'messages_auto.id = messages_auto_views.guid');
		$this->db->join('users', 'users.id = messages_auto_views.user_id');
		$this->db->order_by('id','desc');
		$this->db->limit(500);
		return $this->db->get('messages_auto_views')->result();
	}


}