feat: 增加公交广告中的优惠券功能

wlzboy

2025-09-06 2decf5219e3476e30095fd9dbf6e49c55e105563

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
<?php require '/inc/odbc.php';?> 
<?php 
 
//获取access_token(系统提示) 
Function GetAccess_token_1000006() { 
    global $conn; 
    $access_tokenID=6089;    //对应数据库ID  
    $corpid="wx248505bfbab6d0c1"; 
    $corpsecret="zXfzkk8wBJIZjrxq7BwZ1ckG2505cpNuSlJH1m8i-6Y"; 
    $sql="select vtext,vMono from dictionary where id=$access_tokenID"; 
    $data = sqlsrv_query($conn,$sql); 
    if($data == true){ 
        if (sqlsrv_rows_affected($data)!=0) { 
            while($rs = sqlsrv_fetch_array($data) ) { 
                $access_token=$rs["vtext"]; 
                $access_token_time=date_timestamp_get(date_create($rs["vMono"])); 
                if (time() >= $access_token_time) { 
                    //获取新的access_token 
                    $api_url="https://qyapi.weixin.qq.com/cgi-bin/gettoken?corpid=$corpid&corpsecret=$corpsecret"; 
                    $api_info=file_get_contents($api_url); 
                    $api_info=json_decode($api_info,true); 
                    $errcode = $api_info["errcode"]; 
                    if ($errcode==0) { 
                        $access_token=$api_info["access_token"]; 
                        //echo $access_token; 
                        //写入数据库 
                        $sql="update dictionary set vtext='".$access_token."',vMono='".date("Y-m-d H:i:s",time()+7100)."' where id=$access_tokenID"; 
                        $UPsql = sqlsrv_query($conn,$sql); 
                    } 
                } 
            } 
        } 
    } 
    return $access_token; 
} 
 
//获取access_token(调度分派) 
Function GetAccess_token_21() { 
    global $conn; 
    $access_tokenID=1;    //对应数据库ID  
    $corpid="wx248505bfbab6d0c1"; 
    $corpsecret="2MCilqWYC0FWjOQ894sbb-s7Lb5sVH4HHuJgOsd9l1k"; 
    $sql="select vtext,vMono from dictionary where id=$access_tokenID"; 
    $data = sqlsrv_query($conn,$sql); 
    if($data == true){ 
        if (sqlsrv_rows_affected($data)!=0) { 
            while($rs = sqlsrv_fetch_array($data) ) { 
                $access_token=$rs["vtext"]; 
                $access_token_time=date_timestamp_get(date_create($rs["vMono"])); 
                if (time() >= $access_token_time) { 
                    //获取新的access_token 
                    $api_url="https://qyapi.weixin.qq.com/cgi-bin/gettoken?corpid=$corpid&corpsecret=$corpsecret"; 
                    $api_info=file_get_contents($api_url); 
                    $api_info=json_decode($api_info,true); 
                    $errcode = $api_info["errcode"]; 
                    if ($errcode==0) { 
                        $access_token=$api_info["access_token"]; 
                        //echo $access_token; 
                        //写入数据库 
                        $sql="update dictionary set vtext='".$access_token."',vMono='".date("Y-m-d H:i:s",time()+7100)."' where id=$access_tokenID"; 
                        $UPsql = sqlsrv_query($conn,$sql); 
                    } 
                } 
            } 
        } 
    } 
    return $access_token; 
} 
 
