/*WEIGHT น้ำหนัก(กก.) */

set @date1 ='2016-10-01',@date2='2017-09-30',@x = 0;

SELECT @x :=@x+1 as no,person.pname,concat(person.fname,space(2),person.lname)as 'person_name',

person_wbc_nutrition.person_wbc_id,person_wbc_nutrition.nutrition_date,person_wbc_nutrition.body_weight as WEIGHT

from person_wbc_nutrition

INNER JOIN person_wbc on person_wbc.person_wbc_id = person_wbc_nutrition.person_wbc_id

INNER JOIN person on person.person_id = person_wbc.person_id

where person_wbc_nutrition.nutrition_date BETWEEN @date1 and @date2

and person_wbc_nutrition.body_weight is null

ORDER BY  person_wbc_nutrition.person_wbc_id,person_wbc_nutrition.nutrition_date

#---------------------------------

/*HEIGHT ส่วนสูง (ซม.)*/

set @date1 ='2016-10-01',@date2='2017-09-30',@x = 0;

SELECT @x :=@x+1 as no,person.pname,concat(person.fname,space(2),person.lname)as 'person_name',

person_wbc_nutrition.nutrition_date,person_wbc_nutrition.height as height

from person_wbc_nutrition

INNER JOIN person_wbc on person_wbc.person_wbc_id = person_wbc_nutrition.person_wbc_id

INNER JOIN person on person.person_id = person_wbc.person_id

where person_wbc_nutrition.nutrition_date BETWEEN @date1 and @date2

and person_wbc_nutrition.height is null

ORDER BY  person_wbc_nutrition.person_wbc_id,person_wbc_nutrition.nutrition_date

#-------------------------------

/*HEADCIRCUM เส้นรอบศีรษะ (ซม.) */

set @date1 ='2016-10-01',@date2='2017-09-30',@x = 0,@age = 1;

SELECT @x :=@x+1 as no,person.pname,concat(person.fname,space(2),person.lname)as 'person_name',

timestampdiff(year,person.birthdate,person_wbc_nutrition.nutrition_date)as 'child_age',

person_wbc_nutrition.nutrition_date,person_wbc_nutrition.head_circum_cm

from person_wbc_nutrition

INNER JOIN person_wbc on person_wbc.person_wbc_id = person_wbc_nutrition.person_wbc_id

INNER JOIN person on person.person_id = person_wbc.person_id

where person_wbc_nutrition.nutrition_date BETWEEN @date1 and @date2

and person_wbc_nutrition.head_circum_cm is null

and timestampdiff(year,person.birthdate,person_wbc_nutrition.nutrition_date)=@age

ORDER BY  person_wbc_nutrition.person_wbc_id,person_wbc_nutrition.nutrition_date

#-------------------