'NfdZdZdZdZddlZddlZddlmZmZdZ e dkr3ej ej e ZnejZ dZdZed krejddSdS) get_efence_dataN) DbConnect DbDisconnectEXEPYcbd}d}d}d}d|d}d|d}d }|d d krd |d }d }|d d krd |d }d} ||z|z|z|z| z} ||z|z| z} | S)NztSELECT car_license.license, efence_events.eventDT, efence_events.eventType, efence_area.areaName FROM efence_events zALEFT JOIN car_license ON efence_events.carId = car_license.carId zCLEFT JOIN efence_area ON efence_events.areaId = efence_area.areaId zWHERE (z"efence_events.eventDT >= '{}' AND strStartzefence_events.eventDT <= '{}'strEnd carLicensez$ AND car_license.license LIKE '%{}%'areaNamez% AND efence_area.areaName LIKE '%{}%'z);)format) queryParam selectStmt joinStmt1 joinStmt2 whereStmt1whereStmtStart whereStmtEnd whereStmtCar whereStmtArea whereStmt2 whereStmtsqlStmts */srv/django_bis/apps/parsefile/searchef.pyComposeSqlStmtrMsHJSIUIJ;BB:jCYZZN4;;JxrGs0    $ ,+++++++   !:!:;;JJJ8,,,^ z CHQKKKKKr