Esempio n. 1
0
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}'";
Esempio n. 3
0
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" />