<div class="et_pb_button_module_wrapper et_pb_button_3_wrapper et_pb_button_alignment_center et_pb_module  dbdb-icon-on-right dbdb-icon-on-hover dbdb-has-custom-padding">
				<a class="et_pb_button et_pb_button_3 et_pb_bg_layout_light" href="/product-category/domestic-hot-water/">learn more</a>
			</div>

pip install gTTS

pip install gTTS

In Backend, go to:
Content- Design - Configuration
Select 	Best Deal Print theme name and edit
Other Settings - Header - Logo Image

-- CREATE TABLE team_kingkong.offus_edc_card_velocity_amount_breaches AS
INSERT INTO team_kingkong.offus_edc_card_velocity_amount_breaches
with offus_txn as
(SELECT DISTINCT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN date'2025-05-01' AND DATE'2025-05-31'
    and paymethod in ('CREDIT_CARD','DEBIT_CARD','EMI','EMI_DC')
    AND actionrecommended <> 'BLOCK' AND responsestatus = 'SUCCESS'
    AND paytmmerchantid IS NOT NULL AND paytmmerchantid <> '' AND paytmmerchantid <> ' '
    AND globalcardindex IS NOT NULL AND globalcardindex <> '' AND globalcardindex <> ' ') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b 
ON a.paytmmerchantid = b.edc_mid)

SELECT * FROM 
    (SELECT A.globalcardindex, A.transactionid, A.txn_amount, A.txn_date, A.paytmmerchantid, 'edc_card_velocity_amount' AS rule_name, A.txn_timestamp
    , SUM(IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 21600000, B.txn_amount, NULL)) AS amt6_hr
    , 1000000 AS amt6_hr_threshold
    , SUM(B.txn_amount) as amt24_hr
    , 2000000 AS amt4_hr_threshold
    FROM
        (SELECT * FROM offus_txn
        WHERE txn_date  BETWEEN date'2025-05-01' AND DATE'2025-05-31')A
    INNER JOIN
        (SELECT * FROM offus_txn)B
    ON A.globalcardindex = b.globalcardindex AND A.paytmmerchantid = B.paytmmerchantid AND A.transactionid <> B.transactionid
    AND (A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 86400000 -- <= 1d
    GROUP BY 1,2,3,4,5,6,7)
WHERE ((amt6_hr + txn_amount) > 1000000) OR ((amt24_hr + txn_amount) > 2000000);

DROP TABLE team_kingkong.offus_edc_card_velocity_count_breaches;

-- CREATE TABLE team_kingkong.offus_edc_card_velocity_count_breaches AS
INSERT INTO team_kingkong.offus_edc_card_velocity_count_breaches
with offus_txn as
(SELECT DISTINCT globalcardindex, transactionid, txn_amount, txn_date, paytmmerchantid, txn_timestamp FROM
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , globalcardindex
    , DATE(dl_last_updated) AS txn_date
    , CAST(velocitytimestamp AS DOUBLE) AS txn_timestamp
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN DATE(DATE'2025-01-01' - INTERVAL '1' DAY) AND DATE'2025-01-31'
    and paymethod in ('CREDIT_CARD','DEBIT_CARD','EMI','EMI_DC')
    AND actionrecommended <> 'BLOCK'AND responsestatus = 'SUCCESS'
    AND globalcardindex IS NOT NULL AND globalcardindex <> '' AND globalcardindex <> ' ' 
    AND paytmmerchantid IS NOT NULL AND paytmmerchantid <> '' AND paytmmerchantid <> ' ') a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b 
ON a.paytmmerchantid = b.edc_mid)

SELECT * FROM 
    (SELECT A.globalcardindex, A.transactionid, A.txn_amount, A.txn_date, A.paytmmerchantid, 'edc_card_velocity_count' AS rule_name, A.txn_timestamp
    , COUNT(DISTINCT IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 60000, B.transactionid, NULL)) AS txn1_min
    , 2 AS txn1_min_threshold
    , COUNT(DISTINCT IF((A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 21600000, B.transactionid, NULL)) AS txn6_hr
    , 5 as txn6_hr_threshold
    , COUNT(DISTINCT B.transactionid) as txn24_hr
    , 10 AS txn24_hr_threshold
    FROM
        (SELECT * FROM offus_txn
        WHERE txn_date BETWEEN DATE'2025-01-01' AND DATE'2025-01-31')A
    INNER JOIN
        (SELECT * FROM offus_txn)B
    ON A.globalcardindex = b.globalcardindex AND A.paytmmerchantid = B.paytmmerchantid AND (A.txn_timestamp - B.txn_timestamp) BETWEEN 0 AND 86400000 -- <= 1d
    AND A.transactionid <> B.transactionid
    GROUP BY 1,2,3,4,5,6,7)
WHERE (txn1_min >= txn1_min_threshold) OR (txn6_hr >= txn6_hr_threshold) OR (txn24_hr >= txn24_hr_threshold);

-- TPAP implementation date
SELECT DISTINCT regexp_replace(cast(json_extract(response, '$.messages.cst[0]') as varchar), '"', '') as risk_code
, MIN(DATE(dl_last_updated)) as implementation_date
FROM tpap_hss.upi_switchv2_dwh_risk_data_snapshot_v3
WHERE DATE(dl_last_updated) >= date'2024-01-01'
AND (lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) LIKE '%@paytm%'
or lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) like '%@pt%')
AND json_extract_scalar(response, '$.action_recommended') = 'BLOCK'
GROUP BY 1;

-- ONUS implementation date
select json_extract_scalar(actionrecommendedrules,'$.actionRecommendedRules[0]') as strategy_name
, MIN(DATE(dateinserted)) AS implementation_date
FROM cdp_risk_transform.maquette_flattened_onus_snapshot_v3
WHERE dl_last_updated >= date '2022-01-01'
AND SOURCE = 'PG' AND actionrecommended = 'BLOCK' AND json_extract_scalar(actionrecommendedrules,'$.actionRecommendedRules[0]') IS NOT NULL
GROUP BY 1

