php如何不暴露接口,php函数API接口的一段代码,不为什么就是想放在这里

public function getRealTime()

{

global $db, $res;

dbc();

@$p = $_GET['page'] == "" ? 1 : $_GET['page'];//获取用户选择的页码

@$pagesize = $_GET['limit'] == "" ? 10 : $_GET['limit'];//获取用户选择的每页显示多少条数据

@$keys = $_GET['keys'];//获取用户选择的每页显示多少条数据

@$fromTime = $_GET['fromTime'];//开始时间

@$toTime = $_GET['toTime'];//结束时间

@$limit = ($p - 1) * $pagesize;//偏移量

//筛选全部记录并随前端自动分页展示;

//$sql = "select a.uniacid,a.should_paid,a.id,a.paid_at,b.uniacid,a.status,a.leader_id,b.name,b.short_name,b.dpopen,a.user_id,c.userid,c.name AS leader_name,c.title,c.mobile,d.id,d.name AS member_name,d.phone,CONCAT(d.city,d.area) AS member_address from " . $db->table('orders');

$sql = "select a.uniacid,a.should_paid,a.id,a.paid_at,b.uniacid,a.status,a.leader_id,a.all_num AS num,b.name,b.short_name,b.dpopen,a.user_id,c.userid,c.name AS leader_name,c.title,c.mobile,d.id,d.name AS member_name,CONCAT(d.address_name,d.address_other) AS member_address,d.phone,e.order_id,e.pro_id,f.id,f.name AS pname,f.unit from " . $db->table('orders');

$sql .= " AS a, " . $db->table('set_basic') . " AS b, " . $db->table('leader') . " AS c," . $db->table('member') . " AS d," . $db->table('order_items') . " AS e," . $db->table('products') . " AS f";

$sql .= " WHERE a.paid_at <> '' AND a.uniacid = b.uniacid AND b.dpopen = 1 AND a.leader_id = c.userid AND a.user_id = d.id AND a.id = e.order_id AND e.pro_id = f.id";

//按照站点筛选;

IF ($keys != "") {

$sql .= " AND a.uniacid = " . $keys;

}

//按照时间筛选;

IF ($fromTime != "") {

$sql .= " AND date_format(a.paid_at,'%Y-%m-%d') >= '$fromTime'";

}

IF ($toTime != "") {

$sql .= " AND date_format(a.paid_at,'%Y-%m-%d') <= '$toTime'";

}

$sql .= " ORDER BY a.paid_at DESC";

//信息记录;

$sql .= " LIMIT " . $limit . "," . $pagesize;

$row = $db->queryall($sql);

//获取总记录数量;

$sql_c = "select a.uniacid,a.should_paid,a.id,a.paid_at,b.uniacid,a.status,a.leader_id,a.all_num AS num,b.name,b.short_name,b.dpopen from " . $db->table('orders');

$sql_c .= " AS a, " . $db->table('set_basic') . " AS b";

$sql_c .= " WHERE a.paid_at <> '' AND a.uniacid = b.uniacid AND b.dpopen = 1";

//按照站点筛选;

IF ($keys != "") {

$sql_c .= " AND a.uniacid = " . $keys;

}

//按照时间筛选;

IF ($fromTime != "") {

$sql_c .= " AND date_format(a.paid_at,'%Y-%m-%d') >= '$fromTime'";

}

IF ($toTime != "") {

$sql_c .= " AND date_format(a.paid_at,'%Y-%m-%d') <= '$toTime'";

}

$sql_c .= " ORDER BY a.paid_at DESC";

$row_c = $db->queryall($sql_c);

$count = count($row_c);

$res['code'] = 0;

$res['count'] = $count;

$res["data"] = $row;

die(json_encode_lockdata($res));

}

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值