Paragraph
\n"; report.addStructuredText(htmlText, "html"); report.addParagraph("--- Full html example ---", "example"); htmlText = "\n"; htmlText += "\n"; htmlText += "\n"; htmlText += "\n"; htmlText += "\n"; htmlText += "Paragraph
\n"; htmlText += "\n"; htmlText += "\n"; report.addStructuredText(htmlText, "html", stylesheet); report.addParagraph("--- Plain html example ---", "example"); let plainText = "Testo riga 1\n"; plainText += "Testo riga 2\n"; plainText += "Testo riga 3\n"; report.addStructuredText(plainText, "text"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 210 Description: Create a table with one row */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialtableonerow // @description = Tutorial: Create a table with one row // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table var table = report.addTable('myTable'); //Add a row tableRow = table.addRow(); tableRow.addCell('Cash'); tableRow.addCell('1200'); //Create style var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 211 Description: Create a table with multiple rows */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialtablemultiplerows // @description = Tutorial: Create a table with multiple rows // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table var table = report.addTable('myTable'); //Add row 1 tableRow = table.addRow(); tableRow.addCell('Cash'); tableRow.addCell('1200'); //Add row 2 tableRow = table.addRow(); tableRow.addCell('Bank 1'); tableRow.addCell('500'); //Add row 3 tableRow = table.addRow(); tableRow.addCell('Bank 2'); tableRow.addCell('2600'); //Print report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 212 Description: Create a table with multiple rows and a header */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialtablewithheader // @description = Tutorial: Create a table with multiple rows and header // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table var table = report.addTable('myTable'); //Create table header var tableHeader = table.getHeader(); //Add the header of the table tableRow = tableHeader.addRow(); tableRow.addCell('Description'); tableRow.addCell('Amount'); //Add row 1 tableRow = table.addRow(); tableRow.addCell('Cash'); tableRow.addCell('1200'); //Add row 2 tableRow = table.addRow(); tableRow.addCell('Bank 1'); tableRow.addCell('500'); //Add row 3 tableRow = table.addRow(); tableRow.addCell('Bank 2'); tableRow.addCell('2600'); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 213 Description: Create a table with multiple rows, header and borders */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialtablewithheaderandborders // @description = Tutorial: Create a table with multiple rows, header and borders // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table var table = report.addTable('myTable'); //Create table header var tableHeader = table.getHeader(); //Add the header of the table tableRow = tableHeader.addRow(); tableRow.addCell('Description'); tableRow.addCell('Amount'); //Add row 1 tableRow = table.addRow(); tableRow.addCell('Cash'); tableRow.addCell('1200'); //Add row 2 tableRow = table.addRow(); tableRow.addCell('Bank 1'); tableRow.addCell('500'); //Add row 3 tableRow = table.addRow(); tableRow.addCell('Bank 2'); tableRow.addCell('2600'); //Stylesheet var stylesheet = Banana.Report.newStyleSheet(); //Create style for the table adding borders var style = stylesheet.addStyle("table"); stylesheet.addStyle("table.myTable td", "border: thin solid black"); //Print report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 214 Description: Create a table with fixed columns widths */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialtablecolumnswidth // @description = Tutorial: Create a table with fixed columns width // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { var report = Banana.Report.newReport("Javascrip Tutorial - Table with fixed column widths"); /* Create the table */ var table = report.addTable("table"); /* Add columns */ var column1 = table.addColumn("col1"); var column2 = table.addColumn("col2"); var column3 = table.addColumn("col3"); var column4 = table.addColumn("col4"); var row; /* Add a row with cells */ row = table.addRow(); //Add a row row.addCell("A", "", 1); //add first cell row.addCell("B", "", 1); //add second cell row.addCell("C", "", 1); //add third cell row.addCell("D", "", 1); //add fourth cell //Add more rows... /* Print the report */ var stylesheet = createStyleSheet(); Banana.Report.preview(report, stylesheet); } function createStyleSheet() { var stylesheet = Banana.Report.newStyleSheet(); var style = stylesheet.addStyle(".table"); style.setAttribute("width","100%"); //table takes all the page width stylesheet.addStyle("table.table td", "border: thin solid black"); /* Set column widths */ stylesheet.addStyle(".col1", "width:10%"); stylesheet.addStyle(".col2", "width:55%"); stylesheet.addStyle(".col3", "width:30%"); stylesheet.addStyle(".col4", "width:5%"); return stylesheet; } /** File: embedded_javascript_tutorial1.ac2 Id: 215 Description: Add multiple paragraphs in one cell */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcellmultipleparagraphs // @description = Tutorial: Add multiple paragraphs in one cell of the table // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { var report = Banana.Report.newReport("Javascrip Tutorial - Add multiple paragraphs in one cell"); /* Create the table */ var table = report.addTable("table"); var row; /* Add a row */ row = table.addRow(); /* Add first cell with paragraphs*/ var cell1 = row.addCell("", "", 1); cell1.addParagraph("First paragraph...", ""); cell1.addParagraph("Second paragraph...", ""); cell1.addParagraph(" "); //empty paragraph cell1.addParagraph("Fourth paragraph...", ""); /* Add second cell without paragraphs */ var cell2 = row.addCell("Cell2...", "", 1); /* Print the report */ var stylesheet = createStyleSheet(); Banana.Report.preview(report, stylesheet); } function createStyleSheet() { var stylesheet = Banana.Report.newStyleSheet(); style = stylesheet.addStyle(".table"); style.setAttribute("width","100%"); stylesheet.addStyle("table.table td", "border: thin solid black"); return stylesheet; } /** File: embedded_javascript_tutorial1.ac2 Id: 216 Description: Create a table with fixed columns and cells span */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialtablefixedcolumnscellspan // @description = Tutorial: Create a table with fixed columns and cells span // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { var report = Banana.Report.newReport("Javascrip Tutorial - Simple Table"); /* Create the table */ var table = report.addTable("table"); /* Add columns */ var column1 = table.addColumn("col1"); var column2 = table.addColumn("col2"); var column3 = table.addColumn("col3"); var column4 = table.addColumn("col4"); var row; /* 1st row */ row = table.addRow(); row.addCell("Row 1, Cell 1: span cell over 4 columns", "", 4); //span cell over 4 columns /* 2nd row */ row = table.addRow(); row.addCell("Row 2, Cell 1: span cell over 2 columns", "", 2); //span cell over 2 columns row.addCell("Row 2, Cell 3: span cell over 2 columns", "", 2); //span cell over 2 columns /* 3rd row */ row = table.addRow(); row.addCell("Row 3, Cell 1", "", 1); row.addCell("Row 3, Cell 2: span cell over 2 columns", "", 2); //span cell over 2 columns row.addCell("Row 3, Cell 4", "", 1); /* 4th row*/ row = table.addRow(); row.addCell("Row 4, Cell 1", "", 1); row.addCell("Row 4, Cell 2", "", 1); row.addCell("Row 4, Cell 3", "", 1); row.addCell("Row 4, Cell 4", "", 1); /* 5th row */ row = table.addRow(); row.addCell("Row 5, Cell 1: span cell over 3 columns", "", 3); //span cell over 3 columns row.addCell("Row 5, Cell 4", "", 1); /* Print the report */ var stylesheet = createStyleSheet(); Banana.Report.preview(report, stylesheet); } function createStyleSheet() { var stylesheet = Banana.Report.newStyleSheet(); var style = stylesheet.addStyle(".table"); style.setAttribute("width","100%"); //table takes all the page width stylesheet.addStyle("table.table td", "border: thin solid black; padding-top:10px; padding-bottom:10px;"); /* Set columns' width */ stylesheet.addStyle(".col1", "width:25%"); stylesheet.addStyle(".col2", "width:25%"); stylesheet.addStyle(".col3", "width:25%"); stylesheet.addStyle(".col4", "width:25%"); return stylesheet; } /** File: embedded_javascript_tutorial1.ac2 Id: 220 Description: Set page margins */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialstylesheetsetmargins // @description = Tutorial: Stylesheet set margins // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Add a paragraph with some text using a style report.addParagraph('Hello world!'); //Add some styles var stylesheet = Banana.Report.newStyleSheet(); //Create the margin for the page: [top, right, bottom, left] var pageStyle = stylesheet.addStyle("@page"); pageStyle.setAttribute("margin", "10mm 20mm 10mm 20mm"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 221 Description: Set landscape page */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialstylesheetsetlandscape // @description = Tutorial: Stylesheet set landscape // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Add a paragraph with some text using a style report.addParagraph('Hello world!'); //Add some styles var stylesheet = Banana.Report.newStyleSheet(); //Create the margin for the page var pageStyle = stylesheet.addStyle("@page"); pageStyle.setAttribute("size", "landscape"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 222 Description: Add bold style to a text */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialstylesheetboldtext // @description = Tutorial: Stylesheet add bold style to a text // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Add a paragraph with some text using a style report.addParagraph('Hello world!', 'boldStyle'); //Add some styles var stylesheet = Banana.Report.newStyleSheet(); //Create the "boldStyle" style = stylesheet.addStyle(".boldStyle"); style.setAttribute("font-weight", "bold"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 223 Description: Add a font size to a text */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialstylesheetfontsizetext // @description = Tutorial: Stylesheet add a specific font size to a text // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Add a paragraph with some text using a style report.addParagraph('Hello world!', 'titleStyle'); //Add some styles var stylesheet = Banana.Report.newStyleSheet(); //Create the style for the text style = stylesheet.addStyle(".titleStyle"); style.setAttribute("font-size", "20px"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 224 Description: Add a color to a text */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialstylesheetcolortext // @description = Tutorial: Stylesheet add a color to a text // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Add a paragraph with some text using a style report.addParagraph('Hello world!', 'colorStyle'); //Add some styles var stylesheet = Banana.Report.newStyleSheet(); //Create the style for the text style = stylesheet.addStyle(".colorStyle"); style.setAttribute("color", "red"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 225 Description: First page/cover example */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcoverpageexample // @description = Tutorial: First page/cover example // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport("Cover example"); var title = " 'This is the title' "; var companyName = "Banana.ch SA"; var openingDate = "01.01.2015"; var closufeDate = "31.12.2015"; var year = "2015"; report.addParagraph(title, "heading1 alignCenter"); report.addParagraph(" "); report.addParagraph(companyName, "heading2 alignCenter"); report.addParagraph(" "); report.addParagraph(year, "heading3 alignCenter"); report.addParagraph(" "); report.addParagraph("(" + openingDate + " - " + closufeDate + ")", "heading4 alignCenter"); //Add some styles var stylesheet = Banana.Report.newStyleSheet(); var pageStyle = stylesheet.addStyle("@page"); pageStyle.setAttribute("margin", "10mm 10mm 10mm 20mm"); stylesheet.addStyle("body", "font-family : Helvetica"); style = stylesheet.addStyle(".heading1"); style.setAttribute("font-size", "22px"); style.setAttribute("font-weight", "bold"); style.setAttribute("border-top", "100mm"); style = stylesheet.addStyle(".heading2"); style.setAttribute("font-size", "18px"); style.setAttribute("font-weight", "bold"); style = stylesheet.addStyle(".heading3"); style.setAttribute("font-size", "14px"); style.setAttribute("font-weight", "bold"); style = stylesheet.addStyle(".heading4"); style.setAttribute("font-size", "10px"); style.setAttribute("font-weight", "bold"); style = stylesheet.addStyle(".alignCenter"); style.setAttribute("text-align", "center"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 300 Description: Format numbers */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialformatnumbers // @description = Tutorial: Format numbers // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Convert the value var convertedAmount1 = Banana.Converter.toLocaleNumberFormat("1200.65"); var convertedAmount2 = Banana.Converter.toLocaleNumberFormat("0"); var convertedAmount3 = Banana.Converter.toLocaleNumberFormat(1234.56); var convertedAmount4 = Banana.Converter.toLocaleNumberFormat(1); //Add the converted amount to the report's paragraph report.addParagraph(convertedAmount1); report.addParagraph(convertedAmount2); report.addParagraph(convertedAmount3); report.addParagraph(convertedAmount4); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 301 Description: Format dates */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialformatdates // @description = Tutorial: Format dates // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Convert the value: parameter is a string var date1 = Banana.Converter.toLocaleDateFormat('2015-12-31'); //Convert the value: parameter is a date object var d = new Date(); var date2 = Banana.Converter.toLocaleDateFormat(d); //Add the converted amount to the report's paragraph report.addParagraph(date1); report.addParagraph(date2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 302 Description: Format transactions journal data */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialformattransactionjournaldata // @description = Tutorial: Format transactions journal data // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create the table that will be printed on the report var table = report.addTable("myTable"); //Add column titles to the table report var tableHeader = table.getHeader(); tableRow = tableHeader.addRow(); tableRow.addCell('Data', 'boldStyle'); tableRow.addCell('Account', 'boldStyle'); tableRow.addCell('Description', 'boldStyle'); tableRow.addCell('Amount', 'boldStyle'); //Create a table with all transactions var journal = Banana.document.journal(Banana.document.ORIGINTYPE_CURRENT, Banana.document.ACCOUNTTYPE_NORMAL); //Read some values of the journal table for (var i = 0; i < journal.rowCount; i++) { var tRow = journal.row(i); //Add the values taken from the rows to the respective cells of the table //For the dates and the amounts we apply the format functions tableRow = table.addRow(); tableRow.addCell(Banana.Converter.toLocaleDateFormat(tRow.value('JDate'))); tableRow.addCell(tRow.value('JAccount')); tableRow.addCell(tRow.value('JAccountDescription')); tableRow.addCell(Banana.Converter.toLocaleNumberFormat(tRow.value('JAmount')), 'alignRight'); } //Create the styleSheet var stylesheet = Banana.Report.newStyleSheet(); //Add borders to the table var style = stylesheet.addStyle("table"); stylesheet.addStyle("table.myTable td", "border: thin solid black"); //Add the right alignment for the amount style = stylesheet.addStyle(".alignRight"); style.setAttribute("text-align", "right"); //Add the bold style for the header style = stylesheet.addStyle(".boldStyle"); style.setAttribute("font-weight", "bold"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 310 Description: Basic mathematical operations (sum, subtract, multiply, divide) */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialbasicmathematicaloperations // @description = Tutorial: Basic mathematical operations (sum, subtract, multiply, divide) // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Do some mathematical operations and add the results to the report //Sum var sum = Banana.SDecimal.add('6.50', '3.50'); // return '10.00' report.addParagraph(sum); //Subtract var sub = Banana.SDecimal.subtract('10', '3'); // return '7' report.addParagraph(sub); //Multiply var mul = Banana.SDecimal.multiply('6', '3'); // return '18' report.addParagraph(mul); //Divide var div = Banana.SDecimal.divide('6', '3'); // return '2' report.addParagraph(div); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 311 Description: abs function */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialabsfunction // @description = Tutorial: abs function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Return the value without the sign var absValue = Banana.SDecimal.abs('-10'); //Add a paragraph to the report report.addParagraph(absValue); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 312 Description: Compare two values */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcomparevalues // @description = Tutorial: Compare two values // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); // Compare the values: // return 1 if value1 > value2 // return 0 if value1 = value2 // return -1 if value1 < value2 var compareValue = Banana.SDecimal.compare('5', '2'); //Add a paragraph to the report report.addParagraph(compareValue); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 313 Description: Invert sign of a value */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialinvertsign // @description = Tutorial: Invert value sign // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Invert the sign: //if positive return a negative value //if negative return a positive value var invertValue = Banana.SDecimal.invert('4'); //Add a paragraph to the report report.addParagraph(invertValue); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 314 Description: Check the sign of a value */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcheckvaluesign // @description = Tutorial: Check value sign // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Check the sign of the value: //return 1 if value > 0 //return 0 if value = 0 //return -1 if value <0 var signValue = Banana.SDecimal.sign('-6'); //Add a paragraph to the report report.addParagraph(signValue); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 315 Description: Number of decimals and rounding properties */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialdecimalsrounding // @description = Tutorial: Number of decimals and rounding properties // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Divide without properties var result1 = Banana.SDecimal.divide('10', '3.25'); //return '3.3333333333333333333333333' report.addParagraph(result1); //Divide with number of decimals property var result2 = Banana.SDecimal.divide('10', '3.25', { 'decimals': 4 }); report.addParagraph(result2); //Divide with number of decimals and rounding properties var result3 = Banana.SDecimal.divide('10', '3.25', { 'decimals': 2, 'mode': Banana.SDecimal.HALF_UP }); report.addParagraph(result3); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 320 Description: Dialog information */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialinformationdialog // @description = Tutorial: Information dialog // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Open a dialog window with an information Banana.Ui.showInformation('Title', 'This is the information message!'); } /** File: embedded_javascript_tutorial1.ac2 Id: 321 Description: Dialog question */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialquestiondialog // @description = Tutorial: Question dialog // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create a report var report = Banana.Report.newReport("Report title"); //Open a dialog window with a question var question = Banana.Ui.showQuestion('Question title', 'Print the report?'); //If 'true' do something... if (question) { //...for example add some text to the paragraph report.addParagraph('The answer was YES!'); //...then print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } } /** File: embedded_javascript_tutorial1.ac2 Id: 322 Description: Dialog show text */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialshowtextdialog // @description = Tutorial: Show text dialog // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Open a dialog window showing the text. //In this case we want to show the table Accounts as html file Banana.Ui.showText(Banana.document.table('Accounts').toHtml(['Account', 'Group', 'Description', 'Balance'], true)); } /** File: embedded_javascript_tutorial1.ac2 Id: 323 Description: Dialog input text */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialinputtextdialog // @description = Tutorial: Input text dialog // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create a report var report = Banana.Report.newReport("Report title"); //Open a dialog window asking the user to insert some text //The text inserted is saved into a variable var textInsertedByUser = Banana.Ui.getText('This is a dialog window', 'Insert some text', ''); //Add to the paragraph the text inserted by the user report.addParagraph(textInsertedByUser); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 324 Description: Dialog item selection */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialitemselectiondialog // @description = Tutorial: Item selection dialog // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Open a dialog window asking to select an item from the list //The selected item is then saved into a variable var itemSelected = Banana.Ui.getItem('Input', 'Choose a value', ['Item ONE', 'Item TWO', 'Item THREE', 'Item FOUR', 'Item FIVE'], 2, false); //Add the selected item to the paragraph report.addParagraph(itemSelected); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 325 Description: Dialog period selection */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialperiodselectiondialog // @description = Tutorial: Period selection dialog // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create a report var report = Banana.Report.newReport("Report title"); //Open a dialog windows to choose a period var date = Banana.Ui.getPeriod('Period selection', '2015-01-01', '2015-12-31'); //Add the date information to the report report.addParagraph(date.startDate); report.addParagraph(date.endDate); report.addParagraph(date.hasSelection); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 330 Description: Show messages */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialshowmessages // @description = Tutorial: Show messages // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { Banana.document.clearMessages(); //Step 1 - table access var transactionTable = Banana.document.table('Transactions'); //Step 2 - loop on each row of the table for (var i = 0; i < transactionTable.rowCount; i++) { var tRow = transactionTable.row(i); //Check the length of the description if (tRow.value('Description').length > 20 && tRow.value('Description').length < 30) { Banana.document.addMessage("Warning: row " + tRow.rowNr + ", description's length is " + tRow.value('Description').length + "!"); } else if (tRow.value('Description').length >= 30) { Banana.document.addMessage("Error: row " + tRow.rowNr + ", description's length is " + tRow.value('Description').length + "!"); } } } /** File: embedded_javascript_tutorial1.ac2 Id: 331 Description: Show messages linked to table Transaction */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialshowmessageslinkedtotable // @description = Tutorial: Show messages linked to table Transactions // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { Banana.document.clearMessages(); //Step 1 - table access var transactionTable = Banana.document.table('Transactions'); //Step 2 - loop on each row of the table for (var i = 0; i < transactionTable.rowCount; i++) { var tRow = transactionTable.row(i); //Check the length of the description if (tRow.value('Description').length > 20 && tRow.value('Description').length < 30) { tRow.addMessage("Warning: description's length is " + tRow.value('Description').length + "!"); } else if (tRow.value('Description').length >= 30) { tRow.addMessage("Error: description's length is " + tRow.value('Description').length + "!"); } } } /** File: embedded_javascript_tutorial1.ac2 Id: 332 Description: Clear all messages */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialclearmessages // @description = Tutorial: Clear all messages // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { Banana.document.clearMessages(); } /** File: embedded_javascript_tutorial1.ac2 Id: 400 Description: Save settings */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialsavesettings // @description = Tutorial: Save settings // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Readscript settings var readText = Banana.document.scriptReadSettings(); //If there is a saved setting we can use it if (readText) { //Use the JSON.parse() to convert a JSON text into a JavaScript object var object = JSON.parse(readText); //Add a paragraph with the saved and parsed text report.addParagraph('Previously saved value: ' + object); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } // If it doesn't exists a saved setting yet (which it happens the very first time the script is executed), // it is necessary to create and save it //For example using an dialog window to insert some text var text = Banana.Ui.getText('Save settings example', 'Insert some text', ''); //Convert a JavaScript value into a JSON string using the JSON.stringify() function var textToSave = JSON.stringify(text); //Save script settings var savedText = Banana.document.scriptSaveSettings(textToSave); } /** File: embedded_javascript_tutorial1.ac2 Id: 500 Description: Retrieve basic accounting informations */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretrievebasicaccountinginformation // @description = Tutorial: Retrieve basic accounting information // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create report var report = Banana.Report.newReport('Report title'); //Get some value of the accounting file var fileName = Banana.document.info("Base", "FileName"); var decimalsAmounts = Banana.document.info("Base", "DecimalsAmounts"); var headerLeft = Banana.document.info("Base", "HeaderLeft"); var headerRight = Banana.document.info("Base", "HeaderRight"); var basicCurrency = Banana.document.info("AccountingDataBase", "BasicCurrency"); //For openingDate and closureDate var startDate = Banana.document.info('AccountingDataBase', 'OpeningDate'); var endDate = Banana.document.info('AccountingDataBase', 'ClosureDate'); //For file accounting type var fileType = Banana.document.info("Base", "FileType"); var fileGroup = Banana.document.info("Base", "FileTypeGroup"); var fileNumber = Banana.document.info("Base", "FileTypeNumber"); //Add the informations to the report report.addParagraph(fileName); report.addParagraph(decimalsAmounts); report.addParagraph(headerLeft); report.addParagraph(headerRight); report.addParagraph(basicCurrency); report.addParagraph(startDate); report.addParagraph(endDate); report.addParagraph(fileType); report.addParagraph(fileGroup); report.addParagraph(fileNumber); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 501 Description: Retrieve address informations */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretrieveaddressinformation // @description = Tutorial: Retrieve address information // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create report var report = Banana.Report.newReport('Report title'); //Save informations var company = Banana.document.info('AccountingDataBase', 'Company'); var courtesy = Banana.document.info('AccountingDataBase', 'Courtesy'); var name = Banana.document.info('AccountingDataBase', 'Name'); var familyName = Banana.document.info('AccountingDataBase', 'FamilyName'); var address1 = Banana.document.info('AccountingDataBase', 'Address1'); var address2 = Banana.document.info('AccountingDataBase', 'Address2'); var zip = Banana.document.info('AccountingDataBase', 'Zip'); var city = Banana.document.info('AccountingDataBase', 'City'); var state = Banana.document.info('AccountingDataBase', 'State'); var country = Banana.document.info('AccountingDataBase', 'Country'); var web = Banana.document.info('AccountingDataBase', 'Web'); var email = Banana.document.info('AccountingDataBase', 'Email'); var phone = Banana.document.info('AccountingDataBase', 'Phone'); var mobile = Banana.document.info('AccountingDataBase', 'Mobile'); var fax = Banana.document.info('AccountingDataBase', 'Fax'); var fiscalNumber = Banana.document.info('AccountingDataBase', 'FiscalNumber'); var vatNumber = Banana.document.info('AccountingDataBase', 'VatNumber'); //Add the informations to the report report.addParagraph(company); report.addParagraph(courtesy); report.addParagraph(name); report.addParagraph(familyName); report.addParagraph(address1); report.addParagraph(address2); report.addParagraph(zip); report.addParagraph(city); report.addParagraph(state); report.addParagraph(country); report.addParagraph(web); report.addParagraph(email); report.addParagraph(phone); report.addParagraph(mobile); report.addParagraph(fax); report.addParagraph(fiscalNumber); report.addParagraph(vatNumber); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 510 Description: Retrieve rows table values using findRowByValue() function */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretrieverowstablevaluesusingfindrowbyvalue // @description = Tutorial: Retrieve rows table values using findRowByValue() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create report var report = Banana.Report.newReport("Report title"); //Save the row extracted from the table var rowToExtract = Banana.document.table('Accounts').findRowByValue('Account', '1000'); //Add the Account, Description and Balance informations to the report report.addParagraph(rowToExtract.value('Account')); report.addParagraph(rowToExtract.value('Description')); report.addParagraph(rowToExtract.value('Balance')); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 511 Description: Retrieve specific rows table values */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretrievespecificrowstablevalues // @description = Tutorial: Retrieve specific rows table values // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create report var report = Banana.Report.newReport("Report title"); // Step 1 - table access: specify the name of the table ("Accounts", "Transactions", "VatCodes", ...) var accountsTable = Banana.document.table("Accounts"); //Step 2 - row selection: it is important to note that the rows of the Banana table start counting from 0, //so keep in mind to specify one number less than the desired one //1st row = 0 //2nd row = 1 //3rd row = 2 //4th row = 3 //... var row3 = accountsTable.row(2); // We want the third row // Step 3 - select all the desired columns var account = row3.value("Account"); var description = row3.value("Description"); var balance = row3.value("Balance"); //Add the informations to the report report.addParagraph(account); report.addParagraph(description); report.addParagraph(balance); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 512 Description: Retrieve rows table values */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretrieverowstablevalues // @description = Tutorial: Retrieve rows table values // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create a report var report = Banana.Report.newReport('Report title'); //Step 1 - table access var accountsTable = Banana.document.table('Accounts'); //Step 2 - loop on each row of the table, instead of specifying a single row for (var rowNumber = 0; rowNumber < accountsTable.rowCount; rowNumber++) { var tRow = accountsTable.row(rowNumber); //Step 3 - select the desired columns var account = tRow.value('Account'); var description = tRow.value('Description'); var balance = tRow.value('Balance'); //Add the informations to the report report.addParagraph(account + ', ' + description + ', ' + balance); } //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 513 Description: Retrieve rows table with account number */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretretrieverowstablewithaccountnumber // @description = Tutorial: Retrieve rows table with account number // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create a report var report = Banana.Report.newReport('Report title'); //Step 1 - table access var accountsTable = Banana.document.table('Accounts'); //Step 2 - loop on each row of the table, instead of specifying a single row for (var rowNumber = 0; rowNumber < accountsTable.rowCount; rowNumber++) { var tRow = accountsTable.row(rowNumber); //If the row has an account number we save the values and print them if (tRow.value('Account')) { //Step 3 - select the desired columns var account = tRow.value('Account'); var description = tRow.value('Description'); var balance = tRow.value('Balance'); //Add the informations to the report report.addParagraph(account + ', ' + description + ', ' + balance); } } //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 514 Description: Print all table rows in a table format */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialretprintrowstablewithaccountnumberintableformat // @description = Tutorial: Print rows table with account number in table format // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create a report var report = Banana.Report.newReport('Report title'); //Create the table that will be printed on the report var table = report.addTable("myTable"); //Add column titles to the table report var tableHeader = table.getHeader(); tableRow = tableHeader.addRow(); tableRow.addCell("Account"); tableRow.addCell("Description"); tableRow.addCell("Balance"); //Step 1 - table access var accountsTable = Banana.document.table('Accounts'); //Step 2 - loop on each row of the table, instead of specifying a single row for (var rowNumber = 0; rowNumber < accountsTable.rowCount; rowNumber++) { var tRow = accountsTable.row(rowNumber); //If the row has an account number we save the values and print them if (tRow.value('Account')) { //Step 3 - select the desired columns var account = tRow.value('Account'); var description = tRow.value('Description'); var balance = tRow.value('Balance'); //Add the values taken from the rows to the respective cells of the table tableRow = table.addRow(); tableRow.addCell(account); tableRow.addCell(description); tableRow.addCell(balance); } } //Create the styleSheet to var stylesheet = Banana.Report.newStyleSheet(); //Create a table style adding the border var style = stylesheet.addStyle("table"); stylesheet.addStyle("table.myTable td", "border: thin solid black"); //Print the report Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 515 Description: Find all rows that match a condition using findRows */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialfindrows // @description = Tutorial: Retrieve all rows table that match a condition using findRows // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { var tableAccounts = Banana.document.table('Accounts'); var rows = tableAccounts.findRows(accountStartsWith25XX); var accounts = []; for(var i = 0; i < rows.length; i++) { accounts.push(rows[i].value('Account')); } Banana.Ui.showInformation('Info', 'Accounts that start with 25XX: ' + accounts.join(';')); } function accountStartsWith25XX(rowObj,rowNr,table) { // Return true if account start with '25XX' return rowObj.value('Account').startsWith('25'); } /** File: embedded_javascript_tutorial1.ac2 Id: 516 Description: Retrieve all rows that match a condition using extractRows */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialextractrows // @description = Tutorial: Retrieve all rows table that match a condition using extractRows // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { var tableAccounts = Banana.document.table('Accounts'); tableAccounts.extractRows(accountStartsWith25XX, 'Accounts that start with 25XX'); } function accountStartsWith25XX(rowObj,rowNr,table) { // Return true if account start with '25XX' return rowObj.value('Account').startsWith('25'); } /** File: embedded_javascript_tutorial1.ac2 Id: 600 Description: Amount of opening for all transactions for an account */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentbalancesingleaccount // @description = Tutorial: Retrieve amount of an account using currentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take opening sum for a non-specific period: period taken from Banana var amount1 = Banana.document.currentBalance('1000', '', '').opening; //Take opening sum for a specific period var amount2 = Banana.document.currentBalance('1000', '2015-01-05', '2015-02-07').opening; //Add a paragraph with the amounts just calculated report.addParagraph(Banana.document.accountDescription('1000')); report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 601 Description: Amount of opening for all transactions for multiple accounts */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentbalancemultipleaccounts // @description = Tutorial: Retrieve amount of multiple accounts using currentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take opening sum for a non-specific period: period taken from Banana var amount1 = Banana.document.currentBalance('1000|1010|1011', '', '').opening; //Take opening sum for a specific period var amount2 = Banana.document.currentBalance('1000|1010|1011', '2015-01-05', '2015-02-07').opening; //Add a paragraph with the amounts just calculated report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 602 Description: Amount of opening for all transactions for a single group */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentbalancesinglegroup // @description = Tutorial: Retrieve amount of single group using currentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take opening sum for a non-specific period: period taken from Banana var amount1 = Banana.document.currentBalance('Gr=100', '', '').opening; //Take opening sum for a specific period var amount2 = Banana.document.currentBalance('Gr=100', '2015-01-05', '2015-02-07').opening; //Add a paragraph with the amounts just calculated report.addParagraph(Banana.document.accountDescription('Gr=100')); report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 603 Description: Amount of opening for all transactions for multiple groups */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentbalancemultiplegroups // @description = Tutorial: Retrieve amount of multiple groups using currentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take opening sum for a non-specific period: period taken from Banana var amount1 = Banana.document.currentBalance('Gr=100|110|120', '', '').opening; //Take opening sum for a specific period var amount2 = Banana.document.currentBalance('Gr=100|110|120', '2015-01-05', '2015-02-07').opening; //Add a paragraph with the amounts just calculated report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 604 Description: Amount of opening for all transactions for a BClass */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentbalancesinglebclass // @description = Tutorial: Retrieve amount of a single BClass using currentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take opening sum for a non-specific period: period taken from Banana var amount1 = Banana.document.currentBalance('BClass=1', '', '').opening; //Take opening sum for a specific period var amount2 = Banana.document.currentBalance('BClass=1', '2015-01-05', '2015-02-07').opening; //Add a paragraph with the amounts just calculated report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 605 Description: Amount of opening for all transactions for multiple BClass values */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentbalancemultiplebclass // @description = Tutorial: Retrieve amount of multiple BClass using currentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take opening sum for a non-specific period: period taken from Banana var amount1 = Banana.document.currentBalance('BClass=1|2', '', '').opening; //Take opening sum for a specific period var amount2 = Banana.document.currentBalance('BClass=1|2', '2015-01-05', '2015-02-07').opening; //Add a paragraph with the amounts just calculated report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 610 Description: Sum the Vat amounts for the specified vat code */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialvatcurrentbalancesinglevatcode // @description = Tutorial: Sum the VAT amounts for single VAT code using vatCurrentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take the vatAmount sum for a non-specific period: period taken from Banana var amount1 = Banana.document.vatCurrentBalance('S10', '', '').vatAmount; //Take the vatAmount sum for a specific period var amount2 = Banana.document.vatCurrentBalance('S10', '2015-01-01', '2015-01-06').vatAmount; //Add a paragraph with the amounts just calculated report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 611 Description: Sum the Vat amounts for multiple vat codes */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialvatcurrentbalancemultiplevatcodes // @description = Tutorial: Sum the VAT amounts for multiple VAT codes using vatCurrentBalance() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Take the vatAmount sum for a non-specific period: period taken from Banana var amount1 = Banana.document.vatCurrentBalance('S10|P10', '', '').vatAmount; //Take the vatAmount sum for a specific period var amount2 = Banana.document.vatCurrentBalance('S10|P10', '2015-02-01', '2015-02-28').vatAmount; //Add a paragraph with the amounts just calculated report.addParagraph(amount1); report.addParagraph(amount2); //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 620 Description: For a given account without specifying the period */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentcardnoperiod // @description = Tutorial: Use currentCard() function for a given account // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table with all the transactions of the given account var transTab = Banana.document.currentCard('1010', '', ''); //For each row of the table we save the values for (var i = 0; i < transTab.rowCount; i++) { var tRow = transTab.row(i); var date = tRow.value('JDate'); var account = tRow.value('JAccount'); var description = tRow.value("JDescription"); var debit = tRow.value('JDebitAmount'); var credit = tRow.value('JCreditAmount'); var balance = tRow.value('JBalance'); //Add a paragraph with the values just calculated report.addParagraph(date + ', ' + account + ', ' + description + ', ' + debit + ', ' + credit + ', ' + balance); } //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 621 Description: For a given account and period */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialcurrentcardwithperiod // @description = Tutorial: Use currentCard() function for a given account and period // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table with all transactions for the given account and period var transTab = Banana.document.currentCard('1010', '2015-01-03', '2015-02-07'); //For each row of the table we save the values for (var i = 0; i < transTab.rowCount; i++) { var tRow = transTab.row(i); var date = tRow.value('JDate'); var account = tRow.value('JAccount'); var description = tRow.value("JDescription"); var debit = tRow.value('JDebitAmount'); var credit = tRow.value('JCreditAmount'); var balance = tRow.value('JBalance'); //Add a paragraph with the values just calculated report.addParagraph(date + ', ' + account + ', ' + description + ', ' + debit + ', ' + credit + ', ' + balance); } //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 630 Description: Get all transaction for normal accounts */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialjournal // @description = Tutorial: Retrieve all transactions for normal accounts using the journal() function // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { //Create the report var report = Banana.Report.newReport('Report title'); //Create a table with all transactions var journal = Banana.document.journal(Banana.document.ORIGINTYPE_CURRENT, Banana.document.ACCOUNTTYPE_NORMAL); //Read the table and save some values for (var i = 0; i < journal.rowCount; i++) { var tRow = journal.row(i); var date = tRow.value('JDate'); var account = tRow.value('JAccount'); var accDescription = tRow.value('JAccountDescription'); var description = tRow.value('JDescription'); var vatCode = tRow.value('JVatCodeWithoutSign'); var vatDescription = tRow.value('JVatCodeDescription'); var amount = tRow.value('JAmount'); //Add to the paragraph the values just saved report.addParagraph(date + ', ' + account + ', ' + accDescription + ', ' + description + ', ' + vatCode + ', ' + vatDescription + ', ' + amount); } //Print the report var stylesheet = Banana.Report.newStyleSheet(); Banana.Report.preview(report, stylesheet); } /** File: embedded_javascript_tutorial1.ac2 Id: 700 Description: Reading an xml file */ // @api = 1.0 // @id = ch.banana.uni.app.tutorialreadxmlfile // @description = Tutorial: Read an XML file // @task = app.command // @doctype = nodocument // @publisher = Banana.ch SA // @pubdate = 2019-01-25 // @inputdatasource = none // @timeout = -1 function exec() { // The xml file var xml = '