# I am working on scRNAseq data derived from human bladder cancer 'Urothelial carcinoma'
# Urothelial carcinoma has 2 subtypes - muscle invasive (MIBC), non-muscle invasive (NMIBC)
# NMIBC has recurrence rate 70%-80% if untreated and approx 50% progress to MIBC (Aya T Shalata et al. 2022), where MIBC has a 50-70% mortality rate! (Jong Chul Park et al. 2014)
# I will look at urothelial heterogeneity within non-malignant NMIBC papilloma as intratumoural heterogeneity is a major driver to drug resistance (NA Saunders et al. 2012)

# Data comes from 2 individuals. (M 67yrs, M 58yrs)
# sample BC1 = low grade Ta non-malignant NMIBC cells from (M, 67yrs)
# sample BC6 = low grade Ta non-malignant NMIBC cells from (M, 58yrs)
# differences between the two cell sets could be, but not limited to person differences (age, genetic mutations, lifestyle)

# Firstly, I will access the Genomics shared libraries 
.libPaths("libs/R_4.3.3")

# load relevant libraries
library(tidyverse)
citation("tidyverse")
library(Seurat)
citation("Seurat")
library(clustree)
citation("clustree")
library(ggplot2)
citation("ggplot2")
library(ggrepel)
citation("ggrepel")
library(fgsea)
citation("fgsea")

# 1 Load, preview and explore data ####
counts <- Read10X("data5/02_assessment_options/assessment02_BC1-BC6")

# check dimensions of data (i.e number of genes - rows, cells - columns)
dim(counts)
# number of rows = 38606, columns = 16155

# quick preview of data. Structure, type, first few values
str(counts)

# setting IDs and conditions (here = cancer T stages) for counts
ids <- c("BC1", "BC6")
con <- c("BC1", "BC6")

# create a table 'cell_counts' based on column names from 'counts'
# create metadata df, and annotate my data with labels
cell_counts <- table(substring(colnames(counts),18))

# construct two vectors 'sample', 'conditions' from 'ids', 'con' based on 'cell_counts'
# set up sample and condition labels for the backgrounds
samples <- c()
for (s in 1:length(ids)) { 
  samples <- c(samples, (rep(paste(ids)[s], cell_counts[s])))
} 
conditions <- c()
for (c in 1:length(con)) { 
  conditions <- c(conditions, (rep(paste(con)[c], cell_counts[c])))
} 

# now create a metadata df
metadata <- data.frame(Sample=samples, Conditions=conditions, row.names=colnames(counts))

# then check metadata df cell numbers match expected 
metadata |> group_by(Sample) |> summarise(Cells=n())
metadata |> group_by(Conditions) |> summarise(Cells=n())

# create seurat object 'so' from data - R package used for scRNAseq analysis that stores, organise scRNAseq data, metadata, results 
# rows = genes, columns = cells
# 'meta.data' specifies a metadata df which has additional info of each cell (ie cell types)
so <- CreateSeuratObject(counts=counts, project="Genomics_W5assessment", meta.data=metadata)

# assign cell identities based on 'conditions' column from metadata
# for further analysis to consider cells belonging to different conditions
# i.e later DEA, clustering etc can be done based on 'conditions'
Idents(so) <- so@meta.data$Conditions

# check seurat version
packageVersion("Seurat")

# remove unused variables to tidy up memory
rm(c, s, cell_counts, con, conditions, ids, samples, counts, metadata)

# ################################### #

# 2 Data QC check ####

# removing low quality data from data set 
# high Mt% indicates dying cells, often correlated with low number of features
# high number of features suggests 2 cells are present in sample instead of single cell

# calc %MT gene expression  
# add a new metadata column 'percent.mt' of %MT for each cell
so <- PercentageFeatureSet(so, pattern="^MT-", col.name="percent.mt")

# Visualize distribution of MT gene percentages 
VlnPlot(so, features = "percent.mt")

# violin plot to visualize and compare distribution of 2 selected features - number of features, MT%
# across different cell groups (i.e sample or condition)
# assists QC by easing detection of any outliers in my data (low quality/stressed/dying cells)
VlnPlot(so, features=c("nFeature_RNA","percent.mt"), 
        ncol=2, pt.size=0, group.by="Sample", raster=FALSE)

# distribution pattern is different for BC1 BC6 in nFeature_RNA
# BC1 data is too evenly distributed, no median possible to be observed
# In contrast BC6 has nice violin shaped distribution making it relatively easier to decide cut off points to remove low quality data
# so I decide data cut off threshold based on BC6 

# save plot
ggsave("plots5/1_violinplot_preQC.png")

# Summarize key stats based on distribution above, related to %MT and number of features 
# Create a summary table 
summary_metadata <- so@meta.data |> 
  group_by(Sample) |> 
  summarize(
    mt_med = quantile(percent.mt, 0.5),
    mt_q95 = quantile(percent.mt, 0.95),
    mt_q75_plus_IQR = quantile(percent.mt, 0.75) + (1.5 * IQR(percent.mt)),
    feat_med = median(nFeature_RNA),
    feat_q95 = quantile(nFeature_RNA, 0.95),
    feat_q75_plus_IQR = quantile(nFeature_RNA, 0.75) + (1.5 * IQR(nFeature_RNA)),
    count = n()
  )

# print the table
summary_metadata

# scatter plot number of features VS %MT for each cell 
# assists my QC by identifying cells with high MT%, low features (indicative of dying cells/ empty droplets)
ggplot(so@meta.data, aes(nFeature_RNA, percent.mt, colour=Sample)) +
  geom_point(alpha=0.2) + 
  facet_grid(.~Sample) + 
  theme_bw()

ggsave("plots5/2_nfeatures_vs_%MT_preQC.png")

# now remove low feature/high MT% cells using UQ + (1.5*IQR) rule
# find the upper threshold limit for MT% in both samples, then take the lowest value
mt_filt <- min(summary_metadata$mt_q75_plus_IQR)

# find upper threshold limit for feature number in both, then take the lowest value
feat_max_filt <- min(summary_metadata$feat_q75_plus_IQR)

# print proposed thresholds
mt_filt # 6.370424
feat_max_filt # 5279.75
# These are proposed threshold, but I need to take closer look at data first to decide cut off points  

# Taking a closer look at low quality data first - I will use 2 graphs, one for each feature
# this is in preparation to filter data after visualization 

# 1 - zoomed-in version scatter plot focusing on cells < 10% MT content (clear up feature 1)
# I can exclude cells that are potentially stressed/ dying more clearly since zoomed in view
ggplot(subset(so@meta.data, subset = percent.mt < 10), aes(nFeature_RNA, percent.mt, colour=Sample)) + 
  geom_point(alpha=0.2) + 
  facet_grid(.~Sample) + 
  theme_bw() + 
  xlim(0,8000) + # set limits to x axis to zoom in when viewing graph to decide cut off point

ggsave("plots5/3_%MT_zoomedlowqual_QC.png")

# 2 - density plot for number of features detected per cell (clear up feature 2) 
# across different samples in the seurat object 'so' I created earlier
# from plot I can identify potential problems like under-sampling or a variability in number of genes detected
ggplot(so@meta.data, aes(x=nFeature_RNA, colour=Sample)) + 
  geom_density() + 
  facet_grid(.~Sample) + 
  theme_bw() + 
  xlim(0,3500) # set limits for x axis to zoom in when viewing graph to decide cut off point, the 'dip' in graph 
# graph 'dip' is approx at 1800 on x axis

ggsave("plots5/4_nfeature_zoomedlowqual_QC.png")

# Now I can begin data filtering process! - filter based on 3 conditions
# 1 - cells < 1800 features (genes) detected
# 2 - cells with more than number of features defined by 'feat_max_filt' 
# 3 - % MT gene expression. Threshold 6.370424 prev defined by 'mt_filt'. Again, filtering out cells with high MT content as indicative of low quality cells (i.e dying)
so <- subset(so, subset = nFeature_RNA >= 1800 & nFeature_RNA <= feat_max_filt & percent.mt <= mt_filt)

# after filtering I have new data set - post QC
# so generate new summary data for filtered data set 
so@meta.data |> group_by(Sample) |> summarize(mt_med = quantile(percent.mt, 0.5),
                                              mt_q95 = quantile(percent.mt, 0.95),
                                              mt_q75_plus_IQR = quantile(percent.mt, 0.75) + (1.5 * IQR(percent.mt)),
                                              feat_med = median(nFeature_RNA),
                                              feat_q95 = quantile(nFeature_RNA, 0.95),
                                              feat_q75_plus_IQR = quantile(nFeature_RNA, 0.75) + (1.5 * IQR(nFeature_RNA)),
                                              count = n())

# now visualize new summary data post QC - violin plot like previous
# violin plot to visualize and compare distribution of 2 selected features - number of features, MT%
# across different cell groups (i.e sample or condition)
VlnPlot(so, features=c("nFeature_RNA", "percent.mt"), 
        ncol=2, pt.size=0, group.by="Sample", raster=FALSE)

# Recap - I have chosen thresholds based on BC6 as it had better initial distribution to decide data cut off points
# filtered data only shows cells of good quality facilitating my downstream analysis

ggsave("plots5/5_violinplot_postQC.png")

# some points to consider about the QC process is that : 
# same filters are applied to both data sets BC1 BC6, which would surely have differences (i.e starting distributions, sequencing depth across data sets)
# a threshold that works well for one data set may i.e discard good quality cells in another
# but can only try our best when deciding cut-off point - i.e zooming into graph. It is better than including bad quality data!

# create save point
save.image("savepointA_QC-complete.RData")

# ############################################## #

# 3 Data Integration ####

# merge data sets after filtering each data sets individually. Need to ensure filtering doesn't bias data
# potential problem - imbalanced data set (i.e one was aggressively filtered = has far fewer cells than other, could cause bias downstream)
# use stats to account for these differences (i.e normalization, batch correction, merging strategies)
# here I use normalization 

# Merging data is crucial for comparison 
# different cell types from one person can be more similar than same cell type from 2 people 
# this means same cell type from different donors would be separated during analysis/ clustering - not useful
# integration needed to allow comparison

# split objects by conditions defined in section 1 
con.list <- SplitObject(so, split.by = "Conditions")

# normalize and identify variable features for each data set independently
# also ensure the modified object is returned so con.list is updated
# top 3000 most variable genes selected for downstream analysis
con.list <- lapply(X = con.list, FUN = function(x) {
  x <- NormalizeData(x, normalization.method = "LogNormalize")
  x <- FindVariableFeatures(x, selection.method = "vst", nfeatures = 3000)
  return(x)  
})

# Scale the data and perform PCA for each condition
con.list <- lapply(X = con.list, FUN = function(x) {
  x <- ScaleData(x)
  x <- RunPCA(x)
  return(x)
})

# after normalization and variable feature selection - standard thing to do is integrate the 2 conditions based on shared variable features
# then can proceed with other analyses such as scaling, PCA, clustering, or differential expression
# I prev selected top 3000 most variable genes to look at (nfeature)
# when shared variable features close to 3000 = likely lose biological difference
# but some similarities/ shared variables (to certain extent) needed to merge 2 data sets = ~600-2400, closer halfway the better

# check overlap between most variable features in 2 conditions (BC1,BC6)
length(intersect(VariableFeatures(con.list$BC1), VariableFeatures(con.list$BC6)))
# 1385

# select features repeatedly variable across data sets for integration
intfeats <- SelectIntegrationFeatures(object.list = con.list, nfeatures = 3000)

# integration - finally! Now combine data sets using anchors 
int.anchors <- FindIntegrationAnchors(object.list = con.list, anchor.features = intfeats)
so_donorint <- IntegrateData(anchorset = int.anchors)

# scaling data to ensure genes with higher variance don't dominate analysis following integration, each feature contributes equally
# set default assay to 'integrated' so downstream analysis uses integrated data (corrected values)
# instead of data before integration/ raw counts etc
DefaultAssay(so_donorint) <- "integrated"
so_donorint <- ScaleData(so_donorint, features = rownames(so_donorint))

# clear up after integration 
# splitted conditions, anchors used to integrate datasets, features selected for integration, original 'so' object before processing
rm(con.list, int.anchors, intfeats, so)

# create save point 
save.image("savepointB_QC-integration-complete.RData")

# Extra analysis (1,2,3,4) ####

# since no new packages were able to be downloaded, i do custom things

# Custom Ligand-Receptor Interaction Networks
# use custom lists of ligands and receptors to build your interaction network manually

# Define ligand-receptor pairs (from a database or literature)
ligand_receptor_pairs <- data.frame(
  Ligand = c("CD80", "CD86","CD70", "CCL2", "CXCL9"),
  Receptor = c("CD28", "CD28", "CD27", "CCR2", "CXCL9")
)

