1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47
|
static RechParamsUserByIdParams(value) {
var promises = [];
for (var i = 0; i < value[3].length; i++)
{
let numb = value[3][i];
console.error('Valeur de Numb : ', numb)
promises.push(Users.checkValue(numb, value[0]));
}
Promise.all(promises)
.then(function(data){
console.log('D A T A : ', data)
value.push(data);
return value;
}).catch((e) => { console.error(e); });
}
static checkValue(ParId, UsrId){
return new Promise(function(resolve, reject){
var query_str = 'SELECT * FROM usr_par WHERE usr_id = ? AND par_id = ?';
var query_var = [UsrId, ParId];
connection.query(query_str, query_var, function (err, rows) {
if (err) {
console.log(' E R R O R ')
reject(err);
}
else {
if (rows.length != 0) {
console.log(' B ')
console.log('ROWS : ', rows[0])
resolve(rows[0]);
}
else {
console.log(' C ')
var cree = { up_id: '', usr_id: UsrId, par_id: ParId, up_val: 0 }
console.log('CREE : ', cree)
resolve(cree);
}
}
});
});
} |