//Using the new ES6 Syntax

    console.log(["a", "b", "c", "d", "e", "f", "g"].filter(el => !["b", "c", "g"].includes(el)));

    // OR

    // Main array
    let myArray = ["a", "b", "c", "d", "e", "f", "g"];

    // Array to remove
    const toRemove = ["b", "c", "g"];

    const diff = () => (myArray = myArray.filter((el) => !toRemove.includes(el)));
  console.log(diff()); // [ 'a', 'd', 'e', 'f' ]

    // OR

    const diff2 = () => {
      return myArray = myArray.filter((el) => !toRemove.includes(el));
    };
    console.log(diff2()); // [ 'a', 'd', 'e', 'f' ]

gpupdate /force

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT 
      [LN]
      ,[HN]
      ,[FULLNAME]
     , [YEAR]

  
      ,[SEX]
      ,[BIRTHDATE]
    
      ,[WARD NAME]
      ,[PATIENT TYPE NAME]
      ,[DOCTOR NAME]
  
      ,[AN]
      ,[VN]
     ,[ORDER DATETIME]
       ,[IREQ_LAST_CHK_DT] as 'Checkin datetime'

      ,[RES ITEM NAME]
      ,[RES ITEM RESULT]

      ,[RES ITEM REPORT DATETIME]
      ,[RES ITEM REPORT STAFF NAME]
      ,[RES ITEM APPROVE DATETIME]
      ,[RES ITEM APPROVE STAFF NAME] 

--      ,[IREQ_LAST_APP_DT]
  FROM [LAB_DB].[dbo].[view_lab_statistic_Result_List]
  where [RES ITEM STATE] = 'A' and  HN in (SELECT  distinct HN
  FROM [LAB_DB].[dbo].[view_lab_statistic_Result_List]
  where [RES ITEM CODE] in ('IM1429','IM1430','IM1433','IM1448') and ([IREQ_LAST_CHK_DT] Between '@dt1' and '@dt2')) and [RES ITEM CODE] in ('IM1429','IM1430','IM1433','IM1448')
  

#include <Servo.h>

int motor1pin1 = 2;
int motor1pin2 = 3;
 
int motor2pin1 = 4;
int motor2pin2 = 5;

#define echoPin 6 // attach pin D6 Arduino to pin Echo of HC-SR04
#define trigPin 7 //attach pin D7 Arduino to pin Trig of HC-SR04

Servo myservo;

void setup() {

  pinMode(motor1pin1,OUTPUT);
  pinMode(motor1pin2,OUTPUT);
  pinMode(motor2pin1,OUTPUT);
  pinMode(motor2pin2,OUTPUT);

  pinMode(trigPin, OUTPUT); // Sets the trigPin as an OUTPUT
  pinMode(echoPin, INPUT); // Sets the echoPin as an INPUT
  Serial.begin(9600); // // Serial Communication is starting with 9600 of baudrate speed

  long duration; // variable for the duration of sound wave travel
  int distanceFront; // variable for the distance measurement
  int distanceLeft; // variable for the distance measurement
  int distanceRight; // variable for the distance measurement

  myservo.attach(9);

}

void loop() {
  goForward();
  checkDistanceFront();

  if (distance < 5) {
    stopMoving();

  }
}

void goForward() {
  digitalWrite(motor1pin1,HIGH);
  digitalWrite(motor1pin2,LOW);
 
  digitalWrite(motor2pin1,HIGH);
  digitalWrite(motor2pin2,LOW);  
  delay(1000);
}

void checkDistanceFront() {
    // Clears the trigPin condition
  digitalWrite(trigPin, LOW);
  delayMicroseconds(2);
  // Sets the trigPin HIGH (ACTIVE) for 10 microseconds
  digitalWrite(trigPin, HIGH);
  delayMicroseconds(10);
  digitalWrite(trigPin, LOW);
  // Reads the echoPin, returns the sound wave travel time in microseconds
  duration = pulseIn(echoPin, HIGH);
  // Calculating the distance
  distanceFront = duration * 0.034 / 2; // Speed of sound wave divided by 2 (go and back)
  // Displays the distance on the Serial Monitor
  Serial.print("Duration: ");
  Serial.print(duration);
  Serial.println(" ms");
}

void lookLeft() {

  myservo.write(0);

  digitalWrite(trigPin, LOW);
  delayMicroseconds(2);
  // Sets the trigPin HIGH (ACTIVE) for 10 microseconds
  digitalWrite(trigPin, HIGH);
  delayMicroseconds(10);
  digitalWrite(trigPin, LOW);
  // Reads the echoPin, returns the sound wave travel time in microseconds
  duration = pulseIn(echoPin, HIGH);
  // Calculating the distance
  distanceLeft = duration * 0.034 / 2; // Speed of sound wave divided by 2 (go and back)
  // Displays the distance on the Serial Monitor
  Serial.print("Duration: ");
  Serial.print(duration);
  Serial.println(" ms");

}

void lookRight() {

  myservo.write(170);

  digitalWrite(trigPin, LOW);
  delayMicroseconds(2);
  // Sets the trigPin HIGH (ACTIVE) for 10 microseconds
  digitalWrite(trigPin, HIGH);
  delayMicroseconds(10);
  digitalWrite(trigPin, LOW);
  // Reads the echoPin, returns the sound wave travel time in microseconds
  duration = pulseIn(echoPin, HIGH);
  // Calculating the distance
  distanceRight = duration * 0.034 / 2; // Speed of sound wave divided by 2 (go and back)
  // Displays the distance on the Serial Monitor
  Serial.print("Duration: ");
  Serial.print(duration);
  Serial.println(" ms");

}

class Solution {
public:
    typedef long long ll;
    
    int maxLevelSum(TreeNode* root) {
        vector<int> levels(1e5, 0);
        queue<pair<int,TreeNode*>> q;
        if(!root)
            return 0;
        q.push({0, root});
        int lvls_reached = 0;
        while(!q.empty()){
            auto node(q.front().second);auto lvl(q.front().first);
            q.pop();
            levels[lvl] += node->val;
            lvls_reached = max(lvls_reached, lvl);
            if(node->left)
                q.push({lvl + 1, node->left});
            if(node->right)
                q.push({lvl + 1, node->right});
        }
        ll maxi = LLONG_MIN;
        int ans = -1;
        for(int i = 0; i <=lvls_reached; i++)
            if(levels[i] > maxi)
                ans = i, maxi = levels[i];
        return ans + 1;
    }
};

class Solution {
  public:
    string longestPalin (string S) {
        // code here
        if(S.length() == 0)
            return "";
        string ans;
        pair<int,int> r{0,0};
        int len = 1, n = S.length();
        for(int i = 0 ; i < n; i++){
            int j = i, k =i;
            while(j-1 >= 0 && k+1 < n){
                if(!(S[j-1] == S[k+1]))
                    break;
                j--,k++;
            }
            int l1 = k - j + 1;
            pair<int,int> p1{j,k},p2{i,i};
            int l2 = 1;
            if( i +1 < n){
                bool f = (S[i] == S[i+1]);
                if(f){
                    j = i, k = i+1;
                    while( j-1 >=0 && k+1 < n){
                        if(!(S[j-1] == S[k+1]))
                            break;
                        j--,k++;
                    }
                    l2 = k - j + 1;
                    p2 = {j,k};
                }
            }
            if(len < max(l1,l2)){
                len = max(l1,l2);
                r = (l1 > l2)?p1:p2;
            }
        }
        for(int i = r.first; i<=r.second;i++)
            ans += S[i];
        return ans;
    }
};

--------------------------------------------------------------------------------------
# docker-compose.yaml
--------------------------------------------------------------------------------------
version: '3.6'

services:
  db:
    image: mariadb:latest
    restart: unless-stopped
    environment:
      MYSQL_ROOT_PASSWORD: root
      MYSQL_DATABASE: wpdb
      MYSQL_USER: wpdbuser
      MYSQL_PASSWORD: wppasswd
      VIRTUAL_HOST: example.com, www.example.com
    volumes:
      - ./data_db:/var/lib/mysql
    networks:
      - wpsite

  phpmyadmin:
    image: phpmyadmin/phpmyadmin
    depends_on:
      - db
    restart: unless-stopped
    ports:
      - 18000:80
    environment:
      PMA_HOST: db
      MYSQL_ROOT_PASSWORD: root
    networks:
      - wpsite

  wordpress:
    image: wordpress:latest
    depends_on:
      - db
    restart: unless-stopped
    ports:
      - 18001:80
    environment:
      WORDPRESS_DB_HOST: db:3306
      WORDPRESS_DB_NAME: wpdb
      WORDPRESS_DB_USER: wpdbuser
      WORDPRESS_DB_PASSWORD: wppasswd
    volumes:
      - ./YOUR_WORDPRESS_FOLDER:/var/www/html
    networks:
      - wpsite

   nginx: 
    build: 
      context: ./nginx
    ports: 
      - 80:80
    networks: 
      - nextjs-app

