function get_related_dates($projectname, $basedate)
{
include "cdash/config.php";
require_once "cdash/pdo.php";
$dates = array();
$db = pdo_connect("{$CDASH_DB_HOST}", "{$CDASH_DB_LOGIN}", "{$CDASH_DB_PASS}");
pdo_select_db("{$CDASH_DB_NAME}", $db);
$dbQuery = pdo_query("SELECT nightlytime FROM project WHERE name='{$projectname}'");
if (pdo_num_rows($dbQuery) > 0) {
$project = pdo_fetch_array($dbQuery);
$nightlytime = $project['nightlytime'];
//echo "query result nightlytime: " . $nightlytime . "<br/>";
} else {
$nightlytime = "00:00:00";
//echo "default nightlytime: " . $nightlytime . "<br/>";
}
if (!isset($basedate) || strlen($basedate) == 0) {
$basedate = gmdate(FMT_DATE);
}
// Convert the nightly time into GMT
$nightlytime = gmdate(FMT_TIME, strtotime($nightlytime));
$nightlyhour = time2hour($nightlytime);
$nightlyminute = time2minute($nightlytime);
$nightlysecond = time2second($nightlytime);
$basemonth = date2month($basedate);
$baseday = date2day($basedate);
$baseyear = date2year($basedate);
$dates['nightly+2'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday + 2, $baseyear);
$dates['nightly+1'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday + 1, $baseyear);
$dates['nightly-0'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday, $baseyear);
$dates['nightly-1'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday - 1, $baseyear);
$dates['nightly-2'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday - 2, $baseyear);
// Snapshot of "now"
//
$currentgmtime = time();
$currentgmdate = gmdate(FMT_DATE, $currentgmtime);
// Find the most recently past nightly time:
//
$todaymonth = date2month($currentgmdate);
$todayday = date2day($currentgmdate);
$todayyear = date2year($currentgmdate);
$currentnightly = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $todaymonth, $todayday, $todayyear);
while ($currentnightly > $currentgmtime) {
$todayday = $todayday - 1;
$currentnightly = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $todaymonth, $todayday, $todayyear);
}
$dates['now'] = $currentgmtime;
$dates['most-recent-nightly'] = $currentnightly;
$dates['today_utc'] = $currentgmdate;
$dates['basedate'] = gmdate(FMT_DATE, $dates['nightly-0']);
// CDash equivalent of DART1's "last rollup time"
if ($dates['basedate'] === $dates['today_utc']) {
// If it's today, it's now:
$dates['last-rollup-time'] = $dates['now'];
} else {
// If it's not today, it's the nightly time on the basedate:
$dates['last-rollup-time'] = $dates['nightly-0'];
}
return $dates;
}
function get_related_dates($projectnightlytime, $basedate)
{
$dates = array();
$nightlytime = $projectnightlytime;
if (!isset($basedate) || strlen($basedate) == 0) {
$basedate = gmdate(FMT_DATE);
}
// Convert the nightly time into GMT
$nightlytime = gmdate(FMT_TIME, strtotime($nightlytime));
$nightlyhour = time2hour($nightlytime);
$nightlyminute = time2minute($nightlytime);
$nightlysecond = time2second($nightlytime);
$basemonth = date2month($basedate);
$baseday = date2day($basedate);
$baseyear = date2year($basedate);
$dates['nightly+2'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday + 2, $baseyear);
$dates['nightly+1'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday + 1, $baseyear);
$dates['nightly-0'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday, $baseyear);
$dates['nightly-1'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday - 1, $baseyear);
$dates['nightly-2'] = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $basemonth, $baseday - 2, $baseyear);
// Snapshot of "now"
//
$currentgmtime = time();
$currentgmdate = gmdate(FMT_DATE, $currentgmtime);
// Find the most recently past nightly time:
//
$todaymonth = date2month($currentgmdate);
$todayday = date2day($currentgmdate);
$todayyear = date2year($currentgmdate);
$currentnightly = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $todaymonth, $todayday, $todayyear);
while ($currentnightly > $currentgmtime) {
$todayday = $todayday - 1;
$currentnightly = gmmktime($nightlyhour, $nightlyminute, $nightlysecond, $todaymonth, $todayday, $todayyear);
}
$dates['now'] = $currentgmtime;
$dates['most-recent-nightly'] = $currentnightly;
$dates['today_utc'] = $currentgmdate;
$dates['basedate'] = gmdate(FMT_DATE, $dates['nightly-0']);
// CDash equivalent of DART1's "last rollup time"
if ($dates['basedate'] === $dates['today_utc']) {
// If it's today, it's now:
$dates['last-rollup-time'] = $dates['now'];
} else {
// If it's not today, it's the nightly time on the basedate:
$dates['last-rollup-time'] = $dates['nightly-0'];
}
return $dates;
}
<input type="hidden" name='time' value='' />
<?php
function time2second($seconds)
{
$seconds = (int) $seconds;
if ($seconds < 86400) {
//如果不到一天
$format_time = gmstrftime('-1&%H&%M', $seconds);
} else {
$time = explode(' ', gmstrftime('%j %H %M %S', $seconds));
//Array ( [0] => 04 [1] => 14 [2] => 14 [3] => 35 )
$format_time = $time[0] - 1 . '&' . $time[1] . '&' . $time[2];
}
return $format_time;
}
$times = time2second($item['tel_time']);
$times = explode('&', $times);
$day = ltrim($times[0], '0');
$hours = ltrim($times[1], '0');
$minute = ltrim($times[2], '0');
?>
<label style="width:20%;"><select name="day" style="width:70%;margin-right:5px;">
<script>
for(var i=0;i<=30;i++){
if(i=='<?php
echo $day;
?>
'){var ch="selected='selected'";}else{var ch='';}
document.write("<option "+ch+" value='"+i+"'>"+i+"</option>");
}
<tr>
<th style="text-align: center;">เวลา</th>
<th style="text-align: center;">เส้นทาง</th>
<th style="text-align: center;">รถ</th>
<th></th>
</tr>
<?php
$starttime = $daystamp;
$endtime = $daystamp + time2second(23, 59, 59);
$sql = "SELECT DEPARTURE_TIME, NAME, CB_BUSES.BUSNUMBER AS \"BUSNO\", NUMPLATE, CB_ROUTES.COLOR\n\t\t\t\t\t\t\t\tFROM CB_BUSRUNS, CB_ROUTES, CB_BUSES\n\t\t\t\t\t\t\t\tWHERE CB_BUSRUNS.ROUTE_ID = CB_ROUTES.ID\n\t\t\t\t\t\t\t\t\tAND CB_BUSRUNS.BUSNUMBER = CB_BUSES.BUSNUMBER\n\t\t\t\t\t\t\t\t\tAND CB_BUSRUNS.DRIVER_ID = " . $_SESSION['user']['id'] . "\n\t\t\t\t\t\t\t\t\tAND CB_BUSRUNS.DEPARTURE_TIME BETWEEN {$starttime} AND {$endtime}\n\t\t\t\t\t\t\t\tORDER BY CB_BUSRUNS.DEPARTURE_TIME ASC";
$parse = oci_parse($connection, $sql);
oci_execute($parse);
while ($rundata = oci_fetch_array($parse)) {
$time = date("H:i", $rundata['DEPARTURE_TIME']);
$pass = "******";
if ($rundata['DEPARTURE_TIME'] < mktime() + time2second(6)) {
$pass = "******";
}
echo "<tr>\n\t\t\t\t\t\t\t\t\t<td style='font-size:20px;'>{$time}</td>\n\t\t\t\t\t\t\t\t\t<td><span style='color: {$rundata['COLOR']}'>■</span> {$rundata['NAME']}</td>\n\t\t\t\t\t\t\t\t\t<td>{$rundata['BUSNO']} ({$rundata['NUMPLATE']})</td>\n\t\t\t\t\t\t\t\t\t<td>{$pass}</td>\n\t\t\t\t\t\t\t\t</tr>";
}
?>
</table>
</div>
</p>
</div>
</div>
<?php
}
?>
</body>
</html>
?>
</td>
<td><?php
echo $row['sn_password'];
?>
</td>
<td><?php
echo substr($row['start_time'], 0, -3);
?>
</td>
<td><?php
echo substr($row['end_time'], 0, -3);
?>
</td>
<td><?php
echo time2second($row['tel_time']);
?>
</td>
<td><?php
echo $row['sale_price'] / 100;
?>
</td>
<td><?php
echo $row['status'] ? yii::t('vcos', '启用') : yii::t('vcos', '禁用');
?>
</td>
<td>
<?php
//操作挂件
$this->widget('ManipulateWidget', array('ControllerName' => 'Systemsetting', 'MethodName' => 'telephone_service_edit', 'id' => $row['id'], 'canedit' => $canedit, 'candelete' => $candelete));
?>
&orderby=bus&sort=<?php
echo $orderby == "bus" ? $sort : $xsort;
?>
'>รถ</a></th>
<th><a href='administrator.php?page=trip&daystamp=<?php
echo $daystamp;
?>
&orderby=driver&sort=<?php
echo $orderby == "driver" ? $sort : $xsort;
?>
'>พนักงานขับ</a></th>
<th>จัดการ</th>
</tr>
<?php
$startday = $daystamp;
$endday = $daystamp + time2second(23, 59, 59);
$sql = "SELECT RUNID,\n\t\t\t\t\tCB_BUSRUNS.BUSNUMBER AS \"BUSNO\",\n\t\t\t\t\tNUMPLATE,\n\t\t\t\t\tCB_BUSES.COLOR AS \"BUSCOLOR\",\n\t\t\t\t\tCB_ROUTES.NAME AS \"ROUTENAME\",\n\t\t\t\t\tCB_ROUTES.COLOR AS \"ROUTECOLOR\",\n\t\t\t\t\tCB_USERS.NAME AS \"DRIVERNAME\",\n\t\t\t\t\tCB_BUSRUNS.DEPARTURE_TIME AS \"DEP\"\n\t\t\t\tFROM CB_BUSRUNS, CB_BUSES, CB_ROUTES, CB_USERS\n\t\t\t\tWHERE CB_BUSRUNS.BUSNUMBER = CB_BUSES.BUSNUMBER\n\t\t\t\t\tAND CB_BUSRUNS.ROUTE_ID = CB_ROUTES.ID\n\t\t\t\t\tAND CB_BUSRUNS.DRIVER_ID = CB_USERS.ID\n\t\t\t\t\tAND CB_BUSRUNS.DEPARTURE_TIME BETWEEN {$startday} AND {$endday}\n\t\t\t\tORDER BY {$orderby} {$sort}, DEPARTURE_TIME ASC";
$parse = oci_parse($connection, $sql);
oci_execute($parse);
while ($rundata = oci_fetch_array($parse)) {
echo "<tr><td style='font-size: 20px; text-align: center;'>" . date("H:i", $rundata['DEP']) . "</td>";
echo "<td><span style='color: {$rundata['ROUTECOLOR']}'>■</span> {$rundata['ROUTENAME']}</td>";
echo "<td><span style='color: {$rundata['BUSCOLOR']}; text-shadow: 0px 0px 2px #000000;'>■</span> {$rundata['BUSNO']} ({$rundata['NUMPLATE']})</td>";
echo "<td>{$rundata['DRIVERNAME']}</td>";
echo "<td><a href='?page=administrator&page=trip&action=edit&id={$rundata['RUNID']}'>แก้ไข</a> <a href='?page=administrator&daystamp={$daystamp}&page=trip&action=remove&id={$rundata['RUNID']}' onclick='return confirm(\"แน่ใจหรือไม่ว่าจะลบ\");'>ลบ</a></td></tr>";
}
?>
</table></div></p>
</div>
</div>
{
$seconds = (int) $seconds;
if ($seconds < 86400) {
//如果不到一天
$format_time = gmstrftime('0天%H时%M分', $seconds);
} else {
$time = explode(' ', gmstrftime('%j %H %M %S', $seconds));
//Array ( [0] => 04 [1] => 14 [2] => 14 [3] => 35 )
$format_time = $time[0] - 1 . '天' . $time[1] . '时' . $time[2] . '分';
}
return $format_time;
}
?>
<?php
foreach ($type as $key => $row) {
$times = time2second($row['tel_time']);
?>
<tr>
<td class="center">
<label>
<input type="checkbox" name="ids[]" value="<?php
echo $row['tel_id'];
?>
" class="ace isclick" />
<span class="lbl"></span>
</label>
</td>
<td><?php
echo ++$key;
?>
</td>
{
$seconds = (int) $seconds;
if ($seconds < 86400) {
//如果不到一天
$format_time = gmstrftime('0天%H时%M分', $seconds);
} else {
$time = explode(' ', gmstrftime('%j %H %M %S', $seconds));
//Array ( [0] => 04 [1] => 14 [2] => 14 [3] => 35 )
$format_time = $time[0] - 1 . '天' . $time[1] . '时' . $time[2] . '分';
}
return $format_time;
}
?>
<?php
foreach ($wifi_item as $key => $row) {
$times = time2second($row['wifi_time']);
?>
<tr>
<td class="center">
<label>
<input type="checkbox" name="ids[]" value="<?php
echo $row['wifi_id'];
?>
" class="ace isclick" />
<span class="lbl"></span>
</label>
</td>
<td><?php
echo ++$key;
?>
</td>
</div>
<?php
if (isset($_POST['submit'])) {
$id = $_POST['id'];
$name = $_POST['name'];
$color = $_POST['color'];
$firstrun = explode(":", $_POST['firstrun']);
$lastrun = explode(":", $_POST['lastrun']);
if (!is_numeric($firstrun[0]) || !is_numeric($firstrun[1]) || !is_numeric($lastrun[0]) || !is_numeric($lastrun[1])) {
error("", "กรุณากรอกเวลาในรูปแบบ ชม:นท");
}
if ($firstrun[0] > 23 || $firstrun[0] < 0 || $lastrun[0] < 0 || $firstrun[1] > 59 || $lastrun[1] > 59 || $firstrun[1] < 0 || $lastrun[1] < 0) {
error("", "กรุณากรอกเวลาให้ถูกต้อง");
}
$firstrun = time2second($firstrun[0], $firstrun[1], 0);
$lastrun = time2second($lastrun[0], $lastrun[1], 0);
if ($lastrun < $firstrun) {
error("", "เวลาจบต้องมาทีหลังเวลาเริ่ม");
}
if (!is_numeric($id)) {
error("", "กรุณากรอกรหัสเส้นทางเป็นตัวเลข");
}
if (trim($name) == "" || trim($color) == "") {
error("", "กรุณากรอกข้อมูลให้ครบ");
}
$sql = "INSERT INTO CB_ROUTES (ID, NAME, COLOR, FIRST_RUN, LAST_RUN) VALUES ({$id}, '{$name}', '{$color}', {$firstrun}, {$lastrun})";
$parse = oci_parse($connection, $sql);
if (oci_execute($parse)) {
header("location: administrator.php?page=routes");
} else {
$e = oci_error();
<input type="hidden" name='time' value='' />
<?php
function time2second($seconds)
{
$seconds = (int) $seconds;
if ($seconds < 86400) {
//如果不到一天
$format_time = gmstrftime('-1&%H&%M', $seconds);
} else {
$time = explode(' ', gmstrftime('%j %H %M %S', $seconds));
//Array ( [0] => 04 [1] => 14 [2] => 14 [3] => 35 )
$format_time = $time[0] - 1 . '&' . $time[1] . '&' . $time[2];
}
return $format_time;
}
$times = time2second($wifi_item['wifi_time']);
$times = explode('&', $times);
$day = ltrim($times[0], '0');
$hours = ltrim($times[1], '0');
$minute = ltrim($times[2], '0');
?>
<label style="width:20%;"><select name="day" style="width:70%;margin-right:5px;">
<script>
for(var i=0;i<=30;i++){
if(i=='<?php
echo $day;
?>
'){var ch="selected='selected'";}else{var ch='';}
document.write("<option "+ch+" value='"+i+"'>"+i+"</option>");
}
