How to sort by votes in Elements API

[arifje]

I would like to create a feed with entries sorted by votes, so I would like to know how to translate this example to PHP:

{% set entries = craft.entries.section('media').limit(15) %}
{% do craft.upvote.sort(entries) %}

{% for entry in entries %}
  //	
{% endfor %}

Thanks!

[lindseydiloreto]

The literal translation of {% do craft.upvote.sort(entries) %} is this...

Upvote::$plugin->upvote_query->orderByTally($elements);

https://github.com/doublesecretagency/craft-upvote/blob/v2/src/variables/UpvoteVariable.php#L247

Give that a shot!

[arifje]

Hi, I am still looking for a way to achieve this in Elements API. Your translation didn't help much so sar, I have no clue how to implement it ;-(

This is my endpoint from Elements API, where I retreive the entries. I would like to get te latest entries sorted by votes, so not only sort the latest entries/result, if you know what I mean :-)

'app/entries' => function() {

    // mode
    $mode = \Craft::$app->request->getQueryParam('mode');
   	
	// featured
	if($mode=="featured") {
		$criteria['featured'] = true;
	}
	
	// sort by views
	if($mode=="trending") {
		$criteria['postDate'] = '>=' . date('Y-m-d', strtotime("-15 days"));
	}
						       	
    return [
        
		'serializer' => 'jsonFeed',
		'resourceKey' => 'entries',
        'elementType' => Entry::class,
        'elementsPerPage' => 15,
		'criteria' => $criteria,
        'transformer' => function(Entry $entry) {
            
			// total views
			$views = 0;
			$views = EntryCount::$plugin->entryCount->getCount($entry->id)->count;
			              
            // votes	               
            $score = Upvote::$plugin->upvote_query->tally($entry->id);
            	                
            return $entries = [  
                'timestamp' => $entry->postDate->getTimestamp(),
                'date_published' => $entry->postDate->format('d/m H:i'),
				'date_modified' => $entry->dateUpdated->format('d/m H:i'),           
                'entry_id' => $entry->id,
                'title' => $entry->title,
                'link' => $entry->url,
                'views' => $views,
                
                'votes' => [
                	'up' => 0,
                	'down' => 0,
                	'score' => $score 
                ],                     
                
            ];
          
        },
        'cache' => false,
        'paginate' => true,
		'pretty' => true
    ];
},