/* event listeners are in fieldname5 */ /* if there are too many periods, change max width of article */ function changeWidth(q){ if (q.length >= 15) jQuery('.ast-container').css('max-width','100%'); else if (q.length >= 10) jQuery('.ast-container').css('max-width','1400px'); else if (q.length >= 7) jQuery('.ast-container').css('max-width','1240px'); else jQuery('.ast-container').css('max-width','800px'); if (q.length >= 3) jQuery('.f003 span.uh').css('max-width','100%'); else jQuery('.f003 span.uh').css('max-width','700px'); /* just to return smth */ return true; }; /* getting list of quarters or years to be sent to server */ function listAllPeriods(mainQuarterData, extraParams, group, add){ let showQuarters = []; let mainIndex = 0; if (fieldname6 == 'Quarterly') { showQuarters.push(fieldname9); if (fieldname8 == 'qoq') { for (i = 1; i < fieldname10 + 1 + add; i++) { showQuarters.push(mainQuarterData.allQuarters[i +mainQuarterData.allQuarters.indexOf(fieldname9)]); } } else if (fieldname8 == 'yoy') { for (i = 1; i < fieldname10 + 1 + add; i++) { showQuarters.push(mainQuarterData.allQuarters[i*4 +mainQuarterData.allQuarters.indexOf(fieldname9)]); } } else if (fieldname8 == 'separate') { fieldname11.forEach((element) => showQuarters.push(element)); } else if (fieldname8 == 'average') { if (fieldname11.length > 0) showQuarters.push('Avg'); fieldname11.forEach((element) => extraParams.average.push(element)); } } else { showQuarters.push(fieldname9+'FY'); if (fieldname8 == 'yoy') { mainIndex = mainQuarterData.allYears.indexOf(JSON.stringify(fieldname9)); for (i = 1; i < fieldname10 + 1 + add; i++) { showQuarters.push(mainQuarterData.allYears[i +mainIndex]+'FY'); } } else if (fieldname8 == 'separate') { fieldname11.forEach((element) => showQuarters.push(element+'FY')); } else if (fieldname8 == 'average') { if (fieldname11.length > 0) showQuarters.push('Avg'); fieldname11.forEach((element) => extraParams.average.push(element+'FY')); } } /* removing undefined - could happen for charts */ console.log('64 '+showQuarters); showQuarters = showQuarters.filter(element => element && (typeof element !== 'string' || !element.startsWith("undefined"))); return showQuarters; }; /* function for drawing charts */ function chartPaint(place, obj, periods, dat, chartTitle){ let colors = ['#4d6d9a', '#edb5bf', '#eab740', '#6d9a4d', '#994d4d', '#99ced3', '#5f6366', '#9a4d6d', '#86b3d1', '#bab2b5', '#99994d', '#99734d']; let dataset = []; for (i=0; i tick.value == 0 ? '#000' : '#ccc' } } }, plugins: { title: { display: true, text: chartTitle, font: { size: 16, family: 'Georgia' } }, subtitle: { display: true, text: 'us.finsee.com', align: 'end', font: { size: 14, family: 'Georgia' } }, legend: { labels: { font: { size: 14, family: 'Georgia' } } } } } } ); /* just to return smth */ return true; }; /* replacing chart data with moving averages */ function updateWithAverage(arr, a) { if (arr.length === 0) { return []; } const result = []; for (let i = 0; i < arr.length; i++) { /* don't include first items in new array */ if (i >= a-1){ /* Include the current element */ const endIndex = i + 1; /* Start index for the last 'a' items */ const startIndex = Math.max(0, endIndex - a); const lastAItems = arr.slice(startIndex, endIndex); const average = lastAItems.reduce((sum, num) => sum + num, 0) / lastAItems.length; result.push(PREC(average, 2)); } } return result; }; /* preparing data for charts and sending it to paint charts */ function prepareChartData(q){ if (typeof sessionStorage['chartStructure'] !== 'undefined' && sessionStorage['chartStructure'] !== null) { /* extra parameters to send to server. Important for average */ let extra = { average: [], ttm: false }; /* adding periods if user chose moving average or change */ let yoyAdd = fieldname8 == 'qoq' && fieldname26 == 'yoy'? 3 : 0; let additional = fieldname30 == 0? fieldname28-1 : fieldname28+yoyAdd; let cmp = JSON.parse(sessionStorage['mainCompany']); let c = JSON.parse(sessionStorage['chartStructure']); c.Type = { LineType: fieldname29, Change: fieldname30, ChangeType: fieldname26, Average: fieldname28, /* reverse() is needed to show chart periods from old to recent */ Periods: listAllPeriods(q, extra, fieldname4, additional).reverse(), MainAdjust: cmp.adjust }; /* if user chose to see share in %, send maxRow to server */ if (fieldname18) { let tbl = JSON.parse(sessionStorage['mainTableStructure']); maxRow = { Company: { Country: cmp.country, Ticker: cmp.ticker, Adjust: cmp.adjust, IsDetailed: cmp.detailed, Numbers: cmp.numbers }, Article: { Group: tbl.Group, Table: tbl.Name, Name: 'MAX-ROW', Position: fieldname18 } } } else maxRow = 0; /* check if there are lines to show and check that we don't paint the same chart twice. window.linesCount is better than cookies for the case when user reloads the page: cookies will say that chart is painted, but global var will be absent */ let isSameLinesCount = false; if (typeof window.linesCount !== 'undefined' && window.linesCount !== null && typeof window.maxRow !== 'undefined' && window.maxRow !== null){ if (window.linesCount == c.Lines.length && window.mRow == fieldname18) isSameLinesCount = true; } /* fieldname9 !== 1 is needed to check that periods were loaded, the rest - to escape sending parameters to server twice before everything is loaded, +FY and +Q4 are needed for annual, because fieldname9 doesn't have these endings, showQuarters[0].length is needed when we change from Annual to Quarterly and back */ let qrt = c.Type.Periods.slice().reverse(); if (c.Lines.length > 0 && (!isSameLinesCount || JSON.stringify(c) != sessionStorage['chartStructure']) && fieldname9 !== 1 && ((fieldname8 != 'yoy' && fieldname8 != 'qoq') || (qrt[0].length == 6 && (fieldname9 == qrt[0] || fieldname9+'FY' == qrt[0] || fieldname9+'Q4' == qrt[0]) && (fieldname10 === 0 || qrt.length > 1)) )) { let res = SERVER_SIDE('dataForChart', c.Lines, c.Type.Periods, c.Type.MainAdjust, extra, maxRow); console.log('dataForChart&'+JSON.stringify(c.Lines)+'&'+JSON.stringify(c.Type.Periods)+ '&'+JSON.stringify(c.Type.MainAdjust+'&'+JSON.stringify(extra)+ '&'+JSON.stringify(maxRow))); if (typeof res !== 'undefined' && res !== null) { let serverData = JSON.parse(res); let periods = c.Type.Periods.slice(); /* deleting first elements from periods, so that # of periods equals data length. Needed for Change in charts */ for (n=0; n < additional; n++){ periods.splice(0,1); } /* var to be sent to paint a chart */ let data = []; /* vars to use below to count data */ let midData = []; let rawData = []; let lines = ['']; /* adding maxRow and defining index for it beforehand */ let m = serverData['rows'].length; if (serverData['maxRow'].length > 0) serverData['rows'].push(serverData['maxRow'][0]); for (i=0; i'); /* if data for some periods is missing, add it as false */ let updatedData = {}; for (let period of c.Type.Periods) { if (serverData['rows'][i]['Data'].hasOwnProperty(period)) { updatedData[period] = serverData['rows'][i]['Data'][period]; } else { updatedData[period] = null; } } rawData = Object.values(updatedData); midData.length = 0; data[i] = []; if (fieldname30 == 0) { if (fieldname28 === 1) data[i] = rawData; else data[i] = updateWithAverage(rawData, fieldname28); } else { if (fieldname8 == 'qoq' && fieldname26 == 'yoy') { for (s=4; s data[i].push(PREC(element, 2))); } else { data[i] = updateWithAverage(midData, fieldname28); } } } /* if we have Max row - show share as % of max Row and delete max Row from data */ if (serverData['maxRow'].length > 0) { for (a=0; a

Chart lines:	remove all
'+serverData['rows'][i]['Country'] +':'+serverData['rows'][i]['Ticker']+' '+ serverData['rows'][i]['Name']+ '	remove

'); jQuery('#chart-lines').html(lines.join('')); jQuery('.main_params.chart').show(); jQuery('#painted-chart').show(); /* chart title */ let title = []; if (fieldname30 != 0) { if (fieldname6 == "Quarterly" && fieldname26 == "qoq") title.push("QoQ change"); else title.push("YoY change"); if (fieldname30 == "percentage") title.push(" in percentage"); } if (fieldname28 > 1) { if (fieldname30 != 0) title.push(", "); if (fieldname8 == "qoq") title.push(fieldname28+"Q moving average"); else title.push(fieldname28+"Y moving average"); } chartPaint('first-chart', c, periods, data, title.join('')); /* saving chart structure in cookies */ sessionStorage['chartStructure'] = JSON.stringify(c); /* needed to avoid showing the same chart twice */ window.linesCount = c.Lines.length; window.mRow = fieldname18; } } if (c.Lines.length > 0){ jQuery('#adjustment-info').html('

All periods are adjusted to '+cmp.ticker+ ' fiscal years

'); jQuery('#second-ticker').html('

'+cmp.ticker+'

'); } else { jQuery('#adjustment-info').html(''); jQuery('#second-ticker').html(''); } } /* saving empty chart structure into cookies, needed for event listeners */ else sessionStorage['chartStructure'] = JSON.stringify({Type: {},Lines: []}); /* just to return smth */ return true; }; /* showing details after user clicks on the line */ function detailsLine(obj, rank, len, c){ let p = obj.DetRows[0].Position; /* showing buttons */ let allText = '

'; let focusText = '

'; let childrenText = ''; if (obj['Subtotals'].includes(p) || obj['Totals'].includes(p)) { childrenText = '

'; } let parentsText = ''; if (!obj['Totals'].includes(p) && (rank > 1 || obj['Totals'].length > 0)) { parentsText = '

'; } let chartText = '

'; let row = ''+chartText +' '+allText+' '+focusText+' '+childrenText+' '+parentsText+''; /* hiding active button */ return row.replace(obj.DetRows[0].Type, obj.DetRows[0].Type+' hide'); } /* calculating number of periods between first and last q. ABS is needed if user reverses columns */ function calculatePeriods(q){ if (fieldname8 == 'qoq') { return ABS(parseFloat(q[0].substring(0, 4) - q[q.length-1].substring(0, 4))*4 + parseFloat((q[0].substring(5)) - q[q.length-1].substring(5))); } else return ABS(q[0].substring(0, 4) - q[q.length-1].substring(0, 4)); }; /* deciding which type of % change to show: absolute or cagr */ function cagrType(q){ let a = 'Δ%'; let r = 'CAGR'; /* calculating number of periods between first and last q */ let periods = calculatePeriods(q); if (q[q.length-1] == "Avg") return a; else if (fieldname8 == 'yoy' || fieldname8 == 'qoq') { if (periods === 1 || fieldname8 == 'qoq') return a; else return r; } else if (fieldname6 == "Quarterly") return a; else { let nOne = q[0].substring(0, 4); let nTwo = q[q.length-1].substring(0, 4); if (nOne - nTwo > 1) return r; else return a; } }; /* showing top row of the main table, called by function results, when creating table */ function topTableLine(n, q){ let nTotal = ''; let nRelative = ''; /* calculating number of periods between first and last q */ let periods = calculatePeriods(q); if (n == "Change") t = "Diff"; else if (n == "CAGR") t = cagrType(q); if (q.includes("Avg")) return ''+t+''; else if (fieldname8 == 'yoy') { if (periods === 1) return ''+t+''; else return ''+t+'('+periods+'y)'; } else if (fieldname8 == 'qoq') { if (periods === 1) return ''+t+''; else return ''+t+'('+periods+'q)'; } else if (fieldname6 == "Quarterly") { return ''+t+'
('+q[0].substring(2) +'-'+q[q.length-1].substring(2)+')'; } else { if (periods > 1) return ''+t+'('+periods+'y)'; else return ''+t+''; } }; /* showing results line by line, called by function results, when creating table */ function showLine(el, q, max, structure){ let text = []; text.push(''); else text.push('">'); /* if this is name, we don't add functions */ if (el.Type == 'name') text.push(''+el['Name']+''); else text.push(''+el['Name']+''); /* vars to check if we need to show this line */ let hasData = false; let isHigherField27 = fieldname27 === 0 ? true : false; for (i = 0; i < q.length; i++){ /* if this is name, we show the line anyway */ if (el.Type == 'name') { if (hasData === false) hasData = true; text.push(''); } /* if this is not name, we check if it has any data in at least one quarter */ else { /* do not close td with > to add class positive/negative later */ text.push(''); /* if first and last periods both have values, we add Change or CAGR */ else { let firstNum = structure.Direction == 'recent-old'? el[q[0]] : el[q[q.length-1]]; let lastNum = structure.Direction == 'recent-old'? el[q[q.length-1]] : el[q[0]]; if (fieldname12 == 'percentage') { if (structure.Direction == 'recent-old') { firstNum = el[q[0]]/max[q[0]]*100; lastNum = el[q[q.length-1]]/max[q[q.length-1]]*100; } else { firstNum = el[q[q.length-1]]/max[q[q.length-1]]*100; lastNum = el[q[0]]/max[q[0]]*100; } } if (firstNum >= lastNum) text.push(' positive">'); else text.push(' negative">'); if (q[i] == 'Change') { if (fieldname12 == 'percentage') text.push(PREC((firstNum-lastNum), 1).toLocaleString('uk-ua')+'pp'); else text.push((firstNum-lastNum).toLocaleString('uk-ua')); } /* check if we divide 0 or by 0 */ else if (q[i] == 'CAGR' && firstNum != 0 && lastNum != 0) { /* check which type of growth to show */ let t = cagrType(q); if (t == 'CAGR') { /* calculating number of periods between first and last q */ let periods = calculatePeriods(q); /* if one is positive and other is negative, dont show */ if (firstNum*lastNum < 0) text.push(''); else if(fieldname6 == 'Annual' && fieldname8 == 'separate'){ /* check if (nOne - nTwo > 1) not needed: done when calling cagrType(q) */ text.push(PREC((POW(firstNum/lastNum, 1/periods)-1)*100, 1)+'%'); } else text.push(PREC((POW(firstNum/lastNum, 1/periods)-1)*100, 1)+'%'); } else text.push(PREC((firstNum/lastNum-1)*100, 1)+'%'); } else text.push(''); } } /* usual periods (years, quarters or ttm) */ else { /* show absolute numbers */ if (fieldname12 == 'absolute') { if (typeof el[q[i]] == 'undefined' || el[q[i]] === false || el[q[i]] === 0) text.push('">'); else text.push('">'+el[q[i]].toLocaleString('uk-ua')); } /* show percentages */ else { if (typeof el[q[i]] == 'undefined' || el[q[i]] === false || el[q[i]] === 0) text.push('">'); else text.push('">'+PREC((el[q[i]]/max[q[i]])*100, 1).toLocaleString('uk-ua')+'%'); } } text.push(''); /* check if we need to show this line */ if (typeof el[q[i]] != 'undefined' && el[q[i]] != 0 && el[q[i]] !== false && q[i] != 'Change' && q[i] != 'CAGR') hasData = true; if (typeof el[q[i]] != 'undefined' && fieldname27 !== 0 && ABS(el[q[i]]/max[q[i]]*100) >= fieldname27) isHigherField27 = true; } } if (hasData && isHigherField27) { /* if there is at least 1 line to show, we change boolean */ if (structure.ShowRows.length == 0 || structure.ShowRows.includes(el['Position'])) structure.IsVisible = true; return text.join('')+''; } else return ''; } /* changing fields, based on user input */ function changeFields(mainQuarterData){ /* index of main period */ let mainIndex = 0; let isSelectChangeNeeded = true; let chosenParams = [fieldname6, fieldname8, fieldname9, fieldname10, fieldname11, fieldname12, fieldname14, fieldname18, fieldname27, fieldname30, sessionStorage['mainCompany']]; if (window.chosenParams !== null && typeof window.chosenParams !== "undefined" && window.chosenParams.length > 0) { isSelectChangeNeeded = JSON.stringify(chosenParams) == JSON.stringify(window.chosenParams) ? false : true; } if (isSelectChangeNeeded) { /* hide other table names if user changed select fields */ window.moreTableNames = false; /* showing max number of periods */ function fillNumberOfPeriods(n){ /* check if there are no previous periods */ let num10 = n === 1? [0] : []; let text10 = n === 1? [0] : []; for (i=1; i

'+ main+'

>'); tableNames.push('>'); tableNames.push(''); other.forEach((element) => tableNames.push('')); tableNames.push('

'+element+'

'); } return tableNames; } /* showing list of absent quarters */ function listAbsent(periods, len){ let absentText = []; if (periods.length > 0) { absentText.push('No data for the periods: '); periods.forEach((element) => absentText.push(element + ', ')); /* removing the last comma */ absentText[absentText.length-1] = absentText[absentText.length-1].slice(0, -2); absentText.push(''); } return absentText; } /* checking if we need to send request to the server */ function sendRequest(isSelect, mainCompany, chosenTable, showQuarters, extraParams, group){ let isCalculationNeeded = true; /* checking if parameters are the same */ if (!isSelect && typeof window.serverParams !== 'undefined' && window.serverParams !== null){ let p = window.serverParams; if (p.country == mainCompany.country && p.ticker == mainCompany.ticker && p.group == group && p.chosenTable == chosenTable && JSON.stringify(p.showQuarters) == JSON.stringify(showQuarters) && JSON.stringify(p.extraParams) == JSON.stringify(extraParams)) isCalculationNeeded = false; } /* fieldname9 !== 1 is needed to check that periods were loaded, the rest - to escape sending parameters to server twice before everything is loaded, +FY and +Q4 are needed for annual, because fieldname9 doesn't have these endings, showQuarters[0].length is needed when we change from Annual to Quarterly and back */ if (isCalculationNeeded && fieldname9 !== 1 && ((fieldname8 != 'yoy' && fieldname8 != 'qoq') || (showQuarters[0].length == 6 && (fieldname9 == showQuarters[0] || fieldname9+'FY' == showQuarters[0] || fieldname9+'Q4' == showQuarters[0]) && (fieldname10 === 0 || showQuarters.length > 1)) )) isCalculationNeeded = true; else isCalculationNeeded = false; if (isCalculationNeeded) { console.log('calculation needed'); /* for the rare cases when we didn't obtain company data and user then chose another company */ window.serverParams = ''; /* showing that data is loading */ jQuery('.f003 span').html('

Downloading data...

'); let serverResult = SERVER_SIDE('financials', mainCompany.country, mainCompany.ticker, group, chosenTable, showQuarters, extraParams); if (typeof serverResult !== 'undefined' && serverResult !== null && serverResult.length > 0) { console.log('calculation happened'); let parsed = JSON.parse(serverResult); /* saving params in order not to call server unnecessarily */ window.serverParams = { country: mainCompany.country, ticker: mainCompany.ticker, group: group, chosenTable: parsed['table'][0]['TableName'], showQuarters: showQuarters, extraParams: extraParams }; /* saving params in order not to call server unnecessarily */ sessionStorage['tableName'] = parsed['table'][0]['TableName']; sessionStorage['tableType'] = group; return parsed; } } else return false; }; /* showing main table, called after we receive quarter data */ function results(mainCompany, mainQuarterData, isSelectChangeNeeded){ /* extra parameters to send to server */ let extraParams = { average: [], ttm: false, isDetailed: mainCompany.detailed, numbers: mainCompany.numbers }; /* getting user input */ let group = fieldname4; let chosenTable = ''; /* getting list of quarters or years to be sent to server */ let showQuarters = listAllPeriods(mainQuarterData, extraParams, group, 0); /* check cookies if user chose table Name */ if (sessionStorage['tableName'] !== null && typeof sessionStorage['tableName'] !== "undefined" && sessionStorage['tableName'].length > 0) { /* if user didn't change table type, we take table name from cookies */ if (group == sessionStorage['tableType']) chosenTable = sessionStorage['tableName']; else { sessionStorage['tableType'] = ''; sessionStorage['tableName'] = ''; } } else { sessionStorage['tableType'] = group; sessionStorage['tableName'] = ''; } /* send request to the server */ let parsed = sendRequest(isSelectChangeNeeded, mainCompany, chosenTable, showQuarters, extraParams, group); if (parsed) { /* showing current Table name, button to show other tables and other tables */ let tableNames = listTableNames(parsed['table'][0]['TableName'], parsed['other tables'], group); /* if user chose to see percentages or to see only rows higher than certain % of total */ let maxValues = {}; if (fieldname12 == 'percentage' || fieldname27 !== 0) { /* sorting fields by Rank and Amount in the main period const and ... needed to avoid mutation of original object */ const sortedFields = [...parsed['table'][0]['Data']].sort((a,b) => a.Rank - b.Rank || b[showQuarters[0]] - a[showQuarters[0]]); /* sorting and filtering fields to be shown in fieldname18: possible fields to be divided by */ let shareRowsNames = []; let shareRowsPos = []; for (i=0; i < sortedFields.length; i++){ if (sortedFields[i].Type != 'name' && sortedFields[i][showQuarters[0]] != 0) { shareRowsNames.push(sortedFields[i].Name); shareRowsPos.push(sortedFields[i].Position); } } getField(18).setChoices( {texts: shareRowsNames, values: shareRowsPos}); /* filling object maxValues with max values by the field, chosen by user in fieldname18 */ let maxRow = {}; for (i=0; i < sortedFields.length; i++){ if (sortedFields[i].Position == fieldname18) maxRow = sortedFields[i]; } showQuarters.forEach((element) => maxValues[element] = maxRow[element]); } /* list of period names to show in the table */ let rKeys = Object.keys(parsed['table'][0]['Data'][0]); /* leaving only periods, for which there are data */ let tableQuarters = fieldname8 == 'average' ? showQuarters : parsed['included periods']; /* filtering out all periods, for which there are no data */ let absentText = listAbsent(parsed['absent periods'], tableQuarters.length+1); /* if there are any periods to show */ if (parsed['included periods'].length > 0) { let result = []; result.push(tableNames.join('') + '' + absentText.join('')); if (fieldname14.includes('percentage') && tableQuarters.length > 1) tableQuarters.splice(1, 0, "CAGR"); if (fieldname14.includes('absolute') && tableQuarters.length > 1) tableQuarters.splice(1, 0, "Change"); /* saving table structure into cookies to use in event listeners */ let rows = []; let mainTableStructure = { Name: parsed['table'][0]['TableName'], Group: group, Rank1: [], Rank2: [], Rank3: [], Rank4: [], Rank5: [], Subtotals: [], Totals: [], DetRows: [], ShowRows: [], Direction: 'recent-old', IsVisible: false }; /* checking if need to reverse columns or show detailed row */ let detailedRow = { P: -2, Text: '', Type: '' }; if (typeof sessionStorage['mainTableStructure'] !== 'undefined' && sessionStorage['mainTableStructure'] !== null) { let cookiesTable = JSON.parse(sessionStorage['mainTableStructure']); mainTableStructure.Direction = cookiesTable.Direction; if (mainTableStructure.Direction == 'old-recent') tableQuarters.reverse(); /* show detailed row */ if (cookiesTable.DetRows.length > 0 && cookiesTable.Name == parsed['table'][0]['TableName'] && cookiesTable.Group == group) { let currentLine = parsed['table'][0]['Data'].filter(function (el) { return el.Position == cookiesTable.DetRows[0].Position; }); let currentRank = currentLine[0].Rank; detailedRow.Text = detailsLine( cookiesTable, currentRank, tableQuarters.length+1, mainCompany); detailedRow.Type = cookiesTable.DetRows[0].Type; detailedRow.P = cookiesTable.DetRows[0].Position; mainTableStructure.DetRows.push({ Position: cookiesTable.DetRows[0].Position, Type: cookiesTable.DetRows[0].Type, Name: cookiesTable.DetRows[0].Name }); } /* list of active rows */ if (cookiesTable.ShowRows.length > 0 && cookiesTable.Name == parsed['table'][0]['TableName'] && cookiesTable.Group == group) { mainTableStructure.ShowRows = cookiesTable.ShowRows; } } /* showing quarters on top line, first cell is icon to reverse columns */ let topline = []; topline.push(''); for (i = 0; i < tableQuarters.length; i++){ /* deleting first 2 numbers of year for quarters or FY for years */ if (tableQuarters[i] == "Avg") { if (fieldname6 == "Quarterly") topline.push(''); else topline.push(''); } else if (tableQuarters[i] == "Change" || tableQuarters[i] == "CAGR") { topline.push(topTableLine(tableQuarters[i], tableQuarters)); } else if (fieldname6 == "Quarterly") topline.push(''); else topline.push(''); } result.push(topline.join('')+''); for (s = 0; s < parsed['table'][0]['Data'].length; s++){ /* showing each row */ rows.push(showLine(parsed['table'][0]['Data'][s], tableQuarters, maxValues, mainTableStructure)); if (detailedRow.Type.length > 0 && rows[rows.length-1].length > 0 && parsed['table'][0]['Data'][s].Position == detailedRow.P) { /* adding detailed buttons, check if row is not empty. If parent button is active - add before current line, else - after */ if (detailedRow.Type == 'parentRows') rows.splice(rows.length-1, 0, detailedRow.Text); else rows.push(detailedRow.Text); } /* forming table structure. Don't check if row is empty: it could be needed in structure if periods change and it becomes not empty */ rnk = 'Rank'+parsed['table'][0]['Data'][s]['Rank']; /* s+1 is needed because we count rows from 1 */ mainTableStructure[rnk].push(s+1); if (parsed['table'][0]['Data'][s]['Total'] == 'subtotal') mainTableStructure['Subtotals'].push(s+1); else if (parsed['table'][0]['Data'][s]['Total'] == 'total') mainTableStructure['Totals'].push(s+1); } /* check if we have at least one row to show. Needed if user chose to see part of the table and then changed some parameters. */ if (mainTableStructure.IsVisible == true) { result.push(rows.join('')); } else { result.push(''); result.push(rows.join('').replaceAll(' hide', '')); } sessionStorage['mainTableStructure'] = JSON.stringify(mainTableStructure); /* doubling top line in the bottom of the table if it's large */ if (parsed['table'][0]['Data'].length > 8) result.push(topline.join('')+''); result.push('

	'+tableQuarters[i]+'(' +(parsed['included periods'].length-1)+'q)	'+tableQuarters[i]+'(' +(parsed['included periods'].length-1)+'y)	'+tableQuarters[i].substring(2)+'	'+tableQuarters[i].substring(0, 4)+'
No data for chosen periods. Showing all rows

Click on article name (i.e. "Net income") to see additional options or to add it to chart

'); /* check that fieldname18 is calculated (maxValues) before showing results. Otherwise result is showed twice: first time for 0.1 second, when you change group and field18 > 0 */ if ((fieldname12 != 'percentage' && fieldname27 == 0) || (maxValues[showQuarters[0]] !== undefined && maxValues[showQuarters[0]] != false) ) jQuery('.f003 span').html(result.join('')); } /* if there are no periods to show */ else { jQuery('.f003 span').html(tableNames.join('')+ '

Please choose other periods ...

This table doesn\'t have data for these periods

'); } /* change max width of article, according to the number of periods */ changeWidth(tableQuarters); } /* just to return smth */ return true; }; function getQuarters(){ /* run this function only if ticker is already chosen */ if (sessionStorage['mainCompany'] !== null && typeof sessionStorage['mainCompany'] !== "undefined" && sessionStorage['mainCompany'].length > 0) { let mainCompany = JSON.parse(sessionStorage['mainCompany']); /* getting quarter data */ let mainQuarterData = false; if (sessionStorage['mainQuarterData'] !== null && typeof sessionStorage['mainQuarterData'] !== "undefined" && sessionStorage['mainQuarterData'].length > 0) { mainQuarterData = JSON.parse(sessionStorage['mainQuarterData']); } /* if we don't have company quarter data, request it from server */ if (!mainQuarterData) { let quarterQuery = SERVER_SIDE('getQuartersFinancials', mainCompany.detailed, mainCompany.country, mainCompany.ticker); if (typeof quarterQuery !== 'undefined' && quarterQuery !== null && quarterQuery.length > 0) { mainQuarterData = JSON.parse(quarterQuery); sessionStorage['mainQuarterData'] = quarterQuery; /* if detailed company - get data from cookies, otherwise - from server response. marketCap - always from server response */ if (mainCompany.detailed === false) { mainCompany.yearEnds = mainQuarterData['reportDate']; mainCompany.numbers = mainQuarterData['rounding'].length > 0 ? mainQuarterData['rounding'] : ''; mainCompany.adjust = mainQuarterData['adjust']; mainCompany.currency = mainQuarterData['currency']; } mainCompany.marketCap = mainQuarterData['marketCap']; let companyInfo = '

'+mainCompany.name+'

' +mainCompany.country+':'+mainCompany.ticker+ '

Market Cap	Year ends	Currency
' +mainCompany.marketCap+'	'+mainCompany.yearEnds+'	'+mainCompany.numbers +' '+mainCompany.currency+'

'; sessionStorage['companyInfo'] = JSON.stringify(companyInfo); sessionStorage['mainCompany'] = JSON.stringify(mainCompany); } /* showing info that we wait for company data */ else { jQuery('.f001 span').html('

Downloading company data...

please wait a few seconds

'); } } /* preloading icons */ function preloadImage(urls){ urls.forEach((element) => new Image().src = element); } preloadImage([ 'https://us.finsee.com/wp-content/uploads/All-rows.png', 'https://us.finsee.com/wp-content/uploads/Focus.png', 'https://us.finsee.com/wp-content/uploads/Children.png', 'https://us.finsee.com/wp-content/uploads/Parents.png', 'https://us.finsee.com/wp-content/uploads/Add-to-chart.png' ]); if (mainQuarterData) { /* changing select fields based on user input */ let isSelectChangeNeeded = changeFields(mainQuarterData); /* call next function after finishing */ results(mainCompany, mainQuarterData, isSelectChangeNeeded); /* painting chart */ prepareChartData(mainQuarterData); } } /* just to return smth */ return true; }; function searchQuery(){ /* needed during testing phase, so we dont show external data */ let code = ''; if (typeof sessionStorage['code'] !== 'undefined' && sessionStorage['code'] !== null && sessionStorage['code'].length > 0) { code = sessionStorage['code']; } else { jQuery('.f031').show(); code = fieldname31; } let query = fieldname1; if (query != '' && code != '') { jQuery('.f001 span').html('Getting results...'); if (typeof window.serverParams !== 'undefined' && window.serverParams !== null && window.serverParams.length > 0){ window.serverParams.country = ''; window.serverParams.ticker = ''; } /* hide other table names if user changed select fields */ window.moreTableNames = false; let serverResult = SERVER_SIDE('getInfoFinancials', query, code); /* if we recieved response from server */ if (typeof serverResult !== 'undefined' && serverResult !== null && serverResult.length > 0) { /* parsing response */ let parsed = JSON.parse(serverResult); let companyData = []; if (parsed['company']['exact'].length == 0 && parsed['company']['partial'].length == 0 && parsed['company']['additional'].length == 0) { jQuery('.f001 span').html('no results'); } /* if there are companies, we create table with their list */ else { /* needed during testing phase, so we dont show external data */ sessionStorage['code'] = code; jQuery('.f031').hide(); let functVars = ''; let companyInfo = []; companyInfo.push(''); /* highliting user input text in results in bold font type */ function showBold(t, up){ let s = fieldname1; for (let i = 0; i < s.length; i++) { t = t.replace(s[i], "" + s[i] + ""); /* if it's ticker, we transform query to upper case */ if (up == "tick") { s = s.toUpperCase(); t = t.replace(s, "" + s + ""); } else { let firstUpper = s[i].charAt(0).toUpperCase() + s[i].substring(1); t = t.replace(firstUpper, "" + firstUpper + ""); t = t.replace(s[i].toUpperCase(), "" + s[i].toUpperCase() + ""); } return t; } }; function showCompany(el, isDetailed){ if (isDetailed){ let numb = ''; if (el["Numbers"] == '0') numb = ''; else if (el["Numbers"] == '3') numb = 'thousands'; else if (el["Numbers"] == '6') numb = 'millions'; else if (el["Numbers"] == '9') numb = 'billions'; else numb = el["Numbers"]; functVars = "true, '"+el["CompanyName"]+"', '"+el["Country"]+"', '" +el["Ticker"]+"', '"+el["YearEnds"]+"', '" +numb+"', '"+el["Currency"]+"', '"+el["AdjustMonths"]+"'"; return ''; } else if (el["exchangeShortName"] == "NYSE" || el["exchangeShortName"] == "NASDAQ" || el["exchangeShortName"] == "PNK") { /* removing single quotes, otherwise companies like DPZ are not clickable */ let name = el["name"].replaceAll("'", ""); functVars = "false, '"+name+"', 'US', '" +el["symbol"]+"', false, false, '"+el["currency"]+"', false"; return ''; } else return ''; } if (parsed['company']['exact'].length > 0 || parsed['company']['partial'].length > 0){ companyInfo.push(''); } parsed['company']['exact'].forEach((element) => companyInfo.push(showCompany(element, true))); parsed['company']['partial'].forEach((element) => companyInfo.push(showCompany(element, true))); if (parsed['company']['additional'].length > 0){ companyInfo.push(''); } parsed['company']['additional'].forEach((element) => companyInfo.push(showCompany(element, false))); companyInfo.push('

'+showBold(el["Ticker"], "tick")+ '	'+showBold(el["CompanyName"], "name")+'
'+showBold(el["symbol"], "tick")+ '	'+showBold(name, "name")+'	'+ el["exchangeShortName"]+'
Detailed data:
Basic data:

'); jQuery('.f001 span').html(companyInfo.join('')); } /* call next function after finishing */ getQuarters(); } } /* call next function after finishing */ else getQuarters(); /* just to return smth */ return true; }; jQuery( document ).ready(function() { /* we call searchQuery which calls getQuarters, which calls results */ searchQuery(); /* just to return smth */ return true; });