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; }