/** * 获取出库单数据列表 */ public function act_getOutStoreList() { //查询条件初始化 $conditions = array(); $conditions[] = 'ioType=1'; if (isset($_GET['type']) && !empty($_GET['type'])) { //$conditions[] = 'ioType=2'; } if (isset($_GET['ordersn']) && !empty($_GET['ordersn'])) { $_ordersn = trim($_GET['ordersn']); if (preg_match("/^[a-z\\-]*[\\d]*\$/i", $_ordersn)) { $conditions[] = "ordersn='{$_ordersn}'"; } unset($_ordersn); } if (isset($_GET['iostatus']) && !empty($_GET['iostatus'])) { $conditions[] = "ioStatus=" . intval($_GET['iostatus']); } if (isset($_GET['storeid']) && !empty($_GET['storeid'])) { $conditions[] = "storeId=" . intval($_GET['storeid']); } if (isset($_GET['invoicetypeid']) && !empty($_GET['invoicetypeid'])) { $conditions[] = "invoiceTypeId=" . intval($_GET['invoicetypeid']); } if (isset($_GET['cStartTime']) && !empty($_GET['cStartTime'])) { $startTime = strtotime(intval($_GET['cStartTime']) . ' 00:00:00'); $conditions[] = "createdTime >='{$startTime}' "; } if (isset($_GET['cEndTime']) && !empty($_GET['cEndTime'])) { $endTime = strtotime(intval($_GET['cEndTime']) . ' 23:59:59'); $conditions[] = "createdTime <='{$endTime}' "; } $where = 'WHERE ' . implode(' AND ', $conditions); $page = isset($_GET['page']) && intval($_GET['page']) > 0 ? intval($_GET['page']) : 1; $perpage = isset($_GET['perpage']) && !empty($_GET['perpage']) ? intval($_GET['perpage']) : 30; $sort = 'ORDER BY id DESC'; $whIoStoreAct = new WhIoStoreModel(); $total = $whIoStoreAct->getIOStoreCount($where); $page = new Page($total, $perpage, '', 'CN'); $InStoreList = $whIoStoreAct->getInStoreList($where, $sort, $page->limit); $show_page = $total > $num ? $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9)) : $page->fpage(array(0, 2, 3)); $invoiceTypeList = WhIoStoreModel::getInvoiceTypeListByioType(0); $InStoreList['pageinfo']['total'] = $total; $InStoreList['pageinfo']['perpage'] = $perpage; $InStoreList['pageinfo']['nowpage'] = $page; $InStoreList['pageinfo']['show_page'] = $show_page; $InStoreList['typelist'] = $invoiceTypeList; return $InStoreList; }