<div class="header_tpl">Strings</div> <table cellspacing="0" cellpadding="0" border="0"> <tr class="tr_hdr_tpl"><td>Template</td><td>Key</td><td>Value</td><td>Result</td></tr> <tr class="first_row_tpl"><td>uppercase</td><td>first_name</td><td>#first_name#</td><td>#first_name|uppercase#</td></tr> <tr><td>uppercase</td><td>last_name</td><td>#last_name#</td><td>#last_name|uppercase#</td></tr> <tr><td>lowercase</td><td>addr1</td><td>#addr1#</td><td>#addr1|lowercase#</td></tr> <tr><td>lowercase</td><td>addr2</td><td>#addr2#</td><td>#addr2|lowercase#</td></tr> <tr><td>maxlength</td><td>company</td><td>#company#</td><td>#company|maxlength:11:true#</td></tr> </table> </div> <?php $table = new \core\html\Table(); $table->addAtributos("tr", array("class" => "tr_hdr_tpl")); $table->body(array("Tabela", "Registros", "metadados", "editar")); $table->addAtributos("tr", array("class" => "first_row_tpl")); foreach ($listaTabelas as $lista => $metadados) { $linkMetaDados = '<a href="' . \core\url\Url::setURL("tabelas", "metaDadosTable", array(), null, array('table' => $metadados['TABLE_NAME'])) . '" title="editar metadados da tabela ' . $metadados['TABLE_NAME'] . '">IMG META</a>'; $linkEditar = '<a href="' . \core\url\Url::setURL("tabelas", "visualizarDados", array(), null, array('table' => $metadados['TABLE_NAME'])) . '" title="editar dados da tabela ' . $metadados['TABLE_NAME'] . '">EDITAR DADOS</a>'; $table->body(array($metadados['TABLE_NAME'], $metadados['TABLE_ROWS'], $linkMetaDados, $linkEditar)); } echo '<div class="preview_tpl" id="previewData">'; echo '<div class="header_tpl">Lista de tabelas do sistema</div>'; echo $table->getTable(); echo '</div>'; ?> </body> </html>
/* foreach ( $arrayLabel as $key => $column_name ){ $label[] = $column_name['column_name']; } foreach( $label as $vLabel ){ $dados[] = '<label for="'.$vLabel.'">'.$vLabel.': </label>'; if( $vLabel == $primary_key ){ $dados[] = '<input type="text" name="'.$vLabel.'" value="'.$registroTabela[0][$vLabel].'" readonly="readonly">'; }else{ $dados[] = '<input type="text" name="'.$vLabel.'" value="'.$registroTabela[0][$vLabel].'" >'; } $table->body( $dados ); unset( $dados ); } */ foreach ($output as $value) { $table->body($value); } $table->body(array("", '<input type="submit" name="bEdt" value="Gravar">')); echo '<div class="preview_tpl" id="previewData">'; echo '<div class="header_tpl">Editar registro <b></b></div>'; echo '<form name="edt" method="post" action="' . \core\url\Url::setURL('tabelas', 'save', array($id, ''), null, array('table' => $tabelaAnalise['table'])) . '">'; echo $table->getTable(); echo '</form>'; echo '</div>'; ?> </body> </html>
} </style> </head> <body> <?php $table = new \core\html\Table(); $table->addAtributos("tr", array("class" => "tr_hdr_tpl")); foreach ($cabecalhoTabela as $key => $column_name) { $cabecalho[] = $column_name['column_name']; } # define o cabeçalho da tabela //$cabecalhoTabela = array_keys( $metaDadosTabela[0] ); $cabecalho[] = "editar"; $cabecalho[] = "excluir"; //$table->body( array_keys( $dadosTabela[0] ) ); $table->body($cabecalho); $table->addAtributos("tr", array("class" => "first_row_tpl")); //debug(__FILE__, __LINE__, array_keys($metaDataTable[0]) ); foreach ($dadosTabela as $row => $dados) { /* * é necessário a identificação automática da chave primária para * a composição do href */ $linkEditarDado = '<a href="' . \core\url\Url::setURL("tabelas", "edt", array($dados[$primary_key], ""), null, array("table" => $tabelaAnalise['table'])) . '" title="Editar linha">Editar</a>'; $linkExcluirDado = '<a href="" title="Excluir dado">Excluir</a>'; $dados[] = $linkEditarDado; $dados[] = $linkExcluirDado; $table->body($dados); } echo '<div class="preview_tpl" id="previewData">'; echo '<div class="header_tpl">Metadados da tabela <b>' . $tabelaAnalise['table'] . '</b></div>';
addr1: "Upton Avenue 1870", addr2: "Liberty Square 4949", company: "Monk Home Loans" }; var parentObj = document.getElementById("previewData"); parentObj.innerHTML = window.dhx4.template(parentObj.innerHTML, data); } </script> </head> <body onload="doOnLoad();"> <?php $table = new \core\html\Table(); $table->addAtributos("tr", array("class" => "tr_hdr_tpl")); # define o cabeçalho da tabela $table->body(array_keys($metaDataTable[0])); $table->addAtributos("tr", array("class" => "first_row_tpl")); //debug(__FILE__, __LINE__, array_keys($metaDataTable[0]) ); foreach ($metaDataTable as $row => $metadados) { //$linkMetaDados = '<a href="'..'" title="editar metadados da tabela '.$metadados['TABLE_NAME'].'">IMG META</a>'; //$linkEditar = '<a href="'..'" title="editar dados da tabela '.$metadados['TABLE_NAME'].'">EDITAR DADOS</a>'; //$table->body(array($metadados['TABLE_NAME'], $metadados['TABLE_ROWS'])); $table->body($metadados); } echo '<div class="preview_tpl" id="previewData">'; echo '<div class="header_tpl">Metadados da tabela <b>' . $tabelaAnalise['table'] . '</b></div>'; echo $table->getTable(); echo '</div>'; echo '<div><a href="' . \core\url\Url::setURL("tabelas", "visualizarDados", array(), null, array('table' => $tabelaAnalise['table'])) . '" title="Administrar dados da tabela ' . $tabelaAnalise['table'] . '">Administrar dados da tabela</a></div>'; ?>