我需要通過 REST API 在 Bitrix24 CRM 中填寫自定義字段。當談到處理標準字段（如 TITLE、TEL 等）時，它可以工作，但如果我嘗試通過將自定義字段的屬性名稱放在請求中來確定自定義字段的價值，端點就會忽略它。這里有一個片段：$company = CRest::call( 'crm.company.add', [ 'fields' => [ "TITLE" => "Company 1" , "COMPANY_TYPE" => "Customer" , "CURRENCY_ID" => 'EUR' , "REVENUE" => "123000" , "ADDRESS" => "st. some address" , "ADDRESS_CITY" => "some city" , "ADDRESS_POSTAL_CODE" => "12345" , "ADDRESS_PROVINCE" => "some province" , "PHONE" => [ ["VALUE" => "1230000000", "VALUE_TYPE" => "WORK"] ,["VALUE" => "1234000000", "VALUE_TYPE" => "FAX"] ] , "EMAIL" => [ ["VALUE" => "[email protected]", "VALUE_TYPE" => "WORK"] ] , "INDUSTRY" => "MANUFACTURING" , "CUSTOM_FIELD" => "Hey I'm not a standard field and I'm going to be ignored" ] ]);有人有同樣的需求嗎？我該如何解決？
1 回答
隔江千里
TA貢獻1906條經驗 獲得超10個贊
您需要另一次 使用自己的參考JOIN表，因為您正在該表上查詢 2 次不同的元鍵，因此請嘗試以下操作：wp_woocommerce_order_itemmeta
function get_last_order_id_from_product( $product_id ) {
global $wpdb;
return $wpdb->get_col( $wpdb->prepare( "
SELECT oi.order_id
FROM {$wpdb->prefix}woocommerce_order_items as oi
LEFT JOIN {$wpdb->prefix}woocommerce_order_itemmeta as oim
ON oi.order_item_id = oim.order_item_id
LEFT JOIN {$wpdb->prefix}woocommerce_order_itemmeta as oim2
ON oi.order_item_id = oim2.order_item_id
LEFT JOIN {$wpdb->posts} AS p
ON oi.order_id = p.ID
WHERE p.post_type = 'shop_order'
AND oi.order_item_type = 'line_item'
AND oim.meta_key = '_product_id'
AND oim.meta_value = '%d'
AND oim2.meta_key = 'Ticket Number'
ORDER BY oi.order_id DESC
LIMIT 1, 1
", $product_id ) );
}
測試和工作。
- 1 回答
- 0 關注
- 226 瀏覽
添加回答
舉報
0/150
提交
取消