PHP TimeDate::toDatabaseDate示例

示例#1

文件： jseason.class.php 项目： joomux/jTips

 function save()
 {
     $bind = array();
     $this->updated = gmdate('Y-m-d H:i:s');
     foreach ($this as $prop => $val) {
         $bind[$prop] = $val;
     }
     if (!$this->bind($bind)) {
         return false;
     }
     if (!$this->check()) {
         return false;
     }
     //set the dates back to db format
     if (!empty($this->start_time)) {
         $this->start_time = TimeDate::toDatabaseDate($this->start_time);
     }
     if (!empty($this->end_time)) {
         $this->end_time = TimeDate::toDatabaseDate($this->end_time);
     }
     //Bug 36: pass in true to allow nulls to be updated
     if (!$this->store(true)) {
         jTipsLogger::_log($this->_db->getErrorMsg(), 'ERROR');
         return false;
     }
     //reformat the dates
     //set the dates back to display format
     if (!empty($this->start_time)) {
         $this->start_time = TimeDate::toDisplayDate($this->start_time);
     }
     if (!empty($this->end_time)) {
         $this->end_time = TimeDate::toDisplayDate($this->end_time);
     }
     return true;
 }

示例#2

文件： juser.class.php 项目： joomux/jTips

 function save()
 {
     global $database, $jTips;
     $bind = array();
     $this->set('updated', gmdate('Y-m-d H:i:s'));
     foreach ($this as $prop => $val) {
         $bind[$prop] = $val;
     }
     if (!$this->bind($bind)) {
         return false;
     }
     //jTipsDebug("IDA: " .$this->id);
     if (!$this->check()) {
         return false;
     }
     if (!$this->user_id) {
         jTipsLogger::_log('attempt to save jtipsuser with no related josuser. aborted', 'ERROR');
         return false;
     }
     //jTipsDebug("IDB: " .$this->id);
     if (empty($this->id) and !empty($this->season_id)) {
         $newUser = true;
     } else {
         $newUser = false;
     }
     //Bug 36: Set the image property to empty string instead of null
     if (!$this->store(true)) {
         jTipsLogger::_log($this->_db->getErrorMsg(), 'ERROR');
         return false;
     }
     //jTipsDebug("IDC " .$this->id);
     //late entry points here
     jTipsLogger::_log('saving user with id ' . $this->id . ' and season ' . $this->season_id);
     if ($newUser) {
         // BUG 406 - optionally set reminders as on by default
         if ($jTips['DefaultReminders']) {
             jTipsLogger::_log('setting email reminder option as on by default');
             $this->setPreference('email_reminder', 1);
         }
         jTipsLogger::_log('setting default points for new user for season ' . $this->season_id);
         $jSeason = new jSeason($database);
         $jSeason->load($this->season_id);
         jTipsLogger::_log('comparing dates ' . date('Y-m-d') . ' >? ' . TimeDate::toDatabaseDate($jSeason->start_time));
         if (date('Y-m-d') > TimeDate::toDatabaseDate($jSeason->start_time)) {
             $jSeason->getDefaultPoints($this->id);
         }
         if ($jTips['JomSocialActivities'] and $jTips['JomSocialOnUserJoin']) {
             // BUG 334 - typo in user_id variable.
             jTipsJomSocial::writeJoinMessage($this->user_id, $jSeason);
         }
     }
     return true;
 }

示例#3

