mcustomvalue.class

Ir para a documentação deste ficheiro.

<?php
 
class MCustomValue
{
    const KEY_SEPARATOR = '|';
    
    public $id;
 
    public $customizedId;
 
    public $customFieldId;
 
    public $value;
 
    public function __construct($data=NULL)
    {
        if ( $data )
        {
            $this->setData($data);
        }
    }
 
    private static function getBusiness()
    {
        $MIOLO = MIOLO::getInstance();
        return new MBusiness('admin');
    }
 
    public function setData($data)
    {
        $this->id = $data->id;
        $this->customizedId = $data->customizedId;
        $this->customFieldId = $data->customFieldId;
        $this->value = $data->value;
    }
 
    public function insert($id = null)
    {
        $this->id = $this->getBusiness()->_db->getNewId('miolo_custom_value_id_seq', 'miolo_sequence');
 
        $sql = new MSQL(
            'id, customized_id, custom_field_id, value',
            'miolo_custom_value'
        );
 
        $args = array(
            $this->id,
            $this->customizedId,
            $id ?? $this->customFieldId,
            $this->value,
        );
 
        return self::getBusiness()->execute($sql->insert($args));
    }
 
    public function update($customFieldId = null)
    {
        $sql = new MSQL(
            'customized_id, custom_field_id, value',
            'miolo_custom_value',
            'id = ?'
        );
 
        $args = array(
            $this->customizedId,
            $customFieldId ?? $this->customFieldId,
            $this->value,
            $this->id,
        );
 
        return self::getBusiness()->execute($sql->update($args));
    }
 
    public function updateByData()
    {
        $sql_field = "SELECT id,
                             name
                        FROM miolo_custom_field
                       WHERE name = (SELECT name from miolo_custom_field where id = ?)
                       ORDER BY id";
 
        $cols = array('id',
            'nome',
        );
        $args[] = $this->customFieldId;
        $fields = SAGU::resultToArray(SDatabase::query($sql_field, $args), $cols);
 
        foreach ( $fields as $field )
        {
            $sql_value = new MSQL(
                'value',
                'miolo_custom_value',
                'customized_id = ? AND
                 custom_field_id = ?'
            );
            
            $get = self::getBusiness()->query($sql_value, array($this->customizedId, $field['id']));
            
            if ( count($get->result) == 0 )
            {
                $result = $this->insert($field['id']);
            }
            else
            {
                $values = array('value' => $this->value);
                $where = array('customized_id' => $this->customizedId, 'custom_field_id' =>  $field['id']);   
                $sql = MSQL::updateTable('miolo_custom_value', $values, $where);
                
                $result = self::getBusiness()->Execute($sql);
            }
        }
        return $result;
    }
 
    public function delete()
    {
        if ( !isset($this->id) )
        {
            return false;
        }
 
        $sql = new MSQL('', 'miolo_custom_value', 'id = ?');
        return self::getBusiness()->execute($sql->delete($this->id));
    }
 
    public static function getFieldValues($identifier, $customizedId)
    {
        $sql = new MSQL(
            'miolo_custom_field.id,
             miolo_custom_value.value',
            '',
            'miolo_custom_value.customized_id = ?'
        );
 
        $sql->setLeftJoin(
            'miolo_custom_value',
            'miolo_custom_field',
            'miolo_custom_value.custom_field_id = miolo_custom_field.id AND
             miolo_custom_field.identifier = ?'
        );
 
        $args = array(
            $identifier,
            $customizedId,
        );
 
        $query = self::getBusiness()->query($sql, $args);
 
        $values = new stdClass();
 
        if ( $query->result )
        {
            foreach ( $query->result as $row )
            {
                list($id, $value) = $row;
                $inputId = MCustomField::generateInputId($identifier, $id);
 
                $values->{$inputId} = $value;
            }
        }
 
        return $values;
    }
 
    public static function searchFieldValues($identifier, $searchData, $returnSql = false, $onlyCustomizedid = false, $filters = null)
    {
        $MIOLO = MIOLO::getInstance();
        $db = $MIOLO->getDatabase('admin');
 
        $where = array();
 
        // Adicionados elementos de filtragem para buscar apenas resultados vinculados aos registros filtrados no formulário.
        if ( $filters )
        {
            $finalWhere = array();
            if ($filters->filtroFormularioBusca)
            {
                $finalWhere[] = 'miolo_custom_field.filtroformulariobusca IS ' . ($filters->filtroFormularioBusca ? 'true' : 'false');
            }
 
            if ( count($filters->customizedIds) > 0 )
            {
                $customizedIds = "'" . implode("','", $filters->customizedIds) . "'";
                $finalWhere[] = 'miolo_custom_value.customized_id IN (' . $customizedIds . ')';
            }
        }
 
        foreach ( $searchData as $id => $value )
        {
            if ( $id && $value )
            {
                $value = addslashes($value);
                $where[] = " ( custom_field_id = '{$id}' AND value ILIKE '{$value}%' ) ";
            }
        }
 
        $countWhere = count($where);
        
        if ( $countWhere == 0 )
        {
            $strWhere2 = '';
        }
        else
        {
            $strWhere1 = ' WHERE ' . implode(' OR ', $where);
            $finalWhere[] = " customized_id IN (SELECT customized_id
                                                    FROM miolo_custom_value 
                                              INNER JOIN miolo_custom_field 
                                                      ON custom_field_id = miolo_custom_field.id 
                                                     AND miolo_custom_field.identifier = '{$identifier}'
                                                         {$strWhere1}
                                                GROUP BY customized_id
                                                  HAVING COUNT(*) = {$countWhere}) ";
        }
        
        // 
        $sqlWhere = implode(' AND ', $finalWhere);
 
        if ($onlyCustomizedid)
        {
            $columns = " customized_id ";
        }
        else
        {
            $columns = " miolo_custom_value.id,
                         customized_id,
                         custom_field_id,
                         value ";
        }
 
        $sql = "SELECT {$columns} 
                  FROM miolo_custom_value 
            INNER JOIN miolo_custom_field 
                    ON custom_field_id = miolo_custom_field.id 
                   AND miolo_custom_field.identifier = '{$identifier}'
                   AND {$sqlWhere} 
                   ORDER BY miolo_custom_value.id";
 
        if ($returnSql)
        {
            $sql = (count($finalWhere) > 0 ? $sql : '');
            return $sql;
        }
        else if ( $filters->associative )
        {
            return SDatabase::queryAssociative($sql);
        }
        else
        {
            return $db->query($sql);
        }
    }
 
    public function deleteByCustomizedId()
    {
        $sql = new MSQL('', 'miolo_custom_value', 'customized_id = ? and custom_field_id = ?');
        return self::getBusiness()->execute($sql->delete(array($this->customizedId, $this->customFieldId)));
    }
 
    public static function getMioloCustomValueByCustomized($customizedId, $mioloCustomFieldId)
    {
        $MIOLO = MIOLO::getInstance();
        $sql = 'SELECT value
                  FROM miolo_custom_value
                 WHERE customized_id = ?
                   AND custom_field_id = ?';
        
        $args = [
            $customizedId,
            $mioloCustomFieldId,
        ];
 
        return $MIOLO->getDatabase()->query(SAGU::prepare($sql, $args));
    }
}