a
gK @ 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 Zd
d ZG d d
d
ZG dd deZdS ) )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/Holvia.pygetTime s r c @ s0 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 r
c @ s e Zd ZdZdZdZdZdZg Zg Z i Z
dZ dZ dZ
dZdZdZd ZdZg ZdZdZdZdZdZd
Zg Zd d Zd
d Z dd Z dd Z dd Z dd Z dS )Holviatoosmartr i5Hf7MSHKkPN1hy r g z#COCHE[ ]?FILIE[ ]?RE[ ]?LBC[ ]?[Vv]i z,/home/serge/www/toosmart_digicoche/data/tmp/Fc C sl zP|| _ || _tj| j| j| j| j d| _| j | _|| _|| _ || _
|| _ W n | d Y n0 d S )N)hostuserpasswddbu* Erreur de connexion à la base de données)
sqlDbsqlHostMySQLdbconnectsqlUser sqlPasswdconncursorpdfoutputFileName ocrFolderdebug
printDebug)selfr* r+ ocrDirectorydbNamer# r- r
r
r __init__D s
zHolvia.__init__c C s" | j d | | _ | jr t| d S )Nz
) _debugOCRr- print)r/ pTxtr
r
r r. T s zHolvia.printDebugc C sp zz g }t | j| j}d}g }W nH tyj } z0| d|dt| | d W Y d }~n
d }~0 0 |D ]}zZdt| d }|| jd t| d d t
| jd t| d }| } t |t j
}
t |
dd t jt j d
} t t jd } t j| t j| d
d }
t |
t jt j}t|d
kr@|d n|d
}|D ]}t | |gddd
qLtjt | ddd}t | jd t| d | | | | t !| jd t| d |d
}W qp tyX } zlt"# \}}}|j$j%j&}|j'}t(d| t(d| t(d| | d|dt| | d W Y d }~qpd }~0 0 qpt)*| j+|d }|d ur|, | _-nDt)*d|d }|d urd| _-n"t(d d | _.| |d W d S t)/d |d }t|dkrt|d | _0| |d z8t)/d |d t)j1}t|dkr8|D ] }|| _2q*W nP ty } z6d | _2| d!|dt| | d" W Y d }~n
d }~0 0 | j2d kr| 3 rt(d# d | _.W d S d}|D ]Z}| | t)/d$|}t|dkr8| j45| t|| j6 | _6|D ].}t7| j8t7t9|d :d%d&d' d'| _8qzNt)/d(|d t)j1}t|dkr|D ]"}|d
:d&d | _;|d | _<q`W nJ ty } z0| d!|dt| | d" W Y d }~n
d }~0 0 z&tj=|| tj>j?d)} | @| | W n | d Y n0 |d
}qz>t !| j| jA d* Bd+} | j| j| jA d, d | jCd- W n ty } zlt"# \}}}|j$j%j&}|j'}t(d| t(d| t(d| | d|dt| | d W Y d }~n
d }~0 0 W n tyj } zlt"# \}}}|j$j%j&}|j'}t(d| t(d| t(d| | d|dt| | d W Y d }~n
d }~0 0 d S ).Nr zUnexpected err= , type(err)=ERRORPage_.jpgJPEG )( r= )
iterations )r< r< r< 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 ([0-9]{1,2}\/[0-9]{2}\/[0-9]{4})z2Bon de livraison[\n]+[0-9]{3}[a-zA-Z ]+ ([0-9]{8})r zUnexpected1 err=ERROR1z{"blEnDoublon":1}z'([0-9]{1,3}[.,][0-9]{1,2}).*([0-9]{10}),. z3TOTAL MARCHANDISES\D+(([0-9])+)\D+(([0-9.,])+)\D+KG) output_typez -color-0.jpgRGBz-BL.pdf)save_all
append_images)Dr r* ocrDpi Exceptionr. typestrsaver, cv2imreadcopycvtColorCOLOR_BGR2GRAY thresholdTHRESH_BINARY_INV THRESH_OTSUgetStructuringElement
MORPH_RECT morphologyEx
MORPH_OPEN findContours
RETR_EXTERNALCHAIN_APPROX_SIMPLElen drawContours pytesseractimage_to_stringnparrayimwriteappendr opensysexc_infotb_framef_code co_filename tb_linenor4 researchcleCochegroup
typeLivraison
nonIntegrablefindall
dateLivraison MULTILINE_numBlblExist
linesPoidsextendqttCocheCalculeroundpoidsTotalCalculefloatreplacepoidsTotalDetecteqttCocheDetecte
image_to_datar DICTsurlignerZonesr+ convert mergedImage) r/ imageAmelioreeSurligneepagesPdfiPageocrReturnArrayerrpage
image_nameimgresultgraythreshhorizontal_kernelremove_horizontalcntscdfeexception_typeexception_objectexception_tracebackfilename line_numbermelementjSfilepoidtesseract_outputimr
r
r readZ s
"
"
, "
$
z Holvia.readc C s z$t | jd t| d }g }W nD tyh } z,td|dt| td W Y d }~n
d }~0 0 t|d D ]R\}}|dkrvd|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 qv ty } z,td|dt| td W Y d }~qvd }~0 0 qvzt |t j}t|d} | j\}
}|
d |d f}| |d}|d
kr(| j
| || j| j d t| d W nF ty } z,td td |dt| W Y d }~n
d }~0 0 d!S )"Nr8 rE zUnexpectedC err=r6 ERRORClevel r= lefttopwidthheightr conftext)xyr r rotation
confidencer U )* 2 )r r< )r r r< r r g ?zUnexpectedD err=ERRORDrP z-color-r9 erreurzUnexpectedE err=T)rX rY r, rV rT r4 rU enumerateintrZ rectangleFILLED addWeightedrn r[
COLOR_BGR2RGBr fromarraysizeresizer r rW r+ )r/ r r imageASurlignerblockASurlignerr i level_idxbboxcoloroverlayalphar r r new_size
resized_imager
r
r r sZ
$
&.zHolvia.surlignerZonesc
C s z | j rW dS | jD ]T}|d t| t|d dd d|d dd |d d| j|d dd < qzt| jd d
| _W n d| _Y n0 zt
d }d t| 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 | jdd d }z| j| W nF ty } z,td|dt| td W Y d }~n
d }~0 0 | jj}tdt| d | jD ]}d| _z| j| d | _W n d| _d| _Y n0 t| j| d dd }d t| d t| j| d d t| d t| j| d d t| j d t| j d | j d }| j| q| j W n ty } zlt \} }
} | j j!j"} | j#}
td | td | td |
| $d!|d"t| | $d# W Y d }~n
d }~0 0 W n ty } zlt \} }
} | j j!j"} | j#}
td | td | td |
| $d!|d"t| | $d# W Y d }~n
d }~0 0 d S )$NFr r= r@ r r )poidsdateZeleveurZtuerielotz%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=r6 zERROR A2z{"blId":}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 rF rG rH rI rJ r7 )%r{ r rV quantiemeVersDater
lineMergedr strptimer} strftimenow
idAbattoirrz r r r r r r3 r r) executerT r4 rU lastrowid
enAnomaliedateLivraisonLigner( closerp rq rr rs rt ru r. )r/ linePoids currentDatesqlr blIdkey numeroTuerier r r r r r r
r
r mergeDataO s
R
$
zHolvia.mergeDatac
C s zt j}|d dkr$|d dks0|d dkr6d}nd}tddD ]F}|| |krDt|td | td |||d W S qDW nD ty } z,td
|d t| td W Y d }~n
d }~0 0 d S )
Nr r d i )
r < [ y i i1 iO in )
r r ; Z x r i i0 iN im r=
z{:02d}r r6 z ERROR A4 ) r r yearrangerV formatrT r4 rU )r/ najmr r r
r
r r s
$ <zHolvia.quantiemeVersDateN)!r r r r& r# r' r" r r linesLotsr r} rz r
poidsTotalrx rS r, r+ motsASurligner
dateTuerier r r r r{ r r2 r. r r r r r
r
r
r r ) s> >8`r )PILr uuidr json ImportErrorri r rX rp rv pdf2imager TSLibOCRtimeosnumpyrk TS_OCRr$ r collectionsr r- r r
r r
r
r
r s.