function build_listado_acordes()
{
// Grid de acordes
global $ins, $dic, $Path;
$searchbox = $ins['searchbox'] ? $ins['searchbox'] : false;
$sqlData = select_acordes($searchbox);
$y = 0;
if ($sqlData) {
foreach ($sqlData as $row) {
$seccion = 'acordes';
$id = $row[id_acorde];
$valor = $row[acorde];
$tblData[$y] = $row;
unset($tblData[$y][combo], $tblData[$y][img_guitar], $tblData[$y][img_piano], $tblData[$y][img_bass]);
$tblData[$y][acorde] = '<span class="editar campo-editable" data-pk="' . $id . '" data-title="' . $dic[ico][editar] . '" title="' . $dic[ico][editar] . '">' . $valor . '</span> <span id="frm-msj_' . $id . '"></span>';
$tblData[$y][notas] = '<span class="editar campo-editable" data-name="notas" data-pk="' . $id . '" data-title="' . $dic[ico][editar] . '" title="' . $dic[ico][editar] . '">' . create_list(explode('|', implode(',|', explode(',', $row[notas])))) . '</span>';
$tblData[$y][guitarra] = '<span style="text-align:center; vertical-align:middle;" class="editar campo-editable" data-type="file" data-name="img_guitar" data-pk="' . $id . '" data-title="' . $dic[ico][editar] . '" title="' . $dic[ico][editar] . '">' . '<img class="img-zoom" src="' . $Path[chordsurl] . $row[img_guitar] . '" data-zoom-image="' . $Path[chordsurl] . $row[img_guitar] . '" width="50%"/></span>';
$tblData[$y][piano] = '<span style="text-align:center; vertical-align:middle; margin-top: 8%;" class="editar campo-editable" data-type="file" data-name="img_piano" data-pk="' . $id . '" data-title="' . $dic[ico][editar] . '" title="' . $dic[ico][editar] . '">' . '<img class="img-zoom" src="' . $Path[chordsurl] . $row[img_piano] . '" data-zoom-image="' . $Path[chordsurl] . $row[img_piano] . '" width="50%"/></span>';
$tblData[$y][bajo] = '<span style="text-align:center; vertical-align:middle;" class="editar campo-editable" data-type="file" data-name="img_bass" data-pk="' . $id . '" data-title="' . $dic[ico][editar] . '" title="' . $dic[ico][editar] . '">' . '<img class="img-zoom" src="' . $Path[chordsurl] . $row[img_bass] . '" data-zoom-image="' . $Path[chordsurl] . $row[img_bass] . '" width="50%"/></span>';
$tblData[$y][quitar] = ico_eliminar($id, "activate('frm-captura-" . $seccion . "','" . $seccion . "'," . $id . ');');
$y++;
}
}
return build_grid_paginado($tblData, $titulos);
}
function dropdown_acordes($data = array())
{
global $dic;
$requerido = $data[requerido] ? true : false;
$name = $data[name] ? $data[name] : 'lts_acordes';
$lst_data = select_acordes();
$dataDropdown = array('data' => $lst_data, 'name' => $name, 'value' => 'id_acorde', 'text' => 'acorde', 'requerido' => $requerido, 'class' => $data[clase], 'multiple' => $data[multiple], 'width' => '200', 'selected' => $data[id_selected], 'title' => $dic[tooltips][lst_acordes]);
return drop_down_select($dataDropdown);
}
