<?

session_start();

define ('IN_SITE', 1);

include_once ('includes/global.php');
include_once ('includes/class_formchecker.php');
include_once ('includes/class_custom_field.php');
include_once ('includes/class_user.php');
include_once ('includes/class_fees.php');
include_once ('includes/class_item.php');
include_once ('includes/class_reputation.php');

require ('global_header.php');

if (!empty($_REQUEST['user_id'])) {
    $tempname =   $db->get_sql_field("SELECT username  FROM " . DB_PREFIX . "users WHERE user_id =" . intval($_REQUEST['user_id']) . "", 'username');
    header('HTTP/1.1 301 Moved Permanently'); 
    header('Location: ' . ' http://' . $_SERVER['HTTP_HOST'] . '/rate/' . $tempname . '.html');
}

if (!empty($_REQUEST['username'])) {
    $store_name = $db->rem_special_chars($_REQUEST['username']);
    $_REQUEST['user_id'] = $db->get_sql_field("SELECT user_id FROM " . DB_PREFIX . "users WHERE username ='" . $store_name . "'", 'user_id');
}
$user_id = intval($_REQUEST['user_id']);
if (!empty($user_id) && empty($_REQUEST['username'])) {
    $_REQUEST['username'] = $db->get_sql_field("SELECT username FROM " . DB_PREFIX . "users WHERE user_id =" . $user_id . "", 'username');
}
$user_name = $_REQUEST['username'];
$auction_id = intval($_REQUEST['auction_id']);
$rep_view = (in_array($_REQUEST['view'], array('all', 'positive', 'neutral', 'negative', 'from_buyers', 'from_sellers', 'left'))) ? $_REQUEST['view'] : 'all';

$limit = 20;
$start=$start==0?0:($start-1)*$limit;

$additional_vars = '&view=' . $rep_view . '&user_id=' . $user_id . '&auction_id=' . $auction_id;

