How to use pagination in complex query

Hello,



Thanks for all helped me to move forward with my project conversion to CI MVC , moving forward step by step with your help.

What I'm missing in my work, I don't know why query not getting page , only table gets it


 

namespace App\Models;
use CodeIgniter\Model;
use CodeIgniter\Database;
use CodeIgniter\Database\RawSql;

class ListModel extends Model
{
public static function  get_list()
{
$db = \Config\Database::connect();

$query = $db->query('SELECT customerName, customercity, customermail, ordertotal,salestotal
FROM onlinecustomers AS c
  INNER JOIN
  orders AS o
  ON c.customerid = o.customerid
  LEFT JOIN
  sales AS s
  ON o.orderId = s.orderId
  WHERE
salestotal > 100
and c.state in ('CA', 'TX')
and c.active = 1
and o.item_no in (1,5,15) ');
$result = $query->getResult();
return $result; 
  }

}
-----------------------
On My Controller


namespace App\Controllers;
class MyList extends BaseController
{

public function __construct() {
        helper('url');
      // Library("pagination");
      //$pager = \Config\Services::pager();
    }

public function index()
    {
        $listModel = new \App\ModelsListModel();
        $myquery= $listModel->get_list;    //just query works, but not accepting paging


            $data = [
              'listings' => $myquery ,                        (not showing anything)
              'pager' => $myquery->pager,               (getting error, I guess query doesn't allow paging)
              'total' => $myquery->countAll(),         (getting error, same not getting count as table)
              'page' => isset($_GET['page']) ? $_GET['page'] : 1,
              'perPage' => 15
        ];
       
        return view('default', $data);

----
and my default view
<?php
foreach($listings as $order):
echo $order['customerName'];
endforeach;

  if ($pager)
      echo  $pagi_path='mylist';
        $pager->setPath($pagi_path);
      echo $pager->links();
        endif
?>

How to use pagination in complex query

Thank you