function getTransactionsByStatus($conn) { global $codeParser; $globalData = new GlobalData(); $status = trim($_GET["status"]); $startDate = trim($_GET["startDate"]); $endDate = trim($_GET["endDate"]); $follower = trim($_GET["follower"]); $query = "set names utf8"; $result = $conn->query($query); $query = "SELECT T_transaction.transactionId,T_transaction.createdDt,T_transaction.follower,T_transaction.parentOpenid, " . "T_parent.nickname, T_parent.mobile,T_child.subject, T_child.grade, T_child.interest, T_child.expected_price, " . "T_child.expectedTeacherGender, T_child.expectedLocation, T_transaction.teacherOpenid, " . "T_teacher.name as teacherName, T_teacher.mobile as teacherMobile, T_transaction.trialTime, T_transaction.fixedTime, " . "T_transaction.fee, T_transaction.location, T_transaction.status,T_transaction.comment FROM T_parent, T_child, `T_transaction` " . "LEFT JOIN T_teacher ON T_transaction.teacherOpenid = T_teacher.openId WHERE T_transaction.parentOpenid = T_parent.openId and " . "T_transaction.childId = T_child.childId"; if ($status == '2') { $query = $query . " and T_transaction.status = 2 and T_parent.mobile != ''"; } else { $query = $query . " and T_transaction.status = '{$status}'"; } if ($startDate != '') { $query = $query . " and T_transaction.createdDt > '{$startDate}'"; } if ($endDate != '') { $query = $query . " and T_transaction.createdDt < '{$endDate}'"; } if ($follower != 'All') { $query = $query . " and T_transaction.follower = '{$follower}'"; } $whiteList = $globalData->getWhiteList(); $query = $query . " and T_transaction.parentOpenid not in {$whiteList}"; $query = $query . " order by status, createdDt desc"; $result = $conn->query($query); $jsonArray = array('transactionId' => array(), 'createdDt' => array(), 'follower' => array(), 'parentOpenId' => array(), 'nickname' => array(), 'mobile' => array(), 'grade' => array(), 'subject' => array(), 'interest' => array(), 'expected_price' => array(), 'expectedTeacherGender' => array(), 'expectedLocation' => array(), 'teacherName' => array(), 'teacherMobile' => array(), 'trialTime' => array(), 'fixedTime' => array(), 'fee' => array(), 'location' => array(), 'status' => array(), 'comment' => array()); while ($row = $result->fetch_assoc()) { array_push($jsonArray["transactionId"], $row["transactionId"]); array_push($jsonArray["createdDt"], $row["createdDt"]); array_push($jsonArray["follower"], $row["follower"]); array_push($jsonArray["parentOpenId"], $row["parentOpenid"]); array_push($jsonArray["nickname"], $row["nickname"]); array_push($jsonArray["mobile"], $row["mobile"]); array_push($jsonArray["grade"], $row["grade"]); array_push($jsonArray["subject"], $codeParser->getSubject($row["subject"])); array_push($jsonArray["interest"], $codeParser->getInterestName($row["interest"], $conn)); array_push($jsonArray["expected_price"], $codeParser->getExpectedPrice($row["expected_price"])); array_push($jsonArray["expectedTeacherGender"], $codeParser->getExpectedGender($row["expectedTeacherGender"])); array_push($jsonArray["expectedLocation"], $codeParser->getExpectedLocation($row["expectedLocation"])); array_push($jsonArray["teacherName"], $codeParser->handleNullValue($row["teacherName"])); array_push($jsonArray["teacherMobile"], $codeParser->handleNullValue($row["teacherMobile"])); array_push($jsonArray["trialTime"], $row["trialTime"]); array_push($jsonArray["fixedTime"], $row["fixedTime"]); array_push($jsonArray["fee"], $row["fee"]); array_push($jsonArray["location"], $row["location"]); array_push($jsonArray["status"], $codeParser->getStatusDescription($row["status"])); array_push($jsonArray["comment"], $row["comment"]); } echo json_encode($jsonArray); }
<?php require_once "globalData.php"; $globalData = new GlobalData(); $conn = new mysqli($globalData->getMysqlHost(), $globalData->getMysqlUsername(), $globalData->getMysqlPassword(), $globalData->getMysqlDatabase()); function getTeacherInformation($openId, $conn) { $jsonArray = array(); //1,获取个人基本信息 $query = "set names utf8"; $result = $conn->query($query); $query = "select * from T_teacher where openId = '{$openId}'"; $result = $conn->query($query); $row = $result->fetch_assoc(); $jsonArray = $row; $jsonArray["options"] = array("name" => array(), "code" => array(), "typeCode" => array()); $jsonArray["certificate"] = array("desc" => array(), "imgUrl" => array()); //2,获取可教科目 $query = "set names utf8"; $result = $conn->query($query); $query = "select name,code,typeCode from T_offers where teacherOpenId = '{$openId}' and status != 'D'"; $result = $conn->query($query); while ($row = $result->fetch_assoc()) { array_push($jsonArray["options"]["name"], $row["name"]); array_push($jsonArray["options"]["code"], $row["code"]); array_push($jsonArray["options"]["typeCode"], $row["typeCode"]); } //3,获取证书 $query = "set names utf8"; $result = $conn->query($query); $query = "select description, imageUrl from T_teacher_certifications where teacherOpenId = '{$openId}'";
require_once "config.php"; require_once "globalData.php"; require_once 'vendor/autoload.php'; use Qiniu\Auth; $openid = ""; if (isset($_GET['code'])) { $code = $_GET['code']; $access_token_get_url = "https://api.weixin.qq.com/sns/oauth2/access_token?appid=" . $appid . "&secret=" . $secret . "&code=" . $code . "&grant_type=authorization_code"; $access_token_json = file_get_contents($access_token_get_url); $json_obj = json_decode($access_token_json, true); $openid = $json_obj["openid"]; } else { exit("NO CODE"); //$openid = "obS35vk9Hqwl4WZXsosjxm_hckKQ"; } $globalData = new GlobalData(); if (strpos($globalData->getWhiteList(), $openid) == '') { exit("该功能目前尚未开放."); } $accessKey = 'k7HBysPt-HoUz4dwPT6SZpjyiuTdgmiWQE-7qkJ4'; $secretKey = 'BuaBzxTxNsNUBSy1ZvFUAfUbj8GommyWbfJ0eQ2R'; $auth = new Auth($accessKey, $secretKey); $bucket = 'wojiaonixue'; $token = $auth->uploadToken($bucket); ?> <!DOCTYPE html> <html lang="zh-CN"> <head> <meta charset="utf-8"> <title>手工录入订单</title> <meta name="viewport" content="width=device-width,initial-scale=1.0,maximum-scale=1.0,user-scalable=0" />