# Create a data frame to represent ligand-receptor interactions for each cell
ligand_receptor_matrix <- data.frame(cell = colnames(so), stringsAsFactors = FALSE)

# Loop over each ligand-receptor pair and check if they are present in the gene list
for (i in 1:nrow(ligand_receptor_pairs)) {
  ligand <- ligand_receptor_pairs$Ligand[i]
  receptor <- ligand_receptor_pairs$Receptor[i]
  
  # Check if the ligand and receptor genes exist in the Seurat object (so)
  ligand_receptor_matrix[[paste0("Ligand_", ligand)]] <- ifelse(ligand %in% rownames(so), 1, 0)
  ligand_receptor_matrix[[paste0("Receptor_", receptor)]] <- ifelse(receptor %in% rownames(so), 1, 0)
}

# Assign this new matrix to the Seurat object metadata
so@meta.data <- cbind(so@meta.data, ligand_receptor_matrix[, -1])  # Remove 'cell' column as it's redundant

# Verify if the new columns have been added
head(so@meta.data)

# Calculate the expression of ligands and receptors for each cell type (or cluster) in your Seurat object.
ligand_expression <- FetchData(so_donorint, vars = ligand_receptor_pairs$Ligand)
receptor_expression <- FetchData(seurat_object, vars = ligand_receptor_pairs$Receptor)

# Calculate potential interactions based on co-expression or proximity of ligand-receptor pairs.
# Example: correlation of ligand and receptor expression
interaction_scores <- cor(ligand_expression, receptor_expression)

# Visualize the interactions as a network.
library(igraph)

network_graph <- graph_from_data_frame(ligand_receptor_pairs)

# Open a graphics device (PNG in this case)
png("plots5/ligandreceptorinteractions.png", 
    width = 1000, height = 800, res = 300, bg = "white")

plot(network_graph,
     vertex.label = V(network_graph)$name, 
     vertex.label.cex = 0.3,         # Adjust label size
     vertex.label.color = "black",   # Label color
     vertex.label.dist = 4)          # Distance from node

# Close the device to save the plot
dev.off()

To sort your WooCommerce products by the highest discount using JetSmartFilters' **Sort Filter**, you can use the following steps and PHP snippet:

---

### **1. Add a Custom Meta Key for Discount Calculation**
You need to calculate and store the discount as a custom meta key for each product. This meta key will be used in the JetSmartFilters Sort Filter.

Add the following PHP snippet to your theme's `functions.php` file or a custom plugin:

```php
add_action('save_post_product', 'update_product_discount_meta');
function update_product_discount_meta($post_id) {
    // Ensure it's a product post type
    if (get_post_type($post_id) !== 'product') {
        return;
    }

    // Get the product object
    $product = wc_get_product($post_id);
    if (!$product) {
        return;
    }

    // Get the regular and sale prices
    $regular_price = (float) $product->get_regular_price();
    $sale_price = (float) $product->get_sale_price();

    // Calculate the discount percentage
    if ($regular_price > 0 && $sale_price > 0) {
        $discount = round((($regular_price - $sale_price) / $regular_price) * 100);
    } else {
        $discount = 0; // No discount
    }

    // Update the custom field with the discount value
    update_post_meta($post_id, '_product_discount', $discount);
}
```

---

### **2. Recalculate Discounts for Existing Products**
To apply the discount calculation to existing products, you can run a script or use a plugin like **WP Crontrol** to loop through all products and update their discounts.

```php
add_action('init', 'recalculate_discounts_for_all_products');
function recalculate_discounts_for_all_products() {
    $args = array(
        'post_type' => 'product',
        'posts_per_page' => -1,
        'fields' => 'ids',
    );
    $products = get_posts($args);

    foreach ($products as $product_id) {
        update_product_discount_meta($product_id);
    }
}
```
This will process all products and save their discounts. After running it once, you can remove or comment out this action.

---

### **3. Configure the JetSmartFilters Sort Filter**
In the **Sort Filter** settings (as shown in your screenshot):
1. **Order By**: Select **Meta Key Numeric** (since the discount is a number).
2. **Key**: Enter `_product_discount` (the meta key used in the PHP snippet).
3. **Order**: Set to **DESC** (to sort from highest to lowest discount).

---

### **4. Test the Sorting**
- Add the JetSmartFilters **Sort Filter** to the page where your product listing grid is displayed.
- Ensure the sorting works as expected, with the products having the highest discount appearing first.

Clase	    Media Query Range		Ejemplo de Clase
col-*		Default (XS: <576px)	col-12
col-sm-*	≥576px					col-sm-6
col-md-*	≥768px					col-md-4
col-lg-*	≥992px					col-lg-3
col-xl-*	≥1200px					col-xl-2
col-xxl-*	≥1400px (Bootstrap 5)	col-xxl-1

* GOAL: Within a macro, you want to create a new variable name.
* It could then be used as a data set name, or a variable name to be assigned, etc.;
%macro newname(dset=,varname=);
* You have to make the new name before you use it in
* another data statement;
data _NULL_;
L1=CATS("&varname","_Plus1");
CALL SYMPUT('namenew',L1);
;
* Now you can use the variable name created by SYMPUT;
DATA REVISED;SET &DSET;
   &namenew=&varname+1;
run;
%mend;
Data try;
input ABCD @@;
datalines;
1 2 3 4
;run;
%newname(dset=try,varname=ABCD);
proc print data=revised;run;

https://pubads.g.doubleclick.net/gampad/ads?iu=/21775744923/external/single_ad_samples&sz=640x480&cust_params=sample_ct%3Dredirecterror&ciu_szs=300x250%2C728x90&gdfp_req=1&output=vast&unviewed_position_start=1&env=vp&impl=s&nofb=1&correlator=

https://pubads.g.doubleclick.net/gampad/ads?iu=/21775744923/external/single_ad_samples&sz=640x480&cust_params=sample_ct%3Dredirecterror&ciu_szs=300x250%2C728x90&gdfp_req=1&output=vast&unviewed_position_start=1&env=vp&impl=s&correlator=

Dork For : Finding exposed cloud service credentials

Regards,
Joel Indra

            

git clone https://github.com/yourusername/hospital-management-system.git

{
	"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 Happy Monday Melbourne!\n\n"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":coffee: Barista Services on Level 2 :coffee:",
				"emoji": true
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": " Wednesday, 29th January :calendar-date-22:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": " \n\n :lunch: *Light Lunch*: Provided by Kartel Catering from *12:30pm* on *Levels 1 & 2!* \n\n"
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": "Thursday, 23rd January :calendar-date-23:",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":breakfast: *Breakfast*: Provided by *Kartel Catering* from *8:30am - 10:30am on Levels 1 & 2*. \n\n "
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "Stay tuned for more fun throughout the year. Happy 2025! :party-wx:"
			}
		}
	]
}

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": " :mirror_ball::star: Boost Days - What's on this week! :star::mirror_ball:"
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "See below for what's in store for our Boost Days this week:"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-21: Tuesday, 28th January",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Xero Café*: Café-style beverages and sweet treats \n\n:meow-coffee-intensifies-and-shakes: *Barista Special*: _Iced Chai Latte_ \n\n:pancakes: *Breakfast*: Provided by *Catroux* from *8:30am - 10:30am* \n\n :nail_care::skin-tone-2: *Tipsy Manicures:* Emma offers quick Shape & Shine express manicures, Gel It Manicures & Pedicures and Hand N’ Arm & Foot N’ Leg Massages, there's a treatment for everyone's pampering needs. treat yourself <https://docs.google.com/spreadsheets/d/1pTGAD8oFXmPF890Uzj4d-Crfch8muuzEzDnNyBA9ReY/edit?gid=23583621#gid=23583621|*here.*> "
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-23: Thursday, 30th January",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":coffee: *Xero Café*: Café-style beverages and sweet treats \n\n :meow-coffee-intensifies-and-shakes: *Barista Special*: _Iced Chai Latte_ \n\n :sandwich: *Light Lunch*: Provided by *Catroux* from *12:30pm - 1:30pm* \n\n  \n\n"
			}
		},
		{
			"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?cid=eGVyby5jb21fMXM4M3NiZzc1dnY0aThpY2FiZDZvZ2xncW9AZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ|*Auckland Social Calendar*>, and get ready to Boost your workdays!\n\nLove,\nWX :wx:"
			}
		}
	]
}

gdb -tui -ex=r --args out/Debug/chrome --disable-seccomp-sandbox \
    http://google.com

// Custom function for validating phone numbers across multiple forms and fields
add_filter('gform_field_validation', function($result, $value, $form, $field) {

    $form_field_pairs = [
        4 => [8],
        1 => [4],
        2 => [4],
        3 => [4],
    ];

    if (isset($form_field_pairs[$form['id']]) && in_array($field->id, $form_field_pairs[$form['id']])) {
       
        $pattern = '/^\d{10}$/';
        
        if (!preg_match($pattern, $value)) {
            $result['is_valid'] = false;
            $result['message'] = 'Please enter a valid 10-digit phone number.';
        }
    }

    return $result;
}, 10, 4);

# 6 Immune cell scoring ####
# since community 1, 0 both contain immune cells, do immune cell scoring to see involvement 

# Score each cell based on activation of listed genes 




# for T cell activation 
# define a gene set for T-cell activation
tcell_activation_genes <-  c("CD69", "CD3G", "IFNG", "TNF", "CD3E", "CD3D", "ZAP70", "LCK")

# add activation score to Seurat object
seurat_object <- AddModuleScore(so_donorint, features = list(tcell_activation_genes), name = "Tcell_Activation")

# visualize activation score and save plot
VlnPlot(seurat_object, features = "Tcell_Activation1", pt.size = 0)
ggsave("plots5/tcellactivation_0.25.png")





# for cytotoxic T cells 
# define cytotoxic T cells gene set and add cytotoxic T cells score to Seurat object
cytotoxic_tcell_genes <-  c("CD8A", "GZMK", "GZMA") 
seurat_object <- AddModuleScore(seurat_object, features = list(cytotoxic_tcell_genes), name = "Cytotoxic_Tcell")

# visualize cytotoxic T cells 
VlnPlot(seurat_object, features = "Cytotoxic_Tcell1", pt.size = 0)
ggsave("plots5/cytotoxictcells_0.25.png")



# for exhausted T cells
# define exhausted T cells gene set abd add exhausted T cells score to Seurat object
exhausted_tcell_genes <-  c("PD1", "CTLA4", "LAG3", "TIM3") 
seurat_object <- AddModuleScore(seurat_object, features = list(exhausted_tcell_genes), name = "Exhausted_Tcell")

# visualize exhausted T cells 
VlnPlot(seurat_object, features = "Exhausted_Tcell1", pt.size = 0)
ggsave("plots5/exhaustedtcells_0.25.png")





# for Macrophage activation 
# define a gene set for macrophage activation
macrophage_activation_genes <-  c("CD80", "CD86", "TNF", "IL6", "STAT1", "IRF5", "iNOS", "CXCL8", "IL8")

# add activation score to Seurat object
seurat_object <- AddModuleScore(so_donorint, features = list(macrophage_activation_genes), name = "Macrophage_Activation")

# visualize activation score
VlnPlot(seurat_object, features = "Macrophage_Activation1", pt.size = 0)
ggsave("plots5/macrophageactivation_0.25.png")




# for B cell activation - just exploring 
# define a gene set for B-cell activation
bcell_activation_genes <-  c("IRF4", "CD86", "CD79A", "BTK")

# add activation score to Seurat object
seurat_object <- AddModuleScore(so_donorint, features = list(bcell_activation_genes), name = "Bcell_Activation")

# visualize activation score
VlnPlot(seurat_object, features = "Bcell_Activation1", , pt.size = 0)
ggsave("plots5/bcellactivation_0.25.png")



For full activation, B cells require co-stimulatory signals, often provided by T helper cells (Tfh cells) during T-dependent activation or through pathogen-associated signals during T-independent activation.

# 6 Res 0.25 ####

# ensure assay is integrated 
DefaultAssay(so_donorint) <- "integrated"

# set resolution at 0.25 which is higher than previously used 0.05 for clustering cells 
res <- 0.25

# now assign cells to a cluster and run UMAP - reduce dimensions so I can visualize
# UMAP allows visualizing clusters 
# 2D representation of cells to visualize similarities/differences based on high dimensional features (i.e gene expression) - based on first PCA
so_donorint <- FindClusters(so_donorint, resolution = res)
so_donorint <- RunUMAP(so_donorint, dims=1:pcs, return.model = TRUE, verbose = FALSE)

# UMAP plot - Visualization of my clustered data using UMAP plot 
DimPlot(so_donorint, reduction = "umap", label = TRUE, label.size = 6)
# as expected, further subdivision of community X shown

