TEDUH | Sistem Bank Data Perumahan | Jabatan Perumahan Negara, KPKT

Bil	No PT/Lot/Plot	No Unit	Harga Jualan(RM)	Harga SPJB(RM)	Status Jualan	Kuota Bumi
1	12	PT 284222	695,640.00	-	Belum Dijual	Ya
2	14	PT 284224	528,240.00	-	Belum Dijual	Ya
3	16	PT 284226	568,000.00	-	Belum Dijual	Tidak
4	18	PT 284228	568,000.00	-	Belum Dijual	Tidak
5	19	PT 284229	568,000.00	-	Belum Dijual	Tidak
6	13	PT 284223	523,590.00	523,590.00	Telah Dijual	Ya
7	15	PT 284225	568,000.00	568,000.00	Telah Dijual	Tidak
8	17	PT 284227	568,000.00	568,000.00	Telah Dijual	Tidak
9	21	PT 284231	568,000.00	568,000.00	Telah Dijual	Tidak
10	22	PT 284232	568,000.00	568,000.00	Telah Dijual	Tidak
11	26	PT 284236	568,000.00	568,000.00	Telah Dijual	Tidak
12	27	PT 284237	568,000.00	568,000.00	Telah Dijual	Tidak
13	29	PT 284239	648,000.00	648,000.00	Telah Dijual	Tidak
14	20	PT 284230	568,000.00	-	Belum Dijual	Tidak
15	28	PT 284238	568,000.00	568,000.00	Telah Dijual	Tidak
16	23	PT 284233	728,000.00	728,000.00	Telah Dijual	Tidak

Messages1 Timeline Exceptions Views7 Route Queries12 Models19 Mails Gate Session Request

Request history8.1.3074.37ms3MBGET unit-project-swasta/{id}/{total_bil_unit?}

warninglog[18:49:25] LOG.warning: Return type of App\Visitor\Visitor::count() should either be compatible with...

Booting (18.73ms)time
Application (55.63ms)time
1 x Application (74.8%)
55.63ms
1 x Booting (25.19%)
18.73ms

7 templates were rendered

portal-new.pages.static.unit_projek_swastaunit_projek_swasta.blade.php#?blade
portal-new.portalportal.blade.php#?blade
portal-new.themes.headerheader.blade.php#?blade
portal-new.themes.navbarnavbar.blade.php#?blade
portal-new.themes.breadcrumbbreadcrumb.blade.php#?blade
portal-new.themes.titletitle.blade.php#?blade
portal-new.themes.footerfooter.blade.php#?blade

uri: GET unit-project-swasta/{id}/{total_bil_unit?}
middleware: web
controller: App\Http\Controllers\PortalSwastaController@unitprojectswasta
namespace: App\Http\Controllers
prefix
where
as: portal.project-swasta.unit
file: app/Http/Controllers/PortalSwastaController.php:623-668

10 statements were executed (3 duplicates)Show only duplicates teduh-production dw_hims_new38.08ms

Connection Establishedteduh-productionDatabaseVisitorRepository.php#57

Backtrace

app/Visitor/Repos/DatabaseVisitorRepository.php:57
app/Visitor/Visitor.php:100
app/Visitor/Middleware/LogVisitor.php:25
vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
app/Http/Middleware/SetLocale.php:24

insert into `visitor_registry` (`ip`, `country`, `visited_at`) values ('216.73.216.76', null, '2025-06-26 18:49:25')

7.32msteduh-productionDatabaseVisitorRepository.php#57

Bindings	0: 216.73.216.76 1: 2: 2025-06-26 18:49:25
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:57 app/Visitor/Visitor.php:100 app/Visitor/Middleware/LogVisitor.php:25 vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183 app/Http/Middleware/SetLocale.php:24

Connection Establisheddw_hims_newPortalSwastaController.php#625

Backtrace

app/Http/Controllers/PortalSwastaController.php:625
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `pemajuan` where `id` = '30307-1' and date_from < now() and date_to > now() limit 1

3.59msdw_hims_newPortalSwastaController.php#625

Bindings	0: 30307-1
Backtrace	app/Http/Controllers/PortalSwastaController.php:625 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `nolot_unit` where `pemajuan_id` = '30307-1' and `pembangunan_id` != '53384' and date_from < now() and date_to > now()

3.58msdw_hims_newPortalSwastaController.php#652

Bindings	0: 30307-1 1: 53384
Backtrace	app/Http/Controllers/PortalSwastaController.php:652 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `pembangunan` where `pembangunan`.`id` in (53404)

820μsdw_hims_newPortalSwastaController.php#652

Backtrace