文件： edit.php 项目： joomux/jTips

    $step = 5;
}
$tpl->date_start_time_minute = jTipsHTML::integerSelectList('00', $end, $step, 'date_start_time_minute', "class='inputbox'", $date_start_time_minute);
if (intval($jTips['Is24Hour']) == 1) {
    $tpl->date_start_time_meridiem = '';
} else {
    $tpl->date_start_time_meridiem = jTipsHTML::selectList($meridiemOptions, 'date_start_time_meridiem', "class='inputbox'", 'value', 'text', $date_start_time_meridiem);
}
//now prepare the end_time
if (!$focus->end_time) {
    $focus->end_time = gmdate('Y-m-d H:i:s');
}
//BUG 263
if (!isJoomla15()) {
    $tpl->date_end_date = TimeDate::toDisplayDate($focus->end_time, true);
    $tpl->date_end_date = TimeDate::toDatabaseDate($tpl->date_end_date);
} else {
    $tpl->date_end_date = TimeDate::toDisplayDate($focus->end_time, true);
}
$date_end_time_hour = TimeDate::format($focus->end_time, '%I', true);
$date_end_time_minute = TimeDate::format($focus->end_time, '%M', true);
$date_end_time_meridiem = strtolower(TimeDate::format($focus->end_time, '%p', true));
// BUG 326 - Optionally allo 24-hour format
if (intval($jTips['Is24Hour']) == 1) {
    $hour_end = 23;
    if ($date_end_time_meridiem == 'pm') {
        $date_end_time_hour += 12;
    }
} else {
    $hour_end = 12;
}

示例#4

文件： functions.inc.php 项目： joomux/jTips

function parseDataType(&$data, $column, $field)
{
    global $database;
    $dataval = $data[$column];
    switch ($field['type']) {
        case 'int':
            if (is_numeric($dataval)) {
                return $dataval;
            } else {
                return 0;
            }
            break;
        case 'double':
        case 'float':
            if (is_float($dataval)) {
                return $dataval;
            } else {
                return 0;
            }
            break;
        case 'bool':
            if ($dataval == 1 or preg_match('/yes/i', $dataval)) {
                return 1;
            } else {
                return 0;
            }
            break;
        case 'date':
            //return toDbDate($dataval);
            return TimeDate::toDatabaseDate($dataval);
            break;
        case 'datetime':
            //return toDbDateTime($dataval);
            return TimeDate::toDatabaseDateTime($dataval);
            break;
        case 'time':
            //return toDbTime($dataval);
            return TimeDate::toDatabaseTime($dataval);
            break;
        case 'relate':
            //Locate an existing record matching the given data value
            //If nothing found create a skeleton record with the supplied data
            //Return key of supplied data in related table.
            $class = $field['related'];
            $obj = new $class($database);
            $related_fields = $field['related_fields'];
            if (count($related_fields) > 1) {
                $values = preg_split('/[\\s]+/', $dataval);
            } else {
                $values = array($dataval);
            }
            $max = min(count($values), count($related_fields));
            $params = array();
            for ($i = 0; $i < $max; $i++) {
                $params[$related_fields[$i]] = $values[$i];
            }
            if (isset($field['dependency']) and !empty($field['dependency'])) {
                $params[$field['dependency']['key']] = getDependentField($field, $data, $_POST['importFields']);
            }
            //jTipsDebug($_POST);
            //jTipsDebug($dataval);
            //jTipsDebug($field);
            //jTipsDebug($params);
            //die();
            $obj->loadByParams($params);
            $rel_key = $field['related_key'];
            if (isset($obj->{$rel_key}) and !empty($rel_key)) {
                return $obj->{$rel_key};
            } else {
                if ($field['required']) {
                    $obj->bind($params);
                    $obj->save();
                    return $obj->{$rel_key};
                } else {
                    return $field['default'];
                }
            }
            break;
        case 'virtual':
            continue;
            break;
        case 'text':
        default:
            return mysql_real_escape_string($dataval);
            break;
    }
}

示例#5

