el codigo es el siguiente:
edit_rule.php
<?php
define('AT_INCLUDE_PATH', '../../include/');
require (AT_INCLUDE_PATH.'vitals.inc.php');
authenticate(AT_PRIV_HELLO_WORLD);
require (AT_INCLUDE_PATH.'header.inc.php');
//echo "<pre>"; print_r(get_defined_constants());
$dir = pathinfo(__FILE__);
define('AT_THIS_MODULE_PATH', $dir['dirname'] . DIRECTORY_SEPARATOR);
//define('KDEBUG', true);
require_once(AT_THIS_MODULE_PATH.'lib-funciones.inc.php');
require_once(AT_THIS_MODULE_PATH.'k/cake.php');
require_once(AT_THIS_MODULE_PATH.'lib-yo.inc.php');
$conditions = $sug = array();
$id = $_REQUEST["rule_id"];
$boton = $_REQUEST["boton"]; //echo $boton."<br>";
if ($boton == "Borrar"){
$SQL_R = "DELETE FROM ".TABLE_PREFIX."rules WHERE id='".$id."'";
//echo $SQL;
mysql_query($SQL_R);
echo mysql_error();
$SQL_C = "DELETE FROM ".TABLE_PREFIX."rules_conditions WHERE rule_id='".$id."'";
//echo $SQL;
mysql_query($SQL_C);
echo mysql_error();
$SQL_S = "DELETE FROM ".TABLE_PREFIX."rules_suggestions WHERE rule_id='".$id."'";
//echo $SQL;
mysql_query($SQL_S);
echo mysql_error();
echo "La Regla ha sido eliminada.";
} else {
if (isset($_POST['add_rule'])) {
$id = $Rule->save($_POST['data']);
//pr($_POST['data']);
if ($id === false) {
echo "error";
} else {
$_SESSION['rule_id'] = $id;
}
}
else if (isset($_POST['edit_rule']))
{
if (isset($_POST['config'])) {
$config = $_POST['config'];
}
$item = $_POST['item'];
if (isset($_POST['conditions'])) {
$conditions = $_POST['conditions'];
}
if (isset($_POST['sug'])) {
$sug = $_POST['sug'];
}
}
else if (isset($_POST['_edit_rule_']))
{
echo "se intenta editar desde el listado";
$_SESSION['rule_id'] = $_POST['rule_id'];
}
$hidden = '';
if (isset($_POST['borrar']))
{
//print_r($_POST);
$bor = array_keys($_POST['borrar']);
$SQL = "DELETE FROM ".TABLE_PREFIX."rules_conditions WHERE id='".$bor[0]."'";
//echo $SQL;
mysql_query($SQL);
echo mysql_error();
}
if (isset($_POST['borrar_accion']))
{
//print_r($_POST);
$bor = array_keys($_POST['borrar_accion']);
$SQL = "DELETE FROM ".TABLE_PREFIX."rules_actions WHERE id='".$bor[0]."'";
//echo $SQL;
mysql_query($SQL);
echo mysql_error();
}
if (isset($_POST['borrar_regla'])) {
$bor = array_keys($_POST['borrar_regla']);
$SQL = "DELETE FROM ".TABLE_PREFIX."reglas WHERE id='".$bor[0]."'";
mysql_query($SQL);
echo mysql_error();
}
if (isset($_POST['_agregar_condicion_'])) {
$conditions[] = array();
}
if (isset($_POST['_agregar_sugerencia_'])) {
$sug[] = array();
}
if (isset($_SESSION['id'])) {
$Rule = new Rule();
$rule = $Rule->read($_SESSION['id']);
//pr($rule);
$config['rule_id'] = $_SESSION['id'];
if (!isset($_POST['config'])) {
$sql = "SELECT * FROM ".TABLE_PREFIX."rules_conditions WHERE rule_id='{$config['rule_id']}'";
$r = query($sql);
while ($row = mysql_fetch_assoc($r)) {
$conditions[] = $row;
}
$sql = "SELECT * FROM ".TABLE_PREFIX."rules_suggestions WHERE rule_id='{$config['rule_id']}'";
$r = query($sql);
while ($row = mysql_fetch_assoc($r)) {
$sug[] = $row;
}
}
}
if (isset($_POST['actualizar']))
{
//pr($_POST);
//pr($conditions);
//die();
if (is_array($conditions))
{
$SQL = "DELETE FROM ".TABLE_PREFIX."rules_conditions WHERE rule_id='{$_SESSION['rule_id']}'";
query($SQL);
$items = array_keys($conditions);
foreach ($conditions as $key => $condition)
{
// Si el contexto es 0 y el item_id no, es que
// falta completar.
if ($condition['item_id'] == 0) {
unset($conditions[$key]);
}
else if ($condition['context_id'] == 0 || $condition['logic_value'] == 0)
{
$error = "Faltan completar campos";
//pr($condition);
//echo $error;
}
else {
$Condition = new Condition();
$tmp['condition'] = $condition;
$tmp['condition']['course_id'] = $_SESSION['course_id'];
$tmp['condition']['member_id'] = $_SESSION['member_id'];
$tmp['condition']['rule_id'] = $_SESSION['rule_id'];
//pr($tmp);
$Condition->debug = true;
//echo "SAVE";
$Condition->save($tmp);
}
}
}
$sql = "DELETE FROM ".TABLE_PREFIX."rules_suggestions WHERE rule_id='".$_SESSION['rule_id']."'";
query($sql);
foreach ($sug as $key => $sugerencia)
{
if ($sugerencia['id_accion'] == 0) {
unset($sug[$key]);
}
else if ($sugerencia['id_recurso'] == 0)
{
echo "<h3>sugerencia faltan datos</h3>";
}
else {
$Suggestion = new Suggestion();
$tmp['suggestion'] = $sugerencia;
$tmp['suggestion']['rule_id'] = $_SESSION['rule_id'];
//pr($tmp);
//$Suggestion->debug = true;
//echo "SAVE suggestion ";
$Suggestion->save($tmp);
}
}
$mensaje = "Se creo/edito la regla: '".$config['rule_id']."' correctamente. <a href='mods/tutoria/index_instructor.php'>Ver listado</a>";
}
}
?>
<form method='post'>
<input type="hidden" name="config[conditions]" value="<? echo $config['conditions']; ?>">
<input type="hidden" name="config[suggestions]" value="<? echo $config['suggestions']; ?>">
<input type="hidden" name="config[rule_id]" value="<? echo $config['rule_id']; ?>">
<input type="hidden" name="data[condition][rule_id]" value="<? echo $_SESSION['rule_id']; ?>">
<input type="hidden" name="data[condition][member_id]" value="<? echo $_SESSION['member_id']; ?>">
<?php
if (isset($error))
{
echo "<h3><font color='red'>$error</font></h3>";
} else if (isset($mensaje)) {
echo "<h3><font color='green'>$mensaje</font></h3>";
}
?>
<table border='1'>