Lançado Adianti Framework 7.6!
Clique aqui para saber mais
menu
Adianti Framework
A base robusta e open-source para criar sistemas com agilidade e código limpo.
Adianti Reports & BI
Dashboards analíticos e Relatórios para Empresas e Produtores de Software.
Mentoring
Auxilio de especialista para o desenvolvimento decolar.
Treinamento
Capacitação oficial com profissionais Adianti.
Outsourcing
Desenvolvimento de aplicações sob demanda.

Adianti Solutions

API

 Adianti, Framework, PHP, MVC, Active record, Front controller, IDE, RAD, Web, multiplataforma, geração de código, desenvolvimento rápido, relatórios, formulários, listagens, datagrids, gráficos, banco de dados, padrões de projeto, design patterns API do Adianti Framework.
API Docs
code
Selecione a classe

Source for file AdiantiMultiSearchService.php

Documentation is available at AdiantiMultiSearchService.php

  1. <?php
  2. namespace Adianti\Service;
  3.  
  4. use Adianti\Core\AdiantiApplicationConfig;
  5. use Adianti\Util\AdiantiStringConversion;
  6. use Adianti\Database\TTransaction;
  7. use Adianti\Database\TRepository;
  8. use Adianti\Database\TCriteria;
  9. use Adianti\Database\TFilter;
  10. use Adianti\Database\TExpression;
  11.  
  12. use StdClass;
  13. use Exception;
  14.  
  15. /**
  16.  * MultiSearch backend
  17.  *
  18.  * @version    7.4
  19.  * @package    service
  20.  * @author     Pablo Dall'Oglio
  21.  * @author     Matheus Agnes Dias
  22.  * @copyright  Copyright (c) 2006 Adianti Solutions Ltd. (http://www.adianti.com.br)
  23.  * @license    http://www.adianti.com.br/framework-license
  24.  */
  25. class AdiantiMultiSearchService
  26. {
  27.     /**
  28.      * Search by the given word inside a model
  29.      */
  30.     public static function onSearch($param = null)
  31.     {
  32.         $key  = $param['key'];
  33.         $ini  = AdiantiApplicationConfig::get();
  34.         $seed = APPLICATION_NAME . ( !empty($ini['general']['seed']) ? $ini['general']['seed'] : 's8dkld83kf73kf094' );
  35.         $hash = md5("{$seed}{$param['database']}{$param['key']}{$param['column']}{$param['model']}");
  36.         $mask = $param['mask'];
  37.         
  38.         if ($hash == $param['hash'])
  39.         {
  40.             try
  41.             {
  42.                 TTransaction::openFake($param['database']);
  43.                 $info = TTransaction::getDatabaseInfo();
  44.                 $default_op = $info['type'] == 'pgsql' ? 'ilike' : 'like';
  45.                 $operator   = !empty($param['operator']) ? $param['operator'] : $default_op;
  46.                 
  47.                 $repository = new TRepository($param['model']);
  48.                 $criteria = new TCriteria;
  49.                 if ($param['criteria'])
  50.                 {
  51.                     $criteria = unserialize( base64_decode(str_replace(array('-', '_'), array('+', '/'), $param['criteria'])) );
  52.                 }
  53.     
  54.                 $columns = explode(',', $param['column']);
  55.                 
  56.                 if (!isset($param['value']))
  57.                 {
  58.                     $param['value'] = '';
  59.                 }
  60.                 
  61.                 if ($columns)
  62.                 {
  63.                     $dynamic_criteria = new TCriteria;
  64.                     
  65.                     if (empty($param['onlyidsearch']))
  66.                     {
  67.                         foreach ($columns as $column)
  68.                         {
  69.                             if (stristr(strtolower($operator),'like') !== FALSE)
  70.                             {
  71.                                 $param['value'] = str_replace(' ', '%', $param['value']);
  72.                                 
  73.                                 if (in_array($info['type'], ['mysql', 'oracle', 'mssql', 'dblib', 'sqlsrv']))
  74.                                 {
  75.                                     $filter = new TFilter("lower({$column})", $operator, strtolower("%{$param['value']}%"));
  76.                                 }
  77.                                 else
  78.                                 {
  79.                                     $filter = new TFilter($column, $operator, "%{$param['value']}%");
  80.                                 }
  81.                             }
  82.                             else
  83.                             {
  84.                                 $filter = new TFilter($column, $operator, $param['value']);
  85.                             }
  86.         
  87.                             $dynamic_criteria->add($filter, TExpression::OR_OPERATOR);
  88.                         }
  89.                     }
  90.                     
  91.                     $id_search_value = ((!empty($param['idtextsearch']) && $param['idtextsearch'] == '1') || ((defined("{$param['model']}::IDPOLICY")) AND (constant("{$param['model']}::IDPOLICY") == 'uuid'))) ? $param['value'] : (int) $param['value'];
  92.                     
  93.                     if ($param['idsearch'] == '1' and !empty( $id_search_value ))
  94.                     {
  95.                         $dynamic_criteria->add( new TFilter($key, '=', $id_search_value), TExpression::OR_OPERATOR);
  96.                     }
  97.                 }
  98.                 
  99.                 if (!$dynamic_criteria->isEmpty())
  100.                 {
  101.                     $criteria->add($dynamic_criteria, TExpression::AND_OPERATOR);
  102.                 }
  103.                 $criteria->setProperty('order', $param['orderColumn']);
  104.                 $criteria->setProperty('limit', 1000);
  105.                 
  106.                 $items = array();
  107.                 
  108.                 if (!empty($param['value']) || $param['minlength'] == '0')
  109.                 {
  110.                     $collection = $repository->load($criteria, FALSE);
  111.                     
  112.                     foreach ($collection as $object)
  113.                     {
  114.                         $k = $object->$key;
  115.                         $maskvalues = $mask;
  116.                         
  117.                         $maskvalues = $object->render($maskvalues);
  118.                         
  119.                         // replace methods
  120.                         $methods = get_class_methods($object);
  121.                         if ($methods)
  122.                         {
  123.                             foreach ($methods as $method)
  124.                             {
  125.                                 if (stristr($maskvalues, "{$method}()") !== FALSE)
  126.                                 {
  127.                                     $maskvalues = str_replace('{'.$method.'()}', $object->$method(), $maskvalues);
  128.                                 }
  129.                             }
  130.                         }
  131.                         
  132.                         $c = $maskvalues;
  133.                         if ( $k != null && $c != null )
  134.                         {
  135.                             $c = AdiantiStringConversion::assureUnicode($c);
  136.                             
  137.                             if (!empty($k) && !empty($c))
  138.                             {
  139.                                 $items[] = "{$k}::{$c}";
  140.                             }
  141.                         }
  142.                     }
  143.                 }
  144.                 
  145.                 $ret = array();
  146.                 $ret['result'] = $items;
  147.                 echo json_encode($ret);
  148.                 TTransaction::close();
  149.             }
  150.             catch (Exception $e)
  151.             {
  152.                 $ret = array();
  153.                 $ret['result'] = array("1::".$e->getMessage());
  154.                 
  155.                 echo json_encode($ret);
  156.             }
  157.         }
  158.     }
  159. }
© Adianti Solutions     Política de privacidade