a
gF? @ s z$d dl mZ d dlmZ d dlZW n ey> d dlZY n0 d 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 d
ZG d d d eZdS )
)Image)uuid4N)Output)convert_from_path)*)datetime)Counterc C s dS )N r
r
r
_/mnt/bigdisk/leo/remi/toosmart/soft/v2017b/4_specific/TOOSMART_DIGICOCHE/2_tools/ocr/Cooperl.pygetTime s r c @ s e Zd ZdZdZdZdZdZg Zg Z i Z
dZ dZ dZ
dZdZdZd ZdZg ZdZdZdZdZdZdZd
ZdZd d Z d
d Z dd Z dd Z dd Z dd Z!dS )CooperlFtoosmartr i5Hf7MSHKkPN1hyr g z#C[\w\S]*E COUPE EURO [EF]ILIERE LBC z,/home/serge/www/toosmart_digicoche/data/tmp/ c C s zl|| _ || _|| _tj| j| j| j| jd| _| j | _|| _ || _
|| _ | d | dt
| W n | d Y n0 d S )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 r
r
r __init__: s
zCooperl.__init__c C s" | j d | | _ | jr t| d S )Nz
) _debugOCRr print)r$ pTxtr
r
r r" L s zCooperl.printDebugc C sF zt | j| j}d}g }|D ]}zdt| d }|| j| d t| j| }| }t | jd t| d | t
| jd t| d }t j
t|ddd} || |d }W q ty }
z0| d |
d
t|
| d W Y d }
~
q d }
~
0 0 q ztt| j|d } | d ur:| | _nH| d
| |d | d
| d| j td d| _W W dS W nJ ty }
z0| d |
d
t|
| d W Y d }
~
n
d }
~
0 0 | d|d z| d|d td|d tj } t | d kr,| D ] } | | _ q n:td|d tj tj B } t | d krf| D ] } | | _ qXW nP ty }
z6d| _ | d|
d
t|
| d W Y d }
~
n
d }
~
0 0 | j dkr| rtd d| _W dS td|d } t | d kr(t| d !dd| _"| j#| d zPtd| j d |d tj } t | d krv| D ]} | d | _$| d | _%qZW nJ ty }
z0| d |
d
t|
| d W Y d }
~
n
d }
~
0 0 |D ]}
| jdkrtd |
} t | d kr| j&'| t | | _(| D ]8}t)| j*t)t+|d !d d d! d!| _*|d | _,q qt j-t|t j.j/d"}z| 0| W nF ty }
z,td#|
d
t|
td$ W Y d }
~
n
d }
~
0 0 W n ty@ } zlt12 \}}}|j3j4j5}|j6}td%| td&| td'| | d(|d)t| | d W Y d }~n
d }~0 0 d S )*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}z:Date livraison ([0-9 ]{1,3}/ *[0-9 ]{1,3} */ *[ 0-9]{2,3}) z \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=ZERROR2Exception 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_nameimgZimageAmelioreeimageAmelioreeSurligneedferrmelementSfilepoidtesseract_outputeexception_typeexception_objectexception_tracebackfilename line_numberr
r
r readR s
"
("
z Cooperl.readc C s zt | jd }g }W nD ty\ } z,td|dt| td W Y d }~n
d }~0 0 zft|d D ]R\}}|dkrnd|d | d|d | d|d
| d|d | d |d
| |d | d}t|d
| dkrd}n t|d
| dkr
d}nd}zl| } t | |d |d f|d |d
|d |d f|t j
d}
t | |
|d|
d }| | W qn ty } z,td|dt| td W Y d }~qnd }~0 0 qnW nF ty } z,td|dt| td W Y d }~n
d }~0 0 z4t
|t j}t|d} | | j| j d W nF ty } z,td td |dt| W Y d }~n
d }~0 0 d S ) NzPage_1_result.jpgzUnexpected C err=r2 ERRORClevel r+ 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)rB rC r! rL r) rM enumerateintrD rectangleFILLED addWeightedrK cvtColor
COLOR_BGR2RGBr fromarrayrA r ) r$ r| imageASurlignerblockASurlignerrw i level_idxbboxcoloroverlayalphart r
r
r rh sX
$$ .zCooperl.surlignerZonesc C s z.| j rW dS | jD ]&}|d |d |d d| j|d < qzt| jdd| _W n d| _Y n0 t| j| _z>| jD ]2}t | j
t t | j| d d
d d d | _
qW nD t
y } z,td
|dt| td W Y d }~n
d }~0 0 t d}dt| d t| j d | j d t| j
d t| j d t| j
d t| j d t| j d | j d | j d | j dd d }z| j| W nJ t
y } z0td
|dt| td| W Y d }~n
d }~0 0 | jj}td t| d | jdkr(d| _| jD ]}t| j| d d d }d t| d! t| d t| j| d d t| t | j d t| j d t| j d | j d }z| j| W nR t
y } z8td
|dt| td"| t| W Y d }~n
d }~0 0 q.| j W n t
y } zvt!" \} }
} | j#j$j%} | j&}
td#| td$| td%|
| 'd&|d't| | 'd( | '| W Y d }~n
d }~0 0 d S ))NFr6 r r+ )poidsre lotz%d/%m/%yz%Y%m%dr r r7 r8 r9 r1 r2 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 r; r< r= r> r? r3 )(rS r_
lineMergedr strptimer[ strftimerV ra rb poidsTotalCalculerd rZ rL r) rM nowr#
idAbattoirrR r] r^ rW r( r execute lastrowidre quantiemeVersDater
enAnomalier closeri rj rk rl rm rn r" )r$ linePoidskeyrw currentDatesqlblId numeroTuerier} r~ r r r r r
r
r mergeData s
$
4 ( "
"
zCooperl.mergeDatac
C s$ zt j}|d dkr$|d dks0|d dkr6d}nd}tddD ]F}|| |krDt|td | td |||d W S qDW n ty } zvt \}}}|j j
j } |j }
t
d
| t
d | t
d |
t
d
| | d|dt| | d W Y d }~n
d }~0 0 d S )N r d i )
r < [ y i i1 iO in )
r r ; Z x r i i0 iN im r+
z{:02d}r; r< r= zn: r> r? r3 )r r yearranger# formatrL ri rj rk rl rm rn r) r" rM ) r$ najmrx r} r~ r r r r r
r
r r g s$
$ <
zCooperl.quantiemeVersDateN)"__name__
__module__ __qualname__r r r r r r_ linesLotsr r[ rR r rc rP r@ r! r r\
dateTuerier r] ra r^ rS r re r' r" r rh r r r
r
r
r r
s@ 7Mr
)PILr uuidr json ImportErrorrG r rB ri rN pdf2imager TSLibOCRtimeosnumpyrI TS_OCRr r collectionsr r r
r
r
r
r s*