{"formatVersion":1,"graph":{"connections":[[["5f41cfbc-2a45-4e25-8281-e78a5e43c17c",2],["6471e6c0-8555-4aad-b514-dad90725aba5",2]],[["b599d8a9-1709-48e6-9820-ebe5aec690fb",1],["6471e6c0-8555-4aad-b514-dad90725aba5",3]],[["6471e6c0-8555-4aad-b514-dad90725aba5",1],["3b374022-86dc-4f8a-9f11-d00880d4d8b3",1]],[["6471e6c0-8555-4aad-b514-dad90725aba5",1],["47191754-3694-4c0e-bc48-165b750f30f3",2]],[["3b374022-86dc-4f8a-9f11-d00880d4d8b3",2],["69b47d05-7e08-488e-bc6b-74abccc25f01",1]],[["69b47d05-7e08-488e-bc6b-74abccc25f01",2],["47191754-3694-4c0e-bc48-165b750f30f3",3]],[["47191754-3694-4c0e-bc48-165b750f30f3",1],["2b6c97de-67a3-407b-83bd-aa4963296521",1]],[["2b6c97de-67a3-407b-83bd-aa4963296521",2],["9ac3b257-1bda-4b27-afde-bd31f43e6632",1]]],"nodes":[{"$type":"importExcel","sheetNumber":1,"range":null,"hasHeaders":true,"skipErroneousRows":false,"id":"5f41cfbc-2a45-4e25-8281-e78a5e43c17c","name":"Поставки","description":null,"ports":[{"$type":"streamInputPort","id":1,"tag":null,"direction":"in","parameterId":"fe9369d3-a0fe-4fd7-b989-d9b39e3dec8f"},{"$type":"tableOutputPort","id":2,"tag":"main","direction":"out"}]},{"$type":"entityNode","model":"online_shop","entity":"product","id":"b599d8a9-1709-48e6-9820-ebe5aec690fb","name":"Справочник Товары","description":null,"ports":[{"$type":"tableOutputPort","id":1,"tag":null,"direction":"out"}]},{"$type":"joinNode","rules":[{"portId":3,"join":"left","alias":"product","addColumnPrefix":true,"condition":"Товар = product.name"}],"projectionRules":[],"mainPortId":2,"removeInputColumns":false,"id":"6471e6c0-8555-4aad-b514-dad90725aba5","name":"Присоединение к поставкам товаров","description":null,"ports":[{"$type":"tableOutputPort","id":1,"tag":null,"direction":"out"},{"$type":"tableInputPort","id":2,"tag":null,"direction":"in","parameterId":null},{"$type":"tableInputPort","id":3,"tag":null,"direction":"in","parameterId":null}]},{"$type":"filterNode","condition":"Пустой(product_id)","id":"3b374022-86dc-4f8a-9f11-d00880d4d8b3","name":"Новые товары","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"entityInsertNode","columns":[{"sourceColumn":"Товар","targetColumn":"name"}],"model":"online_shop","entity":"product","id":"69b47d05-7e08-488e-bc6b-74abccc25f01","name":"Вставка новых товаров","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":"inserted","direction":"out"}]},{"$type":"joinNode","rules":[{"portId":3,"join":"left","alias":"new_product","addColumnPrefix":true,"condition":"Пустой(product_id)\r\nИ\r\nТовар = new_product.name\r\n"}],"projectionRules":[],"mainPortId":2,"removeInputColumns":false,"id":"47191754-3694-4c0e-bc48-165b750f30f3","name":"Присоединение новых товаров","description":null,"ports":[{"$type":"tableOutputPort","id":1,"tag":null,"direction":"out"},{"$type":"tableInputPort","id":2,"tag":null,"direction":"in","parameterId":null},{"$type":"tableInputPort","id":3,"tag":null,"direction":"in","parameterId":null}]},{"$type":"projectionNode","rules":[{"$type":"addCalculatedColumn","formula":"ПервыйНеПустой(product_id; new_product_id)","columnName":"Идентификатор товара"}],"removeInputColumns":false,"sortRules":[],"id":"2b6c97de-67a3-407b-83bd-aa4963296521","name":"Определение идентификатора товара","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":null,"direction":"out"}]},{"$type":"entityInsertNode","columns":[{"sourceColumn":"Идентификатор товара","targetColumn":"productid"},{"sourceColumn":"Кол-во","targetColumn":"amount"},{"sourceColumn":"Дата поставки","targetColumn":"shipped_date"}],"model":"online_shop","entity":"supply_product","id":"9ac3b257-1bda-4b27-afde-bd31f43e6632","name":"Вставка данных в таблицу","description":null,"ports":[{"$type":"tableInputPort","id":1,"tag":null,"direction":"in","parameterId":null},{"$type":"tableOutputPort","id":2,"tag":"inserted","direction":"out"}]}]},"layout":{"paperSize":{},"nodes":{"5f41cfbc-2a45-4e25-8281-e78a5e43c17c":{"position":{"x":160,"y":180},"size":{"width":150,"height":40}},"b599d8a9-1709-48e6-9820-ebe5aec690fb":{"position":{"x":350,"y":180},"size":{"width":150,"height":40}},"6471e6c0-8555-4aad-b514-dad90725aba5":{"position":{"x":210,"y":290},"size":{"width":230,"height":40}},"3b374022-86dc-4f8a-9f11-d00880d4d8b3":{"position":{"x":310,"y":390},"size":{"width":150,"height":40}},"69b47d05-7e08-488e-bc6b-74abccc25f01":{"position":{"x":310,"y":470},"size":{"width":150,"height":40}},"47191754-3694-4c0e-bc48-165b750f30f3":{"position":{"x":230,"y":580},"size":{"width":210,"height":40}},"2b6c97de-67a3-407b-83bd-aa4963296521":{"position":{"x":230,"y":660},"size":{"width":210,"height":40}},"9ac3b257-1bda-4b27-afde-bd31f43e6632":{"position":{"x":260,"y":750},"size":{"width":150,"height":40}}},"links":{"6471e6c0-8555-4aad-b514-dad90725aba5:1#47191754-3694-4c0e-bc48-165b750f30f3:2":{"vertices":[{"x":280,"y":380}]}}},"params":[{"id":"fe9369d3-a0fe-4fd7-b989-d9b39e3dec8f","caption":"Входящий Excel","value":"Пусто","text":"","visual":true,"multiple":false,"datatype":"file"}]}