コード例 #1
0
 function _get_facet_summary(&$ds, $meta, $tree)
 {
     $index_defs = @$meta['search']['index'];
     $facet_defs = $meta['facets'];
     // remove the sort field
     unset($index_defs['sort.default']);
     // get count field
     if (isset($facet_defs['count'])) {
         $count = $facet_defs['count'];
         unset($facet_defs['count']);
     }
     $fields = array();
     // get all fields to sum
     foreach ($facet_defs as $facet) {
         if ($facet['select'] == 'all') {
             continue;
         }
         $fields[] = "SUM(IF({$facet['select']},1,0)) AS '{$facet['name']}'";
     }
     // add count to get total
     if (!isset($count)) {
         $count = isset($meta['fields']['url']['select']) ? 't.' . $meta['fields']['url']['select'] : 't.id';
     }
     $fields[] = "COUNT(DISTINCT {$count}) AS total";
     $fields = join(',', $fields);
     $generator = new SqlGenerator($meta['mysql_table'] . ' t', $fields, $index_defs);
     $sql = $generator->convert($tree);
     $ds->log(4, 'Facets SQL: ' . $sql);
     $r = $this->db->queryAll($sql, NULL, MDB2_FETCHMODE_ASSOC);
     if (PEAR::isError($r)) {
         return $ds->_set_error(500, 'Search (facet summary): ' . $r->message . ' ' . $r->userinfo);
     }
     // typically only 1 row of results is returned, but for union searches multiple rows are returned
     // in this case sum all rows together - this can contain duplicate values, but we will live with it
     if (count($r) <= 1) {
         $accuracy = 'exact';
     } else {
         $accuracy = 'approx';
         $tmp = array();
         for ($i = 0; $i < count($r); $i++) {
             foreach ($r[$i] as $name => $value) {
                 @($tmp[$name] += $value);
             }
         }
         $r = array($tmp);
     }
     // collate results
     $results = array();
     foreach ($facet_defs as $facet) {
         if (!isset($results[$facet['type']])) {
             $results[$facet['type']] = array();
         }
         if ($facet['select'] == 'all') {
             $results[$facet['type']][$facet['name']] = $r[0]['total'];
         } else {
             $results[$facet['type']][$facet['name']] = $r[0][$facet['name']];
         }
     }
     $results['accuracy'] = $accuracy;
     if ($accuracy == 'exact') {
         $results['total'] = $r[0]['total'];
     }
     return $results;
 }
コード例 #2
0
 function update($tabela, $dados, $string)
 {
     if (!$tabela) {
         echo "Informe uma tabela.";
         return false;
     }
     if (!$dados) {
         echo "Informe valores";
         return false;
     }
     if (!$string) {
         echo "Informe condição";
         return false;
     }
     try {
         $this->freeSQL(SqlGenerator::update($table, $dados, $string));
         return true;
     } catch (exception $erro) {
         echo "Não foi possivel alterar registro. FAILL: " . $erro->getMessage();
         return false;
     }
 }