API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 17th, 2020
88
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 20.65 KB | None | 0 0
raw download clone embed print report
  1. form Block
  2. name Блокове
  3.  
  4. hor_sectors 2 dimensions 2:8
  5. ver_sectors 1 dimensions 1
  6.  
  7. view_block Block grid
  8. name Блокове
  9. coordinates 1,1,1,1
  10. end_view_block
  11.  
  12. view_block Room grid
  13. name Стаи
  14. coordinates 2,1,2,1
  15. end_view_block
  16.  
  17. view_block BlockRentPrice nested
  18. name Цена на наема за блок
  19. coordinates 1,1,1,1
  20. end_view_block
  21.  
  22. view_block RoomRentPrice nested
  23. name Цена на наема за стая
  24. coordinates 1,1,1,1
  25. end_view_block
  26. end_form
  27.  
  28. view Block
  29.  
  30. unique_key BlockID
  31.  
  32. can_delete Eng.HasRight("ADMIN")
  33. can_save Eng.HasRight("INSPECTORMAN")
  34.  
  35. sql_unique_clause BlockID = is_gen_long
  36.  
  37. sql
  38. line SELECT * FROM SOS_Block ^^ order by BlockName
  39. end_sql
  40.  
  41. sql_count
  42. line SELECT count(*) FROM SOS_Block
  43. end_sql_count
  44.  
  45. sql_max
  46. line SELECT MAX(BlockID) FROM SOS_Block
  47. end_sql_max
  48.  
  49.  
  50. col BlockID
  51. length 4
  52. name ID Блок
  53. relation_point ToBlockRentPrice
  54. relation_block BlockRentPrice
  55. end_col
  56.  
  57. col BlockName
  58. length 10
  59. name Блок
  60. relation_point SOS_BLOCK->SOS_ROOM
  61. relation_block ROOM
  62. stay_linked true
  63. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  64. end_col
  65.  
  66. col TypePowerMeasure
  67. name Тип електромер
  68. length 10
  69. edit_type button
  70. button_state Блоков, Стаен
  71. button_key 0,1
  72. default_value 0
  73. end_col
  74.  
  75. col Active
  76. name Активен?
  77. length 10
  78. edit_type button
  79. button_state НЕ, ДА
  80. button_key 0,1
  81. default_value 1
  82. end_col
  83.  
  84. col TotalVolume
  85. name Пълен отопляем обем (куб.м.)
  86. length 10
  87. decimals 3
  88. end_col
  89.  
  90. col HeatingPower
  91. name Мощност абонатна станция(квт)
  92. length 10
  93. decimals 3
  94. viewable_in_grid hidden
  95. end_col
  96.  
  97. col RentCoef
  98. name Коефициент наем
  99. length 10
  100. decimals 2
  101. viewable_in_grid normal
  102. validate BLOCK_RENTCOEF>=0
  103. end_col
  104.  
  105.  
  106. relation SOS_Block->SOS_Room
  107. name Стаи
  108. type one_to_many
  109. rs_from Block
  110. rs_to Room
  111. fields_from BlockID
  112. fields_to BlockID
  113. end_relation
  114.  
  115. relation ToBlockRentPrice
  116. name Цена на наема за блока
  117. type one_to_many
  118. rs_from Block
  119. rs_to BlockRentPrice
  120. fields_from BlockID
  121. fields_to BlockID
  122. end_relation
  123. end_view
  124.  
  125. view BlockRentPrice
  126. unique_key BlockID, RoomID, ValueDate
  127. sql
  128. line SELECT * FROM SOS_RENTPRICE ^^ WHERE BlockID=is_gen_long AND RoomID = -1 ORDER BY ValueDate DESC
  129. end_sql
  130.  
  131. col ID
  132. name ID
  133. length 10
  134. viewable_in_grid hidden
  135. sql_ignore yes
  136. end_col
  137.  
  138. col BlockID
  139. name ID блок
  140. length 10
  141. viewable_in_grid hidden
  142. end_col
  143.  
  144. col RoomID
  145. name ID стая
  146. length 10
  147. viewable_in_grid hidden
  148. default_value -1
  149. end_col
  150.  
  151. col ValueDate
  152. name От дата
  153. length 10
  154. end_col
  155.  
  156. col ValueType
  157. name Вид стойност
  158. length 10
  159. edit_type button
  160. button_state ПРОЦЕНТ,СУМА
  161. button_key 0,1
  162. default_value 0
  163. end_col
  164.  
  165. col ValueAmount
  166. name Стойност
  167. length 10
  168. decimals 2
  169. validate BLOCKRENTPRICE_VALUEAMOUNT>0
  170. end_col
  171.  
  172. end_view
  173.  
  174. view Room
  175.  
  176. unique_key BlockID, RoomID
  177.  
  178. sql
  179. line SELECT * FROM SOS_ROOM ^^ where BlockID = is_gen_long order by RoomName
  180. end_sql
  181.  
  182. sql_count
  183. line SELECT count(*) FROM SOS_ROOM where BlockID = is_gen_long
  184. params BlockID
  185. end_sql_count
  186.  
  187. sql_max
  188. line SELECT max(RoomID) FROM SOS_ROOM where BlockID = is_gen_long
  189. params BlockID
  190. end_sql_max
  191.  
  192. can_delete Eng.HasRight("ADMIN")
  193. can_save Eng.HasRight("INSPECTORMAN")
  194.  
  195. col BlockID
  196. length 4
  197. name ID Блок
  198. viewable_in_grid hidden
  199. end_col
  200.  
  201. col RoomID
  202. length 4
  203. name ID Стая
  204. relation_point ToRoomRentPrice
  205. relation_block RoomRentPrice
  206. end_col
  207.  
  208. col RoomName
  209. name Стая
  210. length 10
  211. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  212. end_col
  213.  
  214. col Places
  215. name Max. Места
  216. length 10
  217. VALIDATE ROOM_PLACES >= 0 && ROOM_PLACES <= 60 && ROOM_BUSY <= ROOM_PLACES
  218. end_col
  219.  
  220. col Busy
  221. length 10
  222. name Заети Места
  223. VALIDATE ROOM_BUSY >= 0 && ROOM_BUSY <= 60
  224. end_col
  225.  
  226. col Area
  227. name Площ
  228. length 10
  229. decimals 2
  230. end_col
  231.  
  232. col PowerMeter
  233. name Електромер
  234. length 10
  235. edit_type button
  236. button_state НЕ, ДА
  237. button_key 0,1
  238. default_value 0
  239.  
  240. end_col
  241.  
  242. col Lift
  243. name Асансьор
  244. length 10
  245. edit_type button
  246. button_state НЕ, ДА
  247. button_key 0,1
  248. default_value 0
  249.  
  250. end_col
  251.  
  252. col Cleaner
  253. name Чистачка
  254. length 10
  255. edit_type button
  256. button_state НЕ, ДА
  257. button_key 0,1
  258. default_value 0
  259. end_col
  260.  
  261. col Heating
  262. name Парно
  263. length 10
  264. edit_type button
  265. button_state НЕ, ДА
  266. button_key 0,1
  267. default_value 0
  268. end_col
  269.  
  270. col RoomType
  271. name Тип Стая
  272. length 10
  273. edit_type combo
  274. combo_sql gen_select 0,Празна,1,Мъжка,2,Женска,3,Семейна,4,Чужденци
  275. default_value 0
  276. end_col
  277.  
  278. col IsActive
  279. name Използуване
  280. length 10
  281. edit_type button
  282. button_state НЕ, ДА
  283. button_key 0,1
  284. default_value 1
  285. end_col
  286.  
  287. col IsPayConsume
  288. name Плаща ли консумативи?
  289. length 10
  290. edit_type button
  291. button_state НЕ, ДА
  292. button_key 0,1
  293. default_value 1
  294. end_col
  295.  
  296. col CoefPower
  297. name Коефицент за ел. енергия
  298. length 10
  299. decimals 3
  300. end_col
  301.  
  302. col Volume
  303. name Отопляем обем (куб.м.)
  304. length 10
  305. decimals 3
  306. end_col
  307.  
  308. col RentCoef
  309. name Коефициент наем
  310. length 10
  311. decimals 2
  312. viewable_in_grid normal
  313. validate ROOM_RENTCOEF>=0
  314. end_col
  315.  
  316. col PenaltyCoef
  317. name Наказателен коефициент
  318. length 10
  319. viewable_in_grid normal
  320. edit_type button
  321. button_state НЕ, ДА, НЕДЕКЛАРИРАНИ ЕЛ.УРЕДИ
  322. button_key 0,1,2
  323. default_value 0
  324. end_col
  325. relation ToRoomRentPrice
  326. name Цена на наема за стая
  327. type one_to_many
  328. rs_from Room
  329. rs_to RoomRentPrice
  330. fields_from BlockID, RoomID
  331. fields_to BlockID, RoomID
  332. end_relation
  333.  
  334. end_view
  335.  
  336. view RoomRentPrice
  337. unique_key BlockID, RoomID, ValueDate
  338. sql
  339. line SELECT * FROM SOS_RENTPRICE ^^ WHERE BlockID=is_gen_long AND RoomID = is_gen_long ORDER BY ValueDate DESC
  340. end_sql
  341.  
  342. col ID
  343. name ID
  344. length 10
  345. viewable_in_grid hidden
  346. sql_ignore yes
  347. end_col
  348.  
  349. col BlockID
  350. name ID блок
  351. length 10
  352. viewable_in_grid hidden
  353. end_col
  354.  
  355. col RoomID
  356. name ID стая
  357. length 10
  358. viewable_in_grid hidden
  359. end_col
  360.  
  361. col ValueDate
  362. name От дата
  363. length 10
  364. end_col
  365.  
  366. col ValueType
  367. name Вид стойност
  368. length 10
  369. edit_type button
  370. button_state ПРОЦЕНТ,СУМА
  371. button_key 0,1
  372. default_value 0
  373. end_col
  374.  
  375. col ValueAmount
  376. name Стойност
  377. length 10
  378. decimals 2
  379. validate ROOMRENTPRICE_VALUEAMOUNT>0
  380. end_col
  381.  
  382. end_view
  383.  
  384. form Department
  385. name Факултети и специалности
  386.  
  387. hor_sectors 1 dimensions 1
  388. ver_sectors 2 dimensions 3:5
  389.  
  390. view_block Departments grid
  391. name Факултети
  392. coordinates 1,1,1,1
  393. end_view_block
  394.  
  395. view_block Subjects grid
  396. name Специалности
  397. coordinates 1,2,1,2
  398. end_view_block
  399.  
  400. end_form
  401.  
  402. view Departments
  403.  
  404. unique_key DepartmentID
  405.  
  406. can_save Eng.HasRight("ADMIN")
  407.  
  408. sql_unique_clause DepartmentID = is_gen_long
  409.  
  410. sql
  411. line SELECT * FROM SOS_DEPARTMENT ^^ order by DepartmentAbrv
  412. end_sql
  413.  
  414. sql_count
  415. line SELECT count(*) FROM SOS_DEPARTMENT
  416. end_sql_count
  417.  
  418. sql_max
  419. line SELECT MAX(DepartmentID) FROM SOS_DEPARTMENT
  420. end_sql_max
  421.  
  422. can_delete Eng.HasRight("ADMIN")
  423.  
  424. col DepartmentID
  425. length 3
  426. name ID Факултет
  427. end_col
  428.  
  429. col DepartmentAbrv
  430. length 8
  431. name Съкр. наименование
  432. relation_point Departments->Subjects
  433. relation_block Subjects
  434. stay_linked yes
  435. validate DEPARTMENTS_DEPARTMENTABRV!=""
  436. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  437. end_col
  438.  
  439. col DepartmentName
  440. length 30
  441. name Наименование
  442. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  443. end_col
  444.  
  445. col IsLocal
  446. name ВУЗ
  447. length 10
  448. edit_type button
  449. button_state ТУ, ДРУГ ВУЗ
  450. button_key 1,0
  451. default_value 1
  452. end_col
  453.  
  454. relation Departments->Subjects
  455. name Специалности
  456. type one_to_many
  457. rs_from Departments
  458. rs_to Subjects
  459. fields_from DepartmentID
  460. fields_to DepartmentID
  461. end_relation
  462.  
  463.  
  464. end_view
  465. view Subjects
  466.  
  467. unique_key DepartmentID, SubjectID
  468.  
  469. cmd_line yes
  470.  
  471. sql
  472. line SELECT * FROM SOS_SUBJECT ^^ where DepartmentID = is_gen_long order by SubjectAbrv
  473. end_sql
  474.  
  475. sql_count
  476. line SELECT count(*) FROM SOS_SUBJECT where DepartmentID = is_gen_long
  477. end_sql_count
  478.  
  479. sql_max
  480. line SELECT max(SubjectID) FROM SOS_SUBJECT where DepartmentID = is_gen_long
  481. Params DepartmentID
  482. end_sql_max
  483.  
  484. can_delete Eng.HasRight("ADMIN")
  485. col DepartmentID
  486. length 3
  487. viewable_in_grid hidden
  488. end_col
  489.  
  490. col SubjectID
  491. length 3
  492. //viewable_in_grid hidden
  493. name ID
  494. end_col
  495.  
  496. col SubjectAbrv
  497. length 10
  498. name Съкр. наименование
  499. VALIDATE SUBJECTS_SUBJECTABRV!=""
  500. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  501. end_col
  502.  
  503. col SubjectName
  504. name Наименование
  505. length 25
  506. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  507. end_col
  508. end_view
  509.  
  510.  
  511.  
  512. form Country
  513. name Номенклатури
  514.  
  515. hor_sectors 1 dimensions 1
  516. ver_sectors 1 dimensions 1:1
  517.  
  518. view_block Country grid
  519. name Държави
  520. coordinates 1,1,1,1
  521. end_view_block
  522.  
  523. end_form
  524.  
  525. view Country
  526.  
  527. unique_key CountryID
  528.  
  529. can_save Eng.HasRight("ADMIN")
  530.  
  531. sql_unique_clause CountryID = is_gen_long
  532.  
  533. sql
  534. line SELECT * FROM SOS_COUNTRY ^^ order by CountryName
  535. end_sql
  536.  
  537. sql_count
  538. line SELECT count(*) FROM SOS_COUNTRY
  539. end_sql_count
  540.  
  541. sql_max
  542. line SELECT MAX(CountryID) FROM SOS_COUNTRY
  543. end_sql_max
  544.  
  545. can_delete Eng.HasRight("ADMIN")
  546.  
  547. col CountryID
  548. length 3
  549. name ID Държава
  550. end_col
  551.  
  552. col CountryName
  553. length 35
  554. name Наименование
  555. validate COUNTRY_COUNTRYNAME!=""
  556. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  557. end_col
  558. end_view
  559.  
  560.  
  561. form EducationType
  562. name Номенклатури
  563.  
  564. hor_sectors 1 dimensions 1
  565. ver_sectors 1 dimensions 1:1
  566.  
  567. view_block EducationTypes grid
  568. name Форми на обучение
  569. coordinates 1,1,1,1
  570. end_view_block
  571.  
  572. end_form
  573.  
  574. view EducationTypes
  575.  
  576. unique_key EduTypeID
  577.  
  578. can_save Eng.HasRight("ADMIN")
  579.  
  580. sql_unique_clause EduTypeID = is_gen_long
  581.  
  582. sql
  583. line SELECT * FROM SOS_EDUTYPE ^^ order by EduTypeAbrv
  584. end_sql
  585.  
  586. sql_count
  587. line SELECT count(*) FROM SOS_EDUTYPE
  588. end_sql_count
  589.  
  590. sql_max
  591. line SELECT MAX(EduTypeID) FROM SOS_EDUTYPE
  592. end_sql_max
  593.  
  594. can_delete Eng.HasRight("ADMIN")
  595.  
  596. col EduTypeID
  597. length 3
  598. name ID
  599. end_col
  600.  
  601. col EduTypeAbrv
  602. length 4
  603. name Съкр.
  604. validate EDUCATIONTYPES_EDUTYPEABRV != ""
  605. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  606. end_col
  607.  
  608. col EduTypeName
  609. length 35
  610. name Наименование
  611. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  612. end_col
  613. end_view
  614.  
  615. form StudentTypes
  616. name Номенклатури
  617.  
  618. hor_sectors 1 dimensions 1
  619. ver_sectors 1 dimensions 1:1
  620.  
  621. view_block StudentTypes grid
  622. name Категории студенти
  623. coordinates 1,1,1,1
  624. end_view_block
  625.  
  626. end_form
  627.  
  628. view StudentTypes
  629. head_lines 1
  630. unique_key StudentTypeID
  631.  
  632. can_save Eng.HasRight("ADMIN")
  633. can_delete Eng.HasRight("ADMIN")
  634.  
  635. sql_unique_clause StudentTypeID = is_gen_long
  636.  
  637. sql
  638. line SELECT * FROM SOS_STUDENTTYPE ^^ order by StudentTypeAbrv
  639. end_sql
  640.  
  641. sql_count
  642. line SELECT count(*) FROM SOS_STUDENTTYPE
  643. end_sql_count
  644.  
  645. sql_max
  646. line SELECT MAX(StudentTypeID) FROM SOS_STUDENTTYPE
  647. end_sql_max
  648.  
  649. col StudentTypeID
  650. length 3
  651. name ID
  652. end_col
  653.  
  654. col StudentTypeAbrv
  655. length 4
  656. name Съкр.
  657. validate STUDENTTYPES_STUDENTTYPEABRV != ""
  658. validate_msg Въведете съкратено наименование!
  659. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  660. end_col
  661.  
  662. col StudentTypeName
  663. length 20
  664. name Наименование
  665. validate STUDENTTYPES_STUDENTTYPENAME != ""
  666. validate_msg Въведете наименование!
  667. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  668. end_col
  669.  
  670. col OrderNo
  671. length 10
  672. name Заповед номер
  673. validate STUDENTTYPES_ORDERNO != ""
  674. validate_msg Въведете заповед номер!
  675. end_col
  676.  
  677. col OrderDate
  678. length 10
  679. name Заповед дата
  680. validate (new Date(STUDENTTYPES_ORDERDATE)).getFullYear() > 1900
  681. validate_msg Въведете дата на заповедта!
  682. end_col
  683.  
  684. col FromDate
  685. length 10
  686. name От дата
  687. validate (new Date(STUDENTTYPES_FROMDATE)).getFullYear() > 1900
  688. validate_msg Въведете начална дата на заповедта!
  689. end_col
  690.  
  691. col ToDate
  692. length 10
  693. name До дата
  694. validate (new Date(STUDENTTYPES_TODATE)).getFullYear() > 1900
  695. validate_msg Въведете крайна дата на заповедта!
  696. end_col
  697.  
  698. col PaySubsidy
  699. name Без субсидия(САМО за ДП!!!)
  700. length 20
  701. edit_type combo
  702. combo_sql GEN_SELECT 0,ПРЕЗ УЧ. ГОДИНА,1,ЦЕЛОГОДИШНО
  703. default_value 0
  704. end_col
  705. end_view
  706.  
  707.  
  708. form Penalty
  709. name Номеклатури
  710.  
  711. hor_sectors 1 dimensions 1
  712. ver_sectors 1 dimensions 1:1
  713.  
  714. view_block Penalties grid
  715. name Наказания
  716. coordinates 1,1,1,1
  717. end_view_block
  718.  
  719. end_form
  720.  
  721. view Penalties
  722.  
  723. unique_key PenaltyID
  724.  
  725. can_save Eng.HasRight("ADMIN")
  726.  
  727. sql_unique_clause PenaltyID = is_gen_long
  728.  
  729. sql
  730. line SELECT * FROM SOS_Penalty ^^ order by PenaltyName
  731. end_sql
  732.  
  733. sql_count
  734. line SELECT count(*) FROM SOS_Penalty
  735. end_sql_count
  736.  
  737. sql_max
  738. line SELECT MAX(PenaltyID) FROM SOS_Penalty
  739. end_sql_max
  740.  
  741. can_delete Eng.HasRight("ADMIN")
  742.  
  743. col PenaltyID
  744. length 3
  745. name ID Наказание
  746. end_col
  747.  
  748. col PenaltyName
  749. length 35
  750. name Наименование
  751. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  752. end_col
  753. end_view
  754.  
  755. form AcadYear
  756. name Номеклатури
  757.  
  758. hor_sectors 1 dimensions 1
  759. ver_sectors 1 dimensions 1:1
  760.  
  761. view_block AcadYear grid
  762. name Учебни години
  763. coordinates 1,1,1,1
  764. end_view_block
  765.  
  766. end_form
  767.  
  768. view AcadYear
  769. script
  770. line {{
  771. function isValidAcadYear() {
  772. var diff ;
  773. var from, to, sep ;
  774. if (ACADYEAR_ACADYEARNAME.length != 9) return false ;
  775. from = ACADYEAR_ACADYEARNAME.substr(0, 4) ;
  776. sep = ACADYEAR_ACADYEARNAME.substr(4, 1) ;
  777. to = ACADYEAR_ACADYEARNAME.substr(5, 4) ;
  778. if (sep != "/") return false ;
  779. diff = to - from ;
  780. if (diff != 1) return false ;
  781. return true ;
  782. }
  783. function isValidFromDate() {
  784. var year1, year2 ;
  785. year1 = new Date(ACADYEAR_FROMDATE) ;
  786. if(year1.getDate() == 1 && year1.getMonth() ==0)
  787. return false;
  788. year2 = ACADYEAR_ACADYEARNAME.substr(0, 4) ;
  789. return year1.getFullYear() == year2 ;
  790. }
  791. function isValidToDate() {
  792. var year1, year2 ;
  793. year1 = new Date(ACADYEAR_TODATE) ;
  794. if(year1.getDate() == 31 && year1.getMonth() ==11)
  795. return false;
  796. year2 = ACADYEAR_ACADYEARNAME.substr(5, 4) ;
  797. return year1.getFullYear() == year2 ;
  798. }
  799. }}
  800. end_script
  801.  
  802. unique_key AcadYearID
  803.  
  804. can_save Eng.HasRight("ADMIN")
  805. sql_unique_clause AcadYearID = is_gen_long
  806.  
  807. sql
  808. line SELECT * FROM SOS_ACADYEAR ^^ order by ACADYEARNAME
  809. end_sql
  810.  
  811. sql_count
  812. line SELECT count(*) FROM SOS_ACADYEAR
  813. end_sql_count
  814.  
  815. sql_max
  816. line SELECT MAX(AcadYearID) FROM SOS_ACADYEAR
  817. end_sql_max
  818.  
  819. can_delete Eng.HasRight("ADMIN")
  820.  
  821. col AcadYearID
  822. length 3
  823. name ID
  824. end_col
  825.  
  826. col ACADYEARNAME
  827. length 10
  828. name Учебна год.
  829. picture 9999_9999
  830. default_value "____/____"
  831. mask ____/____
  832. validate isValidAcadYear()
  833. //validate_msg Невалиден формат!
  834. end_col
  835.  
  836. col FromDate
  837. length 8
  838. name От дата
  839. validate isValidFromDate()
  840. end_col
  841.  
  842. col ToDate
  843. length 8
  844. name До дата
  845. validate isValidToDate()
  846. end_col
  847.  
  848. end_view
  849.  
  850. form Year
  851. name Летни Месеци
  852.  
  853. hor_sectors 1 dimensions 1
  854. ver_sectors 1 dimensions 1:1
  855.  
  856. view_block Year grid
  857. name Летни Месеци
  858. coordinates 1,1,1,1
  859. end_view_block
  860.  
  861. end_form
  862.  
  863. view Year
  864. script
  865. line {{
  866. function isValidFromDateSummer() {
  867. var yeartmp;
  868. yeartmp = new Date(YEAR_FROMDATESUMMER) ;
  869. return yeartmp.getFullYear() == YEAR_YEAR ;
  870. }
  871. function isValidToDateSummer() {
  872. var yeartmp;
  873. yeartmp = new Date(YEAR_TODATESUMMER) ;
  874. return yeartmp.getFullYear() == YEAR_YEAR ;
  875. }
  876. }}
  877. end_script
  878.  
  879. unique_key Year
  880.  
  881. can_save Eng.HasRight("ADMIN")
  882. sql_unique_clause Year = is_gen_long
  883.  
  884. sql
  885. line SELECT * FROM SOS_YEAR ^^ order by YEAR
  886. end_sql
  887.  
  888. sql_count
  889. line SELECT count(*) FROM SOS_YEAR
  890. end_sql_count
  891.  
  892. can_delete Eng.HasRight("ADMIN")
  893.  
  894. col Year
  895. name Година
  896. length 10
  897. end_col
  898.  
  899. col FromDateSummer
  900. length 10
  901. name От дата Лято
  902. validate isValidFromDateSummer()
  903. end_col
  904.  
  905. col ToDateSummer
  906. length 10
  907. name До дата Лято
  908. validate isValidToDateSummer()
  909. end_col
  910.  
  911. end_view
  912.  
  913. form PayItem
  914. name Номеклатури
  915.  
  916. hor_sectors 1 dimensions 1
  917. ver_sectors 1 dimensions 1:1
  918.  
  919. view_block PayItem grid
  920. name Видове плащания
  921. coordinates 1,1,1,1
  922. end_view_block
  923.  
  924. end_form
  925.  
  926. view PayItem
  927. unique_key PayItemID
  928.  
  929. sql_unique_clause PayItemID = is_gen_long
  930.  
  931. can_save Eng.HasRight("ADMIN")
  932. can_delete Eng.HasRight("ADMIN")
  933.  
  934. sql
  935. line SELECT * FROM SOS_PAYITEM ^^
  936. end_sql
  937.  
  938. sql_count
  939. line SELECT count(*) FROM SOS_PAYITEM
  940. end_sql_count
  941.  
  942. sql_max
  943. line SELECT MAX(PayItemID) FROM SOS_PAYITEM
  944. end_sql_max
  945.  
  946. col PayItemID
  947. length 10
  948. name ID
  949. end_col
  950.  
  951. col PayItemName
  952. length 30
  953. name Вид плащане
  954. validate PAYITEM_PAYITEMNAME != ""
  955. validate_msg Въведете вид плащане!
  956. picture $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
  957. end_col
  958. end_view
  959.  
  960. form DocNo
  961. name Номеклатури
  962.  
  963. hor_sectors 1 dimensions 1
  964. ver_sectors 1 dimensions 1:1
  965.  
  966. view_block DocNo grid
  967. name Последни номера на документи
  968. coordinates 1,1,1,1
  969. end_view_block
  970.  
  971. end_form
  972.  
  973. view DocNo
  974. unique_key ID
  975.  
  976. sql_unique_clause ID = is_gen_long
  977.  
  978. can_save Eng.HasRight("ADMIN")
  979. can_delete Eng.HasRight("ADMIN")
  980.  
  981. sql
  982. line SELECT * FROM SOS_DOCNO ^^ ORDER BY LastDocNum
  983. end_sql
  984.  
  985. sql_count
  986. line SELECT count(*) FROM SOS_DOCNO
  987. end_sql_count
  988.  
  989. sql_max
  990. line SELECT MAX(ID) FROM SOS_DOCNO
  991. end_sql_max
  992.  
  993. col ID
  994. length 7
  995. name ID
  996. end_col
  997.  
  998. col LastDocNum
  999. length 15
  1000. name Последен номер фактура
  1001. validate DOCNO_LASTDOCNUM >= 0
  1002. end_col
  1003.  
  1004. col LastOrderNum
  1005. length 15
  1006. name Последен номер заповед
  1007. validate DOCNO_LASTORDERNUM >= 0
  1008. end_col
  1009.  
  1010. col LastOrderDoctorant
  1011. length 15
  1012. name Последен номер заповед докторанти
  1013. validate DOCNO_LASTORDERDOCTORANT >= 0
  1014. end_col
  1015.  
  1016. end_view
  1017.  
  1018.  
  1019. form LivStatus
  1020. name Номенклатури
  1021.  
  1022. hor_sectors 1 dimensions 1
  1023. ver_sectors 1 dimensions 1
  1024.  
  1025. view_block LivStatus grid
  1026. name Житейски статус
  1027. coordinates 1,1,1,1
  1028. end_view_block
  1029.  
  1030. end_form
  1031.  
  1032. view LivStatus
  1033.  
  1034. unique_key LivStatusID
  1035.  
  1036. can_delete Eng.HasRight("ADMIN")
  1037.  
  1038. sql
  1039. line SELECT * FROM SOS_LivStatus ^^
  1040. end_sql
  1041.  
  1042. sql_count
  1043. line SELECT count(*) FROM SOS_LivStatus
  1044. end_sql_count
  1045.  
  1046. sql_max
  1047. line SELECT MAX(LivStatusID) FROM SOS_LivStatus
  1048. end_sql_max
  1049.  
  1050. col LivStatusID
  1051. name ID Статус
  1052. length 8
  1053. end_col
  1054.  
  1055. col LivStatusName
  1056. name Наименование
  1057. length 20
  1058. end_col
  1059.  
  1060. col PercRent
  1061. name Процент от наема
  1062. length 10
  1063. decimals 2
  1064. end_col
  1065.  
  1066. end_view
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!