/**
  * @brief Initializes the API Request Process.
  *
  * ## Overview
  * This will parse various request parameters and attemp to call the 
  * respective action on an object controller.
  *
  * @uses spl_autoload_register()
  * @see index.php
  *
  * @return {Null} Always unless fatal error or exception is thrown.
  *
  * @author TronNet DevOps [Sean Murray] <*****@*****.**>
  * @date 02/19/2014
  */
 public static function Init($params = null)
 {
     try {
         if (count($_POST)) {
             // Auth always required
             $method = 'post';
             $params = $_POST;
         } else {
             // Some auth may be required
             $method = 'get';
             $params = $_GET;
         }
         DebugHandler::Log(var_export($params, true));
         DebugHandler::Log(var_export($method, true));
         DebugHandler::Log(var_export($_SERVER['REQUEST_URI'], true));
         $noGet = explode('?', $_SERVER['REQUEST_URI']);
         $delReqParams = explode('/', $noGet[0]);
         DebugHandler::Log(var_export($delReqParams, true));
         array_shift($delReqParams);
         DebugHandler::Log(var_export($delReqParams, true));
         if (isset($delReqParams[0]) && !empty($delReqParams[0])) {
             $params['_action'] = $delReqParams[0];
             if (isset($delReqParams[1]) && !empty($delReqParams[1])) {
                 $params['_target'] = $delReqParams[1];
                 array_shift($delReqParams);
             }
         }
         if (!isset($params['_target'])) {
             throw new Exception('No target was provided');
         }
         DebugHandler::Log(var_export($params, true));
         $className = $params['_target'];
         $action = $params['_action'];
         $controller = $className . 'Controller';
         DebugHandler::Log(var_export(SATANBARBARA_API_NAMESPACE . $controller . '::ValidRequestMethod::' . $action, true));
         if (call_user_func(SATANBARBARA_API_NAMESPACE . $controller . '::ValidRequestMethod', $method, $action)) {
             $filteredParams = call_user_func(SATANBARBARA_API_NAMESPACE . $controller . '::FilterParams', $method, $action, $params);
             $data = call_user_func(SATANBARBARA_API_NAMESPACE . $controller . '::' . $action, $filteredParams);
         } else {
             throw new Exception('This action cannot be envoked through the get method!');
         }
         AJAX::Response('json', $data);
     } catch (Exception $e) {
         AJAX::Response('json', array(), 1, $e->getMessage());
     }
 }
