session_start();
include('../datacon.php');
require('head.php');
require('../proclib.php');
$addEdit = $_POST['addEdit'];
$IndID = nonull($_POST['IndID']);
$IndProgID = nonull( $_POST['IndProgID2']);
$IndName = $_POST['IndName'];
$IndNote = $_POST['IndNote'];
$IndOCID = nonull( $_POST['IndOCID']);
$IndOTID = nonull( $_POST['IndOTID']);
$IndRefID = nonull( $_POST['IndRefID']);
$IndPrimRef = $_POST['IndPrimRef'];
$IndStrategy = $_POST['IndStrategy'];
$IndPeriod = $_POST['IndPeriod'];
$IndStage = $_POST['IndStage'];
$IndDiscuss = $_POST['IndDiscuss'];
$IndUserID = $_SESSION['UsrID'];
$IndEntryDate = date('Ymd H:i');
$IndEntryDate = date('Ymd');
$newOutcomeType = $_POST['newOutcomeType'];
// echo "Action = $addEdit
\n";
$IndUserID = $_SESSION['gSessionOK'];
if (!get_magic_quotes_gpc()){
$IndName = addslashes( $IndName);
$IndNote = addslashes( $IndNote);
}
if ($addEdit == 'delete'){
echo "
Delete Item
";
$sql = "DELETE FROM outcomes.Indicators WHERE IndID = $IndID";
}
// add new program-specific outcome (outcome type) if entered in text box:
if ($addEdit == 'add' or $addEdit == 'edit'){
if ( strlen($newOutcomeType)>1 ) {
$sql = "SELECT OTName, OTID FROM outcomes.OutcomeTypes where UPPER(OTName) = UPPER('$newOutcomeType') and OTProgID = $IndProgID";
$x = runSql($sql);
if (mysql_num_rows($x) == 0) {
$sql2 = "INSERT INTO outcomes.OutcomeTypes ( OTName, OTProgID) VALUES ('". $newOutcomeType. "',". $IndProgID.")";
$x = runSql($sql2);
$sql = "SELECT OTID FROM outcomes.OutcomeTypes where UPPER(OTName) = UPPER('$newOutcomeType')";
$x = runSql($sql);
$row = mysql_fetch_assoc($x);
$IndOTID = $row['OTID'];
} else {
echo "Duplicate entry found. New program-specific outcome NOT added.";
$row = mysql_fetch_assoc($x);
$IndOTID = $row['OTID'];
}
}
}
if ($addEdit == 'add'){
echo "
Add Item
";
$UsrID = $_SESSION['UsrID'];
$sql = "INSERT INTO outcomes.Indicators (IndProgID, IndName, indNote, IndOCID, IndOTID, IndRefID, IndPrimRef, IndStrategy, IndPeriod, IndStage, IndUserID, IndEntryDate, IndDiscuss) VALUES
($IndProgID, '$IndName', '$IndNote', $IndOCID, $IndOTID, $IndRefID, '$IndPrimRef', '$IndStrategy', '$IndPeriod', '$IndStage', '$UsrID', '$IndEntryDate', '$IndDiscuss')";
}
if ($addEdit == 'edit') {
echo "Edit Item
";
//require('proclibUpdate.php');
$flist = 'IndProgID, IndName, indNote, IndOCID, IndRefID, IndPrimRef, IndStrategy, IndPeriod, IndStage, IndUserID, IndEntryDate';
// $sql = getSQL( 'outcomes.Indicators', $flist);
$sql = "UPDATE outcomes.Indicators SET ".
" IndName = '$IndName', IndNote = '$IndNote', ".
" IndOCID = $IndOCID, IndRefID = $IndRefID, IndPrimRef = '$IndPrimRef', ".
" IndStrategy = '$IndStrategy', ".
" IndOTID = $IndOTID, IndDiscuss = '$IndDiscuss', IndProgID = $IndProgID, ".
" IndPeriod = '$IndPeriod', IndStage = '$IndStage', IndUserID = '$IndUserID' ".
" WHERE IndID = $IndID";
}
echo "SQL: " . $sql . "";
$dbResult = runSql($sql);
echo "
";
echo "Date: $IndEntryDate";
require('foot.php');
?>