include ("./header.php");
include $_SERVER[DOCUMENT_ROOT] . "/module/shop/shop.lib.php";
include $_SERVER[DOCUMENT_ROOT] . "/module/member/member.lib.php";
include $_SERVER[DOCUMENT_ROOT] . "/module/shop/review/review.lib.php";
include $_SERVER[DOCUMENT_ROOT] . "/module/board/board.lib.php";
include $_SERVER[DOCUMENT_ROOT] . "/module/log/log.lib.php";
include $_SERVER[DOCUMENT_ROOT] . "/module/one_to_one/one_to_one.lib.php";
//DB연결
$dblink = SetConn($_conf_db["main_db"]);
$yesterday = date("Y-m-d",mktime(0,0,0,date("m"),date("d")-1,date("Y")));
$yesterday6 = date("Y-m-d",mktime(0,0,0,date("m"),date("d")-6,date("Y")));
$monthFirst = date("Y-m")."-01";
$_REQUEST[sh_date] = "order_date";
$_REQUEST[pay_opt]="A";
$arrList = getArticleList($_conf_tbl["board_info"], $scale, $_REQUEST[offset], "");
//$arrBoardNoticeList = getBoardListBaseNMemoCnt("notice", "", "", "", "4", 0); //공지사항
/*
$arrOneList = getOneToOneListAll("", "", "4", 0); //1:1문의
$arrBoardAfterList = getBoardListBaseNMemoCnt("after", "", "", "", "4", 0); //이용후기
$arrBoardQnaList = getBoardListBaseNMemoCnt("qna", "", "", "", "4", 0); //상품문의
//1:1 미답변 시작
$arrOneMiList = getOneToOneListAll("st", "N", "4", 0);
if($arrOneMiList['list']['total'] > 0):
for ($i=0;$i<$arrOneMiList['list']['total'];$i++) {
$sql = "insert into tbl_board_admin_tmp values ('one', '/backoffice/module/one_to_one/one_to_one_info.php?idx=','".$arrOneMiList['list'][$i]['idx']."','".$arrOneMiList['list'][$i]['subject']."','".$arrOneMiList['list'][$i]['wdate']."');";
$rs = mysql_query($sql, $GLOBALS[dblink]);
}
endif;
//1:1 미답변 끝
//qna 미답변 시작
$arrQnaMiList = getBoardListMiQna("qna", "", "", "", "4", 0);
if($arrQnaMiList['list']['total'] > 0):
for ($i=0;$i<$arrQnaMiList['list']['total'];$i++) {
$sql = "insert into tbl_board_admin_tmp values ('qna', '/backoffice/module/board/board_view.php?boardid=qna&mode=view&idx=','".$arrQnaMiList['list'][$i]['idx']."','".$arrQnaMiList['list'][$i]['subject']."','".$arrQnaMiList['list'][$i]['wdate']."');";
$rs = mysql_query($sql, $GLOBALS[dblink]);
}
endif;
//qna 미답변 끝
$arrMiList = getListByTbl("tbl_board_admin_tmp", " order by wdate desc"); //미답변게시판
*/
if(!$_REQUEST[cal_date]){
$cal_date = date("Y-m-d");
}else{
$cal_date = $_REQUEST[cal_date];
}
//날짜를 - 구분자로 배열로 만듬
$arrDate = explode("-",$cal_date);
$arrSolarCalendar = getDiarySet(intval($arrDate[0]), intval($arrDate[1]), intval($arrDate[2]));
$arrBoardList = getBoardListSchedule("schedule", $arrSolarCalendar[first_before], $arrSolarCalendar[last_after]);
//DB해제
//SetDisConn($dblink);
?>
include "admin_info.php"; ?>
관리자메인
- 접속현황
if(in_array("shop_accounts_manage", $arrayMyMenu) && (in_array("shop_accounts_manage",$_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["AUTH"]) || $_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["GRADE"]=="ROOT")){?>
- 매출현황
}?>
if(in_array("member_manage", $arrayMyMenu) && (in_array("member_manage",$_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["AUTH"]) || $_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["GRADE"]=="ROOT")){?>
- 회원현황
}?>
if(in_array("shop_accounts_manage", $arrayMyMenu) && (in_array("shop_accounts_manage",$_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["AUTH"]) || $_SESSION[$_SITE["DOMAIN"]]["ADMIN"]["GRADE"]=="ROOT")){?>
쇼핑몰 현황
| 날짜 |
매출액 |
주문건수 |
입금대기 |
입금확인 |
배송중 |
거래완료 |
for($i=0; $i<7; $i++) {
$j = 6-$i;
$ldate[$i] = date("Y-m-d", mktime(0, 0, 0, date("m"), date("d")-$j, date("Y")));
$arrMoney[$i] = getAccountStatus($ldate[$i], $ldate[$i]);
$totalMoney += $arrMoney[$i]['list_sum'][pay_amount];
$arrOrder[$i] = getOrderListAdmin("", "", $ldate[$i], $ldate[$i], "", 0, 0);
$totalOrder += $arrOrder[$i][total];
$arrOrder1[$i] = getOrderListAdmin("", "", $ldate[$i], $ldate[$i], "1", 0, 0);
$totalOrder1 += $arrOrder1[$i][total];
$arrOrder6[$i] = getOrderListAdmin("", "", $ldate[$i], $ldate[$i], "6", 0, 0);
$totalOrder6 += $arrOrder6[$i][total];
$arrOrder8[$i] = getOrderListAdmin("", "", $ldate[$i], $ldate[$i], "8", 0, 0);
$totalOrder8 += $arrOrder8[$i][total];
$arrOrder9[$i] = getOrderListAdmin("", "", $ldate[$i], $ldate[$i], "9", 0, 0);
$totalOrder9 += $arrOrder9[$i][total];
?>
>
| =str_replace("-","월 ",substr($ldate[$i],5,5))?>일 =$i=="6"?" (금일)":""?> |
=number_format($arrMoney[$i]['list_sum'][pay_amount])?>원 |
=number_format($arrOrder[$i][total])?>건 |
=number_format($arrOrder1[$i][total])?>건 |
=number_format($arrOrder6[$i][total])?>건 |
=number_format($arrOrder8[$i][total])?>건 |
=number_format($arrOrder9[$i][total])?>건 |
}
//DB해제
SetDisConn($dblink);
?>
| 합계 |
=number_format($totalMoney)?>원 |
=number_format($totalOrder)?>건 |
=number_format($totalOrder1)?>건 |
=number_format($totalOrder6)?>건 |
=number_format($totalOrder8)?>건 |
=number_format($totalOrder9)?>건 |
}?>
//DB연결
$dblink = SetConn($_conf_db["main_db"]);
if($arrList['list']['total'] > 0){
for ($i=0;$i<$arrList['list']['total'];$i++) {
$arrBoardList = getBoardListBase($arrList['list'][$i]['boardid'], "", "", "", "4", 0); //공지사항
?>
=$arrList['list'][$i]['boardname']?>
if(($i+1)%4==0){
echo "
";
}
}}
?>
//DB연결
$dblink = SetConn($_conf_db["main_db"]);
$sql = "delete from tbl_board_admin_tmp";
$rs = mysql_query($sql, $GLOBALS[dblink]);
//DB해제
SetDisConn($dblink);
include ("./footer.php"); ?>