j? d dl mZ d dlmZ d dlZn# e$ r d dlZY nw xY wd dlZd dlmZ d dlZd dl Z d dl
Z
d dl m Z d dl
T d dlZd dlZd dlZd dlT d dlZd dlmZ d dlmZ d Z G d
d e ZdS ) )Image)uuid4N)Output)convert_from_path)*)datetime)Counterc dS )N r N/var/www/html/soft/v2017b/4_specific/TOOSMART_DIGICOCHE/2_tools/ocr/Cooperl.pygetTimer s
2r
c e Zd ZdZdZdZdZdZg Zg Z i Z
dZ dZ dZ
dZdZdZd ZdZg ZdZdZdZdZdZdZd
ZdZd Z d Z d
Z d Z d Z d Z!dS )CooperlFtoosmartr i5Hf7MSHKkPN1hyr g z#C[\w\S]*E COUPE EURO [EF]ILIERE LBC z,/home/serge/www/toosmart_digicoche/data/tmp/ c || _ || _ || _ t j | j | j | j | j | _ | j | _ || _ || _
|| _ | d | dt | z d S # | d Y d S xY w)N)hostuserpasswddbu# Connexion à la base de données OKzoutputFileName = u* Erreur de connexion à la base de données)debugsqlDbsqlHostMySQLdbconnectsqlUser sqlPasswdconncursorpdfoutputFileName ocrFolder
printDebugstr)selfr$ r% ocrDirectorydbNamer r s r __init__zCooperl.__init__: s J DJ DJ"DL N T\ UYUchlhrsssDI )**,,DKDH"0D )DN OO A B B B OO /#n2E2E E F F F F F J OO H I I I I I Is B4B8 8Cc Z | j dz |z | _ | j rt | d S d S )Nz
) _debugOCRr print)r) pTxts r r' zCooperl.printDebugL s8 (2T9 : $KKKKK r
c
t | j | j }d}g } |D ]^} dt | z dz }| | j |z d t
j | j |z }| }t
j | j dz t | z dz | t j | j dz t | z dz }t j
t j | dd } | | |dz } # t" $ rH}
| d |
d
t' |
| d Y d }
~
Xd }
~
ww xY w t) j | j |d } | | | _ nz| d
| |d | d
| d| j z t3 d d| _ dS nT# t" $ rG}
| d |
d
t' |
| d Y d }
~
nd }
~
ww xY w| d|d z | d|d z t) j d|d t( j } t; | d k r
| D ] } | | _
nRt) j d|d t( j t( j z } t; | d k r | D ] } | | _
n[# t" $ rN}
d| _ | d|
d
t' |
| d Y d }
~
nd }
~
ww xY w| j dk r,| rt3 d d| _ dS t) j d|d } t; | d k rvt | d ! dd ! dd ! d d | _" | j# | d t) j d| j z d z |d t( j } t; | d k r | D ] } | d | _$ | d | _% nT# t" $ rG}
| d |
d
t' |
| d Y d }
~
nd }
~
ww xY w|D ]}
| j dk rt) j d!|
} t; | d k r| j& ' | t; | | _( | D ]a}tS | j* tS tW |d ! d"d# d$ z d$ | _* |d | _, bt j- t j | t j. j/ % } | 0 | d S # t" $ r<}
t3 d&|
d
t' |
t3 d' Y d }
~
d S d }
~
ww xY w# t" $ r}tc j2 \ }}}|j3 j4 j5 }|j6 }t3 d(| t3 d)| t3 d*| | d+|d,t' | | d Y d }~d S d }~ww xY w)-N Page_z.jpgJPEGz _result.jpgfraz --oem 0 --psm 4)langconfigUnexpected err= , type(err)=ERRORr z------u, Le BL ne comporte pas la bonne clé coche : z{"blNonIntegrable":1}TFz1 : z^([0-9]{6}) [\w]+$u* [A-Z]ON DE LIVRAISON[ ]?N°[\D]+([0-9]{6})r zUnexpected1 err=ERROR1z{"blEnDoublon":1}zYDate livraison\s+((?:[0-9oO ]\s*){1,3}\/\s*(?:[0-9oO ]\s*){1,3}\/\s*(?:[0-9oO ]\s*){2,3}) o0Oz \D+(([\d,])*)[| ]*(([\d,])*) zUnexpected 1 err=z8([0-9]{1,3})[. ]{0,2}([0-9]{1,4}) ([0-9]{1,3}[.,][0-9]*),. ) output_typez Unexpected 2 cooperl.py err=ERROR2Exception type: File name:
Line number:
Unexpected e=
, type(e)=)7r r$ ocrDpir( saver& cv2imreadcopyimwriter open pytesseractimage_to_stringnparrayappend Exceptionr' typeresearchcleCochegroup
typeLivraisonr/
nonIntegrablefindall MULTILINElen_numBl
IGNORECASEblExistreplace
dateLivraisonmotsASurlignerpoidsTotalDetecteqttCocheDetecte
linesPoidsextendqttCocheCalculeround
poidsTotalfloat quantieme
image_to_datar DICTsurlignerZonessysexc_infotb_framef_code co_filename tb_lineno)r) pagesPdfiPageocrReturnArraypage
image_nameimgimageAmelioreeimageAmelioreeSurligneedferrmelementSfilepoidtesseract_outputeexception_typeexception_objectexception_tracebackfilename line_numbers r readz Cooperl.readR s M %(4;??HE N 1
-
--!(3u::!5!>JIIdnz 96BBB *T^j%@AAC%(XXZZNK 83u:: E
UWefff.3j '9QTWX]T^T^9^an9n.o.o+ %4RXn5M5MTYbtuuuB"))"--- "AIEE ! - - -OO$F#$F$F$s))$F$FGGGOOG,,,,,,,,-
)Idm^A->??=)*D&&
OOH---OON1$5666OOH---OO$RSWS`$`aaa1222)-D& 5 '
)
)
) Bc B Bd3ii B BCCC((((((((
)
OOF^A%6 6 7 7 7
*~a'8 8999J 4nQ6G VVq66A::#$ . .&- .
#PR`abRcdfdpsu tA eA B BA1vvzz'( 2 2G*1DKK
*
*
* Cs C CtCyy C CDDD))))))))
*
{b <<>> !-...)-D& 5
w zH IJ zK L LA1vvzz%(1YY%6%6sB%?%?%G%GS%Q%Q%Y%YZ]_b%c%c"#**1Q4000
*Js4= 01O OQ_`aQbcecoppq66A::#$ : :18./6qz,,
*
*
* D D DS D DEEE))))))))
*
(
5
5 %++
#^`effA1vvzz ..q111/21vv,$% 5 5D.3DOeERVWXRYRaRabegjRkRkLlLlnoFpFp4prs.t.tDO-1!WDNN + 8BY9Z9Zgrgyg~
##$455555
EEEcEEFFFh
% % %DGLNN AN ,.A*3:FH-7K $n 5 5 5 - * * * /; / / / OO :! : :Q : : ; ; ; OOG $ $ $ $ $ $ $ $ $ %s $Z6 DD.,Z6 .
F 8=E;5Z6 ;F Z6 B4H; :Z6 ;
J =JZ6 J !Z6 .B6M% $Z6 %
N=/AN83Z6 8N==8Z6 7B$Z6 A#T ?Z6
U
=U Z6 UDZ6 Y- -
Z371Z.(Z6 .Z33Z6 6
]' B ]""]'c
t j | j dz }g }nH# t $ r;}t d|dt | t d Y d }~nd }~ww xY w t
|d D ]\ }}|dk rd|d | z d|d | z d|d
| z d|d | z d |d
| |d | d}t |d
| dk rd}n$t |d
| dk rd}nd} | } t j | |d |d f|d |d
z |d |d z f|t j
d}
t j | |
|d|
z
d }| | J# t $ r<}t d|dt | t d Y d }~d }~ww xY wnH# t $ r;}t d|dt | t d Y d }~nd }~ww xY w t j
|t j }t j |d } | | j | j z d z nH# t $ r;}t d t d |dt | Y d }~nd }~ww xY wd S ) NzPage_1_result.jpgzUnexpected C err=r9 ERRORClevel r2 lefttopwidthheightr conftext)xyr r rotation
confidencer U )* 2 )r )r r r r r g ?zUnexpectedD err=ERRORDzUnexpected D err=RGBz-BL.pdferreurzUnexpectedE err=T)rM rN r& rW r/ rX enumerateintrO rectangleFILLED addWeightedrV cvtColor
COLOR_BGR2RGBr fromarrayrL r% ) r) r imageASurlignerblockASurlignerr i level_idxbboxcoloroverlayalphar s r rs zCooperl.surlignerZones s !j :M)M N NO OO 6#66$s))66 7 7 7 (OOOOOOOO )*:7*C D D
(
( 9 >> !1&!9!!< < !1%!8!; ;!"%5g%>q%A!A"#&6x&@&C"C$%&6v&>q&A 0 8 ; D +F3A6772== . -f 5a 899R?? - + ("1"6"6"8"8
gS 49/E'+Cy4='@$s)dS[nB\&]_dfifpr r r #*-/'5/[\_d[dfg*h*h'..t4444$ ( ( ( AS A AT#YY A ABBB h(3 "
(: 6#66$s))66 7 7 7 (OOOOOOOO 7 !l?C}t d
|dt | t d|z Y d }~nd }~ww xY w| j j }t d t# | z d z | j dk rd| _ | j D ]`}t# | j | d d d }d t# | z d!z t# | z dz t# | j | d z dz t# | t; | j z dz t# | j z dz t# | j z dz | j z dz } | j | # t $ rN}t d
|dt | t d"|z t | Y d }~Zd }~ww xY w| j d S # t $ r}tC j" \ } }
} | j# j$ j% } | j& }
t d#| t d$| t d%|
| ' d&|d't | | ' d( | ' | Y d }~d S d }~ww xY w))NFr@ r r2 )poidsrp lotz%d/%m/%yz%Y%m%dr r rA rB rC r8 r9 zERROR A1z
%Y%m%d%H%MzINSERT INTO tier_att(id_base, id_type, id_tier,attdatcre, id_work, actif, newobj, att1, att2, att3,att6,att7,att8,att9,attf100,att17,att90) VALUES (1, 10, NULL,'z
', 16, 1, 0, z, 'z', 'z','z ',ROUND('z'),''z\'z');z ERROR A2 z{"blId":}r zINSERT INTO prod_att(id_base, id_type, id_prod, id_work, actif, newobj, fid_prod, type, name, revision, `desc`, att1, att2, att3, att4, attf100, attf101,att10,attf104) VALUES (1, 11, NULL, 11, 1, 0, null, null, null, null, null, 'z','', 'z ERROR A3 rF rG rH rI rJ r: )(r^ rj
lineMergedr strptimerf strftimera rl rm poidsTotalCalculero re rW r/ rX nowr(
idAbattoirr] rh ri rb r. r# execute lastrowidrp quantiemeVersDater
enAnomalier" closert ru rv rw rx ry r' )r) linePoidskeyr currentDatesqlblId numeroTuerier r r r r r s r mergeDatazCooperl.mergeData s J !!
u !_
x
x ;DQ ? ? D @ CFC C %&(+L(9(9:/B/BC FKK NRM_` chh
K'',,,, <<<S <<===++,,,#JJJJJJJJ
IOO
!
!
!DGLNN AN ,.A*3:FH-7K $n 5 5 5 - * * * /; / / / OO :! : :Q : : ; ; ; OOG $ $ $ OOC
!s Q= 0Q= 2A/ .Q= / A:8 Q= A'C? >Q= ?
E 1D?:Q= ?EDQ= I. -Q= .
J684J1,Q= 1J66D4Q= +PQ=
Q AQQ= Q Q= =
UB1T>>Uc
t j j } |dz dk r |dz dk s |dz dk rd}nd}t dd D ]q}|| |k rct | t d | z t d |||dz
z
z c S rd S # t $ r}t j \ }}}|j j
j } |j }
t d
| t d | t d |
t d
| | d|dt | | d Y d }~d S d }~ww xY w)N r d i )
r < [ y i i1 iO in )
r r ; Z x r i i0 iN im r2
z{:02d}rF rG rH zn: rI rJ r: )r r yearranger( formatrW rt ru rv rw rx ry r/ r' rX ) r) najmr r r r r r r s r r zCooperl.quantiemeVersDateg s % #A N1aAcE1HH3EE1R[[
^
^a5!88 q66C(:(:$;$;;c(//RSTVWXYZWZT[R[B\B\>]>]]]]]
^
^
% % %DGLNN AN ,.A*3:FH-7K $n 5 5 5 - * * * /; / / / %OOO OO :! : :Q : : ; ; ; OOG $ $ $ $ $ $ $ $ $ %s B9B? <B? ?
F B,E;;F N)"__name__
__module__ __qualname__r r r r! r rj linesLotsr rf r] r rn r[ rK r& r% rg
dateTuerier rh rl ri r^ r rp r, r' r rs r r r r
r r r s EGG!I EJIJMMJJ4H
F>INNJ OOMJIJ J J$ N% N% N%` E4 4 4nK! K! K!Z% % % % %r
r )PILr uuidr json ImportErrorrR r rM rt rY pdf2imager TSLibOCRtimeosnumpyrT TS_OCRr r collectionsr r r r r
r r s_ KKKK LLLLL
' ' ' ' ' ' A b% b% b% b% b%f b% b% b% b% b%s