<?

/***************************************************************************
*                            Dolphin Smart Community Builder
*                              -----------------
*     begin                : Mon Mar 23 2006
*     copyright            : (C) 2006 BoonEx Group
*     website              : http://www.boonex.com/
* This file is part of Dolphin - Smart Community Builder
*
* Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License. 
* http://creativecommons.org/licenses/by/3.0/
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the Creative Commons Attribution 3.0 License for more details. 
* You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin, 
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/

require_once( 'inc/header.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'design.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'profiles.inc.php' );
require_once( BX_DIRECTORY_PATH_INC . 'utils.inc.php' );

// --------------- page variables and login

$_page['name_index'] = 45;
$_page['css_name'] = 'compose.css';

$logged['member'] = member_auth(0);

$_page['header'] = _t( "_INBOX_H" );
$_page['header_text'] = _t( "_INBOX_H1" );

// this is dynamic page -  send headers to do not cache this page
send_headers_page_changed();

$preview_length = 45;

// --------------- page components

$_ni = $_page['name_index'];

$_page_cont[$_ni]['page_main_code'] = DesignBoxContent( '', PageCompPageMainCode(), $oTemplConfig -> PageInbox_db_num );

// --------------- [END] page components

PageCode();

// --------------- page components functions

/**
 * page code function
 */
