Bruce Gust | Sample Code

Below you'll see examples of some of the code that I've either written myself or contributed to. If you have any questions, please feel free to contact me and don't forget to peruse my portfolio at http://www.brucegust.com/portfolio.

Please click on the Verizon logo displayed to the right to see what I contributed during my contract position with Verizon...

Thanks! Kind Words... In short, Bruce proved to be a professional model in every sense of the word. His skills were at the top of his peers and he maintained them through disciplined study, earning him the nickname "hard charger". As an instructional leader, he set standards of professionalism, discipline, and integrity that were beyond reproach. As a team member, he was consistently focused on the goals of leadership and never failed to deliver. As a team leader, he set an example for all to admire, including myself. As a result, many people Bruce touched during his service, attribute him to much of their success. He was indeed an inspirational leader. ...I give Bruce the highest marks in professionalism, leadership and integrity. Knowing his breadth of abilities, his dedication, and his proven success, I would hire him for nearly any position in my organization knowing he'll find a way to win regardless of the obstacles. Ray Dunaway, PMP, CWI Corporate Vice President of Technology Bapcock Power, Louisville, KY (click here to view the entire text)

I've had the pleasure of working with Bruce over the past six months. Bruce is hard-working, dependable and unafraid of a challenge. I hired Bruce to work on a legacy platform as we moved to a new system...Bruce single-handedly maintained three portals for us. He kept the call center portal up and running throughout the six months he was with us. He also made a few much needed enhancements to our client facing portal. The clients were thrilled with the functionality and ease of use...He will be a value add to any organization lucky enough to have him join the team. Kristi Hatchell Director of Operations Patient Focus (click here to view the entire text)

Bruce Gust has worked under my employ for over a year in the position of software development contractor. In that time he has proven himself to be a valuable resource to the team...Bruce is a pleasure to work with due to his personality and all around positive attitude. He interacted directly with internal customers and they were always pleased with the results. Bruce was a remote employee and was always easy to manage. He was responsive to emails and phone calls and I was never concerned about output even though we were at separate locations... I would not hesitate to work with him again. Donald Meador Senior Manager South Area Development at Verizon Wireless (refer to linkedin.com for the full text)

The following is a portion of an email I received after having remedied a dilemma that had been left unresolved for two years. I was asked to take a look at it and see if I couldn't come up with a solution. The problem was a broken link resulting from a number of factors, not the least of which were some security issues that prohibited some docs from being viewed using an http protocol. I was able to create a workaround and here is the response from the Stephanie Horton, Senior Manager of Member and Client Engagement ... I think you deserve a medal for this one, many minds have come and gone and given up! This definitely has the smell of success...Seriously Huge Thank You for working and succeeding! Stephanie Horton Sr. Manager, Member and Client Engagement Applied Health Analytics (refer to linkedin.com for the full text / screenshot)

click here to view more testimonials from both supervisors and clients...

PHP

Object Oriented Programming Most of my work is done in an OOP enviornment. With Verizon, I was asked to code within an original framework that further grouped the various classes beneath the banners of "Model," "View" and "Controller." Very clever, actually. With Patient Focus, again, OOP was the approach, but this time it was constructed within the Code Igniter framework and the syntax was more complicated / verbose. Symbion was primarily procedural PHP, but what made that paradigm unique is that the database was T-SQL and everything was written in PHP, including the Javascript. It was "echo-ed," rather than written as straight Javascript. I didn't include any samples of that work, although I do have that experience documented in the context of some Stored Procedures I wrote in MSSQL Studio. Feel free to look at the samples below. PDF Generator Using JQuery "GET" Upload and Insert of Document & Attachments w/ Email Alert Multi-Dimensional / Associative Arrays and the Scope Resolution Operator (::) GANT Calendar (PDO and Javascript) Verizon Calendar (Procedural and Javascript)

Bootstrap

Responsive Website

CSS

Thornhill Landscaping Media Queries

iPhone

PHP | Object Oriented Programming

Here's a sampling of some of what I've done in an OOP environment... PDF Generator Using JQuery "GET" The dilemma in this instance is that you had several PDFs being generated via several SELECT statements. Because each PDF was several pages long, if the incoming request was for several hundred reports, the system had a tendancy to timeout. The solution was to do things incrementally using some JQuery. The user begins by clicking on a link that triggers the initial SELECT while simultaneously opening up a little "alert" box. This is the class that's looking to see if the user has selected a "Prime" dynamic. If so, then the "print_orders" command is put into position: E) Implementation (back to top...) 1) showOrders.tpl / pap.class.php (back to top...) Your GUI is represented by "showOrders.tpl" which is called by the "pap.class.php" page. On line #5553 - #5558 of the "pap.class.php" page, you've got this: if (stristr($row['ordItemShort'],'prime')) { $laps=round($row['ordQty']/10)+1; // define the number of laps you're going to do based on the $ordQty value $out['printButton'] = "print_forms('".$row['empID']."', '".$row['hID']."', '".$row['ordItemShort']."', '', '".$row['ordID']."', '". $row['ordQty']."','0','".$laps."')"; } else if(stristr($row['ordItemShort'],'survey')) { $out['printButton'] = $printButtonGrowl." xajax_Production.init_genPSM('".$row['empID']."', '".$row['hID']."', '".$row['ordItemShort']."', '', '".$row['ordID']."', '". $row['ordQty']."')"; } What you're looking at is different from the original in that you have some reports that have both "prime" and "survey" in the title. The original code was looking for either "prime" or "survey" ( if (stristr($row['ordItemShort'],'survey') || stristr($row['ordItemShort'], 'prime')) {. With that logic, the "prime" dynamic wasn't being accurately identified. Also, in our prototype we were using a regular link. This is a button so you had to pass the variables in a little differently. In any event... It's putting together the "printButton" that shows up on "showOrders.tpl" which looks like this: {{ IF $printButton}} <div class="UnTip" onmouseover="Tip('Print Order')" style="width: 20px; height: 20px; float: left; cursor: pointer; background: url(../images/layout/icons_dashboard.png) no-repeat -20px -100px;" onclick="{{$printButton}}"></div> {{ ELSE }} <div style="float:left; height:20px; width:20px;"></div> {{ END IF }} Notice, there's either a print button or there's not. Everything is being determined by the "pap.class.php" page. The "print_forms" JQuery function, which is located on the "js.tpl" page (bIQ/common/templates/pap)" looks like this: function print_forms(empID, hID, itemSel, cpID, orderID, quantity, primeID, laps, reps) { $('.centered').show(); $.get('hello.php?empID='+empID+'&hID='+hID+'&item_sel='+itemSel+'&cpID='+cpID+'&orderID='+orderID+'&quantity='+quantity+'&PrimeID='+primeID+'&laps='+laps+'&reps=1', function(data) { $('#gear_text').html(data); }); } The "print_forms" function "shows" the "centered" div and then puts the info coming back from the "hello.php" page into the "gear_text" part of the little window. That HTML / CSS on the "showOrders.tpl" page looks like this:

2) hello.php / pap_print.class.php (back to top...) The "print_forms" command starts by knocking on the door of the "hello.php" page which is going to trigger the "$bob" command which is going to run the init_genPSP function that's housed on the "pap_print.class" page. That particular function is a bear in that it's generating the actual PDF, but here's the piece that was edited so it's only generating 10 documents at a time and is always looking for the PrimeID that's greater than the one being passed into the function. Here's the "hello.php" page:

