91在线精品亚洲一区二区,亚洲免费视频网址,先锋影音色资源

訂單預覽中的訂單注釋

woocommerce_admin_order_preview_end操作鉤子沒有參數。所以首先要使用woocommerce_admin_order_preview_get_order_details操作鉤子，在這里可以訪問$order對象

對于訂單注釋，您可以使用wc_get_order_notes函數，您可以在此處使用check-their參數。

// Add order notes so you can accees in `woocommerce_admin_order_preview_start`
add_filter( 'woocommerce_admin_order_preview_get_order_details', 'admin_order_preview_add_order_notes_data', 10, 2 );
function admin_order_preview_add_order_notes_data( $data, $order ) {
        
    $notes = wc_get_order_notes([
        'order_id' => $order->get_id(),
    ]);

    ob_start();

    ?>
    <div class="wc-order-preview-order-note-container" style="padding: 20px;">
        <div class="wc-order-preview-custom-note">
        <h2 class="order-note">Order Note:</h2>
            <ul class="order_notes">
                <?php
                if ( $notes ) {
                    foreach ( $notes as $note ) {
                        $css_class   = array( 'note' );
                        $css_class[] = $note->customer_note ? 'customer-note' : '';
                        $css_class[] = 'system' === $note->added_by ? 'system-note' : '';
                        $css_class   = apply_filters( 'woocommerce_order_note_class', array_filter( $css_class ), $note );
                        ?>
                        <li rel="<?php echo absint( $note->id ); ?>" class="<?php echo esc_attr( implode( ' ', $css_class ) ); ?>">
                            <div class="note_content">
                                <?php echo wpautop( wptexturize( wp_kses_post( $note->content ) ) ); // @codingStandardsIgnoreLine ?>
                            </div>
                            <p class="meta">
                                <abbr class="exact-date" title="<?php echo esc_attr( $note->date_created->date( 'Y-m-d H:i:s' ) ); ?>">
                                    <?php
                                    
                                    echo esc_html( sprintf( __( '%1$s at %2$s', 'woocommerce' ), $note->date_created->date_i18n( wc_date_format() ), $note->date_created->date_i18n( wc_time_format() ) ) );
                                    ?>
                                </abbr>
                                <?php
                                if ( 'system' !== $note->added_by ) :
                                    
                                    echo esc_html( sprintf( ' ' . __( 'by %s', 'woocommerce' ), $note->added_by ) );
                                endif;
                                ?>
                                <a href="#" class="delete_note" role="button"><?php esc_html_e( 'Delete note', 'woocommerce' ); ?></a>
                            </p>
                        </li>
                        <?php
                    }
                } else {
                    ?>
                    <li class="no-items"><?php esc_html_e( 'There are no notes yet.', 'woocommerce' ); ?></li>
                    <?php
                }
                ?>
            </ul>
        </div>
    </div>
    <?php

    $order_notes = ob_get_clean();  

    $data['order_notes'] = $order_notes;

    return $data;

}

//order notes
add_action( 'woocommerce_admin_order_preview_start', 'woocommerce_admin_order_preview_order_notes' );
function woocommerce_admin_order_preview_order_notes() {
    ?> {{{data.order_notes}}} <?php
}

測試和工作。

點擊查看詳細內容

如何顯示自己的訂單列表？

它會轉到上一頁。問題是，在評估索引的邏輯時，存在一個問題：它旨在找到用戶的Frontend_Order對象，但request.user不是User對象，而是AnonymousUser。因此，您應該進行適當的檢查： def index(request): total_user = User.objects.count()-1 if request.user.is_authenticated: frontend_order_list = request.user.user_frontend_order.all() else: frontend_order_list = Frontend_Order.objects.none() context = { 'total_user': total_user, 'frontend_order_list': frontend_order_list } return render(request, '0_index.html', context) 注意：通常最好使用settings.AUTH_USER_MODEL[Django-doc]來引用用戶模型，而不是直接使用User模型[Django-doc]。有關更多信息，請參閱文檔的User模型部分。注意：Django中的模型是用PascalCase編寫的，而不是snake_case，因此您可能希望將

顯示上次訂單日期

這似乎只是一個簡單的聚合函數max(date)group by所有non-aggregated字段 SELECT a.id , a.name , c.email , u.activated , i.available_integration_id , totals.cnt_orders AS "Total Orders", totals.sum_amount AS "Total Amount", max(o.created_at) as Most_Recent_OrderFROM accounts a INNER JOIN users u ON a.id = u.account_id INNER JOIN contacts c ON u.contact_id = c.id LEFT JOIN integrations i ON a.id = i.account_id LEFT JOIN orders o ON a.id = o.account_id LEFT JOIN ( SELECT a.id , COUNT( t.id ) AS cnt_orders, SUM( t.amount ) AS sum_amount FROM accounts a INNER JOIN orders o ON o.account_id = a.id INNER JOIN transactions t

在MySQL中每隔n小時獲取一次訂單

timestamp diff就是您的朋友： WHERE TIMESTAMPDIFF(HOUR, o_created, Now()) IN (8, 16, 24, … )

我需要幫助顯示每年最貴的訂單

盡量使用over子句和按年份劃分。它將幫助你得到想要的結果。 select year(h.OrderDate) as "Years", h.SalesOrderID, p.FirstName, p.LastName, **max(d.LineTotal) over (partition by year(h.OrderDate) order by year(h.OrderDate))** as "Total"from sales.SalesOrderHeader h join Person.Person pon h.CustomerID = p.BusinessEntityID join sales.SalesOrderDetail d on d.SalesOrderID = h.SalesOrderID

Docker統計n秒

docker stats $container在運行時不會退出，因此您的sleep 5沒有機會執行。對于您，您應該使用下一步： --no-stream Disable streaming stats and only pull the first result 然后，你可以使用下一個偽代碼來控制速率： while xxx; do docker stats $container --no-stream sleep 5done

如果所有項目的狀態與訂單完成時間一致，如何僅統計訂單完成時間

為了確認，一個訂單可以由許多sub-part組成。任何sub-part的完成狀態可能（或不）是完整的。您希望獲得所有訂單，其中所有sub-part都已完成。對嗎？如果是這樣，您可以通過計算訂單詳細信息來執行查詢，這樣標記為“finish”的所有條目都等于同一訂單的條目數。一旦結果合格，您就可以從主訂單中獲取詳細信息，例如客戶是誰等。 select PreQueryResult.orderID, PreQueryResult.TotalSubParts, PreQueryResult.FinishedSubParts, o.date, o.status from ( select od.orderid, count(*) as TotalSubParts, sum( case when od.status = 'finish' then 1 else 0 end ) as FinishedSubParts from order_detail od group by od.orderid ) PreQueryResult JOIN Orders o on PreQueryResult.orderid = o.orderid 因此，如果您運行上述查詢，您將看到總零件數和總完工數的結果。要將最終結果集限制為那些已完成的結果集，只需添加一個final WHERE子句，例如 where Pr

按供應商統計訂單導致SQL錯誤

這應該是帖子評論中提到的正確答案。 SELECT DISTINCT(sp.CompanyName), COUNT(DISTINCT o.OrderID) as ordersFROM Suppliers as spINNER JOIN Products as pON sp.SupplierID = p.SupplierIDINNER JOIN [Order Details] as odINNER JOIN Orders as oON od.OrderID = o.OrderIDON p.ProductID = od.ProductIDAND o.OrderID=od.OrderIDGROUP BY sp.CompanyName;

如何與業務員聯合統計拜訪狀態欄

看起來你的salesman-->transaction和salesman-->salesman_activities有一對多的關系。嘗試按如下方式使用子查詢： SELECT `transactions`.`driver_id`, sa.productive_count, SUM(CASE WHEN `transactions`.`transaction_type` = 1 THEN `transactions`.`total_amount` END ) AS sales, SUM(CASE WHEN `transactions`.`transaction_type` = 2 THEN `transactions`.`total_amount` END) AS sales_return FROM `salesman` INNER JOIN (select driver_id, COUNT(CASE WHEN `salesman_activities`.`visit_status` = "Productive" AND DATE(`salesman_activities`.`created_at`) BETWEEN '2020-12-17' AND '2020-12-17' THEN `salesman_activities`.`visit_status` END) AS

將我的帳戶-訂單中的“查看訂單/訂單id”url/endpoint更改為“訂單/訂單id”

將/my-account/view-order/ORDER-ID/url更改為/my-account/orders/ORDER-ID/可以通過應用幾個步驟來完成。步驟1）更改視圖順序端點可以在頁面設置部分的WooCommerce>Settings>Advanced中自定義每個端點的URL 或者改用woocommerce_get_endpoint_url過濾器掛鉤 function filter_woocommerce_get_endpoint_url( $url, $endpoint, $value, $permalink ) { // Specific endpoint if ( $endpoint === 'view-order' ) { // New URL $url = $permalink . 'orders/' . $value; } return $url;}add_filter( 'woocommerce_get_endpoint_url', 'filter_woocommerce_get_endpoint_url', 10, 4 ); 現在更改端點時，查看新url時將看到以下消息： “尚未下訂單”。這是因為加載了/myaccount/orders.php模板文件，而這應該是/myaccount/view-order.php模板步驟2）確保加載了

Oracle SQL根據訂單id統計過去10天內客戶的訂單

你可以嘗試使用self-join和date of減法條件，該條件需要判斷10天內的行數 Query 1: SELECT t1.Customer_ID, t1.Order_NR, COUNT(*) Number_OrdersFROM T t1 INNER JOIN T t2ON t1.Customer_ID = t2.Customer_ID AND t2.Order_Date BETWEEN t1.Order_Date - 10 AND t1.Order_DateGROUP BY t1.Customer_ID, t1.Order_NRORDER BY t1.Order_NR Results: | CUSTOMER_ID | ORDER_NR | NUMBER_ORDERS ||-------------|----------|---------------|| 100 | 1 | 1 || 200 | 2 | 1 || 300 | 3 | 1 || 100 | 4 | 2 || 100 | 5 | 2 || 200 | 6 | 1 || 700 | 7 | 1 || 800 | 8 | 2 || 800 | 9 | 2 || 800 | 10 | 3 |

SQL:查找第n個客戶的第n個訂單

如果“第四個客戶”是指進行第四次租賃的客戶，那么您可以將問題分解為兩個方面：找到第四個客戶，以及找到他們最昂貴的租賃。像這樣： SELECT * FROM payment WHERE customer_id = ( SELECT customer_id FROM payment ORDER BY payment_date LIMIT 1 OFFSET 3) ORDER BY amount DESCLIMIT 1; 在這里，我在子查詢中找到第四個客戶的ID，使用LIMIT&OFFSET只得到我想要的一條記錄。然后在外部查詢中，我只需對該客戶的所有記錄進行排序，然后取金額最大的記錄。

為每個客戶機選擇第一個和第n個訂單

將where t2.rn = 5條件放入left join： select t.client_id, t.order_id as first_order, t2.order_id as fifth_order, t.datetime as first_dt, t2.datetime as fifth_dt,from( select o.client_id, o.order_id, o.datetime, row_number() over(partition by o.client_id order by o.datetime) as rn from "OhMyTable" as o) as t left join ( select o.client_id, o.order_id, o.datetime, row_number() over(partition by o.client_id order by o.order_id) as rn from "OhMyTable" as o order by o.order_id ) as t2 on t.client_id = t2.client_id and t2.rn = 5where t.rn = 1 and t2.datetime is null

從reactjs的firestore獲取過去N天的用戶訂單列表

我在放一個參考函數。你可以根據自己的需要修改它。 n_days_ago_from_now = (days) => new Date(new Date().getTime() - 1000*60*60*24*days)n_days_ago_from_now(3)Date Sat Jan 30 2021 15:42:10 GMT+0400 n_days_ago_from_now(5)Date Thu Jan 28 2021 15:42:13 GMT+0400

嘗試統計總訂單和每月唯一的客戶

請檢查這是否是你想要的答案。架構（MySQL v5.5） create table orders (order_id int, order_date date, order_country varchar(10), customer_id int);insert into orders values(1, '2021/03/04', 'SWE', 1);insert into orders values(2, '2021/03/01', 'SWE', 1);insert into orders values(3, '2021/03/01', 'DK', 3);insert into orders values(4, '2021/03/01', 'DK', 3);insert into orders values(5, '2021/03/03', 'NOR', 2);insert into orders values(6, '2021/02/27', 'DK', 3);insert into orders values(7, '2020/12/30', 'Ger', 4); Query #1 SELECT o.order_date,COUNT(order_id) as orderAmount , coalesce(max(Customer_Count),0) as customer

小程序如何上傳視頻到七牛云

uefi error

js 雙重for循環問題

現在微信里的網頁，怎么才可以不出現底部的前進后退欄？

websocket客戶端發送的數據會按序到底服務器么？

HandlerExecutionChain中為什么有兩個interceptorList？一個array，一個list。

vivo手機安卓10的版本，渲染的還是初始值，未更新

vue-element-admin，打包怎么給js，css加版本號

lazyload + ajax 沒有數據的時候的顯示，無效？

python字典淺復制

小程序 如何上傳視頻到七牛云