<h2>Edit File - add_dharamkanta.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/shishpainfoway.com/public_html/interlock/add_dharamkanta.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;Add Dharam Kanta Record&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;
						Add Dharam Kanta Record
					&lt;/div&gt;
					&lt;div class=&quot;panel-body&quot;&gt;
						&lt;?php
						if (isset($_POST[&quot;btnsave&quot;])) {

							$daten = mysqli_real_escape_string($link, $_REQUEST['daten']);
							$rstno = mysqli_real_escape_string($link, $_REQUEST['rstno']);
							$vehno = mysqli_real_escape_string($link, $_REQUEST['vehno']);
							$vehtype = mysqli_real_escape_string($link, $_REQUEST['vehtype']);
							$mtrl = mysqli_real_escape_string($link, $_REQUEST['mtrl']);
							$gwet = mysqli_real_escape_string($link, $_REQUEST['gwet']);
							$twet = mysqli_real_escape_string($link, $_REQUEST['twet']);
							$nwet = mysqli_real_escape_string($link, $_REQUEST['nwet']);
							$name = mysqli_real_escape_string($link, $_REQUEST['name']);
							$phone = mysqli_real_escape_string($link, $_REQUEST['phone']);
							$price = mysqli_real_escape_string($link, $_REQUEST['price']);
							$ptype = mysqli_real_escape_string($link, $_REQUEST['ptype']);
							$remark = mysqli_real_escape_string($link, $_REQUEST['remark']);

							$queryy = &quot;insert into tbl_dharamkanta (date,rstno,vehno,vehtype,mtrl,gwet,twet,nwet,name,phone,price,ptype,remark) values('$daten','$rstno','$vehno','$vehtype','$mtrl','$gwet','$twet','$nwet','$name','$phone','$price','$ptype','$remark')&quot;;
							//echo $queryy;
							$result = mysqli_query($link, $queryy);
							if($ptype==&quot;1&quot;){
								$income = mysqli_query($link, &quot;insert into tbl_cash_income (date,amount,disc) values('$daten','$price','Dharam Kanta 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;Data Added successfully.&lt;/div&gt;
							&lt;?php
							} 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;form method=&quot;post&quot; enctype=&quot;multipart/form-data&quot;&gt;
							&lt;div class=&quot;col-md-3 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Date&lt;/label&gt;
									&lt;input type=&quot;date&quot; class=&quot;form-control&quot; name=&quot;daten&quot; required=&quot;&quot; value=&quot;&lt;?= $today; ?&gt;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-3 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;RST No.&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;rstno&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-3 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Vehicle No.&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;vehno&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-3 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Vehicle Type&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;vehtype&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-3 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Material&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;mtrl&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-2 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;G Weight&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;gwet&quot; id=&quot;num2&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-2 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Tier Weight&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;twet&quot; id=&quot;num1&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-2 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Net Weight&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;nwet&quot; id=&quot;subt&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-3 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Name&lt;/label&gt;
									&lt;input type=&quot;tel&quot; class=&quot;form-control&quot; name=&quot;name&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-2 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Mobile No.&lt;/label&gt;
									&lt;input type=&quot;tel&quot; class=&quot;form-control&quot; name=&quot;phone&quot; required=&quot;&quot; maxlengh=&quot;10&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-2 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Price&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;price&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-2 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Paid/Unpaid&lt;/label&gt;
									&lt;select class=&quot;form-control&quot; name=&quot;ptype&quot; required=&quot;&quot;&gt;
										&lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
										&lt;option value=&quot;1&quot;&gt;Paid&lt;/option&gt;
										&lt;option value=&quot;0&quot;&gt;Unpaid&lt;/option&gt;
									&lt;/select&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-6 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Remark&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;remark&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
								&lt;div class=&quot;form-group&quot;&gt;
									&lt;input type=&quot;submit&quot; class=&quot;btn btn-default&quot; name=&quot;btnsave&quot; value=&quot;Save&quot; style=&quot;width: 100%;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/form&gt;
					&lt;/div&gt;
				&lt;/div&gt;
			&lt;/div&gt;

			&lt;div class=&quot;col-md-12&quot;&gt;
				&lt;div class=&quot;panel panel-default&quot;&gt;
					&lt;?php
					if (isset($_POST[&quot;updatess&quot;])) {
						$bill = $_POST['id'];
						$oprice = $_POST['price'];
						$sqll = &quot;UPDATE tbl_dharamkanta SET ptype='1' 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','Dharam Kanta 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;Recieved 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;?php
					if (isset($_POST[&quot;delete&quot;])) {
						$bill = $_POST['id'];
						$sql = &quot;DELETE FROM tbl_dharamkanta WHERE id=$bill&quot;;
						$result = mysqli_query($link, $sql);
						if (mysqli_affected_rows($link)) {
							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-title&quot;&gt;
					Recently Dharam Kanta Record
					&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;RST No.&lt;/th&gt;
									&lt;th&gt;Vehicle Details&lt;/th&gt;
									&lt;th&gt;MTRL&lt;/th&gt;
									&lt;th&gt;Weight&lt;/th&gt;
									&lt;th&gt;Name &amp; Phone&lt;/th&gt;
									&lt;th&gt;Price&lt;/th&gt;
									&lt;th&gt;Remark&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_dharamkanta 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 echo $row['rstno']; ?&gt;&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											echo &quot;No.: &quot; . $row['vehno'] . &quot;&lt;br&gt;&quot;;
											echo &quot;Type: &quot; . $row['vehtype'];
											?&gt;
										&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $row['mtrl']; ?&gt;&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											echo &quot;GWET: &quot; . $row['gwet'] . &quot;&lt;br&gt;&quot;;
											echo &quot;TWET: &quot; . $row['twet'] . &quot;&lt;br&gt;&quot;;
											echo &quot;NWET: &quot; . $row['nwet'];
											?&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 echo $row['price']; ?&gt;&lt;br&gt;
										&lt;?php
										if($row['ptype']==&quot;0&quot;){
											echo &quot;Unpaid&quot;;
										}else{
											echo &quot;Paid&quot;;
										}
										?&gt;
										&lt;/td&gt;
										&lt;td&gt;&lt;?php echo $row['remark']; ?&gt;&lt;/td&gt;
										&lt;td&gt;
											&lt;?php
											if ($row['ptype'] == &quot;0&quot;) {
											?&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;button data-toggle=&quot;modal&quot; data-target=&quot;#delete&lt;?= $row['id']; ?&gt;&quot; class=&quot;btn btn-danger btn-xs&quot;&gt;Delete&lt;/button&gt;
											&lt;?php
											} else {
											?&gt;
												&lt;a class=&quot;btn btn-icon btn-xs btn-success mr-1&quot;&gt;
													Paid
												&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['price']; ?&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['price']; ?&gt;&quot; name=&quot;price&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;Received&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;div class=&quot;modal fade modalbox&quot; id=&quot;delete&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;Delete Data&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;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;delete&quot; value=&quot;Delete&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;/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;

	&lt;script&gt;
		$(document).ready(function() {
			//this calculates values automatically 
			sum();
			$(&quot;#num1, #num2&quot;).on(&quot;keydown keyup&quot;, function() {
				sum();
			});
		});

		function sum() {
			var num1 = document.getElementById('num1').value;
			var num2 = document.getElementById('num2').value;
			var result1 = num2 - num1;
			if (!isNaN(result1)) {
				document.getElementById('subt').value = result1.toFixed(2);
			}
		}
	&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>