Ufdjrw

I am trying to add offline capability to my web app. It has a autocomplete function and get it's source from ajax url. Ajax response is generated after several sql queries. This is working very fine.

Now i want to mak it offline. To do that i made my Database offline using Websql(though it deprecated) and managed to sync with server.

To make it offline i need to generate the source of autocomplete from the websql.
Here is my script sample

$("#add_item").autocomplete(
source: function (request, response) 
 if (!$('#poscustomer').val()) 
 $('#add_item').val('').removeClass('ui-autocomplete-loading');
 bootbox.alert('<?=lang('
 select_above
 ');?>'
 )
 ;
 $('#add_item').focus();
 return false;
 
 var analyzed = analyze_term(request.term);
 var term = analyzed.term,
 option_id = analyzed.option_id,
 warehouse_id = $("#poswarehouse").val(),
 customer_id = $("#poscustomer").val(),
 limit = 5;
 var getProducts = new Promise(function (resolve, reject) );
 Promise.all([getProducts]).then(function (values) 
 console.log(values);
 response(values[0]);
 );
,
minLength: 1,
autoFocus: false,
delay: 250,
response: function (event, ui) 
 console.log(ui);
 if ($(this).val().length >= 16 && ui.content[0].id == 0) 
 bootbox.alert('No match found', function () 
 $('#add_item').focus();
 
 )
 ;
 $(this).val('');
 
 else if (ui.content.length == 1 && ui.content[0].id != 0) 
 ui.item = ui.content[0];
 $(this).data('ui-autocomplete')._trigger('select', 'autocompleteselect', ui);
 $(this).autocomplete('close');
 
 else if (ui.content.length == 1 && ui.content[0].id == 0) 
 bootbox.alert('no_match_found', function () 
 $('#add_item').focus();
 
 )
 ;
 $(this).val('');

 
,
 select: function (event, ui) 
 event.preventDefault();
 if (ui.item.id !== 0) 
 var row = add_invoice_item(ui.item);
 if (row)
 $(this).val('');
 else 
 bootbox.alert('no_match_found ');
 
 
);

Above code example partially working. Here i have used another promise inside the map function. in that promise one property called 'options' added to the data object and this map function return an array of data object. When I log this data in console i get the 'option' property. By in the function response() i do not get this 'option property property

How can I solve this. I have tried many ways as my knowledge but always same result. then I found a npm package Web sql promisified but could not use as i need to run it on client side. I appreciate help.