Search code examples
mysqlyiiclistview

Yii dataprovider 3 tables

I want this:

SELECT i.inmueble_nombre, a.arrendatario_nombre, a.arrendatario_email, c.contrato_fecha_ini, c.contrato_fecha_fin
FROM zf_inmuebles i, zf_arrendatarios a, zf_contratos c
WHERE c.contrato_estado =  'ALta'
AND i.inmueble_id = c.zf_inmuebles_inmueble_id
AND a.arrendatario_id = c.zf_arrendatarios_arrendatario_id

In a dataprovider for a Clistview, how can I do it?

Solution

  • One simple option is to use a CSqlDataProvider. Basicaly, you just set the query and the count, and the data provider will return an array (with your selected columns as keys) for each list item.