<?php
require_once(WEBROOT.'lib/functions.php');
require_once(WEBROOT.'xajax/xajax_core/xajax.inc.php');
require_once(WEBROOT.'lib/class/session.class.php');
require_once(WEBROOT.'lib/class/app.class.php');
require_once(WEBROOT.'lib/class/hdap.class.php');
require_once(WEBROOT.'lib/class/channel.class.php');
require_once(WEBROOT.'lib/class/admin.class.php');
require_once('pap.class_print.php');
// init vars and settings
$A = new Application($CN);
$P = new PrintProduction($CN);
$H = new HelpDesk($CN);
$C = new Channel($CN);
$M = new Admin($CN);
$xajax = new xajax();
$xajax->configure("javascript URI", 'xajax/');
$xajax->register(XAJAX_CALLABLE_OBJECT, $A);
$xajax->register(XAJAX_CALLABLE_OBJECT, $P);
$xajax->register(XAJAX_CALLABLE_OBJECT, $H);
$xajax->register(XAJAX_CALLABLE_OBJECT, $C);
$xajax->register(XAJAX_CALLABLE_OBJECT, $M);
$empID=$_GET['empID'];
$hID=$_GET['hID'];
$item_sel=$_GET['item_sel'];
$cpID=$_GET['cpID'];
$orderID=$_GET['orderID'];
$quantity=$_GET['quantity'];
$PrimeID=$_GET['PrimeID'];
$laps=$_GET['laps']-1;
$reps=$_GET['reps'];
$attempt=new PrintProduction($CN);
//usuallly $cpID is NULL by default. It's set to 0 in the context of the JQuery syntax to avoid it throwing an error. For the sake of the "init_genPSM" method, if it's 0, just leave that parameter blank
if($cpID==0)
{
$bob=$attempt->init_genPSP($empID, $hID, $item_sel, '', $orderID, $quantity, $PrimeID, $reps);
}
else
{
$bob=$attempt->init_genPSP($empID, $hID, $item_sel, $cpID, $orderID, $quantity, $PrimeID, $reps);
}
if($laps>0)
{
echo "<script>
$(document).ready(function() {
$.get('hello_again.php?empID=$empID&hID=$hID&item_sel=$item_sel&cpID=$cpID&orderID=$orderID&quantity=$quantity&PrimeID=$bob&laps=$laps&reps=$reps', function(data) {
$('.centered').show();
$('#gear_text').html(data);
});
});
</script>";
}
else
{
$printDate = date('m_d_Y');
$linkPath = '/SecureFileZipper.php?zipLoc=internal/production/' . $printDate . '/primed/' . $orderID;
echo "<script>
$('.centered').show();
$('#gear_text').html('You are all set! <br><br>To access the PDFs you just created, click <a href=\"$linkPath\" target=\"_blank\" style=\"font-size:9pt;\">here</a>.<br><br>Click <a id=\"close_print_window\" href=\"#\" style=\"font-size:9pt;\">here</a> to close this window!');
$('#close_print_window').click(function() {
$('.centered').hide();
});
</script>";
}
?>

On lines #27 - #35, you're grabbing the values that are embedded in the URL coming from the "print_forms" function. The "$reps" value was hardcoded initially as "1" and the "$laps" value was calculated as part of the initial functionality on the "pap.class.php" page. Notice how we're subtracting "1" from the number of laps that have been done. The "$reps" value is for the sake of numbering the PDFs that are being generated as part of the "init_genPSM" function on the "pap_print.class" page. Here's that code:

function init_genPSP($empID_sel=NULL,$hID_sel=NULL,$item_sel=NULL,$cpID_sel=NULL, $orderID=NULL, $quantity=500, $PrimeID, $reps) {
global $S;
global $A;
//$R = new xajaxResponse();
//$R->appendResponse(Application::InitializeClass());
$boom=0;
//$stmt = $this->cn->prepare('SELECT Top 10 PrimeID, rhID FROM Orders_hraResponseHeaders WHERE orderID = :orderID AND PrimeID>:PrimeID ORDER BY PrimeID');
$stmt = $this->cn->prepare('SELECT Top 10 PrimeID, rhID FROM Orders_hraResponseHeaders WHERE orderID = ? AND PrimeID>? ORDER BY PrimeID');
$stmt->execute(array($orderID, $PrimeID));
if($table = $stmt->fetchall(PDO::FETCH_ASSOC))
{
$userTable = array();
foreach($table as $value) {
$lastPrimeID=$value['PrimeID'];
$rhID = $value['rhID'];
$stmt = $this->cn->prepare('SELECT cp.cpID, RIGHT(u.usrSSN, 4) as usrSSN_L4, u.*, r.rhID, e.empName, h.hPID, h.hID, h.hName, c.cmpLogoLrg, c.cmpLogoMed,
c.cmpSignatureImg, c.cmpSignatoryName, c.cmpSignatoryTitle, c.cmpPHRLetter, c.cmpPostSurveyTxt, c.cmpSurveyLegalTxt, c.cmpBioSurveyLegalTxt, c.cmpSurveyLetter_sp,
c.cmpSignatoryTitle_sp, c.cmpSurveyLetter
FROM hraResponseHeaders r INNER JOIN
hraUsers u ON r.usrID = u.usrID INNER JOIN
Employers e ON u.empID = e.empID INNER JOIN
ChannelPartners cp ON e.cpID = cp.cpID INNER JOIN
hraHeaders h ON r.hID = h.hID INNER JOIN
Components c ON cp.cmpID=c.cmpID
WHERE (r.rhID= ?)');
$stmt->execute(array($rhID));
$userTable[]= $stmt->fetchall(PDO::FETCH_ASSOC);
}
//Date for PDF Folder
$pDate = date('m_d_Y');
// Loop through Prime Users and Generate a report.
//Determine the number of orders
$orderCount = sizeof($userTable);
//get the character count for the number of orders so we can use it in padding
$orderCountCharCount = strlen($orderCount);
if($orderCount>0)
{
//you still have rows to process
$new_count=$reps;
for ($i=0; $i < $orderCount; $i++) {
$incrFileName = $orderID.'_'.str_pad($new_count, $orderCountCharCount, '0', STR_PAD_LEFT).'_';
$pdfPath = $this->exe_primeGenPSP($item_sel, $userTable[$i][0], $incrFileName, $orderID, $pDate);
//$R->append('d4', 'innerHTML', '<iframe style="display: none" name="iframe" name="iframe" src="'.$fpath[$i].'"></iframe>');
$new_count=$new_count+1;
}
//kill the connection in order to avoid the chance of timing out...
$stmt=null;
$this->cn=null;
return $lastPrimeID;
}
else
{
//you've reached the end of the line and all of the docs have been processed
}
}
else
{
echo "no";
}
//if there are still more rows to process,
//return $R;
}

On line #9, you've got the SELECT that we're now familiar with thanks to the change that we made on the "pap.class.php" page, as far as grabbing only 10 rows. The $PrimeID is being grabbed from the embedded value in the URL. We get all that information and then on line #50, we kick off the "exe_primeGenPSP" function which is what actually generates the PDFs. On line #46 you see the "$reps" value. We add 10 to that with each lap in order to prevent overwriting the PDFs that have already been completed. When everything is done, we return the "$lastPrimeID" which is the last ID of the row that was processed and we pass that into the "GET" command on line #55 of the "hello.php" page that now has the new $PrimeID in tow as well as the adusted number of $reps and we send that all that to the "hello_again.php" page. 3) hello_again.php (back to top...) The "hello_again.php" page really only has one purpose and that's to give the database connection an opportunity to time out. You'll notice on lines #57 - #58, we're shutting down the connection. This is what ensures that regardless of how many rows we have to process, we don't run the risk of timing things out. The "hello_again.php" page looks like this:

<?php
$empID=$_GET['empID'];
$hID=$_GET['hID'];
$item_sel=$_GET['item_sel'];
$cpID=$_GET['cpID'];
$orderID=$_GET['orderID'];
$quantity=$_GET['quantity'];
$PrimeID=$_GET['PrimeID'];
$laps=$_GET['laps'];
$reps=$_GET['reps']+10;
if($laps>1)
{
echo "<br><br>Stand by! You've only got $laps more laps to go!";
}
else
{
echo "<br><br>Stand by! You've only got $laps more lap to go!";
}
echo "<script>
$(document).ready(function() {
setTimeout(function() {
$.get('hello.php?empID=$empID&hID=$hID&item_sel=$item_sel&cpID=$cpID&orderID=$orderID&quantity=$quantity&PrimeID=$PrimeID&laps=$laps&reps=$reps', function(data) {
$('#gear_text').html(data);
});
}, 3000);
});
</script>";
?>

You're grabbing the needed values on lines #3 - #11 and embedding them into your next "GET" which is going to bounce the process back to the "hello.php" page. You add 10 to the $reps value on line #10, you'll subtract from the $laps value when you get back to the "hello.php" page and you're giving the whole process a 3 second reprieve on line #29. When you get back to the "hello.php" page, you're repeating the process but it's dependent on the number of $laps you've got left which is line #51 of the "pap_print.class" page. Once you're at a point where there are no laps left, you give the user the link to the zip file and provide the function that allows the user to close the window. Upload and Insert of Document & Attachments w/ Email Alert This is a basic syntax that allowed an employee to submit a Project Request.

They would fill out the form the form that you see to the right. When the user hit, "submit" they were routed to a page that began like this: <?php require_once('satellitepageclass.php'); require_once('model_class.php'); //where the ProjectAdmin class was kept require_once('view_class.php'); $page_title="South Area Network Project Insert Page"; $new_page= new SatellitePage; $new_article= new ProjectAdmin; $new_display = new viewProject; $insert=$new_article->project_insert(); // instantiating the project_insert method

class Project Admin {
public function project_insert(){
global $mysqli;
$user_name=$mysqli->real_escape_string(trim($_POST['user_name'])); $email=trim($_POST['email']); $priority=trim($_POST['priority']);
$type=trim($_POST['type']); $department=$mysqli->real_escape_string(trim($_POST['department']));
$description=$mysqli->real_escape_string(trim($_POST['description'])); $name=$mysqli->real_escape_string(trim($_POST['short_name']));
$go_live_date = date('Y-m-d',strtotime($_POST['month'].' '.$_POST['day'].' '.$_POST['year'])); $today=date("Y-m-d");
$attachment_count=0;
$pref_count=0;
$sql="insert into projects (name, email, department, priority, description, requested_by, app_type, date, go_live_date) values ('$name', '$email', '$department', '$priority', '$description', '$user_name', '$type', '$today', '$go_live_date')"; //echo $sql;
if(!$query=$mysqli->query($sql))
{
$err = 'your page_insert query didn\'t work becasue:'
.' ERRNO: '
.$mysqli->errno
.' ERROR: '
.$mysqli->error
.' for this query: '
.$sql
.PHP_EOL;
trigger_error($err, E_USER_WARNING);
}
$novie_id = $mysqli->insert_id;
//check to see if this user is already listed in preferences
$sql_1 = "select id from preferences where email = '$email'";
if(!$query=$mysqli->query($sql_1))
{
$err = 'your preferences query didn\'t work becasue:'
.' ERRNO: '
.$mysqli->errno
.' ERROR: '
.$mysqli->error
.' for this query: '
.$sql
.PHP_EOL;
trigger_error($err, E_USER_WARNING);
}
$pref_count = $query_1->num_rows;
if($pref_count==0)
{
//add user to preferences table
$sql_3 = "insert into preferences (email) VALUES ('$email')";
if(!$query=$mysqli->query($sql))
{
$err = 'your preferences_insert query didn\'t work because:'
.' ERRNO: '
.$mysqli->errno
.' ERROR: '
.$mysqli->error
.' for this query: '
.$sql
.PHP_EOL;
trigger_error($err, E_USER_WARNING);
}
}
$msgText=""; $msgText .= "height:800px; border: 1px solid #cccccc;\">
style=\"font-family:Helvetica; font-size:12px; color:#ffffff; text-align:right; vertical-align:middle;
font-weight:bold; width:370px;\">Project Request Form; $msgText .=date("l - F jS, Y");
$msgText .="background-color:#8f9293;\">
style=\"border-spacing: 0; border-collapse: collapse;\">
font-size:32px; color:#ffffff;\"> South Area Network
style=\"background-color:#000000;\">
font-family:Helvetica; font-size:12px; color:#000000; height:674px; vertical-align:top;
padding:10px;\"> A project request has been submitted. Below are some of the details. To view the entire
Project Request, login to the South Arean Network Admin Page.Project Name: ";
$msgText .=$_POST['short_name']; $msgText.="<br><hr><br>Requested By: ";
$msgText .=$_POST['user_name']; $msgText.="<br><hr><br"; if($_POST['priority']==1) {
$priority="urgent"; } elseif($_POST['priority']==2) { $priority=="high"; }
elseif($_POST['priority']==3) { $priority="medium"; } elseif($_POST['priority']==4) { $priority="low"; }
elseif($_POST['priority']==5) { $priority="very low"; } $msgText.="Priority: "; $msgText .=$priority;
$msgText.="<br><hr><br>"; $msgText .="go live date: "; $msgText .=date("m/d/Y",
strtotime($go_live_date)); $msgText .="<br><hr><br>"; $msgText .=nl2br($_POST['description']); $msgText
.="
style=\"font-family:Helvetica; font-size:9px; color:#000000; text-align:center;\">©Verizon Wireless |
South Area | All Rights Reserved |
href=\"http://southareanetwork.nss.vzwnet.com/page.php?page_id=8\" style=\"font-family:Helvetica; font-size:9px;/">Contact</a>";
$toText="Donald.Meador@VerizonWireless.com";
//$toText="bruce.gust@VerizonWireless.com"; $ccText="bruce.gust@VerizonWireless.com"; $fromText = $_POST['email'];
$subjectText="new project request from "; $subjectText .=$fromText; $header = "From:
".$fromText."\r\n"; $header .= "Cc: ".$ccText."\n"; $header .= "Reply-To : ".$fromText."\r\n"; $header
.= "Return-Path : ".$fromText."\r\n"; $header .= "X-Mailer: PHP\r\n"; $header .=
"MIME-Version: 1.0\r\n"; $header .= "Content-Type: text/html; charset=ISO-8859-1\r\n"; //
ini_set(sendmail_from,$fromText); $postoffice=mail($toText, $subjectText, $msgText, $header, '-f'.$fromText);
return($novie_id); }
}

Please feel free to click on the "paint bucket" to view a more legible version of the code!

lines 1-7 clean up the data
lines 10-22 insert the data
line 23 grabs the insert id that will be used to update the row we just entered if there's an attachment associated with it
line 25 looks to see if user is currently listed in the preferences table. The preferences table stored all user data pertaining to their favorite tools and the corresponding links along with any Project Requests that had on file
line 38 looks to see how many rows were returned by the previous SELECT statement and if none were registered, then the user was added to the preferences table
lines 57 - 84 send an email out to the Regional Manager, alerting them to a new Project in the project table that includes a link to the project itself
line 85 returns the INSERT ID which will be used to "link" any attachments that go along with this Project Request to the Request itself

The next step is to handle any attachments the user may have included in their request. First, you have the instantiation of the method depending on whether or not anything was sent via the form. if(isset($_FILES['attachment_1'])&& !empty($_FILES['attachment_1']['name'])) { $attachment_upload_1=$new_article->attachment_upload_1($insert); $attachment_count=1; } You can see the attachment_upload method below.

public function attachment_upload_1($insert) {
global $mysqli;
$novie_id=$insert;
if(isset($_FILES['attachment_1'])&&!empty($_FILES['attachment_1']['name']))
{
$pathinfo = pathinfo($_FILES['attachment_1']['name']);
$new_name =$pathinfo['filename'].'_'.$novie_id.'.'.$pathinfo['extension']; $base_directory= "attachments/";
$target = $base_directory.''.$new_name; $url =$new_name; $uploadOk=1; $fileParts = pathinfo( $url );
$extension = $fileParts['extension'];
if($extension=="jpg" OR $extension=="jpeg" OR $extension=="JPG" OR $extension=="GIF" OR $extension=="gif" OR $extension=="PNG" OR $extension=="png" OR $extension=="doc" OR $extension=="docx" or $extension=="pdf" OR $extension=="xls" OR $extension=="xlsx" OR $extension=="ppt" OR $extension=="pptx" OR $extension=="txt" OR $extension=="pub" OR $extension=="wps" or $extension=="bmp" OR $extension=="BMP" OR $extension=="csv")
{
$uploadOk = 1;
}
else
{
$uploadOk = 0;
header("Location:project_badfile.php");
exit();
}
if(!move_uploaded_file($_FILES['attachment_1']['tmp_name'], $target))
{
header("Location: http://southareanetwork.nss.vzwnet.com/project_no_upload.php");
exit();
}
else
{
$sql_10 = "insert into attachments (project_id, url) values ('$novie_id', '$url')";
if(!$query_10=$mysqli->query($sql_10))
{
$err_10='your attachments info didn\'t get uploaded becasue:'
. 'ERRNO: '
.$mysqli->errno
. 'ERROR: '
.$mysqli->error
. 'and the query itself looks like this: '
.$sql_10
.PHP_EOL;
trigger_error($err_2, E_USER_NOTICE);
}
}

Basically, you're just uploading the file and, if the upload was successful, you insert the file name along with its URL and its corresponding project_id into the "attachments" table. Multi-Dimensional / Associative Arrays and the Scope Resolution Operator (::) With this particular contract, I was asked to come in and troubleshoot some code. Below is an example of some syntax I worked with that illustrates my familiarity with multi-dimensional /associative arrays. In the code below, you're seeing a SQL SELECT statement arriving as an array that is then broken up using a "for" loop. The purpose of what you're seeing below was to run through an array and look for "groups" of data based on their dates. Everything that constitutued a group was "pushed" into a sub array. Take a look: Line #31:$timeline = AccountTimelines::getAccountTimeline($accountid); - Here's an example of the double colon, or "Scope Resolution Operator Line #35-36: $event = $timeline[$i]; - This is saying to PHP, "Take the value of $i and use it as an array index into the $timeline array. Get the contents of that array position and assign it to the $event variable. Do this over and over again until the value of $i is equal to the number of elements in the $timeline array." Line #41: array_push($txnGroup, $event); - Here's an example of a subarray being pushed into the empty $txnGroup array

public function accounttimeline($accountid = null)
{
if (isset($_REQUEST['preview']) && $_REQUEST['preview']) {
return;
}
if (isset($_REQUEST['searchfor'])) {
$return['json'] = Accounts::timelinesearch($_REQUEST['searchfor']);
if ($return['json']) {
$return['success'] = 1;
if (count($return['json'])>1) {
$return['body'] = $this->load->view('/app/templates/accounttimeline/searchresults', $return, true);
} else {
$return['body'] = "There should be a loaded account now";
$return['loadAccount'] = $return['json'][0]['clientcode']
. '-' . $return['json'][0]['practicecode']
. '-' . $return['json'][0]['practicepatientid'];
}
} else {
$return['success'] = 1;
$return['body'] = "There are no results to display. Please refine your search.";
}
echo json_encode($return);
return;
}
$ud=setUserData();
$data = pf::getAppData('/app/accounttimeline');
$accountid = isset($_REQUEST['accountkey']) ?Accounts::getAccountFromNewAccountID($_REQUEST['accountkey']):(isset($_REQUEST['accountid'])?$_REQUEST['accountid']:$accountid);
if ($accountid !== null) {
$data['badge'] = Accounts::getBadge($accountid);
$timeline = AccountTimelines::getAccountTimeline($accountid);
$data['timeline'] = array();
$txnGroup = array();
for ($i=0; $i < count($timeline); $i++) {
$event = $timeline[$i];
$event['demo'] = ($data['badge']['practiceid'] == '63'?$accountid : false);
if ($event['eventtype']=='transaction') {
$thisDate = Date('mdy', strToTime($event['eventdate']));
$nextDate = (isset($timeline[$i+1])&&$timeline[$i+1]['eventtype']=='transaction')?Date('mdy', strToTime($timeline[$i+1]['eventdate'])):null;
array_push($txnGroup, $event);
if ($thisDate != $nextDate) {
//add to data
if (count($txnGroup)!=1) {
array_push($data['timeline'], array(
'eventdate'=>Date('m/d/Y', strToTime($event['eventdate'])),
'eventtype'=>'transactions',
'runningbal'=>$event['runningbal'],
'transactions'=>$txnGroup
));
} else {
array_push($data['timeline'], $event);
}
$txnGroup = array();
}
} else {
if ($event['eventtype'] == 'statement') {
$event['dir'] = "/p/" . (ENVIRONMENT === 'production' ? 'prod' : 'dev') . "/statements/$event[exportid]/";
$event['file'] = "$event[accountid]-$event[content].pdf";
}
array_push($data['timeline'], $event);
}
}
$data['timeline'] = array_reverse($data['timeline']);
}
$ci =& get_instance();
$ci->template->app2Load('app/templates/accounttimeline/body', $data);
}

GANT Calendar The GANT Calendar project was assigned to me in order to visually display what projects were being assigned and how their various due dates and projected timeframes overlapped. It looked like what you see to the right (feel free to click on the image to get a larger view). Because the DEV team had within its ranks both PHP developers and .NET developers, the database that had to be interacted with was a T-SQL database. Hence, all the queries had to be Stored Procedures and the database connection was a PDO configuration. I worked with my counterpart to put the whole thing together. She crafted the Stored Procedures and I assembled and displayed the data. The first two elements are the sliding carousels that give the user the opportunity to focus in on either a specific day or month. This was facilitated using the Owl Carousel" JQuery Plugin. The calendar itself is a large table. Each column represents a period of seven days, with each day being a cell. In my header, I use today's date as my starting point and then work my way both to the left and the right to "fill in" the weeks that will be displayed. For the sake of brevity, here's the primary SELECT as it was facilitated using a PDO configuration in order to connect with the T-SQL database and then execute the Stored Procedures on the server:

$query = "EXECUTE stp_Select_REPORT_DevelopeProjects_Gantt :DataDisplay_Start, :DataDisplay_End"; $stpro = $mssql_pdo->prepare($query); $stpro->bindParam(':DataDisplay_Start', $week_one, PDO::PARAM_STR); $stpro->bindParam(':DataDisplay_End', $week_twelve, PDO::PARAM_STR); // call the stored procedure $stpro->execute(); $results = $stpro->fetchALL(PDO::FETCH_ASSOC); If you would like to see more of the code in detail, click on the paint bucket... Verizon Calendar

The Verizon Calendar - at one point I was asked to basically deconstruct the google calendar and create an interface where engineers could document events that had compromised Verizon's coverage. The resulting app was something I was kind of proud of. There were places I incorporated a procedural approach within an OOP dynamic which may be poisonous in the minds of some, but it was the most direct way in which I could solve some of the "logic" that needed to be addressed as far as how things were displayed etc. I've got some code samples documented below, but be sure to click on the graphic to the right which will connect you to a working model. There were several challenges to overcome when given the inital "specs." The actual calendar "scaffolding" was basic enough, but then to generate specific Javascript code based on the states and regions that were displayed was a little cumbersome - especially given the fact that you had to set the visibility of the regions to "hidden" when working with the states dynamic and vice versa when the user started working with the regions. Some of the code was static, but here's the function that generated the Javascript for the states...

function javascript_commands($content, $number)
{
$page_display=func_get_arg(0);
$the_number=(func_get_arg(1)-1);
//echo $the_number;
$the_count=1;
$java_count=0;
$java_state="";
$briefcase="";
$current_state="";
$the_state="";
$briefcase.="var queue={};\n";
if(isset($_GET['state'])&&!$_GET['state']=="")
{
$briefcase.="queue.";
if($_GET['state']=="North Carolina")
{
$briefcase.="North_Carolina";
}
elseif($_GET['state']=="South Carolina")
{
$briefcase.="South_Carolina";
}
else
{
$briefcase.=$_GET['state'];
}
$briefcase.="=true;";
}
foreach($page_display as $page)
{
if($current_state<>$page['state'])
{
$briefcase.="function ";
if(stripslashes($page['state'])=="North Carolina")
{
$briefcase.="North_Carolina";
}
elseif(stripslashes($page['state'])=="South Carolina")
{
$briefcase.="South_Carolina";
}
else
{
$briefcase.=stripslashes($page['state']);
}
$briefcase.="()\n{\n";
$briefcase.="if(Object.size(the_queue)>0)\n{\n";
$briefcase.="delete the_queue.CATN;\n";
$briefcase.="delete the_queue.CATN;\n";
$briefcase.="delete the_queue.FL;\n";
$briefcase.="delete the_queue.CTX;\n";
$briefcase.="delete the_queue.HGC;\n";
$briefcase.="delete the_queue.GAAL;\n";
$briefcase.="delete the_queue.SCTL;\n";
$briefcase.="delete the_queue.AREA;\n";
$briefcase.="delete the_queue.ALU;\n";
$briefcase.="delete the_queue.DEVICE;\n";
$briefcase.="delete the_queue.CATN_long;\n";
$briefcase.="delete the_queue.FL_long;\n";
$briefcase.="delete the_queue.CTX_long;\n";
$briefcase.="delete the_queue.HGC_long;\n";
$briefcase.="delete the_queue.GAAL_long;\n";
$briefcase.="delete the_queue.SCTL_long;\n";
$briefcase.="delete the_queue.AREA_long;\n";
$briefcase.="delete the_queue.ALU_long;\n";
$briefcase.="delete the_queue.DEVICE_long;\n";
$briefcase.="}\n";
$briefcase.="$(\".CATN,.FL,.CTX,.HGC,.GAAL,.SCTL,.AREA,.ALU,.DEVICE, .CATN_long,.FL_long,.CTX_long,.HGC_long,.GAAL_long,.SCTL_long,.AREA_long,.ALU_long,.DEVICE_long\").show();\n";
$briefcase.="queue.";
if(stripslashes($page['state'])=="North Carolina")
{
$briefcase.="North_Carolina";
}
elseif(stripslashes($page['state'])=="South Carolina")
{
$briefcase.="South_Carolina";
}
else
{
$briefcase.=stripslashes($page['state']);
}
$briefcase.="=true;\n";
//right here you're doing a little test to ensure that you've got more than one state. Otherwise, the Javascript breaks
foreach($page_display as $display)
{
if($java_state<>$page['state'])
{
$java_count=$java_count+1;
}
}
//echo $java_count;
//java_count represents the number of states you've got on this month. You'll compose only a portion of the Javascript command below if you only have one state. Otherwise, you're going to get an error
if($java_count>1)
{
$briefcase.="$(\"";
foreach($page_display as $display)
{
if($the_state=="")
{
$the_state==$page['state'];
}
if($the_state<>$current_state)
{
$briefcase.=".";
if(stripslashes($display['state'])=="North Carolina")
{
$briefcase.="North_Carolina";
}
elseif(stripslashes($display['state'])=="South Carolina")
{
$briefcase.="South_Carolina";
}
else
{
$briefcase.=stripslashes($display['state']);
}
if($the_count<$the_number)
{
$briefcase.=",";
}
else
{
$briefcase.="\").hide();";
}
$the_count=$the_count+1;
}
$the_state=$display['state'];
}
}
$briefcase.="\n\n";
$briefcase.="for( var state in queue)";
$briefcase.="\n{\n$(\".\" + state).show();\n}\n";
$briefcase.="return true;\n";
$briefcase.="}\n";
}
$the_count=$count=1;
$current_state=$page['state'];
}
return $briefcase;
}

One of the bigger "brain-benders" for me was to figure out a way to display all of the events correctly as the user scanned any one week from left to right. I had to figure out which day had the greatest concentration of activity and then configure the rest of the week according to a "staircase" look. It makes more sense when you see it. But to get to that point, I wound up creating a separate table for each week, or each "row" of the calendar. Here's what the third week - or row - would look like: First, make sure you've got data:

if($row_number==3 AND $table_row_three>0)
{
$current_event_2="";
for($d=1; $d<=$table_row_three; $d++)
{
?>
<tr style="height:16px; width:auto;">
<td>
<?php
$korbin="SELECT * FROM `calendar_sequence_third` WHERE end_date>= '$the_date' AND date<= '$the_date' and sequence='$d'";
//echo $korbin;
$korbin_query=mysqli_query($mysqli, $korbin);
$korbin_count=mysqli_num_rows($korbin_query);
if($korbin_count>0)
{
$korbin_row=mysqli_fetch_assoc($korbin_query);
if($current_event_2<>$korbin_row['event_id'])
{
//in order to display the proper start date for events that span multiple days, you've got to find the first day of that sequence
$kathy="select date from calendar where event_id='$korbin_row[event_id]' ORDER by date ASC LIMIT 1";
$kathy_query=mysqli_query($mysqli, $kathy);
$kathy_row=mysqli_fetch_assoc($kathy_query);
$start_date_3=$kathy_row['date'];
include('row_three_script_long.php');
$current_event_2=$korbin_row['event_id'];
}
}
$kevin="SELECT * FROM `calendar_sequence_third` WHERE date='$the_date' and end_date='0000-00-00' and sequence='$d'";
//echo $kevin;
$kevin_query=mysqli_query($mysqli, $kevin);
$kevin_count=mysqli_num_rows($kevin_query);
if($kevin_count>0)
{
//echo $kevin;
$kevin_row=mysqli_fetch_assoc($kevin_query);
include('row_three_script.php');
}
if($kevin_count==0 AND $korbin_count==0)
{
echo " ";
}

Once that's established, the next thing is to set up the formatting and the overall aesthetics and this is how that looks. Again, feel free to click on the "paint bucket" to see an easier-to-read version of the code.

<?php
$briefcase_5="";
$briefcase_5.="<div class=\"";
//make sure that this isn't repeating an event that's already been listed
if($korbin_row['date']<=$the_date)
{
if($korbin_row['region']=="ALU")
{
$briefcase_5.="ALU_long";
}
if($korbin_row['region']=="AREA")
{
$briefcase_5.="AREA_long";
}
if($korbin_row['region']=="CATN")
{
$briefcase_5.="CATN_long";
}
if($korbin_row['region']=="CTX")
{
$briefcase_5.="CTX_long";
}
if($korbin_row['region']=="DEVICE")
{
$briefcase_5.="DEVICE_long";
}
if($korbin_row['region']=="ERC")
{
$briefcase_5.="ERC_long";
}
if($korbin_row['region']=="FL")
{
$briefcase_5.="FL_long";
}
if($korbin_row['region']=="GAAL")
{
$briefcase_5.="GAAL_long";
}
if($korbin_row['region']=="HGC")
{
$briefcase_5.="HGC_long";
}
if($korbin_row['region']=="SCTL")
{
$briefcase_5.="SCTL_long";
}
}
$briefcase_5.="\">";
$briefcase_5 .="<div class=\"";
if(stripslashes($korbin_row['state'])=="North Carolina")
{
$briefcase_5.="North_Carolina";
}
elseif(stripslashes($korbin_row['state'])=="South Carolina")
{
$briefcase_5.="South_Carolina";
}
else
{
$briefcase_5.=stripslashes($korbin_row['state']);
}
$briefcase_5.="\">";
//$briefcase_5.=$korbin_row['event_id'].' - ' .$korbin_row['date'];
$briefcase_5.=" <a href=\"#\" onclick=\"javascript:void window.open('event_description.php?id=";
$briefcase_5.=$korbin_row['id'];
$briefcase_5.="','1435862141298','width=610,height=560,toolbar=0,menubar=0,location=0,status=0,scrollbars=0,resizable=1,left=0,top=0');return false;\" class=\"";
//here you've got to determine if this date is the initial date of a multi day event, or if it's part of a succession. If so, you don't want to display the text. The other thing you need to look at
//is the day. If it's Sunday, you need to display the text and if it's the first day of the month, you need to display the text
$day_of_week=date("l", strtotime($the_date));
//$date_of_month=date("d", strtotime($korbin_row['date']));
if($day_of_week=="Sunday" OR date("d", strtotime($the_date))==01 OR $korbin_row['date']==$the_date)
{
if($korbin_row['region']=="ALU")
{
$briefcase_5.="tooltip_date_ALU_long";
$text_style="ALU";
}
if($korbin_row['region']=="AREA")
{
$briefcase_5.="tooltip_date_AREA_long";
$text_style="AREA";
}
if($korbin_row['region']=="CATN")
{
$briefcase_5.="tooltip_date_CATN_long";
$text_style="CATN";
}
if($korbin_row['region']=="CTX")
{
$briefcase_5.="tooltip_date_CTX_long";
$text_style="CTX";
}
if($korbin_row['region']=="DEVICE")
{
$briefcase_5.="tooltip_date_DEVICE_long";
$text_style="DEVICE";
}
if($korbin_row['region']=="ERC")
{
$briefcase_5.="tooltip_date_ERC_long";
$text_style="ERC";
}
if($korbin_row['region']=="FL")
{
$briefcase_5.="tooltip_date_FL_long";
$text_style="FL";
}
if($korbin_row['region']=="GAAL")
{
$briefcase_5.="tooltip_date_GAAL_long";
$text_style="GAAL";
}
if($korbin_row['region']=="HGC")
{
$briefcase_5.="tooltip_date_HGC_long";
$text_style="HGC";
}
if($korbin_row['region']=="SCTL")
{
$briefcase_5.="tooltip_date_SCTL_long";
$text_style="SCTL";
}
}
else
{
if($korbin_row['region']=="ALU")
{
$briefcase_5.="tooltip_date_ALU";
$text_style="area";
}
if($korbin_row['region']=="AREA")
{
$briefcase_5.="tooltip_date_AREA";
$text_style="AREA";
}
if($korbin_row['region']=="CATN")
{
$briefcase_5.="tooltip_date_CATN";
$text_style="CATN";
}
if($korbin_row['region']=="CTX")
{
$briefcase_5.="tooltip_date_CTX";
$text_style="CTX";
}
if($korbin_row['region']=="DEVICE")
{
$briefcase_5.="tooltip_date_DEVICE";
$text_style="DEVICE";
}
if($korbin_row['region']=="ERC")
{
$briefcase_5.="tooltip_date_ERC";
$text_style="ERC";
}
if($korbin_row['region']=="FL")
{
$briefcase_5.="tooltip_date_FL";
$text_style="FL";
}
if($korbin_row['region']=="GAAL")
{
$briefcase_5.="tooltip_date_GAAL";
$text_style="GAAL";
}
if($korbin_row['region']=="HGC")
{
$briefcase_5.="tooltip_date_HGC";
$text_style="HGC";
}
if($korbin_row['region']=="SCTL")
{
$briefcase_5.="tooltip_date_SCTL";
$text_style="SCTL";
}
}
//right here you're going to put your search stylings...
if(isset($_GET['search'])&&$_GET['search']==$korbin_row['event_id'])
{
$briefcase_5.="\" style=\"background-color:#ecfa05; color:#000000;\">";
}
else
{
$briefcase_5.="\">";
}
$position = 10;
$message = $korbin_row['short_name'];
$post = substr($message,$position,1);
if($post !=" ") {
$length = strlen( $message );
while($post !=" " && $position < $length){
$b =1;
$position = $position+$b;
$post = substr($message,$position,1);
}
}
$post = substr($message,0,$position);
if(strlen($post)>10)
{
$briefcase_5.=stripslashes($post).'...';
}
else
{
$briefcase_5.=stripslashes($post);
}
//$briefcase_5.=$korbin_row['id'];
$briefcase_5.="<span><img class=\"callout_area\" src=\"images/callout.gif\" alt=\"callout\" /><b>";
$briefcase_5.=date("n/j/Y", strtotime($start_date_3)).' - '.date("n/j/Y", strtotime($korbin_row['end_date']));
$briefcase_5.="</b><div style=\"float:right;\"><div class=\"";
$briefcase_5.=$text_style;
$briefcase_5.="\">";
$briefcase_5.=stripslashes($korbin_row['state']).' | '.stripslashes($korbin_row['region']);
$briefcase_5.="</div></div><br><br><u>";
$briefcase_5.=stripslashes($korbin_row['short_name']);
$briefcase_5.="</u><br>";
$position_1 = 100;
$message_1 = $korbin_row['description'];
$post_1 = substr($message_1,$position_1,1);
if($post_1 !=" ") {
$length_1 = strlen( $message_1 );
while($post_1 !=" " && $position_1 < $length_1){
$a =1;
$position_1 = $position_1+$a;
$post_1 = substr($message_1,$position_1,1);
}
}
$post_1 = substr($message_1,0,$position_1);
if(strlen($post_1)>10)
{
$briefcase_5.=stripslashes($post_1).'...';
}
else
{
$briefcase_5.=stripslashes($post_1);
}
$briefcase_5.="</span>
</a><br></div>";
$briefcase_5.="</div>";
echo $briefcase_5;
?>

Bootstrap

Responsive Website Click here to view the Bootstrap version of the Verizon website I built for their South Regional Territory.

CSS

The big priority these days with CSS is to ensure that your site is responsive to the type of devices that are being potentially used by your users. If they're on their desktop with a large monitor, that will be one kind of "look." On the other hand, if they're on their phone, the CSS will need to accommodate that scenario and display graphics and navigation that's appropriate to that size. Thornhill Landscaping Here's an example of what I did for "Thornhill Landscaping:"

body {
font-family: Helvetica, Microsoft Sans Serif;
font-size: 12px;
color: #000000;
vertical-align: top;
padding: 0px;
height: 100%;
width:768px;
margin:auto;
background-color:#101214;
}
#main_menu {
width:768px;
height:1024px;
margin:auto;
text-align:center;
background-image:url(images/menu_768.png);
background-repeat:no-repeat;
}
#main_menu_about {
position:absolute;
margin-left:45px;
margin-top:200px;
width:683px;
height:70px;
background-image:url(images/spacer.gif);
background-repeat:no-repeat;
z-index:100px;
}
#main_menu_visitors {
position:absolute;
margin-left:45px;
margin-top:300px;
width:683px;
height:70px;
z-index:100px;
}
#main_menu_ministries {
position:absolute;
margin-left:45px;
margin-top:410px;
width:683px;
height:70px;
z-index:100px;
}
#main_menu_children {
position:absolute;
margin-left:45px;
margin-top:510px;
width:683px;
height:70px;
z-index:100px;
}
#main_menu_calendar {
position:absolute;
margin-left:45px;
margin-top:610px;
width:683px;
height:70px;
z-index:100px;
}
#main_menu_contact {
position:absolute;
margin-left:45px;
margin-top:709px;
width:683px;
height:70px;
z-index:100px;
}
#main_menu_email {
position:absolute;
margin-left:335px;
margin-top:870px;
width:253px;
height:28px;
z-index:100px;
}
#main_menu_signature {
position:absolute;
margin-left:295px;
margin-top:945px;
width:168px;
height:65px;
z-index:100px;
}
#main_social_facebook {
position:absolute;
margin-left:628px;
margin-top:55px;
width:16px;
height:32px;
z-index:100px;
}
#main_social_twitter {
position:absolute;
margin-left:660px;
margin-top:55px;
width:20px;
height:32px;
z-index:100px;
}
#main_social_email {
position:absolute;
margin-left:690px;
margin-top:55px;
width:35px;
height:32px;
z-index:100px;
}
#header_divider {
width:100%;
margin:auto;
height:10px;
background-color:#28368f;
}
#footer {
width:480px;
margin:auto;
font-family: Helvetica, Microsoft Sans Serif;
font-size: 10px;
color: #ffffff;
text-align:center;
padding-top:5px;
}
#title {
height:38px;
}
#contact_images {
padding-top:7px;
width:320px;
margin:auto;
}

