Drop files here

SQL upload ( 0 ) x -

Server: 127.0.0.1 »Database: cafe »Table: tbl_calculations
Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (2128 total, Query took 0.0044 seconds.) [post_date: 2025-02-28... - 2025-02-28...]
SELECT * FROM `tbl_calculations` ORDER BY `post_date` DESC 
Full texts idid_empEmployeeDesignationSalaryPrevious_reservedWorkedMis_CountGet_PreviousAnnualpublic_holidaysLieu_Avail_In_MonthPayable_Dayscut_daysNow_reservedTotal_reservedBonusEarned_BonusOverTimeAdvancePayablepost_date Descending Ascending 1branchcellbank_transfer_optiontitle_namebank_nameaccount_numberstatus
2314 187 Saif Ali Khan Commis 3 28000.00 0 12 2 0 0 2.1538461538462 16.153846153846 0 0 0 0.00 15076.923076923 0 15076.923076923 2025-02-28 Islamabad +923554696655 No 0
2313 186 Muhammad Hassan Ul Haq Busser 20000.00 0 9 2 0 0 1.6923076923077 12.692307692308 0 0 0 0.00 8461.5384615385 0 8461.5384615385 2025-02-28 Islamabad +923179028881 Yes Muhammad Hassan Ul Haq Meezan Bank Limited 00300109690603 0
2312 587 Shahzad Arif Dishwasher Main Kitchen 25000.00 0 10 18 0 0 4 30 0 2 2 0.00 25000 0 25000 2025-02-28 Lahore No 0
2311 588 Asmat Ullah Dishwasher Main Kitchen 25000.00 0 24 2 0 0 4 30 0 0 0 0.00 25000 0 25000 2025-02-28 Lahore No 0
2310 586 Shahid Maqbool Dishwasher Main Kitchen 25000.00 0 12 11 0 0 3.5384615384615 26.538461538462 0 0 0 0.00 22115.384615385 0 22115.384615385 2025-02-28 Lahore No 0
2309 585 Hammad Manzoor Busser 25000.00 0 15 7 0 0 3.3846153846154 25.384615384615 0 0 0 0.00 21153.846153846 0 21153.846153846 2025-02-28 Lahore No 0
2308 584 Muhammad Usman Intern Pastry 10000.00 0 22 2 0 0 3.6923076923077 27.692307692308 0 0 0 0.00 9230.7692307692 0 9230.7692307692 2025-02-28 Lahore No 0
2307 113 Gulam Qadir Commis 2 35000.00 0 9 2 0 0 1.6923076923077 12.692307692308 0 0 0 0.00 14807.692307692 0 14807.692307692 2025-02-28 Islamabad +923228702624 No 0
2306 185 Binyameen Yousaf House Keeping 20000.00 0 25 2 0 0 4 30 0 1 1 0.00 20000 0 20000 2025-02-28 Islamabad +923476748171 No 0
2305 184 Noman Pastry Commis 3 28000.00 0 24 2 0 0 4 30 0 0 0 0.00 28000 0 28000 2025-02-28 Islamabad +923489299771 No 0
2304 583 Sadaqat Ullah Dishwasher Main Kitchen 25000.00 0 22 2 0 0 3.6923076923077 27.692307692308 0 0 0 0.00 23076.923076923 0 23076.923076923 2025-02-28 Lahore +923554722419 No 0
2303 581 Irfan Hanif House Keeping 25000.00 0 24 2 0 0 4 30 0 0 0 0.00 25000 0 25000 2025-02-28 Lahore +923284365639 No 0
2302 579 Salar Nazir Intern Main Kitchen 20000.00 0 21 2 0 0 3.5384615384615 26.538461538462 0 0 0 0.00 17692.307692308 0 17692.307692308 2025-02-28 Lahore +923484991126 No 0
2301 582 Azan Atif Commis 2 30000.00 0 21 2 0 0 3.5384615384615 26.538461538462 0 0 0 0.00 26538.461538462 0 26538.461538462 2025-02-28 Lahore +923174871736 No 0
2300 580 Aziz Ullah Commis 1 40000.00 0 25 2 0 0 4 30 0 1 1 0.00 40000 0 40000 2025-02-28 Lahore +923470658107 No 0
2299 577 Ijaz Mehboob Khan Babar Senior CDP 65000.00 0 24 6 0 0 4 30 0 4 4 0.00 65000 0 3672.00 61328 2025-02-28 Lahore +923062607055 Yes Ijaz Mehboob Khan Babar Bank Alfalah Limited 04611007953164 0
2298 578 Shafi Ullah Intern Barista 25000.00 0 28 2 0 0 4 30 0 4 4 0.00 25000 0 25000 2025-02-28 Lahore +923435925028 No 0
2297 576 Ali Raza Busser 25000.00 0 23 2 2 0 3.8461538461538 30 0 1 1 0.00 25000 0 25000 2025-02-28 Lahore +923418172139 No 0
2296 183 Anwar Ahmad GRO 35000.00 0 22 2 2 0 3.6923076923077 29.692307692308 0 0 0 0.00 34641.025641026 0 34641.025641026 2025-02-28 Lahore +923454146992 No 0
2295 575 Saqib Tariq Server 25000.00 0 24 2 0 0 4 30 0 0 0 0.00 25000 0 25000 2025-02-28 Lahore +923065878482 No 0
2294 182 Ahraz Ali Pastry Commis 3 25000.00 0 24 2 0 0 4 30 0 0 0 0.00 25000 0 25000 2025-02-28 Islamabad +923452851964 No 0
2293 181 Muhammad Saqib Server 28000.00 0 24 2 0 0 4 30 0 0 0 0.00 28000 0 28000 2025-02-28 Islamabad +923125507178 No 0
2292 574 Najeeb Ullah Server 30000.00 1 22 2 1 2 0 3.8461538461538 30 0 1 2 0.00 30000 0 30000 2025-02-28 Lahore +923555289191 No 0
2291 573 Sohail Ahmad Dishwasher Main Kitchen 25000.00 7 25 2 1 0 0 4 30 0 2 9 0.00 25000 0 25000 2025-02-28 Lahore No 0
2290 180 Ubaid Ullah Helper Main Kitchen 25000.00 4 27 2 0 0 4 30 0 3 7 0.00 25000 0 25000 2025-02-28 Islamabad +923424044883 No 0