public function getIndex()
 {
     // Page Title
     $this->_data['page_title'] = "Licenses";
     $this->_data['licenses'] = License::search();
     return View::make('admin.licenses.index', $this->_data)->nest('header', 'admin.common.header', $this->_data)->nest('footer', 'admin.common.footer', $this->_data);
 }
 }
 if ($_GET['startWith']) {
     $whereAdd[] = "TRIM(LEADING 'THE ' FROM UPPER(L.shortName)) LIKE UPPER('" . $_GET['startWith'] . "%')";
 }
 $orderBy = $_GET['orderBy'];
 //get total number of records to print out and calculate page selectors
 $totalLicenseObj = new License();
 $totalRecords = $totalLicenseObj->searchCount($whereAdd);
 //reset pagestart to 1 - happens when a new search is run but it kept the old page start
 if ($totalRecords <= $pageStart) {
     $pageStart = 1;
 }
 $limit = $pageStart - 1 . ", " . $numberOfRecords;
 $licenseObj = new License();
 $licenseArray = array();
 $licenseArray = $licenseObj->search($whereAdd, $orderBy, $limit);
 $pagination = '';
 if ($totalRecords == 0) {
     echo "<br /><br /><i>Sorry, no licenses fit your query</i>";
     $i = 0;
 } else {
     //maximum number of pages to display on screen at one time
     $maxDisplay = 25;
     $thisPageNum = count($licenseArray) + $pageStart - 1;
     echo "<span style='font-weight:bold;'>Displaying " . $pageStart . " to " . $thisPageNum . " of " . $totalRecords . " License Records</span><br />";
     //print out page selectors
     if ($totalRecords > $numberOfRecords) {
         if ($pageStart == "1") {
             $pagination .= "<span class='smallText'><<</span>&nbsp;";
         } else {
             $pagination .= "<a href='javascript:setPageStart(1);'><<</a>&nbsp;";
 /**
  * Get user licenses
  *
  * Lists all licenses of a use for a product
  */
 public function postGetUserLicenses()
 {
     if ($this->_isValidRequest()) {
         $email = Input::get('email');
         $product_code = Input::get('code');
         if (!$email or !$product_code) {
             $this->_invalidRequest();
         }
         $product = Product::where('code', '=', $product_code)->first();
         if (!$product) {
             $this->_invalidRequest();
         }
         $licenses = License::search($email, 'email', $product->code);
         $data = array();
         foreach ($licenses as $key => $license) {
             $usage = LicensesUses::getAllUsage($license->license_key);
             $data[] = array('license' => $license, 'usage' => $usage);
         }
         return Response::json($data);
     }
 }