File Manager

✏️ Edit File: /var/www/vhosts/nursoft.al/public_html/SmileSoft/login/Nklinik_php_files/model_posi.php

<?php
error_reporting(0);
ini_set('display_errors', 0);
define('INCLUDE_CHECK',1);
include "dbconnect.php";
include_once("status.php");
$dt_a = date("Y-m-d H:i:s");
$klinik_id = $_SESSION["klinik_id"];
$tipi = preg_replace('#[^0-9 A-Za-z -_.,]#', '',$_POST["tipi"]);
if(isset($_POST["delete_id"])){ $sql = mysql_query("DELETE FROM sales_order WHERE transaction_id = '".preg_replace('#[^0-9]#', '',$_POST["delete_id"])."' AND klinik_id = '$klinik_id'"); exit(); }
if(isset($_POST["emertimi"]) && isset($_POST["njesia_shto"]) && isset($_POST["sasia"]) && isset($_POST["cpatvsh"])){

$emertimi = strip_tags($_POST["emertimi"]);$njesia_shto = strip_tags($_POST["njesia_shto"]);
$sasia = preg_replace('#[^0-9]#', '',$_POST["sasia"]);
$cpatvsh = preg_replace('#[^0-9]#', '',$_POST["cpatvsh"]);
$tvshja = preg_replace('#[^0-9]#', '',$_POST["tvshja"]);$barkodi = preg_replace('#[^0-9]#', '',$_POST["barkodi"]);
mysql_query("INSERT INTO `produkte`(`titulli`, `data`, `cmimi_bleres`,
`njesia`, `sasia`, `sasi_shitur`, `tvsh`, `barkodi`, `klinik_id`) VALUES
('$emertimi','$dt_a','$cpatvsh','$njesia_shto','$sasia','0','$tvshja','$barkodi','$klinik_id')");
$b =  mysql_insert_id();$c = $sasia;}else{$b = preg_replace('#[^0-9]#', '',$_POST['product']);$c = preg_replace('#[^0-9]#', '',$_POST['qty']);}
$product_code =  strip_tags($_POST['product_code']);
$doktor_id = preg_replace('#[^0-9]#', '',$_POST['doktorri']);
$customer_id = preg_replace('#[^0-9]#', '',$_POST['furnitori']);
$recet_id = preg_replace('#[^0-9]#', '',$_POST['recet_id']);
$recete_gati_id = preg_replace('#[^0-9]#', '',$_POST['recete_gati_id']);
$pacientii = preg_replace('#[^0-9]#', '',$_POST['pacient_id']);
$date = date("m/d/y");
$radha = strip_tags($_POST['takim_id']);
$artikulli= strip_tags($_POST['artikulli']);
$gjendja= strip_tags($_POST['gjendja']);
$receta = mysql_fetch_array(mysql_query("SELECT * FROM receta_gati where id='$recete_gati_id' AND klinik_id = '$klinik_id'"));
$rsow = mysql_fetch_array(mysql_query("select *  from perdorues where id = '$_SESSION[userid]' AND klinik_id = '$klinik_id'"));
if($_POST['skonto'] > $rsow["skonto"]){$skonto= $rsow["skonto"];}else{$skonto= preg_replace("/[^0-9]/", "",$_POST['skonto']);}
$percent=$receta["skonto"] / 100;
if(empty($product_code) && !empty($b))
{
$prod = mysql_query("SELECT * FROM produkte where id='$b' AND aktiv = '1'  AND klinik_id = '$klinik_id' ");
}
elseif($product_code !="")
{
$prod = mysql_query("SELECT * FROM produkte where barkodi='$product_code' AND aktiv = '1' AND klinik_id = '$klinik_id' ");
if(mysql_num_rows($prod) < 1){ echo "no_exist"; exit(); }
}
if(empty($product_code) && empty($b) && !empty($skonto)){mysql_query("UPDATE sales_order SET discount='$skonto',pacient_id='$pacientii' WHERE invoice='$_SESSION[userid]-$recet_id' AND klinik_id = '$klinik_id'");}
if($customerrow["id"] !=''){$customerid = $customerrow["id"];}else{$customerid =0;}
if(mysql_num_rows($prod) > 0)
{
$row=mysql_fetch_array($prod);
$product_id=$row['id'];
$asasa=$row['cmimi_shitjes'];
$code=$row['barkodi'];
$name=$row['titulli'];
$njesia=$row['njesia'];
$tvsh=$row['tvsh'];
$vtshjj = ($row['tvsh'] / 100);
//edit qty
$sk= $asasa - ($asasa * $percent);
$fffffff= $asasa;
$d=$fffffff * $c + ($fffffff * $vtshjj);
// query
$sql2 = "SELECT invoice FROM sales_order WHERE invoice='$_SESSION[userid]-$recet_id' AND product='$product_id' AND klinik_id = '$klinik_id' ";
$asdasd2 = mysql_query( $sql2);
if(mysql_num_rows($asdasd2) > 0)
{
$sql3 = "UPDATE sales_order SET qty=qty+'$c',amount=amount+'$d', artikulli='$artikulli',gjendja='$gjendja',pacient_id='$pacientii', discount='$skonto', doktor_id='$doktor_id' WHERE invoice='$_SESSION[userid]-$recet_id' AND product='$product_id' AND klinik_id = '$klinik_id'";
$asdasd3 = mysql_query( $sql3);
}
else
{$sqlaa = mysql_query("SELECT transaction_id from sales_order WHERE invoice='$_SESSION[userid]-$recet_id' AND product = '1' AND name = 'Recete' AND klinik_id = '$klinik_id'");
if(mysql_num_rows($sqlaa) > 0)
{
$kka = mysql_fetch_array($sqlaa);
$sql = mysql_query("UPDATE sales_order SET discount='".$kka["discount"]."',pacient_id='$pacientii',artikulli='".$kka["artikulli"]."',gjendja='".$kka["gjendja"]."' WHERE invoice='$_SESSION[userid]-$recet_id' AND klinik_id = '$klinik_id'");
mysql_query("DELETE from sales_order WHERE invoice='$_SESSION[userid]-$recet_id' AND product = '1' AND name = 'Recete' AND klinik_id = '$klinik_id' ");
}
$sql4 = "INSERT INTO sales_order(invoice,product,qty,amount,name,price,product_code,date,user_id, discount, njesia, tvsh, tipi,artikulli,gjendja,klinik_id,pacient_id,doktor_id) 
VALUES
('$_SESSION[userid]-$recet_id','$product_id','$c','$d','$name','$fffffff','$code','$date','$customerid','$skonto','$njesia','$tvsh','$tipi',
'$artikulli','$gjendja','$klinik_id','$pacientii','$doktor_id')";
$asdasd4 = mysql_query($sql4);
echo mysql_error();
}

if(isset($_POST["emertimi"]) && isset($_POST["njesia_shto"]) && isset($_POST["sasia"]) && isset($_POST["cpatvsh"])){exit();}
if($row['sasia'] <= $row['limiti'] && $tipi !="fature_blerje"){
?>
<div class="alert alert-danger alert-dismissible fade in mb-2" role="alert">
<button type="button" class="close" data-dismiss="alert" aria-label="Close">
<span aria-hidden="true" style=" font-weight: 300;">×</span>
</button>
<strong><?php echo $lang["FB"]; ?>Kujdes ! sasia e <?php echo $row['titulli']; ?><?php echo $lang["FB"]; ?> është nën limitin e caktuar</strong>
</div> <?php  } }?>
<script>document.getElementById('perscroll').scrollTop = 1000000000000000000000000000;
function edit_data(id, text, column_name)
{
$.ajax({
url:"Nklinik_php_files/savesales.php",
method:"POST",
data:{id:id, text:text, column_name:column_name},
dataType:"text",
success:function(data){
if(column_name!="skonto"){ add_product("shikoo"); }} });
}
$(document).on('blur', '.qty', function(){
var id = $(this).data("id1");
var qty = $(this).text();
edit_data(id, qty, "qty");
});