$user_details = $db->get_sql_row("SELECT user_id, username, shop_account_id, shop_categories,
	shop_active, preferred_seller, reg_date, country, state, zip_code, balance, enable_private_reputation FROM
	" . DB_PREFIX . "users WHERE user_id=" . $user_id);

    $timenow = time();  // echo $timenow;
	$month_one = "2592000"; // 86400 * 30 Days
	$month_six = "15552000"; // 86400 * 180 Days
	$month_yer = "31536000"; // 86400 * 365 Days
	$time_one = $timenow - $month_one;
	$time_six = $timenow - $month_six;
	$time_yer = $timenow - $month_yer;
	
if($setts['feedback_style'] == 1)
{
	$pos_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '4' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$pos_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '4' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$pos_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '4' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");
	$neu_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '2' AND reputation_rate <= '3' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$neu_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '2' AND reputation_rate <= '3' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$neu_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '2' AND reputation_rate <= '3' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");
	$neg_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$neg_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$neg_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");
	$pos_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '4'");
	$neu_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate >= '2' AND reputation_rate <= '3'");
	$neg_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1'");
	
	$template->set('pos_life', $pos_life);
	$template->set('neu_life', $neu_life);
	$template->set('neg_life', $neg_life);
	$template->set('pos_one', $pos_one);
	$template->set('pos_six', $pos_six);
	$template->set('pos_yer', $pos_yer);
	$template->set('neu_one', $neu_one);
	$template->set('neu_six', $neu_six);
	$template->set('neu_yer', $neu_yer);
	$template->set('neg_one', $neg_one);
	$template->set('neg_six', $neg_six);
	$template->set('neg_yer', $neg_yer);
}
	if($setts['feedback_style'] == 2)
{
	$star5_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '5' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$star5_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '5' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$star5_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '5' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");
	$star4_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '4' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$star4_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '4' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$star4_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '4' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");
	$star3_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '3' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$star3_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '3' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$star3_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '3' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");
	$star2_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '2' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$star2_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '2' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$star2_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '2' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");	
	$star1_one = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1' AND reg_date >= '".$time_one."' AND reg_date <= '".$timenow."'");
	$star1_six = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1' AND reg_date >= '".$time_six."' AND reg_date <= '".$timenow."'");
	$star1_yer = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1' AND reg_date >= '".$time_yer."' AND reg_date <= '".$timenow."'");	
	$star5_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '5'");
	$star4_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '4'");
	$star3_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '3'");	
	$star2_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '2'");
	$star1_life = $db->count_rows('reputation', "WHERE user_id='" . $user_details['user_id'] . "' AND reputation_rate = '1'");

	$template->set('star5_one', $star5_one);
	$template->set('star5_six', $star5_six);
	$template->set('star5_yer', $star5_yer);
	$template->set('star4_one', $star4_one);
	$template->set('star4_six', $star4_six);
	$template->set('star4_yer', $star4_yer);
	$template->set('star3_one', $star3_one);
	$template->set('star3_six', $star3_six);
	$template->set('star3_yer', $star3_yer);
	$template->set('star2_one', $star2_one);
	$template->set('star2_six', $star2_six);
	$template->set('star2_yer', $star2_yer);
	$template->set('star1_one', $star1_one);
	$template->set('star1_six', $star1_six);
	$template->set('star1_yer', $star1_yer);
	$template->set('star5_life', $star5_life);
	$template->set('star4_life', $star4_life);
	$template->set('star3_life', $star3_life);
	$template->set('star2_life', $star2_life);
	$template->set('star1_life', $star1_life);
}	

if (item::count_contents($user_details))
{
	$reputation = new reputation();
	$reputation->setts = &$setts;

	$template->set('user_reputation_header', header5(MSG_VIEW_REPUTATION));

	//$template->set('db', $db);

	$template->set('user_id', $user_id);
	$template->set('auction_id', $_REQUEST['auction_id']);
	$template->set('user_details', $user_details);

	$tax = new tax();
	$seller_country = $tax->display_countries($user_details['country']);
	$template->set('seller_country', $seller_country);

	$template->set('one_month', 30 * 86400);
	$template->set('six_months', 180 * 86400);
	$template->set('twelve_months', 365 * 86400);

	$total_comments = $db->count_rows('reputation', "WHERE user_id='" . $user_id . "'");
	$template->set('total_comments', $total_comments);

	$reputation_output = $reputation->calc_reputation($user_id);
	$template->set('reputation_rating', $reputation_output['percentage']);

	$template->set('rep_view', $rep_view);

	switch ($rep_view)
	{
		case 'positive':
			$search_pattern = " r.user_id='" . $user_id . "' AND r.reputation_rate>3 ";
			break;
		case 'neutral':
			$search_pattern = " r.user_id='" . $user_id . "' AND r.reputation_rate=3 ";
			break;
		case 'negative':
			$search_pattern = " r.user_id='" . $user_id . "' AND r.reputation_rate<3 ";
			break;
		case 'from_buyers':
			$search_pattern = " r.user_id='" . $user_id . "' AND r.user_id=w.seller_id ";
			break;
		case 'from_sellers':
			$search_pattern = " r.user_id='" . $user_id . "' AND r.user_id=w.buyer_id ";
			break;
		case 'left':
			$search_pattern = " r.from_id='" . $user_id . "' ";
			break;
		default:
			$search_pattern = " w.buyer_id='" . $user_id . "' OR w.seller_id='" . $user_id . "'";
			$single = 1;
	}

	$show_reputation_details = ($setts['enable_private_reputation'] && $user_details['enable_private_reputation']) ? 0 : 1;
	$template->set('show_reputation_details', $show_reputation_details);
	
	if ($show_reputation_details)
	{
	    if(!$single)
		{
		    $sql_select_reputation = $db->query("SELECT r.*, f.username AS from_username, t.username AS to_username, s.username AS seller_username, b.username AS buyer_username FROM " . DB_PREFIX . "reputation r
			    LEFT JOIN " . DB_PREFIX . "winners w ON w.winner_id=r.winner_id 
				LEFT JOIN " . DB_PREFIX . "users s ON s.user_id=w.seller_id 
				LEFT JOIN " . DB_PREFIX . "users b ON b.user_id=w.buyer_id 
				LEFT JOIN " . DB_PREFIX . "users f ON f.user_id=r.from_id
			    LEFT JOIN " . DB_PREFIX . "users t ON t.user_id=r.user_id WHERE
			    " . $search_pattern . " ORDER BY r.reg_date DESC LIMIT " . $start . "," . $limit);
			$total_rep = $db->count_rows('reputation r LEFT JOIN ' . DB_PREFIX . 'winners w ON w.winner_id=r.winner_id', "WHERE " . $search_pattern);	
            				
		}
		else
		{
			$sql_select_reputation = $db->query("SELECT w.winner_id, w.buyer_id, w.seller_id, u.username, f.username AS from_username, t.username AS to_username, r.reputation_rate, r.reputation_content, r.auto_feedback, w.auction_id, w.purchase_date FROM " . DB_PREFIX . "winners w 
                LEFT JOIN " . DB_PREFIX . "users u ON u.user_id=" . $user_id . " 
				LEFT JOIN " . DB_PREFIX . "users f ON f.user_id=w.buyer_id 
				LEFT JOIN " . DB_PREFIX . "users t ON t.user_id=w.seller_id 
				LEFT JOIN " . DB_PREFIX . "reputation r ON r.winner_id=w.winner_id AND r.from_id!=" . $user_id . "
				WHERE " . $search_pattern . " ORDER BY w.winner_id DESC LIMIT " . $start . "," . $limit);
            $total_rep = $db->count_rows('winners w LEFT JOIN ' . DB_PREFIX . 'reputation r ON r.winner_id=w.winner_id AND r.from_id!=' . $user_id . '', "WHERE " . $search_pattern);	
		}
	
		$custom_fld = new custom_field();
		$custom_fld->setts = &$setts;
		
		(string) $rep_details_content = null;
		while ($rep_details = $db->fetch_array($sql_select_reputation))
		{
			if(empty($rep_details['reputation_rate']))
			{
				$rep_details['reputation_content'] = MSG_NOT_RATED_YET;
			}
		
			if($rep_view == 'left')
			{
			    $rep_username = $rep_details['to_username'];
				$rep_user_id = $rep_details['user_id'];
				
				if($rep_details['from_username'] == $rep_details['seller_username'])
				{
					$feedback_type = GMSG_REP_AUCTION_SALE;
				}
				if($rep_details['from_username'] == $rep_details['buyer_username'])
				{
					$feedback_type = GMSG_REP_AUCTION_PURCHASE;
				}
			}
			else if($rep_view == 'from_buyers')
			{
			    $rep_username = $rep_details['from_username'];
				$rep_user_id = $rep_details['from_id'];
				$feedback_type = GMSG_REP_AUCTION_SALE;			
			}
			else if($rep_view == 'from_sellers')
			{
			    $rep_username = $rep_details['from_username'];
				$rep_user_id = $rep_details['from_id'];
				$feedback_type = GMSG_REP_AUCTION_PURCHASE;			
			}
			else
			{
				if($rep_details['username'] == $rep_details['to_username'])
				{
				    $rep_username = $rep_details['from_username'];
					$rep_user_id = $rep_details['buyer_id'];
					$feedback_type = GMSG_REP_AUCTION_SALE;
				}
				if($rep_details['username'] == $rep_details['from_username'])
				{
				    $rep_username = $rep_details['to_username'];
					$rep_user_id = $rep_details['seller_id'];
					$feedback_type = GMSG_REP_AUCTION_PURCHASE;
				}
			}
	
			$background = ($counter++%2) ? 'c1' : 'c2';
			$page_handle = $rep_details;
			
            $media_url = $db->get_sql_field("SELECT media_url FROM " . DB_PREFIX . "auction_media WHERE auction_id='" . $rep_details['auction_id'] . "'", 'media_url');
            $media_url = str_replace('source_img', 'thumb_img', $media_url);
            $auction_image = (!empty($media_url)) ? $media_url : '' . SITE_PATH . 'themes/' . $setts['default_theme'] . '/img/system/noimg.gif';
			$auc_data = $db->get_sql_row("SELECT name, currency, buyout_price FROM " . DB_PREFIX . "auctions WHERE auction_id='".$rep_details['auction_id']."'");
			
			if($rep_details['auto_feedback'])
			{
                switch ($from_feedback)
                {
	                case '1':
                        $rep_details['reputation_content'] = MSG_AUTO_FEEDBACK_CONTENT_FROM_SELLER;
		                break;
	                case '2':
                        $rep_details['reputation_content'] = MSG_AUTO_FEEDBACK_CONTENT_FROM_BUYER;
		                break;
                }				
			}
			
			if($mobile_device)
			{
			    $rep_details_content .= '<tr class="' . $background . '"> '.
	      	        '<td width="17%" align="right" style="border-bottom: 1px solid #CCCCCC;">'. $reputation->rep_rate($rep_details['reputation_rate']) . '</td>'.
                    '<td width="23%" align="center" style="border-bottom: 1px solid #CCCCCC;"><a href="' . process_link('auction_details', array('name' => $auc_data['name'], 'auction_id' => $rep_details['auction_id'])) . '"><img height="150px" width="150px" src="' .$auction_image. '" style="border:1px solid #BBBBBB;"></a></td>'.			
	      	        '<td width="60%" valign="top" align="left" style="height:210px;font-size:32px;border-bottom:1px solid #CCCCCC;line-height:1.3em;padding-top:10px;padding-bottom:10px">'. $rep_details['reputation_content'] . '<BR><a href="' . process_link('auction_details', array('name' => $auc_data['name'], 'auction_id' => $rep_details['auction_id'])) . '"><font color="#666666">'.$db->add_special_chars($auc_data['name']).'</font></a> <font color="red">'.$auc_data['buyout_price'].' '.$auc_data['currency'].'</font><BR>' . $rep_username . '&nbsp;' . user_pics($rep_user_id,true) . '
                    <BR><BR>' . date("M d, Y H:i",$rep_details['purchase_date']) . '<BR><font color="#666666">' . $feedback_type . '</font>
					</td></tr>';	
			}
			else
			{			
			    $rep_details_content .= '<tr class="' . $background . '"> '.
	      	    '<td valign="center" align="center" style="border-bottom: 1px solid #CCCCCC;">'. $reputation->rep_rate($rep_details['reputation_rate']) . '</td>'.
                '<td valign="center" align="center" style="border-bottom: 1px solid #CCCCCC;"><a href="' . process_link('auction_details', array('name' => $auc_data['name'], 'auction_id' => $rep_details['auction_id'])) . '"><img height="60" width="60" src="' .$auction_image. '" style="border:1px solid #BBBBBB;"></a></td>'.			
	      	    '<td valign="top" style="border-bottom: 1px solid #CCCCCC;">'. $rep_details['reputation_content'] . '<BR><a href="' . process_link('auction_details', array('name' => $auc_data['name'], 'auction_id' => $rep_details['auction_id'])) . '"><font color="#666666">'.$db->add_special_chars($auc_data['name']).'</font></a> <font color="red">'.$auc_data['buyout_price'].' '.$auc_data['currency'].'</font><BR>' . $rep_username . '&nbsp;' . user_pics($rep_user_id,true) . 	      	    '<td valign="center" align="center" style="border-bottom: 1px solid #CCCCCC;">'. date("M d, Y H:i",$rep_details['purchase_date']) . '<BR><BR>' . $feedback_type . '</td>'.
		        '</tr>';
		    }
	    }
	
	    $template->set('rep_details_content', $rep_details_content);
        $array=array('from_buyers'=>'/fb','from_sellers'=>'/fs','left'=>'/left','all'=>'');	
		$pagination = paginate($start, $limit, $total_rep, 'user_reputation.php', 'rate/'.$user_name.$array[$_REQUEST['view']]);
		$template->set('pagination', $pagination);
	}

	if($mobile_device)
	{
	    $template_output .= $template->process('user_reputation_mobile.tpl.php');
	}
	else
	{
	    $template_output .= $template->process('user_reputation.tpl.php');
	}
}
else
{
	$template->set('message_header', header5(MSG_VIEW_REPUTATION));
	$template->set('message_content', '<p align="center">' . MSG_USER_DOESNT_EXIST . '</p>');

	$template_output .= $template->process('single_message.tpl.php');
}

include_once ('global_footer.php');

echo $template_output;

?>