uc_shipping_zones_admin.inc in Ubercart Global Quote 6

Administration pages for uc_shipping_zones

File

uc_shipping_zones/uc_shipping_zones_admin.inc

<?php

/**
 * @file
 * Administration pages for uc_shipping_zones
 */

/**
 * Theme zones admin form
 */
function theme_uc_shipping_zones_admin($form) {
  $header = array(
    t('Delete'),
    t('Name'),
    t('Countries'),
    t('Regions'),
  );
  $result = db_query("SELECT * FROM {uc_shipping_zones} ORDER BY name");
  while ($r = db_fetch_object($result)) {
    $row = array();
    $zid = $r->zid;
    $row[] = drupal_render($form['zones'][$zid]['delete']);
    $row[] = $r->name;
    $row[] = str_replace('|', ' ', $r->countries);
    if ($r->regions && count($r->regions)) {
      $row[] = str_replace('|', ' ', $r->regions);
    }
    else {
      $row[] = 'All';
    }
    $row[] = l('edit', 'admin/store/settings/quotes/methods/zones/' . $zid);
    $rows[] = $row;
  }
  if (count($rows) == 0) {
    $rows[] = array(
      array(
        'data' => t('No zones found'),
        'colspan' => 4,
      ),
    );
  }
  $output .= theme('table', $header, $rows);
  $output .= drupal_render($form);
  return $output;
}

/*
 * uc_shipping_zones admin form
 */
function uc_shipping_zones_admin($form_state, $id = 0) {
  ahah_helper_register($form, $form_state);
  $form = array();
  $form['zones'] = array(
    '#tree' => TRUE,
  );
  if ($id) {
    $field = "Edit Zone";
  }
  else {
    $field = 'Add a new zone';
    $edit->name = NULL;
    $edit->id = NULL;
    $edit->country = NULL;
    $edit->regions = NULL;
  }
  $zquery = db_query("SELECT * FROM {uc_shipping_zones}");
  while ($zone = db_fetch_object($zquery)) {
    $zid = $zone->zid;
    $form['zones'][$zid]['delete'] = array(
      '#type' => 'checkbox',
      '#default_value' => 0,
    );

    // Edit zone
    if ($id && $id == $zid) {
      $edit = $zone;
      $edit->countries = explode('|', $zone->countries);
      $edit->regions = explode('|', $zone->regions);
    }
  }
  $countries = array();
  foreach (uc_get_country_data() as $c) {
    $countries[$c['country_name'] . ',' . $c['country_id']] = $c['country_name'];
  }
  if (isset($form_state['storage']['zone']['country'])) {
    $edit->countries = $form_state['storage']['zone']['country'];
    unset($form_state['storage']['zone']['country']);
  }
  $form['zone'] = array(
    '#type' => 'fieldset',
    '#title' => t($field),
    '#description' => t('Shipping zone options'),
    '#collapsible' => TRUE,
    '#collapsed' => FALSE,
    '#prefix' => '<div id="shipping-zone-wrapper">',
    // This is our wrapper div.
    '#suffix' => '</div>',
    '#tree' => TRUE,
  );
  $form['zone']['zid'] = array(
    '#type' => 'hidden',
    '#value' => $edit->zid,
  );
  $form['zone']['name'] = array(
    '#type' => 'textfield',
    '#title' => t('Zone name'),
    '#default_value' => '',
    '#default_value' => $edit->name,
    '#size' => 40,
    '#description' => t('Name for the zone'),
  );
  $form['zone']['country'] = array(
    '#type' => 'select',
    '#title' => t('Countries'),
    '#options' => $countries,
    '#default_value' => $edit->countries,
    '#multiple' => TRUE,
    '#description' => t('Select all the countries of the zone. ') . l('Add countries', 'admin/store/settings/countries/edit'),
    '#ahah' => array(
      'event' => 'change',
      'path' => ahah_helper_path(array(
        'zone][region',
      )),
      'wrapper' => 'dropdown-region-replace',
    ),
  );
  $form['zone']['region'] = array(
    '#type' => 'select',
    '#title' => t('Region'),
    '#options' => uc_shipping_zones_regions_ajax($edit->countries),
    '#default_value' => $edit->regions,
    '#multiple' => TRUE,
    '#description' => t('Select regions. '),
    '#prefix' => '<div id="dropdown-region-replace">',
    '#suffix' => '</div>',
  );
  $form['buttons']['submit'] = array(
    '#type' => 'submit',
    '#value' => t('Submit Changes'),
  );
  $form['#redirect'] = 'admin/store/settings/quotes/methods/zones';
  return $form;
}
function uc_shipping_zones_admin_validate($form, &$form_state) {
  $values = $form_state['values'];
  if (!is_array($values['zones']) || !array_search(array(
    'delete' => 1,
  ), $values['zones'])) {
    if (!$values['zone']['name']) {
      form_set_error('name', t('Enter a name for the zone'));
    }
    if (!is_array($values['zone']['country']) || count($values['zone']['country']) < 1) {
      form_set_error('country', t('You must select a country for your zone'));
    }
    else {

      // Check overlapping zones.
      $zones = uc_shipping_zones_get();
      $cerror = array();
      $rerror = array();
      if (isset($values['zone']['region'][''])) {
        $values['zone']['region'] = NULL;
      }
      foreach ($zones as $zone) {

        // Not the same outdated zone
        if (!$values['zone']['zid'] || $values['zone']['zid'] != $zone->zid) {
          $check_regions = FALSE;

          // Check for overlapping countries
          foreach ($values['zone']['country'] as $vc) {

            // Country defined in another zone
            if (in_array($vc, explode('|', $zone->countries))) {

              // all regions
              if ($values['zone']['region'] == NULL || $values['zone']['region'] == NULL) {
                $cerror[] = $vc;
              }
              else {
                $check_regions = TRUE;
              }
            }
          }

          // Check for region overlapping
          if ($check_regions) {
            foreach ($values['zone']['region'] as $vr) {
              if (in_array($vr, explode('|', $zone->regions))) {
                $rerror[] = $vr;
              }
            }
          }
        }
      }
      if (count($cerror)) {
        form_set_error('country', t('The following countries are selected in other zones: %list', array(
          '%list' => implode(', ', $cerror),
        )));
      }
      if (count($rerror)) {
        form_set_error('region', t('The following regions are selected in other zones: %list', array(
          '%list' => implode(', ', $rerror),
        )));
      }
    }
  }
}
function uc_shipping_zones_regions_ajax($selection) {
  if (!count($selection)) {
    return array(
      '' => 'All',
    );
  }
  $countries = array();
  foreach ($selection as $country) {
    $cid = explode(',', $country);
    $countries[] = sprintf('%d', $cid[1]);
  }
  $countries = implode(',', $countries);
  $result = db_query("SELECT * FROM {uc_zones} WHERE zone_country_id IN (%s) ORDER BY 'zone_name'", $countries);
  $options[''] = t('All');
  while ($zone = db_fetch_object($result)) {
    $options[$zone->zone_name . ',' . $zone->zone_id] = $zone->zone_name;
  }
  return $options;
}

