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 build_listado_cifrados() { // Grid de artistas global $ins, $Path; $searchbox = $ins['searchbox'] ? $ins['searchbox'] : false; $sqlData = select_cifrados($searchbox); $y = 0; if ($sqlData) { foreach ($sqlData as $row) { $seccion = 'cifrados'; $id = $row[id_cifrado]; $tblData[$y] = $row; // unset($tblData[$y][id_cifrado]); $tblData[$y][portada] = '<span style="text-align:center; vertical-align:middle;">' . '<img class="img-zoom" src="' . $Path[coversurl] . $row[portada] . '" data-zoom-image="' . $Path[coversurl] . $row[portada] . '" width="50%"/></span>'; $tblData[$y][acciones] = ico_detalle('ico-cifrado_' . $id, 'ver_cifrado(' . $id . ');') . ' ' . ico_editar('ico-editar_' . $id, 'editar_cifrado(' . $id . ');') . ' ' . ico_eliminar($id, "activate('frm-captura-" . $seccion . "','" . $seccion . "'," . $id . ');'); $y++; } } return build_grid_paginado($tblData, $titulos); }