Please enable JavaScript.

Coggle requires JavaScript to display documents.

🚀 Быстрый подбор тура (start (else ($SYS.GET (QUESTION (doc=1d8EITn3BvFNj…

- - - - QUESTION
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
        
        range=Туры Rentour!E%checkrowId
      - https://api.pipe.bot/docs/spreadsheets/read
        
        else
        
        %search=%result
        
        else
        
        $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        2 more items...
        
        QUESTION
        
        3 more items...
        
        ANSWER
        
        16 more items...
      - ANSWER
        
        %result
- - - - %search=%season
        
        $SYS.GET
        
        ANSWER
        
        %TourName1=2
        
        %TourId1=0
        
        %rowId=rowId
        
        %value11=11
        
        %value13=13
        
        %value12=12
        
        %value10=10
        
        %TourPhoto1=26
        
        %TourMap1=17
        
        %TourUrl1=25
        
        %TourDescription1=24
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        Ошибка поиска по сезону карта 🚀 Быстрый подбор тура
        
        ?rowId>0
        
        else
        
        ?Male=Мужчинам
        
        2 more items...
        
        ?Famale=Женщинам
        
        2 more items...
        
        ?Group=Группа
        
        2 more items...
        
        ?Family=Семья
        
        1 more item...
        
        else
        
        1 more item...
        
        QUESTION
        
        search=%search
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
        
        range=Туры!%column
- - - - Ошибка
    - - else
        
        %a=%rowId
        
        calc %rowId=%a+1
        
        $SYS.GET
        
        QUESTION
        
        range=Туры!A%rowId
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        else
        
        ANSWER
        
        %result
        
        No good
      - ?value11=Женщинам
        
        else
        
        %search=%value0
        
        $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        $SYS.CARDS
        
        2 more items...
        
        QUESTION
        
        range=Карточки туров!A:A
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
        
        search=%search
        
        ANSWER
        
        %rowId=rowId
        
        %TourID1=0
        
        %TourName1=2
        
        %TourPhoto1=6
        
        %TourReyting1=5
        
        %TourReviews1=13
        
        %TourUrl1=14
        
        %TourDescription1=7
    - - ?value11=Женщинам
        
        ?value13=Дети #
      - else #
    - - else #
      - ?value11=Женщинам
        
        else #
        
        ?value12=Группа #
    - - ?value11=Женщинам
        
        ?value12=Группа
        
        ?value13=Дети #
        
        else #
        
        else #
      - else #
- - - - https://api.pipe.bot/docs/spreadsheets/read
        
        else
        
        %search=%result
        
        $SYS.GET
        
        ANSWER
        
        %value0=0
        
        %value21=21
        
        %value1=1
        
        %value12=12
        
        %value13=13
        
        %value11=11
        
        %rowId=rowId
        
        QUESTION
        
        range=Туры!A:A
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
        
        search=%search
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        ?season=Весна
        
        3 more items...
      - QUESTION
        
        range=Туры!A%rowId
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
      - ANSWER
        
        %result
- - - - else
        
        ...We can not find any record
      - ?rowId>0
        
        ?MusicUSD>0
        
        %service1=🔊 Большая колонка +%MusicKZT %currency
        
        else
        
        ?hookahUSD>0
        
        %service2=💨 Кальян %hookahKZT %currency / шт.
        
        1 more item...
        
        else
        
        %service2=null #
        
        else
        
        %service1=null #
    - - range=Туры Rentour!E:E
      - doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
      - search=%search
    - - %MusicUSD=24
      - %hookahUSD=26
      - %PhotoVideoUSD=28
      - %BlanketsUSD=30
      - %BalonUSD=32
      - %grillUSD=34
      - %barbecueUSD=36
      - %samovarUSD=38
      - %tableUSD=40
      - %chairUSD=42
      - %tablewareUSD=44
      - %tentUSD=46
      - %cookUSD=48
      - %WaiterUSD=50
      - %DogsUSD=52
      - %BigBonfireUSD=54
      - %delivery1USD=56
      - %delivery7USD=58
      - %delivery15USD=60
      - %Preparation1USD=62
      - %Preparation7USD=64
      - %Preparation15USD=66
      - %Ourfood1USD=68
      - %SledrentalUSD=72
      - %transferfromstartUSD=76
      - %transferFromHotelUSD=78
      - %additionaltourname=81
      - %additionaltourdescription=82
      - %additionaltourduration=83
      - %additionaltourpriceUSD=84
      - %jacketUSD=86
      - %bootsUSD=88
      - %glovesUSD=90
      - %glassesUSD=92
      - %MusicKZT=25
      - %hookahKZT=27
      - %PhotoVideoKZT=29
      - %BlanketsKZT=31
      - %BalonKZT=33
      - %grillKZT=35
      - %barbecueKZT=37
      - %samovarKZT=39
      - %tableUSD=41
      - %chairKZT=43
      - %tablewareKZT=45
      - %tentKZT=47
      - %cookKZT=49
      - %WaiterKZT=51
      - %DogsKZT=53
      - %BigBonfireKZT=55
      - %delivery1KZT=57
      - %delivery7KZT=59
      - %delivery15KZT=61
      - %Preparation1KZT=63
      - %Preparation7KZT=65
      - %Preparation15KZT=67
      - %Ourfood1KZT=69
      - %SledrentalKZT=73
      - %transferfromstartKZT=77
      - %transferFromHotelKZT=79
      - %additionaltourid=80
      - %additionaltourpriceKZT=85
      - %jacketKZT=87
      - %bootsKZT=89
      - %glovesKZT=91
      - %glovesUSD=93
- - - - else
        
        ...We can not find any record
      - ?rowId>0
        
        ...Search result: %value1, %value2
        
        ...RowId:%rowId
    - - %value1=1
      - %value2=2
    - - range=Туры Rentour!E:E
      - doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
      - search=%search
- - - - else
        
        ...We can not find any record
      - ?rowId>0
        
        ?TotalAddServise=1
        
        %DocLine=1
        
        else
        
        ?Music>0
        
        %ServicePrice1=%Music
        
        %ServiceName1=Музыка, большая колонка
        
        %ServiceAmount1=1 шт.
        
        2 more items...
        
        %ServiceTotalPrice1=%Music
    - - range=Расчет!G:G
      - doc=1muO8YCIiLW2NfHkuKGYmjVfjGadsGE67q3k_d-tCS5U
      - search=%search
    - - %rowId=rowId
      - %TourOrderId=6
      - %TourClientId=7
      - %TourFor=8
      - %TourTeam=9
      - %TourId=10
      - %TourName=11
      - %TourTechnique=12
      - %TourDuration=13
      - %TotalServiseKzt=24
      - %TotalTourPriceFor1Kzt=26
      - %TotalTourPriceKzt=28
      - %TotalDiscountProcent=29
      - %TotalTourDiscountPriceFor1Kzt=31
      - %TotalTourtDiscountPriceKzt=33
      - %TotalAddServise=34
      - %Music=36
      - %PhotoVideo=43
      - %HookahPrice=38
      - %HookahAmount=39
      - %TotalHookahPrice=41
      - %BalloonPrice=45
      - %BalloonAmount=46
      - %TotalBalloonPrice=48
      - %GrillPrice=50
      - %BarbecuePrice=52
      - %SamovarPrice=54
      - %BlanketsPrice=56
      - %BlanketsAmount=57
      - %TotalBlanketsPrice=59
      - %TablePrice=61
      - %TableAmount=62
      - %TotalTablePrice=64
      - %ChairsPrice=66
      - %ChairsAmount=67
      - %TotalChairsPrice=69
      - %TablewarePrice=71
      - %TablewareAmount=72
      - %TotalTablewarePrice=74
      - %TentsPrice=76
      - %TentsAmount=77
      - %TotalTentsPrice=79
      - %CookPrice=81
      - %CookAmount=82
      - %TotalCookPrice=84
      - %WaiterPrice=86
      - %WaiterAmount=87
      - %TotalWaiterPrice=89
      - %DogsPrice=91
      - %DogsTime=92
      - %TotalDongsPrice=94
      - %BigBonfirePrice=96
      - %Delivery=98
      - %Installation=100
      - %FoodServicePrice=104
      - %SledRentalPrice=106
      - %TransferStartPrice=108
      - %TransferStartAmount=109
      - %TotalTransferStartPrice=111
      - %TransferHotelPrice=113
      - %TransferHotelAmount=114
      - %TotalTransferHotelPrice=116
      - %AddTourId=117
      - %AddTourName=118
      - %AddTourDescription=119
      - %AddTourDuration=120
      - %AddTourPrice=122
      - %AddTourAmount=123
      - %AddTourTotalPrice=125
      - %JacketPrice=127
      - %JacketAmount=128
      - %JacketTotalPrice=130
      - %BootsPrice=132
      - %BootsAmount=133
      - %BootsTotalPrice=135
      - %GlovesPrice=137
      - %GlovesAmount=138
      - %GlovesTotalPrice=140
      - %MountGlassPrice=142
      - %MountGlassAmount=143
      - %MountGlassTotalPrice=145
      - %StandartPriceKzt=17
      - %DiscountStandartPriceKzt=19
      - %PriceFor1Kzt=21