具有时间戳记列表的事件列表，在表格式显示中按小时分组，以PHP表示 [英] List of events with a list of timestamps, grouped by hour in a tabular display, in PHP
问题描述
在重构时，我正在寻找PHP中时间表（日历）的优化算法。
While refactoring, I am looking for an optimised algorithm for a timetable (calendar) in PHP.
我有一个有时间戳列表的事件列表。这必须以表格的方式呈现。目前的代码工作，但有一个相当一些诀窍和b）非常不灵活。我正在寻找重构这件作品，寻找优化的方法上的输入。
I have a list of events which have a list of timestamps. This must be presented in a tabular way. The current code works, but has a) quite some quircks and is b) very inflexible. I am looking to refactor this piece and looking for input on optimised ways.
这里的示例，请注意标题的表承受小时。并且该小时内的时间被分组在该列中。一个事件，在一个小时内有两个时间戳可以忽略（可能只在理论上发生，根据技术文档）
Example here, notice the header of the table bearing the hours. And the times within that hour being grouped in that column. One event, having two timestamps in one hour can be ignored (may only happen in theory, as per the technical docs)
表使用Drupals theme_table（），我可以从任何数组构建，为每个行支持数组。 Drupal部分在这里不感兴趣：）
The table is built with Drupals theme_table(), which I can build up from any array, bearing arrays for each row. the Drupal part, however, is of little interest here :)
当前代码（片段）：
<?php
//inside function that builds the content for the page linked to above:
$this_morning = _playdates_get_start_of_day_with($timestamp);
$this_night = _playdates_get_end_of_day_with($timestamp);
$nodes = _playdates_load_all_in_range($types, $this_morning, $this_night);
usort($nodes, '_playdates_cmp_titles');
//we now have a list of "nodes", being the events listed in the first column, which have
// a list of playdates, the timestamps. $node->nid is a unique id for each event.
foreach ($nodes as $node) {
$times = $dates = array();
if (is_array($node->starts_at)) {
foreach ($node->starts_at as $starts_at) {
$date = getdate($starts_at);
$dates[$starts_at] = $date;
if (!isset($active) && ($timestamp <= ($date[0] + $timezone))) {
$active = _playdates_get_idx_hour($date);
}
}
$times = _playdates_group_by_hour($dates);
foreach ($times as $key => $value) {
$header_times[$key] = $key;
}
$header = array_merge($header, $header_times);
$entries[$node->nid] = $node;
$entries[$node->nid]->times = $times;
}
}
function _playdates_group_by_hour($timestamps, $playdate = NULL) {
$indexes = array();
foreach ($timestamps as $key => $value) {
$indexes[_playdates_get_idx_hour($value)] = theme('playdates_format_time', $value, $playdate);
}
ksort($indexes);
return $indexes;
}
function _playdates_get_idx_hour($date) {
return playdates_format_date($date[0], 'custom', 'H:00');
}
因此，模式是：grab（和order）事件列表。循环，对于每个事件，循环时间戳，并创建一个数组，其中键是时间戳的小时（小时）。
So, the pattern is: grab (and order) the list of events. Loop over that, for each event, loop over the timestamps and create an array with the key being the hour of the timestamp (group by hours).
？有没有更通用的方法来实现呢？我可以搜索的任何关键字（我不知道如何调用这种模式）？
Are there better patterns? Is there a more generic way to achieve this? Any keywords that I can search for (I have no idea how such a pattern would be called)?
示例数据集
$ nodes（unnessecary data removed）看起来像这样：
example dataset The $nodes (unnessecary data removed) look like this:
array(15) {
[1]=>
object(stdClass)#48 (6) {
["title"]=>
string(19) "Cosa voglio di più"
["type"]=>
string(4) "film"
["nid"]=>
string(4) "2823"
["premiere"]=>
object(stdClass)#49 (1) {
["starts_at"]=>
string(10) "1286550000"
}
["starts_at"]=>
array(2) {
[0]=>
string(10) "1286550000"
[1]=>
string(10) "1286559000"
}
["ends_at"]=>
array(2) {
[0]=>
string(1) "0"
[1]=>
string(1) "0"
}
}
[12]=>
object(stdClass)#46 (6) {
["title"]=>
string(5) "Tirza"
["type"]=>
string(4) "film"
["nid"]=>
string(4) "2813"
["premiere"]=>
object(stdClass)#47 (1) {
["starts_at"]=>
string(10) "1286550000"
}
["starts_at"]=>
array(3) {
[0]=>
string(10) "1286550000"
[1]=>
string(10) "1286558100"
[2]=>
string(10) "1286566200"
}
["ends_at"]=>
array(3) {
[0]=>
string(1) "0"
[1]=>
string(1) "0"
[2]=>
string(1) "0"
}
}
[14]=>
object(stdClass)#36 (6) {
["title"]=>
string(47) "Vision - aus dem Leben der Hildegard von Bingen"
["type"]=>
string(4) "film"
["nid"]=>
string(4) "2783"
["premiere"]=>
object(stdClass)#39 (1) {
["starts_at"]=>
string(10) "1286541900"
}
["starts_at"]=>
array(1) {
[0]=>
string(10) "1286541900"
}
["ends_at"]=>
array(1) {
[0]=>
string(1) "0"
}
}
}
推荐答案
我不熟悉Drupal，所以我要提出一个建议，基于我自己的方法来重构显示的列表一列中的电影标题，以及相应时间列中的开始时间。
I'm not familiar with Drupal at all, so I'm going to make a suggestion based on my own approach to your request to refactor the display of a list of movie titles in one column, and the start time in the appropriate time column.
您正在开始一个包含电影标题和开始时间戳的电影（或电影）数组。我假设在某个地方你可以检索或创建列标题的小时数组。
You are starting with an array of movies (or 'films') containing movie titles and start timestamps. I assume somewhere you can retrieve or create an array of hours for the column title.
下面的例子忽略你正在处理一个对象，对象包含数组， 仅显示替代模式方法。而不是所有的格式和排序，你看起来是这样做，这种模式迭代每个电影，并使用第二个foreach迭代的小时列，并测试电影时间是否匹配小时的时间。
The example below ignores that you are dealing with an object, or that the object contains arrays, only to exhibit an alternate pattern approach. Rather than all the formatting and sorting you appear to be doing, this pattern iterates over each movie and uses a second foreach to iterate over the hour columns, and tests if the movie time matches the hour time.
<?php foreach($movie_array as $movie){
echo '<td>'.$movie['title'].'</td>';
foreach($hours as $hour){
if(date('H',$movie['starts_at']) == date('H',$hour)){
echo '<td>'.date('H:i',$movie['starts_at']).'</td>';
}//endif
else{
echo '<td></td>';
}//endelse
}//endforeach
}//endforeach
?>
我已经跳过设置表，当然，你可以替换我的html实体你更喜欢设置表。
I've skipped setting up the table, and of course, you could replace my html entities with however you prefer to set up the table.
我认为这是一个可行的模式，似乎简化了你的原始模式的逻辑，并保持灵活性。希望我没有误解和忽略你的问题的关键部分。
I think this is a viable pattern that seems to simplify the logic of your original pattern, and remains flexible. Hopefully I haven't misunderstood and omitted a critical part of your problem.
这篇关于具有时间戳记列表的事件列表，在表格式显示中按小时分组，以PHP表示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
