const _dataLabel: string[] = [ 'CANTIDAD_CONSTRUCCIONES_M2', '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 getDataLabel  = (): string[] => {
	return _dataLabel;
};
export const parseDataValues        = ( mysqlResult: any ) => {
	return [
		[
			parseFloat(mysqlResult[ 'data-rows' ][0][ 'cantidad_construcciones_m2' ]),
			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),
			(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,
		],
	];
};