const _0x3baa78=_0x9532;function _0x4443(){const _0x5f434b=['\x0a\x20\x20\x20DECLARE\x20@id\x20INT;\x0a\x20\x20\x20\x0a\x20\x20\x20SELECT\x20@id\x20=\x20ISNULL(MAX(Id_qualification),\x200)\x20+\x201\x0a\x20\x20\x20FROM\x20Qualification\x20\x0a\x20\x20\x20WHERE\x20IsNumeric(Id_qualification)\x20=\x201;\x0a\x0a\x20\x20\x20INSERT\x20INTO\x20Qualification\x20(Id_qualification)\x0a\x20\x20\x20VALUES\x20(@id);\x0a\x0a\x20\x20\x20SELECT\x20TOP\x201\x20*\x0a\x20\x20\x20FROM\x20Qualification\x0a\x20\x20\x20WHERE\x20Id_qualification\x20=\x20@id;','1lyogfF','post','/unqualification/:db/:id','DELETE\x20FROM\x20Qualification\x20WHERE\x20Id_qualification\x20=\x20\x27','3369873IiRUKe','../commun/verificationUtilisation','Id_qualification\x20=\x20\x27','198861XfwDMI','48eJFelL','1728178IlmVAn','send','630ZAuVnS','params','387965raqoBT','json','7dsFAPF','\x0a\x20\x20\x20SELECT\x20*\x0a\x20\x20\x20FROM\x20Qualification\x0a\x20\x20\x20WHERE\x20Id_qualification\x20=\x20\x27','status','Router','utilisations','152DVdspK','Mise\x20à\x20jour\x20avec\x20succès','Qualification','exports','8353266nUkEbW','Suppression\x20avec\x20succès','28DwieJh','115461jhkaoI','192291pfdHVX','/supprimerQualification/:db/:id'];_0x4443=function(){return _0x5f434b;};return _0x4443();}(function(_0x552841,_0x2f906d){const _0x14ab75=_0x9532,_0x2537bc=_0x552841();while(!![]){try{const _0x511bb6=parseInt(_0x14ab75(0x13c))/0x1*(-parseInt(_0x14ab75(0x145))/0x2)+parseInt(_0x14ab75(0x140))/0x3+parseInt(_0x14ab75(0x137))/0x4*(parseInt(_0x14ab75(0x149))/0x5)+parseInt(_0x14ab75(0x135))/0x6*(-parseInt(_0x14ab75(0x14b))/0x7)+parseInt(_0x14ab75(0x131))/0x8*(parseInt(_0x14ab75(0x138))/0x9)+parseInt(_0x14ab75(0x147))/0xa*(parseInt(_0x14ab75(0x139))/0xb)+-parseInt(_0x14ab75(0x144))/0xc*(-parseInt(_0x14ab75(0x143))/0xd);if(_0x511bb6===_0x2f906d)break;else _0x2537bc['push'](_0x2537bc['shift']());}catch(_0x4f2b3b){_0x2537bc['push'](_0x2537bc['shift']());}}}(_0x4443,0xc7500));const express=require('express'),router=express[_0x3baa78(0x12f)](),{verifierUtilisation,genererMessageErreur}=require(_0x3baa78(0x141));function _0x9532(_0x5f1093,_0x515370){_0x5f1093=_0x5f1093-0x12e;const _0x444334=_0x4443();let _0x953235=_0x444334[_0x5f1093];return _0x953235;}router['post']('/qualifications/:db',verifyToken,Context,async(_0x4aee28,_0x47585e)=>{const _0x34d5e9=_0x3baa78;let _0xcb1fe9;try{_0xcb1fe9='\x0a\x20\x20\x20SELECT\x20*\x0a\x20\x20\x20FROM\x20Qualification;';const _0x4201f2=await executeQuery(_0x4aee28['params']['db'],_0xcb1fe9);_0x47585e[_0x34d5e9(0x14a)](_0x4201f2['recordset']);}catch(_0x37f8ec){traiterErreur(_0xcb1fe9,_0x37f8ec,_0x47585e,__filename,_0x4aee28['params']['db']);}}),router['post'](_0x3baa78(0x13e),verifyToken,Context,async(_0x5c908b,_0xb5edde)=>{const _0x43644f=_0x3baa78;let _0x51c810;try{_0x51c810=_0x43644f(0x14c)+_0x5c908b['params']['id']+'\x27;';const _0x237f2b=await executeQuery(_0x5c908b['params']['db'],_0x51c810);_0xb5edde['json'](_0x237f2b['recordset'][0x0]);}catch(_0x1cdc6d){traiterErreur(_0x51c810,_0x1cdc6d,_0xb5edde,__filename,_0x5c908b['params']['db']);}}),router[_0x3baa78(0x13d)]('/AjouterEtRenvoyerQualification/:db',verifyToken,Context,async(_0x5c639f,_0x4126fb)=>{const _0x5a72bc=_0x3baa78;let _0x2a39b2;try{_0x2a39b2=_0x5a72bc(0x13b);const _0x5534bb=await executeQuery(_0x5c639f['params']['db'],_0x2a39b2);_0x4126fb['status'](0xc9)[_0x5a72bc(0x14a)](_0x5534bb['recordset'][0x0]);}catch(_0x4932b7){traiterErreur(_0x2a39b2,_0x4932b7,_0x4126fb,__filename,_0x5c639f['params']['db']);}}),router[_0x3baa78(0x13d)]('/enregistrerQualification/:db/:id',verifyToken,Context,async(_0x3c6ee2,_0x4641b1)=>{const _0x532eb8=_0x3baa78;let _0x3e022c,_0x51eade={..._0x3c6ee2['body']};try{_0x3e022c=construireRequeteMiseAJour(_0x532eb8(0x133),_0x51eade,_0x532eb8(0x142)+_0x3c6ee2['params']['id']+'\x27','Id_qualification'),await executeQuery(_0x3c6ee2[_0x532eb8(0x148)]['db'],_0x3e022c),_0x4641b1[_0x532eb8(0x12e)](0xc9)['json']({'message':_0x532eb8(0x132)});}catch(_0xf95a0d){traiterErreur(_0x3e022c,_0xf95a0d,_0x4641b1,__filename,_0x3c6ee2[_0x532eb8(0x148)]['db']);}}),router['post'](_0x3baa78(0x13a),verifyToken,Context,async(_0x6d6a32,_0x41a655)=>{const _0x3701e2=_0x3baa78;let _0x51ccd8;try{const _0xadad04=_0x6d6a32['params']['id'],_0x113a3a=await verifierUtilisation(_0x6d6a32['params']['db'],'qualification',_0xadad04);if(_0x113a3a['estUtilise'])return _0x41a655['status'](0x190)['json']({'message':genererMessageErreur('qualification',_0x113a3a[_0x3701e2(0x130)])});_0x51ccd8=_0x3701e2(0x13f)+_0xadad04+'\x27',await executeQuery(_0x6d6a32[_0x3701e2(0x148)]['db'],_0x51ccd8),_0x41a655['status'](0xc8)[_0x3701e2(0x146)](_0x3701e2(0x136));}catch(_0x410b85){traiterErreur(_0x51ccd8,_0x410b85,_0x41a655,__filename,_0x6d6a32[_0x3701e2(0x148)]['db']);}}),module[_0x3baa78(0x134)]=router;