phillipwilhelm

Keys for obtaining US Driver's license data

Standard for US Driver's Licenses defines 9 different barcode standards (AAMVA versions) with over 80 different fields encoded inside a barcode. Some fields exist on all barcode standards, other exist only on some. To standardize the API, we have structured the fields in the following sections:

1. Determining AAMVA version
2. Keys existing on all barcode versions
   • Mandatory values
     • Personal data
     • License data
   • Optional values

phillipwilhelm

• Navigating a page with jQuery
  • First lets see how we can select items within the DOM
  • Now we can select elements, let's see how to navigate the DOM
    • jQuery Traversing - Ancestors
      • Traversing Up the DOM Tree
        • jQuery parent() Method
        • jQuery parents() Method
        • jQuery parentsUntil() Method
• jQuery Traversing - Descendants

phillipwilhelm

function main() {
  var payload = {"channel": "bing", "reports": []};
  var date = new Date();
  date.setDate(date.getDate() - 1);
  var yesterday = date.toISOString().split('T')[0];

  var rows = AdsApp.campaigns().forDateRange('YESTERDAY').withCondition('Impressions > 0').get();
  while (rows.hasNext()) {
    var campain = rows.next()
    var row = campain.getStats();

phillipwilhelm

Committing Code

General Rules

• Make atomic commits of changes, even across multiple files, in logical units. That is, as much as possible, each commit should be focused on one specific purpose.
• As much as possible, make sure a commit does not contain unnecessary whitespace changes. This can be checked as follows:

$ git diff --check

phillipwilhelm

Branching

Quick Legend

Description, Instructions, Notes

Instance	Branch

phillipwilhelm

<?php

/**
 * Convert date/time format between `date()` and `strftime()`
 *
 * Timezone conversion is done for Unix. Windows users must exchange %z and %Z.
 *
 * Unsupported date formats : S, n, t, L, B, G, u, e, I, P, Z, c, r
 * Unsupported strftime formats : %U, %W, %C, %g, %r, %R, %T, %X, %c, %D, %F, %x
 *

phillipwilhelm

<div class='menu'>
  <svg class ='basket' width="24" height="24" viewBox="0 0 24 24">
  <path d="M17,18C15.89,18 15,18.89 15,20A2,2 0 0,0 17,22A2,2 0 0,0 19,20C19,18.89 18.1,18 17,18M1,2V4H3L6.6,11.59L5.24,14.04C5.09,14.32 5,14.65 5,15A2,2 0 0,0 7,17H19V15H7.42A0.25,0.25 0 0,1 7.17,14.75C7.17,14.7 7.18,14.66 7.2,14.63L8.1,13H15.55C16.3,13 16.96,12.58 17.3,11.97L20.88,5.5C20.95,5.34 21,5.17 21,5A1,1 0 0,0 20,4H5.21L4.27,2M7,18C5.89,18 5,18.89 5,20A2,2 0 0,0 7,22A2,2 0 0,0 9,20C9,18.89 8.1,18 7,18Z"></path>
</svg>
  <h1> Local storage basket</h1>
</div>
  <div class = 'menu__container'>

</div>

phillipwilhelm

//As referenced in this solution


import { number } from "prop-types";

//https://codepen.io/sosuke/pen/Pjoqqp


interface HSL {
  h: number;

phillipwilhelm

-- split-string-into-rows.sql
-- Duane Hutchins
-- https://www.github.com/duanehutchins
-- Split a string into a mysql resultset of rows
-- This is designed to work with a comma-separated string (csv, SET, array)

-- To use a delimiter other than a comma:
--      Just change all the occurrences of ',' to the new delimiter
--      (four occurrences in SET_EXTRACT and one occurrence in SET_COUNT)

phillipwilhelm

Enhanced onEdit(e) using Google Apps Script

onEdit(e) which is used for the Edit event on Spreadsheet has the old value as e.oldValue. The specifications for this are as follows.

1. When an user edited a single "A1" cell, e of onEdit(e) shows hoge for e.oldValue and fuga for e.value.
2. When an user edited the "A1:A2" multiple cells, e.oldValue and e.value of onEdit(e) are not shown anything.
3. When an user copied and pasted from other cell, e.oldValue and e.value of onEdit(e) are not shown anything.

This sample script was created to retrieve both the edited values and the old values for the range of edited cells. This is the modified e.oldValue.