_name ?>
_size ?> Bytes
_mimetype ?>
_description ?>
innerHTML = $aux;
return TRUE;
}
catch (PDOException $e)
{
$message->addWarning ($e->getMessage ());
}
catch (Exception $e)
{
$message->addWarning ($e->getMessage ());
}
$message->save ();
$this->showMessages ();
return FALSE;
}
public function removePhoto ($fileId, $itemId)
{
if (!$fileId || !$itemId)
return FALSE;
$message = Message::singleton ();
$return = TRUE;
try
{
$form = Form::singleton ('all.xml', 'view.xml', 'create.xml', 'edit.xml');
$table = $form->getTable () .'_media';
$db = Database::singleton ();
$db->exec ("DELETE FROM ". $table ." WHERE _media = ". $fileId ." AND _item = ". $itemId);
$message->addMessage (__ ('Archive unlinked with success!'));
}
catch (PDOException $e)
{
$message->addWarning ($e->getMessage ());
$return = FALSE;
}
$message->save ();
$this->showMessages ();
return $return;
}
public function getPhotos ($itemId)
{
if (!$itemId)
return '';
$message = Message::singleton ();
$result = array ();
try
{
$form = Form::singleton ('all.xml', 'view.xml', 'create.xml', 'edit.xml');
$table = $form->getTable () .'_media';
$db = Database::singleton ();
$sth = $db->prepare ("SELECT _media FROM ". $table ." WHERE _item = ". $itemId);
$sth->execute ();
while ($obj = $sth->fetch (PDO::FETCH_OBJ))
$result [] = $obj->_media;
}
catch (PDOException $e)
{
$message->addWarning ($e->getMessage ());
}
$message->save ();
$this->showMessages ();
return "'". implode ("','", $result) ."'";
}
public function tableExists ($name)
{
$message = Message::singleton ();
try
{
$db = Database::singleton ();
$array = explode ('.', $name);
if (sizeof ($array) == 2)
{
$schema = $array [0];
$table = $array [1];
}
else
{
$schema = $db->getSchema ();
$table = $array [0];
}
$sth = $db->prepare ("SELECT tablename FROM pg_tables WHERE schemaname = '". $schema ."' AND tablename = '". $table ."'");
$sth->execute ();
if (!$sth->rowCount ())
return FALSE;
return TRUE;
}
catch (Exception $e)
{
$message->addWarning ($e->getMessage ());
}
catch (PDOException $e)
{
$message->addWarning ($e->getMessage ());
}
$message->save ();
return FALSE;
}
public function delay ()
{
sleep (1);
}
public function showMessages ()
{
$message = Message::singleton ();
if (!is_object ($message) || !$message->has ())
return FALSE;
$str = '';
while ($msg = $message->get ())
$str .= $msg;
$msgs = &XOAD_HTML::getElementById ('labelMessage');
$msgs->innerHTML = ''. $str .'
';
$message->clear ();
return TRUE;
}
public function xoadGetMeta()
{
$methods = get_class_methods ($this);
XOAD_Client::mapMethods ($this, $methods);
XOAD_Client::publicMethods ($this, $methods);
XOAD_Client::privateMethods ($this, array ());
}
}
?>