a Öò‘i}Tã@szddlmZmZmZmZmZmZmZmZddl Z ddl m Z m Z ddl Z ddlmZddlmZmZddlmZddlZddlZddlmZmZddlZddlmZdd lmZddlZee ƒZ!d e!_"d e!j#d <d e!j#d<de!j#d<de!j#d<de!j#d<de!j#d<ee!ƒZ$dddddœZ%dd„Z&dd„Z'dd „Z(e! )d!¡d"d#„ƒZ*e!j)d$d%gd&d'd(„ƒZ+e!j)d)d%gd&d*d+„ƒZ,e! )d,¡e(d-d.„ƒƒZ-e! )d/¡d0d1„ƒZ.e! )d2¡e(d3d4„ƒƒZ/e!j)d5d6gd&e(d7d8„ƒƒZ0e!j)d5d%gd&e(d9d:„ƒƒZ1e!j)d;d%gd&e(dd?„Z3d@dA„Z4e! )dB¡e(dCdD„ƒƒZ5e! )dE¡e(dFdG„ƒƒZ6e!j)dHd%gd&e(dIdJ„ƒƒZ7e dKkrve!j8dLdMdNdOdS)Pé)ÚFlaskÚrender_templateÚrequestÚjsonifyÚsessionÚredirectÚurl_forÚ send_fileN)ÚdatetimeÚ timedelta)ÚDocument)ÚPtÚRGBColor)ÚWD_ALIGN_PARAGRAPH)ÚMailÚMessage)ÚMIMEText)Ú MIMEMultipartz R0mt3l3c0m!z box.lbsol.roÚ MAIL_SERVERiKÚ MAIL_PORTTZ MAIL_USE_TLSzconcedii@lbsol.roÚ MAIL_USERNAMEz Qpq9kbmbr6!Ú MAIL_PASSWORDÚMAIL_DEFAULT_SENDERZ localhostÚrootZ romtelecomZevidenta_deconturi)ÚhostÚuserÚpasswordZdatabasecCstjjfit¤ŽS)N)ÚmysqlZ connectorZconnectÚ DB_CONFIG©rrú&/var/www/html/concedii/app_mysql_v2.pyÚget_db_connection)sr!cs*‡fdd„}tj|d}d|_| ¡dS)z:Trimite email la HR cand ambele parti au semnat - asincroncs¶zztƒ}|jdd}| dˆf¡| ¡}| ¡| ¡|sFWdStƒ}tjd|d<d|d<d|d ›|d <d |d ›d |d ›d|d d¡›d|d d¡›d|d›d|d›d|drÔ|d d¡nd›d|drð|d d¡nd›d}|  t |dƒ¡t j tjdtjd d!d"}|  ¡| tjd#tjd$¡| ¡}| |d|d|¡| ¡td%ˆ›ƒWn4ty°}ztd&|›ƒWYd}~n d}~00dS)'NT©Ú dictionaryú+SELECT * FROM cereri_concediu WHERE id = %srZFromz hr@lbsol.roZTozCerere de concediu semnata - ÚnameZSubjectzd Buna ziua, O cerere de concediu a fost semnata de ambele parti si asteapta aprobare: Solicitant: z Inlocuitor: Úinlocuitor_namez Perioada: Ú data_startú%d.%m.%Yz - Ú data_sfarsitz Numar zile: Únr_zilez Data completare: Údata_completarez Data semnare solicitant: Údata_semnare_solicitantz%d.%m.%Y %H:%MzN/Az Data semnare inlocuitor: Údata_semnare_inlocuitorzX Accesati aplicatia pentru a aproba cererea. Aplicatie Cereri de Concediu Zplainrré )Ztimeoutrrz(? Email trimis cu succes pentru cererea z? Eroare trimitere email: )r!ÚcursorÚexecuteÚfetchoneÚcloserÚappÚconfigÚstrftimeZattachrÚsmtplibZSMTPZstarttlsÚloginZ as_stringZsendmailÚquitÚprintÚ Exception)Úconnr/ÚcerereÚmsgÚbodyZserverÚtextÚe©Ú cerere_idrr Ú send_async.sP ûú ù ùø ÷ õ ôz+send_email_notification..send_async)ÚtargetTN)Ú threadingZThreadZdaemonÚstart)rBrCÚthreadrrAr Úsend_email_notification,s 8 rHcs$ddlm}|ˆƒ‡fdd„ƒ}|S)Nr)Úwrapscs&dtvrtddiƒdfSˆ|i|¤ŽS)NÚuser_idÚerrorZNeautentificaté‘)rr)ÚargsÚkwargs©Úfrr Údecorated_functionmsz*login_required..decorated_function)Ú functoolsrI)rPrIrQrrOr Úlogin_requiredks rSz/logincCstdƒS)Nz login.html)rrrrr Ú login_pagevsrTz /api/loginZPOST)Úmethodsc CsLt ¡}| d¡}| d¡}tƒ}|jdd}| d|f¡| ¡}| ¡| ¡|shtddiƒdfSzD|d}t |t ƒr†|  d ¡}t   |  d ¡|¡sªtddiƒdfWSWnBtyî}z*td |›ƒtddiƒdfWYd}~Sd}~00|d td <|dtd<|d td <| dd¡td<td|d |d |dtddœdœƒS)NÚusernamerTr"z+SELECT * FROM employees WHERE username = %srKuUsername sau parolă incorectărLzutf-8uEroare verificare parolă: ÚidrJr%Úroler©rWr%rVrX)Úsuccessr)rÚget_jsonÚgetr!r/r0r1r2rÚ isinstanceÚstrÚencodeÚbcryptZcheckpwr:r9r)ÚdatarVrr;r/rZ password_hashr@rrr r7zs@     &   üþr7z /api/logoutcCst ¡tddiƒS)NrZT)rÚclearrrrrr Úlogout¨srcz/api/current-usercCs"ttdtdtdtddœƒS)NrJr%rVrXrY)rrrrrr Ú current_user­s ürdú/cCsdtvrttdƒƒStdƒS)NrJrTzindex_mysql_v2.html)rrrrrrrr Úindex¹s rfz /api/userscCs<tƒ}|jdd}| d¡| ¡}| ¡| ¡t|ƒS)NTr"z6SELECT id, name, username FROM employees ORDER BY name)r!r/r0Úfetchallr2r)r;r/Zusersrrr Ú get_usersÀs  rhz /api/cereriZGETc CsÐtƒ}|jdd}t dd¡}t dd¡}t d¡}gd¢}|d ksL||vrX| d ¡n| d ||f¡| ¡}| ¡| ¡|D]B}d D]8}| |¡rŒt||d ƒr´|| ¡n t ||ƒ||<qŒq„t |ƒS)NTr"rXrrVÚrJ©Úadminzcalin.lisovschizrares.lisovschirka  SELECT c.*, e1.name as name, e2.name as inlocuitor_name FROM cereri_concediu c LEFT JOIN employees e1 ON c.user_id = e1.id LEFT JOIN employees e2 ON c.inlocuitor_id = e2.id ORDER BY c.created_at DESC aF SELECT c.*, e1.name as name, e2.name as inlocuitor_name FROM cereri_concediu c LEFT JOIN employees e1 ON c.user_id = e1.id LEFT JOIN employees e2 ON c.inlocuitor_id = e2.id WHERE c.user_id = %s OR c.inlocuitor_id = %s ORDER BY c.created_at DESC )r'r)r,r-Z created_atZ data_aprobareÚ isoformat) r!r/rr\r0rgr2Úhasattrrlr^r) r;r/Ú user_rolerVrJÚ allowed_usersÚcererir<Úkeyrrr Ú get_cereriËs&     ù  .rrc CsÚt ¡}| d¡}| d¡}| d¡}| d¡}t||||gƒsPtddiƒdfS||krhtddiƒdfSt |d ¡}t |d ¡}||jd }|d kr¦tdd iƒdfStƒ}|j d d} |   d|f¡|   ¡} |   d|f¡|   ¡} | rî| s|   ¡|  ¡tddiƒdfSt  ¡ d¡} |   d|| d||||| d| f¡| j} | ¡z8t| | d| d|||| ƒ}|   d|| f¡| ¡Wn4tyº}ztd|›ƒWYd}~n d}~00|   ¡|  ¡td | dœƒS)NrJr'r)Ú inlocuitor_idrKu!Toate câmpurile sunt obligatoriiéu3ÃŽnlocuitorul trebuie să fie o persoană diferităú%Y-%m-%déruPerioada invalidăTr"z(SELECT name FROM employees WHERE id = %szUtilizator invalidr(zÙ INSERT INTO cereri_concediu (user_id, name, data_start, data_sfarsit, nr_zile, inlocuitor_id, inlocuitor_name, data_completare, status) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, 'pending') r%ú6UPDATE cereri_concediu SET pdf_path = %s WHERE id = %szEroare generare PDF: )rZrW)rr[r\Úallrr ÚstrptimeÚdaysr!r/r0r1r2Únowr5Z lastrowidÚcommitÚ generate_pdfr:r9)rarJr'r)rsrFÚendr*r;r/Ú solicitantÚ inlocuitorr+rBÚpdf_pathr@rrr Ú create_cerereøsN        ü $r‚z/api/cereri//semneazac Cs|t ¡}| d¡}|dvr*tddiƒdfStƒ}|jdd}| d|f¡| ¡}|sv| ¡| ¡tdd iƒd fSt   ¡}|d kr˜| d ||f¡n| d ||f¡|  ¡| d|f¡| ¡}| ¡| ¡zBt |ƒ}tƒ}| ¡}| d||f¡|  ¡| ¡| ¡Wn4t yL} ztd| ›ƒWYd} ~ n d} ~ 00|rp|drp|drpt|ƒtddiƒS)NÚtip)rr€rKz Tip invalidrtTr"r$õCerere negăsităé”rzŒ UPDATE cereri_concediu SET semnat_solicitant = 1, data_semnare_solicitant = %s WHERE id = %s zŒ UPDATE cereri_concediu SET semnat_inlocuitor = 1, data_semnare_inlocuitor = %s WHERE id = %s zNSELECT semnat_solicitant, semnat_inlocuitor FROM cereri_concediu WHERE id = %srwzEroare regenerare PDF: Úsemnat_solicitantÚsemnat_inlocuitorrZ)rr[r\rr!r/r0r1r2r r{r|Úgenerate_pdf_with_signaturesr:r9rH) rWrarƒr;r/r<r{Úcheckrr@rrr Úsemneaza_cerere9sL  üü $rŠc CsTd}tj |¡std|›ƒ‚t|ƒ}||t |d¡ d¡t |d¡ d¡t|ƒ|dddddœ } |j D]0} |   ¡D]"\} } | | j vrr| j   | | ¡| _ qrqf|j D]H} | jD]<}|jD]0}|   ¡D]"\} } | |j vr¾|j   | | ¡|_ q¾q²q¨qž|  dd ¡›d t ¡ d ¡›d }d |›}| |¡|  d d ¡}d |›}tjdddddd|gdd|S)u)Generează PDF iniÈ›ial fără semnăturiúC/var/www/html/concedii/templates_word/cerere_concediu_template.docxuTemplate nu există: rur(ú ................................ri© z{NUME_SOLICITANT}z{NUME_INLOCUITOR}z {DATA_START}z{DATA_SFARSIT}z {NR_ZILE}z{DATA_COMPLETARE}z{SEMNATURA_SOLICITANT}z{DATA_SEMNARE_SOLICITANT}z{SEMNATURA_INLOCUITOR}z{DATA_SEMNARE_INLOCUITOR}ú ú-ú%Y%m%dú.docxú"/var/www/html/concedii/cereri_pdf/ú.pdfÚ libreofficeú --headlessú --convert-toÚpdfú--outdirú!/var/www/html/concedii/cereri_pdfT©r‰)ÚosÚpathÚexistsÚFileNotFoundErrorr r ryr5r^Ú paragraphsÚitemsr?ÚreplaceÚtablesÚrowsÚcellsr{ÚsaveÚ subprocessÚrun)rBZnume_solicitantZnume_inlocuitorr'r)r*r+Ú template_pathÚdocÚ replacementsÚ paragraphrqÚvalueÚtableÚrowÚcellÚfilenameÚ docx_pathÚ pdf_filenamerrrr r}xsL ö      "    ýür}c Cs°tƒ}|jdd}| d|f¡| ¡}| ¡| ¡|sDtdƒ‚d}t|ƒ}|dr`|dnd}|d rz|d  d ¡nd }|d rŽ|d nd}|dr¨|d d ¡nd } |d|d |d d ¡|d d ¡t|dƒ|d|||| dœ } |j D]} |   ¡D]‚\} } | | j vrd| vrp| dkrp| j D]>}| |j vr.|j   | | ¡|_ d|j_tdƒ|j_d|j_q.n| j   | | ¡| _ qqô|jD]¼}|jD]®}|jD] }|   ¡D]\} } | |j vr¬d| vr*| dkr*|j D]L} | j D]>}| |j vrä|j   | | ¡|_ d|j_tdƒ|j_d|j_qäqÚn|j   | | ¡|_ q¬q q–qŒ|d  dd¡›dt ¡ d¡›d}d|›}| |¡|  dd¡}tjdddd d!d"|gdd#|S)$u0Regenerează PDF cu semnături (nume în cursiv)Tr"r$r„r‹r†r%rŒr,r(rir‡r&r-r'r)r*r+rZ SEMNATURAzBrush Script MTérŽrrr‘r’r“r”r•r–r—r˜r™rš)r!r/r0r1r2Ú ValueErrorr r5r^rŸr r?Úrunsr¡Zfontr%r ÚsizeZboldr¢r£r¤r r{r¥r¦r§)rBr;r/r<r¨r©Zsemn_solZ data_semn_solZsemn_inlZ data_semn_inlrªr«rqr¬r§r­r®r¯r°r±r²rrr rˆ¬s|    ö              &   ýürˆz/api/cereri//pdfcCsŠtƒ}|jdd}| d|f¡| ¡}| ¡| ¡|rD|dsTtddiƒdfSd|d›}tj |¡s~tdd iƒdfSt |dd S) NTr"z2SELECT pdf_path FROM cereri_concediu WHERE id = %srrKu PDF negăsitr…r’uFiÈ™ier PDF negăsit)Z as_attachment) r!r/r0r1r2rr›rœrr )rWr;r/r<rrrr Ú download_pdfÿs   r·z /api/calendarc Cs¢tƒ}|jdd}| d¡| ¡}| ¡| ¡g}|D]\}| |d|d ¡|dtdd ¡|d d krxd nd |d |d|d dœdœ¡q/aprobac Cszt dd¡}t dd¡}gd¢}|dkr@||vr@tddiƒd fStƒ}|jd d }| d |f¡| ¡}|sŒ| ¡| ¡tdd iƒdfS|drœ|ds¼| ¡| ¡tddiƒdfS| dtd|f¡| ¡| ¡| ¡zPt |ƒ}tƒ}| ¡}| d||f¡| ¡| ¡| ¡t d|›ƒWn4t yl}zt d|›ƒWYd}~n d}~00tdd iƒS)NrXrrVrirjrkrKz#Nu aveti dreptul sa aprobati cererii“Tr"r$zCerere negasitar…r†r‡z;Cererea trebuie semnata de ambele parti inainte de aprobarertzœ UPDATE cereri_concediu SET status = 'approved', data_aprobare = NOW(), aprobat_de = %s WHERE id = %s r%rwz? PDF regenerat la aprobare: z%? Eroare regenerare PDF la aprobare: rZ) rr\rr!r/r0r1r2r|rˆr9r:) rWrnrVror;r/r<rr@rrr Ú aproba_cerere2sF    ú$r¼Ú__main__z0.0.0.0iˆF)rZportÚdebug)9Zflaskrrrrrrrr Zmysql.connectorrr r r›Zdocxr Z docx.sharedr rZdocx.enum.textrr¦r`Z flask_mailrrr6Zemail.mime.textrZemail.mime.multipartrrEÚ__name__r3Z secret_keyr4Zmailrr!rHrSZrouterTr7rcrdrfrhrrr‚rŠr}rˆr·r»r¼r§rrrr Ús„(          ü?   -     + ? =4S   8