import React, { Component } from 'react';
import { Typography, Paper, createMuiTheme, MuiThemeProvider, TableCell, FormControlLabel, TextField, Input } from '@material-ui/core';
import MUIDataTable from 'mui-datatables';
import NumberFormat from 'react-number-format';
import api from '../../api';
import AddIcon from '@material-ui/icons/Add';
import { values } from 'ramda';
import PropagateLoader from "react-spinners/PropagateLoader"
import Images from '../../assets/Images';
import ReactTooltip from 'react-tooltip';
var ct = require("../../library/CustomTable");
const getMuiTheme = () => createMuiTheme(ct.customTable3());
const options = ct.customOptionsFixedColumn();
const style = {
position: "sticky",
left: 0,
zIndex: 101,
background: "white",
};
const style2 = {
position: "sticky",
background: "white",
zIndex: 100,
top: 0
};
export default class TaxPlanning extends Component {
constructor(props) {
super(props)
this.state = {
dataTable: [
// ["TOTAL ASSETS", "11,247,249", "10,702,196"],
// ["TOTAL CURRENT ASSETS", "2,647,647", "2,058,898"],
// ["Cash & Cash Equivalent", "1,464,571", "729,743"],
// ["Cash & Bank Balance", "938,707", "265,584"],
// ["Time & Call Deposit", "525,864", "464,159"],
// ["BI Deposit", "", ""],
// ["Marketable Securities", "150,250", "154,500"],
// ["Notes Receivable", "", ""],
// ["Accounts Receivable", "172,031", "97,112"],
// ["Trade Receivables - Third Party", "142,668", "77,480"],
]
}
this.handleValue = this.handleValue.bind(this)
}
componentDidMount() {
this.getItemHierarki()
console.log(this.props);
}
getItemHierarki() {
this.setState({ loading: true })
let payload = {
"report_id": this.props.report_id,
"revision": Number(this.props.revision),
"periode": this.props.periode,
"company_id": this.props.company.company_id,
"submission_id": this.props.submissionID
}
api.create().getDetailReportMB(payload).then(response => {
console.log(response);
if (response.data) {
if (response.data.status === "success") {
let dataTable = []
response.data.data.map((item, index) => {
if (item.children && item.children.length > 0) {
dataTable.push([
item.type_report_id,
item.type_report_tax.value_tbc.type_report_id,
item.type_report_tax.value_fc.type_report_id,
item.type_report_tax.value_tbf.type_report_id,
item.id,
item.parent,
item.formula,
item.level,
item.description,
item.tax_planning.january.tbc,
item.tax_planning.january.fcp,
item.tax_planning.january.tbf,
item.tax_planning.february.tbc,
item.tax_planning.february.fcp,
item.tax_planning.february.tbf,
item.tax_planning.march.tbc,
item.tax_planning.march.fcp,
item.tax_planning.march.tbf,
item.tax_planning.april.tbc,
item.tax_planning.april.fcp,
item.tax_planning.april.tbf,
item.tax_planning.may.tbc,
item.tax_planning.may.fcp,
item.tax_planning.may.tbf,
item.tax_planning.june.tbc,
item.tax_planning.june.fcp,
item.tax_planning.june.tbf,
item.tax_planning.july.tbc,
item.tax_planning.july.fcp,
item.tax_planning.july.tbf,
item.tax_planning.august.tbc,
item.tax_planning.august.fcp,
item.tax_planning.august.tbf,
item.tax_planning.september.tbc,
item.tax_planning.september.fcp,
item.tax_planning.september.tbf,
item.tax_planning.october.tbc,
item.tax_planning.october.fcp,
item.tax_planning.october.tbf,
item.tax_planning.november.tbc,
item.tax_planning.november.fcp,
item.tax_planning.november.tbf,
item.tax_planning.december.tbc,
item.tax_planning.december.fcp,
item.tax_planning.december.tbf,
item.tax_planning.total_current_year,
item.tax_planning.total_next_year.tbc,
item.tax_planning.total_next_year.fcp,
item.tax_planning.total_next_year.tbf,
item.tax_planning.total_more_year.tbc,
item.tax_planning.total_more_year.fcp,
item.tax_planning.total_more_year.tbf
])
item.children.map(i => {
if (i.children) {
if (i.children.length > 0) {
dataTable.push([
i.type_report_id,
i.type_report_tax.value_tbc.type_report_id,
i.type_report_tax.value_fc.type_report_id,
i.type_report_tax.value_tbf.type_report_id,
i.id,
i.parent,
i.formula,
i.level,
i.description,
i.tax_planning.january.tbc,
i.tax_planning.january.fcp,
i.tax_planning.january.tbf,
i.tax_planning.february.tbc,
i.tax_planning.february.fcp,
i.tax_planning.february.tbf,
i.tax_planning.march.tbc,
i.tax_planning.march.fcp,
i.tax_planning.march.tbf,
i.tax_planning.april.tbc,
i.tax_planning.april.fcp,
i.tax_planning.april.tbf,
i.tax_planning.may.tbc,
i.tax_planning.may.fcp,
i.tax_planning.may.tbf,
i.tax_planning.june.tbc,
i.tax_planning.june.fcp,
i.tax_planning.june.tbf,
i.tax_planning.july.tbc,
i.tax_planning.july.fcp,
i.tax_planning.july.tbf,
i.tax_planning.august.tbc,
i.tax_planning.august.fcp,
i.tax_planning.august.tbf,
i.tax_planning.september.tbc,
i.tax_planning.september.fcp,
i.tax_planning.september.tbf,
i.tax_planning.october.tbc,
i.tax_planning.october.fcp,
i.tax_planning.october.tbf,
i.tax_planning.november.tbc,
i.tax_planning.november.fcp,
i.tax_planning.november.tbf,
i.tax_planning.december.tbc,
i.tax_planning.december.fcp,
i.tax_planning.december.tbf,
i.tax_planning.total_current_year,
i.tax_planning.total_next_year.tbc,
i.tax_planning.total_next_year.fcp,
i.tax_planning.total_next_year.tbf,
i.tax_planning.total_more_year.tbc,
i.tax_planning.total_more_year.fcp,
i.tax_planning.total_more_year.tbf
])
i.children.map(val => {
if (val.children && val.children.length > 0) {
dataTable.push([
val.type_report_id,
val.type_report_tax.value_tbc.type_report_id,
val.type_report_tax.value_fc.type_report_id,
val.type_report_tax.value_tbf.type_report_id,
val.id,
val.parent,
val.formula,
val.level,
val.description,
val.tax_planning.january.tbc,
val.tax_planning.january.fcp,
val.tax_planning.january.tbf,
val.tax_planning.february.tbc,
val.tax_planning.february.fcp,
val.tax_planning.february.tbf,
val.tax_planning.march.tbc,
val.tax_planning.march.fcp,
val.tax_planning.march.tbf,
val.tax_planning.april.tbc,
val.tax_planning.april.fcp,
val.tax_planning.april.tbf,
val.tax_planning.may.tbc,
val.tax_planning.may.fcp,
val.tax_planning.may.tbf,
val.tax_planning.june.tbc,
val.tax_planning.june.fcp,
val.tax_planning.june.tbf,
val.tax_planning.july.tbc,
val.tax_planning.july.fcp,
val.tax_planning.july.tbf,
val.tax_planning.august.tbc,
val.tax_planning.august.fcp,
val.tax_planning.august.tbf,
val.tax_planning.september.tbc,
val.tax_planning.september.fcp,
val.tax_planning.september.tbf,
val.tax_planning.october.tbc,
val.tax_planning.october.fcp,
val.tax_planning.october.tbf,
val.tax_planning.november.tbc,
val.tax_planning.november.fcp,
val.tax_planning.november.tbf,
val.tax_planning.december.tbc,
val.tax_planning.december.fcp,
val.tax_planning.december.tbf,
val.tax_planning.total_current_year,
val.tax_planning.total_next_year.tbc,
val.tax_planning.total_next_year.fcp,
val.tax_planning.total_next_year.tbf,
val.tax_planning.total_more_year.tbc,
val.tax_planning.total_more_year.fcp,
val.tax_planning.total_more_year.tbf
])
val.children.map(items => {
if (items.children && items.children.length > 0) {
dataTable.push([
items.type_report_id,
items.type_report_tax.value_tbc.type_report_id,
items.type_report_tax.value_fc.type_report_id,
items.type_report_tax.value_tbf.type_report_id,
items.id,
items.parent,
items.formula,
items.level,
items.description,
items.tax_planning.january.tbc,
items.tax_planning.january.fcp,
items.tax_planning.january.tbf,
items.tax_planning.february.tbc,
items.tax_planning.february.fcp,
items.tax_planning.february.tbf,
items.tax_planning.march.tbc,
items.tax_planning.march.fcp,
items.tax_planning.march.tbf,
items.tax_planning.april.tbc,
items.tax_planning.april.fcp,
items.tax_planning.april.tbf,
items.tax_planning.may.tbc,
items.tax_planning.may.fcp,
items.tax_planning.may.tbf,
items.tax_planning.june.tbc,
items.tax_planning.june.fcp,
items.tax_planning.june.tbf,
items.tax_planning.july.tbc,
items.tax_planning.july.fcp,
items.tax_planning.july.tbf,
items.tax_planning.august.tbc,
items.tax_planning.august.fcp,
items.tax_planning.august.tbf,
items.tax_planning.september.tbc,
items.tax_planning.september.fcp,
items.tax_planning.september.tbf,
items.tax_planning.october.tbc,
items.tax_planning.october.fcp,
items.tax_planning.october.tbf,
items.tax_planning.november.tbc,
items.tax_planning.november.fcp,
items.tax_planning.november.tbf,
items.tax_planning.december.tbc,
items.tax_planning.december.fcp,
items.tax_planning.december.tbf,
items.tax_planning.total_current_year,
items.tax_planning.total_next_year.tbc,
items.tax_planning.total_next_year.fcp,
items.tax_planning.total_next_year.tbf,
items.tax_planning.total_more_year.tbc,
items.tax_planning.total_more_year.fcp,
items.tax_planning.total_more_year.tbf
])
items.children.map(itemss => {
if (itemss.children && itemss.children.length > 0) {
dataTable.push([
itemss.type_report_id,
itemss.type_report_tax.value_tbc.type_report_id,
itemss.type_report_tax.value_fc.type_report_id,
itemss.type_report_tax.value_tbf.type_report_id,
itemss.id,
itemss.parent,
itemss.formula,
itemss.level,
itemss.description,
itemss.tax_planning.january.tbc,
itemss.tax_planning.january.fcp,
itemss.tax_planning.january.tbf,
itemss.tax_planning.february.tbc,
itemss.tax_planning.february.fcp,
itemss.tax_planning.february.tbf,
itemss.tax_planning.march.tbc,
itemss.tax_planning.march.fcp,
itemss.tax_planning.march.tbf,
itemss.tax_planning.april.tbc,
itemss.tax_planning.april.fcp,
itemss.tax_planning.april.tbf,
itemss.tax_planning.may.tbc,
itemss.tax_planning.may.fcp,
itemss.tax_planning.may.tbf,
itemss.tax_planning.june.tbc,
itemss.tax_planning.june.fcp,
itemss.tax_planning.june.tbf,
itemss.tax_planning.july.tbc,
itemss.tax_planning.july.fcp,
itemss.tax_planning.july.tbf,
itemss.tax_planning.august.tbc,
itemss.tax_planning.august.fcp,
itemss.tax_planning.august.tbf,
itemss.tax_planning.september.tbc,
itemss.tax_planning.september.fcp,
itemss.tax_planning.september.tbf,
itemss.tax_planning.october.tbc,
itemss.tax_planning.october.fcp,
itemss.tax_planning.october.tbf,
itemss.tax_planning.november.tbc,
itemss.tax_planning.november.fcp,
itemss.tax_planning.november.tbf,
itemss.tax_planning.december.tbc,
itemss.tax_planning.december.fcp,
itemss.tax_planning.december.tbf,
itemss.tax_planning.total_current_year,
itemss.tax_planning.total_next_year.tbc,
itemss.tax_planning.total_next_year.fcp,
itemss.tax_planning.total_next_year.tbf,
itemss.tax_planning.total_more_year.tbc,
itemss.tax_planning.total_more_year.fcp,
itemss.tax_planning.total_more_year.tbf
])
itemss.children.map(item1 => {
if (item1.children && item1.children.length > 0) {
dataTable.push([
item1.type_report_id,
item1.type_report_tax.value_tbc.type_report_id,
item1.type_report_tax.value_fc.type_report_id,
item1.type_report_tax.value_tbf.type_report_id,
item1.id,
item1.parent,
item1.formula,
item1.level,
item1.description,
item1.tax_planning.january.tbc,
item1.tax_planning.january.fcp,
item1.tax_planning.january.tbf,
item1.tax_planning.february.tbc,
item1.tax_planning.february.fcp,
item1.tax_planning.february.tbf,
item1.tax_planning.march.tbc,
item1.tax_planning.march.fcp,
item1.tax_planning.march.tbf,
item1.tax_planning.april.tbc,
item1.tax_planning.april.fcp,
item1.tax_planning.april.tbf,
item1.tax_planning.may.tbc,
item1.tax_planning.may.fcp,
item1.tax_planning.may.tbf,
item1.tax_planning.june.tbc,
item1.tax_planning.june.fcp,
item1.tax_planning.june.tbf,
item1.tax_planning.july.tbc,
item1.tax_planning.july.fcp,
item1.tax_planning.july.tbf,
item1.tax_planning.august.tbc,
item1.tax_planning.august.fcp,
item1.tax_planning.august.tbf,
item1.tax_planning.september.tbc,
item1.tax_planning.september.fcp,
item1.tax_planning.september.tbf,
item1.tax_planning.october.tbc,
item1.tax_planning.october.fcp,
item1.tax_planning.october.tbf,
item1.tax_planning.november.tbc,
item1.tax_planning.november.fcp,
item1.tax_planning.november.tbf,
item1.tax_planning.december.tbc,
item1.tax_planning.december.fcp,
item1.tax_planning.december.tbf,
item1.tax_planning.total_current_year,
item1.tax_planning.total_next_year.tbc,
item1.tax_planning.total_next_year.fcp,
item1.tax_planning.total_next_year.tbf,
item1.tax_planning.total_more_year.tbc,
item1.tax_planning.total_more_year.fcp,
item1.tax_planning.total_more_year.tbf
])
item1.children.map(item2 => {
if (item2.children && item2.children.length > 0) {
dataTable.push([
item2.type_report_id,
item2.type_report_tax.value_tbc.type_report_id,
item2.type_report_tax.value_fc.type_report_id,
item2.type_report_tax.value_tbf.type_report_id,
item2.id,
item2.parent,
item2.formula,
item2.level,
item2.description,
item2.tax_planning.january.tbc,
item2.tax_planning.january.fcp,
item2.tax_planning.january.tbf,
item2.tax_planning.february.tbc,
item2.tax_planning.february.fcp,
item2.tax_planning.february.tbf,
item2.tax_planning.march.tbc,
item2.tax_planning.march.fcp,
item2.tax_planning.march.tbf,
item2.tax_planning.april.tbc,
item2.tax_planning.april.fcp,
item2.tax_planning.april.tbf,
item2.tax_planning.may.tbc,
item2.tax_planning.may.fcp,
item2.tax_planning.may.tbf,
item2.tax_planning.june.tbc,
item2.tax_planning.june.fcp,
item2.tax_planning.june.tbf,
item2.tax_planning.july.tbc,
item2.tax_planning.july.fcp,
item2.tax_planning.july.tbf,
item2.tax_planning.august.tbc,
item2.tax_planning.august.fcp,
item2.tax_planning.august.tbf,
item2.tax_planning.september.tbc,
item2.tax_planning.september.fcp,
item2.tax_planning.september.tbf,
item2.tax_planning.october.tbc,
item2.tax_planning.october.fcp,
item2.tax_planning.october.tbf,
item2.tax_planning.november.tbc,
item2.tax_planning.november.fcp,
item2.tax_planning.november.tbf,
item2.tax_planning.december.tbc,
item2.tax_planning.december.fcp,
item2.tax_planning.december.tbf,
item2.tax_planning.total_current_year,
item2.tax_planning.total_next_year.tbc,
item2.tax_planning.total_next_year.fcp,
item2.tax_planning.total_next_year.tbf,
item2.tax_planning.total_more_year.tbc,
item2.tax_planning.total_more_year.fcp,
item2.tax_planning.total_more_year.tbf
])
item2.children.map(item3 => {
if (item3.children && item3.children.length > 0) {
dataTable.push([
item3.type_report_id,
item3.type_report_tax.value_tbc.type_report_id,
item3.type_report_tax.value_fc.type_report_id,
item3.type_report_tax.value_tbf.type_report_id,
item3.id,
item3.parent,
item3.formula,
item3.level,
item3.description,
item3.tax_planning.january.tbc,
item3.tax_planning.january.fcp,
item3.tax_planning.january.tbf,
item3.tax_planning.february.tbc,
item3.tax_planning.february.fcp,
item3.tax_planning.february.tbf,
item3.tax_planning.march.tbc,
item3.tax_planning.march.fcp,
item3.tax_planning.march.tbf,
item3.tax_planning.april.tbc,
item3.tax_planning.april.fcp,
item3.tax_planning.april.tbf,
item3.tax_planning.may.tbc,
item3.tax_planning.may.fcp,
item3.tax_planning.may.tbf,
item3.tax_planning.june.tbc,
item3.tax_planning.june.fcp,
item3.tax_planning.june.tbf,
item3.tax_planning.july.tbc,
item3.tax_planning.july.fcp,
item3.tax_planning.july.tbf,
item3.tax_planning.august.tbc,
item3.tax_planning.august.fcp,
item3.tax_planning.august.tbf,
item3.tax_planning.september.tbc,
item3.tax_planning.september.fcp,
item3.tax_planning.september.tbf,
item3.tax_planning.october.tbc,
item3.tax_planning.october.fcp,
item3.tax_planning.october.tbf,
item3.tax_planning.november.tbc,
item3.tax_planning.november.fcp,
item3.tax_planning.november.tbf,
item3.tax_planning.december.tbc,
item3.tax_planning.december.fcp,
item3.tax_planning.december.tbf,
item3.tax_planning.total_current_year,
item3.tax_planning.total_next_year.tbc,
item3.tax_planning.total_next_year.fcp,
item3.tax_planning.total_next_year.tbf,
item3.tax_planning.total_more_year.tbc,
item3.tax_planning.total_more_year.fcp,
item3.tax_planning.total_more_year.tbf
])
item3.children.map(item4 => {
if (item4.children && item4.children.length > 0) {
dataTable.push([
item4.type_report_id,
item4.type_report_tax.value_tbc.type_report_id,
item4.type_report_tax.value_fc.type_report_id,
item4.type_report_tax.value_tbf.type_report_id,
item4.id,
item4.parent,
item4.formula,
item4.level,
item4.description,
item4.tax_planning.january.tbc,
item4.tax_planning.january.fcp,
item4.tax_planning.january.tbf,
item4.tax_planning.february.tbc,
item4.tax_planning.february.fcp,
item4.tax_planning.february.tbf,
item4.tax_planning.march.tbc,
item4.tax_planning.march.fcp,
item4.tax_planning.march.tbf,
item4.tax_planning.april.tbc,
item4.tax_planning.april.fcp,
item4.tax_planning.april.tbf,
item4.tax_planning.may.tbc,
item4.tax_planning.may.fcp,
item4.tax_planning.may.tbf,
item4.tax_planning.june.tbc,
item4.tax_planning.june.fcp,
item4.tax_planning.june.tbf,
item4.tax_planning.july.tbc,
item4.tax_planning.july.fcp,
item4.tax_planning.july.tbf,
item4.tax_planning.august.tbc,
item4.tax_planning.august.fcp,
item4.tax_planning.august.tbf,
item4.tax_planning.september.tbc,
item4.tax_planning.september.fcp,
item4.tax_planning.september.tbf,
item4.tax_planning.october.tbc,
item4.tax_planning.october.fcp,
item4.tax_planning.october.tbf,
item4.tax_planning.november.tbc,
item4.tax_planning.november.fcp,
item4.tax_planning.november.tbf,
item4.tax_planning.december.tbc,
item4.tax_planning.december.fcp,
item4.tax_planning.december.tbf,
item4.tax_planning.total_current_year,
item4.tax_planning.total_next_year.tbc,
item4.tax_planning.total_next_year.fcp,
item4.tax_planning.total_next_year.tbf,
item4.tax_planning.total_more_year.tbc,
item4.tax_planning.total_more_year.fcp,
item4.tax_planning.total_more_year.tbf
])
item4.children.map(item5 => {
if (item5.children && item5.children.length > 0) {
dataTable.push([
item5.type_report_id,
item5.type_report_tax.value_tbc.type_report_id,
item5.type_report_tax.value_fc.type_report_id,
item5.type_report_tax.value_tbf.type_report_id,
item5.id,
item5.parent,
item5.formula,
item5.level,
item5.description,
item5.tax_planning.january.tbc,
item5.tax_planning.january.fcp,
item5.tax_planning.january.tbf,
item5.tax_planning.february.tbc,
item5.tax_planning.february.fcp,
item5.tax_planning.february.tbf,
item5.tax_planning.march.tbc,
item5.tax_planning.march.fcp,
item5.tax_planning.march.tbf,
item5.tax_planning.april.tbc,
item5.tax_planning.april.fcp,
item5.tax_planning.april.tbf,
item5.tax_planning.may.tbc,
item5.tax_planning.may.fcp,
item5.tax_planning.may.tbf,
item5.tax_planning.june.tbc,
item5.tax_planning.june.fcp,
item5.tax_planning.june.tbf,
item5.tax_planning.july.tbc,
item5.tax_planning.july.fcp,
item5.tax_planning.july.tbf,
item5.tax_planning.august.tbc,
item5.tax_planning.august.fcp,
item5.tax_planning.august.tbf,
item5.tax_planning.september.tbc,
item5.tax_planning.september.fcp,
item5.tax_planning.september.tbf,
item5.tax_planning.october.tbc,
item5.tax_planning.october.fcp,
item5.tax_planning.october.tbf,
item5.tax_planning.november.tbc,
item5.tax_planning.november.fcp,
item5.tax_planning.november.tbf,
item5.tax_planning.december.tbc,
item5.tax_planning.december.fcp,
item5.tax_planning.december.tbf,
item5.tax_planning.total_current_year,
item5.tax_planning.total_next_year.tbc,
item5.tax_planning.total_next_year.fcp,
item5.tax_planning.total_next_year.tbf,
item5.tax_planning.total_more_year.tbc,
item5.tax_planning.total_more_year.fcp,
item5.tax_planning.total_more_year.tbf
])
item5.children.map(item6 => {
if (item6.children && item.children.length > 0) {
dataTable.push([
item6.type_report_id,
item6.type_report_tax.value_tbc.type_report_id,
item6.type_report_tax.value_fc.type_report_id,
item6.type_report_tax.value_tbf.type_report_id,
item6.id,
item6.parent,
item6.formula,
item6.level,
item6.description,
item6.tax_planning.january.tbc,
item6.tax_planning.january.fcp,
item6.tax_planning.january.tbf,
item6.tax_planning.february.tbc,
item6.tax_planning.february.fcp,
item6.tax_planning.february.tbf,
item6.tax_planning.march.tbc,
item6.tax_planning.march.fcp,
item6.tax_planning.march.tbf,
item6.tax_planning.april.tbc,
item6.tax_planning.april.fcp,
item6.tax_planning.april.tbf,
item6.tax_planning.may.tbc,
item6.tax_planning.may.fcp,
item6.tax_planning.may.tbf,
item6.tax_planning.june.tbc,
item6.tax_planning.june.fcp,
item6.tax_planning.june.tbf,
item6.tax_planning.july.tbc,
item6.tax_planning.july.fcp,
item6.tax_planning.july.tbf,
item6.tax_planning.august.tbc,
item6.tax_planning.august.fcp,
item6.tax_planning.august.tbf,
item6.tax_planning.september.tbc,
item6.tax_planning.september.fcp,
item6.tax_planning.september.tbf,
item6.tax_planning.october.tbc,
item6.tax_planning.october.fcp,
item6.tax_planning.october.tbf,
item6.tax_planning.november.tbc,
item6.tax_planning.november.fcp,
item6.tax_planning.november.tbf,
item6.tax_planning.december.tbc,
item6.tax_planning.december.fcp,
item6.tax_planning.december.tbf,
item6.tax_planning.total_current_year,
item6.tax_planning.total_next_year.tbc,
item6.tax_planning.total_next_year.fcp,
item6.tax_planning.total_next_year.tbf,
item6.tax_planning.total_more_year.tbc,
item6.tax_planning.total_more_year.fcp,
item6.tax_planning.total_more_year.tbf
])
} else {
dataTable.push([
item6.type_report_id,
item6.type_report_tax.value_tbc.type_report_id,
item6.type_report_tax.value_fc.type_report_id,
item6.type_report_tax.value_tbf.type_report_id,
item6.id,
item6.parent,
item6.formula,
item6.level,
item6.description,
item6.tax_planning.january.tbc,
item6.tax_planning.january.fcp,
item6.tax_planning.january.tbf,
item6.tax_planning.february.tbc,
item6.tax_planning.february.fcp,
item6.tax_planning.february.tbf,
item6.tax_planning.march.tbc,
item6.tax_planning.march.fcp,
item6.tax_planning.march.tbf,
item6.tax_planning.april.tbc,
item6.tax_planning.april.fcp,
item6.tax_planning.april.tbf,
item6.tax_planning.may.tbc,
item6.tax_planning.may.fcp,
item6.tax_planning.may.tbf,
item6.tax_planning.june.tbc,
item6.tax_planning.june.fcp,
item6.tax_planning.june.tbf,
item6.tax_planning.july.tbc,
item6.tax_planning.july.fcp,
item6.tax_planning.july.tbf,
item6.tax_planning.august.tbc,
item6.tax_planning.august.fcp,
item6.tax_planning.august.tbf,
item6.tax_planning.september.tbc,
item6.tax_planning.september.fcp,
item6.tax_planning.september.tbf,
item6.tax_planning.october.tbc,
item6.tax_planning.october.fcp,
item6.tax_planning.october.tbf,
item6.tax_planning.november.tbc,
item6.tax_planning.november.fcp,
item6.tax_planning.november.tbf,
item6.tax_planning.december.tbc,
item6.tax_planning.december.fcp,
item6.tax_planning.december.tbf,
item6.tax_planning.total_current_year,
item6.tax_planning.total_next_year.tbc,
item6.tax_planning.total_next_year.fcp,
item6.tax_planning.total_next_year.tbf,
item6.tax_planning.total_more_year.tbc,
item6.tax_planning.total_more_year.fcp,
item6.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
item5.type_report_id,
item5.type_report_tax.value_tbc.type_report_id,
item5.type_report_tax.value_fc.type_report_id,
item5.type_report_tax.value_tbf.type_report_id,
item5.id,
item5.parent,
item5.formula,
item5.level,
item5.description,
item5.tax_planning.january.tbc,
item5.tax_planning.january.fcp,
item5.tax_planning.january.tbf,
item5.tax_planning.february.tbc,
item5.tax_planning.february.fcp,
item5.tax_planning.february.tbf,
item5.tax_planning.march.tbc,
item5.tax_planning.march.fcp,
item5.tax_planning.march.tbf,
item5.tax_planning.april.tbc,
item5.tax_planning.april.fcp,
item5.tax_planning.april.tbf,
item5.tax_planning.may.tbc,
item5.tax_planning.may.fcp,
item5.tax_planning.may.tbf,
item5.tax_planning.june.tbc,
item5.tax_planning.june.fcp,
item5.tax_planning.june.tbf,
item5.tax_planning.july.tbc,
item5.tax_planning.july.fcp,
item5.tax_planning.july.tbf,
item5.tax_planning.august.tbc,
item5.tax_planning.august.fcp,
item5.tax_planning.august.tbf,
item5.tax_planning.september.tbc,
item5.tax_planning.september.fcp,
item5.tax_planning.september.tbf,
item5.tax_planning.october.tbc,
item5.tax_planning.october.fcp,
item5.tax_planning.october.tbf,
item5.tax_planning.november.tbc,
item5.tax_planning.november.fcp,
item5.tax_planning.november.tbf,
item5.tax_planning.december.tbc,
item5.tax_planning.december.fcp,
item5.tax_planning.december.tbf,
item5.tax_planning.total_current_year,
item5.tax_planning.total_next_year.tbc,
item5.tax_planning.total_next_year.fcp,
item5.tax_planning.total_next_year.tbf,
item5.tax_planning.total_more_year.tbc,
item5.tax_planning.total_more_year.fcp,
item5.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
item4.type_report_id,
item4.type_report_tax.value_tbc.type_report_id,
item4.type_report_tax.value_fc.type_report_id,
item4.type_report_tax.value_tbf.type_report_id,
item4.id,
item4.parent,
item4.formula,
item4.level,
item4.description,
item4.tax_planning.january.tbc,
item4.tax_planning.january.fcp,
item4.tax_planning.january.tbf,
item4.tax_planning.february.tbc,
item4.tax_planning.february.fcp,
item4.tax_planning.february.tbf,
item4.tax_planning.march.tbc,
item4.tax_planning.march.fcp,
item4.tax_planning.march.tbf,
item4.tax_planning.april.tbc,
item4.tax_planning.april.fcp,
item4.tax_planning.april.tbf,
item4.tax_planning.may.tbc,
item4.tax_planning.may.fcp,
item4.tax_planning.may.tbf,
item4.tax_planning.june.tbc,
item4.tax_planning.june.fcp,
item4.tax_planning.june.tbf,
item4.tax_planning.july.tbc,
item4.tax_planning.july.fcp,
item4.tax_planning.july.tbf,
item4.tax_planning.august.tbc,
item4.tax_planning.august.fcp,
item4.tax_planning.august.tbf,
item4.tax_planning.september.tbc,
item4.tax_planning.september.fcp,
item4.tax_planning.september.tbf,
item4.tax_planning.october.tbc,
item4.tax_planning.october.fcp,
item4.tax_planning.october.tbf,
item4.tax_planning.november.tbc,
item4.tax_planning.november.fcp,
item4.tax_planning.november.tbf,
item4.tax_planning.december.tbc,
item4.tax_planning.december.fcp,
item4.tax_planning.december.tbf,
item4.tax_planning.total_current_year,
item4.tax_planning.total_next_year.tbc,
item4.tax_planning.total_next_year.fcp,
item4.tax_planning.total_next_year.tbf,
item4.tax_planning.total_more_year.tbc,
item4.tax_planning.total_more_year.fcp,
item4.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
item3.type_report_id,
item3.type_report_tax.value_tbc.type_report_id,
item3.type_report_tax.value_fc.type_report_id,
item3.type_report_tax.value_tbf.type_report_id,
item3.id,
item3.parent,
item3.formula,
item3.level,
item3.description,
item3.tax_planning.january.tbc,
item3.tax_planning.january.fcp,
item3.tax_planning.january.tbf,
item3.tax_planning.february.tbc,
item3.tax_planning.february.fcp,
item3.tax_planning.february.tbf,
item3.tax_planning.march.tbc,
item3.tax_planning.march.fcp,
item3.tax_planning.march.tbf,
item3.tax_planning.april.tbc,
item3.tax_planning.april.fcp,
item3.tax_planning.april.tbf,
item3.tax_planning.may.tbc,
item3.tax_planning.may.fcp,
item3.tax_planning.may.tbf,
item3.tax_planning.june.tbc,
item3.tax_planning.june.fcp,
item3.tax_planning.june.tbf,
item3.tax_planning.july.tbc,
item3.tax_planning.july.fcp,
item3.tax_planning.july.tbf,
item3.tax_planning.august.tbc,
item3.tax_planning.august.fcp,
item3.tax_planning.august.tbf,
item3.tax_planning.september.tbc,
item3.tax_planning.september.fcp,
item3.tax_planning.september.tbf,
item3.tax_planning.october.tbc,
item3.tax_planning.october.fcp,
item3.tax_planning.october.tbf,
item3.tax_planning.november.tbc,
item3.tax_planning.november.fcp,
item3.tax_planning.november.tbf,
item3.tax_planning.december.tbc,
item3.tax_planning.december.fcp,
item3.tax_planning.december.tbf,
item3.tax_planning.total_current_year,
item3.tax_planning.total_next_year.tbc,
item3.tax_planning.total_next_year.fcp,
item3.tax_planning.total_next_year.tbf,
item3.tax_planning.total_more_year.tbc,
item3.tax_planning.total_more_year.fcp,
item3.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
item2.type_report_id,
item2.type_report_tax.value_tbc.type_report_id,
item2.type_report_tax.value_fc.type_report_id,
item2.type_report_tax.value_tbf.type_report_id,
item2.id,
item2.parent,
item2.formula,
item2.level,
item2.description,
item2.tax_planning.january.tbc,
item2.tax_planning.january.fcp,
item2.tax_planning.january.tbf,
item2.tax_planning.february.tbc,
item2.tax_planning.february.fcp,
item2.tax_planning.february.tbf,
item2.tax_planning.march.tbc,
item2.tax_planning.march.fcp,
item2.tax_planning.march.tbf,
item2.tax_planning.april.tbc,
item2.tax_planning.april.fcp,
item2.tax_planning.april.tbf,
item2.tax_planning.may.tbc,
item2.tax_planning.may.fcp,
item2.tax_planning.may.tbf,
item2.tax_planning.june.tbc,
item2.tax_planning.june.fcp,
item2.tax_planning.june.tbf,
item2.tax_planning.july.tbc,
item2.tax_planning.july.fcp,
item2.tax_planning.july.tbf,
item2.tax_planning.august.tbc,
item2.tax_planning.august.fcp,
item2.tax_planning.august.tbf,
item2.tax_planning.september.tbc,
item2.tax_planning.september.fcp,
item2.tax_planning.september.tbf,
item2.tax_planning.october.tbc,
item2.tax_planning.october.fcp,
item2.tax_planning.october.tbf,
item2.tax_planning.november.tbc,
item2.tax_planning.november.fcp,
item2.tax_planning.november.tbf,
item2.tax_planning.december.tbc,
item2.tax_planning.december.fcp,
item2.tax_planning.december.tbf,
item2.tax_planning.total_current_year,
item2.tax_planning.total_next_year.tbc,
item2.tax_planning.total_next_year.fcp,
item2.tax_planning.total_next_year.tbf,
item2.tax_planning.total_more_year.tbc,
item2.tax_planning.total_more_year.fcp,
item2.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
item1.type_report_id,
item1.type_report_tax.value_tbc.type_report_id,
item1.type_report_tax.value_fc.type_report_id,
item1.type_report_tax.value_tbf.type_report_id,
item1.id,
item1.parent,
item1.formula,
item1.level,
item1.description,
item1.tax_planning.january.tbc,
item1.tax_planning.january.fcp,
item1.tax_planning.january.tbf,
item1.tax_planning.february.tbc,
item1.tax_planning.february.fcp,
item1.tax_planning.february.tbf,
item1.tax_planning.march.tbc,
item1.tax_planning.march.fcp,
item1.tax_planning.march.tbf,
item1.tax_planning.april.tbc,
item1.tax_planning.april.fcp,
item1.tax_planning.april.tbf,
item1.tax_planning.may.tbc,
item1.tax_planning.may.fcp,
item1.tax_planning.may.tbf,
item1.tax_planning.june.tbc,
item1.tax_planning.june.fcp,
item1.tax_planning.june.tbf,
item1.tax_planning.july.tbc,
item1.tax_planning.july.fcp,
item1.tax_planning.july.tbf,
item1.tax_planning.august.tbc,
item1.tax_planning.august.fcp,
item1.tax_planning.august.tbf,
item1.tax_planning.september.tbc,
item1.tax_planning.september.fcp,
item1.tax_planning.september.tbf,
item1.tax_planning.october.tbc,
item1.tax_planning.october.fcp,
item1.tax_planning.october.tbf,
item1.tax_planning.november.tbc,
item1.tax_planning.november.fcp,
item1.tax_planning.november.tbf,
item1.tax_planning.december.tbc,
item1.tax_planning.december.fcp,
item1.tax_planning.december.tbf,
item1.tax_planning.total_current_year,
item1.tax_planning.total_next_year.tbc,
item1.tax_planning.total_next_year.fcp,
item1.tax_planning.total_next_year.tbf,
item1.tax_planning.total_more_year.tbc,
item1.tax_planning.total_more_year.fcp,
item1.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
itemss.type_report_id,
itemss.type_report_tax.value_tbc.type_report_id,
itemss.type_report_tax.value_fc.type_report_id,
itemss.type_report_tax.value_tbf.type_report_id,
itemss.id,
itemss.parent,
itemss.formula,
itemss.level,
itemss.description,
itemss.tax_planning.january.tbc,
itemss.tax_planning.january.fcp,
itemss.tax_planning.january.tbf,
itemss.tax_planning.february.tbc,
itemss.tax_planning.february.fcp,
itemss.tax_planning.february.tbf,
itemss.tax_planning.march.tbc,
itemss.tax_planning.march.fcp,
itemss.tax_planning.march.tbf,
itemss.tax_planning.april.tbc,
itemss.tax_planning.april.fcp,
itemss.tax_planning.april.tbf,
itemss.tax_planning.may.tbc,
itemss.tax_planning.may.fcp,
itemss.tax_planning.may.tbf,
itemss.tax_planning.june.tbc,
itemss.tax_planning.june.fcp,
itemss.tax_planning.june.tbf,
itemss.tax_planning.july.tbc,
itemss.tax_planning.july.fcp,
itemss.tax_planning.july.tbf,
itemss.tax_planning.august.tbc,
itemss.tax_planning.august.fcp,
itemss.tax_planning.august.tbf,
itemss.tax_planning.september.tbc,
itemss.tax_planning.september.fcp,
itemss.tax_planning.september.tbf,
itemss.tax_planning.october.tbc,
itemss.tax_planning.october.fcp,
itemss.tax_planning.october.tbf,
itemss.tax_planning.november.tbc,
itemss.tax_planning.november.fcp,
itemss.tax_planning.november.tbf,
itemss.tax_planning.december.tbc,
itemss.tax_planning.december.fcp,
itemss.tax_planning.december.tbf,
itemss.tax_planning.total_current_year,
itemss.tax_planning.total_next_year.tbc,
itemss.tax_planning.total_next_year.fcp,
itemss.tax_planning.total_next_year.tbf,
itemss.tax_planning.total_more_year.tbc,
itemss.tax_planning.total_more_year.fcp,
itemss.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
items.type_report_id,
items.type_report_tax.value_tbc.type_report_id,
items.type_report_tax.value_fc.type_report_id,
items.type_report_tax.value_tbf.type_report_id,
items.id,
items.parent,
items.formula,
items.level,
items.description,
items.tax_planning.january.tbc,
items.tax_planning.january.fcp,
items.tax_planning.january.tbf,
items.tax_planning.february.tbc,
items.tax_planning.february.fcp,
items.tax_planning.february.tbf,
items.tax_planning.march.tbc,
items.tax_planning.march.fcp,
items.tax_planning.march.tbf,
items.tax_planning.april.tbc,
items.tax_planning.april.fcp,
items.tax_planning.april.tbf,
items.tax_planning.may.tbc,
items.tax_planning.may.fcp,
items.tax_planning.may.tbf,
items.tax_planning.june.tbc,
items.tax_planning.june.fcp,
items.tax_planning.june.tbf,
items.tax_planning.july.tbc,
items.tax_planning.july.fcp,
items.tax_planning.july.tbf,
items.tax_planning.august.tbc,
items.tax_planning.august.fcp,
items.tax_planning.august.tbf,
items.tax_planning.september.tbc,
items.tax_planning.september.fcp,
items.tax_planning.september.tbf,
items.tax_planning.october.tbc,
items.tax_planning.october.fcp,
items.tax_planning.october.tbf,
items.tax_planning.november.tbc,
items.tax_planning.november.fcp,
items.tax_planning.november.tbf,
items.tax_planning.december.tbc,
items.tax_planning.december.fcp,
items.tax_planning.december.tbf,
items.tax_planning.total_current_year,
items.tax_planning.total_next_year.tbc,
items.tax_planning.total_next_year.fcp,
items.tax_planning.total_next_year.tbf,
items.tax_planning.total_more_year.tbc,
items.tax_planning.total_more_year.fcp,
items.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
val.type_report_id,
val.type_report_tax.value_tbc.type_report_id,
val.type_report_tax.value_fc.type_report_id,
val.type_report_tax.value_tbf.type_report_id,
val.id,
val.parent,
val.formula,
val.level,
val.description,
val.tax_planning.january.tbc,
val.tax_planning.january.fcp,
val.tax_planning.january.tbf,
val.tax_planning.february.tbc,
val.tax_planning.february.fcp,
val.tax_planning.february.tbf,
val.tax_planning.march.tbc,
val.tax_planning.march.fcp,
val.tax_planning.march.tbf,
val.tax_planning.april.tbc,
val.tax_planning.april.fcp,
val.tax_planning.april.tbf,
val.tax_planning.may.tbc,
val.tax_planning.may.fcp,
val.tax_planning.may.tbf,
val.tax_planning.june.tbc,
val.tax_planning.june.fcp,
val.tax_planning.june.tbf,
val.tax_planning.july.tbc,
val.tax_planning.july.fcp,
val.tax_planning.july.tbf,
val.tax_planning.august.tbc,
val.tax_planning.august.fcp,
val.tax_planning.august.tbf,
val.tax_planning.september.tbc,
val.tax_planning.september.fcp,
val.tax_planning.september.tbf,
val.tax_planning.october.tbc,
val.tax_planning.october.fcp,
val.tax_planning.october.tbf,
val.tax_planning.november.tbc,
val.tax_planning.november.fcp,
val.tax_planning.november.tbf,
val.tax_planning.december.tbc,
val.tax_planning.december.fcp,
val.tax_planning.december.tbf,
val.tax_planning.total_current_year,
val.tax_planning.total_next_year.tbc,
val.tax_planning.total_next_year.fcp,
val.tax_planning.total_next_year.tbf,
val.tax_planning.total_more_year.tbc,
val.tax_planning.total_more_year.fcp,
val.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
i.type_report_id,
i.type_report_tax.value_tbc.type_report_id,
i.type_report_tax.value_fc.type_report_id,
i.type_report_tax.value_tbf.type_report_id,
i.id,
i.parent,
i.formula,
i.level,
i.description,
i.tax_planning.january.tbc,
i.tax_planning.january.fcp,
i.tax_planning.january.tbf,
i.tax_planning.february.tbc,
i.tax_planning.february.fcp,
i.tax_planning.february.tbf,
i.tax_planning.march.tbc,
i.tax_planning.march.fcp,
i.tax_planning.march.tbf,
i.tax_planning.april.tbc,
i.tax_planning.april.fcp,
i.tax_planning.april.tbf,
i.tax_planning.may.tbc,
i.tax_planning.may.fcp,
i.tax_planning.may.tbf,
i.tax_planning.june.tbc,
i.tax_planning.june.fcp,
i.tax_planning.june.tbf,
i.tax_planning.july.tbc,
i.tax_planning.july.fcp,
i.tax_planning.july.tbf,
i.tax_planning.august.tbc,
i.tax_planning.august.fcp,
i.tax_planning.august.tbf,
i.tax_planning.september.tbc,
i.tax_planning.september.fcp,
i.tax_planning.september.tbf,
i.tax_planning.october.tbc,
i.tax_planning.october.fcp,
i.tax_planning.october.tbf,
i.tax_planning.november.tbc,
i.tax_planning.november.fcp,
i.tax_planning.november.tbf,
i.tax_planning.december.tbc,
i.tax_planning.december.fcp,
i.tax_planning.december.tbf,
i.tax_planning.total_current_year,
i.tax_planning.total_next_year.tbc,
i.tax_planning.total_next_year.fcp,
i.tax_planning.total_next_year.tbf,
i.tax_planning.total_more_year.tbc,
i.tax_planning.total_more_year.fcp,
i.tax_planning.total_more_year.tbf
])
}
} else {
dataTable.push([
i.type_report_id,
i.type_report_tax.value_tbc.type_report_id,
i.type_report_tax.value_fc.type_report_id,
i.type_report_tax.value_tbf.type_report_id,
i.id,
i.parent,
i.formula,
i.level,
i.description,
i.tax_planning.january.tbc,
i.tax_planning.january.fcp,
i.tax_planning.january.tbf,
i.tax_planning.february.tbc,
i.tax_planning.february.fcp,
i.tax_planning.february.tbf,
i.tax_planning.march.tbc,
i.tax_planning.march.fcp,
i.tax_planning.march.tbf,
i.tax_planning.april.tbc,
i.tax_planning.april.fcp,
i.tax_planning.april.tbf,
i.tax_planning.may.tbc,
i.tax_planning.may.fcp,
i.tax_planning.may.tbf,
i.tax_planning.june.tbc,
i.tax_planning.june.fcp,
i.tax_planning.june.tbf,
i.tax_planning.july.tbc,
i.tax_planning.july.fcp,
i.tax_planning.july.tbf,
i.tax_planning.august.tbc,
i.tax_planning.august.fcp,
i.tax_planning.august.tbf,
i.tax_planning.september.tbc,
i.tax_planning.september.fcp,
i.tax_planning.september.tbf,
i.tax_planning.october.tbc,
i.tax_planning.october.fcp,
i.tax_planning.october.tbf,
i.tax_planning.november.tbc,
i.tax_planning.november.fcp,
i.tax_planning.november.tbf,
i.tax_planning.december.tbc,
i.tax_planning.december.fcp,
i.tax_planning.december.tbf,
i.tax_planning.total_current_year,
i.tax_planning.total_next_year.tbc,
i.tax_planning.total_next_year.fcp,
i.tax_planning.total_next_year.tbf,
i.tax_planning.total_more_year.tbc,
i.tax_planning.total_more_year.fcp,
i.tax_planning.total_more_year.tbf
])
}
})
} else {
dataTable.push([
item.type_report_id,
item.type_report_tax.value_tbc.type_report_id,
item.type_report_tax.value_fc.type_report_id,
item.type_report_tax.value_tbf.type_report_id,
item.id,
item.parent,
item.formula,
item.level,
item.description,
item.tax_planning.january.tbc,
item.tax_planning.january.fcp,
item.tax_planning.january.tbf,
item.tax_planning.february.tbc,
item.tax_planning.february.fcp,
item.tax_planning.february.tbf,
item.tax_planning.march.tbc,
item.tax_planning.march.fcp,
item.tax_planning.march.tbf,
item.tax_planning.april.tbc,
item.tax_planning.april.fcp,
item.tax_planning.april.tbf,
item.tax_planning.may.tbc,
item.tax_planning.may.fcp,
item.tax_planning.may.tbf,
item.tax_planning.june.tbc,
item.tax_planning.june.fcp,
item.tax_planning.june.tbf,
item.tax_planning.july.tbc,
item.tax_planning.july.fcp,
item.tax_planning.july.tbf,
item.tax_planning.august.tbc,
item.tax_planning.august.fcp,
item.tax_planning.august.tbf,
item.tax_planning.september.tbc,
item.tax_planning.september.fcp,
item.tax_planning.september.tbf,
item.tax_planning.october.tbc,
item.tax_planning.october.fcp,
item.tax_planning.october.tbf,
item.tax_planning.november.tbc,
item.tax_planning.november.fcp,
item.tax_planning.november.tbf,
item.tax_planning.december.tbc,
item.tax_planning.december.fcp,
item.tax_planning.december.tbf,
item.tax_planning.total_current_year,
item.tax_planning.total_next_year.tbc,
item.tax_planning.total_next_year.fcp,
item.tax_planning.total_next_year.tbf,
item.tax_planning.total_more_year.tbc,
item.tax_planning.total_more_year.fcp,
item.tax_planning.total_more_year.tbf
])
}
})
console.log(dataTable);
this.setState({ dataTable, loading: false })
}
} else {
this.setState({ loading: false })
}
})
}
handleValue(data) {
let total = 0
this.state.dataTable.map((item, index) => {
if (data.rowData[1] == item[2]) {
total = item[data.columnIndex] == undefined ? (Number(total) + 0) : (Number(total) + Number(item[data.columnIndex]))
}
})
let indexParent = this.state.dataTable.findIndex((val) => val[1] == this.state.dataTable[data.rowIndex][2])
let a = this.state.dataTable[data.rowIndex][data.columnIndex] = total
// console.log(indexParent);
return a
}
handleChange(value, tableMeta) {
let val = String(value).split(",").join("")
let data = this.state.dataTable
let indexParent = data.findIndex((val) => val[1] == data[tableMeta.rowIndex][5])
if (indexParent > 0) {
// console.log(indexParent)
let a = data[tableMeta.rowIndex][tableMeta.columnIndex] = Number(val)
let jagain = data[indexParent][tableMeta.columnIndex]
a = data[indexParent][tableMeta.columnIndex] = jagain == undefined ? (0 + Number(val)) : (jagain + Number(val))
} else {
data[tableMeta.rowIndex][tableMeta.columnIndex] = Number(val)
}
// this.forceUpdate()
// console.log(this.state.dataTable)
// this.setState({
// data: a,
// }, () => console.log(this.state.dataTable))
}
backToMasterBudget(type) {
let data = []
this.state.dataTable.map(i => {
data.push({
item_report_id: i[1],
total_actual_before: String(i[6]),
january: String(i[7]),
february: String(i[8]),
march: String(i[9]),
april: String(i[10]),
may: String(i[11]),
june: String(i[12]),
july: String(i[13]),
august: String(i[14]),
september: String(i[15]),
october: String(i[16]),
november: String(i[17]),
december: String(i[18]),
total_current_year: String(i[19]),
total_next_year: String(i[20]),
total_more_year: String(i[21])
})
})
let payload = {
"submission_id": this.props.submissionID,
"company_id": this.props.company.company_id,
"periode": this.props.periode,
"report_id": this.props.report_id,
"status": type,
"balance_sheet": data
}
// console.log(data);
this.props.saveToMasterBudget(payload)
this.props.onClickClose()
}
downloadTemplate = async () => {
let res = await fetch(
`https://tia.eksad.com/tia-reporting-dev/public/transaction/master_budget/download_template?report_id=${this.props.report_id}&&company_id=${this.props.company.company_id}&&year=${this.props.periode}`
)
res = await res.blob()
console.log(res)
if (res.size > 0) {
let url = window.URL.createObjectURL(res);
let a = document.createElement('a');
a.href = url;
a.download = 'Template Tax Planning.xlsx';
a.click();
}
}
render() {
let dataTable2 = this.state.dataTable
const handleChange = (value, tableMeta) => {
let val = String(value).split(",").join("")
// let data = this.state.dataTable2
let indexParent = dataTable2.findIndex((val) => val[4] == dataTable2[tableMeta.rowIndex][5])
if (indexParent > 0) {
// console.log(indexParent)
let a = dataTable2[tableMeta.rowIndex][tableMeta.columnIndex] = Number(val)
let jagain = dataTable2[indexParent][tableMeta.columnIndex]
a = dataTable2[indexParent][tableMeta.columnIndex] = jagain == undefined ? (0 + Number(val)) : (jagain + Number(val))
} else {
dataTable2[tableMeta.rowIndex][tableMeta.columnIndex] = Number(val)
}
}
const handleValue = (data) => {
let total = 0
dataTable2.map((item, index) => {
if (data.rowData[4] == item[5]) {
total = item[data.columnIndex] == undefined ? (Number(total) + 0) : (Number(total) + Number(item[data.columnIndex]))
}
})
let indexParent = dataTable2.findIndex((val) => val[4] == dataTable2[data.rowIndex][5])
let a = dataTable2[data.rowIndex][data.columnIndex] = Number(total)
// console.log(indexParent);
return a
}
const handleFormula = (data, tableMeta) => {
let arrayFormula = tableMeta.rowData[6].match(/[a-zA-Z]+|[0-9]+|[-!$%^&*()_+|~=`{}\[\]:";'<>?,.\/]+(?:\.[0-9]+@|)/g)
let arrayJumlah = []
arrayFormula.map((item, indexs) => {
let index = dataTable2.findIndex((val) => val[4] == item)
if (index > 0) {
arrayJumlah.push(dataTable2[index][tableMeta.columnIndex])
} else {
arrayJumlah.push(item)
}
// if (indexs % 2 !== 0) {
// operator.push(item)
// }
})
let array = arrayJumlah
let total = 0
let opt = ""
array.map((item, index) => {
if (item == "+") {
opt = "tambah"
} else if (item == "-") {
opt = "kurang"
} else if (item == "*") {
opt = "kali"
} else if (item == "/") {
opt = "bagi"
} else {
if (opt == "tambah") {
total = Number(total) + Number(item)
} else if (opt == "kurang") {
total = Number(total) - Number(item)
} else if (opt == "kali") {
total = Number(total) * Number(item)
} else if (opt == "bagi") {
total = Number(total) / Number(item)
} else {
total += item
}
}
})
let a = dataTable2[tableMeta.rowIndex][tableMeta.columnIndex] = Number(total)
return a
}
const columns = [{
name: "",
options: {
display: false
}
}, {
name: "",
options: {
display: false
}
}, {
name: "",
options: {
display: false
}
}, {
name: "",
options: {
display: false
}
}, {
name: "",
options: {
display: false
}
},{
name: "",
options: {
display: false
}
}, {
name: "",
options: {
display: false
}
}, {
name: "",
options: {
display: false
}
}, {
name: "Account",
options: {
customHeadRender: (columnMeta) => (