networks:
  wpsite:


#---------------------------------------------------------------------------
#./nginx/Dockerfile
#---------------------------------------------------------------------------
FROM nginx

# Remove any existing config files
RUN rm /etc/nginx/conf.d/\*

# Copy config files
COPY ./default.conf /etc/nginx/conf.d/

# If you want basic auth create a .htpasswd 
# COPY ./.htpasswd ./etc/nginx/.htpasswd

# Expose the listening port
EXPOSE 80

# Launch NGINX
CMD [ "nginx", "-g", "daemon off;" ]

#-------------------------------------------------------------------------
#./nginx/default.conf
#-------------------------------------------------------------------------

upstream nextjs {
  server wordpress:18001;
}

server {
    listen 80;
    server_name _;
    server_tokens off;

    gzip on;
    gzip_proxied any;
    gzip_comp_level 4;
    gzip_types text/css application/javascript image/svg+xml;

    
    
    location / {
    	proxy_pass: http://wordpress;
        proxy_http_version 1.1;
        proxy_set_header Upgrade $http_upgrade;
        proxy_set_header Connection 'upgrade';
        proxy_set_header Host $host;
        proxy_cache_bypass $http_upgrade;
        #auth_basic "Restricted Content";
    	#auth_basic_user_file /etc/nginx/.htpasswd;
    }
    
}

