죽전&평촌점 환불자 명단 바로가기
";
}
if(C_LEVEL != 1) exit;
if(C_ORGINUID == 'ydworld03' || C_ORGINUID == 'ydworld' || C_ORGINUID == 'ydworld31') echo "키즈랜드 통계받기";
?>
업체별 사용처리 현황
| 업체API |
최근날짜 |
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)){?>
|
|
최근에러 내용
| 에러 메세지 |
최근날짜 |
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)){?>
|
처리완료 |
최근 객실 예약 현황(전체보기)
| 주문번호 |
주문자명 |
주문자번호 |
내부티켓
(예약번호) |
예약날짜 |
구매시간 |
채널 |
구매옵션명 |
비고1 |
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 = "처리하기";
?>
|
|
|
() |
|
|
() |
|
|
자동 예약 오류건 현황 (강제실행)
| 주문번호 |
주문자명 |
주문자번호 |
내부티켓
(예약번호) |
예약날짜 |
구매시간 |
채널 |
구매옵션명 |
에러메세지 |
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];
?>
|
|
|
|
|
|
|
|
|
|