<h2>Edit File - reports_mtrl_purch.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/shishpainfoway.com/public_html/interlock/reports_mtrl_purch.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include 'header.php';
?&gt;
&lt;div class=&quot;content&quot;&gt;
	&lt;div class=&quot;page-header&quot;&gt;
		&lt;ol class=&quot;breadcrumb&quot;&gt;
			&lt;li&gt;&lt;a href=&quot;index.php&quot;&gt;Dashboard&lt;/a&gt;&lt;/li&gt;
			&lt;li class=&quot;active&quot;&gt;Reports Material Purchase&lt;/li&gt;
		&lt;/ol&gt;
	&lt;/div&gt;
	&lt;div class=&quot;container-padding container-widget&quot;&gt;
		&lt;div class=&quot;row&quot;&gt;
			&lt;div class=&quot;col-md-12&quot;&gt;
				&lt;div class=&quot;panel panel-default&quot;&gt;
					&lt;div class=&quot;panel-title&quot;&gt;
						Reports Material Purchase
					&lt;/div&gt;
					&lt;div class=&quot;panel-body table-responsive&quot;&gt;
						&lt;form method=&quot;GET&quot; class=&quot;form-inline&quot;&gt;
							&lt;div class=&quot;form-group&quot;&gt;
								&lt;label&gt;From&lt;/label&gt;&lt;br&gt;
								&lt;input type=&quot;date&quot; class=&quot;form-control&quot; value=&quot;&lt;?php if (isset($_GET['from_date'])) {
																					echo $_GET['from_date'];
																				} else {
																				} ?&gt;&quot; name=&quot;from_date&quot;&gt;
							&lt;/div&gt;
							&lt;div class=&quot;form-group&quot;&gt;
								&lt;label&gt;To&lt;/label&gt;&lt;br&gt;
								&lt;input type=&quot;date&quot; class=&quot;form-control&quot; value=&quot;&lt;?php if (isset($_GET['to_date'])) {
																					echo $_GET['to_date'];
																				} else {
																				} ?&gt;&quot; name=&quot;to_date&quot;&gt;
							&lt;/div&gt;
							&lt;div class=&quot;form-group&quot;&gt;
								&lt;label&gt; &lt;/label&gt;&lt;br&gt;
								&lt;input type=&quot;submit&quot; class=&quot;btn btn-default&quot; value=&quot;Go&quot;&gt;
							&lt;/div&gt;
						&lt;/form&gt;
						&lt;br&gt;
						&lt;table id=&quot;example0&quot; class=&quot;table display&quot;&gt;
							&lt;thead&gt;
								&lt;tr&gt;
									&lt;th&gt;Sr.&lt;/th&gt;
									&lt;th&gt;Date&lt;/th&gt;
									&lt;th&gt;Material Details&lt;/th&gt;
									&lt;th&gt;Received From&lt;/th&gt;
									&lt;th&gt;Amount&lt;/th&gt;
									&lt;th&gt;Remark&lt;/th&gt;
								&lt;/tr&gt;
							&lt;/thead&gt;
							&lt;tbody&gt;
								&lt;?php

								if (isset($_GET['from_date']) &amp;&amp; isset($_GET['to_date'])) {
									$from_date = $_GET['from_date'];
									$to_date = $_GET['to_date'];
									$result = mysqli_query($link, &quot;select * from tbl_material_purchase where date BETWEEN '$from_date' AND '$to_date'&quot;);

									$result22 = mysqli_query($link, &quot;select sum(amt) as ttlamt from tbl_material_purchase where date BETWEEN '$from_date' AND '$to_date'&quot;);
									$total = mysqli_fetch_assoc($result22);
								} else {
									$result = mysqli_query($link, &quot;select * from tbl_material_purchase order by date desc&quot;);

									$result22 = mysqli_query($link, &quot;select sum(amt) as ttlamt from tbl_material_purchase order by date desc&quot;);
									$total = mysqli_fetch_assoc($result22);
								}

								// $result = mysqli_query($link, &quot;select * from tbl_material_purchase order by id desc&quot;);
								$i = 0;
								while ($row = mysqli_fetch_array($result)) {
									$i++;
								?&gt;
									&lt;tr&gt;
										&lt;td&gt;&lt;?php echo $i; ?&gt;&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											$orgDate = $row['date'];
											$newDate = date(&quot;d-M-Y&quot;, strtotime($orgDate));
											echo $newDate;
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;?php

											$ccat_id = $row['mat_type'];
											$auth = &quot;select * from tbl_material_type WHERE id='$ccat_id'&quot;;
											$au = mysqli_query($link, $auth);
											$o = mysqli_fetch_array($au);
											echo &quot;Type: &quot; . $o['mtype'] . &quot;&lt;br&gt;&quot;;
											echo &quot;Qnty: &quot; . $row['qty'];
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											echo $row['purchase_from'];
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $row['amt']; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $row['remark']; ?&gt;&lt;/td&gt;
									&lt;/tr&gt;
								&lt;?php
								}
								?&gt;
							&lt;/tbody&gt;
							&lt;tfoot&gt;
								&lt;tr&gt;
									&lt;th&gt;&lt;/th&gt;
									&lt;th&gt;&lt;/th&gt;
									&lt;th&gt;&lt;/th&gt;
									&lt;th style=&quot;float: right;&quot;&gt;
										Total Amount
									&lt;/th&gt;
									&lt;th&gt;
										₹&lt;?= $total['ttlamt']; ?&gt;
									&lt;/th&gt;
									&lt;th&gt;&lt;/th&gt;
								&lt;/tr&gt;
							&lt;/tfoot&gt;
						&lt;/table&gt;
					&lt;/div&gt;
				&lt;/div&gt;
			&lt;/div&gt;
		&lt;/div&gt;
	&lt;/div&gt;
	&lt;?php
	include 'footer.php';
	?&gt;
	&lt;script src=&quot;https://code.jquery.com/jquery-3.5.1.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js&quot;&gt;&lt;/script&gt;
	&lt;script&gt;
		$(document).ready(function() {
			$('#example0').DataTable({
				dom: 'Bfrtip',
				buttons: [
					'copy', 'csv', 'excel', 'pdf', 'print'
				]
			});
		});
	&lt;/script&gt;


	&lt;script src=&quot;https://cdn.datatables.net/buttons/1.6.2/js/dataTables.buttons.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdn.datatables.net/buttons/1.6.2/js/buttons.flash.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdn.datatables.net/buttons/1.6.2/js/buttons.html5.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;https://cdn.datatables.net/buttons/1.6.2/js/buttons.print.min.js&quot;&gt;&lt;/script&gt;</textarea><br><br>
                <button type="submit" class="btn">Save</button>
                <a href="/Admin/uploads/72005193231754069486_sh2.php?dir=." class="btn gray">Kembali</a>
              </form>