public function bindCard(){
$Model = new \Think\Model();
//若果已经绑卡了 则 跳回列表页
$jg = $Model->query('select * from TBL_Vehicle where Openid = "'.$this->token['openid'].'" and VehicleTag <>""');
if($jg) {
$this->redirect('Index/index');
exit();
}
if(IS_POST) {
$num = iconv('UTF-8', 'gbk',I('post.number'));
$data = $Model->query('select * from TBL_Vehicle where VehicleTag ="'. $num .'"');
/*if(!$data) {
$info=array(
'type' => 2,
'mess' => '此手机已绑定'
);
$this->ajaxReturn($info);
exit();
}*/
if(!empty($data[0]['Openid'])){
$info=array(
'type' => 2,
'mess' => '此手机已绑定!手机:'.$num.'select * from TBL_Vehicle where VehicleTag ="'. $num .'"'
);
$this->ajaxReturn($info);
exit();
}
$openidr = array(
'Openid'=>$this->token['openid']
);
$jg = M('Tbl_vehicle')->where('VehicleTag ="'. $num .'"'.' and VehicleTag <> ""')->save($openidr);
if($jg != 0) {
$info=array(
'type' => 1,
'mess' => '【1】在档绑定成功!手机:'.$num."Openid:".$openidr['Openid']
);
}else {
header("Content-Type:text/html; charset=utf-8");
$Dao = M("Tbl_vehicle");// 实例化模型类
// 构建写入的数据数组
$new_data = array(
'Openid'=>$this->token['openid'],
'VehicleTag'=>'12345' ,
'CarOwnerCode'=>"13825251430",
'RepairSender'=>'12345' ,
'SenderMobile'=>"13825251430",
'Company'=> '12345'
);
// 写入数据
if($lastInsId = $Dao->add($new_data)){
$info=array(
'type' => 1,
'mess' => '新增绑定成功!Openid:'.$new_data['Openid']."手机:".$new_data['VehicleTag']
);
} else {
$info=array(
'type' => 2,
'mess' => '新增绑定失败!Openid:'.$new_data['Openid']."手机:".$new_data['VehicleTag']
);
}
}
$this->ajaxReturn($info);
exit();
}
$this->display();
}
最佳答案