Andrey dron79-79
dron79-79
/ Excel cell format
Created
November 23, 2023 16:49
— forked from zloidjinn/Excel cell format
Styling Excel cells with mso-number-format
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Styling Excel cells with mso-number-format | |
| mso-number-format:"0" NO Decimals | |
| mso-number-format:"0\.000" 3 Decimals | |
| mso-number-format:"\#\,\#\#0\.000" Comma with 3 dec | |
| mso-number-format:"mm\/dd\/yy" Date7 | |
| mso-number-format:"mmmm\ d\,\ yyyy" Date9 | |
| mso-number-format:"m\/d\/yy\ h\:mm\ AM\/PM" D -T AMPM | |
| mso-number-format:"Short Date" 01/03/1998 | |
| mso-number-format:"Medium Date" 01-mar-98 | |
| mso-number-format:"d\-mmm\-yyyy" 01-mar-1998 |
dron79-79
/ index.html
Created
February 15, 2021 05:51
— forked from chrisveness/index.html
JavaScript AES client/server interoperability test
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!doctype html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8"> | |
| <title>AES client/server test</title> | |
| <link rel="stylesheet" href="//cdnjs.cloudflare.com/ajax/libs/normalize/3.0.3/normalize.min.css"> | |
| <style> | |
| body { font-size: 80%; padding: 1em; } | |
| form { margin-top: 2em; } | |
| label { display: inline-block; width: 6em; } |
dron79-79
/ Process.php
Last active
January 9, 2020 05:26
— forked from jankal/Process.php
PHP Process class
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * @compability: Linux only. (Windows does not work). | |
| * @author: Alexander Jank <[email protected]> | |
| */ | |
| class Process{ | |
| private $pid; | |
| private $command; | |
| private $cmdHash; | |
| public $output = ""; |
dron79-79
/ реверс строки
Created
October 31, 2018 04:41
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * функция переворота строки | |
| * @param string $string | |
| * @return string | |
| */ | |
| function reverseString($string) { | |
| $lenString = mb_strlen($string, 'UTF-8'); | |
| $arrayTo = []; | |
| if ($lenString > 255) { | |
| return 'Заднаная строка превышает длинну в 255 символов'; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /** | |
| * функция начисления очков по результатам угаданного счета в играх | |
| * @param int $aa предпологаемый счет команды А | |
| * @param int $ab предпологаемый счет команды Б | |
| * @param int $fa фактический счет команды А | |
| * @param int $fb фактический счет команды Б | |
| * @return int | |
| */ | |
| public function getSkore($aa, $ab, $fa, $fb) { |
dron79-79
/ gist:fc5a5d5009581727dde29120e40711ab
Created
October 30, 2018 20:53
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT ID, email, score, company_id | |
| FROM users t1 WHERE score=(SELECT MAX(t2.score) | |
| FROM users t2 WHERE t1.company_id = t2.company_id) | |
| ORDER BY company_id ASC; |