cron - Rails/MySQL: Different user timezones -


question 1 - have app on shared hosting in dallas, tx...so database/web server set central time...i'm unable change this, utc off table.

my application records , displays date , time data user, every user in different time zone.

if configure app (config.time_zone = 'central time (us & canada)'), allow users select timezone, 

def user_time_zone(&block)   time.use_zone(current_user.time_zone, &block) end

will ror display returned data in timezone of user's choice? or need evaluate data , modify accordingly before displayed?

question 1.1 - have related mailers send daily/weekly/monthly reports users. if run these using cron, need schedule jobs @ different time intervals allow timezones? in other words, if 1 job contains 

when 'daily'    @dates = params[:f]['date range'] = "#{date.current} - #{date.current}"

date.current 1 hour ahead on east coast, , 3 hours behind on west , forth. (still using server timezone of central), run 1 @ 11pm (for east) , 1 @ 2am (for west)?

any , advice/assistance appreciated. thanks!

for best results, application should written such time zone of computer running on not influence data or behavior.

that means working in utc in code. example, time.now.utc instead of time.now. see this post details ror.

it best practice set server time zone utc when possible, doesn't mean should rely on in code.

regarding second question, keep in mind every time zone has own concept of "day". see this site visualization.

you should run separate job @ midnight in each time zone aligning data to. applications (such stackexchange web sites) use single time zone (often utc) users. other applications adjust data each user according own time zone. need decide appropriate application.

when scheduling jobs, determine utc time each time zone's midnight aligns to. schedule job time. sure scheduler understands utc. don't try adjust server's local time zone, or might introduce error when local time zone goes through daylight saving time transitions.

make sure not scheduled job run @ correct time, report query uses correct time zone in determining utc range should run for.

note mean 2 users different time zones reporting on same data may end producing different results - because each of "days" different period.


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

c# - Resource not found error -

i have problem accessing method on homecontroller. show code of method : [httpget] public actionresult decriptidentifiantetredirige(string login_crypter, string mdp_crypter) { string loginacrypter = _globalmanager.protegemotdepasse(login_crypter); string mdpacrypter = _globalmanager.protegemotdepasse(mdp_crypter); user userapp = new models.user(login_crypter, mdp_crypter); if (userapp.authentificationvalidee(userapp.userlogin, userapp.password)) { session["name"] = userapp.userlogin; return redirecttoaction("accueil", "home"); } else { return redirecttoaction("validerauthentification", "home"); } } then in routeconfig.cs wrote route : routes.maproute( name: "authentificationapresdecryptage", url: "{controller}/{action}/{login_crypter}/{mdp_crypter}", defaults: new...
Read more