with base as 
(select
      distinct lead.id as buy_lead_id,
      date(lead.created_on+interval'330'minute) as created_on
      lead.city,
      lead.app_label,
      lead.source,
      lead.sub_source,
      lead.platform_source,
      b.utmsource,
      b.utmmedium,
      cstd1.cstd,
      uar1.UAR,
      hist.historic,
      otp.OTP_Verified,
      otp.OTP_time,
      case
        when v.buy_lead_id is not null then 1
        else 0
      end as v,
      case
        when cp.buy_lead_id is not null then 1
        else 0
      end as sold
    from
      (SELECT * FROM 
        (SELECT
     case 
when display_name like'%%Delhi%%'then'Delhi NCR'
when display_name like'%%Bangalore%%'then'Bangalore'
when display_name like'%%Hyderabad%%'then'Hyderabad'
when display_name like'%%Gurgaon%%'then'Delhi NCR'
when display_name like'%%Pune%%'then'Pune'
when display_name like'%%Mumbai%%'then'Mumbai'
when display_name like'%%Delhi/Delhi NCR%%'then'Delhi NCR'
when display_name like'%%Ahmedabad%%'then'Ahmedabad'
when display_name like'%%Noida%%'then'Delhi NCR'
when display_name like'%%Chennai%%'then'Chennai'
when display_name like'%%Lucknow%%'then'Lucknow'
when display_name like'%%Kolkata%%'then'Kolkata'
when display_name like'%%Ghaziabad%%'then'Delhi NCR'
when display_name like'%%Faridabad%%'then'Delhi NCR'
when display_name like'%%Jaipur%%'then'Jaipur'
when display_name like'%%Indore%%'then'Indore'
when display_name like'%%Mysore%%'then'Bangalore'
when display_name like'%%Coimbatore%%'then'Coimbatore'
when display_name like'%%Chandigarh%%'then'Chandigarh'
when display_name like'%%Rewari%%'then'Delhi NCR'
when display_name like'%%Ambala%%'then'Chandigarh'
when display_name like'%%Hubli%%'then'Bangalore'
when display_name like'%%Panipat%%'then'Delhi NCR'
when display_name like'%%Greater Noida%%'then'Delhi NCR'
when display_name like'%%Rohtak%%'then'Delhi NCR'
when display_name like'%%Meerut%%'then'Delhi NCR'
when display_name like'%%Karnal%%'then'Delhi NCR'
when display_name like'%%Sonipat%%'then'Delhi NCR'
when display_name like'%%Kanpur%%'then'Lucknow'
when display_name like'%%Mangalore%%'then'Bangalore'
when display_name like'%%Surat%%'then'Ahmedabad'
when display_name like'%%Aligarh%%'then'Delhi NCR'
when display_name like'%%Belgaum%%'then'Bangalore'
when display_name like'%%Hassan%%'then'Bangalore'
when display_name like'%%Jammu%%'then'Delhi NCR'
when display_name like'%%Jhajjar%%'then'Delhi NCR'
when display_name like'%%Agra%%'then'Delhi NCR'
when display_name like'%%Bhiwadi%%'then'Jaipur'
when display_name like'%%Kolar%%'then'Bangalore'
when display_name like'%%Gulbarga%%'then'Bangalore'
when display_name like'%%Warangal%%'then'Hyderabad'
when display_name like'%%Raichur%%'then'Bangalore'
when display_name like'%%Alwar%%'then'Delhi NCR'
when display_name like'%%Nashik%%'then'Pune'
when display_name like'%%Bahadurgarh%%'then'Delhi NCR'
when display_name like'%%Mathura%%'then'Delhi NCR'
when display_name like'%%Sirsa%%'then'Chandigarh'
when display_name like'%%Thane%%'then'Mumbai'
when display_name like'%%Nagpur%%'then'Pune'
when display_name like'%%Moradabad%%'then'Lucknow'
when display_name like'%%Karimnagar%%'then'Hyderabad'
when display_name like'%%Amritsar%%'then'Chandigarh'
when display_name like'%%Patna%%'then'Lucknow'
when display_name like'%%Bagalkot%%'then'Bangalore'
when display_name like'%%Kochi%%'then'Kochi'
when display_name like'%%Jhansi%%'then'Lucknow'
when display_name like'%%Nizamabad%%'then'Hyderabad'
when display_name like'%%Bareilly%%'then'Lucknow'
when display_name like'%%Saharanpur%%'then'Lucknow'
when display_name like'%%Navi Mumbai%%' then'Mumbai'
when display_name like'%%Navi Mumbai%%' then 'Mumbai'
when display_name like'%%Gurgaon%%' then 'NCR'
when display_name like'%%Greater Noida%%' then 'NCR'
when display_name like'%%Noida%%' then 'NCR'
when display_name like'%%Jodhpur%%'then'Jaipur'
when display_name like'%%Gwalior%%'then'Indore'
when display_name like'%%Hapur%%'then'Delhi NCR'
when display_name like'%%Bhopal%%'then'Indore'
when display_name like'%%Dehradun%%'then'Delhi NCR'
when display_name like'%%Kurukshetra%%'then'Chandigarh'
when display_name like'%%Ahmednagar%%'then'Pune'
when display_name like'%%Mandya%%'then'Bangalore'
when display_name like'%%Aurangabad%%'then'Pune'
when display_name like'%%Jalandhar%%'then'Chandigarh'
when display_name like'%%Gorakhpur%%'then'Lucknow'
when display_name like'%%Khammam%%'then'Hyderabad'
when display_name like'%%Muzaffarnagar%%'then'Delhi NCR'
when display_name like'%%Rajkot%%'then'Ahmedabad'
when display_name like'%%Varanasi%%'then'Lucknow'
when display_name like'%%Hosur%%'then'Coimbatore'
when display_name like'%%Allahabad%%'then'Lucknow'
when display_name like'%%Bathinda%%'then'Chandigarh'
when display_name like'%%Solapur%%'then'Pune'
when display_name like '%%Vadodara%%' then 'Ahmedabad'
when display_name like '%%tumkur%%' then 'Bangalore'
when display_name like '%%tumakuru%%' then 'Bangalore'
when display_name like '%%shimoga%%' then 'Bangalore'
when display_name like '%%Shivamogga%%' then 'Bangalore'
when display_name like '%%Navi Mumbai%%' then 'Mumbai'
when display_name like '%%Navsari%%' then 'Ahmedabad'
when display_name like '%%Pune%%' then 'Pune'
when display_name like '%%sangli%%' then 'Pune'
when display_name like '%%Bhavnagar%%' then 'Ahmedabad'
when display_name like '%%Palwal%%' then 'Delhi NCR'
when display_name like '%%salem%%' then 'Coimbatore'
when display_name like '%%Tiruchirappalli%%' then 'Coimbatore'
when display_name like '%%Trichy%%' then 'Coimbatore'
when display_name like '%%Tiruppur%%' then 'Coimbatore'
when display_name like '%%Madurai%%' then 'Coimbatore'
when display_name like '%%Nanded%%' then 'Pune'
when display_name like '%%Surendranagar%%' then 'Ahmedabad'
when display_name like '%%Surendranagar%%' then 'Ahmedabad'
when display_name like '%%Mirzapur%%' then 'Lucknow'
when display_name like '%%Chittoor%%' then 'Hyderabad'
when display_name like '%%Chittoor%%' then 'Hyderabad'
when display_name like '%%Guntur%%' then 'Hyderabad'
when display_name like '%%Mehsana%%' then 'Ahmedabad'
when display_name like '%%Amreli%%' then 'Ahmedabad'
when display_name like '%%Vellore%%' then 'Coimbatore'
when display_name like '%%Erode%%' then 'Coimbatore'
when display_name like '%%Nalgonda%%' then 'Hyderabad'
when display_name like '%%Akola%%' then 'Pune'
when display_name like '%%Bhandara%%' then 'Pune'
when display_name like '%%Ooty%%' then 'Coimbatore'
when display_name like '%%Rampur%%' then 'Delhi NCR'
when display_name like '%%Anand%%' then 'Ahmedabad'
when display_name like '%%Muzaffarpur%%' then 'Lucknow'
when display_name like '%%Kurnool%%' then 'Hyderabad'
when display_name like '%%Yavatmal%%' then 'Mumbai'
when display_name like '%%Tiruvannamalai%%' then 'Coimbatore'
when display_name like '%%Tiruvannamalai%%' then 'Coimbatore'
when display_name like '%%Latur%%' then 'Pune'
when display_name like '%%Udaipur%%' then 'Jaipur'
when display_name like '%%Srikakulam%%' then 'Hyderabad' 
when display_name like '%%Kadapa%%' then 'Hyderabad'
when display_name like '%%Patial%%' then 'Chandigarh'
when display_name like '%%Amravati%%' then 'Pune'
when display_name like '%%Satna%%' then 'Indore'
when display_name like '%%Porbandar%%' then 'Ahmedabad'
when display_name like '%%Satara%%' then 'Pune'
when display_name like '%%Sambalpur%%' then 'Kolkata'
when display_name like '%%Prakasam%%' then 'Hyderabad'
when display_name like '%%Srikakulam%%' then 'Hyderabad'
when display_name like '%%Jamnagar%%' then 'Ahmedabad'
when display_name like '%%Tirupati%%' then 'Hyderabad'
when display_name like '%%Kheda%%' then 'Ahmedabad'
when display_name like '%%Vijayawada%%' then 'Hyderabad'
when display_name like '%%Cuddalore%%' then 'Coimbatore'
when display_name like '%%Kannauj%%' then 'Lucknow'
when display_name like '%%Unnao%%' then 'Lucknow'
when display_name like '%%Kannur%%' then 'Kochi'
when display_name like '%%Bharatpur%%' then 'Jaipur'
when display_name like '%%Birbhum%%' then 'Kolkata'
when display_name like '%%Gandhinagar%%' then 'Ahmedabad'
when display_name like '%%Osmanabad%%' then 'Pune'
when display_name like '%%Virudhunagar%%' then 'Coimbatore'
when display_name like '%%Faizabad%%' then 'Lucknow'
when display_name like '%%Chamarajanagar%%' then 'Bangalore'
when display_name like '%%Kota%%' then 'Jaipur'
when display_name like '%%Thanjavur%%' then 'Coimbatore'
when display_name like '%%Siliguri%%' then 'Kolkata'
when display_name like '%%Rajahmundry%%' then 'Hyderabad'
when display_name like '%%bhubaneswar%%' then 'Kolkata'
when display_name like '%%bhilwara%%' then 'Jaipur'
when display_name like '%%Hathras%%' then 'Lucknow'
when display_name like '%%Mansa%%' then 'Chandigarh'
when display_name like '%%Shahjahanpur%%' then 'Lucknow'
when display_name like '%%barmer%%' then 'Jaipur'
when display_name like '%%baghpat%%' then 'Delhi NCR'
when display_name like '%%Junagadh%%' then 'Ahmedabad'
when display_name like '%%Bilaspur%%' then 'Indore'
when display_name like '%%Raipur%%' then 'Indore'
when display_name like '%%Bhagalpur%%' then 'Kolkata'
when display_name like '%%Barabanki%%' then 'Lucknow'
when display_name like '%%Asansol%%' then 'Kolkata'
when display_name like '%%Nellore%%' then 'Hyderabad'
when display_name like '%%Banaskantha%%' then 'Ahmedabad'
when display_name like '%%gadag%%' then 'Bangalore'
when display_name like '%%Hoshiarpur%%' then 'Chandigarh'
when display_name like '%%firozabad%%' then 'Delhi NCR'
when display_name like '%%Haridwar%%' then 'Delhi NCR'
when display_name like '%%Kanchipuram%%' then 'Coimbatore'
when display_name like '%%Ranchi%%' then 'Kolkata'
when display_name like '%%Tinsukia%%' then 'Delhi NCR'
when display_name like '%%Ratnagiri%%' then 'Pune'
when display_name like '%%Bankura%%' then 'Kolkata'
when display_name like '%%Rudrapur%%' then 'Delhi NCR'
when display_name like '%%Dewas%%' then 'Indore'
when display_name like '%%Vapi%%' then 'Ahmedabad'
when display_name like '%%Bardhaman%%' then 'Kolkata'
when display_name like '%%Anantapur%%' then 'Hyderabad'
when display_name like '%%Bharuch%%' then 'Ahmedabad'
when display_name like '%%Rewa%%' then 'Indore'
when display_name like '%%Kharagpur%%' then 'Kolkata'
when display_name like '%%Sambhal%%' then 'Delhi NCR'
when display_name like '%%Namakkal%%' then 'Coimbatore'
when display_name like '%%Sikar%%'then 'Jaipur'
when display_name like '%%Chhindwara%%' then 'Indore'
when display_name like '%%Rajgarh%%' then 'Jaipur'
when display_name like '%%Zirakpur%%' then 'Chandigarh'
when display_name like '%%Ujjain%%' then 'Indore'
when display_name like '%%Bikaner%%' then 'Jaipur'
when display_name like '%%Ludhiana%%' then 'Chandigarh'
when display_name like '%%Durgapur%%' then 'Kolkata'
when display_name like '%%Palakkad%%' then 'Kochi'
when display_name like '%%Shimla%%' then 'Chandigarh'
when display_name like '%%Chandrapur%%' then 'Pune'
when display_name like '%%Jaisalmer%%' then 'Jaipur'
when display_name like '%%Nagaur%%' then 'Jaipur'
when display_name like '%%Patan%%' then 'Ahmedabad'
when display_name like '%%Pondicherry%%' then 'Coimbatore'
when display_name like '%%Dindigul%%' then 'Coimbatore'
when display_name like '%%Tirunelveli%%' then 'Coimbatore'
when display_name like '%%Jabalpur%%' then 'Indore'
when display_name like '%%Daman%%' then 'Mumbai'
when display_name like '%%Mahendragarh%%' then 'Delhi NCR'
when display_name like '%%Tonk%%' then 'Jaipur'
when display_name like '%%Mohali%%' then 'Chandigarh'
when display_name like '%%Darjeeling%%' then 'Kolkata'
when display_name like '%%Dhanbad%%' then 'Kolkata'
when display_name like '%%Nabarangpur%%' then 'Kolkata'
when display_name like '%%Pali%%' then 'Jaipur'
when display_name like '%%Rupnagar%%' then 'Chandigarh'
when display_name like '%%Sindhudurg%%' then 'Pune'
when display_name like '%%Jalore%%' then 'Jaipur'
when display_name like '%%Karwar%%' then 'Bangalore'
when display_name like '%%Theni%%' then 'Coimbatore'
when display_name like '%%Krishna%%' then 'Hyderabad'
when display_name like '%%Ajmer%%' then 'Jaipur'
when display_name like '%%Medak%%' then 'Hyderabad'
when display_name like '%%Udupi%%' then 'Bangalore'
when display_name like '%%Villupuram%%' then 'Coimbatore'
when display_name like '%%Vizianagaram%%' then 'Hyderabad'
when display_name like '%%Daman%%' then 'Ahmedabad'
when display_name like '%%Almora%%' then 'Delhi NCR'
when display_name like '%%Kottayam%%' then 'Kochi'
when display_name like '%%Valsad%%' then 'Ahmedabad'
when display_name like '%%West Godavari%%' then 'Hyderabad'
when display_name like '%%Godavari%%' then 'Hyderabad'
when display_name like '%%Daman%%' then 'Mumbai'
when display_name like '%%Churu%%' then 'Jaipur'
when display_name like '%%Dharuhera%%' then 'Delhi NCR'
when display_name like '%%Guwahati%%' then 'Delhi NCR'
when display_name like '%%Sabarkantha%%' then 'Ahmedabad'
when display_name like '%%Raebareli%%' then 'Delhi NCR'
when display_name like '%%Karur%%' then 'Coimbatore'
when display_name like '%%Kaithal%%' then 'Delhi NCR'
when display_name like '%%Cuttack%%' then 'Kolkata'
when display_name like '%%Jamshedpur%%' then 'Kolkata'
when display_name like '%%Kanyakumari%%' then 'Coimbatore'
when display_name like '%%Kanyakumari%%' then 'Coimbatore'
when display_name like '%%Malappuram%%' then 'Kochi'
when display_name like '%%Nainital%%' then 'Delhi NCR'
when display_name like '%%Alappuzha%%' then 'Kochi'
when display_name like '%%Cuttack%%' then 'Kolkata'
when display_name like '%%Jamshedpur%%' then 'Kolkata'
when display_name like '%%Kanyakumari%%' then 'Coimbatore'
when display_name like '%%Malappuram%%' then 'Kochi'
when display_name like '%%Nainital%%' then 'Delhi NCR'
when display_name like '%%Malappuram%%' then 'Kochi'
when display_name like '%%Darbhanga%%' then 'Lucknow'
            else 'Others'  end as city,
          dct.app_label,
          CASE WHEN dct.model IN ('externalbuyrequest','facebookleadform','scheduledphonecall') THEN 'External' ELSE dct.model END AS Source,
          CASE WHEN dct.model='buyrequest' AND bl.sub_source IN ('schedule_test_drive','truebil_test_drive') THEN 'BR_sub'
          WHEN dct.model ='buyrequest' AND bl.sub_source IS NULL THEN 'BR_sub'
          WHEN dct.model ='lead' AND bl.sub_source ='Intent_30' THEN '1'
          WHEN dct.model ='lead' AND bl.sub_source IN ('Intent_20','Intent_25') THEN '2'
          WHEN dct.model ='lead' AND bl.sub_source IN ('Intent_10','Unknown') THEN '3'
          WHEN dct.model='lead' AND bl.sub_source IS NULL THEN '3'
          WHEN bl.sub_source IN ('gmb','facebook','instagram','car_interest','category_changed','twitter','kapture-facebook') THEN 'social_media'
          ELSE bl.sub_source END AS Sub_source,
          bl.platform_source,
          bl.id
        FROM
          sp_web_external.sp_web_buy_lead_buylead AS bl
          LEFT JOIN sp_web_external.sp_web_django_content_type as dct ON dct.id = bl.source_object_type_id
          LEFT JOIN sp_web_external.sp_web_address_city as city ON city.id = bl.city_id
        where date(bl.created_on+interval'330'minute) between date '2023-01-01' and date '2023-05-31'
        --   AND bl.category = 'assured'
          )b
          INNER JOIN (select DISTINCT context_id, created_on, rn from(SELECT
          w.created_time,
          w.context_id,
          bl.created_on,
          bl.id,
          row_number() over(partition by w.context_id order by w.created_time DESC) as rn
        FROM
          sp_web_external.sp_web_workflow_usertask w
          LEFT JOIN sp_web_external.sp_web_buy_lead_buylead bl ON bl.id =w.context_id
          LEFT JOIN sp_web_external.sp_web_django_content_type as dct ON dct.id = bl.source_object_type_id
          LEFT JOIN sp_web_external.sp_web_address_city as city ON city.id = bl.city_id
          where date(bl.created_on+interval'330'minute) between date '2023-01-01' and date '2023-05-31'
        --   AND bl.category ='assured'
          )a
          where rn =1)bb ON b.id = bb.context_id) lead
          LEFT JOIN (SELECT 
 distinct id,

  Case
  when (Platform2 IN ('android','ios') AND (media_source IS NULL AND partner IS NULL)) Then 'Organic'
    when (Platform2 IN ('android','ios') AND (media_source IS NOT NULL AND partner IS NOT NULL)) Then 'Paid'
    when (Platform2 IN ('android','ios') AND (media_source IS NOT NULL AND partner IS NULL)) Then 'Paid'
    when (Platform2 IN ('android','ios') AND (media_source IS NULL AND partner IS NOT NULL)) Then 'Paid'
    when utm_medium = 'fbad' Then 'Facebook'
    when utm_medium = 'FBboost' Then 'Facebook'
    when utm_medium = 'affiliate' Then 'Affiliate'
    when utm_source in ('Taboola', 'adgebra', 'outbrain') Then 'Native'
    when utm_medium = 'partnerships' Then 'Partnerships'
    when utm_medium in (
      'gads_t_search',
      'gads_c_search',
      'gads_m_search',
      'bingads_c_search',
      'bingads_m_search',
      'bingads_t_search'
    )
    and utm_source like '%Brand%' Then 'SEM Brand'
    when utm_medium in (
      'gads_t_search',
      'gads_c_search',
      'gads_m_search',
      'bingads_c_search',
      'bingads_m_search',
      'bingads_t_search'
    )
    and utm_source not like '%Brand%' Then 'SEM Non Brand'
    when utm_medium like '%whatsapp%'
    or utm_medium like '%sms%'
    or utm_medium like '%push%'
    or utm_medium like '%whatsapp=utm_campaign=supply-lead-created_abn1nkm%'
    or utm_medium like '%webpush%'
    or utm_medium like '%WhatsappGetDetailsTD%'
    or utm_medium like '%whatsapp_promotional%'
    or utm_medium like '%email%'
    or utm_source like '%whatsapp_share%' Then 'CRM'
    when utm_medium = 'gads_t_video' Then 'Youtube'
    when utm_medium = 'gads_c_video' Then 'Youtube'
    when utm_medium = 'gads_m_video' Then 'Youtube'
    when utm_medium = 'gads_m_discovery' Then 'Discovery'
    when utm_medium = 'gads_t_discovery' Then 'Discovery'
    when utm_medium = 'gads_c_discovery' Then 'Discovery'
    when utm_medium = 'gads_t_display' Then 'Display'
    when utm_medium = 'gads_c_display' Then 'Display'
    when utm_medium = 'gads_m_display' Then 'Display'
    when utm_source = 'direct' Then 'Direct'
    when utm_source in ('organic')
    and utm_source not in (
      'CRM_p',
      'whatsapp_share',
      'direct',
      'native_share'
    ) then 'Organic'
    when utm_medium is null then 'Organic'
    when utm_medium = '' then 'Organic'
    else 'Others'
  end as utmmedium,
 
  Case
    when utm_medium in (
      'fbad',
      'FBboost',
      'gads_m_display',
      'gads_c_display',
      'gads_t_display',
      'gads_m_video',
      'gads_c_video',
      'gads_t_video',
      'gads_c_discovery',
      'gads_t_discovery',
      'gads_m_discovery'
    )
    and utm_source like '%_RM%' Then 'RM'
    when utm_medium in (
      'fbad',
      'FBboost',
      'gads_m_display',
      'gads_c_display',
      'gads_t_display',
      'gads_m_video',
      'gads_c_video',
      'gads_t_video',
      'gads_c_discovery',
      'gads_t_discovery',
      'gads_m_discovery'
    )
    and utm_source not like '%_RM%' Then 'PR'
    when utm_source like '%Remarketing%' Then 'RM'
    when utm_medium = 'email' Then 'email'
    when utm_medium = 'sms' Then 'sms'
    when utm_medium = 'webpush' Then 'Webpush'
    when utm_medium = 'push' Then 'Push'
    when utm_medium = 'whatsapp' Then 'Whatsapp'
    when utm_medium = 'affiliate' Then 'Website'
    when camp_id in (
      473,
      1027,
      1028,
      1029,
      1050,
      1051,
      1052,
      1054,
      1055,
      1056,
      1057
    ) then 'MissedCall'
    else 'Others'
  end as utmsource
  
from
  (
    SELECT
      b.id,
      t4.source,
      is_contact_number_verified,
      b.lead_qualified_type as lead_qualified_type,
      created_on + interval '5.5 hour' AS Created_on,
      s.description as status,
      DATE(created_on + interval '5.5 hour') AS created_date,
      aps.partner,
      aps.media_source,
      aps.platform as Platform2,
      EXTRACT(
        'month'
        from
          DATE(created_on + interval '5.5 hour')
      ) as created_month,
      b.Category,
      case
        when b.platform_source like '%app_%' THEN 'App'
        when b.platform_source like '%web%' THEN 'Web'
        when b.platform_source like '%mweb_%' THEN 'Web'
        else 'Others'
      end as platform,
      case
        when ph.campaign_id = 473 THEN 'Whistle_Mobi'
        when ph.campaign_id = 1027 THEN 'Profuse'
        when ph.campaign_id = 1028 THEN 'Karix'
        when ph.campaign_id = 1029 THEN 'Airtel'
        when ph.campaign_id = 1051 THEN 'Vserv'
        when ph.campaign_id = 1052 THEN 'Valueleaf'
        when ph.campaign_id = 1054 THEN 'Karshini'
        when ph.campaign_id = 1055 THEN 'Facebook'
        when ph.campaign_id = 1053 THEN 'm2000'
        else null
      end as camp_id,
      CASE
        WHEN t4.source = 'buyrequest' THEN mm.buyrequest
        WHEN t4.source = 'notifyme' THEN mm.notifyme
        WHEN t4.source = 'lead' THEN mm.listing_lead
        WHEN t4.source = 'dealrequest' THEN mm.dealrequest
        WHEN t4.source = 'callback' THEN mm.callback
        WHEN t4.source = 'filter' THEN mm.filter
        WHEN t4.source = 'carfinance' THEN mm.car_finance
        WHEN t4.source = 'shortlist' THEN mm.shorlist
        WHEN t4.source = 'message' THEN mm.message
        else null
      end as utm_medium,
      CASE
        WHEN t4.source = 'buyrequest' THEN mm.buyrequest_source
        WHEN t4.source = 'notifyme' THEN mm.notifyme_source
        WHEN t4.source = 'lead' THEN mm.listing_lead_source
        WHEN t4.source = 'dealrequest' THEN mm.dealrequest_source
        WHEN t4.source = 'callback' THEN mm.callback_source
        WHEN t4.source = 'filter' THEN mm.filter_source
        WHEN t4.source = 'carfinance' THEN mm.car_finance_source
        WHEN t4.source = 'shortlist' THEN mm.shorlist_source
        WHEN t4.source = 'message' THEN mm.message_source
        else null
      end as utm_source
    FROM
      sp_web_external.sp_web_buy_lead_buylead b
      LEFT JOIN sp_phonecall_external.sp_phonecall_call_logs ph on b.account_id = ph.account_id
      LEFT JOIN (SELECT account_id, media_source, partner, platform 
      FROM (SELECT accoUnt_id, media_source, platform, partner, row_number() over (partition by account_id ORDER BY install_time DESC) AS RC
      FROM sp_web_external.sp_web_accounts_accountmetadata acm
      LEFT JOIN sp_apps_flyer.installation_data aps ON acm.device_id = aps.customer_user_id)
      WHERE RC =1)aps ON aps.account_id = b.account_id
      LEFT JOIN sp_web_external.sp_web_status_status s ON b.status_id = s.id
      LEFT JOIN(
        SELECT
          t3.id,
          CASE
            WHEN t3.final_source = 'www.olx.in' THEN 'Olx'
            WHEN t3.final_source = 'www.cardekho.com' THEN 'CarDekho'
            WHEN t3.final_source = 'www.cartrade.com' THEN 'CarTrade'
            ELSE t3.final_source
          END AS SOURCE
        FROM(
            SELECT
              t2.id,
              t2.source_object_type_id,
              CASE
                WHEN t2.source_object_type_id = '321' THEN t2.exbr
                WHEN t2.source_object_type_id = '246'
                AND t2.url = 'Direct' then 'direct'
                WHEN t2.source_object_type_id = '319' THEN t2.platform
                WHEN t2.source_object_type_id = '322' THEN t2.platform
                ELSE t2.model
              END AS final_source,
              t2.url
            FROM(
                SELECT
                  b.id,
                  b.source,
                  b.source_object_id,
                  b.source_object_type_id,
                  dct.model,
                  elp.display_name AS platform,
                  lpa.display_name AS account,
                  t1.display_name AS exbr,
                  ww.title,
                  ww.url
                FROM
                  sp_web_external.sp_web_buy_lead_buylead b
                  LEFT JOIN sp_web_external.sp_web_django_content_type dct ON b.source_object_type_id = dct.id
                  LEFT JOIN sp_web_external.sp_web_external_listing_listingplatformaccounts lpa ON lpa.id = b.source_object_id
                  AND b.source_object_type_id IN ('322', '319')
                  LEFT JOIN sp_web_external.sp_web_external_listing_externallistingplatform elp ON lpa.platform_id = elp.id
                  AND b.source_object_type_id IN ('322', '319')
                  LEFT JOIN(
                    SELECT
                      b.id,
                      b.source_object_type_id,
                      b.source_object_id,
                      elp.display_name
                    FROM
                      sp_web_external.sp_web_buy_lead_buylead b
                      LEFT JOIN sp_web_external.sp_web_external_listing_externalbuyrequest eb ON eb.id = b.source_object_id
                      AND b.source_object_type_id = 321
                      LEFT JOIN sp_web_external.sp_web_external_listing_externallisting el ON el.id = eb.listing_id
                      LEFT JOIN sp_web_external.sp_web_external_listing_listingplatformaccounts lpa ON lpa.id = el.account_id
                      LEFT JOIN sp_web_external.sp_web_external_listing_externallistingplatform elp ON lpa.platform_id = elp.id
                  ) t1 ON t1.id = b.id
                  LEFT JOIN sp_web_external.sp_web_webresults_webarticle ww ON b.source_object_id = ww.id
                  AND b.source_object_type_id = 246
                WHERE
                  DATE(b.created_on + interval '5.5 hour') >= '2022-08-01'
              ) t2
          ) t3
      ) t4 on t4.id = b.id
      LEFT JOIN (
        SELECT
          b.id,
          is_contact_number_verified
        FROM
          sp_web_external.sp_web_buy_lead_buylead b
          LEFT JOIN sp_web_external.sp_web_accounts_accounts aa ON b.account_id = aa.id
          LEFT JOIN sp_web_external.sp_web_spinny_auth_user sau ON aa.user_id = sau.id
        ORDER BY
          b.id desc
      ) otp ON b.id = otp.id
      LEFT JOIN (
        SELECT
          b.id,
          mad.utm_medium as dealrequest,
          man.utm_medium as notifyme,
          mac.utm_medium as callback,
          mabr.utm_medium as buyrequest,
          mal.utm_medium as listing_lead,
          masl.utm_medium as sellrequest,
          mas.utm_medium as car_finance,
          mar.utm_medium as shorlist,
          maf.utm_medium as filter,
          maw.utm_medium as message,
          mad.utm_source as dealrequest_source,
          man.utm_source as notifyme_source,
          mac.utm_source as callback_source,
          mabr.utm_source as buyrequest_source,
          mal.utm_source as listing_lead_source,
          masl.utm_source as sellrequest_source,
          mas.utm_source as car_finance_source,
          mar.utm_source as shorlist_source,
          maf.utm_source as filter_source,
          maw.utm_source as message_source
        FROM
          sp_web_external.sp_web_buy_lead_buylead b
          LEFT JOIN sp_web_external.sp_web_buy_lead_dealrequest d on b.source_object_id = d.id
          LEFT JOIN sp_web_external.sp_web_buy_lead_notifyme n on b.source_object_id = n.id
          LEFT JOIN sp_web_external.sp_web_callback_callback c on b.source_object_id = c.id
          LEFT JOIN sp_web_external.sp_web_listing_buyrequest br on b.source_object_id = br.id
          LEFT JOIN sp_web_external.sp_web_listing_lead l on b.source_object_id = l.id
          LEFT JOIN sp_web_external.sp_web_listing_sellrequest sl on b.source_object_id = sl.id
          LEFT JOIN sp_web_external.sp_web_spinny_filters_filter f on b.source_object_id = f.id
          LEFT JOIN sp_web_external.sp_web_car_finance_carfinance s on b.source_object_id = s.id
          LEFT JOIN sp_web_external.sp_web_shortlist_shortlist ss on b.source_object_id = ss.id
          LEFT JOIN sp_web_external.sp_web_whatsapp_message wh on b.source_object_id = wh.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution mad ON d.marketing_attribution_id = mad.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution man ON n.marketing_attribution_id = man.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution mac ON c.marketing_attribution_id = mac.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution mabr ON br.marketing_attribution_id = mabr.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution mal ON l.marketing_attribution_id = mal.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution masl ON sl.marketing_attribution_id = masl.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution maf ON f.marketing_attribution_id = maf.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution mas ON s.marketing_attribution_id = mas.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution mar ON ss.marketing_attribution_id = mar.id
          LEFT JOIN sp_web_external.sp_web_marketing_marketingattribution maw ON wh.marketing_attribution = maw.id
        WHERE
        DATE(b.created_on + interval '5.5 hour')>= '2022-08-01'
      ) mm ON mm.id = b.id
    WHERE
      DATE(b.created_on + interval '5.5 hour') >= '2022-08-01'
     ) b
where
--   category = 'assured'
  and SOURCE not in ('Olx', 'CarDekho', 'CarTrade', 'hub') )b ON b.id = lead.id
      left join (
        select
          bl.id,
          case
            when bl.id in (
              SELECT
                bl.id
              FROM
                sp_web_external.sp_web_buy_lead_buylead as bl
              WHERE
                bl.id IN (
                  SELECT
                    DISTINCT bl.id
                  FROM
                    sp_web_external.sp_web_buy_lead_buylead as bl
                    LEFT JOIN sp_web_external.sp_web_visits_visit as v ON bl.id = v.buy_lead_id
                    LEFT JOIN sp_web_external.sp_web_spinny_auth_user as au ON au.id = v.created_by_id
                  WHERE
                    au.is_staff = 0
                    AND v.visit_type_id IN (1, 2)
                    AND DATE(bl.created_on) >= '2022-08-01'
                    -- AND bl.category = 'assured'
                )
              UNION ALL
              SELECT
                v.id
              FROM
                sp_web_external.sp_web_buy_lead_buylead as bl
                LEFT JOIN sp_web_external.sp_web_visits_visit as v ON bl.id = v.buy_lead_id
              WHERE
                v.visit_end_time IS NOT NULL
                AND v.visit_type_id IN (1, 2)
                AND bl.id IN (
                  SELECT
                    DISTINCT bl.id
                  FROM
                    sp_web_external.sp_web_buy_lead_buylead as bl
                    LEFT JOIN sp_web_external.sp_web_visits_visit as v ON bl.id = v.buy_lead_id
                    and datediff(MINUTE, bl.created_on, v.created_on) < 10
                    LEFT JOIN sp_web_external.sp_web_spinny_auth_user as au ON au.id = v.created_by_id
                  WHERE
                    au.is_staff = 0
                    AND v.visit_type_id IN (1, 2)
                    AND DATE(bl.created_on) >= '2022-08-01'
                    -- AND bl.category = 'assured'
                )
            ) then 1
            else 0
          end as cstd
        FROM
          sp_web_external.sp_web_buy_lead_buylead as bl
        where
          DATE(bl.created_on) >= '2022-08-01'
         
        --   AND bl.category = 'assured'
      ) as cstd1 ON cstd1.id = lead.id
      left join (
        (SELECT * FROM
          (SELECT
           DISTINCT bl.id,
            case
              when datediff(MINUTE, bl.created_on, wu.created_time) < 10 then 1
              else 0
            end as UAR,row_number() over(partition by bl.id order by wu.created_time  ) as rn,wu.created_time
          FROM
            sp_web_external.sp_web_buy_lead_buylead as bl
            LEFT JOIN sp_web_external.sp_web_workflow_usertask as wu on bl.id = wu.context_id
            and wu.context_type_id = 188
            AND wu.status_id = 82
          where
            -- bl.category = 'assured'
        DATE(bl.created_on) >= '2022-08-01')b
           WHERE rn =1)
      ) uar1 on uar1.id = lead.id
      
      left join
      (
        select
          a.buylead,
          case
            when a.row = 1 then 0
            else 1
          end as historic
        from
          (
            select
              bl.id as buylead,
              aa.id as account_id,
              bl.created_on,
              row_number() over (
                partition by aa.id
                order by
                  bl.created_on
              ) as row
            from
              sp_web_external.sp_web_buy_lead_buylead bl
              left join sp_web_external.sp_web_accounts_accounts aa on bl.account_id = aa.id

            where
              DATE(bl.created_on) >='2022-05-01'
              
            --   and bl.category = 'assured'
          ) a
      ) as hist on hist.buylead = lead.id
      left join sp_web_external.sp_web_visits_visit as v on lead.id = v.buy_lead_id
      AND v.visit_end_time IS NOT NULL
      AND v.visit_type_id IN (1, 2)
      LEFT JOIN sp_web_external.sp_web_buy_lead_carpurchase as cp on cp.buy_lead_id = lead.id
      AND cp.status_id = 153
      left join ( select id, OTP_Verified, case when otp_tat <=10 then 1 
               when otp_tat > 10 then 0 end as OTP_time
              
                FROM(SELECT b.id,sau.is_contact_number_verified  as OTP_Verified,
                datediff('minutes',(ac.created_at+interval'5.5 hours'),(b.created_on+interval'5.5 hours')) as otp_tat
                
                FROM sp_web_external.sp_web_buy_lead_buylead b 
                LEFT JOIN sp_web_external.sp_web_accounts_accounts ac ON b.account_id=ac.id
                LEFT JOIN sp_web_external.sp_web_spinny_auth_user sau ON ac.user_id = sau.id
                where  
                -- b.category='assured'
                DATE(b.created_on) >=  '2022-08-01')t1
      )otp on otp.id=lead.id 
)

