Monday - April 11th, 2016


Verizon Code and Trophies

I was originally hired for a six month contract. That blossomed into a timeframe that was just shy of two years. It was a great experience and the additions that were made to my skillset and portfolio were significant, thanks to the opportunities and personalites I came in contact with during my time with Verizon Wireless.

Here's a brief "tour..."

In addition to what's below, feel free to peruse the Powerpoint presentation that's displayed to the right to view the GANT Chart and the Phantom JS scripting that created a pdf version of the web data the user was looking at.

I) OOP / MVC

The template that was in place, in terms of how PHP pages were to be constructed, was based on an MVC approach to Object Oriented Programming. Where OOP has Functions categorized under the heading of various Classes, this approach further grouped classes in the context of "Model, View and Controller."

Whereas an "object" is usually thought of as a digital placeholder that positions functionality within the landscape of the page, this infrastructure established the page itself as the "object." The result being a very clean and concise way of organizing and constructing applications. Click on the "show / hide" link below to read more and to see how the code was written.

...show / hide

Below is how a page is typically coded.

  1. require_once('homepageclass.php'); // this extends the htmlclass which is all your basic html info such doctype, header information etc. "homepageclass" will extend that and add any unique scripting for the sake of this particular page
  2. require_once('model_class.php');//this is where you keep all of your database functionality
  3. require_once('view_class.php');//this is where you keep all of your "GUI" functionality as far as how you display the data being retrieved by the classes in the model_class.php page
  4. $app_id=6;
  5. $app_roles = array('*');
  6. $new_page= new HomePage($app_id,$app_roles);
  8. $data= new NewsAdmin();
  9. $view = new viewNews();
  11. $headline_info=$data->headline_featured(); //function that retrieves all of the news articles in the database
  12. $headline_display=$view->featured_app($headline_info); // function that breaks up the array into intuitive and aesthetically sensible elements that can be displayed
  14. $body='</div>
  15. <div class="headlines">';
  16. $body.=$headline_display;//here's the "headlines" as they're being displayed thanks to line 13
  17. $body.='
  18. </div>
  20. $new_page->setBody($body);//this is a construct that's located on the htmlclass.php page that simply "assembles" all of the content that's been categorized under the "body" heading and is then displayed on line 23
  22. echo $new_page->display();
  23. ?>


