tradingbills’s gists

tradingbills / gist:c178be3375f86147ec0f3cb4107073d8

Created June 11, 2019 05:02

.babelrc

{"presets":[["@babel/preset-env",{"targets":{"esmodules":true}}]]}

tradingbills / fonts

Last active June 11, 2019 14:19

vim_vim_lib_plugins

	" # Load Plugins

	" Adding and deleting Vim scripts can be tough to manage. If you code in, say, C, you have files for
	" syntax, a filetype detection, plugin features, and more - and all of these files are stored in
	" separate directories along with like files from all of your other plugins. If you want to remove a
	" plugin, you must search all of these directories and delete them manually. What a mess.

	" Load the VIM-Plug package manager.
	runtime plug/plug.vim

tradingbills / vim_lib_keyboardbindings

Last active June 3, 2019 22:06

vimrc

	let NERDTreeShowHidden=1
	let g:user_emmet_leader_key=','
	nnoremap <Leader>q" ciw""<Esc>P
	nnoremap <Leader>q' ciw''<Esc>P
	nnoremap <Leader>qd daW"=substitute(@@,"'\\\\|\"","""","g""")<CR>P
	set splitright
	nmap <F6> :NERDTreeToggle<CR>
	"This allows buffers to be hidden if you've modified a buffer.
	"This is almost a must if you wish to use buffers in this way.
	set hidden

tradingbills / setting.json

Last active June 3, 2019 21:53

	{
	"workbench.editor.showTabs": true,
	"workbench.colorTheme": "Monokai Pro (Filter Spectrum)",
	"workbench.editor.enablePreview": false,
	"workbench.editor.enablePreviewFromQuickOpen": true,
	"editor.minimap.enabled": false,
	"vim.insertModeKeyBindings": [
	{
	"before": ["j", "j"],
	"after": ["<Esc>"]

tradingbills / keyboard bindings

Last active June 3, 2019 04:54

	// Place your key bindings in this file to override the defaultsauto[]
	[
	{
	"key": "ctrl+`",
	"command": "workbench.action.togglePanelPosition"
	},
	{
	"key": "ctrl+l",
	"command": "-expandLineSelection",
	"when": "textInputFocus"

tradingbills / 7.a Signedup and Upgraded in Date RangeItemized by ID.js

Last active March 2, 2018 15:52

Signedup and Paid within dateRange, Itemized who and what

	var collName= 20180302
	// 2018-03-02 00:00:00 to
	// 2018-03-02 23:59:59
	var dateRange= {"$gte":1519948800,"$lte":1520035199}
	var queryDoc; queryDoc.signed_up_at = dateRange

	var paid = "59deb60085a3c22795133b02"
	var free = "59dfe40a0a5037ff1c0bd8af"
	var segPaidOrFree = paid

tradingbills / 11.js

Last active April 19, 2018 20:44

	var collName= 20180419
	// 2018-04-18 00:00:00 to
	// 2018-04-18 23:59:59
	var dateRange= {"$gte":1524009600,"$lte":1524095999}
	var queryDoc11={}; queryDoc11.signed_up_at = dateRange
	// -----------------------------------------------------
	queryDoc11 = undefined
	var queryDoc11= {}, paid = "59deb60085a3c22795133b02", free = "59dfe40a0a5037ff1c0bd8af"
	var useSegId = paid
	queryDoc11= {"last_request_at": dateRange, "segments.segments.id":useSegId}

tradingbills / 10.js

Last active April 19, 2018 20:44

	var collName= 20180419
	/* 2018-04-18 00:00:00 to 2018-04-18 23:59:59 */
	var dateRange= {"$gte":1524009600,"$lte":1524095999}
	// -----------------------------------------------------
	var queryDoc10= {}, paid= "59deb60085a3c22795133b02", free= "59dfe40a0a5037ff1c0bd8af", useSegId = free
	queryDoc10= {"last_request_at": dateRange, "segments.segments.id":useSegId}
	db.getCollection(`${collName}`).aggregate([ { $match: queryDoc10 },{ $group: {_id : null,/* 'Plan Names': { $push: { api_plan_name : "$custom_attributes.api_plan_name", "User email": "$email", "User id": "$user_id" } }, */ "Total no activity" : {"$sum":1} } }
	/* ,{ $project: {_id:0, "Plan Names": "$Plan Names", "Client id" : "$client_id"} } */
	] )

tradingbills / 9.js

Last active April 19, 2018 20:41

	var collName= 20180419
	// 2018-04-18 00:00:00 to
	// 2018-04-18 23:59:59
	var dateRange= {"$gte":1524009600,"$lte":1524095999}
	// -----------------------------------------------------
	var queryDoc09 = {}, segments= {"id": "5a709f20e8a46fcd9c0c5d37", "name": "_HAS ACTIVITY"}
	queryDoc09.last_request_at = dateRange
	queryDoc09["segments.segments.id"] = {$ne:segments.id}
	db.getCollection(`${collName}`).aggregate([ { $match: queryDoc09 }, { "$group": { _id: null,/* 'Plan Names': { $addToSet: { api_plan_name : "$custom_attributes.api_plan_name"}}, */ "Total Non-Activity": {"$sum": 1} } } ])

tradingbills / 8.js

Last active April 19, 2018 20:38

	var collName= 20180419
	// 2018-04-18 00:00:00 to
	// 2018-04-18 23:59:59
	var dateRange= {"$gte":1524009600,"$lte":1524095999}
	// -----------------------------------------------------
	var queryDoc08 = {}, segments = {"id": "5a709f20e8a46fcd9c0c5d37", "name": "_HAS ACTIVITY" }
	queryDoc08.last_request_at = dateRange
	queryDoc08["segments.segments.id"] = segments.id
	db.getCollection(`${collName}`).aggregate([{ $match: queryDoc08 },{ "$group": {_id: null,/* 'Plan Names': { $addToSet: { api_plan_name : "$custom_attributes.api_plan_name"}}, */ "Total Activity": {"$sum": 1} } } ])

Jason Ashley tradingbills