$(document).on('blur', '.skonto', function(){
var id = $(this).data("ids");
var skonto = $(this).val();
edit_data(id, skonto, "skonto");
});
$(document).on('blur', '.artikulli', function(){
var id = $(this).data("idaa");
var artikulli = $(this).html();
edit_data(id, artikulli, "artikulli");
});
$(document).on('blur', '.gjendja', function(){
var id = $(this).data("idg");
var gjendja = $(this).html();
edit_data(id, gjendja, "gjendja");
});
var timeout = null;
function ndrysho_sasine(id,v){
var qty = $("#sasia"+id).val();
clearTimeout(timeout);
timeout = setTimeout(function () {  qty = +qty + +v; edit_data(id, qty, "qty");  }, 200);
}

jQuery('.quantity').each(function() {
var spinner = jQuery(this),
input = spinner.find('input[type="number"]'),
btnUp = spinner.find('.quantity-up'),
btnDown = spinner.find('.quantity-down'),
min = input.attr('min'),
max = input.attr('max');

btnUp.click(function() {
var oldValue = parseFloat(input.val());
if (oldValue >= max) {
var newVal = oldValue;
} else {
var newVal = oldValue + 1;
}
spinner.find("input").val(newVal);
spinner.find("input").trigger("change");
});

btnDown.click(function() {
var oldValue = parseFloat(input.val());
if (oldValue <= min) {
var newVal = oldValue;
} else {
var newVal = oldValue - 1;
}
spinner.find("input").val(newVal);
spinner.find("input").trigger("change");
});

});
</script>

input[type=number]::-webkit-inner-spin-button,
input[type=number]::-webkit-outer-spin-button
{
-webkit-appearance: none;
margin: 0;
}

input[type=number]
{
-moz-appearance: textfield;
}

.quantity input {
width: 50px;
height: 35px;
line-height: 1.65;
text-align: center;
display: block;
padding: 0;
margin: 0;
float:left;
border: 0 !important;
position: relative;
}

.quantity input:focus {
outline: 0;
}

.quantity-nav {
float: left;
position: relative;
height: 42px;
}
[contentEditable=true]:empty:not(:focus):before{ content:attr(data-text) }
.quantity-button {
position: relative;
cursor: pointer;
border-left: 1px solid #eee;
text-align: center;
color: #333;
font-size: 13px;
font-family: "Trebuchet MS", Helvetica, sans-serif !important;
line-height: 1.7;
}

