static function ExercuseQuery($sql)
{
// execute the SQL statement
DLOG("sql={$sql}");
$result = mysql_query($sql, self::GetConnection()) or die(mysql_error());
return $result;
}
static function SaveSetting($initial_money, $last_check_time)
{
DLOG("SaveSetting({$initial_money}, {$last_check_time})");
$sql = "UPDATE setting\n\t\t\t\tSET Value = '{$initial_money}'\n\t\t\t\tWHERE name = '" . self::INITIAL_MONEY . "'";
$result = CDataManager::ExercuseQuery($sql);
$sql = "UPDATE setting\n\t\t\t\tSET Value = '{$last_check_time}'\n\t\t\t\tWHERE name = '" . self::LAST_CHECK_TIME . "'";
$result &= CDataManager::ExercuseQuery($sql);
return $result;
}
function submit_edit_setting()
{
DLOG("submit_edit_setting()");
$initial_money = $_POST['InitialMoney'];
DLOG("initial_money={$initial_money}");
$last_check_time = mktime($_POST['setting_lastchecktime_hour'], $_POST['setting_lastchecktime_minute'], $_POST['setting_lastchecktime_second'], $_POST['setting_lastchecktime_month'], $_POST['setting_lastchecktime_day'], $_POST['setting_lastchecktime_year']);
DLOG("last_check_time={$last_check_time}");
return CSettingManager::SaveSetting($initial_money, $last_check_time);
}
function apply_filter($enable_filter)
{
if (!$enable_filter) {
return;
}
$filters = array();
$count = count($enable_filter);
for ($i = 0; $i < $count; $i++) {
$name = $enable_filter[$i];
switch ($name) {
case "category":
$filters['categories'] = $_POST['category_filter'];
break;
case "detail":
$filters['detail'] = $_POST['detail_text'];
break;
case "from_date":
$filters['from_date'] = mktime($_POST['filter_detail_from_date_hour'], $_POST['filter_detail_from_date_minute'], $_POST['filter_detail_from_date_second'], $_POST['filter_detail_from_date_month'], $_POST['filter_detail_from_date_day'], $_POST['filter_detail_from_date_year']);
break;
case "to_date":
$filters['to_date'] = mktime($_POST['filter_detail_to_date_hour'], $_POST['filter_detail_to_date_minute'], $_POST['filter_detail_to_date_second'], $_POST['filter_detail_to_date_month'], $_POST['filter_detail_to_date_day'], $_POST['filter_detail_to_date_year']);
break;
case "from_amount":
$filters['from_amount'] = $_POST['amount_from_filter'];
break;
case "to_amount":
$filters['to_amount'] = $_POST['amount_to_filter'];
break;
case "description":
$filters['description'] = $_POST['desc_text'];
break;
}
}
DLOG("Set filter");
$_SESSION['filters'] = $filters;
}
public function code_to_openID($code)
{
if (empty($code) == true) {
DLOG("获取的code为空", "run", "caodi");
exit;
}
$appid = $this->app_id;
$secret = $this->secret;
$url = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=" . $appid . "&secret=" . $secret . "&code=" . $code . "&grant_type=authorization_code";
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$result = curl_exec($ch);
DLOG("由OAuth2.0获取到的code转化成用户的openID的结果=" . $result, "run", "caodi");
curl_close($ch);
$user_info = json_decode($result, true);
$open_id = $user_info['openid'];
return $open_id;
}
function parse_description($desc_string)
{
DLOG("desc_string='{$desc_string}'");
$desc = $desc_string;
if (isset($desc) == false || strlen($desc) == 0) {
return "";
}
if ($desc[0] == '"') {
$len = strlen($desc);
$desc = substr($desc, 1, $len - 2);
}
return $desc;
}
