public function view_waitWeighingList()
{
$pagesize = 100;
//页面大小
$statusar = array(PKS_WWEIGHING, PKS_WWEIGHING_EX, PKS_INLANDWWEIGHING);
$statusstr = implode(',', $statusar);
$packing_obj = new PackingOrderModel();
$count = $packing_obj->getRecordsNumByStatus($statusar);
//获得当前状态为待包装的发货单总数量
$pager = new Page($count, $pagesize);
//分页对象
$billlist = $packing_obj->getBillList(' and orderStatus in (' . $statusstr . ') order by po.id ' . $pager->limit);
$this->smarty->assign('billlist', $billlist);
$ShipingTypeList = CommonModel::getShipingTypeListKeyId();
$count = count($billlist);
for ($i = 0; $i < $count; $i++) {
$billlist[$i]['shipingname'] = isset($ShipingTypeList[$billlist[$i]['transportId']]) ? $ShipingTypeList[$billlist[$i]['transportId']] : '';
}
$acc_id_arr = array();
foreach ($billlist as $key => $valbil) {
if (!in_array($valbil['accountId'], $acc_id_arr)) {
array_push($acc_id_arr, $valbil['accountId']);
}
}
$salesaccountinfo = CommonModel::getAccountInfo($acc_id_arr);
$this->smarty->assign('salesaccountinfo', $salesaccountinfo);
if ($count > $pagesize) {
//分页链接
$pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$pagestr = $pager->fpage(array(0, 2, 3));
}
$this->smarty->assign('pagestr', $pagestr);
$navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '待包装称重'));
$this->smarty->assign('navlist', $navlist);
$toptitle = '待包装称重';
//顶部链接
$this->smarty->assign('toptitle', $toptitle);
$toplevel = 2;
//顶层菜单
$this->smarty->assign('toplevel', $toplevel);
$secondlevel = '26';
//当前的二级菜单
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('secnev', 3);
//二级导航
$this->smarty->display('waitweighinglist.htm');
}
public function view_showForm()
{
global $memc_obj;
$pagesize = 200;
//页面大小
$whereSql = $this->buildWhereSql();
//echo $whereSql;exit;
$packorder_obj = new PackingOrderModel();
$rownumber = $packorder_obj->getRowAllNumber($whereSql . ' group by po.id ');
//获得所有的行数
$pager = new Page($rownumber, $pagesize);
$billlist = $packorder_obj->getBillList($whereSql . ' group by po.id order by pd.pName ' . $pager->limit);
//更具条件获得发货单
$packorder_obj->buildOrderinfo($billlist);
/*
//去除重复的
$currentid = NULL;
$prekey = 0;
foreach ($billlist as $key=>$valbill){
if ($currentid == $valbill['id']) {
$billlist[$prekey]['originOrderId'] .= ', '.$valbill['originOrderId'];
unset($billlist[$key]);
}else {
$prekey = $key;
$currentid = $valbill['id'];
}
}
*/
$materInfo = CommonModel::getMaterInfoAll();
//获取包材信息
$materInfo = reverse_array($materInfo, 'pmName', 'id');
$shipingtyplist = CommonModel::getShipingTypeList();
//运输方式列表
$shipingtyplist = reverse_array($shipingtyplist, 'carrierNameCn', 'id');
$salesaccountlist = CommonModel::getSalesaccountList();
//获取销售帐号
$salesaccountlist = reverse_array($salesaccountlist, 'account', 'id');
//print_r($salesaccountlist);exit;
$platformList = CommonModel::getPlatformInfo();
//获取平台帐号
$platformList = reverse_array($platformList, 'platform', 'id');
$this->smarty->assign('shipingtypelist', $shipingtyplist);
$this->smarty->assign('salesaccountlist', $salesaccountlist);
$this->smarty->assign('platformList', $platformList);
foreach ($billlist as $key => $valbil) {
$tracknumber = '';
$str_info = OmAvailableModel::getTNameList("wh_order_tracknumber", "tracknumber", "where shipOrderId='{$valbil['id']}' and is_delete=0");
if (!empty($str_info)) {
$tracknumber = $str_info[0]['tracknumber'];
}
$billlist[$key]['tracknumber'] = $tracknumber;
$originOrder_arr = array();
$originOrder_str = '';
$originOrder_info = OmAvailableModel::getTNameList("wh_shipping_order_relation", "originOrderId", "where shipOrderId='{$valbil['id']}'");
if (!empty($originOrder_info)) {
foreach ($originOrder_info as $originOrder) {
$originOrder_arr[] = $originOrder['originOrderId'];
}
$originOrder_str = implode(',', $originOrder_arr);
}
$billlist[$key]['originOrder'] = $originOrder_str;
//运输方式
$billlist[$key]['shipingname'] = $shipingtyplist[$valbil['transportId']];
//包材
$billlist[$key]['materName'] = $materInfo[$valbil['pmId']];
//平台
$billlist[$key]['platformName'] = $platformList[$valbil['platformId']];
//销售账号
$billlist[$key]['salesaccountinfo'] = $salesaccountlist[$valbil['accountId']];
}
if ($rownumber > $pagesize) {
//分页
$pagestr = $pager->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$pagestr = $pager->fpage(array(0, 2, 3));
}
$this->smarty->assign('pagestr', $pagestr);
$this->smarty->assign('billlist', $billlist);
//发货单列表
$this->smarty->assign('secnev', 3);
$libstu_obj = new LibraryStatusModel();
//出库状态类型
$libstatuslist = $libstu_obj->getAllLibStatusList(' and groupId in (4 ,5)');
$this->smarty->assign('outstatuslist', $libstatuslist);
$toptitle = '订单查询';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$storeId = isset($_GET['storeId']) ? intval($_GET['storeId']) : 0;
if ($storeId == 1) {
$navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '发货单查询'), array('url' => '', 'title' => 'A仓发货单'));
} elseif ($storeId == 2) {
$navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '发货单查询'), array('url' => '', 'title' => 'B仓发货单'));
} else {
$navlist = array(array('url' => '', 'title' => '出库'), array('url' => '', 'title' => '发货单查询'));
}
$this->smarty->assign('navlist', $navlist);
$toplevel = 2;
//一级菜单的序号 0 开始
$this->smarty->assign('toplevel', $toplevel);
$secondlevel = isset($_GET['secondlevel']) ? trim($_GET['secondlevel']) : '';
if (empty($secondlevel)) {
$secondlevel = '21';
//当前的二级菜单
}
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('platLists', $_SESSION['platformList']);
$this->smarty->assign('accounts', $_SESSION['accountList']);
$this->smarty->assign('shippingList', $_SESSION['shippingList']);
$this->smarty->display('dispatchbillquery.htm');
}
public function act_addBatchPrintLists()
{
$appnum = intval(trim($_POST['appnum']));
$num = $appnum > 0 ? $appnum : 2000;
$storeId = isset($_POST['storeId']) ? trim($_POST['storeId']) : 1;
$where = " and po.orderStatus=400 and po.storeId={$storeId}";
//订单状态
$ordertimestart = isset($_POST['ordertimestart']) ? trim($_POST['ordertimestart']) : '';
//下单日期 开始
if ($ordertimestart != 0) {
//开始时间
$ordertimestart_int = strtotime($ordertimestart);
$where .= " and po.createdTime >= {$ordertimestart_int}";
}
$ordertimeend = isset($_POST['ordertimeend']) ? trim($_POST['ordertimeend']) : '';
//下单日期 结束
if ($ordertimeend != 0) {
//结束时间
$ordertimeend_int = strtotime($ordertimeend);
//$ordertimeend_int += 86400;
$where .= " and po.createdTime < {$ordertimeend_int}";
}
$goodsouttimestart = isset($_POST['goodsouttimestart']) ? trim($_POST['goodsouttimestart']) : '';
//出库日期 开始
if ($goodsouttimestart != 0) {
//出库开始时间
$goodsouttimestart_int = strtotime($goodsouttimestart);
$where .= " and po.weighTime >= {$goodsouttimestart}";
}
$goodsouttimeend = isset($_POST['goodsouttimeend']) ? trim($_POST['goodsouttimeend']) : '';
//出库日期 结束
if ($goodsouttimeend != 0) {
//出库结束时间
$goodsouttimeend_int = strtotime($goodsouttimeend);
$goodsouttimeend += 86400;
$where .= " and po.weighTime < {$goodsouttimeend}";
}
$isNote = intval($_POST['isNote']);
switch ($isNote) {
case 1:
//有留言
$where .= ' and po.isNote=1';
break;
case 2:
//没留言
$where .= ' and po.isNote=0';
break;
}
$orderTypeId = intval($_POST['orderTypeId']);
switch ($orderTypeId) {
case 1:
//发货单
$where .= ' and po.orderTypeId=1';
break;
case 2:
//配货单
$where .= ' and po.orderTypeId=2';
break;
}
$shiptype = trim($_POST['shiptype']);
//运输方式
if ($shiptype != 0) {
//运输方式
if ($shiptype == 200) {
$nshiptype = "1,2,3";
} else {
if ($shiptype == 200) {
$nshiptype = "6,10,52,53";
} else {
$nshiptype = $shiptype;
}
}
$where .= " and po.transportId in({$nshiptype})";
} else {
if (empty($_SESSION['shippingList'])) {
$where = " and po.transportId =''";
} else {
$nshiptype = implode(',', $_SESSION['shippingList']);
$where .= " and po.transportId in({$nshiptype})";
}
}
$client_name = trim($_POST['clientname']);
if ($client_name != '') {
//按客户id搜索
$where .= " and po.platformUsername='******'";
}
$salesaccount = trim($_POST['acc']);
if ($salesaccount != '') {
$where .= " and po.accountId='{$salesaccount}'";
} else {
if (empty($_SESSION['accountList'])) {
$where = " and po.accountId =''";
} else {
$accountInfo = implode(',', $_SESSION['accountList']);
$where .= " and po.accountId in({$accountInfo})";
}
}
$hunhe = intval($_POST['hunhe']);
switch ($hunhe) {
case 2:
//单料号
$where .= ' and po.orderAttributes=' . SOA_SINGLE;
break;
case 1:
//多料号
$where .= ' and po.orderAttributes=' . SOA_MULTIY;
break;
case 3:
//组合订单
$where .= ' and po.orderAttributes=' . SOA_COMBIN;
break;
}
$platformName = trim($_POST['platformName']);
if ($platformName != '') {
//平台
$where .= " and po.platformId= {$platformName}";
} else {
if (empty($_SESSION['platformList'])) {
$where .= " and po.platformId =''";
} else {
$platformInfo = implode(',', $_SESSION['platformList']);
$where .= " and po.platformId in({$platformInfo})";
}
}
//print_r($where);exit;
$packorder_obj = new PackingOrderModel();
$billlist = $packorder_obj->getBillList($where . ' group by po.id order by pd.pName limit ' . $num);
if (empty($billlist)) {
self::$errCode = 0;
self::$errMsg = '没有符合条件的订单!';
return;
}
$orderids = '';
$orderidArr = array();
foreach ($billlist as $list) {
$orderidArr[] = $list['id'];
}
$orderids = implode(',', $orderidArr);
$pm_obj = new printModel();
if ($pm_obj->insertPrintGroup($orderids, $storeId)) {
self::$errCode = 200;
self::$errMsg = '申请打印成功!';
return true;
} else {
self::$errCode = 0;
self::$errMsg = '申请打印失败！';
return false;
}
}
