function listar_cad_documento_item($cod_documento)
{
/////////////////////////////////////////////////////////////////////////////
function tbody($codigo_lancamento, $cod_projeto, $cod_ctr_custo, $cod_conta, $historico, $montante, $data_vencimento_liquidacao)
{
if (intval($_GET['id']) > 0) {
$disabled = " disabled ";
} else {
$disabled = " ";
}
return "<tr id='rowToClone'>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 20px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<input " . $disabled . " coluna='codigo_lancamento' id='codigo_lancamento' placeholder='' onchange='calcular_total_debito_credito();' onkeyup='calcular_total_debito_credito();' class='uk-form-small' type='text' style='width: 100%;' value='" . $codigo_lancamento . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 150px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<div class='uk-autocomplete uk-form' data-uk-autocomplete='{source:bs_projeto}' style='width: 100%;'>\n\t\t\t\t\t\t\t\t<input " . $disabled . " coluna='cod_projeto' id='cod_projeto' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $cod_projeto . "'>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 150px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<div class='uk-autocomplete uk-form' data-uk-autocomplete='{source:bs_ctrcusto}' style='width: 100%;'>\n\t\t\t\t\t\t\t\t<input " . $disabled . " coluna='cod_ctr_custo' id='cod_ctr_custo' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $cod_ctr_custo . "'>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 150px;padding: 0px 6px;'>\n\t\t\t\t\t\t\t<div class='uk-autocomplete uk-form' data-uk-autocomplete='{source:bs_conta}' style='width: 100%;'>\n\t\t\t\t\t\t\t\t<input " . $disabled . " coluna='cod_conta' id='cod_conta' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $cod_conta . "'>\n\t\t\t\t\t\t\t</div>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 200px;padding: 0px 5px; '><input " . $disabled . " coluna='historico_' id='historico_' placeholder='' class='uk-form-small' type='text' style='width: 100%;' value='" . $historico . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 100px;padding: 0px 5px;'><input " . $disabled . " coluna='montante' id='montante' placeholder='' class='uk-form-small' type='text' style='width: 100%;text-align: right;' onchange='formatar_numero(this);calcular_total_debito_credito();' onkeyup='formatar_numero(this);calcular_total_debito_credito();' value='" . $montante . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 100px;padding: 0px 5px;'><input " . $disabled . " coluna='data_vencimento_liquidacao' id='data_vencimento_liquidacao' placeholder='' class='uk-form-small' type='text' style='width: 100%;' onchange='formatar_data(this);' onkeyup='formatar_data(this);' value='" . $data_vencimento_liquidacao . "'></td>\n\t\t\t\t\t\t<td class='uk-form-row' style='width: 10px;padding: 0px 5px;'>\n\t\t\t\t\t\t\t<button " . $disabled . " class='uk-button uk-button-mini uk-button-danger' type='button' onclick=delRow(this,'tableToModify') data-uk-tooltip title='Excluir linha'><i class='uk-icon-trash-o'></i></button>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t</tr>";
}
if (intval($_GET['id']) > 0) {
$tbody = "";
} else {
$tbody = tbody('', '', '', '', '', '', '');
}
include "config.php";
$select = "\n\t\t\t\t\tSELECT \n\t\t\t\t\t\t\tcad_documento_item.cod_documento_item, \n\t\t\t\t\t\t\tcad_documento_item.cod_documento, \n\t\t\t\t\t\t\tcad_documento_item.numero_item, \n\t\t\t\t\t\t\tcad_documento_item.codigo_lancamento,\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tconcat(cad_projeto.cod_projeto,' - ', cad_projeto.nome_projeto) as cod_projeto,\n\t\t\t\t\t\t\tconcat(cad_conta.numero_conta,' - ', cad_conta.descricao) as cod_conta,\n\t\t\t\t\t\t\tconcat(cad_centro_custo.numero_centro_custo,' - ', cad_centro_custo.descricao) as cod_ctr_custo,\n\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tmontante, \n\t\t\t\t\t\t\thistorico, \n\n\t\t\t\t\t\t\tDATE_FORMAT(data_vencimento_liquidacao,'%d/%m/%Y') as data_vencimento_liquidacao,\n\t\t\t\t\t\t\tcod_documento_compensacao\n\t\t\t\t\t FROM \n\t\t\t\t\t\t" . $schema_projetos . ".cad_projeto, \n\t\t\t\t\t\t" . $schema . ".cad_documento_item, \n\t\t\t\t\t\t" . $schema . ".cad_conta,\n\t\t\t\t\t\t" . $schema . ".cad_centro_custo \n\t\t\t\t\t\t\n\t\t\t\t\t\twhere \n\t\t\t\t\t\t\tcad_documento_item.cod_projeto=cad_projeto.cod_projeto and\n\t\t\t\t\t\t\tcad_documento_item.cod_conta=cad_conta.cod_conta and\n\t\t\t\t\t\t\tcad_documento_item.cod_ctr_custo=cad_centro_custo.cod_centro_custo and\n\t\t\t\t\t\t\tcod_documento='" . $cod_documento . "' and cad_documento_item.cod_empresa=" . $_SESSION['cod_empresa'] . " ; ";
$resultado = mysql_query($select, $conexao) or die(mysql_error());
while ($row = mysql_fetch_array($resultado)) {
$tbody .= tbody($row['codigo_lancamento'], $row['cod_projeto'], $row['cod_ctr_custo'], $row['cod_conta'], $row['historico'], $row['montante'], $row['data_vencimento_liquidacao']);
}
echo " <div>\n\t\t\t\t\t\t<script>";
$selects = new selects();
$selects->projeto_autocomplete('');
echo "</script>\n\t\t\t\t\t\t<script>";
$selects = new selects();
$selects->ctrcusto_autocomplete('');
echo "</script>\n\t\t\t\t\t\t<script>";
$selects = new selects();
$selects->conta_autocomplete('');
echo "</script>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div class='uk-form'>\n\t\t\t\t\t\t<table class='uk-table uk-table-hover uk-table-condensed' id='tableToModify'>\n\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t<th style='width: 20px;'>CL</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 150px;'>Projeto</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 150px;'>Ctr. Custo</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 150px;'>Conta</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 200px;'>Descrição</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 100px;'>Valor</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 100px;'>Vencimento</th>\n\t\t\t\t\t\t\t\t\t<th style='width: 30px;'></th>\n\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t</thead>\n\t\t\t\t<tbody style='min-height: 250px;'>\n\t\t\t\t\t" . $tbody . "\n\t\t\t\t</tbody>\n\t\t\t</table>\n\t</div>\n\t\n\t";
/////////////////////////////////////////////////////////////////////////////
}