Are you ready to capitalize on IPL excitement with your fantasy sports app? Partnering with a trusted fantasy sports app development company can help you create an engaging platform tailored for cricket fans. With expert guidance, you can offer exciting features, real-time updates, and user-friendly interfaces that attract and retain players throughout the tournament. Capture the enthusiasm of millions, boost user engagement, and turn the IPL season into a great opportunity for your app’s success.

Beleaf Technologies offers affordable solutions to develop fantasy sports apps, providing cost-effective services without compromising quality, helping you enter the market quickly and attract sports enthusiasts with ease.

Know more :https://www.beleaftechnologies.com/fantasy-sports-app-development-company

Whatsapp: +91 7904323274
Telegram: @BeleafSoftTech
Mail to: mailto:business@beleaftechnologies.com

{
    "_id" : ObjectId("682ae3ab51f919e432c3b2d1"),
    "fv" : 2000,
    "pc" : "toi",
    "pfm" : "aos",
    "lid" : 0,
    "enable" : true,
    "deleted" : false,
    "value" : {
        "lang" : 1,
        "defaultSelectedSectionId" : "Home-01",
        "isToRetainUserSelection" : false,
        "bottomBarSections" : [ 
            {
                "uid" : "Home-01",
                "name" : "Home",
                "engName" : "Home",
                "defaulturl" : "https://nprelease.indiatimes.com/aufs/config/navigation/section?client=toi&pc=toi&pfm=aos&path=toi/home",
                "actionBarTitleName" : "Home",
                "tn" : "Home",
                "icons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/120897786.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996271.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959876.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/120897787.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113323285.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/113323312.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113323305.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/113323296.cms"
                }
            }, 
            {
                "uid" : "ETimes-01",
                "name" : "ETimes",
                "engName" : "ETimes",
                "defaulturl" : "https://nprelease.indiatimes.com/aufs/config/navigation/section?path=toi/home/entertainment&pc=toi&fv=<fv>&pfm=aos&client=toi",
                "actionBarTitleName" : "ETimes",
                "tn" : "pagerSection",
                "icons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/120897789.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996275.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959881.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/120897791.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113323293.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/113323319.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113323310.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/113323302.cms"
                },
                "primeSection" : {
                    "uid" : "Yoga-01",
                    "name" : "Yoga",
                    "engName" : "Yoga",
                    "defaulturl" : "https://timeshealthplus.com/TH/plans?acqSource=healthplus_bottomtab&acqSubSource=bottomtab_Icon_iOS&utm_source=Apps&utm_medium=bottomtab_IOS",
                    "actionBarTitleName" : "Yoga",
                    "tn" : "yoga",
                    "icons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "primeIcons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "hideBottomNav" : true,
                    "enableGenericAppWebBridge" : false,
                    "deeplink" : "toiapp://open-$|$-id=Yoga-01-$|$-lang=1-$|$-displayName=Yoga-$|$-url=https://timeshealthplus.com/TH/plans?acqSource=healthplus_bottomtab&acqSubSource=bottomtab_Icon_iOS&utm_source=Apps&utm_medium=bottomtab-$|$-type=htmlview-$|$-pubId-100"
                },
                "myTimes" : {
                    "uid" : "myTimes-01",
                    "name" : "myTimes",
                    "engName" : "myTimes",
                    "defaulturl" : "",
                    "actionBarTitleName" : "myTimes",
                    "tn" : "customtab",
                    "icons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "primeIcons" : {
                        "darkDeselected" : "https://static.toiimg.com/photo.cms?photoid=121166141",
                        "lightSelected" : "https://static.toiimg.com/photo.cms?photoid=121166142",
                        "lightDeselect" : "https://static.toiimg.com/photo.cms?photoid=121185245",
                        "darkSelected" : "https://static.toiimg.com/photo.cms?photoid=121166140"
                    },
                    "hideBottomNav" : true,
                    "enableGenericAppWebBridge" : false
                }
            }, 
            {
                "uid" : "TOIPlus-01",
                "name" : " TOI+",
                "engName" : "TOI+",
                "defaulturl" : "https://nprelease.indiatimes.com/aufs/config/navigation/section?pc=toi&pfm=aos&path=toi/toiplushome&client=toi&fv=<fv>",
                "actionBarTitleName" : "TOI+",
                "tn" : "prSections",
                "icons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/120897782.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996269.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959873.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/120897784.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113088482.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/113088482.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113088482.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/112376793.cms"
                }
            }, 
            {
                "uid" : "Print-Edition-01",
                "name" : "ePaper",
                "engName" : "ePaper",
                "defaulturl" : "https://epaper.indiatimes.com/timesepaper/publication-the-times-of-india,city-delhi.cms",
                "actionBarTitleName" : "ePaper",
                "tn" : "ePaperView",
                "primeIcons" : {
                    "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113088465.cms",
                    "lightSelected" : "https://timesofindia.indiatimes.com/photo/120996279.cms",
                    "lightDeselect" : "https://timesofindia.indiatimes.com/photo/120959884.cms",
                    "darkSelected" : "https://timesofindia.indiatimes.com/photo/113323299.cms"
                },
                "icons" : {
                    "darkDeselected" : "https://static.toiimg.com/photo/120897794.cms",
                    "lightSelected" : "https://static.toiimg.com/photo/120766267.cms",
                    "lightDeselect" : "https://static.toiimg.com/photo/120766270.cms",
                    "darkSelected" : "https://static.toiimg.com/photo/120897797.cms"
                },
                "enableGenericAppWebBridge" : true
            }, 
            {
                "secPos" : 4,
                "uid" : "Game-01",
                "name" : "Games",
                "engName" : "Games",
                "defaulturl" : "https://nprelease.indiatimes.com/ufs-utility/toi-games/fetch/game/config?pc=<pc>&pfm=<pfm>&fv=<fv>&lang=<lang>",
                "actionBarTitleName" : "Games",
                "tn" : "games",
                "overrideSelected" : "true",
                "icons" : {
                    "darkDeselected" : "https://opt.toiimg.com/images/app/bottom/icon/v1/gamesbottomnavicon_unselected_darktheme.png",
                    "lightSelected" : "https://static.toiimg.com/photo/120895359.cms",
                    "lightDeselect" : "https://static.toiimg.com/photo/120959879.cms",
                    "darkSelected" : "https://static.toiimg.com/photo/120766263.cms"
                },
                "primeIcons" : {
                    "darkDeselected" : "https://opt.toiimg.com/images/app/bottom/icon/v1/gamesbottomnavicon_unselected_darktheme.png",
                    "lightSelected" : "https://static.toiimg.com/photo/114589843.cms",
                    "lightDeselect" : "https://opt.toiimg.com/images/app/bottom/icon/v1/gamesbottomnavicon_unselected_lighttheme.png",
                    "darkSelected" : "https://static.toiimg.com/photo/114589840.cms"
                },
                "animateConfig" : {
                    "animateIconLight" : "https://static.toiimg.com/photo/114427341.cms",
                    "animateIconDark" : "https://static.toiimg.com/photo/114427337.cms",
                    "primeAnimateIconLight" : "https://static.toiimg.com/photo/114427341.cms",
                    "primeAnimateIconDark" : "https://static.toiimg.com/photo/114427337.cms",
                    "startTimeOfDay" : {
                        "hr" : 1,
                        "min" : 30
                    },
                    "endTimeOfDay" : {
                        "hr" : 23,
                        "min" : 30
                    },
                    "secondsStartAfter" : 5,
                    "animationDuration" : 2
                }
            }
        ],
        "cityFallbackSection" : {
            "uid" : "Photos-01",
            "name" : "Photos",
            "engName" : "Photos",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/client/toia/navigation/section?lang=1&uid=Photos-01&category=Photo-01&fv=1130&isPager=true",
            "actionBarTitleName" : "Photos",
            "tn" : "pagerSection",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/photos_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/photos_selected_dark.png"
            }
        },
        "shortsSection" : {
            "uid" : "Shorts-01",
            "name" : "Shorts",
            "engName" : "Shorts",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/briefs/v1/toia/listing?lang=1&fv=1130",
            "actionBarTitleName" : "Shorts",
            "tn" : "shorts",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            },
            "IsPinned" : true
        },
        "outSideIndiaSection" : {
            "uid" : "VideoTB-01",
            "name" : "Videos",
            "engName" : "Videos",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/client/feed/list/toia/home-sections-news?lang=1&uid=VideoTB-01&puid=Home-01&category=VideoTB-01&adtag=homevideo&asset=ad,xwd,bn&fv=1130&swadTag=secWid",
            "actionBarTitleName" : "Videos",
            "tn" : "mixedList",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/video_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/video_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/video_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/video_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://timesofindia.indiatimes.com/photo/113398330.cms",
                "lightSelected" : "https://timesofindia.indiatimes.com/photo/113398327.cms",
                "lightDeselect" : "https://timesofindia.indiatimes.com/photo/113398326.cms",
                "darkSelected" : "https://timesofindia.indiatimes.com/photo/113398328.cms"
            }
        },
        "briefETimesSection" : {
            "uid" : "Briefs-01",
            "name" : "Briefs",
            "engName" : "Brief",
            "defaulturl" : "https://plus.timesofindia.com/toi-feed/brief/toia/listing?lang=1&fv=1015&secuid=BriefsEntertainment-01&isincountry==true",
            "actionBarTitleName" : "Brief",
            "tn" : "briefList",
            "icons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            },
            "primeIcons" : {
                "darkDeselected" : "https://opt.toiimg.com/images/Test/QC/brieds_deselected_dark.png",
                "lightSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_light.png",
                "lightDeselect" : "https://opt.toiimg.com/images/Test/QC/briefs_deselected_light.png",
                "darkSelected" : "https://opt.toiimg.com/images/Test/QC/briefs_selected_dark.png"
            }
        }
    }
}

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.Events;

