ok....
el codigo de navigator es el siguiente
<?php
YsJQuery::useComponent(YsJQueryConstant::COMPONENT_JQGRID);
$grid = new YsGrid('gridId','Manipulacion BUSES');
$busGridField = new YsGridField('bus', 'Bus');
$busGridField->setEditable(true);
$busGridField->setWidth(40);
$instGridField = new YsGridField('institucion', 'Institucion');
$instGridField->setEditable(true);
$instGridField->setWidth(200);
$placaGridField = new YsGridField('placa', 'Placa');
$placaGridField->setEditable(true);
$placaGridField->setWidth(90);
$marcaGridField = new YsGridField('marca', 'Marca');
$marcaGridField->setEditable(true);
$cupoGridField = new YsGridField('cupo', 'Capacidad');
$cupoGridField->setEditable(true);
$cupoGridField->setWidth(90);
$motorGridField = new YsGridField('motor', 'Motor');
$motorGridField->setEditable(true);
$chasisGridField = new YsGridField('chasis', 'Chasis');
$chasisGridField->setEditable(true);
$modeloGridField = new YsGridField('modelo', 'Modelo');
$modeloGridField->setEditable(true);
$modeloGridField->setWidth(60);
$fotoGridField = new YsGridField('foto', 'Fotografia');
$fotoGridField->setEditable(true);
$estGridField = new YsGridField('estado', 'Estado');
$estGridField->setEditable(true);
$estGridField->setWidth(60);
$grid->addGridFields($busGridField, $instGridField, $placaGridField,
$marcaGridField, $cupoGridField, $motorGridField, $chasisGridField,
$modeloGridField, $fotoGridField, $estGridField
);
$recordList = new YsGridRecordList();
$db = new cDB();
$db->Connect(HOST, DB_COL, USUARIO, PASS);
$sql = "SELECT b.*,i.nombre
FROM `bus` b
JOIN `institucion` i ON (b.institucion = i.institucion)
";
$rs = $db->Query($sql);
if ($fila = $db->First($rs))
{ do {$record = new YsGridRecord();
$record->setAttribute('bus', $fila['BUS']);
$record->setAttribute('institucion', $fila['nombre']);
$record->setAttribute('placa', $fila['placa']);
$record->setAttribute('marca', $fila['marca']);
$record->setAttribute('cupo', $fila['capacidad']);
$record->setAttribute('motor', $fila['numero_motor']);
$record->setAttribute('chasis', $fila['numero_chasis']);
$record->setAttribute('modelo', $fila['modelo']);
$record->setAttribute('foto', $fila['fotografia']);
$record->setAttribute('estado', $fila['estado']);
$recordList->append($record);
} while($fila = $db->Next($rs));
}
$grid->setRecordList($recordList);
$grid->setWidth("125%");
$grid->setDataType(YsGridConstants::DATA_TYPE_LOCAL);
$grid->setRowNum($db->GetNumRows($rs));
$grid->setRowList(array(3,5,10));
$grid->setViewRecords(true);
$grid->setSortname('bus');
$navigator = new YsGridNavigator();
$form = new YsGridForm();
$form->setUrl('manejoDataDel.php');
$form->setHeight(400);
$form->setReloadAfterSubmit(false);
$form->setLeft(100);
$navigator->setEditForm($form);
$naavigator->setEditText('Modificar');
$navigator->setAddTitle('Proceso de Agregacion Buses');
$navigator->setAddForm($form);
$navigator->setAddText('Agregar');
$navigator->setDelTitle('Eliminar informacion');
$navigator->setDeleteForm($form);
$navigator->setDelText('Eliminar');
$grid->setNavigator($navigator);
?>
<button id="btnOpenDialog">Ver Info</button>
<?php echo YsUIDialog::initWidget('dialogId','style="display:none"
title="Listado de Buses"') ?>
<?php echo $grid->renderTemplate() ?>
<?php echo YsUIDialog::endWidget() ?>
<?php
echo
YsJQuery::newInstance()
->onClick()
->in('#btnOpenDialog')
->execute(
YsUIDialog::build('#dialogId')
->_modal(true)
->_width(1250)
->_zIndex(100)
->_height(480)
->_buttons(array(
'Ok' => new YsJsFunction('alert("que chofo")'),
'Close' => new YsJsFunction(YsUIDialog::close('this')))
)
)
?>
<?php
echo $grid->execute();
$db->Disconnect();
?>
=======================================
el codigo del data es
<?php
$operacion = $_POST['oper'];
$id_bus = $_POST['bus'];
$id_institucion = $_POST['institucion'];
$dato_placa = $_POST['placa'];
$dato_marca = $_POST['marca'];
$dato_capacidad = $_POST['cupo'];
$dato_motor = $_POST['motor'];
$dato_chasis = $_POST['chasis'];
$dato_modelo = $_POST['modelo'];
$dato_foto = $_POST['foto'];
$dato_estado = $_POST['estado'];
$datos = array ("BUS" => $id_bus,'institucion' =>
$id_institucion,'placa' => $dato_placa,'marca' => $dato_marca,
'capacidad' => $dato_capacidad,
'numero_motor' => $dato_motor,'numero_chasis' =>
$dato_chasis,'modelo' => $dato_modelo,'fotografia' =>
$dato_foto,'estado' => $dato_estado);
$db = new cDB();
$db->Connect(HOST, DB_COL, USUARIO, PASS);
$where = sprintf(" BUS = %d ",$id_bus);
//$rs = $db->Update('bus', $datos, $where);
if (strcmp($operacion,'del') == 0 )
{ $rs = $db->Delete('bus', $where); }
?>
-------------------