select distinct buy_lead_id,
created_on,
utmsource,
utmmedium,
cstd,
uar
from base
where 
created_on >= date('2023-01-01') 
and 
created_on <= date('2023-05-01')

function isScrolledIntoView(elem) {
    var docViewTop = $(window).scrollTop();
    var docViewBottom = docViewTop + $(window).height();

    var elemTop = $(elem).offset().top;
    var elemBottom = elemTop + $(elem).height();

    return ((elemBottom <= docViewBottom) && (elemTop >= docViewTop));
}

$(window).scroll(function () {
    $('.textbox').each(function () {
        if (isScrolledIntoView(this) === true) {
            $(this).addClass('visible');
        }
    });

});

@BeforeMethod
@Parameters({"BaseURL"})
public void launchBrowser(String BaseURL) {
  
  ChromeOptions options = new ChromeOptions();
  options.addArguments("--remote-allow-origins=*");

  WebDriver driver = new ChromeDriver(options);
  driver.manage().timeouts().implicitlyWait(Duration.ofSeconds(10));
  url = BaseURL;
  driver.get(url);
}

@Test
public static void RegistrationSuccessTest () {
  
  ChromeOptions options = new ChromeOptions();
  options.addArguments("--remote-allow-origins=*");

  WebDriver driver = new ChromeDriver(options);
  driver.manage().timeouts().implicitlyWait(Duration.ofSeconds(10));

  String url = "https://qa.koel.app/";
  driver.get(url);
  Assert.assertEquals(driver.getCurrentUrl(), url);
  driver.quit();
}

