Удалены все документы : Супермаг Плюс (Супермаг 2000)

--восстанавливаем шапки приходных накладных

insert into supermag.smdocuments
(doctype,id,bornin,createdat,docstate,isclosed,opcode,userop,clientindex,locationfrom,locationto,
currencytype,currencyrate,currencymultorder,totalsum,totalsumcur,priceroundmode,isroubles
)
select f.saletype,f.saleid,'2FB029D83DE04A45A2F82A8B724BAC1C',f.saledate, 3,0,f.saleop,
decode(f.saleop,0,f.saleuserop,''),f.saleclientindex,'',f.salelocationto,1,1,0,sum(f.salesum),sum(f.salesum),3,1
from maximizator.backup_ffmaprep f,supermag.smdocuments h
where f.saleid=h.id(+)  and f.saletype=h.doctype(+)
and h.id is null
group by f.rectype,f.saletype,f.saleid,f.saledate,f.saleop,
f.saleuserop,f.saleclientindex,f.salelocationto
having f.rectype=1 and f.saletype='WI' 
order by f.saledate,f.saleid;

commit;

--восстанавливаем шапки расходных накладных

insert into supermag.smdocuments
(doctype,id,bornin,createdat,docstate,isclosed,opcode,userop,clientindex,locationfrom,locationto,
currencytype,currencyrate,currencymultorder,totalsum,totalsumcur,priceroundmode,isroubles
)
select f.saletype,f.saleid,'2FB029D83DE04A45A2F82A8B724BAC1C',f.saledate, 3,0,f.saleop,
decode(decode(f.saleop,8,'',f.saleuserop),-2,107),f.saleclientindex,f.salelocationfrom,'',1,1,0,sum(f.salesum),sum(f.salesum),3,1
from maximizator.backup_ffmaprep f,supermag.smdocuments h
where f.saleid=h.id(+)  and f.saletype=h.doctype(+)
and h.id is null
group by f.rectype,f.saletype,f.saleid,f.saledate,f.saleop,
f.saleuserop,f.saleclientindex,f.salelocationfrom
having f.rectype=1 and f.saletype='WO' 
order by f.saledate,f.saleid;

commit;

--восстанавливаем спецификации приходных накладных

insert into supermag.smspec
(doctype,docid,specitem,displayitem,article,quantity,expquantity,itemprice,totalprice,itempricenotax,
totalpricenotax,
itempricecur,totalpricecur,causetype,causeid,causespecitem
)
select f.saletype,f.saleid,f.salespecitem,f.salespecitem,f.article,f.saleq,0,
round(f.salesum/f.saleq,2),f.salesum,round(f.salesum/f.saleq,2),f.salesum,round(f.salesum/f.saleq,2),
f.salesum,'','',''
from maximizator.backup_ffmaprep f
where f.saletype='WI' and f.saleid in
(
select distinct b.id
from 
supermag.smdocuments b,
supermag.smspec n
where 
b.doctype=n.doctype(+)
and b.id=n.docid(+)
and b.doctype='WI'
and n.doctype is null
)
order by f.saleid,f.salespecitem;

commit;

--восстанавливаем спецификации расходных накладных

insert into supermag.smspec
(doctype,docid,specitem,displayitem,article,quantity,expquantity,itemprice,totalprice,itempricenotax,
totalpricenotax,
itempricecur,totalpricecur,causetype,causeid,causespecitem
)
select f.saletype,f.saleid,f.salespecitem,f.salespecitem,f.article,f.saleq,0,
round(f.salesum/f.saleq,2),f.salesum,round(f.salesum/f.saleq,2),f.salesum,round(f.salesum/f.saleq,2),
f.salesum,f.incometype,f.incomeid,f.incomespecitem

from maximizator.backup_ffmaprep f
where f.saletype='WO' and f.rectype=1 and f.saleid in
(
select distinct b.id
from 
supermag.smdocuments b,
supermag.smspec n
where 
b.doctype=n.doctype(+)
and b.id=n.docid(+)
and b.doctype='WO'
and n.doctype is null
)
order by f.saleid,f.salespecitem;

commit;

--налоги по приходам

insert into supermag.smspectax
(doctype,docid,specitem,taxid,taxrate,taxsum)
select f.saletype,f.saleid,f.salespecitem,1,0,0
from maximizator.backup_ffmaprep f
where f.saletype='WI' and f.rectype=1 and f.saleid in
(
select distinct b.id
from 
supermag.smdocuments b,
supermag.smspectax n
where 
b.doctype=n.doctype(+)
and b.id=n.docid(+)
and b.doctype='WI'
and n.doctype is null
)
order by f.saleid,f.salespecitem;
commit;

--налоги по расходам

insert into supermag.smspectax
(doctype,docid,specitem,taxid,taxrate,taxsum)
select f.saletype,f.saleid,f.salespecitem,1,0,0
from maximizator.backup_ffmaprep f
where f.saletype='WO' and f.rectype=1 and f.saleid in
(
select distinct b.id
from 
supermag.smdocuments b,
supermag.smspectax n
where 
b.doctype=n.doctype(+)
and b.id=n.docid(+)
and b.doctype='WO'
and n.doctype is null
)
order by f.saleid,f.salespecitem;

commit;