jL
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 d
Z G d d Z G d
de ZdS ) )Image)uuid4N)Output)convert_from_path)*)datetime)CounterFc dS )N r M/var/www/html/soft/v2017b/4_specific/TOOSMART_DIGICOCHE/2_tools/ocr/Holvia.pygetTimer s
2r
c 2 e Zd ZdZdZdZdZdZdZdZ dZ
d Z d
S ) bcolorsz[95mz[94mz[96mz[92mz[93mz[91mz[0mz[1mz[4mN) __name__
__module__ __qualname__HEADEROKBLUEOKCYANOKGREENWARNINGFAILENDCBOLD UNDERLINEr r
r r r s;
F
F
FGG D D DIIIr
r c e Zd ZdZdZdZdZdZg Zg Z i Z
dZ dZ dZ
dZdZdZd ZdZg ZdZdZdZdZdZd
Zg Zd Zd Z d
Z d Z d Z d Z dS )Holviatoosmartr i5Hf7MSHKkPN1hy r g z#COCHE[ ]?FILIE[ ]?RE[ ]?LBC[ ]?[Vv]iv z,/home/serge/www/toosmart_digicoche/data/tmp/Fc 6 || _ || _ t j | j | j | j | j | _ | j | _ || _ || _ || _
|| _ d S # | d Y d S xY w)N)hostuserpasswddbu* Erreur de connexion à la base de données)
sqlDbsqlHostMySQLdbconnectsqlUser sqlPasswdconncursorpdfoutputFileName ocrFolderdebug
printDebug)selfr0 r1 ocrDirectorydbNamer) r3 s r __init__zHolvia.__init__D s
J DJ"DL N T\ UYUchlhrsssDI )**,,DKDH"0D )DN DJJJ J OO H I I I I I Is A:A> >Bc Z | j dz |z | _ | j rt | d S d S )Nz
) _debugOCRr3 print)r5 pTxts r r4 zHolvia.printDebugT s8 (2T9 : $KKKKK r
c
g }t | j | j }d}g }nT# t $ rG}| d|dt | | d Y d }~nd }~ww xY w |D ] } dt
| z dz }| | j dz t
| z dz d t j
| j dz t
| z dz }| } t j |t j
}
t j |
dd t j t j z d
} t j t j d } t j | t j | d
}
t j |
t j t j }t1 | d
k r|d n|d
}|D ]}t j | |gddd
t j | dd } t7 j t; j | dd }t j | j dz t
| z dz | | | | tC j" | j dz t
| z dz |d
z }Y# t $ r}tG j$ \ }}}|j% j& j' }|j( }tS d| tS d| tS d| | d|dt | | d Y d }~d }~ww xY wtU j+ | j, |d }||- | _. nXtU j+ d|d }|d| _. n3tS d d | _/ | |d d S tU j0 d |d }t1 | dk r.t
|d 1 d d! | _2 | |d | d" tU j0 d#|d tT j3 }t1 | dk r |D ] }|| _4
n[# t $ rN}d$| _4 | d%|dt | | d& Y d }~nd }~ww xY w| j4 d$k r,| 5 rtS d' d | _/ d S d} |D ] }| | tU j0 d(| }t1 | dk r| j6 7 | t1 | | j8 z | _8 |D ]l}|d 1 d)d* } | 1 d+d$ } ts | j: ts tw | d, z d, | _: m tU j0 d-|d tT j3 }t1 | dk r3|D ]0}|d
1 d*d$ | _< |d | _= 1nT# t $ rG}| d%|dt | | d& Y d }~nd }~ww xY w t7 j> || t6 j? j@ . } | A | | n # | d Y nxY w|d
z }
tC j" | j | jB z d/z C d0 } | | j | jB z d1z d | jD 2 d S # t $ r}tG j$ \ }}}|j% j& j' }|j( }tS d| tS d| tS d| | d|dt | | d Y d }~d S d }~ww xY w# t $ r}tG j$ \ }}}|j% j& j' }|j( }tS d| tS d| tS d| | d|dt | | d Y d }~d S d }~ww xY w)3Nr zUnexpected err= , type(err)=ERRORPage_.jpgJPEG )( rE )
iterations )rD rD rD ) rJ fraz --oem 0 --psm 4)langconfig _result.jpgException type: File name:
Line number:
Unexpected e=
, type(e)=z-COCHE[ ]?FIL[ \/]?([IE])[BR]E[ ]?LBC[ ]?[Vv]?zCOCHE FILIERE LBC VPFz{"blNonIntegrable":1}TFu- Livré le ([O0-9]{1,2}\/[O0-9]{2}\/[O0-9]{4})O0u& lecture le numéro du bon de livraisonuH [A-ZÊ][a-z]n de livraison[\n]+[a-z\W_]+[0-9]{3}[a-zA-Z 0-9]+ ([0-9]{8})r zUnexpected1 err=ERROR1z{"blEnDoublon":1}z6 ([0-9 ]{1,5}[ ]?[.,][ ]?[0-9]{1,2}).* ([0-9 ]{10,11}),. rJ z3TOTAL MARCHANDISES\D+(([0-9])+)\D+(([0-9.,])+)\D+KG) output_typez -color-0.jpgRGBz-BL.pdf)save_all
append_images)Er r0 ocrDpi Exceptionr4 typestrsaver2 cv2imreadcopycvtColorCOLOR_BGR2GRAY thresholdTHRESH_BINARY_INV THRESH_OTSUgetStructuringElement
MORPH_RECT morphologyEx
MORPH_OPEN findContours
RETR_EXTERNALCHAIN_APPROX_SIMPLElen drawContours GaussianBlur pytesseractimage_to_stringnparrayimwriteappendr opensysexc_infotb_framef_code co_filename tb_linenor; researchcleCochegroup
typeLivraison
nonIntegrablefindallreplace
dateLivraison MULTILINE_numBlblExist
linesPoidsextendqttCocheCalculeroundpoidsTotalCalculefloatpoidsTotalDetecteqttCocheDetecte
image_to_datar DICTsurlignerZonesr1 convert mergedImage) r5 imageAmelioreeSurligneepagesPdfiPageocrReturnArrayerrpage
image_nameimgresultgraythreshhorizontal_kernelremove_horizontalcntscdfeexception_typeexception_objectexception_tracebackfilename line_numbermelementjSfilepoidpoidsTmptesseract_outputims r readz Holvia.readZ s t %
)*,' -TXt{CC!#
)
)
) Bc B Bd3ii B BCCC((((((((
)
2 -
- -
-,-!(3u::!5!>JIIdnw 6U Cf LfUUU *T^g%=E
%JV%STTC XXZZF <S-?@@D ]4C+.+@3?+R T TTU WF(+(A#.RY(Z(Z%(+(89< 9JDE)G )G )G% +,=s?P,/,C E ED&)$ii1nn477$q'D ! N N(!b/1MMMM -ffa @ @F %4RXf5E5EEYklllBK 83u:: E
UW]^^^"))"---+225:dnw>VY\]bYcYc>cfs>s3t3tuuu !AIEE - - -LOLNNIN$46I 2 ; B NH"5"?K,n===-222/;777OO$B!$B$BQ$B$BCCCOOG,,,,,,,, - $- ):;;A}%&WWYY""I NP^_`Pabb=)@D&&
1222)-D&OON1$5666 5
K^\]M^__A1vvzz%(1YY%6%6sC%@%@"
OON1 - . . .
* HIIIJ jlz{|l} A K L Lq66A::#$ . .&-
*
*
* Cs C CtCyy C CDDD))))))))
*
{b <<>> !-...)-D& 5 A 1' (
(
&&&J XZ_``q66A::O**1---+.q66D4H+HD( ! n n#'7??3#<#<#+#3#3C#<#<16t7MPUV[\dVeVeghPiPi7ikl1m1m..
.
#Y[ijk[l#%<1 1A 1vvzz'( > >G5J 1 ; (.999mX...o{333 >a > >DGG > >???(((((((((
) % % %DGLNN AN ,.A*3:FH-7K $n 5 5 5 - * * * /; / / / OO :! : :Q : : ; ; ; OOG $ $ $ $ $ $ $ $ $ %s $ b.
A5=A0+b. 0A55 b. ?IKb.
N B N :b. NBb. A7b. AS/ .b. /
U9AU=b. U8b. C*b. ,A,[b.
\*#=\% b. %\**b. .A]0/b. 0^ b. A$_: :
b+B b& b. &b++b. .
e 8B ee c
t j | j dz t | z dz }g }nH# t $ r;}t d|dt
| t d Y d }~nd }~ww xY wt |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 w t j |t j }t! j |d } | j \ }
}|
d z |d z f}| | d }|d
k r| j
| | | j | j z d z t | z d z n# t $ r}t1 j \ }}}|j j j }|j }t d | t d | t d!| t d"| j | j z d z t | z d z | d#|d$t
| | d% Y d }~nd }~ww xY wd&S )'Nr@ rN zUnexpectedC err=r> ERRORClevel rE lefttopwidthheightr conftext)xyr r rotation
confidencer U )* 2 )r rD )r r rD r r g ?zUnexpectedD err=ERRORDr[ z-color-rA rO rP rQ zImage : rR rS r? T) rc rd r2 ra r_ r; r` enumerateintre rectangleFILLED addWeightedrz rf
COLOR_BGR2RGBr fromarraysizeresizer r rb r1 r| r} r~ r r r r4 )r5 r r imageASurlignerblockASurlignerr i level_idxbboxcoloroverlayalphar r r new_size
resized_imager r r r r r s r r zHolvia.surlignerZones sA !j ')ACJJ)NQ^)^ _ _O OO 555c55 6 6 6 (OOOOOOOO &&6w&? @ @ $ $LAyA~~ -f 5a 88 -e 4Q 77 !1'!:1!= = "28"X"Y[`bebln n n E&)oguoWX[`W`bc&d&dO#**40000 $ $ $===c==>>>(OOOOOOOO$3 < % !l?Cz$Holvia.mergeData..Y s/ S S S41a199S"#5#5 6 S S Sr
r rY r rE rH r )poidsdateeleveurtuerielotz%d/%m/%Yz%Y%m%dz
%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"z');UnexpectedA err=r> zERROR A2z{"blId":}zLine merged : r 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,attf104) VALUES (1, 11, NULL, 11, 1, 0, null, null, null, null, null, 'r rO rP rQ rR rS r? )%r r r ra quantiemeVersDater
lineMergedr strptimer strftimenow
idAbattoirr r r r r r r: r4 r/ executer_ r; r` lastrowid
enAnomaliedateLivraisonLigner. closer| r} r~ r r r )r5 linePoids currentDatesqlr blIdkey numeroTuerier r r r r r s r mergeDatazHolvia.mergeDataS s ^ %!
u T S4? S S SDO !_
K
K ?H|?S?STWY[?\?\>A$BXBXY\]fgh]ijklmjm]nYoYoBpBp>q>qAC@I! RSS@Q=Fq\ 6K 6K ! RSS 122
(%-%6t7I:%V%V%_%_`h%i%i""
(%'"""?
) 'lnn 5 5l C C #:>>*%%%%%%%%&
{, j3t99,s2333 0111 ? - -C&'DO,26/#2Fv2N//,24/*+ $'ts';E'B#C#CBCC#HL BE B B % &(+ ,U3)5 )5 57= >@CL@Q@Q RTZ []` ,W5^7 ^7 7 :@ @ CFdF]B^B^ _ bh h kn k) k) ) ,2 2 594F G JO O K'',,,, !!!!!
)
)
)HK E 02E.7>J 1 ; (.999mX...o{333 >a > >DGG > >???(((((((((
) % % %DGLNN AN ,.A*3:FH-7K $n 5 5 5 - * * * /; / / / OO :! : :Q : : ; ; ; OOG $ $ $ $ $ $ $ $ $ %s R: B'R: 32C& %R: & C1/R: 5D P /H1 0P 1
I6;1I1,P 1I66AP K'&P 'K97D
P
R7B R2,R: 2R77R: :
U+B U&&U+c
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 d
|d t | t d Y d }~d S d }~ww xY w)
Nr r d i )
r < [ y i i1 iO in )
r r ; Z x r i i0 iN im rE
z{:02d}r r> z ERROR A4 ) r r yearrangera formatr_ r; r` )r5 najmr r s r r zHolvia.quantiemeVersDate s= #A NQ!C1 SA QQ1b\\
b
ba5A:: q66C(:(:$;$;;c(//RSVXYZ]^Y^V_R_B`B`>a>aaaaa
b
b
555c55 6 6 6 + s B9B? <B? ?
D 1D DN)!r r r r, r) r- r( r r linesLotsr r r r
poidsTotalr r^ r2 r1 motsASurligner
dateTuerier r r r r r r8 r4 r r r r r r
r r r ) s GG!I EJJIJMMJJ4H
F>INNJ OOMKJ J J u% u% u%p E> > >@_% _% _%B r
r )PILr uuidr json ImportErrorru r rc r| r pdf2imager TSLibOCRtimeosnumpyrw TS_OCRr* r collectionsr r3 r r r r r
r r) s KKKK LLLLL
' ' ' ' ' '
A \ \ \ \ \ V \ \ \ \ \ s