Esempio n. 1
0
 protected function processSource(Source $source)
 {
     $params = $source->getParameters();
     $datasource = $source->getDatasource();
     if (is_numeric($datasource)) {
         $datasource = $this->simu->getDatasourceById((int) $datasource);
     } else {
         $datasource = $this->simu->getDatasourceByName($datasource);
     }
     switch ($datasource->getType()) {
         case 'uri':
             $query = "";
             $path = "";
             $datas = array();
             foreach ($params as $param) {
                 $value = $this->formatParamValue($param);
                 if ($value === null) {
                     return null;
                 }
                 if ($param->getType() == 'path') {
                     $path .= "/" . $value;
                 } elseif ($param->getType() == 'data') {
                     $name = $param->getName();
                     if (isset($datas[$name])) {
                         $datas[$name][] = $value;
                     } else {
                         $datas[$name] = array($value);
                     }
                 } else {
                     $query .= "&" . $param->getName() . "=" . $value;
                 }
             }
             $uri = $datasource->getUri();
             if ($path != "") {
                 $uri .= $path;
             }
             if ($query != "") {
                 $uri .= "?" . substr($query, 1);
             }
             if (isset($this->uricache[$uri])) {
                 $result = $this->uricache[$uri];
             } else {
                 $client = Client::createClient();
                 if ($datasource->getMethod() == "GET") {
                     $result = $client->get($uri);
                 } else {
                     $result = $client->post($uri, $data);
                 }
                 $this->uricache[$uri] = $result;
             }
             break;
         case 'database':
         case 'internal':
             $args = array();
             $args[] = $source->getRequest();
             foreach ($params as $param) {
                 $value = $this->formatParamValue($param);
                 if ($value === null) {
                     return null;
                 }
                 $args[] = $value;
             }
             $query = call_user_func_array('sprintf', $args);
             $database = $this->simu->getDatabaseById($datasource->getDatabase());
             $database->connect();
             $result = $database->query($query);
             break;
     }
     switch ($source->getReturnType()) {
         case 'singleValue':
             return $result;
         case 'json':
             $returnPath = $source->getReturnPath();
             $returnPath = $this->replaceVariables($returnPath);
             $json = json_decode($result, true);
             $result = ResultFilter::filter("json", $json, $returnPath);
             return $result;
         case 'assocArray':
             $returnPath = $source->getReturnPath();
             $returnPath = $this->replaceVariables($returnPath);
             $keys = explode("/", $returnPath);
             foreach ($keys as $key) {
                 if (preg_match("/^([^\\[]+)\\[([^\\]]+)\\]\$/", $key, $matches)) {
                     $key1 = $matches[1];
                     if (!isset($result[$key1])) {
                         break;
                     }
                     $result = $result[$key1];
                     $key = $matches[2];
                 }
                 if (ctype_digit($key)) {
                     $key = (int) $key;
                 }
                 if (!isset($result[$key])) {
                     break;
                 }
                 $result = $result[$key];
             }
             return $result;
         case 'html':
             $returnPath = $source->getReturnPath();
             $returnPath = $this->replaceVariables($returnPath);
             $result = ResultFilter::filter("html", $result, $returnPath, $datasource->getNamespaces());
             return $result;
         case 'xml':
             $returnPath = $source->getReturnPath();
             $returnPath = $this->replaceVariables($returnPath);
             $result = ResultFilter::filter("xml", $result, $returnPath, $datasource->getNamespaces());
             return $result;
         case 'csv':
             $returnPath = $source->getReturnPath();
             $returnPath = $this->replaceVariables($returnPath);
             $result = ResultFilter::filter("csv", $result, $returnPath, null, $source->getSeparator(), $source->getDelimiter());
             return $result;
     }
     return null;
 }
Esempio n. 2
0
 protected function processSource($source)
 {
     $ds = (string) $source['datasource'];
     if (is_numeric($ds)) {
         $datasources = $this->datasources->xpath("/DataSources/DataSource[@id='" . $ds . "']");
     } else {
         $datasources = $this->datasources->xpath("/DataSources/DataSource[@name='" . $ds . "']");
     }
     switch ((string) $datasources[0]['type']) {
         case 'uri':
             $uri = (string) $datasources[0]['uri'];
             $client = Client::createClient();
             $data = array();
             // TODO : add parameters elements in DataSources.xsd
             if ((string) $datasources[0]['method'] == "" || (string) $datasources[0]['method'] == "GET") {
                 $result = $client->get($uri);
             } else {
                 $result = $client->post($uri, $data);
             }
             break;
         case 'database':
         case 'internal':
             $databases = $this->datasources->xpath("/DataSources/Databases/Database[@id='" . (string) $datasources[0]['database'] . "']");
             $database = new Database(null, (int) $databases[0]['id'], (string) $databases[0]['type'], (string) $databases[0]['name']);
             if ((string) $databases[0]['host'] != "") {
                 $database->setHost((string) $databases[0]['host']);
             }
             if ((string) $databases[0]['port'] != "") {
                 $database->setPort((int) $databases[0]['port']);
             }
             if ((string) $databases[0]['user'] != "") {
                 $database->setUser((string) $databases[0]['user']);
             }
             if ((string) $databases[0]['password'] != "") {
                 $database->setPassword((string) $databases[0]['password']);
             } elseif ((string) $databases[0]['user'] != "") {
                 try {
                     $host = $this->get('kernel')->getContainer()->getParameter('database_host');
                     $port = $this->get('kernel')->getContainer()->getParameter('database_port');
                     $user = $this->get('kernel')->getContainer()->getParameter('database_user');
                     if ((string) $databases[0]['host'] == $host && (string) $databases[0]['port'] == $port && (string) $databases[0]['user'] == $user) {
                         $database->setPassword($this->get('kernel')->getContainer()->getParameter('database_password'));
                     }
                 } catch (\Exception $e) {
                 }
             }
             $query = (string) $source['request'];
             $database->connect();
             $result = $database->query($query);
             break;
     }
     switch ((string) $source['returnType']) {
         case 'json':
             $json = json_decode($result, true);
             return ResultFilter::filter("json", $json, (string) $source['returnPath']);
         case 'assocArray':
             return $this->filterResultByLines($result, (string) $source['returnPath']);
         case 'xml':
             return ResultFilter::filter("xml", $result, (string) $source['returnPath']);
         case 'csv':
             $result = ResultFilter::filter("csv", $result, "", null, (string) $source['separator'], (string) $source['delimiter']);
             return $this->filterResultByLines($result, (string) $source['returnPath']);
     }
     return null;
 }