INSERT INTO akfhhighschool_emsdb.teachers ( 
    designation, name, joining_date, birthdate, mpo_date,
    index_no, email, phone, nid, photo, edu_qualification, status
)
SELECT
    degination, teacher_name, joining_date, birth_day, mpo_date,
    NULL, email, mobile, nid, picture, education_status, status
FROM akfhhighschool_websitedb.teacher_information;

UPDATE `teachers` SET `type` = 'Teacher' WHERE  1;
UPDATE teachers
SET teacher_code = CONCAT('25', LPAD(id, 2, '0'));

INSERT INTO akfhhighschool_emsdb.notices (title, description, file, created_at, updated_at)
SELECT
    title,
    title, -- description এও title বসানো হলো
    file_name,
    date,
    date
FROM akfhhighschool_websitedb.upload_file
WHERE 1 ;

INSERT INTO akfhhighschool_emsdb.exam_result (`date`, `title`, `file`, `status`, `created_at`, `updated_at`)
SELECT
    date,
    title,
    file_name,
    1,              -- status ফিক্সড 1
    date,
    NOW()
FROM akfhhighschool_websitedb.upload_file
WHERE 1;

INSERT INTO akfhhighschool_emsdb.excutive_council (id, name, designation, category)
SELECT id, name, designation, details
FROM akfhhighschool_websitedb.excutive_council;

cd C:\Users\USER\Downloads
AccessDatabaseEngine_x64.exe /quiet

https://canyouseeme.org/

DELETE t1
FROM attendances t1
INNER JOIN attendances t2 
WHERE 
    t1.id < t2.id AND 
    t1.user_id = t2.user_id AND 
    t1.punch_time = t2.punch_time;

ALTER TABLE attendances ADD UNIQUE unique_attendance (user_id, punch_time);

DELETE a
FROM attendances a
JOIN (
    SELECT user_id, punch_time, MIN(id) AS min_id
    FROM attendances
    GROUP BY user_id, punch_time
    HAVING COUNT(*) > 1
) b ON a.user_id = b.user_id AND a.punch_time = b.punch_time AND a.id != b.min_id;

SELECT * FROM `attendances` WHERE DATE(`punch_time`) IN ('2026-03-07','2026-03-08','2026-03-10') ORDER BY `punch_time` DESC;

SELECT DISTINCT device_id FROM attendances WHERE punch_time >= CURDATE() AND punch_time < CURDATE() + INTERVAL 1 DAY ORDER BY `attendances`.`device_id` ASC

SELECT user_id FROM attendances WHERE user_id NOT REGEXP '^[0-9]+$';

UPDATE `attendances` SET `status` = '1'  WHERE   `status` = 0 AND `punch_time` <= '2026-01-01';

UPDATE `attendances` SET `status` = '2'  WHERE `status` = 0 AND `punch_time` <= '2026-05-30';

UPDATE `attendances` SET `status` = '0'  WHERE `punch_time` >= '2026-01-30';

UPDATE `attendances` SET `user_id` = '38' WHERE `user_id` = '15';

UPDATE `attendances` 
SET `status` = '0' 
WHERE `user_id` IN (
    '172891','172892',
);

UPDATE `attendance_log` SET `status` = '0' WHERE `checktime` >= '2025-06-24 00:00:00';

UPDATE `attendance_log` SET `status` = '1' WHERE `checktime` <= '2025-12-31 00:00:00';

UPDATE `attendance_log` SET `status` = '0' WHERE `user_id` = 38;

UPDATE `attendance_log` SET `user_id` = '38' WHERE `user_id` = 15;

UPDATE `attendance_log` SET `status` = '0' WHERE `checktime` <= '2024-08-31 00:00:00' ;

UPDATE attendance_log SET user_id= 312 WHERE user_id = 38777

UPDATE attendance_log SET status = 0 WHERE user_id= 312 ;

-- ৩১ ডিসেম্বর ২০২৫-এর পরের সব অ্যাটেনডেন্স ডাটা মুছে ফেলতে
DELETE FROM attendances WHERE punch_time >= '2025-12-31';

-- ২৭ নভেম্বর ২০২৫-এর পরের সব অ্যাটেনডেন্স লগ মুছে ফেলতে
DELETE FROM tbl_attendance_log WHERE attendance_date >= '2025-11-27';

