Query and get it with function

Ask the community
,
1

Hi,
I need to get multiple fields (numbers) on dataset with different filters.
I would like to call dataset into function and interact with them. Can you tell me why my code isn’t working please ? :

$w . onReady ( function () {
let a = lundi ();
let b = mardi ();
console . log ( a );
console . log ( b );
});

function lundi () {

myUser . getEmail () 
    . then (( email ) => { 
        userEmail  =  email ;  // "user@something.com" 
        console . log ( userEmail ); 

        **var**  dt  =  $w ( '#datePicker1' ). value ; 
        **var**  currentWeekDay  =  dt . getDay (); 
        **var**  lessDays  =  currentWeekDay  ==  0  ?  6  :  currentWeekDay  -  1 ; 
        **var**  wkStart  =  **new**  Date ( **new**  Date ( dt ). setDate ( dt . getDate () -  lessDays )); 
        **var**  wkEnd  =  **new**  Date ( **new**  Date ( wkStart ). setDate ( wkStart . getDate () +  7 )); 
        wixData . query ( "planning" ) 
            . between ( "date" ,  wkStart ,  wkEnd ) 
            . isNotEmpty ( "lundi" ) 
            . eq ( "title" ,  email ) 
            . find () 
            . then (( results ) => { 
                
                **if**  ( results . items . length  >  0 ) { 
                    **let**  firstItems  =  results . items [ 0 ]; 
                     **let**  s  =  firstItems . countNumber ; 
                     **return**  s 
                }  **else**  { 
                    **return**  0 ; 
                }  
                
                 
            }); 
             
    });

}

function mardi () {
myUser . getEmail ()
. then (( email ) => {
userEmail = email ; // “user@something.com”
console . log ( userEmail );

        **var**  dt  =  $w ( '#datePicker1' ). value ; 
        **var**  currentWeekDay  =  dt . getDay (); 
        **var**  lessDays  =  currentWeekDay  ==  0  ?  6  :  currentWeekDay  -  1 ; 
        **var**  wkStart  =  **new**  Date ( **new**  Date ( dt ). setDate ( dt . getDate () -  lessDays )); 
        **var**  wkEnd  =  **new**  Date ( **new**  Date ( wkStart ). setDate ( wkStart . getDate () +  7 )); 
        wixData . query ( "planning" ) 
            . between ( "date" ,  wkStart ,  wkEnd ) 
            . isNotEmpty ( "mardi" ) 
            . eq ( "title" ,  email ) 
            . find () 
            . then (( results ) => { 
                **if**  ( results . items . length  >  0 ) { 
                    **let**  firstItems  =  results . items [ 0 ]; 
                    **let**  s  =  firstItems . countNumber ; 
                    **return**  s ; 
                }  **else**  { 
                    **return**  0 ; 
                } 
            }); 
    });

}

2

What is not working? The console.log’s in $w.onReady? Or something else?

3

console.log(a) for (function) lundi() return « undefined» or firstItems.countNumber return « 1 ».
i would like to get item defined on «let s =»

4

Try this:

$w.onReady(async function () { 
let a = await lundi();
let b = await mardi();
console.log(a);
console.log(b);
});

I put the things you have to add in orange.

5

i tried but not working.
I put an console.log(s) and i’ve got “1” on test and undefined on return function
i don’t understand why…

1909×266 41.3 KB

695×608 48.7 KB