See behind an exemple (simplified) of plugin code to get some coordinate in
a DB and display a point accordingly:
There are 3 parts and 4 files.
CLIENT SIDE (ClientYourPluingName.php)
<?php
class ClientYourPluingName extends ClientPlugin
implements ServerCaller {
private $vehiculeCoords;
public function initialize() {
$this->vehiculeCoords = array();
// get coord from db
$db = $this->getDb();
$sql = 'SELECT * FROM "your_table_with_values" WHERE
any_condition_you_want';
$result = $db->query($sql);
if (DB::isError($result)) {
throw new CartoclientException($result->getMessage());
}
$row = NULL;
while ($result->fetchInto($row, DB_FETCHMODE_ASSOC)) {
$this->vehiculeCoords['x'] = $row['name_of_the_x_coord_column'];
$this->vehiculeCoordsY['y'] =
$row['name_of_the_y_coord_column'];
}
}
private function getDb() {
if (is_null($this->db)) {
$dsn = $this->getConfig()->databaseDsn;
print "dsn= ".$dsn."<br>";
if (!$dsn) {
throw new CartoclientException('Search database DSN not
found');
}
$this->db = DB::connect($dsn);
//check for db connection error, throw exception if needed
Utils::checkDbError();
}
return $this->db;
}
/**
* @see ServerCaller::buildRequest()
*/
public function buildRequest() {
// we call for a new shape only if we have a x and y
if ($this->vehiculeCoords['x'] != '' and $this->vehiculeCoords['y']
!= '') {
$newElement = new Point($this->vehiculeCoords['x'],
$this->$this->vehiculeCoords['y']);
$styledShape = new StyledShape();
$styledShape->shape = $newElement;
$shapeStyle = new ShapeStyle();
$shapeStyle->symbol = $this->type;
$shapeStyle->size = 20;
$shapeStyle->color->setFromRGB(51, 0, 204);
$shapeStyle->outlineColor->setFromRGB(0, 0, 0);
$styledShape->shapeStyle = $shapeStyle;
$YourPluingNameRequest = new YourPluingNameRequest();
$YourPluingNameRequest->shapes = array($styledShape);
return $YourPluingNameRequest;
}
}
/**
* @see ServerCaller::initializeResult()
*/
public function initializeResult($YourPluingNameResult) {}
/**
* @see ServerCaller::handleResult()
*/
public function handleResult($YourPluingNameResult) {}
?>
COMMON (YourPluingName.php)
<?php
class YourPluingNameRequest extends Serializable {
/**
* Styled shapes to be drawn
* @var array
*/
public $shapes;
/**
* @see Serializable::unserialize()
*/
public function unserialize($struct) {
$this->shapes = self::unserializeObjectMap($struct, 'shapes',
'StyledShape');
}
}
/**
* Result
* @package Plugins
*/
class YourPluingNameResult {}
?>
COMMON (yourPluingName.wsdl.inc)
<!-- outline -->
<complexType name="Color">
<all>
<element name="r" type="xsd:int"/>
<element name="g" type="xsd:int"/>
<element name="b" type="xsd:int"/>
</all>
</complexType>
<complexType name="ShapeStyle">
<all>
<element name="symbol" type="xsd:int"/>
<element name="size" type="xsd:int"/>
<element name="color" type="types:Color"/>
<element name="outlineColor" type="types:Color"/>
<element name="backgroundColor" type="types:Color"/>
<element name="transparency" type="xsd:int"/>
</all>
</complexType>
<complexType name="LabelStyle">
<all>
<element name="font" type="xsd:int"/>
<element name="size" type="xsd:int"/>
<element name="color" type="types:Color"/>
<element name="outlineColor" type="types:Color"/>
<element name="backgroundColor" type="types:Color"/>
</all>
</complexType>
<complexType name="StyledShape">
<all>
<element name="shapeStyle" type="types:ShapeStyle"/>
<element name="labelStyle" type="types:LabelStyle"/>
<element name="shape" type="types:Shape"/>
<element name="label" type="xsd:string"/>
</all>
</complexType>
<complexType name="ArrayOfStyledShape">
<complexContent>
<restriction base="enc11:Array">
<attribute ref="enc11:arrayType"
wsdl:arrayType="types:StyledShape[]"/>
</restriction>
</complexContent>
</complexType>
<complexType name="OutlineRequest">
<all>
<element name="className" type="xsd:string"/>
<element name="shapes" type="types:ArrayOfStyledShape"/>
<element name="maskMode" type="xsd:boolean"/>
</all>
</complexType>
<complexType name="OutlineResult">
<all>
<element name="className" type="xsd:string"/>
<element name="area" type="xsd:double"/>
</all>
</complexType>
SERVER (ServerYourPluingName.php)
<?php
class ServerYourPluingName extends ClientResponderAdapter {
/**
* @var Logger
*/
private $log;
/**
* @var objet
*/
private $shapes;
/**
* Constructor
*/
function __construct() {
parent::__construct();
$this->log =& LoggerManager::getLogger(__CLASS__);
}
/**
* @see ClientResponder::initializeRequest()
*/
function initializeRequest($requ) {
if ($requ)
$this->shapes = $requ->shapes;
}
/**
* Result is set in initializeRequest but Outline must be called
* in handlePreDrawing
* @see ClientResponder::handlePreDrawing()
*/
function handlePreDrawing($requ) {
if ($requ) {
$pluginManager = $this->serverContext->getPluginManager();
if (empty($pluginManager->outline))
throw new CartoserverException("outline plugin not loaded, "
. "and needed to draw the new
element");
$pluginManager->outline->draw($this->shapes);
}
}
}
?>
mapserver alone or mapserver+cartoweb?
In Cartoweb you need to create a new plugin that will make a request on
the DB
and then generate some simple geometry (a point i suppose) at the given
coordinate.
I can show you some code exemple monday when im back to work and have my
projects files under the hand.
If only mapserver, I suppose you will have to code some phpmapscript
functions,
but im no expert in that.
Regards
Oliver
Hi,
I use postgresql-postgis in a project for fleet vehicle management,i need
to
have the last postion of vehicle
I have create a table with :
CREATE TABLE vehicle (id_vehicle serial, time timestamp, x numeric, y
numeric, speed text, PRIMARY KEY(id_vehicle ,time));
what can i do to show last position with mapserver ?
--
"Qui allume sa bougie à la mienne reçoit de la lumière sans me plonger
dans
l'obscurité."
' Thomas Jefferson'
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
_______________________________________________
Cartoweb-users mailing list
Cartoweb-users@lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users
