"; // print_r($postdata); // echo ""; $sql2 = "update alert_managements set status='".$status."' where id='".$delete_id."' limit 1 "; // echo $sql2.'
';die; if ($conn->query($sql2) === TRUE){ $response_data = array ( 'status' => true, 'message' => 'Success.' ); }else{ $response_data = array ( 'status' => false, 'message' => 'Something Error.' ); } echo json_encode($response_data); die; }else{ if ($postdata['SetAlertValue']=="") { $response_data = array ( 'status' => false, 'message' => 'Please Set Alert Type.' ); }elseif($postdata['setMultipleOption2']=="") { $response_data = array ( 'status' => false, 'message' => 'Please Select Vehicle No.' ); }elseif ($postdata['Email']=="") { $response_data = array ( 'status' => false, 'message' => 'Please Enter Email id' ); }elseif ($postdata['MobileNo']=="") { $response_data = array ( 'status' => false, 'message' => 'Please Enter Mobile No.' ); }else{ $user_Id = $postdata['alert_user_id']; $Parent_user_Id = $postdata['user_Id']; // $group_Id = $postdata['group_Id']; // $sys_username = $postdata['sys_username']; if ($postdata['setMultipleOption2']=="All") { $sys_service_id = 'All'; $VehicleNo = 'All'; }else{ $sys_service_id = ''; $VehicleNo = ''; $setMultipleOption2 = explode(',',$postdata['setMultipleOption2']); if(count($setMultipleOption2)>0) { foreach ($setMultipleOption2 as $key => $value) { $array = explode('##',$value); if(isset($array[1])) { $sys_service_id.= $array[0].','; } if(isset($array[1])) { $VehicleNo.= $array[1].','; } } } $sys_service_id = rtrim($sys_service_id, ','); $VehicleNo = rtrim($VehicleNo, ','); } //echo $postdata['setMultipleOption2'];die; //$postdata['setMultipleOption2']; $id = trim($postdata['id']); $group_Id = trim($postdata['alert_group_id']); $sys_username = trim($postdata['alert_sys_username']); $SetAlertType = trim($postdata['SetAlertValue']); $SetGeoFanceValue = trim($postdata['SetGeoFanceValue']); $SetSpeedValue = trim($postdata['SetSpeedValue']); if(trim($postdata['SetIdlingValue'])=='') { $IdlingHrs = 0; } else { $IdlingHrs = trim($postdata['SetIdlingValue']); } //$VehicleNo =trim($postdata['setMultipleOption2']); $SetTempFrom = trim($postdata['SetTempFromValue']); $SetTempTo = trim($postdata['SetTempToValue']); $email_id = trim($postdata['Email']); $mobile_No = trim($postdata['MobileNo']); $check = ""; if(isset($postdata['checkEmail']) && $postdata['checkEmail']!=''){ $checkEmail = $postdata['checkEmail']; $check .= $checkEmail; } if(isset($postdata['SMS'])){ $SMS = $postdata['SMS']; if ($check=="") { $check .= $SMS; }else{ $check .= ','.$SMS; } //$check = $checkEmail; } if(isset($postdata['Notification'])){ $Notification = $postdata['Notification']; if ($check=="") { $check .= $Notification; }else{ $check .= ','.$Notification; } } // ******************** //die; //57362,50479,50483,50491,50492,50493,50494,50496,50497,50499,50539,50540,50559,50680,50681,78553 $sql3 = "SELECT id,email_id,mobile_No,SetAlertType FROM alert_managements WHERE email_id='".$email_id."' and mobile_No='".$mobile_No."' and SetAlertType='".$SetAlertType."' and sys_username='".$sys_username."' and status='1'"; //echo $sql3;die; $result = mysqli_query($conn, $sql3); $row = mysqli_fetch_assoc($result); $result3 = $conn->query($sql3); if($row['email_id'] == $email_id && $row['id'] != $id) { // if ($result3->num_rows > 0) { $response_data = array ( 'status' => false, 'message' => 'Already exist', 'message2' => 'Already exist '.$SetAlertType.' Alert! Plase Change Email is and mobile No.' ); }else{ //echo $id;die; if ($id=="") { //echo 1;die; $sql = "INSERT INTO alert_managements (Parent_user_Id,user_Id,group_Id,sys_username,email_id,mobile_No,SetAlertType,SetGeoFanceValue,SetSpeedValue,SetTempFrom,SetTempTo,checkSms,IdlingHrs,sys_service_id,VehicleNo) VALUES ('".$Parent_user_Id."','".$user_Id."','".$group_Id."','".$sys_username."','".$email_id."','".$mobile_No."','".$SetAlertType."','".$SetGeoFanceValue."','".$SetSpeedValue."','".$SetTempFrom."','".$SetTempTo."','".$check."',".$IdlingHrs.",'".$sys_service_id."','".$VehicleNo."')"; }else{ //echo 2;die; $sql = "update alert_managements set mobile_No='".$mobile_No."',SetAlertType='".$SetAlertType."',SetGeoFanceValue='".$SetGeoFanceValue."',SetSpeedValue='".$SetSpeedValue."',SetTempFrom='".$SetTempFrom."',SetTempTo='".$SetTempTo."',checkSms='".$check."',IdlingHrs='".$IdlingHrs."',sys_service_id='".$sys_service_id."', VehicleNo='".$VehicleNo."' where id='".$id."' limit 1 "; // //and user_Id=".$user_Id." and group_Id=".$group_Id } //echo $sql;die; if ($conn->query($sql) === TRUE){ $response_data = array ( 'status' => true, 'message' => 'Success.' ); }else{ $response_data = array ( 'status' => false, 'message' => 'Something Error.' ); } } //die; // ******************** } echo json_encode($response_data);die; } ?>