Media Queries Here's the remainder of the stylesheet that accommodates the landscape and portrait views of a mobile phone...

@media screen and (max-width:480px)
{
body {
font-family: Helvetica, Microsoft Sans Serif;
font-size: 12px;
color: #000000;
vertical-align: top;
padding: 0px;
height: 100%;
width:320px;
margin:auto;
background-color:#101214;
}
#main_menu {
width:768px;
height:1024px;
margin:auto;
text-align:center;
background-image:url(images/menu_320.png);
background-repeat:no-repeat;
}
etc...
}
@media screen and (max-width:320px)
{
body {
font-family: Helvetica, Microsoft Sans Serif;
font-size: 12px;
color: #000000;
vertical-align: top;
padding: 0px;
height: 100%;
width:320px;
margin:auto;
background-color:#101214;
}
#main_menu {
width:768px;
height:1024px;
margin:auto;
text-align:center;
background-image:url(images/menu_320.png);
background-repeat:no-repeat;
}
#main_menu_about {
position:absolute;
margin-left:15px;
margin-top:123px;
width:282px;
height:27px;
z-index:100px;
}

This is a portion of the stylesheet used with the brucegust.com page. Here you see an example of what is done when your magnificent, full screen dynamic is suddenly being accessed by a lap top and threatens to cram your gorgeous vista into a tiny little portal. By using @media screen and (min-width: 1000px), we keep the title graphic from looking like the designer made a tragic mistake.

