Skip to content

Instantly share code, notes, and snippets.

View rizkytegar's full-sized avatar
🙂
Very Busy

Rizky rizkytegar

🙂
Very Busy
  • Software Engineer
  • central jakarta, Indonesia
View GitHub Profile
SELECT
p.nama AS 'NAMA PEGAWAI',
(
SELECT
m.nama
FROM
pegawai AS m
WHERE
m.id_pegawai = p.id_manager
) AS 'NAMA MANAGER'
SELECT p.nama AS 'NAMA MANAGER'
FROM `pegawai` AS p
WHERE p.id_pegawai IN (SELECT id_manager FROM `pegawai`)
ORDER BY p.id_pegawai asc;
<?php
function e($value, $doubleEncode = true)
{
if ($value instanceof DeferringDisplayableValue) {
$value = $value->resolveDisplayableValue();
}
if ($value instanceof Htmlable) {
return $value->toHtml();
@rizkytegar
rizkytegar / Searchinsidedropdown.html
Last active July 5, 2024 03:47
Search inside dropdown
<!-- Select -->
<select data-hs-select='{
"hasSearch": true,
"searchPlaceholder": "Search...",
"searchClasses": "block w-full text-sm border-gray-200 rounded-lg focus:border-blue-500 focus:ring-blue-500 before:absolute before:inset-0 before:z-[1] py-2 px-3",
"searchWrapperClasses": "bg-white p-2 -mx-1 sticky top-0",
"placeholder": "Select country...",
"toggleTag": "<button type=\"button\"><span class=\"me-2\" data-icon></span><span class=\"text-gray-800\" data-title></span></button>",
"toggleClasses": "hs-select-disabled:pointer-events-none hs-select-disabled:opacity-50 relative py-3 px-4 pe-9 flex text-nowrap w-full cursor-pointer bg-white border border-gray-200 rounded-lg text-start text-sm focus:border-blue-500 focus:ring-blue-500 before:absolute before:inset-0 before:z-[1]",
"dropdownClasses": "mt-2 max-h-72 pb-1 px-1 space-y-0.5 z-20 w-full bg-white border border-gray-200 rounded-lg overflow-hidden overflow-y-auto [&::-webkit-scrollbar]:w-2 [&::-webkit-scrollbar-thumb]:rounded-full [&::-w
<?php
namespace Tests\Feature;
use Tests\TestCase;
use Illuminate\Http\Response;
use Illuminate\Support\Facades\DB;
class KategoriAsetControllerTest extends TestCase
{