/admin/ajax/ajax_income_1.php

https://gitlab.com/dev.essetel/sjnuri · PHP · 262 lines · 202 code · 17 blank · 43 comment · 9 complexity · a0604a383d1a22a02573dcd36ecfd54c MD5 · raw file 

    

  1. <?php
    2. 

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

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

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

  5. $options = array();
    6. 

  6. $slice_mb_seq = substr($mb_seq, -4, 4);
    7. 

  7. // 카타입으로 2개 인지 3개인지 골라야함   서버나가있네....
    8. 

  8. // cartype 2   특장차   엑셀 비교 + 차이 금액 노츠출 + 수입금 일계표
    9. 

  9. // cartype 1   택시     보조금 + 노출
    10. 

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

  11.   $sql = "SELECT * FROM ( SELECT LEFT(call_date, 10) as call_date, 
    12. 

  12.                           IFNULL(SUM(drv_distance),0) as drv_distance,
    13. 

  13.                           IFNULL(SUM(drv_cash),0) as drv_cash,
    14. 

  14.                           IFNULL(SUM(drv_vccash),0) as drv_vccash,
    15. 

  15.                           IFNULL(SUM(tollfee1),0) as tollfee1,
    16. 

  16.                           IFNULL(SUM(tollfee2),0) as tollfee2,
    17. 

  17.                           IFNULL(SUM(tollfee3),0) as tollfee3,
    18. 

  18.                           IFNULL(SUM(tollfee4),0 ) as tollfee4,
    19. 

  19.                           drvseq ,COUNT(*) AS cnt
    20. 

  20.                           FROM drivers_working_info
    21. 

  21.                           WHERE drvseq = $mb_seq
    22. 

  22.                           AND ownerlevel = 0
    23. 

  23.                           AND Month(call_date)=Month(now())
    24. 

  24.                           GROUP BY LEFT(call_date, 10)
    25. 

  25.                           ) a
    26. 

  26.           LEFT JOIN (
    27. 

  27.                             SELECT LEFT(call_date, 10) as call_date_1, 
    28. 

  28.                             IFNULL(SUM(drv_distance),0) as drv_distance_1,
    29. 

  29.                             IFNULL(SUM(drv_cash),0) as drv_cash_1,
    30. 

  30.                             IFNULL(SUM(drv_vccash),0) as drv_vccash_1,
    31. 

  31.                             IFNULL(SUM(tollfee1),0) as tollfee1_1,
    32. 

  32.                             IFNULL(SUM(tollfee2),0) as tollfee2_1,
    33. 

  33.                             IFNULL(SUM(tollfee3),0) as tollfee3_1,
    34. 

  34.                             IFNULL(SUM(tollfee4),0 ) as tollfee4_1,
    35. 

  35.                             drvseq as drvseq_1 , COUNT(*) as cnt_1
    36. 

  36.                             FROM drivers_working_info
    37. 

  37.                             WHERE drvseq = $mb_seq
    38. 

  38.                             AND ownerlevel = 1
    39. 

  39.                             AND Month(call_date)=Month(now())
    40. 

  40.                             GROUP BY LEFT(call_date, 10)
    41. 

  41.                             ) b
    42. 

  42.             ON (a.call_date = b.call_date_1)";
    43. 

  43.   $result = sql_query($sql);
    44. 

  44.   while ($row = sql_fetch_array($result)) {
    45. 

  45. 

  46.     // 요금차이 
    47. 

  47.     $miner_price = $row['drv_cash_1'] - $row['drv_cash'];
    48. 

  48.     if ($miner_price) {
    49. 

  49.       $miner_price = $miner_price;
    50. 

  50.     } else {
    51. 

  51.       $miner_price = 0;
    52. 

  52.     }
    53. 

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

  54.     $row['drv_cash'] = number_format($row['drv_cash']);
    55. 

  55.     $row['drv_vccash'] = number_format($row['drv_vccash']);
    56. 

  56.     $row['tollfee1'] = number_format($row['tollfee1']);
    57. 

  57.     $row['tollfee2'] = number_format($row['tollfee2']);
    58. 

  58.     $row['tollfee3'] = number_format($row['tollfee3']);
    59. 

  59.     $row['tollfee4'] = number_format($row['tollfee4']);
    60. 

  60.     $row['cnt'] = number_format($row['cnt']);
    61. 

  61. 

  62. 

  63. 

  64. 

  65.     $tollfee_a =  (int)$row['tollfee1_1'] + (int)$row['tollfee2_1'] + (int)$row['tollfee3_1'] + (int)$row['tollfee4_1'];
    66. 

  66.     $row['drv_distance_1'] = number_format($row['drv_distance_1']);
    67. 

  67.     $row['drv_cash_1'] = number_format($row['drv_cash_1']);
    68. 

  68.     $row['drv_vccash_1'] = number_format($row['drv_vccash_1']);
    69. 

  69.     $row['tollfee1_1'] = number_format($row['tollfee1_1']);
    70. 

  70.     $row['tollfee2_1'] = number_format($row['tollfee2_1']);
    71. 

  71.     $row['tollfee3_1'] = number_format($row['tollfee3_1']);
    72. 

  72.     $row['tollfee4_1'] = number_format($row['tollfee4_1']);
    73. 

  73.     $row['cnt_1'] = number_format($row['cnt_1']);
    74. 

  74. 

  75. 

  76.     $row['a_call_date'] = iuf_hex_encode($row['call_date']);
    77. 

  77.     $a_mb_seq = iuf_hex_encode($mb_seq);
    78. 

  78.     $row['a_drv_distance'] = iuf_hex_encode($row['drv_distance']);
    79. 

  79.     $row['a_cnt'] = iuf_hex_encode($row['cnt']);
    80. 

  80.     $row['a_drv_cash'] = iuf_hex_encode($row['drv_cash']);
    81. 

  81.     $row['a_drv_vccash'] = iuf_hex_encode($row['drv_vccash']);
    82. 

  82.     $row['a_cnt_1'] = iuf_hex_encode($row['cnt_1']);
    83. 

  83.     $row['a_drv_cash_1'] = iuf_hex_encode($row['drv_cash_1']);
    84. 

  84.     $row['a_drv_vccash_1'] = iuf_hex_encode($row['drv_vccash_1']);
    85. 

  85.     $a_tollfee_a = iuf_hex_encode($tollfee_a);
    86. 

  86. 

  87. 

  88.     $option['data'] = "<tr class='iframe1_1' data-calldate='{$row['call_date']}' data-cartype='{$cartype}'>
    89. 

  89.                         <td class='addtd1'>{$row['call_date']}</td>
    90. 

  90.                         <td class='addtd2'>{$row['drv_distance']}</td>
    91. 

  91.                         <td class='addtd3'>{$row['cnt']}</td>
    92. 

  92.                         <td class='addtd4'>{$row['drv_cash']}</td>
    93. 

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

  94.                         <td class='addtd6'>{$row['cnt_1']}</td>
    95. 

  95.                         <td class='addtd7'>{$row['drv_cash_1']}</td>
    96. 

  96.                         <td class='addtd8'>{$row['drv_vccash_1']}</td>
    97. 

  97.                         <td class='addtd9'></td>
    98. 

  98.                         <td class='addtd10'></td>
    99. 

  99.                         <td class='addtd11'>{$miner_price}</td>
    100. 

  100.                         <td class='addtd12'>{$row['tollfee1_1']}</td>
    101. 

  101.                         <td class='addtd13'>{$row['tollfee2_1']}</td>
    102. 

  102.                         <td class='addtd14'>{$row['tollfee3_1']}</td>
    103. 

  103.                         <td class='addtd15'>{$row['tollfee4_1']}</td>
    104. 

  104.                         <td>
    105. 

  105.                           <a href='./income_day_print.php?calldate={$row['a_call_date']}&drvseq={$a_mb_seq}&drv_distance={$row['a_drv_distance']}&cnt={$row['a_cnt']}&drv_cash={$row['a_drv_cash']}&drv_vccash={$row['a_drv_vccash']}&cnt_1={$row['a_cnt_1']}&drv_cash_1={$row['a_drv_cash_1']}&drv_vccash_1={$row['a_drv_vccash_1']}&tollfee_a={$a_tollfee_a}' onclick='return dayprint(this.href);' target='_blank' class='btn btn_02'>일계표</a>
    106. 

  106.                         </td>
    107. 

  107.                       </tr>";
    108. 

  108.     // 폼으로 넘기려고 작업 하던 내용
    109. 

  109.     // $option['data'] = "<tr class='iframe1_1' data-calldate='{$row['call_date']}' data-cartype='{$cartype}'>
    110. 

  110.     //   <td class='addtd1'>{$row['call_date']}</td>
    111. 

  111.     //   <td class='addtd2'>{$row['drv_distance']}</td>
    112. 

  112.     //   <td class='addtd3'>{$row['cnt']}</td>
    113. 

  113.     //   <td class='addtd4'>{$row['drv_cash']}</td>
    114. 

  114.     //   <td class='addtd5'>{$row['drv_vccash']}</td>
    115. 

  115.     //   <td class='addtd6'>{$row['cnt_1']}</td>
    116. 

  116.     //   <td class='addtd7'>{$row['drv_cash_1']}</td>
    117. 

  117.     //   <td class='addtd8'>{$row['drv_vccash_1']}</td>
    118. 

  118.     //   <td class='addtd9'></td>
    119. 

  119.     //   <td class='addtd10'></td>
    120. 

  120.     //   <td class='addtd11'>{$miner_price}</td>
    121. 

  121.     //   <td class='addtd12'>{$row['tollfee1_1']}</td>
    122. 

  122.     //   <td class='addtd13'>{$row['tollfee2_1']}</td>
    123. 

  123.     //   <td class='addtd14'>{$row['tollfee3_1']}</td>
    124. 

  124.     //   <td class='addtd15'>{$row['tollfee4_1']}</td>
    125. 

  125.     //   <td>
    126. 

  126.     //   <form id='fincome1' method='post' action='./income_day_print.php'>
    127. 

  127.     //     <input type='hidden' name='calldate' value='{$row['a_call_date']}'>
    128. 

  128.     //     <input type='hidden' name='drvseq' value='{$a_mb_seq}'>
    129. 

  129.     //     <input type='hidden' name='drv_distance' value='{$row['a_drv_distance']}'>
    130. 

  130.     //     <input type='hidden' name='cnt' value='{$row['a_cnt']}'>
    131. 

  131.     //     <input type='hidden' name='drv_cash' value='{$row['a_drv_cash']}'>
    132. 

  132.     //     <input type='hidden' name='drv_vccash' value='{$row['a_drv_vccash']}'>
    133. 

  133.     //     <input type='hidden' name='cnt_1' value='{$row['a_cnt_1']}'>
    134. 

  134.     //     <input type='hidden' name='drv_cash_1' value='{$row['drv_cash_1']}'>
    135. 

  135.     //     <input type='hidden' name='drv_vccash_1' value='{$row['a_drv_vccash_1']}'>
    136. 

  136.     //     <input type='hidden' name='tollfee_a' value='{$a_tollfee_a}'>
    137. 

  137.     //     <a href='javascript:void(0)' onclick='dayprint();' class='btn btn_02'>일계표</a>
    138. 

  138.     //   </from>
    139. 

  139.     //   </td>
    140. 

  140.     // </tr>";
    141. 

  141.     // $option['date'] = $row['call_date'];
    142. 

  142.     // array_push($options, preg_replace('/\r\n|\r|\n/','',$option));
    143. 

  143.     array_push($options, $option);
    144. 

  144.   }
    145. 

  145. } elseif ($cartype == 1) {
    146. 

  146.   $sql = "SELECT * FROM ( SELECT LEFT(call_date, 10) as call_date, 
    147. 

  147.             IFNULL(SUM(drv_distance),0) as drv_distance,
    148. 

  148.             IFNULL(SUM(drv_cash),0) as drv_cash,
    149. 

  149.             IFNULL(SUM(drv_vccash),0) as drv_vccash,
    150. 

  150.             IFNULL(SUM(tollfee1),0) as tollfee1,
    151. 

  151.             IFNULL(SUM(tollfee2),0) as tollfee2,
    152. 

  152.             IFNULL(SUM(tollfee3),0) as tollfee3,
    153. 

  153.             IFNULL(SUM(tollfee4),0 ) as tollfee4,
    154. 

  154.             drvseq , 
    155. 

  155.             COUNT(*) AS cnt
    156. 

  156.             FROM drivers_working_info
    157. 

  157.             WHERE drvseq = $mb_seq
    158. 

  158.             AND ownerlevel = 0
    159. 

  159.             AND Month(call_date)=Month(now())
    160. 

  160.             GROUP BY LEFT(call_date, 10)
    161. 

  161.           ) a
    162. 

  162.         left JOIN (
    163. 

  163.           SELECT LEFT(call_date, 10) as call_date_1, 
    164. 

  164.             IFNULL(SUM(drv_distance),0) as drv_distance_1,
    165. 

  165.             IFNULL(SUM(drv_cash),0) as drv_cash_1,
    166. 

  166.             IFNULL(SUM(drv_vccash),0) as drv_vccash_1,
    167. 

  167.             IFNULL(SUM(tollfee1),0) as tollfee1_1,
    168. 

  168.             IFNULL(SUM(tollfee2),0) as tollfee2_1,
    169. 

  169.             IFNULL(SUM(tollfee3),0) as tollfee3_1,
    170. 

  170.             IFNULL(SUM(tollfee4),0 ) as tollfee4_1,
    171. 

  171.             drvseq as drvseq_1 , 
    172. 

  172.             COUNT(*) as cnt_1
    173. 

  173.             FROM drivers_working_info
    174. 

  174.             WHERE drvseq = $mb_seq
    175. 

  175.             AND ownerlevel = 1
    176. 

  176.             AND Month(call_date)=Month(now())
    177. 

  177.             GROUP BY LEFT(call_date, 10)
    178. 

  178.             ) b
    179. 

  179.           ON (a.call_date = b.call_date_1)  
    180. 

  180.         left JOIN ( 
    181. 

  181.             SELECT LEFT(recv_time, 10) AS call_date_2,
    182. 

  182.             COUNT(*) AS cnt_2, 
    183. 

  183.             IFNULL(SUM(price),0) AS price_2,
    184. 

  184.             drvno
    185. 

  185.             FROM bank_excel 
    186. 

  186.             WHERE REPLACE(REPLACE(drvno,'[',''),']','') = {$slice_mb_seq}
    187. 

  187.             AND result = '계좌이체성공' 
    188. 

  188.             AND Month(recv_time)=Month(now())
    189. 

  189.             GROUP BY LEFT(recv_time, 10) 
    190. 

  190.             ) c
    191. 

  191.           ON (RIGHT(a.drvseq,4) = REPLACE(REPLACE(c.drvno,'[',''),']',''))";
    192. 

  192.   $result = sql_query($sql);
    193. 

  193.   while ($row = sql_fetch_array($result)) {
    194. 

  194.     // 요금차이 
    195. 

  195.     $miner_price = $row['drv_cash_1'] - $row['drv_cash'];
    196. 

  196.     if ($miner_price) {
    197. 

  197.       $miner_price = $miner_price;
    198. 

  198.     } else {
    199. 

  199.       $miner_price = 0;
    200. 

  200.     }
    201. 

  201. 

  202.     $row['drv_distance'] = number_format($row['drv_distance']);
    203. 

  203.     $row['drv_cash'] = number_format($row['drv_cash']);
    204. 

  204.     $row['drv_vccash'] = number_format($row['drv_vccash']);
    205. 

  205.     $row['tollfee1'] = number_format($row['tollfee1']);
    206. 

  206.     $row['tollfee2'] = number_format($row['tollfee2']);
    207. 

  207.     $row['tollfee3'] = number_format($row['tollfee3']);
    208. 

  208.     $row['tollfee4'] = number_format($row['tollfee4']);
    209. 

  209.     $row['cnt'] = number_format($row['cnt']);
    210. 

  210.     $tollfee_a =  (int)$row['tollfee1_1'] + (int)$row['tollfee2_1'] + (int)$row['tollfee3_1'] + (int)$row['tollfee4_1'];
    211. 

  211. 

  212.     $row['drv_distance_1'] = number_format($row['drv_distance_1']);
    213. 

  213.     $row['drv_cash_1'] = number_format($row['drv_cash_1']);
    214. 

  214.     $row['drv_vccash_1'] = number_format($row['drv_vccash_1']);
    215. 

  215.     $row['tollfee1_1'] = number_format($row['tollfee1_1']);
    216. 

  216.     $row['tollfee2_1'] = number_format($row['tollfee2_1']);
    217. 

  217.     $row['tollfee3_1'] = number_format($row['tollfee3_1']);
    218. 

  218.     $row['tollfee4_1'] = number_format($row['tollfee4_1']);
    219. 

  219.     $row['cnt_1'] = number_format($row['cnt_1']);
    220. 

  220. 

  221. 

  222.     $row['a_call_date'] = iuf_hex_encode($row['call_date']);
    223. 

  223.     $a_mb_seq = iuf_hex_encode($mb_seq);
    224. 

  224.     $row['a_drv_distance'] = iuf_hex_encode($row['drv_distance']);
    225. 

  225.     $row['a_cnt'] = iuf_hex_encode($row['cnt']);
    226. 

  226.     $row['a_drv_cash'] = iuf_hex_encode($row['drv_cash']);
    227. 

  227.     $row['a_drv_vccash'] = iuf_hex_encode($row['drv_vccash']);
    228. 

  228.     $row['a_cnt_1'] = iuf_hex_encode($row['cnt_1']);
    229. 

  229.     $row['a_drv_cash_1'] = iuf_hex_encode($row['drv_cash_1']);
    230. 

  230.     $row['a_drv_vccash_1'] = iuf_hex_encode($row['drv_vccash_1']);
    231. 

  231.     $a_tollfee_a = iuf_hex_encode($tollfee_a);
    232. 

  232. 

  233. 

  234.     $option['data'] = "<tr class='iframe1_1' data-calldate='{$row['call_date']}'  data-cartype='{$cartype}'>
    235. 

  235.                         <td class='addtd1'>{$row['call_date']}</td>
    236. 

  236.                         <td class='addtd2'>{$row['drv_distance']}</td>
    237. 

  237.                         <td class='addtd3'>{$row['cnt']}</td>
    238. 

  238.                         <td class='addtd4'>{$row['drv_cash']}</td>
    239. 

  239.                         <td class='addtd5'>{$row['drv_vccash']}</td>
    240. 

  240.                         <td class='addtd6'>{$row['cnt_1']}</td>
    241. 

  241.                         <td class='addtd7'>{$row['drv_cash_1']}</td>
    242. 

  242.                         <td class='addtd8'>{$row['drv_vccash_1']}</td>
    243. 

  243.                         <td class='addtd9'>{$row['cnt_2']}</td>
    244. 

  244.                         <td class='addtd10'>{$row['price_2']}</td>
    245. 

  245.                         <td class='addtd11'></td>
    246. 

  246.                         <td class='addtd12'>{$row['tollfee1_1']}</td>
    247. 

  247.                         <td class='addtd13'>{$row['tollfee2_1']}</td>
    248. 

  248.                         <td class='addtd14'>{$row['tollfee3_1']}</td>
    249. 

  249.                         <td class='addtd15'>{$row['tollfee4_1']}</td>
    250. 

  250.                          <td>
    251. 

  251.                           <a href='./income_day_print.php?calldate={$row['a_call_date']}&drvseq={$a_mb_seq}&drv_distance={$row['a_drv_distance']}&cnt={$row['a_cnt']}&drv_cash={$row['a_drv_cash']}&drv_vccash={$row['a_drv_vccash']}&cnt_1={$row['a_cnt_1']}&drv_cash_1={$row['a_drv_cash_1']}&drv_vccash_1={$row['a_drv_vccash_1']}&tollfee_a={$a_tollfee_a}' onclick='return dayprint(this.href);' target='_blank' class='btn btn_02'>일계표</a>
    252. 

  252.                         </td>
    253. 

  253.                       </tr>";
    254. 

  254.     // $option['date'] = $row['call_date'];
    255. 

  255.     // array_push($options, preg_replace('/\r\n|\r|\n/','',$option));
    256. 

  256.     array_push($options, $option);
    257. 

  257.   }
    258. 

  258. }
    259. 

  259. 

  260. 

  261. // $output = json_encode($options, JSON_UNESCAPED_UNICODE);
    262. 

  262. print_r($options);
    263.