@Test
public static void RegistrationSuccessTest () {

  WebDriver driver = new ChromeDriver();
  driver.manage().timeouts().implicitlyWait(Duration.ofSeconds(10));

  String url = "https://qa.koel.app/";
  driver.get(url);
  Assert.assertEquals(driver.getCurrentUrl(), url);
  driver.quit();
}

bench init frappe-bench --frappe-branch version-13
https://dapper-mind-3bf.notion.site/Frappe13-f16a49137ae1496c9bc70cd19f7d49b3?pvs=4

async function successA(){return 'A'}
async function successB(){return 'B'}
async function failC(){throw 'error c'}
async function failD(){throw 'error d'}

const results = await Promise.allSettled([
    successA(),
    successB(),
    failC(),
    failD()
])

const successfullResults = results
    .filter(result => result.status === "fulfilled")
    .map(result => result.value)

console.log(successfullResults)

results
    .filter(result => result.status === "rejected")
    .forEach(error => console.log(error.reason))

<form action="/submit-contact-form" method="POST">
      <label for="name">Name:</label>
      <input type="text" id="name" name="name" required>

      <label for="email">Email:</label>
      <input type="text" id="email" name="email" required>

      <label for="message">Message:</label>
      <textarea id="message" name="message" rows="5" required></textarea>

      <input type="submit" value="Submit">

