<?php
/**
 * @file
 * @todo Add file header description
 */

function tripal_project_administration_description_page() {
  $output = '';


  return $output;
}

function tripal_project_configuration_page() {
  $output = '';

  $output .= drupal_get_form('tripal_project_sync_projects_form');

  return $output;
}

function tripal_project_sync_projects_form($form_state = NULL) {
  $form = array();

  $form['sync'] = array(
    '#type' => 'fieldset',
    '#title' => 'Sync Projects'
  );

  $form['sync']['description'] = array(
    '#type' => 'item',
    '#value' => 'Many of the details for projects are stored in chado. Often other tripal '
      .'modules may create projects as a means of grouping data together. Sync\'ing projects '
      .'in chado created drupal pages (known as nodes) which display the data to priviledged users.'
  );

  $form['sync']['submit'] = array(
    '#type' => 'submit',
    '#value' => 'Sync All Projects',

  );

  return $form;
}

function tripal_project_sync_projects_form_submit($form, &$form_state) {
  global $user;

  //sync'ing is done by a tripal_job that is added here
  $job_id = tripal_add_job('Sync Projects', 'tripal_project',
  'tripal_project_sync_all_projects', array(), $user->uid);

}

function tripal_project_sync_all_projects() {

  //retrieve all projects in drupal
  $resource = db_query('SELECT project_id FROM {chado_project}');
  $drupal_projects = array();
  while ($r = db_fetch_object($resource)) {
    $drupal_projects[$r->project_id] = $r->project_id;
  }

  // retrieve all projects in chado
  $chado_projects = array();
  $previous_db = tripal_db_set_active('chado');
  $resource = db_query('SELECT project_id FROM {project}');
  tripal_db_set_active($previous_db);
  while ($r = db_fetch_object($resource)) {
    // if not already in drupal add to list to be sync'd
    if (!isset($drupal_projects[$r->project_id])) {
      $chado_projects[$r->project_id] = $r->project_id;
    }
  }

  print 'Number of Projects to Sync: ' . sizeof($chado_projects) . "\n";

  foreach ($chado_projects as $project_id) {
    $project = tripal_core_chado_select('project', array('name', 'description'), array('project_id' => $project_id));

    // create node
    $new_node = new stdClass();
    $new_node->type = 'chado_project';
    $new_node->uid = $user->uid;
    $new_node->title = $project[0]->name;
    $new_node->project_id = $project_id;
    $new_node->description = $project[0]->description;
    node_validate($new_node);
    $errors = form_get_errors();
    if (!$errors) {
      $node = node_submit($new_node);
      node_save($node);
      if ($node->nid) {
        print "Added " . $project[0]->name . " (Node ID:" . $node->nid . ")\n";
      }
    }
    else {
      print "Failed to insert project: " . $project[0]->name . "\n";
      print "Errors: " . print_r($errors, TRUE) . "\n";
    }

  }


}