*/
class Bvb_Grid_Deploy_Table extends Bvb_Grid_DataGrid
{
public $templateInfo;
protected $messageOk;
/**
* [PT] Se o formulário foi submetido com sucesso
*
* @var bool
*/
protected $formSuccess = 0;
/**
* [PT] Se o formulário foi submetido
*
* @var bool
*/
protected $formPost = 0;
/**
* [PT] Guarda os valores dos forms se der erro
*/
protected $_formValues = array ();
/**
* [PT] AS mensagens de erro no form
*
* @var unknown_type
*/
protected $_formMessages = array ();
protected $output = 'table';
/**
* [PT] Permissão para adicionar
* [EN] Permission to add records
*
* @var array
*/
private $allowAdd = null;
/**
* [PT] Permissão para editar registos
* [EN] Permission to edit records
*
* @var array
*/
private $allowEdit = null;
/**
* [PT] Permissão para remove registos
* [EN] Permission to delete records
*
* @var array
*/
private $allowDelete = null;
/**
* [PT] String com a mensagem depois de submetido o formulario
* [EN] Message after form submission
*
* @var string
*/
public $message;
/**
* [PT] Dados do template
* [EN] Template data
*
* @var array
*/
public $template;
protected $_editNoForm;
/**
* [PT] A url das imagens para exportação
*
* @var string
*/
public $imagesUrl;
/**
* [PT] Se quando é permitido adicionar registo, mostramos as duas tabelas
* [PT] uma com os registos e a outra com os formulários
*
* @var bool
*/
protected $double_tables = 0;
/**
* [PT] Set se falhar a validação do formulario
* [EN] Set if form vaidation failed
*
* @var bool
*/
protected $_failedValidation;
/**
* [PT] Utilizado para receber os dados de remoção de registos
* [EN] Url param with the information about removing records
*
* @var string
*/
protected $_comm;
/**
* [PT] o template
*
* @var object
*/
public $temp;
/**
* [PT] A função __construct recebe o adapter para se liga à base de dados
* [PT] É também tratada toda a informação relacionada com a url e os params
* [PT] É também instaciada o Auth do Zend_Auth. A autenticação deve ter sido
* [PT] Efectuada utilizando o método store, para agora poder validar o user
*
* [EN] The __construct function receives the db adapter. All information related to the
* [EN] URL is also processed here
* [EN] To edit, add, or delete records, a user must be authenticated, so we instanciate
* [EN] it here. Remember to use the method write when autenticating a user, so we can know
* [EN] if its logged or not
*
* @param array $data
*/
function __construct($db)
{
parent::__construct ( $db );
$this->setTemplate ( 'table', 'table' );
}
/**
* [Para podemros utiliza]
*
* @param string $var
* @param string $value
*/
function __set($var, $value)
{
parent::__set ( $var, $value );
}
function getFieldType($type, $table)
{
$fields = $this->getDescribeTable ( $table );
return $fields [$type] ['DATA_TYPE'];
}
/**
*
* [PT] Aqui é processada toda a informação relacionada com os formulários
* [PT] Verificamos se o utilizador pode ou não adicionar dados e
* [PT] Depois verificamos o o request->method para saber se é post. Se for processamos
*
* [EN] Process all infmation forms related
* [EN] First we check for pemrissions to add, edit, delete
* [EN] And then the request->isPost. If true we process the data
*
*/
protected function processForm()
{
$pk = parent::getPrimaryKey ();
if (@$this->info ['add'] ['allow'] == 1 && ! is_array ( $this->data ['table'] ) && $pk)
{
$this->allowAdd = 1;
}
if (@$this->info ['delete'] ['allow'] == 1 && ! is_array ( $this->data ['table'] ) && $pk)
{
$this->allowDelete = 1;
}
if (@$this->info ['edit'] ['allow'] == 1 && ! is_array ( $this->data ['table'] ) && $pk)
{
$this->allowEdit = 1;
}
//[PT] Se podermos remover ou editar, temos que inicializar a classe de encriptação
//[PT] Para remover enviamos os parametros pela URL encriptados. Para editar enviamos uma flag
//[EN] IF a user can edit or delete data we must instanciate the crypt classe.
//[EN] This is an extra-security step.
if ($this->allowEdit == 1 || $this->allowDelete)
{
$dec = isset ( $this->ctrlParams ['comm'] ) ? $this->ctrlParams ['comm'] : '';
$this->_comm = $dec;
}
/**
* [PT] Remover se houver alguma coisa a remover
* [EN] emove if there is something to remove
*/
if ($this->allowDelete)
{
self::deleteRecord ( $dec );
}
if (Zend_Controller_Front::getInstance ()->getRequest ()->isPost ())
{
$param = Zend_Controller_Front::getInstance ()->getRequest ();
$opComm = isset ( $this->ctrlParams ['comm'] ) ? $this->ctrlParams ['comm'] : '';
$op_query = self::convertComm ( $opComm );
$get_mode = isset ( $op_query ['mode'] ) ? $op_query ['mode'] : '';
$mode = $get_mode == 'edit' ? 'edit' : 'add';
//[PT] Temos que saber quais os campos que vamos buscar ao Post. Só vamos buscar os nomes
//[PT] Dos campos da tabela da base de dados.
//[PT] Temos por isso que verificar se o utilizador definiu campos a serem processados
//[PT] Ou se são para processar todos
//[EN] We mst know what fields to get with getPost(). We only gonna get the fieds
//[EN] That belong to the database table. We must ensure we process the right data.
//[EN] So we also must verify if have been defined the fields to process
if (is_array ( $this->info [$mode] ['fields'] ))
{
$fields = array ();
foreach ( $this->info [$mode] ['fields'] as $key => $value )
{
$fields [$key] = $key;
}
} else
{
$fields = parent::getFields ( $mode, $this->data ['table'] );
}
//[PT] APlicar os filtros e a validalção. Primeiro são aplicados os filtros
//[EN] Apply filter and validators. Firtst we apply the filters
foreach ( $fields as $value )
{
$this->_formValues [$value] = $param->getPost ( $value );
$fieldType = $this->getFieldType ( $value, $this->data ['from'] );
if (substr ( $fieldType, 0, 3 ) != 'set')
{
$result = self::applyFilters ( $param->getPost ( $value ), $value, $mode );
$result = self::Validate ( $result, $value, $mode );
} else
{
$possibleValuesForSetField = explode ( ",", str_replace ( array ('(', ')', '\'', 'set' ), array ('', '', '', '' ), $fieldType ) );
if (is_array ( $param->getPost ( $value ) ))
{
$finalValue = array_intersect ( $possibleValuesForSetField, $param->getPost ( $value ) );
} else
{
$finalValue = null;
}
if (count ( $finalValue ) > 0)
{
$result = implode ( ',', $finalValue );
} else
{
$result = '';
}
}
$final [$value] = $result;
}
//[PT] Se passou na validação
//[EN] If pass validation
if ($this->_failedValidation !== true)
{
//[PT] vamos saber se existem campos com entrada forçada.
//[EN] Check ig the user has defined "force" fields. If so we need to merge them
//[EN] With the ones we get from the form process
$force = $this->info [$mode] ['force'];
if (is_array ( $force ))
{
$final_values = array_merge ( $final, $force );
} else
{
$final_values = $final;
}
unset ( $final_values [parent::getPrimaryKey ()] );
//[PT] Processar dados
//[EN] Process data
if ($mode == 'add' && is_array ( $final_values ))
{
$this->_db->insert ( $this->data ['table'], $final_values );
$this->message = $this->__ ( 'Record saved' );
$this->messageOk = true;
}
//[PT] Processar dados
//[EN] Process data
if ($mode == 'edit' && is_array ( $final_values ))
{
if (isset ( $this->info ['edit'] ['where'] ))
{
$where = " AND " . $this->info ['edit'] ['where'];
} else
{
$where = '';
}
$this->_db->update ( $this->data ['table'], $final_values, " $pk=" . $this->_db->quote ( $op_query ['id'] ) . " $where " );
$this->message = $this->__ ( 'Record saved' );
$this->messageOk = true;
//[PT] Notificar que ja nao é preciso mostrar o form
$this->_editNoForm = 1;
unset ( $this->ctrlParams ['comm'] );
unset ( $this->ctrlParams ['edit'] );
}
if ($this->cache ['use'] == 1)
{
$this->cache ['instance']->clean ( Zend_Cache::CLEANING_MODE_MATCHING_TAG, array ($this->cache ['tag'] ) );
}
$this->formSuccess = 1;
} else
{
$this->message = $this->__ ( 'Validation failed' );
$this->messageOk = false;
$this->formSuccess = 0;
$this->formPost = 1;
$final_values = null;
}
//[PT] Agone unset todos os campso, para aurl não ficar comprida. $this->getUrl
//[EN] Unset all params so we can have a more ckean URl when calling $this->getUrl
if (is_array ( $final_values ))
{
foreach ( $final_values as $key => $value )
{
unset ( $this->ctrlParams [$key] );
}
}
}
}
/**
* [PT] Aplicar os filtros ao formulário. Os filtros são aplicados usando
* [PT] os que vem por defeito na ZF
*
* [EN] Apply filter susing the Zend Framework set.
*
* @param string $value
* @param string $field
* @param string $mode
* @return string
*/
function applyFilters($value, $field, $mode)
{
$filters = isset ( $this->info [$mode] ['fields'] [$field] ['filters'] ) ? $this->info [$mode] ['fields'] [$field] ['filters'] : '';
if (is_array ( $filters ))
{
//[PT] OK. Tem filtros para aplicar. Vamos buscar os dirs
foreach ( $filters as $func )
{
$class = $this->_elements ['filter']->load ( $func );
$t = new $class ( );
$value = $t->filter ( $value );
}
}
return $value;
}
/**
* [PT] Validar o formulário usando as funções por defeito da ZF
*
* [EN] Validate fields using the set on he Zend Framework
*
* @param string $value
* @param string $field
* @param string $mode
* @return string
*/
function Validate($value, $field, $mode = 'edit')
{
//[PT] Array de valores possiveis
$values = isset ( $this->info [$mode] ['fields'] [$field] ['values'] ) ? $this->info [$mode] ['fields'] [$field] ['values'] : '';
//[PT]A Lista de possiveis "validadores"
$validators = isset ( $this->info [$mode] ['fields'] [$field] ['validators'] ) ? $this->info [$mode] ['fields'] [$field] ['validators'] : '';
//[PT] Podemos validar logo se o valor estiver na array de valores permitidos
if (is_array ( $values ) && $mode == 'edit')
{
if (! in_array ( $value, $values ))
{
$this->_failedValidation = true;
return false;
}
} elseif (is_array ( $validators ))
{
foreach ( $validators as $key => $func )
{
if (is_array ( $validators [$key] ))
{
$func = $key;
}
$class = $this->_elements ['validator']->load ( $func );
//[PT] Se for array, significa que o Zend_Validate recebe argumentos
//[EN] If an array, means the Validator receives arguments
if (is_array ( $validators [$key] ))
{
//[PT] Se for array, significa que o Zend_Validate recebe argumentos
//[EN] If an array, means the Validator receives arguments
$t = new $class ( implode ( ',', $validators [$key] ) );
$return = $t->isValid ( $value );
if ($return === false)
{
$this->_failedValidation = true;
foreach ( $t->getMessages () as $messageId => $message )
{
$this->_formMessages [$field] [] = array ($messageId => $message );
}
return false;
}
} else
{
$t = new $class ( );
$return = $t->isValid ( $value );
if ($return === false)
{
$this->_failedValidation = true;
foreach ( $t->getMessages () as $messageId => $message )
{
$this->_formMessages [$field] [] = array ($messageId => $message );
}
return false;
}
}
}
}
return $value;
}
/*
/**
* [PT] Remover da base de dados
* [PT] Não esquecer de verificar se o utilizador anexou um WHERE
* [PT] O que significa que temos de o junter a query
* [EN] Remove the record from the table
* [EN] Don't forget to see if the user as set an "extra" WHERE.
*
* @param string $sql
* @param string $user
* @return string
*/
function deleteRecord($sql)
{
$param = explode ( ";", $sql );
foreach ( $param as $value )
{
$dec = explode ( ":", $value );
@$final [$dec [0]] = $dec [1];
}
if (@$final ['mode'] != 'delete')
{
return 0;
}
$id = $this->_db->quoteIdentifier ( parent::getPrimaryKey () );
if (isset ( $this->info ['delete'] ['where'] ))
{
$where = " AND " . $this->info ['delete'] ['where'];
} else
{
$where = '';
}
try
{
if (is_array ( $this->info ['delete'] ['cascadeDelete'] ))
{
foreach ( $this->info ['delete'] ['cascadeDelete'] as $value )
{
$operand = isset ( $value ['operand'] ) ? $value ['operand'] : '=';
$parentField = isset ( $value ['parentField'] ) ? $value ['parentField'] : $this->getPrimaryKey ();
if ($parentField != $this->getPrimaryKey ())
{
$finalValue = $this->_db->fetchOne ( "SELECT " . $this->_db->quoteIdentifier ( $parentField ) . " FROM " . $this->_db->quoteIdentifier ( $this->data ['table'] ) . " WHERE id=" . $this->_db->quote ( $final ['id'] ) );
} else
{
$finalValue = $final ['id'];
}
$this->_db->delete ( $value ['table'], $this->_db->quoteIdentifier ( $value ['childField'] ) . $operand . $this->_db->quote ( $finalValue ) );
}
}
$this->_db->delete ( $this->data ['table'], " $id =" . $this->_db->quote ( $final ['id'] ) . " $where " );
} catch ( Zend_Exception $e )
{
$this->messageOk = FALSE;
$this->message = $this->__ ( 'Error deleting record =>' ) . $e->getMessage ();
}
if ($this->cache ['use'] == 1)
{
$this->cache ['instance']->clean ( Zend_Cache::CLEANING_MODE_MATCHING_TAG, array ($this->cache ['tag'] ) );
}
return true;
}
/**
* [PT] Formatar o tipo de campo nos filtros
* [PT] Ou do tipo select ou text
*
* [EN] Field type on the filters area. If the field type is enum, build the options
* [EN] Also, we first need to check if the user has defined values to presente.
* [EN] If set, this values override the others
*
* @param string $campo
* @param string $valor
* @return string
*/
function formatField($campo, $valor, $options = array())
{
$url = parent::getUrl ( array ('filters', 'start', 'comm' ) );
if (! is_array ( $this->data ['table'] ))
{
$table = parent::getDescribeTable ( $this->data ['table'] );
} else
{
$ini = substr ( $campo, 0, (strpos ( $campo, "." )) );
$table = parent::getDescribeTable ( $this->data ['table'] [$ini] );
}
$tipo = $table [$campo];
$tipo = $tipo ['DATA_TYPE'];
if (substr ( $tipo, 0, 4 ) == 'enum')
{
$enum = str_replace ( array ('(', ')' ), array ('', '' ), $tipo );
$tipo = 'enum';
}
foreach ( array_keys ( $this->filters ) as $value )
{
if (! $this->data ['fields'] [$value] ['hide'])
{
$help_javascript .= "filter_" . $value . ",";
}
}
if ($options ['noFilters'] != 1)
{
$onchange = "onchange=\"changeFilters('$help_javascript','$url');\" id=\"filter_{$campo}\"";
}
$opcoes = $this->filters [$campo];
if ($opcoes ['style'])
{
$opt = " style=\"{$opcoes['style']}\" ";
} else
{
$opt = " style=\"width:95%\" ";
}
if (is_array ( $opcoes ['valores'] ))
{
$tipo = 'invalid';
$avalor = $opcoes ['valores'];
$valor = "";
}
switch ($tipo)
{
case 'invalid' :
break;
case 'enum' :
$avalor = explode ( ",", substr ( $enum, 4 ) );
$valor = "";
break;
default :
$valor = "_filtersValues [$campo] . "\" $opt>";
break;
}
return $valor;
}
/**
* [PT] Construir o header da tabela (a primeira linha e nao os titulos)
*
* [EN] Build the first line of the table (Not the TH )
*
* @return string
*/
function buildHeader()
{
$url = parent::getUrl ( array ('comm', 'edit', 'filters', 'order' ) );
$final = '';
if ($this->_adapter == 'db')
{
if ((@$this->info ['double_tables'] == 0 && @$this->ctrlParams ['add'] != 1 && @$this->ctrlParams ['edit'] != 1) && $this->getPrimaryKey () && @$this->info ['add'] ['allow'] == 1 && @$this->info ['add'] ['button'] == 1 && @$this->info ['add'] ['no_button'] != 1)
{
$final = "