public class TurnManager : MonoBehaviour
{
    [SerializeField] private Character[] characters;
    [SerializeField] private float nextTurnDelay = 1.0f;

    private int curCharacterIndex = -1;
    public Character CurrentCharacter;

    public event UnityAction<Character> OnBeginTurn;
    public event UnityAction<Character> OnEndTurn;

    // Singleton
    public static TurnManager Instance;

    void Awake ()
    {
        if(Instance != null && Instance != this)
            Destroy(gameObject);
        else
            Instance = this;
    }

    void OnEnable ()
    {
        Character.OnDie += OnCharacterDie;
    }

    void OnDisable ()
    {
        Character.OnDie -= OnCharacterDie;
    }

    void Start ()
    {
        BeginNextTurn();
    }

    // Called when a new player is ready for their turn.
    public void BeginNextTurn ()
    {
        curCharacterIndex++;

        if(curCharacterIndex == characters.Length)
            curCharacterIndex = 0;

        CurrentCharacter = characters[curCharacterIndex];
        OnBeginTurn?.Invoke(CurrentCharacter);
    }

    // Called after the current character has casted their combat action.
    public void EndTurn ()
    {
        OnEndTurn?.Invoke(CurrentCharacter);
        Invoke(nameof(BeginNextTurn), nextTurnDelay);
    }

