|
@@ -93,20 +93,20 @@ |
|
|
block discarded – undo |
|
93
|
93
|
protected function getSQLFrom(): string |
|
94
|
94
|
{ |
|
95
|
95
|
return static::MAIN_TABLE |
|
96
|
|
- . ' LEFT JOIN ' . static::LINES_TABLE . ' ON (' |
|
97
|
|
- . static::MAIN_TABLE . '.idfactura = ' . static::LINES_TABLE . '.idfactura)' |
|
|
96
|
+ . ' LEFT JOIN '.static::LINES_TABLE.' ON (' |
|
|
97
|
+ . static::MAIN_TABLE.'.idfactura = '.static::LINES_TABLE.'.idfactura)' |
|
98
|
98
|
// . ' LEFT JOIN '. static::SECONDARY_TABLE . ' ON (' |
|
99
|
99
|
// . static::MAIN_TABLE . '.idfacturarect = ' . static::SECONDARY_TABLE_ALIAS . '.idfactura)' |
|
100
|
|
- . ' LEFT JOIN '. static::ALMACENES_TABLE . ' ON (' |
|
101
|
|
- . static::MAIN_TABLE . '.codalmacen = ' . static::ALMACENES_TABLE . '.codalmacen)' |
|
102
|
|
- . ' LEFT JOIN '. static::NCFTIPO_TABLE . ' ON (' |
|
103
|
|
- . static::MAIN_TABLE . '.tipocomprobante = ' . static::NCFTIPO_TABLE . '.tipocomprobante)' |
|
104
|
|
- . ' LEFT JOIN ' . static::NCFTIPOPAGO_TABLE . ' ON (' |
|
105
|
|
- . static::MAIN_TABLE . '.ncftipopago = ' . static::NCFTIPOPAGO_TABLE . '.codigo)' |
|
106
|
|
- . ' LEFT JOIN ' . static::NCFTIPOMOV_TABLE . ' ON (' |
|
107
|
|
- . static::MAIN_TABLE . '.ncftipomovimiento = ' . static::NCFTIPOMOV_TABLE . '.codigo)' |
|
108
|
|
- . ' LEFT JOIN ' . static::NCFTIPOANUL_TABLE . ' ON (' |
|
109
|
|
- . static::MAIN_TABLE . '.ncftipoanulacion = ' . static::NCFTIPOANUL_TABLE . '.codigo)'; |
|
|
100
|
+ . ' LEFT JOIN '.static::ALMACENES_TABLE.' ON (' |
|
|
101
|
+ . static::MAIN_TABLE.'.codalmacen = '.static::ALMACENES_TABLE.'.codalmacen)' |
|
|
102
|
+ . ' LEFT JOIN '.static::NCFTIPO_TABLE.' ON (' |
|
|
103
|
+ . static::MAIN_TABLE.'.tipocomprobante = '.static::NCFTIPO_TABLE.'.tipocomprobante)' |
|
|
104
|
+ . ' LEFT JOIN '.static::NCFTIPOPAGO_TABLE.' ON (' |
|
|
105
|
+ . static::MAIN_TABLE.'.ncftipopago = '.static::NCFTIPOPAGO_TABLE.'.codigo)' |
|
|
106
|
+ . ' LEFT JOIN '.static::NCFTIPOMOV_TABLE.' ON (' |
|
|
107
|
+ . static::MAIN_TABLE.'.ncftipomovimiento = '.static::NCFTIPOMOV_TABLE.'.codigo)' |
|
|
108
|
+ . ' LEFT JOIN '.static::NCFTIPOANUL_TABLE.' ON (' |
|
|
109
|
+ . static::MAIN_TABLE.'.ncftipoanulacion = '.static::NCFTIPOANUL_TABLE.'.codigo)'; |
|
110
|
110
|
} |
|
111
|
111
|
|
|
112
|
112
|
/** |
joenilson /
fsRepublicaDominicana
