Skip to content

Instantly share code, notes, and snippets.

View jhesyong's full-sized avatar

Arthur Jiang jhesyong

View GitHub Profile
@jhesyong
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,
]);
@jhesyong
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
jhesyong / bootstrap-tooltip-border.scss
Last active May 24, 2018 11:32
Add border to bootstrap tooltip
$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; }
}
@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);
}