.quantity-button.quantity-up {

font-size: 17px;
margin-top: 7px;
border-radius: 50%;
border: 1px solid #eee;
line-height: 1.3;
padding: 0px 7px;
position: relative;
float: right;
}

.quantity-button.quantity-down {
font-size: 17px;
margin-top: 7px;
border-radius: 50%;
border: 1px solid #eee;
line-height: 1.3;
padding: 0px 8px;
position: relative;
float: left;
}
</style>                    </script>
<style> td{    padding: 9px 5px;width:100%;}th {width:100%;
padding: 2px 5px;    font-size:11px; font-weight:normal; }.close{opacity:0.9;} .alert-danger {
border-color: #868484 !important;
background-color: #ff0019 !important;
color: #ffffff !important;
width: 100%;
margin: 0 auto;
z-index: 1;
left: 0; position:absolute;
right: 0;
margin-left: auto;
margin-right: auto;
float: none;
text-align: center;
}.nav .nav-item .nav-link{color:black;}.nav-vertical .nav-right ~ .tab-content .tab-pane{padding:0;} </style>
<?php if(!isset($_POST["fature"]) && $_POST["fature"] !="true"){ ?>
<div  id="fs" class="col-xl-7 col-lg-6 col-xs-12" style="<?php if($tipi != "Arka" && $tipi != "Doktor"){ ?>height:93.4vh;<?php }elseif($tipi == "Arka"){ ?>height:86.8vh;<?php }else{ ?>height:92.2vh;<?php } ?> overflow-y: auto;float:right; background-color:#fcfcfc;padding:0px;">
<div class="nav-vertical"><ul class="nav nav-tabs nav-right">
<?php $det =""; if($detyra !=""){$det = " AND id IN ($detyra)";} $kat = mysql_query("SELECT * FROM kategorite WHERE klinik_id = '$klinik_id' $det order by emri asc");  $x=0; while($kategorite = mysql_fetch_array($kat)){ ?>
<li class="nav-item"><a class="nav-link <?php if($x == 0){ echo "active";} ?>" style="color:black;" id="baseVerticalRight-tab<?php echo $kategorite["id"]; ?>" data-toggle="tab" aria-controls="tabVerticalRight<?php echo $kategorite["id"]; ?>" href="#tabVerticalRight<?php echo $kategorite["id"]; ?>" aria-expanded="true"><?php echo $kategorite["emri"]; ?></a></li>
<?php $x++; } ?></ul>
<div class="tab-content">
<?php $kat =mysql_query("SELECT * FROM kategorite WHERE klinik_id = '$klinik_id' $det order by emri asc"); $x=0; while($kategorite = mysql_fetch_array($kat)){ ?>
<div role="tabpanel" class="tab-pane <?php if($x == 0){ echo "active";} ?>" id="tabVerticalRight<?php echo $kategorite["id"]; ?>" aria-expanded="true" aria-labelledby="baseVerticalRight-tab<?php echo $kategorite["id"]; ?>">
<?php $produktet =mysql_query("SELECT * FROM produkte where kategoria ='$kategorite[id]' AND aktiv = '1' AND klinik_id = '$klinik_id' "); while($produktet_info = mysql_fetch_array($produktet)){ ?>
<button type="button" onclick="javascript:add_product('<?php echo $produktet_info['id']; ?>');" style="width:33%;height:70px;float:left;border: 1px solid white;background-color:#37BC9B;cursor:pointer;color:white;font-size: 16px;font-weight: bold;"><?php echo $produktet_info["titulli"]; ?></button>
<?php $x++; } ?></div><?php } ?></div>
</div>
</div>
<div class="col-xl-5 col-lg-6 col-xs-12" id="perprintt" style=" background-color:#fcfcfc;border-radius:0px; border: 1px solid #eaeaea;padding:0px;">
<?php if($recet_id != "0"){ ?>
<input class="form-control"  id="complaintinps" type="text" style="border-radius:0;width:100%;background-color:white;border-radius:0!important;" value="<?php if($tipi == "Doktor"){$pc = $recet_id; }else{ $pc = $receta["pacient_id"];} $pacienti = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$pc' AND klinik_id = '$klinik_id' ")); echo $pacienti["emri"]; ?>" readonly>
<div data-idg=<?php echo $_SESSION["userid"]."-".$recet_id; ?> id="gjendja" style="border-radius:0!important;width:100%;<?php if($rsow["kategoria"] != "Doktor"){ ?>min-height:188px; <?php }else{ ?>min-height:22vh;<?php } ?> background-color:white;" class="gjendja form-control" name="gjendja" <?php if($rsow["kategoria"] == "Doktor" || $rsow["kategoria"] == "Admin"){ ?>contenteditable="true" <?php } ?> data-text="Gjendja / Përshkrim i trajtimeve"><?php $rrresult =mysql_fetch_array(mysql_query("SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id' ORDER BY transaction_id ASC LIMIT 1"));  if($rrresult["gjendja"] !=""){ echo $rrresult["gjendja"]; } ?></div>
<div data-idaa=<?php echo $_SESSION["userid"]."-".$recet_id; ?> id="complaintinput5" style="border-radius:0!important;width:100%;<?php if($rsow["kategoria"] != "Doktor"){ ?>min-height:188px; <?php }else{ ?>min-height:22vh;<?php } ?>  background-color:white;display:block !important;" class="artikulli form-control" name="complaintdetails" <?php if($rsow["kategoria"] == "Doktor" || $rsow["kategoria"] == "Admin"){ ?>contenteditable="true" <?php } ?> data-text="Rp..."><?php $rrresult =mysql_fetch_array(mysql_query("SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id' ORDER BY transaction_id ASC LIMIT 1")); if($rrresult["artikulli"] == "" && $receta["artikulli"] !=""){ ?><?php echo nl2br($receta["artikulli"]); ?><?php }elseif($rrresult["artikulli"] !=""){ echo $rrresult["artikulli"]; } ?></div>