    // Called when a character dies.
    void OnCharacterDie (Character character)
    {
        if(character.IsPlayer)
            Debug.Log("You lost!");
        else
            Debug.Log("You win!");
    }
}

-- REJECTION RATE 
CREATE TABLE team_kingkong.offus_rej_rate_monthly AS
WITH offus_base as 
(select DISTINCT a.*, case when edc_mid is not null then 'EDC' else 'QR' end as mid_type from
    (SELECT DISTINCT pg_mid from cdo.total_offline_merchant_base_snapshot_v3) f
INNER join
    (select distinct actionrecommended
    , json_extract_scalar(actionrecommendedrulestatus, '$[0].status') as rule_status
    , json_extract_scalar(actionrecommendedrulestatus, '$[0].versionedRule.ruleName') as rule_name
    , transactionid
    , cast(eventamount as double)/100 as txn_amount
    , paytmmerchantid
    , substr(cast(dl_last_updated as varchar(30)), 1, 7) AS yearMonth
    from cdp_risk_transform.maquette_flattened_offus_snapshot_v3
    where dl_last_updated BETWEEN date '2025-01-01' AND DATE'2025-05-31'
    and paymethod in ('UPI','CREDIT_CARD','DEBIT_CARD','EMI','EMI_DC')) a
on a.paytmmerchantid = f.pg_mid
LEFT JOIN
    (SELECT DISTINCT mid AS edc_mid FROM paytmpgdb.entity_edc_info_snapshot_v3
    WHERE terminal_status = 'ACTIVE' AND dl_last_updated >= DATE '2010-01-01') b 
ON a.paytmmerchantid = b.edc_mid)

SELECT A.*, B.attempted_txn, B.attempted_gmv FROM
    (SELECT yearMonth, rule_name, mid_type
    , COUNT(transactionid) as rejected_txn
    , SUM(txn_amount) as rejected_gmv
    FROM offus_base
    WHERE actionrecommended = 'BLOCK' AND rule_status = 'LIVE'
    GROUP BY 1,2,3)A
INNER JOIN
    (SELECT yearMonth, mid_type
    , COUNT(transactionid) as attempted_txn
    , SUM(txn_amount) as attempted_gmv
    FROM offus_base
    GROUP BY 1,2)B
ON A.yearMonth = B.yearMonth AND A.mid_type = B.mid_type

-- Rule X Monthly Breach rate
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'MID_CCDC_Daily_TXN_limit_Check' AS rule_name
FROM team_kingkong.offus_MID_CCDC_Daily_TXN_limit_Check_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'edc_card_velocity_count' AS rule_name 
FROM team_kingkong.offus_edc_card_velocity_count_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'Merchant_PerTxnLimit_Check' AS rule_name  
FROM team_kingkong.offus_Merchant_PerTxnLimit_Check_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'edc_card_velocity_amount' AS rule_name  
FROM team_kingkong.offus_edc_card_velocity_amount_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'MID_UPI_Daily_TXN_limit_Check' AS rule_name  
FROM team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'oil_gas_dc_limit_EDC' AS rule_name  
FROM team_kingkong.offus_oil_gas_dc_limit_EDC_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_Unsafe_Country_Transactions' AS rule_name  
FROM team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'CCUPI_vpa_mid_hourly_limit' AS rule_name  
FROM team_kingkong.offus_CCUPI_vpa_mid_hourly_limit_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_PerCard_PerMID_TXN_Limit' AS rule_name  
FROM team_kingkong.offus_ICA_PerCard_PerMID_TXN_Limit_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'CCUPI_vpa_mid_daily_limit' AS rule_name  
FROM team_kingkong.offus_CCUPI_vpa_mid_daily_limit_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_OddTime_PerCard_PerMID_EDC' AS rule_name  
FROM team_kingkong.offus_ICA_OddTime_PerCard_PerMID_EDC_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
, 'ICA_Bank_Decline_Threshold_Block' AS rule_name  
FROM team_kingkong.offus_ICA_Bank_Decline_Threshold_Block_breaches
GROUP BY 1;

-- OFFUS OVERALL BREACH RATE
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt FROM
(SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_MID_CCDC_Daily_TXN_limit_Check_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_edc_card_velocity_count_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount 
FROM team_kingkong.offus_Merchant_PerTxnLimit_Check_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_edc_card_velocity_amount_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_MID_UPI_Daily_TXN_limit_Check_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_oil_gas_dc_limit_EDC_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_Unsafe_Country_Transactions_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_CCUPI_vpa_mid_hourly_limit_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_PerCard_PerMID_TXN_Limit_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount 
FROM team_kingkong.offus_CCUPI_vpa_mid_daily_limit_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_OddTime_PerCard_PerMID_EDC_breaches

UNION

SELECT DATE(txn_date) AS txn_date, transactionid, txn_amount
FROM team_kingkong.offus_ICA_Bank_Decline_Threshold_Block_breaches)
GROUP BY 1;

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

[CreateAssetMenu(fileName = "Combat Action", menuName = "New Combat Action")]
public class CombatAction : ScriptableObject
{
    public enum Type
    {
        Attack,
        Heal
    }

    public string DisplayName;
    public Type ActionType;

    [Header("Damage")]
    public int Damage;
    public GameObject ProjectilePrefab;

    [Header("Heal")]
    public int HealAmount;
}

using System.Collections;
using System.Collections.Generic;
using UnityEngine;

[CreateAssetMenu(fileName = "Combat Action", menuName = "New Combat Action")]
public class CombatAction : ScriptableObject
{
    public enum Type
    {
        Attack,
        Heal
    }

    public string DisplayName;
    public Type ActionType;

    [Header("Damage")]
    public int Damage;
    public GameObject ProjectilePrefab;

    [Header("Heal")]
    public int HealAmount;
}