ggsave("plots5/UMAP_res0.25.png")

# split UMAP plot - based on 'conditions' + add labels 
# shows me how clusters are distributed across different experimental conditions 
DimPlot(so_donorint, reduction = "umap", split.by = "Conditions", label = TRUE, label.size = 6)
# similar to UMAP at res 0.05, community 0 shown to lack large proportion of cells 

ggsave("plots5/split_UMAP_res0.25.png") 

# % distribution of each cell cluster across different conditions 
# allows me to understand how cell populations are organized in relation to experimental conditions 
round(prop.table(table(Idents(so_donorint), so_donorint$Conditions))*100,3)


# DEA for cell communities at resolution 0.25

# now prepare DEA
# switch back to integrated assay for comparisons 
DefaultAssay(so_donorint) <- "integrated"

# run DEA to identify differentially expressed genes between community 1, 0
uro.markers <- FindMarkers(so_donorint, ident.1 = 7, ident.2 = 5)
# graph description is based on ident.1 = community x
# but I have repeated the above code with different 'ident' to compare gene expression between communities

# check data frame 
head(uro.markers)

# avoid errors caused by small p-values downstream by setting p-value limits
# all adjusted p-value > or = to (1e-300)
uro.markers["p_val_adj"] <- lapply(uro.markers["p_val_adj"], pmax, 1e-300)

# preparation for volcano plot
# categorize genes (in uro.markers) based on their DEA results
# create new column 'DEA' to classify each gene as up, down, no based on log fold-change and adjusted p-value
uro.markers$DEA <- "NO"
uro.markers$DEA[uro.markers$avg_log2FC > 1 & uro.markers$p_val_adj < 0.05] <- "UP"
uro.markers$DEA[uro.markers$avg_log2FC < -1 & uro.markers$p_val_adj < 0.05] <- "DOWN"
uro.markers$genes <- rownames(uro.markers)

# Volcano plot to visualize DEA results for comparison between the conditions (Ta1, Ta6)
ggplot(uro.markers, aes(x=avg_log2FC, y=-log10(p_val_adj))) + 
  geom_point(aes(colour = DEA), show.legend = FALSE) + 
  scale_colour_manual(values = c("blue", "gray", "red")) +
  geom_hline(yintercept = -log10(0.05), linetype = "dotted") + 
  geom_vline(xintercept = c(-1,1), linetype = "dotted") + 
  theme_bw() + 
  theme(panel.border = element_blank(), panel.grid.major = element_blank(), panel.grid.minor = element_blank(), axis.line = element_line(colour = "black"), plot.title = element_text(hjust = 0.5)) +
  geom_text_repel(data=subset(uro.markers, (abs(avg_log2FC) > 9 & p_val_adj < 0.05)| (avg_log2FC < -5 & p_val_adj < 0.05)), aes(x=avg_log2FC, y=-log10(p_val_adj), label=genes), max.overlaps = 1000, size=4.5) +
  ggtitle("DEA between community 7 and 5 (7 in red)") 

# Extract upregulated genes (log fold change > 4, p-value < 0.05 )
upreg_res_0.25 <- uro.markers[uro.markers$avg_log2FC > 2 & uro.markers$p_val_adj < 0.05, "genes"]

# Extract downregulated genes (log fold change > 4, p-value < 0.05 )
downreg_res_0.25<- uro.markers[uro.markers$avg_log2FC < -3 & uro.markers$p_val_adj < 0.05, "genes"]

print(upreg_res_0.25) 

print(downreg_res_0.25)

ggsave("plots5/volcano_integrated_7vs5.png")

sudo lsof -t -i tcp:80 -s tcp:listen | sudo xargs kill

sudo lsof -i tcp:80 -s tcp:listen

sudo lsof -i tcp:80

COMMAND  PID     USER   FD   TYPE DEVICE SIZE/OFF NODE NAME  
nginx   1858     root    6u  IPv4   5043      0t0  TCP ruir.mxxx.com:http (LISTEN)  
nginx   1867 www-data    6u  IPv4   5043      0t0  TCP ruir.mxxx.com:http (LISTEN)  
nginx   1868 www-data    6u  IPv4   5043      0t0  TCP ruir.mxxx.com:http (LISTEN)  
nginx   1869 www-data    6u  IPv4   5043      0t0  TCP ruir.mxxx.com:http (LISTEN)  
nginx   1871 www-data    6u  IPv4   5043      0t0  TCP ruir.mxxx.com:http (LISTEN)  

echo kill $(sudo netstat -anp | awk '/ LISTEN / {if($4 ~ ":80$") { gsub("/.*","",$7); print $7; exit } }')

netstat -anp --numeric-ports | grep ":${PORT}\>.*:" 

fuser -v "${PORT}"/tcp

lsof -P -S 2 -i "tcp:${PORT}" | grep "\(:${PORT}->.*:\|:$PORT (LISTEN)$\)"

$ netstat -anp --numeric-ports | grep ":80\>.*:" 
tcp6       0      0 :::80           :::*            LISTEN      1914/apache2    

$ fuser -v "80/tcp"
                     USER        PID ACCESS COMMAND
80/tcp:              root       1914 F.... apache2
                     www-data  12418 F.... apache2
...

$ lsof -P -S 2 -i "tcp:80" | grep "\(:80->.*:\|:80 (LISTEN)$\)"
apache2  1914     root    4u  IPv6   11920      0t0  TCP *:80 (LISTEN)
apache2 12418 www-data    4u  IPv6   11920      0t0  TCP *:80 (LISTEN)
...

CMS:

{url entity='cms' id=6 id_lang=Context::getContext()->language->id}

Category:
{url entity='category' id=ID_CATEGORIA}

Producto:
{url entity='product' id=ID_PRODUCTO}

Brand:
{url entity='manufacturer' id=ID_MANUFACTURER}

Sitemap:
{$urls.pages.sitemap}


Attachments
{url entity='attachment' params=['id_attachment' => $attachment.id_attachment]}

public class Solution {
    public int solve(int[] A, int B) {
        
        HashMap<Integer,Integer> hm=new HashMap<>();
        
        int cnt=0;
        int sum=0;
        hm.put(0,1);
        for(int i=0;i<A.length;i++){
            sum^=A[i];
            if(hm.containsKey(sum^B)){
                cnt+=hm.get(sum^B);
                
            }if(hm.containsKey(sum)){
                hm.put(sum,hm.get(sum)+1);
            }
            else{
                hm.put(sum,1);
            }
            
        }
        return cnt;
    }
}

class Solution {
    public List<List<Integer>> threeSum(int[] nums) {
        List<List<Integer>> ll=new ArrayList<>();
        
        Arrays.sort(nums);
        for(int i=0;i<nums.length;i++){
           
           if(i>0 && (nums[i]==nums[i-1]))
                continue;
            int j=i+1;
            int k=nums.length-1;
            while(j<k){
                int sum=nums[i]+nums[j]+nums[k];
                if(sum<0){
                    j++;
                }
                else if(sum>0){
                    k--;
                }
                else{
                    List<Integer> l=new ArrayList<>();
                    l.add(nums[i]);
                    l.add(nums[j]);
                    l.add(nums[k]);
                    j++;
                    k--;
                    while(j<k && nums[j]==nums[j-1]){
                        j++;
                    }
                    while(j<k && nums[k]==nums[k+1]){
                        k--;
                    }
                    ll.add(l);

                }
            }
        }
            return ll;
    }
}

<style>
  .elementor-element:not(.dont) {
    opacity: 0;
    transform: translateY(8vh) skewY(-3deg);
    transition: opacity 0.5s ease, transform 0.8s ease 0.2s;
  }
  .elementor-element.animated:not(.dont) {
    opacity: 1;
    transform: translateY(0) skewY(0deg);
  }
</style>

<script>
  document.addEventListener("DOMContentLoaded", () => {
    const handleIntersection = (entries, observer) => {
      entries.forEach(entry => {
        entry.target.classList.toggle('animated', entry.isIntersecting);
      });
    };
    const observer = new IntersectionObserver(handleIntersection, {
      root: null,
      rootMargin: '0px',
      threshold: 0
    });
    document.querySelectorAll('.elementor-element').forEach(element => observer.observe(element));
  });

/templates/catalog/_partials/miniatures/product.tpl

<div style="text-align: center; margin: 3px;">
    	<form action="{$urls.pages.cart}" method="post" id="add-to-cart-or-refresh">	
          <input type="hidden" name="token" value="{$static_token}">
          <input type="hidden" name="id_product" value="{$product.id}" id="product_page_product_id">
          <button class="btn btn-primary add-to-cart {if $product.quantity < 1}out-of-stock{/if}" data-button-action="add-to-cart" type="submit">
                   <i class="material-icons shopping-cart">shopping_cart</i>
                   {l s='Add to cart' d='Shop.Theme.Actions'}
          </button>
  		</form>
</div>

<div class="pro-manufacture">
<a href="{$link->getManufacturerLink($product.id_manufacturer)|escape:'html':'UTF-8'}" title="{Manufacturer::getNameById($product.id_manufacturer|escape:'html':'UTF-8')}">{Manufacturer::getNameById($product.id_manufacturer|escape:'html':'UTF-8')}</a>
</div>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script>
$(document).ready(function () {
    var pageMap = {
        "/en/whale-safari/": "https://fareharbor.com/embeds/book/kullabergsguiderna/?full-items=yes&flow=1324061",
        "/tumlarsafari/": "https://fareharbor.com/embeds/book/kullabergsguiderna/?full-items=yes&flow=1324061",
        "/grottvandring/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510420/?full-items=yes&flow=1085497",
        "/en/cavewalk/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510420/?full-items=yes&flow=1085497",
        "/en/rent-a-mountainbike-on-kullaberg/": "https://fareharbor.com/embeds/book/kullabergsguiderna/?full-items=yes&flow=1089659",
        "/hyr-en-mountainbike-cykla-pa-kullaberg/": "https://fareharbor.com/embeds/book/kullabergsguiderna/?full-items=yes&flow=1089659",
        "/en/abseiling/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510419/?full-items=yes&flow=1085497",
        "/bergsnedfirning-pa-kullaberg/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510419/?full-items=yes&flow=1085497",
        "/en/coasteering-eng/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510439/?full-items=yes&flow=1085497",
        "/coasteering/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510439/?full-items=yes&flow=1085497",
        "/en/bike-rental/": "https://fareharbor.com/embeds/book/kullabergsguiderna/?full-items=yes&flow=1324078",
        "/hyrcykel/": "https://fareharbor.com/embeds/book/kullabergsguiderna/?full-items=yes&flow=1324078",
        "/en/treasure-hunt/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510421/?full-items=yes&flow=1085497",
        "/kullamannens-skattjakt/": "https://fareharbor.com/embeds/book/kullabergsguiderna/items/510421/?full-items=yes&flow=1085497"
    };

    // Get the current page path
    var currentPath = window.location.pathname;

    // Check if the current path exists in the pageMap
    if (pageMap[currentPath]) {
        var bookingURL = pageMap[currentPath];

        // Create the desktop button
        var desktopButton = $('<a>', {
            href: bookingURL,
            style: "margin-right: 2em !important; text-decoration:none !important; font-family:'Roboto Condensed', sans-serif !important; font-size:20px !important; font-weight:700 !important; letter-spacing: 1.1px !important;box-shadow:none !important; padding: .15em 2em !important;",
            class: "fh-hide--mobile fh-fixed--bottom fh-icon--cal fh-button-true-flat-color fh-shape--square fh-lang",
            text: "BOKA NU"
        });

        // Create the mobile button
        var mobileButton = $('<a>', {
            href: bookingURL,
            style: "text-decoration:none !important; width: 50% !important; margin: 0 auto !important; font-family:'Roboto Condensed', sans-serif !important; font-size: 1.2em !important; font-weight:bold !important; letter-spacing: 1.1px !important; box-shadow:none !important; text-align: center !important; width: 60% !important;",
            class: "fh-hide--desktop fh-size--small fh-fixed--bottom fh-button-true-flat-color fh-color--white fh-shape--square fh-lang",
            text: "BOKA NU"
        });

        // Append the buttons to the body
        $('body').append(desktopButton).append(mobileButton);

        // Update text to "BOOK NOW" for English pages
        if (currentPath.includes('/en/')) {
            $('a.fh-fixed--bottom').text('BOOK NOW');
        }
    }
});
</script>

Beleaf Technologies offers the ultimate solution for meme coin development, turning creative ideas into successful digital currencies. With expertise in blockchain technology, we provide start-to-end services, including concept design, token creation, smart contract development, and marketing strategies. Our team ensures smooth creation,flexcibility, and security for your project. Partner with Beleaf Technologies and bring your vision to life in the vibrant world of meme coins. Your success is our priority!