<div  style="float:right; <?php if($rsow["skonto"] > 0){ ?> display:none; <?php } ?> width:100%;">
<input type="number" min="0"  style="width:100%;" data-ids=<?php echo $_SESSION["userid"]."-".$recet_id; ?> max="<?php echo $rsow["skonto"]; ?>" id="skonto" class="skonto form-control" value="<?php  $uljee = $rrresult["discount"]; echo $rrresult["discount"]; ?>" placeholder="Skonto" name="skonto">
</div>    <?php } } ?>
<table id="print" style="width:100%;">
<tbody id="perscroll" style="overflow-y:auto; overflow-x:hidden; <?php if($recet_id != "0" && $tipi != "Arka" && $tipi != "Doktor"){ ?>max-height:310px;height:310px;<?php }elseif($recet_id != "0" && $tipi == "Arka"){ ?> height:268px; max-height:268px; <?php }elseif($tipi != "Doktor"){ ?>max-height:75vh;height:75vh;<?php }elseif($tipi == "Doktor"){ ?>max-height:220px;height:220px;<?php } ?>width:100%; background-color:#fff; float:left; border: 1px solid #eaeaea;border-radius:0;margin-bottom:0;">
<tr class="cart__row cart__header-labels" style="border-bottom: 1px solid #eaeaea;">
<td style="padding-left:20px; text-align:left !important;" class="emertimi"><?php echo $lang["FB"]; ?>Emërtimi</td>
<td style="min-width:100px;text-align:center;"><?php echo $lang["FB"]; ?>Sasia</td>
<?php if($_SESSION["shikocmimet"] == "1"){ ?>
<td style="min-width:100px;text-align:center;"><?php echo $lang["FB"]; ?>Cmimi</td>
<td style="min-width:100px;text-align:center;" colspan="2"><?php echo $lang["FB"]; ?>Vlera</td>
<?php } ?>
</tr>

<?php $totam=0;$totam2=0;
$skonto_pacient = mysql_fetch_array(mysql_query("SELECT buxhet,skonto FROM pacient where id='$pacientii' AND klinik_id = '$klinik_id'"));
$kursi = mysql_fetch_array(mysql_query("SELECT euro,usd FROM klinikat where id = '$klinik_id'"));
$result ="SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id' ORDER BY transaction_id ASC";
$prod = mysql_query($result);
$mer_id_e_pacientit_per_kontroll ="";
while($row = mysql_fetch_array($prod)){
	$mer_id_e_pacientit_per_kontroll = $row["pacient_id"];
$produkti_monedh = mysql_fetch_array(mysql_query("select monedha from produkte where id = '$row[product]' AND klinik_id = '$klinik_id'"));
if($produkti_monedh['monedha'] =="$"){$ppp=($row['price'] * $kursi["usd"]) * 100;}elseif($produkti_monedh['monedha'] =="€"){$ppp=($row['price'] * $kursi["euro"]) * 100;}else{$ppp=$row['price'];}
?>
<tr class="cart__row table__section" style="border-bottom: 1px solid #eaeaea;">
<td style="text-align:left !important;"><button  name="delete_btn" onclick="javascript:delete_p_id('<?php echo $row['transaction_id']; ?>');" id="delete" type='button' style="float:left;background-color:red;border-radius: 50%;padding: 1px 5px 2px 7px;color:white;font-size: 10px;border: 0;cursor: pointer;margin-top: 2px;margin-right: 5px;"><small><i class="icon-close2" style="margin-left: -2px;"></i></small></button> <?php echo $row['name']; ?></td>
<td style="text-align:center;position:relative;padding:0;">
<div class="quantity">
<div class="quantity-button quantity-down" onclick="ndrysho_sasine(<?php echo $row['transaction_id']; ?>,-1)">-</div>
<input type="number" class="qty" min="1" onkeyup="ndrysho_sasine(<?php echo $row['transaction_id']; ?>,0)" step="1" onclick="this.focus();this.select()" id="sasia<?php echo $row['transaction_id']; ?>" value="<?php echo $row['qty']; ?>" value="1">
<div class="quantity-button quantity-up" onclick="ndrysho_sasine(<?php echo $row['transaction_id']; ?>,1)">+</div>
</div>
</td><?php if($_POST["ndryshopacient"] == "true"){ $sko = $skonto_pacient["skonto"]; } else {if($skonto !=""){ $sko = $skonto; }else{ if($skonto_pacient["skonto"] !=""){ $sko = $skonto_pacient["skonto"]; }else{$sko = $row['discount']; }}}  $pppa=$ppp * $row['qty']; $pppa2= ($ppp - ($ppp * ($sko / 100))) * $row['qty']; if($_SESSION["shikocmimet"] == "1"){ ?>
<td style="text-align:center;min-width:80px;"><?php echo number_format($ppp,2); ?></td>

<td  colspan="2" style="text-align:center;"><?php echo number_format($pppa,2); ?></td><?php } ?>
<?php $totam += $pppa; $totam2 += $pppa2; ?>
</tr>
<?php } 
	if($mer_id_e_pacientit_per_kontroll != $pacientii){ mysql_query("update sales_order set pacient_id = '$pacientii' WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id'"); } 
	?>
