我需要通過 REST API 在 Bitrix24 CRM 中填寫自定義字段。當(dāng)談到處理標(biāo)準(zhǔn)字段（如 TITLE、TEL 等）時(shí)，它可以工作，但如果我嘗試通過將自定義字段的屬性名稱放在請(qǐng)求中來確定自定義字段的價(jià)值，端點(diǎn)就會(huì)忽略它。這里有一個(gè)片段：$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" => "me@company1.com", "VALUE_TYPE" => "WORK"] ] , "INDUSTRY" => "MANUFACTURING" , "CUSTOM_FIELD" => "Hey I'm not a standard field and I'm going to be ignored" ] ]);有人有同樣的需求嗎？我該如何解決？
1 回答
隔江千里
TA貢獻(xiàn)1906條經(jīng)驗(yàn) 獲得超10個(gè)贊
您需要另一次 使用自己的參考JOIN表，因?yàn)槟谠摫砩喜樵?2 次不同的元鍵，因此請(qǐng)嘗試以下操作：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 ) );
}
測(cè)試和工作。
- 1 回答
- 0 關(guān)注
- 225 瀏覽
添加回答
舉報(bào)
0/150
提交
取消