File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/NurSoft/NurSMS/NurSMSdergo.php

<?php
include_once("MobileAppApi/lidhu_me_db.php");

if ($_POST["veprimi"] =="updatesms" && $_POST["smsid"] !="" && $_POST["cel"] !="") {
	$smsid = preg_replace("/[^0-9]/", "", $_POST["smsid"]);
	$vlera = preg_replace("/[^0-9]/", "", $_POST["vlera"]);
	$cel = preg_replace("/[^0-9+]/", "", $_POST["cel"]);
	//$chcek_first_number = substr($cel, 0, 1);
	//if($chcek_first_number != "0"){ $cel = "+".$cel; }
	$pergjigja_delivered = strip_tags($_POST["pergjigja_delivered"]);
	$pergjigja_sent = strip_tags($_POST["pergjigja_sent"]);
	$data_ora = date("Y-m-d H:i:s");
	
	if(isset($_POST["derguar_kerkese"]) && $_POST["derguar_kerkese"] !="") { $kerkese_sql = " derguar_kerkese = '1', derguar_kerkese_data = '$data_ora' "; }
	if(isset($_POST["pergjigja_sent"]) && $_POST["pergjigja_sent"] !="") { $kerkese_sql = " pergjigja_sent = '$pergjigja_sent', sms_sent = '$vlera', sms_sent_data = '$data_ora' "; }
	if(isset($_POST["pergjigja_delivered"]) && $_POST["pergjigja_delivered"] !="") { $kerkese_sql = " pergjigja_delivered = '$pergjigja_delivered', sms_delivered = '$vlera', sms_delivered_data = '$data_ora' "; }
	$conn->query("UPDATE sms SET $kerkese_sql WHERE id = '$smsid' AND cel = '$cel'");
	echo "UPDATE sms SET $kerkese_sql WHERE id = '$smsid' AND cel = '$cel'";
	exit();
}

if ($_POST["klienti"] !="" && $_POST["numrat"] !="" && isset($_POST["ShtoListe"])) {
	$titulli = $_POST["titulli"];
	$klienti = $_POST["klienti"];
	$aktiv = $_POST["aktiv"];
	$numrat = explode("\r\n", $_POST['numrat']);

$listat = $conn->query("INSERT INTO `listat`(`emri`, `user_id`, `klient_id`, `aktiv`) VALUES('$titulli','0','$klienti','$aktiv')");
	$list_id = $conn->insert_id;
	foreach($numrat as $numri){
		if($numri !=""){
	$conn->query("INSERT INTO `nr_telefoni`(`klient_id`, `cel`, `emri`, `user_id`, `aktiv`, `list_id`) VALUES('$klienti','$numri','','$user_id','$aktiv','$list_id')");
		}
	}
	
	echo "<p style='font-size:25px;color:green;text-align:center;font-weight:bold;width:100%;'>Lista u shtua me sukses!</p>";
header( "refresh:2;url=NurSMSdergo.php" );
}
if($_POST["mesazhi"] !="" && $_POST["titulli"] !="" && $_POST["paisja"] !="" && $_POST["lista"] !="") {
	$titulli = strip_tags($_POST["titulli"]);
	$mesazhi = strip_tags($_POST["mesazhi"]);
	$klienti = $_POST["klienti"];
	$paisja = preg_replace('#[^0-9]#i', '', $_POST["paisja"]);
	$lista = preg_replace('#[^0-9]#i', '', $_POST["lista"]);
	$fushata = $conn->query("INSERT INTO `fushatat`(`titulli`, `mesazhi`, `user_id`, `klient_id`, `dervice_id`,`token`,`paisja`,`nga`,`list_id`)VALUES('$titulli','$mesazhi','$klienti','$klienti','','','$paisja','Web','$lista')");
	$fushataid = $conn->insert_id;
	"SELECT * FROM `nr_telefoni` WHERE klient_id = '$klienti' AND list_id = '$lista' AND aktiv = '1'";
	$num = $conn->query("SELECT * FROM `nr_telefoni` WHERE klient_id = '$klienti' AND list_id = '$lista' AND aktiv = '1'");
	$numrat= "";
	 if ($num->num_rows > 0) { 
		 while($numbers = $num->fetch_assoc()) {
  $cel = preg_replace("/[^0-9+]/", "", $numbers["cel"]);
//$check_if_exist = $conn->query("SELECT id FROM `sms` WHERE klient_id = '$klienti' AND cel = '$cel'");
//if($check_if_exist->num_rows == 0) { 
				 $conn->query("INSERT INTO `sms`(`nr_celi_id`, `klient_id`, `cel`, `msg`, `user_id`, `fushat_id`, `list_id`) VALUES('$numbers[id]','$klienti','$cel','$mesazhi','0','$fushataid','$lista')");
			 	$sms_id = $conn->insert_id;		
		 $numrat .= $cel.":".$sms_id.",";
//	 }	
	}	 
	$numrat =  rtrim($numrat,",");
	send_android_push($numrat, $mesazhi, $paisja, "null", $fushataid);
	}
	echo "<p style='font-size:25px;color:green;text-align:center;font-weight:bold;width:100%;'>Mesazhi u dergua me sukses!</p>";
header( "refresh:5;url=NurSMSdergo.php" );
}

?>
<form action="" method="POST" style="width:50%;margin:0 auto;">
	<input type="text" style="width:100%;height:40px;" name="titulli" placeholder="Emri i fushates (Arsyeja, etj)">
	<textarea name="mesazhi" style="height:300px; width:100%;" placeholder="Mesazhi"></textarea>
	<select name="klienti" style="width:100%;height:40px;">
	<option value="">Zgjidh Klientin</option>
		<?php  $result = $conn->query("SELECT emri,id FROM `klient`"); if ($result->num_rows > 0) { while($to = $result->fetch_assoc()) { ?>
	<option value="<?php echo $to["id"]; ?>"><?php echo $to["emri"]; ?></option>
		<?php } } ?>
	</select>
		<select name="paisja" style="width:100%;height:40px;">
	<option value="">Zgjidh Paisjen</option>
		<?php  $result = $conn->query("SELECT name,id FROM `android_devices`"); if ($result->num_rows > 0) { while($to = $result->fetch_assoc()) { ?>
	<option value="<?php echo $to["id"]; ?>"><?php echo $to["name"]; ?></option>
		<?php } } ?>
	</select>
		<select name="lista" style="width:100%;height:40px;">
	<option value="">Zgjidh Listen</option>
		<?php  $result = $conn->query("SELECT emri,id FROM `listat`"); if ($result->num_rows > 0) { while($to = $result->fetch_assoc()) { ?>
	<option value="<?php echo $to["id"]; ?>"><?php echo $to["emri"]; ?></option>
		<?php } } ?>
	</select>
	<input type ="submit" name="dergosms" value="Dergo">
	</form>
</br></br></br></br>
<form action="" method="POST" style="width:50%;margin:0 auto;">
	<input type="text" style="width:100%;height:40px;" name="titulli" placeholder="Emri i listes">
	<textarea name="numrat" style="height:300px; width:100%;" placeholder="Numrat"></textarea>
	<select name="klienti" style="width:100%;height:40px;">
	<option value="">Zgjidh Klientin</option>
		<?php  $result = $conn->query("SELECT emri,id FROM `klient`"); if ($result->num_rows > 0) { while($to = $result->fetch_assoc()) { ?>
	<option value="<?php echo $to["id"]; ?>"><?php echo $to["emri"]; ?></option>
		<?php } } ?>
	</select>
	<select name="aktiv" style="width:100%;height:40px;">
	<option value="1">Aktiv</option>
	<option value="0">InAktiv</option>
	</select>
	<input type ="submit" name="ShtoListe" value="Shto">
	</form>

Batal

⬅ Naik ke NurSoft 2 item

Nama	Tipe	Ukuran	Diubah	Aksi
📁MobileAppApi	dir	—	2020-04-06 17:12	📂 Buka
🐘NurSMSdergo.php	php	5.7 KB	2020-04-06 16:47	✏️ Edit 👁️ View