</tbody>
<tbody style="width:100%; background-color:#fff; float:left;margin-bottom:0;">
<tr  style='border-top:2px solid black;' class="cart__row table__section">
<?php if($_SESSION["category"] != "Doktor"){ ?><td style="border: none; padding:0;">
<input type="number" min="0"  style="float:left; width:70px;<?php if($rsow["skonto"] == 0){ ?> display:none;<?php } ?>" data-ids="<?php echo $_SESSION["userid"]."-".$recet_id; ?>" onblur="add_product('shikoo');" max="<?php echo $rsow["skonto"]; ?>" id="skonto_posi" class="skonto_posi form-control input-sm" value="<?php echo $sko; ?>" placeholder="<?php echo $lang["FB"]; ?>Skonto" name="skonto_posi">
<select id="monedha" class="form-control input-sm" style="cursor: pointer;float:left;">
<?php if(!empty($_POST["monedha"])){ ?><option value="<?php echo $_POST["monedha"]; ?>"><?php echo $_POST["monedha"]; ?></option><?php }else{ ?><option value="Lekë"><?php echo $lang["FB"]; ?>Lekë</option><?php } ?>
<option value="€">€</option>
<option value="$">$</option>
</select><select id="metoda_pageses" onchange="kontrollobuxhetin()" class="form-control input-sm" style="cursor: pointer;">
<?php if(!empty($_POST["metoda_pageses"])){ ?><option value="<?php echo $_POST["metoda_pageses"]; ?>"><?php echo $_POST["metoda_pageses"]; ?></option><?php }else{ ?><option value="Kesh"><?php echo $lang["FB"]; ?>Kesh</option><?php } ?>
<option value="Bankë"><?php echo $lang["FB"]; ?>Bankë</option>
<option value="Debit"><?php echo $lang["FB"]; ?>Debit</option>
	<?php if($skonto_pacient["buxhet"] > 0){ ?><option value="Buxhet"><?php echo $lang["FB"]; ?>Buxhet</option><?php } ?>
	<option value="Preventiv"><?php echo $lang["FB"]; ?>Preventiv</option>
</select></td><?php } ?><td style="border: none; none;min-width:90px; font-size:11px; font-weight:bold; color:green;"><?php $euro = ($totam2  / 100) / $kursi["euro"];  $dollar = ($totam2 / 100) / $kursi["usd"]; echo number_format($euro,2)." €"; echo "</br>"; echo number_format($dollar,2)." $"; ?></td>
<td style="border: none;min-width: 100px;"><?php if($sko > 0){  echo "<b style='font-size:11px;'>"; echo $sko."% skonto</b>"; }?></td>
<?php if($_SESSION["category"] != "Doktor"){ ?>
<td style="text-align:center;"><?php if($receta["skonto"] > 0 || $sko > 0){ echo "<b>".number_format($totam2,2)."</b>"; echo "<span style='margin-left : 10px;color:red; text-decoration: line-through;'><b>".number_format($totam,2)."</b></span>"; }else{ echo "<b>".number_format($totam,2)."</b>"; } ?> </td><?php } $total_skonto = $totam - $totam2; ?>
</tr>
</tbody>
</table>
<script>
function kontrollobuxhetin(){
	<?php 
if($receta["skonto"] > 0 || $sko > 0){ $totaasdawdasdli = $totam2; } else{ $totaasdawdasdli = $totam; }
$amsndakjhsdkjaw = $totaasdawdasdli - $skonto_pacient["buxhet"];
if($skonto_pacient["buxhet"] < $totaasdawdasdli){ ?>
	if($("#metoda_pageses").val() == "Buxhet") {
	alert("<?php echo $lang["FB"]; ?>KUJDES! Totali i fatures eshte me i larte se buxheti i pacientit, per mbetjen prej <?php echo number_format($amsndakjhsdkjaw,2); ?> do te gjeneroherohet fature automatike nga sistemi si pagese ne formen KESH");
		}
	<?php } ?>
	if($("#metoda_pageses").val() == "Preventiv") {
$("#fature_preventiv").html("Preventiv")
		} else {
$("#fature_preventiv").html("Faturë");
		}
	}
		<?php if($_POST["metoda_pageses"] != "Preventiv"){ ?> $("#fature_preventiv").html("Faturë"); <?php } ?>
