function dbUtil()
{
reset_db_result();
$args_arr = func_get_args();
$type = $args_arr[0];
try {
$mongo = new MongoClient('mongodb://nb403:27127/admin:admin');
$db = $mongo->svnCodeComment;
if ($type == GetProductList) {
return getProductList($db);
} elseif ($type == GetVersionList) {
$prodName = $args_arr[1];
return getVersionList($db, $prodName);
} elseif ($type == CodeSearch) {
list($prodName, $version, $keyword) = array_slice($args_arr, 1);
return codeSearch($db, $prodName, $version, $keyword);
} elseif ($type == CodeSearchDetail) {
list($prodName, $id) = array_slice($args_arr, 1);
return codeSearchDetail($db, $prodName, $id);
} elseif ($type == AddCodeInfo) {
list($codeSvnPathWithVersion, $version, $prodName, $creator, $diskPath) = array_slice($args_arr, 1);
return addCodeInfo($db, $codeSvnPathWithVersion, $version, $prodName, $creator, $diskPath);
} elseif ($type == GetCommentorList) {
$prodName = $args_arr[1];
return getCommentorList($db, $prodName);
} elseif ($type == GetCreator) {
list($prodName, $version) = array_slice($args_arr, 1);
return getCreator($db, $prodName, $version);
} elseif ($type == GetCodeDiskPath) {
list($prodName, $version) = array_slice($args_arr, 1);
return getCodeDiskPath($db, $prodName, $version);
} elseif ($type == GetCodeInfo) {
list($prodName, $version) = array_slice($args_arr, 1);
return getCodeInfo($db, $prodName, $version);
} elseif ($type == GetProdNameMap) {
return getProdNameMap($db);
} elseif ($type == SetProdNameMap) {
list($prodName, $tableName) = array_slice($args_arr, 1);
return setProdNameMap($db, $prodName, $tableName);
}
} catch (MongoConnectionException $e) {
set_db_result("1", $e->getMessage());
}
}
$contents['max_participants'] = "Non renseigné";
}
$contents['age_min'] = $event['age_min'];
$contents['age_max'] = $event['age_max'];
$contents['description'] = $event['description'];
if ($event['site']) {
$contents['site'] = $event['site'];
} else {
$contents['site'] = "Non renseigné";
}
if ($event['site']) {
$contents['site'] = "<li><a href=\"" . $contents['site'] . "\">" . $contents['site'] . " </a></li>";
} else {
$contents['site'] = "<li>Non renseigné</li>";
}
$creator = getCreator($_GET['id']);
if (!empty($creator)) {
$contents['creator'] = $creator;
$creator_photo = getMembersPicture($creator[0][1]);
}
if (isset($creator_photo['lien'])) {
$contents['creator']['picture'] = PHOTO_PROFIL . $creator_photo['lien'];
} else {
$contents['creator']['picture'] = IMAGES . "photo_profil_defaut.jpg";
}
if ($event['organisateur']) {
$contents['info_organisateur'] = $event['organisateur'];
} else {
$contents['info_organisateur'] = $contents['creator'][0]['pseudo'];
}
if ($event['organisateur_contact']) {
$F->setCellValue('G' . $Line, $r['registration_no']);
$F->setCellValue('H' . $Line, $r['roll_no']);
$F->setCellValue('I' . $Line, $r['fathers_name']);
$F->setCellValue('J' . $Line, $r['mothers_name']);
$F->setCellValue('K' . $Line, $r['dob']);
$F->setCellValue('L' . $Line, $r['sex']);
$F->setCellValue('M' . $Line, $r['community']);
$F->setCellValue('N' . $Line, $r['region']);
$F->setCellValue('O' . $Line, getFeeCategory($r['fee_category']));
$F->setCellValue('P' . $Line, $r['mb_no']);
$F->setCellValue('Q' . $Line, $r['email_id']);
$F->setCellValue('R' . $Line, getSemester($r['fee_paid_upto_semester_code']));
$F->setCellValue('S' . $Line, $reside);
$F->setCellValue('T' . $Line, $r['student_id']);
$F->setCellValue('U' . $Line, $r['password']);
$F->setCellValue('V' . $Line, getCreator($r['created_by_id']));
$Line = $Line + 1;
}
header('Content-Type: application/vnd.ms-excel');
$resolve = getDepartmentCenter($deptidcenterid, 'dept');
$resolvecourse = getDepartmentCenterCourse($courseid, 'dept');
$filename = 'DU Student Data- ' . $resolve . "-" . $resolvecourse . "-" . time() . ".xls";
header("Content-Disposition: attachment;filename=" . $filename);
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter->save(str_replace('.php', '.xls', __FILE__));
$objWriter->save('php://output');
exit;
function getDepartmentCenter($dccode, $btype)
{
if ($btype == 'center') {
exit;
}
// Fonction qui check s'il a le droit de modifier.
if (connected() && (checkOrganiser($_SESSION['id'], $_GET['id']) or $_SESSION['niveau'] == 2 or $_SESSION['niveau'] == 3)) {
} else {
if (!connected()) {
alert("error", "Vous devez être connecté !");
header("Location: " . getLink(["membres", "connexion"]));
exit;
} else {
alert("error", "Vous n'avez pas le droit de modifier cet évènement!");
header("Location: " . getLink(["accueil"]));
exit;
}
}
$contents['modos'] = array_merge(getCreator($_GET["id"]), getCreators($_GET['id']));
$contents['errorMessage'] = '';
if (!empty($_POST['pseudo'])) {
if (!checkUsed($_POST['pseudo'], NULL, False)) {
///si le pseudo n'existe pas///
$contents['errorMessage'] .= 'Le pseudo renseigné n\'existe pas ! ';
}
$orga_id = getUserAuth($_POST['pseudo'], False)['id'];
if (checkOrganiser($orga_id, $_GET['id'])) {
$contents['errorMessage'] .= 'Le pseudo renseigné est déja organisateur de cet évènement ! ';
}
if (getUserDetails($orga_id)['niveau'] <= 0) {
$contents['errorMessage'] .= 'Le pseudo renseigné n\'est pas activé ! ';
}
if (empty($contents['errorMessage'])) {
if (insertModo($_GET['id'], $orga_id)) {
<?php
require_once 'connect.php';
$post = file_get_contents("php://input");
$postData = json_decode($post, true);
$data['result'] = false;
$data['postData'] = $postData;
if (isset($postData['code']) && !empty($postData['code']) && isset($postData['userCode']) && !empty($postData['userCode'])) {
$code = $postData['code'];
$query = "SELECT * FROM event WHERE code='" . mysqli_real_escape_string($connection, $code) . "'";
$result = mysqli_query($connection, $query);
if ($result && mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
$currentUser = getUser($postData['userCode']);
$creator = getCreator($row['id']);
if (count($currentUser) > 0) {
$chosenDates = getDatesByUser($currentUser['id']);
$data['data'][] = array('id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'location' => $row['location'], 'code' => $row['code'], 'creator_name' => $creator['name'], 'creator_email' => $creator['email'], 'creation_date' => translateMonth(date('d F Y', strtotime($row['creation_date']))), 'creation_time' => date('H:i', strtotime($row['creation_date'])), 'dates' => $chosenDates, 'isCreator' => $currentUser['is_creator'], 'users' => getAllUsers($row['id']));
}
}
$data['result'] = true;
}
}
function getUser($userCode)
{
global $connection;
$query = "SELECT * FROM event_user WHERE code='" . mysqli_real_escape_string($connection, $userCode) . "'";
$result = mysqli_query($connection, $query);
$user = array();
if ($result && mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_array($result)) {
///////////////////////////////////////////////////////////////////////////////////////////////////////////
$sqlReg = "SELECT b.build_identify, b.year_of_const, b.type_const, b.total_square, b.numb_on_ground, \n\t\t\t\t\tb.numb_half_under, b.numb_under_floors, b.numb_floors,b.all_objects, a.asoc_numb, u.id, a.id \n\t\t\t FROM buildings b, asoc a, users u \n\t\t\t WHERE a.building_id = b.id AND a.id = '{$a_id}' and a.invalid='0' and b.invalid='0'";
$resReg = mysql_query($sqlReg) or die(mysql_error());
while ($rowReg = mysql_fetch_assoc($resReg)) {
$id = $rowReg['id'];
$name = $rowReg['asoc_numb'];
$numb = $rowReg['build_identify'];
$build_year = $rowReg['year_of_const'];
$type_c = getConstrType($rowReg['type_const']);
$floors = $rowReg['numb_floors'];
$on_ground = $rowReg['numb_on_ground'];
$half_under = $rowReg['numb_half_under'];
$under = $rowReg['numb_under_floors'];
$total_square = $rowReg['total_square'];
$all_objects = $rowReg['all_objects'];
$user = getCreator($rowReg['id']);
}
// echo $numb;
// echo $build_year;
// echo $type_c;
// echo $total_square;
// echo $on_ground;
// echo $half_under;
// echo $under;
// echo $floors;
// echo $name;
// echo $user;
///////////////////////////////////////////////////////////////////////////////////////////////////////////
?>
<style type="text/css">
@media screen{div.bb{visibility: visible;}}
// Fonction qui check s'il a le droit de modifier.
if (connected() && (checkOrganiser($_SESSION['id'], $_GET['id']) or $_SESSION['niveau'] == 2 or $_SESSION['niveau'] == 3)) {
} else {
if (!connected()) {
alert("error", "Vous devez être connecté !");
header("Location: " . getLink(["membres", "connexion"]));
exit;
} else {
alert("error", "Vous n'avez pas le droit de modifier cet évènement!");
header("Location: " . getLink(["accueil"]));
exit;
}
}
$contents['errorMessage'] = '';
$contents['modos'] = getCreators($_GET['id']);
$contents['creator'] = getCreator($_GET['id']);
if (!empty($_POST)) {
if (!checkUsed($_POST['pseudo'], NULL, False)) {
///si le pseudo n'existe pas///
$contents['errorMessage'] .= 'Le pseudo renseigné n\'existe pas ! ';
}
$orga_id = getUserAuth($_POST['pseudo'], False)['id'];
if (!checkOrganiser($orga_id, $_GET['id'])) {
$contents['errorMessage'] .= 'Le pseudo renseigné n\'est pas organisateur de cet évènement ! ';
}
if (getUserDetails($orga_id)['niveau'] <= 0) {
$contents['errorMessage'] .= 'Le pseudo renseigné n\'est pas activé ! ';
}
if (strtolower($contents['creator'][0][0]) == strtolower($_POST['pseudo'])) {
$contents['errorMessage'] .= 'Vous ne pouvez pas supprimer le créateur !';
}
" class="label label-primary" style="font-size:19px">
<i class="fa fa-user"></i> <?php
echo $student_name;
?>
»
<small style="font-size:12px; font-weight:bold; color:white"><?php
echo getDepartmentCenter($dept_center_code, $belongs_to_center_dept);
?>
» <?php
echo getDepartmentCenterCourse($dept_center_course_code, $belongs_to_center_dept);
?>
</small></h3>
<br/><br/>
<small style="font-weight:bold; font-size:12px" class="label label-default pull-right"><i class="fa fa-info"></i> Student Profile created by <?php
echo getCreator($created_by_id);
?>
</small>
</div>
<br/>
<legend><i class="fa fa-book"></i> Academic Information » <a href="#editacademics"
title="Edit Academic information" data-toggle="modal" class="btn btn-primary btn-sm pull-right">
<i class="fa fa-pencil"></i> Edit Academics</a>
</legend>
<div id="editacademics" class="modal fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-dialog" style='width:750px; height:450px;'>
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
