PageRenderTime 47ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/mgmt/admin/joined_enquiry.php

https://gitlab.com/msdusad/all_ones
PHP | 209 lines | 190 code | 19 blank | 0 comment | 17 complexity | 2222c34284e08fc75b38073a1dc63fed MD5 | raw file
    

  1. <?php session_start();
    2. 

  2. if(!isset($_SESSION['username']))
    3. 

  3. {
    4. 

  4. 	header("location:index.php");
    5. 

  5. }
    6. 

  6. include("conn.php");
    7. 

  7. ?>
    8. 

  8. <?php
    9. 

  9. if(isset($_GET['did']))
    10. 

  10. {
    11. 

  11. 	$del=mysql_query("delete from add_enquiry where id='".$_GET['did']."'");
    12. 

  12. 	echo '<script>alert("Data has been deleted!");</script>';
    13. 

  13. 	echo '<script>window.location="joined_enquiry.php";</script>';
    14. 

  14. }
    15. 

  15. ?>
    16. 

  16. 

  17. <?php include("header.php");?>
    18. 

  18. <div style="clear:both;"></div>
    19. 

  19.  <div class="rightpanel" style="clear:both;">
    20. 

  20.     	<div class="headerpanel">
    21. 

  21.         	<a href="#" class="showmenu"></a>
    22. 

  22.             
    23. 

  23.             <div class="headerright">
    24. 

  24.             	<div class="dropdown notification">
    25. 

  25.                     
    26. 

  26.                 </div><!--dropdown-->
    27. 

  27.                 
    28. 

  28.     			<div class="dropdown userinfo">
    29. 

  29.                     <a class="dropdown-toggle" data-toggle="dropdown" data-target="#" href="#"> 
    30. 

  30.            Welcome <b><?php echo $_SESSION['username']?></b>
    31. 

  31.                    
    32. 

  32.          <b class="caret"></b></a>
    33. 

  33.                     <ul class="dropdown-menu">
    34. 

  34.                         <!--<li><a href="editprofile.html"><span class="icon-edit"></span> Edit Profile</a></li>
    35. 

  35.                         <li><a href="#"><span class="icon-wrench"></span> Account Settings</a></li>
    36. 

  36.                         <li><a href="#"><span class="icon-eye-open"></span> Privacy Settings</a></li>
    37. 

  37.                         <li class="divider"></li>-->
    38. 

  38.                         <li><a href="sign_out.php"><span class="icon-off"></span> Sign Out</a></li>
    39. 

  39.                     </ul>
    40. 

  40.                 </div><!--dropdown-->
    41. 

  41.     		
    42. 

  42.             </div><!--headerright-->
    43. 

  43.             
    44. 

  44.     	</div><!--headerpanel-->
    45. 

  45.         <div class="breadcrumbwidget">
    46. 

  46.         </div><!--breadcrumbs-->
    47. 

  47.         <div class="pagetitle">
    48. 

  48.         	<h1>View Enquiry</h1>
    49. 

  49.          <a href="add_enquiry.php" ><button style="float:right;background:#0b4073;color:#fff;">Add Enquiry</button></a>
    50. 

  50.         </div><!--pagetitle-->
    51. 

  51.     <div style="color:#000; margin-top:10px;width:100%;max-width:100%;">
    52. 

  52.     <table class="table table-bordered" style="text-align:center;">
    53. 

  53.     <thead>
    54. 

  54. 		<th style="width:20px;">S. No.</th>    
    55. 

  55. 		<th style="width:50px;">Enquiry Name</th>
    56. 

  56. 		<th style="width:130px;">Email</th>
    57. 

  57. 		<th style="width:70px;">Country</th>
    58. 

  58. 		<th style="width:90px;">Contact</th>
    59. 

  59. 		<th style="width:70px;">Type</th>
    60. 

  60. 		<th style="width:100px;">Enquiry Source</th>
    61. 

  61. 		<th style="width:100px;">Date</th>
    62. 

  62. 		<th style="width:100px;">Interact Interface</th>
    63. 

  63. 		<th style="width:80px;">Status</th>
    64. 

  64. 		<th>Delete</th>
    65. 

  65. 		
    66. 

  66.     </thead>
    67. 

  67.     <?php 
    68. 

  68. 		$data=mysql_query("select * from add_enquiry where enq_status='Sent-Pipeline-Join-Close' order by id desc")or die(mysql_error());
    69. 

  69. 		while($fetch = mysql_fetch_array($data)){
    70. 

  70. 			
    71. 

  71. 			?>
    72. 

  72. 			<?php if($fetch['enq_type']=="United States Individual Training"){?>
    73. 

  73. 			<tr style="background:pink;">
    74. 

  74. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#000;"><?php echo $fetch['id'];?></a></td>	
    75. 

  75. 			<td><?php echo $fetch['u_name'];?></td>
    76. 

  76. 			<td><?php echo $fetch['email'];?></td>
    77. 

  77. 			<td><?php echo $fetch['country'];?></td>
    78. 

  78. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    79. 

  79. 			<td><?php echo $fetch['enq_type'];?></td>
    80. 

  80. 			<td><?php echo $fetch['enq_source'];?></td>
    81. 

  81. 			<td><?php echo $fetch['date'];?></td>
    82. 

  82. 			<td><?php echo $fetch['in_interface'];?></td>
    83. 

  83. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#000;"><?php echo $fetch['enq_status'];?></a></td>
    84. 

  84. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    85. 

  85. 			</tr>	
    86. 

  86. 			<?php } 
    87. 

  87. 			else if($fetch['enq_type']=="Domestic Individual Training"){?>
    88. 

  88. 			<tr style="background:skyblue;">
    89. 

  89. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#000;"><?php echo $fetch['id'];?></a></td>	
    90. 

  90. 			<td><?php echo $fetch['u_name'];?></td>
    91. 

  91. 			<td><?php echo $fetch['email'];?></td>
    92. 

  92. 			<td><?php echo $fetch['country'];?></td>
    93. 

  93. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    94. 

  94. 			<td><?php echo $fetch['enq_type'];?></td>
    95. 

  95. 			<td><?php echo $fetch['enq_source'];?></td>
    96. 

  96. 			<td><?php echo $fetch['date'];?></td>
    97. 

  97. 			<td><?php echo $fetch['in_interface'];?></td>
    98. 

  98. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#000;"><?php echo $fetch['enq_status'];?></a></td>
    99. 

  99. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    100. 

  100. 			</tr>	
    101. 

  101. 			<?php } 
    102. 

  102. 			else if($fetch['enq_type']=="World Individual Training"){?>
    103. 

  103. 			<tr style="background:orange;">
    104. 

  104. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#000;"><?php echo $fetch['id'];?></a></td>	
    105. 

  105. 			<td><?php echo $fetch['u_name'];?></td>
    106. 

  106. 			<td><?php echo $fetch['email'];?></td>
    107. 

  107. 			<td><?php echo $fetch['country'];?></td>
    108. 

  108. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    109. 

  109. 			<td><?php echo $fetch['enq_type'];?></td>
    110. 

  110. 			<td><?php echo $fetch['enq_source'];?></td>
    111. 

  111. 			<td><?php echo $fetch['date'];?></td>
    112. 

  112. 			<td><?php echo $fetch['in_interface'];?></td>
    113. 

  113. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#000;"><?php echo $fetch['enq_status'];?></a></td>
    114. 

  114. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    115. 

  115. 			</tr>	
    116. 

  116. 			<?php } 
    117. 

  117. 			else if($fetch['enq_type']=="Domestic Corporate Training"){?>
    118. 

  118. 			<tr style="background:yellow;">
    119. 

  119. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#000;"><?php echo $fetch['id'];?></a></td>	
    120. 

  120. 			<td><?php echo $fetch['u_name'];?></td>
    121. 

  121. 			<td><?php echo $fetch['email'];?></td>
    122. 

  122. 			<td><?php echo $fetch['country'];?></td>
    123. 

  123. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    124. 

  124. 			<td><?php echo $fetch['enq_type'];?></td>
    125. 

  125. 			<td><?php echo $fetch['enq_source'];?></td>
    126. 

  126. 			<td><?php echo $fetch['date'];?></td>
    127. 

  127. 			<td><?php echo $fetch['in_interface'];?></td>
    128. 

  128. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#000;"><?php echo $fetch['enq_status'];?></a></td>
    129. 

  129. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    130. 

  130. 			</tr>			
    131. 

  131. 			<?php } 
    132. 

  132. 			else if($fetch['enq_type']=="International Corporate Training"){?>
    133. 

  133. 			<tr style="background:yellow;">
    134. 

  134. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#000;"><?php echo $fetch['id'];?></a></td>	
    135. 

  135. 			<td><?php echo $fetch['u_name'];?></td>
    136. 

  136. 			<td><?php echo $fetch['email'];?></td>
    137. 

  137. 			<td><?php echo $fetch['country'];?></td>
    138. 

  138. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    139. 

  139. 			<td><?php echo $fetch['enq_type'];?></td>
    140. 

  140. 			<td><?php echo $fetch['enq_source'];?></td>
    141. 

  141. 			<td><?php echo $fetch['date'];?></td>
    142. 

  142. 			<td><?php echo $fetch['in_interface'];?></td>
    143. 

  143. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#000;"><?php echo $fetch['enq_status'];?></a></td>
    144. 

  144. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    145. 

  145. 			</tr>
    146. 

  146. 			<?php } 
    147. 

  147. 			else if($fetch['enq_type']=="College Workshop"){?>
    148. 

  148. 			<tr style="background:purple;color:#fff;">
    149. 

  149. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#fff;"><?php echo $fetch['id'];?></a></td>	
    150. 

  150. 			<td><?php echo $fetch['u_name'];?></td>
    151. 

  151. 			<td><?php echo $fetch['email'];?></td>
    152. 

  152. 			<td><?php echo $fetch['country'];?></td>
    153. 

  153. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    154. 

  154. 			<td><?php echo $fetch['enq_type'];?></td>
    155. 

  155. 			<td><?php echo $fetch['enq_source'];?></td>
    156. 

  156. 			<td><?php echo $fetch['date'];?></td>
    157. 

  157. 			<td><?php echo $fetch['in_interface'];?></td>
    158. 

  158. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#fff;"><?php echo $fetch['enq_status'];?></a></td>
    159. 

  159. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    160. 

  160. 			</tr>
    161. 

  161. 			<?php } 
    162. 

  162. 			else if($fetch['enq_type']=="Domestic Project"){?>
    163. 

  163. 			<tr style="background:green;color:#fff;">
    164. 

  164. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#fff;"><?php echo $fetch['id'];?></a></td>	
    165. 

  165. 			<td><?php echo $fetch['u_name'];?></td>
    166. 

  166. 			<td><?php echo $fetch['email'];?></td>
    167. 

  167. 			<td><?php echo $fetch['country'];?></td>
    168. 

  168. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    169. 

  169. 			<td><?php echo $fetch['enq_type'];?></td>
    170. 

  170. 			<td><?php echo $fetch['enq_source'];?></td>
    171. 

  171. 			<td><?php echo $fetch['date'];?></td>
    172. 

  172. 			<td><?php echo $fetch['in_interface'];?></td>
    173. 

  173. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>"style="color:#fff;"><?php echo $fetch['enq_status'];?></a></td>
    174. 

  174. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    175. 

  175. 			</tr>
    176. 

  176. 			<?php } 
    177. 

  177. 			else if($fetch['enq_type']=="International Project"){?>
    178. 

  178. 			<tr style="background:green;color:#fff;">
    179. 

  179. 			<td><a href="show_enquiry.php?sid=<?= $fetch['id'];?>" style="color:#fff;"><?php echo $fetch['id'];?></a></td>	
    180. 

  180. 			<td><?php echo $fetch['u_name'];?></td>
    181. 

  181. 			<td><?php echo $fetch['email'];?></td>
    182. 

  182. 			<td><?php echo $fetch['country'];?></td>
    183. 

  183. 			<td><?php echo $fetch['country_code'];?>-<?php echo $fetch['contact'];?></td>
    184. 

  184. 			<td><?php echo $fetch['enq_type'];?></td>
    185. 

  185. 			<td><?php echo $fetch['enq_source'];?></td>
    186. 

  186. 			<td><?php echo $fetch['date'];?></td>
    187. 

  187. 			<td><?php echo $fetch['in_interface'];?></td>
    188. 

  188. 			<td><a href="updatestatus.php?uid=<?= $fetch['id']; ?>" style="color:#fff;"><?php echo $fetch['enq_status'];?></a></td>
    189. 

  189. 			<td><a href="joined_enquiry.php?did=<?= $fetch['id'];?>"><img src="img/DeleteRed.png" width="20" height="20"></a></td>
    190. 

  190. 			</tr>
    191. 

  191. 			   
    192. 

  192.     <?php  } }?>
    193. 

  193.     
    194. 

  194.     </table>
    195. 

  195.         </div> 
    196. 

  196. 	 </div>         
    197. 

  197.                      
    198. 

  198.     
    199. 

  199.     <div class="clearfix"></div>
    200. 

  200.     
    201. 

  201.     <!--footer-->
    202. 

  202.     
    203. 

  203. </div><!--mainwrapper-->
    204. 

  204. 

  205. </body>
    206. 

  206. </html>
    207. 

  207. 

  208.         
    209. 

  209.     
    210.