文件： list.tmpl.php 项目： joomux/jTips

    function display()
    {
        global $mainframe, $database, $jTips, $jLang, $jLicence, $mosConfig_absolute_path, $mosConfig_live_site, $database;
        jTipsLogger::_log('Loading dashboard', 'INFO');
        jTipsCommonHTML::loadOverlib();
        $option = jTipsGetParam($_REQUEST, 'option', 'com_jtips');
        if (isJoomla15()) {
            JToolbarHelper::title($jLang['_ADMIN_DASH_CPANEL'], 'frontpage');
        } else {
            ?>
			<table class="adminheading" border="0" width="100%">
			<tr>
				<th class="cpanel" align="left"><?php 
            echo $jLang['_ADMIN_DASH_CPANEL'];
            ?>
</th>
				<td align="right"><a href="http://www.jtips.com.au" target="_blank" title="jTips Home"><img src="<?php 
            echo $mosConfig_live_site;
            ?>
/components/com_jtips/images/license_logo.png" alt="" border="0" /></a></td>
			</tr>
			</table>
		<?php 
        }
        ?>
		<table class="adminform">
		<tr>
		<td width="55%" valign="top">
		<?php 
        jTipsLogger::_log('Building dashboard icons', 'INFO');
        foreach ($this->menu as $item) {
            if (isset($item['url']) and !empty($item['url'])) {
                $link = $item['url'];
                $extra = "target='_blank'";
            } else {
                $link = "index2.php?option={$option}&amp;task=" . $item['task'];
                $extra = "";
            }
            ?>
		<div id="cpanel" style="float:left;">
			<div class="icon">
				<a href="<?php 
            echo $link;
            ?>
" <?php 
            echo $extra;
            ?>
>
				<img src="components/com_jtips/images/<?php 
            echo $item['image'];
            ?>
"  alt="<?php 
            echo $jLang[$item['alt']];
            ?>
" align="middle" border="0" /><span><?php 
            echo $jLang[$item['link']];
            ?>
</span></a>
			</div>
		</div>
		<?php 
        }
        ?>
</td>
<td width="45%" valign="top">
	<div style="width: 100%;">
	<?php 
        $tabs = new jTipsTabs(1);
        $tabs->startPane('dashpanel');
        $tabs->startTab($jLang['_ADMIN_DASH_TAB_SUMMARY'], 'summary');
        $center = "style='text-align:center;'";
        ?>
	&nbsp;
	<table class='adminlist'>
	<thead>
	<tr>
		<th><?php 
        echo $jLang['_COM_DASH_SEASON'];
        ?>
</th>
		<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_COM_DASH_CURR_ROUND'];
        ?>
</th>
		<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_TOTAL_USERS'];
        ?>
</th>
		<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_PENDING_TIPS'];
        ?>
</th>
		<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_PENDING_PAYMENT'];
        ?>
</th>
	</tr>
	</thead>
	<tbody>
	<?php 
        jTipsLogger::_log('Loading season data', 'INFO');
        $total_user_count = 0;
        foreach ($this->jSeasons as $jSeason) {
            if (TimeDate::toDatabaseDate($jSeason->end_time) > gmdate('Y-m-d')) {
                $round_id = $jSeason->getCurrentRound();
                $jRound = new jRound($database);
                if ($round_id) {
                    $jRound->load($round_id);
                }
                $jTipsUsers = $jSeason->getUsers();
                $total_users = 0;
                $no_tips = 0;
                $has_paid = 0;
                $no_tips_overlib = "";
                foreach ($jTipsUsers as $jTipsUser) {
                    $total_users++;
                    if (!$jTipsUser->hasTipped($jRound->id)) {
                        $no_tips++;
                        if ($no_tips < 10) {
                            $no_tips_overlib .= "<br />" . htmlentities($jTipsUser->getName());
                        } else {
                            if ($no_tips == 10) {
                                $no_tips_overlib .= "<br />...more";
                            }
                        }
                    }
                    if ($jTipsUser->paid == 1) {
                        $has_paid++;
                    }
                }
                if ($jTips['Payments'] != 0) {
                    $pending_payment = $total_users - $has_paid;
                } else {
                    $pending_payment = "N/A";
                }
                $no_tips_overlib = substr($no_tips_overlib, 6);
                if ($no_tips > 0) {
                    $no_tips_overlib_call = jTipsToolTip($no_tips_overlib, "Users Missing Tips");
                } else {
                    $no_tips_overlib_call = '';
                }
                ?>
			<tr>
				<td><?php 
                echo $jSeason->name;
                ?>
</td>
				<td <?php 
                echo $center;
                ?>
><?php 
                echo $jRound->round;
                ?>
</td>
				<td <?php 
                echo $center;
                ?>
><?php 
                echo $total_users;
                ?>
</td>
				<td <?php 
                echo $center;
                ?>
><?php 
                echo $no_tips . "&nbsp;" . $no_tips_overlib_call;
                ?>
</td>
				<td <?php 
                echo $center;
                ?>
><?php 
                echo $pending_payment;
                ?>
</td>
			</tr>
			<?php 
                $total_user_count += $total_users;
            }
        }
        ?>
	</tbody>
	</table>
	<?php 
        $tabs->endTab();
        $tabs->startTab($jLang['_ADMIN_DASH_TAB_UPDATED'], 'update');
        $filesWritable = filesWritable();
        ?>
	&nbsp;
	<table class="adminlist" width="100%">
		<thead>
		<tr>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_UPG_THISVERSION'];
        ?>
</th>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_UPG_LATESTVERSION'];
        ?>
</th>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_UPG_UPGRADE'];
        ?>
</th>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_UPG_FILE_CHECK'];
        ?>
</th>
		</tr>
		</thead>
		<tbody>
		<tr>
			<td <?php 
        echo $center;
        ?>
><?php 
        echo getFullVersion();
        ?>
</td>
			<!-- td <?php 
        echo $center;
        ?>
 id="latest_version"><input type="button" onclick="liveCheckLatestVersion('latest_version');" class="button" value="Check Now" <?php 
        if (!$filesWritable) {
            echo "disabled";
        }
        ?>
 /></td -->
			<td <?php 
        echo $center;
        ?>
>N/A</td>
			<!-- td <?php 
        echo $center;
        ?>
><span id="liveupdatespan"><?php 
        echo getUpdateButton('', '');
        ?>
</span></td -->
			<td <?php 
        echo $center;
        ?>
>N/A</td>
			<td <?php 
        echo $center;
        ?>
>
			<?php 
        if ($filesWritable) {
            $tip = $jLang['_ADMIN_DASH_UPG_FILE_CHECK_OK'];
            $tipTitle = $jLang['_ADMIN_DASH_UPG_FILE_CHECK_OK_TITLE'];
            $img = 'checkin.png';
            echo jTipsToolTip($tip, $tipTitle, '', $img);
        } else {
            $tip = $jLang['_ADMIN_DASH_UPG_FILE_CHECK_FAIL'];
            $tipTitle = $jLang['_ADMIN_DASH_UPG_FILE_CHECK_FAIL_TITLE'];
            $img = 'warning.png';
            ?>
				<a href=>
				<?php 
            echo jTipsToolTip($tip, $tipTitle, '', $img, '', "index2.php?option=com_jtips&amp;module=Upgrade&amp;task=list");
            ?>
				</a>
				<?php 
        }
        ?>
			</td>
		</tr>
		<?php 
        if (needsUpgrade()) {
            ?>
		<tr>
			<td colspan="4" id="upgrade_area" <?php 
            echo $center;
            ?>
>
				<input type="button" class="button" name="upgrade" value="<?php 
            echo $jLang['_ADMIN_UPGRADE_BUTTON'];
            ?>
" onclick="doUpgrade(this);" />
			</td>
		</tr>
		<?php 
        }
        ?>
		</tbody>
		<thead>
		<tr>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_LAST_VALIDATED'];
        ?>
</th>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_VALIDATION'];
        ?>
</th>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_DASH_EXPIRY_DATE'];
        ?>
</th>
			<th <?php 
        echo $center;
        ?>
><?php 
        echo $jLang['_ADMIN_LICENSE_USER_COUNT'];
        ?>
</th>
		</tr>
		</thead>
		<tbody>
		<tr>
			<td <?php 
        echo $center;
        ?>
><?php 
        $validation_date = $jLicence->getValidationDate();
        if ($validation_date == -1) {
            echo $jLang['_ADMIN_DASH_LIC_EXPIRED'];
        } else {
            echo $validation_date;
        }
        ?>
			</td>
			<td <?php 
        echo $center;
        ?>
><a href="index2.php?option=com_jtips&amp;task=Validate&amp;module=Dashboard"><?php 
        echo $jLang['_ADMIN_DASH_REVALIDATE'];
        ?>
</a></td>
			<td <?php 
        echo $center;
        ?>
><?php 
        echo TimeDate::toDisplayDate($jLicence->licence['license_expiry']);
        ?>
&nbsp;</td>
			<td <?php 
        echo $center;
        ?>
><?php 
        echo $jLicence->getActiveUserCount();
        ?>
 / <?php 
        echo $jLicence->getLicensedUsers();
        ?>
</td>
		</tr>
		</tbody>
		<thead>
		<tr>
			<th <?php 
        echo $center;
        ?>
 colspan="4"><?php 
        echo $jLang['_ADMIN_DASH_LOGGING'];
        ?>
</th>
		</tr>
		</thead>
		<tbody>
		<tr>
			<td nowrap><?php 
        echo $jLang['_ADMIN_DASH_FILE_SIZE'];
        ?>
: <?php 
        echo size_readable(filesize($mosConfig_absolute_path . '/components/com_jtips/jtips.log'));
        ?>
</td>
			<td <?php 
        echo $center;
        ?>
><a href="index2.php?option=com_jtips&amp;task=DownloadLog&amp;module=Dashboard"><?php 
        echo $jLang['_ADMIN_DASH_DOWNLOAD'];
        ?>
</a></td>
			<td <?php 
        echo $center;
        ?>
><a href="index2.php?option=com_jtips&amp;task=PurgeLog&amp;module=Dashboard"><?php 
        echo $jLang['_ADMIN_DASH_PURGE'];
        ?>
</a></td>
			<td>&nbsp;</td>
		</tr>
		</tbody>
		<tfoot>
		<tr>
			<td colspan="4"><small><em><?php 
        echo $jLang['_ADMIN_DASH_LOG_ROTATED'];
        ?>
</em></small></td>
		</tr>
		</tfoot>
	</table>
	<?php 
        $tabs->endTab();
        $tabs->startTab($jLang['_ADMIN_DASH_TAB_ABOUT'], 'about');
        ?>
	<div style="text-align:center;"><img src="components/com_jtips/images/logo.png" border="0" />
	<h1><?php 
        echo getFullVersion();
        ?>
</h1></div>
	<p><?php 
        echo $jLang['_ADMIN_DASH_ABOUT_UPDATES'];
        ?>
 <a href="http://www.jtips.com.au/" target="_blank">http://www.jtips.com.au</a></p>
	<p><?php 
        echo $jLang['_ADMIN_DASH_ABOUT_SALES'];
        ?>
 <a href="mailto:sales@jtips.com.au?subject=jTips Enquiry">sales@jtips.com.au</a></p>
	<p><?php 
        echo $jLang['_ADMIN_DASH_ABOUT_SUPPORT'];
        ?>
 <a href="http://www.jtips.com.au" target="_blank">jTips.com.au</a></p>
	<p><?php 
        echo $jLang['_ADMIN_DASH_ABOUT_REBUILD'];
        ?>
 <a href="#" onclick="sendRebuildRequest('rebuildProgress');">&raquo; <?php 
        echo $jLang['_COMMON_CLICK_HERE'];
        ?>
 &laquo;</a>&nbsp;&nbsp;&nbsp;<span id="rebuildProgress"></span></p>
	<?php 
        $tabs->endTab();
        $tabs->startTab($jLang['_ADMIN_DASH_TAB_CREDITS'], 'credits');
        ?>
	&nbsp;
	<p><strong><?php 
        echo $jLang['_ADMIN_DASH_CREDITS'];
        ?>
:</strong></p>
	<table class="adminlist" width="100%">
		<thead>
		<tr>
			<th><?php 
        echo $jLang['_ADMIN_DASH_CREDITS_PACKAGE'];
        ?>
</th>
			<th><?php 
        echo $jLang['_ADMIN_DASH_CREDITS_HOMEPAGE'];
        ?>
</th>
		</tr>
		</thead>
		<tbody>
		<tr>
			<td>mootools</td>
			<td><a href="http://mootools.net/" target="_blank">http://mootools.net</a></td>
		</tr>
		<tr>
			<td>tnimg</td>
			<td><a href="http://vagh.armdex.com/tnimg" target="_blank">http://vagh.armdex.com/tnimg</a></td>
		</tr>
		<tr>
			<td>cURL</td>
			<td><a href="http://www.phpclasses.org/browse/package/1988.html" target="_blank">http://www.phpclasses.org</a></td>
		</tr>
		<tr>
			<td>dUnzip2</td>
			<td><a href="http://www.phpclasses.org/browse/package/2495.html" target="_blank">http://www.phpclasses.org</a></td>
		</tr>
		<tr>
			<td>MOOdalBox</td>
			<td><a href="http://www.e-magine.ro/web-dev-and-design/36/moodalbox/" target="_blank">http://www.e-magine.ro</a></td>
		</tr>
		<tr>
			<td>Silk Icons</td>
			<td><a href="http://www.famfamfam.com/lab/icons/silk/" target="_blank">http://www.famfamfam.com</a></td>
		</tr>
		<tr>
			<td>datejs</td>
			<td><a href="http://www.datejs.com/" target="_blank">http://www.datejs.com</a></td>
		</tr>
		<tr>
			<td>strftime in javascript</td>
			<td><a href="http://tech.bluesmoon.info/2008/04/strftime-in-javascript.html" target="_blank">http://tech.bluesmoon.info/2008/04/strftime-in-javascript.html</a></td>
		</tr>
		<tr>
			<td>Editor Area</td>
			<td><a href="http://www.cdolivet.net/editarea/" target="_blank">http://www.cdolivet.net/editarea</a></td>
		</tr>
		<tr>
			<td>GNOME Icons</td>
			<td><a href="http://commons.wikimedia.org/wiki/GNOME_Desktop_icons" target="_blank">http://commons.wikimedia.org/wiki/GNOME_Desktop_icons</a></td>
		</tr>
		</tbody>
	</table>
	<?php 
        $tabs->endTab();
        $tabs->startTab($jLang['_ADMIN_DASH_TAB_HELP'], 'help');
        ?>
	&nbsp;
	<h2><?php 
        echo $jLang['_ADMIN_DASH_HELP'];
        ?>
</h2>
	<p><?php 
        echo $jLang['_ADMIN_DASH_HELP_INTRO'];
        ?>
 <a href="http://www.jtips.com.au" target="_blank">www.jtips.com.au</a></p>
	<ul>
		<li><?php 
        echo $jLang['_ADMIN_DASH_HELP_GETTING_STARTED'];
        ?>
</li>
		<li><?php 
        echo $jLang['_ADMIN_DASH_HELP_GUIDES'];
        ?>
</li>
		<li><?php 
        echo $jLang['_ADMIN_DASH_HELP_TRICKS'];
        ?>
</li>
	</ul>
	<p>Do you have an invalid license key? Please contact jTips Support
		at <a href="mailto:support@jtips.com.au">support@jtips.com.au</a> and confirm your license key
		is valid for the domain <strong><?php 
        echo $_SERVER['SERVER_NAME'];
        ?>
</strong>.</p>
	<?php 
        $tabs->endTab();
        $tabs->endPane();
        ?>
	</div>
	</td>
	</tr>
	</table>
	<?php 
    }