function support_pm_admin_project_form_submit in Support Ticketing System 6

Same name and namespace in other branches

1. 7 support_pm/support_pm.admin.inc \support_pm_admin_project_form_submit()

Save new or updated project definition.

File

support_pm/support_pm.admin.inc, line 606

Code

function support_pm_admin_project_form_submit($form, &$form_state) {
  $client = support_client_load($form_state['values']['clid']);
  if ($form_state['clicked_button']['#value'] == t('Delete project')) {
    drupal_set_message(t('Deleted %project project.', array(
      '%project' => $form_state['values']['project'],
    )));
    db_query('DELETE FROM {support_project} WHERE projid = %d', $form_state['values']['projid']);
    db_query('DELETE FROM {support_project_client} WHERE projid = %d', $form_state['values']['projid']);
    db_query('DELETE FROM {support_project_ticket} WHERE projid = %d', $form_state['values']['projid']);
  }
  else {
    if ($form_state['clicked_button']['#value'] == t('Update project')) {
      db_query("UPDATE {support_project} SET project = '%s', path = '%s', disabled = %d, weight = %d WHERE projid = %d", $form_state['values']['project'], $form_state['values']['path'], $form_state['values']['disabled'], $form_state['values']['weight'], $form_state['values']['projid']);
      db_query('DELETE FROM {support_project_client} WHERE projid = %d', $form_state['values']['projid']);
      foreach ($form_state['values']['clids'] as $clid) {
        db_query('INSERT INTO {support_project_client} (projid, clid) VALUES(%d, %d)', $form_state['values']['projid'], $clid);
      }
      drupal_set_message(t('Updated %project project.', array(
        '%project' => $form_state['values']['project'],
      )));
    }
    else {
      db_query("INSERT INTO {support_project} (project, path, disabled, weight) VALUES('%s', '%s', %d, %d)", $form_state['values']['project'], $form_state['values']['path'], $form_state['values']['disabled'], $form_state['values']['weight']);
      $projid = db_last_insert_id('support_project', 'projid');
      foreach ($form_state['values']['clids'] as $clid) {
        db_query('INSERT INTO {support_project_client} (projid, clid) VALUES(%d, %d)', $projid, $clid);
      }
      drupal_set_message(t('Created %project project.', array(
        '%project' => $form_state['values']['project'],
      )));
    }
  }
  menu_rebuild();
  drupal_goto('admin/support/project');
}