diff --git a/2016/user-edit.php b/2016/user-edit.php index edc079f..0e2109b 100644 --- a/2016/user-edit.php +++ b/2016/user-edit.php @@ -1,348 +1,390 @@ . require 'load.php'; $user = null; if( isset( $_GET['uid'] ) ) { $user = User::factoryFromUID( @ $_GET['uid'] ) ->queryRow(); if( !$user ) { die( "not found" ); } if( !$user->hasPermissionToEditUser() ) { error_die( "Can't edit user" ); } } else { if( !has_permission( 'edit-users' ) ) { error_die( "Can't create user" ); } } // register form submit action if( is_action( 'save-user' ) ) { // avoid spaces if( $_POST['email'] ) { $_POST['email'] = luser_input( $_POST['email'], 32 ); } // generate Gravatar if( $_POST['email'] ) { $_POST['gravatar'] = md5( $_POST['email'] ); } $data = []; $data[] = new DBCol( 'user_name', $_POST['name'], 's' ); $data[] = new DBCol( 'user_surname', $_POST['surname'], 's' ); $data[] = new DBCol( 'user_uid', $_POST['uid'], 's' ); $data[] = new DBCol( 'user_email', $_POST['email'], 'snull' ); + $data[] = new DBCol( 'user_site', $_POST['site'], 'snull' ); $data[] = new DBCol( 'user_gravatar', $_POST['gravatar'], 'snull' ); + $data[] = new DBCol( 'user_lovelicense', $_POST['lovelicense'], 'snull' ); // promote empty strings to null foreach( $data as $row ) { $row->promoteNULL(); } if( $user ) { // update existing user User::factoryByID( $user->getUserID() ) ->update( $data ); } else { // insert a new User User::factory() ->insertRow( $data ); } $id = $user ? $user->getUserID() : last_inserted_ID(); $user = User::factoryByID( $id ) ->queryRow(); // POST -> redirect -> GET http_redirect( $user->getUserEditURL(), 302 ); } if( isset( $_POST['action'], $_POST['skill_uid'], $_POST['skill_score'] ) ) { $skill = Skill::factoryFromUID( $_POST['skill_uid'] ) ->queryRow(); $skill or error_die( sprintf( "Skill '%s' not found", esc_html( $_POST['skill_uid'] ) ) ); if( is_action( 'change-skill' ) ) { if( isset( $_POST['skill_delete'] ) ) { // Delete skill checked query( sprintf( "DELETE FROM {$T('user_skill')} WHERE user_ID = %d AND skill_ID = %d", $user->getUserID(), $skill->getSkillID() ) ); } else { // Update skill elsewhere query_update('user_skill', new DBCol('skill_score', $_POST['skill_score'], 'd' ), sprintf( 'skill_ID = %d', $skill->getSkillID() ) ); } } if( is_action( 'add-skill' ) ) { $skill = Skill::factoryFromUID( $_POST['skill_uid'] ) ->queryRow(); // If exists, delete it query( sprintf( "DELETE FROM {$T('user_skill')} WHERE user_ID = %d AND skill_ID = %d", $user->getUserID(), $skill->getSkillID() ) ); insert_row('user_skill', [ new DBCol('user_ID', $user->getUserID(), 'd'), new DBCol('skill_ID', $skill->getSkillID(), 'd'), new DBCol('skill_score', $_POST['skill_score'], 'd'), ] ); } } // register action to delete the user if( $user && is_action( 'delete-user' ) ) { // delete the user from the database User::factory() ->whereInt( 'user_ID', $user->getUserID() ) ->delete(); // POST -> redirect -> GET http_redirect( $user->getUserEditURL(), 302 ); } Header::spawn('user', [ 'title' => $user ? sprintf( __("Modifica utente %s"), $user->getUserFullname() ) : __( "Aggiungi Utente" ) , 'url' => $user ? $user->getUserURL() : null, ] ); ?>

getUserURL(), __( "Vedi" ) . icon('account_box', 'left') ) ?>

get( User::NAME ) ) : '' ?> />
get( User::SURNAME ) ) : '' ?> />
getUserUID() ) : '' ?> />
getUserEmail() ) : '' ?> />
hasUserGravatar() ? value( $user->getUserGravatarUID() ) : '' ?> />
- + + + +
+
+
+ + get( User::WEBSITE ) ) + : '' + ?> /> +
+
+
+ + + +
+
+ + + + hasUserLovelicense() ) { + echo $user->getUserLovelicense()->getLink(); + } + ?> +
+
+

factoryUserSkills() ->queryGenerator(); ?> valid() ): ?>

getSkillPhrase() ?>

