Library-management/ADreturn.php at master · jaytorasakar8/Library-management · 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

<?php
	include 'conn.php';

	$claim_return_id=$_GET['claim_return_id'];
	$result=$mysqli->query("SELECT * FROM claimreturn where claim_return_id='$claim_return_id'");


	while ($row=$result->fetch_array())
	{
	$issue_id=$row['Issue_id'];
	$mid=$row['Mid'];
	$name=$row['Name'];
	$bid=$row['Bid'];
	$bname=$row['Bname'];
	$validreturndate=$row['validreturndate'];
	$validreturndate1=new DateTime($row['validreturndate']);
		$returndate=new DateTime(date('Y-m-d'));
		$diff=date_diff($returndate,$validreturndate1);
		$days=$diff->d;
	//insert requestclaim record into return table
	$sql=$mysqli->query("INSERT INTO returnbook(Issue_id,claim_return_id,Mid,Name,Bid,Bname,validreturndate,Return_date,diff)
	   VALUES('$issue_id','$claim_return_id','$mid','$name','$bid','$bname','$validreturndate',now(),'$days')");

	$result=$mysqli->query($sql);

     }


	$sql2=$mysqli->query("update member set Book1=NULL where Mid='$mid'");

	$sql3=$mysqli->query("DELETE FROM claimreturn WHERE claim_return_id='$claim_return_id'");

	$sql4=$mysqli->query("update book set Availability='yes' where Bid='$bid'");
//inser into return store


$result=$mysqli->query("SELECT * FROM returnbook where claim_return_id='$claim_return_id'");
	while ($row=$result->fetch_array())
	{
    $return_id=$row['Return_id'];
	$issue_id=$row['Issue_id'];
	$mid=$row['Mid'];
	$name=$row['Name'];
	$bid=$row['Bid'];
	$bname=$row['Bname'];
	$validreturndate=$row['validreturndate'];
    $returndate=$row['Return_date'];

	$sql=$mysqli->query("INSERT INTO returnstore(Return_id,Issue_id,Bid,Bname,Mid,Name,validreturndate,Return_date,diff)
	   VALUES('$return_id','$issue_id','$bid','$bname','$mid','$name','$validreturndate',now(),'$days')");

	$result=$mysqli->_query($sql);

     }


//delete returnclaim record	 and return record
$sql1=$mysqli->query("DELETE FROM claimreturn WHERE claim_return_id='$claim_return_id'");
    $result1=$mysqli->query($sql1);

$sql1=$mysqli->query("DELETE FROM returnbook WHERE claim_return_id='$claim_return_id'");
    $result1$mysqli->query($sql1);

$sql1=$mysqli->query("DELETE FROM issuebook WHERE Issue_id='$issue_id'");
    $result1=$mysqli->query($sql1);

	//create fine record


	header ('location:admin.php');


?>