mods/_standard/social/edit_profile.php

   1 <?php
   2 /****************************************************************/
   3 /* ATutor                                                                                                               */
   4 /****************************************************************/
   5 /* Copyright (c) 2002-2009                                                                              */
   6 /* Inclusive Design Institute                                   */
   7 /* http://atutor.ca                                                                                             */
   8 /*                                                              */
   9 /* This program is free software. You can redistribute it and/or*/
  10 /* modify it under the terms of the GNU General Public License  */
  11 /* as published by the Free Software Foundation.                                */
  12 /****************************************************************/
  13 // $Id$
  14 $_user_location = 'public';
  15
  16 define('AT_INCLUDE_PATH', '../../../include/');
  17 require(AT_INCLUDE_PATH.'vitals.inc.php');
  18 require(AT_SOCIAL_INCLUDE.'friends.inc.php');
  19 $_custom_css = $_base_path . AT_SOCIAL_BASENAME . 'module.css'; // use a custom stylesheet
  20
  21 if (!$_SESSION['valid_user']) {
  22         require(AT_INCLUDE_PATH.'header.inc.php');
  23         $info = array('INVALID_USER', $_SESSION['course_id']);
  24         $msg->printInfos($info);
  25         require(AT_INCLUDE_PATH.'footer.inc.php');
  26         exit;
  27 }
  28
  29 // Initiates member
  30 $member = new Member($_SESSION['member_id']);
  31
  32 // Handles social profile
  33 if ($_POST['social_profile']){
  34         //update database from here
  35         header('Location: sprofile.php');
  36 }
  37
  38
  39 // Handles Saving
  40 if (isset($_POST['submit'])){
  41         //where was this request sent from
  42         if (isset($_POST['edit'])){
  43                         $id              = intval($_POST['id']);
  44                 if ($_POST['edit']=='position'){
  45                         $company         = $_POST['company'];
  46                         $title           = $_POST['title'];
  47                         $from            = $_POST['from'];
  48                         $to                      = $_POST['to'];
  49                         $description = $_POST['description'];
  50                         $member->updatePosition($id, $company, $title, $from, $to, $description);
  51                 } elseif ($_POST['edit']=='education'){
  52                         $university      = $_POST['university'];
  53                         $country         = $_POST['country'];
  54                         $province        = $_POST['province'];
  55                         $degree          = $_POST['degree'];
  56                         $field           = $_POST['field'];
  57                         $from            = $_POST['from'];
  58                         $to                     = $_POST['to'];
  59                         $description = $_POST['description'];
  60                         $member->updateEducation($id, $university, $from, $to, $country, $province, $degree, $field, $description);
  61                 } elseif ($_POST['edit']=='websites'){
  62                         $url            = $_POST['url'];
  63                         $site_name      = $_POST['site_name'];
  64                         $member->updateWebsite($id, $url, $site_name);
  65                 } elseif ($_POST['edit']=='interests' || $_POST['edit']=='associations' || $_POST['edit']=='awards' || $_POST['edit']=='expertise'
  66                                         || $_POST['edit']=='others'){
  67                         $interests              = isset($_POST['interests'])&&$_POST['interests']==''? _AT('na'): $_POST['interests'];
  68                         $associations   = isset($_POST['associations'])&&$_POST['associations']==''? _AT('na'): $_POST['associations'];
  69                         $awards                 = isset($_POST['awards'])&&$_POST['awards']==''? _AT('na'): $addslashes($_POST['awards']);
  70                         $expertise              = isset($_POST['expertise'])&&$_POST['expertise']==''? _AT('na'): $_POST['expertise'];
  71                         $others                 = isset($_POST['others'])&&$_POST['others']==''? _AT('na'): $_POST['others'];
  72                         $member->updateAdditionalInformation($interests, $associations, $awards, $expertise, $others);
  73                 } elseif ($_POST['edit']=='representation'){
  74                         $rep_name               = $_POST['rep_name'];
  75                         $rep_title              = $_POST['rep_title'];
  76                         $rep_phone              = $_POST['rep_phone'];
  77                         $rep_email              = $_POST['rep_email'];
  78                         $rep_address            = $_POST['rep_address'];
  79                         $member->updateRepresentation($id, $rep_name, $rep_title, $rep_phone, $rep_email, $rep_address);
  80                 } elseif ($_POST['edit']=='contact'){
  81                         $rep_name               = $_POST['con_name'];
  82                         $rep_phone              = $_POST['con_phone'];
  83                         $rep_email              = $_POST['con_email'];
  84                         $rep_address            = $_POST['con_address'];
  85                         $member->updateContact($id, $con_name, $con_phone, $con_email, $con_address);
  86                 } elseif ($_POST['edit']=='personal'){
  87                         $per_weight             = $_POST['per_weight'];
  88                         $per_height             = $_POST['per_height'];
  89                         $per_hair               = $_POST['per_hair'];
  90                         $per_eyes               = $_POST['per_eyes'];
  91                         $per_ethnicity          = $_POST['per_ethnicity'];
  92                         $per_languages          = $_POST['per_languages'];
  93                         $per_disabilities       = $_POST['per_disabilities'];
  94                         $member->updatePersonal($per_weight, $per_height, $per_hair, $per_eyes, $per_ethnicity, $per_languages, $per_disabilities);
  95                 }
  96         }
  97         elseif (isset($_POST['add'])) {
  98                 if ($_POST['add']=='position'){
  99                         $company         = $_POST['company'];
 100                         $title           = $_POST['title'];
 101                         $from            = $_POST['from'];
 102                         $to                      = $_POST['to'];
 103                         $description = $_POST['description'];
 104                         $member->addPosition($company, $title, $from, $to, $description);
 105                 } elseif ($_POST['add']=='education'){
 106                         $university      = $_POST['university'];
 107                         $country         = $_POST['country'];
 108                         $province        = $_POST['province'];
 109                         $degree          = $_POST['degree'];
 110                         $field           = $_POST['field'];
 111                         $from            = $_POST['from'];
 112                         $to                      = $_POST['to'];
 113                         $description = $_POST['description'];
 114                         $member->addEducation($university, $from, $to, $country, $province, $degree, $field, $description);
 115                 } elseif ($_POST['add']=='websites'){
 116                         $url            = $_POST['url'];
 117                         $site_name      = $_POST['site_name'];
 118                         $member->addWebsite($url, $site_name);
 119                 } elseif ($_POST['add']=='interests'){
 120                         $interests      = $_POST['interests'];
 121                         $member->addInterests($interests);
 122                 } elseif ($_POST['add']=='associations'){
 123                         $associations = $_POST['associations'];
 124                         $member->addAssociations($associations);
 125                 } elseif ($_POST['add']=='awards'){
 126                         $awards         = $_POST['awards'];
 127                         $member->addAwards($awards);
 128                 } elseif ($_POST['add']=='representation'){
 129                         $rep_name               = $_POST['rep_name'];
 130                         $rep_title              = $_POST['rep_title'];
 131                         $rep_phone              = $_POST['rep_phone'];
 132                         $rep_email              = $_POST['rep_email'];
 133                         $rep_address            = $_POST['rep_address'];
 134                         $member->addRepresentation( $rep_name, $rep_title, $rep_phone, $rep_email, $rep_address);
 135                 } elseif ($_POST['add']=='contact'){
 136                         $con_name               = $_POST['con_name'];
 137                         $con_phone              = $_POST['con_phone'];
 138                         $con_email              = $_POST['con_email'];
 139                         $con_address            = $_POST['con_address'];
 140                         $member->addContact($con_name, $con_phone, $con_email, $con_address);
 141                 } elseif ($_POST['add']=='personal'){
 142                         $per_weight             = $_POST['per_weight'];
 143                         $per_height             = $_POST['per_height'];
 144                         $per_hair               = $_POST['per_hair'];
 145                         $per_eyes               = $_POST['per_eyes'];
 146                         $per_ethnicity          = $_POST['per_ethnicity'];
 147                         $per_languages          = $_POST['per_languages'];
 148                         $per_disabilities               = $_POST['per_disabilities'];
 149                         $member->addPersonal($per_weight, $per_height, $per_hair, $per_eyes, $per_ethnicity, $per_languages, $per_disabilities);
 150                 }
 151         }
 152 }
 153
 154
 155 // Handles Adding
 156 if (isset($_GET['add'])){
 157         //header starts here.
 158         include(AT_INCLUDE_PATH.'header.inc.php');
 159         if ($_GET['add']=='position'){
 160                 $savant->display('social/edit_profile/edit_position.tmpl.php');
 161         } elseif ($_GET['add']=='education'){
 162                 $savant->display('social/edit_profile/edit_education.tmpl.php');
 163         } elseif ($_GET['add']=='websites'){
 164                 $savant->display('social/edit_profile/edit_websites.tmpl.php');
 165         } elseif ($_GET['add']=='interests' || $_GET['add']=='associations' || $_GET['add']=='awards'){
 166                 $savant->assign('title', $_GET['add']);
 167                 $savant->display('social/edit_profile/edit_additional.tmpl.php');
 168         } elseif ($_GET['add']=='representation'){
 169                 $savant->display('social/edit_profile/edit_representation.tmpl.php');
 170         } elseif ($_GET['add']=='contact'){
 171                 $savant->display('social/edit_profile/edit_contact.tmpl.php');
 172         } elseif ($_GET['add']=='personal'){
 173                 $savant->display('social/edit_profile/edit_personal.tmpl.php');
 174         }
 175         //footer
 176         include(AT_INCLUDE_PATH.'footer.inc.php');
 177         exit;
 178 }
 179
 180 // Handles Editing
 181 if (isset($_GET['edit']) && isset($_GET['id']) && (intval($_GET['id']) > 0)){
 182         $id = intval($_GET['id']);
 183
 184         //header starts here.
 185         include(AT_INCLUDE_PATH.'header.inc.php');
 186         $savant->assign('id', $id);
 187         if ($_GET['edit']=='position'){
 188                 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_position WHERE id='.$id;
 189                 $rs = mysql_query($sql, $db);
 190                 $row = mysql_fetch_assoc($rs);
 191
 192                 //Template
 193                 $savant->assign('company', $row['company']);
 194                 $savant->assign('profile_title', $row['title']);
 195                 $savant->assign('from', $row['from']);
 196                 $savant->assign('to', $row['to']);
 197                 $savant->assign('description', $row['description']);
 198                 $savant->display('social/edit_profile/edit_position.tmpl.php');
 199         } elseif ($_GET['edit']=='education'){
 200                 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_education WHERE id='.$id;
 201                 $rs = mysql_query($sql, $db);
 202                 $row = mysql_fetch_assoc($rs);
 203
 204                 //Template
 205                 $savant->assign('university', $row['university']);
 206                 $savant->assign('country', $row['country']);
 207                 $savant->assign('province', $row['province']);
 208                 $savant->assign('degree', $row['degree']);
 209                 $savant->assign('field', $row['field']);
 210                 $savant->assign('from', $row['from']);
 211                 $savant->assign('to', $row['to']);
 212                 $savant->assign('description', $row['description']);
 213                 $savant->display('social/edit_profile/edit_education.tmpl.php');
 214         } elseif ($_GET['edit']=='websites'){
 215                 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_websites WHERE id='.$id;
 216                 $rs = mysql_query($sql, $db);
 217                 $row = mysql_fetch_assoc($rs);
 218
 219                 //Template
 220                 $savant->assign('url', $row['url']);
 221                 $savant->assign('site_name', $row['site_name']);
 222                 $savant->display('social/edit_profile/edit_websites.tmpl.php');
 223
 224         } elseif ($_GET['edit']=='interests'){
 225                 $sql = 'SELECT interests FROM '.TABLE_PREFIX.'social_member_additional_information WHERE member_id='.$_SESSION['member_id'];
 226                 $rs = mysql_query($sql, $db);
 227                 $row = mysql_fetch_assoc($rs);
 228
 229                 //Template
 230                 $savant->assign('interests', $row['interests']);
 231                 $savant->assign('title', 'interests');
 232                 $savant->display('social/edit_profile/edit_additional.tmpl.php');
 233         } elseif ($_GET['edit']=='associations'){
 234                 $sql = 'SELECT associations FROM '.TABLE_PREFIX.'social_member_additional_information WHERE member_id='.$_SESSION['member_id'];
 235                 $rs = mysql_query($sql, $db);
 236                 $row = mysql_fetch_assoc($rs);
 237
 238                 //Template
 239                 $savant->assign('associations', $row['associations']);
 240                 $savant->assign('title', 'associations');
 241                 $savant->display('social/edit_profile/edit_additional.tmpl.php');
 242         } elseif ($_GET['edit']=='awards'){
 243                 $sql = 'SELECT awards FROM '.TABLE_PREFIX.'social_member_additional_information WHERE member_id='.$_SESSION['member_id'];
 244                 $rs = mysql_query($sql, $db);
 245                 $row = mysql_fetch_assoc($rs);
 246
 247                 //Template
 248                 $savant->assign('awards', $row['awards']);
 249                 $savant->assign('title', 'awards');
 250                 $savant->display('social/edit_profile/edit_additional.tmpl.php');
 251         } elseif ($_GET['edit']=='representation'){
 252                 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_representation WHERE member_id='.$_SESSION['member_id'];
 253                 $rs = mysql_query($sql, $db);
 254                 $row = mysql_fetch_assoc($rs);
 255
 256                 //Template
 257                 $savant->assign('rep_name', $row['rep_name']);
 258                 $savant->assign('rep_title', $row['rep_title']);
 259                 $savant->assign('rep_phone', $row['rep_phone']);
 260                 $savant->assign('rep_email', $row['rep_email']);
 261                 $savant->assign('rep_address', $row['rep_address']);
 262                 $savant->display('social/edit_profile/edit_representation.tmpl.php');
 263
 264         }elseif ($_GET['edit']=='contact'){
 265                 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_contact WHERE member_id='.$_SESSION['member_id'];
 266                 $rs = mysql_query($sql, $db);
 267                 $row = mysql_fetch_assoc($rs);
 268
 269                 //Template
 270                 $savant->assign('con_name', $row['con_name']);
 271                 $savant->assign('con_title', $row['con_title']);
 272                 $savant->assign('con_phone', $row['con_phone']);
 273                 $savant->assign('con_email', $row['con_email']);
 274                 $savant->assign('con_address', $row['con_address']);
 275                 $savant->display('social/edit_profile/edit_contact.tmpl.php');
 276
 277         }elseif ($_GET['edit']=='personal'){
 278                 $sql = 'SELECT * FROM '.TABLE_PREFIX.'social_member_personal WHERE member_id='.$_SESSION['member_id'];
 279                 $rs = mysql_query($sql, $db);
 280                 $row = mysql_fetch_assoc($rs);
 281
 282                 //Template
 283                 $savant->assign('per_weight', $row['per_weight']);
 284                 $savant->assign('per_height', $row['per_height']);
 285                 $savant->assign('per_hair', $row['per_hair']);
 286                 $savant->assign('per_eyes', $row['per_eyes']);
 287                 $savant->assign('per_ethnicity', $row['per_ethnicity']);
 288                 $savant->assign('per_languages', $row['per_languages']);
 289                 $savant->assign('per_disabilities', $row['per_disabilities']);
 290                 $savant->display('social/edit_profile/edit_personal.tmpl.php');
 291         }
 292
 293         //footer
 294         include(AT_INCLUDE_PATH.'footer.inc.php');
 295         exit;
 296 }
 297
 298
 299 // Handles Deleting
 300 if (isset($_GET['delete'])){
 301         $id     = intval($_GET['id']);
 302         if ($_GET['delete']=='position'){
 303                 $member->deletePosition($id);
 304         } elseif ($_GET['delete']=='education'){
 305                 $member->deleteEducation($id);
 306         } elseif ($_GET['delete']=='websites'){
 307                 $member->deleteWebsite($id);
 308         } elseif ($_GET['delete']=='interests'){
 309                 $member->deleteInterests($id);
 310         } elseif ($_GET['delete']=='associations'){
 311                 $member->deleteAssociations($id);
 312         } elseif ($_GET['delete']=='awards'){
 313                 $member->deleteAwards($id);
 314         } elseif ($_GET['delete']=='representation'){
 315                 $member->deleteRepresentation($id);
 316         } elseif ($_GET['delete']=='contact'){
 317                 $member->deleteContact($id);
 318         } elseif ($_GET['delete']=='personal'){
 319                 $member->deletePersonal($id);
 320         }
 321 }
 322
 323
 324 // Member object
 325 include(AT_INCLUDE_PATH.'header.inc.php');
 326 $savant->display('social/pubmenu.tmpl.php');
 327 $savant->assign('profile', $member->getDetails());
 328 $savant->assign('position', $member->getPosition());
 329 $savant->assign('education', $member->getEducation());
 330 $savant->assign('websites', $member->getWebsites());
 331 $savant->assign('representation', $member->getRepresentation());
 332 $savant->assign('contact', $member->getContact());
 333 $savant->assign('personal', $member->getPersonal());
 334 $savant->display('social/edit_profile.tmpl.php');
 335 include(AT_INCLUDE_PATH.'footer.inc.php');
 336 ?>