U TGˆh¬ã@sàdZdZdZddlZddlZddlmZddlmZm Z m Z m Z m Z m Z mZmZmZmZmZmZddlmZmZmZddlmZmZmZmZdd lmZmZm Z m!Z!m"Z"dd l#m$Z$dd l%m&Z&dd l'm(Z(Gd d„deƒZ)dS)zCopyright 2021, 3Lizz GPL version 3z info@3liz.orgéN)ÚDict) ÚQgisÚQgsDistanceAreaÚ QgsExpressionÚQgsExpressionContextÚQgsExpressionContextUtilsÚ QgsFeatureÚQgsFeatureRequestÚQgsFieldÚ QgsFieldsÚQgsJsonExporterÚ QgsJsonUtilsÚ QgsProject)Ú QMetaTypeÚ QTextCodecÚQVariant)ÚQgsRequestHandlerÚQgsServerRequestÚQgsServerResponseÚ QgsService)Úfind_vector_layerÚget_lizmap_groupsÚget_lizmap_user_loginÚget_server_fidÚwrite_json_response)ÚExpressionServiceError)ÚLogger)Úto_boolc@s¼eZdZedœdd„Zedœdd„Zeeeddœdd „Z e e eefeedd œd d „ƒZ e e eefeedd œd d„ƒZ e e eefeedd œdd„ƒZe e eefeedd œdd„ƒZdS)ÚExpressionService)ÚreturncCsdS)z Service name Ú EXPRESSION©©Úselfr!r!úB/var/www/lizmap/lizmap/plugins/lizmap_server/expression_service.pyÚname.szExpressionService.namecCsdS)z Service version z1.0.0r!r"r!r!r$Úversion3szExpressionService.versionN)ÚrequestÚresponseÚprojectrc Cs€t||ƒ}t|ƒ}t|ƒ}| ¡}||d<t|ƒ|d<| |¡| ¡}zÄ| dd¡ ¡} zt |  ¡ƒ  ¡Wn(t k r–t dd| ›ddƒ‚YnX| d kr°| |||¡nZ| d krÈ| |||¡nB| d krà| |||¡n*| d krø| |||¡nt dd  | ¡dƒ‚Wnnt k r:} z|  |¡W5d} ~ XYnBt k rz} z"t | ¡t ddƒ} |  |¡W5d} ~ XYnXdS)z( Execute a 'EXPRESSION' request Z lizmap_userZlizmap_user_groupsÚREQUESTÚúBad request errorzInvalid POST DATA for 'ú'éZEVALUATEZREPLACEEXPRESSIONTEXTZGETFEATUREWITHFORMSCOPEZ VIRTUALFIELDSz…Invalid REQUEST parameter: must be one of 'Evaluate', 'ReplaceExpressionText', 'GetFeatureWithFormScope', 'VirtualFields'; found '{}'NzInternal server errorzInternal 'lizmap' service error)rrrÚcustomVariablesÚlistÚsetCustomVariablesÚ parametersÚgetÚupperÚbytesÚdataÚdecodeÚ ExceptionrÚevaluateÚreplace_expression_textÚget_feature_with_form_scopeÚ virtualFieldsÚformatZformatResponserÚ log_exception) r#r'r(r)Zrequest_handlerÚgroupsZ user_loginZ custom_varÚparamsZreqparamÚerrÚer!r!r$ÚexecuteRequest>sN    ý ÿü  z ExpressionService.executeRequest)r@r(r)rc Cs4tƒ}| dd¡}|s"tdddƒ‚t||ƒ}|sDtdd|›ddƒ‚| dd¡}|s|| d d¡}|sptdd dƒ‚d |›d }zt |¡}WnBtk rÌ| d |›dt  ¡›¡tdd|›ddƒ‚YnXt ƒ} |   t   ¡¡|   t  |¡¡|   t  |¡¡tƒ} |  | ¡| ¡¡|  | ¡¡i} g} g} t|tƒrLt|ƒ} nt|tƒr`| ¡} | D]’\}}t|ƒ}| | ¡| | ¡¡| |  ¡¡| !¡rÂ|  "d|›d| #¡›¡qd| $¡sâ|  "d|›d¡qd| %| ¡|| |<qd| rtdd &d '| ¡¡dƒ‚| dd¡}|sF| dd¡}|rFd|d}dggddœ}|sÞi}i}|  ¡D]H\}}| (| ¡}| )¡rœd||<| *¡||<nt t+ ,|¡¡||<qj|d "|¡|d  "|¡t-||ƒdSzt |¡}WnDtk r0| d!|›dt  ¡›¡tdd"|›ddƒ‚YnX|rRt|tƒrRt.|ƒdkrftdd"|›ddƒ‚d#|dks†|dd#d$kr˜tdd% &|¡dƒ‚t+ /d&|d't0 1d(¡¡}t+ 2d&|d'|t0 1d(¡¡}|sætdd)|›dƒ‚t3| 4¡ƒ}| 5|¡t6| d*¡ƒ}|D]}t7|ƒ}| 8| 9¡¡| 4¡D].}| :¡}| ;|¡d+kr2| <|||¡q2|rx|   t  =|¡¡|  >|¡|  ?| 4¡¡i}i}|  ¡D]d\}}|r¸| %| ¡| (| ¡}| )¡râd||<| *¡||<n t t+ ,|¡¡||<| @¡||<q |d "|¡|d  "|¡qt-||ƒdS),a  Evaluate expressions against layer or features In parameters: LAYER=wms-layer-name EXPRESSION=An expression to evaluate or EXPRESSIONS=["first expression", "second expression"] or EXPRESSIONS={"key1": "first expression", "key2": "second expression"} // optionals FEATURE={"type": "Feature", "geometry": {}, "properties": {}} or FEATURES=[{"type": "Feature", "geometry": {}, "properties": {}}, {"type": "Feature", "geometry": {}, "properties": {}}] FORM_SCOPE=boolean to add formScope based on provided features ÚLAYERr+r,z8Invalid 'Evaluate' REQUEST: LAYER parameter is mandatoryr.z(Invalid LAYER parameter for 'Evaluate': ú providedZ EXPRESSIONSr zLInvalid 'Evaluate' REQUEST: EXPRESSION or EXPRESSIONS parameter is mandatoryú["ú"]zJSON loads expressions 'ú ' exception: z)Invalid 'Evaluate' REQUEST: EXPRESSIONS 'ú' are not well formedúError "ú": úExpression not valid "ú"z&Invalid EXPRESSIONS for 'Evaluate': {}Ú ÚFEATURESÚFEATUREú[ú]Úsuccessr©ÚstatusÚresultsÚerrorsÚfeaturesNrVrWúJSON loads features 'ú&Invalid 'Evaluate' REQUEST: FEATURES 'ÚtypeÚFeatureú_Invalid 'Evaluate' REQUEST: FEATURES '{}' are not well formed: type not defined or not Feature.ú){ "type": "FeatureCollection","features":ú}úUTF-8zEInvalid FEATURES for 'Evaluate': not GeoJSON features array provided Ú FORM_SCOPEéÿÿÿÿ)Arr3rrÚjsonÚloadsr8ÚcriticalÚ tracebackÚ format_excrÚ appendScoperÚ globalScopeÚ projectScopeÚ layerScoperÚ setSourceCrsÚcrsÚtransformContextÚ setEllipsoidÚ ellipsoidÚ isinstancer0Ú enumerateÚdictÚitemsrÚsetGeomCalculatorÚsetDistanceUnitsÚ distanceUnitsÚ setAreaUnitsÚ areaUnitsÚhasParserErrorÚappendÚparserErrorStringÚisValidÚpreparer=Újoinr9Ú hasEvalErrorÚevalErrorStringr Ú encodeValuerÚlenÚstringToFieldsrÚ codecForNameÚstringToFeatureListr ÚfieldsÚextendrrÚ setGeometryÚgeometryr%ÚindexOfÚ setAttributeÚ formScopeÚ setFeatureÚ setFieldsÚ expression) r@r(r)ÚloggerÚ layer_nameÚlayerZ expressionsrZexp_jsonÚ exp_contextÚdaÚexp_mapÚexp_parser_errorsZ exp_itemsÚkrBÚexprXÚfeatureÚbodyÚresultÚerrorÚvalueÚgeojsonÚfeature_fieldsÚ feature_listÚ feat_fieldsÚadd_form_scopeÚfÚfeatÚfieldÚ field_namer!r!r$r9qsB ý  ý  ý ÿ ý          ý   ü   ÿ ý   ý ÿü þ ýý         zExpressionService.evaluatec CsLtƒ}| dd¡}|s"tdddƒ‚t||ƒ}|sDtdd|›ddƒ‚| dd¡}|s|| d d¡}|sptdd dƒ‚d |›d }zt |¡}WnBtk rÌ| d |›dt  ¡›¡tdd|›ddƒ‚YnX| dd¡} | sú| dd¡} | rúd| d} t ƒ} |   t   ¡¡|   t  |¡¡|   t  |¡¡tƒ} |  | ¡| ¡¡|  | ¡¡i} g}t|tƒrtt|ƒ}nt|tƒrˆ| ¡}|D]\}}|| |<qŒdggddœ}| s i}|  ¡D],\}}t || | ¡}t t |¡¡||<qÀ|d |¡t ||ƒdS|  !¡dkr*| "¡}| #¡}nðzt | ¡}WnDtk r|| d| ›dt  ¡›¡tdd| ›ddƒ‚YnX|ržt|tƒržt$|ƒdkr²tdd| ›ddƒ‚d|dksÒ|dddkrätdd %| ¡dƒ‚t &d | d!t' (d"¡¡}t )d | d!|t' (d"¡¡}|s2tdd# %| ¡dƒ‚t*| "¡ƒ}| +|¡t,| d$¡ƒ}| d%d¡ !¡d&k}|rÖt-ƒ}| | ¡¡t*ƒ}|  .¡D]@}t/ 0¡d'kr¶t1t2|ƒt3j4ƒ}nt1t2|ƒt5j6ƒ}| |¡q’nd}d}|D]}t7|ƒ}| 8| 9¡¡| "¡D].}| :¡}| ;|¡d(kr| <|||¡q|rL|   t  =|¡¡|  >|¡|  ?| "¡¡i}|  ¡D],\}}t || | ¡}t t |¡¡||<qp|rèt7|| @¡ƒ} |  8| 9¡¡|  At| B¡ƒ¡|d | C| ¡¡n|d |¡qâ|r>| Dd)¡| Ed*d+¡| Fd, Gd-d.d, G|d¡d/g¡¡n t ||ƒdS)0av Replace expression texts against layer or features In parameters: LAYER=wms-layer-name STRING=A string with expression between [% and %] or STRINGS=["first string with expression", "second string with expression"] or STRINGS={"key1": "first string with expression", "key2": "second string with expression"} // optionals FEATURE={"type": "Feature", "geometry": {}, "properties": {}} or FEATURES=[{"type": "Feature", "geometry": {}, "properties": {}}, {"type": "Feature", "geometry": {}, "properties": {}}] or FEATURES=ALL to get Replace expression texts for all features of the layer FORM_SCOPE=boolean to add formScope based on provided features FORMAT=GeoJSON to get response as GeoJSON rDr+r,zEInvalid 'ReplaceExpressionText' REQUEST: LAYER parameter is mandatoryr.z5Invalid LAYER parameter for 'ReplaceExpressionText': rEZSTRINGSÚSTRINGzQInvalid 'ReplaceExpressionText' REQUEST: STRING or STRINGS parameter is mandatoryrFrGzJSON loads strings 'rHz2Invalid 'ReplaceExpressionText' REQUEST: STRINGS 'rIrOrPrQrRrSrrTrVNZALLrYrZr[r\r]r^r_r`zTInvalid FEATURES for 'ReplaceExpressionText': not GeoJSON features array provided {}raZFORMATÚGEOJSONi„rbéÈú Content-Typez'application/vnd.geo+json; charset=utf-8ú, z{"type": "FeatureCollection"z "features": [ú]})Hrr3rrrcrdr8rerfrgrrhrrirjrkrrlrmrnrorprqr0rrrsrtrZreplaceExpressionTextr r‚r{rr4r‡Ú getFeaturesrƒr=r„rr…r†r rˆrr ÚkeysrÚ versionIntr ÚstrrÚStringrZQStringrr‰rŠr%r‹rŒrrŽrÚidÚ setAttributesÚvaluesÚ exportFeatureÚ setStatusCodeÚ setHeaderÚwriter) r@r(r)r‘r’r“ZstringsZ the_stringZstr_jsonrXršr”r•Zstr_mapZ str_itemsr˜Úsr›rœržr r¡rŸr¢r£Zgeojson_outputZexporterZgeojson_fieldsr¦r¤r¥r§r!r!r$r:KsB ý  ý  ý ÿ ý         ü  ÿ ý   ý ÿü þ ýÿü        þÿ z)ExpressionService.replace_expression_textc Cstƒ}| dd¡}|s"tdddƒ‚t||ƒ}|sDtdd|›ddƒ‚| dd¡}|s`tdd dƒ‚| d d¡}|s|tdd dƒ‚zt |¡}Wn@tk rÊ| d |›d t  ¡›¡tdd  |¡dƒ‚YnX|rÚt |t ƒsìtdd  |¡dƒ‚d|ks|ddkrtdd  |¡dƒ‚t  |t d¡¡} t  || t d¡¡} | sTtdd  |¡dƒ‚t| ƒdkrttdd  |¡dƒ‚| d} | dd¡} d} | r~zt | ¡}WnBtk râ| d | ›d t  ¡›¡tdd  | ¡dƒ‚YnX|röt |t ƒstdd  | ¡dƒ‚| d¡dkr*tdd  | ¡dƒ‚t  | t d¡¡}t  | |t d¡¡}|rdt|ƒdkrvtdd  | ¡dƒ‚|d} tƒ}| t ¡¡| t |¡¡| t |¡¡| t | ¡¡| rØ| t | ¡¡tƒ}| | ¡| ¡¡| |  ¡¡t!|ƒ}| "|¡| #| $¡¡| %| &¡¡| '¡rPtdd  || (¡¡dƒ‚| )¡sltdd  |¡dƒ‚| *|¡t+||ƒ}t,| d¡ƒ}|s | -t+j.¡| /¡}dd„|Dƒ}| 0¡}d d„| d!d¡ 1d"¡Dƒ}|D]}| 2| 3|¡¡qÞ| 4d#¡| 5d$d%¡| 6d&¡| 7¡t8|ƒ}|r6| 9|¡d}| :|¡D]<}|d't;||ƒ}| 6|| <|i|¡¡| 7¡d(}qD| 6d)¡dS)*a² Get filtered features with a form scope In parameters: LAYER=wms-layer-name FILTER=An expression to filter layer FORM_FEATURE={"type": "Feature", "geometry": {}, "properties": {}} // optionals PARENT_FEATURE={"type": "Feature", "geometry": {}, "properties": {}} FIELDS=list of requested field separated by comma WITH_GEOMETRY=False rDr+r,zGInvalid 'GetFeatureWithFormScope' REQUEST: LAYER parameter is mandatoryr.z,Invalid LAYER parameter for 'VirtualField': rEÚFILTERzHInvalid 'GetFeatureWithFormScope' REQUEST: FILTER parameter is mandatoryZ FORM_FEATUREzNInvalid 'GetFeatureWithFormScope' REQUEST: FORM_FEATURE parameter is mandatoryzJSON loads form feature 'rHzPInvalid 'GetFeatureWithFormScope' REQUEST: FORM_FEATURE '{}' are not well formedr[r\zrInvalid 'GetFeatureWithFormScope' REQUEST: FORM_FEATURE '{}' are not well formed: type not defined or not Feature.r`zSInvalid FORM_FEATURE for 'GetFeatureWithFormScope': not GeoJSON feature provided {}érZPARENT_FEATURENzRInvalid 'GetFeatureWithFormScope' REQUEST: PARENT_FEATURE '{}' are not well formedztInvalid 'GetFeatureWithFormScope' REQUEST: PARENT_FEATURE '{}' are not well formed: type not defined or not Feature.zUInvalid PARENT_FEATURE for 'GetFeatureWithFormScope': not GeoJSON feature provided {}zíszAExpressionService.get_feature_with_form_scope..cSsg|]}|r| ¡‘qSr!©Ústrip©r¿r¤r!r!r$rÁïsÚFIELDSú,rªr«úapplication/jsonú*{ "type": "FeatureCollection","features":[Ú.r¬r­)=rr3rrrcrdr8rerfrgr=rqrsr r„rr…r†rƒrrhrrirjrkrZparentFormScoperrlrmrnrorprrurvrwrxryrzr|r}r~r rÚsetFlagsÚ NoGeometryÚprimaryKeyAttributesr‡Úsplitr{r‹r·r¸r¹Úflushr r´r®rr¶)r@r(r)r‘r’r“Z exp_filterZ form_featurerŸZform_feature_fieldsZform_feature_listZ form_featZparent_featureZ parent_featZparent_feature_fieldsZparent_feature_listr”r•Zexp_fÚreqÚ with_geomÚ pk_attributesÚattribute_listr‡Úr_fieldsr¤Ú json_exporterÚ separatorr¥Úfidr!r!r$r;'s„ ý  ý ý ýÿÿü ÿüÿþüþýÿüÿü ÿÿü ÿüÿþüþýÿþü  ÿü ÿü        z-ExpressionService.get_feature_with_form_scopec# CsÈtƒ}| dd¡}|s"tdddƒ‚t||ƒ}|sDtdd|›ddƒ‚| dd¡}|s`tdd dƒ‚zt |¡}WnBtk r°| d |›d t  ¡›¡tdd |›d dƒ‚YnXt |t ƒsÐtdd |›d dƒ‚t ƒ}|  t ¡¡|  t |¡¡|  t |¡¡tƒ} |  | ¡| ¡¡|  | ¡¡i} g} | ¡D]’\} } t| ƒ}| | ¡| | ¡¡| | ¡¡| ¡rš|   d| ›d| !¡›¡q<| "¡sº|   d| ›d¡q<| #|¡|| | <q<| rîtdd $d %| ¡¡dƒ‚t&ƒ}| dd¡}|rˆt|ƒ}| | ¡| | ¡¡| | ¡¡| ¡rVtdd $|| !¡¡dƒ‚| "¡sttdd|›ddƒ‚| #|¡t&||ƒ}| dd¡}z| 't(|ƒ¡Wn*t)k rÐtdd|›ddƒ‚YnX| dd¡ *¡}|dkr| dd¡}t& +||dk¡}| ,t& -|g¡¡n|dkr:tdd|›ddƒ‚t.| d¡ƒ}|sZ| /t&j0¡| 1¡}d d!„|Dƒ}| 2¡}d"d!„| d#d¡ 3d$¡Dƒ}|D]}|  | 4|¡¡q˜| 5d%¡| 6d&d'¡| 7d(¡| 8¡t9|ƒ}|rð| :|¡d}| ;|¡D]º}|d)t<||ƒ}i} | =|¡| >| 2¡¡i}!|  ¡D]T\} }| ?|¡}"| @¡rnd*| | <| A¡|!| <n t tB C|"¡¡| | <| D¡|!| <q<| 7|| E|| |¡¡| 8¡d+}qþ| 7d,¡d*S)-a Get virtual fields for features In parameters: LAYER=wms-layer-name VIRTUALS={"key1": "first expression", "key2": "second expression"} // optionals FILTER=An expression to filter layer FIELDS=list of requested field separated by comma WITH_GEOMETRY=False LIMIT=number of features to return or nothing to return all SORTING_ORDER=asc or desc, default = asc SORTING_FIELD=field name to sort by rDr+r,z=Invalid 'VirtualFields' REQUEST: LAYER parameter is mandatoryr.z-Invalid LAYER parameter for 'VirtualFields': rEZVIRTUALSz@Invalid 'VirtualFields' REQUEST: VIRTUALS parameter is mandatoryzJSON loads virtuals 'rHz+Invalid 'VirtualFields' REQUEST: VIRTUALS 'rIrJrKrLrMz(Invalid VIRTUALS for 'VirtualFields': {}rNr»z1Invalid FILTER for 'VirtualFields' Error "{}": {}z9Invalid FILTER for 'VirtualFields' Expression not valid "ZLIMITz-1z$Invalid LIMIT for 'VirtualFields': "Z SORTING_ORDER)ÚascZdescZ SORTING_FIELDr×z,Invalid SORTING_ORDER for 'VirtualFields': "r½cSsg|]}|‘qSr!r!r¾r!r!r$rÁžsz3ExpressionService.virtualFields..cSsg|]}|r| ¡‘qSr!rÂrÄr!r!r$rÁ srÅrÆrªr«rÇrÈrÉNr¬r­)Frr3rrrcrdr8rerfrgrqrsrrhrrirjrkrrlrmrnrorprtrrurvrwrxryrzr{r|r}r~r=rr ÚsetLimitÚintÚ ValueErrorÚlowerZ OrderByClauseÚ setOrderByZOrderByrrÊrËrÌr‡rÍr‹r·r¸r¹rÎr r´r®rrŽrr9r€rr r‚rr¶)#r@r(r)r‘r’r“ZvirtualsZvir_jsonr”r•r–r—r˜rBr™rÏZ req_filterZreq_expZ req_limitZreq_sorting_order_paramZreq_sorting_fieldZorder_by_clauserÐrÑrÒr‡rÓr¤rÔrÕr¥rÖZextrarWržr!r!r$r<s$ ý  ý ýÿ ý   ý     ý   ÿü  ý    ý     ý         zExpressionService.virtualFields)Ú__name__Ú __module__Ú __qualname__r±r%r&rrrrCÚ staticmethodrr9r:r;r<r!r!r!r$r,s2 ÿ 3Z ÿ\ ÿ_r)*Ú __copyright__Ú __license__Ú __email__rcrfÚtypingrÚ qgis.corerrrrrrr r r r r rZqgis.PyQt.QtCorerrrÚ qgis.serverrrrrZlizmap_server.corerrrrrZlizmap_server.exceptionrÚlizmap_server.loggerrÚlizmap_server.toolsrrr!r!r!r$Ús 8