-- যেসব user_id তে শুধু সংখ্যা নেই (অক্ষর বা আবর্জনা ডাটা রয়েছে) সেগুলো মুছে ফেলতে
DELETE FROM attendances WHERE user_id NOT REGEXP '^[0-9]+$';

-- user_id কলামের ডাটা টাইপ INT (পূর্ণসংখ্যা) এবং ডিফল্ট মান NULL হিসেবে পরিবর্তন করতে
ALTER TABLE `attendances` CHANGE `user_id` `user_id` INT NULL DEFAULT NULL;

Windows-এ Run (Windows + R) এর হিস্টরি (ইতিহাস) ডিলেট করার কয়েকটি উপায় আছে। নিচে সহজভাবে ব্যাখ্যা করছি:
🧹 পদ্ধতি ১: Registry Editor ব্যবহার করে

Windows + R চাপুন, তারপর লিখুন regedit → Enter চাপুন।

নিচের লোকেশনটিতে যান:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\RunMRU

ডান পাশে আপনি Run-এ টাইপ করা পুরনো কমান্ডগুলোর লিস্ট (a, b, c... নামে) দেখতে পাবেন।
যেগুলো আপনি মুছে ফেলতে চান, সেগুলোর ওপর রাইট ক্লিক করে Delete দিন।

MRUList নামক ভ্যালুটি ডিলিট করবেন না।
কাজ শেষ হলে Regedit বন্ধ করে দিন।

USE safedelivery_courierdb;

TRUNCATE TABLE delivery_branch_transfers;
TRUNCATE TABLE delivery_branch_transfer_details;

TRUNCATE TABLE parcels;
TRUNCATE TABLE parcel_logs;
TRUNCATE TABLE parcel_delivery_payments;
TRUNCATE TABLE parcel_delivery_payment_details;
TRUNCATE TABLE parcel_merchant_delivery_payments;
TRUNCATE TABLE parcel_merchant_delivery_payment_details;

TRUNCATE TABLE parcel_payment_requests;
TRUNCATE TABLE parcel_pickup_requests;

TRUNCATE TABLE return_branch_transfers;
TRUNCATE TABLE return_branch_transfer_details;

TRUNCATE TABLE rider_payments;
TRUNCATE TABLE rider_runs;
TRUNCATE TABLE rider_run_details;

SELECT merchant_id, COUNT(*) AS occurrence_count
FROM merchant_service_area_return_charges
GROUP BY merchant_id
HAVING COUNT(*) > 3;

DELETE merchants, merchant_shops
FROM merchants
LEFT JOIN merchant_shops ON merchants.id = merchant_shops.merchant_id
WHERE merchants.m_id = 'M-0304';

DELETE m, ms
FROM merchants m
LEFT JOIN merchant_shops ms ON m.id = ms.merchant_id
WHERE m.m_id = 'M-0132';

DELETE ms, m FROM merchants m JOIN merchant_shops ms ON m.id = ms.merchant_id WHERE m.m_id ='M-0243';

UPDATE `parcels` SET `return_charge` = '0' WHERE `return_charge` != 0 AND `delivery_type` IN (1,2);

SET @time := NOW();

UPDATE merchants
SET created_at = (@time := DATE_ADD(@time, INTERVAL 1 SECOND))
ORDER BY id ASC;

UPDATE riders
SET contact_number = CONCAT('0', contact_number);

INSERT INTO merchant_shops (shop_name, shop_address, merchant_id, branch_id, district_id, area_id, contact_number, status, is_default, created_at, updated_at)
SELECT
    company_name, 
    address, 
    id AS merchant_id, 
    branch_id, 
    district_id, 
    area_id, 
    contact_number, 
    1 AS status, 
    1 AS is_default, 
    NOW() AS created_at, 
    NOW() AS updated_at
FROM merchants;

UPDATE parcels
SET parcel_code = FLOOR(1000 + RAND() * 8000)
WHERE status IN (14, 24);

SELECT * FROM parcel_merchant_delivery_payments WHERE total_payment_amount != 0 AND total_payment_received_amount = 0 AND status = 2

SELECT p.id
FROM parcels p
JOIN parcel_merchant_delivery_payment_details pd
    ON p.id = pd.parcel_id