body {
font-family: Helvetica, Microsoft Sans Serif;
font-size: 14px;
color: #000000;
vertical-align: top;
padding: 0px;
height: 100%;
width: 100%;
margin: 0;
background-color:#000000;
}
#top_graphics {
height:227px;
}
#qr_container {
width:320px;
position:relative;
margin-left:-5px;
}
table.qr_code {
width:329px;
}
#phone_background {
width:332px;
height:500px;
position:relative;
background-image:url(images/phone_background.png);
background-repeat:no-repeat;
margin:auto;
}
@media screen and (min-width: 1000px)
{
#left-container {
z-index:3;
position:absolute;top:0;
height:227px;
width:295px;
float:left;
background-image:url(images/1000_header_01.gif);
background-repeat:no-repeat;
}
#brucegust {
position:absolute;top:0;
height:227px;
width:295px;
float:left;
}
}
#top_filler {
height:227px;
background-image:url(images/header_02.jpg);
background-repeat: repeat-x;
}

Stored Procedures

Symbion Healthcare Working with the SQL Management Studio, here are some of the queries I wrote:

USE
[BIProd]
GO
/****** Object: StoredProcedure [dbo].[cer_CapXTempSave] Script Date: 5/29/2014 3:26:06 PM ******/
SET
ANSI_NULLS
ON
GO
SET
QUOTED_IDENTIFIER
ON
GO
ALTER PROCEDURE [dbo].[cer_CapXTempSave]
--Parms for stored procedure
@capxtempid as int,
@cermodelid as int,
@capxid as int,
@spmodelid as int,
@assettypeid as int,
@totalcost as int ,
@description as varchar(150),
@shortname as varchar(150),
@allocatedamount as int,
@userid as int
AS
BEGIN
declare @key as int
declare @ErrorMessage as varchar(300)
declare @ErrorNo as int
set @ErrorMessage = ''
set @ErrorNo = 0
declare @cer_itemcost int
select @cer_itemcost = ISNULL(itemcost,0) from cer_Detail where cermodelid= @cermodelid
declare @cer_itemshipping int
select @cer_itemshipping = ISNULL(shipping,0) from cer_Detail where cermodelid= @cermodelid
declare @cer_iteminstallation int
select @cer_iteminstallation = ISNULL(installation,0) from cer_Detail where cermodelid = @cermodelid
declare @cer_totalcost int
select @cer_totalcost = @cer_itemcost + @cer_itemshipping + @cer_iteminstallation
declare @capx_allocatedamount int
if @allocatedamount >@cer_totalcost
BEGIN
select @capx_allocatedamount= @cer_totalcost
END
ELSE
BEGIN
select @capx_allocatedamount = @allocatedamount
END
insert into cer_CapX(cermodelid, capxid, spmodelid, assettypeid, totalcost, description, shortname,allocatedamount,updateuserid, updatedate )
values(@cermodelid, @capxid, @spmodelid, @assettypeid, @totalcost, @description, @shortname,@capx_allocatedamount, @userid, getdate ())
set @ErrorNo = @@Error
if @ErrorNo <> 0
BEGIN
set @key = 0
set @ErrorMessage = 'Failed to insert the record (' + cast(@ErrorNo as varchar) + '}'
END
select @key as ID, @ErrorMessage as
ErrorMessage
END

