Hello guys, I don’t know why this function doesn’t work.Should send an email to all the recipients collected in a database on button click, but send only to the first one.
export function upload() {
$w("#uploadButton1").startUpload()
.then((uploadedFile) => {
return uploadedFile;
})
}
export async function rep1() {
let uploadedFile = await upload();
const numberOfItems = $w('#dataset1').getTotalCount();
$w('#dataset1').getItems(0, numberOfItems).then(results => {
let resultLength = results.length;
let values = results.items;
let secondItem = values[0];
const today = new Date();
let toInsert6 = {
"operatore": getOperator(),
"azione": "Invio nuova campagna email [Lista 1] ",
"contenuto": numberOfItems + " email inviate [" + id + "]",
"ora": t,
};
wixData.insert("logsistema", toInsert6)
.then((results32) => {
let item32 = results32; //see item below
})
.catch((err) => {
let errorMsg = err;
});
let toInsert9 = {
"nome": $w("#input8").value,
"oggetto": $w("#input5").value,
"invii": numberOfItems,
"idcampagna": id,
"sku": $w("#input9").value,
"interazioni": 0,
"perc": 0,
};
wixData.insert("camlista", toInsert9)
.then((results3) => {
let item3 = results3; //see item below
})
.catch((err) => {
let errorMsg = err;
});
console.log(values);
results.items.forEach(item => {
let language = item.language;
if (language === "EN") {
try {
console.log("en");
sendEnglish(body, recipient, descrizione2, prezzo2, nome2, link, scadenza2, imageUrl, sku2)
.then(response => console.log(""));
wixData.insert("caminv", toInsert13)
.then((results4) => {
let item4 = results4; //see item below
})
.catch((err) => {
let errorMsg = err;
});
} catch (err) {}
} else {
try {
sendEmail2(body, recipient, descrizione, prezzo, nome, link, scadenza, imageUrl, sku)
.then(response => console.log(""));
console.log("it");
wixData.insert("caminv", toInsert12)
.then((results4) => {
let item4 = results4; //see item below
})
.catch((err) => {
let errorMsg = err;
});
} catch (err) {}
}
let imageUrl = "https://static.wixstatic.com/media/" + uploadedFile.url.split("/")[3];
const r = String(parseFloat(Math.floor(Math.random() * 100000000000000000) + 1000000000000));
const link = `https://laram.it/campagne/${r}`;
const body = ``;
const data = $w("#datePicker1").value;
const recipient = item.email;
const descrizione = `${$w("#textBox1").value}`;
const nome = ` ${$w("#input5").value}`;
const prezzo = ` ${$w("#input6").value}`;
const scadenza = `${date(data)}`;
const sku = `${$w("#input9").value}`;
let toInsert13 = {
"email": item.email,
"token": r,
"visto": false,
"idcampagna": id,
"immagine": uploadedFile.url,
"descrizione": descrizione,
"nome": nome,
"sku": sku,
"prezzo": prezzo,
"scadenza": `${date(data)}`,
"sca": data,
"language": "EN",
};
let toInsert12 = {
"email": item.email,
"token": r,
"visto": false,
"idcampagna": id,
"immagine": uploadedFile.url,
"descrizione": descrizione,
"nome": nome,
"sku": sku,
"prezzo": prezzo,
"scadenza": `${date(data)}`,
"sca": data,
"language": "IT",
};
const data2 = $w("#datePicker2").value;
const descrizione2 = `${$w("#textBox2").value}`;
const nome2 = ` ${$w("#input11").value}`;
const prezzo2 = ` ${$w("#input10").value}`;
const scadenza2 = `${date(data)}`;
const sku2 = `${$w("#input12").value}`;
})
})
}
export async function button116_click(event) {
if ($w("#slider1").value === 100) {
$w("#text45").hide();
if ($w("#repeater1").hidden === false) {
await rep1();
setTimeout(function () {
$w("#text45").show();
$w("#text45").text = "Spedito con successo";
wixWindow.openLightbox("funziona");
$w("#progressBar1").value === 100;
setTimeout(function () {
setTimeout(function () {
wixLocation.to(wixLocation.url);
}, 2000);
}, 4000);
}, 4000);
} else if ($w("#repeater2").hidden === false) {
await rep2();
setTimeout(function () {
$w("#text45").show();
$w("#text45").text = "Spedito con successo";
wixWindow.openLightbox("funziona");
$w("#progressBar1").value === 100;
setTimeout(function () {
setTimeout(function () {
wixLocation.to(wixLocation.url);
}, 2000);
}, 4000);
}, 4000);
}
} else {
$w("#text45").show();
$w("#text45").text = "Completa lo slider"
}
}