sulfo

<div class="wrapper">
    <h1>Answered Questions</h1>
    <div class="pie-charts">
        <div class="pieID--micro-skills pie-chart--wrapper">
            <h2>Micro-Skills</h2>
            <div class="pie-chart">
                <div class="pie-chart__pie"></div>
                <ul class="pie-chart__legend">
                    <li><em>Additive</em><span>642</span></li>
                    <li><em>Multiplicative</em><span>358</span></li>

sulfo

BigQuery for Google Analytics

No metrics in

Self Joins

• Cross Join example
• Inner Join example

joins can be inefficent - they can require moving lots of data around and increase the data process from n to n * n

sulfo

➜  Homestead git:(eb7477d) vagrant destroy && vagrant up
    homestead-7: Are you sure you want to destroy the 'homestead-7' VM? [y/N] y
==> homestead-7: Destroying VM and associated drives...
==> homestead-7: Pruning invalid NFS exports. Administrator privileges will be required...
Password:
Bringing machine 'homestead-7' up with 'virtualbox' provider...
==> homestead-7: Importing base box 'laravel/homestead'...
==> homestead-7: Matching MAC address for NAT networking...
==> homestead-7: Checking if box 'laravel/homestead' is up to date...
==> homestead-7: Setting the name of the VM: homestead-7

sulfo

find * | egrep "\.env$" | xargs grep INDEX

# thanks jonastanz

sulfo

# Start within ssh
dbexport
logout
homestead halt
vagrant box update
vagrant destory
vagrant up
homestead ssh
dbimport

sulfo

Restore of Mac - Essentials

General

• Chrome (Extensions synced through account)
• Dropbox
• 1Password
• Spotify
• Spark

Utilities

sulfo

# Set the root path (that's our variable not Nginx variable) to the landing page template file
set $rootPath "/map.php";
set $crawlerPath "/map.html";

if ($http_user_agent ~ "Ask Jeeves/Teoma|AdsBot-Google|exabot|Mediapartners-Google|GoogleToolbar|Google Web Preview|googlebot|yahoo|bingbot|baiduspider|facebookexternalhit|twitterbot|rogerbot|linkedinbot|msnbot|embedly|quora link preview|showyoubot|outbrain|pinterest|slackbot|vkShare|W3C_Validator|WebCrawler|Screaming Frog SEO Spider|Slackbot-LinkExpanding|robot|crawler") {
  set $isCrawler 1;
  rewrite ^ $crawlerPath;
}
if ($isCrawler = 0) {
  rewrite ^ $rootPath;

sulfo

–ctrl a c           -> cre­ate new win­dow
–ctrl a A           -> set win­dow name
–ctrl a w           -> show all win­dow
–ctrl a 1|2|3|…   -> switch to win­dow n
–ctrl a ”           -> choose win­dow
–ctrl a ctrl a      -> switch between win­dow
–ctrl a d           -> detach win­dow
–ctrl a ?           -> help
–ctrl a [           -> start copy, move cur­sor to the copy loca­tion, press ENTER, select the chars, press ENTER to copy the selected char­ac­ters to the buffer
–ctrl a ]           -> paste from buffer

sulfo

function cart_notice() {
  $free_shipping_settings = get_option( 'woocommerce_free_shipping_settings' );
  $maximum = $free_shipping_settings['min_amount'];
  $current = WC()->cart->subtotal;
  if ( $current < $maximum ) {
    echo '<div class="woocommerce-message">Get free shipping if you order $ ' . ($maximum - $current) . ' more!</div>';
  }
}
 
add_action( 'woocommerce_before_cart', 'cart_notice' );