未签劳动合同赔偿计算方法及相关信息
未签劳动合同赔偿计算方法及相关信息
根据相关法律规定,如果用人单位没有与员工签订劳动合同,则需要向员工支付双倍工资,具体计算方法如下:
赔偿金额 = 员工月工资 × 2 × 工作时间
其中,工作时间是指员工实际工作的时间,单位为月。
以下为计算未签劳动合同赔偿涉及的相关信息的获取方法:
1. 获取未签劳动合同的赔偿
public function get_compensation($user_id) {
global $db;
$re_row = $this->get_resign_info($user_id);
$compensation = 0;
//获取最后一次的离职信息
if ($re_row['have_contract'] == 0) {
$compensation += $re_row['total_compensation'];
}
//获取交通补贴
$traffic_sql = "select * from t_traffic_subsidy_info where user_id = $user_id and review_status=2 and is_deleted=0";
$traffic_res = $db->get_all($traffic_sql);
if (!empty($traffic_res)) {
foreach ($traffic_res as $val) {
$compensation += $val['compensation'];
}
}
//住宿补贴
$live_sql = "select * from t_live_subsidy_info where user_id = $user_id and review_status=2 and is_deleted=0";
$live_res = $db->get_all($live_sql);
if (!empty($live_res)) {
foreach ($live_res as $val) {
$compensation += $val['compensation'];
}
}
$array[] = $compensation;
$array[] = $re_row['total_compensation'] - $compensation;
return $array;
}
2. 获取工资信息
//获取工资信息
public function get_salary_info($user_id) {
global $db;
//获取最新的离职信息
$sql_str = "select * from t_resign where user_id = $user_id and is_submit = 1 and is_deleted = 0 order by resign_time desc limit 1";
$res_row = $db->get_row($sql_str);
if (!empty($res_row)) {
//获取最后一次发放的工资
$end_time = $res_row['resign_time'];
$sql_str = "select * from t_salary_send_log where user_id = $user_id and is_deleted = 0 and send_time <= '$end_time' order by send_time desc limit 1";
$row = $db->get_row($sql_str);
if (!empty($row)) {
$row['base_salary'] = $row['base_salary'] - $row['total_deduct_money'];
$row['total_salary'] = $row['total_salary'] - $row['total_deduct_money'];
}
return $row;
} else {
return array();
}
}
3. 获取绩效
//获取绩效
public function get_performance($user_id, $resign_time) {
global $db;
//获取最新的离职信息
$sql_str = "select * from t_performance_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
4. 获取津贴
//获取津贴
public function get_allowance($user_id, $resign_time) {
global $db;
//获取最新的离职信息
$sql_str = "select * from t_allowance_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
5. 获取奖金
//获取奖金
public function get_bonus($user_id, $resign_time) {
global $db;
//获取最新的离职信息
$sql_str = "select * from t_bonus_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
6. 获取社保信息
//获取社保信息
public function get_insurance_info($user_id) {
global $db;
$sql_str = "select * from t_insurance_log where user_id = $user_id and is_deleted = 0 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
7. 获取公积金信息
//获取公积金信息
public function get_fund_info($user_id) {
global $db;
$sql_str = "select * from t_fund_log where user_id = $user_id and is_deleted = 0 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
8. 获取报销信息
//获取报销信息
public function get_reimbursement_info($user_id, $resign_time) {
global $db;
$sql_str = "select * from t_reimbursement_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 and is_checked = 1 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
9. 获取事假信息
//获取事假信息
public function get_leave_info($user_id, $resign_time) {
global $db;
$sql_str = "select * from t_leave_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 and is_checked = 1 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
10. 获取出差信息
//获取出差信息
public function get_travel_info($user_id, $resign_time) {
global $db;
$sql_str = "select * from t_travel_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 and is_checked = 1 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
11. 获取加班信息
//获取加班信息
public function get_overtime_info($user_id, $resign_time) {
global $db;
$sql_str = "select * from t_overtime_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 and is_checked = 1 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
12. 获取补发信息
//获取补发信息
public function get_refund_info($user_id, $resign_time) {
global $db;
$sql_str = "select * from t_refund_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 and is_checked = 1 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
13. 获取考勤
//获取考勤
public function get_attendance_info($user_id, $resign_time) {
global $db;
$sql_str = "select * from t_attendance_log where user_id = $user_id and check_date <= '$resign_time' and is_deleted = 0 order by check_date desc limit 1";
$row = $db->get_row($sql_str);
return $row;
}
注意:
- 以上代码仅供参考,实际应用中可能需要根据具体情况进行调整。
- 建议员工在未签劳动合同的情况下,保留好相关的证据,例如工资条、工作证明等,以便在维权时提供证据。
- 如果与用人单位协商不成,可以向劳动仲裁委员会申请仲裁。
原文地址: https://www.cveoy.top/t/topic/lgRF 著作权归作者所有。请勿转载和采集!