PHP wc_get_static_groups_ids_array示例

示例#1

文件： customers.php 项目： sajidshah/le-dolci

function wc_crm_update_user_groups($group_ids = array(), $customers_email = '')
{
    if (empty($customers_email)) {
        return false;
    }
    global $wpdb;
    $groups_array = wc_get_static_groups_ids_array();
    $table = $wpdb->prefix . 'wc_crm_groups_relationships';
    $wpdb->hide_errors();
    $wpdb->query("DELETE FROM {$table} WHERE customer_email = '{$customers_email}';");
    if (is_array($group_ids) && !empty($group_ids)) {
        foreach ($group_ids as $group_id) {
            if (!in_array($group_id, $groups_array)) {
                continue;
            }
            $data = array('group_id' => $group_id, 'customer_email' => $customers_email);
            $wpdb->query("INSERT INTO {$table} (group_id, customer_email) VALUES ({$group_id}, '{$customers_email}') ON DUPLICATE KEY UPDATE group_id = {$group_id}, customer_email = '{$customers_email}';");
        }
    }
}

示例#2

文件： group-functions.php 项目： daanbakker1995/vanteun

function wc_crm_add_to_group($group_id = 0, $customers_ids = array())
{
    if (!$group_id || empty($customers_ids) || !is_array($customers_ids)) {
        return false;
    }
    $groups_array = wc_get_static_groups_ids_array();
    if (!in_array($group_id, $groups_array)) {
        return false;
    }
    foreach ($customers_ids as $c_id) {
        global $wpdb;
        $data = array('group_id' => $group_id, 'c_id' => $c_id);
        $table = $wpdb->prefix . 'wc_crm_groups_relationships';
        $wpdb->hide_errors();
        if (!$wpdb->query("SELECT ID FROM {$table} WHERE group_id = {$group_id} AND c_id = {$c_id} ")) {
            $wpdb->query("INSERT INTO {$table} (group_id, c_id) VALUES ({$group_id}, '{$c_id}');");
        }
    }
}

示例#3

文件： class-wc-crm-customer.php 项目： daanbakker1995/vanteun

 public function update_groups($group_ids = array())
 {
     if ($this->customer_id <= 0) {
         return false;
     }
     global $wpdb;
     if (is_array($group_ids) && !empty($group_ids)) {
         $groups_array = wc_get_static_groups_ids_array();
         $table = $wpdb->prefix . 'wc_crm_groups_relationships';
         $wpdb->hide_errors();
         $wpdb->query("DELETE FROM {$table} WHERE c_id = '{$this->customer_id}';");
         foreach ($group_ids as $group_id) {
             if (!in_array($group_id, $groups_array)) {
                 continue;
             }
             $data = array('group_id' => $group_id, 'c_id' => $this->customer_id);
             $wpdb->insert($table, $data, array('%d', '%d'));
         }
     }
 }