We are a leading blockchain game development company that specializes in creating immersive, interactive, and profitable blockchain games.

class Solution {
    int mod = (int) 1e9 + 7;
    public int sumDistance(int[] nums, String s, int d) {
        int n = nums.length;

        //no difference if robots phase through each other , think of it like swapping robots
        for(int i = 0 ;i < n ; i++){
            char ch = s.charAt(i);
            
            if(ch == 'L')
            nums[i] -= d;

            else
            nums[i] += d;
        }

        //sorting to get the correct order number line
        Arrays.sort(nums);

        //for further logic how to find the total distance -> 6:00
        //https://www.youtube.com/watch?v=OiY_p1T5wA0 

        //finding difference between consecutive elements
        long diff[] = new long[n-1];
        for(int i = 0 ;i < n-1; i++){
            diff[i] = Math.abs(nums[i] - nums[i+1]);
        }

        //using diff array to count distance
        long i = n-1 , j = 1;
        long ans = 0;

        for(int z= 0 ;z < n-1 ; z++){
            ans = (ans +(diff[z] * i * j)) % mod;
            i--;
            j++;
        }
        
        return (int)ans ;
    }
}

const Loginform = () => {
  const navigate = useNavigate();
  const [user, setUser] = useState({
    credentials: "", Password: ""
  });

  let name, value;

  const handleinput = (e) => {
    name = e.target.name;
    value = e.target.value;
    setUser({ ...user, [name]: value });

  }

userModel.js File --->
  
static async getAllUsers() {
    try {
        const users = await MykhojUserMstModel.findAll();
        return users;
    } catch (error) {
        throw new Error('Failed to retrieve users');
    }
}

userController.js File---->
  
const loginController = {
    // ...existing code...

    getAllUsers: async (req, res, next) => {
        try {
            const users = await UserMst.getAllUsers();
            res.status(200).json(users);
        } catch (error) {
            console.log(error);
            res.status(500).json({ error: 'Failed to retrieve users' });
        }
    },
};

module.exports = loginController;

  <Link to="/wills/quick-booking">
                    <span className="box-title">
                      Book Quick Appointment
                    </span>
                  </Link>
                  
                  
                  you are an expert in react development.
                  i have added a link component and set the route. 
                  but when i clikc "Book Quick Appointment". it throws error message like  
                  "No route matches URL \"/wills/quick-booking\""
                  its status is 404 not found.
                  Help me to find and fix solution for the problem.
                  
                  

                  Solutions:
                  
                  1. Make sure that you have a Route component in your app that matches the /wills/quick-booking path. You can do this by adding the following code to your app:

<Route exact path="/wills/quick-booking">
  {/* Insert the component for the quick booking page here */}
</Route>

check routes file in projct directory and update the path.







                  

<!DOCTYPE html>
<html>
<body>

<h2>What Can JavaScript Do?</h2>

<p id="demo">My name is Lillian.</p>

<button type="button" onclick="document.getElementById('demo').style.fontSize='35px'">Click Me!</button>

</body>
</html> 

class Solution{
    public:
int randomPartition(int arr[], int l, int r)
    {
        int n = r-l+1;
        int pivot = rand() % n;
        swap(arr[l + pivot], arr[r]);
        return partition(arr, l, r);
    }
    int kthSmallest(int arr[], int l, int r, int k)
    {
        // If k is smaller than number of elements in array
        if (k > 0 && k <= r - l + 1)
        {
            // find a position for random partition
            int pos = randomPartition(arr, l, r);
            
            // if this pos gives the kth smallest element, then return
            if (pos-l == k-1)
                return arr[pos];
                
            // else recurse for the left and right half accordingly
            if (pos-l > k-1)  
                return kthSmallest(arr, l, pos-1, k);
            return kthSmallest(arr, pos+1, r, k-pos+l-1);
        }
    
        return INT_MAX;
    }
     
    // partitioning the array along the pivot
    int partition(int arr[], int l, int r)
    {
        int x = arr[r], i = l;
        for (int j = l; j <= r - 1; j++)
        {
            if (arr[j] <= x)
            {
                swap(arr[i], arr[j]);
                i++;
            }
        }
        swap(arr[i], arr[r]);
        return i;
    }
};

 <el-select v-model="row.deptId" placeholder="请选择" @change="(deptId) => andleChangeDeptId(deptId, $index)">
         <el-option v-for="item in projectList" :label="item.name" :value="item.deptId" 	 :key="item.deptId"></el-option>
</el-select>

handleChangeDeptId(deptId, index) {
   console.log(deptId, index) // 这个就是你传过来的值了
}

"""
Problem Description
Given a non-empty array of digits representing a non-negative integer, plus one to the integer and return the same list.

The digits are stored such that the most significant digit is at the head of the list, and each element in the array contain a single digit.

You may assume the integer does not contain any leading zero, except the number 0 itself.

Input format
You will be given a list of integers.

Output format
Return a list of integer +1.

Sample Input 1
1 2 3

Sample Output 1
1 2 4

Explanation 1
The array represents the integer 123.

Sample Input 2
4 3 2 1

Sample Output 2
4 3 2 2
"""

Consider you are an experienced python developer.
Help me to solve the above problem and integrate the code into below code.
Code should follow python naming conventions
Return the updated code.

```py
def plusOne(digits):
if __name__ == '__main__':
    digits = input().split()
    digits = [int(i) for i in digits]
    result = plusOne(digits)
    for i in result:
        print(i,end=' ')
```

<!DOCTYPE html>
<html>
<body>

<h2>What Can JavaScript Do?</h2>

<p>JavaScript can change HTML attribute values.</p>

<p>In this case JavaScript changes the value of the src (source) attribute of an image.</p>

<button onclick="document.getElementById('myImage').src='pic_bulbon.gif'">Turn on the light</button>

<img id="myImage" src="pic_bulboff.gif" style="width:100px">

<button onclick="document.getElementById('myImage').src='pic_bulboff.gif'">Turn off the light</button>

<button onclick="document.getElementById('myImage').src='pic_lighton.gif'">Turn on light</button>

<img id="myImage" src="pic_bulboff.gif" style="width:100px">

<button onclick="document.getElementById('myImage').src='pic_lightoff.gif'">Turn off light</button>

</body>
</html>

​#include <iostream>

using namespace std;

int main()
{
    int n;
    cin >> n;
    long long rez;
    rez = 1LL * n * (n + 1) / 2;
    cout << rez;
    return 0;
}

SELECT column1, column2, ...., columnN, COUNT(*) as count
FROM name_of_table
GROUP BY column1, column2, ...., columnN
HAVING COUNT(*) > 1;

.text-ellipsis--2{
  text-overflow:ellipsis;
  overflow:hidden;
  // Addition lines for 2 line or multiline ellipsis
  display: -webkit-box !important;
  -webkit-line-clamp: 2; /*here number of lines*/
  -webkit-box-orient: vertical;
  white-space: normal;
}

a.

public static void main(String[] args) {
		
		xmethod(5);
	
	}
	public static void xmethod(int n) {
		if(n > 0) {
			System.out.print( n + " ");
			xmethod (n-1);
	
		}
	}
}
//output:
5 4 3 2 1


