/** * 申请退款 */ 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_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 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 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; }