Skip to content

Instantly share code, notes, and snippets.

View Khuzha's full-sized avatar

Sardorkhuja Tukhtakhodjaev Khuzha

51 followers · 43 following
View GitHub Profile
@Khuzha
Khuzha / pgsql
Last active September 8, 2020 07:52
SELECT main.login, main.timestamp, main.partner_id, main.currency, main.ref_camp, main.subtype,
deposit, payout, main.income, dep_players_count, fd_count, bonus_amount, bonus_currency,
COUNT(reg.login) AS regs
FROM (SELECT p2.login, tr.timestamp::date, p2.partner_id, tr.currency, p1.ref_camp, tr.subtype,
SUM(tr.amount) FILTER(WHERE tr.type = 'deposit') AS deposit,
SUM(tr.amount) FILTER(WHERE tr.type = 'payout') AS payout,
SUM(tr.amount) FILTER(WHERE tr.type = 'deposit') -
SUM(tr.amount) FILTER(WHERE tr.type = 'payout') as income,
COUNT(DISTINCT tr.login) FILTER(WHERE tr.type = 'deposit') AS dep_players_count,
COUNT(tr.amount)
@Khuzha
Khuzha / PostgreSQL
Created September 7, 2020 09:46
Правильно подсчитывающий запрос:
```SELECT p2.login, tr.timestamp::date, p2.partner_id, tr.currency, p1.ref_camp, tr.subtype,
SUM(tr.amount) FILTER(WHERE tr.type = 'deposit') AS deposit,
SUM(tr.amount) FILTER(WHERE tr.type = 'payout') AS payout,
SUM(tr.amount) FILTER(WHERE tr.type = 'deposit') -
SUM(tr.amount) FILTER(WHERE tr.type = 'payout') as income,
COUNT(DISTINCT tr.login) FILTER(WHERE tr.type = 'deposit') as dep_players_count,
COUNT(*) FILTER (WHERE tr.type = 'deposit' AND tr.subtype = 'first') as fd_count
FROM transactions_paysys tr
@Khuzha
Khuzha / код
Created August 16, 2020 21:13
<% if (result.length !== 0) { %>
<h2 class="text-center">Результаты поиска</h2>
<table class="table table-hover">
<thead class="black white-text">
<tr>
<th scope="col">№</th>
<th scope="col">Фамилия, имя</th>
<th scope="col">Комната</th>
@Khuzha
Khuzha / Sergey.java
Created June 11, 2020 08:21
package com.khuzha.objects;
import java.util.Scanner;
public class Sergey {
static int factorial(int n) {
if (n == 0)
return 1;
else
return(n * factorial(n-1));
@Khuzha
Khuzha / lodger.ejs
Created June 8, 2020 00:04
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title><%= lodger.lastName %> <%= lodger.firstName %> <%= lodger.fathersName %></title>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css"
integrity="sha384-9aIt2nRpC12Uk9gS9baDl411NQApFmC26EwAOH8WgZl5MYYxFfc+NcPb1dKGj7Sk" crossorigin="anonymous">
</head>
<body class="container mt-3">
<% if (edited) { %>
@Khuzha
Khuzha / For Ilya
Created May 20, 2020 00:01
import java.io.IOException;
import java.net.URI;
import java.net.http.HttpClient;
import java.net.http.HttpRequest;
import java.net.http.HttpResponse;
import java.util.Scanner;
public class Calc {
public static void main(String[] args) throws IOException, InterruptedException {
@Khuzha
Khuzha / read-excel-file
Created April 27, 2020 22:55
const schema = {
'Date of request': {
prop: 'date',
type: Date
},
'Name': {
prop: 'name',
type: String
},
'Birthday': {
@Khuzha
Khuzha / For Julia
Last active April 4, 2020 21:47
def devyatoe(a):
"""
Выведет в стандартный поток вывод возраст и слово "год" в нужном падеже
:параметр a: возраст
:тип данных параметра a: целочисленное значение
:функция вернет: ничего
"""
if a%10==0 or a%10>4 or a//10%10==1:
"""
@Khuzha
Khuzha / mod
Last active February 29, 2020 17:34
for Albina
package com.khuzha.objects;
public class Main {
public static void main(String[] args) {
int k = 2, l = 2, m = 4, n = 6;
if (l % k == 0 && m % k == 0 && n % k == 0) {
System.out.println("Все эти числа можно разделить на число k без остатка.");
} else {
System.out.println("Одно из этих чисел делится на число k с остатком");
@Khuzha
Khuzha / Вычисление высоты треугольника по его сторонам
Created February 15, 2020 21:52
package com.khuzha.objects;
import java.util.Scanner;
public class Main {
public static void main(String[] args) {
Scanner scan = new Scanner(System.in);
System.out.println("Введите длину стороны а:");
float a = scan.nextInt();