Like unlike system

Question

Like unlike system

Stefjoe Apr '18

Created Apr '18	Last Reply Apr '18	Replies 3	Views 326	Votes 0

Stefjoe 59.9k

Apr '18

Hello,

i am working on a like / unlike system and i have problems in Volt.

i can delete and insert data in controler, but when i want to display the data, i get it multiple times or if the data are empty i get nothing.

So, If loggedUserId == likes.clickedId i want to display , but it displays .

If loggedUserId == likes.clickedId is empty I want to display , but it displays nothing.

{% for likes in user.likes %}

                                        {% if loggedUserId == likes.clickedId %}

                                        {{ tag_html("a", ["href":"likes?usersId=" ~ user.id ~ "&unlike=unlike", "role":"tooltip", "data-toggle":"tooltip","data-placement":"top", "title":"Like me","class": "email-ic unlike"]) }}
                                        <i class="fa fa-heart-o" aria-hidden="true"></i>
                                        <span style="font-size: 10px">
                                                {% for sumLikes in totalLikes %}
                                                    {% if user.id ==  sumLikes.usersId %}
                                                        {{ sumLikes.totalLikesDB }}
                                                    {% endif %}
                                                {% endfor %}
                                            </span>
                                        {{ tag_html_close("a") }}

                                        {% else %}

                                        {{ tag_html("a", ["href":"likes?usersId=" ~ user.id ~ "&like=like", "role":"tooltip", "data-toggle":"tooltip","data-placement":"top", "title":"Like me","class": "email-ic unlike"]) }}
                                        <i class="fa fa-heart" aria-hidden="true"></i>
                                        <span style="font-size: 10px">
                                                {% for sumLikes in totalLikes %}
                                                    {% if user.id ==  sumLikes.usersId %}
                                                        {{ sumLikes.totalLikesDB }}
                                                    {% endif %}
                                                {% endfor %}
                                            </span>
                                        {{ tag_html_close("a") }}

                                        {% endif %}

                                    {% endfor %}

Best wishes and thank you in advance

Stefjoe
59.9k

Accepted
answer

Apr '18

Ok,i found a way, maybe not the best but it works.

I set a start value for example usersId = 68, clickedId = 0, likeClicks = 0, so now the "for loop" will always run.

In Volt i have an if-else statement which checks if the values are 0 or 1, if 0 the like heart is unfilled and if 1 the like heart is red :-)

hope it helps

Nikolay Mihaylov · Answer 1 · 2018-04-22T11:00:21-07:00

What you mean it displays nothing? There is if/else statement - it always will display something :)

Perhaps there is an error somewhere. Have you dumped user.likes, loggedUserId, likes.clickedId do they have the correct information?

Stefjoe · Answer 2 · 2018-04-22T11:40:55-07:00

Hello Nikolay,

thank you for your answer. Yes i dumped them and they are correct. The problem is, when the data is empty, so when there is no like from logged user, if i have start value it is working.

In my db i have the usersId of the user who get the like and the cickedId who clicked the like

So {% if loggedUserId == likes.clickedId %} -> it is correct, BUT if in db is no entry the loop is not working.

Rgds Stefan

Emilio Degiovanni · Answer 3 · 2018-04-22T13:03:35-07:00

you have a logic problem, I think you need refactorize that code

itemsToLike all items like
itemsLiked items where user like
itemsCount counter by user

Then rewrite the view

Nikolay Mihaylov · Answer 4 · 2018-04-22T23:12:35-07:00

As @Emilio said, its not a Volt, but a logic problem. user.likes is your relation depending on current user. So yes, if user did not like anyting = no results.

What I would do is select records and make a join to the table where you store the likes with current user id in the join clause. The sql should look something like:

SELECT
    main.field1,
    main.field2,
    main.field3,
    likes.id AS isLikedByCurrentUser
FROM main_table AS main
LEFT JOIN likes_table AS likes ON likes.main_table_id = main.id AND likes.user_id = CURRENT_LOGGED_USER_ID
WHERE ...
LIMIT 10
OFFSET 0

Stefjoe · Answer 5 · 2018-04-23T11:04:06-07:00

Hello Emilio and Nikolay,

i will try that.

In my db i have id, usersId, clickedId, likes ... so my relation is the usersId.

Thx for your help, i will reply.

Stefjoe · Answer 6 · 2018-04-23T12:27:05-07:00

Ok, i think the querybuilder is working, but i still have a problen in Volt.

    $isClicked = $this->modelsManager->createBuilder()
        ->from(["u" => "Vokuro\Models\Users", "l" => "Vokuro\Models\Likes"])
        ->where('l.usersId = u.id ',array('id' => $id))
        ->groupBy("u.id")
        ->getQuery()
        ->execute();

  $this->view->setVar("isClicked", $isClicked);

I get usersId 68 and 172, that is ok, they are stored in db. But what do i have to do in Volt now?

{% for liked in isClicked %}
  {% if user.id == liked.usersId %}
      clicked
  {% else %}
       not clicked
  {% endif %}
{% endfor %}

liked.usersId is empty, isClicked is an object.

Rgds Stefan