//print_r($test_arr);
preg_match("/<{testapprove_loopstart}>(.*?)<{testapprove_loopend}>/s", $xTemplate, $matched1);
$replace2 = $matched1[1];
while (list($kk, $vv) = @each($test_arr)) {
$user_id = $test_arr[$kk]["user_id"];
$values["directreplace"]["user_id"] = $test_arr[$kk]["user_id"];
//$values["directreplace"]["username"]=$test_arr[$kk]["username"];
$username = $common->name_display($db_object, $user_id);
$values["directreplace"]["username"] = $username;
$values["directreplace"]["test_name"] = $test_arr[$kk]["test_name"];
$values["directreplace"]["test_id"] = $test_arr[$kk]["test_id"];
$values["directreplace"]["test_mode"] = "approve";
$replaced2 .= $common->direct_replace($db_object, $replace2, $values);
}
if ($replaced2 == "") {
$replaced2 = $error_msg["cEmptyrecords"];
}
$xTemplate = preg_replace("/<{testapprove_loopstart}>(.*?)<{testapprove_loopend}>/s", $replaced2, $xTemplate);
$values = array();
$xTemplate = $common->direct_replace($db_object, $xTemplate, $values);
echo $xTemplate;
}
}
}
$altobj = new Alerts_for_approval();
if ($user_id == 1) {
$altobj->display($common, $db_object, $user_id, $error_msg);
} else {
echo $error_msg["cNoPermission"];
}
include "footer.php";
class Alerts_for_approval
{
function display($common, $db_object, $user_id)
{
if ($user_id == 1) {
$devbuilder = $common->prefix_table("approved_devbuilder");
$user = $common->prefix_table("user_table");
$mysql = "select distinct({$devbuilder}.skill_id),{$devbuilder}.user_id,{$user}.username from {$devbuilder},{$user} where {$user}.user_id={$devbuilder}.user_id and {$devbuilder}.pstatus='u'";
$solution = $db_object->get_rsltset($mysql);
$path = $common->path;
$xFile = $path . "/templates/learning/alert.html";
$xTemplate = $common->return_file_content($db_object, $xFile);
preg_match("/<{alert_start}>(.*?)<{alert_end}>/s", $xTemplate, $matched);
$replace = $matched[1];
while (list($kk, $vv) = @each($solution)) {
$array["emp_name"] = $solution[$kk]["username"];
$array["user_id"] = $solution[$kk]["user_id"];
$array["skill_id"] = $solution[$kk]["skill_id"];
$replaced .= $common->direct_replace($db_object, $replace, $array);
}
$xTemplate = preg_replace("/<{alert_start}>(.*?)<{alert_end}>/s", $replaced, $xTemplate);
$xTemplate = $common->direct_replace($db_object, $xTemplate, $array);
echo $xTemplate;
}
}
}
$altobj = new Alerts_for_approval();
if ($user_id == 1) {
$altobj->display($common, $db_object, $user_id);
}
include "footer.php";
