$Type = "N"; $dateTime = timezoneConverter($Type, $gmt_datetime, $db_user_timezone); $dtm = explode(SEPARATOR, $dateTime); $local_start_date = date("Y-m-d", strtotime($dtm[1])); try { $arrSubscDetails = insUserSubscriptionDetails($db_userid, $gmt_datetime, $gmt_start_date, $db_subscriptionenddategmt, $local_start_date, $db_subscriptionend_date_local, $db_subscriptionstatus, $db_orderid, $db_planid, $db_planname, $db_plandesc, $db_planfor, $db_plantype, $db_numberofsessions, $db_numberofminspersessions, $db_planperiod, $db_numberofinvitee, $db_meetingrecording, $db_diskspace, $db_isfree, $db_plancostinr, $db_plancostoth, $db_concurrentsessions, $db_talktimemins, $db_autorenewflag, $db_consumednumberofsessions, $db_consumedtalktimemins, $objDataHelper); } catch (Exception $a) { throw new Exception("response.php : insSubscriptionMaster : Error in adding subscription details." . $a->getMessage(), 541); } $subscStatus = $arrSubscDetails[0]['@STATUS']; $subsc_id = $arrSubscDetails[0]['@OUTPUT']; if ($subscStatus == 1) { $ClientSubStatus = "2"; //update CSM try { $arrClientSubStatus = updateClientSubscription($ClientSubStatus, $gmt_datetime, $strSetClient_ID, $db_orderid, $db_planid, $objDataHelper); } catch (Exception $e) { throw new Exception("index.php : updInvitationStatus Failed : " . $e->getMessage(), 1126); } $stat = "1"; $msg = "Plan <b>" . "{$db_planname}" . "</b> successfully assigned to <b>" . "{$db_usename}" . "</b>."; } else { $stat = "0"; $msg = 'Error in Adding.'; } } } else { $stat = "-1"; $msg = "Invalid Data"; } $finalStat = $stat . SEPARATOR . $msg;
$SubUsername = trim($arrSubAssignDtls[0]['user_name']); $SubStatus = trim($arrSubAssignDtls[0]['subscription_status']); $GMTDatetime = GM_DATE; $SubEndDate = date("Y-m-d", strtotime(GM_DATE)); $NewSubStatus = "4"; try { $arrRevokeStatus = revokeUserSubscription($SubEndDate, $NewSubStatus, $GMTDatetime, $SubScriptionId, $SubUserId, $SubOrderId, $SubPlanId, $objDataHelper); } catch (Exception $e) { throw new Exception("index.php : updInvitationStatus Failed : " . $e->getMessage(), 1126); } $strUpdStatus = trim($arrRevokeStatus[0]['@STATUS']); if ($strUpdStatus == 1) { $ClientSubStatus = "4"; //update CSM try { $arrClientSubStatus = updateClientSubscription($ClientSubStatus, $GMTDatetime, $strSetClient_ID, $SubOrderId, $SubPlanId, $objDataHelper); } catch (Exception $e) { throw new Exception("index.php : updInvitationStatus Failed : " . $e->getMessage(), 1126); } $strClientSubUpdStatus = trim($arrClientSubStatus[0]['@STATUS']); $stat = "1"; $msg = "Plan <strong>"" . "{$SubPlanname}" . ""</strong> has been revoke successfully."; } else { if ($strUpdStatus == 2) { $stat = "0"; $msg = "Nothing is updated."; } else { $stat = "0"; $msg = 'Error in while updating.'; } }