Пример #1
0
 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');
 }
Пример #2
0
 public static function initDB()
 {
     global $dbConn;
     self::$dbConn = $dbConn;
     mysql_query('SET NAMES UTF8');
 }
Пример #3
0
 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');
 }
Пример #4
0
 public function act_copyOrder()
 {
     $orderid = isset($_POST['orderid']) ? $_POST['orderid'] : "";
     $countryName = isset($_POST['countryName']) ? $_POST['countryName'] : "";
     $state = isset($_POST['state']) ? $_POST['state'] : "";
     $detail_sku = isset($_POST['detail_sku']) ? $_POST['detail_sku'] : "";
     $city = isset($_POST['city']) ? $_POST['city'] : "";
     $landline = isset($_POST['landline']) ? $_POST['landline'] : "";
     $phone = isset($_POST['phone']) ? $_POST['phone'] : "";
     $zipCode = isset($_POST['zipCode']) ? $_POST['zipCode'] : "";
     $street = isset($_POST['street']) ? $_POST['street'] : "";
     $address2 = isset($_POST['address2']) ? $_POST['address2'] : "";
     $address3 = isset($_POST['address3']) ? $_POST['address3'] : "";
     $transport = isset($_POST['transport']) ? $_POST['transport'] : "";
     $note = isset($_POST['note']) ? $_POST['note'] : "";
     $userId = $_SESSION['sysUserId'];
     $order = copyOrderModel::selectOrder($orderid);
     $user = copyOrderModel::selectUser($orderid);
     $details = copyOrderModel::selectDetail($orderid);
     $platformId = $order['platformId'];
     $plateform = copyOrderModel::selectplatform($platformId);
     $table = "om_unshipped_order_extension_" . $plateform;
     $extension = copyOrderModel::selectExtension($table, $orderid);
     $warehouse = copyOrderModel::selectWarehouse($orderid);
     $notes = copyOrderModel::selectNote($orderid);
     BaseModel::begin();
     if (!$order) {
         self::$errCode = 501;
         self::$errMsg = "原订单已完成或不存在!";
         return false;
     }
     if ($order['isCopy'] == 2) {
         self::$errCode = 502;
         self::$errMsg = "此订单是复制产生的订单,不能在被复制!";
         return false;
     }
     $new_order = array();
     foreach ($order as $key => $value) {
         if ($key == 'id') {
             continue;
         }
         $new_order[$key] = $value;
         if ($key == 'isCopy') {
             $new_order[$key] = 2;
         }
     }
     //$statuslist = copyOrderModel::selectStatus($status);
     //$new_order['orderStatus'] = $statusList['groupId'];
     //$new_order['orderType'] = $statusList['statusCode'];
     //先插入订单生成订单id
     //$sql = "";
     foreach ($new_order as $key => $value) {
         if (is_numeric($value)) {
             $sql[] = "{$key}={$value}";
         } else {
             $sql[] = "{$key}='{$value}'";
         }
     }
     $sql = implode(",", $sql);
     $id = copyOrderModel::insertOrder($sql, $userId);
     if (!$id) {
         self::$errCode = 503;
         self::$errMsg = "复制订单插入失败!";
         BaseModel::rollback();
         return false;
     }
     $new_user = array();
     //插入用户信息
     foreach ($user as $key => $value) {
         $new_user[$key] = $value;
         if ($key == 'omOrderId') {
             $new_user[$key] = $id;
         }
         if ($key == 'countryName') {
             $new_user[$key] = $countryName;
         }
         if ($key == 'state') {
             $new_user[$key] = $state;
         }
         if ($key == 'city') {
             $new_user[$key] = $city;
         }
         if ($key == 'landline') {
             $new_user[$key] = $landline;
         }
         if ($key == 'phone') {
             $new_user[$key] = $phone;
         }
         if ($key == 'zipCode') {
             $new_user[$key] = $zipCode;
         }
         if ($key == 'street') {
             $new_user[$key] = $street;
         }
         if ($key == 'address2') {
             $new_user[$key] = $address2;
         }
         if ($key == 'address3') {
             $new_user[$key] = $address3;
         }
     }
     $sql = array();
     foreach ($new_user as $key => $value) {
         if (is_numeric($value)) {
             $sql[] = "{$key}={$value}";
         } else {
             $sql[] = "{$key}='{$value}'";
         }
     }
     $sql = implode(",", $sql);
     $msg = copyOrderModel::insertUser($sql, $userId);
     if (!$msg) {
         self::$errCode = 503;
         self::$errMsg = "插入复制订单用户信息失败!";
         BaseModel::rollback();
         return false;
     }
     //插入订单明细信息
     foreach ($details as $nums => $detail) {
         $new_detail = array();
         $skuinfo = explode("*", $detail_sku[$nums]);
         foreach ($detail as $key => $value) {
             if ($key == 'id') {
                 continue;
             }
             $new_detail[$key] = $value;
             if ($key == 'omOrderId') {
                 $new_detail[$key] = $id;
             }
             if ($key == 'sku') {
                 $new_detail[$key] = $skuinfo[0];
             }
             if ($key == 'amount') {
                 $new_detail[$key] = $skuinfo[1];
             }
         }
         $sql = array();
         foreach ($new_detail as $key => $value) {
             if ($key == 'createdTime') {
                 $sql[] = "{$key}=" . time() . " ";
                 continue;
             }
             if (is_numeric($value)) {
                 $sql[] = "{$key}={$value}";
             } else {
                 $sql[] = "{$key}='{$value}'";
             }
         }
         $sql = implode(",", $sql);
         $msg = copyOrderModel::insertDetail($sql, $userId);
         if (!$msg) {
             self::$errCode = 504;
             self::$errMsg = "插入复制订单明细信息失败!";
             BaseModel::rollback();
             return false;
         }
     }
     //插入复制订单扩展信息
     $new_extension = array();
     foreach ($extension as $key => $value) {
         if ($key == 'omOrderId') {
             $new_extension[$key] = $id;
             continue;
         }
         $new_extension[$key] = $value;
     }
     $sql = array();
     foreach ($new_extension as $key => $value) {
         if (is_numeric($value)) {
             $sql[] = "{$key}={$value}";
         } else {
             $sql[] = "{$key}='{$value}'";
         }
     }
     $sql = implode(",", $sql);
     $msg = copyOrderModel::insertExtension($table, $sql, $userId);
     if (!$msg) {
         self::$errCode = 505;
         self::$errMsg = "插入复制订单扩展信息失败!";
         BaseModel::rollback();
         return false;
     }
     //插入复制订单仓库信息
     if ($warehouse) {
         $new_warehouse = array();
         foreach ($warehouse as $key => $value) {
             if ($key == 'omOrdeId') {
                 $new_warehouse[$key] = $id;
                 continue;
             }
             $new_warehouse[$key] = $value;
         }
         $sql = array();
         foreach ($new_warehouse as $key => $value) {
             if (is_numeric($value)) {
                 $sql[] = "{$key}={$value}";
             } else {
                 $sql[] = "{$key}='{$value}'";
             }
         }
         $sql = implode(",", $sql);
         $msg = copyOrderModel::insertWarehouse($sql, $userId);
         if (!$msg) {
             self::$errCode = 506;
             self::$errMsg = "插入复制订单仓库信息失败!";
             BaseModel::rollback();
             return false;
         }
     }
     //插入复制订单备注信息
     if ($notes) {
         $new_note = array();
         foreach ($notes as $key => $value) {
             if ($key == 'omOrdeId') {
                 $new_note[$key] = $id;
                 continue;
             }
             if ($key == 'userId') {
                 $new_note[$key] = $userId;
                 continue;
             }
             if ($key == 'createdTime') {
                 $new_note[$key] = time();
                 continue;
             }
             $new_note[$key] = $value;
         }
         $sql = array();
         foreach ($new_note as $key => $value) {
             if (is_numeric($value)) {
                 $sql[] = "{$key}={$value}";
             } else {
                 $sql[] = "{$key}='{$value}'";
             }
         }
         $sql = implode(",", $sql);
         $msg = copyOrderModel::insertNote($sql);
         if (!$msg) {
             self::$errCode = 506;
             self::$errMsg = "插入复制订单备注信息失败!";
             BaseModel::rollback();
             return false;
         }
     }
     //完全插入成功再插入复制记录和订单操作记录
     $msg = copyOrderModel::insertCopyRecord($orderid, $id, $userId);
     if (!$msg) {
         self::$errCode = 507;
         self::$errMsg = "插入复制订单记录失败!";
         BaseModel::rollback();
         return false;
     }
     //最后修改原订单为复制订单
     $msg = copyOrderModel::updateOrder($orderid);
     if (!$msg) {
         self::$errCode = 508;
         self::$errMsg = "修改原订单失败!";
         BaseModel::rollback();
         return false;
     }
     BaseModel::commit();
     return true;
 }
Пример #5
0
 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');
 }