const _dataLabelViviendas: string[] = [ 'CANTIDAD_CONSTRUCCIONES_M2', 'CANTIDAD_HABITACIONES', 'CANTIDAD_SANITARIOS', 'YEAR_2016', 'YEAR_2017', 'YEAR_2018', 'YEAR_2019', 'YEAR_2020', 'YEAR_2021', 'YEAR_2022', 'G2', 'G3', 'G4', 'G5', 'ZONA_01', 'ZONA_02', 'ZONA_03', 'ZONA_04', 'ZONA_05', 'ZONA_06', 'ZONA_07', 'ZONA_08', 'ZONA_09', 'ZONA_10', 'ZONA_11', 'ZONA_12', 'ZONA_13', 'ZONA_14', 'ZONA_15', 'ZONA_16', 'ZONA_17', 'ZONA_18', 'ZONA_19' ];
export const getDataLabelViviendas  = (): string[] => {
	return _dataLabelViviendas;
};
export const parseDataValues        = ( mysqlResult: any ) => {
	return [
		[
			parseFloat( mysqlResult[ 'data-rows' ][ 0 ][ 'cantidad_construcciones_m2' ] ),
			parseFloat( mysqlResult[ 'data-rows' ][ 0 ][ 'cantidad_habitaciones' ] ),
			parseFloat( mysqlResult[ 'data-rows' ][ 0 ][ 'cantidad_sanitarios' ] ),
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2016' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2017' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2018' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2019' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2020' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2021' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2022' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'year_2023' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'g2' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'g3' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'g4' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'g5' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_01' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_02' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_03' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_04' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_05' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_06' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_07' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_08' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_09' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_10' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_11' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_12' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_13' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_14' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_15' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_16' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_17' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_18' ],
			mysqlResult[ 'data-rows' ][ 0 ][ 'zona_19' ],
		],
	];
};
export const parsePostDataValues    = ( requestPostData: any ) => {
	return [
		[
			parseFloat( requestPostData[ 'cantidad_construcciones_m2' ] || 0),
			parseFloat( requestPostData[ 'cantidad_habitaciones' ] || 0 ),
			parseFloat( requestPostData[ 'cantidad_sanitarios' ] || 0),
			(requestPostData['request_year'] === '2016')?1:0,
			(requestPostData['request_year'] === '2017')?1:0,
			(requestPostData['request_year'] === '2018')?1:0,
			(requestPostData['request_year'] === '2019')?1:0,
			(requestPostData['request_year'] === '2020')?1:0,
			(requestPostData['request_year'] === '2021')?1:0,
			(requestPostData['request_year'] === '2022')?1:0,
			(requestPostData['request_year'] === '2023')?1:0,
			(requestPostData['request_pot'] === 'g2')?1:0,
			(requestPostData['request_pot'] === 'g3')?1:0,
			(requestPostData['request_pot'] === 'g4')?1:0,
			(requestPostData['request_pot'] === 'g5')?1:0,
			(requestPostData['request_zona'] === '1')?1:0,
			(requestPostData['request_zona'] === '2')?1:0,
			(requestPostData['request_zona'] === '3')?1:0,
			(requestPostData['request_zona'] === '4')?1:0,
			(requestPostData['request_zona'] === '5')?1:0,
			(requestPostData['request_zona'] === '6')?1:0,
			(requestPostData['request_zona'] === '7')?1:0,
			(requestPostData['request_zona'] === '8')?1:0,
			(requestPostData['request_zona'] === '9')?1:0,
			(requestPostData['request_zona'] === '10')?1:0,
			(requestPostData['request_zona'] === '11')?1:0,
			(requestPostData['request_zona'] === '12')?1:0,
			(requestPostData['request_zona'] === '13')?1:0,
			(requestPostData['request_zona'] === '14')?1:0,
			(requestPostData['request_zona'] === '15')?1:0,
			(requestPostData['request_zona'] === '16')?1:0,
			(requestPostData['request_zona'] === '17')?1:0,
			(requestPostData['request_zona'] === '18')?1:0,
			(requestPostData['request_zona'] === '19')?1:0,
		],
	];
};
export const parseRequestClass = ( resultObject: any, request_pot: any ) => {
	//--- FIX-DATA-FIELDS
	resultObject[ 'data-fields' ].push( 'result_price' );
	delete ( resultObject[ 'data-fields' ][ 4 ] );
	delete ( resultObject[ 'data-fields' ][ 5 ] );
	delete ( resultObject[ 'data-fields' ][ 6 ] );
	delete ( resultObject[ 'data-fields' ][ 7 ] );
	resultObject[ 'data-fields' ] = resultObject[ 'data-fields' ].filter( ( n: string ) => n );
	
	//--- SELECT-RESULT-PRICE
	resultObject[ 'data-rows' ][ 0 ].result_price = resultObject[ 'data-rows' ][ 0 ][ 'g5' ];
	resultObject[ 'data-rows' ][ 0 ].result_price = ( request_pot === 'g4' ) ? resultObject[ 'data-rows' ][ 0 ][ 'g4' ] : resultObject[ 'data-rows' ][ 0 ].result_price;
	resultObject[ 'data-rows' ][ 0 ].result_price = ( request_pot === 'g3' ) ? resultObject[ 'data-rows' ][ 0 ][ 'g3' ] : resultObject[ 'data-rows' ][ 0 ].result_price;
	resultObject[ 'data-rows' ][ 0 ].result_price = ( request_pot === 'g2' ) ? resultObject[ 'data-rows' ][ 0 ][ 'g2' ] : resultObject[ 'data-rows' ][ 0 ].result_price;
	delete ( resultObject[ 'data-rows' ][ 0 ].g5 );
	delete ( resultObject[ 'data-rows' ][ 0 ].g4 );
	delete ( resultObject[ 'data-rows' ][ 0 ].g3 );
	delete ( resultObject[ 'data-rows' ][ 0 ].g2 );
	
	return resultObject;
};