final_list = []
for _,row in dataset.iterrows():
    lat = row['latitude']
    lng = row['longitude']
    radius = row['radius']
    country_iso = row['country_iso']
    tran_month = row['month']
    tran_year = row['year']

    start_date,end_date = get_start_end_date(tran_month,tran_year)
    query = get_monthly_count_query(lat,lng,radius,tran_month,tran_year,country_iso)
    print(query)
    
    input_json = row.to_dict()
    result_dataset = execute_query(query,redshift_username, redshift_password)
    data_json = result_dataset.to_dict(orient='records')[0]
    final_json = {**input_json,**data_json}
    final_list.append(final_json)

final_dataset = pd.DataFrame(final_list)
final_dataset

nohup python manage.py runserver 0.0.0.0:8000 > Django_admin.log &

nohup celery -A mysite worker --loglevel=info > celery_worker.log &
nohup celery -A mysite beat --loglevel=info > celery_beat.log &

{
  "name": "Permissions Extension",
  ...
  "permissions": [
    "activeTab",
    "contextMenus",
    "storage"
  ],
  "optional_permissions": [
    "topSites",
  ],
  "host_permissions": [
    "https://www.developer.chrome.com/*"
  ],
  "optional_host_permissions":[
    "https://*/*",
    "http://*/*"
  ],
  ...
  "manifest_version": 3
}

<img src="line.jpg" alt="">

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":star: Xero Boost Days! :star:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Please see below for what's on this week! "
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-21: Wednesday, 21st May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy free coffee and café-style beverages from our partner, *Naked  Duck*.\n:breakfast: *Morning Tea*: Provided by *Naked Duck* from *9am* in the All Hands.\n:massage:*Wellbeing*: Crossfit class at *Be Athletic* from 11am."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-22: Thursday, 22nd May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":coffee: *Café Partnership*: Café Partnership: Enjoy coffee and café-style beverages from our partner, *Naked Duck*.\n:late-cake: *Lunch*: Provided by *Naked Duck* from *12pm* in the All Hands."
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Stay tuned to this channel for more details, check out the <https://calendar.google.com/calendar/u/0/r?cid=Y185aW90ZWV0cXBiMGZwMnJ0YmtrOXM2cGFiZ0Bncm91cC5jYWxlbmRhci5nb29nbGUuY29t|*Sydney Social Calendar*>, and get ready to Boost your workdays!\n\nLove,\nWX Team :party-wx:"
			}
		}
	]
}

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":xeros-connect: Boost Days - What's on this week! :xeros-connect:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Morning Ahuriri :wave: Happy Monday, let's get ready to dive into another week with our Xeros Connect Boost Day programme! See below for what's in store :eyes:"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-21: Wednesday, 21st May :camel:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy coffee and café-style beverages from our cafe partner, *Adoro*, located in our office building *8:00AM - 11:30AM*.\n:wrap: *Lunch*: Provided by *Design Cuisine* from *12:30PM-1:30PM* in the Kitchen."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-22: Thursday, 22nd May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy coffee and café-style beverages from our cafe partner, *Adoro*, located in our office building *8:00AM - 11:30AM*.\n:breakfast: *Breakfast*: Provided by *Roam* from *9:30AM-10:30AM* in the Kitchen."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-23: Friday, 23rd May",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:xero-hackathon: *Hackathon Social Happy Hour*: Enjoy some drinks and nibbles from *4:00PM-5:30PM* in Clearview, and celebrate our Hackathon Award winners!"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "*What else?* Stay tuned to this channel for more details, check out the <https://calendar.google.com/calendar/u/0?cid=eGVyby5jb21fbXRhc2ZucThjaTl1b3BpY284dXN0OWlhdDRAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ|*Hawkes Bay Social Calendar*>, and get ready to Boost your workdays!\n\nWX Team :party-wx:"
			}
		}
	]
}

SELECT field FROM ent.[DE Name]

<?php 

// A message stored in a string
$statusMessage = "Process completed#";

// Remove the last symbol from the message
$cleanMessage = substr($statusMessage, 0, -1);

// Display the messages
echo "Before cleanup: " . $statusMessage . "\n";
echo "After cleanup: " . $cleanMessage . "\n";


// Here is the output

/*
Before cleanup: Process completed#
After cleanup: Process completed
*/

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":cute-sun: Boost Days - What's On This Week :cute-sun:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n\n Let's get ready to dive into another week here in the Melbourne Office :yay: "
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": "Xero Café :coffee:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n :new-thing: *This week we are offering:* \n\n :cookie:  A selection of yummy cookies from an Indigeous supplier Coocee Cookies. \n\n *Weekly Café Special :coffee-eyes:* Caramel Macchiato"
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": "Tuesday 20th May :calendar-date-20:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":hands: Join us in the Wominjeka Breakout Space for the Global All Hands live in Melbourne from *9.00am-10.00am*.  "
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": " Wednesday 21st May :calendar-date-21:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": " \n\n :lunch: *Light Lunch*: from *12pm* in the Wominjeka Breakout Space. Please see the menu in the :thread: \n\n"
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": "Thursday, 22nd May :calendar-date-22:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":waffle::juicebox:*Breakfast*:from *8:30am - 10:30am* in the Wominjeka Breakout Space."
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Stay tuned for more fun throughout the year. :party-wx:"
			}
		}
	]
}

<td><?= date("d/m/Y", strtotime($event['date'])) ?></td>

<?php
// Esempio di chiamata cURL che ritorna un JSON con un timestamp
$curl = curl_init("https://esempio.com/api/data"); // Cambia con la tua URL
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
$response = curl_exec($curl);
curl_close($curl);

// Decodifica JSON (supponiamo che abbia un campo 'timestamp')
$data = json_decode($response, true);
$remoteTimestamp = isset($data['timestamp']) ? (int)$data['timestamp'] : null;

