Query yii2 mysql

From my point of view the first house that I see wrong is that you are making a query of data type "Revenue" so the answer of your query will be a type of collection of objects type "income", but as you can see in your query you are entering different tables as "person" or even you do SUM operations, if you need to do something like that I do not recommend you use the Model :: find ().

With something appreciated this should be more useful and I think it would be the right way

$query = new Query;
// compose the query
$query->->leftJoin('persona', 'ingreso.idingreso = persona.idpersona')
                ->leftJoin('detalle_ingreso', 'ingreso.idingreso = detalle_ingreso.idingreso')
                ->select('ingreso.idingreso', 'ingreso.fecha_hora', 'persona.nombre', 'ingreso.tipo_comprobante', 'ingreso.serie_comprobante', 'ingreso.num_comprobante', 'ingreso.impuesto', 'ingreso.estado', 'SUM("ingreso.cantidad*precio_cantidad") AS total')
                ->Where(["estado" => 'A'])                                         
                ->orderBy(['ingreso.idingreso' => SORT_DESC])
                ->groupBy(['ingreso.idingreso', 'ingreso.fecha_hora', 'persona.nombre', 'ingreso.tipo_comprobante', 'ingreso.serie_comprobante', 'ingreso.num_comprobante', 'ingreso.impuesto', 'ingreso.estado']);
// build and execute the query
$rows = $query->all();

For the page, I recommend you read the official docummetacion about it, here is a small example

$query = Article::find()->where(['status' => 1]); // puedes substituir esta lina por l o anteriormente explicado 
$countQuery = clone $query;
$pages = new Pagination(['totalCount' => $countQuery->count()]);
$models = $query->offset($pages->offset)
        ->limit($pages->limit)
        ->all();




foreach ($models as $model) {
    // display $model here
}

// display pagination
echo LinkPager::widget([
    'pagination' => $pages,
]);

Paging documentation Yii2: link

The instruction find () - > ... is still missing with the command ...-> all (); or ... - > one ()

Example:

$table = Ingreso::find()
                ->leftJoin('persona', 'ingreso.idingreso = persona.idpersona')
                ->leftJoin('detalle_ingreso', 'ingreso.idingreso = detalle_ingreso.idingreso')
                ->select('ingreso.idingreso', 'ingreso.fecha_hora', 'persona.nombre', 'ingreso.tipo_comprobante', 'ingreso.serie_comprobante', 'ingreso.num_comprobante', 'ingreso.impuesto', 'ingreso.estado', 'SUM("ingreso.cantidad*precio_cantidad") AS total')
                ->Where(["estado" => 'A'])                                         
                ->orderBy(['ingreso.idingreso' => SORT_DESC])
                ->groupBy(['ingreso.idingreso', 'ingreso.fecha_hora', 'persona.nombre', 'ingreso.tipo_comprobante', 'ingreso.serie_comprobante', 'ingreso.num_comprobante', 'ingreso.impuesto', 'ingreso.estado'])
                ->all();