$smarty->assign('is_store_admin', $is_store_admin);
assign_query_info();
$smarty->display('store_rebate_info.htm');
} elseif ($_REQUEST['act'] == 'query') {
/* 检查权限 */
admin_priv('store_rebate');
$id = intval($_REQUEST['rid']);
$order_type = isset($_REQUEST['otype']) && intval($_REQUEST['otype']) > 0 ? intval($_REQUEST['otype']) : 0;
$rebate = rebateHave($id);
$nowtime = gmtime();
$rebate['rebate_paytime_start'] = local_date('Y.m.d', $rebate['rebate_paytime_start']);
$paytime_end = $rebate['rebate_paytime_end'];
$rebate['rebate_paytime_end'] = local_date('Y.m.d', $paytime_end);
$rebate['isdo'] = $paytime_end + $GLOBALS['_CFG']['okgoods_time'] * 3600 * 24 >= $nowtime ? 0 : 1;
$rebate['chadata'] = datecha($paytime_end + $GLOBALS['_CFG']['okgoods_time'] * 3600 * 24);
$rebate['caozuo'] = getRebateDo($rebate['status'], $rebate['rebate_id'], 'view');
if ($order_type == 0) {
$order_list = getOkOrder();
$display = 'rebate_store_order.htm';
} else {
$order_list = getBackHuanOrder();
$display = 'rebate_store_order2.htm';
}
$smarty->assign('rebate', $rebate);
$smarty->assign('order_list', $order_list['orders']);
$smarty->assign('filter', $order_list['filter']);
$smarty->assign('record_count', $order_list['record_count']);
$smarty->assign('page_count', $order_list['page_count']);
$sort_flag = sort_flag($order_list['filter']);
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
make_json_result($smarty->fetch($display), '', array('filter' => $order_list['filter'], 'page_count' => $order_list['page_count']));
/**
* 获取供应商列表信息
*
* @access public
* @param
*
* @return void
*/
function rebate_list($act = '')
{
$result = get_filter();
if ($result === false) {
//$aiax = isset($_GET['is_ajax']) ? $_GET['is_ajax'] : 0;
/* 过滤信息 */
$filter['rebate_paytime_start'] = !empty($_REQUEST['rebate_paytime_start']) ? local_strtotime($_REQUEST['rebate_paytime_start']) : 0;
$filter['rebate_paytime_end'] = !empty($_REQUEST['rebate_paytime_end']) ? local_strtotime($_REQUEST['rebate_paytime_end'] . " 23:59:59") : 0;
$filter['status'] = isset($_REQUEST['status']) ? intval($_REQUEST['status']) : -1;
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? ' sr.supplier_id' : trim($_REQUEST['sort_by']);
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? ' ASC' : trim($_REQUEST['sort_order']);
$filter['is_pay_ok'] = empty($_REQUEST['is_pay_ok']) ? '0' : intval($_REQUEST['is_pay_ok']);
$filter['actname'] = empty($act) ? trim($_REQUEST['act']) : $act;
$where = 'WHERE 1 ';
$where .= $filter['rebate_paytime_start'] ? " AND sr.rebate_paytime_start >= '" . $filter['rebate_paytime_start'] . "' " : " ";
$where .= $filter['rebate_paytime_end'] ? " AND sr.rebate_paytime_end <= '" . $filter['rebate_paytime_end'] . "' " : " ";
$where .= $filter['is_pay_ok'] ? " AND sr.is_pay_ok = '" . $filter['is_pay_ok'] . "' " : " AND sr.is_pay_ok = '0' ";
$where .= $filter['status'] > -1 ? " AND sr.status = '" . $filter['status'] . "' " : " ";
/* 分页大小 */
$filter['page'] = empty($_REQUEST['page']) || intval($_REQUEST['page']) <= 0 ? 1 : intval($_REQUEST['page']);
if (isset($_REQUEST['page_size']) && intval($_REQUEST['page_size']) > 0) {
$filter['page_size'] = intval($_REQUEST['page_size']);
} elseif (isset($_COOKIE['ECSCP']['page_size']) && intval($_COOKIE['ECSCP']['page_size']) > 0) {
$filter['page_size'] = intval($_COOKIE['ECSCP']['page_size']);
} else {
$filter['page_size'] = 15;
}
/* 记录总数 */
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('supplier_rebate') . " AS sr " . $where;
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
$filter['page_count'] = $filter['record_count'] > 0 ? ceil($filter['record_count'] / $filter['page_size']) : 1;
/* 查询 */
$sql = "SELECT sr.* , s.supplier_name, s.supplier_rebate " . "FROM " . $GLOBALS['ecs']->table("supplier_rebate") . " AS sr left join " . $GLOBALS['ecs']->table("supplier") . " AS s on sr.supplier_id=s.supplier_id \n {$where}\n ORDER BY " . $filter['sort_by'] . " " . $filter['sort_order'] . "\n LIMIT " . ($filter['page'] - 1) * $filter['page_size'] . ", " . $filter['page_size'] . " ";
set_filter($filter, $sql);
} else {
$sql = $result['sql'];
$filter = $result['filter'];
}
$list = array();
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res)) {
$row['sign'] = createSign($row['rebate_id'], $row['supplier_id']);
$row['rebate_paytime_start'] = local_date('Y.m.d', $row['rebate_paytime_start']);
$endtime = $row['rebate_paytime_end'];
//+$GLOBALS['_CFG']['tuihuan_days_qianshou']*3600*24;
$row['rebate_paytime_end'] = local_date('Y.m.d', $endtime);
//$row['all_money'] = $GLOBALS['db']->getOne("select sum(money_paid + surplus) from ". $GLOBALS['ecs']->table('order_info') ." where rebate_id=". $row['rebate_id'] ." and rebate_ispay=2");
$row['all_money'] = $GLOBALS['db']->getOne("select sum(" . order_amount_field() . ") from " . $GLOBALS['ecs']->table('order_info') . " where rebate_id=" . $row['rebate_id'] . " and rebate_ispay=2");
$row['all_money_formated'] = price_format($row['all_money']);
$row['rebate_money'] = round($row['all_money'] * $row['supplier_rebate'] / 100, 2);
$row['rebate_money_formated'] = price_format($row['rebate_money']);
$row['pay_money'] = $row['all_money'] - $row['rebate_money'];
$row['pay_money_formated'] = price_format($row['pay_money']);
$row['pay_status'] = $row['is_pay_ok'] ? "已处理，已返佣" : "未处理";
$row['pay_time'] = local_date('Y.m.d', $row['pay_time']);
$row['user'] = $_SESSION['user_name'];
$row['payable_price'] = price_format($row['payable_price']);
$row['status_name'] = rebateStatus($row['status']);
$row['caozuo'] = getRebateDo($row['status'], $row['rebate_id'], $filter['actname']);
$list[] = $row;
}
$arr = array('result' => $list, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
return $arr;
}