</script>
</div>
<?php  if(mysql_num_rows($prod) < 1){ echo"<script>
document.getElementById('saveposandprint').disabled = true;
document.getElementById('saveposandprint').style.cursor='not-allowed';
document.getElementById('saveperf').style.cursor='not-allowed';
document.getElementById('saveperf').disabled = true;</script>";
if($_POST["tipi_kekeses"] == "POS"){ echo "<script>document.getElementById('fiskal').style.cursor='not-allowed';
document.getElementById('fiskal').disabled = true;</script>"; }
}else{ echo "<script>document.getElementById('saveposandprint').style.cursor='pointer';
document.getElementById('saveperf').style.cursor='pointer'; ";
if($_POST["tipi_kekeses"] == "POS"){echo "document.getElementById('fiskal').style.cursor='pointer'; "; }
echo "document.getElementById('saveposandprint').disabled = false;
document.getElementById('saveperf').disabled = false;";
if($_POST["tipi_kekeses"] == "POS"){ echo "document.getElementById('fiskal').disabled = false;"; }
echo "</script>";
}
$dt_ora = date("Y-m-d H:i:s");
$metoda_pageses = preg_replace("/[^0-9A-za-z ]/", "", $_POST['metoda_pageses']);
$monedha = strip_tags($_POST['monedha']);

if($metoda_pageses == ""){ $metoda_pageses = "Debit"; }
if(isset($_POST["printo"]) && $_POST["tipi"] == "Arka"){
if($metoda_pageses=="Debit"){ $aaaaa = '0'; }else{ $aaaaa ='1'; }
if($metoda_pageses=="Buxhet"){ $buxh = '1'; 
mysql_query("update pacient set buxhet = buxhet - '$totam2' WHERE id = '$pacientii' AND klinik_id = '$klinik_id'");	 
							 }else{ $buxh ='0'; }
mysql_query("INSERT INTO `fatura`(`data`, `user_id`, `shitur_nga`, `totali`, `skonto`, `pacient_id`, `metoda_pageses`,
`arka`, `orari_arkes`,`total_skonto`,`monedha`,`euro`,`dollar`,`klinik_id`, `pagese_me_buxhet`) VALUES('$dt_a',
'$_SESSION[userid]','$tipi','$totam2','$sko','$pacientii','$metoda_pageses','$aaaaa','$dt_ora','$total_skonto'
,'$monedha','$euro','$dollar','$klinik_id','$buxh')");
$faturidd = mysql_insert_id();
echo mysql_error();$emri_pacientit = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$pacientii' AND klinik_id = '$klinik_id'"));
echo "<script>$('#nrfatures').html('".$faturidd."');</script>";echo "<script>$('#emri_pacientit').html('".$emri_pacientit['emri']."');</script>";
$zgjidh=mysql_query("SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND (tipi = 'Arka' OR tipi = 'Perpunimi')     AND klinik_id = '$klinik_id'");
while($zgjidhrow = mysql_fetch_array($zgjidh)){
$produkti_monedh = mysql_fetch_array(mysql_query("select monedha from produkte where id = '$zgjidhrow[product]'    AND klinik_id = '$klinik_id'"));
if($produkti_monedh['monedha'] =="$"){$tot=(($zgjidhrow['price'] * $kursi["usd"]) * 100) * $zgjidhrow["qty"];}elseif($produkti_monedh['monedha'] =="€"){$tot=(($zgjidhrow['price'] * $kursi["euro"]) * 100) * $zgjidhrow["qty"];}else{$tot=$zgjidhrow['price']  * $zgjidhrow["qty"];}
$tek_dollar = ($tot / 100) / $kursi["usd"];
$tek_euro = ($tot / 100) / $kursi["euro"];
	$asdjakwdlakwdklj = ($zgjidhrow['price']  * $zgjidhrow["qty"]) * ($sko / 100);
mysql_query("INSERT INTO  `produkte_te_shitura`(`produkt_id`, `pacient_id`, `user_id`, `data`, `sasia`, `skonto`, `arka`,
`shitur_nga`, `cmimi`, `recete_id`, `fature_id`, `metoda_pageses`, `dorezuar`,`total_skonto`,`monedha`,`euro`,`dollar`,`klinik_id`, `pagese_me_buxhet`) VALUES('$zgjidhrow[product]','$pacientii', '$_SESSION[userid]','$dt_a',
'$zgjidhrow[qty]','$sko','1','$tipi','$tot','$recet_id',' $faturidd','$metoda_pageses','$dt_ora','$asdjakwdlakwdklj','$monedha','$tek_euro','$tek_dollar','$klinik_id','$buxh')");
$ing=mysql_query("SELECT * FROM ingredientet WHERE produkt_id= '$zgjidhrow[product]' AND klinik_id = '$klinik_id'");
while($ingreditnt = mysql_fetch_array($ing)){
if($ingreditnt["njesia"] !="Copë"){ $assssdd = "0.".$ingreditnt['sasia']; }else{  $assssdd = $ingreditnt['sasia']; }
mysql_query("INSERT INTO  `produkte_te_shitura`(`produkt_id`, `pacient_id`, `user_id`, `doktor_id`, `data`, `sasia`, `skonto`, `arka`,
`shitur_nga`, `cmimi`, `recete_id`, `fature_id`, `metoda_pageses`, `dorezuar`, `shenime`,`dhembet`,`total_skonto`,`monedha`,`euro`,`dollar`,`klinik_id`) VALUES('$ingreditnt[ingredient_id]','$pacientii','0','$_SESSION[userid]','$dt_a',
'$assssdd','$sko','1','$tipi','0','$recet_id',' $faturidd','$metoda_pageses','$dt_ora','Ingredient - $ingreditnt[njesia]','$zgjidhrow[dhembet]','$total_skonto','$monedha','0','0','$klinik_id')");
$inasdasd = mysql_fetch_array(mysql_query("SELECT sasi_recepture,shitur_heren_e_fundit,masa,sasia from produkte where id = '$ingreditnt[ingredient_id]' AND klinik_id = '$klinik_id'"));
$asas = $ingreditnt["sasia"] * $zgjidhrow["qty"];
$asdwaeqwe = $inasdasd["shitur_heren_e_fundit"] + $asas;$zbrit_sasine="";
$masa = $inasdasd["masa"];
if($ingreditnt["njesia"] !="Copë"){if($asdwaeqwe >= $masa){ $mbetja = $asdwaeqwe - $masa; $zbrit_sasine = " ,`sasia` = `sasia` - '$zgjidhrow[qty]'";}else{ $mbetja = $asdwaeqwe; } }else{ $asas = $ingreditnt['sasia'] * $zgjidhrow["qty"]; $mbetja = ($masa * $ingreditnt['sasia']) * $zgjidhrow["qty"]; $zbrit_sasine = " ,`sasia` = `sasia` - '$asas'";}
mysql_query("UPDATE `produkte` SET `sasi_recepture` = `sasi_recepture` - '$asas', `shitur_heren_e_fundit` = '$mbetja' $zbrit_sasine where id = '$ingreditnt[ingredient_id]' AND klinik_id = '$klinik_id'");
}
echo mysql_error();} mysql_query("DELETE FROM sales_order where invoice='$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id'");}
if(isset($_POST["printo"]) && $_POST["tipi"] == "Doktor"){
     $doktorrir = mysql_fetch_array(mysql_query("SELECT doktor_id FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id'"));
	if($doktorrir["doktor_id"] != 0){ $doktori_qe_ka_hedhur_ne_sistem = $doktorrir["doktor_id"]; }else{ $doktori_qe_ka_hedhur_ne_sistem = $_SESSION["userid"]; }
$protokolli = date("Y");
mysql_query("INSERT INTO `receta_pacientesh`(`user_id`, `pacient_id`, `artikulli`, `data`, `skonto`, `radha`, `perpunimi`, `arka`, `gjendja`, `protokolli`, `klinik_id`)
VALUES ('$doktori_qe_ka_hedhur_ne_sistem','$recet_id','$artikulli','$dt_ora','$sko','$radha','1','1','$gjendja','$protokolli','$klinik_id')");
$rec_r_id = mysql_insert_id();
echo mysql_error();
$nr_serial = sprintf("%08d", $rec_r_id);
mysql_query("UPDATE `receta_pacientesh` SET `nr_serial`='$nr_serial',`nr_serial_protokoll` ='$nr_serial / $protokolli' WHERE id = '$rec_r_id' AND klinik_id = '$klinik_id'");
mysql_query("INSERT INTO `fatura`(`data`, `user_id`,`doktor_id`, `shitur_nga`, `totali`, `skonto`, `recete_id`, `pacient_id`, `metoda_pageses` ,`total_skonto`,`monedha`,`euro`,`dollar`,`klinik_id`)
VALUES('$dt_a','0','$doktori_qe_ka_hedhur_ne_sistem','$tipi + Arka','$totam2','$sko','$rec_r_id','$recet_id','$metoda_pageses','$total_skonto','$monedha','$euro','$dollar','$klinik_id')");
$faturidd = mysql_insert_id();
$emri_pacientit = mysql_fetch_array(mysql_query("SELECT emri FROM pacient where id='$recet_id' AND klinik_id = '$klinik_id'"));
echo "<script>$('#nrfatures').html('".$faturidd."');</script>";echo "<script>$('#emri_pacientit').html('".$emri_pacientit['emri']."');</script>";
$zgjidh=mysql_query("SELECT * FROM sales_order WHERE invoice= '$_SESSION[userid]-$recet_id' AND tipi = 'Doktor'    AND klinik_id = '$klinik_id'");
while($zgjidhrow = mysql_fetch_array($zgjidh)){
$produkti_monedh = mysql_fetch_array(mysql_query("select monedha from produkte where id = '$zgjidhrow[product]'    AND klinik_id = '$klinik_id'"));
if($produkti_monedh['monedha'] =="$"){$tot=(($zgjidhrow['price'] * $kursi["usd"]) * 100) * $zgjidhrow["qty"];}elseif($produkti_monedh['monedha'] =="€"){$tot=(($zgjidhrow['price'] * $kursi["euro"]) * 100) * $zgjidhrow["qty"];}else{$tot=$zgjidhrow['price']  * $zgjidhrow["qty"];}
$tek_dollar = ($tot / 100) / $kursi["usd"];
$tek_euro = ($tot / 100) / $kursi["euro"];
mysql_query("INSERT INTO  `produkte_te_shitura`(`produkt_id`, `pacient_id`, `user_id`, `doktor_id`, `data`, `sasia`, `skonto`, `arka`,
`shitur_nga`, `cmimi`, `recete_id`, `fature_id`, `metoda_pageses`,`total_skonto`,`monedha`,`euro`,`dollar`,`klinik_id`) VALUES('$zgjidhrow[product]','$recet_id', '0','$doktori_qe_ka_hedhur_ne_sistem','$dt_a',
'$zgjidhrow[qty]','$sko','1','$tipi + Arka','$tot','$rec_r_id',' $faturidd','$metoda_pageses','$total_skonto','$monedha','$tek_euro','$tek_dollar','$klinik_id')");
$ing=mysql_query("SELECT * FROM ingredientet WHERE produkt_id= '$zgjidhrow[product]' AND klinik_id = '$klinik_id'");
while($ingreditnt = mysql_fetch_array($ing)){
if($ingreditnt["njesia"] !="Copë"){ $assssdd = "0.".$ingreditnt['sasia']; }else{  $assssdd = $ingreditnt['sasia']; }
$asas = $ingreditnt["sasia"] * $zgjidhrow["qty"];
mysql_query("INSERT INTO  `produkte_te_shitura`(`produkt_id`, `pacient_id`, `user_id`, `doktor_id`, `data`, `sasia`, `skonto`, `arka`,
`shitur_nga`, `cmimi`, `recete_id`, `fature_id`, `metoda_pageses`, `dorezuar`, `shenime`,`dhembet`,`tipi`,`total_skonto`,`monedha`,`euro`,`dollar`,`klinik_id`) VALUES('$ingreditnt[ingredient_id]','$pacientii','0','$doktori_qe_ka_hedhur_ne_sistem','$dt_a',
'$assssdd','$sko','1','$tipi','0','$recet_id',' $faturidd','$metoda_pageses','$dt_ora','Ingredient - $asas $ingreditnt[njesia]','$zgjidhrow[dhembet]','Ingredient','$total_skonto','$monedha','0','0','$klinik_id')");
$inasdasd = mysql_fetch_array(mysql_query("SELECT sasi_recepture,shitur_heren_e_fundit,masa,sasia from produkte where id = '$ingreditnt[ingredient_id]'    AND klinik_id = '$klinik_id'"));
$asdwaeqwe = $inasdasd["shitur_heren_e_fundit"] + $asas;$zbrit_sasine="";
$masa = $inasdasd["masa"];
if($ingreditnt["njesia"] !="Copë"){if($asdwaeqwe >= $masa){ $mbetja = $asdwaeqwe - $masa; $zbrit_sasine = " ,`sasia` = `sasia` - '$zgjidhrow[qty]'";}else{ $mbetja = $asdwaeqwe; } }else{ $asas = $ingreditnt['sasia'] * $zgjidhrow["qty"]; $mbetja = ($masa * $ingreditnt['sasia']) * $zgjidhrow["qty"]; $zbrit_sasine = " ,`sasia` = `sasia` - '$asas'";}
mysql_query("UPDATE `produkte` SET `sasi_recepture` = `sasi_recepture` - '$asas', `shitur_heren_e_fundit` = '$mbetja' $zbrit_sasine where id = '$ingreditnt[ingredient_id]' AND klinik_id = '$klinik_id'");
}
echo mysql_error();} mysql_query("DELETE FROM sales_order where invoice='$_SESSION[userid]-$recet_id' AND tipi = '$tipi' AND klinik_id = '$klinik_id'");} ?>
<?php if(isset($_POST["recet_id"]) && isset($_POST["printo"]) && $_POST["tipi"] == "Perpunimi"){ $sql = mysql_query("UPDATE receta_pacientesh set perpunimi = '1', ora_perpunimit = now() WHERE id = '".preg_replace('#[^0-9]#', '',$_POST["recet_id"])."' AND klinik_id = '$klinik_id'"); exit(); }elseif(isset($_POST["recet_id"]) && isset($_POST["printo"]) && $_POST["tipi"] == "Arka"){$sql = mysql_query("UPDATE receta_pacientesh set arka = '1', arka_par = '1', ora_posit = now() WHERE id = '".preg_replace('#[^0-9]#', '',$_POST["recet_id"])."' AND klinik_id = '$klinik_id'"); exit(); } ?>
<style>.chosen-container { background: white; width:100% !important;} </style>

Batal

⬅ Naik ke login 12 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘check.php	php	645 B	2017-12-06 12:40	✏️ Edit 👁️ View
🐘check_and_send_sms.php	php	10 KB	2018-10-20 21:43	✏️ Edit 👁️ View
🐘check_and_send_sms_urimi.php	php	2.9 KB	2018-04-12 01:00	✏️ Edit 👁️ View
🐘connect.php	php	368 B	2018-04-09 01:13	✏️ Edit 👁️ View
🐘db_conx.php	php	299 B	2018-11-20 20:14	✏️ Edit 👁️ View
🐘dbconnect.php	php	3 KB	2023-03-23 13:59	✏️ Edit 👁️ View
🐘dental_pos.php	php	109.9 KB	2023-03-23 14:57	✏️ Edit 👁️ View
🐘image_resize.php	php	1.5 KB	2017-12-06 12:40	✏️ Edit 👁️ View
🐘model_posi.php	php	31.6 KB	2023-02-04 19:59	✏️ Edit 👁️ View
🐘savesales.php	php	50.9 KB	2023-02-04 19:54	✏️ Edit 👁️ View
🐘smsGateway.php	php	2.9 KB	2018-05-14 14:36	✏️ Edit 👁️ View
🐘status.php	php	3.1 KB	2018-12-06 22:38	✏️ Edit 👁️ View