$sql = " select * from g1_guin a, pay_order b where 1=1 and a.gu_id_add = '0' and a.od_id = b.od_id and (b.od_status = '결제완료') and a.mb_id = '{$member['mb_id']}' ";
$result = sql_query($sql);
$max_cnt = 0;
$end_cnt = 0;
$all_cnt = 0;
for($i=0; $row=sql_fetch_array($result); $i++){
$all_cnt++;
$max_date = "";
for($j=1; $j<=11; $j++ ){
if($max_date < $row['gu_opt_date'.$j]){
$max_date = $row['gu_opt_date'.$j];
}
}
if($max_date >= date('Y-m-d')){
$max_cnt++;
}
if($max_date < date('Y-m-d')){
$end_cnt++;
}
}
$all_qry = sql_fetch("select count(*)as cnt from g1_guin a, pay_order b where 1=1 and a.gu_id_add = '0' and a.od_id = b.od_id and a.mb_id = '{$member[mb_id]}' ");
$all_cnt = $all_qry['cnt'];
$sql_min = " select count(*) cnt from g1_guin a, pay_order b where 1=1 and a.gu_id_add = '0' and a.od_id = b.od_id and (b.od_status = '주문') and a.mb_id = '{$member['mb_id']}' and b.od_method != '신용카드' ";
$row_min = sql_fetch($sql_min);
?>
 |
업체 로그인 |
 |
업체 회원가입 |
+ 실시간 대출문의
서비스 안내
이용안내
광고안내
고객지원
공지사항
자주묻는 질문
1:1 문의
광고/제휴 문의