. trait UserTrait { /** * Get the user ID * * @return int */ public function getUserID() { return $this->nonnull( User::ID ); } /** * Get the user UID * * @return string */ public function getUserUID() { return $this->get( User::UID ); } /** * Get the user e-mail * * @return string */ public function getUserEmail() { return $this->get( User::EMAIL ); } /** * Check if the user is public * * @return bool */ public function isUserPublic() { return $this->get( User::IS_PUBLIC ); } /** * Check if I can see this user * * @return bool */ public function isUserVisible() { return $this->isUserPublic() || $this->isUserMyself(); } /** * Get the user full name * * @return string */ public function getUserFullname() { return sprintf( __("%s %s"), $this->get( User::NAME ), $this->get( User::SURNAME ) ); } function getUserURL( $base = ROOT ) { return $base . sprintf( PERMALINK_USER, CURRENT_CONFERENCE_UID, $this->getUserUID() ); } function forceUserPermalink() { $url = $this->getUserURL( ROOT ); if( $url !== $_SERVER['REQUEST_URI'] ) { http_redirect( $url ); } } function getUserLink( $base = null, $html_class = null) { $name = $this->getUserFullname(); return HTML::a( $this->getUserURL( $base ), $name, sprintf( __("Profilo utente di %s"), $name ), $html_class ); } /** * Check if the User has a Gravatar image * * @return int */ public function hasUserGravatar() { return $this->has( User::GRAVATAR ) || $this->has( User::EMAIL ); } /** * Get the md5 of the E-mail * * @return string|null */ public function getUserGravatarUID() { $gravatar = $this->get( User::GRAVATAR ); return $gravatar ? $gravatar : md5( $this->getUserEmail() ); } /** * Check if the User has an image * * @return boolean */ public function hasUserImage() { return $this->has( User::IMAGE ) || $this->has( User::GRAVATAR ); } /** * Get the URL of the user image * * @param int $size Suggested width * @param boolean $absolute Set true to force an absolute URL * @return string */ public function getUserImage( $size = 256, $absolute = false ) { $image = $this->get( User::IMAGE ); if( ! $image ) { $image = 'https://www.gravatar.com/avatar/' . $this->getUserGravatarUID() . '?s=' . $size; } return site_page( $image, $absolute ); } /** * It has an user bio? * * @return bool */ public function hasUserBio() { return null !== $this->get('user_bio'); } function getUserBio() { return $this->get('user_bio'); } function getUserBioHTML($args = []) { return Markdown::parse( __( $this->getUserBIO() ), $args); } /** * Check if the user is somehow social * * @return bool */ public function isUserSocial() { foreach( User::allSocialFields() as $field ) { if( $this->has( $field ) ) { return true; } } return false; } /** * Get the user Facebook profile URL * * @return string URL */ public function getUserFacebruck() { return 'https://facebook.com/' . $this->get( User::FACEBOOK ); } /** * Get the user Google+ profile URL * * @return string URL */ public function getUserGuggolpluz() { return 'https://plus.google.com/' . $this->get( User::GOOGLE_PLUS ); } /** * Get the user Twitter profile URL * * @return string URL */ public function getUserTuitt() { return 'https://twitter.com/' . $this->get( User::TWITTER ); } /** * Get the user Linkedin profile URL * * @return string URL */ public function getUserLinkeddon() { return 'https://www.linkedin.com/in/' . $this->get( User::LINKEDIN ); } /** * Get the user GitHub profile URL * * @return string URL */ public function getUserGithubbo() { return 'https://github.com/' . $this->get( User::GITHUB ); } /** * Get the edit URL to this user * * @return string */ public function getUserEditURL() { $url = http_build_get_query( '2016/user-edit.php', [ 'uid' => $this->getUserUID(), ] ); return site_page( $url ); } /** * Can you edit this user? * * @return bool */ public function hasPermissionToEditUser() { if( has_permission('edit-users') ) { return true; } if( has_permission('edit-account') && $this->isUserMyself() ) { return true; } return false; } /** * Is this user myself? * * @return bool */ public function isUserMyself() { return is_logged() && get_user()->getUserID() === $this->getUserID(); } - function hasUserLovelicense() { - return null !== $this->get( 'user_lovelicense' ); + /** + * Check if the User has a loved license + * + * @return + */ + public function hasUserLovelicense() { + return $this->has( 'user_lovelicense' ); } - function getUserLovelicense() { - return license( $this->user_lovelicense ); + /** + * Get the User loved license + * + * @return License + */ + public function getUserLovelicense() { + return license( $this->get( 'user_lovelicense' ) ); } function factoryUserSkills() { return UserSkill::factorySkillByUser( $this->getUserID() ); } function factoryUserEvents() { return FullEvent::factoryByUser( $this->getUserID() ); } /** * Normalize a User object */ protected function normalizeUser() { $this->integers( User::ID ); $this->booleans( User::IS_PUBLIC, User::IS_ACTIVE ); } } class User extends Sessionuser { use UserTrait; /** * Name column */ const NAME = 'user_name'; /** * Aristocratic title column */ const ARISTOCRATIC_TITLE = 'user_title'; /** * ID column */ const SURNAME = 'user_surname'; /** * He/she public column */ const IS_PUBLIC = 'user_public'; /** * Image column */ const IMAGE = 'user_image'; /** * E-mail */ const EMAIL = 'user_email'; /** * Gravatar column */ const GRAVATAR = 'user_gravatar'; /** * RSS column */ const RSS = 'user_rss'; /** * Facebook username column */ const FACEBOOK = 'user_fb'; /** * Linkedin username column */ const LINKEDIN = 'user_lnkd'; /** * Google+ username column */ const GOOGLE_PLUS = 'user_googl'; /** * Twitter username */ const TWITTER = 'user_twtr'; /** * GitHub username */ const GITHUB = 'user_github'; /** * Personal website column */ const WEBSITE = 'user_site'; /** * Loved license column */ const LOVED_LICENSE = 'user_lovelicense'; /** * Biography column */ const BIO = 'user_bio'; /** * Complete ID column name */ const ID_ = self::T . DOT . self::ID; /** * Maximum UID length */ const MAXLEN_UID = 20; /** * Constructor */ public function __construct() { $this->normalizeUser(); } /** * Get all the user social fields * * @return array */ public static function allSocialFields() { return [ User::RSS, User::FACEBOOK, User::LINKEDIN, User::GOOGLE_PLUS, User::TWITTER, User::GITHUB, ]; } /** * Factory users by an event * * @param $event_ID int * @return Query */ public static function factoryByEvent( $event_ID ) { return self::factory() ->from('event_user') ->equals('event_user.user_ID', 'user.user_ID') ->whereInt('event_user.event_ID', $event_ID ); } }