PageRenderTime 38ms CodeModel.GetById 8ms RepoModel.GetById 0ms app.codeStats 0ms

/application/modules/schedule_group_manivest/views/print_view_excel.php

https://bitbucket.org/bo_hmb/bo_hmb
PHP | 160 lines | 133 code | 25 blank | 2 comment | 9 complexity | 837073577a625135a2aaa1eac01e72fc MD5 | raw file
Possible License(s): Apache-2.0, MIT, LGPL-2.1, MPL-2.0-no-copyleft-exception, GPL-2.0 
    

  1. <?php
    2. 

  2. 

  3. header("Content-type: application/vnd-ms-excel");
    4. 

  4. header("Content-Disposition: attachment; filename=Group_Manifest.xls");
    5. 

  5. ?>
    6. 

  6. 

  7. <!DOCTYPE html>
    8. 

  8. <html>
    9. 

  9. <head>
    10. 

  10. <link rel="shortcut icon" href="<?php echo base_url() ?>assets/img/logo.png" /> 
    11. 

  11.   
    12. 

  12. <title>GROUP MANIVEST</title>
    13. 

  13.   
    14. 

  14.     <style>
    15. 

  15.       
    16. 

  16.         table{
    17. 

  17.               
    18. 

  18.         border-collapse: collapse;
    19. 

  19.               
    20. 

  20.         /*width: 100%;*/
    21. 

  21.               
    22. 

  22.         /*margin: 0 auto;*/
    23. 

  23.           
    24. 

  24.         }
    25. 

  25.           
    26. 

  26.         table th{
    27. 

  27.               
    28. 

  28.         border:1px solid #000;
    29. 

  29.               
    30. 

  30.         font-weight: bold;
    31. 

  31.               
    32. 

  32.         text-align: center;
    33. 

  33.         font-size: 12px;
    34. 

  34.           
    35. 

  35.         }
    36. 

  36.           
    37. 

  37.         table td{
    38. 

  38.               
    39. 

  39.         border:0px solid #000;
    40. 

  40.               
    41. 

  41.         padding: 3px;
    42. 

  42.         font-size: 13px;
    43. 

  43.               
    44. 

  44.         vertical-align: top;
    45. 

  45.           
    46. 

  46.         }
    47. 

  47. 

  48.     </style>
    49. 

  49. </head>
    50. 

  50. <body>
    51. 

  51. <!-- kop -->
    52. 

  52. <h2 style="text-align: center; font-weight: bold;">GROUP MANIFEST</h2>
    53. 

  53. <table>
    54. 

  54.     <tr>
    55. 

  55.        <td >
    56. 

  56.         <table>
    57. 

  57.             <tr>    
    58. 

  58.                 <td></td>
    59. 

  59.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;background-color: #b3ffb3"> 
    60. 

  60.                     <h5>GROUP CODE</h5>
    61. 

  61.                 </td>
    62. 

  62.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;background-color: #b3ffb3"> 
    63. 

  63.                     <h5>: <?php echo $master->group_code;?></h5>
    64. 

  64.                 </td>
    65. 

  65.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;background-color: #FFFF00"> 
    66. 

  66.                     <h5>DEP. DATE</h5>
    67. 

  67.                 </td>
    68. 

  68.                 <td style="border:0px solid #000;width: 120px;font-size: 14px;background-color: #FFFF00"> 
    69. 

  69.                     <h5>: <?php echo date('d-m-Y', strtotime($master->dep_date));?></h5>
    70. 

  70.                 </td>
    71. 

  71.             </tr>
    72. 

  72.             <tr>
    73. 

  73.                 <td></td>                
    74. 

  74.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    75. 

  75.                     <h5>TOTAL PAX</h5>
    76. 

  76.                 </td>
    77. 

  77.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    78. 

  78.                     <h5>: <?php echo $master->total_pax;?></h5>
    79. 

  79.                 </td>
    80. 

  80.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    81. 

  81.                     <h5>RETURN DATE</h5>
    82. 

  82.                 </td>
    83. 

  83.                 <td style="border:0px solid #000;width: 120px;font-size: 14px;"> 
    84. 

  84.                     <h5>: <?php echo date('d-m-Y', strtotime($master->return_date));?></h5>
    85. 

  85.                 </td>
    86. 

  86.             </tr>
    87. 

  87.             <tr>
    88. 

  88.                 <td></td>                               
    89. 

  89.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    90. 

  90.                     <h5>FLIGHT DETAIL</h5>
    91. 

  91.                 </td>
    92. 

  92.                 <td style="border:0px solid #000;width: 1px;font-size: 14px;"> 
    93. 

  93.                     <h5>: <?php echo $master->flight_detail;?></h5>
    94. 

  94.                 </td>
    95. 

  95.                 <td style="border:0px solid #000;width: 139px;font-size: 14px;"> 
    96. 

  96.                     <h5>LAST UPDATE</h5>
    97. 

  97.                 </td>
    98. 

  98.                 <td style="border:0px solid #000;width: 120px;font-size: 14px;"> 
    99. 

  99.                     <h5>: <?php echo date('d-m-Y H:m:s', strtotime($master->update_at)) ?></h5>
    100. 

  100.                 </td>
    101. 

  101.             </tr>
    102. 

  102.             
    103. 

  103.         </table>
    104. 

  104.       </th>
    105. 

  105.         <th style="border:0px solid #000; width: 100px"></th>
    106. 

  106.         <th style="border:0px solid #000; width: 100px"></th>
    107. 

  107.         <th style="border:0px solid #000; width: 100px"></th>
    108. 

  108.         <th style="border:0px solid #000; width: 100px"></th>
    109. 

  109.         <th style="border:0px solid #000; width: 100px"></th>
    110. 

  110.         <th style="border:0px solid #000; width: 100px"></th>
    111. 

  111.         <th style="border:0px solid #000; width: 155px">
    112. 

  112.             <center><img src="<?php echo base_url() ?>assets/img/logokop.png" class="img-responsive" alt="" height="100" width="100"></center>
    113. 

  113.         </th>
    114. 

  114.     </tr>
    115. 

  115. </table>
    116. 

  116. <!-- N Kop -->
    117. 

  117. <br>
    118. 

  118. <table>    
    119. 

  119.     <tr>           
    120. 

  120.         <th style="width: 20px;">No</th>
    121. 

  121.         <th style="width: 40px;">Title</th>
    122. 

  122.         <th style="width: 250px;">Full Name</th>
    123. 

  123.         <th style="width: 90px;">No. Pasport</th>
    124. 

  124.         <th style="width: 70px;">Birth Date</th>
    125. 

  125.         <th style="width: 100px;">Place Birth</th>
    126. 

  126.         <th style="width: 70px;">Date Issue</th>
    127. 

  127.         <th style="width: 70px;">Exp. Date</th>
    128. 

  128.         <th style="width: 70px;">Issuing Office</th>
    129. 

  129.         <th style="width: 30px;">Age</th>
    130. 

  130.         <th style="width: 200px;">Relationship</th>
    131. 

  131.         <th style="width: 150px;">Agen</th>
    132. 

  132.         <!-- <th style="width: 120px;">Note</th> -->
    133. 

  133.     </tr>
    134. 

  134. 

  135.     <?php $nomor=1; foreach($detail as $row) {?>
    136. 

  136. 

  137.         <?php if ($row->no_pasport == "") $no_pasport="-"; else $no_pasport=$row->no_pasport; ?>
    138. 

  138.         <?php if ($row->exp_pasport == "0000-00-00") $exp_pas="-"; else $exp_pas=date('d-M-Y', strtotime($row->exp_pasport)); ?>
    139. 

  139.         
    140. 

  140.         <?php $create_pas="-"; if ($row->create_pasport == "0000-00-00") $exp_pas="-"; else $create_pas=date('d-M-Y', strtotime($row->create_pasport)); ?>
    141. 

  141.         <tr>                                                
    142. 

  142.            <td style="border:1px solid #000;text-align: center;"><?php echo $nomor ?></td>
    143. 

  143.            <td style="border:1px solid #000;"><?php echo $row->title ?></td>
    144. 

  144.            <td style="text-transform: uppercase; border:1px solid #000;"><?php echo strtoupper($row->nm_lengkap) ?></td>
    145. 

  145.            <td style="border:1px solid #000;"><?php echo $no_pasport ?></td>
    146. 

  146.            <td style="border:1px solid #000;"><?php echo $x="'".date('d-M-Y', strtotime($row->tgl_lahir))?></td>
    147. 

  147.            <td style="text-transform: uppercase; border:1px solid #000;"><?php echo strtoupper($row->tmp_lahir) ?></td>
    148. 

  148.            <td style="border:1px solid #000;"><?php echo $x="'".$create_pas?></td>
    149. 

  149.            <td style="border:1px solid #000;"><?php echo $x="'".$exp_pas?></td>
    150. 

  150.            <td style="text-transform: uppercase; border:1px solid #000;"><?php echo strtoupper($row->kota_paspor) ?></td>
    151. 

  151.            <td style="border:1px solid #000;"><?php echo $row->age ?></td>
    152. 

  152.            <td style="border:1px solid #000;"><?php echo $row->keluarga ?></td>
    153. 

  153.            <td style="border:1px solid #000;"><?php echo $row->nm_marketing ?></td>  
    154. 

  154.            <!-- <td style="border:1px solid #000;"><?php echo $row->status ?></td>       -->
    155. 

  155.         </tr>   
    156. 

  156.     <?php $nomor++;}?> 
    157. 

  157. </table>
    158. 

  158. 

  159. </body>
    160. 

  160. </html>
    161.