SolSearchAdmin.php

<?php

require 'SolSearchAdminInterface.php';
require 'SolSearch.php';

class SolSearchAdmin extends Solsearch implements SolSearchAdminInterface {

  /**
   * Admin only. Add a new group to the database. This must be done before any
   * of that groups ads are added. Admin only.
   *
   * @param string $url
   * @param string $name
   */
  public function insertGroup($url, $name) {
    // For testing we'll check if the client already exists.
    $result = dbQuery("SELECT apikey FROM clients WHERE url = '$url'");
    if ($result->rowCount()) {
      $apikey = $result->fetchObject()->apikey;
    }
    else {
      $apikey = $this->makeAPIkey();
      $result = dbQuery("INSERT INTO clients (apikey, name, url) VALUES ('$apikey', '$name', '$url')");
    }
    return ['apikey' => $apikey];
  }

  /**
   * Admin only. Update a client's name or url
   */
  public function updateGroup($id, $name, $url) {
    $query = "UPDATE clients SET url = '$url', name = '$name' WHERE id = '$id'";
    dbQuery($query);
  }


  public function listGroups() {
    $result = dbQuery(
      "SELECT c.id, c.name, c.url FROM clients c LEFT JOIN ads a ON c.id = a.client_id GROUP BY c.id, a.type"
    );
    while ($item = $result->fetchObject()) {
      $groups[] = $item;
    }
    return $groups;
  }

  private function makeAPIkey() {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $randstring = '';
    for ($i=0; $i<12; $i++) {
      $randstring .= $characters[rand(0, strlen($characters)-1)];
    }
    return $randstring;
  }


  public function deleteGroup($id) {
    $dbQuery("DELETE FROM clients WHERE id = '$id'");
    $dbQuery("DELETE FROM ads WHERE client_id = '$id'");
  }
}