ÿØÿà JFIF ` ` ÿþ
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/ticket/ |
Upload File : |
<? include "../include/top_iframe.html"; // 히스 토리저장 $sql = "select * from TB_TICKET_HISTORY where ticket_seq = '{$ticket_seq}' order by ins_dt asc "; function getFieldNm($field){ $field_nm = array( 'group_code' => '그룹코드', 'rsv_no' => '예약번호', 'mb_id' => '회원ID', 'mb_id' => '회원ID', 'ticket_nm' => '티켓명', 'ticket_status' => '티켓상태', 'ti_generation' => '구분', 'ti_send_hp' => '바우처 수신 번호', 'ti_send_type' => '바우처 발송방법', 'ti_send_method' => '바우처 발송수단', 'ti_valid_start' => '유효기간 시작일', 'ti_valid_end' => '유효기간 종료일', 'ti_reserve_dt' => '예약일', 'ti_send_dt' => '발송일', 'ti_use_dt' => '사용일', 'ti_cust_nm' => '고객명', 'ti_cust_hp' => '고객휴대폰', 'ti_memo' => '메모', 'ticket_number' => '티켓번호', 'producer_id' => '공급처', ); if($field_nm[$field]){ return $field_nm[$field]; } else { return $field; } } $rs = db_query($sql); while($row=db_fetch_array($rs)) { $after = json_decode($row['ti_history_data'], true); // 초기등록 if($before == ''){ $before = $after; foreach($after as $hk => $hv){ if(in_array($hk, array('edit_id','edit_dt','ins_id', 'ins_dt', 'seq', 'del_flag'))){ continue; } if($hv =='' || $hv=='0000-00-00' || $hv=='0000-00-00 00:00:00'){ continue; } $difference[] .= getFieldNm($hk) . ' : ' . $hv; } // 이력비교 } else { $difference = array(); foreach($after as $hk => $hv){ if(in_array($hk, array('edit_id','edit_dt','seq'))){ continue; } if($before[$hk] != $hv){ $difference[] .= getFieldNm($hk) . ' : ' . $hv; } } } $row['history_str'] = implode("<br>", $difference); $before = $after; $data[] = $row; } $data = array_reverse($data); ?> <div class="iframe ma0"> <div class="popbox"> <!-- 본문 --> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="setting_write2"> <colgroup> <col width="5%" /> <col width="17%" /> <col /> <col width="15%" /> </colgroup> <thead> <th>No.</th> <th>내역</th> <th>수정내용</th> <th>일시</th> </thead> <tbody> <? $n=count($data); foreach($data as $v){ ?> <tr> <td><?=$n?></td> <td><?=$v['ti_history_nm']?></td> <td style="background-color:#fffae5; text-align:left;"> <?=$v['history_str']?> </td> <td> <?=$v['ins_id']?><br> <?=$v['ins_dt']?> </td> </tr> <? $n--; } ?> </tbody> </table> </div> </div> <!-- /본문 --> <? include "../include/footer_iframe.html"; ?>