Skip to content

Instantly share code, notes, and snippets.

@kovenko
Last active May 18, 2020 11:37
Show Gist options
  • Save kovenko/4f243b02ccc178cff591a654cb436b71 to your computer and use it in GitHub Desktop.
Save kovenko/4f243b02ccc178cff591a654cb436b71 to your computer and use it in GitHub Desktop.
8583427 г. Барнаул, ул. Беляева, д. 18
SELECT
hres.resettlement_type_id, r.name, hres.*
FROM new_reloc_contracts nrc
JOIN new_reloc_contracts_quarters nrcq ON nrcq.contract_id = nrc.id
JOIN house_resettlements hres ON hres.id = nrcq.house_resettlement_id AND hres.deleted_at IS NULL
JOIN refs r ON r.id = hres.resettlement_type_id
WHERE nrc.contract_number LIKE '12653%' AND nrc.deleted_at IS NULL
$contract
https://ais.reformagkh.localhost/regional-system-ps/contract/add-quarters/18049
quarter[stage]: 2376
quarter[request]: 7738
quarter[alarmQuarterParts][0][id]: 0
quarter[alarmQuarterParts][0][newRelocQuarterId]: 30832
quarter[alarmQuarterParts][0][alarmQuarterId]: 8824384
quarter[alarmQuarterParts][0][resettlementSquare]: 15.2
quarter[alarmQuarterParts][0][resettlementPpl]: 3
quarter[alarmQuarterParts][1][id]: 0
quarter[alarmQuarterParts][1][newRelocQuarterId]: 30833
quarter[alarmQuarterParts][1][alarmQuarterId]: 8824384
quarter[alarmQuarterParts][1][resettlementSquare]: 15.2
quarter[alarmQuarterParts][1][resettlementPpl]: 3
quarter[alarmQuarterParts][2][id]: 0
quarter[alarmQuarterParts][2][newRelocQuarterId]:
quarter[alarmQuarterParts][2][alarmQuarterId]: 8824384
quarter[alarmQuarterParts][2][resettlementSquare]: 15.2
quarter[alarmQuarterParts][2][resettlementPpl]: 3
$contractHouseRepository->addQuarters
$contract
$object = null
$user = 1
$stage = 2376
$request = 7738
$addedQuartersIds = []
$addedQuartersParts = [
0 = {array} [4]
new_reloc_quarter_id = {int} 30832
ajf_quarter_id = {int} 8824384
square = "15.2"
ppl = "3"
1 = {array} [4]
new_reloc_quarter_id = {int} 30833
ajf_quarter_id = {int} 8824384
square = "15.2"
ppl = "3"
2 = {array} [4]
new_reloc_quarter_id = null
ajf_quarter_id = {int} 8824384
square = "15.2"
ppl = "3"
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment