function deleteNotification()
{
global $OWgetDbo;
global $language;
$app = \Slim\Slim::getInstance();
$app->response->headers->set('Content-Type', 'application/json');
$app->response->setStatus(200);
//Lang Call Start
$hammu_lang_id = $app->request()->params("lang_id");
if (!empty($hammu_lang_id)) {
getCurrentLanguages($hammu_lang_id);
}
//Lang Call end
$sql = "SELECT * FROM " . OW_DB_PREFIX . "invites_log WHERE `action`='buy_rose_client'";
$invite_log = $OWgetDbo->queryForList($sql);
$today = date("d-m-Y H:m:s");
$today_time = strtotime($today);
foreach ($invite_log as $key => $invite) {
$data = json_decode($invite['data']);
if ($today_time > $data->date) {
$sql1 = "UPDATE ow_invites_log SET `noti_remove`='1' WHERE `inviterId`='{$invite['inviterId']}' AND `inviteeId`='{$invite['inviteeId']}'";
$result = $OWgetDbo->update($sql1);
if ($result) {
$message = $language->text("hammu", "delete_noti_success");
//"Notificaton deleted successfully!";
$return_data = array('response_status' => "1", 'response_message' => $message);
} else {
$message = $language->text("hammu", "delete_noti_fail");
//"Notification not deleted or not exist!";
$return_data = array('response_status' => "0", 'response_message' => $message);
}
$app->response->setBody(json_encode($return_data));
}
}
}
function proposeDateInvitation()
{
global $HAMMU_BOL_Service;
global $language;
$app = \Slim\Slim::getInstance();
$app->response->headers->set('Content-Type', 'application/json');
$app->response->setStatus(200);
//Lang Call Start
$hammu_lang_id = $app->request()->params("lang_id");
if (!empty($hammu_lang_id)) {
getCurrentLanguages($hammu_lang_id);
}
//Lang Call end
$inviterId = $app->request()->params("inviterId");
$inviteeId = $app->request()->params("inviteeId");
$id = $app->request()->params("id");
$date = $app->request()->params("date");
$timestamp = strtotime($date);
$invitesId = $app->request()->params("invitesId");
$rarray = $HAMMU_BOL_Service->agree($inviterId, $inviteeId, $id, $timestamp, $invitesId);
if (count($rarray) > 0) {
$message = $language->text("hammu", "proposeDateInvitation_success");
//"Invitation for Propose Date!"
$return_data = array("response_status" => "1", "response_message" => $message);
$app->response->setBody(json_encode($return_data));
} else {
$message = $language->text("hammu", "proposeDateInvitation_fail");
//"Invitation to Propose Date already Proposed!"
$return_data = array("response_status" => "0", "response_message" => $message);
$app->response->setBody(json_encode($return_data));
}
}
function escort_notification_list()
{
global $HAMMU_BOL_Service;
global $language;
global $Userservice;
$app = \Slim\Slim::getInstance();
$app->response->headers->set('Content-Type', 'application/json');
$app->response->setStatus(200);
$inviterId = $app->request()->params("inviterId");
$lang_id = $app->request()->params("lang_id");
$inviteeId_loop = null;
$rarray = $HAMMU_BOL_Service->findEscortListByIds($inviterId);
$datas = json_decode(json_encode($rarray, true), true);
$meet_location = "";
$longitude = "";
$latitude = "";
$instruction = "";
$final_date = "";
getCurrentLanguages($lang_id);
if (!empty($datas)) {
$return_array = array();
$data_content = "";
foreach ($datas as $key => $data) {
$flag = NULL;
$inviteeUsername = $Userservice->getUserName($data["inviterId"]);
$date = date("Y-m-d H:i", $data["timestamp"]);
$time = date("H:i", $data["timestamp"]);
$data_timestamp = $data["data"];
$json_string = isJSON($data_timestamp);
if (!empty($json_string)) {
$meet_location_result = json_decode($data_timestamp);
$meeting_data_arr = (array) $meet_location_result;
if (in_array($meeting_data_arr['meet_location'], $meeting_data_arr)) {
$meet_location = $meeting_data_arr['meet_location'];
}
if (in_array($meeting_data_arr['latitude'], $meeting_data_arr)) {
$latitude = $meeting_data_arr['latitude'];
}
if (in_array($meeting_data_arr['longitude'], $meeting_data_arr)) {
$longitude = $meeting_data_arr['longitude'];
}
if (in_array($meeting_data_arr['instruction'], $meeting_data_arr)) {
$instruction = $meeting_data_arr['instruction'];
}
if (in_array($meeting_data_arr['date'], $meeting_data_arr)) {
$data_content = $final_date = date("Y-m-d H:i", $meeting_data_arr['date']);
}
} else {
if ($data_timestamp) {
$data_content = date("Y-m-d H:i", $data_timestamp);
}
}
// echo $data["action"];
// die;
$message = $language->text('hammu', $data["action"] . "_noti", array('user' => $inviteeUsername, "date" => $date, "time" => $time, "data" => $data_content));
// echo $message;
// die;
$flag = "none";
if ($data["action"] == "invitation_sent" || $data["action"] == "client_re_arrange") {
$flag = "accept";
} else {
if ($data["action"] == "client_agree") {
$flag = "propose_date";
} else {
if ($data["action"] == 'buy_rose') {
$flag = "none";
} else {
if ($data["action"] == 'buy_rose_client') {
$flag = "none";
}
}
}
}
if ($inviteeId_loop != $data["inviterId"]) {
$inviteeId_loop = $data["inviterId"];
$user_infos = getUserInfo($inviteeId_loop);
}
$user_infos["meet_location"] = $meet_location;
$user_infos["latitude"] = $latitude;
$user_infos["longitude"] = $longitude;
$user_infos["instruction"] = $instruction;
$user_infos["propose_date"] = $final_date;
$return_array[] = array("message" => $message, "id" => $data["id"], "data" => $data["data"], "flag" => $flag, "action" => $data["action"], "seen_unseen" => $data["flag"], "inviterId" => $data["inviterId"], "user_info" => $user_infos, "date" => date("Y/m/d H:i", $data["timestamp"]));
}
$return_data = array("response_status" => "1", "data" => $return_array);
$app->response->setBody(json_encode($return_data));
} else {
$return_data = array("response_status" => "0", "response_message" => "You have No Notification");
$app->response->setBody(json_encode($return_data));
}
}
function findCurrentOnlineStutus()
{
global $OWgetDbo;
$app = \Slim\Slim::getInstance();
$app->response->headers->set('Content-Type', 'application/json');
$app->response->setStatus(200);
$Id = $app->request()->params("user_id");
$lang_id = (int) $app->request()->params("lang_id");
$currentLanguageId = getCurrentLanguages($lang_id);
$sql = "SELECT available FROM " . OW_DB_PREFIX . "skapi WHERE userId={$Id}";
$result = $OWgetDbo->queryForList($sql);
$available = $result[0]['available'];
if ($currentLanguageId == '32') {
$message = "Erfolgreiche Suche";
} else {
if ($currentLanguageId == '33') {
$message = "Exito";
} else {
$messages = "Successful";
}
}
$return_data = array("response_status" => "1", "response_message" => $messages, "data" => $available);
$app->response->setBody(json_encode($return_data));
}
function roseInvites()
{
global $HAMMU_BOL_Service;
$app = \Slim\Slim::getInstance();
$app->response->headers->set('Content-Type', 'application/json');
$app->response->setStatus(200);
//Lang Call Start
$hammu_lang_id = $app->request()->params("lang_id");
if (!empty($hammu_lang_id)) {
getCurrentLanguages($hammu_lang_id);
}
//Lang Call end
$inviterId = $app->request()->params("inviterId");
$inviteeId = $app->request()->params("inviteeId");
$rarray = $HAMMU_BOL_Service->invite_rose($inviterId, $inviteeId);
if (count($rarray) > 0) {
$return_data = array("response_status" => "1", "response_message" => "Invitation Buy Rose!");
$app->response->setBody(json_encode($return_data));
} else {
$return_data = array("response_status" => "0", "response_message" => "Invitation not Buy Rose or already Buy Rose!");
$app->response->setBody(json_encode($return_data));
}
}
