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" } } componentDidMount() { this.setState({ loading: true }) this.getSettingControl() } 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); 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() }) }) } 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 } // console.log(JSON.stringify(payload)) // if (this.props.status === 'CLOSED') { // api.create().getDetailReportCF(payload).then(response => { // console.log(response); // let dataTable = [] // // console.log(response) // 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.cash_flow.total_actual_before === null ? "0" : item.cash_flow.total_actual_before === "" ? "0" : item.cash_flow.total_actual_before, // item.cash_flow.january, // item.cash_flow.february, // item.cash_flow.march, // item.cash_flow.april, // item.cash_flow.may, // item.cash_flow.june, // item.cash_flow.july, // item.cash_flow.august, // item.cash_flow.september, // item.cash_flow.october, // item.cash_flow.november, // item.cash_flow.december, // item.cash_flow.total_current_year, // item.cash_flow.total_next_year, // item.cash_flow.total_more_year, // item.order, // item.condition_it_should_be, // item.condition_if_wrong, // item.cash_flow.forecast_formula == null ? [] : item.cash_flow.forecast_formula // ]) // 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.cash_flow.total_actual_before === null ? "0" : item.cash_flow.total_actual_before === "" ? "0" : item.cash_flow.total_actual_before, // item.cash_flow.january, // item.cash_flow.february, // item.cash_flow.march, // item.cash_flow.april, // item.cash_flow.may, // item.cash_flow.june, // item.cash_flow.july, // item.cash_flow.august, // item.cash_flow.september, // item.cash_flow.october, // item.cash_flow.november, // item.cash_flow.december, // item.cash_flow.total_current_year, // item.cash_flow.total_next_year, // item.cash_flow.total_more_year, // item.order, // item.condition_it_should_be, // item.condition_if_wrong, // item.cash_flow.forecast_formula == null ? [] : item.cash_flow.forecast_formula // ]) // if (item.children !== null) { // if (item.children.length > 0) { // item.children.map((items, indexs) => { // handlePushChild(items) // }) // } // } // }) // this.setState({ dataTable, loading: false, dataReal: res, editable: true }) // } else { // this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning', loading: false }, () => { // if (response.data.message.includes("Someone Logged In")) { // 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: response.problem, tipeAlert: 'error', loading: false }) // } // }) // } else { api.create().getDetailReportCF(payload).then(response => { let dataTable = [] // console.log(response) 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.cash_flow.total_actual_before === null ? "0" : item.cash_flow.total_actual_before === "" ? "0" : item.cash_flow.total_actual_before, 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.cash_flow.total_current_year, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? 0 : item.cash_flow.total_next_year, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? 0 : item.cash_flow.total_more_year, item.order, item.condition_it_should_be, item.condition_if_wrong, item.cash_flow.forecast_formula == null ? [] : item.cash_flow.forecast_formula ]) 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.cash_flow.total_actual_before === null ? "0" : item.cash_flow.total_actual_before === "" ? "0" : item.cash_flow.total_actual_before, 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.cash_flow.total_current_year, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? 0 : item.cash_flow.total_next_year, item.type_report_id == 5 || item.type_report_id == 6 || item.type_report_id == 7 ? 0 : item.cash_flow.total_more_year, item.order, item.condition_it_should_be, item.condition_if_wrong, item.cash_flow.forecast_formula == null ? [] : item.cash_flow.forecast_formula ]) if (item.children !== null) { if (item.children.length > 0) { item.children.map((items, indexs) => { handlePushChild(items) }) } } }) this.setState({ dataTable, loading: false, dataReal: res, editable: true }) } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning', loading: false }, () => { if (response.data.message.includes("Someone Logged In")) { 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: response.problem, tipeAlert: 'error', loading: false }) } }) // } } async downloadAllData() { // let url = `https://tia.eksad.com/tia-reporting-dev/public/transaction/master_budget/export_master_budget?submission_id=${this.props.submissionID}&&report_id=${this.props.report_id}&&company_id=${this.props.company.company_id}&&year=${this.props.periode}&&revision=${this.props.revision}` // console.log(url); let resReal = `https://tia.eksad.com/tia-reporting-dev/public/transaction/cash_flow/export_master_budget?submission_id=${this.props.submissionID}&&company_id=${this.props.company.company_id}&&year=${this.props.periode}&&revision=${this.props.revision}&&report_id=${this.props.report_id}` let resNull = `https://tia.eksad.com/tia-reporting-dev/public/transaction/cash_flow/export_master_budget?submission_id=&&company_id=${this.props.company.company_id}&&year=${this.props.periode}&&revision=${this.props.revision}&&report_id=${this.props.report_id}` let res = await fetch( this.props.submissionID == null ? resNull : resReal ) console.log(this.props.submissionID); console.log(resReal) console.log(resNull) res = await res.blob() if (res.size > 0) { let url = window.URL.createObjectURL(res); let a = document.createElement('a'); a.href = url; a.download = 'Master Budget Cash Flow.xlsx'; a.click(); this.setState({ loading: false }) } else { this.setState({ loading: false }) } } closeAlert() { this.setState({ alert: false }) } render() { let dataTable2 = this.state.dataTable let loading = false const handleValueFormula = (value, tableMeta, column, periode, forecast) => { 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)) } } }) let handledoubleFC = 0 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 == 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 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 forecastt += Number(valuezz == "" ? 0 : valuezz) } } anjay.push(forecastt) } else { let tst = String(item).replace('[M-1]', '') let data = column == 7 ? 18 : column - 1 let period = data == 18 ? Number(this.props.periode) - 1 : 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 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 { 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[22] == item) if (indexID !== -1) { let valuezz = dataTable2[indexID][column].value == undefined ? dataTable2[indexID][column] : dataTable2[indexID][column].value if (item == dataTable2[tableMeta.rowIndex][22]) { 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) } } } // if (String(tableMeta.rowData[5]).toLocaleUpperCase() == "4.0 CASH FLOW MOVEMENT" && column == 7) { // console.log(item) // console.log(totalPrio) // console.log(total) // } }) total = R.equals(total, NaN) ? "0.0" : total // // total = R.equals(total, NaN) ? "0.0" : total // // console.log(dataTable2[tableMeta.rowIndex][22]) // // console.log(tableMeta.rowData[5]) // if (tableMeta.rowData[5] == "1.5 Other non-current assets") { // if (forecast !== undefined) { // if (String(tableMeta.rowData[5]).toLocaleUpperCase() == "4.0 CASH FLOW MOVEMENT" && column == 7) { // console.log(splitFormula) // console.log(baru) // console.log(anjay) // console.log(anjay2) // console.log(total) // console.log(dataTable2[tableMeta.rowIndex]) // } // } if (dataTable2[tableMeta.rowIndex][column].value == undefined) { dataTable2[tableMeta.rowIndex][column] = total } else { dataTable2[tableMeta.rowIndex][column].value = total } loading = false return total } const handleForecast = (tableMeta, periode, column) => { let total = 0 total = handleValueFormula(dataTable2[tableMeta.rowIndex][column], tableMeta, column, periode, dataTable2[tableMeta.rowIndex][25]) 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: `MB 2021`, 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 (
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[7]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[7]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? : tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[7], tableMeta, 7)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[7], tableMeta, 7)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[8]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[8]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[8], tableMeta, 8)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[8], tableMeta, 8)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[9]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[9]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[9], tableMeta, 9)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[9], tableMeta, 9)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[10]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[10]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[10], tableMeta, 10)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[10], tableMeta, 10)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[11]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[11]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[11], tableMeta, 11)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[11], tableMeta, 11)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[12]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[12]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[12], tableMeta, 12)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[12], tableMeta, 12)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[13]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[13]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[13], tableMeta, 13)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[13], tableMeta, 13)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[14]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[14]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[14], tableMeta, 14)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[14], tableMeta, 14)).toFixed(1) <= Number(this.state.maxValue)) ? : : null }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[15]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[15]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (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 }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[16]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[16]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (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 }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[17]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[17]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (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 }
{ // this.props.status === 'CLOSED' ? // tableMeta.rowData[0] === 4 || tableMeta.rowData[0] === 1 ? // null : // tableMeta.rowData[0] === 7 ? // (Number(tableMeta.rowData[18]).toFixed(1) >= Number(this.state.minValue) && Number(tableMeta.rowData[18]).toFixed(1) <= Number(this.state.maxValue)) ? // : // // // // : // // // } // /> // : tableMeta.rowData[0] === 3 ? null //
// { // handleChange(event.target.value, tableMeta) // console.log(dataTable2) // }} // /> // } // /> //
: // null tableMeta.rowData[0] === 5 ? // null : tableMeta.rowData[0] === 4 ? null : tableMeta.rowData[0] === 6 ? // null : tableMeta.rowData[0] === 1 ? // value === "" ? // null : // null : tableMeta.rowData[0] === 7 ? (Number(handleValueFormula(tableMeta.rowData[18], tableMeta, 18)).toFixed(1) >= Number(this.state.minValue) && Number(handleValueFormula(tableMeta.rowData[18], tableMeta, 18)).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: `${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 (
Pengajuan Budget Tahunan
this.closeAlert()}> this.closeAlert()} severity={this.state.tipeAlert}> {this.state.messageAlert}
Budget Tahunan - Cash Flow
{this.props.company.company_name} Period : {this.props.periode} (rev.{this.props.revision}) in IDR mn
{loading || (this.state.loading && loadingComponent)} {!loading && }
) } }