Create your own meme coin effortlessly with Beleaf Technologies! We provide customized solutions, from design to deployment, ensuring a unique, secure, and successful digital currency customize to your vision.

Contact today for free demo : https://www.beleaftechnologies.com/meme-coin-development-company
Whatsapp: +91 7904323274
Skype: live:.cid.62ff8496
d3390349
Telegram: @BeleafSoftTech
Mail to: mailto:business@beleaftechnologies.com

https://codepen.io/robooneus/pen/ANgJJm

htmlllllll
<div class="click-mobile" id="menu">
  	<span></span>
</div>
jsssssssssss
//
// This is The Scripts used for Simply Theme
//
function main() {
  (function () {
    'use strict'
    //Script
    //-----------------------------------
    $(document).ready(function($){
      $('.click-mobile').click(function(){
        $('.head-menu').slideToggle(400);
        return false;
      });

      $("#menu").click(function () {
        $(this).toggleClass("active");
        $(".head-menu").toggleClass("active");
      });
    });

  }());
}
main();
csssssssssssssssssssssssssssss
/* click-mobile */
.click-mobile{
    position: relative;
    display: none;
	cursor: pointer;
}

.click-mobile span{
    background: #2a2929;
    height: 4px;
    width: 41px;
    display: block;
    position: relative;
    border-radius: 1px;
}

.click-mobile::before,
.click-mobile::after{
    content: ' ';
    height: 4px;
    width: 41px;
    background: #2a2929;
    position: absolute;
    transition: transform 0.3s;
    border-radius: 1px;
}

.click-mobile::before{
    top: -8px;
}

.click-mobile::after{
    bottom: -8px;
}

.click-mobile.active span {
    visibility: hidden;
    transition: transform 0.3s;
}

.click-mobile.active::before,
.click-mobile.active::after {
  content: "";
  position: absolute;
  width: 41px;
  height: 4px;
  background: #2a2929;
  top: 0;
  left: 0;
  transition: transform 0.3s;
  border-radius: 1px;
}

.click-mobile.active::before {
  transform: rotate(45deg);
}

.click-mobile.active::after {
  transform: rotate(-45deg);
}
/*  */
@media(max-width: 767px){
	.click-mobile{
		display: block;
		position: absolute;
		right: 20px;
		top: 50%;
		transform: translateY(-50%);
		z-index: 9;
	}
	.head-menu{
		display: none;
	}
	.head-menu{
		position: absolute;
		top: 120px;
		left: 0;
		width: 100vw;
		height: 100vh;
		background: #fff;
		z-index: 10;
	}
	.head-menu ul{
		flex-direction: column;
		padding: 30px 20px;
	}
	nav.head-menu ul li a{
		text-align: center;
		margin: 0;
		padding: 5px 0;
		display: block;
	}
	nav.head-menu ul li a::after{
		display: none;
	}
}

<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 100 100" width="100" height="100">
  <!-- Metà colorata (gold) -->
  <clipPath id="left-half">
    <rect x="0" y="0" width="50" height="100"/>
  </clipPath>
  <polygon points="50,5 61,35 95,35 67,57 78,90 50,70 22,90 33,57 5,35 39,35" fill="#FFD700" clip-path="url(#left-half)"/>
  
  <!-- Metà bianca -->
  <clipPath id="right-half">
    <rect x="50" y="0" width="50" height="100"/>
  </clipPath>
  <polygon points="50,5 61,35 95,35 67,57 78,90 50,70 22,90 33,57 5,35 39,35" fill="#FFFFFF" clip-path="url(#right-half)"/>
</svg>

<br>

<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 100 100" width="100" height="100">
  <polygon points="50,5 61,35 95,35 67,57 78,90 50,70 22,90 33,57 5,35 39,35" fill="#FFD700"/>
</svg>

{% if request.path[1] == 'product' and request.path[2] > '' %}
				    {% set ky = product.categoryUID|keys %}

				    {% set keyToPrint = '' %}
				    {% set countChildren = 0 %}
				    {% set countChildrenOld = 0 %}
				    {% for key,id in product.categoryUID %}
			            {% set countChildrenOld = countChildren %}
				        {% set cat = getCategory(id) %}
				        {% if cat.parentUID > 0 %}
				            {% set countChildren = countChildren + 1 %}
				            {% set c1 = getCategory(cat.parentUID) %}
                            {% if c1.parentUID > 0 %}
    				            {% set countChildren = countChildren + 1 %}
    				            {% set c2 = getCategory(c1.parentUID) %}
    	                        {% if c2.parentUID > 0 %}
        				            {% set countChildren = countChildren + 1 %}
        				            {% set c3 = getCategory(c2.parentUID) %}
        	                        {% if c3.parentUID > 0 %}
            				            {% set countChildren = countChildren + 1 %}
            				            {% set c4 = getCategory(c3.parentUID) %}
            				            {% if c4.parentUID > 0 %}
                				            {% set countChildren = countChildren + 1 %}
                				        {% endif %}
            				        {% endif %}
        				        {% endif %}
    				        {% endif %}
				        {% endif %}
				        {% if countChildren > countChildrenOld %}
				            {#% set countChildren = 0 %#}
				            {% set keyToPrint = id %}
				        {% endif %}
				    {% endfor %}
				    {% if countChildren == 0 and countChildrenOld == 0 %}
				        {% set keyToPrint = product.categoryUID[ky|last] %}
				    {% endif %}
				    
				    {#
                    {% set last_key = ky|last %}
					{% set category_id = product.categoryUID[last_key] %}
					{% set js_cat_path = '' %}
					
					{% set list = getCategoryList(category_id) %}
					#}
					
					{% set list = getCategoryList(keyToPrint) %}
					{% for k,category in list %}
						{% if category.name != '' and not category.disabled %}
							<li  itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem">
							    <a href="{% if canonical %}{{getSpokenCategoryUrl(category.uid,category.slug)}}{%else%}{{getCategoryURL(category.uid)}}{% endif %}" itemprop="item"> {{ category.name }} </a>
							    <meta itemprop="position" content="{{ (k+3) }}" />
								<meta itemprop="name" content="{{ category.name | escape('html') }}" />
								{% set js_cat_path = js_cat_path ~ ' | ' ~ category.name %}
							</li>
						{% endif %}
					{% endfor %}
					<li  itemprop="itemListElement" itemscope itemtype="https://schema.org/ListItem">
						<a href="{% if canonical %}{{ getSpokenProductUrl(request.path[2],product.slug)}}{%else%}/product/{{request.path[2] }}{% if request.path[3] != ''%}/{{request.path[3] }}{% endif %}{% endif %}" itemprop="item">
							<meta itemprop="name" content="{{ product.title | escape('html')}}" />{{ product.title }}
							<meta itemprop="position" content="{{ k + 4 }}" />
						</a>
					</li>
				{% endif %}

Task 6:
1. AWS Identity and Access Management (IAM) Task
2. Introduction to Amazon Relational Database Service (RDS) - SQL Server)

AWS Identity and Access Management (IAM) is a web service that enables Amazon Web Services (AWS) customers to manage users and user permissions in AWS. With IAM, you can centrally manage users, security credentials such as access keys, and permissions that control which AWS resources users can access.

Task1: Creating Users:
Step 1: Sign in to the AWS Management Console
Go to the AWS Management Console at https://aws.amazon.com/console/.
Sign in with your AWS account credentials.
Step 2: Navigate to the IAM (Identity and Access Management) Service
In the AWS Management Console, search for IAM in the search bar or find it under the Security, Identity, & Compliance category.
Click on IAM to open the IAM dashboard.
Step 3: Create a New User
In the IAM dashboard, click on Users in the left-hand menu.
Click on Create User
Step 4: Configure the User Details
Enter the User name :User1
Under Select AWS access type, check AWS Management Console access.
For Console password, choose Custom password (You create a password for the User1 as User1@123).
Uncheck   Require password reset to force the user to change their password upon first login.
. Step 5: Set Permissions
Click Next: Permissions.
Choose the following options to set permissions for the user:
Attach existing policies directly: Select policies that define the permissions for the user.
Step 6: Review and Create the User
Click Next: Tags to add optional tags for the user.
Click Next: Review to review the user's details and permissions.
Click Create user to finalize the process.
Click on download .csv file 
 Repeat above steps  for to create User2 and User3
Task 2: Create UserGroups
(a) Create “EC2-Admin”  UserGroup
Step 1: Navigate to the IAM (Identity and Access Management) Service
In the AWS Management Console, search for IAM in the search bar or find it under the Security, Identity, & Compliance category.
Click on IAM to open the IAM dashboard.
Step 2: Create a New User Group
In the IAM dashboard, click on User groups in the left-hand menu.
Click on Create group.
Step 3: Configure the Group Details
Enter EC2-Admin as the Group name.
Click Create group to create the group without attaching any policies at this step.
Step 4: Attach an Inline Policy to the Group
In the User groups list, click on the EC2-Admin group name.
Click on the Permissions tab.
Click Add permissions and then select Create inline policy.
Step 5: Define the Inline Policy
In the Create policy editor, switch to the JSON tab.
Paste the following policy JSON to allow view, start, and stop access to EC2 instances:
{
    "Version": "2012-10-17",
    "Statement": [
        {
            "Effect": "Allow",
            "Action": [
                "ec2:DescribeInstances",
                "ec2:DescribeImages",
                "ec2:DescribeVolumes",
                "ec2:DescribeTags",
                "ec2:DescribeSecurityGroups",
                "ec2:DescribeKeyPairs",
                "ec2:DescribeSnapshots"
            ],
            "Resource": "*"
        },
        {
            "Effect": "Allow",
            "Action": [
                "ec2:StartInstances",
                "ec2:StopInstances"
            ],
            "Resource": "arn:aws:ec2:*:*:instance/*"
        }
    ]
}

Step 7: Name and Attach the Policy
Enter a name for the policy, such as EC2-ViewStartStopAccess.
Click Create policy to attach it to the group.
Step 8: Add Users to the Group
In the EC2-Admin group page, click on the Users tab.
Click Add users.
Select the User3 to add to this group.
Click Add users to finalize the process.

(b) Create “EC2-Support”  UserGroups
Step 1: Navigate to the IAM Service
In the AWS Management Console, search for IAM in the search bar or find it under the Security, Identity, & Compliance category.
Click on IAM to open the IAM dashboard.
Step 2: Create a New User Group
In the IAM dashboard, click on Groups in the left-hand menu.
Click on Create New Group.
Step 3: Configure the Group Details
Enter EC2-Support as the Group Name.
Click Next Step to proceed.
Step 4: Attach a Policy to the Group
On the Attach Policy page, use the search bar to find the AmazonEC2ReadOnlyAccess policy.
Select the checkbox next to AmazonEC2ReadOnlyAccess.
Click Next Step to continue.
Step 5: Review and Create the Group
Review the group's name and attached policies.
Click Create Group to finalize the process.
Step 6: Add Users to the Group (Optional)
To add users, go to the Groups section, select EC2-Support, click on the Group Actions dropdown, and choose Add Users to Group.
Select the User2 and click Add Users.
(c) Create “S3-Support”  UserGroup
Step 1: Navigate to the IAM (Identity and Access Management) Service
In the AWS Management Console, search for IAM in the search bar or find it under the Security, Identity, & Compliance category.
Click on IAM to open the IAM dashboard.
Step 2: Create a New User Group
In the IAM dashboard, click on User groups in the left-hand menu.
Click on Create group.
Step 3: Configure the User Group Details
In the Group name field, enter S3-Support.
Click Next.
Step 4: Attach the S3 Read-only Access Policy
On the Attach policies page, search for AmazonS3ReadOnlyAccess.
Check the box next to the AmazonS3ReadOnlyAccess policy to grant the group read-only access to Amazon S3.
Click Next.
Step 5: Review and Create the Group
Review the group name and attached policy on the Review page.
Click Create group to finalize the process.
Step 6: Add Users to the Group (Optional)
In the User groups page, click on the S3-Support group you just created.
Click on the Users tab.
Click Add users.
Select the User1 to add to this group, Click Add users.
Task 3: Create EC2 Instance named “MyServer” with Linux OS Image 
Task 4: Create S3 bucket and add some files to bucket
Task 5: Sign-In and Test Users
1. In the navigation pane on the left, choose Dashboard.
A Sign-in URL for IAM users in this account link is displayed on the right. It will look similar to: https://123456789012.signin.aws.amazon.com/console
This link can be used to sign-in to the AWS Account you are currently using.
Copy the Sign-in URL for IAM users in this account to a text editor.


2. Open a private (Incognito) window.


Choose the ellipsis at the top-right of the screen
Select New Incognito Window
3. Paste the IAM users sign-in link into the address bar of your private browser session and press Enter.
Sign-in with:
IAM user name: User1
Password:User1@123
4. In the search box to the right of Services, search for and choose S3 to open the S3 console.
Choose the name of the bucket that exists in the account and browse the contents.
Since your user1 is part of the S3-Support Group in IAM, they have permission to view a list of Amazon S3 buckets and the contents.
Now, test whether they have access to Amazon EC2.
 5. In the search box to the right of Services, search for and choose EC2 to open the EC2 console.
In the left navigation pane, choose Instances.
You cannot see any instances. Instead, you see a message that states You are not authorized to perform this operation. This is because this user has not been granted any permissions to access Amazon EC2.
6. At the top of the screen, choose User1
Choose Sign Out
7. Now sign-in as User2, who has been hired as your Amazon EC2 support person.
Paste the IAM users sign-in link into your private browser tab's address bar and press Enter.
Sign-in with:
IAM user name: User2
Password:User2@123 
8. In the search box to the right of Services, search for and choose EC2 to open the EC2 console.
In the navigation pane on the left, choose Instances.
You are now able to see an Amazon EC2 instance “MyServer” because you have Read only permissions. 
However, you will not be able to make any changes to Amazon EC2 resources.
9. Select the instance named  ”MyServer”
In the Instance state menu above, select Stop instance.
In the Stop Instance window, select Stop.
You will receive an error stating You are not authorized to perform this operation. This demonstrates that the policy only allows you to view information, without making changes.
Choose the X to close the Failed to stop the instance message.
10. Next, check if User-2 can access Amazon S3.
In the search box to the right of Services, search for and choose S3 to open the S3 console.
You will see the message “You don't have permissions to list buckets” because User2 does not have permission to access Amazon S3.
At the top of the screen, choose User-2
Choose Sign Out
11. You will now sign-in as User3, who has been hired as your Amazon EC2    administrator.
Sign-in with:
IAM user name: User3
Password: User3@123
 12. In the search box to the right of Services, search for and choose EC2 to open the EC2 console.
In the navigation pane on the left, choose Instances.
As an EC2 Administrator, you should now have permissions to Stop the Amazon EC2 instance.
13. Select the instance named “MyServer”
In the Instance state menu, choose Stop instance.
In the Stop instance window, choose Stop.
The instance will enter the stopping state and will shutdown.

{
	"blocks": [
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":xero-boost: Boost Days for the last week of Jan :xero-boost:"
			}
		},
		{
			"type": "divider"
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-29: Wednesday, 29th January",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": "\n:coffee: *Café Partnership*: Enjoy coffee and café-style beverages from our cafe partner, *Adoro*, *8:00AM - 11:30AM*.\n:lunch: *Lunch*: Provided by *Mitzi and Twinn* *12:30PM - 1:30PM* in the Kitchen."
			}
		},
		{
			"type": "header",
			"text": {
				"type": "plain_text",
				"text": ":calendar-date-30: Thursday, 30th January",
				"emoji": true
			}
		},
		{
			"type": "section",
			"text": {
				"type": "mrkdwn",
				"text": ":coffee: *Café Partnership*: Enjoy coffee and café-style beverages from our cafe partner, *Adoro*, *8:00AM - 11:30AM*. \n:lunch: *Breakfast*: Provided by *Roam* *9:30AM - 10:30AM* in the Kitchen. \n:celebrate_: *Social Happy Hour*: Kick off 2025 with our first social happy hour 🎉 join us from *4PM to 5:30PM*. We can't wait to see you there (more details to come)."
			}
		},
		{
			"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?cid=eGVyby5jb21fbXRhc2ZucThjaTl1b3BpY284dXN0OWlhdDRAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ|*Hawkes Bay Social Calendar*>, and get ready to Boost your workdays!\n\nWX Team :party-wx:"
			}
		}
	]
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class TestController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index()
    {
        //
    }
    /**
     * Show the form for creating a new resource.
     */
    public function create()
    {
        //
    }
    /**
     * Store a newly created resource in storage.
     */
    public function store(Request $request)
    {
        //
    }
    /**
     * Display the specified resource.
     */
    public function show(string $id)
    {
        //
    }
    /**
     * Show the form for editing the specified resource.
     */
    public function edit(string $id)
    {
        //
    }
    /**
     * Update the specified resource in storage.
     */
    public function update(Request $request, string $id)
    {
        //
    }
    /**
     * Remove the specified resource from storage.
     */
    public function destroy(string $id)
    {
        //
    }
}

