getAll("SELECT id,name,plugin FROM pre_channel WHERE plugin IN ('alipay','alipaysl','alipayd','wxpayn','wxpaynp') ORDER BY id ASC");
$channel_select = '';
foreach($channels as $row){
$channel_select .= '';
}
$link = '';
$sql = " 1";
if(isset($_GET['value']) && !empty($_GET['value'])) {
$value=daddslashes($_GET['value']);
$sql .= " AND A.`{$_GET['column']}`='{$value}'";
$link .= '&column='.$_GET['column'].'&value='.urlencode($_GET['value']);
}
?>
分账规则修改/添加
分账规则列表
ID
支付通道
商户ID
接收方账号/姓名
分账比例
状态
操作
getColumn("SELECT count(*) from pre_psreceiver A WHERE{$sql}");
$pagesize=15;
$pages=ceil($numrows/$pagesize);
$page=isset($_GET['page'])?intval($_GET['page']):1;
$offset=$pagesize*($page - 1);
$rs=$DB->query("SELECT A.*,B.name channelname FROM pre_psreceiver A LEFT JOIN pre_channel B ON A.channel=B.id WHERE{$sql} order by A.id desc limit $offset,$pagesize");
while($res = $rs->fetch())
{
echo '