def deleteItem( self, item ):
if not self._editItem:
return
if QMessageBox.question(
self,
"Delete supplier",
"Are you sure you want to remove the supplier " + self._editItem['name'] + '?',
QMessageBox.Yes | QMessageBox.No) != QMessageBox.Yes:
return
Database.execute('elc_DeleteSupplier',self._editItem['id'])
self._controller.updateSuppliers()
def deleteItem( self, item ):
if not self._editItem:
return
if QMessageBox.question(
self,
"Delete source type",
"Are you sure you want to remove the source type " + self._editItem['name'] + '?',
QMessageBox.Yes | QMessageBox.No) != QMessageBox.Yes:
return
Database.execute('elc_DeleteSourceType',self._editItem['id'])
ReaderType.reload()
self._controller.updateSourceTypes()
def setPoint( self, coords ):
src_crs = self._iface.mapCanvas().mapRenderer().destinationCrs()
tgt_crs = QgsCoordinateReferenceSystem()
tgt_crs.createFromOgcWmsCrs('EPSG:4167')
transform = QgsCoordinateTransform( src_crs, tgt_crs )
wkt = transform.transform( coords.x(), coords.y() ).wellKnownText()
# Add the point to the database
success = Database.execute('elc_CreateAddressPoint', self._address.id(), str(wkt))
if success:
# Refresh GUI
self._iface.mapCanvas().refresh()
self._controller.updateAddress( self._address.id() )
def load( self ):
self._readerClasses[:] = []
for sc in Reader.__subclasses__():
self._readerClasses.append(
dict(name=sc.__name__,params=sc.params())
)
self._readerClasses.sort( key=lambda x: x['name'] )
for i, c in enumerate( self._readerClasses ):
self.uReaderClass.addNameValue( c['name'], i )
for r in Database.execute('select srid, name from elc_getSpatialReferenceSystems() order by name'):
self.uCoordSys.addNameValue(r[1],r[0])
self.loadList()
def setSelectRectangle( self, rectangle ):
src_crs = self._iface.mapCanvas().mapRenderer().destinationCrs()
tgt_crs = QgsCoordinateReferenceSystem()
tgt_crs.createFromOgcWmsCrs('EPSG:4167')
transform = QgsCoordinateTransform( src_crs, tgt_crs )
searchrect = transform.transformBoundingBox( rectangle )
wkt = str(QgsGeometry.fromRect(searchrect).exportToWkt())
jobid = self._controller.job().id()
self._foundIds[:] = []
if self._layers.isVisible( self._layers.addressLayer()):
for r in Database.execute('select adr_id from elc_findAddressIds(%s,%s) order by poffset',jobid,wkt):
self._foundIds.append(r[0])
self._addresses.resetFilter()
self._foundSad[:] = []
if self._layers.isVisible( self._layers.landonlineAddressLayer() ):
for r in Database.execute('select sad_id, rna_id, roadname, housenumber, poffset from elc_findLandonlineAddresses(%s) order by poffset',wkt):
self._foundSad.append(dict(
address=str(r[3])+' '+str(r[2]),
sad_id=r[0],
rna_id=r[1],
offset=round(float(r[4]),1)
))
self.uSadListView.setList(self._foundSad)
self._foundRna[:] = []
if self._layers.isVisible( self._layers.landonlineRoadLayer() ):
for r in Database.execute('select rna_id, rcl_id, roadname, poffset from elc_findLandonlineRoads(%s) order by poffset',wkt):
self._foundRna.append(dict(
roadname=r[2],
rna_id=r[0],
rcl_id=r[1],
offset=round(float(r[3]),1)
))
self.uRnaListView.setList(self._foundRna )
def findAddresses( self, rectangle ):
src_crs = self._iface.mapCanvas().mapRenderer().destinationCrs()
tgt_crs = QgsCoordinateReferenceSystem()
tgt_crs.createFromOgcWmsCrs('EPSG:4167')
transform = QgsCoordinateTransform( src_crs, tgt_crs )
searchrect = transform.transformBoundingBox( rectangle )
wkt = str(QgsGeometry.fromRect(searchrect).exportToWkt())
addresses = []
for r in Database.execute('select sad_id, rna_id, roadname, housenumber, poffset from elc_findLandonlineAddresses(%s) order by poffset',wkt):
addresses.append(dict(
address=str(r[3])+' '+str(r[2]),
sad_id=r[0],
rna_id=r[1],
offset=round(float(r[4]),1)
))
return addresses
def load( self ):
self.loadSourceTypes()
for r in Database.execute('select stt_id,name from elc_TAList() order by name'):
self.uTA.addNameValue(r[1],r[0])
self.loadList()
