<td class="mmList1">' . $medlem["id"] . '</td>
<td class="mmList2">' . $medlem["aNamn"] . '</td>
<td class="mmList2">' . $medlem["fNamn"] . ' ' . $medlem["eNamn"] . '</td>
<td class="mmList1">' . $medlem["epost"] . '</td>
<td class="mmList2">' . $medlem["steg"] . '</td>
<td class="mmList1">' . $medlem["companyname"] . '</td>
<td class="mmList2">' . $medlem["startdatum"] . ' - ' . $medlem["slutdatum"] . '</td>
<td class="mmList1" id="win-date-' . $medlem["id"] . '">' . $medlem["veckotavling_status"] . '</td>
<td class="mmList2" id="win-date-' . $medlem["id"] . '">' . $medlem["veckotavling_week"] . '</td>
<td class="mmList1" id="win-date-' . $medlem["id"] . '">' . $medlem["veckotavling_datum"] . '</td>
</tr>';
}
$winnertable .= '</table>';
echo $winnertable;
$jdate = new JDate($date);
$week = $jdate->getWeek();
if (count($winners) > 0) {
$att = null;
$emaillist = '';
$winnerIds = '';
$namelist = '<br/>';
$html = "<h2>VINNARE VECKA {$week}</h2><h2>";
foreach ($winners as $id => $medlem) {
$att .= "\n";
$html .= '<a href="/pages/profil.php?mid=' . $medlem["id"] . '">' . $medlem["aNamn"] . '</a><br />';
$emaillist .= $medlem["epost"] . ", ";
$winnerIds .= $medlem["id"] . ", ";
$namelist .= $medlem["fNamn"] . ' ' . $medlem["eNamn"] . ' - ' . $medlem["epost"] . ' - ' . $medlem["steg"] . '<br />';
}
$html .= "</h2>";
$winnerIds = substr($winnerIds, 0, strlen($winnerIds) - 2);
/**
* Update the members to be a week winner
* Krillo 2012-09-10
*
* @global $db $db
* @param type $idArray
* @return type
*/
public static function updateVeckoVinnare($idArray, $date)
{
global $db;
$jDate = new JDate($date);
$idArray = implode(',', $idArray);
$sql = "UPDATE mm_medlem SET veckotavling_status = 1, veckotavling_week = '" . $jDate->getYear() . '-' . $jDate->getWeek() . "' WHERE id IN ({$idArray});";
$status = $db->query($sql);
return $status;
}
<?php require 'jdate.class.php'; $date = "2010-01-01 00:12:12"; $udate = 1262300400; $d = new JDate(); print_r($d->getWeek($date)); print_r($d->getWeek($udate)); print_r($d->getWeek());
