/** * WhGoodsAssignAct::export_data() * 导出调拨数据 * @return void */ public function export_data() { $ids = trim($_GET['ids']); if ($ids) { $assignList = WhGoodsAssignModel::getAssignList(" and a.id in ({$ids})", '', '', 'a.id'); $assign_status = C('assign_status'); //print_r($assign_status);exit; $name = 'assignList' . date('Y-m-d') . ".xls"; //$name = iconv('UTF-8', 'gb2312//ignore', $name); $excel = new ExportDataExcel('browser', $name); $excel->initialize(); $tharr = array("调拨单号", "SKU", "产品名称", "转出仓库", "转入仓库", "需求数量", "配货数量", '出库复核数量', '接收数量', '生成人员', '生成时间', '调拨单状态', '状态变更时间'); $excel->addRow($tharr); if (!empty($assignList)) { foreach ($assignList as $assign) { $outStore = WarehouseManagementModel::warehouseManagementModelList(" where id = {$assign['outStoreId']}"); $outStore = $outStore[0]['whName']; $inStore = WarehouseManagementModel::warehouseManagementModelList(" where id = {$assign['inStoreId']}"); $inStore = $inStore[0]['whName']; $maker = getUserNameById($assign['createUid']); $make_date = date('Y-m-d H:i:s', $assign['createTime']); $state_date = date('Y-m-d H:i:s', $assign['statusTime']); $status = $assign_status[$assign['status']]; $details = WhGoodsAssignModel::getsAssignListDetail($assign['id']); foreach ($details as $k => $val) { $tdarr = array($k == 0 ? $assign['assignNumber'] : '', $val['sku'], $val['goodsName'], $outStore, $inStore, $val['num'], $val['assignNum'], $val['outCheckNum'], $val['inCheckNum'], $k == 0 ? $maker : '', $k == 0 ? $make_date : '', $k == 0 ? $status : '', $k == 0 ? $state_date : ''); //print_r($tdarr);exit; $excel->addRow($tdarr); } } } $excel->finalize(); exit; } }
/** * whGoodsAssignView::view_editAssignList() * 调拨单修改界面 * @return void */ public function view_editAssignList() { self::bulidNav('修改调拨单', '修改调拨单', 51); $id = intval(trim($_GET['id'])) ? intval(trim($_GET['id'])) : 0; if ($id) { $where = 'where status = 1'; $storeLists = WarehouseManagementModel::warehouseManagementModelList($where); //获取可用仓库列表 $data = WhGoodsAssignModel::getAssignList(" and a.id={$id}", '', '', 'a.id'); if (!empty($data)) { $res = $data[0]; $detail = WhGoodsAssignModel::getsAssignListDetail($id); //调拨单明细 $this->smarty->assign('detail', $detail); $this->smarty->assign('res', $res); $createUser = getUserNameById($res['createUid']); $this->smarty->assign('createUser', $createUser); //$user = array('name'=>$userName, 'uid'=>$_SESSION['userId']); $this->smarty->assign('storeLists', $storeLists); $this->smarty->display('editAssignList.htm'); } //$userName = getUserNameById($_SESSION['userId']); //获取用户名 } }
$type = intval(trim($_GET['type'])); if (!empty($order_group)) { $sql = "select * from wh_store_goods_assign where id in ({$order_group})"; $g_query = $dbConn->query($sql); if ($g_query) { $group_info = $dbConn->fetch_array_all($g_query); } if (empty($group_info)) { echo "调拨单不存在!"; exit; } $order_groups = explode(',', $order_group); foreach ($order_groups as $key => $id) { $assignNumber = OmAvailableModel::getTNameList('wh_store_goods_assign', 'assignNumber', "where id = {$id}"); $assignNumber = $assignNumber['0']['assignNumber']; $skuinfo = WhGoodsAssignModel::getsAssignListDetail($id); $page_num = 40; //一页几个sku $count = count($skuinfo); $pages = ceil($count / $page_num); for ($i = 1; $i <= $pages; $i++) { ?> <table width="100%" border="1" cellspacing="0" cellpadding="0"> <tr> <td style="padding:5px;"><?php echo $type == 1 ? '配货清单' : '调拨出库单'; ?> :<font color="black"><?php echo $assignNumber; ?> </font><span style="padding-left:100px" color="black"><?php