예제 #1
0
 $actualWeight = $data['actualWeight'];
 $tracknumber = trim($data['tracknumber']);
 $orderids = CombinePackageModel::selectAllRecordByOrderId($orderid);
 var_dump($orderid . "-------" . $orderStatus);
 echo "\n";
 if (C($orderStatus) == 2) {
     //已发货状态
     $where = " WHERE id in (" . join(',', $orderids) . ") AND orderStatus = " . C('STATESHIPPED');
     $returnStatus0 = array('orderStatus' => C("STATESHIPPED"), 'orderType' => C('STATEHASSHIPPED_CONV'));
     if (OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) {
         echo "\n=====同步的订单{$orderid}状态成功======\n";
     }
     $msg = CommonModel::updateWarehouseInfo($orderid, 2, $operateUserId, $operateTime, $actualWeight);
     if ($msg) {
         $where = ' WHERE id in (' . join(",", $orderids) . ') AND orderStatus= ' . C('STATESHIPPED') . ' AND orderType= ' . C('STATEHASSHIPPED_CONV') . ' AND is_delete = 0 ';
         if (OrderindexModel::shiftOrderList($where)) {
             echo "转移成功\n";
         } else {
             echo "转移失败\n";
         }
     }
 } else {
     $where = " WHERE id in (" . join(',', $orderids) . ") AND orderStatus = " . C('STATESHIPPED');
     $returnStatus0 = array('orderType' => C($orderStatus));
     if (OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) {
         echo "\n=====同步的订单{$orderid}状态成功======\n";
     }
     $msg = commonModel::updateWarehouseInfo($orderid, C($orderStatus), $operateUserId, $operateTime);
     if ($tracknumber) {
         $updateArr = array('omOrderId' => $orderid, 'tracknumber' => $tracknumber, 'createdTime' => time());
         $msg = OrderAddModel::insertOrderTrackRow($updateArr);
예제 #2
0
    			echo $account." add error!\n";
    		}
    	}*/
}
exit;
$tableName = "om_account";
/*$db_config	=	C("DB_CONFIG");
$dbConn		=	new mysql();
$dbConn->connect($db_config["master1"][0],$db_config["master1"][1],$db_config["master1"][2],'');
$dbConn->select_db($db_config["master1"][4]);*/
//echo ' [x] ', json_decode($msg->body), "\n";
//var_dump($msg->body); echo "\n";
$where = ' WHERE orderStatus = 100 and orderType in(101,110) and is_delete = 0 and storeId = 1 ';
$orderNum = OrderindexModel::showOrderNum($tableName, $where);
echo $orderNum;
echo "\n";
$page = 1;
$perpage = 1000;
$totalpage = ceil($orderNum / $perpage);
while ($page <= $totalpage) {
    echo "总共{$totalpage}页---现在是第{$page}页\n";
    //$start_num  = ($page-1)*$perpage;
    $start_num = 0;
    $limit = " ORDER BY id LIMIT {$start_num}, {$perpage}";
    if (OrderindexModel::shiftOrderList($where . $limit)) {
        echo "转移成功\n";
    } else {
        echo "转移失败\n";
    }
    $page++;
}