USE [BIProd]
GO
/****** Object: StoredProcedure [dbo].[cer_ActiveInfo] Script Date: 5/29/2014 3:26:51 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cer_ActiveInfo]
@workqueuestageid as int
AS
SET NOCOUNT ON;
declare @beginning_cermodelid int
select @beginning_cermodelid = (select TOP 1 ws.cermodelid from cer_WorkqueueStage ws where ws.cerworkqueuestageid=@workqueuestageid)
declare @notes_text varchar(1000)
select @notes_text = (select ws.notes from cer_WorkqueueStage ws where ws.cerworkqueuestageid = @workqueuestageid)
declare @the_workqueueuserid int
IF @notes_text IS NULL
BEGIN
select @the_workqueueuserid =(select TOP 1 ws.workqueueuserid from cer_WorkqueueStage ws where ws.cermodelid=@beginning_cermodelid and ws.notes IS NOT NULL
and ws.cerworkqueuestageid <@workqueuestageid order by ws.updatedate DESC)
END
ELSE
BEGIN
select @the_workqueueuserid =(select ws.workqueueuserid from cer_WorkqueueStage ws where ws.cermodelid=@beginning_cermodelid and ws.notes IS NOT NULL
and ws.cerworkqueuestageid =(@workqueuestageid+1))
END
If @the_workqueueuserid IS NULL
Begin
select @the_workqueueuserid =(select TOP 1 ws.workqueueuserid from cer_WorkqueueStage ws where ws.cermodelid=@beginning_cermodelid and ws.cerworkqueuestageid =(@workqueuestageid +1))
End
declare @the_username varchar(150)
select @the_username =(select u.displayname from ptl_User u where u.userid =@the_workqueueuserid)
select TOP 1 ws.cerworkqueuestageid, ws.notes, ws.workqueueuserid,u.displayname, @the_username as the_username
from cer_WorkqueueStage ws INNER JOIN ptl_User u on u.userid=ws.workqueueuserid
where ws.cerworkqueuestageid =@workqueuestageid
AND ws.notes IS NOT NULL order by ws.updatedate DESC
declare @the_entityid int
select @the_entityid = (select wr.workqueueentityid FROM cer_WorkqueueUser wr WHERE wr.userid=@UserID AND (wr.workqueueroleid=12 OR wr.workqueueroleid=13 OR wr.workqueueroleid=14 ))
SELECT t2.assetshortname, t2.entityshortname, t2.abbrevname, t2.statusshortname, t2.cermodelid, t2.assettypeid, t2.statusid, t2.createuserid, t2.entityid, t2.createdate, t2.workqueueuserid, t2.workqueuestatusid, t2.displayname, t2.description, t2.financingflag
FROM (select DISTINCT ws.cermodelid from cer_WorkqueueStage ws where ws.workqueueentityid = @the_entityid) t1
INNER JOIN
(SELECT at.shortname as assetshortname, en.shortname as entityshortname, en.abbrevname, st.shortname as statusshortname, cer.cermodelid, cer.assettypeid,
cer.statusid, cer.createuserid, cer.entityid, cer.createdate, wq.workqueueuserid, wq.statusid as workqueuestatusid,u.displayname,det.financingflag,
description = case when Len( cer.description ) >= 25 then Left( cer.description, 25 - patindex('%[^0-9a-z]%', reverse(Left( cer.description, 25)))) + '...' else cer.description end
FROM
cer_Model cer INNER JOIN fin_AssetType at on at.assettypeid = cer. assettypeid
INNER JOIN ptl_Entity en on en.entityid = cer.entityid INNER JOIN cer_Workqueue wq on cer.cermodelid= wq.cermodelid
INNER JOIN ptl_Status st on st.statusid = wq.statusid
INNER JOIN cer_Detail det on det.cermodelid=cer.cermodelid
LEFT OUTER JOIN ptl_User u on wq.workqueueuserid=u.userid
WHERE det.financingflag=1) t2
ON t1.cermodelid = t2.cermodelid

Javascript

Basic Functionality This is coming from the project I referenced earlier where I was using a hybrid of PHP, T-SQL and Javascript. Here's some of the basic Javascript I worked with (for more verbose examples of Javascript, please refer to the "Verizon Calendar.": <td width='$column4' align='right' valign='middle' class='overline'> <span class='clickableLite' onmouseover=\"this.style.textDecoration='underline';\" onmouseout=\"this.style.textDecoration='none';\" this "onmouseover" code is a clever usage of Javascript that gives the user the look and feel of a link, when in fact, it's just a cue to execute a Javascript command. Now you've got your "onclick" command... onclick='loadlookup(dataform,\"specialty_lookup\",entityid,specialtyid,specialty,\"specialty\")'> Here's the actual Javascript function... function loadlookup(form, page, entityid, id, name, label) { lookuplabel.innerHTML = 'Click name to add: '+label; lookupentity = form.entityid.value; switch (label) { case "physician" : groupid = form.specialtyid.value; break; case "payer" : groupid = form.finclassid.value; break; default : groupid = ""; break; } if (form.showsql.value == 1) showsql = "&showsql=1"; else showsql = ""; eval ('window.lookup.location=\''+page+'.php?entityid='+lookupentity+'&id='+id+'&name='+name+'&group='+groupid+showsql+'\';'); }

X Code

iPhone As part of the Showdown, I built an iPhone app. This was prior to a full fledged mobile version of the site so I used the iPhone app to display crucial portions of the online community and also built an app tha tyou actually paid for which gave you access to certain portions of the website that were otherwise off limits. It worked very well and well received at the time! // // showdown_plus.m // Intro // // Created by Bruce Gust on 1/1/13. // Copyright (c) 2013 Bruce Gust. All rights reserved. // #import "showdown_plus.h" @interface showdown_plus () @end @implementation showdown_plus - (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil { self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil]; if (self) { // Custom initialization } return self; } - (IBAction)home_plus_button:(id)sender { [self dismissViewControllerAnimated:YES completion:nil]; } - (IBAction)plus_forward_button:(id)sender { [_showdown_plus_webview goForward]; } - (IBAction)showdown_plus_button:(id)sender { NSString *fullURL = @"http://www.countryshowdown.com/mobile/showdown_plus.php?paid=1"; NSURL *url = [NSURL URLWithString:fullURL]; NSURLRequest *requestObj = [NSURLRequest requestWithURL:url]; [_showdown_plus_webview loadRequest:requestObj]; } - (void)viewDidLoad { [self showdown_plus_button :self]; [super viewDidLoad]; // Do any additional setup after loading the view. } - (void)didReceiveMemoryWarning { [super didReceiveMemoryWarning]; // Dispose of any resources that can be recreated. } - (IBAction)showdown_plus_back_button:(id)sender { [_showdown_plus_webview goBack]; } @end

Action Script

The Starting Line Flash / ActionScript was one of my first languages that I dove into. If you head out to http://www.brucegust.com/StartingLine, you'll see some of my Flash ability in action. The pages have a bunch of animation going on. This chunk of code is a series of "if" statements that determine how things flow based on the user's selection. if (Downloads eq "Yes") { gotoAndPlay("Downloads", 20); } else if (Saying eq "Yes") { gotoAndPlay("Saying I", 20); } else if (Order eq "Yes") { gotoAndPlay("How to Order", 20); } else if (About eq "Yes") { gotoAndPlay("About the Author", 20); } else if (Home eq "Yes") { gotoAndPlay("Transition", 1); } else if (Back eq "Yes") { gotoAndPlay("Overview II", 20); } else { gotoAndPlay("Transition", 1); } Another piece of code that you can see in action on the Texaco Country Showdown on the rotating carousel is something saves a great deal of space on the timeline. Rather than a multitude of frames being eaten up while one slide is "paused" before a motion tween that segues into the next slide, this makes the slide in question "wait" according to a perscribed number of seconds before it moves on. var myInterval; function wait(howLong) { clearInterval(myInterval); stop(); myInterval = setInterval(function () { play(); }, howLong); } counter = 1; Finally, this is a button that I enjoyed making. Again, it was for the Showdown site. This is when they were sponsored by Colgate when mobile devices were not the priority that they are today. This is the script that goes along with one of the volume control buttons that turns when you hove over it and then connects the user to a specific link when they click on it. Click here to see it in action. onClipEvent(load){ //is the cursor over the movie clip previouslyOver=false; } onClipEvent(enterFrame){ currentlyOver=this.hitTest(_root._xmouse,_root._ymouse,true); //if there is a change, go to another frame if(!previouslyOver and currentlyOver){ previouslyOver=true; this.gotoAndPlay("on"); } else if (previouslyOver and !currentlyOver){ previouslyOver=false; this.gotoAndPlay("off"); } } on (release) { getURL("Search.php"); } Here's a list of some of the Flash-based pages I built: