query('SELECT * FROM lrlz_order WHERE pd_amount=0 AND LENGTH(bonus_rate) > 0 AND add_time > UNIX_TIMESTAMP(DATE (\'2017-09-28 00:00:00\')) AND order_state = 0'); if(empty($items)) return; foreach ($items as $item) { $order_sn = $item['order_sn']; $member_id = intval($item['buyer_id']); account_helper::order_cancel($order_sn,$member_id,true); } } public function init_commentsOp() { $mod = Model('goods'); $i = 0; while (true) { $start = $i * 1000; $items = Model()->table('evaluate_goods')->field('geval_commonid,geval_goodsid')->order('geval_id asc')->limit("{$start},1000")->select(); if(empty($items)) { return; } $i++; foreach ($items as $item) { $cid = intval($item['geval_commonid']); if($cid <= 0) continue; $mod->editGoodsCommon(['comments' => array('exp', "comments+1")],['goods_commonid' => $cid]); } } } }