Exemplo n.º 2
0
 public static function Fetch($ids = array(-1), $fields = array('*'), $limit = 20, $offset = 0, $orderBy = 'id', $orderByDir = 'ASC', $groupBy = 'id', $criteria = null, $delineation = null, $operator = null)
 {
     $obj = SATANBARBARA_API_NAMESPACE . static::$_ENTITY;
     $objSet = array();
     $mergers = array();
     $results = array();
     $visible = array_keys(self::GetProperties(BaseEntity::EAP_READ_ONLY));
     $start = $end = null;
     if (!is_array($ids)) {
         $ids = explode(',', $ids);
     }
     if (!is_array($fields)) {
         $fields = explode(',', $fields);
     }
     /**
      * @todo maybe make this more smart and search the array and slice, instead of first index
      */
     if (in_array('*', $fields)) {
         $filteredFields = $visible;
     } else {
         if (in_array('count', $fields)) {
             $filteredFields = $fields;
         } else {
             $filteredFields = array_intersect($fields, $visible);
             if (!count($filteredFields)) {
                 $filteredFields = $visible;
             }
         }
     }
     if (isset($criteria)) {
         if (isset($criteria['dateStart'])) {
             $start = $criteria['dateStart'];
         }
         if (isset($criteria['dateEnd'])) {
             $end = $criteria['dateEnd'];
         }
         $filteredCriteria = static::Filter($criteria);
     } else {
         $filteredCriteria = null;
     }
     if (isset(static::$mergers) && in_array("mergers", $fields)) {
         unset($fields[array_search("mergers", $fields)]);
         foreach (static::$mergers as $entity => $merger) {
             if ($merger['fields'] == '*') {
                 $manager = SATANBARBARA_API_NAMESPACE . $entity . 'Manager';
                 $propertyDirectives = call_user_func($manager . '::GetProperties', BaseEntity::EAP_READ_ONLY);
                 $merger['fields'] = array_keys($propertyDirectives);
             }
             $mergers[$entity] = $merger;
         }
     }
     if ($ids[0] == -1) {
         $resultSet = Storage::FetchAll(Storage::MYSQL, $filteredFields, $limit, $offset, $orderBy, $orderByDir, $groupBy, $filteredCriteria, $delineation, $operator, $mergers, $start, $end, self::$_STORAGE_NAMESPACE, static::$_KEY);
         DebugHandler::Log(var_export($resultSet, true));
         foreach (array_keys($resultSet) as $id) {
             $results[$id] = $resultSet[$id][0];
             $results[$id]['id'] = $id;
         }
     } else {
         $resultSet = Storage::FetchByIDs(Storage::MYSQL, $ids, $filteredFields, $mergers, self::$_STORAGE_NAMESPACE, static::$_KEY);
         DebugHandler::Log(var_export($resultSet, true));
         foreach (array_keys($resultSet) as $id) {
             $results[$id] = $resultSet[$id][0];
             $results[$id]['id'] = $id;
         }
     }
     DebugHandler::Log(var_export($results, true));
     return $results;
 }
 public static function FetchAll($table, $fields, $limit, $offset, $orderBy = 'id', $orderByDir = 'ASC', $groupBy = 'id', $criteria = null, $delineation = null, $operator = null, $associations = null, $start = null, $end = null)
 {
     $db = self::getHandle();
     $isCount = false;
     if ($groupBy == 'none') {
         $groupBy = null;
     }
     if (in_array('count', $fields)) {
         $isCount = true;
         $fieldsCondenced = '`' . $table . '`.`id`';
         $countSubWrapBegin = 'SELECT COUNT(*) AS `total` FROM (';
         $countSubWrapEnd = ') `' . $table . '`';
         array_shift($fields);
     } else {
         $fieldsCondenced = '`' . $table . '`.`' . implode($fields, '`, `' . $table . '`.`') . '`';
         if ($groupBy) {
             if (!in_array($groupBy, $fields)) {
                 if (!in_array('id', $fields)) {
                     $groupBy = $fields[0];
                 } else {
                     $groupBy = 'id';
                 }
             }
         }
         if ($orderBy) {
             if (!in_array($orderBy, $fields)) {
                 if (!in_array('id', $fields)) {
                     $orderBy = $fields[0];
                 } else {
                     $orderBy = 'id';
                 }
             }
         }
     }
     if (empty($orderByDir) || $orderByDir != 'ASC' && $orderByDir != 'DESC') {
         $orderByDir = 'ASC';
     }
     $association = '';
     $where = 'WHERE ';
     $whereParams = array();
     $counter = 0;
     $bindParamKey = '';
     if (is_array($criteria)) {
         foreach ($criteria as $key => $value) {
             if ($counter) {
                 switch ($delineation) {
                     case 'and':
                         $where .= ' AND ';
                         break;
                     case 'or':
                         $where .= ' OR ';
                         break;
                 }
             }
             $bindParamKey = ':crit' . $counter++;
             switch ($operator) {
                 case 'like':
                     $where .= ' `' . $table . '`.`' . $key . '` LIKE ' . $bindParamKey;
                     $whereParams[$bindParamKey] = $value . '%';
                     break;
                 case 'fuzzy':
                     $where .= ' `' . $table . '`.`' . $key . '` LIKE ' . $bindParamKey;
                     $whereParams[$bindParamKey] = '%' . $value . '%';
                     break;
                 case 'eq':
                     $where .= ' `' . $table . '`.`' . $key . '`=' . $bindParamKey;
                     $whereParams[$bindParamKey] = $value;
                     break;
             }
         }
     }
     if (is_array($associations)) {
         foreach ($associations as $key => $assocIdentity) {
             $association = ' LEFT JOIN `' . $assocIdentity['to']['key'] . '` ON `' . $assocIdentity['from']['key'] . '`.`' . $assocIdentity['from']['field'] . '` = `' . $assocIdentity['to']['key'] . '`.`' . $assocIdentity['to']['field'] . '`';
             foreach ($assocIdentity['fields'] as $field) {
                 $fieldsCondenced .= ', ' . '`' . $assocIdentity['to']['key'] . '`.`' . $field . '` AS `' . $key . '_' . $field . '`';
             }
         }
     }
     if ($start) {
         $bindParamKey = ':crit' . $counter++;
         if (count($whereParams)) {
             $where .= ' AND ';
         }
         $where .= '`' . $table . '`.`date` > ' . $bindParamKey;
         $whereParams[$bindParamKey] = $start;
     }
     if ($end) {
         $bindParamKey = ':crit' . $counter++;
         if (count($whereParams)) {
             $where .= ' AND ';
         }
         $where .= '`' . $table . '`.`date` < ' . $bindParamKey;
         $whereParams[$bindParamKey] = $end;
     }
     if (!count($whereParams)) {
         $where = '';
     }
     if ($orderBy) {
         $orderQuery = ' ORDER BY `' . $table . '`.`' . $orderBy . '` ' . $orderByDir . ' ';
     } else {
         $orderQuery = '';
     }
     if ($groupBy) {
         $groupQuery = ' GROUP BY `' . $table . '`.`' . $groupBy . '` ';
     } else {
         $groupQuery = '';
     }
     $query = 'SELECT ' . $fieldsCondenced . ' FROM `' . $table . '` ' . $association . ' ' . $where . $groupQuery . $orderQuery . ' LIMIT :lim OFFSET :ofs';
     if ($isCount) {
         $query = $countSubWrapBegin . $query . $countSubWrapEnd;
     }
     DebugHandler::Log($query);
     $statement = $db->prepare($query);
     $statement->bindValue(':lim', (int) $limit, \PDO::PARAM_INT);
     $statement->bindValue(':ofs', (int) $offset, \PDO::PARAM_INT);
     DebugHandler::Log(var_export($whereParams, true));
     foreach ($whereParams as $paramName => $paramValue) {
         $statement->bindValue($paramName, $paramValue);
     }
     if ($statement->execute() === false) {
         /**
          * @todo make better error
          */
         throw new Exception('There was a problem with the search query! ' . var_export($statement->errorInfo(), true));
     }
     return $statement->fetchAll(\PDO::FETCH_ASSOC | \PDO::FETCH_GROUP);
 }