Saturday 23 January 2021

Map into a hidden or display none div or bootstrap tabs or accordion collapsed doesn't work correctly leaflet

 ////////////////////// If div display NoNe


Call on div toggle event or Display block event

setInterval(function () {

    map.invalidateSize();

  }, 100);


Call on tab show or visible event

 $('#Exmaple').on('shown.bs.collapse', function (e) {

 map.invalidateSize(true);

})

Call on accordion toggle event

$("#Example").on("shown.bs.tab", "#link3", function () {

 map.invalidateSize(false);

  });


/////////// Result




Saturday 16 January 2021

Generate or Create GUID random in MS SQL Server with datetime

 /////////////////// Sql

select LEFT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)+RIGHT(REPLACE(CONVERT(VARCHAR(255),NEWID()),'-',''),10)+format(getdate(), 'yyyyMMddHHmmssfff')GUID


///////// Result


11F7A1525A049FB6145E20210116183025690

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...