Jan Jůna junajan

## mysql-wrapper-class.php
<?php
/*
#
#   Trida zajistujici praci s databazi.
#   Pokud se planuje pouziti jine databaze, pak je nutne vytvorit kopii teto tridy s prikazi pro zvolenou
#   databazi, ulozit ji pod nazvem_databaze.class.php
#
*/

class MySQL {

## flatten.js
const arr = [{
  values: [1, 2]
}, {
  values: [3, 4]
}];


const c = arr
  .map((obj) => obj.values)
  .reduce(((all, arr) => [...all, ...arr]), []);

## 90tka_trades_simple_oct_nov_dec.tsv

          
            #
            Ticker
            Amnt (pieces)
            Open date
            O. Price
            Close date
            C. Price
            Profit/Loss

            
              846
              MDT
              125 (2)
              Dec 26, 2018
              $11,072.25 ($88.58)
              Dec 27, 2018
              $11,176.65 ($89.41)
              $104.40 | 0.94%

            
              844
              MDT
              66 (1)
              Dec 17, 2018
              $6,072.34 ($92.01)
              Dec 27, 2018
              $5,901.27 ($89.41)
              ($171.07) | -2.82%

            
              843
              WMT
              133 (2)
              Dec 17, 2018
              $12,066.76 ($90.73)
              Dec 26, 2018
              $12,011.88 ($90.31)
              ($54.88) | -0.45%

            
              842
              WMT
              65 (1)
              Dec 14, 2018
              $5,968.00 ($91.82)
              Dec 26, 2018
              $5,870.47 ($90.31)
              ($97.53) | -1.63%

            
              837
              USB
              474 (4)
              Dec 10, 2018
              $24,004.36 ($50.64)
              Dec 26, 2018
              $21,471.82 ($45.30)
              ($2,532.53) | -10.55%

            
              833
              USB
              346 (3)
              Dec 7, 2018
              $17,937.64 ($51.84)
              Dec 26, 2018
              $15,673.52 ($45.30)
              ($2,264.12) | -12.62%

            
              831
              USB
              228 (2)
              Dec 6, 2018
              $11,934.52 ($52.34)
              Dec 26, 2018
              $10,328.22 ($45.30)
              ($1,606.31) | -13.46%

            
              830
              USB
              113 (1)
              Dec 4, 2018
              $5,951.57 ($52.67)
              Dec 26, 2018
              $5,118.81 ($45.30)
              ($832.76) | -13.99%

            
              845
              UNP
              130 (3)
              Dec 17, 2018
              $18,172.00 ($139.78)
              Dec 26, 2018
              $17,672.04 ($135.94)
              ($499.95) | -2.75%

## stocks_over_sma200.tsv

          
            Ticker
            Name
            Sector
            Exchange
            Health

            
              ABT
              Abbott Laboratories
              Health Care
              NYSE
              +

            
              AMGN
              Amgen Inc.
              Health Care
              NASDAQ
              +

            
              EXC
              Exelon
              Utilities
              NYSE
              +

            
              FOXA
              Twenty-First Century Fox, Inc
              Consumer Discretionary
              NASDAQ
              +

            
              KO
              The Coca-Cola Company
              Consumer Staples
              NYSE
              +

            
              LLY
              Eli Lilly and Company
              Health Care
              NYSE
              +

            
              MCD
              McDonald's Corp
              Consumer Discretionary
              NYSE
              +

            
              MDT
              Medtronic Inc.
              Health Care
              NYSE
              +

            
              MRK
              Merck & Co.
              Health Care
              NYSE
              +

## stream.csv

          
            id
            date
            kraken_USDTZUSD
            kraken_XXLMZUSD
            kraken_XXRPZUSD
            binance_XRPUSDT
            binance_XLMUSDT
            binance_TUSDUSDT

            
              1
              2018-12-09 18:51:06
              0.99700
              0.12399
              0.31173
              0.31350
              0.12392
              1.00240

            
              2
              2018-12-09 18:51:18
              0.99700
              0.12399
              0.31173
              0.31355
              0.12393
              1.00240

## binancePrices.js
// Binance prices:
{
  ETHBTC: '0.03121200',
  LTCBTC: '0.00754100',
  BNBBTC: '0.00138310',
  NEOBTC: '0.00224200',
  QTUMETH: '0.01765700',
  EOSETH: '0.02610500',
  SNTETH: '0.00016991',
  BNTETH: '0.00597600',

## sockets.js
// == Client 1 ==
var socket = require('socket.io-client')('http://localhost');

const gameInfo = null
socket.emit('createGame', (createdGame) => {
	gameInfo = createdGame
})

socket.on('clientConnected', (clientId) => {


## 90tka_trades_simple_september.tsv

          
            #
            Ticker
            Amnt (pieces)
            Open date
            O. Price
            Close date
            C. Price
            Profit/Loss

            
              788
              KMI
              919 (2)
              Sep 27, 2018
              $16,155.56 ($17.58)
              Sep 28, 2018
              $16,294.70 ($17.73)
              $139.14 | 0.86%

            
              787
              SPG
              91 (2)
              Sep 26, 2018
              $15,974.69 ($175.55)
              Sep 28, 2018
              $16,078.04 ($176.68)
              $103.36 | 0.65%

            
              785
              KMI
              456 (1)
              Sep 26, 2018
              $8,035.04 ($17.62)
              Sep 28, 2018
              $8,085.29 ($17.73)
              $50.25 | 0.63%

            
              786
              NEE
              195 (4)
              Sep 26, 2018
              $32,055.09 ($164.39)
              Sep 28, 2018
              $32,648.44 ($167.43)
              $593.35 | 1.85%

            
              783
              UPS
              69 (1)
              Sep 25, 2018
              $8,022.84 ($116.27)
              Sep 28, 2018
              $8,056.82 ($116.77)
              $33.98 | 0.42%

            
              784
              NEE
              144 (3)
              Sep 25, 2018
              $23,995.71 ($166.64)
              Sep 28, 2018
              $24,109.62 ($167.43)
              $113.90 | 0.47%

            
              781
              NEE
              95 (2)
              Sep 24, 2018
              $16,033.20 ($168.77)
              Sep 28, 2018
              $15,905.65 ($167.43)
              ($127.55) | -0.80%

            
              782
              SPG
              45 (1)
              Sep 24, 2018
              $7,952.50 ($176.72)
              Sep 28, 2018
              $7,950.68 ($176.68)
              ($1.82) | -0.02%

            
              777
              NEE
              47 (1)
              Sep 19, 2018
              $7,950.11 ($169.15)
              Sep 28, 2018
              $7,869.11 ($167.43)
              ($81.00) | -1.02%

## 90tka_trades_grouped_september.tsv

          
            Ticker
            Amnt (scale)
            Open date
            O. Price
            Close date
            C. Price
            Profit/Loss

            
              KMI
              1375 (2)
              Sep 26, 2018
              $24,190.60 ($17.59)
              Sep 28, 2018
              $24,379.99 ($17.73)
              $189.39 | 0.78%

            
              UPS
              69 (1)
              Sep 25, 2018
              $8,022.84 ($116.27)
              Sep 28, 2018
              $8,056.82 ($116.77)
              $33.98 | 0.42%

            
              SPG
              136 (2)
              Sep 24, 2018
              $23,927.19 ($175.94)
              Sep 28, 2018
              $24,028.72 ($176.68)
              $101.54 | 0.42%

            
              NEE
              481 (4)
              Sep 19, 2018
              $80,034.12 ($166.39)
              Sep 28, 2018
              $80,532.82 ($167.43)
              $498.70 | 0.62%

            
              TGT
              550 (3)
              Sep 17, 2018
              $47,948.61 ($87.18)
              Sep 25, 2018
              $48,020.34 ($87.31)
              $71.72 | 0.15%

            
              FOXA
              538 (2)
              Sep 18, 2018
              $23,867.98 ($44.36)
              Sep 24, 2018
              $24,204.46 ($44.99)
              $336.48 | 1.41%

            
              COST
              103 (2)
              Sep 14, 2018
              $24,003.29 ($233.04)
              Sep 21, 2018
              $24,173.36 ($234.69)
              $170.07 | 0.71%

            
              DWDP
              697 (3)
              Sep 13, 2018
              $47,643.39 ($68.35)
              Sep 19, 2018
              $47,946.98 ($68.79)
              $303.59 | 0.64%

            
              BAC
              800 (2)
              Sep 12, 2018
              $24,179.66 ($30.22)
              Sep 19, 2018
              $24,848.32 ($31.06)
              $668.66 | 2.77%

## job.list
https://weworkremotely.com/jobs/3115-driven-javascript-node-js-developer
https://angel.co/jan-juna
https://stackoverflow.com/jobs?searchTerm=node.js&type=contract&allowsremote=true
https://www.dropurpin.com/
https://news.ycombinator.com/jobs
http://www.devgurus.io/
https://www.startupjobs.cz/nabidka/6918/node-js-developer?utm_source=facebook&utm_medium=ad-auto&utm_content=6918&utm_campaign=2093
https://www.dropurpin.com/apply-now/
http://x-team.com/
http://www.pracevsiliconvalley.cz/pozice/
	<?php
	/*
	#
	# Trida zajistujici praci s databazi.
	# Pokud se planuje pouziti jine databaze, pak je nutne vytvorit kopii teto tridy s prikazi pro zvolenou
	# databazi, ulozit ji pod nazvem_databaze.class.php
	#
	*/

	class MySQL {
	const arr = [{
	values: [1, 2]
	}, {
	values: [3, 4]
	}];


	const c = arr
	.map((obj) => obj.values)
	.reduce(((all, arr) => [...all, ...arr]), []);
#	Ticker	Amnt (pieces)	Open date	O. Price	Close date	C. Price	Profit/Loss
846	MDT	125 (2)	Dec 26, 2018	$11,072.25 ($88.58)	Dec 27, 2018	$11,176.65 ($89.41)	$104.40 \| 0.94%
844	MDT	66 (1)	Dec 17, 2018	$6,072.34 ($92.01)	Dec 27, 2018	$5,901.27 ($89.41)	($171.07) \| -2.82%
843	WMT	133 (2)	Dec 17, 2018	$12,066.76 ($90.73)	Dec 26, 2018	$12,011.88 ($90.31)	($54.88) \| -0.45%
842	WMT	65 (1)	Dec 14, 2018	$5,968.00 ($91.82)	Dec 26, 2018	$5,870.47 ($90.31)	($97.53) \| -1.63%
837	USB	474 (4)	Dec 10, 2018	$24,004.36 ($50.64)	Dec 26, 2018	$21,471.82 ($45.30)	($2,532.53) \| -10.55%
833	USB	346 (3)	Dec 7, 2018	$17,937.64 ($51.84)	Dec 26, 2018	$15,673.52 ($45.30)	($2,264.12) \| -12.62%
831	USB	228 (2)	Dec 6, 2018	$11,934.52 ($52.34)	Dec 26, 2018	$10,328.22 ($45.30)	($1,606.31) \| -13.46%
830	USB	113 (1)	Dec 4, 2018	$5,951.57 ($52.67)	Dec 26, 2018	$5,118.81 ($45.30)	($832.76) \| -13.99%
845	UNP	130 (3)	Dec 17, 2018	$18,172.00 ($139.78)	Dec 26, 2018	$17,672.04 ($135.94)	($499.95) \| -2.75%
Ticker	Name	Sector	Exchange	Health
ABT	Abbott Laboratories	Health Care	NYSE	+
AMGN	Amgen Inc.	Health Care	NASDAQ	+
EXC	Exelon	Utilities	NYSE	+
FOXA	Twenty-First Century Fox, Inc	Consumer Discretionary	NASDAQ	+
KO	The Coca-Cola Company	Consumer Staples	NYSE	+
LLY	Eli Lilly and Company	Health Care	NYSE	+
MCD	McDonald's Corp	Consumer Discretionary	NYSE	+
MDT	Medtronic Inc.	Health Care	NYSE	+
MRK	Merck & Co.	Health Care	NYSE	+
id	date	kraken_USDTZUSD	kraken_XXLMZUSD	kraken_XXRPZUSD	binance_XRPUSDT	binance_XLMUSDT	binance_TUSDUSDT
1	2018-12-09 18:51:06	0.99700	0.12399	0.31173	0.31350	0.12392	1.00240
2	2018-12-09 18:51:18	0.99700	0.12399	0.31173	0.31355	0.12393	1.00240
	// Binance prices:
	{
	ETHBTC: '0.03121200',
	LTCBTC: '0.00754100',
	BNBBTC: '0.00138310',
	NEOBTC: '0.00224200',
	QTUMETH: '0.01765700',
	EOSETH: '0.02610500',
	SNTETH: '0.00016991',
	BNTETH: '0.00597600',
	// == Client 1 ==
	var socket = require('socket.io-client')('http://localhost');

	const gameInfo = null
	socket.emit('createGame', (createdGame) => {
	gameInfo = createdGame
	})

	socket.on('clientConnected', (clientId) => {
Ticker	Amnt (scale)	Open date	O. Price	Close date	C. Price	Profit/Loss
KMI	1375 (2)	Sep 26, 2018	$24,190.60 ($17.59)	Sep 28, 2018	$24,379.99 ($17.73)	$189.39 \| 0.78%
UPS	69 (1)	Sep 25, 2018	$8,022.84 ($116.27)	Sep 28, 2018	$8,056.82 ($116.77)	$33.98 \| 0.42%
SPG	136 (2)	Sep 24, 2018	$23,927.19 ($175.94)	Sep 28, 2018	$24,028.72 ($176.68)	$101.54 \| 0.42%
NEE	481 (4)	Sep 19, 2018	$80,034.12 ($166.39)	Sep 28, 2018	$80,532.82 ($167.43)	$498.70 \| 0.62%
TGT	550 (3)	Sep 17, 2018	$47,948.61 ($87.18)	Sep 25, 2018	$48,020.34 ($87.31)	$71.72 \| 0.15%
FOXA	538 (2)	Sep 18, 2018	$23,867.98 ($44.36)	Sep 24, 2018	$24,204.46 ($44.99)	$336.48 \| 1.41%
COST	103 (2)	Sep 14, 2018	$24,003.29 ($233.04)	Sep 21, 2018	$24,173.36 ($234.69)	$170.07 \| 0.71%
DWDP	697 (3)	Sep 13, 2018	$47,643.39 ($68.35)	Sep 19, 2018	$47,946.98 ($68.79)	$303.59 \| 0.64%
BAC	800 (2)	Sep 12, 2018	$24,179.66 ($30.22)	Sep 19, 2018	$24,848.32 ($31.06)	$668.66 \| 2.77%
	https://weworkremotely.com/jobs/3115-driven-javascript-node-js-developer
	https://angel.co/jan-juna
	https://stackoverflow.com/jobs?searchTerm=node.js&type=contract&allowsremote=true
	https://www.dropurpin.com/
	https://news.ycombinator.com/jobs
	http://www.devgurus.io/
	https://www.startupjobs.cz/nabidka/6918/node-js-developer?utm_source=facebook&utm_medium=ad-auto&utm_content=6918&utm_campaign=2093
	https://www.dropurpin.com/apply-now/
	http://x-team.com/
	http://www.pracevsiliconvalley.cz/pozice/