$objectManager =  \Magento\Framework\App\ObjectManager::getInstance();        
 
$paymentHelper = $objectManager->get('Magento\Payment\Helper\Data');
$allPaymentMethods = $paymentHelper->getPaymentMethods();
$allPaymentMethodsArray = $paymentHelper->getPaymentMethodList();
 
var_dump($allPaymentMethodsArray);
var_dump($allPaymentMethods);
 
$paymentConfig = $objectManager->get('Magento\Payment\Model\Config');
$activePaymentMethods = $paymentConfig->getActiveMethods();
 
var_dump(array_keys($activePaymentMethods));
 
$orderPaymentCollection = $objectManager->get('\Magento\Sales\Model\ResourceModel\Order\Payment\Collection');
$orderPaymentCollection->getSelect()->group('method');
$paymentMethods[] = array('value' => '', 'label' => 'Any');
foreach ($orderPaymentCollection as $col) { 
    $paymentMethods[] = array('value' => $col->getMethod(), 'label' => $col->getAdditionalInformation()['method_title']);            
}        

class Main {
    public static void main(String[] args) {
        int arr[] = {1,2,3,4,5,6,7,7};
        int n = arr.length;//length of the array is n
        int largest = arr[n - 1];// the largest is always the last in sorted array 
        int second_largest = 0;// initaialze a variable for 2nd 

        for (int i = n - 2; i >= 0; i--) {
            if (arr[i] != largest) {
                second_largest = arr[i];
                break;
            }
        }

        System.out.println("the second largest element:-"+second_largest);
    }
}
        
//required logic in case of array size < 2 
//        if(arr.length<2){// u can use n variable (n<2)
//            System.out.println(" no element in array");
//            return ;
//        }


//for loop:-
// iteration from the first or second last element , as we are searching for second largest no need to search for n-1 , but we can start from n-1 also , no problem 


//This is a brute force approach 
//TC=O(nlogn) due to sorting taking more time
//SC=O(n)

1. Selecciona un Editor WYSIWYG
Algunos editores populares que puedes integrar manualmente son:
TinyMCE: Sitio oficial
CKEditor: Sitio oficial
Quill: Sitio oficial
Para este ejemplo, usaremos TinyMCE, pero el proceso es similar para otros editores.
2. Descarga la Librería
Puedes descargar los archivos del editor desde su sitio oficial o usar un CDN.
TinyMCE (CDN):
Agrega el siguiente script en tu vista:

<script src="https://cdn.tiny.cloud/1/no-api-key/tinymce/6/tinymce.min.js" referrerpolicy="origin"></script>

3. Crea el Campo de Texto
En tu vista, define un campo de texto normal (por ejemplo, un textarea) donde se aplicará el editor.

<?= $form->field($model, 'asunto')->textarea(['id' => 'editor', 'rows' => 6]) ?>

4. Inicializa el Editor
Agrega un bloque de JavaScript para inicializar el editor en el campo de texto. Esto lo puedes hacer directamente en la vista o en un archivo JS separado.
Ejemplo con TinyMCE:

<?php
$this->registerJs(<<<JS
    tinymce.init({
        selector: '#editor', // Selecciona el textarea por su ID
        language: 'es', // Idioma del editor
        plugins: 'advlist autolink lists link image charmap print preview anchor searchreplace visualblocks code fullscreen insertdatetime media table paste help wordcount',
        toolbar: 'undo redo | formatselect | bold italic backcolor | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | removeformat | help',
        menubar: false, // Opcional: Oculta la barra de menús
        height: 300, // Altura del editor
    });
JS);
?>

  uarda los Datos en el Modelo
El contenido del editor se enviará como parte del formulario al servidor, ya que TinyMCE reemplaza el contenido del textarea. No necesitas hacer nada especial para procesar los datos en Yii2; simplemente accede al atributo del modelo como lo harías normalmente:

if ($model->load(Yii::$app->request->post()) && $model->save()) {
    // Procesa y guarda los datos del modelo
}

6. Opcional: Personalización Avanzada
Puedes personalizar aún más el editor añadiendo opciones específicas según tus necesidades:
Subida de Imágenes:
Configura una URL para manejar la subida de imágenes.
Barra de Herramientas Personalizada:
Ajusta qué botones aparecen en la barra de herramientas.
Estilos CSS:
Aplica estilos personalizados al contenido usando content_css.
Ejemplo con Subida de Imágenes:

tinymce.init({
    selector: '#editor',
    plugins: 'image code advlist autolink lists link image charmap print preview anchor searchreplace visualblocks code fullscreen insertdatetime media table paste help wordcount',
    toolbar: 'undo redo | formatselect | bold italic backcolor | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | removeformat | help| link image | code',
    images_upload_url: '/path/to/upload-handler', // Ruta a tu controlador para subir imágenes
  	 menubar: false, // Opcional: Oculta la barra de menús
     height: 300, // Altura del editor
});

Conclusión
Integrar un editor WYSIWYG manualmente te da flexibilidad y control total sobre su configuración. Aunque requiere algo más de trabajo que usar un widget preconfigurado, es una opción ideal si prefieres evitar dependencias externas o necesitas personalización avanzada.
Si tienes dudas específicas sobre cómo implementar algo (como subir imágenes o configurar estilos), no dudes en preguntar. ¡Estoy aquí para ayudarte! 😊

class Solution {
    public List<Integer> majorityElement(int[] nums) {
        List<Integer> ar = new ArrayList<>();
        int cnt1 = 0;
        int cnt2 = 0;
        int ele1 = Integer.MIN_VALUE;
        int ele2 = Integer.MIN_VALUE;
        for (int i = 0; i < nums.length; i++) {
            if (cnt1 == 0 && nums[i] != ele2) {
                ele1 = nums[i];
                cnt1++;
            } else if (cnt2 == 0 && nums[i] != ele1) {
                ele2 = nums[i];
                cnt2++;
            } else if (ele1 == nums[i]) {
                cnt1++;
            } else if (ele2 == nums[i]) {
                cnt2++;
            } else {
                cnt1--;
                cnt2--;
            }
        }
        cnt1=0;
        cnt2=0;
        for(int x:nums){
            if(ele1==x)
                cnt1++;
            else if(ele2==x){
                     cnt2++;
            }
        }
        if(cnt1>(nums.length/3))
            ar.add(ele1);
        if(cnt2>(nums.length/3))
            ar.add(ele2);
        return ar;
    }
}

Secure Page
ASP.NET (.aspx) File
<%@ Page Language="C#" AutoEventWireup="true" Inherits="master_files_delivery_route" CodeFile="delivery_route.aspx.cs" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Delivery Route</title>
    <script type="text/javascript">
        function ProcessKeyDown(e) {
            if (e == 13) { gv_delivery_route.UpdateEdit(); }
            if (e == 27) { gv_delivery_route.CancelEdit(); }
        }

        var command = '';
        var cperror_msgnum;
        function Begin_CallBack(s, e) {
            command = e.command;
        }
        function End_CallBack(s, e) {
            if ((command == 'UPDATEEDIT' || command == 'DELETEROW') && s.cperror_add_info != 'error') {
                msg_popup.SetContentUrl("../common/error_message.aspx?message_num=" + s.cperror_msg_num + "&additional_info=" + s.cperror_add_info);
                msg_popup.Show();
            }
        }

        function End_CallBack_Grid(s, e) {
            if (s.cperror_msg_num != "-1") {
                msg_popup.SetContentUrl("../common/error_message.aspx?message_num=" + s.cperror_msg_num + "&additional_info=" + s.cperror_add_info);
                msg_popup.Show();
                s.cperror_msg_num = '-1';
            }
        }

        function DeliveryZone_Init(s, e) {
            s.GetMainElement().onclick = function () {
                var delivery_zone = s.GetText();
                s.PerformCallback();
                s.SetText(delivery_zone);
            };
        }

        function DeliveryZone_EndCallBack(s, e) {
            s.ShowDropDown();
        }

        function DeliveryZone_GotFocus(s, e) {
            var item_zone = s.GetSelectedItem();
            if (item_zone) {
                s.SetText(item_zone.GetColumnText('delivery_zone'));
            }
        }

        function DeliveryZone_SelectedChanged(s, e) {
            var item_zone = s.GetSelectedItem();
            if (item_zone) s.SetText(item_zone.GetColumnText('delivery_zone'));
            gv_delivery_route_d.GetEditor('description').SetValue(item_zone.GetColumnText('description'));
            gv_delivery_route_d.GetEditor('zone_group').SetValue(item_zone.GetColumnText('zone_group'));
            gv_delivery_route_d.GetEditor('zone_sub_group').SetValue(item_zone.GetColumnText('zone_sub_group'));
            gv_delivery_route_d.PerformCallback();
        }
    </script>
