public function view_sureAddMenu()
{
$StatusMenuAct = new StatusMenuAct();
$is_ok = $StatusMenuAct->act_sureAddMenu();
if ($is_ok) {
if ($is_ok == 2) {
$state = '流程已存在';
} else {
$state = '操作成功';
}
} else {
$state = '操作失败';
}
header('location:index.php?mod=StatusMenu&act=statusMenu&state=' . $state);
exit;
}
public function view_abnormalStockList()
{
global $memc_obj;
$pagesize = 200;
//页面大小
//var_dump($AbOrderList); exit;
$omAvailableAct = new OmAvailableAct();
$TransAPIAct = new TransAPIAct();
$OrderindexAct = new OrderindexAct();
$GoodsAct = new GoodsAct();
$OrderRefundAct = new OrderRefundAct();
//平台信息
$OmAccountAct = new OmAccountAct();
$WarehouseAPIAct = new WarehouseAPIAct();
$AbOrderList = $WarehouseAPIAct->act_getAbOrderList();
//var_dump($AbOrderList); exit;
$AbOrderListArr = array();
$AbOrderids = array();
$AbOrderShow = array();
foreach ($AbOrderList as $orderId) {
$AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']);
$AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo;
$AbOrderids[] = $orderId['originOrderId'];
$AbOrderShow[$orderId['originOrderId']] = $orderId['id'];
}
//var_dump($AbOrderListArr); exit;
$this->smarty->assign('AbOrderListArr', $AbOrderListArr);
$this->smarty->assign('AbOrderShow', $AbOrderShow);
//var_dump($AbOrderListArr); exit;
$platform = $OmAccountAct->act_getPlatformListByPower();
$this->smarty->assign('platform', $platform);
$account = $OmAccountAct->act_accountAllListById();
//账号信息
/**导航 start**/
$ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : 0;
$this->smarty->assign('ostatus', 770);
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
//二级目录
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
//echo $orderStatus."============"; echo "<br>";
$s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus);
//echo $orderStatus."==".$s_total; echo "<br>";
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc');
$second_type[$orderStatus] = $s_type[0]['statusCode'];
}
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
$where = " WHERE is_delete=0 ";
$accountList = $_SESSION['accountList'];
$platformList = $_SESSION['platformList'];
//echo "<pre>"; print_r($accountList); exit;
$platformsee = array();
for ($i = 0; $i < count($platformList); $i++) {
$platformsee[] = $platformList[$i];
}
if ($platformsee) {
$where .= ' AND platformId IN (' . join(",", $platformsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
$accountsee = array();
for ($i = 0; $i < count($accountList); $i++) {
$accountsee[] = $accountList[$i];
}
if ($accountsee) {
$where .= ' AND accountId IN (' . join(",", $accountsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
//if($where){
//$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 ");
$refund_total = $OrderRefundAct->act_getRecordNums();
//}else{
//$refund_total = 0;
//}
$this->smarty->assign('refund_total', $refund_total);
//三级目录
/*$refund_one = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=0");
$this->smarty->assign('refund_one', $refund_one);
$refund_two = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=1");
$this->smarty->assign('refund_two', $refund_two);
$refund_three = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 and status=2");
$this->smarty->assign('refund_three', $refund_three);*/
/**导航 end**/
$toptitle = '异常缺货统计页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0');
$this->smarty->assign('statusMenu', $statusMenu);
/* $where = ' WHERE is_delete = 0 '.$where;
$total = $omAvailableAct->act_getTNameCount('om_order_refund', $where);*/
$parameterArr = array();
$parameterArr['AbOrderList'] = $AbOrderids;
$total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr);
$this->smarty->assign('abnormal_total', $total);
//echo $total; exit;
$num = $pagesize;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$limit = $page->limit;
//var_dump($parameterArr);
$omOrderList = $OrderindexAct->act_showABOrder($ostatus, $otype, $page->limit, $parameterArr);
$this->smarty->assign('omOrderList', $omOrderList);
$pm = $GoodsAct->act_getMaterInfoByList();
$transportationList = $TransAPIAct->act_getCarrierListById();
$this->smarty->assign('transportationList', $transportationList);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
//获取系统所有状态
//$statusList = copyOrderModel::selectStatusList();
//var_dump($statusList); exit;
//$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
//$this->smarty->assign('sku', $sku);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->display('orderindex.htm');
}
public function view_modifyOrderList()
{
global $memc_obj;
$sysUserId = $_SESSION['sysUserId'];
$modify_showerrorinfo = '';
$OrderModifyAct = new OrderModifyAct();
$OrderindexAct = new OrderindexAct();
$UserCompetenceAct = new UserCompetenceAct();
//var_dump($_GET); exit;
if (isset($_GET) && !empty($_GET)) {
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['edit_ostatus']) ? $_GET['edit_ostatus'] : $_GET['ostatus'];
$otype = isset($_GET['edit_otype']) ? $_GET['edit_otype'] : $_GET['otype'];
}
if (isset($_POST) && !empty($_POST)) {
//var_dump($_POST); echo "<br>"; exit;
$orderid = isset($_POST['orderid']) ? $_POST['orderid'] : '';
$ostatus = isset($_POST['edit_ostatus']) ? $_POST['edit_ostatus'] : $_POST['ostatus'];
$otype = isset($_POST['edit_otype']) ? $_POST['edit_otype'] : $_POST['otype'];
$update_order = array();
$update_userinfo = array();
$update_tracknumber = array();
//$orderid = $_POST['orderid'];
//var_dump($_POST); exit;
$updatestatus = false;
if ($_POST['action'] == 'addDetail') {
//var_dump($_GET); echo "<br>"; exit;
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['edit_ostatus']) ? $_GET['edit_ostatus'] : $_GET['ostatus'];
$otype = isset($_GET['edit_otype']) ? $_GET['edit_otype'] : $_GET['otype'];
if ($OrderModifyAct->act_batchAdd($orderid, $_POST)) {
$modify_showerrorinfo = "<font color='green'>添加成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>添加失败</font>";
}
} else {
if ($_POST['action'] == 'addNote') {
//var_dump($_GET); echo "<br>"; exit;
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['edit_ostatus']) ? $_GET['edit_ostatus'] : $_GET['ostatus'];
$otype = isset($_GET['edit_otype']) ? $_GET['edit_otype'] : $_GET['otype'];
if ($OrderModifyAct->act_addNote($orderid, $_POST)) {
$modify_showerrorinfo = "<font color='green'>添加成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>添加失败</font>";
}
} else {
$visible_movefolder = $UserCompetenceAct->act_getInStatusIds($_POST['otype'], $sysUserId);
if (!in_array($_POST['edit_otype'], $visible_movefolder)) {
$modify_showerrorinfo = "<font color='red'>您没有改变订单状态的权限</font>";
} else {
if ($_POST['username'] != $_POST['edit_username']) {
$update_userinfo['username'] = $_POST['edit_username'];
}
if ($_POST['ostatus'] != $_POST['edit_ostatus']) {
$update_order['orderStatus'] = $_POST['edit_ostatus'];
}
if ($_POST['otype'] != $_POST['edit_otype']) {
$update_order['orderType'] = $_POST['edit_otype'];
$updatestatus = true;
}
if ($_POST['street'] != $_POST['edit_street']) {
$update_userinfo['street'] = $_POST['edit_street'];
}
if ($_POST['platformUsername'] != $_POST['edit_platformUsername']) {
$update_userinfo['platformUsername'] = $_POST['edit_platformUsername'];
}
if ($_POST['address2'] != $_POST['edit_address2']) {
$update_userinfo['address2'] = $_POST['edit_address2'];
}
if ($_POST['actualShipping'] != $_POST['edit_actualShipping']) {
$update_order['actualShipping'] = $_POST['edit_actualShipping'];
}
if ($_POST['city'] != $_POST['edit_city']) {
$update_userinfo['city'] = $_POST['edit_city'];
}
if ($_POST['state'] != $_POST['edit_state']) {
$update_userinfo['state'] = $_POST['edit_state'];
}
if ($_POST['countryName'] != $_POST['edit_countryName']) {
$update_userinfo['countryName'] = $_POST['edit_countryName'];
}
if ($_POST['zipCode'] != $_POST['edit_zipCode']) {
$update_userinfo['zipCode'] = $_POST['edit_zipCode'];
}
if ($_POST['landline'] != $_POST['edit_landline']) {
$update_userinfo['landline'] = $_POST['edit_landline'];
}
if ($_POST['phone'] != $_POST['edit_phone']) {
$update_userinfo['phone'] = $_POST['edit_phone'];
}
if ($_POST['transportId'] != $_POST['edit_transportId']) {
$update_order['transportId'] = $_POST['edit_transportId'];
}
if ($_POST['edit_tracknumber']) {
$update_tracknumber['omOrderId'] = $orderid;
$update_tracknumber['tracknumber'] = $_POST['edit_tracknumber'];
$update_tracknumber['addUser'] = $sysUserId;
$update_tracknumber['createdTime'] = time();
//var_dump($update_tracknumber); exit;
}
BaseModel::begin();
//开始事务
if ($update_order) {
//$sql = "UPDATE om_unshipped_order set ".array2sql($update_order)." WHERE id = ".$orderid;
//$msg = OrderLogModel::orderLog($orderid,$update_order['orderStatus'],$update_order['orderType'],$sql);
if (OrderindexModel::updateOrder('om_unshipped_order', $update_order, ' WHERE id = ' . $orderid)) {
if ($updatestatus) {
$ProductStatus = new ProductStatus();
if (!$ProductStatus->updateSkuStatusByOrderStatus(array($orderid), $batch_ostatus_val, $batch_otype_val)) {
BaseModel::rollback();
}
}
$modify_showerrorinfo = "<font color='green'>更新成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>更新失败</font>";
BaseModel::rollback();
}
}
if ($update_userinfo) {
//var_dump($update_userinfo);
if (OrderindexModel::updateOrder('om_unshipped_order_userInfo', $update_userinfo, ' WHERE omOrderId = ' . $orderid)) {
$modify_showerrorinfo = "<font color='green'>更新成功</font>";
} else {
$modify_showerrorinfo = "<font color='red'>更新失败</font>";
BaseModel::rollback();
}
}
if ($update_tracknumber) {
//echo $msg;
if (!OrderAddModel::insertOrderTrackRow($update_tracknumber)) {
/*self :: $errCode = "001";
self :: $errMsg = "跟踪号插入失败";
return false;*/
$modify_showerrorinfo = "<font color='red'>跟踪号插入失败</font>";
BaseModel::rollback();
}
}
BaseModel::commit();
BaseModel::autoCommit();
}
}
}
}
$this->smarty->assign('modify_showerrorinfo', $modify_showerrorinfo);
$omAvailableAct = new OmAvailableAct();
//平台信息
$platform = $omAvailableAct->act_getTNameList('om_platform', 'id,platform', 'WHERE is_delete=0');
//var_dump($platform);
$platformList = array();
foreach ($platform as $v) {
$platformList[$v['id']] = $v['platform'];
}
$this->smarty->assign('platformList', $platformList);
/**导航 start**/
$this->smarty->assign('ostatus', $ostatus);
$this->smarty->assign('otype', $otype);
//二级目录
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0');
//var_dump($otypeList);
$this->smarty->assign('otypeList', $otypeList);
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
/*$accountacc = $_SESSION['accountacc'];
$oc_where = " where orderStatus='$orderStatus' ";
if($accountacc){
$oc_where .= ' AND ('.$accountacc.') ';
}*/
$s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $oc_where);
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$orderStatus}' order by sort asc");
$second_type[$o_secondinfo['statusCode']] = $s_type[0]['statusCode'];
}
//var_dump($second_count);
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund", " where is_delete=0");
$this->smarty->assign('refund_total', $refund_total);
//三级目录
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
$this->smarty->assign('o_threelevel', $o_threelevel);
$three_count = array();
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
$s_total = $OrderindexAct->act_showSearchOrderNum($ostatus, $orderType);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order"," where orderStatus='$ostatus' and orderType='$orderType' and storeId=1 and is_delete=0");
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
$this->smarty->assign('three_count', $three_count);
$toptitle = '订单显示页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 ');
$this->smarty->assign('statusMenu', $statusMenu);
$value = '';
$where = '';
switch ($searchTransportationType) {
case '1':
$transportation = CommonModel::getCarrierList(1);
//快递
break;
case '2':
$transportation = CommonModel::getCarrierList(0);
//平邮
break;
default:
$transportation = CommonModel::getCarrierList();
//所有的
break;
}
//var_dump($transportation); exit;
$transportationList = array();
foreach ($transportation as $tranValue) {
$transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
}
//var_dump($transportationList); exit;
$this->smarty->assign('transportation', $transportation);
$this->smarty->assign('transportationList', $transportationList);
//var_dump($orderid, $ostatus,$otype);
$omOrderList = $OrderModifyAct->act_getModifyOrderList($orderid, $ostatus, $otype, $storeId = 1);
//var_dump($omOrderList);
//$sku = array();
$account_where = ' WHERE is_delete = 0 ';
if ($searchPlatformId) {
$account_where .= ' AND platformId = ' . $searchPlatformId;
}
$accountList = $UserCompetenceAct->act_showGlobalUser();
if ($accountList) {
$account_where .= ' AND id in ( ' . join(',', $accountList) . ' ) ';
}
//帐号信息
$accountList = $omAvailableAct->act_getTNameList('om_account', '*', $account_where);
//var_dump($accountList); exit;
$account = array();
foreach ($accountList as $v) {
$account[$v['id']] = $v['account'];
}
//包材信息
$pm = GoodsModel::getMaterInfoByList();
//获取系统所有状态
$statusList = copyOrderModel::selectStatusList();
$CurrencyAct = new CurrencyAct();
$currencyList = $CurrencyAct->act_getCurrencyListById();
//echo "<pre>"; print_r($currencyList); exit;
$this->smarty->assign('currencyList', $currencyList);
$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
$this->smarty->assign('accountList', $accountList);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->display('orderModify.htm');
}
public function view_showUserCompense()
{
$OmAccountAct = new OmAccountAct();
$StatusMenuAct = new StatusMenuAct();
$uid = $_GET['uid'];
//var_dump($_POST); exit;
$showinfo = '';
if (isset($_POST['action']) && !empty($_POST['action'])) {
if ($OmAccountAct->act_addUserCompense($_POST)) {
$showinfo = "<font color='green'>添加权限成功！</font>";
} else {
$showinfo = "<font color='red'>添加权限失败!</font>";
}
$uid = $_POST['uid'];
}
if (empty($uid)) {
header("location:index.php?mod=user&act=index");
exit;
}
$this->smarty->assign('uid', $uid);
$this->smarty->assign('showinfo', $showinfo);
$UserCompenseList = $OmAccountAct->act_getUserCompenseList($uid);
//echo "<pre>";
//print_r($UserCompenseList); exit;
//$visible_platform = array();
//$visible_account = array();
//echo "<pre>";
//var_dump($UserCompenseList);
//$visible_platform = $UserCompenseList['visible_platform'];
//$visible_account = $UserCompenseList['visible_account'];
$visible_movefolder = json_decode($UserCompenseList['visible_movefolder'], true);
//$visible_showfolder = $UserCompenseList['visible_showfolder'];
//$visible_editorder = $UserCompenseList['visible_editorder'];
$visible_platform_account = json_decode($UserCompenseList['visible_platform_account'], true);
//var_dump($visible_platform_account); exit;
/*if(empty($visible_movefolder)){
echo "=============";
}*/
$key_visible_movefolder = array();
if (is_array($visible_movefolder)) {
$key_visible_movefolder = array_keys($visible_movefolder);
}
$StatusMenu = $StatusMenuAct->act_getStatusMenuListById('*', ' WHERE groupId != 0 ');
//var_dump($StatusMenu);
$statusGroupLists = $StatusMenuAct->act_getMenuGroupList();
//echo "<pre>"; print_r($statusGroupLists); exit;
//$all_platform = $UserCompenseList['all_platform'];
//var_dump($all_platform);
//$all_account = $UserCompenseList['all_account'];
//$all_account = $UserCompenseList['all_account'];
$arr_all_platform_account = $UserCompenseList['arr_all_platform_account'];
$editorder_options = array(1 => '平台', '账号', '买家ID', '订单号', '下单时间', '付款时间', '产品总金额', '物流费用', '订单金额', 'Transaction ID', '币种', '估算重量', '买家选择发货物流', '跟踪号', 'Full name', 'Street1', 'Street2', 'City', 'State', 'Country ', 'Postcode', 'Tel1', 'Tel2', 'Tel3', '买家邮箱1', '买家邮箱2', '买家邮箱3', '订单备注');
$this->smarty->assign('editorder_options', $editorder_options);
//$this->smarty->assign('visible_platform', $visible_platform);
//$this->smarty->assign('visible_account', $visible_account);
$this->smarty->assign('visible_platform_account', $visible_platform_account);
$this->smarty->assign('arr_all_platform_account', $arr_all_platform_account);
$this->smarty->assign('key_visible_movefolder', $key_visible_movefolder);
$this->smarty->assign('visible_showfolder', $visible_showfolder);
$this->smarty->assign('visible_editorder', $visible_editorder);
//$this->smarty->assign('all_platform', $all_platform);
//$this->smarty->assign('all_account', $all_account);
$this->smarty->assign('StatusMenu', $StatusMenu);
$this->smarty->assign('statusGroupLists', $statusGroupLists);
$this->smarty->assign('toptitle', '订单系统细颗粒度权限控制');
$this->smarty->assign('toplevel', 3);
$this->smarty->assign('secondlevel', '32');
$this->smarty->display("showUserCompense.htm");
}
public static function get_waiting_sale($sku)
{
//获取海外仓待发货数据 Herman.Xi
$totalnums = 0;
$combineskus = GoodsModel::getCombineBySku($sku);
$skus = array($sku => 1) + $combineskus;
/*$combineskus = get_combinesku($sku);
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);*/
$StatusMenuAct = new StatusMenuAct();
$menuList = $StatusMenuAct->act_getStatusMenuList("*", " where dStatus = 1 and groupId = 0 and is_delete=0 and storeId= {$storeId} ");
//var_dump($menuList); exit;
$dStatusCodes = array();
foreach ($menuList as $value) {
$dStatusCodes[] = $value['statusCode'];
}
//var_dump($dStatusCodes);
foreach ($skus as $_sku => $_num) {
$ordersql = "SELECT \t\ta.id,b.sku,b.amount\n\t\t\t\t\t\tFROM \t\t\tom_unshipped_order AS a \n\t\t\t\t\t\tLEFT JOIN om_unshipped_order_detail AS b \n\t\t\t\t\t\tON \t\t\t\tb.omOrderId = a.id \n\t\t\t\t\t\tWHERE \t\t\ta.orderStatus NOT IN (" . join(',', $dStatusCodes) . ") \n\t\t\t\t\t\tAND \t\t\ta.is_delete = 0 \n\t\t\t\t\t\tAND \t\t\tb.sku='{$_sku}' \n\t\t\t\t\t\tAND\t\t\t\ta.storeId = " . $storeId;
//echo $ordersql;
$query = self::$dbConn->query($ordersql);
$ebay_ids = self::$dbConn->fetch_array_all($query);
if (!empty($ebay_ids)) {
foreach ($ebay_ids as $ebay_id) {
$realtimes = self::get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
}
}
return $totalnums;
/*$sql = "SELECT b.ebay_amount ,b.sku
FROM ebay_order AS a
LEFT JOIN ebay_orderdetail AS b ON a.ebay_ordersn = b.ebay_ordersn
WHERE a.ebay_status IN (705,706,707,710)
AND b.sku in ({$skus_str})
AND a.ebay_combine!='1'
";
$sql = $dbcon->execute($sql);
$skunums = $dbcon->getResultArray($sql);
foreach($skunums as $sku_info){
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += ($sku_info["ebay_amount"]*$realtimes);
}
return $totalnums;*/
}
/**
* 申请退款
*/
function act_applyRefund()
{
$id = isset($_POST['orderId']) ? trim($_POST['orderId']) : '';
$ostatus = isset($_POST['orderStatus']) ? trim($_POST['orderStatus']) : '';
$otype = isset($_POST['orderType']) ? trim($_POST['orderType']) : '';
if ($id == '') {
self::$errCode = 1;
self::$errMsg = '参数非法！';
return FALSE;
}
$refundedInfo = self::act_getRefundedSum($id);
//var_dump($refundedInfo);
//print_r($refundedInfo);
$totalSum = $refundedInfo['totalSum'];
$refundedSum = $refundedInfo['refundSum'];
//var_dump($refundedSum);
if ($refundedSum != 0 && $refundedSum >= $totalSum) {
self::$errCode = 02;
self::$errMsg = '该订单累计申请退款金额已达订单金额，不可再申请！';
return FALSE;
}
$StatusMenuAct = new StatusMenuAct();
$tableName = $StatusMenuAct->act_getOrderNameByStatus($ostatus, $otype);
$orderInfo = OrderRefundModel::getOrderInfo($tableName, $id);
//$orderObj = new OrderRefundModel();
//$orderInfo = OrderRefundModel::getTNameList($table, $field, $where);
if (!$orderInfo) {
$orderInfo['refundedSum'] = $refundedSum;
}
//var_dump($orderInfo); exit;
self::$errCode = OrderRefundModel::$errCode;
self::$errMsg = OrderRefundModel::$errMsg;
return $orderInfo;
}
public function act_index()
{
$id = $_REQUEST['orderid'];
$ostatus = $_REQUEST['ostatus'];
$otype = $_REQUEST['otype'];
$storeId = 1;
$where = ' WHERE da.is_delete = 0 AND da.storeId = ' . $storeId . ' AND da.orderStatus = ' . $ostatus;
if ($otype != '') {
$where .= ' AND da.orderType = ' . $otype;
}
$where .= ' AND da.id = ' . $id;
$StatusMenuAct = new StatusMenuAct();
$tableName = $StatusMenuAct->act_getOrderNameByStatus($ostatus, $otype);
$orderlist = OrderindexModel::showSearchOrderList($tableName, $where);
$data['order'] = $orderlist[$id];
//var_dump($orderlist); exit;
/*$price = array();
$data['order'] = OrderModifyModel::index($$tableName,$where);
foreach($data['order'] as $k => $v){
$data['order'][$k]['ordersTime'] = date("Y-m-d H:i:s",$v['ordersTime']);
$data['order'][$k]['paymentTime'] = date("Y-m-d H:i:s",$v['paymentTime']);
if($data['order'][$k]['createdTime'] != ''){
$data['order'][$k]['createdTime'] = date("Y-m-d H:i:s",$v['createdTime']);
}
$goodinfo = GoodsModel::getSkuinfo($v['sku']);
$data['order'][$k]['price'] = $goodinfo['goods_cost'];
}
$data['combinePackageMessage'] = '';
switch($data['order'][0]['combinePackage']){
case 0:
$data['combinePackageMessage'] = '正常订单(未合并包裹)';
break;
case 1:
$result = OmAvailableModel::getTNameList(' `om_records_combinePackage` ',' * ',' WHERE main_order_id = "'.$data['order'][0]['id'].'"');
$data['combinePackageMessage'] .= '该订单是合并包裹'.$result[0]['main_order_id'].'的一部分';
break;
case 2:
$result = OmAvailableModel::getTNameList(' `om_records_combinePackage` ',' * ',' WHERE split_order_id = "'.$data['order'][0]['id'].'"');
$data['combinePackageMessage'] .= '该订单是合并包裹'.$result[0]['main_order_id'].'的一部分';
break;
default:
break;
}
$data['isSplitMessage'] = '';
switch($data['order'][0]['isSplit']){
case 0:
$data['isSplitMessage'] = '正常订单(未拆分)';
break;
case 1:
$result = OmAvailableModel::getTNameList(' `om_records_splitOrder` ',' * ',' WHERE main_order_id = "'.$data['order'][0]['id'].'"');
$data['isSplitMessage'] .= '该订单拆分成'.count($result).'个订单';
break;
case 2:
$result = OmAvailableModel::getTNameList(' `om_records_combinePackage` ',' * ',' WHERE split_order_id = "'.$data['order'][0]['id'].'"');
$result = OmAvailableModel::getTNameList(' `om_records_combinePackage` ',' * ',' WHERE main_order_id = "'.$result[0]['main_order_id'].'"');
$data['isSplitMessage'] .= '该订单与'.count($result).'个订单由订单'.$result[0]['main_order_id'].'拆分而来';
break;
default:
break;
}*/
//$data['transport'] = CommonModel::getCarrierList();
//$data['materials'] = GoodsModel::getMaterInfo();
$data['operationLog'] = OmAvailableModel::getTNameList('`om_order_log`', ' * ', ' WHERE omOrderId = ' . $id);
if (empty($data['operationLog'])) {
$data['operationLog'] = array(array('note' => '暂无操作日志', 'createdTime' => ''));
} else {
foreach ($data['operationLog'] as $k => $v) {
$data['operationLog'][$k]['createdTime'] = date("Y-m-d H:i:s", $v['createdTime']);
}
}
//$data['currency'] = OmAvailableModel :: getTNameList('om_currency',' * ',' WHERE 1');
//var_dump($data); exit;
self::$errCode = OrderindexModel::$errCode;
self::$errMsg = OrderindexModel::$errMsg;
return $data;
}
public function act_showOrderList($ostatus, $otype, $where)
{
$StatusMenuAct = new StatusMenuAct();
$tableName = $StatusMenuAct->act_getOrderNameByStatus($ostatus, $otype);
$data = OrderindexModel::showOrderList($tableName, $where);
self::$errCode = OrderindexModel::$errCode;
self::$errMsg = OrderindexModel::$errMsg;
return $data;
}
public function view_getOrderList()
{
global $memc_obj;
$pagesize = isset($_GET['pnum']) && intval($_GET['pnum']) > 0 && intval($_GET['pnum']) < 101 ? intval($_GET['pnum']) : 20;
//页面大小
if ($_GET['debug'] == 1) {
$starttime = time() + microtime();
echo microtime() . '-----' . $starttime . "\n";
}
//菜单
$status = '';
$search = isset($_REQUEST['search']) ? $_REQUEST['search'] : '';
//搜索时使用的数据
//order表
$searchPlatformId = isset($_GET['platformId']) ? $_GET['platformId'] : '';
//搜索平台
$searchAccountId = isset($_GET['accountId']) ? $_GET['accountId'] : '';
//搜索账号
$searchIsNote = isset($_GET['isNote']) ? $_GET['isNote'] : '';
//是否有留言
$searchTransportationType = isset($_GET['transportationType']) ? $_GET['transportationType'] : '';
//运输类型
$searchTransportation = isset($_GET['transportation']) ? $_GET['transportation'] : '';
//运输方式
$searchIsBuji = isset($_GET['isBuji']) ? $_GET['isBuji'] : '';
//是否补寄订单
$searchIsLock = isset($_GET['isLock']) ? $_GET['isLock'] : '';
//是否锁定
$searchOrderTime1 = isset($_GET['OrderTime1']) ? $_GET['OrderTime1'] : '';
//搜索下单初始时间
$searchOrderTime2 = isset($_GET['OrderTime2']) ? $_GET['OrderTime2'] : '';
//搜索下单结束时间
//order_detail表
$searchReviews = isset($_GET['reviews']) ? $_GET['reviews'] : '';
//是否评价
$searchSku = isset($_GET['sku']) ? $_GET['sku'] : '';
//sku
//$searchOmOrderId = ''; //订单编号
$searchOrderType = isset($_GET['selectOrderType']) ? $_GET['selectOrderType'] : '';
//订单种类
//order_userInfo表
//$searchUsername = ''; //买家名
//$searchEmail = '';
$countryName = isset($_GET['country']) ? $_GET['country'] : "";
$state = isset($_GET['state']) ? $_GET['state'] : "";
$city = isset($_GET['city']) ? $_GET['city'] : "";
$zipCode = isset($_GET['zipCode']) ? $_GET['zipCode'] : "";
//order_warehouse表
//$weighTimeStart = isset($_GET['searchTimeStart'])? $_GET['searchTimeStart']:"";
//$weighTimeEnd = isset($_GET['searchTimeEnd'])? $_GET['searchTimeEnd']:"";
$searchTimeType = isset($_GET['searchTimeType']) ? $_GET['searchTimeType'] : '';
//order_tracknumbe表
//$searchTracknumber = ''; //跟踪号
//order_extension_ebay表
//$searchTransId = ''; //交易ID
$searchKeywordsType = isset($_GET['KeywordsType']) ? $_GET['KeywordsType'] : '';
//搜索关键字类型
$searchKeywords = isset($_GET['Keywords']) ? $_GET['Keywords'] : '';
//搜索关键字
$this->smarty->assign('searchPlatformId', $searchPlatformId);
$this->smarty->assign('searchAccountId', $searchAccountId);
$this->smarty->assign('searchIsNote', $searchIsNote);
$this->smarty->assign('searchTransportationType', $searchTransportationType);
$this->smarty->assign('searchTransportation', $searchTransportation);
$this->smarty->assign('searchIsBuji', $searchIsBuji);
$this->smarty->assign('searchIsLock', $searchIsLock);
$this->smarty->assign('searchOrderTime1', $searchOrderTime1);
$this->smarty->assign('searchOrderTime2', $searchOrderTime2);
$this->smarty->assign('searchReviews', $searchReviews);
$this->smarty->assign('searchSku', $searchSku);
$this->smarty->assign('searchOrderType', $searchOrderType);
//$this->smarty->assign('searchEmail', $searchEmail);
$this->smarty->assign('searchKeywordsType', $searchKeywordsType);
$this->smarty->assign('searchKeywords', $searchKeywords);
$this->smarty->assign('searchCountry', $countryName);
$this->smarty->assign('searchState', $state);
$this->smarty->assign('searchCity', $city);
$this->smarty->assign('searchZipCode', $zipCode);
//$this->smarty->assign('searchTimeStart', $weighTimeStart);
//$this->smarty->assign('searchTimeEnd', $weighTimeEnd);
$this->smarty->assign('searchTimeType', $searchTimeType);
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "firsttime ==={$dotime}=== " . ($dotime - $starttime) . "\n\n";
}
$OrderRefundAct = new OrderRefundAct();
$omAvailableAct = new OmAvailableAct();
$OrderindexAct = new OrderindexAct();
//平台信息
$OmAccountAct = new OmAccountAct();
$WarehouseAPIAct = new WarehouseAPIAct();
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "secondtime === " . ($dotime1 - $dotime) . "\n\n";
}
$AbOrderList = $WarehouseAPIAct->act_getAbOrderList();
//var_dump($AbOrderList); exit;
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "thirdtime === " . ($dotime - $dotime1) . "\n\n";
}
$AbOrderListArr = array();
$AbOrderids = array();
$AbOrderShow = array();
foreach ($AbOrderList as $orderId) {
$AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']);
$AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo;
$AbOrderids[] = $orderId['originOrderId'];
$AbOrderShow[$orderId['originOrderId']] = $orderId['id'];
}
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "forthtime === " . ($dotime1 - $dotime) . "\n\n";
}
//var_dump($AbOrderListArr); exit;
$this->smarty->assign('AbOrderListArr', $AbOrderListArr);
$this->smarty->assign('AbOrderShow', $AbOrderShow);
//$platform = $omAvailableAct->act_getTNameList('om_platform','id,platform','WHERE is_delete=0');
$platform = $OmAccountAct->act_getPlatformListByPower();
//var_dump($platform);
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "fiftytime === " . ($dotime - $dotime1) . "\n\n";
}
$this->smarty->assign('platform', $platform);
/**导航 start**/
$default_ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : C('STATEPENDING');
/*if(isset($_GET['ostatus']) && !empty($_GET['ostatus'])){
$ostatus = $_GET['ostatus'];
}else{
$ostatus = C('STATEPENDING');
}*/
$ostatus = $_GET['ostatus'];
//echo C('STATEPENDING');
$this->smarty->assign('ostatus', $ostatus);
$otype = isset($_GET['otype']) ? $_GET['otype'] : '';
$this->smarty->assign('otype', $otype);
//二级目录
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
if ($ostatus) {
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0');
} else {
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $default_ostatus . '" AND is_delete=0');
}
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "sixtytime === " . ($dotime1 - $dotime) . "\n\n";
}
//var_dump($otypeList);
$this->smarty->assign('otypeList', $otypeList);
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
$accountacc = $_SESSION['accountacc'];
//var_dump($ostatusList); echo "<br>";
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
//echo $orderStatus."============"; echo "<br>";
$s_total = 0;
//$OrderindexAct->act_showSearchOrderNum($orderStatus);
//echo $orderStatus."==".$s_total; echo "<br>";
$second_count[$o_secondinfo['statusCode']] = $s_total;
//$s_type = $omAvailableAct->act_getTNameList("om_status_menu","*","WHERE is_delete=0 and groupId='$orderStatus' order by sort asc");
$s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc');
$second_type[$orderStatus] = $s_type[0]['statusCode'];
}
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "seventime === " . ($dotime - $dotime1) . "\n\n";
}
//var_dump($second_count);
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//var_dump($second_type);
//退款数量
$accountList = $_SESSION['accountList'];
$platformList = $_SESSION['platformList'];
//echo "<pre>"; print_r($accountList); exit;
$where = " WHERE is_delete=0 ";
$platformsee = array();
for ($i = 0; $i < count($platformList); $i++) {
$platformsee[] = $platformList[$i];
}
if ($platformsee) {
$where .= ' AND platformId IN (' . join(",", $platformsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
$accountsee = array();
for ($i = 0; $i < count($accountList); $i++) {
$accountsee[] = $accountList[$i];
}
if ($accountsee) {
$where .= ' AND accountId IN (' . join(",", $accountsee) . ') ';
} else {
//$where .= " AND 1=2 ";
}
//echo $where;
//$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund"," where is_delete=0 ");
$refund_total = $OrderRefundAct->act_getRecordNums();
$this->smarty->assign('refund_total', $refund_total);
$parameterArr = array();
//var_dump($AbOrderids);
$parameterArr['AbOrderList'] = $AbOrderids;
$total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr);
$this->smarty->assign('abnormal_total', $total);
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "8time === " . ($dotime1 - $dotime) . "\n\n";
}
//三级目录
$three_count = array();
if ($ostatus) {
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
/*$or_where = " where orderStatus='$ostatus' and orderType='$orderType' ";
if($accountacc){
$or_where .= ' AND ('.$accountacc.') ';
}*/
//$s_total = $OrderindexAct->act_showSearchOrderNum($ostatus, $orderType);
$s_total = $default_ostatus == 900 && $orderType == 21 ? 'n' : $OrderindexAct->act_showSearchOrderNum($default_ostatus, $orderType);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where);
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
} else {
$or_where = "WHERE is_delete=0 and groupId='{$default_ostatus}' ";
if ($accountacc) {
$or_where .= ' AND (' . $accountacc . ') ';
}
$or_where .= " order by sort asc";
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$default_ostatus}' order by sort asc");
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
/*$or_where = " where orderStatus='$ostatus' and orderType='$orderType' ";
if($accountacc){
$or_where .= ' AND ('.$accountacc.') ';
}*/
$s_total = $default_ostatus == 900 && $orderType == 21 ? 'n' : $OrderindexAct->act_showSearchOrderNum($default_ostatus, $orderType);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where);
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
}
//
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "9time === " . ($dotime - $dotime1) . "\n\n";
}
$this->smarty->assign('o_threelevel', $o_threelevel);
$this->smarty->assign('three_count', $three_count);
$toptitle = '订单显示页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 ');
$this->smarty->assign('statusMenu', $statusMenu);
$value = '';
$where = '';
switch ($searchTransportationType) {
case '1':
$transportation = CommonModel::getCarrierList(1);
//快递
break;
case '2':
$transportation = CommonModel::getCarrierList(0);
//平邮
break;
default:
$transportation = CommonModel::getCarrierList();
//所有的
break;
}
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "10time === " . ($dotime1 - $dotime) . "\n\n";
}
//var_dump($transportation); exit;
$transportationList = array();
foreach ($transportation as $tranValue) {
$transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
}
//var_dump($transportationList); exit;
$this->smarty->assign('transportation', $transportation);
$this->smarty->assign('transportationList', $transportationList);
if ($search == '') {
/*$where = ' WHERE is_delete = 0 AND storeId = 1 AND orderStatus = '.$ostatus;
if($otype != ''){
$where .= ' AND orderType = '.$otype;
}*/
//$total = $omAvailableAct->act_getTNameCount($orderForm, $where);
$total = $OrderindexAct->act_showOrder($ostatus, $otype);
//echo $total; exit;
$num = $pagesize;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$where .= " ORDER BY ordersTime " . $page->limit;
//echo "========订单系统升级中========="; echo "<br>";
$omOrderList = $OrderindexAct->act_showOrder($ostatus, $otype, $page->limit);
//echo "<pre>"; var_dump($omOrderList); exit;
//$omOrderList = $omAvailableAct->act_getTNameList($orderForm, '*', $where);
} else {
$parameterArr = array();
$parameterArr['searchPlatformId'] = $searchPlatformId;
$parameterArr['searchAccountId'] = $searchAccountId;
$parameterArr['searchIsNote'] = $searchIsNote;
$parameterArr['searchTransportationType'] = $searchTransportationType;
$parameterArr['searchTransportation'] = $searchTransportation;
$parameterArr['searchIsBuji'] = $searchIsBuji;
$parameterArr['searchIsLock'] = $searchIsLock;
$parameterArr['searchOrderTime1'] = $searchOrderTime1;
$parameterArr['searchOrderTime2'] = $searchOrderTime2;
$parameterArr['searchReviews'] = $searchReviews;
$parameterArr['searchSku'] = trim($searchSku);
$parameterArr['searchOrderType'] = $searchOrderType;
$parameterArr['searchKeywordsType'] = $searchKeywordsType;
$parameterArr['countryName'] = trim($countryName);
$parameterArr['state'] = trim($state);
$parameterArr['city'] = trim($city);
$parameterArr['zipCode'] = trim($zipCode);
$parameterArr['searchTimeType'] = trim($searchTimeType);
$parameterArr['searchKeywords'] = trim($searchKeywords);
//$parameterArr['searchKeywords'] = trim($searchKeywords);
/*if($_SESSION['sysUserId'] == 8){
var_dump($ostatus.'---'.$otype);
}*/
//echo "订单系统升级中。。。。。。。<br>";
//var_dump($parameterArr); echo "<br>";
//$total = $OrderindexAct->act_index($parameterArr,$searchKeywordsType,$searchKeywords);
$total = $OrderindexAct->act_showOrder($ostatus, $otype, '', $parameterArr);
//echo $total; exit;
$num = $pagesize;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$limit = $page->limit;
//var_dump($parameterArr);
$omOrderList = $OrderindexAct->act_showOrder($ostatus, $otype, $page->limit, $parameterArr);
//var_dump($omOrderList);
//$omOrderList = OrderindexAct::act_index($parameterArr,$searchKeywordsType,$searchKeywords,$limit,$ostatus);
}
if ($_GET['debug'] == 1) {
$dotime = time() + microtime();
echo "11time ={$dotime}== " . ($dotime - $dotime1) . "\n\n";
}
//$sku = array();
$account_where = ' WHERE is_delete = 0 ';
if ($searchPlatformId) {
$account_where .= ' AND platformId = ' . $searchPlatformId;
}
$UserCompetenceAct = new UserCompetenceAct();
$accountList = $UserCompetenceAct->act_showGlobalUser();
if ($accountList) {
$account_where .= ' AND id in ( ' . join(',', $accountList) . ' ) ';
}
//帐号信息
$accountList = $omAvailableAct->act_getTNameList('om_account', '*', $account_where);
//var_dump($accountList); exit;
$account = array();
foreach ($accountList as $v) {
$account[$v['id']] = $v['account'];
}
//包材信息
$pm = GoodsModel::getMaterInfoByList();
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
//var_dump($page);
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
//echo $show_page;
//获取系统所有状态
$statusList = copyOrderModel::selectStatusList();
if ($_GET['debug'] == 1) {
$dotime1 = time() + microtime();
echo "12time ={$dotime1}== " . ($dotime1 - $dotime) . "\n\n";
}
//echo $show_page;
$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
$this->smarty->assign('accountList', $accountList);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->display('orderindex.htm');
}
function act_updateMenuStatusAPI()
{
$orderId = post_check(trim($_REQUEST['orderId']));
$ebay_status = $_REQUEST['ebay_status'];
$final_status = $_REQUEST['final_status'];
$truename = $_REQUEST['username'];
if (empty($orderId)) {
self::$errCode = 401;
self::$errMsg = 'orderId is null';
return false;
}
if (empty($ebay_status)) {
self::$errCode = 402;
self::$errMsg = 'ebay_status is null';
return false;
}
if (empty($final_status)) {
self::$errCode = 403;
self::$errMsg = 'final_status is null';
return false;
}
if (empty($truename)) {
self::$errCode = 404;
self::$errMsg = 'truename is null';
return false;
}
$status1 = getStatusMenuByOldStatus($final_status);
$orderStatus1 = $status1[0];
$orderType1 = $status1[1];
$status2 = getStatusMenuByOldStatus($ebay_status);
$orderStatus2 = $status2[0];
$orderType2 = $status2[1];
$tableName = "om_unshipped_order";
$data['orderStatus'] = $orderStatus1;
$data['orderType'] = $orderType1;
$where = " where id = {$orderId} AND orderStatus = {$orderStatus2} AND orderType = {$orderType2} AND is_delete = 0 ";
$updatedata = OrderindexModel::updateOrder($tableName, $data, $where);
if ($updatedata) {
self::$errCode = 200;
self::$errMsg = 'update success';
return true;
} else {
self::$errCode = 405;
self::$errMsg = 'update error';
return false;
}
}
public function view_applyTheLineEUBTrackNumber()
{
global $memc_obj;
$OmEUBTrackNumberAct = new OmEUBTrackNumberAct();
if (isset($_GET) && !empty($_GET)) {
$orderid = isset($_GET['orderid']) ? $_GET['orderid'] : '';
$ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : '';
$otype = isset($_GET['otype']) ? $_GET['otype'] : '';
}
$showerrorinfo = '';
//print_r($_POST);
if (isset($_FILES) && !empty($_FILES)) {
$info = $OmEUBTrackNumberAct->act_applyTheLineEUBTrackNumber();
if ($info) {
$showerrorinfo = "<font color=\"green\">上传成功！<br></font><font color=\"red\">" . $OmEUBTrackNumberAct::$errMsg . "</font>";
} else {
$showerrorinfo = "<font color=\"red\">上传成功！<br>" . $OmEUBTrackNumberAct::$errMsg . "</font>";
}
}
$this->smarty->assign('showerrorinfo', $showerrorinfo);
$omAvailableAct = new OmAvailableAct();
//平台信息
$platform = $omAvailableAct->act_getTNameList('om_platform', 'id,platform', 'WHERE is_delete=0');
//var_dump($platform);
$platformList = array();
foreach ($platform as $v) {
$platformList[$v['id']] = $v['platform'];
}
$this->smarty->assign('platformList', $platformList);
/**导航 start**/
$this->smarty->assign('ostatus', $ostatus);
$this->smarty->assign('otype', $otype);
//二级目录
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
//var_dump($ostatusList);
$this->smarty->assign('ostatusList', $ostatusList);
$otypeList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $ostatus . '" AND is_delete=0');
//var_dump($otypeList);
$this->smarty->assign('otypeList', $otypeList);
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
$accountacc = $_SESSION['accountacc'];
$oc_where = " where orderStatus='{$orderStatus}' and storeId=1 and is_delete=0 ";
if ($accountacc) {
$oc_where .= ' AND (' . $accountacc . ') ';
}
$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $oc_where);
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$orderStatus}' order by sort asc");
$second_type[$o_secondinfo['statusCode']] = $s_type[0]['statusCode'];
}
//var_dump($second_count);
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund", " where is_delete=0");
$this->smarty->assign('refund_total', $refund_total);
//三级目录
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
$this->smarty->assign('o_threelevel', $o_threelevel);
$three_count = array();
foreach ($o_threelevel as $o_threeinfo) {
$orderType = $o_threeinfo['statusCode'];
$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", " where orderStatus='{$ostatus}' and orderType='{$orderType}' and storeId=1 and is_delete=0");
$three_count[$o_threeinfo['statusCode']] = $s_total;
}
$this->smarty->assign('three_count', $three_count);
$toptitle = '订单显示页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0 ');
$this->smarty->assign('statusMenu', $statusMenu);
//var_dump($data); exit;
$this->smarty->display('eubTheLineApply.htm');
}
public function view_orderRefundList()
{
global $memc_obj;
$pagesize = 200;
//页面大小
//菜单
$status = '';
//print_r($_GET);
//搜索时使用的数据
//order表
$searchPlatformId = isset($_GET['platformId']) ? $_GET['platformId'] : '';
//搜索平台
$searchRefundType = isset($_GET['refundType']) ? $_GET['refundType'] : '';
//退款类型
$searchRefundStatus = isset($_GET['refundStatus']) ? $_GET['refundStatus'] : '';
//
$searchOmOrderId = isset($_GET['omOrderId']) ? $_GET['omOrderId'] : '';
//订单编号
$searchTransId = isset($_GET['transId']) ? $_GET['transId'] : '';
//交易ID
$searchApplyTime1 = isset($_GET['applyTime1']) ? $_GET['applyTime1'] : '';
//初始时间
$searchApplyTime2 = isset($_GET['applyTime2']) ? $_GET['applyTime2'] : '';
//结束时间
$status = isset($_GET['status']) ? $_GET['status'] : 0;
//操作状态
$orderType = isset($_GET['orderType']) ? $_GET['orderType'] : 1;
//单据种类
$ostatus = isset($_GET['ostatus']) ? $_GET['ostatus'] : 0;
//一级分类
//echo "------------------$searchOmOrderId----------------";
$where = ' where is_delete=0 ';
if ($searchPlatformId != '') {
$where .= ' AND platformId = ' . $searchPlatformId;
}
if ($searchRefundType != '') {
$where .= ' AND refundType = ' . $searchRefundType;
}
if ($searchTransId != '') {
$where .= ' AND transId = ' . $searchTransId;
}
if ($searchOmOrderId != '') {
$where .= ' AND omOrderId = ' . $searchOmOrderId;
}
if ($status != '') {
$where .= ' AND status = ' . $status;
}
if ($searchApplyTime1 != '' && $searchApplyTime2 != '') {
$where .= ' AND addTime >= "' . strtotime($searchApplyTime1) . '" AND addTime <= "' . strtotime($searchApplyTime2) . '" ';
}
$accountList = $_SESSION['accountList'];
$platformList = $_SESSION['platformList'];
//echo "<pre>"; print_r($accountList); exit;
$platformsee = array();
for ($i = 0; $i < count($platformList); $i++) {
$platformsee[] = $platformList[$i];
}
if ($platformsee) {
$where .= ' AND platformId IN (' . join(",", $platformsee) . ') ';
} else {
$where .= " AND 1=2 ";
}
$accountsee = array();
for ($i = 0; $i < count($accountList); $i++) {
$accountsee[] = $accountList[$i];
}
if ($accountsee) {
$where .= ' AND accountId IN (' . join(",", $accountsee) . ') ';
} else {
$where .= " AND 1=2 ";
}
$this->smarty->assign('searchPlatformId', $searchPlatformId);
$this->smarty->assign('searchRefundType', $searchRefundType);
$this->smarty->assign('searchRefundStatus', $searchRefundStatus);
$this->smarty->assign('searchOmOrderId', $searchOmOrderId);
$this->smarty->assign('searchTransId', $searchTransId);
$this->smarty->assign('searchApplyTime1', $searchApplyTime1);
$this->smarty->assign('searchApplyTime2', $searchApplyTime2);
$omAvailableAct = new OrderRefundAct();
$OrderindexAct = new OrderindexAct();
//平台信息
$OmAccountAct = new OmAccountAct();
$WarehouseAPIAct = new WarehouseAPIAct();
$AbOrderList = $WarehouseAPIAct->act_getAbOrderList();
//var_dump($AbOrderList); exit;
$AbOrderListArr = array();
$AbOrderids = array();
$AbOrderShow = array();
foreach ($AbOrderList as $orderId) {
$AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($orderId['id']);
$AbOrderListArr[$orderId['originOrderId']] = $AbOrderInfo;
$AbOrderids[] = $orderId['originOrderId'];
$AbOrderShow[$orderId['originOrderId']] = $orderId['id'];
}
//var_dump($AbOrderListArr); exit;
$this->smarty->assign('AbOrderListArr', $AbOrderListArr);
$this->smarty->assign('AbOrderShow', $AbOrderShow);
//$platform = $omAvailableAct->act_getTNameList('om_platform','id,platform','WHERE is_delete=0');
$platform = $OmAccountAct->act_getPlatformListByPower();
$this->smarty->assign('platform', $platform);
/**导航 start**/
$this->smarty->assign('ostatus', $ostatus);
$this->smarty->assign('status', $status);
$this->smarty->assign('refund_status', $status);
$StatusMenuAct = new StatusMenuAct();
$ostatusList = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = 0 AND is_delete=0');
/*var_dump($ostatusList);*/
$this->smarty->assign('ostatusList', $ostatusList);
//二级目录
/*$o_secondlevel = $omAvailableAct->act_getTNameList('om_status_menu','*','WHERE is_delete=0 and groupId=0 order by sort asc');
$this->smarty->assign('o_secondlevel', $o_secondlevel);*/
$second_count = array();
$second_type = array();
foreach ($ostatusList as $o_secondinfo) {
$orderStatus = $o_secondinfo['statusCode'];
//echo $orderStatus."============"; echo "<br>";
$s_total = $OrderindexAct->act_showSearchOrderNum($orderStatus);
//echo $orderStatus."==".$s_total; echo "<br>";
$second_count[$o_secondinfo['statusCode']] = $s_total;
$s_type = $StatusMenuAct->act_getStatusMenuList('statusCode,statusName', 'WHERE groupId = "' . $orderStatus . '" AND is_delete=0 order by sort asc');
$second_type[$orderStatus] = $s_type[0]['statusCode'];
}
$this->smarty->assign('second_count', $second_count);
$this->smarty->assign('second_type', $second_type);
//退款数量
//echo $where;
//$refund_total = $omAvailableAct->act_getTNameCount("om_order_refund", " where is_delete=0 ");
$refund_total = $omAvailableAct->act_getRecordNums();
$this->smarty->assign('refund_total', $refund_total);
$parameterArr = array();
//var_dump($AbOrderids);
$parameterArr['AbOrderList'] = $AbOrderids;
$total = $OrderindexAct->act_showABOrder($ostatus, $otype, '', $parameterArr);
$this->smarty->assign('abnormal_total', $total);
//三级目录
/*$refund_one = $omAvailableAct->act_getTNameCount("om_order_refund",$where." and status=0");
$this->smarty->assign('refund_one', $refund_one);
$refund_two = $omAvailableAct->act_getTNameCount("om_order_refund",$where." and status=1");
$this->smarty->assign('refund_two', $refund_two);
$refund_three = $omAvailableAct->act_getTNameCount("om_order_refund",$where." and status=2");
$this->smarty->assign('refund_three', $refund_three);*/
/**导航 end**/
$refund_status = array('671' => array(1, 0), '673' => array(1, 1), '674' => array(1, 2), '675' => array(2, 0), '676' => array(2, 1), '677' => array(2, 2), '678' => array(3, 0), '679' => array(3, 1));
$o_threelevel = $omAvailableAct->act_getTNameList("om_status_menu", "*", "WHERE is_delete=0 and groupId='{$ostatus}' order by sort asc");
//var_dump($o_threelevel);
$extral_str = array();
foreach ($o_threelevel as $o_threeinfo) {
$statusCode = $o_threeinfo['statusCode'];
$torderType = $refund_status[$statusCode][0];
$tostatus = $refund_status[$statusCode][1];
$where = " WHERE orderType = '{$torderType}' and status = '{$tostatus}' and is_delete = 0 ";
//echo $where; echo "<br>";
$s_total = $omAvailableAct->act_getRecordNums($where);
//$s_total = $omAvailableAct->act_getTNameCount("om_unshipped_order", $or_where);
$three_count[$o_threeinfo['statusCode']] = $s_total;
$extral_str[$o_threeinfo['statusCode']] = "orderType={$torderType}&status={$tostatus}";
}
$this->smarty->assign('extral_str', $extral_str);
$this->smarty->assign('o_threelevel', $o_threelevel);
$this->smarty->assign('three_count', $three_count);
$toptitle = '退款操作页面';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 0);
$threelevel = '1';
//当前的三级菜单
$this->smarty->assign('threelevel', $threelevel);
$statusMenu = $omAvailableAct->act_getTNameList('om_status_menu', ' * ', 'WHERE is_delete=0');
$this->smarty->assign('statusMenu', $statusMenu);
//print_r($orderRefundList);//exit;
//$where = ' WHERE is_delete = 0 '.$where;
$where = " WHERE orderType = '{$orderType}' and status = '{$status}' and is_delete = 0 ";
//echo $where;
//$total = $omAvailableAct->act_getTNameCount('om_order_refund', $where);
$total = $omAvailableAct->act_getRecordNums($where);
$num = 100;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
//$where .= " ORDER BY id " . $page->limit;
//$orderRefundList = $omAvailableAct->act_getTNameList('om_order_refund', '*', $where);
$orderRefundList = $omAvailableAct->act_getRefundList($where);
//echo $where;
if (empty($orderRefundList)) {
$orderRefundList = array();
}
$this->smarty->assign('orderRefundList', $orderRefundList);
$where = ' WHERE is_delete = 0 ';
//$where = ' WHERE is_delete = 0 AND orderRefundId in('.$value.') '.$where;
if (!empty($orderRefundList)) {
foreach ($orderRefundList as $k => $v) {
if ($value == '') {
$value = $v['id'];
} else {
$value .= ',' . $v['id'];
}
}
$where = ' WHERE is_delete = 0 AND orderRefundId in(' . $value . ') ';
} else {
$where .= " AND 1=2 ";
}
$orderRefundDetailList = $omAvailableAct->act_getTNameList('om_order_refund_detail', '*', $where);
/*if(empty($orderRefundDetailList)){
$status = '无符合条件的订单';
$this->smarty->assign('status', $status);
$this->smarty->display('orderRefund.htm.htm');
exit;
}*/
//print_r($orderRefundDetailList);
if (empty($orderRefundDetailList)) {
$orderRefundDetailList = array();
}
$this->smarty->assign('orderRefundDetailList', $orderRefundDetailList);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
//获取系统所有状态
$statusList = copyOrderModel::selectStatusList();
$this->smarty->assign('status', $status);
$this->smarty->assign('statusList', $statusList);
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('account', $account);
$this->smarty->assign('sku', $sku);
$this->smarty->assign('pm', $pm);
$this->smarty->assign('orderdEtailExtensionEbay', $orderdEtailExtensionEbay);
$this->smarty->assign('omOrderList', $omOrderList);
$this->smarty->assign('omOrderDetail', $omOrderDetail);
//$this->smarty->assign('orderTracknumber', $orderTracknumber);
$this->smarty->assign('omOrderExtensionEbay', $omOrderExtensionEbay);
$this->smarty->assign('omOrderUserInfo', $omOrderUserInfo);
$this->smarty->display('orderRefund.htm');
}
public static function resendOrder($orderid, $note, $type, $old_ostatus, $old_otype)
{
!self::$dbConn ? self::initDB() : NULL;
BaseModel::begin();
//开始事务
//$tableName = 'om_unshipped_order';
//echo $old_ostatus; echo "<br>";
//echo $old_otype; echo "<br>";
$StatusMenuAct = new StatusMenuAct();
$tableName = $StatusMenuAct->act_getOrderNameByStatus($old_ostatus, $old_otype);
//echo $tableName;
if ($type == 1) {
$updatesql = 'update ' . $tableName . ' set isBuji=1,isCopy=1 where id=' . $orderid . ' and is_delete = 0 and storeId = 1';
} else {
$updatesql = 'update ' . $tableName . ' set isCopy=1 where id=' . $orderid . ' and is_delete = 0 and storeId = 1';
}
if (!self::$dbConn->query($updatesql)) {
//更新状态失败
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
self::$errCode = '003';
self::$errMsg = '订单信息不存在，无法复制!';
return FALSE;
}
//产生新订单
$where = ' WHERE id = ' . $orderid . ' and is_delete = 0 and storeId = 1';
$orderData = OrderindexModel::showOrderList($tableName, $where);
$orderDetail = $orderData[$orderid]['orderDetail'];
if (!$orderDetail) {
//更新状态失败
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
return FALSE;
}
$insert_orderDetail = array();
foreach ($orderDetail as $detail) {
$insert_orderDetailData = $detail['orderDetailData'];
unset($insert_orderDetailData['id']);
$insert_orderDetailExtenData = $detail['orderDetailExtenData'];
unset($insert_orderDetailExtenData['omOrderdetailId']);
$insert_orderDetail[] = array('orderDetailData' => $insert_orderDetailData, 'orderDetailExtenData' => $insert_orderDetailExtenData);
}
$obj_order_data = $orderData[$orderid]['orderData'];
if ($obj_order_data['isBuji'] == 2) {
self::$errCode = '003';
self::$errMsg = "补寄产生订单不能补寄!";
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
return FALSE;
}
if ($obj_order_data['isCopy'] == 2) {
self::$errCode = '003';
self::$errMsg = "复制产生订单不能复制!";
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
return FALSE;
}
unset($obj_order_data['id']);
$orderExtenData = $orderData[$orderid]['orderExtenData'];
unset($orderExtenData['omOrderId']);
$orderUserInfoData = $orderData[$orderid]['orderUserInfoData'];
unset($orderExtenData['omOrderId']);
if ($type == 1) {
$obj_order_data['isCopy'] = 2;
$obj_order_data['actualTotal'] = 0.0;
} else {
$obj_order_data['isCopy'] = 2;
$obj_order_data['isBuji'] = 2;
$obj_order_data['actualTotal'] = 0.0;
$obj_order_data['orderStatus'] = C('STATEBUJI');
$obj_order_data['orderType'] = C('STATEBUJI_DONE');
}
$orderNote = array('content ' => $note, 'userId' => $_SESSION['sysUserId'], 'createdTime' => time());
$insert_orderData = array();
$insert_orderData = array('orderData' => $obj_order_data, 'orderExtenData' => $orderExtenData, 'orderUserInfoData' => $orderUserInfoData, 'orderDetail' => $insert_orderDetail, 'orderNote' => $orderNote);
//$orderNote = $orderData['orderNote'];
//echo $insertsql;
//var_dump($insert_orderData); exit;
if ($insertId = OrderAddModel::insertAllOrderRowNoEvent($insert_orderData)) {
//echo $split_log .= 'insert success!' . "\n"; exit;
//var_dump($_mainId,$_spitId); exit;
if (!OrderLogModel::insertOrderLog($insertId, '补寄产生订单')) {
BaseModel::rollback();
self::$errCode = '001';
self::$errMsg = "补寄失败!";
return false;
}
if (!OrderRecordModel::insertSendRecords($orderid, $insertId)) {
BaseModel::rollback();
self::$errCode = '002';
self::$errMsg = "补寄失败添加记录失败!";
return false;
}
} else {
//$split_log .= '补寄新订单产生失败!' . "\n";
BaseModel::rollback();
self::$errCode = '003';
self::$errMsg = "补寄新订单产生失败";
return false;
}
BaseModel::commit();
self::$errCode = '200';
self::$errMsg = "补寄新订单成功！";
return TRUE;
}
