/**
* 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