//获取access_token(合作报表) 
Function GetAccess_token_1000004() { 
    global $conn; 
    $access_tokenID=5698;    //对应数据库ID  
    $corpid="wx248505bfbab6d0c1"; 
    $corpsecret="6fuEHzsvx0KGuZyjoDic9W1YNsbOzWP65_rj3s3gm-E"; 
    $sql="select vtext,vMono from dictionary where id=$access_tokenID"; 
    $data = sqlsrv_query($conn,$sql); 
    if($data == true){ 
        if (sqlsrv_rows_affected($data)!=0) { 
            while($rs = sqlsrv_fetch_array($data) ) { 
                $access_token=$rs["vtext"]; 
                $access_token_time=date_timestamp_get(date_create($rs["vMono"])); 
                if (time() >= $access_token_time) { 
                    //获取新的access_token 
                    $api_url="https://qyapi.weixin.qq.com/cgi-bin/gettoken?corpid=$corpid&corpsecret=$corpsecret"; 
                    $api_info=file_get_contents($api_url); 
                    $api_info=json_decode($api_info,true); 
                    $errcode = $api_info["errcode"]; 
                    if ($errcode==0) { 
                        $access_token=$api_info["access_token"]; 
                        //echo $access_token; 
                        //写入数据库 
                        $sql="update dictionary set vtext='".$access_token."',vMono='".date("Y-m-d H:i:s",time()+7100)."' where id=$access_tokenID"; 
                        $UPsql = sqlsrv_query($conn,$sql); 
                    } 
                } 
            } 
        } 
    } 
    return $access_token; 
} 
 
//获取access_token(优惠券生成) 
Function GetAccess_token_1000016() { 
    global $conn; 
    $access_tokenID=7056;    //对应数据库ID  
    $corpid="wx248505bfbab6d0c1"; 
    $corpsecret="zXfzkk8wBJIZjrxq7BwZ1ckG2505cpNuSlJH1m8i-6Y"; 
    $sql="select vtext,vMono from dictionary where id=$access_tokenID"; 
    $data = sqlsrv_query($conn,$sql); 
    if($data == true){ 
        if (sqlsrv_rows_affected($data)!=0) { 
            while($rs = sqlsrv_fetch_array($data) ) { 
                $access_token=$rs["vtext"]; 
                $access_token_time=date_timestamp_get(date_create($rs["vMono"])); 
                if (time() >= $access_token_time) { 
                    //获取新的access_token 
                    $api_url="https://qyapi.weixin.qq.com/cgi-bin/gettoken?corpid=$corpid&corpsecret=$corpsecret"; 
                    $api_info=file_get_contents($api_url); 
                    $api_info=json_decode($api_info,true); 
                    $errcode = $api_info["errcode"]; 
                    if ($errcode==0) { 
                        $access_token=$api_info["access_token"]; 
                        //echo $access_token; 
                        //写入数据库 
                        $sql="update dictionary set vtext='".$access_token."',vMono='".date("Y-m-d H:i:s",time()+7100)."' where id=$access_tokenID"; 
                        $UPsql = sqlsrv_query($conn,$sql); 
                    } 
                } 
            } 
        } 
    } 
    return $access_token; 
} 
 
//获取access_token(通讯录同步专用 https://work.weixin.qq.com/wework_admin/frame#apps/contactsApi) 
Function GetAccess_token_contactsApi() { 
    global $conn; 
    $access_tokenID=6557;    //对应数据库ID  
    $corpid="wx248505bfbab6d0c1"; 
    $corpsecret="TjLL-dIOllJ_-WeF8N90DVzWn02vva4Xuf3PlytgDSo"; 
    $sql="select vtext,vMono from dictionary where id=$access_tokenID"; 
    $data = sqlsrv_query($conn,$sql); 
    if($data == true){ 
        if (sqlsrv_rows_affected($data)!=0) { 
            while($rs = sqlsrv_fetch_array($data) ) { 
                $access_token=$rs["vtext"]; 
                $access_token_time=date_timestamp_get(date_create($rs["vMono"])); 
                if (time() >= $access_token_time) { 
                    //获取新的access_token 
                    $api_url="https://qyapi.weixin.qq.com/cgi-bin/gettoken?corpid=$corpid&corpsecret=$corpsecret"; 
                    $api_info=file_get_contents($api_url); 
                    $api_info=json_decode($api_info,true); 
                    $errcode = $api_info["errcode"]; 
                    if ($errcode==0) { 
                        $access_token=$api_info["access_token"]; 
                        //echo $access_token; 
                        //写入数据库 
                        $sql="update dictionary set vtext='".$access_token."',vMono='".date("Y-m-d H:i:s",time()+7100)."' where id=$access_tokenID"; 
                        $UPsql = sqlsrv_query($conn,$sql); 
                    } 
                } 
            } 
        } 
    } 
    return $access_token; 
} 
?>