a
g#? @ s z$d dl mZ d dlmZ d dlZW n ey> d dlZY n0 d dlZd dlmZ d dlZd dl Z d dl
m Z d dl T d dl
Z
d dlZd dlZd dlT d dlZd dlmZ d dlmZ d Zd
d ZG d d
d
eZdS ) )Image)uuid4N)Output)convert_from_path)*)datetime)CounterFc C s dS )N r
r
r
_/mnt/bigdisk/leo/remi/toosmart/soft/v2017b/4_specific/TOOSMART_DIGICOCHE/2_tools/ocr/Loudeac.pygetTime s r c @ s e Zd ZdZdZdZdZdZdZdZ g Z
g Z i Z g Z
dZdZdZdZdZdZd ZdZdZd
ZdZdZd d Zd
d Zdd Z dd Z dd Z dddZ dd Z dS ) Loudeactoosmartr i5Hf7MSHKkPN1hyi^ z,/home/serge/www/toosmart_digicoche/data/tmp/FzCOCHE L[R]?[B]?C VPFr g c C s zf|| _ || _tj| j| j| j| j d| _| 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)
sqlDbsqlHostMySQLdbconnectsqlUser sqlPasswdconncursorpdfoutputFileName ocrFolder
printDebugstr)selfr r ocrDirectorydbNamer r
r
r __init__9 s
zLoudeac.__init__c C s | j d | | _ tr t| d S )Nz
) _debugOCRdebugprint)r" pTxtr
r
r r K s zLoudeac.printDebugc C s t | j| j}d}g }|D ] }zdt| d }|| j| d t| j| }| }| |d}t
| jd t| d | t | jd t| d }|
dt tjt|dd d
} || |
d t |d }W q ty6 }
z0|
d |
d
t|
|
d W Y d }
~
qd }
~
0 0 qtd|d } t| dkrt| d | _| j| d |
d| j td|d } t| dkrt| d | _| j| d |
d| j td|d } t| dkrd| _ zJtd|d } t| dkr>| D ]"} | d dd| _ | d | _ qW nJ ty }
z0|
d|
d
t|
|
d W Y d }
~
n
d }
~
0 0 t | j!|d } | d ur| " | _#| jd |
d | j# nTt d |d } | d ur| " | _#| jd |
d | j# nt$d d| _%d S |
d |d z8td!|d tj&} t| dkrl| D ] } | | _'q^W nP ty }
z6d| _'|
d|
d
t|
|
d W Y d }
~
n
d }
~
0 0 | j'dkr| ( rt$d" |
| j' d| _%d S |D ]}
t)d#d$t|d }
| j#dkrtd%|
} t| dkrt| | _*| D ]&}| j|d | j|d qF|
d&tt| |
d't| | j+,| qtj-t|tj.j/d(}z| 0| W n, t$d)|
d
t|
t$d* Y n0 d S )+N Page_z.jpgJPEG z _result.jpgz%s - Lecture OCRfra )langconfigu %s - Lecture OCR TerminéezUnexpected err= , type(err)=ERRORz)[0-9]{5} ([0-9]{1,2}/[0-9]{1,2}/[0-9]{2})r zDate de livraison : z1DATE ABATTAG\D+([0-9]{1,2}\/[0-9]{1,2}\/[0-9]{2})zDate de la tuerie : zYDATE ABATTAG\D+([0-9]{1,2}\/[0-9]{1,2}\/[0-9]{2})[,. ]*([0-9]{1,2}\/[0-9]{1,2}\/[0-9]{2})Tz*TOTAL[\W]+GENERAL\D+([\d]+)\D+([\d\,\. ]+).r zUnexpected1 err=ERROR1z
COCHE LBC VPFzType de livraison : z
POCHP LDC VPFz{"blNonIntegrable":1}Fz1 : u# BON LIVRAISON[ ]?N°[\D]+([0-9]{5})z{"blEnDoublon":1}z , ([0-9])z,\1z ([0-9]{4,5})[ -.]([0-9.,]{5})u Nombre de coches detectées : u Détail des poids : ) output_typezUnexpected2 err=ERROR2)1r r ocrDpir! saver cv2imreadcopyincrease_brightnessimwriter openr r pytesseractimage_to_stringnparrayappend Exceptiontyperefindalllen
dateLivraisonmotsASurligner
dateTueriedateAbattageMultiplereplacepoidsTotalDetecteqttCocheDetectesearchcleCochegroup
typeLivraisonr(
nonIntegrable
IGNORECASE_numBlblExistsubqttCocheCalcule
linesPoidsextend
image_to_datar DICTsurlignerZones)r" pagesPdfiPageocrReturnArraypage
image_nameimgimageAmelioreeimageAmelioreeSurligneedferrmelementSfilepoidtesseract_outputr
r
r readQ s
"
z Loudeac.readc s | j r
dS | jD ]"}|d d|d d| j|d < qzt| jdd| _W n d| _Y n0 zt| jdd| _W n d| _Y n0 t| j| _ z>| jD ]2}t
| j t
t | j| d
d d
d d | _ qW nF ty } z,td |d
t| td W Y d }~n
d }~0 0 t d}| jr>d}nd}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 t| d }z| j| W nN ty@ } z4td |d
t| td t| W Y d }~n
d }~0 0 | jj }td t| d i | jD ]Z}z0 t| j| d d t| j| d < W n" d t| j| d < Y n0 qht fd d d!}| jD ]}t| j| d } d}
t| |kr
d"}
d#t| d$ t| d t| j| d d t| j d t|
d | j d% }z| j| W nF ty } z,td&|d
t| td' W Y d }~n
d }~0 0 q| j d S )(NFr* r r )poidsdatelotz%d/%m/%yz%Y%m%drp ,r4 zUnexpectedA err=r2 zERROR A1z
%Y%m%d%H%M zINSERT INTO tier_att(id_base, id_type, id_tier,attdatcre, id_work, actif, newobj, att1, att2, att3,att6,att7,att8,att9,attf100,att17,att90,att15) VALUES (1, 10, NULL,'z
', 16, 1, 0, z, 'z', 'z',''z\'z',z);zERROR A2z{"blId":}rr c s | S )Nr
)kZtuerieLongueurr
r # z#Loudeac.mergeData..)keyZanomaliezINSERT INTO prod_att(id_base, id_type, id_prod, id_work, actif, newobj, fid_prod, type, name, revision, `desc`, att1, att2, att3, att4, attf100, att8,attf104) VALUES (1, 11, NULL, 11, 1, 0, null, null, null, null, null, 'z','', 'z');zUnexpectedB err=ZERRORB) rU r[
lineMergedr strptimerJ strftimerL rI rZ roundpoidsTotalCalculefloatrN rE r( rF now
enAnomalier!
idAbattoirrT rO rP rW r& r execute lastrowidmaxr close) r" linePoidsr} ri currentDateZstatutBLsqlblIdZ longueurNumTueriePlusUtilise numeroTuerieZ
anomalieLigner
rz r mergeData s
4 (
0
"zLoudeac.mergeDatac C s@ zt | jd }g }W nD ty\ } z,td|dt| td W Y d }~n
d }~0 0 t|d D ]R\}}|dkrjd|d | d|d | d|d
| d|d | d |d
| |d | d}t|d
| dkrd}n t|d
| dkrd}nd}zl| } t | |d |d f|d |d
|d |d f|t j
d}
t | |
|d|
d }| | W qj ty } z,td|dt| td W Y d }~qjd }~0 0 qjz4t
|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.jpgzUnexpectedC err=r2 ERRORClevel r* lefttopwidthheightr conftext)xyr r rotation
confidencer U )* 2 )r )r r r r r g ?zUnexpectedD err=ERRORDRGBz-BL.pdferreurzUnexpectedE err=T)r: r; r rE r( rF enumerateintr< rectangleFILLED addWeightedrD cvtColor
COLOR_BGR2RGBr fromarrayr9 r ) r" rn imageASurlignerblockASurlignerri i level_idxbboxcoloroverlayalphare r
r
r r_ ; sL
< .zLoudeac.surlignerZonesr- c C s t |t j}t |\}}}d| }d|||k< |||k |7 < t |||f}t |t j}t |dt|j |j
dd}|S )Nr g333333?r r ) r: r
COLOR_BGR2HSVsplitmerge
COLOR_HSV2BGRr rB zerosshapedtype) r" re valueZhsvhsvZlimZ final_hsvr
r
r r= m s zLoudeac.increase_brightnessc
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}zException type: z File name: z
Line number: zn: z
Unexpected e=z
, type(e)=r3 )r r yearranger! formatrE sysexc_infotb_framef_code co_filename tb_linenor( r rF ) r" najmrj eexception_typeexception_objectexception_tracebackfilename line_numberr
r
r quantiemeVersDate| s$
$ <
zLoudeac.quantiemeVersDateN)r- )!__name__
__module__ __qualname__r r r r r8 r r r[ linesLotsr~ rK rJ rL rM rR rT r r rO rZ r rP rU r% r ro r r_ r= r r
r
r
r r
s> Y2
r
)PILr uuidr json ImportErrorr@ r r: rG pdf2imager TSLibOCRtimeosnumpyrB TS_OCRr r collectionsr r' r r
r
r
r
r s*