app/Http/Controllers/PortalSwastaController.php:652
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `kod_jenis_rumah` where `kod_jenis_rumah`.`id` in (1)

600μsdw_hims_newPortalSwastaController.php#652

Bindings	0: 1
Backtrace	app/Http/Controllers/PortalSwastaController.php:652 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `visitor_registry` where `visited_at` between '2025-06-26 00:00:00' and '2025-06-26 23:59:59'

11.64msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-26 00:00:00 1: 2025-06-26 23:59:59
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:98 app/Visitor/Visitor.php:121 view::portal-new.themes.footer:97 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select sum(`visitors`) as aggregate from `visitor_daily` where `id` >= '2025-06-01 00:00:00' and `id` < '2025-06-26 00:00:00'

490μsteduh-productionDatabaseVisitorRepository.php#106

Bindings	0: 2025-06-01 00:00:00 1: 2025-06-26 00:00:00
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:106 app/Visitor/Visitor.php:132 view::portal-new.themes.footer:109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as aggregate from `visitor_registry` where `visited_at` between '2025-06-26 00:00:00' and '2025-06-26 23:59:59'

4.79msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-26 00:00:00 1: 2025-06-26 23:59:59
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:98 app/Visitor/Repos/DatabaseVisitorRepository.php:108 app/Visitor/Visitor.php:132 view::portal-new.themes.footer:109 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

select sum(`visitors`) as aggregate from `visitor_daily` where `id` < '2025-06-26 00:00:00'

1.32msteduh-productionDatabaseVisitorRepository.php#90

Bindings	0: 2025-06-26 00:00:00
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:90 app/Visitor/Visitor.php:110 view::portal-new.themes.footer:121 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58

select count(*) as aggregate from `visitor_registry` where `visited_at` between '2025-06-26 00:00:00' and '2025-06-26 23:59:59'

3.93msteduh-productionDatabaseVisitorRepository.php#98

Bindings	0: 2025-06-26 00:00:00 1: 2025-06-26 23:59:59
Backtrace	app/Visitor/Repos/DatabaseVisitorRepository.php:98 app/Visitor/Repos/DatabaseVisitorRepository.php:91 app/Visitor/Visitor.php:110 view::portal-new.themes.footer:121 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124

App\Models\Hims\NoLotUnit: 16NoLotUnit.php#?
App\Models\Hims\Pemajuan: 1Pemajuan.php#?
App\Models\Hims\Pembangunan: 1Pembangunan.php#?
App\Models\Hims\Lookup\JenisRumah: 1JenisRumah.php#?

