<?php
/*******************************************************************************
 * Copyright (c) 2006-2013 Eclipse Foundation and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* http://www.eclipse.org/legal/epl-v10.html
*
* Contributors:
*    Matt Ward (Eclipse Foundation) - initial API and implementation
*    Denis Roy (Eclipse Foundation) - 2013 update
*******************************************************************************/

	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/app.class.php");
	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/nav.class.php");
	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/menu.class.php");
	require_once($_SERVER['DOCUMENT_ROOT'] . "/eclipse.org-common/system/evt_log.class.php");

	# Add'l requires for Bugzilla
	require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection.class.php";
	require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_rw.class.php");
	require_once("/home/data/httpd/eclipse-php-classes/system/dbconnection_foundation_ro.class.php");
	
	$App 	= new App();	$Menu 	= new Menu();
	$App->runStdWebAppCacheable();
	include("_projectCommon.php");
	$Menu->addMenuItem("Select another project", "bugz_manager.php", "_self");

	$Session = $App->useSession(true);
	$pageTitle 		= "Bugzilla Manager";
	$pageKeywords	= "";
	$pageAuthor		= "Eclipse Foundation, Inc.";
	
	# Begin buffered output
	ob_start();

	?>
		<div id="maincontent" style="padding:8px;">
		<h1 style="padding-top:10px; padding-bottom:20px;"><?= $pageTitle ?></h1>
		<link rel="stylesheet" type="text/css" href="../css/stylesheet.css" />
		
	<?php
		include "details.html";
		//turn on/off verbose debuging
		define("DEBUG",0);
		//turn on(1) or off(0) actual inserts7
		define("do_inserts",1);

		$Required_Fields = array('project_desc','votes_per_user','max_votes_per_bug','votes_to_confirm','default_milestone');


//connect to the foundation db in 
$fdbc = new DBConnectionFoundation();
$fdbh = $fdbc->connect();
$bdbc = new DBConnectionBugsRW();
$bdbh = $bdbc->connect();
//set the global log options
$evt_log = new EvtLog();
$evt_log->setLogTable("__bugs");
$evt_log->setLogAction("EDIT_PROJECTDETAILS");
$evt_log->setuid($_SESSION['uid']);
$evt_log->setPK2($_SESSION['project']);

debug_msg("</br>Session project:" . $_SESSION['project'] ." ", 1 );

//Special arrays for holding 'special'(my sister sarah is special) projects ADD TO THS AND THINGS 
// SHOULD BE FINE.
$specialproject = array("tptp","tptp.test","tptp.platform","tptp.performance","tptp.monitoring","");

/****************************
*
* Name: do_specialcheck
* Function: does a search for a string(the Session project) within another string(from the special array)
*
* I/O: pointer to the array, returns TRUE is stristr is true.
*
* By: M. Ward
* Date: Feb 2/07
* Comment: I'm sure there is a better way to do this, but I can't think of one
*
*******************************/
function do_specialcheck( &$specialarray) {

  $steps = count( $specialarray );
  debug_msg("In specialcheck there will be: " . $steps . " steps" , 3);
  //auto decrement the steps since all arrays start at 0!
  $steps--;

  while( $steps >= 0 ){
    debug_msg("Specialcheck while loop.  Looking for: " . $specialarray[$steps] . " in " . $_SESSION['project'] . " step: " . $steps,3);
    debug_msg("strlen return: " . strlen(stristr($_SESSION['project'], $specialarray[$steps])),4);
    if( strlen(stristr($_SESSION['project'], $specialarray[$steps])) > 1 ){
      debug_msg("strlen returned 1 or more",4);
      return 1;
    } else {
      $steps--;
    }
  }
  debug_msg("About to return 0 from specialcheck",3);
  return 0;
}

