JSFiddle - React, Tailwind, and code Playground

by megaadriano

JavaScript

var arr = ["UPDATE `estoque_malhas_formulario` SET STATUS = 1,paginas=0 WHERE  licenca LIKE '${licenca}.%';",
"UPDATE `form_model_sequencial` SET sequencial = 1809 WHERE id_form_model = 496;",
"DELETE FROM form_pgc WHERE id_form LIKE '${licenca}.%';",
"DELETE FROM form_imagem WHERE id_form LIKE '${licenca}.*';",
"DELETE FROM `sequencial_formulario` WHERE id_form LIKE '${licenca}.%';"];
var strQuery = '';
var arrLic = [
'0.169.152.2.*',
'0.169.152.1.*',
'0.169.152.0.*',
'0.169.151.23.*',
'0.169.151.22.*',
'0.169.151.21.*',
'0.169.151.20.*'];
for(var i=0;i<arrLic.length;i++){
		let licenca = arrLic[i].replace(/\.\*/g,'');
    var template = "UPDATE `estoque_malhas_formulario` SET STATUS = 1,paginas=0 WHERE  licenca LIKE '${licenca}.%';\n"+
"UPDATE `form_model_sequencial` SET sequencial = 1809 WHERE id_form_model = 496;\n"+
"DELETE FROM form_pgc WHERE id_form LIKE '${licenca}.%';\n"+
"DELETE FROM form_imagem WHERE id_form LIKE '${licenca}.*';\n"+
"DELETE FROM `sequencial_formulario` WHERE id_form LIKE '${licenca}.%'\n";
    strQuery+=template.replace(/\$\{licenca\}/g,licenca);
    
}
console.log(strQuery);