{"Type":0,"Id":"f99866dc-f410-4a25-9edb-1645542610c3","Text":"Artikels","Image":"iVBORw0KGgoAAAANSUhEUgAAACgAAAAoCAYAAACM/rhtAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAOwwAADsMBx2+oZAAAAadJREFUWEftylGKRFEIA9G3/03PgBSahGyg4Z4vtfye5/l1f9BZzRM4VdnbnkiGtO0GOar5Bqcqe9sTyZC23SBHNd/gVGVveyIZ0rYb5KjmG5yq7G1PJEPadoMc1XyDU5W97YlkSNtukKOab3Cqsrc9kQxp2w1yVPMNTlX2tieSIW27QY5qvsGpyt72RDKkbTfIUc03OFXZ255IhrTtBjmq+QanKnvbE8mQtt0gRzXf4FRlb3siGdK2G+So5hucquxtTyRD2naDHNV8g1OVve2JZEjbbpCjmm9wqrK3PZEMadsNclTzDU5V9rYnkiFtu0GOar7Bqcre9kQypG03yFHNNzhV2dueSIa07QY5qvkGpyp72xPJkLbdIEc13+BUZW97IhnSthvkqOYbnKrsbU8kQ9p2gxzVfINTlb3tiWRI226Qo5pvcKqytz2RDGnbDXJU8w1OVfa2J5IhbbtBjmq+wanK3vZEMqRtN8hRzTc4VdnbnkiGtO0GOar5Bqcqe9sTyZC23SBHNd/gVGVveyIZ0rYb5KjmG5yq7G1PJEPaxvo8z4/6vn8ibsTWg8bdlwAAAABJRU5ErkJggg==","FormXaml":"\r\n\t\r\n\t\t\r\n\t\t\r\n\t\r\n\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n","FormQuery":"if @key=''\r\n\traiserror('U dient minstens één zoeksleutel op te geven!',16,1 )\r\n\r\ndeclare @cle1Lib char(250), @cle2Lib char(250), @cle3Lib char(250)\r\n\r\nselect @cle1Lib = isnull(rtrim(valeur),'Interne code') from options where type = 'CLE1_S_N'\r\n\t\r\nif @sommeil=1\r\nselect dbo.XDESIGN_F(s_id) as modele,rtrim(@cle1Lib)+' : '+rtrim(s_cle1) as s_cle1,'Prijs excl. : '+ltrim(dbo.transform(s_prix_ht,'999 999.99')) as s_prix_ht,s_id \r\n\t\tfrom STOCK \r\n\t\twhere (s_modele like '%'+@key+'%') or (s_cle1 like '%'+@key+'%') or (s_cle2 like '%'+@key+'%') or (s_cle3 like '%'+@key+'%')\r\n\t\torder by s_modele\r\nelse\r\n\tselect dbo.XDESIGN_F(s_id) as modele,rtrim(@cle1Lib)+' : '+rtrim(s_cle1) as s_cle1,'Prijs excl. : '+ltrim(dbo.transform(s_prix_ht,'999 999.99')) as s_prix_ht,s_id \r\n\t\tfrom STOCK \r\n\t\twhere ((s_modele like '%'+@key+'%') or (s_cle1 like '%'+@key+'%') or (s_cle2 like '%'+@key+'%') or (s_cle3 like '%'+@key+'%'))\r\n\t\tand (s_sommeil=0)\r\n\t\torder by s_modele","Steps":[{"ViewCellXaml":"\r\n\r\n\r\n","ItemTappedQuery":"declare @cle1Lib char(250), @cle2Lib char(250), @cle3Lib char(250)\r\n\r\nselect @cle1Lib = isnull(rtrim(valeur),'Clé 1') from options where type = 'CLE1_S_N'\r\nselect @cle2Lib = isnull(rtrim(valeur),'Clé 2') from options where type = 'CLE2_S_N'\r\nselect @cle3Lib = isnull(rtrim(valeur),'Clé 3') from options where type = 'CLE3_S_N'\r\n \r\nselect dbo.XDESIGN_F(s_id) as modele,\r\n\trtrim(@cle1Lib)+' : '+rtrim(s_cle1) as s_cle1,\r\n\trtrim(@cle2Lib)+' : '+rtrim(s_cle2) as s_cle2,\r\n\trtrim(@cle3Lib)+' : '+rtrim(s_cle3) as s_cle3,\r\n\t'Prijs excl : '+ltrim(dbo.transform(s_prix_ht,'999 999.99')) as s_prix_ht,\r\n\t'LAP : '+ltrim(dbo.transform(s_dpa,'999 999.99')) as s_dpa,\r\n\t'Stock : '+ltrim(dbo.transform(dbo.XDISPO_DISPO(s_id,'0000000001'),'999 999')) as dispo,\r\n\ts_id\r\nfrom STOCK \r\nwhere s_id=@s_id"},{"ViewCellXaml":"\r\n\r\n\r\n\t\r\n \r\n \r\n \r\n \r\n \r\n \r\n\t\t\r\n \r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\t\r\n\r\n\r\n","ItemTappedQuery":"select top 20 convert(char(10),pieds_v.date,105) as date,\r\n\trtrim(cli.c_nom)+ ' ('+rtrim(cli.c_ville)+')' as client,\r\n\t'H : '+ltrim(dbo.transform(lignes_v.q,'999 999')) as q,\r\n\t'Totaal Excl. : '+ltrim(dbo.transform(lignes_v.TOT_NET_HT,'999 999.99')) as tot_net_ht\r\nfrom PIEDS_V inner join LIGNES_V on (pieds_v.id=lignes_v.id) and (pieds_v.journal=lignes_v.journal) and (pieds_v.piece=lignes_v.piece)\r\ninner join CLI on (pieds_v.id_cli=cli.c_id)\r\nwhere id_article=@s_id\r\norder by pieds_v.date desc"},{"ViewCellXaml":"\r\n\r\n\r\n\t\r\n\t\r\n","ItemTappedQuery":""}],"ChartCode":null,"ChartAssemblyId":null}