$page = is_numeric($_REQUEST['page']) && $_REQUEST['page'] > 0 ? $_REQUEST['page'] : 1;
    if ($page > $total_page) {
        $page = $total_page;
    }
    if ($page < 1) {
        $page = 1;
    }
    $offset = ($page - 1) * $page_size;
    $limit = $page_size;
    $extra_params['provider_id'] = $_REQUEST['provider_id'];
    //查找开票清单明细
    $sql = "select pir.purchase_invoice_request_id,p.provider_name,pir.created_stamp,pir.created_user,pir.status,pir.total_net_cost,total_cost\r\n        from romeo.purchase_invoice_request pir\r\n        left join ecshop.ecs_provider p on p.provider_id = pir.supplier_id" . $sql_add . "order by pir.created_stamp desc \r\n        limit {$limit} offset {$offset} \r\n        ";
    $purchase_invoice_request_list = $db->getAll($sql);
    $smarty->assign('purchase_invoice_request_list', $purchase_invoice_request_list);
    $pagination = new Pagination($total, $page_size, $page, 'page', $url = 'purchase_invoice_request_list_new.php?act=search', null, $extra_params);
    $smarty->assign('pagination', $pagination->get_simple_output());
    // 分页
    $smarty->assign('start_time', $start_time);
    //开始时间
    $smarty->assign('end_time', $end_time);
    //结束时间
    $smarty->assign('provider_name', $provider_name);
}
//新建开票清单
if ($act == 'purchase_invoice_request_add') {
    $user_name = $_SESSION['admin_name'];
    $provider_id = $_REQUEST['provider_id'];
    $provider_code = get_provider_code($provider_id);
    $note = $_REQUEST['note'];
    $date = date('Ymd', time());
    $number = get_sequence_number($date);