$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 ";