b. 
public static void main(String[] args) {
		
		xmethod(5);
	
	}
	public static void xmethod(int n) {
		if(n > 0) {
			xmethod (n-1);
			System.out.print( n + " ");
		}
	}
}

//Output:
 5 4 3 2 1

public static void main(String[] args) {
		
		//Scanner scan = new Scanner(System.in); 
		//System.out.println("Enter Non Negetive Number: ");
		//int number = scan.nextInt();
		
		System.out.println(xmethod(5));
		
		
	}
	public static int xmethod(int number) {
		if(number==1)
			return 1;
		else
			return number + xmethod(number-1);
	}
}

//OUTPUT: 15
1+2+3+4+5 =  15

function check_post_input_varsdd( $postId, $post, $update ) {

	if ( $post->post_type === 'sp_easy_accordion' && 4551 === $postId ) {
		// Get the exact number of input variables in $_POST
		$input_count = count( $_POST, COUNT_RECURSIVE ) - count( $_POST );
		echo( '<pre>' );
		var_dump( 'input_count' . $input_count );
		echo( '</pre>' );
		die;
	}

}

//add_action( 'save_post', 'check_post_input_varsdd', 99, 3 );

sudo docker stop $(sudo docker ps -aq)

sudo docker rm $(sudo docker ps -aq)

docker build -f ./server/Dockerfile-dev . -t f-server:dev2
docker tag f-server:dev menaheero/f-server:dev
docker push menaheero/f-server:dev
docker build -f ./Dockerfile . -t f-front:dev2
docker-compose up -d --force-recreate


cd /www/flag/ && docker-compose pull frontend && docker-compose stop frontend && docker-compose up -d frontend; rm -r frontend/_nuxt/ &> /dev/null; docker cp alltargeting_frontend:/app/.nuxt/dist/client/ frontend/_nuxt; sleep 5s;

docker-compose up -d --force-recreate
docker-compose exec -T server python ./manage.py migrate
docker-compose exec -T server python ./manage.py collectstatic --noinput
docker image prune -f

class Solution {
    public int[] maximumSumQueries(int[] nums1, int[] nums2, int[][] queries) {
        int n = nums1.length;

        //we will use Treemap to store sum -> nums1
        TreeMap<Integer,TreeSet<Integer>> map = new TreeMap<>();
        
        //filling elements sums -> num1 ( we will find num2 through sum - num1)
        for(int i = 0 ;i < n ;i++){
            int val1 = nums1[i] , val2 = nums2[i] , total = val1 + val2;
            
            map.computeIfAbsent(total , k -> new TreeSet<>()).add(val1);
        }

        int ans[] = new int[queries.length];
        //process queries
        for(int i =0 ;i < queries.length ; i++)
        ans[i] = getMax(map , queries[i] );
        

        return ans;
    }

    public int getMax(TreeMap<Integer,TreeSet<Integer>> map ,int[] queries){
        int x = queries[0] , y = queries[1];

        //we will get the last key in the treeMap as that will be maximum
        Integer sum = map.lastKey();

        //check if sum exists and is greater than x+y
        while(sum != null && sum >= x+y){
            TreeSet<Integer> temp = map.get(sum);

            //now get the num1 against that sum which is >= x
            Integer num1 = temp.ceiling(x);

            //check if num1 exists and is >= x then find num2
            if(num1 != null && num1 >= x){
                int num2 = sum - num1;

                //if both are >= x and y respectively return that answer
                if(num2 >= y)
                return sum;
            }

            /* if either num1 or 2 is invalid go to a lower key sum , which is still
             greater than x+y , as we need to store the maximum*/
            sum = map.lowerKey(sum);
        }

        return -1;
    }
}

<!-- add normal flaoting button html code here on top 
if the language here is Swedish, then you don't have to add SV in the script
-->

