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>