hi,
Shown below is the PHP code to obtain the value for each date in the
corresponding date range.And with I''ve attached the MYSQL Database
Table.Please Have a look.I''ve tried to convert this code to rails but
not yet succeeded.Please let me know if you can do....
<?php
$con=mysql_connect("localhost","root","");
mysql_select_db("dgrid_development",$con);
$sql=mysql_query("select * from events");
while($row=mysql_fetch_array($sql))
{
$date_array = date_range($row["when"],$row["to"]);
$txt=''(''.$row["what"].''-''.$row["color"].'')'';
$arrayMixed[]= array_fill_keys($date_array, $txt);
}
function date_range($sd,$ed)
{
$tmp = array();
$sdu = strtotime($sd);
$edu = strtotime($ed);
while ($sdu <= $edu)
{
$tmp[] = date(''Y-m-d'',$sdu);
$sdu = strtotime(''+1 day'',$sdu);
}
return ($tmp);
}
foreach($arrayMixed as $final)
{
foreach($final as $key=>$value)
{
$group[$key].=$value;
}
}
print''<pre>'';
print_r($group);
print ''</pre>'';
?>
Thanks in Advance.
cheers,
Shankar.
Attachments:
http://www.ruby-forum.com/attachment/3262/events.sql
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Time to learn more rails and ruby my friend. We''re not going to write your code for you. Have an attempt and then ask questions about that in a succinct and clear manner. Blog: http://random8.zenunit.com/ Learn rails: http://sensei.zenunit.com/ On 05/02/2009, at 2:09 PM, Shankar Ganesh <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org > wrote:> > hi, > Shown below is the PHP code to obtain the value for each date in the > corresponding date range.And with I''ve attached the MYSQL Database > Table.Please Have a look.I''ve tried to convert this code to rails but > not yet succeeded.Please let me know if you can do.... > > <?php > $con=mysql_connect("localhost","root",""); > mysql_select_db("dgrid_development",$con); > $sql=mysql_query("select * from events"); > > while($row=mysql_fetch_array($sql)) > { > $date_array = date_range($row["when"],$row["to"]); > $txt=''(''.$row["what"].''-''.$row["color"].'')''; > $arrayMixed[]= array_fill_keys($date_array, $txt); > } > > function date_range($sd,$ed) > { > $tmp = array(); > $sdu = strtotime($sd); > $edu = strtotime($ed); > while ($sdu <= $edu) > { > $tmp[] = date(''Y-m-d'',$sdu); > $sdu = strtotime(''+1 day'',$sdu); > } > return ($tmp); > } > > foreach($arrayMixed as $final) > { > foreach($final as $key=>$value) > { > $group[$key].=$value; > } > } > > print''<pre>''; > print_r($group); > print ''</pre>''; > ?> > > Thanks in Advance. > > cheers, > Shankar. > > Attachments: > http://www.ruby-forum.com/attachment/3262/events.sql > > -- > Posted via http://www.ruby-forum.com/. > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi Julian,
Here is what the code I tried
<% result=[]%>
<%date=[] %>
## An array from database with select all query
<% @eventall.each do |test| %>
<%i1= test.when%>
<%i2 =test.to%>
<%i3=i1.to_s.gsub(''-'','''') %>
<%i4=i2.to_s.gsub(''-'','''')%>
<%span =i3..i4%>
<%date=span.each { |x| puts x }%>
<%date.each_with_index do |value, key|%>
<% result.push(value)%>
<%end%>
<%end%>
## An array which contains ''color'' and
''what'' value concatinated
<% wattt = [] %>
<% for watl in @eventall%>
<% wattt << watl.what.concat(watl.color)%>
<%end%>
## This is the code i did to combine both array to fill the date between
certain range to corresponding value
<%hash = {}%>
<%result.each { |d| hash[d] = [] }%>
<%result.each_with_index { |x,i| hash[x] << wattt[i] }%>
<%hash.each_key { |key| hash[key] = hash[key].join(''-'')
}%>
<% hash.each do |d,v| %>
<%= d%><%= v%><br>
<%end%>
Hope I explained well.Tell me if I''m not clear.
Thanks,
Shankar.
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Ok how does it not work? Blog: http://random8.zenunit.com/ Learn rails: http://sensei.zenunit.com/ On 05/02/2009, at 3:27 PM, Shankar Ganesh <rails-mailing-list-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org > wrote:> > Hi Julian, > > Here is what the code I tried > > <% result=[]%> > <%date=[] %> > > ## An array from database with select all query > > <% @eventall.each do |test| %> > <%i1= test.when%> > <%i2 =test.to%> > <%i3=i1.to_s.gsub(''-'','''') %> > <%i4=i2.to_s.gsub(''-'','''')%> > <%span =i3..i4%> > <%date=span.each { |x| puts x }%> > <%date.each_with_index do |value, key|%> > <% result.push(value)%> > <%end%> > > <%end%> > > ## An array which contains ''color'' and ''what'' value concatinated > > <% wattt = [] %> > <% for watl in @eventall%> > <% wattt << watl.what.concat(watl.color)%> > <%end%> > > ## This is the code i did to combine both array to fill the date > between > certain range to corresponding value > > <%hash = {}%> > <%result.each { |d| hash[d] = [] }%> > <%result.each_with_index { |x,i| hash[x] << wattt[i] }%> > <%hash.each_key { |key| hash[key] = hash[key].join(''-'') }%> > <% hash.each do |d,v| %> > <%= d%><%= v%><br> > <%end%> > > Hope I explained well.Tell me if I''m not clear. > > Thanks, > Shankar. > -- > Posted via http://www.ruby-forum.com/. > > >--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
The value for the corresponding date range is not inserting appropriately. I shall give an example here, consider : for ''id'' as 1, date of ''when'' as 2009-02-01,date of ''to'' 2009-02-15,''what'' as test date between days ! and ''color'' as #DD5511 for ''id'' as 2, date of ''when'' as 2009-02-02,date of ''to'' 2009-02-14,''what'' as test again and ''color'' as #22AA99 for the above values in the database I''m getting output as, 20090213- 20090202test again#22AA99#22AA99- 20090214- 20090203test#DD5511#DD5511- 20090215 20090204tests#CBC2FE#CBC2FE--- 20090205- 20090206- 20090207- 20090208- 20090209- 20090210- 20090211- 20090212- 20090201test date between days !#DD5511#DD5511 you can see some dates are left blank.I need the values to be filled appropriately. Thanks in advance. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---