<h2>Edit File - reports_mtrl_sale.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_sale.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 sale&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 sale
					&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;Mat Details&lt;/th&gt;
									&lt;th&gt;Customer Details&lt;/th&gt;
									&lt;th&gt;Price&lt;/th&gt;
									&lt;th&gt;REC&lt;/th&gt;
									&lt;th&gt;BAL&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_sale where date BETWEEN '$from_date' AND '$to_date'&quot;);

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

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

								// $result = mysqli_query($link, &quot;select * from tbl_material_sale 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
											$int_id = $row['id'];
											$result_items = mysqli_query($link, &quot;select * from tbl_mat_sale_items where msale_id='$int_id'&quot;);
											while ($item = mysqli_fetch_array($result_items)) {
												$tileid = $item['mat_type'];
												$sel = mysqli_query($link, &quot;SELECT * FROM tbl_material_type WHERE id='$tileid'&quot;);
												$pdf = mysqli_fetch_array($sel);
												$ssname = $pdf['mtype'];
											?&gt;
												&lt;?= 'Type: ' . $ssname . '&lt;br&gt;'; ?&gt;
												&lt;?= 'QTY: ' . $item['qty'] . '&lt;br&gt;'; ?&gt;
												&lt;?= 'Rate: ' . $item['rate']; ?&gt;
											&lt;?php
											}
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											echo &quot;Name: &quot; . $row['name'] . &quot;&lt;br&gt;&quot;;
											echo &quot;Phone: &quot; . $row['phone'];
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											if ($row['bill_gst'] == &quot;1&quot;) {
												echo $row['amt_with_gst'];
											} else {
												echo $row['ttlamt'];
											}
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $row['rec']; ?&gt;&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $row['bal']; ?&gt;&lt;/td&gt;

									&lt;/tr&gt;
								&lt;?php
								}
								?&gt;
							&lt;/tbody&gt;
							&lt;tfoot&gt;
								&lt;tr&gt;
									&lt;td&gt;&lt;/td&gt;
									&lt;td&gt;&lt;/td&gt;
									&lt;td&gt;&lt;/td&gt;
									&lt;td&gt;Total:&lt;/td&gt;
									&lt;td&gt;&lt;/td&gt;
									&lt;td&gt;&lt;/td&gt;
									&lt;td&gt;&lt;/td&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() {
			// DataTable initialisation
			$('#example0').DataTable({
				dom: 'Bfrtip',
				buttons: [
					'copy', 'csv', 'excel', 'pdf', 'print'
				],
				&quot;paging&quot;: false,
				&quot;autoWidth&quot;: true,
				&quot;footerCallback&quot;: function(row, data, start, end, display) {
					var api = this.api();
					nb_cols = api.columns().nodes().length;
					var j = 4;
					while (j &lt; nb_cols) {
						var pageTotal = api
							.column(j, {
								page: 'current'
							})
							.data()
							.reduce(function(a, b) {
								return Number(a) + Number(b);
							}, 0);
						// Update footer
						$(api.column(j).footer()).html(pageTotal);
						j++;
					}
				}
			});
		});
	&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>