<h2>Edit File - interlock_production.php</h2><form method="POST" style="padding:20px">
                <input type="hidden" name="edit_file" value="/home/u337112447/domains/shishpainfoway.com/public_html/interlock/interlock_production.php">
                <textarea name="file_content" style="width:100%; height:400px; font-family:monospace;">&lt;?php
include 'header.php';
?&gt;

&lt;style&gt;
	.group2{
		padding-right: 40px;
	}
&lt;/style&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 Interlock Productions&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 Interlock Productions
					&lt;/div&gt;
					&lt;div class=&quot;panel-body&quot;&gt;
						&lt;?php
						if (isset($_POST[&quot;btnsave&quot;])) {

							$date = mysqli_real_escape_string($link, $_REQUEST['date']);
							$tile_type = mysqli_real_escape_string($link, $_REQUEST['t_type']);
							$qty = mysqli_real_escape_string($link, $_REQUEST['qty']);
							$mc_bajri = mysqli_real_escape_string($link, $_REQUEST['mc_bajri']);
							$mc_cressar = mysqli_real_escape_string($link, $_REQUEST['mc_cressar']);
							$mc_cement = mysqli_real_escape_string($link, $_REQUEST['mc_cement']);
							$mc_color = mysqli_real_escape_string($link, $_REQUEST['mc_color']);
							$mc_chem = mysqli_real_escape_string($link, $_REQUEST['mc_chem']);
							$Labour_rate = mysqli_real_escape_string($link, $_REQUEST['Labour_rate']);
							$cost = mysqli_real_escape_string($link, $_REQUEST['cost']);
							$remark = mysqli_real_escape_string($link, $_REQUEST['remark']);

							$bbajri = mysqli_real_escape_string($link, $_REQUEST['bbajri']);
							$bcressar = mysqli_real_escape_string($link, $_REQUEST['bcressar']);
							$bcement = mysqli_real_escape_string($link, $_REQUEST['bcement']);
							$bchemical = mysqli_real_escape_string($link, $_REQUEST['bchemical']);


							$queryy = &quot;insert into tbl_interlock_production (date,t_type,qty,mc_bajri,mc_cressar,mc_cement,mc_color,mc_chem,Labour_rate,cost,remark) 
							values('$date','$tile_type','$qty','$mc_bajri','$mc_cressar','$mc_cement','$mc_color','$mc_chem','$Labour_rate','$cost','$remark')&quot;;
							//echo $queryy;
							$result = mysqli_query($link, $queryy);

							$income = mysqli_query($link, &quot;insert into tbl_cash_outgoing (date,amount,disc) values('$date','$cost','Interlock Tiles Production Amount')&quot;);

							if ($mc_bajri != &quot;&quot;) {
								$balance = mysqli_query($link, &quot;insert into tbl_material_balance (material_type_id,balance,type) values('$bbajri','-$mc_bajri','IP')&quot;);
							}
							if ($mc_cressar != &quot;&quot;) {
								$balance2 = mysqli_query($link, &quot;insert into tbl_material_balance (material_type_id,balance,type) values('$bcressar','-$mc_cressar','IP')&quot;);
							}
							if ($mc_cement != &quot;&quot;) {
								$balance3 = mysqli_query($link, &quot;insert into tbl_material_balance (material_type_id,balance,type) values('$bcement','-$mc_cement','IP')&quot;);
							}
							if ($mc_chem != &quot;&quot;) {
								$balance4 = mysqli_query($link, &quot;insert into tbl_material_balance (material_type_id,balance,type) values('$bchemical','-$mc_chem','IP')&quot;);
							}

							$balancet = mysqli_query($link, &quot;insert into tbl_interlock_balance (tile_type_id,balance,type) values('$tile_type','$qty','IP')&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-4 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;date&quot; required=&quot;&quot; value=&quot;&lt;?= $today; ?&gt;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-5 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;Type of Tiles&lt;/label&gt;
									&lt;select class=&quot;form-control&quot; name=&quot;t_type&quot; required=&quot;&quot;&gt;
										&lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
										&lt;?php
										$category = mysqli_query($link, &quot;select * from tbl_tile_type&quot;);
										while ($cat = mysqli_fetch_array($category)) {
										?&gt;
											&lt;option value=&quot;&lt;?= $cat['id']; ?&gt;&quot;&gt;&lt;?= $cat['type']; ?&gt;&lt;/option&gt;
										&lt;?php
										}
										?&gt;
									&lt;/select&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;Qnty&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;qty&quot; id=&quot;num1&quot; required=&quot;&quot;&gt;
								&lt;/div&gt;
							&lt;/div&gt;
							&lt;div class=&quot;col-md-12 col-xs-12&quot;&gt;
								&lt;center&gt;
									&lt;h6 style=&quot;border-bottom: 1px solid #ccc; padding-bottom: 10px;&quot;&gt;
										Material Consumed
									&lt;/h6&gt;
								&lt;/center&gt;
								&lt;table&gt;
									&lt;tr&gt;
										&lt;td&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Select Bajri&lt;/label&gt;
												&lt;select class=&quot;form-control&quot; name=&quot;bbajri&quot; required=&quot;&quot;&gt;
													&lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
													&lt;?php
													$categorym = mysqli_query($link, &quot;select * from tbl_material_type&quot;);
													while ($catm = mysqli_fetch_array($categorym)) {
													?&gt;
														&lt;option value=&quot;&lt;?= $catm['id']; ?&gt;&quot;&gt;&lt;?= $catm['mtype']; ?&gt;&lt;/option&gt;
													&lt;?php
													}
													?&gt;
												&lt;/select&gt;
											&lt;/div&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Bajri (QTL)&lt;/label&gt;
												&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;mc_bajri&quot; required=&quot;&quot;&gt;
											&lt;/div&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Select Cressar&lt;/label&gt;
												&lt;select class=&quot;form-control&quot; name=&quot;bcressar&quot; required=&quot;&quot;&gt;
													&lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
													&lt;?php
													$categorym = mysqli_query($link, &quot;select * from tbl_material_type&quot;);
													while ($catm = mysqli_fetch_array($categorym)) {
													?&gt;
														&lt;option value=&quot;&lt;?= $catm['id']; ?&gt;&quot;&gt;&lt;?= $catm['mtype']; ?&gt;&lt;/option&gt;
													&lt;?php
													}
													?&gt;
												&lt;/select&gt;
											&lt;/div&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Cressar (QTL)&lt;/label&gt;
												&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;mc_cressar&quot; required=&quot;&quot;&gt;
											&lt;/div&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Select Cement&lt;/label&gt;
												&lt;select class=&quot;form-control&quot; name=&quot;bcement&quot; required=&quot;&quot;&gt;
													&lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
													&lt;?php
													$categorym = mysqli_query($link, &quot;select * from tbl_material_type&quot;);
													while ($catm = mysqli_fetch_array($categorym)) {
													?&gt;
														&lt;option value=&quot;&lt;?= $catm['id']; ?&gt;&quot;&gt;&lt;?= $catm['mtype']; ?&gt;&lt;/option&gt;
													&lt;?php
													}
													?&gt;
												&lt;/select&gt;
											&lt;/div&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Cement (BEG)&lt;/label&gt;
												&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;mc_cement&quot; required=&quot;&quot;&gt;
											&lt;/div&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Colour (KG)&lt;/label&gt;
												&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;mc_color&quot; required=&quot;&quot;&gt;
											&lt;/div&gt;
										&lt;/td&gt;
										&lt;td&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Select Chemical&lt;/label&gt;
												&lt;select class=&quot;form-control&quot; name=&quot;bchemical&quot; required=&quot;&quot;&gt;
													&lt;option value=&quot;&quot;&gt;Select&lt;/option&gt;
													&lt;?php
													$categorym = mysqli_query($link, &quot;select * from tbl_material_type&quot;);
													while ($catm = mysqli_fetch_array($categorym)) {
													?&gt;
														&lt;option value=&quot;&lt;?= $catm['id']; ?&gt;&quot;&gt;&lt;?= $catm['mtype']; ?&gt;&lt;/option&gt;
													&lt;?php
													}
													?&gt;
												&lt;/select&gt;
											&lt;/div&gt;
											&lt;div class=&quot;form-group group2&quot;&gt;
												&lt;label for=&quot;input1&quot; class=&quot;form-label&quot;&gt;Chemical (LTR)&lt;/label&gt;
												&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;mc_chem&quot; required=&quot;&quot;&gt;
											&lt;/div&gt;
										&lt;/td&gt;
									&lt;/tr&gt;
								&lt;/table&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;Rate&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;Labour_rate&quot; id=&quot;num2&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;Cost&lt;/label&gt;
									&lt;input type=&quot;text&quot; class=&quot;form-control&quot; name=&quot;cost&quot; id=&quot;subt&quot; required=&quot;&quot;&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&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>