Ƣf BddlZddlmZddlZddlZddlmZdZdZdS)N)Error)datecN|dr|dr ||dz|zz }n|dr&|ds|d|zz }|dnX|dr&|ds|d|zz }|dn*|d|d||fS)NAND )pop)listsidnames (/srv/django_bis/apps/parsefile/search.pyarranger s 7 tAw  RZ_ !! !W T!W  VBY,! ((1++++ !W T!W  VD[.! ((1++++ ((1+++ ((1+++Ahc tjdddd}|}d}d}d}d }d }d }d } d } |d} |dd } d} |d |dkr:|d r|drd} | |dz|zz } t || ||\}} t |dkrVd|z| z} |d|| t|| } nJ| |dzz } |dt| |dd} || t|| } n|d s,|ds#d} td| |dzz } |dr|dr | |dz|zz } n|dr#|ds| |z } |dnW|dr#|ds| |z } |dn,|} |d|d| || zdzz } |d|d || t|| } n|d |dkr|d r|drd} td| |dz|zdz|zz } t || ||\}} | || zdzz } t|| || t|| } | | | fS#t$r=}tdt|ztjdYd}~nd}~wwxYw|dS)Nz 127.0.0.1itransdb itranswlcz 1tr@nsb1rry)hostdatabaseuserpasswordz select * from drivers_info_hist u變動生效日期 >= %s u變動生效日期 <= %s u!姓名 like CONCAT('%', %s, '%') u!工號 like CONCAT('%', %s, '%') z ORDER BY rzwhere ru(select drivers_info_hist.* from drivers_info_hist, (select 姓名, max(變動生效日期) as 變動生效日期 from drivers_info_hist where 變動生效日期 <= %s group by 姓名)MAX where drivers_info_hist.姓名= MAX.姓名 and drivers_info_hist.變動生效日期 = MAX.變動生效日期 u變動生效日期 DESC2r rrz DESCaz!Error connecting to the database:)mysql connectorconnectcursorr rlenexecutetuplefetchallprintfetchonerstrsysexitclose)r connectionr headsdedr r orderr checksortvar1searches rsearchdbr5s H''     (:     6*4!2!2+4)2 51 5 Q488A;;; 4 6 1gq Q$!DG$! 4= tAb&&Q t99q== wx} }~B B! ((1+++ ..5;; ' ' '""&& U, , ,! ((1+++ $s   $ ..5;; ' ' '""&&1g!d1g! c  4= 7 tAw  RZ_ !! !W T!W  R%! ((1++++ !W T!W  T'! ((1++++ ! ((1+++ ((1+++ 5:g     qt%%%   Q47 Q!DG! c  4= F "2 %%tAb&&Q 5:g  d1 qt%%%   e   ,c!ff 45558A;;;;;;;; sM$M'' N.13N))N.) mysql.connectorrrr(csvdatetimerrr5rrr:sv!!!!!!    OOOOOr