$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);