/**
* Update the specified resource in storage.
*
* @param PageRequest|Request $request
* @param Project $project
* @param Module $module
* @param Page $page
* @return \Illuminate\Http\Response
*/
public function update(PageRequest $request, Project $project, Module $module, Page $page)
{
if (isset($_POST['module_id'])) {
$module_id = $_POST['module_id'];
$pages = Page::where('module_id', '=', $module_id)->get();
foreach ($pages as $page) {
$page->update($request->all());
$page->save();
}
return redirect()->route('project.module.show', [$project, $module]);
}
if (isset($_POST['module_name'])) {
$pages = $_POST;
$module = Module::where('project_id', '=', $project->id)->where('name', '=', $_POST['module_name'])->first();
foreach ($pages as $val) {
if (is_numeric($val)) {
$p = Page::where('id', '=', $val)->first();
$p->module_id = $module->id;
$p->save();
}
}
}
$page->update($request->all());
$page->save();
return redirect()->route('project.module.show', [$project, $module]);
}
function extractModule(string $summary)
{
if (preg_match('/(?<module>[A-Z]+\\d{1,2})/', $summary, $matches) !== 1) {
return null;
}
return \App\Module::where('naam', $matches['module'])->first();
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index()
{
//
$actif = 'gescom';
$tri = "alpha";
$module = Module::where('etat_module', 1)->orderBy('nom_module', 'asc')->get();
return view('gescom.liste-module', compact('actif', 'module', 'tri'));
}
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
//
$pages = Page::where('module_id', '=', $_GET)->get();
$existing_pages_count = Page::where('module_id', '=', $_GET)->count();
$projected_pages = Module::where('id', '=', $_GET)->pluck('projected_total_pages');
$pages_count = $projected_pages - $existing_pages_count;
return view('pages.index', compact('pages', 'pages_count'));
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//truncate the activities table so that the auto incrementing 'id' field starts counting from 1 again
DB::table('activities')->truncate();
//Read in a csv file containing data on some of the activities in the COMSC department
$activtiesCSVFile = new CsvFile(__DIR__ . '/_data/Activities.csv');
//Generate a record using data from each line of the CSV file where each row is in the format:
//TODO:put the format here
//'id' value for each module in the 'modules' table specified in the CSV file, as the module seeder
//(and all other seeders including this one) will only be run a single time when it has been put into production
foreach ($activtiesCSVFile as $currentRow) {
//get an object representing the first module whose module code matches the one in the row
//of the CSV file that is currently being processed. The first method returns only the first match
//as the modules in the database should have unique module codes anyway.
$module = Module::where('module_code', '=', (string) $currentRow[2])->first();
//obtain the 'ID' (primary key) of the module that matches the above 'where' query
$moduleID = $module->id;
$moduleActivity = Activity::create(['title' => trim($currentRow[0]), 'role_type' => trim($currentRow[1]), 'module_id' => $module->id, 'quant_ppl_needed' => $currentRow[4], 'closing_date_for_applications' => $currentRow[5], 'knowledge_required' => $currentRow[6]]);
}
}
/**
* Show the form for editing the specified resource.
*
* @param int $id
* @return Response
*/
public function editer($id)
{
//
$actif = 'gescom';
$societes[''] = '';
$societes[0] = 'Tous les contacts';
$contacts[''] = '';
$gescom = Gescom::first();
$societe = Societe::select('id', 'nom_clt')->where('etat', 1)->get();
$contact = Contact::select('id', 'nom_contact', 'prenoms_contact')->where('etat', 1)->get();
$modules[''] = '';
$module = Module::where('etat_module', 1)->orderBy('nom_module', 'asc')->get();
// Remplissage du tableau des modules
foreach ($module as $key => $value) {
foreach ($value->produits as $pkey => $pvalue) {
$modules[$value->id . '.' . $pvalue->id] = $value->nom_module . ' (' . $pvalue->nom_produit . ')';
}
}
// Remplissage du tableau des sociétés
foreach ($societe as $key => $value) {
$societes[$value->id] = $value->nom_clt;
}
// Remplissage du tableau des contacts
foreach ($contact as $key => $value) {
$contacts[$value->id] = $value->nom_contact . ' ' . $value->prenoms_contact;
}
$profil = Devis::with('gescom', 'societedata')->findOrfail($id);
foreach ($profil->modules as $key => $value) {
$produit_id = $value->pivot->produit_id;
}
$produit = Produit::findOrFail($produit_id);
$produits = $produit->modules;
$actif = 'gescom';
return view('gescom.edit-devis', compact('actif', 'profil', 'produits', 'contacts', 'gescom', 'societes', 'modules'));
}
public static function geticonbymodule($module)
{
$icon = Module::where('module', $module)->value('icon');
return $icon;
}
public function DeleteModuleActSession($user_id, $module_id, $act_id, $sess_id)
{
if (UserMod::where('id', $user_id)->where('role', '=', 'Lecturer')->exists() and Module::where('id', $module_id)->where('module_leader', $user_id)->exists() and Activity::where('id', $act_id)->where('module_id', $module_id)->exists() and ActSession::where('id', $sess_id)->where('activity_id', $act_id)->exists()) {
$Session = ActSession::where('id', $sess_id)->where('activity_id', $act_id);
$Session->delete();
Session::flash('success', "Session was successfully deleted");
return redirect('Lecturer/' . $user_id . '/Modules/mod' . $module_id . '/Act' . $act_id);
} else {
Session::flash('failed', "Something went wrong!, please try again or contact Technical Support");
return back()->withInput();
}
}
public function ReqAct($user_id, $module_id)
{
if (UserMod::where('id', $user_id)->where('role', '=', 'PHD Student')->exists() and Module::where('id', $module_id)->exists()) {
if (AddRequest::where('user_id', '=', Input::get('user_id'))->where('activity_id', '=', Input::get('activity_id'))->exists()) {
Session::flash('ErrMessage', "You already have requested this activity before");
return back()->withInput();
} else {
$supervisor_id = Input::get('supervisor');
$supervisor = UserMod::where('id', $supervisor_id)->where('role', '=', 'Lecturer')->first();
$activity_id = Input::get('activity_id');
$activity = Activity::where('id', $activity_id)->with('module')->first();
$messageSubject = '[No reply] Application Requested';
$user = UserMod::where('id', $user_id)->where('role', '=', 'PHD Student')->first();
$student_name = $user->name;
$student_email = $user->email;
$activity_title = $activity->title;
$activity_module = $activity->module->module_code . ' ' . $activity->module->module_name;
AddRequest::create(array('activity_id' => Input::get('activity_id'), 'user_id' => Input::get('user_id'), 'status' => Input::get('status')));
$supervisor_name = $supervisor->title . '. ' . $supervisor->name;
$supervisor_email = $supervisor->email;
// Sending Email to PhD Student when requesting job
$data = array('name' => $student_name, 'Recemail' => $student_email, 'activity_title' => $activity_title, 'activity_module' => $activity_module);
Mail::send('PhdApplicationRequest', $data, function ($message) use($student_email, $student_name, $messageSubject) {
$message->to($student_email, $student_name)->subject($messageSubject);
});
// Sending Email to Supervisor for confirmation
$sup_mail = array('name' => $supervisor_name, 'Recemail' => $supervisor_email, 'student_name' => $student_name, 'activity_title' => $activity_title, 'activity_module' => $activity_module);
Mail::send('LecturerApplicationRequest', $sup_mail, function ($message) use($supervisor_email, $supervisor_email, $messageSubject) {
$message->to($supervisor_email, $supervisor_email)->subject($messageSubject);
});
Session::flash('message', "Request was successfully sent!, an email was sent to you showing your application's details");
return back()->withInput();
}
} else {
Session::flash('failed', "Something went wrong, please try again!");
return back()->withInput();
}
}
public function disable($id)
{
$module = Module::where('id', $id)->first();
$module->disable();
return View::make('admin.modules');
}
public static function modulesProf($id)
{
$liste = Module::where('enseignant_id', '=', $id)->get();
return $liste;
}
public function deleteModule($user_id, $id)
{
if (UserMod::where('id', $user_id)->where('role', '=', 'Administrator')->exists() and Module::where('id', $id)->exists()) {
$module = DB::table('modules')->where('id', $id);
$module->delete();
Session::flash('module_deleted', "Module was successfully deleted");
return redirect('Admin/' . $user_id . '/Modules');
} else {
Session::flash('failed', "Something went wrong, please try again!");
return back()->withInput();
}
}
function get_modules()
{
$module_list = Module::where('status', 1)->orderBy('sort', 'asc')->get();
return $module_list;
}