It becomes easier to understand when you see the htmlclass.php page. Here's the way that looks:

  1. <?php
  2. //require_once 'DataTools/classes/SecurityCheck.class.php';
  3. class htmlpage
  4. {
  5. protected $headerTop; //the following values are "protected" in order to ensure that they remain exclusive to the htmlpage Class. This is healthy programming because it prevents situations where unintended usages of the Property name (i.e. $style) don't result in wires getting crossed and apps blowing up because of the way the page is subsequently processed
  6. protected $metatags;
  7. protected $style;
  8. protected $scripts;
  9. protected $headerBottom;
  10. protected $body;
  11. protected $footer;
  12. protected $URL;
  13. protected $web_address;
  14. protected $security;
  15. protected $app_id;
  16. protected $app_roles = array();
  17. public $root_directory;
  19. //public function __construct($app_id, $app_roles = array(), $title='South Area Network Page')
  20. public function __construct($title='South Area Network Page')
  21. {
  22. //$this->app_id = $app_id;
  23. //$this->app_roles = $app_roles;
  24. //here' where I'm declaring and / or defining my Property values
  25. $this->metaTags=''; //by leaving this blank, I'm giving myself the opportunity to define this in the context of some kind of interactivity in the context of a Function. As an aside, you don't declare a variable / property with a function and expect it to be shared by other Functions in the same Class apart from using the Construct Function.
  26. $this->style='';
  27. $this->scripts='';
  28. $this->body='';
  30. $this->headerTop = '
  31. <!DOCTYPE html>
  32. <head>
  33. <meta http-equiv="Pragma" content="no-cache" />
  34. <meta http-equiv="Expires" content="-1" />
  36. <title>'.$title.'</title>
  37. <link href="css/new_style.css" rel="stylesheet" type="text/css" />
  38. <link rel="shortcut icon" href="http://southareanetwork.nss.vzwnet.com/images/verizon_favicon.ico">
  39. <map name="tabs">
  40. <area shape="rect" coords="19,27,140,43" href="http://cascsawssa1v.nss.vzwnet.com:8080/c0couri/exdash/index.php">
  41. <area shape="rect" coords="153,27,262,43" href="network_tools.php">
  42. <area shape="rect" coords="281,27,393,43" href="recognition.php">
  43. <area shape="rect" coords="405,27,523,43" href="project_request.php">
  44. </map>
  45. <map name="login">
  46. <area shape="rect" coords="14,64,456,131" href="index.php">
  47. </map>
  48. '; //hard coding the value of my $headerTop Property
  50. $this->headerBottom= '
  52. '; //hard coding the value of my $headerBottom Property, but this can usurped by the other pages
  54. $this->footer='
  55. </div> <!-- close site_content -->
  56. <div class="footer"><br>© Verizon Wireless | South Area | All Rights Reserved | <a href="sign_in.php" style="color:#ffffff; text-decoration:none;">Sign In</a> | <a href="page.php?page_id=8.php" style="color:#ffffff; text-decoration:none;">Contact</a></div></body></html>
  57. ';//hard coding the value of my $footer Property
  58. //$this->security = new SecurityCheck($this,$this->app_id,$this->app_roles);
  59. $this->setURL();
  60. }
  62. public function getURL()
  63. {
  64. return $this->URL;
  65. } //apparently I'm going to be defining my URL Property value in the context of either this Function or the one directly beneath it. Either way, the Property value is the one being "returned" by one of these two functions.
  67. public function setURL($URL=null)
  68. {
  69. if(isset($URL))
  70. {
  71. $this->URL=$URL;
  72. }
  73. else
  74. {
  75. $this->URL='http://'.$_SERVER['HTTP_HOST'].$_SERVER['SCRIPT_NAME'];
  76. return;
  77. }
  78. }
  80. public function curPageName()
  81. {
  82. $this->web_address=substr($_SERVER["SCRIPT_NAME"],strrpos($_SERVER["SCRIPT_NAME"],"/")+1);
  83. return $this->web_address;
  84. }
  86. public function setMetaTags($metaTags)
  87. {
  88. $this->metatags .=$metaTags;
  89. return; //I can expect this Property value to be establishd as a result of a variable that's going to be passed into this Function
  90. }
  92. public function setStyle($style)
  93. {
  94. $this->style .=$style;
  95. return;
  96. } //same thing as $metaTags
  98. public function setScript($scripts)
  99. {
  100. $this->scripts .=$scripts;
  101. return;
  102. } //same thing as $metaTags
  104. public function setBody($body)
  105. {
  106. $this->body .=$body;
  107. return;
  108. } // same thing as $metaTags
  110. public function display()
  111. {
  112. echo $this->headerTop;
  113. echo $this->metatags;
  114. echo $this->style;
  115. echo $this->scripts;
  116. echo $this->headerBottom;
  117. echo $this->body;
  118. echo $this->footer;
  120. return;
  121. } //this Function is taking all of the Property values that have been declared and defined and displaying them by "echo-ing" them
  123. }
  125. ?>


II) 20,000,000 Rows...

The first project I was assigned was to take a database that consisted of Twitter data and build an app that allowed users to query the database based on date and latitude / longitude values.

What made this challenging was that even by indexing the data, because the query included a "BETWEEN" dynamic, the indexing approach did very little in terms of streamling the search process.

The first step was to break the original table down into 365 individual tables. Each table was a day's worth of Twitter traffic. This in and of itself required a script that would run overnite for several days and break the table down and write new tables with one day's worth the data.

Once that was in place, the actual app would identify the tables that corresponded to the user's search criteria. It would then grab the appropriate data and export it into a temporary table that could then be dumped into a CSV table the user could download.

Even with the data being broken down into 365 different tables, the process was still potentially lengthy to the point of being distracting for the user. To prevent the apparent lack of activity from being a problem, a Javascript was introduced that "moved" the user's process so they could see progress being made. Click on the "show more..." link below to see the code.

...show / hide

You've got 365 tables, each representing one day's worth of Twitter traffic. When the user submits their search criteria, the first thing is to determine how many days / tables will need to be queried in order to "mine" the appropriate amount of information. That number of tables becomes the number of "laps" the code will make as it gathers all of the data from each of the tables that corresponds to the latitude and longitude values the user entered and inserts that information into a new temporary that has as its name the current session id.

