public function xinzeng($id){
$order = Db::name('order')->where(['id'=>$id,'status'=>1])->find();
$data=[
'records'=>[
[
'fields'=>[
'ID'=>$order['id'],
'Member_id'=>$order['member_id'],
'Order Number'=>$order['order_num'],
'Order Date'=>date("Y-m-d",$success),
'Gross Premium'=>(float)$order['price'],
'Net Premium'=>(float)$order['cost_price'],
'Last Name'=>$order['xing'],
'First Name'=>$order['ming'],
'DOB'=>$order['age'],
'Gender'=>$order['sex'],
'Email'=>$order['email'],
'Citizenship'=>$order['country'],
'Grade'=>$order['grade'],
'Passport Number'=>$order['passport'],
'Phone Number'=>'+'.$phone_area.'-'.$order['phone'],
'Beneficiary First Name'=>$order['ben_name'],
'Beneficiary Last Name'=>$order['ben_xing'],
'Relation'=>$order['ben_rel'],
'Beneficiary DOB'=>$order['ben_age'],
'Beneficiary Email'=>$order['ben_email'],
'Address'=>$order['address'],
'State'=>$order['city_zhou'],
'City'=>$order['city_chengshi'],
'Zip Code'=>$order['zipcode'],
'Visa Type'=>$title,
'Plan'=>$ins['name'].'/'.$deduc,
'School'=>$school['title'],
'EffectiveFrom'=>$order['start_date'],
'Effective To'=>$order['end_date'],
'Coverage Days'=>(float)$order['date'],
'Status'=>$zhif,
'Channels'=>$order['liaojie'],
'Payment Methods'=>$fangshi,
'Credit Card or Admin Fee'=>(float)$order['sx_price'],
'Age'=>$nian,
]
]
]
];
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_URL, "https://api.airtable.com/v0/appnb67MsIVTKyMw6/%E8%AE%A2%E5%8D%95%E8%AF%A6%E6%83%85");
curl_setopt($ch, CURLOPT_HTTPHEADER, [
"Content-Type: application/json",
"Authorization: Bearer keynFeBDTkWYkM116"
]);
//这两行是不检测ssl证书
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'POST');
curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($data));
$result = curl_exec($ch);
curl_close($ch);
print_R(json_decode($result,true));
$res = json_decode($result,true);
$data = [
'order_id' =>$res['records'][0]['fields']['ID'],
'air_id'=>$res['records'][0]['id']
];
Db::name('air')->insert($data);
return 'ok ';
}
根据airtable上的字段名称,设置参数进行传递,名称必须对应
原创©本文章为教腾豪原创,未经许可,禁止转载
0条评论