import { createMuiTheme, FormControlLabel, MuiThemeProvider, Paper, Snackbar, TableCell, Tooltip, Typography, withStyles } from '@material-ui/core' import MUIDataTable from 'mui-datatables'; import React, { Component } from 'react' import NumberFormat from 'react-number-format'; import ReactTooltip from 'react-tooltip'; import api from '../../api'; import Images from '../../assets/Images'; import * as R from 'ramda' import { PropagateLoader } from 'react-spinners'; import Constant from '../../library/Constant'; import { Alert } from '@material-ui/lab'; var ct = require("../../library/CustomTable"); const getMuiTheme = () => createMuiTheme(ct.customTable3()); const options = ct.customOptionsFixedColumn(); const style = { position: "sticky", left: 0, background: "white", zIndex: 101, }; const style2 = { position: "sticky", background: "white", zIndex: 100 }; const LightTooltip = withStyles((theme) => ({ tooltip: { backgroundColor: theme.palette.common.white, color: 'rgba(0, 0, 0, 0.87)', boxShadow: theme.shadows[1], fontSize: 11, }, }))(Tooltip); export default class CashFlow extends Component { constructor(props) { super(props) this.state = { dataTable: [], loading: false, minValue: "0", maxValue: "0", handleTekTekTek: 0, viewOnly: true, } } handleViewOnly() { let checkApprover = false let checkLastStatus = false let checkStatus = false let checkPrevRev = false if (this.props.isApprover) { checkApprover = true } else { checkApprover = false } if (this.props.lastStatus == 'SUBMIT' || this.props.lastStatus == 'REVISION') { checkLastStatus = true } else { checkLastStatus = false } if (this.props.prevRevision) { checkPrevRev = true } else { checkPrevRev = false } if (this.props.status === 'revision' || this.props.status === 'not-yet' || this.props.status === 'draft' || this.props.status === 'submitted') { checkStatus = true } else { checkStatus = false } // console.log(this.props.status) // console.log(this.props.lastStatus) // console.log(checkStatus) // console.log(checkLastStatus) // console.log(checkApprover) // console.log(checkPrevRev) this.setState({ viewOnly: !checkApprover && checkLastStatus && checkStatus && checkPrevRev }) } componentDidMount() { console.log(this.props); this.setState({ loading: true }) this.getSettingControl() // console.log(this.props.PLBSFAMSubmitted) this.handleViewOnly() } handleGetFor(type) { this.setState({ get_for: type }, () => { // this.getLatestUpdate() this.getSettingControl() this.getItemHierarki() }) } getSettingControl() { let body = { group: 'THRESHOLD_CONTROL', company_id: this.props.company.company_id, type: 'CASH_FLOW' } api.create().getAllSettingByType(body).then(response => { console.log(response) if (response.data) { if (response.data.status === 'success') { this.setState({ minValue: response.data.data[0] ? response.data.data[0].min_value : null, maxValue: response.data.data[0] ? response.data.data[0].max_value : null, }, () => { this.getItemHierarki() }) } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning', loading: false }, () => { if (response.data.message.includes("Someone Logged In") || response.data.message.includes("Token Expired")) { setTimeout(() => { localStorage.removeItem(Constant.TOKEN) window.location.reload(); }, 1000); } }) } } else { this.setState({ alert: true, messageAlert: response.problem, tipeAlert: 'error', loading: false }) } }) } getItemHierarki() { this.setState({ loading: true }) let payload = { "company_id": this.props.company.company_id, "get_for": "edit", "quartal": this.props.quarter, "periode": this.props.periode, "report_id": this.props.report_id, "revision": Number(this.props.revision), "rolling_outlook_id": this.props.rollingOutlookID } api.create().getRollingOutlookCF(payload).then(response => { let dataTable = [] console.log(response) console.log(payload); if (response.data) { if (response.ok) { if (response.data.status == 'success') { let res = response.data.data const handlePushChild = (item) => { dataTable.push([ item.type_report_id, item.id, item.parent, item.formula, item.level, item.description, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.january, formula: item.cash_flow.january_formula } : item.cash_flow.january, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.february, formula: item.cash_flow.february_formula } : item.cash_flow.february, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.march, formula: item.cash_flow.march_formula } : item.cash_flow.march, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.april, formula: item.cash_flow.april_formula } : item.cash_flow.april, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.may, formula: item.cash_flow.may_formula } : item.cash_flow.may, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.june, formula: item.cash_flow.june_formula } : item.cash_flow.june, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.july, formula: item.cash_flow.july_formula } : item.cash_flow.july, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.august, formula: item.cash_flow.august_formula } : item.cash_flow.august, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.september, formula: item.cash_flow.september_formula } : item.cash_flow.september, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.october, formula: item.cash_flow.october_formula } : item.cash_flow.october, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.november, formula: item.cash_flow.november_formula } : item.cash_flow.november, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.december, formula: item.cash_flow.december_formula } : item.cash_flow.december, item.order, item.condition_it_should_be, item.condition_if_wrong, ]) if (item.children !== null) { if (item.children.length > 0) { item.children.map((items, indexs) => { handlePushChild(items) }) } } } res.map((item, index) => { dataTable.push([ item.type_report_id, item.id, item.parent, item.formula, item.level, item.description, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.january, formula: item.cash_flow.january_formula } : item.cash_flow.january, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.february, formula: item.cash_flow.february_formula } : item.cash_flow.february, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.march, formula: item.cash_flow.march_formula } : item.cash_flow.march, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.april, formula: item.cash_flow.april_formula } : item.cash_flow.april, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.may, formula: item.cash_flow.may_formula } : item.cash_flow.may, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.june, formula: item.cash_flow.june_formula } : item.cash_flow.june, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.july, formula: item.cash_flow.july_formula } : item.cash_flow.july, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.august, formula: item.cash_flow.august_formula } : item.cash_flow.august, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.september, formula: item.cash_flow.september_formula } : item.cash_flow.september, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.october, formula: item.cash_flow.october_formula } : item.cash_flow.october, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.november, formula: item.cash_flow.november_formula } : item.cash_flow.november, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? { value: item.cash_flow.december, formula: item.cash_flow.december_formula } : item.cash_flow.december, item.order, item.condition_it_should_be, item.condition_if_wrong, ]) if (item.children !== null) { if (item.children.length > 0) { item.children.map((items, indexs) => { handlePushChild(items) }) } } }) console.log(dataTable); this.setState({ dataTable, loading: false, dataReal: res, editable: true }, () => { this.setState({ loading: true }, () => { setTimeout(() => { this.setState({ loading: false }, () => { this.setState({ loading: true }, () => { setTimeout(() => { this.setState({ loading: false }, () => { this.setState({ loading: true }, () => { setTimeout(() => { this.setState({ loading: false }) }, 500); }) }) }, 500); }) }) }, 500); }) }) } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning', loading: false }, () => { if (response.data.message.includes("Someone Logged In") || response.data.message.includes("Token Expired")) { setTimeout(() => { localStorage.removeItem(Constant.TOKEN) window.location.reload(); }, 1000); } }) } } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'error', loading: false }) } } else { this.setState({ alert: true, messageAlert: 'Connection Timeout, please check your Connection', tipeAlert: 'error', loading: false }) } }) } async downloadAllData() { // alert('Coming Soon ...') let url = `${process.env.REACT_APP_URL_MAIN_BE}/public/transaction/cash_flow/rolling_outlook/export_rolling_outlook?rolling_outlook_id=${this.props.rollingOutlookID}&&report_id=${this.props.report_id}&&company_id=${this.props.company.company_id}&&year=${this.props.periode}&&revision=${this.props.revision}&&quartal=${this.props.quarter}` console.log(url); let res = await fetch( `${process.env.REACT_APP_URL_MAIN_BE}/public/transaction/cash_flow/rolling_outlook/export_rolling_outlook?rolling_outlook_id=${this.props.rollingOutlookID === null ? "" : this.props.rollingOutlookID}&&report_id=${this.props.report_id}&&company_id=${this.props.company.company_id}&&year=${this.props.periode}&&revision=${this.props.revision}&&quartal=${this.props.quarter}` ) res = await res.blob() if (res.size > 0) { let url = window.URL.createObjectURL(res); let a = document.createElement('a'); a.href = url; a.download = 'Rolling Outlook Cash Flow.xlsx'; a.click(); } setTimeout(() => { this.setState({ loading: false }) }, 500); } closeAlert() { this.setState({ alert: false }) } olahDataCashFlow(dataTable2) { console.log(dataTable2) let listCF = [] dataTable2.map((item, index) => { listCF.push( // { // "item_report_id": item[1], // "parent": item[2], // "formula": String(item[3]), // "item_name": item[5], // "january": String(item[7].value == undefined ? item[7] : Number(item[7].value).toFixed(1)), // "february": String(item[8].value == undefined ? item[8] : Number(item[8].value).toFixed(1)), // "march": String(item[9].value == undefined ? item[9] : Number(item[9].value).toFixed(1)), // "april": String(item[10].value == undefined ? item[10] : Number(item[10].value).toFixed(1)), // "may": String(item[11].value == undefined ? item[11] : Number(item[11].value).toFixed(1)), // "june": String(item[12].value == undefined ? item[12] : Number(item[12].value).toFixed(1)), // "july": String(item[13].value == undefined ? item[13] : Number(item[13].value).toFixed(1)), // "august": String(item[14].value == undefined ? item[14] : Number(item[14].value).toFixed(1)), // "september": String(item[15].value == undefined ? item[15] : Number(item[15].value).toFixed(1)), // "october": String(item[16].value == undefined ? item[16] : Number(item[16].value).toFixed(1)), // "november": String(item[17].value == undefined ? item[17] : Number(item[17].value).toFixed(1)), // "december": String(item[18].value == undefined ? item[18] : Number(item[18].value).toFixed(1)), // "total_current_year": String(item[19] != '' ? Number(item[19]).toFixed(1) : item[19]), // "total_next_year": String(item[20] != '' ? Number(item[20]).toFixed(1) : item[20]), // "total_more_year": String(item[21] != '' ? Number(item[21]).toFixed(1) : item[21]), // "kpi_type": "", // "max_ach": "", // "pic": "", // "strategic": "", // "total_actual_before": "", // "uom": "", // "weight": "" // } { "item_report_id": item[1], "january": String(item[6].value == undefined ? item[6] : Number(item[6].value).toFixed(1)), "february": String(item[7].value == undefined ? item[7] : Number(item[7].value).toFixed(1)), "march": String(item[8].value == undefined ? item[8] : Number(item[8].value).toFixed(1)), "april": String(item[9].value == undefined ? item[9] : Number(item[9].value).toFixed(1)), "may": String(item[10].value == undefined ? item[10] : Number(item[10].value).toFixed(1)), "june": String(item[11].value == undefined ? item[11] : Number(item[11].value).toFixed(1)), "july": String(item[12].value == undefined ? item[12] : Number(item[12].value).toFixed(1)), "august": String(item[13].value == undefined ? item[13] : Number(item[13].value).toFixed(1)), "september": String(item[14].value == undefined ? item[14] : Number(item[14].value).toFixed(1)), "october": String(item[15].value == undefined ? item[15] : Number(item[15].value).toFixed(1)), "november": String(item[16].value == undefined ? item[16] : Number(item[16].value).toFixed(1)), "december": String(item[17].value == undefined ? item[17] : Number(item[17].value).toFixed(1)), } ) }) console.log(listCF) this.createCashFlow(listCF) } createCashFlow(dbcf) { let payload = { "rolling_outlook_id": this.props.rollingOutlookID, "company_id": this.props.company.company_id, "periode": this.props.periode, "report_id": this.props.report_id, "status": "submitted", "quartal": this.props.quarter, "cash_flow": dbcf } console.log(dbcf) console.log(JSON.stringify(payload)) api.create().createRollingOutlookCF(payload).then(response => { console.log(payload); console.log(response); // console.log(JSON.stringify(payload)) if (response.data) { if (response.data.status === "success") { this.props.onClickClose() this.props.refresh() } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning', loading: false, handleTekTekTek: 0 }, () => { document.body.style.overflow = 'unset'; if (response.data.message.includes("Someone Logged In") || response.data.message.includes("Token Expired")) { setTimeout(() => { localStorage.removeItem(Constant.TOKEN) window.location.reload(); }, 1000); } this.props.onClickClose() this.props.refresh() }) } // else { // this.setState({ loading: false, handleTekTekTek: 0 }, () => { // this.props.onClickClose() // this.props.refresh() // }) // } } else { this.setState({ loading: false, handleTekTekTek: 0 }) } }) this.props.onClickClose() this.props.refresh() } render() { let dataTable2 = this.state.dataTable let loading = false const handleValueFormula = (value, tableMeta, column, periode, forecast) => { // console.log(tableMeta.rowData[5]) // console.log(column) loading = true let splitFormula = String(tableMeta.rowData[3]).split(/([()@])/) let baru = [] let anjay = [] splitFormula.map((item, index) => { let items = String(item).substr(Number(String(item).length) - 1, 1) let subForm = String(item).substr(0, Number(String(item).length) - 1) let re = /^[a-zA-Z0-9_]+$/; if (item !== "") { if (!re.test(items)) { baru.push(subForm) baru.push(items) } else { baru.push(String(item)) } } }) baru.map((item, index) => { if (item == '-' || item == '+' || item == '/' || item == '*' || item == '(' || item == ')') { anjay.push(item) } else { if (String(item).includes('#')) { if (String(item).includes('[M-1]')) { if (forecast !== undefined) { let forecastt = 0 if (column == 19) { let tst = String(item).replace('[M-1]', '') let data = 18 let period = this.props.periode - 1 let indexID = tableMeta.rowData[data].formula.findIndex((val) => val.item_formula == String(`@${tst}`) && val.periode == period) if (indexID !== -1) { let valuezz = tableMeta.rowData[data].formula[indexID].value if (tableMeta.rowData[5] == "Cash at the beginning period") { // console.log(dataTable2[tableMeta.rowIndex+1]) // console.log(dataTable2[tableMeta.rowIndex+1][data].value) let valuezzz = dataTable2[tableMeta.rowIndex][7].value forecastt += Number(valuezzz == "" ? 0 : valuezzz) } else { forecastt += Number(valuezz == "" ? 0 : valuezz) } } } if (column == 20) { let tst = String(item).replace('[M-1]', '') let data = 18 let period = this.props.periode let indexID = tableMeta.rowData[data].formula.findIndex((val) => val.item_formula == String(`@${tst}`) && val.periode == period) if (indexID !== -1) { let valuezz = tableMeta.rowData[data].formula[indexID].value if (tableMeta.rowData[5] == "Cash at the beginning period") { let valuezzz = dataTable2[tableMeta.rowIndex + 1][19] forecastt += Number(valuezzz == "" ? 0 : valuezzz) } else { forecastt += Number(valuezz == "" ? 0 : valuezz) } } } if (column == 21) { let tst = String(item).replace('[M-1]', '') let period = Number(this.props.periode) + 1 let indexID = forecast.findIndex((val) => String(val.item_formula).replace('forecast_', '') == String(`@${tst}`) && val.periode == period) if (indexID !== -1) { let valuezz = forecast[indexID].value if (tableMeta.rowData[5] == "Cash at the beginning period") { let valuezzz = dataTable2[tableMeta.rowIndex + 1][20] forecastt += Number(valuezzz == "" ? 0 : valuezzz) } else { forecastt += Number(valuezz == "" ? 0 : valuezz) } } } anjay.push(forecastt) } else { let tst = String(item).replace('[M-1]', '[M1]') // let data = column == 7 ? 18 : column - 1 // let period = data == 18 ? Number(this.props.periode) - 1 : this.props.periode // console.log(tst) let indexID = tableMeta.rowData[column].formula.findIndex((val) => val.item_formula == String(`@${tst}`)) if (indexID !== -1) { let valuezz = tableMeta.rowData[column].formula[indexID].value // if (tableMeta.rowData[5] == "Cash at the beginning period" && column == 9) { // console.log(data) // console.log(dataTable2[tableMeta.rowIndex+1][5]) // console.log(dataTable2[tableMeta.rowIndex+1][data]) // console.log(dataTable2[tableMeta.rowIndex-1][data].value) // console.log(dataTable2[tableMeta.rowIndex][data].value) // console.log(dataTable2[tableMeta.rowIndex+1][data].value) // let valuezzz = dataTable2[tableMeta.rowIndex + 1][data].value anjay.push(valuezz == "" ? 0 : valuezz) // } else { // anjay.push(valuezz == "" ? 0 : valuezz) // } } } } else { if (forecast !== undefined) { let indexID = forecast.findIndex((val) => String(val.item_formula).replace('forecast_', '') == String(`@${item}`) && val.periode == Number(periode)) if (indexID !== -1) { let valuezz = forecast[indexID].value anjay.push(valuezz == "" ? 0 : Number(valuezz)) } } else { // console.log(value) let indexID = value.formula.findIndex((val) => val.item_formula == String(`@${item}`) && val.periode == Number(this.props.periode)) if (indexID !== -1) { let valuezz = value.formula[indexID].value anjay.push(valuezz == "" ? 0 : valuezz) } } } } else { let indexID = dataTable2.findIndex((val) => val[18] == item) if (indexID !== -1) { let valuezz = dataTable2[indexID][column].value == undefined ? dataTable2[indexID][column] : dataTable2[indexID][column].value if (item == dataTable2[tableMeta.rowIndex][18]) { anjay.push(0) } else { anjay.push(valuezz == "" ? 0 : valuezz) } } else { if (item === '(-1)') { anjay.push(-1) } } } } }) let anjay2 = [] let kurung = false let item1 = [] anjay.map((item, index) => { if (item == "(") { kurung = true } else if (item == ")") { kurung = false anjay2.push(item1) item1 = [] } else { if (kurung) { item1.push(item) } else { anjay2.push(item) } } }) let total = 0 let opt = "" let totalPrio = 0 let optPrio = "" let prio = false let optPrev = "" anjay2.map((item, index) => { if (Array.isArray(item)) { prio = true optPrev = opt item.map((items, indexs) => { if (items == "+") { optPrio = "tambah" } else if (items == "-") { optPrio = "kurang" } else if (items == "*") { optPrio = "kali" } else if (items == "/") { optPrio = "bagi" } else { if (optPrio == "tambah") { totalPrio = Number(totalPrio) + Number(items) } else if (optPrio == "kurang") { totalPrio = Number(totalPrio) - Number(items) } else if (optPrio == "kali") { totalPrio = Number(totalPrio) * Number(items) } else if (optPrio == "bagi") { totalPrio = Number(totalPrio) / Number(items) == NaN ? 0 : Number(totalPrio) / Number(items) } else { totalPrio += Number(items) } } }) if (index == anjay2.length - 1) { if (opt == "tambah") { total = Number(total) + Number(totalPrio) } else if (opt == "kurang") { total = Number(total) - Number(totalPrio) } else if (opt == "kali") { total = Number(total) * Number(totalPrio) } else if (opt == "bagi") { total = Number(total) / Number(totalPrio) == NaN ? 0 : Number(total) / Number(totalPrio) } else { total += Number(totalPrio) } } } else { if (item == "+") { opt = "tambah" if (prio) { if (optPrev == "tambah") { total = Number(total) + Number(totalPrio) } else if (optPrev == "kurang") { total = Number(total) - Number(totalPrio) } else if (optPrev == "kali") { total = Number(total) * Number(totalPrio) } else if (optPrev == "bagi") { total = Number(total) / Number(totalPrio) == NaN ? 0 : Number(total) / Number(totalPrio) } else { total += Number(totalPrio) } prio = false totalPrio = 0 optPrio = "" } } else if (item == "-") { opt = "kurang" if (prio) { if (optPrev == "tambah") { total = Number(total) + Number(totalPrio) } else if (optPrev == "kurang") { total = Number(total) - Number(totalPrio) } else if (optPrev == "kali") { total = Number(total) * Number(totalPrio) } else if (optPrev == "bagi") { total = Number(total) / Number(totalPrio) == NaN ? 0 : Number(total) / Number(totalPrio) } else { total += Number(totalPrio) } prio = false totalPrio = 0 optPrio = "" } } else if (item == "*") { opt = "kali" if (prio) { if (optPrev == "tambah") { total = Number(total) + Number(totalPrio) } else if (optPrev == "kurang") { total = Number(total) - Number(totalPrio) } else if (optPrev == "kali") { total = Number(total) * Number(totalPrio) } else if (optPrev == "bagi") { total = Number(total) / Number(totalPrio) == NaN ? 0 : Number(total) / Number(totalPrio) } else { total += Number(totalPrio) } prio = false totalPrio = 0 optPrio = "" } } else if (item == "/") { opt = "bagi" if (prio) { if (optPrev == "tambah") { total = Number(total) + Number(totalPrio) } else if (optPrev == "kurang") { total = Number(total) - Number(totalPrio) } else if (optPrev == "kali") { total = Number(total) * Number(totalPrio) } else if (optPrev == "bagi") { total = Number(total) / Number(totalPrio) == NaN ? 0 : Number(total) / Number(totalPrio) } else { total += Number(totalPrio) } prio = false totalPrio = 0 optPrio = "" } } 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) == NaN ? 0 : Number(total) / Number(item) } else { total += Number(item) } } } }) total = R.equals(total, NaN) ? "0.0" : total // if (column == 9 && tableMeta.rowData[1] == 3243762) { // console.log(tableMeta.rowData) // console.log(splitFormula) // console.log(baru) // console.log(anjay) // console.log(anjay2) // console.log(total) // } // if (tableMeta.rowData[5] == '2.1 Additional fixed assets and CIP' && column == 7) { // console.log(tableMeta.rowData) // console.log(splitFormula) // console.log(baru) // console.log(anjay) // console.log(anjay2) // console.log(total) // } if (dataTable2[tableMeta.rowIndex][column].value == undefined) { dataTable2[tableMeta.rowIndex][column] = total } else { dataTable2[tableMeta.rowIndex][column].value = total } loading = false return total } let columns = [ { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "(In Rupiah million)", options: { customHeadRender: (columnMeta) => ( {columnMeta.name} ), setCellProps: () => ({ style }), customBodyRender: (val, tableMeta) => { return (
{tableMeta.rowData[26] ? tableMeta.rowData[26].length > 0 ?
{tableMeta.rowData[0] === 4 ? "" : val}
: tableMeta.rowData[4] == 0 ? {String(tableMeta.rowData[0] === 4 ? "" : val).toUpperCase()} :
{tableMeta.rowData[0] === 4 ? "" : val}
: tableMeta.rowData[4] == 0 ? {String(tableMeta.rowData[0] === 4 ? "" : val).toUpperCase()} :
{tableMeta.rowData[0] === 4 ? "" : val}
}
) } } }, { name: `Rolling Outlook ${String(this.props.quarter).toLocaleUpperCase()} ${this.props.periode}`, options: { customHeadRender: (columnMeta) => ( {/* {columnMeta.name} */}
{columnMeta.name}
{"1"}
{"2"}
{"3"}
{"4"}
{"5"}
{"6"}
{"7"}
{"8"}
{"9"}
{"10"}
{"11"}
{"12"}
), setCellProps: () => ({ style2 }), customBodyRender: (val, tableMeta, updateValue) => { return (
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? : tableMeta.rowData[0] === 6 ? : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q1' || this.props.quarter === 'q2' || this.props.quarter === 'q3' ? null : (Number(tableMeta.rowData[6].value).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[6].value).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q1' || this.props.quarter === 'q2' || this.props.quarter === 'q3' ? null : (Number(tableMeta.rowData[7].value).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[7].value).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q1' || this.props.quarter === 'q2' || this.props.quarter === 'q3' ? null : (Number(tableMeta.rowData[8].value).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[8].value).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q2' || this.props.quarter === 'q3' ? null : ((this.props.quarter != 'q1' || this.props.PLBSFAMSubmitted ? Number(tableMeta.rowData[9].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[9], tableMeta, 9)).toFixed(1)) >= Number(this.state.minValue) && (this.props.quarter != 'q1' ? Number(tableMeta.rowData[9].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[9], tableMeta, 9)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q2' || this.props.quarter === 'q3' ? null : ((this.props.quarter != 'q1' || this.props.PLBSFAMSubmitted ? Number(tableMeta.rowData[10].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[10], tableMeta, 10)).toFixed(1)) >= Number(this.state.minValue) && (this.props.quarter != 'q1' ? Number(tableMeta.rowData[10].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[10], tableMeta, 10)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q2' || this.props.quarter === 'q3' ? null : ((this.props.quarter != 'q1' || this.props.PLBSFAMSubmitted ? Number(tableMeta.rowData[11].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[11], tableMeta, 11)).toFixed(1)) >= Number(this.state.minValue) && (this.props.quarter != 'q1' ? Number(tableMeta.rowData[11].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[11], tableMeta, 11)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q3' ? null : ((this.props.quarter == 'q3' || this.props.PLBSFAMSubmitted ? Number(tableMeta.rowData[12].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[12], tableMeta, 12)).toFixed(1)) >= Number(this.state.minValue) && (this.props.quarter == 'q3' ? Number(tableMeta.rowData[12].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[12], tableMeta, 12)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q3' ? null : ((this.props.quarter == 'q3' || this.props.PLBSFAMSubmitted ? Number(tableMeta.rowData[13].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[13], tableMeta, 13)).toFixed(1)) >= Number(this.state.minValue) && (this.props.quarter == 'q3' ? Number(tableMeta.rowData[13].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[13], tableMeta, 13)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? this.props.quarter === 'q3' ? null : ((this.props.quarter == 'q3' || this.props.PLBSFAMSubmitted ? Number(tableMeta.rowData[14].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[14], tableMeta, 14)).toFixed(1)) >= Number(this.state.minValue) && (this.props.quarter == 'q3' ? Number(tableMeta.rowData[14].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[14], tableMeta, 14)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? (this.props.PLBSFAMSubmitted? Number(tableMeta.rowData[15].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[15], tableMeta, 15)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[15], tableMeta, 15)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? ((this.props.PLBSFAMSubmitted? Number(tableMeta.rowData[16].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[16], tableMeta, 16)).toFixed(1)) >= Number(this.state.minValue) && (Number(handleValueFormula(tableMeta.rowData[16], tableMeta, 16)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
{ tableMeta.rowData[0] === 3 || tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 7 ? ((this.props.PLBSFAMSubmitted? Number(tableMeta.rowData[17].value).toFixed(1) : Number(handleValueFormula(tableMeta.rowData[17], tableMeta, 17)).toFixed(1)) >= Number(this.state.minValue) && (Number(handleValueFormula(tableMeta.rowData[17], tableMeta, 17)).toFixed(1)) <= Number(this.state.maxValue)) ? : : null }
) } } }, { 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: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, // { // name: "", // options: { // display: false, // customHeadRender: (columnMeta) => ( // // {/* // {columnMeta.name} // */} //
{columnMeta.name}
//
//
// {"ForeCast"} //
//
// // ), // setCellProps: () => ({ style2 }), // customBodyRender: (value, tableMeta, updateValue) => { // return ( //
// {tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null // : // tableMeta.rowData[0] === 7 ? // (Number(handleForecast(tableMeta, `${Number(this.props.periode)}`, 19)).toFixed(1) >= Number(this.state.minValue) && Number(handleForecast(tableMeta, `${Number(this.props.periode)}`, 19)).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : //
// // } // /> //
} //
// ) // } // } // }, // { // name: `${Number(this.props.periode) + 1}`, // options: { // customHeadRender: (columnMeta) => ( // // {/* // {columnMeta.name} // */} //
{columnMeta.name}
//
//
// {"ForeCast"} //
//
// // ), // setCellProps: () => ({ style2 }), // customBodyRender: (value, tableMeta, updateValue) => { // return ( //
// {tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null // : // tableMeta.rowData[0] === 7 ? // (Number(handleForecast(tableMeta, `${Number(this.props.periode) + 1}`, 20)).toFixed(1) >= Number(this.state.minValue) && Number(handleForecast(tableMeta, `${Number(this.props.periode) + 1}`, 20)).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : //
// // } // /> //
} //
// ) // } // } // }, // { // name: `${Number(this.props.periode) + 2}`, // options: { // customHeadRender: (columnMeta) => ( // // {/* // {columnMeta.name} // */} //
{columnMeta.name}
//
//
// {"ForeCast"} //
//
// // ), // setCellProps: () => ({ style2 }), // customBodyRender: (value, tableMeta, updateValue) => { // return ( //
// {tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null // : // tableMeta.rowData[0] === 7 ? // (Number(handleForecast(tableMeta, `${Number(this.props.periode) + 2}`, 21)).toFixed(1) >= Number(this.state.minValue) && Number(handleForecast(tableMeta, `${Number(this.props.periode) + 2}`, 21)).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : //
// // } // /> //
} //
// ) // } // } // } { name: "", options: { display: false } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }, ] const loadingComponent = (
); return (
Rolling Outlook & Revision CAT
this.closeAlert()}> this.closeAlert()} severity={this.state.tipeAlert}> {this.state.messageAlert}
Rolling Outlook - Cash Flow
{this.props.company.company_name} Period : {this.props.periode} {String(this.props.quarter).toLocaleUpperCase()} (rev.{this.props.revision}) in IDR mn
{loading || (this.state.loading && loadingComponent)} {!loading && }
{this.state.viewOnly &&
}
) } }