Kada dođe do ovoga, neka je bog u pomoći onome koji radi to.
Ovde su kratke beleške šta je sve potrebno odraditi prilikom ažuriranja neke stare instance....
SUPREMA UPDATE
Iz Client Apps-a pokrenuto:
Install
In App Code Update
Pušteni predmeti:
22S01002107
23S01001208
23S01003276
23S01003744
22S01001540
23S01001212
23S01001213
24S01000655
22S01002085
24S01003333
23S01001193
25S01000976
Tabele:
_dashboardgroups
_el_organization_struct (kolona vrstapredmeta)
_service (kolona kontakt_display)
Puštene procedure:
update_non_existing_dashboards
update_existing_dashboards_without_group
updrate_elastycdataver2
_el_insert_customdashboard
_setup_lang_cols
copyfronttemplatefromtemplategallery
_el_web_temp_auth
_el_aftercase
return_clientname
_el_formularfieldssave
_el_insert_custom_fields
_el_update_referent_field
_el_update_form_custom_fields_newapp
_el_create_analitycs_view_newapp
_el_create_data_view_newapp
_update_contact_custom_fields
_el_cases_basic_definition
_el_delete_row_formular
_el_update_website_settings
_el_delete_whole_formular
_el_insertfierst_delivery_address
_el_communicationnosql
_el_create_subject
_el_insertkontakt_nova
_el_debt_subject
_el_newcase_newapp
_ppnewkeycustomNEW (lokalna)
_el_postit NOVI!!!!!!!!!!!!!!!!!!!
Pozivanje procedure
updrate_elastycdataver2 - za prelazak na v2
exec _setup_lang_cols "EN", "English"
exec _setup_lang_cols "Sr", "Serbian"
exec _setup_lang_cols "Bs", "Bosnian"
exec _setup_lang_cols "De", "German"
exec _setup_lang_cols "Hr", "Hrvatski"
exec _setup_lang_cols "sl", "Slovenian"
exec _setup_lang_cols "es", "Spanish"
exec _setup_lang_cols "fr", "French"
exec _setup_lang_cols "RS ", "Srbija"
PREKOPIRATI CELU INSTANCU ZBOG FAJLOVA
Dodatne akcije:
proveriti da li su sva osnovna podesavanja popunjenja (hoce da puca ako je npr formular nekog podesavanja prazan)
aftercase da bi se u prikazu predmeta klijent prikazao
u predmetu "Prijem" skloniti "cn-field-field1" sa atributa "Zdravstveni centar"
isprazniti ceo predmet "Tip uzorka" (cursor)
proveriti print formulara izvestaj u predmetu Prijem
obrisati definicije predmeta subjekti i ulazni racuni (procedurom koju nema _el_definicija_predmeta);
kreirana nova procedura _ppnewkeycustomNEW koja drugacije izvlaci br protokola na predmetu prijem;
proveri adresu na sajtu (login);
proveriti folder assets u root folderu;
Kolega Tomislav zna o čemu se radi ovde
if (select type from sys.objects where name = "_el_post") = "U"
begin
drop table _el_post
exec ("CREATE view [dbo].[_el_post] as
select post_id as [id],
""own"" as tip,
client as subjekt,
clientcontact as contact,
opis as [text],
oddelek as oddelek,
strn as strn,
faza as phaze,
acckey as doc,
datum as datum,
userzap as poster,
0 as [file],
0 as groupid,
null as groupname,
"""" as receivername,
"""" as embedthumb,
"""" as embedlink,
post_embedhtml as embedhtml,
post_embeddescription as embeddescription,
post_emplimg as emplimg,
radnik as radnik,
status as status,
post_members as members,
post_profileimage as profileimg,
naziv as naziv,
posldog as posldog,
rokisporuke as rokisporuke,
post_numcomm as numcomm,
"""" as numlike,
closed as Closed,
clientname as subjektdisplayname,
datumspre as datchange,
"""" as checkcomplete,
post_numsales as numsales,
post_numforms as numforms,
post_numtask as numtask,
post_numterm as numterm,
post_numaktivnost as numaktivnost,
post_numveznidok as numveznidok, ident as ident
from _service")
if exists(select * from sys.columns where object_id = (select object_id from sys.tables where name = "_service") and name = "case_id")
begin
EXEC sp_rename "_service.case_id", "caseid", "COLUMN";
end
update _service set post_id = case_id, postid = case_id where isnull(postid,"") = "" and isnull(post_id,"") = ""
update _service set post_id = postid where isnull(post_id,"") = ""
update _service set postid = post_id where isnull(postid,"") = ""
exec ("alter PROCEDURE [dbo].[_el_postIt]
@userid int, @tip nvarchar(10),
@text nvarchar(2000),
@oddelek nvarchar(30),
@strn nvarchar(16), @phaze nvarchar(30),
@doc nvarchar(16), @file bigint,
@subj nvarchar(30),
@groupid int,
@embedlink nvarchar(500),
@embedthumb nvarchar(500),
@embedhtml nvarchar(2000),
@embeddescription nvarchar(2000),
@embedlinkref nvarchar(500)
AS
DECLARE
@id int,
@tip1 nvarchar(10),
@contact int,
@odgovorni int,
@subjekt nchar(30),
@subjekt1 nchar(30),
@dDatum datetime,
@oddelek1 nchar(30),
@status nvarchar(100),
@clientserv nvarchar(100),
@clientservlong nvarchar(200),
@contactserv int,
@ukljuciklijenta nchar(1)
update _service set post_id=caseid,postid=caseid where acckey=@doc
if not exists(select userid from _el_postdoc_follows where userid=@userid and acckey=@doc)
insert into _el_postdoc_follows(userid,acckey,alert,mail,userchange,tip) values (@userid,@doc,""T"",""T"",@userid,""S"")
if isnull(@odgovorni,"""")<>""""
begin
set @odgovorni=(select top 1 user_id from _userspp,_service where _userspp.naziv=_service.radnik and contacts=1 and _service.acckey=@doc)
if @odgovorni<>@userid
insert into _el_postdoc_follows(userid,acckey,alert,mail,userchange,tip) values (@odgovorni,@doc,""T"",""T"",@userid,""K"")
end")
end
