COMMUNITY
CS CENTER
BANK INFO
-
국민은행 000-00-00000-0
HOLDER : 예금주
-
카카오뱅크 00000-000-0000
HOLDER : 예금주
SOCIAL NETWORK
pY : : pub.u
. ic k,u .. c w1u 0 function.setTemplatePath.php i_ 8 function.GoogleGtmScriptFunc.php resu0u 0 function.showDesignFlash.php Q1u $ 0 function.assignBrandBest.php x1u + 8 function.showAllMobileVer3Depth.php
c_ 1 8 function.assignBrandBestIcon.php t'];y1u 8 8 function.showBatchGoodsData.php '', c_ > 8 function.assignBrandMenuData.php
.u E 0 function.showBrandDepth.php
T1u K 8 function.assignMypageSummaryData.php 1u R 8 function.showCategoryDepth.php $platf e X 8 function.callAccountCheckerTool.php b1u _ 8 function.showCategoryLight.php M';
V1u e 8 function.confirmLicenseLink.php $re1u k 8 function.showDesignLastest.php ferer'c_ p 0 function.dataCartCount.php Pc_ v 8 function.showDesignLightPopup.php $biU1u { 0 function.dataCouponMax.php - 1u @ function.showCategoryLightNavigation.php ess[Y1u 8 function.dataGoodsContents.php sex : 1u 0 function.showDesignPopup.php Z1u 0 function.dataGoodsImage.php [Qc_ 0 function.showDesignVideo.php [1u 0 function.dataGoodsToday.php _1u @ function.showCategoryMiniShopNavigation.php b\1u 8 function.dataGoodsTodayLight.php lic 1u 8 function.showGoodsCoupons.php r=array]1u 0 function.dataInstargram.php e1u 8 function.showCategoryNavigation.php r^1u 8 function.dataRightRecommCount.php shoRc_ 8 function.showGoodsOrderForm.php
_1u 0 function.dataWishCount.php =1u @ function.showCategoryNavigationTopBar.php ='0Ac_ 8 function.defaultScriptFunc.php irthdaSc_ 8 function.showGoodsSearchForm.php uyera1u 0 function.escrow_mark.php serI1u @ function.showCategoryPageNavigation.php 'refe,u 8 function.escrow_mark_mobile.php 'refe1u 8 function.showInstagramFeed.php _SERVE e 0 function.getBoarddata.php fm_1u 8 function.showLocationDepth.php publid1u 0 function.getChildBrand.php re1u @ function.showCategoryRecommendDisplay.php
e1u 8 function.getChildCategory.php > date(f_ 8 function.showCompareCurrency.php
f1u # 8 function.getChildLocation.php goods_s1u ) 8 function.showLocationNavigation.php aCc_ . 0 function.getCouponCode.php opKc_ 5 0 function.showCoupons.php '],
g_ ; 8 function.getFavoriteBrand.php n4' =1u B 8 function.showDesignBanner.php 'optioni1u H 8 function.getFavoriteCategory.php this~1u P 8 function.showBrandPageNavigation.php j1u W @ function.getGabiaMainBannerPannel.php y'],0,41u ^ 8 function.showDesignBannerOld.php '],
Dc_ d 8 function.getGabiaMainPannel.php erInfu1u l 0 function.returnHello.php 'nonl1u s @ function.getGabiaOpenMarketBanner.php ,
'o1u z 8 function.showDesignBroadcast.php $_SEm1u 8 function.getGabiaSkinPannel.php cart_1u 0 function.showMainTopBar.php un1u 0 function.getGoodsOptions.php 1u 8 function.showManagerAlert.php er']);
g_ 0 function.metaHeaderWrite.php Uc_ 0 function.showMapApi.php date(p1u 0 function.naverWcsScript.php '1u 8 function.showDesignDisplay.php _seq']q1u 8 function.o2oAdminMemberListRute.php v1u 8 function.scmSelectWarehouse.php o['bir1u @ function.o2oFrontMypageCouponBarcode.php 'bir1u 0 function.showMapApiInit.php uEc_ 0 function.playVideoComm.php In1u 0 function.showMycartTop.php $ts1u ( function.qrcode.php e{1u @ function.showBrandLightNavigation.php r' =>1u @ function.showBrandRecommendDisplay.php DR']
|1u @ function.showBrandMiniShopNavigation.php ams)@c_ 8 function.showDesignDisplayPaging.php }1u 8 function.showBrandNavigation.php er_u1u 8 function.showNaverMileageButton.php ,1u 0 function.showMyPromotion.php 1u @ function.showGoodsSearchFormLight.php ate fm_Tc_ @ function.showLocationLightNavigation.php quer1u @ function.showLocationRecommendDisplay.php to Vc_ # 8 function.showMobileTopForm.php =?";
1u ) 8 function.showMyMinishopLight.php
}1u . 0 function.showMypageTop.php t_1u 9 0 function.showNaverMapApi.php 1u E 0 function.showPromotion.php rt1u R 8 function.showSearchOption.php 0' ? da1u _ 8 function.showSearchRecent.php + 1 : 1u l 8 function.showSearchRecentUse.php 'sex1u y 8 function.showTopPromotion.php ['sex']1u 8 function.show_blockpage_count.php rerWc_ 0 function.snsLikeButton.php 'Lc_ 0 function.snslinkurl.php ip' Xc_ 0 function.sslAction.php ->db->c1u 0 function.sslGetHtml.php ams);1u 0 function.sslGetScript.php {
1u 0 functions.safe_mode.ini ;
1u ( object.say.php mber_s1u ( object.smartucc.php '1u 0 postfilter.arrangeSpace.php d1u 0 postfilter.removeTmpCode.php 1u 8 prefilter.addImageAttributes.php {
Zc_ @ prefilter.addImageAttributesBefore.php ;
}1u 8 prefilter.addImageLazyAttributes.php 1u # 0 prefilter.adjustPath.php Wher1u / 0 prefilter.defaultScript.php a1u ; 8 prefilter.designAreaDivision.php pdat[c_ F 0 prefilter.facebook_ver.php B1u Q 0 prefilter.parseMySyntax.php 1u 0 showMyMinishopCountLight.php
return false;
}
public function getSearchPopular($sEnd){
$query = "select keyword, sum(cnt) scnt from (select keyword, cnt from `fm_search_list` where regist_date >= ? order by regist_date DESC limit 500) t group by keyword order by scnt desc limit 10";
return $this->db->query($query,array($sEnd));
}
public function insertSearchRecent($sKeyword, $stodayTime, $iMemberSeq, $sIp){
$iRecentSeq = $this->checkKeywordRecent($sKeyword, $iMemberSeq, $sIp);
if(!$iRecentSeq){
$sQuery = "INSERT INTO fm_search_recent (`regist_date`,`update_date`,`keyword`,`member_seq`,`ip`,`cnt`) VALUES(?, ?, ?, ?, ?, 1)";
$bind = array($stodayTime, $stodayTime, $sKeyword, $iMemberSeq, $sIp);
}else{
$sQuery = "UPDATE fm_search_recent SET `update_date` = ?, `cnt` = `cnt` + 1 WHERE recent_seq = ?";
$bind = array($stodayTime, $iRecentSeq);
}
$this->db->query($sQuery, $bind);
}
public function delSearchRecent($aParams){
if( $aParams['iRecentSeq'] ){
$sQuery = "DELETE FROM fm_search_recent WHERE recent_seq = ?";
$bind = array($aParams['iRecentSeq']);
}else if( $aParams['sIp'] ){
$sQuery = "DELETE FROM fm_search_recent WHERE ip = ?";
$bind = array($aParams['sIp']);
}else if( $aParams['iMemberSeq'] ){
$sQuery = "DELETE FROM fm_search_recent WHERE member_seq = ?";
$bind = array($aParams['iMemberSeq']);
}
$this->db->query($sQuery, $bind);
}
protected function checkKeywordRecent($sKeyword, $iMemberSeq, $sIp){
$query = "select recent_seq from fm_search_recent where keyword = ? and (member_seq = ? or ip = ?)";
$bind[] = $sKeyword;
$bind[] = $iMemberSeq;
$bind[] = $sIp;
$query = $this->db->query($query, $bind);
if($query) $row = $query->row_array();
return $row['recent_seq'];
}
public function check_search_keyword($keyword,$today){
$query = "select list_seq from fm_search_list where keyword = ? and regist_date=?";
$bind[] = $keyword;
$bind[] = $today;
$query = $this->db->query($query,$bind);
if($query) $row = $query->row_array();
return $row['list_seq'];
}
public function last_year_delete()
{
$timestamp = strtotime('-1 year');
$bind_date[] = date('Y-m-t 00:00:00',$timestamp);
/*
$query = "delete from fm_order_stats where regist_date < ?";
$this->db->query($query,$bind_date);
*/
$query = "delete from fm_cart_stats where regist_date < ?";
$this->db->query($query,$bind_date);
$query = "delete from fm_wish_stats where regist_date < ?";
$this->db->query($query,$bind_date);
$query = "delete from fm_search_stats where regist_date < ?";
$this->db->query($query,$bind_date);
//debug_var($this->db->queries);
}
// 상품 장바구니 통계 ( 상품기준 - 순위 추출 )
public function get_goods_cart_stats($params){
if($params) {
foreach($params as $k => $v){
$$k = $v;
}
}
// 날짜검색
/* SQL INJECTION 방지를 위한 데이터 바인딩 처리 */
$bindData = [];
if (!empty($sdate) && !empty($edate)) {
$addWhere .= " AND cs.stats_date >= ? " . " AND cs.stats_date <= ? ";
$bindData[] = $sdate;
$bindData[] = $edate;
} elseif (empty($sdate) && !empty($edate)) {
$addWhere .= " AND cs.stats_date <= ? ";
$bindData[] = $edate;
} elseif (!empty($sdate) && empty($edate)) {
$addWhere .= " AND cs.stats_date >= ? ";
$bindData[] = $sdate;
}
// 상품명 검색
if (!empty($keyword)){
$addWhere .= " AND cs.goods_name like '%".addslashes($keyword)."%' ";
}
// 카테고리 검색
if (!empty($category1)){
$category_code = max(array($category1,$category2,$category3,$category4));
$addWhere .= " AND gcl.category_code = '".$category_code."' ";
$addFrom .= "LEFT JOIN fm_category_link AS gcl ON cs.goods_seq = gcl.goods_seq ";
}
// 브랜드 검색
if (!empty($brands1)){
$brandCode = max(array($brands1,$brands2,$brands3,$brands4));
$addWhere .= " AND gbl.category_code = '".$brandCode."' ";
$addFrom .= "LEFT JOIN fm_brand_link AS gbl ON cs.goods_seq = gbl.goods_seq ";
}
// 입점사 검색
if (!empty($provider_seq) && $provider_seq > 1){
$addWhere .= " AND g.provider_seq = '".$provider_seq."' ";
}
// 정렬
$orderBy = " ORDER BY goods_cnt desc, goods_name";
if ($order_by == 'users'){
$orderBy = " ORDER BY goods_user_cnt desc, goods_name";
}
$sql = "SELECT *
FROM (
SELECT
cs.goods_seq as goods_seq,
cs.goods_name as goods_name,
SUM(IFNULL(cs.option_ea,0)) as goods_ea,
SUM(IFNULL(cs.option_user_ea,0)) as goods_user_ea,
SUM(IFNULL(cs.option_cnt,0)) as goods_cnt,
SUM(IFNULL(cs.option_user_cnt,0)) as goods_user_cnt,
g.page_view as page_view,
g.review_count as now_review_cnt,
IF(cs.goods_seq,(select count(*) from fm_cart where goods_seq = cs.goods_seq),0) as now_cart_cnt,
IF(cs.goods_seq,(select count(*) from fm_goods_wish where goods_seq = cs.goods_seq),0) as now_wish_cnt,
IF(cs.goods_seq,(select count(*) from (select count(*), goods_seq from fm_goods_fblike where member_seq>0 group by goods_seq, member_seq) tmp where goods_seq = cs.goods_seq group by goods_seq),0) as now_like_cnt,
IF(cs.goods_seq,(select count(*) as cnt from fm_goods_restock_notify where goods_seq=cs.goods_seq and notify_status='none' group by goods_seq),0) as now_restock_cnt
FROM
fm_accumul_cart_stats as cs
LEFT JOIN fm_goods as g
ON cs.goods_seq = g.goods_seq
".$addFrom."
WHERE
cs.goods_seq > 0
".$addWhere."
GROUP BY
cs.goods_seq ) tmp
ORDER BY
goods_cnt desc, goods_seq
LIMIT 100";
return $this->db->query($sql, $bindData);
}
// 옵션 장바구니 통계 ( 상품 하위 옵션 정보 추출 )
public function get_option_cart_stats($params){
if ($params) {
foreach($params as $k => $v) {
$$k = $v;
}
}
// 상품고유번호 검색
if ($goods_seq > 0) {
$addWhere .= " AND cs.goods_seq = '".$goods_seq."' ";
}
// 날짜검색
/* SQL INJECTION 방지를 위한 데이터 바인딩 처리 */
$bindData = [];
if (!empty($sdate) && !empty($edate)){
$addWhere .= " AND cs.stats_date >= ? " . " AND cs.stats_date <= ? ";
$bindData[] = $sdate;
$bindData[] = $edate;
}elseif (empty($sdate) && !empty($edate)){
$addWhere .= " AND cs.stats_date <= ? ";
$bindData[] = $edate;
}elseif (!empty($sdate) && empty($edate)){
$addWhere .= " AND cs.stats_date >= ? ";
$bindData[] = $sdate;
}
$sql = "SELECT
cs.option1 as option1,
cs.option2 as option2,
cs.option3 as option3,
cs.option4 as option4,
cs.option5 as option5,
SUM(cs.option_ea) as option_ea,
SUM(cs.option_user_ea) as option_user_ea,
SUM(cs.option_cnt) as option_cnt,
SUM(cs.option_user_cnt) as option_user_cnt,
gs.stock as stock,
gs.badstock as badstock,
gs.reservation15 as reservation15,
gs.reservation25 as reservation25
FROM
fm_accumul_cart_stats as cs
LEFT JOIN fm_goods_option as go
ON ( cs.goods_seq = go.goods_seq and cs.option1 = go.option1 and cs.option2 = go.option2 and cs.option3 = go.option3 and cs.option4 = go.option4 and cs.option5 = go.option5 )
LEFT JOIN fm_goods_supply as gs
ON go.option_seq = gs.option_seq
WHERE
cs.goods_seq > 0
".$addWhere."
GROUP BY
cs.goods_seq, cs.option1, cs.option2, cs.option3, cs.option4, cs.option5
ORDER BY
cs.goods_name, cs.option1, cs.option2, cs.option3, cs.option4, cs.option5 ";
return $this->db->query($sql, $bindData);
}
public function get_goods_wish_stats($params){
if($params) {
foreach($params as $k => $v) {
$$k = $v;
}
}
/* SQL INJECTION 방지를 위한 데이터 바인딩 처리 */
$bindData = [];
if (!empty($sdate) && !empty($edate)){
$addWhere .= " and ws.regist_date >= ? " . " and ws.regist_date <= ? ";
$bindData[] = $sdate." 00:00:00";
$bindData[] = $edate." 23:59:59";
} elseif (empty($sdate) && !empty($edate)) {
$addWhere .= " and ws.regist_date <= ? ";
$bindData[] = $edate." 23:59:59";
} elseif (!empty($sdate) && empty($edate)) {
$addWhere .= " and ws.regist_date >= ? ";
$bindData[] = $sdate." 00:00:00";
}
##
if (!empty($provider_seq)) {
$addWhere .= " and ws.provider_seq = '".$provider_seq."' ";
}
##
if (!empty($keyword)) {
$addWhere .= " and ws.goods_name like '%".addslashes($keyword)."%' ";
}
##
if (!empty($category1)) {
$category_code = max(array($category1,$category2,$category3,$category4));
$addWhere .= " and gcl.category_code = '".$category_code."' ";
$addFrom .= "LEFT JOIN fm_category_link as gcl on ws.goods_seq = gcl.goods_seq ";
}
##
if (!empty($brands1)) {
$brandCode = max(array($brands1,$brands2,$brands3,$brands4));
$addWhere .= " and gbl.category_code = '".$brandCode."' ";
$addFrom .= "LEFT JOIN fm_brand_link as gbl on ws.goods_seq = gbl.goods_seq ";
}
##
$orderBy = " order by wss.goods_cnt desc, ws.goods_name";
if ($order_by == 'users'){
$orderBy = " order by wss2.user_cnt desc, ws.goods_name";
}
$query = "select
ws.goods_seq as goods_seq,
ws.goods_name as stat_goods_name,
wss.goods_cnt as goods_cnt,
wss2.user_cnt as user_cnt,
gs.tstock as tstock,
gs.tbadstock as tbadstock,
gs.treservation15 as treservation15,
gs.treservation25 as treservation25,
g.page_view as page_view,
g.review_count as now_review_cnt,
IF(ws.goods_seq,(select count(*) from fm_cart where goods_seq = ws.goods_seq),0) as now_cart_cnt,
IF(ws.goods_seq,(select count(*) from fm_goods_wish where goods_seq = ws.goods_seq),0) as now_wish_cnt,
IF(ws.goods_seq,(select count(*) from (select count(*), goods_seq from fm_goods_fblike where member_seq>0 group by goods_seq, member_seq) tmp where goods_seq = ws.goods_seq group by goods_seq),0) as now_like_cnt,
IF(ws.goods_seq,(select count(*) as cnt from fm_goods_restock_notify where goods_seq=ws.goods_seq and member_seq>0 and notify_status='none' group by goods_seq),0) as now_restock_cnt
from
fm_wish_stats as ws
INNER JOIN (select count( * ) as goods_cnt, goods_name FROM fm_wish_stats group by goods_name) as wss
on ws.goods_name = wss.goods_name
LEFT JOIN (select count(*) as user_cnt, goods_name from (select goods_name, userid from fm_wish_stats where userid is not null group by goods_name, userid) as tmp group by goods_name) as wss2
on ws.goods_name = wss2.goods_name
LEFT JOIN fm_goods as g
on ws.goods_seq = g.goods_seq
LEFT JOIN (select goods_seq, sum(stock) as tstock, sum(badstock) as tbadstock, sum(reservation15) as treservation15, sum(reservation25) as treservation25 FROM fm_goods_supply group by goods_seq) as gs
on g.goods_seq = gs.goods_seq
".$addFrom."
where
ws.wish_stats_seq > 0
".$addWhere."
group by
ws.goods_name
".$orderBy."
limit 0, 100";
return $this->db->query($query, $bindData);
}
public function get_goods_search_stats($params){
if ($params) {
foreach($params as $k => $v) {
$$k = $v;
}
}
/* SQL INJECTION 에 의한 쿼리 바인딩 처리 */
##
$bindData = [];
if (!empty($sdate) && !empty($edate)) {
$addWhere .= " and regist_date >= ? ". " and regist_date <= ? ";
$bindData[] = $sdate." 00:00:00";
$bindData[] = $edate." 23:59:59";
}elseif (empty($sdate) && !empty($edate)){
$addWhere .= " and regist_date <= ? ";
$bindData[] = $edate." 23:59:59";
}elseif (!empty($sdate) && empty($edate)){
$addWhere .= " and regist_date >= ? ";
$bindData[] = $sdate." 00:00:00";
}
##
if (!empty($keyword)) {
$addWhere .= " and keyword like '%".addslashes($keyword)."%' ";
}
$query = "
select
keyword, count(*) keyword_cnt from fm_search_stats
where
search_stats_seq > 0
".$addWhere."
group by keyword
order by keyword_cnt desc
limit 0, 100";
return $this->db->query($query, $bindData);
}
public function get_goods_search_by_age($keyword,$period)
{
$start = date('Y-m-d',strtotime('-'.$period.' days'))." 00:00:00";
$query = "select IF(ISNULL(userid),'NONE','MEMBER') AS member_check,age,count(*) cnt from fm_search_stats where keyword=? and regist_date>=? group by member_check, age";
return $this->db->query($query,array($keyword,$start));
}
public function get_goods_search_by_sex($keyword,$period)
{
$start = date('Y-m-d',strtotime('-'.$period.' days'))." 00:00:00";
$query = "select IF(ISNULL(userid),'NONE','MEMBER') AS member_check,sex,count(*) cnt from fm_search_stats where keyword=? and regist_date>=? group by member_check,sex";
return $this->db->query($query,array($keyword,$start));
}
public function get_goods_search_by_date($keyword,$period)
{
$start = date('Y-m-d',strtotime('-'.$period.' days'))." 00:00:00";
$query = "
select * from (
select substring(regist_date,1,10) regist_date,count(*) cnt from fm_search_stats where keyword=? and regist_date>=? group by substring(regist_date,1,10)
) t order by t.cnt desc limit 5
";
return $this->db->query($query,array($keyword,$start));
}
public function get_goods_search_paging_by_date($keyword='', $start='', $end='', $page=1)
{
$this->db->select('*')->from('fm_search_stats');
if ($keyword) {
$this->db->where('keyword',$keyword);
}
if( $start ){
$start = $start." 00:00:00";
$this->db->where('regist_date >= ', $start);
}
if( $end ){
$end = $end." 23:59:59";
$this->db->where('regist_date <= ', $end);
}
$query = $this->db->get();
$query = $this->db->last_query();
// paging (페이지당출력수,현재페이지넘버,페이지숫자링크갯수,쿼리,인자)
$this->blockpage->bind_not = true;
$result = select_page(10,$page,10,$query);
$this->blockpage->bind_not = false;
return $result;
}
public function get_goods_review_stats($params){
if ($params) {
foreach($params as $k => $v) {
$$k = $v;
}
}
/* SQL INJECTION 에 의한 쿼리 바인딩 처리 */
##
$bindData = [];
if (!empty($sdate) && !empty($edate)) {
$addWhere2 .= " and r_date >= ? " . " and r_date <= ? ";
$bindData[] = $sdate." 00:00:00";
$bindData[] = $edate." 23:59:59";
} elseif (empty($sdate) && !empty($edate)){
$addWhere2 .= " and r_date <= ? ";
$bindData[] = $edate." 23:59:59";
} elseif (!empty($sdate) && empty($edate)){
$addWhere2 .= " and r_date >= ? ";
$bindData[] = $sdate." 00:00:00";
}
##
if (!empty($keyword)) {
$addWhere .= " and g.goods_name like '%".addslashes($keyword)."%' ";
}
##
if (!empty($category1)) {
$category_code = max(array($category1,$category2,$category3,$category4));
$addWhere .= " and gcl.category_code = '".$category_code."' ";
$addFrom .= "LEFT JOIN fm_category_link as gcl on g.goods_seq = gcl.goods_seq ";
}
##
if (!empty($brands1)) {
$brandCode = max(array($brands1,$brands2,$brands3,$brands4));
$addWhere .= " and gbl.category_code = '".$brandCode."' ";
$addFrom .= "LEFT JOIN fm_brand_link as gbl on g.goods_seq = gbl.goods_seq ";
}
##
if (!empty($provider_seq)){
$addWhere .= " and g.provider_seq = '".$provider_seq."' ";
}
$query = "select
g.goods_seq as goods_seq,
g.goods_name as stat_goods_name,
gr.reviewCnt as review_cnt,
gs.tstock as tstock,
gs.tbadstock as tbadstock,
gs.treservation15 as treservation15,
gs.treservation25 as treservation25,
g.page_view as page_view,
g.review_count as now_review_cnt,
(select count(*) from fm_cart where goods_seq = g.goods_seq) as now_cart_cnt,
(select count(*) from fm_goods_wish where goods_seq = g.goods_seq) as now_wish_cnt,
(select count(*) from (select count(*), goods_seq from fm_goods_fblike where member_seq>0 group by goods_seq, member_seq) tmp where goods_seq = g.goods_seq group by goods_seq) as now_like_cnt,
(select count(*) as cnt from fm_goods_restock_notify where goods_seq=g.goods_seq and member_seq>0 and notify_status='none' group by goods_seq) as now_restock_cnt
from
fm_goods as g
INNER JOIN (select count(*) reviewCnt, goods_seq from fm_goods_review
where length(goods_seq) > 0 ".$addWhere2." group by goods_seq ) as gr
on (INSTR(gr.goods_seq, CONCAT(g.goods_seq, ',')) or
INSTR(gr.goods_seq, CONCAT(',', g.goods_seq)) or
gr.goods_seq = g.goods_seq)
LEFT JOIN (select goods_seq, sum(stock) as tstock, sum(badstock) as tbadstock, sum(reservation15) as treservation15, sum(reservation25) as treservation25 FROM fm_goods_supply group by goods_seq) as gs
on g.goods_seq = gs.goods_seq
".$addFrom."
where
g.goods_seq > 0
".$addWhere."
group by g.goods_seq
order by gr.reviewCnt desc
limit 0, 100";
return $this->db->query($query, $bindData);
}
public function get_goods_restock_stats($params){
if($params) {
foreach($params as $k => $v) {
$$k = $v;
}
}
##
/* SQL INJECTION 에 의한 쿼리 바인딩 처리 */
$bindData = [];
if (!empty($sdate) && !empty($edate)) {
$addWhere .= " and grn.regist_date >= ? " . " and grn.regist_date <= ? ";
$bindData[] = $sdate." 00:00:00";
$bindData[] = $edate." 23:59:59";
}elseif (empty($sdate) && !empty($edate)) {
$addWhere .= " and grn.regist_date <= ? ";
$bindData[] = $edate." 23:59:59";
}elseif (!empty($sdate) && empty($edate)){
$addWhere .= " and grn.regist_date >= ? ";
$bindData[] = $sdate." 00:00:00";
}
##
if (!empty($provider_seq)) {
$addWhere .= " and g.provider_seq = '".$provider_seq."' ";
}
##
if (!empty($keyword)) {
$addWhere .= " and g.goods_name like '%".addslashes($keyword)."%' ";
}
##
if (!empty($category1)) {
$category_code = max(a
COPYRIGHT (c) (주)회사명 ALL RIGHTS RESERVED.
