<?php
require '../system/vendor/class.eyemysqladap.inc.php';
require '../system/vendor/class.eyedatagrid.inc.php';
$db = new EyeMySQLAdap('localhost', 'root', 'kr7943', 'snippetz');
$x = new EyeDataGrid($db);
// Set the query
$x->setQuery("*", "snips", 'snip_id', 'user_id = ' . $userID . '');
// Allows filters
//$x->allowFilters();
$x->showRowNumber();
$x->addStandardControl(EyeDataGrid::STDCTRL_DELETE, "deleteSnip(%_P%," . $userID . ")");
$x->addStandardControl(EyeDataGrid::STDCTRL_EDIT, "window.location='/home/edit/%_P%'");
$x->setColumnType('language', EyeDataGrid::TYPE_CUSTOM, '%language%');
$x->setColumnType('title', EyeDataGrid::TYPE_CUSTOM, '<a href="/home/snip/%_P%">%title%</a>');
$x->setColumnType('private', EyeDataGrid::TYPE_ARRAY, array('1' => 'yes', '0' => 'no'));
$x->hideColumn('user_id');
$x->hideColumn('snip_id');
$x->hideColumn('snippet');
$x->hideColumn('description');
?>
<script type="text/javascript" charset="utf-8">
jQuery(function($) {
$("#dialog").hide();
});
function postDestroy(snipID, code)
{
$.ajax({
type: "POST",
url: "/snips/snip_delete",
data: "snipID="+snipID+"&code="+code,
$db1 = new EyeMySQLAdap(HOST, USUARIO, PASSWORD, BASE);
// Load the datagrid class
$x = new EyeDataGrid($db1);
// Set the query
$x->setQuery($se, $fr, 'NRO', $q);
// Show reset grid control
//$x->showReset();
// Mostrar checkbox para seleccion de filas
// $x->showCheckboxes();
// $x->showRadiobutton();
//
// Mostrar numero de filas
// $x->showRowNumber();
//----------------------------------------------------------------------
// Damos formato a los datos a mostrar
$x->setColumnType('FECHA', EyeDataGrid::TYPE_DATE, 'd M, Y', true);
// Change the date format
$x->setColumnType('ELIMINADO', EyeDataGrid::TYPE_ARRAY, array('S' => 'Eliminado', 'N' => '', '' => ''));
// Convert db values to something better
$x->setColumnType('FECHA_ENTREGA', EyeDataGrid::TYPE_DATE, 'd, M, Y', true);
// Change the date format
$x->setColumnType('PRECIO', EyeDataGrid::TYPE_DOLLAR, FALSE, array('Back' => '#c3daf9', 'Fore' => 'black'));
//----------------------------------------------------------------------
// Normalizamos las cabezeras de la tabla.
$x->setColumnHeader('FECHA', 'Fecha emisión');
$x->setColumnHeader('nro_factura', 'Nro. Factura');
//----------------------------------------------------------------------
//Ocultamos los campos no deseados.
if (!USAR_ELIMINACION_VIRTUAL) {
$x->hideColumn('ELIMINADO');
}
