OnliveLeavePortal/test3.php at master · AdarshKC/OnliveLeavePortal · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
<?php
session_start();
error_reporting(0);
include_once('../includes/config.php');

$sql1="SELECT * FROM tblemployees";
$query = $dbh -> prepare($sql1);
$query->execute();
$empl=$query->fetchAll(PDO::FETCH_OBJ);

//print_r ($empl);
//echo $query->rowCount();

$sql2="SELECT * FROM tblleavetype ";
$query = $dbh -> prepare($sql2);
$query->execute();
$leave=$query->fetchAll(PDO::FETCH_OBJ);

//echo $query->rowCount();
//print_r ($leave);

// Some error in code!!!
$emp_id = "";
$leave_id = "";

// $sql3="SELECT * FROM tblleaves WHERE LeaveType=:l AND empid=:e AND Status=1";
// $query = $dbh -> prepare($sql3);
// $query->bindParam(':e', $emp_id, PDO::PARAM_INT);
// $query->bindParam(':l', $LeaveType, PDO::PARAM_STR);

foreach($leave as $i) {
	foreach($empl as $j) {
		$emp_id = $j->id;
		$leave_id = $i->id;
		$LeaveType = $i->LeaveType;
		$unique_id = (string)$leave_id."_".$emp_id;
		$accumulates = $i->accumulates;
		$totl_avl_year = $i->totl_avl_year;
		$distributed = $i->dIstributed;
		$include_weekends = $i->include_weekends;
		$total_consec = $i->total_consec;

		//echo $emp_id." ".$leave_id." ".$unique_id." ".$accumulates."<br><br>";
		// Calculating leaves_taken for current session...
		$leaves_taken = 0;
		// $query->execute();
		// $taken=$query->fetchAll(PDO::FETCH_OBJ);
		// if($query->rowCount()) {
		// 	foreach ($taken as $k) {
		// 		//echo "is<br>";
		// 		$leaves_taken+=$k->count;
		// 	}
		// }
		$left_days = ($totl_avl_year)-($leaves_taken);
		//echo $i->totl_avl_year.$totl_avl_year."<br>";
		//print_r ($taken);
		//echo "<br>";

		$sql="INSERT INTO leave_left(`emp_id`, `leave_id`, `LeaveType`, `leaves_taken`, `left_days`, `unique_id`, `accumulates`, `distributed`, `totl_avl_year`, `include_weekends`, `total_consec`) VALUES (:emp_id, :leave_id, :LeaveType, :leaves_taken, :left_days, :unique_id, :accumulates, :distributed, :totl_avl_year, :include_weekends, :total_consec)";

		// $sql="INSERT INTO leave_left(`emp_id`, `leave_id`, `LeaveType`, `leaves_taken`, `left_days`, `unique_id`, `accumulates`, `distributed`, `totl_avl_year`, `include_weekends`, `total_consec`) VALUES (". $emp_id .", ". $leave_id .", '". $LeaveType ."', ". $leaves_taken .", ". $left_days .", '". $unique_id ."', ". $accumulates .", ". $distributed .", ". $totl_avl_year .", ". $include_weekends .", ". $total_consec .")";

		$query = $dbh->prepare($sql);
		$query->bindParam(':emp_id', $emp_id, PDO::PARAM_INT);
		$query->bindParam(':leave_id', $leave_id, PDO::PARAM_INT);
		$query->bindParam(':unique_id', $unique_id, PDO::PARAM_STR);
		$query->bindParam(':accumulates', $accumulates, PDO::PARAM_INT);
		$query->bindParam(':leaves_taken',$leaves_taken, PDO::PARAM_INT);
		$query->bindParam(':left_days',$left_days, PDO::PARAM_INT);
		$query->bindParam(':LeaveType',$LeaveType, PDO::PARAM_STR);
		$query->bindParam(':totl_avl_year',$totl_avl_year, PDO::PARAM_INT);
		$query->bindParam(':distributed',$distributed, PDO::PARAM_INT);
		$query->bindParam(':include_weekends',$include_weekends, PDO::PARAM_INT);
		$query->bindParam(':total_consec',$total_consec, PDO::PARAM_INT);
		$query->execute();
		//echo $dbh->errorCode();

		//print_r($dbh->errorInfo());
		//var_dump($query->queryString());

		//print_r($query->fetchAll(PDO::FETCH_OBJ));

		echo $emp_id.", ".$leave_id.", ".$unique_id.", ".$accumulates.", ".$leaves_taken.", ".$left_days.", ".$LeaveType.", ".$distributed.", ".$totl_avl_year.", ". $include_weekends ." ". $total_consec. "<br>";
	}
}
?>