/*****************************
* 
* Name: do_postwork
* Function: does the checks and data inserts.  Putting this stuff here lets me use the return function without screwing up the page.
* 
* I/O: needs to be passed the db handle.
* 
* By: M. Ward
* Date: Feb 22/06
* 
******************************/
function do_postwork( ) {
  global $bdbh;
  global $fdbh;
  global $evt_log;
	
  debug_msg("In post section",2);
  //change up the project settings, in case this is a special project
  if( checkpost($_SESSION['projisclass'] ) ) {
    $workingproject = $_SESSION['projisclass'];
  } else {
     $workingproject = $_SESSION['project'];
  }
  //check that the user is associated with this project
  $query = "SELECT count(*) ProjectID FROM Projects WHERE ( ProjectID IN (SELECT ProjectID FROM PeopleProjects WHERE PersonID ='" . $_SESSION['uid'] . "' AND";
  $query .= "  ( Relation IN ('PM','PD','PL' ) OR ( Relation='CM' AND EditBugs=1 ) )  AND ProjectID='" . $workingproject . "' AND (InactiveDate is NULL OR InactiveDate >= CURRENT_DATE()) ) OR ";
  $query .= " ( ParentProjectID IN (SELECT ProjectID FROM PeopleProjects WHERE PersonID = '" . $_SESSION['uid'] . "' AND Relation IN ('PM','PD') AND ";
  $query .= " (InactiveDate is NULL OR InactiveDate >= CURRENT_DATE())) AND ProjectID='" . $workingproject . "'  ) ) AND BugsName IS NOT NULL; ";
  
  debug_msg($query,3);
  $result = mysql_query($query, $fdbh);
  if($result == FALSE) {
    debug_msg(mysql_error(), 0);
    debug_msg("Please contact the Webmaster about this error. Thank you.",0);
    return; 
  }  
  $data = mysql_fetch_array($result);
  
  if( $data['ProjectID'] >= 1) {
    debug_msg("Checking milestone",2);
    //first need to check that hte default milestone exists in the milestones list, or else it will cause 'A legal target milestone was not set' error
    //build query
    debug_msg("POSTED milestone was: " . $_POST['default_milestone'],3); 
    $query = "select count(*) from milestones where value=\"" . $_POST['default_milestone'] . "\" ";
    $query .= " AND product_id=\"" . $_SESSION['main_product_id'] ."\";";
    debug_msg($query,3);
    $result = mysql_query($query, $bdbh);
    if($result == FALSE) {
      debug_msg(mysql_error(), 0);
      debug_msg("Please contact the Webmaster about this error. Thank you.",0);
      return; 
    }  
    $data = mysql_fetch_array($result);
    if( $data['count(*)'] == 0) {
      debug_msg("You have specified a default milestone that has not been defined.  Please define the milestone first and then change the default.",0);
      return;
    }
  
  	debug_msg("updating bugzilla",2);
    //build the insert command
    $bugsquery = "update products ";
    $bugsquery .= "set description=\"" . $_POST['project_description'] ."\",";
    //make sure that the votes can't be negative(no idea what this would do to bugzilla
    if ( $_POST['votes_per_user'] < 0 )
      $bugsquery .= " votesperuser=0,";
    else 
      $bugsquery .= " votesperuser=\"" . $_POST['votes_per_user'] ."\",";
    //make sure that the votes can't be negative(no idea what this would do to bugzilla
    if ( $_POST['max_votes_per_bug'] < 0 )
      $bugsquery .= " maxvotesperbug=0,";
    else
      $bugsquery .= " maxvotesperbug=\"" . $_POST['max_votes_per_bug'] . "\",";
    $bugsquery .= " defaultmilestone=\"" . $_POST['default_milestone'] . "\" ";
    $bugsquery .= "where name=\"" . $_SESSION['bugsname'] ."\"";
    $bugsquery .= " AND id=\"" . $_SESSION['main_product_id'] ."\";";
    debug_msg($bugsquery,3);
        //set a key for the logs
    $evt_log->setPK1($_POST['bugname']);
    if( do_inserts == 1) {
      $result = mysql_query($bugsquery,$bdbh);
      //check for error
      if($result == FALSE) {
        debug_msg(mysql_error(), 0);
        debug_msg("Please contact the Webmaster about this error. Thank you.",0);
        return;
      }
      //log the event, regardless of wether or not it failed.
      $evt_log->insertModLog($_SESSION['uid']);   
    }  
  }
}

