/** * Function updateNofiticatoinModel is used to update or delete notification details * @param int $delId notification id to delete * @param int $userID user id * @return void */ function updateNotificationModel($notificationID, $userID) { global $wpdb; $getSubscriberID = $wpdb->get_var($wpdb->prepare('SELECT sub_id FROM ' . WVG_CHANNEL_NOTIFICATION . ' WHERE user_id=%d', $userID)); $subscriberId = json_decode($getSubscriberID, true); if (in_array($notificationID, $subscriberId)) { $delkey = array_search($notificationID, $subscriberId); unset($subscriberId[$delkey]); if (!empty($subscriberId)) { $updatedId = json_encode($subscriberId); /** data hold query details */ $data = array('sub_id' => $updatedId); /** where hold query condition */ $where = array('user_id' => $userID); /** format hold data format */ $format = array('%s'); /** where format hold where data format */ $whereFormat = array('%d'); $wpdb->update(WVG_CHANNEL_NOTIFICATION, $data, $where, $format, $whereFormat); } else { deleteNotificationModel($userID); } } else { echo __('Unknown Error Occured', APPTHA_VGALLERY); exitAction(''); } }
/** * Function to delete notification details. * This function is used to remove required user notification details. * @param int $userID user id * @return void */ public function deleteNotification($userID) { $notificationID = isset($_POST['delId']) && $_POST['delId'] != '' ? intVal($_POST['delId']) : ''; if (empty($notificationID)) { deleteNotificationModel($userID); } else { updateNotificationModel($notificationID, $userID); } }