U
    'ýNfÒ  ã                   @   s€   d Z dZdZdZddlZddlZddlmZmZ dZ	e	dkrRej
 ej
 e¡¡Zne ¡ Zdd„ Zd	d
„ Zedkr|e d¡ dS )Zget_efence_dataé   é    N)Ú	DbConnectÚDbDisconnectZEXEZPYc                 C   s˜   d}d}d}d}d  | d ¡}d  | d ¡}d	}| d
 d	krJd  | d
 ¡}d	}| d d	krhd  | d ¡}d}	|| | | | |	 }
|| | |
 }|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 zWHERE (z"efence_events.eventDT >= '{}' AND ÚstrStartzefence_events.eventDT <= '{}'ÚstrEndÚ Ú
carLicensez$ AND car_license.license LIKE '%{}%'ÚareaNamez% AND efence_area.areaName LIKE '%{}%'z);)Úformat)Ú
queryParamZ
selectStmtZ	joinStmt1Z	joinStmt2Z
whereStmt1ZwhereStmtStartZwhereStmtEndZwhereStmtCarZwhereStmtAreaZ
whereStmt2Z	whereStmtÚsqlStmt© r   ú)/home/mars/bis/apps/parsefile/searchef.pyÚComposeSqlStmtM   s     r   c                 C   sâ   i }| d | |d< |d | |d< ||d< ||d< t |ƒ}tdƒ}| ¡ }	|	 |¡ g }
tdƒ |	D ]d}|d d	kr–|d
 |d	  d¡d|d g}n*|d dkrÀ|d
 |d	  d¡d|d g}|
 |¡ qf|	 ¡  t|dƒ |
S )Nú r   r   r   r	   u   æ„›è±ç³»çµ±u'   è»Šç‰Œ,æ—¥æœŸæ™‚é–“,å‹•ä½œ,åœç±¬å€åŸŸé   r   r   z%Y/%m/%d %H:%Mu   é€²å…¥é   u   é›¢é–‹)	r   r   ÚcursorÚexecuteÚprintÚstrftimeÚappendÚcloser   )Ú	startdateÚ	starttimeÚenddateÚendtimeÚlicenseÚarear   r   Úconnr   Z
listResultÚrowÚstrr   r   r   Ú	searchef2i   s(    	
 
r"   Ú__main__)Z	PROG_NAMEZ	VER_MAJORZ	VER_MINORZ	VER_BUILDÚosÚsysZdbintfr   r   Z	CODE_TYPEÚpathÚdirnameÚabspathÚ__file__Z
currFolderÚgetcwdr   r"   Ú__name__Úexitr   r   r   r   Ú<module>   s   /