/
sergius24
/
excel-app
Обзор
Документация
Войти
/
sergius24
/
excel-app
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
CI/CD
Аналитика
Безопасность
master
static/script.js
118 строк
8 KB
Puzzanis
refactoring
01 фев 2026, 20:06
01 фев 2026, 20:06
2be33a2
Код
Авторство
О чём код?
��/ / 1 . ;>10;L=K5 ?5@5<5==K5 8 A?@02>G=8: <>4C;59 v a r t a b l e ; v a r c u r r e n t S h e e t = " s h e e t 1 " ; v a r k e y = " " ; c o n s t m o d u l e L i b r a r y = { " C P U " : [ " C P U - 4 7 A " , " C P U - 3 7 A " , " C P U - 3 7 B " ] , " D I " : [ " D I - 3 2 " , " D I - 3 3 " , " D I - 3 4 " ] , " D I O " : [ " D I O - 3 2 A " , " D I O - 3 4 A " ] , " D O " : [ " D O - 3 1 A " ] , " A I " : [ " A I - 3 1 " , " A I - 3 2 " , " A I - 3 3 " ] , " A I O " : [ " A I O - 3 1 " ] , " R e d u n d M o d u l e " : [ " D P M - 4 1 A " ] , " E t h e r n e t " : [ " C - 4 3 A " , " C - 4 6 A " ] , " R S - 4 8 5 " : [ " C I - 3 4 A " ] , " R e p e a t M o d u l e " : [ " R P - 3 1 " ] } ; / / 2 . =8F80;870F8O ?@8 703@C7:5 AB@0=8FK w i n d o w . o n l o a d = f u n c t i o n ( ) { t a b l e = n e w T a b u l a t o r ( " # e x a m p l e - t a b l e " , { a j a x U R L : " / a p i / d a t a ? s h e e t = " + c u r r e n t S h e e t , l a y o u t : " f i t C o l u m n s " , g r o u p B y : " r a c k " , / / @C??8@>2:0 ?> :>@78=0< g r o u p U p d a t e O n C e l l E d i t : t r u e , g r o u p H e a d e r : f u n c t i o n ( v a l u e , c o u n t , d a t a , g r o u p ) { / / 03>;>2>: 3@C??K A :=>?:>9 1KAB@>3> 4>102;5=8O r e t u r n ` < d i v s t y l e = " d i s p l a y : f l e x ; j u s t i f y - c o n t e n t : s p a c e - b e t w e e n ; w i d t h : 1 0 0 % ; a l i g n - i t e m s : c e n t e r ; " > < s p a n > < b > >@78=0: $ { v a l u e } < / b > < s m a l l s t y l e = " c o l o r : # 6 6 6 " > ( $ { c o u n t } <>4. ) < / s m a l l > < / s p a n > < b u t t o n o n c l i c k = " a d d M o d u l e T o R a c k ( ' $ { v a l u e } ' ) " s t y l e = " f o n t - s i z e : 1 1 p x ; p a d d i n g : 2 p x 8 p x ; c u r s o r : p o i n t e r ; b a c k g r o u n d : # f f f ; b o r d e r : 1 p x s o l i d # 9 9 9 ; b o r d e r - r a d i u s : 3 p x ; " > + >1028BL 2 MBC :>@78=C < / b u t t o n > < / d i v > ` ; } , c o l u m n s : [ { t i t l e : " >@78=0" , f i e l d : " r a c k " , e d i t o r : " i n p u t " , h e a d e r F i l t e r : t r u e } , { t i t l e : " !;>B" , f i e l d : " s l o t " , w i d t h : 8 0 , h o z A l i g n : " c e n t e r " , e d i t o r : " n u m b e r " } , { t i t l e : " "8?" , f i e l d : " t y p e " , e d i t o r : " l i s t " , e d i t o r P a r a m s : { v a l u e s : O b j e c t . k e y s ( m o d u l e L i b r a r y ) , c l e a r a b l e : t r u e } , c e l l E d i t e d : f u n c t i o n ( c e l l ) { / / : @8=C48B5;L=> >G8I05< 8 ?5@5@8A>2K205< OG59:C <>45;8 c o n s t r o w = c e l l . g e t R o w ( ) ; r o w . g e t C e l l ( " m o d e l " ) . s e t V a l u e ( " " ) ; } } , { t i t l e : " @B8:C;/ >45;L" , f i e l d : " m o d e l " , e d i t o r : " l i s t " , e d i t o r P a r a m s : ( c e l l ) = > { c o n s t t y p e = c e l l . g e t R o w ( ) . g e t D a t a ( ) . t y p e ; / / 5@Q< <0AA82 87 :>=AB0=BK 8;8 2>72@0I05< ?CAB>9, 5A;8 A>2?045=89 =5B c o n s t i t e m s = m o d u l e L i b r a r y [ t y p e ] | | [ ] ; r e t u r n { v a l u e s : i t e m s } ; } } , { f o r m a t t e r : " b u t t o n C r o s s " , w i d t h : 4 0 , h o z A l i g n : " c e n t e r " , c e l l C l i c k : ( e , c e l l ) = > c e l l . g e t R o w ( ) . d e l e t e ( ) } ] , } ) ; } ; / / 3 . $C=:F88 C?@02;5=8O 40==K<8 a s y n c f u n c t i o n s a v e C u r r e n t S h e e t ( ) { i f ( ! t a b l e ) r e t u r n P r o m i s e . r e s o l v e ( ) ; c o n s t d a t a = t a b l e . g e t D a t a ( ) ; r e t u r n f e t c h ( " / a p i / d a t a ? s h e e t = " + c u r r e n t S h e e t , { m e t h o d : " P O S T " , h e a d e r s : { " C o n t e n t - T y p e " : " a p p l i c a t i o n / j s o n " } , b o d y : J S O N . s t r i n g i f y ( d a t a ) } ) ; } a s y n c f u n c t i o n s w i t c h S h e e t ( b t n , s h e e t I d ) { a w a i t s a v e C u r r e n t S h e e t ( ) ; / / !>E@0=O5< ?5@54 CE>4>< d o c u m e n t . q u e r y S e l e c t o r A l l ( ' . t a b s b u t t o n ' ) . f o r E a c h ( b = > b . c l a s s L i s t . r e m o v e ( ' a c t i v e ' ) ) ; b t n . c l a s s L i s t . a d d ( ' a c t i v e ' ) ; c u r r e n t S h e e t = s h e e t I d ; t a b l e . s e t D a t a ( " / a p i / d a t a ? s h e e t = " + s h e e t I d ) ; } / / 4 . $C=:F88 4>102;5=8O M;5<5=B>2 f u n c t i o n a d d N e w R a c k ( ) { l e t n a m e = p r o m p t ( " 2548B5 =0720=85 =>2>9 :>@78=K: " , " R a c k " + t a b l e . g e t G r o u p s ( ) . l e n g t h ) ; i f ( n a m e ) { t a b l e . a d d R o w ( { r a c k : n a m e , s l o t : 0 , t y p e : " " , m o d e l : " " } ) ; } } f u n c t i o n a d d M o d u l e T o R a c k ( r a c k N a m e ) { c o n s t d a t a = t a b l e . g e t D a t a ( ) ; l e t m a x S l o t = - 1 ; d a t a . f o r E a c h ( r o w = > { i f ( r o w . r a c k = = = r a c k N a m e & & r o w . s l o t > m a x S l o t ) m a x S l o t = r o w . s l o t ; } ) ; t a b l e . a d d R o w ( { r a c k : r a c k N a m e , s l o t : m a x S l o t + 1 , t y p e : " " , m o d e l : " " } ) ; } / / #=825@A0;L=0O :=>?:0 " >1028BL <>4C;L" ( 2 ?>A;54=NN :>@78=C) f u n c t i o n a d d N e w M o d u l e ( ) { c o n s t d a t a = t a b l e . g e t D a t a ( ) ; c o n s t r a c k s = [ . . . n e w S e t ( d a t a . m a p ( i t e m = > i t e m . r a c k ) ) ] ; i f ( r a c k s . l e n g t h = = = 0 ) r e t u r n a d d N e w R a c k ( ) ; a d d M o d u l e T o R a c k ( r a c k s [ r a c k s . l e n g t h - 1 ] ) ; }