&ie^ @ ddlmZmZmZmZmZmZmZddlm Z ddl m Z m Z ddl mZeeZde_dej$d<dej$d <e eZGd d ej(ZGd d ej(ZGddej(ZGddej(ZGddej(ZGddej(ZGddej(ZGddej(ZGddej(ZGddej(ZGddej(Zd Z ejCd!d"d#g$e d%Z"ejCd&d#g$d'Z#ejCd(d#g$d)Z$ejCd*d#g$d+Z%ejCd,d#g$d-Z&ejCd.d#g$d/Z'ejCd0d"d#g$d1Z(ejCd2d3Z)ejCd4d"d#g$e d5Z*ejCd6e d7Z+ejCd8d"d#g$ejCd9d"d#g$e dld;Z,ejCdd"d#g$e d?Z.ejCd@d#g$e dAZ/ejCdBd#g$e dCZ0ejCdDd"d#g$e dEZ1ejCdFd#g$e dGZ2ejCdHe dIZ3ejCdJd#g$e dKZ4ejCdLd#g$e dMZ5ejCdNd#g$e dOZ6ejCdPd#g$e dQZ7ejCdRd#g$e dSZ8ejCdTd#g$e dUZ9ejCdVd#g$e dWZ:ejCdXd#g$e dYZ;ejCdZd#g$e d[Zej~d`Z@ejCdae dbZAej5ejejjdk(rIddcl m Z ej jedde defej jd:d:d:edgk(rejdhdidjky:y:#1swY$xYw)m)Flaskrender_templaterequestredirecturl_forsessionflash) SQLAlchemy)generate_password_hashcheck_password_hashwrapssuper_secret_keyzsqlite:///portal.dbSQLALCHEMY_DATABASE_URIFSQLALCHEMY_TRACK_MODIFICATIONSceZdZej ej dZej ejdddZej ejddZ y) AdminT primary_key2FuniquenullablerN) __name__ __module__ __qualname__dbColumnIntegeridStringusername password_hash!/var/www/html/admin_portal/app.pyrr sN 2::4 0Byy2teyDHIIbiinuI=Mr'rceZdZej ej dZej ejdddZejdddZ y ) GroupTrdFrEmployeegroup)backreflazyN) rrrrr r!r"r#name relationship employeesr&r'r(r*r*sH 2::4 0B 99RYYs^D59 AD G$GIr'r*ceZdZej ej dZej ejddZej ejdZ ej ejdZ ej ej ejdZ ejdd dd Zejd d dd Zy )r,TrFrxzgroup.idRustdeskAccountemployeeall, delete-orphanr.r/cascade CredentialN)rrrrr r!r"r# full_name corp_email edu_email ForeignKeygroup_idr1rustdesk_accounts credentialsr&r'r(r,r,s 2::4 0B "))C.5 9I299S>*J "))C.)IyyR]]:%>?H(9:TXbvw//, Wk/lKr'r,cheZdZej ej dZej ej ejddZej ejddZ ej ejddZ ej ejdZ y) r6Tr employee.idFrr+rN) rrrrr r!r"r? employee_idr# computer_name rustdesk_idpasswordr&r'r(r6r6"s 2::4 0B))BJJ m(Du)UKIIbiinuI=M))BIIbME):Kyy3(Hr'r6ceZdZej ej dZej ej ejddZej ejddZ ej ejdZ ej ejdZ ej ejdZ ej ejdZy) r;TrrDFrr+rN)rrrrr r!r"r?rEr# site_nameurlloginrHnoter&r'r(r;r;)s 2::4 0B))BJJ m(Du)UK "))C.5 9I ))BIIcN #C IIbiin %Eyy3(H 99RYYs^ $Dr'r;cReZdZej ej dZej ejddZej ejddZ ej ejdZ ej ejdd Z y ) QuickLinkTrr+Frr rz is-primary)defaultN) rrrrr r!r"r#titlerKemoji color_classr&r'r(rOrO2s| 2::4 0B IIbiinuI 5E ))BIIcNU) 3C IIbiim $E))BIIbM<)@Kr'rOceZdZej ej dZej ejdZej ejddZ ej ejdZ ejdd dd Z ejd d dd Z ejd d dd Zy)BuildingTrrr4FrrNetworkSettingbuildingr8r9 WifiNetworkVideoSurveillanceN)rrrrr r!r"r#mesh_idr0addressr1networkswifisdvrsr&r'r(rVrV:s 2::4 0Bii " &G 99RYYs^e9 4Dii #'G/$XlmH OOM:DRfO gE ??. Wk? lDr'rVceZdZej ej dZej ej ejddZej ejdZ ej ej Z ej ejdZ ej ejdZ ej ejdZej ejdZej ejdZej ej"Zej ejdZy) rWTr building.idFrr+rN)rrrrr r!r"r? building_idr# vlan_name vlan_numbernetworkmaskgatewaydns1dns2Text static_rangesip_countr&r'r(rWrWEs 2::4 0B))BJJ m(Du)UK "))C.)I))BJJ'Kii " &G 99RYYr] #Dii " &G 99RYYr] #D 99RYYr] #DIIbgg&Myy3(Hr'rWc eZdZej ej dZej ej ejddZej ejdZ ej ejdZ y)rYTrraFrr+N) rrrrr r!r"r?rbr#ssidrHr&r'r(rYrYRse 2::4 0B))BJJ m(Du)UK 99RYYs^ $Dyy3(Hr'rYceZdZej ej dZej ej ejddZej ejdZ ej ejdZ ej ejdZ ejdd dd Zy ) rZTrraFrr+r4 DvrAccountdvrr8r9N)rrrrr r!r"r?rbr#dvr_namelocation serial_numberr1accountsr&r'r(rZrZXs 2::4 0B))BJJ m(Du)UKyy3(Hyy3(HIIbiin-M|UOcdHr'rZc eZdZej ej dZej ej ejddZej ejdZ ej ejdZ y) rpTrzvideo_surveillance.idFrr+rN) rrrrr r!r"r?dvr_idr#rLrHr&r'r(rprp`sg 2::4 0B YYrzz2==1H#ITYY ZF IIbiin %Eyy3(Hr'rpc.tfd}|S)NcLdtvrttdS|i|S)Nadmin_idrL)rrr)argskwargsfs r(decorated_functionz*login_required..decorated_functionhs+ W $GG,- -$!&!!r'r )r}r~s` r(login_requiredrgs! 1X"" r'z/settings/group//editGETPOST)methodsc,tjj|}tjdk(rVtj d|_tjjtddttdStd|S)Nrr0u7Группа успешно переименована.successsettingszedit_group.html)r-)r*query get_or_404rmethodformr0rrcommitr rrr)r"r-s r( group_editrpsm KK " "2 &E~~\\&)   GS +,, ,E ::r'z#/settings/admin//editcpdtvr tdStjj |}t j jd}t j jd}|r||_|rddl m }|||_ tjjtdS)Nrz/loginadmin_usernameadmin_passwordrr /settings)rrrrrrrgetr$werkzeug.securityr r%rr)rzadmin new_username new_passwordr s r( edit_adminr{s !! KK " "8 ,E<<##$45L<<##$45L%<4\BJJ K  r'z%/settings/admin//deletecdtvr tdS|tjdk(rytjj |}t jj|t jjy)Nrzr)u1Нельзя удалить самого себяi)) rrrrrrrdeleter)rzrs r( delete_adminrsd !!7;;z**G KK " "8 ,EJJeJJ r'z/settings/admin/addcdtvr tdStjj d}tjj d}|r|rt j j|j}|sVddl m }t |||}tjj|tjjtd S) Nrzrrrr$rrr$r%r)rrrrrrr filter_byfirstrr raddr)r$rHexisting_adminr new_admins r( add_adminrs !!|| 01H|| 01HH...AGGI @!4X>I JJNN9 % JJ    K  r'z/settings/link/addcVdtvrttdStjj d}tjj d}tjj d}|r|j dk(rd}tjj d}|r|j dk(rd }|rN|rLt|||| }tjj|tjjttd S) NrzrL link_titlelink_url link_colorrz#3498db link_emojiu🔗)rRrKrTrSr) rrrrrrstriprOrrr)rRrKcolorrSnew_links r(add_linkrs ()) LL  \ *E ,,  : &C LL  \ *E EKKMR' LL  \ *E EKKMR'    x   GJ' ((r'z!/settings/link//editcdtvrttdStjj |}t jjd|_ t jjd|_ t jjd|_ t jjd|_ tjjttdS)NrzrLrrrrr)rrrrOrrrrrrRrKrTrSrr)link_idlinks r( edit_linkrs ()) ?? % %g .D!!,/DJ|| +DH||'' 5D!!,/DJJJ GJ' ((r'rctjdk(rtjj tj dj }|rZt|jtj dr3|jtd<tddttdStd d td S) Nrr$rrHrzu+Успешный вход в системуrr2uSОшибка авторизации. Проверьте логин и пароль.dangerz login.html)rrrrrrrr r%r"rr rrr)users r(rLrLs~~{{$$gll:.F$GMMO '(:(:GLLctjj|}tjj }t d||S)Nzemployee_detail.htmlempr)r,rrr*rr)r"rrs r(employee_detailr s8 .. # #B 'C [[__ F 1s6 JJr'z /employee/addz/employee//editNc |rtjj|nd}tjj }t j dk(rt jjdd}t jjdd}t jjdd}t jjd}|s)t}tjj|||_ ||_ ||_ |r t|nd|_tjj!t jjd}|r|j#dd}|j%rut'|j(d |t jjd d } tjj| tjj!n t+d d t+ddt-t/d|j(St1d||S)Nrr<rr=r>r@rG uОсновной ПКrustdesk_passwordrErFrGrHu}Профиль сохранен, но RustDesk ID пропущен (должен содержать только цифры).warningu5Данные сотрудника сохранены.rrr"zemployee_form.htmlr)r,rrr*rrrrrrrr<r=r>intr@rreplaceisdigitr6r"r rrr) r"rrr<r=r>gid raw_rd_idrd_idrds r( employee_formrs%'(..  R DC [[__ F~~LL$$["5 \\%%lB7 LL$$["5 llz**C JJNN3 ! #! #&s3xD  LL$$]3 %%c2.E}}$ #"9 %$\\--.A2F   r" !!#VXab EyQ 1cff=>> /S HHr'z/employee//deletectjjtjj |tjj tddttdS)Nu Сотрудник удален.rr2) rrrr,rrrr rrrs r(employee_deleter?sPJJhnn//34JJ ,i8 GK( ))r'rctjdk(rdtjvrHtjj t tjdtddndtjvrdttjd}tjj ttjd | td dnd tjvr~ttjd tjdtjdtjd}tjj |tddtjjttdStdt jj!tjj!tjj!S)Nrrrru Группа добавлена.rrrrru,Администратор добавлен.rrrrr)rRrKrSrTu/Быстрая ссылка добавлена.rz settings.html)radminslinks)rrrrrrr*r r rrOrrrrrr)pwrs r(rrHsP~~ ',, & JJNN5gll<&@A B 4i @ GLL (' 5E(FGB JJNN5',,7G*HXZ[ \ @) L 7<< ' ll<0LL,ll<0#LL6 H JJNN8 $ CY O  +,, ?"'++//"3"'++//"3!*!4!4!6 88r'z/settings/link//deletectjjtjj |tjj ttdSNr) rrrrOrrrrrrs r( link_deleterdsEJJioo0045JJ GJ' ((r'z/settings/group//deletectjjtjj |tjj ttdSr) rrrr*rrrrrrs r( group_deleterksEJJekk,,R01JJ GJ' ((r'z /buildingsctjdk(rttjj dtjdtjj d}t j j|t j jtddttdStjj}td | S) Nrr[r0r\)r[r0r\u/Здание успешно добавлено.r buildingszbuildings.html)r)rrrVrrrrrrr rrrrr) new_building all_buildingss r(rrss~~LL$$Y/f%LL$$Y/ |$  ?K ,--NN&&(M +} EEr'z/building//deletectjj|}tjj |tjj tddttdS)NuJЗдание и вся его инфраструктура удалены.rr) rVrrrrrrr rrr"rXs r(delete_buildingrsV~~((,HJJhJJ VXab GK( ))r'z/building/cZtjj|}td|S)Nzbuilding_detail.html)b)rVrrrrs r(building_detailrs&~~((,H 1X >>r'z/building//network/addctjj|t|tj j dtj j dtj j dtj j dtj j dtj j dtj j dtj j dtj j d  }tjj|tjjttd | S) Nrcrdrerfrgrhrirkrl) rbrcrdrerfrgrhrirkrlrr) rVrrrWrrrrrrrrr)r"nets r( add_networkrs NNb! ,,"";/LL$$]3   + \\  f %   + \\  f % \\  f %ll&&7!!*- CJJNN3JJ G-"5 66r'z/building//wifi/addc8t|tjjdtjjd}tj j |tj jttd|S)NrnrH)rbrnrHrr) rYrrrrrrrrr)r"wifis r(add_wifirsd 2GLL,<,/dvr/addctt|tjjdtjjdtjjd}tj j |tj jttd|S)Nrrrsrt)rbrrrsrtrr) rZrrrrrrrrr)r"rqs r(add_dvrrs| !!*-!!*-ll&&7  C JJNN3JJ G-"5 66r'z/dvr//account/addctjj|}t|tj j dtj j d}tjj|tjjttd|jS)NrLrH)rwrLrHrr)rZrrrprrrrrrrrrrb)rwrqaccs r(add_dvr_accountrs~  ! ! , ,V 4C F',,*:*:7*CgllN^N^_iNj kCJJNN3JJ G-#//B CCr'z!/delete_item//cNd}d}|dk(r,tjj|}|j}n|dk(r,tjj|}|j}nk|dk(r,t jj|}|j}n:|dk(r5t jj|}|jj}|r=tjj|tjjttd|S)Nrerrq dvr_accountrr)rWrrrbrYrZrprqrrrrrr) item_typer"itemb_ids r( delete_itemrs D DI##..r2 f   ++B/ e  &&11"5 m #**2.xx##  $  G-$7 88r'z/employee//rustdesk/addc"tjj|tjj dd}dj ttj|}t|tjj d|tjj d}tjj|tjjtddt!t#d| S) NrGrrFrHru8Учетная запись RustDesk добавлена!rrr)r,rrrrrjoinfilterstrrr6rrrrr rr)r"raw_idclean_idrs r( add_rustdeskrs NNb!\\  mR 0Fwwvckk623H ll&&7!!*-  B JJNN2JJ DiP G-"5 66r'z/rustdesk//deletectjj|}|j}tj j |tj jttd|SNrr) r6rrrErrrrrr)r"remp_ids r(delete_rustdeskrsX    ) )" -B ^^FJJbJJ G-&9 ::r'z/rustdesk//editctjj|}tjj dd}dj ttj|}tjj d|_ ||_ tjj d|_ tjjt!ddt#t%d|j&S) NrGrrFrHuGУчетная запись RustDesk успешно обновлена!rrr)r6rrrrrrrrrrFrGrHrrrr rrrE)r"rrrs r( edit_rustdeskrs    ) )" -B\\  mR 0Fwwvckk623H||''8BBN,,"":.BKJJ SU^_ G-"..A BBr'z/credential//editc<tjj|}tjj d|_tjj d|_tjj d|_tjj d|_ tjj d|_ tjjtddtt!d|j" S) NrJrKrLrHrMu;Доступ к сайту успешно обновлен!rrr)r;rrrrrrJrKrLrHrMrrrr rrrEr"creds r(edit_credentialr s    & &r *D\\%%k2DN||&DH!!'*DJLL$$Z0DM   (DIJJ GS G-$2B2BC DDr'z!/employee//credential/addc Btjj|t|tj j dtj j dtj j dtj j dtj j d}tjj|tjjtddttd | S) NrJrKrLrHrM)rErJrKrLrHrMu/Данные сервиса добавлены!rrr)r,rrr;rrrrrrrr rrr s r(add_credentialr &s NNb! ,,"";/ LL  U #llw'!!*- \\  f %  DJJNN4JJ ;YG G-"5 66r'z/credential//deletectjj|}|j}tj j |tj jttd|Sr) r;rrrErrrrrr)r"r rs r(delete_credentialr7sZ    & &r *D   FJJdJJ G-&9 ::r'cfdtvr(dtjjtdiSiS)Nrz current_admin)rrrrr&r'r( inject_adminrAs,W1D!EFF Ir'/cXtjj}td|S)Nz index.htmlr)rOrrrrs r(indexrGs# OO   !E r)sTTT'I Ho#(= $%/4 +,_>BHH> HBHHH mrxx m)bhh)%%AA mrxx m )RXX ))"(() ee)) *UFOD;E; 06(C!D!$ 2VHE F  6(3!4!, &2)3): .A )B )8eV_-).)9&& <%1O2O,  K!K ?UFO4 $ufo>(I?5(IT &9*:*;08184 +fX>)?)  ,vh?)@) <%1 F2 F &9*:*  ?!? +fX>7?7$ (6(;7<7  '&: 7; 7 *VH=D>D .A9B9, ,vh?7@7$ &9;:; $vh7C8C* &9E:E& .A 7B 7 (6(;;<; 366  __MMO {{a< ug=ST^=_`a  zGGTG2s :A7VV