public function getConnection()
{
try {
if (!$this->database) {
$options = array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ, PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING);
$this->database = new PDO(Config::get('DB_TYPE') . ':host=' . Config::get('DB_HOST') . ';dbname=' . Config::get('DB_NAME') . ';port=' . Config::get('DB_PORT') . ';charset=' . Config::get('DB_CHARSET'), Config::get('DB_USER'), Config::get('DB_PASS'), $options);
}
} catch (PDOException $e) {
throw new Exception("PDOException: " . $e->getMessage());
}
return $this->database;
}
public function __construct($logger = 'default', $config = null)
{
//include the logger file that loads the log4php autoloader
require_once Config::get('LOG4PHP_LOGGER_FILE');
//configure log4php
if ($config == null || !isset($config) || empty($config)) {
$config = Config::get('LOG4PHP_CONFIG');
}
Logger::configure($config);
//create a logger
$this->logger = Logger::getLogger($logger);
}
/**
* Construct the (base) controller. This happens when a real controller is constructed, like in
* the constructor of IndexController when it says: parent::__construct();
*/
function __construct(LoggerInterface $logger = null)
{
// always initialize a session
Session::init();
// user is not logged in but has remember-me-cookie ? then try to login with cookie ("remember me" feature)
if (!Session::userIsLoggedIn() and Request::cookie('remember_me')) {
header('location: ' . Config::get('URL') . 'login/loginWithCookie');
}
// create a view object to be able to use it inside a controller, like $this->View->render();
$this->View = new View();
//initialize the logger object
$this->logger = $logger;
}
public function __construct($title, $data, $headers, $sizes, $max_lengths)
{
parent::__construct();
$this->header_text = $title;
$this->footer_text = "Generated by [" . Session::get('user_name') . "] on [" . date("l jS \\of F Y h:i:s A") . "] - " . Config::get('VERSION');
$this->data = $data;
$this->col_headers = $headers;
$this->col_sizes = $sizes;
$this->col_max_lengs = $max_lengths;
$this->SetTitle($title);
$this->SetAuthor(Session::get('user_name'));
$this->AliasNbPages();
$this->SetFont('Arial', '', 8);
$this->AddPage();
$this->renderTable();
}
/**
* Gets a user's profile data, according to the given $user_id
* @param int $user_id The user's id
* @return mixed The selected user's profile
*/
public static function getPublicProfileOfUser($user_id)
{
$database = DatabaseFactory::getFactory()->getConnection();
$sql = "SELECT user_id, user_name, user_email, user_active, user_has_avatar\n FROM tbl_users WHERE user_id = :user_id LIMIT 1";
$query = $database->prepare($sql);
$query->execute(array(':user_id' => $user_id));
$user = $query->fetch();
if ($query->rowCount() == 1) {
if (Config::get('USE_GRAVATAR')) {
$user->user_avatar_link = AvatarModel::getGravatarLinkByEmail($user->user_email);
} else {
$user->user_avatar_link = AvatarModel::getPublicAvatarFilePathOfUser($user->user_has_avatar, $user->user_id);
}
} else {
Session::add('feedback_negative', Text::get('FEEDBACK_USER_DOES_NOT_EXIST'));
}
return $user;
}
?>
&start_date=<?php
echo $message->calendar_date;
?>
&end_date=<?php
echo $message->calendar_date;
?>
"><?php
echo $message->service_id;
?>
</a></td>
<?php
} else {
?>
<a title="View Subscriptions" href="<?php
echo Config::get('URL');
?>
messages/subscriptions/?service_id=<?php
echo $message->service_id;
?>
&product_id=<?php
echo $message->product_id;
?>
&update_type=<?php
echo $message->update_type;
?>
&start_date=<?php
echo $this->start_date;
?>
&end_date=<?php
echo $this->end_date;
/**
* Hook - can be used to forward data to an external system (realtime forwarders)
*
* @param $data mixed data to be processed
* @return int array indicating the processing status and data after processing
*/
protected function hook($data)
{
if (Config::get('INBOX_FORWARDER') == 1) {
//forward
//initialize the parameters
$message_id = "";
$sp_rev_id = "";
$sp_re_password = "";
$sp_id = "";
$service_id = "";
$link_id = "";
$trace_unique_id = "";
$correlator = "";
$message = "";
$sender_address = "";
$dest_address = "";
$date_time = "";
//get the data from array
if (isset($data['_lastInsertID'])) {
$message_id = $data['_lastInsertID'];
}
if (isset($data['spRevId'])) {
$sp_rev_id = $data['spRevId'];
}
if (isset($data['spRevpassword'])) {
$sp_re_password = $data['spRevpassword'];
}
if (isset($data['spId'])) {
$sp_id = $data['spId'];
}
if (isset($data['serviceId'])) {
$service_id = $data['serviceId'];
}
if (isset($data['linkid'])) {
$link_id = $data['linkid'];
}
if (isset($data['traceUniqueID'])) {
$trace_unique_id = $data['traceUniqueID'];
}
if (isset($data['correlator'])) {
$correlator = $data['correlator'];
}
if (isset($data['message'])) {
$message = $data['message'];
}
if (isset($data['senderAddress'])) {
$sender_address = $data['senderAddress'];
}
if (isset($data['smsServiceActivationNumber'])) {
$dest_address = $data['smsServiceActivationNumber'];
}
if (isset($data['dateTime'])) {
$date_time = $data['dateTime'];
}
// add some logic to handle exceptions in this script
$database = null;
try {
//$database = SQLSRVDatabaseFactory::getFactory()->getConnection();
$options = array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ, PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING);
$database = new PDO('sqlsrv:Server=SEMATEL-SERVER;Database=db_Sematel', 'sa', 'SematelServer2014', $options);
} catch (Exception $ex) {
return array('result' => 3, 'resultDesc' => 'Cannot connect to the database. Error: ' . $ex->getMessage());
}
try {
$database->beginTransaction();
$sql = "INSERT INTO tbl_inbound_messages (message_id, service_id, link_id, trace_unique_id, correlator, message, sender_address, dest_address, date_time, created_on) VALUES (:message_id, :service_id, :link_id, :trace_unique_id, :correlator, :message, :sender_address, :dest_address, :date_time, CURRENT_TIMESTAMP);";
$query = $database->prepare($sql);
$bind_patameters = array(':message_id' => $message_id, ':service_id' => $service_id, ':link_id' => $link_id, ':trace_unique_id' => $trace_unique_id, ':correlator' => $correlator, ':message' => $message, ':sender_address' => $sender_address, ':dest_address' => $dest_address, ':date_time' => $date_time);
$this->logger->debug('{class_mame}|{method_name}|{service_id}|forwarding-hook|{query}|bind_parameters:{bind_params}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'query' => $sql, 'bind_params' => json_encode($bind_patameters)));
if ($query->execute($bind_patameters)) {
$row_count = $query->rowCount();
$database->commit();
if ($row_count == 1) {
return array('result' => 0, 'resultDesc' => 'Forwarding successful', 'data' => $data);
}
} else {
$this->logger->error('{class_mame}|{method_name}|{service_id}|error executing the query|{error}|{query}|bind_parameters:{bind_params}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'error' => $database->errorCode(), 'query' => $sql, 'bind_params' => json_encode($bind_patameters)));
return array('result' => 5, 'resultDesc' => 'Error executing a query.');
}
} catch (PDOException $e) {
return array('result' => 4, 'resultDesc' => 'Error executing a query. Error: ' . $e->getMessage());
}
return array("result" => "19", "resultDesc" => "Forwarding record failed ({$sql})" . $database->errorCode() . " " . $database->errorInfo(), "data" => $data);
}
return array("result" => "0", "resultDesc" => "Hook execution successful", "data" => $data);
}
/**
* Hook - can be used to forward data to an external system (realtime forwarders)
*
* @param $data mixed data to be processed
* @return int array indicating the processing status and data after processing
*/
protected function hook($data)
{
/* Update outgoing table with the parameters */
//initialize the parameters
$correlator = "";
$dest_address = "";
$delivery_status = "";
$delivery_receipt_id = 0;
//get the data from array
if (isset($data['correlator'])) {
$correlator = $data['correlator'];
}
if (isset($data['address'])) {
$dest_address = $data['address'];
}
if (isset($data['deliveryStatus'])) {
$delivery_status = $data['deliveryStatus'];
}
if (isset($data['_lastInsertID'])) {
$delivery_receipt_id = $data['_lastInsertID'];
}
// add some logic to handle exceptions in this script
$database = DatabaseFactory::getFactory()->getConnection();
$database->beginTransaction();
$sql = "UPDATE tbl_outbound_messages SET delivery_timestamp = NOW(), delivery_status=:delivery_status, delivery_notif_type=2, delivery_receipt_id =:delivery_receipt_id, last_updated_on=NOW() WHERE dest_address=:dest_address AND correlator=:correlator";
// IMPORTANT - note dest_addresses in the where clause (to be visited later)
$query = $database->prepare($sql);
$query->execute(array(':delivery_status' => $delivery_status, ':delivery_receipt_id' => $delivery_receipt_id, ':dest_address' => $dest_address, ':correlator' => $correlator));
$row_count = $query->rowCount();
$data['_recordsUpdated'] = $row_count;
$database->commit();
if ($database->errorCode() != "0000") {
//success
return array("result" => "18", "resultDesc" => "Saving FAILED. Error: " . $database->errorCode(), "data" => $data);
}
//forward the request
if (Config::get('DELIVERY_FORWARDER') == 1) {
//
//initialize the parameters
$time_stamp = "";
$sub_req_id = "";
$trace_unique_id = "";
$correlator = "";
$dest_address = "";
$delivery_status = "";
$id = "";
//get the data from array
if (isset($data['timeStamp'])) {
$time_stamp = $data['timeStamp'];
}
if (isset($data['subReqID'])) {
$sub_req_id = $data['subReqID'];
}
if (isset($data['traceUniqueID'])) {
$trace_unique_id = $data['traceUniqueID'];
}
if (isset($data['correlator'])) {
$correlator = $data['correlator'];
}
if (isset($data['address'])) {
$dest_address = $data['address'];
}
if (isset($data['deliveryStatus'])) {
$delivery_status = $data['deliveryStatus'];
}
if (isset($data['_lastInsertID'])) {
$id = $data['_lastInsertID'];
}
// add some logic to handle exceptions in this script
$database = null;
try {
//$database = SQLSRVDatabaseFactory::getFactory()->getConnection();
$options = array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ, PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING);
$database = new PDO('sqlsrv:Server=SEMATEL-SERVER;Database=db_Sematel', 'sa', 'SematelServer2014', $options);
} catch (Exception $ex) {
return array('result' => 3, 'resultDesc' => 'Cannot connect to the database. Error: ' . $ex->getMessage());
}
$bind_patameters = array();
try {
$database->beginTransaction();
$sql = "INSERT INTO dbo.tbl_delivery_receipts (id, time_stamp, sub_req_id, trace_unique_id, correlator, dest_address, delivery_status, created_on) VALUES (:id, :time_stamp, :sub_req_id, :trace_unique_id, :correlator, :dest_address, :delivery_status, CURRENT_TIMESTAMP);";
$query = $database->prepare($sql);
$bind_patameters = array(':id' => $id, ':time_stamp' => $time_stamp, ':sub_req_id' => $sub_req_id, ':trace_unique_id' => $trace_unique_id, ':correlator' => $correlator, ':dest_address' => $dest_address, ':delivery_status' => $delivery_status);
$this->logger->debug('{class_mame}|{method_name}|{service_id}|forwarding-hook|{query}|bind_parameters:{bind_params}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'query' => $sql, 'bind_params' => json_encode($bind_patameters)));
if ($query->execute($bind_patameters)) {
$row_count = $query->rowCount();
$database->commit();
if ($row_count == 1) {
return array('result' => 0, 'resultDesc' => 'Forwarding successful', 'data' => $data);
}
} else {
$this->logger->error('{class_mame}|{method_name}|{service_id}|error executing the query|{error}|{query}|bind_parameters:{bind_params}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'error' => $database->errorCode(), 'query' => $sql, 'bind_params' => json_encode($bind_patameters)));
return array('result' => 5, 'resultDesc' => 'Error executing a query.');
}
} catch (PDOException $e) {
$this->logger->error('{class_mame}|{method_name}|{service_id}|forwarding-hook|{query}|bind_parameters:{bind_params}|{error}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'query' => $sql, 'bind_params' => json_encode($bind_patameters), 'error' => $e->getMessage()));
return array('result' => 4, 'resultDesc' => 'Error executing a query. Error: ' . $e->getMessage());
}
return array("result" => "19", "resultDesc" => "Forwarding record failed ({$sql})" . $database->errorCode() . " " . $database->errorInfo(), "data" => $data);
}
return array("result" => "0", "resultDesc" => "Hook execution successful", "data" => $data);
}
/**
* Hook - can be used to forward data to an external system (realtime forwarders)
*
* @param $data mixed data to be processed
* @return int array indicating the processing status and data after processing
*/
protected function hook($data)
{
if (Config::get('SUBSCRIPTION_FORWARDER') == 1) {
//forward
//initialize the parameters
$id = "";
$subscriber_id = "";
$sp_id = "";
$product_id = "";
$service_id = "";
$service_list = "";
$update_type = "";
$update_time = "";
$update_desc = "";
$effective_time = "";
$expiry_time = "";
$named_parameters = "";
$keyword = "";
//get the data from array
if (isset($data['_lastInsertID'])) {
$id = $data['_lastInsertID'];
}
if (isset($data['ID'])) {
$subscriber_id = $data['ID'];
}
if (isset($data['spID'])) {
$sp_id = $data['spID'];
}
if (isset($data['productID'])) {
$product_id = $data['productID'];
}
if (isset($data['serviceID'])) {
$service_id = $data['serviceID'];
}
if (isset($data['serviceList'])) {
$service_list = $data['serviceList'];
}
if (isset($data['updateType'])) {
$update_type = $data['updateType'];
}
if (isset($data['updateTime'])) {
$update_time = $data['updateTime'];
}
if (isset($data['updateDesc'])) {
$update_desc = $data['updateDesc'];
}
if (isset($data['effectiveTime'])) {
$effective_time = $data['effectiveTime'];
}
if (isset($data['expiryTime'])) {
$expiry_time = $data['expiryTime'];
}
if (isset($data['keyword'])) {
$keyword = $data['keyword'];
}
// process named parameters - key value pairs
if (isset($data['key'])) {
$count = $data['repeatedParameters']['key'];
$named_parameters_array = array($data['key'] => $data['value']);
//initial key and value pair
for ($i = 1; $i <= $count; $i++) {
if (isset($data['key' . $i]) && isset($data['value' . $i])) {
$named_parameters_array[$data['key' . $i]] = $data['value' . $i];
}
}
$named_parameters = json_encode($named_parameters_array);
//encode into json string
}
// add some logic to handle exceptions in this script
$database = null;
try {
//$database = SQLSRVDatabaseFactory::getFactory()->getConnection();
$options = array(PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ, PDO::ATTR_ERRMODE => PDO::ERRMODE_WARNING);
$database = new PDO('sqlsrv:Server=SEMATEL-SERVER;Database=db_Sematel', 'sa', 'SematelServer2014', $options);
} catch (Exception $ex) {
return array('result' => 3, 'resultDesc' => 'Cannot connect to the database. Error: ' . $ex->getMessage());
}
try {
$database->beginTransaction();
//$sql=$sql="INSERT INTO dbo.tbl_Subscription_messages (id, subscriber_id, sp_id, product_id, service_id, service_list, update_type, update_desc, effective_time, expiry_time, created_on) VALUES (:id,:subscriber_id,:sp_id,:product_id,:service_id,:service_list,:update_type,:update_desc,:effective_time,:expiry_time,CURRENT_TIMESTAMP)";
$sql = "INSERT INTO dbo.tbl_Subscription_messages (id, subscriber_id, sp_id, product_id, service_id, service_list, update_type, update_desc, effective_time, expiry_time, created_on, keyword) VALUES (:id,:subscriber_id,:sp_id,:product_id,:service_id,:service_list,:update_type,:update_desc,:effective_time,:expiry_time,CURRENT_TIMESTAMP,:keyword)";
$query = $database->prepare($sql);
$bind_patameters = array(':id' => $id, ':subscriber_id' => $subscriber_id, ':sp_id' => $sp_id, ':product_id' => $product_id, ':service_id' => $service_id, ':service_list' => $service_list, ':update_type' => $update_type, ':update_desc' => $update_desc, ':effective_time' => $effective_time, ':expiry_time' => $expiry_time, ':keyword' => $keyword);
$this->logger->debug('{class_mame}|{method_name}|{service_id}|forwarding-hook|{query}|bind_parameters:{bind_params}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'query' => $sql, 'bind_params' => json_encode($bind_patameters)));
if ($query->execute($bind_patameters)) {
$row_count = $query->rowCount();
$database->commit();
if ($row_count == 1) {
return array('result' => 0, 'resultDesc' => 'Forwarding successful', 'data' => $data);
}
} else {
$this->logger->error('{class_mame}|{method_name}|{service_id}|error executing the query|{error}|{query}|bind_parameters:{bind_params}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'error' => $database->errorCode(), 'query' => $sql, 'bind_params' => json_encode($bind_patameters)));
return array('result' => 5, 'resultDesc' => 'Error executing a query.');
}
} catch (PDOException $e) {
return array('result' => 4, 'resultDesc' => 'Error executing a query. Error: ' . $e->getMessage());
}
return array("result" => "19", "resultDesc" => "Forwarding record failed ({$sql})" . $database->errorCode() . " " . $database->errorInfo(), "data" => $data);
}
return array("result" => "0", "resultDesc" => "Successful - hook is off", "data" => $data);
}
/**
* Send the password reset mail
*
* @param string $user_name username
* @param string $user_password_reset_hash password reset hash
* @param string $user_email user email
*
* @return bool success status
*/
public static function sendPasswordResetMail($user_name, $user_password_reset_hash, $user_email)
{
// create email body
$body = Config::get('EMAIL_PASSWORD_RESET_CONTENT') . ' ' . Config::get('URL') . Config::get('EMAIL_PASSWORD_RESET_URL') . '/' . urlencode($user_name) . '/' . urlencode($user_password_reset_hash);
// create instance of Mail class, try sending and check
$mail = new Mail();
$mail_sent = $mail->sendMail($user_email, Config::get('EMAIL_PASSWORD_RESET_FROM_EMAIL'), Config::get('EMAIL_PASSWORD_RESET_FROM_NAME'), Config::get('EMAIL_PASSWORD_RESET_SUBJECT'), $body);
if ($mail_sent) {
Session::add('feedback_positive', Text::get('FEEDBACK_PASSWORD_RESET_MAIL_SENDING_SUCCESSFUL'));
return true;
}
Session::add('feedback_negative', Text::get('FEEDBACK_PASSWORD_RESET_MAIL_SENDING_ERROR') . $mail->getError());
return false;
}
/**
* Handles what happens when user moves to URL/service/all. This returns all servives in the system.
*/
public function all()
{
/*
Initialize the request data
*/
//get request data
$service_id = Request::get('service_id');
$service_type = Request::get('service_type');
$short_code = Request::get('short_code');
$page = null !== Request::get('page') ? (int) Request::get('page') : 1;
//page - default is 1
$rpp = (int) Config::get('RECORDS_PER_PAGE');
//records per page
$start_record = (int) (($page - 1) * $rpp);
// start record
//request data to be used in calling the model
$data = array('service_id' => $service_id, 'service_type' => $service_type, 'short_code' => $short_code, 'page' => $page, 'rpp' => $rpp, 'start_record' => $start_record);
//log the event
$this->logger->debug('{class_mame}|{method_name}|{service_id}|request-request|{data}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'data' => json_encode($data)));
$service_model = new ServiceModel($this->logger);
$result = $service_model->getServices($service_id, $service_type, $short_code, $start_record, Config::get('RECORDS_PER_PAGE'));
$data['result'] = $result;
//add some pagination logic here
$total_records = isset($result['_totalRecords']) ? $result['_totalRecords'] : 0;
$pagination = new Pagination();
$pagination->setCurrent($page);
$pagination->setTotal($total_records);
$markup = $pagination->parse();
$data['markup'] = $markup;
//success
if ($result['result'] == 0) {
$this->View->render('servicemanager/all', $data);
} else {
$this->View->render('error/loaderror', $result['resultDesc']);
}
//log the event
$this->logger->debug('{class_mame}|{method_name}|{service_id}|result|{result}|{result_desc}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'result' => $result['result'], 'result_desc' => $result['resultDesc']));
}
/**
* Deletes the cookie
* It's necessary to split deleteCookie() and logout() as cookies are deleted without logging out too!
* Sets the remember-me-cookie to ten years ago (3600sec * 24 hours * 365 days * 10).
* that's obviously the best practice to kill a cookie @see http://stackoverflow.com/a/686166/1114320
*/
public static function deleteCookie()
{
setcookie('remember_me', false, time() - 3600 * 24 * 3650, Config::get('COOKIE_PATH'));
}
/**
* Data preprocessing before it can be saved. Enriching the message to be saved and forwarded.
*
* @param $data mixed data to be preprocessed
* @return int array indicating the processing status and data after processing
*/
protected function preProcess($data)
{
//check for required parameters
if (!(isset($data['message']) && isset($data['sender_address']) && isset($data['dest_address']) && isset($data['service_id']))) {
return array('result' => 13, 'resultDesc' => 'Expected parameters not found.', 'data' => $data);
}
//get the service data
$response = $this->getService($data['service_id']);
//print_r($response);
if ($response['result'] != 0) {
//retrieving service failed
$this->logger->debug('{class_mame}|{method_name}|error-loading-service|{result}|{result_desc}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'request_data' => implode('|', $data), 'result' => $response['result'], 'sdp_result_desc' => $response['resultDesc']));
return $response;
}
//extract service data from
$service = $response['data'];
//service data
// Check service status configuration 0 - OFF and 1 - ON
if ($service->status != 1) {
return array('result' => 15, 'resultDesc' => 'Service with id ' . $data['service_id'] . ' is OFF or is not configured correctly.', 'data' => $data);
}
//resolve the end point
$data['notify_endpoint'] = $service->delivery_notification_endpoint;
if (!isset($data['notify_endpoint']) || empty($data['notify_endpoint'])) {
//use default enmd point
$data['notify_endpoint'] = Config::get('SEND_SMS_DEFAULT_DELIVERY_NOTIFICATION_ENDPOINT');
}
//check whether short code exists as part of the request data, if not, load service configuration file
if (!isset($data['sender_address']) || empty($data['sender_address'])) {
$data['sender_address'] = $service->short_code;
}
//send request to external server
$send_response = SDP::sendSms($this->logger, $data['service_id'], $data['dest_address'], $data['correlator'], $data['sender_address'], $data['message'], $data['link_id']);
//log the event
$this->logger->debug('{class_mame}|{method_name}|sdp-result|{request_data}|{sdp_result}|{sdp_result_desc}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'request_data' => implode('|', $data), 'sdp_result' => $send_response['ResultCode'], 'sdp_result_desc' => $send_response['ResultDesc']));
$data['sdp_sendsms_result'] = $send_response;
//check send sms response code
if ($send_response['ResultCode'] == 0) {
// success
//send the message to external system
$data['send_ref_id'] = $send_response['ResultDetails']['result'];
//ref id of SDP to be changed with API change
$data['status'] = 2;
//send sms successful
$data['status_desc'] = 'SENT[Message sent]';
//message sent
} else {
$data['status'] = 4;
//sending failed
$data['status_desc'] = 'FAIED[Sending failed. ' . $send_response['ResultCode'] . ' - ' . $send_response['ResultDesc'] . ': ' . $send_response['ResultDetails'] . ']';
//message send failed
}
return array('result' => "0", 'resultDesc' => 'Preprocessing successful', 'data' => $data);
}
public static function stopSmsNotification(LoggerInterface $logger, $kmp_service_id, $kmp_correlator)
{
$kmp_spid = Config::get('SP_ID');
// sp id from configuration file
$kmp_timestamp = date("YmdHis");
//current timestamp
$kmp_sppwd = self::generatePassword($kmp_timestamp);
// password to be passed to SDP
$bodyxml = '<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:v2="http://www.huawei.com.cn/schema/common/v2_1" xmlns:loc="http://www.csapi.org/schema/parlayx/sms/notification_manager/v2_3/local"><soapenv:Header><v2:RequestSOAPHeader><spId>' . $kmp_spid . '</spId><spPassword>' . $kmp_sppwd . '</spPassword><serviceId>' . $kmp_service_id . '</serviceId><timeStamp>' . $kmp_timestamp . '</timeStamp></v2:RequestSOAPHeader></soapenv:Header><soapenv:Body><loc:stopSmsNotification><correlator>' . $kmp_correlator . '</correlator></loc:stopSmsNotification></soapenv:Body></soapenv:Envelope>';
//create the client
$client = new nusoap_client(Config::get('SMS_NOTIFICATION_MANAGER_ENDPOINT'), true);
$bsoapaction = "";
$client->soap_defencoding = 'utf-8';
$client->useHTTPPersistentConnection();
//send the request to the server
$result = $client->send($bodyxml, $bsoapaction);
//log the send request
$logger->debug("{class_mame}|{method_name}|{service_id}|sending stop sms notification|{endpoint}|{soapaction}|{request}", array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'service_id' => $kmp_service_id, 'endpoint' => Config::get('SMS_NOTIFICATION_MANAGER_ENDPOINT'), 'soapaction' => $bsoapaction, 'request' => $bodyxml));
//check for fault and return
if ($client->fault) {
return array('ResultCode' => 1, 'ResultDesc' => 'SOAP Fault', 'ResultDetails' => $result, 'xml' => $bodyxml, 'endpoint' => Config::get('SMS_NOTIFICATION_MANAGER_ENDPOINT'));
}
// check for errors and return
$err = $client->getError();
if ($err) {
return array('ResultCode' => 2, 'ResultDesc' => 'Error', 'ResultDetails' => $err, 'xml' => $bodyxml, 'endpoint' => Config::get('SMS_NOTIFICATION_MANAGER_ENDPOINT'));
} else {
//check for fault code
if (isset($result['faultcode'])) {
return array('ResultCode' => '3', 'ResultDesc' => 'Fault - ' . $result['faultcode'], 'ResultDetails' => $result['faultstring'], 'xml' => $bodyxml, 'endpoint' => Config::get('SMS_NOTIFICATION_MANAGER_ENDPOINT'));
}
//return success
return array('ResultCode' => 0, 'ResultDesc' => 'Operation Successful.', 'ResultDetails' => $result, 'xml' => $bodyxml, 'endpoint' => Config::get('SMS_NOTIFICATION_MANAGER_ENDPOINT'));
}
}
public function subscriptions_pdf()
{
/*
Initialize the request data
*/
//get request data
$subscriber_id = Request::get('subscriber_id');
$service_id = Request::get('service_id');
$product_id = Request::get('product_id');
$update_type = Request::get('update_type');
$start_date = Request::get('start_date');
$end_date = Request::get('end_date');
//set default start date - 1 month ago
if (!isset($start_date) || $start_date == '') {
$date = date_create(date('Y-m-d'));
date_sub($date, date_interval_create_from_date_string('1 months'));
$start_date = date_format($date, 'Y-m-d');
}
//set default end date - current day
if (!isset($end_date) || $end_date == '') {
$end_date = date('Y-m-d');
}
//request data to be used in calling the model
$data = array('subscriber_id' => $subscriber_id, 'service_id' => $service_id, 'product_id' => $product_id, 'update_type' => $update_type, 'start_date' => $start_date, 'end_date' => $end_date);
//log the event
$this->logger->debug('{class_mame}|{method_name}|request|request-data:{data}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'data' => json_encode($data)));
//call the model
$model = new MessageModel($this->logger);
$result = $model->getSubscriptionMessages($start_date . ' 00:00:00', $end_date . ' 23:59:59', $subscriber_id, $service_id, $product_id, $update_type, 0, Config::get('MAX_RECORDS_PDF'));
//add result
$data['result'] = $result;
//print_r($result);
//request data to be used in calling the model
$data = array('subscriber_id' => $subscriber_id, 'service_id' => $service_id, 'product_id' => $product_id, 'update_type' => $update_type, 'start_date' => $start_date, 'end_date' => $end_date);
$title = "Subscription Requests Extract - Subscriber: {$subscriber_id}, Service ID: {$service_id}, Product ID: {$product_id}, Update Type: {$update_type}, Start Date: {$start_date}, End Date: {$end_date}";
$headers = array('#', 'Subscriber', 'Service ID', 'Product ID', 'Update Type', 'Effective Time', 'Expiry Time', 'Processing Time');
$sizes = array(15, 43, 40, 40, 35, 35, 35, 35);
$max_sizes = array(10, 30, 28, 28, 30, 25, 25, 25);
$data = array();
$filename = __FUNCTION__ . '_' . Session::get('user_name') . '_' . date('YmdHis') . '.pdf';
$i = 0;
foreach ($result['messages'] as $message) {
$data[$i] = array($message->id, $message->subscriber_id, $message->service_id, $message->product_id, $message->update_desc, $message->effective_time, $message->expiry_time, $message->created_on);
$i++;
}
$pdf = new PDF($title, $data, $headers, $sizes, $max_sizes);
$pdf->Output($filename, 'I');
//log the event
$this->logger->info('{class_mame}|{method_name}|result|{result}|result_desc:{result_desc}', array('class_mame' => __CLASS__, 'method_name' => __FUNCTION__, 'result' => $result['result'], 'result_desc' => $result['resultDesc']));
}
/**
* Disable service
*
* @param string $service_id service id
* @return bool TRUE if enable is successful, FALSE if enable fails
*/
public function disable($service_id)
{
//get the serivce parameters from the database
$response = self::getService($service_id);
//confirm the status of the service
if ($response['result'] != 0) {
return $response;
}
//extract service data
$service_data = $response['service'];
if ($service_data->status == Config::get('SMS_SERVICE_OFF')) {
return array('result' => 9, 'resultDesc' => 'Service already disabled.', 'service' => $service_data);
}
//check whether the service requires sending a request to SDP for on demand service type
if ($service_data->service_type == Config::get('SMS_ON_DEMAND_SERVICE_TYPE')) {
//send request to SDP if application
$response = self::sendStopSmsNotification($service_data);
if ($response['result'] == 0) {
$service_data->status = Config::get('SMS_SERVICE_OFF');
// disable
} else {
return $response;
// return as is
}
} else {
$service_data->status = Config::get('SMS_SERVICE_OFF');
// disable
}
$response['service'] = $service_data;
//update the database
$response = self::saveServiceStatus($response);
//update the configuration file - Future task
//return
return $response;
}