/admin/admin/ajax/ajax_income_2.php

https://gitlab.com/dev.essetel/sjnuri · PHP · 194 lines · 147 code · 15 blank · 32 comment · 12 complexity · 4506b4e9411e650e24f55738c87923bb MD5 · raw file 

    

  1. <?php
    2. 

  2. include_once('./_common.php');
    3. 

  3. $mb_seq = $_GET['mb_seq'];
    4. 

  4. $call_date = $_GET['call_date'];
    5. 

  5. $cartype = $_GET['cartype'];
    6. 

  6. $options = array();
    7. 

  7. 

  8. // 워킹 인포에 1번 데이터랑 2번 데이터 같이 보여줘야하는데 하나만 했음~~ 
    9. 

  9. if ($cartype = 2) {
    10. 

  10.   $sql = "SELECT * FROM (SELECT * FROM drivers_working_info 
    11. 

  11.                         WHERE DATE(call_date) = '{$call_date}'
    12. 

  12.                         AND ownerlevel = 0) a
    13. 

  13.         LEFT JOIN (SELECT call_date AS call_date_1,
    14. 

  14.                     drv_distance AS drv_distance_1,
    15. 

  15.                     drv_cash AS drv_cash_1,
    16. 

  16.                     drv_vccash AS drv_vccash_1,
    17. 

  17.                     tollfee1 AS tollfee1_1,
    18. 

  18.                     tollfee2 AS tollfee2_1,
    19. 

  19.                     tollfee3 AS tollfee3_1,
    20. 

  20.                     tollfee4 AS tollfee4_1,
    21. 

  21.                     tollname1 AS tollname1_1,
    22. 

  22.                     tollname2 AS tollname2_1,
    23. 

  23.                     tollname3 AS tollname3_1,
    24. 

  24.                     tollname4 AS tollname4_1,
    25. 

  25.                     seq as seq_1
    26. 

  26.                     FROM drivers_working_info 
    27. 

  27.                     WHERE DATE(call_date) = '{$call_date}' 
    28. 

  28.                     AND ownerlevel = 1 )b
    29. 

  29.           ON (a.call_date = b.call_date_1 )
    30. 

  30.           WHERE a.drvseq = $mb_seq";
    31. 

  31.   $result = sql_query($sql);
    32. 

  32.   while ($row = sql_fetch_array($result)) {
    33. 

  33. 

  34.     $sql = "SELECT * FROM drivers_working_info_file
    35. 

  35.           WHERE mf_id = {$row['seq']}";
    36. 

    37. 

  37.     $row_f = sql_fetch($sql);
    38. 

  38. 

  39.     $subsidy = number_format($row['drv_cash'] - $row['drv_vccash']);
    40. 

  40.     $row['drv_distance'] = number_format($row['drv_distance']);
    41. 

  41.     $row['drv_cash'] = number_format($row['drv_cash']);
    42. 

  42.     $row['drv_vccash'] = number_format($row['drv_vccash']);
    43. 

  43.     $row['tollfee1'] = number_format($row['tollfee1']);
    44. 

  44.     $row['tollfee2'] = number_format($row['tollfee2']);
    45. 

  45.     $row['tollfee3'] = number_format($row['tollfee3']);
    46. 

  46.     $row['tollfee4'] = number_format($row['tollfee4']);
    47. 

  47.     $row['drv_distance_1'] = number_format($row['drv_distance_1']);
    48. 

  48.     $row['drv_cash_1'] = number_format($row['drv_cash_1']);
    49. 

  49.     $row['drv_vccash_1'] = number_format($row['drv_vccash_1']);
    50. 

  50.     $row['tollfee1_1'] = number_format($row['tollfee1_1']);
    51. 

  51.     $row['tollfee2_1'] = number_format($row['tollfee2_1']);
    52. 

  52.     $row['tollfee3_1'] = number_format($row['tollfee3_1']);
    53. 

  53.     $row['tollfee4_1'] = number_format($row['tollfee4_1']);
    54. 

  54. 

  55.     if ($row_f) {
    56. 

  56.       $file_is = "<a href='/iium/file_download.php?path=iu_drivers_working_info&original={$row_f['origin_name']}&name={$row_f['file_name']}'>다운로드</a>";
    57. 

  57.       // $file_is = "<input type='button' onclick='showPopup();'/>";
    58. 

  58.     } else {
    59. 

  59.       $file_is = "";
    60. 

  60.     }
    61. 

  61.     if ($row['drv_cash_1']) {
    62. 

  62.       $row_update = "<a onclick='return income_update(`{$row['seq_1']}`)'>수정</a>";
    63. 

  63.     } else {
    64. 

  64.       $row_update = '';
    65. 

  65.     }
    66. 

  66. 

  67.     $adm_ck = $row['adm_ck'] == 1 ? 'checked' : '';
    68. 

  68.     $option['data'] = " <tr class='iframe1_2' >
    69. 

  69.                         <td>{$row['call_date']}</td>
    70. 

  70.                         <td>{$row['drv_distance']}</td>
    71. 

  71.                         <td>{$row['drv_distance_1']}</td>
    72. 

  72.                         <td>{$row['drv_cash']}</td>
    73. 

  73.                         <td>{$row['drv_cash_1']}</td>
    74. 

  74.                         <td>{$row['drv_vccash']}</td>
    75. 

  75.                         <td>{$row['drv_vccash_1']}</td>
    76. 

  76.                         <td>{$subsidy}</td>
    77. 

  77.                         <td>{$row['tollfee1_1']}</td>
    78. 

  78.                         <td>{$row['tollfee2_1']}</td>
    79. 

  79.                         <td>{$row['tollfee3_1']}</td>
    80. 

  80.                         <td>{$row['tollfee4_1']}</td>
    81. 

  81.                         <td>{$file_is}</td>
    82. 

  82.                         <td><input data-seq='{$row['seq']}' class='adm_ck' type='checkbox' name='adm_ck' value='{$row['adm_ck']}' {$adm_ck}></td>
    83. 

  83.                         <td>{$row_update}</td>
    84. 

  84.                       </tr>";
    85. 

    86. 

  86. 

  87.     // $option['data'] = " <tr class='iframe1_2' >
    88. 

  88.     //                       <td>{$row['call_date']}</td>
    89. 

  89.     //                       <td>{$row['drv_distance']}</td>
    90. 

  90.     //                       <td>{$row['drv_distance_1']}</td>
    91. 

  91.     //                       <td>{$row['drv_cash']}</td>
    92. 

  92.     //                       <td>{$row['drv_cash_1']}</td>
    93. 

  93.     //                       <td>{$row['drv_vccash']}</td>
    94. 

  94.     //                       <td>{$row['drv_vccash_1']}</td>
    95. 

  95.     //                       <td>{$row['tollfee1_1']}</td>
    96. 

  96.     //                       <td>{$row['tollfee2_1']}</td>
    97. 

  97.     //                       <td>{$row['tollfee3_1']}</td>
    98. 

  98.     //                       <td>{$row['tollfee4_1']}</td>
    99. 

  99.     //                       <td><input data-seq='{$row['seq']}' class='adm_ck' type='checkbox' name='adm_ck' value='{$row['adm_ck']}' {$adm_ck}></td>
    100. 

  100.     //                       <td><a herf='#'>수정</a></td>
    101. 

  101.     //                     </tr>";
    102. 

  102.     array_push($options, $option);
    103. 

  103.   }
    104. 

  104. } elseif ($cartype == 1) {
    105. 

  105.   $sql = "SELECT * FROM (SELECT * FROM drivers_working_info 
    106. 

  106.                           WHERE DATE(call_date) = '{$call_date}'
    107. 

  107.                           AND ownerlevel = 0) a
    108. 

  108.           LEFT JOIN (SELECT call_date AS call_date_1,
    109. 

  109.                           drv_distance AS drv_distance_1,
    110. 

  110.                           drv_cash AS drv_cash_1,
    111. 

  111.                           drv_vccash AS drv_vccash_1,
    112. 

  112.                           tollfee1 AS tollfee1_1,
    113. 

  113.                           tollfee2 AS tollfee2_1,
    114. 

  114.                           tollfee3 AS tollfee3_1,
    115. 

  115.                           tollfee4 AS tollfee4_1,
    116. 

  116.                           tollname1 AS tollname1_1,
    117. 

  117.                           tollname2 AS tollname2_1,
    118. 

  118.                           tollname3 AS tollname3_1,
    119. 

  119.                           tollname4 AS tollname4_1,
    120. 

  120.                           seq as seq_1
    121. 

  121.                           FROM drivers_working_info 
    122. 

  122.                           WHERE DATE(call_date) = '{$call_date}' 
    123. 

  123.                           AND ownerlevel = 1 )b
    124. 

  124.             ON (a.call_date = b.call_date_1 )
    125. 

  125.             WHERE a.drvseq = $mb_seq";
    126. 

  126.   $result = sql_query($sql);
    127. 

  127.   while ($row = sql_fetch_array($result)) {
    128. 

  128. 

  129.     $sql = "SELECT * FROM drivers_working_info_file
    130. 

  130.             WHERE mf_id = {$row['seq']}";
    131. 

  131.     $row_f = sql_fetch($sql);
    132. 

  132. 

  133.     $subsidy = $row['drv_cash'] - $row['drv_cash_1'];
    134. 

  134.     $row['drv_distance'] = number_format($row['drv_distance']);
    135. 

  135.     $row['drv_cash'] = number_format($row['drv_cash']);
    136. 

  136.     $row['drv_vccash'] = number_format($row['drv_vccash']);
    137. 

  137.     $row['tollfee1'] = number_format($row['tollfee1']);
    138. 

  138.     $row['tollfee2'] = number_format($row['tollfee2']);
    139. 

  139.     $row['tollfee3'] = number_format($row['tollfee3']);
    140. 

  140.     $row['tollfee4'] = number_format($row['tollfee4']);
    141. 

  141.     $row['drv_distance_1'] = number_format($row['drv_distance_1']);
    142. 

  142.     $row['drv_cash_1'] = number_format($row['drv_cash_1']);
    143. 

  143.     $row['drv_vccash_1'] = number_format($row['drv_vccash_1']);
    144. 

  144.     $row['tollfee1_1'] = number_format($row['tollfee1_1']);
    145. 

  145.     $row['tollfee2_1'] = number_format($row['tollfee2_1']);
    146. 

  146.     $row['tollfee3_1'] = number_format($row['tollfee3_1']);
    147. 

  147.     $row['tollfee4_1'] = number_format($row['tollfee4_1']);
    148. 

  148. 

  149.     if ($row_f) {
    150. 

  150.       $file_is = "<a href='/iium/file_download.php?path=iu_drivers_working_info&original={$row_f['origin_name']}&name={$row_f['file_name']}'>다운로드</a>";
    151. 

  151.     } else {
    152. 

  152.       $file_is = "";
    153. 

  153.     }
    154. 

  154. 

  155. 

  156. 

  157.     $adm_ck = $row['adm_ck'] == 1 ? 'checked' : '';
    158. 

  158.     $option['data'] = " <tr class='iframe1_2' >
    159. 

  159.                           <td>{$row['call_date']}</td>
    160. 

  160.                           <td>{$row['drv_distance']}</td>
    161. 

  161.                           <td>{$row['drv_distance_1']}</td>
    162. 

  162.                           <td>{$row['drv_cash']}</td>
    163. 

  163.                           <td>{$row['drv_cash_1']}</td>
    164. 

  164.                           <td>{$row['drv_vccash']}</td>
    165. 

  165.                           <td>{$row['drv_vccash_1']}</td>
    166. 

  166.                           <td>-</td>
    167. 

  167.                           <td>{$row['tollfee1_1']}</td>
    168. 

  168.                           <td>{$row['tollfee2_1']}</td>
    169. 

  169.                           <td>{$row['tollfee3_1']}</td>
    170. 

  170.                           <td>{$row['tollfee4_1']}</td>
    171. 

  171.                           <td>{$file_is}</td>
    172. 

  172.                           <td><input data-seq='{$row['seq']}' class='adm_ck' type='checkbox' name='adm_ck' value='{$row['adm_ck']}' {$adm_ck}></td>
    173. 

  173.                           <td><a onclick='return income_update(`{$row['seq_1']}`)'>수정</a></td>
    174. 

  174.                         </tr>";
    175. 

  175.     // $option['data'] = " <tr class='iframe1_2' >
    176. 

  176.     //                       <td>{$row['call_date']}</td>
    177. 

  177.     //                       <td>{$row['drv_distance']}</td>
    178. 

  178.     //                       <td>{$row['drv_distance_1']}</td>
    179. 

  179.     //                       <td>{$row['drv_cash']}</td>
    180. 

  180.     //                       <td>{$row['drv_cash_1']}</td>
    181. 

  181.     //                       <td>{$row['drv_vccash']}</td>
    182. 

  182.     //                       <td>{$row['drv_vccash_1']}</td>
    183. 

  183.     //                       <td>{$row['tollfee1_1']}</td>
    184. 

  184.     //                       <td>{$row['tollfee2_1']}</td>
    185. 

  185.     //                       <td>{$row['tollfee3_1']}</td>
    186. 

  186.     //                       <td>{$row['tollfee4_1']}</td>
    187. 

  187.     //                       <td><input data-seq='{$row['seq']}' class='adm_ck' type='checkbox' name='adm_ck' value='{$row['adm_ck']}' {$adm_ck}></td>
    188. 

  188.     //                       <td><a herf='#'>수정</a></td>
    189. 

  189.     //                     </tr>";
    190. 

  190.     array_push($options, $option);
    191. 

  191.   }
    192. 

  192. }
    193. 

  193. 

  194. print_r($options);
    195.