Re: 배송처리 개발 php 복잡한거 그냥 쿼리로 해결
if($R['delivery']=='1') {//배숭중인경우에
if($R['site']=='1') { //국문
if((strtotime($delivery_date) - strtotime($R['delivery_date']."+3 days")) > 0) {//3일이 지났다면
db_query("update @@@@@ set delivery ='2' where uid = '".$R['uid']."' " , $DB_CONNECT);
}
}
if($Delivery_tmp['site']=='4') { //영문
if((strtotime($delivery_date) - strtotime($R['delivery_date']."+30 days")) > 0) {//30일이 지났다면
db_query("update @@@@@ set delivery ='2' where uid = '".$R['uid']."' " , $DB_CONNECT);
}
}
}
php 코드 제어 없이 sql 한방으로는
db_query("update @@@@@ set delivery = '2' where site='1' and delivery = '1' and cast(delivery_date as unsigned) < '".date("YmdHis", strtotime("-3 days"))."'", $DB_CONNECT);
db_query("update @@@@@ set delivery = '2' where site='1' and delivery = '1' and cast(delivery_date as unsigned) < '".date("YmdHis", strtotime("-30 days"))."'", $DB_CONNECT);