if ($remoteTimestamp === null) {
    die("Timestamp non trovato nella risposta");
}

// Crea oggetto DateTime dal timestamp ricevuto
$remoteDate = (new DateTime())->setTimestamp($remoteTimestamp);

// Crea oggetto DateTime per 1 anno fa a mezzanotte
$localDate = new DateTime();
$localDate->modify('-1 year')->setTime(0, 0, 0);

// Confronto
if ($remoteDate < $localDate) {
    echo "Il timestamp remoto è più vecchio di 1 anno.\n";
} else {
    echo "Il timestamp remoto è più recente di 1 anno.\n";
}

// Debug: stampa date
echo "Data remota: " . $remoteDate->format('Y-m-d H:i:s') . "\n";
echo "Data di riferimento: " . $localDate->format('Y-m-d H:i:s') . "\n";
?>

/{!Opportunity.Id}/e?clone=1&recordTypeId={RecordTypeId}

/flow/Flow_API_Name?Variable1=value1&Variable2=value2

/lightning/r/Report/{ReportId}/view?pv0=value1&pv1=value2

/lightning/o/Opportunity/new?RecordType={RecordTypeId}

/lightning/o/Opportunity/new?useRecordTypeCheck=1

/lightning/o/Contact/new?defaultFieldValues=LastName=Smith,AccountId={!Account.Id}

/lightning/o/Account/new?defaultFieldValues=CustomCheckbox__c={!IF(Account.SomeCheckbox__c, true, false)} 

display:flex;
flex-direction:column;
}
.widget.skin154 .cpSlider{
display:flex;

}
.widget.skin154 .text{
padding:1em;
padding-bottom:0;
position:relative;
display:flex;
flex-direction:column;
height:100%;
}

