-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathgetPaidList.php
More file actions
30 lines (24 loc) · 1.48 KB
/
getPaidList.php
File metadata and controls
30 lines (24 loc) · 1.48 KB
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
<?php
header("content-type:text/html;charset=utf-8");
include_once(__DIR__."/common.php");
$data = initPostData();
$pageId = (int)$data['page'];
if($pageId<0){
die();
}
$result = array();
$result['code'] = 10;
$result['max_i'] = 19;
$result['date'] = "2022-1-1 ⭐新年快乐哒哟⭐";
/*
//需要增加一个pay_name大概,总不能日常实名上网
$con = pdo_database();
//pid(自增id),upd_date(更新日期),type(类型:待补充类型0,接收捐款1,活动支出2,押金收入3,押金支出4,利息收入5),pay_date(支付日期),pay_num(金额),pay_way(支付方式:待补充0,现金1,支付宝2,微信3,银行卡4,其它(在备注中补充)5),pay_image(支付截图),pay_name(支付人昵称),pay_openid(支付人openid),chk_way(报销方式:未报销0,微信1,支付宝2),chk_date(报销日期),chk_status(入账状态:待提审0,已入账1,需审核2,审核不通过,需修改3),chk_image(报销截图),chk_openid(审核人openid),detail(备注)
$sql = 'SELECT pid,pay_date,pay_num,check_way FROM `paid` WHERE check_status = 1 ORDER BY pay_date DESC LIMIT :pageId * 20,20';
$sth = $con->prepare($sql, array(PDO::ATTR_CURSOR => PDO::CURSOR_FWDONLY));
$sth->execute(array(':pageId' => $pageId));
$res = $sth->fetchAll(PDO::FETCH_ASSOC);
$result['paidList'] = json_encode($res,JSON_UNESCAPED_UNICODE);
*/
// 然后还要单独走一个自己的待审核列表(可更新)和专供审核员的审核列表(可审核),审核后
echo json_encode($result);