Iminqweno yam kwi-DBMS yexesha elizayo, kunye ne-Rosreestr malunga nokuthengiselana

Umxhasi usebenzisana nesiseko sedatha.
Ukusuka kwindawo http://corchaosis.ru, nguJonathan Tiong.

Ukongeza kwinto yokuba ndingumdwelisi weprogram (ikakhulukazi iDelphi + zonke iintlobo zeDBMS ezahlukeneyo, kutshanje i-ORACLE, + i-PHP encinci), ndinomsebenzi wokuzonwabisa - ukuthenga nokuthengisa amagumbi. Ndithenga indawo yokuhlala ngexesha lokwakha kumphuhlisi othembekileyo ongaphezulu okanye ongaphantsi ngexabiso elilungileyo (umzekelo, ngoku uSamolet ngumakhi onjalo, amagumbi akufutshane nesikhululo semetro saseNekrasovka ayathengiswa), linda ukuhanjiswa kwendlu (kaninzi zimbini. iminyaka kamva, oku kwenzeka ngezibonelelo ezingabizi), ndiyayihlaziya kwaye emva koko ndiyithengise nge-95-100% yexabiso layo lemarike.

Ngoko ke, mna (njengaye wonke umntu) ndijongene nengxaki yokungabikho kokuthengiselana kweRosReestr.

Ingxaki yokunqongophala kweRosreestr yeentengiselwano zokuthengiselana

Kwinkqubo yi "Transaction", kwaye kwi-real estate "iNtengiselwano kunye nenye indlela" (kwaye kwakhona, njengenxalenye yayo, "iSivumelwano seBhokisi yeDiphozithi eKhuselekileyo"), kwaye inzima ngakumbi. Ndiyakuxelela.

UVasya weza kubona indlu eyayithengiswa nguPetya. Kwaye uVasya wayethanda ngokwenene yonke into, kubandakanywa nexabiso, kodwa uVasya akanamali. Le yindlela ibali lethu eliqala ngayo.

UVasya unepropati yakhe, enemilinganiselo ethile engabalulekanga kuye - uLomonosov wayehlala kwindlu engummelwane, ukuphakama kwesilingi ziimitha ezisixhenxe ezinesiqingatha, kukho isiseko seziqhamo kunye nemifuno kunye nemarike yeSadovod. kufuphi, unokuhamba kwi-Aeroexpress, phantsi kwendlu kukho isiseko esinobude bemitha eyi-1, kukho i-attic ngaphezu kwendlu elungele ukubonwa kweenkwenkwezi. UVasya uyaqonda ukuba ezi mpawu zonyusa ixabiso lendlu yakhe, kodwa kungekhona yena. Kwaye uthatha isigqibo sokuthenga indlu kaPetya kwaye athengise indlu yakhe. Kodwa ukuthengisa ngokuchanekileyo ukuze kuthengwe indlu kaPetya, hayi nje. Kulwimi lwee-realtors, oku kubizwa ngokuba "Enye indlela ikhethiwe."

Ngoku makhe sijonge le meko kwicala likaPetya. Inyani kukuba uPetya akanamdla wokuhlala ekunciphiseni imali, uthengisa indlu ukuze azithengele indlu kwisixeko esineshumi elinanye saseValinor, kodwa akakajongi ukuba yeyiphi. Kulwimi lwabarhwebi, oku kubizwa ngokuba “kukusebenza ngenye indlela.”

Ii-elves ezimbini ze-Middle-earth, i-Maglor kunye ne-Maedhros, zifanelekile (kwi-criteria yePetya) indawo yokuhlala kwisixeko saseValinor, esithengiswa ngokukhawuleza, njengoko beza kukhonza uMelkor. Ngolwimi lwee-realtors oku kubizwa ngokuba "Intengiso yasimahla".

Ngoko, uVasya ufumana umxhasi, uSeryozha. Ngoku, uPetya ufumana iindlela ezimbini ezifanelekileyo kuye kwisixeko saseValinor. Sesizakugqibezela isivumelwano. Masicinge ngokulula ukuba akukho namnye kwabachaphazelekayo kwintengiselwano osebenzisa imali-mboleko kwaye akanabantwana njengabanini zabelo. Ke ngoko, ezi zenzo zilandelayo kufuneka zenziwe ngoku:
1. USeryozha unika imali kuPetya.
2. UVasya unika indlu yakhe kuSeryozha.
3. UPetya unika indawo yakhe yokuhlala kuVasya.
4. Ngaba i-Maglor okanye i-Maedhros idlulisela indawo yabo yokuhlala eValinor ukuya ePeta kwaye bafumane imali kaSeryozha.
5. UMalkor noMaedhros baya eMordor ukuya kukhonza eMelkor.

Kuya kuba kuhle ukuhambisa iskripthi esilandelayo kwi-Rosreestr ukuze siqhutywe:

QALISA INTENZI
Nika indawo kaVasya eSeryozha.
Nika indawo kaPetya kuVasya.
qalisa
Nika indawo yokuhlala yaseMalkor kuPetya
Nika imali kaSeryozha eMalkor
IF_ERROR:
Nika indawo yokuhlala kaMaedhros kuPetya
Nika imali kaSeryozha kuMaedhros
isiphelo
YENZA INTENSELELO

