php - calculate two consecutive days with XYZ values within a week in a month -

-

i have database in mysql , have table named user_daily_data_recorded. have following columns

  1. date_of_record
  2. steps_walked
  3. member_id

the table contains data of each , every date , populated regularly. want send congratulation mail user/members who have walked 15000 steps @ least 2 days per week on month (say in month february user1 has walked 15000 on monday , thursday receive congratulatory mail). should do? let me know if question not clear. file containing script executed once per month. need find 2 days 15000 steps per week in a particular month.

if want know how select users should e-mail today, help:

select member_id   user_daily_data_recorded uddr        # selects users created record today.        join (select distinct ( member_id ) id                user_daily_data_recorded               date_of_record = curdate()) todays_users          on todays_users.id = uddr.id        # selects users below 15000 steps yesterday.        join (select distinct ( member_id ) id                user_daily_data_recorded               sum(steps_walked) < 15000                     , date_of_record < curdate()              group  member_id) yesterday_below_mark_users          on yesterday_below_mark_users.id = uddr.id # selects members on 15000 steps today.  sum(uddr.steps_walked) >= 15000 group  member_id

i didn't tested it, may steps :)

edit: steps on mark week:

select distinct( member_id )   user_daily_data_recorded uddr        join (select member_id             id,                     count(date_of_record) dates_over_mark                user_daily_data_recorded               month(date_of_record) = month(curdate())                     , steps_walked >= 15000              group  week(date_of_record)              having dates_over_mark >= 2) very_active_members          on very_active_members.id = uddr.members_id

Comments

Post a Comment

Popular posts from this blog

java - activate/deactivate sonar maven plugin by profile? -

-
i use sonar plugin executes if activated in maven profile. sonar runs on every compile. the problem build fail other team members not have sonar application installed locally. pom.xml checked in team members same copy including sonar configuration, don't want them modify purpose of disabling sonar (they might inadvertently check modified copy in). please advise how configure maven (.m2/settings.xml) and/or pom.xml sonar feature can enabled/disabled local profile. here sonar configuration in each project's pom.xml: <plugin> <groupid>org.codehaus.mojo</groupid> <artifactid>sonar-maven-plugin</artifactid> <version>1.0</version> <executions> <execution> <id>make-sonar</id> <phase>compile</phase> <goals> <goal>sonar</goal> </goals> </execution> </executions> ...
Read more

python - TypeError: can only concatenate tuple (not "float") to tuple -

-
i'm new python, question might easy, anyway, patience: as trying call newton-raphson method calculate implied volatility in black-scholes formula call/put option pricing, first thing is, newton method in scipy.optimize seems calculate function's zeros, in black-scholes formula, want function's value option price, not zero. (i'm new here programming, i'm not sure techniques.) should write function things like: def f(sigma, price): return bsformula(s0,k,r,t,q,sigma) - price then, while calling newton method, takes args=() 1 parameter in function, write this: value = newton(bsprice2, 0.5, args=price) but error message: file "bs.py", line 36, in bsimpvol value = newton(bsprice2, 0.5, args=float(price)) file "/usr/lib/python2.7/dist-packages/scipy/optimize/zeros.py", line 143, in newton q0 = func(*((p0,) + args)) typeerror: can concatenate tuple (not "float") tuple could tell me why that? how fix it? apprecia...
Read more

java - What is the difference between String. and String.this. ? -

-
this question has answer here: meaning of .this , .class in java 2 answers i'll straight point. im still learning bit of syntax , want know difference between code is code a: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.valueof(i))); } } please ignore fact i undeclared, not lost. code b: public class buttonz extends jbutton{ public buttonz(){ settext(new string(string.this.charat(i))); } } what don't yet understand difference in typing string.this , string. i under assumption when use dot operator on class accessing it's static methods(and/or variables if they're not hidden). i have studied little bit , have concluded when using string. accessing string static methods.. when using string.this. i'm accessing methods class buttonz extendi...
Read more