Файловый менеджер

Файловый менеджер - Редактировать - /home/tuudkjt/globeasy/wp-content/plugins/reviewx/app/Services/OrderItemSyncService.php

Назад
<?php namespace Rvx\Services; use DateTime; use Rvx\Utilities\Auth\Client; use Rvx\Utilities\Helper; use Rvx\WPDrill\Facades\DB; class OrderItemSyncService extends \Rvx\Services\Service { protected $orderFullfillmentStatusRelation; protected $validOrderIds = []; protected $validOrdersMetaIds = []; protected $orderItems = []; protected $orderItemCount = 0; protected $orderFullfillmentAtRelation; protected $orderItemOrderRelation = []; protected $orderItemProductRelation = []; protected $orderItemQtyRelation = []; protected $orderItemPriceRelation = []; public function syncOrder($file) : int { $orderCount = 0; $this->orderStat(); $startDate = (new DateTime())->modify('-60 days')->format('Y-m-d H:i:s'); $endDate = (new DateTime())->format('Y-m-d H:i:s'); DB::table('wc_orders')->select(['id', 'customer_id', 'total_amount', 'tax_amount', 'status', 'date_created_gmt', 'date_updated_gmt'])->whereBetween('date_created_gmt', $startDate, $endDate)->chunk(100, function ($orders) use($file, &$orderCount) { foreach ($orders as $order) { $this->validOrderIds[] = (int) $order->id; $order->fulfillment_status = $this->orderFullfillmentStatusRelation[(int) $order->id] ?? null; $order->fulfilled_at = $this->orderFullfillmentAtRelation[(int) $order->id] ?? null; $formattedOrder = $this->formatOrderData($order); Helper::appendToJsonl($file, $formattedOrder); $orderCount++; } }); Helper::rvxLog($orderCount, "Order Done"); return $orderCount; } public function formatOrderData($order) : array { $paid_at = !empty($order->fulfilled_at) && \strtotime($order->fulfilled_at) ? \wp_date('Y-m-d H:i:s', \strtotime($order->fulfilled_at)) : null; return ['rid' => 'rid://Order/' . (int) $order->id, 'wp_id' => (int) $order->id, 'customer_wp_unique_id' => $order->customer_id ? Client::getUid() . '-' . $order->customer_id : null, 'subtotal' => Helper::formatToTwoDecimalPlaces($order->total_amount ?? 0.0), 'tax' => Helper::formatToTwoDecimalPlaces($order->tax_amount ?? 0.0), 'total' => Helper::formatToTwoDecimalPlaces($order->total_amount ?? 0.0), 'status' => isset($order->status) ? Helper::orderStatus(Helper::rvxGetOrderStatus($order->status)) : null, 'review_request_email_sent_at' => null, 'review_reminder_email_sent_at' => null, 'photo_review_email_sent_at' => null, 'paid_at' => $paid_at, 'created_at' => !empty($order->date_created_gmt) ? Helper::validateReturnDate($order->date_created_gmt) : null, 'updated_at' => !empty($order->date_updated_gmt) ? Helper::validateReturnDate($order->date_updated_gmt) : null]; } public function orderStat() { $startDate = (new DateTime())->modify('-60 days')->format('Y-m-d H:i:s'); $endDate = (new DateTime())->format('Y-m-d H:i:s'); DB::table('wc_order_stats')->whereBetween('date_created', $startDate, $endDate)->chunk(100, function ($orderStats) { foreach ($orderStats as $orderStat) { $this->orderFullfillmentStatusRelation[(int) $orderStat->order_id] = Helper::orderItemStatus(Helper::rvxGetOrderStatus($orderStat->status)); $this->orderFullfillmentAtRelation[(int) $orderStat->order_id] = $orderStat->date_completed ?? $orderStat->date_paid ?? null; } }); } public function syncOrderItem($file) : int { $orderItemCount = 0; // Early exit if no valid orders to process if (empty($this->validOrderIds)) { // Helper::rvxLog(0, "No valid orders found, skipping order item sync"); return 0; } // Step 1: Collect valid order items and their IDs $this->validOrdersMetaIds = []; $this->orderItems = []; // Store full order item objects keyed by order_item_id DB::table('woocommerce_order_items')->whereNotIn('order_item_type', ['shipping'])->whereIn('order_id', $this->validOrderIds)->chunk(500, function ($orderItems) { foreach ($orderItems as $orderItem) { $this->validOrdersMetaIds[] = $orderItem->order_item_id; $this->orderItems[$orderItem->order_item_id] = $orderItem; } }); // Early exit if no valid order items found if (empty($this->validOrdersMetaIds)) { // Helper::rvxLog(0, "No valid order items found, skipping meta sync"); return 0; } // Step 2: Fetch associated meta data for the collected order items $this->getOrderItemMeta(); // Step 3: Format and write each order item to the file foreach ($this->orderItems as $orderItemId => $orderItem) { $orderItem->product_id = $this->orderItemProductRelation[$orderItemId] ?? 0; $orderItem->quantity = $this->orderItemQtyRelation[$orderItemId] ?? 0; $orderItem->price = $this->orderItemPriceRelation[$orderItemId] ?? 0.0; $formattedOrderItem = $this->formatOrderItem($orderItem); Helper::appendToJsonl($file, $formattedOrderItem); $orderItemCount++; } Helper::rvxLog($orderItemCount, "Order Item Done"); return $orderItemCount; } public function formatOrderItem($orderItem) : array { $productId = (int) ($orderItem->product_id ?? 0); return ['rid' => 'rid://LineItem/' . (int) $orderItem->order_item_id, 'wp_id' => (int) $orderItem->order_item_id, "wp_unique_id" => Client::getUid() . '-' . (int) $orderItem->order_item_id, 'order_id' => (int) $orderItem->order_id, 'product_wp_unique_id' => Client::getUid() . '-' . $productId, 'name' => $orderItem->order_item_name ?? null, 'quantity' => (int) ($orderItem->quantity ?? 0), 'price' => Helper::formatToTwoDecimalPlaces($orderItem->price ?? 0.0), 'review_id' => null, 'site_id' => Client::getSiteId(), 'fulfillment_status' => $this->orderFullfillmentStatusRelation[(int) $orderItem->order_id] ?? null, 'fulfilled_at' => !empty($this->orderFullfillmentAtRelation[(int) $orderItem->order_id]) ? Helper::validateReturnDate($this->orderFullfillmentAtRelation[(int) $orderItem->order_id]) : null, 'reviewed_at' => null]; } public function getOrderItemMeta() : void { DB::table('woocommerce_order_itemmeta')->whereIn('order_item_id', $this->validOrdersMetaIds)->whereIn('meta_key', ['_product_id', '_qty', '_line_total'])->chunk(100, function ($orderItemMeta) { foreach ($orderItemMeta as $item) { if ($item->meta_key === '_product_id') { $this->orderItemProductRelation[$item->order_item_id] = $item->meta_value; } if ($item->meta_key === '_qty') { $this->orderItemQtyRelation[$item->order_item_id] = $item->meta_value; } if ($item->meta_key === '_line_total') { $this->orderItemPriceRelation[$item->order_item_id] = $item->meta_value; } } }); } }

| ver. 1.6 | Github | . | PHP 8.1.34 | Генерация страницы: 0 | proxy | phpinfo | Настройка