Please enable JavaScript.

Coggle requires JavaScript to display documents.

Бронирование тура (start (?checkrowId=4 (%search=%TourId1 (else ($SYS…

- - - - else
        
        $SYS.GET
        
        ANSWER
        
        %glovesUSD=90
        
        %glassesUSD=92
        
        %additionaltourdescription=82
        
        %Preparation15USD=66
        
        %Preparation7USD=64
        
        %delivery15USD=60
        
        %delivery7USD=58
        
        %delivery1USD=56
        
        %samovarUSD=38
        
        %barbecueUSD=36
        
        %MusicUSD=24
        
        %PhotoVideoUSD=28
        
        %Preparation1USD=62
        
        %hookahUSD=26
        
        %BalonUSD=32
        
        %BlanketsUSD=30
        
        %additionaltourname=81
        
        %transferfromstartUSD=76
        
        %SledrentalUSD=72
        
        %Ourfood1USD=68
        
        %grillUSD=34
        
        %BigBonfireUSD=54
        
        %DogsUSD=52
        
        %tentUSD=46
        
        %tablewareUSD=44
        
        %chairUSD=42
        
        %tableUSD=40
        
        %transferFromHotelUSD=78
        
        %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
        
        %glassesKZT=93
        
        %additionaltourpriceUSD=84
        
        %additionaltourduration=83
        
        %cookUSD=48
        
        %WaiterUSD=50
        
        %bootsUSD=88
        
        %jacketUSD=86
        
        %ServiceAmount=6
        
        %Equipment=94
        
        %transfer=95
        
        %Catering=96
        
        %Entertainment=97
        
        %Food=98
        
        QUESTION
        
        range=Туры Rentour!E:E
        
        search=%search
        
        doc=1d8EITn3BvFNjDJ4bfwkpcRL4H6s_zas2yQ0D25TJ7jI
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        else
        
        $SYS.GET
        
        https://api.pipe.bot/docs/spreadsheets/read
        
        1 more item...
        
        QUESTION
        
        3 more items...
        
        ANSWER
        
        24 more items...
- - - - BUTTONS
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=8
        
        title=%service8
        
        BUTTON
        
        %chargeButtonPressed=4
        
        title= %service4
        
        type=postback
        
        BUTTON
        
        title= %service6
        
        type=postback
        
        %chargeButtonPressed=6
        
        BUTTON
        
        %chargeButtonPressed=3
        
        title= %service3
        
        type=postback
        
        BUTTON
        
        %chargeButtonPressed=10
        
        type=postback
        
        title=%service10
        
        BUTTON
        
        %chargeButtonPressed=7
        
        title= %service7
        
        type=postback
        
        BUTTON
        
        title= %service2
        
        type=postback
        
        %chargeButtonPressed=2
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=0
        
        title=Далее
        
        BUTTON
        
        type=postback
        
        title=%service9
        
        %chargeButtonPressed=9
        
        BUTTON
        
        %chargeButtonPressed=5
        
        type=postback
        
        title= %service5
        
        BUTTON
        
        title= %service1
        
        type=postback
        
        %chargeButtonPressed=1
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=11
        
        title= %service11
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=12
        
        title= %service12
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=13
        
        title= %service13
      - image=%TourPhoto
      - title=%TourName
      - bypass=0
      - subtitle=Выберите доп. услуги
    - - ?chargeButtonPressed=0
        
        else
      - ?chargeButtonPressed=1
        
        %update=%Music1
        
        $SYS.POST
        
        https://api.pipe.bot/docs/spreadsheets/update
        
        ?result=1
        
        %service1=❌ Большая колонка
        
        1 more item...
        
        else
        
        Something went wrong
        
        QUESTION
        
        doc=1muO8YCIiLW2NfHkuKGYmjVfjGadsGE67q3k_d-tCS5U
        
        range=Расчет!AJ%TourRowId
        
        value=%update
        
        ANSWER
        
        %result
      - ?button1=Ok
- - - - BUTTONS
        
        BUTTON
        
        %chargeButtonPressed=0
        
        title=Далее
        
        type=postback
        
        BUTTON
        
        title= %service1
        
        type=postback
        
        %chargeButtonPressed=1
      - image=%TourPhoto
      - title=%TourName
      - bypass=0
      - subtitle=Выберите доп. услуги
    - - ?chargeButtonPressed=0
        
        else
      - ?chargeButtonPressed=1
        
        ?serviceNmae1=Гриль
        
        else
        
        calc %addservicecheck=mb_strpos('%service1','❌')
        
        else
        
        %servicecolumn=AX
        
        1 more item...
        
        ?addservicecheck=false
        
        $SYS.CARDS
        
        2 more items...
        
        else
        
        else
        
        ?serviceName1=Самовар
        
        else
        
        ?serviceName1=🐕 Собаки Хаски (нарты)
        
        else
        
        ?serviceName1=🔥 Большой костер
        
        else
        
        2 more items...
        
        ?serviceNmae1=Мангал
- - - - BUTTONS
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=0
        
        title=Далее
        
        BUTTON
        
        title= %service2
        
        type=postback
        
        %chargeButtonPressed=2
        
        BUTTON
        
        title= %service1
        
        type=postback
        
        %chargeButtonPressed=1
      - image=%TourPhoto
      - title=%TourName
      - bypass=0
      - subtitle=Выберите доп. услуги
    - - ?chargeButtonPressed=0
        
        else
      - ?chargeButtonPressed=1
- - - - BUTTONS
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=0
        
        title=Далее
        
        BUTTON
        
        title= %service2
        
        type=postback
        
        %chargeButtonPressed=2
        
        BUTTON
        
        title= %service1
        
        type=postback
        
        %chargeButtonPressed=1
        
        BUTTON
        
        title= %service3
        
        type=postback
        
        %chargeButtonPressed=3
      - image=%TourPhoto
      - title=%TourName
      - bypass=0
      - subtitle=Выберите доп. услуги
    - - ?chargeButtonPressed=0
        
        else
      - ?chargeButtonPressed=1
- - - - BUTTONS
        
        BUTTON
        
        %chargeButtonPressed=21
        
        title= %meaning21
        
        type=postback
        
        BUTTON
        
        title= %meaning13
        
        type=postback
        
        %chargeButtonPressed=13
        
        BUTTON
        
        %chargeButtonPressed=18
        
        type=postback
        
        title= %meaning18
        
        BUTTON
        
        title= %meaning11
        
        type=postback
        
        %chargeButtonPressed=11
        
        BUTTON
        
        type=postback
        
        title= %meaning15
        
        %chargeButtonPressed=15
        
        BUTTON
        
        %chargeButtonPressed=20
        
        type=postback
        
        title= %meaning20
        
        BUTTON
        
        type=postback
        
        title= %meaning16
        
        %chargeButtonPressed=16
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=22
        
        title=%meaning22
        
        BUTTON
        
        %chargeButtonPressed=10
        
        type=postback
        
        title=%meaning10
        
        BUTTON
        
        %chargeButtonPressed=7
        
        title= %meaning7
        
        type=postback
        
        BUTTON
        
        title= %meaning3
        
        type=postback
        
        %chargeButtonPressed=3
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=19
        
        title=%meaning19
        
        BUTTON
        
        type=postback
        
        title=%meaning9
        
        %chargeButtonPressed=9
        
        BUTTON
        
        %chargeButtonPressed=5
        
        type=postback
        
        title= %meaning5
        
        BUTTON
        
        title= %meaning2
        
        type=postback
        
        %chargeButtonPressed=2
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=12
        
        title= %meaning12
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=14
        
        title= %meaning14
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=17
        
        title= %meaning17
        
        BUTTON
        
        type=postback
        
        title= %meaning1
        
        %chargeButtonPressed=1
        
        BUTTON
        
        %chargeButtonPressed=6
        
        type=postback
        
        title= %meaning6
        
        BUTTON
        
        type=postback
        
        title= %meaning4
        
        %chargeButtonPressed=4
        
        BUTTON
        
        type=postback
        
        %chargeButtonPressed=8
        
        title=%meaning8
        
        BUTTON
        
        %chargeButtonPressed=0
        
        title=Сделать расчет
        
        type=postback
      - image=%TourPhoto
      - title=%TourName
      - bypass=0
      - subtitle=Выберите доп. услуги
    - - ?chargeButtonPressed=0
        
        else
      - ?chargeButtonPressed=1
        
        %update=%Music1
        
        $SYS.POST
        
        https://api.pipe.bot/docs/spreadsheets/update
        
        ?result=1
        
        %service1=❌ Большая колонка
        
        1 more item...
        
        else
        
        Something went wrong
        
        QUESTION
        
        doc=1muO8YCIiLW2NfHkuKGYmjVfjGadsGE67q3k_d-tCS5U
        
        range=Расчет!AJ%TourRowId
        
        value=%update
        
        ANSWER
        
        %result
      - ?button1=Ok
- - - - %service2=💨 Кальян %hookahKZT %currency / шт.
        
        else
        
        ?PhotoVideoUSD>0
        
        %service3=📷 Фото и видео +%PhotoVideoKZT %currency
        
        else
        
        ?BlanketsUSD>0
        
        1 more item...
        
        else
        
        1 more item...
        
        else
        
        %service3=null #
    - - %service2=null #
- - - - ?Catering>0
        
        %ServiceCategory2.2=Кейтеринг
        
        %ServiceCategory2=%ServiceCategory2.2 (%Catering)
        
        ?Entertainment>0
        
        %ServiceCategory3.3=Развлечения
        
        %ServiceCategory3=%ServiceCategory3.3 (%Entertainment)
        
        2 more items...
        
        else
        
        else
        
        ?Equipment>0
        
        1 more item...
        
        Ошибка
        
        ?transfer>0
        
        %ServiceCategory3.3=Трансфер
        
        1 more item...
      - else
        
        else
        
        else
        
        ?Equipment>0
        
        %ServiceCategory2.2=Экипировка
        
        %ServiceCategory2=%ServiceCategory2.2 (%Equipment) #
        
        else #
        
        ?transfer>0
        
        %ServiceCategory2.2=Трансфер
        
        %ServiceCategory2=%ServiceCategory2.2 (%transfer)
        
        ?Equipment>0
        
        1 more item...
        
        else
        
        1 more item...
        
        ?Entertainment>0
        
        %ServiceCategory2.2=Развлечения
        
        %ServiceCategory2=%ServiceCategory2.2 (%Entertainment)
        
        ?transfer>0
        
        %ServiceCategory3.3=Трансфер
        
        1 more item...
        
        else
        
        ?Equipment>0
        
        1 more item...
        
        Ошибка
- - - - %ServiceCategory1.1=Кейтеринг
        
        %ServiceCategory1=%ServiceCategory1.1 (%Catering)
        
        ?Entertainment>0
        
        %ServiceCategory2.2=Развлечения
        
        %ServiceCategory2=%ServiceCategory2.2 (%Entertainment)
        
        ?transfer>0
        
        1 more item...
        
        else
        
        2 more items...
        
        else
        
        else
        
        ?Equipment>0
        
        %ServiceCategory2.2=Экипировка
        
        1 more item...
        
        Ошибка
        
        ?transfer>0
        
        %ServiceCategory2.2=Трансфер
        
        %ServiceCategory2=%ServiceCategory2.2 (%transfer) #
    - - else
        
        else
        
        ?Equipment>0
        
        %ServiceCategory1.1=Экипировка
        
        %ServiceCategory1=%ServiceCategory1.1 (%Equipment) #
        
        else #
        
        ?transfer>0
        
        %ServiceCategory1.1=Трансфер
        
        %ServiceCategory1=%ServiceCategory1.1 (%transfer)
        
        ?Equipment>0
        
        %ServiceCategory2.2=Экипировка
        
        1 more item...
        
        else
        
        Ошибка
      - ?Entertainment>0
        
        %ServiceCategory1.1=Развлечения
        
        %ServiceCategory1=%ServiceCategory1.1 (%Entertainment)
        
        ?transfer>0
        
        %ServiceCategory2.2=Трансфер
        
        %ServiceCategory2=%ServiceCategory2.2 (%transfer)
        
        2 more items...
        
        else
        
        ?Equipment>0
        
        %ServiceCategory2.2=Экипировка
        
        1 more item...
        
        Ошибка
- - - - $SYS.POST
        
        https://api.pipe.bot/docs/spreadsheets/update
        
        ?result=1
        
        else
        
        %checkservicefood1=❌
        
        %servicefood1=❌ Гриль %grillKZT %currency
        
        1 more item...
        
        else
        
        Something went wrong
        
        QUESTION
        
        doc=1muO8YCIiLW2NfHkuKGYmjVfjGadsGE67q3k_d-tCS5U
        
        range=Расчет!AX%TourRowId
        
        value=%update
        
        ANSWER
        
        %result
- - - - ?result=1
        
        ?checkservicefood1=❌
        
        %checkservicefood1=0
        
        %servicefood1=Гриль %grillKZT %currency
        
        ✅ Удалено! #
      - else
        
        Can not delete row
    - - doc=1muO8YCIiLW2NfHkuKGYmjVfjGadsGE67q3k_d-tCS5U
      - range=Расчет!AX%TourRowId
      - value=
    - - %result
- - - - else
        
        ?hookahUSD>0
        
        %service2=💨 Кальян %hookahKZT %currency / шт.
        
        calc %button2=%button1+1
        
        else
        
        ?PhotoVideoUSD>0
        
        1 more item...
        
        else
        
        1 more item...
        
        else
        
        %service2=null #
- - - - else
        
        else
        
        else
        
        else
        
        else
        
        lese
        
        2 more items...
        
        ?MusicUSD>0
        
        1 more item...
        
        ?additionaltourpriceUSD>0
        
        %serviceName1=Доп. программа
        
        1 more item...
        
        ?PhotoVideoUSD>0
        
        %serviceName1=📷 Фото и видео
        
        %service1=%serviceName1
        +%PhotoVideoKZT %currency
        
        ?BlanketsUSD>0
        
        %serviceName1=🧶 Плед
        
        %service1=%serviceName1
        %BlanketsKZT %currency / шт.
        
        ?glasses>0
        
        %serviceNmae1=🥽 Горные очки
        
        %service1= %serviceNmae1
        %glassesKZT %currency
      - ?glovesUSD>0
        
        %serviceNmae1=🧤 Перчатки
        
        %service1= %serviceNmae1
        %glovesKZT %currency
    - - %serviceNmae1=🥾 Сапоги
        
        %service1= %serviceNmae1
        %bootsKZT %currency
  - - - %service1=%serviceName1
        %jacketKZT %currency / шт.
- - - - else
        
        ?transferfromstartUSD>0
        
        %serviceName2=🚌 Трансфер
        
        %service2=%serviceName2
        
        else
        
        ?jacketUSD>0
        
        %serviceName1=🧥 Пуховик
        
        %service1=%serviceName1
        %jacketKZT %currency / шт.
        
        else
        
        ?bootsUSD>0
        
        %serviceNmae1=🥾 Сапоги
        
        %service1= %serviceNmae1
        %bootsKZT %currency
        
        else
        
        ?glovesUSD>0
        
        %serviceNmae1=🧤 Перчатки
        
        1 more item...
        
        else
        
        ?glasses>0
        
        1 more item...
        
        else
        
        2 more items...
- - - - %service1=❌ Большая колонка
        
        ✅ Добавлено! #
    - - Something went wrong