</head>
<body>
    <form id="form1" runat="server">
        <div style="display: inline-block; width: 100%; margin: -8;">
            <div style="padding-bottom: 3px;">
                <dx:ASPxButton runat="server" ID="btn_new_row" Text="Add New" Theme="Aqua" AutoPostBack="false" Width="88px" UseSubmitBehavior="false">
                    <ClientSideEvents Click="function(s, e) {
                                       gv_delivery_route.AddNewRow();   }" />
                </dx:ASPxButton>
            </div>
            <dx:ASPxGridView ID="gv_delivery_route" runat="server" AutoGenerateColumns="False" DataSourceID="sql_delivery_route" KeyFieldName="delivery_route" Theme="Aqua" OnInit="gv_delivery_route_Init"
                OnRowValidating="gv_delivery_route_RowValidating" EnableCallBacks="true" ClientInstanceName="gv_delivery_route" OnCellEditorInitialize="gv_delivery_route_CellEditorInitialize"
                Settings-ShowFilterBar="Auto" Settings-ShowFilterRow="true">
                <Columns>
                    <dx:GridViewCommandColumn VisibleIndex="0" ButtonType="Image" Width="60px">
                        <EditButton Text="Edit" Visible="true" Image-Url="../images/img_edit.png">
                            <Image Url="../images/img_edit.png"></Image>
                        </EditButton>
                        <UpdateButton Text="Edit" Visible="true" Image-Url="../images/img_edit.png">
                            <Image Url="../images/Apply.png"></Image>
                        </UpdateButton>
                        <CancelButton Text="Edit" Visible="true" Image-Url="../images/img_edit.png">
                            <Image Url="../images/Cancel.png"></Image>
                        </CancelButton>
                    </dx:GridViewCommandColumn>
                    <dx:GridViewDataTextColumn FieldName="delivery_route" ReadOnly="true" VisibleIndex="1" Caption="Delivery Route" PropertiesTextEdit-Style-BackColor="#C2E2ED">
                        <PropertiesTextEdit>
                            <ClientSideEvents KeyDown="function(s, e) {ProcessKeyDown(e.htmlEvent.keyCode); }" />
                        </PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="description" VisibleIndex="2" Caption="Description">
                        <PropertiesTextEdit>
                            <ClientSideEvents KeyDown="function(s, e) {ProcessKeyDown(e.htmlEvent.keyCode); }" />
                        </PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="created_by" ReadOnly="true" Visible="true" VisibleIndex="3" Caption="Create By">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataDateColumn FieldName="created_date" VisibleIndex="4" Caption="Create Date" ReadOnly="true" PropertiesDateEdit-DropDownButton-Enabled="false" PropertiesDateEdit-DisplayFormatInEditMode="true">
                        <PropertiesDateEdit></PropertiesDateEdit>
                    </dx:GridViewDataDateColumn>
                    <dx:GridViewDataTextColumn FieldName="updated_by" ReadOnly="true" VisibleIndex="5" Caption="Update By">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataDateColumn FieldName="updated_date" VisibleIndex="6" Caption="Updated Date" PropertiesDateEdit-DropDownButton-Enabled="false" ReadOnly="true" PropertiesDateEdit-DisplayFormatInEditMode="true">
                        <PropertiesDateEdit></PropertiesDateEdit>
                    </dx:GridViewDataDateColumn>
                    <dx:GridViewCommandColumn VisibleIndex="7" ButtonType="Image" Width="30px">
                        <DeleteButton Visible="true" Text="Delete" Image-Url="../images/img_delete.png">
                            <Image Url="../images/img_delete.png"></Image>
                        </DeleteButton>
                    </dx:GridViewCommandColumn>
                </Columns>
                <SettingsBehavior AllowSelectByRowClick="True" ConfirmDelete="True" AllowFocusedRow="true" />
                <SettingsEditing Mode="Inline" />
                <SettingsText ConfirmDelete="Are you sure you want to delete?" />
                <ClientSideEvents FocusedRowChanged="function(s, e) {               
                                                        if (typeof(gv_delivery_route_d) != 'undefined')
                                                        {                                                       
                                                            gv_delivery_route_d.PerformCallback(s.GetFocusedRowIndex());                                                                                                
                                                        }
                                                    }"
                    EndCallback="End_CallBack" BeginCallback="Begin_CallBack" />
                <Styles>
                    <CommandColumn Spacing="3px" Wrap="False" />
                </Styles>
            </dx:ASPxGridView>
            <div style="padding-top: 10px"></div>

            <div style="padding-bottom: 3px;">
                <dx:ASPxButton runat="server" ID="btn_add_delivery_route_d" Text="Add New" Theme="Aqua" AutoPostBack="false" Width="88px" UseSubmitBehavior="false">
                    <ClientSideEvents Click="function(s, e) {
                                       gv_delivery_route_d.AddNewRow();   }" />
                </dx:ASPxButton>
            </div>
            <dx:ASPxGridView ID="gv_delivery_route_d" runat="server" AutoGenerateColumns="False"
                OnCellEditorInitialize="gv_delivery_route_d_CellEditorInitialize"
                OnRowValidating="gv_delivery_route_d_RowValidating"
                OnInit="gv_delivery_route_d_Init"
                ClientInstanceName="gv_delivery_route_d"
                DataSourceID="sql_delivery_route_d"
                KeyFieldName="i_delivery_route;i_delivery_zone"
                OnCustomCallback="gv_delivery_route_d_CustomCallback"
                OnCommandButtonInitialize="gv_delivery_route_d_CommandButtonInitialize"
                Settings-ShowFilterBar="Auto"
                Settings-ShowFilterRow="true"
                Theme="Aqua" Width="100%">
                <Columns>
                    <dx:GridViewCommandColumn VisibleIndex="0" ButtonType="Image">
                        <EditButton Text="Edit" Visible="true" Image-Url="../images/img_edit.png">
                            <Image Url="../images/img_edit.png"></Image>
                        </EditButton>
                        <UpdateButton Text="Edit" Visible="true" Image-Url="../images/img_edit.png">
                            <Image Url="../images/Apply.png"></Image>
                        </UpdateButton>
                        <CancelButton Text="Edit" Visible="true" Image-Url="../images/img_edit.png">
                            <Image Url="../images/Cancel.png"></Image>
                        </CancelButton>
                    </dx:GridViewCommandColumn>
                    <dx:GridViewCommandColumn VisibleIndex="1" ButtonType="Image">
                        <CustomButtons>
                            <dx:GridViewCommandColumnCustomButton ID="cmdUp">
                                <Image Url="../images/Up.ico"></Image>
                            </dx:GridViewCommandColumnCustomButton>
                        </CustomButtons>
                        <CustomButtons>
                            <dx:GridViewCommandColumnCustomButton ID="cmdDown">
                                <Image Url="../images/Down.ico"></Image>
                            </dx:GridViewCommandColumnCustomButton>
                        </CustomButtons>                        
                    </dx:GridViewCommandColumn>
                    <dx:GridViewDataTextColumn FieldName="i_delivery_route" VisibleIndex="2" Width="150px" Visible="false">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataComboBoxColumn FieldName="i_delivery_zone" VisibleIndex="3" ReadOnly="true">
                        <PropertiesComboBox ValueField="delivery_zone" TextField="delivery_zone" TextFormatString="{0}"
                            DisplayFormatString="{0}" CallbackPageSize="30" EnableCallbackMode="true" DropDownStyle="DropDown"
                            OnItemsRequestedByFilterCondition="cbo_delivery_zone_ItemsRequestedByFilterCondition" IncrementalFilteringMode="Contains"
                            OnItemRequestedByValue="cbo_delivery_zone_ItemRequestedByValue">
                            <Columns>
                                <dx:ListBoxColumn Caption="Delivery Zone" FieldName="delivery_zone" Name="delivery_zone" />
                                <dx:ListBoxColumn Caption="Description" FieldName="description" Name="description" />
                                <dx:ListBoxColumn FieldName="zone_group" Name="zone_group" Caption="Zone Group" />
                                <dx:ListBoxColumn FieldName="zone_sub_group" Name="zone_sub_group" Caption="Zone Sub Group" />
                            </Columns>
                            <ClientSideEvents GotFocus="DeliveryZone_GotFocus"
                                Init="DeliveryZone_Init" ValueChanged="DeliveryZone_GotFocus" EndCallback="DeliveryZone_EndCallback" />
                        </PropertiesComboBox>
                    </dx:GridViewDataComboBoxColumn>
                    <dx:GridViewDataTextColumn FieldName="description" VisibleIndex="4" Width="150px" ReadOnly="true">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="zone_group" VisibleIndex="5" ReadOnly="true" Caption="Zone Group">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="zone_sub_group" VisibleIndex="6" ReadOnly="true" Caption="Zone Sub Group">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="load_seq" VisibleIndex="7" ReadOnly="true">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataTextColumn FieldName="created_by" ReadOnly="true" Visible="true" VisibleIndex="8" PropertiesTextEdit-Style-BackColor="LightGray">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataDateColumn FieldName="created_date" VisibleIndex="9" ReadOnly="true" PropertiesDateEdit-DropDownButton-Enabled="false" PropertiesDateEdit-DisplayFormatInEditMode="true">
                        <PropertiesDateEdit></PropertiesDateEdit>
                    </dx:GridViewDataDateColumn>
                    <dx:GridViewDataTextColumn FieldName="updated_by" ReadOnly="true" VisibleIndex="10" PropertiesTextEdit-Style-BackColor="LightGray">
                        <PropertiesTextEdit></PropertiesTextEdit>
                    </dx:GridViewDataTextColumn>
                    <dx:GridViewDataDateColumn FieldName="updated_date" VisibleIndex="11" PropertiesDateEdit-DropDownButton-Enabled="false" ReadOnly="true" PropertiesDateEdit-DisplayFormatInEditMode="true">
                        <PropertiesDateEdit></PropertiesDateEdit>
                    </dx:GridViewDataDateColumn>
                    <dx:GridViewCommandColumn VisibleIndex="12" ButtonType="Image">                        
                        <DeleteButton Visible="true" Text="Delete" Image-Url="../images/img_delete.png">
                            <Image Url="../images/img_delete.png"></Image>
                        </DeleteButton>
                    </dx:GridViewCommandColumn>
                </Columns>
                <ClientSideEvents EndCallback="End_CallBack_Grid" BeginCallback="Begin_CallBack" />
                <SettingsBehavior AllowSelectByRowClick="True" ConfirmDelete="True" />
                <SettingsEditing Mode="Inline" />
                <SettingsText ConfirmDelete="Are you sure you want to delete?" />
                <Styles>
                    <CommandColumn Spacing="3px" Wrap="False" />
                </Styles>
            </dx:ASPxGridView>

            <asp:SqlDataSource ID="sql_delivery_route_d" runat="server" ConnectionString="<%$ ConnectionStrings:mainConnection %>"
                SelectCommand="select_delivery_route_d" SelectCommandType="StoredProcedure"
                DeleteCommand="delete_delivery_route_d" DeleteCommandType="StoredProcedure"
                InsertCommand="save_delivery_route_d" InsertCommandType="StoredProcedure"
                UpdateCommand="save_delivery_route_d" UpdateCommandType="StoredProcedure"
                OnDeleted="sql_delivery_route_d_deleted" OnInserted="sql_delivery_route_d_inserted" OnUpdated="sql_delivery_route_d_updated"
                OnDeleting="sql_delivery_route_d_tran" OnUpdating="sql_delivery_route_d_tran" OnInserting="sql_delivery_route_d_tran" 
                OnSelecting="sql_delivery_route_d_Selecting">
                <SelectParameters>
                    <asp:Parameter Name="i_delivery_route" Type="String" />
                </SelectParameters>
                <DeleteParameters>
                    <asp:Parameter Name="i_delivery_route" Type="String" />
                    <asp:Parameter Name="i_delivery_zone" Type="String" />
                    <asp:Parameter Name="o_succeed" Type="Boolean" Direction="InputOutput" />
                    <asp:Parameter Name="o_msg_num" Type="Int32" Direction="InputOutput" Size="10" />
                    <asp:Parameter Name="o_add_info" Type="String" Direction="InputOutput" DefaultValue="" Size="3000" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="i_delivery_route" Type="String" />
                    <asp:Parameter Name="i_delivery_zone" Type="String" />
                    <asp:SessionParameter Name="i_user" SessionField="username" Type="String" />
                    <asp:Parameter Name="o_succeed" Type="Boolean" Direction="InputOutput" DefaultValue="false" />
                    <asp:Parameter Name="o_msg_num" Type="Int32" Direction="InputOutput" Size="10" />
                    <asp:Parameter Name="o_add_info" Type="String" Direction="InputOutput" DefaultValue="" Size="3000" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="i_delivery_route" Type="String" />
                    <asp:Parameter Name="i_delivery_zone" Type="String" />
                    <asp:SessionParameter Name="i_user" SessionField="username" Type="String" />
                    <asp:Parameter Name="o_succeed" Type="Boolean" Direction="InputOutput" DefaultValue="false" />
                    <asp:Parameter Name="o_msg_num" Type="Int32" Direction="InputOutput" Size="10" />
                    <asp:Parameter Name="o_add_info" Type="String" Direction="InputOutput" DefaultValue="" Size="3000" />
                </UpdateParameters>
            </asp:SqlDataSource>

            <asp:SqlDataSource ID="sql_delivery_route" runat="server"
                ConnectionString="<%$ ConnectionStrings:mainConnection %>"
                SelectCommand="select_delivery_route" SelectCommandType="StoredProcedure" DeleteCommand="delete_delivery_route"
                DeleteCommandType="StoredProcedure" InsertCommand="save_delivery_route" InsertCommandType="StoredProcedure"
                UpdateCommand="save_delivery_route" UpdateCommandType="StoredProcedure"
                OnDeleted="sql_delivery_route_popup" OnInserted="sql_delivery_route_popup" OnUpdated="sql_delivery_route_popup"
                OnUpdating="sql_delivery_route_tran" OnDeleting="sql_delivery_route_tran" OnInserting="sql_delivery_route_tran">

                <DeleteParameters>
                    <asp:Parameter Name="delivery_route" Type="String" />
                    <asp:Parameter Direction="InputOutput" Name="success" Type="Boolean" />
                    <asp:Parameter Name="o_msg_num" Type="Int32" Direction="InputOutput" Size="10" />
                    <asp:Parameter Name="o_add_info" Type="String" Direction="InputOutput" DefaultValue="" Size="3000" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="delivery_route" Type="String" />
                    <asp:Parameter Name="description" Type="String" />
                    <asp:SessionParameter Name="i_updated_by" SessionField="username" Type="String" />
                    <asp:SessionParameter Name="i_created_by" SessionField="username" Type="String" />
                    <asp:Parameter Name="success" Type="Boolean" Direction="InputOutput" DefaultValue="false" />
                    <asp:Parameter Name="o_msg_num" Type="Int32" Direction="InputOutput" Size="10" />
                    <asp:Parameter Name="o_add_info" Type="String" Direction="InputOutput" DefaultValue="" Size="3000" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="delivery_route" Type="String" />
                    <asp:Parameter Name="description" Type="String" />
                    <asp:SessionParameter Name="i_updated_by" SessionField="username" Type="String" />
                    <asp:SessionParameter Name="i_created_by" SessionField="username" Type="String" />
                    <asp:Parameter Name="success" Type="Boolean" Direction="InputOutput" DefaultValue="false" />
                    <asp:Parameter Name="o_msg_num" Type="Int32" Direction="InputOutput" Size="10" />
                    <asp:Parameter Name="o_add_info" Type="String" Direction="InputOutput" DefaultValue="" Size="3000" />
                </UpdateParameters>
            </asp:SqlDataSource>

            <asp:SqlDataSource ID="Sql_filter" runat="server" ConnectionString="<%$ ConnectionStrings:mainConnection%>"></asp:SqlDataSource>

            <dx:ASPxPopupControl ID="ASPxPopupControl2" runat="server"
                ClientInstanceName="msg_popup" ShowLoadingPanel="true" Theme="Aqua" ShowMaximizeButton="true" ContentUrl="javascript:void(0);"
                Width="400px" CloseAction="CloseButton" PopupHorizontalAlign="WindowCenter" PopupVerticalAlign="Above" MaxHeight="200px">
                <ContentCollection>
                    <dx:PopupControlContentControl ID="PopupControlContentControl1" runat="server">
                    </dx:PopupControlContentControl>
                </ContentCollection>

                <ClientSideEvents CloseUp="function(s,e){msg_popup.Hide();}" />
            </dx:ASPxPopupControl>
        </div>
    </form>
