죽전&평촌점 환불자 명단 바로가기
"; } if(C_LEVEL != 1) exit; if(C_ORGINUID == 'ydworld03' || C_ORGINUID == 'ydworld' || C_ORGINUID == 'ydworld31') echo "키즈랜드 통계받기"; ?>
업체별 사용처리 현황 q("select * from (select api_channel,max(regdate) as regdate from use_barcode_list where api_channel is not null && api_channel != '' group by api_channel) a order by regdate desc"); while($list = $db->fa($sql)){?>
업체API 최근날짜


최근에러 내용 q("select * from local_pc_chk_send"); while($list = $db->fa($sql)){?>
에러 메세지 최근날짜
처리완료


자동 예약 에러건 q("select b.* from social_bearstown_info_yet_detail a inner join barcode b on b.barcode = a.package_barcode inner join social_bearstown_info c on c.barcode = a.package_barcode where a.status in (1,2) && b.status != 4 && a.regdate <= date_add(now(),interval -10 minute) group by a.order_num"); while($list = $db->fa($sql)){?>
주문번호 티켓번호 구매자 정보 구매옵션 구매날짜
()


구글 번역 에러 q("select * from language_translation_status where nType = 'language_status' && status = 'N'"); while($list = $db->fa($sql)){?>
에러 메세지 최근날짜
처리완료


최근 객실 예약 현황(전체보기) q("select a.*,b.buy_date,b.channel_name,b.buy_name,b.buy_hp,c.product_option,d.social_use_status,d.social_use_confirm_admin_id,d.social_use_confirm_admin_name,d.social_use_updatetime from social_bearstown_info a inner join pos_master b on b.order_num = a.order_num inner join barcode c on c.barcode = a.package_barcode left join social_bearstown_info_etc d on d.barcode = a.barcode where a.uid = 'withcoupang' && a.resno is not null order by b.buy_date desc limit 30"); while($list = $db->fa($sql)){ $memo_status = ""; if($list[social_use_status] == "Y") $memo_status = "{$list[social_use_confirm_admin_id]}
{$list[social_use_confirm_admin_name]}
{$list[social_use_updatetime]}"; else $memo_status = "처리하기"; ?>
주문번호 주문자명 주문자번호 내부티켓
(예약번호)
예약날짜 구매시간 채널 구매옵션명 비고1

()
()


자동 예약 오류건 현황 (강제실행) q("select a.start_date,a.status,a.error_msg,c.* from social_bearstown_info_yet_detail a inner join barcode_detail b on b.barcode = a.package_barcode inner join product_option_detail d on d.idx = b.product_option_detail_idx inner join barcode c on c.barcode = a.package_barcode where a.status in (1,2) && d.opt2 = 'stay'"); while($list = $db->fa($sql)){ $status = ""; if(status == 1) $status = "예약대기중"; else if(status == 1) $status = "예약처리중"; ?>
주문번호 주문자명 주문자번호 내부티켓
(예약번호)
예약날짜 구매시간 채널 구매옵션명 에러메세지
()



전날 사용 현황(매출DB 증축 관련 TEST) = "2021-01-01 00:00:00" group by a.company_list_idx,a.company_branch_list_idx,a.company_upjang_list_idx,a.use_uid,left(a.use_date,10) 2. 테스트 입력 insert into company_calculate_item_list(open_date,company_list_idx,company_branch_list_idx,company_upjang_list_idx,use_uid,master_option_idx,use_count) select DATE_FORMAT(a.use_date,'%Y-%m-%d'),a.company_list_idx,a.company_branch_list_idx,a.company_upjang_list_idx,a.use_uid,a.master_option_idx,count(*) from barcode_detail a inner join master_option b on b.idx = a.master_option_idx where a.status = 'Y' && a.use_date >= "2021-01-01 00:00:00" group by a.company_list_idx,a.company_branch_list_idx,a.company_upjang_list_idx,a.use_uid,left(a.use_date,10),a.master_option_idx */ $sql = $db->q("select a.company_list_idx,DATE_FORMAT(a.open_date,'%Y-%m-%d') as open_date,sum(a.total_sell_price) as total_sell_price,sum(a.total_buy_price) as total_buy_price,b.title as company_list_title from company_calculate_price_list a inner join company_list b on b.idx = a.company_list_idx where a.open_date between DATE_FORMAT(CURDATE() - INTERVAL 1 DAY,'%Y-%m-%d 00:00:00') and now() group by a.open_date,a.company_list_idx order by total_sell_price desc"); $total_sell_price_sum = 0; $total_buy_price_sum = 0; $tr_barcode_bg = ""; $calculate_data = ""; while($list = $db->fa($sql)){ $date_chk = ($list[open_date] == date("Y-m-d") ? "today" : "yesterday"); $calculate_data[$list[company_list_idx]][$date_chk][total_sell_price] = $list[total_sell_price]; $calculate_data[$list[company_list_idx]][$date_chk][total_buy_price] = $list[total_buy_price]; $calculate_info[$list[company_list_idx]]["title"] = $list[company_list_title]; } foreach($calculate_data as $key => $val){ if($tr_barcode_bg == "#bbdefb") $tr_barcode_bg = "#e3f2fd"; else $tr_barcode_bg = "#bbdefb"; $total_yesterday_sell_price_sum += $calculate_data[$key]["yesterday"][total_sell_price]; $total_yesterday_buy_price_sum += $calculate_data[$key]["yesterday"][total_buy_price]; $total_today_sell_price_sum += $calculate_data[$key]["today"][total_sell_price]; $total_today_buy_price_sum += $calculate_data[$key]["today"][total_buy_price]; ?>
업체명 전날 당일
판매가 입금가(매입가) 판매가 입금가(매입가)