Skip to content

Instantly share code, notes, and snippets.

View helanan's full-sized avatar

Helana helanan

View GitHub Profile
@helanan
helanan / nginx-restart.bat
Created March 21, 2018 15:37
Quick startup for NGINX and PHP on Windows
@ECHO OFF
call nginx-stop.bat
call nginx-start.bat
EXIT /b
DENSE_RANK computes the rank of a row in an ordered group of rows and returns the rank as a NUMBER. The ranks are consecutive integers beginning with 1. The largest rank value is the number of unique values returned by the query. Rank values are not skipped in the event of ties. Rows with equal values for the ranking criteria receive the same rank. This function is useful for top-N and bottom-N reporting.
This function accepts as arguments any numeric datatype and returns NUMBER.
As an aggregate function, DENSE_RANK calculates the dense rank of a hypothetical row identified by the arguments of the function with respect to a given sort specification. The arguments of the function must all evaluate to constant expressions within each aggregate group, because they identify a single row within each group. The constant argument expressions and the expressions in the order_by_clause of the aggregate match by position. Therefore, the number of arguments must be the same and types must be compatible.
As an analytic f
@helanan
helanan / index.html
Created December 28, 2016 17:36
SideNav
<div class="sideBar">
<!-- This section gets pushed to the top-->
<div class="sideBar__section">
<div class="sideBar__item is-side-bar-item-selected">Inbox</div>
<div class="sideBar__item">Contacts</div>
<div class="sideBar__item">Account</div>
</div>
<!-- This section gets pushed to the bottom-->
<div class="sideBar__section">
<div class="sideBar__item">Change theme</div>
@helanan
helanan / 3-way-responsive-menu-example.markdown
Created November 21, 2016 16:15
3-way responsive menu example
@helanan
helanan / index.haml
Last active November 3, 2016 15:43
NP Modal Demo
.modal
.header
Did you know?
.content
6.5 million visitors come to our site every year and only 1/3 donate a dollar to our annual giving fund. If every person browsing our site donated $1 we would be able to meet our annual budget and therefore, help to feed more homeless across America!
.actions
%a.success{href: '#'} Donate $1
%a{href: '#'} No Thanks
.loader-bar
.bar
@helanan
helanan / 404-svg-animated-page-concept-for-e-store-zajno-illustrated-by-lina.markdown
Created October 13, 2016 04:50
404 svg animated page concept for e-store @ Zajno (Illustrated by Lina)
@helanan
helanan / instock.js
Last active October 9, 2016 04:54
Create an Object Using Literal Notation
var inStock = {
item: 'T-Shirt',
available: 40,
purchased: 25,
checkStock: function() {
return this.available - this.purchased;
}
};
var elItem = document.getElementById('shirtsInstock');
@helanan
helanan / NPM Cheat Sheet
Created October 6, 2016 06:23
NPM Cheat Sheet (Node Package Manager)
Why use NPM?
Makes it easy for Javascript developers to share the code they've created to solve particular problems and for others to reuse that code in their own applications.
-check to see if they've made updaes and then download those updates
Essentially NPM contains reusable bits of code in either packages or modules.
A package is just a directory with one or more files in it and a file called "package.json" with some meta data about this package.
NPM is a great Javascript resource for 3 main reasons:
1) There are lots of modules on the server side a developer can access
@helanan
helanan / Testing Javascript.carbide.md
Last active August 29, 2016 20:10
Testing Javascript