_token: Fe688F5AWoA8Or0yq9oZSFnEnBOvZp5KD8f2ar51
visit_expired_at: O:25:"Illuminate\Support\Carbon":3:{s:4:"date";s:26:"2025-06-26 23:59:59.999999";s:13:"timezone_type...
_previous: array:1 [ "url" => "http://103.156.83.178/unit-project-swasta/30307-1/16" ]
_flash: array:2 [ "old" => [] "new" => [] ]

telescope

View in Telescope

path_info

/unit-project-swasta/30307-1/16

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:10 [▼
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "10.1.86.179"
  ]
  "via" => array:1 [▶
    0 => "1.1 squid-proxy-5b5d847c96-rkbw4 (squid/6.10)"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "host" => array:1 [▶
    0 => "103.156.83.178"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 26 Jun 2025 10:49:25 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijc4Z3NreG42ZnR5ZlE4QXhIajVlOWc9PSIsInZhbHVlIjoiMk1ZWjNZbXk3M2FOV0g5ZUZiN3NVYXpDbEVQWnNVSFZrcHNuZ0M4OE9Pc0o4ZHhpbHRKb2U0VFJWSDBYSFhKOTFsRWRwM0NmMGU2d3U1VnBPUUlYaHBoYUVZeHJ3dWE3Z0VGbkZEc0lDZzZlUkFScG1LWnEwWW9OSXRjbk9Fc1QiLCJtYWMiOiJkMDczNjEwNjk0NzViM2FmOTZiY2NhYTRlNTAxZTNjZTY3ODNjYmFjZDgxYTRiZGQyY2IyYjcyN2VhNDg1YzM0IiwidGFnIjoiIn0%3D; expires=Thu, 26 Jun 2025 12:49:25 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Ijc4Z3NreG42ZnR5ZlE4QXhIajVlOWc9PSIsInZhbHVlIjoiMk1ZWjNZbXk3M2FOV0g5ZUZiN3NVYXpDbEVQWnNVSFZrcHNuZ0M4OE9Pc0o4ZHhpbHRKb2U0VFJWSDBYSFhKOTFsRWRwM ▶"
    1 => "laravel_session=eyJpdiI6Ii80NGtjZ1NaT3lIeXdmTmV0Q3l5bEE9PSIsInZhbHVlIjoiWFBHY3V1WFdIVWRpLzVJUytkNXB5cWtub2pTUVNuRWpEeGNBVHRLd3BRM1VLbHhpeE11N3VOOW81U1JQMmJ4RHV2M3F4Ty9IalNHZG5GSEsybUQ3RXRpUU5HRXlhTHpvMm9LMHdMQno1OU9qcERsUVpic3pRYzBlL3NkVUtIdXYiLCJtYWMiOiIwZDE3M2I3MzQxNzBmZjFkMDQ3NzQyMGUxYmVkMTllZWE4MjY0OTUwNDYxMTg4NDg0N2FkYjIwNzQzZTllZjQ0IiwidGFnIjoiIn0%3D; expires=Thu, 26 Jun 2025 12:49:25 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ii80NGtjZ1NaT3lIeXdmTmV0Q3l5bEE9PSIsInZhbHVlIjoiWFBHY3V1WFdIVWRpLzVJUytkNXB5cWtub2pTUVNuRWpEeGNBVHRLd3BRM1VLbHhpeE11N3VOOW81U1JQMmJ4RHV2 ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Ijc4Z3NreG42ZnR5ZlE4QXhIajVlOWc9PSIsInZhbHVlIjoiMk1ZWjNZbXk3M2FOV0g5ZUZiN3NVYXpDbEVQWnNVSFZrcHNuZ0M4OE9Pc0o4ZHhpbHRKb2U0VFJWSDBYSFhKOTFsRWRwM0NmMGU2d3U1VnBPUUlYaHBoYUVZeHJ3dWE3Z0VGbkZEc0lDZzZlUkFScG1LWnEwWW9OSXRjbk9Fc1QiLCJtYWMiOiJkMDczNjEwNjk0NzViM2FmOTZiY2NhYTRlNTAxZTNjZTY3ODNjYmFjZDgxYTRiZGQyY2IyYjcyN2VhNDg1YzM0IiwidGFnIjoiIn0%3D; expires=Thu, 26-Jun-2025 12:49:25 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ijc4Z3NreG42ZnR5ZlE4QXhIajVlOWc9PSIsInZhbHVlIjoiMk1ZWjNZbXk3M2FOV0g5ZUZiN3NVYXpDbEVQWnNVSFZrcHNuZ0M4OE9Pc0o4ZHhpbHRKb2U0VFJWSDBYSFhKOTFsRWRwM ▶"
    1 => "laravel_session=eyJpdiI6Ii80NGtjZ1NaT3lIeXdmTmV0Q3l5bEE9PSIsInZhbHVlIjoiWFBHY3V1WFdIVWRpLzVJUytkNXB5cWtub2pTUVNuRWpEeGNBVHRLd3BRM1VLbHhpeE11N3VOOW81U1JQMmJ4RHV2M3F4Ty9IalNHZG5GSEsybUQ3RXRpUU5HRXlhTHpvMm9LMHdMQno1OU9qcERsUVpic3pRYzBlL3NkVUtIdXYiLCJtYWMiOiIwZDE3M2I3MzQxNzBmZjFkMDQ3NzQyMGUxYmVkMTllZWE4MjY0OTUwNDYxMTg4NDg0N2FkYjIwNzQzZTllZjQ0IiwidGFnIjoiIn0%3D; expires=Thu, 26-Jun-2025 12:49:25 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ii80NGtjZ1NaT3lIeXdmTmV0Q3l5bEE9PSIsInZhbHVlIjoiWFBHY3V1WFdIVWRpLzVJUytkNXB5cWtub2pTUVNuRWpEeGNBVHRLd3BRM1VLbHhpeE11N3VOOW81U1JQMmJ4RHV2 ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "Fe688F5AWoA8Or0yq9oZSFnEnBOvZp5KD8f2ar51"
  "visit_expired_at" => "O:25:"Illuminate\Support\Carbon":3:{s:4:"date";s:26:"2025-06-26 23:59:59.999999";s:13:"timezone_type";i:3;s:8:"timezone";s:17:"Asia/Kuala_Lumpur";}"
  "_previous" => array:1 [▶
    "url" => "http://103.156.83.178/unit-project-swasta/30307-1/16"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-06-26 18:49:25	GET	/unit-project-swasta/30307-1/16	1 7 12 19

TEDUH | Transforming & Empowering Data Usage In Housing

Senarai Unit Perumahan Swasta

Keterangan Unit

1 x Application (74.8%)	55.63ms
1 x Booting (25.19%)	18.73ms