{"meta":{"parserVersion":1,"key":"dedb0853-3237-41b1-94b4-db88694449c7","base":{"name":"인테리어시공 매출 관리","desc":"- 수주한 인테리어공사의 기본 정보를 등록하고 전체 매출금액과 자재비용, 외주비용 및 매출이익을 관리하는 앱\n- 계약 정보는 \"인테리어시공 계약 관리\" 앱과 연동처리함","icon":"ic_app7.png"},"exporter":{"name":"웍스운영자","companyName":"다우그룹"},"exportedAt":1585752988791},"components":{"view":{"id":null,"charts":[{"id":null,"title":"연도별 매출 현황","chartType":"COLUMN","groupByCid":"_la57h37gv","subGroupByCid":"","rangeOption":"YEAR","subRangeOption":null,"goal":null,"aggMethod":"SUM","subAggMethod":"COUNT","aggCid":"_63tgpvkou","subAggCid":null,"combination":false,"stack":false,"subStack":false,"showValue":true,"theme":0},{"id":null,"title":"지역별 이익률 현황 ","chartType":"PIE","groupByCid":"_b5f6cr8gg","subGroupByCid":"","rangeOption":null,"subRangeOption":null,"goal":null,"aggMethod":"AVG","subAggMethod":"COUNT","aggCid":"_kl1yn0yy2","subAggCid":null,"combination":false,"stack":false,"subStack":false,"showValue":true,"theme":2},{"id":null,"title":"연도별 외주비용 현황","chartType":"COLUMN","groupByCid":"_la57h37gv","subGroupByCid":"","rangeOption":"YEAR","subRangeOption":null,"goal":null,"aggMethod":"SUM","subAggMethod":"COUNT","aggCid":"_tq276ghzh","subAggCid":null,"combination":false,"stack":false,"subStack":false,"showValue":true,"theme":3}],"columns":[{"id":null,"fieldCid":"_ogvav4b4v","columnName":"","width":null},{"id":null,"fieldCid":"_b5f6cr8gg","columnName":"","width":null},{"id":null,"fieldCid":"_la57h37gv","columnName":"","width":null},{"id":null,"fieldCid":"_63tgpvkou","columnName":"","width":null},{"id":null,"fieldCid":"_f4wfie4ik","columnName":"","width":null},{"id":null,"fieldCid":"_votg8i51c","columnName":"","width":null},{"id":null,"fieldCid":"_kl1yn0yy2","columnName":"","width":null}],"titleColumnIndex":0,"sortColumnIndex":2,"sortDirection":"DESC","docNoConfig":{"id":null,"useDocNo":false,"docNoType":"simple","customPrefix":null,"customDigit":2}},"form":{"id":null,"appletId":null,"data":{"type":"canvas","valueType":null,"multiple":false,"cid":"cxx1","parentCid":null,"properties":null,"components":[{"type":"columns","valueType":null,"multiple":false,"cid":"_lqhdj2f9n","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_k8qfcxmfm","parentCid":"_lqhdj2f9n","properties":{},"components":[]},{"type":"column","valueType":null,"multiple":false,"cid":"_rcivh3sxn","parentCid":"_lqhdj2f9n","properties":{},"components":[]}]},{"type":"columns","valueType":null,"multiple":false,"cid":"_tffk43kub","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_ctc9uw7ry","parentCid":"_tffk43kub","properties":{},"components":[]},{"type":"column","valueType":null,"multiple":false,"cid":"_5wg49o7pk","parentCid":"_tffk43kub","properties":{},"components":[]}]},{"type":"columns","valueType":null,"multiple":false,"cid":"_mo1trvnu4","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_bbtyzwaie","parentCid":"_mo1trvnu4","properties":{},"components":[]},{"type":"column","valueType":null,"multiple":false,"cid":"_ur95je2ip","parentCid":"_mo1trvnu4","properties":{},"components":[]}]},{"type":"hr","valueType":null,"multiple":false,"cid":"_jukah0s21","parentCid":"cxx1","properties":{},"components":[]},{"type":"label","valueType":null,"multiple":false,"cid":"_h1y36eesk","parentCid":"cxx1","properties":{"label":"◆ 매출 정보","color":"4"},"components":[]},{"type":"columns","valueType":null,"multiple":false,"cid":"_xi993tchd","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_vzt3nq3bn","parentCid":"_xi993tchd","properties":{},"components":[{"type":"number","valueType":"NUMBER","multiple":false,"cid":"_63tgpvkou","parentCid":"_vzt3nq3bn","properties":{"label":"매출금액","hideLabel":false,"guide":"","guideAsTooltip":true,"required":true,"defaultValue":"0","minLength":"0","maxLength":"1000000000","width":"150","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"useTableAutoAggr":false,"tableAggrType":"","code":"number_1"},"components":[]}]},{"type":"column","valueType":null,"multiple":false,"cid":"_bvlnpgyiv","parentCid":"_xi993tchd","properties":{},"components":[{"type":"number","valueType":"NUMBER","multiple":false,"cid":"_az02t0bai","parentCid":"_bvlnpgyiv","properties":{"label":"자재비용","hideLabel":false,"guide":"","guideAsTooltip":true,"required":true,"defaultValue":"0","minLength":"0","maxLength":"1000000000","width":"150","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"useTableAutoAggr":false,"tableAggrType":"","code":"number_2"},"components":[]}]}]},{"type":"table","valueType":null,"multiple":false,"cid":"_nsx4cdlga","parentCid":"cxx1","properties":{"label":"외주 내역","hideLabel":false,"guide":"","guideAsTooltip":true},"components":[{"type":"text","valueType":"STEXT","multiple":true,"cid":"_0ahf7omuj","parentCid":"_nsx4cdlga","properties":{"label":"참여업체명","hideLabel":false,"guide":"","guideAsTooltip":true,"required":false,"duplicate":false,"similar":false,"defaultValue":"","minLength":0,"maxLength":100,"width":100,"widthUnit":"percent","format":"all"},"components":[]},{"type":"select","valueType":"SELECT","multiple":true,"cid":"_sgqqcw3g1","parentCid":"_nsx4cdlga","properties":{"label":"참여공정","hideLabel":false,"guide":"","guideAsTooltip":true,"required":false,"defaultValue":"-999","items":[{"value":"-999","displayText":"선택안함","selected":true},{"value":"0","displayText":"가설/철거공사","selected":false},{"value":"1","displayText":"목공사","selected":false},{"value":"2","displayText":"벽체공사","selected":false},{"value":"3","displayText":"도장공사","selected":false},{"value":"4","displayText":"시트필름공사","selected":false},{"value":"5","displayText":"기타","selected":false}]},"components":[]},{"type":"number","valueType":"NUMBER","multiple":true,"cid":"_30bdi1nin","parentCid":"_nsx4cdlga","properties":{"label":"금액","hideLabel":false,"guide":"","guideAsTooltip":true,"required":true,"defaultValue":"0","minLength":"0","maxLength":"1000000000","width":"120","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"useTableAutoAggr":true,"tableAggrType":"SUM","code":"sum_1"},"components":[]}]},{"type":"columns","valueType":null,"multiple":false,"cid":"_dwetdmsfu","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_39faqzkyb","parentCid":"_dwetdmsfu","properties":{},"components":[{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_tq276ghzh","parentCid":"_39faqzkyb","properties":{"label":"외주비용","hideLabel":false,"guide":"","guideAsTooltip":true,"expressionType":"number","expression":"sum_1","width":"150","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_1"},"components":[]}]},{"type":"column","valueType":null,"multiple":false,"cid":"_i5lg65io9","parentCid":"_dwetdmsfu","properties":{},"components":[{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_f4wfie4ik","parentCid":"_i5lg65io9","properties":{"label":"비용총액","hideLabel":false,"guide":"","guideAsTooltip":true,"expressionType":"number","expression":"number_2 + formula_1","width":"150","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_2"},"components":[]}]}]},{"type":"columns","valueType":null,"multiple":false,"cid":"_n8pvw9g1f","parentCid":"cxx1","properties":{"count":2},"components":[{"type":"column","valueType":null,"multiple":false,"cid":"_pmvtx4io1","parentCid":"_n8pvw9g1f","properties":{},"components":[{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_votg8i51c","parentCid":"_pmvtx4io1","properties":{"label":"매출이익","hideLabel":false,"guide":"고정비를 제외하지 않은 금액입니다.","guideAsTooltip":false,"expressionType":"number","expression":"number_1 - formula_2","width":"150","widthUnit":"px","unitText":"원","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_3"},"components":[]}]},{"type":"column","valueType":null,"multiple":false,"cid":"_oedkp42f6","parentCid":"_n8pvw9g1f","properties":{},"components":[{"type":"formula","valueType":"NUMBER","multiple":false,"cid":"_kl1yn0yy2","parentCid":"_oedkp42f6","properties":{"label":"이익률","hideLabel":false,"guide":"","guideAsTooltip":true,"expressionType":"number","expression":"formula_3 / number_1 * 100","width":"60","widthUnit":"px","unitText":"%","fixType":"postfix","decimalPoints":"0","thousandComma":true,"code":"formula_4"},"components":[]}]}]},{"type":"textarea","valueType":"TEXT","multiple":false,"cid":"_4me2ha9m0","parentCid":"cxx1","properties":{"label":"비고","hideLabel":false,"guide":"","guideAsTooltip":true,"required":false,"defaultValue":"","width":100,"widthUnit":"percent","rows":"6"},"components":[]}]}},"process":{"id":null,"appletId":null,"useProcess":false,"statuses":[{"id":null,"name":"대기","start":true,"doing":false,"end":false,"count":null,"color":"0"},{"id":null,"name":"진행","start":false,"doing":true,"end":false,"count":null,"color":"0"},{"id":null,"name":"완료","start":false,"doing":false,"end":true,"count":null,"color":"0"}],"transitions":[{"id":null,"beforeStatus":"대기","nextStatus":"진행","actionName":"진행하기","actionRoles":["REGISTRANT","ADMIN"],"pushRoles":[]},{"id":null,"beforeStatus":"진행","nextStatus":"완료","actionName":"완료하기","actionRoles":["REGISTRANT","ADMIN"],"pushRoles":[]},{"id":null,"beforeStatus":"완료","nextStatus":"진행","actionName":"완료취소하기","actionRoles":["REGISTRANT","ADMIN"],"pushRoles":[]}],"addPushes":[]}},"messageKeys":null}