As each table is processed and dumped into the new temp table, the user is routed to a page whose sole purpose is to inform the user how many more "laps" or tables the process has to go through before the process if finished. Once the process completes its last "lap," the user is routed to a page where it can now export all of the information that's been compiled and inserted into the new temp table into a CSV file.

Here's the code for the page that is monitoring the number of "laps" that are being made:

  1. <?php
  2. $the_session_id=session_id();
  3. if(empty($the_session_id))
  4. {
  5. session_start();
  6. $the_session_id=session_id();
  7. }
  9. if(!isset($_GET['new_count']))
  10. {
  11. if(isset($_POST['start_date']))
  12. {
  13. header("location:no_results.php");
  14. exit();
  15. }
  17. if(!$_POST['end_date'])
  18. {
  19. header("location:no_results.php");
  20. exit();
  21. }
  23. if(!$_POST['latitude_1'])
  24. {
  25. header("location:no_results.php");
  26. exit();
  27. }
  29. if(!$_POST['latitude_2'])
  30. {
  31. header("location:no_results.php");
  32. exit();
  33. }
  35. if(!$_POST['longitude_1'])
  36. {
  37. header("location:no_results.php");
  38. exit();
  39. }
  41. if(!$_POST['longitude_2'])
  42. {
  43. header("location:no_results.php");
  44. exit();
  45. }
  46. }
  49. ini_set('max_execution_time', 300); //300 seconds = 5 minutes
  50. ini_set("memory_limit", "700M");
  51. include ("carter.inc");
  52. $cxn = mysqli_connect($host,$user,$password,$database)
  53. or die ("couldn't connect to server");
  55. /*$start_date = date('Y-m-d',strtotime($_POST['start_month'].' '.$_POST['start_day'].' '.$_POST['start_year']));
  56. $end_date = date('Y-m-d',strtotime($_POST['end_month'].' '.$_POST['end_day'].' '.$_POST['end_year']));*/
  59. if(!isset($_GET['new_count']))
  60. {
  62. $the_start_date=trim($_POST['start_date']);
  63. $the_end_date=trim($_POST['end_date']);
  65. $min_date = strtotime("$the_start_date"); // or your date as well
  66. $max_date = strtotime("$the_end_date");
  67. $datediff = $max_date - $min_date;
  68. $starting_count= floor($datediff/(60*60*24));
  69. $the_count=$starting_count+2;
  71. $lat_1=trim($_POST['latitude_1']);
  72. $lat_2=trim($_POST['latitude_2']);
  73. $lon_1=trim($_POST['longitude_1']);
  74. $lon_2=trim($_POST['longitude_2']);
  76. //set up temporary table based on session_id, but first make sure there isn't one left over from an abandoned session
  78. $dan="show tables like '$the_session_id'";
  79. $dan_result=mysqli_query($cxn, $dan);
  80. if(!$dan_result)
  81. {
  82. $rats=mysqli_errno($cxn).': '.mysqli_error($cxn);
  83. die($rats);
  84. }
  85. $dan_count=mysqli_num_rows($dan_result);
  86. if($dan_count>0)
  87. {
  88. $michelle="delete from $the_session_id";
  89. $michelle_query=mysqli_query($cxn, $michelle);
  90. if(!$michelle_query)
  91. {
  92. $bummer=mysqli_errno($cxn).': '.mysqli_error($cxn);
  93. die($bummer);
  94. }
  95. }
  96. else
  97. {
  98. $brice="CREATE TABLE `$the_session_id` (
  99. `id` int(11) NOT NULL AUTO_INCREMENT,
  100. `actor_id` varchar(150) DEFAULT NULL,
  101. `actor_display_name` varchar(150) DEFAULT NULL,
  102. `posted_time` varchar(150) DEFAULT NULL,
  103. `lat` varchar(150) DEFAULT NULL,
  104. `lon` varchar(150) DEFAULT NULL,
  105. `location_name` varchar(150) DEFAULT NULL,
  106. `posted_day` date DEFAULT NULL,
  107. `session_id` varchar(150) DEFAULT NULL,
  108. PRIMARY KEY (`id`)
  109. ) ENGINE=InnoDB AUTO_INCREMENT=529425 DEFAULT CHARSET=latin1";
  110. $brice_query=mysqli_query($cxn, $brice);
  111. if(!$brice_query)
  112. {
  113. echo "right here, champ";
  114. $rats=mysqli_errno($cxn).': '.mysqli_error($cxn);
  115. die($rats);
  116. }
  117. }
  118. //get the right table names
  120. $table_date = str_replace("-","","$the_start_date");
  121. $the_table_name="twtr_";
  122. $the_table_name.=$table_date;
  124. $current_date = "$the_start_date";
  125. $new_current_date=date('Y-m-d', strtotime($current_date. ' + 1 days'));
  126. $new_table_date = str_replace("-","","$new_current_date");
  127. $new_table_name="twtr_";
  128. $new_table_name.=$new_table_date;
  129. $the_twitter_table=$the_session_id;
  131. $nelson="insert into $the_twitter_table (actor_id, actor_display_name, posted_time, lat, lon, location_name, posted_day, session_id) SELECT actor_id, actor_display_name, posted_time, geo_coords_lat ,geo_coords_lon, location_name, posted_day, '$the_session_id' FROM $the_table_name WHERE (geo_coords_lat BETWEEN '$lat_1' and '$lat_2') and (geo_coords_lon BETWEEN '$lon_1' and '$lon_2')";
  132. $nelson_query=mysqli_query($cxn, $nelson);
  133. if(!$nelson_query)
  134. {
  135. $nuts=mysqli_errno($cxn).': '.mysqli_error($cxn);
  136. die($nuts);
  137. }
  138. $new_count=$the_count-1;
  139. header("Location:new_nelson_preliminary.php?lat_1=$lat_1&lat_2=$lat_2&lon_1=$lon_1&lon_2=$lon_2&new_count=$new_count&table_name=$new_table_name¤t_date=$the_start_date&session_id=$the_session_id");
  140. exit();
  141. }
  142. else
  143. {
  144. if($_GET['new_count']==0)
  145. {
  146. $the_session_id=$_GET['session_id'];
  147. header("Location:new_nelson_twitter_preliminary.php?session_id=$the_session_id");
  148. exit();
  149. }
  150. else
  151. {
  152. $the_table_name=$_GET['table_name'];
  153. $the_new_count=$_GET['new_count'];
  154. $lat_1=$_GET['lat_1'];
  155. $lat_2=$_GET['lat_2'];
  156. $lon_1=$_GET['lon_1'];
  157. $lon_2=$_GET['lon_2'];
  158. $the_session_id=$_GET['session_id'];
  159. $the_twitter_table=$the_session_id;
  161. $nelson="insert into $the_twitter_table (actor_id, actor_display_name, posted_time, lat, lon, posted_day, session_id) SELECT actor_id, actor_display_name, posted_time, geo_coords_lat ,geo_coords_lon, posted_day, '$the_session_id' FROM $the_table_name WHERE (geo_coords_lat BETWEEN '$lat_1' and '$lat_2') and (geo_coords_lon BETWEEN '$lon_1' and '$lon_2')";
  162. $nelson_query=mysqli_query($cxn, $nelson);
  163. if(!$nelson_query)
  164. {
  165. $nuts=mysqli_errno($cxn).': '.mysqli_error($cxn);
  166. die($nuts);
  167. }
  168. $new_count=$the_new_count-1;
  169. $current_date = $_GET['current_date'];
  170. $new_current_date=date('Y-m-d', strtotime($current_date. ' + 1 days'));
  171. $new_table_date = str_replace("-","","$new_current_date");
  172. $new_table_name="twtr_";
  173. $new_table_name.=$new_table_date;
  174. header("Location:new_nelson_preliminary.php?lat_1=$lat_1&lat_2=$lat_2&lon_1=$lon_1&lon_2=$lon_2&new_count=$new_count&table_name=$new_table_name¤t_date=$new_current_date&session_id=$the_session_id");
  175. exit();
  177. }
  178. }
  181. ?>




III) Bootstrap

Given the priority of creating mobile versions of whatever web content that you have, "Bootstrap" is a very handy skill to have in your toolbox.

It's not always intuitive, when it comes to creating a mirror image of your site. Even collapsible menus require a little "finagling" in order to get the desired effect.

Click here to view the Bootstrap version of the Verizon webpage.


© Verizon Wireless | South Area | All Rights Reserved | Sign In | Contact