include_once("_common.php"); include_once(G5_PATH."/_head.php"); include_once(G5_EDITOR_LIB); $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); ?>
마이페이지