Arthur Jiang jhesyong

jhesyong / rotate-jpg.php

Last active August 29, 2015 14:16

Rotate jpg according to exif

	<?php

	function rotate_jpg($filename)
	{
	if (exif_imagetype($filename) == IMAGETYPE_JPEG)
	{
	$image = imagecreatefromjpeg($filename);
	$image = imagerotate($image, array_values([0, 0, 0, 180, 0, 0, -90, 0, 90])[@exif_read_data($filename)['Orientation'] ?: 0], 0);
	imagejpeg($image, $filename, 100);
	}

jhesyong / bootstrap-tooltip-border.scss

Last active May 24, 2018 11:32

Add border to bootstrap tooltip

jhesyong / left join null last

Created August 12, 2015 03:52

Put null to the last when using left join

	SELECT * FROM media
	LEFT JOIN media_priority
	ON (media_priority.media_id = media.id AND media_priority.media_tag = '".$tag."')
	WHERE something = 'something'
	ORDER BY (media_priority.media_order IS NULL) ASC, media_priority.media_order ASC;

jhesyong / laravel-s3-presign-url.php

Created October 14, 2015 07:32

Get presigned url of private file

	function getFilePathAttribute($value)
	{
	$disk = Storage::disk('s3');

	if ($disk->exists($value)) {
	$command = $disk->getDriver()->getAdapter()->getClient()->getCommand('GetObject', [
	'Bucket' => Config::get('filesystems.disks.s3.bucket'),
	'Key' => $value,
	]);

	$tooltip-border-color: #ccc;
	$tooltip-border-width: 1px;
	$tooltip-arrow-border-width: $tooltip-arrow-width + $tooltip-border-width;

	.tooltip {
	&.top { padding: $tooltip-arrow-border-width 0; }
	&.right { padding: 0 $tooltip-arrow-border-width; }
	&.bottom { padding: $tooltip-arrow-border-width 0; }
	&.left { padding: 0 $tooltip-arrow-border-width; }
	}