<h2>Editing File: /home/nudhamca/client.nudhamcapital.co.uk/dashboard/statement.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
session_start();
include_once ('../include/session.php');
require_once '../include/class.user.php';
if (!isset($_SESSION['acc_no'])) {
    header(&quot;Location: login.php&quot;);
    exit();
}


$reg_user = new USER();

$stmt = $reg_user-&gt;runQuery(&quot;SELECT * FROM account WHERE acc_no=:acc_no&quot;);
$stmt-&gt;execute(array(&quot;:acc_no&quot; =&gt; $_SESSION['acc_no']));
$row = $stmt-&gt;fetch(PDO::FETCH_ASSOC);


$email = $row['email'];

$temp = $reg_user-&gt;runQuery(&quot;SELECT * FROM transfer WHERE email = '$email' &quot;);
$temp-&gt;execute(array(&quot;:acc_no&quot; =&gt; $_SESSION['acc_no']));
$rows = $temp-&gt;fetch(PDO::FETCH_ASSOC);


?&gt;
&lt;?php include 'mheader.php';
?&gt;

&lt;title&gt;Account Statement&lt;/title&gt;


&lt;!-- content @s --&gt;&lt;br&gt;&lt;br&gt;
&lt;script&gt;function printtag(tagid) {
            var hashid = &quot;#&quot;+ tagid;
            var tagname =  $(hashid).prop(&quot;tagName&quot;).toLowerCase() ;
            var attributes = &quot;&quot;; 
            var attrs = document.getElementById(tagid).attributes;
              $.each(attrs,function(i,elem){
                attributes +=  &quot; &quot;+  elem.name+&quot; ='&quot;+elem.value+&quot;' &quot; ;
              })
            var divToPrint= $(hashid).html() ;
            var head = &quot;&lt;html&gt;&lt;head&gt;&quot;+ $(&quot;head&quot;).html() + &quot;&lt;/head&gt;&quot; ;
            var allcontent = head + &quot;&lt;body  onload='window.print()' &gt;&quot;+ &quot;&lt;&quot; + tagname + attributes + &quot;&gt;&quot; +  divToPrint + &quot;&lt;/&quot; + tagname + &quot;&gt;&quot; +  &quot;&lt;/body&gt;&lt;/html&gt;&quot;  ;
            var newWin=window.open('','Print-Window');
            newWin.document.open();
            newWin.document.write(allcontent);
            newWin.document.close();
           // setTimeout(function(){newWin.close();},10);
        }&lt;/script&gt;
&lt;div id='DivIdToPrint'&gt; 
                    &lt;div id=&quot;dvContainer&quot;&gt;
                &lt;div class=&quot;nk-content nk-content-fluid&quot;&gt;
                    &lt;div class=&quot;container-xl wide-lg&quot;&gt;
                        &lt;div class=&quot;nk-content-body&quot;&gt;
                            &lt;div class=&quot;nk-block-head nk-block-head-sm&quot;&gt;
                                &lt;div class=&quot;nk-block-between&quot;&gt;
                                    &lt;div class=&quot;nk-block-head-content&quot;&gt;
                                        &lt;h3 class=&quot;nk-block-title page-title&quot;&gt;Account Statement&lt;/h3&gt;
                                        
                                    &lt;/div&gt;&lt;!-- .nk-block-head-content --&gt;
                                    &lt;div class=&quot;nk-block-head-content&quot;&gt;
                                        &lt;div class=&quot;toggle-wrap nk-block-tools-toggle&quot;&gt;
                                            &lt;a href=&quot;#&quot; class=&quot;btn btn-icon btn-trigger toggle-expand mr-n1&quot; data-target=&quot;pageMenu&quot;&gt;&lt;em class=&quot;icon ni ni-menu-alt-r&quot;&gt;&lt;/em&gt;&lt;/a&gt;
                                            &lt;div class=&quot;toggle-expand-content&quot; data-content=&quot;pageMenu&quot;&gt;
                                                &lt;ul class=&quot;nk-block-tools g-3&quot;&gt;
                                                    &lt;li&gt;&lt;button type=&quot;button&quot; onclick='printtag(&quot;DivIdToPrint&quot;);' id='btn' class=&quot;btn btn-white btn-outline-light&quot;&gt;&lt;em class=&quot;icon ni ni-download-cloud&quot;&gt;&lt;/em&gt;&lt;span&gt;Export&lt;/span&gt;&lt;/button&gt;&lt;/li&gt;
                                                   
                                                &lt;/ul&gt;
                                            &lt;/div&gt;
                                        &lt;/div&gt;&lt;!-- .toggle-wrap --&gt;
                                    &lt;/div&gt;&lt;!-- .nk-block-head-content --&gt;
                                &lt;/div&gt;&lt;!-- .nk-block-between --&gt;
                            &lt;/div&gt;&lt;!-- .nk-block-head --&gt;
                                &lt;div class=&quot;nk-block nk-block-lg&quot;&gt;
                                    &lt;div class=&quot;nk-block-head&quot;&gt;
                                        &lt;div class=&quot;nk-block-head-content&quot;&gt;
                                            &lt;h4 class=&quot;nk-block-title&quot;&gt;Transactions&lt;/h4&gt;
                                            
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;card card-preview&quot;&gt;
                                        &lt;div class=&quot;card-inner&quot;&gt;
                                            &lt;table class=&quot;datatable-init-export nowrap table&quot; data-export-title=&quot;Export&quot;&gt;
                                                &lt;thead&gt;
                                                    &lt;tr&gt;
						&lt;th class=&quot;no-sort&quot; style=&quot;width:1%&quot;&gt;#&lt;/th&gt;
						
						&lt;th style=&quot;white-space: nowrap&quot;&gt;AMOUNT&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;RECIEVING ACCOUNT AND NAME&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;TYPE&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;BANK&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;DESCRIPTION&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;DATE/TIME&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;STATUS&lt;/th&gt;
						
					&lt;/tr&gt;
				&lt;/thead&gt;
				&lt;tbody&gt;
				&lt;?php 
				$acc_no = $_SESSION['acc_no'];
				$email = $row['email'];
				$his = $reg_user-&gt;runQuery(&quot;SELECT * FROM transfer WHERE email = '$email'&quot;);
				$his-&gt;execute(array(&quot;:acc_no&quot;=&gt;$_SESSION['acc_no']));
				while($rows = $his-&gt;fetch(PDO::FETCH_ASSOC)){?&gt;
					&lt;tr&gt;
						&lt;td&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $row['currency']; ?&gt; &lt;?php echo $rows['amount']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['acc_no']; ?&gt; - &lt;?php echo $rows['acc_name']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['transtype']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['bank_name']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['remarks']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['date']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['status']; ?&gt;&lt;/td&gt;
						
					&lt;/tr&gt;
				&lt;?php } ?&gt;
				&lt;/tbody&gt;
			&lt;/table&gt;
        &lt;/div&gt;
                                    &lt;/div&gt;&lt;!-- .card-preview --&gt;
                                &lt;/div&gt; &lt;!-- nk-block --&gt;    
    &lt;div class=&quot;nk-block nk-block-lg&quot;&gt;
                                    &lt;div class=&quot;nk-block-head&quot;&gt;
                                        &lt;div class=&quot;nk-block-head-content&quot;&gt;
                                            
                                        &lt;/div&gt;
                                    &lt;/div&gt;
                                    &lt;div class=&quot;card card-preview&quot;&gt;
                                        &lt;div class=&quot;card-inner&quot;&gt;
                                            &lt;table class=&quot;datatable-init-export nowrap table&quot; data-export-title=&quot;Export&quot;&gt;
                                                &lt;thead&gt;        
                                &lt;tr&gt;
						&lt;th class=&quot;no-sort&quot; style=&quot;width:1%&quot;&gt;Ref No.&lt;/th&gt;
						
						&lt;th style=&quot;white-space: nowrap&quot;&gt;TYPE&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;AMOUNT &lt;b&gt;(&lt;?php echo $row['currency']; ?&gt;)&lt;/b&gt;&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;TO/FROM&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;DESCRIPTION&lt;/th&gt;
						&lt;th style=&quot;white-space: nowrap&quot;&gt;DATE/TIME&lt;/th&gt;
						
						
					&lt;/tr&gt;
				&lt;/thead&gt;
				&lt;tbody&gt;
				&lt;?php 
				$uname = $_SESSION['acc_no'];
				$debcre = $reg_user-&gt;runQuery(&quot;SELECT * FROM alerts WHERE uname = '$uname'&quot;);
				$debcre-&gt;execute();
				while($rows = $debcre-&gt;fetch(PDO::FETCH_ASSOC)){?&gt;
					&lt;tr&gt;
						&lt;td&gt;&lt;?php echo $rows['id']; ?&gt;
                              &lt;/td&gt;
						&lt;td&gt;&lt;?php include('ss.php');  ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['amount']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['sender_name']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['remarks']; ?&gt;&lt;/td&gt;
						&lt;td&gt;&lt;?php echo $rows['date']; ?&gt; &amp;nbsp;&lt;?php echo $rows['time']; ?&gt;&lt;/td&gt;
						
						
					&lt;/tr&gt;
				&lt;?php } ?&gt;
				&lt;/tbody&gt;
			&lt;/table&gt;
			&lt;!-- END table --&gt;
	&lt;/div&gt;
                                    &lt;/div&gt;&lt;!-- .card-preview --&gt;
                                &lt;/div&gt; &lt;!-- nk-block --&gt; 
      &lt;/div&gt;
                                &lt;/div&gt;&lt;/div&gt;
                                &lt;/div&gt; &lt;/div&gt;
                                &lt;/div&gt;                          
   &lt;?php include 'mfooter.php';
?&gt;                             </textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fhome%2Fnudhamca%2Fclient.nudhamcapital.co.uk%2Fdashboard'>Back to Directory</a>