</body>
</html>
        
 Save
C# (.cs) File
using DevExpress.Web.ASPxGridView;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using DevExpress.Web.ASPxEditors;

public partial class master_files_delivery_route : System.Web.UI.Page
{
    string asn_no, str_success, msg_num, g_messge, add_info;
    public SystemInfo sys;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Label_setting();
            FormatDate();
        }
        gv_delivery_route_d.JSProperties["cperror_msg_num"] = -1; //nilai default - tidak ada kesalahan /error
    }
    protected void gv_delivery_route_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
    {
        if (e.NewValues["delivery_route"] == null)
        {
            AddError(e.Errors, gv_delivery_route.Columns["delivery_route"], "Delivery route is required.");
            gv_delivery_route.JSProperties["cperror_add_info"] = "error";
        }
        if (e.NewValues["description"] == null)
        {
            AddError(e.Errors, gv_delivery_route.Columns["description"], "Description is required.");
            gv_delivery_route.JSProperties["cperror_add_info"] = "error";
        }
    }
    private void FormatDate()
    {
        string dateformat = Session["date_format_desc"].ToString();

        //gv_delivery_route
        GridViewDataDateColumn col_created = gv_delivery_route.Columns["created_date"] as GridViewDataDateColumn;
        if (col_created != null)
        {
            col_created.PropertiesDateEdit.DisplayFormatString = dateformat;
        }
        GridViewDataDateColumn col_updated = gv_delivery_route.Columns["updated_date"] as GridViewDataDateColumn;
        if (col_updated != null)
        {
            col_updated.PropertiesDateEdit.DisplayFormatString = dateformat;
        }

        //gv_delivery_route_d
        GridViewDataDateColumn col_created1 = gv_delivery_route.Columns["created_date"] as GridViewDataDateColumn;
        if (col_created1 != null)
        {
            col_created1.PropertiesDateEdit.DisplayFormatString = dateformat;
        }
        GridViewDataDateColumn col_updated1 = gv_delivery_route.Columns["updated_date"] as GridViewDataDateColumn;
        if (col_updated1 != null)
        {
            col_updated1.PropertiesDateEdit.DisplayFormatString = dateformat;
        }
    }
    void AddError(Dictionary errors, GridViewColumn column, string errorText)
    {
        if (errors.ContainsKey(column)) return;
        errors[column] = errorText;
    }
    private void Label_setting()
    {
        DataSet ds = new DataSet();
        String sysMsg;
        DataTable dtLabelNum = new DataTable();
        dtLabelNum.Columns.Add("lblNum", typeof(int));
        DataTable dtLabelTabCol = new DataTable();
        //details
        dtLabelTabCol.Columns.Add("table_column", typeof(string));
        dtLabelTabCol.Rows.Add("delivery_route_d.delivery_route");
        dtLabelTabCol.Rows.Add("delivery_route_d.delivery_zone");
        dtLabelTabCol.Rows.Add("delivery_route_d.description");
        dtLabelTabCol.Rows.Add("delivery_route_d.load_seq");
        dtLabelTabCol.Rows.Add("delivery_route_d.updated_by");
        dtLabelTabCol.Rows.Add("delivery_route_d.updated_date");
        dtLabelTabCol.Rows.Add("delivery_route_d.created_by");
        dtLabelTabCol.Rows.Add("delivery_route_d.created_date");
        dtLabelTabCol.Rows.Add("delivery_zone.zone_group");
        dtLabelTabCol.Rows.Add("delivery_zone.zone_sub_group");

        //header       
        dtLabelTabCol.Rows.Add("delivery_route.updated_by");
        dtLabelTabCol.Rows.Add("delivery_route.updated_date");
        dtLabelTabCol.Rows.Add("delivery_route.created_by");
        dtLabelTabCol.Rows.Add("delivery_route.created_date");
        dtLabelTabCol.Rows.Add("delivery_route.description");
        dtLabelTabCol.Rows.Add("delivery_route.delivery_route");
        dtLabelNum.Rows.Add(6077);

        string owner_code = Session["default_owner_code"].ToString();
        string whs_code = Session["default_whs_code"].ToString();

        try
        {
            sys = new SystemInfo();
            ds = sys.Select_GetLabelByNum(dtLabelNum, dtLabelTabCol, owner_code, whs_code);
            gv_delivery_route_d.Columns["i_delivery_zone"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.delivery_zone", ds);
            gv_delivery_route_d.Columns["load_seq"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.load_seq", ds);
            gv_delivery_route_d.Columns["description"].Caption = SystemInfo.GetLabelByTabCol("delivery_route.description", ds);
            gv_delivery_route_d.Columns["zone_group"].Caption = SystemInfo.GetLabelByTabCol("delivery_zone.zone_group", ds);
            gv_delivery_route_d.Columns["zone_sub_group"].Caption = SystemInfo.GetLabelByTabCol("delivery_zone.zone_sub_group", ds);
            gv_delivery_route_d.Columns["updated_by"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.updated_by", ds);
            gv_delivery_route_d.Columns["updated_date"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.updated_date", ds);
            gv_delivery_route_d.Columns["created_by"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.created_by", ds);
            gv_delivery_route_d.Columns["created_date"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.created_date", ds);

            gv_delivery_route.Columns["delivery_route"].Caption = SystemInfo.GetLabelByTabCol("delivery_route.delivery_route", ds);
            gv_delivery_route.Columns["description"].Caption = SystemInfo.GetLabelByTabCol("delivery_route.description", ds);
            gv_delivery_route.Columns["created_by"].Caption = SystemInfo.GetLabelByTabCol("delivery_route.created_by", ds);
            gv_delivery_route.Columns["created_date"].Caption = SystemInfo.GetLabelByTabCol("delivery_route.created_date", ds);
            gv_delivery_route.Columns["updated_by"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.updated_by", ds);
            gv_delivery_route.Columns["updated_date"].Caption = SystemInfo.GetLabelByTabCol("delivery_route_d.updated_date", ds);

            //mandatory delivery route
            if (SystemInfo.GetMandatoryByTabCol("delivery_route.delivery_route", ds)) ((GridViewDataTextColumn)gv_delivery_route.Columns["delivery_route"]).PropertiesEdit.Style.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFEF97");
            if (SystemInfo.GetMandatoryByTabCol("delivery_route.description", ds)) ((GridViewDataTextColumn)gv_delivery_route.Columns["description"]).PropertiesEdit.Style.BackColor = System.Drawing.ColorTranslator.FromHtml("#FFEF97");


            DataTable dt = new DataTable();
            dt = sys.Select_Getdate_Format(Session["date_format"].ToString());
            ((GridViewDataDateColumn)gv_delivery_route_d.Columns["created_date"]).PropertiesDateEdit.DisplayFormatString = dt.Rows[0]["description2"].ToString() + " " + dt.Rows[0]["time_format"].ToString();
            ((GridViewDataDateColumn)gv_delivery_route_d.Columns["updated_date"]).PropertiesDateEdit.DisplayFormatString = dt.Rows[0]["description2"].ToString() + " " + dt.Rows[0]["time_format"].ToString();

            //add new button
            btn_add_delivery_route_d.Text = btn_new_row.Text = SystemInfo.GetLabelByNum(6077, ds);

            int page_row_size = 0;

            page_row_size = sys.GetRowPerPage(Session["default_owner_code"].ToString(), Session["default_whs_code"].ToString());
            gv_delivery_route.SettingsPager.PageSize = page_row_size;
            gv_delivery_route_d.SettingsPager.PageSize = page_row_size;

        }
        catch (Exception ex)
        {
            sysMsg = ex.ToString();
            Response.Write(sysMsg);
        }
    }
    protected void sql_delivery_route_popup(object sender, SqlDataSourceStatusEventArgs e)
    {
        Boolean success;
        Int32 msgNum;
        string addinfo;
        
        // Pastikan koneksi database terbuka
        if (e.Command.Connection.State.Equals("Closed")) e.Command.Connection.Open();
        if (e.Command.Transaction == null) e.Command.Transaction = e.Command.Connection.BeginTransaction();
        try
        {
            success = Convert.ToBoolean(e.Command.Parameters["@success"].Value);
            msgNum = Convert.ToInt32(e.Command.Parameters["@o_msg_num"].Value);
            addinfo = Convert.ToString(e.Command.Parameters["@o_add_info"].Value);
            if (success)
            {
              //coomit jika sukses
                e.Command.Transaction.Commit();


            // Mengirimkan informasi sukses ke client-side menggunakan JSProperties
                gv_delivery_route.JSProperties["cperror_msg_num"] = msgNum;
                gv_delivery_route.JSProperties["cperror_add_info"] = addinfo;

            }
            else
            {
              // Jika operasi gagal, rollback transaksi
                if (e.Command.Transaction != null)
                {
                    e.Command.Transaction.Rollback();
                }
                    // Mengirimkan informasi kesalahan ke client-side menggunakan JSProperties
                gv_delivery_route.JSProperties["cperror_msg_num"] = msgNum;
                gv_delivery_route.JSProperties["cperror_add_info"] = addinfo;

            }
        }
        catch (Exception ex)
        {
            //// Jika terjadi error, batalkan transaksi dan lemparkan exception
            if (e.Command.Transaction != null)
                e.Command.Transaction.Dispose();
            throw (ex);
        }
        finally
        {
            // Pastikan transaksi dibersihkan setelah selesai
            if (e.Command.Transaction != null)
                e.Command.Transaction.Dispose();
        }

    }
 
   
    protected void gv_delivery_route_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
    {
      // Mengecek apakah sedang mengedit baris baru
        if (gv_delivery_route.IsNewRowEditing)
        {
  
           // Mengecek apakah kolom yang diedit adalah kolom "delivery_route"
            if (e.Column.FieldName == "delivery_route")
              // Membuat editor kolom "delivery_route" menjadi bisa diedit
                e.Editor.ReadOnly = false;
            else
                return; // Jika kolom yang diedit bukan "delivery_route", tidak ada tindakan lebih lanjut
        }
        else
            return;
    }
    protected void gv_delivery_route_Init(object sender, EventArgs e)
    {
      //Mendapatkan pesan konfirmasi penghapusan berdasarkan ID pesan (262) dan bahasa yang dipilih oleh pengguna
        string label = SystemInfo.errorMsg(262, (string)Session["language"]);
        ASPxGridView grid_ln = (ASPxGridView)sender;
        grid_ln.SettingsText.ConfirmDelete = label;
    }
    protected void sql_delivery_route_tran(object sender, SqlDataSourceCommandEventArgs e)
    {
      //open koneksi
        e.Command.Connection.Open();
        // Memulai transaksi pada koneksi yang terbuka
        e.Command.Transaction = e.Command.Connection.BeginTransaction();
    }
    protected void gv_delivery_route_d_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
    {
        gv_delivery_route_d.DataBind();
    }

    // Event handler untuk validasi baris baru
    protected void gv_delivery_route_d_RowValidating(object sender, DevExpress.Web.Data.ASPxDataValidationEventArgs e)
    {
        if (e.NewValues["i_delivery_zone"] == null)
        {
            AddError(e.Errors, gv_delivery_route.Columns["i_delivery_zone"], "Delivery Zone is required.");
            gv_delivery_route.JSProperties["cperror_add_info"] = "error";
        }
    }
    protected void gv_delivery_route_d_Init(object sender, EventArgs e)
    {
        string label = SystemInfo.errorMsg(262, (string)Session["language"]);
        ASPxGridView grid_ln = (ASPxGridView)sender;
        grid_ln.SettingsText.ConfirmDelete = label;
    }
    protected void gv_delivery_route_d_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
    {
        if (gv_delivery_route_d.IsNewRowEditing)
        {
            if (e.Column.FieldName == "i_delivery_zone")
                e.Editor.ReadOnly = false;
            else
                return;
        }
        else
            return;

        if (e.Column.FieldName == "i_delivery_zone")
        {
            ASPxComboBox combo = e.Editor as ASPxComboBox;
            combo.ClientSideEvents.SelectedIndexChanged = "DeliveryZone_SelectedChanged";
        }
    }
    protected void sql_delivery_route_d_deleted(object sender, SqlDataSourceStatusEventArgs e)
    {
        DbCommand command = e.Command;
        DbTransaction tx = command.Transaction;

        try
        {
            str_success = e.Command.Parameters["@o_succeed"].Value.ToString();
            msg_num = e.Command.Parameters["@o_msg_num"].Value.ToString();
            add_info = e.Command.Parameters["@o_add_info"].Value.ToString();
            if ((bool)e.Command.Parameters["@o_succeed"].Value)
            {
                tx.Commit();
                Show_Error_Detail("173", "~/images/ok-icon.png", "");
            }
            else
            {
                tx.Rollback();
                Show_Error_Detail(msg_num, "~/images/error_button.png", "Add Info [ " + add_info + " ]");
            }

        }
        catch (Exception ex)
        {
            if (e.Command.Transaction != null)
            {
                e.Command.Transaction.Dispose();
                e.Command.Connection.Close();
            }
            throw (ex);
        }
        finally
        {
            if (e.Command.Transaction != null)
            {
                e.Command.Transaction.Dispose();
                e.Command.Connection.Close();
            }
        }
    }
    protected void sql_delivery_route_d_inserted(object sender, SqlDataSourceStatusEventArgs e)
    {
        DbCommand command = e.Command;
        DbTransaction tx = command.Transaction;

        try
        {
            str_success = e.Command.Parameters["@o_succeed"].Value.ToString();
            msg_num = e.Command.Parameters["@o_msg_num"].Value.ToString();
            add_info = e.Command.Parameters["@o_add_info"].Value.ToString();
            if ((bool)e.Command.Parameters["@o_succeed"].Value)
            {
                tx.Commit();
                Show_Error_Detail("170", "~/images/ok-icon.png", "");
            }
            else
            {
                tx.Rollback();
                Show_Error_Detail(msg_num, "~/images/error_button.png", "Add Info [ " + add_info + " ]");
            }

        }
        catch (Exception ex)
        {
            if (e.Command.Transaction != null)
            {
                e.Command.Transaction.Dispose();
                e.Command.Connection.Close();
            }
            throw (ex);
        }
        finally
        {
            if (e.Command.Transaction != null)
            {
                e.Command.Transaction.Dispose();
                e.Command.Connection.Close();
            }
        }
    }
    protected void sql_delivery_route_d_updated(object sender, SqlDataSourceStatusEventArgs e)
    {
        DbCommand command = e.Command;
        DbTransaction tx = command.Transaction;

        try
        {
            str_success = e.Command.Parameters["@o_succeed"].Value.ToString();
            msg_num = e.Command.Parameters["@o_msg_num"].Value.ToString();
            add_info = e.Command.Parameters["@o_add_info"].Value.ToString();
            if ((bool)e.Command.Parameters["@o_succeed"].Value)
            {
                tx.Commit();
                Show_Error_Detail("171", "~/images/ok-icon.png", "");
            }
            else
            {
                tx.Rollback();
                Show_Error_Detail(msg_num, "~/images/error_button.png", "Add Info [ " + add_info + " ]");
            }

        }
        catch (Exception ex)
        {
            if (e.Command.Transaction != null)
            {
                e.Command.Transaction.Dispose();
                e.Command.Connection.Close();
            }
            throw (ex);
        }
        finally
        {
            if (e.Command.Transaction != null)
            {
                e.Command.Transaction.Dispose();
                e.Command.Connection.Close();
            }
        }
    }
    protected void sql_delivery_route_d_tran(object sender, SqlDataSourceCommandEventArgs e)
    {
        e.Command.Parameters["@i_delivery_route"].Value = gv_delivery_route.GetRowValues(gv_delivery_route.FocusedRowIndex, "delivery_route").ToString();
        DbCommand command = e.Command;
        DbConnection cx = command.Connection;
        cx.Open();
        DbTransaction tx = cx.BeginTransaction();
        command.Transaction = tx;
    }
    public void Show_Error(string msgnum, string Url, string AddInfo)
    {
        gv_delivery_route.JSProperties["cperror_msg_num"] = msgnum;
        gv_delivery_route.JSProperties["cperror_add_info"] = AddInfo;
        gv_delivery_route.JSProperties["cperror_image_url"] = Url;
    }
    public void Show_Error_Detail(string msgnum, string Url, string AddInfo)
    {
        gv_delivery_route_d.JSProperties["cperror_msg_num"] = msgnum;
        gv_delivery_route_d.JSProperties["cperror_add_info"] = AddInfo;
        gv_delivery_route_d.JSProperties["cperror_image_url"] = Url;
    }
    protected void sql_delivery_route_d_Selecting(object sender, SqlDataSourceSelectingEventArgs e)
    {
        object values = gv_delivery_route.GetRowValues(gv_delivery_route.FocusedRowIndex, new string[] { "delivery_route" });
        string focusrow = (values == null) ? null : values.ToString();
        e.Command.Parameters["@i_delivery_route"].Value = focusrow;
    }
    protected void cbo_delivery_zone_ItemsRequestedByFilterCondition(object source, ListEditItemsRequestedByFilterConditionEventArgs e)
    {
        ASPxComboBox comboBox_zone = (ASPxComboBox)source; 
       //// Memeriksa apakah permintaan berasal dari callback dan jika halaman sedang melakukan postback
        if (comboBox_zone.IsCallback && Page.IsPostBack)
        {
            comboBox_zone.Items.Clear(); //hapus yang ada sebelum input baru
            Sql_filter.SelectParameters.Clear();
            Sql_filter.SelectCommand = "wm_select_delivery_zone";
            Sql_filter.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
            Sql_filter.SelectParameters.Add("zone", TypeCode.String, string.Format("%{0}%", e.Filter));
            Sql_filter.SelectParameters.Add("startIndex", TypeCode.Int64, (e.BeginIndex + 1).ToString());
            Sql_filter.SelectParameters.Add("endIndex", TypeCode.Int64, (e.EndIndex + 9).ToString());
            //DataView dv = (DataView)Sql_filter.Select(DataSourceSelectArguments.Empty);
            comboBox_zone.DataSource = Sql_filter;
            comboBox_zone.DataBind();
        }
    }
    protected void cbo_delivery_zone_ItemRequestedByValue(object source, ListEditItemRequestedByValueEventArgs e)
    {

    }
    protected void gv_delivery_route_d_CommandButtonInitialize(object sender, ASPxGridViewCommandButtonEventArgs e)
    {
        if (e.ButtonType == DevExpress.Web.ASPxGridView.ColumnCommandButtonType.Edit)
            e.Visible = false;
    }
}
        

class Solution {
    public int subarraySum(int[] nums, int k) {
        HashMap<Long,Integer> hm=new HashMap<>();
        long sum=0;
        int cnt=0;
        hm.put(sum,1);
        for(int i=0;i<nums.length;i++){
            sum+=nums[i];
            if(hm.containsKey(sum-k)){
                cnt+=hm.get(sum-k);

            }
            if(hm.containsKey(sum)){
                hm.put(sum,hm.get(sum)+1);
            }
            else{
            hm.put(sum,1);
            }
        }
        
        return cnt;
        
    }
    
}

def duplibit(arr):
    seen =set()
    dup = set()
    for num in arr:
        if num in seen:
            dup.add(num)
        else:
            seen.add(num)
    return list(dup)


array = [1,2,3,4,1,2,4,8,9]
print(duplibit(array))

def duplibit(arr):
    freq = {}
    dup = []
    for num in arr:
        freq[num] = freq.get(num ,0)+1
    for key,value in freq.items():
        if value >1:
            dup.append(key)
    return dup
        

array = [1,2,3,4,1,2,4,8,9]
print(duplibit(array))

def dupbit(arr):
    bitmap =0
    dup =[]
    for num in arr:
        bit= 1<<(num-1)
        if bit & bitmap:
            dup.append(num)
        else:
            bitmap |=bit
            
    return dup
    
    
    
array = [1,2,3,4,5,2,4,5,2,4,8]
print(dupbit(array))

'''
def reverse(s):
    s= list(s)
    l , r=0, len(s)-1
    while l<r:
        s[l],s[r] = s[r], s[l]
        l=l+1
        r=r-1
    return "".join(s)
   '''
'''  
def reverse(s):
    return s[::-1]
'''
'''
def reverse(s):
    result =''
    for char in s:
        result = char + result
    return result
'''
'''
def reverse(s):
    return ''.join(reversed(s))
'''

input_string="Narendra"
print(reverse(input_string))

import java.util.Arrays; // Import required for Arrays utility class

class Main {
    public static void main(String[] args) {
        int arr[] = {1, 3, 2, 6, 5, 4}; // Correct array initialization
        Arrays.sort(arr); // Correct usage of Arrays.sort
       System.out.println(Arrays.toString(arr)); // prints the  sorted array
       int n = arr.length;
       System.out.println(arr[n-1]);

       
    }
}
//Tc-O(nlogn)
//lergest element in an array ( sorting and return n-1) (brute force method)