Esi sisikripthi sentengiselwano esenziwe lula esinenye indlela, ethatha ukuba zonke iiflethi zinomnini omnye omdala (kwaye onako), ukuba amaxabiso abo ayalingana, kwaye iirealtors (ukuba zikhona) ziyahlawulwa nokuba zithini na izigaba zentengiselwano.

Nangona kunjalo, iRosreestr ayixhasi ukuthengiselana. Zonke izenzo ziya kwenziwa ngokulandelelana kwaye ngokuzimeleyo, enye emva kwenye, ngaphandle kokubuyisela umva ukuthengiselana ngokubanzi ukuba enye yazo iyasilela. Ubuninzi obunokufezekiswa - kunikwe ukuba i-Rosreestr kunye ne-MFC ayisebenzi ngokudluliselwa kwemali - kukubeka imali kwibhokisi yediphozithi ekhuselekileyo, kunye neemeko zokufikelela kuyo nguVasya, uPetya, uSeryozha (ukuba akukho ntengiselwano ibhalisiwe kuzo zonke), kunye nabanye abadlali, ekuboniseni izivumelwano ezibhaliswe nguRosreestr. (Kwaye ngendlela, iibhanki aziqinisekisi ngokuzimeleyo ukunyaniseka kwezivumelwano, oko kukuthi, zithembela ukunyaniseka kwamaphepha amaqela kwi-transaction).

Ngaphandle kweengozi zokungagqitywanga ngokupheleleyo kwentengiselwano, enye ingxaki kukuba ukuba abanye abathathi-nxaxheba banokungena kwikhaya labo elitsha ngaphandle kokulinda ukubhaliswa ngokupheleleyo (hello, umba wokuhlawulwa ngaphantsi kweebhilidi ezisetyenziswayo!), Emva koko uMaglor noMaedhros abayi kuhamba ngokukhawuleza khonza uMelkor, kwaye mhlawumbi uMaglor akayi kukwazi ukuba nje akayi kuba nexesha lokubamba iiSilmarils ezandleni zakhe. Ukuthengiselana kwe-real estate kwenziwa ngokulandelelana, kwaye ukuphunyezwa kwentengiselwano nganye kuya kuthatha ubuncinane iintsuku ze-9 zokusebenza.

Ukongeza, i-Rosreestr ayixhasi ukunyanzeliswa kwezindlu ezakhiwe phantsi kwe-DDU, kodwa inokuthi, oku kuyinyathelo lokuqala ngokumalunga nekamva elilula.

Ngoku makhe siqhubele phambili kwiintsilelo kunye neminqweno yam malunga neDBMS

1) Eyokuqala kukungabikho kwenkqubo yokulawula inguqulelo. Ukuba kwicala leDelphi ndiphuhlisa kwibhokisi yam yesanti, kwaye utshintsho endilwenzayo aluyi kubonakala kwabanye abadwelisi beprogram de bazinikele, oku akunjalo ngeDBMS. Kwaye nokuba ndithenjwa ngokupheleleyo (ubuncinci ngaphakathi kwendawo eyimfuneko kumsebenzi owabelwe mna) ukufikelela kwi-database yokulwa, kwaye oku kwenzeka, andinakukwazi ukuphuhlisa kuyo. Ngelixa ndilungisa ingxaki, yonke into iya kuwa. YiStone Age enjani le??? Yenza ibhokisi yesanti kubaphuhlisi.

2) Okwesibini kukunqongophala kweetheyibhile ezichazwe kwangaphambili ezisemgangathweni ezichaza ihlabathi lokwenyani. Inkampani nganye endiyisebenzeleyo inefomathi yayo yetafile echaza amagama (ngesiRashiya kunye (ubuncinci) nesiNgesi, kwiimeko ezahlukeneyo zesiRashiya) zeenyanga ezilishumi elinesibini!

I-3) Okwesithathu - kwaye apha ndiya kusebenzisa isigama se-Oracle - akukho ndlela yokubiza i-Faka okanye i-Update script elula esebenzisa ukuBuyisa, ngendlela efanayo esiyibiza ngokuthi Khetha. Mhlawumbi ezi ayizizo iingxaki ze-Oracle, kodwa iingxaki kwi-interface yeDelphi + Oracle.

4) Okwesine - isidingo sokunika amagunya kwiinkqubo kunye nemisebenzi endiyidalayo apho ndingafuni ukwenza oku. Andifuni ukuseta kwaye emva koko nditshintshe iimvume zomsebenzisi kwiinkqubo kunye nemisebenzi. Kutheni, ukuba andizange ndibhale ngokucacileyo iGranti, ngaba inkqubo ngokwayo ayikwazi ukujonga izinto ezibandakanyekayo, kwaye, ngokuhambelana namalungelo okusebenza kunye nabo, ukunika okanye kungekhona abasebenzisi abathile ilungelo lokubiza umsebenzi? Ndikulungele ukubhala igama elinye elingundoqo kule nto xa ubhala imisebenzi kunye neenkqubo. Okanye, nokuba ngcono, vumela umsebenzisi ukuba aqalise ukubulawa, kwaye ukuba isebe le-algorithm limkhokelela kwisicelo apho umsebenzisi akanalo amalungelo, uya kuyilahla ngempazamo.

umthombo: www.habr.com