Total Votes of each post

[Jackie Bermudez]

Hi,

I need help with Java in the Jforum. So, I've been trying to get the Total of votes from each post. For that:

In generic_queries.sql I put the following query where I supposed to get the total of votes, I tested in MySQL and I get the result I want:

KarmaModel.getTotalVotes = SELECT post_id, COUNT(post_id) AS totalVotes FROM jforum_karma WHERE post_id = ? 

Then, I want to get this result in post_show_action_buttons.htm with

${post.karma.getTotalVotes()}

.

So, what I did in GenericKarmaDao.java

public KarmaStatus getTotalVotes(final int postId)
	{
		final KarmaStatus karma = new KarmaStatus();

		PreparedStatement pstmt = null;
		ResultSet resultSet = null;
		try {
			pstmt = JForumExecutionContext.getConnection()
					.prepareStatement(SystemGlobals.getSql("KarmaModel.getPostKarma"));
			pstmt.setInt(1, postId);

			resultSet = pstmt.executeQuery();
			if (resultSet.next()) {
				int totalVotes=resultSet.getInt("totalVotes");
				karma.setTotalVotes(totalVotes);
			}

			return karma;
		}
		catch (SQLException e) {
			throw new DatabaseException(e);
		}
		finally {
			DbUtils.close(resultSet, pstmt);
		}
	}

Then in KarmaDao.java

KarmaStatus getTotalVotes(int postId) ;

In

KarmaStatus.java

public KarmaStatus(final KarmaStatus karma)
	{
		if (karma != null) {
			this.id = karma.getId();
			this.karmaPoints = karma.getKarmaPoints();
			this.totalVotes = karma.getTotalVotes();
			
		}
	}
public int getTotalVotes()
	{
		return this.totalVotes;
	}
	
	public void setTotalVotes(final int totalVotes)
	{
		this.totalVotes = totalVotes;
	}

Please, I need your help. I always tried to create a new query and get information that I want to get, but I never succeed on the attempt. Please help me to identify where I'm wrong.

Thank you!!

[Tim Moores]

So what does this code do now, where does that start to deviate from what you want it to do, and where are you stuck making the required changes?

The FreeMarker syntax is wrong, it should be "totalVotes" rather than "getTotalVotes()", similar to the change you needed to make in one of the other questions you asked.

[Jackie Bermudez]

I get "0" if I use ${post.karma.totalVotes}, it doesn't work. I need the total of votes of each post, for that I created a new query, so I want to pull the information that the query is giving me. The code that I put there is new to be able to display the number on the forum.

[Tim Moores]

So you need to investigate where it starts to go wrong. For example, is the if condition in line 13 ever true? If yes, is the value it retrieves correct? If the answers are both "yes", is the KarmaStatus object being used in the template the same one where you set the value?

[Jackie Bermudez]

Got it working. That wasn't the problem, I didn't have to do anything on KarmaStatus(final KarmaStatus karma).

Classes that I used and steps:
generic_queries.sql (Create the query)
GenericKarmaDAO (Execute the query)
KarmaStatus.java (set and get)
KarmaDAO (get the post id)
Post.java (constructor)
GenericPostDAO.java (set the total of votes)