Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function update_STAR()
- {
- var tran_no = $("#dd_starlist :selected").text();
- var no = (tran_no.length)/10;
- unattachSTARs(no).then(update_AI_starLists());
- }
- function unattachSTARs(no)
- {
- var promises = [];
- var tran_no = $("#dd_starlist :selected").text();
- for(var i=0; i < no; i++)
- {
- stars[i] = tran_no.substring((i*10),(i*10)+10);
- var url1 = "https://XYZ.quickbase.com/db/bgttp2a33?act=API_DoQuery&query={6.EX." + stars[i] + "}&clist=3.6.101.44";
- promises.push($.get(url1).then(function(data){
- var rid = $("record_id_",data).text();
- var url2 = "https://XYZ.quickbase.com/db/bgttp2a33?act=API_EditRecord&rid=" + rid + "&_fid_44=''";
- return $.post(url2)
- }));
- }
- return $.when.apply($.promises);
- }
- function update_AI_starLists()
- {
- var timestamp = new Date().getTime();
- var fvalue1 =""; var fvalue2 =""; var trans; var all_stars= "";
- var url1 = "https://XYZ.quickbase.com/db/bgttp2a33?act=API_DoQuery&query={44.EX."+ kRid + "}&clist=6.14&rand=" +timestamp;
- return ($.get(url1).then(function(xml)
- {
- $("record",xml).each(function()
- {
- all_stars+= $(this).find('transaction_number').text() + "<br>";
- if($(this).find('latest_star_status').text().toUpperCase() == "CLOSED")
- fvalue1+= $(this).find('transaction_number').text() + "<br>";
- else
- fvalue2+= $(this).find('transaction_number').text() + "<br>";
- });
- var url2="https://XYZ.quickbase.com/db/bgttp2a24?act=API_EditRecord&rid="+kRid+"&_fid_124="+all_stars+"&_fid_126="+fvalue2+"&_fid_125="+fvalue1+"&rand="+timestamp;
- return $.post(url2)
- }).then(update_dropdown()));
- }
- function update_dropdown()
- {
- var timestamp=new Date().getTime();
- var url1='https://XYZ.quickbase.com/db/bgttp2a33?act=API_DoQuery&query={44.EX.'+kRid+'}&clist="0.6.14.44"&includeRids=1&rand='+timestamp;
- var x = document.getElementById("dd_starlist");
- $("#dd_starlist").html("");
- $.get(url1,function(xml){
- $("record",xml).each(function()
- {
- var option = document.createElement("option");
- option.text = $(this).find('transaction_number').text();
- option.value = $(this).find('transaction_number').text();
- x.add(option);
- });
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement