<h2>File Contents: /home/u885320773/domains/sugatu.in/public_html/consultancy/designer/design-orders.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/u885320773/domains/sugatu.in/public_html/consultancy/designer/design-orders.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php include 'include/check-session.php'; ?&gt;

&lt;!doctype html&gt;
&lt;html lang=&quot;en&quot;&gt;

&lt;head&gt;
  &lt;!-- Required meta tags --&gt;
  &lt;meta charset=&quot;utf-8&quot;&gt;
  &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot;&gt;
  &lt;link rel=&quot;icon&quot; href=&quot;assets/images/favicon-32x32.png&quot; type=&quot;image/png&quot; /&gt;
  &lt;!--plugins--&gt;
  &lt;link href=&quot;assets/plugins/vectormap/jquery-jvectormap-2.0.2.css&quot; rel=&quot;stylesheet&quot;/&gt;
  &lt;link href=&quot;assets/plugins/simplebar/css/simplebar.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/plugins/perfect-scrollbar/css/perfect-scrollbar.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/plugins/metismenu/css/metisMenu.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
   &lt;link href=&quot;assets/plugins/datatable/css/dataTables.bootstrap5.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
 
  &lt;!-- Bootstrap CSS --&gt;
  &lt;link href=&quot;assets/css/bootstrap.min.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/css/bootstrap-extended.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/css/style.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/css/icons.css&quot; rel=&quot;stylesheet&quot;&gt;
  &lt;link href=&quot;https://fonts.googleapis.com/css2?family=Roboto:wght@400;500&amp;display=swap&quot; rel=&quot;stylesheet&quot;&gt;
  &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/bootstrap-icons@1.5.0/font/bootstrap-icons.css&quot;&gt;
  
  
  
&lt;link rel=&quot;stylesheet&quot; href=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css&quot;&gt;
&lt;script src=&quot;https://code.jquery.com/jquery-3.5.1.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;https://stackpath.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;



  

  &lt;!-- loader--&gt;
	&lt;link href=&quot;assets/css/pace.min.css&quot; rel=&quot;stylesheet&quot; /&gt;

  &lt;!--Theme Styles--&gt;
  &lt;link href=&quot;assets/css/dark-theme.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/css/light-theme.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/css/semi-dark.css&quot; rel=&quot;stylesheet&quot; /&gt;
  &lt;link href=&quot;assets/css/header-colors.css&quot; rel=&quot;stylesheet&quot; /&gt;

  &lt;title&gt;Manage Orders&lt;/title&gt;
&lt;/head&gt;

&lt;body&gt;


  &lt;!--start wrapper--&gt;
  &lt;div class=&quot;wrapper&quot;&gt;
    &lt;!--start top header--&gt;
      &lt;header class=&quot;top-header&quot;&gt;        
        &lt;nav class=&quot;navbar navbar-expand gap-3&quot;&gt;
			&lt;div class=&quot;mobile-toggle-icon fs-3&quot;&gt;
              &lt;i class=&quot;bi bi-list&quot;&gt;&lt;/i&gt;
            &lt;/div&gt;
			&lt;h4 style=&quot;margin-bottom: 0;&quot;&gt;Manage Orders&lt;/h4&gt;
			
            &lt;div class=&quot;top-navbar-right ms-auto&quot;&gt;
              &lt;ul class=&quot;navbar-nav align-items-center&quot;&gt;
                
				&lt;!-- ====== HEADER MENU ====== --&gt;
		&lt;?php include 'include/hmenu.php'; ?&gt;
       
              
			&lt;/ul&gt;
              &lt;/div&gt;
        &lt;/nav&gt;
      &lt;/header&gt;
       &lt;!--end top header--&gt;

        &lt;!--  ======= SIDE MENU ======  --&gt;
	   &lt;?php include 'include/menu.php'; ?&gt;
	   

       &lt;!--start content--&gt;
          &lt;main class=&quot;page-content&quot;&gt;
		  
		  &lt;?php	if(isset($_GET['add'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Lead Successfully Saved&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
        &lt;?php	if(isset($_GET['edit'])) {
					echo '&lt;div class=&quot;alert alert-success fade show&quot;&gt;
    &lt;strong&gt;Successfully Edited&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
				&lt;?php	if(isset($_GET['delete'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Successfully Deleted&lt;/strong&gt;.
  &lt;/div&gt;';
				} ?&gt;
								&lt;?php	if(isset($_GET['error'])) {
					echo '&lt;div class=&quot;alert alert-danger fade show&quot;&gt;
    &lt;strong&gt;Error While Adding Record&lt;/strong&gt;. Kindly try again.
  &lt;/div&gt;';
				} ?&gt;






		  &lt;div class=&quot;table-responsive&quot;&gt;
							&lt;table id=&quot;example2&quot; class=&quot;table table-striped table-bordered&quot;  data-order='[[ 0, &quot;desc&quot; ]]' data-page-length='25' style=&quot;width:100%&quot;&gt;
								&lt;thead&gt;
									&lt;tr&gt;
                    &lt;th&gt;Id&lt;/th&gt;
										&lt;th&gt;Order Id&lt;/th&gt;
                    &lt;th&gt;Amount&lt;/th&gt;
                    &lt;th&gt;Work Status&lt;/th&gt;
                    &lt;th&gt;Order Date&lt;/th&gt;
                    &lt;th&gt;Name&lt;/th&gt;
                    &lt;th&gt;Organisation&lt;/th&gt;
										
										
									&lt;/tr&gt;
								&lt;/thead&gt;
								&lt;tbody&gt;
								
								&lt;?php 

                

						include 'config.php';
              
            if(isset($_GET['designer'])) {
  
              // collect value of input field
              $designer = $_GET['designer'];
              $designerquery=&quot;and `assigneddesigner`='$designer'&quot;;
            } else{
              $designerquery='';
            }

         $sql2 = &quot;SELECT * FROM `designorders` where `orderstatus`='success' $designerquery and `assigneddesigner`='$sid'&quot;;
          
      $result2 = $conn-&gt;query($sql2);
  
      if ($result2-&gt;num_rows &gt; 0) {
        // output data of each row
        while($row = $result2-&gt;fetch_assoc()) {
         $id=$row[&quot;id&quot;];
         $order_id=$row[&quot;order_id&quot;];
         $orderdate=$row[&quot;orderdate&quot;];
         $fname=$row[&quot;fname&quot;];
         $organisation=$row[&quot;organisation&quot;];
         $amount=$row[&quot;amount&quot;];
         $phone=$row[&quot;phone&quot;];
         $workstatus=$row[&quot;workstatus&quot;];
          echo '
				&lt;tr&gt;
        &lt;td&gt;'.$id.'&lt;/td&gt;
				&lt;td&gt;&lt;a href=&quot;design-order-details.php?order_id='.$order_id.'&quot; class=&quot;btn btn-sm btn-success&quot; target=&quot;_blank&quot;&gt;&lt;b&gt;'.$order_id.'&lt;/b&gt;&lt;/a&gt;&lt;/td&gt;
        &lt;td&gt;₹'.$amount.'&lt;/td&gt;
        &lt;td&gt;&lt;b&gt;'.$workstatus.'&lt;/b&gt;&lt;/td&gt;
				&lt;td&gt;'.$orderdate.'&lt;/td&gt;
				&lt;td&gt;'.$fname.'&lt;/td&gt;
        &lt;td&gt;'.$organisation.'&lt;/td&gt;
        
				
				&lt;/tr&gt;
		  ';
		  
		  
		
}
}
?&gt;
       


								
								&lt;/tbody&gt;
						&lt;/table&gt;
						&lt;/div&gt;
		  
		  
		  
			 
			 
			 
			 
			 

          &lt;/main&gt;
       &lt;!--end page main--&gt;

       &lt;!--start overlay--&gt;
        &lt;div class=&quot;overlay nav-toggle-icon&quot;&gt;&lt;/div&gt;
       &lt;!--end overlay--&gt;

       &lt;!--Start Back To Top Button--&gt;
		     &lt;a href=&quot;javaScript:;&quot; class=&quot;back-to-top&quot;&gt;&lt;i class='bx bxs-up-arrow-alt'&gt;&lt;/i&gt;&lt;/a&gt;
       &lt;!--End Back To Top Button--&gt;

      

  &lt;/div&gt;
  &lt;!--end wrapper--&gt;


  &lt;!-- Bootstrap bundle JS --&gt;
  &lt;script src=&quot;assets/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
  &lt;!--plugins--&gt;
  &lt;script src=&quot;assets/js/jquery.min.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;assets/plugins/simplebar/js/simplebar.min.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;assets/plugins/metismenu/js/metisMenu.min.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;assets/plugins/perfect-scrollbar/js/perfect-scrollbar.js&quot;&gt;&lt;/script&gt;
&lt;script src=&quot;assets/js/pace.min.js&quot;&gt;&lt;/script&gt;
    &lt;script src=&quot;assets/plugins/datatable/js/jquery.dataTables.min.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;assets/plugins/datatable/js/dataTables.bootstrap5.min.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;assets/js/table-datatable.js&quot;&gt;&lt;/script&gt;

  &lt;!--app--&gt;
  &lt;script src=&quot;assets/js/app.js&quot;&gt;&lt;/script&gt;
  &lt;script src=&quot;assets/js/index.js&quot;&gt;&lt;/script&gt;
  &lt;script&gt;
    new PerfectScrollbar(&quot;.best-product&quot;)
 &lt;/script&gt;


&lt;/body&gt;

&lt;/html&gt;</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fu885320773%2Fdomains%2Fsugatu.in%2Fpublic_html%2Fconsultancy%2Fdesigner'>⬅ Back to Directory</a>