Как сделать уведомление о новом отзыве в админке?

Question

[Martovitskiy]

Использую Opencart 3. Пытаюсь в админке вывести уведомление о новом отзыве. Есть модуль с отзывами admin/controller/catalog/p_review.php:

<?php
class ControllerCatalogPReview extends Controller {
...

            // Reviews
     $this->load->model('catalog/review');

     $review_total = $this->model_catalog_review->getTotalReviews(array('filter_status' => 0));

     $data['review_total'] = $review_total;

     $data['review'] = $this->url->link('catalog/review', 'user_token=' . $this->session->data['user_token'] . '&filter_status=0', true);
...
}

Пытаюсь так:
Вывожу в header.twig

{% if p_review_total >= 1 %}
      <li class="dropdown"><a href="{{ p_review }}"> <i class="fa fa fa-comments-o fa-lg blinking" style="color:green"></i> <span style="font-size: 10px">{{ text_review }}</span> <sub>{{ text_new_review }}: ({{ review_total }})</sub></a></li>
   {% endif %}

В header.php

// Reviews

$this->load->model('catalog/p_review');

$p_reviewtotal = $this->model_catalog_p_review->getTotalReviews(array('status' => 0));

$data['p_reviewtotal'] = $p_reviewtotal;

$data['p_review'] = $this->url->link('catalog/p_review', 'user_token=' . $this->session->data['user_token'] . '&status=0', true);

Что делаю не так?

Answer 1

[Martovitskiy]

Решил проблему так:
header.php

$this->load->model('catalog/p_review');

$p_review_total = $this->model_sale_order->getTotalReviews('');
$data['p_review_total'] = $p_review_total;

$data['review'] = $this->url->link('catalog/p_review', 'user_token=' . $this->session->data['user_token'] . '&status=0', true);

model/p_review.php

public function getTotalReviews($status) {
    $query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "p_review WHERE status = '" . $status . "'");
    return $query->row['total'];
}