function getHtmlContext($url)
{
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HEADER, TRUE);
//表示需要response header
curl_setopt($ch, CURLOPT_NOBODY, FALSE);
//表示需要response body
curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
curl_setopt($ch, CURLOPT_TIMEOUT, 120);
$result = curl_exec($ch);
global $header;
if ($result) {
$headerSize = curl_getinfo($ch, CURLINFO_HEADER_SIZE);
$header = explode("\r\n", substr($result, 0, $headerSize));
$body = substr($result, $headerSize);
}
if (curl_getinfo($ch, CURLINFO_HTTP_CODE) == '200') {
return $body;
}
if (curl_getinfo($ch, CURLINFO_HTTP_CODE) == '302') {
$location = getHeader("Location");
if (strpos(getHeader("Location"), 'http://') == false) {
$location = getHost($url) . $location;
}
return getHtmlContext($location);
}
return NULL;
}
/**
* 授权
*/
public function getOpenID()
{
$weObj = new \System\lib\Wechat\Wechat($this->config("WEIXIN_CONFIG"));
$this->weObj = $weObj;
if (empty($_GET['code']) && empty($_GET['state'])) {
$callback = getHostUrl();
$reurl = $weObj->getOauthRedirect($callback, "1");
redirect($reurl, 0, '正在发送验证中...');
exit;
} elseif (intval($_GET['state']) == 1) {
$accessToken = $weObj->getOauthAccessToken();
// 是否有用户记录
$isUser = $this->table('user')->where(["openid" => $accessToken['openid'], 'is_on' => 1])->get(null, true);
/*var_dump($isUser);exit();*/
if ($isUser == null) {
//没有此用户跳转至输入注册的页面
header("LOCATION:" . getHost() . "/register.html");
} else {
$userID = $isUser['id'];
$updateUser = $this->table('user')->where(['id' => $userID])->update(['last_login' => time(), 'last_ip' => ip2long(getClientIp())]);
$_SESSION['userInfo'] = ['openid' => $isUser['openid'], 'userid' => $isUser['id'], 'nickname' => $isUser['nickname'], 'user_img' => $isUser['user_img']];
//var_dump($_SESSION['userInfo']['openid']);exit();
header("LOCATION:http://onebuy.ping-qu.com");
//进入网站成功
//用户取消授权
//
//$this->R('','90006');
}
}
}
function setUp()
{
/*
* This test requires that the fossology test archive has been
* loaded under the name fossarchive-T.tar.bz2 For now, the setup
* will just verify the material is there?
*/
global $URL;
global $name;
global $safeName;
$name = 'fossI16L518.tar.bz2';
$safeName = escapeDots($name);
$this->host = getHost($URL);
$this->Login();
/* check for existense of archive */
$page = $this->mybrowser->get($URL);
$page = $this->mybrowser->clickLink('Browse');
$this->assertTrue($this->myassertText($page, '/Browse/'), "verifyFossI16L518 FAILED! Could not find Browse menu\n");
$page = $this->mybrowser->clickLink('Testing');
$this->assertTrue($this->myassertText($page, '/Testing/'), "verifyFossI16L518 FAILED! Could not find Testing folder\n");
$result = $this->myassertText($page, "/{$safeName}/");
if (!$result) {
exit(FALSE);
}
}
function getUrlfromDir($local_dir)
{
//-------------------------------
$server_dir = getWebDir($local_dir);
$server_scheme = getScheme();
$server_host = getHost();
return "{$server_scheme}://{$server_host}/{$server_dir}";
}
public function agregateLogs($error, $data = null)
{
App::getServiceLog()->log($error, $data);
$subject = 'Message subject ąśżźćę';
$body = App::template('stopsupervisor', array('error' => $error, 'data' => $data, 'host' => getHost()));
$message = Swift_Message::newInstance()->setSubject('webservice [' . getHost() . '] - error')->setFrom('*****@*****.**', 'webservice')->setTo(App::getConfig('swiftmailer.cron_log_errors'))->setBody($body, 'text/html')->addPart(strip_tags($body), 'text/plain');
App::getServiceMailer()->send($message);
}
function get_source_domain($dname)
{
$dname = getHost($dname);
$dsub = substr($dname, 0, 4);
if (strtolower($dsub) == "www.") {
$dname = substr($dname, 4);
}
return $dname;
}
function __construct($page, $url)
{
/* to do: check for http? if not return null...)? */
if (empty($page)) {
return;
}
$this->page = $page;
if (empty($url)) {
return;
}
$this->host = getHost($url);
}
public function raport()
{
$key = 'crontime';
$limit = 8;
$cache = App::getCache();
$worker = App::getServiceWorker();
$ltime = $cache->get($key);
// poprzednie badanie
// niechginie($ltime);
$ntime = date('Y-m-d H:i:s');
// teraz
$ltime or $ltime = $ntime;
$cache->set($key, $ntime);
// nieginie($ltime);
// nieginie($worker->countErrorFromSince($ltime));
// niechginie($worker->getLastErrors($ltime));
if ($num = $worker->countErrorFromSince($ltime)) {
$body = App::template('cronraport', array('list' => $worker->getLastErrors($ltime, $limit), 'limit' => $limit, 'ltime' => $ltime, 'num' => $num, 'host' => getHost(), 'panel' => App::generate('admin', array(), $referenceType = true)));
$message = Swift_Message::newInstance()->setSubject('webservice [' . getHost() . '] - error')->setFrom('*****@*****.**', 'webservice')->setTo($this->emails)->setBody($body, 'text/html')->addPart(strip_tags($body), 'text/plain');
App::getServiceMailer()->send($message);
}
}
function setUp()
{
/*
* This test requires that the fossology test archive has been
* loaded under the name 3files.tar.bz2
*/
global $URL;
global $name;
global $safeName;
$name = 'RedHat.tar.gz';
$safeName = escapeDots($name);
$this->host = getHost($URL);
//print "SetUp: host is:$this->host\n";
$this->Login();
/* check for existense of archive */
$page = $this->mybrowser->get($URL);
$page = $this->mybrowser->clickLink('Browse');
$this->assertTrue($this->myassertText($page, '/Browse/'), "verifySimpletest FAILED! Could not find Browse menu\n");
$page = $this->mybrowser->clickLink('Testing');
$this->assertTrue($this->myassertText($page, "/{$safeName}/"), "verifySimpleTest FAILED! Could not find RedHat.tar upload\n");
$result = $this->myassertText($page, "/{$name}/");
//if(!($result)) { echo "WTF!\n"; exit(FALSE); }
}
function setUp()
{
/*
* This test requires that the fossology test archive has been
* loaded under the name 3files.tar.bz2
*/
global $URL;
global $name;
global $safeName;
$name = '3files.tar.bz2';
$safeName = escapeDots($name);
$this->host = getHost($URL);
$this->Login();
/* check for existense of archive */
$page = $this->mybrowser->get($URL);
$page = $this->mybrowser->clickLink('Browse');
$this->assertTrue($this->myassertText($page, '/Browse/'), "verify3files FAILED! Could not find Browse menu\n");
$page = $this->mybrowser->clickLink('Copyright');
$this->assertTrue($this->myassertText($page, '/Copyright/'), "verify3files FAILED! Could not find copyright folder\n");
$result = $this->myassertText($page, "/{$name}/");
if (!$result) {
exit(FALSE);
}
}
function setUp()
{
/*
* This test requires that the fossology test archive has been
* loaded under the name fossDirsOnly.tar.bz2
*/
global $URL;
global $name;
global $safeName;
print "starting verifyFossDirsOnly-SetUp\n";
$name = 'fossDirsOnly.tar.bz2';
$safeName = escapeDots($name);
$this->host = getHost($URL);
$this->Login();
/* check for existense of archive */
$page = $this->mybrowser->get($URL);
$page = $this->mybrowser->clickLink('Browse');
$this->assertTrue($this->myassertText($page, '/Browse/'), "verifyDirsOnly FAILED! Could not find Browse menu\n");
$result = $this->myassertText($page, "/{$safeName}/");
if (!$result) {
$this->fail("Failure, cannot find archive {$name}, Stopping test\n");
exit(1);
}
}
<?php require_once dirname(dirname(dirname(__FILE__))) . '/functions.php'; $queryList = getSQLQuery(getPDO()); $menuList = getMenuListForProcOrder(getPDO(), $queryList["SELECT_MENU_FOR_PROCORDER"]); $menuData = getProced(getPDO(), $menuList); $threadList = getThreadListUrl($menuData["menu_url"], getDiFix(getPDO(), "threadListUrlSuffix", $menuData["kind"], $queryList["SELECT_DIFIX"])); var_dump($menuData); var_dump(getUa(getPDO(), $queryList["SELECT_UA"])); var_dump(getHost($menuData["menu_url"])); $html = threadSteal(getPDO(), "133.130.96.221", "threadSteal", $threadList, $queryList["INSERT_IP_ACCESS"], getUa(getPDO(), $queryList["SELECT_UA"]), getHost($menuData["menu_url"])); var_dump($html);
/**
* Get the url of corresponding page. for gene network diagram.
* @param type $pageName
* @param type $idArr
* @return string
*/
function getPageUrl($pageName, $idArr = array(1, 2, 3, 4))
{
$host = getHost();
$param = idArr2Str($idArr);
switch ($pageName) {
case "entirePathway":
$preUrl = "/mccap-server/app/page/mapEntirePathway.php?id=";
break;
case "metaPathway":
$preUrl = "/mccap-server/app/page/mapMetaPathway.php?id=";
break;
case "entireModule":
$preUrl = "/mccap-server/app/page/mapEntireModule.php?id=";
break;
case "metaModule":
$preUrl = "/mccap-server/app/page/mapMetaModule.php?id=";
break;
default:
$preUrl = "/mccap-server/app/page/error.php";
$param = "";
break;
}
$url = $host . $preUrl . $param;
return $url;
}
/**
* 获取关注回复
*/
private function _getFollowReply()
{
if (!empty($this->userInfo)) {
//活动回复
if (!empty($user['parent'] && !empty($user['parent_share_type']) && !empty($user['activity_id']))) {
//是否在进行活动
$isActivity = $this->table('activity_share_' . $user['parent_share_type'])->where(['is_on' => 1, 'is_show' => 1])->get(['id', 'start_time', 'end_time'], true);
if ($isActivity) {
if (time() > $isActivity['start_time'] && time() < $isActivity['end_time']) {
switch ($user['parent_share_type']) {
case 1:
$content = '欢迎关注广融在线！你已获得参与广融活动“邀好友送特权利率”活动的资格。马上<a href="' . getHost() . '/activity/activity_1_1.html?activity_id=' . $user['activity_id'] . '">点击这里</a>进行领取！';
break;
case 2:
//$content='欢迎关注广融在线！你可参加“投资送现金活动”。马上<a href="'.getHost().'/activity/activity_2_1.html?activity_id='.$user['activity_id'].'">点击这里</a>了解活动详情！';
$content = '对！骚年你没关注错 ！' . "\r\n";
$content .= '这是稳拿8%~13%收益的赚钱平台！' . "\r\n";
$content .= '投资随投随取，快捷方便！' . "\r\n";
$content .= '收益完胜各大银行和各类宝宝！' . "\r\n";
$content .= '快来参与日赚百元计划“领100元红包”吧！' . "\r\n";
$content .= '红包有限！先到先得哦~' . "\r\n";
$content .= '<a href="' . getHost() . '/activity/activity_2_1.html?activity_id=' . $user['activity_id'] . '">点击领100元红包</a>';
break;
}
}
}
}
}
$followReply = $this->table("wechat_response")->where(array("type" => 2, 'is_on' => 1))->get(null, true);
if (!$followReply) {
return false;
}
if ($followReply['rsp_type'] == 0) {
//文本回复
$this->weObj->text($followReply['text'])->reply();
exit;
}
if ($followReply['rsp_type'] == 1) {
//图文回复(未实现)
// $news_temp = $this->table("wechat_news")->where(array("id" => $followReply['news'], 'is_on' => 1))->order('sort_order asc')->get(null, true);
$news_temp = $this->table("wechat_news")->where(array("id" => $followReply['news'], 'is_on' => 1))->get();
//get()内不能
// $this->weObj->text("text")->reply();exit;
foreach ($news_temp as $a) {
$news[] = array('Title' => $a['title'], 'Description' => $a['desc'], 'PicUrl' => $a['img_thumb_360'], 'Url' => empty($a['url']) ? empty($a['url']) ? $this->config('WEIXIN_ARTICLE_PATH') . $a['id'] : $a['url'] : $a['url']);
}
$this->weObj->news($news)->reply();
exit;
}
}
public function getHostname()
{
return getHost();
}
$encodiedThreadBaseHtml = threadSteal(getPDO(), $ip, "threadSteal", $threadList, $queryList["INSERT_IP_ACCESS"], getUa(getPDO(), $queryList["SELECT_UA"]), getHost($menuData["menu_url"]));
$threadData = threadReArray(threadDataPregMatch($encodiedThreadBaseHtml, getDiRegex(getPDO(), "threadStealRegex", $menuData["kind"], $queryList["SELECT_DIREGEX"])), $threadUrl, $censorList);
threadInsert(getPDO(), $threadData, $menuData["id"], $menuData["kind"], $queryList["INSERT_THREAD"]);
unset($threadData);
}
if ($isResSteal) {
$threadData = getThreadData(getPDO(), $menuData["id"], $queryList["SELECT_THREAD"]);
$i = 0;
foreach ($threadData as $value) {
if ($value["thread_now_res_no"] - $value["res_end"] < (int) $fixedList["updateWaiting"]) {
continue;
} else {
timeWeit((int) $fixedList["weitTimeMin"], (int) $fixedList["weitTimeMax"]);
}
$ip = useIp(getPDO(), getUseIpMod(getPDO()));
$encodiedResBaseHtml = resSteal(getPDO(), $ip, "resSteal", $value["thread_url"], $queryList["INSERT_IP_ACCESS"], getUa(getPDO(), $queryList["SELECT_UA"]), getHost($menuData["menu_url"]));
if (!$encodiedResBaseHtml) {
continue;
}
$isoldLog = threadIsOldLog($encodiedResBaseHtml, getDiRegex(getPDO(), "threadOldlogedRegex", $menuData["kind"], $queryList["SELECT_DIREGEX"]));
if ($isoldLog) {
threadUpdateTois_oldlog($value["thread_sha"], $prepareStForTUIO, $dbHandle);
}
$resData = getResArray(getDiRegex(getPDO(), "resStealRegex", $menuData["kind"], $queryList["SELECT_DIREGEX"]), $encodiedResBaseHtml, $value["thread_sha"]);
if (!$resData) {
continue;
}
$ankaerLinkProced = resBodyAnkaerLinkProc($resData, getDiRegex(getPDO(), "resBodyAnkaerLinkStealRegex", $menuData["kind"], $queryList["SELECT_DIREGEX"]));
if ($menuData["kind"] === "open2ch.net") {
$imgLinkProced = resBodyImgLinkProcO(getPDO(), $ankaerLinkProced, $value["thread_sha"], getDiRegex(getPDO(), "resBodyImgLinkStealRegex", $menuData["kind"], $queryList["SELECT_DIREGEX"]), $queryList["UPDATE_THREAD_IS_IMG"], $fixedList["imgDirUrl"], $menuData["kind"]);
} else {
/**
* 注销
*/
public function logout()
{
session_destroy();
header("LOCATION:" . getHost() . "/admin/login.html");
//跳转到login登录
}
<?php
session_start();
/**
* Class for authenticating the site
*
* by Petri Laihonen 26.01.2014
*
*/
$provideResponse = false;
$respArry = array();
$salt = "æøæ|asdrSDRAG12556AWQ899REG1WqerG#¤%#%&¤#YWRGHåäG?Rq+oew£#»qwer";
$server = getHost();
debugLog("Server: " . $server);
// sanitize some
$_POST = sanitize($_POST);
// Database credentials
require_once "dbCredentials.php";
debugLog("Required includes are now with us");
if (!($dbConn = mysqli_connect($conn, $dbUser, $dbPass, $database))) {
$response = array('status' => 'fail', 'message' => 'database connect error.');
debugLog('Database Connection Failed. Error:' . mysqli_error());
echo json_encode($response);
exit;
}
if (!$_SESSION['userId']) {
if (!isset($_SERVER['PHP_AUTH_USER']) || !isset($_SERVER['PHP_AUTH_PW'])) {
header('HTTP/1.0 401 Unauthorized');
header('WWW-Authenticate: Basic realm="Management Access"');
$displayLogin = 1;
// header("Location: ".$server."/login.php");
<?php
header("Location: " . getHost());
function getHost()
{
$proto = empty($_SERVER['HTTPS']) ? "http://" : "https://";
return $proto . $_SERVER['SERVER_NAME'];
}
if (isset($userInputNeeded['module'])) {
$module = getModule();
}
if (isset($userInputNeeded['basePath'])) {
$basePath = getBasePath($basePath);
}
if (isset($userInputNeeded['multisiteMode'])) {
$multisiteMode = getMultisiteMode();
}
// Load supplemental multisite parameters:
if ($multisiteMode == MULTISITE_HOST_BASED) {
if ($opts->getOption('hostname')) {
$host = $opts->getOption('hostname');
} else {
if ($interactive) {
$host = getHost();
}
}
}
}
// Make sure the override directory is initialized (using defaults or CLI
// parameters will not have initialized it yet; attempt to reinitialize it
// here is harmless if it was already initialized in interactive mode):
initializeOverrideDir($overrideDir, true);
// Normalize the module setting to remove whitespace:
$module = preg_replace('/\\s/', '', $module);
// Build the Windows start file in case we need it:
buildWindowsConfig($baseDir, $overrideDir, $module);
// Build the import configuration:
buildImportConfig($baseDir, $overrideDir, 'import.properties');
buildImportConfig($baseDir, $overrideDir, 'import_auth.properties');
/**
* Helper function for smarty_link()
*
* @see smarty_link()
*/
function _smarty_link_entry($params, &$smarty)
{
global $PIVOTX;
$vars = $smarty->get_template_vars();
if (!empty($params['entry'])) {
$params['uid'] = $params['entry'];
} else {
$params['uid'] = getDefault($params['uid'], $vars['entry']['uid']);
}
// Abort immediately if uid isn't set or there is no entry.
if (empty($params['uid'])) {
debug("Can't create entry link since uid isn't set.");
return '';
} elseif (!$PIVOTX['db']->entry_exists($params['uid'])) {
debug("Can't create entry link since there is no entry with uid {$params['uid']}.");
return '';
}
$text = getDefault($params['text'], "%title%");
$title = getDefault($params['title'], "%title%");
$link = makeFileLink($params['uid'], $params['weblog'], "");
// Perhaps add the protocol and hostname, to create a full URL.
if (!empty($params['fullurl'])) {
$link = getHost() . $link;
}
if ($params['query'] != '') {
if (strpos($link, "?") > 0) {
$link .= '&' . $params['query'];
} else {
$link .= '?' . $params['query'];
}
}
if (!empty($params['hrefonly'])) {
$output = $link;
} else {
if (isset($vars['entry']) && $vars['entry']['code'] == $params['uid']) {
$entry = $vars['entry'];
} else {
$temp_db = new db(false);
$entry = $temp_db->read_entry($params['uid']);
}
$text = str_replace('%title%', $entry['title'], $text);
$text = str_replace('%subtitle%', $entry['subtitle'], $text);
$text = formatDate($entry['date'], $text);
$title = trim($title);
if (!empty($title)) {
$title = str_replace('%title%', $entry['title'], $title);
$title = str_replace('%subtitle%', $entry['subtitle'], $title);
$title = formatDate($entry['date'], $title);
}
$output = sprintf("<a href=\"%s\" title=\"%s\">%s</a>", $link, cleanAttributes($title), $text);
}
return $output;
}
<p><?php
echo getComite($comite_proyecto[0]);
?>
</p>
<div class="row card-content-benefits">
<div class="col s6">
<h6 class="benefit-title">MEALS</h6>
<h5><strong><?php
echo getMeals($comite_proyecto[0]);
?>
</strong></h5>
</div>
<div class="col s6">
<h6 class="benefit-title">HOST</h6>
<h5><strong><?php
echo getHost($comite_proyecto[0]);
?>
</strong></h5>
</div>
<div class="col s6">
<h6 class="benefit-title">IPS</h6>
<h5><strong><?php
echo getIPS($comite_proyecto[0]);
?>
</strong></h5>
</div>
<div class="col s6">
<h6 class="benefit-title">LEAD</h6>
<h5><strong><?php
echo getLead($comite_proyecto[0]);
?>
function formatItem($item, $number)
{
global $conf;
global $lang;
global $smarty;
static $date = 0;
date_default_timezone_set("America/New_York");
/* if($item['date'] != $date) {
$date = $item['date'];
$timestamp = strtotime($date);
$pdate = strftime($lang['DATEFORMAT'],$timestamp);
print '<h1>'.$pdate.'</h1>';
}*/
if (date('j', $item['timestamp']) != date('j', $date)) {
$date = $item['timestamp'];
$pdate = date("l F j, Y", $date);
print '<h1>' . $pdate . '</h1>';
}
/* $smarty->assign('conf', $conf);
$smarty->assign('lang', $lang);
$smarty->assign('iitem', md5($item['url']));
$smarty->assign('number', $number);
$smarty->assign('item', $item);
$smarty->assign('channelFavicon', channelFavicon($item['feedurl']));
$sources = array();
$sources['digg'] = ($conf['digg'] == 'true' && !stristr(getHost($item['url']),'digg'));
$sources['del.icio.us'] = ($conf['del.icio.us'] == 'true');
$sources['reddit'] = ($conf['reddit'] == 'true' && !stristr(getHost($item['feedurl']),'reddit'));
$sources['furl'] = ($conf['furl'] == 'true');
$sources['newsvine'] = ($conf['newsvine'] == 'true');
$smarty->assign('sources', $sources);
$smarty->display('item.tpl');*/
print '<div class="feed">';
// print '<div class="item" id="IITEM-'.$item['id'].'">';
// print '<div class="item" id="IITEM-'.md5($item['url']).'">';
if ($item['viewed']) {
print '<div class="item read" id="' . $item['id'] . '">';
} else {
print '<div class="item" id="' . $item['id'] . '">';
}
print '<img src="' . channelFavicon($item['feedurl']) . '" width="16" height="16" class="icon" alt="" />';
// print '<span class="time">'.$item['time'].'</span> ';
print '<span class="time">' . date('H:i', $item['timestamp']) . '</span> ';
print '<span class="title" id="TITLE' . $number . '">';
//print htmlspecialchars($item['title']);
print $item['title'];
print '</span> ';
print '<span class="source">';
if ($conf['new_window'] == 'true') {
print '<a href="' . $item['url'] . '" target="_blank">»';
} else {
print '<a href="' . $item['url'] . '">»';
}
// print htmlspecialchars($item['name']);
print $item['name'];
print '</a>';
print "</span>\n";
print '<div class="excerpt" id="ICONT' . $number . '">';
// $safehtml =& new safehtml();
// print $safehtml->parse($item['body']);
$body = $item['body'];
if ($conf['new_window'] == 'true') {
$new_window_regex = '/<a href([^>]+)>/i';
$new_window_replace = '<a href\\1 target="_blank">';
$body = preg_replace($new_window_regex, $new_window_replace, $body);
}
print $body;
print '<div class="integration">';
if ($conf['digg'] == 'true' && !stristr(getHost($item['url']), 'digg')) {
print '<a href="http://digg.com/submit?phase=3&url=' . $item['url'] . '&title=' . $item['title'] . '" target="_new"><img src="img/digg.gif" alt="" /> ' . $lang['digg'] . '</a> ';
}
if ($conf['del.icio.us'] == 'true') {
print '<a href="http://del.icio.us/post?url=' . $item['url'] . '&title=' . $item['title'] . '" target="_new"><img src="img/del.icio.us.gif" alt="" /> ' . $lang['delicious'] . '</a> ';
}
if ($conf['reddit'] == 'true' && !stristr(getHost($item['feedurl']), 'reddit')) {
print '<a href="http://www.reddit.com/submit?url=' . $item['url'] . '&title=' . $item['title'] . '" target="_new"><img src="img/reddit.png" alt="" /> ' . $lang['reddit'] . '</a> ';
}
if ($conf['furl'] == 'true') {
print '<a href="javascript:furlPost(\'' . $item['url'] . '\',\'' . $item['title'] . '\');"><img src="img/furl.gif" alt="" /> ' . $lang['furl'] . '</a> ';
}
if ($conf['newsvine'] == 'true') {
print '<a href="javascript:void(window.open(\'http://www.newsvine.com/_wine/save?u=' . $item['url'] . '&h=' . $item['title'] . '\',\'newsvine\',\'toolbar=no,width=590,height=480\'));"><img src="img/newsvine.gif" alt="" /> ' . $lang['newsvine'] . '</a> ';
}
print '</div>';
print '</div>';
print '</div>';
print "</div>\n";
// flush();
}
/**
* 用户信息
* @param array $list 列表数据
* @param array $data 标题数据
* @return unknown
*/
function PHPExcel($list, $data)
{
$this->vendor('Excel.PHPExcel');
//创建PHPExcel对象
$objPHPExcel = new \PHPExcel();
//设置属性
$objPHPExcel->getProperties()->setCreator('ctos')->setLastModifiedBy('ctos')->setTitle('Office 2007 XLSX Test Document')->setSubject('Office 2007 XLSX Test Document')->setDescription('Test document for Office 2007 XLSX, generated using PHP classes.')->setKeywords('office 2007 openxml php')->setCategory('Test result file');
//设置宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20);
//设置高度
$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(22);
$objPHPExcel->getActiveSheet()->getRowDimension('2')->setRowHeight(20);
// 字体和样式
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(10);
$objPHPExcel->getActiveSheet()->getStyle('A2:I2')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
$objPHPExcel->getActiveSheet()->getStyle('A2:I2')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A2:I2')->getBorders()->getAllBorders()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);
// 设置水平居中
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('F')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('G')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('H')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('I')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
// 合并
$objPHPExcel->getActiveSheet()->mergeCells('A1:I1');
// 表头
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $data['title'])->setCellValue('A2', $data['thematic_name'])->setCellValue('B2', $data['bill_sn'])->setCellValue('C2', $data['goods_name'])->setCellValue('D2', $data['goods_sn'])->setCellValue('E2', $data['code'])->setCellValue('F2', $data['price'])->setCellValue('G2', $data['nickname'])->setCellValue('H2', $data['phone'])->setCellValue('I2', $data['add_time']);
// 内容
for ($i = 0, $len = count($list); $i < $len; $i++) {
//转换成字符串
$objPHPExcel->getActiveSheet(0)->setCellValueExplicit('A' . ($i + 3), $list[$i]['thematic_name'], \PHPExcel_Cell_DataType::TYPE_STRING);
$objPHPExcel->getActiveSheet(0)->setCellValue('B' . ($i + 3), $list[$i]['bill_sn']);
$objPHPExcel->getActiveSheet(0)->setCellValue('C' . ($i + 3), $list[$i]['goods_name']);
$objPHPExcel->getActiveSheet(0)->setCellValue('D' . ($i + 3), $list[$i]['goods_sn']);
$objPHPExcel->getActiveSheet(0)->setCellValue('E' . ($i + 3), $list[$i]['code']);
$objPHPExcel->getActiveSheet(0)->setCellValue('F' . ($i + 3), $list[$i]['price']);
$objPHPExcel->getActiveSheet(0)->setCellValue('G' . ($i + 3), $list[$i]['nickname']);
$objPHPExcel->getActiveSheet(0)->setCellValue('H' . ($i + 3), $list[$i]['phone']);
$objPHPExcel->getActiveSheet(0)->setCellValue('I' . ($i + 3), $list[$i]['add_time']);
$objPHPExcel->getActiveSheet()->getStyle('A' . ($i + 3) . ':I' . ($i + 3))->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objPHPExcel->getActiveSheet()->getStyle('A' . ($i + 3) . ':I' . ($i + 3))->getBorders()->getAllBorders()->setBorderStyle(\PHPExcel_Style_Border::BORDER_THIN);
$objPHPExcel->getActiveSheet()->getRowDimension($i + 3)->setRowHeight(16);
}
// Rename sheet
// 重命名工作表
$objPHPExcel->getActiveSheet()->setTitle($data['title']);
// Set active sheet index to the first sheet, so Excel opens this as the first sheet
//设置活动工作表索引到第一个工作表，那么 Excel 就会打开这作为第一个工作表
$objPHPExcel->setActiveSheetIndex(0);
// 输出
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="' . $data['title'] . '.xls"');
header('Cache-Control: max-age=0');
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
$name = time();
$url = getHost();
$url = $url . '/excel/' . $name . '.xls';
$objWriter->save('./excel/' . $name . '.xls');
return $url;
}
function ResolveHost()
{
$this->Host = getHost();
if (!empty($this->Host) && $this->Host != $this->IP) {
queryDB(true, "UPDATE `" . DB_PREFIX . DATABASE_VISITORS . "` SET `host`='" . @mysql_real_escape_string($this->Host) . "' WHERE `id`='" . @mysql_real_escape_string($this->UserId) . "' AND `visit_latest`=1;");
}
}
require "config.php";
include '../config/config.general.php';
// ** business functions
require 'includes/business.class.php';
// ** database functions
include '../web/classes/database.class.php';
// ** localization functions
include '../web/classes/local.class.php';
// ** business functions
include '../web/classes/business.class.php';
// ** connect to database
include '../web/classes/connect.db.php';
// ** all database queries
include '../web/classes/db_queries.db.php';
// get and define referer
$ref = getHost($_SERVER['HTTP_REFERER']);
$_SESSION['referer'] = $_SESSION['referer'] != '' ? $_SESSION['referer'] : $ref;
// property id
if ($_GET['prp']) {
$_SESSION['property'] = (int) $_GET['prp'];
} elseif ($_POST['prp']) {
$_SESSION['property'] = (int) $_POST['prp'];
} elseif (!$_SESSION['property']) {
$_SESSION['property'] = '1';
}
$_SESSION['propertyID'] = $_SESSION['property'];
//standard outlet for contact form
if ($_GET['outletID']) {
$_SESSION['outletID'] = (int) $_GET['outletID'];
} else {
if ($_SESSION['outletID'] != '') {
function getAppUrl()
{
$url = getHost() . getAppPath();
return $url;
}
/**
* 返回给前端页面json
* @param string|array $data
* @param string $errcode
* @param bool $helper 是否helper调用，如果true,则不返回json
*/
protected function R($data = "", $errcode = '', $helper = false, $jumpUrl = '')
{
if (!empty($errcode)) {
$this->errcode = $errcode;
}
if ($this->errcode == 0) {
$errmsg = '请求成功！';
$isImportant = 0;
} else {
if (empty(self::$errMap)) {
$errMap = (require __ROOT__ . '/errorCode.php');
self::$errMap = $errMap;
}
if (is_array(self::$errMap[$this->errcode])) {
$errmsg = self::$errMap[$this->errcode][0];
$isImportant = self::$errMap[$this->errcode][1];
$defaultUrl = empty(self::$errMap[$this->errcode][2]) ? 0 : self::$errMap[$this->errcode][2];
$jumpUrl = empty($jumpUrl) ? $defaultUrl : $jumpUrl;
} else {
$errmsg = self::$errMap[$this->errcode];
$isImportant = 0;
$jumpUrl = '';
}
}
$returnData = ["errcode" => $this->errcode, "errmsg" => $errmsg, 'data' => $data, 'isImportant' => $isImportant, 'jumpUrl' => $jumpUrl];
$isView = Router::$isView;
$isViewMuti = Router::$isViewMuti;
if (!$helper && $isView === false) {
ajaxReturn($returnData, "JSON", JSON_UNESCAPED_UNICODE);
} elseif (!$helper && $isView === true) {
//错误跳转
if ($returnData['errcode'] != 0 && $returnData['isImportant'] == 1) {
redirect(getHost() . $jumpUrl);
}
if ($isViewMuti) {
self::$viewDataTemp[self::$functionName] = $returnData;
} else {
self::$viewDataTemp = $returnData;
}
return;
}
return $returnData;
}
private function _repoDBlogin($browser = NULL)
{
if (is_null($browser)) {
$this->_browser();
}
global $URL;
global $USER;
global $PASSWORD;
$page = NULL;
$cookieValue = NULL;
$host = getHost($URL);
$this->assertTrue(is_object($this->mybrowser));
$this->mybrowser->useCookies();
$cookieValue = $this->mybrowser->getCookieValue($host, '/', 'Login');
$this->mybrowser->setCookie('Login', $cookieValue, $host);
$page = $this->mybrowser->get("{$URL}?mod=auth&nopopup=1");
$this->assertTrue($page);
/* Use the test configured user if none specified */
if (!strlen($this->User)) {
$this->setUser($USER);
}
// no check on the password, as it could be blank, just use it...It should
// have been set (if there was one) in Login
//echo "FTDB: user is:$this->User and Password:$this->Password\n";
$this->assertTrue($this->mybrowser->setField('username', $this->User), "Fatal! could not set username field in login form for {$this->User}\n");
$this->assertTrue($this->mybrowser->setField('password', $this->Password), "Fatal! could not set password field in login form for {$this->User}\n");
$this->assertTrue($this->mybrowser->isSubmit('Login'));
$page = $this->mybrowser->clickSubmit('Login');
$this->assertTrue($page, "FATAL! did not get a valid page back from Login\n");
//print "DB: _RDBL: After Login ****page is:$page\n";
$page = $this->mybrowser->get("{$URL}?mod=Default");
//$p = $this->__chopPage($page);
//print "DB: _RDBL: After mod=Default ****page is:$page\n";
$this->assertTrue($this->myassertText($page, "/User:<\\/small>\\s{$this->User}/"), "Did not find User:<\\/small> {$this->User}\nThe User may not be logged in\n");
$this->mybrowser->setCookie('Login', $cookieValue, $host);
$page = $this->mybrowser->getContent();
$NumMatches = preg_match('/User Logged Out/', $page, $matches);
$this->assertFalse($NumMatches, "User Logged out!, Login Failed! %s");
return $cookieValue;
}
