PageRenderTime 81ms CodeModel.GetById 36ms RepoModel.GetById 0ms app.codeStats 0ms

/mgmt/payment/slip.php

https://gitlab.com/msdusad/all_ones
PHP | 324 lines | 202 code | 58 blank | 64 comment | 24 complexity | 7363ea71578a9bef1e8de4df66f36c3c MD5 | raw file
    

  1. 

  2. <?php session_start();
    3. 

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

  4. {
    5. 

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

  6. }
    7. 

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

  8.  include("header.php");
    9. 

  9.  $ms=$_GET['sl'];
    10. 

  10. if(!isset($_SESSION['number'])) 
    11. 

  11. { 
    12. 

  12.      $inslipnos=mysql_query("SELECT * FROM slip;");
    13. 

  13.     while($sl=mysql_fetch_array($inslipnos)){
    14. 

  14. $_SESSION['number'] = $sl['slipno']; 
    15. 

  15.     }
    16. 

  16. }else{ 
    17. 

  17.     
    18. 

  18. $_SESSION['number'] = $_SESSION['number'] + 1; 
    19. 

  19.   $inslipno=mysql_query("UPDATE slip SET slipno='{$_SESSION['number']}';");
    20. 

  20. } 
    21. 

  21.  
    22. 

  22. 

  23. ?>
    24. 

  24. <style>
    25. 

  25.     tr,td,th{
    26. 

  26. border:2px solid black; 
    27. 

  27.     }
    28. 

  28.     
    29. 

  29. </style>
    30. 

  30. 

  31. <script type="text/javascript">        
    32. 

  32. 

  33.           function printPage(id) {
    34. 

  34.     var printContents = document.getElementById(id).innerHTML;
    35. 

  35.      var originalContents = document.body.innerHTML;
    36. 

  36.      document.body.innerHTML = printContents;
    37. 

  37.      window.print();
    38. 

  38. 

  39. }
    40. 

  40.     </script>
    41. 

  41. <script type="text/javascript">
    42. 

  42.     function val(){
    43. 

  43.         var em_name = document.msd.courseadd.value;
    44. 

  44.             if (em_name == "") {
    45. 

  45.                 alert(" Fill Course  Name");
    46. 

  46.                 em_name.focus;
    47. 

  47.                 return false;
    48. 

  48.             } 
    49. 

  49.             var dp = document.msd.code.value;
    50. 

  50.             if (dp == "") {
    51. 

  51.                 alert("Please fill  Course Code");
    52. 

  52.                 dp.focus;
    53. 

  53.                 return false;
    54. 

  54.             } 
    55. 

  55.     }
    56. 

  56.     </script>
    57. 

  57. 

  58. <style>
    59. 

  59.     
    60. 

  60.     @media print {
    61. 

  61.     #addcourse {
    62. 

  62.         margin: 0;
    63. 

  63.         border: initial;
    64. 

  64.         border-radius: initial;
    65. 

  65.         width: initial;
    66. 

  66.         min-height: initial;
    67. 

  67.         box-shadow: initial;
    68. 

  68.         background: initial;
    69. 

  69.         page-break-after: always;
    70. 

  70.     }
    71. 

  71. }
    72. 

  72. </style>
    73. 

  73. 

  74. 

  75. <div style="clear:both;"></div>
    76. 

  76.  <div class="rightpanel" style="clear:both;">
    77. 

  77.     	<div class="headerpanel">
    78. 

  78.         	<a href="#" class="showmenu"></a>
    79. 

  79.             
    80. 

  80.             <div class="headerright">
    81. 

  81.             	<div class="dropdown notification">
    82. 

  82.                     
    83. 

  83.                 </div><!--dropdown-->
    84. 

  84.                 
    85. 

  85.     			<div class="dropdown userinfo">
    86. 

  86.                     <a class="dropdown-toggle" data-toggle="dropdown" data-target="#" href="#"> 
    87. 

  87.            Welcome <b><?php echo $_SESSION['username']?></b>
    88. 

  88.                    
    89. 

  89.          <b class="caret"></b></a>
    90. 

  90.                     <ul class="dropdown-menu">
    91. 

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

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

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

  94.                         <li class="divider"></li>-->
    95. 

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

  96.                     </ul>
    97. 

  97.                 </div><!--dropdown-->
    98. 

  98.     		
    99. 

  99.             </div><!--headerright-->
    100. 

  100.        <!--  $pdf_from_file = $client->convertFile('/path/to/your/file.html');
    101. 

  101. $pdf_from_html = $client->convertHtml('<b>bold</b> and <i>italic</i>'); -->
    102. 

  102.     	</div><!--hea 600
    103. 

  103. derpanel-->
    104. 

  104.         <div class="breadcrumbwidget">
    105. 

  105.         </div><!--breadcrumbs-->
    106. 

  106.         <div class="pagetitle">
    107. 

  107.         	<h1 align="center">Payment Slip</h1>
    108. 

  108.             
    109. 

  109.         </div><!--pagetitle--><br><br>
    110. 

  110.    
    111. 

  111.  <input type="button" value="Print" onclick="printPage('addcourse');" align="right" style="margin-left:50px; width: 6em;  height: 2em;" >&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
    112. 

  112.     <!-- <a  href="mailslip.php?sid=<?php echo $ms;?> "  > -->
    113. 

  113.         <a href="hide-show-code.php?ids=<?php echo $ms?>&slno=<?php echo $_SESSION['number'];?>"> Send On Email</a><br><br>
    114. 

  114. 

  115.       <div style="margin:50px;color:#990000; margin-top:10px" name="addcourse" id="addcourse"  >
    116. 

  116.            <center><img src="images2/111.jpg" height="30" width="90" ></center><br><br>
    117. 

  117.           <h2 align="center">Nex-G  Payment  Slip</h2> <br><br>
    118. 

  118.           <p>Sr. No. <?php echo $_SESSION['number'];?></p><br>
    119. 

  119.     <table class="table table-bordered" style="text-align:center;border:2px solid black;" cellspacing="5" cellpadding="6">
    120. 

  120.                   <?php  
    121. 

  121.      $ms=$_GET['sl'];
    122. 

  122.      $result=mysql_query("SELECT * FROM trregistration where id='$ms';");
    123. 

  123. if($result){
    124. 

  124.               if ($result && mysql_num_rows($result)>0) {
    125. 

  125.     while($row=mysql_fetch_array($result)){  
    126. 

  126.         $inst=$row['installment'];
    127. 

  127.         $fs=$row['inst_f_submited_fee'];
    128. 

  128.          $ss=$row['inst_s_submited_fee'];
    129. 

  129.          $ts=$row['inst_t_submited_fee'];
    130. 

  130.         $to=$row['email'];
    131. 

  131.         $name=$row['fname']." ".$row['lname'];
    132. 

  132.              $rgs=$row['reg_number'];
    133. 

  133.         $time=$row['fromduration']." To ".$row['toduration'];
    134. 

  134.         $co=$row['trcode'];
    135. 

  135.         $ins1=$row['inst_f_submited_fee']+$row['reg_amount'];
    136. 

  136.         $date1=$row['due_date1'];
    137. 

  137.         $narr1="Trainee Fees First Installment With Registration Fees";
    138. 

  138.         $ins2=$row['inst_s_submited_fee'];
    139. 

  139.         $date2=$row['inst_s_date'];
    140. 

  140.         $narr2=$row['narration_s_inst'];
    141. 

  141.         
    142. 

  142.          $ins3=$row['inst_t_submited_fee'];
    143. 

  143.         $date3=$row['inst_t_date'];
    144. 

  144.         $narr3=$row['narration_t_inst'];
    145. 

  145.         $du1=$row['trfees']-$ins1;
    146. 

  146.         $du2=$du1-$ins2;
    147. 

  147.         $du3=$du2-$ins3;
    148. 

  148.         $fee=$row['trfees'];
    149. 

  149.         $registration_date=$row['registration_date'];
    150. 

  150. 		 $registration_fee=$row['reg_amount'];
    151. 

  151. 		$reg_narration="Registration Fees";
    152. 

  152.           //$du=$row['trfees']-$row['reg_amount']-$row['inst_f_submited_fee']-$row['inst_s_submited_fee']-$row['inst_t_submited_fee'];
    153. 

  153.         ?>     
    154. 

  154.     <tr ><td >Trainee Name : <?php echo $name;  ?></td><td>Registration Number : <?php echo $rgs;?></td></tr>
    155. 

  155.         
    156. 

  156.     <tr><td>Course Code : <?php echo $co; ?></td><td>Registration Date : <?php echo $registration_date; ?></td></tr>
    157. 

  157.            
    158. 

  158.     </table><br>
    159. 

  159.         <table class="table table-bordered" style="text-align:center;border:2px solid black;">
    160. 

  160.             <tr><td>Course Fees : <?php echo $fee; ?></td><td></td><td></td><td></td></tr>
    161. 

  161.           <tr><td>Date</td><td>Credit</td><td>Due Balance</td><td>Narration</td> </tr>
    162. 

  162.             <?php if($inst =='1'){ 
    163. 

  163.             if($fs!=''){
    164. 

  164.             ?>
    165. 

  165.              <tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr> 
    166. 

  166.             <tr><td><?php echo $date1 ;   ?></td> <td><?php echo $ins1   ;?></td> <td><?php echo $du1;   ?></td> <td><?php echo $narr1   ;?></td> </tr> 
    167. 

  167.          <?php }
    168. 

  168.         else{
    169. 

  169. 			?><tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr> <?php
    170. 

  170. 			//echo "No Fees Submitted Yet";
    171. 

  171. 		}
    172. 

  172.         
    173. 

  173.         } 
    174. 

  174.         
    175. 

  175.         
    176. 

  176.         elseif($inst =='2'){ 
    177. 

  177.           if($fs !='' && $ss ==''){?>
    178. 

  178. 			<tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr>
    179. 

  179.             <tr><td><?php echo $date1 ;   ?></td> <td><?php echo $ins1   ;?></td> <td><?php echo $du1;   ?></td> <td><?php echo $narr1   ;?></td> </tr> 
    180. 

  180.           </table>
    181. 

  181.           
    182. 

  182.          <?php }
    183. 

  183.         elseif($fs !='' && $ss !='' ){?>
    184. 

  184. 		  <tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr>
    185. 

  185.             <tr><td><?php echo $date1 ;   ?></td> <td><?php echo $ins1   ;?></td> <td><?php echo $du2;   ?></td> <td><?php echo $narr1   ;?></td> </tr>
    186. 

  186.             <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
    187. 

  187.             
    188. 

  188.          
    189. 

  189.       <?php  }
    190. 

  190.             elseif($fs =='' && $ss !=''){
    191. 

  191.             
    192. 

  192.           ?> <tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr>
    193. 

  193. 		  <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
    194. 

  194.             <?php
    195. 

  195.             }
    196. 

  196.             else{ 
    197. 

  197. 				?><tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr> <?php
    198. 

  198. 				//echo "No Fees Submitted Yet";
    199. 

  199. 			}
    200. 

  200.         } 
    201. 

  201. else{ 
    202. 

  202.     
    203. 

  203.     if($fs!='' && $ss =='' && $ts =='') {?>
    204. 

  204. 		  <tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr>
    205. 

  205.             <tr><td><?php echo $date1 ;   ?></td> <td><?php echo $ins1   ;?></td> <td><?php echo $du1;   ?></td> <td><?php echo $narr1   ;?></td> </tr>
    206. 

  206.          
    207. 

  207.           
    208. 

  208.         <?php  } 
    209. 

  209. 

  210.     elseif( $fs!='' && $ss !='' && $ts == '') {?>
    211. 

  211. 		  <tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr>
    212. 

  212.             <tr><td><?php echo $date1 ;   ?></td> <td><?php echo $ins1   ;?></td> <td><?php echo $du1;   ?></td> <td><?php echo $narr1   ;?></td> </tr>
    213. 

  213.             <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
    214. 

  214.          
    215. 

  215.           
    216. 

  216.         <?php  } 
    217. 

  217.          elseif($fs!='' && $ss !='' && $ts != ''){   ?>
    218. 

  218. 		  <tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr>
    219. 

  219.             <tr><td><?php echo $date1 ;   ?></td> <td><?php echo $ins1   ;?></td> <td><?php echo $du1;   ?></td> <td><?php echo $narr1   ;?></td> </tr>
    220. 

  220.             <tr><td><?php echo $date2 ;?></td> <td><?php echo $ins2 ;?></td> <td><?php echo $du2; ?></td> <td><?php echo $narr2 ;?></td> </tr>
    221. 

  221.             <tr><td><?php echo $date3 ;?></td> <td><?php echo $ins3 ;?></td> <td><?php echo $du3; ?></td> <td><?php echo $narr3 ;?></td> </tr>
    222. 

  222.         
    223. 

  223.           
    224. 

  224.         <?php }  
    225. 

  225.     else{
    226. 

  226. 		?><tr><td><?php echo $registration_date ;   ?></td> <td><?php echo $registration_fee   ;?></td> <td></td> <td><?php echo $reg_narration   ;?></td> </tr> <?php
    227. 

  227. 		//echo "No Fees submitted yet";
    228. 

  228. 	}
    229. 

  229.               
    230. 

  230.               }
    231. 

  231.         
    232. 

  232.   //Code For Send Slip On email  
    233. 

  233.     /*  $sub="Nex-G Pay Slip";
    234. 

  234.    $bo=' <h2 style="margin-left:320px;">Nex-G  Pay  Slip</h2> <br><br>
    235. 

  235.    <table class="table table-bordered" style="text-align:center;" cellspacing="5" cellpadding="6">
    236. 

  236.    <h2 style="margin-left:320px;">Nex-G  Pay  Slip</h2> <br><br> <table class="table table-bordered" style="text-align:center;" border="1"><tr><td>Trainee Name : '.$name.' </td><td>Registration Number :  '.$rgs.'</td></tr>
    237. 

  237.         
    238. 

  238.     <tr><td>Course Code : '.$co.' </td><td>Time Duratuion : '.$time.' </td></tr>
    239. 

  239.            
    240. 

  240.     </table><br>
    241. 

  241.         <table class="table table-bordered" style="text-align:center;" border="1">
    242. 

  242.             <tr><td>Course Fees : '.$fee.'</td></tr>
    243. 

  243.           <tr><td>Date</td><td>Credit</td><td>Due Balance</td><td>Narration</td> </tr>';
    244. 

  244.            if($inst =='1'){ 
    245. 

  245.             $bo.='<tr><td> '.$date1.'</td> <td>'.$ins1.'</td> <td><?php echo '.$du1.'</td> <td>'. $narr1.'</td> </tr>';
    246. 

  246.          } 
    247. 

  247.         
    248. 

  248.         if($inst =='2'){ 
    249. 

  249.           if($ss ==''){
    250. 

  250.              $bo.='<tr><td>'.$date1.'</td> <td>'.$ins1.'</td> <td>'.$du1.'</td> <td>'.$narr1.'</td> </tr> 
    251. 

  251.           </table>';
    252. 

  252.           }
    253. 

  253.         else{
    254. 

  254.             $bo.='<tr><td>'. $date1.' </td> <td> '.$ins1.' </td> <td> '.$du2.'</td> <td>'.$narr1.'</td> </tr>
    255. 

  255.             <tr><td> '.$date2 .'</td> <td>'. $ins2.'</td><td>'.$du2.'</td> <td> '.$narr2.'</td> </tr>'; 
    256. 

  256.         }
    257. 

  257.         } 
    258. 

  258. if($inst =='3'){ 
    259. 

  259.     
    260. 

  260.     if($ss =='' && $ts =='') {
    261. 

  261.             $bo.='<tr><td> '.$date1.' </td> <td> '.$ins1.' </td> <td> '.$du1.'</td> <td> '.$narr1 .'</td> </tr>';
    262. 

  262.           } 
    263. 

    264. 

  264.     elseif( $ts == '') {
    265. 

  265.             $bo.= '<tr><td> '.$date1.'</td> <td> '.$ins1.'</td> <td>'.$du1.'</td> <td>'.$narr1.' </td> </tr>
    266. 

  266.             <tr><td>'.$date2.' </td> <td> '.$ins2.'</td> <td> '.$du2.'</td> <td> '.$narr2 .'</td> </tr>';
    267. 

  267.          
    268. 

  268.           
    269. 

  269.          } 
    270. 

  270.          else {  
    271. 

  271.              $bo.='<tr><td>'.$date1.' </td> <td> '.$ins1 .'</td> <td>'.$du1.'</td> <td> '.$narr1 .'</td> </tr>
    272. 

  272.             <tr><td>'.$date2.'</td> <td> '.$ins2.'</td> <td>'.$du2.'</td> <td> '.$narr2.' </td> </tr>
    273. 

  273.             <tr><td> '.$date3.' </td> <td> '.$ins3.' </td> <td> '.$du3.'</td> <td>'.$narr3.' </td> </tr>';       
    274. 

  274.  }           
    275. 

  275.               }
    276. 

  276.          $bo.='</table>';  
    277. 

  277.         
    278. 

  278.         $headerss = 'From: Nex-G<info@nexg.in>' . "\r\n" .
    279. 

  279.     'Reply-To:  info@nexg.in' . "\r\n" .
    280. 

  280.     'X-Mailer: PHP/' . phpversion();
    281. 

  281.         $headerss.= "MIME-Version: 1.0\r\n"; 
    282. 

  282. $headerss.= 'Content-type: text/html; charset=iso-8859-1' . "\r\n"; 
    283. 

  283. $headerss.= "X-Priority: 1\r\n"; 
    284. 

  284.        
    285. 

  285.     
    286. 

  286.         //$ms=mail($to,$sub,$bo,$headerss);
    287. 

  287.         
    288. 

  288.         */
    289. 

  289.     //.......................end hear
    290. 

  290.     }
    291. 

  291.               ?> </table> 
    292. 

  292. <br><br><br><br><br><br><p style="font-size:16px;margin-left:00px;"> Nex-G Exuberant Solution Pvt. Ltd.</p><br>
    293. 

  293.      <p style="font-size:16px;margin-left:00px;">Accounts</p>
    294. 

  294.      
    295. 

  295.      <?php 
    296. 

  296.              }
    297. 

  297. }
    298. 

  298. 

  299. else{ echo "error in query pass".mysql_error();} 
    300. 

  300. 

  301. 

  302. //mysql_connect("localhost","root","password","db");
    303. 

  303. ?>
    304. 

  304.     </div>
    305. 

  305.     
    306. 

  306.     
    307. 

  307.      
    308. 

  308.      
    309. 

  309.      
    310. 

  310.      
    311. 

  311. 	 </div>         
    312. 

  312.                      
    313. 

  313.     
    314. 

  314.     <div class="clearfix"></div>
    315. 

  315.     
    316. 

  316.     <!--footer-->
    317. 

  317.     
    318. 

  318. </div><!--mainwrapper-->
    319. 

  319. 

  320. </body>
    321. 

  321. </html>
    322. 

  322. 

  323.         
    324. 

  324.     
    325.