if ( $App->getDBReadOnly() ) {
  print("<h3>The database is currently offline for maintanence.  Please try again later</h3>");
} else {
  //Store the project in the global session cookie 
  if( checkpost($_POST['cmonprojects']) ){
    debug_msg("setting session project as " . $_POST['cmonprojects'] , 2);
    $_SESSION['project'] = $_POST['cmonprojects'];
    debug_msg("Set Session project:" . $_SESSION['project'] ." ", 2);
  } 

  //check to see if this page is being called due to an internal post command.
  if( isset($_POST['Submit']) ){
    do_postwork();
  } 

  debug_msg("projisclass contains:" . $_SESSION['projisclass'],4);
  //wrap to prevent special project lookups
  if ( checkpost($_SESSION['projisclass']) == 0  ) {
    debug_msg("Initial run on a project",3);
    //query to get the bugzilla product name
    $query = "select BugsName from Projects where ProjectID = '" . $_SESSION['project'] . "';";
    debug_msg($query,3);
    $result = mysql_query($query, $fdbh);
    if($result === FALSE){
      debug_msg(mysql_error(), 0);
      debug_msg("Please contact the Webmaster about this error. Thank you.",0);
    }
    $data = mysql_fetch_array($result);
    debug_msg("BugsName: " . $data['BugsName'], 3);
    
  } else if( ( checkpost($_GET['issp']) == 0 ) && ( checkpost($_SESSION['projisclass']) == 1 ) && ( checkpost($_POST['Submit']) == 0 ) &&  (checkpost($_POST['cmonprojects']) == 0) ) {
    debug_msg("Special project found in Project IS Classification!",3);
    $data['BugsName'] = $_SESSION['projisclass'];
    $_SESSION['project'] = $_SESSION['projisclass'];
  } else { 
    $data['BugsName'] = $_SESSION['project'];
  }
  
  debug_msg("Data[bugsname] is: " . $data['BugsName'],3);
  if ( $data['BugsName'] != "" ) {
 
    //Now that TPTP has re-organized itself, the standard bugzilla project layout(unlike say eclipse.platform 
    //tptp now has multiple sub-products that are all still part of the parent project so tptp.tptpsomeproduct is part of 
    //tptp) that I was relying on is fraked.  Now we have  do a little extra processing for 1 exception, so
    //let's check if this page was posted with the 'tptp' project and in that case generate a list of 'product'
    //links that call this page (again) with the correct thing to edit
    if ( in_array($_SESSION['project'],$specialproject) ) {

      debug_msg("In special projects section",2);
 
      //this check makes sure that the project classification is only updated if this is a 'special' project 1st time request
      //to the page.  All other calls to the page with sub-products, wont cause this to update and so will be found
      //with the correct wildcard classification
	  //if ( strlen(stristr($_SESSION['project'], ".")) > 1 ) {
	  //  debug_msg("In projisclass test", 4);
      //insert this project into the session. Name is contraction of 'project is classification(in bugzilla)'
  	  //  $_SESSION['projisclass'] = substr($_SESSION['project'],0,strpos($_SESSION['project'],".") );
  	  //}
  	  $_SESSION['projisclass'] = strtolower($data['BugsName']);
  	
  
      //break out the name, which is one of our keys
	  $bugzillaname = $data['BugsName'];
	  $_SESSION['bugsname'] = $bugzillaname;
	  //get the info from the bugs database
	  $bugsquery = "select * from products where name like \"" . $bugzillaname ."%\";";
	  debug_msg($bugsquery,3);
	  $result = mysql_query($bugsquery, $bdbh);
	  if( $result === FALSE){
  	    debug_msg(mysql_error(), 0);
	    debug_msg("Please contact the Webmaster about this error. Thank you.",0);
	  } 
      debug_msg("Num rows: " . mysql_num_rows($result), 2);
      if( mysql_num_rows($result) != 0 )  {
        $html = "</br><h3>You need to select a product to edit</h3></br>";
        $html .= "<form name=\"editproducts\" method=\"post\" action=\"edit_bugzilla_project.php\">\n\r";
        $html .= "<select name=\"cmonprojects\"> \n\r";
        while ($myrow = mysql_fetch_array($result)) {
          $html .= "<option>" . $myrow["name"] ."</option> \n\r";  	
        }
        $html .= "</select>";
        $html .= "<input type=\"submit\" name=\"Product\" value=\"Edit\">";
        $html .= "</form></br>";
      }
      
    } else {
  	  //break out the name, which is one of our keys
	  $bugzillaname = $data['BugsName'];
	  $_SESSION['bugsname'] = $bugzillaname;
	  //get the info from the bugs database
	  $bugsquery = "select * from products where name = \"" . $bugzillaname ."\";";
	  debug_msg($bugsquery,3);
	  $result = mysql_query($bugsquery, $bdbh);
	  if( $result == FALSE){
  	    debug_msg(mysql_error(), 0);
	    debug_msg("Please contact the Webmaster about this error. Thank you.",0);
	  } 
	
      $data = mysql_fetch_array($result);
      //error check for out of date bugsname
      if( $data === FALSE ){
       debug_msg("It looks like there was an issue in resolving your Project->Bugzilla mapping.",0); 
       debug_msg("Please contact the Webmaster about this error. Thank you.",0);
	  }
 	
	  //Store usefull data
	  $_SESSION['main_product_id'] = $data['id'];
	  debug_msg("Project ID is: " .$_SESSION['main_product_id'], 3 );
	  $project_name = $data['name'];
	  $_SESSION['project_name'] = $data['name'];
	  debug_msg("Project Name is: " . $project_name, 3);
	  $project_desc = $data['description'];
	  debug_msg("Project Desc is: " . $project_desc, 3);
	  $new_bugs = $data['isactive'];
	  debug_msg("Project new bugs is: " . $new_bugs, 3);
	  $votes_per_user = $data['votesperuser'];
	  debug_msg("Project votes per is: " . $votes_per_user, 3);
	  $max_votes_per_bug = $data['maxvotesperbug'];
	  debug_msg("Project max votes is: " . $max_votes_per_bug, 3);
	  $default_milestone = $data['defaultmilestone'];
	  debug_msg("Project default milestone is: " . $default_milestone, 3);
  	 
	  //now build the html
	  $html = "<h3>Overall bugzilla settings for " . $project_name . " </h3></br>\n\r";
  	
      //this is just to let the user know if the project will accept bugs(has not been archived)
	  if( $new_bugs == "0" )
	    $html .= "<h4>NOTE: This project has been closed to new bugs</h4>";
	
	  //build the form
  	  $html .= "<form name=\"project_details\" method=\"post\" action=\"edit_bugzilla_project.php\" >\n\r";
	  $html .= "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" >\n\r";
	  $html .= "<tr><td>Description </td><td><textarea rows=\"5\" cols=\"40\" name=\"project_description\">" . $project_desc ."</textarea></td></tr>\n\r";
	  $html .= "<tr><td>Max votes per user </td><td><input type=\"text\" name=\"votes_per_user\" value=\"" . $votes_per_user ."\"></td></tr>\n\r";
	  $html .= "<tr><td>Max votes per bug </td><td><input type=\"text\" name=\"max_votes_per_bug\" value=\"" . $max_votes_per_bug ."\"></td></tr>\n\r";
	  $html .= "<tr><td>Default milestone </td><td><select name=\"default_milestone\" >";
	  //get all available milestones and fill the select box
	  $query="select value from milestones where product_id=\"" . $_SESSION['main_product_id']."\";";
	  debug_msg($query,4);
	  $result = mysql_query($query,$bdbh);
	  if ( $result == FALSE ) {
  	    debug_msg(mysql_error(),0);
	    debug_msg("Please contact the Webmaster about this error. Thank you.",0);
	  }
	  while ( $myrow = mysql_fetch_array($result) ) {
	    if ( $default_milestone == $myrow["value"] )
	      $html .= "<option selected>" . $myrow["value"] . "\r\n";
	    else
	      $html .= "<option>" . $myrow["value"] . "\r\n";
	  }
	  $html .= "</select></td></tr>\n\r";
	  $html .= "</table>\n\r<input type=\"submit\" name=\"Submit\" value=\"Make Changes\" >\n\r";
	  $html .= "<input type=\"hidden\" name=\"bugname\" value=\"" . $bugzillaname . "\">";
	  $html .= "</form>\n\r";
 	
	  //links to the other sections: components,versions and milestones 
	  $html .="</br></br>";
	  $html .="<a href=\"edit_bugzilla_components.php\">Edit bugzilla components for " . $project_name .  "</a>\n\r</br>";
	  $html .="<a href=\"add_bugzilla_versions.php\">Add bugzilla versions for " . $project_name .  "</a>\n\r</br>";
	  $html .="<a href=\"add_bugzilla_milestones.php\">Add bugzilla milestones for " . $project_name .  "</a>\n\r</br>";
 	
	  //add a link for the 'other products'
      if( checkpost($_SESSION['projisclass'] ) == 1 ){
        $html .= "<a href=\"edit_bugzilla_project.php\">Select another product</a></br>";
      }
    }
  } else {
    $html = "<h3>Unable to determine the correct bugzilla component.  Please send a message to the webmaster indicating which project produced this error.</h3></br>\n\r";
  } //end special projects section


  //return the the main page
  $html .="<a href=\"bugz_manager.php\">Select another project</a>";
}

echo $html;


    echo "</div>";
    
    $html = ob_get_contents();
    ob_end_clean();

    $App->generatePage($theme, $Menu, null, $pageAuthor, $pageKeywords, $pageTitle, $html);
  	
?>