function PageCompPageMainCode()
{
	global $site;
	global $message_arr;
	global $preview_length;
	global $date_format;

	$member['ID'] = (int)$_COOKIE['memberID'];
	$member['Password'] = $_COOKIE['memberPassword'];

	$sort_order = $_REQUEST['sort_order'] == 'ASC' ? 'ASC' : "DESC";
	switch ( $_REQUEST['sort_by'] )
	{
		case 'From':
			$sort_by = 'Profiles.NickName';
			break;

		case 'Date':
		default:
			$sort_by = 'Date';
			break;
	}

	ob_start();

if ( $_POST['msg_form_submit'] )
	{
		$sel_str = "";
		while( list( $key, $val ) = each( $_POST ) )
		if ( (int)$key && $val )
		$sel_str .= ",$key";
		$sel_str = substr( $sel_str, 1 );
		$sel_arr = explode( ",", $sel_str );

		while( list( $key, $val ) = each( $sel_arr ) )
		{
		switch( $_POST['msg_form_submit'] )
			{
				case _t( "_Delete" ): $query = "DELETE FROM `Messages`"; break;
				case _t( "_Mark as New" ): $query = "UPDATE `Messages` SET New = '1'"; break;
				case _t( "_Mark as old" ): $query = "UPDATE `Messages` SET New = '0'"; break;
			}
		if ( strlen($query) )
			db_res( "$query WHERE ID = ".((int)$val)." AND Recipient = ".(int)$member['ID'] );
		}
	}

$message = $_GET['message'];

$m_arr = fill_array( db_res( "SELECT
								`Messages`.`ID`,
								`Messages`.`Sender`,
								`Messages`.`Subject`,
								DATE_FORMAT( `Messages`.`Date`, '$date_format' ) AS Date,
								LEFT( `Messages`.`Text`, {$preview_length} ) AS Preview,
								`Messages`.`New`,
								`Profiles`.`NickName`,
								`Profiles`.`RealName`,
								`Profiles`.`Status`,
								`Profiles`.`ID` as pID
							FROM `Messages`
							LEFT JOIN Profiles ON Messages.Sender = Profiles.ID
							WHERE Recipient = ".((int)$member['ID'])." ORDER BY $sort_by $sort_order" ) );


	$m_num = count( $m_arr );

	$mnew_arr = db_arr( "SELECT COUNT(*) FROM `Messages` WHERE `Recipient` = ".((int)$member['ID'])." AND New = '1'" );
	$m_new = $mnew_arr[0];
/*
	if ( $message )
	{
		$msg_text = db_arr( "SELECT `Text` FROM `Messages` WHERE `ID` = ".((int)$message)." AND `Recipient` = ".((int)$member['ID']) );
		$msg_text = process_text_withlinks_output( $msg_text['Text'] );
		db_res( "UPDATE `Messages` SET `New` = '0' WHERE `ID` = ".((int)$message)." AND `Recipient` = ".(int)$member['ID'] );
	}
*/
	$ret = '';
	$ret .= '<div class="inbox_block">';
		$ret .= '<div>';
		if ( $m_arr )
		{
			$ret .= '<form action="' . $_SERVER['PHP_SELF'] . '" method="post" name="msg_form">';
			$ret .= '<table cellspacing="1" cellpadding="1" width="100%" border="0" bgcolor="#CCCCCC">';
				$ret .= '<tr bgcolor="#ffffff">';
					$ret .= '<td colspan="2" rowspan="2" align="center" valign="middle"><img src="' . getTemplateIcon('inbox.gif') . '" alt="" /></td>';
					$ret .= '<td colspan="3" height="35">' . _t( "_Messages in Inbox" ) . ': <b>' . $m_num . '</b> ' . _t( "_total" ) . ', <b>' . $m_new . '</b> ' . _t( "_new" ) . '</td>';
				$ret .= '</tr>';
				$ret .= '<tr bgcolor="#ffffff">';
					$ret .= '<td align="center" height="25">&nbsp;<b>' . _t( "_From" ) . ':</b>&nbsp;</td>';
					$ret .= '<td align="center">&nbsp;<b>' . _t( "_Date" ) . ':</b>&nbsp;</td>';
					$ret .= '<td align="center">&nbsp;<b>' . _t( "_message_subject" ) . ':</b>&nbsp;</td>';
				$ret .= '</tr>';

				$j=0;
				for ( $i = 0; $m_arr[$i]; $i++ )
				{

					if( ( $j % 2) == 0 )
					{
						$color='#FFFFFF';
					}
					else
					{
						$color='#EAF6C6';
					}
//######################################################################
					if ($m_arr[$i]['New'])
					{
						$add_strong = 'style="font-weight:bold;"';
					}
					else
					{
						$add_strong = '';
					}
//######################################################################
					if( strlen( $m_arr[$i]['Subject'] ) == 0 )
					{
						$subject = $m_arr[$i]['Preview'];
						if ( strlen( $m_arr[$i]['Preview'] ) >= $preview_length )
						$subject .= "...";
					}
					else
					{
						$subject = $m_arr[$i]['Subject'];
						if ( strlen( $m_arr[$i]['Subject'] ) >= $preview_length )
						$subject .= "...";
					}
//######################################################################

					$ret .= '<tr class="tr_hover" bgcolor="' . $color . '">';
						$ret .= '<td align="center"><input type="checkbox" name="' . $m_arr[$i]['ID'] . '" /></td>';
						$ret .= '<td align="center" width="24" height="24">';
						$ret .= $m_arr[$i]['New'] ? '<img src="' . getTemplateIcon('not_readed.gif') . '" alt="' . _t("_new") . '" title="' . _t("_New Message") . '" />' : '<img src="' . getTemplateIcon('readed.gif') . '" alt="' . _t("_Readed") . '" title="' . _t("_Readed") . '" />';
						$ret .= '</td>';
						$ret .= '<td align="left" ' . $add_strong . '>&nbsp;<a href="' . getProfileLink($m_arr[$i]['ID']) . '" title="' . _t("_View Profile") . '">' . $m_arr[$i]['NickName'] . '</a>&nbsp;</td>';
						$ret .= '<td align="left" ' . $add_strong . '>&nbsp;' . $m_arr[$i]['Date'] . '&nbsp;</td>';
						$ret .= '<td align="left" ' . $add_strong . '>&nbsp;<a href="messages_inbox.php?message=' . $m_arr[$i]['ID'] . '">';
						$ret .= process_line_output( html2txt( $subject ));
						$ret .= '</a>';
						$ret .= '</td>';
					$ret .= "</tr>\n";

					$j++;
				}

				$ret .= '<tr bgcolor="#ffffff">';
					$ret .= '<td colspan="5">';
						$ret .= '<table cellspacing="3" cellpadding="0" border="0">';
							$ret .= '<tr>';
								$ret .= '<td>' . _t( "_Selected messages" ) . ':&nbsp;</td>';
								$ret .= '<td><input name="msg_form_submit" type="submit" value="' . _t( "_Delete" ) . '" /></td>';
								$ret .= '<td>&nbsp;</td>';
								$ret .= '<td><input name="msg_form_submit" type="submit" value="' . _t( "_Mark as New" ) . '" /></td>';
								$ret .= '<td>&nbsp;</td>';
								$ret .= '<td><input name="msg_form_submit" type="submit" value="' . _t( "_Mark as old" ) . '" /></td>';
							$ret .= '</tr>';
						$ret .= '</table>';
					$ret .= '</td>';
				$ret .= '</tr>';
			$ret .= '</table>';
			$ret .= '</form>';
		}
		else
		{
			$ret .= '<div class="no_result">';
				$ret .= '<div>';
					$ret .= _t( "_No messages in Inbox" );
				$ret .= '</div>';
			$ret .= '</div>';
		}

		$ret .= '</div>';
	$ret .= '</div>';



	return $ret;
}

?>