Dažādas piezīmes

hQuse: I love XQuery...

Publicēts: 16:27:39 09/17/09
Autors: hQuse

let $nr := 1 let $c := count(//ApplManipDOT) return if ($nr <= $c) then if(//ApplManipDOT[$nr]/DISCOUNT_TYPE=0) then number(round-half-to-even(((//ApplManipDOT[$nr]/PRICE * //ApplManipDOT[$nr]/MANIPCOUNT - //ApplManipDOT[$nr]/APPLMANIP_COMPENSATION) - //ApplManipDOT[$nr]/DISCOUNT) div (//ApplManipDOT[$nr]/VAT_SUM + 1), 2)) else number(round-half-to-even(((//ApplManipDOT[$nr]/PRICE * //ApplManipDOT[$nr]/MANIPCOUNT - //ApplManipDOT[$nr]/APPLMANIP_COMPENSATION) - (//ApplManipDOT[$nr]/PRICE * //ApplManipDOT[$nr]/MANIPCOUNT - //ApplManipDOT[$nr]/APPLMANIP_COMPENSATION) * //ApplManipDOT[$nr]/DISCOUNT div 100) div (//ApplManipDOT[$nr]/VAT_SUM + 1), 2)) else ''