<script>  
        jQuery(document).ready(function($){
                var urlParams = new URLSearchParams(window.location.search); 
        		var lang = urlParams.get('lang');
        if(lang == 'en') { 
                $('.fh-lang').html('Book Now');
                } if(lang == 'de') { 
                $('.fh-lang').html('Jetzt Buchen');
                } 
        });
</script>

class MykhojUserMstModel extends Sequelize.Model {
    static associate(models) {
        // Define associations with other models, if any
    }
}

MykhojUserMstModel.init(
    {
        UserID: {
            type: DataTypes.INTEGER,
            primaryKey: true,
            autoIncrement: true,
        },
        UserName: {
            type: DataTypes.STRING(50),
            allowNull: false,
        },
        Password: {
            type: DataTypes.STRING(100),
            allowNull: false,
        },
        DepartmentID: {
            type: DataTypes.TINYINT,
            allowNull: false,
            references: {
                model: 'MykhojDepartmentMstModel',
                key: 'DepartmentID',
            },
        },
        DesignationID: {
            type: DataTypes.TINYINT,
            allowNull: false,
            references: {
                model: 'MykhojDesignationMstModel',
                key: 'DesignationID',
            },
        },
        Roll: {
            type: DataTypes.STRING(50),
            allowNull: false,
        },
        FName: {
            type: DataTypes.STRING(50),
            allowNull: false,
        },
        LName: {
            type: DataTypes.STRING(50),
            allowNull: false,
        },
        Gender: {
            type: DataTypes.ENUM('Male', 'Female'),
            allowNull: false,
            defaultValue: 'Male',
        },
        Email: {
            type: DataTypes.STRING(50),
            allowNull: false,
        },
        MobileNumber: {
            type: DataTypes.BIGINT.UNSIGNED,
            allowNull: false,
        },
        RAddress: {
            type: DataTypes.STRING(255),
            allowNull: false,
        },
        CityID: {
            type: DataTypes.MEDIUMINT,
            allowNull: false,
            references: {
                model: 'L_CityMst',
                key: 'CityID',
            },
        },
        Status: {
            type: DataTypes.BOOLEAN,
            defaultValue: true,
        },
        CreatedBy: {
            type: DataTypes.MEDIUMINT,
            allowNull: false,
            references: {
                model: 'Adm_UserMst',
                key: 'UserID',
            },
        },
        ModifiedBy: {
            type: DataTypes.MEDIUMINT,
            allowNull: false,
            references: {
                model: 'Adm_UserMst',
                key: 'UserID',
            },
        },
        ModifiedOn: {
            type: DataTypes.DATE,
            defaultValue: DataTypes.NOW,
        },
    },
    {
        sequelize: sequelizeInstances.Mykhoj,
        modelName: 'MykhojUserMst',
        tableName: 'Adm_UserMst',
        underscored: false,
        timestamps: false,
    }
);

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Express js</title>
</head>
<body>
    <form action="/data" method="post">
        <input type="text" name="name"  >
        <input type="email" name="email"   >
        <input type="submit" value="submit" >
    </form>
</body>
</html>

const expres = require("express");
const app = expres();
const path = require("path");
const bodyParser = require("body-parser");

app.use(bodyParser.urlencoded({extended: false}));

app.get("/",(req, res) =>{
    res.sendFile(path.join(__dirname + "/index.html"));
})

app.post("/data", (req, res) =>{
    const userName = req.body.name;
    const email = req.body.email;
    const sum = userName+ " " + email;
    res.send(sum);
    
});

const PORT = 4000;

app.listen(PORT, () =>{
    console.log(`Server is working on ${PORT}`)
});

const express = require("express");
const app = express();
const path = require("path");

app.get("/", (req, res) =>{
    res.sendFile(path.join(__dirname +  "/index.html"))
});

const PORT = 4000;

app.listen(PORT, () =>{
    console.log(`Server is working on ${PORT}`)
});

du -hs * | sort -hr

public static void main(String[] args) {
		int array1[]={2,3,4,6};
		int array2[]={1,2,5,4,5,7,2,3}; 
		
		System.out.print("my Array 1 = " + Arrays.toString(array1));
		
		System.out.print("\n\nmy Array 2 = " + Arrays.toString(array2));

		System.out.println("\n\n\nFrom Array1 to Array2:  " + Arrays.toString(append(array1,array2)));
		
		
		System.out.println("\n\nFrom Array2 To Array 1: " + Arrays.toString(append(array2, array1)));
		

		
	}
	public static int[] append(int[] array1, int[] array2) {
		
		int array1Length = array1.length;
		int array2Length = array2.length;
		
		int[] array3 = new int[array1Length+array2Length]; 
		
		for(int i=0;i<array1Length;i++)
		{
			array3[i]=array1[i];
		}
		for(int i=0;i<array2Length;i++) 
		{
		array3[array1Length+i]=array2[i];
		}
		return array3;
		}
	
}

//OUTPUT:
my Array 1 = [2, 3, 4, 6]

my Array 2 = [1, 2, 5, 4, 5, 7, 2, 3]


From Array1 to Array2:  [2, 3, 4, 6, 1, 2, 5, 4, 5, 7, 2, 3]


From Array2 To Array 1: [1, 2, 5, 4, 5, 7, 2, 3, 2, 3, 4, 6]

public static void main(String[] args) {
		//int[] array = {1,2,3,4,5};
		//System.out.print(collapse(array));
		
	}
	@SuppressWarnings("unused")
	public static int[] collapse(int[] array) {
		
		int L=array.length; 
		int outSize;
		
		if(L%2==0)
			outSize = L/2;
		else
			outSize = L/2+1;
		
		int[] array2 = new int[outSize]; //{2 3 4 5 6 7} ->{5 9 13}
			//{2 3 4 5 6} -> {5 9 6}
		int i2=0;
		
		for(int i=0;i<L-1;i=i+2) 
		{
			array2[i/2] = array[i] + array[i+1];
			//i2++; }
			if(L%2==1) {
			array2[outSize-1] = array[L-1]; }
			return array2;
		}
		return array2;
	}
}

first npm init
second npm i express nodemon


const http = require("http");
const fs = require("fs");

const home = fs.readFileSync("./index.html", "utf-8");
const server = http.createServer((req, res) =>{
    if(req.url === "/"){
     return   res.end(home);
    }
   
});

const PORT = 4000;
const hostname = "localhost";

server.listen(PORT, hostname, () =>{
    console.log("Server is working");
});

public static void main(String[] args) {
		int[] array1= {4,2,3,1,2,1};
		int[] array2 = {2,3,1};
		
		 System.out.print(contain(array1, array2));
		
	}
	
	public static boolean contain(int[] array1, int[] array2) {
		int counter =0;
		for(int i=0; i<(array1.length-array2.length); i++) 
		{
			counter =0;
			for(int j=0; j<array2.length; j++) 
			{
				if(array1[i+j] == array2[j]) 
					counter ++;
				else
					break;
				}
			if(counter == array2.length)
				return true;
		}
		return false;
	}
}

//OUTPUT:
true.

public static void main(String[] args) {
		int[][] array = {
				{10,20,30},
				{40,50,60},
				{70,80,90},
		};
		RowColumn(array);
		SumRow(array);
		SumColumn(array);
		
		String[][] name = {
				{"Moha", "Ade", "Yahya"},
				{"Abdi", "abdirahman", "Xidig"},
		};
		names(name);
		
	}
	public static void RowColumn(int[][] array) {
		for(int i =0; i<array.length; i++) {
			for(int j=0; j<array[i].length; j++) {
				System.out.print(array[i][j] + " ");
			}
			System.out.println();
		}
	}
	public static void SumRow(int[][] array) {
		for(int i=0; i<array.length; i++) {
			int Sum = 0;
			for(int j=0; j<array[i].length; j++) {
				Sum = Sum + array[i][j];
			}
			System.out.println("\nSum of Row " + i + ", is = " + Sum );
		}
	}
	public static void SumColumn(int[][] array) {
		for(int j=0; j<array[0].length; j++) {
			int sum = 0;
			for(int i=0; i<array.length; i++) {
				sum = sum + array[i][j];
			}
			System.out.println("\nSum of Column " + j + ", is = " + sum);
		}
	}
	public static void names(String[][] name) {
		for(int j=0; j<name[0].length; j++) {
			String full_name = "  ";
			for(int i=0; i<name.length; i++) {
				full_name = full_name + name[i][j];
			}
			System.out.println("\nfull names of colum " + j + ", are " + full_name);
		}
	}
}

//OUTPUT:
10 20 30 
40 50 60 
70 80 90 

Sum of Row 0, is = 60

Sum of Row 1, is = 150

Sum of Row 2, is = 240

Sum of Column 0, is = 120

Sum of Column 1, is = 150

Sum of Column 2, is = 180

full names of colum 0, are   MohaAbdi

full names of colum 1, are   Adeabdirahman

full names of colum 2, are   YahyaXidig

composer require laravel/breeze --dev