$totalLoveCount += $loveCount;
}
}
}
$json_data = array();
$json_data["companyName"] = $company_name;
$json_data["userLoveCount"] = $userLoveCount;
$json_data["currentUser"] = $_SESSION['nickname'];
$json_data["totalLoveCount"] = $totalLoveCount;
$json_data["nicknameList"] = $nicknameList;
$json = json_encode($json_data);
echo $json;
} elseif ($type && $type == 'userLoveExchange') {
// Get nickname for the user who's being viewed
$viewPointNickname = $centerNickname;
$viewPointUsername = get_username_for_nick($viewPointNickname, $company_id);
$filters = '';
// No filters at the moment.
// Get list of users that the $viewPointNickname has had interactions with.
$usernameList = get_love_exchange_user_list($viewPointUsername, $company_id, $filters);
$usernameFilter = format_array_as_infilter($usernameList);
$userLoveExchangeQuery = "SELECT usr.nickname as giver,usr1.nickname as receiver,count(lv.id) as count,lv.private\n FROM " . LOVE . " as lv\n INNER JOIN " . USERS . " as usr ON (lv.giver = usr.username)\n INNER JOIN " . USERS . " as usr1 ON (lv.receiver = usr1.username)\n WHERE lv.company_id={$company_id} ";
if ($usernameFilter) {
$userLoveExchangeQuery .= " AND (usr.username in " . $usernameFilter . " AND usr1.username in " . $usernameFilter . ") ";
}
$userLoveExchangeQuery .= $dateRangeFilter;
$userLoveExchangeQuery .= " GROUP BY lv.giver,lv.receiver order by lv.giver, lv.receiver";
$res = mysql_query($userLoveExchangeQuery);
$loveDataArray = array();
$userLoveExchangeTotal = 0;
if ($res && mysql_num_rows($res) > 0) {
if (isset($_GET['cat'])) {
$cat = addslashes($_GET['cat']);
}
if (!$cat) {
$cat = "sent";
}
if (isset($_GET['nickname'])) {
$nickname = addslashes($_GET['nickname']);
}
if (!$nickname) {
$nickname = $_SESSION['nickname'];
}
if ($nickname) {
// For now the company is expected to be same as that of logged in user.
$company_id = $_SESSION['company_id'];
$username = get_username_for_nick($nickname, $company_id);
}
$query = '';
$queryResult = false;
if (!empty($username) && $username && $type && $type == 'details') {
if ($cat == 'sent') {
$sqlFrom = " FROM " . LOVE . " as lv\n\t\t INNER JOIN " . USERS . " as usr ON (lv.receiver = usr.username)\n\t\t WHERE lv.company_id = " . $company_id . " AND lv.giver = '" . $username . "'";
$sqlFrom .= $dateRangeFilter;
$query = "SELECT lv.why, usr.nickname as receiver, lv.private ";
$query .= $sqlFrom;
$link = "type=details&cat={$cat}&nickname=" . urlencode($nickname) . "&" . $dateRangeQueryParameters;
} else {
if ($cat == 'received') {
$sqlFrom = " FROM " . LOVE . " as lv\n\t\t INNER JOIN " . USERS . " as usr ON (lv.giver = usr.username)\n\t\t WHERE lv.company_id = " . $company_id . " AND lv.receiver = '" . $username . "'";
$sqlFrom .= $dateRangeFilter;
$query = "SELECT lv.why, usr.nickname as giver, lv.private, lv.id, lv.favorite ";
