public function act_addNote($orderid, $data)
{
$add_notes = $data['add_notes'];
//var_dump($add_pitemid);
if (empty($add_notes)) {
self::$errCode = '400';
self::$errMsg = '没有提交数据';
return false;
}
foreach ($add_notes as $key => $value) {
$add_note = array();
if (isset($add_notes[$key]) && !empty($add_notes[$key])) {
$add_note['content'] = $add_notes[$key];
}
if ($add_note) {
$add_note['omOrderId'] = $orderid;
$add_note['userId'] = $_SESSION['sysUserId'];
$add_note['createdTime'] = time();
if (!OrderAddModel::insertOrderNotesRow($add_note)) {
self::$errCode = OrderModifyModel::$errCode;
self::$errMsg = OrderModifyModel::$errMsg;
return false;
}
}
}
self::$errCode = OrderModifyModel::$errCode;
self::$errMsg = OrderModifyModel::$errMsg;
return true;
}
public function act_ApplicationException($omOrderId, $content)
{
$tableName = "om_unshipped_order";
$storeId = 1;
if (!$omOrderId || !$content) {
self::$errCode = '5806';
self::$errMsg = 'param is error';
return array();
}
$where = " WHERE id = " . $omOrderId . " AND orderStatus = " . C('STATESHIPPED');
$returnStatus0 = array('orderStatus' => C('STATEINTERCEPTSHIP'), 'orderType' => C('STATEPENDING_APPEXC'));
if (!OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) {
self::$errCode = '5807';
self::$errMsg = 'update error';
return false;
}
$insertOrderNoteDada = array('omOrderId' => $omOrderId, 'content' => $content, 'userId' => 0, 'createdTime' => time());
if ($insertOrderNoteids = OrderAddModel::insertOrderNotesRow($insertOrderNoteDada)) {
self::$errCode = '5808';
self::$errMsg = 'insert Note error';
return false;
}
self::$errCode = '200';
self::$errMsg = 'sync success';
return true;
}
/**
* 插入订单对应下的总表信息
* @para $data as array
* @add by Herman.Xi
* @last modified 20131022
* $in 默认为进入订单模式
*/
public static function insertAllOrderRow($orderData, $extension = 'ebay', $in = true)
{
self::initDB();
//var_dump($orderData); exit;
$obj_order_data = $orderData['orderData'];
$orderExtenData = $orderData['orderExtenData'];
$orderUserInfoData = $orderData['orderUserInfoData'];
$orderDetailArr = $orderData['orderDetail'];
if ($obj_order_data['platformId'] == "2") {
//ebay
$ebay_orderid = $orderExtenData['orderId'];
$tName = 'om_unshipped_order_extension_ebay';
$where = "WHERE orderId='{$ebay_orderid}'";
$flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where);
$tName = 'om_shipped_order_extension_ebay';
$flagCountshipped = OmAvailableModel::getTNameCount($tName, $where);
} else {
$tName = 'om_unshipped_order';
$where = "WHERE accountId='{$obj_order_data['accountId']}' AND recordNumber='{$obj_order_data['recordNumber']}' AND platformId={$obj_order_data['platformId']} and is_delete ='0'";
$flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where);
$tName = 'om_shipped_order';
$flagCountshipped = OmAvailableModel::getTNameCount($tName, $where);
}
//if (empty ($flagCountUnshipped) && empty ($flagCountshipped)) { //判断订单是否已经在系统2个订单表（未发货和已发货）中存在
if (empty($flagCountUnshipped) && empty($flagCountshipped)) {
$platfrom = omAccountModel::getPlatformSuffixById($obj_order_data['platformId']);
$extension = $platfrom['suffix'];
//获取后缀名称
BaseModel::begin();
//开始事务
$insertOrderDataRow = self::insertOrderRow($obj_order_data);
//插入到order表
if (empty($insertOrderDataRow)) {
BaseModel::rollback();
//throw new Exception('insert orderData error');
}
$orderExtenData['omOrderId'] = $insertOrderDataRow;
$orderUserInfoData['omOrderId'] = $insertOrderDataRow;
$resultExten = self::insertExtension($orderExtenData, $extension);
//插入到order_extend表
if (!$resultExten) {
BaseModel::rollback();
//throw new Exception('insert orderExtenData error');
}
$resultUserInfo = self::insertUserinfoRow($orderUserInfoData);
//插入到order_userInfo表
if (!$resultUserInfo) {
BaseModel::rollback();
//throw new Exception('insert orderUserInfoData error');
}
foreach ($orderDetailArr as $orderDetail) {
$orderDetailData = $orderDetail['orderDetailData'];
$orderDetailExtenData = $orderDetail['orderDetailExtenData'];
$orderDetailData['omOrderId'] = $insertOrderDataRow;
$orderDetailData['createdTime'] = time();
$insertOrderDatilRow = self::insertOrderdetail($orderDetailData);
//插入到detail表
if (empty($insertOrderDatilRow)) {
BaseModel::rollback();
//throw new Exception('insert orderDetailData error');
}
$orderDetailExtenData['omOrderdetailId'] = $insertOrderDatilRow;
if ($orderDetailExtenData) {
$resultOrderDetailExten = self::insertDetailExtension($orderDetailExtenData, $extension);
//插入到detailExtend
if (!$resultOrderDetailExten) {
BaseModel::rollback();
//throw new Exception('insert orderDetailExtenData error');
}
}
}
if ($obj_order_data['platformId'] == 1) {
$insertOrderidsDada = array('omOrderId' => $insertOrderDataRow, 'PayPalPaymentId' => $orderData['orderExtenData']['PayPalPaymentId'], 'orderid' => $orderData['orderExtenData']['orderId'], 'accountId' => $orderData['orderData']['accountId'], 'saletime' => time());
$insertOrderids = OrderidsModel::insertOrderidsList($insertOrderidsDada);
if (!$insertOrderids) {
BaseModel::rollback();
//throw new Exception('insert orderIds error');
}
}
if (isset($orderData['orderNote']) && !empty($orderData['orderNote'])) {
$orderNote = $orderData['orderNote'];
$insertOrderNoteDada = array('omOrderId' => $insertOrderDataRow, 'content' => $orderNote['content'], 'userId' => $orderNote['userId'], 'createdTime' => $orderNote['createdTime']);
$insertOrderNoteids = OrderAddModel::insertOrderNotesRow($insertOrderNoteDada);
if (!$insertOrderNoteids) {
BaseModel::rollback();
//throw new Exception('insert orderNote error');
}
}
$buyerInfo = $orderUserInfoData;
$buyerInfo['platformId'] = $obj_order_data['platformId'];
unset($buyerInfo['omOrderId']);
unset($buyerInfo['countrySn']);
unset($buyerInfo['currency']);
unset($buyerInfo['currency']);
$insertBuyerInfo = self::insertBuyerInfoRow($buyerInfo);
if (!$insertBuyerInfo) {
BaseModel::rollback();
//throw new Exception('insert BuyerInfo error');
}
$ProductStatus = new ProductStatus();
if (!$ProductStatus->updateSkuStatusByOrderStatus(array($insertOrderDataRow))) {
BaseModel::rollback();
//throw new Exception('update puchaseinfo error');
}
BaseModel::commit();
BaseModel::autoCommit();
return $insertOrderDataRow;
} else {
self::$errCode = "400";
self::$errMsg = "已经包含订单信息，不能重复插入！";
return false;
}
}
