|
@@ -92,10 +92,10 @@ |
|
|
block discarded – undo |
|
92
|
92
|
protected function getSQLFrom(): string |
|
93
|
93
|
{ |
|
94
|
94
|
return static::MAIN_TABLE |
|
95
|
|
- . ' LEFT JOIN '. static::SECONDARY_TABLE . ' ON (' |
|
96
|
|
- . static::MAIN_TABLE . '.idfacturarect = ' . static::SECONDARY_TABLE_ALIAS . '.idfactura)' |
|
97
|
|
- . ' LEFT JOIN ' . static::ESTADOSDOC_TABLE . ' ON (' |
|
98
|
|
- . static::MAIN_TABLE . '.idestado = ' . static::ESTADOSDOC_TABLE . '.idestado AND ' |
|
|
95
|
+ . ' LEFT JOIN '.static::SECONDARY_TABLE.' ON (' |
|
|
96
|
+ . static::MAIN_TABLE.'.idfacturarect = '.static::SECONDARY_TABLE_ALIAS.'.idfactura)' |
|
|
97
|
+ . ' LEFT JOIN '.static::ESTADOSDOC_TABLE.' ON (' |
|
|
98
|
+ . static::MAIN_TABLE.'.idestado = '.static::ESTADOSDOC_TABLE.'.idestado AND ' |
|
99
|
99
|
. static::ESTADOSDOC_TABLE.'.nombre != \'Anulada\')'; |
|
100
|
100
|
} |
|
101
|
101
|
|
Please login to merge, or discard this patch.