Automating Your Gruntwork with Javascript- Part 2 (Integration+Model)
This supports a software dev. class for businesspeople that you can find here:
https://www.alexandercowan.com/making-html-manageable
And a case you can find here:
https://www.alexandercowan.com/making-html-manageable
HTML
<script src="https://spreadsheets.google.com/feeds/cells/1DA6htKy-Z-8QRkifkLbzlzG2r5YWOKE77JXEJNmq45g/1/public/values?alt=json-in-script&callback=doData"></script>
<div class="top-bar">
<ul class="nav-list">
<li><a href="#">Home</a></li>
<li><a href="#">Parts</a></li>
<li><a href="#">Search</a></li>
<li><a href="#">Help</a></li>
</ul>
<div id="search-box">
<input type="text" name="parts-search" placeholder="Mfg., Model, or Part Number" size=30>
</div>
</div>
<div id="search-controls">
<div id="result-sort">
Sort By
<select>
<option value="None">Popularity</option>
<option value="Acme">Price</option>
<option value="Bacme">Manufacturer</option>
</select>
</div>
<div id="filter-parts">
Search By
<select id="dd-mfr">
<option value="All">Manufacturer</option>
<option value="Acme">Acme</option>
<option value="Bacme">Bacme</option>
<option value="Cacme">Cacme</option>
<option value="Dacme">Dacme</option>
</select>
<select id="dd-model">
<option value="All">Model</option>
<option value="TooCool">TooCool</option>
<option value="TooHot">TooHot</option>
<option value="JustRight">JustRight</option>
<option value="Coolerator">Coolerator</option>
</select>
<select>
<option value="All">Type</option>
<option value="Sniggler">Sniggler</option>
<option value="Wiggler">Wiggler</option>
<option value="Jiggler">Jiggler</option>
<option value="Tiggler">Tiggler</option>
</select>
</div>
<button type="button" id='search-btn'>Go</button>
</div>
<div id="parts-content" />
CSS
.top-bar, #search-box, .nav-list li, .nav-list a {
background-color: #002D45;
font-family:Proxima Nova,helvetica neue,helvetica,sans-serif;
font-weight: bold;
font-size: 110%;
color: #ffffff;
}
.top-bar {
color: #FFFFFF;
height: 40px;
margin: 0px;
padding: 10px;
display: flex;
align-items: center;
}
.nav-list {
list-style-type: none;
padding: 0;
display: inline;
}
.nav-list li {
float: left;
}
.nav-list a {
display: inline;
padding: 8px;
text-decoration: none;
}
#search-box {
margin-left:auto;
margin-right:0;
padding: 10px;
}
#search-controls {
background-color: #ffffff;
padding: 15px 15px;
font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif;
font-size: 70%;
display: flex;
align-items: center;
}
#filter-parts {
float: right;
margin-left: auto;
margin-right: 0;
padding-right: 5px;
}
.catalog-part {
margin: 2px;
padding: 0px 5px;
float: left;
border-style: solid;
border-color: #808285;
border-width: 1px;
width: 150px;
height: 200px;
line-height: 200px;
display: table-cell;
position: relative;
}
.catalog-part img {
height: auto;
vertical-align: middle;
width: 100%;
}
.overlay {
position: absolute;
top: 0;
bottom: 0;
left: 0;
right: 0;
height: 100%;
width: 100%;
opacity: 0;
transition: .5s ease;
background-color: #f4f4f4;
display: inline-table;
}
.catalog-part:hover .overlay {
opacity: .75;
}
p {
font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif;
line-height: 1;
overflow: scroll;
}
.catalog-part p {
vertical-align: middle;
text-align: center;
color: black;
display: table-cell;
vertical-align: middle;
font-size: 80%;
font-family: 'Lucida Sans Unicode', 'Lucida Grande', sans-serif;
}
JavaScript
///CODE TO PULL IN PARTS
var spData = null;
function doData(json) {
spData = json.feed.entry;
}
function readData($partsContent) {
const startCol = 2;
var data = spData;
var divData = [];
var row = 0;
for (var i = 0; i < data.length; i++) {
var cell = data[i]["gs$cell"];
var val = cell["$t"];
//console.log(val);
if (cell.col == startCol) {
drawDiv(divData, $partsContent, (row == 1));
divData = [];
row++;
}
divData.push(val);
}
drawDiv(divData, $partsContent);
}
function drawDiv(divData, parent, isHeader) {
if (divData == null) return null;
if (divData.length == 0) return null;
if(isHeader) return;
partNum = divData[0];
imgURL = divData[1];
mfr = divData[2];
model = divData[3];
type = divData[4];
price = divData[5];
avail = divData[6];
orders = divData[7];
//Write parts-content div
var $partsDiv = $("<div/>");
$partsDiv.addClass('catalog-part');
$partsDiv.attr( { 'mfr': mfr, 'model':model } );
$partsDiv.prepend($('<img>',{src:imgURL}));
//Write overlay div
var $overlayDiv = $("<div/>");
$overlayDiv.addClass('overlay');
var txt2 = $("<p></p>").html(mfr + " " + partNum + "<br>" + model + "<br>" + orders + " Orders <br>" + price + " " + avail);
$overlayDiv.prepend(txt2);
//Assemble full catalog-par div
$partsDiv.append($overlayDiv);
parent.append($partsDiv);
}
$(document).ready(function () {
readData($("#parts-content"));
///CODE FOR NAVIGATION
$("#search-btn").on("click", function() {
$('.catalog-part').show(); //on new search, start w/ all parts
var selmfr = $('#dd-mfr').find(':selected').val();
console.log("selected mfr " + selmfr); //this just for testing/debugging
if(selmfr=="All") {
//do nothing
} else {
$('.catalog-part').each(function(){
if ($(this).attr('mfr').indexOf(selmfr) < 0) {
$(this).hide();
} else...