/*
 * Admin form submit
 */
function uc_shipping_zones_admin_submit($form, &$form_state) {

  // check for and handle any deletions
  if (is_array($form_state['values']['zones'])) {
    foreach ($form_state['values']['zones'] as $zid => $value) {
      if ($value['delete']) {
        db_query("DELETE FROM {uc_shipping_zones} WHERE zid = %d", $zid);
      }
    }
  }
  if ($form_state['values']['zone']['name'] && is_array($form_state['values']['zone']['country']) && count($form_state['values']['zone']['country'])) {
    $countries = implode('|', $form_state['values']['zone']['country']);
    $regions = implode('|', $form_state['values']['zone']['region']);
    if ($form_state['values']['zone']['zid']) {
      db_query("UPDATE {uc_shipping_zones} SET name='%s', countries='%s', regions='%s' WHERE zid='%d'", check_plain($form_state['values']['zone']['name']), $countries, $regions, $form_state['values']['zone']['zid']);
    }
    else {
      db_query("INSERT INTO {uc_shipping_zones} (name, countries, regions) VALUES ('%s','%s', '%s')", check_plain($form_state['values']['zone']['name']), $countries, $regions);
    }
  }
}

Functions

Name	Description
theme_uc_shipping_zones_admin	Theme zones admin form
uc_shipping_zones_admin
uc_shipping_zones_admin_submit
uc_shipping_zones_admin_validate
uc_shipping_zones_regions_ajax