Add(MainForm,14112285,497,322)
{
 Width=860
 Height=506
 MarginLeft=3
 MarginTop=3
 MarginRight=3
 MarginBottom=3
 Border=3
 BorderStyle=1
 Position=1
}
Add(ChildScrollBox,8844261,553,371)
{
}
BEGIN_SDK
  Add(EditMulti,4271376,21,21)
  {
   WorkCount=1
   Width=727
   Height=550
   link(doWork1,879511:doEvent1,[(53,27)(53,76)])
  }
  Add(ScrollBox,964248,511,112)
  {
   Left=264
   Width=605
   Height=467
   Align=5
   WinStyle=2
   Name="scrl_001"
   BorderStyle=1
   Point(Width)
  }
  Add(ChildPanelEx,2261261,560,217)
  {
   @Hint=#19:Динамические группы|
   Mode=1
   link(onVShift,8595977:doOperation,[(606,223)(606,139)(550,139)(550,160)])
   link(onResult,4141012:doMessage,[])
   link(pWidth,964248:Width,[(566,208)(531,208)])
   link(vOffset,15893030:Var2,[])
   AddHint(39,57,130,13,@Hint)
  }
  BEGIN_SDK
    Add(EditMultiEx,3885935,21,21)
    {
     WorkCount=#5:##add|8:##select|
     EventCount=#8:onVShift|8:onResult|0:|
     VarCount=#7:##count|0:|
     DataCount=#6:pWidth|7:vOffset|
     Width=496
     Height=403
     Point(##add)
     Point(##select)
     Point(##count)
     link(##add,4250363:doEvent1,[(39,27)(39,146)])
     link(##select,1177020:doSplit,[(32,34)(32,265)])
    }
    Add(Panel,15904931,441,49)
    {
     Width=369
     Height=86
     Font=[MS Sans Serif,12,0,0,1]
     Visible=1
     Point(doWidth)
     Point(Height)
     Point(doTop)
     Point(doHeight)
     Point(doVisible)
    }
    Add(Button,11087212,91,147)
    {
     Left=2
     Top=2
     Width=95
     Height=82
     Align=1
     Font=[MS Sans Serif,12,0,0,1]
     TabOrder=-1
     Caption=""
     Point(doCaption)
     link(onClick,16401184:doEvent1,[])
    }
    Add(MTStrTbl,11520425,210,294)
    {
     Left=97
     Top=2
     Width=270
     Height=82
     Align=5
     Font=[MS Sans Serif,12,0,0,1]
     WinStyle=3
     Name="mtbl_001"
     Columns=#9:name1=150|9:name2=100|9:name3=250|9:name4=200|
     Style=4
     Grid=0
     Point(doHeight)
    }
    Add(Hub,4250363,49,140)
    {
     link(onEvent1,6740804:doOperation,[(80,146)(80,62)])
     link(onEvent2,11087212:doCaption,[])
    }
    Add(Math,6740804,175,56)
    {
     OpType=1
     Op2=18
     ResultType=0
     link(onResult,15904931:doWidth,[])
     link(Op1,3885935:pWidth,[(181,47)(27,47)])
    }
    Add(MT_Part,1177020,91,259)
    {
     link(onSplit,3091176:doCase,[])
    }
    Add(MT_String,11205836,224,245)
    {
     Delimeter="_"
     link(onResult,9614300:doRowAction,[])
    }
    Add(MST_RowAction,9614300,280,245)
    {
     MSTControl="mtbl_001"
    }
    Add(Case,3091176,147,259)
    {
     @Hint=#34:Выделение команды установки высоты|
     Value=String(-1)
     link(onNextCase,11205836:doMTString,[])
     link(onTrue,7577038:doOperation,[(193,272)(193,363)])
     AddHint(-118,113,179,26,@Hint)
    }
    Add(Math,7577038,224,357)
    {
     OpType=2
     Op2=24
     ResultType=0
     link(onResult,8700013:doEvent1,[])
     link(Op1,11520425:Count,[])
    }
    Add(Hub,8700013,280,357)
    {
     OutCount=4
     link(onEvent1,2608456:doData,[(305,363)(305,300)])
     link(onEvent2,15904931:doHeight,[(368,370)(368,76)])
     link(onEvent3,11458420:doOperation,[])
     link(onEvent4,13247899:doWork2,[(375,384)(375,111)])
    }
    Add(DoData,2608456,322,294)
    {
     link(onEventData,15904931:doTop,[(361,300)(361,69)])
     link(Data,3885935:vOffset,[(328,33)(34,33)])
    }
    Add(Math,11458420,441,371)
    {
     OpType=1
     Op2=1
     link(onResult,3885935:onVShift,[(480,377)(480,27)])
     link(Op1,15904931:Height,[])
    }
    Add(ChanelToIndex,13247899,392,98)
    {
     link(onIndex,15904931:doVisible,[(431,104)(431,83)])
    }
    Add(MST_ArrayRows,15673897,175,98)
    {
     MSTControl="mtbl_001"
    }
    Add(MT_MTArrayEnum,9756254,175,154)
    {
     link(onItem,10915627:doStr,[])
     link(Array,15673897:Strings,[])
    }
    Add(MT_String,10915627,224,154)
    {
     link(onResult,10031208:doAdd,[])
    }
    Add(StrList,10031208,280,154)
    {
    }
    Add(DoData,3602060,280,203)
    {
     link(onEventData,3885935:onResult,[(333,209)(333,34)])
     link(Data,10031208:Text,[])
    }
    Add(Hub,16401184,140,147)
    {
     OutCount=3
     link(onEvent1,10031208:doClear,[(165,153)(165,146)(263,146)(263,167)])
     link(onEvent2,9756254:doEnum,[])
     link(onEvent3,3602060:doData,[(165,167)(165,209)])
    }
  END_SDK
  Add(MT_String,11581838,189,126)
  {
   link(onResult,14798857:doValue,[])
  }
  Add(MT_MultiData,10069644,301,126)
  {
   From=2
   Count=1
   link(onData1,5953592:doCase,[])
  }
  Add(Case,5953592,357,126)
  {
   Value=String(-1)
   link(onTrue,11554508:doSeparateMT,[(396,139)(396,118)(235,118)(235,223)])
  }
  Add(MT_Memory,14798857,245,126)
  {
   link(onData,10069644:doSeparateMT,[])
  }
  Add(MT_MultiData,11554508,245,217)
  {
   Count=1
   Point(Data)
   link(onData1,2261261:##add,[])
   link(Data,14798857:Value,[])
  }
  Add(StrList,10000206,126,49)
  {
  }
  Add(Hub,879511,63,70)
  {
   OutCount=3
   link(onEvent1,10000206:doText,[])
   link(onEvent2,151755:doEnum,[(116,83)(116,146)])
   link(onEvent3,9978300:doEnum,[(109,90)(109,328)])
  }
  Add(ArrayEnum,151755,140,140)
  {
   link(onItem,11581838:doMTString,[])
   link(Array,5355832:Var2,[])
  }
  Add(ArrayEnum,9978300,126,322)
  {
   link(onItem,11602246:doMTString,[])
   link(onEndEnum,4154590:doEvent1,[(169,335)(169,475)])
   link(Array,5355832:Var1,[(132,117)])
  }
  Add(GetDataEx,5355832,140,112)
  {
   link(Data,10000206:Array,[])
  }
  Add(MT_String,11602246,189,308)
  {
   link(onResult,11144894:doValue,[])
  }
  Add(MT_Memory,11144894,245,308)
  {
   link(onData,2376732:doSeparateMT,[])
  }
  Add(MT_MultiData,2376732,301,308)
  {
   From=2
   Count=1
   link(onData1,2285829:doCase,[])
  }
  Add(Case,2285829,357,308)
  {
   Value=String(-1)
   link(onNextCase,5418568:doConvert,[])
  }
  Add(MT_MultiData,16457722,245,385)
  {
   Count=1
   Point(Data)
   link(onData1,4443410:doAdd,[])
   link(Data,11144894:Value,[])
  }
  Add(MT_Add,4443410,413,385)
  {
   InputMT=1
   link(onAdd,11319913:doWork2,[])
   link(Data,5418568:Var,[])
  }
  Add(ConvertorEx,5418568,413,308)
  {
   Mode=1
   link(onResult,16457722:doSeparateMT,[(452,314)(452,300)(235,300)(235,391)])
  }
  Add(For,5457338,413,476)
  {
   IncludeEnd=1
   link(onEvent,5228770:doAdd,[])
   link(End,2261261:##count,[(426,467)(566,467)])
  }
  Add(MT_Add,5228770,469,476)
  {
   @Hint=#35:Команда на установку высоты -- "-1"|
   Data=String(-1)
   link(onAdd,11319913:doWork3,[(515,482)])
   AddHint(13,45,183,26,@Hint)
  }
  Add(HubEx,11319913,511,385)
  {
   Angle=3
   link(onEvent,2261261:##select,[(515,230)])
  }
  Add(Math,8595977,567,154)
  {
   ResultType=0
   Point(doClear)
   link(Op2,15893030:Var1,[(580,145)(559,145)(559,194)])
  }
  Add(GetDataEx,15893030,567,189)
  {
   link(Data,8595977:Result,[])
  }
  Add(Hub,4154590,343,469)
  {
   OutCount=3
   link(onEvent1,8595977:doClear,[(396,475)(396,167)])
   link(onEvent2,5457338:doFor,[])
   link(onEvent3,3963701:doRedraw,[(375,489)(375,524)])
  }
  Add(RedrawManager,3963701,413,518)
  {
   ControlManager="scrl_001"
  }
  Add(Message,4141012,630,224)
  {
  }
  Add(InfoTip,14744595,126,91)
  {
   Info=#24:Парсинг заголовков групп|
   Width=330
   Height=165
   Margin=10
  }
  Add(InfoTip,14361363,119,266)
  {
   Info=#25:Парсинг содержимого групп|
   Width=344
   Height=158
   Margin=10
  }
  Add(InfoTip,8628584,308,434)
  {
   Info=#24:Установка размеров групп|
   Width=267
   Height=123
   Margin=10
  }
END_SDK
Add(ChildFormEx,13097368,497,371)
{
 link(onSendToTable,8844261:doWork1,[])
}
BEGIN_SDK
  Add(EditMultiEx,3339126,21,21)
  {
   EventCount=#13:onSendToTable|
   Width=902
   Height=571
  }
  Add(MainForm,13836894,658,539)
  {
   Left=35
   Top=105
   Width=510
   Height=431
   MarginLeft=3
   MarginTop=3
   MarginRight=3
   MarginBottom=3
   Border=3
   BorderStyle=3
   Position=3
  }
  Add(Memo,14630204,161,84)
  {
   Left=5
   Top=5
   Width=245
   Height=355
   Strings=#59:1.02.2025;Гвозди;135шт;Эдуард Суровый;Плохо закалачиваются;|40:1.02.2025;Бананы;555шт;Тамара Ивановна;;|67:1.02.2025;Бананы;705шт;Вера Сергеевна, Татьяна Сергеевна;Сосисочная|23:1.02.2025;Гвозди;135шт;|65:2.02.2025;Лак для волос;5шт;Джамшут Равшанович;Ничего не понятно;|88:2.02.2025;Топор;705шт;Вера Сергеевна, Татьяна Сергеевна; нет фантазии что то придумать);|43:3.02.2025;Гвозди;45шт;Пол Гилберт, Стив Вай|38:4.02.2025;Бананы;542шт;Тамара Ивановна|58:4.02.2025;Хлеб;123шт;Аркадий Укупник, Филипп Бедросыч;    |
   ScrollBars=3
  }
  Add(ArrayFilterRepeats,12024156,707,266)
  {
   link(onEndFilter,16312575:doEnum,[])
   link(Array,7552928:Array,[])
  }
  Add(StrList,10808540,567,147)
  {
  }
  Add(ArrayEnum,6209312,175,147)
  {
   link(onItem,3522122:doSplit,[])
   link(onEndEnum,7543828:doEnum,[(214,160)(214,223)])
   link(Array,14630204:Array,[])
  }
  Add(MultiStrData,3522122,224,147)
  {
   Count=1
   link(onPart1,2827148:doConvert,[])
  }
  Add(StrList,7552928,693,217)
  {
  }
  Add(ArrayEnum,7543828,581,217)
  {
   link(onItem,4569756:doSplit,[])
   link(onEndEnum,12024156:doFilter,[(634,230)(634,272)])
   link(Array,14054089:Var2,[])
  }
  Add(MultiStrData,4569756,644,217)
  {
   Count=1
   link(onPart1,7552928:doAdd,[])
  }
  Add(FormatStr,423063,812,273)
  {
   Mask="%1;%2;-1"
   link(onFString,980245:doAdd,[])
   link(Str2,16312575:Index,[(825,264)(804,264)(804,313)(769,313)])
  }
  Add(ArrayEnum,16312575,756,273)
  {
   link(onItem,423063:doString,[])
   link(onEndEnum,13241821:doEnum,[(795,286)(795,321)(193,321)(193,342)])
   link(Array,12024156:ArrayFilter,[(762,264)(748,264)(748,306)(713,306)])
  }
  Add(Replace,9950737,448,147)
  {
   SubStr=";"
   DestStr="_"
   link(onReplace,5791458:doStrCatDlm,[])
  }
  Add(Trim,1755495,364,147)
  {
   Char=" "
   Mode=2
   link(onTrim,1106632:doTrim,[])
   link(Text,3522122:RemaindStr,[(370,138)(272,138)(272,187)(230,187)])
  }
  Add(Trim,1106632,406,147)
  {
   Char=";"
   Mode=2
   link(onTrim,9950737:doReplace,[])
  }
  Add(Memo,6440523,658,441)
  {
   Left=255
   Top=5
   Width=245
   Height=355
   ScrollBars=3
  }
  Add(ArrayEnum,13241821,203,336)
  {
   link(onItem,4337509:doEvent1,[])
   link(Array,980245:Array,[(209,327)(881,327)])
  }
  Add(ArrayEnum,15988690,294,441)
  {
   link(onItem,13600319:doSplit,[])
   link(Array,14054089:Var1,[(300,201)])
  }
  Add(MultiStrPart,3790315,392,378)
  {
  }
  Add(If_else,6979627,385,441)
  {
   link(onTrue,8811699:doString,[])
   link(Op2,3790315:Part1,[])
  }
  Add(MultiStrData,13600319,336,441)
  {
   Count=1
   link(onPart1,6979627:doCompare,[])
  }
  Add(GetDataEx,14054089,581,196)
  {
   link(Data,10808540:Array,[])
  }
  Add(FormatStr,8811699,448,441)
  {
   DataCount=3
   Mask="%1;%2;%3"
   link(onFString,16709857:doWork2,[])
   link(Str1,13600319:RemaindStr,[(454,432)(440,432)(440,481)(342,481)])
   link(Str2,1420522:GetData,[])
   link(Str3,3790315:Part2,[(468,425)(405,425)])
  }
  Add(Hub,4337509,259,336)
  {
   OutCount=3
   link(onEvent1,16709857:doWork1,[(606,342)])
   link(onEvent2,3790315:doSplit,[(382,349)(382,384)])
   link(onEvent3,15988690:doEnum,[(284,356)(284,447)])
  }
  Add(StrList,980245,861,273)
  {
  }
  Add(EventFromData,1420522,455,378)
  {
   link(onEvent,14098023:doConvert,[])
  }
  Add(HubEx,16709857,602,441)
  {
   link(onEvent,6440523:doAdd,[])
  }
  Add(Convertor,14098023,511,378)
  {
   Mode=1
   link(onResult,10549897:doOperation,[])
   link(Data,15988690:Index,[(517,369)(503,369)(503,488)(307,488)])
  }
  Add(Math,10549897,560,378)
  {
   Op2=1001
   ResultType=0
   link(onResult,1420522:doData,[(599,384)(599,363)(445,363)(445,384)])
  }
  Add(Button,4979143,56,42)
  {
   Left=175
   Top=375
   TabOrder=-1
   Caption="Convert"
   link(onClick,6525798:doEvent1,[])
  }
  Add(Button,16237282,560,497)
  {
   Left=235
   Top=375
   Width=95
   TabOrder=-1
   Caption="SendToTable"
   link(onClick,12979427:doEvent1,[])
  }
  Add(DoData,12599514,658,497)
  {
   link(onEventData,3339126:onSendToTable,[(900,503)(900,27)])
   link(Data,6440523:Text,[])
  }
  Add(Hub,12979427,616,497)
  {
   link(onEvent1,12599514:doData,[])
   link(onEvent2,13836894:doClose,[(648,510)(648,566)])
  }
  Add(Hub,6525798,105,42)
  {
   OutCount=5
   link(onEvent1,980245:doClear,[(851,48)(851,286)])
   link(onEvent2,7552928:doClear,[(683,55)(683,230)])
   link(onEvent3,10808540:doClear,[(550,62)(550,160)])
   link(onEvent4,6440523:doClear,[(130,69)(130,496)(529,496)(529,454)])
   link(onEvent5,6209312:doEnum,[(139,76)(139,153)])
  }
  Add(DateConvertor,2827148,280,147)
  {
   Mode=8
   Format="dd.MM.yyyy"
   link(onResult,1720819:doConvert,[])
  }
  Add(DateConvertor,1720819,322,147)
  {
   Mode=9
   Format="dd.MM.yyyy"
   Point(Result)
   link(onResult,1755495:doTrim,[])
  }
  Add(StrCatDelim,5791458,497,147)
  {
   Delimiter=";"
   link(onStrCatDlm,10808540:doAdd,[])
   link(Str1,1720819:Result,[(503,138)(489,138)(489,187)(328,187)])
  }
  Add(InfoTip,6282113,217,98)
  {
   Info=#18:Нормализация строк|
   Width=323
   Height=116
   Margin=10
  }
END_SDK

Add(MainForm,2953706,441,238)
{
 Width=715
 Height=506
 MarginLeft=3
 MarginTop=3
 MarginRight=3
 MarginBottom=3
 Border=3
 Caption="MultiTable"
 BorderStyle=1
 Position=1
 Point(onClose)
 link(onClose,2890957:doWork2,[])
}
Add(ChildScrollBox,8844261,539,308)
{
}
BEGIN_SDK
  Add(EditMulti,4271376,21,21)
  {
   WorkCount=1
   Width=377
   Height=228
   link(doWork1,879511:doEvent1,[(53,27)(53,48)])
  }
  Add(ScrollBox,964248,322,77)
  {
   Width=709
   Height=438
   Align=2
   WinStyle=2
   Name="scrl_001"
   BorderStyle=1
   Point(Width)
  }
  Add(ChildPanelEx,2261261,266,147)
  {
   @Hint=#19:Динамические группы|
   Mode=1
   link(onVShift,8595977:doOperation,[(305,153)(305,62)(249,62)(249,83)])
   link(onResult,4141012:doMessage,[])
   link(vOffset,15893030:Var2,[])
   link(pWidth,964248:Width,[(279,138)(342,138)])
   AddHint(-21,69,130,13,@Hint)
  }
  BEGIN_SDK
    Add(EditMultiEx,3885935,21,21)
    {
     WorkCount=#7:##clear|5:##add|8:##select|
     EventCount=#8:onVShift|8:onResult|
     VarCount=#7:##count|0:|
     DataCount=#7:vOffset|6:pWidth|
     Width=650
     Height=522
     Point(##clear)
     Point(##add)
     Point(##select)
     Point(##count)
     link(##add,11635148:doSeparateMT,[(46,34)(46,146)])
     link(##select,13247899:doWork2,[(39,41)(39,503)])
    }
    Add(Panel,15904931,602,49)
    {
     Width=369
     Height=86
     Font=[MS Sans Serif,12,0,0,1]
     Visible=1
     Name="panel_001"
     Point(doWidth)
     Point(Height)
     Point(doTop)
     Point(doHeight)
     Point(doVisible)
    }
    Add(Button,11087212,266,147)
    {
     Width=95
     Height=85
     Align=1
     Font=[MS Sans Serif,12,0,0,1]
     TabOrder=-1
     WinStyle=3
     Caption=""
     Point(doCaption)
     Point(doFont)
     link(onClick,16401184:doEvent1,[])
    }
    Add(MTStrTbl,11520425,343,357)
    {
     Left=87
     Width=280
     Height=82
     Align=5
     Font=[MS Sans Serif,12,0,0,1]
     WinStyle=3
     Name="mtbl_001"
     Columns=#9:name1=150|8:name2=70|9:name3=180|9:name4=150|
     Style=4
     Grid=0
     Point(doAlign)
    }
    Add(Hub,4250363,196,140)
    {
     link(onEvent1,6740804:doOperation,[(221,146)(221,62)])
     link(onEvent2,11087212:doCaption,[])
    }
    Add(Math,6740804,392,56)
    {
     OpType=1
     Op2=18
     ResultType=0
     link(onResult,15904931:doWidth,[])
     link(Op1,3885935:pWidth,[(398,26)(34,26)])
    }
    Add(Math,7577038,287,462)
    {
     OpType=2
     ResultType=0
     link(onResult,6737462:doOperation,[])
     link(Op1,14478038:Result,[])
     link(Op2,11520425:Count,[(300,446)(363,446)])
    }
    Add(Hub,8700013,448,462)
    {
     OutCount=3
     link(onEvent1,2608456:doData,[(473,468)(473,433)])
     link(onEvent2,15904931:doHeight,[(578,475)(578,76)])
     link(onEvent3,11458420:doOperation,[])
    }
    Add(DoData,2608456,532,427)
    {
     link(onEventData,15904931:doTop,[(571,433)(571,69)])
     link(Data,3885935:vOffset,[(538,292)(27,292)])
    }
    Add(Math,11458420,602,476)
    {
     OpType=1
     Op2=1
     link(onResult,3885935:onVShift,[(648,482)(648,27)])
     link(Op1,15904931:Height,[])
    }
    Add(ChanelToIndex,13247899,532,490)
    {
     link(onIndex,15904931:doVisible,[(585,496)(585,83)])
    }
    Add(FontManager,7461808,140,301)
    {
     ControlManager="mtbl_001"
     Point(FontCharset)
    }
    Add(Font,6371043,140,357)
    {
     Point(CharSet)
     link(onFont,4843448:doEvent1,[])
     link(Size,7461808:FontSize,[])
     link(Color,7461808:FontColor,[])
     link(Name,7461808:FontName,[])
     link(Style,7461808:FontStyle,[])
     link(CharSet,7461808:FontCharset,[])
    }
    Add(Img_Text,3115299,280,357)
    {
     Text="W"
     Point(doFont)
    }
    Add(Hub,4843448,196,357)
    {
     OutCount=3
     link(onEvent1,11087212:doFont,[(249,363)(249,160)])
     link(onEvent2,3115299:doFont,[])
     link(onEvent3,14478038:doOperation,[(221,377)(221,412)])
    }
    Add(Math,14478038,287,406)
    {
     Op2=1
     ResultType=0
     link(Op1,3115299:TextHeight,[])
    }
    Add(InfoTip,6154573,112,294)
    {
     Info=#25:Определение высоты группы|
     VAlign=2
     Width=274
     Height=235
     Margin=10
    }
    Add(DSC_Query,14267734,343,245)
    {
     @Color=5614250
     DSManager="parent.parent.sqlite_1"
     link(onQuery,2337115:doAddRow,[])
    }
    Add(FormatStr,11075861,196,245)
    {
     DataCount=1
     Mask="SELECT product,quantity,buyer,note FROM elements WHERE parent=%1"
     link(onFString,14267734:doQuery,[])
     link(Str1,8637286:Value,[])
    }
    Add(MT_MultiData,11635148,77,140)
    {
     link(onData1,4250363:doEvent1,[])
     link(onData2,8637286:doValue,[(130,153)(130,188)])
    }
    Add(Memory,8637286,196,182)
    {
     link(onData,15029490:doEvent1,[(235,188)(235,223)(67,223)(67,356)])
    }
    Add(MST_ArrayRows,15673897,343,98)
    {
     MSTControl="mtbl_001"
    }
    Add(MT_MTArrayEnum,9756254,343,154)
    {
     link(onItem,10915627:doStr,[])
     link(Array,15673897:Strings,[])
    }
    Add(MT_String,10915627,392,154)
    {
     link(onResult,2224873:doTrim,[])
    }
    Add(StrList,10031208,497,154)
    {
    }
    Add(DoData,3602060,497,203)
    {
     link(onEventData,3885935:onResult,[(536,209)(536,34)])
     link(Data,10031208:Text,[])
    }
    Add(Hub,16401184,308,147)
    {
     OutCount=3
     link(onEvent1,10031208:doClear,[(333,153)(333,146)(480,146)(480,167)])
     link(onEvent2,9756254:doEnum,[])
     link(onEvent3,3602060:doData,[(333,167)(333,209)])
    }
    Add(Hub,15029490,77,350)
    {
     OutCount=3
     link(onEvent1,7859062:doClear,[(102,356)(102,251)])
     link(onEvent2,6371043:doFont,[])
     link(onEvent3,7577038:doOperation,[(130,370)(130,468)])
    }
    Add(MST_DB,2337115,392,245)
    {
     MSTControl="mtbl_001"
    }
    Add(MST_Clear,7859062,140,245)
    {
     MSTControl="mtbl_001"
     link(onChange,11075861:doString,[])
    }
    Add(Trim,2224873,441,154)
    {
     Char=";"
     link(onTrim,10031208:doAdd,[])
    }
    Add(Math,6737462,399,462)
    {
     Op2=7
     ResultType=0
     link(onResult,8700013:doEvent1,[])
    }
  END_SDK
  Add(Hub,879511,63,42)
  {
   OutCount=5
   link(onEvent1,2261261:##clear,[(88,48)(88,41)(242,41)(242,153)])
   link(onEvent2,8345200:doQuery,[])
   link(onEvent3,8595977:doClear,[(116,62)(116,90)])
   link(onEvent4,3963701:doBeginUpdate,[(88,69)(88,209)])
   link(onEvent5,1686440:doFor,[(109,76)(109,167)])
  }
  Add(Math,8595977,266,77)
  {
   ResultType=0
   Point(doClear)
   link(Op2,15893030:Var1,[(279,68)(258,68)(258,124)])
  }
  Add(GetDataEx,15893030,266,119)
  {
   link(Data,8595977:Result,[])
  }
  Add(RedrawManager,3963701,182,189)
  {
   ControlManager="scrl_001"
   Point(doEndUpdate)
   Point(doBeginUpdate)
  }
  Add(Message,4141012,322,154)
  {
  }
  Add(For,1686440,126,161)
  {
   IncludeEnd=1
   link(onEvent,2261261:##select,[])
   link(onStop,3963701:doEndUpdate,[(172,174)(172,202)])
   link(End,2261261:##count,[(139,145)(223,145)(223,208)(272,208)])
  }
  Add(DSC_Query,8345200,126,49)
  {
   @Color=5614250
   SQL="SELECT name,idx FROM groups"
   DSManager="parent.sqlite_1"
   link(onQuery,2261261:##add,[(228,55)(228,160)])
  }
END_SDK
Add(DS_SQLite,5269537,539,252)
{
 @Color=5614250
 Name="sqlite_1"
 FileName=":memory:"
 WaitClose=0
 Point(onClose)
 link(onOpen,3519221:doExec,[])
 link(onClose,13097368:doStart,[(578,265)(578,349)(431,349)(431,307)])
}
Add(ChildFormEx,13097368,441,294)
{
 link(onCreate,5269537:doOpen,[(487,300)(487,258)])
 link(onClose,2890957:doWork3,[(514,307)])
 link(onSendToTable,8844261:doWork1,[])
}
BEGIN_SDK
  Add(EditMultiEx,3339126,21,21)
  {
   WorkCount=#10:doGetTable|7:doStart|
   EventCount=#8:onCreate|7:onClose|13:onSendToTable|
   Width=706
   Height=466
   link(doGetTable,13836894:doShowModal,[(158,27)(158,454)])
   link(doStart,15721710:doWork2,[(39,34)(39,160)])
  }
  Add(MainForm,13836894,308,413)
  {
   Left=35
   Top=105
   Width=543
   Height=420
   MarginLeft=3
   MarginTop=3
   MarginRight=3
   MarginBottom=3
   Border=3
   Visible=1
   Caption="Convert ListToDB"
   BorderStyle=3
   Position=3
   Point(doVisible)
   Point(doShowModal)
   link(onActivate,2870680:doTimer,[])
  }
  Add(Memo,14630204,182,91)
  {
   Width=537
   Height=355
   Align=2
   Strings=#59:1.02.2025;Гвозди;135шт;Эдуард Суровый;Плохо закалачиваются;|40:1.02.2025;Бананы;555шт;Тамара Ивановна;;|67:1.02.2025;Бананы;705шт;Вера Сергеевна, Татьяна Сергеевна;Сосисочная|23:1.02.2025;Гвозди;135шт;|65:2.02.2025;Лак для волос;5шт;Джамшут Равшанович;Ничего не понятно;|88:2.02.2025;Топор;705шт;Вера Сергеевна, Татьяна Сергеевна; нет фантазии что то придумать);|43:3.02.2025;Гвозди;45шт;Пол Гилберт, Стив Вай|38:4.02.2025;Бананы;542шт;Тамара Ивановна|58:4.02.2025;Хлеб;123шт;Аркадий Укупник, Филипп Бедросыч;    |
   ScrollBars=3
  }
  Add(ArrayEnum,6209312,196,154)
  {
   link(onItem,3522122:doSplit,[])
   link(onEndEnum,11897762:doEvent1,[(235,167)(235,244)])
   link(Array,14630204:Array,[])
  }
  Add(MultiStrData,3522122,252,154)
  {
   Count=1
   link(onPart1,2827148:doConvert,[])
  }
  Add(FormatStr,423063,357,238)
  {
   DataCount=1
   Mask="UPDATE variable SET count = (SELECT count FROM variable WHERE id = 1) + 1 WHERE id = 1;\r\nINSERT INTO groups VALUES(Null,'%1',(SELECT count FROM variable WHERE id = 1),-1);"
   link(onFString,9529671:doExec,[])
  }
  Add(Trim,1755495,392,154)
  {
   Char=" "
   Mode=2
   link(onTrim,1106632:doTrim,[])
   link(Text,3522122:RemaindStr,[(398,145)(300,145)(300,194)(258,194)])
  }
  Add(Trim,1106632,434,154)
  {
   Char=";"
   Mode=2
   link(onTrim,5791458:doStrCatDlm,[])
  }
  Add(Button,4979143,98,147)
  {
   Left=225
   Top=365
   Width=85
   akLeft=1
   akRight=0
   Enabled=1
   TabOrder=-1
   Caption="Convert"
   Point(doEnabled)
   link(onClick,4266426:doEvent1,[])
  }
  Add(DateConvertor,2827148,308,154)
  {
   Mode=8
   Format="dd.MM.yyyy"
   link(onResult,1720819:doConvert,[])
  }
  Add(DateConvertor,1720819,350,154)
  {
   Mode=9
   Format="dd.MM.yyyy"
   Point(Result)
   link(onResult,1755495:doTrim,[])
  }
  Add(InfoTip,6282113,245,105)
  {
   Info=#18:Нормализация строк|
   Width=295
   Height=116
   Margin=10
  }
  Add(DSC_Exec,9529671,406,238)
  {
   @Color=5614250
   DSManager="parent.sqlite_1"
  }
  Add(DSC_Query,14226630,308,280)
  {
   @Color=5614250
   SQL="SELECT name,idx FROM groups"
   DSManager="parent.sqlite_1"
   link(onQuery,6177478:doEvent1,[])
  }
  Add(FormatStr,884083,602,140)
  {
   DataCount=5
   Mask="UPDATE variable SET count = (SELECT count FROM variable WHERE id = 2) + 1 WHERE id = 2;\r\nINSERT INTO elements VALUES(Null,'%1','%2','%3','%4','%5',(SELECT count FROM variable WHERE id = 2),-1);"
   link(onFString,1233640:doExec,[])
  }
  Add(StrCatDelim,5791458,490,154)
  {
   Delimiter=";"
   link(onStrCatDlm,12997162:doMTString,[])
   link(Str1,1720819:Result,[(496,145)(482,145)(482,194)(356,194)])
  }
  Add(MT_String,12997162,553,140)
  {
   link(onResult,884083:doString,[])
  }
  Add(DSC_Exec,1233640,658,140)
  {
   @Color=5614250
   DSManager="parent.sqlite_1"
  }
  Add(DSC_Query,15791966,308,238)
  {
   @Color=5614250
   SQL="SELECT DISTINCT date FROM elements;"
   DSManager="parent.sqlite_1"
   link(onQuery,423063:doString,[])
  }
  Add(Hub,11897762,252,238)
  {
   OutCount=4
   link(onEvent1,15791966:doQuery,[])
   link(onEvent2,14226630:doQuery,[(284,251)(284,286)])
   link(onEvent3,3339126:onSendToTable,[(291,258)(291,41)])
   link(onEvent4,13836894:doClose,[(278,265)(278,440)])
  }
  Add(MT_MultiMem,3370357,490,280)
  {
  }
  Add(DSC_Query,6070957,392,350)
  {
   @Color=5614250
   SQL="SELECT id,date FROM elements"
   DSManager="parent.sqlite_1"
   link(onQuery,12065741:doValue,[])
  }
  Add(Hub,6177478,357,280)
  {
   link(onEvent1,3370357:doValue,[])
   link(onEvent2,6070957:doQuery,[(382,293)(382,356)])
  }
  Add(If_else,8732812,490,350)
  {
   link(onTrue,2074840:doString,[])
   link(Op1,3370357:Value1,[])
   link(Op2,12065741:Value2,[(503,341)(531,341)(531,390)(454,390)])
  }
  Add(FormatStr,2074840,546,350)
  {
   Mask="UPDATE elements SET parent = %2 WHERE id = %1;"
   link(onFString,1835631:doExec,[])
   link(Str1,12065741:Value1,[(552,341)(538,341)(538,397)(447,397)])
   link(Str2,3370357:Value2,[(559,334)(503,334)])
  }
  Add(DSC_Exec,1835631,602,350)
  {
   @Color=5614250
   DSManager="parent.sqlite_1"
  }
  Add(MT_MultiMem,12065741,441,350)
  {
   link(onData,8732812:doCompare,[])
  }
  Add(Hub,4266426,140,147)
  {
   link(onEvent1,3339126:onCreate,[(165,153)(165,27)])
   link(onEvent2,6209312:doEnum,[])
  }
  Add(Timer,2870680,357,413)
  {
   Interval=0
   Enable=1
   AutoStop=1
   link(onTimer,6227862:doEvent1,[])
  }
  Add(Hub,6227862,406,413)
  {
   link(onEvent1,15721710:doWork1,[(431,419)(431,468)(46,468)(46,153)])
   link(onEvent2,3339126:onClose,[(697,426)(697,34)])
  }
  Add(ChanelToIndex,15721710,56,147)
  {
   link(onIndex,4979143:doEnabled,[])
  }
END_SDK
Add(DSC_Exec,3519221,588,252)
{
 @Color=5614250
 SQL="CREATE TABLE variable(id INTEGER PRIMARY KEY AUTOINCREMENT, count int);\r\nINSERT INTO variable VALUES(Null,-1);\r\nINSERT INTO variable VALUES(Null,1000);\r\nCREATE TABLE groups(id INTEGER PRIMARY KEY AUTOINCREMENT,name text,idx int,parent int);\r\nCREATE TABLE elements(id INTEGER PRIMARY KEY AUTOINCREMENT,date text,product text,quantity text,buyer text,note text,idx int,parent int);"
 DSManager="sqlite_1"
}
Add(HubEx,2890957,510,259)
{
 link(onEvent,5269537:doClose,[])
}
Add(Button,12804036,385,294)
{
 Left=310
 Top=450
 Width=85
 akLeft=1
 akRight=0
 TabOrder=-1
 Caption="Get Table"
 link(onClick,13097368:doGetTable,[])
}