import React, { Component } from 'react'; import { Typography, Paper, TextField, MenuItem, Select, FormControlLabel, Snackbar, withStyles, createMuiTheme, MuiThemeProvider, Checkbox, Input } from '@material-ui/core'; import MUIDataTable from 'mui-datatables'; import Images from '../assets/Images'; import api from '../api'; import Autocomplete from '@material-ui/lab/Autocomplete'; import MuiAlert from '@material-ui/lab/Alert'; import { titleCase } from '../library/Utils'; import { ExcelRenderer } from 'react-excel-renderer'; import UploadFile from "../library/Upload"; import { format } from 'date-fns'; import Constant from '../library/Constant'; import PropagateLoader from "react-spinners/PropagateLoader" import { DatePicker } from '@material-ui/pickers'; import moment from 'moment'; import BalanceSheetRO from './RollingOutlook/BalanceSheetRO'; import ProfitLossRO from './RollingOutlook/ProfitLossRO'; import TaxPlanningRO from './RollingOutlook/TaxPlanningRO'; var ct = require("../library/CustomTable"); const getMuiTheme = () => createMuiTheme(ct.customTable()); const Alert = withStyles({ })((props) => ); export default class RollingOutlook extends Component { constructor(props) { super(props) this.state = { perusahaan: 'TAP Group', listRevision: null, revision: null, listPeriode: null, periode: null, listCompany: null, company: null, report_id: null, visibleRollingOutlook: true, visibleBS: false, visiblePL: false, visibleTP: false, visibleCAT: false, listAttachment: [], visibleUpload: false, revisionTable: null, alert: false, tipeAlert: '', messageAlert: '', submissionID: null, isSubmit: false, visibleTableHistory: false, isApprover: false, lastStatus: "", intent: "", approverID: null, pic: '', submitter: false, detailRevisiCheck: [], lastRevision: "", checkApprover: false, lastPeriod: '', latestPeriode: '', minDateRevision: new Date(), maxDateRevision: new Date(), btnApprove: false } this.myRef = React.createRef() this.fileHandler = this.fileHandler.bind(this); } scrollToMyRef = () => window.scrollTo(0, this.myRef.current.offsetTop) componentDidMount() { this.setState({ loading: true }) this.props.selectIndex('Rolling Outlook & CAT') if (this.props.location.state !== undefined) { console.log(this.props); this.setState({ userType: this.props.location.state.userType, intent: 'Home', lastPeriod: this.props.location.state.rawData.periode, rawData: this.props.location.state.rawData }, () => { this.checkApprover() }) } else { this.checkApprover() } } checkApprover() { api.create().checkApprover().then(response => { console.log(response); if (response.data.data.is_approver === true) { this.setState({ isApprover: true, checkApprover: true }, () => this.getPeriode()) } else { this.setState({ isApprover: false, checkApprover: false }, () => this.getDetailUser()) } }) } getCompanySubmitted() { let body = { "periode": this.state.periode.periode } api.create().getCompanySubmitted(body).then(response => { console.log(response); if (response.data) { if (response.data.status === 'success') { let data = response.data.data let companyData = data.map((item) => { return { company_id: item.company_id, company_name: item.company_name, } }) let defaultProps = { options: companyData, getOptionLabel: (option) => titleCase(option.company_name), }; this.setState({ listCompany: defaultProps, company: companyData[0] }, () => { // console.log(response.data.data); if (response.data.data.length > 0) { this.getRevision() } else { this.setState({ listRevision: null, revision: null, dataTable: [], loading: false, checkApprover: false, lastRevision: "", visibleTableHistory: false }) } // }) } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning' }, () => { if (response.data.message.includes("Someone Logged In")) { setTimeout(() => { localStorage.removeItem(Constant.TOKEN) window.location.reload(); }, 1000); } }) } } else { this.setState({ alert: true, messageAlert: response.problem, tipeAlert: 'error', listCompany: null, company: null }) } }) } getReportAttachment() { let payload = { "company_id": this.state.company.company_id, "periode": this.state.periode.periode, "revision": this.state.revision.revision, } api.create().getMasterBudgetAtt(payload).then(response => { console.log(response) if (response.data) { if (response.data.status === "success") { this.setState({ listAttachment: response.data.data }) } } // console.log(response); }) } getReport() { let payload = { "company_id": this.state.company.company_id, "periode": this.state.periode.periode, "report_type": "Rolling Outlook", } api.create().getReportTypeBody(payload).then(response => { console.log(response); if (response.data) { if (response.data.status === "success") { let dataTable = response.data.data.map((item, index) => { return [ item.number, item.report_name, item.revision, this.state.isSubmit === false ? "CLOSED" : item.current_status, item.report_id, Number(item.revision) > 0 ? (item.current_status == "not-yet" ? false : item.is_can_upload) : item.is_can_upload, item.revision ] }) let dataTableRevision = response.data.data.map((item, index) => { return [ item.report_id, item.report_name, "" ] }) // console.log(dataTable); this.setState({ dataTable, loading: false, dataTableRevision, dataForRevision: response.data.data }) } } else { this.setState({ loading: false }) } }) } getLatestPeriodSubmit() { let body = { "company_id": this.state.company.company_id, "periode": this.state.periode.periode } api.create().getSubmitMasterBudget(body).then(response => { console.log(response); if (response.data) { if (response.data.status === "success") { this.setState({ isSubmit: response.data.data.is_can_submit }, () => { this.getReport() this.getReportAttachment() }) } } }) } getDetailUser() { let userId = localStorage.getItem(Constant.USER) api.create().getDetailUser(userId).then((response) => { if (response.data) { if (response.ok) { if (response.data.status === 'success') { this.setState({ userCompany: response.data.data.company }, () => { this.getCompanyActive() }) } } } }) } getCompanyActive() { api.create().getPerusahaanActive().then((response) => { console.log(response); if (response.data) { if (response.data.status === 'success') { let data = response.data.data let comID = this.state.rawData ? this.state.rawData.company_id : 0 let companyData = data.map((item) => { return { company_id: item.company_id, company_name: item.company_name, } }) let arrayBaru = [] this.state.userCompany.map((item, index) => { let indexID = companyData.findIndex((val) => val.company_id == item) if (indexID !== -1) { arrayBaru.push(companyData[indexID]) } }) let defaultProps = { options: arrayBaru, getOptionLabel: (option) => titleCase(option.company_name), }; let index = arrayBaru.findIndex((val) => val.company_id == comID) this.setState({ listCompany: defaultProps, company: arrayBaru.length < 1 ? companyData[0] : (index == -1 ? arrayBaru[0] : arrayBaru[index]) }, () => { this.getLastPeriod() }) } else { this.setState({ alert: true, messageAlert: response.data.message, tipeAlert: 'warning' }, () => { if (response.data.message.includes("Someone Logged In")) { setTimeout(() => { localStorage.removeItem(Constant.TOKEN) window.location.reload(); }, 1000); } }) } } else { this.setState({ alert: true, messageAlert: response.problem, tipeAlert: 'error', listCompany: null, company: null }) } }) } getLastPeriod() { api.create().getLastPeriod(this.state.company.company_id).then(response => { console.log(response); if (response.data.status === "success") { this.setState({ lastPeriod: response.data.data.last_periode, latestPeriode: response.data.data.latest_periode }, () => { this.getPeriode() }) } }) } getPeriode() { api.create().getPeriodeTransaction().then(response => { // let dateNow = new Date // let year = this.state.rawData ? this.state.rawData.periode : format(dateNow, 'yyyy') let currentYear = new Date().getFullYear() // console.log(currentYear) if (response.data) { if (response.data.status === "success") { let data = [] response.data.data.map((item) => { if (this.state.isApprover) { if (item >= 2000 && item <= (Number(currentYear) + 1)) { data.push(item) } } else { if ((item >= 2000) && (item == this.state.lastPeriod || item < this.state.lastPeriod)) { data.push(item) } } }) let periodeData = data.map((item) => { return { periode: item, } }) let defaultProps = { options: periodeData, getOptionLabel: (option) => option.periode, }; let index = data.sort((a, b) => a - b).findIndex((val) => val === (this.state.lastPeriod == "" ? String(Number(currentYear) + 1) : this.state.lastPeriod)) // console.log(data) console.log(this.state.lastPeriod) // console.log(periodeData) // console.log(index) this.setState({ listPeriode: defaultProps, periode: index === -1 ? periodeData[0] : periodeData[index] }, () => { if (this.state.isApprover === true) { this.getCompanySubmitted() } else { this.getRevision() } }) } } }) } getRevision() { let payload = { "company_id": this.state.company.company_id, "periode": this.state.periode.periode } api.create().getRevision(payload).then(response => { console.log(response); if (response.data) { if (response.data.status === "success") { let data = response.data.data let revisionData = data.map((item) => { return { revision: item, } }) let defaultProps = { options: revisionData, getOptionLabel: (option) => option.revision, }; this.setState({ listRevision: defaultProps, revision: revisionData[0] }, () => { this.getSubmission() }) } } }) } getSubmission() { this.setState({ loading: true }) let payload = { "company_id": this.state.company.company_id, "periode": this.state.periode.periode, "is_approver": this.state.isApprover } api.create().getSubmission(payload).then(response => { console.log(response) if (response) { if (response.data.status === "success") { this.setState({ submissionID: response.data.data.submission_id, submitter: response.data.data.submitter, approverID: response.data.data.approve_id, pic: response.data.data.approver == null ? '' : response.data.data.approver, lastStatus: response.data.data.last_status === null ? 'SUBMIT' : response.data.data.last_status, loading: false, lastRevision: response.data.data.last_revision, btnApprove: response.data.data.is_submit }, () => { console.log(this.state.lastStatus); this.historyApproval() this.getLatestPeriodSubmit() api.create().checkApprover().then(response => { // console.log(response); if (response.data.data.is_approver === true) { this.setState({ isApprover: true, checkApprover: true }) } else { this.setState({ isApprover: this.state.lastStatus === "SUBMITTED" ? true : false, checkApprover: false }) } }) }) } else { this.setState({ submissionID: null, loading: false }) } } }) } historyApproval() { let body = { "company_id": this.state.company.company_id, "periode": this.state.periode.periode } api.create().historyApproval(body).then(response => { console.log(response); if (response.data.data.length > 0) { let dataTableHistory = response.data.data.map(item => { return [ item.pic, item.status_approval, item.remarks, item.item_revision, item.history_approval_date ] }) this.setState({ dataTableHistory, visibleTableHistory: true }) } }) } approvalSubmission(type) { this.scrollToMyRef() this.setState({ loading: true }) let body = { "approval_id": this.props.location.state == undefined ? this.state.approverID : this.state.rawData.approval_id, "status": type, "detail": this.state.detailRevisiCheck } let payload = { "company_id": this.state.company.company_id, "min_periode": moment(this.state.minDateRevision).format('YYYY-MM-DD'), "max_periode": moment(this.state.maxDateRevision).format('YYYY-MM-DD') } console.log(payload) api.create().approvalSubmission(body).then((res) => { console.log(res) this.setState({ loading: false }, () => { this.getSubmission() }) if (type == 'revision') { api.create().createPeriodeRevision(payload).then((res) => console.log(res)) } }) } clickDetail(item, id, revision, status) { console.log(this.state.dataForRevision); this.state.dataForRevision.map(i => { if (i.report_name === item) { if (i.revision !== revision) { this.setState({ prevRevision: true }) } else { this.setState({ prevRevision: false }) } } }) this.setState({ report_id: id, revisionTable: revision, status: status }, () => { if (item === 'Balance Sheet') { this.setState({ visibleRollingOutlook: false, visibleBS: true, visiblePL: false, visibleCAT: false, visibleTP: false, }) } else if (item === 'Profit Loss') { this.setState({ visibleRollingOutlook: false, visibleBS: false, visiblePL: true, visibleCAT: false, visibleTP: false, }) } else if (item === 'Tax Planning') { this.setState({ visibleRollingOutlook: false, visibleBS: false, visiblePL: false, visibleCAT: false, visibleTP: true, }) } else if (item === 'CAT') { this.setState({ visibleRollingOutlook: false, visibleBS: false, visiblePL: false, visibleCAT: true, visibleTP: false, }) } }) } handleChange(value, tableMeta) { let data = this.state.dataTable data[tableMeta.rowIndex][tableMeta.columnIndex] = value } fileHandler = (event) => { let fileObj = event ExcelRenderer(fileObj, (err, resp) => { // console.log(resp) if (err) { console.log(err); } else { const formData = new FormData(); formData.append("revision", Number(this.state.revision.revision)); formData.append("companyId", this.state.company.company_id); formData.append("periode", Number(this.state.periode.periode)); formData.append("file", event); this.setState({ formData }) } }) } uploadAttachment(formData) { api.create().uploadAttachment(formData).then(response => { if (response.data) { if (response.data.status === "success") { this.setState({ visibleUpload: false }, () => { this.getSubmission() }) } } }) } deleteAttachment(item) { api.create().deleteAttachment(item.attachment_id).then(response => { if (response.data) { if (response.data.status === "success") { this.getSubmission() } } }) } closeAlert() { this.setState({ alert: false }) } saveToMasterBudget(data) { this.setState({ loading: true }) // console.log(JSON.stringify(data)); api.create('UPLOAD').createSubmitReport(data).then(response => { console.log(response); if (response.data) { if (response.data.status === "success") { this.getSubmission() } else { this.setState({ loading: false }, () => { this.getSubmission() }) } } else { this.setState({ loading: false }, () => { this.getSubmission() }) } }) } async downloadAttachment(fileurl, name) { let length = name.split(".").length let fileType = name.split(".")[length - 1] console.log(fileType); let url = `${process.env.REACT_APP_URL_MAIN_BE}/public/transaction/master_budget/download_attachment?fileName=${fileurl}&&fileType=${fileType}` // console.log(url); let res = await fetch( `${process.env.REACT_APP_URL_MAIN_BE}/public/transaction/master_budget/download_attachment?fileName=${fileurl}&&fileType=${fileType}` ) res = await res.blob() this.setState({ loading: false }) if (res.size > 0) { let url = window.URL.createObjectURL(res); let a = document.createElement('a'); a.href = url; a.download = 'Rolling Outlook Attachment.xlsx'; a.click(); } } validate() { this.setState({ loading: true }) let array = [] let canSubmit = true this.state.dataTable.map(item => { if (item[1] !== 'Cash Flow') { if (item[3] !== "submitted" && item[3] !== 'approved') { canSubmit = false array.push(item[3]) } } // if (item[3].includes("not-yet") || item[3].includes("draft")) { // array.push(item[3]) // } else { // array.push(item[3]) // } }) if (canSubmit === true) { let body = { submission_id: this.state.submissionID } api.create().submitMasterBudget(body).then(response => { console.log(response); if (response.data) { if (response.data.status === "Success") { this.getSubmission() } } }) } else { this.setState({ alert: true, messageAlert: 'Data Is Not Complete', tipeAlert: 'warning', loading: false }) } // if (array.includes("not-yet" || "draft")) { // console.log('gagal'); // } else { // console.log('masuk'); // } } validateRevision() { let arrayRevisi = this.state.detailRevisiCheck let remarksKosong = 0 arrayRevisi.map((item,index) => { if (item.remarks == "") { remarksKosong += 1 } }) if (remarksKosong > 0) { this.setState({ alert: true, messageAlert: 'Remarks Cannot be Empty', tipeAlert: 'error' }) } else { this.setState({ visibleRevision: false }, () => this.approvalSubmission('revision')) } } render() { const handleMaxDate = () => { let handleDate = Number(moment(this.state.maxDateRevision).format('YYYYMMDD')) - Number(moment(this.state.minDateRevision).format('YYYYMMDD')) return handleDate < 0? moment(this.state.minDateRevision).format('YYYY/MM/DD') : moment(this.state.maxDateRevision).format('YYYY/MM/DD') } const columns = ["#", "Report Type", { name: "Revision", options: { customBodyRender: (val, tableMeta, updateValue) => { var list = []; for (var i = 0; i <= tableMeta.rowData[6]; i++) { list.push(i); } return (
{ // console.log(event.target) updateValue(event.target.value) this.handleChange(event.target.value, tableMeta) }} autoWidth > {list.map((item, index) => {item} )} } />
); } } }, { name: "Status", options: { customBodyRender: (val, tableMeta) => { return (
{val === "submitted" || val === "approved" ? COMPLETED : val === "draft" ? DRAFT : val === "revision" ? REVISION : val === "approval_proccess" ? APPROVAL PROCCESS : val === "approval_review" ? APPROVAL REVIEW : val === "not-yet" ? OPEN : val === "CLOSED" ? CLOSED : }
); } } }, { name: "Action", options: { customBodyRender: (val, tableMeta) => { return (
); } } }, { name: "", options: { display: false } }, { name: "", options: { display: false } }] const columnsHistory = [ "Name", "Status", "Remarks", "Revision Item", "Date" ] const columnRevisi = [ { name: "#", options: { customBodyRender: (val, tableMeta, updateValue) => { var list = []; for (var i = 0; i <= tableMeta.rowData[6]; i++) { list.push(i); } return (
val.report_id == tableMeta.rowData[0]) == -1 ? false : true} onClick={() => handleCheckRevision(tableMeta.rowData)} /> } />
); } } }, "Report Type", { name: 'Remarks', options: { customBodyRender: (value, tableMeta, updateValue) => { return (
{ // console.log(event.target.value) // updateValue(event.target.value) handleChangeText(event.target.value, tableMeta) // console.log(dataTable2) }} />} />
) } } } ] const handleChangeText = (value, tableMeta) => { let dataTableRevision = this.state.dataTableRevision dataTableRevision[tableMeta.rowIndex][tableMeta.columnIndex] = value let detailRevisiCheck = this.state.detailRevisiCheck let indexId = detailRevisiCheck.findIndex((val) => val.report_id == tableMeta.rowData[0]) if (indexId !== -1) { detailRevisiCheck[indexId].remarks = value } this.setState({ dataTableRevision, detailRevisiCheck }) } const handleCheckRevision = (value) => { let detailRevisiCheck = this.state.detailRevisiCheck let payload = { report_id: value[0], remarks: value[2] } let indexId = detailRevisiCheck.findIndex((val) => val.report_id == value[0]) if (indexId == -1) { detailRevisiCheck.push(payload) } else { detailRevisiCheck.splice(indexId, 1) } this.setState({ detailRevisiCheck }) console.log(detailRevisiCheck) } const options = { filter: false, sort: false, responsive: "scroll", print: false, download: false, selectableRows: false, viewColumns: false, pagination: false, search: false } const optionsRevision = { filter: false, sort: false, responsive: "scroll", print: false, download: false, selectableRows: false, viewColumns: false, pagination: false, search: false } const loadingComponent = (
); return (
this.closeAlert()}> this.closeAlert()} severity={this.state.tipeAlert}> {this.state.messageAlert} {this.state.loading && loadingComponent} {this.state.visibleRollingOutlook && (
Rolling Outlook & CAT Revision
Rolling Outlook & CAT
this.setState({ periode: newInputValue }, () => { if (this.state.isApprover === true) { this.getCompanySubmitted() } else { this.setState({ visibleTableHistory: false }) this.getRevision() } })} disabled={this.state.intent === 'Home' ? true : false} disableClearable style={{ width: 250 }} renderInput={(params) => } value={this.state.periode} />
this.setState({ company: newInputValue }, () => { this.setState({ visibleTableHistory: false }) this.getRevision() })} disableClearable style={{ width: 250 }} renderInput={(params) => } value={this.state.company} />
{/* this.setState({ revision: newInputValue }, () => { this.getReport() this.getReportAttachment() })} disabled={true} disableClearable style={{ width: 250 }} renderInput={(params) => } value={this.state.revision} /> */}
Attachment:
{!this.state.isApprover && (this.state.lastStatus === 'SUBMIT' && this.state.lastStatus === 'REVISION') && (
)}
{this.state.listAttachment.length > 0 ? this.state.listAttachment.map((item, index) => { return (
{index + 1}.
) }) : null }
{!this.state.isApprover && (this.state.lastStatus === 'SUBMIT' && this.state.lastStatus === 'REVISION') && (
{this.state.listAttachment.length > 0 ? this.state.listAttachment.map((item) => { return ( ) }) : null }
)}
{this.state.checkApprover === true ? this.state.lastStatus === 'WAITING FOR REVIEW' ?
{this.state.lastStatus}
: this.state.lastStatus === 'WAITING FOR YOUR APPROVAL' ?
{this.state.lastStatus}
: null : this.state.lastStatus === 'SUBMITTED' ?
{this.state.lastStatus}
: this.state.lastStatus === 'WAITING FOR APPROVAL' ?
{`${this.state.lastStatus} - ${this.state.pic}`}
: this.state.lastStatus === 'REVISION' ?
NEED REVISION
: this.state.lastStatus === 'APPROVED' ?
APPROVED
: null } {this.state.visibleTableHistory && (
)}
{this.state.checkApprover === true ? this.state.lastStatus === 'WAITING FOR REVIEW' ?
: (this.state.lastStatus === 'WAITING FOR YOUR APPROVAL' && this.state.btnApprove) ?
: null : (this.state.lastStatus === 'SUBMIT' || this.state.lastStatus === 'REVISION') && this.state.isSubmit === true ?
: this.state.lastStatus === 'SUBMITTED' && this.state.submitter ?
: null }
)} {this.state.visibleUpload && (
Upload File
{ this.fileHandler(dt) this.setState({ uploadStatus: 'idle', percentage: '0' }) }} onUpload={() => this.uploadAttachment(this.state.formData)} />
)} {this.state.visibleBS && ( this.setState({ visibleBS: false, visibleRollingOutlook: true })} /> )} {this.state.visiblePL && ( this.setState({ visiblePL: false, visibleRollingOutlook: true })} /> )} {this.state.visibleTP && ( this.setState({ visibleTP: false, visibleRollingOutlook: true })} status={this.state.status} lastStatus={this.state.lastStatus} /> )} {this.state.visibleRevision && (
Revision
You ask your subsidiary to make a revision
Timing duration you give for revision:
this.setState({minDateRevision: moment(e).format('YYYY/MM/DD')}, () => this.setState({maxDateRevision: handleMaxDate()}))} value={moment(this.state.minDateRevision).format('YYYY/MM/DD')} KeyboardButtonProps={{ 'aria-label': 'change date', }} inputProps={{ style: { fontSize: 11 } }} InputLabelProps={{ style: { fontSize: 11, color: '#7e8085' } }} style={{ padding: 0, margin: 0, width: '100%' }} />
Until
this.setState({maxDateRevision: moment(e).format('YYYY/MM/DD')})} minDate={moment(this.state.minDateRevision).format('YYYY/MM/DD')} value={moment(this.state.maxDateRevision).format('YYYY/MM/DD')} KeyboardButtonProps={{ 'aria-label': 'change date', }} inputProps={{ style: { fontSize: 11 } }} InputLabelProps={{ style: { fontSize: 11, color: '#7e8085' } }} style={{ padding: 0, margin: 0, width: '100%' }} />
)}
); } }