<?php

include "../root.class.php";

$db = new db_safeguard();
$users_res = $db->query("users", "SELECT * FROM users WHERE 1");
while ($user = $users_res->fetch_assoc()) {
    $leave_days_rate = $user['leave_days_rate'];
    // insert the amount into table
    $db->query("leavedays_trans", "INSERT INTO `leavedays_trans`(`type`, `amount`, `user_id`, `date`, `start_date`, `to_date`, `status`) VALUES ('LEAVE','$leave_days_rate','{$user['record_id']}','" . date("Y-m-d") . "','','','1')");
}