<?php
/* (C) Websplosion LLC, 2001-2021

IMPORTANT: This is a commercial software product
and any kind of using it must agree to the Websplosion's license agreement.
It can be found at http://www.chameleonsocial.com/license.doc

This notice may not be removed from the source code. */

#$area = "login";
include("../_include/core/administration_start.php");

class CHon extends CHtmlBlock
{
	function action()
	{
		global $g;
		global $g_user;
		$action = get_param('action');
		$id = get_param('id');
		if($action=='delete' && !empty($id)){
			DB::execute("delete from mail_msg where id=".to_sql($id));
			global $p;
			redirect($p."?user_id=".get_param("user_id"));
		}
	}
	function parseBlock(&$html)
	{
	 	global $g;
		global $l;
		global $g_user;
		$user_id = get_param('user_id',0);
		$user_name=DB::result("select name from user where user_id=".to_sql($user_id));
		$html->setvar("user_name", $user_name);
		parent::parseBlock($html);
	}
}


class Cgroups extends CHtmlList
{
	function init()
	{
		parent::init();
		global $g;
		global $g_user;
		$user_id = get_param('user_id');
		$this->m_on_page = 10;
		$this->m_sql_count = "select count(M.id)  from mail_msg as M join mail_folder as F on F.id = M.folder join user as U on U.user_id = M.user_from
		join user as U2 on U2.user_id = M.user_to";
		$this->m_sql = "select M.*,F.name as fname,U.name as u_from, U2.name as u_to  from mail_msg as M join mail_folder as F on F.id = M.folder
		join user as U on U.user_id = M.user_from
		join user as U2 on U2.user_id = M.user_to
		";
		$this->m_sql_where = " M.user_id = ".to_sql($user_id);
		$this->m_sql_order = " date_sent desc  ";
		$this->m_params = "&user_id=".get_param('user_id');
		$this->m_field['id'] = array("id", null);
		$this->m_field['u_from'] = array("u_from", null);
		$this->m_field['u_to'] = array("u_to", null);
		$this->m_field['subject'] = array("subject", null);
		$this->m_field['text'] = array("text", null);
		$this->m_field['date_sent'] = array("date_sent", null);
		$this->m_field['fname'] = array("fname", null);


	}
	function onItem(&$html, $row, $i, $last)
	{
		global $g;
		$user_id = get_param('user_id');
		$html->setvar("id", $row['id']);
		$html->setvar("user_id", $user_id);
		$html->setvar("user_to", $row['u_to']);
		$html->setvar("user_from", $row['u_from']);
		$html->setvar("subject", $row['subject']);
		$html->setvar("text", $row['text']);
		$html->setvar("data", date('d-m-Y h:i:s',$row['date_sent']));
		$html->setvar("folder", $row['fname']);

        if ($i % 2 == 0) {
            $html->setvar("class", 'color');
            $html->setvar("decl", '_l');
            $html->setvar("decr", '_r');
        } else {
            $html->setvar("class", '');
            $html->setvar("decl", '');
            $html->setvar("decr", '');
        }
	}
	function parseBlock(&$html)
	{
		global $g;
		global $g_user;

		$user_id = get_param('user_id');
		$html->setvar("user_id", $user_id);

		parent::parseBlock($html);
	}
}


$page = new CHon("", $g['tmpl']['dir_tmpl_administration'] . "look_message_mail.html");
$header = new CAdminHeader("header", $g['tmpl']['dir_tmpl_administration'] . "_header.html");
$page->add($header);

$group_list = new Cgroups("mail_list", null);
$page->add($group_list);

$footer = new CAdminFooter("footer", $g['tmpl']['dir_tmpl_administration'] . "_footer.html");
$page->add($footer);

$page->add(new CAdminPageMenuUsers());

include("../_include/core/administration_close.php");