$obj2=D('Onewinlog');
$datas=D('Oneyuanjoins')->where('status=1 and paytime is not null')->order('paytime asc')->limit(100);
foreach($datas as &$data){
$insert[] = array(
'join_id' => $data['id'], //付款单id
'seq' => $data['seq'], //期次
'seq_id' => $data['seq_id'], //活动id
'shop_id' => $data['shop_id'],
'prod_id' => $data['prod_id'],
'user_id' => $data['user_id'],
'paytime' => $data['paytime'],//年月日时分秒毫秒
'y_time' => date('Y-m-d',substr($data['paytime'],0,strlen($data['paytime'])-3) ),//年月日2015-10-24
'h_time' => date('H:i:s',substr($data['paytime'],0,strlen($data['paytime'])-3) ),//时分秒
'm_time' => date("His",substr($data['paytime'],0,strlen($data['paytime'])-3) ).substr($data['paytime'],0,3),//要计算的数据
'create_ip' => $data['create_ip'],
'address' => $data['address'],
'create_time' => $data['create_time'],
'is_mobile'=>$data['is_mobile'],
'status'=>$data['status'],
'win_seq' => $winseq, //所属活动中奖的seqid
);
//
$obj2->add($insert);
} 最佳答案