This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH RECURSIVE oktmos ("id", parent_id) AS ( | |
SELECT o."id", o.parent_id | |
FROM oktmo o | |
WHERE o."id" = 71875000 | |
UNION ALL | |
SELECT o."id", o.parent_id | |
FROM oktmo o INNER JOIN oktmos ON (oktmos."id" = o.parent_id) | |
), | |
schools_in_municipality AS ( | |
SELECT sc."id", sc."shortname" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH RECURSIVE oktmos ("id", parent_id) AS ( | |
SELECT o."id", o.parent_id | |
FROM oktmo o | |
WHERE o."id" = 71875000 | |
UNION ALL | |
SELECT o."id", o.parent_id | |
FROM oktmo o INNER JOIN oktmos ON (oktmos."id" = o.parent_id) | |
), | |
fs AS ( | |
SELECT sc."id", sc."shortname" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
explain ANALYZE WITH RECURSIVE sub_orgs(gid, organization_type) AS | |
(SELECT o.gid, o.organization_type FROM en_organization o | |
WHERE gid = 'b55d19bc-1ecc-68d9-bf7a-78ec21808327' | |
UNION SELECT | |
o.gid, o.organization_type FROM sub_orgs so, en_organization o | |
WHERE o.management_organization_gid = so.gid AND o.organization_type IN ('MOUO', 'ROUO')) | |
SELECT * FROM sub_orgs; | |
"CTE Scan on sub_orgs (cost=16.32..17.14 rows=41 width=36)" | |
" CTE sub_orgs" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
childDeepClone: function (child) { | |
var childCopy = _.pick(child, 'lastName', 'firstName', 'middleName', 'birthDate', 'gender', 'birthPlace', 'snils'); | |
if (_.isArray(child.addressList)) { | |
var addressCopy = []; | |
_.each(child.addressList, function (address) { | |
if (address) { | |
addressCopy.push(_.pick(address, 'postalCode', 'fullAddress', 'fullHouse', 'addressUID', 'houseUID', 'plain', 'oktmo', 'flat', 'type')); | |
} else { | |
addressCopy.push(null); | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"orgType": { | |
"name": "OO", | |
"code": 3, | |
"title": "ОО", | |
"management": false | |
}, | |
"permissions": { | |
"ADM_SUPER": 1, | |
"SPO_OO_MY_ORGANIZATION": 3, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
db.keeperhandledfiles.find({name:{$nin:["040ed108-aa3c-4f62-9543-493665085385.xml","405d1d99-007b-4fa6-bc83-63817ffd8ef9.xml","87d2698e-7bc3-4cca-859a-a7fb9e660328.xml","ef7f7505-5dfa-4996-9715-349afc032a86.xml","007b4e10-52fc-4e5f-85ab-80c576e6aafb.xml","00d92039-9d21-4c10-810d-135092cd1afc.xml","00e03c93-7bca-488d-b654-29880d34ff1b.xml","0131c139-af9f-4708-9e65-500bab1d5b36.xml","016d71d4-6f01-4c4b-90f4-67f943d0bf22.xml","020b0b9d-db87-409c-a852-dfc7cb00ef3d.xml","03608107-4966-4acb-9e6a-05870938a444.xml","04414869-231a-4845-ad9b-df8211091862.xml","04b8e648-f15a-4c25-9aee-67ca0c4c9487.xml","059efa17-1f96-4eca-9330-a0e1c09e131d.xml","06ce1ee6-5253-43af-a165-656f0d5094d0.xml","09745f4e-6abb-4417-80da-64329c0442ea.xml","09bb326a-e99c-484a-b5dc-4076fc2e56c0.xml","0aefbfe0-ccc6-4598-8af3-c73e4281b168.xml","0f8daca7-3479-45be-8277-3083a2280bcd.xml","0fd7398c-740a-4d38-bd26-9878ae8e8ddb.xml","10da12ae-95cb-47af-8756-526696dbd986.xml","1195e4f6-780b-4133-ad42-66ed470dcad5.xml","12129ade-c1bd-42f5-8b45-e85b257c5e54. |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
@NamedEntityGraphs({ | |
@NamedEntityGraph( | |
name = "OdoPetition.xls", | |
attributeNodes = { | |
@NamedAttributeNode("document"), | |
@NamedAttributeNode("organization"), | |
@NamedAttributeNode(value = "studyProgram", subgraph = "OdoPetition.studyProgram.xls") | |
}, | |
subgraphs = { | |
@NamedSubgraph(name = "OdoPetition.studyProgram.xls", |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
person0_.guid as guid1_92_, | |
person0_.createdTs as createdT2_92_, | |
person0_.updatedTs as updatedT3_92_, | |
person0_.provider_guid as provide38_92_, | |
person0_. timestamp as timestam4_92_, | |
person0_.deleted as deleted5_92_, | |
person0_.deleted_by_provider as deleted_6_92_, | |
person0_.adapt_program_needy as adapt_pr7_92_, | |
person0_.birth_date as birth_da8_92_, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
personlink0_.guid as guid1_99_, | |
personlink0_.createdTs as createdT2_99_, | |
personlink0_.updatedTs as updatedT3_99_, | |
personlink0_.provider_guid as provide10_99_, | |
personlink0_. timestamp as timestam4_99_, | |
personlink0_.child_guid as child_g11_99_, | |
personlink0_.link_create_date as link_cre5_99_, | |
personlink0_.deleted as deleted6_99_, | |
personlink0_.deleted_by_provider as deleted_7_99_, |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
select | |
personids0_.person_guid as person_g1_92_0_, | |
personids0_.origin_id as origin_i2_98_0_, | |
personids0_.provider_guid as provider3_0_, | |
provider1_.guid as guid1_110_1_, | |
provider1_.createdTs as createdT2_110_1_, | |
provider1_.updatedTs as updatedT3_110_1_, | |
provider1_.active as active4_110_1_, | |
provider1_.all_access as all_acce5_110_1_, | |
provider1_.apiKey as apiKey6_110_1_, |
OlderNewer