public function savelog()
{
$error = $this->_post('error');
$info = $this->_post('info');
saveLog('error/steadmin_order', array('msg' => $error, 'info' => $info));
$this->JsonReturn('ok', null, 1);
}
function sendSMS($id, $dateLog)
{
global $client;
//读取所要发送短信到数据，单条发送
$sql = "SELECT id,code,mobile FROM fph_send_sms WHERE id >=" . $id . " AND result = 1 AND 1=1 ORDER BY id ASC LIMIT 1";
$res = mysql_query($sql);
$rs = mysql_fetch_array($res);
if (isset($rs['id'])) {
$statusCode = $client->sendSMS(array($rs['mobile']), $rs['code'], '', '', 'UTF-8');
if ($statusCode == 0) {
$result = 2;
$msg = '发送成功';
saveLog($dateLog, $rs['id'] + 1);
} else {
$result = 3;
$msg = '发送失败';
}
$updateSql = "update fph_send_sms set result = " . $result . ", msg = '" . $msg . "' where id = " . $rs['id'];
mysql_query($updateSql);
} else {
saveLog($dateLog, $id);
}
exit;
}
if ($resultCount->num_rows > 0) {
foreach ($resultCount as $model) {
$arrayLogin['count_cat'] = $model["TOTAL"];
}
saveLog("login: (sucess) " . $username . " professional_with_category");
} else {
$arrayLogin['count_cat'] = "-1";
saveLog("login: (sucess) " . $username . " professional_without_category");
}
} else {
$arrayLogin['count_cat'] = "-2";
saveLog("login: (sucess) " . $username . " user_only");
}
echo json_encode($arrayLogin);
} else {
saveLog("login: (error) " . $username . " invalid");
echo json_encode(array('id' => '-1'));
}
} else {
if (strcmp('get-user-by-id', $_POST['method']) == 0) {
$idUser = $_POST['id_user'];
$sql = "SELECT USER.ID,\n\t\t\t\t\t USER.EMAIL,\n\t\t\t\t\t USER.NAME,\n\t\t\t\t\t USER.BIRTH,\n\t\t\t\t\t USER.SEX,\n\t\t\t\t\t USER.PICTURE_PROFILE,\n\t\t\t\t\t USER.SOCIALNET,\n\t\t\t\t\t USER.IS_PRO,\n\t\t\t\t\t USER.DATE_TIME_USER,\n\t\t\t\t\t (PROFESSIONAL.ID)AS ID_PRO,\n\t\t\t\t\t PROFESSIONAL.BANNER,\n\t\t\t\t\t PROFESSIONAL.CITY,\n\t\t\t\t\t PROFESSIONAL.STATE,\n\t\t\t\t\t PROFESSIONAL.ADDR,\n\t\t\t\t\t PROFESSIONAL.DISTRICT,\n\t\t\t\t\t PROFESSIONAL.PHONE1,\n\t\t\t\t\t PROFESSIONAL.PHONE2,\n\t\t\t\t\t PROFESSIONAL.LOCATION,\n\t\t\t\t\t PROFESSIONAL.DATE_TIME_PROF\n\t\t\t\t\t FROM USER LEFT JOIN PROFESSIONAL ON (USER.ID=PROFESSIONAL.ID_USER) WHERE USER.ID=" . $idUser;
$lastId;
$result = $conn->query($sql);
if ($result->num_rows > 0) {
$arrayLogin = array();
foreach ($result as $model) {
$arrayLogin = getArrayUser($model);
}
if ($arrayLogin["is_pro"] == "1") {
$id_pro = $arrayLogin["id_pro"];
/**
* 输出自定义提示信息
*/
private function halt($msg = '', $errMsg = '')
{
if (isHave($this->config['save_errlog'])) {
saveLog('db/error', var_export($msg, true) . ':' . $errMsg);
}
showError($msg);
}
function processWorkspace()
{
global $sLastExecution;
global $ScriptAction;
try {
if (($solrConf = System::solrEnv(SYS_SYS)) !== false) {
G::LoadClass('AppSolr');
print "Solr Configuration file: " . PATH_DATA_SITE . "env.ini\n";
print "solr_enabled: " . $solrConf['solr_enabled'] . "\n";
print "solr_host: " . $solrConf['solr_host'] . "\n";
print "solr_instance: " . $solrConf['solr_instance'] . "\n";
$oAppSolr = new AppSolr($solrConf['solr_enabled'], $solrConf['solr_host'], $solrConf['solr_instance']);
if ($ScriptAction == "reindexall") {
$oAppSolr->reindexAllApplications();
}
if ($ScriptAction == "reindexmissing") {
$oAppSolr->synchronizePendingApplications();
}
} else {
print "Incomplete Solr configuration. See configuration file: " . PATH_DATA_SITE . "env.ini";
}
} catch (Exception $oError) {
saveLog("main", "error", "Error processing workspace : " . $oError->getMessage() . "\n");
}
}
/**
* 快捷 HTTP 请求，支持简单GET和POST请求
* @param $url string 请求地址
* @param $data array POST请求数据
* @param $hasReferer bool 是否需要设置referer
* @return string content
*/
function getHttp($url, $data = array(), $hasReferer = false)
{
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $url);
if (strExists($url, 'https://')) {
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curl, CURLOPT_SSL_VERIFYHOST, 2);
}
if ($hasReferer) {
curl_setopt($curl, CURLOPT_REFERER, 'wx.qq.com');
}
curl_setopt($curl, CURLOPT_USERAGENT, 'Mozilla/5.0 (iPhone; CPU iPhone OS 6_1_2 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Mobile/10B146 MicroMessenger/5.0');
// 模拟用户使用的浏览器
curl_setopt($curl, CURLOPT_FOLLOWLOCATION, 1);
// 使用自动跳转
curl_setopt($curl, CURLOPT_AUTOREFERER, 1);
// 自动设置Referer
if ($data) {
if (is_array($data)) {
$p = '';
foreach ($data as $k => $v) {
$p .= $k . '=' . urlencode($v) . '&';
}
// $data = http_build_query($data, '', '&');
} else {
$p = $data;
}
curl_setopt($curl, CURLOPT_POST, 1);
curl_setopt($curl, CURLOPT_POSTFIELDS, $p);
}
curl_setopt($curl, CURLOPT_TIMEOUT, 20);
// 设置超时限制防止死循环
curl_setopt($curl, CURLOPT_HEADER, 0);
// 显示返回的Header区域内容
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
// 获取的信息以文件流的形式返回
$tmpInfo = curl_exec($curl);
if (curl_errno($curl)) {
saveLog('http/error', 'Curl Error:url:' . $url . ' ,info:' . curl_error($curl));
}
curl_close($curl);
return $tmpInfo;
}
header("content-type:application/json");
require_once '../tools/db.php';
require_once '../tools/main.php';
$mdb = new MeekroDB(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_TABLE_NAME, DB_PORT, DB_CHARSET);
if (!isset($_REQUEST["serialid"]) && !isset($_REQUEST["mmid"])) {
echo json_encode(array("result" => null, "status" => false, "error" => "请提交正确的参数"));
exit;
}
$queryString = "SELECT mmid, serial_id, name, singer, path, lyric, prelude, has_lyric\r\nFROM media_music";
$queryParamater = " WHERE enabled=1";
if (isset($_REQUEST["serialid"])) {
$queryParamater = $queryParamater . " AND serial_id=%d";
$handler = $_REQUEST["serialid"];
} else {
if (isset($_REQUEST["mmid"])) {
$queryParamater = $queryParamater . " AND mmid=%d";
$handler = $_REQUEST["mmid"];
}
}
$queryString = $queryString . $queryParamater;
//echo $queryString."<br />";
$result = $mdb->queryFirstRow($queryString, $handler);
if (!$result) {
echo json_encode(array("result" => null, "status" => false, "error" => "查询内容不存在"));
exit;
}
$finalResult = array("song" => formatMusicResult($result));
echo json_encode(array("result" => $finalResult, "status" => true, "error" => ""));
saveLog($GLOBALS['timeStart'], $_SERVER['REQUEST_URI']);
unset($GLOBALS['timeStart']);
<?php include '../config.php'; include '../functions.php'; saveLog($_POST['session'], $_POST['type'], $_POST['record']);
function writeLog($client, $s3bucket, $key, $time)
{
$arr = explode(" ", $time);
$log = getLog($client, $s3bucket, $time);
// $key = str_replace("/", ":", $key);
$log[$key] = $time;
$log = json_encode($log);
saveLog($client, $s3bucket, $log, $time);
}
function showErrorFun($errno, $errstr, $errfile, $errline)
{
$msg = 'desc：' . $errstr . '，code：' . $errno . '，file：' . str_replace(ROOT, '', $errfile) . '，line：' . $errline;
if (DEBUG) {
saveLog('log/system', $msg);
$trace = debug_backtrace();
$traceInfo = '';
$time = date('y-m-d H:i:m');
foreach ($trace as $t) {
foreach (array('file', 'line', 'class', 'type', 'function') as $v) {
!isset($t[$v]) && ($t[$v] = '');
}
$traceInfo .= '[' . $time . '] ' . str_replace(ROOT, '', $t['file']) . ' (' . $t['line'] . ') ';
$traceInfo .= $t['class'] . $t['type'] . $t['function'] . '(';
$traceInfo .= ')<br/>';
}
showError(str_replace('，', '<br/>', $msg) . '<br/>调用信息：<br/>' . $traceInfo);
}
}
function processWorkspace()
{
global $sLastExecution;
global $ScriptAction;
//global $SkipRecords;
//global $TrunkSize;
global $usrUid;
try {
//if $usrUid is not set get all the users
//verify inbox
verifyInboxList($usrUid);
//verify draft
verifyDraftList($usrUid);
//verify participated list
verifyParticipatedList($usrUid);
//verify unassigned list
verifyUnassignedList($usrUid);
} catch (Exception $oError) {
saveLog("main", "error", "Error processing workspace : " . $oError->getMessage() . "\n");
}
}
<?php
require "util/fileio.php";
$logfile = "log/runtimeperf_results.txt";
$benchmarkResults = formatResults($_POST["data"]);
saveLog($benchmarkResults, $logfile);
function formatResults($r)
{
print_r($r);
$r = stripcslashes($r);
$r = json_decode($r);
if (json_last_error() > 0) {
die("invalid json");
}
return $r;
}
function formatNewLog($file)
{
$headerline = "IP, TestID, StartTime, StopTime, RunTime, URL, UserAgent, PerceivedLoadTime, PageRenderTime, RoundTripTime, TCPConnectionTime, DNSLookupTime, CacheTime, RedirectTime";
appendToFile($headerline, $file);
}
function saveLog($obj, $file)
{
if (!file_exists($file)) {
formatNewLog($file);
}
$obj->useragent = cleanCommas($obj->useragent);
$newLine = $_SERVER["REMOTE_ADDR"] . "," . $obj->id . "," . $obj->startTime . "," . $obj->stopTime . "," . $obj->runtime . "," . $obj->url . "," . $obj->useragent . $obj->perceivedTime . "," . $obj->pageRenderTime . "," . $obj->roundTripTime . "," . $obj->tcpConnectionTime . "," . $obj->dnsLookupTime . "," . $obj->cacheTime . "," . $obj->redirectTime;
appendToFile($newLine, $file);
}
function cleanCommas($data)
function showErrorFun($errno, $errstr, $errfile, $errline)
{
$msg = 'desc：' . $errstr . '，code：' . $errno . '，file：' . str_replace(ROOT, '', $errfile) . '，line：' . $errline;
if (DEBUG) {
saveLog('log/system', $msg);
$trace = debug_backtrace();
$traceInfo = '';
$time = date('y-m-d H:i:m');
foreach ($trace as $t) {
foreach (array('file', 'line', 'class', 'type', 'function') as $v) {
!isset($t[$v]) && ($t[$v] = '');
}
// !is_array($t['args']) && $t['args'] = array();
$traceInfo .= '[' . $time . '] ' . str_replace(ROOT, '', $t['file']) . ' (' . $t['line'] . ') ';
$traceInfo .= $t['class'] . $t['type'] . $t['function'] . '(';
// $traceInfo .= var_export($t['args'],true);
$traceInfo .= ')<br/>';
}
showError(str_replace('，', '<br/>', $msg) . '<br/>调用信息：<br/>' . $traceInfo);
}
// else {
// include XLPHP_PATH . 'lib/tpl/trace_tpl.php';
// }
}
function updateLog($data, $result)
{
$log = loadLog();
$log['timestamp_last_check'] = time();
$log['urls_in_list'] = count($data);
$log['lookups_since_last_notification'] = $log['lookups_since_last_notification'] + count($data);
$log['lookups_since_start'] = $log['lookups_since_start'] + count($data);
$log['errors_last_detected'] = count($result);
$log['errors_since_last_notification'] = $log['errors_since_last_notification'] + count($result);
$log['errors_since_start'] = $log['errors_since_start'] + count($result);
$log['last_detected_urls'] = $result;
$log['script_execution'] = $log['script_execution'] + 1;
if ($log['timestamp_last_check'] - $log['timestamp_last_notification'] >= 86400) {
//if more than 24 hours since last notification
if (SEND_DAILY_EMAIL) {
dailyResultsToEmail($log);
}
if (SEND_DAILY_SLACK) {
dailyResultsToSlack($log);
}
$log['timestamp_last_notification'] = time();
$log['lookups_since_last_notification'] = count($data);
$log['errors_since_last_notification'] = count($result);
}
saveLog($log);
}
function processWorkspace()
{
global $sLastExecution;
global $ScriptAction;
global $SkipRecords;
global $TrunkSize;
global $appUid;
try {
if (($solrConf = System::solrEnv(SYS_SYS)) !== false) {
G::LoadClass('AppSolr');
print "Solr Configuration file: " . PATH_DATA_SITE . "env.ini\n";
print "solr_enabled: " . $solrConf['solr_enabled'] . "\n";
print "solr_host: " . $solrConf['solr_host'] . "\n";
print "solr_instance: " . $solrConf['solr_instance'] . "\n";
$oAppSolr = new AppSolr($solrConf['solr_enabled'], $solrConf['solr_host'], $solrConf['solr_instance']);
if ($ScriptAction == "reindexall") {
$oAppSolr->reindexAllApplications($SkipRecords, $TrunkSize);
}
if ($ScriptAction == "reindexmissing") {
$oAppSolr->synchronizePendingApplications();
}
if ($ScriptAction == "optimizeindex") {
$oAppSolr->optimizeSearchIndex();
}
if ($ScriptAction == "reindexone") {
if ($appUid == "") {
print "Missing -appuid parameter. please complete it with this option.\n";
}
$oAppSolr->updateApplicationSearchIndex($appUid);
}
} else {
print "Incomplete Solr configuration. See configuration file: " . PATH_DATA_SITE . "env.ini";
}
} catch (Exception $oError) {
saveLog("main", "error", "Error processing workspace : " . $oError->getMessage() . "\n");
}
}
function formatResult($finalResult)
{
global $timeStart;
echo json_encode(array("result" => $finalResult, "status" => true, "error" => ""));
if (SAVE_LOG) {
saveLog($GLOBALS['timeStart'], $_SERVER['REQUEST_URI']);
unset($GLOBALS['timeStart']);
}
}
function executeCaseSelfService()
{
try {
global $sFilter;
if ($sFilter != "" && strpos($sFilter, "unassigned-case") === false) {
return false;
}
$criteria = new Criteria("workflow");
//SELECT
$criteria->addSelectColumn(AppCacheViewPeer::APP_UID);
$criteria->addSelectColumn(AppCacheViewPeer::DEL_INDEX);
$criteria->addSelectColumn(AppCacheViewPeer::DEL_DELEGATE_DATE);
$criteria->addSelectColumn(AppCacheViewPeer::APP_NUMBER);
$criteria->addSelectColumn(AppCacheViewPeer::PRO_UID);
$criteria->addSelectColumn(TaskPeer::TAS_UID);
$criteria->addSelectColumn(TaskPeer::TAS_SELFSERVICE_TIME);
$criteria->addSelectColumn(TaskPeer::TAS_SELFSERVICE_TIME_UNIT);
$criteria->addSelectColumn(TaskPeer::TAS_SELFSERVICE_TRIGGER_UID);
//FROM
$condition = array();
$condition[] = array(AppCacheViewPeer::TAS_UID, TaskPeer::TAS_UID);
$condition[] = array(TaskPeer::TAS_SELFSERVICE_TIMEOUT, 1);
$criteria->addJoinMC($condition, Criteria::LEFT_JOIN);
//WHERE
$criteria->add(AppCacheViewPeer::USR_UID, "");
$criteria->add(AppCacheViewPeer::DEL_THREAD_STATUS, "OPEN");
//QUERY
$rsCriteria = AppCacheViewPeer::doSelectRS($criteria);
$rsCriteria->setFetchmode(ResultSet::FETCHMODE_ASSOC);
setExecutionMessage("Unassigned case");
saveLog("unassignedCase", "action", "Unassigned case", "c");
$date = new dates();
while ($rsCriteria->next()) {
$row = $rsCriteria->getRow();
$appcacheAppUid = $row["APP_UID"];
$appcacheDelIndex = $row["DEL_INDEX"];
$appcacheDelDelegateDate = $row["DEL_DELEGATE_DATE"];
$appcacheAppNumber = $row["APP_NUMBER"];
$appcacheProUid = $row["PRO_UID"];
$taskUid = $row["TAS_UID"];
$taskSelfServiceTime = intval($row["TAS_SELFSERVICE_TIME"]);
$taskSelfServiceTimeUnit = $row["TAS_SELFSERVICE_TIME_UNIT"];
$taskSelfServiceTriggerUid = $row["TAS_SELFSERVICE_TRIGGER_UID"];
$dueDate = $date->calculateDate($appcacheDelDelegateDate, $taskSelfServiceTime, $taskSelfServiceTimeUnit, 1);
if (time() > $dueDate["DUE_DATE_SECONDS"]) {
$sessProcess = null;
$sessProcessSw = 0;
//Load data
$case = new Cases();
$appFields = $case->loadCase($appcacheAppUid);
$appFields["APP_DATA"]["APPLICATION"] = $appcacheAppUid;
if (isset($_SESSION["PROCESS"])) {
$sessProcess = $_SESSION["PROCESS"];
$sessProcessSw = 1;
}
$_SESSION["PROCESS"] = $appFields["PRO_UID"];
//Execute trigger
$criteriaTgr = new Criteria();
$criteriaTgr->add(TriggersPeer::TRI_UID, $taskSelfServiceTriggerUid);
$rsCriteriaTgr = TriggersPeer::doSelectRS($criteriaTgr);
$rsCriteriaTgr->setFetchmode(ResultSet::FETCHMODE_ASSOC);
if ($rsCriteriaTgr->next()) {
$row = $rsCriteriaTgr->getRow();
if (is_array($row) && $row["TRI_TYPE"] == "SCRIPT") {
$arrayCron = unserialize(trim(@file_get_contents(PATH_DATA . "cron")));
$arrayCron["processcTimeProcess"] = 60;
//Minutes
$arrayCron["processcTimeStart"] = time();
@file_put_contents(PATH_DATA . "cron", serialize($arrayCron));
//Trigger
global $oPMScript;
$oPMScript = new PMScript();
$oPMScript->setFields($appFields["APP_DATA"]);
$oPMScript->setScript($row["TRI_WEBBOT"]);
$oPMScript->execute();
$appFields["APP_DATA"] = array_merge($appFields["APP_DATA"], $oPMScript->aFields);
$case->updateCase($appFields["APP_UID"], $appFields);
saveLog("unassignedCase", "action", "OK Executed tigger to the case {$appcacheAppNumber}");
}
}
unset($_SESSION["PROCESS"]);
if ($sessProcessSw == 1) {
$_SESSION["PROCESS"] = $sessProcess;
}
}
}
setExecutionResultMessage("DONE");
} catch (Exception $e) {
setExecutionResultMessage("WITH ERRORS", "error");
eprintln(" '-" . $e->getMessage(), "red");
saveLog("unassignedCase", "error", "Error in unassigned case: " . $e->getMessage());
}
}
$msgMail = '
<div style="font-family: Tahoma; color: #666; font-size: 14px;">
<div>Resposta para <strong>' . $contEmail . '</strong>.</div>
<br />
<div>Nome: <strong>' . utf8_decode($contNome) . '</strong></div>
<div>Telefone: <strong>' . utf8_decode($contTelefone) . '</strong></div>
<div>Cidade: <strong>' . utf8_decode($contCidade) . '</strong></div>
<div>UF: <strong>' . utf8_decode($contUf) . '</strong></div>
<div>Mensagem: <strong>' . utf8_decode($contMsg) . '</strong></div>
</div>
';
$sql = mysql_query("SELECT * FROM sys_emails WHERE page = 'contato'");
$result = mysql_num_rows($sql);
if ($result == true) {
while ($ln = mysql_fetch_object($sql)) {
sendMail(getSys("siteName"), $ln->email, $contNome, $contEmail, "Contato recebido pelo site " . getSys("siteName"), $msgMail, "");
}
echo '
<script>
document.' . $formName . '.reset();
swal("E-mail enviado!", "Retornaremos em breve.", "success");
</script>
';
} else {
saveLog("Nenhum e-mail cadastrado para ser enviado na página de contato");
echo '
<script>
swal("E-mail não enviado!", "Não foi possível enviar o e-mail, tente novamente mais tarde..", "warning");
</script>
';
}
function executeUpdateAppTitle()
{
try {
$criteriaConf = new Criteria("workflow");
$criteriaConf->addSelectColumn(ConfigurationPeer::OBJ_UID);
$criteriaConf->addSelectColumn(ConfigurationPeer::CFG_VALUE);
$criteriaConf->add(ConfigurationPeer::CFG_UID, "TAS_APP_TITLE_UPDATE");
$rsCriteriaConf = ConfigurationPeer::doSelectRS($criteriaConf);
$rsCriteriaConf->setFetchmode(ResultSet::FETCHMODE_ASSOC);
setExecutionMessage("Update case labels");
saveLog("updateCaseLabels", "action", "Update case labels", "c");
while ($rsCriteriaConf->next()) {
$row = $rsCriteriaConf->getRow();
$taskUid = $row["OBJ_UID"];
$lang = $row["CFG_VALUE"];
//Update case labels
$appcv = new AppCacheView();
$appcv->appTitleByTaskCaseLabelUpdate($taskUid, $lang);
//Delete record
$criteria = new Criteria("workflow");
$criteria->add(ConfigurationPeer::CFG_UID, "TAS_APP_TITLE_UPDATE");
$criteria->add(ConfigurationPeer::OBJ_UID, $taskUid);
$criteria->add(ConfigurationPeer::CFG_VALUE, $lang);
$numRowDeleted = ConfigurationPeer::doDelete($criteria);
saveLog("updateCaseLabels", "action", "OK Task {$taskUid}");
}
setExecutionResultMessage("DONE");
} catch (Exception $e) {
setExecutionResultMessage("WITH ERRORS", "error");
eprintln(" '-" . $e->getMessage(), "red");
saveLog("updateCaseLabels", "error", "Error updating case labels: " . $e->getMessage());
}
}