WHERE p.merchant_id = 444
  AND p.payment_type != 5;

UPDATE rider_run_details
SET 
    complete_note = 'Out Of Coverage',
    collected_amount = 0,
    status = 7,
    delivery_type = 4
WHERE rider_run_id = 15071;

UPDATE `rider_run_details`
SET 
    `complete_note` = 'Out Of Coverage',
    `collected_amount` = 0,
    `status` = 7,
    `delivery_type` = 4
WHERE `rider_run_id` = 15071;

UPDATE `parcels` SET 
 `status` = '24'
 WHERE `parcel_invoice` IN (

);

UPDATE parcels
SET cod_charge = 0, cod_percent = 0
WHERE merchant_id = 345 AND cod_percent = 1;

ALTER TABLE merchant_shops CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

INSERT INTO merchant_shops (shop_name, shop_address, merchant_id, branch_id, district_id, area_id, contact_number, status, is_default, created_at, updated_at)
SELECT 
    company_name AS shop_name, 
    address AS shop_address, 
    id AS merchant_id, 
    branch_id, 
    district_id, 
    area_id, 
    contact_number, 
    1 AS status, 
    1 AS is_default,
    NOW() AS created_at,
    NOW() AS updated_at
FROM 
    merchants;

TRUNCATE TABLE easyfast_courierdb.delivery_branch_transfers;
TRUNCATE TABLE easyfast_courierdb.delivery_branch_transfer_details;

TRUNCATE TABLE easyfast_courierdb.parcels;
TRUNCATE TABLE easyfast_courierdb.parcel_logs;
TRUNCATE TABLE easyfast_courierdb.parcel_delivery_payments;
TRUNCATE TABLE easyfast_courierdb.parcel_delivery_payment_details;

TRUNCATE TABLE easyfast_courierdb.parcel_merchant_delivery_payments;
TRUNCATE TABLE easyfast_courierdb.parcel_merchant_delivery_payment_details;

TRUNCATE TABLE easyfast_courierdb.parcel_payment_requests;
TRUNCATE TABLE easyfast_courierdb.parcel_pickup_requests;


TRUNCATE TABLE easyfast_courierdb.pathao_orders;
TRUNCATE TABLE easyfast_courierdb.pathao_order_details;
TRUNCATE TABLE easyfast_courierdb.pathao_order_detail_logs;
TRUNCATE TABLE easyfast_courierdb.pathao_order_details;


TRUNCATE TABLE easyfast_courierdb.return_branch_transfers;
TRUNCATE TABLE easyfast_courierdb.return_branch_transfer_details;

TRUNCATE TABLE easyfast_courierdb.rider_payments;
TRUNCATE TABLE easyfast_courierdb.rider_runs;
TRUNCATE TABLE easyfast_courierdb.rider_run_details;






TRUNCATE TABLE easyfast_courierdb.branches;
TRUNCATE TABLE easyfast_courierdb.branch_users;

TRUNCATE TABLE easyfast_courierdb.branch_users;

TRUNCATE TABLE easyfast_courierdb.expenses;
TRUNCATE TABLE easyfast_courierdb.email_verifications;

TRUNCATE TABLE easyfast_courierdb.merchants;
TRUNCATE TABLE easyfast_courierdb.merchant_service_area_charges;
TRUNCATE TABLE easyfast_courierdb.merchant_service_area_cod_charges;
TRUNCATE TABLE easyfast_courierdb.merchant_service_area_return_charges;

TRUNCATE TABLE easyfast_courierdb.news_letters;
TRUNCATE TABLE easyfast_courierdb.notifications;

TRUNCATE TABLE easyfast_courierdb.riders;
TRUNCATE TABLE easyfast_courierdb.send_boxes;

TRUNCATE TABLE easyfast_courierdb.service_area_weight_package;
TRUNCATE TABLE easyfast_courierdb.staff;
TRUNCATE TABLE easyfast_courierdb.staff_payments;
TRUNCATE TABLE easyfast_courierdb.visitor_messages;

DELETE FROM `merchants` WHERE `id` NOT IN ( SELECT DISTINCT `merchant_id` FROM `parcels` WHERE `merchant_id` IS NOT NULL );