public function view_editMenu()
{
$id = intval($_GET['id']);
$menu = StatusMenuModel::getStatusMenuList("*", "where id={$id}");
$this->smarty->assign('menu', $menu);
$group = StatusMenuGroupModel::getMenuGroupList("*", "where storeId=1 and groupId = 0 and is_delete=0");
$this->smarty->assign('group', $group);
$navlist = array(array('url' => '', 'title' => '系统设置'), array('url' => 'index.php?mod=StatusMenu&act=statusMenu', 'title' => '订单流程'), array('url' => '', 'title' => '修改流程'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', '修改流程');
$toplevel = 3;
//一级菜单的序号
$this->smarty->assign('toplevel', $toplevel);
$secondlevel = 39;
//当前的二级菜单
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('curusername', $_SESSION['userName']);
$this->smarty->display('menuAdd.htm');
}
public static function getsaleandnosendall($sku, $storeId = 1)
{
//获取虚拟/待发货库存（除超大订单进来的待发货）
self::initDB();
$totalnums = 0;
$combineskus = GoodsModel::getCombineBySku($sku);
//var_dump($combineskus);
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);
//var_dump($skus); echo "<br>";
$skus_str = implode("','", $skus);
$skus_str = "'" . $skus_str . "'";
//echo "<pre>";
//$skus = GoodsModel::getCombineANDSKU($sku); //$combineskus
//var_dump($skus); echo "<br>";
//exit;
//return 0;
$menuList = StatusMenuModel::getStatusMenuList("*", " where dStatus = 1 and groupId = 0 and is_delete=0 and storeId= {$storeId} ");
//var_dump($menuList); exit;
$dStatusCodes = array();
foreach ($menuList as $value) {
if ($value['statusCode']) {
$dStatusCodes[] = $value['statusCode'];
}
}
$tendaytime = time() - 10 * 24 * 60 * 60;
//待发货二级状态已经暂不寄超过十天时间
$ordersql = 'SELECT b.sku, b.amount FROM om_unshipped_order AS a JOIN om_unshipped_order_detail AS b ON a.id = b.omOrderId where a.orderStatus in (' . join(',', $dStatusCodes) . ') and a.is_delete=0 and a.storeId= ' . $storeId . ' AND b.sku in (' . $skus_str . ') and b.is_delete=0 and b.storeId= ' . $storeId;
$query = self::$dbConn->query($ordersql);
$skunums = self::$dbConn->fetch_array_all($query);
foreach ($skunums as $sku_info) {
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
$ordersql = 'SELECT b.sku, b.amount FROM om_unshipped_order AS a JOIN om_unshipped_order_detail AS b ON a.id = b.omOrderId where a.orderStatus = ' . C('STATESENDTEMP') . ' and a.paymentTime > ' . $tendaytime . ' and a.is_delete=0 and a.storeId= ' . $storeId . ' AND b.sku in (' . $skus_str . ') and b.is_delete=0 and b.storeId= ' . $storeId;
$query = self::$dbConn->query($ordersql);
$skunums = self::$dbConn->fetch_array_all($query);
foreach ($skunums as $sku_info) {
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
/*$ordersql = 'SELECT a.id FROM om_unshipped_order AS a where a.orderStatus in ('.join(',', $dStatusCodes).') and a.is_delete=0 and a.storeId= '.$storeId;
$ordersql .= ' UNION ';
$ordersql .= 'SELECT a.id FROM om_unshipped_order AS a where a.orderStatus = '.C('STATESENDTEMP').' and a.paymentTime > '.$tendaytime.' and a.is_delete=0 and a.storeId= '.$storeId;
//echo $ordersql; echo "<br>"; exit;
$query = self::$dbConn->query($ordersql);
$orders = self::$dbConn->fetch_array_all($query);*/
//var_dump($orders); exit;
//return 10;
/*foreach($orders as $value){
//foreach($skus as $_sku => $_num){
$detailsql = 'SELECT b.sku, b.amount FROM om_unshipped_order_detail AS b where b.omOrderId = '.$value['id'].' AND b.sku in ('.$skus_str.') and b.is_delete=0 and b.storeId= '.$storeId;
echo $detailsql; echo "<br>";
exit;
$query = self::$dbConn->query($detailsql);
$detail = self::$dbConn->fetch_array_all($query);
if(empty($detail)){
continue;
}
//var_dump($detail);
foreach($detail as $val){
//$_sku = $val['sku'];
$amount = intval($val['amount']);
$totalnums += ($amount*$_num);
}
//}
}*/
//var_dump($totalnums);
//新的待发货计算没有数据，并且缺货配货记录，等待配货的信息@2013-11-10
return json_encode($totalnums);
}
public function act_getExpressShipOrderInfo()
{
$recordnumber = !empty($_GET["recordnumber"]) ? addslashes(trim($_GET["recordnumber"])) : '';
$selleraccount = !empty($_GET["selleraccount"]) ? addslashes(trim($_GET["selleraccount"])) : '';
//$selleraccount='sunwebzone';
//$recordnumber='537995';
if (empty($recordnumber)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'recordnumber is null.';
exit(json_encode($data));
}
if (empty($selleraccount)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'selleraccount is null.';
exit(json_encode($data));
}
$field = "a.*";
$condition = "ORDER BY a.id DESC LIMIT 50";
$orders = OrderInfoModel::getExpressOrderInfo($selleraccount, $recordnumber, $field, $condition = '');
if (empty($orders)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'No data or get a order information error';
exit(json_encode($data));
}
foreach ($orders as &$order) {
if ($order['orderStatus'] == 2) {
$order['catename'] = '已发货';
} else {
$select = 'statusName';
$where = " WHERE groupId = '{$order['orderStatus']}' AND statusCode = '{$order['orderType']}' LIMIT 1 ";
$cates = StatusMenuModel::getStatusMenuList($select, $where);
$order['catename'] = $cates[0]['statusName'];
}
$order['orderdetail'] = OrderInfoModel::getShipOrderDetailByOrderId($order['id']);
}
$data['data'] = $orders;
exit(json_encode($data));
}
public function act_getMenuGroupList()
{
$list = StatusMenuModel::getStatusMenuList('statusName,statusCode,groupId', 'where is_delete = 0 ORDER BY groupId ASC,statusCode ASC');
$grouplists = array();
$group0 = array();
foreach ($list as $key => $value) {
if ($value['groupId'] == 0) {
$group0[$value['statusCode']]['name'] = $value['statusName'];
$group0[$value['statusCode']]['list'] = $value;
}
}
foreach ($list as $k => $v) {
foreach ($group0 as $k0 => $v0) {
if ($k0 == $v['groupId']) {
$grouplists[$v['groupId']]['name'] = $v0['name'];
$grouplists[$v['groupId']]['subCode'] .= $v['statusCode'] . ',';
$grouplists[$v['groupId']]['list'][] = $v;
}
}
}
self::$errCode = StatusMenuModel::$errCode;
self::$errMsg = StatusMenuModel::$errMsg;
if ($list) {
return $grouplists;
} else {
return false;
}
}
