Wiki SGY.io

Ceci est une ancienne révision du document !

---

CASE WHEN `User`.`firstname` IS NULL

THEN `User`.`username`

WHEN `User`.`firstname` IS NOT NULL

THEN (CONCAT(`User`.`firstname`, " ", `User`.`lastname`))

END

CASE `User`.`show_fullname`

WHEN 1 THEN
	IF((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL), `User`.`username`, CONCAT(`User`.`firstname`, " ", `User`.`lastname`))
WHEN 0 THEN
	`User`.`username`

END

CASE `User`.`show_fullname`

WHEN 1 THEN
	`User`.`name`
WHEN 0 THEN
	`User`.`username`

END

CASE `User`.`show_fullname` WHEN 1 THEN `User`.`name` WHEN 0 THEN `User`.`username` END

CASE `User`.`show_fullname`

WHEN 1 THEN
	

	CASE 
		WHEN `User`.`firstname` IS NULL THEN
			`User`.`username`
		WHEN `User`.`firstname` IS NOT NULL THEN
			CONCAT(`User`.`firstname`, " ", `User`.`lastname`)
	END

WHEN 0 THEN
	`User`.`username`

END

CASE `User`.`show_fullname` WHEN 1 THEN CASE WHEN `User`.`firstname` IS NULL THEN `User`.`username` WHEN `User`.`firstname` IS NOT NULL WHEN CONCAT(`User`.`firstname`, “ ”, `User`.`lastname`) END WHEN 0 THEN `User`.`username` END

CASE `User`.`show_fullname` WHEN 1 THEN IF¹⁾ WHEN 0 THEN `User`.`username` END

²⁾ AND ³⁾

ALTER TABLE `socialbeer`.`users` ADD COLUMN `name_mode` enum('username','fullname','firstname_firstletterlastname') NOT NULL DEFAULT 'username' AFTER `username`

    'public_name' => '

CASE `User`.`show_fullname`

WHEN 1 THEN
	IF(((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL)) OR ((`User`.`firstname` = "") OR (`User`.`lastname` = "")), `User`.`username`, CONCAT(`User`.`firstname`, " ", `User`.`lastname`))
WHEN 0 THEN
	`User`.`username`
END'

IF⁴⁾ OR ⁵⁾, `User`.`username`, CONCAT(`User`.`firstname`, “ ”, `User`.`lastname`))

    'public_name' => '

CASE `User`.`name_display`

WHEN "username" THEN
	`User`.`username`
WHEN "fullname" THEN
	IF(((`User`.`firstname` IS NULL) OR (`User`.`lastname` IS NULL)) OR ((`User`.`firstname` = "") OR (`User`.`lastname` = "")), `User`.`username`, CONCAT(`User`.`firstname`, " ", `User`.`lastname`))
WHEN "firstname_fllastname" THEN
	CONCAT(`User`.`firstname`, " ", SUBSTRING(`User`.`lastname`,1,1), ".")

END

CASE `User`.`name_display` WHEN “username” THEN `User`.`username` WHEN “fullname” THEN IF⁶⁾ OR ⁷⁾, `User`.`username`, CONCAT(`User`.`firstname`, “ ”, `User`.`lastname`)) WHEN “firstname_fllastname” THEN CONCAT(`User`.`firstname`, “ ”, SUBSTRING(`User`.`lastname`,1,1), “.”) END

	<a href="#" class="beer-mini-item-button-blue"><?php echo $this->Html->link($this->Text->truncate($review['User']['public_name'],10, array('ending' => '')), array('controller' => 'users', 'action' => 'view',  $review['User']['username'])); ?></a>