.widget.skin154 .widgetDesc{
display:flex;
flex-direction:column;
justify-content:space-between;
height:100%;

Copyright [yyyy] [name of copyright owner]

Licensed under the Apache License, Version 2.0 (the "License");
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

    http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

Want to be a millionaire? Fantasy sports apps might just be your winning move. With the growing craze for online fantasy leagues, investing in a fantasy sports app is gaining serious attention. These apps offer users a chance to engage, compete, and win real rewards. If you're eyeing this booming trend, fantasy sports app development could open doors to massive returns. It’s not just a game—it’s a smart investment opportunity in the digital age.


Beleaf Technologies change your innovative ideas into real-world solutions by delivering custom software development, helping businesses grow with technology tailored to their unique goals and challenges.


Know more :https://www.beleaftechnologies.com/fantasy-sports-app-development-company

Whatsapp: +91 7904323274
Telegram: @BeleafSoftTech
Mail to: mailto:business@beleaftechnologies.com

d sdsad adsa dsa dsa dsa

-- MONTH x CATEGORY X RULE wise Rejected txn & gmv, Attempted txn & gmv and Rejection rate
CREATE TABLE team_kingkong.onus_rej_rate_monthly AS
WITH flattened as 
    (SELECT DISTINCT mnth, transactionid, strategy_name, actionrecommended, amt, case when m1.mid is not null then category else 'Others' end as business_category FROM
        (select transactionid
        , json_extract_scalar(actionrecommendedrules,'$.actionRecommendedRules[0]') as strategy_name
        , cast(eventAmount as double)/100 as amt
        , substr(cast(dateinserted as varchar), 1,7) as mnth
        -- , paymethod,eventName,addAndPay
        , paytmmerchantid
        , actionrecommended
        FROM cdp_risk_transform.maquette_flattened_onus_snapshot_v3
        WHERE dl_last_updated BETWEEN date '2025-01-01' AND DATE'2025-05-31'
        AND SOURCE = 'PG') a
    left join 
        (select * from team_kingkong.voc_mid_categorization
        where mid != '') m1 
    on a.paytmmerchantid = m1.mid)
 
SELECT A.mnth, A.business_category, A.strategy_name, A.rej_txns, A.rej_gmv, B.attempted_txns, B.attempted_gmv FROM
    (select mnth
    , business_category
    , strategy_name
    , count(transactionid) as rej_txns
    , sum(amt) as rej_gmv
    from flattened
    WHERE actionrecommended = 'BLOCK'
    GROUP BY 1,2,3)A
INNER JOIN
    (SELECT mnth, business_category
    , count(transactionid) as attempted_txns
    , sum(amt) as attempted_gmv
    FROM flattened
    GROUP BY 1,2)B
ON A.mnth = B.mnth AND A.business_category = B.business_category;
 


-- Rule X Monthly Breach rate
SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'CCBP_attempt_Txn_user_1d_7d_30d' AS rule_name
FROM team_kingkong.onus_CCBP_attempt_Txn_user_1d_7d_30d_breaches
GROUP BY 1

-- UNION

-- SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(txn_amount) as breach_amt
-- , 'on_us_sbi_nb_limit' AS rule_name 
-- FROM team_kingkong.onus_on_us_sbi_nb_limit_breaches
-- GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'CCBP_sucTxn_user_1d_7d_30d' AS rule_name  
FROM team_kingkong.onus_CCBP_sucTxn_user_1d_7d_30d_breaches
GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'Fastag_TrustedUser_CCDC_Weekly_Monthly_limitCheck' AS rule_name  
FROM team_kingkong.onus_Fastag_TrustedUser_CCDC_Weekly_Monthly_limitCheck_breaches
GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'Fastag_Trusted_VRN_CCDC_Weekly_Monthly_limitCheck' AS rule_name  
FROM team_kingkong.onus_Fastag_Trusted_VRN_CCDC_Weekly_Monthly_limitCheck_breaches
GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'UtilityEventTxnLImit' AS rule_name  
FROM team_kingkong.onus_UtilityEventTxnLImit_breaches
GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'on_us_loan_repayments_user_limits' AS rule_name  
FROM team_kingkong.onus_on_us_loan_repayments_user_limits_breaches
GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'Fastag_NonTrustedUser_CCDC_Monthly_limitCheck' AS rule_name  
FROM team_kingkong.onus_Fastag_NonTrustedUser_CCDC_Monthly_limitCheck_breaches
GROUP BY 1

UNION

SELECT substr(cast(dateinserted as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt
, 'CCBP_GMV_per_user_1d_7d_30d' AS rule_name  
FROM team_kingkong.onus_CCBP_GMV_per_user_1d_7d_30d_breaches
GROUP BY 1;

-- ONUS OVERALL BREACH RATE
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(transactionid) as breach_cnt, SUM(amt) as breach_amt FROM
(SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_CCBP_attempt_Txn_user_1d_7d_30d_breaches

-- UNION

-- SELECT DATE(dateinserted) AS txn_date, transactionid, amt
-- FROM team_kingkong.onus_on_us_sbi_nb_limit_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt 
FROM team_kingkong.onus_CCBP_sucTxn_user_1d_7d_30d_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_Fastag_TrustedUser_CCDC_Weekly_Monthly_limitCheck_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_Fastag_Trusted_VRN_CCDC_Weekly_Monthly_limitCheck_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_UtilityEventTxnLImit_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_on_us_loan_repayments_user_limits_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_Fastag_NonTrustedUser_CCDC_Monthly_limitCheck_breaches

UNION

SELECT DATE(dateinserted) AS txn_date, transactionid, amt
FROM team_kingkong.onus_CCBP_GMV_per_user_1d_7d_30d_breaches
)
GROUP BY 1;

-- RULE x CATEGORY x UPI SUBTYPE X MONTH wise rejected txn & gmv, attempted txn & gmv & rejection rate
-- CREATE TABLE team_kingkong.tpap_rej_rate_monthly AS
INSERT INTO team_kingkong.tpap_rej_rate_monthly
with overall as 
(SELECT DISTINCT A.year_month
, A.category
, IF(C.upi_subtype IS NOT NULL, c.upi_subtype, IF(A.category = 'LITE_MANDATE', 'UPI_LITE_MANDATE', '')) AS upi_subtype
, A.amount
, A.txn_id
, risk_code
, action_recommended
FROM
    (SELECT DISTINCT substr(cast(dl_last_updated as varchar(30)), 1, 7) as year_month, txn_id, amount, category
    FROM switch.txn_info_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN date'2025-04-01' AND DATE('2025-05-31')
    AND DATE(created_on) BETWEEN date'2025-04-01' AND DATE('2025-05-31'))A
LEFT JOIN
    (SELECT DISTINCT txnid
    , CAST(json_extract_scalar(request, '$.requestPayload.amount') AS DOUBLE) as txn_amount
    , regexp_replace(cast(json_extract(request, '$.evaluationType') as varchar), '"', '') AS upi_subtype
    , regexp_replace(cast(json_extract(response, '$.messages.cst[0]') as varchar), '"', '') as risk_code
    , json_extract_scalar(response, '$.action_recommended') AS action_recommended
    FROM tpap_hss.upi_switchv2_dwh_risk_data_snapshot_v3
    WHERE DATE(dl_last_updated) BETWEEN date'2025-04-01' AND DATE('2025-05-31')
    AND (lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) LIKE '%@paytm%'
    or lower(regexp_replace(cast(json_extract(request, '$.requestPayload.payerVpa') as varchar), '"', '')) like '%@pt%'))C
on A.txn_id = C.txnid)
 
SELECT A.year_month, A.category, A.upi_subtype, A.risk_code, A.rej_txns, A.rej_gmv, B.attempted_txns, B.attempted_gmv FROM
    (select year_month
    , category
    , upi_subtype
    , risk_code
    , count(txn_id) as rej_txns
    , sum(amount) as rej_gmv
    from overall
    WHERE action_recommended = 'BLOCK'
    GROUP BY 1,2,3,4)A
INNER JOIN
    (SELECT year_month, category, upi_subtype
    , count(txn_id) as attempted_txns
    , sum(amount) as attempted_gmv
    FROM overall
    GROUP BY 1,2,3)B
ON A.year_month = B.year_month AND A.category = B.category AND A.upi_subtype = B.upi_subtype;
        
        
-- Rule X Monthly Breach rate
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk200_breaches' AS rule_name
FROM team_kingkong.tpap_risk200_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk307_breaches' AS rule_name 
FROM team_kingkong.tpap_risk307_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk304_breaches' AS rule_name  
FROM team_kingkong.tpap_risk304_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk127_breaches' AS rule_name  
FROM team_kingkong.tpap_risk127_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk005_breaches' AS rule_name  
FROM team_kingkong.tpap_risk005_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk306_breaches' AS rule_name  
FROM team_kingkong.tpap_risk306_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk236_breaches' AS rule_name  
FROM team_kingkong.tpap_risk236_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk235_breaches' AS rule_name  
FROM team_kingkong.tpap_risk235_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk152_breaches' AS rule_name  
FROM team_kingkong.tpap_risk152_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk292_breaches' AS rule_name  
FROM team_kingkong.tpap_risk292_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk510_breaches' AS rule_name  
FROM team_kingkong.tpap_risk510_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk318_breaches' AS rule_name  
FROM team_kingkong.tpap_risk318_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk239_breaches' AS rule_name  
FROM team_kingkong.tpap_risk239_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk151_breaches' AS rule_name  
FROM team_kingkong.tpap_risk151_breaches
GROUP BY 1

UNION

SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt
, 'tpap_risk009_breaches' AS rule_name  
FROM team_kingkong.tpap_risk009_breaches
GROUP BY 1
;


-- TPAP OVERALL BREACH RATE
SELECT substr(cast(txn_date as varchar(30)), 1, 7) as year_month, COUNT(txn_id) as breach_cnt, SUM(txn_amount) as breach_amt FROM
(SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk200_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk307_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount 
FROM team_kingkong.tpap_risk304_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk127_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk005_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk306_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk236_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk235_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk152_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk292_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk510_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk318_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk239_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk151_breaches

UNION

SELECT DATE(txn_date) AS txn_date, txn_id, txn_amount
FROM team_kingkong.tpap_risk009_breaches
)
GROUP BY 1;        

// bad
var leds = stage.selectAll('.led').data(data).enter().append('svg:svg').classed('led', true)
    .attr('width', (radius + margin) * 2).append('svg:g')
    .attr('transform', 'translate(' + (radius + margin) + ',' + (radius + margin) + ')')
    .call(tron.led);

// good
var leds = stage.selectAll('.led')
    .data(data)
  .enter().append('svg:svg')
    .classed('led', true)
    .attr('width', (radius + margin) * 2)
  .append('svg:g')
    .attr('transform', 'translate(' + (radius + margin) + ',' + (radius + margin) + ')')
    .call(tron.led);

OWLNETS-UMLS-GRAPH-12.py

var $offCanvasNav = $('.mobile-menu'),
          $offCanvasNavSubMenu = $offCanvasNav.find('.dropdown');
      /*Add Toggle Button With Off Canvas Sub Menu*/
      $offCanvasNavSubMenu.parent().prepend('<span class="menu-expand"><i></i></span>');
      /*Close Off Canvas Sub Menu*/
      $offCanvasNavSubMenu.slideUp();
      /*Category Sub Menu Toggle*/
      $offCanvasNav.on('click', 'li a, li .menu-expand', function(e) {
        console.log('clicked:', e.target, e.currentTarget);
        var $currentTarget = $(e.currentTarget);
        var $this = $(this);
        if (($this.parent().attr('class').match(/\b(menu-item-has-children|has-children|has-sub-menu)\b/)) && ($this.attr('href') === '#' || $this.hasClass('menu-expand'))) {
          e.preventDefault();
          e.stopPropagation();
          if ($this.siblings('ul:visible').length) {
            $this.parent('li').removeClass('active');
            $this.siblings('ul').slideUp();
          } else {
            $this.parent('li').addClass('active');
            $this.closest('li').siblings('li').removeClass('active').find('li').removeClass('active');
            $this.closest('li').siblings('li').find('ul:visible').slideUp();
            $this.siblings('ul').slideDown();
          }
        }
      });

DECLARE
    /*  -------------------------------------------------------------------------------------------
        - L_JSON_RESPONSE:  Variável do tipo CLOB (Character Large Object) que armazenará a resposta JSON da API.
        - L_NEXT_URL:       Variável do tipo VARCHAR2 que armazena a URL da próxima página de resultados da API.
        - L_POKEMON_NAME:   Variável do tipo VARCHAR2 que não é utilizada diretamente no código, mas poderia ser usada para armazenar o nome do Pokémon se necessário.
        - ID:               Variável do tipo NUMBER usada para armazenar o ID do Pokémon extraído da URL.
        -------------------------------------------------------------------------------------------
    */
    L_JSON_RESPONSE CLOB;
    L_NEXT_URL VARCHAR2(4000);
    L_POKEMON_NAME VARCHAR2(100);
    ID  NUMBER;
BEGIN

    -- URL inicial da API para obter os Pokémon
    L_NEXT_URL := 'https://pokeapi.co/api/v2/pokemon/';

    -- Loop para continuar a buscar enquanto houver uma próxima página
    LOOP
        -- Faz a requisição à API
        L_JSON_RESPONSE := APEX_WEB_SERVICE.MAKE_REST_REQUEST(
            P_URL         => L_NEXT_URL,
            P_HTTP_METHOD => 'GET'
        );

        -- Se a resposta não for nula, processa a lista de Pokémon
        IF L_JSON_RESPONSE IS NOT NULL THEN
            -- Loop para processar os nomes dos Pokémon
            FOR C1 IN (
                SELECT JT.name, JT.url
                FROM JSON_TABLE(
                    L_JSON_RESPONSE,
                    '$.results[*]' COLUMNS (
                        name PATH '$.name',
                        url PATH '$.url'
                    )
                ) JT
            ) LOOP

                ID := REGEXP_SUBSTR(C1.url, '(\d+)(/|\?)$', 1, 1, NULL, 1);

                -- Filtrar somente a 1° geração
                IF ID <= 151 THEN

                    -- Insert na tabela base
                    INSERT INTO POKEMON (ID_POKEMON, NAME_POKEMON, URL_POKEMON)
        	        VALUES (ID, C1.name, C1.url);

                END IF;

            END LOOP;

            -- Obtém a URL da próxima página de resultados
            BEGIN
                SELECT JT.next
                INTO L_NEXT_URL
                FROM JSON_TABLE(
                    L_JSON_RESPONSE,
                    '$' COLUMNS (
                        next PATH '$.next'
                    )
                ) JT;

                -- Se a URL for null ou vazia, sai do loop
                IF L_NEXT_URL IS NULL OR L_NEXT_URL = '' OR ID > 151 THEN
                    EXIT;
                END IF;

            EXCEPTION
                WHEN NO_DATA_FOUND THEN
                    -- Se não houver o campo 'next', sai do loop
                    EXIT;
            END;
        ELSE
            DBMS_OUTPUT.PUT_LINE('Resposta vazia recebida.');
            EXIT; -- Se não houver resposta, sai do loop
        END IF;
    END LOOP;

EXCEPTION
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('Erro ao processar a requisição: ' || SQLERRM);
END;