module namespace page = 'http://basex.org/examples/web-page';

declare %rest:path("/view/{$link}")
function page:listarProduto($link){
  <smartphones>
  {
      for $worten in db:open("worten")//smartphone,
          $fnac in db:open("fnac")//smartphone
                           where $worten/pageUrl[contains(.,$link)]
                           or $fnac/pageUrl[contains(.,$link)]
                           let $loja:= if($worten/pageUrl[contains(.,$link)]) then $worten else $fnac
                           let $pageUrl:= $loja/pageUrl
                           group by $pageUrl
                           return
                           <smartphone>
                           {$loja/name}
                           {$loja/brand}
                           {$loja/storage}
                           {$loja/color}
                           <store name="{$loja/store/text()}">
                           {$loja/pageUrl}
                           {$loja//current}
                           {$loja//old}
                           </store>
                           {
                           (: Vai buscar os preços da outra loja :)
                           let $outraLoja := if($loja = $worten) then $fnac else ($worten)
                           for $preco in $outraLoja
                           where lower-case($preco/name)=lower-case($loja/name) and lower-case($preco/brand)=lower-case($loja/brand) and lower-case($preco/storage)=lower-case($loja/storage) and lower-case($preco/color)=lower-case($loja/color)
                             return
                             <store name="{$preco/store/text()}">
                             {$preco//pageUrl}
                             {$preco//current}
                             {$preco//old}
                             </store>
                           }
                           </smartphone>
  }
  </smartphones>
};